{"dot_number":"541596","summary":{"total":39,"fatalities":1,"injuries":13},"crashes":[{"crash_id":"5087500","dot_number":"541596","report_state":"MI","report_date":"20260105","report_time":"0744","city":"GRAND RAPIDS","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X7LJ304561","vehicle_license":"RB86590","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:33"},{"crash_id":"5038481","dot_number":"541596","report_state":"MI","report_date":"20250922","report_time":"0930","city":"ANN ARBOR","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"5KJJBWD17SLVP7102","vehicle_license":"RB74641","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:49"},{"crash_id":"5064029","dot_number":"541596","report_state":"MI","report_date":"20250807","report_time":"1300","city":"Mulliken","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:30:59"},{"crash_id":"4772213","dot_number":"541596","report_state":"MI","report_date":"20240624","report_time":"1230","city":"Delhi Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"5KJJBWFG5SLUR8187","vehicle_license":"BD83494","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4763129","dot_number":"541596","report_state":"MI","report_date":"20240607","report_time":"0831","city":"Walker","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X7LJ304561","vehicle_license":"RB86590","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:40"},{"crash_id":"4655002","dot_number":"541596","report_state":"MI","report_date":"20231102","report_time":"1352","city":"WALKER","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"5KJJBWD15RPUR8157","vehicle_license":"RC27055","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:09"},{"crash_id":"4582602","dot_number":"541596","report_state":"MI","report_date":"20230626","report_time":"1030","city":"GRAND RAPIDS TWP","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0XXJJ196014","vehicle_license":"RB74646","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:40"},{"crash_id":"4498877","dot_number":"541596","report_state":"MI","report_date":"20230124","report_time":"0754","city":"CROCKERY TWP","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X4GJ132947","vehicle_license":"BC03430","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:53"},{"crash_id":"4419941","dot_number":"541596","report_state":"MI","report_date":"20220908","report_time":"1517","city":"Eagle Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X2GJ476986","vehicle_license":"RB74650","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:15"},{"crash_id":"4515524","dot_number":"541596","report_state":"MI","report_date":"20220303","report_time":"1524","city":"MUSKEGON TWP","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKZDP0XXKJ240918","vehicle_license":"RB60747","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:38"},{"crash_id":"4248878","dot_number":"541596","report_state":"MI","report_date":"20211027","report_time":"1350","city":"OLIVE TWP","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X6GJ132951","vehicle_license":"RB88725","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:46"},{"crash_id":"4229757","dot_number":"541596","report_state":"MI","report_date":"20210920","report_time":"1700","city":"WALKER","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X0GJ476985","vehicle_license":"RB74642","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:59"},{"crash_id":"4207670","dot_number":"541596","report_state":"MI","report_date":"20210803","report_time":"1434","city":"GRAND RAPIDS","state":"MI","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XKZDP0X8JJ196013","vehicle_license":"RB74643","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:00"},{"crash_id":"4080482","dot_number":"541596","report_state":"MI","report_date":"20201210","report_time":"1240","city":"FERRYSBURG","state":"MI","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XKZDP0X5HJ157423","vehicle_license":"RB74648","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:25"},{"crash_id":"4027764","dot_number":"541596","report_state":"MI","report_date":"20200825","report_time":"1135","city":"Scio Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X2GJ476986","vehicle_license":"RB74650","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:41"},{"crash_id":"4018372","dot_number":"541596","report_state":"MI","report_date":"20200815","report_time":"1008","city":"WYOMING","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDB0X87J193750","vehicle_license":"BC44480","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:41"},{"crash_id":"3877827","dot_number":"541596","report_state":"MI","report_date":"20191029","report_time":"1229","city":"Muskegon","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X4GJ132950","vehicle_license":"RB74651","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:11"},{"crash_id":"3860272","dot_number":"541596","report_state":"MI","report_date":"20191002","report_time":"1243","city":"Orangeville Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X4GJ132950","vehicle_license":"RB74651","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:22"},{"crash_id":"3840412","dot_number":"541596","report_state":"MI","report_date":"20190826","report_time":"1430","city":"Cascade Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X4GJ132947","vehicle_license":"BC03430","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:22"},{"crash_id":"3838582","dot_number":"541596","report_state":"MI","report_date":"20190812","report_time":"1030","city":"Boston Twp","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKZDP0X9LJ304559","vehicle_license":"BC03489","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:22"},{"crash_id":"3934979","dot_number":"541596","report_state":"MI","report_date":"20190723","report_time":"1424","city":"Muskegon","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1NKDGGGG00J421847","vehicle_license":"BC03431","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:34"},{"crash_id":"3792529","dot_number":"541596","report_state":"MI","report_date":"20190521","report_time":"0631","city":"Georgetown Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X8GJ132952","vehicle_license":"RB74652","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:34"},{"crash_id":"3680021","dot_number":"541596","report_state":"MI","report_date":"20181012","report_time":"0804","city":"Grandville","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0XXJJ196014","vehicle_license":"BB78770","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:33"},{"crash_id":"3416605","dot_number":"541596","report_state":"MI","report_date":"20170615","report_time":"1310","city":"White Oak Twp","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKZDP0X9GJ476984","vehicle_license":"BA69979","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:41"},{"crash_id":"3414859","dot_number":"541596","report_state":"MI","report_date":"20170602","report_time":"1245","city":"Grand Ledge","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDB0XX7J193751","vehicle_license":"BA42405","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:37:41"},{"crash_id":"3316854","dot_number":"541596","report_state":"MI","report_date":"20161115","report_time":"0820","city":"Plainfield Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDB0X87J193750","vehicle_license":"BA69984","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:01"},{"crash_id":"3266545","dot_number":"541596","report_state":"MI","report_date":"20160826","report_time":"0802","city":"Bowne Twp","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X8GJ132949","vehicle_license":"BA78151","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:12"},{"crash_id":"3257129","dot_number":"541596","report_state":"MI","report_date":"20160804","report_time":"1250","city":"Wyoming","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKZDP0X4GJ132947","vehicle_license":"BA69999","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:12"},{"crash_id":"2910468","dot_number":"541596","report_state":"MI","report_date":"20140827","report_time":"0837","city":"Grand Rapids","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDR9X2YJ857764","vehicle_license":"AC81292","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:33"},{"crash_id":"2896221","dot_number":"541596","report_state":"MI","report_date":"20140719","report_time":"0357","city":"Walker","state":"MI","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XKDDB0X14J071825","vehicle_license":"AA08142","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:42"},{"crash_id":"2892757","dot_number":"541596","report_state":"MI","report_date":"20140718","report_time":"1329","city":"Muskegon","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1NKDGGGG0EJ421847","vehicle_license":"BA10863","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:42"},{"crash_id":"2893716","dot_number":"541596","report_state":"MI","report_date":"20140716","report_time":"0825","city":"Grand Haven","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:42"},{"crash_id":"2770277","dot_number":"541596","report_state":"MI","report_date":"20131014","report_time":"0656","city":"Gaines Twp","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKDDB0X67J193746","vehicle_license":"AC81313","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:11"},{"crash_id":"1812442","dot_number":"541596","report_state":"MI","report_date":"20070607","report_time":"1718","city":"Walker","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKDDB0X56J159926","vehicle_license":"4629BE","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:17"},{"crash_id":"1572814","dot_number":"541596","report_state":"MI","report_date":"20051201","report_time":"1405","city":"Walker","state":"MI","fatalities":1,"injuries":0,"tow_away":0,"vin":"1XKDDB0X05J116089","vehicle_license":"2261AX","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:09"},{"crash_id":"254804","dot_number":"541596","report_state":"MI","report_date":"20000909","report_time":"0825","city":"CALEDONIA TWP","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"0932AF","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"726819","dot_number":"541596","report_state":"MI","report_date":"19980729","report_time":"1245","city":"GRAND RAPIDS","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"ZU8103","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:28"},{"crash_id":"728185","dot_number":"541596","report_state":"MI","report_date":"19980306","report_time":"0935","city":"GRANDVILLE","state":"MI","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"ZU8102","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:39"},{"crash_id":"724196","dot_number":"541596","report_state":"MI","report_date":"19970818","report_time":"1300","city":"THORNAPPLE TWP","state":"MI","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"ZU8100","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"YELLOW ROSE TRANSPORT","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:53"}]}