NTSB investigations, MN
19 cases where NTSB found Wire.
Cases per year
| 2008 | 4 |
|---|---|
| 2010 | 1 |
| 2011 | 1 |
| 2013 | 1 |
| 2014 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2021 | 2 |
| 2022 | 2 |
| 2023 | 2 |
| 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\" = 'MN' 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" = 'MN' 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 CEN24LA139Accident · Minor injuriesClass 4 · LimitedFinal reportAerostar International S53A · Rochester, MNThe pilot’s failure to maintain clearance from power lines while landing in a field.NTSB CEN24LA006Accident · 1 fatalClass 3 · LimitedFinal reportGyro Technic GT-VX2 · Saint Peter, MNThe pilot's failure to maintain clearance from power lines during low-level maneuvering through a river valley.NTSB CEN23LA324Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-402B · Clara City, MNThe pilot’s failure to maintain clearance from a transmission line during an aerial application flight.NTSB CEN22LA387Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Millville, MNThe pilot’s inadequate inflight planning resulted in impact with a power line.NTSB CEN22LA342Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · East Grand Forks, MNThe pilot’s failure to maintain clearance from the power lines during a low-level application pass.NTSB CEN21FA330Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Elgin, MNThe pilot’s decision to operate the helicopter under powerlines, which resulted in a main rotor blade striking a powerline, causing the helicopter to descend from a low altitude and impact terrain.NTSB CEN21LA116Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 600N · Mankato, MNThe pilot’s loss of situational awareness while landing, resulting in an impact with power lines.NTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.NTSB CEN18FA011Accident · 2 fatalField investigationFinal reportCessna 172M · Ramsey, MNThe pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…NTSB CEN14LA486Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Langola Township, MNMaintenance personnel’s failure to apply sufficient torque on the throttle control lever nut, which resulted in a loss of throttle control and subsequent loss of engine power.NTSB CEN14CA442Accident · No injuriesData collectionFinal reportRockwell International S 2R · Kerkhoven, MNThe pilot failure to see and avoid the guide wire during the aerial application flight.NTSB CEN14CA444Accident · No injuriesData collectionFinal reportHughes 369HS · Saint Peter, MNThe pilot did not see the wires resulting in the subsequent wire collision.NTSB CEN13CA272Accident · No injuriesData collectionFinal reportCessna 172M · Thief River Falls, MNThe pilot’s failure to maintain clearance from the power line while on approach to landing.NTSB CEN11CA533Accident · No injuriesData collectionFinal reportGarlick Helicopters OH-58C · Rushford, MNThe pilot's diverted attention, which resulted in the failure to maintain clearance from the power line.NTSB CEN11CA010Accident · Minor injuriesData collectionFinal reportMartin Curtis Zenair CH701 SP · Lonsdale, MNThe pilot's failure to maintain clearance from a power line while on approach to land.NTSB CHI08CA252Accident · No injuriesData collectionFinal reportHiller UH-12E · Cokato, MNThe pilot did not visually identify and maintain clearance with the power lines, and the pilot's inability to maintain control of the helicopter once it contacted the power lines. Factors associated with the accident were the low altitude operations being…NTSB CHI08CA243Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Cosmos, MNThe pilot's failure to maintain clearance from the guide wire while maneuvering on an aerial application flight. Contributing to the accident was the presence of the guide wire.NTSB CHI08CA227Accident · No injuriesData collectionFinal reportHead Balloons AX9-118 · Cook, MNThe pilot's decision to land in a confined area. Contributing to the accident were the hidden power transmission lines and the confined landing site.NTSB CHI08CA176Accident · No injuriesData collectionFinal reportAero Commander S2R · Clontarf, MNThe pilot's failure to maintain clearance from the power transmission lines. Contributing to the accident was the power transmission lines.