NTSB investigations, IN
10 cases where NTSB found Wire.
Cases per year
| 2009 | 3 |
|---|---|
| 2010 | 1 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2017 | 1 |
| 2019 | 1 |
| 2024 | 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\" = 'IN' 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" = 'IN' 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 CEN24LA209Accident · Serious injuriesClass 4 · LimitedFinal reportArbc Inc DBA Lindstrand 90A · Hebron, INThe pilot’s failure to maintain clearance from powerlines while landing in a field.NTSB CEN19FA084Accident · 1 fatalClass 3 · FieldFinal reportPiper PA32R · Goshen, INThe pilot’s failure to maintain adequate altitude for undetermined reasons during a practice circling approach in dark night visual meteorological conditions, which resulted in a collision with power lines.NTSB GAA17CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Vevay, INThe pilot’s failure to see and avoid power lines during an agricultural application flight due to distraction when reading a map.NTSB CEN15CA293Accident · Serious injuriesData collectionFinal reportCessna A188B · Crawfordsville, INThe pilot's failure to maintain clearance from the powerline during an aerial application operations.NTSB CEN15LA026Accident · 1 fatalLimited investigationFinal reportStephenson Stol CH 701 · Mount Vernon, INThe pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…NTSB CEN13LA424Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · Huntingburg, INThe pilot's failure to maintain clearance from a power line during an aerial application maneuver. Contributing to the accident was the pilot's failure to identify potential obstructions in the area before beginning low-altitude maneuvers.NTSB CEN10CA406Accident · No injuriesData collectionFinal reportWSK PZL Mielec M-18A · Muncie, INThe pilot's failure to see and avoid the power line during an aerial application flight.NTSB CEN09CA498Accident · Minor injuriesData collectionFinal reportRans Employee Flying Club Rans S-6S · Montezuma, INThe pilot's failure to maintain aircraft control after takeoff resulting in an impact with a power line and the ground.NTSB CEN09CA371Accident · Serious injuriesData collectionFinal reportBuckeye Dream Mach · Marian, INThe pilot's failure to maintain clearance with the utility pole and power lines.NTSB CEN09CA162Accident · Minor injuriesData collectionFinal reportCameron Balloons V-77 · Terre Haute, INThe loss of the burner pilot light during approach to the landing area and the pilot's failure to relight the burner using alternate sources.