home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Failed to yield", intersection = 0 and "retrieved" is on date 2022-05-31

✎ 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:
22000423
Date:
2022-05-19
Time:
15:27
Address:
261 NAHANTON ST
Speed limit:
35
Violation cited:
no
Narrative:
Based on observations, and statements made, the following occoured. M/V#1 was attempting to pull out of 261 Nahanton St., and turn left (east) on Nahanton St. Traffic heading west on Nahanton St. was stopped, and provided enough room for M/V#1 to pull out. As it began to enter the eastbound lane the operator accelerated and was struck by M/V#2 which was travelling east in Nahanton. M/V#1 was then spun around, and struck M/V#3 which was stopped in traffic traveling west.
Keywords:
[]
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.2985028
Longitude:
-71.1989141
Location:
261 Nahanton St, Newton, MA 02459, USA
Case number:
22000446
Date:
2022-05-25
Time:
08:41
Address:
2140 COMMONWEALTH AVENUE
Speed limit:
25
Violation cited:
no
Narrative:
On Wednesday, May 25, 2022, while assigned to unit N493, I responded to the area of 2140 Commonwealth Avenue, Newton for a motor vehicle crash. The weather at the time of the crash was clear and sunny. The road surface was dry. Commonwealth Avenue is a public way maintained by the City of Newton. The operator of MV1, Mr. Pouya Jalili (S24275452), stated he was operating his 2019 Honda CR-V (MA: 1NPG25) on Commonwealth Avenue (E) near Melrose Street. Mr. Lalili stated as he was coming around a bend in the road, a vehicle in front of him has entered his travel lane from their driveway and was attempting to cross Commonwealth Avenue. Mr. Lalili stated he beeped his horn and swerved to the left to try and avoid the collision. MV1's from driver side crashed into the from driver side of MV2. MV1 had damage to it's front end and was removed from the roadway by Tody's towing. Mr. Lalili reported no injuries. The operator of MV2, Ms. Brianna Cataldo (S24925616), stated she was attempting to cross Commonwealth Avenue from her driveway while operating her 2018 Hyundai Elantra (MA: 7XB298). Ms. Cataldo stated while exiting her driveway, she stopped before entering to roadway to allow traffic to clear to her right and left. Ms. Cataldo stated she looked to her left for some time and did not observe any vehicles traveling towards her. Ms. Cataldo stated she proceeded to enter Commonwealth Avenue and make her left turn to travel Westbound. Ms. Cataldo stated she then heard a beep and MV1 was in the Westbound lane, crashing into the front of her vehicle. Ms. Cataldo stated she did not see the vehicle until it was too late. I observed damage to the front end of MV1. Ms. Cataldo reported no injuries.
Keywords:
Crash, Solar
Dcc:
Failed to yield
Report url:
report
Image url:
image
Latitude:
42.3477865
Longitude:
-71.2493678
Location:
2140 Commonwealth Ave, Auburndale, MA 02466, 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 407.251ms