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 WPR09LA171Accident · No injuriesLimited investigationFinal reportCessna 550 · Salt Lake City, UTThe uncommanded retraction of the right main landing gear hydraulic actuator strut for undetermined reasons.NTSB CEN09CA356Accident · No injuriesData collectionFinal reportBeech A36 · Charleston, MOThe pilot's inadvertent use of the landing gear selector handle instead of the flap handle during landing rollout, which resulted in the collapse of the nose landing gear.NTSB CEN09CA226Accident · No injuriesData collectionFinal reportCessna 172A · Corsicana, TXThe pilot's improper flare.NTSB WPR09CA172Accident · No injuriesData collectionFinal reportCessna 152 · Ellensburg, WAThe student pilot's improper flare and improper recovery from a bounced landing.NTSB ERA09LA210Accident · No injuriesLimited investigationFinal reportCessna 310K · Ocala, FLThe right main landing gear collapse as a result of the pilot's improper flare during a previous landing. Contributing to the accident was the flight instructor's inadequate supervision.NTSB ERA09CA190Accident · No injuriesData collectionFinal reportPiper PA-42 · Belmar, NJThe pilot's improper flare, which resulted in a hard landing.NTSB ERA09LA209Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lumberton, MSCollapse of the landing gear due to worn left main landing gear components.NTSB CEN09CA184Accident · No injuriesData collectionFinal reportMarrero Andres Starduster · San Antonio, TXThe pilot's loss of control during take off. Contributing to the accident was the crosswind component.NTSB ANC09CA033Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the main landing gear collapsing during taxi.NTSB CEN09CA179Accident · No injuriesData collectionFinal reportAviat A-1C · Denver, COThe pilot's failure to maintain control during taxi. A contributing factor was the gusty winds.NTSB ANC09CA020Accident · No injuriesData collectionFinal reportBeech 65-A90-1 · Soldotna, AKThe pilot's misidentification of the runway surface during landing. Contributing to the accident were the snow-covered terrain, and low-light conditions.NTSB WPR09CA095Accident · No injuriesData collectionFinal reportDickson Vans RV-8 · El Monte, CAThe pilot's failure to maintain directional control during landing.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 CEN09LA137Accident · No injuriesLimited investigationFinal reportBeech A36 · Farmington, NMCollapse of the landing gear during landing due to the incorrect installation of the landing gear actuator. Contributing to the accident was the pilot's failure to initiate the abnormal procedures checklist prior to landing.NTSB CEN09LA116Accident · Minor injuriesLimited investigationFinal reportLearjet 45XR · Telluride, COThe failure of both pilots to positively identify the runway prior to landing.NTSB CEN09CA121Accident · No injuriesData collectionFinal reportCessna 150M · Greene, IAA loss of engine power due to undetermined reasons. Contributing to the accident was the rough, snow-covered terrain.NTSB CEN09CA208Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Valparaiso, INThe pilot's improper flare during landing, resulting in a bounced landing.NTSB CEN09CA084Accident · No injuriesData collectionFinal reportRockwell International 114 · Meacham Int'l Airport, TXThe pilot's failure to maintain pitch control during landing.NTSB ERA09CA217Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Middletown, DEThe pilot's failure to maintain aircraft control while landing in gusty conditions.NTSB CEN09CA071Accident · No injuriesData collectionFinal reportCessna 150F · Trenton, TXThe pilot's improper flare during landing, resulting in a hard landing. Contributing to the accident were the night light conditions and the instructor's inadequate supervision of the pilot.NTSB CEN09CA119Accident · No injuriesData collectionFinal reportPiper Aerostar 6 · Middletown, OHThe pilot's failure to verify that the landing gear was down and locked prior to landing.NTSB CEN09IA057Incident · No injuriesIncident investigationFinal reportCessna T210N · Lubbock, TXAn unidentified anomaly within the airplane's electrical system. Contributing to the incident was the pilot's failure to manually extend the landing gear.NTSB ERA09LA050Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe failure of the nose gear drag link bolt due to reversed bending fatigue.NTSB CEN09CA045Accident · No injuriesData collectionFinal reportHartter Lenny J Bearhawk · Mack, COThe collapse of the left main landing gear which resulted in the pilot's failure to maintain directional control.NTSB WPR09LA029Accident · No injuriesLimited investigationFinal reportCessna 421C · Mesa, AZThe failure of the hydraulic landing gear extension systems due to a ruptured line.NTSB ERA09CA023Accident · No injuriesData collectionFinal reportPiper PA-20 · Albertville, ALThe pilot’s failure to maintain control of the airplane during the landing roll.NTSB ERA09LA020Accident · No injuriesLimited investigationFinal reportSikorsky S-76C · New York, NYThe failure of the flightcrew to stabilize the helicopter over its confined landing area during a hovering left-pedal turn, resulting in tail rotor blade contact with a perimeter fence component and a subsequent loss of directional control. Contributing to…NTSB CEN09CA004Accident · No injuriesData collectionFinal reportCessna 182P · Mount Vernon, MOThe pilot failed to maintain a proper landing aim point. Contributing to the accident were the setting sun and the uneven terrain approaching the runway.NTSB ERA09CA016Accident · No injuriesData collectionFinal reportCessna 182T · Gulf Shores, ALThe pilot's improper recovery from a bounced landing.NTSB ERA09CA006Accident · No injuriesData collectionFinal reportBeech F17D · Moscow, TNThe mechanical failure of the landing gear actuation chain.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 CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…NTSB NYC08CA328Accident · No injuriesData collectionFinal reportHood Junior Ace · Ashville, ALThe pilot's improper flare while landing. Contributing to the accident was the airplane's lack of yaw control as reported by the pilot.NTSB CHI08CA295Accident · Minor injuriesData collectionFinal reportNorth American Harvard MK · Dayton, OHImproper maintenance on the tail wheel anti-shimmy mechanism and the pilot's decision to continue operating the airplane with a known shimmy in the tail wheel.NTSB SEA08CA211Accident · No injuriesData collectionFinal reportCessna 180 · Bluff, UTThe pilot's encounter with the rough, uneven, and eroded condition of the airstrip.NTSB CHI08LA286Accident · Minor injuriesLimited investigationFinal reportFlight Design Ctsw · Delaware, OHThe student pilot's failure to maintain directional control during landing.NTSB CHI08LA297Accident · Serious injuriesLimited investigationFinal reportPowrachute Pegasus · New London, WIThe pilot's loss of directional control during landing due to failure of the nose wheel support as a result of an inadequate weld.NTSB NYC08CA315Accident · No injuriesData collectionFinal reportPiper PA-30 · Jefferson, GAThe pilot's failure to follow the airplane manufacturer's landing gear failure and emergency extension procedures. Contributing to the accident was a malfunction of the landing gear system for undetermined reasons.NTSB SEA08CA203Accident · No injuriesData collectionFinal reportSnelling Zodiac · Rexburg, IDThe private pilot's excessive use of the flight controls and improper landing flair, which resulted in a hard landing and subsequent gear collapse.NTSB SEA08CA202Accident · No injuriesData collectionFinal reportMooney M20K · Trinity Center, CAThe complete loss of engine power due to fuel exhaustion as a result of a leak in the fuel system. Contributing to the accident was the rough terrain the airplane encountered during the forced landing.NTSB MIA08LA195Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30 · Clearwater, FLThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the pilot's improper use of a supplemental cockpit lighting during approach.NTSB DFW08LA231Accident · No injuriesLimited investigationFinal reportEvektor-Aerotechnik Sportstar · Roanoke, TXThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the pilot's lack of flight experience in the make and model of airplane.NTSB MIA08CA190Accident · No injuriesData collectionFinal reportCessna 310R · Lake Placid, NYThe pilot's failure to observe the ongoing construction to the closed runway while landing. Contributing to the accident was flight service's failure to brief the pilot of the closed runway.NTSB CHI08CA280Accident · Minor injuriesData collectionFinal reportCessna 150G · Urbana, OHA loss of engine power due to carburetor ice. Contributing to the accident were environmental conditions conducive to carburetor icing.NTSB ANC08CA120Accident · No injuriesData collectionFinal reportCessna T207 · Nyac, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the nose wheel separating from the airplane during the landing roll.NTSB DEN08LA153Accident · No injuriesLimited investigationFinal reportCessna 210 · Pagosa Springs, COThe failure of the landing gear to extend for undetermined reasons.NTSB MIA08LA185Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Sparta, TNFailure of the nose landing gear mount during a normal landing due to an improper weld.NTSB SEA08CA197Accident · No injuriesData collectionFinal reportCessna A185F · Lakeview, ORThe pilot's failure to maintain directional control. A contributing factor was the rough terrain.NTSB NYC08CA301Accident · No injuriesData collectionFinal reportSteppling RV-6A · Toughkenamon, PAThe pilot's improper recovery from a bounced landing.NTSB ANC08CA115Accident · No injuriesData collectionFinal reportPiper PA-22 · Fairbanks, AKThe pilot's selection of an unsuitable landing site, resulting in a main landing gear collapse during the landing roll.