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 DFW07CA015Accident · No injuriesData collectionFinal reportMaule M5 · New Braunfels, TXThe failure of the right main landing gear attachment during the landing roll, which resulted in a ground loop. A contributing factor was a crosswind.Oct 26, 2006 · N32CX · Substantial damageNTSB DEN07CA014Accident · No injuriesData collectionFinal reportChampion 7GCB · Farmington, NMthe pilot's failure to maintain directional control during the landing.Oct 24, 2006 · N9867Y · Substantial damageNTSB LAX07LA024Accident · No injuriesLimited investigationFinal reportCessna U206G · Willcox, AZThe pilot's misjudged flare and porpoising during landing.Oct 23, 2006 · N206LL · Substantial damageNTSB DEN07IA027Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Denver, COThe inadvertent activation of the priority pushbutton on the sidestick by the first officer resulting in a nose down pitch and loss of aircraft control during the landing flare.Oct 23, 2006 · N924FR · No damageNTSB DEN07CA015Accident · No injuriesData collectionFinal reportCessna T210G · Delta, COthe pilot's failure to maintain aircraft control and a proper descent rate during the landing.Oct 23, 2006 · N6849R · Substantial damageNTSB ANC07CA004Accident · No injuriesData collectionFinal reportPiper PA-20-135 · Anchorage, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an inadvertent ground loop and encounter with terrain. Factors associated with the accident were the ground loop and inadequate main wheel brakes.Oct 23, 2006 · N3404A · Substantial damageNTSB MIA07CA010Accident · No injuriesData collectionFinal reportBeech A36 · St. Augustine, FLThe pilot's misjudged distance/altitude during landing, which resulted in an undershoot and on ground collision with a dirt bank.Oct 22, 2006 · N200MW · Substantial damageNTSB DFW07LA011Accident · Minor injuriesLimited investigationFinal reportSikorsky S-76A++ · Eugene Isl 259The flight crew's failure to maintain clearance with the water and their diverted attention to secondary tasks while preparing to land. Contributing factor were the low ceilings and the heavy rains restricting their visibility.Oct 22, 2006 · N22342 · DestroyedNTSB MIA07CA008Accident · No injuriesData collectionFinal reportCessna 172S · Ormond Beach, FLThe failure of the student pilot to initiate a recovery from the bounced landing resulting in a hard landing.Oct 21, 2006 · N401ER · Substantial damageNTSB LAX07CA018Accident · No injuriesData collectionFinal reportCodding/Fluno Sportsman GS-2 · Hopland, CAthe pilot's excessive braking during landing roll, which resulted in the airplane nosing over. A contributing factor was the erroneous windsock indication, which prompted the pilot to land with a tailwind, and inadvertently increase his landing roll.Oct 20, 2006 · N429AD · Substantial damageNTSB CHI07TA015Accident · No injuriesFinal reportCessna 182R · Dexter, MOThe pilot's improper runway selection for landing and the pilot's inadequate flare. A factor was the tailwind.Oct 17, 2006 · N873MP · Substantial damageNTSB LAX07CA010Accident · No injuriesData collectionFinal reportMonocoupe 110 Special · Chandler, AZthe failure of the forward left main landing gear attach point resulting in loss of control.Oct 15, 2006 · N501W · Substantial damageNTSB DFW07CA012Accident · No injuriesData collectionFinal reportCessna 182 · Vicksburg, MSThe structural damage to the firewall during a suspected hard landing.Oct 15, 2006 · N1013Y · Substantial damageNTSB DEN07CA011Accident · Minor injuriesData collectionFinal reportAdams A55S · Albuquerque, NMthe pilot's improper in-flight planning/decision. A contributing factor was the unfavorable wind.Oct 15, 2006 · N9019A · Substantial damageNTSB LAX07CA009Accident · No injuriesData collectionFinal reportFinney Thorp T-18 · San Diego, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control during landing.Oct 13, 2006 · N467JF · Substantial damageNTSB DFW07CA013Accident · No injuriesData collectionFinal reportAeronca 65-TAC · Fredricksburg, TXThe pilot's failure to compensate for the existing wind conditions. A contributing factor was the prevailing crosswind.Oct 13, 2006 · N36687 · Substantial damageNTSB ATL07CA008Accident · No injuriesData collectionFinal reportCessna CE-180-A · Statesville, NCThe pilot's failure to maintain directional control during the landing roll, which resulted in an on-ground collision with the runway.Oct 13, 2006 · N180VT · Substantial damageNTSB NYC07LA006Accident · No injuriesLimited investigationFinal reportBeech BE-200 · Leonardtown, MDThe airplane manufacturer's inadequate landing gear downlock plate maintenance orientation information, and the disengaged main landing gear.Oct 12, 2006 · N528WG · Substantial damageNTSB LAX07CA006Accident · No injuriesData collectionFinal reportHarry D. Miller Midget Mustang 1 · Reno, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.Oct 12, 2006 · N14HM · Substantial damageNTSB CHI07CA008Accident · No injuriesData collectionFinal reportPiper PA-24-260 · Osage Beach, MOThe pilot's inadequate compensation for wind conditions which resulted in the hard landing. The gusting crosswind was a factor.Oct 12, 2006 · N8546P · Substantial damageNTSB SEA07LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Lebanon, ORThe pilot's failure to maintain directional control during the landing roll, resulting in the aircraft departing the runway and impacting a Visual Approach Slope Indicator (VASI) standard. The VASI standard near the side of the runway was a factor.Oct 11, 2006 · N8122T · Substantial damageNTSB DEN07CA007Accident · Minor injuriesData collectionFinal reportHuff Acro Sport I · Delta, COthe pilot's failure to select a touchdown point a safe distance from the construction crew, and his failure to maintain directional control of the airplane. Contributing factors in this accident included the pilot's limited forward visibility when the…Oct 11, 2006 · N511SH · Substantial damageNTSB ANC07CA005Accident · No injuriesData collectionFinal reportLetecky Zavody L-23 Super Blanik · Chugiak, AKThe pilot's failure to maintain control of the glider while landing in gusty crosswind conditions, which resulted in a hard landing and structural damage to the fuselage. Factors associated with the accident were turbulence, a crosswind and wind gusts, and…Oct 10, 2006 · N394BA · Substantial damageNTSB CHI07CA006Accident · No injuriesData collectionFinal reportCessna 172N · Grand Rapids, MNThe student pilot's misjudged landing flare and improper recovery from the bounced landing which led to the failure of the nose landing gear. The overload failure of the nose landing gear was a factor.Oct 9, 2006 · N739XK · Substantial damageNTSB CHI07LA005Accident · No injuriesLimited investigationFinal reportBurkhart Grob G103 · Lake Village, INInadequate visual lookout by the pilot. A factor associated with the accident was that neither airplane was equipped with communications equipment.Oct 8, 2006 · N4425Y · 2 aircraft · Substantial damageNTSB CHI07CA004Accident · No injuriesData collectionFinal reportCessna 172N · St Charles, MOThe pilot's failure to properly judge the landing flare and his inadequate recovery from the resulting bounced landing. A contributing factor was the inadvertent pilot induced oscillation (porpoise) after initial runway contact.Oct 8, 2006 · N4775D · Substantial damageNTSB LAX07CA013Accident · No injuriesData collectionFinal reportAviat A-1A · Woodlake, CAthe collapse of the landing gear during the landing roll out due to an encounter with rough uneven terrain. Also causal was the pilot's in-flight decision to land on the unsuitable mountainous uneven terrain with hidden obstructions.Oct 7, 2006 · N40AW · Substantial damageNTSB ATL07LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Alabaster, ALThe jammed landing gear hydraulic motor shuttle valve.Oct 7, 2006 · N70SR · Substantial damageNTSB NYC07CA004Accident · No injuriesData collectionFinal reportBeech BE-58 · Annapolis, MDThe pilot's improper in-flight decision to attempt to land on the wet runway, which resulted in an overrun. Factors in the accident were rain, and the gusty wind conditions.Oct 6, 2006 · N600U · Substantial damageNTSB LAX07CA007Accident · No injuriesData collectionFinal reportCessna 172P · Glendale, AZthe student's inadequate compensation for the gusting crosswind and inadequate flare that resulted in a hard landing. The certified flight instructor's inadequate supervision of the flight is also causal.Oct 6, 2006 · N97811 · Substantial damageNTSB CHI07CA003Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Fargo, NDThe pilot's inadequate flare which resulted in a hard landing. Factors associated with the accident were the gusty winds and the pilot's lack of experience.Oct 6, 2006 · N275ND · Substantial damageNTSB SEA07CA003Accident · No injuriesData collectionFinal reportCessna T182T · Spokane, WAThe pilot's excessive braking which resulted in a loss of aircraft control during the landing roll. A taxiway sign was a factor.Oct 5, 2006 · N134GW · Substantial damageNTSB DFW07CA003Accident · No injuriesData collectionFinal reportBoeing 75 · Sweetwater, TXThe pilot's failure to maintain directional control while landing.Oct 5, 2006 · N27933 · Substantial damageNTSB CHI07CA001Accident · No injuriesData collectionFinal reportCessna 180K · Barton City, MIThe pilot's failure to attain a proper touchdown point and his inadvertent selection of a downwind runway, which resulted in the overrun. A contributing factor was the tailwind encountered during landing. Additional factors were the wet, turf runway, and the…Oct 1, 2006 · N64257 · Substantial damageNTSB NYC06CA232Accident · No injuriesData collectionFinal reportCessna 172S · Cambridge, MDThe pilot's failure to maintain directional control while landing.Sep 30, 2006 · N61WT · Substantial damageNTSB SEA06CA191Accident · No injuriesData collectionFinal reportMaule M-6-235 · Ronan, MTThe pilot's failure to maintain directional control during the landing roll in the tailwheel-equipped aircraft. A swale (sunken area) between the runway and the taxiway was a factor.Sep 29, 2006 · N9918T · Substantial damageNTSB CHI06CA274Accident · No injuriesData collectionFinal reportBeech B19 · Pontiac, MIThe pilot's failure to perform a go-around when he noticed the airplane was not on a stabilized final approach. Contributing factors to the accident were the hard landing, the subsequent pilot-induced oscillation (porpoise) which resulted in the collapse of…Sep 29, 2006 · N1949W · Substantial damageNTSB DFW06LA216Accident · 1 fatalLimited investigationFinal reportWeber Venture · El Paso, TXThe aircraft's inadequate landing gear design, which resulted in a loss of directional control and subsequent nose-over. A factor was the owner/builder's failure to incorporate modifications to the landing gear.Sep 28, 2006 · N5QE · Substantial damageNTSB SEA06CA189Accident · Minor injuriesData collectionFinal reportNorthwing Apache Sport · Brewster, WAThe pilot's failure to maintain control of the aircraft during the landing, resulting in its impact with terrain. A factor was the wind gust condition.Sep 24, 2006 · UNREG · Substantial damageNTSB LAX06CA303Accident · No injuriesData collectionFinal reportCleberg Sportsman 2+2 GS-2 · Tucson, AZThe pilot's failure to maintain directional control of the airplane during landing.Sep 24, 2006 · N24AZ · Substantial damageNTSB CHI06FA269Accident · 1 fatalField investigationFinal reportCessna 182Q · Cumberland, WIThe pilot's inadvertent attempt to land on water with the wheels down and his failure to verify the gear position prior to landing. Contributing factors were the inoperative gear system due to the open gear selector circuit breaker, which tripped for…Sep 24, 2006 · N97435 · Substantial damageNTSB SEA06CA186Accident · No injuriesData collectionFinal reportCessna 152 · Pembroke Pine, FLThe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor was the runway sign.Sep 23, 2006 · N45945 · Substantial damageNTSB SEA06CA187Accident · No injuriesData collectionFinal reportCessna 172S · Naples, FLThe student pilot's failure to adequately compensate for wind conditions during the landing roll. A drainage ditch and wind were contributing factors.Sep 22, 2006 · N320CP · Substantial damageNTSB CHI06CA270Accident · No injuriesData collectionFinal reportDevereux Mustang II · Auburn, INThe failure of the left main landing gear attachment weld which resulted in the pilot's inablility to maintain directional control of the airplane during the landing roll.Sep 21, 2006 · N44DX · Substantial damageNTSB SEA06LA184Accident · 1 fatalLimited investigationFinal reportShimer One Design · Lake Wales, FLThe loss of control for an undetermined reason during the landing roll.Sep 20, 2006 · N973D · Substantial damageNTSB ATL06CA128Accident · No injuriesData collectionFinal reportMooney M-20J · Blue Ridge, GAThe pilot's failure to achieve the proper touchdown point on landing resulting in an overrun, and on ground collision with trees.Sep 20, 2006 · N201SJ · Substantial damageNTSB SEA06LA193Accident · No injuriesLimited investigationFinal reportCessna 152 · Lantana, FLThe student pilot's improper recovery from a bounced landing.Sep 18, 2006 · N24403 · Substantial damageNTSB LAX06CA296Accident · No injuriesData collectionFinal reportBell 47G · Angels Camp, CAa hard landing due to the pilot's inadequate compensation for a wind shift encountered on final approach and his failure to maintain an adequate translational lift airspeed.Sep 18, 2006 · N7762 · Substantial damageNTSB LAX06CA295Accident · No injuriesData collectionFinal reportBeech A36 · Chandler, AZthe student's failure to establish a stabilized approach, which resulted in a bounced landing and a loss of directional control. Also causal was the flight instructor's inadequate supervision of the flight, delayed remedial action, and failure to verbally…Sep 18, 2006 · N9067E · Substantial damageNTSB MIA06CA139Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Fort Lauderdale, FLThe inadequate installation of a flexible hydraulic hose at the nose landing gear actuator by an unknown person resulting in the total loss of hydraulic fluid, the inability of the pilot to extend the landing gear, and subsequent wheels-up landing.Sep 17, 2006 · N428RM · Substantial damage