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 FTW01LA157Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Uvalde, TXThe pilot's failure to verify the landing gear was down and locked, which resulted in a wheels up landing and subsequent ground fire.NTSB CHI01LA176Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Green Bay, WIThe pilot not performing the pre-landing checklist, and the wheels-up landing made by the pilot.NTSB LAX01LA177Accident · No injuriesLimited investigationFinal reportBeech E33A · So Lake Tahoe, CAThe pilot's improper aircraft handling and decision to prematurely raise the landing gear during takeoff. Contributing factors were his lack of experience taking off under the high density altitude condition and his improper maintenance.NTSB NYC01LA106Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Swanton, OHthe failure of the pilot to verify the landing gear was extended prior to landing, due to diverted attention.NTSB CHI01LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Saint Cloud, MNThe inadvertent wheels-up landing by the pilot. A factor was the pilots failure to follow the before landing checklist.NTSB SEA01LA071Accident · No injuriesLimited investigationFinal reportCessna 172 RG · Gig Harbor, WAThe pilot's failure to extend the airplane's landing gear while landing.NTSB LAX01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Chino, CAThe pilot's failure to extend the landing gear. A factor was the pilot's failure to use the landing checklist.NTSB DEN01LA076Accident · No injuriesLimited investigationFinal reportBeech 95-B55B (T42A) · Watkins, COAn inadvertent landing gear retracted landing by the CFI during an instructional flight conducting a touch-and-go landing.NTSB DEN01LA052Accident · No injuriesLimited investigationFinal reportCessna 441 · Englewood, COthe pilot's failure to verify that the landing gear was down and locked before landing, which resulted in a wheels-up landing.NTSB CHI01FA084Accident · Minor injuriesField investigationFinal reportBeech 1900D · Chicago, ILThe flightcrew not lowering the landing gear and/or verifying the landing gear position as required by three separate checklists, which resulted in an inadvertent gear-up landing. A factor to the accident was the flightcrew not complying with the required…NTSB LAX01LA082Accident · No injuriesLimited investigationFinal reportBeech BE-55 · San Bernardino, CAThe failure of the pilot under instruction to extend the landing gear during the landing approach. A factor was the flight instructor's inadequate supervision.NTSB MIA01LA044Accident · No injuriesLimited investigationFinal reportAero Vodochody Aero. Works L-39C · Hilton Head Isl, SCthe pilot's improper inflight planning/decision and failure to follow the prelanding checklist, resulting in the landing gear not being lowered in sufficient time to be verified down and locked, which resulted in a wheels up landing and substantial damage to…NTSB DEN01LA008Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Santa Teresa, NMthe pilot's failure to follow procedures/directives and lower the landing gear for landing. Contributing factors were the damaged propellers making it impossible to perform a go-around, the inadvertent stall to the runway, and the pilot being in a state of…NTSB DEN00LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Blanding, UTThe pilot's failure to follow the checklist and lower the landing gear for landing. A factor was diverted attention.NTSB FTW00LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mountain Home, ARThe failure of the landing gear to extend due to the empty hydraulic reservoir.NTSB CHI00LA293Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Sellersburg, INthe improper servicing of the emergency extension assembly and the gear extension not verified by company maintenance personnel. Factors were the failure of the hydraulic system's motor, normal and emergency gear extension not available to the pilot, and the…NTSB DEN00LA151Accident · No injuriesLimited investigationFinal reportCessna 310D · Watkins, COThe pilot's failure to follow procedures and lower the landing gear prior to landing. Factors were diverted attention and aural perception.NTSB DEN00LA142Accident · No injuriesLimited investigationFinal reportMooney M20E · Canon City, COThe pilot's failure to extend the landing gear, which resulted in a wheels up landing.NTSB DEN00LA153Accident · No injuriesLimited investigationFinal reportMooney M20C · Erie, COFailure by the pilot to follow procedures and lower the landing gear.NTSB LAX00TA263Accident · No injuriesFinal reportCessna 337G · Battle Mountain, NVFailure of the pilot to extend the landing gear, and his failure to follow the published before landing checklist concerning extension of the landing gear.NTSB NYC00IA150Incident · No injuriesIncident investigationFinal reportBeech 1900D · Rochester, NYThe reversal of landing gear hydraulic lines by company maintenance personnel. Factors related to the incident were the manufacturers omission of maintenance procedures, and the failure of an electrical switch for undetermined reasons.NTSB DEN00LA097Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Englewood, COIn-flight planning and decision by the flight instructor by allowing the student to fly into a hazardous situation. Factors were the flight instructor delaying extending the landing gear and delaying a go-around.NTSB DEN00LA094Accident · No injuriesLimited investigationFinal reportCessna T210M · Laramie, WYThe pilot-in-command's failure to confirm, the landing gear was down and locked. Factors were the check pilot's failure to confirm the landing gear was down and locked, and the sun glare.NTSB ATL00LA050Accident · No injuriesLimited investigationFinal reportCessna 501 · Orlando, FLThe pilot's failure to follow the landing checklist that resulted in the delay of lowering the landing gear before touchdown.NTSB CHI00LA116Accident · No injuriesLimited investigationFinal reportBeech 58 · Decatur, ILthe failure of the pilot to extend the landing gear which resulted in the gear-up landing. A factor to the accident was the pilot's failure to complete the landing checklist.NTSB CHI00LA102Accident · No injuriesLimited investigationFinal reportBeech A36 · Bloomington, INdirectional control not maintained and maximum gross weight was exceeded by the pilot in command.NTSB LAX00LA131Accident · No injuriesLimited investigationFinal reportPiper PA-31-T1 · Scottsdale, AZThe pilot's failure to ensure that the landing gear was lowered before touchdown.NTSB ATL00LA032Accident · No injuriesLimited investigationFinal reportBellanca 260 B · Cornelia, GAThe pilot's failure to use the checklist, resulting in a wheels-up landing and post-crash fire.NTSB FTW00LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AT · Fayetteville, ARThe flight crew's failure to extend the landing gear. Contributing factors were the flight crew's non-compliance with the checklist, the pilot-in-command's diverted attention as a result of the loss of instrument approach/runway lighting, the partial failure…NTSB NYC00LA046Accident · No injuriesLimited investigationFinal reportCessna 210L · Columbus, OHThe pilot's failure to verify landing gear extension. Factors were the unreliable retraction/extension assembly, and the flying club's continued operation of the airplane with known deficiencies in the equipment.NTSB MIA00LA034Accident · No injuriesLimited investigationFinal reportCessna 182RG · Jacksonville, FLThe pilot's failure to complete the before landing checklist and extend the landing gear, resulting in a gear up landing. A factor in the accident is the failure of the landing gear warning circuit to activate the cockpit warning horn.NTSB CHI00LA029Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Romulus, MIthe inadvertent wheels-up landing by the pilot.NTSB SEA00LA011Accident · No injuriesLimited investigationFinal reportBeech A36TC · Pasco, WAThe pilot's failure to extend the landing gear. Factors include a blocked view of the landing gear light indicating system.NTSB FTW00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oklahoma City, OKThe failure of the pilot to follow the landing checklist and verify that the landing gear was down and locked, which resulted in a wheels up landing. A factor was the failure of the landing gear locking mechanism for an undetermined reason.NTSB CHI99LA315Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Eden Prairie, MNthe failure of the pilot to follow the landing checklist and his failure to extend the landing gear.NTSB LAX99LA278Accident · No injuriesLimited investigationFinal reportCessna TR182 · S. Lake Tahoe, CAThe pilot's failure to verify the landing gear was in the extended position. A factor in the accident was gear warning system's unresolved discrepancies.NTSB DEN99LA151Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Albuquerque, NMThe pilot's failure to follow published procedures in operating the aircraft. A factor was partial failure of the electrical system.NTSB FTW99FA223Accident · No injuriesField investigationFinal reportSwearingen SA-227-AC · San Antonio, TXThe instructor pilot's failure to complete the Emergency Gear Extension Checklist, resulting in the inadvertent wheels-up landing. A factor was the instructor pilot's fatigued condition.NTSB DEN99LA127Accident · No injuriesLimited investigationFinal reportCessna T210F · Albuquerque, NMThe pilot's inadvertent wheels up landing.NTSB ANC99LA085Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fairbanks, AKThe pilot's failure to extend the airplane landing gear. A factor in the accident was an interference with the pilot's habit pattern.NTSB CHI99LA206Accident · No injuriesLimited investigationFinal reportBeech 58 · Wheeling, ILthe landing gear extension not performed by the pilot. A contributing factor was the checklist not followed by the pilot.NTSB MIA99LA175Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Fort Myers, FLThe pilot's failure to verify that the retractable landing gear were down and locked for landing.NTSB SEA99LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Plentywood, MTThe pilot's failure to ensure that the landing gear were properly down and locked for landing.NTSB CHI99LA173Accident · No injuriesLimited investigationFinal reportAero Commander 500 · Effingham, ILinadvertent wheels-up landing and the checklist not followed by the pilot. The landing gear lever not engaged was an additional cause.NTSB ATL99LA086Accident · No injuriesLimited investigationFinal reportBeech BE-100 · Hickory, NCThe failure of the landing gear actuator due to the improper installation of the lower thrust bearing by maintenance personnel.NTSB LAX99LA130Accident · No injuriesLimited investigationFinal reportBeech 58 · Atwater, CAthe failure of the student to extend the landing gear and the flight instructor's inadequate supervision of the flight.NTSB CHI99LA068Accident · No injuriesLimited investigationFinal reportCessna P210N · Eau Clare, WIthe delayed gear extension by the pilot. Contributing factors were the checklist not used by the pilot, the inoperative gear warning, and the maintenance replacement of the throttle control/gear warning interconnect cable not performed by company/operator…NTSB ATL99FA021Accident · No injuriesField investigationFinal reportBeech BE-55B · Hampton, GAThe pilot's failure to use the landing checklist that resulted in the wheels-up landing.NTSB MIA99LA020Accident · No injuriesLimited investigationFinal reportBeech BE-58 · Jackson, MSThe pilot's failure to ensure the landing gear was down resulting in a wheels up landing.NTSB ANC98LA159Accident · No injuriesLimited investigationFinal reportBeech A36 · New Stuyahok, AKThe pilot's failure to extend the landing gear prior to landing. Factors associated with this accident were the pilot's interference with his normal habit pattern, turbulence, and the crosswind condition during landing.