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 NYC92LA085Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Tewksbury, MAThe failure of the pilot to compensate for adverse winds, which resulted in a bounced landing, subsequent loss of airspeed and airplane control.Apr 23, 1992 · N6325L · Substantial damageNTSB NYC92LA084Accident · No injuriesLimited investigationFinal reportCessna 172N · New Madison, OHThe pilot's failure to attain a proper touchdown point. Contributing to the accident was the pilot inadequately planned his approach and his failure to perform a go-around.Apr 23, 1992 · N733XP · Substantial damageNTSB NYC92IA086Incident · No injuriesIncident investigationFinal reportLockheed L-1011-385 · Flushing, NYThe captain's improper aircraft control which resulted in an excessive nosewheel rate of sink and subsequent overload failure of the nose gear tires.Apr 23, 1992 · N721DA · Minor damageNTSB FTW92LA119Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Brinkley, ARThe pilot's failure to achieve proper airstrip alignment for landing, and the resultant loss of directional control.Apr 23, 1992 · N3626N · Substantial damageNTSB FTW92LA117Accident · No injuriesLimited investigationFinal reportCessna 310P · Austin, TXThe approach controller's failure to properly sequence arriving traffic, and the tower controller's failure to sequence and separate landing traffic. Factors in the accident were: the pilot's failure to obtain a landing clearance and the night light…Apr 23, 1992 · N5936M · Substantial damageNTSB CHI92LA132Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas DC-8F-55 · Ypsilanti, MIThe pilot-in-command's misjudging of the touchdown point. Factors include (aircraft performance) hydroplaning condition, and the pilot-in-command's poor evaluation of weather conditions.Apr 23, 1992 · N29549 · Substantial damageNTSB ATL92LA087Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · Rutherfordton, NCThe pilot's failure to maintain directional control during a landing roll which resulted in a collision with trees.Apr 23, 1992 · N6336C · Substantial damageNTSB ANC92LA063Accident · No injuriesLimited investigationFinal reportCessna 170 · Kenai, AKThe pilot's failure to maintain directional control. Factors to the accident were: an inadequate recovery from a bounced landing, and the pilot's lack of familiarity with the modified aircraft.Apr 21, 1992 · N3970V · Substantial damageNTSB ANC92LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKThe pilot's failure to maintain directional control. A factor to the accident was: a crosswind.Apr 20, 1992 · N7077D · Substantial damageNTSB ATL92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Moontown, ALThe pilot's excessive reference airspeed on landing, improper use of the wheel brakes, and his delay in executing an aborted landing. A factor was the wet runway surface.Apr 19, 1992 · N5112P · Substantial damageNTSB ANC92LA064Accident · No injuriesLimited investigationFinal reportCessna 182 · Tolovana, AKThe pilot's failure to use all of the available runway (landing area on the road) for the precautionary landing. Contributing to the accident were the precautionary landing, the pilot's inadequate pre flight and in flight planning/preparation, and the road…Apr 19, 1992 · N3405R · Substantial damageNTSB NYC92LA082Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Columbus, OHThe pilot's improper preflight of the helicopter, which resulted in a tie down strap not being removed prior to attempted flight, and the subsequent roll over and collision with the ramp.Apr 18, 1992 · N104MB · Substantial damageNTSB NYC92LA077Accident · No injuriesLimited investigationFinal reportCessna 172N · Sidney, OHThe failure of the pilot to maintain airplane directional control after landing, which resulted in a departure from the runway and encounter with rough terrain.Apr 14, 1992 · N5085G · Substantial damageNTSB ATL92LA077Accident · No injuriesLimited investigationFinal reportCessna 172I · Knightdale, NCThe pilot's inadequate compensation for crosswind conditions, and his failure to maintain aircraft control. A factor was the crosswind conditions at the airport.Apr 13, 1992 · N8471L · Substantial damageNTSB FTW92LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Stuttgart, ARThe pilot's failure to compensate for wind conditions. Factors were the crosswind and the downdraft.Apr 12, 1992 · N6934H · Substantial damageNTSB NYC92DHM02Accident · No injuriesFinal reportCarey Glassair SH2 · West Milford, NJImproper installation of the wheel brakes, which resulted in failure of a left brake line during the landing roll and subsequent loss of directional control and collision with an object after departing the runway.Apr 10, 1992 · N80004 · Substantial damageNTSB LAX92LA175Accident · Minor injuriesLimited investigationFinal reportHughes 369C · Pacific Ocean (Pacific Ocean)An undetermined failure in the rotor system.Apr 10, 1992 · N8311F · Substantial damageNTSB LAX92LA171Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Tucson, AZThe total failure of the landing gear strut (trunnion) due to fatigue. A factor in the accident was related to the inadequately performed recent annual inspection.Apr 10, 1992 · N41632 · Substantial damageNTSB SEA92LA071Accident · No injuriesLimited investigationFinal reportCessna A185F · Billings, MTA worn tailwheel steering system and inadequate inspection of the airplane. A factor relating to the accident was the crosswind condition.Apr 9, 1992 · N135NC · Substantial damageNTSB SEA92LA069Accident · No injuriesLimited investigationFinal reportCessna 150J · Tumwater, WAThe (student) pilot's improper recovery from a bounced landing. Factors contributing to the accident were excessive airspeed and the pilot's lack of total experience.Apr 8, 1992 · N60850 · DestroyedNTSB ATL92LA084Accident · No injuriesLimited investigationFinal reportPZL-Okecie PZL-104 Wilga 80 · Mt. Pleasant, SCThe improper flare during the touchdown phase of the approach by the pilot which exceeded the design limits of the airframe and the right landing gear assembly.Apr 8, 1992 · N3141W · Substantial damageNTSB ANC92LA059Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Mccarthy, AKThe pilot's failure to maintain directional control of the airplane. Contributing to the accident were the snow berm and the pilot's lack of total experience in the type of operation (ski equipped airplanes).Apr 8, 1992 · N97421 · Substantial damageNTSB CHI92DEE01Accident · No injuriesFinal reportBoeing E75 · Leland, ILThe pilot's excessive application of brakes. A factor in the accident was the pilot's lack of experience in this model aircraft.Apr 7, 1992 · N64955 · Substantial damageNTSB NYC92LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Moneta, VAThe student pilot's failure to properly compensate for the crosswind condition and to maintain directional control of the airplane after landing. Contributing to the accident was the crosswind.Apr 5, 1992 · N67658 · Substantial damageNTSB NYC92DGT01Accident · Serious injuriesFinal reportSchempp-Hirth Discus BT · Julian, PAThe pilot's inadvertent use of the speed brakes, which resulted in an excessive rate of descent. A factor related to the accident was the pilot's inadequate preflight.Apr 5, 1992 · N224WT · DestroyedNTSB MIA92LA105Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Deland, FLThe pilot's inadequate compensation for wind conditions.Apr 4, 1992 · N50072 · Substantial damageNTSB MIA92LA104Accident · No injuriesLimited investigationFinal reportWaco U1-C · St. Petersburg, FLPilot-in-command's failure to maintain control of the airplane on landing. Contributing to the accident were the gusty crosswinds.Apr 4, 1992 · N13562 · Substantial damageNTSB MIA92LA103Accident · 1 fatalLimited investigationFinal reportDouglas AD4-DW · Titusville, FLThe pilot in commands approach at higher than normal airspeed and his landing the aircraft at higher than normal airspeed at a point one half to three quarters down the runway resulting in the aircraft overrunning the runway and nosing over.Apr 4, 1992 · N91945 · Substantial damageNTSB LAX92LA168Accident · Minor injuriesLimited investigationFinal reportRobinson R-22B · Carlsbad, CAThe pilot's inadequate compensation for wind conditions, his failure to arrest the descent rate in a timely fashion, and the selection of unsuitable terrain on which to practice autorotations.Apr 4, 1992 · N4071J · Substantial damageNTSB FTW92LA106Accident · Minor injuriesLimited investigationFinal reportChampion 7ECA · Weatherford, TXThe pilot's failure to maintain directional control during the landing rollout, and the ensuing inadvertent stall during the aborted landing due to the jammed elevator. A factor was the crosswind.Apr 4, 1992 · N9153L · Substantial damageNTSB CHI92LA121Accident · No injuriesLimited investigationFinal reportCessna 172M · Osage Beach, MOThe pilot-in-command's failure to use all th eavailable runway and his misjudgment of the proper touchdown point during landing.Apr 4, 1992 · N9568V · Substantial damageNTSB LAX92LA162Accident · No injuriesLimited investigationFinal reportRobinson R22B · Simi Valley, CAThe instructor pilot's delayed flare from the autorotation landing. A contributing factor was the soft nature of the terrain.Apr 3, 1992 · N504RS · Substantial damageNTSB NYC92LA072Accident · No injuriesLimited investigationFinal reportCessna 152 · Coatsville, PAThe failure of the student pilot to compensate for adverse winds during landing, which resulted in a loss of airspeed and subsequent stall and loss of control. A factor related to the accident was the student pilot's lack of total flight experience.Apr 1, 1992 · N49436 · Substantial damageNTSB SEA92LA064Accident · No injuriesLimited investigationFinal reportCessna 152 · Friday Harbor, WAThe pilot's improper recovery from a bounced landing. A factor was the poorly planned approach.Mar 29, 1992 · N25944 · Substantial damageNTSB LAX92LA155Accident · No injuriesLimited investigationFinal reportBeech C-24R · Phoenix, AZThe flight instructor's inadequate supervision of the flight and the private pilot's failure to maintain airspeed. Contributing to this accident was the failure of the main landing gear due to overload.Mar 28, 1992 · N66350 · DestroyedNTSB LAX92FA154Accident · 1 fatalField investigationFinal reportHughes 269C · Hesperia, CAA failure of the student pilot to maintain adequate rotor RPM. Contributing to the accident was a failure of the instructor pilot to adequately supervise the training flight and a delay in correcting a low rotor RPM condition.Mar 28, 1992 · N9597F · DestroyedNTSB ANC92LA054Accident · No injuriesLimited investigationFinal reportCessna A185F · Fairbanks, AKPoor in flight planning/decision. Factors to the accident were: snow covered terrain, and wrong runway not identified.Mar 28, 1992 · N3332S · Substantial damageNTSB FTW92FA098Accident · 1 fatalField investigationFinal reportCessna 172M · Oklahoma City, OKInadvertent stall during aborted landing. Factors were the tailwind, the pilot's selection of the wrong runway for existing wind conditions and his long landing.Mar 26, 1992 · N20059 · DestroyedNTSB DEN92LA044Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Erie, COA loss of directional control when the pilot failed to adequately compensate for crosswind conditions during landing roll. A factor was: a 27 knot crosswind gust.Mar 24, 1992 · N3328D · Substantial damageNTSB CHI92LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Lafayette, INThe student pilot's failure to maintain directional control and his delaying the aborted landing.Mar 23, 1992 · N2959R · Substantial damageNTSB CHI92DEP02Accident · No injuriesFinal reportRutan Varieze · Kenosha, WICollapse of the nose landing gear.Mar 23, 1992 · N39L · Substantial damageNTSB CHI92DCA01Accident · No injuriesFinal reportGrumman G-164 · Malden, MOThe pilot could not maintain directional control after one of the main landing gear brakes jammed during a landing roll. The operator did not comply with an airworthiness directive issued to prevent a possible braking system malfunction.Mar 23, 1992 · N580Y · Substantial damageNTSB ANC92LA050Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Palmer, AKInadequate in-flight planning/decision. Factors to the accident were: icy and snow covered runway, and delayed remedial action.Mar 22, 1992 · N5947D · Substantial damageNTSB BFO92LA043Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Manville, NJThe pilot's failure to maintain obstacle clearance.Mar 21, 1992 · N9348N · Substantial damageNTSB ANC92LA049Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Shageluk, AKThe left main landing gear ski being partially disconnected at the time of the landing. Contributing factors were the inadequate preflight by the pilot, and the snow covered landing area.Mar 21, 1992 · N83367 · Substantial damageNTSB LAX92LA144Accident · No injuriesLimited investigationFinal reportPiper PA28-235 · Havasu Lake, CAThe dual student's failure to maintain directional control, the cfi's improper supervision of the flight, and the cfi's failure to perform the necessary remedial action. Contributing to this accident was the dual student's improper use of the brakes.Mar 20, 1992 · N8840W · Substantial damageNTSB BFO92LA045Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Brewer, METhe pilot's failure to correct an excessive descent rate during flare. Contributing to the accident was the pilots improper compensation for wind conditions.Mar 19, 1992 · N62951 · Substantial damageNTSB FTW92LA091Accident · No injuriesLimited investigationFinal reportCessna 172P · West Helena, ARPilot's improper flarea ND improper recovery from a bounced landing.Mar 16, 1992 · N96493 · Substantial damageNTSB FTW92LA090Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Roanoke, LAThe locking of the main landing gear brakes.Mar 16, 1992 · N8363K · Substantial damageNTSB DEN92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Longmont, COThe pilot's failure to maintain directional control during landing. Factors were: a snow bank alongside the runway, and gusty crosswind.Mar 16, 1992 · N6863P · Substantial damage