NTSB investigations, CA

8 cases where NTSB found Eng oil sys (airframe furnish).

Cases per year

20082026
NTSB investigations, CA per year, 2008–2026: 8 cases
20081
20091
20102
20111
20131
20141
20151

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\" = 'CA' 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\", '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.

NTSB WPR15LA085Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · San Luis Obispo, CAThe pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…Jan 16, 2015 · N232LT · Substantial damageNTSB 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.May 24, 2014 · N97038 · Substantial damageNTSB 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.Jan 5, 2013 · N262NJ · Substantial damageNTSB WPR11LA363Accident · No injuriesLimited investigationFinal reportCessna 340A · Fullerton, CAThe pilot's inability to maintain directional control during landing due to the left brake's degraded performance due to oil contamination, which resulted from the fatigue failure of an oil line component.Jun 1, 2011 · N340BG · Substantial damageNTSB 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.Dec 2, 2010 · N11858 · Substantial damageNTSB WPR10CA181Accident · No injuriesData collectionFinal reportMorrison Joseph Q2 · Frazier Park, CAA partial loss of engine power likely due to the failure of the oil pump.Mar 26, 2010 · N142BP · Substantial damageNTSB WPR09CA137Accident · No injuriesData collectionFinal reportRudolph Ralph Monroe Starlite · Coachella, CAA total loss of engine power due to oil starvation to the rear crankshaft journal.Mar 2, 2009 · N180RR · Substantial damageNTSB SEA08LA133Accident · Minor injuriesLimited investigationFinal reportThrush S-2R · Holtville, CAThe loss of oil pressure for undetermined reasons.May 11, 2008 · N8860Q · Substantial damage