{"dot_number":"109542","summary":{"total":24,"fatalities":2,"injuries":22},"crashes":[{"crash_id":"4808727","dot_number":"109542","report_state":"TX","report_date":"20240904","report_time":"1522","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"4V4NC9EG6EN164391","vehicle_license":"1M26396","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:31:35"},{"crash_id":"4566703","dot_number":"109542","report_state":"TX","report_date":"20230510","report_time":"1628","city":"TYLER","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1HSWGAZR66J209900","vehicle_license":"RSM0985","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:40"},{"crash_id":"4387322","dot_number":"109542","report_state":"TX","report_date":"20220705","report_time":"1709","city":"NOT LISTED","state":"TX","fatalities":2,"injuries":4,"tow_away":0,"vin":"1FVACWDC97DY95949","vehicle_license":"GKX2422","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:16"},{"crash_id":"3954514","dot_number":"109542","report_state":"TX","report_date":"20200330","report_time":"0717","city":"TYLER","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"2NKHHN7X9CM325442","vehicle_license":"1L44472","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:52"},{"crash_id":"3716085","dot_number":"109542","report_state":"TX","report_date":"20181206","report_time":"0910","city":"RURAL FREESTONE COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"3ALACWDT8EDFK7163","vehicle_license":"LFF5055","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:24"},{"crash_id":"3719766","dot_number":"109542","report_state":"TX","report_date":"20181205","report_time":"0910","city":"RURAL FREESTONE COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"3ALACWDT8EDFK7163","vehicle_license":"LFF5055","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:36:24"},{"crash_id":"2556980","dot_number":"109542","report_state":"TX","report_date":"20120320","report_time":"0640","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1HSCAAHN21J002108","vehicle_license":"1A89242","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:17"},{"crash_id":"2276941","dot_number":"109542","report_state":"TX","report_date":"20100531","report_time":"0640","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"4V4NC9TG46N443858","vehicle_license":"2SM207","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:17"},{"crash_id":"2101768","dot_number":"109542","report_state":"TX","report_date":"20090209","report_time":"1324","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1HSHBAHN5XH619280","vehicle_license":"2DY368","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2002914","dot_number":"109542","report_state":"TX","report_date":"20080401","report_time":"0500","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"2HSFHAER5WC052149","vehicle_license":"2DY369","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:42"},{"crash_id":"1522668","dot_number":"109542","report_state":"TX","report_date":"20050728","report_time":"1110","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1HSHCAHR3TH264159","vehicle_license":"ZAY842","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC (AVIS FOOD SERVICE)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:29"},{"crash_id":"1360629","dot_number":"109542","report_state":"TX","report_date":"20040818","report_time":"0830","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"JALB4B1KXW7003267","vehicle_license":"3MKW13","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC (AVIS FOOD SERVICE)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1248506","dot_number":"109542","report_state":"TX","report_date":"20040209","report_time":"1255","city":"","state":"TX","fatalities":0,"injuries":3,"tow_away":0,"vin":"1HSHANSN5MH366413","vehicle_license":"2BB499","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC (AVIS FOOD SERVICE)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:50"},{"crash_id":"1043865","dot_number":"109542","report_state":"TX","report_date":"20010823","report_time":"0647","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"AA185BHA12067","vehicle_license":"7160XV","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:19"},{"crash_id":"294667","dot_number":"109542","report_state":"TX","report_date":"20000707","report_time":"0500","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"2HSFBGSR2HC089834","vehicle_license":"2AU457","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:36"},{"crash_id":"268179","dot_number":"109542","report_state":"TX","report_date":"20000515","report_time":"1000","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUWYBYB6HH305061","vehicle_license":"2AU459","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:36"},{"crash_id":"154407","dot_number":"109542","report_state":"TX","report_date":"19990702","report_time":"1700","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"","vehicle_license":"7160XV","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:01"},{"crash_id":"134702","dot_number":"109542","report_state":"TX","report_date":"19970902","report_time":"1300","city":"TYLER","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"2DB086","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:53"},{"crash_id":"120107","dot_number":"109542","report_state":"TX","report_date":"19960815","report_time":"0900","city":"TYLER","state":"TX","fatalities":0,"injuries":3,"tow_away":0,"vin":"1HTDA1950BHB35010","vehicle_license":"2AX002","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:21"},{"crash_id":"116692","dot_number":"109542","report_state":"TX","report_date":"19960523","report_time":"0900","city":"TYLER","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1GRL7H1J0MJ108038","vehicle_license":"7787YF","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:35"},{"crash_id":"111762","dot_number":"109542","report_state":"TX","report_date":"19951215","report_time":"1000","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUWYBYA2HH292283","vehicle_license":"2DH593","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:54"},{"crash_id":"90433","dot_number":"109542","report_state":"TX","report_date":"19940930","report_time":"1700","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUWYBYA2HH292283","vehicle_license":"2CU376","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:23"},{"crash_id":"87687","dot_number":"109542","report_state":"TX","report_date":"19940728","report_time":"1100","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"T19C1AV563042","vehicle_license":"2BM710","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:23"},{"crash_id":"85997","dot_number":"109542","report_state":"TX","report_date":"19940713","report_time":"1600","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"2B7JB31Z7KK385216","vehicle_license":"FG1113","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"TYLER BEVERAGES INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:52:23"}]}