NTSB investigations: Amateur-built UNKNOWN ENG, KY
9 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
| 1978 | 1 |
|---|---|
| 1982 | 1 |
| 1987 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2022 | 1 |
Where
Open the mapLatest 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.\"eventStateOrRegion\" = 'KY' 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.
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."eventStateOrRegion" = 'KY' 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" 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 ERA22LA294Accident · Serious injuriesClass 3 · LimitedFinal reportBucker BU-133 · Hartford, KYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall during an attempted return to the runway.NTSB ERA15LA304Accident · No injuriesLimited investigationFinal reportBoard James A Zenith 601 HD · Danville, KYThe pilot's improper adjustment of the propeller blade angle, which resulted in inadequate engine thrust, and his decision to continue the takeoff despite the excessively long takeoff roll.NTSB ERA13CA107Accident · No injuriesData collectionFinal reportBrewer James M KR2 · Bear Branch, KYThe pilot’s improper preflight planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot’s lack of knowledge about the airplane’s total fuel capacity and fuel quantity instrumentation.NTSB ERA12CA547Accident · Minor injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Tail Dragger · Elizabethtown, KYThe pilot’s failure to maintain directional control of the tailwheel-equipped airplane during a takeoff in gusty crosswind conditions. Contributing to the accident was the pilot's decision to take off in gusty wind conditions associated with approaching…NTSB NYC06CA021Accident · Serious injuriesData collectionFinal reportCraig Sonerai II LT · Ashland, KYA loss of directional control during an emergency landing. A factor in the accident was an unlatched canopy requiring the pilot to hold it closed to maintain aircraft control.NTSB NYC01LA231Accident · No injuriesLimited investigationFinal reportLet 33 · Bardstown, KYThe pilot's improper flare, which resulted in a nose-first, hard touchdown.NTSB ATL87LA207Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Crestwood, KYThe balloon contacted power lines as it was beginning to climb after an aborted ldg attempt. Electrical arcing ignited the propane fuel supply on board. The sole-occupant student plt jumped from the burning balloon and fell approx 40 ft onto a fence. The…NTSB ATL82DA200Accident · No injuriesFinal reportErcoupe 415-C · Richmond, KYPilot hand propped aircraft which broke tail tie-down rope and taxiied unattended into a runway light and a ditch about 175 feet from starting point.NTSB IAD78FA064Accident · No injuriesClosedCessna 404 · Covington, KY