Skip to content

NTSB investigations, 2009

30 cases where the defining event was Landing gear collapse.

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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '094') 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '094')
  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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '094')
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 ERA10CA079Accident · No injuriesData collectionFinal reportAir Gulfstream Airlines SX-300 · West Palm Beach, FLThe loss of directional control while landing for undetermined reasons.Nov 14, 2009 · N884 · Substantial damage NTSB ERA10CA033Accident · No injuriesData collectionFinal reportElkins Christen Eagle II · Athens, KYThe pilot's improper liftoff, resulting in a collision with the ground during climbout.Oct 25, 2009 · N78E · Substantial damage 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.Oct 24, 2009 · N4420K · Minor damage 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.Oct 8, 2009 · N1674C · Substantial damage NTSB ERA10LA009Accident · No injuriesLimited investigationFinal reportButler Aerostar · Brooksville, FLThe collapse of the nose landing gear during landing rollout for undetermined reasons.Oct 1, 2009 · N81FW · Substantial damage NTSB WPR09CA468Accident · No injuriesData collectionFinal reportCessna 195 · Kingman, AZFailure of the right landing gear wheel attachment bolts.Sep 28, 2009 · N190JS · Substantial damage 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.Sep 18, 2009 · N66051 · Minor damage NTSB ERA09LA540Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Gettysburg, PAThe failure of the left main wheel attachment fitting due to overstress.Sep 13, 2009 · N466CT · Substantial damage NTSB WPR09CA434Accident · No injuriesData collectionFinal reportCessna 195 · Camarillo, CAThe pilot's failure to maintain directional control during the landing roll.Sep 5, 2009 · N1508D · Substantial damage 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.Aug 27, 2009 · N40VS · Substantial damage NTSB ERA09LA474Accident · No injuriesLimited investigationFinal reportCessna T210M · Dalton, GAThe failure of the right main landing gear actuator downlock spring.Aug 22, 2009 · N732MM · Substantial damage 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.Aug 21, 2009 · N6038D · Substantial damage 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.Aug 17, 2009 · N9467A · Substantial damage 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.Aug 10, 2009 · N2292E · Substantial damage 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…Aug 8, 2009 · G-CEJN · No damage NTSB WPR09LA383Accident · No injuriesLimited investigationFinal reportBeech 76 · Glendale, AZThe fatigue failure of the left main landing gear enhanced side brace assembly.Jul 30, 2009 · N83ER · Substantial damage NTSB WPR09LA372Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Walla Walla, WAA tripped landing gear motor circuit breaker, which prevented the gear from fully locking in the down position, and subsequent collapse during landing. Contributing to the accident was the disabled landing gear warning horn.Jul 22, 2009 · N7504Y · Substantial damage NTSB CEN09CA457Accident · No injuriesData collectionFinal reportCessna 310 · Fort Worth, TXThe failure of the pivot pin in the side brace of the right main landing gear resulting in the gear collapse during taxi for undetermined reasons.Jul 10, 2009 · N3106L · Substantial damage NTSB ANC09LA064Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · Skwentna, AKA fracture of the airplane's tailwheel shock absorber linkage during taxi, resulting in the collapse of the tailwheel.Jul 7, 2009 · N777YA · Substantial damage NTSB WPR09CA319Accident · No injuriesData collectionFinal reportCessna LC-126C · Lincoln, CAA fatigue crack in the left main landing gear strut resulting in the collapse of the strut during the landing roll.Jun 30, 2009 · N1064D · Substantial damage NTSB WPR09LA297Accident · No injuriesLimited investigationFinal reportBellanca 17-31ATC · Roosevelt, UTThe retraction of the left main landing gear due to the failure of the extension and retraction actuator arm attach bolt. Contributing to the accident was the failure of maintenance personnel to discover the extensive elongation of the actuator attach fitting…Jun 19, 2009 · N14797 · Substantial damage NTSB ERA09IA338Incident · No injuriesIncident investigationFinal reportBombardier CL-600-2B1 · Atlanta, GAThe failure of the left main landing gear to extend due to high levels of particulate contamination in the hydraulic fluid.Jun 11, 2009 · N857AS · Minor damage NTSB CEN09CA315Accident · No injuriesData collectionFinal reportHolsclaw Francis E Starduster · Ranger, TXThe pilot's inability to maintain directional control due to the buckling of the right landing gear as a result of corrosion.May 23, 2009 · N42WT · Substantial damage NTSB CEN09CA307Accident · No injuriesData collectionFinal reportBeech C35 · Englewood, COThe collapse of the landing gear due to the mechanic's failure to properly wire the landing gear squat switch.May 19, 2009 · N1945D · Substantial damage NTSB ERA09IA267Incident · No injuriesIncident investigationFinal reportCessna 402C · Nantucket, MAInstallation of an improper bearing in the landing gear actuator.Apr 27, 2009 · N769EA · Minor damage NTSB WPR09LA171Accident · No injuriesLimited investigationFinal reportCessna 550 · Salt Lake City, UTThe uncommanded retraction of the right main landing gear hydraulic actuator strut for undetermined reasons.Mar 29, 2009 · N44FR · Substantial damage NTSB CEN09CA356Accident · No injuriesData collectionFinal reportBeech A36 · Charleston, MOThe pilot's inadvertent use of the landing gear selector handle instead of the flap handle during landing rollout, which resulted in the collapse of the nose landing gear.Mar 20, 2009 · N451S · Substantial damage NTSB ERA09LA210Accident · No injuriesLimited investigationFinal reportCessna 310K · Ocala, FLThe right main landing gear collapse as a result of the pilot's improper flare during a previous landing. Contributing to the accident was the flight instructor's inadequate supervision.Mar 18, 2009 · N6901L · Substantial damage NTSB ERA09LA209Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Lumberton, MSCollapse of the landing gear due to worn left main landing gear components.Mar 8, 2009 · N8560Y · Substantial damage NTSB ANC09CA033Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the main landing gear collapsing during taxi.Feb 27, 2009 · N3578Z · Substantial damage