Fatal NTSB investigations, 2020

7 cases where the sequence of events included Miscellaneous/other.

Cases per year

20082026
Fatal NTSB investigations, 2020 per year, 2008–2026: 218 cases
200815
200912
201013
201116
201216
201319
201419
201515
201616
201711
201810
201913
20207
20219
20228
20238
20245
20254
20262

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\") = 2020
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '900' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 CEN21LA080Accident · 1 fatalClass 3 · LimitedFinal reportVans RV6 · Hitchcock, TXThe pilot’s impairment by the effects of ingested alcohol, which resulted in the loss of airplane control and impact with terrain.Dec 8, 2020 · N69HF · DestroyedNTSB WPR21LA061Accident · 1 fatalClass 4 · LimitedFinal reportCessna 172 · Arch Cape, ORThe pilot’s descent into the ocean for reasons that could not be determined.Nov 9, 2020 · N1444V · DestroyedNTSB WPR20LA176Accident · 1 fatalClass 3 · LimitedFinal reportVans RV4 · Safford, AZA loss of pitch control during the landing approach due to a jammed elevator control system.Jun 9, 2020 · N173CW · Substantial damageNTSB ERA20LA202Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA23 · San Juan, PRThe pilot’s intentional operation of the airplane with known deficiencies of the left engine and subsequent in-flight loss of control after takeoff. Contributing to the loss of engine power was internal contamination of the left servo fuel injector.…Jun 2, 2020 · N14181 · Substantial damageNTSB CEN20LA169Accident · 1 fatalClass 3 · LimitedFinal reportRans S-12 · Delta, COThe pilot’s exceedance of the airplane’s critical angle of attack during a test flight which resulted in an aerodynamic stall and impact with terrain.May 3, 2020 · N427LB · DestroyedNTSB WPR20LA131Accident · 3 fatalClass 3 · LimitedFinal reportBeech 35 · Currie, NVThe pilot’s failure to maintain airplane control during a forced landing which resulted in a hard landing for reasons that could not be determined based on available evidence.Apr 24, 2020 · N8743A · DestroyedNTSB CEN20FA072Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Florence, COThe pilot’s decision to continue the takeoff with reduced airplane performance due to high density altitudeFeb 2, 2020 · N5969W · Substantial damage