NTSB investigations, IL
34 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 5 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 3 |
| 2020 | 2 |
| 2021 | 2 |
| 2026 | 1 |
Where
Open the mapLatest cases
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\" = '094' 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" = '094' 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 CEN26LA229Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Carbondale, ILThe flight instructor’s delayed remedial action during the student pilot’s miscalculated landing flare which resulted in a hard landing and the nose landing gear collapsing.NTSB CEN22LA043Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wheeling, ILThe student pilot’s improper landing flare, which resulted in a hard landing. Contributing was the student pilot’s self-induced pressure to land after being admonished by the controller.NTSB CEN22LA020Accident · No injuriesClass 4 · LimitedFinal reportHall Terrence / Hall Cathie Cruzer CH-750 · Benton, ILThe pilot’s improper landing flare, which resulted in a hard landing and the nose landing gear collapsing.NTSB CEN21LA058Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Waukegan, ILThe pilot’s failure to maintain directional control during takeoff with a crosswind that resulted in a ground loop and impact with terrain.NTSB CEN20CA333Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters Carbon CUB EX · Marion, ILThe pilot's failure to attain/maintain directional control during landing that resulted in a ground-loop and collision with terrain.NTSB GAA17CA499Accident · No injuriesData collectionFinal reportCessna 170 · Rochelle, ILThe pilot’s failure to maintain directional control during landing with a tailwind.NTSB CEN17LA309Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-802A · Galesburg, ILA total loss of engine power due to the fracture of a single 1st stage compressor rotor airfoil in high-cycle fatigue as a result of the erosion and thinning of the airfoil's leading edge. Contributing to the fractured airfoil and loss of engine power was the…NTSB GAA17CA452Accident · No injuriesData collectionFinal reportPiper PA28 · St. Joseph, ILThe pilot’s improper landing flare, which resulted in the nose landing gear collapsing and subsequent loss of directional control.NTSB GAA17CA109Accident · No injuriesData collectionFinal reportPiper PA28R · Kewanee, ILThe pilot’s failure to extend the landing gear during the approach to land.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 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 CEN15LA147Accident · No injuriesLimited investigationFinal reportPiper PA 31-350 · Chicago, ILThe collapse of the nose and right main landing gears during landing for reasons that could not be determined because examination of the landing gear system revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN15CA037Accident · No injuriesData collectionFinal reportCessna 162 · Hinckley, ILThe student pilot's relaxing of elevator back pressure during the landing roll that induced a porpoise, loss of control, and collapsing of the nose wheel.NTSB CEN15CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Quincy, ILThe pilot's improper fuel management, which resulted in the total loss of power to both engines due to fuel exhaustion and the subsequent forced landing in a field. Also causal to the accident was the pilot's decision to use the slower emergency hand-pump to…NTSB CEN14CA352Accident · No injuriesData collectionFinal reportBeech 35 33 · Mt. Vernon, ILThe pilot's failure to ensure the landing gear was extended into the fully locked position.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 CEN14LA127Accident · No injuriesLimited investigationFinal reportPiaggio P180 - Avanti II · Springfield, ILThe pilot's decision to reengage the hydraulic system following the successful extension of the landing gear using the emergency extension procedures. Contributing to the accident was the failure of the directional control valve in the gear-up position and…NTSB CEN13LA398Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctls · Sandwich, ILThe pilot’s failure to recognize the formation of carburetor ice during cruise descent and apply carburetor heat, which resulted in the total loss of engine power.NTSB CEN12LA456Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Metropolis, ILLanding gear collapse for reasons that could not be determined because testing could not replicate the problem.NTSB CEN12CA363Accident · No injuriesData collectionFinal reportHoac-Austria HK 36R Super Dimona · New Douglas, ILThe pilot’s improper landing flare and inadequate recovery from a bounced landing.NTSB CEN11LA596Accident · No injuriesLimited investigationFinal reportSuminski Walter M Jabiru SP · Columbia, ILSeparation of the right main wheel during landing rollout for undetermined reasons.NTSB CEN11FA220Accident · No injuriesField investigationFinal reportMooney M20J · Romeoville, ILThe collapse of the left main landing gear during the landing roll for undetermined reasons.NTSB CEN11LA178Accident · No injuriesLimited investigationFinal reportBeech A36 · Danville, ILThe pilot's failure to maintain directional control during the landing roll.NTSB CEN11FA144Accident · Minor injuriesField investigationFinal reportGates Learjet 35A · Springfield, ILThe pilot’s decision to conduct an instrument approach in icing conditions without the anti-ice system activated, contrary to the airplane flight manual guidance, which resulted in an inadvertent aerodynamic stall due to an in-flight accumulation of airframe…NTSB CEN10LA506Accident · No injuriesLimited investigationFinal reportAshcraft DR107 · Aurora, ILThe low cycle fatigue failure of the tail wheel spring during landing.NTSB CEN10CA215Accident · No injuriesData collectionFinal reportMurray Starlite · Shelbyville, ILThe corrosion of the left landing gear rotor and brake, which resulted in the loss of directional control during the landing rollout, and the pilot's inadequate preflight inspection.NTSB CEN10LA143Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · DeKalb, ILThe collapse of the landing gear during landing due to the company's improper maintenance practices and the pilot's decision to take off with an overextended landing gear strut.NTSB CEN09LA285Accident · Serious injuriesLimited investigationFinal reportRockwell International 112A · Metropolis, ILA total loss of engine power for undetermined reasons.NTSB CEN09CA139Accident · No injuriesData collectionFinal reportCessna 172I · Rockford, ILThe pilot's inability to maintain directional control during the landing roll after contacting a low-lying snow bank that was obscured by drifting snow.NTSB ENG08IA042IncidentIncident investigationFinal reportBoeing 737 · Chicago, ILThe right nose landing gear axle's failure from intergranular and fatigue cracking due to an earlier bearing failure.NTSB CHI08CA255Accident · No injuriesData collectionFinal reportCessna 182C · Sparta, ILThe pilot's inadequate preflight/planning which resulted in the failure to assure an adequate fuel supply for the flight and the improper flare during the landing. Contributing to the accident was the ditch that the airplane contacted.NTSB CHI08CA179Accident · No injuriesData collectionFinal reportCessna 195 · Lansing, ILThe pilot's inadequate compensation for the gusting crosswind condition during landing. Contributing to the accident was the strong gusting crosswind condition.NTSB CHI08LA169Accident · No injuriesLimited investigationFinal reportMorrison E-Racer · Aurora, ILAn undetermined failure in the high-pressure fuel system, and the subsequent loss of engine power and in-flight fire. Contributing to the accident were the pilot's restricted visibility due to the smoke in the cockpit, failure of the aileron control during…NTSB CHI08LA070Accident · No injuriesLimited investigationFinal reportBeech 58 · Cahokia, ILMaintenance personnel's improper replacement of the landing gear leg brace assembly which subsequently failed to keep the landing gear in the locked position.