NTSB investigations, MT
9 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2004 | 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\" = 352)
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" = 352) 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 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.NTSB SEA97LA116Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Hysham, MTA failure of an engine exhaust valve and the pilot's misjudgement of altitude/distance during an emergency landing at an airstrip.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 DEN88FA097Accident · 2 fatalField investigationFinal reportCessna 150 · Deer Lodge, MTNTSB DEN87LA179Accident · Minor injuriesLimited investigationFinal reportCessna 175 · Kalispell, MTThe pvt plt was on a x-country flight. The engine began running rough, made a 'bang' sound and lost partial power. Smoke entered the cockpit, oil pressure was lost and the plt initiated an emergency landing. The acft ldg gr struck powerlines on approach to a…NTSB DEN86LA236Accident · Serious injuriesLimited investigationFinal reportMayala Dragonfly · Helena, MTThe acft was on final apch after completing a x-country from billings, MT, when the accident occurred. The plt stated the acft was low after intercepting the VASI so power was added; however, the eng did not respond. The acft struck a small hill 300 ft short…NTSB DEN85LA218Accident · No injuriesLimited investigationFinal reportDowner Aircraft Industries REP. Seabee RC-3 · Haugan, MTThe plt had reconditioned N6305K and was flying the acft to his home in Texas. He continued to state that while climbing through 6500 ft, he heard an unusual noise followed by a substantial loss in pwr. The plt executed an emergency landing on a forest…NTSB DEN84LA240Accident · No injuriesLimited investigationFinal reportCessna 310Q · Havre, MTDuring cruise flight with five adults and two infants on board, the pilot noted left engine oil pressure decreasing and a visible oil leak. Engine shutdown and propeller feather were accomplished but altitude could not be maintained. A forced landing was…NTSB DEN82DA060Accident · No injuriesFinal reportCessna 170B · Worden, MTThe pilot reported that the carburetor heat control became inoperative while on a cross-country flight. The weather conditions were conducive to the formation of carburetor ice. A decision was made to land in an alfalfa field while the engine was still…