Skip to main content

SMS Databases

The aviation law enforcement community, and members of our aviation industry in general, continue to talk about Safety Management Systems and their implementation. A number of aviation organizations now have Safety Management System SMS in place, but they vary considerably in terms of employee acceptance, effectiveness, and ease of use. This is due in part to the fact that guidance is still forthcoming, and also because each organization’s SMS is typically developed from within, based on existing safety climate/culture and accident prevention programs that have evolved over time. Sadly, many organizations that have “implemented” SMS find themselves with little more than just another manual sitting on the shelf.

Most people are in agreement that SMS is a “data-driven approach to safety”. In essence, this means we collect and analyze data, identify hazards and latent conditions, assess risk, and implement risk controls in order to prevent accidents. Some organizations are collecting data from inexpensive employee reporting programs and system/task analyses. Others are investing relatively large sums of money in Flight Data Monitoring (FDM) systems to collect data on flight profiles and deviations from standard operating procedures.  And while employee reporting and FDM can both contribute to overall safety efforts as part of a comprehensive SMS, the data must still be processed into meaningful risk controls and corrective actions.

computer_mouse copySMS uses a quality management approach to managing safety. It requires, among other things, the monitoring of daily activities, identification of hazards through system/task analysis, management of change, training, auditing, a method for employees to report hazards, errors, and events, and procedures for managing risk and following up to ensure that implemented risk controls remain effective. Clearly, this is no easy task and requires more than an SMS Manual and some paper forms to do the job right. 


So what do we do with our data? How do we address the many latent conditions that we know exist within our organizations in a manner that is both proactive and predictive, as SMS doctrine teaches us? And how can we make the whole safety risk management process efficient and effective? Fortunately, modern technology provides us with the SMS database. The ubiquitous Excel® spreadsheet is but one example of a tool that is great for recording and organizing data, but falls short of addressing many safety risk management process elements. 


When planning and developing an SMS database, or if selecting a customized or off-the-shelf commercial program, consider first whether it is compatible with your existing office tools (such as Excel). Consider also whether your database will be hosted by a third party, or reside on your company-owned servers, either in-house or co-located. Costs of hardware, space, and IT resources must also be considered, in addition to the software itself. In any case, much of your safety risk data will be sensitive and confidential. Physical security, access devices, firewalls, intrusion protection/detection, secure transmission, backup, and storage should all be planned for.

Regarding employee reporting, will your reporting system be paper or web-based? If web-based, how will employees connect? Effective reporting should be accessible and easy. Will you offer anonymous reporting options? And how will data from employee reports be entered into the database? 


Then consider the following database attributes: 

  • Levels of authority should be established for database administration, password assignment and access.

  • Will the database provide for user-defined values and data entry choices that will permit use of the database for management of other issues, such as quality management, security, occupational health, and environmental protection?

  • How will interfaces between managers be handled regarding investigation, risk acceptance, and corrective actions?

  • Will your database provide for the assignment of responsibilities for investigation, risk acceptance, corrective actions, and communication of lessons learned?

  • Your SMS database should also contain controls to ensure the integrity of data and the proper completion of all assigned risk management responsibilities, including follow-up audits.

SMS Safety Management System is all about continuous improvement. And because SMS uses a quality management approach, there’s no reason why your database shouldn’t work to improve quality throughout your organization. In addition to managing incidents, accidents, near-accidents and identified hazards, your database should be able to help you track and manage a variety of other user-defined issues, such as scheduling problems, reliability of equipment, errors and quality escapes in maintenance, communications difficulties, security breeches, EPA violations, quality or supply problems with vendors, OSHA reportable injuries, and other processes for which improvement is desired.


corrective actions bar cropped sharp

An effective SMS database should also support trend analysis. Trend reports allow managers to target specific types of events, equipment, mission types, etc., over time, and look for contributing factors that may be a recurring theme. By accurately determining the root causes of these associated events, risk controls and corrective actions can be implemented that make effective use of our limited safety management resources.

We’ve come a long way with cell phones, computers, and the internet to help us communicate and manage information, and the complexity of SMS processes demands that we use these tools to our advantage. An effective SMS database should go beyond the collecting and sharing of data to address the many elements of safety risk management and to improve the quality of other processes throughout our organizations. 

Paul Salerno is President of Omni Air Group, a leading developer of Safety Management Systems for industry. For more information, visit OAG online at www.omniairgroup.com

CONTACT US

COMPANY NAME : Omni Air Group

PHONE NUMBER : 760.239.7895

ADDRESS : 5505 S Dorset Rd. Spokane, Washington 99224, USA

EMAIL : info@omnisms.aero

Comments

Popular posts from this blog

Emergency Response Plan in Aviation: The First Ten Minutes That Decide Everything!

Why do the first ten minutes matter more than anything else? The first ten minutes after an aviation emergency shape every outcome that follows. This is where your emergency response plan either works or fails. Decisions move fast. Stress runs high. There is no time to search for answers. You rely on preparation. When the plan is clear, people act with confidence. When it is weak, confusion spreads instantly. What Really Happens in Those First Ten Minutes In real operations, emergencies never arrive neatly packaged. You face alarms, radio calls, unclear data, and human fear at once. These moments test leadership, training, and structure. A strong emergency response plan turns chaos into order. It gives you a script when thinking feels hard and time feels short. How a Well Designed Plan Guides Human Decisions Under pressure, the brain looks for patterns. A good plan provides those patterns. You know who leads, who communicates, and who records. Tasks stay simple. Priorities stay clear...

Error-Capturing Strategies and System Design

Building error tolerance, error mitigation, and error-capturing strategies into our systems should be one of the most important outputs of safety management, especially when guided by a robust FAA safety management system and supported by formal safety risk assessment processes. These strategies are a hallmark of good system design. And when system design flaws are discovered, risk controls are implemented. Monitoring of the affected process then helps us see if our strategies are effective. If not, our previously-implemented controls must be corrected to keep a hazard in check. Way back in the 80’s I was serving as DO for Salair Air Cargo, operating a fleet of 10 old DC-3s and 30 young pilots. We landed 4 new contracts for Emery Worldwide, and suddenly saw a rash of events in which our DC-3 crews were failing to remove the gear pins before flight. Why did this trend appear after thousands of hours of operation? What changed in our operating environment? Back then we didn’t invest...