NTSB investigations, MI

6 cases where NTSB found Impairment/incapacitation.

Cases per year

20092026
NTSB investigations, MI per year, 2009–2026: 6 cases
20091
20113
20151
20241

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\", '020120'))
  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 CEN24FA215Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Clinton, MIThe flight instructor’s failure to maintain airplane control while maneuvering for a forced landing. Contributing to the accident was the student pilot’s or flight instructor’s inadvertent positioning of the fuel selector valve between the Left Tank and Off…Jun 10, 2024 · N1039X · Substantial damageNTSB CEN15LA398Accident · Serious injuriesLimited investigationFinal reportBuckeye Dream Macine · Zeeland, MIThe noncertificated pilot's impairment due to alcohol consumption, which resulted in his failure to maintain clearance from a tree.Aug 8, 2015 · UNREG · DestroyedNTSB CEN11FA666Accident · 2 fatalField investigationFinal reportRobinson Helicopter R44 · Curren, MIThe non-instrument-rated pilot's decision to continue visual flight into instrument meteorological conditions, which resulted in controlled flight into trees and the ground. Contributing to the accident was the pilot's impairment from multiple drugs.Sep 24, 2011 · N8324F · Substantial damageNTSB CEN11FA480Accident · 1 fatalField investigationFinal reportTaylorcraft DCO-65 · Boyne City, MIThe pilot failed to maintain airplane control while maneuvering at low altitude, which resulted in a stall/spin and impact with the terrain.Jul 16, 2011 · N50408 · Substantial damageNTSB CEN11LA365Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 (PT17) · Freemont, MIThe pilot’s failure to attain a positive climb rate following takeoff for reasons that could not be determined because the propeller was not provided for further examination. Contributing to the accident was the pilot's impairment from alcohol.May 27, 2011 · N60147 · Substantial damageNTSB CEN09IA606Incident · No injuriesIncident investigationFinal reportSaab 340B · Traverse City, MIThe flight attendant's incapacitation due to an anxiety attack.Jul 31, 2009 · N452XJ · No damage