crash_reports
5 rows where "datetime" is on date 2022-05-25 and "retrieved" is on date 2022-05-31
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, hit_run, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2022-05-25
Time:
07:52
Address:
BEACON ST & WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of MV1 states he was traveling on Beacon Street somewhere in the area by Walnut Street when a green garbage truck (unknown make, model or registration plate) backed into his companies work truck and damaged the front windshield. Operator of MV1 states he doesn't think the operator of the garbage truck knew he struck MV1 and left the scene. Operator of MV1 will be contacting his employer for a private tow. No injuries.
Keywords:
[]
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3308369
Longitude:
-71.2070206
Location:
Case
number:
Date:
2022-05-25
Time:
08:41
Address:
2140 COMMONWEALTH AVENUE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday, May 25, 2022, while assigned to unit N493, I responded to the area of 2140 Commonwealth Avenue, Newton for a motor vehicle crash. The weather at the time of the crash was clear and sunny. The road surface was dry. Commonwealth Avenue is a public way maintained by the City of Newton. The operator of MV1, Mr. Pouya Jalili (S24275452), stated he was operating his 2019 Honda CR-V (MA: 1NPG25) on Commonwealth Avenue (E) near Melrose Street. Mr. Lalili stated as he was coming around a bend in the road, a vehicle in front of him has entered his travel lane from their driveway and was attempting to cross Commonwealth Avenue. Mr. Lalili stated he beeped his horn and swerved to the left to try and avoid the collision. MV1's from driver side crashed into the from driver side of MV2. MV1 had damage to it's front end and was removed from the roadway by Tody's towing. Mr. Lalili reported no injuries. The operator of MV2, Ms. Brianna Cataldo (S24925616), stated she was attempting to cross Commonwealth Avenue from her driveway while operating her 2018 Hyundai Elantra (MA: 7XB298). Ms. Cataldo stated while exiting her driveway, she stopped before entering to roadway to allow traffic to clear to her right and left. Ms. Cataldo stated she looked to her left for some time and did not observe any vehicles traveling towards her. Ms. Cataldo stated she proceeded to enter Commonwealth Avenue and make her left turn to travel Westbound. Ms. Cataldo stated she then heard a beep and MV1 was in the Westbound lane, crashing into the front of her vehicle. Ms. Cataldo stated she did not see the vehicle until it was too late. I observed damage to the front end of MV1. Ms. Cataldo reported no injuries.
Keywords:
Crash, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3477865
Longitude:
-71.2493678
Location:
Case
number:
Date:
2022-05-25
Time:
12:09
Address:
WALNUT ST & WATERTOWN ST
Speed
limit:
25
Violation
cited:
no
Narrative:
oper #1 stated he was turning right from Walnut onto Watertown Street when he took out the traffic lights on the corner. Dagle was contacted to fix light pole. Pictures taken and sent to IT. No damage to truck.
Keywords:
Pictures
Dcc:
Improper turn
Report
url:
Image
url:
Latitude:
42.3558631
Longitude:
-71.2090326
Location:
Case
number:
Date:
2022-05-25
Time:
18:20
Address:
15 CYPRESS ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 and MV#2 were traveling south on Cpyress St. MV#1 stopped for a pedestrian in the cross walk. MV#2 did not stop in time and crashed into MV#1. Operator of MV#1 stated that when he stopped for the pedestrian, MV#2 crashed into him. Operator of MV#2 stated that his reaction time was not quick enough when he observed MV#1 stop, causing him to crash into MV#1. No injuries occurred. Both vehicles were driven off scene.
Keywords:
Crash, Ped, Walk
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3285638
Longitude:
-71.1951188
Location:
Case
number:
Date:
2022-05-25
Time:
18:31
Address:
WALNUT ST & WASHINGTON ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
The operator of MV#1 stated he was traveling eastbound on Washington St. through the intersection of Walnut St. The operator of MV#1 stated he had a "green" signal as he proceeded through the intersection. The Operator of MV#1 stated his vehicle was struck at an angle by MV#2. A witness to the accident confirmed MV#1 had a "green" signal while MV#2 had a "red" signal. The operator of MV#2 stated he was unsure what color signal he had as he traveled south on Walnut St. through the intersection of Washington St. Damage to both vehicles were consistent with a "T-bone" collision. No injuries were reported. Both vehicles were driven from the scene. The Operator of MV#2 was cited.
Keywords:
Citation, Crash
Dcc:
Signs/Signals
Report
url:
Image
url:
Latitude:
42.3274246
Longitude:
-71.2532573
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);