NTSB investigations, MT
11 cases where NTSB found Runway/land/takeoff/taxi surface.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 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\", '030230'))
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", '030230')) 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 WPR24LA071Accident · Minor injuriesClass 4 · LimitedFinal reportLearjet 55 · Livingston, MTThe flight crew’s decision to land on a snow-covered runway with a tailwind, resulting in a runway excursion and subsequent impact with terrain. Contributing to the accident, was the failure of the airport authority to plow the runway.NTSB WPR23LA266Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-12 · Judith Gap, MTThe pilot's decision to take off on a soft field that exceeded the performance capabilities of the airplane, which resulted in an impact with a pole and terrain.NTSB WPR21LA096Accident · No injuriesClass 4 · LimitedFinal reportHeckel Super Sportsman · Spotted Bear, MTThe pilot’s failure to maintain aircraft control during the landing roll on an unimproved snow-covered runway which resulted in a nose-over.NTSB WPR20CA250Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Kalispell, MTThe pilot's excessive speed while landing on a wet grass runway, which resulted in a runway excursion and impact with a fence.NTSB GAA18CA240Accident · No injuriesData collectionFinal reportBrown Joseph Sportsman GS-2 · Kalispell, MTThe pilot’s selection of an unsuitable snow-covered airstrip for landing, which resulted in a nose-over.NTSB GAA16CA353Accident · Minor injuriesData collectionFinal reportCessna 182 · Hungry Horse, MTThe pilot's decision to land on unsuitable wet terrain, and his failure to stop prior to the end of the runway, which resulted in a runway overrun and impact with tree(s).NTSB WPR14CA384Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Meadow Creek, MTThe pilot's inadequate landing flare and failure to maintain aircraft control during landing.NTSB WPR12CA145Accident · No injuriesData collectionFinal reportRockwell International 690C · Conrad, MTThe pilot did not maintain directional control of the airplane due to ice and slushy snow on the runway during the landing roll.NTSB WPR09CA421Accident · No injuriesData collectionFinal reportMeyer Robert AIR CAM · Hamilton, MTThe separation of the right main landing gear wheel due to the flight's encounter with soft terrain while landing on an unimproved river sandbar. Contributing to the accident was the pilot's decision to attempt a landing on an unimproved off-airport surface.NTSB SEA08CA118Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Libby, MTThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during the landing rollout.NTSB SEA08CA102Accident · No injuriesData collectionFinal reportPiper PA-22/20 · Three Forks, MTThe pilot's inadequate compensation for wind conditions during landing. A gusting crosswind was a contributing factor.