NTSB investigations, 1975, 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\") = 1975
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") = 1975 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 ANC76AA056Accident · 2 fatalClosedBellanca 7GCAA · Soldotna, AKNTSB ANC76AA057Accident · No injuriesClosedCessna 180 · Pilot Station, AKNTSB ANC76DAG28Accident · Minor injuriesClosedAeronca 11AC · Telida, AKNTSB ANC76DAA22Accident · No injuriesClosedChampion 7ECA · Mckinley Park, AKNTSB ANC76AA054Accident · 1 fatalClosedBellanca 7GCBC · Bettles, AKNTSB ANC76AA053Accident · 1 fatalClosedBellanca 8GCBC · Fairbanks, AKNTSB ANC76AA056Accident · Serious injuriesClosedBoeing 747 · Anchorage, AKNTSB ANC76AA051Accident · Minor injuriesClosedCessna 180 · Akiachak, AKNTSB ANC76DAG74Accident · No injuriesClosedCessna 180 · Cordova, AKNTSB ANC76AA050Accident · No injuriesClosedCessna 180 · Dillingham, AKNTSB ANC76AA055Accident · No injuriesClosedCessna 207 · Marshall, AKNTSB ANC76DAG72Accident · No injuriesClosedCessna 170B · Homer, AKNTSB ANC76DAG69Accident · No injuriesClosedHelio Acft H-250 · St.Marys, AKNTSB ANC76DAG68Accident · No injuriesClosedCessna 150 · Karluk, AKNTSB ANC76DAG67Accident · No injuriesClosedPiper PA-12 · Skwentna, AKNTSB ANC76AAG71Accident · Minor injuriesClosedStinson 108 · Port Alsworth, AKNTSB ANC76AA049Accident · No injuriesClosedDouglas DC-3 · Kenai, AKNTSB ANC76DAG64Accident · No injuriesClosedMaule M-4210 · Anchorage, AKNTSB ANC76AA048Accident · 3 fatalClosedPiper PA-18 · Willow, AKNTSB ANC76AA047Accident · 3 fatalClosedCessna 185 · Anchorage, AKNTSB ANC76DAG66Accident · No injuriesClosedCessna 177 · Port Lyons, AKNTSB ANC76FAG62Accident · No injuriesClosedHelio Acft H-250 · Anchorage, AKNTSB ANC76FAG63Accident · No injuriesClosedCessna 206 · Anchorage, AKNTSB ANC76DAG61Accident · No injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC76DAG58Accident · No injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC76DAG57Accident · Minor injuriesClosedLuscombe 8A · Willow, AKNTSB ANC76DAG60Accident · Minor injuriesClosedLake LA-4 · Paxson, AKNTSB ANC76DAG56Accident · No injuriesClosedStinson 108-2 · Gulkana, AKNTSB ANC76DAG52Accident · No injuriesClosedPiper PA-18 · Sleetmute, AKNTSB ANC76AA046Accident · 2 fatalClosedLake LA-4 · Skagway, AKNTSB ANC76AA044Accident · No injuriesClosedBell 206 · Kenai, AKNTSB ANC76DAG55Accident · No injuriesClosedChampion 7EC · Homer, AKNTSB ANC76FAG51Accident · No injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC76DAG59Accident · No injuriesClosedPiper PA-18 · Kodiak, AKNTSB ANC76AAG70Accident · No injuriesClosedPiper PA-18 · Iliamna, AKNTSB ANC7LFAG50Accident · No injuriesClosedCessna 170 · Palmer, AKNTSB ANC76DAA20Accident · No injuriesClosedPiper PA-18 · Kaktovik, AKNTSB ANC76DAG48Accident · No injuriesClosedCessna 180 · Palmer, AKNTSB ANC76DAG54Accident · No injuriesClosedCessna 185 · Tahneta Lake, AKNTSB ANC76DAA21Accident · No injuriesClosedPiper PA-12 · Teller, AKNTSB ANC76DAG41Accident · No injuriesClosedCessna 170B · Sparrevohn, AKNTSB ANC76AA045Accident · No injuriesClosedCessna 170 · Bethel, AKNTSB ANC76AA042Accident · No injuriesClosedHelio Acft H-250 · Teller, AKNTSB ANC76DAG47Accident · No injuriesClosedMaule M-5 · Mt Susitna, AKNTSB ANC76DAG44Accident · No injuriesClosedMaule M-5 · Talkeetna, AKNTSB ANC76AA041Accident · No injuriesClosedHiller Acft UH-12A · Nome, AKNTSB ANC76DAG43Accident · No injuriesClosedCessna 180 · Nondalton, AKNTSB ANC76AA040Accident · No injuriesClosedDehavilland DHC-3 · Kuskokwim Rvr, AKNTSB ANC76DAG49Accident · No injuriesClosedStinson 108-3 · Port Alsworth, AKNTSB ANC76DAG45Accident · No injuriesClosedPiper PA-18 · Mcgrath, AK