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 CHI03LA283Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Deer Grove, ILThe pilot's failure to attain the proper touchdown point, and his failure to execute a go-around.Aug 25, 2003 · N5360B · Substantial damageNTSB CHI03LA209Accident · No injuriesLimited investigationFinal reportYoung Cozy MkIV · Quincy, ILThe pilot's improper flare.Aug 22, 2003 · N96PJ · Substantial damageNTSB CHI03LA328Accident · No injuriesLimited investigationFinal reportLet L-13 Blanik · Highland, ILThe pilot's failure to extend the spoilers and his inadvertent use of the flaps during final approach, which resulted in the proper touchdown point being exceeded due to excessive airspeed. A factor to the accident was the dirt mound.Aug 16, 2003 · N302SL · Substantial damageNTSB CHI03LA260Accident · No injuriesLimited investigationFinal reportCessna 172L · Harvard, ILThe pilot's improper flare which led to a hard landing.Aug 14, 2003 · N7054Q · Substantial damageNTSB CHI03LA258Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Litchfield, ILAn animal wandered onto the runway and collided with the airplane. A factor was the night light condition.Aug 10, 2003 · N3258W · Substantial damageNTSB CHI03LA240Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28C · Kankakee, ILThe pilot misjudged flare which led to a hard landing. Contributing to the accident was the pilot's failure to follow procedures/directives when he exceeded the airplane's weight and balance.Aug 2, 2003 · N15SA · Substantial damageNTSB CHI03LA212Accident · No injuriesLimited investigationFinal reportCessna 172P · Pinckneyville, ILThe planned approach not maintained by the pilot and the delayed remedial action by the certified flight instructor. A contributing factor to the accident was the approach light.Jul 14, 2003 · N98395 · Substantial damageNTSB CHI03LA196Accident · No injuriesLimited investigationFinal reportBell 206B3 · Lansing, ILThe dynamic rollover encountered by the pilot. Factors were the inadequate remedial action by the pilot due to his failure to prevent the rollover, and the inadequate facility with regard to the design of the landing platform.Jul 2, 2003 · N52L · Substantial damageNTSB CHI03LA167Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Atwood, ILThe pilot's selection of an unsuitable landing area and his improper decision to continue the approach without the airport and runway clearly in-sight. Factors contributing to the accident were the pilot's disorientation, the transmission wires, and the road…Jun 18, 2003 · N94327 · Substantial damageNTSB CHI03LA143Accident · No injuriesLimited investigationFinal reportMooney M20S · West Chicago, ILThe pilot's improper flare, and the pilot's failure to maintain directional control. Contributing factors were the pilot's improper flare and his inadequate recovery from a bounced landing.Jun 2, 2003 · N21737 · Substantial damageNTSB CHI03LA146Accident · No injuriesLimited investigationFinal reportGlasflugel Libelle 201B · Hampshire, ILThe unsuitable terrain encountered by the pilot during the off airport landing. A factor was the rock.May 24, 2003 · N3650 · Substantial damageNTSB CHI03LA115Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Romeoville, ILThe pilot not maintaining directional control during the landing rollout. A factor to the accident was the gusting crosswind.Apr 27, 2003 · N97930 · Substantial damageNTSB CHI03LA114Accident · No injuriesLimited investigationFinal reportCessna 182T · Marengo, ILThe pilot's improper flare. A factor contributing to the accident was the gusty crosswind.Apr 25, 2003 · N35291 · Substantial damageNTSB CHI03LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Carbondale, ILThe pilot failed to properly recover from a bounced landing which resulted in the airplane porpoising.Apr 11, 2003 · N6317D · Substantial damageNTSB CHI03LA102Accident · No injuriesLimited investigationFinal reportCessna 172S · Grayslake, ILThe flight instuctor's improper in-flight decision to land with a tailwind and failure to maintain directional control of the airplane during landing. Factors contributing to the accident were the tailwind, the student pilot's inadequate flare, and the muddy…Apr 11, 2003 · N389SP · Substantial damageNTSB CHI03LA085Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · West Chicago, ILThe pilot's improper flare resulting in a hard landing.Mar 19, 2003 · N930DE · Substantial damageNTSB CHI03LA091Accident · No injuriesLimited investigationFinal reportAviat A-1 · Cahokia, ILThe pilot’s inadequate compensation for wind and his failure to maintain directional control of the airplane which resulted in a ground loop. A factor associated with the accident was the gusty crosswind condition.Mar 8, 2003 · N96033 · Substantial damageNTSB CHI03LA077Accident · No injuriesLimited investigationFinal reportSwearingen SA-26AT · Cahokia, ILThe pilot failed to maintain directional control of the airplane during landing. Factors associated with the accident were the snow covered runway, the crosswind, and the overload failure of the nose gear.Feb 16, 2003 · N30TF · Substantial damageNTSB CHI03IA070Incident · No injuriesIncident investigationFinal reportCanadair CRJ-600 · Bloomington, ILThe pilot's improper in-flight decision to land on a runway with a tailwind component that exceeded the airplane's tailwind limitation and his failure to perform a go-around which resulted in the proper touchdown point not being attained and the airplane…Feb 15, 2003 · N653BR · Minor damageNTSB CHI03LA001Accident · No injuriesLimited investigationFinal reportMooney M20J · Chicago, ILThe pilot's inadequate compensation for wind, and his failure to maintain directional control.Oct 1, 2002 · N22RJ · Substantial damageNTSB CHI02LA251Accident · No injuriesLimited investigationFinal reportCessna 210L · Lacon, ILThe pilot's improper in-flight decision to perform an intentional gear-up precautionary landing instead of continuing to the next available airport. A factor to the accident was the corn crop.Aug 10, 2002 · N3UF · Substantial damageNTSB CHI02LA249Accident · Minor injuriesLimited investigationFinal reportGoode Acro Sport I · Carbondale, ILThe unsuitable landing area selected by the pilot and his lack of total experience in the accident airplane. The gusting winds were a contributing factor.Aug 7, 2002 · N65701 · Substantial damageNTSB CHI02LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Belleville, ILDirectional control not obtained/maintained by the pilot during landing.Aug 1, 2002 · N8137S · Substantial damageNTSB CHI02CA250Accident · No injuriesData collectionFinal reportPiper PA-J3-C65 · Sparta, ILThe CFI's failure to maintain directional control during landing roll and the unsuccessful attempt at a go around. A factor was the ditch.Jul 9, 2002 · N7744B · Substantial damageNTSB CHI02CA196Accident · No injuriesData collectionFinal reportGrenier Acro Sport · Jacksonville, ILThe probable cause of this accident is a failure of the left main landing gear attachment bolt and the subsequent collapse of the left main landing gear. Repeated hard landings was a factor and a lack of recent experience were contributing factors.Jun 30, 2002 · N1419 · Substantial damageNTSB CHI02LA126Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Sandwich, ILThe driver of the automobile improperly drove his automobile on the active runway and did not maintain visual lookout for landing aircraft.May 10, 2002 · N276U · Substantial damageNTSB CHI04LA124Accident · No injuriesLimited investigationFinal reportBeech 58 · Lansing, ILThe flight crew's failure to follow the checklist resulting in a landing without the landing gear extended.May 1, 2002 · N4097S · Substantial damageNTSB CHI02LA119Accident · No injuriesLimited investigationFinal reportCessna 560 · Lake In The Hil, ILThe flightcrew's delay in executing a go-around..Apr 25, 2002 · N560RP · Substantial damageNTSB CHI02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Manito, ILThe pilot's improper planning and decision and his failure to maintain adequate airspeed, which resulted in a stall and hard landing. The gusting crosswind conditions were a contributing factor.Feb 9, 2002 · N7025A · Substantial damageNTSB CHI02LA022Accident · No injuriesLimited investigationFinal reportSmith Aerostar 601 · Danville, ILThe separation of the main landing gear scissor assembly during landing for undetermined reasons, resulting in the directional control of the airplane not being possible.Nov 8, 2001 · N128AC · Substantial damageNTSB CHI02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Decatur, ILThe excessive braking performed by the flight instructor.Nov 5, 2001 · N4576H · Substantial damageNTSB CHI02LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Peoria, ILThe gear collapse for undetermined reasons during the landing roll. A factor was the pilot not using a proper touchdown point by landing long.Nov 2, 2001 · N5984V · Substantial damageNTSB CHI02LA016Accident · No injuriesLimited investigationFinal reportCessna T210M · Salem, ILThe ruptured hydraulic hose.Oct 30, 2001 · N761UV · Substantial damageNTSB CHI01LA321Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Carbondale, ILThe pilot misjudged the proper alignment with the landing area. Contributing to the accident was the light conditions.Sep 23, 2001 · N47964 · Substantial damageNTSB CHI01LA282Accident · No injuriesLimited investigationFinal reportHoskins Quickie Q2 · Carbondale, ILThe failure of the tailwheel spring. A factor was the directional control not possible by the pilot.Aug 22, 2001 · N202SH · Substantial damageNTSB CHI01LA272Accident · No injuriesLimited investigationFinal reportCessna 152 · Peru, ILThe pilot's inadequate recovery from a bounced landing. Factors associated with the accident were improper touchdown point, rough terrain, and the nose gear collapse.Aug 9, 2001 · N6182R · Substantial damageNTSB CHI01LA205Accident · No injuriesLimited investigationFinal reportCessna 172S · Lake in the Hil, ILThe student pilot misjudging the flare during that landing. Factors were the wrong runway selected by the student pilot, the tailwinds encountered during that landing and the flight instructor's inadequate supervision during that landing.Jul 11, 2001 · N795SP · Substantial damageNTSB CHI01LA308Accident · No injuriesLimited investigationFinal reportCessna 182K · Mattoon, ILThe pilot improperly flared the airplane which resulted in a hard landing.Jul 5, 2001 · N2501Q · Substantial damageNTSB CHI01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Morris, ILthe directional control not maintained by the pilot. The crosswind was a contributing factor.Jun 16, 2001 · N3526Z · Substantial damageNTSB CHI01LA168Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · HIghland, ILThe pilot's failure to extend the spoilers during landing approach, which resulted in a touchdown at a higher than normal airspeed. An additional cause was the intentional ground loop/swerve maneuver performed by the pilot to avoid overrunning the end of the…Jun 16, 2001 · N76SP · Substantial damageNTSB CHI01LA316Accident · No injuriesLimited investigationFinal reportCessna 172R · Alton, ILThe misjudged flare by the pilot.May 19, 2001 · N9532K · Substantial damageNTSB CHI01LA133Accident · No injuriesLimited investigationFinal reportCessna 172M · West Chicago, ILThe inadequate compensation for the crosswind by the student pilot. Additional factors included the student pilot's lack of total flight time, the runway sign and the crosswind.May 9, 2001 · N13474 · Substantial damageNTSB CHI01FA084Accident · Minor injuriesField investigationFinal reportBeech 1900D · Chicago, ILThe flightcrew not lowering the landing gear and/or verifying the landing gear position as required by three separate checklists, which resulted in an inadvertent gear-up landing. A factor to the accident was the flightcrew not complying with the required…Feb 10, 2001 · N97UX · Substantial damageNTSB CHI01LA079Accident · No injuriesLimited investigationFinal reportCessna 310R · Cahokia, ILThe collapse of the left main landing gear during landing roll for undetermined reasons.Feb 2, 2001 · N4249C · Substantial damageNTSB CHI01LA007Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Highland, ILthe designated examiner not maintaining clearance from the bank/dike. Factors were the designated examiner's delayed remedial action and the bank/dike.Oct 11, 2000 · N2060T · Substantial damageNTSB CHI00LA309Accident · No injuriesLimited investigationFinal reportCessna 172P · Wheeling, ILThe student pilot's inadequate compensation for the crosswind that resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind, the ditch, the student's lack of experience, and the poor…Sep 26, 2000 · N98629 · Substantial damageNTSB CHI00LA299Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Morris, ILThe improper servicing of the left main landing gear tire which resulted in it having low air pressure and the pilot's inability to maintain directional control on landing. A factor associated with the accident was the ditch.Sep 16, 2000 · N33036 · Substantial damageNTSB CHI00LA287Accident · No injuriesLimited investigationFinal reportCessna 172R · New Lenox, ILThe pilot's failure to maintain directional control during landing. Factors to the accident were the pipe that was struck, the crosswind, and the pilot's runway selection.Aug 29, 2000 · N364SA · Substantial damageNTSB CHI00LA275Accident · No injuriesLimited investigationFinal reportFlurry Aventura II · Benton, ILthe pilot's inadvertent wheel down landing in water.Aug 28, 2000 · N106DF · Substantial damageNTSB CHI00LA250Accident · Serious injuriesLimited investigationFinal reportBell 206B · Marengo, ILthe simulated autorotation performed by the pilot at too low an altitude and airspeed.Aug 4, 2000 · N7JR · Substantial damage