home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc = "["Failed to yield", "Inattention"]", intersection = 0 and "retrieved" is on date 2020-10-06

✎ 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:
2000000266
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:
report
Image url:
image
Latitude:
42.3174679
Longitude:
-71.2256788
Location:
926 Chestnut St, Waban, MA 02468, USA
Case number:
2000000415
Date:
2020-07-30
Time:
14:30
Address:
380 WATERTOWN ST
Speed limit:
25
Violation cited:
no
Narrative:
On July 30, 2020, while on patrol in marked unit N525, I responded to a 2 car MVA in front of 380 Watertown Street, Newton. The weather at the time of the crash was clear and sunny. The road surface was dry. Watertown Street is a public way maintained by the City of Newton. The operator of MV1, Joseph Vara (S27929046), stated he was operating his 2006 Ford dump truck (MA CON: V42297) East on Watertown Street. Vara stated as he was traveling past 380 Watertown Street, MV2 attempted to merge into his lane from a parking spot on the roadway it's front driver side crashed into the rear passenger side tire area of his vehicle. Vara reported no injuries. I observed damage to the outer rear passenger tire of MV1. The operator of MV2, Willis Herlihy (S63431207), stated his vehicle, a 2010 Toyota Avalon (MA: AG2122) was parked in front of 380 Watertown Street. Herlihy stated as he was exiting the parking spot, he looked back and did not see any traffic. Herlihy stated as he merged into the travel lane the front passenger side of his vehicle crashed into the rear driver side tire area of MV1. Herlihy reported no injuries. I observed damage to the front end of MV2. MV2 was removed from the roadway by Tody's Towing.
Keywords:
Crash, Solar
Dcc:
Failed to yield, Inattention
Report url:
report
Image url:
image
Latitude:
42.3603603
Longitude:
-71.2014192
Location:
380 Watertown St, Newton, MA 02458, 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 682.141ms