NTSB investigations: Amateur-built UNKNOWN ENG, 1985
22 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\") = 1985
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") = 1985
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 DEN86LA049Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Bountiful, UTAccording to the plt, he and three friends were en route to a local ski resort, when the helicopter encountered deteriorating wx. The plt stated he elected to cross the ridge and fly down a ravine to maintain visual reference. The plt said he was aware of…NTSB LAX86FVA01Accident · 1 fatalFinal reportRobert D. Campbell KR-1 · Oakdale, CAThe acft crashed in a cow pasture in VMC wx. The acft left wing struck the ground in a steep angle of bank and the acft nosed in throwing the eng 450 ft farther across the field. The canopy & canopy latch were found prior to the impact point of the left wing.…NTSB MIA86FA014Accident · Minor injuriesField investigationFinal reportCessna 421C · Ft.Lauderdale, FLThe acft crashed on the arpt during an on demand air taxi flt. The plt stated that on final apch he encountered turbulence and rain. As he broke out of the rain the glare from the sun interferred with his visual perception. A go around was attempted but the…NTSB CHI86FEX03Accident · No injuriesFinal reportBell H13G · Mccordsville, INThe helicopter rolled over after the main rotor blades contacted the terrain during an attempt to land from a hover. The plt had a student plt airplane certificate at the time of the accident.NTSB CHI85LA378Accident · Minor injuriesLimited investigationFinal reportSchweizer 134 · Hampshire, ILThe pilot reportedly failed to use spoilers on final. The approach was high so he attempted a 180 degree turn at the departure end of the runway. The glider stalled and collided with the ground.NTSB ATL85LA273Accident · 1 fatalLimited investigationFinal reportCessna 404 · Hayesville, NCFisherman heard an aircraft overhead but did not see any sign of it in the night sky. Shortly thereafter they saw a flash and fire on the side of a mountain, then they heard the explosion. The sheriff was called and an investigation revealed a crashed…NTSB NYC85LA221Accident · No injuriesLimited investigationFinal reportRobinson R22 · Ronkonkoma, NYDuring a local training flight the student was attempting a lift off and began to drift to the left. The students control input was to the left aggravating the situation. The instructor took control of the aircraft however the roll over had progressed to an…NTSB FTW85FA331Accident · 2 fatalField investigationFinal reportValentin Taifun 17E · Abilene, TXThe glider was thermaling in a slow right climbing turn about 600 feet above ground level. Witnesses stated it started a right spiraling descent and the nose suddenly dropped until it was in a near vertical attitude. The spiral then developed into a tight…NTSB CHI85LA305Accident · Serious injuriesLimited investigationFinal reportKauffman BD4 · Acme, MIThe plt was on the second flt of newly certificated acft and had been airborne aprx 10 minutes when a total loss of pwr was experienced. Unable to return to the arpt the plt landed the acft in an open fld. During the landing roll the acft struck a road…NTSB ATL85LA222Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-109B · Williamson, GAThe plt of the powered glider reported that during an apch to land, the acft encountered a downdraft & landed hard. The landing gear was damaged as well as the prop, eng cowling & oil cooler.NTSB MIA85LA214Accident · No injuriesLimited investigationFinal reportBell 47D1 · Moultrie, GAThe plt stated that while he was on an aerial application mission, the helicopter ran out of fuel. During an autorotation, the main rotor severed the tail boom.NTSB CHI85LA277Accident · No injuriesLimited investigationFinal reportBurch Pitts S-1 · Houghton Lake, MIThe acft nosed down following a ground loop during a landing roll. The plt reported the tailwheel began to shimmy, directional control of the acft was lost and it ground looped to the right. The acft traveled aprx 10 ft off the rwy where the left wing dug…NTSB SEA85FA156Accident · 1 fatalField investigationFinal reportKibler-Bede BD-5B · Oak Harbor, WAPrior to the acdnt, witnesses aprx 9 mi sw of the crash site saw an acft (matching the description of N5KB) flying at about 100 to 200 ft over the water on a NE heading. It then pulled up in a steep climbing turn toward the shoreline. No known witnesses saw…NTSB CHI85IA212Incident · No injuriesIncident investigationFinal reportBoeing 727-023 · Chicago, ILAmerican airlines flt 57 had departed baltimore for Chicago. On final approach at ohare the crew discovered the nose gear would not extend. The fe made three attempts to crank down the gear all of which were unsucessful. After landing with nose gear up all…NTSB DEN85FA131Accident · 1 fatalField investigationFinal reportConsolidated-Vultee PBY-5A · Lewistown, MTDuring taxi to takeoff the brakes failed. The plt attempted to groundloop the acft. The acft rolled down hill and collided with a gully. The plt was fatally injured. During preflight the co-plt inadvertently added hydraulic fluid in the alcohol tank. The…NTSB NYC85LA116Accident · No injuriesLimited investigationFinal reportCentrair 101A · Barre, MAThe acft encountered windshear during the approach to land and landed in trees. By the time the plt realized his situation it was too late and his wing tip hit a tree top. The acft camp to rest in trees.NTSB CHI85LA180Accident · No injuriesLimited investigationFinal reportMitchell Monnett Moni · Athens, MIThe plt of the home-built/powered glider initiated a touch-&-go landing. However, he did not retract the spoilers when he began the takeoff portion of the touch-&-go. The acft lifted off into ground effect, but the left wing contacted a rwy light at the…NTSB CHI85LA175Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Richfield, OHThe plt made a short field takeoff using aprx 1700 ft of the 2200 ft airstrip. Unable to clear trees along the flt path, he turned to the right. However, the acft's wheel pants contacted a tree while the plane was still banked to the right & a slight amount…NTSB FTW85LA191Accident · No injuriesLimited investigationFinal reportWisconsin State Prison Sonerai II · Castroville, TXAccording to the plt, after lift-off from the 5,000 ft long rwy, the acft was in ground effect prior to an uncontrolled right roll. The acft impacted the ground right wing first. The plt reported 2 hrs experience in the acft and no mechanical malfunctions.NTSB CHI85IA143Incident · No injuriesIncident investigationFinal reportFairchild F-27 · Champaign, ILDuring engine start a fuel line running between the fuel pump and the differential pressure switch ruptured and caused a small fire. The crew observed a fire warning light,aborted the start procedure and activated the fire extingui shing system which put the…NTSB LAX85IA175Incident · No injuriesIncident investigationFinal reportPiper PA-44-180 · San Jose, CAA Piper seminule was vectored to the final apch course & cleared for an ILS apch at 3000FT MSL. A DC-9, in trail at 5000FT MSL, was overtaking the seminule. The controller elected to change their sequence & cleared the seminule to climb to 4000FT MSL due to…NTSB MIA85IA120Incident · No injuriesIncident investigationFinal reportDouglas DC-6B · Miami, FLCrew stated that on takeoff roll the number four engine failed and an aborted takeoff was intiated. During the decelleration after the throttles were closed the number four engine seized and the number four propeller separated when the propeller shaft failed.…