Fatal NTSB investigations, 2001, WA
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1964 | 20 |
|---|---|
| 1965 | 13 |
| 1966 | 15 |
| 1967 | 13 |
| 1968 | 25 |
| 1969 | 20 |
| 1970 | 25 |
| 1971 | 17 |
| 1972 | 19 |
| 1973 | 16 |
| 1974 | 26 |
| 1975 | 23 |
| 1976 | 17 |
| 1977 | 30 |
| 1978 | 30 |
| 1979 | 22 |
| 1980 | 20 |
| 1981 | 23 |
| 1982 | 13 |
| 1983 | 24 |
| 1984 | 12 |
| 1985 | 21 |
| 1986 | 21 |
| 1987 | 13 |
| 1988 | 13 |
| 1989 | 18 |
| 1990 | 18 |
| 1991 | 18 |
| 1992 | 20 |
| 1993 | 10 |
| 1994 | 11 |
| 1995 | 17 |
| 1996 | 13 |
| 1997 | 10 |
| 1998 | 14 |
| 1999 | 12 |
| 2000 | 5 |
| 2001 | 10 |
| 2002 | 5 |
| 2003 | 12 |
| 2004 | 16 |
| 2005 | 8 |
| 2006 | 9 |
| 2007 | 12 |
| 2008 | 12 |
| 2009 | 5 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 5 |
| 2013 | 1 |
| 2014 | 8 |
| 2015 | 9 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 8 |
| 2019 | 8 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 6 |
| 2023 | 4 |
| 2024 | 7 |
| 2025 | 5 |
| 2026 | 4 |
Where
Latest 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\") = 2001
AND c.\"eventStateOrRegion\" = 'WA' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 2001 AND c."eventStateOrRegion" = 'WA' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 SEA02LA012Accident · 1 fatalLimited investigationFinal reportThurston Pitts S-1S · Eatonville, WAThe pilot's unsuccessful corrective action (recovery) from an inverted spin. A contributing factor was the pilot's encounter with the inverted spin maneuver.NTSB SEA02FA002Accident · 3 fatalField investigationFinal reportCessna 172N · Decatur Island, WAThe pilot's failure to maintain airspeed during a low altitude turn, resulting in a stall. The pilot exceeding the aircraft's maximum gross takeoff weight was a factor.NTSB SEA01LA158Accident · 1 fatalLimited investigationFinal reportMatey Hawker Hurricane · Buckley, WAA loss of power for undetermined reasons, and the pilot's inflight decision to attempt a 180 degree turn back to the runway from low altitude and his failure to maintain sufficient flying airspeed during the turn. A contributing factor was drug impairment of…NTSB SEA01FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Puyallup, WAThe pilot's failure to maintain adequate airspeed during departure resulting in a stall. Trees were a factor in the accident.NTSB SEA01LA116Accident · 2 fatalLimited investigationFinal reportYakovlev YAK 52 · Custer, WAThe first pilot's failure to maintain aircraft control while maneuvering. Factors include an inadvertent stall.NTSB SEA01LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-18-105 Special · Wilbur, WAA collision with terrain for undetermined reasons.NTSB SEA01FA089Accident · 2 fatalField investigationFinal reportRobinson R44 · Gorst, WAAn abrupt application of the tail rotor/anti-torque pedal by an unknown pilot resulting in tail rotor contact with the tail boom. Tail rotor blades and empennage assembly separation, and trees were factors.NTSB SEA01FA070Accident · 2 fatalField investigationFinal reportCessna 182P · Fairfield, WAThe pilot's failure to maintain altitude and/or clearance over trees, resulting in a collision with trees, separation of a wing and uncontrolled collision with terrain. Factors included the pilot's inadequate preflight planning and preparation, dark night…NTSB SEA01FA064Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Greenwater, WAFailure to maintain clearance from mountainous terrain.NTSB SEA01FA060Accident · 1 fatalField investigationFinal reportCessna U206G · Mica, WAThe pilot's continued flight into instrument meteorological conditions. Contributing factors were fog, low ceilings, drizzle/mist, rising terrain, and the non-availability of a functioning transponder.