NTSB investigations, 2021, MT
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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 | 16 |
Where
Open the mapLatest 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\") = 2021
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") = 2021 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 WPR22LA056Accident · No injuriesClass 4 · LimitedFinal reportMonte Clark Vans RV8 · Hamilton, MTThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB WPR22LA024Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · St Ignatius, MTThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA016Accident · No injuriesClass 3 · LimitedFinal reportCessna 180H · Kalispell, MTThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop and a runway excursion.NTSB WPR21FA353Accident · 2 fatalClass 3 · FieldFinal reportBeech S35 · Billings, MTThe pilot’s improper flare, which led to a hard landing, subsequent loss of control, and collision with trees.NTSB WPR21LA313Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 425 · Helena, MTA flameout of both engines due to fuel starvation for reasons that could not be determined due to the airplane’s damage.NTSB WPR21LA315Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14-19-3 · Whitefish, MTA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to accomplish a preflight inspection.NTSB WPR21LA289Accident · Minor injuriesClass 4 · LimitedFinal reportStinson 108-1 · Bozeman, MTThe pilot’s failure to maintain directional control during landing which resulted in a ground loop.NTSB WPR21LA285Accident · No injuriesClass 4 · LimitedFinal reportCessna T210 · Missoula, MTThe pilot's failure to extend the landing gear during landing. Contributing to the accident was the pilot’s failure to use a pre-landing checklist.NTSB WPR21FA258Accident · 2 fatalClass 3 · FieldFinal reportCessna 172R · Missoula, MTThe pilot’s failure to maintain airspeed and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR21LA249Accident · Minor injuriesClass 3 · LimitedFinal reportMooney M20F · Marion, MTThe pilot’s improper rotation during takeoff from a high-altitude airport and his failure to abort the takeoff, which resulted in an impact with trees and terrain. Contributing to the accident was the pilot’s improper management of the turbocharger, which…NTSB WPR21LA239Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · West Glacier, MTThe pilot’s inadequate performance planning and decision to continue the takeoff which, resulted in a runway overrun and collision with terrain.NTSB WPR21LA236Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1H · Townsend, MTThe pilot’s failure to maintain helicopter control after an encounter with settling with power during approach at an altitude that was too low for recovery, which resulted in a hard landing.NTSB WPR21LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Miles City, MTThe pilot’s failure to maintain directional control during takeoff which resulted in a ground loop and collision with terrain.NTSB WPR21LA219Accident · Serious injuriesClass 3 · LimitedFinal reportStoddard Hamilton Glasair II · Darby, MTThe pilot’s impact with terrain during a go-around following an attempted precautionary landing due to a low oil pressure indication. The reason for the low oil pressure indication could not be determined based on the available information.NTSB WPR21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wilsall, MTThe pilot's failure to maintain directional control during the landing roll with a crosswind.NTSB WPR21LA138Accident · No injuriesClass 4 · LimitedFinal reportBurg Frederick S ZEN CH701 · Shepherd, MTThe pilot’s unstable approach, and improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB WPR21LA137Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Three Forks, MTThe pilot’s improper landing flare, which resulted in a loss of directional control, runway excursion and impact with terrain.NTSB WPR21LA096Accident · No injuriesClass 4 · LimitedFinal reportHeckel Super Sportsman · Spotted Bear, MTThe pilot’s failure to maintain aircraft control during the landing roll on an unimproved snow-covered runway which resulted in a nose-over.