NTSB investigations, 2012

6 cases where NTSB found OTC medication.

Cases per year

20082026
NTSB investigations, 2012 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\") = 2012
    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 WPR13FA056Accident · 2 fatalField investigationFinal reportMcdaniel RV-6-CH · Scio, ORThe pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.Nov 26, 2012 · N424D · Substantial damageNTSB CEN13LA046Accident · 1 fatalLimited investigationFinal reportSorensen Sprint Mxii · Groesbeck, TXThe pilot’s failure to maintain control of the noncertificated airplane during a go-around. Contributing to the accident was the pilot’s physical and psychological impairment.Nov 5, 2012 · N460JS · Minor damageNTSB ERA12LA528Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-19 · Dansville, NYThe pilot’s failure to maintain glider control while maneuvering. Contributing to the accident was the pilot’s impairment due to an over-the-counter sedating antihistamine.Aug 25, 2012 · N438AS · Substantial damageNTSB CEN12FA570Accident · 2 fatalField investigationFinal reportAmerican AA-1 · Llano, TXThe flight instructor’s delayed remedial action and inadequate supervision during practice traffic pattern work. Contributing to the accident was the flight instructor’s use of sedating medication on the day of the accident and airplane’s high angle of attack…Aug 25, 2012 · N5796L · Substantial damageNTSB WPR12FA282Accident · 4 fatalField investigationFinal reportAerospatiale AS350B · Camp Verde, AZThe pilot's improper decision to fly at a low altitude through a river canyon, contrary to voluntary guidance within the Special Conservation Area, which led to collision with a cable. Contributing to the pilot’s decision were his cognitive and psychomotor…Jun 30, 2012 · N729DP · Substantial damageNTSB ERA12FA319Accident · 1 fatalField investigationFinal reportCessna 177B · Honesdale, PAThe pilot pitching the airplane to an excessive nose-up attitude during an aborted landing, which resulted in increased induced drag, diminished airspeed, and an aerodynamic stall/spin. Contributing to the accident was the pilot’s use of a sedating…May 5, 2012 · N34539 · Substantial damage