NTSB investigations, SD
5 cases where NTSB found Wire.
Cases per year
| 2009 | 1 |
|---|---|
| 2012 | 1 |
| 2015 | 2 |
| 2019 | 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\" = 'SD' 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" = 'SD' 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 GAA19CA502Accident · No injuriesData collectionFinal reportAir Tractor AT502 · Onida, SDThe pilot's failure to maintain clearance from power wires during agricultural application operations.NTSB GAA15CA196Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Forest City, SDThe pilot's failure to monitor the flight environment for adequate terrain/obstacle clearance during takeoff, which resulted in the inflight collision with power transmission line wires.NTSB CEN15CA160Accident · Serious injuriesData collectionFinal reportZenith Acft Stol CH 701 · Marion, SDThe pilot failed to maintain control of the airplane while maneuvering to land resulting in contact with a power line and the ground. Contributing to the accident was the pilot's lack of familiarity with the airplane.NTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.NTSB CEN09CA194Accident · Minor injuriesData collectionFinal reportAir Tractor AT-502B · Harrold, SDThe pilot's failure to maintain clearance from the power lines during his turn to reverse course due to weather. Contributing to the accident was the reduced visibility at the time of the accident.