Fatal NTSB investigations

7 cases where NTSB found Residence/building.

Cases per year

20132026
Fatal NTSB investigations per year, 2013–2026: 7 cases
20133
20141
20161
20181
20221

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 c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022022'))
  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 WPR22FA151Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Heyburn, IDThe pilot’s failure to maintain altitude during an instrument approach, which resulted in a descent below the approach path and impact with a vent stack. Also causal was the failure of the processing plant to correctly paint the vent stacks, which had been…Apr 13, 2022 · N928JP · Substantial damageNTSB CEN19LA050Accident · 1 fatalLimited investigationFinal reportCessna R172K · Chesaning, MIThe pilot's loss of airplane control for reasons that could not be determined based on the available information.Dec 29, 2018 · N1095V · DestroyedNTSB CEN16FA333Accident · 1 fatalField investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain a normal approach path to the runway, which resulted in the airplane colliding with a tree and a house during final approach. Contributing to the accident was the pilot's lack of recent flight experience.Aug 25, 2016 · N17SK · Substantial damageNTSB WPR14FA320Accident · 1 fatalField investigationFinal reportMooney M20L - NO Series · San Diego, CAThe pilot's failure to achieve climb performance and maintain sufficient airspeed during a go-around, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot's failure…Jul 31, 2014 · N147MP · Substantial damageNTSB ERA14LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-161 · Elkmont, ALA stuck exhaust valve, which resulted in a total loss of engine power at low altitude. Contributing to the accident were the pilot’s decision to fly at a low altitude, which reduced his forced landing options when the loss of engine power occurred; and poor…Nov 30, 2013 · N8878E · DestroyedNTSB ERA13FA358Accident · 4 fatalField investigationFinal reportRockwell International 690B · East Haven, CTThe pilot's failure to maintain airspeed while banking aggressively in and out of clouds for landing in gusty tailwind conditions, which resulted in an aerodynamic stall and uncontrolled descent.Aug 9, 2013 · N13622 · DestroyedNTSB CEN13LA433Accident · 1 fatalLimited investigationFinal reportClayton Gerald H Glastar GS-1 · Columbus, INSlippage in the engine clutch and gear reduction module and a resultant uncommanded movement of the propeller blades into reverse thrust.Jul 25, 2013 · N513GC · Destroyed