NTSB investigations, 1990, WA
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.
Cases per year
| 1963 | 1 |
|---|---|
| 1964 | 110 |
| 1965 | 131 |
| 1966 | 140 |
| 1967 | 159 |
| 1968 | 125 |
| 1969 | 116 |
| 1970 | 118 |
| 1971 | 86 |
| 1972 | 107 |
| 1973 | 104 |
| 1974 | 109 |
| 1975 | 129 |
| 1976 | 117 |
| 1977 | 104 |
| 1978 | 118 |
| 1979 | 118 |
| 1980 | 107 |
| 1981 | 102 |
| 1982 | 95 |
| 1983 | 101 |
| 1984 | 89 |
| 1985 | 73 |
| 1986 | 100 |
| 1987 | 79 |
| 1988 | 80 |
| 1989 | 76 |
| 1990 | 78 |
| 1991 | 94 |
| 1992 | 79 |
| 1993 | 69 |
| 1994 | 67 |
| 1995 | 73 |
| 1996 | 65 |
| 1997 | 62 |
| 1998 | 67 |
| 1999 | 68 |
| 2000 | 67 |
| 2001 | 66 |
| 2002 | 66 |
| 2003 | 74 |
| 2004 | 75 |
| 2005 | 59 |
| 2006 | 49 |
| 2007 | 53 |
| 2008 | 58 |
| 2009 | 58 |
| 2010 | 51 |
| 2011 | 58 |
| 2012 | 54 |
| 2013 | 37 |
| 2014 | 47 |
| 2015 | 36 |
| 2016 | 32 |
| 2017 | 39 |
| 2018 | 47 |
| 2019 | 37 |
| 2020 | 28 |
| 2021 | 41 |
| 2022 | 35 |
| 2023 | 36 |
| 2024 | 29 |
| 2025 | 37 |
| 2026 | 29 |
Where
Open the mapLatest cases
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 year(c.\"eventDate\") = 1990
AND 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 year(c."eventDate") = 1990 AND 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 SEA91LA035Accident · No injuriesLimited investigationFinal reportCessna 182-E · Anacortes, WAThe poor inflight decision by the PIC to land on a short grass airstrip in strong gusty tailwind conditions.NTSB SEA91LA034Accident · 1 fatalLimited investigationFinal reportBeech D50C · Snohomish, WAThe obstruction (protruding door support bracket) in the doorway of the aircraft; failure of the company/operator personnel, the pilot, and the skydivers to assure that the doorway was clear of obstructions; and subsequent snagging of the d-ring, which…NTSB SEA91LA030Accident · 1 fatalLimited investigationFinal reportRobinson Wenoso · Olympia, WAThe inadvertant stall/spin and loss of aircraft control by the pilot in command while performing aerobatic maneuvers.NTSB SEA91LA032Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Seattle, WAThe pilot's failure to maintain airspeed while on an instrument approach under instrument meteorlogical conditions, resulting in the aircraft stalling and enter a spin.NTSB SEA91FA027Accident · 5 fatalField investigationFinal reportAero Commander 690A · Ryderwood, WAThe pilot's improper inflight planning and failure to maintain proper altitude in mountainous terrain at night.NTSB SEA91FA025Accident · Serious injuriesField investigationFinal reportPiper PA31 · Enumclaw, WAFuel exhaustion due to inadequate preflight planning and preparations, and poor inflight planning and decisions. The pilot elected to fly into known adverse weather conditions, and did not calculate fuel consumption for the planned flight.NTSB SEA91LA022Accident · No injuriesLimited investigationFinal reportBeech 65-88 · Spokane, WAThe pilot's misjudgement of his touchdown due to disorientation caused by his lack of forward visibility created by an accumulation of ice on the windshield.NTSB SEA91LA018Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Bremerton, WAThe pilot did not maintain altitude.NTSB SEA91FA019Accident · 1 fatalField investigationFinal reportCessna 206 · Pullman, WAThe pilot displayed inadequate inflight planning and decision making. Factors to the accident were: the weather was obscured, the dark night condition, and a proper altitude not maintained.NTSB SEA91LA015Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1C · Port Townsend, WAThe pilot's failure to use carburetor heat which resulted in a loss of engine power and a forced landing.NTSB SEA91LA013Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Trout Lake, WAThe pilot's failure to maintain clearance from an obstacle.NTSB SEA91LA011Accident · No injuriesLimited investigationFinal reportCessna 172G · Anacortes, WAThe pilot poorly compensated for the wind condition.NTSB SEA91LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Pullman, WAThe student pilot's failure to maintain directional control.NTSB SEA91IA003Incident · No injuriesIncident investigationFinal reportCessna 551 · Elma, WAInadequate inspection of the electrical wire bundle assembly by maintenance personnel, and chafing/burning of the wire bundle.NTSB SEA91LA002Accident · No injuriesLimited investigationFinal reportBeech 58 · Seattle, WAThe pilot did not flare the airplane on landing. Factors related to the accident were: the pilot did not adequately recover from a bounced landing and the nose gear assembly failed in overload.NTSB SEA91LA001Accident · Serious injuriesLimited investigationFinal reportCessna T210K · Everett, WAA loss of engine power for undetermined reasons.NTSB SEA90LA199Accident · 2 fatalLimited investigationFinal reportCessna 172N · Neilton, WAThe failure of the crew to maintain adequate clearance from the terrain. Factors to the accident were mountainous and box canyon terrain.NTSB SEA90LA195Accident · No injuriesLimited investigationFinal reportPiper PA18-150 · Enumclaw, WAThe pilot did not maintain directional control of the airplane during the landing roll in gusting wind condition.NTSB SEA90LA189Accident · No injuriesLimited investigationFinal reportCessna TR182 · Everett, WAPilot did not maintained an adequate airspeed during the initial climb. The pilot failed to maintain directional control.NTSB SEA90GA180Accident · 1 fatalFinal reportBell 204B · Keller, WAThe total loss of engine power due to turbine blade separation while the pilot was operating in the aircraft at a gross weight that exceeded performance specifications for existing meteorological conditions. Factors include the failure or inability to…NTSB SEA90LA179Accident · No injuriesLimited investigationFinal reportCessna 182P · Lummi Island, WAThe pilot's failure to maintain directional control while applying brakes after landing.NTSB SEA90LA173Accident · No injuriesLimited investigationFinal reportCessna 172P · Granite Falls, WAThe pilot in command's use of excessive flaps for takeoff resulting in loss of climb performance.NTSB SEA90FA167Accident · 2 fatalField investigationFinal reportCessna 150-L · Newman Lake, WAThe pilot's poor judgement in attempting to land at an unlighted airstrip at night and his failure to maintain clearance from terrain during a go around.NTSB SEA90LA162Accident · 1 fatalLimited investigationFinal reportVaden SA102 Cavalier · Tumwater, WAThe pilot's failure to maintain airspeed during takeoff following an engine loss of power. The reason for the loss of power was not determined.NTSB SEA90LA160Accident · No injuriesLimited investigationFinal reportAlfred Stevens KEN Rand KR-2 · Ellensburg, WAThe pilot did not maintain a proper altitude above the terrain or visual lookout which resulted in a collision with a transmission wire.NTSB SEA90LA159Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Wenatchee, WAImproper installation of the oil filter gasket by maintenance personnel resulting in loss of engine oil and seizure of the engine.NTSB SEA90LA157Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Ellensburg, WAThe pilot did not adequately level off the helicopter and collided with the terrain.NTSB SEA90FA158Accident · Serious injuriesField investigationFinal reportAerospatiale SA315B · Cougar, WALoss of power due to contamination in the engine speed governor.NTSB SEA90LA155Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC-65 · Chehalis, WAThe pilot's inadequate compensation for wind conditions. The gusty crosswind ws a related factor.NTSB SEA90TL#07Accident · Minor injuriesClass 3Final reportBoeing Vertol 107-11 · Leavenworth, WANTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…NTSB SEA90LA140Accident · No injuriesLimited investigationFinal reportRockwell S2R · Royal City, WAThe pilot's failure to ensure an adequate supply of fuel, which resulted in fuel exhaustion.NTSB SEA90LA138Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Darrington, WAThe inflight encounter with turbulent downdraft winds that resulted in a vertical descent from which the pilot could not recover with full power applied.NTSB SEA90LA136Accident · No injuriesLimited investigationFinal reportNorth American P-51 · Seattle, WAAn encounter with vortex turbulence while on final approach to landing.NTSB SEA90LA135Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Toutle, WAThe pilot's improper planning/decision by operating and maneuvering the heliocpter in a regime where he could not maintain rotor RPM. The high density altitude and rough terrain were related factors.NTSB SEA90LA132Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bellingham, WACollision with a submerged object.NTSB SEA90LA131Accident · No injuriesLimited investigationFinal reportCessna TU206G · Roche Harbor, WAThe pilot's failure to maintain directional control after encountering unstable atmospheric conditions during final approach to landing.NTSB SEA90LA127Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Renton, WALoss of engine power due to fuel starvation. The cause of the accident was the pilot displayed poor inflight planning by not adequately following procedures or directives associated with fuel consumption.NTSB SEA90LA126Accident · Minor injuriesLimited investigationFinal reportHardesty/Hays Quickie Q2 · Twisp, WAThe pilot's failure to maintain directional control during the landing roll. Factors related to the accident were: the high weeds on the sides of the grass/dirt strip and the dirt berm.NTSB SEA90FA125Accident · Serious injuriesField investigationFinal reportCessna T210K · Everett, WAInadequate preflight by the pilot by not assuring that the rudder pedals were properly engaged. A factor related to the accident was: the pilot's lack of familiarity with this make and model of aircraft.NTSB SEA90LA124Accident · No injuriesLimited investigationFinal reportPiper J-2 · Concrete, WAThe pilot's improper planning/decisions and failure to maintain clearance from the trees.NTSB SEA90LA121Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Walla Walla, WAA loss of engine power for undetermined reasons.NTSB SEA90FA122Accident · 5 fatalField investigationFinal reportCessna T210L · Ashford, WAThe pilot's continuation of VFR flight into instrument meteorological conditions.NTSB SEA90FA115Accident · 1 fatalField investigationFinal reportAerospatiale AS350B · Glacier, WAPassenger did not follow the procedures associated with the operations in the vicinity of the helicopter.NTSB SEA90LA112Accident · No injuriesLimited investigationFinal reportCessna 177 · Hitchcock, WAThe pilot's loss of control of the airplane during final approach for landing. Sunglare was a factor related to the accident.NTSB SEA90LA108Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Dayton, WALoss of engine power for an undetermined reason.NTSB SEA90LA107Accident · No injuriesLimited investigationFinal reportRobert C. Campbell Quickie · Arlington, WAThe pilot did not maintain directional control of the airplane.NTSB SEA90LA104Accident · No injuriesLimited investigationFinal reportAerofab Lake LA-250 · Spokane, WAThe pilot was taxiing the airplane at an excessive speed which resulted in a loss of directional control.NTSB SEA90TL#03Accident · No injuriesClass 3Final reportBell UH-1B · Yakima, WANTSB SEA90LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Randle, WAThe pilot failed to compensate for the wind conditions.