Fatal NTSB investigations: Amateur-built UNKNOWN ENG, 2000

9 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG. 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: Amateur-built UNKNOWN ENG, 2000 per year, 1964–2026: 421 cases
19641
19651
19662
19701
19712
19721
19751
19761
19772
19783
19792
19801
19812
19826
19835
19842
19855
19865
19878
19881
19891
19905
19912
19925
19935
19947
19958
19965
19973
19987
19997
20009
20018
200215
200321
200418
200520
200621
200719
200817
200919
201010
201112
201214
201314
201413
20157
20168
20175
201811
201913
20207
20217
20226
20235
20249
20252
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\") = 2000
    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 ('99999'))
  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 MIA00LA234Accident · 1 fatalLimited investigationFinal reportEachon Time Warp Spitfire 9 · Lakeland, FLa loss of control which resulted in an inadvertent stall at too low an altitude to allow recovery. Factors in this accident were, the pilot/owner did not verify that the airplane was balanced before the flight, and he did not perform any weight or balance…Aug 8, 2000 · N355DE · DestroyedNTSB CHI00FAMS2Accident · 1 fatalMissing aircraftFinal reportPeters RAF 2000 · Manistique, MIundetermined.Jul 29, 2000 · N11ZK · DestroyedNTSB CHI00LA226Accident · 1 fatalLimited investigationFinal reportHalsmer Crazy 8 · Lafayette, INAircraft control not being maintained by the pilot during the forced landing. Factors to the accident were the engine failure due to an overtemperature, the pilot's lack of familiarity with the aircraft, and the trees.Jul 27, 2000 · N9034L · DestroyedNTSB 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 LAX00LA242Accident · 1 fatalLimited investigationFinal reportWorldwide Aero AEROS-40B · San Bernadino, CAThe ground crew's diverted attention toward the landing airship while trying to catch a mooring rope, which resulted in their failure to detect an immenient collision with each other.Jun 28, 2000 · N819AC · No damageNTSB NYC00LA141Accident · 1 fatalLimited investigationFinal reportCarlson Criquet · East Palestine, OHThe failure of the powerplant to produce adequate power for undetermined reasons, and the pilot's continued operation of the airplane with known deficiencies.May 24, 2000 · N22CA · DestroyedNTSB LAX00FA148Accident · 2 fatalField investigationFinal reportFouga 6 CM 170 · San Joaquin, CAThe pilot's intentional performance of aerobatic maneuvers that resulted in the aircraft stalling and entering a spin from which he did not recover. A factor in the accident was the pilot's lack of experience in the aircraft.Apr 9, 2000 · N495F · DestroyedNTSB LAX00FA122Accident · 1 fatalField investigationFinal reportPiper PA-12 · Cima, CAIn-flight collision with terrain for undetermined reasons.Mar 7, 2000 · N7586H · Destroyed