crash_reports
2 rows where dcc = "["Lane departure", "Inattention"]", intersection = 0 and keywords contains "Airbag"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-06-05
Time:
00:12
Address:
163 LEXINGTON ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On Wednesday, June 5th 2019, at approximately 12:12am, I, Officer Brooks, responded to 163 Lexington street for a report of a 2 car MVA. Upon my arrival I observed that MV1(MA REG 574PF5) had struck MV2(FL REG CWWE22) which was parked legally in front of 163 Lexington street. I spoke with the operator of MV1 who stated he was traveling southbound on Lexington street, and had reached over to his passenger side to grab a Burger King bag. When he reached for the bag he drifted to the right and struck MV2. MV1 had heavy damage to the passenger side and airbag deployment. The operator was checked out by Cataldo and signed a patient refusal. MV1 was towed by Tody's. The operator was issued a citation for an expired registration. I spoke with the owner of MV2 who was inside of 163 Lexington street at the time of the accident. His vehicle had been legally parked when struck. MV2 sustained major damage to the driver's side. MV2 was towed by Tody's. Both operators were provided the report number.
Keywords:
Airbag, Citation, Crash
Dcc:
Lane departure, Inattention
Report
url:
Image
url:
Latitude:
42.3552534
Longitude:
-71.2426722
Location:
Case
number:
Date:
2020-10-27
Time:
18:39
Address:
546 PARKER ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
On Tuesday, October 27th 2020 at 18:40 hours, Myself N-499 and Ofc Crowe N498 responded to 546 Parker St for a single vehicle accident into a city tree. Upon arrival, I identified Mass Reg # 3GDM90, 2015 LEXS RX350, Color Gray had crashed into a City Tree. The airbags had not been deployed. The operator was no longer in the vehicle upon my arrival. He was identified as registered owner Brian Mcneill. Mcneill admitted he had operated the vehicle. Mcneill stated he was driving North on Parker St toward RT 9 headed home to Wellesley. Mcneill stated he was on his phone texting and lost sight of the road. Mcneill's vehicle veered off the side of the road and side swiped a City of Newton Tree causing heavy right side damage and loss of the front right tire. Mcneill's wife came to the scene to pick him up and drive him home. The set of golf clubs in the trunk of the vehicle was documented in the MV Inventory Crash Form. Mcneill suffered no injuries and signed a patient refusal with the medics. Tody's towed the vehicle. Mcneill was given MA Uniform Citation # T2013042 for the amount of $ 210 for M.G.L Ch 89/S4A Marked Lanes Violation and M.G.L Ch. 90/S13B Texting While Driving Violation. Pictures were taken of the accident and submitted to Newton IT Bureau.
Keywords:
Airbag, Citation, Crash, Phone, Pictures, Tree
Dcc:
Lane departure, Inattention
Report
url:
Image
url:
Latitude:
42.3089195
Longitude:
-71.197509
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);