NTSB investigations

66 cases where NTSB found Main landing gear attach sec.

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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01023211'))
  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 ERA11LA484Accident · No injuriesLimited investigationFinal reportNorth American TB-25N · Georgetown, DEMaintenance personnel's inadequate examination of the main landing gear during the airplane’s most recent conditional inspection, which resulted in the fatigue failure of the right main landing gear shock strut drag arm during the landing roll.Sep 4, 2011 · N9079Z · Substantial damageNTSB ANC11CA018Accident · No injuriesData collectionFinal reportCessna A185F · Aniak, AKThe inadvertent contact with a rut in the snow while taxiing, resulting in the collapse of the right main landing gear.Mar 19, 2011 · N5182H · Substantial damageNTSB CEN11LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Delphi, INThe pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.Mar 4, 2011 · N82429 · Substantial damageNTSB CEN10CA358Accident · No injuriesData collectionFinal reportCessna 180K · Cahokia, ILThe fatigue failure of the axle's attaching bolts during landing.Jun 26, 2010 · N2785K · Substantial damageNTSB CEN10CA321Accident · No injuriesData collectionFinal reportCessna A188B · Orange, TXThe loss of directional control during the takeoff roll due to an incorrectly maintained left main landing gear.Jun 9, 2010 · N9510J · Substantial damageNTSB WPR10LA207Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Fruitland, UTThe pilot’s improper landing flare.Apr 17, 2010 · N9019D · Substantial damageNTSB ERA10LA108Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Concord, NCA missing right main landing gear aft trunnion mount attachment nut.Jan 1, 2010 · N8985C · Substantial damageNTSB CEN10LA085Accident · No injuriesLimited investigationFinal reportCessna 210A · Robert Lee, TXThe collapse of the right main landing gear during landing for unknown reasons.Dec 25, 2009 · N9499X · Substantial damageNTSB 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 damageNTSB CEN09LA567Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Marshall, MIThe failure of the main landing gear attach point.Sep 5, 2009 · N3383E · Substantial damageNTSB 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 damageNTSB 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 damageNTSB 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 damageNTSB CEN09CA268Accident · No injuriesData collectionFinal reportLuscombe 8 · Terrell, TXThe failure of the landing gear due to undetected corrosion.Apr 22, 2009 · N2330K · Substantial damageNTSB DFW08IA126Incident · No injuriesIncident investigationFinal report2007 Savage Air Epic LT · Uvalde, TXThe pilot's excessive speed during a turn off the active runway to the taxiway which exceeded the lateral limits of the supporting landing gear structure resulting in the collapse of the left main gear.May 1, 2008 · N603JS · Minor damageNTSB DFW08CA099Accident · No injuriesData collectionFinal reportCessna 310Q · Roswell, NMThe airframe and powerplant mechanic's incorrect reassembly of the landing gear.Apr 11, 2008 · N7935Q · Substantial damage