Excel Spreadsheet

Copy of SafeMTS Key__11-14-2023__for OMB.xlsx

Near-Miss Reporting and Analysis Program for the Maritime Transportation System

Excel Spreadsheet

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

Metadata
2 - Core Data Fields
3 - Values
4 - Values Key and Definitions
Location-Vessel Dependency Key


Sheet 1: Metadata

General Information
File Created By Amanda Lemons
Current File Owner/Managed by MARAD/BTS SafeMTS Team
File Last Updated By Amanda Lemons
Date File was last updated 11/14/2023
File Description This file is used as the key for the SafeMTS Pilot data fields and values.



Tab Number Name Information
1 MetaData & Directions for Use This tab
2 Core Data Fields Contains the current list of agreed upon, identified critical data fields.
3 Values Contains the current values associated for the critical data fields on tab 2.
4 Values Key and Definitions Contains the list of definitions, notes, and spelled out acronyms for the fields and values.
5 Location-Vessel Dependency Key Contains the dependency structure between the two fields "Location on Vessel" and "Location on Vessel - Detail"

Sheet 2: 2 - Core Data Fields

Field Title Data Field Type Core Data Field? Definition of Field/Guidance Notes Additional Notes
SafeMTS Event ID ID Code Yes
Determined after data ingestion, SafeMTS assigned
Company Name Categorical N/A

Company Event ID* ID Code Yes
Not required, but helpful to capture if provided
Event Date Date Yes

Time of Event Time No
Reporters only need to include if relevant to the incident
Event Description Free Text Yes

Incident Type/Category Categorical Yes

Near Miss Classification Categorical Yes Reporters should select only the primary or most applicable. Single Select
Geographic Location Categorical Yes

Vessel Name (1) Free Text Yes
Company could alternatively provide a Vessel ID if they do not want to provide a name
Vessel Name (2) Free Text Yes
Company could alternatively provide a Vessel ID if they do not want to provide a name
Vessel Type (1) Categorical Yes
Could be automated if the compnay provides a key based on Vessel Name
Vessel Type (2) Categorical Yes
Could be automated if the compnay provides a key based on Vessel Name
Business Segment Categorical No

Location on Vessel Categorical Yes

Location on Vessel - Detail Categorical Yes
Dependency from "Location on Vessel"
Operations/Activity Ongoing Categorical Yes
Single Select
System/Equipment Involved Categorical Yes
Single Select
Observing Personnel Type Categorical Yes
Single Select
Factor Preventing Worse Incident Categorical Yes
Multi-select
Action Taken - Narrative Narrative No

Immediate Corrective Action Categorical Yes
Multi-select
Systemic Corrective Action Categorical Yes
Multi-select
Potential Consequence Categorical Yes
Multi-select
Actual Consequence Categorical Yes
Multi-select
Potential Severity Level Categorical No
ASTM categories
Causal/Contributing Factors Categorical Yes
Multi-select
Root Cause Categorical Yes


Sheet 3: 3 - Values

Incident Type/Category Near Miss Classification Vessel Name (1) Vessel Name (2) Vessel Type (1) Vessel Type (2) Business Segment Geographic Location Location on Vessel Location on Vessel - Detail Operations/Activity Ongoing System/Equipment Involved Observing Personnel Type Factor Preventing Worse Incident Action Taken - Narrative Immediate Corrective Action Systemic Corrective Action Potential Consequence Actual Consequence Potential Severity Level Causal/Contributing Factors Root Cause
Near Miss (Unsafe Act) Caught In, Under, Between

ATB ATB Blue Water Anchorage Accommodations Spaces & Storage Accommodations/State Room Access/Egress Accommodation/Habitability Crew Alarm
Clean-up Develop & install proper labeling Activation Of Fire Suppression System Activation Of Fire Suppression System Catastrophic Act of Violence Act of Violence
Hazard Recognition (Unsafe Condition) Collision/Allision

Barge Barge Brown Water Dock/In Port/Shore Ashore/Not on Vessel Control Room Administrative Anchoring Machinery Contractor (Supernumerary) COI inspection finding
Coworker Assistance Different solution found Client Cargo Damage/Contamination Client Cargo Damage/Contamination Severe Carelessness Carelessness
Undesired Event (Negative Business Impact) Contamination

