NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1183Accident · Serious injuriesClosedPiper PA-28 · North Bend, WANTSB UNK65X1036Accident · No injuriesClosedPiper J3 · Birch Bay, WANTSB UNK65X0907Accident · No injuriesClosedCessna 310 · Everett, WANTSB UNK65X0881Accident · 4 fatalClosedBeechcraft S35 · Tacoma, WANTSB UNK65X0866Accident · Minor injuriesClosedCessna 195 · Morris Lake, WANTSB UNK65X0818Accident · No injuriesClosedCessna 172 · Mesa, WANTSB UNK65X0777Accident · Minor injuriesClosedN American F51D · Enumclaw, WANTSB UNK65X0580Accident · No injuriesClosedCessna 172 · Ellensburg, WANTSB UNK65X0474Accident · Minor injuriesClosedCessna 150 · Medical Lake, WANTSB UNK65X0423Accident · No injuriesClosedPiper PA28 · Spokane, WANTSB UNK65X0398Accident · No injuriesClosedCessna 170B · Mesa, WANTSB UNK65X0367Accident · No injuriesClosedBeech F35 · Ocean Shores, WANTSB UNK65X0348Accident · No injuriesClosedPiper PA30 · Everett, WANTSB UNK65X0328Accident · Minor injuriesClosedSchweizer 222E · Issaquah, WANTSB UNK65X0211Accident · No injuriesClosedCessna 140A · Wheeler, WANTSB UNK65X0186Accident · No injuriesClosedCessna 140 · Camas, WANTSB UNK65X0181Accident · No injuriesClosedPiper PA20 · Yakima, WANTSB UNK65X0143Accident · No injuriesClosedLuscombe 8E · Selah, WANTSB UNK65X0132Accident · 2 fatalClosedPiper PA-18 · Waterville, WANTSB UNK64X4197Accident · Minor injuriesClosedPiper PA22 · Lynden, WANTSB UNK64X4170Accident · No injuriesClosedBeechcraft D35 · Puyallup, WANTSB UNK64X4155Accident · No injuriesClosedRyan STA · Whidbey Is, WANTSB UNK64X4083Accident · No injuriesClosedBeechcraft C35 · Kelso, WANTSB UNK64X4065Accident · No injuriesClosedPiper J5 · Oak Harbor, WANTSB UNK64X4064Accident · No injuriesClosedPiper PA28 · Chehalis, WANTSB UNK64X4005Accident · No injuriesClosedNavy N3N · Chelan Falls, WANTSB UNK64X4002Accident · Minor injuriesClosedBeechcraft M23 · Tacoma, WANTSB SEA65A0025Accident · 2 fatalClosedBeechcraft 35 · Granite Fals, WANTSB UNK64X3940Accident · Minor injuriesClosedPiper J2 · Mt Wash, WANTSB UNK64X3920Accident · No injuriesClosedPiper PA12 · Inchelium, WANTSB UNK64X3897Accident · Minor injuriesClosedCessna 172 · Snohomish, WANTSB UNK64X3791Accident · No injuriesClosedPiper PA18A · Tonasket, WANTSB UNK64X3784Accident · No injuriesClosedCessna 120 · Vancouver, WANTSB UNK64X3780Accident · No injuriesClosedBell 47G2 · Manson, WANTSB UNK64X3758Accident · 1 fatalClosedBoeing A75 · Quincy, WANTSB UNK64X3694Accident · 1 fatalClosedBeechcraft B-35 · Keyport, WANTSB UNK64X3693Accident · No injuriesClosedHughes 269A · Redondo, WANTSB UNK64X3679Accident · 1 fatalClosedCessna 150 · Renton, WANTSB UNK64X3600Accident · No injuriesClosedCessna 182 · Seattle, WANTSB UNK64X3572Accident · No injuriesClosedCessna 140 · Tacoma, WANTSB UNK64X3560Accident · No injuriesClosedPiper PA24 · Stuart Is, WANTSB UNK64X3477Accident · No injuriesClosedCessna 172 · Kelso, WANTSB UNK64X3408Accident · Serious injuriesClosedCallair A6 · Sunnyside, WANTSB UNK64X3357Accident · Minor injuriesClosedGrumman G164 · Touchet, WANTSB UNK64X3334Accident · No injuriesClosedBeechcraft M35 · Tekoa, WANTSB UNK64X3330Accident · No injuriesClosedRepublic RC3 · Seattle, WANTSB UNK64X3325Incident · No injuriesClosedBell B-47G2 · Monitor, WANTSB UNK64X3204Accident · 1 fatalClosedMooney M20 · La Touche, WANTSB UNK64X3176Accident · No injuriesClosedBeechcraft D35 · Lind, WANTSB UNK64X3038Accident · Minor injuriesClosedAeronca 15AC · Spokane, WA