crash_reports
4 rows where dcc = "["Fatigue/Sleep"]", intersection = 0 and keywords contains "Airbag"
This data as json, CSV (advanced)
Suggested facets: speed_limit, violation_cited, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-01
Time:
08:15
Address:
416 WALNUT ST
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 1-1-19 AT APPROX. 0815HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 416 WALNUT ST. I SPOKE TO THE OPERATOR OF VEHICLE #1. DRIVER STATES HE WAS TRAVELING N-BOUND ON WALNUT ST. HE FELT DROWSY AND WAS SWERVING TO THE RIGHT. HE STATES HE WENT UP ON THE CURB AND HIT A NNHS PARKING SIGN. HE UPROOTED THE SIGN IT HIT HIS HOOD AND SMASHED HIS WINDSHIELD. DRIVER STATES HE WENT UP ON THE SIDEWALK BEFORE HE WAS ABLE TO GAIN CONTROL OF HIS VEHICLE AND RETURN TO THE STREET. VEHICLE #2 STATES SHE WAS TRAVELING N-BOUND AHEAD OF VEHICLE #1. SHE STATES HE WENT UP ON THE SIDEWALK AND LANDED HIS VEHICLE IN FRONT OF HERS. VEHICLE #1 HAD FRONT END AND HOOD DAMAGE, A SMASHED WINDSHIELD AND RIGHT SIDE AIRBAG DEPLOYMENT. THERE WAS NO DAMAGE TO VEHICLE #2. VEHICLE #1 DID NOT MAKE CONTACT WITH VEHICLE #2. ALL PARTIES REPORTED NO INJURIES. ALL PARTIES ADVISED TO CONTACT THEIR INSURANCE COMPANY. VEHICLE #1 HAD HIS VEHICLE TOWED BY AAA. THE UPROOTED POLE WAS PLACED N THE BURM AT THE INTERSECTION OF WALNUT AND ELM. I TOOK SEVERAL PICTURES OF THE POLE, THE SIGN, AND THE AREA IT ORIGINATED FROM. PICTURES PLACED IN BOX FOR I.T. BUREAU.
Keywords:
Airbag, Crash, Pictures
Dcc:
Fatigue/Sleep
Report
url:
Image
url:
Latitude:
42.347026
Longitude:
-71.2061414
Location:
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);