Fatal NTSB investigations: NONE, 2004

8 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, 2004 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\") = 2004
    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 NYC04LA217Accident · 1 fatalLimited investigationFinal reportFirefly Galaxy 9 · Lewisburg, WVThe pilot's improper decision to attempt to board the balloon while it was ascending.Sep 25, 2004 · N2200Z · Minor damageNTSB ATL04LA178Accident · 1 fatalLimited investigationFinal reportSchleicher K6-CR · LaGrange, GAThe pilot's failure to maintain control of the aircraft which resulted in a stall and subsequent impact with terrain. Factors were the pilot's impairment due to marijuana and his unreported mental conditions.Sep 12, 2004 · N23Z · Substantial damageNTSB SEA04FA111Accident · 1 fatalField investigationFinal reportTeST TST-10 M · Enumclaw, WAAircraft control not maintained while maneuvering for landing. A proper glidepath was not maintained was a factor.Jun 21, 2004 · N410JP · Substantial damageNTSB IAD04LA022Accident · 1 fatalLimited investigationFinal reportMasak Scimitar · Alexandria, PAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the turbulent wind conditions.May 22, 2004 · N12PX · DestroyedNTSB LAX04LA203Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Reno, NVthe pilot's failure to maintain an adequate airspeed margin while performing a return to runway maneuver, which led to a stall and spin. Factors in the accident were: 1) the deteriorated condition of the glider towrope, which resulted in towrope failure…May 8, 2004 · N126PS · DestroyedNTSB ATL04LA094Accident · 1 fatalLimited investigationFinal reportFirefly F8B · Eatonton, GAThe overload failure of the windline quick release tiedown eyebolt.Apr 7, 2004 · N2200D · Minor damageNTSB SEA04LA063Accident · 1 fatalLimited investigationFinal reportGlasflugel STD Libelle 201B · Oso, WAThe pilot of the Glaser-Dirks (lead glider) failure to maintain clearance from the Glasflugel (trailing glider) resulting in a mid-air collision while maneuvering.Apr 2, 2004 · N161D · 2 aircraft · Substantial damageNTSB NYC04LA078Accident · 1 fatalLimited investigationFinal reportRaven Industries Rally RX7 · Nicholasville, KYThe pilot's improper decision to continue the inadvertent flight in variable wind conditions, which resulted in an impact with power lines. Factors were the variable wind conditions and the unsuitable takeoff area.Feb 28, 2004 · N4110M · Substantial damage