"narcotic," 1938, from goof + ball (n.1); as an intensive of goof (n.), it dates from 1959.
goofball or goof balln. A barbiturate or tranquilizer in the form of a pill, especially when taken for nonmedical purposes.