NTSB investigations, 1964, 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\") = 1964
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") = 1964 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 UNK65X1141Accident · No injuriesClosedPiper PA22 · Silver Lake, MNNTSB UNK65X1140Accident · No injuriesClosedCessna 180 · So St Paul, MNNTSB UNK65X1105Accident · 1 fatalClosedPiper PA-22 · Winona, MNNTSB UNK65X1093Accident · 3 fatalClosedBeechcraft 95-B55 · Good Thunder, MNNTSB UNK65X1072Accident · No injuriesClosedPiper PA22 · St Cloud, MNNTSB UNK65X1070Accident · No injuriesClosedAeronca 11AC · Gerogetown, MNNTSB UNK65X1054Accident · No injuriesClosedAeronca 7GCM · Cloquet, MNNTSB UNK65X1012Accident · No injuriesClosedPiper PA12 · Littlefork, MNNTSB UNK65X0995Accident · No injuriesClosedCessna 170A · Rosemount, MNNTSB UNK65X0969Accident · Serious injuriesClosedAeronca 7AC · Le Sueur, MNNTSB UNK65X0955Accident · No injuriesClosedCessna 310B · Hopkins, MNNTSB UNK65X0781Accident · No injuriesClosedPiper PA22 · Sleepy Eye, MNNTSB UNK65X0689Accident · No injuriesClosedCessna 180 · St Paul, MNNTSB UNK65X0667Accident · No injuriesClosedBeechcraft 35B33 · Minneapolis, MNNTSB UNK65X0658Accident · No injuriesClosedCessna 150 · Minneapolis, MNNTSB UNK65X0611Accident · No injuriesClosedCessna 180 · Leech Lake, MNNTSB UNK65X0585Accident · 1 fatalClosedCessna 170B · Wabasso, MNNTSB UNK65X0567Accident · Minor injuriesClosedErcoupe 415C · Isle, MNNTSB UNK65X0547Accident · Serious injuriesClosedHughes 269B · Owatonna, MNNTSB UNK65X0528Accident · No injuriesClosedCessna 182 · Anoka, MNNTSB UNK65X0441Accident · 1 fatalClosedBeechcraft N-35 · Brainerd, MNNTSB UNK65X0417Accident · Minor injuriesClosedGrumman F6F5 · Minneapolis, MNNTSB UNK65X0247Accident · 5 fatalClosedMooney M-20A · Cambridge, MNNTSB UNK65X0237Accident · Minor injuriesClosedPiper PA18A · Fergus Falls, MNNTSB UNK65X0208Accident · No injuriesClosedPiper PA28 · Duluth, MNNTSB UNK65X0168Accident · No injuriesClosedPiper J5A · Stanton, MNNTSB UNK64X4187Accident · No injuriesClosedStinson 108 · Grand Portage, MNNTSB UNK64X4152Accident · No injuriesClosedCessna 182 · Murdock, MNNTSB UNK64X4140Accident · No injuriesClosedLuscombe 8F · Isabella, MNNTSB UNK64X4067Accident · No injuriesClosedBeechcraft 23 · St Paul, MNNTSB UNK64X4031Accident · No injuriesClosedPiper PA22 · Marshall, MNNTSB UNK64X3993Accident · No injuriesClosedPiper PA22 · Gaylord, MNNTSB UNK64X3973Accident · No injuriesClosedCessna 140 · Rosemount, MNNTSB UNK64X3878Accident · 1 fatalClosedBeechcraft D-18S · Deer River, MNNTSB UNK64X3863Accident · Serious injuriesClosedBoeing B-720 · Minneapolis, MNNTSB UNK64X3840Accident · No injuriesClosedPiper PA20 · Grove City, MNNTSB UNK64X3751Accident · No injuriesClosedCessna 180 · Circle Pines, MNNTSB UNK64X3705Accident · Serious injuriesClosedPiper PA25 · Prior Lake, MNNTSB UNK64X3652Accident · No injuriesClosedCessna 310H · Hopkins, MNNTSB UNK64X3566Accident · Serious injuriesClosedCessna 140 · Virginia, MNNTSB UNK64X3523Accident · Serious injuriesClosedBarnes 65A · Minneapolis, MNNTSB UNK64X3422Accident · No injuriesClosedCessna 170 · East Bethel, MNNTSB UNK64X3389Accident · No injuriesClosedCessna 150 · Bowlus, MNNTSB UNK64X3353Accident · No injuriesClosedBoeing A75N1 · Waseca, MNNTSB UNK64X3194Accident · No injuriesClosedCessna 140 · Minneapolis, MNNTSB UNK64X3181Accident · No injuriesClosedLake LA4 · Lake Elmo, MNNTSB UNK64X2970Accident · No injuriesClosedBeechcraft P35 · Faribault, MNNTSB UNK64X2927Accident · No injuriesClosedCessna 310B · Grand Rapids, MNNTSB UNK64X2907Accident · No injuriesClosedCessna 150 · Oslo, MNNTSB UNK64X2888Accident · Serious injuriesClosedBeechcraft 35A33 · Int L Falls, MN