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 CEN22LA329Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Saint Joseph, ILThe pilot’s failure to remain clear of obstacles while landing.Jul 19, 2022 · N9688Q · Substantial damageNTSB CEN22LA326Accident · No injuriesClass 4 · LimitedFinal reportHelicopteres Guimbal Cabri G2 · Madison, ILLoss of tail rotor effectiveness resulting in an in-flight loss of control.Jul 19, 2022 · N457PA · Substantial damageNTSB ERA22LA336Accident · Minor injuriesClass 4 · LimitedFinal reportBellanca 7KCAB · East Haddam, CTThe pilot's failure to maintain directional control during the landing.Jul 17, 2022 · N8680V · Substantial damageNTSB ERA22LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Hanson, MAThe pilot’s improper landing flare, which resulted in a hard landing and partial loss of directional control. Contributing to the accident was the pilot’s improper decision to depart and land with a known mechanical deficiency with the nose landing gear.Jul 17, 2022 · N5859E · Substantial damageNTSB ERA22LA324Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Lawrenceville, GAThe student pilot’s failure to maintain directional control while landing with a crosswind.Jul 17, 2022 · N62405 · Substantial damageNTSB ERA22LA367Accident · Minor injuriesClass 4 · LimitedFinal reportVickers-Slingsby T65A · Butler, GAThe pilot’s retraction the landing gear just prior to touchdown on the runway.Jul 16, 2022 · N157HH · Substantial damageNTSB CEN22LA325Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 305A · Mc Kinney, TXThe failure of the pilot to maintain adequate airspeed during landing resulting in an inadvertent aerodynamic stall.Jul 15, 2022 · N5292G · Substantial damageNTSB ANC22LA060Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F21 · Kenai, AKThe pilot’s failure to maintain adequate distance from a tree while landing.Jul 15, 2022 · N2005Z · Substantial damageNTSB ANC22LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Port Alsworth, AKThe pilot’s excessive use of brakes which resulted in a nose-over.Jul 15, 2022 · N14LD · Substantial damageNTSB ANC22LA057Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Lake Louise, AKThe pilot's failure to maintain a proper glide path, which resulted in a hard landing short of the airstrip.Jul 15, 2022 · N3980T · Substantial damageNTSB ANC22LA056Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot's failure to maintain control of the airplane during taxi operations on a riverbank with shallow water.Jul 15, 2022 · N4040W · Substantial damageNTSB WPR22LA252Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · San Martin, CAThe pilot’s failure to maintain directional control during landing.Jul 14, 2022 · N9802E · Substantial damageNTSB WPR22LA251Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 208B · Salt Lake City, UTThe pilot’s inability to maintain control of the airplane when it encountered a microburst during a landing attempt and a go-around near known thunderstorm activity. Contributing to the accident was an inadequate amount of wind sensors and wind shear…Jul 14, 2022 · N877FE · Substantial damageNTSB ERA22LA316Accident · No injuriesClass 4 · LimitedFinal reportCessna P337H · Monongahela, PAThe malfunction of the braking system fluid line, which resulted in an overrun of the runway.Jul 14, 2022 · N5GY · Substantial damageNTSB WPR22LA272Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-60-601P · Scappoose, WAThe pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot’s failure to utilize a prelanding checklist.Jul 13, 2022 · N601NG · Substantial damageNTSB GAA22WA236Accident · No injuriesClass 3 · ForeignGulfstream GIV · Jeddah, Saudi ArabiaJul 13, 2022 · HZ-A23 · Substantial damageNTSB WPR22LA260Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Kelso, WAThe student pilot’s inadequate flare resulting in a loss of airplane control during landing with gusting wind conditions.Jul 12, 2022 · N43037 · Substantial damageNTSB ERA22LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Hillsboro, OHThe pilot's loss of directional control while landing, which resulted in a runway excursion.Jul 12, 2022 · N49189 · Substantial damageNTSB CEN22LA316Accident · Minor injuriesClass 4 · LimitedFinal reportPiper/Cub Crafters PA-18-150 · Llano, TXThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.Jul 12, 2022 · N131WK · Substantial damageNTSB WPR22LA244Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7GCBC · Afton, WYThe pilot's inadequate flare and bounced landing which resulted in loss of directional control of the airplane during the landing roll.Jul 10, 2022 · N50678 · Substantial damageNTSB GAA23WA010IncidentClass 5 · ForeignBeech 400A · Cornwall, United KingdomJul 10, 2022 · N709ELNTSB ERA22LA359Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-22-150 · Fitchburg, MAThe pilot's loss of directional control while landing, which resulted in a ground loop.Jul 10, 2022 · N5915D · Substantial damageNTSB CEN22LA319Accident · No injuriesClass 4 · LimitedFinal reportSchleicher ASW-19B · Elbert, COThe pilot’s misidentification of the runway during the visual approach which resulted in an off runway landing and impact with a trailer.Jul 10, 2022 · N53JC · Substantial damageNTSB GAA22WA230Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Oktyabsky, RussiaJul 9, 2022 · RA-04373 · Substantial damageNTSB ERA22LA305Accident · No injuriesClass 4 · LimitedFinal reportDuffy Russell A Slingshot · Shirley, NYThe pilot’s failure to maintain adequate airspeed during landing leading to an aerodynamic stall and subsequent impact with the ground.Jul 9, 2022 · N63RD · Substantial damageNTSB CEN22LA314Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Rogers, ARThe pilot’s failure to establish a stabilize approach criteria during low-level maneuvering to the runway, which resulted in a hard landing and contact with a hay bale.Jul 9, 2022 · N83552 · Substantial damageNTSB WPR22LA250Accident · No injuriesClass 4 · LimitedFinal reportCessna 172P · Portland, ORThe pilot under instruction’s improper landing flare, and the flight instructor’s delayed remedial action.Jul 8, 2022 · N90558 · Substantial damageNTSB ERA22LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172M · South Portland, METhe student pilot’s improper landing flare, which resulted in a hard landing. Also causal was the flight instructor’s inadequate remedial action.Jul 8, 2022 · N9946Q · Substantial damageNTSB WPR22LA248Accident · No injuriesClass 3 · LimitedFinal reportCessna T210R · Stanley, IDThe pilot’s failure to provide adequate braking during a tailwind landing, which resulted in a runway excursion.Jul 7, 2022 · N6353U · Substantial damageNTSB ANC22LA054Accident · No injuriesClass 4 · LimitedFinal reportCessna 182D · McGrath, AKA nose landing gear collapse during landing for reasons that could not be determined based on the available information.Jul 6, 2022 · N8754X · Substantial damageNTSB ANC22LA052Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cordova, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing, which resulted in an aerodynamic stall and impact with terrain.Jul 6, 2022 · N2588P · Substantial damageNTSB ERA22LA311Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Livingston, TNThe pilot’s improper flare, which resulted in a hard landing.Jul 5, 2022 · N955V · Substantial damageNTSB ERA22LA299Accident · Serious injuriesClass 4 · LimitedFinal reportArnold J/Jones D L AIR CAM · Sebring, FLThe pilot’s loss of control during landing.Jul 3, 2022 · N6272Z · Substantial damageNTSB DCA22LA151Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737-700 · Santa Ana, CAA flight attendant received a serious injury for undetermined reasons during a firm landing.Jul 2, 2022 · N480WN · No damageNTSB GAA22WA224Accident · No injuriesClass 5 · ForeignRobinson R44 · Novy township, RussiaJul 1, 2022 · RA-06228 · Substantial damageNTSB CEN22LA302Accident · Minor injuriesClass 4 · LimitedFinal reportPitts S1 · Sturgeon Bay, WIThe pilot’s failure to maintain airplane control during landing, which resulted in a runway excursion and nose over. Contributing to the accident was the pilot’s inadequate preflight inspection and the pilot’s lack of flight control system knowledge.Jul 1, 2022 · N23RS · Substantial damageNTSB CEN22LA295Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-135 · Walker, MNThe pilot’s failure to maintain directional control during landing. Contributing to the accident was the flight instructor’s delayed remedial action during a go-around.Jul 1, 2022 · N1136 · Substantial damageNTSB ANC22LA059Accident · No injuriesClass 4 · LimitedFinal reportKakeldey Ronald O Smith PA12 EXP · Beluga, AKThe pilot’s loss of control during the landing roll.Jul 1, 2022 · N73AK · Substantial damageNTSB ERA22LA342Accident · No injuriesClass 4 · LimitedFinal reportMesserschmitt-Boelkow-Blohm BO_105S · Daytona Beach, FLThe pilot’s rapid reduction of collective following an in-flight loss of control while lifting from a dolly resulting in a hard landing. Contributing to the loss of control was the pilot’s likely inadequate left anti-torque control pedal input during initial…Jun 30, 2022 · N160TH · Substantial damageNTSB CEN22LA294Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Idabel, OKThe pilot’s failure to apply full power during the practice autorotation recovery, which resulted in a hard landing.Jun 30, 2022 · N378JC · Substantial damageNTSB ERA22LA296Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Knoxville, TNThe inadequate maintenance of the left main landing gear through bolt, which resulted in a left main landing gear collapse and subsequent runway excursion during landing.Jun 28, 2022 · N721SD · Substantial damageNTSB WPR22LA233Accident · No injuriesClass 4 · LimitedFinal reportGMK Ventures AL18 · Moab, UTThe pilot’s failure to maintain directional control during a landing attempt, which resulted in a ground loop and collision with terrain. Contributing to the accident was the absence of an airspeed indicator due to an alternator failure.Jun 27, 2022 · N17GK · Substantial damageNTSB CEN22LA292Accident · No injuriesClass 4 · LimitedFinal reportMagnaghi Aeronautica SKY Arrow LSA · West Lafayette, INThe pilot’s failure to maintain proper airspeed while landing in gusting winds, which resulted in a hard landing and a runway excursion.Jun 27, 2022 · N458SA · Substantial damageNTSB CEN22LA306Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Cleveland, MSThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and substantial damage.Jun 26, 2022 · N97789 · Substantial damageNTSB ERA22LA306Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24 · New Shoreham, RIThe pilot’s failure to attain a proper touchdown point, resulting in a runway excursion.Jun 25, 2022 · N7883P · Substantial damageNTSB DCA22WA137Incident · No injuriesClass 5 · Foreign737 800 · Cairo, EgyptJun 25, 2022 · SU-GCZ · Minor damageNTSB DCA22WA136Incident · No injuriesClass 5 · Foreign737 800 · Dubrovnik, CroatiaJun 25, 2022 · G-JZBC · Minor damageNTSB WPR22LA226Accident · No injuriesClass 3 · LimitedFinal reportCessna TR182 · Santa Barbara, CAA failure of the right main landing gear actuator pressure line O-ring, which resulted in a gear-up landing on the runway.Jun 24, 2022 · N738JZ · Substantial damageNTSB WPR22LA224Accident · No injuriesClass 4 · LimitedFinal reportRobert Fitts Fitts CUB · Hillsboro, ORThe pilot’s failure to maintain directional control during landing in gusting wind.Jun 23, 2022 · N8576F · Substantial damageNTSB GAA22WA207Accident · No injuriesClass 5 · ForeignPiper PA-23-250 · The Settlement, British Virgin IslandsJun 23, 2022 · N13987 · Substantial damage