home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

2 rows where dcc contains "Defective equipment", intersection = 0 and keywords contains "Pictures"

✎ 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:
1900000766
Date:
2019-07-25
Time:
16:23
Address:
444 WATERTOWN ST
Speed limit:
30
Violation cited:
no
Narrative:
At approximately 1620HRs on Thursday, July, 25, 2019, I was dispatched to 444 Washington St. in reference to a truck vs tree motor vehicle crash. Upon arrival, I noted MV1 (MA Vet: 22098) had partially left the roadway and came to rest when it struck a city tree on the sidewalk. Additionally, I noted MV1 struck MV2 (MA Pass: 5CN826), which was parked on the road in front of the tree/aforementioned address. MV1 sustained damage to its front clip and was leaking fluids. MV2 sustained damage to its right rear bumper/quarter panel area. Upon speaking with the operator of MV1, an employee of Tony's Auto Services, he stated that he was test riding the vehicle after they made repairs to its power steering system. He stated that as he traveled eastbound on Watertown St. at approx 30MPH, the vehicle's brakes failed and he guided MV1 towards the tree in an attempt to stop it without injuring anyone. Todys Services took custody of MV1. Newton Fire cleaned up the leaking fluids and the operator of MV1 signed a patient refusal with Newton Medics. Newton Dispatch notified the city to see if they wished to inspect the tree which was still freestanding and appeared to only suffer minor damage. Tony's Auto Services notified the owner of MV1 and I notified the owner of MV2 of the crash. I submitted a picture of the tree to IT to be attached to this report. I cleared without further incident.
Keywords:
Crash, Fire, Pictures, Tree
Dcc:
Defective equipment
Report url:
report
Image url:
image
Latitude:
42.3588636
Longitude:
-71.2033801
Location:
444 Watertown St, Newton, MA 02458, USA
Case number:
22000326
Date:
2022-04-21
Time:
08:05
Address:
619 CHESTNUT STREET
Speed limit:
25
Violation cited:
no
Narrative:
On Thursday 4/21/22 at approximately 805 hours while assigned to marked unit n498 I was dispatched to the intersection of Beacon and Chestnut Streets for a report of a motor vehicle crash into a utility pole. Upon arrival I observed two motor vehicles that had crashed in front of 619 Chestnut street and a utility pole also in front of 619 Chestnut Street with significant damage (pole# 85/75). While on scene I interviewed the operator, NUNEZ Ralphie, of Motor Vehicle 1, (MD Reg 5EP2140), who states he just dropped his Girlfriend off at a house on Beacon Street and turned right from Beacon Street onto Chestnut Street and began travelling southbound on Chestnut Street. NUNEZ states as he was driving he felt the steering wheel lock up and the vehicle was heading straight for the Utility Pole. He states he struck the Utility Pole and the force from the crash pushed his vehicle into the Northbound lane of traffic. After speaking with NUNEZ I spoke with the operator, MILLER Michael, of Motor vehicle #2, (Ma reg 1BTT36) who states he was travelling Northbound on Chestnut street when he observed Motor Vehicle#1 drive into the utility pole causing the vehicle to enter his lane of travel. MILLER states he attempted to veer to the right of the road to attempt to avoid the motor vehicle, but was unsuccessful and struck Motor Vehicle#1. Also on scene was, PISANO Christian, who witnessed the crash. See his attached witness statement given to me verbally on scene. 3 pictures were taken of the damage to the utility pole and forwarded to IT to be attached this crash report
Keywords:
Crash, Pictures
Dcc:
Defective equipment, Unknown
Report url:
report
Image url:
image
Latitude:
42.3285764
Longitude:
-71.2262367
Location:
619 Chestnut St, Waban, MA 02468, 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 798.992ms