NTSB investigations: Amateur-built UNKNOWN ENG, SC
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
| 1971 | 1 |
|---|---|
| 1973 | 1 |
| 1977 | 1 |
| 1979 | 2 |
| 1986 | 1 |
| 1990 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2005 | 2 |
| 2006 | 1 |
| 2008 | 1 |
| 2010 | 3 |
| 2012 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 2 |
| 2023 | 1 |
| 2024 | 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\" = 'SC' 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" = 'SC' 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 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 ERA23LA132Accident · Serious injuriesClass 3 · LimitedFinal reportStilp Tanner E Savannah S · Trenton, SCThe loss of control during the base turn to final due to the impingement of the Y-stick control by a notepad.NTSB ERA22LA081Accident · Serious injuriesClass 4 · LimitedFinal reportGlobe GC-1B · Bennettsville, SCThe pilot’s inadequate preflight planning, resulting in a takeoff attempt from a grass parking area instead of the runway and subsequent impact with a pole.NTSB ERA21LA192Accident · Serious injuriesClass 3 · LimitedFinal reportMeyeres F L/Meyeres M M Skystar Ktfox Clsc 4 · Mountain Rest, SCA partial loss of engine power due to carburetor icing. Contributing to the accident was the engine’s lack of carburetor heat.NTSB GAA19CA567Accident · No injuriesData collectionFinal reportGeorge W. Felix Mosquito · Kershaw, SCThe pilot's improper cyclic input during takeoff, which resulted in a loss of helicopter control, the skid impacting the ground, and a subsequent dynamic rollover.NTSB ERA18LA249Accident · 1 fatalLimited investigationFinal reportEdward R. Sugg Sonex · Marion, SCImpact with terrain for reasons that could not be determined based on the available information.NTSB ERA12CA156Accident · No injuriesData collectionFinal reportBeech 58 · Walterboro, SCThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident was the sunglare.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 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 ERA10LA256Accident · Serious injuriesLimited investigationFinal reportSwezey T/Molnar D Vans RV-10 · Ridgeland, SCAn explosion and fire of unknown origin during taxi from landing. Contributing to the accident was the builder's noncompliance with the manufacturer's suggested designed fuel system.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 ATL07CA009Accident · No injuriesData collectionFinal reportLawing Thomas R Exec 162-F · Aiken, SCThe pilot’s failure to adequately compensate for wind conditions during takeoff which resulted in a loss of tail rotor effectiveness and a roll over during an attempted forced landing.NTSB ATL05CA130Accident · Minor injuriesData collectionFinal reportJabiru SK0007 · Aiken, SCThe loss of engine power for undetermined reasons.NTSB ATL05LA052Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Macedonia, SCThe fatigue cracking of the planetary gear housing, which resulted in the loss of engine power.NTSB ATL03LA108Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Fort Mill, SCThe pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power.NTSB MIA02LA154Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Union, SCthe pilot's failure to maintain obstacle clearance.NTSB MIA01LA164Accident · 1 fatalLimited investigationFinal reportBroyles P51 · Conestee, SCPartial loss of engine power due to an engine cylinder experiencing detonation resulting in a forced landing to none suitable terrain.NTSB ATL00LA071Accident · Minor injuriesLimited investigationFinal reportRyskamp Sonex · Greenville, SCThe pilot's misjudgment of airspeed and altitude resulting in an undershoot.NTSB MIA98LA163Accident · Serious injuriesLimited investigationFinal reportNanchang CJ-6A · Pageland, SCWas the inadvertent stall of the airplane by the pilot-in-command while attempting to clear trees beneath the airplane during the descent for the forced landing. Contributing to the accident was the partial loss of engine power due to separation of the No.9…NTSB ATL97LA103Accident · No injuriesLimited investigationFinal reportHughes 269C · Johnston, SCfailure of the pilot to maintain the proper rotor RPM during the approach and flare for landing.NTSB ATL95LA116Accident · 1 fatalLimited investigationFinal reportSmith Monnett Moni · Cheraw, SCThe loss of engine power for unknown reasons, and the pilot's failure to maintain flying speed, which resulted in impact with the ground while the airplane was in a stalled condition.NTSB ATL90LA134Accident · No injuriesLimited investigationFinal reportHughes 269C · Saluda, SCPilot's failure to properly plan for high density altitude operations, which resulted in settling with power to the ground.NTSB ATL86LA179Accident · Serious injuriesLimited investigationFinal reportAndrew D. Moore HP-18 · Chester, SCThe pilot related that while turning from base to final he heard a loud bang from the left side of the aircraft. The aircraft entered a steep left turn and crashed left of final approach course. Post crash examination of the aircraft revealed that the flap…NTSB MIA80DLG01Accident · Minor injuriesClosedQuickie 1 · Allendale, SCNTSB MIA79DLG29Accident · Minor injuriesClosedHiller UH-12E · Timmonsville, SCNTSB MIA77DLG20Accident · No injuriesClosedBell 47D · Oswego, SCNTSB MIA73DLG39Accident · No injuriesClosedNavion A · Pelzer, SCNTSB MIA72DLG09Accident · No injuriesClosedBell 47D-1 · Rembert, SC