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 GAA18CA362Accident · No injuriesData collectionFinal reportPiper PA18 · Healy, AKThe pilot’s overapplication of the brakes during the landing roll, which resulted in a nose-over.NTSB GAA18CA324Accident · No injuriesData collectionFinal reportPiper PA 22 · Talkeetna, AKThe flight instructor’s improper landing flare and failure to maintain a proper descent rate during approach, which resulted in a hard landing.NTSB GAA18CA337Accident · No injuriesData collectionFinal reportCessna 180 · Kanab, UTThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA320Accident · No injuriesData collectionFinal reportPiper PA 12 · Nulato, AKThe pilot’s improper landing flare, which resulted in a hard landing on upsloping terrain, and his subsequent failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack during an attempted go-around, which resulted in…NTSB GAA18CA321Accident · Minor injuriesData collectionFinal reportDehavilland Beaver DHC 2 · Ketchikan, AKThe pilot’s failure to maintain pitch and directional control during a water landing.NTSB ANC18LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna 210 · Ramona, CAThe failure of the engine-driven hydraulic pump due to the installation of improper cap screws, which resulted in a gap in the pump housing, a subsequent hydraulic leak, and the landing gear collapsing.NTSB WPR18WA208Incident · No injuriesForeign investigationPiper PA28 · Pretoria, South AfricaNTSB GAA18CA314Accident · No injuriesData collectionFinal reportSchleicher ASW · Nephi, UTThe glider’s encounter with atmospheric conditions where the lift was not sufficient to maintain flight, which resulted in a hard off-airport landing.NTSB WPR18LA175Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Lewiston, IDThe failure of a hydraulic line in the landing gear system, which resulted in the pilot's inability to lower the gear and a subsequent gear-up landing.NTSB GAA18CA348Accident · No injuriesData collectionFinal reportCessna 172 · Orlando, FLThe pilot’s improper landing flare, which resulted in a bounced, hard landing.NTSB ERA18LA176Accident · No injuriesLimited investigationFinal reportCessna 337 · Atlanta, GAAn area of pitting and corrosion on the surface of the aluminum hydraulic line connecting the emergency handle/pump to the electric hydraulic pump, which resulted in a loss of hydraulic pressure and the pilot’s inability to extend the landing gear.NTSB GAA18CA342Accident · No injuriesData collectionFinal reportBeech D35 · Corona, CAThe pilot’s inadvertent landing gear retraction during the landing roll.NTSB GAA18CA317Accident · No injuriesData collectionFinal reportAeronca 7AC · Vinton, IAThe pilot’s failure to maintain directional control while landing in gusting tailwind conditions.NTSB GAA18CA315Accident · No injuriesData collectionFinal reportJim Green CCX · Couer D'Alene, IDThe pilot’s failure to maintain directional control during landing in gusting wind conditions.NTSB GAA18CA311Accident · Minor injuriesData collectionFinal reportMaule M5 · Lewiston, IDThe pilot’s failure to maintain the runway centerline and his subsequent decision to not perform a go-around, which resulted in the main landing gear contacting tall wheat and a subsequent loss of control.NTSB GAA18CA302Accident · No injuriesData collectionFinal reportTaylorcraft F21 · Payette, IDThe student pilot’s failure to maintain directional control during landing with a crosswind and his subsequent failure to maintain airspeed during an aborted landing, which resulted in a collision with terrain and nose-over.NTSB ANC18LA039Accident · No injuriesLimited investigationFinal reportCessna T182T · Yerington, NVLoss of directional control during landing for reasons that could not be determined based on the available evidence, which resulted in a runway excursion.NTSB GAA18CA305Accident · Minor injuriesData collectionFinal reportZS Delta-Bielsko Wroclaw SZD 36 A Cobra 15 · Hammond, ILThe pilot’s loss of directional control during an off-airport landing and his subsequent failure to maintain clearance from power pole guy wires.NTSB GAA18CA303Accident · No injuriesData collectionFinal reportPiper PA18 · Kenai, AKThe pilot’s failure to maintain directional control during the landing roll with a tailwind.NTSB GAA18CA301Accident · No injuriesData collectionFinal reportEldridge George Skystar Kitfox SER 7 · Weippe, IDThe pilot’s failure to maintain a proper approach altitude, which resulted in a collision with a fence.NTSB GAA18CA326Accident · No injuriesData collectionFinal reportCessna 172 · Westminster, MDThe pilot’s improper landing flare, which resulted in a hard landing.NTSB GAA18CA298Accident · No injuriesData collectionFinal reportGarcia Benigno Baby ACE D · St. Johns, AZThe pilot’s failure to maintain directional control during landing in gusting, quartering tailwind conditions.NTSB GAA18CA297Accident · Minor injuriesData collectionFinal reportPiper PA22 · Start, LAThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB GAA18CA293Accident · No injuriesData collectionFinal reportCessna 150 · Bemidgi, MNThe student pilot’s failure to maintain lateral control of the airplane during the landing roll, which resulted in a side load and subsequent failure of the left main landing gear extension casting.NTSB CEN18RA187Accident · Minor injuriesForeign investigationIsrael Aircraft Industries Gulfstream 200 · Tegucigalpa, HondurasimportNTSB WPR18LA153Accident · No injuriesLimited investigationFinal reportPiper PA24 · San Jose, CAA landing gear retraction during the landing rollout for reasons that could not be determined based on the available evidence.NTSB ERA18LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Sandersville, GAA nose landing gear collapse for reasons that could not be determined based on the available information.NTSB GAA18CA288Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · Marlborough, MAThe pilot’s improper decision to land on a runway that was too short for a safe landing and his subsequent failure to maintain directional control in tailwind conditions.NTSB GAA18CA477Accident · Minor injuriesData collectionFinal reportDavidson, Ronald A. Avid · Moab, UTThe pilot's excessive brake application and delayed remedial action, which resulted in a nose over.NTSB GAA18CA287Accident · No injuriesData collectionFinal reportMaule M 7 · Burnet, TXThe pilot’s failure to maintain directional control during landing in gusting wind conditions and with an incorrect flap configuration.NTSB GAA18CA285Accident · No injuriesData collectionFinal reportCessna 182 · Wickenburg, AZThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN18CA176Accident · Minor injuriesData collectionFinal reportPiper PA 18 · Albuquerque, NMThe pilot's loss of directional control following an encounter with gusty crosswind during landing.NTSB GAA18CA286Accident · No injuriesData collectionFinal reportBoeing A75N1(PT17) · Eden Prairie, MNThe pilot’s failure to maintain directional control during landing in crosswind conditions.NTSB CEN18LA180Accident · Minor injuriesLimited investigationFinal reportRoger G White Glasair · Broomfield, COThe failure of the right brake line, which resulted in a loss of directional control and runway excursion.NTSB CEN18LA178Accident · Minor injuriesClass 3 · LimitedFinal reportPeet Charles Zenith CH 701 · Jackson, WYA total loss of engine power for undetermined reasons, and the pilot’s failure to maintain proper control of the airplane, which led to a hard, bounced landing.NTSB CEN18CA185Accident · No injuriesData collectionFinal reportCessna 120 · Harlan, IAThe pilot’s late go-around during a bounced landing, which led to an aerodynamic stall and impact with terrain.NTSB GAA18CA281Accident · No injuriesData collectionFinal reportPiper PA 32R · Cape Carteret, NCThe pilot’s steep approach, which resulted in a hard landing and the collapse of the landing gear during touchdown.NTSB GAA18CA280Accident · Minor injuriesData collectionFinal reportCessna 172 · Nooksack, WAThe pilot’s improper approach in tailwind conditions, which resulted in long landing and subsequent runway overrun.NTSB GAA18CA279Accident · No injuriesData collectionFinal reportChampion 7ECA · Morrilton, ARThe pilot’s failure to maintain directional control in variable crosswind conditions.NTSB GAA18CA278Accident · No injuriesData collectionFinal reportCessna 170 · Zelienople, PAThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA18CA292Accident · No injuriesData collectionFinal reportPiper PA28 · Merritt Island, FLThe student pilot’s improper landing flare in tailwind conditions, which resulted in a hard landing.NTSB CEN18LA172Accident · Serious injuriesLimited investigationFinal reportWittman D R/Wittman D M RV 6 · Borger, TXThe pilot's failure to maintain airplane control during landing and during the subsequent aborted landing attempt in crosswind conditions.NTSB GAA18CA274Accident · No injuriesData collectionFinal reportPiper PA28 · Wickenburg, AZThe student pilot’s failure to maintain directional control during the landing roll in tailwind conditions.NTSB GAA18CA272Accident · No injuriesData collectionFinal reportCub Crafters CC19 · Mesa, AZThe pilot’s failure to maintain directional control of the airplane during the landing roll.NTSB GAA18CA271Accident · No injuriesData collectionFinal reportCessna P210 · Grass Valley, CAThe pilot’s improper landing flare, which resulted in a long landing and a runway excursion.NTSB CEN18LA163Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Luling, TXThe pilot’s failure to secure the left-wing fuel cap after refueling the airplane, which resulted in a fuel leak on takeoff.NTSB GAA18CA269Accident · No injuriesData collectionFinal reportPiper PA 18-150 · Goose Bay, AKThe student pilot’s failure to maintain directional control during landing with a gusting tailwind.NTSB GAA18CA262Accident · No injuriesData collectionFinal reportCessna 182 · Albuquerque, NMThe pilot’s decision to continue flight in mountainous terrain with downdraft conditions, which necessitated a precautionary landing on unsuitable terrain.NTSB GAA18CA261Accident · Minor injuriesData collectionFinal reportZenair CH 2000 · Naples, FLThe student pilot’s improper landing flare, which resulted in a bounced landing.NTSB ERA18TA144Accident · Serious injuriesFinal reportChristopher Lord ELA 07 Scorpion · Sebring, FLThe pilot's failure to slow the gyroplane and maintain control while exiting the runway.