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
| 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\") = 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.
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
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 ANC78DA008Accident · Serious injuriesClosedShort Bros SC-7 · Toksook Bay, AKNTSB ANC78DAG17Accident · Serious injuriesClosedCessna 185D · Mt.Susitna, AKNTSB ANC78DAG20Accident · No injuriesClosedPiper PA-22 · Talkeenta, AKNTSB ANC78DAG16Accident · No injuriesClosedCessna 180 · Anchorage, AKNTSB ANC78DA007Accident · Minor injuriesClosedCessna 207 · Iliamna, AKNTSB ANC78DA006Accident · No injuriesClosedBeech 65-A80 · Allakaket, AKNTSB ANC78FA005Accident · 2 fatalClosedHiller Acft FH1100 · Anchor Point, AKNTSB ANC78DAG15Accident · No injuriesClosedAeronca 7ECA · Anchorage, AKNTSB ANC78DA004Accident · Minor injuriesClosedBell 206-L · Deadhorse, AKNTSB ANC78FAA03Accident · Minor injuriesClosedCessna 185 · Shaktoolik, AKNTSB ANC78FAD01Accident · 1 fatalClosedCessna 150 · Goddard, AKNTSB ANC78FAA02Accident · No injuriesClosedCessna 150 · Fairbanks, AKNTSB ANC78FA002Accident · 2 fatalClosedMooney M-20C · Northway, AKNTSB ANC78DAG07Accident · No injuriesClosedPiper PA-18 · Dadina River, AKNTSB ANC78DAG08Accident · No injuriesClosedChampion 7GCAA · Cantwell, AKNTSB ANC77DAH50Accident · No injuriesClosedCessna 180 · Thompson Pass, AKNTSB ANC77DAG12Accident · No injuriesClosedPiper PA-18A · Anchorage, AKNTSB ANC78DAG10Accident · No injuriesClosedPiper PA-22 · Dillingham, AKNTSB ANC78DAG09Accident · No injuriesClosedCessna 170B · Bethel, AKNTSB ANC78DAG06Accident · No injuriesClosedPiper PA-18 · Port Hieden, AKNTSB ANC78DAG01Accident · Minor injuriesClosedCessna 150 · Gulkana, AKNTSB MKC77PAG03Accident · No injuriesClosedAeronca 15AC · Anchorage, AKNTSB ANC77DAA62Accident · No injuriesClosedCessna 180 · New Minto, AKNTSB ANC78DAG04Accident · No injuriesClosedPiper PA-18 · Iliamna, AKNTSB ANC77FAA60Accident · No injuriesClosedCessna 180 · Nenana, AKNTSB ANC77FA090Accident · Serious injuriesClosedPiper PA-31B · Lke Minchumina, AKNTSB ANC77DAH36Accident · No injuriesClosedCessna 150M · Soldotna, AKNTSB ANC78DA001Accident · No injuriesClosedCessna U206F · Afognak Isl, AKNTSB ANC77DAA57Accident · Serious injuriesClosedPiper PA-18 · Ft.Yukon, AKNTSB ANC77DAH28Accident · No injuriesClosedLake LA-4 · Turquoise Lake, AKNTSB ANC77DAH40Accident · No injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC77DAH27Accident · No injuriesClosedCessna 180 · Talkeetna, AKNTSB ANC77DAH41Accident · No injuriesClosedPiper PA-12 · Anchorage, AKNTSB ANC77DAH35Accident · No injuriesClosedCessna 170A · Seward, AKNTSB ANC77DAH25Accident · No injuriesClosedPiper PA-18 · Homer, AKNTSB ANC77DAH20Accident · No injuriesClosedCessna 182 · Anchorage, AKNTSB ANC77DAH30Accident · No injuriesClosedPiper PA-18 · Sparrevohn, AKNTSB ANC77DAH21Accident · No injuriesClosedPiper PA-22 · Skwenta, AKNTSB ANC77DAH18Accident · No injuriesClosedBellanca 7ACA · Kasitna Bay, AKNTSB ANC77DA099Accident · No injuriesClosedPiper PA-28R · Port Alsworth, AKNTSB ANC77DAH14Accident · No injuriesClosedMaule M-5 · Hayes River, AKNTSB DCA77AA027Accident · 4 fatalClosedDouglas DC-7BF · Yakutat, AKNTSB ANC77DAH13Accident · No injuriesClosedPiper PA-14 · Iliamna, AKNTSB ANC77DA088Accident · No injuriesClosedHiller Acft 1100 · Sparrevohn Afs, AKNTSB ANC78DAG35Accident · No injuriesClosedCessna A185F · Cordova, AKNTSB ANC77DAH42Accident · No injuriesClosedCessna 180 · Palmer, AKNTSB ANC77DAA51Accident · 1 fatalClosedCessna A185F · Bettles, AKNTSB DCA77AA026Accident · 13 fatalClosedDehavilland DHC-6 · Iliamna, AKNTSB ANC77DAH22Accident · No injuriesClosedCessna 180 · Rainy Pass Lod, AKNTSB ANC77DAH23Accident · No injuriesClosedWillbird 01 · Susitna Lodge, AK