NTSB investigations
60 cases where NTSB found Eng oil sys (airframe furnish).
Cases, newest first
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\", '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 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 ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.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 WPR09LA153Accident · 1 fatalLimited investigationFinal reportHowes RV-6 · Paulden, AZA total loss of engine power due to oil starvation as a result of a leak from the inadequate weld repair of a high-pressure oil line. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering that resulted in a stall during an…NTSB WPR09CA137Accident · No injuriesData collectionFinal reportRudolph Ralph Monroe Starlite · Coachella, CAA total loss of engine power due to oil starvation to the rear crankshaft journal.NTSB DFW08CA236Accident · No injuriesData collectionFinal reportPiper PA-32R-300 · Augusta, KSA loose oil line that resulted in a total loss of engine oil, causing the engine to cease.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.NTSB SEA08LA133Accident · Minor injuriesLimited investigationFinal reportThrush S-2R · Holtville, CAThe loss of oil pressure for undetermined reasons.NTSB ENG08IA022Incident · No injuriesIncident investigationFinal reportBoeing 747 · Newark, NJAn engine fire in the No. 3 engine due to the failure of, and subsequent flammable fluid leak from, one of three fuel or hydraulic lines located in the engine's accessory raceway that ignited when the fluid came in contact with the hot engine cases.…