NTSB investigations, 1973, AK

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1973, 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\") = 1973
    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 ANC74AA050Accident · 2 fatalClosedPiper PA-18 · Glennallen, AKDec 31, 1973 · N7694D · Substantial damageNTSB ANC74FAA23Accident · Minor injuriesClosedCessna 180 · Ft.Yukon, AKDec 30, 1973 · N9625B · Substantial damageNTSB ANC74DAG83Accident · Minor injuriesClosedPiper PA-12 · Anchorage, AKDec 30, 1973 · N3029M · Substantial damageNTSB ANC74DAG85Accident · No injuriesClosedCessna 185 · Illiamna, AKDec 22, 1973 · N185ML · Substantial damageNTSB ANC74FAA24Accident · No injuriesClosedConvair L-13 · Fairbanks, AKDec 20, 1973 · N4704V · Substantial damageNTSB ANC74DAG82Accident · No injuriesClosedChampion 7GCBC · Kodiak, AKDec 20, 1973 · N9018L · Substantial damageNTSB ANC74AA049Accident · 2 fatalClosedPiper PA-18 · Puntilla, AKDec 14, 1973 · N7908P · DestroyedNTSB ANC74AA047Accident · 3 fatalClosedCessna 180C · Anchorage, AKNov 23, 1973 · N4669S · DestroyedNTSB ANC74AA046Accident · 1 fatalClosedAero Comdr 560A · Galena, AKNov 23, 1973 · N12317 · DestroyedNTSB ANC74DAG80Accident · Minor injuriesClosedPiper J-3 · Kodiak, AKNov 18, 1973 · N6069H · Substantial damageNTSB ANC74FAG81Accident · Serious injuriesClosedTaylorcraft BC12-D · Skwentna, AKNov 17, 1973 · N96188 · Substantial damageNTSB ANC74DAG79Accident · No injuriesClosedPiper PA-18 · Talkeetna, AKNov 17, 1973 · N215T · Substantial damageNTSB ANC74AA045Accident · 3 fatalClosedCessna 170 · Anchorage, AKNov 17, 1973 · N9058A · DestroyedNTSB ANC74DAA21Accident · No injuriesClosedPiper PA-16 · North Pole, AKNov 16, 1973 · N5776H · Substantial damageNTSB ANC74DAG74Accident · No injuriesClosedPiper PA-20 · Alex Lk Ldge, AKNov 12, 1973 · N7012K · Substantial damageNTSB ANC74AA044Accident · Serious injuriesClosedPiper PA-18 · Anchorage, AKNov 12, 1973 · N3872Z · 2 aircraft · Substantial damageNTSB ANC74DAG78Accident · No injuriesClosedCessna 170B · Skwentna, AKNov 10, 1973 · N8168A · Substantial damageNTSB ANC74DAG77Accident · No injuriesClosedPiper PA-12 · Beluga, AKNov 10, 1973 · N2368M · Substantial damageNTSB ANC74DAG72Accident · No injuriesClosedPiper PA-11 · Alexndr Lake, AKNov 4, 1973 · N4987M · Substantial damageNTSB ANC74AA043Accident · No injuriesClosedDehavilland DHC-3 · Eek, AKNov 2, 1973 · N98T · Substantial damageNTSB ANC74AA042Accident · No injuriesClosedPiper PA-32 · Port Heiden, AKOct 30, 1973 · N4236T · Substantial damageNTSB ANC74AA041Accident · No injuriesClosedCessna 180 · Chitna, AKOct 29, 1973 · N6443X · Substantial damageNTSB ANC74AA040Accident · 1 fatalClosedCessna 180 · Anchorage, AKOct 26, 1973 · N3160D · DestroyedNTSB ANC74FAA19Accident · Minor injuriesClosedHiller Acft FH1100 · Fairbanks, AKOct 23, 1973 · N369FH · Substantial damageNTSB ANC74FAG76Accident · No injuriesClosedCessna 150 · Anchorage, AKOct 22, 1973 · N6691T · Substantial damageNTSB ANC74DAG70Accident · No injuriesClosedCessna 185 · Ugashik, AKOct 20, 1973 · N4520F · Substantial damageNTSB ANC74DAG69Accident · No injuriesClosedCessna U206 · Bethel, AKOct 20, 1973 · N8015Z · Substantial damageNTSB ANC74DAG68Accident · No injuriesClosedCessna U206 · Akiak, AKOct 15, 1973 · N2125F · Substantial damageNTSB ANC74DAG67Accident · Minor injuriesClosedCessna 185 · Anchorage, AKOct 13, 1973 · N1531F · Substantial damageNTSB ANC74DAG65Accident · No injuriesClosedCessna 305B · Willow, AKOct 13, 1973 · N9850 · Substantial damageNTSB ANC74DAG75Accident · No injuriesClosedCessna 177A · Nikolski, AKOct 11, 1973 · N30610 · Substantial damageNTSB ANC74FAA20Accident · No injuriesClosedBellanca 7GCBC · Fairbanks, AKOct 10, 1973 · N1848G · Substantial damageNTSB ANC74AA039Accident · No injuriesClosedPiper PA-32 · Ugashik, AKOct 8, 1973 · N4074R · Substantial damageNTSB ANC74AA038Accident · Minor injuriesClosedCessna 185 · Ketchikan, AKOct 8, 1973 · N2760J · Substantial damageNTSB ANC74DAG64Accident · No injuriesClosedPiper PA-14 · Anchorage, AKOct 6, 1973 · N5135H · Substantial damageNTSB ANC74AA037Accident · Minor injuriesClosedGrumman G-44 · Kodiak, AKOct 6, 1973 · N176MS · DestroyedNTSB ANC74DAG63Accident · Minor injuriesClosedCessna 150 · Susitna, AKOct 3, 1973 · N1273Q · Substantial damageNTSB ANC74DAG66Accident · Minor injuriesClosedPiper PA-18 · Nondalton, AKOct 1, 1973 · N5408Y · Substantial damageNTSB ANC74DAG62Accident · No injuriesClosedSudaviation SA318C · Kenai, AKOct 1, 1973 · N8452 · Substantial damageNTSB ANC74FAG73Accident · Serious injuriesClosedPiper PA-18 · Gulkana, AKSep 30, 1973 · N3577P · DestroyedNTSB ANC74DAG61Accident · No injuriesClosedPiper PA-18 · Rain Pass Lg, AKSep 30, 1973 · N3946Z · Substantial damageNTSB ANC74DAA22Accident · No injuriesClosedCessna 180 · Kotzebue, AKSep 30, 1973 · N4540B · DestroyedNTSB ANC74DAG60Accident · No injuriesClosedBellanca 7GCBC · Anchorage, AKSep 29, 1973 · N57484 · Substantial damageNTSB ANC74DAG59Accident · No injuriesClosedPiper PA-12 · Anchorage, AKSep 25, 1973 · N4444M · Substantial damageNTSB ANC74DAG57Accident · No injuriesClosedMaule M4220C · Bethel, AKSep 23, 1973 · N40319 · Substantial damageNTSB ANC74AA036Accident · 1 fatalClosedPiper PA-18 · King Salmon, AKSep 23, 1973 · N4436Z · No damageNTSB ANC74DAA14Accident · No injuriesClosedPiper PA-20 · Bettles, AKSep 22, 1973 · N1775A · Substantial damageNTSB ANC74FAA15Accident · No injuriesClosedPiper PA-18 · Clear, AKSep 21, 1973 · N9855D · Substantial damageNTSB ANC74DAG58Accident · No injuriesClosedCessna 305 · Susitna, AKSep 20, 1973 · N6233 · Substantial damageNTSB ANC74AA035Accident · 2 fatalClosedCessna 150L · Birchwood, AKSep 18, 1973 · N5352Q · Destroyed