NTSB investigations: Amateur-built UNKNOWN ENG, AR
32 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
| 1965 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1984 | 1 |
| 1988 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2003 | 3 |
| 2004 | 1 |
| 2005 | 2 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 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\" = 'AR' 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" = 'AR' 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 CEN17LA312Accident · No injuriesLimited investigationFinal reportRalph Marine Devil DOG · Danville, ARA separation of the left tire from its wheel because of the use of an improper substance and wheel size, which resulted in a loss of directional control during landing.NTSB CEN15LA131Accident · No injuriesLimited investigationFinal reportBell-Watson 47 G · North Little Rock, ARThe flight instructor’s failure to maintain adequate rotor rpm during the practice touchdown autorotation, which resulted in a subsequent loss of helicopter control and impact with terrain.NTSB CEN15LA023Accident · Serious injuriesLimited investigationFinal reportTuberville Zodiac XL · Mountain Home, ARThe partial loss of engine power during takeoff for reasons that could not be determined because postaccident engine examinations revealed no anomalies that would have precluded normal operation.NTSB CEN12LA259Accident · No injuriesLimited investigationFinal reportMoody-Siple A · Stuttgart, ARThe pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN09CA391Accident · No injuriesData collectionFinal reportShultz Jeffrey D Sonex · Mena, ARThe total loss of engine power for undetermined reasons.NTSB DFW08LA108Accident · Serious injuriesLimited investigationFinal reportWoods Challenger II · Corning, ARThe pilot's failure to maintain clearance from transmission lines. A contributing factor was the low altitude selected by the pilot.NTSB CHI07LA113Accident · 2 fatalLimited investigationFinal reportMurphy Aircraft Mfg SR3500 Moose · Cotter, ARThe pilot not maintaining airplane control and airspeed during the approach. Factors were the gusty wind conditions, the inadvertent stall the pilot encountered, and the power lines that were impacted during the uncontrolled descent.NTSB CHI05FA272Accident · 1 fatalField investigationFinal reportMitsubishi MU-2B-36 · West Memphis, ARThe pilot's improper in-flight decision not to land at the departure runway or other available airports during the emergency descent, and his failure to maintain clearance from a vehicle and terrain. Contributing factors were a false engine fire warning…NTSB DFW05CA137Accident · Minor injuriesData collectionFinal reportPZL-Mielec M18 · Clover Bend, ARThe pilot's failure to maintain directional control during takeoff. A contributing factor was the dust devil (whirlwind) encountered.NTSB FTW04LA152Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Dumas, ARThe loss of engine power for undetermined reasons.NTSB CHI03LA311Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Cash, ARThe delayed aborted takeoff by the pilot. The ditch was a factor to the accident.NTSB CHI03LA230Accident · No injuriesLimited investigationFinal reportMurch Rotec Rally 3 · Searcy, ARThe frayed rudder cable that failed during the turn to final. A factor was the ditch the airplane encountered during the forced landing.NTSB CHI03LA155Accident · No injuriesLimited investigationFinal reportSesin EXEC90 · Searcy, ARThe unqualified maintenance performed by the pilot and the inadequate autorotation by the pilot. A factor contributing to this accident was the overtemperature of the engine cooling system.NTSB FTW01LA196Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18 · Dumas, ARThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB FTW00LA078Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AT · Fayetteville, ARThe flight crew's failure to extend the landing gear. Contributing factors were the flight crew's non-compliance with the checklist, the pilot-in-command's diverted attention as a result of the loss of instrument approach/runway lighting, the partial failure…NTSB FTW00LA006Accident · 1 fatalLimited investigationFinal reportWSK PZL Mielec M18 · Weldon, ARThe cause of the accident was undetermined.NTSB FTW98LA179Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec PZL-M-18 · Carlisle, ARThe pilot's inadequate preflight and inflight planning/decision, which resulted in fuel exhaustion and the lost of engine power. A factor was the lack of suitable terrain for a forced landing.NTSB FTW96LA132Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Dewitt, ARa loss of engine power due to the malfunction of the carburetor as a result of an improper overhaul. A factor was the unsuitable terrain for the forced landing.NTSB FTW95LA317Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mccrory, ARThe loss of engine power due to a cracked cylinder. A factor was the lack of suitable terrain for the forced landing.NTSB FTW95LA027Accident · Serious injuriesLimited investigationFinal reportGardner SEA REY · Hartman, ARFailure of the pilot to follow the landing checklist and retract the landing gear for a water landing.NTSB FTW93LA146Accident · Minor injuriesLimited investigationFinal reportPzl-Mielec PZL-M-18 · De Witt, ARCompensation for wind improper by pilot. Factors were tailwind and downdraftNTSB FTW92DPG12Accident · No injuriesFinal reportGrumman G-164A · Mc Crory, ARThe pilots failure to maintain directional control.NTSB FTW91FA123Accident · 1 fatalField investigationFinal reportHughes 269B · Brickeys, ARThe failure of the clutch control cable due to fraying which initiated the forced landing and the operator's failure to perform recommended inspections on the aircraft. Factors were the pilot's failure to maintain rotor RPM and the unsuitable terrain.NTSB MKC90LA132Accident · No injuriesLimited investigationFinal reportPiper PA-36-400 · Altheimer, ARDirectional control was not maintained by the pilot in command. Contributing factors were landing with a tailwind. Compensation for wind conditions not considered and selection of the wrong runway.NTSB MKC90LA118Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Morton, ARThe pilot's failure to maintain directional control due to inadequate compensation for wind conditions.NTSB MKC88LA057Accident · No injuriesLimited investigationFinal reportMorane-Saulnier F1-156C · Pine Bluff, ARThe pilot, while hand-propping the acft for a personal flt, started the engine. The cockpit was unattended. He was assisted by two ground crewmembers that were holding onto the wing struts. After starting, the engine progressively developed more power, and…NTSB MKC85LA001Accident · No injuriesLimited investigationFinal reportAyres S2R-R3S · Lepanto, ARAs the pilot set climb power the acft began to settle. Full power was applied but the descent continued. The pilot dumped the chemical load and landed in a rice field. During recovery of the wreckage the flexible induction air duct partially collapsed…NTSB FTW78FPG26Accident · 1 fatalClosedBensen B8-MG · Carlisle, ARNTSB FTW78DPG06Accident · No injuriesClosedMustang II · Wheatley, ARNTSB FTW68D0335Accident · No injuriesClosedCessna 180 · Pine Bluff, ARNTSB FTW67F0152Accident · No injuriesClosedPiper PA-25 · Success, ARNTSB FTW66I0019Incident · No injuriesClosedBoeing B-727 · Little Rock, AR