NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 SEA81FA011Accident · 2 fatalClosedPiper PA-12 · Rexburg, IDNTSB SEA81FYA06Accident · Serious injuriesClosedCessna 150F · Caldwell, IDNTSB SEA81FA008Accident · 6 fatalClosedBeech A60 · Driggs, IDNTSB SEA81FA006Accident · No injuriesClosedPiper PA32RT · Oakley, IDNTSB SEA81FA005Accident · 2 fatalClosedCessna U206F · Bonners Ferry, IDNTSB SEA81DYA05Accident · No injuriesClosedCessna 182P · Blackfoot, IDNTSB SEA81FYA04Accident · Serious injuriesClosedCessna 182A · Blackfoot, IDNTSB SEA81DYA03Accident · No injuriesClosedBellanca 7KCAB · Council, IDNTSB SEA81FA003Accident · 1 fatalClosedCessna 172 · Craigmont, IDNTSB SEA81FYP03Accident · Minor injuriesClosedCessna TU206G · Salmon, IDNTSB SEA81DYA02Accident · No injuriesClosedPiper PA-28 · Blackfoot, IDNTSB SEA81IA001Incident · No injuriesClosedPiper PA-28 · Elk City, IDNTSB SEA81DYA01Accident · No injuriesClosedCessna 182 · Picabo, IDNTSB SEA80FYA25Accident · Serious injuriesClosedBreezy RLU-1F · Jerome, IDNTSB SEA80FYP37Accident · Serious injuriesClosedGrum-Amer AA-1B · Coeur D'Alene, IDNTSB SEA80DYA23Accident · No injuriesClosedBeech C24R · Soda Springs, IDNTSB SEA80DYP35Accident · No injuriesClosedCessna 180 · Coeur D'Alene, IDNTSB SEA80DYP32Accident · No injuriesClosedAeronca 7FC · Grangeville, IDNTSB SEA80FA043Accident · 2 fatalClosedPiper J4E · Mountain Home, IDNTSB SEA80FA042Accident · 2 fatalClosedCessna T207 · Salmon, IDNTSB SEA80DYA21Accident · No injuriesClosedCessna 150 · Horseshoe Bend, IDNTSB SEA80FA039Accident · 1 fatalClosedAero Comdr 500B · Salmon, IDNTSB SEA80DYA24Accident · No injuriesClosedPiper J3C-65 · Blackfoot, IDNTSB SEA80DYP31Accident · No injuriesClosedCessna 182 · Elk City, IDNTSB SEA80DYA20Accident · No injuriesClosedWeatherly 201B · Mountain Home, IDNTSB SEA80FYA19Accident · 1 fatalClosedCallair A-9 · Homedale, IDNTSB SEA80DYA18Accident · Minor injuriesClosedCessna 172 · Donnelly, IDNTSB SEA80DYA17Accident · Minor injuriesClosedCessna 182 · Mccall, IDNTSB SEA80DYP25Accident · Minor injuriesClosedCessna R172K · Mullen, IDNTSB SEA80FA035Accident · 3 fatalClosedPiper PA-28 · Couer D'Alene, IDNTSB SEA80DYA16Accident · Minor injuriesClosedCessna T188C · Fairfield, IDNTSB SEA80FYA15Accident · Minor injuriesClosedBell 206A · Boise, IDNTSB SEA80FYA14Accident · No injuriesClosedPiper PA-25 · Burley, IDNTSB SEA80DYA13Accident · Minor injuriesClosedCessna T188C · American Falls, IDNTSB SEA80FA025Accident · 3 fatalClosedDouglas DC-3C · Athol, IDNTSB SEA80FA024Accident · 1 fatalClosedCessna T210L · Pocatello, IDNTSB SEA80DYP16Accident · Minor injuriesClosedCessna 172 · Orofino, IDNTSB SEA80FYA11Accident · Serious injuriesClosedCassutt 3M · Boise, IDNTSB SEA80DYA10Accident · No injuriesClosedCessna 185D · Challis, IDNTSB SEA80DYA09Accident · No injuriesClosedCessna 152 · Blackfoot, IDNTSB SEA80DYA08Accident · No injuriesClosedCessna 170B · Mccall, IDNTSB SEA80DYP12Accident · No injuriesClosedPiper PA-38 · Sandpoint, IDNTSB SEA80FYA06Accident · Serious injuriesClosedCessna 210E · Burley, IDNTSB SEA80FA016Accident · 4 fatalClosedCessna 182Q · Murphy, ID