NTSB investigations, GA

8 cases where NTSB found Main landing gear.

Cases per year

20082026
NTSB investigations, GA per year, 2008–2026: 8 cases
20081
20093
20101
20111
20181
20221

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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01023210'))
  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.

NTSB ERA22LA367Accident · Minor injuriesClass 4 · LimitedFinal reportVickers-Slingsby T65A · Butler, GAThe pilot’s retraction the landing gear just prior to touchdown on the runway.Jul 16, 2022 · N157HH · Substantial damageNTSB ERA18LA176Accident · No injuriesLimited investigationFinal reportCessna 337 · Atlanta, GAAn area of pitting and corrosion on the surface of the aluminum hydraulic line connecting the emergency handle/pump to the electric hydraulic pump, which resulted in a loss of hydraulic pressure and the pilot’s inability to extend the landing gear.May 29, 2018 · N86507 · Substantial damageNTSB ERA12LA117Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lawrenceville, GAThe mechanic's improper installation and lubrication of the bushing on the right main landing gear truss assembly, which resulted in the landing gear not locking in the down position.Dec 19, 2011 · N790GK · Substantial damageNTSB ERA10LA263Accident · No injuriesLimited investigationFinal reportHachem Zachery S E7 · Homerville, GAThe pilot’s improper flare, which resulted in a hard landing.May 12, 2010 · N101RU · Substantial damageNTSB ERA10LA107Accident · No injuriesLimited investigationFinal reportMaule M5 · LaGrange, GAThe failure of the right main landing gear for undetermined reasons.Dec 6, 2009 · N51620 · Substantial damageNTSB 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 damageNTSB 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 damageNTSB MIA08CA104Accident · No injuriesData collectionFinal reportCessna 172M · Savannah, GAThe pilot's failure to maintain directional control on landing touchdown with a crosswind.May 23, 2008 · N73471 · Substantial damage