Quick answer: You can solve a real murder case file the way investigators do: fix the time window first, list who was physically able to act inside it, and check every statement against the records. Below is a short fictional case file built like a real one, with a police summary, camera logs, a receipt and statements, and the full solution after a clear spoiler warning.
A scenario: Three friends sit around a laptop after dinner. One reads the police summary aloud, another copies the camera log onto a napkin, and the third is already sure the angry rival dealer did it. Ten minutes later the napkin disagrees, and the argument begins.
Key takeaways
- Opportunity comes before motive: first ask who could have done it, then why.
- Pin the earliest and latest possible moment of the crime before looking at suspects.
- Logs and receipts do not lie; compare every statement with them.
- The loudest suspect is often a red herring; the quiet lie is usually a single number.
Reading about deduction is easy. Hunting through a stack of documents for the one detail that refuses to fit is not. The case below is fictional, but everything you need is on this page. Exactly one person could have done it, and you can prove it without guessing.
How to Approach It
- Find the window. Pin down the earliest and latest moments the crime could have happened.
- List who was physically present during that window. Opportunity first, motive later.
- Check each statement against the records. Logs and receipts don't lie. People sometimes do.
For a deeper version of this method, our beginner's guide to analyzing clues walks through it step by step.
Case File: The Death at Pike & Daughter Antiques
Document 1: Police Summary
At 7:30 p.m. on Thursday, Linda Marsh, the evening cleaner at Pike & Daughter Antiques, arrived for her shift and found the owner, Harold Pike (68), unresponsive in the back office. Emergency services pronounced him dead at the scene. A half-finished mug of tea sat on his desk. Toxicology later confirmed a slow-acting poison in the tea and in a jar of honey on the desk. No poison was found in the kettle, the tea bags, the mug's water supply or any other food in the building.
Document 2: The Building
The shop has two entrances: the front door into the showroom and a back door into the loading bay. Both are covered by cameras that record continuously; the footage has been verified and was not tampered with. The windows do not open. The back office sits between the showroom and the loading bay. The door between the loading bay and the office was locked all day, and only Harold had that key; it was found on his key ring. To reach the office from the loading bay, you must go outside and come back in through the front door.
Document 3: Grocery Receipt (found in Harold's coat)
Corner Market, 5:50 p.m. One jar of clover honey, sealed. One carton of milk.
Police found the honey jar's torn foil seal in the office wastebasket. Nobody else in the shop ever used honey; Harold's niece confirmed he bought it that day because "he'd run out yesterday."
Document 4: Camera Log
- 4:02 p.m. Nora Pike (niece and co-owner) enters through the front door.
- 5:40 p.m. Harold leaves through the front door.
- 6:00 p.m. Harold returns through the front door carrying a grocery bag.
- 6:05 p.m. Tom Reyes (delivery driver) enters the loading bay through the back door with a crate.
- 6:15 p.m. Tom leaves through the back door. The loading bay camera shows he never left the bay during those ten minutes.
- 6:30 p.m. Nora leaves through the front door.
- 6:45 p.m. Mrs. Elena Ortiz (customer) enters through the front door.
- 6:50 p.m. Felix Crane (rival antiques dealer) enters through the front door.
- 6:58 p.m. Felix leaves through the front door.
- 7:05 p.m. Mrs. Ortiz leaves through the front door.
- 7:30 p.m. Linda Marsh enters through the front door.
No one else entered or left the building between 4:00 p.m. and 7:30 p.m.
Document 5: Harold's Phone and Smartwatch
- 6:38 to 6:42 p.m. Outgoing call from Harold's office landline to a regular customer, Mr. Samuel Hart.
- 7:20 p.m. Harold's smartwatch records its last heart rate reading.
Document 6: Financial Note
A partnership agreement found in the office states that if either co-owner dies, the surviving co-owner receives full ownership of the shop and building. The shop's accountant told police that Harold had planned to sell the building the following month, against Nora's wishes.
Document 7: An Email
From Felix Crane to Harold Pike, sent Tuesday: "You undercut me on the Whitfield estate for the last time. You'll regret this, old man."
The Statements
Witness: Samuel Hart (customer, by phone)
"Harold called me about a clock I'd asked him to find. I could hear him sipping something. He laughed and said the new honey was far too sweet, but he was drinking the tea anyway. He sounded completely normal."
Witness: Elena Ortiz (customer, in the showroom)
"I came in to look at a mirror. Harold came out from the office just as I arrived and stayed with me. Then that other dealer, Mr. Crane, walked in and started shouting about some estate sale. Harold told him to leave. They never went near the office; I was standing right between them and the office door the whole time. After Mr. Crane left, Harold walked me to the door and went back to his office. That was just after seven."
Suspect: Felix Crane
"Yes, I sent that email, and yes, I went there to have it out with him. I was angry. But I was in that showroom for eight minutes, in front of a customer, and I never set foot in his office. I'd never been in the building before that evening."
Suspect: Tom Reyes
"I dropped the crate in the bay like always. The office door was locked, same as every week. I didn't see Harold. Didn't see anyone."
Suspect: Nora Pike
"I was doing the books in the front showroom most of the afternoon. My uncle came back from the store around six and I left right after, maybe five past. I never went into the back office that evening, and I didn't know he'd bought anything at the store."
Suspect: Linda Marsh
"I got there at 7:30 like every Thursday. The office light was on. I found him in his chair and called 911 right away."
Your Turn
Stop here and work it out:
- What are the earliest and latest moments the poison could have gone in?
- Who was inside, with access to the office, during that window?
- Which statement contradicts a record?
Write down your answer and two facts that support it, then scroll down.
Spoiler warning: the solution follows.
Solution
Step 1: The Window
The poison was in the honey, bought sealed at 5:50 p.m. and carried into the building by Harold at 6:00 p.m. The jar could not have been poisoned before 6:00.
Between 6:38 and 6:42, Samuel Hart heard Harold drinking tea and commenting on "the new honey," so the poisoned honey was already in the mug. The poison went into the jar between 6:00 and about 6:40 p.m. Fix that window and most suspects fall away on their own.
Step 2: Who Had Access
| Person | Inside the building | Could reach the office, 6:00 to 6:40? | Result |
|---|---|---|---|
| Linda Marsh | From 7:30 | No, arrived after the window and after the last smartwatch reading | Ruled out |
| Felix Crane | 6:50 to 6:58 | No, arrived after Harold was already drinking the tea; Mrs. Ortiz kept him away from the office | Ruled out |
| Tom Reyes | 6:05 to 6:15 | No, stayed in the loading bay; the bay door to the office was locked | Ruled out |
| Nora Pike | 4:02 to 6:30 | Yes, inside for the first half hour of the window | Only person with opportunity |
Felix's email is a motive, and motive without opportunity convicts no one.
Step 3: The Lie
Nora said she left "maybe five past" six, right after Harold returned. The front door camera shows her leaving at 6:30. She shaved 25 minutes off her own timeline, and those 25 minutes are exactly when the new honey jar sat in the building with her still inside.
She also claimed not to know Harold had bought anything, yet told police he bought the honey "because he'd run out yesterday."
Step 4: Motive
The partnership agreement gives the surviving co-owner the shop and building, and Harold was about to sell against her wishes. Motive supports the conclusion, but we didn't need it. Opportunity and a proven lie did the work.
The Answer
Nora Pike poisoned the honey. She was the only person with access to the office between 6:00 and 6:40, she lied about when she left, and she stood to gain the entire business.
How the Case Was Built to Fool You
If you picked Felix, you took the bait the case was built to offer:
- A loud red herring. Felix sends a threatening email and shows up shouting on the night of the death, yet the timeline clears him completely.
- Two independent witnesses. Mr. Hart pins down when the tea was being drunk; Mrs. Ortiz pins down where Felix was. Neither knows they hold the critical evidence.
- A quiet denial. Nora sounds calm and helpful. Her lie is a single number, visible only against the camera log.
The trap is choosing the suspect with the obvious motive and bending the evidence to fit. More on that in 5 logic mistakes players make in detective games.
Want a Bigger Case?
The cases on Forgotten Mystery are longer, with forensic reports, bank records, phone data and interrogation transcripts, but they work the same way: the answer is in the documents, and you prove it before you accuse. Start with the free case.
If catching a suspect in a contradiction is your favorite part, Interrogation Room: Murder (also on Google Play) turns that into a game: you choose your questions, the answers go into a notebook, and the suspect's patience runs out if you waste turns.
Which of our games fits you next?
- Another full file, with friends on their own phones: UnsolvedMurderMystery.com gives your group a private room with text chat, and voice chat on Premium for up to 8 players. Its cases are complete police files of fictional unsolved cold cases, and the first one is free.
- A case file live with 2 to 8 players: ColdCaseOnline.com, where the group reads one file together and names the killer once everyone agrees.
- Printed and spread across a table: our printable cold case files, for solo or group play over about 2 to 3 hours, with sealed envelopes and the solution in the last one.
- A whole case inside one phone: Cold Crime, where you go through the victim's messages, call log and photos. All cases are free.
- A quick logic break: Detective Grid, where you flip cards and rule out suspects one clue at a time; the daily case is free in the browser. More on our games page.
FAQ
Is this based on a real murder case?
No. Every name, place and event in this case file is invented. It mirrors the structure of a real investigation file without referring to any real victim.
Why doesn't the motive matter more?
Because two people had motive and only one had opportunity. In a well-built mystery, motive explains why; opportunity and contradictions prove who.
What is in a real murder case file?
Typically a summary report, scene and forensic findings, records such as phone logs, receipts or camera footage, and witness statements. Solving one means comparing those sources until one account no longer fits.
How can I get better at cases like this?
Practice building the time window first, every time. Short puzzles like our murder mystery riddles train that reflex before a full case.