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 CHI82DA101Accident · Minor injuriesFinal reportCessna 150 · West Chicago, ILThe student and an instructor had previously flown this aircraft to recertify the student for solo flight. After the dual flight, the student had some problem with obtaining fuel and took off without refueling. While flying at night, the student became lost.…NTSB CHI82DA097Accident · No injuriesFinal reportCessna 150 · Wheeling, ILThe student pilot departed Wheeling, IL on a cross-country flight to dubuque, IA; oshkosh, WI and return. The pilot refueled with 17.7 gallons of 100 octane low-lead gasoline at dubuque, but did not refuel at oshkosh. Near milwaukee, he noted that the right…NTSB CHI82DA085Accident · No injuriesFinal reportPiper PA-22-150 · Rockford, ILThe pilot had taxied to runway 24. While making a turn to runup, the wind picked up the right wing and tail, and flipped the plane over on its back.NTSB CHI82IA072Incident · No injuriesIncident investigationFinal reportSwearingen SA-227 · Chicago, ILThe pilot stated that at the departure airport, the runway was slippery and the turn onto the runway was difficult. The nosewheel steering was activated momentarily to straighten the nose, but was turned off prior to the takeoff roll. At the destined airport…NTSB CHI82DA066Accident · No injuriesFinal reportCessna 152 · Plainfield, ILThe student pilot stated that during takeoff roll the aircraft began to drift left. Right rudder did not correct the drift and the left wheel contacted snow on the side of the runway causing drag on the aircraft. The aircraft nosed over as it departed the…NTSB CHI82DA060Accident · No injuriesFinal reportCessna 172A · Roselle, ILShortly after takeoff, the pilot noted a partial loss of power. He turned back toward the airport and turned the carburetor heat on; however, the carburetor heat did not seem to help. The fuel selector was switched from both tanks to the right tank, and this…NTSB CHI82DA058Accident · No injuriesFinal reportBeech 58 · St. Charles, ILDuring an IFR approach the pilot stated he picked up about 1/2 to 1 inch of ice on the leading edge of the wings after activating all icing equipment. After breaking out of the clouds the pilot descended with full flaps at 110 to 115 knots. He began to flare…NTSB CHI82DA050Accident · No injuriesFinal reportPiper PA-31-310 · East Saint Loui, ILThe aircrew did not key the approach lights on during the first ILS approach at night. Therefore, a missed approach was made. On the second approach, the lead-in lights were visible from over one mile. However, the visibility was much worse at touchdown,…NTSB CHI82DA052Accident · No injuriesFinal reportPiper PA-28-151 · Monee, ILThe pilot began his takeoff at the approach end of runway 27. He stated that the aircraft rolled straight for 700 ft, then at about 55 mph (lift-off speed), the plane veered left into a snowbank. The runway was 35 ft wide and was reported to have had frozen…NTSB CHI82DA053Accident · No injuriesFinal reportPiper PA-28-161 · Dwight, ILAfter landing the aircraft encountered ice on the runway. The pilot applied brakes, swerved left, and collided with a snowbank.NTSB CHI82DA046Accident · Minor injuriesFinal reportCessna 150 · Altamont, ILAbout five to ten minutes after takeoff at night, the engine began to lose power and then suddenly stopped. Pilot elected to land in a light colored area that was surrounded by darker areas. During the approach, the aircraft struck a tree which damaged the…NTSB CHI82DA045Accident · No injuriesFinal reportSikorsky UH-19B · Urbana, ILThe pilot and a medical attendant were on a flight to Urbana to make a medical evacuation. The pilot stated that just prior to touchdown, the helicopter began to rotate to the left. He reported that he landed immediately, cut the power, and stopped the…NTSB CHI82DA043Accident · No injuriesFinal reportPiper PA-28R-201 · Mattoon, ILThe pilot tookoff with an inoperative landing light. After arriving at the destination, it was dark and snowing, and the visibility was about one mile. Airport personnel were removing snow from the lights on runway 11/29. Snow had been cleared from the lights…NTSB CHI82DEE13Accident · No injuriesFinal reportCessna 152 · Lansing, ILWhile on a supervised solo the acft drifted to the left during rollout on rwy 9. The left main gear was caught in snow at the side of the rwy causing the acft to nose into a snowbank.NTSB CHI82DA036Accident · No injuriesFinal reportCessna 182H · Peoria, ILThe owner of the aircraft was a student pilot. Another person, who was a private pilot, stated that he was invited to ride along. The private pilot reported that he was unaware that the aircraft owner was not a certificated pilot. After returning from a local…NTSB CHI82FEE12Accident · No injuriesFinal reportCessna 172RG · Wheeling, ILThe pilot stated that after the aircraft was started and warmed up approximately five to ten minutes the engine was shut down to investigate frozen brake pads. After the brake pads were freed the engine was restarted and during cranking the pilot noticed…NTSB CHI82IA026Incident · No injuriesIncident investigationFinal reportLockheed L-1011 · Chicago, ILThe aircraft had departed boston on a scheduled flight with the #1 generator placarded inoperative and noted in the minimum equipment list. En route to los angeles, CA at FL 350, about 80 mi northeast of bay city, MN., the crew noted a simultaneous loss of #2…NTSB CHI82FA025Accident · No injuriesField investigationFinal reportPiper 23-250 · Wheeling, ILShortly after takeoff the pilot noticed a loss of oil pressure on both engines and initiated a left turn back to the airport. During landing the aircraft departed the right side of runway 12, collided with, and substantially damaged two Cessna 150'S and…NTSB CHI82DA023Accident · No injuriesFinal reportCessna 152 · Peoria, ILReportedly, the student tookoff without his instructor's appproval. He initiated a takeoff roll on runway 35 with the wind from 230 degrees at 11 knots. He stated that the wind shifted and caught him from behind as he was about to lift off. Directional…NTSB CHI82DA021Accident · No injuriesFinal reportCessna 152 · Paxton, ILDuring the student's last landing, the landing gear struck a snowberm at the approach end of the runway. Reportedly, the berm could not be seen from the air. After hitting the berm, the instructor took control of the aircraft and completed the landing. An…NTSB CHI82DEV05Accident · No injuriesClosedCessna 172 · Carthage, ILNTSB CHI82FEE10Accident · No injuriesClosedCessna 177RG · Monee, ILNTSB CHI82FEE09Accident · No injuriesClosedCessna 177 · Paw Paw, ILNTSB CHI81FEE08Accident · No injuriesClosedPiper PA-28 · Rochelle, ILNTSB CHI82FEX04Accident · No injuriesClosedPiper PA-28 · Gibson City, ILNTSB CHI82DEE11Accident · No injuriesClosedCessna 172M · Chicago, ILNTSB CHI82FEV04Accident · No injuriesClosedCessna 177B · Villa Grove, ILNTSB CHI82FEE07Accident · No injuriesClosedCessna 172N · Kankakee, ILNTSB CHI82FEE06Accident · No injuriesClosedCessna 172RG · Fox Lake, ILNTSB CHI82FEE05Accident · No injuriesClosedCessna 172N · Grayslake, ILNTSB CHI82FCA01Accident · No injuriesClosedHughes 369HS · Cahokia, ILNTSB CHI82FEE04Accident · No injuriesClosedBeech C23 · West Chicago, ILNTSB CHI82DA010Accident · Serious injuriesClosedMooney M20J · Effingham, ILNTSB CHI82DEV03Accident · No injuriesClosedBeech B19 · Savoy, ILNTSB CHI82FEV02Accident · Minor injuriesClosedCessna 205 · Danville, ILNTSB CHI82FEE03Accident · 1 fatalClosedSonerai II · Romeoville, ILNTSB CHI82FA006Incident · Minor injuriesClosedShorts SD3-30 · Dixon, ILNTSB CHI82FA004Accident · No injuriesClosedPiper PA-60 · Champaign, ILNTSB CHI82FA003Accident · 4 fatalClosedCessna 310I · Hainesville, ILNTSB CHI82FA002Accident · 1 fatalClosedBeech B95A · Bedford Park, ILNTSB CHI82DEE02Accident · No injuriesClosedPiper PA-38 · Joliet, ILNTSB CHI82FEE01Accident · Serious injuriesClosedPiper PA-28 · Wheeling, ILNTSB CHI82DEV01Accident · Minor injuriesClosedSchweizer SGS126 · Monticello, ILNTSB ATL82FLQ01Accident · No injuriesClosedCessna 172RG · Wheeling, ILNTSB CHI81FEE53Accident · Minor injuriesClosedGulf Amer AA-5A · Plainfield, ILNTSB CHI81IA099Incident · No injuriesClosedCessna 152 · Romeoville, ILNTSB CHI81DEE54Accident · No injuriesClosedPiper PA-28 · Polo, ILNTSB CHI81FA096Accident · 1 fatalClosedCessna 175 · Fenton, ILNTSB CHI81DEE52Accident · No injuriesClosedPitts S1C · Lockport, ILNTSB CHI81FA092Accident · No injuriesClosedHawker Sdly 748 · Chicago, IL