NTSB investigations, 2016
5 cases where NTSB found Debris/dirt/foreign object.
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 5 |
| 2010 | 3 |
| 2011 | 4 |
| 2012 | 4 |
| 2013 | 5 |
| 2014 | 16 |
| 2015 | 10 |
| 2016 | 5 |
| 2017 | 9 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 6 |
| 2021 | 6 |
| 2022 | 5 |
| 2023 | 1 |
| 2024 | 6 |
| 2025 | 3 |
| 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03022055'))
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", '03022055')) 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 WPR17LA030Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Scottsdale, AZThe pilot’s loss of directional control during the landing roll, which resulted in the runway excursion onto the rock-covered runway safety area.NTSB GAA17CA057Accident · No injuriesData collectionFinal reportPiper PA18 · Mouth of The Big Susitna River, AKThe pilot’s decision to take off with a gusting quartering tailwind and his subsequent loss of airplane control.NTSB GAA16CA503Accident · Minor injuriesData collectionFinal reportCessna 185 · Fairbanks, AKThe pilot’s failure to recognize he was taking off with a tailwind and his inadequate compensation for taking off with a tailwind, which led to the airplane’s failure to attain a climb and a subsequent forced landing.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 GAA16CA321Accident · No injuriesData collectionFinal reportAir Tractor AT 502 · Delhi, LAThe pilot's inability to maintain directional control during the landing roll as a result of a piece of concrete from the runway impacting the right main landing gear brake during the landing roll, resulting in a right brake failure and a ground loop.