Barge - CB Barge - CB Container Drifting/Not Under Command Cargo/Void Spaces Doorway Anchored Aids to Navigation (ATON) Passenger Communicated Issue
Different Solution Found Discontinue equipment use or operation Collision/Allision Collision/Allision Moderate Complacency/Laziness Complacency/Laziness
Other Damage - Cargo

Barge - LASH Barge - LASH Dry Cargo Lock Deck Spaces & Storage Head Assisting Auxiliary Engine Shore Personnel Coworker Intervention
Emergency Procedure Equipment Properly Labeled Contact With Suspended Object Contact With Suspended Object Minor Distraction Distraction
Not Applicable Damage - Equipment

Break Bulk/General Cargo Break Bulk/General Cargo Harbor Services Offshore Engine/Machinery Spaces & Storage Laundry ATB Assist/Escort Ballast Shipyard Worker Drills on Hazard
Equipment Inspected Equipment/System repaired/replaced/modified Container overboard Container overboard
Equipment/ Material Failure Equipment/ Material Failure
Not Reported Damage - Structural

Con/RO Con/RO International Shipyard Galley & Storage Lazarette Audit Bilge Other Equipment Design
Equipment/System Shutdown (LOTO) Improve Equipment maintenance/inspection program Contamination Contamination
Failure to Follow Procedure Failure to Follow Procedure

Disruption of Ops

Container Ship Container Ship Jones Act Underway at Sea Navigation Bridge/Wheelhouse Lounge Backloading Equipment Boiler (Main or Auxiliary) Not Applicable Inspection/Testing
Hazard Communicated Improve organization communication Damage - Cargo Damage - Cargo
Fatigue Fatigue

DP Undesired Event

Dry Bulk Cargo Dry Bulk Cargo Ocean Carrier Underway in Restricted Waters Other Mess Hall Ballasting/De-Ballasting Bow/Stern Thruster Not Reported Job Safety Analysis (JSA)
Made Aware of Proper Procedure Made Aware of Proper Procedure Damage - Equipment Damage - Equipment
Incorrect Procedure Incorrect Procedure

Dropped Object

Heavy Lift Heavy Lift Passenger Underway under Pilotage Not Applicable Passageway Bunkering/Fueling Cargo being carried
Knowledge, Skills, Ability (KSA)
Made Aware of Required PPE Made Aware of Required PPE Damage - Structural Damage - Structural
Insufficient Training Insufficient Training

Electrocution

Large passenger Large passenger Tanker Vessel Alongside Not Reported Stairs/Ladder Cargo Operations Cargo Gear
Luck
Obstacle/Hazard Removed Modify/Develop Procedure (JSA) Dropped Object Dropped Object
Lack of Awareness Lack of Awareness

Equipment Failure

MODU MODU Other Other
Storage Space Carrying Supplies Cargo Piping, Hoses & Valves
Personal Protective Equipment (PPE)
Operation Stopped New PPE provided Economic/Reputational Damage Economic/Reputational Damage
Lack of Preventive Maintenance Lack of Preventive Maintenance

Fire/Explosion

Offshore Supply Offshore Supply Not Applicable Not Applicable
Ashore/Not on Vessel Change Battery Cargo Pump
Preventative Maintenance Program
Procedures Followed Obstacle/Hazard Removed Electrical Hazard/Fire Electrical Hazard/Fire
Lift/Push/Pull Exertion Lift/Push/Pull Exertion

Flooding

Offshore Supply/Anchor Handler Offshore Supply/Anchor Handler Not Reported Not Reported
On Dock Cleaning Cargo Tank/Hold
Procedures
Safety Equipment Installed Order spare parts/technical assistance required Environmental Hazard (not spills) Environmental Hazard (not spills)
Localized Vibration Localized Vibration

Grounding

Passenger - Cruise Ship Passenger - Cruise Ship


Overboard Confined Space Operations Cleaning Fluids/Materials
Quality Control
Safety Stand Down Review Procedures/Provide Training Equipment Failure Equipment Failure
Motion of Vessel Motion of Vessel

