NTSB investigations: Amateur-built UNKNOWN ENG, Outside the U.S.
15 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
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1987 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2014 | 2 |
| 2019 | 1 |
| 2022 | 2 |
| 2025 | 1 |
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.\"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.
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."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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB GAA25WA258Occurrence · No injuriesClass 4 · ForeignSukhoi SU31 · Lvivuk, UkraineNTSB GAA22WA297AccidentClass 5 · ForeignDan Hawken Titan T-51 · Soest, GermanyNTSB GAA22WA132Accident · 1 fatalClass 5 · ForeignSukhoi SU-31 · Ploiesti, RomaniaNTSB GAA19WA460Accident · 1 fatalForeign investigationDe Havilland DH82 · Hythe, United KingdomNTSB CEN15WA082Accident · 2 fatalForeign investigationGates Learjet 25D · Champoton, MexicoNTSB CEN15WA129Accident · No injuriesForeign investigationSiai-Marchetti S.205 18R · Speck-Fehraltorf, SwitzerlandNTSB DEN08WA037Accident · 1 fatalForeign investigationCirrus Design SR-20 · Jagel, GermanyNTSB DEN06WA122Accident · No injuriesForeign investigationCessna C210P · Hoexter, GermanyNTSB SEA05WA171Accident · 2 fatalForeign investigationAinsworth Lancair 4P Turbine · Sundre, Alberta, CanadaNTSB IAD99WA062Accident · 2 fatalForeign investigationLearjet 35A · Adwa, EthiopiaNTSB DCA99WA008Incident · No injuriesForeign investigationBoeing 727 · Point A Pitre, FranceNTSB DCA92RA020Accident · 30 fatalForeign investigationConvair 640 · Kafoutine, SenegalNTSB MIA87LA164Accident · 1 fatalLimited investigationFinal reportCessna 402C · Missing Acft, BahamasOn 5/27/87 at about 0915 EDT, the plt departed palm beach intl arpt (pbi) on a flt to marsh harbour, great abaco island, Bahamas. When the Acft did not arrive at the destination, a search was initiated. The Acft was not fnd & was presumed to have been…NTSB UNK66X0156Accident · No injuriesClosedBell 47G-5 · Episkopi, GreeceNTSB UNK65X0341Accident · No injuriesClosedNo American F51D · Corinto, Niue