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 NYC94LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Somerset, PAwas the failure of the pilot to adequately compensate for wind conditions, and maintain directional control. A factor related to the accident were the gusting crosswinds.Oct 26, 1993 · N6566J · Substantial damageNTSB LAX94LA029Accident · No injuriesLimited investigationFinal reportBeech 76 · Livermore, CAthe dual student's improper use of the throttle and the flight instructor's inadequate supervision of the flight.Oct 26, 1993 · N6626X · Substantial damageNTSB CHI94LA029Accident · No injuriesLimited investigationFinal reportCessna 182N · Onaga, KSthe pilot-in-command's poor pre-flight planning and failure to maintain runway alignment. Factors were the dark light conditions and the lack of runway lights.Oct 26, 1993 · N92881 · Substantial damageNTSB FTW94LA017Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Woodville, TXFailure of the pilot in command to maintain control of the aircraft during an aborted landing.Oct 24, 1993 · N317BB · Substantial damageNTSB LAX94LA024Accident · No injuriesLimited investigationFinal reportCessna 150K · California City, CAFailure of maintenance personnel to assure that the nose wheel axle was properly secured during previous maintenance.Oct 23, 1993 · N6067G · Substantial damageNTSB ATL94LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lexington, NCThe pilot's failure to maintain directional control during a crosswind landing. A factor was the crosswind condition.Oct 23, 1993 · N9778C · Substantial damageNTSB SEA94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Hamilton, MTThe pilot's improper recovery from a bounced landing, and failure to maintain directional control of the airplane. Factors related to the accident were: the pilot's improper flare for landing, the resultant porpoise, and the ditch near the side of the runway.Oct 22, 1993 · N3568M · Substantial damageNTSB NYC94LA016Accident · No injuriesLimited investigationFinal reportBeech 58 · Millville, NJthe pilot's inadvertent actuation of the landing gear lever during the landing roll, resulting in the retraction of the landing gear on the runway.Oct 22, 1993 · N13AK · Substantial damageNTSB NYC94LA015Accident · Minor injuriesLimited investigationFinal reportCessna 310L · Tewksbury, MAwas an improperly planned approach, and excessive compensation for the winds by the pilot which resulted in an overrun, and on ground collision with a fence and vehicle. A factor was the gusty crosswinds.Oct 22, 1993 · N3328X · Substantial damageNTSB FTW94LA029Accident · No injuriesLimited investigationFinal reportCessna 210 · Monte Vista, COFailure by the pilot in command to follow procedures and directives to lower the landing gear prior to landing.Oct 22, 1993 · N9653T · Substantial damageNTSB FTW94LA018Accident · No injuriesLimited investigationFinal reportCessna 150L · Athens, TXPilot's failure to maintain directional control due to improper compensation for the wind conditions.Oct 22, 1993 · N17056 · Substantial damageNTSB CHI94LA028Accident · No injuriesLimited investigationFinal reportCessna 182 · Belleville, MIwas wind information not used by the pilot-in-command and a resultant exceeding of the airplane's performance capabilities.Oct 21, 1993 · N6353A · DestroyedNTSB ANC94LA013Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Karluk, AKThe selection of unsuitable terrain for landing.Oct 20, 1993 · N4327P · Substantial damageNTSB SEA94LA017Accident · No injuriesLimited investigationFinal reportCessna 182R · Tooele, UTAirspeed was not maintained.Oct 15, 1993 · N6503E · Substantial damageNTSB FTW94LA011Accident · No injuriesLimited investigationFinal reportCessna 172F · Co. Springs, COAn encounter with wake turbulence during the landing flare. A factor was lack of total pilot experience.Oct 15, 1993 · N5191F · Substantial damageNTSB LAX94LA011Accident · No injuriesLimited investigationFinal reportBeech C90A · Napa, CAThe dual student's improper use of powerplant controls, and inadequate supervision by the flight instructor (CFI).Oct 12, 1993 · N487JD · Substantial damageNTSB CHI94LA012Accident · No injuriesLimited investigationFinal reportCessna A188B · Wall, SDFailure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. A factor related to the accident was: the pilot's lack of familiarity with the type (make and model) of airplane.Oct 12, 1993 · N4788Q · Substantial damageNTSB SEA94LA012Accident · No injuriesLimited investigationFinal reportCessna T-337E · Yamhill, ORThe pilot failed to attain the proper touchdown point. The tailwind was a factor.Oct 10, 1993 · N1244M · Substantial damageNTSB MIA94LA004Accident · Serious injuriesLimited investigationFinal reportEhlers Lancair 320 · Bay St. Louis, MSThe pilot-in-command's failure to maintain airspeed resulting in an in flight loss of control (stall/spin) and subsequent in flight collision with trees and terrain.Oct 10, 1993 · N320SE · DestroyedNTSB LAX94LA008Accident · No injuriesLimited investigationFinal reportStinson 108 · Mesa, AZa loose wheel half bolt, due to the inadequate maintenance inspection of the aircraft.Oct 10, 1993 · NC409 · Substantial damageNTSB SEA94LA013Accident · No injuriesLimited investigationFinal reportCessna 172N · Renton, WAThe student pilot's failure to maintain directional control during landing. The crosswind was a factor.Oct 9, 1993 · N7367E · Substantial damageNTSB ANC94LA009Accident · No injuriesLimited investigationFinal reportDouglas C-54GDC · Point Lay, AKThe pilot-in-command's failure to perform proper preflight planning by not computing the required landing runway length.Oct 9, 1993 · N811E · Substantial damageNTSB ANC94LA010Accident · No injuriesLimited investigationFinal reportCessna CE-180 · King Salmon, AKThe pilot-in-command's selection of unsuitable terrain and the berm on the airstrip.Oct 8, 1993 · N2245C · Substantial damageNTSB MIA94LA003Accident · No injuriesLimited investigationFinal reportDouglas DC-3C · San Juan, PRPartial failure of a wing rib due to exfoliation corrosion and inadequate inspection of the aircraft by company maintenance personnel.Oct 7, 1993 · N781T · Substantial damageNTSB CHI94LA008Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Bristol, INthe pilot's abrupt maneuver (intentional swerve) and main gear collapse during the landing roll on a short grass strip.Oct 7, 1993 · N71492 · Substantial damageNTSB MIA94LA002Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Opa-Locka, FLImproper servicing of three of the four main landing gear dampers by company maintenance personnel, and innadequate remedial action by the pilot as ground resonance began.Oct 6, 1993 · N95AF · Substantial damageNTSB FTW94LA006Accident · No injuriesLimited investigationFinal reportCessna 310I · Southlake, TXAircraft control not maintained by the private pilot receiving instruction. Factors were rough runway, runway edge lights inoperative, dark night conditions, brakes restricted due to an out of rig rudder system, and inadequate CFI supervision.Oct 6, 1993 · N8090M · Substantial damageNTSB ANC94LA006Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Aniak, AKThe pilot-in-command's failure to compensate for the wind conditions. The gusty wind was a factor.Oct 6, 1993 · N8479Y · Substantial damageNTSB SEA94LA009Accident · No injuriesLimited investigationFinal reportCessna 150E · Sandy, ORFailure of the pilot to maintain proper runway alignment during the landing. The lack of adequate runway alignment marking was a related factor.Oct 5, 1993 · N3071J · Substantial damageNTSB SEA94LA008Accident · No injuriesLimited investigationFinal reportCessna 172RG · Corvallis, ORThe cfi's inadequate in-flight planning, and his inadvertent gear-up landing. Factors include the cfi's diverted attention.Oct 5, 1993 · N16ED · Substantial damageNTSB ANC94LA012Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Haines, AKFatigue failure in a weld on the right main landing gear oleo strut tubing.Oct 5, 1993 · N5285J · Substantial damageNTSB SEA94LA005Accident · No injuriesLimited investigationFinal reportCessna T182RG · Casper, WYInadequate maintenance and inspection of the hydraulic line resulting in a loss of hydraulic pressure.Oct 4, 1993 · N999RG · Substantial damageNTSB NYC94LA001Accident · No injuriesLimited investigationFinal reportCessna 172M · Wellsville, NYThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall and inflight collision with the terrain.Oct 4, 1993 · N20286 · Substantial damageNTSB FTW94LA004Accident · Minor injuriesLimited investigationFinal reportRaven Rally RX7 · Albuquerque, NMPilot's failure to maintain aircraft control. A factor was the gusty winds.Oct 4, 1993 · N27953 · Substantial damageNTSB CHI94LA009Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Benton, KSThe failure of the student pilot to maintain directional control and proper runway alignment during the landing roll. The proximity of the ditch to the runway was a related factor.Oct 4, 1993 · N801B · Substantial damageNTSB FTW94LA002Accident · No injuriesLimited investigationFinal reportMaule M-5-200C · Watkins, COThe pilot's loss of directional control resulting in the inadvertent ground loop. A factor was the instructor's failure to take remedial action on a timely manner.Oct 3, 1993 · N16CB · Substantial damageNTSB CHI94LA003Accident · No injuriesLimited investigationFinal reportWelch OW8M · Greenfield, INThe pilot's failure to properly flare the airplane. The gusty crosswind was a factor.Oct 3, 1993 · N17117 · Substantial damageNTSB NYC94LA003Accident · No injuriesLimited investigationFinal reportCessna 172 · Mt. Gilead, OHthe pilot's improper inflight decision to conduct a night landing at an airport without runway lights, and the subsequent misalignment with the runway and collision with an object.Oct 2, 1993 · N736RZ · Substantial damageNTSB BFO93LA192Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Batavia, OHThe pilot's improper flare.Oct 1, 1993 · N3332U · Substantial damageNTSB FTW93LA273Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Hurst, TXThe excessive flare and the control interference by the pilot undergoing instruction and inadequate supervision by the CFI. Factors were the pilot's failure to understand the instructor's directions due to his limited knowledge of the english language.Sep 30, 1993 · N2064J · Substantial damageNTSB SEA93LA216Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Clinton, MTTotal failure of the tow equipment.Sep 26, 1993 · N52AS · Substantial damageNTSB ATL93LA163Accident · No injuriesLimited investigationFinal reportAerospatiale TB21 · Spruce Pine, NCThe pilot's inadequate inflight decision in delaying a go-around attempt and in attempting a go around with full flap extension.Sep 26, 1993 · N2528D · DestroyedNTSB SEA93LA210Accident · No injuriesLimited investigationFinal reportWhite BD-5 · Helena, MTThe pilot's failure to maintain airspeed. The pilot's lack of experience in this make and model aircraft was a factor.Sep 25, 1993 · N273GW · Substantial damageNTSB BFO93LA187Accident · No injuriesLimited investigationFinal reportCessna 150B · Woodford, VAThe pilot misjudging his altitude and airspeed and not attaining the proper touchdown point resulting in the airplane exiting the runway and colliding with pine trees. Factors in this accident were: 1) the wet runway, 2) rain which resulted in poor braking…Sep 25, 1993 · N7386X · Substantial damageNTSB LAX93LA368Accident · No injuriesLimited investigationFinal reportCessna 172P · Phoenix, AZThe pilot's misjudging the landing flare. A physical problem may have contributed.Sep 24, 1993 · N98909 · Substantial damageNTSB SEA93LA212Accident · No injuriesLimited investigationFinal reportCessna 182RG · Vancouver, WAThe pilot's inadvertent landing gear retraction.Sep 23, 1993 · N736ZV · Substantial damageNTSB BFO93LA185Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Wauseon, OHThe pilot's failure to compensate for the crosswind which resulted in loss of directional control during the flare/touchdown. A factor in the accident was the crosswind component.Sep 23, 1993 · N53730 · Substantial damageNTSB CHI93LA377Accident · No injuriesLimited investigationFinal reportLanceair 235M · Rockford, ILThe pilot-in-command delayed aborting the landing. Factors were a wet runway and the pilot-in-command's lack of recent experience in this type of airplane.Sep 22, 1993 · N12TN · Substantial damageNTSB BFO93LA183Accident · No injuriesLimited investigationFinal reportCessna 170B · Martinsburg, WVThe pilot's failure to maintain directional control.Sep 22, 1993 · N8081A · Substantial damageNTSB ANC93LA182Accident · No injuriesLimited investigationFinal reportCessna 180 · Pumice Creek, AKThe pilot's failure to maintain directional control of the airplane during the landing roll. Factors were the pilot misjudged the wind information, and the unfavorable wind.Sep 21, 1993 · N4563B · Substantial damage