NTSB investigations, 1965, MN
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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
| 1964 | 113 |
|---|---|
| 1965 | 115 |
| 1966 | 117 |
| 1967 | 130 |
| 1968 | 95 |
| 1969 | 113 |
| 1970 | 88 |
| 1971 | 80 |
| 1972 | 82 |
| 1973 | 77 |
| 1974 | 83 |
| 1975 | 98 |
| 1976 | 78 |
| 1977 | 92 |
| 1978 | 98 |
| 1979 | 76 |
| 1980 | 66 |
| 1981 | 89 |
| 1982 | 61 |
| 1983 | 68 |
| 1984 | 51 |
| 1985 | 57 |
| 1986 | 43 |
| 1987 | 40 |
| 1988 | 52 |
| 1989 | 50 |
| 1990 | 42 |
| 1991 | 59 |
| 1992 | 25 |
| 1993 | 40 |
| 1994 | 39 |
| 1995 | 37 |
| 1996 | 40 |
| 1997 | 37 |
| 1998 | 36 |
| 1999 | 33 |
| 2000 | 39 |
| 2001 | 40 |
| 2002 | 46 |
| 2003 | 40 |
| 2004 | 32 |
| 2005 | 31 |
| 2006 | 29 |
| 2007 | 25 |
| 2008 | 31 |
| 2009 | 29 |
| 2010 | 32 |
| 2011 | 28 |
| 2012 | 28 |
| 2013 | 33 |
| 2014 | 24 |
| 2015 | 15 |
| 2016 | 26 |
| 2017 | 20 |
| 2018 | 14 |
| 2019 | 16 |
| 2020 | 26 |
| 2021 | 12 |
| 2022 | 24 |
| 2023 | 34 |
| 2024 | 24 |
| 2025 | 22 |
| 2026 | 13 |
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\") = 1965
AND c.\"eventStateOrRegion\" = 'MN' 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") = 1965 AND c."eventStateOrRegion" = 'MN' 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 MKC66F0346Accident · No injuriesClosedPiper PA-22 · Park Rapids, MNNTSB MKC66F0342Accident · No injuriesClosedCessna 140 · Monticello, MNNTSB MKC66F0343Accident · No injuriesClosedBeechcraft 23 · So St Paul, MNNTSB MKC66F0410Accident · No injuriesClosedPiper PA-12 · Lake Elmo, MNNTSB MKC66D0376Accident · No injuriesClosedCessna 170A · New Ulm, MNNTSB MKC66F0378Accident · No injuriesClosedCessna 120 · Eveleth, MNNTSB MKC66F0315Accident · No injuriesClosedCessna 310H · Hopkins, MNNTSB MKC66F0332Accident · No injuriesClosedAero Cmdr 520 · Minneapolis, MNNTSB MKC66F0331Accident · No injuriesClosedCessna 170 · So St Paul, MNNTSB MKC66F0391Accident · Minor injuriesClosedBeech N35 · Madison, MNNTSB MKC66F0358Accident · Serious injuriesClosedChampion 7DC · White Bea, MNNTSB MKC66D0308Accident · No injuriesClosedCessna 172 · Maple Plain, MNNTSB MKC66D0361Accident · No injuriesClosedLitton Stms 213-1 · St Paul, MNNTSB MKC66A0028Accident · 1 fatalClosedPiper PA-28 · Fairfax, MNNTSB MKC66D0311Accident · No injuriesClosedCessna 150 · Rochester, MNNTSB MKC66A0025Accident · 1 fatalClosedCessna 180 · Bemidji, MNNTSB MKC66A0024Accident · 1 fatalClosedSr.Aero SPT D-260 · Hamel, MNNTSB MKC66F0307Accident · No injuriesClosedPiper PA-28 · Duluth, MNNTSB MKC66F0273Accident · No injuriesClosedPiper J3L-S · Excelsior, MNNTSB MKC66F0254Accident · No injuriesClosedCessna 170A · So St Paul, MNNTSB MKC66F0285Accident · No injuriesClosedPiper J3-S · Baudette, MNNTSB MKC66F0269Accident · Serious injuriesClosedCessna 150 · N.Greenwald, MNNTSB MKC66F0261Accident · No injuriesClosedPiper PA-28 · Sebeka, MNNTSB MKC66D0266Accident · No injuriesClosedCessna 140 · Melrose, MNNTSB MKC66A0016Accident · 1 fatalClosedAir Space 18A · Anoka, MNNTSB MKC66F0251Accident · No injuriesClosedCessna 150 · Mound, MNNTSB MKC66F0293Accident · Minor injuriesClosedBeechcraft C-18S · Interntl Fls, MNNTSB MKC66A0013Accident · No injuriesClosedBell 47G3B1 · Altura, MNNTSB MKC66F0208Accident · 1 fatalClosedPiper PA-28 · Brainerd, MNNTSB MKC66D0233Accident · No injuriesClosedBeechcraft C-35 · So St Paul, MNNTSB MKC66F0200Accident · No injuriesClosedPiper PA-24 · Park Rapids, MNNTSB MKC66D0242Accident · No injuriesClosedPiper PA-18A · Fairmont, MNNTSB MKC66F0194Accident · Minor injuriesClosedPiper PA-28 · Minneapolis, MNNTSB MKC66F0239Accident · Minor injuriesClosedChampion 7GC · Silver Bay, MNNTSB MKC66F0238Accident · No injuriesClosedCessna 170 · Cottonwood, MNNTSB MKC66F0217Accident · Minor injuriesClosedBeechcraft 23 · Lake City, MNNTSB MKC66A0009Accident · 1 fatalClosedChampion 7ECA · 3n Floodwood, MNNTSB MKC66F0294Accident · No injuriesClosedTaylorcraft BC-12D · So St Paul, MNNTSB MKC66D0235Accident · No injuriesClosedBoeing A75N1 · Maynard, MNNTSB MKC66F0209Accident · No injuriesClosedBeechcraft A23 · Rochester, MNNTSB MKC66A0008Accident · 2 fatalClosedAeronca 7AC · Forest Alke, MNNTSB MKC66D0183Accident · No injuriesClosedPiper PA-12 · Pipestone, MNNTSB MKC66F0210Accident · No injuriesClosedPiper PA-28 · Minneapolis, MNNTSB MKC66D0182Accident · No injuriesClosedRepublic RC-3 · Onamia, MNNTSB MKC66F0201Accident · No injuriesClosedCessna 140 · Robbinsdale, MNNTSB MKC66F0226Accident · No injuriesClosedAeronca 7AC · Detroit Laks, MNNTSB MKC66F0180Accident · No injuriesClosedCessna 172 · So St Paul, MNNTSB MKC66F0263Accident · No injuriesClosedPiper PA-22 · Gaylord, MNNTSB MKC66D0203Accident · No injuriesClosedCessna 310 · Backus, MNNTSB MKC66F0159Accident · No injuriesClosedCessna 180 · Bigfork, MN