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 SEA94FA163Accident · 1 fatalField investigationFinal reportPiper J3C-65 · Seeley Lake, MTThe pilot in command's failure to maintain flying airspeed.NTSB SEA94LA158Accident · No injuriesLimited investigationFinal reportCessna A188 · Cut Bank, MTThe pilot's failure to adequately compensate for wind conditions. The crosswind and the ditch were factors.NTSB SEA94LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Wolf Creek, MTPoor in flight planning. The mountainous terrain was a factor.NTSB SEA94LA140Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Culbertson, MTThe pilot's failure to maintain directional control. Factors include gusty crosswinds, and a fence near the point of takeoff.NTSB SEA94LA152Accident · No injuriesLimited investigationFinal reportCessna T188C · Angela, MTDirectional control was not maintained. Factors to the accident were: wet terrain and inadequate aircraft preflight.NTSB SEA94LA132Accident · Serious injuriesLimited investigationFinal reportPiper PA-12 · Nashua, MTAirspeed was not maintained. Factors include an inadvertent stall.NTSB SEA94LA128Accident · Serious injuriesLimited investigationFinal reportBell 204B · Libby, MTThe fatigue fracture of the 42 degree gear box input pinion. Factors include unsuitable, mountainous/hilly terrain.NTSB SEA94LA122Accident · 1 fatalLimited investigationFinal reportVickers Spitfire Mark Xviii · Great Falls, MTThe pilot's failure to maintain aircraft control while in instrument meteorological conditions (IMC). Factors include the pilot's poor inflight decision to attempt an IMC climb in an aircraft not certified for instrument flight rules (IFR) operation, and his…NTSB SEA94LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monarch, MTPoor in flight planning/decision. A factor to the accident was downdrafts.NTSB SEA94LA086Accident · No injuriesLimited investigationFinal reportCessna 182G · Belgrade, MTThe loss of engine power for undetermined reasons. The intentional ground loop and the fence were factors in the accident.NTSB SEA94LA074Accident · No injuriesLimited investigationFinal reportBeech 58P · Billings, MTThe pilot's inadvertent retraction of the landing gear while on the runway.NTSB SEA94LA059Accident · No injuriesLimited investigationFinal reportCessna T210N · Havre, MTAn undetermined loss of engine power.NTSB SEA94LA058Accident · No injuriesLimited investigationFinal reportCessna 402C · Billings, MTThe nose gear actuator froze. A factor to the accident was temperature extremes.NTSB SEA94LA056Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Sidney, MTThe pilot's inadequate compensation for the crosswind resulting in loss of directional control.NTSB SEA94LA048Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Missoula, MTThe pilot/passenger's failure to maintain directional control and the pilot in command's failure to properly supervise the landing.NTSB SEA94LA022Accident · No injuriesLimited investigationFinal reportBeech A-35 · Billings, MTThe pilot's failure to maintain directional control during the go-around. Factors include proper airspeed not being maintained, and gusty crosswinds.NTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.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 SEA93LA216Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Clinton, MTTotal failure of the tow equipment.NTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.NTSB SEA93FA205Accident · 2 fatalField investigationFinal reportCessna 185A · De Borgia, MTThe pilot's poor in-flight planning/decision and his failure to maintain airspeed above a stall.NTSB SEA93LA195Accident · No injuriesLimited investigationFinal reportCessna A188B · Ringling, MTThe pilot's failure to maintain airspeed.NTSB SEA93LA189Accident · No injuriesLimited investigationFinal reportCessna 150M · Missoula, MTThe loss of engine power from fuel exhaustion due to inadequate preflt planning/preparation by the PIC. A factor related to the accident was the rough/uneven terrain at the accident site.NTSB SEA93LA188Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Three Forks, MTThe pilot's failure to maintain flying speed resulting in a stall/mush. The high density altitude and the pilot's failure to completely jettison his load were factors.NTSB SEA93LA171Accident · No injuriesLimited investigationFinal reportCessna 188 · Marion, MTThe premature liftoff for takeoff by the pilot and the inadvertant stall/mush. A factor relating to the accident was the high density altitude.NTSB SEA93LA163Accident · No injuriesLimited investigationFinal reportCessna 195 · Pray, MTThe PIC failed to maintain directional control. A factor relating to the accident was the tailwind weather condition.NTSB SEA93LA156Accident · 1 fatalLimited investigationFinal reportStark Rand KR-2 · Townsend, MTThe loss of engine power due to the failure of the improperly modified magneto and loss of control in flight by the PIC while maneuvering to return to the airport.NTSB SEA93LA143Accident · No injuriesLimited investigationFinal reportCessna 180 · Bozeman, MTDirectional control was not maintained. A factor to the accident was: inadequate remedial action.NTSB SEA93LA135Accident · Minor injuriesLimited investigationFinal reportBell 206B · Harlem, MTThe improper refueling system procedures which allowed water to contaminate the aircraft fuel and the pilot's inadequate preflight.NTSB SEA93LA132Accident · Minor injuriesLimited investigationFinal reportCessna T-188C · Augusta, MTThe pilot's failure to maintain airspeed and terrain clearance while maneuvering on an aerial application flight. A factor relating to the accident was the pilot's diverted attention.NTSB SEA93LA128Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Havre, MTThe pilot in command misjudged his clearance from a ditch, and his use of improper remedial action.NTSB SEA93LA112Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Hardin, MTThe pilot in command's failure to maintain directional control.NTSB SEA93LA106Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Fort Benton, MTInadequate inflight planning/decision. Factors to the accident were: turbulence, downdrafts, poor weather evaluation and altitude not maintained.NTSB SEA93LA098Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Helena, MTThe inadequate lookout by the PIC and his failure to maintain clearance from electrical wires. A factor relating to the accident was the presence of electrical wires near the approach end of the airstrip.NTSB SEA93LA096Accident · Minor injuriesLimited investigationFinal reportCessna T-210N · Laurel, MTThe loss of engine power from fuel exhaustion due to the pilot's failure to ensure an adequate supply of fuel for the flt.NTSB SEA93LA093Accident · No injuriesLimited investigationFinal reportCessna 172K · Pony, MTThe improper preflt planning by the PIC and his failure to attain takeoff airspeed during ground roll on a soft snow covered airstrip. A factor relating to the accident was the soft snow on the airstrip.NTSB SEA93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Hamilton, MTThe pilot's improper use of carburetor heat. A factor which contributed to the accident was the carburetor icing conditions.NTSB SEA93LA083Accident · No injuriesLimited investigationFinal reportCessna 150 · Laurel, MTThe loss of engine power, undetermined.NTSB SEA93LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Winnett, MTThe student pilot's failure to maintain directional control. Factors contributing to the accident were the snowbank and lack of total experience in type operation.NTSB SEA93GA052Accident · 1 fatalFinal reportHiller UH-12E · Chinook, MTInattentive FBO personnel.NTSB SEA93LA047Accident · No injuriesLimited investigationFinal reportAero Commander AC-500B · Billings, MTLoss of engine power on both engines for undetermined reasons and left main landing gear not down and locked on touchdown.NTSB SEA93GA041Accident · 8 fatalFinal reportCessna 550 · Billings, MTThe pilot-in-command's failure to follow established vortex avoidance procedures, as published in the airman's information manual, to provide his own wake turbulence separation.NTSB SEA93LA027Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · Billings, MTFailure of a gear door roller, which necessitated a gear up landing. Factors include inadequate lubrication.NTSB SEA92LA215Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Helena, MTFuel exhaustion, the pilot in command's failure to refuel en route and the inability of the pilot in command to avoid the fence during the landing roll. Factors contributing to the accident were dark night conditions and the fence.NTSB SEA92LA213Accident · No injuriesLimited investigationFinal reportCessna 172M · Lloyd, MTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was wind gusts.NTSB SEA92LA185Accident · No injuriesLimited investigationFinal reportSchaknowski Dyke Delta JD-2 · Billings, MTFatigue of the left main landing gear axle.NTSB SEA92LA179Accident · No injuriesLimited investigationFinal reportCessna A185F · Ennis, MTDirectional control was not maintained. Factors to the accident were: a loose gravel airstrip, wind gusts and inadequate remedial action.NTSB SEA92LA176Accident · No injuriesLimited investigationFinal reportCessna 180K · Wibaux, MTA poorly planned approach.NTSB SEA92LA171Accident · No injuriesLimited investigationFinal reportBoeing B-75 · Three Forks, MTThe pilot's failure to maintain directional control. Factors include a crosswind gust.NTSB SEA92LA167Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Shelby, MTThe poor decision by the pilot to make an aerial application turn around manuever under power lines and his failure to maintain clearance from the power lines.