Template Library
Incident Investigation Report Template
An Excel workbook for investigating an incident or near miss: the report with potential risk, a timeline, a cause chain that flags stopping points such as 'operator error', actions rated by strength, and a log that shows how the whole system is performing.
The Report tab records what happened, when, where, and the immediate actions. You score the actual severity, the potential severity, and the likelihood of a repeat, and the potential risk, its band, and a suggested investigation level calculate. The Timeline tab lists what happened in order with the source of each fact and marks the defenses that should have stopped the event.
The Causes tab holds the chain of whys with evidence and a cause category, and checks each answer for stopping points such as 'operator error' or 'retrain'. The Actions tab lists corrective actions with their level in the hierarchy of controls; the strength (Strong, Intermediate, or Weak) calculates, and the Summary checks that there is at least one strong action. The Log and Log summary tabs record every report and show reports by type, reports per 100 employees, days to investigate, and the share of high-potential events fully investigated.
An example forklift near miss is included so you can see a finished report before you replace it.
Download Incident Investigation Report Template Back to Templates
What Is Included in the Workbook
| Sheet | Purpose | What Teams Capture |
|---|---|---|
| How-To | Guidance and disclaimer | Steps and notes |
| Scales | Scoring scales and band limits | Severity and likelihood descriptors, editable band limits |
| Report | The incident or near-miss report | Event details, scores, potential risk and band, investigation level, time to report, people involved by role |
| Timeline | What happened, in order (Excel Table) | Time, event, source, defense that should have stopped it, notes |
| Causes | The chain of whys (Excel Table) | Question or answer, evidence, cause category, stopping-point check, root cause statement |
| Actions | Corrective actions (Excel Table) | Action, cause addressed, hierarchy level, calculated strength, owner, due date, status, overdue flag, effectiveness check |
| Summary | This investigation at a glance | Risk band, investigation level, actions by strength, strong-action check, overdue actions |
| Log | All reports (Excel Table) | Type, area, potential severity and likelihood, band, days to investigate, full investigation done |
| Log summary | The pattern across reports | Reports by type, per 100 employees, high-potential events investigated, average days |
Key Features Inside the Template
Potential Risk, Not Just Outcome
Score the worst credible outcome, so a near miss with serious potential gets a full investigation.
A Stopping-Point Check
Flags answers such as 'operator error', 'lack of attention', and 'retrain' and prompts you to ask why.
Actions Rated by Strength
Elimination, substitution, and engineering are Strong; administrative actions Intermediate; PPE and communication Weak.
A Log That Shows the System
See reports per 100 employees, days to investigate, and whether the high-potential events were investigated fully.
Best Use Cases
- Investigating an injury, near miss, or hazard report
- Training supervisors and safety committee members to investigate without blame
- Showing that investigations lead to strong actions
- Keeping a register of all reports and investigations
- Preparing for an audit of incident management
How to Use the Template Effectively
- Make the area safe, make any report that the rules require, and record the facts on the Report tab.
- Gather evidence and interview those involved, then list what happened on the Timeline tab.
- Ask why until you reach a cause in the system that you can change, and record the evidence on the Causes tab.
- Choose actions from the top of the hierarchy of controls, and check the Summary for a strong action.
- Assign owners and due dates, share the learning, and check later that the actions worked.
- Record every report on the Log tab and review the pattern at the safety committee.
Who Should Use This Template
- Supervisors and safety coordinators
- Safety committee members
- Maintenance and engineering leads
- Quality and operations managers
Common Mistakes to Avoid
- Stopping at 'operator error' or 'failure to follow procedure'
- Judging depth of investigation by the actual outcome instead of the potential
- Listing only weak actions such as retraining and warning signs
- Punishing the person who reported
- Not checking that the actions were done and worked
Important Notes
Incident Investigation Report Template Frequently Asked Questions
How is the investigation level decided?
The potential risk is the potential severity times the likelihood of a repeat, from 1 to 25. High and Extreme suggest a full team investigation, Medium a supervisor-led investigation, and Low a quick check and trend. The band limits are on the Scales tab and you can edit them.
How is the strength of an action decided?
From its level in the hierarchy of controls: Elimination, Substitution, and Engineering are Strong, Administrative is Intermediate, and PPE and Communication are Weak. For serious events, aim for at least one Strong action.
Can I record names?
The template uses roles. Whether to record names depends on your organization's policy and local privacy law, so check before you do.