NTSB investigations, 2009, 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\") = 2009
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") = 2009 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 WPR10CA096Accident · No injuriesData collectionFinal reportStinson SR-8B · Auburn, WAThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR10LA091Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Camas, WAThe left magneto's broken p-lead, which led to the engine inadvertently starting while the pilot was turning the propeller by hand.NTSB WPR10LA090Accident · No injuriesLimited investigationFinal reportCessna 310 · Pasco, WAThe failure of the right main landing gear up-lock.NTSB WPR10CA073Accident · No injuriesData collectionFinal reportCessna 172M · Diamond Point, WAThe pilot's inadequate compensation for the variable and unfavorable wind conditions.NTSB WPR10LA069Accident · Serious injuriesLimited investigationFinal reportMahre Starduster SA300 · Zillah, WAThe pilot’s failure to maintain aircraft control during a low-altitude maneuver.NTSB WPR10FA223Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D1 · Skokomish, WAThe pilot's failure to maintain clearance from trees while flying over hilly, forested terrain.NTSB WPR10FA009Accident · 1 fatalField investigationFinal reportPiper PA-12 · Burlington, WAThe pilot's in-flight loss of control due to his failure to correctly connect the elevator control cables during the restoration/rebuild of the airplane. Contributing to this accident was the pilot's decision to perform a high-speed taxi test prior to having…NTSB WPR10CA008Accident · No injuriesData collectionFinal reportCessna 172P · Renton, WAThe failure of the student pilot to maintain directional control during the takeoff portion of a touch-and-go landing resulting in a collision with a sign.NTSB WPR09CA474Accident · No injuriesData collectionFinal reportCessna T182T · Granite Falls, WALanding in rugged terrain for undetermined reasons.NTSB WPR09CA473Accident · No injuriesData collectionFinal reportAviat A-1B · Toledo, WAThe pilot's failure to maintain clearance from a tree while taxiing. Contributing to the accident was the pilot's distracted attention.NTSB WPR09CA433Accident · No injuriesData collectionFinal reportSwalley Mark H CH 701 SP · Bremerton, WAThe pilot's inadequate compensation for the gusty wind conditions and failure to maintain aircraft control.NTSB WPR09LA423Accident · Minor injuriesLimited investigationFinal reportCessna TU206G · Ballard, WAThe pilot's precautionary water landing with partially extended landing gear. Contributing to the accident was the unidentified anomaly with the airplane's electrical system, which rendered the gear position indicator system inoperative.NTSB WPR09LA408Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Tacoma, WAThe pilot's improper landing flare in crosswind conditions resulting in a gear leg collapse.NTSB WPR09CA416Accident · No injuriesData collectionFinal reportMorgan James E Morgan RV6 · Everett, WAThe pilot’s failure to maintain clearance from objects during taxi. Contributing to the accident was the inadequate marking of the taxiway and obstacles.NTSB WPR09CA403Accident · No injuriesData collectionFinal reportRockwell 690 · Wenatchee, WAThe pilot’s failure to maintain situational awareness, and thus clearance from objects, while operating at low altitude.NTSB WPR09LA390Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Eatonville, WAThe loss of engine power due to fuel starvation as a result of the pilot's inadequate in-flight fuel management. Contributing to the accident was the airplane's lack of an interconnected fuel vent system.NTSB WPR09LA371Accident · No injuriesLimited investigationFinal reportSikorsky S-55 · Chelan, WAFailure of a seal in the hydraulic system resulting in a loss of hydraulic pressure while maneuvering at low altitude.NTSB WPR09LA364Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Washougal, WAA loss of engine power during initial climb due to a stuck exhaust valve.NTSB WPR09CA368Accident · Minor injuriesData collectionFinal reportSchweizer SGU 2-22CK · Ephrata, WAThe premature launch signal given by the wing walker.NTSB WPR09CA363Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Metaline Falls, WAThe pilot’s failure, during the landing roll, to identify the end of the runway and stop the airplane within the space available.NTSB WPR09LA372Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Walla Walla, WAA tripped landing gear motor circuit breaker, which prevented the gear from fully locking in the down position, and subsequent collapse during landing. Contributing to the accident was the disabled landing gear warning horn.NTSB WPR09LA362Accident · 1 fatalLimited investigationFinal reportMooney M20C · Elma, WAA total loss of engine power during cruise flight due to the fatigue failure of the number 4 cylinder connecting rod.NTSB WPR09LA350Accident · Minor injuriesLimited investigationFinal reportBielawa Rotorway E · Sequim, WAThe failure (disbonding) of a composite main rotor blade for undetermined reasons, leading to an immediate loss of control in flight during hover.NTSB WPR09CA349Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Snohomish, WAA complete loss of engine power due to the failure of the airplane's engine-driven fuel pump.NTSB WPR09CA342Accident · No injuriesData collectionFinal reportMid-South Custom Craft SH-2R · Sequim, WAThe total loss of engine power due to fuel starvation as a result of the pilot's failure to reposition the fuel selector to the main tank. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.NTSB WPR09CA338Accident · No injuriesData collectionFinal reportBell 206B · Burlington, WAThe pilot’s failure to maintain control of the helicopter while attempting to lift off from a trailer. The helicopter subsequently impacted the ground and rolled over.NTSB WPR09CA331Accident · Minor injuriesData collectionFinal reportBell 47G-3B-2 · Ocean Shores, WAThe pilot's failure to maintain clearance from the water while maneuvering due to the pilot's diverted attention.NTSB WPR09CA329Accident · No injuriesData collectionFinal reportNalis Glastar · Arlington, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank prior to takeoff.NTSB WPR09CA328Accident · No injuriesData collectionFinal reportBoeing A75N1 · Gig Harbor, WAThe pilot's inadequate compensation for the crosswind and failure to maintain directional control.NTSB WPR09LA318Accident · 1 fatalLimited investigationFinal reportAlexander Schleicher ASW 27-18E · Ephrata, WAThe pilot’s failure to maintain control of the glider during flight and his exceedance of the glider’s design limits during an attempted recovery from a spin.NTSB WPR09FA316Accident · 2 fatalField investigationFinal reportCessna 172M · Rimrock, WAThe pilot's failure to maintain clearance from trees during a go-around. Contributing to the accident was the pilot's lack of flight experience, and his delayed initiation of a go-around.NTSB WPR09CA310Accident · No injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot's failure to maintain adequate airspeed during landing, which resulted in an aerodynamic stall.NTSB WPR09CA306Accident · No injuriesData collectionFinal reportJenkins Jack Glastar SP · Coupeville, WAThe pilot’s improper landing flare that resulted in a hard landing on soft/grassy terrain.NTSB WPR09CA300Accident · No injuriesData collectionFinal reportNorth American/Victoria MNT LT AT-6A · Olympia, WAThe pilot's inadequate compensation for the crosswind gust and failure to maintain directional control while landing.NTSB WPR09CA294Accident · No injuriesData collectionFinal reportDornier ALPHA-JET · Arlington, WAThe pilot's failure to lower the landing gear prior to landing. Contributing to the accident were the distractions created by the pilot incorrectly setting a radio frequency and by his fixation on an airplane that was on the runway during his approach.NTSB WPR09CA291Accident · No injuriesData collectionFinal reportClarke Colin A Glastar · Wenatchee, WAThe pilot’s failure to maintain adequate airspeed, resulting in an aerodynamic stall and loss of control.NTSB WPR09CA283Accident · Minor injuriesData collectionFinal reportSmith Albert F Challenger TWO · Moses Lake, WAThe student pilot's inadequate compensation for the crosswind condition and failure to maintain lateral roll control of the airplane. Also causal was the flight instructor's failure to effectively communicate his instruction to relinquish the flight controls…NTSB WPR09CA278Accident · No injuriesData collectionFinal reportCessna 180J · Bellingham, WAThe pilot's failure to maintain directional control during landing.NTSB WPR09CA276Accident · No injuriesData collectionFinal reportCessna A185F · Wenatchee, WAThe pilot's misjudged approach and failure to attain the proper touchdown point.NTSB WPR09CA262Accident · No injuriesData collectionFinal reportCessna 210 · Seattle, WAA total loss of engine power due to fuel starvation as a result of the pilot's failure to activate the fuel boost pump when attempting an engine restart. Contributing to the accident was the pilot's failure to use a checklist.NTSB WPR09CA260Accident · No injuriesData collectionFinal reportStinson SR-8B · Tacoma, WAThe application of unintended braking input due to the pilot's failure to keep his feet correctly positioned on the rudder pedals during the landing roll.NTSB WPR09CA252Accident · No injuriesData collectionFinal reportCessna 185E · Tacoma, WAThe pilot's failure to maintain directional control while landing with a crosswind.NTSB WPR09FA246Accident · Minor injuriesField investigationFinal reportCessna 172 · Burlington, WAThe failure of the pilot of another airplane to maintain adequate visual lookout during the approach.NTSB WPR09CA232Accident · Minor injuriesData collectionFinal reportAtkins John RAF 2000 G · South Prairie, WAThe pilot's abrupt maneuver to avoid a collision that resulted in an airspeed reduction and subsequent loss of lift provided by the rotor system. Contributing to the accident was the failure of both pilots to maintain an adequate visual lookout for other…NTSB WPR09LA227Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Colfax, WAA total loss of engine power due to excessive wear in several carburetor components that led to a malfunction of the carburetor.NTSB WPR09LA223Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Puyallup, WAA loss of engine power due to fuel starvation as a result of the pilot’s failure to verify the fuel levels in the tanks, and, his failure to select the proper fuel tank.NTSB WPR09LA217Accident · Minor injuriesLimited investigationFinal reportGoodacre CA4-HP · Mansfield, WAThe pilot's failure to maintain aircraft control while landing with a known crosswind condition.NTSB WPR09LA197Accident · No injuriesLimited investigationFinal reportRaytheon A36 · Lopez Island, WAA loss of engine power during cruise flight due to oil starvation. The oil starvation event was due to the failure of maintenance personnel to tighten the aft mounting nuts for the newly installed propeller governor and the pilot’s failure to secure the oil…NTSB WPR09CA191Accident · Serious injuriesData collectionFinal reportRemos Gemini Remos · Jefferson, WAThe pilot's inadequate compensation for the gusty crosswinds conditions while approaching to land.NTSB WPR09CA186Accident · Minor injuriesData collectionFinal reportAir Creation Clipper 58 · Anacortes, WAThe partial loss of engine power due to the passenger's inadvertent movement of the engine throttle control.