NTSB investigations, SC
8 cases where NTSB found Fence/fence post.
Cases per year
| 2011 | 1 |
|---|---|
| 2012 | 1 |
| 2014 | 1 |
| 2016 | 1 |
| 2018 | 2 |
| 2019 | 1 |
| 2022 | 1 |
Where
Open the mapLatest 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\" = 'SC' 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\", '03022047'))
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" = 'SC' 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", '03022047')) 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 ERA22LA202Accident · No injuriesClass 4 · LimitedFinal reportPiper PA32 · Fountain Inn, SCThe pilot’s failure to obtain the proper touchdown point during landing, which resulted in a runway overrun and collision with a fence.NTSB GAA20CA059Accident · No injuriesData collectionFinal reportErcoupe 415 · Greer, SCThe pilot's improper landing flare, which resulted in a hard landing, loss of directional control, and impact with a fence.NTSB GAA18CA467Accident · No injuriesData collectionFinal reportBeech 58 · Greenville, SCThe pilot failure to attain the proper touchdown point on a wet runway, which resulted in insufficient runway remaining to safely stop the airplane.NTSB GAA18CA411Accident · No injuriesData collectionFinal reportEipper Quicksilver · Marietta, SCThe pilot's improper landing flare, which resulted in a loss of directional control.NTSB GAA16CA291Accident · Minor injuriesData collectionFinal reportBilly Amerson Stol CH 750 · Manning, SCThe pilot's failure to maintain directional control during landing, which resulted in an impact with a fence and trees.NTSB ERA14LA425Accident · Minor injuriesLimited investigationFinal reportNavion Navion · Rock Hill, SCThe pilot’s improper fuel management, which resulted in the exhaustion of the fuel supply in the selected fuel tank and a subsequent total loss of engine power.NTSB ERA12LA453Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · North Myrtle Beach, SCThe pilot's inadequate use of carburetor heat during cruise flight, which resulted in a partial loss of engine power and subsequent forced landing.NTSB ERA11CA445Accident · No injuriesData collectionFinal reportPiper PA-32RT-300 · Charleston, SCThe pilot's decision to continue the approach and landing at a high airspeed, which resulted in an improper touchdown point and subsequent runway excursion.