NTSB investigations, 2020, MT
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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
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\") = 2020
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") = 2020 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 WPR21LA067Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Dillon, MTThe student pilot’s exceedance of the airplane’s critical angle attack during an attempted go-around, which resulted in an aerodynamic stall.NTSB WPR21LA032Accident · 1 fatalClass 3 · LimitedFinal reportCessna 172 · Billings, MTThe pilot’s failure to maintain the proper descent glide path while on final approach for reasons that could not be determined from available evidence.NTSB WPR20LA304Accident · 2 fatalClass 3 · LimitedFinal reportCessna 172 · Seeley Lake, MTThe noninstrument-rated pilot’s encounter with instrument meteorological conditions during a night visual approach due to wildfire smoke, which resulted in controlled flight into terrain.NTSB WPR20LA308Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 30 · Billings, MTThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR20LA278Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Harlowton, MTThe pilot’s failure to follow the appropriate takeoff procedures, which resulted in a collision with terrain.NTSB WPR20CA250Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Kalispell, MTThe pilot's excessive speed while landing on a wet grass runway, which resulted in a runway excursion and impact with a fence.NTSB WPR20LA245Accident · 1 fatalClass 3 · LimitedFinal reportCessna 337 · Ennis, MTThe pilot-in-command’s failure to maintain sufficient airspeed while attempting an evasive maneuver from a boxed canyon, which resulted in an aerodynamic stall/spin and impact with mountainous terrain. Contributing to the accident was the pilot-in-command’s…NTSB WPR20LA235Accident · No injuriesClass 3 · LimitedFinal reportMcdonnell Douglas 600 · Thompson Falls, MTA partial loss of engine power for reasons that could not be determined based on available evidence.NTSB WPR20CA217Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Absarokee, MTThe pilot's failure to maintain airplane control during a go-around that resulted in the airplane exceeding its critical angle of attack and aerodynamically stalling which resulted in a collision with the ground.NTSB WPR20CA214Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18A-135 · Marion, MTThe pilot's failure to maintain directional control of the airplane while landing in gusting wind conditions, which resulted in a runway excursion and collision with a fence.NTSB WPR20CA183Accident · No injuriesClass 4 · Data collectionFinal reportCessna 310 · Butte, MTThe pilot's failure to maintain clearance from a fence post during final approach which resulted in a damage to the left main landing gear, and its subsequent collapse during landing.NTSB WPR20CA166Accident · No injuriesClass 4 · Data collectionFinal reportAviat A 1 · Glendive, MTThe pilot's failure to maintain airplane control during landing in gusting wind condition which resulted in a collision with terrain.NTSB WPR20CA173Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Butte, MTThe pilot's failure to maintain airplane control during landing in turbulent conditions.NTSB WPR20CA149Accident · No injuriesClass 4 · Data collectionFinal reportCessna 185 · Winifred, MTAn inadequate flare that resulted in a bounced landing and the pilot's subsequent delayed decision to go-around that did not allow for sufficient clearance from trees when the airplane was affected by a gusting wind.NTSB WPR20LA128Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA31T · Billings, MTThe degraded airplane performance after takeoff for reasons that could not be determined from available evidence.NTSB WPR20CA124Accident · No injuriesData collectionFinal reportCessna 180 · Marion, MTThe pilot's loss of directional control and subsequent improper brake application during the landing roll in gusting wind conditions, which resulted in a nose-over.NTSB WPR20LA068Accident · No injuriesClass 3 · LimitedFinal reportCessna 172Q · Big Timber, MTA loss of engine power during climbout for undetermined reasons.NTSB WPR20FA063Accident · 4 fatalClass 3 · FieldFinal reportCessna TR182 · Billings, MTThe pilot’s failure to maintain clearance due to poor decision making in selecting an unsafe altitude during cruise flight.NTSB WPR20CA066Accident · No injuriesData collectionFinal reportPiper PA 23 · Helena, MTThe pilot's improper decision to attempt an off-airport departure from rough terrain without inspecting the takeoff area, which resulted in a collision with a shallow rut during takeoff and the nose landing gear collapsing.