NTSB investigations
463 cases where the defining event was Landing gear not configured.
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '095') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '095') 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 CEN12LA473Accident · No injuriesLimited investigationFinal reportCessna TR182 · Steamboat Springs, COThe pilot's failure to extend the landing gear before landing.NTSB WPR12CA310Accident · No injuriesData collectionFinal reportPiper PA-46 · Delano, CAThe pilot's failure to extend the landing gear before touchdown. Contributing to the accident was the pilot's failure to perform the appropriate checklist due to distractions posed by another airplane inbound to the same airport and a cluttered radio…NTSB CEN12LA444Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Grand Forks, NDThe pilot receiving instruction's failure to extend the landing gear and the flight instructor's failure to adequately monitor his student's actions during the approach.NTSB WPR12CA311Accident · No injuriesData collectionFinal reportCessna T210L · Idaho Falls, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was an uncorrected malfunction of the landing gear warning horn system.NTSB CEN12CA436Accident · No injuriesData collectionFinal reportBeech 58 · Sugar Loaf Mountain, MIThe pilot did not complete the before-landing checklist and, subsequently, failed to extend the landing gear prior to landing. Contributing to the accident was the pilot’s distraction with his passengers’ conversation.NTSB ERA12LA450Accident · No injuriesLimited investigationFinal reportBeech A36 · Johns Island, SCThe pilot's failure to complete the manual emergency gear extension after a loss of electrical power. Contributing to the accident was the pilot's decision to delegate the landing gear extension to a non-pilot-rated passenger.NTSB ERA12CA424Accident · No injuriesData collectionFinal reportBeech 58 · Atlanta, GAThe pilot's inadvertent retraction of the landing gear during the landing.NTSB CEN12CA406Accident · No injuriesData collectionFinal reportPiper PA-24 · Watertown, WIThe pilot’s failure to extend the landing gear before landing.NTSB CEN12LA434Accident · No injuriesLimited investigationFinal reportBeech A36 · New Orleans, LAThe pilot's failure to lower the landing gear before touchdown.NTSB CEN12LA387Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Teresa, NMThe pilot’s failure to ensure that the landing gear was down and locked before landing.NTSB WPR12CA240Accident · No injuriesData collectionFinal reportCessna P337H · Jerome, IDThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.NTSB ERA12CA361Accident · No injuriesData collectionFinal reportLydon Patrick F Searey · Sanford, FLThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB WPR12CA234Accident · No injuriesData collectionFinal reportMurphy Rebel · Hayden Lake, IDThe pilots’ failure to position the landing gear for landing on the water, which resulted in a nose-over.NTSB CEN12LA283Accident · No injuriesLimited investigationFinal reportBeech 58 · Sioux Falls, SDThe failure of the normal and emergency landing gear system to fully retract or extend the landing gear for reasons that could not be determined during postaccident examinations, which resulted in a partial gear-up landing.NTSB DCA12FA058Accident · No injuriesField investigationFinal reportBombardier DHC-8-402 · Houston, TXthe nose landing gear alternate release handle was not pulled with sufficient enough force or distance to release the uplocks and allow extension of the nose landing gear. Contributing to the accident was the dissimilar pull force and pull length set on the…NTSB ERA12CA247Accident · No injuriesData collectionFinal reportMooney M20J · Butler, PAThe pilot’s failure to extend the landing gear before landing.NTSB DCA12WA038Accident · No injuriesForeign investigationFairchild SA-227 · Brisbane, AustraliaThe Australian Transportation Safety Bureau (ATSB) has notified the NTSB of an incident involving a Fairchild SA-227 that occurred on February 14, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the ATSB investigation under the…NTSB CEN12CA157Accident · Minor injuriesData collectionFinal reportCessna R182 · Colorado Springs, COThe pilot did not extend the landing gear before landing.NTSB CEN12CA136Accident · No injuriesData collectionFinal reportMooney M20K · Willmar, MNThe pilot landed without lowering the landing gear.NTSB WPR12LA097Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAThe pilot’s failure to review or execute any applicable checklist procedures or troubleshoot or take corrective action before landing despite indications that the landing gear was not extended. Contributing to the accident were the pilot’s misunderstanding of…NTSB ANC12CA012Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Kaltag, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's self-reported fatigue.NTSB CEN12CA036Accident · No injuriesData collectionFinal reportCessna 210J · West Chicago, ILThe pilot's failure to extend the landing gear before touchdown due to his failure to use a checklist.NTSB WPR12CA016Accident · No injuriesData collectionFinal reportBeech D17S · Phoenix, AZThe pilot's failure to extend the landing gear.NTSB CEN11LA632Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18-150 · Long Lake, WIThe pilot's failure to complete the prelanding checklist, which resulted in the landing gear wheels not being retracted for the water landing.NTSB CEN11IA615Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Baton Rouge, LAThe improperly installed upper attachment bolt in the left main landing gear uplock assembly, which led to the failure of the left main landing gear to extend before landing. Contributing to the accident was maintenance personnel's lack of training on the…NTSB CEN11CA561Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to extend the landing gear prior to landing.NTSB CEN11CA518Accident · No injuriesData collectionFinal reportCessna 180D · Oscoda, MIThe pilot's failure to retract the landing gear before a water landing. Contributing to the accident was the pilot's failure to use a checklist.NTSB ERA11CA382Accident · No injuriesData collectionFinal reportBeech A36 · Wauchula, FLThe pilot's failure to extend the landing gear during the approach.NTSB CEN11CA461Accident · No injuriesData collectionFinal reportPiper PA-24-180 · Amarillo, TXThe pilot's failure to lower the landing gear prior to landing.NTSB CEN11LA418Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Rantoul, ILThe pilot did not use the emergency landing gear extension system, which resulted in a wheels-up landing. Contributing to the accident was the inoperative landing gear power pack motor.NTSB ANC11CA044Accident · No injuriesData collectionFinal reportDouglas DC-6B · Cold Bay, AKThe flight crew's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. Contributing to the accident was the flight crew's diverted attention.NTSB CEN11IA379Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B19 · Milwaukee, WIThe failure of the right main landing gear (MLG) to extend normally, which resulted from the combination of a slightly worn uplock pin, the operation of the hydraulic pumps below their specified operating pressures, and contamination within the landing gear…NTSB ANC11LA041Accident · No injuriesLimited investigationFinal reportEclipse EA500 · Nome, AKThe pilot landed without lowering the landing gear. Contributing to the accident was the pilot's decision to fly the airplane with an inoperative wing flap system.NTSB ERA11CA238Accident · No injuriesData collectionFinal reportMooney M20K · Augusta, GAThe pilot's failure to extend the landing gear prior to landing. Contributing to the accident was the pilot’s reported fatigue.NTSB CEN11CA277Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Kansas City, MOThe pilot's failure to extend the landing gear for a landing.NTSB WPR11FA159Accident · No injuriesField investigationFinal reportFairchild SA227-AC · Seattle, WAThe pilot's failure to extend the landing gear, which resulted in a gear-up landing.NTSB CEN11CA216Accident · No injuriesData collectionFinal reportCessna A185F · Belle Chase, LAThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB CEN11CA212Accident · No injuriesData collectionFinal reportBeech G35 · Brenham, TXThe pilot’s failure to extend the landing gear during the approach resulting in a gear-up landing.NTSB WPR11CA142Accident · No injuriesData collectionFinal reportPiper PA-31P-350 · North Bend, ORThe pilot's failure to lower the landing gear while on approach to landing. Contributing to the accident was the pilot's failure to follow a written checklist during the approach portion of the flight.NTSB CEN11CA185Accident · No injuriesData collectionFinal reportPiper PA-28RT-201 · Danville, INThe pilot's failure to extend the landing gear prior to touchdown.NTSB WPR11CA130Accident · Minor injuriesData collectionFinal reportAllardyce Michael Glastar · Wilsonville, ORThe pilot's failure to raise the landing gear wheels prior to landing in water, resulting in a nose over.NTSB CEN11IA179Incident · No injuriesIncident investigationFinal reportCessna 210N · Columbia, MOThe pilot did not extend the landing gear before touchdown due to his distraction during the landing approach and his not using a landing checklist.NTSB WPR11CA141Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Aurora, ORThe pilot's failure to lower the landing gear prior to landing.NTSB CEN11CA113Accident · No injuriesData collectionFinal reportBeech 95-C55 · Ozark, ARThe pilot's failure to extend the landing gear prior to landing.NTSB ERA11CA076Accident · No injuriesData collectionFinal reportBeech 95-C55 · Williston, FLThe pilot's failure to properly configure and confirm the position of the landing gear prior to landing.NTSB DCA11WA007Incident · No injuriesForeign investigationBoeing 737 · Puerto Vallerta, MexicoOn November 4, 2010, a Global Airlines chartered Boeing 727-200, registered as XA-UHY, landed with its nose gear retracted at Licenciado Gustavo Díaz Ordaz International Airport (PVR), Puerto Vallerta, Mexico. The event is being investigated by the Government…NTSB ENG10IA055Incident · No injuriesIncident investigationFinal reportBombardier CL600 2B19 · Milwaukee, WIThe failure of the left main landing gear (MLG) to extend normally and manually for reasons that could not be conclusively determined.NTSB ENG10IA053Incident · No injuriesIncident investigationFinal reportBombardier CL600 2D24 · John F. Kennedy International Airport, NYThe probable cause of the incident was the restriction of the right main landing gear door against the fuselage wheel well body fairing which prevented the extension of the right main landing gear.NTSB CEN10LA564Accident · No injuriesLimited investigationFinal reportCessna 310K · Boerne Stage, TXThe pilot’s failure to ensure that the landing gear was extended prior to landing, resulting in a landing on the partially extended landing gear.NTSB ERA10LA478Accident · No injuriesLimited investigationFinal reportPiaggio P-180 · Clearwater, FLThe flight crew did not ensure that the landing gear was down and that it indicated down through the takeoff sequence.