NTSB investigations, 2016
4 cases where NTSB found Engine (turbine/turboprop), general.
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 5 |
| 2010 | 9 |
| 2011 | 5 |
| 2012 | 2 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 1 |
| 2016 | 4 |
| 2017 | 7 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 6 |
| 2023 | 3 |
| 2024 | 4 |
| 2025 | 2 |
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\", '01057200'))
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", '01057200')) 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 WPR17FA024Accident · 4 fatalField investigationFinal reportPiper PA 31T · Elko, NVA loss of engine power to the left engine for reasons that could not be determined due to the extensive fire and impact damage to the airplane.NTSB CEN17LA009Accident · Minor injuriesLimited investigationFinal reportAero Smart Solutions Lancair Evolution · Iola, KSWater contamination of the fuel due to the pilot’s inadequate preflight inspection, which led to a total loss of engine power. Contributing to the accident was the pilot’s failure to complete the engine-out checklist, which resulted in an excessive loss of…NTSB CEN16LA335Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Cave-In-Rock, ILA total loss of engine power due to air entering the fuel system for reasons that could not be determined based on available information. Contributing to the accident was the pilot’s inability to restart the engine due to the check valve assembly design.NTSB ERA16LA082Accident · Minor injuriesLimited investigationFinal reportPilatus PC-12 · Savannah, GAThe pilots’ failure to follow proper procedures in response to a crew alerting system warning for high engine torque values, which necessitated an off-runway emergency landing during which the airplane sustained substantial damage due to postimpact fire.…