NTSB investigations, MT

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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.

NTSB SEA06FA068Accident · 2 fatalField investigationFinal reportBeech C99 · Butte, MTThe second pilot's failure to follow the published instrument approach procedure and the captain/PIC's inadequate supervision. Snow and mountain obscuration were factors.Mar 18, 2006 · N54RP · Substantial damageNTSB SEA06LA052Accident · 1 fatalLimited investigationFinal reportRobinson R44 · Helena, MTThe pilot's intentional suicide. The unauthorized use of a helicopter and impairment by alcohol were factors.Feb 6, 2006 · N7085U · DestroyedNTSB SEA06LA029Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Butte, MTThe pilot's failure to maintain clearance from the terrain during low-level maneuvering at night. Factors included the pilot’s improper in-flight decision to continue into an area that was forecasted to possibly contain snow, fog, and low ceilings. Additional…Dec 17, 2005 · N4350F · DestroyedNTSB SEA06FA022Accident · 1 fatalField investigationFinal reportCessna 425 · Belgrade, MTThe pilot's failure to maintain airspeed during the approach which resulted in an inadvertent stall. Factors associated with the accident were dark night conditions, clouds, icing conditions, low visibility and snow.Nov 30, 2005 · N701QR · DestroyedNTSB SEA05LA189Accident · No injuriesLimited investigationFinal reportBallhagen/Shyrock Q-2 · Kalispell, MTThe pilot/owner's improper setting of the engine's valve clearance, leading to the failure of the exhaust valves to fully close and a total loss of power while on a VFR downwind, and the pilot/owner's failure to maintain sufficient airspeed as he tried to…Sep 2, 2005 · N12QJ · Substantial damageNTSB SEA05LA176Accident · Minor injuriesLimited investigationFinal reportAlon A-2A · Helena, MTThe loss of engine power for undetermined reasons, which resulted in a forced landing and nose over. A factor contributing to the accident was the ground bordering the runway pavement.Aug 20, 2005 · N5467F · Substantial damageNTSB SEA05CA149Accident · Minor injuriesData collectionFinal reportHughes 269A · Laurel, MTthe pilot's failure to maintain rotor rpm while executing a pinnacle approach, which resulted in a loss of control and collision with terrain.Jul 21, 2005 · N801CP · Substantial damageNTSB SEA05CA148Accident · No injuriesData collectionFinal reportPiper PA-16 · Park City, MTThe failure of the pilot to maintain directional control of the airplane on the takeoff roll. Factors contributing to the accident included the loose gravel, ditch, and the fence.Jul 20, 2005 · N5942H · Substantial damageNTSB SEA05CA135Accident · No injuriesData collectionFinal reportCessna 170B · Laurel, MTThe flight instructor's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop. A contributing factor was the flight instructor's diverted attention to talking with the student.Jun 28, 2005 · N2619D · Substantial damageNTSB SEA05FA124Accident · Serious injuriesField investigationFinal reportCessna 320E · Missoula, MTTerrain clearance was not possible as a result of a right engine failure. Factors contributing to the accident included the rising terrain, foreign material being ingested into the engine's turbocharger, which obstructed the turbocharger's impeller, the…Jun 21, 2005 · N3438Q · DestroyedNTSB SEA05LA121Accident · Minor injuriesLimited investigationFinal reportCessna 188A · Fairview, MTWhile in cruise flight a separation of a propeller blade as a result of a propeller hub crack. Factors contributing to the accident included the installation of an unapproved propeller, and the failure to properly service the propeller with red dyed oil for…Jun 20, 2005 · N2133U · Substantial damageNTSB SEA05LA120Accident · No injuriesLimited investigationFinal reportMBB BO-105 · Billings, MTThe pilot's improper in-flight decision to continue a simulated engine-out autorotation after sensing an excessive descent rate at 100 feet above the ground. Factors include the excessive descent rate, variable winds, and a high density altitude.Jun 17, 2005 · N314MS · Substantial damageNTSB SEA05CA117Accident · Minor injuriesData collectionFinal reportPiper PA-25-260 · Geraldine, MTThe pilot's failure to maintain clearance with rising terrain. Rising terrain was a factor.Jun 12, 2005 · N4768Y · Substantial damageNTSB SEA05CA109Accident · No injuriesData collectionFinal reportJackson Rans S-6S · Laurel, MTThe flight instructor's inadequate remedial action which resulted in a stall/spin during final approach to land. A contributing factor was the student pilot's failure to maintain adequate airspeed during the landing approach.May 28, 2005 · N133DJ · Substantial damageNTSB SEA05LA100Accident · No injuriesLimited investigationFinal reportCessna 152TW · Missoula, MTThe pilot's failure to maintain clearance from a taxiway identification sign as he attempted to turn off the runway onto the taxiway during the last part of the landing roll. Factors include a taxiway identification sign in the vicinity of the intersection of…May 12, 2005 · N7866Z · Substantial damageNTSB SEA05FA092Accident · 2 fatalField investigationFinal reportCessna T210N · Kalispell, MTLoss of aircraft control during climb while in instrument meteorological conditions. Icing conditions was a factor.May 3, 2005 · N106PM · DestroyedNTSB SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.Apr 27, 2005 · N1387Q · Substantial damageNTSB SEA05LA084Accident · Minor injuriesLimited investigationFinal reportCessna T210N · Kalispell, MTAn airborne fire which was fueled by leaking hydraulic fluid (the ignition source for the fire was undetermined) from the landing gear hydraulic system located under the cockpit instrument panel due to inadequate maintenance from other maintenance personnel.…Apr 20, 2005 · N2AK · DestroyedNTSB SEA05CA083Accident · No injuriesData collectionFinal reportHughes 269A · Whitefish, MTThe student pilot's failure to maintain control of the helicopter while hovering resulting in an in-flight collision with terrain. Gusting winds and the student pilot's inadequate compensation for the wind conditions were contributing factors.Apr 17, 2005 · N7054C · Substantial damageNTSB SEA05LA066Accident · No injuriesLimited investigationFinal reportAbbott Glasair Legend · Cascade, MTThe accumulation of wet snow on the engine inlet assembly protection screen during a rapid increase in outside air temperature, while on an instrument approach for landing. Factors include falling snow, a sudden and significant increase in outside air…Mar 24, 2005 · C-GUTT · Substantial damageNTSB SEA05CA050Accident · No injuriesData collectionFinal reportAviat Husky A-1 · Kalispell, MTThe pilot's failure to maintain clearance from a tree located off the departure end of his private airstrip during an aborted landing attempt. Factors include trees located near the departure end of the runway.Feb 17, 2005 · N22HU · Substantial damageNTSB SEA05LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Superior, MTA loss of engine power due to the pilot's inadequate planning/decision and improper fuel management, which resulted in fuel starvation. A contributing factor was the berm.Feb 9, 2005 · N6399W · Substantial damageNTSB SEA05CA033Accident · No injuriesData collectionFinal reportCessna 180 · Billings, MTThe pilot's improper flare and his failure to maintain aircraft control. The pilot's improper recovery from a bounced landing is a contributing factor.Jan 10, 2005 · N8609X · Substantial damageNTSB SEA05LA032Accident · No injuriesLimited investigationFinal reportAerostar 601 · Hamilton, MTA partial loss of engine power due to the lack of lubrication and subsequent failure of the left engine's right turbocharger for undetermined reasons, and subsequent forced landing after takeoff. A factor was the unsuitable terrain for the forced landing.Dec 30, 2004 · N601DF · DestroyedNTSB SEA05FA023Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Belgrade, MTThe pilot's failure to maintain altitude/clearance while maneuvering in mountainous terrain, which resulted in an inflight collision with trees and terrain. Contributing factors were the mountainous terrain and the downdraft.Dec 4, 2004 · N1159C · DestroyedNTSB SEA05LA011Accident · No injuriesLimited investigationFinal reportCessna T210H · Missoula, MTThe pilot's failure to follow published procedures/directives (inducing excessive fuel flow to the engine), and the subsequent loss of engine power for nonmechanical reasons while on final approach. Contributing factors were the utility pole and the ditch.Oct 23, 2004 · N2240R · Substantial damageNTSB SEA05LA001Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Winifred, MTThe pilot's failure to maintain airspeed which resulted in an aerodynamic stall while maneuvering.Oct 19, 2004 · N79795 · Substantial damageNTSB SEA05LA010Accident · No injuriesLimited investigationFinal reportBeech 99A · Billings, MTthe pilot's failure to follow the instrument approach procedure, which resulted in a premature descent below the decision height and subsequent collision with a building.Oct 18, 2004 · N955AA · Substantial damageNTSB SEA05LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Augusta, MTThe pilot's failure to maintain adequate obstacle clearance which resulted in the in-flight collision with rising terrain. Trees and rising terrain are factors in the accident.Oct 2, 2004 · N3086R · Substantial damageNTSB SEA04GA192Accident · 3 fatalFinal reportCessna U206G · Essex, MTThe pilot's misidentification of the airplane's location, which resulted in his improper decision to fly into the wrong drainage, and his failure to maintain terrain clearance while executing a turn to reverse course after he realized his navigational error.…Sep 20, 2004 · N206SM · DestroyedNTSB SEA04FA173Accident · 2 fatalField investigationFinal reportBeech C35 · Kalispell, MTThe pilot's improper positioning of the fuel tank selector, which resulted in fuel starvation and a subsequent loss of engine power while maneuvering.Aug 29, 2004 · N63AC · DestroyedNTSB 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.Aug 19, 2004 · N17062 · DestroyedNTSB 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.Aug 18, 2004 · N199GL · DestroyedNTSB SEA04CA151Accident · No injuriesData collectionFinal reportPiper PA22-20 · Wht Sulphur Spg, MTThe failure of the private pilot receiving flight training for a tail wheel endorsement to maintain aircraft control, and his excessive braking during the landing roll, subsequently nosing over the airplane. A contributing factor was the flight instructor's…Aug 1, 2004 · N3838P · Substantial damageNTSB SEA04CA142Accident · No injuriesData collectionFinal reportCessna 182N · Bainville, MTThe pilot's misjudgment of his airspeed on landing, and his subsequent overrunning of the runway. A contributing factor was the trees.Jul 24, 2004 · N92824 · Substantial damageNTSB SEA04CA138Accident · No injuriesData collectionFinal reportCessna A185F · Cut Bank, MTThe pilot's failure to maintain directional control during the takeoff roll.Jul 16, 2004 · N185S · Substantial damageNTSB SEA04LA119Accident · 2 fatalLimited investigationFinal reportApco Powered Parachute · Wolf Point, MTThe pilot's loss of control as a result of trying a low altitude quick turning maneuver. A factor was the pilot's lack of experience in the aircraft.Jun 29, 2004 · UNREG · DestroyedNTSB SEA04LA118Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Miles City, MTThe pilot's failure to maintain directional control of the aircraft during the landing roll resulting in a main landing gear collapse.Jun 25, 2004 · N1936P · Substantial damageNTSB SEA04LA117Accident · No injuriesLimited investigationFinal reportCessna 185F · Bozeman, MTThe failure of the right main gear brake disk attach flange during the landing roll, due to fatigue cracks emanating from numerous corrosion pits present on the surface of the disk, leading to the right brake becoming totally inoperative, and resulting in a…Jun 24, 2004 · N4585F · Substantial damageNTSB SEA04LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-18A · Trego, MTFailure to maintain clearance from trees during the initial climb.Jun 8, 2004 · N7094D · DestroyedNTSB SEA04LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Columbus, MTThe pilot's failure to maintain directional control of the aircraft during the landing and subsequent go-around. Inadequate compensation for the gusting winds and an airport hangar were factors.Jun 5, 2004 · N82172 · Substantial damageNTSB SEA04LA094Accident · No injuriesLimited investigationFinal reportBeech P-35 · Havre, MTA loss of engine power due to fuel starvation during the initial climb after takeoff as a result of an unsecured fuel sender unit which resulted in a false fuel quantity indication.May 29, 2004 · N7DR · Substantial damageNTSB SEA04LA084Accident · No injuriesLimited investigationFinal reportPiper J4/E · Bigfork, MTA loss of engine power due to fuel exhaustion while in cruise flight as a result of inadequate preflight planning / preparation. Factors contributing to the accident were the short landing field and trees.May 18, 2004 · N37982 · Substantial damageNTSB SEA04LA087Accident · No injuriesLimited investigationFinal reportCessna 185A · Polson, MTThe pilot's inadequate compensation for the changing wind conditions at the time of the landing. Factors include gusty, variable, crosswinds, and a runway marker near the edge of the runway the pilot was landing on.May 16, 2004 · N1624H · Substantial damageNTSB SEA04LA080Accident · Minor injuriesLimited investigationFinal report2003 Nash Kitfox II · Broadview, MTFuel starvation during cruise flight for undetermined reasons. Unsuitable terrain for a forced landing was a factor.May 9, 2004 · N308KF · Substantial damageNTSB SEA04LA196Accident · No injuriesLimited investigationFinal reportDornier DO27A4 · Marion, MTThe pilot's improper landing flare resulting in a hard landing.May 8, 2004 · N276MK · Substantial damageNTSB 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.May 1, 2004 · N5483H · Substantial damageNTSB SEA04LA067Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Hardin, MTThe pilot's failure to perform a go-around. Contributing factors were the pilot's misjudgment of speed and distance and the tree.Apr 10, 2004 · N5235X · Substantial damageNTSB SEA04LA061Accident · No injuriesLimited investigationFinal reportCessna 305A · Bozeman, MTThe pilot's failure to maintain directional control during the landing roll in the tail wheel-equipped aircraft, leading to an inadvertent ground-loop, during which the aircraft's wing impacted the ground.Mar 31, 2004 · N5210G · Substantial damageNTSB SEA04LA069Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Marion, MTThe pilot's failure to maintain directional control during the landing roll. Contributing factors were the gust of wind and the snowbank.Mar 20, 2004 · N90076 · Substantial damage