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

19622026
NTSB investigations, 1967, AK per year, 1962–2026: 9,807 cases
19629
196311
1964171
1965158
1966174
1967167
1968173
1969201
1970211
1971214
1972195
1973211
1974224
1975249
1976296
1977251
1978265
1979228
1980239
1981227
1982199
1983211
1984216
1985203
1986186
1987189
1988179
1989193
1990193
1991176
1992192
1993191
1994138
1995173
1996161
1997157
1998172
1999159
2000140
2001131
2002139
2003120
2004107
2005129
200696
2007105
2008108
2009101
201091
2011104
2012112
201394
201479
201577
201697
201775
201893
201987
202080
202192
202284
202375
202480
202586
202663

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.

NTSB ANC68A0035Accident · Minor injuriesClosedAero Macchi AL60B · Nome, AKDec 29, 1967 · N1702L · Substantial damageNTSB ANC68D0076Accident · Minor injuriesClosedLuscombe 8A · Fairbanks, AKDec 24, 1967 · N71596 · Substantial damageNTSB ANC68D0091Accident · No injuriesClosedPiper PA-18 · Anchorage, AKDec 19, 1967 · N3774Z · Substantial damageNTSB ANC68F0074Accident · No injuriesClosedPiper PA-18 · Sitka, AKDec 16, 1967 · N4581A · Substantial damageNTSB ANC68A0034Accident · Minor injuriesClosedCessna 180 · Teller, AKDec 16, 1967 · N9173T · Substantial damageNTSB ANC68A0033Accident · No injuriesClosedBell 47G-2A · Anchorage, AKDec 15, 1967 · N8495E · Substantial damageNTSB ANC68F0089Accident · No injuriesClosedCessna 170 · Skwentna, AKDec 4, 1967 · N3474D · Substantial damageNTSB ANC68D0073Accident · No injuriesClosedBeech D18S · Kodiak, AKNov 30, 1967 · N234S · Substantial damageNTSB ANC68A0032Accident · No injuriesClosedPiper PA-32 · Eagle, AKNov 28, 1967 · N4005R · Substantial damageNTSB ANC68A0031Accident · 5 fatalClosedHiller FH1100 · Juneau, AKNov 23, 1967 · N784LC · DestroyedNTSB ANC68A0030Accident · No injuriesClosedGrumman G-44 · Kodiak, AKNov 20, 1967 · N9311R · Substantial damageNTSB ANC68A0029Accident · No injuriesClosedLockheed Ga L-382B · Anchorage, AKNov 14, 1967 · N9263R · Substantial damageNTSB ANC68D0068Accident · No injuriesClosedAeronca 7GC · Willow, AKNov 12, 1967 · N4883E · Substantial damageNTSB ANC68A0028Accident · No injuriesClosedPiper PA-12 · Skwentna, AKNov 11, 1967 · N3595M · Substantial damageNTSB ANC68F0067Accident · No injuriesClosedPiper PA-12 · Port Heiden, AKNov 6, 1967 · N2945M · Substantial damageNTSB ANC68A0026Accident · No injuriesClosedCessna 180A · Homer, AKOct 22, 1967 · N9751B · Substantial damageNTSB ANC68A0027Accident · No injuriesClosedCessna U206 · Anchorage, AKOct 18, 1967 · N5279U · Substantial damageNTSB ANC68D0066Accident · No injuriesClosedCessna 140 · Eureka, AKOct 14, 1967 · N2215V · Substantial damageNTSB ANC68D0063Accident · No injuriesClosedCessna 180 · Tyonek, AKOct 14, 1967 · N7604A · Substantial damageNTSB ANC68A0025Accident · No injuriesClosedCurtiss-Wrt C-46A · Fairbanks, AKOct 13, 1967 · N92853 · Substantial damageNTSB ANC68F0078Accident · No injuriesClosedCessna 180 · Anchorage, AKOct 7, 1967 · N4654A · Substantial damageNTSB ANC68F0056Accident · No injuriesClosedPiper PA-18 · Chitina, AKOct 7, 1967 · N1271A · Substantial damageNTSB ANC68D0059Accident · No injuriesClosedPiper PA-18 · Ketchikan, AKOct 7, 1967 · N9919D · Substantial damageNTSB ANC68A0024Accident · 1 fatalClosedBell 47J-2A · Cordova, AKOct 6, 1967 · N3073G · DestroyedNTSB ANC68A0023Accident · 1 fatalClosedHiller UH-12E · Juneau, AKOct 5, 1967 · N9756C · DestroyedNTSB ANC68A0022Accident · No injuriesClosedSikorsky S-55B · Pt.Woronzoff, AKOct 4, 1967 · N5096V · Substantial damageNTSB ANC68D/072Accident · No injuriesClosedPiper PA-14 · King Salmon, AKSep 30, 1967 · N4257H · Substantial damageNTSB ANC68D0061Accident · No injuriesClosedPiper PA-18 · Paxson, AKSep 28, 1967 · N3872Z · Substantial damageNTSB ANC68A0021Accident · No injuriesClosedHiller UH-12E · Juneau, AKSep 23, 1967 · N9756C · Substantial damageNTSB ANC68F0055Accident · No injuriesClosedPiper PA-22 · Kenai, AKSep 22, 1967 · N8520D · Substantial damageNTSB ANC68F0088Accident · No injuriesClosedPiper PA-18 · Gulkana, AKSep 21, 1967 · N2855T · Substantial damageNTSB ANC68D0087Accident · No injuriesClosedStinson 108-2 · Pilot Point, AKSep 21, 1967 · N9510K · Substantial damageNTSB ANC68D0069Accident · No injuriesClosedPiper PA-12 · Tok, AKSep 21, 1967 · N7856H · Substantial damageNTSB ANC68D0058Accident · No injuriesClosedCessna 172G · Ketchikan, AKSep 20, 1967 · N3763L · DestroyedNTSB ANC68D0051Accident · No injuriesClosedPiper PA-12 · Gulkana, AKSep 20, 1967 · N2997M · Substantial damageNTSB ANC68D0053Accident · No injuriesClosedAeronca 7EC · Juneau, AKSep 19, 1967 · N7453B · DestroyedNTSB ANC68A0020Accident · 3 fatalClosedPiper PA-18A · Chitina, AKSep 17, 1967 · N6772B · DestroyedNTSB ANC68A0019Accident · 1 fatalClosedCessna 180 · Iliamna, AKSep 16, 1967 · N3133C · Substantial damageNTSB ANC68A0018Accident · No injuriesClosedHiller UH-12E · Chicken, AKSep 15, 1967 · N5361V · Substantial damageNTSB ANC68F0093Accident · Serious injuriesClosedCessna 175 · Pilot Point, AKSep 11, 1967 · N7317M · Substantial damageNTSB ANC68A0017Accident · 2 fatalClosedCessna 172 · AKSep 6, 1967 · N3789L · DestroyedNTSB ANC68F0077Accident · No injuriesClosedPiper PA-14 · Skwentna, AKSep 4, 1967 · N4221H · Substantial damageNTSB ANC68D0086Accident · Minor injuriesClosedPiper PA-12 · Palmer, AKSep 2, 1967 · N4158M · Substantial damageNTSB ANC68F0097Accident · Serious injuriesClosedPiper PA-18 · Chitina, AKSep 1, 1967 · N2285Z · DestroyedNTSB ANC68F0070Accident · Serious injuriesClosedBeech A45 · Juneau, AKAug 31, 1967 · N9181Z · DestroyedNTSB ANC68D0054Accident · No injuriesClosedCessna 180 · Golovin, AKAug 31, 1967 · N5180E · Substantial damageNTSB ANC68D0049Accident · Minor injuriesClosedPiper PA-12S · Ketchikan, AKAug 29, 1967 · N3993M · DestroyedNTSB ANC68A0015Accident · Minor injuriesClosedSikorsky S-62A · Tyonek, AKAug 25, 1967 · N10060 · Substantial damageNTSB ANC68A0014Accident · No injuriesClosedHelio Acft H-250 · Buckland, AKAug 24, 1967 · N6305V · Substantial damageNTSB ANC68D0048Accident · Minor injuriesClosedMooney M20B · Haines, AKAug 23, 1967 · N74760 · Destroyed