crash_reports
2 rows where dcc = "["Illness"]", intersection = 0 and keywords contains "Pictures"
This data as json, CSV (advanced)
Suggested facets: datetime (date), date (date), retrieved (date), keywords (array), dcc (array)
Case
number:
Date:
2021-03-09
Time:
08:51
Address:
269 WATERTOWN ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On March 9th, 2021 at approximately 08:51 hours while working N491 I responded to the area of #265 Watertown St for a report of a MV crash with possible entrapment. On my arrival I located a black Chev Suburban MA reg 6hy959 crashed into a tree in front of #269 Watertown St The operator, later identified as Rachel Franchi, dob 05/10/1981 was still inside the vehicle. She was bleeding from her forehead. I attempted to talk with her but she appeared dazed and confused. I spoke with a witness, identified as Sarah Plesh. She reported traveling W/B on Watertown St when she observed the Black Suburban who had been coming E/B suddenly veer off the road and crash into a tree. Witness stopped her vehicle and exited to check on the condition of the driver. She observed the operator whom she thought to be having a medical emergency. Witness then noticed a small child in the back seat. The car doors were all locked but witness was able to get the child to unlock the doors. Witness then removed the child from the car and held him to police arrived on scene. Operator had to be coaxed out of her vehicle with the assistance of medical personnel. She was later transported to Newton Wellesley by Fallon Ambulance. Tody towed the vehicle. Pictures of the damaged city tree were taken by SGT Fleming and later emailed to the IT bureau. Father of child, Robert Franchi arrived on scene and took custody of the child,Julian, dob12/12/2015. He didn't appear to have suffered any injuries from this crash.
Keywords:
Crash, Ems, Pictures, Tree
Dcc:
Illness
Report
url:
Image
url:
Latitude:
42.3614824
Longitude:
-71.1975905
Location:
Case
number:
Date:
2021-12-06
Time:
11:42
Address:
10 MIDLAND AVE
Speed
limit:
10
Violation
cited:
no
Narrative:
On Monday, December 06, 2021, while assigned to Traffic unit N525, I responded to the area of Midland Avenue and Riverdale Avenue, Newton for a report of a motor vehicle crash resulting from a medical event. The weather at the time of this incident was overcast. The road surface in the area of the incident was mostly dry. Midland Avenue and Riverdale Avenue are both public ways in the City of Newton. I spoke with Mr. William Shea (S45354021), a foreman for Diaz Construction who was working on a job site next to 10 Midland Avenue at the time of the incident. Mr. Diaz stated while working with Mr. Silvestre Laneiro (S45163124) and Mr. Leonardo Alvarenga (S63414490), they observed a green Ford Taurus (MA: 6BF469) traveling towards the area of their job site while traveling North on Riverdale Avenue. Mr. Shea stated he observed a white male party vomiting what appeared to be blood out of the driver side window of the vehicle. Mr. Shea stated he then observed the vehicle's driver side area crash into numerous cement posts in front of 10 Midland Avenue (PSMJ Resources, Inc.) at a low rate of speed. The vehicle then traveling over a large mental plate in the roadway covering a trench and it continued down Riverdale Avenue until it crashed into the front driver side tire of a parked 1998 Volvo 828 rock truck owned by Diaz Construction. This vehicle was parked unoccupied on the roadway inside the jobsite. Mr. Shea stated they all went over to the vehicle to assist the driver, later identified as Mr. Richard Proia (S25282466). Mr. Shea stated there was a large amount of blood all over Mr. Proia's face, person, and vehicle and he was continuing to throw up blood. Mr. Proia was transported to St. Elizabeths Hospital in Boston by Newton Medics prior to my arrival. Due to Mr. Proia's condition at the time of his transport, Sgt. Michael Wade of the Newton Police Traffic Bureau contacted Trooper Mark Delaney of the Middlesex County CPAC who declined jurisdiction in the event that Mr. Proia succumbs to his injuries. I contacted Trooper John Paul from the MSP Reconstruction Unit to make him aware of the crash. MSP declined to respond. I notified Mr. Proia's daughter, Jennifer Proia, that her father had been transported to the hospital after being involved in the crash. Photos were taken of the crash scene and submitted to the IT Bureau. I observed damage to the front passenger side bumper/fender area of Mr. Proia's vehicle. I observed very minor damage to the front driver side tire area of the Volvo rock truck involved in the crash. Mr. Proia's vehicle was removed from the roadway by Tody's Towing. Officer Wilson canvassed the area for surveillance footage of the incident with a negative result. Sgt. Wade received a call from Dr. Grivetti (2021-10751) from the Medical Examiners Office a short time after Mr. Proia was transported to St. Elizabeths. Dr. Grivetti stated he received a call from the hospital notifying him that Mr. Proia has passed away and he was making notification to us. Dr. Grivetti stated it is his understanding that Mr. Proia suffered an aggressive GI bleed leading to cardiac arrest. This medical event appears to have been the catalyst for Mr. Proia's crash.
Keywords:
Crash, Hospital, Pictures, Speed
Dcc:
Illness
Report
url:
Image
url:
Latitude:
42.3653266
Longitude:
-71.1949564
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);