NTSB investigations, 1967, 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\") = 1967
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") = 1967 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 MKC68D0433Accident · No injuriesClosedCessna 150 · Duluth, MNNTSB MKC68F0408Accident · No injuriesClosedBeech 95-B55 · Hibbing, MNNTSB MKC68F0469Accident · No injuriesClosedPiper PA-24 · Tamarack, MNNTSB MKC68F0391Accident · Minor injuriesClosedCessna 150 · Rosemount, MNNTSB MKC68F0428Accident · No injuriesClosedCessna 310B · St.Paul, MNNTSB MKC68F0371Accident · No injuriesClosedNavion A · Willmar, MNNTSB MKC68D0376Accident · No injuriesClosedCessna 150 · Wykoff, MNNTSB MKC68F0393Accident · Serious injuriesClosedBeech A23 · Askov, MNNTSB MKC68D0359Accident · No injuriesClosedPiper PA-28 · Grand Rapids, MNNTSB MKC68F0363Accident · No injuriesClosedMooney 20E · Winsted, MNNTSB MKC68F0355Accident · Minor injuriesClosedAeronca 15AC · Markville, MNNTSB MKC68D0357Accident · No injuriesClosedCessna 182 · Prior Lake, MNNTSB MKC68F0335Accident · No injuriesClosedPiper PA-12 · Eden Prairie, MNNTSB MKC68F0358Accident · No injuriesClosedCessna 172 · Hill City, MNNTSB MKC68F0360Accident · No injuriesClosedPiper J-3 · St.Charles, MNNTSB MKC68F0314Accident · No injuriesClosedPiper PA-28 · St.Peter, MNNTSB MKC68D0356Accident · No injuriesClosedLuscombe 8A · Circle Pines, MNNTSB MKC68F0333Accident · No injuriesClosedBeech 35 · Minneapolis, MNNTSB MKC68F0311Accident · No injuriesClosedCessna 310 · Crystal, MNNTSB MKC68D0336Accident · No injuriesClosedAeronca 7AC · Buffalo, MNNTSB MKC68F0273Accident · Minor injuriesClosedThorp T-18 · Anoka, MNNTSB MKC68D0361Accident · No injuriesClosedLuscombe 8F · Brainerd, MNNTSB MKC68D0276Accident · No injuriesClosedPiper PA-12 · Pipestone, MNNTSB MKC68D0310Accident · No injuriesClosedChampion 7ECA · Caribou, MNNTSB MKC68F0249Accident · No injuriesClosedMooney M20F · Callaway, MNNTSB MKC68F0286Accident · No injuriesClosedBellanca 14-19 · Lake Elmo, MNNTSB MKC68D0272Accident · No injuriesClosedCessna 150G · Worthington, MNNTSB MKC68F0242Accident · Minor injuriesClosedCessna 172 · Green Isle, MNNTSB MKC68D0289Accident · No injuriesClosedPiper PA-28 · Crystal, MNNTSB MKC68F0241Accident · Serious injuriesClosedCessna 170B · Howard Lake, MNNTSB MKC68D0334Accident · No injuriesClosedCessna 140 · Fairmont, MNNTSB MKC68F0262Accident · No injuriesClosedBeech A23 · Mankato, MNNTSB MKC67F0453Accident · No injuriesClosedPiper PA-28 · Barnesville, MNNTSB MKC68F0260Accident · No injuriesClosedPiper PA-18 · Minneapolis, MNNTSB MKC68F0261Accident · No injuriesClosedCessna 182 · Hopkins, MNNTSB MKC68F0236Accident · Serious injuriesClosedErnst Eaa Biplan · Cambridge, MNNTSB MKC68F0228Accident · Minor injuriesClosedPiper PA-25 · Fairfax, MNNTSB MKC68F0207Accident · No injuriesClosedTaylorcraft BC12-D · Crane Lake, MNNTSB MKC68F0188Accident · No injuriesClosedStits SA3B · Owatonna, MNNTSB MKC68D0225Accident · No injuriesClosedPiper PA-22 · Bemidji, MNNTSB MKC68F0204Accident · Minor injuriesClosedPiper PA-12 · Cloquet, MNNTSB MKC68F0156Accident · Minor injuriesClosedClark 1000 · Owatonna, MNNTSB MKC68F0208Accident · No injuriesClosedPiper PA-14 · Bemidji, MNNTSB MKC68F0191Accident · No injuriesClosedPiper PA-24 · Alexandria, MNNTSB MKC68F0175Accident · Serious injuriesClosedCessna 140 · Two Harbors, MNNTSB MKC68D0471Accident · No injuriesClosedLuscombe 8E · Brainerd, MNNTSB MKC68F0253Accident · No injuriesClosedBellanca 14-19 · Rothsay, MNNTSB MKC68D0205Accident · Minor injuriesClosedCessna 180 · Princeton, MNNTSB MKC68F0112Accident · No injuriesClosedRepublic RC-3 · Nisswa, MNNTSB MKC68F0122Accident · No injuriesClosedMooney M20C · Goodland, MN