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 NYC03LA105Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Roanoke, VAThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the gusty wind conditions.May 12, 2003 · CFKLW · Substantial damageNTSB SEA03LA079Accident · No injuriesLimited investigationFinal reportCessna P210N · Boise, IDThe landing gear extension was not performed by the pilot for landing. Contributing factors included the pilot's failure to perform the Before Landing checklist and his unfamiliarity with the landing gear warning horn system.May 10, 2003 · N711BG · Substantial damageNTSB CHI03LA123Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Point Lookout, MOFailure of the pilot to maintain control of the aircraft. Contributing factors were the sudden windshift to a tailwind, the wet runway surface, the lack of available runway overrun area and the rocky, descending embankment.May 10, 2003 · N541U · Substantial damageNTSB SEA03LA080Accident · No injuriesLimited investigationFinal reportAllen SA-300 · Yakima, WADirectional control was not maintained during the landing roll. A steering spring disconnected as a result of a tailwheel shimmy was a factor.May 9, 2003 · N147DA · Substantial damageNTSB DEN03LA078Accident · Minor injuriesLimited investigationFinal reportBell 206-L4 · Aurora, COinadequate infligt planning/decision by the flight crew and the check pilot's failure to initiate remedial action in a timely manner. Contributing factors were the pilot-in-command's inadequate supervision of the check pilot, the check pilot's lack of recency…May 8, 2003 · N70TV · Substantial damageNTSB FTW03LA147Accident · No injuriesLimited investigationFinal reportBell 206B · Hurst, TXThe improper flare by the pilot receiving instruction, which resulted in the hard landing. A contributing factor was the flight instructor's inadequate supervision.May 7, 2003 · N81519 · Substantial damageNTSB NYC03LA099Accident · No injuriesLimited investigationFinal reportCessna 182F · Washington Cour, OHFailure of the nose gear assembly. A factor was the inadequate inspection by the pilot/mechanic.May 4, 2003 · N3591Y · Substantial damageNTSB MIA03CA103Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Madison, MSThe pilot's failure to maintain control during the landing rollout/which resulted in the airplane veering off the runway and incurring damage.May 3, 2003 · N175W · Substantial damageNTSB LAX03LA146Accident · No injuriesLimited investigationFinal reportCessna 170A · Twentynine Palm, CAThe pilot's inadequate compensation and his failure to maintain aircraft control. The gusty wind condition was a contributing factor.May 1, 2003 · N1607D · Substantial damageNTSB LAX03GA145Accident · No injuriesFinal reportEurocopter France AS350B3 · Napa, CAthe pilot under instruction's inadvertent activation of the collective manual fuel slide lock, which led to engine and main rotor overspeeds due to excessive fuel flow during power application. This resulted in failures of the gas generator turbine (N1)…May 1, 2003 · N341HP · Substantial damageNTSB NYC03LA093Accident · No injuriesLimited investigationFinal reportCessna R182 · Monticello, NYThe pilot's premature raising of the flaps during the aborted landing. A factor in this accident was the crosswind condition.Apr 28, 2003 · N1695R · Substantial damageNTSB MIA03LA101Accident · No injuriesLimited investigationFinal reportCessna 177-RG · Clearwater, FLThe pilot's failure to maintain directional control during landing roll resulting in the failure and separation of the right main landing gear, partial collapse of the nose landing gear, and substantial damage to the airplane.Apr 28, 2003 · N8015G · Substantial damageNTSB SEA03LA073Accident · No injuriesLimited investigationFinal reportPilatus B4-PC11AF · Enumclaw, WAThe pilot's failure to maintain directional control. Contributing factors were the crosswind/tailwind conditions and the trees which the glider impacted.Apr 27, 2003 · N159AS · Substantial damageNTSB SEA03LA071Accident · No injuriesLimited investigationFinal reportCessna 180 · Pasco, WAThe pilot's inadequate remedial action when his aircraft began to veer during the landing roll, and his ultimate failure to maintain directional control which resulted in a ground loop. Factors include the pilot's momentary diversion of his attention during…Apr 27, 2003 · N180MK · Substantial damageNTSB NYC03LA092Accident · No injuriesLimited investigationFinal reportStinson 108 · Brookville, OHThe pilot's failure to maintain directional control while landing.Apr 27, 2003 · N97376 · Substantial damageNTSB MIA03LA100Accident · No injuriesLimited investigationFinal reportCessna 172P · Lantana, FLthe pilot's use of excessive airspeed and the improper touchdown point during the landing roll, which resulted in the airplane departing the runway, and impacting with trees.Apr 27, 2003 · N51898 · Substantial damageNTSB CHI03LA115Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Romeoville, ILThe pilot not maintaining directional control during the landing rollout. A factor to the accident was the gusting crosswind.Apr 27, 2003 · N97930 · Substantial damageNTSB LAX03LA143Accident · No injuriesLimited investigationFinal reportCessna 180A · Scottsdale, AZThe failure of a main landing gear axle bolt, and the subsequent separation of the right main landing gear wheel from the gear strut during the landing roll, which resulted in a collapse of the right main landing gear.Apr 26, 2003 · N9759B · Substantial damageNTSB FTW03LA144Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Houston, TXThe pilot's failure to maintain directional control while landing.Apr 26, 2003 · N55133 · Substantial damageNTSB LAX03LA141Accident · Minor injuriesLimited investigationFinal reportCessna 182P · North Las Vegas, NVThe pilot's inadequate compensation for the gusty cross wind conditions and failure to maintain directional control.Apr 25, 2003 · N43VB · Substantial damageNTSB CHI03LA114Accident · No injuriesLimited investigationFinal reportCessna 182T · Marengo, ILThe pilot's improper flare. A factor contributing to the accident was the gusty crosswind.Apr 25, 2003 · N35291 · Substantial damageNTSB FTW03LA139Accident · Minor injuriesLimited investigationFinal reportHackney Vans RV-6A · Canton, TXThe pilot's failure to maintain directional control during the landing flare/touchdown. A contributing factor was the soft terrain.Apr 23, 2003 · N528DH · Substantial damageNTSB CHI03LA110Accident · No injuriesLimited investigationFinal reportMaule M-5-210C · Ironwood, MIThe pilot's inadvertent ground loop on landing. A contributing factor was the ditch.Apr 23, 2003 · N9014A · Substantial damageNTSB ANC03LA047Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Palmer, AKThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in an inadvertent ground loop and collapse of the left main landing gear.Apr 23, 2003 · N5589H · Substantial damageNTSB LAX03LA140Accident · No injuriesLimited investigationFinal reportCessna 180J · Angwin, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control of the airplane during the landing roll.Apr 22, 2003 · N7821K · Substantial damageNTSB FTW03LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Pecos, TXThe failure of the pilot to maintain aircraft control while landing. A contributing factor was the gusty wind condition.Apr 22, 2003 · N1667Y · Substantial damageNTSB SEA03LA066Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Plummer, IDThe jamming of the left parking brake locking tab on a burr on the left brake master cylinder activation rod during the landing roll, resulting in the left brake becoming locked in a position where excessive braking was applied.Apr 20, 2003 · N114MK · Substantial damageNTSB DEN03LA069Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kemmerer, WYthe pilot's failure to maintain directional control and his inadequate compensation for wind during the landing roll which resulted in a ground loop/swerve and impact with terrain. Contributing factors include the wind gust and the ditch.Apr 20, 2003 · N40520 · Substantial damageNTSB ANC03LA046Accident · Minor injuriesLimited investigationFinal reportAviat A1 · Anchorage, AKThe flight instructor's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over.Apr 20, 2003 · N36LE · Substantial damageNTSB FTW03LA135Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Bossier City, LAThe failure of the passenger to follow the pilots landing instructions.Apr 19, 2003 · N7172D · No damageNTSB NYC03LA086Accident · No injuriesLimited investigationFinal reportCessna 182P · Blacksburg, VAThe pilot's improper flare and his improper recovery from a bounced landing.Apr 16, 2003 · N21520 · Substantial damageNTSB DEN03LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300T · St. George, UTthe pilot's improper flare technique, resulting in a hard landing that caused the nose landing gear down-lock to fail and the gear to collapse. A contributing factor was the unfavorable wind.Apr 16, 2003 · N31998 · Substantial damageNTSB DEN03LA080Accident · No injuriesLimited investigationFinal reportMaule MX-7-235 · Watkins, COthe pilot's failure to maintain directional control of the aircraft during the landing roll out. Contributing factors were the unlocked tailwheel.Apr 14, 2003 · N44UG · Substantial damageNTSB ATL03LA079Accident · No injuriesLimited investigationFinal reportBoeing Stearman A75L3 · Gainesville, GAThe pilot's failure to maintain directional control during the landing roll resulting in an inadvertent ground loop.Apr 14, 2003 · N4908N · Substantial damageNTSB SEA03LA062Accident · No injuriesLimited investigationFinal reportCurtiss-Wright Travel Air C-4000 · Florence, ORPilot's failure to maintain directional control during the landing roll. Factors include rough terrain.Apr 12, 2003 · N6298 · Substantial damageNTSB NYC03LA084Accident · No injuriesLimited investigationFinal reportMaule M4 · Danielson, CTThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the crosswind condition.Apr 12, 2003 · N4714T · Substantial damageNTSB CHI03LA107Accident · No injuriesLimited investigationFinal reportMcBride Avid Flyer · Anderson, INThe pilot's misjudgment of speed which resulted in a landing overrun. The pilot's lack of experience in make and model airplane, and the ditch were contributing factors.Apr 12, 2003 · N29MD · Substantial damageNTSB NYC03LA083Accident · Serious injuriesLimited investigationFinal reportMooney M20K · West Milford, NJThe pilot's inadequate compensation for the crosswind and his failure to maintain directional control. Factors in the accident were the crosswind and landing at night.Apr 11, 2003 · N231LS · Substantial damageNTSB CHI03LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Carbondale, ILThe pilot failed to properly recover from a bounced landing which resulted in the airplane porpoising.Apr 11, 2003 · N6317D · Substantial damageNTSB CHI03LA102Accident · No injuriesLimited investigationFinal reportCessna 172S · Grayslake, ILThe flight instuctor's improper in-flight decision to land with a tailwind and failure to maintain directional control of the airplane during landing. Factors contributing to the accident were the tailwind, the student pilot's inadequate flare, and the muddy…Apr 11, 2003 · N389SP · Substantial damageNTSB ATL03LA076Accident · No injuriesLimited investigationFinal reportLarry Woods Venture · Fort Payne, ALThe pilot's failure to maintain directional control during the landing roll.Apr 11, 2003 · CGDJF · Substantial damageNTSB MIA03LA098Accident · No injuriesLimited investigationFinal reportCessna 172N · Foxworth, MSThe failure of the pilot to perform a go-around, his failure to attain the proper touchdown point, and his delay in applying the normal brakes resulting in his inability to stop the airplane and subsequent on-ground collision with a fence.Apr 10, 2003 · N738QM · Substantial damageNTSB FTW03LA125Accident · No injuriesLimited investigationFinal reportCarterCopter Prototype · Olney, TXThe pilot's failure to extend the landing gear. A factor was his diverted attention.Apr 8, 2003 · N121CC · Substantial damageNTSB SEA03LA057Accident · No injuriesLimited investigationFinal reportCessna 152 · Butte, MTThe pilot's inadequate compensation for gusty variable wind conditions and his improper flare. Factors include gusty and variable winds .Apr 7, 2003 · N48733 · DestroyedNTSB SEA03LA056Accident · Minor injuriesLimited investigationFinal reportCessna TU206 G · Pistol Creek, IDInadequate visual lookout by the driver of the vehicle that turned on to the runway. Factors include rising terrain decreasing the possibility of a successful go-around and rough uneven terrain beyond the departure end of the runway.Apr 7, 2003 · N756WZ · Substantial damageNTSB SEA03LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lexington, ORThe pilot's inadequate compensation for the cosswind conditions during the landing roll which resulted in a loss of control. A contributing factor was the crosswind condition.Apr 7, 2003 · N4857A · Substantial damageNTSB FTW03LA127Accident · No injuriesLimited investigationFinal reportCessna 152 · Durant, OKThe student pilot's improper landing flare resulting in a hard landing and his improper recovery procedures for a bounced landing.Apr 7, 2003 · N116SS · Substantial damageNTSB FTW03LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Moran, TXLanding short of the runway due to the pilot's failure to maintain a proper glide path, which resulted in the airplane impacting a tree. A contributing factor was the short runway.Apr 7, 2003 · N18141 · Substantial damageNTSB CHI03LA098Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Wichita, KSThe premature lowering of the collective and the improper use of the cyclic during the run-on landing performed by the flight instructor, as well as the main rotor/tail boom contact. Contributing factors were the intentional run-on landing, the grass landing…Apr 7, 2003 · N8968F · Substantial damageNTSB ANC03LA042Accident · No injuriesLimited investigationFinal reportAerospatiale SA-319B · Valdez, AKThe pilot's encounter with a ground resonance condition during the landing touchdown, which resulted in the shearing of a main rotor spacing cable bolt, and buckling of the tail boom.Apr 7, 2003 · N119PH · Substantial damage