home / crashreports

home

Menu
  • GraphQL API

crash_reports

Table actions
  • GraphQL API for crash_reports

3 rows where dcc = "["Over-steering", "Inattention"]", intersection = 0 and "retrieved" is on date 2020-10-07

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: speed_limit, 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:
1900000965
Date:
2019-09-21
Time:
23:02
Address:
219 LAKE AVE
Speed limit:
25
Violation cited:
yes
Narrative:
Operator of MV1 stated he was driving southbound on Lake Ave and looked down for a brief moment and did not see the bend in the road and struck the stone wall in front of 219 Lake Ave. The passenger of MV1 stated the operator was traveling southbound and did not see the turn and went up on the side walk and collided with the stone wall. The operator of MV1 was evaluated by Medic 1, the passenger reports no injuries. Cataldo received two parental refusals for both parties. A witness (Baptiste, Franck Jean) stated he witnessed the accident and believed the vehicle was travelling at approximately 40mph and lost control around the bend and struck the wall. David Donahue from Tody's Towing towed the vehicle. The homeowner at 219 Lake Ave was home and notified about the damage to their property. Six digital photos of the accident scene were taken and submitted to IT. Update 9/28/19: Upon further review and discussion with Sgt. Dempsey, Operator of MV1- Gallivan, Chase was issued citation T1445308- 89/4A- Marked Lane Violation and 90/8-JOL Passenger Restriction. Citation was issued in hand.
Keywords:
Citation, Crash, Pictures, Walk
Dcc:
Over-steering, Inattention
Report url:
report
Image url:
image
Latitude:
42.3255283
Longitude:
-71.2032033
Location:
219 Lake Ave, Newton, MA 02461, USA
Case number:
1900001102
Date:
2019-10-27
Time:
18:15
Address:
854 BEACON ST
Speed limit:
25
Violation cited:
no
Narrative:
I was dispatched to 854 Beacon St, Newton, MA for an overturned motor vehicle accident. I arrived on scene and saw Vehicle #1 (MA reg 9AS213) overturned on its driver's side with the female operator/registered owner trapped inside. Newton Fire arrived on scene and mechanically removed the operator out of the motor vehicle. Prior to where Vehicle #1 was overturned I observed Vehicle #2 (MA reg 615FF6) with rear bumper damage and a snapped rear axle. Vehicle #2 was unoccupied. Operator of Vehicle #1 was transported to Newton-Wellesley Hospital for treatment by Newton Medics. Both motor vehicles were towed by Tody's and inventory sheets were completed and filed. I spoke with the Operator of Vehicle #1 at Newton-Wellesley Hospital. Operator stated that she does not remember what happened before the crash and that she only remembers waking up in her car. I told her that her car was towed and a report is on file. Ofc Selig spoke with the registered owner of Vehicle #2 and notified her of the incident. Based on my investigation it appears that Vehicle #1 struck the rear of Vehicle #2 and the operator over steered causing the vehicle to overturn onto the driver's side.
Keywords:
Crash, Fire, Hospital
Dcc:
Over-steering, Inattention
Report url:
report
Image url:
image
Latitude:
42.330261
Longitude:
-71.1965808
Location:
854 Beacon St, Newton, MA 02459, USA
Case number:
1900001240
Date:
2019-12-02
Time:
22:24
Address:
WASHINGTON ST
Speed limit:
30
Violation cited:
no
Narrative:
Operator of MV1 stated he was traveling Eastbound on Washington St. when MV2 turned left in front of his vehicle colliding with him. Operator of MV2 stated he was traveling in the right hand land on Washington St. traveling Eastbound when he attempted to make a U-turn to travel Westbound onto Washington St. Operator of MV2 stated he first attempted to change lanes, however collided with MV1. No injuries. MV1 sustained minor damage to the right front end. MV2 sustained moderate damage to the left front end. Todys responded and towed MV2. A towed motor vehicle form was filled out in regards and placed on file.
Keywords:
Moderate
Dcc:
Over-steering, Inattention
Report url:
report
Image url:
image
Latitude:
42.3498391
Longitude:
-71.2179998
Location:
Washington St, 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 656.441ms