# 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 433 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB MKC85LA049](https://openairdocs.org/ntsb/MKC85LA049.md): Cessna 150A · Independence, MO · Accident · No injuries · Limited investigation · Final report · Jan 13, 1985 · N7025X · Substantial damage > Plt made two go-arounds because the acft was blown to the left of the rwy. Acft touched on third attempt, veered to the left and contacted a snowbank. - [NTSB LAX85LA110](https://openairdocs.org/ntsb/LAX85LA110.md): Waco YKC · Placerville, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1985 · N14000 · Substantial damage > Acft was lined up on rwy but plt misjudged height and acft stalled aprx 3 ft above the ground. Acft bounced and upon contacting the ground veered right. Plt over compensated and acft ground looped traveling off left side of rwy into a road. The pond is aprx… - [NTSB LAX85LA108](https://openairdocs.org/ntsb/LAX85LA108.md): Cessna T210L · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Jan 12, 1985 · N4691Q · Substantial damage > During first leg of the flight, plt discovered that landing gear would not extend. Pressurizing 'down side' with emergency hand pump allowed normal operation of the landing gear. On return flt to San Jose, plt tried to extend the gear but system would not… - [NTSB CHI85LA085](https://openairdocs.org/ntsb/CHI85LA085.md): Piper PA-32-301 · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Jan 10, 1985 · N83187 · Substantial damage > The low time pilot with six POB was ld at dark night light saw showers and icy patches on runway during rollout the acft entered a skid with nose cocked to the left the left main gear failed outboard and the acft exited the left side of the rwy the left wing… - [NTSB BFO85FA012](https://openairdocs.org/ntsb/BFO85FA012.md): Rockwell Sabreliner/NA265-40 · Glen Burnie, MD · Accident · Minor injuries · Field investigation · Final report · Jan 9, 1985 · N1863T · Substantial damage > While on short final the acft was obsvd to nose down into the displaced threshold of rwy 33L. The coplt stated that he sensed that he was getting slow and went to add pwr with his left hand. He was sitting for the first time in the left seat and although he… - [NTSB MKC85LA046](https://openairdocs.org/ntsb/MKC85LA046.md): Cessna 152 · Des Moines, IA · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 1985 · N68318 · Substantial damage > Plt was informed of holes along the right side of the rwy so he intentionally touched own on the left side of the rwy. The left main gear contacted a snowbank which paralled the rwy and the acft nosed into the snowbank. - [NTSB MKC85LA044](https://openairdocs.org/ntsb/MKC85LA044.md): Piper PA-28-161 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jan 6, 1985 · N84499 · Substantial damage > Pilot said acft swerved to right during landing roll. Acft ran off right side of rwy into snow covered area resulting indamage to wing & gear. No evidence of aircraft malfunction was found after the accident. - [NTSB MIA85LA075](https://openairdocs.org/ntsb/MIA85LA075.md): Cessna 152 · Wesley Chapel, FL · Accident · No injuries · Limited investigation · Final report · Jan 6, 1985 · N94560 · 2 aircraft · Substantial damage > The student plt flying N94560 was making her 1st solo touch and go landing when control of the acft was lost. Upon touchdown, N94560 veered left, departed the rwy and collided with N3854D which was being taxied on the grass aprx 20 ft from the rwy. - [NTSB FTW85LA093](https://openairdocs.org/ntsb/FTW85LA093.md): Cessna 310 · Corpus Christi, TX · Accident · No injuries · Limited investigation · Final report · Jan 6, 1985 · N5301A · Substantial damage > Plt rptd loss of pwr on left eng during flare; directional control was lost & acft went off side of the rwy. Left gear collapsed and acft rcvd substantial damage. Engines were run after acct. Reason for rptd loss of pwr undet. Acfts radio inop. Plts seat back… - [NTSB MIA85LA072](https://openairdocs.org/ntsb/MIA85LA072.md): Raven S-60A · Pompano Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 5, 1985 · N4270A · Minor damage > The balloon envelope struck a palm tree and a building while landing. The basket turned over when it contacted the ground. A passenger was injured when another passenger fell on her as the basket turned over. - [NTSB FTW85LA092](https://openairdocs.org/ntsb/FTW85LA092.md): Gates Learjet 25B · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Jan 5, 1985 · N55PT · Substantial damage > The plt-in-command (PIC) reported that after touchdown, the spoilers & brakes were applied, but no braking action was felt although peddle pressure was evident. He stated that by the time it was clear that the brakes were ineffective,insufficient rwy remained… - [NTSB LAX85LA096](https://openairdocs.org/ntsb/LAX85LA096.md): Cessna 172RG · Camarillo, CA · Accident · No injuries · Limited investigation · Final report · Jan 4, 1985 · N5194U · Substantial damage > The plt reported that upon landing a strong gust of wind caused the acft to deviate to the left. Application of the appropriate flight controls did not arrest the deviation. Brakes were applied but not in time to prevent the acft from exiting the rwy. The… - [NTSB ANC85LA032](https://openairdocs.org/ntsb/ANC85LA032.md): Cessna 207A · Nuiqsut, AK · Accident · No injuries · Limited investigation · Final report · Jan 4, 1985 · N9237M · Substantial damage > After a night landing by the copilot, and after the first bounce, the pilot in command took control of the aircraft after it developed a high sink rate. The pilot then ground looped the aircraft. - [NTSB CHI85LA083](https://openairdocs.org/ntsb/CHI85LA083.md): Cessna 172M · Mt Sterling, IL · Accident · No injuries · Limited investigation · Final report · Jan 2, 1985 · N9484H · Substantial damage > The plt landed long at his home arpt using no flaps with a prevailing tailwind. The 2600 ft turf strip was frozen. During braking the acft skidded off the rwy and struck a snow berm before rolling inverted. - [NTSB DEN85LA054](https://openairdocs.org/ntsb/DEN85LA054.md): Cessna 180 · Marion, MT · Accident · No injuries · Limited investigation · Final report · Jan 1, 1985 · N966K · Substantial damage > The acft nosed over onto its back after the plt landed in snow 6 to 8 inches in depth. - [NTSB MIA85LA068](https://openairdocs.org/ntsb/MIA85LA068.md): Schweizer 2-33A · Orlando, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 29, 1984 · N1229S · Substantial damage > The acft was flared for landing about 1/2 way down the rwy at excessive airspeed. The plt stated that as the acft touched down, it bounced into the air and impacted trees at 10-15 ft AGL. The spoilers were found in a retracted position after the accident.… - [NTSB DEN85LA051](https://openairdocs.org/ntsb/DEN85LA051.md): Cessna 152 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Dec 29, 1984 · N48738 · Substantial damage > According to the solo student plt, the landing was made in a snow filled ditch aprx 5 ft right of the rwy. The nose gear collapsed and the acft nosed over. The plt and his CFI stated that rwy markings were inadequate. - [NTSB LAX85FA091](https://openairdocs.org/ntsb/LAX85FA091.md): Bell 47G3B · San Diego, CA · Accident · 1 fatal · Field investigation · Final report · Dec 28, 1984 · N474MP · Substantial damage > The helicopter landed on the morred tuna boat. After toudhdown the helicopter appeared to be repositioning itself when the main rotor blades contacted the boom portion of a crane which was being utilized to load bags of salt aboard the boat. - [NTSB NYC85LA050](https://openairdocs.org/ntsb/NYC85LA050.md): Beech P35 · Morrisville, VT · Accident · No injuries · Limited investigation · Final report · Dec 27, 1984 · N1DL · Substantial damage > Plt noted accumulation of rime ice in flt. On NDB approach, VFR conditions reached about 7 miles from runway, IFR flt plan cancelled and straight-in visual approach performed. Crossing threshold at about 2O ft AGL, plt reduced throttle and acft immediately… - [NTSB MIA85FA067](https://openairdocs.org/ntsb/MIA85FA067.md): Lounsbery Taylor/COOT-A · Punta Gorda, FL · Accident · Serious injuries · Field investigation · Final report · Dec 27, 1984 · N24GL · Destroyed > The acft was landed hard, according to witnesses, after completion of the first takeoff and flt around the traffic pattern. The plt shut off the eng, exited the acft & inspected for damage. He then restarted the eng and took off again. The plt stated after… - [NTSB CHI85LA080](https://openairdocs.org/ntsb/CHI85LA080.md): Piper Aerostar 600 · Kalamazoo, MI · Accident · No injuries · Limited investigation · Final report · Dec 27, 1984 · N8060J · Substantial damage > The plt reported upon touchdown, the acft contacted a patch of ice causing it to slide sideways resulting in a left main gear collapse. ATC twr witnesses stated the acft appeared fast on final and a hard landing was made. - [NTSB NYC85LA049](https://openairdocs.org/ntsb/NYC85LA049.md): Piper PA-28-140 · Marlboro, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1984 · N3968K · Substantial damage > The acft landed hard on runway 27 at Marlboro airport while on a solo flight. The aircraft was substantially damaged andthe student pilot received minor injuries. The pilot had a total of 47 flight hours all of which were in the same make and model aircraft.… - [NTSB FTW85LA085](https://openairdocs.org/ntsb/FTW85LA085.md): Beech 95-C55 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Dec 24, 1984 · N4826J · Substantial damage > The plt attempted to extend the landing gear but failed to complete the landing checklist by insuring that the gear were down and locked. The acft landed gear up causing a small post crash fire. The plt had been requested to keep his speed up during the apch.… - [NTSB CHI85LA082](https://openairdocs.org/ntsb/CHI85LA082.md): Beech BE-58 · Flint, MI · Accident · No injuries · Limited investigation · Final report · Dec 24, 1984 · N300EP · Substantial damage > During a flt in IFR conditions the acft encountered icing. The ice was still on the wings and tail when the acft prepared to land. Extra airspeed was carried on final approach. The acft ballooned as it flared for touchdown. It then stalled and made a hard… - [NTSB MIA85LA062](https://openairdocs.org/ntsb/MIA85LA062.md): Great Lakes 2T-1A-2 · Naples, FL · Accident · No injuries · Limited investigation · Final report · Dec 23, 1984 · N14JV · Substantial damage > After making a three point landing on the paved runway the pilot lost control of the acft, it veered left and ran off the rwy. The acft then struck a mound of sandy soil and nosed over. - [NTSB LAX85LA095](https://openairdocs.org/ntsb/LAX85LA095.md): Pitts Special SST · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Dec 23, 1984 · N272H · Substantial damage > During 3 previous touch & go landings the plt noticed a slight tendency for the acft to turn rt during the landing roll roll. He decided to make a full stop landing. During the landing the plt allowed the acft roll onto the runway shoulder. He said he was… - [NTSB BFO85LA010](https://openairdocs.org/ntsb/BFO85LA010.md): Luscombe 8F · Newburg, MD · Accident · No injuries · Limited investigation · Final report · Dec 23, 1984 · N836B · Substantial damage > During ldg roll the PIC felt a vibration as the tailwheel contacted the rwy. In an effort to minimize the vibration the plt lifted the tailwheel off the rwy. The acft began to ground loop to the right toward a pole. Heavy application of the wheel brakes… - [NTSB LAX85LA079](https://openairdocs.org/ntsb/LAX85LA079.md): Bell 47G · Chatsworth, CA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1984 · N182JR · Destroyed > The plt was practicing off airport touch & go's. on the second lndg the left skid contacted a hidden dirt embankment andthe acft rolled over. A post impact fire consumed the aircraft. Both certificated commercial plts aboard the helicopter escaped unharmed.… - [NTSB NYC85LA046](https://openairdocs.org/ntsb/NYC85LA046.md): Cessna 140 · Burlington, VT · Accident · No injuries · Limited investigation · Final report · Dec 21, 1984 · N77110 · Substantial damage > The acft skidded & veered left during the landing roll, & subsequently, it nosed over on the rwy. - [NTSB CHI85IA073](https://openairdocs.org/ntsb/CHI85IA073.md): Beech 58P · Akron, OH · Incident · No injuries · Incident investigation · Final report · Dec 21, 1984 · N25RL · Minor damage > During arrival at medina, OH, the plt discovered that the NDB was inop, so he diverted to the Akron fulton arpt. He was vectored for a localizer apch to rwy 25. During the apch, he descended to the min descent alt (mda) of 512 ft AGL. When he had the arpt in… - [NTSB LAX85LA061](https://openairdocs.org/ntsb/LAX85LA061.md): Piper PA-30 · Garberville, CA · Accident · No injuries · Limited investigation · Final report · Dec 20, 1984 · N8780Y · Substantial damage > The plt reported that on his first attempt to land he was 'too high' so he made a go-around. On the second apch to the 3050 ft rwy, he was flying at 110 mph. He landed long, applied brakes & skidded off the dept end of the rwy. The lt tire blew-out,… - [NTSB NYC85LA045](https://openairdocs.org/ntsb/NYC85LA045.md): Piper PA-18-150 · Stow, MA · Accident · No injuries · Limited investigation · Final report · Dec 18, 1984 · N14315 · Substantial damage > Plt stated that after a normal crosswind touchdown, the tail section did not drop as expected, but rose and veered left. Acft swerved and flipped inverted. - [NTSB ATL85LA059](https://openairdocs.org/ntsb/ATL85LA059.md): Aerospatiale SA341G · Cornelius, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1984 · N49534 · Substantial damage > With the executive vice president of the company acting as PIC and the company plt acting as co-plt, the acft approcahed the operator's slightly elevated helipad. According to pax statements, the acft landed hard, bounced into the air and began spinning… - [NTSB CHI85LA071](https://openairdocs.org/ntsb/CHI85LA071.md): Cessna 182K · Lincoln, IL · Accident · No injuries · Limited investigation · Final report · Dec 17, 1984 · N2776Q · Substantial damage > The plt lost directional control during the landing roll. The acft veered to the right, rolled through 60 ft of sod, struck a dead furrow & nosed up. Winds were from 230 degrees at 13 KTS. The plt stated he should have used more rudder for cross wind… - [NTSB LAX85LA077](https://openairdocs.org/ntsb/LAX85LA077.md): Cessna 177RG · Santa Maria, CA · Accident · No injuries · Limited investigation · Final report · Dec 15, 1984 · N34992 · Substantial damage > After touchdown on a touch-and-go lndg, acft veered left and left wing came up, raising left wheel off ground. Plt corrected with aileron and added power for go-around but acft was off runway and traversing soft terrain; lift-off speed was not attained and… - [NTSB DEN85LA044](https://openairdocs.org/ntsb/DEN85LA044.md): Piper PA-28RT-201 · Nucla, CO · Accident · No injuries · Limited investigation · Final report · Dec 15, 1984 · N2193Y · Substantial damage > According to the plt, after landing on centerline brakes were applied and ice on the rwy caused the acft to veer left. An abort was initiated but realizing that the acft was going off the side of the rwy the plt secured the eng. The nose gear collapsed as the… - [NTSB MKC85LA055](https://openairdocs.org/ntsb/MKC85LA055.md): Beech 300 · Hutchinson, KS · Accident · No injuries · Limited investigation · Final report · Dec 14, 1984 · N6823M · Substantial damage > On late final, the plt under instruction reduced pwr sharply to correct a slightly high approach, advancing the propeller controls to full increase. The combination of power reduction and increased profile drag on the propellers was excessive for the desired… - [NTSB DEN85LA042](https://openairdocs.org/ntsb/DEN85LA042.md): Hughes 369D · Springville, UT · Accident · No injuries · Limited investigation · Final report · Dec 13, 1984 · N58220 · Substantial damage > The acft was being positioned at a remote site for a passenger pick-up. During the maneuvering to get into a good spot for landing the plt lost visual reference because of blowing snow. The plt said he felt the right skid hit the ground and lowered collective… - [NTSB SEA85LA029](https://openairdocs.org/ntsb/SEA85LA029.md): Cessna 172M · Sultan, WA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1984 · N4436R · Substantial damage > An overrun occurred on the 2,000 foot airstrip due to excess approach and landing speed. A light coating of snow was present on the grass runway and the pilot neglected to raise the flaps adding to a longer landing roll and making braking less effective. A 5… - [NTSB NYC85LA040](https://openairdocs.org/ntsb/NYC85LA040.md): Beech 58TC · Norwood, MA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1984 · N2164L · Substantial damage > Touchdown made 1/3 the way down the wet rwy. Brakes were ineffective on wet pavement. Plt raised flaps and reapplied brakes with no positive result. Acft continued onto 60 ft overrun area where some braking action was effective however, acft continued down an… - [NTSB MIA85LA055](https://openairdocs.org/ntsb/MIA85LA055.md): Cessna 150F · Fort Myers, FL · Accident · No injuries · Limited investigation · Final report · Dec 9, 1984 · N8600S · Substantial damage > The plt was practicing touch and go landings. On the accident landing the acft drifted to the rt of the rwy and touched down with a side angle. The plt said the acft ballooned and he applied power to go around but thought he did not have the proper control so… - [NTSB LAX85LA064](https://openairdocs.org/ntsb/LAX85LA064.md): Beech B-60 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 1984 · N6023S · Substantial damage > During landing roll out the plt observed the acft's nose gear begin to collapse. Although on approach the plt had placed the ldg gear selector in the down position & had observed the illumination of the green gear down lights, the plt responded to the… - [NTSB CHI85LA065](https://openairdocs.org/ntsb/CHI85LA065.md): Cessna 150C · Hampshire, IL · Accident · No injuries · Limited investigation · Final report · Dec 9, 1984 · N7954Z · Substantial damage > Touchdown occurred nearly half-way down airstrip, which was wet with melting frost. Plt did not attempt a go-around, but relied on braking action for safe completion of landing roll. Braking action was nil. Acft overran through a barbed-wire fence and into a… - [NTSB ATL85LA051](https://openairdocs.org/ntsb/ATL85LA051.md): Grumman AA-5B · Fremont, NC · Accident · No injuries · Limited investigation · Final report · Dec 9, 1984 · N74636 · Substantial damage > The student plt reported that he landed hard & bounced twice before settling to the rwy. He applied full braking & the acft skidded off the end of the rwy. - [NTSB MKC85FA032](https://openairdocs.org/ntsb/MKC85FA032.md): Swearingen SA226TC · Harrison, AR · Accident · No injuries · Field investigation · Final report · Dec 7, 1984 · N511SS · Substantial damage > The acft was being operated as skyways flt 488. The first officer was flying the acft. The acft touched down on the rwy aprx 1584 feet from the approach end and after a short roll, the landing gear warning horn sounded and the left wing settled to the ground.… - [NTSB NYC85LA038](https://openairdocs.org/ntsb/NYC85LA038.md): Gulfstream 690B · Millinocket, ME · Accident · No injuries · Limited investigation · Final report · Dec 6, 1984 · N699GN · Substantial damage > Plt stated that after touchdown, acft began a left drift. As plt applied corrective input, he noted the left wheel was in a snow windrow, so additional input was made to break wheel free of window. Left wheel crossed windrow as acft swerved right but plt was… - [NTSB LAX85LA060](https://openairdocs.org/ntsb/LAX85LA060.md): Stinson 108-2 · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 1984 · N426C · Substantial damage > When the plt received ldg instructions the wind was reported as being calm. During ldg flare on rwy 26, at 2 ft AGL, a gust was encountered. The gust was from the acft's 7 o'clock position & the plt was unable to maintain control of the acft. He stated that… - [NTSB FTW85LA069](https://openairdocs.org/ntsb/FTW85LA069.md): Cessna 152 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Dec 6, 1984 · N25890 · Substantial damage > After touchdown flaps were raised and power added to takeoff during the touch-&-go landing. The solo student pilot was unable to maintain birectional control of the acft and it went off the left side of the asphalt rwy. The acft nosed overafter colliding with… - [NTSB FTW85LA064](https://openairdocs.org/ntsb/FTW85LA064.md): Cessna 152 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Dec 3, 1984 · N6114Q · Substantial damage > Shortly after touchdown on a full stop landing directional control was lost and the acft went off the left side of the 5,000 x 100 ft rwy. The aircraft collided with and came to rest in a ditch on the north side of the runway. Winds were northeasterly at 10… - [NTSB NYC85LA036](https://openairdocs.org/ntsb/NYC85LA036.md): Piper PA-24-250 · Meriden, CT · Accident · No injuries · Limited investigation · Final report · Dec 2, 1984 · N7453P · Substantial damage > While in cruise, plt heard an abnormal sound from the left side of the engine compartment and having had previous problems with the newly-installed engine, elected to make a precautionary landing at a nearby arpt to investigate. Plt stated he landed long and… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=434 ## 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=433 --- 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.