Mystery Science provides ready-made science mysteries for elementary school students. Each lesson contains a central mystery, discussion questions, supplemental reading, and a hands-on activity.
We have access to the paid version of this site for grades K-4.