NTSB investigations, MT
19 cases where NTSB found Fluids/misc hardware.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2014 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 1 |
| 2025 | 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '0107'))
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0107')) 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 WPR25LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 182M · Willow Creek, MTThe pilot’s inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR24LA048Accident · Minor injuriesClass 4 · LimitedFinal reportFlight Design Ctls · Hungry Horse, MTThe pilot's inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR22LA337Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Seeley Lake, MTThe loss of engine power due to fuel starvation as a result of unporting of the fuel.NTSB WPR22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-30 · St Ignatius, MTA partial loss of power during takeoff for undetermined reasons.NTSB WPR22LA231Accident · Serious injuriesClass 3 · LimitedFinal reportJames C Geyman RV-9A · Missoula, MTThe pilot’s improper fuel management, which resulted in fuel starvation and a loss of engine power. Contributing to the accident was the pilot’s failure to activate the auxiliary fuel boost pump, which inhibited a successful engine restart.NTSB WPR22LA024Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182Q · St Ignatius, MTThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR21LA315Accident · No injuriesClass 4 · LimitedFinal reportBellanca 14-19-3 · Whitefish, MTA total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to accomplish a preflight inspection.NTSB WPR20LA308Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 30 · Billings, MTThe pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB GAA18CA220Accident · No injuriesData collectionFinal reportPiper PA 22 · Shelby, MTThe pilot’s improper use of the fuel selector, which resulted in fuel starvation to the engine and an off-runway landing.NTSB GAA17CA529Accident · Minor injuriesData collectionFinal reportCessna 182 · Fairfield, MTThe pilot's failure to secure the right fuel cap during the preflight inspection, which resulted in fuel exhaustion, a total loss of engine power, and an off-airport hard landing.NTSB WPR16CA145Accident · Minor injuriesData collectionFinal reportBeech 19A · Helena, MTThe pilot's failure to reposition the fuel selector valve to the on position prior to takeoff resulting in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.NTSB WPR14LA269Accident · Minor injuriesLimited investigationFinal reportPiper PA 30 · Kalispell, MTThe pilot’s inadequate preflight planning and checks, during which he failed to determine the quantity and distribution of the fuel, which resulted in the loss of right engine power during takeoff due to fuel starvation.NTSB WPR11LA289Accident · Serious injuriesLimited investigationFinal reportLemond FLY Fisher · West Glacier, MTA total loss of engine power during takeoff due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB WPR11CA296Accident · Minor injuriesData collectionFinal reportCessna 188 · Glasgow, MTThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR10LA180Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Terry, MTThe pilot's failure to maintain directional control during the landing roll in gusting winds. Contributing to the accident was a loss of engine power on final approach due to fuel exhaustion as a result of the pilot having to divert due to deteriorating…NTSB WPR09MA159Accident · 14 fatalClass 1 · MajorFinal reportPilatus PC-12/45 · Butte, MT(1) the pilot's failure to ensure that a fuel system icing inhibitor was added to the fuel before the flights on the day of the accident; (2) his failure to take appropriate remedial actions after a low fuel pressure state (resulting from icing within the…NTSB WPR09CA092Accident · No injuriesData collectionFinal reportRyan Navion · Three Forks, MTA total loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel system management. Contributing to the accident were the pilot's diverted attention and failure to perform the prelanding checklist.NTSB DCA09IA014Incident · No injuriesIncident investigationFinal reportBoeing 777 · Bozeman, MTAn accumulation of ice in the fuel system, which formed from the water normally present in jet fuel during commonly encountered flight conditions, which accreted and released, restricting the fuel flow at the right engine fuel-oil heat exchanger inlet face.…NTSB LAX08LA212Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Kalispell, MTA partial loss of engine power during initial climb due to fuel system contamination by a foreign substance. Contributing to the accident was the uneven terrain.