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 SEA88LA136Accident · No injuriesLimited investigationFinal reportCessna 210 · Baker, NVThe pilot stated he landed long on unattended grass strip due to gusty wing conds. The aircraft encountered a ditch or vehicle track hidden by vegetation, shearing nose gear and collapsing left main.Jul 6, 1988 · N6524X · Substantial damageNTSB MIA88LA216Accident · No injuriesLimited investigationFinal reportWaco UPF-7 · Key West, FLWhile on a sightseeing flt, during the landing roll with a direct crosswind from the rt at 9 KTS, the plt reported that the acft turned into the wind. He was unable to correct this with left rudder & braking before the acft travelled into a ditch. He further…Jul 6, 1988 · N32133 · Substantial damageNTSB CHI88LA154Accident · Minor injuriesLimited investigationFinal reportMooney M20J · Thief Rvr Falls, MNJul 5, 1988 · N11652 · Substantial damageNTSB BFO88LA064Accident · No injuriesLimited investigationFinal reportHughes 369D · Clarksburg, WVThe student and instructor practiced several maneuvers. At the time of the accident they were doing straight-in landings. The student did one landing after a demo by the instructor. The student was doing his second landing which the instructor described as…Jul 5, 1988 · N32CT · Substantial damageNTSB NYC88LA176Accident · No injuriesLimited investigationFinal reportLake LA-4 · Linden, NJHard landing due to improper level off of the student and the flight instructor's inadequate supervision. The left wing partially failed because of overload and the aircraft made a forced landing in a swamp.Jul 4, 1988 · N6655L · Substantial damageNTSB CHI88LA158Accident · Serious injuriesLimited investigationFinal reportRaven S55A · Mishawaka, INAfter short personal flight, the pilot of the balloon made a landing in an open field. The gondola turned over and was dragged through the field. The pax suffered serious injuries.Jul 4, 1988 · N4186E · No damageNTSB CHI88LA152Accident · No injuriesLimited investigationFinal reportCessna 172M · Breckenridge, MIThe student pilot was attempting to land on the private airstrip when the aircraft touched down hard on the runway. The aircraft bounced back up into the air. The pilot was unable to maintain control of the aircraft and upon impacting back onto the runway the…Jul 4, 1988 · N20058 · Substantial damageNTSB DEN88LA144Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Colorado Spring, COThe plt and pax departed st. louis and stopped twice enroute due to wx. The plt was given landing clearance on rwy 17 at Colorado springs and the wind was reported to be from 190 degrees at 12 KTS. Witnesses at the arpt stated N4878S 'porpoised' several times…Jul 3, 1988 · N4878S · Substantial damageNTSB ATL88LA209Accident · No injuriesLimited investigationFinal reportCessna 195A · Memphis, TNThe plt reported that the left wheel separated from the airplane during ldg rollout on rwy 27, allowing the left gear to drag on the rwy. The airplane then bounced, veered to the right, and skidded to a stop. The left ldg gear collapsed as the acft stopped.…Jul 3, 1988 · N1576D · Substantial damageNTSB LAX88LA248Accident · Serious injuriesLimited investigationFinal reportCessna 177RG · Weaverville, CAAt the end of a cross country flt, the plt was landing the airplane in a 5 kt, gusting to 10 kt tailwind. The airplane did not touch down until past mid-field and the plt said the brakes were not effective until two thirds of the way down the rwy. The…Jul 2, 1988 · N1532H · Substantial damageNTSB CHI88LA149Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Grafton, WIWhile landing at a 1,900' sod airstrip with a 10 knot crosswind, the aircraft swerved to the left, ran off the runway and struck some small trees and shrubs. The pilot lacked total experience in low wing aircraft and lacked familiarity with that particular…Jul 2, 1988 · N2496K · Substantial damageNTSB CHI88DEC04Accident · No injuriesFinal reportPerkins Dragonfly · Fowlerville, MIThe pilot failed to maintain positive control of his homebuilt aircraft by taking appropriate actions for recovery from the bounced landing. The aircraft contacted the ground abruptly on the third bounce and the upper wing spar failed. The pilot's lack of…Jul 2, 1988 · N192AP · Substantial damageNTSB LAX88DVG08Accident · No injuriesFinal reportGrumman G-164A · Gridley, CADuring the landing roll, the left wing caught on high weeds. The pilot lost control of the airplane, veered off the landing strip, and collided with a ditch paralleling the runway. There were no reported mechanical failures or malfunctions with the airplane…Jul 1, 1988 · N7933 · Substantial damageNTSB CHI88LA150Accident · Serious injuriesLimited investigationFinal reportRockwell 112A · Sandusky, OHThe pilot failed to maintain directional control after making a bounched landing. Additionally, the pilot failed to add full power after the bounched landing prior to striking trees to the left of the runway.Jul 1, 1988 · N1463J · Substantial damageNTSB ANC88LA079Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Hooper Bay, AKThe commercially certificated pilot was attempting to land in winds estimated as 30 knots gusting to 40. He reportedly hit a downdraft just piror to landing and had a harder than normal touchdown. During the later stages of the landing roll-out, he applied…Jul 1, 1988 · N15268 · Substantial damageNTSB SEA88IA121Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-8-73F · Seattle, WACrew noted inflight indications of loss of hydraulic fluid, then carried out standard procedures per crew manual. Emerg hyd sys used to lower flaps for lndg. Acft landed with four right brakes locked. The tires blew and the wheels were ground flat.…Jun 30, 1988 · N791FT · Minor damageNTSB MKC88LA118Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Olathe, KSAfter a long cross country flight, the pilot said he encountered heavy rain and thunderstorms near his destination. He reported that he was able to continue the flight under VFR, but when landing on the wet runway braking was ineffective. The airplane…Jun 30, 1988 · N8328A · Substantial damageNTSB MIA88LA209Accident · No injuriesLimited investigationFinal reportCessna 152 · Titusville, FLThe plt stated that on approach for landing the acft developed a high sink rate. The acft landed hard and bounced. The pilot said she had pushed the nose of the acft down to prevent it from stalling and did not apply power. The nose gear collapsed and the…Jun 30, 1988 · N46068 · Substantial damageNTSB DEN88LA142Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTJun 30, 1988 · N6392Q · Substantial damageNTSB BFO88LA062Accident · No injuriesLimited investigationFinal reportTravel Air D4D · Roanoke, VAThe plt reported that during the landing roll the tail wheel began to shimmy. He stated that since there was not enough airspeed to lift the tail of the acft, he applied brakes in an attempt to slow the acft. At this time the acft veered to the right. He…Jun 30, 1988 · N434N · Substantial damageNTSB ANC88LA082Accident · No injuriesLimited investigationFinal reportCessna 172 · Healy, AKThe commercial pilot/flight instructor was attempting to land at a private turf airstrip when she reportedly encountered the outflow from a thunderstorm located about one mile away. She elected to continue with the landing and touched down with a greater than…Jun 30, 1988 · N739QH · Substantial damageNTSB FTW88LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Lake Charles, LABetween flights, the pilot noticed the nose was very high while taxiing but thought it was because the strut had failed to compress. On the next touchdown, on the main wheels, the airplane started porpoising and despite the pilot's corrections, the porpoising…Jun 29, 1988 · N3969M · Substantial damageNTSB ATL88LA204Accident · Serious injuriesLimited investigationFinal reportAdams A55S · Collierville, TNA multiple balloon flight was being conducted to obtain publicity for the local balloon club. Television exposure of balloon flights had been shot and the balloons were in the process of landing. The reporter/passenger in the accident balloon had been through…Jun 29, 1988 · N9807N · No damageNTSB ATL88LA203Accident · No injuriesLimited investigationFinal reportCessna 172 · Greenville, SCThe student & instructor (CFI) were on a practice short field apch, simulating a 50' obstacle. The CFI rprtd that as the acft came over the threshold at about 40' AGL, the airspeed was 60 mph & the flaps were extended 40 deg. The studentreduced the power to…Jun 29, 1988 · N7392A · Substantial damageNTSB ANC88LA077Accident · No injuriesLimited investigationFinal reportHelio H-295 · Clear, AKThe commercially certificated 8,000 hour pilot was attempting to land his Helio courier airplane at a remote, private airstrip in Alaska to pick up a non-revenue passenger. He reported that he landed hard, and that the left main gear collapsed. He said that…Jun 29, 1988 · N6493V · Substantial damageNTSB ANC88LA075Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Medfra, AKThe 18 year-old 100 hour private pilot initially reported that the left wing tip of the Piper PA-20 he was piloting struck brush next to the turf runway during the landing flare. He said that the airplane veered to the left, off the runway and into the dense…Jun 29, 1988 · N7074K · Substantial damageNTSB ANC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Shismaref, AKThe pilot stated he decided to land on the beach due to weather. After touchdown on the beach the main landing gear dropped into an area of soft sand; the aircraft then went over on its back.Jun 29, 1988 · N7157Z · Substantial damageNTSB MKC88LA117Accident · No injuriesLimited investigationFinal reportSchweizer 2-33 · Warrensburg, MODuring a student pilot's first solo in a glider, the plt said he misread the altimeter by 1000 feet. Attempting to land on the airport during the low approach, he struck trees, then a fence, before ground contact.Jun 28, 1988 · N7546 · Substantial damageNTSB LAX88LA235Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Agua Dulce, CAThe plt completed his participation in the 'bomb drop' portion of an air show and he attempted to land on rwy 22. The plt reported that his touchdown was normal but he lost control of his acft during the landing rollout. The wind direction was variable & its…Jun 26, 1988 · N96384 · Substantial damageNTSB ATL88LA201Accident · No injuriesLimited investigationFinal reportCessna 172M · Meridianville, ALThe plt reported that he attempted to make a touch and go ldg at the departure arpt before heading out on the first leg of a cross-country flt. The airplane encountered a gust of wind at touchdown and veered off the side of the rwy. The airplane subsequently…Jun 26, 1988 · N5075R · Substantial damageNTSB CHI88FA143Accident · No injuriesField investigationFinal reportShort Brothers SC.7 · Cleveland, OHFatigue failure on the radius between the body of the nose landing gear and the portion containing the arms.Jun 25, 1988 · N30GA · Substantial damageNTSB ATL88LA214Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Andrews, NCThe pilot failed to establish a proper apch profile and experienced a hard landing. The hard landing caused the main landing gear to collapse, and the airplane veered off of the left side of the runway. A witness located near the runway confirmed that the…Jun 25, 1988 · N59039 · Substantial damageNTSB ANC88LA072Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Beaver Creek, AKAccording to the pilot he made a landing on the gravel bar. Shortly after touchdown the pilot lost directional control and ground looped. The acft struck a tree stump and collapsed the left lndg gear.Jun 25, 1988 · N2987G · Substantial damageNTSB CHI88LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Portage, WIDuring taxi from landing the pilot failed to maintain adequate visual lookout and taxied onto a runway in front of an aircraft on its landing roll. The pilot stated that as he approached the other runway his visibility was restricted by a stand of trees, and…Jun 23, 1988 · N44753 · 2 aircraft · Substantial damageNTSB LAX88LA229Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Dorris, CADuring a local pleasure flt, just as the airplane touched down, an antelope ran across the rwy. The plt swerved the airplane to avoid the animal, exited the runway and collided with the terrain. There were no mechanical failures or malfunctions with the…Jun 22, 1988 · N5042P · Substantial damageNTSB CHI88LA138Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Howell, MIJun 22, 1988 · N757CD · Substantial damageNTSB ATL88FA200Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Myrtlewood, ALJun 22, 1988 · N780GM · DestroyedNTSB ANC88LA070Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Black Lake, AKThe pilot attempted a landing at a mining strip which was 1000 feet long. The pilot overshot the runway touchdown point; he then attempted a go-around, lost control , and crashed 300 feet off the departure end of the runway.Jun 22, 1988 · N2183F · Substantial damageNTSB FTW88LA139Accident · No injuriesLimited investigationFinal reportCessna 140 · Clifton, TXThe student pilot was on her third landing during her first solo flight. The pilot reported that she lost control and the airplane ground looped during the landing roll.Jun 21, 1988 · N76505 · Substantial damageNTSB ANC88LA069Accident · No injuriesLimited investigationFinal reportPiper PA-14 · Anchorage, AKThe pilot stated that after touchdown on the runway a gust of wind hit the plane pushing the tail to the right and causing the aircraft to ground loop.Jun 21, 1988 · N4260H · Substantial damageNTSB ATL88LA196Accident · Minor injuriesLimited investigationFinal reportCessna 175C · Boston, GAThe pilot was attempting to land following a reduction in power when he overshot the runway. The pilot said the engine did not quit and was still producing thrust. The aircraft was destroyed by fire after it came to rest. The plt landed downhill and downwind.Jun 20, 1988 · N8371T · DestroyedNTSB DEN88LA132Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-102 · Moriarty, NMThe pvt glider plt was completing a five hr endurance flight. During the turn from base to final, the glider encountered a 15 kt xwind and overshot the turn. The plt attempted to 'buttonhook' back toward the intended touchdown point. Witnesses stated that…Jun 19, 1988 · N143SS · Substantial damageNTSB CHI88LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Urbana, ILWhile landing at the completion of his first solo cross country instructional flight, the student pilot landed long and was unable to stop before the end of the runway. The student pilot stated that he selected the sod runway instead of the 2,550' x 29'…Jun 19, 1988 · N49207 · Substantial damageNTSB SEA88LA114Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Orofino, IDPlt stated that due to encircling tstms, elected a precautionary landing at 1800-foot usfs (forrest service) emrrgency strip. Touchdown was long and go-around resulted in a stall/mush into the trees.Jun 18, 1988 · N62961 · DestroyedNTSB NYC88LA171Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Steep Falls, METhe Ercoupe 415C took off to practice touch and go's with a student pilot in the left seat and on the controls. In the right seat was a private pilot who was listed as a pilot rated passenger. Both occupants were co-owners of the aircraft. The student pilot…Jun 18, 1988 · N94037 · Substantial damageNTSB MKC88LA112Accident · No injuriesLimited investigationFinal reportBeech D18S · St. Louis, MOArriving at his destination airport after a night 14 CFR 135 air taxi cargo flight, the main landing gear collapsed during roll-out causing substantial damage to the aircraft. Post accident investigation revealed a broken landing gear drag link, which caused…Jun 18, 1988 · N4234A · Substantial damageNTSB SEA88LA112Accident · Minor injuriesLimited investigationFinal reportCessna 182B · Athol, IDPlt landed long to avoid potential conflict with truck waiting to cross rwy. The pilot stated he experienced a tailwind after touchdown. He initiated a go-around but contacted rough terrain in overrun before becoming airborne.Jun 17, 1988 · N7112E · Substantial damageNTSB MIA88IA196Incident · No injuriesIncident investigationFinal reportLearjet 24 · W. Palm Beach, FLThe acft departed fort lauderdale executive arpt on a 14 CFR part 91 positioning flight to pick up a patient in west Palm Beach FL, for a 14 CFR part 135 air ambulance flight to rochester new york. The plt stated that on landing the acft floated aprx 4000…Jun 17, 1988 · N29LA · Minor damageNTSB CHI88LA137Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Mattoon, ILUpon return from a local aerial photography flight, the pilot failed to ensure that the aircraft landing gear was extended, down and locked. When the aircraft touched down, the gear was only extended approximately 10%; it collapsed fully when it contacted the…Jun 16, 1988 · N8226P · Substantial damageNTSB MIA88FA191Accident · Minor injuriesField investigationFinal reportPiper PA-38-112 · Vero Beach, FLThe 25 yr old student plt was practicing take-offs & ldgs on rwy 11L in preparation for his pvt plt flt test. When he departed, about 1.9 hrs prior to the accident, the winds were 090 degs at 13 knts. At the time of the accident the winds had increased to 18…Jun 14, 1988 · N2387T · Substantial damage