NTSB investigations: Amateur-built UNKNOWN ENG, 2010
62 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
| 1964 | 11 |
|---|---|
| 1965 | 12 |
| 1966 | 20 |
| 1967 | 16 |
| 1968 | 7 |
| 1969 | 11 |
| 1970 | 14 |
| 1971 | 16 |
| 1972 | 10 |
| 1973 | 12 |
| 1974 | 17 |
| 1975 | 13 |
| 1976 | 20 |
| 1977 | 19 |
| 1978 | 25 |
| 1979 | 18 |
| 1980 | 20 |
| 1981 | 19 |
| 1982 | 29 |
| 1983 | 21 |
| 1984 | 26 |
| 1985 | 22 |
| 1986 | 27 |
| 1987 | 31 |
| 1988 | 29 |
| 1989 | 15 |
| 1990 | 28 |
| 1991 | 20 |
| 1992 | 22 |
| 1993 | 27 |
| 1994 | 26 |
| 1995 | 31 |
| 1996 | 30 |
| 1997 | 22 |
| 1998 | 30 |
| 1999 | 34 |
| 2000 | 49 |
| 2001 | 45 |
| 2002 | 64 |
| 2003 | 67 |
| 2004 | 58 |
| 2005 | 70 |
| 2006 | 59 |
| 2007 | 74 |
| 2008 | 63 |
| 2009 | 62 |
| 2010 | 62 |
| 2011 | 44 |
| 2012 | 58 |
| 2013 | 43 |
| 2014 | 46 |
| 2015 | 40 |
| 2016 | 39 |
| 2017 | 43 |
| 2018 | 34 |
| 2019 | 40 |
| 2020 | 28 |
| 2021 | 36 |
| 2022 | 41 |
| 2023 | 41 |
| 2024 | 34 |
| 2025 | 32 |
| 2026 | 25 |
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 year(c.\"eventDate\") = 2010
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 year(c."eventDate") = 2010
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 WPR11LA080Accident · Serious injuriesLimited investigationFinal reportSchaefer Kitfox 4 · Glendale, AZThe pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…NTSB CEN11LA090Accident · 1 fatalLimited investigationFinal reportSoutherland Freebird Litesport U · Decatur, ILThe pilot's reported inability to control his amateur-built airplane for undetermined reasons after the airplane inadvertently became airborne while conducting a high-speed taxi.NTSB ERA11CA092Accident · No injuriesData collectionFinal reportHaeussler Ray Sonex · Buffalo, NYThe pilot's failure to maintain directional control during takeoff due to his abrupt advancing of the throttle.NTSB CEN11CA065Accident · No injuriesData collectionFinal reportWelch Thomas RV9 · Sac City, IAThe pilot's loss of directional control while landing with a gusting wind.NTSB ERA11LA043Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hilton Head Island, SCThe Pitts pilot's inadequate visual lookout and failure to maintain clearance from the Cirrus airplane.NTSB CEN11LA045Accident · Serious injuriesLimited investigationFinal reportWalker Kenneth Sonex · San Angelo, TXThe pilot's loss of airplane control. Contributing to the accident was the pilot's impairment due to alcohol.NTSB CEN11CA047Accident · No injuriesData collectionFinal reportAardema Robert John 1 Aardema RAG WNG SP · Oshtemo, MIThe failure of the ignition system wiring, which resulted in a total loss of engine power.NTSB ERA11CA029Accident · No injuriesData collectionFinal reportSqueglia R/Wheeler W Hummel Bird · Hollywood, FLThe pilot's inadequate flare, which resulted in a hard landing.NTSB CEN11CA035Accident · Minor injuriesData collectionFinal reportBorne Charles A III RV-4 · Los Lunas, NMThe pilot's improper flare, which resulted in a hard landing and loss of directional control.NTSB WPR11CA018Accident · Minor injuriesData collectionFinal reportDeitz Avid Flyer MK4 · Colville, WAThe pilot's failure to compensate for a wind gust and maintain runway alignment during final approach to land, which resulted in an in-flight collision with a tree.NTSB CEN11CA028Accident · Minor injuriesData collectionFinal reportWeddington Double Eagle · Temple, TXThe loss of engine power for undetermined reasons.NTSB ERA11LA011Accident · No injuriesLimited investigationFinal reportGrumman G164 · Edison, GALeakage of hydraulic fluid from the internal fuselage line fitting, resulting in a subsequent loss of the right brake’s effectiveness.NTSB CEN11CA002Accident · No injuriesData collectionFinal reportGingerich Alton & Slagel Dean Christavia MK 1 · Nappanee, INThe total loss of engine power for undetermined reasons.NTSB WPR10CA466Accident · Minor injuriesData collectionFinal reportHiller UH-12E · Mecca, CAThe pilot's failure to maintain clearance from an obstacle while maneuvering.NTSB WPR10LA462Accident · 1 fatalLimited investigationFinal reportCosmos Phase II · El Mirage, CAThe pilot's improper preflight and starting procedures, which resulted in an inadvertent takeoff with the gust lock still installed.NTSB WPR10LA468Accident · Minor injuriesLimited investigationFinal reportGiboney Thunder Mustang · Reno, NVFailure of a connecting rod bearing and two connecting rods, which resulted in a loss of engine power while maneuvering at low altitude.NTSB ERA10CA476Accident · No injuriesData collectionFinal reportGoodman Robert Bruce RV-4 · Gainesville, GAThe pilot's failure to see and avoid marked power lines during low-level flight over a lake.NTSB CEN10CA537Accident · Minor injuriesData collectionFinal reportLewis Brandon Scott Exterminator · Rockford, ILThe pilot's failure to maintain control of the gyrocopter while practicing takeoffs and landings.NTSB CEN10CA530Accident · No injuriesData collectionFinal reportCullis Ultracruiser Sport · Defiance, OHThe pilot's failure to maintain aircraft control during the landing roll.NTSB ERA10LA504Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Mocksville, NCThe pilot’s failure to attain the proper touchdown point, following a loss of engine power due to carburetor icing.NTSB CEN10CA469Accident · Serious injuriesData collectionFinal reportHughes 269B · Lakeview, MIThe pilot's excessive descent angle during landing approach, which resulted in a settling with power condition.NTSB WPR10CA389Accident · No injuriesData collectionFinal reportLet L 33 Solo · Adelanto, CAThe pilot’s inability to make it to the airport as a result of his inadequate planning for the gusting headwinds.NTSB WPR10CA428Accident · No injuriesData collectionFinal reportHolmgreen John B RV8A · Carlsbad, CAThe pilot’s inadequate pretakeoff checks and failure to maintain control during the takeoff roll. Contributing to the accident was the pilot’s diverted attention due to the open canopy.NTSB CEN10CA454Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Petersburg, TXThe pilot's failure to maintain clearance from a signpost during an aerial application flight.NTSB ERA10LA379Accident · Minor injuriesLimited investigationFinal reportGarlick Helicopters OH-58A+ · Newport, TNInadequate maintenance inspections of the main rotor blade inertia screw holes, which resulted in a main rotor blade failure due to fatigue. Contributing to the accident was the pilot's inadequate preflight inspection of the main rotor blades.NTSB CEN10LA442Accident · 1 fatalLimited investigationFinal reportLunceford Sparrowhawk II · Tell City, INThe pilot's loss of control of the gyroplane for undetermined reasons.NTSB CEN10CA441Accident · Minor injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INA loss of engine power during initial climb due to fuel exhaustion. Contributing to the accident was the pilot's diverted attention while attempting to restart the engine.NTSB WPR10LA366Accident · 1 fatalLimited investigationFinal reportClark RV-9A · Oregon City, ORThe pilot's decision to depart with known mechanical anomalies and the loss of engine power for undetermined reasons.NTSB ERA10LA365Accident · 1 fatalLimited investigationFinal reportTexas Air Ventures Comp AIR 8 · Mount Pleasant, SCThe pilot's failure to retrim the airplane and maintain aircraft control during an aborted landing, which resulted in an inadvertent stall. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB CEN10LA409Accident · 1 fatalLimited investigationFinal reportDavis John TR-4 · Denton, TXA loss of engine power and the pilot’s subsequent loss of control for undetermined reasons.NTSB CEN10CA421Accident · No injuriesData collectionFinal reportNord 3202 · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll.NTSB ERA10LA362Accident · No injuriesLimited investigationFinal reportGarlick Helicopters OH-58A+ · Rowley, MAThe failure of the power turbine governor internal driveshaft bearings, resulting in the failure of the governor.NTSB ERA10CA352Accident · No injuriesData collectionFinal reportVans RV8 · Port Orange, FLThe pilot's failure to maintain directional control during the landing rollout.NTSB CEN10CA395Accident · No injuriesData collectionFinal reportBell OH-58A · Roswell, NMThe pilot's failure to maintain clearance from transmission wires.NTSB CEN10CA376Accident · No injuriesData collectionFinal reportWells Terry Hula Girl · Wellington, COA partial loss of engine power due to the inadequate design of the engine cowling.NTSB WPR10LA317Accident · Serious injuriesLimited investigationFinal reportWorgull Hornet · Camp Verde, AZThe in-flight separation of the exhaust clamps for an undetermined reason, which resulted in the exhaust system striking the wooden propeller.NTSB ERA10CA332Accident · No injuriesData collectionFinal reportCrabtree RV6 · Sewanne, TNThe pilot's improper recovery from a bounced landing.NTSB WPR10LA310Accident · Serious injuriesLimited investigationFinal reportRice KR-2 · Richfield, UTA loss of engine power during initial climb due to a carburetor malfunction.NTSB ERA10LA328Accident · No injuriesLimited investigationFinal reportParks J L/Dreffin D Seawind 3000 · Sanibel Island, FLAn overstress failure of the elevator. Contributing to the accident was the owner/builder's modification of the experimental airplane beyond the recommendations of the kit manufacturer.NTSB WPR10LA294Accident · No injuriesLimited investigationFinal reportSchleicher Alexander ASH 26 E · Parowan, UTThe pilot's failure to see and avoid the other glider climbing in the same thermal.NTSB WPR10CA288Accident · No injuriesData collectionFinal reportBurkhart Grob G103C Twin III Acro · Minden, NVThe pilot's encounter with an area of degraded lift during cruise flight, resulting in a forced off-airport landing.NTSB CEN10CA304Accident · No injuriesData collectionFinal reportBordelon Kitfox IV · Stanton, MNThe pilot’s inadvertent propeller blade pitch change and subsequent loss of forward thrust.NTSB ANC10CA050Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, resulting in the airplane nosing over during taxi.NTSB CEN10CA301Accident · No injuriesData collectionFinal reportCessna 421B · Anderson, INThe pilot’s failure to establish proper rotation and liftoff speed during the takeoff roll.NTSB ERA10LA294Accident · Minor injuriesLimited investigationFinal reportSwanson RV-9A · Ashland, VAThe pilot's failure to obtain the proper touchdown point during a forced landing in gusting wind. Contributing to the accident was a total loss of engine power, likely due to carburetor ice.NTSB CEN10LA274Accident · 1 fatalLimited investigationFinal reportHenney Michael A Vans RV-6A · Granbury, TXThe loss of control for undetermined reasons.NTSB WPR10LA250Accident · Serious injuriesLimited investigationFinal reportWildman RV6-A · Columbia, CAThe pilot’s inadequate compensation for the gusting crosswind and improper landing flare.NTSB ERA10LA266Accident · 2 fatalLimited investigationFinal reportAerostar S A YAK-52 · Jensen Beach, FLThe pilot's decision to perform an aerobatic maneuver at a low altitude, which resulted in insufficient clearance from the water to conduct a recovery. Contributing to the accident was the airplane’s extended landing gear, which resulted in a degradation of…NTSB ERA10TA261Accident · No injuriesFinal reportBell 407 · Abingdon, VAThe improper repair of an engine component by a repair facility, which resulted in a complete loss of engine power. Contributing to the accident was the failure of the repair facility to recognize that an improper repair had been accomplished, which allowed…NTSB CEN10LA242Accident · No injuriesLimited investigationFinal reportJorritsma Jerrold S Berkut · Loveland, COA loss of engine power due to a malfunction of the fuel controller resulting in a compressor stall.