NTSB investigations: Amateur-built UNKNOWN ENG, 2008
63 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\") = 2008
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") = 2008
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 CEN09LA113Accident · No injuriesLimited investigationFinal reportCotton Galen M Helicycle · Houston, TXThe loss of engine power during a hover landing which resulted in a hard landing.NTSB WPR09IA070Incident · No injuriesIncident investigationFinal reportMD Helicopter MD 900 · Kamuela, HIThe separation of the endplate bolts for undetermined reasons, resulting in an in-flight separation of the right endplate. Contributing to the accident was the manufacturer's failure to provide sufficient guidance for endplate bolt installation.NTSB ERA09LA107Accident · Minor injuriesLimited investigationFinal reportMoore David DM-1 · Salters, SCA hard landing following an autorotation that resulted from the separation of the red main rotor blade cap that led to the uncontrolled movement of the cyclic, autorotation and a hard landing.NTSB ERA09LA106Accident · 1 fatalLimited investigationFinal reportReamer RV7A · Wadesboro, NCThe pilot's failure to maintain adequate airspeed while on approach for a precautionary landing, which resulted in an aerodynamic stall.NTSB ERA09CA121Accident · No injuriesData collectionFinal reportLake LA-4-200 · Apopka, FLThe pilot's improper flare.NTSB ERA09CA091Accident · No injuriesData collectionFinal reportKimball Enterprises Pitts Model-12 · Weirdales, FLThe pilot's inadequate compensation for the wind conditions. Contributing to the accident was the crosswind.NTSB ERA09FA080Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Ft. Lauderdale, FLThe failure of both pilots to see and avoid the other aircraft.NTSB WPR09LA050Accident · 1 fatalLimited investigationFinal reportBeech A36 · Coalinga, CAThe loss of engine power while in climb to cruise flight for undetermined reasons.NTSB CEN09LA075Accident · Minor injuriesLimited investigationFinal reportHauser U/Hauser J KIT FOX CL · Boulder, COA loss of engine thrust due to the pilot's inadvertent activation of the propeller controls. Contributing to the accident were the non-standard propeller controls and the pilot's lack of experience in the airplane.NTSB ERA09CA046Accident · No injuriesData collectionFinal reportHilderson Oswald Aventura HP · Weirwood, VAThe pilot's failure to maintain control of the airplane following an in-flight encounter with turbulence during approach, which led to a loss of engine power due to fuel starvation, and subsequent forced landing into trees.NTSB CEN09LA034Accident · Serious injuriesLimited investigationFinal reportRans S-12XL · Breckenridge, TXThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall.NTSB ERA09CA024Accident · Minor injuriesData collectionFinal reportLange Flugzeugbau E1 Antares · Winter Haven, FLThe failure of the pilot of the other airplane to announce his intentions prior to takeoff, resulting in a runway incursion. Contributing to the accident was the limited forward visibility due to the runway slope.NTSB CEN09CA026Accident · Minor injuriesData collectionFinal reportHolland Rotorway 162F · Rutland, SDThe loss of torque due to a failure of a transmission drivebelt and the pilot's delayed landing flare during the autorotation. Contributing to the accident was the dusk light condition and the corn crop.NTSB WPR09LA004Accident · 1 fatalLimited investigationFinal reportBonde TF-51D · Sandy Valley, NVThe pilot's failure to maintain adequate airspeed while maneuvering to land, resulting in an aerodynamic stall. Contributing to the accident was the pilot's diverted attention while attempting to extend the landing gear.NTSB ERA09LA001Accident · Serious injuriesLimited investigationFinal reportBezinque Alisport-Silent · Vero Beach, FLThe failure of the electric fuel boost pump which resulted in a loss of engine power due to fuel starvation.NTSB NYC08LA322Accident · 1 fatalLimited investigationFinal reportNagel SAL 2/3 P51 · Schenectady, NYThe pilot's failure to maintain adequate airspeed during the initial climb, which led to an aerodynamic stall.NTSB SEA08CA204Accident · No injuriesData collectionFinal reportGoetz RAF 2000 · Mulino, ORThe pilot's failure to maintain directional control during landing.NTSB DFW08CA229Accident · No injuriesData collectionFinal reportSukhoi SU-31M · Collinsville, OKThe pilot's failure to maintain clearance from marked transmission lines while on final approach.NTSB LAX08CA293Accident · No injuriesData collectionFinal reportBrubaker F1 · Truckee, CAThe failure of the bolts securing the tail wheel to its attach point that resulted in a loss of directional control.NTSB CHI08LA274Accident · Minor injuriesLimited investigationFinal reportSadler Vampire · Findlay, OHA total loss of engine power due to the failure of the reduction drive assembly as a result of excessive wear and high temperatures. Contributing to the accident were the pilot's lack of total experience in the airplane and the unsuitable terrain for a forced…NTSB SEA08LA195Accident · Minor injuriesLimited investigationFinal reportLancair Propjet · Camarillo, CAThe loss of engine power due to air within the fuel system.NTSB SEA08GA194Accident · 3 fatalFinal reportLockheed P2V-7 · Reno, NVThe failure of the flight crew to maintain airspeed above in-flight minimum control speed (Vmca) after losing power in the left jet engine during initial climb after takeoff. Contributing to the accident was the crew's inadequate cockpit resource management…NTSB DFW08CA222Accident · No injuriesData collectionFinal reportFairchild SW3 · Carlsbad, NMFailure of the door to remain secure for undetermined reasons.NTSB SEA08CA184Accident · No injuriesData collectionFinal reportWheat Excalibur EX · Moses Lake, WAThe right rudder pedal attach rivets sheared due to overload.NTSB SEA08CA177Accident · Minor injuriesData collectionFinal reportAnglin RV-6 · Puyallup, WAThe complete loss of engine power for undetermined reasons. Contributing to the accident were hidden obstructions (tree stumps) in the field of long grass within which the pilot executed his forced landing.NTSB LAX08LA263Accident · Serious injuriesLimited investigationFinal reportSmith Stewart S51D · Oxnard, CAThe loss of engine power for an undetermined reason.NTSB CHI08CA240Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164B · Salem, IAThe loss of engine power for an undetermined reason. Contributing to the accident was the high grass encountered during the landing roll.NTSB NYC08LA273Accident · No injuriesLimited investigationFinal reportOuzts Rodney Rutan-LongEZ · Winder, GAThe failure of the left brake due to contamination of the brake fluid.NTSB NYC08LA259Accident · Serious injuriesLimited investigationFinal reportSands Thomas E Rotorway 162 · Graysville, TNA loss of control for undetermined reasons.NTSB DFW08LA197Accident · 1 fatalLimited investigationFinal reportMarshall James J Cozy MK IV · Midlothian, TXThe pilot's failure to maintain clearance from the wall of the rock quarry.NTSB DFW08CA189Accident · No injuriesData collectionFinal reportStinson 108-1 · Alliance, NEThe pilot's failure to maintain directional control on takeoff. Contributing to the accident was a lack of total experience.NTSB DFW08CA184Accident · No injuriesData collectionFinal reportWright Avid Flyer MK IV · Lake Jackson, TXThe loss of engine power due to a connecting rod failure.NTSB MIA08LA134Accident · 1 fatalLimited investigationFinal reportDouglas A. Pohl Lancair IV-P · Hollywood, FLA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain aircraft control which resulted in an aerodynamic stall.NTSB CHI08LA189Accident · Serious injuriesLimited investigationFinal reportRoof Curtis Hawk P6E · Iowa City, IAThe loss of engine power for an undetermined reason and the pilot's subsequent failure to maintain airspeed, which resulted in an aerodynamic stall.NTSB ANC08LA083Accident · No injuriesLimited investigationFinal reportBell UH-1B · Iliamna, AKThe failure of company maintenance personnel to ensure the helicopter was properly maintained, resulting in a severe in-flight vibration due to collective bounce. Contributing to the accident was loose and worn bearings on the helicopter's stabilizer bar,…NTSB CHI08CA168Accident · No injuriesData collectionFinal reportWolseley Motors SE5-A · Seymour, INThe pilot/builder's failure to manufacture the airplane with an appropriate engine thrust angle. Contributing to the accident was the pilot/builder's adjustment of the horizontal stabilizer which rendered the airplane uncontrollable.NTSB CHI08LA169Accident · No injuriesLimited investigationFinal reportMorrison E-Racer · Aurora, ILAn undetermined failure in the high-pressure fuel system, and the subsequent loss of engine power and in-flight fire. Contributing to the accident were the pilot's restricted visibility due to the smoke in the cockpit, failure of the aileron control during…NTSB NYC08LA222Accident · 2 fatalLimited investigationFinal reportDennis P. McGurk F1 Rocket · Woodbine, NJA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the proper tank prior to performing aerobatics.NTSB SEA08CA153Accident · No injuriesData collectionFinal reportHammond MH1 · McCall, IDThe pilot's failure to maintain directional control during the landing roll, resulting in a inadvertent ground loop. Contributing to the accident were variable winds that resulted in a landing tailwind, and rough terrain.NTSB DFW08CA164Accident · No injuriesData collectionFinal reportBritish Jet Provost T Mk.5A · Bay City, TXThe pilot's failure to maintain aircraft control during final approach. Contributing to the accident was the downdraft.NTSB CHI08LA154Accident · No injuriesLimited investigationFinal reportBeech A36 · Grand Rapids, MNA loss of engine thrust due to the propeller separating from the aircraft as a result of fatigue failure of the propeller attachment bolts caused by the insufficient torque of the bolts during installation.NTSB NYC08LA207Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Pawtucket, RIBoth pilots' failure to see and avoid the other airplane. Contributing to the accident was the air traffic controllers failure to notify either pilot of the potential conflict.NTSB DEN08LA098Accident · 2 fatalLimited investigationFinal reportHarms Robert M KIT FOX SE · La Porte, TXThe pilot's failure to maintain adequate airspeed while maneuvering, resulting in an aerodynamic stall and uncontrolled descent.NTSB DFW08CA158Accident · No injuriesData collectionFinal reportAeros Venture · Baldwin City, KSthe pilot's failure to maintain proper runway alignment and the instructor's delayed remedial action to abort the landing, which resulted in a collision with a mailbox and hangar. A factor was the crosswind.NTSB SEA08LA138Accident · 1 fatalLimited investigationFinal reportKolb Kolbra · Jordan Valley, ORThe pilot's failure to maintain an adequate airspeed while maneuvering that led to a stall/mush.NTSB DFW08CA152Accident · Serious injuriesData collectionFinal reportRotorway 162F · Gonzales, TXfailure of the main rotor drive belt for undetermined reasons.NTSB CHI08FA132Accident · 1 fatalField investigationFinal reportFairchild Hiller FH-1100 · Comstock, MIA loss of engine power in flight due to fuel exhaustion resulting from the pilot's inadequate fuel management. Contributing to the accident was the unsuitable terrain for a forced landing.NTSB SEA08LA128Accident · Serious injuriesLimited investigationFinal reportMoravan Zlin 50LX · Modesto, CAThe pilot failed to maintain clearance from terrain during a low-altitude maneuver at an airshow. Contributing to the accident was the task overload in the increased frequency congestion.NTSB MIA08LA096Accident · 1 fatalLimited investigationFinal reportGarrett Gerald P Cozy Mark IV · Jekyll Island, GAControlled flight into water for undetermined reasons.NTSB SEA08CA123Accident · Minor injuriesData collectionFinal reportVans RV-7A · Hollister, CAThe in-flight collision with a bird.