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 CEN12LA204Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Roanoke, TXThe pilot’s failure to follow the published emergency procedures to lower the landing gear following a loss of electrical power.NTSB CEN12LA218Accident · No injuriesLimited investigationFinal reportCessna 182A · New Philadelphia, OHThe inadequate maintenance of the wheel attachment bolts, which resulted in the left wheel separating from the landing gear during landing due to ductile overstress fractures.NTSB ERA12IA187Incident · No injuriesIncident investigationFinal reportCessna 402B · Fort Lauderdale, FLThe overload fracture of the right main landing gear bellcrank and a securing bolt, which resulted in the collapse of the right main landing gear.NTSB WPR12CA112Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not maintain directional control while landing on a snow-contaminated runway.NTSB WPR12CA101Accident · No injuriesData collectionFinal reportLearjet 31A · Wheatland, WYThe flight crew’s loss of directional control during landing on an ice- and water-contaminated runway, which resulted in a runway excursion.NTSB ERA12CA178Accident · No injuriesData collectionFinal reportCessna 152 · Miami, FLThe student pilot's improper flare and recovery from a bounced landing.NTSB ERA12LA188Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Culpeper, VAThe pilot's failure to use the manufacturer's checklist to troubleshoot the perceived malfunction and thereby ensure the position of the landing gear before landing. The reason the landing gear were not down and locked could not be determined, as no…NTSB WPR12CA103Accident · No injuriesData collectionFinal reportRockwell International S-2R · Yellow Pine, IDThe pilot did not reduce the airplane’s descent rate prior to the landing flare/touchdown, which resulted in a hard landing.NTSB ERA12CA140Accident · No injuriesData collectionFinal reportLuscombe 8A · Umatilla, FLA failure of the left main landing gear due to a preexisting crack and corrosion, which resulted in a loss of directional control during landing.NTSB ERA12LA132Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Shelter Island, NYA hard landing, which resulted in a failure of the right main and collapse of the left main landing gear.NTSB ERA12LA117Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe mechanic's improper installation and lubrication of the bushing on the right main landing gear truss assembly, which resulted in the landing gear not locking in the down position.NTSB WPR12CA061Accident · No injuriesData collectionFinal reportGrumman AA5 · Furnace Creek, CAThe pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB CEN12LA103Accident · No injuriesLimited investigationFinal reportBeech C23 · Watertown, SDA total loss of engine power during initial climb for undetermined reasons.NTSB ERA12WA104Accident · No injuriesForeign investigationPiper PA28 · Bogota, ColombiaOn December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…NTSB WPR12LA052Accident · No injuriesLimited investigationFinal reportBeech 76 · San Carlos, CAThe collapse of the right main landing gear during the turn off the runway due to the failure of the A-frame assembly.NTSB WPR12LA047Accident · No injuriesLimited investigationFinal reportCessna 310I · Sedona, AZThe collapse of the right main landing gear after landing for a reason that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation, and postaccident testing could not be performed due…NTSB ERA12CA088Accident · No injuriesData collectionFinal reportAnatra Bart T Vans RV-7A · Quinton, VAThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation, and the subsequent nose-over during the forced landing.NTSB ERA12WA091Incident · No injuriesForeign investigationPiper PA23 · Quibdo, ColombiaOn November 23, 2011, about 1717 UTC, a Piper PA-23-250, Colombian registration HK1263, operated by Aerolineas Alas de Colombia LTDA, experienced collapse of the left main landing gear during the landing roll at the El Carano Airport (SKUI), Quibdo, Colombia.…NTSB ERA12CA079Accident · No injuriesData collectionFinal reportBeech C-45G · Lyman, MSThe collapse of the right main landing gear during landing due to an encounter with soft terrain.NTSB ERA12CA075Accident · No injuriesData collectionFinal reportBellanca 17-30A · Pine Mountain, GAThe pilot's inadequate directional control during landing, which resulted in a runway excursion.NTSB ERA12LA069Accident · No injuriesLimited investigationFinal reportGrenier Raymond Vans Aircraft RV-8 · Nashua, NHThe right main landing gear collapse due to the overload fracture of the hardware for reasons that could not be determined during postaccident testing and examination.NTSB ERA12WA067Incident · No injuriesForeign investigationCessna 402 · Quibdo, ColombiaOn November 4, 2011, about 1640 UTC, a Cessna 402C, Colombian registration HK4417, registered to and operated by AeroEjecutivos De Antioquia S.A. experienced collapse of the left main landing gear during the takeoff roll from El Carano Airport (SKUI), Quibdo,…NTSB ERA12FA056Accident · Serious injuriesField investigationFinal reportGulfstream G150 · Key West, FLThe pilot in command's failure to follow the normal landing procedures (placing engines into reverse thrust first and then brake), his delayed decision to continue the landing or go-around, and the flight crew's failure to follow emergency procedures once a…NTSB CEN12CA027Accident · No injuriesData collectionFinal reportMichael Cans RV-8 · Breaux Bridge, LAThe pilot's failure to maintain control of the airplane after striking an unseen sinkhole during landing.NTSB ERA12CA028Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Culpeper, VAThe pilot's inadequate knowledge of the airplane's emergency gear extension procedures, which resulted in his failure to successfully perform a manual extension of the landing gear.NTSB ERA11LA507Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-25 · Atlanta, GAThe improper installation of the nose landing gear strut and subsequent collapse of the nose landing gear during landing.NTSB WPR11CA468Accident · No injuriesData collectionFinal reportBeech 36 · Riverton, WYThe pilot's inadvertent retraction of the landing gear during the landing roll.NTSB ERA11LA519Accident · No injuriesLimited investigationFinal reportHeinlein George GH125 · Okeechobee, FLThe non-certificated pilot's improper flare on an earlier flight, which resulted in a hard landing, fracture of the right main landing gear bolt, and subsequent collapse of the right main landing gear.NTSB CEN11LA658Accident · No injuriesLimited investigationFinal reportMark Divita RV-8 · Lancaster, TXThe failure of the tailwheel to remain locked during a crosswind landing, which resulted in a loss of directional control.NTSB CEN11CA655Accident · No injuriesData collectionFinal reportBeech B90 · Hillsboro, TXThe pilot's failure to obtain a proper touchdown point, which resulted in a runway undershoot.NTSB CEN11CA661Accident · No injuriesData collectionFinal reportLuscombe 8A · Huntington, INThe failure of the right main landing gear strut due to internal corrosion.NTSB ERA11LA491Accident · No injuriesLimited investigationFinal reportCessna TR182 · Stevensville, MDThe pilot did not maintain directional control during the landing roll.NTSB WPR11LA471Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Phoenix, AZThe pilot's improper flare and hard landing, which resulted in the failure of the nose landing gear drag link in overstress.NTSB WPR11CA432Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12-D · Lancaster, CAThe student pilot’s inadequate flare resulting in a hard landing. Contributing to the accident was the certified flight instructor's inadequate supervision.NTSB ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.NTSB WPR11LA427Accident · No injuriesLimited investigationFinal reportStinson V77 · Tillamook, ORThe pilot’s loss of directional control while taxiing in a gusting tailwind.NTSB WPR11LA436Accident · No injuriesLimited investigationFinal reportTubbs S/Performance PA-18 225DD · Mile Hi Landing Strip, IDThe collapse of the left landing gear during landing for undetermined reasons.NTSB CEN11LA558Accident · No injuriesLimited investigationFinal reportPiper Aerostar 601P · Alpine, TXThe pilot’s improper flare which resulted in a hard landing. Contributing to the accident was the pilot’s improper decision to fly the airplane with a known mechanical deficiency.NTSB ERA11LA466Accident · No injuriesLimited investigationFinal reportPiper PA46 · Manasses, VAAn undetermined nose landing gear steering anomaly or anomalies, which resulted in the pilot's inability to maintain directional control of the airplane during the landing rollout. The damage to the nose landing gear precluded a determination of the cause of…NTSB CEN11LA596Accident · No injuriesLimited investigationFinal reportSuminski Walter M Jabiru SP · Columbia, ILSeparation of the right main wheel during landing rollout for undetermined reasons.NTSB ANC11CA081Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Valdez, AKThe pilot's failure to maintain the proper approach path, which resulted in a runway undershoot.NTSB ANC11TA079Accident · No injuriesFinal reportDehavilland DHC-2 MK. I(L20A) · Northway, AKThe pilot's failure to identify unsuitable terrain for landing and subsequent contact with a dirt mound, resulting in the separation of the tailwheel from the airframe.NTSB CEN11LA542Accident · No injuriesLimited investigationFinal reportT&T Falcon LS · Lee's Summit, MOA binding condition in the left rudder cable which resulted in a loss of directional control during landing.NTSB WPR11LA364Accident · No injuriesLimited investigationFinal reportNicholson 2000 · Sedona, AZThe pilot’s improper landing flare, which resulted in a hard landing.NTSB WPR11LA370Accident · No injuriesLimited investigationFinal reportPiper J5A · Biddle, MTFailure of the left main landing gear strut during the landing roll due to a preexisting crack.NTSB ANC11CA072Accident · No injuriesData collectionFinal reportAeronca 7AC · McCarthy, AKThe separation of the right main landing gear oleo strut assembly, resulting in the collapse of the main landing gear during the landing roll.NTSB WPR11CA357Accident · No injuriesData collectionFinal reportCessna 175 · Greer, AZThe pilot’s improper flare and inadequate recovery from a bounced landing which resulted in a nose gear collapse.NTSB CEN11CA583Accident · No injuriesData collectionFinal reportMooney M20K · Cresson, TXThe pilot’s inadequate recovery from a bounced landing and subsequent failure to maintain directional control of the airplane.NTSB CEN11CA526Accident · No injuriesData collectionFinal reportPiper PA-36-375 · Cambridge, NEThe pilot's failure to reset the engine's mixture control lever to the full rich position prior to takeoff.NTSB CEN11LA494Accident · No injuriesLimited investigationFinal reportCessna T210L · Columbia, MOThe collapse of the right main landing gear during landing due to a lack of component lubrication, which resulted in the failure of the landing gear to lock once extended.