NTSB investigations, 1970, MT
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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
| 1963 | 2 |
|---|---|
| 1964 | 78 |
| 1965 | 73 |
| 1966 | 87 |
| 1967 | 82 |
| 1968 | 61 |
| 1969 | 56 |
| 1970 | 67 |
| 1971 | 55 |
| 1972 | 46 |
| 1973 | 49 |
| 1974 | 59 |
| 1975 | 61 |
| 1976 | 60 |
| 1977 | 61 |
| 1978 | 57 |
| 1979 | 50 |
| 1980 | 46 |
| 1981 | 52 |
| 1982 | 57 |
| 1983 | 37 |
| 1984 | 38 |
| 1985 | 42 |
| 1986 | 34 |
| 1987 | 27 |
| 1988 | 31 |
| 1989 | 26 |
| 1990 | 32 |
| 1991 | 28 |
| 1992 | 29 |
| 1993 | 25 |
| 1994 | 29 |
| 1995 | 26 |
| 1996 | 23 |
| 1997 | 29 |
| 1998 | 38 |
| 1999 | 24 |
| 2000 | 28 |
| 2001 | 18 |
| 2002 | 25 |
| 2003 | 23 |
| 2004 | 29 |
| 2005 | 21 |
| 2006 | 33 |
| 2007 | 28 |
| 2008 | 20 |
| 2009 | 16 |
| 2010 | 14 |
| 2011 | 21 |
| 2012 | 17 |
| 2013 | 29 |
| 2014 | 21 |
| 2015 | 20 |
| 2016 | 18 |
| 2017 | 12 |
| 2018 | 14 |
| 2019 | 15 |
| 2020 | 19 |
| 2021 | 18 |
| 2022 | 14 |
| 2023 | 16 |
| 2024 | 18 |
| 2025 | 24 |
| 2026 | 15 |
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\") = 1970
AND c.\"eventStateOrRegion\" = 'MT' 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") = 1970 AND c."eventStateOrRegion" = 'MT' 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 SEA71FDG18Accident · No injuriesClosedCessna 205 · Winston, MTNTSB SEA71DDG20Accident · No injuriesClosedCessna 182 · Dutton, MTNTSB SEA71DDA11Accident · No injuriesClosedPiper PA-18 · Garryowen, MTNTSB SEA71FDG19Accident · No injuriesClosedCessna 120 · Whitewater, MTNTSB SEA71FDA08Accident · No injuriesClosedCessna 180H · Billings, MTNTSB SEA71DDA10Accident · No injuriesClosedCessna 150F · Glendive, MTNTSB SEA71DDA09Accident · No injuriesClosedAeronca 7AC · Opheim, MTNTSB DEN71AD020Accident · 5 fatalClosedCessna 180 · Missoula, MTNTSB SEA71DDG17Accident · No injuriesClosedPiper PA-28 · Livingston, MTNTSB SEA71FDG16Accident · Serious injuriesClosedMooney M20F · Cameron, MTNTSB SEA71AS023Accident · 2 fatalClosedPiper PA-14 · Carlyle, MTNTSB SEA71DDG14Accident · Minor injuriesClosedMooney M20C · Melrose, MTNTSB SEA71FDG13Accident · No injuriesClosedCessna 170A · Fort Benton, MTNTSB SEA71DDG11Accident · No injuriesClosedCessna 210 · Missoula, MTNTSB SEA71AS010Accident · 1 fatalClosedMooney M20E · Big Fork, MTNTSB SEA71DDA07Accident · No injuriesClosedTaylorcraft BC12-D · Melstone, MTNTSB SEA71DDG10Accident · No injuriesClosedCessna 172A · Loring, MTNTSB SEA71FDA05Accident · Serious injuriesClosedStinson 108-2 · Red Lodge, MTNTSB SEA71DDA06Accident · No injuriesClosedCessna 180 · Kirby, MTNTSB SEA71FDG09Accident · No injuriesClosedMooney M20A · Libby, MTNTSB SEA71FDA04Accident · No injuriesClosedPiper PA-18A · Garryowen, MTNTSB SEA71FDG15Accident · No injuriesClosedMooney M20E · Kalispell, MTNTSB SEA71FDA02Accident · No injuriesClosedCessna 170B · Billings, MTNTSB SEA71DDG08Accident · Minor injuriesClosedCessna 172 · Butte, MTNTSB SEA71DDA03Accident · No injuriesClosedPiper PA-18 · Lavina, MTNTSB SEA71FDG07Accident · No injuriesClosedLuscombe 8F · Butte, MTNTSB SEA71FDG06Accident · No injuriesClosedBeech J35 · Helena, MTNTSB SEA71FDG05Accident · No injuriesClosedPiper PA-23 · Helena, MTNTSB SEA71DDG04Accident · No injuriesClosedPiper PA-18A · Brady, MTNTSB SEA71FDG03Accident · No injuriesClosedPiper J3 · Cut Bank, MTNTSB SEA71FDA01Accident · No injuriesClosedBeech A-23 · Roundup, MTNTSB SEA71DDG02Accident · No injuriesClosedStinson 108-2 · Floweree, MTNTSB SEA71FDG01Accident · No injuriesClosedPiper PA-25 · Gallatin Gwy, MTNTSB SEA70DDG15Accident · No injuriesClosedPiper PA-32 · Three Forks, MTNTSB SEA70DDG13Accident · No injuriesClosedPiper PA-28 · Fairfield, MTNTSB SEA70FDA16Accident · Serious injuriesClosedPiper PA-18 · Wolf Point, MTNTSB SEA70DDG14Accident · No injuriesClosedCessna 172 · Kremlin, MTNTSB SEA70FDA15Accident · No injuriesClosedCessna 182 · Joliet, MTNTSB SEA70DDA17Accident · No injuriesClosedPiper PA-18 · Poplar, MTNTSB SEA70DDG12Accident · No injuriesClosedCessna 172G · Belgrade, MTNTSB SEA70DDA14Accident · No injuriesClosedCessna 150 · Billings, MTNTSB SEA70FDG11Accident · 1 fatalClosedPiper PA-18 · Turner, MTNTSB SEA70FDA12Accident · No injuriesClosedCallair A-9 · Moore, MTNTSB SEA70FDA11Accident · No injuriesClosedPiper PA-25 · Lindsay, MTNTSB SEA70FDG09Accident · No injuriesClosedHiller Acft UH-12B · Sandcoulee, MTNTSB SEA70FDG08Accident · No injuriesClosedPiper PA-18 · Cascade, MTNTSB SEA70DDA10Accident · No injuriesClosedPiper PA-18 · Sidney, MTNTSB SEA70FDA09Accident · No injuriesClosedPiper PA-28 · Baker, MTNTSB SEA70DDA08Accident · No injuriesClosedPiper PA-25 · Billings, MTNTSB SEA70FDG06Accident · 1 fatalClosedPiper PA-25 · Big Sandy, MT