NTSB investigations, AR
19 cases where NTSB found Wire.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 1 |
| 2010 | 2 |
| 2011 | 1 |
| 2014 | 2 |
| 2016 | 3 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 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\" = 'AR' 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" = 'AR' 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 CEN25LA075Accident · 1 fatalClass 3 · LimitedFinal reportBellanca 7GCBC · Batesville, ARThe pilot’s failure to maintain clearance from powerlines while flying at low altitude.NTSB CEN24LA257Accident · Minor injuriesClass 4 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Sedgwick, ARThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB CEN23LA271Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Siloam Springs, ARThe pilot’s failure to maintain clearance from power lines while on final approach to land.NTSB CEN22LA335Accident · 1 fatalClass 3 · LimitedFinal reportAyres S2R-T34 · Parkin, ARThe pilot’s failure to maintain clearance from tower guy wires while maneuvering.NTSB CEN20CA391Accident · Minor injuriesClass 4 · Data collectionFinal reportChampion 8GCBC · Ozark, ARThe pilot's failure to maintain clearance from a wire during final approach to landing.NTSB GAA19CA177Accident · Minor injuriesData collectionFinal reportChampion 7EC · Fayetteville, ARThe pilot's exceedance of the airplane's critical angle of attack during takeoff as he attempted to avoid power lines, which resulted in an aerodynamic stall.NTSB CEN19FA020Accident · 1 fatalClass 2 · FieldFinal reportHughes 369 · McDougal, ARThe pilot's failure to maintain the helicopter's clearance from the powerline structure while hovering in gusty wind conditions, which resulted in an inadvertent collision with the structure and an uncontrolled descent into terrain.NTSB GAA17CA030Accident · Minor injuriesData collectionFinal reportAir Tractor AT 502 · Paragould, ARThe pilot's failure to avoid electrical wires during low-altitude maneuvering, which resulted in a wire strike.NTSB GAA16CA512Accident · No injuriesData collectionFinal reportAir Tractor AT802 · Wilson, ARThe pilot’s failure to adequately survey the area of operation and his subsequent failure to maintain clearance from power lines during an agricultural application flight.NTSB CEN16LA312Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-502B · Hickory Ridge, ARThe pilot's failure to maintain clearance from a transmission line while maneuvering at low altitude.NTSB CEN15LA015Accident · No injuriesLimited investigationFinal reportCessna P210N · West Memphis, ARA catastrophic engine failure due to an oil starvation event for reasons that could not be determined based on the available evidence.NTSB CEN14CA314Accident · Minor injuriesData collectionFinal reportAir Tractor AT 402B · Newport, ARThe pilot misjudged his altitude which resulted in the airplane contacting a wire during the low altitude aerial application maneuver.NTSB CEN11CA224Accident · Minor injuriesData collectionFinal reportAyres S2R-T34 · Swan Lake, ARAn in-flight collision with power lines following an encounter with a wind gust.NTSB CEN11CA011Accident · Minor injuriesData collectionFinal reportCessna 175C · Humphrey, ARThe pilot’s failure to maintain clearance from a static wire while maneuvering at a low altitude.NTSB CEN10CA391Accident · No injuriesData collectionFinal reportAir Tractor AT602 · Lake Village, ARThe pilot's failure to maintain clearance from the wires during the aerial application pass.NTSB CEN10LA046Accident · Serious injuriesLimited investigationFinal reportYounkin J R Mullicoupe · Siloam Springs, ARA loss of engine power due to fuel starvation for undetermined reasons.NTSB DEN08FA122Accident · 2 fatalField investigationFinal reportHughes 269B · Salesville, ARThe pilot's failure to maintain clearance from the crossing transmission line.NTSB DFW08LA108Accident · Serious injuriesLimited investigationFinal reportWoods Challenger II · Corning, ARThe pilot's failure to maintain clearance from transmission lines. A contributing factor was the low altitude selected by the pilot.NTSB DFW08CA104Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Paragould, ARThe pilot's failure to maintain clearance from electrical wires while maneuvering. Contributing to the accident were binding of the elevator control, inadvertent stall and trees.