crash_reports
5 rows where "datetime" is on date 2019-12-17 and keywords contains "Ice"
This data as json, CSV (advanced)
Suggested facets: intersection, speed_limit, keywords, dcc, dcc_code, datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2019-12-17
Time:
10:58
Address:
1874 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
Operator of vehicle #1 stated he was travelling Westbound on Washington St. The road conditions at that time was covered in Slush and ice. Operator #1 stated as he was rounding a slight bend in the Rd. His vehicle continued to slide to the left and into oncoming Eastbound traffic. Vehicle #1 Then collided with vehicle #2. Operator of vehicle #2 stated he was traveling Eastbound on Washington St. when vehicle #1 slid into his travel lane, striking his vehicle head on. He stated vehicle #2 then Struck vehicle #3 which had been driving eastbound to his right. Operator of Vehicle #3 stated he was travelling Eastbound when his vehicle was struck by Vehicle #2 which caused his vehicle to spin out of control and into the Westbound travel lane where his vehicle struck Vehicle #4. Vehicle #3 then struck the fence owned by the Woodland Golf Club. Operator #4 stated she was travelling Westbound when vehicle #3 spun out of control and struck her vehicle. Operator stated she attempted to stop but was unable to due to the poor Rd. conditions.
Keywords:
Ice
Dcc:
Too fast for conditions
Report
url:
Image
url:
Latitude:
42.3352873
Longitude:
-71.2420805
Location:
Case
number:
Date:
2019-12-17
Time:
12:05
Address:
GROVE ST & PIERREPONT RD
Speed
limit:
30
Violation
cited:
no
Narrative:
Operator of Vehicle # 1 states she was traveling straight ahead at the speed limit (30 mph) (SB) on Grove Street approaching Pierrepont Road when she lost control of the vehicle due to the ice/slush on the roadway. She then veered off to the right side of the road and struck Verizon utility pole number 85/155 with her front end head on at Grove and Pierrepont Rd. I observed heavy front end damage to the front end/passenger side front of the vehicle and it was towed by Tody's. There was no damage to the utility pole. There is a decline in elevation to the roadway in this area and the road conditions were slippery due to the current snowstorm that was producing snow and freezing rain at the time.
Keywords:
Ice, Rain, Snow, Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3320655
Longitude:
-71.2565313
Location:
Case
number:
Date:
2019-12-17
Time:
14:47
Address:
717 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On the above date and time I responded to 717 Centre St for a report of a crash involving two vehicles. The weather was snowy / rainy/ sleeting, and the roadway was a mixture of ice/ snow. Upon arrival on scene I spoke with the operator of V1 Ms. Howe, she stated she was traveling south on Centre St when V2 stopped abruptly. Ms. Howes stated she applied the brakes and her vehicle would nt stop due to the icy roadway and she had contact with V2. I then spoke with the operator of V2, Ms. Nunnally stated that a vehicle had abruptly pulled out of the driveway of 717 Centre St. She stated she applied her brakes immediately to avoid contact and pulled to the right. She stated when she stopped she felt rear impact from V2. Both parties had no injuries at this time. V2 was towed by Todys towing to 1354 Washington Street Newton. Ms. Howe removed valuables from the vehicle. At this time it appears the icy roadway was a contributing factor of the crash.
Keywords:
Crash, Ice, Rain, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.347321
Longitude:
-71.1892941
Location:
Case
number:
Date:
2019-12-17
Time:
16:31
Address:
AUSTIN ST & LOWELL AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV1 was traveling SOUTH on Lowell Ave when it saw MV2 in the intersection, hit his brakes and slid into the passenger side door of MV2. MV2 had a stop sign, had to inch past the stop sign to see oncoming traffic coming from the North. MV2 believed she was clear to proceed through the intersection (Austin St @ Lowell Ave) when MV1 collided with her vehicle. The conditions were extremely icy on the roads and dark. Traffic was congested and this intersection is dangerous as drivers from the EAST side of Austin St have to proceed past the stop sign to observe traffic coming over the bridge from Lowell Ave. No injuries. Both vehicles were towed by Tody's.
Keywords:
Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3502544
Longitude:
-71.2108899
Location:
Case
number:
Date:
2019-12-17
Time:
19:29
Address:
244 LEXINGTON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
MV1 was traveling SOUTH on Lexington St when it collided with MV2 while it was backing out of a driveway ( 244 Lexington St). MV2 sustained damage to its rear driver's side. MV1 did not have any damage as it was suited with a plow mounted in front. MV2 operator was transported to NWH due to head/facial injuries from the steering wheel. Conditions of the road were extremely icy. Tody's towed MV2 from the driveway of 244 Lexington St.
Keywords:
Ice
Dcc:
Inattention
Report
url:
Image
url:
Latitude:
42.3534427
Longitude:
-71.2447531
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);