NTSB investigations, 2015
10 cases where NTSB found Engine (turbine/turboprop).
Cases per year
| 2008 | 18 |
|---|---|
| 2009 | 16 |
| 2010 | 18 |
| 2011 | 19 |
| 2012 | 12 |
| 2013 | 18 |
| 2014 | 13 |
| 2015 | 10 |
| 2016 | 7 |
| 2017 | 16 |
| 2018 | 11 |
| 2019 | 14 |
| 2020 | 8 |
| 2021 | 11 |
| 2022 | 10 |
| 2023 | 10 |
| 2024 | 8 |
| 2025 | 5 |
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\") = 2015
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010572'))
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") = 2015 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010572')) 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 WPR16FA035Accident · 2 fatalField investigationFinal reportAero Vodochody L 39C · Apple Valley, CAA total loss of engine power on takeoff, which resulted from a sudden over-temperature condition due to an improperly adjusted fuel control unit and the deteriorated condition of the fuel nozzles.NTSB ENG16IA001Incident · No injuriesIncident investigationFinal reportBoeing 747 · Russian airspace, JapanThe PW4056 engine experienced an in-flight loss of power because of damage to the low-pressure turbine (LPT) because of the inadequate overhaul inspection and repair instructions that existed at the time of the LPT module's last overhaul. A vane hook in the…NTSB DCA15FA185Accident · Serious injuriesField investigationFinal reportBoeing Boeing 777-236 · Las Vegas, NVThe failure of the left engine high-pressure compressor (HPC) stage 8-10 spool, which caused the main fuel supply line to become detached from the engine main fuel pump and release fuel, resulting in a fire on the left side of the airplane. The HPC stage 8-10…NTSB CEN15LA370Accident · No injuriesLimited investigationFinal reportBell 206B · Cresco, IAThe loss of engine power due to the high-cycle fatigue failure of the third-stage turbine wheel.NTSB ERA15LA280Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369FF · Vega Baja, PRA total loss of engine power due to insufficient lubrication to the engine's No. 2 bearing, which resulted in the failure of the bearing and a subsequent forced landing.NTSB WPR15LA177Accident · No injuriesLimited investigationFinal reportBell 206 L4 · Dewey, AZA total loss of engine power due to the failure of the No. 2 bearing, which resulted from a fractured separator.NTSB WPR15LA159Accident · Minor injuriesLimited investigationFinal reportGarlick UH-1B · Kettle Falls, WAA total loss of engine power due to foreign object (towel) ingestion. Contributing to the accident was maintenance personnel’s inadequate postmaintenance inspection of the engine.NTSB CEN15LA202Accident · No injuriesLimited investigationFinal reportFairchild SA227 AC · Rifle, COThe uncontained engine failure due to the fatigue failure of the second-stage turbine rotor disk.NTSB ENG15IA017Incident · No injuriesIncident investigationFinal reportBoeing 707 338C · Victorville, CAthe fracture of one 1st stage turbine blade from a high cycle fatigue crack that originated from a break in the coating on the leading edge of the blade. The cause for the break in the coating could not be determined. Contributing to the uncontained release…NTSB ERA15LA138Accident · No injuriesLimited investigationFinal reportBell 206 · Sevierville, TNAn uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.