NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 SEA81DYK02Accident · Minor injuriesClosedHughes 369 · Powers, ORNTSB SEA81FA010Accident · 1 fatalClosedAero Comdr 685 · Ashland, ORNTSB SEA81DYM10Accident · Serious injuriesClosedStinson L-5 · Philomath, ORNTSB SEA81DYK03Accident · No injuriesClosedPiper PA-34 · Sutherlin, ORNTSB SEA81DYK01Accident · No injuriesClosedPiper PA-32R · Adel, ORNTSB SEA81FYM09Accident · Minor injuriesClosedBell 47G-3 · Buell, ORNTSB SEA81FA002Accident · 1 fatalClosedCessna 182Q · Ashland, ORNTSB SEA81DYM05Accident · No injuriesClosedMooney M20A · Sandy, ORNTSB SEA81DYM04Accident · No injuriesClosedPiper PA-18 · Hillsboro, ORNTSB SEA81DYM03Accident · No injuriesClosedPiper PA-28R · Nehalem, ORNTSB SEA81DYM02Accident · No injuriesClosedPiper PA-28 · Molalla, ORNTSB SEA80FYM63Accident · No injuriesClosedCessna 182A · Harrisburg, ORNTSB SEA80FYK18Accident · Serious injuriesClosedBell 47J-2A · Brookings, ORNTSB SEA80FA046Accident · 1 fatalClosedCessna 172N · Pendleton, ORNTSB SEA80FYM60Accident · 1 fatalClosedBLN Works FF-6B · Shedd, ORNTSB SEA80DYM58Accident · No injuriesClosedCessna 172 · Molalla, ORNTSB SEA80DYK17Accident · Minor injuriesClosedCessna 150 · Redmond, ORNTSB SEA81FYM61Accident · No injuriesClosedGrum Amer AA-5A · Newburg, ORNTSB SEA81FYM07Accident · No injuriesClosedHughes 269C · Pilot Rock, ORNTSB SEA80FYK15Accident · No injuriesClosedPiper PA-28R · Sixes, ORNTSB SEA80DYK14Accident · No injuriesClosedCessna 210 · French Glen, ORNTSB SEA80DYM55Accident · No injuriesClosedHiller Acft UH-12E · Tillamook, ORNTSB SEA80DYM53Accident · No injuriesClosedAero Comdr 100 · Prineville, ORNTSB SEA80DYK16Accident · No injuriesClosedCessna 188 · Medford, ORNTSB SEA80FYM54Accident · Serious injuriesClosedPiper PA-28 · Portland, ORNTSB SEA80FYK13Accident · Minor injuriesClosedCessna 421 · Redmond, ORNTSB SEA80FA040Accident · 4 fatalClosedAerofab LA-4-2 · Cascade Locks, ORNTSB SEA80FYK12Accident · Serious injuriesClosedCessna 182A · Roseburg, ORNTSB SEA80FYK11Accident · No injuriesClosedCessna 140 · Creswell, ORNTSB SEA80DYM51Accident · No injuriesClosedCessna 150L · Tigard, ORNTSB SEA80DYM56Accident · No injuriesClosedCessna 210B · Lagrande, ORNTSB SEA80FYM50Accident · Minor injuriesClosedPiper PA-22 · Dallas, ORNTSB SEA80DYM47Accident · Serious injuriesClosedCessna 152 · Milton-Freewtr, ORNTSB SEA80DYM46Accident · No injuriesClosedPiper PA-28 · Brooks, ORNTSB SEA80DYM49Accident · No injuriesClosedHenkes RV-3 · Canby, ORNTSB SEA80DYK09Accident · No injuriesClosedMaule M-5 · Klamath Falls, ORNTSB SEA80FYM44Accident · No injuriesClosedPiper J3C-85 · Hood River, ORNTSB SEA80DYM45Accident · No injuriesClosedPiper PA-18 · Hermiston, ORNTSB SEA80DYM43Accident · No injuriesClosedPiper PA-36 · The Dalles, ORNTSB SEA80FYK10Accident · Serious injuriesClosedPrue Super STD · Brothers, ORNTSB SEA80FA036Accident · 4 fatalClosedPiper PA32RT · Granite, ORNTSB SEA80DYM48Accident · No injuriesClosedCessna 150J · Long Creek, ORNTSB SEA80FYM41Accident · No injuriesClosedHiller Acft UH-12E · Gales Creek, ORNTSB SEA80DYM42Accident · No injuriesClosedCessna 182 · Madras, ORNTSB SEA80FA032Accident · 1 fatalClosedPiper PA-28 · Woodburn, ORNTSB SEA80FA044Accident · 2 fatalClosedPiper PA-28 · Portland, ORNTSB SEA80FYM40Accident · Minor injuriesClosedHiller Acft FH1100 · Albany, ORNTSB SEA80FA031Accident · 1 fatalClosedCessna 210L · Harrisburg, ORNTSB SEA80DYM38Accident · No injuriesClosedCessna 150 · Sevenson, ORNTSB SEA80DYM37Accident · No injuriesClosedPiper PA-28 · Yamhill, OR