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 CHI96LA311Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Cambridge, ILThe pilot's failure to maintain control of the airplane while landing. A factor associated with the accident was the downdraft reported by the pilot.Aug 21, 1996 · N3607H · Substantial damageNTSB CHI96LA302Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenwood, ILthe pilot's failure to obtain a proper touchdown point.Aug 17, 1996 · N6218F · Substantial damageNTSB CHI96LA246Accident · Minor injuriesLimited investigationFinal reportElliot Steen Skybolt · Belleville, ILthe inadequate weld on the landing gear by the builder/pilot.Jul 24, 1996 · N596E · Substantial damageNTSB CHI96LA214Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Union, ILThe pilots misjudgment of the altitude and distance to the runway.Jun 23, 1996 · N12195 · Substantial damageNTSB CHI96TA160Accident · No injuriesFinal reportCessna 182 · Jacksonville, ILthe pilot's improper compensation for the crosswind condition. A factor in the accident was the crosswind conditions which existed.May 17, 1996 · N661SP · Substantial damageNTSB CHI96LA140Accident · No injuriesLimited investigationFinal reportCessna 172 · Dekalb, ILThe flight instructor's inadequate supervision, and his delay in taking remedial action to regain directional control of the airplane. Factors relating to the accident were: the student's improper flare for landing, improper recovery from a bounced landing,…Apr 21, 1996 · N6542J · Substantial damageNTSB CHI96LA122Accident · No injuriesLimited investigationFinal reportCessna 210K · West Chicago, ILMaintenance personnel's failure to comply with an airworthiness directive on the landing gear which led to a retraction/extension assembly malfunction.Apr 1, 1996 · N9470M · Substantial damageNTSB CHI96LA098Accident · No injuriesLimited investigationFinal reportCessna 152 · Jacksonville, ILFailure of the student pilot to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. A factor relating to the accident was: the crosswind condition.Feb 24, 1996 · N6325Q · Substantial damageNTSB CHI96LA097Accident · No injuriesLimited investigationFinal reportCessna 172P · West Chicago, ILthe student pilot's misjudging the flare. A factor was the gusts.Feb 24, 1996 · N99341 · Substantial damageNTSB CHI96LA089Accident · No injuriesLimited investigationFinal reportCessna 210 · Shelbyville, ILthe pilot's misjudged flare and improper recovery from a bounced landing. Factors relating to the accident were: the pilot's improper use of procedure by wearing unapproved correcting lenses, and his resultant decreased depth perception.Feb 15, 1996 · N9614X · Substantial damageNTSB CHI96LA063Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wheeling, ILthe pilot's misjudgment of the landing flare.Dec 24, 1995 · N8162S · Substantial damageNTSB CHI96LA036Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Lacon, ILwas the compensation for wind conditions inadequate and aircraft control not maintained. A factor was directional control inadequately maintained.Nov 21, 1995 · N714QH · Substantial damageNTSB CHI95LA270Accident · Minor injuriesLimited investigationFinal reportBell 47 · Arlington Hts, ILplot misjudged the flare. The factors included the pilot getting too close to the lead helicopter, allowing his airspeed to get too slow, and encountering settling with power.Aug 12, 1995 · N4032G · Substantial damageNTSB CHI95LA210Accident · No injuriesLimited investigationFinal reportBeech 76 · Wheeling, ILthe dual student's inadequate compensation for the wind conditions, and the CFI's inadequate supervision of the flight. A factor associated with the accident was the gusty crosswind condition.Jul 6, 1995 · N60078 · Substantial damageNTSB CHI95LA192Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Peru, ILthe pilot's failure to maintain directional control of the airplane while landing. A factor in the accident was the runway light.Jun 17, 1995 · N21873 · Substantial damageNTSB CHI95LA179Accident · No injuriesLimited investigationFinal reportCessna T210M · Downers Grove, ILthe pilot's failure to attain the proper touchdown point, and his subsequent failure to execute a go-around.Jun 13, 1995 · N112YM · Substantial damageNTSB CHI95LA140Accident · No injuriesLimited investigationFinal reportCessna 152 · West Chicago, ILThe pilot's failure to maintain directional control. A factor was the crosswind.May 1, 1995 · N47331 · Substantial damageNTSB CHI95LA131Accident · No injuriesLimited investigationFinal reportPiper PA-22-20-108 · Kankakee, ILThe pilot's inadequate recovery from a bounced landing.Apr 2, 1995 · N4917Z · Substantial damageNTSB CHI95LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rochelle, ILthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the student pilot's improper use of the brakes.Nov 11, 1994 · N32196 · Substantial damageNTSB CHI95LA015Accident · No injuriesLimited investigationFinal reportQuestair Venture · Wheeling, ILThe inadvertent deployment of the nosewheel steering. A factor in this accident was the inadequate design of the rudder pedal pivot point height above the cockpit floor by the design personnel.Oct 18, 1994 · N62V · Substantial damageNTSB CHI95LA009Accident · No injuriesLimited investigationFinal reportCessna 152 · Bloomington, ILThe pilot's failure to maintain aircraft control while landing. Factors associated with the accident were the improper landing flare and the pilot's lack of total experience.Oct 10, 1994 · N69187 · Substantial damageNTSB CHI94MA290Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11F · Chicago, ILThe first officer's improper flare and improper use of flight controls during the landing flare/touchdown.Aug 19, 1994 · IDUPO · Substantial damageNTSB CHI94LA231Accident · No injuriesLimited investigationFinal reportCessna 150 · Alton, ILthe student pilot's improper recovery from a bounced landing. A factor associated with the accident is the student pilot's misjudged landing flare.Jul 17, 1994 · N3639V · Substantial damageNTSB CHI94LA284Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX7-77 · West Chicago, ILthe pilot's failure to maintain proper descent rate.Jun 25, 1994 · N21WR · No damageNTSB CHI94LA194Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Peoria, ILthe pilot's misjudged landing flare. A factor associated with the accident is the pilot allowing the airplane to descend at an excessive rate.Jun 9, 1994 · N72009 · Substantial damageNTSB CHI94LA186Accident · No injuriesLimited investigationFinal reportHawker Siddeley DH-125-3A · Waukegan, ILwas the pilot-in-command disregarding the location of the flight manifest container in the cockpit. Factor's associated with the accident were a jammed control column and inadequate procedures for the use and storage of the flight manifest container on the…May 30, 1994 · N900CD · Substantial damageNTSB CHI94LA150Accident · No injuriesLimited investigationFinal reportBoeing B75-N1 · Sandwich, ILthe pilot in command's failure to maintain directional control during a crosswind landing and attempted go around.May 8, 1994 · N68135 · Substantial damageNTSB CHI94LA122Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILthe pilot's inadequate compensation for wind conditions. A factor associated with the accident was the crosswind.Mar 23, 1994 · N97650 · Substantial damageNTSB CHI94LA115Accident · No injuriesLimited investigationFinal reportCessna 152 · Wheeling, ILthe student pilot's improper recovery from a bounced landing.Mar 17, 1994 · N2MS · Substantial damageNTSB CHI94LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sandwich, ILthe private pilot's failure to maintain directional control of the airplane while landing on a snow and ice covered runway. Factors are the snow on the runway and the snowbank.Feb 14, 1994 · N76SA · Substantial damageNTSB CHI94IA081Incident · No injuriesIncident investigationFinal reportBoeing 737-130 · Chicago, ILAn inadequate procedure for handling of wheel chocks by company maintenance and operations personnel. Factors associated with this accident were an inadequate inspection of the airplane by company maintenance personnel, and an inadequate pre-flight inspection…Feb 10, 1994 · N408PE · Minor damageNTSB CHI93LA377Accident · No injuriesLimited investigationFinal reportLanceair 235M · Rockford, ILThe pilot-in-command delayed aborting the landing. Factors were a wet runway and the pilot-in-command's lack of recent experience in this type of airplane.Sep 22, 1993 · N12TN · Substantial damageNTSB CHI93LA370Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Lenox, ILSelection of the wrong runway by the pilot after misreading the wind sock. The resultant tailwind was a related factor.Sep 19, 1993 · N8753E · Substantial damageNTSB CHI93LA358Accident · No injuriesLimited investigationFinal reportCessna 140 · Trenton, ILFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and subsequent nose over of the airplane.Sep 5, 1993 · N89467 · Substantial damageNTSB CHI93LA320Accident · Minor injuriesLimited investigationFinal reportBell 47-G5 · Schaumburg, ILthe pilot's improper autorotation techniques.Aug 12, 1993 · N1347X · Substantial damageNTSB CHI93DEV01Accident · 1 fatalFinal reportWalter D. Courtney Courtney TWO · Canton, ILthe pilot's failure to maintain control of the airplane during final approach to landing.Aug 8, 1993 · N78WC · Substantial damageNTSB CHI93LA227Accident · No injuriesLimited investigationFinal reportCessna 182L · Aurora, ILThe disconnected nose gear upper torque link (landing gear steering). Directional control not possible was a factor.Jun 27, 1993 · N3119R · Substantial damageNTSB CHI93LA214Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Galesburg, ILThe departing pilot's (N251NW) inadequate visual lookout while operating in VFR conditions at an uncontrolled airport. Factors related to the accident were: the departing pilot's diverted attention, and the arriving pilot's (N2632U) inadequate visual lookout.Jun 18, 1993 · N2632U · 2 aircraft · Substantial damageNTSB CHI93LA198Accident · Serious injuriesLimited investigationFinal reportBeech 200 · Wonder Lake, ILThe failure of the pilot of the Beech 200, N210PH, to maintain sufficient runway alignment to prevent the airplane from departing the runway.Jun 10, 1993 · N210PH · 2 aircraft · Substantial damageNTSB CHI93LA183Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Flora, ILthe delayed remedial action by the flight instructor. A factor related to the accident was the lack of total experience in this type operation by the flight instructor.May 27, 1993 · N714AN · Substantial damageNTSB CHI93LA172Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · West Chicago, ILThe pilot-in-command's inadequate compensation for the wind conditions he encountered during the landing approach and touchdown and not maintaining a proper descent rateMay 14, 1993 · N2947E · Substantial damageNTSB CHI93IA110Incident · No injuriesIncident investigationFinal reportFokker 100 · Chicago, ILFailure of the company station manager to follow proper dispatch procedures, and ice accumulation on the nose gear locking mechanism. Factors related to the incident were: wet snow (slush) on the runway at the departure airport, and inadequate design which…Mar 13, 1993 · N895US · Minor damageNTSB CHI93LA076Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Streator, ILThe pilot's failure to perform a go-around. The tailwind and the pilot's selection of the downwind runway were factor.Jan 23, 1993 · N2248X · Substantial damageNTSB CHI93LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake In The Hls, ILThe student pilot's failure to maintain directional control.Dec 26, 1992 · N4328D · Substantial damageNTSB CHI93LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Kankakee, ILThe pilot-in-command not obtaining directional control prior to landing touch down in a crosswind condition.Nov 14, 1992 · N2836C · Substantial damageNTSB CHI92LA288Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Belvidere, ILThe pilot's failure to maintain adequate clearance from obstacles during the aborted landing. Related factors are the failure to maintain directional control, and the pilot's lack of total experience in the type of operation.Sep 23, 1992 · N1943H · Substantial damageNTSB CHI92LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Peoria, ILThe private pilot's misjudged touchdown. Related factors are the reduced visibility due to sunglare, ongoing runway construction, and the pilot's inattention to atc/communications/information.Sep 23, 1992 · N2484Y · Substantial damageNTSB CHI92LA286Accident · No injuriesLimited investigationFinal reportCessna 210C · Peoria, ILThe pilot-in-command's not compensating for wind conditions and his not maintaining directional control.Sep 10, 1992 · N3683Y · Substantial damageNTSB CHI92LA272Accident · No injuriesLimited investigationFinal reportBoeing A-75 · Ottawa, ILThe pilot-in-command's failure to adequately compensate for wind conditions, and his not maintaining directional control. Factors were the crosswind and wind gusts.Sep 10, 1992 · N55410 · Substantial damageNTSB CHI92LA268Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Harvard, ILFailure of the pilot in command to align the accident airplane with the centerline of the runway during landing.Sep 8, 1992 · N5029Z · Substantial damage