NTSB investigations: Amateur-built UNKNOWN ENG, 2003, GA

5 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
NTSB investigations: Amateur-built UNKNOWN ENG, 2003, GA per year, 1964–2026: 61 cases
19641
19731
19782
19801
19842
19852
19861
19892
19901
19911
19921
19941
19951
19971
19981
20022
20035
20041
20052
20071
20082
20093
20102
20113
20121
20131
20142
20152
20164
20171
20192
20213
20244
20251

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\") = 2003
    AND c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
    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 ATL04LA019Accident · No injuriesLimited investigationFinal reportSpegele Mustang II · Calhoun, GAThe pilot's improper flare which resulted in a hard landing and subsequent landing gear collapse.Oct 16, 2003 · N262CS · Substantial damageNTSB ATL04LA001Accident · 1 fatalLimited investigationFinal reportJohnson Walter A Hornet · Saint Marys, GAThe loss of engine power due to improper maintenance and the pilot's failure to maintian airspeed during the attempted forced landing that resulted in a stall.Oct 1, 2003 · N1928J · Substantial damageNTSB ATL03LA141Accident · No injuriesLimited investigationFinal reportBellanca CH-300 · Peachtree City, GAThe pilots failure to maintain directional control during landing roll that resulted in a ground loop and subsequent collapse of the main landing gear.Sep 17, 2003 · N796W · Substantial damageNTSB ATL03LA106Accident · No injuriesLimited investigationFinal reportPolstra Zodiac CH 601 HDS · Thomson, GAThe total loss of engine power due to the fatigue fracture of the No. 3 cylinder intake valve, which resulted in a forced landing to rough terrain and subsequent collision with small trees and a tree stump.Jun 16, 2003 · N721PT · Substantial damageNTSB ATL03CA105Accident · Minor injuriesData collectionFinal reportAyers RV-6A · St. Simons Isld, GAThe pilot's inadequate preflight inspection that resulted in his failure to remove the seatbelt (flight control gust lock) from the right side flight control stick.Jun 11, 2003 · N221SA · Substantial damage