NTSB investigations, OK
14 cases where NTSB found Wire.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 4 |
| 2011 | 2 |
| 2012 | 1 |
| 2017 | 1 |
| 2018 | 1 |
| 2022 | 2 |
| 2023 | 1 |
| 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\" = 'OK' 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" = 'OK' 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 WPR26LA277Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206B III · Stonewall, OKThe pilot’s failure to maintain clearance from power lines while conducting a low-altitude aerial application.NTSB CEN23FA360Accident · Serious injuriesClass 3 · FieldFinal reportPiper PA-24-250 · Oklahoma City, OKThe pilot’s mismanagement of fuel, which resulted in fuel starvation and a subsequent total loss of engine power.NTSB CEN22LA395Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Prue, OKThe pilot’s failure to maintain clearance from power lines during intentional low-level maneuvering.NTSB CEN22LA154Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150 · Wade, OKThe student pilot’s failure to maintain clearance from power lines during takeoff.NTSB CEN18FA201Accident · 1 fatalField investigationFinal reportAyres S2R · El Reno, OKThe pilot's failure to maintain clearance from tower guy wires while maneuvering during an aerial application flight.NTSB CEN17CA120Accident · Serious injuriesData collectionFinal reportAero Commander S2R · Fairmont, OKThe pilot’s failure to maintain clearance from a power line while conducting agricultural spray operations.NTSB CEN12CA533Accident · No injuriesData collectionFinal reportThrush S-2R · Newkirk, OKThe pilot’s failure to maintain clearance from power lines.NTSB CEN12LA047Accident · Serious injuriesLimited investigationFinal reportSaber Trike unk · Okmulgee, OKThe in-flight collision with electrical wires for undetermined reasons.NTSB CEN11CA509Accident · No injuriesData collectionFinal reportBell 206B · Temple, OKThe pilot’s failure to maintain clearance from static power lines.NTSB CEN09FA562Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Tulsa, OKThe non-instrument-rated pilot’s decision to attempt flight in instrument meteorological conditions, which resulted in spatial disorientation and an in-flight collision with a radio tower guy wire.NTSB CEN09CA479Accident · Serious injuriesData collectionFinal reportPiper PA28-151 · Purcell, OKThe student pilot's failure to see and avoid the power lines.NTSB CEN09CA359Accident · No injuriesData collectionFinal reportHiller UH-12E · Stringtown, OKThe pilot's failure to maintain clearance from power lines. Contributing to the accident was the pilot's preoccupation with personal affairs.NTSB CEN09CA133Accident · Minor injuriesData collectionFinal reportBrantly B-2B · Cement, OKThe pilot's failure to maintain proper airspeed and descent rate during approach, which resulted in a hard landing. Contributing to the accident were the nearby power lines.NTSB DFW08CA229Accident · No injuriesData collectionFinal reportSukhoi SU-31M · Collinsville, OKThe pilot's failure to maintain clearance from marked transmission lines while on final approach.