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

19622026
NTSB investigations, 1969, 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\") = 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.

NTSB ANC70A0051Accident · Minor injuriesClosedCessna 180 · Cordova, AKDec 30, 1969 · N8619X · Substantial damageNTSB ANC70A0050Accident · Minor injuriesClosedStinson V-77 · Golovin, AKDec 29, 1969 · N50225 · Substantial damageNTSB ANC70D0087Accident · No injuriesClosedPiper PA-18 · Glennallen, AKDec 28, 1969 · N2992Z · Substantial damageNTSB ANC70D0084Accident · Minor injuriesClosedPiper PA-20 · Skwentna, AKDec 21, 1969 · N1818A · Substantial damageNTSB ANC70A0049Accident · Minor injuriesClosedCessna 402A · Port Moller, AKDec 21, 1969 · N4574Q · Substantial damageNTSB ANC70A0048Accident · 2 fatalClosedPiper PA-12 · Juneau, AKDec 21, 1969 · N3013M · Substantial damageNTSB ANC70D0091Accident · Minor injuriesClosedCessna 150F · Willow, AKDec 17, 1969 · N6296R · Substantial damageNTSB ANC70D0085Accident · No injuriesClosedCessna 172 · Fairbanks, AKDec 13, 1969 · N8039X · Substantial damageNTSB ANC70I0047Incident · No injuriesClosedLockheed Ga 382B · Prudhoe Bay, AKDec 10, 1969 · N920NA · Minor damageNTSB ANC70A0046Accident · No injuriesClosedCessna 206 · Cordova, AKDec 7, 1969 · N4802F · DestroyedNTSB ANC70D0075Accident · No injuriesClosedChampion 7GCB · Huslia, AKDec 6, 1969 · N2951G · Substantial damageNTSB ANC70F0092Accident · Minor injuriesClosedPiper PA-14 · Anchorage, AKNov 30, 1969 · N4201H · Substantial damageNTSB ANC70D0077Accident · Minor injuriesClosedPiper PA-12 · Willow, AKNov 30, 1969 · N3666N · Substantial damageNTSB ANC70A0045Accident · Serious injuriesClosedHiller Acft FH1100 · Arctic Vil, AKNov 30, 1969 · N431FH · Substantial damageNTSB ANC70F0080Accident · Minor injuriesClosedPiper PA-11 · Kenai, AKNov 29, 1969 · N78665 · Substantial damageNTSB ANC70A0043Accident · 2 fatalClosedCessna 180 · Anchorage, AKNov 24, 1969 · N4700B · Substantial damageNTSB ANC70D0082Accident · No injuriesClosedPiper J3C-65 · Kodiak, AKNov 23, 1969 · N98763 · Substantial damageNTSB ANC70A0044Accident · No injuriesClosedBell 47J-2 · Cape Beaufrt, AKNov 21, 1969 · N8506F · Substantial damageNTSB ANC70A0042Accident · No injuriesClosedCessna 180 · Kwigillingok, AKNov 16, 1969 · N2733X · Substantial damageNTSB ANC70A0041Accident · 2 fatalClosedCessna 180H · Pt.Alexander, AKNov 12, 1969 · N8216V · DestroyedNTSB ANC70A0040Accident · No injuriesClosedDehavilland DHC-2 · Barrow, AKNov 10, 1969 · N4478 · Substantial damageNTSB ANC70A0039Accident · 2 fatalClosedPiper PA-18 · Palmer, AKNov 8, 1969 · N7128K · Substantial damageNTSB ANC70D0090Accident · No injuriesClosedPiper PA-12 · Seward, AKNov 4, 1969 · N2328M · Substantial damageNTSB ANC70A0038Accident · Minor injuriesClosedBeech TC-45J · Barrow, AKOct 31, 1969 · N437PA · DestroyedNTSB ANC70I0037Incident · No injuriesClosedBeech 95 · Anchorage, AKOct 28, 1969 · N2728Y · Minor damageNTSB ANC70D0079Accident · Minor injuriesClosedBell 47J-2 · Iliamna, AKOct 27, 1969 · N8497E · Substantial damageNTSB ANC70D0072Accident · No injuriesClosedPiper PA-12S · Kodiak, AKOct 25, 1969 · N7716H · Substantial damageNTSB ANC70F0056Accident · No injuriesClosedPiper PA-32 · Fairbanks, AKOct 21, 1969 · N4160W · Substantial damageNTSB ANC70D0093Accident · Minor injuriesClosedCessna 150 · Galena, AKOct 20, 1969 · N50019 · Substantial damageNTSB ANC70A0036Accident · No injuriesClosedHughes 269B · Ketchikan, AKOct 19, 1969 · N9441F · Substantial damageNTSB ANC70A0035Accident · 1 fatalClosedBell 47J-2 · Fairbanks, AKOct 15, 1969 · N73950 · DestroyedNTSB ANC70A0032Accident · 6 fatalClosedCessna TU206B · Anchorage, AKOct 13, 1969 · N4977F · DestroyedNTSB ANC70D0086Accident · No injuriesClosedPiper PA-14 · Wasilla, AKOct 12, 1969 · N4205H · Substantial damageNTSB ANC70A0034Accident · No injuriesClosedDehavilland DHC-6 · Point Barrow, AKOct 10, 1969 · N4443 · Substantial damageNTSB ANC70D0074Accident · No injuriesClosedPiper PA-18 · Fairbanks, AKOct 9, 1969 · N7178K · Substantial damageNTSB ANC70D0089Accident · No injuriesClosedCessna 172 · St Mary Mssn, AKOct 6, 1969 · N5937A · Substantial damageNTSB ANC70A0030Accident · 1 fatalClosedPiper PA-18 · Fairbanks, AKOct 6, 1969 · N3991Z · Minor damageNTSB ANC70F0034Accident · No injuriesClosedAeronca 11BC · Glennallen, AKOct 5, 1969 · N3261E · Substantial damageNTSB ANC70F0088Accident · No injuriesClosedAlon A-2 · Anchorage, AKOct 4, 1969 · N6537Q · Substantial damageNTSB ANC70A0031Accident · No injuriesClosedCessna 185 · Juneau, AKOct 1, 1969 · N2210T · Substantial damageNTSB ANC70D0050Accident · Minor injuriesClosedCessna 170B · Palmer, AKSep 30, 1969 · N3433D · Substantial damageNTSB ANC70D0069Accident · No injuriesClosedHiller Acft FH1100 · Barrow, AKSep 28, 1969 · N423FH · Substantial damageNTSB ANC70A0029Accident · 3 fatalClosedCessna 177 · Kodiak, AKSep 27, 1969 · N29466 · DestroyedNTSB ANC70F0030Accident · No injuriesClosedTaylorcraft BC12D · Fairbanks, AKSep 25, 1969 · N95786 · Substantial damageNTSB ANC70D0073Accident · No injuriesClosedStinson 108-1 · Delta Junctn, AKSep 25, 1969 · N9010K · Substantial damageNTSB ANC70A0028Accident · No injuriesClosedBell 47G-2 · Barrow, AKSep 25, 1969 · N6751D · Substantial damageNTSB ANC70F0070Accident · Minor injuriesClosedCessna 150 · Anchorage, AKSep 24, 1969 · N6673F · Substantial damageNTSB ANC70D0068Accident · No injuriesClosedCessna 180C · Kenai, AKSep 21, 1969 · N9337T · Substantial damageNTSB ANC70D0033Accident · Minor injuriesClosedPiper PA-11 · Anchorage, AKSep 21, 1969 · N4987M · Substantial damageNTSB ANC70F0067Accident · Serious injuriesClosedStinson 108-3 · Cantwell, AKSep 20, 1969 · N622C · Destroyed