NTSB investigations, GA
7 cases where NTSB found Recip eng oil sys.
Cases per year
| 2008 | 1 |
|---|---|
| 2010 | 1 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 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 c.\"eventStateOrRegion\" = 'GA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01058550'))
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 c."eventStateOrRegion" = 'GA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01058550')) 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 ERA17LA109Accident · Minor injuriesLimited investigationFinal reportErcoupe 415 · Dawsonville, GAA decrease in oil pressure due to the pilot's unintentional overfilling of the engine oil sump, and the pilot's subsequent decision to perform an off-airport precautionary landing, which resulted in impact with a tree.NTSB ERA14LA436Accident · Serious injuriesLimited investigationFinal reportBellanca 17-30A · Monroe, GAThe improper installation of the oil filter adapter at an unknown time, which resulted in an oil leak and subsequent oil starvation to the engine.NTSB ERA13FA256Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Macon, GAA total loss of engine power due to oil starvation for reasons that could not be determined due to extensive postcrash fire and heat damage to the engine components.NTSB ERA12LA469Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Statesboro, GAA total loss of engine power as a result of oil exhaustion due to the mechanic's failure to apply appropriate torque to the oil filter.NTSB ERA12LA394Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAA failure of the No. 2 cylinder connecting rod due to a lack of lubrication, which resulted in a total loss of engine power.NTSB ERA10LA179Accident · No injuriesLimited investigationFinal reportFerguson William C FX4-2 · Cartersville, GAThe failure of the engine-driven oil pump drive coupling resulting in a loss lubrication and subsequent loss of engine power.NTSB MIA08LA196Accident · No injuriesLimited investigationFinal reportCessna 120 · Jesup, GAAn oil starvation-induced catastrophic engine failure due to the improper installation of the crankshaft expansion plug during engine overhaul.