NTSB investigations, 2005, MT
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
| 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\") = 2005
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") = 2005 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 SEA06LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Butte, MTThe pilot's failure to maintain clearance from the terrain during low-level maneuvering at night. Factors included the pilot’s improper in-flight decision to continue into an area that was forecasted to possibly contain snow, fog, and low ceilings. Additional…NTSB SEA06FA022Accident · 1 fatalField investigationFinal reportCessna 425 · Belgrade, MTThe pilot's failure to maintain airspeed during the approach which resulted in an inadvertent stall. Factors associated with the accident were dark night conditions, clouds, icing conditions, low visibility and snow.NTSB SEA05LA189Accident · No injuriesLimited investigationFinal reportBallhagen/Shyrock Q-2 · Kalispell, MTThe pilot/owner's improper setting of the engine's valve clearance, leading to the failure of the exhaust valves to fully close and a total loss of power while on a VFR downwind, and the pilot/owner's failure to maintain sufficient airspeed as he tried to…NTSB SEA05LA176Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Helena, MTThe loss of engine power for undetermined reasons, which resulted in a forced landing and nose over. A factor contributing to the accident was the ground bordering the runway pavement.NTSB SEA05CA149Accident · Minor injuriesData collectionFinal reportHughes 269A · Laurel, MTthe pilot's failure to maintain rotor rpm while executing a pinnacle approach, which resulted in a loss of control and collision with terrain.NTSB SEA05CA148Accident · No injuriesData collectionFinal reportPiper PA-16 · Park City, MTThe failure of the pilot to maintain directional control of the airplane on the takeoff roll. Factors contributing to the accident included the loose gravel, ditch, and the fence.NTSB SEA05CA135Accident · No injuriesData collectionFinal reportCessna 170B · Laurel, MTThe flight instructor's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop. A contributing factor was the flight instructor's diverted attention to talking with the student.NTSB SEA05FA124Accident · Serious injuriesField investigationFinal reportCessna 320E · Missoula, MTTerrain clearance was not possible as a result of a right engine failure. Factors contributing to the accident included the rising terrain, foreign material being ingested into the engine's turbocharger, which obstructed the turbocharger's impeller, the…NTSB SEA05LA121Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Fairview, MTWhile in cruise flight a separation of a propeller blade as a result of a propeller hub crack. Factors contributing to the accident included the installation of an unapproved propeller, and the failure to properly service the propeller with red dyed oil for…NTSB SEA05LA120Accident · No injuriesLimited investigationFinal reportMBB BO-105 · Billings, MTThe pilot's improper in-flight decision to continue a simulated engine-out autorotation after sensing an excessive descent rate at 100 feet above the ground. Factors include the excessive descent rate, variable winds, and a high density altitude.NTSB SEA05CA117Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Geraldine, MTThe pilot's failure to maintain clearance with rising terrain. Rising terrain was a factor.NTSB SEA05CA109Accident · No injuriesData collectionFinal reportJackson Rans S-6S · Laurel, MTThe flight instructor's inadequate remedial action which resulted in a stall/spin during final approach to land. A contributing factor was the student pilot's failure to maintain adequate airspeed during the landing approach.NTSB SEA05LA100Accident · No injuriesLimited investigationFinal reportCessna 152TW · Missoula, MTThe pilot's failure to maintain clearance from a taxiway identification sign as he attempted to turn off the runway onto the taxiway during the last part of the landing roll. Factors include a taxiway identification sign in the vicinity of the intersection of…NTSB SEA05FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Kalispell, MTLoss of aircraft control during climb while in instrument meteorological conditions. Icing conditions was a factor.NTSB SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.NTSB SEA05LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kalispell, MTAn airborne fire which was fueled by leaking hydraulic fluid (the ignition source for the fire was undetermined) from the landing gear hydraulic system located under the cockpit instrument panel due to inadequate maintenance from other maintenance personnel.…NTSB SEA05CA083Accident · No injuriesData collectionFinal reportHughes 269A · Whitefish, MTThe student pilot's failure to maintain control of the helicopter while hovering resulting in an in-flight collision with terrain. Gusting winds and the student pilot's inadequate compensation for the wind conditions were contributing factors.NTSB SEA05LA066Accident · No injuriesLimited investigationFinal reportAbbott Glasair Legend · Cascade, MTThe accumulation of wet snow on the engine inlet assembly protection screen during a rapid increase in outside air temperature, while on an instrument approach for landing. Factors include falling snow, a sudden and significant increase in outside air…NTSB SEA05CA050Accident · No injuriesData collectionFinal reportAviat Husky A-1 · Kalispell, MTThe pilot's failure to maintain clearance from a tree located off the departure end of his private airstrip during an aborted landing attempt. Factors include trees located near the departure end of the runway.NTSB SEA05LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Superior, MTA loss of engine power due to the pilot's inadequate planning/decision and improper fuel management, which resulted in fuel starvation. A contributing factor was the berm.NTSB SEA05CA033Accident · No injuriesData collectionFinal reportCessna 180 · Billings, MTThe pilot's improper flare and his failure to maintain aircraft control. The pilot's improper recovery from a bounced landing is a contributing factor.