NTSB investigations, IL
86 cases where the first occurrence was “In flight collision with object”.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220)
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI90DEE07Accident · Minor injuriesFinal reportSchweizer G-164B · Deer Grove, ILThe pilot's inadequate visual lookout, resulting in collision with a power line.NTSB CHI90DEV04Accident · No injuriesFinal reportGrumman G-164B · Princeton, ILThe pilot-in-command's failure to maintain adequate clearance from obstacles during flight at low altitude, resulting in wire strike.NTSB CHI90LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wonder Lake, ILThe pilot's inadequate compensation for wind conditions, and his faiiure to maintain proper altitude on final approach to land. Factors related to the accident were: the trees & snowbank.NTSB CHI90LA022Accident · No injuriesLimited investigationFinal reportCessna 172 · Lansing, ILThe pilot's inadvertent selection of unsuitable terrain (taxiway/construction area). The steel marker poles contributed to the aircraft damage.NTSB CHI89FA112Accident · Minor injuriesField investigationFinal reportHughes 269C · Lockport, ILImproper flight technique by the PIC during a takeoff from a confined area.NTSB CHI89DEE02Accident · Minor injuriesFinal reportAeronca 7AC · Marseilles, ILPic's overconfidence in the accident aircraft's climb performance as he attempted to take off up hill and over wires.NTSB CHI89FA038Accident · 2 fatalField investigationFinal reportCessna T210N · Springfield, ILThe pilot's improper IFR procedure during an ILS approach in below minimum conditions, and the pilot's failure to proceed to an alternate destination. Contributing factors were the adverse weather conditions.NTSB CHI89LA012Accident · No injuriesLimited investigationFinal reportCessna 182 · Sparta, ILNTSB CHI88LA229Accident · No injuriesLimited investigationFinal reportGrumman AA-5B · Schaumburg, ILDuring an attempted night landing at an airport with inoperative pilot-controlled runway lights, the pilot made a series of low passes (approximately 6 passes) before trying to land. The aircraft collided with the top of a tree located slightly to the left of…NTSB CHI88LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · St. Jacob, ILDuring the initial climbout the student pilot failed to attain sufficient altitude to clear the power lines located off of the departure end of the runway. When the pilot realized that he would not be able to clear the power lines, he elected to attempt to…NTSB CHI88FA090Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Quincy, ILDescent below the dh by the pilot in command during an instrument approach into known adverse weather rather then proceeding to a suitable alternate destination.NTSB CHI88LA060Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, ILPilot-in-command's misjudged flare and his failure to attain a proper descent rate.NTSB CHI88LA034Accident · No injuriesLimited investigationFinal reportCessna 172K · Staunton, ILDuring the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot…NTSB CHI87LA130Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Lansing, ILDuring an attempted go-around, the right wing struck a tree, the left wing then contacted a building and the aircraft impacted in a freshly plowed field. Witnesses report the aircraft was high and fast and drifting to the right of runway centerline. Also…NTSB CHI87FA040Accident · 4 fatalField investigationFinal reportMooney M20E · Hanna City, ILThe aircraft struck power lines and crashed two miles from the end of the runway on final approach ground track after being cleared for an ILS approach. The accident occurred at the end of a three leg cross-country flight from the Bahamas which began aprx 8…NTSB CHI87LA019Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Bethalto, ILThe pilot attempted an ILS approach into an airfield (runway 29) that was reporting a zero foot obscured ceiling with 1/16 mile visibiltiy and fog. He stated that he became confused during the last portion of the approach and was beginning a missed approach…NTSB CHI87FA021Accident · 1 fatalField investigationFinal reportCessna 182P · Goreville, ILThe acft crashed and burned following a collision with a guy-wire supporting a micro-wave tower. The plt had initiated the flt in MVFR weather and continued the VFR flt into IMC conditions. The crash site was located adjacent to interstate hwy 57 and…NTSB CHI86LA220Accident · No injuriesLimited investigationFinal reportCessna 152 · Dwight, ILThe tail of the aircraft struck the cab of a truck while on final approach. The CFI stated that, as they were passing over the road at the approach end of the runway, the aircraft entered a downdraft and the empennage struck the truck which was approaching…NTSB CHI86FA068Accident · 1 fatalField investigationFinal reportCessna 177RG · Valley View, ILThe plt was conducting a low pass, 40 ft AGL, on a river and struck a power line crossing his flt path. The strike caused loss of control and the acft impacted on the frozen surface of the river.NTSB CHI86FA029Accident · 2 fatalField investigationFinal reportCessna 172N · Mt Carmel, ILAccording to the survivor, the plt & 2 pax all had a beer, then went to the arpt. After taking off at night, the plt flew over Mt Carmel, then flew toward his home. He elected to make a low pass over his house. During the pass, the acft struck a tree & some…NTSB CHI86FA013Accident · 1 fatalField investigationFinal reportCessna 170A · Murphysboro, ILThe plt took off in marginal VMC in an acft placarded for 'day VFR only'. Aprx 32 minutes after takeoff the acft collided with trees and descended to ground impact. A hunter in the local area at the time of the accident reported hearing the acft eng sound…NTSB CHI85FEV03Accident · 1 fatalFinal reportCessna 172 · Sweetwater, ILThe acft was observed flying at low alt parallel to a hiway before colliding with a tree before impacting the ground. The plts wife said that the plt had been under extreme stress for a few months and had not been to bed for 2 days preceding the accident. She…NTSB CHI85LA312Accident · Minor injuriesLimited investigationFinal reportFrank H Marchetti Avenger Gyro Plane · Shelbyville, ILThe gyroplane was running up on the end of the rwy when the varieze landed on top of him, striking thr rotor system. The varieze flew a non=std flt pattern & did not make a radio call in the traffic pattern.NTSB CHI85LA191Accident · No injuriesLimited investigationFinal reportCessna A188B · Virden, ILDuring aerial application, the pilot attempted to pass over a set of low wires and under high tension lines. The wires are 300 ft. apart horizontally. The prop contacted the high tension lines and the acft was destroyed on contact with the ground.NTSB CHI84LA345Accident · Minor injuriesLimited investigationFinal reportHughes 300/269C · Freeport, ILThe helicopter was being used to give sight seeing rides at albertus airport. The two pax onboard asked the plt to provide an exciting ride. The plt stated that he intended to demonstrate an autorotation to a corn field and make a pwr recovery. After flaring…NTSB CHI84FA315Accident · 1 fatalField investigationFinal reportPiper PA-32RT-300 · Sandwich, ILPilot attempted to takeoff with 7 passengers in a six place acft. The acft was 187 lbs over gross wt and 1.54 inches out of aft c.g. the pilot tookoff downwind and collided with trees at the end of the rwy. There was a post crash fire.NTSB CHI84LA300Accident · No injuriesLimited investigationFinal reportCessna 177 · Columbia, ILPilot stated that she landed the aircraft approximately one third of the way down the runway. She continued to stated the acft ballooned so she decided to go-around, during which she retracted the flaps to 1/4. The pilot operating handbook states that the…NTSB CHI84LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Greenville, ILThe plt received a weather briefing the night before the accident and did not have it updated on the day of the accident. The acft was descended below the mda during the approach in fog and collided with high tension lines.NTSB CHI84LA092Accident · No injuriesLimited investigationFinal reportBeech B-19 · Crystal Lake, ILThe acft hit a snow bank during an approach for landing. The plt added power and made a go-around. The CFI took control of the acft and made the final landing when the main landing gear collapsed.NTSB CHI83LA342Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Camp Point, ILThe plt had just completed a swath run. As he approached a road he pulled up to avoid a car, then attempted to descend below power lines & in so doing collided with a stop sign. The acft cartwheeled & landed inverted in a bean field.NTSB CHI83LA227Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Elgin, ILThe acft collided with the roof of a trailer truck during an approach to land over a toll road. The collision separated the left main gear from the acft and damaged the other two landing gear. The impact left two depressions about 2 inches deep in the edge of…NTSB CHI83LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Ridott, ILThis was the pilot's first operation on the 1320 ft strip. After touchdown, he encountered poor braking action and attempted to go around. When he realized he had insufficient runway remaining, he aborted the go-around. Subsequently, the aircraft collided…NTSB CHI83LA003Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Seneca, ILWhile landing on a 2300 ft runway, the plane touched down about 1000 to 1200 ft beyond the approach end. The pilot felt that there was insufficient room to stop safely, so she initiated a go-around. The pilot was unable to attain enough altitude to clear…NTSB CHI82DA268Accident · No injuriesFinal reportPiper PA-38 · Antioch, ILThe pilot initiated a soft field takeoff from a 2200 ft, wet, grass runway. After becoming airborne, he lowered the nose of the aircraft to increase his airspeed. The pilot stated that the aircraft failed to climb as expected and would not clear boats that…NTSB CHI82FA228Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201 · Washington, ILDuring takeoff, the aircraft struck a pile of lumber that was 62 ft from the departure end of the runway. Two witnesses believed that the pilot did not use all off the runway for takeoff. One witness estimated that the pilot began the takeoff about 150 ft…NTSB CHI82DA154Accident · Minor injuriesFinal reportCessna 182 · Ottawa, ILThe aircraft collided with a truck off the approach end of the runway during a low, no flap approach. According to the pilot a caution sign for vehicles using the road had been removed by vandals and he did not see the truck because of his low approach. The…