NTSB investigations, 2016, SC
6 cases where NTSB found Environmental issues.
Cases per year
| 2008 | 7 |
|---|---|
| 2009 | 5 |
| 2010 | 7 |
| 2011 | 7 |
| 2012 | 9 |
| 2013 | 4 |
| 2014 | 5 |
| 2015 | 3 |
| 2016 | 6 |
| 2017 | 4 |
| 2018 | 9 |
| 2019 | 8 |
| 2020 | 3 |
| 2021 | 10 |
| 2022 | 4 |
| 2023 | 6 |
| 2024 | 2 |
| 2025 | 4 |
| 2026 | 4 |
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 year(c.\"eventDate\") = 2016
AND 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\", '03'))
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 year(c."eventDate") = 2016 AND 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", '03')) 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 GAA16CA478Accident · No injuriesData collectionFinal reportCessna 180 · Clemson, SCThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.NTSB GAA16CA426Accident · No injuriesData collectionFinal reportAmerican Champion 8KCAB · Cordova, SCThe pilot's failure to maintain the runway heading, which resulted in the airplane not being aligned with the runway and a subsequent runway excursion.NTSB GAA16CA306Accident · Minor injuriesData collectionFinal reportS.O.C.A.T.A. Rallye 150 · York, SCThe pilot's failure to maintain directional control during takeoff, which resulted in an impact with a peach tree(s).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 ERA16LA148Accident · No injuriesLimited investigationFinal reportFlight Design Ctsw · Hilton Head Island, SCThe pilot's failure to apply carburetor heat following a loss of engine power due to carburetor icing.NTSB GAA16LA172Accident · Serious injuriesLimited investigationFinal reportBalloon Works FIREFLY8B · Rock Hill, SCThe pilot’s inadequate compensation for wind, which resulted in the balloon landing hard and a passenger sustaining a serious injury.