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.
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" DESCRun 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 CHI08CA281Accident · Serious injuriesData collectionFinal reportFirefly Balloons 8B-15 · Springfield, ILThe failure of the passenger to follow the pilot's instructions by not steadying herself during the landing.NTSB CHI08LA273Accident · No injuriesLimited investigationFinal reportBeech C23 · Grayslake, ILThe inadequate flare by the student pilot and the inadequate supervision and delayed go-around performed by the flight instructor. Contributing to the accident were the student pilot's failure to attain/maintain a stabilized approach.NTSB CHI08CA247Accident · No injuriesData collectionFinal reportBellanca 17-30A · Waukegan, ILThe pilot's inability to maintain directional control of the airplane following a failure of the right brake.NTSB CHI08CA234Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Lawrenceville, ILThe pilot's misjudged application of the brakes during landing.NTSB CHI08CA184Accident · No injuriesData collectionFinal reportHuebner RV6-A · Jerseyville, ILThe muddy, unsuitable terrain encountered during the landing.NTSB CHI08CA181Accident · No injuriesData collectionFinal reportBeech C23 · Schaumburg, ILThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control during landing. Contributing to the accident were the gusting crosswind, and the embankment.NTSB CHI08CA187Accident · No injuriesData collectionFinal reportPiper J3C-65 · Lake In The Hil, ILThe directional control not maintained/obtained by the pilot during landing.NTSB CHI08CA179Accident · No injuriesData collectionFinal reportCessna 195 · Lansing, ILThe pilot's inadequate compensation for the gusting crosswind condition during landing. Contributing to the accident was the strong gusting crosswind condition.NTSB CHI08CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Naperville, ILThe pilot's failure to execute a go-around. Contributing to the accident was the pilot's excessive airspeed during touchdown, which resulted in the runway overrun.NTSB CHI08CA090Accident · No injuriesData collectionFinal reportCessna 172 · Apple River, ILThe pilot's inadequate compensation for wind conditions, and his failure to obtain/maintain directional control. Contributing factors were a crosswind and a snow bank.NTSB CHI08LA070Accident · No injuriesLimited investigationFinal reportBeech 58 · Cahokia, ILMaintenance personnel's improper replacement of the landing gear leg brace assembly which subsequently failed to keep the landing gear in the locked position.NTSB CHI08CA038Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plato Center, ILThe excessive airspeed used by the pilot which resulted in an overrun, impact with a ditch and subsequent nose over. The ditch was a factor.NTSB CHI08IA026Incident · Minor injuriesIncident investigationFinal reportAirbus Industrie A320-232 · Chicago, ILThe misrouted and reversed antiskid wiring by vendor maintenance personnel leading to the runway excursion. Contributing to the incident were the runway sign, the vendor's maintenance personnel not understanding the entire maintenance procedures in the dual…NTSB CHI07CA242Accident · No injuriesData collectionFinal reportMarcellus Starduster SA-300 · Columbia, ILThe pilot's improper flare, which resulted in a hard landing and subsequent left main landing gear collapse.NTSB CHI07CA200Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lake in the Hil, ILThe pilot's failure to achieve a proper touchdown point and delayed decision to abort the landing. Factors contributing to the accident include the chain link fence and the trees.NTSB CHI07CA171Accident · No injuriesData collectionFinal reportLuscombe 8A · Columbia, ILThe pilot's failure to maintain directional control of the airplane, causing a ground loop, subsequent runway excursion, and left main gear collapse. Factors in the accident include the ground loop encountered and the depression.NTSB CHI07CA153Accident · No injuriesData collectionFinal reportCessna 182S · Harvard, ILThe pilot's misjudged flare and improper recovery from a bounced landing, which caused the nose gear to collapse and subsequent damage to the propellor and underside of the airplane.NTSB CHI07CA128Accident · No injuriesData collectionFinal reportCessna 172P · West Chicago, ILThe instructor's inadequate remedial action following the student pilot's loss of control during the crosswind landing and the instructor's failure to compensate for the wind conditions. Contributing factors were, the crosswind, the gusting wind conditions…NTSB CHI07CA082Accident · No injuriesData collectionFinal reportCessna 172N · Pinckneyville, ILPresence of a deer on the runway resulting in an inadvertent collision during the landing roll.NTSB CHI07CA054Accident · No injuriesData collectionFinal reportCessna 172S · Alton, ILThe student pilot's inadequate recovery from a bounced landing, which resulted in the airplane impacting a runway sign. A factor in the accident was the student pilot's misjudged landing flare.NTSB CHI07CA028Accident · No injuriesData collectionFinal reportCessna 421C · Moline, ILThe incorrect installation of the torque link scissor assembly by maintenance personnel, which resulted in the collapse of the right main landing gear during landing.NTSB CHI06CA252Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Hampshire, ILThe pilot's inadequate approach for landing and his failure to attain a proper descent rate.NTSB CHI06CA214Accident · No injuriesData collectionFinal reportRobinson R-44 · Wadsworth, ILThe pilot inadvertently pulled back on the cyclic when birds flew into the windscreen. A factor associated with the accident were the birds.NTSB CHI06CA227Accident · No injuriesData collectionFinal reportCessna 172M · Cahokia, ILThe pilot's inadequate flare. A factor was the night light conditions.NTSB CHI06CA185Accident · Minor injuriesData collectionFinal reportCessna 172K · Sullivan, ILThe pilot's misjudged flare and his improper recovery from the bounced landing which led to a loss of directional control and subsequent collision with crops and the ground.NTSB CHI06LA278Accident · No injuriesLimited investigationFinal reportPiper PA-18A-150 · Lawrenceville, ILThe visual separation from the glider attempted by the tow pilot and traffic advisories from the glider not received by the tow pilot. The airport sign/marker was a contributing factor.NTSB CHI06CA129Accident · No injuriesData collectionFinal reportPiper PA-30 · Dongola, ILThe pilot's intentional maneuver to avoid obstructions at the end of the runway which resulted in the airplane impacting a ditch. The wet grass runway and the ditch were factors.NTSB CHI06CA103Accident · No injuriesData collectionFinal reportPiper PA-32-301 · Grayslake, ILThe pilot failed to compensate adequately for the crosswind condition and failed to maintain directional control during the landing roll. Contributing factors included the crosswind, the narrow runway, soft ground, and the ditch.NTSB CHI06CA053Accident · No injuriesData collectionFinal reportCessna 172R · Morris, ILThe pilot's improper in-flight decision to land with a quartering tailwind and not maintaining directional control. Factors were the quartering tailwind and the snowdrift.NTSB CHI06CA059Accident · No injuriesData collectionFinal reportCessna 150F · Poplar Grove, ILThe student pilot's inadequate recovery from the bounced landing, and not maintaining airplane control during the landing.NTSB DCA06MA009Accident · 1 fatalClass 1 · MajorFinal reportBoeing 737-700 · Chicago, ILThe pilots' failure to use available reverse thrust in a timely manner to safely slow or stop the airplane after landing, which resulted in a runway overrun. This failure occurred because the pilots' first experience and lack of familiarity with the…NTSB CHI06CA054Accident · No injuriesData collectionFinal reportPiper PA-44-180 · Rockford, ILFailure of the commercial pilot (dual student) to maintain a proper descent rate and a safe airspeed during the simulated forced landing. Additional causes were the failure of the flight instructor and the dual student to initiate a go-around in sufficient…NTSB CHI05CA253Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Rockton, ILThe pilot's excessive descent rate on approach for landing and the settling with power condition subsequently encountered. Contributing factors were the pilot's failure to reduce the descent rate prior to entering the settling with power condition and his…NTSB CHI05CA169Accident · Minor injuriesData collectionFinal reportKelley Volmer Amphibian B · Nauvoo, ILThe pilot's failure to maintain appropriate airspeed during landing, which resulted in a stall/mush condition and hard landing.NTSB CHI05CA157Accident · Minor injuriesData collectionFinal reportCessna 195 · Peru, ILThe pilot not maintaining directional control during the landing and the ground loop he encountered.NTSB CHI05LA136Accident · No injuriesLimited investigationFinal reportCessna 182TR · Wheeling, ILThe pilot failed to verify that the landing gear were fully extended and failed to perform the emergency landing gear extention procedures. Factors to the accident included the low hydraulic fluid level, and the weak battery that resulted in a partial…NTSB CHI05CA126Accident · No injuriesData collectionFinal reportYoung Zodiac 601XL · Mattoon, ILThe pilot's failure to maintain control of the airplane during the landing flare resulting in an in-flight collision with the runway pavement.NTSB CHI05CA027Accident · No injuriesData collectionFinal reportCessna T182T · Morris, ILThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control. Factors associated with the accident were the gusty crosswind condition and the runway sign which the airplane contacted.NTSB CHI04CA251Accident · No injuriesData collectionFinal reportCessna 182T · Lake In The Hil, ILthe excessive descent rate resulting in a hard landing.NTSB CHI04LA217Accident · No injuriesLimited investigationFinal reportGrumman G-164-B · Bradford, ILThe pilot's misjudgment of speed and distance, and his failure to perform a go-around. Additional factors were the wet runway and the ditch.NTSB CHI04CA179Accident · No injuriesData collectionFinal reportWaco YMF-FSC · Lansing, ILThe pilot's inadequate compensation for wind conditions and his failure to maintain directional control. The crosswind and the ditch were contributing factors.NTSB CHI04CA164Accident · No injuriesData collectionFinal reportCessna 401 · Mt. Vernon, ILThe pilot's misjudgment of the landing flare. Contributing factors were the pilot's failure to execute a stabilized approach for landing. An additional factor was the presence of the runway lights.NTSB CHI04LA155Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-40 · Waukegan, ILThe pilot's misjudgment of the landing flare which resulted in a hard landing. Contributing factors were the subsequent overload and collapse of the nose landing gear.NTSB CHI04CA095Accident · No injuriesData collectionFinal reportBeech C23 · Lake in the Hil, ILThe dual student pilot not maintaining airplane control during the go-around and the flight instructor pilot's inadequate remedial action resulting in the airplane's uncontrolled descent.NTSB CHI04LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Peru, ILThe inadvertent landing gear retraction by the dual student during the landing roll.NTSB CHI04LA063Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · Lansing, ILThe improper flare by the pilot due to his diverted attention during landing. Factors were the pilot's failure to execute a go-around, the overload of the right main landing gear, and the snowbank.NTSB CHI04CA067Accident · No injuriesData collectionFinal reportCessna 172N · Cahokia, ILThe inadequate supervision by the certified flight instructor which lead to the student pilot's failure to maintain clearance from the snowbank during the landing. The snowbank was a factor.NTSB CHI04LA013Accident · No injuriesLimited investigationFinal reportBell 47G-3B-1 · Schaumburg, ILThe commercial pilot not maintaining directional control of the helicopter and the improper flare initiated before landing.NTSB CHI03LA317Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Highland, ILThe pilot encountering unsuitable terrain during an off-airport landing. A factor to the accident was the high vegetation.NTSB CHI03LA304Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Atwood, ILThe pilot's failure to correctly identify the location of the airport. Factors to the accident include the pilot flying while fatigued, which contributed to his misidentification of the runway, and the rough/uneven soybean field.