Hazardous Atmosphere

Passenger - Ferries Passenger - Ferries


Ballast tank Crane Operations Clothes Washer/Dryer
Risk Mitigation Measure(s) that prevented further consequence escalation (swiss cheese model)
Secured Lose Gear/Equipment Safety Equipment Installed Extra Work/Time/Cost/Delay Extra Work/Time/Cost/Delay
Overexertion, Overload, Ergonomic Factors Overexertion, Overload, Ergonomic Factors

Illness/Injury

Pilot Boat Pilot Boat


Cargo Tank/Hold Deck Machinery Maintenance Comminuter-Food Grinder
Rounds
Shift Ballast Safety Meeting Fall Fall
Poor Planning Poor Planning

Lifeboat/Rescue Boat Release

Research Research


Control Room Deck Maintenance Communication Equipment
Safety Meeting
Other Other Fall Into Open Hole Fall Into Open Hole
Poor/bad Design Poor/bad Design

Line Handling

RO/RO RO/RO


Duct Keel Deck Operations Compressed Air
Securing Loose Objects
Not Applicable Not Applicable Fall Overboard Fall Overboard
Poor/Insuffucient Communications Poor/Insuffucient Communications

Loss of Anchor

School Ship School Ship


Exterior Cargo Area Deicing Cranes/Davits/Lifting apparatus
Shutting down/securing equipment
Not Reported Not Reported Falling Object Falling Object
Rushing Task Rushing Task

Loss of Tow

Small passenger Small passenger


Fuel Tank Diving Operations Deck Gear
Stop Work Authority


Fatigue Fatigue
Weather Weather

LOTO (Lockout/Tagout)

Survey Survey


Hold Docking/Undocking Deck Plating
Other


Fire Fire
Unknown Unknown

Missing Guards

Tanker - Chemical Tanker - Chemical


Void Space DP Operations Diving Equipment
Not Applicable


Grounding Grounding
Other Other

Missing or Damaged PPE

Tanker - LNG/LPG Tanker - LNG/LPG


Aloft Drills/Training Dock Equipment
Not Reported


Hatch Damage Hatch Damage
Not Applicable Not Applicable

Other Lifesaving Equipment Malfunction

Tanker - Oil Tanker - Oil


ATB Notch Drydock/Shipyard Operations Documentation




Hull Damage Hull Damage
Not Reported Not Reported

Pollution/Spill

Towing vessel/Ocean-going tug Towing vessel/Ocean-going tug


Ballast Water treatment house Electrical Maintenance Door/Hatch




Injury - Other Injury - Other



Power Loss

Tug & Barge (Connected) Tug & Barge (Connected)


Battery Locker Embarking/Disembarking Electrical devices/appliances




Injury - Medical Treatment Case Injury - Amputation



Sensor Failure

Tug Boat (Harbor/Inland) Tug Boat (Harbor/Inland)


Bow/Focsle Deck Engine Room Maintenance Electrical Distribution




Injury - Amputation Injury - Asphyxia/Choking



Slip/Trip/Fall (No Injury)

Other Other


Bunker Station Escort Of Navy Vessel Electrical Generators




Injury - Asphyxia/Choking Injury - Burn



Smoke/Smolder

Not Applicable Not Applicable


Catwalk Filling Potable Water Tanks Fire Fighting




Injury - Burn Injury - Chemical/Radiation Exposure



Struck By

Not Reported Not Reported


Control Room Galley Operations Forklift




Injury - Chemical/Radiation Exposure Injury - Crushing



Other






Damage Control Locker Garbage Management Freezer/Chill Box/Storeroom




Injury - Crushing Injury - Cumulative Trauma



Not Applicable






Deck General Vessel Operations Fresh Water Generator




Injury - Cumulative Trauma Injury - Disease



Not Reported






Doorway Helicopter Operations Fuel Purification




Injury - Disease Injury - Eye/Vision Impairment











Forepeak Helideck Inspection Fuel Service




Injury - Drowning Injury - First Aid











Gangway Hose Transfer Fuel Tank




Injury - Eye/Vision Impairment Injury - Hearing











