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 CEN10CA533Accident · No injuriesData collectionFinal reportPiper PA46-310P · Farmington, NMThe pilot’s premature retraction of the landing gear and the flaps during landing. Contributing to the accident was the inadvertent dimming of the cockpit lighting, resulting in a perceived unsafe gear configuration.NTSB WPR10LA441Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spanish Fork, UTThe pilot did not extend the landing gear due to his impairment from alcohol.NTSB CEN10LA524Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Greeley, COA loss of engine power for undetermined reasons.NTSB ERA10LA390Accident · 1 fatalLimited investigationFinal reportCessna A185F · Rockwood, METhe pilot's failure to retract the landing gear prior to a water landing. Contributing to the accident was the pilot's impairment due to medication.NTSB ERA10IA378Incident · No injuriesIncident investigationFinal reportCessna 402C · Hyannis, MAThe pilot's failure to extend the landing gear prior to landing flare and touchdown.NTSB WPR10LA340Accident · No injuriesLimited investigationFinal reportMooney M20F · Cottonwood, AZThe pilot’s failure to lower the landing gear prior to landing.NTSB CEN10CA341Accident · No injuriesData collectionFinal reportCessna R182RG · Albuquerque, NMThe pilot's failure to lower the landing gear. Contributing to the accident was the pilot's distraction with an erroneous airspeed indicator.NTSB WPR10CA270Accident · No injuriesData collectionFinal reportBeech C24R · Boise, IDThe pilot's failure to properly configure the landing gear for landing and the flight instructor's inadequate supervision.NTSB CEN10CA261Accident · No injuriesData collectionFinal reportSwearingen SA-226AT · West Memphis, ARFailure of both pilots to ensure that the airplane was properly configured for landing.NTSB CEN10CA258Accident · No injuriesData collectionFinal reportCalcote Clarence E Glasair RG · Lee's Summit, MOThe failure of the landing gear to fully extend and lock in the down position for unknown reasons.NTSB CEN10CA228Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Jamestown, NDThe pilot's failure to lower the landing gear, resulting in a gear-up landing.NTSB WPR10WA265Accident · No injuriesForeign investigationBeech 200 · Nadi, FijiOn April 25, 2010, at 1406 coordinated universal time, a Beech 200, French registry F-OIAN, landed with the gear retracted following an electrical system anomaly at the Nadia Airport, island of Fiji. The airplane was operated by Air Alize as an international…NTSB WPR10LA216Accident · No injuriesLimited investigationFinal reportCessna 210 · Show Low, AZInadequate clearance between a landing gear brake system line and airframe components, which precluded gear extension and resulted in an intentional gear-up landing.NTSB ERA10CA201Accident · No injuriesData collectionFinal reportBeech 95-B55 (T42A) · Sevierville, TNThe pilot's inadvertent retraction of the landing gear on the ground during a touch-and-go landing.NTSB CEN10FA164Accident · 1 fatalField investigationFinal reportMaule M-5-235C · Lewisville, TXThe pilot did not retract the landing gear before a water landing. Contributing to the accident was the pilot did not use a checklist.NTSB CEN10CA152Accident · No injuriesData collectionFinal reportBeech A35 · Marfa, TXThe pilot's failure to extend the landing gear.NTSB ERA10CA156Accident · No injuriesData collectionFinal reportPiaggio P180 · Greensboro, NCThe pilot's failure to properly configure the landing gear for landing. Contributing to the accident was the pilot's diverted attention looking for traffic and manipulating the secondary trim controls.NTSB CEN10LA128Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lockhart, TXThe flight instructor’s failure to use the emergency checklist, and his failure to extend the landing gear manually. Contributing to the accident was the electrical failure/malfunction for reasons undetermined.NTSB ERA10CA132Accident · No injuriesData collectionFinal reportSocata TBM 700 · Memphis, TNThe pilot’s failure to extend the landing gear before landing.NTSB CEN10LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · St. Louis, MOThe pilot's failure to properly follow the manual landing gear extension procedure, resulting in a gear-up landing.NTSB CEN10CA026Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Grand Forks, NDThe flight instructor's failure to ensure the landing gear was extended prior to landing.NTSB WPR09LA417Accident · No injuriesLimited investigationFinal reportPiper PA28R · Wendover, UTThe failure of the pilot to attain and maintain an airspeed sufficient for normal landing gear retraction during initial climb. Contributing to the accident was the pilot's failure to use the airplane's manual override landing gear system, misidentifying that…NTSB CEN09CA474Accident · No injuriesData collectionFinal reportBeech H-18 · Dayton, OHThe pilot's failure to lock the tailwheel during landing resulting in the loss of directional control.NTSB CEN09CA439Accident · No injuriesData collectionFinal reportPiper PA-28R-201 · West Chicago, ILThe pilot's failure to extend the landing gear resulting in a wheels-up landing. Contributing to the accident was the pilot being distracted by mowers near the approach end of the runway.NTSB CEN09IA416Incident · No injuriesIncident investigationFinal reportMooney M20J · Midland, TXThe pilot’s failure to ensure the airplane was properly configured, which resulted in a wheels-up landing.NTSB WPR09CA294Accident · No injuriesData collectionFinal reportDornier ALPHA-JET · Arlington, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident were the distractions created by the pilot incorrectly setting a radio frequency and by his fixation on an airplane that was on the runway during his approach.NTSB ERA09CA342Accident · No injuriesData collectionFinal reportBeech F33A · Rock Hill, SCThe pilot's failure to correctly extend the landing gear before landing.NTSB CEN09CA260Accident · No injuriesData collectionFinal reportCessna 210 · Richmond, INThe pilot under instruction's failure to lower the landing gear and the instructor pilot's inadequate supervision.NTSB WPR09FA212Accident · No injuriesField investigationFinal reportCessna T210L · Moab, UTThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's self-induced distraction by maneuvering on final to show a point of interest to passengers.NTSB ERA09CA245Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Tampa, FLThe pilot's failure to confirm that the landing gear was retracted prior to the attempted water landing.NTSB WPR09LA189Accident · No injuriesLimited investigationFinal reportBeech A36TC · Roseburg, ORThe pilot's failure to follow the landing checklist, which resulted in a gear up landing. Contributing to the accident was the pilot's diverted attention.NTSB ERA09CA234Accident · No injuriesData collectionFinal reportCessna 172RG · Charleston, SCThe pilot's failure to extend the landing gear before landing. Contributing to the accident was the diversion of the pilot's attention to an airplane on a converging final approach course.NTSB CEN09CA244Accident · No injuriesData collectionFinal reportMooney M20J · Salem, INThe pilot's failure to follow the landing checklist and extended the landing gear.NTSB WPR09CA120Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Lincoln, CAThe pilot's failure to extend the landing gear for landing. Contributing to the accident was the pilot's diverted attention due to an open door and the airport's pilot activated runway lights turning off.NTSB WPR09LA100Accident · No injuriesLimited investigationFinal reportCessna 210A · Henderson, NVAn undetermined failure of the hydraulic power pack to fully extend the main landing gear through both the normal and emergency systems.NTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.NTSB CEN09CA156Accident · No injuriesData collectionFinal reportRockwell International 500-S · Grand Forks, NDThe pilot's failure to extend the landing gear prior to touchdown.NTSB WPR09CA044Accident · No injuriesData collectionFinal reportCessna T210M · Hanford, CAThe failure of the pilot to use the before-landing checklist and extend the landing gear prior to landing.NTSB ERA09CA071Accident · No injuriesData collectionFinal reportCessna 172RG · Cleveland, MSThe pilot's failure to lower the landing gear prior to touchdown.NTSB WPR09CA101Accident · No injuriesData collectionFinal reportBeech K35 · Port Townsend, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident was the pilot's failure to use a checklist and the distraction caused by the discussion with the passenger.NTSB CEN09CA058Accident · No injuriesData collectionFinal reportMooney M20E · San Antonio, TXThe failure of the pilot to lower the gear before landing. Contributing to the accident was the pilot's failure to complete the before landing checklist.NTSB DEN08LA159Accident · No injuriesLimited investigationFinal reportCessna 172RG · St. Louis, MOThe improper maintenance performed resulting in a jammed nose landing gear door preventing the extension of the nose landing gear.NTSB DFW08CA227Accident · No injuriesData collectionFinal reportCessna 172RG · Almogordo, NMThe pilot's failure to extend the airplane's landing gear before landing.NTSB NYC08CA285Accident · Serious injuriesData collectionFinal reportHaines Searey · Sunapee, NHThe pilot's failure to ensure that the landing gear was retracted for the water landing.NTSB LAX08LA281Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Groveland, CAThe pilot's failure to ensure that the landing gear was retracted prior to the water landing.NTSB DFW08CA219Accident · No injuriesData collectionFinal reportPiper PA46-500TP · St. Louis, MOThe pilot's failure to ensure that the landing gear was placed in the down position prior to landing.NTSB CHI08CA259Accident · No injuriesData collectionFinal reportPiper PA-34-200T · East Tawas, MIThe pilot's failure to lower the landing gear prior to touchdown.NTSB MIA08LA159Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Kingston, RIThe pilot's misjudgment of speed and altitude while maneuvering to land during an emergency descent. Contributing to the accident was the partial loss of engine power.NTSB CHI08CA236Accident · No injuriesData collectionFinal reportBeech H35 · Bay City, MIThe checklist not followed and the inadvertent wheels up landing by the pilot.NTSB LAX08CA247Accident · No injuriesData collectionFinal reportMooney M20K · Chehalis, WAThe pilot's failure to lower the landing gear, resulting in a gear up landing.