In this work, superhydrophobic ytterbium oxide coatings were fabricated via the solution precursor plasma spray process under atmospheric and low-pressure conditions. Firstly, Yb2O3 coatings were deposited via the solution precursor atmospheric plasma spray (SPAPS) process by an injection of Yb(NO3)3 solution into atmospheric plasma. The SPAPS coatings exhibited hierarchical columnar structures composed of micron-sized clusters with nanometer-sized splats/particles on the top surface. The SPAPS coating showed a water contact angle (WCA) of ~163o, a roll-off angle (RA) of ~6o, and multiple complete droplet rebound behavior. Based on the SPAPS process, a novel solution precursor vacuum plasma spray (SPVPS) process was developed by injecting Yb(NO3)3 solution into low-pressure plasma. Highly-dense Yb2O3 coatings with relatively consistent microstructures were deposited at different standoff distances at 150 mbar. The coating showed relatively flat topographies, resulting in a WCA of ~155o and a RA of ~28o. The dense SPVPS coating maintained a high microstructural integrity and relatively consistent hydrophobicity after a comprehensive set of mechanical tests, showing a higher mechanical robustness than the SPAPS coatings. By increasing the chamber pressure to 250 mbar and using a glancing angle deposition method, superhydrophobic coatings with bump-structures and inter-bump gaps were deposited via the SPVPS process, showing a WCA of ~160o and a RA of ~7o. The Yb2O3 coatings showed reversible wetting behaviors. The as-deposited coating was superhydrophilic while it became superhydrophobic after vacuum (1-15 Pa) treatment. The superhydrophobic coating again became superhydrophilic after Ar-plasma cleaning or heat treatment, while it regained the superhydrophobicity after another vacuum treatment. The investigation of the surface composition showed that hydrocarbon species increased significantly after vacuum treatment and decreased dramatically after Ar-plasma cleaning or heat treatment, indicating hydrocarbon adsorption/desorption on the surface was the decisive factor for the reversible wettability of the coating. The surface composition of Yb2O3 coatings after long-term (over 10 months) air exposure, Yb2O3 coatings after ultra-high vacuum (~10-7 Pa) treatment and Al2O3 coatings after vacuum treatment (1-15 Pa) were investigated, showing the WCA variation of all the coatings after different treatments was closely related to the amount of hydrocarbon species adsorbed on the surface.