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 FTW02TA007Accident · No injuriesFinal reportCessna A185F · Houma, LAthe pilot's high flare, which resulted in a hard landing.Oct 3, 2001 · N727 · Substantial damageNTSB SEA01LA177Accident · No injuriesLimited investigationFinal reportCessna 172RG · Newberg, ORThe pilot's failure to lower the landing gear. A factor was the pilot's failure to follow checklist procedures.Sep 30, 2001 · N6515R · Substantial damageNTSB NYC01LA231Accident · No injuriesLimited investigationFinal reportLet 33 · Bardstown, KYThe pilot's improper flare, which resulted in a nose-first, hard touchdown.Sep 30, 2001 · N3301L · Substantial damageNTSB MIA01LA234Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Melbourne, FLthe pilot's failure to maintain directional control of the aircraft during the landing rollout while landing in gusty crosswind conditions, which resulted in a ground swerve, and the aircraft exiting the runway and incurring substantial damage when it…Sep 30, 2001 · N5447F · Substantial damageNTSB FTW01LA213Accident · Serious injuriesLimited investigationFinal reportCameron Balloon N-77 · McKinney, TXthe pilot's failure to maintain clearance with the fence while landing. A contributing factor was the high wind condition.Sep 29, 2001 · N60206 · No damageNTSB NYC01LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Wildwood, NJthe pilot's inadequate compensation for wind conditions. Factors were the crosswind and the gusts.Sep 28, 2001 · N3465D · Substantial damageNTSB CHI01LA333Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Duluth, MNThe pilots failure to maintain directional control during the landing. Factors were the crosswind and the soft terrain.Sep 28, 2001 · N653C · Substantial damageNTSB ANC01LA150Accident · No injuriesLimited investigationFinal reportSlepcev Storch SS-MK4 · Anchorage, AKThe pilot's failure to maintain directional control and an inadvertent ground loop/swerve during the landing roll.Sep 28, 2001 · N69UP · Substantial damageNTSB MIA01LA231Accident · No injuriesLimited investigationFinal reportBell OH-58A · Sevierville, TNThe failure of the pilot to maintain control of the helicopter while approach to land resulting in a hard landing, a tail rotor ground strike, and the main rotor striking the tail boom.Sep 27, 2001 · N923MC · Substantial damageNTSB DEN01LA164Accident · No injuriesLimited investigationFinal reportCessna 172RG · Englewood, COthe failure of the dual student to verify that the landing gear was down and locked, and the failure of the flight instructor to adequately supervise the dual student.Sep 27, 2001 · N9320D · Substantial damageNTSB CHI01LA326Accident · No injuriesLimited investigationFinal reportCessna 208 · Aurora, MNThe pilot not maintaining the proper descent rate during the landing. Factors were the flap's popped circuit breaker, the pilot not verifying the flap's position, the glassy water, and the dock.Sep 27, 2001 · N12712 · Substantial damageNTSB SEA01LA174Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDThe pilot's inadequate compensation for wind conditions. A factor was variable winds.Sep 26, 2001 · N224H · Substantial damageNTSB CHI01LA330Accident · No injuriesLimited investigationFinal reportColonial C-2 · Faribault, MNThe failure of the landing gear shock strut.Sep 26, 2001 · N273B · Substantial damageNTSB ANC01LA146Accident · Minor injuriesLimited investigationFinal reportDouglas DC-6B · Nuiqsut, AKThe flightcrew's continued use of an unstabilized GPS approach. Factors associated with the accident were low ceilings, and the inadequate coordination between the crew.Sep 26, 2001 · N867TA · Substantial damageNTSB CHI01LA321Accident · No injuriesLimited investigationFinal reportBoeing Stearman B75N1 · Carbondale, ILThe pilot misjudged the proper alignment with the landing area. Contributing to the accident was the light conditions.Sep 23, 2001 · N47964 · Substantial damageNTSB NYC01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Kenton, OHThe pilot's failure to stop the airplane within the available runway. Factors included the uneven braking and the pilot's lack of experience in airplane make and model.Sep 22, 2001 · N7630D · Substantial damageNTSB ANC01LA145Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Tanana, AKAn unlocked landing gear mechanism during landing roll. A factor associated with the accident was an electrical system failure.Sep 22, 2001 · N4352F · Substantial damageNTSB ANC01LA144Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Mentasta, AKThe pilot's inadequate compensation for wind conditions while landing. Factors associated with the accident were the pilot's inadequate recovery from a bounced landing, and a variable wind.Sep 22, 2001 · N8943 · Substantial damageNTSB ATL01LA112Accident · No injuriesLimited investigationFinal reportCessna 210K · Bessemer, ALFailure of the landing gear-down lock mechanism, which resulted in the pilot's inability to control the airplane. A factor was the trees.Sep 18, 2001 · N9455M · Substantial damageNTSB CHI01LA315Accident · No injuriesLimited investigationFinal reportCessna 182M · Marshall, WIThe pilot misjudged his altitude and airspeed and landed long. A factor was the wet grass.Sep 11, 2001 · N92071 · Substantial damageNTSB ATL01LA113Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Punta Gorda, FLThe pilot's improper flare which resulted in a hard landing and subsequent collapse of the landing gear..Sep 9, 2001 · N4070E · Substantial damageNTSB ANC01LA139Accident · No injuriesLimited investigationFinal reportEurocopter AS 350 BA · Skagway, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and snow-covered terrain.Sep 9, 2001 · N60809 · Substantial damageNTSB NYC01LA225Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-35 · Cumberland, MDThe pilot misjudged distance and altitude. A factor was the pilot's lack of familiarity with the glider.Sep 8, 2001 · N2540H · Substantial damageNTSB DEN01LA160Accident · No injuriesLimited investigationFinal reportCessna 177RG · St. George, UTbrake system failure for reasons undetermined, which resulted in a loss of control on landing.Sep 8, 2001 · N52043 · Substantial damageNTSB MIA01LA230Accident · No injuriesLimited investigationFinal reportCessna 150M · Ormond Beach, FLthe student pilot's improper landing flare/touchdown while attempting to make a soft field landing during a supervised solo flight which resulted in substantial damage to the aircraftSep 5, 2001 · N704KK · Substantial damageNTSB ANC01LA133Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Tok, AKThe pilot's failure to abort the landing. Factors associated with the accident were the pilot's selection of an unsuitable landing area, and his failure to attain a proper touchdown point. An additional factor was a ditch.Sep 4, 2001 · N5129Y · Substantial damageNTSB LAX01LA301Accident · No injuriesLimited investigationFinal reportBellanca 7GCAA · Bridgeport, CAThe failure of the pilot to maintain directional control of the tail wheel equipped aircraft during landing roll which resulted in a ground loop.Sep 2, 2001 · N5042D · Substantial damageNTSB IAD01LA103Accident · No injuriesLimited investigationFinal reportCessna U206G · Millersburg, OHThe pilot's misjudgment of speed and distance, which resulted in an overrun during landing. Factors were the short, wet, grass runway, and his failure to do a go-around.Sep 2, 2001 · N579LD · Substantial damageNTSB DEN01LA158Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B-15 · Colo. Springs, COthe passenger's failure to follow instructions given to brace for a high wind landing, and the pilot's failure to adequately monitor the passenger's actions. A contributing factor was the thermal lift.Sep 2, 2001 · N2575P · Minor damageNTSB CHI01LA306Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Pierre, SDThe pilot not maintaining directional control of the airplane during landing.Sep 2, 2001 · N4215Y · Substantial damageNTSB CHI01LA301Accident · No injuriesLimited investigationFinal reportCessna 150L · Madison, WIThe deer which struck the empennage of the airplane during the landing flare.Sep 1, 2001 · N19302 · Substantial damageNTSB CHI01LA299Accident · No injuriesLimited investigationFinal reportBeech 58P · Theodosia, MODiminished braking action due to standing water on the runway. A factor associated with the accident was the ditch which the airplane contacted.Sep 1, 2001 · N6412X · Substantial damageNTSB ANC01LA132Accident · No injuriesLimited investigationFinal reportCessna 177RG · Fairbanks, AKThe pilot's failure to extend the landing gear.Aug 31, 2001 · N45367 · Substantial damageNTSB CHI01LA307Accident · No injuriesLimited investigationFinal reportCessna 182RG · Manhattan, KSthe instructor pilot allowing an excessive descent rate to develop and not correcting the excessive descent rate.Aug 30, 2001 · N9984C · Substantial damageNTSB SEA01LA162Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Shelton, WAThe binding/grabbing of the right main gear braking system during the landing roll.Aug 29, 2001 · N53411 · Substantial damageNTSB LAX01LA292Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Mesa, AZThe pilot's improper autorotation in that he failed to attain the proper descent rate resulting in a hard landing and subsequent airframe damage. A factor was the high temperature.Aug 28, 2001 · N995PM · Substantial damageNTSB ATL01LA096Accident · No injuriesLimited investigationFinal reportCessna R172K · Valdosta, GAThe flight instructor's improper flare of the airplane, which resulted in a hard landing. Factors were the dual student's failure to relinquish control of the airplane and the dual student's interference on the flight controls.Aug 27, 2001 · N758BW · Substantial damageNTSB NYC01LA219Accident · No injuriesLimited investigationFinal reportCessna 172M · Danbury, CTAn inoperative airspeed indicator and the pilot's improper recovery from the bounced landing.Aug 26, 2001 · N9869Q · Substantial damageNTSB LAX01LA293Accident · No injuriesLimited investigationFinal reportChampion 7FC · Reno, NVThe failure of the pilot to maintain directional control during the landing roll.Aug 25, 2001 · N9857B · Substantial damageNTSB IAD01LA105Accident · No injuriesLimited investigationFinal reportBeech 19 · Augusta, METhe student pilot's improper flare, which resulted in a hard landing.Aug 25, 2001 · N2009A · Substantial damageNTSB CHI01FA292Accident · Minor injuriesField investigationFinal reportBoeing 737-3G7 · Kansas City, MOThe second in command failed to maintain proper runway alignment, directional control, and landed long. The pilot in command failed to execute a go-around and failed to provide adequate supervision. Additional factors included the thunderstorm, the dark…Aug 25, 2001 · N306AW · Substantial damageNTSB ATL01LA102Accident · No injuriesLimited investigationFinal reportBeech 55 · Jacksonville, FLThe failure of the left landing gear extention rod for undetermined reasons that resulted in a landing with the gear retracted.Aug 25, 2001 · N521U · Substantial damageNTSB NYC01LA216Accident · No injuriesLimited investigationFinal reportCessna 182R · Elizabethtown, KYThe pilot's improper decision to fly the airplane with a known deficiency, and his inflight decision to land with a quartering tailwind. A factor was the wing maintenance officer's concurrence to fly the airplane with the known deficiency.Aug 23, 2001 · N5419E · Substantial damageNTSB DEN01FA151Accident · 2 fatalField investigationFinal reportAviat A-1 · Montrose, COthe pilot's intentional abrupt maneuver immediately after takeoff and the subsequent loss of aircraft control. Contributing factors were high density altitude weather conditions, and the airplane improper weight and balance.Aug 23, 2001 · N8HU · DestroyedNTSB SEA01LA156Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Twin Falls, IDNose over during the landing roll for undetermined reasons.Aug 22, 2001 · N3632T · Substantial damageNTSB CHI01LA282Accident · No injuriesLimited investigationFinal reportHoskins Quickie Q2 · Carbondale, ILThe failure of the tailwheel spring. A factor was the directional control not possible by the pilot.Aug 22, 2001 · N202SH · Substantial damageNTSB ANC01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Sparrevohn, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were rough/uneven terrain, and an overload failure of the main landing gear landing strut.Aug 22, 2001 · N6949B · Substantial damageNTSB MIA01LA227Accident · No injuriesLimited investigationFinal reportCessna 172S · Gadsden, ALthe pilot misjudged the flare, resulting in a hard landing, and impact with the runway.Aug 21, 2001 · N764SP · Substantial damageNTSB LAX01TA284Accident · No injuriesFinal reportAero Commander 500S · Elko, NVThe main landing gear collapsed for undetemined reasons.Aug 21, 2001 · N975AA · Substantial damageNTSB CHI01LA287Accident · No injuriesLimited investigationFinal reportCessna 305 · Vichy, MOThe pilot failed to maintain directional control of the airplane during landing. The crosswind was a factor.Aug 20, 2001 · N432WC · Substantial damage