crash_reports
3 rows where dcc = "["Too fast for conditions"]", intersection = 0 and keywords contains "Speed"
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-02-01
Time:
15:35
Address:
15 CYPRESS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/1/19 I was working N496 when I responded to a 2 car MVA at 15 Cypress St. with a road rage incident ( incident # 19004330). Upon arrival I spoke with Edward Macaleese. Macaleese stated MA reg 2EE232 (being operated by Fabian Castillo) was tailgating him while traveling southbound on Cypress St. so he pulled to the side to allow him to pass. After Castillo passed Macaleese he slammed on his brakes causing Macaleese to rear end Castillo. I spoke with Castillo who stated that he was traveling southbound on Cypress St. when the vehicle in front of him (Macaleese) began driving "much slower than the speed limit". Castillo stated the Macaleese pulled over to allow him to pass, after Castillo began to slow in traffic due to a vehicle pulling out. Macaleese struck Castillo from behind. Both parties stated they were not injured. Both vehicle were still drive able. Both parties were provided an accident report number.
Keywords:
Crash, Speed
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3285638
Longitude:
-71.1951188
Location:
Case
number:
Date:
2020-02-13
Time:
17:56
Address:
199 BOYLSTON ST
Speed
limit:
5
Violation
cited:
no
Narrative:
The operator of MV#1 stated she was driving around MV#2 as it was parked outside the establishment. As MV#1 passed, the driver side door of MV#2 opened creating a collision. MV#1 sustained significant damage to its front end as well as passenger side door. MV#2's driver side door sustained significant damage. No injuries were reported and MV#1 was able to be driven away from the scene, while MV#2 arranged for a private tow. A witness to the collision reports MV#1 was driving at a high rate of speed as it drove around MV#2.
Keywords:
Speed
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3215125
Longitude:
-71.1756718
Location:
Case
number:
Date:
2021-06-27
Time:
14:06
Address:
275 DUDLEY RD
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 06/27/21 at approximately 14:06 I responded across from #295 Dudley Rd. for a single vehicle crash.When I arrived I witnessed Veh#1 was on its drivers side resting against pole #34. The operator was already out of the car sitting on the stone wall next to it. The Operator of veh #1 stated he was driving due North on Dudley Rd. driving the speed limit when he saw a jogger (witness #2) in his lane. He then swerved into the left lane when he saw an oncoming car. He then swerved back to the right and rolled his vehicle coming to rest beside Eversource Pole #34. The vehicle was towed by Tody's towing. The operators father showed up on scene before he signed a patient refusal to go to the hospital. Father stated he would take his son later by car to have his right forearm checked out because of airbag rash. Operator of veh #1 cited in hand Mass. #T2080856 for Ch 90/ Sec 17 Speeding estimated 50mph in a 25 Zone.
Keywords:
Airbag, Citation, Crash, Hospital, Speed
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3123404
Longitude:
-71.1818448
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);