NTSB investigations, 2009
109 cases where the sequence of events included Landing gear collapse.
Cases per year
| 2008 | 124 |
|---|---|
| 2009 | 109 |
| 2010 | 95 |
| 2011 | 101 |
| 2012 | 101 |
| 2013 | 84 |
| 2014 | 75 |
| 2015 | 74 |
| 2016 | 143 |
| 2017 | 114 |
| 2018 | 130 |
| 2019 | 93 |
| 2020 | 80 |
| 2021 | 66 |
| 2022 | 65 |
| 2023 | 68 |
| 2024 | 107 |
| 2025 | 84 |
| 2026 | 76 |
Where
Latest cases
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 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\" = '094' 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" = '094' 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 CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.NTSB ERA10LA100Accident · No injuriesLimited investigationFinal reportFpna A-22 Valor · Hunting Island, SCMaintenance personnel's inadequate inspection of the oil system's fittings during a routine oil servicing, which resulted in oil starvation due to a loose and/or detached oil line B-nut fitting that led to the engine seizing while in flight.NTSB WPR10CA088Accident · No injuriesData collectionFinal reportAviat A1-A · West Jordon, UTThe pilot's failure to maintain directional control of the airplane during the landing roll in gusting wind conditions.NTSB ERA10IA095Incident · No injuriesIncident investigationFinal reportBeech 58 · Lexington, KYThe overstress failure of the nose landing gear aft drag brace.NTSB ERA10LA107Accident · No injuriesLimited investigationFinal reportMaule M5 · LaGrange, GAThe failure of the right main landing gear for undetermined reasons.NTSB ERA10CA068Accident · No injuriesData collectionFinal reportCessna C185F · Auburn, METhe pilot’s failure to maintain directional control while landing.NTSB ERA10CA079Accident · No injuriesData collectionFinal reportAir Gulfstream Airlines SX-300 · West Palm Beach, FLThe loss of directional control while landing for undetermined reasons.NTSB ERA10CA054Accident · No injuriesData collectionFinal reportPiper PA32 · Jacksonvile, FLThe pilot’s failure to maintain directional control during landing in gusty crosswind conditions.NTSB ERA10CA033Accident · No injuriesData collectionFinal reportElkins Christen Eagle II · Athens, KYThe pilot's improper liftoff, resulting in a collision with the ground during climbout.NTSB CEN10IA030Incident · No injuriesIncident investigationFinal reportCurtiss Wright P-40E · Lincoln, NEThe right landing gear's partial retraction during landing due to paint contamination of the landing gear handle detent.NTSB WPR10LA034Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Cedar City, UTThe failure of the landing gear accumulator/regulator and the installation of the improper priority valve, which precluded the landing gear from extending and locking into place.NTSB CEN10CA024Accident · No injuriesData collectionFinal reportCessna 170B · London, OHThe pilot's failure to maintain directional control during the takeoff roll.NTSB CEN10CA022Accident · Serious injuriesData collectionFinal reportGottelt Herbert R Kitfox IV/ · Crystal Falls, MIThe pilot's inability to maintain control due to an undetermined problem affecting lateral control of the airplane.NTSB ANC10CA002Accident · No injuriesData collectionFinal reportPiper PA-31-350 · Nondalton, AKThe pilot's decision to attempt a landing in weather conducive to strong downdrafts, resulting in a loss of control.NTSB WPR10CA011Accident · No injuriesData collectionFinal reportCessna 180 · Pistol Creek, IDThe separation of one of the airplane's main landing gear legs during landing in variable gusting wind conditions, due to the nut being stripped from the attachment bolt.NTSB ERA10LA005Accident · No injuriesLimited investigationFinal reportCessna 210 · Louisville, KYA malfunction of the landing gear extension system due to a fractured hydraulic line. Contributing to the accident was the inadequate inspection and maintenance of the hydraulic line.NTSB ERA10LA009Accident · No injuriesLimited investigationFinal reportButler Aerostar · Brooksville, FLThe collapse of the nose landing gear during landing rollout for undetermined reasons.NTSB WPR09CA468Accident · No injuriesData collectionFinal reportCessna 195 · Kingman, AZFailure of the right landing gear wheel attachment bolts.NTSB CEN09CA609Accident · No injuriesData collectionFinal reportAeronca 11AC · Augusta, KSThe pilot's failure to maintain directional control while landing with a quartering tailwind.NTSB ANC09CA109Accident · No injuriesData collectionFinal reportShort Bros. & Harland SC7 Series · Skwentna, AKThe pilot's failure to maintain directional control while landing on a rough, soft, and narrow airstrip.NTSB ENG09IA018Incident · No injuriesIncident investigationFinal reportBoeing 767 · Newark, NJFailure of Main Landing Gear (MLG) truck beam was due to contamination of the inner surface corrosion protective layers from hydraulic fluid and deice fluid that resulted in corrosion and intergranular stress corrosion cracking.NTSB WPR09LA475Accident · No injuriesLimited investigationFinal reportWaco QCF-2 · Bend, ORThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the pilot's lack of experience in the make and model airplane.NTSB ERA09LA540Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Gettysburg, PAThe failure of the left main wheel attachment fitting due to overstress.NTSB CEN09LA579Accident · Minor injuriesLimited investigationFinal reportCessna 172S · Park Rapids, MNThe pilot's failure to maintain a proper climb rate during a night takeoff.NTSB CEN09CA583Accident · No injuriesData collectionFinal reportSierra E5A Replica · Port Huron, MIThe pilot's failure to maintain aircraft control during landing.NTSB CEN09CA585Accident · Minor injuriesData collectionFinal reportCessna 170B · Dalhart, TXThe pilot’s decision to land with a tailwind resulting in a loss of directional control.NTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.NTSB CEN09LA573Accident · No injuriesLimited investigationFinal reportBeech B36TC · Sullivan, MOA loss of aircraft control for undetermined reasons.NTSB CEN09CA569Accident · No injuriesData collectionFinal reportCessna T210 · Tulsa, OKA temporary loss of elevator pitch control for undetermined reasons.NTSB WPR09CA434Accident · No injuriesData collectionFinal reportCessna 195 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.NTSB WPR09CA440Accident · No injuriesData collectionFinal reportUniversal Globe GC-1 · Pacoima, CAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR09CA439Accident · No injuriesData collectionFinal reportBellanca 17-30A · La Grande, ORThe pilot's improper flare, which resulted in a bounced landing.NTSB WPR09CA430Accident · No injuriesData collectionFinal reportCessna 152 · Merced, CAThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the nose landing gear strut.NTSB WPR09CA429Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR · San Diego, CAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB ERA09LA520Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Arcadia, FLThe pilot's bounced takeoff roll, which resulted in a collapsed landing gear. Contributing to the accident was the airplane's overweight condition.NTSB ERA09LA474Accident · No injuriesLimited investigationFinal reportCessna T210M · Dalton, GAThe failure of the right main landing gear actuator downlock spring.NTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.NTSB ERA09LA467Accident · No injuriesLimited investigationFinal reportCessna 140A · White Plains, NYThe failure of the right main landing gear due to a preexisting crack adjacent to a weld line.NTSB ERA09LA471Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Sanford, FLThe fatigue cracking at the point the nose landing gear actuator attaches to the mount resulting in separation of the actuator and partial collapse of the nose landing gear. Contributing to the accident was the lack of specific inspection guidance for…NTSB ERA09LA480Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Donalsonville, GAThe failure of the right main gear strut due to an improper weld repair by maintenance personnel.NTSB CEN09CA516Accident · No injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Harlan, IAThe pilot's failure to perform accurate weight and balance calculations which resulted in exceeding the maximum takeoff weight and the airplane's climb capability.NTSB ERA09WA552Accident · No injuriesForeign investigationMooney M20F · Warwickshire, United KingdomOn August 8, 2009, at 1218 UTC, a Mooney M20F, G-CEJN, was substantially damaged when the landing gear collapsed during landing at Wellesbourne Mountford Airfield, Warwickshire, United Kingdom. The pilot was not injured. Visual meteorological conditions…NTSB ERA09LA446Accident · No injuriesLimited investigationFinal reportLobb Kenneth CH 701 · Murfreesboro, TNA total loss of engine power due to the improper installation of the alternator drive gear.NTSB WPR09LA390Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Eatonville, WAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate in-flight fuel management. Contributing to the accident was the airplane's lack of an interconnected fuel vent system.NTSB ERA09CA443Accident · No injuriesData collectionFinal reportCessna 172S · Alabaster, ALThe student pilot's failure to maintain directional control during landing.NTSB ERA09CA437Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Lincoln Park, NJThe pilot's improper flare, which resulted in a bounced landing, and the subsequent collapse of the landing gear.NTSB WPR09LA383Accident · No injuriesLimited investigationFinal reportBeech 76 · Glendale, AZThe fatigue failure of the left main landing gear enhanced side brace assembly.NTSB WPR09LA457Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Ely, NVThe pilot's failure to maintain directional control during the landing roll.NTSB CEN09LA463Accident · No injuriesLimited investigationFinal reportPilgrim Samuel W JR RV-6 · Oshkosh, WIThe failure of the rudder pedal which resulted in the pilot's inability to maintain directional control of the aircraft.