crash_reports
2 rows where dcc = "["Too fast for conditions", "Inattention"]" and keywords contains "Rain"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-10-27
Time:
08:07
Address:
CHERRY ST & DERBY ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday October 27, 2021 at approximately 0807 hours I responded to Cherry St at Derby St (both public ways) for a two car motor vehicle accident. Be advised at this time the weather was very rainy and cloudy, and the roads were covered in leafs and were wet. MV1 was operating on Cherry St northbound by the Derby St intersection behind MV2. MV1 operator stated he stopped as the intersection traffic light was turning yellow. MV1 operator stated he stopped with at least one car length between his MV at the intersection. MV1 operator stated MV2 continued halfway through the intersection but stopped as the light was turning yellow. MV1 operator stated after MV2 stopped in the middle of the intersection, it reversed backwards and struck his MV. MV1 sustained extensive front end damage and was towed by Todys. MV1 operator reported no injuries at this time. MV2 operator stated she was on Cherry St northbound at the Derby St intersection. MV2 operator stated when the intersection traffic lights turned yellow she stopped in the middle of the intersection, and put her MV in reverse. MV2 operator stated because of the slippery and wet road conditions, her MV reversed too quickly and slid, striking MV1 which was already stopped behind her. MV2 sustained minor rear end damage and did not require a tow. MV2 operator reported no injuries at this time,
Keywords:
Crash, Rain, Severe
Dcc:
Too fast for conditions, Inattention
Report
url:
Image
url:
Latitude:
42.3574786
Longitude:
-71.22748
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);