NTSB investigations
1,789 cases where the sequence of events included Landing gear collapse.
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.\"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."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 CEN12LA485Accident · No injuriesLimited investigationFinal reportMooney M20E · Englewood, COThe pilot's loss of directional control during landing.NTSB CEN12IA451Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Marysville, OHFatigue failure of the left main wheel assembly on takeoff, which resulted in a loss of directional control and runway excursion.NTSB CEN12CA450Accident · No injuriesData collectionFinal reportCessna 195B · Camdenton, MOThe pilot's loss of directional control on landing, which resulted in a runway excursion.NTSB ERA12CA461Accident · No injuriesData collectionFinal reportCzech Sport Piper Sport · Sanford, METhe student pilot’s inadequate landing flare and improper recovery from a bounced landing.NTSB CEN12LA458Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Egeland, NDThe partial loss of engine power for reasons that could not be determined during postaccident examinations.NTSB ERA12LA441Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Auburn, ALThe airplane owner’s failure to have maintenance personnel comply with an aircraft manufacturer's service bulletin to require engine mount inspections for fatigue cracks, which resulted in an undetected fatigue crack, the engine mount failing, and the nose…NTSB CEN12FA425Accident · Minor injuriesField investigationFinal reportPiper PA-28RT-201 · Mesquite, TXThe failure of the right landing gear to fully extend, due to a combination of corrosion, inadequate lubrication, and a misadjusted gear-down limit switch. Contributing to the accident was the pilot's failure to perform the emergency landing gear extension…NTSB ERA12LA431Accident · No injuriesLimited investigationFinal reportLeder John A Leder Velocity XL RG · Thomson, GASeparation of the nose landing gear due to a preexisting fatigue crack caused by an earlier shimmy event and the subsequent incorrect installation of the shimmy dampener.NTSB ERA12CA424Accident · No injuriesData collectionFinal reportBeech 58 · Atlanta, GAThe pilot's inadvertent retraction of the landing gear during the landing.NTSB CEN12CA416Accident · Minor injuriesData collectionFinal reportMichael A Howard Dominator · Omaha, NEA nosewheel shimmy on takeoff, which resulted in the failure of the nosewheel landing gear and a loss of control.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 ERA12CA408Accident · Minor injuriesData collectionFinal reportCessna 195B · Millington, TNThe pilot's failure to maintain directional control during the landing roll.NTSB ERA12CA404Accident · No injuriesData collectionFinal reportCessna 172K · Tupelo, MSThe pilot's improper recovery from a bounced landing.NTSB CEN12CA375Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Ipswich, SDThe pilot's failure to abort the takeoff, which resulted in a runway excursion.NTSB CEN12LA374Accident · No injuriesLimited investigationFinal reportYakovlev Yak-52 · Loveland, COThe pilot’s inadvertent closure of the pneumatic system valve, which resulted in the nose landing gear not fully extending before landing. Contributing to the accident was the pilot's reliance on the mechanical landing gear position indicators instead of the…NTSB ERA12LA394Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAA failure of the No. 2 cylinder connecting rod due to a lack of lubrication, which resulted in a total loss of engine power.NTSB WPR12LA253Accident · Minor injuriesLimited investigationFinal reportCessna 172B · San Andreas, CAA loss of engine power in cruise flight for reasons that could not be determined because a postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB WPR12LA262Accident · No injuriesLimited investigationFinal reportCessna 120 · Smith Valley, NVThe failure of the right main landing gear strut due to corrosion-induced fatigue, which resulted in a runway excursion.NTSB CEN12CA392Accident · No injuriesData collectionFinal reportCessna P210N · Detroit, MIThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB CEN12WA364Incident · No injuriesForeign investigationPiper PA23 · Igualada, Spain, SpainOn June 9, 2012 about 1000 UTC, a Spanish registered Piper PA-23-250, EC-GCF, sustained minor damage when the left main landing gear collapsed during landing at Igualada Aerodrome, Spain. The pilot crew and five passengers on board the airplane were not…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 WPR12LA261Accident · No injuriesLimited investigationFinal reportPiper PA46R-350T · Cameron Park, CAThe fatigue failure of the nose landing gear actuator attach foot during the landing roll. Contributing to the accident was the non-compliance with the manufacturer’s service bulletin.NTSB CEN12LA310Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Humnoke, ARThe pilot’s failure to attain the proper touchdown point, which resulted in a landing undershoot.NTSB ANC12CA039Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Talkeetna, AKThe pilot's failure to maintain directional control of the tailwheel-equipped airplane during landing, which resulted in a ground loop. Contributing to the accident was the flight instructor's failure to adequately monitor the landing.NTSB CEN12LA339Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Applegate, MIThe pilot’s decision to attempt to take off from an unimproved field, which resulted in a collapsed nose landing gear.NTSB DCA12WA073Accident · No injuriesForeign investigationConvair 440 · Ciudad de Guatemala, GuatemalaNTSB CEN12LA300Accident · No injuriesLimited investigationFinal reportCessna T210K · Midland, TXThe failure of the right main landing gear to fully extend before landing due to a bent downlock adjustment screw.NTSB ERA12LA315Accident · No injuriesLimited investigationFinal reportBerry Dean Glasair I · Columbus, GAThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and collision with a runway sign. Contributing to the accident was the pilot’s lack of experience in the airplane make and model, resulting in and his…NTSB CEN12CA277Accident · No injuriesData collectionFinal reportCessna 152 · San Antonio, TXThe student pilot's misjudgment of the landing flare, which resulted in a hard/bounced landing and subsequent impact with the runway.NTSB CEN12CA263Accident · No injuriesData collectionFinal reportCampbell David Legacy · Durango, COThe pilot’s improper flare and subsequent aerodynamic stall, which resulted in a hard landing.NTSB WPR12CA192Accident · No injuriesData collectionFinal reportCessna 195B · Sacramento, CAThe pilot’s failure to maintain directional control during the landing roll while landing with a gusting wind.NTSB ANC12TA035Accident · No injuriesFinal reportPiper PA-18-150 · Paxon, AKA separation of the right main landing gear suspension strut assembly due to overstress, which resulted in the collapse of the main landing gear while landing.NTSB WPR12FA193Accident · No injuriesField investigationFinal reportCessna 560XL · Eugene, ORAn uncommanded landing gear retraction after touchdown for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN12CA272Accident · No injuriesData collectionFinal reportTucker-Hurni Starduster SA-300 · Vidalia, LAThe failure of the airplane’s right main landing gear due to a pre-existing fatigue crack and corrosion.NTSB DCA12WA161Incident · No injuriesForeign investigationBoeing 737 · Karachi, PakistanOn April 22, 2012, at about 12:35 local time, a Shaheen Boeing 737-400, registration number AP-BJN, operating as flight NL122 from Islamabad (ISB) to Karachi (KHI), Pakistan had the left main landing gear collapse upon landing KHI. It is reported that there…NTSB CEN12LA259Accident · No injuriesLimited investigationFinal reportMoody-Siple A · Stuttgart, ARThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12LA299Accident · No injuriesLimited investigationFinal reportCessna 210 · Gatlinburg, TNFailure of the nose landing gear down pressure hose, which resulted in the main landing gear being unable to lock and collapse of the main landing gear during the landing roll.NTSB ERA12CA283Accident · No injuriesData collectionFinal reportCessna 150M · Cedartown, GAThe pilot’s failure to maintain directional control during takeoff.NTSB ERA12LA287Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Cross Keys, NJThe pilot's failure to maintain control of the airplane during landing, which resulted in the overstress and subsequent failure of the right main landing gear assembly.NTSB WPR12LA174Accident · No injuriesLimited investigationFinal reportWillerton Vans RV6A · Sequim, WAThe pilot's inadequate landing flare, which resulted in a hard landing.NTSB CEN12CA233Accident · No injuriesData collectionFinal reportCessna 210H · Marienthal, KSThe pilot's inadequate compensation for the wind during landing.NTSB CEN12LA230Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Isabel, SDThe partial loss of engine power due to carburetor ice.NTSB ERA12LA296Accident · No injuriesLimited investigationFinal reportJones SA105 · New Smyrna Beach, FLThe failure of the nose landing gear wooden attachment/support structure, which resulted in collapse of the nose landing gear during taxi. Contributing to the accident was the improper design of the nose landing gear attachment structure.NTSB CEN12LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Arcola, TXA total loss of engine power during landing approach for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA214Accident · No injuriesLimited investigationFinal reportCessna 172S · Midlothian, TXThe pilot's failure to maintain directional control during the landing roll.NTSB CEN12CA215Accident · No injuriesData collectionFinal reportCessna 441 · Battle Creek, MIThe maintenance technician did not remove the tow bar prior to the flight.NTSB WPR12CA142Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jean, NVThe student pilot did not maintain directional control during the landing roll.NTSB CEN12CA225Accident · No injuriesData collectionFinal reportBeech V35B · Malvern, ARThe pilot did not fly a stabilized approach and elected not to perform a go-around, which resulted in a runway excursion.NTSB ERA12CA232Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Dover, TNThe pilot's failure to maintain directional control during takeoff in gusty wind conditions, which resulted in a collision with an object and a landing gear collapse during the subsequent landing.NTSB ERA12CA215Accident · No injuriesData collectionFinal reportCessna 140A · Mooresville, NCThe separation of the left rudder cable turnbuckle and the pilot’s subsequent loss of directional control during landing.