NTSB investigations, 2011

6 cases where NTSB found OTC medication.

Cases per year

20082026
NTSB investigations, 2011 per year, 2008–2026: 56 cases
20085
20096
20104
20116
20126
20135
20147
20153
20162
20174
20181
20192
20202
20211
20221
20231

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\", '02012030'))
  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 WPR12FA044Accident · 1 fatalField investigationFinal reportMooney M20M · Pomona, CAThe pilot’s failure to maintain sufficient altitude to clear obstructions while maneuvering on the base leg of the traffic pattern for landing.Nov 18, 2011 · N741SB · Substantial damageNTSB ANC11FA107Accident · 1 fatalField investigationFinal reportDehavilland DHC-3T · Kodiak, AKThe pilot’s failure to maintain clearance from a tree during a low altitude maneuver and his failure to maintain control of the airplane. Contributing to the accident was the pilot’s use of over-the-counter sedating medications.Sep 24, 2011 · N361TT · Substantial damageNTSB WPR11FA268Accident · 1 fatalField investigationFinal reportTrusty Thorp T-18 · Tehachapi, CAThe pilot’s failure to maintain clearance from mountainous terrain during cruise flight, which resulted from his impairment or incapacitation due to multiple medical conditions and sedating medication.Jun 20, 2011 · N851LT · Substantial damageNTSB WPR11LA223Accident · 1 fatalLimited investigationFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Arlington, WAThe pilot’s failure to maintain control during the takeoff climb, which resulted in a stall at low altitude and collision with terrain. Contributing to the accident was the pilot’s impaired performance from over-the-counter medications.May 14, 2011 · N282SC · Substantial damageNTSB ERA11FA218Accident · 2 fatalField investigationFinal reportCessna 310R · Pikeville, KYThe pilot's flight below the published minimum descent altitude in instrument meteorological conditions, which resulted in a collision with trees and the ground. Contributing to the accident was the pilot's use of nighttime cold medication at doses above…Mar 30, 2011 · N1914G · Substantial damageNTSB ERA11FA151Accident · 1 fatalField investigationFinal reportCessna 150E · Ware Shoals, SCThe non-certificated pilot's impairment due to alcohol and a sedating antihistamine, which resulted in his failure to maintain airspeed and the subsequent aerodynamic stall and ground impact.Feb 19, 2011 · N3022J · Substantial damage