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 GAA17CA493Accident · No injuriesData collectionFinal reportBoyd Bruce RV4 · Yerington, NVThe pilot's improper landing flare, which resulted in a bounded landing and subsequent loss of directional control.NTSB ANC17LA046Accident · No injuriesLimited investigationFinal reportThrush S2R · Talkeetna, AKThe pilot's improper landing in the tailwheel-equipped airplane, which allowed an excessive load on the tailwheel and resulted in the subsequent component fracture, loss of control, runway excursion, and impact with terrain.NTSB GAA17CA487Accident · No injuriesData collectionFinal reportPiper PA28 · Chandler, AZThe student pilot's failure to maintain directional control during landing.NTSB GAA17CA486Accident · No injuriesData collectionFinal reportCessna L19 · Nashville, TNThe pilot’s improper landing flare in crosswind conditions, which resulted in a bounced landing, and his subsequent failure to maintain directional control during the landing roll.NTSB GAA17CA485Accident · No injuriesData collectionFinal reportCessna 182 · Sparta, MIThe pilot’s improper landing flare, which resulted in a hard landing.NTSB CEN17LA323Accident · Serious injuriesLimited investigationFinal reportNorth American SNJ-4 · Ashland, OHThe pilot’s improper recovery from a bounced landing, which resulted in a loss of directional control.NTSB GAA17CA484Accident · No injuriesData collectionFinal reportConstrucciones Aeronauticas C.A.S.A. 1.131 · Ocean City, NJThe pilot’s failure to maintain directional control during the landing roll.NTSB GAA17CA506Accident · No injuriesData collectionFinal reportPiper J3C · Camas, WAThe pilot receiving instruction’s failure to maintain directional control during landing.NTSB GAA17CA483Accident · No injuriesData collectionFinal reportRockwell International 114 · Cairo, ILThe pilot's failure to extend the landing gear before landing, which resulted in a gear-up landing and a runway overrun.NTSB GAA17CA478Accident · No injuriesData collectionFinal reportKing John E JR Kitfox · Reno, NVThe pilot’s failure to maintain directional control during landing in variable wind conditions.NTSB DCA17WA175Incident · No injuriesForeign investigationEmbraer EMB135 · Middlemount, AustraliaThe Australian Transport Safety Board (ATSB) has notified the NTSB of a serious incident involving a EMBRAER EMB135 airplane that occurred on August 08, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…NTSB GAA17CA471Accident · No injuriesData collectionFinal reportChampion 7ACA · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll and the flight instructor’s use of excessive braking, which led to a nose-over.NTSB ANC17LA042Accident · No injuriesLimited investigationFinal reportBeech 19A · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the right main landing (MLG) tire impacting a rock and the subsequent loss of directional control and collapse of the right MLG.NTSB GAA17CA490Accident · No injuriesData collectionFinal reportCessna 208 · Mulino, ORThe pilot's improper landing flare, which resulted in a bounced landing.NTSB GAA17CA475Accident · No injuriesData collectionFinal reportCessna 180 · Willow, AKThe pilot’s improper landing flare while landing on water with glassy water conditions, which resulted in the airplane nosing over.NTSB GAA17CA465Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Salisbury, NCThe physical interference of the student pilot’s headset control unit with the canopy, which prevented the canopy latches from seating properly and resulted in the canopy opening in flight and the subsequent hard landing.NTSB DCA17WA165Accident · No injuriesForeign investigationBoeing 737 · Medan, IndonesiaThe KNKT of Indonesia has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on August 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the KNKT's investigation under the provisions of ICAO Annex 13 as…NTSB CEN17LA302Accident · Minor injuriesLimited investigationFinal reportJames F Hake MTO Sport · Mentone, INThe pilot’s failure to maintain a proper touchdown attitude, which resulted in a loss of directional control during the landing roll.NTSB CEN17LA301Accident · No injuriesLimited investigationFinal reportBeech D17S · Colorado Springs, COThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.NTSB ANC17CA041Accident · No injuriesData collectionFinal reportAirbus AS350 · Delta Junction, AKThe pilot’s failure to maintain clearance from a steel frame attached to a tracked drilling unit. Contributing to the accident was the pilot’s failure to visually identify the steel frame during the reconnaissance process.NTSB GAA17CA482Accident · No injuriesData collectionFinal reportCessna 172 · Kearney, NEThe pilot’s failure to maintain directional control of the airplane during the landing roll, which resulted in a runway excursion.NTSB GAA17CA473Accident · No injuriesData collectionFinal reportCessna 180 · Puntilla, AKThe airplane’s encounter with a downdraft while maneuvering at a low altitude, which resulted in the exceedance of the airplane’s critical angle of attack and a subsequent aerodynamic stall.NTSB GAA17CA469Accident · No injuriesData collectionFinal reportAir Tractor AT 402 · San Angelo, TXThe pilot’s failure to maintain directional control during the landing roll in crosswind conditions.NTSB WPR17LA177Accident · No injuriesLimited investigationFinal reportAir Tractor AT 802A · Wells, NVThe pilot's failure to maintain directional control during a period of thermal activity, which led to a runway excursion and impact with terrain.NTSB CEN17LA306Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Denver, COThe pilot’s failure to maintain directional control while landing.NTSB GAA17CA536Accident · Minor injuriesData collectionFinal reportMenzimer Gary Ray Firestar · Westfield, PAThe pilot's improper decision to operate an airplane without recent flight training and his inadvertent application of left electric rudder trim before flight and a subsequent loss of airplane control.NTSB GAA17CA470Accident · No injuriesData collectionFinal reportCessna 172 · Carlsbad, CAThe student pilot’s improper landing flare in gusting wind conditions.NTSB GAA17CA467Accident · Serious injuriesData collectionFinal reportJames D Riggs RV-10 · Lawrenceburg, TNThe pilot’s improper landing flare and failure to maintain yaw control during a go-around in gusting wind conditions.NTSB GAA17CA462Accident · No injuriesData collectionFinal reportChampion 7ECA · Butler, PAThe pilot's failure to maintain directional control during the landing roll in crosswind conditions.NTSB GAA17CA452Accident · No injuriesData collectionFinal reportPiper PA28 · St. Joseph, ILThe pilot’s improper landing flare, which resulted in the nose landing gear collapsing and subsequent loss of directional control.NTSB GAA17CA481Accident · No injuriesData collectionFinal reportMooney M20C · Clearwater, FLThe pilot’s distraction before landing by a helicopter that was transitioning to the airport and his subsequent failure to extend the landing gear before touchdown.NTSB GAA17CA479Accident · No injuriesData collectionFinal reportCessna 172 · Santa Ana, CAA hard landing and propeller strike for reasons that could not be determined based on the available evidence.NTSB GAA17CA460Accident · No injuriesData collectionFinal reportCessna 305 · Eagle Lake, TXThe pilot’s loss of directional control during landing in variable wind conditions.NTSB GAA17CA456Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD 55-1 · Mocksville, NCThe pilot’s improper landing flare in gusting wind conditions.NTSB WPR17LA169Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Enumclaw, WAThe pilot's improper approach for landing, which resulted in the airplane landing long, and his delayed decision to go around with insufficient runway remaining, which resulted in collision with an airport perimeter fence.NTSB GAA17CA457Accident · No injuriesData collectionFinal reportSwearingen SA26 · Hondo, TXThe pilot’s failure to extend the landing gear before landing.NTSB GAA17CA455Accident · No injuriesData collectionFinal reportCessna 150 · McKinney, TXThe student pilot’s improper landing flare, which resulted in bounced landing and the collapse of the nose landing gear.NTSB GAA17CA451Accident · No injuriesData collectionFinal reportMark Goldberg Bearhawk Patrol · Oshkosh, WIThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop.NTSB GAA17CA459Accident · No injuriesData collectionFinal reportRockwell International S 2R · McRae, GAThe pilot’s failure to maintain directional control during the landing roll in tailwind conditions.NTSB GAA17CA445Accident · No injuriesData collectionFinal reportCessna 170 · San Andreas, CAThe pilot’s improper landing flare during an aborted go-around in gusting wind conditions, which resulted in a hard landing.NTSB GAA17CA444Accident · No injuriesData collectionFinal reportMcintosh Donald W Kitfox Series 7 · Priest River, IDThe pilot's failure to maintain lateral/bank control during the landing in variable gusting wind conditions.NTSB GAA17CA442Accident · No injuriesData collectionFinal reportCessna A185 · Nampa, IDThe pilot’s failure to maintain directional control during the landing roll.NTSB ERA17WA294Accident · No injuriesForeign investigationRaytheon Hawker · Mykonos, GreeceOn July 26, 2017, at 0727 Universal Coordinated Time (UTC), a Raytheon Aircraft Company Hawker 850XP, Turkish registration TC-MAN, operated by Genel Havacilik AS, received substantial damage following an abnormal runway contact during landing at Mykonos…NTSB WPR17LA165Accident · No injuriesClass 3 · LimitedFinal reportLake LA 4 · Byron, CAThe pilot’s failure to activate the hydraulic system during the approach, and his failure to ensure that the landing gear was down and locked before touchdown. Contributing to the accident was the pilot's decision to operate the airplane with an inoperative…NTSB DCA17WA156Incident · No injuriesForeign investigationBoeing 737 · Bucharest, RomaniaThe Civil Aviation Safety Investigation and Analysis Center (CASIAC) of Romania has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on July 25, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the…NTSB GAA17CA437Accident · No injuriesData collectionFinal reportCessna 172 · Powell, WYThe student pilot’s improper landing flare and subsequent failure to relinquish the flight controls, which resulted in a hard landing.NTSB CEN17LA282Accident · Serious injuriesLimited investigationFinal reportBeech G35 · Wichita Falls, TXThe flight's encounter with adverse weather conditions at night, which resulted in the pilot's loss of airplane control upon landing due to standing water and a subsequent runway overrun.NTSB GAA17CA443Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G 164B · Berlin, MDThe ground crewman’s failure to visually check the runway before crossing it in a vehicle, which resulted in he and the vehicle being struck by the landing airplane.NTSB GAA17CA441Accident · No injuriesData collectionFinal reportPiper PA18S · Sterling, AKThe pilot’s failure to maintain directional control while landing in crosswind conditions.NTSB GAA17CA432Accident · No injuriesData collectionFinal reportCessna TU206B · Sandy, ORThe pilot’s improper bank control during landing in gusting wind conditions.