NTSB investigations, IL

1,788 cases where the phase of flight was Landing.

Cases, newest first

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 550)
  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 CHI90LA016Accident · No injuriesLimited investigationFinal reportCessna 172 · New Lenox, ILFailure of the pilot to attain wind information, which resulted in his selection of an unfavorable (wrong) runway. A factor related to the accident was: the crosswind condition.Oct 16, 1989 · N4269F · Substantial damageNTSB CHI90LA008Accident · No injuriesLimited investigationFinal reportBeech C23 · Rock Falls, ILImproper flare by the pilot, which resulted in a hard landing.Oct 12, 1989 · N9157S · DestroyedNTSB CHI89LA197Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Lebanon, ILFailure of the pilot to use all available runway and his misjudgement of the available distance (runway length) for landing. Contributing factors were: inadequate preflight planning/preparation, and the runway and terrain conditions.Sep 28, 1989 · N1165X · Substantial damageNTSB CHI89LA195Accident · No injuriesLimited investigationFinal reportBeech 36 · Princeton, ILThe pilot had excessive airspeed, misjudged the landing distance, and did not go around. The high obstructions (trees),wet runway, ditch, and uneven terrain (roadway) were contributing factors.Sep 28, 1989 · N7818R · Substantial damageNTSB CHI89DEE06Accident · Minor injuriesFinal reportHowe Quickie Q2 · Lakeinthehills, ILThe pilot failed to maintain directional control of the airplane during a bounced landing. A factor related to the accident was the pilot's evasive maneuver to avoid rolling into a stone quarry.Sep 28, 1989 · N525LH · Substantial damageNTSB CHI89LA189Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Newark, ILThe pilot landed long and failed to make a go around.Sep 19, 1989 · N714XG · Substantial damageNTSB CHI89IA140Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-10-10 · Chicago, ILHydroplaning attributed to the physical condition of the runway, and the airport personnel's failure to adequately maintain the runway. Contributing factors were: the rain and the wet runway.Jul 19, 1989 · N1846U · No damageNTSB CHI89LA139Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Grayslake, ILThe pilot's improper flare and recovery from a bounced landing, and his failure to go around (when there was sufficient speed and runway remaining). A contributing factor was his lack of recent experience in type of aircraft.Jul 15, 1989 · N8301F · Substantial damageNTSB CHI89LA098Accident · No injuriesLimited investigationFinal reportCessna P210N · Wheeling, ILFailure of the pilot to extend the landing gear, which resulted in a wheels-up landing.May 30, 1989 · N4763P · Substantial damageNTSB CHI89FA092Accident · No injuriesField investigationFinal reportSwearingen SA226TC · Marion, ILFailure of the pilot to maintain directional control of the aircraft. Contributing to the accident was lack of crew coordination and inappropriate remedial action on the part of the aircrew, and improper maintenance modification by the operator.May 19, 1989 · N232AM · Substantial damageNTSB CHI89IA084Incident · No injuriesIncident investigationFinal reportFokker F-27 MK500 · Moline, ILMaterial failure of the landing gear retraction and extension assembly. Inadequate maintenance and troubleshooting procedures in company directives were factors in this incident.May 4, 1989 · N511AW · Minor damageNTSB CHI89LA081Accident · No injuriesLimited investigationFinal reportCessna 172D · Ottawa, ILStudent pilot's continuing an approach to landing beyond the point where she could bring the aircraft to a controlled stop on the remaining runway surface.Apr 25, 1989 · N98923 · Substantial damageNTSB CHI89LA077Accident · No injuriesLimited investigationFinal reportCessna 152 · Cahokia, ILInadequate compensation for wind conditions by the student pilot and his failure to maintain directional control. The crosswind and the student's lack of total experience were contributing factors.Apr 25, 1989 · N5498B · Substantial damageNTSB CHI89LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Chicago, ILThe pilot's failure to compensate for the crosswind condition which existed during the landing. Contributing to the accident was the gusty, crosswind which existed and the failure of the aircraft manufacturer to provide crosswind performance data for the…Apr 4, 1989 · N2944P · Substantial damageNTSB CHI89FA058Accident · No injuriesField investigationFinal reportCessna 177RG · Rockford, ILThe inadequate servicing of the hydraulic fluid by maintenance personnel and the pilot's failure to extend the landing gear manually.Mar 18, 1989 · N52634 · Substantial damageNTSB CHI89LA060Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILImproper flare by the pilot. The crosswind (quartering headwind) was considered to be a factor.Mar 12, 1989 · N3045M · Substantial damageNTSB CHI89LA056Accident · No injuriesLimited investigationFinal reportCessna TR182 II · Sandwich, ILThe pilot's poor handling of the aircraft, improper flare and inadequate recovery from a bounced landing.Mar 11, 1989 · N2096S · Substantial damageNTSB CHI89LA052Accident · No injuriesLimited investigationFinal reportCessna 172M · Quincy, ILThe pilot's failure to achieve a proper touchdown point and to maintain adequate visual lookout during the landing.Feb 18, 1989 · N6894H · Substantial damageNTSB CHI89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Plainfield, ILDec 30, 1988 · N8369Y · Substantial damageNTSB CHI89LA021Accident · No injuriesLimited investigationFinal reportCessna 170A · Springfield, ILThe conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement…Nov 2, 1988 · N5596C · Substantial damageNTSB CHI89LA019Accident · No injuriesLimited investigationFinal reportCessna 182 · Pekin, ILThe pilot reported that he attempted to make a 'wheels' landing in the Cessna 182 (tricycle gear), and made a hard landing on the turf runway. The pilot aborted the landing, requested emergency equipment and circled the airport until the emergency equipment…Oct 19, 1988 · N5711B · Substantial damageNTSB CHI89LA006Accident · No injuriesLimited investigationFinal reportBeech 55B · Quincy, ILThe pilot in command's failure to maintain control of the aircraft and to take appropriate action to correct the porpoise.Oct 9, 1988 · N8769R · Substantial damageNTSB CHI88LA228Accident · Minor injuriesLimited investigationFinal reportLake LA-4-200 · Fox Lake, ILThe plt had just completed a course at the Lake acft factory school, but had not yet obtained a seaplane rating. After he flew home, he landed on local lakes. He reported that drg a landing on calm water, he expected to hear a 'slush sound' as the hull…Sep 1, 1988 · N8012A · DestroyedNTSB CHI88LA208Accident · No injuriesLimited investigationFinal reportBeech C55 · Cahokia, ILWhile on a maintenance test hop after annual inspection, the pilot failed to insure that the landing gear was extended before touchdown. The pilot stated that the gear handle was placed in the gear down position, and that no gear warning horn sounded during…Aug 15, 1988 · N19RE · Substantial damageNTSB CHI88IA200Incident · No injuriesIncident investigationFinal reportAerospatiale ATR-42-300 · Chicago, ILAug 12, 1988 · N426MQ · No damageNTSB CHI88LA196Accident · No injuriesLimited investigationFinal reportCessna 320E · Springfield, ILDrg a night arrival, the plt failed to get a down & locked indcn for the nose gear. He made svrl low passes over the rwy for observation. Tower & fire/rescue personnel rprtd the nose gear appeared to be extended, so the plt made a normal landing. As the nose…Aug 8, 1988 · N222L · Substantial damageNTSB CHI88DEE08Accident · No injuriesFinal reportTownson Starduster SA100 · Monee, ILPilot failing to maintain control of the airplane during landing touchdown and roll out.Jul 31, 1988 · N9119R · Substantial damageNTSB CHI88LA175Accident · No injuriesLimited investigationFinal reportBeech 35R · Manito, ILDrg arrival, the plt experienced an electrical prblm with the landing gear & had to use manual extension procedures. He stated that when he selected the flaps for landing, he heard the motor run, but did not visually check that the flaps were extended. Just…Jul 26, 1988 · N3016V · Substantial damageNTSB CHI88IA165Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD80 · Chicago, ILJul 14, 1988 · N253A · No damageNTSB CHI88LA161Accident · No injuriesLimited investigationFinal reportCessna 170B · Rockford, ILJul 8, 1988 · N8048A · Substantial damageNTSB CHI88LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILWhile landing at the completion of his first solo cross country instructional flight, the student pilot landed long and was unable to stop before the end of the runway. The student pilot stated that he selected the sod runway instead of the 2,550' x 29'…Jun 19, 1988 · N49207 · Substantial damageNTSB CHI88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mattoon, ILUpon return from a local aerial photography flight, the pilot failed to ensure that the aircraft landing gear was extended, down and locked. When the aircraft touched down, the gear was only extended approximately 10%; it collapsed fully when it contacted the…Jun 16, 1988 · N8226P · Substantial damageNTSB CHI88LA122Accident · No injuriesLimited investigationFinal reportCessna 152 · Romeoville, ILMay 30, 1988 · N68312 · Substantial damageNTSB CHI88LA121Accident · No injuriesLimited investigationFinal reportCessna R172K · Aurora, ILThe pilot said that on final apch, 'a rapid descent took place.' The aircraft touched down on the rwy and bounced. The pilot said he added pwr and lowered the nose, but the nose gear and propeller hit the rwy. The acft bounced again and sustained substantial…May 29, 1988 · N736AF · Substantial damageNTSB CHI88LA100Accident · No injuriesLimited investigationFinal reportCessna 182D · Mt. Vernon, ILAfter electing to go-around on his first approach, the student pilot ballooned the aircraft as he passed over the runway on the second approach. Remedial action was attempted, but the pilot overcontrolled and the aircraft struck the runway slightly nosewheel…Apr 16, 1988 · N8891X · Substantial damageNTSB CHI88LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Salem, ILWhile attempting to land with a quartering tailwind, the student experienced a loss of directional control and elected to G0-around. On climbout he was unable to maintain the proper rate of climb, and once out of ground effect the aircraft started to descend.…Mar 26, 1988 · N96010 · Substantial damageNTSB CHI88LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Mendota, ILDuring the landing roll, in gusty, crosswind conditions the upwind wing of the aircraft lifted and the aircraft experienced a noseover.Mar 26, 1988 · N35407 · Substantial damageNTSB CHI88LA066Accident · No injuriesLimited investigationFinal reportCessna 150L · Springfield, ILThe aircraft experienced a hard landing followed by collapse of the nose gear. The student pilot stated that he bounced on his first attempt to land and the second touchdown was nose first which resulted in the collapse of the nose gear.Feb 21, 1988 · N18225 · Substantial damageNTSB CHI88IA061Incident · No injuriesIncident investigationFinal reportDouglas DC-10 · Chicago, ILJudgemental error on the part of the local controller for clearing vehicles across the active runway tiwh insufficient separation from arriving aircraft, which was further compromised by a mechanical malfunction in the equipment crossing the runway.Feb 11, 1988 · N123AA · No damageNTSB CHI88LA057Accident · No injuriesLimited investigationFinal reportCessna 421A · Wheeling, ILFeb 3, 1988 · N421Q · Substantial damageNTSB CHI88LA034Accident · No injuriesLimited investigationFinal reportCessna 172K · Staunton, ILDuring the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot…Dec 22, 1987 · N78705 · Substantial damageNTSB CHI88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, ILThe plt returned to the arpt after dark & noted there was an excessive x-wind for the active rwy. He elected to land on the unlighted grass rwy (rwy 14) which was aligned more favorably with the wind. He thought that on final apch, he had aligned the acft…Dec 6, 1987 · N757KW · Substantial damageNTSB CHI88LA030Accident · Minor injuriesLimited investigationFinal reportCessna 337 · Kankakee, ILThe pilot was attempting to land on runway 22 at an uncontrolled airport when he heard another pilot transmit he was about to depart from the same runway. According to the pilot, while he was turning on to final approach, he observed an aircraft taxiing to…Nov 21, 1987 · N6255F · Substantial damageNTSB CHI88DEE01Accident · No injuriesFinal reportAlexander Volksplane VP-1 · Dekalb, ILThe plt had little experience flying tailwheel equipped acft & had only 10 hrs flt time in this make & model. During arrival, he landed on rwy 27 with a quartering left x-wind that was gusting to 20 KTS. Just before touchdown, a gust of wind caused the acft…Nov 12, 1987 · N99VP · Substantial damageNTSB CHI88LA022Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Decatur, ILThe aircraft experienced a landing with the gear retracted. The pilot stated that he perceived the yellow light indication for the landing gear to mean 'down', instead of looking for a green light.Nov 10, 1987 · N7865Y · Substantial damageNTSB CHI88LA016Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Union, ILThe glider was approaching to land when, according to the pilot, he noticed the aircraft was descending 'too fast' and his airspeed was 'too slow'. The pilot then realized he wasn't going to make the runway and decided to land the glider in a nearby field.…Oct 25, 1987 · N1219S · Substantial damageNTSB CHI87LA226Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Frankfort, ILThe student plt was on a flt with 2 pax aboard. He rprtd that drg a ngt lndg, the acft bounced & ballooned. He added pwr to fly the acft back down to the rwy, but it bounced & ballooned again. By this time, the acft was about halfway down the rwy.…Sep 27, 1987 · N5196K · Substantial damageNTSB CHI87LA223Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Joliet, ILThe aircraft landed on what the pilot thought was a runway. He stated that on short final the aircraft floated before touching down and consequently there was not enough room to make a go-around. After touchdown, he braked hard and the aircraft swerved left…Sep 27, 1987 · N6320A · Substantial damageNTSB CHI87LA220Accident · No injuriesLimited investigationFinal reportCessna 172RG · Pinckneyville, ILAccording to the instructor (CFI), he & the student confirmed the gear was extended & locked as they entered the traffic pattern. Flaps were extended & they contd in the pattern to practice a short field landing technique. Power was reduced after crossing…Sep 20, 1987 · N9543B · Substantial damageNTSB CHI87LA218Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grayslake, ILThe aircraft landed off the right side of the runway on a dark night when the pilot was unable to identify the intended landing runway. The aircraft landed in soft turf and during subsequent loss of control, turned right and nosed down into a ravine. The…Sep 20, 1987 · N8315S · Substantial damage