I’m mainly talking about watching a TV show or movie that’s originally in English enabling subtitles that’s either in Spanish, German, Russian, Finnish, etc. and can mistakes in translation still occur? I recall watching Lie to Me with Japanese subtitles during a scene involving an interrogation but a key word within the dialog was not translated correctly based on context.
For example, the protagonist said “You’re an accessory for murder” towards the suspect but subtitles used the wrong word choice 小物 (which means “accessories” as in small goods, i.e. stationery or trinkets) when the intended meaning for “accessory” from that context leans more on being a conspirator (共犯者 or 共謀) of a crime (like as in aiding the criminal).
Strangely enough they’re usually well made. There are cases where things are translated slightly differentely than you’d expect to get closer to the original meaning in the other language or to save space (cause this is also often a problem). But these differences are interesting in themselves, like you see a different interpretation. In the rare case where it’s really bad you can tell without knowing the spoken language.