NTSB investigations, 2016, SC
3 cases where NTSB found Aircraft systems.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2013 | 3 |
| 2014 | 4 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 5 |
| 2019 | 3 |
| 2020 | 5 |
| 2021 | 6 |
| 2022 | 3 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 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 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\", '0102'))
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", '0102')) 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 ERA17LA053Accident · Minor injuriesLimited investigationFinal reportBroussard Broussard MH 1521 · Simpsonville, SCThe pilot’s inability to maintain directional control during the landing roll due to a flat left main landing gear tire.NTSB GAA16CA302Accident · No injuriesData collectionFinal reportPiper PA 28 · Rowesville, SCThe fuel line failure between the fuel transducer and the carburetor, which resulted in a total loss of engine power and subsequent forced off airport landing.NTSB ERA16LA135Accident · No injuriesLimited investigationFinal reportCessna 210L · Myrtle Beach, SCA complete loss of electrical power, which resulted from the separation of an alternator wire due to corrosion. Contributing to the accident was the failure of the emergency landing gear extension system due to a lack of hydraulic fluid, which resulted in…