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 NYC99LA188Accident · No injuriesLimited investigationFinal reportCessna 172R · Cheswold, DEThe pilot's improper flare and improper recovery from a bounced landing.Aug 1, 1999 · N2746C · Substantial damageNTSB CHI99LA274Accident · No injuriesLimited investigationFinal reportNorth American AT-6G · Harlan, IAthe failure of the pilot to maintain directional control of the aircraft during landing. Factors to the accident were the crosswind, the failure of the pilot to maintain compensation for the crosswind condition on approach, and the inadvertent ground loop…Aug 1, 1999 · N98FP · Substantial damageNTSB ANC99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Levelock, AKThe pilot's selection of an unsuitable landing site.Aug 1, 1999 · N693JB · Substantial damageNTSB ANC99LA102Accident · No injuriesLimited investigationFinal reportCessna 180A · Gustavus, AKThe pilot's inadvertent ground loop/swerve.Aug 1, 1999 · N6180 · Substantial damageNTSB SEA99LA140Accident · No injuriesLimited investigationFinal reportCessna T210J · Sequim, WAThe pilot's failure to adequately compensate for the changing wind conditions. Factors include a berm located off the east end of the runway and a tailwind.Jul 31, 1999 · N821SB · Substantial damageNTSB NYC99LA189Accident · No injuriesLimited investigationFinal reportPiper PA24-250 · Greencastle, PAThe pilot's misjudgement of speed and distance during the approach and his failure to perform a go around.Jul 31, 1999 · N5801P · Substantial damageNTSB NYC99LA186Accident · Minor injuriesLimited investigationFinal reportPitts S-2A · Pittstown, NJThe pilot's failure to obtain the proper touchdown point.Jul 31, 1999 · N6PS · Substantial damageNTSB MIA99LA210Accident · No injuriesLimited investigationFinal reportWilderoder Great Lakes 2TIA · Pensacola, FLThe pilot's failure to check the brake hydraulic fluid reservoir prior to flight resulting in a low fluid level going undetected and failure of the brakes during landing rollout, which resulted in the aircraft overrunning the runway, colliding with a fence,…Jul 31, 1999 · N47149 · Substantial damageNTSB CHI99LA265Accident · No injuriesLimited investigationFinal reportCessna 310N · Eden Prairie, MNmaintenance personnel installed washers which were not large enough in diameter to prevent the retraction/extension scissors links from separating from each other.Jul 31, 1999 · N310DE · Substantial damageNTSB ANC99LA116Accident · No injuriesLimited investigationFinal reportCessna 206 · Talkeetna, AKA leak/partial failure of the left main gear brake system. Factors in the accident were a short runway/landing area, and the presence of rocks/boulders at the end of the airstrip.Jul 31, 1999 · N3831G · Substantial damageNTSB MIA99LA207Accident · No injuriesLimited investigationFinal reportCessna 172M · Pierson, FLthe flight instructor's (pilot in command) failure to achieve the proper touch down point, his improper decision to continue the touch and go, and failure to abort the takeoff in sufficient time, resulting in the aircraft overrunning the runway and colliding…Jul 30, 1999 · N9880V · Substantial damageNTSB CHI99LA271Accident · No injuriesLimited investigationFinal reportCessna 180K · Shawano, WIthe failure of the pilot to maintain directional control. Factors were the misjudged flare and improper recovery from the bounced landing by the pilot, and the ditch.Jul 30, 1999 · N4809E · Substantial damageNTSB CHI99FA263Accident · No injuriesField investigationFinal reportUnderwood Brokaw Bullet · Oshkosh, WIthe pilot failed to maintain directional control of the airplane.Jul 29, 1999 · N331TB · Substantial damageNTSB CHI99FA260Accident · No injuriesField investigationFinal reportBurns Pietenpol AIR Camper · Oshkosh, WIthe pilot failed to maintain directional control and ground looped the airplane. Factors included the crosswind and the turbulence from the DC-3.Jul 28, 1999 · N350MB · Substantial damageNTSB FTW99LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Heber Springs, ARThe pilot's excessive approach airspeed resulting in the airplane overrunning the runway, and his failure to maintain aircraft control during the landing roll.Jul 26, 1999 · N7605J · Substantial damageNTSB DEN99LA129Accident · No injuriesLimited investigationFinal reportBoeing A-75-N1 (Stearman) · Tooele, UTThe failure of the right main landing gear tire's inner tube, and the subsequent inadvertent ground loop by the pilot.Jul 26, 1999 · N56772 · Substantial damageNTSB LAX99LA258Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZthe student pilot's premature retraction of the flaps during an aborted landing and his failure to obtain/maintain adequate flying airspeed, which resulted in a stall/mush condition and the airplane settling back onto the ground. The student pilot's failure…Jul 25, 1999 · N5535D · Substantial damageNTSB SEA99LA128Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Spokane, WAThe pilot's failure to maintain directional control. A related factor was the pilot's lack of experience in tailwheel aircraft.Jul 24, 1999 · N80622 · Substantial damageNTSB MIA99LA202Accident · No injuriesLimited investigationFinal reportBeech C23 · Seneca, SCthe pilot misjudged the flare, landed hard, bounced, departed the runway, which resulted in an impact with a ditch and embankment. A factor in this accident was the improper recovery from a bounced landing.Jul 24, 1999 · N63TW · Substantial damageNTSB CHI99LA338Accident · No injuriesLimited investigationFinal reportCessna 182R · Fargo, NDthe pilot misjudged the landing flare which resulted in the airplane porpoising during the landing.Jul 24, 1999 · N9799E · Substantial damageNTSB CHI99LA251Accident · No injuriesLimited investigationFinal reportCessna 180 · Frankfort, MIthe inadequate flare and the go-around not performed by the pilot.Jul 24, 1999 · N9330C · Substantial damageNTSB NYC99LA183Accident · No injuriesLimited investigationFinal reportCessna 172G · Dover, DEThe student pilot's failure to execute a go-around. Factors include excessive airspeed on the final approach, and the student pilot's attempt to land beyond a safe touchdown point.Jul 23, 1999 · N6017R · DestroyedNTSB FTW99LA203Accident · No injuriesLimited investigationFinal reportBeech C23 · Tulsa, OKThe pilot's failure to maintain the proper descent rate, which resulted in a hard landing.Jul 23, 1999 · N6712W · Substantial damageNTSB DEN99LA127Accident · No injuriesLimited investigationFinal reportCessna T210F · Albuquerque, NMThe pilot's inadvertent wheels up landing.Jul 23, 1999 · N6726R · DestroyedNTSB DEN99LA125Accident · Minor injuriesLimited investigationFinal reportCessna 172E · Peyton, COThe pilot's failure to maintain directional control of the aircraft during landing touchdown. Factors were the crosswind and the ditch.Jul 22, 1999 · N5696T · Substantial damageNTSB CHI99LA245Accident · No injuriesLimited investigationFinal reportCessna 172N · Greenville, MIthe student pilot's inadequate use of the rudder which resulted in a loss of directional control during an aborted landing. A factor associated with the accident was the student's lack of total experience and the segmented circle which the airplane contacted.Jul 20, 1999 · N3558E · Substantial damageNTSB ATL99LA115Accident · No injuriesLimited investigationFinal reportBeech 55 · Nashville, TNThe total failure of the nose gear extension and retraction assembly that resulted in the collapse of the nose gear during landing.Jul 20, 1999 · N56AW · Substantial damageNTSB CHI99LA244Accident · No injuriesLimited investigationFinal reportCessna 182N · Green Bay, WIThe pilot's delayed flare and his improper recovery from a bounced landing.Jul 19, 1999 · N92215 · Substantial damageNTSB IAD99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Zanesville, OHThe pilot not maintaining a proper descent rate and an inadequate flare.Jul 18, 1999 · N235TL · Substantial damageNTSB FTW99LA193Accident · No injuriesLimited investigationFinal reportCessna 150M · Beaumont, TXThe student pilot's excessive rate of descent resulting in the hard landing and his improper recovery from a bounced landing.Jul 18, 1999 · N150WM · Substantial damageNTSB CHI99LA259Accident · No injuriesLimited investigationFinal reportCessna 180 · Tower, MNfailure of the operator of the boat to maintain clearance with the floatplane.Jul 18, 1999 · N4636B · Substantial damageNTSB CHI99LA242Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Bristol, WIthe pilot's failure to perform a proper recovery from the bounced landing, resulting in the airplane's nose gear striking the runway. A factor relating to the accident was the excessive airspeed maintained during the landing.Jul 18, 1999 · N2980H · Substantial damageNTSB NYC99LA179Accident · No injuriesLimited investigationFinal reportAllen-Charles Barracuda · Hermon, NYThe pilot's inadequate preflight planning which resulted in a precautionary landing. A factor in this accident was the pilot's selection of unsuitable terrain for the precautionary landing.Jul 17, 1999 · N849JA · Substantial damageNTSB IAD99LA055Accident · No injuriesLimited investigationFinal reportAeronca 11BC · Millbrook, NYwas the pilot's inadequate compensation for winds and his failure to maintain directional control.Jul 17, 1999 · N3756E · Substantial damageNTSB SEA99LA124Accident · No injuriesLimited investigationFinal reportNavion B · Stanley, IDAn improperly planned approach and gusting wind conditions. A tailwind was a factor.Jul 16, 1999 · N5304K · Substantial damageNTSB LAX99LA252Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Taft, CAThe pilot's selection of the wrong runway in consideration of the wind conditions and his subsequent failure to maintain directional control. The pilot's decision to abort the landing attempt with inadequate runway remaining for the takeoff phase was also…Jul 16, 1999 · N46451 · Substantial damageNTSB ATL99LA110Accident · No injuriesLimited investigationFinal reportCessna 172N · Kissimmee, FLThe pilot's improper flare and recovery from a bounced landing.Jul 16, 1999 · N734YU · Substantial damageNTSB NYC99LA177Accident · No injuriesLimited investigationFinal reportAirbus Industrie A-300-600ER · Jamaica, NYimproper use of the flight controls by the captain trainee, and inadequate supervision by the check airman.Jul 15, 1999 · N80057 · Substantial damageNTSB FTW99TA190Accident · Minor injuriesFinal reportHughes 269C · Houston, TXThe hard landing as a result of the flight instructor's failure to attain the proper airspeed before simulating an engine failure, which resulted in the development of a high sink rate. Factors were the night illumination and the soft ground.Jul 15, 1999 · N7491F · Substantial damageNTSB SEA99LA119Accident · No injuriesLimited investigationFinal reportCessna 185 · Renton, WAFailure of the pilot-in-command to maintain directional control after landing, resulting in a ground loop.Jul 14, 1999 · N532PC · Substantial damageNTSB CHI99LA237Accident · No injuriesLimited investigationFinal reportCessna 172L · Montezuma, IAthe pilot inadvertently landed on the wrong runway and exceeded the proper touchdown point on the runway. Factors associated with the accident were the gusty tailwind, the fence, and the ditch.Jul 14, 1999 · N19752 · Substantial damageNTSB CHI99TA232Accident · No injuriesFinal reportHughes OH-6A · Chesterfield, MOthe pilot-in-command's improper autorotational landing.Jul 13, 1999 · N911EP · Substantial damageNTSB CHI99LA241Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Aitkin, MNthe right spring in the tailwheel assembly's separation. Factors were the fatigue in the landing gear, the maintenance personnel not identifying the fatigue during the annual inspection, and the right main gear's separation.Jul 13, 1999 · N96884 · Substantial damageNTSB SEA99LA131Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Snohomish, WABrake system failure due to the presence of air bubbles in the hydraulic fluid.Jul 12, 1999 · N65PR · Substantial damageNTSB NYC99LA174Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hamburg, NYThe pilot's improper recovery from a bounced landing. A related factor was the lack of experience in make and model.Jul 12, 1999 · N42246 · DestroyedNTSB LAX99LA247Accident · Minor injuriesLimited investigationFinal reportRose Velocity 173/FG-E · Santa Monica, CAThe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain runway alignment.Jul 11, 1999 · N137V · Substantial damageNTSB LAX99LA250Accident · No injuriesLimited investigationFinal reportCessna 172M · Fresno, CAThe pilot's misjudged landing flare and inadequate recovery procedures from the subsequent bounced landing.Jul 10, 1999 · N73113 · Substantial damageNTSB LAX99LA249Accident · No injuriesLimited investigationFinal reportCessna 185 · Beckwourth, CAThe pilot's inadequate compensation for the wind conditions and subsequent failure to maintain directional control.Jul 9, 1999 · N6XS · Substantial damageNTSB CHI99LA220Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Sylvania, WIthe misjudged planned approach and the evasive maneuver attempted by the pilot-in-command. A factor was the presence of trees.Jul 9, 1999 · N3209F · Substantial damageNTSB CHI99FA222Accident · 1 fatalField investigationFinal reportCessna 182E · Menominee Falls, WIthe pilots failure to maintain adequate clearance. A factor was the static wire.Jul 9, 1999 · N2899Y · Destroyed