crash_reports
2 rows where keywords contains "Rain" and "retrieved" is on date 2022-01-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-01-17
Time:
05:30
Address:
1053 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
MV 1 was traveling straight eastbound on Washington St when he began to spin out due to the icy rainy conditons of the road. MV spun out into a 360 degree circle and collisoned its rear left side with a light pole on the side of Washington St. The operator of MV 1 was not injured. MV 1 sustained major damage to the entire rear of the vehicle and disabled it. The light pole sustained major damage and had to be removed by Dagle. MV 1 was towed by Tody's due to it being disabled on a public way.
Keywords:
Ice, Rain
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3504361
Longitude:
-71.2164445
Location:
Case
number:
Date:
2022-01-20
Time:
08:32
Address:
1446 BEACON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On Thursday, January 20, 2022, while assigned to Traffic unit N525, I responded to the area of 1446 Beacon Street, Newton for a report of an MVA involving a City of Newton contracted school bus. The weather at the time of the crash was light rain. The road surface was wet. Beacon Street is a public way maintained by the City of Newton. I spoke with the operator of MV1, Mr. Ralph Ghera (S43446773). Mr. Ghera stated he is a driver for JSC Transportation (contracted by the City of Newton) and was picking up a student to transport them to Newton South High School. Mr. Ghera stated his vehicle, a 2019 Ford Transit Van (MA SPN: 109403 ), was parked in front of Beacon Street (E) with it's red flashing lights activated while Ms. Ella Glennon was entering the vehicle for transport. At this time, MV2 (2020 Lincoln Aviator (MA: 3AB494) travelled past MV1 Eastbound on Beacon Street and disregarded the flashing lights that were activated on the van. MV2's front passenger side door mirror made contact with MV1's front driver side door mirror. I observed very minor damage to the mirrors on both vehicles. No injuries were reported. I spoke with Ella's father, Ian Glennon, on scene and made him aware of his daughters involvement in the crash. Mr. Glennon stated his daughter was not injured. Ella was then transported to Newton South by Mr. Ghera. The operator of MV2, Mr. Yipei Zhang (S13848781), was issued Massachusetts Uniform Citation 265793AB in hand for Chapter 90, Section 14 (Fail to stop for a school bus). Photos were taken and submitted to the IT Bureau.
Keywords:
Bus, Citation, Crash, Pictures, Rain, School
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3294623
Longitude:
-71.2231274
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);