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 FTW92LA044Accident · No injuriesLimited investigationFinal reportHiller-Osborn UH-12D · Rio Medina, TXThe pilot's improper flare during touchdown.Dec 2, 1991 · N67065 · Substantial damageNTSB LAX92LA056Accident · No injuriesLimited investigationFinal reportPiper PA22-150 · Palo Alto, CAThe pilot's failure to maintain directional control during the landing rollout.Dec 1, 1991 · N3170Z · Substantial damageNTSB CHI92LA036Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-200 · Lakeville, MNThe failure of both pilots to maintain visual separation from each other. Contributing factors to this accident were an inadequate visual lookout by both pilots and the pilot-in-command's failure to follow procedures and directives.Dec 1, 1991 · N2072T · 2 aircraft · Substantial damageNTSB ANC92LA018Accident · No injuriesLimited investigationFinal reportCessna 150 · Anchorage, AKThe certified flight instructor's (CFI) delay in initiating the go around. Contributing to the accident was the snow berm and dark night light condition.Dec 1, 1991 · N704YP · Substantial damageNTSB FTW92LA028Accident · No injuriesLimited investigationFinal reportCessna 120 · Las Cruces, NMThe pilot's failure to maintain directional control. A factor was the tailwind.Nov 29, 1991 · N1906N · Substantial damageNTSB CHI92LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Willmar, MNAn inadequate weather evaluation which resulted in flight into icing conditions. Factors in the accident were the icing conditions and the excessive descent during landing.Nov 29, 1991 · N80553 · Substantial damageNTSB LAX92LA053Accident · No injuriesLimited investigationFinal reportCessna 180 · Long Beach, CAThe failure of the pilot to maintain directional control during the landing touchdown.Nov 27, 1991 · N2982A · Substantial damageNTSB FTW92LA027Accident · No injuriesLimited investigationFinal reportCessna R182 · Santa Fe, NMThe right main gear collapsed for undetermined reasons, which resulted in the pilot's loss of directional control during the landing roll.Nov 27, 1991 · N2645C · Substantial damageNTSB DEN92LA010Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Watkins, COFailure to maintain directional control of the airplane during landing flare. A factor was the crosswind condition that existed at the time of the accident.Nov 27, 1991 · N41698 · Substantial damageNTSB FTW92GA036Accident · No injuriesFinal reportBeech C-12C · Belen, NMThe pilot's failure to land at the proper touchdown point.Nov 26, 1991 · N783MC · Substantial damageNTSB FTW92LA034Accident · No injuriesLimited investigationFinal reportCessna 172P · Okmulgee, OKThe pilot's failure to compensate for a crosswind condition. Factors were the pilot's lack of total experience and the prevailing crosswind.Nov 25, 1991 · N65748 · Substantial damageNTSB BFO92LA009Accident · No injuriesLimited investigationFinal reportCessna 150 · Portsmouth, VAThe pilot's improper flare attitude during the landing flare/touchdown and his failure to initiate recovery from a bounced landing.Nov 15, 1991 · N3072V · Substantial damageNTSB ATL92LA023Accident · No injuriesLimited investigationFinal reportGeorga L. Atwood Kitfox III · Trezevant, TNThe pilot's improper handling of the airplane which resulted in a noseover.Nov 13, 1991 · N49GA · Substantial damageNTSB ANC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Stebbins, AKThe pilot's failure to adequately compensate for the wind during landing. Factors were the crosswind and the attempted go aroundNov 8, 1991 · N1685A · Substantial damageNTSB FTW92LA021Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Teresa, NMThe pilot's failure to initiate corrective action in a timely fashion.Nov 7, 1991 · N29348 · Substantial damageNTSB LAX92LA048Accident · No injuriesLimited investigationFinal reportCessna 182H · Fortuna, CAThat the pilot misjudged the flare altitude. Contributing to the accident was the failure of the flight instructor to adequately supervise the flight.Nov 6, 1991 · N3474S · Substantial damageNTSB LAX92LA052Accident · No injuriesLimited investigationFinal reportCessna 195A · Camarillo, CAThe failure of the pilot to maintain directional control during the landing ground roll.Nov 5, 1991 · N195MD · Substantial damageNTSB LAX92LA038Accident · No injuriesLimited investigationFinal reportQuestaire Venture · San Luis Obispo, CAThe pilot's inability to control the aircraft during the landing roll due to a failure of the left brake and nose wheel steering systems. The failure of the brake and steering systems was due to a deterioration of the 'o' ring seals caused by the use of…Nov 2, 1991 · N71T · Substantial damageNTSB LAX92LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Reedley, CAThe student pilot's improper use of the flight controls and his failure to maintain directional control of the aircraft. A contributing factor in the accident was the students lack of total experience.Nov 1, 1991 · N48760 · Substantial damageNTSB ANC92LA012Accident · No injuriesLimited investigationFinal reportCessna 172 · Ekuk, AKThe pilot's improper in flight planning and decision in that he attempted to touchdown too close to the log.Oct 31, 1991 · N46279 · Substantial damageNTSB NYC92LA021Accident · No injuriesLimited investigationFinal reportRobinson R22B · Millville, NJThe pilot's failure to maintain control of the helicopter. A factor related to the accident was the pilot's improper compensation for wind conditions.Oct 30, 1991 · N502TH · Substantial damageNTSB MIA92LA018Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilot's improper flare & failure to recover from a ballooned landing.Oct 28, 1991 · N69250 · Substantial damageNTSB CHI92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bellaire, MIThe pilot's improper remedial action after ballooning during a landing flare. Factors associated with the accident are gusty crosswinds and the pilot's lack of total experience.Oct 28, 1991 · N3795A · Substantial damageNTSB ANC92LA011Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain airspeed.Oct 26, 1991 · N1887A · Substantial damageNTSB NYC92LA018Accident · Serious injuriesLimited investigationFinal reportBoeing 737-4B7 · Boston, MAA latch failure on a door in the aft galley which allowed a liquor kit to roll forward.Oct 23, 1991 · N441US · No damageNTSB NYC92LA014Accident · Serious injuriesLimited investigationFinal reportAerostar Raven S-60 · Trenton, NJExcessive descent rate by the pilot in command. A factor was overloading of the basket.Oct 20, 1991 · N4057H · No damageNTSB FTW92LA018Accident · Minor injuriesLimited investigationFinal reportMahan Hardaway Quickie Q2 · Arcola, TXThe pilot's improper flare and improper recovery from the resultant bounced landing. A factor was the pilot's lack of familiarity with the airplane.Oct 20, 1991 · N82BD · Substantial damageNTSB NYC92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Edgartown, MAImproper recovery from a bounced landing by the pilot. Factors related to the accident were improper use of the flight controls and throttles.Oct 19, 1991 · N14189 · Substantial damageNTSB NYC92LA010Accident · 1 fatalLimited investigationFinal reportBalloon Works Firefly 7 · Webster, NHFailure of the ground crewman (from another Balloon) to recognize the hazardous condition that existed, when the Balloon came in contact with a high voltage power line during a precautionary landing. Factors related to the accident were: the lack of suitable…Oct 19, 1991 · N4051L · Substantial damageNTSB CHI92LA096Accident · Serious injuriesLimited investigationFinal reportCameron N120 · Goshen, INAn improper touchdown by the pilot in command.Oct 19, 1991 · N6092K · No damageNTSB ATL92LA011Accident · No injuriesLimited investigationFinal reportWinchester Thorp T-18 · Walterboro, SCThe student pilot's improper use of the wheel brakes, and the subsequent loss of directional control. Factors in this accident were the student pilot's lack of total flying experience and the pilot-in-command's inadequate supervision of the flight.Oct 19, 1991 · N27DW · Substantial damageNTSB ANC92FA006Accident · No injuriesField investigationFinal reportBeech BE-99 · Allakaket, AKWas the pilot-in-command misjudged the proper touchdown point on the runway. Contributing to the accident was the snow-covered terrain and a snowbank.Oct 19, 1991 · N299GL · Substantial damageNTSB NYC92LA015Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, METhe failure of the nose wheel through bolt as a result of fatigue cracking.Oct 18, 1991 · N6544G · Substantial damageNTSB CHI92LA016Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Warsaw, INPilot's delayed inflight planning/decision to land.Oct 18, 1991 · N357OK · No damageNTSB ANC92LA007Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Scammon Bay, AKThe pilot's failure to maintain airspeed during the aborted landing. Contributing to the accident was the unfavorable wind.Oct 18, 1991 · N7353Q · Substantial damageNTSB LAX92LA018Accident · No injuriesLimited investigationFinal reportSnow S2C · Bowie, AZThe failure of the pilot to maintain directional control after landing. The unfavorable wind condition was a related factor.Oct 17, 1991 · N1625S · Substantial damageNTSB FTW92GA011Accident · No injuriesFinal reportCessna T21OR · Lordsburg, NMThe pilot's improper recovery from a bounced landing. Factors were the pilot's excessive airspeed and improper flare technique.Oct 17, 1991 · N7681U · Substantial damageNTSB SEA92LA008Accident · No injuriesLimited investigationFinal reportMcholland XPA-11 · Sandpoint, IDA poor in-flight decision. Contributing to the accident was the rough/uneven terrain.Oct 14, 1991 · N11XP · Substantial damageNTSB SEA92LA010Accident · No injuriesLimited investigationFinal reportCessna 172C · Colville, WAThe pilot's delayed go-around. Factors contributing to the accident was the pilot's misjudgement of distance and speed during the approach.Oct 13, 1991 · N64475 · Substantial damageNTSB MIA92LA013Accident · No injuriesLimited investigationFinal reportChristen Industries Pitts S-2B · Sebring, FLFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve and collision with tall grass beside the runway. The tall grass was a related factor.Oct 13, 1991 · N69SZ · Substantial damageNTSB ATL92LA005Accident · No injuriesLimited investigationFinal reportCessna 182 · Pinson, ALThe failure of the pilot to visually detect and attain proper alignment with the runway.Oct 13, 1991 · N9342X · Substantial damageNTSB SEA92LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Rawlins, WYAn inadequate weather evaluation. Factors to the accident were: gusts and crosswind.Oct 11, 1991 · N2015B · Substantial damageNTSB ATL92LA004Accident · Serious injuriesLimited investigationFinal reportBeech F33A · Franklin, NCThe pilot's failure to lower the landing gear resulting in a gear up contact with the runway, and the eventual loss of control of the airplane.Oct 11, 1991 · N37MC · Substantial damageNTSB LAX92LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Van Nuys, CAThe student pilot's improper landing flare which resulted in a hard landing and the buckling of the airplane's nose gear.Oct 9, 1991 · N6211Q · Substantial damageNTSB CHI92LA004Accident · No injuriesLimited investigationFinal reportBeech 95 · Elkhart, INThe inadequate amount of hydraulic fluid present in the normal brake system.Oct 9, 1991 · N1309Z · Substantial damageNTSB NYC92LA002Accident · Minor injuriesLimited investigationFinal reportFairchild SA-227AC · Augusta, METhe copilot's failure to attain a proper touchdown point. Factors were the captain's failure to follow company procedure and both pilot's limited experience.Oct 7, 1991 · N120FA · Substantial damageNTSB MIA92LA005Accident · No injuriesLimited investigationFinal reportBell 206-L-1 · Hollywood, FLThe failure of the pilot to maintain rotor RPM and the failure of the CFI to monitor the controls.Oct 6, 1991 · N78CF · Substantial damageNTSB LAX92LA009Accident · No injuriesLimited investigationFinal reportCessna 210 · Riverside, CAThe failure of a hydraulic gear return line, which caused the aircraft's main landing gear to collapse during landing touchdown.Oct 6, 1991 · N9517T · Substantial damageNTSB ANC92LA003Accident · No injuriesLimited investigationFinal reportCessna A185F · Amber Bay, AKThe pilot's loss of directional control during the landing roll. Contributing to the accident was the unfavorable wind.Oct 6, 1991 · N1681R · Substantial damageNTSB LAX92LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Santa Rosa, CAThe failure of the student pilot to maintain control of the aircraft during a recovery from a bounced landing.Oct 4, 1991 · N55394 · Destroyed