{"dot_number":"499559","summary":{"total":24,"fatalities":0,"injuries":21},"crashes":[{"crash_id":"2199843","dot_number":"499559","report_state":"TX","report_date":"20091016","report_time":"1230","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB8X3SN378633","vehicle_license":"2EV926","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"2046419","dot_number":"499559","report_state":"MN","report_date":"20081117","report_time":"0808","city":"ALBERT LEA","state":"MN","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X64D826368","vehicle_license":"R33556","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:20"},{"crash_id":"2029959","dot_number":"499559","report_state":"TX","report_date":"20080902","report_time":"1258","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FTSW31P83EC04220","vehicle_license":"9HWZ11","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:33"},{"crash_id":"1740930","dot_number":"499559","report_state":"TX","report_date":"20061208","report_time":"1410","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X8XD516857","vehicle_license":"R7GK27","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:37"},{"crash_id":"1189945","dot_number":"499559","report_state":"TX","report_date":"20030821","report_time":"1925","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5CB9X2XD483045","vehicle_license":"R4XK40","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:06"},{"crash_id":"1173192","dot_number":"499559","report_state":"TX","report_date":"20030630","report_time":"1615","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XP5DB9X6D483047","vehicle_license":"R4XK44","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:06"},{"crash_id":"1254233","dot_number":"499559","report_state":"AR","report_date":"20030603","report_time":"2012","city":"HOPE","state":"AR","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X4YD516855","vehicle_license":"RA4XK41","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:17"},{"crash_id":"1023694","dot_number":"499559","report_state":"TX","report_date":"20010501","report_time":"0825","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB8X1VD435440","vehicle_license":"1XR799","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"257948","dot_number":"499559","report_state":"MS","report_date":"20010321","report_time":"1251","city":"RIDGELAND","state":"MS","fatalities":0,"injuries":1,"tow_away":0,"vin":"UNKNOWN","vehicle_license":"IKW330","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"281579","dot_number":"499559","report_state":"TX","report_date":"20010112","report_time":"0500","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X01D55917","vehicle_license":"1VG235","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:55"},{"crash_id":"1140019","dot_number":"499559","report_state":"GA","report_date":"20000620","report_time":"1150","city":"","state":"GA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X9YDS16852","vehicle_license":"1SP121","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:36"},{"crash_id":"159471","dot_number":"499559","report_state":"TX","report_date":"19991221","report_time":"0700","city":"SAN ANTONIO","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"1NY932","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:48"},{"crash_id":"152275","dot_number":"499559","report_state":"TX","report_date":"19990420","report_time":"2200","city":"LUFKIN","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"R21124","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"148076","dot_number":"499559","report_state":"TX","report_date":"19981119","report_time":"0600","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"R21440","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:28"},{"crash_id":"144933","dot_number":"499559","report_state":"TX","report_date":"19980804","report_time":"0700","city":"HOUSTON","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"","vehicle_license":"1JC209","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:28"},{"crash_id":"772878","dot_number":"499559","report_state":"MO","report_date":"19980622","report_time":"0540","city":"NON-CITY OR U","state":"MO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DD9XX5D361414","vehicle_license":"1FX962","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:38"},{"crash_id":"141883","dot_number":"499559","report_state":"TX","report_date":"19980410","report_time":"1500","city":"DIBOLL","state":"TX","fatalities":0,"injuries":4,"tow_away":0,"vin":"","vehicle_license":"1MS110","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:38"},{"crash_id":"140833","dot_number":"499559","report_state":"TX","report_date":"19980302","report_time":"0600","city":"DALLAS","state":"TX","fatalities":0,"injuries":4,"tow_away":0,"vin":"","vehicle_license":"2BC331","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:39"},{"crash_id":"140727","dot_number":"499559","report_state":"TX","report_date":"19980225","report_time":"2100","city":"LEWISVILLE","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"R10469","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:39"},{"crash_id":"140523","dot_number":"499559","report_state":"TX","report_date":"19980217","report_time":"0700","city":"AUSTIN","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"1KB062","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:39"},{"crash_id":"127537","dot_number":"499559","report_state":"TX","report_date":"19970224","report_time":"0800","city":"GRAND PRAIRIE","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"2WKPDCJG4FK912770","vehicle_license":"2CR080","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC (H P POULAND INC)(POUL","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:05"},{"crash_id":"115837","dot_number":"499559","report_state":"TX","report_date":"19960425","report_time":"1300","city":"WYLIE","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X9RD346087","vehicle_license":"1EL290","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC (H P POULAND INC)(POUL","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:35"},{"crash_id":"115137","dot_number":"499559","report_state":"TX","report_date":"19960401","report_time":"1500","city":"","state":"TX","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XP5DB9X2PD325272","vehicle_license":"2AA836","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC (H P POULAND INC)(POUL","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:35"},{"crash_id":"114629","dot_number":"499559","report_state":"TX","report_date":"19960314","report_time":"0800","city":"LUFKIN","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB8X2SD383716","vehicle_license":"1GA334","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"JOHN & SANDRA INC (H P POULAND INC)(POUL","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:51:35"}]}