crash_reports
17 rows where dcc = "[]", intersection = 0 and keywords contains "Fire"
This data as json, CSV (advanced)
Suggested facets: date, speed_limit, keywords, datetime (date), date (date), retrieved (date), keywords (array)
Case
number:
Date:
2019-02-12
Time:
14:45
Address:
659 CHESTNUT ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 2/12/2018 at approx 1445hrs while assigned to 497 I responded to the area of 659 Chestnut St for a report of a two car crash . Upon arrival Ma Reg 9VA441 being operated by Steven HUTCHINSON and Ma Reg 98NL90 being operated by Vi DANG were pulled to the side of the road, there was a heavy snowfall and the road had accumulated a thick layer of snow and multiple crashes were occurring. NFD was on scene , DANG was crying and hysterical despite the minor nature of the crash and zero damage to either vehicle. HUTCHINSON stated they were creeping along NB on Chestnut St when DANG stopped, HUTCHINSON attempted to stop and his 4wd engaged and he slid slightly into the back of DANGS car, no marks or damage to either car. DANG elected to go to NWH with Cataldo . DANGs veh towed so as not to obstruct roadway.
Keywords:
Crash, Fire, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3272407
Longitude:
-71.2264688
Location:
Case
number:
Date:
2019-02-13
Time:
21:26
Address:
2000 COMMONWEALTH AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
MV#1 Stated while traveling westbound down Commonwealth ave he struck a patch of ice. The ice caused his vehicle to rotate 360 degrees and proceeded to slide on the roadside shoulder striking a verizon poll ( 102/285). MV#1 traveled approximately 12ft from the road before striking the poll. MV#1 sustained heavy front end damage. MV#1 had all airbags deployed and had a small fire under the front end. I observed multiple other vehicles passing having difficulties and vehicles sliding due to significant ice conditions. Driver of MV#1 had injuries to his left arm, possible broken forearm/wrist. Passenger of MV#1 stated she had chest pains. Medics transported both parties to Newton Wellesley Hospital for further evaluation. Tody's Towed the vehicle due to heavy front end damage.
Keywords:
Airbag, Fire, Hospital, Ice
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3470319
Longitude:
-71.2431985
Location:
Case
number:
Date:
2019-04-18
Time:
12:22
Address:
81 OAK ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday 04/18/209 at approximately 1222 hours I responded to 81 Oak Street for a motor vehicle accident involving Newton Fire Ladder 2. At the time of the accident the weather was cloudy and road conditions were dry. Oak Street is a public way in the city of Newton. Upon arrival I spoke with the operator of MV1 who stated while trying to manuever through oncoming traffic on Oak Street heading southboud MV1 struck MV2's drivers side mirror while MV2 was parked. MV1 reported no damage and reported no injuries. MV2 reiterated the same events and reported very minor damage to the drivers side mirror. No injuries were reported. Several pictures were taken of both vehicles and submitted to the IT Bureau.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3098704
Longitude:
-71.2208998
Location:
Case
number:
Date:
2019-04-18
Time:
14:00
Address:
37 ELM ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Thursday 04/18/2019 at approximately 1400 hours I responded to 37 Elm Street for a single vehicle accident with City of Newton property damage. At the time of the accident the weather was cloudy and the road conditions were dry. Elm Street is a public way in the city of Newton. The operator of MV1 identified as Silton Barrett (S17437114) stated he parked his UHAUL van in front of 37 Elm Street to make a delivery. While attempting to pull MV1 back into the traffic lane he struck a fire hydrant knocking it over and completely detaching it from the base on the ground. MV1 sustained minor front end damage and was able to leave the scene. Several photographs were taken and submitted to the IT Bureau. City of Newton was notified for the property damage.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3512239
Longitude:
-71.23108
Location:
Case
number:
Date:
2019-08-30
Time:
11:08
Address:
142 PARK ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On Friday, August 30, 2019, while assigned to Traffic unit N525, I responded to Burr Park (142 Park Street, Newton) for a motor vehicle crash involving a City of Newton Fire truck. The operator of Newton Fire Ladder 3 (MA: MF453453), Michael Pohlman, stated while trying to exit Burr Park from the Waverly Street exit, the middle driver side tire area of Ladder 3 made contact with a fixed cement pole. The pole is located at the entrance/exit and has a chain attached to it used to restrict access to the area. I observed minor damage to the driver side middle tire area and no damage to the pole. No injuries were reported by the occupants of Ladder 3. Photos were taken and submitted to the IT Bureau. Ladder 3 stated they were at the Burr Park permorming an inspection.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.352293
Longitude:
-71.1810558
Location:
Case
number:
Date:
2019-12-23
Time:
19:19
Address:
807 WASHINGTON ST
Speed
limit:
35
Violation
cited:
no
Narrative:
On 12/23/19, at 1919 hours, I responded to the area of 807 Washington St. for pedestrian struck by a motor vehicle. Upon arrival with Cataldo Medics and Newton Fire, I observed Catherine Chapman being treated in the westbound lane a few feet in front of a 2010 Hyundai Elantra (MA Reg. 4KH 743). The vehicle had a shattered windshield. Ms. Chapman appeared to be wearing a dark colored jacket and dark pants. The operator of the motor vehicle, Emily Shuman, stated she was traveling westbound in the outside lane when Ms. Chapman stepped in front of her car from the eastbound lane. I also spoke with a witness, Malcolm Robinson, who stated Ms. Chapman was crossing the street from the eastbound lanes with two other people. The other two people stopped in the middle of the street but Ms. Chapman kept walking and was struck. The other two people were Victor Polk and Halimah Polk, both of which confirmed the witness statement. Ms. Chapman was transported by Cataldo to Brigham & Womens Hospital with non-life threatening injuries. Todys towed the vehicle and pictures of the scene were submitted to IT.
Keywords:
Fire, Hospital, Ped, Pictures, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3519457
Longitude:
-71.2064132
Location:
Case
number:
Date:
2020-09-01
Time:
13:55
Address:
780 BEACON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday, September 1, 2020, while assigned to marked unit N496, I responded to the area of 780 Beacon Street, Newton for a report of a motor vehicle crash involving a bicyclist. The weather at the time of the crash was clear and sunny. The road surface was dry. Beacon Street is a public way maintained by the City of Newton. I spoke with the operator of the vehicle involved in the crash, Dina Hudson (S33833807). Ms. Hudson stated she was sitting in her 2015 white Jeep Grand Cherokee (MA: 727SZ7) that was parked (E) in a metered parking spot in front of 780 Beacon Street. Ms. Hudson stated traffic in the Eastbound lane of Beacon Street to her left was stopped. There was a red light ahead at the intersection and traffic had built up past where her vehicle was parked. Ms. Hudson stated she opened her driver side door while she was looking for her debit card to go to the bank. Ms. Hudson stated at this time a bicyclist was traveling at a high rate of speed around the stopped traffic towards the intersection and crashed into her driver side door. Ms. Hudson stated the operator of the bicycle then traveled further up the roadway and crashed behind a vehicle stopped in traffic. Ms. Hudson stated she was unsure if the bicyclist crashed into the stopped vehicle or if it had landed on the roadway just before it. Ms. Hudson stated the bicyclist then got up from the roadway and began yelling at her that the crash was her fault. I observed a few small fresh scrapes on the outside of the driver side door area. When I initially arrived at the crash location, I observed Officer Lazarakis checking on his well-being of the injured bicyclist, Marc Lind. Lind was observed laying on the sidewalk in front of 780 Beacon Street. After being evaluated by Newton Medics, I spoke with Mr. Lind. Mr. Lind stated he was traveling on his Trek bicycle Eastbound on Beacon Street towards Langley Road. Mr. Lind stated while traveling through the area at this time, traffic in the Eastbound Lane was stopped and there was a red light ahead of him at the intersection. Mr. Lind estimated his speed at this time to be 10-12 miles per hour. Mr. Lind stated as he travelled past the Santander Bank at 780 Beacon Street, the operator of a parked white Jeep to his right abruptly opened their door into traffic. Mr. Lind stated he attempted to avoid the vehicles door and veered to the left. Mr. Lind stated the right end of his handlebar made contact with the door and as he traveled forward and applied his brakes his right side crashed into the rear of a vehicle stopped in traffic ahead of him. Mr. Lind stated he crashed to the roadway on his right side. Mr. Lind was able to move to the side of the roadway and wait for Newton PD, Fire, and Medics to respond. Mr. Lind reported injuries to his right arm, side, and leg area. Mr. Lind signed a patient refusal with Newton Medics and was transported away from the area by his wife with his bicycle. I observed no substantial damage to his Trek bicycle. At the time of the crash, Mr. Lind was wearing a white t-shirt, black shorts, black, shoes, and a gray helmet with sunglasses. I spoke with a witness to the crash, Steve Worthington. Mr. Worthington stated he was stopped in traffic on Beacon Street about 4 vehicles back from the red light. Mr. Worthington stated he looked out of his passenger door mirror and observed a bicyclist "whipping" down Beacon Street in between vehicles parked on the side of the road and vehicles stopped in traffic at the red light. Mr. Worthington estimated the speed of the bicycle to be approximately 20 miles per hour. Mr. Worthington stated the bicyclist had to "lean" by his vehicle to get by. Mr. Worthington stated a vehicle just ahead of him that was parked opened their door and the bicyclist made contact with the door. Mr. Worthington stated the bicyclist then went down in front of the car that was in front of him. Mr. Worthington stated the bicyclist was rolling around on the ground and screaming "It's your fault" at the woman that opened her door Photos were taken of the bicycle and the vehicle involved and submitted to the IT Bureau.
Keywords:
Bike, Crash, Fire, Helmet, Pictures, Solar, Speed
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3301182
Longitude:
-71.1928911
Location:
Case
number:
Date:
2020-12-03
Time:
12:40
Address:
483 CENTRE ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 12/3/2020 at 1400hrs I investigated a past motor vehicle crash involving a pedestrian. The crash occurred on 12/03/2020 at approximately 1240hrs. The crash was located in the area of 483 Centre St. Centre St is a public way in the city of Newton. Vehicle 1 was traveling southbound on Centre St near the area of 483 Centre St. Pedestrian 1 was located on the southbound side of Centre St near 483 Centre St. Pedestrian entered the southbound lane of Centre St and was struck by Vehicle 1. As a result of the impact Pedestrian 1 sustained a minor injury to his left leg. Vehicle 1 had no known damage. No parties were transported. No tow was required. It should be noted that the crash was reported by the Operator of Vehicle 1 Daniel Zandman at approximately 1400hrs. Zandman states that he was operating his Vehicle southbound on Centre St just after the intersection at Church St. Zandman states that Pedestrian 1 unexpectedly ran in front of his vehicle. Zandman stated that he did not have enough reaction time to come to a complete stop and his front bumper made contact with Pedestrian 1. Zandman stated that after impact he immediately got out of his vehicle and checked on Pedestrian 1. Zandman described pedestrian on as a 10 year old white male identified as Dexter Jagoditish. Zandman stated that while on scene Dexter called his mother Jess Jagoditish who immediately responded to the scene. Zandman stated that he exchanged information with Jess Jagoditish who then took Dexter home. Zandman states that a witness Mia Martin was also on scene. At approximately 1425hrs I called and spoke to Dexter and his mother Jess Jagoditish. Dexter states that he was walking on the sidewalk near 483 Centre St. Dexter states that he wanted to cross Centre St and thought there were no cars coming. Dexter stated that he entered the southbound lane of Centre St and a car came out of no where and hit him. I then spoke to Jess Jagoditish who is Dexter's mother. Jess stated that she received a call from Dexter around 1240hrs stating he was just hit by a car. Jess stated that when she arrived on scene Dexter was with Zandman and a witness Mia Martin. Jess stated that both Zandman and Martin explained them what had happened. Jess stated that Dexter appeared to be ok so she decided to take him home. Jess states that at this time Dexter has a bruise on his left calf but otherwise appears to be ok. At 1551hrs I spoke with the witness Mia Martin. Martin states that just prior to the crash she was walking her dog behind Dexter. Martin states that "out of nowhere" Dexter sprinted into the southbound lane of Centre St. Mia states that she then observed Vehicle 1 attempt to slow down and swerve to the lest to avoid Dexter. Mia states that the passenger side front bumper then made contact with Dexter. Mia states at impact Vehicle 1 was traveling at a very slow speed. Mia states that Dexter was then knocked on to the ground but then immediately jumped up and started to run away. Mia states that both she and Zandman were able to get Dexter to comeback so that they could check to see if he was ok. Mia states that Dexter was then able to contact his mom who responded on scene. Due to this crash being reported after the fact, Fire, EMS or Police where not initially notified and did not respond to the scene. Pictures were also not taken of the crash scene. At this time this report is for documentation purposes. After speaking with all the parties involved it appears that the crash was caused by Pedestrian 1 entering the roadway in a manner which gave Vehicle 1 little or no time to react.
Keywords:
Crash, Ems, Fire, Ped, Pictures, Speed, Walk
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3540168
Longitude:
-71.1866673
Location:
Case
number:
Date:
2021-01-26
Time:
19:47
Address:
80 CHARLESBANK RD
Speed
limit:
25
Violation
cited:
no
Narrative:
On 1/26/2021, Newton Fire and Police were dispatched to Charlesbank Rd. and St. James St. for a single motor vehicle collision. Upon arrival, I observed Motor Vehicle #1 parked in the roadway with damage to its front end and under carriage. The operator stated; due to the snowy, wet, slippery conditions, her vehicle slid into the concrete median. The operator reported no injuries, however the vehicle was towed away from the scene by Tody's Towing Service.
Keywords:
Fire, Snow
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3585654
Longitude:
-71.1797224
Location:
Case
number:
Date:
2021-05-18
Time:
08:30
Address:
105 RUMFORD AVE
Speed
limit:
25
Violation
cited:
no
Narrative:
The operator of MV#1 states that he was exiting #105 Rumford Ave when the top of his freight caught the wires across the driveway to that address. The force of the crash snapped Edison pole #866/6 in half and took down the wires. MV#1 also sustained damage to the front windshield and cab. The Newton Fire, Waltham Fire and Waltham PD also responded as well as Eversource. There were no tows and no injuries.
Keywords:
Crash, Fire
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.358273
Longitude:
-71.242456
Location:
Case
number:
Date:
2021-07-26
Time:
18:59
Address:
19 FAXON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
Operator of vehicle one Newton FF Eric Howard stated that while getting into the drivers seat of Newton Medic Unit 3 a Fallon Ambulance ( 2021 Ford Econoline MA reg AMN 7715 ), that was parked in front of 19 Faxon St, he inadvertently stepped on the break and disengaged the gear shift so that the ambulance went from park to drive. FF Howard was getting ready to drive Newton Medic Unit 3 to Newton Wellesley Hospital while Fallon Medics attend to their patient in the rear of the ambulance. FF Howard stated that after the ambulance went into drive it drove south bound on Faxon St and it's front driver's side fender struck the rear passenger side bumper of vehicle two. FF Howard stated that he was not injured in the crash and was able to drive the ambulance to Newton Wellesley Hospital. Fallon Medics Jared Gaglio and Shane McMahon stated that they were in the rear of the ambulance treating their patient, Dominica Tramontozzi when they felt the ambulance move forward and strike vehicle two. Both Gaglio and McMahon stated that they were not injured in the crash. I was unable to take a statement from Tramontozzi. Operator of Vehicle two Newton FF Joseph Colella stated that he was sitting in the driver's sea of Newton Fire Dept Eng 8 ( 2004 E-One Pumper MA reg MF471 and Newton Fire LT Douglas Quinn was sitting in the front passenger seat when the crash occurred. Vehicle two was parked in front of 19 Faxon St. FF Colella stated that the front driver's fender of vehicle one stuck the rear passenger bumper of vehicle two. Both FF Colella and Fire LT Quinn stated that they were not injured in the crash. Vehicle two did not require a tow. Vehicle one was towed from Newton Wellesley Hospital after a tow was arraigned by a Fallon Ambulance Supervisor. I took photos of both vehicles and forwarded the disk to the NPD's IT Bureau for downloading. Faxon St is public way in the City of Newton.
Keywords:
Crash, Ems, Fire, Hospital, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.364169
Longitude:
-71.1997368
Location:
Case
number:
Date:
2021-07-27
Time:
14:49
Address:
513 WASHINGTON ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On 07/27/2021, while assigned to N494, I, Officer Conary, spoke with DEALE, Cathy (Operator of MV1) over the phone about a past hit and run. DEALE explained to me that she parked Westbound on Washington Street in front of 513 by the fire hydrant. Between 1200-1400 MV1 was hit on the driver side, and the mirror broke off. Operator of MV1 did not see any other vehicle standing by, she left the area and notified Newton Police. Operator of MV1 sent me pictures to confirm the damage. I went back to the area of where the accident was reported and confirmed glass and a pieces of a mirror on the side of the road.
Keywords:
Crash, Fire, Phone, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3552254
Longitude:
-71.1940066
Location:
Case
number:
Date:
2021-08-19
Time:
12:14
Address:
256 ALBEMARLE RD
Speed
limit:
25
Violation
cited:
no
Narrative:
THE OPERATOR OF MV#1 STATED THAT HE WAS TRAVELING N/B DOWN ALBEMARLE RD WHEN HIS VEHICLE FLOATED OFF THE ROADWAY INTO CHEESECAKE BROOKE. THE ROAD WAS COMPLETELY FLOODED AT THE TIME DUE TO HEAVY RAIN. THE VEHICLE WAS ALMOST COMPLETELY SUBMERGED UNDER WATER. THE OPERATOR GOT OUT OF THE VEHICLE THROUGH HIS SUN ROOF BECAUSE HE WAS TRAPPED. THE OPERATOR STATE ED THAT HE WAS NOT INJURED. MV#1 WAS FLOODED INSIDE AND WITH THE CURRENT IT WAS PUSHED UNDER THE FOOT BRIDGE WHICH CAUSED MAJOR DAMAGE TO IT. TRAFFIC RESPONDED AND TOOK PICTURES. TODY'S RESPONDED WITH THE FIRE DEPARTMENT TO LIFT MV#1 OUT OF THE BROOK. MV#1 WAS TOWED TO THE TOW YARD. MEDICS DID NOT RESPOND SO THERE WAS NO PATIENT REFUSAL.
Keywords:
Fire, Pictures, Rain, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3576147
Longitude:
-71.2159572
Location:
Case
number:
Date:
2021-10-10
Time:
16:01
Address:
320 WASHINGTON ST
Speed
limit:
20
Violation
cited:
no
Narrative:
On Sunday, October 10, 2021, at approximately 1601 hrs, while assigned to N494, I responded to 320 Washington St., the Four Points Sheraton, (rear Centre St. side) for a single motorcycle accident ( MV1- MA Reg 2S2136). Upon arrival, the fire and medics were treating the operator of the motorcycle, identified as BASS, Braxton Lee. BASS stated he came off the Mass Pike Eastbound exit, traveled three lanes to very left lane on the Washington St. rotary (EB), and he hit a pot hole in the road. He stated he then lost control of the motorcycle and was thrown over the handlebars crashing onto the sidewalk. The motorcycle skidded the length of the curb until the stair area of the hotel. BASS sustained injuries to his left shoulder, hands, left torso, knees, and the left side of his head. He was transported by Medic 5 to the BI Boston. The motorcycle sustained minor damage and was towed from the scene by Todys. I observed a dip in the left lane where BASS and witness on scene stated he initially lost control of the motorcycle. See attatched photos. Witness statement: MAZZIE, Zach stated he witnessed BASS crash his motorcycle. He stated BASS came off the Mass Pike exit, traveling Eastbound on Washington St., when he proceeded to the left lane, and was thrown from the motorcycle. He stated he saw him hit a bump in the road, at which point he lost control of the bike and crashed, landing on the curb into the fence. He pointed to the area of the bump which I then observed and have included a photo
Keywords:
Crash, Fire, Pictures, Solar
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3563932
Longitude:
-71.1872752
Location:
Case
number:
Date:
2022-04-12
Time:
09:15
Address:
197 CALIFORNIA ST
Speed
limit:
25
Violation
cited:
no
Narrative:
On Tuesday April 12th 2022 at approximately 0915 hours I responded to the area of 197 California Street for a city of Newton fire truck that struck a fire hydrant while responding to an emergency. At the time of the accident the weather was cloudy and the road surface was dry. California Street is owned and maintained by the city of Newton. Upon arrival I spoke with the operator of Newton Fire Engine 1 identified as Joseph Frank. Joseph stated that while attempting to park the fire engine he struck the fire hydrant, causing the fire hydrant to be knocked over and inoperable. Minor damage to the front drivers side of the fire engine was photographed and submitted to the IT Bureau as well as the damaged fire hydrant. No injuries were reported. City of Newton was notified of the damaged hydrant.
Keywords:
Crash, Fire, Pictures
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3651092
Longitude:
-71.1963023
Location:
Case
number:
Date:
2022-05-24
Time:
13:24
Address:
2014 WASHINGTON ST
Speed
limit:
10
Violation
cited:
no
Narrative:
On 524/2022 at approx 1324Hrs while assigned to 497 I responded to the west entrance of Newton Wellesley Hospital for a report of a two car crash. Upon arrival I observed a gray Land Rover Ma Reg 1106 and a white delivery truck Ma reg W13340 connected at the entrance to the rear of NWH, an area that is under construction. I spoke with the owner of the Land Rover, Frederick Camerato who stated he had parked his car in order to pick someone at the hospital up, while it was parked it was struck and dragged by a delivery truck, Ma Reg W13340 being operated by Mohammed Aquas. Aquas stated he was heading to make a delivery to the hospital and the Land Rover was parked in an illegal spot. Construction at the hospital created poor conditions, in addition to multiple vehicles stopped or parked in the fire lane. There were multiple construction trucks parked on access road and on the curb.
Keywords:
Crash, Fire, Hospital
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3306679
Longitude:
-71.2477866
Location:
Case
number:
Date:
2022-06-14
Time:
12:30
Address:
366 BEACON ST
Speed
limit:
30
Violation
cited:
no
Narrative:
On Tuesday 6/14/2022 at approx 1230hrs, while assigned to N496, I responded to 366 Beacon St in Newton for a 3 car MVA. There, operator of MV2 sated that she had neck pain and suffered an injury to her head. Fire and medics responded and evaluated the operator of MV2 who was later transported to NWH. Operator of MV1 states that he was driving WB on Beacon St when the vehicle ahead of him slowed down to take a left. He said he was coming to a stop when he was struck by MV2 from behind. Operator of MV2 states that she was driving WB on Beacon St and when she was struck from behind by MV3. She said that after she was hit she "lost control" and collided with MV1. She stated that her head hit the steering wheel. MV2 was towed by Tody's towing service. Operator of MV3 states that he was travelling WB on Beacon St and noticed an incoming sports car which made him turn his head. When he looked back in front of him he could not stop in time before hitting MV2.
Keywords:
Fire
Dcc:
[]
Report
url:
Image
url:
Latitude:
42.3324686
Longitude:
-71.1744418
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);