NTSB investigations, ID

8 cases where NTSB found Main landing gear.

Cases per year

20082026
NTSB investigations, ID per year, 2008–2026: 8 cases
20082
20101
20121
20161
20181
20232

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\" = 'ID' 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 WPR23LA350Accident · No injuriesClass 3 · LimitedFinal reportCessna U206C · Challis, IDThe failure of the left main landing gear spring assembly due to a fatigue crack. Contributing to the accident was the improper maintenance on the landing gear spring assembly which allowed corrosion to develop.Sep 20, 2023 · N3923G · Substantial damageNTSB WPR23LA102Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Hayden, IDThe failure of the right main landing gearbox assembly due to fatigue cracking, which resulted in a loss of directional control during the landing roll.Jan 31, 2023 · N9235B · Substantial damageNTSB WPR18LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Lewiston, IDThe failure of a hydraulic line in the landing gear system, which resulted in the pilot's inability to lower the gear and a subsequent gear-up landing.May 29, 2018 · N7546K · Substantial damageNTSB GAA16CA136Accident · No injuriesData collectionFinal reportFox AL KIT FOX Model · Slate Creek, IDThe left main landing gear forward gear tube collapsed during the landing roll.Feb 7, 2016 · N6394R · Substantial damageNTSB WPR12CA234Accident · No injuriesData collectionFinal reportMurphy Rebel · Hayden Lake, IDThe pilots’ failure to position the landing gear for landing on the water, which resulted in a nose-over.May 3, 2012 · N1076D · Substantial damageNTSB WPR10IA482Incident · No injuriesIncident investigationFinal reportBeech F90 · Idaho Falls, IDThe partial retraction/collapse of the main landing gear during the landing roll for undetermined reasons.Sep 29, 2010 · N124BK · Minor damageNTSB SEA08CA186Accident · No injuriesData collectionFinal reportCessna 140A · Lowman, IDThe pilot's failure to maintain directional control during the landing roll.Aug 16, 2008 · N1161D · Substantial damageNTSB LAX08CA210Accident · No injuriesData collectionFinal reportCessna TU206G · Coeur d'Alene, IDThe pilot's failure to maintain proper runway alignment and clearance from a large rock on the side of the runway. Contributing to the accident was the failure of the pilot to maintain the runway environment of his private strip clear of obstructions.Jul 1, 2008 · N4776U · Substantial damage