NTSB investigations, 1966, 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\") = 1966
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") = 1966 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 SEA67F0232Accident · No injuriesClosedBeech A45 · Aurora, ORNTSB SEA67F0233Accident · Minor injuriesClosedNavion B · Hillsboro, ORNTSB SEA67A0045Accident · No injuriesClosedBell 47G3B1 · Yachats, ORNTSB SEA67F0231Accident · No injuriesClosedCessna 182H · Harrisburg, ORNTSB SEA68A0008Accident · 1 fatalClosedCallari S-1A · Ashland, ORNTSB SEA67F0227Accident · No injuriesClosedBeech A23 · Portland, ORNTSB SEA67D0215Accident · Serious injuriesClosedPiper PA-22 · Gibbon, ORNTSB SEA67D0226Accident · No injuriesClosedBeech 35 · Madras, ORNTSB SEA67F0197Accident · No injuriesClosedCessna 320E · Eugene, ORNTSB SEA67F0225Accident · No injuriesClosedCessna 411 · Paisley, ORNTSB SEA67D0222Accident · No injuriesClosedPiper PA-18 · Fossil, ORNTSB SEA67F0216Accident · No injuriesClosedPiper PA-32 · Sisters, ORNTSB SEA67F0224Accident · No injuriesClosedCessna 182E · Springfield, ORNTSB SEA67D0223Accident · No injuriesClosedBellanca 14-13 · Malin, ORNTSB SEA67D0196Accident · No injuriesClosedPiper PA-22 · Mulino, ORNTSB SEA67D0204Accident · No injuriesClosedBeech A23 · Klamath Fall, ORNTSB SEA67A0033Accident · No injuriesClosedHughes 269B · Frenchglen, ORNTSB SEA67D0190Accident · No injuriesClosedPiper PA-22 · Idanha, ORNTSB DCA67A0003Accident · 18 fatalClosedDouglas DC-9 · Nwemme, ORNTSB SEA67F0161Accident · No injuriesClosedPiper PA-24 · North Bend, ORNTSB SEA67F0189Accident · Serious injuriesClosedCessna T-210F · Hillsboro, ORNTSB SEA67A0030Accident · Minor injuriesClosedBensen B8-M · Albany, ORNTSB SEA67F0217Accident · No injuriesClosedCessna 170A · Chiloquin, ORNTSB SEA67A0022Accident · 4 fatalClosedBeech A35 · Mitchell, ORNTSB SEA67F0184Accident · Minor injuriesClosedCessna 150 · Springfield, ORNTSB SEA67D0181Accident · No injuriesClosedAeronca 7FC · Blachly, ORNTSB SEA67A0020Accident · No injuriesClosedHiller UH-12E · Cottage Grve, ORNTSB SEA67D0180Accident · No injuriesClosedCessna 182B · Troutdale, ORNTSB SEA67F0116Accident · Serious injuriesClosedPiper PA-22 · Redmond, ORNTSB SEA67A0019Accident · No injuriesClosedBell 47G3B1 · Medford, ORNTSB SEA67F0187Accident · No injuriesClosedCessna 150 · Eugene, ORNTSB SEA67D0172Accident · No injuriesClosedBeech S35 · Salem, ORNTSB SEA67F0115Accident · No injuriesClosedCessna 150 · Roseburg, ORNTSB SEA67D0171Accident · No injuriesClosedBeech S35 · Eugene, ORNTSB SEA67A0017Accident · 1 fatalClosedBeech G35 · Rogue River, ORNTSB SEA67F0214Accident · No injuriesClosedPiper PA-22 · Hillsboro, ORNTSB SEA67F0162Accident · No injuriesClosedPiper PA-22 · Lebanon, ORNTSB SEA67F0158Accident · No injuriesClosedCessna 310 · Hillsboro, ORNTSB SEA67D0098Accident · No injuriesClosedCessna 180 · Pendleton, ORNTSB SEA67F0157Accident · No injuriesClosedPiper PA-24 · Oregon City, ORNTSB SEA67F0112Accident · No injuriesClosedCessna 182-A · Crescent Lke, ORNTSB SEA67A0015Accident · Serious injuriesClosedDouglas A-26B · La Grande, ORNTSB SEA67A0014Accident · 3 fatalClosedCessna 320-1 · Fairview, ORNTSB SEA67F0146Accident · No injuriesClosedAeronca 7AC · North Bend, ORNTSB SEA67F0147Accident · No injuriesClosedTaylorcraft BC12-D · Tigard, ORNTSB SEA67F0105Accident · No injuriesClosedCessna 170B · Troutdale, ORNTSB SEA67D0087Accident · No injuriesClosedPiper PA-22 · Heppner, ORNTSB SEA67A0012Accident · No injuriesClosedPiper PA-28 · Mitchell, ORNTSB SEA67A0010Accident · Minor injuriesClosedHughes 269B · Eaverton, ORNTSB SEA67A0009Accident · 2 fatalClosedPiper PA-22 · Seaside, OR