NTSB investigations, 2014, 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\") = 2014
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") = 2014 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 WPR15CA056Accident · No injuriesData collectionFinal reportTaylorcraft BL 65 · Everett, WAThe pilot's failure to maintain directional control during the landing roll resulting in a runway excursion and collision with hangars.NTSB WPR15CA053Accident · No injuriesData collectionFinal reportStafford Wayne H Glastar · Monroe, WAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and encounter with terrain.NTSB WPR15LA023Accident · No injuriesLimited investigationFinal reportAir Tractor AT 301 · Basin City, WAMaintenance personnel’s and the airplane owner’s failure to inspect the engine for cracks in the cylinders as required by an airworthiness directive, which resulted in the loss of engine power during low-altitude maneuvering flight.NTSB WPR14FA393Accident · 1 fatalField investigationFinal reportTifft Kitfox III · Lake Stevens, WAThe pilot's failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the inability of the flight instructor to take control…NTSB WPR14CA386Accident · Minor injuriesData collectionFinal reportCessna E162 · Bellingham, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB WPR14CA383Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Rimrock, WAThe pilot's failure to maintain aircraft control during takeoff from a rough runway surface which resulted in an off-airport forced landing just beyond the runway.NTSB WPR14CA360Accident · No injuriesData collectionFinal reportNavion Navion F · Colville, WAThe pilot's loss of directional control during the landing roll.NTSB WPR14FA355Accident · 1 fatalField investigationFinal reportThomas C Sikes Loehle 5151 Mustang · Chehalis, WAThe pilot’s failure to maintain adequate airspeed during initial climb, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall/spin. Contributing to the accident was that pilot’s psychiatric disease, which…NTSB WPR14CA378Accident · No injuriesData collectionFinal reportPiper PA 18A 150 · Walla Walla, WAThe pilot's misjudged approach which resulted in overshooting the landing point and insufficient remaining landing surface.NTSB WPR14CA358Accident · No injuriesData collectionFinal reportBoeing A75N1 (PT-17) · Seattle, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing.NTSB WPR14LA340Accident · No injuriesLimited investigationFinal reportHughes 269C · Darrington, WAMaintenance personnel’s failure to secure the throttle mount bracket during a recent engine installation, which resulted in the loss of throttle movement and an inability to control engine power.NTSB WPR14FA310Accident · 1 fatalField investigationFinal reportBell 206A · Wenatchee, WAThe pilot's failure to maintain a proper decent rate and path, which resulted in a hard landing and dynamic rollover. Contributing to the accident was the pilot's impairment by a sedating medication.NTSB WPR14LA308Accident · Serious injuriesLimited investigationFinal reportMdhi 369D · Oso, WAThe pilot/mechanic’s failure to properly perform required inspections of the main rotor blades at the necessary intervals, which resulted in an in-flight separation of a main rotor blade due to disbonding and fatigue cracking. Contributing to the accident was…NTSB WPR14LA307Accident · No injuriesLimited investigationFinal reportPiper PA 46 350P · Auburn, WAA collapse of the nose landing gear for reasons that could not be determined based on the available information.NTSB WPR14CA306Accident · No injuriesData collectionFinal reportBosco Don Searey · Mount Vernon, WAThe pilot's failure to maintain lateral control while taxiing. Contributing to the accident was the incorrect decision to takeoff once the sponson had been damaged.NTSB WPR14LA298Accident · No injuriesLimited investigationFinal reportPiper PA 30 · Othello, WAThe partial loss of engine power for reasons that could not be determined based on the available information.NTSB WPR14CA290Accident · Minor injuriesData collectionFinal reportBell 47K · Kingston, WAThe pilot's failure to maintain aircraft control during the landing approach, which resulted in an excessive descent angle and settling with power.NTSB WPR14LA285Accident · Minor injuriesLimited investigationFinal reportBailey-Moyes Microlights Dragonfly B Model · Buckley, WAThe pilot’s inability to maintain airplane control due to a loss of flight control effectiveness for reasons that could not be determined during postaccident examinations.NTSB WPR14FA286Accident · 1 fatalField investigationFinal reportCessna 182 · Fall City, WAThe pilot’s decision to depart in low-ceiling conditions and his continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into terrain.NTSB WPR14LA284Accident · No injuriesLimited investigationFinal reportGlobe GC 1B · Puyallup, WAThe failure of the exhaust assembly in the No. 3 cylinder for reasons that could not be determined due to the damage incurred to the fractured parts. Also causal to the accident was maintenance personnel’s improper installation of the cylinder.NTSB WPR14CA279Accident · Serious injuriesData collectionFinal reportWiley Kitfox IV · Sprague, WAThe pilot's failure to maintain adequate clearance from powerlines during the landing approach resulting in a collision.NTSB WPR14CA287Accident · No injuriesData collectionFinal reportMooney M20TN · Yakima, WAThe pilot's failure to configure the landing gear for landing.NTSB WPR14CA270Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Quincy, WAThe pilot's failure to maintain clearance from a wind generator tower while drying cherries, which resulted in a loss of aircraft control and subsequent hard landing.NTSB WPR14CA276Accident · No injuriesData collectionFinal reportChristen Industries A 1 · Moses Lake, WAThe airplane impacted a bird during low level flight.NTSB WPR14CA261Accident · No injuriesData collectionFinal reportCessna 210A · Port Angeles, WAThe pilot's failure to maintain directional control during landing, which resulted in a ground-loop.NTSB WPR14CA254Accident · No injuriesData collectionFinal reportMaule MX 7-235 · Port Orchard, WAThe pilot's delayed remedial action and failure to maintain directional control.NTSB WPR14FA226Accident · 2 fatalField investigationFinal reportNorth American AT 6C · Buckley, WAThe loss of engine power during takeoff initial climb for reasons that could not be determined during a postaccident examination of the airplane.NTSB WPR14CA229Accident · No injuriesData collectionFinal reportAeronca 11AC · Tacoma, WAThe student pilot's improper application of rudder resulted in a loss of control during the landing roll and the flight instructor's inadequate oversight.NTSB WPR14CA223Accident · No injuriesData collectionFinal reportPiper J3C 65 · Bellingham, WAThe pilot's failure to maintain directional control during the landing on a narrow airstrip, which resulted in a collision with trees.NTSB WPR14CA219Accident · Minor injuriesData collectionFinal reportPzl-Swidnik PW 5 · Enumclaw, WAThe pilot's failure to maintain control of the glider during the landing flare which resulted in a stall and hard landing.NTSB WPR14FA209Accident · 1 fatalField investigationFinal reportKenneth A Berger Searey LSX · Electric City, WAThe pilot’s failure to maintain pitch control during takeoff after encountering a boat wake, which resulted in the airplane bouncing, impacting the water’s surface, and subsequently becoming submerged.NTSB WPR14LA206Accident · Minor injuriesLimited investigationFinal reportWilliams Helicopter UH 1H · Waitsburg, WAAn extreme vibration immediately after entering forward flight for reasons that could not be determined because postaccident examination of the helicopter did not reveal any anomalies that would have precluded normal operation. Contributing to the accident…NTSB WPR14CA212Accident · No injuriesData collectionFinal reportPiper PA 18A · Arlington, WAThe pilot's improper application of brakes during taxi in tailwind conditions, which resulted in a loss of aircraft control and subsequent nose over.NTSB WPR14CA192Accident · Minor injuriesData collectionFinal reportCessna 120 · Colville, WAThe pilot's failure to maintain directional control during the landing roll.NTSB WPR14LA179Accident · No injuriesLimited investigationFinal reportCoulter Hugh Clarke Pulsar XP Series I · Bremerton, WAFatigue failure of the nose landing gear retention and pivot shaft, which resulted in the in-flight separation of the nose gear wheel and tire assembly.NTSB WPR14CA163Accident · No injuriesData collectionFinal reportCessna 172S · Everett, WAThe pilot's failure to maintain directional control during a takeoff, which resulted in the airplane veering off the runway surface and colliding with a sign.NTSB WPR14CA162Accident · No injuriesData collectionFinal reportCessna 207 · Shaw Island, WAThe pilot's loss of directional control during the landing flare with a gusting tailwind.NTSB WPR14CA155Accident · No injuriesData collectionFinal reportCessna 172M · Anacortes, WAThe pilot's improper application of brakes during the landing roll resulted in a runway excursion and nose over.NTSB WPR14CA150Accident · No injuriesData collectionFinal reportJust Highlander · Yakima, WAThe student pilot's inadequate compensation for the gusting crosswind conditions and the certified flight instructor's inadequate supervision, resulting in a loss of directional control during the landing roll.NTSB WPR14FA137Accident · 2 fatalField investigationFinal reportEurocopter AS 350 B2 · Seattle, WAThe loss of helicopter control due to a loss of hydraulic boost to the tail rotor pedal controls at takeoff, followed by a loss of hydraulic boost to the main rotor controls after takeoff. The reason for the loss of hydraulic boost to the main and tail rotor…NTSB WPR14CA136Accident · No injuriesData collectionFinal reportNorman Quad City Challenger · Monroe, WAThe pilot's inadequate construction of the propeller bracket, which resulted in its failure during the initial climb and the propeller subsequently departing the airplane.NTSB WPR14CA125Accident · No injuriesData collectionFinal reportCessna 172K · Eastsound, WAThe pilot's inadequate flare and failure to maintain aircraft control during landing in gusty wind conditions.NTSB WPR14LA112Accident · No injuriesLimited investigationFinal reportWeinzierl Searey · Stanwood, WAThe noncertificated pilot’s failure to maintain clearance from water while maneuvering at a low altitude over glassy water conditions, which adversely affected his depth perception.NTSB WPR14LA104Accident · No injuriesLimited investigationFinal reportSimpson Amphibeous Trike/No · Chehalis, WAThe failure of the left wing prong.NTSB WPR14CA103Accident · No injuriesData collectionFinal reportWaco Classic YMF F5C · Renton, WAThe pilot's failure to maintain directional control of the airplane during landing.NTSB WPR14LA100Accident · 1 fatalLimited investigationFinal reportErcoupe 415 C · Poulsbo, WAThe pilot's failure to confirm that the engine oil filler cap was secured before flight, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.NTSB WPR14CA086Accident · Minor injuriesData collectionFinal reportDehavilland Beaver DHC 2 MK.1 · Shaw Island, WAThe pilot's failure to maintain directional control during takeoff in variable wind conditions, resulting in a collision with trees lining the left side of the runway.