NTSB investigations, MT
6 cases where the defining event was Sys/Comp malf/fail (non-power).
Cases per year
| 2013 | 1 |
|---|---|
| 2016 | 1 |
| 2017 | 1 |
| 2023 | 1 |
| 2024 | 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 e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '330')
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" = '330') 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 WPR25LA122Accident · No injuriesClass 3 · LimitedFinal reportBeech C90A · Helena, MTThe failure of the left main landing gear to fully extend and lock as a result of broken downlock switch wires and the failure of the pilots to complete the manual gear extension checklist.NTSB WPR24LA192Accident · No injuriesClass 4 · LimitedFinal reportSIAI Marchetti SM. 1019 · Twin Bridges, MTThe binding of the parking brake cable, which resulted in un-commanded brake application during the landing roll and subsequent nose over.NTSB WPR23LA269Accident · Minor injuriesClass 3 · LimitedFinal reportCSP Leasing MTO Sport · Gardiner, MTFailure of the rudder/nosewheel steering system for reasons that could not be determined, which resulted in loss of yaw control and a subsequent rollover.NTSB WPR17LA056Accident · No injuriesLimited investigationFinal reportBeech 99 · Billings, MTThe fatigue failure of the left main landing gear (MLG) actuator piston rod, which prevented the hydraulic system from producing pressure to control the MLG’s position and led to the right MLG collapsing during landing.NTSB WPR17IA007Incident · No injuriesIncident investigationFinal reportShort Bros SD3 60 Sherpa · Missoula, MTThe failure of the nose landing gear down-lock piston to engage due to paint accumulation, which resulted in a nose landing gear collapse during landing. Also causal was the failure of the facility that performed the painting to comply with manufacturer…NTSB WPR14CA041Accident · No injuriesData collectionFinal reportBell 206B · Superior, MTThe pilot's failure to maintain aircraft control while maneuvering during a long-line operation.