crash_reports
2 rows where dcc = "["Failed to yield", "Unknown"]", dcc contains "Unknown" and keywords contains "Bus"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-09-13
Time:
16:32
Address:
CHERRY ST & HARRIS RD
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator #1 states he was traveling southbound on Cherry St when he observed vehicle #2 drive through the stop sign at the end of Harris Rd, resulting in a collision with the front end of his vehicle, vehicle #1. Operator #2 states she was traveling westbound on Harris Rd and did not see the stop sign as she approached Cherry St. She subsequently drove through the stop sign and made contact with vehicle #1. Her intention was to cross Cherry St and go down Cherry Place, which is directly across the street from Harris Rd. No injuries were reported. Vehicle #2 sustained damage to the right rear corner as well as the undercarriage and was towed by Tody's. Vehicle #1 was parked legally on Cherry St and the operator has his own tow coming, as the vehicle is a contracted Waltham school bus van. It should be noted that no students were on board the van at the time of the collision.
Keywords:
Bus, School
Dcc:
Failed to yield, Unknown
Report
url:
Image
url:
Latitude:
42.3560826
Longitude:
-71.2279862
Location:
Case
number:
Date:
2020-01-23
Time:
18:11
Address:
966 WATERTOWN ST
Speed
limit:
25
Violation
cited:
yes
Narrative:
On 1/23/19 while working N493, I responded to 966 Watertown St for an MVA, car into a building. Business name is TIEM. The operator (operator #1) was the sole occupant of the vehicle (MA reg 4PW429, now known as vehicle #1). I was able to obtain a statement from operator #1 while medics and fire were en route. Operator #1 told me that she was driving eastbound on Watertown St when vehicle #2 (MA reg 1BSN69) pulled out to take a left from the Shell Gas Station at 979 Watertown St. Operator #1 had to swerve to the right in order to avoid a collision with vehicle #2. This caused vehicle #1 to crash into the exterior brick wall of 966 Watertown St. There was airbag deployment and visible structural damage to the business, however it did not appear severe. The operator of vehicle #2 was still on scene and confirmed the events that operator #1 spoke of. Operator #2 stated she did not see vehicle #1 as she was pulling out due to heavy traffic flow and parked cars. Vehicle #2 did not make contact with any other car or structure. Vehicle #1 sustained heavy front end damage and was towed by Tody's. Operator #1 was checked out by the medics but declined transport. The owner of the business affected was notified and responded to the scene. He was provided this report number for insurance purposes. No emergency accomodations or notifications needed be made in regards to the damage. It should be noted that a witness remained on scene and verified what operator #1 said transpired. His contact information was provided and is listed in the appropriate field, along with the business owner info for TIEM. Operator #2 was issued in hand MA citation T2079187 and sent on her way.
Keywords:
Airbag, Bus, Citation, Crash, Fire, Severe
Dcc:
Failed to yield, Unknown
Report
url:
Image
url:
Latitude:
42.3497612
Longitude:
-71.2246356
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);