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 NYC88LA140Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Rochester, NYThe Luscombe 8E experienced a failure of the right main landing gear axle during a bounced landing. The failure occurred at the weld where the axle attaches to the landing gear strut. Examination of the fracture revealed a pre-existing crack that was not…May 15, 1988 · N2047K · Substantial damageNTSB MIA88LA170Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ocean Springs, MSThe instructor stated that they were on their third touch and go and had made a wheel landing, and just as she started to retract the flaps, the aircraft made an aprx 30 degree turn off the right side of the runway. She then stated that no matter how much…May 15, 1988 · N7682K · Substantial damageNTSB DEN88LA108Accident · No injuriesLimited investigationFinal reportCessna 210L · St. George, UTMay 15, 1988 · N732BR · Substantial damageNTSB ATL88LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, OHThe plt landed the airplane long at an excessive airspeed. The airplane overran the rwy end, traveled across a grassy area onto a ramp area, and collided with a parked airplane. The plt had 2 hrs of flt experience in this make and model airplane, which was…May 15, 1988 · N8261L · Substantial damageNTSB NYC88LA139Accident · No injuriesLimited investigationFinal reportCessna 172RG · West Chester, PAThe pilot was performing a touch and go landing at brandwyine airport and lost directional control during landing. He said he touched down, applied full power then remembered to put the flaps up. When the acft started to veer off the rwy the plt applied…May 14, 1988 · N9638B · Substantial damageNTSB NYC88FA143Accident · Minor injuriesField investigationFinal reportBell 206B · Farmingdale, NYThe Bell 206B was being flown on a helicopter rating ride with the PIC in the right seat and an FAA inspector in the left seat. The oral was satisfactory and the flight check progressed to autorotations. The first one was long, the second short. On the third…May 12, 1988 · N39071 · Substantial damageNTSB SEA88LA091Accident · No injuriesLimited investigationFinal reportCessna 150K · Yamhill, OROn short final for landing onto a 2100 foot airstrip at about 12 feet AGL, the aircraft encountered adverse winds and struck the ground in a three point attitude breaking off the nose gear. The aircraft then nosed over inverted striking a barbed wire fence.…May 11, 1988 · N6251G · Substantial damageNTSB LAX88LA178Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Sacramento, CAMay 11, 1988 · N747JR · Substantial damageNTSB LAX88LA177Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Temecula, CADuring the landing roll in a direct crosswind, the aircraft began to weather vane. The pilot was unable to maintain control of the aircraft which veered off the runway where it collided with the terrain and nosed over. There were no reported mechanical…May 11, 1988 · N9570K · Substantial damageNTSB SEA88LA092Accident · No injuriesLimited investigationFinal reportCessna 185 · Mercer Island, WAThe pilot stated that the aircraft struck a log while landing on the water. The aircraft then nosed over inverted and sank.May 10, 1988 · N1701R · Substantial damageNTSB ATL88LA170Accident · No injuriesLimited investigationFinal reportBellanca 8GCBC · Elizabethton, TNThe flt was being accomplished to refamiliarize the commercial plt with the airplane prior to completing the remainder of the training curriculum. One takeoff and ldg had been completed without incident. During the second approach to landing, it was related…May 10, 1988 · N8641V · Substantial damageNTSB SEA88LA089Accident · No injuriesLimited investigationFinal reportCessna 172 · Kennewick, WADuring landing roll the aircraft's nose gear began to shudder, with the nose gear turning 90 degrees to the left. The aircraft then nosed down onto the nose and right wing. Visual examination of the aircraft's shimmy dampener arm assembly revealed a previous…May 9, 1988 · N7090A · Substantial damageNTSB CHI88LA109Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Indianapolis, INMay 8, 1988 · N43DR · Substantial damageNTSB ATL88LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Bowling Green, OHThe plt reported that he reduced the pwr to idle while on final appch after determining that the airplane was too high. He then lowered the nose to 'accelerate the descent'. The airplane touched down long on the rwy at about 90 KTS, and began to porpoise. He…May 7, 1988 · N5495K · Substantial damageNTSB ANC88LA054Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Hunter Creek, AKAfter landing at a mining camp airstrip, the right landing gear failed causing the aircraft to ground loop. Examination of the broken gear part revealed the original fracture to be a fatigue fracture. The initial crack in the gear leg ran parallel to the gear…May 6, 1988 · N22901 · Substantial damageNTSB LAX88LA175Accident · No injuriesLimited investigationFinal reportCessna 152 · Upland, CAThe student pilot's flt purpose was to practice takeoffs & landings at a different arpt. When he departed, the winds were the same as the dest arpt. The CFI felt that a weather briefing was not required. The student touched down on rwy 24 & the acft began…May 5, 1988 · N25294 · Substantial damageNTSB CHI88LA107Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lake Village, INThe pilot had landed long and, realizing he would not stop before running off the runway, attempted a go-around. The pilot stated he had one notch of flaps down, approximately 10 degrees, and after adding full power attempted to lift-off. The aircraft ran off…May 5, 1988 · N55552 · Substantial damageNTSB ATL88LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lawrenceville, GAThe student plt returned to the departure arpt and attempted a landing with a cross wind gusting to an estimated 20 KTS. After landing, a gust of wind was encountered. The aircraft became airborne. The student pilot held the aircraft's controls rigid. The…May 5, 1988 · N8205 · DestroyedNTSB CHI88LA106Accident · No injuriesLimited investigationFinal reportNorth American AT-6D · Eden Prairie, MNWhile on an aircraft familiarization for purpose of check out, the pilot encountered a gusty crosswind on landing and failed to maintain aircraft control. The instructor pilot took over the controls, but was unable to regain directional control, and the…May 3, 1988 · N29935 · Substantial damageNTSB ATL88LA164Accident · No injuriesLimited investigationFinal reportPiper PA-31-325 · Wilkesboro, NCAfter a normal approach and landing, the left main gear slowly collapsed during the roll out. The aircraft veered to the left, struck a sign off the runway edge and collided with a ditch. The left main gear was found unlocked during postaccident…May 3, 1988 · N34GK · Substantial damageNTSB LAX88DVA04Accident · 1 fatalFinal reportSchumann KR-2 · Merced, CAThe pilot was flight testing a new airplane that he had constructed. He had completed two touch and go landings. During a third approach, witnesses observed the airplane approaching the runway at a very high airspeed. The airplane touched down on the runway…May 2, 1988 · N127AS · DestroyedNTSB LAX88LA171Accident · No injuriesLimited investigationFinal reportCessna 180B · Quincy, CAAt the end of a pleasure flight, while in the traffic pattern, the pilot noted that the winds were light and variable. While on final approach, a correction for drift was made. During the landing roll, in gusting conditions, the pilot lost control of the…May 1, 1988 · N5104E · Substantial damageNTSB DEN88LA104Accident · No injuriesLimited investigationFinal reportBeech H35 · Ruidoso, NMMay 1, 1988 · N618T · Substantial damageNTSB BFO88LA043Accident · No injuriesLimited investigationFinal reportBeech C23 · Manassas, VAThe plt said that earlier he attempted to land at carlisle, pa and during the lndg roll he encountered a wind gust and lost directional control of the acft. The r wing raised and the acft went off the side of the rwy. The plt said he heard a loud bump as the…May 1, 1988 · N9358S · Substantial damageNTSB ATL88LA160Accident · No injuriesLimited investigationFinal reportCessna 172N · Gilbert, SCThe airplane overran rwy 23 during ldg and nosed over. The plt reported that he attempted to abort the ldg after initially landing long on the rwy. As the airplane began to climb however, he realized that it would not clear obstacles located past the end of…May 1, 1988 · N5085K · Substantial damageNTSB NYC88LA135Accident · No injuriesLimited investigationFinal reportGrumman AA5B · Morristown, NJA loss of control due to improper technique after a bounced landing. Contributing was the second pilot also attempting to correct the situation.Apr 30, 1988 · N4557Q · Substantial damageNTSB LAX88LA173Accident · No injuriesLimited investigationFinal reportChampion 7CCM · Cameron Park, CAWhile practicing touch and go landings, the pilot reported that a wind from behind caught the tail of the aircraft. The pilot overcorrected and ground looped the aircraft. The aircraft veered off the runway and nosed over. The pilot reported that there were…Apr 30, 1988 · N6712C · Substantial damageNTSB DEN88LA105Accident · No injuriesLimited investigationFinal reportCessna 185F · Erie, COThe commercial plt was practicing touch and go landings during a local flight. During landing roll on the last landing, the pilot reached down to retract landing flaps and opened the cowl flaps. He then became aware that the aircraft was turning right. Left…Apr 30, 1988 · N8389Q · Substantial damageNTSB CHI88LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-140D · Whittemore, MIWhile landing on a farmer's strip, the pilot failed to maintain directional control of the aircraft. The aircraft swerved off the left side of the strip, into a plowed field where it struck a rock.Apr 30, 1988 · N6433R · Substantial damageNTSB CHI88LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140D · Flushing, MIWhile on final approach for landing on a short, grass strip, the pilot said she encountered sunglare which restricted her visibility such that she was unable to judge the landing. Touchdown occurred with insufficient runway remaining to stop the aircraft. The…Apr 30, 1988 · N5965U · Substantial damageNTSB BFO88LA037Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Wise, VAThe student plt was on his first solo flight and attempting his second solo landing when he was unable to maintain directional control in a left crosswind. The acft drifted right and the plt attempted to do a go-around to avoid going off the side of the rwy.…Apr 30, 1988 · N7947N · Substantial damageNTSB MKC88LA093Accident · No injuriesLimited investigationFinal reportBeech 95 · Shell Knob, MOThe pilot of the accident aircraft failed to maintain directional control during the landing roll. The left wing of the aircraft struck trees along the left side of the runway. Aircraft control was lost resulting in the right main landing gear collapsing.Apr 29, 1988 · N635B · Substantial damageNTSB MKC88LA084Accident · Serious injuriesLimited investigationFinal reportRaven S-55 · Burlington, IAWhile attempting to land the balloon during a commercial operation, a dust devil was encountered. The balloon and gondola twisted and pitched violently. During a hard landing, the PIC was thrown from the aircraft, and the aircraft continued to bounce along…Apr 29, 1988 · N6436U · Substantial damageNTSB MKC88LA080Accident · No injuriesLimited investigationFinal reportBeech F17D · Perryville, MODuring the landing phase of operation, the propeller struck the runway several times prior to the acft making a gear up ldg. After the acft came to a stop, a post flight fire erupted destroying the acft. Evidence of gear up landing was confirmed after post…Apr 29, 1988 · N385 · DestroyedNTSB BFO88LA038Accident · No injuriesLimited investigationFinal reportCessna 172M · Fayetteville, WVThe pilot landed long and with excessive airspeed, which resulted in an overrun of the runway. Inadequate inflight planning is a contributing factor.Apr 29, 1988 · N13261 · Substantial damageNTSB SEA88LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Elko, NVDuring landing roll the pilot lost directional control of the aircraft with a groundloop resulting. The pilot had a total time of 17 hours in this type of aircraft and 152 hours total flight time.Apr 28, 1988 · N2952C · Substantial damageNTSB SEA88LA085Accident · No injuriesLimited investigationFinal reportBeech 35 · Pasco, WADuring lndg roll, NLG and rmlg collapsed. During tow in from rwy, lndg gear cb was noted to be tripped. Cause of cb activation unk.Apr 28, 1988 · N2839V · Substantial damageNTSB FTW88LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Lamont, OKThe pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was…Apr 28, 1988 · N2645F · Substantial damageNTSB FTW88DQG04Accident · No injuriesFinal reportPiper PA-28-201T · Shallowater, TXThe pilot lost directional control during the landing roll with a strong left crosswind on a narrow runway. A go-around was attempted but the aircraft drifted right and received substantial damage when it touched down in soft terrain.Apr 28, 1988 · N30273 · Substantial damageNTSB DEN88LA101Accident · No injuriesLimited investigationFinal reportCessna 172Q · Englewood, COApr 28, 1988 · N96299 · Substantial damageNTSB NYC88LA129Accident · Minor injuriesLimited investigationFinal reportChampion 7KCAB · Dracut, MAThe pilot said that while making a normal approach for a 'glassy water' landing on a lake, he flared high and stalled the airplane. The right wing dropped off and the airplane crashed into the water.Apr 27, 1988 · N9712N · Substantial damageNTSB LAX88LA174Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Chico, CAApr 27, 1988 · N6601P · Substantial damageNTSB DEN88LA102Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Great Falls, MTThe private plt was returning home from a personal transportation flight with one pax, another private plt. Both men reported that while on final for rnwy 25, the sun was in their eyes and hindered their vision. The plt in command stated that he cannot…Apr 27, 1988 · N79P · DestroyedNTSB ATL88LA157Accident · No injuriesLimited investigationFinal reportCessna 180A · Danville, KYThe plt performed a wheel landing and attempted to hold the tailwheel off the runway surface with nose down elevator. The right wing began to lift and the acft veered to the right. Remedial control inputs were made and the left main landing gear axle…Apr 26, 1988 · N9712B · Substantial damageNTSB ANC88LA050Accident · No injuriesLimited investigationFinal reportCessna 180 · Fairbanks, AKThe pilot returned to Fairbanks int'l airport from an intended cross-country flight due to deteriorating weather. During the flight the airplane felt out of trim, and she elected to land on the longest runway available (10,300). During the landing roll she…Apr 25, 1988 · N91290 · Substantial damageNTSB MIA88LA159Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Kissimmee, FLWhile landing on runway 24 in strong gusty crosswind conditions the student plt lost control of the aircraft. While making a go-around the aircraft drifted to the left side of the runway striking the VASI lights. The aircraft then continued on to the left…Apr 24, 1988 · N61027 · Substantial damageNTSB ATL88LA152Accident · No injuriesLimited investigationFinal reportCessna 172F · Walland, TNThe pilot attempted to abort a takeoff after experiencing a sudden gust of wind at liftoff. The aircraft collided with a fence and ditch which caused substantial airframe damage. The pilot reported the winds gusting to 15 knots. There was no reported aircraft…Apr 22, 1988 · N1414U · Substantial damageNTSB MIA88LA158Accident · No injuriesLimited investigationFinal reportBeech E55 · Pahokee, FLWhile on an instructional flt practicing short & soft field landings, the acft was landed gear up. The instructor plt stated there was no failure or malfunction of the landing gear warning horn and that when the throttle was retarded fully the horn sounded.Apr 21, 1988 · N81893 · Substantial damageNTSB NYC88LA115Accident · No injuriesLimited investigationFinal reportMaule M-6-235 · Walton, NYThe pilot decided to land on a sod strip. He bounced once, then lowered the nose to keep it on the ground. The prop dug into the ground and the aircraft flipped over. The pilot reported that he was practicing manuevers and wanted to practice a sod landing.Apr 20, 1988 · N366X · Substantial damageNTSB MIA88LA154Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · Orlando, FLThe plt stated that the winds started to pick up & he decided to land. During the apch just before touchdown, the gondola struck a tree, causing the occupants to fall against each other, breaking one of the passengers legs.Apr 18, 1988 · N6583C · Minor damage