NTSB investigations, 1965, MT
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 1965
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") = 1965 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 SEA66D0188Accident · No injuriesClosedCessna 180 · Babb, MTNTSB SEA66D0203Accident · No injuriesClosedPiper PA-18 · Billings, MTNTSB SEA66D0200Accident · No injuriesClosedAeronca 7AC · Billings, MTNTSB SEA66D0195Accident · No injuriesClosedBellanca 14-13 · Billings, MTNTSB SEA66D0189Accident · No injuriesClosedBeechcraft C33 · Chester, MTNTSB SEA66F0192Accident · No injuriesClosedCessna 320 · Billings, MTNTSB SEA66D0178Accident · No injuriesClosedPiper PA-11 · Lambert, MTNTSB SEA66D0169Accident · No injuriesClosedCessna 210 · Highwood, MTNTSB SEA66F0180Accident · Minor injuriesClosedPiper PA-18A · Huntley, MTNTSB SEA66F0171Accident · No injuriesClosedDehaviland DH-82A · Helena, MTNTSB SEA66A0030Accident · No injuriesClosedBrantly B-2 · Bigfork, MTNTSB SEA66D0161Accident · No injuriesClosedPiper PA-28 · Avon, MTNTSB SEA66A0028Accident · 1 fatalClosedStinson 108-3 · Augusta, MTNTSB SEA66A0027Accident · 1 fatalClosedCessna 140 · Ryegate, MTNTSB SEA66F0190Accident · No injuriesClosedPiper PA-24 · Twin Bridges, MTNTSB SEA66F0148Accident · No injuriesClosedCessna 182F · Broadus, MTNTSB SEA66D0142Accident · Minor injuriesClosedPiper PA-18 · Stanford, MTNTSB SEA66F0122Accident · No injuriesClosedMooney M20C · Red Lodge, MTNTSB SEA66A0022Accident · No injuriesClosedHiller UH-12E · Choteau, MTNTSB SEA66A0021Accident · 2 fatalClosedNavion B · Judith Gap, MTNTSB SEA66F0141Accident · Minor injuriesClosedAeronca 7AC · Ronan, MTNTSB SEA66F0105Accident · No injuriesClosedPiper PA-17 · Deborgia, MTNTSB SEA66F0099Accident · No injuriesClosedLuscombe 8E · W.Yellowston, MTNTSB SEA66A0017Accident · 1 fatalClosedCallair A-9 · 14s Ryegate, MTNTSB SEA66D0104Accident · No injuriesClosedCessna 180 · Livingston, MTNTSB SEA66A0012Accident · No injuriesClosedBell 47G3B1 · Libby, MTNTSB SEA66D0117Accident · No injuriesClosedCessna 120 · Whitefish, MTNTSB SEA66F0066Accident · Serious injuriesClosedLuscombe 8E · Billings, MTNTSB SEA66D0109Accident · No injuriesClosedCessna 140A · Vida, MTNTSB SEA66D0094Accident · No injuriesClosedCessna 182H · Butte, MTNTSB SEA66A0009Accident · 1 fatalClosedCallair S-1A · 8sw Billings, MTNTSB SEA66A0006Accident · 1 fatalClosedNavion G · 30nw Augusta, MTNTSB SEA66D0103Accident · No injuriesClosedCessna 185 · Billings, MTNTSB SEA66D0149Accident · No injuriesClosedBeech C-18S · Willard, MTNTSB SEA66D0076Accident · No injuriesClosedCessna 185A · Livingston, MTNTSB SEA66F0095Accident · No injuriesClosedPiper PA-11 · Molt, MTNTSB SEA66F0046Accident · No injuriesClosedCessna 182 · Darby, MTNTSB SEA66D0077Accident · Minor injuriesClosedPiper PA-18A · Lewistown, MTNTSB SEA66A0002Accident · 1 fatalClosedTaylorcraft BC-12D · Biddle, MTNTSB SEA66F0058Accident · No injuriesClosedCessna 120 · Kalispell, MTNTSB SEA66D0078Accident · No injuriesClosedCessna 180 · Twin Bridges, MTNTSB SEA66D0064Accident · No injuriesClosedCessna 182A · Schafer, MTNTSB SEA66F0032Accident · No injuriesClosedCessna 180H · Devon, MTNTSB SEA65A0068Accident · 1 fatalClosedCessna 210 · Opheim, MTNTSB SEA66F0036Accident · No injuriesClosedPiper J3C-65 · Missoula, MTNTSB SEA66D0065Accident · No injuriesClosedPiper PA-18 · Galata, MTNTSB SEA66D0055Accident · No injuriesClosedPiper PA-18 · Winifred, MTNTSB SEA66F0038Accident · No injuriesClosedPiper J3L · Bloomfield, MTNTSB SEA66F0035Accident · No injuriesClosedCessna 140A · Cut Bank, MTNTSB SEA66D0040Accident · No injuriesClosedCallair A-9 · Boyd, MT