NTSB investigations, 1965, ID
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
| 1964 | 70 |
|---|---|
| 1965 | 49 |
| 1966 | 62 |
| 1967 | 64 |
| 1968 | 65 |
| 1969 | 47 |
| 1970 | 54 |
| 1971 | 57 |
| 1972 | 41 |
| 1973 | 48 |
| 1974 | 63 |
| 1975 | 56 |
| 1976 | 63 |
| 1977 | 48 |
| 1978 | 43 |
| 1979 | 56 |
| 1980 | 44 |
| 1981 | 40 |
| 1982 | 47 |
| 1983 | 41 |
| 1984 | 41 |
| 1985 | 46 |
| 1986 | 50 |
| 1987 | 25 |
| 1988 | 29 |
| 1989 | 22 |
| 1990 | 30 |
| 1991 | 30 |
| 1992 | 37 |
| 1993 | 26 |
| 1994 | 39 |
| 1995 | 35 |
| 1996 | 33 |
| 1997 | 31 |
| 1998 | 41 |
| 1999 | 46 |
| 2000 | 34 |
| 2001 | 24 |
| 2002 | 48 |
| 2003 | 52 |
| 2004 | 40 |
| 2005 | 38 |
| 2006 | 30 |
| 2007 | 40 |
| 2008 | 34 |
| 2009 | 37 |
| 2010 | 37 |
| 2011 | 33 |
| 2012 | 40 |
| 2013 | 32 |
| 2014 | 30 |
| 2015 | 27 |
| 2016 | 22 |
| 2017 | 31 |
| 2018 | 28 |
| 2019 | 33 |
| 2020 | 24 |
| 2021 | 39 |
| 2022 | 27 |
| 2023 | 29 |
| 2024 | 35 |
| 2025 | 22 |
| 2026 | 19 |
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\" = 'ID' 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" = 'ID' 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 SEA66D0201Accident · No injuriesClosedMooney M20B · Featherville, IDNTSB SEA66F0175Accident · Minor injuriesClosedPiper PA-24 · Idaho Falls, IDNTSB SEA66A0033Accident · 2 fatalClosedNavion A · Lowman, IDNTSB SEA66A0029Accident · 1 fatalClosedTaylorcraft BC12-D · Blackfoot, IDNTSB SEA66F0155Accident · Serious injuriesClosedPiper PA18A · Homedale, IDNTSB SEA66D0170Accident · No injuriesClosedPiper J-3 · Carey, IDNTSB SEA66F0156Accident · Minor injuriesClosedBriegleb BG-7 · Rexburg, IDNTSB SEA66A0026Accident · 2 fatalClosedStinson V-77 · Boise, IDNTSB SEA66F0128Accident · No injuriesClosedCessna 180 · Nampa, IDNTSB SEA66D0137Accident · No injuriesClosedMooney M20E · Twin Falls, IDNTSB SEA66D0127Accident · No injuriesClosedLuscombe 8A · Priest River, IDNTSB SEA66D0119Accident · No injuriesClosedBird CK · Notus, IDNTSB SEA66D0131Accident · No injuriesClosedStinson 108-2 · Bonner Ferry, IDNTSB SEA66F0102Accident · Minor injuriesClosedPitts Psig · Idaho Falls, IDNTSB SEA66F0135Accident · No injuriesClosedBeechcraft K35 · Cottonwood, IDNTSB SEA66F0091Accident · Serious injuriesClosedPiper PA28 · Blackfoot, IDNTSB SEA66F0072Accident · No injuriesClosedPiper PA-22 · Nampa, IDNTSB SEA66F0069Accident · No injuriesClosedBeechcraft S-35 · Hailey, IDNTSB SEA66F0068Accident · Minor injuriesClosedBeechcraft J-35 · Pocatello, IDNTSB SEA66D0059Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDNTSB SEA66A0005Accident · 1 fatalClosedBeech 35 · 4w Malta, IDNTSB SEA66F0049Accident · No injuriesClosedPiper PA-24 · Boise, IDNTSB SEA66F0022Accident · No injuriesClosedPiper PA-18A · Idaho Falls, IDNTSB SEA66F0020Accident · Minor injuriesClosedPiper PA-18A · Burley, IDNTSB SEA66D0043Accident · No injuriesClosedCessna 206 · Sellway, IDNTSB SEA66D0027Accident · No injuriesClosedCessna 180 · Burley, IDNTSB SEA66F0048Accident · Minor injuriesClosedBoeing A75 · Homedale, IDNTSB SEA66F0019Accident · No injuriesClosedPiper PA-18A · Rockford, IDNTSB SEA66A0003Accident · 2 fatalClosedBeech C-45H · Salmon, IDNTSB SEA66F0096Accident · No injuriesClosedPiper PA-18A · Copeland, IDNTSB SEA66D0017Accident · No injuriesClosedCessna 180 · Cascade, IDNTSB SEA66F0057Accident · No injuriesClosedFairchild M62C · Homedale, IDNTSB SEA66F0067Accident · No injuriesClosedPiper PA-18A · Paul, IDNTSB SEA65F0072Accident · No injuriesClosedCessna 182 · Boise, IDNTSB SEA65F0067Accident · No injuriesClosedBoeing B75N1 · Reubens, IDNTSB SEA66F0047Accident · No injuriesClosedBeechcraft 35 · Caldwell, IDNTSB SEA65F0061Accident · Serious injuriesClosedCessna 172 · Lewiston, IDNTSB SEA65F0069Accident · No injuriesClosedBeechcraft 35 · Blackfoot, IDNTSB SEA65D0052Accident · No injuriesClosedCessna 182A · Weiser, IDNTSB SEA65F0041Accident · No injuriesClosedNo American SNJ-5 · Caldwell, IDNTSB SEA65F0045Accident · Serious injuriesClosedPiper J-3 · Meadows, IDNTSB SEA65F0023Accident · No injuriesClosedBeech K35 · Boise, IDNTSB SEA65D0034Accident · No injuriesClosedMooney M18C · Idaho Falls, IDNTSB SEA65D0040Accident · No injuriesClosedCessna 310 · Soda Springs, IDNTSB SEA65F0018Accident · No injuriesClosedCallair A-9 · Genesee, IDNTSB SEA65D0017Accident · 1 fatalClosedCessna 170B · Glenns Ferry, IDNTSB SEA65F0056Accident · No injuriesClosedCessna 182 · Twin Falls, IDNTSB SEA65D0024Accident · No injuriesClosedPiper PA-18A · Bancroft, IDNTSB SEA65D0011Accident · No injuriesClosedPiper PA24 · Challis, ID