NTSB investigations, 1980, 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\") = 1980
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") = 1980 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 CHI81FER10Accident · No injuriesClosedCessna 172N · Excelsior, MNNTSB CHI81FER09Accident · No injuriesClosedBeech A23 · Stanton, MNNTSB CHI81DER08Accident · No injuriesClosedBeech 23 · Alexandria, MNNTSB CHI81FA010Accident · 5 fatalClosedMitsubishi MU-2 · Ramsey, MNNTSB CHI81DER07Accident · No injuriesClosedCessna 150 · Cook, MNNTSB CHI81DER05Accident · No injuriesClosedCessna 172 · Thief River, MNNTSB CHI81DER06Accident · No injuriesClosedCessna 152 · Cloquet, MNNTSB CHI81FER04Accident · Minor injuriesClosedAeronca 11AC · Clyndon, MNNTSB CHI81FER03Accident · No injuriesClosedPiper PA-18 · Brainerd, MNNTSB CHI80DER02Accident · No injuriesClosedPiper PA-28 · Grand Meadows, MNNTSB CHI81FER01Accident · No injuriesClosedGreat Lakes Baby · Whitebear Lake, MNNTSB CHI80FER69Accident · Serious injuriesClosedCameron Viva · Chaska, MNNTSB CHI80DER67Accident · No injuriesClosedPiper PA-32 · Litchfield, MNNTSB CHI80FER59Accident · Minor injuriesClosedHughes 269C · Rockford, MNNTSB CHI80DER58Accident · No injuriesClosedPiper PA-25 · Bingham Lake, MNNTSB CHI80FER66Accident · No injuriesClosedCessna A188B · Garden City, MNNTSB CHI80FER65Accident · No injuriesClosedBeech B19 · Eden Prairie, MNNTSB CHI80FER64Accident · No injuriesClosedCessna 150 · Ogema, MNNTSB CHI80FER61Accident · No injuriesClosedCessna P206 · Blaine, MNNTSB CHI80FER63Accident · Minor injuriesClosedCessna 188 · Long Prairie, MNNTSB CHI80DER62Accident · No injuriesClosedGrumman G-164B · E.Grand Forks, MNNTSB CHI80FER60Accident · 1 fatalClosedCassutt · Winona, MNNTSB CHI80FER56Accident · Serious injuriesClosedBellanca 7GCBC · Duluth, MNNTSB CHI80FER57Accident · No injuriesClosedPiper PA-34 · Albert Lea, MNNTSB CHI80FER54Accident · No injuriesClosedMooney M20 · Blaine, MNNTSB CHI80DER52Accident · Minor injuriesClosedBell OH-13 · Bixby, MNNTSB CHI80FER55Accident · 1 fatalClosedCassutt 111M · Warren, MNNTSB CHI80DER53Accident · No injuriesClosedCessna 172 · Fosston, MNNTSB CHI80FER50Accident · Minor injuriesClosedBell OH-13H · Olivia, MNNTSB CHI80FA048Accident · 4 fatalClosedBeech A35 · Angle Inlet, MNNTSB CHI80FER51Accident · No injuriesClosedCessna A185F · Ely, MNNTSB CHI80FER49Accident · 1 fatalClosedPiper PA-25 · Grove City, MNNTSB CHI80DER48Accident · Serious injuriesClosedPiper PA-28 · Tower, MNNTSB CHI80FER47Accident · Minor injuriesClosedPiper PA-25 · Hector, MNNTSB CHI80DER46Accident · No injuriesClosedCessna 188A · Grygla, MNNTSB CHI80FER44Accident · Minor injuriesClosedHughes 269C · Dexter, MNNTSB CHI80DER43Accident · No injuriesClosedHughes 269C · Willmar, MNNTSB CHI80FER41Accident · Minor injuriesClosedBeech B19 · Mankato, MNNTSB CHI80FA041Accident · 4 fatalClosedCessna 172K · Big Fork, MNNTSB CHI80DA044Accident · 1 fatalClosedCessna 150 · St Paul, MNNTSB CHI80FER40Accident · No injuriesClosedCessna 210 · Minneapolis, MNNTSB CHI80DER39Accident · No injuriesClosedCessna 152 · Minneapolis, MNNTSB CHI80FER42Accident · No injuriesClosedAeronca 7AC · Mora, MNNTSB CHI80FER38Accident · No injuriesClosedPiper PA-22 · Hoffman, MNNTSB MKC80FER37Accident · Serious injuriesClosedFly Baby BWM-10 · Waubun, MNNTSB MKC80DER33Accident · No injuriesClosedBeech C23 · Eveleth, MNNTSB MKC80DER34Accident · No injuriesClosedCessna 185 · Eveleth, MNNTSB MKC80DER35Accident · No injuriesClosedCessna 150 · Rushford, MNNTSB MKC80DER36Accident · No injuriesClosedCessna 180 · Battle Lake, MNNTSB MKC80FA030Accident · 2 fatalClosedCessna 340A · Minneapolis, MN