OpenAirDocs.org

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.

NTSB NYC02LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Argyle, NYThe pilot's improper in-flight decision to land on a contaminated runway. A factor was the contaminated runway.Feb 19, 2002 · N4456J · Substantial damageNTSB DEN02LA026Accident · No injuriesLimited investigationFinal reportBeech B36TC · Englewood, COThe pilot flaring the airplane prematurely, which resulted in a hard landing.Feb 18, 2002 · N6444C · Substantial damageNTSB CHI02LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Hackensack, MNThe pilot's inadequate compensation for the winds conditions which resulted in the failure to maintain directional control of the airplane. Factors associated with the accident were the gusty crosswind conditions and the trees alongside the runway which the…Feb 18, 2002 · N1463F · Substantial damageNTSB CHI02LA078Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Dowagiac, MIThe pilot's inadequate compensation for the wind conditions that resulted in directional control not being maintained during the landing roll. Factors to the accident were the pilot's inadequate in-flight decision to attempt the landing with a gusting 20 knot…Feb 18, 2002 · N66986 · Substantial damageNTSB DEN02LA025Accident · No injuriesLimited investigationFinal reportCessna 172N · Durango, COthe pilot's failure to maintain directional control during the landing roll. Contributing factors were the crosswind and the pilot's fatigue from lack of sleep.Feb 17, 2002 · N4642J · Substantial damageNTSB LAX02LA087Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Beatty, NVThe pilot failed to maintain control of the airplane.Feb 16, 2002 · N9299D · Substantial damageNTSB SEA02LA041Accident · No injuriesLimited investigationFinal reportCessna 180 · Pacific City, ORThe pilot's inadequate compensation for local wind conditions during the landing roll. Factors include unfavorable winds, and a swampy area adjacent to the runway.Feb 15, 2002 · N2434C · Substantial damageNTSB IAD02LA030Accident · Minor injuriesLimited investigationFinal reportKorsch Classic IV · East Moriches, NYThe pilot's improper recovery from a bounced landing, which resulted in a loss of directional control. A contributing factor was the pilot's lack of experience in aircraft type.Feb 14, 2002 · N767PG · Substantial damageNTSB LAX02LA084Accident · No injuriesLimited investigationFinal reportCessna 172S · Glendale, AZThe pilot of the landing airplane failed to maintain directional control resulting in the on-ground collission.Feb 13, 2002 · N299ME · 2 aircraft · Substantial damageNTSB ATL02LA047Accident · No injuriesLimited investigationFinal reportPiper PA -18 · Winter Haven, FLThe pilot's improper flare during an attempted landing on water. A factor was glassy water.Feb 12, 2002 · N8553C · Substantial damageNTSB NYC02FA059Accident · No injuriesField investigationFinal reportMitsubishi MU-300 · Cleveland, OHThe pilot's failure to obtain the proper touch down point on the runway, and the pilot-in-commands failure to initiate a go-round. Factors in the accident were the tailwind condition, the snow-covered runway.Feb 11, 2002 · N541CW · Substantial damageNTSB DEN02LA024Accident · No injuriesLimited investigationFinal reportAviat A-1A · Afton, WYThe pilot's failure to maintain directional control, which resulted in a collision with a snow bank. Contributing factors were the icy runway and the snow bank.Feb 11, 2002 · N29HU · Substantial damageNTSB SEA02LA038Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Creswell, ORThe pilot's failure to maintain directional control on landing resulting in the aircraft leaving the runway environment, crossing a ditch and nosing over. Contributing factors were variable winds reported by the pilot and the ditch.Feb 10, 2002 · N62658 · Substantial damageNTSB NYC02LA058Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Fremont, OHDamage to the right tire, which resulted in a sudden loss of tire pressure and a loss of directional control.Feb 9, 2002 · N2254A · Substantial damageNTSB LAX02LA081Accident · No injuriesLimited investigationFinal reportConrad Pulsar 582 · Prescott, AZThe pilot failed to maintain landing reference speed and aircraft control. A factor was the gusty wind conditions.Feb 9, 2002 · N3218N · Substantial damageNTSB LAX02LA080Accident · No injuriesLimited investigationFinal reportGreat Lakes 2T-1A-1 · San Diego, CAThe pilot failed to maintain directional control after encountering a gust of wind during the landing roll. Factors were the unexpected wind gusts and the soft terrain adjacent to the runway.Feb 9, 2002 · N502GL · Substantial damageNTSB CHI02LA077Accident · No injuriesLimited investigationFinal reportCessna 172 · Manito, ILThe pilot's improper planning and decision and his failure to maintain adequate airspeed, which resulted in a stall and hard landing. The gusting crosswind conditions were a contributing factor.Feb 9, 2002 · N7025A · Substantial damageNTSB NYC02LA057Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Point Pleasant, WVAn inadvertent collision with a deer while landing at dusk. A factor in the accident was the dusk light condition.Feb 8, 2002 · N18325 · Substantial damageNTSB LAX02FA075Accident · No injuriesField investigationFinal reportCessna 525A · Novato, CAThe pilot's failure to achieve the proper touchdown point and his failure to retract the flaps and spoilers during an attempted landing abort, which resulted in a landing overrun. Also causal was the pilot's decision to attempt a landing in wind conditions…Feb 8, 2002 · N288G · Substantial damageNTSB ANC02LA018Accident · No injuriesLimited investigationFinal reportAerospatiale AS350-B · Girdwood, AKThe pilot's failure to maintain adequate distance from a radio antenna during landing. A factor was the presence of an antenna.Feb 7, 2002 · N6080D · Substantial damageNTSB FTW02LA077Accident · No injuriesLimited investigationFinal reportBeech 200 · Camden, ARThe inadvertent stall as the result of the pilot's failure to maintain proper airspeed. A contributing factor was the pilot's use of the approach flaps setting for the landing.Feb 6, 2002 · N93LV · Substantial damageNTSB LAX02LA221Accident · No injuriesLimited investigationFinal reportBeech 58P · Santa Ana, CAthe pilot's failure to remain above the landing Boeing 757's glide path resulting in an encounter with wing tip vortices, a loss of directional control after touchdown, and collision with taxiway signs.Feb 3, 2002 · N4458S · Substantial damageNTSB LAX02LA074Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Hawthorne, CAFailure of the student to maintain directional control of the airplane on the landing rollout and failure of the CFI to adequately supervise the flight. A contributing factor was the decreased tension of the right main landing gear shock cord/bungee.Feb 2, 2002 · N300PS · Substantial damageNTSB CHI02LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Falls City, NEThe deer striking the airplane during landing. A factor relating to this accident was the dark night.Jan 29, 2002 · N56729 · Substantial damageNTSB SEA02LA033Accident · No injuriesLimited investigationFinal reportBeech B-19 · Moses Lake, WAThe instructor's inadequate supervision of the student pilot. Also, the dual student's incorrect use of the fuel selector valve. A factor was the uneven terrain.Jan 28, 2002 · N23849 · Substantial damageNTSB FTW02LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARthe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the sunglare.Jan 28, 2002 · N32194 · Substantial damageNTSB CHI02LA072Accident · No injuriesLimited investigationFinal reportBeech 23 · Salina, KSthe student pilot's improper flare and the CFI failed to take remedial action.Jan 28, 2002 · N841KS · Substantial damageNTSB SEA02LA032Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Eagle Point, ORThe pilot inadvertently failed to retract the landing gear for the water landing and the aircraft nosed over.Jan 27, 2002 · N4379Z · Substantial damageNTSB NYC02LA053Accident · No injuriesLimited investigationFinal reportCessna 172R · Richmond, VAThe pilot's improper recovery from a bounced landing. A factor in the accident was the pilot improper flare.Jan 27, 2002 · N9525V · Substantial damageNTSB NYC02LA052Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Marlborough, MAThe pilot's failure to achieve a proper touchdown point on the runway which resulted in an overrun. A factor was the pilot's lack of experience in short field operations.Jan 26, 2002 · N28239 · Substantial damageNTSB LAX02LA070Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Payson, AZFailure of the pilot to maintain directional control of the airplane. A contributing factor was the premature raising of the flaps.Jan 26, 2002 · N5264R · Substantial damageNTSB CHI02LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Bloomington, INThe pilot's inadequate recovery from a bounced landing which resulted in a hard contact with the runway. Factors associated with the accident were the improper flare and the crosswind condition.Jan 26, 2002 · N350NW · Substantial damageNTSB MIA02LA055Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · Milton, FLThe inability of the pilot to maintain directional control of the airplane resulting in a ground loop. A finding in the investigation was a loose left rudder flight control cable.Jan 22, 2002 · N41686 · Substantial damageNTSB LAX02LA068Accident · No injuriesLimited investigationFinal reportCessna 206H · Mammoth Lakes, CAthe pilot's inadequate compensation for the gusty crosswind conditions, which resulted in a loss of aircraft control and nose over during landing roll.Jan 22, 2002 · N72635 · Substantial damageNTSB CHI02LA068Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Iowa Falls, IAThe pilot's inadequate compensation for the crosswind condition and the subsequent failure to maintain control of the airplane. Factors associated with the accident were the crosswind and the rough terrain encountered.Jan 21, 2002 · N9248D · Substantial damageNTSB NYC02LA050Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Manassas, VAThe pilot's improper autorotation, which resulted in a hard landing and bent airframe support tube. A factor in this accident was previous damage to the airframe support tube.Jan 20, 2002 · N1964J · Substantial damageNTSB MIA02LA056Accident · No injuriesLimited investigationFinal reportMaule M-7-235B · Sarasota, FLThe poor in-flight planning decision by the pilot-in-command for his failure to request the runway most aligned with the wind and his failure to maintain directional control during the landing roll.Jan 20, 2002 · N235AL · Substantial damageNTSB SEA02LA034Accident · No injuriesLimited investigationFinal reportRockwell 500-S · Baker City, ORThe pilot's excessive descent rate at the time the aircraft came in contact with the runway during a night precautionary landing. Factors include extensive airframe ice accumulation, ice accumulation on the flight compartment windshield, ambient conditions…Jan 19, 2002 · N1187G · Substantial damageNTSB CHI02LA064Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Wahoo, NEThe student, who was a private pilot, used excessive braking during the landing roll.Jan 18, 2002 · N71677 · Substantial damageNTSB DEN02LA021Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Logan, UTthe pilot's failure to maintain aircraft control during landing roll. Contributing factors were the runway's patchy snow and ice conditions and a snow bank along the side of the runway.Jan 17, 2002 · N68737 · Substantial damageNTSB ATL02LA040Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bessemer, ALOn ground collision with an animal during landing.Jan 17, 2002 · N6910F · Substantial damageNTSB FTW02LA067Accident · No injuriesLimited investigationFinal reportCessna 172 · Iraan, TXThe pilot's failure to maintain directional control during landing roll. Contributing factors were the pilot's selection of a downwind runway for landing, the tail wind condition, and his lack of total experience in the type of aircraft.Jan 15, 2002 · N509R · Substantial damageNTSB DEN02LA020Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Grand Junction, COthe failure of the tail wheel left steering cable. A contributing factor was the pilot's loss of aircraft control (not possible) and the subsequent inadvertent ground loop.Jan 13, 2002 · N382X · Substantial damageNTSB ATL02LA039Accident · No injuriesLimited investigationFinal reportCessna 172M · Sanford, NCThe pilots failure to maintain directional control during landing roll that resulted in a collision with an airport sign. Factors were wet runway surface and wind gust.Jan 13, 2002 · N9334H · Substantial damageNTSB FTW02LA068Accident · No injuriesLimited investigationFinal reportCessna 172S · Sugar Land, TXthe student pilot's failure to maintain directional control during landing.Jan 12, 2002 · N497SJ · Substantial damageNTSB ATL02LA038Accident · Minor injuriesLimited investigationFinal reportH.S. Mosley Cuby Sport · Panama City, FLThe pilot's inadequate preflight and inflight decisions that resulted the execution of and off-airport landing to rough and uneven terrain where the airplane nosed over during the landing. The pilot did not apply normal breaking during the landing roll.Jan 12, 2002 · N202FL · Substantial damageNTSB ANC02LA009Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's inadequate supervision of the flight. Factors in the accident were the student's failure to maintain directional control of the airplane during the landing roll, icy runway conditions, and snow-covered terrain along the runway edges.Jan 12, 2002 · N9908D · Substantial damageNTSB LAX02LA067Accident · No injuriesLimited investigationFinal reportFarrand Vans RV6 · San Jose, CAFailure of the pilot to sufficiently slow the airplane prior to exiting the runway, which lead to the left main landing gear collapsing and a subsequent ground loop.Jan 10, 2002 · N164DF · Substantial damageNTSB ATL02LA034Accident · No injuriesLimited investigationFinal reportCessna 152 · Clewiston, FLThe student pilot's inadequate compensation for wind, and failure to maintain directional control. A contributing factor was a crosswind.Jan 7, 2002 · N25441 · Substantial damageNTSB LAX02LA062Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Reno, NVThe pilot failed to maintain directional control resulting in an inadvertent ground loop. A contributing factor was the tailwind.Jan 5, 2002 · N83517 · Substantial damage