Fatal NTSB investigations: NONE

9 cases on aircraft whose registry engine model is NONE, where the first occurrence was “In flight collision with terrain/water”. 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

19822026
Fatal NTSB investigations: NONE per year, 1982–2026: 9 cases
19821
19841
19871
20023
20053

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230))
  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 LAX05LA224Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude and his decision to turn toward higher terrain.Jul 3, 2005 · N31AP · DestroyedNTSB SEA05LA114Accident · 1 fatalLimited investigationFinal reportAvia Stroitel AC-4B · Wenatchee, WAThe pilot's failure to maintain terrain clearance for undetermined reasons.Jun 11, 2005 · N1198Z · DestroyedNTSB LAX05LA135Accident · 1 fatalLimited investigationFinal reportCameron Balloons A-210 · Marana, AZthe failure of the flying pilot to attain a proper climb rate and maintain an adequate clearance from rising terrain. Also causal was the commercial pilot's inadequate supervision of the flight and his delayed remedial action.Apr 13, 2005 · N210EW · Substantial damageNTSB LAX02LA291Accident · 1 fatalLimited investigationFinal reportPZL-Bielsko SZD-42-2 Jantar · Hemet, CAthe pilot's failure to maintain an adequate terrain clearance altitude.Sep 21, 2002 · N131AS · Substantial damageNTSB LAX02LA215Accident · 1 fatalLimited investigationFinal reportRolladen-Schneider LS8-18 · Incline Village, NVthe pilot's inadequate in-flight planning and failure to maintain an adequate clearance from terrain.Jul 6, 2002 · N818JF · Substantial damageNTSB DEN02LA067Accident · 1 fatalLimited investigationFinal reportSchreder RS-15 · Jackson, WYthe pilot's failure to maintain adequate clearance from the mountain summit.Jul 1, 2002 · N33515 · DestroyedNTSB MIA88FA008Accident · 1 fatalField investigationFinal reportExtra Flugzeugbau 230 · Arcadia, FLThe accident occurred while the aircraft was performing exhibition aerobatics at an airshow. The acft had just completed a portion of the planned low alt aerobatic sequence which included a tail slide & 3 rolls with the nose of the acft pointed toward the…Oct 17, 1987 · N230WF · DestroyedNTSB SEA84FA185Accident · 2 fatalField investigationFinal reportde Havilland Beaver DHC-2 · Ketchikan, AKThe plt flew into a canyon with a climb-out gradient in excess of the acft capability and collided with the upsloping terrain. The plt said he had hit a downdraft and turned away from the rising terrain just as collision occurred. Surviving passengers do not…Jul 26, 1984 · N4787C · DestroyedNTSB LAX82DXQ10Accident · 1 fatalFinal reportBroyill-Cowan-Murray BG12B · Yerington, NVAt about 1315 PDT, the pilot departed on a round robin cross-country flight from minden, Nevada to bridgeport California and return. He was participating in a region ii soaring championship (sport class). On the return leg of the trip, the pilot was oserved…May 22, 1982 · N612BG · Destroyed