crash_reports
3 rows where dcc_code = "[21]", intersection = 0 and keywords contains "Airbag"
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-23
Time:
02:09
Address:
150 NEEDHAM ST
Speed
limit:
30
Violation
cited:
yes
Narrative:
The operator of MV1, Mr. Tong Zhi, stated that he was traveling west bound on Needham street when he fell asleep causing him to lose control of the vehicle and crash into a Verizon utility pole 305/17. The motor vehicle sustained major front end damage and full airbag deployment. The utility pole was snapped, and was leaning as a result of the impact. Mr. Zhi stated that he had wrist and chest pain due to the crash and was transported to Newton Wellesley Hospital by Cataldo. Todys arrived on scene and towed the vehicle. Verizon was notified regarding their damaged utility pole. Photographs of the crash were taken and place in the IT Bureau's mailbox. Due to the facts that Mr. Zhi was asleep at the wheel while traveling on a major public way in the City of Newton, that he crossed the double yellow line into the on coming travel lane, and subsequently crashed into a utility pole causing heavy damage, Mr Zhi is being charged with 90-24 Operating to Endanger. A Massachusetts Uniform Citation, #T2080141, was completed back at the station for the offenses of 89-4A Marked Lanes violation and 90-24 Operating to Endanger. The violator's copy of the citation was placed in the Chiefs mailbox to be mailed to the offender while the criminal application portion was placed in the court prosecutors mailbox attached to this report.
Keywords:
Airbag, Citation, Crash, Hospital, Pictures
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3125203
Longitude:
-71.2122908
Location:
Case
number:
Date:
2021-09-13
Time:
16:59
Address:
885 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 09/13/2021, while assigned to N494, I, Officer Conary, and Officer Kane (N492), responded to 885 Centre Street for a report of a single motor vehicle accident with airbag deployment. Upon arrival, I observed MV1 up on the curb with significant damage to the front and front right side. Operator of MV1 explained to me that he just got out of work and was driving Northbound on Centre Street when he fell asleep. Next thing he knew he was off the roadway. He explained to me that he had an early morning at work, and this hasn't happened before. Medics arrived on scene and he signed a patient refusal. Tody's towed MV1. The City of Newton was notified because the crosswalk sign was taken down during the accident. There was also damage to a City tree. Pictures were taken and submitted to IT to be uploaded accordingly.
Keywords:
Airbag, Crash, Crosswalk, Pictures, Tree
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3433232
Longitude:
-71.1938657
Location:
Case
number:
Date:
2022-03-25
Time:
01:18
Address:
110 COMMONWEALTH AVE
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was traveling eastbound on Commonwealth Ave which is a public way in the city of Newton when the driver fell asleep and side swiped MV2 and then proceeded to rear end the back right portion of MV3. MV3 then rolled forward and made contact with MV4. Airbags were not deployed and there were no injuries. MV1 was towed by a private tow.
Keywords:
Airbag
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.3381234
Longitude:
-71.1705257
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);