home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where "datetime" is on date 2019-02-21 and keywords contains "Ice"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)

case_number ▼ date time address speed_limit violation_cited narrative keywords dcc report_url image_url latitude longitude
Case number:
1900000203
Date:
2019-02-21
Time:
08:35
Address:
BEACON ST & HAMMOND ST
Speed limit:
25
Violation cited:
no
Narrative:
Oper of Veh # 1 stated he was going WB on Beacon Street and wasn't able to stop at red light due to the icy roads. He struck Veh # 2 in the middle of the intersection. Oper of Veh 2 stated she had a green light when she was going through intersection and saw veh # 1 go through intersection and hit her. Veh # 1 had a plow equipped was unable to put that in diagram. No Injuries, No Tows
Keywords:
Ice
Dcc:
Too fast for conditions
Report url:
report
Image url:
image
Latitude:
42.3328654
Longitude:
-71.1727828
Location:
Beacon St & Hammond St, Newton, MA 02467, USA
Case number:
1900000205
Date:
2019-02-21
Time:
09:53
Address:
IONIA ST
Speed limit:
25
Violation cited:
no
Narrative:
On Thursday, February 21, 2019, while assigned to Traffic unit N526, I responded to the area of Ionia Street, Newton for a report of a motor vehicle accident involving a City of Newton owned vehicle. Ionia Street is a public way maintained by the City of Newton. The weather at the time of the accident was overcast. The road surface was icy and snow covered. The operator of MV1, Patrick Carresi (MA: S73958042), stated he was operating a City of Newton owned 2016 Ford F350 plow truck (MA MVN: M94756) turning left onto Ionia Street from Auburndale Av. Carresi stated as he took the turn, the rear passenger corner of the truck made contact with the drivers side front panel of MV2 which was parked on the side of the road facing southbound. I observed minor damage to the rear of MV1. MV2 received heavy front end damage with the entire front panel torn off. Carresi reported no injuries. Carresi works for the Utilities Department with the DPW. The operator of MV2, Donna Canavan (MA: S57637058), stated she was parked inside her 2005 Honda CRV (MA: 8ZEE40) facing southbound on Ionia Street. Canavan stated as the plow truck took the turn onto Ionia Street from Auburndale Av its rear corner of the truck struck the front panel of her parked vehicle ripping the panel off. I observed significant damage to the front panel area of MV2. Canavan reported no injuries and was able to drive her vehicle from the scene. Pictures were taken of both vehicles and submitted to the IT Bureau.
Keywords:
Crash, Ice, Pictures, Snow
Dcc:
[]
Report url:
report
Image url:
image
Latitude:
42.349507
Longitude:
-71.244875
Location:
Ionia St, Newton, MA 02466, USA

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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);
Powered by Datasette · Queries took 301.445ms