{"dot_number":"252668","summary":{"total":74,"fatalities":5,"injuries":43},"crashes":[{"crash_id":"2378078","dot_number":"252668","report_state":"OK","report_date":"20101209","report_time":"0800","city":"","state":"OK","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUEYSYB7H298848","vehicle_license":"4595 GIZ","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:55"},{"crash_id":"2378079","dot_number":"252668","report_state":"OK","report_date":"20101209","report_time":"0800","city":"","state":"OK","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPSDB9XOXD475008","vehicle_license":"2LD 454","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:41:55"},{"crash_id":"2168301","dot_number":"252668","report_state":"KS","report_date":"20090919","report_time":"1505","city":"","state":"KS","fatalities":0,"injuries":2,"tow_away":0,"vin":"4V4NC9TJ37N428989","vehicle_license":"77503","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"2164026","dot_number":"252668","report_state":"CO","report_date":"20090903","report_time":"1300","city":"","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP7DB9X81D551154","vehicle_license":"106677","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:42:56"},{"crash_id":"2157406","dot_number":"252668","report_state":"CA","report_date":"20090706","report_time":"1509","city":"COMMERCE","state":"CA","fatalities":1,"injuries":0,"tow_away":0,"vin":"1XPXD49X38D737433","vehicle_license":"96777","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"2132427","dot_number":"252668","report_state":"WY","report_date":"20090326","report_time":"1302","city":"RAWLINS","state":"WY","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X1YD517106","vehicle_license":"72743","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:09"},{"crash_id":"1953520","dot_number":"252668","report_state":"MO","report_date":"20080317","report_time":"1645","city":"NON-CITY OR UNINCORPORATE","state":"MO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X2WD449380","vehicle_license":"72757","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:43:42"},{"crash_id":"1926349","dot_number":"252668","report_state":"TN","report_date":"20070910","report_time":"2052","city":"","state":"TN","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X7YD474889","vehicle_license":"0072739","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:17"},{"crash_id":"1860155","dot_number":"252668","report_state":"KS","report_date":"20070811","report_time":"2240","city":"OAKLEY","state":"KS","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XKTD69X5WJ788706","vehicle_license":"72761","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:17"},{"crash_id":"1849568","dot_number":"252668","report_state":"TX","report_date":"20070810","report_time":"1430","city":"","state":"TX","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X9YD522313","vehicle_license":"72752","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:17"},{"crash_id":"1721816","dot_number":"252668","report_state":"CO","report_date":"20061107","report_time":"1545","city":"","state":"CO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X3YD517124","vehicle_license":"72768","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:37"},{"crash_id":"1731150","dot_number":"252668","report_state":"KS","report_date":"20061026","report_time":"1815","city":"","state":"KS","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X41N526088","vehicle_license":"72751","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:44:38"},{"crash_id":"1569847","dot_number":"252668","report_state":"CO","report_date":"20051227","report_time":"0530","city":"","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X2YD474881","vehicle_license":"72763","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:09"},{"crash_id":"1569842","dot_number":"252668","report_state":"CO","report_date":"20051227","report_time":"0530","city":"","state":"CO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X2YD474881","vehicle_license":"72763","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:09"},{"crash_id":"1549288","dot_number":"252668","report_state":"LA","report_date":"20051101","report_time":"0230","city":"","state":"LA","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X5YD517108","vehicle_license":"0072745","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:09"},{"crash_id":"1466947","dot_number":"252668","report_state":"KS","report_date":"20050410","report_time":"0330","city":"","state":"KS","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9XXYD517119","vehicle_license":"72749","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:45:47"},{"crash_id":"1416778","dot_number":"252668","report_state":"MO","report_date":"20050111","report_time":"0510","city":"NON-CITY OR UNINCORPORATE","state":"MO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X3YD474887","vehicle_license":"PWR-15248","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:08"},{"crash_id":"1398422","dot_number":"252668","report_state":"WI","report_date":"20040907","report_time":"0907","city":"PLOVER","state":"WI","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYSSZB2XPA40621","vehicle_license":"50380","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:17"},{"crash_id":"1350963","dot_number":"252668","report_state":"TN","report_date":"20040702","report_time":"0315","city":"","state":"TN","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":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:40"},{"crash_id":"1269042","dot_number":"252668","report_state":"UT","report_date":"20040414","report_time":"0455","city":"Beaver","state":"UT","fatalities":0,"injuries":1,"tow_away":0,"vin":"1PT01ANH0W9010792","vehicle_license":"400987","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:41"},{"crash_id":"1264547","dot_number":"252668","report_state":"CO","report_date":"20040327","report_time":"1845","city":"","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X34D474887","vehicle_license":"15248","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:41"},{"crash_id":"1235469","dot_number":"252668","report_state":"TX","report_date":"20040115","report_time":"2250","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X3YD484612","vehicle_license":"25175","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC (EARL PILE)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:46:51"},{"crash_id":"1092750","dot_number":"252668","report_state":"TX","report_date":"20030322","report_time":"1055","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X3WN452153","vehicle_license":"1205","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC (EARL PILE)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:18"},{"crash_id":"1095532","dot_number":"252668","report_state":"TX","report_date":"20030309","report_time":"0235","city":"","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"2FUPCSZB7VA721944","vehicle_license":"PWR1257","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC (EARL PILE)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:18"},{"crash_id":"1080164","dot_number":"252668","report_state":"AZ","report_date":"20030110","report_time":"2010","city":"","state":"AZ","fatalities":0,"injuries":1,"tow_away":0,"vin":"2XP5DB9X2YD517101","vehicle_license":"38108","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:32"},{"crash_id":"1145531","dot_number":"252668","report_state":"FL","report_date":"20021007","report_time":"1730","city":"LEE","state":"FL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUPCXY130WP92467","vehicle_license":"1247","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:33"},{"crash_id":"1031579","dot_number":"252668","report_state":"CO","report_date":"20020912","report_time":"0735","city":"","state":"CO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X2YD474881","vehicle_license":"15052","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:46"},{"crash_id":"1009943","dot_number":"252668","report_state":"KS","report_date":"20020724","report_time":"0903","city":"GRANDVIEW","state":"KS","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X5XD466742","vehicle_license":"PUR/14866","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:47"},{"crash_id":"1010557","dot_number":"252668","report_state":"NE","report_date":"20020625","report_time":"1045","city":"OMAHA","state":"NE","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"1209","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:47:48"},{"crash_id":"343885","dot_number":"252668","report_state":"KS","report_date":"20020328","report_time":"1245","city":"","state":"KS","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP6DB9X2VD610054","vehicle_license":"1231","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:03"},{"crash_id":"344429","dot_number":"252668","report_state":"CO","report_date":"20020215","report_time":"1225","city":"DENVER","state":"CO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X1TN418899","vehicle_license":"PWR1219","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:03"},{"crash_id":"368766","dot_number":"252668","report_state":"MO","report_date":"20020206","report_time":"0705","city":"NON-CITY OR UNINCORPORATE","state":"MO","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9X51N522325","vehicle_license":"37987","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:03"},{"crash_id":"305662","dot_number":"252668","report_state":"IL","report_date":"20020117","report_time":"0830","city":"CHICAGO","state":"IL","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XPSDB9X2YD474881","vehicle_license":"15052","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"N","source":"mcmis","ingested_at":"2026-05-16 00:48:03"},{"crash_id":"295546","dot_number":"252668","report_state":"CO","report_date":"20010907","report_time":"2350","city":"","state":"CO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X5XD466742","vehicle_license":"14866","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:19"},{"crash_id":"431495","dot_number":"252668","report_state":"AZ","report_date":"20010325","report_time":"0402","city":"","state":"AZ","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5D69X47N402607","vehicle_license":"29700","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:41"},{"crash_id":"637456","dot_number":"252668","report_state":"KS","report_date":"20001128","report_time":"0410","city":"","state":"KS","fatalities":0,"injuries":0,"tow_away":0,"vin":"1FUYDSEB7TP682490","vehicle_license":"1236","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"275957","dot_number":"252668","report_state":"CO","report_date":"20001117","report_time":"1915","city":"","state":"CO","fatalities":1,"injuries":0,"tow_away":0,"vin":"1XP5DB8X3VD431129","vehicle_license":"PWR1234","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"637294","dot_number":"252668","report_state":"KS","report_date":"20001101","report_time":"1505","city":"","state":"KS","fatalities":0,"injuries":0,"tow_away":0,"vin":"1XP5DB9XXYD517105","vehicle_license":"25662","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"477782","dot_number":"252668","report_state":"CA","report_date":"20000925","report_time":"1540","city":"PLACER","state":"CA","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":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"493998","dot_number":"252668","report_state":"CO","report_date":"20000915","report_time":"0715","city":"DENVER","state":"CO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X1YD517106","vehicle_license":"25744","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:48:56"},{"crash_id":"528250","dot_number":"252668","report_state":"FL","report_date":"20000722","report_time":"1405","city":"JACKSONVILLE","state":"FL","fatalities":0,"injuries":2,"tow_away":0,"vin":"1XKWD69X2GS336195","vehicle_license":"1ND873","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING  INC TERRY RAMSEY","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:36"},{"crash_id":"164674","dot_number":"252668","report_state":"UT","report_date":"20000330","report_time":"0140","city":"THOMPSON","state":"UT","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X1WD445756","vehicle_license":"1242","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING  INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:36"},{"crash_id":"868327","dot_number":"252668","report_state":"NV","report_date":"19991103","report_time":"1145","city":"","state":"NV","fatalities":0,"injuries":0,"tow_away":0,"vin":"301645","vehicle_license":"1207","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING  INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:49:49"},{"crash_id":"497905","dot_number":"252668","report_state":"CO","report_date":"19990414","report_time":"1115","city":"","state":"CO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X2SD381429","vehicle_license":"PWR1222","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"575397","dot_number":"252668","report_state":"ID","report_date":"19990331","report_time":"1120","city":"BOISE","state":"ID","fatalities":0,"injuries":1,"tow_away":0,"vin":"1XP5DB9X2XD466732","vehicle_license":"1203","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"786886","dot_number":"252668","report_state":"MS","report_date":"19990302","report_time":"1410","city":"","state":"MS","fatalities":0,"injuries":2,"tow_away":0,"vin":"UNKNOWN","vehicle_license":"1240","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"434669","dot_number":"252668","report_state":"AZ","report_date":"19990124","report_time":"1013","city":"YUCCA","state":"AZ","fatalities":1,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"31179","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"497423","dot_number":"252668","report_state":"CO","report_date":"19990106","report_time":"0800","city":"DENVER","state":"CO","fatalities":0,"injuries":1,"tow_away":0,"vin":"1FUYDSEB7TP682490","vehicle_license":"28376","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:15"},{"crash_id":"146315","dot_number":"252668","report_state":"TX","report_date":"19980918","report_time":"0100","city":"HOUSTON","state":"TX","fatalities":0,"injuries":0,"tow_away":0,"vin":"","vehicle_license":"32624","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING INC (EARL PILE)","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:28"},{"crash_id":"773475","dot_number":"252668","report_state":"MO","report_date":"19980831","report_time":"0240","city":"071852 ST. JOSEPH","state":"MO","fatalities":0,"injuries":0,"tow_away":0,"vin":"UP721948","vehicle_license":"283721","vehicle_lic_state":"","cargo_body_type":"","gvw_rating":"","weather_condition":"","road_surface":"","light_condition":"","carrier_name":"PILE TRUCKING","federal_recordable":"Y","state_recordable":"Y","source":"mcmis","ingested_at":"2026-05-16 00:50:28"}]}