NTSB investigations
649 cases where the defining event was 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '094') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '094') 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 ERA14IA019Incident · No injuriesIncident investigationFinal reportPiper PA 46 350P · Tallahassee, FLThe failure of the nose landing gear (NLG) actuator attachment bolt due to fatigue for reasons that could not be determined during postincident examination, which resulted in the NLG collapsing during landing.NTSB CEN13WA560Accident · No injuriesForeign investigationBeech 76 - NO Series · Dublin, IrelandOn September 20, 2013, at 1703 hours universal coordinated time, a Beech model 76 Duchess, Ireland registration EI-BUN, was involved in a runway excursion after landing at the Weston Airfield (EIWT), Dublin, Ireland. The flight instructor and pilot receiving…NTSB WPR13CA413Accident · No injuriesData collectionFinal reportCessna T310R · San Luis Obispo, CAThe pilot's inadvertent action of retracting the landing gear instead of the flaps during the landing roll, which resulted in the right main landing gear collapsing.NTSB WPR13CA403Accident · No injuriesData collectionFinal reportMaule M-7-260C · Nashua, MTThe pilot's failure to maintain clearance from a berm during the takeoff, which resulted in a loss of directional control.NTSB ERA13LA398Accident · No injuriesLimited investigationFinal reportCessna 210J · Fort Myers, FLThe failure of the landing gear hydraulic power pack system to provide sufficient pressure to lock the main landing gear in the down position. Contributing to the accident was the improper maintenance and inspection of the landing gear system, the pilot’s…NTSB DCA13FA148Accident · No injuriesField investigationFinal reportBeech 1900D · Telluride, COFailure of the left main landing gear actuator internal lock to engage in the locked position for undetermined reasons.NTSB WPR13LA382Accident · No injuriesLimited investigationFinal reportCessna 206 · Boise, IDThe mechanical failure of the nose landing gear for reasons that could not be determined because impact damage prevented a complete examination.NTSB ERA13CA371Accident · No injuriesData collectionFinal reportCessna 172S · Manassas, VAThe student pilot’s improper recovery from a bounced landing.NTSB ERA13CA384Accident · No injuriesData collectionFinal reportCessna 172S · Middletown, DEThe student pilot’s improper recovery from a bounced landing.NTSB ERA13LA365Accident · No injuriesLimited investigationFinal reportFetterman Lanny R Firestar II · Numidia, PAA fatigue failure of the right main landing gear wheel axle attachment bracket, which resulted in a nose-over during a precautionary landing.NTSB WPR13LA349Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Billings, MTThe pilots’ inadequate landing flare, which resulted in a hard landing and collapse of the left main landing gear.NTSB WPR13LA319Accident · No injuriesLimited investigationFinal reportCessna T210K · Phoenix, AZThe collapse of the left main landing gear due to a broken gear tooth in the landing gear actuator.NTSB WPR13CA271Accident · No injuriesData collectionFinal reportCessna T210N · Salmon, IDThe pilot's decision to land on a wet grass airstrip, which resulted in a main landing gear collapse after a collision with rough terrain.NTSB DCA13WA171Accident · No injuriesForeign investigationBeech E90 · Rustenburg, South AfricaNTSB WPR13LA237Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Chandler, AZThe failure of the alternator and/or battery, which prevented the operation of the landing gear extension system and resulted in the nose landing gear collapsing during the landing roll.NTSB WPR13LA214Accident · No injuriesLimited investigationFinal reportCessna 421A · Oakland, CAA failure of the left main landing gear pivot bolt in overstress during landing.NTSB ANC13CA038Accident · No injuriesData collectionFinal reportBeech A36 · Port Alsworth, AKThe failure of the left main landing gear retraction brace assembly, resulting in the collapse of the left main landing gear.NTSB ERA13LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Winston Salem, NCFatigue failure of the right main landing gear attach bolts due to an unreported hard landing at an unknown time, and subsequent collapse of the landing gear.NTSB ERA13LA188Accident · No injuriesLimited investigationFinal reportCessna 402C · Fort Lauderdale, FLThe disconnection of the nose landing gear actuator, which resulted in the subsequent collapse of the nose landing gear. Contributing to the accident was the repair station’s inadequate maintenance, postmaintenance inspection process, and oversight of the…NTSB CEN13LA208Accident · No injuriesLimited investigationFinal reportCessna 421C · Amarillo, TXMaintenance personnel's failure to detect the misadjustment of the left landing gear actuator's switch after recent maintenance, which prevented the landing gear from locking in the extended position and resulted in the landing gear collapsing during landing.NTSB CEN13LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · College Station, TXThe failure of the nose landing gear fork during landing due to fatigue.NTSB DCA13WA063Accident · No injuriesForeign investigationSwearingen 227 · Dublin, IrelandThe AAIU of Ireland has notified the NTSB of an accident involving a Swearingen 227 that occurred on March 07, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the AAIU-Ireland's investigation under the provisions of ICAO Annex 13 as…NTSB ERA13LA129Accident · No injuriesLimited investigationFinal reportBeech 58 · Winston-Salem, NCThe failure of the left main landing gear to fully extend due to improper rigging by maintenance personnel during a maintenance check.NTSB CEN13CA187Accident · No injuriesData collectionFinal reportChampion 7GCAA · Oshkosh, WIFatigue cracking and failure of the left wheel strut mount resulting in collapse of the left main landing gear during taxi.NTSB CEN13LA141Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · McKinney, TXCollapse of the landing gear for reasons that could not be determined because visual examination did not reveal any mechanical malfunction or failure that would have prevented the gear from locking in the extended position and postaccident damage precluded…NTSB ANC13LA016Accident · No injuriesLimited investigationFinal reportCessna 150C · Juneau, AKThe collapse of the left main landing gear during the landing roll, as a result of fatigue cracking. Contributing to the accident was the improper maintenance of the landing gear.NTSB DCA13WA020Incident · No injuriesForeign investigationBoeing MD-82 · Johannesburg, South AfricaOn November 13, 2012, a McDonnell Douglas MD-80, registration ZS-TOG, experienced a wheel failure on the left hand main gear during takeoff from O.R.Tambo International Airport (FAJS), , South Africa. The chartered flight was enroute to Kamuzu International…NTSB CEN13IA059Incident · No injuriesIncident investigationFinal reportFairchild SA227-AC · Minneapolis, MNLoose electrical connections to the hydraulic system and anomalies in the hydraulic shuttle valve and power pack, which resulted in an uncommanded gear unlock and collapse of the left main landing gear. Contributing to the accident was the operator’s failure…NTSB ERA13LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fort Lauderdale, FLThe collapse of the right main landing gear during landing for reasons that could not be duplicated or determined during the postaccident investigation because of the initial unavailability of the airplane after the accident.NTSB WPR13LA034Accident · No injuriesLimited investigationFinal reportJeffair Barracuda · Payson, AZThe failure of the landing gear to remain extended during the landing roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB WPR13IA026Incident · No injuriesIncident investigationFinal reportCessna P210N · Oakland, CAThe pilot’s failure to follow proper procedures to confirm that the main landing gear was down and locked before landing.NTSB DCA13WA023Incident · No injuriesForeign investigationBoeing 737 · Casablanca, MoroccoOn October 24, 2012 a Boeing 737-800, registration CN-ROA experienced a nosewheel failure during taxiing after landing at the Casablanca / Mohammed V Airport. The airplane was operated by Royal Air Maroc as flight 471 from Tunis, Tunisia. There were no…NTSB ERA13CA047Accident · No injuriesData collectionFinal reportDaniels Alan L Kitfox Series 7 · Plymouth, MAThe pilot's improper landing flare and subsequent inadequate recovery from a bounced landing.NTSB CEN13IA024Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Elyria, OHThe manufacturing defects in the main landing gear leg, which resulted in its eventual failure.NTSB DCA13WA002Accident · No injuriesForeign investigationMcdonnell Douglas MD11 · Sao Paulo, BrazilNTSB ERA13LA005Accident · No injuriesLimited investigationFinal reportCessna 310I · Burlington, VTThe collapse of the left main landing gear due to a failure of the left main gear bellcrank pin for reasons that could not be determined because the pieces of the fractured bellcrank pin were not located.NTSB WPR12LA422Accident · No injuriesLimited investigationFinal reportHawker MK 11 SEA Fury · Reno, NVThe collapse of the right main landing gear due to failure of the landing gear rotary selector valve seal.NTSB CEN12CA644Accident · No injuriesData collectionFinal reportCessna 421C · Kenedy, TXThe pilot’s improper flare, which resulted in a hard landing and subsequent collapse of the landing gear.NTSB ERA12IA559Incident · No injuriesIncident investigationFinal reportCessna 402B · Opa-Locka, FLThe pilot’s turning the airplane too sharply while exiting the runway, which resulted in the failure of the right main landing gear bellcrank due to an overstress fracture.NTSB CEN12LA672Accident · No injuriesLimited investigationFinal reportSocata TBM 700 · Horseshoe Bay, TXThe off-centered right main landing gear ball joint, which resulted in the right main landing gear collapsing during landing.NTSB WPR12CA320Accident · No injuriesData collectionFinal reportPiper PA-30 · Yelm, WAThe pilot's failure to maintain an adequate airspeed on approach and his inadequate flare, which resulted in a hard landing.NTSB WPR12CA319Accident · No injuriesData collectionFinal reportDornier DO 27 B5 · Jackson Hole, WYThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear.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 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 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 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 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 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 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.