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 CHI84LA100Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Lk In The Hills, ILThe plt made a hard landing which damaged the nose gear making it impossible for the plt to avoid a collision with a snowbank during a subsequent landing.NTSB CHI84LA101Accident · No injuriesLimited investigationFinal reportPiper PA38-112 · Lacon, ILThe plt was ferrying the acft to the Lacon arpt for winter storage. On final apch she touched down short & struck a snow bank on the apch end of the rwy. The plt stated that difficulty in depth perception due to the snow covered terrain resulted in touchdown…NTSB CHI84LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Greenville, ILThe plt received a weather briefing the night before the accident and did not have it updated on the day of the accident. The acft was descended below the mda during the approach in fog and collided with high tension lines.NTSB CHI84LA095Accident · No injuriesLimited investigationFinal reportCessna C-172P · Macomb, ILThe acft swerved off the rwy into a ditch during a crosswind landing. The wind was from 180 degrees at 10 KTS. The plt said that he lost directional control of the acft because of the wind.NTSB CHI84IA093Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILAs the capt applied power & released brakes to begin the takeoff, the acft started to drift to the right. The capt stated that he closed the throttles & put the #1 & #2 throttles in reverse. The acft then began to veer left & spun around nearly 1-1/2 times.…NTSB CHI84LA092Accident · No injuriesLimited investigationFinal reportBeech B-19 · Crystal Lake, ILThe acft hit a snow bank during an approach for landing. The plt added power and made a go-around. The CFI took control of the acft and made the final landing when the main landing gear collapsed.NTSB CHI84LA090Accident · No injuriesLimited investigationFinal reportCessna 210D · Rockford, ILThe plt was on a maintenance test flt to check the landing gear hydraulic power pac. He was unable to lower the main landing gear and landed with the nosewheel down. Examination of the hydraulic pac after the accident revealed that the hydraulic system had…NTSB CHI84LA087Accident · No injuriesLimited investigationFinal reportCessna 150L · Rock Falls, ILThe instructor plt stated that the student plt was flying the aircraft. While on final approach he advised the student plt to add engine power. The student did so very rapidly causing the engine to stall. Before the engine could be restarted the aircraft…NTSB CHI84LA085Accident · No injuriesLimited investigationFinal reportCessna 140 · Huntley, ILThe student plt allowed the acft to drift left during takeoff in spite of verbal instructions by the CFI to correct the situation. The acft continued toward a snowbank and the CFI did not take corrective action on the controls in time to avoid a collision…NTSB CHI84LA086Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Waukegan, ILThe student plt said he lost too much airspeed during a no power approach and made a hard landing. After a bounce, the acft hit on the nose gear and it collapsed. The acft skidded off the rwy into a snowbank.NTSB CHI84LA091Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Chicago, ILThe acft was being taxied from landing. At a service road intersection a baggage tug collided with the right wing. The acft lights were reportedly on at the time of the accident. The driver of the tug said he was not looking for a small acft on the taxiway,…NTSB CHI84LA081Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · East St. Louis, ILThe pilot was found lying on the ramp under the front of the aircraft, bleeding profusely from scalp wounds. Although he was unable to recall the circumstances preceding the accident, he noted that it would not have occurred had he not attempted to 'pull the…NTSB CHI84LA079Accident · No injuriesLimited investigationFinal reportCessna 150G · Plato Center, ILThe acft nosed over during a forced landing after the engine lost power. After the accident oil samples from the acft were analyzed and found to contain anti-freeze. The acft owner suspected sabotage.NTSB CHI84FA076Accident · No injuriesField investigationFinal reportBeech BE-99 · Galesburg, ILThe main gear retracted while the acft was being taxied to the taxioff position. Investigation revealed that a landing gear maintenance valve PN22400-1, SN19 manufactured by airright inc had corroded and was allowing stray voltage to cyclethe landing gear…NTSB CHI84LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Peoria, ILThe student plt elected to make a touch & go landing on a rwy covered with loose snow & patches of ice. He reported that when he added power during his 1st touch & go, the acft veered to the left & subsequently collided with a snowbank.NTSB CHI84IA060Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-61 · Chicago, ILA DC-8-61 operated by capitol air inc experienced a partial failure of the left main gear on the landing roll. The rear portion of the left main landing gear bogie & both rear tires were separated. Components of the left landing gear were submitted to…NTSB CHI84FA051Accident · 1 fatalField investigationFinal reportBeech V35B · Cairo, ILThe acft dove into the ground nose first from a 90 degree bank shortly after takeoff. The acft was observed by witnessesto take off slowly 'with about 1/2 power' being used. The climb was slow and at 300-400 ft the acft turned left with thelanding gear still…NTSB CHI84IA041Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Chicago, ILDuring taxi from landing the left outboard wheel rim failed and bounced onto a highway causing damage to a vehicle the rim failed due to a per-existing fatigue crack.NTSB CHI84FU001Accident · 1 fatalFinal reportQuicksilver MX · Elwin, ILThe plt possessed a student plt & 3rd class medical certificate. After takeoff, he circled over the airfield, then climbed to about 200 ft AGL. A high school classmate stated that the ultralight then entered a nose high attitude & appeared to enter a practice…NTSB CHI84FEE01Accident · No injuriesFinal reportPopelka BD-5 · Sugar Grove, ILThe acft had received an inspection on 9/8/83, before it was disassembled & transported from California to Illinois. On 10/27/83, the plt took off on a flt from sandwich to aurora, IL. While on a final apch to land at aurora, after a throttle reduction, the…NTSB CHI84LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Harrisburg, ILThe acft nosed over during takeoff roll while on a solo training flt. The pilot applied too much right rudder then over compensated with left rudder and brake. The acft went off the left side of the rwy into soft mud and nosed over.NTSB DCA84AA002Accident · 10 fatalFinal reportHawker Siddeley HS-748-2A · Pinckneyville, ILAbout 1.5 min after departing springfield, IL, the fltcrew reported a slight electrical problem, but they continued on course. About 33 min later & a few min before the acft should have reached its destination, the acft crashed. Impact occurred while the acft…NTSB CHI84LA017Accident · No injuriesLimited investigationFinal reportCessna 177 · Wonder Lake, ILThe acft veered off the rwy and into a fence during a crosswind landing. The landing was on rwy 9 and the wind was from 021 degrees at 5 KTS gusting to 22 KTS. The pilot had applied power for a go-around but not in time to prevent the touchdown. Then the acft…NTSB CHI84LA011Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Aurora, ILApproaching the destination arpt the plt was advised by Aurora local control that the only available landing area was anunlighted taxiway, designated temporary rwy 9/27, used as a day VFR rwy. Use of the temporary rwy after sunset was not authorized, & the…NTSB CHI84LA020Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · East Peoria, ILAt about 10 ft AGL a 300-400 RPM decrease in power occurred. The plt elected to land straight ahead into a cut bean field. He touched down about 400 ft from the end of the rwy, traveled about 500 ft further where a large rut was struck. About 10 flt hours…NTSB CHI83IA446Incident · No injuriesIncident investigationFinal reportCessna 401A · Frankfort, ILThe right main landing gear collapsed during landing roll-the right main landing gear bellcrank was found to have failed in instantaneous overload. The rigging of main gear was improper.NTSB CHI83LA444Accident · No injuriesLimited investigationFinal reportCessna 172P · Sandwich, ILDuring landing the plt used forward slip, & after touchdown the acft went off the right side of the rwy striking a taxiway. The jar of hitting the taxiway resulted in the plt unintentionally advancing the throttle & the acft became airborne. The plt retarded…NTSB CHI83FA441Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Bethany, ILPrior to this flt, the plt had contacted a fss & inquired about the wx. He was advised that VFR flt to terre haute, IN, was not recommended. He took off at about 1830 CDT. The plt again contacted the fss & inquired about the wx at burlington, IA &…NTSB CHI83FA440Accident · 2 fatalField investigationFinal reportErcoupe 415-C · Raymond, ILDuring a wx briefing at 1433 CDT, the plt was advised to expect 500 ft ceilings, 2 mi visibilities, rain showers & thunderstorms. He then took off from bismark, MO with no flt plan. Reportedly, wx was encountered during the flt which deteriorated as he…NTSB CHI83LA432Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Carthage, ILThe acft collided with a ditch during landing. The acft bounced and floated during landing. The pilot said he thought hewas too FAR down the rwy for a go-around so he applied the brakes. The acft skidded off the rwy end into a ditch. The pilot thought a gust…NTSB CHI83LA430Accident · No injuriesLimited investigationFinal reportCessna U206F · Garden Prairie, ILWhile en route, the fuel pressure dropped, and subsequently, the eng lost power completely. During a landing in a corn field, the acft was damaged. An investigation revealed that the fuel line had separated at the flow divider. Reportedly, the eng had been…NTSB CHI83FA428Accident · Minor injuriesField investigationFinal reportSikorsky S-76A · Chicago, ILWhile cruising at 2000 ft MSL & 150 KTS, the crew heard a loud noise, and simultaneously, the helicopter yawed aprx 30 to 40 deg to the right & pitched nose down. The aircrew began an autorotation & activated the emergency floats. The helicopter continued in…NTSB CHI83IA425Incident · No injuriesIncident investigationFinal reportFairchild FH-227 · Chicago, ILAfter taking off, the landing gear handle remained latched 'down' when the nosewheel did not center. The flightcrew thenused the nose gear steering override sw & turned the nosewheel until the 'off center light' extinguished. The override sw was placed 'off'…NTSB CHI83LA424Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Wheeling, ILThe acft went off the rwy and collapsed the landing gear after power loss during takeoff. Three of the passengers furnished statements and 2 seemed to think that the left engine quit. The acft turned to the right but the pilot did notknow which engine quit.…NTSB CHI83LA422Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Galesburg, ILAfter landing at the Galesburg arpt, the plt was turning onto the taxiway when the acft ground looped in strong wind conditions. The left wing was substantially damaged during the mishap.NTSB CHI83LA421Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Galesburg, ILThe plt stated that when he was landing on rwy 20 with a x-wind, it switched to a rear quartering wind. At about that time, the acft went off the rwy & struck a rwy marker with its tailwheel. The acft then ground looped, damaging the lower left wing.NTSB CHI83LA420Accident · No injuriesLimited investigationFinal reportBoeing PT-13D · Galesburg, ILDuring the landing roll, the left main tire blew out & the plt lost directional control. Subsequently, the acft ground looped & the left wing & aileron were damaged.NTSB CHI83IA418Incident · No injuriesIncident investigationFinal reportBoeing 727-200 · Chicago, ILThe acft experienced a left walking beam failure when the landing gear was extended during approach, the acft log was noted 'during gear extension at 230 KTS tremendous bang occurred which dropped panels at rows 15-7 02 masks at row 18. Three green normal…NTSB CHI83LA427Accident · No injuriesLimited investigationFinal reportCessna 172 · Carbondale, ILThe instructor plt (CFI) was providing a dual check-out for a private plt in the Cessna 172. After flying in the local area, they returned to the arpt to practice touch-and-go landings on rwy 18. The winds were reported from 190 deg at 20, gusting 25 KTS. On…NTSB CHI83LA415Accident · No injuriesLimited investigationFinal reportCessna 150G · Paris, ILThe student plt was on his 1st solo x-country flt. On the 1st leg of the flt, he became disoriented, experienced fuel exhaustion & landed in a soybean field. During the landing, the acft nosed over when the gear encountered the tall beans. The student…NTSB CHI83LA416Accident · No injuriesLimited investigationFinal reportCessna 152 · Frankfort, ILThe plt stated that he touched down with a slight angle to the rwy and went off to the left side into the grass. He misjudged the distance to the trees and the left wing contacted a tree.NTSB CHI83LA411Accident · No injuriesLimited investigationFinal reportPiper J-3 · Rockford, ILThe plt stated the engine quit, sputtered and quit again before he landed in a bean feild and nosed over. Plt who is also an A&P mechanic had been using sloshing/sealing compound (randolph tank sealer #802) in the fuel tank. After the accident the compound…NTSB CHI83LA398Accident · No injuriesLimited investigationFinal reportStewart Headwind · New Douglas, ILDuring flt, the eng lost power & the plt was unable to get a restart. While making a forced landing in a plowed field, the main gear collapsed & the acft nosed over. Later, after the acft was uprighted, the eng was started & was operated to 1300 RPM. Prop…NTSB CHI83LA396Accident · No injuriesLimited investigationFinal reportCessna 172 · Princeton, ILThe turf rwy was wet from recent rains. The plt stated that during takeoff, the acft had accelerated to near the rotation speed when it was slowed by a soft spot in the rwy near mid field. At the same point, an upslope portion of the rwy was encountered & the…NTSB CHI83LU011Accident · Serious injuriesFinal reportPioneer Flightstar · Robinson, ILThe plt reported that after taking off, he stayed low over farm fields. He reported that he traveled about 1 1/4 mi from the arpt & decided to return & land. However, during a left turn, the ultralight vehicle crashed. The plt was seriously injured & did not…NTSB CHI83FU009Accident · 1 fatalFinal reportWeedhopper B · St. Joseph, ILThe ultralight vehicle collided with the ground after the left wing folded up at about 1000 ft AGL. Witnesses said the ultralight was traveling east when the wing collapsed or folded back. Reportedly, it pitched up & the right wing tip went up. The vehicle…NTSB CHI83LA388Accident · Minor injuriesLimited investigationFinal reportGreat Lakes 2T-1A-2 · Bloomington, ILThe plt reported that during takeoff, there was a loss of power at appx 100 ft AGL. He had lifted off before reaching the midpoint of the rwy. However, due to the climb attitude & configuration of the acft, he could not see the rwy below & thought he was at…NTSB CHI83FA387Accident · 2 fatalField investigationFinal reportAerotek Pitts S-2A · Waukegan, ILWhile on a local flt, the acft crashed in lake Michigan about 1/2 mi from the shoreline. According to witnesses, it was flying over the water at about 100 ft, then pulled almost straight up to about 300 ft above the water, nosed over & went almost straight…NTSB CHI83LA386Accident · No injuriesLimited investigationFinal reportCessna 182 · Joliet, ILAcft landed long & ran off the end of the rwy. The left tire blew prior to departing the rwy, & after departing the rwy the acft collided with an arpt warning sign. A 3,452 ft turf rwy, 4/22, was available.NTSB CHI83LA385Accident · No injuriesLimited investigationFinal reportCessna 150 · Savanna, ILThe plt reported the winds were from 160 deg at 7 KTS & that he back taxied on rwy 14 to takeoff. He reported that during the takeoff roll, he encountered a right x-wind, & when he was aprx 2/3 of the way down the rwy, the acft veered to the left. After…