Fatal NTSB investigations: Amateur-built UNKNOWN ENG

12 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “In flight collision with object”. 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

19892026
Fatal NTSB investigations: Amateur-built UNKNOWN ENG per year, 1989–2026: 12 cases
19891
19932
19941
19991
20033
20041
20051
20072

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.\"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')
      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\" = 220))
  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 CHI08LA037Accident · 2 fatalLimited investigationFinal reportPadelt PG37-1 · Hampton, IAThe pilot's inadequate in-flight planning which resulted in the failure to maintain clearance with the power lines. Contributing to the accident was the power line.Nov 16, 2007 · N4448Y · Substantial damageNTSB CHI07FA052Accident · 1 fatalField investigationFinal reportBeech 58 · Washington, INThe pilot's failure to maintain clearance from trees and terrain while attempting to return to the departure airport for undetermined reasons after takeoff. The intervening tree line was a contributing factor.Jan 2, 2007 · N678DC · DestroyedNTSB ATL05LA113Accident · 1 fatalLimited investigationFinal reportMize Donald Kolb MK III X · Dickson, TNThe pilot's failure to maintain adequate obstacle clearance during climb out which resulted in the in-flight collision with a tree.Jun 24, 2005 · N194DM · Substantial damageNTSB FTW04FA167Accident · 2 fatalField investigationFinal reportBell 206B · Cushing, OKthe pilot's inadequate in-flight planning/decision and his failure to maintain obstacle clearance. Contributing factors were low altitude flight, sun glare, and the static wires.Jun 27, 2004 · N27TV · DestroyedNTSB MIA03LA045Accident · 1 fatalLimited investigationFinal reportBornhofen Twinjet 1500 · Melbourne, FLthe pilot-in-command failed to obtain sufficient altitude to clear obstacles at the approach end of the airport which resulted in an in-flight collision with trees.Jan 24, 2003 · N750TJ · DestroyedNTSB LAX03FA072Accident · 1 fatalField investigationFinal reportCirrus Design SR 20 · San Jose, CAThe pilot's failure to maintain the course for the published approach procedure due to his diverted attention. The distraction responsible for the pilot's diverted attention was the erroneous frequency assignment provided by ATC and the resultant task…Jan 24, 2003 · N893MK · DestroyedNTSB ATL03LA037Accident · 1 fatalLimited investigationFinal reportLong 2000 · Brewton, ALThe pilot's improper use of flight controls (cyclic and collective) and failure to maintain rotor RPM while maneuvering that resulted in the separation of the tailboom assembly.Jan 24, 2003 · N8YF · Substantial damageNTSB NYC99LA221Accident · 1 fatalLimited investigationFinal reportValenza Volksplane VP-II · Westmore, VTThe pilot's failure to maintain adequate altitude/clearance from the trees. A related factor was the pilot's lack of familiarity with the airplane.Sep 6, 1999 · N8535B · DestroyedNTSB FTW95FA020Accident · 1 fatalField investigationFinal reportBrantly Helicopter B-2 · Artesia, NMThe pilot's impairment of judgment and performance due to drugs, and his failure to maintain clearance from a powerline.Oct 22, 1994 · N5905X · DestroyedNTSB 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 LAX93LA148Accident · 1 fatalLimited investigationFinal reportLangerud Varieze · Zenia, CAThe pilot's poor weather evaluation and continued flight into instrument meteorological conditions. The low ceiling was a factor.Mar 2, 1993 · N91CL · DestroyedNTSB ATL89FA196Accident · 1 fatalField investigationFinal reportBeech A-36 · Chapel Hill, NCThe pilot's failure to maintain control of the airplane while maneuvering for a landing. Contributing factors were: the pilot's failure to follow the emergency procedures for an autopilot malfunction, and pilot fatigue.Aug 12, 1989 · N25805 · Destroyed