NTSB investigations, 1966, AK
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
| 1962 | 9 |
|---|---|
| 1963 | 11 |
| 1964 | 171 |
| 1965 | 158 |
| 1966 | 174 |
| 1967 | 167 |
| 1968 | 173 |
| 1969 | 201 |
| 1970 | 211 |
| 1971 | 214 |
| 1972 | 195 |
| 1973 | 211 |
| 1974 | 224 |
| 1975 | 249 |
| 1976 | 296 |
| 1977 | 251 |
| 1978 | 265 |
| 1979 | 228 |
| 1980 | 239 |
| 1981 | 227 |
| 1982 | 199 |
| 1983 | 211 |
| 1984 | 216 |
| 1985 | 203 |
| 1986 | 186 |
| 1987 | 189 |
| 1988 | 179 |
| 1989 | 193 |
| 1990 | 193 |
| 1991 | 176 |
| 1992 | 192 |
| 1993 | 191 |
| 1994 | 138 |
| 1995 | 173 |
| 1996 | 161 |
| 1997 | 157 |
| 1998 | 172 |
| 1999 | 159 |
| 2000 | 140 |
| 2001 | 131 |
| 2002 | 139 |
| 2003 | 120 |
| 2004 | 107 |
| 2005 | 129 |
| 2006 | 96 |
| 2007 | 105 |
| 2008 | 108 |
| 2009 | 101 |
| 2010 | 91 |
| 2011 | 104 |
| 2012 | 112 |
| 2013 | 94 |
| 2014 | 79 |
| 2015 | 77 |
| 2016 | 97 |
| 2017 | 75 |
| 2018 | 93 |
| 2019 | 87 |
| 2020 | 80 |
| 2021 | 92 |
| 2022 | 84 |
| 2023 | 75 |
| 2024 | 80 |
| 2025 | 86 |
| 2026 | 63 |
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\") = 1966
AND c.\"eventStateOrRegion\" = 'AK' 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") = 1966 AND c."eventStateOrRegion" = 'AK' 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 ANC67A0050Accident · Minor injuriesClosedBell 47G-2A · Kenai, AKNTSB ANC67A0049Accident · No injuriesClosedCessna 180 · Bethel, AKNTSB ANC67F0094Accident · No injuriesClosedCessna U206A · Kenai, AKNTSB ANC67D0078Accident · No injuriesClosedCessna 170B · Cordova, AKNTSB ANC67A0048Accident · Minor injuriesClosedPiper PA-14 · Homer, AKNTSB ANC67D0068Accident · No injuriesClosedPiper PA-28 · Fairbanks, AKNTSB ANC67I0047Incident · No injuriesClosedDouglas DC-3A · Nome, AKNTSB ANC67D0074Accident · No injuriesClosedPiper PA-18A · Aniak, AKNTSB ANC67A0046Accident · No injuriesClosedCessna 180 · Anchorage, AKNTSB ANC67D0065Accident · No injuriesClosedMaule MA4210 · Anchorage, AKNTSB ANC67D0093Accident · No injuriesClosedLuscombe 8A · Seldovia, AKNTSB ANC67D0064Accident · No injuriesClosedStinson 108-1 · King Salmon, AKNTSB ANC67D0077Accident · No injuriesClosedCessna 180 · Seward, AKNTSB ANC67A0045Accident · 1 fatalClosedPiper PA-18 · Yakutat, AKNTSB ANC67D0061Accident · No injuriesClosedPiper PA-18 · Clear, AKNTSB ANC67A0044Accident · No injuriesClosedCessna 180 · Seldovia, AKNTSB ANC67A0043Accident · No injuriesClosedDouglas A-26 · Homer, AKNTSB ANC67A0041Accident · No injuriesClosedPilatus PC6BH2 · Kotzebue, AKNTSB ANC67A0042Accident · No injuriesClosedBrantly B-2 · Scotty Creek, AKNTSB ANC67A0040Accident · 2 fatalClosedPiper PA-18 · Tyonek, AKNTSB ANC67D0059Accident · No injuriesClosedPiper PA-18 · Aleknagik, AKNTSB ANC67D0069Accident · No injuriesClosedCessna 172G · Kenai, AKNTSB ANC67A0039Accident · No injuriesClosedCessna U206 · Seldovia, AKNTSB ANC67A0037Accident · 1 fatalClosedBell 47G-2 · Anchorage, AKNTSB ANC67F0056Accident · No injuriesClosedCessna 180 · Homer, AKNTSB ANC67D0076Accident · No injuriesClosedAeronca 15AC · Afognak, AKNTSB ANC67A0038Accident · No injuriesClosedBell 47G-4A · Kenai, AKNTSB ANC67A0035Accident · No injuriesClosedSikorsky S-55B · Clear, AKNTSB ANC67A0034Accident · No injuriesClosedCessna 180 · Nome, AKNTSB ANC67A0033Accident · Serious injuriesClosedBell 47J-2A · Anchorage, AKNTSB ANC67F0060Accident · No injuriesClosedPiper PA-18 · Juneau, AKNTSB ANC67A0031Accident · Minor injuriesClosedCessna 185 · Napakiak, AKNTSB ANC67A0032Accident · 5 fatalClosedHoward DGA-15 · Afognak, AKNTSB ANC67F0067Accident · No injuriesClosedPiper PA-12 · Anchorage, AKNTSB ANC67A0029Accident · 1 fatalClosedPiper PA-18S · Ugashik, AKNTSB ANC67D0034Accident · No injuriesClosedPiper PA-22 · Fairbanks, AKNTSB ANC67D0035Accident · No injuriesClosedCessna 180 · Fairbanks, AKNTSB ANC67A0028Accident · 2 fatalClosedPiper PA-18 · Fairbanks, AKNTSB ANC67F0073Accident · No injuriesClosedAeronca 15AC · Tok, AKNTSB ANC67A0027Accident · 2 fatalClosedTaylorcraft BC12 · Naknek, AKNTSB ANC67D0081Accident · No injuriesClosedCessna 150F · Paxson, AKNTSB ANC67D0045Accident · No injuriesClosedPiper PA-18 · Big Delta, AKNTSB ANC67D0033Accident · No injuriesClosedPiper PA-14 · Nenana, AKNTSB ANC67F0072Accident · Serious injuriesClosedPiper PA-18 · Northway, AKNTSB ANC67D0058Accident · No injuriesClosedPiper PA-18A · Egegik, AKNTSB ANC67D0055Accident · No injuriesClosedAeronca 7GCBC · Iliamna, AKNTSB ANC67F0051Accident · No injuriesClosedCessna 180C · Anchorage, AKNTSB ANC67D0052Accident · No injuriesClosedTaylorcraft BC12-D · Palmer, AKNTSB ANC67F0030Accident · Serious injuriesClosedPiper PA-22 · Yakutat, AKNTSB ANC67D0063Accident · No injuriesClosedGrumman G-21 · Alegnagik, AK