NTSB investigations, 2021, 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.
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\") = 2021
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") = 2021 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 WPR22LA047Accident · No injuriesClass 3 · LimitedFinal reportCessna R182 · Puyallup, WAAn overstress fracture of the left main landing gear pivot assembly, which resulted in the failure of the left main landing gear to fully extend and lock into place.NTSB WPR22FA023Accident · 1 fatalClass 3 · FieldFinal reportMooney M20M · Snoqualmie, WAThe pilot’s decision to fly the airplane into known icing conditions, which resulted in a loss of airplane control and collision with terrain.NTSB WPR22LA013Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Laurier, WAThe flight instructor’s delayed remedial action to prevent the airplane from landing long which, resulted in a runway overrun and collision with terrain.NTSB WPR22LA017Accident · No injuriesClass 4 · LimitedFinal reportCessna 177 · White Swan, WAA total loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.NTSB WPR21LA351Accident · No injuriesClass 4 · LimitedFinal reportGeorge A. Thiel Just Aircraft Highlander · Monroe, WAThe in-flight malfunction of the throttle control pivot arm, which resulted in a total loss of engine power and the subsequent collision with terrain during the forced landing.NTSB WPR21LA363Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32-300 · Orcas Island, WAThe total loss of engine power due to the pilot’s mismanagement of the fuel system which resulted in fuel starvation.NTSB WPR21LA346Accident · Serious injuriesClass 4 · LimitedFinal reportGordon Scot A RV-6A · Palouse, WAThe pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB WPR21LA339Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · Arlington, WAThe fatigue fracture of the tailwheel fitting spring, which resulted in the loss of directional control during the landing roll.NTSB WPR21LA336Accident · Serious injuriesClass 4 · LimitedFinal reportRagwing S1 · Arlington, WAThe pilot’s loss of directional control during landing.NTSB DCA21LA229Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 767-332 · Seattle, WAThe flightcrew’s failure to set the hydraulic panel correctly during the execution of the pushback checklist, and when the hydraulic panel setting was corrected, that resulted in the airplane coming to a sudden stop and a flight attendant receiving a serious…NTSB WPR21LA332Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Wenatchee, WAThe student pilot’s inadequate inflight navigation and the flight instructors delayed remedial action which resulted in a collision with trees.NTSB DCA21LA208Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-990ER · SeaTac, WAThe passenger’s use of the evacuation slide resulted in the serious injury.NTSB WPR21LA318Accident · No injuriesClass 3 · LimitedFinal reportNorth American T-28B · Puyallup, WAA nose wheel shimmy during the landing roll for reasons that could not be determined from the available evidence, which led to a loss of directional control.NTSB WPR21LA307Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170A · Metaline Falls, WAThe pilot’s failure to attain sufficient altitude during the initial climb to clear trees due to an encounter with windshear.NTSB WPR21LA309Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Morton, WAThe pilot's improper landing flare which resulted in a hard landing and subsequent nosewheel collapse.NTSB WPR21LA297Accident · No injuriesClass 4 · LimitedFinal reportKevin P Stolhammer KR 1 · Electric City, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR21LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Chelan, WAThe pilot’s unstable approach to land in turbulent conditions, which resulted in a hard landing short of the runway and subsequent loss of directional control and collision with terrain.NTSB WPR21LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Renton, WAThe boat operator’s failure to remain a safe distance from the floatplane during the takeoff run, which resulted in a collision.NTSB WPR21LA367Accident · No injuriesClass 4 · LimitedFinal reportQuest Kodiak 100 · Roche Harbor, WAThe pilot’s failure to maintain bank control during the landing roll which resulted in the right wing impacting the water’s surface.NTSB WPR21LA251Accident · Serious injuriesClass 4 · LimitedFinal reportStinson 108-3 · Stevenson, WAA runway incursion, which resulted in a go-around, and subsequent forced landing when the airplane was not able to climb at a rate sufficient to clear approaching rising terrain.NTSB WPR21LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-25-235 · Twisp, WAAn in-flight separation of the control stick from the torque tube assembly, which resulted in a loss of directional control during the landing roll and subsequent on-ground collision.NTSB WPR21LA235Accident · Minor injuriesClass 4 · LimitedFinal reportHPH Glasflugel · Winthrop, WAThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight.NTSB WPR21LA303Accident · No injuriesClass 3 · LimitedFinal reportCessna 172S · Yelm, WAA total loss of engine power for reasons that could not be determined based on the available evidence.NTSB WPR21LA213Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Cashmere, WAA total loss of engine power shortly after takeoff for reasons that could not be determined based on the available information.NTSB WPR21LA189Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Arlington, WAThe pilot’s failure to maintain directional control during landing, with a crosswind, which resulted in a runway excursion and subsequent impact with terrain.NTSB WPR21LA182Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 175B · Royal City, WAThe pilot’s failure to maintain airplane control during a landing with a tailwind which resulted in excessive ground speed, runway over run and subsequent nose over.NTSB WPR21LA172Accident · No injuriesClass 4 · LimitedFinal reportMichael J Robbins Searey · Friday Harbor, WAPartial loss of engine power due to the detachment of the throttle cable from the carburetor arm, as a result of the pilot’s inadequate maintenance which resulted in an off-airport landing and impact with vegetation.NTSB WPR21FA170Accident · 1 fatalClass 3 · FieldFinal reportConsolidated Vultee BT-13A · Camas, WAThe pilot’s exceedance of the airplane’s critical angle of attack during an aborted landing, resulting in an aerodynamic stall and impact with terrain.NTSB WPR21LA161Accident · 2 fatalClass 3 · LimitedFinal reportRans S12 · Colville, WAThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering to avoid powerlines, which resulted in an aerodynamic stall and a loss of control. Contributing to the accident was the partial loss of engine power due to improper…NTSB WPR21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA22 · Pullman, WAThe pilot's failure to maintain directional control during taxiing in crosswind conditions, which resulted in the airplane nosing over.NTSB WPR21LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Bellingham, WAThe student pilot’s inadequate flare resulting in a loss of control during landing with a crosswind and subsequent nose over.NTSB WPR21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 182H · Blakely Island, WAA total loss of engine power during climb for reasons that could not be determined which resulted in a forced water landing.NTSB WPR21LA151Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Yacolt, WAA partial loss of power caused by carbon build up in the cylinders, which prevented the exhaust valves from seating properly. Contributing to the accident was flying in moderate icing conditions which resulted in reduced aircraft performance and vibrations.NTSB WPR21LA149Accident · No injuriesClass 4 · LimitedFinal reportLuscombe 8A · Port Townsend, WAThe pilot’s inadequate engine hand propping procedure which resulted in the airplane’s unexpected movement and subsequent impact with a fueling station.NTSB WPR21LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Everett, WAA total loss of engine power during climb, for reasons that could not be determined based on available evidence.NTSB WPR21LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Eastsound, WAThe pilot’s failure to maintain directional control during the landing roll with a tailwind, which resulted in a landing gear collapse and collision with terrain.NTSB WPR21LA120Accident · No injuriesClass 4 · LimitedFinal reportPiggott John H Bearhawk · Eatonville, WAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB WPR21LA097Accident · 1 fatalClass 3 · LimitedFinal reportCessna 170A · Port Angeles, WAThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate in-flight fuel planning.NTSB WPR21LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Kelso, WAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a runway excursion and subsequent nose over.NTSB WPR21LA084Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Winthrop, WAThe pilot’s failure to adequately monitor the environment which resulted in a collision with a snowbank and subsequent loss of control.NTSB WPR21LA083Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170B · Palouse, WAThe student pilot’s improper landing flare and loss of directional control and the flight instructor’s delayed remedial action resulted in a runway excursion and nose over.