OpenAirDocs.org

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.

NTSB ERA23LA292Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Suffolk, VAThe pilot’s inadequate landing flare, which resulted in a nose landing gear collapse.Jul 3, 2023 · N716MM · Substantial damageNTSB CEN23LA288Accident · No injuriesClass 4 · LimitedFinal reportAirborne XT 582 · Oregon, ILThe pilot’s failure to maintain directional control after a bounced landing.Jul 3, 2023 · N5613B · Substantial damageNTSB ERA23LA282Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kennesaw, GAThe student pilot’s loss of directional control while landing, which resulted in a runway excursion and collision with an airport sign.Jul 2, 2023 · N734YD · Substantial damageNTSB CEN23LA274Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Durango, COThe pilot’s failure to extend the landing gear before landing.Jul 2, 2023 · N7525P · Substantial damageNTSB WPR23LA273Accident · No injuriesClass 4 · LimitedFinal reportVans RV8 · Metaline Falls, WAThe pilot’s loss of directional control during landing due to impact with a concrete ring embedded in the grass runway.Jul 1, 2023 · N68TP · Substantial damageNTSB WPR23LA253Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Novato, CAThe pilot's failure to maintain directional control of the airplane during the landing roll for a touch and go, which resulted in a collision with terrain.Jun 30, 2023 · N372AH · Substantial damageNTSB WPR23LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna R172E · Alamogordo, NMFailure of the pilot to maintain control of the airplane during the landing.Jun 28, 2023 · N7881N · Substantial damageNTSB WPR23LA246Accident · No injuriesClass 4 · LimitedFinal reportBlack Sheep CCX-1865 · Big Creek Ranger Station, IDThe pilot’s failure to identify the wet landing surface and his subsequent inability to maintain directional control and stop during landing on the unimproved grass runway, which resulted in a runway excursion and unintentional ground loop.Jun 28, 2023 · N510US · Substantial damageNTSB DCA23WA345OccurrenceClass 5 · ForeignBoeing 777 · Dhaka, BangladeshJun 28, 2023 · HZ-AK28 · No damageNTSB DCA23FA339Accident · No injuriesClass 3 · FieldFinal reportBoeing 717-200 · Charlotte, NCA fatigue fracture of the upper lock link that initiated along scratch features on the lower surface at the parting line of the forged aluminum component. Contributing to the accident was the overhaul facilities noncompliance with Service Bulletin 717-32-002.Jun 28, 2023 · N955AT · Substantial damageNTSB GAA23WA201Incident · No injuriesClass 5 · ForeignLearjet 45 · Estado La Guaira, VenezuelaJun 27, 2023 · YV2716 · Minor damageNTSB GAA23WA186Accident · No injuriesClass 5 · ForeignGulfstream II · Zumpango, MexicoJun 27, 2023 · XC-LPY · Substantial damageNTSB ERA23LA289Accident · No injuriesClass 4 · LimitedFinal reportHughes 269A · Anderson, SCThe mechanics’ improper torquing of the main rotor blade dampers, which resulted in a ground resonance event during landing.Jun 27, 2023 · N90270 · Substantial damageNTSB GAA23WA176Accident · Minor injuriesClass 5 · ForeignCessna 182 · Jelenia Góra, PolandJun 25, 2023 · D-EDYP · Substantial damageNTSB ERA23LA295Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron 206B · Sandersville, GAThe pilot’s failure to maintain clearance from trees during landing, which resulted in a tail rotor contact with tree limbs and a subsequent loss of control.Jun 25, 2023 · N919AC · Substantial damageNTSB ERA23LA278Accident · No injuriesClass 4 · LimitedFinal reportGopalan Hariharan 4 Place · Sanford, NCThe pilot’s failure to maintain directional control while landing in a crosswind, which resulted in a nose over.Jun 25, 2023 · N108YZ · Substantial damageNTSB CEN23LA265Accident · No injuriesClass 4 · LimitedFinal reportBearhawk Model 5 · Livingston, TXThe pilot’s failure to maintain directional control during the rollout, which resulted in a runway excursion, and a collision with a building. Contributing to the accident were the obstacles at the airstrip that prevented the pilot from performing a go-around.Jun 25, 2023 · N619MS · Substantial damageNTSB WPR23LA259Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A-1B · Las Vegas, NVThe pilot’s unsafe inflight operation of the airplane and failure to maintain clearance from a person on the ground, which resulted in a serious injury.Jun 24, 2023 · N307F · Minor damageNTSB WPR23LA237Accident · No injuriesClass 4 · LimitedFinal reportCessna 182F · Idaho Falls, IDThe pilot’s failure to maintain directional control while landing with a gusting crosswind.Jun 21, 2023 · N3531Y · Substantial damageNTSB WPR23LA235Accident · No injuriesClass 4 · LimitedFinal reportJohn Topliff PA18-200EXP · Truckee, CAThe pilot’s loss of directional control on landing roll out, during variable wind conditions.Jun 21, 2023 · N356AW · Substantial damageNTSB CEN23LA251Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Osceola, IAThe pilot’s failure to maintain directional control of the tailwheel equipped airplane during a crosswind landing.Jun 21, 2023 · N3127C · Substantial damageNTSB CEN23LA249Accident · No injuriesClass 3 · LimitedFinal reportCessna 175 · Mesquite, TXThe pilot’s inability to maintain directional control during the landing roll due to corroded brake caliper pins.Jun 21, 2023 · N9354B · Substantial damageNTSB CEN23LA252Accident · No injuriesClass 4 · LimitedFinal reportStarduster II · Norwich, NYThe pilot’s loss of directional control during landing rollout due to interference from the pilot’s foot/shoe with the airplane structure that resulted in a runway excursion and impact with terrain.Jun 20, 2023 · N299KD · Substantial damageNTSB ANC23LA044Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Talkeetna, AKA loss of directional control, while landing, due to a flat main landing gear tire.Jun 19, 2023 · N9214C · Substantial damageNTSB CEN23LA244Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-502 · Sturgis, SDThe pilot’s improper timing to initiate beta mode with the propeller and his failure to maintain directional during the full load landing that resulted in a runway excursion. Contributing to the accident was the pilot’s lack of recent experience with…Jun 18, 2023 · N290LA · Substantial damageNTSB WPR23LA238Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Mesa, AZThe student pilot’s improper flare, which resulted in a hard landing.Jun 17, 2023 · N28034 · Substantial damageNTSB ERA23LA291Accident · No injuriesClass 4 · LimitedFinal reportVolato 400 · Dublin, GAThe pilot’s improper landing flare which resulted in a runway undershoot and a hard landing, which substantially damaged the airplane’s firewall.Jun 17, 2023 · PR-ZVL · Substantial damageNTSB CEN23LA242Accident · Minor injuriesClass 4 · LimitedFinal reportTipton Kitfox Kitfox IV · Odessa, MOThe pilot’s failure to attain the proper touchdown speed, which resulted in a runway excursion and subsequent nose over.Jun 17, 2023 · N4287Y · Substantial damageNTSB ERA23LA281Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Indian Trail, NCA loss of control during the landing roll due to a brake failure for reasons that could not be determined based on available evidence.Jun 16, 2023 · N3662Z · Substantial damageNTSB CEN23LA243Accident · No injuriesClass 4 · LimitedFinal reportBeech 95 · Edna, TXThe pilot’s failure to maintain directional control during a precautionary off-field landing.Jun 15, 2023 · N99PL · Substantial damageNTSB CEN23LA241Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401B · Holyoke, COThe pilot's failure to maintain directional control during the landing roll.Jun 15, 2023 · N6106U · Substantial damageNTSB WPR23LA230Accident · Serious injuriesClass 4 · LimitedFinal reportVans RV6A · Mimbres, NMThe pilot’s inflight loss of control while landing with wind gusts that resulted in a hard landing and subsequent nose over.Jun 11, 2023 · N60605 · Substantial damageNTSB WPR23LA234Accident · No injuriesClass 4 · LimitedFinal reportCessna P210N · Olivehurst, CAThe pilot’s failure to extend the landing gear before landing.Jun 10, 2023 · N4761A · Substantial damageNTSB WPR23LA224Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Agness, ORThe pilot’s failure to maintain sufficient airspeed and decision to touch down on the surface of the water, resulting in a nose over.Jun 10, 2023 · N1778C · Substantial damageNTSB CEN23LA253Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Watkins, COThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize the prelanding checklist to ensure the landing gear was extended before landing.Jun 10, 2023 · N6886P · Substantial damageNTSB WPR23LA228Accident · No injuriesClass 4 · LimitedFinal reportBenoit Leclair Rans S-7S · Bryce Canyon, UTThe pilot's failure to maintain control of the airplane during the landing roll and subsequent impact with terrain during go-around.Jun 9, 2023 · N56QC · Substantial damageNTSB WPR23LA227Accident · No injuriesClass 4 · LimitedFinal reportCamille E Patch Calidus · Jerome, IDThe pilot’s failure to maintain directional control during landing, which resulted in rollover.Jun 9, 2023 · N800YA · Substantial damageNTSB CEN23LA235Accident · No injuriesClass 4 · LimitedFinal reportNorth American T-6G · Colorado Springs, COThe pilot’s failure to maintain directional control during landing.Jun 9, 2023 · N16JV · Substantial damageNTSB WPR23LA220Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Nephi, UTA total loss of engine power due to fuel contamination as a result of the inadequate removal of fuel system corrosion during previous maintenance.Jun 8, 2023 · N7318Y · Substantial damageNTSB CEN23LA236Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Stevens Point, WIThe pilot’s failure to maintain directional control during landing that resulted in a ground loop and impact with the runway.Jun 8, 2023 · N223WH · Substantial damageNTSB ERA23LA261Accident · No injuriesClass 3 · LimitedFinal reportDassault-Breguet Falcon 10 · Panama City, FLThe flight crew’s failure to appropriately configure the airplane for landing, which resulted in a failed attempt to utilize the thrust reversers during landing and the inability to stop the airplane using its brakes due to increased forward thrust.…Jun 7, 2023 · N87RT · Substantial damageNTSB WPR23LA216Accident · No injuriesClass 3 · LimitedFinal reportCessna 172R · Santa Monica, CAA failure of the nose wheel upper torque link bolt, which resulted in a loss of steering control. Contributing to the accident were maintenance personnel’s failure to inspect and replace the fractured bolt and the pilot’s oversight of the bolt during his…Jun 5, 2023 · N819KS · Substantial damageNTSB CEN23LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Salem, WIThe pilot’s improper landing flare, which resulted in a hard landing and the left main landing gear collapse.Jun 5, 2023 · N42220 · Substantial damageNTSB ANC23LA040Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Anchorage, AKThe pilot's excessive braking during landing on a sand bar, which resulted in a nose over.Jun 4, 2023 · N83330 · Substantial damageNTSB WPR23LA362Accident · No injuriesClass 4 · LimitedFinal reportLet L-23 Super Blanik · Minden, NVThe pilot’s failure to maintain directional control during the landing roll, resulting in an impact with a taxiway sign.Jun 3, 2023 · N438BA · Substantial damageNTSB WPR23LA210Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Prescott, AZThe pilot’s improper landing flare, which resulted in an aerodynamic stall. Contributing to the accident was his delayed decision to initiate a go-around.Jun 3, 2023 · N249K · Substantial damageNTSB CEN23LA230Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Rutherfordton, NCThe disengagement of the tailwheel locking mechanism during the landing roll which resulted in a loss of directional control during landing with a crosswind.Jun 3, 2023 · N5068X · Substantial damageNTSB CEN23LA222Accident · No injuriesClass 4 · LimitedFinal reportPitts S-2S · Garden Plain, KSThe pilot’s inability to maintain directional control during landing roll due to a flat tire.Jun 3, 2023 · N1PW · Substantial damageNTSB CEN23LA227Accident · Serious injuriesClass 3 · LimitedFinal reportKolb Twinstar · Starbuck, MNThe pilot’s improper landing flare and hard landing, which resulted in the left axle fracturing from bending overstress.Jun 2, 2023 · N1025T · Substantial damageNTSB WPR23LA269Accident · Minor injuriesClass 3 · LimitedFinal reportCSP Leasing MTO Sport · Gardiner, MTFailure of the rudder/nosewheel steering system for reasons that could not be determined, which resulted in loss of yaw control and a subsequent rollover.Jun 1, 2023 · N207AG · Substantial damage