crash_reports
3 rows where dcc = "["Failed to yield"]", intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-06-18
Time:
08:32
Address:
17 CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV#1 was traveling east-bound on Crafts St when it was struck by MV#2 pulling out of the Whole Foods parking lot. MV#1 rolled over and the operator was trapped for a short amount of time. Sgt. Chisholm got Operator #1 out of the vehicle. MV#1 also took down a no parking sign. Traffic took pictures. The operator of MV#1 had minor injuries but signed a refusal after being treated on scene. MV#1 had major damage all over. MV#2 had front end damage. The operator of MV#2 signed a refusal as well and was able to drive his vehicle away from the accident. MV#1 was towed by Tody's towing.
Keywords:
Crash, Pictures
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3545196
Longitude:
-71.1995511
Location:
Case
number:
Date:
2020-12-10
Time:
08:16
Address:
1185 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday, December 10, 2020 while assigned to Traffic unit N525, I responded to the area 1185 Walnut Street, Newton for a report of a motor vehicle crash involving a City of Newton vehicle. The weather at the time of the crash was clear and sunny. The road surface was dry. Walnut Street is a public way maintained by the City of Newton. The Operator of MV1, Paula Khoury, stated she was parked in front of 1185 Walnut Street, Newton. Ms. Khoury stated while operating a 2018 Kia Sorento (MA: 7HK496), she attempted to leave her parking spot. Ms. Khoury stated she looked back into traffic and did not observe any vehicles. Ms. Khoury stated she attempted to merge into the southbound travel lane of Walnut Street when the front driver side of her vehicle crashed into the middle passenger side of a passing pick up truck. Ms. Khoury reported no injuries. I observed damage to the front driver side of MV1. The operator of MV2, Brian Napolitano, stated he was operating a City of Newton owned 2008 Ford pick up truck (MA MVN: M1653A) southbound on Walnut Street. Mr. Napolitano stated as he was passing the area of 1185 Walnut Street, a black SUV parked to his right attempted to leave it's parking spot and merge into traffic. Mr. Napolitano stated MV1 crashed into the passenger side of his vehicle. I observed minor damage to the middle passenger side of MV2. Mr. Napolitano reported no injuries. Mr. Napolitano worked for the City of Newton DPW. Photos were taken of the damage to both vehicle and submitted to the IT Bureau.
Keywords:
Crash, Pictures, Solar
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3211415
Longitude:
-71.20588
Location:
Case
number:
Date:
2022-04-18
Time:
15:12
Address:
102 GARLAND RD
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 (Newton City vehicle) was traveling Southbound on Garland Rd. when it side swiped a vehicle that was parked facing Southbound in front of 102 Gardland Rd. Operator of MV1 stated he did not believe he struck the vehicle, but stated he heard a loud crunch when passing MV2. MV1 was completely operational and appeared to not have sustained any damage. MV2 sustained large scrapes by the left front tire and heavy front end damage, consisting of the front bumper being almost entirely taken off. Owner of MV2 arrived on scene and stated they would be contacting their own tow company in regards to the vehicle being moved. Pictures of the scene and the damaged vehicles were taken and sent to the IT Bureau in order to be attached to this report.
Keywords:
Pictures
Dcc:
Failed to yield
Report
url:
Image
url:
Latitude:
42.3342945
Longitude:
-71.2055846
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);