crash_reports
2 rows where dcc = "["Failed to yield", "Inattention"]" and keywords contains "Airbag"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-04-17
Time:
08:18
Address:
926 CHESTNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
Mv#1 operator stated she came to a stop at the stop sign on the Boylston St E/B access ramp at the intersection of Chestnut St. #1 stated she proceeded straight across into the intersection at which time #1 struck Mv#2 that was travelling on Chestnut St N/B. After impact, #1 crashed to the left into the bushes and yard of 926 Chestnut St. The impact also pushed #2 to the right into the same bushes. #2 operator stated she was travelling on Chestnut St N/B (right of way) and was about to clear the intersection when #1 suddenly appeared from her left and struck #2 broadside (driver's side). #1 operator had pain on the left side of her body and #2 had chest pain from striking her steering wheel. Both were transported to NWH for further evaluation. #1 sustained heavy damage to the front end with multiple airbag deployment. #2 sustained heavy damage to the driver's side and front end. Both were towed by Tody's to their storage yard.
Keywords:
Airbag, Bus, Crash
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3174679
Longitude:
-71.2256788
Location:
Case
number:
Date:
2022-06-08
Time:
10:11
Address:
MARLBORO STREET & TREMONT STREEET
Speed
limit:
35
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED HE WAS TRAVELING WEST BOUND ON TREMONT STREET WHEN MV#2 BACKED OUT OF A DRIVEWAY AND STRUCK HIM. THIS CAUSED HIM TO THEN CRASH INTO A FENCE AT 4 MARLBORO STREET. THE OPERATOR OF MV#2 STATED SHE WAS BACKING OUT OF A DRIVEWAY WHEN SHE STRUCK MV#1. SHE STATED THAT MV#1 WAS SPEEDING. THE PROPERTY OWNER AT 4 MARLBORO STREET WAS ON SCENE AND AWARE OF THE PROPERTY DAMAGE. BOTH OPERATORS HAD CONFLICTING STATEMENTS BUT MV#1 HAD THE RIGHT OF WAY. BOTH VEHICLES WERE TOWED BY TODYS TOWING. BOTH OPERATORS APPEARED TO HAVE MINOR INJURIES AND WERE TRANSPORTED. THERE WAS AIRBAG DEPLOYMENT TO MV#1. BOTH VEHICLES HAD MAJOR DAMAGE.
Keywords:
Airbag, Crash, Speed
Dcc:
Failed to yield, Inattention
Report
url:
Image
url:
Latitude:
42.3524407
Longitude:
-71.1756664
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);