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 CHI90DER04Accident · Minor injuriesFinal reportBD 4- Francisco BD-4 · Rosemount, MNFailure of the manufacturer (amateur built) to design fuel system adequately to prevent vapor lock in fuel line.NTSB SEA90LA150Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 Libelle · Thompson Falls, MTA disabled aircraft blocking the active runway.NTSB MKC90LA145Accident · Minor injuriesLimited investigationFinal reportMonnett Sonerai II · Cherokee, IAAircraft control not maintained by the pilot in command.NTSB SEA90LA117Accident · No injuriesLimited investigationFinal reportDickey E-RACER · Jackpot, NVAn undetermined failure or anomaly of the exhaust system, which resulted in an in-flight fire of the fiberglass structure of the aircraft and failure of the aircraft braking system.NTSB NYC90LA143Accident · 1 fatalLimited investigationFinal reportBoeing A75L3 · Groton, CTAn impact with the ground following an improperly executed roll with insufficient altitude for recovery. Factors related to the accident were improper use of the flight controls by the pilot.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 SEA90LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Randle, WAThe pilot failed to compensate for the wind conditions.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 FTW90DPJ08Accident · 1 fatalFinal reportDe Havilland Venom 112 MK4 · Muskogee, OKThe pilot's premature rotation and the subsequent stall. A factor was the pilot's lack of experience in the airplane.NTSB NYC90LA124Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Barre, MAThe premature commanded tow release by the towplane pilot over unsuitable terrain.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 SEA90LA082Accident · No injuriesLimited investigationFinal reportRobert Van Scoyoc Soneria IIL · Ellensburg, WAThe loss of engine power due to carburetor icing, caused by the pilot's failure to apply carburetor heat. Factors in the accident were the carburetor icing weather conditions and the lack of suitable terrain for forced landing.NTSB LAX90LA164Accident · Minor injuriesLimited investigationFinal reportBell 47G · Riverside, CAThe pilot's failure to maintain control of the helicopter. A factor related to the accident was: the pilot's lack of experience in the type of aircraft.NTSB LAX90LA142Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Chico, CAFuel starvation due to unporting of the fuel pick up in the fuel tank selected for the takeoff.NTSB ATL90FA095Accident · 2 fatalField investigationFinal reportEmbraer EMB-120 · Gadsden, ALInadequate visual lookout by the pilots of both aircraft, which resulted in their failure to see-and-avoid oncoming traffic. A factor related to the accident was: the sun's glare, which restricted the vision of the Cessna 172 pilot.NTSB ATL90FA070Accident · 2 fatalField investigationFinal reportBeech 58 · Demorest, GAThe pilot's failure to maintain control of the airplane while in instrument meteorological conditions. Contributing factors were: the pilot's overconfidence, lack of recent flight experience, and the weather conditions.NTSB MIA90IA070Incident · No injuriesIncident investigationFinal reportBoeing 727-225A · Sarasota, FLImproper servicing of the forward lavatory by contract service personnel.NTSB FTW90DRA02Accident · Serious injuriesFinal reportNorth American P-51-D · Galveston, TXThe pilot in command's failure to obtain a weather briefing. Ontributing to the accident was his inadequate inflight planning and the resultant low fuel state.NTSB LAX90LA048Accident · Serious injuriesLimited investigationFinal reportAerostar RX-7 · Chandler, AZImproper planning/decision by the pilot. Factors related to the accident were: variable and high wind conditions.NTSB CHI90IA006Incident · No injuriesIncident investigationFinal reportBoeing 757-251 · San Francisco, CAThe extreme wear and eventual failure of a torque tube in the inboard trailing edge flap system. Inspection and lubrication intervals were a factor, as was the physical location of the torque tube with reference to external factors.NTSB ATL89LA221Accident · Minor injuriesLimited investigationFinal reportBeech B23 · Hatteras, NCLoss of engine power for an unknown reason.NTSB ATL89LA212Accident · No injuriesLimited investigationFinal reportSikorsky H-34J · Louisville, GAAn undetermined malfunction of the main rotor drive system.NTSB ATL89FA196Accident · 1 fatalField investigationFinal reportBeech A-36 · Chapel Hill, NCThe pilot's failure to maintain control of the airplane while maneuvering for a landing. Contributing factors were: the pilot's failure to follow the emergency procedures for an autopilot malfunction, and pilot fatigue.NTSB BFO89LA067Accident · No injuriesLimited investigationFinal reportTravel Air B-4000 · Midland, VAThe pilot's improper compensation for wind conditions and improper flare during the landing. Contributing factors were:the wind conditions and the pilot's lack of experience in this make and model of aircraft.NTSB LAX89LA245Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Maricopa, AZThe pilot's inability to maintain airspeed, resulting in a hard landing. Also causal to the accident was the opening of the canopy for undetermined reasons.NTSB DEN89LA165Accident · Minor injuriesLimited investigationFinal reportHenry Vickers HCV-110 · Newcastle, WYThe failure to the magneto. The selection of a powerplant with a single magneto system was an improper choice and directly contributed to the cause. The pilot's misjudgement of the wind for the approach to a forced landing resulted in an improper ground…NTSB LAX89LA188Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Haleiwa, Oahu, HIThe pilot's failure to adequately compensate for wind conditions and the failure to maintain sufficient altitude to clear obstacles. Contributing to the accident were the downdrafts along the ridge line.NTSB FTW89LA119Accident · No injuriesLimited investigationFinal reportCessna A185F · Marksville, LAFailure of the pilot to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and a subsequent nose over.NTSB LAX89DVG05Accident · No injuriesFinal reportMorse F85P-1 · Redding, CAAn animal on the runway. Factors were: the pilot's intentional ground loop and the resultant loss of control.NTSB DEN89LA088Accident · Minor injuriesLimited investigationFinal reportMiller S.A.L. 2/3 Mustang · Erie, COLoss of engine power for an unknown reason. Soft uneven terrain was a contributing factor.NTSB ATL89LA108Accident · No injuriesLimited investigationFinal reportBeech A36 · Chamblee, GAThe inattention of the pilot which resulted in the inadvertent retraction of the landing gear during the landing roll.NTSB MKC89LA065Accident · No injuriesLimited investigationFinal reportComposite Aircraft Mfg Cozy · Hudson, IAImproper preflight by the pilot which resulted in an inadequate fuel supply and fuel exhaustion.NTSB SEA89IA042Incident · No injuriesIncident investigationFinal reportFairchild SA-227-AC · Seattle, WAInoperative nosewheel steering due to improper maintenance. Contributing to the incident was the lack of adequate maintenance information available in the aircraft manuals.NTSB MIA89LA053Accident · Minor injuriesLimited investigationFinal reportPilatus P-2/05 · St. Augustine, FLAfter an en route stop, the pilot took off in the newly acquired acft. Shortly after gear and flap retraction, the eng sustained a partial loss of power. The plt stated that all eng gages appeared normal and a turn was begun in an attempt to return to the…NTSB FTW89LA019Accident · Minor injuriesLimited investigationFinal reportLuscombe 11A · Houston, TXNTSB CHI89LA025Accident · No injuriesLimited investigationFinal reportCessna 172P · Samaria, MINTSB FTW89DPA02Accident · Minor injuriesFinal reportPilatus B4PC11 · Bridgeport, TXThe glider was being tow-launched by an automobile from the pilot's private ranch airstrip. When the glider was approximately 250 feet AGL, the tow rope separated and the pilot attempted to return to the airstrip. A downdraft made this impossible and the…NTSB MIA89LA010Accident · No injuriesLimited investigationFinal reportRaven S-60A · Tampa, FLDrg an apch to land, the plt saw some bushes & another balloon (which had already landed) in his intended landing area. He applied burner to soar over the obstacles, then pulled the envelope vent to quickly descend after the obstacles had been cleared. He…NTSB LAX89DUQ01Accident · 1 fatalFinal reportLewis Moni · Lancaster, CADuring a local flight, shortly after takeoff, the pilot reported engine trouble. The pilot was cleared to land at his discretion. The glider was observed to make a steep left descending turn subsequently colliding with the terrain. This was an experimental…NTSB LAX88FA332Accident · Serious injuriesField investigationFinal reportFairchild Hiller FH-1100 · Picacho, AZOwner/pic used poor judgement in allowing an unqualified pilot to fly the helicopter when it was not equipped with dual controls.NTSB SEA88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Seattle, WAPlt landed with 80 deg right cross wind of 8 KTS, groundlooped to right. The plt said that ATIS info gave the wind as 220 degrees at 8 KTS; however his EST from windsock observation included gusts of 15 KTS. The observing station reported no gusts on the date…NTSB ANC88LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Fairbanks, AKThe airplane was on a climbout at approximately 1000 to 1200 feet m.s.l. when the engine quit and the pilot encountered an engine fire. The pilot elected to go back to the airport. The airplane crashed on the taxiway, and the airplane was substantially…NTSB ANC88LA118Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe plt was practicing touch-&-go landings. On the first landing, the acft bounced & a successful go-around was made. During the second landing, the plt lost directional control of the acft & it went off the left side of the rwy & was damaged.NTSB LAX88LA292Accident · Serious injuriesLimited investigationFinal reportSiai-Marchetti S.205/22R · Bullhead City, AZAt the end of a cross country flight, the pilot had to abort the landing the first time due to heavy rain showers and turbulence. The pilot returned for landing and during the landing roll on the wet runway, the pilot lost control of the airplane. The…NTSB CHI88DEM10Accident · No injuriesFinal reportGrumman G-164B · Schoolcraft, MIThe pilot failed to maintain directional control while maneuvering the aircraft to avoid an obstacle during the landing roll. The aircraft's right wing impacted a corn crop and the aircraft swerved/ground looped to the right and skidded to a stop, nose down.…NTSB MIA88LA247Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Boca Raton, FLWhile at an alt of aprx 800 ft 1 mile offshore, the plt reported a drop of the manifold pressure from 29 to 20'HG, & as a result, the main rotor and engine RPM needles split. He then turned on the boost pump with negative results. An autorotative landing in…NTSB MKC88LA142Accident · No injuriesLimited investigationFinal reportShirlan Dickey E-RACER · Dubuque, IAAt a fuel stop in Dubuque, IA the PIC purchased fuel for the final leg of his flt to oshkosh. After a pre-flt chk and subsequent eng runup, the PIC took the active rwy and commenced a takeoff roll. The lift off and initial climb went without difficulty until…NTSB CHI88FA178Accident · No injuriesField investigationFinal reportSonerai IIL · Oshkosh, WINTSB SEA88LA134Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Eastsound, WAPlt was cruising at 200 feet over the water, looked down to get a chart under his seat and collided with the water.NTSB LAX88DUG05Accident · No injuriesFinal reportCosta TEENY-TWO · Corona, CAThe homebuilt teeny-two acft was built with a 40 HP, british reliant, hawk ae eng, rather than a volkswagon eng which builders normally used. It had been flown only one time before the acdnt flt. The 1st flt was made in cooler temp conds without incident; the…