NTSB investigations, 1980, 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
| 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
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\") = 1980
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") = 1980 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 ANC81DA013Accident · 1 fatalClosedAero Comdr 680-FL · Gambell, AKNTSB ANC81FA012Accident · Serious injuriesClosedCessna 180 · Wasilla, AKNTSB ANC81DAD02Accident · No injuriesClosedCessna 180 · St. John'S Hbr, AKNTSB ANC81FA010Accident · Serious injuriesClosedCessna 207 · Pilot Station, AKNTSB ANC81DA009Accident · No injuriesClosedCessna 185 · Kasigluk, AKNTSB ANC81IA011Incident · Minor injuriesClosedC.A.S.A. C-212 · Deadhorse, AKNTSB ANC81FA008Accident · 4 fatalClosedPiper PA-32 · Cold Bay, AKNTSB ANC81DAG15Accident · No injuriesClosedCessna 180 · Whittier, AKNTSB ANC81DAG13Accident · Minor injuriesClosedMaule M-5 · Anchorage, AKNTSB ANC81DAA07Accident · Serious injuriesClosedCessna T210G · Ruby, AKNTSB ANC81DA006Accident · No injuriesClosedCessna 185 · Fort Yukon, AKNTSB ANC80FA010Accident · Serious injuriesClosedBell 206B · Pilot Point, AKNTSB ANC81DA005Accident · No injuriesClosedBell 206L · Atmauthluk, AKNTSB ANC81DAG12Accident · No injuriesClosedCessna 170B · Cold Bay, AKNTSB ANC81DAG10Accident · No injuriesClosedHughes 269A · Goose Bay, AKNTSB ANC81DAA05Accident · Minor injuriesClosedCessna 150 · Gold King Crk, AKNTSB ANC81DAG06Accident · No injuriesClosedCessna 185 · St Marys, AKNTSB ANC81FA004Accident · 2 fatalClosedCessna U20GF · Deadhorse, AKNTSB ANC81DAG07Accident · No injuriesClosedPiper PA-32 · Simeonof Is, AKNTSB ANC81DAG11Accident · No injuriesClosedPiper PA-18 · Iliamna, AKNTSB ANC81DAG04Accident · Minor injuriesClosedPiper PA-22 · Tulakes, AKNTSB ANC81DA003Accident · No injuriesClosedCessna 170B · Fort Yukon, AKNTSB ANC81DA002Accident · Minor injuriesClosedCessna 206 · Pilot Point, AKNTSB ANC81DAA04Accident · Serious injuriesClosedStinson 108-3 · Nenana, AKNTSB ANC81FA001Accident · 1 fatalClosedCessna 185F · Le Duc Lake, AKNTSB ANC81FAG03Accident · Serious injuriesClosedCessna 180 · Big Lake, AKNTSB ANC81DAD01Accident · Serious injuriesClosedAeronca 7AC · Haines, AKNTSB ANC81DAA02Accident · Minor injuriesClosedCessna 180 · Arctic Village, AKNTSB ANC81DAA01Accident · Minor injuriesClosedBeech E18S · Candle, AKNTSB ANC81DAG01Accident · Minor injuriesClosedCessna 180J · Girdwood, AKNTSB ANC80FA104Accident · 2 fatalClosedBellanca 7GCBC · Anchorage, AKNTSB ANC80DA106Accident · No injuriesClosedDehavnd Can DHC-2 · Tatitna, AKNTSB ANC80DA105Accident · Minor injuriesClosedCessna 207 · Levelock, AKNTSB ANC80FA103Accident · Serious injuriesClosedRobertson 207A · Nikiski, AKNTSB ANC80DAA28Accident · No injuriesClosedCessna 170 · Arctic Village, AKNTSB ANC81DAG05Accident · Minor injuriesClosedTaylorcraft BC12-D · Chugiak, AKNTSB ANC80DAH13Accident · No injuriesClosedCessna 172 · Anchorage, AKNTSB ANC80FA102Accident · 2 fatalClosedPiper PA-18 · Anchorage, AKNTSB ANC80DAH14Accident · No injuriesClosedCessna 180 · Mccarthy, AKNTSB ANC81DAG17Accident · Serious injuriesClosedPiper PA-11 · Kenai, AKNTSB ANC81DAG02Accident · No injuriesClosedDehavilland DHC-2 · Twin Lakes, AKNTSB ANC81DAG09Accident · No injuriesClosedPiper PA-14 · Talkeetna, AKNTSB ANC80DA100Accident · Minor injuriesClosedCessna 207A · Karluk, AKNTSB ANC80FA101Accident · 3 fatalClosedCessna 172M · Lime Peak, AKNTSB ANC80DAH05Accident · No injuriesClosedCessna U206G · Dillingham, AKNTSB ANC80FA099Accident · Serious injuriesClosedCessna 207 · Fairbanks, AKNTSB ANC80DAA23Accident · Minor injuriesClosedCessna A185F · Bettles, AKNTSB ANC80DAH06Accident · No injuriesClosedLake 4-200 · Anchorage, AKNTSB ANC80DAA27Accident · No injuriesClosedMaule M-5 · Big Delta, AKNTSB ANC80DAH09Accident · Minor injuriesClosedPiper PA-18 · King Salmon, AK