Hull Hot Work Galley Equipment




Injury - Fatality Injury - Heat Exhaustion











Lifeboat/Rescue Boat Idle/standing by Gangway




Injury - First Aid Injury - Hypothermia











Manifold Cargo Bunker In Port Garbage




Injury - Hearing Injury - Inhaled/Absorbed/Ingested











Mooring Dolphin Inspection GMDSS




Injury - Heart Attack/Condition Injury - Scrapes/Bruises/Cut/Puncture











Mooring Station Internal Fuel Transfer Hatch




Injury - Heat Exhaustion Injury - Sprain/Strain











Muster Station Laundry Heat Exchanger




Injury - Hypothermia Injury - Struck By











Outboards/Over the side Lifeboat/Rescue Boat Activities Helm




Injury - Inhaled/Absorbed/Ingested Injury - Unconscious











Paint Locker Liferaft Activities Hold




Injury - Scrapes/Bruises/Cut/Puncture Loss of GPS Signals











Passageway Line Tending Hospital




Injury - Sprain/Strain Loss of Tow











Pilot Ladder Loading Deck Cargo Hull And Structure




Injury - Struck By Port State Detention











Ramp/RoRo Loading Potable Water HVAC




Injury - Unconscious Power Instability/Power Loss











Ship Crane Loading Stores/Supplies Hydraulic System




Loss of GPS Signals Prop Fouling











Stairs/Ladder Lock Operations Incinerator




Loss of Tow Property Damage











Stern Lube Oil Transfer Inert Gas




Port State Detention Propulsion loss











Storage Space Maintenance Intercon Coupler




Power Instability/Power Loss Shock Hazard/Electrical











Towing Winch Make/Break Tow Ladder/Stairs




Prop Fouling Spill (Minor/Loss of Containment)











Tunnel Military Operations Landing Chair




Property Damage Steering Loss











Walkway Navigating Lifeboat/Rescue Boat




Propulsion Loss Unsafe Conditions











Workshop Off Watch Lighting/Electrical Fixture




Shock Hazard/Electrical Vessel Instability











AMS (auxillary machinery space) Over The Side Lube Oil




Spill (Major/Loss of Containment) Water Intrusion











Battery Locker Painting/Chemical Use Lube Oil Purification




Steering Loss Other











Bow/Stern Thruster Room Personal Care Main Propulsion




Unsafe Conditions None











Bunker Station Personnel Transfer Main Reduction Gear




Vessel Instability Not Applicable











Co2 Room Pilot Transfer Mast/Rigging




Water Intrusion Not Reported











Control Room Power Tool Use Mooring Equipment




Other












Doorway Pre-Departure Checks Navigation




Not Applicable












Doorway Receiving Risers From The Rig Navigation Lights




Not Reported












Electric Shop Rigging/Stowing Gangway Oily Water Separater (OWS)


















Emergency Generator Room Rigging/Stowing Pilot Ladder Other Lifesaving Equipment


















Engine Space Rounds Other Vessel


















Foam Room ROV Operations Personal Protective Equipment (PPE)


















Inert Gas Room Running lines (power, gas, communications) Pilot Ladder


















Machine Shop Safety System Inspection Potable/Distilled Water


















Pump Room Ship/Barge Assist Power Tools/Tools


















Purifier Room Shore Power Operations Propeller & Shafting


















Stairs/Ladder Slops Transfer Railing


















Storage Space Stores Operations Ramp


















Tunnel Subsea Operations Reefer Container


















Workshop Tank Vessel Escort Refrigeration


















Galley Tank/Hold Cleaning Research Equipment


















Stairs/Ladder Testing Safety Equipment ROV


















Storage Space Towing Sea Water Cooling


















Battery Locker Underway/In Transit Sewage


















Bridge/Wheelhouse Walking Slop Tank


















Doorway Waste Handling Sludge


















Intercon Room Working Aloft/At Heights Steam


















Storage Space Other Steering


















Other Not Applicable Stern Ramp


















Not Applicable Not Reported Stowage System (Software)


















Not Reported
Stripping And Transfer




















Test equipment




















Thermal Oil




















Towing Equipment




















Vapor Recovery




















