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.

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.Jul 14, 2002 · N9542S · Substantial damageNTSB 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.Jun 27, 2002 · N13RM · DestroyedNTSB SEA01LA160Accident · Serious injuriesLimited investigationFinal reportShank Kitfox Model II · Battle Ground, WAThe pilot's failure to maintain adequate airspeed during climbout.Aug 28, 2001 · N2136F · DestroyedNTSB SEA01LA116Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Custer, WAThe first pilot's failure to maintain aircraft control while maneuvering. Factors include an inadvertent stall.Jun 10, 2001 · N52BG · DestroyedNTSB 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.Oct 23, 2000 · N567AW · DestroyedNTSB 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…Oct 21, 2000 · N8331H · Substantial damageNTSB 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).May 29, 2000 · N1995M · Substantial damageNTSB 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.Oct 23, 1999 · N54844 · 2 aircraft · Minor damageNTSB 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…Aug 23, 1999 · N6070K · DestroyedNTSB 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.May 25, 1999 · N149BT · Substantial damageNTSB SEA97LA189Accident · Minor injuriesLimited investigationFinal reportRotz RAF 2000 GTX SE · Olympia, WAThe pilot's failure to attain adequate rotor rpm prior to takeoff.Aug 15, 1997 · N9155H · Substantial damageNTSB SEA96LA220Accident · No injuriesLimited investigationFinal reportRalph Taylor Royal T · Kent, WAin-flight collision with an unknown object.Sep 25, 1996 · N2554 · Substantial damageNTSB 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.Aug 21, 1996 · N289W · Substantial damageNTSB SEA94LA143Accident · No injuriesLimited investigationFinal reportWray KR-2 · Puyallup, WAAn improperly functioning fuel boost pump.May 28, 1994 · N786RW · Substantial damageNTSB SEA93LA202Accident · Serious injuriesLimited investigationFinal reportKope Zenith CH200 · Waterville, WAA short in the electrical wiring to the fuel pump.Aug 21, 1993 · N456K · Substantial damageNTSB SEA93LA116Accident · Serious injuriesLimited investigationFinal reportRambow Monnett Moni · Ritzville, WAThe improper landing flare.May 21, 1993 · N106NR · Substantial damageNTSB SEA92LA172Accident · Minor injuriesLimited investigationFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe pilot misjudged the landing flare. Factors include a lack of total pilot expereince.Jul 31, 1992 · N3907A · Substantial damageNTSB SEA92LA139Accident · Minor injuriesLimited investigationFinal reportHarriman N-3 Ultra PUP · Arlington, WAThe partial loss of engine power, cause undetermined.Jun 28, 1992 · N30843 · DestroyedNTSB 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.Apr 20, 1991 · N570TS · Substantial damageNTSB SEA91LA083Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Port Orchard, WAThe loss of engine power due to contaminated fuel system.Apr 12, 1991 · N85948 · Substantial damageNTSB SEA90LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Randle, WAThe pilot failed to compensate for the wind conditions.Jun 21, 1990 · N4428F · Substantial damageNTSB 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.May 21, 1990 · N3229Z · Substantial damageNTSB 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.Jan 23, 1989 · N386PH · Minor damageNTSB 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…Sep 9, 1988 · N2526A · Substantial damageNTSB 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.Jul 20, 1988 · N2748K · DestroyedNTSB 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…Jun 8, 1988 · N7243X · Substantial damageNTSB 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.Sep 27, 1987 · N8751S · Substantial damageNTSB 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…Jun 29, 1985 · N5KB · DestroyedNTSB 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…Dec 19, 1984 · N4247A · 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 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 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 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.Jun 27, 1982 · N5919 · Substantial damageNTSB SEA81FYM01Accident · 1 fatalClosedWalker Mini · Trout Lake, WAOct 2, 1980 · N249KY · DestroyedNTSB SEA80FYE18Accident · Serious injuriesClosedAerospatle 318C · Aberdeen, WAFeb 27, 1980 · N5593N · Substantial damageNTSB SEA78DYE27Accident · No injuriesClosedPietenpol Bowers · Tacoma, WAJun 28, 1978 · N688Y · Substantial damageNTSB SEA77DYP40Accident · No injuriesClosedGrumman G-164B · Quincy, WAAug 15, 1977 · N48423 · Substantial damageNTSB SEA76FYE13Accident · No injuriesClosedDehavilland DHC-3 · Auburn, WASep 4, 1975 · N567AA · Substantial damageNTSB SEA70F0077Accident · Serious injuriesClosedPuss Moth 80A · Tekoa, WAAug 3, 1969 · N223EC · Substantial damage