Ongoing NTSB investigations: Amateur-built UNKNOWN ENG
7 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the defining event was Loss of engine power (total). 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
| 2025 | 4 |
|---|---|
| 2026 | 3 |
Where
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.\"completionStatus\" = 'Ongoing'
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341'))
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."completionStatus" = 'Ongoing'
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '341'))
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 WPR26LA331Accident · Serious injuriesClass 4 · LimitedInvestigation openFilip Richard/Fakowee Avia Indus Thrp T211 SP E · Benson, AZNTSB ERA26LA303Accident · Serious injuriesClass 3 · LimitedPreliminary reportMcfarland Larry C Zenith 601 HDS · Ripley Landing, WVOn August 15, 2026, about 1300 eastern daylight time, an experimental, amateur-built Zenith 601 HDS airplane, N601EZ, was substantially damaged when it was involved in an accident near Ripley Landing, West Virginia. The private pilot was seriously injured.…NTSB ERA26LA231Accident · Serious injuriesClass 3 · LimitedPreliminary reportOlson/Williams Sonex · Jaffrey, NHOn June 5, 2026, at 1100 eastern daylight time, an experimental amateur-built Sonex airplane, N28YD, was substantially damaged when it was involved in an accident near Jaffrey, New Hampshire. The private pilot was seriously injured. The flight was conducted…NTSB CEN26LA060Accident · Serious injuriesClass 3 · LimitedPreliminary reportSonerai II · Cresson, TXOn December 12, 2025, about 1431 central standard time, a Sonerai II airplane, registration N28MD, was substantially damaged when it was involved in an accident near Cresson, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code…NTSB ERA26LA055Accident · No injuriesClass 3 · LimitedPreliminary reportPerry William Lancair IV P · Savannah, GAOn November 13, 2025, at 1949 eastern standard time, an experimental amateur-built Lancair IV-P, N163BR, was substantially damaged when it was involved in an accident near Savannah, Georgia. The pilot and passenger were uninjured. The airplane was operated as…NTSB ANC25LA091Accident · No injuriesClass 3 · LimitedPreliminary reportVu Holdings LLC/DBA Vanilla UN VA 001 · Ninilchik, AKOn August 20, 2025, at about 0632 Alaska daylight time, a Platform Aerospace VA 001 Unmanned Aerial System (UAS), N246VU, was substantially damaged when it was involved in an accident on a beachside cliff near Ninilchik, Alaska. The aircraft was unmanned. The…NTSB WPR25LA244Accident · Serious injuriesClass 3 · LimitedPreliminary reportNorth American T-28C · West Wendover, NVOn August 07, 2025, at 1532 Pacific daylight time, a North American T-28C, N9748Y, was substantially damaged when it was involved in an accident near West Wendover, Utah. The pilot and the passenger were seriously injured. The airplane was operated as a Title…