NTSB investigations, MT
32 cases where the first occurrence was “Airframe/component/system failure/malfunction”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1986 | 2 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1996 | 2 |
| 1998 | 4 |
| 1999 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 4 |
| 2004 | 1 |
| 2005 | 2 |
| 2006 | 3 |
| 2007 | 2 |
Where
Open the mapLatest cases
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'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 130)
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' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130) 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 LAX07CA288Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Laurel, MTCorrosion and fatigue-induced failure of the landing gear structure.NTSB SEA07LA133Accident · No injuriesLimited investigationFinal reportBeech B-99 · Billings, MTThe total failure of the nose landing gear actuator and the subsequent nose gear collapse during landing.NTSB SEA07LA002Accident · No injuriesLimited investigationFinal reportCessna 340A · Kalispell, MTThe fracture of the adjusting bellcrank in overstress due to binding in a linkage forward of the bell crank.NTSB SEA06CA094Accident · No injuriesData collectionFinal reportHarold Vander Avid Flyer · Miles City, MTFailure of the engine to propeller reduction gearbox for undetermined reasons. High vegetation was a factor.NTSB SEA06CA088Accident · Minor injuriesData collectionFinal reportPotts MA-5 · Kalispell, MTSeparation of the left main landing gear during the landing roll for an undetermined reason, which resulted in the airplane nosing down.NTSB 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…NTSB 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.…NTSB 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…NTSB SEA02LA182Accident · No injuriesLimited investigationFinal reportCessna 172RG · Billings, MTThe failure of the landing gear actuator during landing as a result of fatigue.NTSB SEA02LA130Accident · No injuriesLimited investigationFinal reportThurmond Moni · Laurel, MTUndertorqued mounting bolts which resulted in fatigue to the wooden propeller blade and subsequent in flight separation of one of the blades while in cruise flight. An improper installation of the propeller assembly and soft terrain encountered during the…NTSB SEA02LA074Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Helena, MTFracture of the left main wheel assembly during the takeoff roll. Factors include the use of a wheel assembly not approved for the accident airplane, and the use of an oversized tire.NTSB SEA02FA064Accident · No injuriesField investigationFinal reportCessna 182E · Red Lodge, MTLong term fatigue of the nose landing gear strut fork initiated by side loading which resulted in the separation of the fork from the strut and the consequent collapse of the nose gear. A contributing factor was the ditch the aircraft traversed during the…NTSB SEA01LA046Accident · 1 fatalLimited investigationFinal reportWestern International UH-1H · Darby, MTInflight loss of a tail rotor pitch change link-to-blade grip attach bolt, resulting partial loss of tail rotor control, and subsequent entanglement of the helicopter's external load cable with a tree during emergency descent. Factors included the pilot's…NTSB SEA00LA128Accident · No injuriesLimited investigationFinal reportKeith Kinden Rebel · Libby, MTAn improper installation of a rudder control cable Nicopress sleeve by the owner/builder. The rudder control cable disconnection and the slipped cable from the sleeve were factors.NTSB SEA00LA032Accident · No injuriesLimited investigationFinal reportCessna 140 · Helena, MTSeparation of the left main landing gear. Factors include inadequate preflight inspection by the pilot, and inadequate inspection at the time of annual inspection by maintenance personnel.NTSB SEA99LA103Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Billings, MTThe separation of the left main landing gear shock strut for undetermined reasons.NTSB SEA98LA166Accident · No injuriesLimited investigationFinal reportCessna 175 · Missoula, MTA complete loss of crankcase oil due to a missing oil filler tube followed by the failure of a connecting rod. Factors include encountering a small pine tree during the landing roll.NTSB SEA98LA146Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Libby, MTA failure of the external load cable, which became entangled in the tail rotor.NTSB SEA98FA089Accident · 1 fatalField investigationFinal reportMooney M20A · Canyon Creek, MTThe design stress limits of the aircraft was exceeded. The pilot's inadequate preflight planning/preparation, lack of an instrument rating, poor weather evaluation and low ceilings and mountain obscuration were factors.NTSB SEA98LA073Accident · No injuriesLimited investigationFinal reportAero Commander 500-A · Billings, MTFailure of the main landing gear strut outer-body to inner-body needle bearing from the lack of lubrication and the development of corrosion. An inadequate manufacturer's inspection program was a factor.NTSB SEA96LA219Accident · Minor injuriesLimited investigationFinal reportKaman HH-43 B/F · Troy, MTfailure of the freewheeling sprag unit bearings for undetermined reasons.NTSB SEA96IA104Incident · No injuriesIncident investigationFinal reportDornier 328 · Billings, MTpaint overspray on the elevator trim actuator push rods, which damaged the actuator quad rings during normal operation and allowed water to enter the actuators; and the resultant freezing of the actuators. Factors relating to the incident included the…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 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 SEA90IA161Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Belgrade, MTThe malfunction of the starter control valve.NTSB DEN89LA163Accident · No injuriesLimited investigationFinal reportCessna A188B · Fort Benton, MTFailure of the tailwheel assembly attaching bolts.NTSB DEN87IA032Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Billings, MTN124AV was operating as big sky airlines flt 3857, scheduled service from helena to Billings. The flt proceeded uneventfully until the apch into Billings. The flt crew stated after the incident that when the landing gear was extended, the left main gear…NTSB DEN87FA018Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Billings, MTWhile on takeoff from a hospital roof top helipad on an emergency medical service flt, a synchronized elevator cover blew off and struck the tail rotor. This resulted in an inflight separation of one tail rotor blade and a loss of anti-torque control. The plt…NTSB DEN84LA224Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Richey, MTThe plt had finished spraying & was proceeding to the glendive arpt. He said that eng or prop began a sudden severe vibration which required the eng to be shut down. An emegency landing was made. The plt stated that the left wing impacted a hill which spun…NTSB DEN83LA121Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Ennis, MTDuring a night flight, oil began spreading over the windshield & heavy smoke came in the cockpit through the cabin heater. The plt opened the cabin windows, reduced power & turned back toward the arpt. The oil pressure dropped to 5 PSI & the plt descended to…NTSB DEN83LA046Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 (Soloy) · Great Falls, MTWhile maneuvering at low altitude in search of animals, the pilot experienced a severe vibration through the flight controls. The helicopter began an uncontrolled descent and attempts to stop the descent by using the collective were unsuccessful. The…NTSB DEN83LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cut Bank, MTThe aircraft experienced a total electrical failure while enroute. On arrival, the pilot selected gear down, however it would not lower. He misidentified the operation of the emergency gear down switch and pushed it up instead of down. The pilot stated that…