NTSB investigations, IL
193 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 GAA18CA305Accident · Minor injuriesData collectionFinal reportZS Delta-Bielsko Wroclaw SZD 36 A Cobra 15 · Hammond, ILThe pilot’s loss of directional control during an off-airport landing and his subsequent failure to maintain clearance from power pole guy wires.NTSB CEN18LA205Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Union, ILThe pilot’s medical impairment at the time of the accident, which resulted in a collision with power lines off the end of the runway.NTSB GAA18CA157Accident · No injuriesData collectionFinal reportCessna 182 · Rockford, ILThe pilot’s unnecessary action during the approach, which resulted in a hard landing.NTSB GAA18CA110Accident · Minor injuriesData collectionFinal reportHelicopteres Guimbal Cabri G2 · Cahokia, ILThe student pilot's failure to maintain yaw control while landing in gusting crosswind conditions and the flight instructor's delayed remedial action.NTSB CEN18LA047Accident · Serious injuriesLimited investigationFinal reportBeech C90 · Rockford, ILThe pilot's inadequate preflight planning and his decision to depart without the required fuel reserve, which resulted in fuel exhaustion during a night approach and subsequent loss of engine power.NTSB CEN18LA041Accident · No injuriesLimited investigationFinal reportCessna 182S · Bolingbrook, ILThe pilot’s failure to maintain directional control during takeoff.NTSB GAA18CA012Accident · No injuriesData collectionFinal reportEurocopter Deutschland MBB BK 117 · Canton, ILThe flight instructor's incorrect cyclic control during a hover, which resulted in a hard landing.NTSB CEN18LA008Accident · No injuriesLimited investigationFinal reportPiper PA 34-220T · Sugar Grove, ILA partial loss of engine power for reasons that could not be determined based on the available information.NTSB GAA17CA566Accident · No injuriesData collectionFinal reportLet L 23 Super Blanik · Hampshire, ILThe pilot’s improper landing flare and subsequent failure to maintain directional control during landing.NTSB CEN17LA333Accident · Serious injuriesLimited investigationFinal reportGulfstream American AA 5B · Carbondale, ILThe failure of the propeller due to fatigue as a result of improper installation by unknown maintenance personnel at some point during the life of the propeller.NTSB GAA17CA398Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Pocahontas, ILThe helicopter pilot’s miscommunication with the ground crewmember during reloading operations, which resulted in a takeoff with the filler hose attached to the helicopter and subsequent impact with a truck.NTSB GAA17CA461Accident · No injuriesData collectionFinal reportCessna A188B · Kankakee, ILThe pilot’s improper landing flare, which resulted in a bounced landing, and his subsequent incorrect brake application, which led to the loss of directional control.NTSB CEN17LA180Accident · Serious injuriesLimited investigationFinal reportBrokaw Bergon F Zodiac · Orangeville, ILThe total loss of engine power due to fuel starvation.NTSB GAA17CA265Accident · No injuriesData collectionFinal reportRotorcraft Development OH-58A+ · Waterloo, ILThe pilot’s failure to see and avoid transmission wires while maneuvering at a low altitude.NTSB CEN17LA145Accident · No injuriesLimited investigationFinal reportCessna 120 · Columbia, ILThe partial loss of engine power due to carburetor icing.NTSB CEN16LA329Accident · Serious injuriesLimited investigationFinal reportCollins RV6A · Pekin, ILThe pilot's failure to latch the canopy before takeoff, and his subsequent distraction and failure to maintain control while attempting to close the open canopy, which resulted in an aerodynamic stall.NTSB CEN16CA321Accident · Serious injuriesData collectionFinal reportContinental Copters Tomcat MK6B · Sparland, ILThe pilot's improper fuel management, which resulted in fuel exhaustion, a total loss of engine power, and a forced landing.NTSB CEN16LA297Accident · No injuriesLimited investigationFinal reportCessna 172F · Newark, ILThe failure of the No. 4 cylinder exhaust valve, which resulted in a partial loss of engine power and a forced landing. Contributing to the valve failure and loss of engine power was the extended time since the last overhaul.NTSB GAA16CA397Accident · No injuriesData collectionFinal reportOlmsted Charles A RV · Dwight, ILThe pilot's delayed action to perform an aborted landing, which resulted in a nose over and substantial damage to the firewall, fuselage, and empennage.NTSB CEN16LA246Accident · No injuriesLimited investigationFinal reportCessna 172 · Wonder Lake, ILThe flight instructor's inadequate supervision and lack of remedial action due to his diverted attention to a radio call, which resulted in the airplane landing short of the runway.NTSB CEN16LA235Accident · No injuriesLimited investigationFinal reportCessna 182 · Kankakee, ILAa total loss of engine power due to fuel starvation, which resulted from the low level of fuel unporting during a rapid spiraling descent.NTSB CEN16LA218Accident · No injuriesLimited investigationFinal reportAeronca 7AC · East St. Louis, ILA total loss of engine power due to fracture of the piston pin, which led to fatigue cracking and eventual fracture of the adjacent connecting rod.NTSB CEN16FA214Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Marion, ILThe pilots' failure to maintain adequate airspeed while executing a simulated engine failure and landing maneuver, which resulted in the wing's critical angle of attack being exceeded and a subsequent aerodynamic stall and loss of control.NTSB GAA16CA296Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Cahokia/St. Louis, ILThe flight instructor's delayed remedial action and his failure to remain vigilant as the helicopter entered the weathercock stability region, in gusting wind conditions, resulting in loss of tail rotor effectiveness and ground impact.NTSB GAA16CA277Accident · Minor injuriesData collectionFinal reportPiper PA 24 · Loda, ILThe pilot's failure to properly calculate the fuel consumption rate and to properly monitor the fuel status in flight, which resulted in a total loss of engine power due to fuel exhaustion and a subsequent forced landing, runway excursion, and impact with a…NTSB GAA16CA280Accident · No injuriesData collectionFinal reportStaudacher S 300 · Prospect Heights, ILThe pilot's incorrect pitch control during the landing, which resulted in a hard bounced landing, and subsequent left main landing gear collapse, a runway excursion, and a collision with a runway sign.NTSB GAA16CA153Accident · Serious injuriesData collectionFinal reportBarnes Thomas A Vans · Bolingbrook, ILThe pilot's failure to maintain direction control during the takeoff roll, which resulted in runway excursion, collision with terrain, and nose over.NTSB CEN15LA402Accident · Serious injuriesLimited investigationFinal reportViking Dragonfly · Freeport, ILThe airplane’s degraded climb performance due to its being over its maximum gross weight and a hole in the engine exhaust.NTSB CEN15LA341Accident · Serious injuriesLimited investigationFinal reportHughes 269B · Atkinson, ILThe pilot's improper decision to intentionally fly the helicopter at a low altitude and his subsequent failure to maintain clearance from a power line.NTSB CEN15LA335Accident · No injuriesLimited investigationFinal reportAir Tractor AT 502B · Virden, ILThe pilot’s failure to establish a proper airspeed during takeoff with the airplane near its maximum gross weight and with a quartering tailwind.NTSB CEN15LA323Accident · No injuriesLimited investigationFinal reportCessna 182B · Fults, ILThe malfunction of the flap assembly, which resulted in a restriction of aileron control. Contributing to the accident was maintenance personnel’s inadequate inspection of a corroded flap control cable.NTSB GAA15CA183Accident · No injuriesData collectionFinal reportCessna 180 · Cahokia, ILThe pilot's failure to maintain directional control during the landing roll which resulted in a ground loop.NTSB GAA15CA129Accident · No injuriesData collectionFinal reportLancair ES - NO Series · Hampshire, ILThe failure of the brake master cylinder which resulted in a loss of brake pressure and the subsequent loss of directional control during the landing roll.NTSB CEN15LA198Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Dunlap, ILA loss of main rotor rpm for reasons that could not be determined during postaccident examinations.NTSB CEN15LA177Accident · No injuriesLimited investigationFinal reportErcoupe 415 C · St Jacob, ILThe loss of engine power during the go-around due to fuel contamination.NTSB CEN15CA151Accident · No injuriesData collectionFinal reportCessna 172P · Kankakee, ILThe student pilot's improper flight control inputs resulting in the loss of control during the landing flare.NTSB CEN15LA068Accident · Serious injuriesLimited investigationFinal reportRans S-14 · Kewanee, ILThe pilot’s failure to maintain airspeed during the final approach, which resulted in a stall/mush. Contributing to the accident was the pilot’s failure to obtain training in the pusher-type airplane.NTSB CEN15FA048Accident · 1 fatalField investigationFinal reportAero Commander 500 B · Chicago, ILThe pilot's failure to maintain airspeed while attempting to return to the airport after a reported engine problem, which resulted in an aerodynamic stall/spin.NTSB CEN15FA009Accident · 3 fatalField investigationFinal reportRaytheon 58 · Palos Hills, ILThe pilot's loss of airplane control due to spatial disorientation while operating in night, instrument meteorological conditions.NTSB CEN14CA490Accident · Serious injuriesData collectionFinal reportBuckeye Dream · Monee, ILThe pilot's failure to see and avoid power lines while maneuvering low to the ground, which resulted in a collision and loss of control.NTSB CEN14CA464Accident · No injuriesData collectionFinal reportAir Tractor AT 502B · Colusa, ILThe pilot did not maintain control of the airplane during takeoff from a grass strip. Contributing was the airplane being loaded beyond its capability for the runway.NTSB CEN14LA423Accident · 1 fatalLimited investigationFinal reportBell 47G 5 · Mansfield, ILThe pilot's failure to maintain clearance from power lines during low-altitude flight in gusting wind conditions following his use of a sedating medication.NTSB CEN14LA408Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Decatur, ILDebris in the fuel system, which resulted in fuel starvation and a subsequent loss of engine power.NTSB CEN14LA349Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-502 · Carthage, ILThe airplane’s inability to climb out of ground effect, which resulted from the pilot using a lower power setting than needed for takeoff due to the mechanic’s installation of the wrong engine torque gauge.NTSB CEN14LA316Accident · 1 fatalLimited investigationFinal reportGrazhopper Trike · Ottawa, ILThe noncertificated pilot’s improper decision to operate the powered-parachute at low altitude through mist in a confined area while he was impaired by multiple sedating medications, which resulted in his loss of control of the parachute and subsequent impact…NTSB CEN14LA309Accident · No injuriesLimited investigationFinal reportSchumacher Challenger II · St. Joesph, ILThe total loss of engine power due to a lack of lubrication following the in-flight failure of the mechanical oil injection pump. Contributing to the accident was the temporary obscuration of the pilot's forward visibility due to sun glare during the forced…NTSB CEN14CA289Accident · No injuriesData collectionFinal reportCessna 182A · Valmeyer, ILThe inadvertent deployment of the skydiver's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.NTSB CEN14LA196Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · West Chicago, ILThe failure of the nose gear actuator attachment to the engine mount due to overstress, which resulted in the loss of directional control during landing.NTSB CEN14LA134Accident · No injuriesLimited investigationFinal reportCessna 172K · Milan, ILThe pilot’s delayed use of carburetor heat while operating the airplane in atmospheric conditions conducive to carburetor icing, which resulted in a total loss of engine power due to carburetor icing during a short final approach.NTSB CEN14CA017Accident · No injuriesData collectionFinal reportRobinson R22 - Beta · Chicago, ILThe flight instructor's failure to take remedial action in a timely manner.