NTSB investigations: Amateur-built UNKNOWN ENG, WA
89 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.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA'
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 SEA02LA134Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Kittitas, WAThe pilot's failure to conduct an adequate preflight inspection of the fuel resulting in fuel exhaustion and a subsequent forced landing. A contributing factor was the rocky terrain encountered during the forced landing.NTSB SEA02LA115Accident · No injuriesLimited investigationFinal reportSeattle Aerotech Helipower 2500 · Arlington, WAAircraft control not maintained during a run-on landing. A vibration of unknown origin was a factor in the accident.NTSB SEA01LA160Accident · Serious injuriesLimited investigationFinal reportShank Kitfox Model II · Battle Ground, WAThe pilot's failure to maintain adequate airspeed during climbout.NTSB SEA01LA116Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Custer, WAThe first pilot's failure to maintain aircraft control while maneuvering. Factors include an inadvertent stall.NTSB SEA01LA008Accident · 1 fatalLimited investigationFinal reportWildman Adventurer · Yelm, WAA main rotor blade strike (impact) with both a pusher propeller blade and the rudder during an unknown phase of operation resulting in a loss of control and uncontrolled descent to terrain.NTSB SEA01LA009Accident · No injuriesLimited investigationFinal reportHallett HALLETT-1 · Yelm, WAThe pilot's failure to abort the takeoff when it became questionable as to whether the aircraft would be able to clear an object just off the departure end of the runway, and the pilot's failure to maintain clearance from the object as he attempted to…NTSB SEA00LA096Accident · No injuriesLimited investigationFinal reportAS+ AS-4 · Ephrata, WAThe pilot's improper in-flight decision by not immediately seeking a safe landing site upon encountering the sink. A factor was the high vegetation (sagebrush).NTSB SEA00IA007Incident · No injuriesIncident investigationFinal reportCessna 172P · Wenatchee, WAThe failure of the pilots in both aircraft to maintain an adequate visual lookout. Haze was a factor.NTSB SEA99FA146Accident · 2 fatalField investigationFinal reportRepublic RC-3 · Chimacum, WAThe inadequate visual lookout by both the pilot-in-command and second pilot, and the pilot-in-command's failure to maintain sufficient flying speed to prevent a stall condition. Contributing factors were the transmission lines, gusty wind conditions, and the…NTSB SEA99LA071Accident · No injuriesLimited investigationFinal reportBen Travis Kitfox IV · Carnation, WALoss of engine power due to a cracked engine impulse line, which disabled the fuel pump. A factor was the intentional ground loop by the pilot.NTSB SEA97LA189Accident · Minor injuriesLimited investigationFinal reportRotz RAF 2000 GTX SE · Olympia, WAThe pilot's failure to attain adequate rotor rpm prior to takeoff.NTSB SEA96LA220Accident · No injuriesLimited investigationFinal reportRalph Taylor Royal T · Kent, WAin-flight collision with an unknown object.NTSB SEA96LA196Accident · Serious injuriesLimited investigationFinal reportWestcott Glasair I-FT · Puyallup, WAfailure of the air inlet screen, and subsequent ingestion of the foam air filter. An inadequate maintenance modification by the amateur builder and no suitable landing area were related factors.NTSB SEA94LA143Accident · No injuriesLimited investigationFinal reportWray KR-2 · Puyallup, WAAn improperly functioning fuel boost pump.NTSB SEA93LA202Accident · Serious injuriesLimited investigationFinal reportKope Zenith CH200 · Waterville, WAA short in the electrical wiring to the fuel pump.NTSB SEA93LA116Accident · Serious injuriesLimited investigationFinal reportRambow Monnett Moni · Ritzville, WAThe improper landing flare.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 SEA92LA139Accident · Minor injuriesLimited investigationFinal reportHarriman N-3 Ultra PUP · Arlington, WAThe partial loss of engine power, cause undetermined.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 SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.NTSB SEA90LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Randle, WAThe pilot failed to compensate for the 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 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 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 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 SEA88LA107Accident · No injuriesLimited investigationFinal reportBeech A36 · Wenatchee, WAAirframe ice was accumulating on the aircraft at 13,000 feet so the pilot requested an altitude of 14,000 feet. At 14,000 feet the pilot lost control of the aircraft and descended down to 6,500 feet before recovering. The pilot had stated that he felt he had…NTSB SEA87LA196Accident · No injuriesLimited investigationFinal reportCessna 150F · Mount Vernon, WAThe aircraft's engine ceased operating due to fuel exhaustion about five miles short of the destination airport. A field was selected for the landing site. During the landing roll, the aircraft nosed over on freshly plowed terrain.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 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 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.NTSB 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…NTSB 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.…NTSB SEA82DA096Accident · No injuriesFinal reportBensen B-8M · Kennewick, WAThe pilot stated that he was demonstrating the gyrocopter's vertical decent capability at an eaa fly-in. He flew the aircraft into the wind at approximately 200 feet, reduced power and failed to recover from the sink rate.NTSB SEA81FYM01Accident · 1 fatalClosedWalker Mini · Trout Lake, WANTSB SEA80FYE18Accident · Serious injuriesClosedAerospatle 318C · Aberdeen, WANTSB SEA78DYE27Accident · No injuriesClosedPietenpol Bowers · Tacoma, WANTSB SEA77DYP40Accident · No injuriesClosedGrumman G-164B · Quincy, WANTSB SEA76FYE13Accident · No injuriesClosedDehavilland DHC-3 · Auburn, WANTSB SEA70F0077Accident · Serious injuriesClosedPuss Moth 80A · Tekoa, WA