NTSB investigations, 1967, 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\") = 1967
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") = 1967 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 ANC68A0035Accident · Minor injuriesClosedAero Macchi AL60B · Nome, AKNTSB ANC68D0076Accident · Minor injuriesClosedLuscombe 8A · Fairbanks, AKNTSB ANC68D0091Accident · No injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC68F0074Accident · No injuriesClosedPiper PA-18 · Sitka, AKNTSB ANC68A0034Accident · Minor injuriesClosedCessna 180 · Teller, AKNTSB ANC68A0033Accident · No injuriesClosedBell 47G-2A · Anchorage, AKNTSB ANC68F0089Accident · No injuriesClosedCessna 170 · Skwentna, AKNTSB ANC68D0073Accident · No injuriesClosedBeech D18S · Kodiak, AKNTSB ANC68A0032Accident · No injuriesClosedPiper PA-32 · Eagle, AKNTSB ANC68A0031Accident · 5 fatalClosedHiller FH1100 · Juneau, AKNTSB ANC68A0030Accident · No injuriesClosedGrumman G-44 · Kodiak, AKNTSB ANC68A0029Accident · No injuriesClosedLockheed Ga L-382B · Anchorage, AKNTSB ANC68D0068Accident · No injuriesClosedAeronca 7GC · Willow, AKNTSB ANC68A0028Accident · No injuriesClosedPiper PA-12 · Skwentna, AKNTSB ANC68F0067Accident · No injuriesClosedPiper PA-12 · Port Heiden, AKNTSB ANC68A0026Accident · No injuriesClosedCessna 180A · Homer, AKNTSB ANC68A0027Accident · No injuriesClosedCessna U206 · Anchorage, AKNTSB ANC68D0066Accident · No injuriesClosedCessna 140 · Eureka, AKNTSB ANC68D0063Accident · No injuriesClosedCessna 180 · Tyonek, AKNTSB ANC68A0025Accident · No injuriesClosedCurtiss-Wrt C-46A · Fairbanks, AKNTSB ANC68F0078Accident · No injuriesClosedCessna 180 · Anchorage, AKNTSB ANC68F0056Accident · No injuriesClosedPiper PA-18 · Chitina, AKNTSB ANC68D0059Accident · No injuriesClosedPiper PA-18 · Ketchikan, AKNTSB ANC68A0024Accident · 1 fatalClosedBell 47J-2A · Cordova, AKNTSB ANC68A0023Accident · 1 fatalClosedHiller UH-12E · Juneau, AKNTSB ANC68A0022Accident · No injuriesClosedSikorsky S-55B · Pt.Woronzoff, AKNTSB ANC68D/072Accident · No injuriesClosedPiper PA-14 · King Salmon, AKNTSB ANC68D0061Accident · No injuriesClosedPiper PA-18 · Paxson, AKNTSB ANC68A0021Accident · No injuriesClosedHiller UH-12E · Juneau, AKNTSB ANC68F0055Accident · No injuriesClosedPiper PA-22 · Kenai, AKNTSB ANC68F0088Accident · No injuriesClosedPiper PA-18 · Gulkana, AKNTSB ANC68D0087Accident · No injuriesClosedStinson 108-2 · Pilot Point, AKNTSB ANC68D0069Accident · No injuriesClosedPiper PA-12 · Tok, AKNTSB ANC68D0058Accident · No injuriesClosedCessna 172G · Ketchikan, AKNTSB ANC68D0051Accident · No injuriesClosedPiper PA-12 · Gulkana, AKNTSB ANC68D0053Accident · No injuriesClosedAeronca 7EC · Juneau, AKNTSB ANC68A0020Accident · 3 fatalClosedPiper PA-18A · Chitina, AKNTSB ANC68A0019Accident · 1 fatalClosedCessna 180 · Iliamna, AKNTSB ANC68A0018Accident · No injuriesClosedHiller UH-12E · Chicken, AKNTSB ANC68F0093Accident · Serious injuriesClosedCessna 175 · Pilot Point, AKNTSB ANC68A0017Accident · 2 fatalClosedCessna 172 · AKNTSB ANC68F0077Accident · No injuriesClosedPiper PA-14 · Skwentna, AKNTSB ANC68D0086Accident · Minor injuriesClosedPiper PA-12 · Palmer, AKNTSB ANC68F0097Accident · Serious injuriesClosedPiper PA-18 · Chitina, AKNTSB ANC68F0070Accident · Serious injuriesClosedBeech A45 · Juneau, AKNTSB ANC68D0054Accident · No injuriesClosedCessna 180 · Golovin, AKNTSB ANC68D0049Accident · Minor injuriesClosedPiper PA-12S · Ketchikan, AKNTSB ANC68A0015Accident · Minor injuriesClosedSikorsky S-62A · Tyonek, AKNTSB ANC68A0014Accident · No injuriesClosedHelio Acft H-250 · Buckland, AKNTSB ANC68D0048Accident · Minor injuriesClosedMooney M20B · Haines, AK