NTSB investigations, 1969, 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\") = 1969
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") = 1969 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 ANC70A0051Accident · Minor injuriesClosedCessna 180 · Cordova, AKNTSB ANC70A0050Accident · Minor injuriesClosedStinson V-77 · Golovin, AKNTSB ANC70D0087Accident · No injuriesClosedPiper PA-18 · Glennallen, AKNTSB ANC70D0084Accident · Minor injuriesClosedPiper PA-20 · Skwentna, AKNTSB ANC70A0049Accident · Minor injuriesClosedCessna 402A · Port Moller, AKNTSB ANC70A0048Accident · 2 fatalClosedPiper PA-12 · Juneau, AKNTSB ANC70D0091Accident · Minor injuriesClosedCessna 150F · Willow, AKNTSB ANC70D0085Accident · No injuriesClosedCessna 172 · Fairbanks, AKNTSB ANC70I0047Incident · No injuriesClosedLockheed Ga 382B · Prudhoe Bay, AKNTSB ANC70A0046Accident · No injuriesClosedCessna 206 · Cordova, AKNTSB ANC70D0075Accident · No injuriesClosedChampion 7GCB · Huslia, AKNTSB ANC70F0092Accident · Minor injuriesClosedPiper PA-14 · Anchorage, AKNTSB ANC70D0077Accident · Minor injuriesClosedPiper PA-12 · Willow, AKNTSB ANC70A0045Accident · Serious injuriesClosedHiller Acft FH1100 · Arctic Vil, AKNTSB ANC70F0080Accident · Minor injuriesClosedPiper PA-11 · Kenai, AKNTSB ANC70A0043Accident · 2 fatalClosedCessna 180 · Anchorage, AKNTSB ANC70D0082Accident · No injuriesClosedPiper J3C-65 · Kodiak, AKNTSB ANC70A0044Accident · No injuriesClosedBell 47J-2 · Cape Beaufrt, AKNTSB ANC70A0042Accident · No injuriesClosedCessna 180 · Kwigillingok, AKNTSB ANC70A0041Accident · 2 fatalClosedCessna 180H · Pt.Alexander, AKNTSB ANC70A0040Accident · No injuriesClosedDehavilland DHC-2 · Barrow, AKNTSB ANC70A0039Accident · 2 fatalClosedPiper PA-18 · Palmer, AKNTSB ANC70D0090Accident · No injuriesClosedPiper PA-12 · Seward, AKNTSB ANC70A0038Accident · Minor injuriesClosedBeech TC-45J · Barrow, AKNTSB ANC70I0037Incident · No injuriesClosedBeech 95 · Anchorage, AKNTSB ANC70D0079Accident · Minor injuriesClosedBell 47J-2 · Iliamna, AKNTSB ANC70D0072Accident · No injuriesClosedPiper PA-12S · Kodiak, AKNTSB ANC70F0056Accident · No injuriesClosedPiper PA-32 · Fairbanks, AKNTSB ANC70D0093Accident · Minor injuriesClosedCessna 150 · Galena, AKNTSB ANC70A0036Accident · No injuriesClosedHughes 269B · Ketchikan, AKNTSB ANC70A0035Accident · 1 fatalClosedBell 47J-2 · Fairbanks, AKNTSB ANC70A0032Accident · 6 fatalClosedCessna TU206B · Anchorage, AKNTSB ANC70D0086Accident · No injuriesClosedPiper PA-14 · Wasilla, AKNTSB ANC70A0034Accident · No injuriesClosedDehavilland DHC-6 · Point Barrow, AKNTSB ANC70D0074Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKNTSB ANC70D0089Accident · No injuriesClosedCessna 172 · St Mary Mssn, AKNTSB ANC70A0030Accident · 1 fatalClosedPiper PA-18 · Fairbanks, AKNTSB ANC70F0034Accident · No injuriesClosedAeronca 11BC · Glennallen, AKNTSB ANC70F0088Accident · No injuriesClosedAlon A-2 · Anchorage, AKNTSB ANC70A0031Accident · No injuriesClosedCessna 185 · Juneau, AKNTSB ANC70D0050Accident · Minor injuriesClosedCessna 170B · Palmer, AKNTSB ANC70D0069Accident · No injuriesClosedHiller Acft FH1100 · Barrow, AKNTSB ANC70A0029Accident · 3 fatalClosedCessna 177 · Kodiak, AKNTSB ANC70F0030Accident · No injuriesClosedTaylorcraft BC12D · Fairbanks, AKNTSB ANC70D0073Accident · No injuriesClosedStinson 108-1 · Delta Junctn, AKNTSB ANC70A0028Accident · No injuriesClosedBell 47G-2 · Barrow, AKNTSB ANC70F0070Accident · Minor injuriesClosedCessna 150 · Anchorage, AKNTSB ANC70D0068Accident · No injuriesClosedCessna 180C · Kenai, AKNTSB ANC70D0033Accident · Minor injuriesClosedPiper PA-11 · Anchorage, AKNTSB ANC70F0067Accident · Serious injuriesClosedStinson 108-3 · Cantwell, AK