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.

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…Oct 3, 1984 · N4014D · Substantial damageNTSB MKC84LA287Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Prairie City, IAWhile the hot air balloon was airborne, the surface winds increased to 13 KTS. The plt instructed both passengers to prepare for a high wind landing. Contrary to the plt's instructions, the passenger, who became injured, crouched in the bottom of the basket…Sep 30, 1984 · N8517L · No damageNTSB ATL84LA289Accident · No injuriesLimited investigationFinal reportWilliam T. Hodges Goldwing · Americus, GADuring the initial takeoff climb at an alt of 150 ft AGL, a ttl loss of power occurred. A forced landing was made in a soybean filed at which time the acft was substantially damaged. The plt stated the loss of power resulted from the installation of a…Sep 15, 1984 · N132GW · Substantial damageNTSB ANC84FA140Accident · No injuriesField investigationFinal reportCessna 180 · Anchorage, AKThe plt stated that he was taking off to the southeast & the acft was on the step when a x-wind hit, lifting the right wing. He said the left wing then hit the water, spinning the acft to the left & the nose hit the water. The acft went over on its back &…Aug 18, 1984 · N9062M · Substantial damageNTSB SEA84LA207Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel AIR B9-4000 · Vancouver, WAThe pilot stated after the accident that he applied too much brake during the landing roll. The aircraft nosed over.Aug 17, 1984 · N9917 · Substantial damageNTSB ATL84FA241Accident · Serious injuriesField investigationFinal reportCessna 337A · Ocean Springs, MSThe acft stalled, rolled inverted and crashed into a hangar roof during an attempted go-around after an aborted landing. The plt had landed for refueling and offered a ride in the acft to a person that helped him during the refueling. Duringthe first landing…Aug 3, 1984 · N90244 · DestroyedNTSB SEA84LA156Accident · No injuriesLimited investigationFinal reportMonett-Keating Moni · Bremerton, WAThe pilot stated he had shut down the engine several times to glide. On the last restart the engine ran for aprx 15 secsand then began to run rough and died. Attempted restarts were not successful. The aircraft failed to clear trees while attempting to land…Jul 3, 1984 · N193RK · Substantial damageNTSB CHI84LA272Accident · Minor injuriesLimited investigationFinal reportHoward E. Lee Rutan Long EZ · Minneapolis, MNThe plt claimed a loss of power during takeoff. He turned and attempted a landing on the arpt. The rwy was overrun and the acft stopped in a wheat field. Post accident examination of the engine revealed no discrepancies.Jun 30, 1984 · N373JH · Substantial damageNTSB CHI84LA245Accident · Serious injuriesLimited investigationFinal reportBell 47-G2 · Nimrod, MNWhile landing in an area of tall grass a skid collided with a sand ridge causing a roll over.Jun 18, 1984 · N18JM · DestroyedNTSB MIA84IA177Incident · No injuriesIncident investigationFinal reportGrumman G-111 · West Palm Beach, FLAfter a repositioning flt, the main gear collapsed. An exam of the hand pump selector control valve revealed that one of the two dump ports for thr flap position had a hydraulic leak. Reportedly, this allowed system pressure to retract the gear. The valve,…Jun 3, 1984 · N112FB · Minor damageNTSB FTW84LA247Accident · No injuriesLimited investigationFinal reportGermany Wetherell Sonerai I · Leander, TXPrior to the flight the plt adjusted the carburetor. A local flight was made to test the carburator. During the gliding apch to the rwy the plt noticed the eng idle power was 1400 RPM. While on base leg the plt advanced the throttle, however, eng pwr remained…May 28, 1984 · N92CL · Substantial damageNTSB LAX84LA298Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Ramona, CAAs part of an experimental test flt in the turbine powered acft, intentional spins were performed. The planned one turn spin evolved into a flat spin. Recovery procedures were ineffective and the plt elected to deploy the anti-spin parachute. Despite repeated…May 18, 1984 · N4772K · DestroyedNTSB MKC84LA138Accident · No injuriesLimited investigationFinal reportSoneria II · Kansas City, KSThe plt of the home built acft was practicing touch-&-go landings. While climbing out after the 5th landing, the plt's canopy unlatched & opened. The plt attempted to close the canopy & nosed the acft down to maintain a safe airspeed. While trying to close…May 5, 1984 · N1355K · Substantial damageNTSB ATL84LA144Accident · 1 fatalLimited investigationFinal reportBrown, R. M. JR. Monnett Moni · Kill Devil Hill, NCThe acft was the 4th acft to take off of 7 scheduled to make a formation fly-by of the wright brothers national memorial. As the acft took off to join up for the flt, a thick low fog bank rolled in. The other acft departed the area, but the plt attempted to…Apr 14, 1984 · N92RB · Substantial damageNTSB MIA84LA134Accident · No injuriesLimited investigationFinal reportBell 47D1 · Berlin, GAThe plt collided with power lines as he turned to fly back to reload the acft. The plt made a statement that he did not see the wires in the trees. The plt did not file an accident report.Apr 12, 1984 · N586T · DestroyedNTSB MIA84LA127Accident · No injuriesLimited investigationFinal reportBucker Flugzeugbau Jungmann · St. Augustine, FLThe plts of a Bucker jungmann, N1947G, & a pitts S-2B, N5302M, were practicing for an airshow. They began a maneuver called a 'mirror fly-by' in which the Bucker was rolled upside down & the pitts was flown underneath it. Due to the air flow over the wings…Apr 2, 1984 · N1947G · 2 aircraft · Minor damageNTSB FTW84LA164Accident · Minor injuriesLimited investigationFinal reportEagle Balloons Eagle C-7 · Houston, TXThe plt stated that the wx at the accident site was scattered clouds between 150-650 ft AGL with a definite ceiling at 650 ft (broken). Visibility was 1 mi with rapidly forming fog layer. The plt descended with the intention of landing as soon as possible. He…Mar 10, 1984 · N6081L · Substantial damageNTSB DCA84AA014Accident · Serious injuriesFinal reportFokker F27-100 · Jamaica, NYDuring the previous flt, the acft encountered light icing conditions while crusing at 4000 ft. the capt stated that the ice disappeared from the acft's structure in the course of its descent at 3000 ft & he did not use wing de-icing or the eng cowling…Jan 13, 1984 · N148PM · Substantial damageNTSB NYC84FHM03Accident · No injuriesFinal reportHomebuilt Spad Xiii · Montgomery, NYThe acft lost power about 1 mile from the arpt and the plt made a forced landing on a farm. The acft nosed over. The weather conditions were conducive to carburetor icing and this acft has no provision for carburetor heat control.Dec 10, 1983 · N3772L · Substantial damageNTSB ATL84LA046Accident · No injuriesLimited investigationFinal reportBell 47-G · Middle River, MDWhile practicing hovering about 2 ft AGL the student allowed the helicoper to start drifting aft & right. The right skid heel contacted the ground & the helicopter roll onto its right side.Nov 18, 1983 · N64816 · Substantial damageNTSB LAX84AA054Accident · Serious injuriesFinal reportWestland Helicopters 30-100 · Long Beach, CAAt 4,000 ft MSL directional control was lost. Witnesses observed the helicopter descending through the localized cloud layer in a left high-rotation turn, with the pitch attitude varying & its rate of descent 'very fast.' The helicopter then collided with…Nov 8, 1983 · N5830T · DestroyedNTSB DEN83LA218Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · Park City, UTThe glider dragged a wing and nosed into the ground before ground looping during landing. The pilot said he was lifted by an updraft during landing and was running out of landing space so he turned to an alternate area. The turn was made at 150-200 ft AGL &…Sep 18, 1983 · N7636 · Substantial damageNTSB CHI83IA418Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Chicago, ILThe acft experienced a left walking beam failure when the landing gear was extended during approach, the acft log was noted 'during gear extension at 230 KTS tremendous bang occurred which dropped panels at rows 15-7 02 masks at row 18. Three green normal…Sep 7, 1983 · N1984 · Minor damageNTSB CHI83FA419Accident · 1 fatalField investigationFinal reportWarren Moneri S · Lapeer, MIThe glider collided with the ground after an unscheduled tow release at about 150 ft AGL.this was the plts first flt in this acft after having the engine removed and the acft recertified as a glider. Ground personnel observed the glider and tow pilot release…Sep 7, 1983 · N275HW · DestroyedNTSB SEA83FA162Accident · 1 fatalField investigationFinal reportPiper PA-36 · Firth, IDAccording to witnesses, the acft was overheard returning to the strip for a second load. Reportedly, it went into a steep bank at about 70 ft AGL & turned toward the strip. As the wings leveled, sounds of high eng power ceased & the acft descend to the…Aug 2, 1983 · N57588 · DestroyedNTSB MIA83FA175Accident · 2 fatalField investigationFinal reportLong EZE · Near Captiva, FLA witness observed the aircraft flying in a northerly direction about 1/2 mile away at an altitude of about 100 feet. It appeared to be travelling in excess of 80 KTS and the engine sounded normal. Another witness observed the aircraft strike the water in a…Jul 3, 1983 · N812EZ · DestroyedNTSB SEA83FA141Accident · 1 fatalField investigationFinal reportMonnett - Larsen Moni · Albany, ORThe home built, powered glider was being flown on a local test flight. According to witnesses, the acft was in unpowered flt (gliding) when it entered a descent & crashed. At about the same time it began descending, they observed something separate from the…Jun 30, 1983 · N83GL · DestroyedNTSB MKC83LA139Accident · No injuriesLimited investigationFinal reportBowlin Quickie · Grain Valley, MOThe acft made a landing during its first test flight. The plt stated that he had slowed the acft to below 65 mph at about 10 ft above the rwy. At this point the canard stalled & the nose pitched down. There was no damage on the first rwy contact. On the…Jun 28, 1983 · N55772 · Substantial damageNTSB NYC83LA135Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob 109 · Finleyville, PAThe motorized glider collided with trees and the terrain during an emergency landing after the prop had struck the ground during takeoff. During the takeoff roll the propeller 1st collided with high grass and then a bump in the ground after the pilot lost…Jun 5, 1983 · N903BG · Substantial damageNTSB CHI83LA244Accident · Serious injuriesLimited investigationFinal reportMonerai Sailplane · Montpelier, OHThe glider dragged a wing and carlwheeled during a low turn maneuver by the pilot. The pilot stated that he apparently had failed to lock the flap handle in the proper position and the acft had picked up excess airspeed. In trying to stay in the rwy…Jun 5, 1983 · N13HT · Substantial damageNTSB DEN83FA131Accident · 2 fatalField investigationFinal reportAero Commander 680FL · Monticello, UTThe acft crashed while doing magnetometer surveys at low altitude. The right engine had lost power then regained it for a short period and lost it again. A videotape in the acft recorded the plt saying, 'I changed that # just in time.' The acft yawed and the…Jun 2, 1983 · N271VT · DestroyedNTSB FTW83LA247Accident · No injuriesLimited investigationFinal reportFairchild Hiller FH-1100 · Beaumont, TXThe helicopter was damaged in an emergency landing in a street. The acft had just taken off from an adjoining parking lot in a shopping center. According the plt the acft lost rotor RPM at 150-175 ft during climb after takeoff and went into a 'settling with…May 25, 1983 · N543FH · Substantial damageNTSB CHI83LA215Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Grandville, MIReportedly, the plt increased the bank angle during a turn to align the acft on final apch, then the plane lost speed & stalled. Subsequently, the acft impacted the ground aprx 480 ft southwest of the rwy threshold. Aprx 10 mi east at grand rapids, MI, the…May 15, 1983 · N3019N · Substantial damageNTSB CHI83LA197Accident · Serious injuriesLimited investigationFinal reportHolmes XTC2 · River Falls, MNThe acft pulled up steeply after takeoff and stalled. The acft crashed back on the rwy. The pilot said he reduced power after takeoff and the acft stalled. He also said if he had not reduced power the accident would not have happened.May 4, 1983 · N3885D · Substantial damageNTSB DEN83LA099Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Belfield, NDThe helicopter rolled over on a slight slope in an open field during a landing. The pilot stated that the acft touched down on the left skid, the acft started to tip to the left and he over corrected so that the acft rolled over to the right.Apr 17, 1983 · N8623B · Substantial damageNTSB MIA83LA102Accident · Serious injuriesLimited investigationFinal reportGemini Int'l. Humingbird · Lakeland, FLThe acft landed hard and collapsed the nose gear after one engine failed during takeoff. The acft had made one takeoff and landing and was beginning a second. As the acft rotated the left engine failed due to the throttle linkage becoming disconnected. The…Mar 19, 1983 · N3147G · Substantial damageNTSB NYC83FHJ01Accident · Minor injuriesFinal reportHarrison Volmer VJ-22 Amphibian · Schinnecock Bay, NYWhile gaining speed on step to make water takeoff the hull of the aircraft collided with something not seen in the waterand began to sink. The aircraft filled with water and sank until it rested on the bottom with only the prop tip showing the weather was VFR…Feb 27, 1983 · N3509 · Substantial damageNTSB MIA83LA079Accident · No injuriesLimited investigationFinal reportHughes 500-369HS · Boca Raton, FLThe plt reported the flt experienced a total eng power loss & the acft was ditched in the intracoastal waterway. All examinations & tests conducted during the investigation revealed no evidence of a preimpact failure or malfunction of the airframe or eng.Feb 21, 1983 · N2254X · Substantial damageNTSB LAX83IA080Incident · No injuriesIncident investigationFinal reportBoeing 767-231 · San Diego, CAWhile descending thru 12,000 ft aprx 40 mi east of San Diego, CA, the left overwing evacuation slde annunciator light illuminated. The slide separated from the acft aprx 7 mi east of the arpt. No flt control problems were noted. Integrity of the sys was found…Jan 24, 1983 · N602TW · Minor damageNTSB SEA83FA033Accident · 2 fatalField investigationFinal reportBell 214B · Near Randle, WAThe acft departed a private heliport & impacted a mountain at the 3,400 ft level. The wreckage was located about one mile east from the heliport. The impact site was hidden behind a ridge & is not visible from the heliport or the access road to the heliport.…Dec 18, 1982 · N244PH · DestroyedNTSB CHI83LA062Accident · 1 fatalLimited investigationFinal reportScorpion Too · Sandwich, ILThe rotorcraft impacted the runway very hard with no flare after the engine quit 100-200 feet AGL. The pilot had no training in this aircraft. No fuel was found in the fuel tank and no fuel odors were present. An examination of the fuelsystem, engine and…Dec 18, 1982 · N9354A · DestroyedNTSB 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…Dec 11, 1982 · N90773 · Substantial damageNTSB CHI83LA029Accident · No injuriesLimited investigationFinal reportFlagg 13 · Lansing, ILThe pilot stated he took off to the west and just after becoming airborne the engine lost power. The aircraft landed in a bean field. Examination of the fuel system revealed that the inlet fuel line to the fuel pump had rotted and large pieces of the interior…Oct 30, 1982 · N13625 · Substantial damageNTSB SEA83LA011Accident · No injuriesLimited investigationFinal reportBrantly 305 · Hillsboro, ORThe tail skid hit the ground hard during landing. This caused the helicopter to bounce, and the left wheel contacted the ground causing the helicopter to turn sideways. The main rotor contacted the tail rotor, destroying both tail and main rotor blades.Oct 23, 1982 · N16616 · Substantial damageNTSB DEN83LTI01Accident · No injuriesFinal reportScorpion 133 · Manhattan, MTBattery failed because it had not been charged. No on board charging provision. Electric pump could not operate without electricity. No fuel to engine. During an autorotative landing, the tail rotor was damaged. With no tail rotor control, the helicopter slid…Oct 3, 1982 · N133RW · Substantial damageNTSB CHI83LA001Accident · No injuriesLimited investigationFinal reportBenson Gyrocopter · Mt. Vernon, OHThe gyrocopter pilot stated that he landed the aircraft hard, bounced and then nosed over.Oct 1, 1982 · N9985F · DestroyedNTSB CHI82DA332Accident · No injuriesFinal reportHiller 12B · Detroit, MIThe plt entered the Detroit city arpt area from the west with winds from 280 degrees at 18K gusting to 23K. At 150-175 ft AGL the plt added power in order to reduce his closure rate, traveling southeasterly at the time. The acft then started yawing to the…Sep 2, 1982 · N48209 · Substantial damageNTSB MKC82DA158Accident · No injuriesFinal reportFairchild Hiller FH 1100 · Mason City, IADuring a swath run, the engine RPM dropped to flight idle and the helicopter was landed hard in a clear area beside the field. An investigation revealed that a sensing line for the fuel control system had failed. This prevented the engine from operating above…Aug 26, 1982 · N1345Q · Substantial damageNTSB DEN82DA169Accident · Serious injuriesFinal reportQuicksilver Mxii · Broomfield, COReportedly, the pilot made an intersection takeoff from about midfield on runway 02. He stated that he took off at rotation speed plus 2 KTS. The passenger reported that they reached about 40 ft AGL, then lost lift and begun to settle. As the two-place…Aug 20, 1982 · N3149Z · Substantial damageNTSB DEN82DA165Accident · No injuriesFinal reportBellanca 7GCBC · Yuma, COThe pilot stated that as he touched down the aircraft porpoised "a couple of times." When the aircraft had slowed to approximately 25-30 mph it ran off the runway into soft dirt and nosed over.Aug 16, 1982 · N5138X · Substantial damage