crash_reports
2 rows where keywords contains "Rain" and "retrieved" is on date 2022-04-21
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-04-01
Time:
08:14
Address:
CRAFTS ST & WALTHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday April 1st 2022 at approximately 0814 I responded to Crafts Street and Waltham Street for a minor motor vehicle accident involving a City of Newton DPW vehicle. At the time of the accident the weather was rainy and the road surface was wet. Crafts Street and Waltham Street are both owned and maintained by the City of Newton. The operator of the city vehicle (MV1) identified as Rodolfo Marquez stated he was stopped at the red light on Waltham Street at Crafts Street waiting to go straight onto Harding Street. Marquez stated he was struck from behind by MV2. Minor damage was reported from the rear passenger side corner of the trailer that was attached to the city vehicle. The operator of MV2 identified as Theodore Tsacoyianis stated he was behind MV1 on Waltham Street and was trying to take the right onto Waltham Street and struck the corner of the trailer. Minor damage to the front drivers side was reported. Pictures of the damage to both vehicles were taken and submitted to the IT Bureau. No injuries were reported.
Keywords:
Crash, Pictures, Rain
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3602838
Longitude:
-71.2220498
Location:
Case
number:
Date:
2022-04-08
Time:
12:30
Address:
36 GLEN AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Friday April 8, 2022 at approximately 1230 hours I was dispatched to 36 Glen Ave for a single car MVA into a stone wall. The sky was clear at this time of day but the roads were wet due to a previous rain storm. Witness stated MV1 was operating southbound on Glen Ave (public way) prior to 36 Glen Ave at approximately 40mph. Be advised the speed limit of Glen Ave is 25mph. Witness said MV1 crossed into the northbound lane, and operated through the driveway entrance and into the stone wall belonging to Glen Ave Association. Witness stated there were no other MVs on the road at this time and they were unsure if MV1 operator was on their cellphone while driving. Witness stated MV1 operator crawled out from the vehicle and there were no one else involved or in the car. MV1 sustained heavy and extensive front end damage, and was towed by Todys. MV1 operator stated they only had chest pains, and was not suffering from any head or neck injury at this time. Due to the nature of the incident and quick response by Newton Medics, I was unable to speak to MV1 operator, who was transported to Newton-Wellesley Hospital. I was able to speak to an employee of Glen Ave Association and advised them of the incident. The employee was the manager and they stated the damage to their stone wall was approximately $5,000 USD, and their telephone extension was x200. The employee was given the accident report number.
Keywords:
Crash, Hospital, Rain, Severe, Speed
Dcc:
Too fast for conditions, Inattention
Report
url:
Image
url:
Latitude:
42.3299883
Longitude:
-71.186118
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);