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 WPR20CA250Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Kalispell, MTThe pilot's excessive speed while landing on a wet grass runway, which resulted in a runway excursion and impact with a fence.NTSB CEN20CA351Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Conway, ARThe pilot’s improper recovery from a bounced landing.NTSB CEN20CA349Accident · No injuriesClass 4 · Data collectionFinal reportCessna T206 · Bentonville, ARThe pilot's misjudgment of the landing flare which resulted in a bounced landing.NTSB CEN20CA324Accident · Minor injuriesClass 4 · Data collectionFinal reportGrob G102 · Midlothian, TXThe unstabilized landing approach in gusty wind conditions that resulted in a hard, bounced landing.NTSB ERA20CA267Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Indian Trail, NCThe pilot's failure to attain the proper landing approach speed and touchdown point, which resulted in a runway overrun.NTSB ANC20CA075Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chisana, AKThe pilot's overapplication of brakes during landing in gusting tailwind conditions, which resulted in a nose-over.NTSB WPR20CA243Accident · Minor injuriesClass 4 · Data collectionFinal reportQuest Kodiac 100 · Hunts Point, WAThe pilot’s failure to retract the landing gear during a water landing, which resulted in a nose over. Contributing to the accident was the pilot’s failure to properly use a prelanding checklist.NTSB DCA20WA133Incident · No injuriesForeign investigationBoeing 737 · Wamena, IndonesiaThe KNKT of Indonesia has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 28, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT of Indonesia's investigation under the provisions of ICAO…NTSB CEN20CA313Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Dakota, ILThe pilot’s failure to maintain main rotor clearance from a ground obstacle during a landing.NTSB CEN20CA308Accident · Serious injuriesClass 4 · Data collectionFinal reportMaule MXT7 · Hillsboro, ILThe pilot's exceedance of the airplane's critical angle of attack while attempting to avoid a deer during landing, resulting in an aerodynamic stall.NTSB ERA20CA265Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28R · Fernandina Beach, FLThe failure of the right main landing gear to extend prior to landing, which could not be duplicated during postaccident tests.NTSB WPR20LA237Accident · 1 fatalClass 3 · LimitedFinal reportVans Vans RV-8 · Tehachapi, CAThe pilot’s failure to maintain airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at too low of an altitude to recover.NTSB ERA20CA260Accident · No injuriesClass 4 · Data collectionFinal reportRobinson R44 · Whitehall, MDThe pilot's failure to maintain adequate clearance from a known obstacle while landing from a hover.NTSB WPR20CA254Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Clearwater, ORThe pilot's improper pitch attitude during the soft-field landing roll, which resulted in the tail striking the runway.NTSB ERA20LA259Accident · No injuriesClass 3 · LimitedFinal reportBeech 400 · Montgomery, ALLanding with the left main landing gear retracted due to the failure of the landing gear control unit, which resulted in substantial damage.NTSB CEN20CA299Accident · No injuriesClass 4 · Data collectionFinal reportRockwell 112 · Tomball, TXThe pilot did not maintain control of the airplane during the landing and subsequent go around.NTSB CEN20CA302Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA28 · Grayslake, ILThe pilot’s application of the left brake during landing resulting in a runway excursion.NTSB CEN20CA298Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Cambridge, MNThe pilot's loss of directional control while landing a tailwheel airplane with a slight left quartering a tailwind. Contributing to the accident was the flight instructor's delayed remedial action.NTSB CEN20CA296Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170B · Bloomington, INThe pilot's failure to attain/maintain directional control during landing that resulted in a ground loop and impact with terrain.NTSB ERA20CA256Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 172 · Wellington, FLThe pilot’s inadequate compensation for a wind gust during landing.NTSB WPR20CA230Accident · No injuriesClass 4 · Data collectionFinal reportSeele XPA-18 · Reno, NVAn inadequate flare which resulted in a bounced landing and the pilot's failure to maintain directional control.NTSB ERA20CA268Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 12 · Linconville, METhe pilot's improper landing flare, which resulted in a bounced landing and subsequent main landing gear collapse.NTSB ERA20CA264Accident · No injuriesClass 4 · Data collectionFinal reportMooney M20J · Block Island, RIA hard landing and subsequent loss of control.NTSB CEN20CA317Accident · No injuriesClass 4 · Data collectionFinal reportCessna 120 · Osceola, WIThe pilots did not maintain directional control of the airplane during landing.NTSB CEN20CA289Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Glenwood Springs, COThe pilot's failure to maintain airplane control during landing resulting in a nose over.NTSB ERA20CA257Accident · Minor injuriesClass 4 · Data collectionFinal reportKade Aventura II · Astor, FLThe pilot's failure to retract the amphibious airplane’s landing gear prior to the water landing, which resulted in a nose over.NTSB ERA20CA253Accident · No injuriesClass 4 · Data collectionFinal reportAir Tractor AT502 · Washington, NCThe pilot's failure to maintain directional during landing on a wet grass runway.NTSB CEN20CA285Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Rochester, INThe pilot's failure to maintain directional control during landing resulting in a ground loop.NTSB WPR20CA222Accident · No injuriesClass 4 · Data collectionFinal reportCessna 152 · Hayward, CAThe pilot's failure to maintain airplane control during landing in gusting wind conditions, and the flight instructor's delayed remedial action, which resulted in the left wing striking the runway.NTSB ERA20CA251Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 22 · Fuquay Varina, NCThe pilot's failure to attain a proper approach speed, which resulted in an overrun of the wet grass runway.NTSB CEN20CA281Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · Houston, TXThe flight instructor and student pilot did not properly transfer airplane control during ground rollout, which resulted in the airplane exiting the runway and impacting a ditch.NTSB CEN20CA280Accident · No injuriesClass 4 · Data collectionFinal reportWaco YKC · New Carlisle, OHThe pilot's failure to maintain proper approach speed and descent path to the runway, which resulted in excessive speed at touchdown and insufficient runway remaining to safely bring the airplane to a stop before the end of the runway. Contributing to the…NTSB ANC20LA069Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT802 · Birch Creek, AKA loss of control for undetermined reasons while on the surface of the water during scoop operations in support of wildland firefighting operations.NTSB ANC20CA071Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Palmer, AKThe pilot's loss of control during landing, which resulted in a ground loop and left main landing gear collapse.NTSB WPR20CA220Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Port Townsend, WAThe pilot's failure to maintain directional control during a crosswind landing, which resulted in a nose over.NTSB WPR20CA227Accident · No injuriesClass 4 · Data collectionFinal reportChampion 7GCBC · McCall, IDThe pilot's decision to land with excessive approach airspeed, which resulted in the airplane landing long, the application of additional braking action to stop and subsequent nose over.NTSB WPR20CA219Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Concord, CAThe student pilot's failure to maintain airplane control when the airplane drifted off of runway centerline and subsequently collided with a taxiway sign during a go-around.NTSB ERA20CA249Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Pickens, SCThe student pilot's improper landing flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB CEN20CA274Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA32 · Springfield, OHThe pilot’s inadequate inflight planning that resulted in a loss of engine power due to fuel exhaustion.NTSB GAA20WA124Incident · No injuriesForeign investigationLearjet 45 · Toluca de Lerdo, Méx., Mexico, MexicoThe government of Mexico has notified the NTSB of an accident involving a LEARJET 45 airplane that occurred on July 10, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…NTSB ERA20CA248Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Culpeper, VAThe pilot’s failure to maintain directional control on landing resulting in a runway excursion and subsequent ground loop. Contributing to the outcome were the flight instructor’s inadequate remedial actions.NTSB WPR20CA255Accident · Minor injuriesClass 4 · Data collectionFinal reportAir Creation/Sides Rick A Manta 503 · Ramona, CAThe solo student pilot's improper landing flare, which resulted in a bounced landing and subsequent nose over.NTSB ERA20CA250Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Auburn, METhe student pilot's improper landing flare, which resulted in a hard landing on the nosegear and nosegear collapse.NTSB WPR20CA217Accident · No injuriesClass 4 · Data collectionFinal reportCessna 182 · Absarokee, MTThe pilot's failure to maintain airplane control during a go-around that resulted in the airplane exceeding its critical angle of attack and aerodynamically stalling which resulted in a collision with the ground.NTSB WPR20CA214Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18A-135 · Marion, MTThe pilot's failure to maintain directional control of the airplane while landing in gusting wind conditions, which resulted in a runway excursion and collision with a fence.NTSB WPR20CA213Accident · No injuriesClass 4 · Data collectionFinal reportBeech 33 · Redmond, ORThe left seated flight instructor’s improper manipulation of the landing gear position selection lever to the up position while still on the landing roll, which ultimately resulted in a landing gear collapse during a subsequent landing.NTSB WPR20LA226Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75 · Chino, CAThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA20CA263Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Prattville, ALThe student pilot's failure improper landing flare, which resulted in a hard landing.NTSB ERA20CA238Accident · No injuriesClass 4 · Data collectionFinal reportSocata TB 10 · Easton, PAThe pilot's failure to maintain a proper glide path, which resulted in landing short of the runway, the airplane’s landing gear contacting the runway lip, and substantial damage to the airplane’s right wing.NTSB ANC20LA065Accident · No injuriesClass 3 · LimitedFinal reportCessna 180 · Anchorage, AKThe failure of the left float bottom due to corrosion, which resulted in a loss of control during the water landing.