home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc = "["Other improper action"]", intersection = 0 and keywords contains "Speed"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, hit_run, 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:
2000000429
Date:
2020-08-06
Time:
10:13
Address:
457 WALNUT ST
Speed limit:
25
Violation cited:
no
Narrative:
City of Newton DPW employee Matthew Dagostino stated that on 08/06/2020 at 10:13 hours he was driving a 2007 International 7400 dump truck south bound on Walnut St in the area of number 457. Walnut St is a public way in the city of Newton. Dagostino stated that the truck was equipped with a sander and it's gross weight was appropriately 26,000 lbs. Dagostino stated that his speed was approximately 25 MPH as he drove past 457 Walnut St. Dagostino stated that a vehicle that was travailing south bound in front of his truck MA reg 491DH5 a 2019 Subaru Impreza stopped short . Dagostino stated that the Subaru stopped to let a pedestrian cross the street. Dagostino stated that when the Subaru stopped abruptly it caught him off guard because there was no marked crosswalk in the area. Dagostino stated when the Subaru stopped short he applied the breaks to his truck and had to turn to the left in an attempt to avoid a crash. Dagostino stated that his truck's front passenger side bumper made contact with the Subaru's rear driver's side bumper and tail light. Dagostino's truck had small scrapes to the front passenger side bumper. Nether operator stated that they were injured and the vehicles were not towed.Lev's vehicle had damage to the rear driver's side bumper and tail light . I took photo's of both vehicle and this disk was tuned over to the NPD's It bureau for downloading. Operator of vehicle two Naomi Lev stated that she was driving south bound on Walnut St when she said she was attempting to turn left into Berwick Rd and stopped to let a pedestrian across over Walnut St . It should be noted that Berwick Rd is approximately 1/2 of a mile south of where the crash occurred. Lev stated that she did stop her vehicle to let a pedestrian across just prior to the crash.
Keywords:
Crash, Crosswalk, Ped, Pictures, Speed
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.3449976
Longitude:
-71.2077738
Location:
457 Walnut St, Newtonville, MA 02460, USA
Case number:
2000000697
Date:
2020-12-03
Time:
14:26
Address:
1231 WASHINGTON ST
Speed limit:
10
Violation cited:
no
Narrative:
ON 12-23-20 AT APPROX. 1426HRS. WHILE WORKING N492 I TOOK A REPORT FOR MOTOR EHICLE ACIENT. UPON ARRIVL AT 1231 WASHINGTON I SPOKE TO THE COMPLAINANT ( MARK DONATO, 1231 WASHINGTON ST., NEWTON,MA. DOB: 9-5-57 ). COMP. WORKS FOR HERITAGE CORPORATION. HE SHOWED ME THE REAR LOT OF 1231 WASHINGTON ST. WHERE HE HAD A LARGE HEAVY DUMPTRUCK. BELOQW THE REAR OF THE TRUCK WAS GLASS AND DEBRIS FROM A PAST ACCIDENT. COMP. SHOWED ME VIDEO FOOTAGE FROM 11-30-20 AT 2150HRS. IN THE VIDEO I VIEWED AND SUV IN THE REAR LOT IDLEING. THE SUV ABRUPTLY BACKS IN TO THE PARKED DUMPTRUCK AND THEN QUICKLY SPEEDS AWAY. VEHILE #1 HAS NO VISIBLE DAMAGE. UNABLE TO ASSESS THE DAMAGE TO VEHICLE #2 ADVISED COMP. TO CONTACT HIS INSURANCE COMPANY.
Keywords:
Crash, Speed
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.3494843
Longitude:
-71.2239375
Location:
1231 Washington St, Newton, MA 02465, USA
Case number:
22000478
Date:
2022-06-01
Time:
15:55
Address:
175 EVELYN RD
Speed limit:
25
Violation cited:
no
Narrative:
MV1 and MV2 backed into each other while exiting their driveways. MV1 unintentionally continued in reverse at high rate of speed into Mary Ellen RD. MV1 then shifted into drive and accelerated into a City of Newton tree on Evelyn RD. Driver MV1 transported to NWH with small cut to her lip and pain in her right ankle. Driver MV2 and occupant declined medical attention. City of Newton Tree inspected by Urban Forestry. Urban Forestry cautioned off the area but stated the tree was not expected to fall. An immediate threat report was filed with the Department of Motor vehicles for the operator of MV1
Keywords:
Speed, Tree
Dcc:
Other improper action
Report url:
report
Image url:
image
Latitude:
42.3363681
Longitude:
-71.2184865
Location:
175 Evelyn Rd, 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 466.646ms