NTSB investigations, 1973, 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\") = 1973
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") = 1973 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 SEA74DYG22Accident · No injuriesClosedPiper PA-28 · Richland, WANTSB SEA74AS028Accident · 2 fatalClosedCessna 182P · Kelso, WANTSB SEA74DYE32Accident · No injuriesClosedHiller UH-12E · Queets, WANTSB SEA74AS027Accident · 1 fatalClosedPiper PA-31 · Walla Walla, WANTSB SEA74AS026Accident · No injuriesClosedCessna 182 · Anacortes, WANTSB SEA74FYE31Accident · Serious injuriesClosedCessna 337A · Maynard, WANTSB SEA74DYE30Accident · No injuriesClosedCessna 182 · Tacoma, WANTSB SEA74IS025Incident · No injuriesClosedBoeing 720A · Moses Lake, WANTSB SEA74DYE29Accident · No injuriesClosedCessna 180H · Tillacum, WANTSB SEA74AYE28Accident · Serious injuriesClosedBeech A23-19 · Everett, WANTSB SEA74AS024Accident · 2 fatalClosedCessna 210 · Quilcene, WANTSB SEA74DYE27Accident · No injuriesClosedCessna 172 · Morton, WANTSB SEA74AS023Accident · 2 fatalClosedPiper PA-28 · Wenatchee, WANTSB SEA74DYE26Accident · No injuriesClosedHiller Acft FH1100 · Centralia, WANTSB SEA74DYE25Accident · No injuriesClosedBell 47G-3B · Forks, WANTSB SEA74DYG18Accident · No injuriesClosedCessna 180H · Othello, WANTSB SEA74FYE23Accident · No injuriesClosedSikorsky S-58E · Alpental, WANTSB SEA74IS020Incident · Minor injuriesClosedDouglas DC-8 · Spokane, WANTSB SEA74DYE22Accident · No injuriesClosedPiper PA-24 · Renton, WANTSB SEA74DYE21Accident · Minor injuriesClosedPiper PA-28 · Bellevue, WANTSB SEA74DYE24Accident · No injuriesClosedLuscombe 8A · Auburn, WANTSB SEA74DYG19Accident · No injuriesClosedCessna 182H · Wenatchee, WANTSB SEA74AS019Accident · 1 fatalClosedPiper PA-28R · Tenino, WANTSB SEA74DYE20Accident · No injuriesClosedBell 47F-2 · Forks, WANTSB SEA74DYG20Accident · No injuriesClosedMooney M20E · Prosser, WANTSB SEA74AYC20Accident · Serious injuriesClosedSorrell SNS-6 · Dallesport, WANTSB SEA74DYE19Accident · No injuriesClosedHughes 269A · Forks, WANTSB SEA74DYE18Accident · No injuriesClosedPiper PA-18 · Arlington, WANTSB SEA74AS017Accident · 2 fatalClosedPiper PA-20 · Oakesdale, WANTSB SEA74FYE15Accident · Serious injuriesClosedCessna 150L · Federal Way, WANTSB SEA74DYE17Accident · No injuriesClosedHughes 269C · Eagle Lake, WANTSB SEA74FYG17Accident · No injuriesClosedPitts S-1C · Spokane, WANTSB SEA74DYE12Accident · No injuriesClosedHughes 269A · Eatonville, WANTSB SEA74DYE11Accident · No injuriesClosedCessna 140A · Tacoma, WANTSB SEA74FYG14Accident · Minor injuriesClosedCessna 150F · La Crosse, WANTSB SEA74DYE10Accident · No injuriesClosedHughes 269B · Puyallup, WANTSB SEA74DYE09Accident · No injuriesClosedBell 205-A1 · Lester, WANTSB SEA74FYG16Accident · No injuriesClosedPiper PA-28 · Colville, WANTSB SEA74AS013Accident · 2 fatalClosedCessna 172 · Packwood, WANTSB SEA74FYG13Accident · Serious injuriesClosedHughes 369HS · Packwood, WANTSB SEA74AS009Accident · 4 fatalClosedPiper PA-28 · Eatonville, WANTSB SEA74DYE14Accident · No injuriesClosedCessna 150 · Federal Way, WANTSB SEA74DVG12Accident · No injuriesClosedCessna 210C · Spokane, WANTSB SEA74FYG08Accident · Serious injuriesClosedBell 47J-2A · Inchelium, WANTSB SEA74FYC08Accident · Minor injuriesClosedCessna 150 · Vancouver, WANTSB SEA74DYG10Accident · No injuriesClosedBell 47G3B2 · Tonasket, WANTSB SEA74FYE08Accident · Minor injuriesClosedCessna 172 · Kent, WANTSB SEA74DYG05Accident · No injuriesClosedCessna 150 · Pullman, WANTSB SEA74DYG06Accident · No injuriesClosedSchemp SHK-1 · Ephrata, WANTSB SEA74DYC03Accident · Minor injuriesClosedChampion 7SC · Moro, WA