NTSB investigations, 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, 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 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 SEA98FA062Accident · 1 fatalField investigationFinal reportMooney M20F · Lodgepole, MTThe pilot's failure to maintain clearance from the terrain after flying into an area of known adverse weather. Factors include low ceilings, fog, snow showers, drizzle, and trees along his intended route.NTSB SEA98LA057Accident · No injuriesLimited investigationFinal reportAeronca 7-EC · Glendive, MTThe pilot's delayed remedial action and his inadvertent entry into a ground loop.NTSB SEA98LA051Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Kalispell, MTThe pilot's failure to maintain adequate crosswind correction during landing. A factor was a crosswind.NTSB SEA98LA049Accident · No injuriesLimited investigationFinal reportCessna 177A · Laurel, MTThe pilot's excessive descent rate on final, and improper recovery from a bounced landing.NTSB SEA98LA037Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Bridger, MTThe student pilot's failure to maintain airspeed during a bounced landing recovery.NTSB SEA98LA036Accident · No injuriesLimited investigationFinal reportPiper PA-17 · Bozeman, MTThe pilot's failure to maintain directional control during takeoff.NTSB SEA98LA031Accident · 1 fatalLimited investigationFinal reportCessna 150F · Havre, MTThe student pilot's loss of control after his failure to maintain airspeed. Factors include his lack of total flight experience and incapacitation due to alcohol.NTSB SEA98LA025Accident · No injuriesLimited investigationFinal reportCessna 177 · Thompson Falls, MTThe student pilot's improper remedial action when confronted with a porpoised landing. A factor was his failure to execute a go-around maneuver.NTSB FTW98FA063Accident · 3 fatalField investigationFinal reportPitts S-2B · Bozeman, MTThe failure of both pilots to maintain visual lookout. Factors were the pilot of N693SB not following procedures and directives, and the pilot of N693SB using poor judgment.NTSB SEA98LA020Accident · Minor injuriesLimited investigationFinal reportSchramm Helicycle · Big Timber, MTthe pilot's failure to maintain clearance from power lines. The pilot's diverted attention and transmission wires were factors.NTSB SEA98LA016Accident · No injuriesLimited investigationFinal reportShort Brothers SD3-60 · Billings, MTThe co-pilot's failure to maintain the proper descent rate on final approach, the pilot-in-command's delayed remedial action, and overload of the left main landing gear assembly. Factors contributing were snow, crosswind conditions and deteriorating…NTSB SEA98LA011Accident · No injuriesLimited investigationFinal reportCessna 150H · Missoula, MTThe student pilot's failure to maintain directional control.NTSB SEA98LA006Accident · No injuriesLimited investigationFinal reportBell 47-G3B · Winston, MTFuel starvation due to fuel flow restriction from a failed carburetor automatic mixture control device. Factors include night light conditions for the forced landing.NTSB SEA98LA003Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Galata, MTThe pilot's failure to adequately perform preflight planning (prior to the precautionary landing and prior to the subsequent takeoff), his selection of an unsuitable takeoff area, and his failure to maintain altitude/clearance from the fence during the…NTSB SEA97LA208Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTthe pilot passenger failed to maintain clearance from the power line.NTSB SEA97LA204Accident · 2 fatalLimited investigationFinal reportPiper J-3 · Jordan, MTThe pilot's inadequate remedial action during an inadvertent stall/spin entry. Factors include buzzing, a rapid pull-up, and failure to maintain proper airspeed (Vs).NTSB SEA97LA194Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Hamilton, MTThe pilot's excessive speed taxispeed and failure to maintain wing clearance from a taxiway sign.NTSB SEA97LA185Accident · No injuriesLimited investigationFinal reportCessna 172L · Townsend, MTThe pilot's failure to maintain airspeed.NTSB SEA97LA162Accident · Minor injuriesLimited investigationFinal reportCessna 320E · W. Yellowstone, MTThe pilot's failure to maintain directional control during landing when asymmetric power was applied. A factor was the crosswind conditions.NTSB SEA97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-135 · Biddle, MTThe pilot-in-command's failure to maintain adequate airspeed which resulted in a stall/mush. A factor contributing to the accident was the tailwind condition on takeoff.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 SEA97FA133Accident · 3 fatalField investigationFinal reportCessna U206E · Red Lodge, MTThe pilot-in-command's flight into known adverse weather and the subsequent overload and separation of the right wing-strut fuselage-to-strut attach point. Factors contributing were clouds and obscuration.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 SEA97LA119Accident · No injuriesLimited investigationFinal reportGarlick UH-1H · Lolo, MTFuel exhaustion due to the pilot's failure to refuel.NTSB SEA97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hysham, MTA failure of an engine exhaust valve and the pilot's misjudgement of altitude/distance during an emergency landing at an airstrip.NTSB SEA97LA109Accident · Minor injuriesLimited investigationFinal reportLearjet 35A · Great Falls, MTthe captain's inadequate preflight planning/preparation, and the subsequent improper response to a simulated loss of engine power, resulting in liftoff at an airspeed below that for which sustained flight was possible.NTSB SEA97LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Deer Lodge, MTThe pilot's improper decision to abort the takeoff, and his improper use of brakes during the abort. A factor contributing to the accident was the pilot's failure to maintain directional control during the takeoff roll.NTSB SEA97LA101Accident · No injuriesLimited investigationFinal reportCessna 150F · Plains, MTThe pilot's failure to adequately compensate for wind conditions during the landing roll. Factors contributing to the accident were gusts and crosswinds.NTSB SEA97LA100Accident · No injuriesLimited investigationFinal reportCessna TR182RG · Ennis, MTThe pilot's failure to adequately compensate for the wind conditions. Factors contributing to the accident were the gusting winds, and the presence of a ditch on the edge of the landing area.NTSB SEA97LA087Accident · No injuriesLimited investigationFinal reportCessna A185E · Billings, MTThe flight instructor's inadequate compensation for the wind conditions. The crosswind conditions were a factor.NTSB SEA97LA090Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-65 · Plentywood, MTthe pilot's inadequate recovery from a bounced landing and failure to maintain control of the airplane. Factors relating to the accident included: the pilot's lack of recent experience in the tailwheel aircraft, his inadequate recurrent training, and…NTSB SEA97FA075Accident · 4 fatalField investigationFinal reportCessna T210L · Dillon, MTflight by the pilot into adverse weather conditions, and his failure to maintaint altitude/clearance from terrain. The adverse weather condition was a related factor.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 SEA97FA044Accident · 3 fatalField investigationFinal reportPiper PA-24-260 · Winston, MTPilot incapacitation due to hypoxia. Failure of the pilot to use available oxygen is a factor.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 SEA97LA042Accident · No injuriesLimited investigationFinal reportCessna 150K · Helena, MTThe pilot's failure to maintain directional control.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 SEA97LA026Accident · No injuriesLimited investigationFinal reportCessna 182G · Hardin, MTthe pilot's inadequate compensation for the wind conditions during the landing, and his failure to maintain directional control of the aircraft after touched down. Factors relating to the accident included the pilot's abrupt movement of the throttle as he…NTSB SEA97LA019Accident · No injuriesLimited investigationFinal reportCessna 170B · Utica, MTThe pilot's improper use of the brakes, while landing a tailwheel aircraft in crosswind conditions. The crosswind was a related factor.NTSB SEA96LA219Accident · Minor injuriesLimited investigationFinal reportKaman HH-43 B/F · Troy, MTfailure of the freewheeling sprag unit bearings for undetermined reasons.NTSB SEA96TA213Accident · No injuriesFinal reportBell 206B-3 · St Regis, MTfailure of the pilot to maintain clearance from electrical transmission lines. The proximity of transmission lines was a related factor.NTSB SEA96LA212Accident · 1 fatalLimited investigationFinal reportGrazier Quickie 2 · Superior, MTloss of engine power after takeoff for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering to return to the departure airport, which resulted in a stall and collision with wooded terrain.NTSB SEA96FA209Accident · 1 fatalField investigationFinal reportCessna 340A · Wise River, MTThe pilot's attempt to fly in adverse meteorological conditions which led a loss of aircraft control. Factors contributing to the accident include: the pilot's failure to obtain the most current information of the meteorological conditions prior to departure,…NTSB SEA96LA203Accident · No injuriesLimited investigationFinal reportForney F-1 · Bozeman, MTthe pilot's failure to adequately service the engine with oil before flight, which resulted in a loss of oil pressure and a subsequent forced landing. The high vegetation and embankment at the forced landing site were related factors.NTSB SEA96LA179Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Culbertson, MTthe pilot's inadequate compensation for wind conditions, which resulted in a loss of directional control; and her inadequate remedial action for gusty winds after the aircraft departed the runway. Factors relating to the accident were: the strong and gusty…NTSB SEA96LA176Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Belgrade, MTloss of engine power for undetermined reason(s). A factor relating to the accident was: a ditch in the field where the forced landing was executed.NTSB SEA96FA170Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Libby, MTcollision with rising mountainous terrain for unknown reason(s).NTSB SEA96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Lewistown, MTthe pilot's inadequate compensation for the changing wind conditions, and his failure to maintain directional control, which resulted in an inadvertent ground swerve. The sudden windshift was a related factor.NTSB SEA96LA138Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTthe pilot's failure to follow the proper short field takeoff procedure as specified in the Airplane Flight Manual, his improper use of wing flaps during the takeoff, and his failure to abort the takeoff (while there was sufficient runway remainin). A factor…