NTSB investigations, MT
12 cases where the first occurrence was “Loss of engine power(partial) - nonmechanical”.
Cases per year
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 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\" = 354)
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" = 354) 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 SEA94LA086Accident · No injuriesLimited investigationFinal reportCessna 182G · Belgrade, MTThe loss of engine power for undetermined reasons. The intentional ground loop and the fence were factors in the accident.NTSB SEA93LA090Accident · Minor injuriesLimited investigationFinal reportCessna 182M · Hamilton, MTThe pilot's improper use of carburetor heat. A factor which contributed to the accident was the carburetor icing conditions.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 SEA92LA017Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Belt, MTA blocked fuel vent and an inadequate preflight inspection, which resulted in fuel starvation.NTSB SEA91LA053Accident · No injuriesLimited investigationFinal reportBeech 95 · Roundup, MTPartial loss of power for undetermined reasons.NTSB DEN89LA079Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Wolf Point, MTThe failure of the student pilot to use carburetor heat in a timely manner which resulted in a partial loss of engine power. Contributing to the accident was the inadequate weather evaluation the pilot made after taking off and flying through fog due to his…NTSB DEN88LA031Accident · Serious injuriesLimited investigationFinal reportCessna 170B · Conner, MTOn takeoff from a private, grass strip the pilot stated the engine began to lose power at approximately 20 to 30 feet AGL. A ravine was ahead and he attempted to stretch his glide to the FAR side of the ravine; however, the aircraft stalled and crashed into…NTSB DEN87LA144Accident · No injuriesLimited investigationFinal reportCessna 188B · Malta, MTAfter takeoff on initial climb the acft had a pwr loss which resulted in a forced landing. A hard landing occurred in an open field which sheared off the main landing gear and damaged the airframe. The cause of the pwr loss could not be determined.NTSB DEN86LA188Accident · No injuriesLimited investigationFinal reportPiper J-3 · Ashland, MTPlt did not possess a plt certificate or medical certificate. The plt stated that he fueled the acft with the 'last gas in the storage tank.' The plt preflighted the acft and took off. Shortly after takeoff the engine lost power. The plt executed a landing in…NTSB DEN86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Harve, MTAccording to the plt, shortly after takeoff the eng lost partial pwr as a result of carb ice, & a forced landing was made.NTSB DEN85LA063Accident · No injuriesLimited investigationFinal reportCessna 150 · Missoula, MTOn jan 14, 1985, a Cessna 150 nosed over after landing on a highway near Missoula, MT. The pilot stated he lost partial engine power due to carburetor icing conditions encountered enroute from great falls, MT. The pilot and his passenger were not injured. The…NTSB DEN83LA202Accident · No injuriesLimited investigationFinal reportPiper PA-11-90 · Babb, MTThe pilot said that before takeoff, he fueled the left tank of the aircraft. The right tank was reportedly empty. Five or ten minutes after takeoff the pilot put the acft into a 5 degree left forward slip for about 30 seconds. As soon as the pilot returned…