Skip to content

NTSB investigations, 1968, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19622026

NTSB investigations, 1968, AK per year, 1962–2026: 9,807 cases
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

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") = 1968 AND c."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1968
    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") = 1968
  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 DCA69A0008Accident · 3 fatalClosedBoeing 707 · Anchorage, AKDec 26, 1968 · N799PA · Destroyed NTSB ANC69A0034Accident · 2 fatalClosedLockheed L-100 · Brit Put, AKDec 24, 1968 · N760AL · Destroyed NTSB ANC69D0098Accident · Minor injuriesClosedCessna 185 · Northway, AKDec 22, 1968 · N9914X · Substantial damage NTSB ANC69A0033Accident · Serious injuriesClosedBeech G18S · Kenai, AKDec 18, 1968 · N5730U · Destroyed NTSB ANC69F0091Accident · Serious injuriesClosedGrumman G-44A · Sanak Island, AKDec 15, 1968 · N148M · Destroyed NTSB ANC69D0097Accident · No injuriesClosedCessna 180 · Arctic Villg, AKDec 13, 1968 · N9191C · Substantial damage NTSB ANC69F0090Accident · No injuriesClosedCessna 150 · Iliamna, AKDec 12, 1968 · N6106T · Substantial damage NTSB ANC69F0080Accident · No injuriesClosedLuscombe 8A · Anchorage, AKDec 8, 1968 · N23040 · Substantial damage NTSB ANC72DAA36Accident · No injuriesClosedHiller UH-12E · Stevens Vill, AKDec 7, 1968 · N9743C · Substantial damage NTSB ANC69D0100Accident · No injuriesClosedDehavilland DHC-2 · Fairbanks, AKDec 5, 1968 · N1805R · Substantial damage NTSB ANC69D0082Accident · No injuriesClosedBell 47J-2 · Barrow, AKDec 3, 1968 · N73960 · Substantial damage NTSB DCA69A0006Accident · 39 fatalClosedFairchild F-27B · Pedro Bay, AKDec 2, 1968 · N4905B · Destroyed NTSB ANC69D0089Accident · No injuriesClosedDehavilland DHC-2 · Ketchikan, AKNov 30, 1968 · N17597 · Substantial damage NTSB ANC69A0037Accident · No injuriesClosedAero Comdr 680 · Prudhoe Bay, AKNov 30, 1968 · N13L · Substantial damage NTSB ANC69D0095Accident · Minor injuriesClosedPiper PA-22 · Kodiak, AKNov 28, 1968 · N5205Z · Substantial damage NTSB ANC69A0032Accident · 2 fatalClosedCessna 185 · Point Baker, AKNov 26, 1968 · N2202T · Destroyed NTSB ANC69D0094Accident · No injuriesClosedCessna 170 · Pedro Bay, AKNov 25, 1968 · N2779C · Substantial damage NTSB ANC69D0086Accident · No injuriesClosedBeech C-18S · Barrow, AKNov 21, 1968 · N79019 · Substantial damage NTSB ANC69A0031Accident · 7 fatalClosedAero Comdr 680-E · Barrow, AKNov 21, 1968 · N3810C · Destroyed NTSB ANC69A0030Accident · No injuriesClosedCessna 180D · Manokotak, AKNov 16, 1968 · N8606X · Substantial damage NTSB ANC69D0077Accident · No injuriesClosedChampion 7ECA · Whittier, AKNov 14, 1968 · N9618S · Substantial damage NTSB ANC69A0029Accident · 1 fatalClosedCessna 185 · Anaktuvuk Ps, AKNov 12, 1968 · N2256T · Substantial damage NTSB ANC69A0028Accident · 4 fatalClosedCessna 180H · Anchorage, AKNov 11, 1968 · N9932V · Destroyed NTSB ANC69D0099Accident · No injuriesClosedPiper PA-20 · Copper Centr, AKNov 5, 1968 · N5591H · Substantial damage NTSB ANC69A0027Accident · 1 fatalClosedBell 47G-4A · Kenai, AKNov 4, 1968 · N1396X · Destroyed NTSB ANC69A0026Accident · Minor injuriesClosedLockheed Ga 382E · Prudhoe Bay, AKNov 3, 1968 · N9265R · Substantial damage NTSB ANC69D0079Accident · Minor injuriesClosedPiper PA-32 · Sand Point, AKNov 1, 1968 · N4021W · Destroyed NTSB ANC69D0078Accident · No injuriesClosedCessna 180 · King Salmon, AKOct 27, 1968 · N9798B · Substantial damage NTSB ANC69A0024Accident · 2 fatalClosedPiper J3C-85 · Anchorage, AKOct 23, 1968 · N42633 · Destroyed NTSB ANC69A0023Accident · 1 fatalClosedBell 47J-2 · Prudhoe Bay, AKOct 15, 1968 · N8438E · Destroyed NTSB ANC69D0071Accident · Minor injuriesClosedPiper PA-14 · Anchorage, AKOct 13, 1968 · N5142H · Substantial damage NTSB ANC69D0064Accident · No injuriesClosedStinson 108-1 · Fairbanks, AKOct 12, 1968 · N8724K · Substantial damage NTSB ANC69A0021Accident · Serious injuriesClosedAero Comdr 680 · Tin City, AKOct 12, 1968 · N401M · Substantial damage NTSB ANC69A0022Accident · Minor injuriesClosedBell 47J-2 · Point Barrow, AKOct 10, 1968 · N73950 · Substantial damage NTSB ANC69A0020Accident · 1 fatalClosedPiper PA-28 · Anchorage, AKOct 6, 1968 · N8215W · Substantial damage NTSB ANC69F0085Accident · Minor injuriesClosedCessna 140 · Willow, AKOct 5, 1968 · N2215V · Substantial damage NTSB ANC69D0075Accident · No injuriesClosedPiper PA-18 · Anchorage, AKOct 5, 1968 · N1755P · Substantial damage NTSB ANC69D0070Accident · Minor injuriesClosedLuscombe 8E · Mccarthy, AKOct 2, 1968 · N2046K · Substantial damage NTSB ANC69A0019Accident · 3 fatalClosedBeech D50A · Kenai, AKOct 1, 1968 · N674T · Destroyed NTSB ANC69D0066Accident · No injuriesClosedPiper PA-18 · Whittier, AKSep 29, 1968 · N3797Z · Substantial damage NTSB ANC69D0063Accident · No injuriesClosedLake LA-4 · Fairbanks, AKSep 29, 1968 · N7604L · Substantial damage NTSB ANC69F0060Accident · No injuriesClosedPiper PA-14 · Talkeetna, AKSep 22, 1968 · N5116H · Substantial damage NTSB ANC69D0053Accident · No injuriesClosedPiper PA-12 · Soldotna, AKSep 22, 1968 · N4316M · Substantial damage NTSB ANC69F0068Accident · Minor injuriesClosedPiper PA-22 · Mcgrath, AKSep 20, 1968 · N3319Z · Substantial damage NTSB ANC69D0084Accident · No injuriesClosedPiper J4E · Fairbanks, AKSep 20, 1968 · N38068 · Substantial damage NTSB ANC69D0073Accident · No injuriesClosedPiper PA-20 · Nabesna, AKSep 20, 1968 · N7755K · Destroyed NTSB ANC69D0074Accident · No injuriesClosedPiper PA-18 · Montague Isl, AKSep 16, 1968 · N3910Z · Substantial damage NTSB ANC69D0055Accident · No injuriesClosedCessna 180 · Kenai, AKSep 16, 1968 · N2991A · Destroyed NTSB ANC69D0034Accident · No injuriesClosedCessna 170B · Talkeetna, AKSep 14, 1968 · N2580D · Substantial damage NTSB ANC69A0018Accident · 2 fatalClosedPiper PA-12 · Skwentna, AKSep 14, 1968 · N3595M · Destroyed