NTSB investigations, 2016
2 cases where NTSB found Fuel controlling system.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 4 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 4 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 6 |
| 2025 | 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01057320'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01057320')) 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 WPR16FA166Accident · Minor injuriesField investigationFinal reportDouglas TA-4K · Las Vegas, NVForeign object debris in the engine's main fuel control unit, which restricted fuel flow and subsequently resulted in the loss of engine power. Contributing to the accident was the installation or addition of an extra seal during the main fuel control unit…NTSB CEN16LA227Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Bowie, TXThe inadequate maintenance and inspection of the throttle control arm, which resulted in its in-flight separation and the subsequent loss of engine power.