OpenAirDocs.org

NTSB investigations

53,704 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 ANC86FA071Accident · Serious injuriesField investigationFinal reportPiper PA-18 · Girdwood, AKThe instructor pilot gave the student pilot a forced landing while on left base to runway 19. The student continued the approach at approximately 200 feet noticed the rate of descent increasing. The student applied full power but the airplane continued to…Jun 10, 1986 · N4418Z · Substantial damageNTSB MKC86LA127Accident · No injuriesLimited investigationFinal reportCessna 172F · Jefferson City, MOThe runway was under construction with a new section being added to the old runway. This construction was covered in a published NOTAM. The pilot had been making touch and go landings and was making a full stop landing when he landed on the new portion of the…Jun 9, 1986 · N5695R · Substantial damageNTSB ANC86LA067Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Deshka River, AKThe pilot stated while landing at an unimproved airstrip the aircraft's left main landing gear struck a bush causing the aircraft to ground loop.Jun 9, 1986 · N31285 · Substantial damageNTSB ATL86LA164Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Benton, TNThe glider landed short of the rwy. The plt had observed another acft on the rwy apch end and extended his base leg. During the turn to final, he deployed the spoilers. He reported that the acft experienced a high sink rate after the turn, and that he…Jun 8, 1986 · N2135R · Substantial damageNTSB LAX86FVA08Accident · Serious injuriesFinal reportNelson/Nelson Varieze · Merced, CAWhile on final approach witnesses observed the aircraft to be low and slow when the wing collided with a light stanchion (5' high). The left wing banked sharply to the left, hit the ground and the acft cartwheeled. The pilot reported no mechanical problems…Jun 7, 1986 · N615EZ · DestroyedNTSB BFO86FID07Accident · No injuriesFinal reportCessna 172M · Lynchburg, VAThe accident occurred as the plt was attempting to land at an unfamiliar arpt during a x-country flt because a passenger was feeling ill. The rwy was 2900 ft long with a 5% upslope at mid-field. The plt stated he misjudged his alt and airspeed during the…Jun 6, 1986 · N20372 · Substantial damageNTSB SEA86LA136Accident · No injuriesLimited investigationFinal reportCessna 185 · Boise, IDDuring rollout after landing, the pilot was asked by the tower to expedite clearing the runway due to landing traffic. As the aircraft had slowed, the pilot attempted a turnout when a groundloop occurred. A gust of wind precipitated the groundloop. The wind…Jun 5, 1986 · N9397N · Substantial damageNTSB FTW86LA105Accident · No injuriesLimited investigationFinal reportMaule M7-235 · New Orleans, LAThe plt lost directional control of the acft during the landing roll when he failed to compensate adequately for the x-wind resulting in a ground loop.Jun 5, 1986 · N232T · Substantial damageNTSB BFO86LA033Accident · No injuriesLimited investigationFinal reportCessna 152-II · Gaithersburg, MDWith the wind out of the east at about 10 knots, the student pilot touched down on the centerline of runway 32. Shortly thereafter, the aircraft swerved right and then left and the CFI attempted to take over the controls. She stated that she could not…Jun 5, 1986 · N94214 · Substantial damageNTSB ATL86LA268Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roanoke, ALReportedly, during the landing roll, the acft went off the right side of the rwy and continued across a shallow ditch and down an embankment. The plt stated that the acft did not RESP0ND to control and brake inputs to correct the swerve in calm winds. The FAA…Jun 5, 1986 · N8838K · Substantial damageNTSB ANC86LA065Accident · No injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot stated that after the landing roll, directional control of the aircraft was lost causing the aircraft to exit the left side of the runway striking an airport sign.Jun 5, 1986 · N9747 · Substantial damageNTSB MIA86LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Bartow, FLThe plt stated that she landed hard on the nose wheel and the prop struck the ground, damaging the structure of the aircraft.Jun 4, 1986 · N5456D · Substantial damageNTSB SEA86LA138Accident · No injuriesLimited investigationFinal reportRose A4C · Winnemucca, NVDuring landing roll the pilot lost directional control of the aircraft. The right main gear collapsed dragging the right wing.Jun 3, 1986 · N14884 · Substantial damageNTSB NYC86LA143Accident · No injuriesLimited investigationFinal reportCessna 140 · Meriden, CTDirectional control was lost during landing roll out. The pilot attempted to correct and return the aircraft to the runway. The airplane ground looped causing substantial damage.Jun 3, 1986 · N2286N · Substantial damageNTSB CHI86LA150Accident · No injuriesLimited investigationFinal reportCessna 182F · Hillsboro, WIThe pilot stated that following touchdown a gust of wind caused the aircraft to balloon back into the air. The second touchdown was in a crab angle and the aircraft began to slide sideways. The right wing struck the runway just as the aircraft departed the…Jun 3, 1986 · N3567Y · Substantial damageNTSB SEA86LA135Accident · Minor injuriesLimited investigationFinal reportGrumman G21A · Hobart Bay, AKThe pilot neglected to raise the landing gear after departing the airport. While landing onto water with the gear still down, the aircraft's nose broke off and the aircraft nosed over inverted and then sank.Jun 1, 1986 · N37487 · Substantial damageNTSB CHI86LA148Accident · No injuriesLimited investigationFinal reportCessna 182K · Durand, WIAccording to the pilot, winds at the time of the accident were out of the southwest at 10 gusting to 15 knots. He stated that upon landing on runway 18, the aircraft lifted slightly and rotated approximately 10 degrees to the right. It then ran off the edge…Jun 1, 1986 · N2669Q · Substantial damageNTSB CHI86FEM06Accident · No injuriesFinal reportCessna 170 · Houghton Lake, MIThis student pilot on his initial solo flight bounced the acft during landing. On the second bounce, the pilot inadvertently applied the toe braked and aircraft nosed over.Jun 1, 1986 · N4155V · Substantial damageNTSB ATL86LA152Accident · No injuriesLimited investigationFinal reportForney F-1 · Abbeville, SCThe student plt reported that the acft's brake system was inoperative during ldg rollout. The acft ran off the end of the rwy end into a trash pile and collided with pine logs.Jun 1, 1986 · N7567C · Substantial damageNTSB LAX86LA239Accident · No injuriesLimited investigationFinal reportCessna 150 · Gasquet, CAThe pilot stated that, as he entered the traffic pattern, the windsock for runway 24 indicated about five knots of wind straight down the runway. He further stated that, as he was about to touch down, a sudden cross wind caused the aircraft to 'nose to the…May 31, 1986 · N22MS · Substantial damageNTSB ATL86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Warren, OHDuring a normal takeoff, the pilot decided to abort the takeoff after he determined that the aircraft was not accelerating as fast as he thought it should. After the aircraft touched down on the sod surface, the pilot proceeded toapply full braking. Since the…May 31, 1986 · N3564Z · Substantial damageNTSB MIA86LA170Accident · No injuriesLimited investigationFinal reportCessna 177RG · Jacksonville, FLThe plt stated that the landing gear indicator light showed the gear to be down & locked. When the acft touched down the landing gear collasped and the acft slid to a stop. Post crash examination of the landing gear showed it to operate normally in all modes.…May 30, 1986 · N1888Q · Substantial damageNTSB NYC86LA139Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Johnstown, PAThe flight departed Johnstown-cambria airport at about 1600 hours and returned at about 1700 hours. On landing, the pilot forgot to lower the landing gear and landed gear up. The aircraft slid to a stop and about five minutes later fire erupted.May 29, 1986 · N80611 · Substantial damageNTSB FTW86LA094Accident · No injuriesLimited investigationFinal reportCessna 172N · Vega, TXThe pilot was practicing touch and go landings, when the aircraft began veering to the left after landing. He tried to apply full right rudder, but the aircraft continued to veer left off the runway. The pilot pulled the nose up to clear a tractor. The…May 28, 1986 · N6352D · DestroyedNTSB CHI86LA145Accident · No injuriesLimited investigationFinal reportCessna 182P · Platteville, WIThe plt landed the acft on rwy 7 which was wet. Winds at the time were from 120 degs at 12 KTS. The plt stated that the wind caused the acft to skid and travel off the left side of the rwy. The acft nosed over after contacting soft soil alongside the rwy.May 27, 1986 · N84118 · Substantial damageNTSB ANC86LA063Accident · No injuriesLimited investigationFinal reportCessna 140 · Bradley Ski, AKThe pilot stated that after touchdown he lost control of the aircraft causing the plane to nose over on its back. At the time of the accident the wind was less than six knots.May 27, 1986 · N1661V · Substantial damageNTSB LAX86LA234Accident · No injuriesLimited investigationFinal reportMooney M-18C · Lakeport, CAThe plt indicated that there was a gusty left crosswind present during landing. The acft drifted right off the 40 ft wide asphalt rwy and collided with a small ditch and dirt bank. The acft then nosed over into the arpt drainage ditch.May 26, 1986 · N4146 · Substantial damageNTSB FTW86LA090Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Fort Worth, TXThe student plt was practicing touch and go landings when he landed nose wheel first, causing the acft to bounce several times and veer off the rwy toward a ditch. The student plt, in his attempt to avoid the ditch, over compensated with the brakes and the…May 26, 1986 · N94479 · Substantial damageNTSB DEN86LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Decker, MTThe plt attempted to make a downwind landing in a grass covered pasture, landed long and attempted to make a go-around. During the go-around with the flaps retracted the aircraft struck a wire fence and impacted a horse trailer. The aircraft was destroyed.…May 26, 1986 · N4043E · Substantial damageNTSB SEA86LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Raymond, WAThe pilot chose to land at an alternate airport to await improving weather. During a gusty crosswind, loss of directional control occurred during landing flare. The aircraft departed the runway to the left and nosed over inverted.May 25, 1986 · N6471M · Substantial damageNTSB MIA86LA169Accident · No injuriesLimited investigationFinal reportCessna 172RG · Jackson, MSThe plt stated that she intentionally landed gear up because the nose wheel well doors were jammed closed and would not allow the gear to completely lock down. Examination of the nose landing gear revealed that the nose gear up stop bumper plate assembly fell…May 24, 1986 · N4596V · Substantial damageNTSB LAX86LA232Accident · No injuriesLimited investigationFinal reportCessna 172 · Huntington Bch, CAThe acft contacted a parked car and a hangar following a loss of control during an attempted go-around. The plt reported the acft was high and fast on final apch. He selected full flaps and a nose up attitude to lose airspeed and alt. He flared the acft at 20…May 24, 1986 · N172HW · Substantial damageNTSB ATL86LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Statesville, NCThe pilot allowed the aircraft to stall and touchdown short of the runway while competing in a power off spot landing competition. The pilot stated that the accident could have been prevented by simply adding power.May 24, 1986 · N9778C · Substantial damageNTSB ANC86LA060Accident · 1 fatalLimited investigationFinal reportCessna 180 · Iliamna, AKThe pilot stated that at the time of the accident the wind was 30 knots gusting to 35 knots. After touchdown on the water, the pilot lost control of the aircraft causing the aircraft to nose over on its back and sink.May 23, 1986 · N52189 · Substantial damageNTSB MKC86LA116Accident · No injuriesLimited investigationFinal reportChampion 7KCAB · Crete, NEThe plt of this tail-wheel acft attempted a landing on a rwy with a strong x-wind. After a go-around, he started an apch to a turf rwy that was better aligned with the wind but made a go-around when he thought the grass was too high. He then attempted another…May 22, 1986 · N5229X · Substantial damageNTSB ATL86LA139Accident · No injuriesLimited investigationFinal reportMooney M20K · Peachtree City, GAThe plt reported that the acft began to 'wheelbarrow' on the nose gear during the ldg roll. The acft veered off the rwy into a ditch. The plt said that he might not have had the pitch trim set correctly at touchdown. The acft flt manual before landing…May 22, 1986 · N98544 · Substantial damageNTSB MIA86LA164Accident · No injuriesLimited investigationFinal reportCessna 152 · Stuart, FLThe student plt was on his first supervised solo flt and was attempting his third landing. During the flare, the acft ballooned, nosed over and struck the rwy on the nose gear. The acft then burst into flames and was consumed by fire. Theplt was able to exit…May 20, 1986 · N20SQ · DestroyedNTSB ATL86LA136Accident · No injuriesLimited investigationFinal reportBeech A36 · Swansboro, NCThe plt reported that the acft touched down about 700 ft down the 2700 ft sod rwy. The rwy was wet from rain and braking action was nil. The plt elected to stay on the rwy and continue braking efforts. The acft slid off the rwy end into a drainage ditch. The…May 20, 1986 · N103SM · Substantial damageNTSB ANC86LA059Accident · No injuriesLimited investigationFinal reportTaylorcraft TC-19 · Fairbanks, AKThe pilot stalled the acft during approach to a gravel bar and made a hard landing. The plt said that he needed to improve his proficiency at slow flying.May 20, 1986 · N2002V · Substantial damageNTSB NYC86LA137Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-2-32A · Kurtztown, PAAfter flying in thermals for about 45 minutes, the plts returned to the arpt to land. The instructor (CFI) stated they came over the initial approach point at about 1000 ft for a landing on runway 30. The glider passed over the end of the runway at about 150…May 19, 1986 · N2979H · Substantial damageNTSB MKC86LA111Accident · No injuriesLimited investigationFinal reportJackman Pitts S-1S · Montezuma, KSThe pilot stated that as the aircraft touched down on the runway the left wing struck crops in a wheatfield which arrested the forward motion of the wing. According to th e pilot, the aircraft veered out of control into the wheatfield, cartwheeled twice, and…May 19, 1986 · N39967 · Substantial damageNTSB DEN86LA140Accident · No injuriesLimited investigationFinal reportCessna 172B · Alamosa, COThe student plt had soloed that morning. After a short rest period he flew with his instructor. He then flew a second solo flt. The student plt made two landings. On the third approach the plt made a go-around. On the next approach the acft stalled close to…May 19, 1986 · N6990X · Substantial damageNTSB MKC86LA110Accident · No injuriesLimited investigationFinal reportMyers EAA BI-PLANE · Winfield, KSThe pilot stated he was landing his taildragger to the north with winds from the north at 12 to 15 knots. He said he was making a three point landing and just before touchdown, the airplane changed directions and after touchdown, it went off the side of the…May 18, 1986 · N1770B · Substantial damageNTSB LAX86LA230Accident · No injuriesLimited investigationFinal reportCessna 172B · Tracy, CAThe acft veered off a rural dirt road being used as an airstrip and nosed over in a farm field. The plt indicated that he was attempting to land on a narrow dirt farm road when the acft veered into a freshly plowed and irrigated tomato field. The nose gear…May 18, 1986 · N7176T · Substantial damageNTSB BFO86LA025Accident · Minor injuriesLimited investigationFinal reportCessna 340A · Washington, DCThe acft was reportedly too high to land on the rwy initially assigned by ATC. ATC directed the acft to fly over the arpt and enter downwind traffic for another rwy. The plt was later asked by ATC if he could make a short apch and he replied affirmative. The…May 17, 1986 · N6828P · Substantial damageNTSB ATL86LA134Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Enterprise, ALDuring the touchdown landing phase on runway 23, the aircraft veered off the left side and crashed following an attempted go-around. The pilot applied full power, but was unable to clear a tree line off the departure end. As the pilot elected to abort, the…May 17, 1986 · N25737 · Substantial damageNTSB MIA86LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tallahassee, FLWhile on final apch the acft was blown to the right of the rwy where the left wing struck a dirt mound. The acft then spun to the left and came to rest aprx 75 ft from the edge of the rwy. The plt stated that he decided to try and salvage the landing during…May 16, 1986 · N4986J · Substantial damageNTSB DEN86LA136Accident · No injuriesLimited investigationFinal reportCessna 421C · Albuquerque, NMAcft was landing on rwy 17. Plt said he struck a rabbit with left main landing gear and lost all braking action on left side. Plt used right brake to decelerate but overran rwy end and struck dirt bank.May 15, 1986 · N21WL · Substantial damageNTSB SEA86LA124Accident · Minor injuriesLimited investigationFinal reportCessna 206T · Murphy, IDThe pilot attempted to land with excessive airspeed and altitude. A bounced landing occurred with a touchdown being more than 2/3 way down the runway. During VFR co-around, a departure stall was entered and the aircraft struck the ground with the left wing…May 13, 1986 · N1046V · Substantial damageNTSB MKC86LA105Accident · No injuriesLimited investigationFinal reportBeech A36 · Mountain Home, ARThe PIC rptd gear failure and gear warning horn about 5 to 10 seconds into the landing roll. The PIC rptd 3 in the green before touchdown to the rwy. Subsequent inspection of the landing gear showed no mechanical or other deficiency. Inadvertent movement of…May 13, 1986 · N2015K · Substantial damage