NTSB investigations, MT
28 cases where the first occurrence was “Loss of engine power(total) - mech failure/malf”.
Cases per year
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1985 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 4 |
| 1994 | 1 |
| 1995 | 3 |
| 1998 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2006 | 4 |
| 2007 | 1 |
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\" = 351)
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" = 351) 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 LAX07LA238Accident · No injuriesLimited investigationFinal reportde Havilland Beaver DHC-2 MK.1 · Kalispell, MTA loss of engine power due to the failure of the supercharger impeller bushing, which allowed raw oil to enter the induction system.NTSB SEA06LA167Accident · Minor injuriesLimited investigationFinal reportKinnson Lancair IV-P Turbine · Helena, MTThe total loss of engine power as a result of turbine over temperature due to the pilot's failure to follow proper procedures for engine operation. A contributing factor was the lack of suitable terrain for the ensuing forced landing.NTSB SEA06TA153Accident · No injuriesFinal reportBell 206L-1 · Busby, MTThe improper overhaul of the turbine assembly by maintenance personnel, which resulted in failure of the turbine and a total loss of engine power. A contributing factor was the pilot's misjudgment of the landing flare at the termination of the autorotation.NTSB SEA06CA080Accident · No injuriesData collectionFinal reportPitrolo GL-25 · Worden, MTThe loss of engine power due to failure of both electronic ignition systems. A contributing factor was the lack of suitable terrain for the forced landing.NTSB SEA06LA074Accident · No injuriesLimited investigationFinal reportCentral Copters Lancair IV-P · Belgrade, MTThe total loss of drive power to the aircraft's propeller while on a visual final approach, due to the decoupling of the quill shaft between the reduction gearbox and the engine power section. Factors include a dark night, no suitable terrain on which to…NTSB 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…NTSB SEA03TA116Accident · Minor injuriesFinal reportMcDonnell Douglas 369E · Big Timber, MTFretting on the outside diameter of the compressor coupling adapter which resulted in fatigue and subsequent fracture of the adapter, and ultimately the disconnection of the compressor from the turbine assembly. Contributing factors were low rotor RPM, uneven…NTSB SEA02FA009Accident · 1 fatalField investigationFinal reportCessna 175C · Miles City, MTThe separation of the number four cylinder exhaust valve guide from the cylinder head, leading to the failure of the exhaust valve stem and the catastrophic failure of the engine while in cruise flight. Factors include the necessity of attempting a forced…NTSB SEA99FA138Accident · Serious injuriesField investigationFinal reportBeech H-35 · Swan Lake, MTDetonation/pre-ignition due to use of improper grade and type of fuel (automotive) and the pilot-in-command's failure to use proper fuel specified by manufacturer's directives.NTSB SEA98LA192Accident · Minor injuriesLimited investigationFinal reportMayala Dragonfly · Avon, MTFailure of the engine crankshaft aft oil seal resulting in the loss of engine oil, and rough terrain during the forced landing.NTSB SEA95LA190Accident · No injuriesLimited investigationFinal reportMooney M20K · Roundup, MTan engine failure due to foreign object ingestion into the oil pump. A ruptured oil inlet screen contributed to the accident.NTSB SEA95LA161Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Havre, MTthe loss of power due to a failure of the cylinder head exhaust valve rocker box. The tall crop encountered during the forced landing is a factor.NTSB SEA95LA050Accident · No injuriesLimited investigationFinal reportBeech S-35 · Wolf Point, MTThe loss of power due to lost oil pressure and a failed connecting rod. Factors include fence posts and dusk lighting conditions which limited visibility.NTSB SEA95IA021Incident · No injuriesIncident investigationFinal reportFairchild SA227 · Missoula, MTThe fatigue failure of the first stage compressor impeller.NTSB SEA91LA031Accident · No injuriesLimited investigationFinal reportBeech 3NM · Bozeman, MTThe failure of the right engine master rod.NTSB SEA90LA148Accident · No injuriesLimited investigationFinal reportBell BH-214 · Thompson Falls, MTCrew's encounter with soft terrain while attempting an autorotation landing after the failure of the main rotor drive system.NTSB SEA90LA137Accident · No injuriesLimited investigationFinal reportSikorsky S-58BT · Ovando, MTThe pilot did not maintain rotor RPM after a compressor assembly blade failure. A related factor was an inadequate autorotation resulting in a hard landing.NTSB DEN90LA060Accident · Minor injuriesLimited investigationFinal reportCessna T207 · Hungry Horse, MTFailure of the #4 connecting rod. Factors related to the accident were: the adverse weather conditions and lack of suitable terrain for a forced landing.NTSB DEN89LA115Accident · No injuriesLimited investigationFinal reportCessna 182G · St. Xavier, MTThe pilot's failure to maintain airspeed while maneuvering for a forced landing following a failure of the number two piston. Contributing to the accident was smoke in the cockpit.NTSB DEN88LA137Accident · No injuriesLimited investigationFinal reportBell 206B3 · Missoula, MTA check airman and a commercial plt were performing an instructional flt. During climbout after a practice autorotation, the engine out audio and light warning activated. Both pilots verified an actual engine out and entered an autorotation. The helicopter…NTSB DEN88IA083Incident · No injuriesIncident investigationFinal reportCessna 210 · Billings, MTNTSB DEN87LA119Accident · No injuriesLimited investigationFinal reportCessna A188B · St. Ignatius, MTAn ag plt was spraying a field near the local arpt, at 100 feet AGL. During an aerial application maneuver, the engine made a loud bang and stopped. The plt leveled the acft, selected a landing site and landed. During the roll out, the acft crossed an…NTSB DEN87LA084Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Conrad, MTAn ag plt was returning from an aerial application. Six miles from the destination arpt the engine quit. The plt attempted to land on a road but the acft struck the edge of a pit, spun across the road and came to rest facing 180 degrees from the original…NTSB DEN86LA040Accident · No injuriesLimited investigationFinal reportHelio H-391B · Bozeman, MTAccording to personnel in the area, the plt radioed he had smoke in the cockpit and was returning to gallantin field, his departure point. Later, the plt transmitted that the eng lost total pwr and he was making a forced landing. During the investigation, it…NTSB DEN85LA209Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Superior, MTThe plt was flying with his wife on a pleasure flight to Idaho when smoke started coming into the cabin. Engine oil pressure went to zero. The plt secured the engine and made a forced landing to a farmer's field. The acft was substantially damaged; however,…NTSB DEN84LA181Accident · No injuriesLimited investigationFinal reportCessna A188B · Opheim, MTThe acft was damaged in a forced landing after the engine quit. The plt said that several weeks prior to the accident hediscovered the fuel crossover quick drain was 'frozen' shut and would not drain. He removed the drain to lubricate it and upon…NTSB DEN84LA052Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Great Falls, MTThe acft was damaged in a forced landing on a highway after the engine seized. The plt said 'the engine made unusual sounds of an engine running bad.' Then it lost compression and seized. He made a forced landing on a highway and damagedthe hull. Examination…NTSB DEN83LA142Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hysham, MTThe plt reported that he aborted his x-country flt due to IMC ahead. While returning to billings, MT, oil & smoke started coming from the eng compartment & oil covered his windshield. The eng began losing power, so he shut it down. While making an emergency…