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 LAX86LA217Accident · No injuriesLimited investigationFinal reportCessna 172N · Thermal, CAThe student pilot was returning to Thermal airport, Thermal, CA after completing a round robin solo cross country flight. While landing on runway 30 the student encountered a 90 degree right crosswind and lost control of the airplane. The airplane exited the…May 13, 1986 · N734TE · Substantial damageNTSB DEN86LA135Accident · No injuriesLimited investigationFinal reportCessna T210M · Erie, COThe plt reports that he remembers going through the checklist on downwind following a short flight from a nearby airport. He does not remember doing a final 'down and green' check and the aircraft was landed gear up.May 13, 1986 · N761XE · Substantial damageNTSB ANC86LA056Accident · No injuriesLimited investigationFinal reportCessna A185E · Tok, AKThe pilot-in-command stated that upon landing in a crosswind, a gust of wind caused the airplane to become airborne. Upon touching down again the airplane was in a crab and the pilot lost control and the airplane struck the left wingtip, then the right…May 13, 1986 · N4761Q · Substantial damageNTSB CHI86LA140Accident · No injuriesLimited investigationFinal reportCessna 150F · Gaylord, MIOn rollout, while the plt was attempting to correct a drift to the right, the acft suddenly veered to the left and the nose gear collapsed. During the resulting slide, the aircraft began burning and was destroyed. The plt reported that the magnesium hub of…May 12, 1986 · N6647F · DestroyedNTSB SEA86LA123Accident · Minor injuriesLimited investigationFinal reportBeech A23-24 · Sunnyside, WAAfter completing several touch and goes, the pilot lost control of the aircraft on landing rollout due to a light gusting crosswind. The pilot was unable to avoid departing the runway to the left striking a four foot embankment collapsing the nose gear.May 10, 1986 · N4841B · Substantial damageNTSB MKC86LA102Accident · No injuriesLimited investigationFinal reportAero Commander S2R · Almyra, ARThe plt stated that the landing was routine until he used the brakes. At this point the left wheel brake assembly came apart and the acft veered out of control off the right side of the rwy and into a ditch, where the left main landing gear collapsed. Post…May 10, 1986 · N5509X · Substantial damageNTSB MIA86LA153Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Clearwater, FLWhile attempting to land at an arpt at night without the use of rwy lights, the acft touched down to the right side of the rwy on the grass. The acft then collided with the VASI lights, the landing gear was severed, & the acft slid to a stop.May 10, 1986 · N9272C · Substantial damageNTSB DEN86LA133Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Walsh, COThe plt reports that he was landing to the south on the turf rwy with calm winds when the accident occurred. He said the landing was normal until the acft slowed to 40 to 50 mph at which time a whirlwind was encountered which lifted the right wing. The left…May 10, 1986 · N8812T · Substantial damageNTSB CHI86LA138Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Webster, WIDuring an attempted go-around after a bounced crosswind landing, pilot failed to maintain a proper ground track and the aircraft collided with trees.May 10, 1986 · N8239E · Substantial damageNTSB MIA86LA156Accident · No injuriesLimited investigationFinal reportCessna T210N · Destin, FLThe plt stated that the acft swerved to the left uncontrollably after he applied the brakes during the landing roll. The nose gear then collapsed and the acft slid off the rwy. Investigation revealed no preexisting mechanical malfunction.May 9, 1986 · N9563Y · Substantial damageNTSB LAX86LA216Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Riverside, CAThe CFI reported that during the landing roll on runway 24, at fla-bob airport, Riverside, CA, the airplane began to 'drift to the right.' The CFI applied left rudder to correct the excursion but his left foot slipped off the rudder bar and became lodged…May 9, 1986 · N994C · Substantial damageNTSB FTW86LA083Accident · Minor injuriesLimited investigationFinal reportCessna 210N · Tyler, TXThe pilot failed to flare the aircraft before touchdown, causing the aircraft to bounce and assume a nose down attitude, before it impacted the ground, although the pilot states he lost directional control due to locked controls, investigation did not reveal…May 9, 1986 · N6610Y · Substantial damageNTSB SEA86LA119Accident · No injuriesLimited investigationFinal reportCessna 172 · Yakima, WADuring rollout on the third touch & go landing the student had control of the acft. While preparing for a downwind takeoff the acft drifted across the rwy and into a grass area. The instructor was unable to regain directional control. The acft contacted a…May 7, 1986 · N5014E · Substantial damageNTSB MIA86LA258Accident · Minor injuriesLimited investigationFinal reportBrewster Fleet 7 · Arcadia, FLAccording to statements, the pilot experienced brake difficulty & the acft flipped over during landing rollout & came to rest inverted.May 7, 1986 · N756V · Substantial damageNTSB MIA86LA149Accident · Minor injuriesLimited investigationFinal reportLearjet 24 · Hollywood, FLThe plt stated he made a normal apch and landing but on rollout discovered he had no brakes. The acft traveled off the left side of the rwy and collided with a fence surrounding a ballpark. Post crash examination of the hydraulic system revealed that the…May 7, 1986 · N55NJ · Substantial damageNTSB ATL86FA125Accident · 1 fatalField investigationFinal reportBellanca 17-31ATC · Winchester, TNThe plt made a VFR pattern at an uncontrolled arpt and noted a truck alongside the north end of the rwy. The plt did notsee any persons on the rwy. During the landing flare the plt noticed a man on the rwy near the right wingtip. A jolt was felt as the acft…May 6, 1986 · N28138 · Substantial damageNTSB NYC86LA120Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Plymouth, MAThe acft touched down on a grass landing area and the nose gear collapsed. The acft appeared to have touched down between a crossing runway and taxiway, both of which are asphalt. There is a depression, aprx 18-24 inches deep, that the acft crossed. Wrinkles…May 5, 1986 · N624SK · Substantial damageNTSB NYC86LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Marshfield, MAThe student pilot was making touch and go's on runway 24 in a Piper tomahawk. The wind was from the north west at 12 knots. The pilots reported the wing rose and the aircraft drifted left with a gust. He stated he applied power for a go-around, however the…May 4, 1986 · N2389B · Substantial damageNTSB MKC86LA100Accident · No injuriesLimited investigationFinal reportCessna 170B · Monticello, IAThe plt stated that following a normal touchdown the wind picked up and overturned the acft. He had recently purchased the acft and was ferrying it home when the accident occurred. He further stated that he owned a tailwheel acft prior to purchasing this one,…May 4, 1986 · N66F · Substantial damageNTSB FTW86LA077Accident · No injuriesLimited investigationFinal reportCessna A185F · Georgetown, TXThe pilot failed to correct for a wing which was lifted in a gust of wind. The wingtip touched the ground and the aircraft nosed over onto it's back and stopped.May 4, 1986 · N102PM · Substantial damageNTSB ATL86FEI05Accident · No injuriesFinal reportPiper J3 · Wauseon, OHThe plt reported that he was landing on rwy 27 with the wind from about 190 degrees at 15 mph, gusting to 23 mph; he executed a normal ldg and was rolling out when a gust of wind lifted up the left wing and the acft ground-looped. The acft subsequently…May 4, 1986 · N40782 · Substantial damageNTSB SEA86LA117Accident · No injuriesLimited investigationFinal reportHanson Jungmann 131E · Las Vegas, NVDuring rollout after a left x-wind landing and while decelerating through aprx 20-25 mph, the plt encountered a wind gust. Directional control was lost and the acft nosed over as it departed the rwy. The plt reported having only 2 hrs total flt time in this…May 3, 1986 · N602HB · Substantial damageNTSB MIA86LA143Accident · No injuriesLimited investigationFinal reportMooney M20C · Starke, FLThe plt stated that during landing, he lost directional control of the acft due to crosswinds. He attempted to abort the landing, however, the landing gear contacted a cattle fence which resulted in a loss of control and impact with the terrain. The acft was…May 3, 1986 · N6926V · DestroyedNTSB SEA86LA116Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Twin Falls, IDDuring final apch the ATCT advised the plt of a 17 kt x-wind with gusts to 22 KTS. The plt landed but was unable to maintain directional control and the acft departed the rwy into a grass area. The plt attempted to takeoff again, the wind lifted up the wing…May 2, 1986 · N6494U · DestroyedNTSB NYC86LA116Accident · No injuriesLimited investigationFinal reportCessna 152 II · Pittstown, NJOn flare for landing, student pilot encountered wind shear and landed hard, collapsing the nose gear, bouncing off to the left of the runway, nose digging into soft turf, causing aircraft to come to rest inverted. Aircraft was substantially damaged.…May 2, 1986 · N94577 · Substantial damageNTSB LAX86LA204Accident · No injuriesLimited investigationFinal reportCessna 152 · Wickenberg, AZA Cessna 152 veered off the rwy and nosed over while on a VFR solo cross country training flt. The plt indicated that during roll the acft began oscillating up and down for aprx 100 feet of travel down the runway. The acft then veered left off the runway. The…May 2, 1986 · N48600 · Substantial damageNTSB ATL86LA124Accident · No injuriesLimited investigationFinal reportCessna 182A · Kenansville, NCDuring a landing attempt, the pilot failed to maintain directional control with a 15 knot right crosswind. The pilot stated that he applied rudder and braking, the aircraft drifted of the left side of the runway and collided with a ditch. The pilot did not…May 2, 1986 · N5334N · Substantial damageNTSB MKC86LA099Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Fulton, MOThe pilot and his passenger were on a short flight to check the operation of a VOR receiver. While they were on the landing roll, a gust of wind turned the nose of the airplane to the left and the airplane ran off the runway and the right gear hit a runway…May 1, 1986 · N3XX · Substantial damageNTSB MIA86LA140Accident · No injuriesLimited investigationFinal reportCessna 182P · Hastings, FLThe plt stated she landed long and over ran the runway. She continued to state a go-around should have been performed.May 1, 1986 · N1279S · Substantial damageNTSB DEN86LA123Accident · No injuriesLimited investigationFinal reportCessna 152 · Englewood, COAccording to the student plt, he flared too high during landing & landed hard, collapsing the nose gear.May 1, 1986 · N94703 · Substantial damageNTSB CHI86LA136Accident · No injuriesLimited investigationFinal reportCessna 404 · Marquette, MIThe acft was landed on snow covered rwy 26 with winds from 300 degs at 20 KTS gusting to 30 KTS. Directional control of the acft was lost during the first third of the landing roll and it traveled off the left side of the rwy. The acft entered soft terrain…May 1, 1986 · N313R · Substantial damageNTSB LAX86LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fallbrook, CAA Piper PA-38-112 veered off rwy 36. The wx reporting station located 6 NM se of the arpt reported that the winds were from 180 deg at 7 KTS during the period that the accident occurred. The plt indicated that he misinterpreted the arpt wind indicator and…Apr 30, 1986 · N25954 · Substantial damageNTSB SEA86LA115Accident · No injuriesLimited investigationFinal reportCessna 172 · Twin Falls, IDWhile landing for the fifth and final touch and go, the pilot touched down at about midfield, due to too high of an approach. Rather than go-around, the pilot selected heavy braking. The aircraft then veered to the right, struck a mound of dirt sheering off…Apr 28, 1986 · N3580Q · Substantial damageNTSB SEA86LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Ellensburg, WAThe student plt was attempting to land in high gusting x-winds. The wind was from about 290 degs at 30 KTS gusting to 35 KTS, the rwy heading is about 340 degs. The plt allowed the airspeed to decay to 40 KTS just prior to the flare and a hard flat landing…Apr 28, 1986 · N7198A · Substantial damageNTSB CHI86LA128Accident · Serious injuriesLimited investigationFinal reportCameron O-65 · Pickney, MIThe balloonest had briefed and positioned his two pax for a anticipated hard/drag landing in a 9 kt wind. He stated the balloon touched and bounced then touched and bounced again before it entered the drag sequence of the landing. The female pax suffered a…Apr 28, 1986 · N298CB · No damageNTSB LAX86LA212Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3A · Lower Lake, CAWhen the acft departed lampson arpt the left ldg gear did not retract. Gnd witnesses reported the airplane landed with only the left gear extended. The plt reported he observed all three ldg gear down green lights illuminated while in the traffic pattern. The…Apr 27, 1986 · N8549R · Substantial damageNTSB LAX86LA196Accident · No injuriesLimited investigationFinal reportCessna 172N · Columbia, CAThe plt misjudged the flare during landing and the acft touched down in a nose low attitude shearing the nose gear from the acft. The density altitude was calculated to be 3,500 ft when the accident occurred.Apr 27, 1986 · N7338F · Substantial damageNTSB LAX86LA194Accident · No injuriesLimited investigationFinal reportCessna 150H · Davis, CAThe acft landed on a privately own ranch dirt airstrip. The plt reported the landing was normal, but during the landing roll the acft nosewheel struck a small ditch causing it to nose over onto its back. The pilot did not report any preimpact acft…Apr 27, 1986 · N50007 · Substantial damageNTSB CHI86LA133Accident · No injuriesLimited investigationFinal reportLet L-13 · Gregory, MIThe pilot stated that during landing the right wing of the glider touched the ground causing a right turn. The left wing then caught on a truck tire causing a 70 degree turn to the left. The glider was stopped when the right wing struck a barn. He was later…Apr 27, 1986 · N30LH · Substantial damageNTSB SEA86LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dallas, ORA precautionary landing was made due to deteriorating weather. Directional control was lost while attempting to land on the 70 foot wide, wet, grass airstrip during gusty crosswinds. The aircraft veered to the side of the runway striking four parked…Apr 26, 1986 · N8312K · Substantial damageNTSB MIA86LA134Accident · No injuriesLimited investigationFinal reportCessna 310L · Opa Locka, FLThe right main landing gear collapsed on the landing rollout, after which the acft slid off the right side of the rwy & came to rest on the grass. Post crash examination of the landing gear retract system revealed that the right main gear retract push pull…Apr 26, 1986 · N216Y · Substantial damageNTSB ATL86LMG06Accident · No injuriesFinal reportRussell Acro MR3 · Clio, SCThe plt reported that the home-built acft experienced a loss of aileron control during lndg. He continued the lndg, using the rudder and throttle to control the acft. The acft hit a tree-top adjacent to the rwy and crashed into a plowed field next to the…Apr 26, 1986 · N3MR · DestroyedNTSB ANC86LA049Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Polly Creek, AKThe pilot attempted a landing on a sandbar. During the landing roll the pilot lost directional control of the aircraft causing the airplane to ground loop and then nose over on its back.Apr 26, 1986 · N1616G · Substantial damageNTSB MIA86LA132Accident · No injuriesLimited investigationFinal reportCessna 402B · Opa Locka, FLThe plt stated that upon arrival at his destination he could not get his landing gear to extend. He then returned to Opa Locka airport where he intentionally landed with the gear up. Post crash investigation of the acft revealed that the landing gear would…Apr 25, 1986 · N401NA · Substantial damageNTSB LAX86LA190Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Temecula, CAThe plt reported that while on final apch to land, a moderate crosswind prevailed. Before reaching the rwy threshold the wind appeared to stop. When he began to flare a violent wind gust from the right lifted the right wing. Before he could reestablish…Apr 25, 1986 · N714AW · Substantial damageNTSB ANC86LA048Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Soldotna, AKThe pilot stated that the aircraft is not equipped with a header tank on the fuel system. The engine was starved of fuel when in a shallow dive.Apr 24, 1986 · N78564 · Substantial damageNTSB MKC86LA096Accident · No injuriesLimited investigationFinal reportCessna 182M · Mountain Home, ARThe acft nose gear collapsed during a hard landing. The plt stated that his original destination was gastons arpt, lakeview, AR, which has a turf rwy. There are three other arpts in close proximity to gastons, but all have paved rwys. He further stated that…Apr 23, 1986 · N71551 · Substantial damageNTSB MIA86LA130Accident · No injuriesLimited investigationFinal reportPiper PA-60 · Panama City, FLThe plt stated that on his apch he had a gear down & locked indication but on landing rollout, the nose gear completely collapsed and the acft slid to a stop on the rwy. Post accident examination of the landing gear system revealed that the nose gear…Apr 23, 1986 · N90676 · Substantial damageNTSB LAX86LA189Accident · Serious injuriesLimited investigationFinal reportCessna 195A · San Rafael, CAThe two aircraft collided on the runway during landing approach. The Cessna pilot had washed his aircraft and had made a local flight to dry it off. The beeck pilot was returning from a nearby airport where an annual inspection had been performed. Witnesses…Apr 23, 1986 · N4496C · 2 aircraft · Substantial damageNTSB NYC86LA110Accident · No injuriesLimited investigationFinal reportCessna C-310R · Buffalo, NYThe pilot of the C-310R stated upon landing flare he heard a loud noise on the right side. His speed was such that he became airborne again on relanding right propeller blades struck runway. Aircraft suffered major wing and structural damage.Apr 22, 1986 · N1909G · Substantial damage