Fatal NTSB investigations: NONE, 2014

5 cases on aircraft whose registry engine model is NONE. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases per year

19642026
Fatal NTSB investigations: NONE, 2014 per year, 1964–2026: 190 cases
19642
19652
19681
19701
19713
19721
19731
19742
19761
19774
19784
19793
19804
19817
19824
19837
19845
19852
19863
19873
19886
19893
19903
19914
19924
19931
19941
19963
19976
19991
20001
20013
20026
20035
20048
20058
20063
20074
20084
20092
20105
20117
20122
20132
20145
20153
20162
20171
20188
20193
20203
20213
20224
20241
20251
20264

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\") = 2014
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
  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 DCA15MA019Accident · 1 fatalClass 1 · MajorFinal reportScaled Composites 339 · Koehn Dry Lake, CAScaled Composites' failure to consider and protect against the possibility that a single human error could result in a catastrophic hazard to the SpaceShipTwo vehicle. This failure set the stage for the copilot's premature unlocking of the feather system as a…Oct 31, 2014 · N339SS · DestroyedNTSB WPR14LA263Accident · 1 fatalLimited investigationFinal reportKnell ASC Spirit · Lehi, UTThe pilot’s exceedance of the glider’s critical angle of attack while maneuvering in a steep turn at low altitude, which resulted in an aerodynamic stall.Jun 22, 2014 · N127JK · Substantial damageNTSB ERA14LA290Accident · 1 fatalLimited investigationFinal reportCameron Balloons US Z-225 · Spring City, PAThe pilot's fall from the balloon’s basket during touchdown in a field for reasons that could not be determined based on the available evidence, which resulted in his fatal injury.Jun 15, 2014 · N65625 · No damageNTSB ERA14FA231Accident · 3 fatalField investigationFinal reportEagle C-7 · Ruther Glen, VAThe pilot’s inadequate approach and his failure to maintain clearance from power lines, which resulted in a subsequent fire.May 9, 2014 · N3016Z · DestroyedNTSB WPR14FA181Accident · 1 fatalField investigationFinal reportAero Tek Zuni · Aguila, AZThe pilot's inability to maintain control of the glider after the tow cable separated prematurely due to an incomplete engagement of the cable in the control tow release system due to a missing spring.May 3, 2014 · N22DA · Substantial damage