NTSB investigations, 1976, ID
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1976
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") = 1976 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 SEA77DYP15Accident · No injuriesClosedCessna 170B · Lewiston, IDNTSB SEA77FYA08Accident · No injuriesClosedPiper PA-28R · Glenns Ferry, IDNTSB SEA77FA008Accident · 1 fatalClosedPiper PA-28R · Sandpoint, IDNTSB SEA77FYA06Accident · Minor injuriesClosedCessna 150L · Mountain Home, IDNTSB SEA77DYA05Accident · Minor injuriesClosedCessna 150 · Blackfoot, IDNTSB SEA77DYA07Accident · No injuriesClosedCessna T210K · Challis, IDNTSB SEA77FYA04Accident · Serious injuriesClosedSchweizer SGU222 · Boise, IDNTSB SEA77DYA03Accident · Minor injuriesClosedLake LA-4 · Boise, IDNTSB SEA77DYG01Accident · No injuriesClosedCessna 182D · Cottonwood, IDNTSB SEA77DYA02Accident · Minor injuriesClosedPiper PA-22 · Malta, IDNTSB SEA77DYA01Accident · No injuriesClosedStinson 108 · Soda Springs, IDNTSB SEA77FYG04Accident · Serious injuriesClosedCessna 172 · Grangeville, IDNTSB SEA76DYG67Accident · No injuriesClosedHiller Acft UH-12E · Clark Fork, IDNTSB SEA76DYA48Accident · No injuriesClosedHiller Acft UH-12E · Jerome, IDNTSB SEA76AS075Accident · 1 fatalClosedPiper PA-28 · Mountain Home, IDNTSB SEA76FYA46Accident · 4 fatalClosedPiper PA-22 · American Falls, IDNTSB SEA76AS072Accident · 1 fatalClosedPiper PA-23 · Blackfoot, IDNTSB SEA76AS073Accident · 1 fatalClosedCessna TU206E · Salmon, IDNTSB SEA76DYA44Accident · No injuriesClosedAero Comdr 600S2R · Rexburg, IDNTSB SEA76FYG70Accident · 1 fatalClosedCessna 188 · Lewiston, IDNTSB SEA76DYA45Accident · No injuriesClosedCallair B1A · Newdale, IDNTSB SEA76AS063Accident · 4 fatalClosedBeech H35 · Mccall, IDNTSB SEA76FYA42Accident · Minor injuriesClosedPiper PA-25 · Parma, IDNTSB SEA76DYA41Accident · No injuriesClosedPiper PA-25 · Fruitland, IDNTSB SEA76DYA40Accident · Minor injuriesClosedPiper PA-25 · Hamer, IDNTSB SEA76FYG71Accident · No injuriesClosedCessna 310Q · Coolin, IDNTSB SEA76DYA39Accident · No injuriesClosedHughes 269A · Gooding, IDNTSB SEA76DYA36Accident · No injuriesClosedBell 47G3B2 · Gooding, IDNTSB SEA76FYA35Accident · 1 fatalClosedAero Comdr A-9 · Nampa, IDNTSB SEA76DYA34Accident · No injuriesClosedCessna A188B · Grays Lake, IDNTSB SEA76DYA33Accident · Minor injuriesClosedCallair A-9 · Grandview, IDNTSB SEA76AS059Accident · 5 fatalClosedGrum Amer AA-5A · Boise, IDNTSB SEA76DYG59Accident · Minor injuriesClosedPiper PA-12 · Worley, IDNTSB SEA76DYA31Accident · No injuriesClosedPiper PA-24 · Burley, IDNTSB SEA76FYG62Accident · No injuriesClosedCessna 188B · Lewiston, IDNTSB SEA76DYA32Accident · Minor injuriesClosedPiper PA-25 · Georgetown, IDNTSB SEA76FYA29Accident · Serious injuriesClosedLaister LK-10B · Howe, IDNTSB SEA76FYA28Accident · Serious injuriesClosedTaylorcraft BC12-D · Mountain Home, IDNTSB SEA76DYG69Accident · No injuriesClosedHiller Acft UH-12E · Nezperce, IDNTSB SEA76DYA27Accident · No injuriesClosedPiper PA-20 · Council, IDNTSB SEA76DYA26Accident · No injuriesClosedHiller Acft UH-12E · Rupert, IDNTSB SEA76DYA30Accident · No injuriesClosedBeech D95A · Rexburg, IDNTSB SEA76DYA25Accident · No injuriesClosedGrumman G-164A · Hamer, IDNTSB SEA76DYG35Accident · No injuriesClosedBoeing B75N1 · Nezperce, IDNTSB SEA76AS051Accident · 4 fatalClosedStinson 108-1 · Burley, IDNTSB SEA76AS049Accident · 2 fatalClosedCessna 172K · Weiser, IDNTSB SEA76FYA24Accident · No injuriesClosedBell 47G3B1 · Burley, IDNTSB SEA76FYG48Accident · Serious injuriesClosedEnstrom F-28A · White Bird, IDNTSB SEA76DYG47Accident · Minor injuriesClosedHiller Acft UH-12E · Worley, IDNTSB SEA76DYG43Accident · No injuriesClosedGrumman G-164A · Genesee, ID