Fatal NTSB investigations, 1978, OR
180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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
| 1964 | 13 |
|---|---|
| 1965 | 8 |
| 1966 | 15 |
| 1967 | 17 |
| 1968 | 17 |
| 1969 | 16 |
| 1970 | 11 |
| 1971 | 18 |
| 1972 | 18 |
| 1973 | 13 |
| 1974 | 11 |
| 1975 | 15 |
| 1976 | 16 |
| 1977 | 20 |
| 1978 | 23 |
| 1979 | 7 |
| 1980 | 11 |
| 1981 | 16 |
| 1982 | 14 |
| 1983 | 9 |
| 1984 | 13 |
| 1985 | 9 |
| 1986 | 9 |
| 1987 | 6 |
| 1988 | 4 |
| 1989 | 10 |
| 1990 | 12 |
| 1991 | 11 |
| 1992 | 8 |
| 1993 | 7 |
| 1994 | 11 |
| 1995 | 11 |
| 1996 | 8 |
| 1997 | 14 |
| 1998 | 5 |
| 1999 | 12 |
| 2000 | 7 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 11 |
| 2004 | 8 |
| 2005 | 12 |
| 2006 | 9 |
| 2007 | 9 |
| 2008 | 6 |
| 2009 | 6 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 5 |
| 2013 | 5 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 2 |
| 2019 | 12 |
| 2020 | 7 |
| 2021 | 4 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 5 |
| 2025 | 2 |
| 2026 | 6 |
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\") = 1978
AND c.\"eventStateOrRegion\" = 'OR' AND c.\"eventCountry\" = 'USA'
AND c.\"highestInjuryLevel\" = 'Fatal'
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") = 1978 AND c."eventStateOrRegion" = 'OR' AND c."eventCountry" = 'USA' AND c."highestInjuryLevel" = 'Fatal' 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 DCA79AA005Accident · 10 fatalClosedDouglas DC-8 · Portland, ORNTSB SEA79FA017Accident · 1 fatalClosedCessna 150K · Astoria, ORNTSB SEA79FA016Accident · 1 fatalClosedPiper PA-14 · Eugene, ORNTSB SEA79FA014Accident · 2 fatalClosedBellanca 17-30 · Medford, ORNTSB SEA79FA012Accident · 1 fatalClosedCessna 177B · Kimberly, ORNTSB SEA79FA011Accident · 3 fatalClosedCessna 185 · Joseph, ORNTSB SEA79FA010Accident · 3 fatalClosedPiper PA-20 · Joseph, ORNTSB SEA78FYK24Accident · 1 fatalClosedCallair B-1A · Glide, ORNTSB SEA78FA065Accident · 1 fatalClosedPiper PA-28 · Rainier, ORNTSB SEA78FA063Accident · 4 fatalClosedPiper PA-28 · Sisters, ORNTSB SEA78FYM50Accident · 1 fatalClosedMini Coupe Buffum · Independence, ORNTSB SEA78FA058Accident · 2 fatalClosedBeech C35 · Redmond, ORNTSB SEA78FA056Accident · 2 fatalClosedCessna 172XP · Eugene, ORNTSB SEA78FA055Accident · 3 fatalClosedAero Comdr 100 · Bly, ORNTSB SEA78FA039Accident · 4 fatalClosedPiper PA-28R · Baker, ORNTSB SEA78FA038Accident · 1 fatalClosedNavion A · Ashland, ORNTSB SEA78FYM39Accident · 1 fatalClosedBoeing E75N1 · John Day, ORNTSB SEA78FA025Accident · 1 fatalClosedCessna 150L · Junction City, ORNTSB SEA78FA023Accident · 4 fatalClosedPiper PA-28 · Milton Frwtr, ORNTSB SEA78FA019Accident · 4 fatalClosedBeech 35 · Cascade Locks, ORNTSB SEA78FYK07Accident · 1 fatalClosedPiper PA-25 · Christmas Vly, ORNTSB SEA78FYK06Accident · 1 fatalClosedHiller UH-12E · Reedsport, ORNTSB SEA78FA018Accident · 6 fatalClosedPiper PA-23 · Medford, OR