NTSB investigations, NM

7 cases where NTSB found Aircraft structures.

Cases per year

20082026
NTSB investigations, NM per year, 2008–2026: 7 cases
20081
20091
20102
20121
20141
20151

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\" = 'NM' 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\", '0103'))
  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 DCA15CA117Accident · No injuriesData collectionFinal reportTitan Aerospace Holdings Solara 50 · Otto, NMstructural failure of the left wing due to an overspeed condition.May 1, 2015 · N950TA · DestroyedNTSB CEN14CA246Accident · No injuriesData collectionFinal reportNorth American SNJ 6 · Santa Fe, NMThe pilot's loss of directional control during landing and subsequent go around attempt.May 18, 2014 · N5485V · Substantial damageNTSB CEN12CA121Accident · No injuriesData collectionFinal reportButler John R SX 300 · Truth or Consequences, NMThe pilot did not maintain airplane control during takeoff due to his distraction with the improperly secured canopy, which he forgot to latch.Jan 3, 2012 · N120J · Substantial damageNTSB CEN10CA542Accident · Minor injuriesData collectionFinal reportSchempp-Hirth Standard Cirrus · Moriarty, NMThe inadvertent opening of the cockpit canopy for undetermined reasons.Sep 5, 2010 · N4664 · Substantial damageNTSB CEN10LA474Accident · No injuriesLimited investigationFinal reportCessna A185F · Farmington, NMPre-existing damage of the through-bolt that attached the inboard end of the gear leg to the airframe hard-point, likely caused during maintenance on the gear.Aug 11, 2010 · N4492 · Substantial damageNTSB CEN09CA258Accident · No injuriesData collectionFinal reportMarlin Varieze · Santa Teresa, NMThe pilot's failure to maintain control of the airplane, his failure to latch the canopy prior to takeoff, and his failure to complete the pretakeoff checklist due to his diverted attention.Apr 20, 2009 · N77JM · Substantial damageNTSB DFW08CA222Accident · No injuriesData collectionFinal reportFairchild SW3 · Carlsbad, NMFailure of the door to remain secure for undetermined reasons.Aug 31, 2008 · N2699Y · Substantial damage