NTSB investigations, 1977, 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, 1977, 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\") = 1977
    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 ANC78DA008Accident · Serious injuriesClosedShort Bros SC-7 · Toksook Bay, AKDec 31, 1977 · N64AC · DestroyedNTSB ANC78DAG17Accident · Serious injuriesClosedCessna 185D · Mt.Susitna, AKDec 27, 1977 · N1553F · Substantial damageNTSB ANC78DAG20Accident · No injuriesClosedPiper PA-22 · Talkeenta, AKDec 25, 1977 · N5417Z · Substantial damageNTSB ANC78DAG16Accident · No injuriesClosedCessna 180 · Anchorage, AKDec 25, 1977 · N2230C · Substantial damageNTSB ANC78DA007Accident · Minor injuriesClosedCessna 207 · Iliamna, AKDec 23, 1977 · N1656U · DestroyedNTSB ANC78DA006Accident · No injuriesClosedBeech 65-A80 · Allakaket, AKDec 23, 1977 · N140RH · Substantial damageNTSB ANC78FA005Accident · 2 fatalClosedHiller Acft FH1100 · Anchor Point, AKDec 19, 1977 · N18845 · DestroyedNTSB ANC78DAG15Accident · No injuriesClosedAeronca 7ECA · Anchorage, AKDec 12, 1977 · N2517 · Substantial damageNTSB ANC78DA004Accident · Minor injuriesClosedBell 206-L · Deadhorse, AKNov 30, 1977 · N403EH · Substantial damageNTSB ANC78FAA03Accident · Minor injuriesClosedCessna 185 · Shaktoolik, AKNov 20, 1977 · N80136 · Substantial damageNTSB ANC78FAD01Accident · 1 fatalClosedCessna 150 · Goddard, AKNov 19, 1977 · N63640 · Substantial damageNTSB ANC78FAA02Accident · No injuriesClosedCessna 150 · Fairbanks, AKNov 9, 1977 · N714SQ · Substantial damageNTSB ANC78FA002Accident · 2 fatalClosedMooney M-20C · Northway, AKNov 9, 1977 · N6709N · Substantial damageNTSB ANC78DAG07Accident · No injuriesClosedPiper PA-18 · Dadina River, AKNov 9, 1977 · N9840Q · Substantial damageNTSB ANC78DAG08Accident · No injuriesClosedChampion 7GCAA · Cantwell, AKOct 31, 1977 · N8386V · Substantial damageNTSB ANC77DAH50Accident · No injuriesClosedCessna 180 · Thompson Pass, AKOct 30, 1977 · N5296D · Substantial damageNTSB ANC77DAG12Accident · No injuriesClosedPiper PA-18A · Anchorage, AKOct 22, 1977 · N8246C · Substantial damageNTSB ANC78DAG10Accident · No injuriesClosedPiper PA-22 · Dillingham, AKOct 16, 1977 · N2479P · Substantial damageNTSB ANC78DAG09Accident · No injuriesClosedCessna 170B · Bethel, AKOct 14, 1977 · N3574D · Substantial damageNTSB ANC78DAG06Accident · No injuriesClosedPiper PA-18 · Port Hieden, AKOct 12, 1977 · N3979Z · Substantial damageNTSB ANC78DAG01Accident · Minor injuriesClosedCessna 150 · Gulkana, AKOct 12, 1977 · N8437J · Substantial damageNTSB MKC77PAG03Accident · No injuriesClosedAeronca 15AC · Anchorage, AKOct 2, 1977 · N1293H · Substantial damageNTSB ANC77DAA62Accident · No injuriesClosedCessna 180 · New Minto, AKOct 2, 1977 · N9172L · Substantial damageNTSB ANC78DAG04Accident · No injuriesClosedPiper PA-18 · Iliamna, AKOct 1, 1977 · N99280 · Substantial damageNTSB ANC77FAA60Accident · No injuriesClosedCessna 180 · Nenana, AKSep 27, 1977 · N52037 · Substantial damageNTSB ANC77FA090Accident · Serious injuriesClosedPiper PA-31B · Lke Minchumina, AKSep 24, 1977 · N103TA · DestroyedNTSB ANC77DAH36Accident · No injuriesClosedCessna 150M · Soldotna, AKSep 22, 1977 · N63442 · Substantial damageNTSB ANC78DA001Accident · No injuriesClosedCessna U206F · Afognak Isl, AKSep 21, 1977 · N7353Q · Minor damageNTSB ANC77DAA57Accident · Serious injuriesClosedPiper PA-18 · Ft.Yukon, AKSep 20, 1977 · N453HC · Substantial damageNTSB ANC77DAH28Accident · No injuriesClosedLake LA-4 · Turquoise Lake, AKSep 19, 1977 · N1228L · Substantial damageNTSB ANC77DAH40Accident · No injuriesClosedPiper PA-18 · Anchorage, AKSep 18, 1977 · N3872Z · Substantial damageNTSB ANC77DAH27Accident · No injuriesClosedCessna 180 · Talkeetna, AKSep 18, 1977 · N9433C · Substantial damageNTSB ANC77DAH41Accident · No injuriesClosedPiper PA-12 · Anchorage, AKSep 16, 1977 · N4040M · Substantial damageNTSB ANC77DAH35Accident · No injuriesClosedCessna 170A · Seward, AKSep 16, 1977 · N1364D · Substantial damageNTSB ANC77DAH25Accident · No injuriesClosedPiper PA-18 · Homer, AKSep 16, 1977 · N9657P · Substantial damageNTSB ANC77DAH20Accident · No injuriesClosedCessna 182 · Anchorage, AKSep 16, 1977 · N2744G · Substantial damageNTSB ANC77DAH30Accident · No injuriesClosedPiper PA-18 · Sparrevohn, AKSep 14, 1977 · N1827A · Substantial damageNTSB ANC77DAH21Accident · No injuriesClosedPiper PA-22 · Skwenta, AKSep 14, 1977 · N9612D · Substantial damageNTSB ANC77DAH18Accident · No injuriesClosedBellanca 7ACA · Kasitna Bay, AKSep 14, 1977 · N62967 · Substantial damageNTSB ANC77DA099Accident · No injuriesClosedPiper PA-28R · Port Alsworth, AKSep 14, 1977 · N55030 · Substantial damageNTSB ANC77DAH14Accident · No injuriesClosedMaule M-5 · Hayes River, AKSep 13, 1977 · N51566 · DestroyedNTSB DCA77AA027Accident · 4 fatalClosedDouglas DC-7BF · Yakutat, AKSep 12, 1977 · N6314J · DestroyedNTSB ANC77DAH13Accident · No injuriesClosedPiper PA-14 · Iliamna, AKSep 12, 1977 · N5159H · Substantial damageNTSB ANC77DA088Accident · No injuriesClosedHiller Acft 1100 · Sparrevohn Afs, AKSep 11, 1977 · N5052F · Substantial damageNTSB ANC78DAG35Accident · No injuriesClosedCessna A185F · Cordova, AKSep 10, 1977 · N93829 · Substantial damageNTSB ANC77DAH42Accident · No injuriesClosedCessna 180 · Palmer, AKSep 10, 1977 · N1929C · Substantial damageNTSB ANC77DAA51Accident · 1 fatalClosedCessna A185F · Bettles, AKSep 7, 1977 · N4974C · Minor damageNTSB DCA77AA026Accident · 13 fatalClosedDehavilland DHC-6 · Iliamna, AKSep 6, 1977 · N563MA · DestroyedNTSB ANC77DAH22Accident · No injuriesClosedCessna 180 · Rainy Pass Lod, AKSep 6, 1977 · N9478C · Substantial damageNTSB ANC77DAH23Accident · No injuriesClosedWillbird 01 · Susitna Lodge, AKSep 5, 1977 · N67272 · Substantial damage