NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 SEA66F0193Accident · No injuriesClosedCessna 150 · Ellensburg, WANTSB SEA66D0199Accident · No injuriesClosedCessna 150 · Mount Vernon, WANTSB SEA66D0179Accident · No injuriesClosedBeechcraft 35 · Pullman, WANTSB SEA66F0181Accident · No injuriesClosedCessna 150F · Redmond, WANTSB SEA66A0037Accident · No injuriesClosedBell 47G-2 · Auburn, WANTSB SEA66F0182Accident · Minor injuriesClosedTaylorcraft DC0-65 · Kent, WANTSB SEA66F0172Accident · No injuriesClosedCessna 182 · Pasco, WANTSB SEA66D0169Accident · No injuriesClosedCessna 140 · Wenatchee, WANTSB SEA66D0183Accident · No injuriesClosedCessna 172 · Bellingham, WANTSB SEA66A0035Accident · Minor injuriesClosedDouglas DC-3 · Hoquiam, WANTSB SEA66F0184Accident · No injuriesClosedCessna 150 · Renton, WANTSB SEA66A0032Accident · Minor injuriesClosedBell 47G-2 · 38mi E.Kelso, WANTSB SEA66D0159Accident · No injuriesClosedCessna 182 · Othello, WANTSB SEA66F0176Accident · Minor injuriesClosedAeronca 7AC · Vancouver, WANTSB SEA66I0034Incident · No injuriesClosedDouglas DC-8 · Mcchord Afb, WANTSB SEA66F0166Accident · Minor injuriesClosedPiper PA-18 · Waitsburg, WANTSB SEA66D0162Accident · No injuriesClosedCessna 140A · Seattle, WANTSB SEA66A0031Accident · No injuriesClosedHiller UH-12B · Federal Way, WANTSB SEA66F0158Accident · No injuriesClosedPiper PA-18 · White Swan, WANTSB SEA66F0163Accident · Serious injuriesClosedErco 415C · Coupeville, WANTSB SEA66F0151Accident · No injuriesClosedBeechcraft D-17S · Tacoma, WANTSB SEA66F0185Accident · Serious injuriesClosedStinson HW-75 · Port Orchard, WANTSB SEA66F0152Accident · No injuriesClosedCessna 170B · Silverdale, WANTSB SEA66F0145Accident · Serious injuriesClosedLuscombe 8A · Goldbar, WANTSB SEA66A0025Accident · 1 fatalClosedCessna 172 · Puyallup, WANTSB SEA66A0024Accident · 2 fatalClosedPiper PA-28 · Enumclaw, WANTSB SEA66F0157Accident · No injuriesClosedCessna 310C · Pasco, WANTSB SEA66D0150Accident · No injuriesClosedErcoupe 415-C · Anacortes, WANTSB SEA66F0136Accident · No injuriesClosedGreat Lakes 2T-1E · Spokane, WANTSB SEA66F0140Accident · No injuriesClosedCessna 175 · Kent, WANTSB SEA66D0139Accident · No injuriesClosedCessna 140 · Everett, WANTSB SEA66F0126Accident · No injuriesClosedCessna 337 · Spokane, WANTSB SEA66F0134Accident · Minor injuriesClosedTaylorcraft DC-65 · Hooper, WANTSB SEA66F0130Accident · Minor injuriesClosedCessna 150 · Mazama, WANTSB SEA66D0138Accident · No injuriesClosedPiper PA-22 · Port Angeles, WANTSB SEA66A0019Accident · 1 fatalClosedSmith Mini DSA-1 · Puyallup, WANTSB SEA66F0132Accident · No injuriesClosedCessna 180 · Orchards, WANTSB SEA66D0110Accident · No injuriesClosedAeronca 7CCM · Bremerton, WANTSB SEA66F0115Accident · No injuriesClosedAeronca 11AC · Bellevue, WANTSB SEA66A0016Accident · No injuriesClosedHughes 269A · Granite Flls, WANTSB SEA66D0101Accident · Minor injuriesClosedCessna 150 · Dalkena, WANTSB SEA66A0014Accident · 1 fatalClosedHelio Acft H-391B · Mead, WANTSB SEA66F0100Accident · No injuriesClosedCessna 172 · Othello, WANTSB SEA66F0090Accident · No injuriesClosedPiper PA-25 · Othello, WANTSB SEA66F0092Accident · No injuriesClosedCessna 172 · Kent, WANTSB SEA66A0010Accident · 1 fatalClosedCessna 180A · 8s Mt Vernon, WANTSB SEA66F0085Accident · Minor injuriesClosedLuscombe 8A · Deer Park, WANTSB SEA66F0086Accident · No injuriesClosedPiper PA-28 · Walla Walla, WANTSB SEA66D0074Accident · No injuriesClosedGlobe GC-1B · Seattle, WANTSB SEA66F0071Accident · No injuriesClosedPiper PA-22 · Spokane, WA