NTSB investigations: Amateur-built UNKNOWN ENG, 2001
6 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Loss of engine power”. 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 | 3 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1986 | 3 |
| 1987 | 6 |
| 1988 | 5 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 3 |
| 1994 | 4 |
| 1995 | 4 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 4 |
| 1999 | 3 |
| 2000 | 8 |
| 2001 | 6 |
| 2002 | 15 |
| 2003 | 8 |
| 2004 | 4 |
| 2005 | 12 |
| 2006 | 7 |
| 2007 | 10 |
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\") = 2001
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\" = 350))
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") = 2001
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" = 350))
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 ATL02LA016Accident · Minor injuriesLimited investigationFinal reportWhitty, Philip J. Mustang II · Hampstead, NCA loss of engine power for undetermined reasons, which resulted in a forced landing and subsequent nose over during landing roll. A factor was the soft, unsuitable terrain.NTSB FTW01LA212Accident · No injuriesLimited investigationFinal reportBeech 70 · College Station, TXthe loss of right engine power during takeoff initial climb for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA196Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Dumas, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB CHI01LA152Accident · No injuriesLimited investigationFinal reportAllen Rotorway 162F · Jerseyville, ILthe improper autorotation by the pilot. Contributing factors were the engine failure for undetermined reason(s) and the muddy terrain.NTSB FTW01LA120Accident · No injuriesLimited investigationFinal reportKirchner Pietenpol Aircamper · Tulsa, OKthe pilot's inadequate flare during the forced landing, which resulted in a hard landing. A contributing factor was the engine overheating due a stuck oil cooler thermostat valve, which resulted in a loss of power.NTSB LAX01LA165Accident · Serious injuriesLimited investigationFinal reportDe Havilland Tiger Moth DH 82A · Sonoma, CAFailure of the pilot to properly flush out the fuel system after the header tank became submerged in water, which precipitated a loss of engine power and forced landing in a soft open dirt area.