NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1166Accident · 1 fatalClosedPiper PA-28 · King Salmon, AKNTSB UNK65X1092Accident · No injuriesClosedCessna 185 · Seldovia, AKNTSB UNK65X0980Incident · No injuriesClosedCessna 185 · Homer, AKNTSB UNK65X0964Accident · 1 fatalClosedCessna 185 · Norton Sound, AKNTSB UNK65X0952Accident · No injuriesClosedPiper PA18 · Eureka, AKNTSB UNK65X0925Accident · No injuriesClosedCessna 185 · Bethel, AKNTSB UNK65X0918Accident · No injuriesClosedCurtiss C46 · Oliktok Pt, AKNTSB ANC65I0030Incident · No injuriesClosedGrumman G-73 · Bethel, AKNTSB UNK65X0867Accident · No injuriesClosedPil-Porter PC-6A · Hughes, AKNTSB UNK65X0864Accident · No injuriesClosedPiper PA28 · Anchorage, AKNTSB UNK65X0849Accident · No injuriesClosedPiper PA12 · Anchorage, AKNTSB UNK65X0840Accident · 1 fatalClosedAeronca 7DC · Eagle River, AKNTSB UNK65X0819Accident · No injuriesClosedPiper PA12 · Merrill Fld, AKNTSB UNK65X0802Accident · No injuriesClosedPiper PA20 · Wainwright, AKNTSB UNK65X0771Incident · No injuriesClosedPila Porter PC-6A · Anaik, AKNTSB UNK65X0735Accident · No injuriesClosedBeechcraft J35 · Fairbanks, AKNTSB UNK65X0684Accident · No injuriesClosedTaylorcraft BC12D · Anchorage, AKNTSB UNK65X0677Accident · No injuriesClosedGrumman G-44 · Cape Alitak, AKNTSB UNK65X0670Accident · No injuriesClosedPiper PA-18A · Eureka, AKNTSB UNK65X0659Accident · No injuriesClosedPiper PA18 · Anchorage, AKNTSB UNK65X0626Accident · Minor injuriesClosedStinson 108-2 · Whittier, AKNTSB UNK65X0594Accident · No injuriesClosedPiper PA22 · Willow, AKNTSB UNK65X0560Accident · No injuriesClosedBell 47G2 · Umiat, AKNTSB UNK65X0559Accident · No injuriesClosedCessna 180 · Kwethluk, AKNTSB UNK65X0553Accident · No injuriesClosedCessna 180 · Clear, AKNTSB UNK65X0545Accident · No injuriesClosedPiper PA18A · Paradise Vly, AKNTSB UNK65X0518Accident · No injuriesClosedCessna 140 · Sparrevohn, AKNTSB UNK65X0477Accident · No injuriesClosedMaule M4 · Whittier, AKNTSB UNK65X0462Accident · No injuriesClosedCessna 180F · Setka, AKNTSB UNK65X0317Accident · No injuriesClosedBell 47G2 · King Salmon, AKNTSB UNK65X0234Accident · No injuriesClosedPiper PA22 · Palmer, AKNTSB UNK65X0231Accident · No injuriesClosedCessna 170B · Tants River, AKNTSB UNK65X0118Accident · 1 fatalClosedConvair 285ACF · Chichagof I, AKNTSB UNK65X0106Accident · No injuriesClosedPiper PA-18 · Tanalian Pt, AKNTSB UNK65X0102Accident · No injuriesClosedPiper PA12 · Homer, AKNTSB UNK64X4210Accident · No injuriesClosedChampion 7GCB · Dillingham, AKNTSB UNK64X4202Incident · No injuriesClosedLockheed L-1649 · Shemya, AKNTSB UNK64X4158Accident · No injuriesClosedAeronca 7DC · Anchorage, AKNTSB UNK64X4107Accident · No injuriesClosedBell 47G2 · Tyone, AKNTSB UNK64X4093Accident · No injuriesClosedCessna 180 · Perryville, AKNTSB UNK64X4079Accident · No injuriesClosedHiller UH12E · Manly Ht Spg, AKNTSB UNK64X4069Accident · No injuriesClosedPiper PA18 · Ltl Delta Rv, AKNTSB UNK64X4039Accident · 2 fatalClosedPiper PA-18 · Yanert Glacr, AKNTSB UNK64X4010Accident · No injuriesClosedPiper J-3 · Anchorage, AKNTSB UNK64X4001Accident · No injuriesClosedCessna 170B · Anchorage, AKNTSB UNK64X3941Accident · No injuriesClosedRepublic RC3 · Nenana, AKNTSB UNK64X3932Accident · 1 fatalClosedPiper PA-14 · Tyone Lodge, AKNTSB UNK64X3927Accident · 3 fatalClosedPiper PA-18 · Kenai, AKNTSB UNK64X3911Accident · Minor injuriesClosedPiper PA22 · Chistochina, AKNTSB UNK64X3909Accident · No injuriesClosedHoward DGH15P · Anchorage, AK