NTSB investigations, MT
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, newest first
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' 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' 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 SEA90LA193Accident · No injuriesLimited investigationFinal reportCessna 170 · Havre, MTThe selection of the wrong runway by the owner/student pilot and his failure to compensate for the wind during landing ground roll.NTSB SEA90LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Dillon, MTPilot misjudged the flare that resulted in a bounced landing.NTSB SEA90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Lewistown, MTThe pilot did not maintain an adequate lookout while maneuvering which resulted in a collision with a transmission wire.NTSB SEA90FA165Accident · 4 fatalField investigationFinal reportPiper PA-30-160 · Kalispell, MTFailure of the pilot to flare the aircraft for landing and to maintain its control during the attempted go-around (aborted landing). Factors related to the accident were: darkness, a number of runway edge lights that were either inoperative or hidden by…NTSB SEA90LA164Accident · No injuriesLimited investigationFinal reportCessna A185F · Ovando, MTThe pilot's misjudgement of altitude and distance to the runway, while on final approach, and his failure to attain the proper touchdown point for landing. The fence was a related factor.NTSB SEA90IA161Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Belgrade, MTThe malfunction of the starter control valve.NTSB SEA90LA154Accident · No injuriesLimited investigationFinal reportCessna 188B · Denton, MTThe premature liftoff during takeoff ground roll by the pilot, resulting in a stall.NTSB SEA90LA150Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 Libelle · Thompson Falls, MTA disabled aircraft blocking the active runway.NTSB SEA90LA148Accident · No injuriesLimited investigationFinal reportBell BH-214 · Thompson Falls, MTCrew's encounter with soft terrain while attempting an autorotation landing after the failure of the main rotor drive system.NTSB SEA90LA144Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Jordan, MTPilot's failure to switch fuel tanks and the unsuitable terrain available for a forced landing.NTSB SEA90LA145Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Missoula, MTPilot's failure to maintain directional control during the landing roll.NTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.NTSB SEA90LA137Accident · No injuriesLimited investigationFinal reportSikorsky S-58BT · Ovando, MTThe pilot did not maintain rotor RPM after a compressor assembly blade failure. A related factor was an inadequate autorotation resulting in a hard landing.NTSB DEN90LA153Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Miles City, MTThe failure of the pilot to use carburetor heat during descent for landing, resulting in a loss of power.NTSB DEN90FA139Accident · 2 fatalField investigationFinal reportPiper PA-18 · Laurel, MTThe pilot's failure to maintain proper clearance from other objects wwhile maneuvering.NTSB DEN90LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Condon, MTThe pilot's failure to abort the takeoff.NTSB DEN90LA132Accident · No injuriesLimited investigationFinal reportLund Mustang II · Hamilton, MTThe inadequate compensation for the wind conditions by the pilot.NTSB DEN90LA122Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Belgrade, MTThe inadvertent stall experienced during the attempted forced landing.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 DEN90LA105Accident · No injuriesLimited investigationFinal reportCessna C-180E · Helena, MTThe malfunction of the tail wheel assembly.NTSB DEN90LA093Accident · No injuriesLimited investigationFinal reportCessna 172 · Columbia Falls, MTThe pilot's failure to preflight and secure the fuel cap which resulted in the loss of fuel and the loss of engine power from fuel exhaution. Factor was soft terrain during forced landing.NTSB DEN90LA088Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Forsyth, MTAn unexplained loss of engine power. A factor was the rough unsuitable terrain in which the forced landing was made.NTSB DEN90LA083Accident · No injuriesLimited investigationFinal reportPeterson KIT FOX Model 1 · Highwood, MTA premature lift-off by the pilot, resulting in a stall/mush.NTSB DEN90LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Whitewater, MTPilot's delayed use of carburetor heat and the subsequent induction icing related partial power loss. Contributing factors were the carburetor icing conditions and the unsuitable terrain in which the forced landing was performed.NTSB DEN90LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Three Forks, MTPilot's misjudged landing flare.NTSB DEN90LA075Accident · No injuriesLimited investigationFinal reportCessna 172 · Elkhorn, MTThe pilot's decision to attempt flight in terrain and conditions which exceeded the performance capabilities of the airplane.NTSB DEN90LA067Accident · Minor injuriesLimited investigationFinal reportHeindenreich Fokker DR-1 · Kalispell, MTFailure of the pilot to maintain adequate airspeed, which resulted in a stall. His lack of familiarity with this aircraft was a related factor.NTSB DEN90LA060Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Hungry Horse, MTFailure of the #4 connecting rod. Factors related to the accident were: the adverse weather conditions and lack of suitable terrain for a forced landing.NTSB DEN90LA052Accident · No injuriesLimited investigationFinal reportCessna 180C · Haugan, MTThe failure of the pilot to maintain directional control during the takeoff attempt. A factor in the accident was the icy, snow covered condition of the takeoff area.NTSB DEN90LA035Accident · No injuriesLimited investigationFinal reportCessna 172P · Billings, MTThe failure of the pilot to maintain directional control during adverse wind conditions.NTSB DEN90LA032Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Powderville, MTThe pilot in command left the airplane unattended with the engine running. That the pilot's son did not understand the unsafe condition is considered a contributing factor.NTSB DEN90LA018Accident · No injuriesLimited investigationFinal reportCessna U206B · Billings, MTImproper planning/decision by the pilot while taxiing during unfavorable wind conditions.NTSB DEN90LA014Accident · No injuriesLimited investigationFinal reportCessna 206F · Opheim, MTPilot's failure to maintain terrain clearance while executing a low pass.NTSB DEN89LA221Accident · Serious injuriesLimited investigationFinal reportMooney M20C · Neihart, MTVFR flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain sufficient altitude. Related factors were: the high terrain and adverse weather conditions.NTSB DEN89LA190Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTMisjudgement of the proper touchdown point by the pilot, which resulted in an overrun of the landing area and collision with a post. The downhill terrain condition and location of the fence post were related factors.NTSB DEN89FA178Accident · Serious injuriesField investigationFinal reportBeech E35 · Kalispell, MTContaminated fuel system that starved the engine of fuel.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 DEN89DTI03Accident · 1 fatalFinal reportCessna T188C · Red Lodge, MTImproper inflight decision by the pilot and his failure to attain sufficient altitude. Rising terrain, high density altitude, and trees were considered to be contributing factors.NTSB DEN89LA172Accident · No injuriesLimited investigationFinal reportCessna T188C · Fort Benton, MTOverload failure of the left main landing gear attaching bolts for an unknown reason.NTSB DEN89LA156Accident · Serious injuriesLimited investigationFinal reportPiper PA-28RT-201T · Red Lodge, MTInadequate compensation for the wind conditions during landing roll, resulting in a loss of control. Contributing to the accident was the gusty wind condition.NTSB DEN89LA151Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Ennis, MTThe failure of the pilot to maintain airspeed, which resulted in an inadvertent stall.NTSB DEN89DTI02Accident · 1 fatalFinal reportMusick/Terratorn Tierra II · Lewistown, MTThe unqualified pilot allowed the aircraft to become airborne while taxiing at high speed, he failed to maintain control of the aircraft, and he inadvertently allowed it to enter a stall/spin and crashed. Factors related to the accident were: his failure to…NTSB DEN89DTI01Accident · 1 fatalFinal reportPiper PA-25-235 · Conrad, MTThe pilot's failure to see the guy wire in time to avoid colliding with it.NTSB DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.NTSB DEN89MA130Accident · 4 fatalMajor investigationFinal reportBell 206L-3 · Big Timber, MTFailure of the pilot to maintain control of the aircraft during takeoff, due to spatial disorientation, which resulted in a collision with the terrain. Contributing factors were: dark night, pilot's visual perception, inadequate initial training of the pilot…NTSB DEN89LA121Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Miles City, MTThe pilot's improper decision to land and attempt to taxi at an airport where strong winds would not permit safe ground handling of the aircraft.NTSB DEN89FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Livingston, MTThe poor judgement displayed by the pilot when he maneuvered the airplane at extremely low altitude over mountainous terrain. During the flight the pilot misjudged the pull-up required and struck trees.NTSB DEN89LA115Accident · No injuriesLimited investigationFinal reportCessna 182G · St. Xavier, MTThe pilot's failure to maintain airspeed while maneuvering for a forced landing following a failure of the number two piston. Contributing to the accident was smoke in the cockpit.NTSB DEN89LA114Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Bozeman, MTImproper in-flight planning/decision by the pilot which led to his failure to maintain directional control during the landing. Contributing factors were: use of an unfavorable runway, crosswind, and gusts.NTSB DEN89LA111Accident · No injuriesLimited investigationFinal reportCessna 170A · Kalispell, MTThe pilot's failure to maintain control of the airplane during the landing flare and rollout. Contributing to the accident was the pilot's lack of proficiency with only 4 hours of flight time in the preceding 90 day period.