NTSB investigations, 2011

5 cases where NTSB found Prescription medication.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 77 cases
20086
20095
20107
20115
20126
20133
20146
20158
20167
20177
20182
20194
20201
20214
20222
20231
20243

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\") = 2011
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02012025'))
  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 WPR11FA474Accident · 1 fatalField investigationFinal reportPoe G L/Poe S Y 540 · Chualar, CAThe pilot’s incapacitation due either to g-induced loss of consciousness alone or in combination with a cardiac arrhythmia. Contributing to the accident was the pilot’s use of several medications.Sep 30, 2011 · N42GP · Substantial damageNTSB CEN11FA629Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · West Liberty, OHThe pilot’s improper decision to fly aerobatic maneuvers at low altitude, which resulted in a loss of control and impact with terrain. Contributing to the accident was the pilot’s impairment due to his recent use of multiple impairing drugs.Sep 8, 2011 · N159JW · Substantial damageNTSB WPR11FA392Accident · 1 fatalField investigationFinal reportBriegleb BG-12B · Moore, IDThe pilot’s decision to perform a low pass over the runway in the opposite direction of his intended landing, and his subsequent failure to maintain airspeed and glider control during the reverse-course maneuver. Contributing to the accident was the effect of…Aug 18, 2011 · N559Y · 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 CEN11FA479Accident · 2 fatalField investigationFinal reportCessna 150L · Silverton, COThe pilot's failure to maintain control of the airplane while operating it at low levels above mountainous terrain and in excess of its maximum allowable gross weight, which resulted in an aerodynamic stall. The pilot's failure to maintain control resulted…Jul 14, 2011 · N1539Q · Substantial damage