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 CEN13LA170Accident · No injuriesLimited investigationFinal reportCessna 195 · Austin, TXThe pilot's use of an excessive taxi speed, which resulted in the airplane overrunning the end of the unlit taxiway after the failure of the right wing landing light.NTSB ANC13CA023Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Dutch Harbor, AKThe pilot's decision to land in wind conditions that exceeded the airplane's demonstrated crosswind capability, which resulted in a loss of airplane control during the landing roll.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 WPR13LA112Accident · No injuriesLimited investigationFinal reportCessna 305A · Camarillo, CAA tailwheel vibration upon touchdown and the subsequent loss of directional control for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.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 CEN13CA144Accident · No injuriesData collectionFinal reportMooney M20J · Warsaw, INThe pilot's improper recovery from a bounced landing and failure to maintain control of the airplane during a go-around maneuver. Contributing to the accident were the pilot’s complacency flying the airplane and his lack of training on bounced landing…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 CEN13LA132Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Antlers, OKThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR13LA082Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · North Las Vegas, NVThe pilot’s failure to maintain an adequate descent rate while on final approach, which resulted in a hard landing and landing gear collapse due to overload following the failure of both engines to respond to power inputs during an attempted go-around for…NTSB CEN13CA120Accident · No injuriesData collectionFinal reportRobidoux Lionel Wittman W 10 · Hobart, INThe pilot’s failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall and subsequent hard landing.NTSB CEN13CA125Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Middle Bass Island, OHThe pilot did not attain the proper touchdown point during landing, which resulted in impact with the edge of the runway surface.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 ERA13CA092Accident · No injuriesData collectionFinal reportLiberty Aerospace XL-2 · Lynchburg, VAThe student pilot’s improper flare, which resulted in a hard landing.NTSB CEN13CA083Accident · No injuriesData collectionFinal reportMooney M20TN · Durango, COThe pilot's improper recovery from a bounced landing, and his failure to maintain airplane control during the go-around maneuver.NTSB CEN13CA084Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Melbourne, ARThe pilot's failure to maintain directional control of the airplane during the landing.NTSB WPR13LA060Accident · No injuriesLimited investigationFinal reportPiper PA30 · Phoenix, AZThe pilot's failure to properly inhibit the landing gear transmission motor consistent with the emergency landing gear extension procedure, which precluded the full extension of the landing gear. Contributing to the accident was the airplane's electrical…NTSB ERA13LA065Accident · No injuriesLimited investigationFinal reportBeech C90A · Roanoke, VAThe failure of the right main landing gear bearing actuator support brackets. Contributing to the accident was the owner's and operator's failure to comply with the airplane manufacturer's mandatory service bulletin and the Federal Aviation Administration's…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 ERA13LA052Accident · No injuriesLimited investigationFinal reportWaller Charles R Rans S12-XL · Gordon, ALA fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.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 CEN13CA064Accident · Minor injuriesData collectionFinal reportLawson Ron Rans S-19 · Crowley, LAThe pilot’s improper landing flare, which resulted in the collapse of the nose landing gear and the airplane nosing over.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 CEN12LA668Accident · No injuriesLimited investigationFinal reportThompson RV-6 · Pagosa Springs, COThe pilot’s failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot’s lack of landing experience at high density altitudes.NTSB CEN12FA653Accident · No injuriesField investigationFinal reportPiper PA-46-350P · Kiowa, COA catastrophic engine failure due to unrecognized and unrepaired corrosion within the engine, which was consistent with engine operations after an extended period of inactivity.NTSB CEN12LA635Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Mecosta, MIThe pilot's improper landing flare, which resulted in a bounced landing and loss of airplane control.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 WPR12CA400Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lancaster, CAThe student pilot’s inadvertent selection of an empty fuel tank.NTSB WPR12LA383Accident · No injuriesLimited investigationFinal reportCessna 177RG · Olympia, WAA loss of directional control during landing for reasons that could not be determined because postaccident examination of the nose gear steering mechanism did not reveal any anomalies that would have precluded normal operation.NTSB ERA12IA550Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MACompany maintenance personnel’s failure to comply with the airplane manufacturer’s service instructions by not removing the cracked drag brace from service nor inspecting the repaired drag brace at the appropriate interval, which resulted in the failure of…NTSB CEN12CA607Accident · No injuriesData collectionFinal reportNorth American AT-6F · Council Bluffs, IAAn unlocking of the excessively worn tailwheel lock mechanism, which resulted in a loss of directional control during landing.NTSB CEN12CA585Accident · No injuriesData collectionFinal reportCessna 180 · Brookville, OHThe pilot's failure to maintain directional control of the airplane during the attempted takeoff in gusting crosswind conditions.NTSB ERA12CA520Accident · No injuriesData collectionFinal reportFleet Fleet 16B · Bayport, NYThe pilot’s improper landing flare, which resulted in a hard landing.NTSB ERA12CA519Accident · No injuriesData collectionFinal reportCessna 208B · Raeford, NCThe pilot's decision to land in a grassy area next to a paved runway, which resulted in impact with a ditch and subsequent nose landing gear collapse.NTSB ERA12LA518Accident · No injuriesLimited investigationFinal reportMeyers OTW-160 · Worton, MDThe student pilot's improper landing flare and the flight instructor's inadequate remedial action, which resulted in a hard landing.NTSB CEN12LA530Accident · Serious injuriesLimited investigationFinal reportWilliams John T-51 Mustang · Oshkosh, WIThe separation of an engine cooling hose from the radiator.NTSB ERA12LA494Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Titusville, FLInadequate maintenance servicing and inspection of the nose landing gear, which resulted in the failure of the nose landing gear to lock and its subsequent collapse during landing.NTSB CEN12LA476Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Conway, ARThe pilot's improper landing flare, which resulted in a hard landing and overstress failure of the right main landing gear.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 CEN12LA420Accident · No injuriesLimited investigationFinal reportCessna T210M · Colorado Springs, COThe failure of the right hydraulic main gear down-lock actuator hose in flight.