NTSB investigations, 2012

6 cases where NTSB found Cardiovascular.

Cases per year

20082026
NTSB investigations, 2012 per year, 2008–2026: 69 cases
20084
20091
20108
201112
20126
20136
20146
20155
20174
20183
20194
20201
20211
20224
20232
20242

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 year(c.\"eventDate\") = 2012
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02012050'))
  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 ERA13LA093Accident · 1 fatalLimited investigationFinal reportRussom Roy G Hummel H5 · Calhoun, GAThe pilot’s impairment or incapacitation due to the effects of medication, worsening cardiac disease, or cardiac arrhythmia, which resulted in his loss of control of the airplane.Dec 18, 2012 · N156FH · Substantial damageNTSB CEN13FA081Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Blair, NEThe pilot's loss of control due to physical incapacitation.Nov 29, 2012 · N720RC · Substantial damageNTSB ERA13FA039Accident · 2 fatalField investigationFinal reportBeech A36 · Hooksett, NHThe pilot's total incapacitation in flight due to an acute heart attack.Oct 25, 2012 · N4325W · Substantial damageNTSB CEN12FA378Accident · 4 fatalField investigationFinal reportIar Brasov IS-28B2 · Wallis, TXThe pilot’s failure to maintain adequate airspeed during an emergency situation, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s acute coronary event, which resulted from his severe…Jun 17, 2012 · N6388V · Substantial damageNTSB WPR12LA241Accident · 1 fatalLimited investigationFinal reportWestcott Prowler Jaguar · Salinas, CAThe pilot's inability to maintain airplane control during takeoff due to an incapacitating cardiac event.Jun 1, 2012 · N125CW · DestroyedNTSB CEN12FA154Accident · 1 fatalField investigationFinal reportCessna 172N · Floresville, TXThe medical incapacitation of the pilot due to a sudden cardiac arrhythmia or acute myocardial infarction.Feb 10, 2012 · N5427J · Substantial damage