crash_reports
6 rows where dcc = "["Over-steering"]", intersection = 0 and "retrieved" is on date 2020-10-06
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, hit_run, keywords, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-01-13
Time:
17:55
Address:
1136 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV1 stated that she was traveling southbound on Chestnut street when she lost control of her vehicle causing the vehicle to jump the curb and run over a city speed limit sign breaking it at the base. The city was notified of the broken sign and pictures were taken and placed in ITs mailbox to be attached to the report. The vehicle sustained a right rear flat tire and was towed by AAA. All parties reported no injuries and signed a patient refusal.
Keywords:
Pictures, Speed
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3103168
Longitude:
-71.2238119
Location:
Case
number:
Date:
2019-04-16
Time:
15:04
Address:
25 CHESTNUT ST
Speed
limit:
5
Violation
cited:
no
Narrative:
On 4/16/19 I was sent to 25 Chestnut St the Newton Police Annex for a past motor vehicle hit and run. On arrival I was met by LAU, Justin who stated that upon leaving work around 1530 hrs, he observed a fresh scratch to his personal vehicle. The vehicle, MA 9XS415, was parked backed into the marked parking spot against the exterior wall of 25 Chestnut St and closest to the handicapped ramp. This will now be referred to as vehicle #1. The scratch is on the passenger side doors. 25 Chestnut St is equipped with an exterior surveillance system which caught this incident on camera. At 1210 hrs it shows an older white male in a blue/green pickup make contact with vehicle #1 two times as he was attempting to park. The vehicle drove into the parking spot, hitting the passenger corner of vehicle #1's front bumper, then the passenger door, before coming to a stop.The male that exited the pickup had a distinct grey beard and hair. A still frame of the male was shown to employees inside of 25 Chestnut St who immediately recognized and were able to identify him based off of a check he had dropped off earlier. The party is identified as MASTROPIERI, Rocco DOB 2/16/40. I spoke with MASTROPIERI via phone and explained why I was calling. He informed me that he was at the Annex dropping off a check for the NPMA and did not realize that he made contact with vehicle #1 when parking. MASTROPIERI apologized and stated that he would have reported the incident, had he known. MASTROPIERI responded to headquarters where he was issued a written warning in hand for C.O. 19-75 Failure to Use Care in Turning. The Police Annex is a building/lot with public access in the City of Newton.
Keywords:
Phone
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3488353
Longitude:
-71.2257494
Location:
Case
number:
Date:
2019-05-29
Time:
09:53
Address:
85 WABAN HILL RD NORTH
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper # 1 said he was backing out of his job site at 85 Waban Hill Road North with the help of his coworker. When he put the truck back into drive and pulled forward the rear of truck scratched Veh # 2 which was a delivery truck parked on the same job site. Vehicle # 1 was Eversource truck. Eversource supervisor responded.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3397812
Longitude:
-71.1715623
Location:
Case
number:
Date:
2020-01-29
Time:
12:01
Address:
160 BOYLSTON ST
Speed
limit:
15
Violation
cited:
no
Narrative:
The owner of Operator 1 stated that she parked vehicle 1 in the garage of 160 Boylston St last night. When she returned to her vehicle this morning she noticed that the front driverside fender and bumper was damaged. At this time there in no information on vehicle 2. Vehicle 1 sustained minor damage.
Keywords:
Night
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3195309
Longitude:
-71.1736296
Location:
Case
number:
Date:
2020-01-29
Time:
12:31
Address:
286 WAVERLEY AVE
Speed
limit:
5
Violation
cited:
no
Narrative:
Vehicle # 1 was parked in a parking spot at 286 Waverley Ave. Vehicle # 2 backed out of parking spot next to vehicle # 1 and when tried to make the turn after backing up, it struck Veh # 1. This was witnessed by two witnesses who ran outside and the car was gone. They were able to give dispatch plate of vehicle # 2 which matches description of a tan SUV with a woman driver. Due to very minor damage (small scrapes), Oper # 2 will not be charged with leaving the scene, she may have not been aware of damage) and RP (owners daughter) agreed that she just wanted it documented. Attempted to locate MV #2 at her home but was unsuccessful. Also tried phone number given and it wasn't answered and I wasn't able to leave a voicemail.
Keywords:
Phone
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3459937
Longitude:
-71.1808312
Location:
Case
number:
Date:
2020-09-09
Time:
10:22
Address:
337 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Oper of MV #1 stated that he tried to pull into a parking spot on Washington Street. His back wheel caught the bumper of Veh # 2 and ripped the front bumper off of Veh # 2. Owner of Veh # 2 was located and was going to call AAA for a tow.
Keywords:
[]
Dcc:
Over-steering
Report
url:
Image
url:
Latitude:
42.3569356
Longitude:
-71.1872984
Location:
Advanced export
JSON shape: default, array, newline-delimited, object
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);