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 SEA92IA164Incident · 1 fatalIncident investigationFinal reportSmith Vari EZE · Terry, MTThe pilot in command's exceeding liftoff speed during a taxi test.NTSB SEA92LA146Accident · No injuriesLimited investigationFinal reportCessna 182Q · Melstone, MTInadequate in flight planning/decision. Factors to the accident were: unsuitable terrain was selected, rough/uneven terrain and a go around was not performed.NTSB SEA92FA140Accident · 1 fatalField investigationFinal reportBeech A36TC · Ballantine, MTThe pilot-in-command's physical impairment and his continued VFR flight into instrument meteorological conditions. Factors relating to the accident were: the weather conditions and the hilly terrain.NTSB SEA92LA134Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Ronan, MTThe pilot's operation with known deficiencies in equipment and erratic operation of the fuel control system. A factor contributing to the accident was: soft terrain.NTSB SEA92LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · W. Yellowstone, MTA stall/mush encountered due to poor pre-flight planning/preparation. Factors to the accident were: high density altitude and gross weight exceeded.NTSB SEA92LA126Accident · No injuriesLimited investigationFinal reportBeech K35 · Sula, MTPoor inflight planning/decision. Factors to the accident were: delayed remedial action, a white out weather condition and inadequate clearance.NTSB SEA92LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Monarch, MTThe pilot in command's disregard of the weather forecast and failure to maintain clearance with trees/terrain. Factors contributing to the accident were: hilly/mountainous terrain, weather conditions: rain, low ceilings and downdrafts, trees and the pilot in…NTSB SEA92FA113Accident · 4 fatalField investigationFinal reportCessna 177B · St. Ignatius, MTThe pilot in command's inadvertently allowing the aircraft to enter into a stall/spin. Factors contributing to the accident were: terrain condition, rising terrain, and the pilot in command's lack of familiarity with the geographic area.NTSB SEA92LA098Accident · No injuriesLimited investigationFinal reportSchweizer SGS-1-35C · Big Timber, MTAirspeed was not maintained. Factors to the accident were: no thermal lift and inadequate remedial action.NTSB SEA92FA101Accident · 4 fatalField investigationFinal reportMooney M20F · Glendive, MTAn excessive rate of descent, and the pilot's overconfidence in himself and the aircraft.NTSB SEA92LA103Accident · No injuriesLimited investigationFinal reportE.E. Shilling Q-2 · Billings, MTAn undetermined loss of engine power.NTSB SEA92LA099Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Kalispell, MTThe pilot's failure to maintain adequate airspeed during the go-around.NTSB SEA92LA081Accident · No injuriesLimited investigationFinal reportPiper J-5A · Broadus, MTFuel system exhaustion. Factors include an inadequate preflight, inadvertent fuel dumping, and a ditch in the landing area.NTSB SEA92LA072Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Missoula, MTPartial blockage of the left engine induction air filter, inability to maintain the proper rate of descent, and delayed extension of the landing gear. Factors contributing to the accident were icing conditions, wing ice, and rough/uneven terrain.NTSB SEA92LA071Accident · No injuriesLimited investigationFinal reportCessna A185F · Billings, MTA worn tailwheel steering system and inadequate inspection of the airplane. A factor relating to the accident was the crosswind condition.NTSB SEA92LA059Accident · No injuriesLimited investigationFinal reportCessna 172G · Billings, MTThe pilot's failure to maintain directional control. A factor was the crosswind.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 SEA92FA046Accident · 2 fatalField investigationFinal reportGrumman American AA-5B · West Glacier, MTThe inflight encounter with IMC weather by the non-instrument rated pilot. Factors relating to the accident were the weather conditions, the mountainous/hilly terrain, and lack of instrument qualification by the pilot.NTSB SEA92FA105Accident · 1 fatalField investigationFinal reportCessna 182R · Garrison, MTPoor inflight planning/decision. Factors to the accident were: icing conditions, dark night, flight into known adverse weather and an inadequate weather evaluation.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 SEA92LA028Accident · Serious injuriesLimited investigationFinal reportCessna C-172G · Jackson, MTLoss of control due to the pilot's failure to maintain proper airspeed. Factors relating to the accident were the improper flap setting, the high density altitude, mountainous terrain, lack of experience by the pilot, and downdrafft winds.NTSB SEA92LA025Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AC · Missoula, MTThe pilot's inability to maintain directional control during takeoff. Factors include a dragging brake.NTSB SEA92LA017Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Belt, MTA blocked fuel vent and an inadequate preflight inspection, which resulted in fuel starvation.NTSB SEA92LA029Accident · No injuriesLimited investigationFinal reportAerospatiale AS355F1 · Billings, MTThe unlatching and subsequent opening inflight of the left-rear engine cowl door. A factor contributing to the accident was the failure of company maintenance personnel to execute the manufacturer's service bulletin.NTSB SEA92FA013Accident · 3 fatalField investigationFinal reportCessna 172N · Columbus, MTThe pilot in command's operation at too low an altitude over the river and his failure to maintain adequate clearance from the power lines. Factors contributing to the accident were the wires crossing the river and the pilot in command's poor judgement in…NTSB SEA92T#A01Accident · 2 fatalClass 3Final reportLockheed P-3A · Florence, MTNTSB SEA91FA258Accident · 2 fatalField investigationFinal reportCessna 182Q · Lincoln, MTThe improper inflight planning/decision by the pilot to continue VFR flight into IMC conditions. Factors relating to the accident were the mountainous terrain in the area, and the low ceilings and clouds obscuring the mountains.NTSB SEA91FA246Accident · Serious injuriesField investigationFinal reportCessna C-172G · Red Lodge, MTThe loss of control by the instructor due to the improper recovery altitude selected to terminate a simulated forced landing, the excessive pull-up by the student due to his lack of experience, and the delayed remedial action of the instructor. Factors…NTSB SEA91LA228Accident · No injuriesLimited investigationFinal reportCessna 172N · Butte, MTUnfavorable winds. Factors to the accident were: inadequate weather evaluation and lack of total flight experience.NTSB SEA91LA214Accident · No injuriesLimited investigationFinal reportBeech 58TC · Kalispell, MTThe pilot's failure to extend the landing gear. A factor contributing to the accident was the pilot's failure to identtify a down and locked landing gear condition prior to touchdown.NTSB SEA91LA211Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Anaconda, MTAn inadvertent stall during initial climb. The high density altitude and a premature liftoff by the pilot were factors.NTSB SEA91LA208Accident · Minor injuriesLimited investigationFinal reportChampion 7GCAA · Townsend, MTThe instructor pilot's not maintaining the power off stall speed resulting in a stall condition. A factor contributing to the accident was the lack of sufficient altitude to enable a successful recovery from the stall.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 SEA91LA202Accident · 1 fatalLimited investigationFinal reportTaylor Air Command 532 Elite · Libby, MTLoss of control during takeoff due to the pilot's total lack of experience in the type of aircraft.NTSB SEA91LA199Accident · No injuriesLimited investigationFinal reportCessna C-152 · W. Yellowstone, MTThe failure by the pilot to calculate aircraft fuel comsumption and the pilot's poor inflight planning. Factors relating to the accident were the inadequate preflight planning by the pilot, his lack of qualification and experience, and his disorientation…NTSB SEA91LA196Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roy, MTThe failure of the pilot to maintain clearance from obstacles during takeoff.NTSB SEA91LA190Accident · Minor injuriesLimited investigationFinal reportFleet FL-80 · Havre, MTThe engine driven fuel injection pump metering valve shaft was loose. A factor to the accident was: inadequate annual inspection.NTSB SEA91LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-25 · Musselshell, MTThe pilot's intentional stall at low altitude.NTSB SEA91LA138Accident · Minor injuriesLimited investigationFinal reportCessna C175 · East Glacier, MTThe pilot's failure to maintain sufficient airspeed. Contributing to the accident was: the gusty wind conditions and the pilot's lack of experience in this type of operation.NTSB SEA91LA123Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · St. Xavier, MTThe pilot's improper use of the fuel system, and the overfilling of the fuel tank. Contributing to the accident was: aerobatics performed, the pilot's inattention and the design of the fuel system.NTSB SEA91LA085Accident · No injuriesLimited investigationFinal reportPiper PA-18-125 · Ekalaka, MTThe pilot did not maintain directional control of the airplane during the landing roll. Factors to the accident were: the landing surface was covered with slush, snow was falling and obscured the pilot's vision.NTSB SEA91FA073Accident · 1 fatalField investigationFinal reportPiper PA-30 · Butte, MTInadequate inflight decisions, fuel starvation, and failure to perform alternative IFR approach procedures. Factors include operation with known deficiencies in equipment, disorientation, and lack of familiarity with the geographic area.NTSB SEA91LA055Accident · No injuriesLimited investigationFinal reportCessna 180 · Glasgow, MTThe loss of engine power due to carburetor icing. Factors relating to the accident were the strong winds, high obstructions in the area and tailwind conditions for landing at the only available area.NTSB SEA91LA053Accident · No injuriesLimited investigationFinal reportBeech 95 · Roundup, MTPartial loss of power for undetermined reasons.NTSB SEA91LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Helena, MTThe pilot-in-command's failure to maintain directional control on landing. Contributing to the accident was the pilot's improper flare on landing inadequate recovery from a bounced landing, and the pilot's lack of total and recent experience.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 SEA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wolf Point, MTThe inadequate preflight planning and preparation by the pilot in command, and his selection of unsuitable terrain for takeoff. A factor relating to the accident was the snowdrifts in the takeoff area.NTSB SEA91LA040Accident · No injuriesLimited investigationFinal reportSwearingen SA-227 · Kalispell, MTThe flight crew's inablity to maintain directional control after landing in snow-depth conditions that had been erroneously reported as being within operating limitations.NTSB SEA91LA031Accident · No injuriesLimited investigationFinal reportBeech 3NM · Bozeman, MTThe failure of the right engine master rod.NTSB SEA91LA004Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Hamilton, MTThe pilot's inadequate compensation for wind conditions.