Fatal NTSB investigations, 2017

6 cases where the sequence of events included Attempted remediation/recovery.

Cases per year

20082026
Fatal NTSB investigations, 2017 per year, 2008–2026: 68 cases
20084
20092
20102
20111
20124
20133
20144
20158
20164
20176
20188
20192
20202
20213
20221
20237
20247

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\") = 2017
    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\" = '060' 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 ERA18FA012Accident · 1 fatalField investigationFinal reportBeech 35C33 · Whiteville, NCThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation, and his delayed reaction to the loss of engine power, which led to impact with trees as he was attempting to switch fuel tanks.…Oct 31, 2017 · N293GC · Substantial damageNTSB WPR17LA195Accident · 1 fatalLimited investigationFinal reportWalker Edgar E Glastar · Cascade, IDThe pilot's inadequate flight planning, preparation, and navigation, which resulted in the airplane entering a canyon that the pilot was unable to exit by climbing the airplane. Also causal were his in-flight decision-making and his execution of the course…Sep 2, 2017 · N65EW · DestroyedNTSB CEN17FA249Accident · 1 fatalField investigationFinal reportFlight Design Ctsw · Monticello, IAThe pilot's decision to fly with his large dog in the two-seat, light sport airplane, and the dog's likely contact with the flight controls during landing, which resulted in the pilot's loss of airplane control and a subsequent aerodynamic stall when the…Jul 1, 2017 · N62JN · Substantial damageNTSB CEN17LA181Accident · 1 fatalLimited investigationFinal reportAS+ AC 4 · Blair, NEThe pilot's loss of control due to his diverted attention as he attempted to close the canopy that opened during initial climb.May 13, 2017 · N358R · Substantial damageNTSB ERA17FA115Accident · 2 fatalField investigationFinal reportRyan Navion · Westhampton Beach, NYThe flight instructor's exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall/spin. Contributing to the accident was the flight instructor's failure to familiarize himself with the flight characteristics of the…Feb 26, 2017 · N4529K · DestroyedNTSB WPR17FA063Accident · 1 fatalField investigationFinal reportCessna 172 · Ramona, CAThe flight instructor's failure to ensure that adequate clearance from terrain was maintained after performance of a simulated engine failure maneuver, which resulted in controlled flight into terrain.Feb 12, 2017 · N2179L · Substantial damage