NTSB investigations: Amateur-built UNKNOWN ENG, 2000

8 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Loss of engine power”. 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
NTSB investigations: Amateur-built UNKNOWN ENG, 2000 per year, 1982–2026: 120 cases
19823
19831
19842
19863
19876
19885
19892
19902
19911
19922
19933
19944
19954
19963
19972
19984
19993
20008
20016
200215
20038
20044
200512
20067
200710

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\" = 350))
  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 CHI00LA298Accident · No injuriesLimited investigationFinal reportMorrison E-RACER · Sugar Grove, ILthe owner/builder's inadequate modification to the engine air intake system and the inadvertent engine shutdown. Factors included the low air pressure of the air intake system and the excessive fuel flow to the manifold.Sep 12, 2000 · N345JM · Substantial damageNTSB CHI00LA224Accident · Minor injuriesLimited investigationFinal reportBohner Pitts Model 12 · Neosho, MOThe unsuitable terrain the pilot selected during his emergency landing. Factors were the hay rolls and the loss of engine power for undetermined reasons.Jul 26, 2000 · N811WS · Substantial damageNTSB NYC00LA176Accident · Minor injuriesLimited investigationFinal reportSchwarz Avid Amphibian · Fredericksburg, VAA failure of the propeller reduction gear assembly for undetermined reasons, which resulted in a loss of thrust.Jun 22, 2000 · N61HS · Substantial damageNTSB FTW00LA106Accident · Minor injuriesLimited investigationFinal reportWard Acro · Beasley, TXThe loss of engine power for an undetermined reason.Mar 25, 2000 · N79RW · Substantial damageNTSB LAX00LA118Accident · Serious injuriesLimited investigationFinal reportArrow OH-58A · Calipatria, CAThe pilot's inadequate checklist procedure prior to departure, which did not verify the fuel selector was in the proper position for flight, and the pilot's failure to maintain adequate main rotor speed for an autorotative landing.Mar 8, 2000 · N39FA · Substantial damageNTSB ATL00LA033Accident · Serious injuriesLimited investigationFinal reportAero Comp COMP-AIR-6 · Indiantown, FLThe maintenance personnel inadequate inspection of the fuel system that resulted in loss of engine power due to fuel filter contamination.Mar 5, 2000 · N61520 · Substantial damageNTSB LAX00LA082Accident · No injuriesLimited investigationFinal reportMince Jurka MJ77 · Rio Vista, CAThe loss of engine power during cruise flight for unknown reasons resulting in a forced landing in a plowed field.Jan 22, 2000 · N751JR · Substantial damageNTSB LAX00LA070Accident · Serious injuriesLimited investigationFinal reportHawker Siddeley Hunter F MK 4 · Chino, CAA loss of engine power for undetermined reasons. A factor was the particulate contamination in the fuel.Jan 8, 2000 · N72602 · Substantial damage