crash_reports
3 rows where dcc contains "Failed to yield", intersection = 0 and keywords contains "Severe"
This data as json, CSV (advanced)
Suggested facets: violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-10
Time:
10:36
Address:
2102 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On 12/10/2019 at approx 1036hrs while assigned to 497 i responded to the area of 2102 Commonwealth Av for a report of a 2 car crash. upon arrival I observed Ma Reg V10183 a red Ford F150 pick up with front plow partially on the curb blocking the EB lane of Commonwealth Ave and Ma Reg 8PE124 a black Ford Focus pulled off to the side WB with extensive front end damage. I spoke with the operator of the pick up, Leonardo TAPIA who stated he had been travelling WB on Commonwealth Av when the Ford Focus pulled out in front of him causing the collision. I spoke to the operator of the Ford Focus John KELLY who stated he was taking a left out of the parking lot of 2102 Commonwealth Av, traffic in the EB lanes stopped to let him out, as he was entering the WB lane he collided with the pick up. Ford Focus towed by Todys, both operators signed refusals with Cataldo.
Keywords:
Crash, Severe
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3477264
Longitude:
-71.2477463
Location:
Case
number:
Date:
2020-01-23
Time:
18:11
Address:
966 WATERTOWN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 1/23/19 while working N493, I responded to 966 Watertown St for an MVA, car into a building. Business name is TIEM. The operator (operator #1) was the sole occupant of the vehicle (MA reg 4PW429, now known as vehicle #1). I was able to obtain a statement from operator #1 while medics and fire were en route. Operator #1 told me that she was driving eastbound on Watertown St when vehicle #2 (MA reg 1BSN69) pulled out to take a left from the Shell Gas Station at 979 Watertown St. Operator #1 had to swerve to the right in order to avoid a collision with vehicle #2. This caused vehicle #1 to crash into the exterior brick wall of 966 Watertown St. There was airbag deployment and visible structural damage to the business, however it did not appear severe. The operator of vehicle #2 was still on scene and confirmed the events that operator #1 spoke of. Operator #2 stated she did not see vehicle #1 as she was pulling out due to heavy traffic flow and parked cars. Vehicle #2 did not make contact with any other car or structure. Vehicle #1 sustained heavy front end damage and was towed by Tody's. Operator #1 was checked out by the medics but declined transport. The owner of the business affected was notified and responded to the scene. He was provided this report number for insurance purposes. No emergency accomodations or notifications needed be made in regards to the damage. It should be noted that a witness remained on scene and verified what operator #1 said transpired. His contact information was provided and is listed in the appropriate field, along with the business owner info for TIEM. Operator #2 was issued in hand MA citation T2079187 and sent on her way.
Keywords:
Airbag, Bus, Citation, Crash, Fire, Severe
Dcc:
Failed to yield, Unknown
Report
url:
Image
url:
Latitude:
42.3497612
Longitude:
-71.2246356
Location:
Case
number:
Date:
2020-12-03
Time:
15:28
Address:
1175 WALNUT STREET
Speed
limit:
25
Violation
cited:
yes
Narrative:
Operator of MV1 states he was parked at the meter spot in front of 1175 Walnut Street when he went to merge onto Walnut Street southbound. MV2 struck his front bumper with the right side of her vehicle. Operator of MV1 states he spoke with the operator of MV2 who stated to him she didn't see him merging onto Walnut Street because she was on her cell phone. MV1 sustained damage to the front bumper. Operator of MV2 states she was traveling southbound on Walnut Street and struck MV1 when he was merging into traffic. I asked the operator of MV2 if she was on her cell phone, which she first denied, but admitted to having the cell phone in her hand. MV2 sustained extensive damage to the right side of the vehicle and needed to be towed, which was removed from the roadway by Tody's towing. The operator of MV2 was queried and had an expired license. Massachusetts uniform citation #T2012863 was issued to the operator of MV2 for MGL Ch. 90 Sec. 10 Operating MV w/o a license and MGL Ch. 90 Sec. 13B Use of Electronic Device. No injuries were reported on scene.
Keywords:
Citation, Phone, Severe
Dcc:
Failed to yield, Distracted
Report
url:
Image
url:
Latitude:
42.3214071
Longitude:
-71.2062807
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "crash_reports" ( [case_number] TEXT PRIMARY KEY, [datetime] TEXT, [date] TEXT, [time] TEXT, [address] INTEGER, [street1] TEXT, [street2] TEXT, [intersection] INTEGER, [speed_limit] INTEGER, [hit_run] INTEGER, [violation_cited] INTEGER, [narrative] TEXT, [keywords] TEXT, [dcc] TEXT, [dcc_code] TEXT, [report_url] TEXT, [image_url] TEXT , [geocoded_address] TEXT, [latitude] TEXT, [longitude] TEXT, [manual_geocode] INTEGER, [retrieved] TEXT);