# 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 419 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB CHI86LA049](https://openairdocs.org/ntsb/CHI86LA049.md): Piper PA-28-181 · Dodgeville, WI · Accident · No injuries · Limited investigation · Final report · Dec 15, 1985 · N8458H · Substantial damage > After a x-country flt and during the landing roll the acft started to drift left on the snow covered rwy. The left main gear then encountered deeper snow causing the acft to swing to the left and run into a six-ft snowbank. - [NTSB BFO86LA009](https://openairdocs.org/ntsb/BFO86LA009.md): Piper PA-28-140 · Edgewater, MD · Accident · No injuries · Limited investigation · Final report · Dec 15, 1985 · N427FL · Substantial damage > Upon returning to lee arpt, Edgewater, MD, from a x-country flt to lancaster, PA, the student plt applied full flaps during the final apch for rwy 12. During the landing flare, the acft ballooned and the plt applied full pwr in order to execute a go-around.… - [NTSB ANC86LA016](https://openairdocs.org/ntsb/ANC86LA016.md): Piper PA-20 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Dec 15, 1985 · N7773K · Substantial damage > Aircraft lost control during landing and crashed into another private aircraft. Witness reported seeing aircraft make a fast appraoch, land long, ground loop and slide side ways into parked Aeronca. Witness stated that aircraft landed with a tailwind,while… - [NTSB LAX86LA067](https://openairdocs.org/ntsb/LAX86LA067.md): Piper PA-34-200T · Glendale, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 1985 · N3885F · Substantial damage > After completing a LCL flight the plt returned to his home base arpt & proceeded to land on the 2400 ft long rwy. The plt reported that he was unable to stop at its end and collided with barricades and a fence. A witness reported that the acft skidded on the… - [NTSB MKC86LA034](https://openairdocs.org/ntsb/MKC86LA034.md): Cessna 402B · Gardner, KS · Accident · No injuries · Limited investigation · Final report · Dec 13, 1985 · N3950C · Substantial damage > Landing on an ice covered rwy, the cross-wind was stronger than rptd. The acft drifted left despite control input to correct. The nose gear collapsed before the plt could initiate a go-around. The rptd wind was 340 degrees at 8 knots. The plt stated it was… - [NTSB ATL86LLQ04](https://openairdocs.org/ntsb/ATL86LLQ04.md): Beech BE-60 · Lexington, KY · Accident · No injuries · Final report · Dec 13, 1985 · N202TT · Substantial damage > The left main gear and nose gear collapsed following a loss of control during touchdown. During the flare the acft banked sharply to the right and struck the rwy. The acft then bounced onto the left gear, collapsing it and the nose gear before slidding off… - [NTSB MKC86LA032](https://openairdocs.org/ntsb/MKC86LA032.md): Piper PA-31-350 · Topeka, KS · Accident · No injuries · Limited investigation · Final report · Dec 10, 1985 · N4NP · Substantial damage > N4NP diverted from the original destination forbes field Topeka,Kansas to billard field,b NM away, due to weather. Billard ATCT advised the flight during initial contact, before N4NP reached the ILS fof, of the runway braking action. The pilot said braking… - [NTSB DEN86LA042](https://openairdocs.org/ntsb/DEN86LA042.md): Cessna 172P · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Dec 9, 1985 · N64069 · Substantial damage > The solo student plt was attempting to land during a local flt when he lost control of the acft during the landing roll. The plt stated that the acft veered to one side of the ice covered rwy where it contacted 6 to 8 inches of snow, the acft continued… - [NTSB ATL86LA038](https://openairdocs.org/ntsb/ATL86LA038.md): Cessna 182Q · Stone Mountain, GA · Accident · No injuries · Limited investigation · Final report · Dec 8, 1985 · N4707N · Substantial damage > After an IFR flight into his home area, pilot changed dest to land on his home airport. Made a VFR pattern to land on rwy 17. Plt stated that he flared too late, hit the runway, bounced real high and went around. Made a soft field ldg and when tying acft down… - [NTSB LAX86LA058](https://openairdocs.org/ntsb/LAX86LA058.md): Cessna 210D · Flagstaff, AZ · Accident · No injuries · Limited investigation · Final report · Dec 7, 1985 · N3762Y · Substantial damage > The plt noticed a weakness of the acft's left brake during taxi for takeoff but elected to make the flt. Control tower personnel at the destination arpt stated the acft landed long and attempted to turn onto the right highspeed taxiway. The plt stated that… - [NTSB CHI86LA045](https://openairdocs.org/ntsb/CHI86LA045.md): Cessna 150M · Carbondale, IL · Accident · No injuries · Limited investigation · Final report · Dec 7, 1985 · N62FS · Substantial damage > According to the student pilot flying the plane, after he touched down on his main wheels he lowered the nose and he heard a crack. The nose wheel then collapsed andthe aircraft slid to a stop. According to the operator of the aircraft no preexisting… - [NTSB ATL86LA036](https://openairdocs.org/ntsb/ATL86LA036.md): Cessna 152 · Hickory, NC · Accident · No injuries · Limited investigation · Final report · Dec 6, 1985 · N44687 · Substantial damage > Student pilot was returning from a solo cross country flight. In his report the student said he flew a long final with the VASI showing a proper descent angle. The acft was landed with a shallow flare touching down in a flat attitude. It bounced, bounced… - [NTSB ATL86LA035](https://openairdocs.org/ntsb/ATL86LA035.md): Cessna 182J · Bishopville, SC · Accident · No injuries · Limited investigation · Final report · Dec 6, 1985 · N2650F · Substantial damage > During an attempt to make a direct crosswind landing at a private grass airstrip, the plt allowed the acft to drift off the left side of the rwy where it nosed over in a plowed fld. - [NTSB ANC86LA012](https://openairdocs.org/ntsb/ANC86LA012.md): Piper PA-20 · Shageluk, AK · Accident · No injuries · Limited investigation · Final report · Dec 6, 1985 · N97MM · Substantial damage > The acft contacted trees and descended to the terrain while on an apch to a lake. The plt reported the acft windscreen kept frosting up and he had to repeatedly wipe it clean. In the process of wiping the windscreen he approached the lake at a lower than… - [NTSB LAX86LA060](https://openairdocs.org/ntsb/LAX86LA060.md): Piper PA-32-301 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Dec 5, 1985 · N82009 · Substantial damage > After completing a personal flight the plt landed the acft. Upon touchdown on the 8899 ft-long by 150 ft-wide rwy the plt failed to maintain directional control of the acft. There was a 70 deg, 8 kt. Right x-wind. The acft overran the runway's edge, entered a… - [NTSB ANC86IA010](https://openairdocs.org/ntsb/ANC86IA010.md): Piper Navajo PA-31-350 · Kenai, AK · Incident · No injuries · Incident investigation · Final report · Dec 5, 1985 · N492SC · Minor damage > The pilot in command could not raise the landing gear properly after departure. He diverted to Kenai, Alaska, whereupon extending the gear he obtained three safe gear indications. The pilot landed the airplane and upon roll out the left main gear collapsed.… - [NTSB MIA86LA038](https://openairdocs.org/ntsb/MIA86LA038.md): Grumman American AA-5 · Wimauma, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 3, 1985 · N700TD · Substantial damage > The plt stated that after turning on the rwy lights using the radio transmitter. They appeared to be dim, & only one side of the lights came on. He then landed south of the rwy at which time the right wing struck a fence post. The landing gear then collapsed,… - [NTSB ANC86LA011](https://openairdocs.org/ntsb/ANC86LA011.md): Piper PA-18 · Fishtrap Lake, AK · Accident · No injuries · Limited investigation · Final report · Dec 2, 1985 · N1237A · Substantial damage > Pilot attempted to land his wheel equipped aircraft on frozen lake with water overflow and 12 to 18 inches snow. Acft broke through top layer of thin ice and nosed over upon touchdown. - [NTSB MIA86LA039](https://openairdocs.org/ntsb/MIA86LA039.md): Piper PA-28-181 · Cedar Key, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1985 · N136AV · Substantial damage > The plt was attempting a night landing on his first night x-country & had not landed at this aprt prior to this time. He stated that during the flare, he was caught by a x-wind & blown into the trees adjacent to the rwy. Surface winds at the time of the… - [NTSB LAX86LA052](https://openairdocs.org/ntsb/LAX86LA052.md): Piper PA-20 · Calexico, CA · Accident · No injuries · Limited investigation · Final report · Dec 1, 1985 · N7728K · Substantial damage > The acft ground looped during a landing on rwy 08 at Calexico arpt. The plt reported that upon touchdown the acft began to swerve to the right. The plt applied left rudder to arrest the right swerve. The acft then began a swerve to the left and the plt was… - [NTSB DEN86LA036](https://openairdocs.org/ntsb/DEN86LA036.md): Cessna 152 II · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Dec 1, 1985 · N49209 · Substantial damage > According to the plt, during the landing roll the acft veered to the left of the rwy and struck a snow berm. The plt stated that the accident could have been prevented if he had held the 'nose wheel off the ground' longer and not relaxed his attention. - [NTSB ATL86LA033](https://openairdocs.org/ntsb/ATL86LA033.md): Aero Commander 500 · Albany, GA · Accident · No injuries · Limited investigation · Final report · Dec 1, 1985 · N999B · Substantial damage > The aircraft landed on the wet sod runway with a 30 to 35 knot tailwind and ran off the end of the runway and into the trees. The pilot related that the wind shifted 180 degrees upon touchdown. The pilot also stated that he touched down approximately 1000 ft… - [NTSB DEN86LA035](https://openairdocs.org/ntsb/DEN86LA035.md): Stinson 108-1 · Beulah, ND · Accident · No injuries · Limited investigation · Final report · Nov 30, 1985 · N8143K · Substantial damage > During a landing at dusk on a snow covered rwy, the acft encountered deep snow and nosed over onto its back. The plt stated that after touchdown, he realized that there was aprx one ft of snow on the rwy and was unable to make a go-around. - [NTSB NYC86LA042](https://openairdocs.org/ntsb/NYC86LA042.md): Israel Aircraft Industries WW-24 · Worcester, MA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1985 · N4WG · Substantial damage > According to the pilot, the flight was normal, upon touchdown the reversers were deployed, pilot had information that braking action was poor and rwy was icy but had been sanded, pilot landed on the left side of the rwy centerline aircraft began to drift… - [NTSB DEN86LA043](https://openairdocs.org/ntsb/DEN86LA043.md): Piper PA-18-150 · Hayes, SD · Accident · No injuries · Limited investigation · Final report · Nov 27, 1985 · N6884B · Substantial damage > The plt stated that during the uphill ldg on snow covered terrain, the acft crested the hill, then started downhill on the opposite side. According to the plt he was unable to stop the acft before reaching a cliff. The plt egressed the acft prior to it going… - [NTSB NYC86LA041](https://openairdocs.org/ntsb/NYC86LA041.md): Cessna 150G · Palmyra, NY · Accident · No injuries · Limited investigation · Final report · Nov 24, 1985 · N8324J · Substantial damage > On landing the acft encountered wind gusts forcing the left wing upward, and hitting the right wing on the ground. The acft then spun around striking the prop and left wing on the rwy. - [NTSB ATL86FA029](https://openairdocs.org/ntsb/ATL86FA029.md): Cessna 182R · Bryson City, NC · Accident · 3 fatal · Field investigation · Final report · Nov 19, 1985 · N9547E · Destroyed > The acft made a normal apch and had the flaps down to about 15 deg. Touch down as about one third down the rwy. There was a bounce and the right wing came up and the acft veered to the left off the rwy. Power was applied and the acft paralleled the rwy. The… - [NTSB NYC86LA039](https://openairdocs.org/ntsb/NYC86LA039.md): Piper PA-34-200T · Atlantic City, NJ · Accident · No injuries · Limited investigation · Final report · Nov 17, 1985 · N3011P · Substantial damage > The acft experienced a collapse of the nose gear during the landing roll after what the plt said was a normal landing. The right main gear was further damaged during removal of the acft from the rwy. - [NTSB CHI86LA028](https://openairdocs.org/ntsb/CHI86LA028.md): Mooney M20F · Piper City, IL · Accident · No injuries · Limited investigation · Final report · Nov 14, 1985 · N2907L · Substantial damage > The pilot elected to land on a paved road because his rla was too wet. The aircraft landed on top of a moving automobile. The aircraft remained on top of the automobile as it ran off the side of the road. - [NTSB SEA86LA025](https://openairdocs.org/ntsb/SEA86LA025.md): Piper PA-12 · Imnaha, OR · Accident · No injuries · Limited investigation · Final report · Nov 12, 1985 · N3534M · Substantial damage > Prior to takeoff the pilot taxied through a lot of slush. A nose over occurred while attempting to land on a snow covered clearing. The nose over probably occurred due to very deep snow on the landing area and frozen brakes. - [NTSB ATL86FKG05](https://openairdocs.org/ntsb/ATL86FKG05.md): Smith, Ted Aerostar Aerostar 600 · Birmingham, AL · Accident · No injuries · Final report · Nov 12, 1985 · N107MW · Substantial damage > The left main gear collapsed during a loss of control on landing. The plt reported the acft touched down prematurely during the flare and it contacted the lip of the rwy at the apch end. Directional control could not be maintained, according to the plt, and… - [NTSB ANC86LA008](https://openairdocs.org/ntsb/ANC86LA008.md): Cessna 150 · Rainbow Lake, AK · Accident · No injuries · Limited investigation · Final report · Nov 12, 1985 · N9115U · Substantial damage > The plt reported that after the acft touched down on a snow covered, frozen lake, he was unable to hold the nose gear up, due to the depth of the snow. When the nose came down, the nose gear buckled under & the acft nosed over. - [NTSB MIA86IA029](https://openairdocs.org/ntsb/MIA86IA029.md): Piper PA-44-180 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Nov 9, 1985 · N2103K · Minor damage > The plt stated that he was on a practice instrument apch & after arriving at minimums, declared a missed apch, retracted his landing gear & flaps but decided to land and continued his apch & inadvertently landed gear up. - [NTSB FTW86FPA05](https://openairdocs.org/ntsb/FTW86FPA05.md): Mooney MK20J · Gladewater, TX · Accident · Minor injuries · Final report · Nov 8, 1985 · N201QW · Substantial damage > During takeoff the headset wiring became tangled in the emergency gear extension handle which had been accidently activated. Then the normal gear handle was put in the up position, the emergency gear crank rotated pulling on the headset and the emergency gear… - [NTSB MIA86LA025](https://openairdocs.org/ntsb/MIA86LA025.md): Piper PA-34-200T · St.Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Nov 7, 1985 · N11RJ · Substantial damage > The pilot loaded the ac with 100 pounds of fuel,himself and 5 passengers and departed for a short local flight. The ac was landed 15 minutes later 382 pounds over max gross weight, and landed long on a 2800 ft runway, in a crosswind. The ac then skidded left… - [NTSB ATL86FA020](https://openairdocs.org/ntsb/ATL86FA020.md): Hawker Siddeley DH 125-400A · Sparta, TN · Accident · Serious injuries · Field investigation · Final report · Nov 7, 1985 · N100HF · Substantial damage > Ten minutes prior to landing heavy rain fell on airport. Acft mad normal touchdown,spoilers & lift dump activated.PIC delayed brake application as usual and did not get thrust levers in idle. After acft passed mid-field taxiway PIC reported brakes became… - [NTSB LAX86LA035](https://openairdocs.org/ntsb/LAX86LA035.md): Beech BE-58 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Nov 6, 1985 · N3674G · Substantial damage > The acft approached the rwy for landing without the landing gear extended. The controller instructed the plt to go around but the plt continued the apch and landed with the gear retracted. Post accident inspection of the acft disclosedthe gear selector was in… - [NTSB LAX86LA034](https://openairdocs.org/ntsb/LAX86LA034.md): Aerotek Pitts S-2A · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Nov 6, 1985 · N42XX · 2 aircraft · Substantial damage > During a dual instructional flight the CFI stated that he was looking for traffic while monitoring his student's performance. The CFI failed to observe that an acft was ahead of him in the traffic pattern. That acft was at a lower altitude & was on short… - [NTSB CHI86LA023](https://openairdocs.org/ntsb/CHI86LA023.md): Cessna 152II · Duluth, MN · Accident · No injuries · Limited investigation · Final report · Nov 5, 1985 · N45953 · Substantial damage > The student plt had been practicing touch and go landings and on his third apch the acft drifted to the right of the rwy. He added pwr and attempted to go around. He heard the stall warning horn so he lowered the nose. The acft contactedthe ground, flipped… - [NTSB LAX86LA032](https://openairdocs.org/ntsb/LAX86LA032.md): Cessna T188C · Hilo, HI · Accident · No injuries · Limited investigation · Final report · Nov 4, 1985 · N9958J · Destroyed > The plt became aware of the acft's unanticipated low fuel state when the eng failed while over the pacific ocean, aprx 900 miles from his destination. He restarted the eng but estimated there was not enough fuel remaining to reach his original destination. He… - [NTSB MKC86LA024](https://openairdocs.org/ntsb/MKC86LA024.md): Piper PA-24-180 · Grandview, MO · Accident · No injuries · Limited investigation · Final report · Nov 3, 1985 · N7067P · Substantial damage > This pilot was making a takeoff for a local flight in his Piper PA-24. He stated that he was airborne when he raised the landing gear switch but the airplane settled back to the runway. Pilot said he became airborne again but could not get a safe indication.… - [NTSB NYC86LA029](https://openairdocs.org/ntsb/NYC86LA029.md): Cessna 152 · Bloomsburg, PA · Accident · No injuries · Limited investigation · Final report · Nov 2, 1985 · N24509 · Substantial damage > The plt landed with a 15 KTS tailwind and over a 30 ft obstacle. The acft touched down 1/2 way down the 2000 ft long rwy. Due to excessive speed the acft went into the overrun and became airborne for a short distance before touching downin a nose low altitude… - [NTSB MIA86LA023](https://openairdocs.org/ntsb/MIA86LA023.md): Cessna 152 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Oct 31, 1985 · N15BX · Substantial damage > The plt stated the acft bounced four times on landing. During the fourth bounce the acft impacted the rwy hard causing the nose tire to blow out and the nose gear to bend. - [NTSB CHI86LA021](https://openairdocs.org/ntsb/CHI86LA021.md): Eagle DW-1 · Bangor, MI · Accident · No injuries · Limited investigation · Final report · Oct 30, 1985 · N8807Z · Substantial damage > The acft nosed over after landing on a grass landing strip. The pilot stated the tail came up and the aircraft flipped over on its back after left brake was applied. An examination of the landing gear and brakes revealed that the right brake was released but… - [NTSB SEA86LA019](https://openairdocs.org/ntsb/SEA86LA019.md): Cessna C206 · Funter Bay, AK · Accident · No injuries · Limited investigation · Final report · Oct 29, 1985 · N756FX · Substantial damage > The left main gear did not retract and during water landing caused the aircraft to nose over. The link pin rod was found to be broken and the cylinder assembly main retract link and pin down latch were found to be bent. - [NTSB MKC86IA018](https://openairdocs.org/ntsb/MKC86IA018.md): SAAB-Fairchild SF340A · Lincoln, NE · Incident · No injuries · Incident investigation · Final report · Oct 29, 1985 · N342AM · No damage > During landing roll at the Lincoln airport, the outboard wheel of the left main landing gear separated from the axle. The acft was not hampered in its landing roll and taxithe landing gear assembly revealed that a retaining nut washer was not installed on… - [NTSB NYC86LA024](https://openairdocs.org/ntsb/NYC86LA024.md): Piper PA-38-112 · Norwood, MA · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1985 · N2561P · Destroyed > The plt stated a gust of wind was encountered when the acft was 5 ft from touchdown. The gust turned the acft 90 degs from the rwy heading. The plt applied pwr to avoid trees but was unsuccessful and a collision with the trees occurred. Winds were reportedly… - [NTSB LAX86LA027](https://openairdocs.org/ntsb/LAX86LA027.md): Cessna 172P · Fullerton, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1985 · N98954 · Substantial damage > During an instructional flt the student plt, who had a total of 5 hrs of flt time, attempted to land with the flaps extended to the 20 deg position. The acft ballooned, & the CFI took control & elected to complete the landing. Insufficient rwy remained & the… - [NTSB CHI86LA020](https://openairdocs.org/ntsb/CHI86LA020.md): Cessna 150L · Ashland, OH · Accident · No injuries · Limited investigation · Final report · Oct 26, 1985 · N7447G · Substantial damage > The student pilot was on his second solo flt after he made six landings with his instructor. On the third touch and go the acft hit hard, bounced, stalled, and contacted the rwy in a nose down attitude. The student plt attempted recovery from the hard landing… - [NTSB CHI86LA019](https://openairdocs.org/ntsb/CHI86LA019.md): Cessna 150 · Clinton, IN · Accident · No injuries · Limited investigation · Final report · Oct 26, 1985 · N10769 · 2 aircraft · Substantial damage > Both student plts were making an apch to the same rwy at the time. The Cessna 152 touched down and was in its landing roll when the Cessna 150 landed on top with its nose wheel and prop in the 152'S rear window. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=420 ## 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=419 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.