crash_reports
4 rows where "retrieved" is on date 2021-11-16 and speed_limit = 35
This data as json, CSV (advanced)
Suggested facets: date, intersection, violation_cited, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-11-03
Time:
02:34
Address:
COMMONWEALTH AVE & CROSBY RD
Speed
limit:
35
Violation
cited:
yes
Narrative:
Upon arrival, vehicle 1 was rolled over and facing Eastbound in the Westbound lane. There was extensive damage all over the vehicle and it was leaking fluids. It appears that vehicle 1 was traveling Westbound on Commonwealth Ave and struck a tree and then crashed into the guard rail causing it to roll over. There was damage to a city tree and damage to the guard rail. Operator 1 stated (through translation from Officer Acuna), he was traveling Eastbound on Commonwealth Ave at approximately 25 MPH when he was looking at his GPS and his brakes gave out causing him to crash. When asked again, his story changed and he was not sure what direction he was traveling in. Newton Fire was able to retrieve operator 1's cell phone in the vehicle which was on a loop playing videos on instagram. Operator 1 was transported to Beth Israel Hospital by Fallon Ambulance. Tody's towed vehicle 1 and pictures were taken of the damage to city property and will be submitted to the IT Bureau to be attached to this report. Operator 1 was served in hand, Massachusetts Uniform Citation: T1445611 for the following: Ch. 89 s. 4A - Marked Lanes Violation Ch. 90 s.13B- Electronic Device Use While Operating a Motor Vehicle
Keywords:
Citation, Crash, Ems, Fire, Hospital, Phone, Pictures, Severe, Tree
Dcc:
Distracted
Report
url:
Image
url:
Latitude:
42.3372401
Longitude:
-71.1743446
Location:
Case
number:
Date:
2021-11-09
Time:
08:20
Address:
445 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED SHE WAS TRAVELING E/B ON WASHINGTON STREET WHEN SHE REAR-ENDED MV#2. THE OPERATOR OF MV#2 STATED SHE WAS STOPPED IN TRAFFIC WHEN SHE WAS REAR-ENDED BY MV#1. THERE WAS MAJOR FRONT-END DAMAGE TO MV#1 AND DAMAGED TO THE REAR END OF MV#2. MV#1 WAS TOWED BY TODY'S TOWING. THE OPERATOR OF MV#1 AND HER TWO PASSENGERS WERE TRANSPORTED TO NWH BY THE MEDICS FOR POSSIBLE INJURIES. MV#1 HAD FRONT AIRBAG DEPLOYMENT.
Keywords:
Airbag
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3559471
Longitude:
-71.1911042
Location:
Case
number:
Date:
2021-11-09
Time:
16:14
Address:
ALBEMARLE RD & WATERTOWN ST
Speed
limit:
35
Violation
cited:
yes
Narrative:
MV1 stated he was attempting to turn left from Watertown St onto Albermarle Rd when the drivers side rear end of his bus made contact with the drivers side of MV2 causing minor damage. Operator of MV1 stated he saw MV2 "stop at the yellow light, I looked around to make sure it was safe to go and then when I went forward, I saw she had now moved out in to the middle of the intersection and was stopped blocking traffic". MV2 stated she was travelling straight when she was struck by MV1 causing minor damage. Operator of MV2 was cited for Unlicensed Operation as well as causing gridlock. No injuries reported and no tows requried. Digital images of the scene were turned ove to the IT Bureau.
Keywords:
Bus, Citation
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.354018
Longitude:
-71.213976
Location:
Case
number:
Date:
2021-11-09
Time:
18:20
Address:
WASHINGTON ST & CONCORD ST
Speed
limit:
35
Violation
cited:
no
Narrative:
I responded to the intersection of Wahington Srt at Concord St for a two car MVA. I arrived on location and both of the involved MV's were stopped on Washington St. facing Westbound which was both vehicles direction of travel. V1 MA Reg. 4WF379 Toyt/Util 2019 color gray collided into the rear of V2 stopped at the traffic light. V2 MA Con Reg. P29356 Dodg/PU 2012 color black. Neither operator reported any injury. V1 operator appeared haken but was uninjured. V1 ustained moderate to heavy front end damage. V1 was towed from crash scene by Tody's towing. V2 had rear bumper damage but did not require towing service.
Keywords:
Crash, Moderate
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3253683
Longitude:
-71.2576928
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);