NTSB investigations, 2006, 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\") = 2006
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") = 2006 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 SEA07CA029Accident · No injuriesData collectionFinal reportCessna 172RG · Laurel, MTThe pilot's inadequate compensation for the crosswind conditions during the landing roll, which resulted in a loss of control and subsequent nose over. A contributing factor was the crosswind condition.NTSB SEA07LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Missoula, MTThe student pilot's misjudged distance/speed during final approach, which resulted in an overrun during landing roll and collision with a fence.NTSB SEA07LA020Accident · No injuriesLimited investigationFinal reportCessna 170B · Billings, MTThe flight instructor's inadequate remedial action to maintain directional control, which resulted in a ground loop/swerve during takeoff roll. A factor was the failure of the pilot who was receiving instruction to maintain directional control.NTSB SEA07FA014Accident · No injuriesField investigationFinal reportBell 407 · Kalispell, MTOn-speed failure of the second stage turbine wheel as the result of engine oil starvation. The lack of maintenance oversight was a contributing factor.NTSB SEA07LA002Accident · No injuriesLimited investigationFinal reportCessna 340A · Kalispell, MTThe fracture of the adjusting bellcrank in overstress due to binding in a linkage forward of the bell crank.NTSB SEA06CA191Accident · No injuriesData collectionFinal reportMaule M-6-235 · Ronan, MTThe pilot's failure to maintain directional control during the landing roll in the tailwheel-equipped aircraft. A swale (sunken area) between the runway and the taxiway was a factor.NTSB SEA06CA183Accident · No injuriesData collectionFinal reportCessna 305A · Lewistown, MTThe pilot's failure to maintain aircraft control during landing, which resulted in an inadvertent swerve and nose down. A contributing factor was the gusty wind condition.NTSB SEA06CA182Accident · No injuriesData collectionFinal reportMaule M-4-180V · Lewistown, MTThe airplane inadvertently impacted a coyote hole during the landing roll on unsuitable terrain.NTSB SEA06CA178Accident · Minor injuriesData collectionFinal reportCessna 150 · Laurel, MTThe pilot's excessive application of the brakes during an aborted takeoff, which resulted in a nose over.NTSB SEA06LA167Accident · Minor injuriesLimited investigationFinal reportKinnson Lancair IV-P Turbine · Helena, MTThe total loss of engine power as a result of turbine over temperature due to the pilot's failure to follow proper procedures for engine operation. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB SEA06LA164Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Townsend, MTThe pilot's failure to maintain terrain clearance while intentionally maneuvering low to the ground.NTSB SEA06CA165Accident · No injuriesData collectionFinal reportBell 407 · Havre, MTThe pilot inadvertently allowing the helicopter to enter into a vortex ring state (settling with power) condition while he was lowering a long-line load to the ground, resulting in the helicopter settling to the ground and its tail rotor impacting part of the…NTSB SEA06TA153Accident · No injuriesFinal reportBell 206L-1 · Busby, MTThe improper overhaul of the turbine assembly by maintenance personnel, which resulted in failure of the turbine and a total loss of engine power. A contributing factor was the pilot's misjudgment of the landing flare at the termination of the autorotation.NTSB SEA06CA155Accident · No injuriesData collectionFinal reportCessna 180H · Belgrade, MTThe pilot's failure to maintain directional control while landing.NTSB SEA06CA144Accident · No injuriesData collectionFinal reportPiper PA-11 · Turner, MTThe passenger's inadvertent activation of the airplane's brakes during the landing roll, resulting in the pilot's loss of control and subsequent nose over. A factor was the pilot's inadequate preflight planning/preparation by not briefing the passenger about…NTSB SEA06LA138Accident · No injuriesLimited investigationFinal reportCessna Citation 560 · Hamilton, MTThe pilot's failure to attain the proper touchdown point and to execute a go-around, which lead to an overrun of the runway surface. Contributing to the accident was his failure to maintain the correct landing approach speed (Vref), his failure to maintain…NTSB SEA06CA132Accident · No injuriesData collectionFinal reportCessna 195 · Great Falls, MTThe pilot's loss of aircraft control during the takeoff roll, and the subsequent inadvertent ground loop.NTSB SEA06FA126Accident · 2 fatalField investigationFinal reportPilatus PC-12/47 · Big Timber, MTThe flight instructor's failure to maintain an adequate airspeed while maneuvering, which led to an inadvertent stall.NTSB SEA06CA120Accident · No injuriesData collectionFinal reportCessna 180 · Great Falls, MTThe pilot's failure to adequately compensate for wind conditions. A crosswind was a factor.NTSB SEA06LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Ennis, MTThe loss of engine power during takeoff due to an excessively lean fuel-to-air mixture ratio as a result of excessive mating surface wear between the mixture control arm and metering shaft. A factor was the improper installation of the new engine, which…NTSB SEA06LA109Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Laurel, MTThe failure of maintenance personnel to properly reinstall the left-hand control yoke to the left-hand control column, and the failure of other maintenance personnel to properly verify the installation, which resulted in the pilot's loss of control in flight…NTSB SEA06CA106Accident · No injuriesData collectionFinal reportCessna 170B · West Glacier, MTThe pilot's failure to attain sufficient airspeed for flight, his attempt to abort the takeoff, and the airplane's subsequent departure off the end of the runway. Contributing factors were the impacted fence and vegetation, and his total lack of experience in…NTSB SEA06CA103Accident · No injuriesData collectionFinal reportCessna 172M · Hamilton, MTThe pilot's inadequate compensation for the wind conditions during the landing roll which resulted in his failure to maintain directional control. Factors included variable winds and gusty crosswinds.NTSB SEA06CA095Accident · No injuriesData collectionFinal reportHelmer Avid Magnum · Big Timber, MTThe pilot's failure to maintain directional control after he diverted his attention to close the aircraft's door during the takeoff roll. Factors include a fence and fence post along the side of the runway.NTSB SEA06CA094Accident · No injuriesData collectionFinal reportHarold Vander Avid Flyer · Miles City, MTFailure of the engine to propeller reduction gearbox for undetermined reasons. High vegetation was a factor.NTSB SEA06CA098Accident · No injuriesData collectionFinal reportCessna 172N · Billings, MTThe pilot's failure to maintain clearance from a sign while taxiing to parking.NTSB SEA06CA088Accident · Minor injuriesData collectionFinal reportPotts MA-5 · Kalispell, MTSeparation of the left main landing gear during the landing roll for an undetermined reason, which resulted in the airplane nosing down.NTSB SEA06CA080Accident · No injuriesData collectionFinal reportPitrolo GL-25 · Worden, MTThe loss of engine power due to failure of both electronic ignition systems. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06CA087Accident · No injuriesData collectionFinal reportCessna 310R · Billings, MTCollapse of the right main landing gear during the landing roll for an undetermined reason.NTSB SEA06LA074Accident · No injuriesLimited investigationFinal reportCentral Copters Lancair IV-P · Belgrade, MTThe total loss of drive power to the aircraft's propeller while on a visual final approach, due to the decoupling of the quill shaft between the reduction gearbox and the engine power section. Factors include a dark night, no suitable terrain on which to…NTSB SEA06CA073Accident · No injuriesData collectionFinal reportCessna 170B · Havre, MTThe pilot's improper starting procedures in attempting to hand-prop the airplane's engine. Contributing factors were the discharged battery, the failure of the right parking brake and the hangar which the aircraft collided with.NTSB SEA06FA068Accident · 2 fatalField investigationFinal reportBeech C99 · Butte, MTThe second pilot's failure to follow the published instrument approach procedure and the captain/PIC's inadequate supervision. Snow and mountain obscuration were factors.NTSB SEA06LA052Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Helena, MTThe pilot's intentional suicide. The unauthorized use of a helicopter and impairment by alcohol were factors.