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 DEN00LA020Accident · No injuriesLimited investigationFinal reportCessna 210D · Sheridan, WYThe partial failure of the engine driven hydraulic pump.NTSB NYC00LA035Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Waynesville, OHThe flight instructor's delay in remedial action.NTSB MIA00LA027Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLWas the pilot's improper flare and improper recovery from a bounced landing resulting in a hard landing and damage to the aircraft.NTSB LAX00LA036Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Petaluma, CAThe failure of the pilot to maintain adequate airspeed which resulted in a stall/mush condition and subsequent hard landing.NTSB NYC00LA032Accident · Minor injuriesLimited investigationFinal reportStatz Kitfox II · Ebensburg, PAwas the failure of the pilot to maintain directional control during a bounced landing recovery. A factor was the pilot's lack of experience in make and model.NTSB IAD00LA006Accident · No injuriesLimited investigationFinal reportCessna 172N · Hopedale, MAwas the student pilot's improper flare that resulted in a bounced landing and the flight instructor's delay in taking remedial action.NTSB CHI00LA029Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Romulus, MIthe inadvertent wheels-up landing by the pilot.NTSB ATL00LA013Accident · No injuriesLimited investigationFinal reportBeech BE36 · Daytona Beach, FLThe collapse of the main landing gear for undetermined reasons.NTSB SEA00LA022Accident · No injuriesLimited investigationFinal reportCessna 175 · Garden Valley, IDAn improper in-flight decision by the pilot-in-command to attempt a landing at a confined-area airstrip which was beyond his piloting capabilities, and his subsequent failure to take adequate remedial action upon encountering a downdraft. Related factors were…NTSB NYC00LA033Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Fayetteville, WVThe pilot's decision to continue the landing attempt too far down the runway. A factor was the pilot's self-induced pressure to land the airplane, due to the sickness of the front seat passenger.NTSB DEN00LA017Accident · No injuriesLimited investigationFinal reportCessna 172R · Logan, UTThe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI00LA030Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Saint Charles, MOthe pilot's failure to maintain directional control on landing. A factor was the crosswind.NTSB ATL00LA011Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Hollandale, MSThe certified flight instructor's inadequate supervision of the landing and the student pilot's failure to relinquish the flight controls when the certified flight instructor attempted to recover from a bounced landing.NTSB NYC00LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Factoryville, PAThe pilot's failure to maintain aircraft control during a crosswind landing.NTSB CHI00LA025Accident · No injuriesLimited investigationFinal reportMancini Vans RV-4 · North Platte, NEaircraft control not being maintained by the pilot. A factor to the accident was the crosswind weather condition.NTSB CHI00LA024Accident · No injuriesLimited investigationFinal reportAmerican AA-1B · Gallatin, MOOn-ground collision with an animal during landing roll. The night conditions were a contributing factor.NTSB CHI00LA026Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Rochester, INthe pilot did not obtain the proper touchdown point. Factors included the closed runway and the culvert.NTSB CHI00LA023Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S57-A · Imperial, MOthe passenger's failure to follow instructions on how to properly brace for the landing.NTSB ATL00FA009Accident · 1 fatalField investigationFinal reportCessna 210N · Chamblee, GAThe failure of the flex hydraulic line and the chaffing of an electrical line under the pilot seat that resulted in an inflight fire. The pilot's inflight decision to continue flight with a known airplane deficiencies.NTSB ANC00LA012Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Glennallen, AKThe pilot's failure to maintain directional control during landing. A factor associated with the accident was snow-covered terrain.NTSB DEN00LA015Accident · Serious injuriesLimited investigationFinal reportAerostar RXS-8 · Artesia, NMThe pilot's inadequate compensation for the wind conditions.NTSB NYC00LA025Accident · Serious injuriesLimited investigationFinal reportKnox HI-MAX · Dixfield, METhe pilot's failure to obtain the proper touchdown point. A factor in the accident was the pilot's lack of experience in make and model.NTSB CHI00LA022Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Hannibal, MOthe pilot not maintaining directional of the airplane. Factors were the crosswinds and gusts.NTSB MIA00LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Raleigh, NCThe pilot's failure to maintain directional control on landing rollout for undetermined reasons. This resulted in the airplane veering off the runway and colliding with an airport sign.NTSB LAX00LA031Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe pilot's misjudged landing flare and failure to maintain an adequate airspeed margin, which resulted in a stall/mush and hard landing.NTSB DEN00LA014Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bullfrog, UTThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the pilot's lack of total experience in type of aircraft and the fence.NTSB ANC00IA010Incident · No injuriesIncident investigationFinal reportBoeing 737-400 · Juneau, AKThe failure of the flight crew to provide a recommended landing traffic advisory, and the failure of flight service station personnel to provide a flight advisory to the arriving airplane concerning men and equipment operating on the runway. Factors in the…NTSB CHI00FA020Accident · 2 fatalField investigationFinal reportBell 206B · Cottage Grove, MNUndetermined.NTSB LAX00LA029Accident · No injuriesLimited investigationFinal reportCessna 170A · El Mirage, CAThe pilot's failure to maintain directional control of his airplane, which resulted in an inadvertent ground loop.NTSB LAX00LA028Accident · No injuriesLimited investigationFinal reportCessna 305A · Torrance, CAThe pilot's loss of directional control during landing rollout due to the failure of the tail wheel control system. A contributing factor was the quartering tailwind condition.NTSB SEA00LA011Accident · No injuriesLimited investigationFinal reportBeech A36TC · Pasco, WAThe pilot's failure to extend the landing gear. Factors include a blocked view of the landing gear light indicating system.NTSB FTW00LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Pineville, LAThe student pilot's misjudgment of distance/speed during approach resulting in his failure to attain the proper touchdown point.NTSB SEA00LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Mackay, IDThe pilot's failure to land at the proper touchdown point. Factors include a wind gust, a grass runway, and a drop-off into rough terrain at the end of the runway.NTSB MIA00LA016Accident · No injuriesLimited investigationFinal reportCessna 152 · Cornelia, GAthe pilot misjudged the flare, causing the airplane to porpoise, and subsequently impact with the runwayNTSB NYC00LA016Accident · Minor injuriesLimited investigationFinal reportCessna 190 · Somerville, NJThe pilot's inadequate compensation for wind.NTSB DEN00LA013Accident · No injuriesLimited investigationFinal reportBellanca 8KCAB · Grand Junction, COA failure of the left main landing gear attachment (u-bolt) due to fatigue.NTSB DEN00LA011Accident · No injuriesLimited investigationFinal reportCessna 172B · Englewood, COThe pilot-in-command's failure to maintain directional control of the aircraft during landing roll. Factors were the gusty crosswind and the runway light.NTSB CHI00LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Waukon, IAthe pilot failed to maintain directional control of the airplane during the aborted landing. Factors relating to the accident included the crosswinds, the fence, and the trees.NTSB SEA00LA009Accident · No injuriesLimited investigationFinal reportCessna 182B · Atlanta, IDDirectional control not maintained by the pilot in command.NTSB NYC00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Hopedale, MAThe nose landing gear was not locked in the extended position.NTSB SEA00LA016Accident · No injuriesLimited investigationFinal reportAero Commander 680 · Bremerton, WALoss of directional control by the student pilot during landing. Factors include inadequate remedial action by the flight instructor, and an airport sign that was struck by the airplane, collapsing the left main landing gear.NTSB NYC00LA017Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Orange, MAThe pilot's failure to maintain directional control during a sudden wind shift.NTSB LAX00LA024Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Santa Clarita, CAThe pilot's delay in adding power during a power-on recovery from an autorotation, which resulted in a hard landing and rollover. The flight instructor's inadequate supervision of the flight was also causal.NTSB FTW00LA027Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Terrell, TXThe pilot's failure to maintain aircraft control during landing.NTSB ATL00LA008Accident · No injuriesLimited investigationFinal reportCessna 310R · Columbus, GAThe pilot's improper flare that resulted in a hard landing.NTSB FTW00LA018Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Oklahoma City, OKThe failure of the pilot to follow the landing checklist and verify that the landing gear was down and locked, which resulted in a wheels up landing. A factor was the failure of the landing gear locking mechanism for an undetermined reason.NTSB ATL00LA001Accident · No injuriesLimited investigationFinal reportCessna 305C · Morganton, NCThe pilot's inadequate compensation for a tailwind which resulted in the loss of control.NTSB SEA00LA003Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Laurel, MTThe pilot's inadequate compensation for wind conditions. Factors include a dust devil/whirlwind at the location where the pilot was trying to land.NTSB FTW00LA014Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Jonesboro, ARThe flight instructor's delay in taking remedial action to recover from a low rotor rpm situation. A factor was the student's failure to maintain adequate rotor rpm.NTSB DEN00LA008Accident · No injuriesLimited investigationFinal reportFairchild M62A (PT-19) · Gallup, NMFailure by the pilot in command to maintain control of the aircraft during landing roll. Factors were a lack of experience of either pilot in kind and type of aircraft.