NTSB investigations
53,702 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 WPR21LA148Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · Alturas, CAThe student pilot's improper landing flare which resulted in a bounced landing, loss of airplane control and subsequent collision with terrain.NTSB WPR21LA147Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1 · Ogden, UTThe pilot's failure to maintain directional control during the landing roll with a light crosswind, which resulted in a runway excursion and collision with terrain.NTSB GAA21WA092Accident · No injuriesClass 5 · ForeignBeech 95B55 · Warwickshire, United KingdomNTSB ERA21LA185Accident · No injuriesClass 4 · LimitedFinal reportCessna 182Q · Flemingsburg, KYThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing.NTSB CEN21LA170Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR20 · Boerne, TXThe pilot’s failure to maintain control of the airplane during a full stop landing and the subsequent attempted go-around in turbulent conditions.NTSB CEN21LA169Accident · Minor injuriesClass 4 · LimitedFinal reportBell OH-58 · Pottsboro, TXThe pilot failure to maintain directional control of the helicopter when it encountered an unanticipated wind allowing it to drift into a fence and subsequently roll over and impact terrain.NTSB WPR21LA150Accident · No injuriesClass 4 · LimitedFinal reportCessna 150L · Marana, AZThe student pilot’s improper flare which resulted in a bounced, hard landing and loss of control in a gusting crosswind.NTSB ERA21LA179Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Tampa, FLThe pilot’s improper recovery from a bounced landing, which resulted in a subsequent hard landing and a nose landing gear collapse.NTSB DCA21WA107IncidentClass 5 · ForeignBoeing 757-24APF · San Salvador, El SalvadorNTSB CEN21LA166Accident · No injuriesClass 4 · LimitedFinal reportCessna 207A · Laredo, TXThe pilot’s failure to control the airplane during the landing flare, which resulted in a hard landing.NTSB ERA21LA221Accident · No injuriesClass 4 · LimitedFinal reportCessna T337G · Patuxent River, MDThe pilot’s failure to extend the landing gear during approach, which resulted in a gear up landing.NTSB DCA21WA099Accident · No injuriesClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaNTSB ANC21LA027Accident · No injuriesClass 4 · LimitedFinal reportBeech A36 · Port Alsworth, AKThe pilot's misidentification of the airport’s active runway, which resulted in an off runway landing and a collision with a snow berm. Contributing to the accident was the runway’s lack of identifying markings.NTSB ANC21LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Fairbanks, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB WPR21LA138Accident · No injuriesClass 4 · LimitedFinal reportBurg Frederick S ZEN CH701 · Shepherd, MTThe pilot’s unstable approach, and improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB WPR21LA137Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Three Forks, MTThe pilot’s improper landing flare, which resulted in a loss of directional control, runway excursion and impact with terrain.NTSB CEN21LA159Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-12 · Erie, COThe pilot’s failure to maintain directional control during a full-stop landing, resulting in a runway excursion and impact with a snow berm.NTSB WPR21LA136Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Myrtle Creek, ORThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion and impact with terrain.NTSB ERA21LA175Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Fort Pierce, FLThe flight instructor’s delayed remedial action and failure to maintain directional control during a crosswind landing, which resulted in a runway excursion.NTSB WPR21LA131Accident · No injuriesClass 3 · LimitedFinal reportCessna T210M · Leadore, IDThe pilot’s failure to attain the proper touchdown point on a graveled surfaced runway with insufficient landing performance and subsequent loss of control during the landing roll.NTSB CEN21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Port Aransas, TXThe pilot’s failure to maintain proper airspeed on approach and his attempt to land on a wet runway with insufficient runway remaining, resulting in an overrun and loss of directional control.NTSB GAA21WA050Incident · No injuriesClass 4 · ForeignHonda HA-420 · Kohnan, JapanNTSB WPR21LA132Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-135 · Eastsound, WAThe pilot’s failure to maintain directional control during the landing roll with a tailwind, which resulted in a landing gear collapse and collision with terrain.NTSB WPR21LA128Accident · No injuriesClass 4 · LimitedFinal reportAviat A-1C-180 · McCall, IDThe pilot's loss of directional control while landing in a crosswind, which resulted in a ground loop.NTSB ERA21LA151Accident · No injuriesClass 4 · LimitedFinal reportBeech Sierra · Augusta, METhe pilot’s improper landing flare, which resulted in a bounced landing, and a subsequent runway excursion. Also causal was the flight instructor’s delayed remedial action.NTSB CEN21LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 170 · Poplar Bluff, MOThe pilot’s decision to make a precautionary landing in a field that contained soft terrain, which resulted in the airplane nosing over. Contributing to the accident was the pilot’s decision to fly without a printed VFR sectional chart to identify the…NTSB CEN21LA154Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Duson, LAThe uncertified pilot’s failure to maintain control of the helicopter when encountering a wind gust while hovering to land.NTSB WPR21LA125Accident · No injuriesClass 4 · LimitedFinal reportPhillip B Rolls Pitts 12-EH · Red Bluff, CAThe pilot's failure to maintain directional control during a landing, which resulted in a ground loop and subsequent nose over.NTSB WPR21LA126Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 190 · Camarillo, CAThe failure of the pilot to maintain directional control of the airplane during the landing roll which resulted in a runway excursion and subsequent nose over.NTSB ERA21LA153Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32RT-300 · Brevard, NCThe pilot’s improper landing flare, which resulted in a hard landing, overstress fracture of components of the left main landing gear, and subsequent runway excursion.NTSB CEN21LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Pueblo, COThe pilot’s failure to maintain directional control in gusting crosswind conditions.NTSB CEN21LA149Accident · No injuriesClass 4 · LimitedFinal reportAeropro CZ S R O A220 · Loveland, COThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with terrain.NTSB CEN21LA157Accident · Minor injuriesClass 4 · LimitedFinal reportPost Thorp T-18 · Indianapolis, INThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB GAA21WA044IncidentClass 5 · ForeignCessna 150 · Yariguíes, ColombiaNTSB ERA21LA158Accident · No injuriesClass 4 · LimitedFinal reportVashon Ranger R7 · Hampton, GAThe student pilot’s improper flare while landing with a gusting crosswind which resulted in a hard landing and separation of the left landing gear.NTSB GAA21WA046Incident · No injuriesClass 4 · ForeignHawker Beechcraft 4000 · Plettenburg Bay Airfield, South AfricaNTSB ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.NTSB ERA21LA147Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Johnstown, NYA failure of the landing gear system hydraulic pump assembly for reasons that could not be determined based on available evidence. Contributing was the pilot’s failure to confirm that the landing gear was down and locked before landing.NTSB ANC21LA019Accident · No injuriesClass 4 · LimitedFinal reportCessna U206G · McGrath, AKThe pilot’s selection of an unsuitable landing surface.NTSB CEN21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA 46-350P · Aspen, COThe pilot’s failure to maintain directional control on landing.NTSB WPR21LA120Accident · No injuriesClass 4 · LimitedFinal reportPiggott John H Bearhawk · Eatonville, WAThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop.NTSB ERA21LA145Accident · No injuriesClass 4 · LimitedFinal reportGeorge Matthew Wagoner Zenith 601 HD · Englewood, FLThe pilot’s inadequate compensation for gusty wind conditions, which resulted in a hard landing. The rough terrain of the runway also contributed to the outcome.NTSB CEN21LA147Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-23 · Oshkosh, WIThe failure of the nose landing gear lower drag link for reasons that could not be determined based on available information, which resulted in the collapse of the nose landing gear.NTSB WPR21LA134Accident · No injuriesClass 4 · LimitedFinal reportBeech G35 · Tucson, AZThe pilot’s distraction in the cockpit which interrupted his pre-landing checklist which resulted in his failure to configure the landing gear prior to touchdown.NTSB CEN21LA153Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC130 · Tulsa, OKThe pilot’s improper decision to approach the airport and enter a low altitude hover with a gusting quartering tailwind, which resulted in a loss of tail rotor effectiveness during a turn at a low altitude.NTSB ERA21LA136Accident · Serious injuriesClass 4 · LimitedFinal reportTurcotte JR Robert L RV6 · North Hampton, NHThe pilot’s failure to maintain directional control during the landing in a crosswind condition, which resulted in a runway excursion.NTSB ERA21LA139Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Fort Pierce, FLThe pilot under instruction’s improper landing flare and attempted go-around which resulted in an aerodynamic stall, and subsequent loss of control. Contributing to the accident was the flight instructor’s delayed remedial action.NTSB ERA21LA134Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421 · St. Marys, PAThe pilot’s decision to continue the approach to a snow-covered runway in low-visibility conditions with limited ability to visually differentiate the left runway edge from the snow berm that ran along that side of the runway.NTSB CEN21LA137Accident · No injuriesClass 3 · LimitedFinal reportPiper PA46R-350T · Kansas City, MOThe loss of directional control during landing for reasons that could not be determined.NTSB CEN21LA134Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Indianapolis, INThe pilot’s improper landing flare that resulted in a bounced touch and go landing and subsequent nose wheel separation.