home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc = "["Lane departure", "Reckless driving"]", intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, hit_run, violation_cited, 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:
1900000993
Date:
2019-09-30
Time:
16:56
Address:
195 SUMNER ST
Speed limit:
30
Violation cited:
no
Narrative:
On September 30, 2019 at approximately 16:56 I responded to a reported hit and run crash at 195 Sumner St. Dispatch gave out a description of the vehicle that fled, described as a red pickup truck with a possible partial plate of" MVNA". I, along with several other units checked the area for the vehicle with negative results. I responded to 195 Sumner St. and spoke with the operator of MV 1, who explained that he was traveling Northbound on Langley Rd onto Sumner St when a red pickup truck attempted to pass the RP from behind. Due to Sumner St being a narrow, one way street, the pickup truck cut back in front of MV1 and struck the front driver's side of MV1 with the rear passenger side of the pickup truck.The pickup truck proceeded down Sumner St. towards Centre St. without attempted to stop. The operator of MV1 did not know the make or model of the vehicle, but described it as a full size pickup truck that was red/maroon with a black tailgate with a large "fox racing" sticker on it. The description of the vehicle that fled was broadcasted to units canvassing the area, but was not found.
Keywords:
Crash
Dcc:
Lane departure, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3313028
Longitude:
-71.1924269
Location:
195 Sumner St, Newton, MA 02459, USA
Case number:
1900001258
Date:
2019-12-07
Time:
20:32
Address:
CHESTNUT ST
Speed limit:
25
Violation cited:
yes
Narrative:
Vehicle #1 was traveling north on Chestnut St. In the area of Chestnut St. and Oliver Rd. Vehicle #1 struck the curb on its passenger side. Vehicle #1 then crossed the double yellow lines crossing into the south bound travel lanes. Vehicle #1 then crashed into and over the curb and snow bank traveling completely off the road and into a utility pole on the sidewalk. Vehicle #1 was sustained heavy front end damage and was elevated off the roadway on top of a snowbank with a utility pole indented into its front end. The crash into the utility pole caused the pole to split in half. The operator of vehicle #1 was uninjured and refused medical attention. The operator of vehicle #1 was cited with MGL 90-24/K operating under the influence, MGL 90-24/E negligent operation of a motor vehicle, 90-24/C leaving the scene of property damage and MGL 89-4A marked lanes violation (citation #T2079135 & #T2079136). For validation purposes it should be noted that entering citation #'s in the person tab, only one citation # could be entered. (See incident report #19053321) Vehicle #1 was towed from the scene by Tody's Towing.
Keywords:
Citation, Crash, Snow
Dcc:
Lane departure, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.3307093
Longitude:
-71.2247899
Location:
Chestnut St, Newton, MA, USA
Case number:
1900001338
Date:
2019-12-27
Time:
20:13
Address:
DUDLEY RD
Speed limit:
25
Violation cited:
yes
Narrative:
Vehicle #1 was traveling north on Dudley Rd. Just north of Brookline St. Vehicle #2 was traveling south on Dudley Rd. Just north of Brookline St. Vehicle #1 briefly crossed into Vehicle #2's lane and both vehicles driver side mirrors collided suffering minor damage. Vehicle #1 did not stop after the collision, but was followed by the driver of vehicle #2 and located at Newton South High School. After the accident investigation the Operator of Vehicle #1 was cited for MGL 90/24 OUI Drugs (marijuana ), MGL 90/24/C leaving the scene of property damage. (see incident report #19056178) Additionally the Operator of Vehicle #1 will be charged with MGL 90/24/E Nelgligent Operation of a Motor Vehicle (citation #T2080191). An immediate threat was filed and emailed to the MA RMV. Vehicle #1 was towed by Tody's. A towed MV sheet was completed and filed.
Keywords:
Citation, Crash, School
Dcc:
Lane departure, Reckless driving
Report url:
report
Image url:
image
Latitude:
42.312625
Longitude:
-71.1813595
Location:
Dudley Rd, Newton, MA, 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 238.553ms