NTSB investigations, MT
6 cases where the defining event was Collision with terr/obj (non-CFIT).
Cases per year
| 2019 | 1 |
|---|---|
| 2022 | 1 |
| 2023 | 2 |
| 2025 | 2 |
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '470')
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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '470') 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 WPR25LA295Accident · No injuriesClass 3 · LimitedPreliminary reportSiai-Marchetti SF260B · Billings, MTOn September 26, 2025, about 1040 mountain daylight time, a SIAI-MARCHETTI SF 260B, N272C, was substantially damaged when it was involved in an accident near Billings, Montana. The pilot and passenger were not injured. The airplane was operated as a Title 14…NTSB WPR25FA252Accident · 1 fatalClass 3 · FieldPreliminary reportVans RV-7A · West Glacier, MTOn August 12, 2025, about 1457 mountain daylight time, an experimental amateur-built Vans RV-7A N30SG, was substantially damaged when it was involved in an accident near West Glacier, Montana. The pilot was fatally injured. The airplane was operated as a…NTSB WPR24LA069Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Whitefish, MTThe failure of the airport authorities to renew the airport closure NOTAM for the airport. Contributing to the accident, was the pilot’s inability to see the runway closure sign.NTSB WPR23LA311Accident · Serious injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Miles City, MTThe pilot's failure to maintain control of the airplane while landing on unimproved terrain.NTSB WPR22LA321Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Twin Bridges, MTThe student pilot’s failure to maintain airplane control during an aborted landing, and the flight instructor’s delayed remedial action.NTSB WPR19LA213Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 150 · Roundup, MTThe pilot ‘s failure to maintain an adequate altitude above the trees while maneuvering to land.