crash_reports
3 rows where dcc = "["Signs/Signals", "Inattention"]" and keywords contains "Moderate"
This data as json, CSV (advanced)
Suggested facets: violation_cited, keywords, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-03-09
Time:
15:23
Address:
ALBEMARLE RD & CRAFTS ST
Speed
limit:
30
Violation
cited:
no
Narrative:
OPERATOR OF MV 1 STATED HE WAS TRAVELING SOUTHBOUND ON CRAFTS STREET AND AS HE APPROACHED THE INTERSECTION AT ALBERMARLE ROAD HIS VEHICLE WAS STRUCK ON THE DRIVERS SIDE BY MV 2. MODERATE DAMAGE SUSTAINED TO MV 1 AND NO INJURIES WERE REPORTED. MV 1 WAS TOWED BY TODYS TO THEIR LOT AFTER ALL VALUABLES WERE REMOVED BY THE OWNER. OPERATOR OF MV 2 WAS TRAVELING WESTBOUND ON ALBERMARLE ROAD AND AS HE DROVE ACROSS THE INTERSECTION OF CRAFTS STREET AFTER COMING TO A STOP AT THE STOP SIGN, HE STRUCK MV 1 ON THE DRIVERS SIDE. HEAVY DAMAGE SUSTAINED TO MV 2 AND OPERATOR WAS TRANSPORTED BY MEDICS TO NWH TO BE EVALUATED FOR HIS INJURIES. OPERATOR OF MV 2 WAS UNABLE TO PROVIDE A STATEMENT OF HOW THE ACCIDENT OCCURRED AND HIS VEHICLE WAS ALSO TOWED BY TODYS TO THEIR LOT. A WITNESS TO THE ACCIDENT IDENTIFIED AS BRIAN ABDOW STATED THAT MV 2 WAS AT FAULT. HE STATED THAT MV 2 CAME TO A STOP AT THE STOP SIGN BUT THEN ACCELERATED INTO TRAFFIC ON CRAFTS STREET AND STRUCK MV 1 WHO HAD THE RIGHT OF WAY. OPERATOR OF MV 2 IS BEING ISSUED MA UNIFORM CITATION T1268369 FOR CH.89 S.9 FAILURE TO COMPLY WITH STOP SIGN.
Keywords:
Citation, Crash, Moderate
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3598454
Longitude:
-71.2170818
Location:
Case
number:
Date:
2019-04-18
Time:
20:12
Address:
ELLIS ST & BOYLSTON STREET
Speed
limit:
20
Violation
cited:
yes
Narrative:
The operator of MV1 stated that she was traveling southbound from Quinobequin Road onto Ellis Street when the right rear of her vehicle was struck by MV2 when they failed to stop at a stop sign. The operator of MV2 states that she was traveling Eastbound coming off of Boylston Street when she failed to see the posted stop sign subsequently striking MV1. MV1 sustained major damage to the right rear wheel and airbag deployment and was towed from the scene by Todys. MV2 sustained moderate damage to the front bumper but was driven from the scene. Medics evaluated both parties and they signed patient refusals. The operator of MV2 was giving in hand MA uniform citation T1443935 for 89-9 failure to stop.
Keywords:
Airbag, Citation, Moderate
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3167943
Longitude:
-71.2269407
Location:
Case
number:
Date:
2020-08-21
Time:
13:32
Address:
BOYLSTON ST & CHESTNUT ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 08/21/20 at 13:32 hours, I responded to Boylston & Chestnut Streets for a two car motor vehicle accident involving no injuries. On arrival, both vehicles were pulled over to the right side of the road by 917 Chestnut Street. Operator of M/V# 1 states she was traveling straight ahead on the westbound off ramp of Boylston Street at Chestnut Street. She states she stopped for the stop sign and was attempting to proceed straight through the intersection. Next, she states she was looking towards the right for oncoming traffic and thought it was clear to proceed both ways when she made contact with M/V # 2 in the intersection. I observed moderate damage to the driver's side front quarter panel area/bumper but the vehicle was still driveable. Operator of M/V# 2 states he was traveling straight ahead northbound on Chestnut Street at Boylston Street. He says that he believes M/V # 1 stopped for the stop sign but was inching out in to the intersection. He says that once she came out he attempted to apply his brakes to no avail and the two made contact. I observed moderate damage to the front passenger side quarter panel/bumper area but the vehicle was still driveable. As a result of the accident and the fact that the operator entered the intersection when it was not clear to proceed, I issued the Operator of M/V# 1 MA Uniform Citation# T2015936 for Ch. 89/9 Failure to Stop for Stop Sign.
Keywords:
Citation, Crash, Moderate
Dcc:
Signs/Signals, Inattention
Report
url:
Image
url:
Latitude:
42.3169482
Longitude:
-71.2257627
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);