NTSB investigations, 1964, OR
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
| 1962 | 1 |
|---|---|
| 1964 | 74 |
| 1965 | 88 |
| 1966 | 121 |
| 1967 | 121 |
| 1968 | 84 |
| 1969 | 80 |
| 1970 | 68 |
| 1971 | 77 |
| 1972 | 75 |
| 1973 | 84 |
| 1974 | 71 |
| 1975 | 77 |
| 1976 | 81 |
| 1977 | 95 |
| 1978 | 88 |
| 1979 | 90 |
| 1980 | 76 |
| 1981 | 75 |
| 1982 | 82 |
| 1983 | 65 |
| 1984 | 70 |
| 1985 | 56 |
| 1986 | 51 |
| 1987 | 40 |
| 1988 | 41 |
| 1989 | 45 |
| 1990 | 49 |
| 1991 | 51 |
| 1992 | 48 |
| 1993 | 39 |
| 1994 | 46 |
| 1995 | 56 |
| 1996 | 60 |
| 1997 | 56 |
| 1998 | 40 |
| 1999 | 43 |
| 2000 | 56 |
| 2001 | 47 |
| 2002 | 39 |
| 2003 | 48 |
| 2004 | 40 |
| 2005 | 54 |
| 2006 | 38 |
| 2007 | 47 |
| 2008 | 40 |
| 2009 | 31 |
| 2010 | 40 |
| 2011 | 31 |
| 2012 | 35 |
| 2013 | 31 |
| 2014 | 18 |
| 2015 | 29 |
| 2016 | 23 |
| 2017 | 27 |
| 2018 | 31 |
| 2019 | 42 |
| 2020 | 23 |
| 2021 | 36 |
| 2022 | 24 |
| 2023 | 23 |
| 2024 | 30 |
| 2025 | 20 |
| 2026 | 23 |
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\" = 'OR' 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" = 'OR' 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 UNK65X1108Accident · 3 fatalClosedPiper PA-22 · Salem, ORNTSB UNK65X1084Accident · 2 fatalClosedStinson 108 · Salem, ORNTSB UNK65X1034Accident · No injuriesClosedMooney M20A · Urg, ORNTSB UNK65X0804Accident · No injuriesClosedAero Cmdr 680 · Portland, ORNTSB UNK65X0484Accident · No injuriesClosedCessna 182 · Wallowa Co, ORNTSB UNK65X0359Accident · No injuriesClosedCessna 150 · Troutdale, ORNTSB UNK65X0340Accident · No injuriesClosedPiper PA23 · Rome, ORNTSB UNK65X0271Accident · No injuriesClosedCessna 182 · Minam Lodge, ORNTSB UNK65X0151Accident · Serious injuriesClosedCessna 140 · Beaverton, ORNTSB UNK65X0103Accident · No injuriesClosedStinson 1083 · Burns, ORNTSB UNK65X0100Case · No injuriesClosedBoeing B-720 · Portland, ORNTSB UNK64X4199Accident · Serious injuriesClosedTaylorcraft BC12D · Bly, ORNTSB UNK64X4192Accident · No injuriesClosedBeechcraft 95 · Scappoose, ORNTSB UNK64X4157Accident · No injuriesClosedStinson 1082 · Hillsboro, ORNTSB UNK64X3913Accident · No injuriesClosedNavion · Bend, ORNTSB UNK64X3807Accident · 1 fatalClosedCessna 175A · Idleyld Park, ORNTSB UNK64X3583Accident · Minor injuriesClosedAeronca 7AC · Chiloquin, ORNTSB UNK64X3549Accident · 1 fatalClosedAeronca 7AC · Tillamook, ORNTSB UNK64X3474Accident · No injuriesClosedCessna 180 · Salem, ORNTSB UNK64X3320Accident · Minor injuriesClosedPiper PA22 · Drewsey, ORNTSB UNK64X3249Accident · No injuriesClosedErcoupe 415C · Burns, ORNTSB UNK64X3233Accident · No injuriesClosedPiper PA22 · Mulino, ORNTSB UNK64X3219Accident · No injuriesClosedBell 47G3B1 · Jordan Valley, ORNTSB UNK64X3216Accident · No injuriesClosedPiper PA24 · Astoria, ORNTSB UNK64X3102Accident · No injuriesClosedPiper PA30 · Hillsboro, ORNTSB UNK64X2989Accident · 2 fatalClosedPiper PA22 · Klamath Falls, ORNTSB UNK64X2884Accident · 2 fatalClosedPiper PA-28 · Vale, ORNTSB UNK64X2728Accident · No injuriesClosedBeechcraft M23 · Troutdale, ORNTSB UNK64X2612Accident · Minor injuriesClosedTaylorcraft BC12D · Gaston, ORNTSB UNK64X2504Accident · Serious injuriesClosedErcoupe 415G · Mccredie Spgs, ORNTSB UNK64X2502Accident · No injuriesClosedLuscombe 8A · Lakeside, ORNTSB UNK64X2448Accident · No injuriesClosedPiper PA22 · Bend, ORNTSB UNK64X2378Accident · No injuriesClosedPiper PA24 · Aurora, ORNTSB UNK64X2336Accident · No injuriesClosedCessna 310 · Mcnary, ORNTSB UNK64X2312Accident · No injuriesClosedCessna 210 · Klamath Falls, ORNTSB UNK64X2311Accident · 5 fatalClosedN.American F-51D · Roseburg, ORNTSB UNK64X2172Accident · No injuriesClosedPiper PA24 · Siletz, ORNTSB UNK64X2100Accident · No injuriesClosedPiper PA18 · Bonanza, ORNTSB UNK64X2065Accident · No injuriesClosedBoeing PT17 · Silvers, ORNTSB UNK64X1995Accident · No injuriesClosedPiper J3 · Sandy, ORNTSB UNK64X1982Accident · Minor injuriesClosedBoeing E75 · Waconda, ORNTSB UNK64X1961Accident · Minor injuriesClosedAeronca 7AC · Burns, ORNTSB UNK64X1958Accident · 1 fatalClosedAeronca 11AC · Madras, ORNTSB UNK64X1889Accident · 1 fatalClosedGrumman TBM-3U · Rome, ORNTSB UNK64X1865Accident · Minor injuriesClosedBell 47G-2 · Enterprise, ORNTSB UNK64X1814Accident · Serious injuriesClosedPiper PA22 · The Dalles, ORNTSB UNK64X1688Accident · No injuriesClosedPiper PA-22 · Mulino, ORNTSB UNK64X1633Accident · No injuriesClosedPiper PA30 · Mill City, ORNTSB UNK64X1554Accident · No injuriesClosedCessna 170B · Prineville, ORNTSB UNK64X1551Accident · No injuriesClosedPiper PA28 · Hillsboro, OR