NTSB investigations, 1981, ID
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 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\") = 1981
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") = 1981 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 SEA82DYA04Accident · No injuriesClosedPiper PA-28 · Majic Rsrvoir, IDNTSB SEA82FA005Accident · 3 fatalClosedCessna 421C · Shoshone, IDNTSB SEA82DYA03Accident · No injuriesClosedPiper PA-32 · Rexburg, IDNTSB SEA82FYP05Accident · No injuriesClosedCessna 172F · Orofino, IDNTSB SEA82FA002Accident · 1 fatalClosedCessna 175B · Springfield, IDNTSB SEA82DYP02Accident · No injuriesClosedMaule M-5 · Priest River, IDNTSB SEA82DYA02Accident · Minor injuriesClosedLuscombe 8F · Howe, IDNTSB SEA82FYA01Accident · Serious injuriesClosedChampion 7ECA · Ola, IDNTSB SEA81FYP41Accident · No injuriesClosedCessna 170B · Athol, IDNTSB SEA81DYA25Accident · Serious injuriesClosedAerospatle SA315B · Driggs, IDNTSB SEA81DYA26Accident · No injuriesClosedCessna 172F · Arco, IDNTSB SEA81DYA27Accident · No injuriesClosedAerospatle SA316B · Driggs, IDNTSB SEA81FA053Accident · 3 fatalClosedSoloy UH-12E · Riggins, IDNTSB SEA81DYA24Accident · No injuriesClosedGrumman G-164 · Rigby, IDNTSB SEA81FYA23Accident · No injuriesClosedPiper PA-25 · Caldwell, IDNTSB SEA81DYA22Accident · Serious injuriesClosedCessna 150M · Driggs, IDNTSB SEA81FYA21Accident · No injuriesClosedPiper PA-25 · Middleton, IDNTSB SEA81DYP32Accident · Minor injuriesClosedPiper PA-28 · Warren, IDNTSB SEA81DYA19Accident · No injuriesClosedCessna 180J · Yellow Pine, IDNTSB SEA81FYP29Accident · No injuriesClosedCessna 177 · Priest River, IDNTSB SEA81FA047Incident · No injuriesClosedPiper PA-34 · Boise, IDNTSB SEA81DYA20Accident · No injuriesClosedCessna 180A · Challis, IDNTSB SEA81DYA16Accident · No injuriesClosedPiper PA-18A · Firth, IDNTSB SEA81DYA15Accident · No injuriesClosedPiper PA-25 · Shelley, IDNTSB SEA81IA045Incident · No injuriesClosedPiper PA-31 · Hailey, IDNTSB SEA81FA044Accident · 3 fatalClosedCessna 182Q · Burley, IDNTSB SEA81DYA13Accident · No injuriesClosedCessna 188A · Richfield, IDNTSB SEA81FA042Accident · 3 fatalClosedPiper PA-28 · Bliss, IDNTSB SEA81DYA14Accident · No injuriesClosedPiper PA-32R · Stanley, IDNTSB SEA81DYA12Accident · Serious injuriesClosedPiper PA-25 · Rockford, IDNTSB SEA81DYA11Accident · No injuriesClosedGrumman G-164 · Monteview, IDNTSB SEA81FA039Accident · 1 fatalClosedMaule M5235C · Dixie, IDNTSB SEA81DYP20Accident · No injuriesClosedPiper PA-28 · Lucille, IDNTSB SEA81FA038Accident · 3 fatalClosedPiper PA-28 · Malad City, IDNTSB SEA81FYP18Accident · 1 fatalClosedGrumman G-164B · Harrison, IDNTSB SEA81DYA09Accident · No injuriesClosedCessna 188 · Idaho Falls, IDNTSB SEA81FYP08Accident · No injuriesClosedCessna 172G · Lewiston, IDNTSB SEA81FYA07Accident · 1 fatalClosedPitts S-1S · Boise, IDNTSB SEA81DYA08Accident · No injuriesClosedBellanca 7GCBC · Hailey, IDNTSB SEA81FA014Accident · 4 fatalClosedBeech V35A · Rexburg, ID