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 CHI05LA128Accident · No injuriesLimited investigationFinal reportCessna T210N · Smith Center, KSFailure of the Piper airplane pilot to obtain visual separation from the Cessna airplane rolling out after landing on the intersecting runway resulting in a collision between the two aircraft. A contributing factor was the evasive maneuver attempted be the…May 28, 2005 · N6366Y · 2 aircraft · Substantial damageNTSB ANC05CA078Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Manokotak, AKThe pilot's failure to extend the landing gear. A contributing factor was the pilot's failure to use the checklist.May 26, 2005 · N65MR · Substantial damageNTSB LAX05CA188Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Jean, NVthe student's failure to maintain adequate main rotor rpm when performing a180-degree autorotation, and the instructor's inadequate supervision and delayed remedial action. A factor in the accident was the high density altitude.May 25, 2005 · N192SH · Substantial damageNTSB CHI05CA127Accident · No injuriesData collectionFinal reportCessna 150F · Neodesha, KSThe student pilot's misjudgment of the landing flare resulting in a hard landing, his inadequate recovery from the bounced landing and his subsequent failure to maintain directional control of the airplane. The pilot's attempt to abort the landing, and the…May 25, 2005 · N8337G · Substantial damageNTSB MIA05LA108Accident · No injuriesLimited investigationFinal reportBeech 58 · Gulfport, MSThe inadequate maintenance inspection by maintenance personnel which resulted in damaged landing gear pulleys, resulting in the failure of the landing gear downlock to engage, and collapse of the main landing gear during landing.May 24, 2005 · N6654Y · Substantial damageNTSB ANC05CA080Accident · No injuriesData collectionFinal reportPiper PA-18 · Delta Junction, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an overrun. A factor contributing to the accident was rough and uneven terrain.May 23, 2005 · N1087A · Substantial damageNTSB CHI05CA126Accident · No injuriesData collectionFinal reportYoung Zodiac 601XL · Mattoon, ILThe pilot's failure to maintain control of the airplane during the landing flare resulting in an in-flight collision with the runway pavement.May 22, 2005 · N601AY · Substantial damageNTSB CHI05CA123Accident · No injuriesData collectionFinal reportCessna C-172M · Madison, WIThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control. Factors were the gusty winds and the soft ground.May 22, 2005 · N13558 · Substantial damageNTSB SEA05LA101Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Driggs, IDThe pilot's failure to compensate for wind conditions, which resulted in a ground loop/swerve during the landing roll. A crosswind was a factor.May 21, 2005 · N40318 · Substantial damageNTSB CHI05LA121Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Mt. Pleasant, MIThe pilot's misjudged distance/speed which led to an overrun and collision with a vehicle. Contributing to the accident was the flight instructor's delayed remedial action in executing a go-around.May 21, 2005 · N66427 · Substantial damageNTSB CHI05CA124Accident · No injuriesData collectionFinal reportCessna 172S · Port Huron, MIThe pilot not performing a go-around and misjudging the flare leading to a hard landing.May 21, 2005 · N860SA · Substantial damageNTSB MIA05CA109Accident · No injuriesData collectionFinal reportCessna 172R · Daytona Beach, FLThe student pilot's improper landing flare and the CFI's inadequate supervision resulting in a hard landing and damage to the airplane.May 20, 2005 · N864CP · Substantial damageNTSB CHI05CA118Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Ypsilanti, MIThe pilot's inability to maintain directional control of the airplane due to undetermined reasons. Factors associated with the accident were the crosswind condition and the taxiway sign which was contacted. This case was modified October 12, 2006!!May 19, 2005 · N3936W · Substantial damageNTSB LAX05LA180Accident · No injuriesLimited investigationFinal reportCessna 172M · Tucson, AZThe student pilot's improper flare that induced a porpoise, which resulted in the overload failure of the nose wheel assembly.May 18, 2005 · N9017H · Substantial damageNTSB DFW05CA122Accident · No injuriesData collectionFinal reportBeech BE-55 · Midland, TXThe pilot's failure to extend the landing gear which resulted in a gear-up landing. A contributing factor was the pilot's failure to follow the checklist.May 17, 2005 · N6037W · Substantial damageNTSB NYC05LA085Accident · Minor injuriesLimited investigationFinal reportCessna 525A · Atlantic City, NJThe pilot's improper decision to plan a flight to a runway of insufficient length, his improper in-flight decision to land on that inadequate runway with a tailwind, and his failure to obtain the proper touchdown point. A factor in the accident was the…May 15, 2005 · OY-JET · Substantial damageNTSB LAX05CA181Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Tucson, AZthe improper flare by an undetermined crewmember, which resulted in a hard landing.May 15, 2005 · N55069 · Substantial damageNTSB DFW05CA124Accident · No injuriesData collectionFinal reportCessna 210L · Houston, TXThe pilot's failure to maintain directional control during landing roll. A contributing factor was reported partial loss of brake control.May 15, 2005 · N1766X · Substantial damageNTSB ANC05CA077Accident · No injuriesData collectionFinal reportPiper PA-18 · Dillingham, AKThe instructor pilot's inadequate supervision, and the dual student's failure to maintain directional control. Factors associated with the accident were a crosswind, and an inadvertent ground loop.May 15, 2005 · N8275U · Substantial damageNTSB SEA05LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Puyallup, WAThe fatigue cracking of the upper torque link attach lugs on the right main landing gear strut, which resulted in separation of the right main landing gear.May 14, 2005 · N7263J · Substantial damageNTSB LAX05LA170Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Industries DA 20-C1 · Glendale, AZthe pilot's misjudged landing flare that resulted in a stall and hard landing.May 14, 2005 · N791MA · Substantial damageNTSB LAX05CA169Accident · No injuriesData collectionFinal reportBeech C23 Sundowner · San Martin, CAthe pilot's improper landing flare that resulted in a porpoise and a hard landing.May 14, 2005 · N1982L · Substantial damageNTSB ATL05LA091Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Newnan, GAThe improper repair to the main landing gear assembly resulted in the actuator bracket failure and the right main gear collapse. A factor was the inadequate inspection of the right main landing gear.May 14, 2005 · N2113P · Substantial damageNTSB ANC05LA076Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control during the landing roll. Factors associated with the accident are a crosswind, and an inadvertent ground loop/swerve.May 14, 2005 · N4606C · Substantial damageNTSB SEA05LA100Accident · No injuriesLimited investigationFinal reportCessna 152TW · Missoula, MTThe pilot's failure to maintain clearance from a taxiway identification sign as he attempted to turn off the runway onto the taxiway during the last part of the landing roll. Factors include a taxiway identification sign in the vicinity of the intersection of…May 12, 2005 · N7866Z · Substantial damageNTSB SEA05CA096Accident · No injuriesData collectionFinal reportPiper PA-12 · Snohomish, WAThe pilot's failure to maintain aircraft control during the landing roll on a sandbar which resulted in the aircraft nosing over.May 11, 2005 · N7755H · Substantial damageNTSB NYC05CA082Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's improper flare and recovery from a bounced landing.May 11, 2005 · N64815 · Substantial damageNTSB CHI05CA115Accident · No injuriesData collectionFinal reportCessna 172H · Plattsmouth, NEThe student pilot's inadequate compensation for the wind conditions which resulted in a loss of aircraft control. A factor associated with the accident was the gusting crosswind.May 10, 2005 · N4987R · Substantial damageNTSB ANC05LA074Accident · No injuriesLimited investigationFinal reportCessna 170B · Homer, AKThe flight instructor's inadequate supervision of the flight during the landing roll, which resulted in a loss of control, and collision with a ditch. A factor associated with the accident was the student pilot's failure to maintain directional control.May 10, 2005 · N8305A · Substantial damageNTSB LAX05LA162Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Del Mar, CAThe pilot's failure to arrest the high rate of descent and an inadequate bounced landing recovery technique. a factor in the accident was the rough, uneven terrain.May 9, 2005 · N3002J · No damageNTSB ANC05LA073Accident · No injuriesLimited investigationFinal reportInterstate S-1A · Palmer, AKThe pilot's misjudged distance and speed, which resulted in an overrun during the landing roll, and subsequent nose over. Factors contributing to the accident were a tailwind and a short landing area.May 7, 2005 · N37209 · Substantial damageNTSB ANC05LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of unsuitable terrain for landing, and his failure to maintain control of the airplane, which resulted in a nose over during the landing roll. A factor contributing to the accident was uneven terrain.May 7, 2005 · N9206Y · Substantial damageNTSB SEA05LA094Accident · No injuriesLimited investigationFinal reportCessna 120 · Elk River, IDThe pilot's failure to maintain directional control during the landing roll. An inadvertent ground loop was a factor.May 5, 2005 · N77377 · Substantial damageNTSB MIA05CA121Accident · No injuriesData collectionFinal reportCessna 172SP · Clearwater, FLThe pilot's improper flare and recovery from a bounced landing.May 2, 2005 · N66113 · Substantial damageNTSB NYC05CA079Accident · No injuriesData collectionFinal reportBoeing B75N1 · Culpeper, VAThe pilot's inadequate recovery from a bounced landing. A factor was the crosswind.May 1, 2005 · N1066M · Substantial damageNTSB LAX05LA154Accident · No injuriesLimited investigationFinal reportKittleson Quickie Q-200 · Santa Barbara, CAthe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control.May 1, 2005 · N200AL · Substantial damageNTSB LAX05CA153Accident · Minor injuriesData collectionFinal reportAerotek Pitts S-2A · Tracy, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control, which resulted in a ground loop and nose over.May 1, 2005 · N5300V · Substantial damageNTSB ANC05CA067Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a loss of control during the landing roll, and a collision with willows and a creek bank. A factor associated with the accident was the soft landing area.Apr 30, 2005 · N5061G · Substantial damageNTSB ATL05LA076Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Thomaston, GAThe unapproved repair of the tailwheel rudder arm assembly, which resulted in an overload failure during touchdown and subsequent loss of control of the airplane and on-ground collision with an object.Apr 28, 2005 · N7053K · Substantial damageNTSB ANC05LA065Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Wasilla, AKThe pilot's selection of an unsuitable landing area, which resulted in a loss of control during the landing roll, and a collision with a ditch. A factor associated with the airplane was a leaking brake assembly and diminished braking efficiency.Apr 28, 2005 · N624MW · Substantial damageNTSB SEA05CA088Accident · No injuriesData collectionFinal reportCessna 150L · Eureka, MTThe pilot's failure to adequately compensate for the wind conditions during the landing roll. Factors include a 10 knot crosswind, with gusts up to 15 knots, and a taxiway sign near the point where the aircraft exited the runway.Apr 27, 2005 · N1387Q · Substantial damageNTSB CHI05CA107Accident · No injuriesData collectionFinal reportWhittman Tailwind · Lyndon, KSThe pilot improper recovery from a bounced landing, and his inadequate compensation for a tailwind, which resulted in a loss of control and subsequent collision with the ground. Contributing to the accident was the pilot's selection of a wrong runway, the…Apr 27, 2005 · N74849 · Substantial damageNTSB ANC05CA066Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground encounter with terrain during the landing roll, and subsequent nose down of the airplane. A factor associated with the accident was soft terrain.Apr 27, 2005 · N4685A · Substantial damageNTSB ATL05LA075Accident · Minor injuriesLimited investigationFinal reportSwearingen SA-26AT · Lawrenceville, GAThe pilot's improper landing flare that resulted in a hard landing.Apr 26, 2005 · N50KV · Substantial damageNTSB MIA05CA097Accident · No injuriesData collectionFinal reportBellanca 8GCBC · Pensacola, FLThe pilot misjudged his altitude and distance resulting in an overrun. Also causal was the pilot's failure to execute a go-around.Apr 25, 2005 · N53954 · Substantial damageNTSB DFW05CA108Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH-2000 · Panhandle, TXThe student pilot's improper compensation for existing wind conditions. Contributing factors were the crosswind and inadequate supervision by the flight instructor.Apr 25, 2005 · N215LF · Substantial damageNTSB ANC05CA062Accident · No injuriesData collectionFinal reportCessna 180 · Anchorage, AKThe pilot's failure to compensate for a crosswind during the landing roll, which resulted in a loss of control and the airplane nosing over. A factor associated with the accident was a crosswind, and an inadvertent ground loop.Apr 25, 2005 · N4563B · Substantial damageNTSB LAX05CA145Accident · No injuriesData collectionFinal reportCessna 180 · Corona, CAthe pilot's inadequate compensation for a crosswind/wind gust condition and his failure to maintain directional control during landing rollout.Apr 23, 2005 · N270KC · Substantial damageNTSB LAX05CA142Accident · No injuriesData collectionFinal reportRankin Quickie Q2 · Chino, CAthe pilot's inadequate compensation for a crosswind and his failure to maintain directional control during landing rollout.Apr 21, 2005 · N8337F · Substantial damageNTSB CHI05FA103Accident · 1 fatalField investigationFinal reportCessna 150M · Festus, MOThe pilot's inadequate preflight weather evaluation and his failure to maintain aircraft control during the landing approach. A contributing factor to the accident was the pilot's inadvertent flight in close proximity to a severe thunderstorm associated with…Apr 20, 2005 · N45522 · Substantial damage