NTSB investigations, IL
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1 WHERE c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA' ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CHI82DA321Accident · No injuriesFinal reportCassutt Cassutt · West Chicago, ILThe purpose of the flight was to check the aircraft after repitching the propeller blade angle. Reportedly, the tail wheel swivel cotter pin failed and the pilot lost directional control during the landing. The aircraft then veered off the right side of the…NTSB CHI82FA312Accident · 2 fatalField investigationFinal reportTaylorcraft BL-65 · Rock Falls, ILAircraft caught fire while performing aerobatics and crashed out of control. Gas tank cap had come off and during inverted flight fuel spilled out and ignited.NTSB CHI82DA307Accident · No injuriesFinal reportPiper PA-28-151 · Kankakee, ILSometime after 2300 on August 14, 1982, the aircraft was taken without authorization from the greater Kankakee airport. The aircraft was discovered in a nearby field some 750 feet from the runway. Markings on runway 04 indicated that approximately 150 feet…NTSB CHI82DA305Accident · No injuriesFinal reportBeech E-33 · Frankfort, ILThe accident occured when the pilot was on his final approach to land. The pilot inadvertently touched down 100 feet short of the runway threshold and during the subsequent landing roll the aircraft struck an embankment.NTSB CHI82DA310Accident · No injuriesFinal reportCessna 195A · Dixon, ILThe pilot landed downwind on runway 26 and the aircraft groundlooped during the landing roll. The main landing gear and left wing tip were damaged during the swerve.NTSB CHI82DA302Accident · No injuriesFinal reportSonerai II · Peru, ILThe pilot stated this was the first cross-country in the aircraft the fuel consumption calculations were based on an estimated 4 gallons per hour. When the pilot realized a low fuel condition he decided to land enroute. During the landing approach at Peru, IL…NTSB CHI82DA293Accident · No injuriesFinal reportCessna 152 · Belvidere, ILThe student pilot was practicing touch-and-go landings. On his last landing, the nosewheel struck the ground hard. He reported that there was damage to the nosewheel, and firewall and the engine and propeller were bent.NTSB CHI82DA288Accident · No injuriesFinal reportPiper PA-28-180 · Rockford, ILThe aircraft began to settle or mush after takeoff so the pilot made a landing in a school yard. Post accident examination failure to reveal any evidence of engine malfunction although pilot claimed he lost power. The aircraft was about 80 lbs. Below maximum…NTSB CHI82DA315Accident · No injuriesFinal reportPiper PA-38 · New Haven, ILThe pilot reported that before departing on a routine pipe line patrol, he obtained a weather briefing. After about 30 minutes of flight, the visibility began to decrease due to ground fog. The pilot elected to land on a gravel road. During the landing roll,…NTSB CHI82DA285Accident · No injuriesFinal reportCessna 310P · Marion, ILThe aircrafts right main landing gear collapsed during landing. The instructor and student were practicing touch and go landings when the accident occurred. Examination of the gear revealed the torque tube assembly (p/n 504-5010-8) was broken at the forward…NTSB CHI82DA344Accident · No injuriesFinal reportCessna 150J · Dekalb, ILThe student pilot was practicing touch-and-go landings. He stated that on about his sixth landing, he touched down hard on the main gear then lowered the nose. As the nose wheel touched down, the aircraft veered to the left and the right wing contacted the…NTSB CHI82DA280Accident · Minor injuriesFinal reportSIAI Marchetti S.205-22/R · Carrollton, ILThe aircraft engine failed inflight and during the forced landing on a road the aircraft collided with posts. An investigation showed that a #4 connecting rodcap attaching bolt had failed.NTSB CHI82DA283Accident · No injuriesFinal reportQ-Berry Hawk · Noble, ILAbout 30 min after taking off on a local test flight, the pilot had entered the traffic pattern and was preparing to turn onto a crosswind leg, when the engine lost power. He attempted to restart the engine, but was unable. He attempted to glide to a runway,…NTSB CHI82DA274Accident · No injuriesFinal reportCessna 188B · Loami, ILThe pilot was taking off on the first flight of the day with a reported load of 1080 lbs of wheat seed. During the takeoff, there was a direct crosswind of 6 KTS and the temperature and dew point were 78 and 68 deg, respectively. After using about 3/4 of the…NTSB CHI82DA270Accident · Serious injuriesFinal reportAustin S.E. 5A · Bolingbrook, ILThe pilots of an Austin s.e. 5A and a folker (both ww I replica aircraft) agreed to make a photo fly-by. The pilot of the Austin took off as number one, but instead of remaining in the traffic pattern, he turned out of the pattern. The folker pilot followed…NTSB CHI82DA268Accident · No injuriesFinal reportPiper PA-38 · Antioch, ILThe pilot initiated a soft field takeoff from a 2200 ft, wet, grass runway. After becoming airborne, he lowered the nose of the aircraft to increase his airspeed. The pilot stated that the aircraft failed to climb as expected and would not clear boats that…NTSB CHI82FA266Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Hartsburg, ILAt 1223 CDT the plt contacted peoria approach control & requested radar vectors to the Mt. Hawley arpt located just northof the peoria arpt. At 1227 CDT he stated the weather was getting bad & he would like to fly to the logan county arpt. One witness stated…NTSB CHI82FEV06Accident · No injuriesFinal reportCessna 152 · Jacksonville, ILLanding was made on sod rwy 4. Touchdown was approximately 60 ft prior to crossing the hard surface parallel taxiway for rwy 13/31. The nose wheel broke off upon contact with the hard surface of the parallel taxiway. There was an approximate 2 inch lip…NTSB CHI82FA262Accident · 2 fatalField investigationFinal reportCessna 150L · Pontiac, ILBoth plts onboard were cfi's. the acft was observed to slow down & enter a stall/spin which continued to impact.NTSB CHI82DA250Accident · No injuriesFinal reportPiper PA-30-160 · Salem, ILPilot stated he had 3 green gear lights. During touchdown and roll the landing gear collapsed. The landing gear control switch collar was defective and if the pilot did not hold the gear selector in the down position it may have returned to off before the…NTSB CHI82DA249Accident · No injuriesFinal reportCessna 150J · Alton, ILThe student and instructor pilot (ip) were departing on an instructional flight. Immediately after takeoff, the ip retarded the throttle to simulate an engine failure. The student lowered the nose to maintain airspeed, then prematurely raised it again. The ip…NTSB CHI82DA243Accident · No injuriesFinal reportCessna 182 · Downers Grove, ILThe aircraft collided with a tree during forced landing on a golf course after the engine lost power at 300 feet AGL during takeoff. Water was found in the sumps and carburetor. The right fuel tank cap was not sealing. The pilot reported that the wing sumps…NTSB CHI82DA235Accident · Minor injuriesFinal reportGrumman American AA-1C · Danville, ILThe student pilot stated that at 3000 ft, 14 NM north of the Danville VOR, the engine began vibrating. The engine lost power and the pilot was forced to land in a bean field approximately 4 miles north of the Danville airport. Engine examination revealed the…NTSB CHI82FA234Accident · 1 fatalField investigationFinal reportGoans G-5 · Kankakee, ILThe pilot was making his first flight since a special airworthiness certificate was issued. This aircraft was unique in that the rotor controls were cable instead of push-pull rods. The aircraft after takeoff started pitching up and down. This pitching…NTSB CHI82DA237Accident · No injuriesFinal reportWaco UPF-7 · Popular Grove, ILThe pilot experienced severe engine vibration during cruise flight. The pilot performed an emergency landing in a field. Because of the length of the field the pilot landed hard and the left main gear collapsed. The separated gear struck and fractured the…NTSB CHI82FA228Accident · Serious injuriesField investigationFinal reportPiper PA-28RT-201 · Washington, ILDuring takeoff, the aircraft struck a pile of lumber that was 62 ft from the departure end of the runway. Two witnesses believed that the pilot did not use all off the runway for takeoff. One witness estimated that the pilot began the takeoff about 150 ft…NTSB CHI82DA225Accident · No injuriesFinal reportBoeing E75 · Bloomington, ILThe pilot stated that almost immediately after touchdown the aircraft began tracking to the left. During the attempt to arrest the swerve, the aircraft ground looped 180 degrees to the right. The tail struck two taxi lights as it rotated and the aircraft came…NTSB CHI82FA223Accident · No injuriesField investigationFinal reportCessna 337B · Greenville, ILDuring the initial climb after a touch & go, the rear eng stopped at about 100 to 200 ft AGL. The plt switched the fuel selector to right aux tank but was unable to restart the rear eng. At about 300 to 400 ft AGL the front eng stopped. The plt switched the…NTSB CHI82DA215Accident · Serious injuriesFinal reportBellanca 73CA · Fairfield, ILThe pilot stated that after takeoff he flew 3 or 4 miles, started a right turn and could not recall any further events concerning the flight. Investigation revealed the aircraft crashed on flat terrain. Examination of the flight controls did not reveal any…NTSB CHI82FEE15Accident · Minor injuriesFinal reportSwanson SSW-DTV · Marengo, ILA power loss occurred shortly after takeoff; however, the pilot was able to regain power after mixture adjustments. Upon returning to land, power was again lost partially, then completely. The pilot landed in a soft cornfield in line with the approach path.…NTSB CHI82FEE14Accident · No injuriesFinal reportDouglas DC-3A · Sandwich, ILAfter returning from a parachute jumping flight, the pilot elected to land on the 1800 ft grass runway. A 3000 ft asphalt runway was available, but he had been using the grass runway to avoid wear on the tires. There was a 30 ft powerline at the approach end…NTSB CHI82DA188Accident · No injuriesFinal reportPiper PA-34 · Springfield, ILAfter landing the pilot attempted to taxi the aircraft back to the ramp area in heavy rain and reduced visibility. The aircraft taxied off the left side of the runway and struck two runway lights.NTSB CHI82DA185Accident · No injuriesFinal reportHughes 369D · Fairbury, ILDuring flight, the N2 and nr suddenly accelerated to 110 percent. The pilot eventually shut down the engine and made an autorotation. An open field was selected for a landing site; however, it was muddy with standing water. The pilot decided on a full stop…NTSB CHI82DA180Accident · No injuriesFinal reportPiper PA-28 · Harrisburg, ILDuring a weather briefing, the pilot was advised that there were thunderstorms in the area of his destination at about 1415 CDT, he departed for a two hour flight. After flying over weather most of the way and overflying an airport (hulman regional), he…NTSB CHI82DA175Accident · No injuriesFinal reportCessna R182 · Cahokia, ILThe pilot was making touch and go landings on runway 30 with a wind from about 180 degrees at 11 KTS. On the fourth landing, the aircraft bounced two or three times. The plane slid sideways, went off the runway, and the nose gear failed.NTSB CHI82DA171Accident · Minor injuriesFinal reportBell 47G-5 · Sublette, ILPrior to this flight, the helicopter had been flown about 1 hr from roselle to Sublette, IL, then it was flown another 1/2 hr to survey the area to be sprayed. About 10 minutes after departing to spray, the engine lost power. The pilot started an autorotative…NTSB CHI82FA168Accident · Serious injuriesField investigationFinal reportPiper PA-22 · Joilet, ILWhen the aircraft was about 1 1/2 miles from the destination, a fire started on the left side of the floorboard against the firewall. The pilot turned off the electrical system, and before landing, shut off the fuel selector. After landing, the occupants…NTSB CHI82DA166Accident · No injuriesFinal reportCessna 210 · Galesburg, ILThe pilot was discussing short field landing techniques and the use of flaps with the student pilot/passenger and forgot to lower the landing gear. The wheels up landing resulted in substantial damage to the aircraft.NTSB CHI82DA158Accident · No injuriesFinal reportCessna 150 · Bloomington, ILThe pilot stated that base and final approach at Bloomington-normal airport seemed smooth at 80 mph. At 8 ft above the runway the throttle was reduced to idle. Immediately at throttle reduction, the aircraft dropped to the runway landing on the main gear. The…NTSB CHI82DA155Accident · No injuriesFinal reportCessna 180 · Aurora, ILOn takeoff the aircraft veered off the side of the runway and struck a drainage ditch. The pilot reported a gust of wind caught the aircraft.NTSB CHI82DA154Accident · Minor injuriesFinal reportCessna 182 · Ottawa, ILThe aircraft collided with a truck off the approach end of the runway during a low, no flap approach. According to the pilot a caution sign for vehicles using the road had been removed by vandals and he did not see the truck because of his low approach. The…NTSB CHI82DA153Accident · No injuriesFinal reportCessna 152 · Peoria, ILThe pilot departed mt hawley airport for greater Peoria airport to practice touch and go landings. His first approach was high and he made a go-around. He reported that his second approach was a bit too high, but he elected to continue since the runway was…NTSB CHI82DA151Accident · No injuriesFinal reportCessna 172A · Cissno Park, ILDuring takeoff on runway 09, the aircraft veered to the left. The pilot closed the throttle, but was unable to stop before the left wheel went into soft soil on the north side of the runway. Gusty winds from the south picked up the tail and gently rolled the…NTSB CHI82FA146Accident · No injuriesField investigationFinal reportBeech 56TC · Chicago, ILThe pilot stated that during landing, the touchdown was smooth. Shortly after touchdown, the left wheel began to wobble and thump and the aircraft started to veer to the left. Reportedly, the right brake would not hold the aircraft on the runway. The aircraft…NTSB CHI82DA132Accident · No injuriesFinal reportBeech BE-23 · West Chicago, ILThe pilot stated that during landing flare the aircraft dropped rapidly striking the runway on the main gear. It then bounced back into the air and landed on the nose gear which collapsed.NTSB CHI82DA118Accident · No injuriesFinal reportCessna 172 · Marion, ILThe pilot reported that the wind was from 200 degrees at 22 gusting 30 knots. While taxiing eastbound from the runway, a gust of wind lifted the right wing and tail, and the aircraft nosed over.NTSB CHI82IA113Incident · No injuriesIncident investigationFinal reportCessna 402B · Waukegan, ILPilot reported an oil leak in the right engine to controller while on an instrument approach to Waukegan airport. Several minutes later, pilot reported that he had lost sight of the airport and due to loss of power in the right engine, elected to land in a…NTSB CHI82DA109Accident · No injuriesFinal reportCessna 180 · Nokomis, ILDuring takeoff from a soft sod field the aircraft started gradually turning to the left. The pilot applied full right rudder then reduced power before the aircraft nosed over on its back.NTSB CHI82IA108Incident · No injuriesIncident investigationFinal reportSwearingen SA226TC · Chicago, ILThe aircraft veered left at slow speed but the veer was corrected. At 60 KTS the aircraft veered again and was not corrected. Aircraft left runway and damaged props. Service bulletin SA-226 no. 103 dated 01/20/82 states that limits be placed on use of nose…NTSB CHI82DA103Accident · Minor injuriesFinal reportCessna 175 · Tuscola, ILA landing was made on runway 27 just prior to sunset. The pilot reported that he realized he was not slowing fast enough, but due to the low altitude of the setting sun, he misjudged the length of the runway. He initiated a go-around, but did not obtain…