crash_reports
2 rows where dcc = "["Too fast for conditions"]", intersection = 0 and keywords contains "Hospital"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-06-27
Time:
17:42
Address:
210 NAHANTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On 6/27/20 at 1742 I responded with multiple units, NFD and medics for a report of a MVA with injuries on Nahanton St. Upon arrival I observed NH Reg 4539251 wrapped around Verizon utility pole 6/15 facing eastbound on Nahanton St. The operator and the passenger behind the operator were trapped inside the vehicle. The front right passenger was able to get out of the car. Multiple witnesses stated that the vehicle was traveling WB and when it came around the bend in the road the operator lost control and spun clockwise into the pole. The vehicle ultimately rested facing the direction it came from, eastbound. NFD responded and was able to free the remaining two passengers from the vehicle. All passengers were transported to Beth Israel Boston for treatment. While on scene, I spoke with the passenger from the front seat who stated they were traveling westbound towards Needham and the operator just lost control around the bend due to the wet surface. There were no other vehicles involved in the accident, Tody's responded to tow the vehicle. Verizon was notified of their utility pole being damaged. Pictures were taken of the scene and turned over to IT to be uploaded to this report. I responded to the hospital to follow up with the occupants but was only allowed to speak with the passengers and not the operator as he was in critical condition with a broken femur and head injuries. The rear passenger stated that he didn't think his son, the operator, was going that fast but he lost control around the bend, he was suffering from neck pain and is in fair condition. The passenger in the front seat suffered minor/unknown leg injuries but hospital staff believed he would be discharged tonight.
Keywords:
Crash, Fire, Hospital, Pictures
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.2969814
Longitude:
-71.1958963
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);