NTSB investigations, MT
64 cases where the first occurrence was “In flight collision with terrain/water”.
Cases per year
| 1982 | 7 |
|---|---|
| 1983 | 2 |
| 1984 | 3 |
| 1985 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 3 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 5 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 4 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 3 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 2 |
Where
Latest 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\" = 230)
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" = 230) 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 SEA07CA220Accident · No injuriesData collectionFinal reportHughes 269C · Three Forks, MTThe student pilot's failure to maintain control of the aircraft during autorotation. The flight instructor's inadequate supervision was a factor.NTSB SEA07FA051Accident · 3 fatalField investigationFinal reportBeech 200 · Belgrade, MTThe pilot's failure to maintain an adequate altitude and descent rate during a night visual approach. Dark night conditions and mountainous terrain are factors in the accident.NTSB SEA06LA164Accident · Serious injuriesLimited investigationFinal reportBellanca 8GCBC · Townsend, MTThe pilot's failure to maintain terrain clearance while intentionally maneuvering low to the ground.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.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 SEA04LA168Accident · 1 fatalLimited investigationFinal reportCessna 150L · Angela, MTThe failure of the pilot to maintain clearance while maneuvering. A factor contributing to the accident was the physical impairment of the pilot due to an elevated blood alcohol level.NTSB SEA04FA166Accident · 2 fatalField investigationFinal reportBeech BE-99 · Neihart, MTThe pilot's failure to maintain adequate terrain clearance during cruise, which resulted in the in-flight collision with mountainous terrain. Dark night conditions and mountainous terrain were contributing factors.NTSB SEA04LA077Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Laurel, MTThe pilot's failure to maintain adequate clearance/altitude while maneuvering resulting in the inadvertent in-flight collision with water/terrain.NTSB SEA04LA029Accident · Minor injuriesLimited investigationFinal reportBeech 58P · Missoula, MTThe second pilot's failure to maintain terrain clearance while maneuvering after takeoff. Proper climb rate not verified by the flight crew, fog, freezing fog, dark night conditions and inadequate supervision by the pilot-in-command were factors.NTSB SEA03CA102Accident · No injuriesData collectionFinal reportPiper PA-18 · Silver City, MTProper descent rate not maintained while on final approach. A wind gust is a factor in the accident.NTSB SEA02LA075Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Hot Springs, MTThe pilot's failure to adequately compensate for unfavorable wind conditions. Factors include unfavorable/shifting winds, and a tailwind gust.NTSB SEA02LA001Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lindsay, MTThe pilot's failure to maintain an altitude clear of terrain. A factor was intentional low altitude flight.NTSB SEA01LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R · Cut Bank, MTThe pilot's failure to maintain a speed above stall velocity (Vs) during the after-takeoff climb. Factors include a high density altitude, and a dust devil/whirlwind located along the route of departure.NTSB SEA01LA058Accident · Serious injuriesLimited investigationFinal reportAvia Stroitel AC-5m · Bozeman, MTthe pilot's improper remedial action upon experiencing the unexpected opening of the aircraft's canopy during the initial part of the takeoff climb. Factors include his attention being diverted to the open canopy, his failure to use a checklist to ensure he…NTSB SEA01LA052Accident · No injuriesLimited investigationFinal reportCessna 402B · Billings, MTBest rate-of-climb single-engine speed was not maintained. Delayed remedial action was a factor.NTSB SEA01LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Broadus, MTThe pilot's failure to maintain aircraft control during the takeoff phase of the flight.NTSB SEA00FA080Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Fort Smith, MTThe pilot's failure to maintain clearance from the terrain. Factors include low ceilings, snow, rain, and rising, mountainous/hilly terrain.NTSB SEA00FA074Accident · 1 fatalField investigationFinal reportMaule M-5-210C · Babb, MTTerrain clearance was not maintained. High mountains, mountain obscuration, and the pilot's inadequate preflight planning/preparation were factors.NTSB SEA00LA040Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Columbia Falls, MTFailure of the pilot-in-command to follow the prescribed instrument approach missed approach procedure.NTSB SEA99LA118Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Opheim, MTThe pilot's failure to maintain an airspeed above stall speed (Vs), resulting in a stall/mush into the terrain during a course reversal at the end of an aerial application run. Factors include hilly terrain and high density altitude.NTSB SEA99LA081Accident · 1 fatalLimited investigationFinal reportD. Wayne Smith Wayncraft 14 · Libby, MTCollision with terrain for undetermined reasons.NTSB SEA99LA003Accident · Minor injuriesLimited investigationFinal reportBeech 99 · Missoula, MTThe pilot-in-command's delayed remedial action in response to the co-pilot's improper landing flare, and the co-pilot's application of excessive (full nose-up) trim during the landing flare as taught in the operator's initial aircrew training program. Factors…NTSB SEA98FA161Accident · 1 fatalField investigationFinal reportCessna 177 · Red Lodge, MTThe pilot's failure to maintain adequate altitude over, or clearance with, mountainous terrain during night visual flight rules flight. Factors included night lighting conditions and mountainous terrain.NTSB SEA98LA132Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chico Hot Sprgs, MTThe pilot-in-command's selection of the wrong runway for takeoff. Factors contributing to the accident were high density altitude, rising terrain and a fence post.NTSB SEA98FA100Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Helena, MTThe pilot's failure to maintain the correct altitude while turning inbound during a procedure turn to the ILS final approach course. Factors include hilly/mountainous terrain and clouds in the area where the course reversal was performed.NTSB SEA98FA101Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Bigfork, MTThe pilot's failure to maintain terrain clearance for undetermined reasons. Contributing factors were the mountainous terrain, trees, dark night conditions, clouds and pilot fatigue.NTSB SEA97LA141Accident · Minor injuriesLimited investigationFinal reportWood Murphy Rebel · Marion, MTThe pilot's failure to maintain clearance from the terrain/water. Factors include gusty winds and downdrafts.NTSB SEA97LA131Accident · No injuriesLimited investigationFinal reportCessna 182C · Hardin, MTthe student's delay in initiating a go-around. A factor relating to the accident was: the sunglare.NTSB SEA97LA062Accident · Serious injuriesLimited investigationFinal reportHall Kitfox · Billings, MTThe pilot-in-command's failure to maintain flying airspeed while executing a downwind turn at low altitude immediately following takeoff.NTSB SEA97FA043Accident · 2 fatalField investigationFinal reportPiper PA-28R · Fort Smith, MTThe pilot's failure to maintain clearance from terrain. Factors include the pilot inadvertently becoming lost/disoriented, the dark night (minimum ambient light), and mountainous/hilly terrain.NTSB SEA97LA036Accident · 2 fatalLimited investigationFinal reportPiper PA18-135 · Cohagen, MTThe pilot's failure to maintain airspeed. Factors were the intentional flight at a low altitude and the over gross condition of the airplane.NTSB SEA96FA170Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Libby, MTcollision with rising mountainous terrain for unknown reason(s).NTSB SEA96FA024Accident · 2 fatalField investigationFinal reportBeech C24R · Bozeman, MTfailure of the pilot to follow the specified approach track (proper IFR procedure), and his associated failure to maintain altitude or clearance from mountainous terrain. Factors relating to the accident were: the pilot's failure to abide by the aircraft…NTSB SEA95FA209Accident · 1 fatalField investigationFinal reportCessna 180J · Browning, MTClearance from the ground was not maintained while attempting a VFR flight into IMC weather conditions. A factor to the accident was fog.NTSB SEA95LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Laurel, MTThe selection of unsuitable terrain for landing. A factor to the accident was tall vegetation.NTSB SEA94LA228Accident · Minor injuriesLimited investigationFinal reportSikorsky S-64F · Libby, MTThe flight crew allowed the helicopter's weight and balance to be exceeded, and the external load (tank) jettison system failed to operate. A factor related to the accident was: the false indication on the retardant quantity indicator.NTSB SEA94LA202Accident · 1 fatalLimited investigationFinal reportGroce Vans RV-4 · Glendive, MTAirspeed was not maintained after takeoff. A factor was high density altitude.NTSB SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.NTSB SEA94LA003Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Denton, MTThe pilot in command's failure to maintain adequate clearance with terrain. Factors contributing to the accident were unfavorable winds and the pilot in command's inadquate compensation (premature crosswind turn) for the wind conditions.NTSB SEA92FA101Accident · 4 fatalField investigationFinal reportMooney M20F · Glendive, MTAn excessive rate of descent, and the pilot's overconfidence in himself and the aircraft.NTSB SEA92LA057Accident · 2 fatalLimited investigationFinal reportRobert L. Rice Davis DA-2A · Billings, MTThe failure of the pilot to maintain terrain clearance. Factors relating to the accident were the pilot's lack of experience and the rising terrain in the area.NTSB SEA92LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Missoula, MTThe pilot's poor in-flight decision, failure to perform a missed approach, and improper altitude. Factors include poor preflight planning/preparation, and weather conditions below approach minimums.NTSB SEA91LA206Accident · No injuriesLimited investigationFinal reportBeech V35B · Belgrade, MTThe pilot's failure to maintain a positive rate of climb during the takeoff. Factors contributing to the accident were the open cabin window and the pilot's diverting his attention.NTSB SEA91FA046Accident · 2 fatalField investigationFinal reportCessna C-172 · Colstrip, MTThe pilot's failure to maintain adequate terrain clearance. Factors relating to the accident were the pilot's lack of total night flight experience, his lack of recent night flight experience, the dark night light conditions, and the mountainous/hilly terrain…NTSB DEN90LA108Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Powderville, MTPilot failed to maintain terrain clearance during descent on an aerial application swath run, resulting in an in flight collision with the terrain. That the pilot misjudged the pull up altitude is considered a contributing factor.NTSB DEN90LA014Accident · No injuriesLimited investigationFinal reportCessna 206F · Opheim, MTPilot's failure to maintain terrain clearance while executing a low pass.NTSB DEN89LA167Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Wh Sulphur Spgs, MTThe pilot failed to maintain adequate airspeed during an aerial application maneuver and inadvertently allowed the aircraft to mush into the ground. Unfavorable wind and turbulence were considered to be contributing factors.NTSB DEN88FA063Accident · 3 fatalField investigationFinal reportCessna 421A · Helena, MTThis accident occurred during a night, ILS app to rwy 27 in IMC. The acft collided with a mountain 12 NM ese of the arpt while turning inbound to intercept the LOC course. Investigation revealed that one VOR receiver was set on the destinaton ILS freq, the…NTSB DEN87MA168Accident · 10 fatalMajor investigationFinal reportBeech D18S · Lakeside, MTThe plt borrowed the acft to fly a musical group to kalispell for a pvt engagement at Lakeside, MT, which was aprx 15 mi south of the arpt. That evening, the group boarded the acft for the return flt. After takeoff, the acft was seen flying at low alt in the…NTSB DEN85FA153Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Melstone, MTThe acft was observed in a left turn in a steep dive until it passed out of view behind a hill. The investigation revealed no evidence of airframe or engine malfunction or failure piror to the crash. Medical findings revealed the plt, sole occupant, had 90…