# 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 382 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB BFO88LA083](https://openairdocs.org/ntsb/BFO88LA083.md): Cessna 310R · Washington, DC · Accident · No injuries · Limited investigation · Final report · Sep 15, 1988 · N87297 · Substantial damage > During the landing roll the left main landing gear collapsed. The acft continued to roll and came to a stop on taxiway 'k'. Inspection revealed that the push-pull rod assembly, p/n 0840125-15, failed allowing the gear to collapse. The purpose of the rod is to… - [NTSB ATL88LA247](https://openairdocs.org/ntsb/ATL88LA247.md): Piper PA-60-602P · Hopkinsville, KY · Accident · No injuries · Limited investigation · Final report · Sep 14, 1988 · N64718 · Substantial damage > The airplane overran rwy 26 during ldg, following an sdf appch. The plt reported that he broke out of the wx about 1 mile from the rwy, with 2 to 3 miles visibility. He subsequently landed 'long' on the wet rwy with a tailwind, and found that braking was not… - [NTSB NYC88DNA02](https://openairdocs.org/ntsb/NYC88DNA02.md): Dillinger Long E-Z · Lawrence, MA · Accident · Serious injuries · Final report · Sep 12, 1988 · N84WD · Substantial damage > The plt depd provincetown on a rtrn flt to his home arpt at aprx 0230 EDT & arrived at his destn about 1 hr later. He rprtd he was unable to activate the plt-ctld rwy lights. He checked the lighted wind sock & decided the night was bright & clear enough to… - [NTSB DEN88MA203](https://openairdocs.org/ntsb/DEN88MA203.md): Mcdonnell Douglas DC-10-10 · Denver, CO · Accident · Minor injuries · Major investigation · Final report · Sep 12, 1988 · N1830U · Substantial damage > As the capt was deploying reversers drg lndg, #2 & #3 reversers unlocked & deployed (green lgt cond), but #1 reverser was binding & only moved to the unlocked psn (amber lgt cond). Capt was not warned of this cond, though 2nd officer should have monitored… - [NTSB ANC88LA137](https://openairdocs.org/ntsb/ANC88LA137.md): de Havilland DHC-2 · Ruth Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 12, 1988 · N67207 · Substantial damage > The air taxi pilot was attempting to land his float-equipped airplane on a remote mountain lake in gusty wind conditions. He stated that he touched down with a tailwind component of approximately 5 knots, but that the tailwind increased rapidly during a gust,… - [NTSB ANC88LA133](https://openairdocs.org/ntsb/ANC88LA133.md): Piper PA-12 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 12, 1988 · N3148M · Substantial damage > The private pilot stated that he was attempting to land on a gravel bar when the airplane encountered a soft spot and nosed over. He said that a contributing factor in the accident was that he had applied his brakes too strongly early in the landing roll, and… - [NTSB ANC88LA134](https://openairdocs.org/ntsb/ANC88LA134.md): Cessna 188B · Skwentna, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 1988 · N9037R · Substantial damage > The airline transport rated pilot was flying a load of gasoline in a crop duster type airplane to a residence in rural Alaska. The landing site was a river sand bar located near the residence. The pilot stated, and witnesses concur, that the airplane's main… - [NTSB LAX88LA315](https://openairdocs.org/ntsb/LAX88LA315.md): Billings/Humbyrd Thorp T-18 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Sep 10, 1988 · N45BH · 2 aircraft · Minor damage > Just prior to touchdown a thorp T-18 and a Piper collided in flight. The Piper struck the thorp from above at aprx 10 ft AGL over the threshold. The thorp landed without further incident. The Piper completed a normal landing until the propeller contacted the… - [NTSB SEA88LA175](https://openairdocs.org/ntsb/SEA88LA175.md): Piper PA-20 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1988 · N2526A · Substantial damage > Plt landed with 80 deg right cross wind of 8 KTS, groundlooped to right. The plt said that ATIS info gave the wind as 220 degrees at 8 KTS; however his EST from windsock observation included gusts of 15 KTS. The observing station reported no gusts on the date… - [NTSB MKC88LA169](https://openairdocs.org/ntsb/MKC88LA169.md): Cessna 195 · Keokuk, IA · Accident · No injuries · Limited investigation · Final report · Sep 8, 1988 · N3040B · Substantial damage > The new owner of the acft asked the former owner to ride with him in the right seat while doing some touch and go landings. After the first circuit the former owner said he felt the pilot needed additional training before attempting to fly the acft as PIC.… - [NTSB CHI88LA230](https://openairdocs.org/ntsb/CHI88LA230.md): Cessna 150F · Cambridge, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1988 · N7118F · Substantial damage > The pilot was on a solo flight for the purpose of practicing takeoffs and landings. The aircraft departed the right side of the runway and struck a culvert. The flight was the pilot's second supervised solo. - [NTSB SEA88LA173](https://openairdocs.org/ntsb/SEA88LA173.md): Maule M5-235C · Priest River, ID · Accident · No injuries · Limited investigation · Final report · Sep 6, 1988 · N56312 · Substantial damage > On approach for lndg on rwy 27, the plt noted that the windsock was indicating strong, shifting winds. The acft settled in the flare, despite added power, resulting in hard landing. - [NTSB MKC88LA168](https://openairdocs.org/ntsb/MKC88LA168.md): Cessna 152 · Burlington, IA · Accident · No injuries · Limited investigation · Final report · Sep 6, 1988 · N5458P · Substantial damage > Arriving at the destination apt, on a solo cross country flt, the plt said UNICOM advised a landing on rwy 18. The local fss reported the winds to be out of the northwest favoring runway 36. The plt elected to land on rnwy 18 based on the UNICOM advisory, and… - [NTSB ATL88LA249](https://openairdocs.org/ntsb/ATL88LA249.md): Hughes 269A · Saluda, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1988 · N8823F · Substantial damage > The instructor pilot reported that they were conducting autorotation training. During an autorotation the crew delayed initiating the power recovery. The helicopters struck the ground causing substantial damage. The pilots did not report experiencing a system… - [NTSB ATL88LA246](https://openairdocs.org/ntsb/ATL88LA246.md): Cessna 182K · Hendersonville, NC · Accident · No injuries · Limited investigation · Final report · Sep 5, 1988 · N2636R · Substantial damage > The pilot was nearing touchdown on a normal landing when the left side of the windscreen was struck by a bird. The startled pilot was distracted long enough for the aircraft to bounce on the runway. Elevator control was lost after the first bounce. A nose low… - [NTSB ANC88LA125](https://openairdocs.org/ntsb/ANC88LA125.md): Cessna 180K · Chickaloonflats, AK · Accident · No injuries · Limited investigation · Final report · Sep 5, 1988 · N2989K · Substantial damage > On touchdown off shore on the mud flats, the pilot lost complete control of the airplane. The airplane then nosed over on its back. - [NTSB MIA88LA271](https://openairdocs.org/ntsb/MIA88LA271.md): Piper PA-28 · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · Sep 4, 1988 · N722TC · Substantial damage > The plt stated he approached the 2,450 ft grass airstrip from the NE & circled north of it to observe the windsock. The wind appeared to be from the east. The pilot entered the pattern to land on rwy 36. While flaring to land the acft floated down the rwy &… - [NTSB DEN88LA200](https://openairdocs.org/ntsb/DEN88LA200.md): Thunder and Colt AX8-90 · Las Cruces, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 1988 · N90EH · Substantial damage > The commercial balloon plt was participating in a balloon rally. During landing, the plt noticed the balloon was drifting toward power lines. He elected to open the deflation valve at 30 ft AGL, to attempt to land short of the lines. The balloon touched down… - [NTSB LAX88FA306](https://openairdocs.org/ntsb/LAX88FA306.md): Piper PA-28-161 · Temecula, CA · Accident · 1 fatal · Field investigation · Final report · Sep 2, 1988 · N4328Y · Destroyed > Failure of the pilot to properly initiate a go-around during an aborted landing. The loss of directional control during the landing, failure to return to the runway for the aborted takeoff, and not establishing the proper rate of climb due to high density… - [NTSB FTW88LA159](https://openairdocs.org/ntsb/FTW88LA159.md): Cessna 180H · Welsh, LA · Accident · No injuries · Limited investigation · Final report · Sep 1, 1988 · N9730G · Substantial damage > The pilot was landing the tailwheel type airplane on runway 6 while the winds were from 270 degrees at 15 knots, gusting to 25 knots. After touchdown, it ballooned several feet, touched on the left wheel, then the left wing tip and flipped forward to the… - [NTSB FTW88DRG12](https://openairdocs.org/ntsb/FTW88DRG12.md): Cessna 182R · Spicewood, TX · Accident · No injuries · Final report · Sep 1, 1988 · N3163E · Destroyed > The plt said the windsock indicated the wind was from the northeast; however, witnesses said the winds were from the south & the acft landed downwind. The plt said he went around after the 1st apch, & on the next pattern, he made a lowerfinal apch. He said… - [NTSB CHI88LA228](https://openairdocs.org/ntsb/CHI88LA228.md): Lake LA-4-200 · Fox Lake, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1988 · N8012A · Destroyed > The plt had just completed a course at the Lake acft factory school, but had not yet obtained a seaplane rating. After he flew home, he landed on local lakes. He reported that drg a landing on calm water, he expected to hear a 'slush sound' as the hull… - [NTSB LAX88LA301](https://openairdocs.org/ntsb/LAX88LA301.md): Cessna 152 · Goodyear, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1988 · N46972 · Substantial damage > The student pilot was on her second supervised solo flight. She had completed one touch and go landing and was attempting a second when the accident occurred. The pilot failed to flare the airplane at the proper time and the airplane collided with the terrain… - [NTSB DEN88LA192](https://openairdocs.org/ntsb/DEN88LA192.md): Cessna 206 · Saint George, UT · Accident · No injuries · Limited investigation · Final report · Aug 29, 1988 · N5028U · Substantial damage > Drg the landing roll, the nose gear collapsed, then the acft veered off the rwy, enctrd soft dirt/gravel terrain & nosed over. A post-acdnt inspn revealed that two attaching bolts on the left side of the nose gear yoke had failed & that the TW0 bolts on the… - [NTSB ANC88LA118](https://openairdocs.org/ntsb/ANC88LA118.md): Cessna 170B · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Aug 29, 1988 · N8266A · Substantial damage > The plt was practicing touch-&-go landings. On the first landing, the acft bounced & a successful go-around was made. During the second landing, the plt lost directional control of the acft & it went off the left side of the rwy & was damaged. - [NTSB CHI88LA224](https://openairdocs.org/ntsb/CHI88LA224.md): Cessna 182RG · Dodgeville, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 1988 · N728JS · Substantial damage > While attempting to land on a runway with wind gusts and a quartering tailwind, the pilot failed to adequately judge and compensate for the wind conditions. The aircraft landed long, and the pilot was unable to bring the aircraft to a stop before the end of… - [NTSB BFO88LA078](https://openairdocs.org/ntsb/BFO88LA078.md): Cessna 152 · Easton, MD · Accident · No injuries · Limited investigation · Final report · Aug 28, 1988 · N49572 · Substantial damage > The student pilot reported that he allowed the airspeed to deteriorate on final apch. The acft touched down nosewheel first and began to porpoise on the runway. The acft porpoised 3 or 4 times before the propeller and right wing contacted the runway. - [NTSB BFO88LA077](https://openairdocs.org/ntsb/BFO88LA077.md): Cessna 172 · Oakland, MD · Accident · No injuries · Limited investigation · Final report · Aug 28, 1988 · N4156F · Substantial damage > According to the pilot the landing approach for runway 22 was made over power lines. He stated that during the approach the stall warning horn activated and he increased power to maintain 60 mph with 20 degs of flaps. Once estimating that his intended point… - [NTSB ANC88LA119](https://openairdocs.org/ntsb/ANC88LA119.md): Cessna 185F · Joseph Village, AK · Accident · No injuries · Limited investigation · Final report · Aug 28, 1988 · N4838C · Substantial damage > The pilot-in-command stated the airplane struck a depression in the runway upon landing at Joseph, Alaska. Examination of the left main gear showed that a bracket, part number 0713495-61 failed due to overload, and allowed the landing gear to separate from… - [NTSB SEA88LA164](https://openairdocs.org/ntsb/SEA88LA164.md): Mooney M20J · Nehalem, OR · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1988 · N5813X · Substantial damage > After executing one go-around due to overshoot, plt landed long on second approach. Plt attempted to brake to stop, then rejected landing, applied power and became airborne prematurely. Loss of control and collision with terrain followed. - [NTSB NYC88LA230](https://openairdocs.org/ntsb/NYC88LA230.md): Piper PA-38-112 · Manville, NJ · Accident · No injuries · Limited investigation · Final report · Aug 27, 1988 · N2445N · Destroyed > After completing six landings with an instructor the student plt was released by the instructor for his first solo flt to be conducted as a series of closed pattern touch-and-go landings. On his first solo landing the student plt landed nose wheel first with… - [NTSB FTW88LA154](https://openairdocs.org/ntsb/FTW88LA154.md): Alon A2 · Guthrie, OK · Accident · No injuries · Limited investigation · Final report · Aug 27, 1988 · N6588Q · Substantial damage > The private pilot was trying to sell his airplane and allowed the student pilot to fly it from the left seat. The student pilot landed on the runway but lost control, departed the side of the runway, then hit a VASI light. The airplane stopped when it hit a… - [NTSB DEN88LA201](https://openairdocs.org/ntsb/DEN88LA201.md): Raven S55A · Fort Morgan, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 27, 1988 · N779TV · No damage > The plt reported that at the time of takeoff, the winds were 'light to moderate from 015 deg at 5 KTS or less.' Shortly after takeoff, the winds increased to 10-15 KTS and the plt decided to land on 'grassy, relatively smooth terrain.' The plt said he… - [NTSB BFO88LA079](https://openairdocs.org/ntsb/BFO88LA079.md): Cessna 180 · Harding, WV · Accident · No injuries · Limited investigation · Final report · Aug 27, 1988 · N2922A · Substantial damage > The pilot departed morgantown, WV, en route to a private airstrip, durrett air ranch, near Harding, WV to attend a Cessna 180 fly-in. He stated he circled the airstrip to determine the wind and rwy conditions. He also called UNICOM for active rwy info but did… - [NTSB MKC88LA163](https://openairdocs.org/ntsb/MKC88LA163.md): Piper PA-22 · Freeburg, MO · Accident · No injuries · Limited investigation · Final report · Aug 26, 1988 · N3171Z · Substantial damage > While attempting to land on a farm pasture that the plt had previously walked over to check, the aircraft nose wheel collapsed, followed by a nose over. The aircraft landed nose low with no flaps and dug into the grass runway. - [NTSB DEN88LA194](https://openairdocs.org/ntsb/DEN88LA194.md): Lake LA-4-200 · Lakeside, MT · Accident · No injuries · Limited investigation · Final report · Aug 26, 1988 · N1299L · Substantial damage > The plt and his pax departed bzn at 1500 MDT and flew to Hughes bay on flathead Lake, near Lakeside, MT, arriving at aprx 1700. The plt said he noticed a diminishing wave pattern from the southwest and a strong gust surface pattern from the east. There were… - [NTSB FTW88DPA06](https://openairdocs.org/ntsb/FTW88DPA06.md): Cessna 150K · Whitney, TX · Accident · No injuries · Final report · Aug 25, 1988 · N2550Q · Substantial damage > The student pilot decided to make a touch and go landing before flying to another airport. The airplane touched down more than 1000 feet down the 2000 foot runway, went off the end and 300 feet beyond the end before hitting a dirt bank and nosing over to the… - [NTSB DEN88LA189](https://openairdocs.org/ntsb/DEN88LA189.md): Cessna 195 · Rawlins, WY · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1988 · N3455V · Substantial damage - [NTSB ATL88LA243](https://openairdocs.org/ntsb/ATL88LA243.md): Schempp-Hirth 2 · Whitwell, TN · Accident · No injuries · Limited investigation · Final report · Aug 25, 1988 · N795 · Substantial damage > The pilot was completing a 130 mile cross country flight. Just prior to touchdown, the left wing collided with a water sprinkler pipe along the edge of the runway. The pilot lost directional control. The grass was taller along the runway edge. The pilot did… - [NTSB ATL88LA237](https://openairdocs.org/ntsb/ATL88LA237.md): Maule MX-7-180 · Eufaula, AL · Accident · No injuries · Limited investigation · Final report · Aug 24, 1988 · N56606 · Substantial damage > The plt reported that he landed on a grass strip adjacent to the paved rwy, to 'save the (airplane) tires' from excessive wear. He stated that the airplane groundlooped during the rollout when it encountered a hole in the turf. A mechanic who examined the… - [NTSB SEA88LA162](https://openairdocs.org/ntsb/SEA88LA162.md): Cessna 152 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1988 · N6419M · Substantial damage > Student pilot executed improper flare resulting in hard landing. This was a solo flt. The student said he was high on final but thought it was okay. When he flared to land the acft dropped to the rwy and bounced. The student said he added power and raised the… - [NTSB NYC88LA227](https://openairdocs.org/ntsb/NYC88LA227.md): Schweizer SGS-1-26E · Elmira, NY · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1988 · N3613B · Substantial damage > The plt reported to the local police that he was having trouble getting lift and was attempting an off airport landing when the acft stalled at low alt and crashed. The pilot did not file an accident report. - [NTSB NYC88LA226](https://openairdocs.org/ntsb/NYC88LA226.md): Hughes 269A · Pittstown, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1988 · N7028V · Substantial damage > The CFI was demonstrating a departure autorotation to a prospective student. A high rate of descent with low airspeed and low rotor RPM developed and the CFI attempted a power recovery with no results. The acft touched down hard, the skids collapsed and the… - [NTSB NYC88LA225](https://openairdocs.org/ntsb/NYC88LA225.md): Piper PA-24-260 · Readington, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1988 · N9072P · Destroyed > While attempting a go-around from a rejected landing in x-wind conditions the plt who had no landings in the last 90 days failed to initiate the go-around with sufficient time/distance to clear trees off the end of the rnwy. The acft struck the trees and was… - [NTSB NYC88LA223](https://openairdocs.org/ntsb/NYC88LA223.md): Cessna 172P · Freeport, PA · Accident · No injuries · Limited investigation · Final report · Aug 21, 1988 · N172RQ · Substantial damage > The plt said that he had landed on the 2268 ft long, sod strip on several previous occasions. He said there was a right crosswind at about 6 KTS. The acft was too high and go-arounds were made following the first two approaches. On the third approach, the… - [NTSB LAX88LA292](https://openairdocs.org/ntsb/LAX88LA292.md): Siai-Marchetti S.205/22R · Bullhead City, AZ · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1988 · N955W · Substantial damage > At the end of a cross country flight, the pilot had to abort the landing the first time due to heavy rain showers and turbulence. The pilot returned for landing and during the landing roll on the wet runway, the pilot lost control of the airplane. The… - [NTSB CHI88LA216](https://openairdocs.org/ntsb/CHI88LA216.md): Cessna 172M · Kelley'S Island, OH · Accident · No injuries · Limited investigation · Final report · Aug 21, 1988 · N62920 · Substantial damage > Shortly after crossing the runway threshold on final approach, the pilot experienced a wind shift and elected to attempt a go-around. The pilot discontinued the attempted go-around when he judged that he would be unable to clear trees located at the departure… - [NTSB BFO88LA074](https://openairdocs.org/ntsb/BFO88LA074.md): Aeronca 11AC · Gaithersburg, MD · Accident · No injuries · Limited investigation · Final report · Aug 21, 1988 · N86346 · Substantial damage > The pilot reported that the local winds were varying from 340 degrees to 360 degrees at 12 knots gusting to 20 knots. The pilot stated that he lost directional control due to gusty winds while on landing roll. The aircraft contacted a VASI light and then a… - [NTSB SEA88LA159](https://openairdocs.org/ntsb/SEA88LA159.md): Cessna 150D · Athol, ID · Accident · No injuries · Limited investigation · Final report · Aug 20, 1988 · N4393U · Substantial damage > Acft had been modified to conventional lndg gear. On landing roll, variable and gusty surface winds were encountered. Plt lost control of acft, which nosed over. - [NTSB SEA88LA157](https://openairdocs.org/ntsb/SEA88LA157.md): Cessna 172N · Tyge Valley, OR · Accident · No injuries · Limited investigation · Final report · Aug 20, 1988 · N737RB · Substantial damage > The pilot reported that late in the apch, the acft developed a high sink rate. However, he used elevator only to correct the sink rate. The aircraft impacted the runway and bounced. On the third bounce, the nose gear failed and the aircraft nosed over. The… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=383 ## 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=382 --- 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.