NTSB investigations, IL

60 cases where the first occurrence was “Overrun”.

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'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 340)
  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.

NTSB CHI83LA285Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Lockport, ILPlt stated a company acft landed 2-5 min ahead of him on rwy 9 with light winds out of the east. Prior to pattern entry the plt noticed dark clouds to the west with rain. After landing he could not stop the acft & went off the end of the rwy. The acft…Jun 29, 1983 · N181AA · Substantial damageNTSB CHI83LA217Accident · No injuriesLimited investigationFinal reportCessna 172 · Mchenry, ILThe acft went off the departure end of runway 09 during landing and nosed over. The weather as reported by the operator,was scattered clouds, more than 5 miles visibility and winds calm. Runway 09 had been in use all day. The pilot stated that his approach…May 13, 1983 · N53242 · Substantial damageNTSB CHI83LA145Accident · No injuriesLimited investigationFinal reportCessna 152 · Mt. Carmel, ILThe plt stated he landed downwind, the approach was high & fast & when the acft landed there was only 800 ft of rwy remaining. The plt could not stop the acft before it ran off the end of the rwy & nosed over in a plowed field. The plt is blind in one eye &…Mar 17, 1983 · N5119Q · Substantial damageNTSB CHI83LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Vernon, ILThe aircraft ran off the end of a runway and collided with a ditch. The student pilot on his first solo cross country had become disoriented and landed 95 miles off course. He had been flying 2 hours and 30 minutes. He was supposed to reach enroute stop after…Feb 10, 1983 · N8222W · Substantial damageNTSB CHI83LA009Accident · No injuriesLimited investigationFinal reportCessna 150M · Lawsing, ILOn landing roll the student pilot inadvertently added power, ran off the end of the runway and into a ditch.Oct 5, 1982 · N63627 · Substantial damageNTSB CHI83FA007Accident · Serious injuriesField investigationFinal reportCessna T210L · Lansing, ILThe pilot cut short a cross-country flight because of weather, and during a down-wind landing, the aircraft overran runway 36. The aircraft was landed fast about 1600 ft down the 2500 foot runway, went off the end and ran into a deep ditch. The wind was from…Oct 5, 1982 · N2546S · Substantial damageNTSB CHI82DA330Accident · No injuriesFinal reportCessna 172 · Winchester, ILThe pilot elected to land on a 1600 ft grass strip with a crosswind of about 5 KTS. He reported that he crossed the fence at about 60 KTS with 15 deg of flaps, then touched down about 400 ft down the runway. During the landing roll, he saw he would be unable…Aug 28, 1982 · N22552 · Substantial damageNTSB 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…Jul 24, 1982 · N4970Q · DestroyedNTSB 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…May 29, 1982 · N129H · Substantial damageNTSB 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…Mar 27, 1982 · N7452M · Destroyed