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 NYC93LA038Accident · 1 fatalLimited investigationFinal reportHelio H-700 · Shelton, CTThe pilot's failure to check the position of the landing gear before attempting a water landing.NTSB LAX93LA047Accident · 1 fatalLimited investigationFinal reportNorth American F-51D · Wellington, NVThe pilot's improper handling of his airplane during the performance of an aerobatic maneuver with inadequate altitude.NTSB LAX93LA039Accident · No injuriesLimited investigationFinal reportGlaser-Dirks DG400 · Calistoga, CAThe failure of the brakes due to a separation of the brake cable for undetermined reasons. A factor in the accident was the tailwind condition during the landing rollout.NTSB CHI93LA023Accident · No injuriesLimited investigationFinal reportCessna 140 · Waverly, IAThe pilot's excessive application of brakes during landing roll.NTSB FTW93LA010Accident · Serious injuriesLimited investigationFinal reportRaven S-60A · Albuquerque, NMThe pilot's failure to maintain visual lookout.NTSB ANC92LA157Accident · No injuriesLimited investigationFinal reportSikorsky S-58G · Port Alsworth, AKInflight engine compartment fire and post landing fire of undetermined origin.NTSB CHI92DEM05Accident · Serious injuriesFinal reportTaylorcraft H-2 · Holland, MINot maintaining a sufficient airspeed during the reversal turn and encountering a stall/spin maneuver.NTSB FTW92DPG12Accident · No injuriesFinal reportGrumman G-164A · Mc Crory, ARThe pilots failure to maintain directional control.NTSB SEA92LA172Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe pilot misjudged the landing flare. Factors include a lack of total pilot expereince.NTSB CHI92DEX04Accident · Minor injuriesFinal reportAlkire Pietenpol · Delphi, INSeparation of the propeller while in flight, and unsuitable terrain to effect a forced landing.NTSB SEA92LA169Accident · No injuriesLimited investigationFinal reportGreth Cirrus VK30 · Rawlins, WYThe pilot in command's failure to maintain control of the aircraft. Factors contributing to the accident were: crosswinds and gusts.NTSB SEA92LA139Accident · Minor injuriesLimited investigationFinal reportHarriman N-3 Ultra PUP · Arlington, WAThe partial loss of engine power, cause undetermined.NTSB NYC92IA129Incident · No injuriesIncident investigationFinal reportBoeing 767-231ER · Jamica, NYThe failure of the fifth stage low pressure turbine vanes due to fatigue.NTSB MIA92FA142Accident · 1 fatalField investigationFinal reportHughes 369HS · Labelle, FLThe pilot-in-command's improper application of collective pitch during an autorotative landing resulting in insufficient rotor RPM and in-flight collision with trees and the terrain. Contributing to the accident was the total loss of engine power due to fuel…NTSB FTW92LA140Accident · Minor injuriesLimited investigationFinal reportArdovino Mariucci CRI-CRI MC-12 · Arlington, TXTotal power loss caused by blocked carburetor screen and ignition points open beyond manufacturer's specification. A factor was inadequate annual inspection and ignition point maintenance adjustment not performed.NTSB FTW92LA132Accident · No injuriesLimited investigationFinal reportSchweizer G-164D · Welsh, LAThe engine failure at liftoff due to the failure of multiple turbine blades and the pilot's inability to maintain directional control during the aborted takeoff.NTSB LAX92LA208Accident · No injuriesLimited investigationFinal reportCorbus/Winters BD-5B · Fresno, CAThe total loss of engine power during initial climb due to a fracture and failure of the engine starter ring gear. A contributing factor which was related to the mechanical failure was the airplane owner's inadequate maintenance.NTSB ATL92LA086Accident · 1 fatalLimited investigationFinal reportGlaser-Dirks DG-600/18M · Newnan, GAThe loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall at too low of an altitude to effect recovery.NTSB CHI92LA126Accident · Serious injuriesLimited investigationFinal reportCessna 170B · St. James, MOThe pilot's failure to maintain clearance from terrain during the attempted takeoff and climb out. A related factor was the rising terrain.NTSB DCA92RA020Accident · 30 fatalForeign investigationConvair 640 · Kafoutine, SenegalNTSB DEN92IA014Incident · No injuriesIncident investigationFinal reportCessna 172RG · Broomfield, COFailure of the left main landing gear pivot assembly due to ductile torsional overstress.NTSB NYC91LA247Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas MD-82 · East Boston, MAThe malfunction of an electrical component in the cockpit, which resulted in smoke and the subsequent emergency evacuation of the passengers from the airplane.NTSB ATL91LA165Accident · Serious injuriesLimited investigationFinal reportIcard, Claude M. Sonerai II LT · Morganton, NCThe pilot's failure to maintain directional control of the airplane on the runway, and the inadvertent rotation of the airplane, resulting in an unplanned flight.NTSB CHI91LA263Accident · No injuriesLimited investigationFinal reportBeech 36 · Davenport, IAThe inadequate visual lookout and poor inflight planning and decision making by the pilot of N97867. Factors in the accident are inoperative exterior lights and radio communication not possible.NTSB NYC91DNC04Accident · Minor injuriesFinal reportLaurent A. Cloutier BD-5B · Gilford, NHEngine failure due to a faulty oil pressure relief valve resulting in an emergency landing on unsuitable terrain.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 CHI91LA214Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Sparta, MIInadequate preflight by the pilot and the pilot's failure to reach a proper touchdown point.NTSB ATL91FA117Accident · 2 fatalField investigationFinal reportFuji LM 1 · Keystone Hghts, FLFailure of the number four pilot (in N2100J) to maintain adequate visual lookout and/or clearance from the number three aircraft (N2109L).NTSB CHI91DEP10Accident · No injuriesFinal reportAllan R. Goldman Dragonfly · Kenosha, WIInadequate aircraft design and insufficient information regarding wing versus canard angle for an amateur built aircraft.NTSB CHI91DEP06Accident · No injuriesFinal reportAvid Flyer Avid Flyer · Endeavor, WIThe pilot in command's inability to effectively eliminate carburetor ice to avoid an emergency landing.NTSB NYC91LA143Accident · No injuriesLimited investigationFinal reportCessna 120 · Wellsville, PAA power loss due to a fuel system blockage which resulted in a forced landing.NTSB NYC91DGT04Accident · No injuriesFinal reportGeorge E Heide, JR. Moni Motorglider · Annville, PAThe pilot's intentional landing on unsuitable terrain due to a loss of altitude precipitated by a downdraft.NTSB SEA91LA106Accident · No injuriesLimited investigationFinal reportBeech A36 · Rawlins, WYThe pilot's lack of familiarity with the aircraft, his lack of understanding of the electrical system, and a premature precautionary landing. Contributing to the accident were an alternator failure and the resultant false readings of the powerplant…NTSB ATL91LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Clanton, ALFailure of the pilot to maintain control of the aircraft during a go-around. The pilot's lack of experience was a related factor.NTSB MIA91LA127Accident · No injuriesLimited investigationFinal reportTravel Air 2000 · Homestead, FLAn on ground encounter with weather conditions that were favorable for carburetor icing at a low power setting (glide power), and failure of the pilot to abort the takeoff after recognizing that the eng was not developing full power during the initial climb.NTSB SEA91LA092Accident · Minor injuriesLimited investigationFinal reportSmelser KR-2 · Spokane, WAA failure of the fuel drain valve which resulted in fuel exhaustion and a loss of engine power.NTSB LAX91LA175Accident · Serious injuriesLimited investigationFinal reportSnider RV6 · Paulden, AZThe pilot's poor preflight preparation and his failure to ensure that the fuel selector was properly positioned for flight.NTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.NTSB ATL91LA076Accident · No injuriesLimited investigationFinal reportDavid Lowe ULTRA-PUP · Waycross, GAThe failure of the airplane battery, which prohibited the complete extension of the landing gear, resulting in a landing with the nose gear retracted. A factor in the accident was the soft terrain at the selected landing area.NTSB LAX91LA120Accident · No injuriesLimited investigationFinal reportBoeing A75 · Marana, AZThe failure of the pilot in the trailing airplane to maintain clearance from the lead airplane.NTSB SEA91LA031Accident · No injuriesLimited investigationFinal reportBeech 3NM · Bozeman, MTThe failure of the right engine master rod.NTSB MIA91IA032Incident · No injuriesIncident investigationFinal reportATR ATR-42-300 · St. ThomasThe failure of the left main landing gear side brace lower arm due to fatigue resulting from corrosion formation, which resulted from improper design to prevent corrosion formation.NTSB NYC91LA032Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G103A · Erwinna, PAThe student pilot's improper landing technique and the instructor's inadequate supervision.NTSB LAX91DUJ03Accident · No injuriesFinal reportAir Tractor AT-302 · Somerton, AZThe failure of the number 3 exhaust valve which led to an engine failure and subsequent crash landing.NTSB LAX91TL#02Accident · Minor injuriesClass 3Final reportMcDonnell Douglas 369E · Llano, CANTSB NYC91LA007Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Erwinna, PAThe pilot's failure to maintain directional control during the take off roll.NTSB MIA91FA001Accident · 1 fatalField investigationFinal reportErik K. Van Der Kaay Marco J-5 · Clearwater, FLThe pilot's inadvertent deployment of the air brakes at a low altitude.NTSB NYC90DHM26Accident · No injuriesFinal reportPalen Sopwith Dolphin · Reinbeck, NYUndetermined engine failure during low altitude operations.NTSB CHI90LA274Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob 109A · Waukesha, WIThe pilot's failure to maintain adequate clearance and visual lookout for the moving tractor.NTSB ANC90LA135Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA-315B · Tok, AKImproper installation of the fuel filter element in the aircraft by company/maintenance personnel, and subsequent contamination of the fuel system by unfiltered fuel. Factors related to the accident were: inadequate design of the fuel filter assembly, which…