NTSB investigations, 2016
11 cases where NTSB found Oil.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 11 |
| 2010 | 8 |
| 2011 | 5 |
| 2012 | 18 |
| 2013 | 6 |
| 2014 | 14 |
| 2015 | 13 |
| 2016 | 11 |
| 2017 | 15 |
| 2018 | 10 |
| 2019 | 14 |
| 2020 | 9 |
| 2021 | 8 |
| 2022 | 8 |
| 2023 | 7 |
| 2024 | 7 |
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\", '01071020'))
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", '01071020')) 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 WPR17LA050Accident · No injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 NG · Kingman, AZThe loss of engine oil pressure during cruise flight, which resulted in partial loss of engine power and necessitated a forced landing. The loss of oil pressure was the result of a failed engine piston, likely initiated by foreign object damage, which…NTSB ANC17LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA32R · Bethel, AKA total loss of engine power due to oil starvation, which resulted from an oil cooler leak at a fractured brazed seam.NTSB WPR17LA004Accident · Serious injuriesClass 3 · LimitedFinal reportRockwell International 112A · Phoenix, AZA catastrophic engine failure due to lack of lubrication due to the absence of 2 piston cooling nozzles that backed out of their respective threaded bores, which resulted in a forced landing on unsuitable terrain.NTSB ERA17LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Toone, TNA stuck No. 3 cylinder exhaust valve, which resulted in failure of the cylinder's valvetrain components, breach of the cylinder's rocker box cover, and partial loss of engine power due to oil starvation.NTSB CEN17LA010Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Clarendon, TXThe failure of a cylinder piston pin, which resulted in an obstructed oil inlet screen, reduced the amount of oil available to the engine, and led to the subsequent loss of engine power. Contributing to the accident was the failure of the nonmechanic, who had…NTSB ERA16LA333Accident · No injuriesLimited investigationFinal reportRyan Navion · Hurt, VAIncorrect installation of the oil temperature probe and an inadequate annual inspection that failed to detect leaking oil around the loose probe, which resulted in a catastrophic engine failure due to oil starvation.NTSB ERA16FA329Accident · 1 fatalField investigationFinal reportCessna 172 · Laytonsville, MDThe pilot/mechanic's failure to maintain airspeed following a loss of engine power, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Also causal was the pilot/mechanic's failure to service the engine…NTSB CEN16LA309Accident · No injuriesLimited investigationFinal reportCessna 172K · Neenah, WIA loss of engine power due to oil starvation, which resulted from the pilot, who was not a certified airframe and powerplant mechanic, removing the vacuum pump from the engine, and his misconception that he could operate the airplane without the pump.NTSB ERA16LA217Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Westerly, RIA total loss of engine power due to inadequate maintenance of the oil filter adapter, which resulted in an oil leak and subsequent oil starvation to the engine.NTSB GAA16CA317Accident · Minor injuriesData collectionFinal reportRyan Navion · McMinnville, ORThe pilot's failure to replace the oil filler cap following the preflight inspection, which resulted in a loss of engine oil and engine power, an emergency landing, and impact with terrain.NTSB ERA16LA114Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Gainesville, FLThe failure of the engine crankshaft near the Nos. 4 and 5 crankshaft journals due to oil starvation. The reason for the oil starvation could not be determined during postaccident examination.