# 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 440 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB LAX84LA414](https://openairdocs.org/ntsb/LAX84LA414.md): Maule M-4-210C · Jackson, CA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1984 · N40692 · Substantial damage > During arrival, the plt observed the wind sock indicating a wind from the west at about 15 KTS. He entered the traffic pattern & landed on rwy 19. After touchdown, the acft encountered a gust of wind, ground looped & went off the right side of the rwy,… - [NTSB SEA84LA182](https://openairdocs.org/ntsb/SEA84LA182.md): Cessna 180 · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Jul 23, 1984 · N3117D · Substantial damage > During a precautionary landing the aircraft encountered a 180 degree windshift during rollout. The aircraft nosed over as a result of the resulting tailwind. - [NTSB LAX84LA413](https://openairdocs.org/ntsb/LAX84LA413.md): Ercoupe 415-CD · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Jul 23, 1984 · N3514H · Substantial damage > The student plt reported that when he landed, 'the nose hit 1st & a bit hard causing a balloon. Then the plane again came down hard & ballooned. This happened about 3 times before the plane stopped & went on the nose.' The nose gear collapsed during the… - [NTSB FTW84LA320](https://openairdocs.org/ntsb/FTW84LA320.md): Cessna 152 · College Station, TX · Accident · No injuries · Limited investigation · Final report · Jul 23, 1984 · N5246Q · Substantial damage > The acft nosed down after a bounced landing. The student plt had 1 hour PIC total. She said the acft ballooned and bounced during landing. She said she should have added power during the ballooning to reflare or completed a go-around. - [NTSB NYC84LA249](https://openairdocs.org/ntsb/NYC84LA249.md): Cessna C172 · Sandy Lake, PA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N3275L · Substantial damage > The acft struck a ridge at the rwys approach end and collapsed the nose gear. The acft then slid 120 ft down the center of the rwy. The plt stated he made a normal apch for a short field landing but the acft touched down 10 ft short of the rwy. There were no… - [NTSB LAX84LA408](https://openairdocs.org/ntsb/LAX84LA408.md): Nesmith Cougar 1 · Williams, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1984 · N3456 · Substantial damage > While en route, the plt elected to land at the Williams muni arpt for a rest stop. He noted that rwy 2/20 was closed; however, he observed what appeared to be a new gravel strip, oriented north/south & an airplane on the arpt. The plt assumed the arpt was… - [NTSB FTW84LA322](https://openairdocs.org/ntsb/FTW84LA322.md): Cessna 152 · Friendswood, TX · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N64896 · Substantial damage > During a touch-&-go landing, the plt lost directional control of the acft after he applied power to takeoff again. The acft went off the left side of the rwy, hit a ditch & nosed over. - [NTSB CHI84LA307](https://openairdocs.org/ntsb/CHI84LA307.md): Boeing A75N1 · Huntley, IL · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N55070 · 2 aircraft · Substantial damage > The plts of a Boeing A75, N55070, & a vultee BT-13, N176VR, where in formation as they apchd their destination. When the saw the arpt, they separated for separate landings & lost sight of each other. Before landing, both plts flew over the arpt & noted the… - [NTSB CHI84LA305](https://openairdocs.org/ntsb/CHI84LA305.md): Beech B-35 · Harrison, MI · Accident · No injuries · Limited investigation · Final report · Jul 22, 1984 · N3297V · Substantial damage > The plt inadvertently landed the acft with the landing gear retracted. He said he forgot to lower the gear. Most of his 200+ hours of flight time had been in fixed gear acft. - [NTSB ATL84LA233](https://openairdocs.org/ntsb/ATL84LA233.md): Piper PA-28-180 · Morrison, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 1984 · N7912N · Substantial damage > The plt was giving free rides to his friends. He was attempting to land on rwy 27 when the 'aircraft lost lift at 15 feet above the rwy.' The acft dropped to the rwy in a three point attitude, the plt added power to regain control. The left wing tip and the… - [NTSB LAX84LA416](https://openairdocs.org/ntsb/LAX84LA416.md): Cessna 172E · Elk Grove, CA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1984 · N3587S · Substantial damage > The acft bounced several times during landing according to a plt witness near the rwy. During the bounces the acft left the rwy in a crosswind. The damage to the acft was estimated as minor up to this time. The plt of the accident acft decided to try to… - [NTSB FTW84LA316](https://openairdocs.org/ntsb/FTW84LA316.md): Bell 206L-1 · High Isl Blk298 · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1984 · N2133L · Substantial damage > The helicopter skid contacted a net fence around the landing platform on an oil rig. The safety net broke and the acft rocked over the side of the platform. The plt attempted to autorotate into the water. The landing was hard and one floatseparated. The… - [NTSB SEA84LA179](https://openairdocs.org/ntsb/SEA84LA179.md): Cessna 152II · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N48745 · Substantial damage > According to the CFI, when he & his student were on approach for landing on rwy 16R, he received a report of wind shear. The CFI stated that he was instructing his student in the 'wing down' method for x-wind landings & the acft touched-downon its right wheel… - [NTSB DEN84LA230](https://openairdocs.org/ntsb/DEN84LA230.md): Sikorsky S-55B · Richey, MT · Accident · No injuries · Limited investigation · Final report · Jul 20, 1984 · N24111 · Substantial damage > The pilot stated that he landed in a pasture where he intended to refuel. During the landing roll, one of the wheels dropped into a hole, causing the main rotor blade to flex downward and severe the tailboom. - [NTSB CHI84LA302](https://openairdocs.org/ntsb/CHI84LA302.md): Cessna 150M · Munising, MI · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1984 · N704MS · Substantial damage > The acft nosed over during landing on a solo instructional flt. The students instructor said the approach seemed normal. When the acft flared the nose struck the ground first. The student said he 'did not remember pushing the wheel forward but apparently I… - [NTSB ATL84LA224](https://openairdocs.org/ntsb/ATL84LA224.md): Beech 95-B55 · No.Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jul 19, 1984 · N4E · Substantial damage > When the plt extended the gear, the landing gear motor circuit breaker (c/b) popped. He reset the c/b & after a cool down period attempted to extend the gear again, but with the same results. The plt was not able to extend the gear fully down & locked with… - [NTSB ATL84LA223](https://openairdocs.org/ntsb/ATL84LA223.md): Beech 58 E · Sumter, SC · Accident · No injuries · Limited investigation · Final report · Jul 19, 1984 · N2851W · Substantial damage > After a long work day the pilot forgot to extend his landing gear at his destination airport and landed gear up. The pilot reported he has not slept well on the night before the accident and that his attention was diverted by another acft landing ahead of him. - [NTSB LAX84LA404](https://openairdocs.org/ntsb/LAX84LA404.md): Cessna 170B · Huntington Bch, CA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1984 · N8176A · Substantial damage > The acft departed the rwy to the left during landing. Upon contacting soft dirt the right main gear collapsed and separated from the acft. According to the plt the acft hit a rough spot and bounced. Other damages were done to the fuselage, the wings and the… - [NTSB ANC84LA117](https://openairdocs.org/ntsb/ANC84LA117.md): Cessna 180 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Jul 18, 1984 · N1695C · Substantial damage > The plt was making his fourth landing for a full stop in the tailwheel acft. After the tailwheel contacted the rwy, the upwind wing was raised by a crosswind. The other wing then dragged the surface & the acft partially ground looped & nosed over. - [NTSB LAX84LA398](https://openairdocs.org/ntsb/LAX84LA398.md): Howard DGA-15P · Tracy, CA · Accident · No injuries · Limited investigation · Final report · Jul 16, 1984 · N5553N · Destroyed > During the landing roll, the acft ran off the side of the rwy. The plt stated that he landed with a slight tailwind. - [NTSB FTW84LA311](https://openairdocs.org/ntsb/FTW84LA311.md): Cessna 175A · Daisetta, TX · Accident · No injuries · Limited investigation · Final report · Jul 16, 1984 · N6927E · Substantial damage > The student plt on a solo flt ran off the end of the rwy during landing. FAA said the plt had not received dual instruction recently enough to be legally qualified for this flt. A report of the accident was not filed by the student. - [NTSB CHI84LA299](https://openairdocs.org/ntsb/CHI84LA299.md): Cessna 172 · Alpena, MI · Accident · No injuries · Limited investigation · Final report · Jul 16, 1984 · N8684U · Substantial damage > The plt stated that while flaring for their 5th stop-&-go at night, a deer ran out onto the rwy. The acft collided with the deer & the left main landing gear was sheared off. The acft then veered off the rwy. - [NTSB MKC84LA216](https://openairdocs.org/ntsb/MKC84LA216.md): Adams AB · Ballwin, MO · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 1984 · N4004G · No damage > The plt reported that before landing, he rebriefed the passengers on the landing technique. He noted that a lady passenger seemed nervous about the landing. The plt landed in a pasture with an estimate 6 kt wind. Reportedly, the balloon made a soft touchdown,… - [NTSB LAX84LA427](https://openairdocs.org/ntsb/LAX84LA427.md): Cessna TU206C · Catalina, AZ · Accident · No injuries · Limited investigation · Final report · Jul 15, 1984 · N3971G · Substantial damage > The acft ran into ruts washed out by recent rains on a private arpt. The plt reported that he circled the arpt to look for hazards. He concluded that it was ok to land. After the accident he said that he should have called the arpt operator prior to flying… - [NTSB FTW84LA312](https://openairdocs.org/ntsb/FTW84LA312.md): Piper PA-28R-200 · Lake Charles, LA · Accident · No injuries · Limited investigation · Final report · Jul 15, 1984 · N1456X · Substantial damage > The plt landed on the edge of a 90 ft wide turf rwy which was soft due to recent rains. The acft drifted off into a ditch causing the collapse of the left main gear. - [NTSB MIA84FA203](https://openairdocs.org/ntsb/MIA84FA203.md): Lake LA-4-200 · Hollywood, FL · Accident · Serious injuries · Field investigation · Final report · Jul 14, 1984 · N8001E · Destroyed > After arriving at south Lake, the plt made a water landing on a westerly heading. He stated that he was attempting a step-landing & after touching down, the acft traveled about 100 ft, then the control yoke was jerked from his hands. He & the passengers… - [NTSB LAX84LA391](https://openairdocs.org/ntsb/LAX84LA391.md): Grumman AA-5A · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Jul 14, 1984 · N26938 · Substantial damage > The plt stated that he was high on final approach so he lowered the nose of the acft to lose altitude and in return got an increase in airspeed. He touched down 1/3 the way down the runway and the acft ballooned. He stated that he was unable to stop the acft… - [NTSB CHI84LA300](https://openairdocs.org/ntsb/CHI84LA300.md): Cessna 177 · Columbia, IL · Accident · No injuries · Limited investigation · Final report · Jul 14, 1984 · N29381 · Substantial damage > Pilot stated that she landed the aircraft approximately one third of the way down the runway. She continued to stated the acft ballooned so she decided to go-around, during which she retracted the flaps to 1/4. The pilot operating handbook states that the… - [NTSB ANC84LA115](https://openairdocs.org/ntsb/ANC84LA115.md): Cessna U-206 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Jul 14, 1984 · N3910G · Substantial damage > The acft nosed over during a landing on a sandy beach. Witnesses stated, according to the plt, that the nose wheel was cocked 45 degrees to the right while the acft was on the final approach. Upon touchdown the acft veered to the right, the nose gear… - [NTSB MIA84LA202](https://openairdocs.org/ntsb/MIA84LA202.md): Piper PA-18 · High Springs, FL · Accident · No injuries · Limited investigation · Final report · Jul 13, 1984 · N7776D · Substantial damage > The pilot stated that after recovering from a bounced landing, he started to lose directional control. He stated that he over compensated for the turn & added power to takeoff again. However, the acft veered left & subsequently nosed over. - [NTSB LAX84LA368](https://openairdocs.org/ntsb/LAX84LA368.md): Aeronca 7DC · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Jul 13, 1984 · N4460E · Substantial damage > The student pilot lost directional control during the landing roll. The instructor pilot was unable to regain control to prevent a ground loop. Subsequently, the acft veered off the rwy & was damaged on rough terrain. - [NTSB NYC84LA288](https://openairdocs.org/ntsb/NYC84LA288.md): Cessna 172PII · Madison, CT · Accident · No injuries · Limited investigation · Final report · Jul 12, 1984 · N54465 · Substantial damage > Plt stated groundspeed was fast during the flare and an abrupt touchdown was made 'fairly far' down the rwy. Plt reported, 'braking had not sufficiently slowed or stopped the plane as the plane neared the end of the runway, and it veered off to the right of… - [NTSB LAX84FA389](https://openairdocs.org/ntsb/LAX84FA389.md): Cessna 180 · Randsburg, CA · Accident · 4 fatal · Field investigation · Final report · Jul 12, 1984 · N4697B · Destroyed > Plt attempted to land on a 1200 ft long airstrip. He landed the acft with a tailwind and touched down aprx 600 ft from the apch end of the rwy. The acft skidded off the right side of the rwy and collided with a caterpillar tractor. The four occupants were… - [NTSB DEN84LA220](https://openairdocs.org/ntsb/DEN84LA220.md): Beech F33A · Glen Canyon, UT · Accident · No injuries · Limited investigation · Final report · Jul 12, 1984 · N333TR · Destroyed > According to the plt, a slightly higher than normal apch speed with partial flap extension was used for the apch due to the turbulance and wind gusts to 25 KTS. After crossing the threshold at 20 to 30 ft AGL the flare resulted in what the pilot described as… - [NTSB FTW84LA308](https://openairdocs.org/ntsb/FTW84LA308.md): Robinson R-22A · Henderson, TX · Accident · No injuries · Limited investigation · Final report · Jul 11, 1984 · N8518W · Substantial damage > The instructor plt stated that the student plt landed the helicopter. As the helicopter touched down and was still light on its skids the student applied left cyclic control and the helicopter started to roll towards the left. The student plt froze on the… - [NTSB DEN84LA218](https://openairdocs.org/ntsb/DEN84LA218.md): Piper PA-24-250 · Dickinson, ND · Accident · No injuries · Limited investigation · Final report · Jul 11, 1984 · N7099P · Substantial damage > The pilot stated that he received landing information for the Dickinson muni airport. He continued to state, 'set plane up for landing, checked plane over everything was set up, started to land, prop hit rwy, the next thing I was sliding down rwy.' The… - [NTSB ATL84LA220](https://openairdocs.org/ntsb/ATL84LA220.md): Snow 600-S2C · Lambert, MS · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 1984 · N64744 · Substantial damage > During the landing roll the tailwheel reportedly oscillated braking the shock strut lugs allowing the tail of the acft to contact the sod runway. The plt applied hard braking and the acft nosed over. The plt reported nothing was wrong with the tailwheel… - [NTSB ANC84LA114](https://openairdocs.org/ntsb/ANC84LA114.md): Cessna 185 · Bethel, AK · Accident · No injuries · Limited investigation · Final report · Jul 11, 1984 · N3263C · Substantial damage > The acft ran off the right side of the rwy after touchdown. The plt indicated that the right main tire blew out. He saidthat he was unable to keep the acft on the rwy and it nosed down into soft dirt. - [NTSB NYC84LA239](https://openairdocs.org/ntsb/NYC84LA239.md): Cessna 172N · Ocean City, NJ · Accident · No injuries · Limited investigation · Final report · Jul 10, 1984 · N733BN · Substantial damage > During landing in a x-wind the plt said the acft was pushed to the right side of the rwy by the shifting wind. The nose wheel was broken off and the right wing damaged. The plt reported that the wind shifted from the southwest to the southeast and was gusting… - [NTSB LAX84LA388](https://openairdocs.org/ntsb/LAX84LA388.md): Beech C-23 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Jul 10, 1984 · N1962L · Substantial damage > The student plt was on his 1st solo flt. He reported that the acft bounced during a landing, then 'started to head off to the left.' He reported that he 'came in with power & rudder' but the acft went off the rwy & hit a mound of dirt & a fence. - [NTSB CHI84LA285](https://openairdocs.org/ntsb/CHI84LA285.md): Cessna 170B · Edgerton, WI · Accident · No injuries · Limited investigation · Final report · Jul 10, 1984 · N2748C · Substantial damage > The plt stated he made a faster than normal approach & upon touchdown, the acft bounced back into the air. He added a little power to smooth out the landing, but when the acft touched down, the second time, it veered off the rwy, encountered a muddy corn… - [NTSB MKC84LA208](https://openairdocs.org/ntsb/MKC84LA208.md): Cessna 337G · Hickory Ridge, AR · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N72439 · Substantial damage > The plt was on a business trip to Hickory Ridge, AR. He stated that he landed at wynne, AR, but could not rent an auto to proceed to Hickory Ridge. The FBO stated that there was a 3200 ft crop dusting strip at Hickory Ridge, so the plt elected to fly there.… - [NTSB MKC84LA207](https://openairdocs.org/ntsb/MKC84LA207.md): Cessna 182P · East Lynne, MO · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N8148G · Substantial damage > During landing, plt stated, a gust of wind caught the acft resulting in a hard landing before a recovery could be initiated. The plt reported winds were variable at 20 KTS with gusts to 30 KTS. - [NTSB LAX84LA387](https://openairdocs.org/ntsb/LAX84LA387.md): Helio H-295 · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Jul 9, 1984 · N222LT · Substantial damage > As the tailwheel settled to the rwy the acft veered right and ground looped collapsing the left main ldg gear. The left main gear oleo strut failed due to tensile overload. - [NTSB SEA84LA188](https://openairdocs.org/ntsb/SEA84LA188.md): Cessna 182 · Craigmont, ID · Accident · No injuries · Limited investigation · Final report · Jul 8, 1984 · N9592T · Substantial damage > According to the plt, during landing the brakes failed and the acft came to a stop about 10 ft beyond the end of the rwy after rolling into a shallow ditch. Maint personnel examined the right wheel brake system and found no mechanical malfunction or leakage… - [NTSB MKC84LA203](https://openairdocs.org/ntsb/MKC84LA203.md): Cessna P210N · Topeka, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1984 · N5537W · Substantial damage > During flt, the plt decided to divert to Topeka, KS. While landing on rwy 13, the acft veered to the right. Subsequently, it went off the side of the rwy, encountered soft, muddy terrain & nosed over. The wind was from 210 degs at 14 gusting 22 KTS. - [NTSB LAX84LA385](https://openairdocs.org/ntsb/LAX84LA385.md): Cessna 500 · Gualala, CA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1984 · N555CC · Substantial damage > On an air taxi flt to a privately owned, public use arpt, the transport category acft touched down hard, 7 ft beyond the beginning of the 2500-FT-long rwy. The hard surfaced rwy's strength was inadequate to support the acft's 9500 lb ldg weight & the acft's… - [NTSB CHI84LA277](https://openairdocs.org/ntsb/CHI84LA277.md): Cessna 172N · Lansing, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1984 · N75915 · Substantial damage > The acft ran off the end of the rwy into a ditch during landing. The plt said that his landing speed was 'well above normal touchdown speed.' He had made one approach before the accident and went around because he was 'landing long.' There were no reported… - [NTSB SEA84LA167](https://openairdocs.org/ntsb/SEA84LA167.md): Cessna 172N · Roache Harbor, WA · Accident · No injuries · Limited investigation · Final report · Jul 7, 1984 · N8078E · Substantial damage > The acft bounced and drifted during a landing in a gusty x-wind. The plt tried applying power and reducing flaps but ended up off the rwy in a ditch and fence. His total time in this model acft was 3 hours. - [NTSB MKC84LA204](https://openairdocs.org/ntsb/MKC84LA204.md): Cessna 172M · Colt, AR · Accident · No injuries · Limited investigation · Final report · Jul 7, 1984 · N61625 · Substantial damage > The pilot stated that he made his final approach to the rwy at 70 mph and the aircraft floated when he flared for touchdown. He continued to state that after acft touched down, insufficient runway remained to stop before overrunning the runway and impacted a… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=441 ## 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=440 --- 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.