Vender/Customer equipment




















Ventilation




















Void Space




















Welding/Hot work Equipment




















Other




















Not Applicable




















Not Reported










Sheet 4: 4 - Values Key and Definitions

Term Field Containing Term Value Containing Term Acronym Spelled Out Description/Definition Clarification/Note

Definitions to consider from other organizations:
ATB Vessel Type
Articulated Tug & Barge; Articulated Tug Boat
Should report as a single unit (rather than as a tug and a barge)

1. IMO MSC-MEPC.7/Circ.7: Near-miss: A sequence of events and/or conditions that could have resulted in loss.  This loss was prevented only by a fortuitous break in the chain of events and/or conditions.  The potential loss could be human injury, environmental damage, or negative business impact (e.g., repair or replacement costs, scheduling delays, contract violations, loss of reputation). Note: Other than fatalities, injuries to personnel are not included in IMO definitions of Serious and Less Serious Marine Casualties.
ATON System/Equipment Involved
Aids to Navigation



2. Near Mishap / Near Miss (US Department of Defense) – An undesired event that, under slightly different circumstances, would have resulted in personnel harm, property damage, or an undesired loss of resources. In other words – “An unplanned, unintended, unwanted, and unexpected, but controllable event which disrupts the work process and has the potential to cause material loss or damage, death, injury or occupational illness but was avoided merely by chance”.
Burn


Contact with Hazardous Substance/Dose (Toxic/Corrosive/ Carcinogenic/ Biological/Viral)



Catastrophic Severity

Could result in one or more of the following: death, permanent total disability, irreversible significant environmental impact, or monetary loss equal to or exceeding $1M.



CON/RO Vessel Type
Combination Container/RO RO vessel




Docking/Undocking


Also includes Shifting, Warping, Mooring



DP Near Miss Classification DP Undesired Event Dynamic Positioning




Economic/Reputational Damage


Customer/Stakeholder Complaints



HR Near Miss Classification
Hazard Recognition (Unsafe Condition)




Injury - First Aid


Injury - Scrapes/Bruises/Cut/Puncture



Injury - Inhaled/Absorbed/Ingested


Include insect bites/stings Contact with Hazardous Substance/Dose (Toxic/Corrosive/ Carcinogenic/ Biological/Viral)


Injury - Medical Treatment Case


Injury - Severe Scrapes/Bruises/Cut/Puncture Injury - Sprain/Strain


Injury - Scrapes/Bruises/Cut/Puncture


Other skin irritations such as abrasion, irritation, etc.



JSA Factor Preventing further/worse incident
Job Safety Analysis




LOTO Immediate Corrective Action
Lock out/tag out




LSA/FFE We split this up -2 entries FFE & LSA
Life Saving Appliance/Firefighting Equipment




Minor Severity

Could result in one or more of the following: injury or occupational illness not resulting in a lost work day, minimal environmental impact, or monetary loss less than $10K.



Moderate Severity

Could result in one or more of the following: injury or occupational illness resulting in one or more lost work day(s), reversible moderate environmental impact, or monetary loss equal to or exceeding $10K but less than $100K.



Near Miss Classification


Is this the most likely to have occurred?



NM Near Miss Classification
Near Miss (Unsafe Act)




Offshore Supply







Offshore Supply/Anchor Handler







OWS System/Equipment Involved
Oily Water Seperator




PI Potential Consequence
Power Insatbility/Power Loss




Pollution/Spill


Al environmental impacts



PPE System/Equipment Involved
Personal Protective Equipment




RO/RO Vessel Type
Roll On/Roll Off




ROV System/Equipment Involved
Remote Operated Vehicle




Severe Severity

Could result in one or more of the following: permanent partial disability, injuries or occupational illness that may result in hospitalization of at least three personnel, reversible significant environmental impact, or monetary loss equal to or exceeding $500K but less than $1M.



Shutting down/securing equipment


Auto or manual



Undesired Event (Negative Business Impact)








Sheet 5: Location-Vessel Dependency Key

