NTSB investigations, MI

5 cases where NTSB found Main landing gear.

Cases per year

20102026
NTSB investigations, MI per year, 2010–2026: 5 cases
20101
20162
20181
20201

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\" = 'MI' 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 CEN20CA254Accident · Minor injuriesClass 4 · Data collectionFinal reportVolmer VJ22 · Erie, MIThe pilot's failure to ensure that the amphibious airplane’s wheels were retracted before attempting a water landing, resulting in a nose over during touch down. Contributing to the accident was the lack of a checklist available to the pilot.Jun 27, 2020 · N59262 · Substantial damageNTSB CEN18LA112Accident · No injuriesLimited investigationFinal reportPiper PA 28 · Mackinac Island, MIThe improper reinstallation of the right main landing gear by maintenance personnel which resulted in the separation of the landing gear and the subsequent abnormal runway contact during the landing.Feb 26, 2018 · N1722J · Substantial damageNTSB GAA16CA275Accident · No injuriesData collectionFinal reportCessna 170 · Saginaw, MIThe pilot's exceedance of the critical angle of attack during the landing flare, which resulted in an aerodynamic stall, hard landing, right main landing gear collapse, runway excursion, and nose over.May 30, 2016 · N1441D · Substantial damageNTSB CEN16LA190Accident · No injuriesLimited investigationFinal reportBeech C24R · Marine City, MIThe misalignment of the right main landing gear, which resulted in the failure of the landing gear to retract and extend properly. Also causal was the pilot's failure to have the airplane inspected after a hard landing that had resulted in substantial damage…May 22, 2016 · N20135 · Substantial damageNTSB CEN10LA210Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Three Rivers, MIThe pilot's inability to maintain directional control during landing due to the failure of the left main landing gear torque link as a result of fatigue.Apr 12, 2010 · N3470R · Substantial damage