home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where keywords contains "Airbag" and longitude = "-71.2477866"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
22000318
Date:
2022-04-19
Time:
07:33
Address:
2014 WASHINGTON ST
Speed limit:
25
Violation cited:
no
Narrative:
on 04/19/2022@0733hrs. I responded to 2014 Washington St. @ the entrance to Newton Wellesley Hospital for an MVA. On location I observed the two involved vehicles parked curbside along the westbound side of Washington st directly across from the NWH entrance. V1; 2014 Honda/CR-V Util. color black. V1 Operator Marie Leandre TN OLN#127777292. V2; 2021 KIA/Seltos Util. color blue. V2 Operator Robin McDuffie MA OLN#S71750988. V1 was attempting to turn left to exit NWH heading westbound. The traffic signals at the time were on flash red &yellow instead of normal red, green and yellow. The morning commute traffic on Washington St. is heavy at that time of the morning. V1 operator stated she was waved on by the vehicle operator in the turning lane on the westbound side. V1 proceeded to turn left/westbound onto Washington St. and collided into the driver's side of V2 travelling straight ahead westbound in the outside//32 lane of Washington St. ( westbound). V1 Operator stated she did not see V2. V2 confirmed V1 operator's account of the collision. V2 operator also confirmed the traffic lights were on flash red/yellow. Neither operator was injured as a result of the collision nor was there airbag deployment in either vehicle. Neither vehicle requried towing service.
Keywords:
Airbag, Hospital
Dcc:
Visibility obstructed
Report url:
report
Image url:
image
Latitude:
42.3306679
Longitude:
-71.2477866
Location:
2014 Washington St, Newton, MA 02462, USA
Case number:
22000436
Date:
2022-05-22
Time:
19:34
Address:
2014 WASHINGTON ST
Speed limit:
35
Violation cited:
no
Narrative:
The operator of MV1 was traveling north on Washington street when she attempted to switch lanes crossing into MV2's lane of travel. MV2 then struck MV1 immobilizing both vehicles. MV1 sustained damage to the drivers side of the vehicle. MV2's drivers side airbags deployed. MV2 sustained damage to the front and passenger side of the vehicle. The operator of MV1 was transported to Newton Wellesley Hospital by Fallon Ambulance Service. The operator and both passengers of MV2 signed patient refusals. Both MV1 and MV2 were towed from the scene by Tody's.
Keywords:
Airbag, Ems, Hospital
Dcc:
Inattention
Report url:
report
Image url:
image
Latitude:
42.3306679
Longitude:
-71.2477866
Location:
2014 Washington St, Newton, MA 02462, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 299.768ms