Skip to content

NTSB investigations, WA

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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'
  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'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 SEA94LA212Accident · No injuriesLimited investigationFinal reportAvid Magnum · Woodland, WAInadequate in-flight planning/decision and clearance from trees was not maintained. A factor to the accident was trees.Aug 15, 1994 · N180AB · Substantial damage NTSB SEA94LA209Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Redmond, WAFailure of an exhaust valve. A factor to the accident was: wet grass.Aug 13, 1994 · N95285 · Substantial damage NTSB SEA94LA201Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M18S · Royal City, WAThe pilot's inadequate remedial action. Factors include high density altitude and unfavorable winds.Jul 30, 1994 · N81705 · Substantial damage NTSB SEA94LA200Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-301 · Connell, WAThe pilot's failure to maintain airspeed while conducting aerial application activities.Jul 29, 1994 · N3649Y · Destroyed NTSB SEA94LA192Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Bremerton, WAThe pilot-in-command's failure to maintain directional control during landing.Jul 22, 1994 · N327 · Substantial damage NTSB SEA94LA191Accident · Serious injuriesLimited investigationFinal reportAvian Magnum 9 · Pasco, WAA physical impairment that reduced the passenger's ability to hold on to the basket during the hard landing. Factors include an excessive rate of descent at touchdown.Jul 22, 1994 · N50257 · No damage NTSB SEA94LA189Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Seattle, WAThe proper touchdown point was misjudged by the pilot. During the go-around attempt, he failed to maintain clearance from obstacles.Jul 22, 1994 · N73175 · Substantial damage NTSB SEA94FA182Accident · 1 fatalField investigationFinal reportCessna 172K · Patos Island, WAThe pilot's impairment of judgment and performance due to drugs (marijuana), and his improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees, while taking off toward the closed end of a cove.Jul 18, 1994 · N7417G · Substantial damage NTSB SEA94LA184Accident · No injuriesLimited investigationFinal reportBlack RV-4 · Twisp, WAProper descent rate was not maintained during approach.Jul 17, 1994 · N144US · Substantial damage NTSB SEA94LA185Accident · No injuriesLimited investigationFinal reportCessna A152 · Bremerton, WAThe pilot's failure to maintain directional control.Jul 15, 1994 · N761UA · Substantial damage NTSB SEA94LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Easton, WAThe pilot's failure to maintain directional control. Factors include soft, uneven terrain.Jul 15, 1994 · N1540A · Substantial damage NTSB SEA94LA178Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Easton, WAImproper planning/decision by the pilot-in-command, and inadequate supervision by the check pilot, which resulted in their failure to remain clear of trees during takeoff. Factors related to the accident were: a downdraft and the proximity of trees to the…Jul 13, 1994 · N65857 · Substantial damage NTSB SEA94LA161Accident · No injuriesLimited investigationFinal reportCessna 140 · Kent, WAInadequate compensation for wind conditions. A factor to the accident was wind gust.Jul 13, 1994 · N77045 · Substantial damage NTSB SEA94LA177Accident · Serious injuriesLimited investigationFinal reportDay Teeny II · Colville, WAThe pilot's failure to maintain altitude sufficient to clear terrain. The downdraft was a factor.Jul 11, 1994 · N526AD · Substantial damage NTSB SEA94LA176Accident · No injuriesLimited investigationFinal reportBambrick Corben ACE · Arlington, WAFuel starvation due to the builders' inadequate design of the fuel system. Factors include high ambient temperatures during the climb, and a fence in the field where the forced landing took place.Jul 11, 1994 · CFKEZ · Substantial damage NTSB SEA94LA175Accident · Minor injuriesLimited investigationFinal reportPezetel M-18 Dromader · Plymouth, WAThe rudder being jammed in almost the full left position.Jul 9, 1994 · N4685R · Substantial damage NTSB SEA94FA174Accident · 3 fatalField investigationFinal reportPiper PA-22-135 · Leavenworth, WAThe pilot's inadequate preflight planning/preparation. Factors related to the accident were: high density altitude, the runway condition (with areas of soft or uneven terrain and tall grass), and obstructions (trees) near the departure end of the runway.Jul 9, 1994 · N3645A · Destroyed NTSB SEA94LA173Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ione, WAThe pilot's failure to maintain directional control. Factors include the pilot's fatigue, and trees near the side of the runway.Jul 8, 1994 · N6276M · Substantial damage NTSB SEA94FA164Accident · 1 fatalField investigationFinal reportCessna 185C · Palouse, WAThe inadvertent disorientation of the pilot after entering instrument meteorological conditions. Fog was a related factor.Jul 5, 1994 · N5833T · Substantial damage NTSB SEA94FA154Accident · 1 fatalField investigationFinal reportCessna 172 · Port Angeles, WALack of oil and connecting rod failure. A factor to the accident was rough/uneven terrain.Jun 21, 1994 · N8025B · Destroyed NTSB SEA94LA149Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy UH-12L4 · Clarkston, WADisconnection of the ballast bar aft retaining pin. Factor(s) were: tail rotor blade separation and reduced aircraft control.Jun 14, 1994 · N67264 · Substantial damage NTSB SEA94LA147Accident · No injuriesLimited investigationFinal reportHughes 369D · Snoqualmie, WAPoor in-flight planning/decision. Factors to the accident were: clearance not maintained and tailwind.Jun 10, 1994 · N1088G · Substantial damage NTSB SEA94LA134Accident · Minor injuriesLimited investigationFinal reportKopp Kitfox II · Bremerton, WAThe pilot's inadequate remedial action. Factors include the pilot's failure to maintain directional control, and unfavorable winds.Jun 1, 1994 · N56MD · Substantial damage NTSB SEA94LA143Accident · No injuriesLimited investigationFinal reportWray KR-2 · Puyallup, WAAn improperly functioning fuel boost pump.May 28, 1994 · N786RW · Substantial damage NTSB SEA94LA131Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Touchet, WAThe pilot's inadequate compensation for wind conditions. The wind gusts were a factor.May 28, 1994 · N5642X · Substantial damage NTSB SEA94LA159Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC-2 · Friday Harbor, WAThe pilot's accidental extension of his hand into the arc of the turning propeller. Factors include high winds during the docking process.May 26, 1994 · N6782L · No damage NTSB SEA94FA124Accident · 2 fatalField investigationFinal reportRyan Navion L-17B · Olympia, WAAn inflight fire for an undetermined reason.May 21, 1994 · N1669Z · Destroyed NTSB SEA94LA116Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Dayton, WATotal failure of the connecting rod.May 7, 1994 · N5646X · Substantial damage NTSB SEA94LA114Accident · No injuriesLimited investigationFinal reportCessna 150K · Chehalis, WAThe pilot's inadequate compensation for wind conditions. A factor to the accident was: crosswind.May 2, 1994 · N150S · Substantial damage NTSB SEA94LA112Accident · No injuriesLimited investigationFinal reportBeech A24R · Everett, WAFuel system pump contamination and procedures/directives were not followed.Apr 30, 1994 · N24661 · Substantial damage NTSB SEA94FA111Accident · Serious injuriesField investigationFinal reportCessna TU206G · Gold Bar, WAElectrical system short. Factors to the accident were: mountainous terrain and procedures/directives not followed.Apr 30, 1994 · N732JK · Substantial damage NTSB SEA94LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Snohomish, WAPoor in-flight planning/decision. A factor to the accident was: high vegetation.Apr 23, 1994 · N70277 · Substantial damage NTSB SEA94LA105Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Auburn, WAClearance was not maintained by an other person. A factor to the accident was: procedures/directives were inadequate.Apr 20, 1994 · N159BC · No damage NTSB SEA94IA103Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-83 · Seattle, WAThe fatigue fracture of a main gear wheel hub.Apr 18, 1994 · N931AS · Minor damage NTSB SEA94LA160Accident · No injuriesLimited investigationFinal reportNewgard Kitfox III · Yelm, WAFuel starvation due to an inadequately installed fuel line.Apr 16, 1994 · N82QU · Substantial damage NTSB SEA94LA102Accident · No injuriesLimited investigationFinal reportCessna 172L · Colville, WAThe pilot's failure to attain a proper touchdown point, and his excessive airspeed at the point of touchdown. Factors include the student pilot's lack of recent experience, and a ravine off the end of the runway.Apr 16, 1994 · N3854Q · Substantial damage NTSB SEA94LA095Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Spangle, WAThe pilot not maintaining clearance from the fence. A factor in the accident was the dusk light conditions.Apr 3, 1994 · N6746B · Substantial damage NTSB SEA94LA094Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Rimrock, WAFuel exhaustion, the pilot in command's failure to refuel the aircraft, and the inability to successfully execute an auto- rotation landing because of the low altitude.Apr 1, 1994 · N5211R · Substantial damage NTSB SEA94LA091Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Woodland, WAAirspeed was not maintained.Mar 26, 1994 · N5537E · Substantial damage NTSB SEA94FA085Accident · 2 fatalField investigationFinal reportDouglas DC-3C · Spokane, WAThe failure of the pilot-in-command to maintain airspeed. Factors to the accident were: cylinder fatigue, dark night and stall encountered.Mar 18, 1994 · N3433Y · Destroyed NTSB SEA94LA082Accident · No injuriesLimited investigationFinal reportCessna 185 · Fort Lewis, WAThe fuel shutoff valve seized in a partially open position.Mar 13, 1994 · N4732E · Substantial damage NTSB SEA94LA083Accident · No injuriesLimited investigationFinal reportCessna 172 · Seattle, WAThe student's improper flare for landing and the instructor's delayed remedial action.Mar 11, 1994 · N52807 · Substantial damage NTSB SEA94LA079Accident · Minor injuriesLimited investigationFinal reportKelley Stits SA6B · Snohomish, WAThe pilot's failure to maintain adequate airspeed. Factors include a pole off the departure end of the runway.Mar 10, 1994 · N4696 · Substantial damage NTSB SEA94LA076Accident · Minor injuriesLimited investigationFinal reportTucker Kitfox IV · Vancouver, WAAileron flight controls that were jammed by the pilot's seat slipping from its mount. Factors include inadequate seat installation by the manufacturer.Mar 8, 1994 · N1942J · Substantial damage NTSB SEA94LA072Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Walla Walla, WAUnsuitable terrain for a forced landing after a loss of power due to a failed engine cylinder. Factors include a partial magneto failure.Mar 2, 1994 · N6612Q · Substantial damage NTSB SEA94LA067Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarkston, WAThe pilot in command's inadequate use of carburetor heat. Factor(s) were: carburetor icing weather conditions and rough terrain.Feb 27, 1994 · N50765 · Substantial damage NTSB SEA94LA057Accident · Minor injuriesLimited investigationFinal reportBell 206B · Cathlamet, WALoad jettison was not performed.Feb 3, 1994 · N43823 · Substantial damage NTSB SEA94LA054Accident · No injuriesLimited investigationFinal reportFokker DR-1 · Auburn, WAThe pilot failed to maintain clearance while maneuvering near another airplane.Feb 2, 1994 · N10717 · Substantial damage NTSB SEA94FA051Accident · 1 fatalField investigationFinal reportCessna 140 · Lopez, WAThe pilot/owner's improper installation of the oil temperature sensing bulb, the total loss of all engine oil, and the shearing of a connecting rod cap.Jan 18, 1994 · N77190 · Substantial damage NTSB SEA94LA049Accident · Minor injuriesLimited investigationFinal reportGrumman American AA1B · Lacey, WAThe pilot in command's failure to attain the proper touchdown point. Factors contributing to the accident were tailwinds and wet terrain.Jan 15, 1994 · N1416R · Destroyed