{"dot_number":"974012","summary":{"total":18,"fatalities":0,"injuries":21},"crashes":[{"crash_id":"4574045","dot_number":"974012","report_state":"TX","report_date":"20230605","report_time":"1838","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X81D550402","vehicle_license":"R513779","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:32:40"},{"crash_id":"4356012","dot_number":"974012","report_state":"TX","report_date":"20220510","report_time":"1700","city":"BEAUMONT","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"YPB174321FUPCSZB3","vehicle_license":"R454788","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:33:23"},{"crash_id":"4070895","dot_number":"974012","report_state":"TX","report_date":"20201120","report_time":"1848","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPCSZBXYPF62833","vehicle_license":"R416235","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:34:25"},{"crash_id":"3894023","dot_number":"974012","report_state":"TX","report_date":"20191017","report_time":"1547","city":"NOT LISTED","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPCSZBXYPF62833","vehicle_license":"R416235","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:35:22"},{"crash_id":"3102145","dot_number":"974012","report_state":"LA","report_date":"20150908","report_time":"1912","city":"2805","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUPCSZBXYPF62833","vehicle_license":"R1445448","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:38:57"},{"crash_id":"3012440","dot_number":"974012","report_state":"TX","report_date":"20150224","report_time":"1958","city":"RURAL MONTGOMERY COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDSEB9RP565678","vehicle_license":"R138277","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:21"},{"crash_id":"2855595","dot_number":"974012","report_state":"TX","report_date":"20140408","report_time":"0103","city":"RURAL LEE COUNTY","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJAPAV75DU99005","vehicle_license":"R017050","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:54"},{"crash_id":"2819615","dot_number":"974012","report_state":"TX","report_date":"20140127","report_time":"1404","city":"TEMPLE","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XKWDB9X4YR837047","vehicle_license":"RR8Z72","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:39:55"},{"crash_id":"2752842","dot_number":"974012","report_state":"LA","report_date":"20130911","report_time":"0938","city":"2006","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUPUSZB91LG05391","vehicle_license":"RP5J74","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:12"},{"crash_id":"2735720","dot_number":"974012","report_state":"TX","report_date":"20130712","report_time":"0100","city":"RURAL LEE COUNTY","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1FUJAPCG31PH05866","vehicle_license":"RM4S90","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:24"},{"crash_id":"2701794","dot_number":"974012","report_state":"TX","report_date":"20130429","report_time":"0630","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJAPCK05DU88558","vehicle_license":"RP5K09","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:24"},{"crash_id":"2608999","dot_number":"974012","report_state":"TX","report_date":"20120928","report_time":"1220","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X83D800269","vehicle_license":"RL6N57","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2328182","dot_number":"974012","report_state":"TX","report_date":"20101006","report_time":"1530","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUPCSEB41LG75471","vehicle_license":"R61470","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:56"},{"crash_id":"2309234","dot_number":"974012","report_state":"MO","report_date":"20100922","report_time":"1100","city":"NON-CITY OR UNINCORPORATE","state":"MO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X81D550402","vehicle_license":"R61996","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:17"},{"crash_id":"2188795","dot_number":"974012","report_state":"WY","report_date":"20091028","report_time":"1115","city":"CHEYENNE","state":"WY","fatalities":0,"injuries":10,"tow_away":0,"vin":"1XP5DB9X83D800269","vehicle_license":"R61992","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING COMPANY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"1870234","dot_number":"974012","report_state":"LA","report_date":"20071001","report_time":"1020","city":"","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYDZYB4XP975872","vehicle_license":"R9TY67","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1760020","dot_number":"974012","report_state":"TX","report_date":"20070203","report_time":"0055","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUPCSEBOTH827927","vehicle_license":"R4HP86","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:27"},{"crash_id":"1853693","dot_number":"974012","report_state":"TX","report_date":"20061113","report_time":"1000","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYDZYB2VH855396","vehicle_license":"R6K074","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ALAN SCHNEIDER TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:37"}]}