Fatal NTSB investigations: NONE, 1997

6 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, 1997 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\") = 1997
    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 FTW98LA064Accident · 1 fatalLimited investigationFinal reportAdams A55S · Gallup, NMfailure of the ground crewman to follow proper procedures. A factor relating to the accident was: the passenger failed to follow the pilot's verbal instructions.Dec 6, 1997 · N1063V · No damageNTSB LAX98FA007Accident · 1 fatalField investigationFinal reportSchweizer 2-32 · Warner Springs, CAthe pilot's inadvertent flight into instrument meteorological conditions after inadvertently encountering mountain wave and associated downdraft conditions. The obscuration and high/mountainous terrain were related factors.Oct 11, 1997 · N242DB · Substantial damageNTSB ANC97FA159Accident · 1 fatalField investigationFinal reportde Havilland DHC-2 · Ketchikan, AKThe pilot's excessive climb and turning maneuver at low altitude, the pilot's inadvertent stall, and the intentional operation of the airplane with the required stall warning system disabled. Factors associated with this accident were the pilot's…Sep 30, 1997 · N4787C · DestroyedNTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.Aug 3, 1997 · N20146 · Substantial damageNTSB CHI97LA239Accident · 1 fatalLimited investigationFinal reportBriegleb BG-12A · Superior, WIthe separation of the wing from the glider for undetermined reasons.Aug 2, 1997 · N5516V · DestroyedNTSB ANC97FA024Accident · 1 fatalField investigationFinal reportde Havilland DHC-4A · Sparrevohn, AKloss of the right engine propeller control oil, which led to an overspeed of the right engine and propeller, and necessitated a shut-down of the right engine; and failure of the pilot to maintain adequate altitude/distance from terrain during visual approach…Jan 30, 1997 · N702SC · Destroyed