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 CHI92LA081Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Minneapolis, MNA misjudged autorotation.NTSB FTW92LA058Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Austin, TXThe pilot's failure to maintain proper altitude. Factors were the pilot descending below the minimum descent altitude and not performing the briefed missed approach procedure along with the dark night, fog, drizzle, and low ceiling.NTSB ATL92LA041Accident · No injuriesLimited investigationFinal reportCessna 172I · Gadsden, ALThe improper recovery from a bounced landing by the pilot under examination, and his subsequent failure to maintain directional control. Inadequate supervision by the designated examiner was a factor.NTSB CHI92LA103Accident · No injuriesLimited investigationFinal reportCessna 182P · Monee, ILThe pilot misjudged the landing flare and touchdown. A related factor was: the dark night light conditions.NTSB SEA92LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-12D · Chehalis, WAThe failure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was the poor braking conditions on the wet grass strip.NTSB BFO92FA020Accident · Serious injuriesField investigationFinal reportDouglas DC-9-30 · Horseheads, NYThe aircraft encountered a sudden wind gust during landing flare, which resulted in a hard landing.NTSB BFO92LA023Accident · No injuriesLimited investigationFinal reportCessna 182-D · Put In Bay, OHThe pilot's failure to maintian directional control during landing. Contributing to the accident were the snow on the runway and the gusty winds.NTSB MIA92LA064Accident · No injuriesLimited investigationFinal reportHughes 369D · Pompano Beach, FLImproper collective input by the pilot-in-command and inadequate supervision by the check pilot.NTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.NTSB BFO92LA018Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Richmond, RIThe pilots failure to maintain directional control during rollout.NTSB ATL92LA037Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Griffin, GAThe excessive speed used by the pilot to land on the short private airstrip. A factor was unfavorable wind.NTSB LAX92LA098Accident · No injuriesLimited investigationFinal reportMooney M20J · Bullhead City, AZThe pilot of the other aircraft inadvertently landing on the taxiway instead of the active runway.NTSB CHI92LA069Accident · No injuriesLimited investigationFinal reportCessna 182 · Lake Elmo, MNThe proper touchdown point was not attained and an aborted landing was delayed by the pilot. A factor related to the accident was the icy runway conditions.NTSB ANC92LA027Accident · No injuriesLimited investigationFinal reportCessna 206 · English Bay, AKThe pilot failed to maintain directional control of the airplane during the landing roll. Contributing factors were the ice and slush on the runway, the snowbank, and the crosswind.NTSB ANC92LA025Accident · No injuriesLimited investigationFinal reportCessna 180 · Atmautluak, AKThe pilot selected unsuitable terrain. Factors contributing to the accident were the dawn light condition and the snow on the runway.NTSB LAX92LA079Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Young, AZThe failure of the pilot to maintain directional control during the landing roll. Contributing to the accident was the soft muddy runway conditions at the dirt airstrip.NTSB BFO92LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Glasgow, KYDeer on the runway. Other related factor ws a dark night.NTSB FTW92LA052Accident · No injuriesLimited investigationFinal reportMaule M-7-235 · Cottonport, LAThe pilot's failure to compensate for wind conditions. A factor was the crosswind.NTSB CHI92LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Greencastle, INThe worn centering locking lug on the nose gear assembly.NTSB FTW92LA051Accident · No injuriesLimited investigationFinal reportCessna 180K · Orange, TXThe ruptured left main gear tire for undetermined reasons.NTSB DEN92LA021Accident · Minor injuriesLimited investigationFinal reportCameron V-77 · Littleton, COThe pilot's improper landing procedure, including wrong compensation for wind conditions and improper use of the envelope dump control. A factor was: high wind.NTSB SEA92LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Stanley, IDThe pilot-in-command's selection of unsuitable terrain (snow covered runway) for landing resulting in a nose over on landing rollout.NTSB LAX92LA077Accident · No injuriesLimited investigationFinal reportPiper PA46-310P · Carson City, NVThe failure of the pilot to arrest an excessive sink rate resulting in not attaining the proper touch down point and landing short of the runway threshold. Contributing to the accident was an excessive runway end lip due to inadequate runway end maintenance.NTSB LAX92LA073Accident · No injuriesLimited investigationFinal reportCessna 150F · Lancaster, CAThe pilot misjudging the landing flare. A factor in the accident was the pilot's lack of total flight experience.NTSB ANC92LA023Accident · Minor injuriesLimited investigationFinal reportPiper PA-31 · Tatitlek, AKThe pilot's failure to perform a go around. Contributing to the accident was the icy runway condition and the failure of the fss personnel to properly issue and disseminate a NOTAM concerning the icy runway condition.NTSB DEN92LA019Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Aurora, COThe pilot failed to maintain control of the aircraft. A factor was: improper supervision by the flight instructor.NTSB LAX92LA069Accident · No injuriesLimited investigationFinal reportGates Learjet Lear 25B · Carlsbad, CAThe pilot not attaining the proper touchdown point because of excessive altitude and airspeed, and the pilot's failure to perform a go-around. A factor in this accident was the rough and uneven terrain which was encountered after the aircraft departed the…NTSB CHI92LA042Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fargo, NDThe pilot's improper interpretation of instructions issued by air traffic control specialist, and the pilot's poor inflight planning and decision(s). Factors associated with the accident are the confusing communications by the air traffic control specialist,…NTSB MIA92LA049Accident · No injuriesLimited investigationFinal reportCessna 172N · Gulfport, MSFailure of the pilot-in-command to perform a go-around and inadvertent stall.NTSB ANC92LA020Accident · No injuriesLimited investigationFinal reportStinson 108 · Chugiak, AKThe pilot failed to maintain proper altitude during the final approach. Contributing to the accident was the pilot's lack of total experience performing landings in reduced light conditions, the poor light condition at dusk, and the snow covered terrain.NTSB CHI92LA055Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Roseau, MNThe pilot's failure to maintain proper alignment with, and not selecting the proper touchdown point on the landing runway. Factors associated with the accident are a dark night light condition and crosswinds.NTSB MIA92IA046Incident · No injuriesIncident investigationFinal reportBoeing 727-223 · St. ThomasPilot-in-command's delayed remedial action to correct for a gust of wind during the landing flare.NTSB CHI92LA057Accident · No injuriesLimited investigationFinal reportCessna 182 · Point Lookout, MOFailure of the pilot to attain the proper touchdown Point and maintain directional control of the aircraft. A factor related to the accident was: a go-around was not performed by the pilot.NTSB NYC92LA046Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Lockport, NYAn inadvertent stall during an attempted go-around by the second pilot. Factors related to the accident were improper use of the flight controls by both pilots and the second pilot's attempted control of the airplane.NTSB FTW92LA040Accident · No injuriesLimited investigationFinal reportBell 206L-3+ · Arlington, TXThe helicopter's autorotational landing performance capability was exceeded. Factors were the proper descent rate was not possible for the PIC and sufficient information from the manufacturer was not provided.NTSB CHI92LA050Accident · No injuriesLimited investigationFinal reportCessna 140 · Minneapolis, MNRemedial action was not performed by the CFI. A factor related to the accident was directional control was not maintained by the student pilot.NTSB MIA92LA041Accident · Minor injuriesLimited investigationFinal reportLogan GN-1 · Quincy, FLThe pilot's improper recovery from a bounced landing that caused the loss of control in flight. A contributing factor was the pilot's lack of total experience.NTSB MIA92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Vero Beach, FLFailure of the pilot to maintain directional control during the landing roll. This resulted in the collision with a sign. Contributing to the accident was his lack of total experience.NTSB CHI92LA082Accident · No injuriesLimited investigationFinal reportCessna 140 · Fairbury, NEThe pilot's improper use of the brakes. An associated factor is the pilot's lack of total experience in the type airplane.NTSB BFO92LA012Accident · No injuriesLimited investigationFinal reportJohn W Upton SA-300 · Leon, WVThe defective welding between the axle and the wheel assembly causing the right main gear to collapse.NTSB ANC92LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Talkeetna, AKThe pilot's improper flare following an aborted takeoff, which resulted in a hard landing and the subsequent loss of control of the airplane. Contributing to the accident was the pilot's lack of total experience in the type of operation.NTSB NYC92LA040Accident · No injuriesLimited investigationFinal reportPiper PA28R-200 · Piqua, OHThe pilot allowed the airplane to get too low on short final and struck the terrain short of the runway. Factors in the accident were the proper glide path was not maintained, resulting in the intended touchdown point not being attained.NTSB LAX92LA060Accident · No injuriesLimited investigationFinal reportCessna 180 · Bakersfield, CAThe pilot's failure to maintain directional control of the aircraft during the landing roll due to inadequate compensation for the existing wind conditions. A factor in the accident was the pilot's lack of total experience.NTSB FTW92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-22 · New Roads, LAThe student pilot's loss of directional control and the resultant ground loop. Factors were the cfi's lack of supervision and the ditch adjacent to the runway.NTSB FTW92LA037Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Southlake, TXThe pilots failure to maintain directional control of the airplane. A factor was improper airspeed prior to touchdown which resulted in a hard landing.NTSB CHI92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-15 · Indianapolis, INRemedial action was not performed by the cfi/pic. A factor related to the accident was directional control was not maintained by the student pilot.NTSB CHI92LA046Accident · No injuriesLimited investigationFinal reportCessna 421 · Wheeling, ILThe pilot's failure to maintain directional control of the airplane during landing. A factor contributing to the accident was the icy runway.NTSB CHI92LA041Accident · No injuriesLimited investigationFinal reportCessna 210N · Frankfort, ILThe failure of the fss to notify ATC that the ariport was closed, atc's subsequent approach clearance to the closed airport, and the pilot's inability to maintain directional control on the icy runway. A factor in the accident was the icy runway conditions.NTSB CHI92LA038Accident · No injuriesLimited investigationFinal reportSwearingen SA-226T · Iowa, IAThe pilot's failure to extend the landing gear which resulted in the propeller blades contacting the runway during the landing. A factor related to the accident was the pilot's failure to follow a checklist during the approach.NTSB SEA92LA025Accident · No injuriesLimited investigationFinal reportSwearingen SA-227-AC · Missoula, MTThe pilot's inability to maintain directional control during takeoff. Factors include a dragging brake.