{"dot_number":"249574","summary":{"total":396,"fatalities":19,"injuries":270},"crashes":[{"crash_id":"2782026","dot_number":"249574","report_state":"TX","report_date":"20131022","report_time":"1230","city":"RURAL HARRIS COUNTY","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X97D652529","vehicle_license":"2EU679","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:11"},{"crash_id":"2638576","dot_number":"249574","report_state":"LA","report_date":"20121212","report_time":"1410","city":"6100","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X17D652525","vehicle_license":"2BV810","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:46"},{"crash_id":"2734523","dot_number":"249574","report_state":"OH","report_date":"20121202","report_time":"0745","city":"UNION","state":"OH","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X47D652549","vehicle_license":"2JV522","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:46"},{"crash_id":"2623062","dot_number":"249574","report_state":"TX","report_date":"20121023","report_time":"1439","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X96D642419","vehicle_license":"2HF744","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:46"},{"crash_id":"2631933","dot_number":"249574","report_state":"TX","report_date":"20121016","report_time":"1620","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X45D877972","vehicle_license":"2GB933","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2607133","dot_number":"249574","report_state":"TX","report_date":"20120915","report_time":"0620","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPHD49X6AD109814","vehicle_license":"2NQ517","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2609679","dot_number":"249574","report_state":"TX","report_date":"20120912","report_time":"0930","city":"","state":"TX","fatalities":0,"injuries":5,"tow_away":0,"vin":"1XPHD49X0BD129476","vehicle_license":"2QK111","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2602135","dot_number":"249574","report_state":"MS","report_date":"20120912","report_time":"1523","city":"SOUTHAVEN","state":"MS","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"2MH 825","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2593511","dot_number":"249574","report_state":"TX","report_date":"20120823","report_time":"1141","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPHD49X7CD160449","vehicle_license":"2RA813","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:47"},{"crash_id":"2587462","dot_number":"249574","report_state":"TX","report_date":"20120724","report_time":"1430","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X36D642433","vehicle_license":"2HL833","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:55"},{"crash_id":"2595541","dot_number":"249574","report_state":"TX","report_date":"20120710","report_time":"1205","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9XX5D877975","vehicle_license":"2LP941","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:55"},{"crash_id":"2544747","dot_number":"249574","report_state":"LA","report_date":"20120417","report_time":"1400","city":"5200","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X17D652525","vehicle_license":"2BV810","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:56"},{"crash_id":"2555052","dot_number":"249574","report_state":"TX","report_date":"20120404","report_time":"0313","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X76D642418","vehicle_license":"2HF745","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:40:56"},{"crash_id":"2437769","dot_number":"249574","report_state":"TX","report_date":"20110705","report_time":"1440","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X07D652550","vehicle_license":"2JV663","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:33"},{"crash_id":"2455641","dot_number":"249574","report_state":"TX","report_date":"20110704","report_time":"0539","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X87D652554","vehicle_license":"2JV667","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:33"},{"crash_id":"2546789","dot_number":"249574","report_state":"TX","report_date":"20110622","report_time":"0705","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X36D642433","vehicle_license":"2HL833","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:42"},{"crash_id":"2427113","dot_number":"249574","report_state":"LA","report_date":"20110619","report_time":"1549","city":"3208","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X16D642415","vehicle_license":"2HF743","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:42"},{"crash_id":"2424885","dot_number":"249574","report_state":"TX","report_date":"20110526","report_time":"1224","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X25D845064","vehicle_license":"R54498","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:42"},{"crash_id":"2412781","dot_number":"249574","report_state":"TX","report_date":"20110416","report_time":"0240","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJA6AS73PK83697","vehicle_license":"2BW970","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:43"},{"crash_id":"2390234","dot_number":"249574","report_state":"CO","report_date":"20110213","report_time":"1319","city":"","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X86D642413","vehicle_license":"2HF735","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:43"},{"crash_id":"2347698","dot_number":"249574","report_state":"TX","report_date":"20101207","report_time":"2150","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9XX5D859198","vehicle_license":"2AE673","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:55"},{"crash_id":"2334782","dot_number":"249574","report_state":"TX","report_date":"20101108","report_time":"1240","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XPGDU9X26D642424","vehicle_license":"2HF751","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:56"},{"crash_id":"2297200","dot_number":"249574","report_state":"LA","report_date":"20100803","report_time":"2024","city":"5002","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUJA6DE55LN50402","vehicle_license":"2BQ149","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:17"},{"crash_id":"2327525","dot_number":"249574","report_state":"TX","report_date":"20100506","report_time":"0710","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X87D652540","vehicle_license":"2FY707","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:17"},{"crash_id":"2251083","dot_number":"249574","report_state":"MS","report_date":"20100421","report_time":"1438","city":"SOUTHAVEN","state":"MS","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X26D642410","vehicle_license":"2MR153","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:43"},{"crash_id":"2300842","dot_number":"249574","report_state":"TX","report_date":"20100402","report_time":"0005","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X25D877985","vehicle_license":"2GB953","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:43"},{"crash_id":"2215972","dot_number":"249574","report_state":"VA","report_date":"20091223","report_time":"1515","city":"","state":"VA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKWDB9X65A085055","vehicle_license":"P178982","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:43"},{"crash_id":"2228246","dot_number":"249574","report_state":"TX","report_date":"20091214","report_time":"2005","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X47D652535","vehicle_license":"2FX168","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:55"},{"crash_id":"2197262","dot_number":"249574","report_state":"TX","report_date":"20090924","report_time":"1145","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUPCSZB7WL923887","vehicle_license":"2JA997","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"2156220","dot_number":"249574","report_state":"TX","report_date":"20090804","report_time":"1454","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X16D642429","vehicle_license":"2HL829","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"2160076","dot_number":"249574","report_state":"TX","report_date":"20090713","report_time":"0600","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X76D642449","vehicle_license":"2HL781","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2104407","dot_number":"249574","report_state":"LA","report_date":"20090317","report_time":"1325","city":"803","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X26D642424","vehicle_license":"2HF751","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2210182","dot_number":"249574","report_state":"LA","report_date":"20090313","report_time":"2139","city":"1702","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"2HSCNASRX4CD86875","vehicle_license":"RD1G92","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2092608","dot_number":"249574","report_state":"LA","report_date":"20090216","report_time":"0337","city":"2700","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPCSZB9YPB87243","vehicle_license":"P188034","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2088866","dot_number":"249574","report_state":"TX","report_date":"20090115","report_time":"1620","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X97D652546","vehicle_license":"2JV519","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:19"},{"crash_id":"2080877","dot_number":"249574","report_state":"WV","report_date":"20090105","report_time":"0611","city":"HUNTINGTON","state":"WV","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X77D652531","vehicle_license":"2EU724","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:43:19"},{"crash_id":"2065895","dot_number":"249574","report_state":"TX","report_date":"20081125","report_time":"0740","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1FUJA6AS24DM41558","vehicle_license":"2HL981","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:20"},{"crash_id":"2063838","dot_number":"249574","report_state":"TX","report_date":"20081106","report_time":"1901","city":"","state":"TX","fatalities":1,"injuries":0,"tow_away":0,"vin":"1XPGDU9X76D642449","vehicle_license":"2HL781","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:20"},{"crash_id":"2024986","dot_number":"249574","report_state":"TX","report_date":"20080826","report_time":"0700","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X55D877964","vehicle_license":"2GB940","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:33"},{"crash_id":"2021365","dot_number":"249574","report_state":"TX","report_date":"20080817","report_time":"0510","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGU9X45D877972","vehicle_license":"2GB933","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:33"},{"crash_id":"2015515","dot_number":"249574","report_state":"TX","report_date":"20080804","report_time":"0700","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X55D877964","vehicle_license":"2GB940","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:33"},{"crash_id":"2031956","dot_number":"249574","report_state":"TX","report_date":"20080801","report_time":"1103","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DU9X92D865713","vehicle_license":"2GB663","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:33"},{"crash_id":"2008042","dot_number":"249574","report_state":"TX","report_date":"20080704","report_time":"1250","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X15D877976","vehicle_license":"2GB942","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:34"},{"crash_id":"1989760","dot_number":"249574","report_state":"TX","report_date":"20080509","report_time":"0014","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X57D652527","vehicle_license":"2EL784","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:42"},{"crash_id":"1973907","dot_number":"249574","report_state":"CO","report_date":"20080501","report_time":"1030","city":"","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"2HSFHAMR6WC061945","vehicle_license":"2DE641","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:42"},{"crash_id":"1949649","dot_number":"249574","report_state":"LA","report_date":"20080225","report_time":"0010","city":"2900","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYSDYB5XPA89331","vehicle_license":"R6DV92","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:43"},{"crash_id":"2179760","dot_number":"249574","report_state":"TX","report_date":"20080220","report_time":"0220","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X56D642448","vehicle_license":"2HL831","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT LP","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:43"},{"crash_id":"1924979","dot_number":"249574","report_state":"TX","report_date":"20080121","report_time":"1748","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9X15D859204","vehicle_license":"2FB330","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1962986","dot_number":"249574","report_state":"TX","report_date":"20080113","report_time":"0900","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XPGDU9XX5D859203","vehicle_license":"2FB329","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"},{"crash_id":"1890638","dot_number":"249574","report_state":"LA","report_date":"20071108","report_time":"0757","city":"","state":"LA","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPGDU9X86D642444","vehicle_license":"2HL910","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"ANDREWS TRANSPORT L P","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:08"}]}