NTSB investigations, NM

5 cases where NTSB found Alertness/Fatigue.

Cases per year

20082026
NTSB investigations, NM per year, 2008–2026: 5 cases
20081
20092
20131
20161

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\", '020135'))
  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 GAA16CA320Accident · No injuriesData collectionFinal reportBeech 77 · Santa Fe, NMThe pilot's decision to takeoff over the maximum takeoff weight in high density altitude conditions, which resulted in an inability to climb above terrain, a forced landing, and a collision with a road sign. Contributing to the accident was the pilot's…Jun 16, 2016 · N60189 · Substantial damageNTSB CEN13LA464Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Santa Teresa, NMThe pilot’s failure to maintain clearance from a tree at the completion of an agricultural spray run. Contributing to the accident was the pilot’s decision to accept a high level of risk to spray a small field bordered by multiple obstacles and his fatigue…Aug 6, 2013 · N3789E · Substantial damageNTSB CEN09CA372Accident · No injuriesData collectionFinal reportCessna 177 RG · Albuquerque, NMThe pilot's failure to maintain adequate airspeed while landing, resulting in an aerodynamic stall.Jun 22, 2009 · N1876Q · Substantial damageNTSB CEN09PA348Accident · 2 fatalClass 1Final reportAgusta A109E · Santa Fe, NMThe pilot's decision to take off from a remote, mountainous landing site in dark (moonless) night, windy, instrument meteorological conditions. Contributing to the accident were an organizational culture that prioritized mission execution over aviation safety…Jun 10, 2009 · N606SP · DestroyedNTSB DEN08FA162Accident · 1 fatalField investigationFinal reportPilatus PC-12/47E · Santa Fe, NMThe pilot's incapacitation due to fatigue resulting in an in-flight collision with terrain.Sep 30, 2008 · N606SL · Destroyed