Inspections & safety · Free Word and Excel template

Near-Miss Report Form and Log

A one-page form where the driver records what almost happened: when and where, what happened, its category, what it could have led to, what they did and how to stop it happening again. A reviewer section finds the root cause with the 5 whys and sets the corrective action and its owner. The Excel log follows every report to closure and summarizes reports each month by category and location.

Free: enter your name, email and job title and we email you the file. The form opens in Word, Google Docs and LibreOffice; the log works in Excel, Google Sheets and LibreOffice Calc, with no macros.
  • 7 sections on one A4 page
  • Excel log with status, overdue flags and monthly charts
  • Anonymous reporting if preferred
Preview: Near-miss log.xlsx
Report no.DateLocationCategoryWorst likely outcomeOwnerDueStatusDays open
NM-00012026-08-04Main depotReversing / manoeuvringPerson struck or injuredDepot supervisor2026-08-20Closed14
NM-00032026-09-02City streetsFatigueRun-off-road or rolloverDispatch coordinator2026-10-01Overdue43
NM-00042026-09-17Customer sitePedestrianPerson struck or injuredReview overdue28
NM-00052026-09-25HighwayLoad / securingLoad fell or was damagedDepot supervisor2026-11-10In progress20
NM-00072026-10-10HighwayRoad / weatherCollision with another vehicleAwaiting review5
Example rows with an as-of date of 15 October 2026 and a 7-day review window. The printable Word form has 7 sections.
What's inside

A one-page report form and a follow-up log

The driver fills in the form the same working day, the reviewer completes their section, and the report becomes a row in the log until the corrective action is closed.

  1. 01

    Form: when, where and what happened

    Date, time, location, city or branch, plate, vehicle type, trip and conditions, plus space to describe what happened in a few lines.

  2. 02

    Form: category and likely outcome

    Ten categories plus Other: speeding, following distance, fatigue, distraction and phone, road and weather, other road user, load, vehicle defect, reversing and pedestrians. Then what could have happened and the potential severity.

  3. 03

    Form: what the driver did and suggests

    The immediate action the driver took, their suggestion to prevent a repeat, and optional reporter details with an anonymous option.

  4. 04

    Form: reviewer section

    Report number, five lines for the 5 whys, the root cause, a corrective-action table with owner and due date, and closure boxes.

  5. 05

    Excel: near-miss log

    One row per report with drop-downs for location, category, outcome and severity, a calculated status, days open, and checks for missing data.

  6. 06

    Excel: monthly summary

    Reports by month, category and location with three charts, plus near misses per 100,000 km once you enter monthly fleet km.

What is a near miss in a vehicle fleet?

A near miss is a situation that almost ended in a collision, injury or damage, and did not, thanks to late braking, someone paying attention or plain luck. A truck reverses while a worker walks behind it and stops a meter away. A pallet slides inside the box on a bend and does not fall.

A near miss leaves no visible damage, so the fleet office only hears about it if the driver reports it. A near-miss report form makes that report easy: one page, filled in a few minutes, with no need to name who was at fault.

Why does near-miss reporting matter?

Near misses and real accidents often share the same causes: a tight schedule, a yard with no pedestrian walkway, a missing item on the daily check. The difference is that a near miss shows the cause without anyone paying for it. Fix the cause and the same situation is less likely to come back with a worse outcome. To estimate what a real accident could have cost, use the Road Accident Cost Calculator.

Near misses also happen more often than accidents, so they give you more data, earlier, on where and what the hazards are. The idea of a "safety pyramid" is often quoted: serious accidents sit on a wider base of minor incidents and near misses. The ratios usually attached to that pyramid vary between studies and are still debated, so use the idea and do not base decisions on the numbers.

Reporting only works if drivers trust that a report will not be used against them. That is why the form says plainly that it is not used for discipline, allows anonymous reports, and asks for what happened rather than who was to blame.

How do you set up near-miss reporting, step by step?

  1. Announce the no-blame rule in writing before you hand out the form, and say where to hand it in: the supervisor, a box at the depot, or a photo sent to the safety officer.
  2. Keep the form in every vehicle and ask drivers to fill it in the same working day, while the details are fresh.
  3. Log every report in the Excel log when it arrives, even before review starts. The review window counts from the report date.
  4. Review the report with the 5 whys until you reach a cause you can fix, then set the corrective action, its owner and its due date.
  5. Close the report and tell the reporter the outcome, and go through the monthly summary at the safety meeting to see which categories and locations repeat.

Which near-miss categories does the form use?

The driver ticks one or more categories. The same categories are in the drop-down on the log, so the summary counts reports by them:

CategoryExample
SpeedingTook a bend too fast and drifted slightly out of lane.
Following distanceThe vehicle ahead stopped suddenly and there was almost no room left to stop.
FatigueDrowsy after a night shift and drifted out of lane.
Distraction / phoneLooked at a message on the phone and noticed the car ahead stopping too late.
Road / weatherDust or rain cut visibility, or a pothole or roadworks had no signs.
Other road userA car changed lanes without signalling in front of the vehicle.
Load / securingA pallet slid inside the box, or a strap came loose during the trip.
Vehicle defectWeak brakes or a damaged tire noticed before it caused an accident.
Reversing / manoeuvringReversing in the loading yard with no banksman while someone walked behind.
PedestrianA child or worker stepped out between parked vehicles.

