RIDE Score™ benchmarks operator performance against a unified baseline constructed from 10 independent data sources spanning 40+ years of U.S. amusement safety data — regulatory records, hospital surveillance, product recalls, consumer complaints, service bulletins, occupational injuries, and annual industry surveys.
Each source is classified by data freshness, automation method, and which RIDE Score pillars it feeds. Together they form the most comprehensive amusement safety dataset ever assembled for operator benchmarking.
All sources converge through a crosswalk/harmonization layer in Airtable, then feed into the Power BI AS 360 model as benchmark reference tables alongside live operator data from the GSA checklists, queue feeds, and weather APIs.
Every data source maps to one or more RIDE Score pillars. This matrix shows what each source contributes to the composite benchmark, and the specific fields that flow into each pillar's calculation.
| Source | R — Readiness | I — Integrity | D — Delivery | E — Environment |
|---|---|---|---|---|
| CPSC NEISS | — | — | National injury estimates by product code; severity (hospitalization rate) | Seasonal distribution; age/sex demographics |
| Saferparks 2017 | Operator-reported descriptions; staffing context in narratives | mechanical flag; manufacturer failure rates |
num_injured; category (cause); device_category incident rates |
acc_date seasonality; acc_state regulatory context |
| Saferparks Legacy | Long-run trend in operator-caused incidents | Historical mechanical rate by OEM; 20-year device reliability curves | Historical incident baselines by bus_type |
Multi-decade seasonality validation |
| SP NEISS Extract | — | — | ER-treated injury patterns by device type | Injury distribution by month, age cohort |
| CARES Bulletins | — | Open bulletin count per OEM/device; restraint modifications; compliance status | — | — |
| IAAPA / NSC | — | — | 1-in-15.5M injury rate benchmark; injuries per million attendance | Year-over-year trend; regional participation rates |
| OSHA IMIS / SIR | Employee fatality/injury rate at amusement SIC codes; investigation abstracts | — | — | — |
| CoasterForce / Media | — | Recent malfunction reports (2018–present) | Recent incident counts by ride type (global) | — |
| CPSC Recalls API | — | Active recall status per manufacturer/ride model; hazard descriptions; recall scope (unit count) | — | — |
| SaferProducts.gov | — | Consumer-reported manufacturer defects; product-specific complaints | Sub-ER-threshold incidents; patron complaints; near-miss reports | — |
The SP_Crosswalk table in Airtable normalizes Saferparks' inconsistent field values to the AS 360 standard taxonomy, enabling DAX joins across all benchmark tables.
New DAX measure block for the AS 360 Power BI model. These measures reference the SP_Benchmark tables connected via Airtable Web API connector and joined through the SP_Crosswalk dimension.
Phased implementation from static ingest through automated refresh. Priority ordered by data value and automation feasibility.
SP_Benchmark base.SP_Crosswalk table mapping Saferparks values to AS 360 taxonomy. Fuzzy match manufacturers. NLP-classify cause categories.SP_Benchmark to AS 360 Power BI model via Airtable Web API connector. Build Section 28 DAX measures. Wire to Calendar table.SP_CARES_Bulletins.SP_OSHA_SIR table. Set quarterly refresh.SP_CPSC_Recalls with manufacturer, hazard, recall date, unit count. Cross-reference against operator fleet manufacturers.SP_SaferProducts. Filter noise, extract manufacturer names and incident descriptions.
Saferparks explicitly notes this data "cannot be ethically used to compare or contrast the safety of different rides, parks, carnivals, or states" due to non-uniform reporting criteria across jurisdictions and time periods. CPSC NEISS data covers mobile (carnival) rides under CPSC jurisdiction but fixed-site parks are excluded from CPSC's regulatory authority. The IAAPA/NSC report is the only source covering fixed-site parks specifically.
AS 360 positions all benchmark data as directional industry context, not definitive safety rankings — the same approach credit scoring uses. RIDE Score measures an operator's relative position within an imperfect but comprehensive distribution, not their absolute safety record.