crash_reports
5 rows where dcc contains "Visibility obstructed", intersection = 0 and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: speed_limit, hit_run, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-07-10
Time:
13:06
Address:
63 KENWOOD AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On 7/10/2019 at approx 1306Hrs while assigned to 497 I responded to 57 Kenwood St for a report of a vehicle backing into a gas light pole. Upon arrival I met with a worker for A Blade of Grass Landscaping Company, Taidy GONZALES. GONZALES stated she was backing her company truck into the driveway of 57 Kenwood Rd when she taped the gas light pole belonging to The City of Newton causing the glass globe to crack. NFD responded and turned the gas off.
Keywords:
Fire
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3356174
Longitude:
-71.2024286
Location:
Case
number:
Date:
2019-11-11
Time:
12:12
Address:
14 COOK ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 11-11-19 AT APPROX. 1212HRS. WHILE WORKING N492 I TOOK A REPORT FOR CITY MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 14 COOK ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS BACKING N-BOUND ON COOK ST. DRIVER SAW A BARREL IN HIS REAR VIEW. HE MANEUVERED HIS WAY AROUND THE BARREL BUT DID NOT SEE THE FIRE HYDRANT BEHIND IT UNTIL HE HAD HIT IT. VEHICLE #1 HAD LEFT END DAMAGE ON THE LEFT REAR BUMPER. DRIVER REPORTS NO INJURIES AND WAS ADVISED TO CONTACT HIS INSURANCE COMPANY. THERE WAS NO DAMAGE TO THE FIRE HYDRANT. I TOOK 4 PICTURES OF THE SCENE AND PLACED THE DISC WITH I.T.
Keywords:
Crash, Fire, Pictures
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.360667
Longitude:
-71.1985185
Location:
Case
number:
Date:
2020-05-16
Time:
10:01
Address:
281 NEWTONVILLE AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On May 16th, 2020 at approximately 10:01 hours while working N491 I responded to #281 Newtonville Ave for a reported single vehicle crash. While en route the reporting party stated the vehicle had left the scene. On my arrival I spoke with the R/P who stated while riding his bike down Newtonville Ave he observed a black colored landscaping pickup truck back out of Pillion Court onto Newtonville Ave and hit a fire hydrant across the Street. Its possible the driver never knew he struck the hydrant. The R/P never saw the driver or the license plate number. Fire department and water department were notified and were responding. Pictures were taken and later submitted to Technology Bureau.
Keywords:
Crash, Fire, Pictures
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3527856
Longitude:
-71.1984141
Location:
Case
number:
Date:
2021-01-21
Time:
19:51
Address:
2240 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
On 1/21/21 at approximately 1950 hours, I responded to 2240 Commonwealth Ave for a car into a tree with entrapment. On arrival, I observed MA reg 457RC6 into a tree. Firefighters used jaws of life to gain access to the operator. Operator stated he was driving westbound and his windshield was fogging up and could not see. He stated that he saw the oncoming traffic and swerved and hit the tree. The operator suffered minor injuries and was transported to Mass General. The vehicle was towed by Todys.
Keywords:
Fire, Tree
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3469166
Longitude:
-71.2536165
Location:
Case
number:
Date:
2022-03-24
Time:
11:24
Address:
371 WASHINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On March 24th, 2022 at approximately 11:24 hours while assigned to N491 I along with NFD and Fallon ambulance responded to the area of #371 Washington St, Honda Village for a report of a MV crash with injuries. On my arrival I located both involved vehicles on Washington St just west of Honda Village. Vehicle #1 was CT tag, C218244, 2020 White GMC 2500 Van with heavy front passenger side damage, operated by a Zachary Sabo He stated he was going W/B on Washington St when vehicle #2 exited out from Honda Village colliding with his vehicle. He further reported there was a large truck double parked W/B in front of Honda village in the non passing lane obstructing his view of vehicle #2 exiting Honda Village as well the view of vehicle #2 as she was attempting to exit out onto Washington St. Vehicle #2 was a 2019 Blue Honda CRV utility, Ma. reg, 4RF-585 with heavy front drivers side damage, operated by a Erin Ryan. Ms Ryan had sustained a head injury so I wasn't able to get a clear statement. She did remember a large truck obstructing her view as she attempted to exit Honda Village onto Washington St. The truck was already gone prior to police arrival. Nobody on scene or Honda Village employees could identify the truck. Both vehicles towed by Todys. Operator to vehicle #2 was transported to Saint Elizabeths Hospital with head and hip injuries.
Keywords:
Crash, Ems, Fire, Hospital
Dcc:
Visibility obstructed
Report
url:
Image
url:
Latitude:
42.3566681
Longitude:
-71.1889127
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);