NTSB investigations: Amateur-built UNKNOWN ENG
73 cases on aircraft whose registry engine model is Amateur-built UNKNOWN ENG, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 5 |
|---|---|
| 1983 | 2 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 4 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 3 |
| 1995 | 3 |
| 1997 | 3 |
| 1998 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 8 |
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.\"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\" = 353))
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."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" = 353))
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 NYC08FA023Accident · 1 fatalField investigationFinal reportDaniel R. Lloyd Trish's Ride Home · Greenville, PAThe pilot/builder's improper installation of the electrical system.NTSB CHI08CA008Accident · Serious injuriesData collectionFinal reportVeltman, Robert CH701 · Owosso, MIThe pilot inadvertantly turned the fuel selector to the off position and failed to maintain aircraft control during the subsequent loss of engine power. A factor associated with the accident was the pilot's change in his normal habit pattern.NTSB SEA08CA010Accident · No injuriesData collectionFinal reportWelch RV-9 · Bigfork, MTFuel starvation while on downwind for landing. The pilot's inadequate in-flight fuel management planning was a factor.NTSB SEA08LA007Accident · Minor injuriesLimited investigationFinal reportHaring Clay RV8A · Brigham City, UTFuel exhaustion due to the pilot's inaccurate fuel consumption calculations. Factors include an inaccurate fuel quantity measuring system, and soft terrain encountered during the landing roll.NTSB LAX07LA220Accident · Serious injuriesLimited investigationFinal reportMurrin Frederick L Sopwith F1 · Greenville, PAa fuel starvation induced loss of engine power due to inadequate fuel system pressure. A factor in the accident was the pilot/builder's failure to adequately adjust the fuel system pressure.NTSB LAX07CA205Accident · Minor injuriesData collectionFinal reportSaunders Stiletto · Quartzsite, AZFuel exhaustion due to the pilot's inadequate preflight inspection during which he failed to insure security of the fuel tank's cap.NTSB SEA07CA167Accident · No injuriesData collectionFinal reportRallison Rotorway 162F · Logan, UTThe total loss of engine power due to the pilot inadvertently deactivating the rotor drive clutch assembly. A contributing factor was the downhill terrain condition where he landed, which exceeded the slope limitations of the helicopter.NTSB SEA07CA083Accident · No injuriesData collectionFinal reportDuffy/Wagner Vans RV-4 · Ogden, UTThe pilot's inadequate fuel management resulting in a loss of engine power due to fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX06LA153Accident · 1 fatalLimited investigationFinal reportRonald R Russell RV-6 · Death Valley, CAa fuel starvation induced loss of engine power due to a likely vapor lock condition in the fuel lines.NTSB LAX05LA248Accident · Minor injuriesLimited investigationFinal reportScandinavian Aero Industry KZ VII · Elko, NVThe pilot's failure to use carburetor heat, which resulted in the formation of carburetor ice and the total loss of engine power.NTSB ATL05CA130Accident · Minor injuriesData collectionFinal reportJabiru SK0007 · Aiken, SCThe loss of engine power for undetermined reasons.NTSB CHI05CA153Accident · Minor injuriesData collectionFinal reportS C Aerostar S A YAK-52 · Columbus, NEThe mechanic's inadequate installation of fuel lines, the obstruction of fuel lines, and the fuel starvation leading to the non-mechanical loss of engine power during approach and the unsuitable terrain the pilot encountered during the forced landing.NTSB LAX05LA115Accident · No injuriesLimited investigationFinal reportSukhoi SU-26 · Tucson, AZthe pilot's inadequate in-flight planning and fuel consumption calculations, which resulted in fuel exhaustion.NTSB CHI05CA005Accident · No injuriesData collectionFinal reportBuss Rotorway Exec · Eden Prairie, MNThe pilot's inadvertent deactivation of the battery switch leading to the helicopter's loss of engine power on base leg. A factor was the crops he encountered during the emergency landing.NTSB FTW04CA242Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Haskell, TXThe pilot's improper inflight planning which resulted in a loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.NTSB SEA04LA121Accident · No injuriesLimited investigationFinal reportExp Acft Assn Wi Chapter 60 Moni · Rochester, WAThe pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power during descent. Factors contributing to the accident included the pilot's lack of experience in the aircraft and the tree.NTSB MIA03LA180Accident · No injuriesLimited investigationFinal reportPiper J5A · Winter Haven, FLThe inadequate preflight of the airplane by the pilot-in-command, which failed to detect water-contaminated fuel, and his failure to maintain airspeed resulting in an inadvertent stall.NTSB DEN03FA125Accident · 2 fatalField investigationFinal reportCASA 2.111 · Cheyenne, WYA loss of engine power for reasons undetermined, and the pilot's failure to maintain aircraft control. Contributing factors were the unsuitable terrain on which to make a forced landing, low airspeed, the fence, automobile, and the school bus wash barn.NTSB SEA03FA110Accident · 1 fatalField investigationFinal reportHarshbarger W/Reed RV-8 · Grants Pass, ORCorrosion and contamination within the fuel servo unit and the pilot's delayed turn back to the runway. Contributing factors were trees and the pilot's impairment due to prescription medication.NTSB ATL03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Mill, SCThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power.NTSB CHI03FA099Accident · Serious injuriesField investigationFinal reportDassault DA-20C · St Louis, MOThe pilot in command's improper in-flight decision not to divert to an alternate destination resulting in the exhaustion of the airplane's fuel supply, and his failure to relay his low fuel state to air traffic control in a timely manner.NTSB MIA03LA047Accident · Minor injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Fort Myers, FLThe pilot's inadequate preflight/preparation and his in-flight planning/decision which resulted in fuel exhaustion and the loss of engine power.NTSB ATL03LA026Accident · No injuriesLimited investigationFinal reportPreceptor Ultra pup · Smithville, TNThe pilot's inadequate preflight fuel planning of fuel resulted in fuel starvation, the total loss of engine power and the subsequent forced landing.NTSB SEA02LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kittitas, WAThe pilot's failure to conduct an adequate preflight inspection of the fuel resulting in fuel exhaustion and a subsequent forced landing. A contributing factor was the rocky terrain encountered during the forced landing.NTSB ATL02LA134Accident · Serious injuriesLimited investigationFinal reportFay Velocity Elite · Theodore, ALThe pilot's inadequate inflight planning for required fuel resulted in fuel exhaustion and the subsequent loss of engine power. A factor was unsuitable terrain.NTSB NYC02LA074Accident · No injuriesLimited investigationFinal reportCessna 182C · Moneta, VAThe pilot's inadequate preflight planning, which resulted in fuel exhaustion.NTSB IAD01LA091Accident · Serious injuriesLimited investigationFinal reportDelbridge Rotorway Exec 162F · Carrollton, VApilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion.NTSB SEA01LA053Accident · No injuriesLimited investigationFinal reportGibbs V-6 Stol · Newberg, ORthe pilot's mismanagement of his available fuel, the fuel starvation of the engine, and the pilot's excessive rate of descent during the touchdown portion of a power-off forced landing.NTSB LAX00LA308Accident · Minor injuriesLimited investigationFinal reportPulsar 100 · Victorville, CAthe pilot's failure to provide enough fuel for the intended flight. Contributing to the accident was an improper fuel vapor return system.NTSB LAX00LA257Accident · Minor injuriesLimited investigationFinal reportInteravia E-3 · Watsonville, CAthe total loss of engine power due to the pilot's inaccurate fuel consumption calculations, which resulted in fuel exhaustion.NTSB DEN00LA105Accident · Minor injuriesLimited investigationFinal reportFroelich Lancair IV · Bountiful, UTThe loss of power for undetermined reasons and the pilot's unsuccessful remedial action (dive to avoid the power line). Contributing factors were the power line, the tires and the fence.NTSB NYC98FA129Accident · 1 fatalField investigationFinal reportHawker Hunter T MK 8 · Manchester, NHFuel exhaustion, resulting from the pilot's reliance on an inaccurate fuel quantity indicating system. A factor in the pilot's death was his intentional delay of the ejection sequence in order to avoid people and property on the ground.NTSB FTW98LA179Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Carlisle, ARThe pilot's inadequate preflight and inflight planning/decision, which resulted in fuel exhaustion and the lost of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB IAD97LA121Accident · Minor injuriesLimited investigationFinal reportPohlman/Pohlman Rotorway Exec 90 · Westminster, MDThe loss of power due to carburetor icing. A factor to this accident was the carburetor heat was not accessible from within the cockpit.NTSB LAX97LA183Accident · No injuriesLimited investigationFinal reportNorth American Navion NA-1 · Morristown, AZfailure to replace an old and abraded oil feedline hose which led to its rupture and the in-flight loss of engine oil pressure. A related factor was the pilot's misjudgment of distance-to-go versus altitude remaining during the subsequent forced landing.NTSB FTW97IA362Incident · No injuriesIncident investigationFinal reportAyres S2R-G10 · Munday, TXblockage of both fuel lines from the left wing tank to the header tank by silicone rubber contaminants (foreign material), which resulted in fuel starvation. A related factor was the lack of suitable terrain for the forced landing.NTSB NYC96LA021Accident · Minor injuriesLimited investigationFinal reportBischoff VAN RV-6 · Monticello, NYthe pilot's improper inflight decision to continue flight without sufficient fuel, which resulted in a loss of power due to fuel exhaustion.NTSB CHI95LA202Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Blue Rapids, KSthe leaking drain in the main fuel sump. Factors to the accident were the incorrect fuel indication, the ravine, fuel exhaustion, and the low rotor RPM.NTSB FTW95FA101Accident · 1 fatalField investigationFinal reportBeech A36 · Wallisville, TXFuel starvation due to improper positioning of the fuel tank selector, which resulted in loss of engine power. Factors related to the accident were: darkness and a lack of suitable terrain for the forced landing.NTSB LAX95FA029Accident · Serious injuriesField investigationFinal reportCessna 421A · Sparks, NVThe pilot's improper use of the fuel selector and subsequent fuel starvation.NTSB SEA94LA119Accident · 1 fatalLimited investigationFinal reportHallstrom BD-5B · St. George, UTCarburetor contamination and low output, and the pilot's improper decision to attempt to continue the approach. A factor was the pilot's lack of recent flight experience.NTSB CHI94LA145Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Rochelle, ILthe pilot's inadequate use of carburetor heat. Factors associated with the accident were carburetor icing conditions and rough terrain.NTSB MIA93LA196Accident · Minor injuriesLimited investigationFinal reportSukhoi SU-26M · Natchez, MSThe pilot-in-command's failure to accurately calculate fuel consumption resulting in total loss of engine power due to fuel exhaustion while approaching the destination airport.NTSB SEA93LA174Accident · 2 fatalLimited investigationFinal reportBrauch Glasair · Blanding, UTThe loss of engine power resulting from inadequate maintenance inspection by the pilot, a leak from loose fuel system line fittings, and fuel exhaustion. A factor relating to the accident was the rough/uneven terrain.NTSB MIA93LA142Accident · No injuriesLimited investigationFinal reportSayer, Trevor A. Rans S-12 · New Smyrna Bch, FLFailure of the pilot to maintain adequate airspeed and inadvertent stall/spin. Contributing to the accident was total loss of engine power due to fuel starvation. This was due to improper placement of a component of the fuel system by the builder/pilot.NTSB MIA92FA142Accident · 1 fatalField investigationFinal reportHughes 369HS · Labelle, FLThe pilot-in-command's improper application of collective pitch during an autorotative landing resulting in insufficient rotor RPM and in-flight collision with trees and the terrain. Contributing to the accident was the total loss of engine power due to fuel…NTSB CHI91LA214Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Sparta, MIInadequate preflight by the pilot and the pilot's failure to reach a proper touchdown point.NTSB NYC91LA143Accident · No injuriesLimited investigationFinal reportCessna 120 · Wellsville, PAA power loss due to a fuel system blockage which resulted in a forced landing.NTSB LAX91LA175Accident · Serious injuriesLimited investigationFinal reportSnider RV6 · Paulden, AZThe pilot's poor preflight preparation and his failure to ensure that the fuel selector was properly positioned for flight.NTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.