NTSB investigations, 1973, 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.
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\") = 1973
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") = 1973 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 ANC74AA050Accident · 2 fatalClosedPiper PA-18 · Glennallen, AKNTSB ANC74FAA23Accident · Minor injuriesClosedCessna 180 · Ft.Yukon, AKNTSB ANC74DAG83Accident · Minor injuriesClosedPiper PA-12 · Anchorage, AKNTSB ANC74DAG85Accident · No injuriesClosedCessna 185 · Illiamna, AKNTSB ANC74FAA24Accident · No injuriesClosedConvair L-13 · Fairbanks, AKNTSB ANC74DAG82Accident · No injuriesClosedChampion 7GCBC · Kodiak, AKNTSB ANC74AA049Accident · 2 fatalClosedPiper PA-18 · Puntilla, AKNTSB ANC74AA047Accident · 3 fatalClosedCessna 180C · Anchorage, AKNTSB ANC74AA046Accident · 1 fatalClosedAero Comdr 560A · Galena, AKNTSB ANC74DAG80Accident · Minor injuriesClosedPiper J-3 · Kodiak, AKNTSB ANC74FAG81Accident · Serious injuriesClosedTaylorcraft BC12-D · Skwentna, AKNTSB ANC74DAG79Accident · No injuriesClosedPiper PA-18 · Talkeetna, AKNTSB ANC74AA045Accident · 3 fatalClosedCessna 170 · Anchorage, AKNTSB ANC74DAA21Accident · No injuriesClosedPiper PA-16 · North Pole, AKNTSB ANC74DAG74Accident · No injuriesClosedPiper PA-20 · Alex Lk Ldge, AKNTSB ANC74AA044Accident · Serious injuriesClosedPiper PA-18 · Anchorage, AKNTSB ANC74DAG78Accident · No injuriesClosedCessna 170B · Skwentna, AKNTSB ANC74DAG77Accident · No injuriesClosedPiper PA-12 · Beluga, AKNTSB ANC74DAG72Accident · No injuriesClosedPiper PA-11 · Alexndr Lake, AKNTSB ANC74AA043Accident · No injuriesClosedDehavilland DHC-3 · Eek, AKNTSB ANC74AA042Accident · No injuriesClosedPiper PA-32 · Port Heiden, AKNTSB ANC74AA041Accident · No injuriesClosedCessna 180 · Chitna, AKNTSB ANC74AA040Accident · 1 fatalClosedCessna 180 · Anchorage, AKNTSB ANC74FAA19Accident · Minor injuriesClosedHiller Acft FH1100 · Fairbanks, AKNTSB ANC74FAG76Accident · No injuriesClosedCessna 150 · Anchorage, AKNTSB ANC74DAG70Accident · No injuriesClosedCessna 185 · Ugashik, AKNTSB ANC74DAG69Accident · No injuriesClosedCessna U206 · Bethel, AKNTSB ANC74DAG68Accident · No injuriesClosedCessna U206 · Akiak, AKNTSB ANC74DAG67Accident · Minor injuriesClosedCessna 185 · Anchorage, AKNTSB ANC74DAG65Accident · No injuriesClosedCessna 305B · Willow, AKNTSB ANC74DAG75Accident · No injuriesClosedCessna 177A · Nikolski, AKNTSB ANC74FAA20Accident · No injuriesClosedBellanca 7GCBC · Fairbanks, AKNTSB ANC74AA039Accident · No injuriesClosedPiper PA-32 · Ugashik, AKNTSB ANC74AA038Accident · Minor injuriesClosedCessna 185 · Ketchikan, AKNTSB ANC74DAG64Accident · No injuriesClosedPiper PA-14 · Anchorage, AKNTSB ANC74AA037Accident · Minor injuriesClosedGrumman G-44 · Kodiak, AKNTSB ANC74DAG63Accident · Minor injuriesClosedCessna 150 · Susitna, AKNTSB ANC74DAG66Accident · Minor injuriesClosedPiper PA-18 · Nondalton, AKNTSB ANC74DAG62Accident · No injuriesClosedSudaviation SA318C · Kenai, AKNTSB ANC74FAG73Accident · Serious injuriesClosedPiper PA-18 · Gulkana, AKNTSB ANC74DAG61Accident · No injuriesClosedPiper PA-18 · Rain Pass Lg, AKNTSB ANC74DAA22Accident · No injuriesClosedCessna 180 · Kotzebue, AKNTSB ANC74DAG60Accident · No injuriesClosedBellanca 7GCBC · Anchorage, AKNTSB ANC74DAG59Accident · No injuriesClosedPiper PA-12 · Anchorage, AKNTSB ANC74DAG57Accident · No injuriesClosedMaule M4220C · Bethel, AKNTSB ANC74AA036Accident · 1 fatalClosedPiper PA-18 · King Salmon, AKNTSB ANC74DAA14Accident · No injuriesClosedPiper PA-20 · Bettles, AKNTSB ANC74FAA15Accident · No injuriesClosedPiper PA-18 · Clear, AKNTSB ANC74DAG58Accident · No injuriesClosedCessna 305 · Susitna, AKNTSB ANC74AA035Accident · 2 fatalClosedCessna 150L · Birchwood, AK