NTSB investigations, 1976, 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\") = 1976
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") = 1976 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 ANC77FAA08Accident · No injuriesClosedCessna 170B · Fairbanks, AKNTSB ANC77DAD02Accident · No injuriesClosedCessna 180 · Juneau, AKNTSB ANC77DA018Accident · 2 fatalClosedCessna A185F · Nondalton, AKNTSB ANC77FA017Accident · Serious injuriesClosedBell 206L · Anchorage, AKNTSB ANC77DAG19Accident · Minor injuriesClosedCessna 180 · Soldotna, AKNTSB ANC77DAG20Accident · No injuriesClosedPiper PA-18 · Cordova, AKNTSB ANC77FA014Accident · Minor injuriesClosedBeech E18S · Anchorage, AKNTSB ANC77FAA07Accident · Minor injuriesClosedHiller FH1100 · Circle, AKNTSB ANC77DA013Accident · No injuriesClosedCessna 170B · Beaver, AKNTSB ANC77DA016Accident · No injuriesClosedCessna 206 · Kotzebue, AKNTSB ANC77FA012Accident · 2 fatalClosedBeech E90 · Tok, AKNTSB ANC77DAD01Accident · No injuriesClosedPiper PA-28 · Skagway, AKNTSB ANC77DAG12Accident · No injuriesClosedPiper PA-18 · Seward, AKNTSB ANC77DAG18Accident · No injuriesClosedCessna 170A · Sutton, AKNTSB ANC77DA011Accident · 1 fatalClosedCessna 206 · Kotzebue, AKNTSB ANC77FAA06Accident · No injuriesClosedCessna 185F · North Pole, AKNTSB ANC77DA022Accident · No injuriesClosedCessna 185 · Hyder, AKNTSB ANC77FA009Accident · No injuriesClosedCessna U206 · Helmricks Camp, AKNTSB ANC77DA007Accident · Serious injuriesClosedBell 206B · Flaxman Island, AKNTSB ANC77DAG16Accident · Serious injuriesClosedStinson 108-3 · Aleknagik, AKNTSB ANC77DA008Accident · No injuriesClosedSwearingen SA26AT · King Salmon, AKNTSB ANC77DAH10Accident · No injuriesClosedToady II · Anchorage, AKNTSB ANC77DA006Accident · Serious injuriesClosedCessna 206 · Tuntutuliak, AKNTSB ANC77DAA05Accident · No injuriesClosedCessna 185 · Wiseman, AKNTSB ANC77DA005Accident · No injuriesClosedCessna 185 · Ambler, AKNTSB ANC76DAH09Accident · No injuriesClosedCessna 150 · Summit, AKNTSB ANC77DAG14Accident · No injuriesClosedPiper PA-18 · Mccarthy, AKNTSB ANC77DAA04Accident · No injuriesClosedBeech D17S · Northway, AKNTSB ANC77DAG13Accident · Serious injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC76DAA69Accident · No injuriesClosedStinson 108-3 · Nenana, AKNTSB ANC77DAA03Accident · No injuriesClosedCessna 172M · Ambler, AKNTSB ANC77DAH07Accident · Serious injuriesClosedPiper PA-18 · Tok, AKNTSB ANC77DAH05Accident · No injuriesClosedHelio Acft H-391B · Anchorage, AKNTSB ANC77DAH06Accident · No injuriesClosedPiper PA-18 · Kenai, AKNTSB ANC77DAH03Accident · No injuriesClosedGrum Amer AA-5 · Talketna, AKNTSB ANC76AA003Accident · No injuriesClosedBell 206B · Valdez, AKNTSB ANC77DA002Accident · No injuriesClosedCessna 172 · Lower Kalskag, AKNTSB ANC77DAH04Accident · No injuriesClosedPiper PA-18 · Skwentna, AKNTSB ANC77DAG21Accident · No injuriesClosedCessna 150 · Kodiak, AKNTSB ANC77DAA02Accident · No injuriesClosedCessna 150 · Galena, AKNTSB ANC77DAH02Accident · No injuriesClosedPiper PA-18 · Gunsight Mtn, AKNTSB ANC77DAG22Accident · No injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC77DAH08Accident · Serious injuriesClosedPiper J3C · Sheep Mtn, AKNTSB ANC77DAG23Accident · No injuriesClosedCessna 170 · Montague Is, AKNTSB ANC77AAH01Accident · No injuriesClosedTaylorcraft BCS-65 · Palmer, AKNTSB ANC76DA001Accident · No injuriesClosedCessna 185 · Kipnuk, AKNTSB ANC76AAH87Accident · No injuriesClosedDehavilland DHC-3 · Eureka, AKNTSB ANC76AA142Accident · 1 fatalClosedPiper PA-28R · Juneau, AKNTSB ANC76FAH78Accident · No injuriesClosedCessna U206 · Egegik, AKNTSB ANC76DAA63Accident · No injuriesClosedCessna 210 · Tanana, AK