NTSB investigations: Amateur-built UNKNOWN ENG, 2020
28 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\") = 2020
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") = 2020
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 CEN21LA092Accident · 1 fatalClass 3 · LimitedFinal reportSonex Tailwheel · Burleson, TXA total loss of engine power due to engine seizure. Contributing to the accident was the pilot decision not to orbit the airport, as originally planned.NTSB WPR21LA155Accident · Serious injuriesClass 4 · LimitedFinal reportAerostar International RX 8 · St. George, UTThe pilot’s failure to maintain control of the balloon and a member of the ground crews entanglement with a tether rope, which resulted in a serious injury when they fell to the ground after the balloon unexpectedly ascended.NTSB WPR21LA071Accident · Minor injuriesClass 3 · LimitedFinal reportCo Z Cozy · Compton, CAThe partial loss of engine power due to an improperly installed sparkplug.NTSB CEN21LA074Accident · No injuriesClass 4 · LimitedFinal reportZlin Savage Cub-S · Francis, OKThe pilot’s selection of unsuitable terrain for the landing, which resulted in a nose over when the airplane encountered soft sand during the landing roll.NTSB ERA21LA048Accident · No injuriesClass 4 · LimitedFinal reportVans RV4 · Milton, FLThe pilot's failure to maintain directional control during a crosswind landing.NTSB CEN21LA053Accident · 1 fatalClass 3 · LimitedFinal reportTrick Trikes Stss · Holden, MOThe noncertificated pilot’s failure to maintain aircraft control during takeoff.NTSB ERA21LA027Accident · Minor injuriesClass 4 · LimitedFinal reportMuse Stol CH 750 · Sewanee, TNThe airplane’s encounter with a downdraft during the initial climb, which resulted in an impact with trees.NTSB CEN21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportKitfox Classic 4 · New Carlisle, OHThe pilot’s failure to maintain pitch control of the airplane during landing, which caused the airplane to nose over during landing roll. Contributing to the accident was the main landing gear modification which increased the airplane’s tendency to nose over…NTSB ERA20LA324Accident · 1 fatalClass 3 · LimitedFinal reportVans RV 8 · Hilliard, FLA total loss of engine power due to oil starvation.NTSB ERA20CA319Accident · No injuriesClass 4 · Data collectionFinal reportRotorway Exec 162F · Kenansville, FLThe pilot’s failure to maintain control of the helicopter during takeoff.NTSB CEN20LA440Accident · No injuriesClass 3 · LimitedFinal reportSwearingen SA227 · San Antonio, TXThe pilot’s failure to fly a stabilized approach which resulted in a hard landing and loss of control.NTSB CEN20LA360Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · St Louis, MOA total loss of engine power due to improper maintenance of the mixture control cable and attachment hardware, which led to a forced landing into a congested area.NTSB WPR20CA293Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Phoenix, AZThe pilot's improper pitch attitude and landing flare, which resulted in a hard landing. Contributing to the accident was the flight instructors delayed remedial action.NTSB CEN20CA337Accident · Serious injuriesClass 4 · Data collectionFinal reportEvektor Aerotechnik L13 · Frankenmuth, MIThe pilot's failure to stow the speed brake prior to attempting takeoff.NTSB CEN20CA311Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Tractor AT 401 · Burlington, COThe pilot’s failure to maintain clearance from guy-wires during low-altitude agricultural operations.NTSB CEN20CA277Accident · Minor injuriesClass 4 · Data collectionFinal reportKitfox Kitfox Sport · Rand, COThe encounter with the downdrafts during the attempted takeoff, which resulted in decreased airplane's climb performance and subsequent impact with terrain.NTSB CEN20LA278Accident · 1 fatalClass 3 · LimitedFinal reportGrumman G164 · Springfield, COThe pilot’s loss of visibility in the cockpit due to foam created by the chemicals loaded in the hopper, which resulted in collision with terrain. Contributing to the accident was the combining of chemicals known to produce foam and the pilot’s failure to…NTSB CEN20LA267Accident · Serious injuriesClass 3 · LimitedFinal reportTitan Tornado · Mankato, KSA total loss of engine power for reasons that could not be determined based on available information.NTSB CEN20LA259Accident · Minor injuriesClass 3 · LimitedFinal reportSopwith Type 9400 · Van Alstyne, TXAn inflight loss of aileron control due to movement of a control connector.NTSB WPR20LA201Accident · 1 fatalClass 3 · LimitedFinal reportAvia Stroitel AC-5M · Bend, ORA loss of control just after takeoff for reasons that could not be determined based on the available information.NTSB ANC20CA062Accident · No injuriesClass 4 · Data collectionFinal reportCub Crafters CCK-1865 · Juneau, AKThe pilot's failure to maintain directional control during the landing rollout, which resulted in a ground loop.NTSB WPR20LA177Accident · 1 fatalClass 3 · LimitedFinal reportZenair CH601 · Maricopa, AZThe pilot’s loss of situational awareness and descent below pattern altitude during the landing approach, which resulted in collision with terrain at night.NTSB WPR20CA142Accident · No injuriesClass 4 · Data collectionFinal reportN126c CCX-2000 · Heber City, UTThe front seat pilot's failure to maintain directional control during the landing roll, and the rear seat pilot's delayed remedial control inputs that subsequently resulted in a ground loop. Contributing to the accident was a lack of communication by both…NTSB ERA20CA152Accident · No injuriesData collectionFinal reportHolmgren Bearhawk · Ahoskie, NCThe collapse of the right main landing gear during a bounced, crosswind landing.NTSB CEN20LA134Accident · 1 fatalClass 3 · LimitedFinal reportMuse P51D · Mesquite, TXThe pilot’s inadvertent exceedance of the airplane’s critical angle of attack for undetermined reasons, which resulted in an aerodynamic stall, loss of control, and subsequent impact with terrain.NTSB ERA20CA107Accident · No injuriesData collectionFinal reportOrlican L60 · Frederick, MDThe pilot's failure to maintain airplane control during the approach, which resulted in the airplane ballooning and then veering left upon landing and the right wing impacting the runway.NTSB CEN20CA067Accident · Minor injuriesData collectionFinal reportGlasair 1 · Greenville, TXThe pilot's failure to maintain a proper descent rate, which resulted in a hard landing, and his subsequent loss of airplane control during an attempted go-around.NTSB CEN20CA062Accident · No injuriesData collectionFinal reportBeech 76 · St. Charles, MOThe pilot receiving instruction’s misunderstanding of the flight instructor’s instruction and the pilot's and the instructor’s insufficient use of rudder while adding power to the operating engine, which resulted in the airplane rolling left and the wing…