# NTSB investigations: Landing NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 385 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB SEA88LA136](https://openairdocs.org/ntsb/SEA88LA136.md): Cessna 210 · Baker, NV · Accident · No injuries · Limited investigation · Final report · Jul 6, 1988 · N6524X · Substantial damage > The 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. - [NTSB MIA88LA216](https://openairdocs.org/ntsb/MIA88LA216.md): Waco UPF-7 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Jul 6, 1988 · N32133 · Substantial damage > While 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… - [NTSB CHI88LA154](https://openairdocs.org/ntsb/CHI88LA154.md): Mooney M20J · Thief Rvr Falls, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1988 · N11652 · Substantial damage - [NTSB BFO88LA064](https://openairdocs.org/ntsb/BFO88LA064.md): Hughes 369D · Clarksburg, WV · Accident · No injuries · Limited investigation · Final report · Jul 5, 1988 · N32CT · Substantial damage > The 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… - [NTSB NYC88LA176](https://openairdocs.org/ntsb/NYC88LA176.md): Lake LA-4 · Linden, NJ · Accident · No injuries · Limited investigation · Final report · Jul 4, 1988 · N6655L · Substantial damage > Hard 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. - [NTSB CHI88LA158](https://openairdocs.org/ntsb/CHI88LA158.md): Raven S55A · Mishawaka, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1988 · N4186E · No damage > After 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. - [NTSB CHI88LA152](https://openairdocs.org/ntsb/CHI88LA152.md): Cessna 172M · Breckenridge, MI · Accident · No injuries · Limited investigation · Final report · Jul 4, 1988 · N20058 · Substantial damage > The 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… - [NTSB DEN88LA144](https://openairdocs.org/ntsb/DEN88LA144.md): Piper PA-32-260 · Colorado Spring, CO · Accident · No injuries · Limited investigation · Final report · Jul 3, 1988 · N4878S · Substantial damage > The 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… - [NTSB ATL88LA209](https://openairdocs.org/ntsb/ATL88LA209.md): Cessna 195A · Memphis, TN · Accident · No injuries · Limited investigation · Final report · Jul 3, 1988 · N1576D · Substantial damage > The 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.… - [NTSB LAX88LA248](https://openairdocs.org/ntsb/LAX88LA248.md): Cessna 177RG · Weaverville, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 1988 · N1532H · Substantial damage > At 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… - [NTSB CHI88LA149](https://openairdocs.org/ntsb/CHI88LA149.md): Piper PA-38-112 · Grafton, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1988 · N2496K · Substantial damage > While 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… - [NTSB CHI88DEC04](https://openairdocs.org/ntsb/CHI88DEC04.md): Perkins Dragonfly · Fowlerville, MI · Accident · No injuries · Final report · Jul 2, 1988 · N192AP · Substantial damage > The 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… - [NTSB LAX88DVG08](https://openairdocs.org/ntsb/LAX88DVG08.md): Grumman G-164A · Gridley, CA · Accident · No injuries · Final report · Jul 1, 1988 · N7933 · Substantial damage > During 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… - [NTSB CHI88LA150](https://openairdocs.org/ntsb/CHI88LA150.md): Rockwell 112A · Sandusky, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 1988 · N1463J · Substantial damage > The 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. - [NTSB ANC88LA079](https://openairdocs.org/ntsb/ANC88LA079.md): Piper PA-32 · Hooper Bay, AK · Accident · No injuries · Limited investigation · Final report · Jul 1, 1988 · N15268 · Substantial damage > The 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… - [NTSB SEA88IA121](https://openairdocs.org/ntsb/SEA88IA121.md): Mcdonnell Douglas DC-8-73F · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Jun 30, 1988 · N791FT · Minor damage > Crew 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.… - [NTSB MKC88LA118](https://openairdocs.org/ntsb/MKC88LA118.md): Piper PA-32R-301T · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jun 30, 1988 · N8328A · Substantial damage > After 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… - [NTSB MIA88LA209](https://openairdocs.org/ntsb/MIA88LA209.md): Cessna 152 · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Jun 30, 1988 · N46068 · Substantial damage > The 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… - [NTSB DEN88LA142](https://openairdocs.org/ntsb/DEN88LA142.md): Cessna 152 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Jun 30, 1988 · N6392Q · Substantial damage - [NTSB BFO88LA062](https://openairdocs.org/ntsb/BFO88LA062.md): Travel Air D4D · Roanoke, VA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1988 · N434N · Substantial damage > The 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… - [NTSB ANC88LA082](https://openairdocs.org/ntsb/ANC88LA082.md): Cessna 172 · Healy, AK · Accident · No injuries · Limited investigation · Final report · Jun 30, 1988 · N739QH · Substantial damage > The 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… - [NTSB FTW88LA127](https://openairdocs.org/ntsb/FTW88LA127.md): Piper PA-32-300 · Lake Charles, LA · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1988 · N3969M · Substantial damage > Between 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… - [NTSB ATL88LA204](https://openairdocs.org/ntsb/ATL88LA204.md): Adams A55S · Collierville, TN · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 1988 · N9807N · No damage > A 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… - [NTSB ATL88LA203](https://openairdocs.org/ntsb/ATL88LA203.md): Cessna 172 · Greenville, SC · Accident · No injuries · Limited investigation · Final report · Jun 29, 1988 · N7392A · Substantial damage > The 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… - [NTSB ANC88LA077](https://openairdocs.org/ntsb/ANC88LA077.md): Helio H-295 · Clear, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1988 · N6493V · Substantial damage > The 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… - [NTSB ANC88LA075](https://openairdocs.org/ntsb/ANC88LA075.md): Piper PA-20 · Medfra, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1988 · N7074K · Substantial damage > The 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… - [NTSB ANC88LA074](https://openairdocs.org/ntsb/ANC88LA074.md): Piper PA-18-150 · Shismaref, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1988 · N7157Z · Substantial damage > The 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. - [NTSB MKC88LA117](https://openairdocs.org/ntsb/MKC88LA117.md): Schweizer 2-33 · Warrensburg, MO · Accident · No injuries · Limited investigation · Final report · Jun 28, 1988 · N7546 · Substantial damage > During 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. - [NTSB LAX88LA235](https://openairdocs.org/ntsb/LAX88LA235.md): Taylorcraft BC12-D · Agua Dulce, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1988 · N96384 · Substantial damage > The 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… - [NTSB ATL88LA201](https://openairdocs.org/ntsb/ATL88LA201.md): Cessna 172M · Meridianville, AL · Accident · No injuries · Limited investigation · Final report · Jun 26, 1988 · N5075R · Substantial damage > The 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… - [NTSB CHI88FA143](https://openairdocs.org/ntsb/CHI88FA143.md): Short Brothers SC.7 · Cleveland, OH · Accident · No injuries · Field investigation · Final report · Jun 25, 1988 · N30GA · Substantial damage > Fatigue failure on the radius between the body of the nose landing gear and the portion containing the arms. - [NTSB ATL88LA214](https://openairdocs.org/ntsb/ATL88LA214.md): Piper PA-34-200T · Andrews, NC · Accident · No injuries · Limited investigation · Final report · Jun 25, 1988 · N59039 · Substantial damage > The 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… - [NTSB ANC88LA072](https://openairdocs.org/ntsb/ANC88LA072.md): Champion 7ECA · Beaver Creek, AK · Accident · No injuries · Limited investigation · Final report · Jun 25, 1988 · N2987G · Substantial damage > According 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. - [NTSB CHI88LA140](https://openairdocs.org/ntsb/CHI88LA140.md): Piper PA-28-180 · Portage, WI · Accident · No injuries · Limited investigation · Final report · Jun 23, 1988 · N44753 · 2 aircraft · Substantial damage > During 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… - [NTSB LAX88LA229](https://openairdocs.org/ntsb/LAX88LA229.md): Bellanca 7GCBC · Dorris, CA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1988 · N5042P · Substantial damage > During 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… - [NTSB CHI88LA138](https://openairdocs.org/ntsb/CHI88LA138.md): Cessna 152 · Howell, MI · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 1988 · N757CD · Substantial damage - [NTSB ATL88FA200](https://openairdocs.org/ntsb/ATL88FA200.md): Globe GC-1B · Myrtlewood, AL · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1988 · N780GM · Destroyed - [NTSB ANC88LA070](https://openairdocs.org/ntsb/ANC88LA070.md): Cessna U206 · Black Lake, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 1988 · N2183F · Substantial damage > The 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. - [NTSB FTW88LA139](https://openairdocs.org/ntsb/FTW88LA139.md): Cessna 140 · Clifton, TX · Accident · No injuries · Limited investigation · Final report · Jun 21, 1988 · N76505 · Substantial damage > The 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. - [NTSB ANC88LA069](https://openairdocs.org/ntsb/ANC88LA069.md): Piper PA-14 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 21, 1988 · N4260H · Substantial damage > The 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. - [NTSB ATL88LA196](https://openairdocs.org/ntsb/ATL88LA196.md): Cessna 175C · Boston, GA · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1988 · N8371T · Destroyed > The 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. - [NTSB DEN88LA132](https://openairdocs.org/ntsb/DEN88LA132.md): Burkhart Grob G-102 · Moriarty, NM · Accident · No injuries · Limited investigation · Final report · Jun 19, 1988 · N143SS · Substantial damage > The 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… - [NTSB CHI88LA135](https://openairdocs.org/ntsb/CHI88LA135.md): Cessna 152 · Urbana, IL · Accident · No injuries · Limited investigation · Final report · Jun 19, 1988 · N49207 · Substantial damage > While 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'… - [NTSB SEA88LA114](https://openairdocs.org/ntsb/SEA88LA114.md): Cessna 172P · Orofino, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 1988 · N62961 · Destroyed > Plt 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. - [NTSB NYC88LA171](https://openairdocs.org/ntsb/NYC88LA171.md): Ercoupe 415C · Steep Falls, ME · Accident · No injuries · Limited investigation · Final report · Jun 18, 1988 · N94037 · Substantial damage > The 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… - [NTSB MKC88LA112](https://openairdocs.org/ntsb/MKC88LA112.md): Beech D18S · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · Jun 18, 1988 · N4234A · Substantial damage > Arriving 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… - [NTSB SEA88LA112](https://openairdocs.org/ntsb/SEA88LA112.md): Cessna 182B · Athol, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 17, 1988 · N7112E · Substantial damage > Plt 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. - [NTSB MIA88IA196](https://openairdocs.org/ntsb/MIA88IA196.md): Learjet 24 · W. Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Jun 17, 1988 · N29LA · Minor damage > The 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… - [NTSB CHI88LA137](https://openairdocs.org/ntsb/CHI88LA137.md): Piper PA-24-250 · Mattoon, IL · Accident · No injuries · Limited investigation · Final report · Jun 16, 1988 · N8226P · Substantial damage > Upon 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… - [NTSB MIA88FA191](https://openairdocs.org/ntsb/MIA88FA191.md): Piper PA-38-112 · Vero Beach, FL · Accident · Minor injuries · Field investigation · Final report · Jun 14, 1988 · N2387T · Substantial damage > The 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… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=386 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?page=385 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.