1976 The Return of the World's Greatest Detective

A Los Angeles cop falls off his motorcycle, strikes his head and wakes up believing himself to be Sherlock Holmes. Along with the social worker who is treating him, he sets out to solve the murder of an embezzler.