Empowering database engineers to quickly publish car safety data

Redesigning workflows for the National Highway Traffic Safety Administration and introducing a centralized portal to improve efficiency and transparency in car safety data publication.

Company
National Highway Traffic Safety Administration
Scope
4 Months
Role
UX Designer and Researcher
Team
Me, project manager, 4 engineers
Skills
"Screenshot of the National Highway Traffic Safety Administration (NHTSA) web and mobile application interface showing test submissions. The web view on the tablet highlights various statuses: Submitted, Under Review, Approved, and Published, each with test details such as IDs, vehicle models, occupants, task completion, and user icons. The mobile view displays the same interface scaled down for smartphones

Problem

The National Highway Traffic Safety Administration (NHTSA) faced inefficiencies in translating crash test data from labs into publicly accessible safety ratings. The process was fragmented, relying on outdated software and email communication, causing multi-month delays. With multiple stakeholders—program analysts, crash test engineers, and database engineers—no single source of truth existed to manage this complex workflow.

Outcome

I designed a centralized portal that allowed NHTSA and crash test labs to collaboratively manage the end-to-end workflow for crash test data publication.


  1. Reduce crash test processing time by an estimated 10-30%, significantly shortening the delay in publishing safety ratings.
  2. Increase transparency and accountability for all stakeholders.
  3. Enhanced user efficiency by reducing data submission time for crash test engineers by an estimated 15%.

Identifying gaps in the data publishing process

During research I used interviews and process mapping to identify gaps in the current workflow:

  • Lack of Transparency: No one had a full picture of the steps required to process and publish crash test data.
  • Communication Silos: Email chains buried critical updates, causing delays. There was no way to process and communicate about crash test data in the same system.
  • Outdated Tools: Engineers manually uploaded crash test data using outdated software, which was time-consuming and error-prone.

Mapping the current workflow provided a reference point and communication aid between the stakeholders, users, and myself. Seeing the process visually allowed us to communicate more effectively and collectively identify the most important issues in the process.

A highlighted section titled 'Key stages in crash test data publishing process,' displayed in a green-bordered box. The process is shown as a series of four gray rectangles connected by arrows, each representing a stage: 'Negotiation,' 'Pre-Test Setup,' 'Test Lab Submission,' and 'NHTSA Review and Publishing.' The background contains a blurred and detailed flowchart, emphasizing the outlined stages in the foreground.

The Solution

I designed a centralized portal that allowed NHTSA and crash test labs to collaboratively manage the end-to-end workflow for crash test data publication.

Key features:

  1. Status tracker dashboard

    Displays the current phase of each test, required next steps, and associated files and users. Provides an overview of all tests, with drill-down functionality for detailed views.

  2. All test items contained in one place

    All details about each test including testing organization, people involved, attachments, communication and tasks are grouped with each test.
  3. Integrated communication
    all correspondence directly to the relevant test to eliminate email reliance.
Two smartphones displaying the NHTSA application interface, with callouts highlighting specific features. The app shows categorized test cases like 'Submitted' and 'Under Review,' with details such as test IDs, vehicle references (e.g., Toyota Camry 2022), task progress, file attachments, and comments. Callout numbers mark key sections: '1' emphasizes the 'Submitted' category header, '2' highlights a specific test case card labeled 'High' priority, and '3' points to the comment icon with a count of six. The NHTSA logo is prominently displayed in blue at the top of the screens.
A desktop interface of the NHTSA application displaying categorized test cases under tabs like 'Submitted,' 'Under Review,' 'Approved,' and 'Published.' The 'Submitted' section is highlighted with three callouts: callout 1 'Submitted' tab label, callout 2 highlights a specific test card labeled 'Test 6234' with details such as a high-priority indicator, vehicle reference (Toyota Camry 2022), 4 occupants, and progress (3/10 completed tasks), while callout 3 marks the comment icon showing two comments. The interface also displays user avatars, attachment counts, and task progress across different test cards. A left-side menu includes options for Tests, Labs, Reports, and Trash.

I also designed an interface for automated data uploads to simplify and accelerates data submission, reducing the manual workload for engineers by an estimated 15%.

Iterating and testing

Throughout the project I:

  • Shared iterative updates with users to gather feedback and refine features.
  • Prioritized seamless communication and transparency on the stage in the process the crash test was at based on user input.
  • Held weekly engineering Q&A sessions to overcome the challenges of working with a team unfamiliar with user experience
A laptop on a table showing a user interface for the NHTSA portal. The screen displays various sections like 'Submitted,' 'Under Review,' and 'Approved,' with cards listing test details, reference numbers, and user avatars. A hand with a ring rests on the laptop’s keyboard. The background shows a window with natural light and greenery outside

Final Thoughts

This work demonstrates the power of clearly defining and communicating the problem in order to create effective solutions. Because of my work to align stakeholders, users and my team we were able to transform an outdated and inefficient process into a streamlined, modernized workflow. By design portal to act as a single source of truth, integrating communication, and automating data uploading, the product addressed critical pain points for all stakeholders and users.

Although I recruited to another team before the portal's launch, the design was poised to make a significant impact on how NHTSA manages and publishes crash test data. This work not only set a new standard for efficiency and collaboration but also underscored the role of UX in driving meaningful operational change—ultimately supporting safer, more informed car purchasing decisions for the public.

Interested in working together? Get in touch today.

I'm interested in working with socially responsible companies that are focused on improving human health. If this sounds like you please reach out.