NTSB investigations
18 cases where NTSB found Eng oil dist (airframe furn).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2010 | 3 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2017 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01057920')) 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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01057920')) 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 ERA25LA157Accident · No injuriesClass 3 · LimitedFinal reportBeech E33 · Lenoir, NCThe mechanic’s inadequate annual inspection of the airplane and failure to comply with an applicable airworthiness directive, which resulted in a total loss of engine power due to oil starvation.NTSB CEN24LA211Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Chandeleur Island, LAA fatigue failure of the engine oil pressure line, which resulted in the loss of engine oil during the flight and subsequent damage to the nose landing gear support structure during the precautionary landing.NTSB ERA22LA011Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctls · Greenville, SCA total loss of engine power resulting from the in-flight disconnection of oil hoses from the oil thermostat.NTSB WPR21LA173Accident · Minor injuriesClass 3 · LimitedFinal reportFlight Design Ctsw · Santa Fe, NMA leak in the oil line that supplied the engine with oil, which resulted in oil exhaustion and the total loss of engine power. Contributing to the accident was the routing of the oil line to close to the exhaust manifold.NTSB CEN21LA034Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Lebanon, OHImproper maintenance that resulted in a blocked crankcase breather port and a subsequent 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 WPR14LA207Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Arvin, CAThe pilot’s failure to reconnect the air-oil separator return line after completing an oil change, which resulted in a total loss of engine power due to oil starvation.NTSB WPR13LA085Accident · Minor injuriesLimited investigationFinal reportJeremiah Jackson Vans RV-10 · Julian, CAA loss of engine power due to oil starvation as a result of a disconnected oil line. Contributing to the accident was an insufficiently tightened oil line fitting.NTSB CEN12LA508Accident · Serious injuriesLimited investigationFinal reportCessna 172M · South Wayne, WIInternal engine component failures, which resulted from oil starvation due to debris in the oil system.NTSB CEN12LA357Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Howard, SDA fractured fabricated aluminum oil line, which resulted in oil exhaustion followed by a forced landing.NTSB WPR11LA070Accident · Minor injuriesLimited investigationFinal reportBellanca 7KCAB · Corona, CAThe total loss of engine power due to oil exhaustion as a result of a broken oil line.NTSB CEN11LA005Accident · No injuriesLimited investigationFinal reportMaule MXT-7-180A · Magnolia, ARThe mechanic's failure to properly install an oil drain line after he replaced a cylinder, which caused the engine to seize in flight due to a lack of lubrication.NTSB CEN10CA172Accident · No injuriesData collectionFinal reportKinney Kevin Zenith 601XL · Warren, OHA total loss of engine power due to the failure of an oil hose due to improper installation of the hose.NTSB ERA10LA100Accident · No injuriesLimited investigationFinal reportFpna A-22 Valor · Hunting Island, SCMaintenance personnel's inadequate inspection of the oil system's fittings during a routine oil servicing, which resulted in oil starvation due to a loose and/or detached oil line B-nut fitting that led to the engine seizing while in flight.NTSB CEN09CA354Accident · Serious injuriesData collectionFinal reportThrockmorton Matthew E F1-EVO · Mitchell, INA total loss of engine power due to the disconnection of an oil line and the subsequent loss of engine oil.NTSB SEA08CA176Accident · Minor injuriesData collectionFinal reportCessna 210E · Auburn, WAA catastrophic engine failure due to the partial blockage of the lubricating oil galley in one of the crankshaft connecting rod journals, leading to the failure of the connecting rod cap.NTSB NYC08LA251Accident · No injuriesLimited investigationFinal reportHolmes Arthur Orman Kitfox IV · Burkesville, KYThe total loss of engine power due to the installation of an engine oil filter that did not meet the engine manufacture's specifications.NTSB MIA08FA122Accident · 1 fatalField investigationFinal reportYates Lancair IV-P · Springfield, KYA total loss of engine power due to a loss of engine oil as a result of the installation of the wrong oil adapter O-ring seal.