NTSB investigations: Amateur-built UNKNOWN ENG, TN
29 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
| 1980 | 1 |
|---|---|
| 1982 | 3 |
| 1987 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 3 |
| 2010 | 2 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 3 |
| 2015 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
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.\"eventStateOrRegion\" = 'TN' AND c.\"eventCountry\" = 'USA'
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."eventStateOrRegion" = 'TN' AND c."eventCountry" = 'USA'
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 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 GAA20CA043Accident · No injuriesData collectionFinal reportZenair Zenith 801 · Knoxville, TNThe pilot's failure to maintain a proper descent rate during the approach and his improper landing flare, which resulted in a hard landing.NTSB ERA19LA228Accident · No injuriesClass 3 · LimitedFinal reportPietenpol BIG Piet · Gainesboro, TNSeparation of the spinner cap for reasons that could not be determined based on available evidence, which resulted in contact and subsequent separation of the wooden propeller blade tip.NTSB ERA19LA139Accident · No injuriesClass 3 · LimitedFinal reportMarlow Bearhawk · Sevierville, TNAbnormal combustion in the No. 1 cylinder for reasons that could not be determined based on the available evidence, followed by the activation of the ignition system circuit breaker, which resulted in a total loss of engine power.NTSB ERA18FA240Accident · 1 fatalField investigationFinal reportLance M Hooley Jetez · Covington, TNThe improper manufacture of the left wing, which resulted in a left wing flutter event and failure at low altitude and high speed.NTSB GAA17CA467Accident · Serious injuriesData collectionFinal reportJames D Riggs RV-10 · Lawrenceburg, TNThe pilot’s improper landing flare and failure to maintain yaw control during a go-around in gusting wind conditions.NTSB ERA15FA353Accident · 1 fatalField investigationFinal reportAero Vodochody L39 · Oneida, TNThe pilot's failure to maintain airplane control following a partial loss of engine power during initial climb. The reason for the partial loss of engine power could not be determined due to extensive postimpact damage.NTSB ERA15CA005Accident · No injuriesData collectionFinal reportHPH 304CZ · Pikeville, TNA loss of aerodynamic lift, which resulted in an off-airport landing and subsequent impact with a pole.NTSB ERA14FA461Accident · 1 fatalField investigationFinal reportEagle R&D Helicycle · Gallatin, TNThe pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…NTSB ERA14FA421Accident · 1 fatalField investigationFinal reportKlaas Development Lancair IV P · Ooltewah, TNThe inadequate torque of the propeller mounting bolts and inspection of the propeller, which resulted in the fatigue fracture of the bolts and a subsequent in-flight separation of the propeller assembly.NTSB ERA13LA320Accident · 1 fatalLimited investigationFinal reportThompson Bruce D Sonerai II · Pulaski, TNThe pilot's failure to maintain airspeed during a near-vertical climb after takeoff, which resulted in an aerodynamic stall and subsequent collision with terrain.NTSB ERA12CA551Accident · Minor injuriesData collectionFinal reportHolloman L B/Holloman E M Sonex · Chapmansboro, TNThe pilot’s failure to maintain directional control during the takeoff initial climb.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 ERA10CA332Accident · No injuriesData collectionFinal reportCrabtree RV6 · Sewanne, TNThe pilot's improper recovery from a bounced landing.NTSB ERA09LA498Accident · Serious injuriesLimited investigationFinal reportHahn R-W22 Tiger Moth Rep · Symrna, TNA loss of engine power for undetermined reasons.NTSB ERA09LA325Accident · 2 fatalLimited investigationFinal reportSmith Bret B Searey · Knoxville, TNThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and uncontrolled descent.NTSB ERA09CA313Accident · Minor injuriesData collectionFinal reportPensinger Zodiac 601 · Greeneville, TNAn encounter with wind shear on initial climb after takeoff.NTSB NYC08LA259Accident · Serious injuriesLimited investigationFinal reportSands Thomas E Rotorway 162 · Graysville, TNA loss of control for undetermined reasons.NTSB MIA07FA137Accident · 5 fatalField investigationFinal reportBeech A36 · Elizabethton, TNThe poor in-flight planning by the pilot-in-command for flying towards rising terrain with inadequate clearance.NTSB NYC07CA122Accident · Minor injuriesData collectionFinal reportHanson Gerald Hanson Bucker 131E · Memphis, TNThe pilot's inadequate visual lookout that resulted in a collision with a lighting structure in the grass while landing. A factor in the accident was the pilot's intentional landing in the runway safety area.NTSB ATL06FA045Accident · 1 fatalField investigationFinal reportSwearingen SA-226-TC · Paris, TNThe pilot's inflight loss of control following a reported fuel asymmetry condition for undetermined reasons.NTSB ATL05LA113Accident · 1 fatalLimited investigationFinal reportMize Donald Kolb MK III X · Dickson, TNThe pilot's failure to maintain adequate obstacle clearance during climb out which resulted in the in-flight collision with a tree.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 ATL97LA111Accident · No injuriesLimited investigationFinal reportAvid IV · Memphis, TNThe pilot's failure to maintain control of the aircraft during takeoff. A factor in the accident was the repositioning of the control stick.NTSB ATL87DLT03Accident · 1 fatalFinal reportBurkhart Grob G102-111B · Memphis, TNGlider tow rope released at about 200FT following t/o. glider made rt turn followed by stall/spiral which continued until ground impact. Tow pilot saw glider pilot's hat falling to ground just after tow rope was released by glider pilot. Glider canopy was…NTSB ATL83LA061Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Nashville, TNDuring an autorotation at about 125 ft AGL the student attempted to apply power for a recovery but noted that the oil pressure light was illuminated & the eng had quit. The CFI took the controls & executed an emergency landing. He maneuvered to avoid power…NTSB ATL82DA206Accident · No injuriesFinal reportPitts S2S · Somerville, TNShortly after touchdown during a formation landing, the wingman's aircraft struck an engine stand that had been placed over a hole in the runway. The hole was located about 900 ft from the approach end and was about 2 ft long, 1 ft wide, and 1 ft deep. It was…NTSB ATL82DA150Accident · No injuriesFinal reportBell 47D1 · Blountville, TNThe aircraft lost power at 100 feet above ground level. An autorotation was attempted to a highway. The hard landing resulted in the main rotor severing the tail.NTSB IAD80FLT06Accident · No injuriesClosedGrumman G-164A · Montezuma, TN