NTSB investigations
53,703 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.\"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."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 DEN00LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Erie, COInadequate supervision by the certified flight instructor. Factors were loss of control by the student pilot, the flight instructor's failure to properly monitor the student pilot's rate of descent on final approach, and the flight instructor's lack of recent…NTSB LAX00LA352Accident · Minor injuriesLimited investigationFinal reportMooney M20S · San Carlos, CAThe pilot's failure to maintain directional control of the airplane during an aborted landing.NTSB DEN00LA179Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Blanding, UTThe pilot's failure to follow the checklist and lower the landing gear for landing. A factor was diverted attention.NTSB MIA00LA270Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Charlotte, NCthe right main brake locked after touchdown causing the airplane to yaw and depart the runway, resulting in the landing gear collapsing.NTSB LAX00LA348Accident · Serious injuriesLimited investigationFinal reportCulver LFA · Ione, CAThe failure of the right brake during the landing roll resulting in loss of directional control and subsequent nose over of the airplane.NTSB 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…NTSB ATL00LA093Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Adel, GAThe pilot's selection of a closed runway for landing. Contributing factors were his inadequate inflight planning/decision and the wood block on the runway..NTSB SEA00LA189Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Corvallis, ORThe instructor pilot's delayed remedial action. Factors include the student's failure to properly initiate a flare, and the soft terrain immediately adjacent to the taxiway.NTSB DEN01LA006Accident · No injuriesLimited investigationFinal reportNorth American T-28D · Heber City, UTthe failure of the nose wheel landing gear shimmy damper, which resulted in failure and collapse of the nose wheel landing gear during landing roll.NTSB LAX00LA349Accident · No injuriesLimited investigationFinal reportWoodruff Lancair 360 · Kernville, CAThe pilot failed to maintain an adequate airspeed margin, resulting in a stall/mush and hard landing, and failed to maintain directional control and the left main landing gear separated when it struck a rock.NTSB LAX00LA351Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty and variable crosswind conditions. Factors were the variable and gusty crosswinds.NTSB DEN00LA177Accident · No injuriesLimited investigationFinal reportCessna 340 · Broomfield, COThe pilot landing the aircraft hard exceeding the design stress limits. Factors were: Low ceiling, freezing rain, dark night, excessive descent rate, and improper glide path.NTSB SEA00LA183Accident · No injuriesLimited investigationFinal reportBeech B99 · Missoula, MTA loss of directional control due to a brake locked as a result of snow and ice contamination.NTSB CHI00TA306Accident · Minor injuriesFinal reportBell 47G-5A · Economy, INThe pilot failed to maintain control of the helicopter while attempting a landing on unsuitable terrain. A factor associated with the accident was the grass covered, down slope in the terrain.NTSB CHI00LA304Accident · No injuriesLimited investigationFinal reportCessna 182S · Wichita, KSthe pilot's failure to maintain aircraft control during the landing. Factors relating to this accident were the pilot's improper recovery from the bounced landing and his failure to go-around.NTSB DEN00LA172Accident · No injuriesLimited investigationFinal reportBoeing Stearman D75N1 · Englewood, COthe flight instructor not maintaining supervision. Contributing factors were the student's hard landing due to excessive flare and subsequent inadvertent stall, and the student's failure to maintain directional control during landing roll.NTSB CHI00LA303Accident · Minor injuriesLimited investigationFinal reportPiper PA-31-325 · Jeffersonville, INthe pilot's inadequate normal braking and the pilot's inability to stop the airplane on the runway. Factors relating to this accident were the hydroplaning conditions, wet runway, the tailwind, the trees, and the ravine.NTSB FTW00LA266Accident · No injuriesLimited investigationFinal reportCessna 150K · New Orleans, LAThe pilot's failure to maintain control of the aircraft during an aborted landing. A factor was the crosswind.NTSB ANC00MA125Accident · 5 fatalMajor investigationFinal reportPiper PA-31T3 · Nuiqsut, AKThe pilot's failure to extend the landing gear, his improper aborted landing procedure, and inadvertent stall/mush. Factors in the accident were an improper adjustment of the landing gear warning horn system by company maintenance personnel, and the failure…NTSB NYC00LA264Accident · No injuriesLimited investigationFinal reportAeronca 11AC-991 · Gettysburg, PAThe pilot's failure to maintain control of the airplane after landing which resulted in the inadvertent ground loop.NTSB MIA00IA266Incident · No injuriesIncident investigationFinal reportBeech 1900C · Miami, FLThe excessive clearance between the shuttle valve and the shuttle bore in the end cap of the left main landing gear actuator for undetermined reasons either during overhaul or manufacturing resulting in failure to build hydraulic pressure using the emergency…NTSB LAX00LA340Accident · No injuriesLimited investigationFinal reportCessna 170B · Alturus, CAThe pilot's inadequate compensation for the wind, and his failure to maintain directional control of the airplane during landing. A factor was the faded improperly maintained windsock.NTSB LAX00LA338Accident · No injuriesLimited investigationFinal reportStevens Starduster II AS300 · N. Las Vegas, NVFailure of the right clip that attaches a spring to the tail wheel/rudder control assembly, which resulted in a loss of directional control and collision with a berm.NTSB FTW00LA261Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Burnet, TXThe pilot's failure to maintain directional control of the airplane while landing. A factor was the crosswind.NTSB DEN00LA173Accident · No injuriesLimited investigationFinal reportMaule M-7-235C · Collbran, COThe pilot's failure to maintain directional control during the landing flare and roll. Factors were the tree and fences.NTSB 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.NTSB SEA00LA178Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Tacoma, WAThe pilot's inadequate compensation for winds and his failure to maintain directional control. Factors include a gusting crosswind.NTSB DEN00LA171Accident · No injuriesLimited investigationFinal reportTaylorcraft 20 · Moriarty, NMThe pilot prematurely flaring the airplane, resulting in a hard landing, and causing a loss of directional control. Factors were excessive airspeed and the crosswind.NTSB CHI00LA300Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Sandstone, MNthe pilot exceeding the proper touchdown point on the runway.NTSB ANC00LA122Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Dillingham, AKA malfunctioning main landing gear brake, which precipitated a ground-loop.NTSB LAX00LA335Accident · Minor injuriesLimited investigationFinal reportCessna 172L · Novato, CAFailure of the student pilot to maintain directional control of the airplane during the landing rollout resulting in a collision with a berm.NTSB IAD00FA082Accident · 1 fatalField investigationFinal reportGrumman AA-5B · Carrollton, OHPilot's improper decision to delay the aborted landing, which resulted in an insufficient airspeed during climb and subsequent collision with terrain. A factor was the wet runway and tailwind.NTSB CHI00LA308Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hallock, MNthe pilot not maintaining directional control of the airplane. Factors were the gusts, the crosswind weather conditions, and the ditch terrain condition.NTSB ATL00LA090Accident · No injuriesLimited investigationFinal reportJack McDaniel Rans S12XL · Homestead, FLThe pilot's improper flare during landing which collapsed the landing gear.NTSB DEN00LA168Accident · No injuriesLimited investigationFinal reportCessna A185F · Ruidoso, NMthe pilot's failure to maintain directional control during landing roll. A contributing factor was the crosswind weather condition.NTSB CHI00LA292Accident · Minor injuriesLimited investigationFinal reportCessna 182S · Ellington, MOThe pilot's failure to maintain control of the aircraft during the aborted landing. Contributing to the accident was the rich mixture caused by an obstruction in the regulator section of the fuel servo.NTSB CHI00LA290Accident · No injuriesLimited investigationFinal reportBeech B19 · Dodge Center, MNthe student pilot not maintaining aircraft control and the instructor pilot's delayed remedial action. A factor relating to the accident was the ditch.NTSB NYC00LA254Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Factoryville, PAThe pilot's failure to attain the proper touchdown point.NTSB FTW00LA258Accident · No injuriesLimited investigationFinal reportCessna 177RG · Mountain Home, ARThe failure of the landing gear to extend due to the empty hydraulic reservoir.NTSB ANC00LA115Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's selection of an unsuitable, rough, runway. Factors were the crosswind, the pilot's inexperience, the company's inadequate surveillance of their operation, and dispatch of an inexperienced pilot to the unsuitable airport.NTSB FTW00LA249Accident · No injuriesLimited investigationFinal reportCessna 170A · Mexia, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswind and the pilot's failure to perform a go-around upon encountering a windshift/crosswind.NTSB ANC00LA114Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ruby, AKThe pilot's inadvertent ground loop/swerve during the landing roll.NTSB ANC00LA113Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Yakutat, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were the oil sprayed windshield, the sunglare, and an object in the water which the pilot did not see.NTSB LAX00LA330Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAThe failure of maintenance personnel to detect and correct loose attachment fasteners and fretting at the landing gear attachment during maintenance inspections.NTSB SEA00LA175Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Wapato, WAThe pilot's failure to maintain clearance from the trees off the approach end of the runway, and his delay of the remedial action that would have allowed him to clear the trees. Factors include the pilot's failure to maintain a proper glidepath, trees off the…NTSB LAX00LA323Accident · No injuriesLimited investigationFinal reportCessna 172N · North Las Vegas, NVThe failure of the pilot-in-command to maintain proper airspeed during the aborted landing go-around which resulted in a stall/mush and impact with terrain.NTSB DEN00LA162Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Laramie, WYThe pilot's failure to maintain directional control. A factor was his improper inflight decision in selecting a less-than-favorable runway on which to land that resulted in a ground loop.NTSB NYC00LA259Accident · No injuriesLimited investigationFinal reportMihlebach Waco · Williamstown, NJThe pilot's failure to execute an adequate flare, which resulted in a hard landing.NTSB LAX00LA334Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Paso Robles, CAthe pilot's failure to brief his passenger about the operation of the controls.NTSB MIA00LA261Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Meridianville, ALthe pilot in command's improper recovery from a bounced landing which resulted in hard landing on the nose landing gear and collapse of the nose landing gear.