Skip to content

NTSB investigations, 2009

27 cases where the sequence of events included Landing gear not configured.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20082026

Where

Latest cases

Query with SQL

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 year(c."eventDate") = 2009 AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '095' 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

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 year(c.\"eventDate\") = 2009
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '095' 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 year(c."eventDate") = 2009
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '095' 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 WPR10LA090Accident · No injuriesLimited investigationFinal reportCessna 310 · Pasco, WAThe failure of the right main landing gear up-lock.Dec 12, 2009 · N2640C · Substantial damage 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.Dec 11, 2009 · N411BL · Substantial damage NTSB ERA10LA042Accident · No injuriesLimited investigationFinal reportBeriev BE-103 · Miami, FLA malfunction of the landing gear retraction/extension and indication system for undetermined reasons, which resulted in one or more components being improperly positioned for the water landing.Oct 30, 2009 · N13KL · Substantial damage 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.Oct 22, 2009 · N593ND · Substantial damage NTSB CEN10LA014Accident · No injuriesLimited investigationFinal reportCessna T210L · Albuquerque, NMThe mechanic's failure to find and repair a leaking main landing gear hydraulic line during an annual inspection.Oct 14, 2009 · N211LC · Substantial damage NTSB ERA10LA004Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Whiteville, NCThe pilot's improper flare and subsequent hard landing during an intentional gear-up landing following multiple mechanical malfunctions. Also causal to the accident was an inoperative landing gear emergency-down valve which had blockage for undetermined…Oct 3, 2009 · N8809C · Substantial damage 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…Aug 27, 2009 · N4837T · Substantial damage 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.Jul 24, 2009 · N87711 · Substantial damage 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.Jul 14, 2009 · N3714T · Substantial damage 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.Jul 6, 2009 · N201FD · Minor damage NTSB CEN09LA415Accident · No injuriesLimited investigationFinal reportCessna 441 · Albuquerque, NMA malfunction of the landing gear selector switch and a loose fitting on the emergency extension system which rendered the landing gear system inoperable.Jul 3, 2009 · N988AE · Substantial damage 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.Jun 17, 2009 · N707XA · Substantial damage NTSB ERA09CA342Accident · No injuriesData collectionFinal reportBeech F33A · Rock Hill, SCThe pilot's failure to correctly extend the landing gear before landing.Jun 13, 2009 · N266DC · Substantial damage NTSB CEN09CA343Accident · No injuriesData collectionFinal reportCessna 404 · Englewood, COThe failure of the landing gear to extend due to the failure of a hydraulic line.Jun 6, 2009 · N37127 · Substantial damage 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.Apr 22, 2009 · N7409E · Substantial damage 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.Apr 20, 2009 · N367N · Substantial damage NTSB ERA09CA254Accident · Minor injuriesData collectionFinal reportAmerican Longevity Searey · Littleton, NCThe pilot's failure to ensure the landing gear was properly configured for the water landing.Apr 19, 2009 · N915TR · Substantial damage 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.Apr 11, 2009 · N1982P · Substantial damage 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.Apr 8, 2009 · N333HP · Substantial damage 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.Apr 5, 2009 · N6208V · Substantial damage NTSB CEN09CA244Accident · No injuriesData collectionFinal reportMooney M20J · Salem, INThe pilot's failure to follow the landing checklist and extended the landing gear.Apr 1, 2009 · N115MS · Substantial damage NTSB CEN09CA223Accident · No injuriesData collectionFinal reportBeech D35 · Taos, NMThe failure of the student pilot to complete the before landing checklist. Contributing to the accident was his failure to lower the landing gear before landing.Mar 16, 2009 · N342R · Substantial damage 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.Feb 20, 2009 · N8816P · Substantial damage NTSB CEN09CA169Accident · No injuriesData collectionFinal reportPiper PA-24-250 · Mineral Wells, TXThe failure of the airframe and power plant mechanic to ensure proper lubrication of wire cables in the landing gear system during the annual inspection which precluded safe operation of the landing gear system.Feb 3, 2009 · N5451P · Substantial damage 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.Jan 27, 2009 · N210TF · Substantial damage NTSB CEN09CA125Accident · No injuriesData collectionFinal reportCessna T210L · Albuquerque, NMThe pilot's failure to remove the airplane's tow bar before takeoff.Jan 10, 2009 · N211LC · Substantial damage NTSB ERA09LA130Accident · No injuriesLimited investigationFinal reportCessna 550 · Wilmington, NCA loss of engine power due to the crew's inadequate in-flight fuel monitoring.Jan 4, 2009 · N815MA · Substantial damage