NTSB investigations
203 cases where the first occurrence was “Wheels up landing”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 232) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 232) 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 ANC04LA117Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Telida, AKA failure of the pilot-in-command to extend the landing gear, which resulted in a gear-up landing and structural damage to the airplane.NTSB FTW04LA223Accident · No injuriesLimited investigationFinal reportCessna 340 · Odessa, TXThe pilot's failure to extend the landing gear prior to landing and the instructor's inadequate supervision.NTSB LAX04CA303Accident · No injuriesData collectionFinal reportRockwell 112TC · Bullhead City, AZthe pilot's failure to extend the landing gear prior to landing. Factors in the accident were the pilot's failure to use a checklist and to verify that the gear were extended.NTSB ANC04CA085Accident · No injuriesData collectionFinal reportCessna 402C · Huslia, AKThe pilot's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. A factor associated with the accident was the pilot's diverted attention.NTSB SEA04CA144Accident · No injuriesData collectionFinal reportPiper Aerostar 602P · Seattle, WAThe landing gear extention not performed by the pilot.NTSB LAX04CA263Accident · No injuriesData collectionFinal reportCessna R182 · California City, CAthe pilot's failure to lower the landing gear. A contributing factor was the pilot's distraction while on final approach.NTSB ATL04CA145Accident · No injuriesData collectionFinal reportCessna 172 RG · Fernandina, FLThe pilot's failure to follow the checklist and lower the landing gear prior to landing.NTSB MIA04LA102Accident · No injuriesLimited investigationFinal reportBeech V35B · Bay Saint Louis, MSThe failure of the pilot to verify the landing gear was extended prior to touchdown resulting in a gear-up landing.NTSB ATL04CA121Accident · No injuriesData collectionFinal reportBeech BE-24 · Chamblee, GAThe pilot's failure to use checklist resulted in a gear-up landing.NTSB DEN04CA054Accident · No injuriesData collectionFinal reportCessna T310R · Broomfield, COthe pilot's improper in-flight planning/decision and his failure to verify the landing gear position. Factors contributing to the accident were the pilot's diverted attention due to the electrical failure.NTSB MIA04CA057Accident · No injuriesData collectionFinal reportBeech V35B · Bay St. Louis, MSThe failure of the pilot to complete the landing checklist and extend the landing gear resulting in a gear up landing and damage to the airplane.NTSB ATL04IA054Incident · No injuriesIncident investigationFinal reportNew Piper PA-46-350P · St. ThomasThe pilot's inadequate inflight planning and failure to extend the landing gear, which resulted in a wheels-up landing.NTSB DEN04LA013Accident · No injuriesLimited investigationFinal reportCessna 210G · Meeker, COthe pilot's failure to extend the landing gear. Contributing to the accident was the pilots failure to recognize the gear warning horn during the landing flare.NTSB ATL04IA010Incident · No injuriesIncident investigationFinal reportBeech 58 · Columbus, MSThe pilot's failure to follow the pre-landing checklist, and his failure to extend the landing gear which resulted in a wheels up landing.NTSB ANC03LA125Accident · No injuriesLimited investigationFinal reportPiper PA-31-310 · Cape Yakataga, AKThe pilot's failure to follow the prelanding checklist, which resulted in a wheels up landing when he neglected to lower the airplane's landing gear. A factor in the accident was the pilot's diverted attention associated with turbulence and a wet airstrip.NTSB FTW03CA201Accident · No injuriesData collectionFinal reportCessna 210D · San Antonio, TXThe pilot's failure to comply with the checklist resulting in a wheels up landing. Contributing to the accident was self-induced pressure.NTSB LAX03CA203Accident · No injuriesData collectionFinal reportMooney M20J · Lincoln, CAThe pilot's failure to extend the landing gear prior to landing.NTSB LAX03LA194Accident · No injuriesLimited investigationFinal reportBeech 35-B33 · Inyokern, CAThe pilot failed to extend the landing gear.NTSB MIA03CA117Accident · No injuriesData collectionFinal reportBeech 95-B55 · Forest, MSthe failure of the pilot-in-command to extend the landing gear, or use the checklist while on landing approach, resulting in a gear up landing.NTSB SEA03LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Boise, IDThe landing gear extension was not performed by the pilot for landing. Contributing factors included the pilot's failure to perform the Before Landing checklist and his unfamiliarity with the landing gear warning horn system.NTSB FTW03LA125Accident · No injuriesLimited investigationFinal reportCarterCopter Prototype · Olney, TXThe pilot's failure to extend the landing gear. A factor was his diverted attention.NTSB DEN03LA029Accident · No injuriesLimited investigationFinal reportBeech F33A · Durango, COthe pilot's failure to extend the landing gear. A contributing factor is the pilot's failure to follow the checklist.NTSB SEA03LA018Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125 · Seattle, WAThe landing gear down and locked was not verified prior to landing. The checklist was not followed, and an inoperative landing gear warning horn were factors.NTSB CHI03LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Jackson, MIThe pilot's failure to follow the checklist and extend the landing gear resulting in a gear up landing.NTSB FTW03LA063Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Odessa, TXThe pilot's inadvertent failure to extended the landing gear.NTSB LAX03LA006Accident · No injuriesLimited investigationFinal reportCessna 310L · North Las Vegas, NVThe pilot's failure to use the landing checklist due to his diverted attention, which resulted in a wheels-up landing.NTSB ANC02LA104Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Nuiqsut, AKThe pilot's inadvertent wheels-up landing. Factors contributing to the accident were the pilot's failure to complete the prelanding checklist, his diverted attention, and a delayed gear warning horn alarm.NTSB CHI02LA251Accident · No injuriesLimited investigationFinal reportCessna 210L · Lacon, ILThe pilot's improper in-flight decision to perform an intentional gear-up precautionary landing instead of continuing to the next available airport. A factor to the accident was the corn crop.NTSB SEA02LA139Accident · No injuriesLimited investigationFinal reportCessna R182 · Puyallup, WARestricted movement of the left main landing gear resulting in the gear not extending for the landing. A misaligned brake line was a factor.NTSB LAX02LA236Accident · No injuriesLimited investigationFinal reportCessna TR182 · Yuma, AZthe pilot's failure to properly verify that the landing gear was in the down and locked position.NTSB DEN02LA072Accident · No injuriesLimited investigationFinal reportMooney M20C · Watkins, COthe pilot's failure to use the pre-landing checklist, resulting in an inadvertent wheels up landing.NTSB DEN02LA056Accident · No injuriesLimited investigationFinal reportBeech A35 · Newcastle, WYthe pilot-in-command's failure to lower the landing gear prior to landing.NTSB ATL02IA112Incident · Minor injuriesIncident investigationFinal reportCessna 210L · Sarasota, FLThe pilot's failure to follow the before landing checklist and confirm that the landing gear was extended.NTSB CHI04LA124Accident · No injuriesLimited investigationFinal reportBeech 58 · Lansing, ILThe flight crew's failure to follow the checklist resulting in a landing without the landing gear extended.NTSB IAD02LA045Accident · No injuriesLimited investigationFinal reportCessna P210N · Linden, NJThe pilot's failure to lower the landing gear prior to landing.NTSB CHI02IA110Incident · No injuriesIncident investigationFinal reportPiper PA-34-220T · Sturgis, MIThe flightcrew not following the landing checklist, the flightcrew not lowering the landing gear, and the flight examiner's inadequate supervision of the flight.NTSB MIA02IA072Incident · No injuriesIncident investigationFinal reportPiper PA-31-325 · Fort Laudedale, FLThe failure of the pilot to assure all items of the before landing checklist were complied with before landing, resulting in the wheels up landing.NTSB ANC02LA022Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Fairbanks, AKThe pilot's failure to complete his prelanding checklist, and a subsequent inadvertent wheels up landing.NTSB SEA02LA043Accident · No injuriesLimited investigationFinal reportBeech G35 · Anacortes, WAThe pilot's inadvertent failure to lower the landing gear prior to touchdown.NTSB NYC02LA072Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Atlantic City, NJThe pilot's failure to lower the landing gear prior to landing.NTSB LAX02LA047Accident · No injuriesLimited investigationFinal reportBeech 95 · Kingman, AZthe pilot's failure to complete and verify the prelanding checklist and extend the landing gear, which resulted in the gear-up landing.NTSB MIA02LA016Accident · No injuriesLimited investigationFinal reportCessna T310R · Madison, MSThe pilot's failure to verify that the landing gear was down and locked prior to landing resulting in the airplane being landed with the landing gear retracted.NTSB CHI02LA016Accident · No injuriesLimited investigationFinal reportCessna T210M · Salem, ILThe ruptured hydraulic hose.NTSB SEA01LA177Accident · No injuriesLimited investigationFinal reportCessna 172RG · Newberg, ORThe pilot's failure to lower the landing gear. A factor was the pilot's failure to follow checklist procedures.NTSB DEN01LA164Accident · No injuriesLimited investigationFinal reportCessna 172RG · Englewood, COthe failure of the dual student to verify that the landing gear was down and locked, and the failure of the flight instructor to adequately supervise the dual student.NTSB ANC01LA132Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fairbanks, AKThe pilot's failure to extend the landing gear.NTSB CHI01LA309Accident · No injuriesLimited investigationFinal reportCessna T210N · Fargo, NDthe emegency procedure not followed by the pilot.NTSB DEN01LA137Accident · No injuriesLimited investigationFinal reportBeech A35 · Moab, UTthe pilot's failure to lower the landing gear resulting in a wheels up landing.NTSB ATL01LA104Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Pahokee, FLThe pilot's failure to follow the checklist while making an approach for landing resulting in a wheels up landing. Contributing to the accident was the certified flight instructor inadequate supervision of the rated pilot receiving instruction.NTSB DEN01LA121Accident · No injuriesLimited investigationFinal reportGriffith-Boyd Lancair 360 · La Junta, COa wheels-up landing due to an uncommanded gear retraction resulting from a short circuit of the landing gear electrical wiring.