How do you find the root cause with the 5 whys?

Ask "why?" about the event, then about the answer, and so on until you reach a cause a specific action can fix. Five is a rule of thumb; you may get there at the third why. An example from the brake report in the log:

  1. Why did the vehicle nearly collide at the gate? The brakes were weak.
  2. Why were they weak? The brake pads were worn.
  3. Why was the wear not found? The daily check does not cover brakes.
  4. Why does it not cover them? The checklist was written for light vehicles and never updated for trucks.

The root cause is an incomplete checklist, not a careless driver. The corrective action is to repair the vehicle and add brakes to the daily checklist, owned by the workshop manager.

How does the Excel log calculate status and the rate per 100,000 km?

Status = Closed if a closed date is entered = Awaiting review if no corrective action is written yet = Review overdue if no action is written and the review window has passed = Overdue if the as-of date is past the due date = In progress otherwise Days open = (closed date or as-of date) − report date Per 100,000 km = reports ÷ fleet km × 100,000

The as-of date is today unless you type a fixed date on the Lists sheet, where the review window is 7 days as an example to change to match your procedure. The yearly rate uses only months with km entered, so it does not drop because one month's km is still missing. A row shows a check message when an anonymous report has a name, when an action has no owner or due date, or when a report is closed with no corrective action.

Worked example: September in the example log

Three reports came in during September 2026: fatigue after a night shift, a child stepping out between two cars at a customer site, and a pallet sliding on a bend. The fleet drove 176,500 km that month (an example figure).

  • Rate: 3 ÷ 176,500 × 100,000 = 1.70 near misses per 100,000 km.
  • Fatigue report: the action "minimum rest between shifts" was due on 1 October and is not closed, so on 15 October its status is Overdue, with 43 days open.
  • Pedestrian report: no action written after 28 days, more than the 7-day window, so its status is Review overdue.
  • Load report: the action "extra straps and a short briefing" is due on 10 November, so its status is In progress.

Common near-miss reporting mistakes

  • Punishing the reporter. A single penalty after a report can be enough to stop reporting.
  • Setting a target to cut reports. More reports after launch usually means drivers have started reporting, not that the risk went up.
  • Stopping at "driver error". Ask why the driver made the error: a tight schedule, missing training, or a vehicle unsuited to the route.
  • No reply to the reporter. A driver who never hears what changed will not report again.
  • Actions with no owner or date. An action nobody owns does not get done, which is why the log flags it.
  • Mixing near misses with accidents. An event with damage or injury goes on the Vehicle Accident Report Form and in the Fleet Incident and Claims Log.

What the form does not tell you

The form depends on what drivers notice and choose to report, so it does not measure everything that happens on the road. Report counts are not comparable between two branches with different levels of trust. The rate per 100,000 km shows a trend inside your fleet, not a benchmark against other fleets. Actual accidents and injuries are reported under your incident procedure and your authority's requirements, so check its current requirement. This is a working template, not legal advice.

Related Safee solution

Match the driver's report with what the vehicle recorded

Safee Alarms and Alerts covers more than 50 alarm types. Fleet Monitoring & Insights keeps a timeline of trips, speed and alerts for each vehicle, with path replay, so you can review what the vehicle recorded at the time and place of a report.

  • 50+ alarm types in Alarms and Alerts.
  • Timeline of trips, speed and alerts for each vehicle.
  • Path replay to review the time and place of a report.
  • Export to Excel for monitoring data.
Questions

Questions about the near-miss report form

Want to see what the vehicle recorded for each report? Talk to Safee.

What is the difference between a near miss and an accident?

An accident causes damage or injury; a near miss almost did and did not. Accidents go on the accident report form and the incident log; near misses go on this form and its log.

Is a driver disciplined for reporting a near miss they were involved in?

Not for the report, and the form says so plainly. The aim is to find the cause and fix it. Deliberate violations are handled through the company policy in the usual way, not through the report.

Can drivers report anonymously?

Yes. The driver leaves name, mobile and signature blank and hands the form in where the company says, and the log records Yes in the Anonymous column.

Is a high number of reports a bad sign?

Not necessarily. Reports usually rise after launch because drivers start reporting. Watch the share of reports closed with an action, and the same category repeating at the same location.

How is near misses per 100,000 km calculated?

Reports in the month ÷ fleet km in the month × 100,000. Enter km in the monthly summary from odometers or your tracking report; the yearly rate uses only months with km entered.

Who reviews a report, and when?

Usually the safety supervisor or fleet manager, within a window your company sets. The log uses 7 days as an example; after that the status turns to Review overdue.

Does the template work in Google Docs and Google Sheets?

Yes. Upload the .docx and .xlsx files to Google Drive and open them there. They also work in Word, Excel and LibreOffice, with no macros.

Next step

See what the vehicle recorded for every near miss

Bring your near-miss log, and we will show you how Safee alerts and vehicle paths show what happened at the time and place of each report.

Related tools and templates

Log incidents, score drivers and cost accidents

Get the report

Enter your details and we will email you the file.

Use your real name so the file arrives addressed to you. Don't worry, we won't flood you with emails or calls.

Scroll to Top