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 ERA21LA204Accident · Minor injuriesClass 4 · LimitedFinal reportJabiru Aircraft PTY J170-D · Winchester, VAThe pilot’s loss of directional control on landing. Contributing to the outcome was the pilot’s decision to continue the aborted landing after the airplane had departed the runway surface.NTSB WPR21LA191Accident · Serious injuriesClass 4 · LimitedFinal reportUltramagic S A N-500 · Phoenix, AZThe pilot’s inability to maintain control after the balloon's encounter with an unexpected wind gust, which resulted in a collision with a tree.NTSB WPR21LA181Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Driggs, IDThe pilot’s failure to maintain directional control while landing with gusting wind conditions, which resulted in a ground loop.NTSB ERA21LA203Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Williamson, GAThe pilot's decision to land the airplane with a tailwind, which led to a runway excursion.NTSB CEN21FA207Accident · 1 fatalClass 3 · FieldFinal reportCessna T210M · Oxford, IAThe pilot’s loss of directional control during landing in gusting crosswind conditions that exceeded the airplane’s capability and his decision to attempt to takeoff from a field, which resulted in collision with a power pole/line and terrain.NTSB ANC21LA035Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172P · Lanai City, HIThe solo student pilot’s failure to maintain directional control during landing in crosswind conditions, which resulted in a runway excursion and a nose-over.NTSB ERA21LA205Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Columbia, KYThe pilot’s failure to obtain a proper touchdown point on the runway, which resulted in a runway excursion.NTSB GAA21WA098Accident · No injuriesClass 5 · ForeignRobinson R44 · Región de Ñuble, ChileNTSB ERA21LA210Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Friendly, MDThe pilot’s failure to attain a proper touchdown point on landing, which resulted in a collision with the runway lip.NTSB WPR21LA178Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 42 · Brigham City, UTThe student pilot's unintentional selection of raising the landing gear instead of the flaps during a touch-and-go landing, and the flight instructor's delayed remedial action, which resulted in the landing gear retracting during the landing roll.NTSB GAA21WA093Accident · No injuriesClass 5 · ForeignMooney M20M · Lübeck, GermanyNTSB GAA21WA090Accident · No injuriesClass 5 · ForeignCirrus Design SR22 · Buckinghamshire, United KingdomNTSB CEN21LA202Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75 · Denver, COThe pilot’s failure to maintain directional control during the landing roll with variable and gusty wind conditions.NTSB WPR21LA177Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182J · Sedona, AZThe pilot’s failure to maintain directional control during landing with a crosswind, which resulted in a collision with a fuel truck and a parked airplane.NTSB ANC21LA034Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Palmer, AKThe pilot’s selection of unsuitable terrain for landing and his excessive braking which resulted in a nose-over.NTSB ERA21LA198Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Fredericksburg, VAThe student pilot reported that, during the landing roll, he applied brakes and the airplane veered right. He was unable to correct back to the centerline or brake effectively; the airplane exited the runway and struck an embankment before coming to rest. The…NTSB CEN21LA205Accident · No injuriesClass 4 · LimitedFinal reportCessna 310N · Carrollton, OHThe pilot’s failure to confirm the landing gear was down before landing due to distraction during the Before Landing checks, which resulted in a gear-up landing.NTSB CEN21LA196Accident · No injuriesClass 4 · LimitedFinal reportMobi-light CCX-2300 · Loveland, COThe pilot’s failure to maintain directional control during landing, which resulted in a ground loop, and the failure of both pilots to establish who was in control of the airplane.NTSB GAA21WA119Accident · No injuriesClass 5 · ForeignSpitfire MK26 · Breighton, UK, United KingdomNTSB GAA21WA082Accident · 1 fatalClass 5 · ForeignLearjet 35 · Belo Horizonte, BrazilNTSB CEN21LA210Accident · Serious injuriesClass 4 · LimitedFinal reportFirefly Balloons 2010 Firefly 12B-010 · Pagosa Springs, COThe pilot’s failure to properly control the balloon during a steep approach that resulted in a hard landing and a serious passenger injury.NTSB CEN21LA214Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Gonzales, TXThe pilot’s failure to maintain directional control during landing that resulted in a runway excursion and collision with a pole.NTSB WPR21LA163Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Wilsall, MTThe pilot's failure to maintain directional control during the landing roll with a crosswind.NTSB GAA21WA078Accident · No injuriesClass 5 · ForeignLearjet 25 · Toluca de Lerdo, MexicoNTSB WPR21LA165Accident · No injuriesClass 4 · LimitedFinal reportBryan S Happell TANGO2 · Hayden, IDThe pilot’s failure to control the pitch attitude of the gyroplane during landing, which resulted in a loss of control, runway excursion and collision with terrain.NTSB ERA21LA352Accident · No injuriesClass 4 · LimitedFinal reportHine T L/Johnson R Bush Wacker · Thomaston, GAA loss of directional control upon landing for reasons that could not be determined as a result of a delayed report. Contributing was the pilot’s decision to continue a flight with an unknown airworthiness issue.NTSB ANC21LA030Accident · No injuriesClass 4 · LimitedFinal reportBeech C-99 · Chignik Lagoon, AKThe pilot’s failure to visually inspect the runway condition before landing, which resulted in a collision with an ice chunk and main landing gear separation during landing.NTSB WPR21LA160Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-160 · Cottonwood, AZThe pilot's failure to maintain directional control during landing, which resulted in a ground loop.NTSB GAA21WA105Accident · No injuriesClass 5 · ForeignBeech D17 · Leer (Ostfriesland), GermanyNTSB CEN21LA190Accident · No injuriesClass 3 · LimitedFinal reportGates Learjet 35A · Colorado Springs, COThe flight crew’s improper decision to continue the unstabilized approach, which resulted in an aerodynamic stall and impact with the runway during landing.NTSB ANC21LA031Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Anchorage, AKA loss of control during landing for reasons that could not be determined based on the available evidence.NTSB WPR21LA157Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Bellingham, WAThe student pilot’s inadequate flare resulting in a loss of control during landing with a crosswind and subsequent nose over.NTSB WPR21LA174Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Silver City, NMThe pilot’s loss of situational awareness and failure to touchdown on the runway which resulted in a collision with the airport’s perimeter fence.NTSB ERA21LA186Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Troy, ALAn unanticipated encounter with a deer shortly after touchdown, resulting in a collision and substantial damage to the airframe.NTSB ERA21LA182Accident · No injuriesClass 4 · LimitedFinal reportRowe Dennis A Highlander · Bluefield, WVThe pilot’s failure to maintain directional control while landing in a gusty crosswind, which resulted in a ground loop.NTSB ANC21LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 170A · Lime Village, AKThe pilot’s selection of unsuitable terrain for landing, which resulted in a landing gear collapse.NTSB ERA21LA180Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Orangeburg, SCThe student pilot’s improper recovery from a bounced landing, which resulted in a hard landing.NTSB ERA21LA176Accident · No injuriesClass 4 · LimitedFinal reportCessna 172F · Fayetteville, NCThe pilot’s failure to maintain directional control during the landing, which resulted in a runway excursion and subsequent noseover.NTSB CEN21LA184Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 · Johnson, KSThe pilot's inadequate pedal application during a transition to hover, which resulted in a loss of yaw control and a subsequent impact with terrain.NTSB CEN21LA183Accident · Minor injuriesClass 4 · LimitedFinal reportMaule MT7 · Jewett, TXThe pilot’s failure to maintain control of the airplane after it struck a hidden berm during the intentional off-airport landing, which resulted in a hard landing.NTSB WPR21LA153Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Sand Point, IDThe student pilot’s improper landing flare which resulted in a hard landing, loss of directional control and subsequent nose over.NTSB ERA21LA171Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson Helicopter R66 · Palmyra, PAThe pilot’s improper judgment to attempt a flight while impaired by medications, which resulted in the helicopter’s abnormal ground contact, loss of control, and collision with terrain.NTSB CEN21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Delavan, WIThe pilot’s failure to maintain control of the airplane during the landing roll with gusting crosswinds, which resulted in his excessive brake input and a subsequent nose over.NTSB CEN21LA182Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Denver, COThe pilot’s loss of situational awareness, and his unintended landing on a soft unimproved dirt road, which resulted in a loss of directional control into soft ground and the airplane to subsequently nose over.NTSB GAA21WA108Incident · No injuriesClass 5 · ForeignPiper PA28R · Tamuin, MexicoNTSB ERA21LA168Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Crystal River, FLThe student pilot’s inadequate compensation for a crosswind during landing, which resulted in a loss of directional control and a runway excursion.NTSB GAA21WA084AccidentClass 5 · ForeignRotorway Executive 162F · Stansted, United KingdomNTSB WPR21LA362Accident · No injuriesClass 3 · LimitedFinal reportMaule MX-7-235 · Ontario, ORA loss of hydraulic fluid and failure of the right brake for reasons that could not be determined due to a lack of available evidence.NTSB WPR21FA143Accident · 5 fatalClass 3 · FieldFinal reportAirbus Helicopters AS350-B3 · Palmer, AKThe pilot’s failure to adequately respond to an encounter with whiteout conditions, which resulted in the helicopter’s collision with terrain. Contributing to the accident was the (1) operator’s inadequate pilot training program and pilot competency checks,…NTSB WPR21LA167Accident · No injuriesClass 4 · LimitedFinal reportAmerican Legend AL3 · Petaluma, CAThe pilot's failure to maintain directional control while landing in gusting wind conditions, which resulted in a ground loop.