NTSB investigations: Amateur-built UNKNOWN ENG, 2004
4 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 4 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 7 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 3 |
| 2001 | 4 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 2 |
| 2006 | 2 |
| 2007 | 1 |
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 year(c.\"eventDate\") = 2004
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\" = 260))
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 year(c."eventDate") = 2004
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" = 260))
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 DEN05CA040Accident · No injuriesData collectionFinal reportDaniels Vans RV-8 · Albuquerque, NMthe pilot's failure to maintain directional control resulting in a ground loop.NTSB MIA05CA038Accident · No injuriesData collectionFinal reportSteven W. Jones KR2 · Zellwood, FLThe failure of the pilot to maintain directional control during landing resulting in the on-ground collision with a drainage ditch.NTSB IAD04LA019Accident · Minor injuriesLimited investigationFinal reportKrotje VM-1 Esqual · Cambridge, OHThe pilot's failure to maintain directional control. A factor was the inadequate brake system installed on the airplane.NTSB LAX04LA195Accident · No injuriesLimited investigationFinal reportSpirangam Velocity · Boulder City, NVthe pilot's failure to maintain directional control of the airplane during the landing rollout.