NTSB investigations, 1980, 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
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\") = 1980
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") = 1980 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 SEA81DYE09Accident · No injuriesClosedBakeng Duce · Issaquah, WANTSB SEA81FYM12Accident · Serious injuriesClosedCessna 172N · Yacolt, WANTSB SEA81FA012Accident · 2 fatalClosedPiper PA-34 · Stevenson, WANTSB SEA81FYM11Accident · No injuriesClosedCessna 182P · Orchards, WANTSB SEA81FA013Accident · 1 fatalClosedCessna 210 · Royal City, WANTSB LAX81FA020Accident · 2 fatalClosedCessna 320C · Marysville, WANTSB SEA81FA009Accident · 6 fatalClosedBeech 58TC · Ellensburg, WANTSB SEA81DYP04Accident · No injuriesClosedHughes 269B · Ephrata, WANTSB SEA81IA007Incident · No injuriesClosedCessna 310G · Walla Walla, WANTSB SEA81DYE08Accident · No injuriesClosedHiller Acft UH-12E · Forks, WANTSB SEA81DYE06Accident · No injuriesClosedCessna 172 · Diamond Point, WANTSB SEA81FA004Accident · 3 fatalClosedNavion A · Yakima, WANTSB SEA81DYE07Accident · No injuriesClosedCessna 185 · Port Townsend, WANTSB SEA81DYE05Accident · No injuriesClosedCessna 180 · Forks, WANTSB SEA81FA058Accident · 4 fatalClosedCessna 172M · Quinault, WANTSB SEA81FYE04Accident · No injuriesClosedCessna 210P · Everett, WANTSB SEA81DYP02Accident · No injuriesClosedPiper PA-28R · Almira, WANTSB SEA81FYE03Accident · No injuriesClosedCessna 185 · Seattle, WANTSB SEA81DYM06Accident · No injuriesClosedBell 206L-1 · Cougar, WANTSB SEA81FYP01Accident · Serious injuriesClosedPiper PA-22 · Waterville, WANTSB SEA81DYM08Accident · No injuriesClosedCessna 140 · Vancouver, WANTSB SEA81FYE02Accident · Serious injuriesClosedChampion 8KCAB · Lester, WANTSB SEA81FYM01Accident · 1 fatalClosedWalker Mini · Trout Lake, WANTSB SEA80FYP42Accident · No injuriesClosedBensen B-8M · Quincy, WANTSB SEA80FYP40Accident · Minor injuriesClosedGulf-Schwzr G-164B · Ritzville, WANTSB SEA80DYP41Accident · No injuriesClosedPiper PA-18 · Colfax, WANTSB SEA80DYM62Accident · No injuriesClosedCessna 182P · Goldendale, WANTSB SEA80FA049Accident · 4 fatalClosedCessna 177RG · Lopez, WANTSB SEA80FYP39Accident · No injuriesClosedCessna 182B · Buena, WANTSB SEA81FYP38Accident · Serious injuriesClosedHughes 369D · Newport, WANTSB SEA80FA045Accident · 4 fatalClosedCessna 182Q · Skykomish, WANTSB SEA80FYP36Accident · No injuriesClosedPiper PA-38 · Stratford, WANTSB SEA80FYM57Accident · No injuriesClosedCessna 182C · Orchards, WANTSB SEA80FYP34Accident · No injuriesClosedBell 47G-2 · Sunnyside, WANTSB SEA80FYP33Accident · No injuriesClosedCessna T210N · Walla Walla, WANTSB SEA80FA041Accident · No injuriesClosedCessna R172K · Renton, WANTSB SEA80FYE50Accident · Minor injuriesClosedCessna 182A · Issaquah, WANTSB SEA80DYE53Accident · No injuriesClosedCessna 177B · Olympia, WANTSB SEA80DYE49Accident · No injuriesClosedAeronca 7AC · Kent, WANTSB SEA80DYE48Accident · No injuriesClosedBeech C24R · Roche Harbor, WANTSB SEA80DYE45Accident · No injuriesClosedPiper PA-28 · Forks, WANTSB SEA80DYE47Accident · 2 fatalClosedCoot B · Kelso, WANTSB SEA80FYE42Accident · Serious injuriesClosedBeech A36TC · Seattle, WANTSB SEA80FYP29Accident · No injuriesClosedCessna TU206F · Sunnyside, WANTSB SEA80FYE43Accident · Minor injuriesClosedPiper PA-28 · Gardner, WANTSB SEA80FYP28Accident · Minor injuriesClosedTexas Hel OH-13H · Moses Lake, WANTSB SEA80DYE44Accident · No injuriesClosedBeech A23 · Morton, WANTSB SEA80FA037Accident · 2 fatalClosedCessna 170A · Clinton, WANTSB SEA80FYP27Accident · Serious injuriesClosedCessna 177RG · Ione, WANTSB SEA80DYP30Accident · No injuriesClosedCessna 152 · Spokane, WA