crash_reports
4 rows where dcc contains "Followed too closely", intersection = 0 and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: speed_limit, keywords, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-18
Time:
09:29
Address:
1830 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
ON 1/18/2019 AT APPROX 0929HRS WHILE ASSIGNED TO 497 i RESPONDED TO THE AREA OF 1830 BEACON ST FOR A REPORT OF A TWO CAR COLLISION WITHOUT INJURY. UPON ARRIVAL I OBSERVED BOTH VEHICLES IN THE ROADWAY WITH UNDER RIDE , FLUIDS ALL OVER ROADWAY AND AIRBAG DEPLOYMENT IN THE REAR VEHICLE. BOTH OPERATORS WERE STANDING ON THE SIDEWALK. I SPOKE WITH THE OPERATOR OF MA DEALER REG 5550 MARISSA DEVLIN WHO STATED SHE HAD STOPPED FOR A PEDESTRIAN IN THE CROSSWALK WHEN SHE WAS STRUCK FROM BEHIND. I THAN SPOKE WITH THE OPERATOR OF MA PASSENGER REG 3NM859, THOMAS DORRANCE WHO STATED ' IT APPEARS I'M AT FAULT' DORRANCE STATED HE HAD NOT NOTICED DEVLIN SLOWING AND STOPPING AND RAN INTO THE BACK OF HER. DEVLIN WAS ALSO COMPLAINING OF PAIN FROM THE STEERING WHEEL AND AIRBAG, CATALDO RESPONDED. NFD AND TODYS TOW ARRIVED ON SCENE .NFD USED THE JAWS TO SEPARATE THE TWO VEHICLES TODYS WAS ABLE TO TOW BOTH VEHICLES. DORRANCE SIGNED A PATIENT REFUSAL WITH CATALDO. NFD SPREAD SPEEDY DRY AND CLEARED THE ROADWAY.
Keywords:
Airbag, Crosswalk, Fire, Ped, Speed
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3273334
Longitude:
-71.2389513
Location:
Case
number:
Date:
2019-11-25
Time:
20:05
Address:
300 WASHINGTON ST
Speed
limit:
40
Violation
cited:
no
Narrative:
MV 1 was changing lanes northbound from the far left lane to the second lane when he rear ended MV 2. All air bags were deployed on all sides to MV 1 and it was towed away by Tody's due to it being disabled on a public way. MV 2 was traveling straight Northbound in the second lane when MV 1 rear ended him. MV 2 was towed due to it being disabled on a public way. Newton Fire Department responded with Cataldo ambulance due to air bags being deployed. There were no injuries to either party. Both parties were advised with crash report numbers.
Keywords:
Crash, Ems, Fire
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3567319
Longitude:
-71.1859798
Location:
Case
number:
Date:
2020-08-19
Time:
13:31
Address:
195 CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator #1 stated he was stopped in traffic, S/B on Craft St by the Fire Station, #197 Craft St when he was rear ended by vehicle #2. Operator #2 stated she was behind MV#1 on Craft St when she reported MV#1 stopped in front of her. She was unable to stop before crashing into the rear of his MV. There were no injuries due to this accident and vehicle #2 was towed by Todys due to damage.
Keywords:
Crash, Fire
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3570417
Longitude:
-71.2070929
Location:
Case
number:
Date:
2022-06-02
Time:
18:13
Address:
141 NEEDHAM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
At approximately 1810HRs on Thursday, June 2, 2022, I responded to 141 Needham Street with The Newton Fire Department for a two car crash with minor injuries. Upon arrival, I observed both vehicles in front of the aforementioned address. MV1 (MA Pass: 1HPG40) had damage to its rear end (lift gate, bumper cover, marker lights and license plate). MV2 had damage to its front end (hood, headlights, radiator core support, bumper, fenders and windshield), both air bags were deployed and it was leaking fluid. Upon speaking to the operator of MV1, they stated they were traveling straight ahead when they slowed their vehicle down and MV2 drove into the rear of it. Upon speaking to the operator of MV2, they stated MV1 decelerated and they did not have time to stop, causing them to drive into the rear of MV1. All parties involved signed patient refusals. NFD cleaned up the leaked fluid. Tody's Services removed MV2 from the roadway and MV1 drove away under its own power. I completed and filled an NPD Towed Motor Vehicle Form.
Keywords:
Crash, Fire
Dcc:
Followed too closely
Report
url:
Image
url:
Latitude:
42.3131214
Longitude:
-71.212987
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);