crash_reports
3 rows where dcc contains "Visibility obstructed" and dcc_code = "[18, 99]"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-10-16
Time:
17:42
Address:
CEDAR ST & COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Wednesday, October 16, 2019, I, Patrolman Hatfield, was assigned to marked cruiser N 495 to Division 5 for the 1530 to 2330 hour shift. At approximately 1742 hours, FTO Guarino and I were dispatched to Commonwealth Ave at Cedar St for a motor vehicle accident with minor injuries. FTO Guarino and I arrived on scene and noticed two MVs with damage. I spoke with the RO/operator of MV2, Janet Haines (Janet). Janet stated she was not suffering from injuries. Janet said she was operating southbound on Cedar St crossing Commonwealth Ave when she had a collision with MV2. Janet stated prior to crossing Commonwealth Ave, an unknown MV stopped at the intersection to allow her to cross. Janet then stated she proceeded accross when she crashed into MV1, who drove around the stopped MV. Janet said her brakes did not work and she continued to drive forward and ended on top of the curb of Commonwealth Ave facing eastbound. MV2 suffered damage to the whole front bumper and wheel wells. FTO Guarino spoke with the operator of MV1, Madeleine Richard (Madeleine). Be advised both front and side driver airbags were deployed, and the front driver's side door was unable to be opened. I then spoke with Madeleine. Madeleine stated she was operating eastbound on Commonwealth Ave before being involved in the collision. Madeleine stated she drove around the MV infront of her that was attempting to take a left from Commonwealth Ave onto Cedar St, and she did not see MV2 prior to the accident. MV1 was struck on the driver's side by MV2, and ended facing westbound in the middle of Commonwealth Ave. EMTs and fire arrived on scene. Janet stated she did not need to be transported. Madeleine was transported to Newton Wellesley Hospital for an evaluation. Both MVs were towed by Todys.
Keywords:
Airbag, Crash, Fire, Hospital
Dcc:
Visibility obstructed, Unknown
Report
url:
Image
url:
Latitude:
42.3380858
Longitude:
-71.1987809
Location:
Case
number:
Date:
2019-12-02
Time:
10:01
Address:
PELHAM ST & CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 was stopped southbound on Centre St. attempting to turn right (westbound) on Pelham St. MV#2 was behind MV#1 also facing southbound. As MV#2 attempted to pass MV#1 it sideswiped MV#1's front plow. Damage was observed to MV#2's passenger side front bumper. Minor damage was observed to MV#1's snow plow on the driverside. No injuries were reported and both vehicles were driven from the scene.
Keywords:
Snow
Dcc:
Visibility obstructed, Unknown
Report
url:
Image
url:
Latitude:
42.3312062
Longitude:
-71.1946329
Location:
Case
number:
Date:
2022-02-03
Time:
18:41
Address:
COMMONWEALTH AVENUE & SUMNER STREET
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of MV1 states she was turning left eastbound from Sumner Street onto Commonwealth Avenue when she hit MV2. Operator of MV1 states she couldn't see over the snow pile on Commonwealth Avenue. Operator of MV1 stated she didn't see the car until the last second. MV1 sustained major damage to the front left of the vehicle and left side of the vehicle. All airbags were deployed. MV1 was towed by Todys's Service Inc as it was disabled. Operator of MV1 had no injuries and denied medical attention. Operator of MV2 states he was traveling straight ahead (Westbound) when he saw MV1's car lights and then all he remembers was crashing into the fence of 63 Sumner Street. MV2 sustained major damage to the front center and right side of the vehicle. Todys's Service Inc towed MV2 as all the air bags were deployed and the vehicle was disabled. Operator of MV2 had minor injuries and was transported by medics to Newton Wellesley Hospital to be evaluated. A section of 63 Sumner Street fence was damaged due to Motor Vehicle Accident. Owner (Sam Figler) cell phone: 650-269-4780 was informed of the damage. Witness states he saw MV1 come off of Sumner Street and get hit by MV2 on Commonwealth Avenue. Witness' vehicle did not sustain damage. Witness had no injuries. Several photos were taken of accident and turned into IT.
Keywords:
Airbag, Crash, Hospital, Phone, Pictures, Snow
Dcc:
Visibility obstructed, Unknown
Report
url:
Image
url:
Latitude:
42.336314
Longitude:
-71.1914074
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);