NTSB investigations: Amateur-built UNKNOWN ENG, WA

5 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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

19842026
NTSB investigations: Amateur-built UNKNOWN ENG, WA per year, 1984–2026: 5 cases
19841
19851
19911
19961
20071

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.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('99999')
      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\" = 351))
  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 SEA07FA195Accident · 1 fatalField investigationFinal reportYakovlev YAK-55M · Everett, WAThe pilot's inadequate preflight planning and inspection that led to oil exhaustion and a catastrophic engine failure. Also causal was the pilot's attempted operation of an aircraft with known deficiencies, and the lack of a current airworthiness inspection.…Jul 14, 2007 · N55NH · DestroyedNTSB SEA96LA196Accident · Serious injuriesLimited investigationFinal reportWestcott Glasair I-FT · Puyallup, WAfailure of the air inlet screen, and subsequent ingestion of the foam air filter. An inadequate maintenance modification by the amateur builder and no suitable landing area were related factors.Aug 21, 1996 · N289W · Substantial damageNTSB SEA91LA092Accident · Minor injuriesLimited investigationFinal reportSmelser KR-2 · Spokane, WAA failure of the fuel drain valve which resulted in fuel exhaustion and a loss of engine power.Apr 20, 1991 · N570TS · Substantial damageNTSB SEA85FA156Accident · 1 fatalField investigationFinal reportKibler-Bede BD-5B · Oak Harbor, WAPrior to the acdnt, witnesses aprx 9 mi sw of the crash site saw an acft (matching the description of N5KB) flying at about 100 to 200 ft over the water on a NE heading. It then pulled up in a steep climbing turn toward the shoreline. No known witnesses saw…Jun 29, 1985 · N5KB · DestroyedNTSB SEA84LA156Accident · No injuriesLimited investigationFinal reportMonett-Keating Moni · Bremerton, WAThe pilot stated he had shut down the engine several times to glide. On the last restart the engine ran for aprx 15 secsand then began to run rough and died. Attempted restarts were not successful. The aircraft failed to clear trees while attempting to land…Jul 3, 1984 · N193RK · Substantial damage