crash_reports
3 rows where "datetime" is on date 2020-08-01 and keywords contains "Crash"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2020-08-01
Time:
08:01
Address:
20 CHESTERFIELD RD
Speed
limit:
30
Violation
cited:
no
Narrative:
ON 8-1-20 AT APPROX. 0801HRS. WHILE WORKING N492 I TOOK A REPORT OF R MOTOR VEHICLE ACCIDENT. UPON ARRIVAL AT 20 CHESTERFIELD RD. I NOTICED A MOTOR VEHICLE ( MA REG : 6HY675 ) WAS UP ON THE CURB NEXT TO A CITY TREE. THE MOTOR VEHICLE HAD EXTENSIVE LEFT QTR. PANEL DAMAGE AND LEFT FRONT AND REAR FLAT TIRES. THERE WAS ALSO DAMAGE TO THE TREE CONSISTENT WITH A VEHICLE CRASH. PICTURES OF THE TREE DAMAGE WERE TAKEN AND SIM CARD PLACED IN I.T. BOX. A REGISTRY CHECK OF THE VEHICLE IDENTIFIED THE OWNER AS ( RUCHIRA DAS GUPTA , 25 OLDHAM RD. NEWTON, MA. 02465 ). I WENT TO 25 OLDHAM AND SPOKE WITH THE OWNER. SHE STATES ON 7-31-20 AT APPROX. 2200HRS. SHE WAS TRAVELING W-BOUND ON CHESTERFIELD RD. SHE STATES SHE ACCELERATED BECAUSE SHE WAS TRAVELING UPHILL. SHE STATES SHE GOT HER FOOT STUCK ON THE GAS AND LOST CONTROL OF THE VEHICLE. THE VEHICLE DID NOT STOP UNTIL SHE HIT THE TREE IN FRONT OF 20 CHESTERFIELD AND HER TWO LEFT SIDE TIRES WERE FLAT. COMP. STATED SHE LEFT THE VEHICLE OVERNIGHT.. SHE STATED SHE DID NOT REPORT THE INCIDENT BECAUSE OF EMBARRASSMENT. COMP. STATES SHE HAD JUST CONTACTED AAA AND THEY GAVE HER AN E.T.A. OF ONE HOUR. COMP REPORTS NO INJURIES. COMP. ADVISED TO CONTACT INSURANCE AGENCY AND THAT I WOULD BE WRITING A REPORT OF THE INCIDENT. ADVISED TO CONTACT THE POLICE IN FUTURE INCIDENTS REGARDLESS OF EMBARRASSMENT. CLEARED WITHOUT FURTHER INCIDENT.
Keywords:
Crash, Pictures, Severe, Tree
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3402392
Longitude:
-71.2347757
Location:
Case
number:
Date:
2020-08-01
Time:
10:09
Address:
1200 WALNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On August 1, 2020 I responded to a single motor vehicle crash at 1200 Walnut St. I spoke to the owner of MV1 who said that he parked MV1 in front of 1177 Walnut St to run across the street and pick up his mail. When he exited his vehicle, he noticed that his vehicle began rolling southbound on Walnut St and crashed into city poles in front of 1200 Walnut St. The owner of MV1 said that he had recently got his vehicle inspected but periodically would have the brake light come on and was planning on contacting his mechanic. MV1 has a manual transmission, and the owner said that he put the vehicle in gear, shut the vehicle off and used the electronic emergency brake. He believes that the emergency brake may have malfunctioned, causing the vehicle to roll southbound on Walnut St and crash. As a result of the crash, MV1 sustained front end damage and there was visible damage to the city poles (used to protect the tree on the sidewalk). Officer Raymond took photographs of the damaged city property and submitted them to IT to be attached to this report.
Keywords:
Crash, Pictures, Tree
Dcc:
Unknown
Report
url:
Image
url:
Latitude:
42.3210033
Longitude:
-71.2052133
Location:
Case
number:
Date:
2020-08-01
Time:
20:10
Address:
KENRICK ST & WAVERLEY AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
On Saturday, August 1, 2020 at approximately 1810 hours I responded to a single motor vehicle crash. Upon arrival I saw the vehicle completely off the roadway and in the middle of a grassed area next to a large tree. The operator of MV1 stated he was driving westbound on Kenrick St and attempted to take a left turn on Waverly Ave when he lost control of his car and drove over the curb and hit part of the tree. EMS arrived on scene and operator of MV1 signed a refusal. There was major damage to the front of the car making it inoperable. The vehicle was towed by Todys. Todys had to cut branches of the city tree to get the vehicle out. Pictures of the vehicle and tree have been submitted to IT.
Keywords:
Crash, Ems, Pictures, Tree
Dcc:
Lane departure
Report
url:
Image
url:
Latitude:
42.3467369
Longitude:
-71.1809733
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);