home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Over-steering", keywords contains "Ice" and violation_cited = 0

✎ 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:
1900000297
Date:
2019-03-18
Time:
08:57
Address:
700 CENTRE STREET
Speed limit:
35
Violation cited:
no
Narrative:
Operator of Vehicle #1 stated that he was traveling North on Centre Street. He passed through the intersection of Cabot and Centre street where he proceeded downhill on an icy road. Operator stated that he "fishtailed" and lost control of his vehicle before leaving the roadway and coming to rest in the shrubs and trees in the front yard of 700 Centre Street. At the time of this incident there is a reported water main break at the intersection of Centre street and Sargent street with City Water Crews addressing the issue. I observed a large collection of ice in the intersection and in the northbound lane of Centre street. No injuries were reported. Tody's was notified and removed the truck from the bushes. Operator #1 drove the vehicle away. I notified the home owner, Mr. Watkins of the damage. He estimated the damage to the landscaping to be approximately $2000.
Keywords:
Bus, Ice, Tree
Dcc:
Swerving, Over-steering
Report url:
report
Image url:
image
Latitude:
42.3476813
Longitude:
-71.1881338
Location:
700 Centre St, Newton, MA 02458, USA
Case number:
22000191
Date:
2022-03-01
Time:
09:32
Address:
BRIDGE ST & WATERTOWN ST
Speed limit:
30
Violation cited:
no
Narrative:
The Operator of MV1(Ma Reg 4DKA19) was traveling SB on Bridge St approaching the stop sign at Watertown Street when his vehicle was struck head on. Operator of MV1 stated the operator of MV2 came into his lane of traffic when he turned onto Bridge Street. The Operator of MV2 (Ma reg 1CV892) stated he was traveling WB on Watertown Street when he turned right onto Bridge Street. Operator of MV2 stated he lost control of his vehicle do to ice on the roadway. This caused his vehicle to swerve into the oncoming lane striking MV1 head on. Both vehicle sustained minor damage and did not require a tow. Medic 2 arrived on scene to evaluate the operator of MV1 for possible minor injuries. Operator of MV1 signed a refusal and both parties drove away from the scene safely.
Keywords:
Ice
Dcc:
Over-steering
Report url:
report
Image url:
image
Latitude:
42.3604377
Longitude:
-71.2016878
Location:
Bridge St & Watertown St, Newton, MA 02458, 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 654.322ms