Location on Vessel Key Location on Vessel - Detail
Accommodation Spaces & Storage Accommodations/State Room
Accommodation Spaces & Storage Control Room
Accommodation Spaces & Storage Doorway
Accommodation Spaces & Storage Head
Accommodation Spaces & Storage Laundry
Accommodation Spaces & Storage Lazarette
Accommodation Spaces & Storage Lounge
Accommodation Spaces & Storage Mess Hall
Accommodation Spaces & Storage Passageway
Accommodation Spaces & Storage Stairs/Ladder
Accommodation Spaces & Storage Storage Space
Ashore/Not on Vessel Ashore/Not on Vessel
Ashore/Not on Vessel On Dock
Ashore/Not on Vessel Overboard
Cargo/Void Spaces Ballast tank
Cargo/Void Spaces Cargo Tank/Hold
Cargo/Void Spaces Control Room
Cargo/Void Spaces Duct Keel
Cargo/Void Spaces Exterior Cargo Area
Cargo/Void Spaces Fuel Tank
Cargo/Void Spaces Hold
Cargo/Void Spaces Void Space
Deck Spaces & Storage Aloft
Deck Spaces & Storage ATB Notch
Deck Spaces & Storage Ballast Water treatment house
Deck Spaces & Storage Battery Locker
Deck Spaces & Storage Bow/Focsle Deck
Deck Spaces & Storage Bunker Station
Deck Spaces & Storage Catwalk
Deck Spaces & Storage Control Room
Deck Spaces & Storage Damage Control Locker
Deck Spaces & Storage Deck
Deck Spaces & Storage Doorway
Deck Spaces & Storage Forepeak
Deck Spaces & Storage Gangway
Deck Spaces & Storage Hull
Deck Spaces & Storage Lifeboat/Rescue Boat
Deck Spaces & Storage Manifold Cargo Bunker
Deck Spaces & Storage Mooring Dolphin
Deck Spaces & Storage Mooring Station
Deck Spaces & Storage Muster Station
Deck Spaces & Storage Outboards/Over the side
Deck Spaces & Storage Paint Locker
Deck Spaces & Storage Passageway
Deck Spaces & Storage Pilot Ladder
Deck Spaces & Storage Ramp/RoRo
Deck Spaces & Storage Ship Crane
Deck Spaces & Storage Stairs/Ladder
Deck Spaces & Storage Stern
Deck Spaces & Storage Storage Space
Deck Spaces & Storage Towing Winch
Deck Spaces & Storage Tunnel
Deck Spaces & Storage Walkway
Deck Spaces & Storage Workshop
Engine/Machinery Spaces & Storage AMS (auxillary machinery space)
Engine/Machinery Spaces & Storage Battery Locker
Engine/Machinery Spaces & Storage Bow/Stern Thruster Room
Engine/Machinery Spaces & Storage Bunker Station
Engine/Machinery Spaces & Storage Co2 Room
Engine/Machinery Spaces & Storage Control Room
Engine/Machinery Spaces & Storage Doorway
Engine/Machinery Spaces & Storage Doorway
Engine/Machinery Spaces & Storage Electric Shop
Engine/Machinery Spaces & Storage Emergency Generator Room
Engine/Machinery Spaces & Storage Engine Space
Engine/Machinery Spaces & Storage Foam Room
Engine/Machinery Spaces & Storage Inert Gas Room
Engine/Machinery Spaces & Storage Machine Shop
Engine/Machinery Spaces & Storage Pump Room
Engine/Machinery Spaces & Storage Purifier Room
Engine/Machinery Spaces & Storage Stairs/Ladder
Engine/Machinery Spaces & Storage Storage Space
Engine/Machinery Spaces & Storage Tunnel
Engine/Machinery Spaces & Storage Workshop
Galley & Storage Galley
Galley & Storage Stairs/Ladder
Galley & Storage Storage Space
Navigation, Bridge/Wheelhouse Battery Locker
Navigation, Bridge/Wheelhouse Bridge/Wheelhouse
Navigation, Bridge/Wheelhouse Doorway
Navigation, Bridge/Wheelhouse Intercon Room
Navigation, Bridge/Wheelhouse Storage Space
Other Other
Not Applicable Not Applicable
Not Reported Not Reported
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2025 OMB.report | Privacy Policy