NTSB investigations, 1965, 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\") = 1965
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") = 1965 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 ANC66D0086Accident · No injuriesClosedCessna 172 · Port Heiden, AKNTSB ANC66A0047Accident · 3 fatalClosedPiper PA-14 · Anchorage, AKNTSB ANC66A0026Accident · 2 fatalClosedPiper PA-24 · Umiat, AKNTSB ANC66A0025Accident · No injuriesClosedCessna 180 · Bethel, AKNTSB ANC66A0024Accident · No injuriesClosedGrumman G-73 · Bethel, AKNTSB ANC66A0022Accident · No injuriesClosedBeechcraft 35B33 · Anchorage, AKNTSB ANC66D0075Accident · No injuriesClosedCessna 180C · Stevens Vilg, AKNTSB ANC66D0079Accident · No injuriesClosedPiper PA-22 · Anchorage, AKNTSB ANC66D0088Accident · No injuriesClosedPiper PA-22 · Anchorage, AKNTSB ANC66D0074Accident · Minor injuriesClosedPiper PA-20 · Barrow, AKNTSB ANC66F0081Accident · No injuriesClosedBeechcraft C45G · Anchorage, AKNTSB ANC66D0084Accident · No injuriesClosedCessna 180 · Bethel, AKNTSB ANC66F0077Accident · No injuriesClosedCessna 170 · Sterling, AKNTSB ANC66A0021Accident · No injuriesClosedCessna 205 · Fairbanks, AKNTSB ANC66F0067Accident · Minor injuriesClosedTaylorcraft BCS12D · Sitka, AKNTSB ANC66A0020Accident · No injuriesClosedDehavilland DHC-2 · Articvillage, AKNTSB ANC66F0078Accident · Serious injuriesClosedPiper PA-18 · Wasilla, AKNTSB ANC66D0066Accident · Serious injuriesClosedTaylorcraft BC12D · North Pole, AKNTSB ANC66D0068Accident · Minor injuriesClosedPiper PA-18 · Farewell, AKNTSB ANC66D0059Accident · No injuriesClosedCessna 180 · Kenai, AKNTSB ANC66D0064Accident · No injuriesClosedCessna 310H · Nome, AKNTSB ANC66A0019Accident · 1 fatalClosedCessna 140 · Napakiah, AKNTSB ANC66A0018Accident · No injuriesClosedCessna 180 · Chefornak, AKNTSB ANC66D0100Accident · No injuriesClosedTaylorcraft BC12-D · Mekoryuk, AKNTSB ANC66A0017Accident · 1 fatalClosedPiper PA-22S · Ketchikan, AKNTSB ANC66Z0015Accident · No injuriesClosedBell 47G-2 · 75e Umiat, AKNTSB ANC66F0058Accident · Minor injuriesClosedChampion 7HC · Anchorage, AKNTSB ANC66D0065Accident · No injuriesClosedAeronca 11BC · Sleetmute, AKNTSB ANC66D0071Accident · No injuriesClosedChampion 7GCB · Iliama, AKNTSB ANC66D0041Accident · No injuriesClosedPiper PA-24 · Healy Forks, AKNTSB ANC66A0014Accident · No injuriesClosedPilatus Por PC6BH2 · Selawik, AKNTSB ANC66D0055Accident · No injuriesClosedChampion 7HC · Tyonek, AKNTSB ANC66A0016Accident · 2 fatalClosedPiper PA-18A · Chignik, AKNTSB ANC66D0069Accident · No injuriesClosedCessna 180 · Talkeetna, AKNTSB ANC66A0013Accident · No injuriesClosedHiller UH-12E · Juneau, AKNTSB ANC66D0043Accident · Minor injuriesClosedPiper PA-22 · Fairbanks, AKNTSB ANC66D0035Accident · No injuriesClosedPiper PA-12 · Fairbanks, AKNTSB ANC66A0012Accident · No injuriesClosedHelio 395-A · Yakataga, AKNTSB ANC66A0010Accident · No injuriesClosedDouglas DC-3 · Mc Carthy, AKNTSB ANC66D0072Accident · No injuriesClosedCessna 172 · Skwentna, AKNTSB ANC66AA011Accident · 2 fatalClosedStinson 108-2 · Council, AKNTSB ANC66D0047Accident · No injuriesClosedPiper PA-18 · Tyonek, AKNTSB ANC66D0031Accident · Minor injuriesClosedMooney M18C · Fairbanks, AKNTSB ANC66D0029Accident · No injuriesClosedPiper PA-20 · Kotzebue, AKNTSB ANC66D0036Accident · No injuriesClosedStinson 108-1 · Klukwan, AKNTSB ANC66D0030Accident · Minor injuriesClosedStinson SR · Nome, AKNTSB ANC66A0009Accident · 4 fatalClosedAero Comm 680 · Lk.Tustumena, AKNTSB ANC66D0070Accident · Serious injuriesClosedCessna 180 · Wasilla, AKNTSB ANC66A0008Accident · 3 fatalClosedPiper PA-12 · Anchorage, AKNTSB ANC66D0063Accident · No injuriesClosedChampion 7GCB · Tyonek, AK