NTSB investigations: Amateur-built UNKNOWN ENG
2,048 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, newest first
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.\"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."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 CHI86LA219Accident · Minor injuriesLimited investigationFinal reportHughes 500 (369HS) · West Lafayette, INThe helicopter was at a low altitude hover video taping an athletic event when the aft flex coupling on the tail rotor failed. The plt was unable to regain control and during descent the main rotor blades struck the roof of a residence. The helicopter then…NTSB MKC86FCD03Accident · Serious injuriesFinal reportRoger Warnell KR-1 · Waterloo, IAThe pilot reported that he had carburetor problems. The engine quit and the pilot made a forced landing about one mile from airport. This was the pilots first flight in this aircraft.NTSB LAX86FVD09Accident · No injuriesFinal reportJaks Volksplane VP-2 · Ukiah, CAAt the end of a local flight, during the landing roll, the plt was distracted and allowed the acft to veer to the right side of the rwy. The plt applied the brakes when the left main landing gear collapsed.NTSB LAX86FA307Accident · 1 fatalField investigationFinal reportCherry HP16 · Llano, CAThe glider pilot departed on a local flight and the wreckage of his glider was spotted a little over an hour later. There were no known witnesses to the accident which occurred in VFR daylight conditions.NTSB MKC86LA157Accident · No injuriesLimited investigationFinal reportRandolph R.Clark KR-2 · Russell, KSThe pilot had just completed some adjustments to the carburetor and was making a high-speed taxi test when he became airborne. He applied more power to avoid stalling and immediately thereafter, the engine started running rough. He then decided to make a…NTSB NYC86DNC06Accident · Minor injuriesFinal reportHansen Hawk 304 · Wolfeboro, NHThe experimental aircraft equipped with a buick V-8 aluminum block engine experienced power loss on approach for landing. The pilot decided that the distance and terrain was too great for a glide to the airport, and an emergency water landing in a nearby lake…NTSB NYC86LA160Accident · No injuriesLimited investigationFinal reportHiller 12C · Lehighton, PAThe pilot of the Hiller 12C reported an overheated engine followed by an engine failure. During the forced landing the main rotor flexed and cut the tail boom off the the aircraft. The aircraft was examined. 10 oz. Of a liquid was found in the fuel system. 7…NTSB SEA86LA152Accident · No injuriesLimited investigationFinal reportRockwell S2R · Caldwell, IDShortly after departure the pilot could not get any aileron response. A landing was attempted at a nearby airport where a go around became necessary. During the go around control of the aircraft was lost and it descended to ground impact. Investigation…NTSB NYC86FNA01Accident · No injuriesFinal reportSteen Skybolt UNK · Beverly, MAThe Steen Skybolt modified with a turbo-prop conversion experienced a power loss on takeoff after achieving an altitude of 200-300 ft AGL and made a hard landing on the runway remaining. The landing gear collapsed and aircraft received substantial damage. The…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 FTW86LA113Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Palacios, TXDuring the ground run portion of the takeoff, the acft contacted a mud hole which resulted in it veering off the grass and into bushes alongside the strip. The plt did not select suitable terrain for the takeoff.NTSB ATL86LA165Accident · No injuriesLimited investigationFinal reportCessna 172M · Cobb, GAThe plt reported a rough running eng. He attempted a precautionary ldg during which the acft's nose wheel dug in the soft ground and the acft nosed over. Post accident inspection of the eng failed to disclose any failures/malfunction.NTSB MIA86LA168Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Panama City Bch, FLThe pilot had intended to hover the helicopter and allow a 'clown' to touch the skids while a photographer recorded the event looking upward to give the appearance that the 'clown' was hanging from the skid. The 'clown' grabbed the left rear skid and the…NTSB MIA86FA126Accident · Serious injuriesField investigationFinal reportBlythe Quickie · Eustis, FLThe student pilot departed on a student cross-country flight with 2 gallons of fuel in the tank of the homebuilt quickie. About 30 to 45 minutes later the engine failed at 1800 ft MSL. The student attempted to stretch the glide to a road and struck trees and…NTSB MKC86FA083Accident · 1 fatalField investigationFinal reportGlasair 2 · Cheney, KSThe acft approached Cheney lake, west of wichita, Kansas at low altitude from the southeast. Several witnesses fishing from the bank saw the acft pass near the Cheney lake marina heading toward the lake. The acft then entered a spin and crashed into the lake…NTSB MIA86FA115Accident · 1 fatalField investigationFinal reportPitts Special · Homestead, FLThe plt was on a flt to practice aerobatic mnvrs in a designated practice area. A witness, who was driving nearby, stated that he saw the acft 'falling straight down' & crash in a tomato field. An investigation revealed evidence that the acft had impacted in…NTSB CHI86IA115Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · Minneapolis, MNN508US was operating as nwa flt 150. The captain stated after the incident that the flt was uneventful until landing. Upon landing and spoiler deployment, the acft pitched up abruptly, to an attitude of 10 degrees. The landing was completed without incident.…NTSB CHI86FER02Accident · Minor injuriesFinal reportMonnett Moni · Winona, MNThe acft crash landed off the arpt due to a reported loss of power. The plt landed in a small field surrounded by hills. The acft sink rate during the landing was high and the acft was damaged. Inspection of the eng after the acc was not accomplished due to…NTSB DEN86FTI01Accident · Minor injuriesFinal reportMiller Sievers Special · Gillette, WYOn March 3, 1986 at approximately 1715 MST, an experimental Miller, sievers special, struck the ground during takeoff at the Gillette-campbell county airport, Gillette, Wyoming. The pilot stated that just after takeoff on runway 34, the aircraft appeared to…NTSB FTW86LQG07Accident · Serious injuriesFinal reportRaven Rally RX-7 · Lockney, TXThe student pilot stated that he did not checked the wind forecast when he called for a weather briefing about four hours before the accident. The surface winds increased to 30 gusting 40 KTS while he was airborne. He reported that when he landed, he was not…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.…NTSB FTW85FA088Accident · 4 fatalField investigationFinal reportMooney M20J · San Antonio, TXThe non-instrument rated plt obtained a wx briefing & filed an IFR flt plan although poor wx conditions existed (200 ft ceiling & one-half mi visibility) at San Antonio. The tower instructions to N5681K were to fly rwy heading (120 deg) after departure,…NTSB LAX85LA081Accident · No injuriesLimited investigationFinal reportWeedhopper Super Nova II · Lakeside, CAThe ultralight acft lost power on takeoff & stalled into the ground. According to the builder/plt the capillary type fuel pump had failed to function properly on the takeoff climb causing fuel starvation. He failed to recover from a nose high attitude in time…NTSB SEA85FA034Accident · Serious injuriesField investigationFinal reportde Havilland DHC-3 Turbo · West Seattle, WAAcft was performing test flt maneuvers when problems with the modified fuel system occurred. Ice blocking a fuel vent line caused a partial collapse of the main (engine feed) fuel cell which produced an errouneous fuel quantity reading. In addition, the main…NTSB MIA85LA056Accident · No injuriesLimited investigationFinal reportSikorsky UH34J · Carrabelle, FLThe acft was conducting external load logging operations in a hover at aprx 175 ft AGL when the power loss occurred. According to the plt, the eng ran intermittently with black smoke coming out of the exhaust pipe before the eng failed totally. The…NTSB MIA85LA030Accident · No injuriesLimited investigationFinal reportLet L-13 · Homestead, FLAccording to the plt, a downdraft was encountered on base leg causing the acft to descend and decelerate. Unable to reach the rwy the glider landed in an orchard.NTSB LAX85IA040Incident · No injuriesIncident investigationFinal reportWestland Helicopters WG30 · Santa Ana, CADuring a climb to cruise, the crew experienced control difficulties when the for-&-aft trim actuator began to motor forward and would not stop. An emerg descent was made with both plts exerting aft cyclic pressure to prevent the speed from increasing over 120…NTSB NYC85FFJ01Accident · Serious injuriesFinal reportStevens MONNETT-MONI · Endicott, NYThe acft collided with the terrain in an uncontrolled descent following a partial loss of power during a takeoff climb. The plt stated the RPM dropped from 5200 to 4600 at which time he attempted to lean the mixture. A severe vibration developed and not…NTSB CHI85LA017Accident · No injuriesLimited investigationFinal reportCrosetti Glasair - TD · Ypsilanti, MIThe acft had just returned from a flt. Engine run-up and pre-flt checks were normal. On initial climb, eng lost pwr to extent continued flight was not possible. Plt executed forced landing in an open field. Inspection revealed a bird feather lodged against…