NTSB investigations, MT
128 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1982 | 6 |
|---|---|
| 1983 | 6 |
| 1984 | 8 |
| 1985 | 5 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 4 |
| 1989 | 6 |
| 1990 | 6 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 4 |
| 1996 | 5 |
| 1997 | 5 |
| 1998 | 9 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 5 |
| 2005 | 3 |
| 2006 | 9 |
| 2007 | 1 |
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 c.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260)
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 c."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260) 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 SEA08CA009Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Townsend, MTThe private pilot/student failed to maintain directional control during the landing roll, and remedial action was not possible by the flight instructor which resulted in an inadvertent ground loop.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 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 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 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 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 SEA06CA120Accident · No injuriesData collectionFinal reportCessna 180 · Great Falls, MTThe pilot's failure to adequately compensate for wind conditions. A crosswind was a factor.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 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 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 SEA04CA138Accident · No injuriesData collectionFinal reportCessna A185F · Cut Bank, MTThe pilot's failure to maintain directional control during the takeoff roll.NTSB SEA04LA087Accident · No injuriesLimited investigationFinal reportCessna 185A · Polson, MTThe pilot's inadequate compensation for the changing wind conditions at the time of the landing. Factors include gusty, variable, crosswinds, and a runway marker near the edge of the runway the pilot was landing on.NTSB SEA04LA061Accident · No injuriesLimited investigationFinal reportCessna 305A · Bozeman, MTThe pilot's failure to maintain directional control during the landing roll in the tail wheel-equipped aircraft, leading to an inadvertent ground-loop, during which the aircraft's wing impacted the ground.NTSB SEA04LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Marion, MTThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the gust of wind and the snowbank.NTSB SEA04LA044Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Laurel, MTThe student pilot's failure to maintain aircraft control during the landing roll. Inadequate remedial action was a factor.NTSB SEA03LA188Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Billings, MTThe pilot's inadequate compensation for wind conditions which led to a loss of control and subsequent ground loop. A contributing factor was the wind gust.NTSB SEA03LA166Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Rapids, MTThe failure of the landing gear tire valve stem and the pilot's failure to maintain directional control during the landing roll. The deflation of the tire and rough/uneven terrain were factors.NTSB SEA03LA099Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Laurel, MTAircraft control was not maintained during the landing roll. The aircraft subsequently nosed over.NTSB SEA03LA091Accident · No injuriesLimited investigationFinal reportCessna 150 · Dillon, MTThe pilot's failure to maintain directional control during the takeoff roll, and his inadequate remedial actions during his attempt to realign the aircraft with the runway. Factors include a crosswind, and the pilot's lack of experience in tailwheel-equipped…NTSB SEA03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Marion, MTThe pilot-in-command's failure to maintain directional control during the takeoff roll resulting in the aircraft leaving the runway, crossing a ditch and collapsing the landing gear. A contributing factor was the ditch.NTSB SEA02LA169Accident · No injuriesLimited investigationFinal reportCessna 172 · W. Yellowstone, MTThe pilot's compensation for the wind conditions was inadequate during the landing roll. A quartering tailwind was a factor.NTSB SEA02LA158Accident · No injuriesLimited investigationFinal reportCessna 120 · Missoula, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Delayed remedial action and a high crosswind condition were factors.NTSB SEA02LA118Accident · No injuriesLimited investigationFinal reportCessna 182 E · Sweetgrass, MTThe pilot's failure to adequately compensate for wind conditions after encountering a crosswind gust during the landing roll. Factors include gusty crosswinds, and a fence in the vicinity of the runway.NTSB SEA02LA104Accident · No injuriesLimited investigationFinal reportCessna 180K · Helena, MTBinding brakes for undetermined reasons and the pilot's failure to maintain directional control during an aborted takeoff.NTSB SEA01LA139Accident · No injuriesLimited investigationFinal reportPilatus PC-6/B2-H4 · Great Falls, MTPilot's failure to maintain directional control of the aircraft while landing.NTSB SEA01LA128Accident · No injuriesLimited investigationFinal reportTibert Baby Lakes · Stevensville, MTThe pilot's failure to maintain directional control of the tailwheel-equipped aircraft during the landing roll. Factors include the pilot's low total time in this make and model aircraft and his lack of recent experience in this make and model aircraft.NTSB SEA01LA117Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Billings, MTThe pilot-in-command's failure to maintain directional control of the aircraft during the landing roll. A contributing factor was the gusty crosswind conditions.NTSB SEA01LA047Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Bozeman, MTThe pilot rated passenger's failure to maintain directional control during the landing. A factor was the snow berm which the aircraft rolled into during the landing.NTSB SEA00LA183Accident · No injuriesLimited investigationFinal reportBeech B99 · Missoula, MTA loss of directional control due to a brake locked as a result of snow and ice contamination.NTSB SEA00LA145Accident · No injuriesLimited investigationFinal reportRoot Sherpa · Helena, MTThe pilot's failure to maintain directional control while landing.NTSB SEA00LA055Accident · No injuriesLimited investigationFinal reportCessna 180K · Roundup, MTThe pilot's failure to adequately compensate for wind conditions and subsequent loss of control.NTSB SEA00LA053Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Three Forks, MTThe pilot's failure to maintain directional control of the tailwheel equipped airplane.NTSB SEA00LA044Accident · No injuriesLimited investigationFinal reportCessna 152 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB SEA00LA003Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Laurel, MTThe pilot's inadequate compensation for wind conditions. Factors include a dust devil/whirlwind at the location where the pilot was trying to land.NTSB SEA99LA154Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTThe pilot's failure to maintain directional control. A wet runway surface was a factor.NTSB SEA99LA139Accident · No injuriesLimited investigationFinal reportCessna 188B · Sidney, MTThe pilot's failure to adequately compensate for wind conditions.NTSB SEA99LA102Accident · No injuriesLimited investigationFinal reportCessna 182Q · Conner, MTThe pilot's attempt to take off on an unsuitable runway surface due to standing water on the runway. Factors include standing water on the airstrip.NTSB SEA99LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Boulder, MTThe pilot-in-command's failure to maintain directional control after encountering a dust-devil during landing rollout, resulting in a ground loop and collapse of the main landing gear. Factors include the dust-devil.NTSB SEA99LA008Accident · No injuriesLimited investigationFinal reportCessna 172K · Dillon, MTThe student pilot-in-command's failure to maintain directional control. Contributing factors were rough terrain and crosswind conditions.NTSB SEA99LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Billings, MTDirectional control was not maintained. Inadequate remedial action was a factor.NTSB SEA98LA195Accident · No injuriesLimited investigationFinal reportEvarts Kitfox IV 1200 · Sula, MTAn excessive brake application by the pilot. Factors included a narrow landing area, the pilot's failure to maintain directional control during a 180-degree taxi turn, and a tailwind.NTSB SEA98LA167Accident · No injuriesLimited investigationFinal reportCessna 180 · Anaconda, MTA ground-loop resulting from the pilot's inadequate remedial action while attempting to correct for an inadvertent loss of directional control during the landing roll. Factors include the loss of directional control and attempting to land with a tailwind.NTSB SEA98LA143Accident · Minor injuriesLimited investigationFinal reportMcCarty Avid Magnum · Kalispell, MTThe pilot's inadequate compensation for the wind conditions. A factor was gusty wind conditions.NTSB SEA98LA136Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Great Falls, MTThe pilot-in-command's improper remedial action and overload of the nose landing gear. Contributing factors were gusty winds and a pilot-induced oscillation (porpoise).NTSB SEA98LA114Accident · No injuriesLimited investigationFinal reportCessna 182P · Chico Hot Spgs., MTThe pilot's inadequate remedial action while attempting to compensate for a change in crosswind velocity. Factors include a crosswind, hills near the runway, and high vegetation (weeds) near the runway.NTSB SEA98LA057Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Glendive, MTThe pilot's delayed remedial action and his inadvertent entry into a ground loop.NTSB SEA98LA036Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Bozeman, MTThe pilot's failure to maintain directional control during takeoff.