NTSB investigations, 2010

6 cases where NTSB found Alcohol.

Cases per year

20082026
NTSB investigations, 2010 per year, 2008–2026: 87 cases
20086
20095
20106
20117
20126
20134
20147
20157
20166
20172
20184
20196
20203
20212
20229
20232
20243
20252

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\") = 2010
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02012015'))
  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 CEN11LA045Accident · Serious injuriesLimited investigationFinal reportWalker Kenneth Sonex · San Angelo, TXThe pilot's loss of airplane control. Contributing to the accident was the pilot's impairment due to alcohol.Oct 29, 2010 · N234KS · Substantial damageNTSB WPR10LA441Accident · No injuriesLimited investigationFinal reportCessna TR182 · Spanish Fork, UTThe pilot did not extend the landing gear due to his impairment from alcohol.Aug 28, 2010 · N738MP · Substantial damageNTSB CEN10LA275Accident · 2 fatalLimited investigationFinal reportBellanca 7GCBC · Watertown, SDThe pilot's loss of airplane control while conducting aerobatic, low-altitude maneuvers. Contributing to the accident was the pilot's impairmant due to alcohol.May 29, 2010 · N88399 · Substantial damageNTSB ANC10FA038Accident · 1 fatalField investigationFinal reportPiper PA-18-135 · Willow, AKThe pilot's failure to maintain clearance from a tree due to the effects of impairment from alcohol consumption.May 14, 2010 · N1123 · Substantial damageNTSB ERA10LA206Accident · 2 fatalLimited investigationFinal reportCenter Charles C X-5 · Ghent, NYThe pilot's failure to maintain adequate airspeed during the initial climb, resulting in an aerodynamic stall. Contributing to the accident was the pilot's impairment.Apr 4, 2010 · N25761 · Substantial damageNTSB ERA10FA148Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Springfield, KYThe pilot's inadequate preflight planning, which resulted in a total loss of engine power due to fuel exhaustion, and the pilot's impairment due to alcohol. Contributing to the accident was the Federal Aviation Administration's failure to adequately oversee…Feb 23, 2010 · N7778W · Substantial damage