{"dot_number":"287764","summary":{"total":5,"fatalities":0,"injuries":1},"crashes":[{"crash_id":"4896416","dot_number":"287764","report_state":"MI","report_date":"20250206","report_time":"1730","city":"DETROIT","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X87D682794","vehicle_license":"RB70126","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"STERLING OIL AND CHEMICAL CO INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:21"},{"crash_id":"4672300","dot_number":"287764","report_state":"MI","report_date":"20231206","report_time":"1152","city":"DETROIT","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X87D682794","vehicle_license":"RB70126","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"STERLING OIL AND CHEMICAL CO INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"3355637","dot_number":"287764","report_state":"MI","report_date":"20170203","report_time":"0709","city":"Romulus","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPXD40X1CD138522","vehicle_license":"RB05090","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"STERLING OIL AND CHEMICAL CO INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:54"},{"crash_id":"2691691","dot_number":"287764","report_state":"MI","report_date":"20130226","report_time":"1749","city":"Ann Arbor","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPFDB9X71N535484","vehicle_license":"RA09519","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"STERLING OIL AND CHEMICAL CO INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:36"},{"crash_id":"2017301","dot_number":"287764","report_state":"MI","report_date":"20080902","report_time":"1805","city":"LENOX TWP","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"RA09518","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"STERLING OIL AND CHEMICAL CO INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:33"}]}