Fatal NTSB investigations: Amateur-built UNKNOWN ENG, LA

6 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

19862026
Fatal NTSB investigations: Amateur-built UNKNOWN ENG, LA per year, 1986–2026: 6 cases
19861
19931
19941
19961
20021
20051

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\" = 'LA' AND c.\"eventCountry\" = 'USA'
    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 DFW05LA102Accident · 2 fatalLimited investigationFinal reportSpearman Raptor · Bogalusa, LAThe pilot's failure to maintain control of the airplane. A contributing factor was the pilot's lack of experience in the make/model airplane.Apr 12, 2005 · N750TP · DestroyedNTSB FTW02FA062Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Oak Grove, LAthe pilot's failure to maintain control of the airplane while maneuvering resulting in an inadvertent stall/spin.Jan 5, 2002 · N77RY · DestroyedNTSB FTW96FA216Accident · 2 fatalField investigationFinal reportNanchang CJ-6A · Shreveport, LAa loss of engine power due to failure of the pressure carburetor diaphragm which led to restricted fuel flow through the carburetor and eventual fuel starvation. Factors contributing to the accident were the unsuitable terrain and tall trees which resulted in…May 16, 1996 · N24AD · DestroyedNTSB FTW95FA047Accident · 1 fatalField investigationFinal reportGrumman-Schweizer G-164B · Wisner, LAThe pilot's failure to maintain minimum required airspeed for flight. A factor was the pilot's lack of total experience in the type of aircraft.Nov 16, 1994 · N48398 · Substantial damageNTSB FTW93LA263Accident · 1 fatalLimited investigationFinal reportWsk Pzl Mielec M-18A Dromader · Frogmore, LAThe pilot's failure to maintain clearance with the powerline. A factor was the dusk light condition.Sep 23, 1993 · N452TC · DestroyedNTSB FTW86FRD25Accident · 1 fatalFinal reportWSK PZL Mielec PZL-M18 · Mer Rouge, LAThe pilot pulled up steeply at the end of a spray run and started a turn-around. During this time he allowed the airspeed to bleed off to the point at which the aircraft stalled and entered a spin without sufficient altitude to recover before ground impact…Sep 15, 1986 · N2710L · Destroyed