crash_reports
2 rows where "datetime" is on date 2022-02-13 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:
2022-02-13
Time:
17:30
Address:
BEACON ST & WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
I responded to the area of Beacon St.@Washington St. for a two car MVA. I arrived in the area and observed the two vehicles stopped on the eastbound side of Washington St. V1; MA Reg. 6XY435, 2014 Honda/CRV color white, V1 operator Sylvia Chin MA OLN S83835816. V1 passenger Ashley Chin was seated in the rear passenger seat. There was also a medium size dog in the rear passenger compartment. V2; MA Reg. 666RX3, 2015 Honda/SUV color white, V2 operator Shaina Butler MA OLN S38029127. passengers were two minor children (operator's daughters), AKaile Platt 9 y.o. and Anaii Platt 6 y.o. The V1 passenger was evaluated by EMS for a possible back injury. She was transported to Newton Wellesley Hospital by ambulance. V1 operator was concerned about her dog possibly having an injury. The dog appeared to be uninjured. She was advised to have the dog checked by a Vet when possible. Neither MV had airbag deployment. V1 was on Beacon St stopped at the traffic light. V2 attempted to come to a stop behind V1. V2 skidded on the snow covered road (Beacon St.) attempting to stop and collided into the rear of V1. The two vehicles had moderate damage. Neither vehicle required towing service.
Keywords:
Airbag, Ems, Hospital, Moderate, Snow
Dcc:
Swerving
Report
url:
Image
url:
Latitude:
42.3300068
Longitude:
-71.2484874
Location:
Case
number:
Date:
2022-02-13
Time:
18:56
Address:
PROSPECT AVE & WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Sunday February 13, 2022 at approx. 1856 hours I was traveling north on Walnut Street approaching the intersection of Prospect Ave when I observed a two motor vehicle crash with City property damage. Upon arrival on scene I activated my emergency lights and exited my cruiser to check on all parties and notified dispatch of the crash. I observed both vehicles had airbag deployment and notified for medics to respond. The operator of vehicle one stated he was traveling north on Walnut Street when vehicle two traveled through Prospect Ave onto Walnut Street into his path of travel causing impact. The operator of vehicle two stated he was traveling east, down hill on Prospect Ave, he applied his brakes and his vehicle slide uncontrollable downhill through the intersection onto Walnut Street where vehicle one had impact with his vehicle, which caused him to spin around onto the curb striking a City tree and sidewalk. The vehicle was close to a retaining wall belonging to 580 Walnut Street but did not appear to have had contact. Fire and medics arrive on scene, to check on both parties due to both vehicles having airbag deployment. Both parties declined medical treatment and stated they did not have any injuries. Prospect Ave and Walnut Street were both covered with ice/snow and untreated. I notified for a sander to treat the roadways which was a contributing factor of the crash. Todys towing arrived on scene and towed both vehicles to their tow lot. All parties advised of the process. I took pictures of the City property damage that I will download at the I.T. Bureau.
Keywords:
Airbag, Crash, Fire, Ice, Pictures, Solar, Tree
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3415191
Longitude:
-71.2066448
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);