NTSB investigations: Amateur-built UNKNOWN ENG, 2000

5 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Airframe/component/system failure/malfunction”. 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

19832026
NTSB investigations: Amateur-built UNKNOWN ENG, 2000 per year, 1983–2026: 94 cases
19835
19844
19852
19864
19872
19883
19894
19901
19914
19921
19932
19941
19952
19966
19981
19992
20005
20012
200211
20039
20045
20052
20068
20078

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\") = 2000
    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\" = 130))
  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 SEA01LA008Accident · 1 fatalLimited investigationFinal reportWildman Adventurer · Yelm, WAA main rotor blade strike (impact) with both a pusher propeller blade and the rudder during an unknown phase of operation resulting in a loss of control and uncontrolled descent to terrain.Oct 23, 2000 · N567AW · DestroyedNTSB CHI00LA215Accident · No injuriesLimited investigationFinal reportLutke Rotoway Exec 90 · Kalamazoo, MIthe loss of main rotor rpm due to the failure of the top engine mount and the subsequent loss of the main rotor drive belt tension. A factor was the confined area landing zone.Jul 22, 2000 · N1183M · Substantial damageNTSB DEN00LA132Accident · Minor injuriesLimited investigationFinal reportSpencer Long EZE · Farmington, NMFailure of the coolant recovery system, resulting in overheating of the engine. A factor was the soft ground on which the forced landing was made.Jul 17, 2000 · N51EZ · Substantial damageNTSB LAX00LA245Accident · 1 fatalLimited investigationFinal reportGarlick HH-1K · Live Oak, CAThe inadequate lubrication of the tail rotor drive shaft coupling by unknown maintenance personnel that resulted in the in-flight failure and separation of the helicopter's tail boom.Jun 29, 2000 · N896RP · DestroyedNTSB LAX00LA173Accident · No injuriesLimited investigationFinal reportRotorway Exec 162F · Chandler, AZThe inadequate maintenance inspection of the secondary shaft which resulted in its fatigue failure that emanated from a corroded circumferential score mark. A factor was the fence that the pilot flared to avoid, resulting in a hard landing.Apr 6, 2000 · N21901 · Substantial damage