NTSB investigations, 2017
5 cases where NTSB found Eng oil sys (airframe furnish).
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 6 |
| 2010 | 6 |
| 2011 | 2 |
| 2012 | 4 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 5 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 2 |
| 2022 | 3 |
| 2023 | 3 |
| 2024 | 7 |
| 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\") = 2017
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '010579'))
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") = 2017 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '010579')) 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 WPR18LA050Accident · No injuriesLimited investigationFinal reportGray Jim Robert Exec · Caldwell, IDFailure of the oil pressure gauge line, which resulted in oil exhaustion and a total loss of engine power.NTSB ANC18LA006Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-300 · Dawsonville, GAThe failure of the pilot, who was not a certified mechanic, to tighten the B-nut on a remotely mounted oil filter line, which resulted in oil exhaustion, a total loss of oil pressure, and a subsequent total loss of engine power.NTSB WPR17LA216Accident · No injuriesLimited investigationFinal reportCessna 172P · TamuningThe pilot's inadequate preflight inspection, which resulted in oil exhaustion and a subsequent total loss of engine power during cruise flight.NTSB ERA17LA338Accident · No injuriesLimited investigationFinal reportParks Richard A Starduster SA 100 · Southfields, NYA loose oil line that allowed oil to drip on the exhaust system, which resulted in smoke during cruise flight and a subsequent precautionary landing.NTSB CEN17FA167Accident · 1 fatalField investigationFinal reportCessna 421C · Huntsville, TXThe pilot's failure to identify the alternate runway, to perform a timely precautionary landing, and to maintain airplane control. Contributing to the accident was the failure of the left engine due to oil starvation for reasons that could not be determined…