NTSB investigations, NE
16 cases where NTSB found Wire.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 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\" = 'NE' 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" = 'NE' 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 CEN26LA289Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Raven 1 · Scribner, NEThe pilot's failure to maintain clearance from power lines while maneuvering at low-level altitude during an agricultural operation.NTSB CEN25LA292Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · North Bend, NEThe pilot’s failure to maintain clearance from wires while maneuvering at a low altitude, and the ground crew failure to inform the pilot that the support truck had been moved.NTSB CEN25LA274Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Hastings, NEThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB CEN24LA368Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Lexington, NEThe pilot’s failure to maintain proper clearance from powerlines.NTSB CEN24LA285Accident · Serious injuriesClass 4 · LimitedFinal reportCessna A188B · Sumner, NEThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB CEN22LA345Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ithaca, NEThe pilot’s failure to maintain clearance from power lines during low level aerial application operations due to a distraction.NTSB CEN21LA348Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Merry, NEThe pilot’s failure to maintain clearance from a wire during a low-level aerial application flight.NTSB CEN20CA347Accident · Minor injuriesClass 4 · Data collectionFinal reportGrumman G164 · Scottsbluff, NEThe pilot’s loss of visual reference during agricultural low-level flight, resulting in collision with power lines.NTSB GAA19CA480Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Waco, NEThe pilot's failure to maintain clearance from wires during an agricultural application flight.NTSB GAA19CA454Accident · No injuriesData collectionFinal reportCessna T188 · Deshler, NEThe pilot's failure to maintain clearance from wires during low-altitude maneuvering.NTSB CEN16LA352Accident · No injuriesLimited investigationFinal reportCameron Z90 · Morrill, NEThe pilot’s improper inflight fuel management, which resulted in fuel exhaustion and an inability to avoid contact with power lines.NTSB GAA15CA266Accident · Minor injuriesData collectionFinal reportSchweizer G 164B · Paxton, NEThe pilot's failure to maintain adequate distance from a power line during low altitude flight operations, which resulted in an impact with the power line, and subsequent impact with the ground.NTSB CEN14CA403Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Allen, NEThe pilot did not ensure sufficient obstacle clearance for potential wind conditions, which resulted in his loss of control of the helicopter.NTSB CEN13FA241Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Norfolk, NEThe pilot's decision to fly at a low altitude and his subsequent failure to see and avoid power lines.NTSB CEN10LA250Accident · 1 fatalLimited investigationFinal reportAyres S2R · Rushville, NEThe pilot did not maintain clearance from a power line while maneuvering at low altitude.NTSB DEN08LA120Accident · Serious injuriesLimited investigationFinal reportChomo EAA Biplane B1 · Schuyler, NEThe pilot's failure to maintain clearance from the wire due to his diverted attention resulting in in-flight collision with the wire. Contributing to the accident was the pilot's failure to locate an emergency landing site.