NTSB investigations, MT
9 cases where NTSB found Wire.
Cases per year
| 2008 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 1 |
| 2019 | 2 |
| 2022 | 1 |
Where
Latest 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\", '03022032'))
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", '03022032')) 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 WPR23LA001Accident · 1 fatalClass 3 · LimitedFinal reportScoda Aeronautica Ltda Super Petrel LS · Perma, MTThe pilot’s failure to maintain clearance from the powerline.NTSB WPR19FA246Accident · 3 fatalClass 3 · FieldFinal reportBeech 33 · St. Ignatius, MTThe pilot’s decision to maneuver the airplane at a low altitude, which resulted in impact with power lines and terrain.NTSB WPR19LA055Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 180 · Townsend, MTThe pilot’s failure to maintain clearance from power lines while maneuvering at low level, which resulted in a wire strike and subsequent impact with terrain.NTSB GAA18CA533Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 · Cut Bank, MTThe pilot’s failure to see and avoid power wires while maneuvering at low altitude. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.NTSB GAA16CA080Accident · Minor injuriesData collectionFinal reportAviat A1 · Broadus, MTThe pilot's failure to maintain clearance from the wires while flying at a low altitude resulting in a wire strike, a loss of airplane control, and the consequent impact with terrain.NTSB WPR13FA208Accident · 1 fatalField investigationFinal reportBell 206B · Shepherd, MTThe pilot’s loss of control while maneuvering during low-altitude operations due to sudden neurological impairment or incapacitation and the helicopter’s subsequent collision with power lines.NTSB WPR12LA263Accident · No injuriesLimited investigationFinal reportCessna A185F · Winnett, MTA momentary loss of engine power, which led to an emergency descent at night during which the airplane collided with a wire. The reason for the loss of engine power could not be determined because postaccident examination and operation did not reveal any…NTSB WPR12CA025Accident · No injuriesData collectionFinal reportCessna 172K · Florence, MTThe pilot's failure to maintain clearance from a power line during a low-level flight along a river. Contributing to the accident was the pilot's decision to fly at a low altitude.NTSB LAX08LA154Accident · 1 fatalLimited investigationFinal reportMaule MX-7-235 · Boulder, MTThe pilot's decision to continue flight at low altitude in instrument weather conditions and his failure to maintain clearance from a power line. Contributing to the accident were low cloud and visibility conditions.