Final NTSB investigations: Amateur-built UNKNOWN ENG
2,010 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 | 21 |
| 1993 | 27 |
| 1994 | 26 |
| 1995 | 31 |
| 1996 | 30 |
| 1997 | 22 |
| 1998 | 29 |
| 1999 | 33 |
| 2000 | 49 |
| 2001 | 45 |
| 2002 | 64 |
| 2003 | 67 |
| 2004 | 58 |
| 2005 | 69 |
| 2006 | 58 |
| 2007 | 73 |
| 2008 | 63 |
| 2009 | 62 |
| 2010 | 62 |
| 2011 | 44 |
| 2012 | 58 |
| 2013 | 43 |
| 2014 | 44 |
| 2015 | 40 |
| 2016 | 39 |
| 2017 | 43 |
| 2018 | 34 |
| 2019 | 39 |
| 2020 | 28 |
| 2021 | 36 |
| 2022 | 39 |
| 2023 | 41 |
| 2024 | 33 |
| 2025 | 23 |
| 2026 | 9 |
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.\"completionStatus\" = 'Completed'
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."completionStatus" = 'Completed'
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 ERA26LA311Accident · No injuriesClass 4 · LimitedFinal reportHPH Glasflugel 304CZ · Xenia, OHThe glider’s encounter with atmospheric conditions where lift was not sufficient to maintain flight.NTSB CEN26LA294Accident · Minor injuriesClass 4 · LimitedFinal reportPipistrel Taurus Electro G2.5 · Hempstead, TXThe pilot’s failure to properly stow the motor in preparation for approach and landing that resulted in a loss of airspeed and an inadvertent aerodynamic stall and spin.NTSB WPR26LA265Accident · No injuriesClass 4 · LimitedFinal reportVans RV-7A · Covington, WAThe pilot’s improper pitch control during landing, which resulted in a bounced landing, nose landing gear collapse, and nose over.NTSB WPR26LA213Accident · Serious injuriesClass 4 · LimitedFinal reportMoose SR 2500 · Sonoma, CAThe pilot's failure to maintain airspeed during a go-around in shifting wind conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.NTSB WPR26LA134Accident · No injuriesClass 4 · LimitedFinal reportZlin Aviation Sro Savage CUB-S · Young, AZThe pilot’s failure to maintain adequate clearance from trees during landing.NTSB DCA26LA159Accident · No injuriesClass 4 · LimitedFinal reportPyka Pelican Cargo · Summit Point, WVThe inaccurate obstacle height entered into mission planning that resulted in the aircraft wing’s impact with a tree during descent, resulting resulted in a loss of control.NTSB WPR26LA115Accident · No injuriesClass 4 · LimitedFinal reportMightyfly MF-100 · Atwater, CAA control system anomaly, which resulted in the overload and failure of one of the propulsion motor systems during the transition from hover to forward flight.NTSB ERA26LA133Accident · Minor injuriesClass 4 · LimitedFinal reportMorris Bradley D Zenith Stol CH-701 · Hendersonville, NCThe pilot’s failure to maintain directional control during takeoff, which resulted in a runway excursion and impact with trees.NTSB ERA26LA094Accident · Minor injuriesClass 4 · LimitedFinal reportSled Thomas Helicycle · Mobile, ALThe pilot’s failure to maintain yaw control during a crosswind approach, which resulted in a loss of tail rotor effectiveness, an uncommanded spin, hard landing, and subsequent rollover.NTSB WPR26LA072Accident · No injuriesClass 4 · LimitedFinal reportZenith 750 · Yacolt, WAA loss of engine power for undetermined reasons.NTSB ERA26LA058Accident · No injuriesClass 4 · LimitedFinal reportHuebbe Tom MAX TH · Inverness Highlands South, FLThe pilot’s failure to maintain directional control on takeoff. Contributing to the accident was the aircraft design that did not incorporate differential braking.NTSB CEN26LA054Accident · Minor injuriesClass 4 · LimitedFinal reportLou Malinchak Titan T-51D · Bristow, OKThe collision with two deer during takeoff which resulted in a loss of control and impact with terrain.NTSB WPR26LA015Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Lathrop, CAAn inflight collision with a bird.NTSB CEN25LA405Accident · Minor injuriesClass 4 · LimitedFinal reportSukhoi SU-26MX · Longmont, COThe pilot's failure to maintain directional control during takeoff.NTSB WPR25LA280Accident · No injuriesClass 4 · LimitedFinal reportWeaver Harmon Rocket · Hayden, IDThe pilot’s loss of directional control during landing, which resulted in a runway excursion and collision with terrain.NTSB WPR25LA308Accident · Serious injuriesClass 4 · LimitedFinal reportThomas Graham Teenie Two · Chehalis, WAThe pilot's improper decision to take off with the airplane over its maximum allowable gross weight, which degraded its climb performance and led to a subsequent off airport landing.NTSB CEN25LA390Accident · Serious injuriesClass 4 · LimitedFinal reportCameron Balloons US Z-90 · Cedar Springs, MIThe passenger’s loss of balance during landing that resulted in a serious injury.NTSB WPR25LA271Accident · Minor injuriesClass 4 · LimitedFinal reportNaval Aircraft Factory N3N-3 · Red Lodge, MTThe pilot’s failure to maintain clearance from obstacles during an aborted landing. Contributing to the accident was the high density altitude weather condition.NTSB CEN25LA258Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH701 · Blaine, MNThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR25LA201Accident · Minor injuriesClass 4 · LimitedFinal reportLancair IV · Alpine, WYThe pilot’s loss of visual reference during the landing approach which resulted in a collision with water.NTSB CEN25LA209Accident · No injuriesClass 4 · LimitedFinal reportVans RV-14 · Sealy, TXThe pilot’s improper use of airplane’s wheel brakes during the landing roll-out.NTSB ERA25LA196Accident · Serious injuriesClass 4 · LimitedFinal reportChris Wallen/Michael Pliske Just Acft Highlander · Brasstown, NCThe pilot’s inadvertent application of brake pressure during landing, which resulted in a nose over.NTSB ERA25LA182Accident · Minor injuriesClass 4 · LimitedFinal reportRobb Aventura II · Elmore, ALThe pilot’s failure to configure the airplane for a water landing.NTSB ERA25LA181Accident · Serious injuriesClass 4 · LimitedFinal reportSchleicher ASW-19 · Zephyrhills, FLThe pilot’s inadequate inflight planning and an encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing and collision with a fence.NTSB DCA25LA174Accident · No injuriesClass 4 · LimitedFinal reportPyka Pelican · Dixon, CAThe flight control system’s unanticipated transition to takeoff abort mode due to a software error in the autonomous flight control system, which resulted in a premature throttle reduction and hard landing.NTSB WPR25LA112Accident · Serious injuriesClass 4 · LimitedFinal reportEnstrom 280FX · Waterford, CAThe pilot’s failure to maintain clearance from water while operating at a low altitude.NTSB CEN25LA123Accident · Minor injuriesClass 4 · LimitedFinal reportCaldwell C W 162F · Mounds, OKThe student pilot’s failure to maintain control of the helicopter during a precautionary landing, which resulted in a dynamic roll over and postimpact fire.NTSB ERA25LA131Accident · No injuriesClass 4 · LimitedFinal reportMallory Horton AQUA-BEE · Miami, FLThe pilot’s failure to lower the landing gear before touchdown.NTSB WPR25LA101Accident · No injuriesClass 3 · LimitedFinal reportHughes OH-6A · Santa Teresa, NMThe flight instructor's failure to maintain helicopter control during a practice autorotation, which resulted in a hard landing and structural damage to the tail boom and subsequent failure of the tail rotor drive system.NTSB WPR25LA103Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe unmanned aircraft system’s failure to maintain clearance from an obstacle, which resulted in a loss of control and impact with terrain.NTSB WPR25LA083Accident · No injuriesClass 4 · LimitedFinal reportCharles E Spencer CCK-1865 · Vacaville, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN25LA078Accident · No injuriesClass 4 · LimitedFinal reportZenith Stol CH750 · Byron, ILThe pilot inadvertently moved the ignition key to the off position and broke the key, which resulted in a loss of engine power and subsequent forced landing.NTSB WPR25LA064Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe incorrect altitude indication by test software during landing.NTSB WPR25LA063Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORAn improper altitude indication from a recent software update, which resulted in a loss of engine power in flight.NTSB ERA25LA064Accident · Serious injuriesClass 3 · LimitedFinal reportAMS Flight D O O Carat A · Centralhatchee, GAMaintenance personnel’s failure to comply with the engine manufacturer’s guidance, which resulted in improper valvetrain clearances, unseating of the intake valve keepers, and a total loss of engine power.NTSB WPR25FA020Accident · 1 fatalClass 3 · FieldFinal reportExtra Flugzeugbau EA 300/L · Las Cruces, NMThe pilot’s entry into an aerobatic maneuver at an altitude that was insufficient to complete a successful recovery, which resulted in an accelerated stall and impact with terrain.NTSB CEN25LA013Accident · Minor injuriesClass 3 · LimitedFinal reportRotorway Exec · Plymouth, INA loss of control due to the failed forward tail rotor belt as a result of the owner’s failure to follow the helicopter manufacturer’s tail rotor belt replacement recommendations.NTSB CEN25LA010Accident · No injuriesClass 4 · LimitedFinal reportZodiac 601 · Augusta, KSThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR24FA309Accident · 1 fatalClass 3 · FieldFinal reportNanchang China CJ-6A · Lancaster, CAThe CJ-6A pilot’s failure to maintain separation and the Yak pilot’s failure to monitor the other airplane during a detachment, which resulted in a midair collision.NTSB WPR24LA317Accident · No injuriesClass 4 · LimitedFinal reportYakovlev YAK-50 · Watsonville, CAThe Yak-50 pilot’s failure to maintain clearance from another airplane while taxiing and maneuvering. Contributing to the accident was the pilot’s inattention due to a distraction inside the cockpit.NTSB CEN24LA348Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Amarillo, TXThe pilot’s failure to extend the airplane’s landing gear before landing.NTSB WPR24LA302Accident · No injuriesClass 4 · LimitedFinal reportAmazon.Com Services MK30 · Pendleton, ORThe operator’s failure to maintain separation between two drones during dual simulated engine out recoveries, which resulted in a midair collision.NTSB ERA24FA362Accident · 1 fatalClass 3 · FieldFinal reportSchleicher Alexander ASH 26 E · Waynesville, OHA loss of control on takeoff for undetermined reasons.NTSB CEN24LA330Accident · No injuriesClass 4 · LimitedFinal reportEsqual VM1 · Oshkosh, WIThe pilot’s premature rotation during takeoff which resulted in the airplane settling back to the runway and the subsequent separation of the left wheel.NTSB ERA24LA284Accident · Serious injuriesClass 4 · LimitedFinal reportCorella Neil RV9A · Saluda, SCThe pilot’s failure to maintain an appropriate glide path during the landing approach in variable wind conditions, which resulted in collision with trees.NTSB ERA24LA298Accident · No injuriesClass 4 · LimitedFinal reportGlobe GC1B · Peachtree City, GAA right main landing gear collapse during landing.NTSB ERA24LA258Accident · Serious injuriesClass 3 · LimitedFinal reportClapp Saberwing · Valdosta, GAThe total loss of engine power due to the shearing of the woodruff key that indexed the crankshaft gear and hub assembly to the crankshaft, which resulted in the gear and hub rotating from their indexed position and caused the crankshaft-to-camshaft timing to…NTSB CEN24LA214Accident · Minor injuriesClass 4 · LimitedFinal reportStinson Vultee V-77 · Slaton, TXThe pilot’s failure to maintain directional control after landing in gusting wind conditions which resulted in a runway excursion and the airplane nosing over. Contributing was the pilot’s decision to conduct the flight in very strong, gusting wind conditions.NTSB WPR24LA188Accident · Serious injuriesClass 3 · LimitedFinal reportDavid Fisher Murphy Moose · Ocean Shores, WAThe pilot’s hard, bounced landing, subsequent failure to maintain adequate airspeed, and his exceedance of the airplane’s critical angle of attack during a go-around, which resulted in an aerodynamic stall and impact with terrain.NTSB WPR24FA185Accident · 1 fatalClass 3 · FieldFinal reportRans S-12XL Airaile · Picacho Peak, AZThe pilot’s decision to conduct a low-altitude flight in mountainous terrain and his subsequent loss of airplane control after encountering mechanical turbulence, which resulted in an impact with the terrain.