# 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 432 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB CHI85LA111](https://openairdocs.org/ntsb/CHI85LA111.md): Cessna 195B · Galena, OH · Accident · No injuries · Limited investigation · Final report · Feb 16, 1985 · N3081B · Substantial damage > The acft nosed over when the main lndg gear hit a snowbank during lndg. Te plt stated that he had a x-wind from the rt side. He allowed the acft to drift left into the snow. - [NTSB CHI85LA107](https://openairdocs.org/ntsb/CHI85LA107.md): Cessna 152 · Mansfield, OH · Accident · No injuries · Limited investigation · Final report · Feb 16, 1985 · N93154 · Substantial damage > The student pilot was given clearance to land rwy 14, but lined up & landed rwy 05 which was snow & ice covered. The pilot lost control on landing roll striking a snow bank and turning over. - [NTSB ANC85FA048](https://openairdocs.org/ntsb/ANC85FA048.md): Cessna 152 · Elmendorf Afb, AK · Accident · Minor injuries · Field investigation · Final report · Feb 16, 1985 · N4745P · Substantial damage > Upon touchdown the acft bounced on the main gear. Control of the acft was lost and it touched back down on a heading aprx 30 degrees right of the rwy heading. The acft then contacted a snow bank alongside the rwy. - [NTSB LAX85LA141](https://openairdocs.org/ntsb/LAX85LA141.md): Bellanca 14-13-2 · Corona, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 15, 1985 · N74315 · Substantial damage > While the acft was on final apch the plt tried to slow the acft by lowering the landing gear and flaps. The acft sink rate increased and the acft contacted trees before the plt applied power. The acft touched down 50 ft short of rwy in soft ground where the… - [NTSB DEN85LA082](https://openairdocs.org/ntsb/DEN85LA082.md): Cessna 152 · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Feb 15, 1985 · N24950 · Substantial damage > The acft collided with a snowbank during the landing roll following a loss of directional control. The plt reported that the left brake froze or locked up when it was applied during the landing. Inspection revealed that there was a substantial amount of ice… - [NTSB NYC85LA065](https://openairdocs.org/ntsb/NYC85LA065.md): Piper PA-28-180 · E.Milford, NJ · Accident · No injuries · Limited investigation · Final report · Feb 14, 1985 · N8274W · Substantial damage > The acft contacted a patch of ice on the rwy during landing. Control of the acft was lost and it contacted a snow bank which resulted in substantial damage. - [NTSB LAX85LA138](https://openairdocs.org/ntsb/LAX85LA138.md): Beech BE-18 · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Feb 13, 1985 · N81DA · Substantial damage > The plt reptd that during the landing rollout on rwy 30, a gust of wind caused the acft right wing to lift. The plt was unable to correct the uplifting wing and the acft entered into a left groundloop maneuver & exited the rwy. The local controller reported… - [NTSB MIA85LA094](https://openairdocs.org/ntsb/MIA85LA094.md): Maule M-5-235C · Ft.Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Feb 11, 1985 · N9207E · Substantial damage > The acft landed with a x-wind component of about 25 KTS from the right. The plt and witnesses stated the wind lifted the right wing of off the rwy. Side forces resulted in the left main landing gear collapsing. Maximum demonstrated takeoff and landing x-wind… - [NTSB CHI85LA106](https://openairdocs.org/ntsb/CHI85LA106.md): Cessna 150D · Siren, WI · Accident · No injuries · Limited investigation · Final report · Feb 11, 1985 · N4267U · Substantial damage > The acft collided with a snow bank during landing. This was a solo student flt for the plt. The wind was 20 degrees off the rwy heading and varying bet 7-12 KTS in velocity. The student reported that either more brake & aileron or a running takeoff would have… - [NTSB ATL85LA095](https://openairdocs.org/ntsb/ATL85LA095.md): Beech 58 · Natchez, MS · Accident · No injuries · Limited investigation · Final report · Feb 11, 1985 · N912L · Substantial damage > Plt descended below mda to 720 ft MSL until observing the rwy during a LOC 17 apch at night. An arpt attendant said plt did not call UNICOM for wind info. Plt acknowledged touchdown at midfield with a 30 kt tailwind on the 5000 ft rwy. The plt said braking… - [NTSB MIA85LA092](https://openairdocs.org/ntsb/MIA85LA092.md): Piper J3C-65 · St.Augustine, FL · Accident · No injuries · Limited investigation · Final report · Feb 10, 1985 · N92668 · Substantial damage > The acft collided with a wind direction indicator support pole during a recovery from a bounced landing. The CFI on board stated he turned his head to advise the student in the back seat to keep the left wing down because of the x-wind condition when he… - [NTSB MIA85LA091](https://openairdocs.org/ntsb/MIA85LA091.md): Schweizer G-164A · Panama City, FL · Accident · No injuries · Limited investigation · Final report · Feb 10, 1985 · N3630D · Substantial damage > Plt was landing on a city street so the acft could be put on display. When the acft overran the end of the street the plt locked the brakes to avoid contacting buildings and vehicles and the acft nosed over. - [NTSB LAX85LA135](https://openairdocs.org/ntsb/LAX85LA135.md): Beech 65 · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1985 · N212Y · Substantial damage > An inspection of rwy 8 disclosed the acft touched down on the two main gear simultaineously, followed immediately by thecollapse of the nose gear. The acft's nose & both propellers contacted the rwy, with no indication of a yaw. The nose gear actuator ass'y… - [NTSB FTW85LA114](https://openairdocs.org/ntsb/FTW85LA114.md): Cessna 172E · Hobart, OK · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 1985 · N3818S · Substantial damage > At 1515 CST, the plt contacted a fss & was advised that a front would be moving thru the destination (Hobart) area at about 2200. When he departed stillwater at 1840, the wind was from the south. At 2004, the plt contacted altus afb & was advised that the… - [NTSB BFO85LA016](https://openairdocs.org/ntsb/BFO85LA016.md): Cessna 152-II · Ocean City, MD · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 1985 · N68192 · Substantial damage > While on a student solo x-country flight, the plt experienced vertical gusting conditions during the second landing pattern, following an initial go-around. Fearing a hard landing due to a severe gust, the plt abruptly applied full back pressure on the stick,… - [NTSB SEA85LA055](https://openairdocs.org/ntsb/SEA85LA055.md): Beech 58TC · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Feb 9, 1985 · N6588S · Substantial damage > The acft touched down to the left of the runway onto snow. Visibility at the time of the accident was 1 mile with snow and a ceiling of 700 feet. - [NTSB CHI85LA105](https://openairdocs.org/ntsb/CHI85LA105.md): Cessna 172RG · Lawrenceville, IL · Accident · No injuries · Limited investigation · Final report · Feb 9, 1985 · N6464R · Substantial damage > The private plt & his instructor were practicing instrument approaches. The instructor stated that the fuel gages were reading low & the VOR needle was oscillating, so they decided to make a straight-in landing. He stated that they lowered the gear & flaps,… - [NTSB ATL85LA094](https://openairdocs.org/ntsb/ATL85LA094.md): Champion 7FC · Louisville, KY · Accident · No injuries · Limited investigation · Final report · Feb 9, 1985 · N7507E · Substantial damage > The student plt departed from a snow covered rwy & proceeded on a solo x-country. When he returned, the nosewheel broke thru the snow crusted surface & collapsed, then the acft nosed over. The plt said there were ruts on the rwy from other acft which caused… - [NTSB ATL85LA092](https://openairdocs.org/ntsb/ATL85LA092.md): Beech 95-C55 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Feb 9, 1985 · N211DS · Substantial damage > Plt making practice coupled ILS apch in VMC. Intercepted localizer outside the outer marker. Held the gear,intending to lower them at om. Continued inbd to dh where he resumed manual control. Observed gear warning lt and heard aural gear warning but failed to… - [NTSB MKC85LA056](https://openairdocs.org/ntsb/MKC85LA056.md): Piper PA-31 · Bentonville, AR · Accident · No injuries · Limited investigation · Final report · Feb 8, 1985 · N27743 · Substantial damage > During the landing approach, the plt stated, he probably forgot to extend the landing gear. Inspection of the acft revealed no mechanical problem with the landing gear extension or retraction mechanism. A test of the landing gear system showed it to work… - [NTSB CHI85LA102](https://openairdocs.org/ntsb/CHI85LA102.md): Cessna 421C · Bay City, MI · Accident · No injuries · Limited investigation · Final report · Feb 8, 1985 · N5484G · Substantial damage > The acft colloded with a snowbank during lndg. The plt & passg stated that a lndg gear cught in snow piled at an intersection from plowing. The induced drag veered the acft off the rwy to the left. - [NTSB MIA85LA090](https://openairdocs.org/ntsb/MIA85LA090.md): Piper PA-28R-200 · Merritt Island, FL · Accident · No injuries · Limited investigation · Final report · Feb 7, 1985 · N8591N · Substantial damage > Plt lost directional control and the acft collided with a dirt embankment while landing. The acft was landed with a right rear crosswind. - [NTSB ANC85LA046](https://openairdocs.org/ntsb/ANC85LA046.md): Cessna 207A · Koyuk, AK · Accident · 1 fatal · Limited investigation · Final report · Feb 7, 1985 · N7329U · Minor damage > The acft landed about 630 ft short of the threshold of rwy 02. The plt said he purposely landed short to take advantage of a rwy upslope and because of the location of snow removal equipment at the other end of the rwy. In landing short however he landed on… - [NTSB NYC85IA063](https://openairdocs.org/ntsb/NYC85IA063.md): CASA SAC-212-200 · Atlantic City, NJ · Incident · No injuries · Incident investigation · Final report · Feb 6, 1985 · N296CA · Minor damage > A construcciones sac 212-200 N296CA lost control during landing flare and landed hard on the grass along side runway 11 at bader field, new jersey, after all of the landing checks were completed the copilot pushed full forward the speed levers and called out… - [NTSB FTW85LA110](https://openairdocs.org/ntsb/FTW85LA110.md): Swearingen SA-226T · Shreveport, LA · Accident · No injuries · Limited investigation · Final report · Feb 2, 1985 · N20QN · Substantial damage > The plt landed on rwy 05 which was icy and covered with a blanket of fresh snow. He stated the wind was from 360 degs at 10 KTS. He had been informed of poor braking conditions on the rwy. The plt used main wheel brakes and reverse thrust. The acft drifted… - [NTSB LAX85LA127](https://openairdocs.org/ntsb/LAX85LA127.md): Helio H-295 · Lower Lake, CA · Accident · No injuries · Limited investigation · Final report · Jan 30, 1985 · N269E · Substantial damage > Plt attempted to abort a takeoff as the acft became airborne at aprx 40 mph. The right main gear collapsed when the acft touched down while it was yawed to the left. - [NTSB DEN85LA072](https://openairdocs.org/ntsb/DEN85LA072.md): Beech J35 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Jan 29, 1985 · N615Q · Substantial damage > The pilot was practicing touch and go landings. He stated the landing gear collapsed during landing. Investigation revealed gear door damage (gear intransit) and ldg gear circuit breaker was 'popped.' Post accident exam of the gear system failed to reveal any… - [NTSB MIA85LA085](https://openairdocs.org/ntsb/MIA85LA085.md): Bell 47-G · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jan 28, 1985 · N17271 · Substantial damage > The plt stated the helicopter gained too much forward speed because of gusty winds while he was maneuvering the helicopter to the refueling area. A hard landing resulted as the plt attempted to slow the helicopter to avoid contacting refueling equipment. - [NTSB LAX85LA124](https://openairdocs.org/ntsb/LAX85LA124.md): Cessna 172N · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Jan 28, 1985 · N4852G · Substantial damage > The 50 year old private pilot, with a total of 158 flight hours, said the landing was made on the right half of the 150 ft wide rwy. As he attempted to steer to the middle of the rwy the acft skidded off the left side of the rwy and contacted a snow bank aprx… - [NTSB ATL85LMG02](https://openairdocs.org/ntsb/ATL85LMG02.md): Piper PA-28-180 · Goldsboro, NC · Accident · No injuries · Final report · Jan 27, 1985 · N5291L · Substantial damage > While landing at night, the acft encountered unfavorable winds & went off the left side of the rwy. After departing the rwy, it hit a drainage ditch & the nose gear collapsed. About 50 mi northwest at the raleigh/durham arpt, the wind was variable from 290 to… - [NTSB FTW85LA103](https://openairdocs.org/ntsb/FTW85LA103.md): Cessna 172B · Coushatta, LA · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1985 · N7718X · Substantial damage > The acft was on its 1st flt following maintenance for a previous nose gear shimmy problem. When the student made his 1st attempt to land, he noticed that the nose gear seemed to be cocked, so he aborted the landing. On the 2nd attempt, the acft swerved to the… - [NTSB DEN85LA070](https://openairdocs.org/ntsb/DEN85LA070.md): Cessna 206 · Cedar City, UT · Accident · Minor injuries · Limited investigation · Final report · Jan 25, 1985 · N29044 · Substantial damage > The acft nosed over after contacting a ditch following a loss of directional control during a landing roll. The plt stated that after a soft touchdown the acft began to veer to the left of the rwy. Remedial rudder pressure and braking was attemted to no… - [NTSB CHI85LA095](https://openairdocs.org/ntsb/CHI85LA095.md): Beech BE-58 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jan 24, 1985 · N8555R · Substantial damage > Plt stated the landing gear was lowered on final apch at an airspeed of 148 KTS and a gear down & locked indication was received. Plt continued to state the acft settled closer to the rwy then usual during the landing flare and when the acft was nearing a… - [NTSB MKC85LA050](https://openairdocs.org/ntsb/MKC85LA050.md): Cessna 150L · Beloit, KS · Accident · No injuries · Limited investigation · Final report · Jan 23, 1985 · N10894 · Substantial damage > The student pilot stated he was practicing touch and go landings on rwy 35. After touchdown, the airplane veered left, hit a snowbank off the side of the runway & flipped forward to the inverted position. Winds were from 300 degrees at 5 knots, gusting to 10… - [NTSB LAX85LA148](https://openairdocs.org/ntsb/LAX85LA148.md): Piper PA-38-112 · Sahuarita, AZ · Accident · No injuries · Limited investigation · Final report · Jan 23, 1985 · N2403A · Substantial damage > Acft veered to the right during landing roll on an abandoned airstrip. Right wing contacted a tree aprx 1 ft inboard on right wing tip deforming the main spar. Trees lined both sides of the airstrip. - [NTSB LAX85LA121](https://openairdocs.org/ntsb/LAX85LA121.md): Cessna 152 · Eureka, CA · Accident · No injuries · Limited investigation · Final report · Jan 23, 1985 · N4931P · Substantial damage > While on a local solo instructional flt, the student plt made 3 attempts to land at the arpt. On the 3rd apch, the acft touched down about halfway down the rwy 'a little fast.' The plt added power to abort the landing & make a go-around. He then changed his… - [NTSB LAX85LA120](https://openairdocs.org/ntsb/LAX85LA120.md): Cessna 152 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Jan 22, 1985 · N65273 · Substantial damage > According to the flt instructor (CFI), the student plt demonstrated 4 good touch-&-go landings while on a dual instructional flt. The CFI decided to solo the student, who did not hold either a medical or student plt certificate. The CFI told the student to… - [NTSB CHI85LA093](https://openairdocs.org/ntsb/CHI85LA093.md): Saabye Cassutt Sport Racer · Lake Village, IN · Accident · Minor injuries · Limited investigation · Final report · Jan 22, 1985 · N12SG · Substantial damage > The acft nosed over after colliding with a snow bank during landing. A snow covered driveway, which parallels the rwy was used for landing. The driveway measures 2600'X 25' and the landing was made to the north. The acft was blown to the right during the… - [NTSB NYC85LA056](https://openairdocs.org/ntsb/NYC85LA056.md): Gates Learjet 25D · Johnstown, PA · Accident · No injuries · Limited investigation · Final report · Jan 21, 1985 · N212NE · Substantial damage > The acft overran the end of rwy 33 during an aborted takeoff. During the takeoff ground run the acft inadvertently became airborne at an airspeed bwt 80-150 KTS and ascended to an alt of aprx 30 ft AGL. The plt corrected for left yaw which was present and… - [NTSB LAX85LA118](https://openairdocs.org/ntsb/LAX85LA118.md): Helio H-250 · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Jan 21, 1985 · N55XV · Substantial damage > The acft bounced upon landing in calm wind conditions and the left main gear leg broke off whereupon the acft ground looped to the right. Inspection revealed rust on both sides of the gear strut about 6 inches below the fuselage where a brace is welded to the… - [NTSB FTW85LA099](https://openairdocs.org/ntsb/FTW85LA099.md): Piper PA-23-250 · Addison, TX · Accident · No injuries · Limited investigation · Final report · Jan 20, 1985 · N96DD · Substantial damage > The plt stated that on touchdown, the acft veered left & went off the edge of the 30' wide rwy. The nose gear then collapsed in soft terrain before the plt could get the acft back on the rwy surface. At 1900 CST, the wind was from 360 deg at 30 gusting 40 KTS. - [NTSB SEA85LA047](https://openairdocs.org/ntsb/SEA85LA047.md): Maule M-5-235C · Wenatchee, WA · Accident · No injuries · Limited investigation · Final report · Jan 19, 1985 · N6176M · Substantial damage > The plt elected to make a precautionary landing onto a snow covered grain field. He stated his artifical horizon was inoperative & darkness was approaching. Also, he said he saw a needle flicker & he was not sure if it was a fuel gage or his oil pressure… - [NTSB MKC85LA054](https://openairdocs.org/ntsb/MKC85LA054.md): Piper PA-20 · Wa Keeney, KS · Accident · No injuries · Limited investigation · Final report · Jan 18, 1985 · N5590H · Substantial damage > Acft touched down left of centerline. Left main gear contacted slush on the rwy and the acft swerved into a 2 to 3 ft snowbank alongside the rwy. Plt stated, 'the rwy was plenty clear and the accident would not have happened if the plane had been kept on the… - [NTSB ATL85LA080](https://openairdocs.org/ntsb/ATL85LA080.md): Cessna 310Q · Beaver, WV · Accident · No injuries · Limited investigation · Final report · Jan 18, 1985 · N69938 · Substantial damage > The acft collided with a snow bank during landing ground run on an icy rwy. Plts vision obstructed by ice on windshield. Icing was encountered about 10 mins prior to landing. SIGMET and plt reports indicated the presence of icing. The plt had filed an IFR flt… - [NTSB CHI85LA092](https://openairdocs.org/ntsb/CHI85LA092.md): Beech BE-58 · Lafayette, IN · Accident · No injuries · Limited investigation · Final report · Jan 17, 1985 · N4098S · Substantial damage > Plt diverted due to icing/unfavorable wx at dest. Plt stated the windshield iced over during the apch at purdue university arpt (the alternate) and he flared high resulting in a hard landing. - [NTSB LAX85FA111](https://openairdocs.org/ntsb/LAX85FA111.md): Beech C24R · Riverside, CA · Accident · No injuries · Field investigation · Final report · Jan 16, 1985 · N6020P · Substantial damage > An aborted takeoff was attempted by the plt when the acft failed to sustain flight. He landed on the side of the runway with one wheel in the grass and realized too late that normal braking was not sufficient to stop the landing roll before the acft went over… - [NTSB SEA85LA044](https://openairdocs.org/ntsb/SEA85LA044.md): Bellanca 7ECA · Deer Park, WA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1985 · N996MP · Substantial damage > Acft touched down in the displaced threshold which was not plowed clear of snow as the remaining portion of the rwy was. Acft nosed over following touchdwon. - [NTSB LAX85LA109](https://openairdocs.org/ntsb/LAX85LA109.md): Cessna 177 · Fullerton, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 14, 1985 · N3279T · Substantial damage > On landing, the acft porpoised after it touched down long & fast. A go-around was attempted, but too late, & the acft struck a fence at the end of the rwy. The owner of the acft a pre-solo student pilot, was a passenger. The 'pilot' left the scene & could not… - [NTSB FTW85LA096](https://openairdocs.org/ntsb/FTW85LA096.md): Beech V35B · Amarillo, TX · Accident · No injuries · Limited investigation · Final report · Jan 14, 1985 · N6735T · Substantial damage > During takeoff, the cabin door opened & the plt elected to return for a landing. He reported that he was distracted by wind noise & 'nervousness' and failed to assure that the gear was extended. As he flared, the propeller contacted the rwy. The plt added… - [NTSB ANC85LA044](https://openairdocs.org/ntsb/ANC85LA044.md): de Havilland DHC-2 · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Jan 14, 1985 · N62LC · Substantial damage > Acft is equipped with main gear skis and a tailwheel. Plt stated elevator & rudder controls stuck during the landing roll on snow covered terrain. Inspection reveladed the tail section of the acft collapsed after contacting the head of a small tree. The… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=433 ## 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=432 --- 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.