# 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 424 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB DEN85LTE05](https://openairdocs.org/ntsb/DEN85LTE05.md): Gordon Thorpe T-18 · Alamosa, CO · Accident · Minor injuries · Final report · Jul 26, 1985 · N633GG · Substantial damage > The plt of the amateur built acft was on a flt to ashkosh, WI with an en route stop at pueblo, CO. Due to wx in the pueblo area, he diverted to Alamosa, CO. On his 1st apch to land on rwy 20, he made a go-around. On his 2nd apch, the acft landed long & at… - [NTSB DEN85LTE04](https://openairdocs.org/ntsb/DEN85LTE04.md): Woolsey Quickie Q2 · Rawlins, WY · Accident · No injuries · Final report · Jul 25, 1985 · N66LW · Destroyed > After taking off, the plt noted that the acft's CG had shifted, & as fuel was consumed, the elevator down authority seem to decay. He suspected that baggage (stowed behind the plt's seat & inaccessible during flt) had shifted aft requiring greater than usual… - [NTSB CHI85LA375](https://openairdocs.org/ntsb/CHI85LA375.md): Cessna 172P II · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Jul 25, 1985 · N6508K · Substantial damage > The pilot was on a VFR VASI approach to the ATC controlled arpt 5091 ft runway. During ld round out the pilot said it feld like the acft was 'pushed' down onthe runway. The acft bounced and then ld on the nose wheel. The pilot said a helicopter was in a hover… - [NTSB CHI85LA313](https://openairdocs.org/ntsb/CHI85LA313.md): Luscombe 8A · Valparaiso, IN · Accident · No injuries · Limited investigation · Final report · Jul 25, 1985 · N2071K · Substantial damage > The acft nosed over during landing. The plt said that he made a wheel lndg and after the acft slowed to 20 mph the tail lifted and the acft nosed over. - [NTSB NYC85LA192](https://openairdocs.org/ntsb/NYC85LA192.md): Cessna P206D · Limerick, ME · Accident · No injuries · Limited investigation · Final report · Jul 23, 1985 · N8789Z · Substantial damage > During the short field approach, as the aircraft passed over the tree line, the sink rate suddenly increased. The pilot applied power and increased the pitch but the aircraft touching down hard and bounced. A second touch down was made and as the nosewheel… - [NTSB DEN85LA204](https://openairdocs.org/ntsb/DEN85LA204.md): Bellanca 14-19-3 · Logan, NM · Accident · No injuries · Limited investigation · Final report · Jul 23, 1985 · N7685B · Substantial damage > The plt lost directional control while landing on a gravel road. Subsequently, the acft was damaged when it veered to the right & went into a ditch. - [NTSB BFO85LA060](https://openairdocs.org/ntsb/BFO85LA060.md): Cessna 152 · Charlottesville, VA · Accident · No injuries · Limited investigation · Final report · Jul 23, 1985 · N89432 · Substantial damage > The student plt entered a left base for rwy 03, and according to a witness, made a hard landing on the main gear. After touchdown, the nose gear collapsed and the acft slid approximately 80 feet down the rwy. - [NTSB LAX85LA327](https://openairdocs.org/ntsb/LAX85LA327.md): Piper PA-34-200T · Avalon, CA · Accident · No injuries · Limited investigation · Final report · Jul 22, 1985 · N2193Z · Substantial damage > The plt and a gnd witness reptd the acft touched down, main wheel first, in a smooth, soft manner. Upon touch down the nose gear collapsed. The acft slid for 200 ft before coming to rest. Examination of the nose gear assembly disclosed the gear actuator rod… - [NTSB DEN85LA193](https://openairdocs.org/ntsb/DEN85LA193.md): Cessna 182P · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Jul 22, 1985 · N6375F · Substantial damage > The pilot lost directional control during the touchdown phase of landing. The aircraft was substantially damaged when it veered off the runway and nosed over in the soft dirt. - [NTSB SEA85LA175](https://openairdocs.org/ntsb/SEA85LA175.md): Cessna 150C · Chesaw, WA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1985 · N1935Z · Substantial damage > The student plt landed on an unnamed, 1200 ft landing strip in calm wind conditions. He stated that during the landing, he misjudged the distance & overran the rwy. After departing the rwy, the acft encountered terrain with a tree root system & nosed over. - [NTSB NYC85LA187](https://openairdocs.org/ntsb/NYC85LA187.md): Cessna 152 · Marlboro, NJ · Accident · No injuries · Limited investigation · Final report · Jul 21, 1985 · N11BZ · Destroyed > According to the pilot, the aircraft floated during the flare to touchdown. The pilot applied power for a go around, but the aircraft did not clear some bushes at the end of the runway. The aircraft landed straight ahead in a field and rolled about 300 feet… - [NTSB DEN85LA194](https://openairdocs.org/ntsb/DEN85LA194.md): Cessna 170B · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Jul 21, 1985 · N5414C · Substantial damage > The plt was returning from a local pleasure flt, it was a hot day. The plt said that he inadvertently leveled the acft aprx 10 ft high. He said the acft stalled causing a hard landing. The impact caused substantial damage to the acft. - [NTSB ATL85LA222](https://openairdocs.org/ntsb/ATL85LA222.md): Burkhart Grob G-109B · Williamson, GA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1985 · N5829T · Substantial damage > The plt of the powered glider reported that during an apch to land, the acft encountered a downdraft & landed hard. The landing gear was damaged as well as the prop, eng cowling & oil cooler. - [NTSB NYC85LA190](https://openairdocs.org/ntsb/NYC85LA190.md): New Standard D-25 · Rhinebeck, NY · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N176H · Substantial damage > The acft was moving at about 30 mph when the gear collapsed. According to the plt, the landing gear leg fitting failed causing the gear to collapse. - [NTSB LAX85LA334](https://openairdocs.org/ntsb/LAX85LA334.md): Mooney M20A · Compton, CA · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N8141E · Substantial damage > The student plt had a total of 36 flight hrs which included 9.4 hrs in the monney acft. He had been authorized by his CFI, who flew with him the preceding day, to practice landing. On the student's first attempted ldg, he touched down hard & began porpoising.… - [NTSB FTW85LA292](https://openairdocs.org/ntsb/FTW85LA292.md): Champion 7KCAB · Chattanooga, OK · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N1642G · Substantial damage > The plt lost directional control while landing in a crosswind and the acft ground looped after the left main landing gear contacted soft terrain alongside of the runway. The nearest official aviation weather reporting station was at lawton, OK, located 16… - [NTSB CHI85LA303](https://openairdocs.org/ntsb/CHI85LA303.md): Bell 206BII · Farmington, MN · Accident · No injuries · Limited investigation · Final report · Jul 20, 1985 · N49737 · Substantial damage > During maneuvering to ld in an uncultivated fld the tail rotor struck a fence post,from a dismantled fence,that was concealed by high weeds. One tail rotor blade was separated,the pilot lost control,and on touchdown the helicopter rolled over. - [NTSB SEA85LA174](https://openairdocs.org/ntsb/SEA85LA174.md): Bell 47G-3B-1 · Lebanon, OR · Accident · No injuries · Limited investigation · Final report · Jul 19, 1985 · N9417A · Substantial damage > The plt stated he performed 4 circling approaches over a sand bar and on the 5th approcah, rotor RPM decayed. Unable to regain the RPM, a hard landing resulted during which the main rotor blades severed the tailrotor. - [NTSB SEA85LA173](https://openairdocs.org/ntsb/SEA85LA173.md): Cessna 180G · Battle Mountain, NV · Accident · No injuries · Limited investigation · Final report · Jul 19, 1985 · N5252D · Substantial damage > While landing at Battle Mountain to refuel, the left main gear collapsed. The wind was reported to be from 360 deg a 18 gusting 30 KTS. - [NTSB DEN85LA191](https://openairdocs.org/ntsb/DEN85LA191.md): Cessna 172 · Sykeston, ND · Accident · No injuries · Limited investigation · Final report · Jul 19, 1985 · N739GA · Substantial damage > The plt said he made a normal landing on an aerial application airstrip. During the rollout the plt spotted an unmarked mail box. The plt said he swerved to avoid colliding with the mail box. The acft went off the side of the strip and into a field. The plt… - [NTSB BFO85LA059](https://openairdocs.org/ntsb/BFO85LA059.md): Cessna 182RG · Stevensville, MD · Accident · No injuries · Limited investigation · Final report · Jul 19, 1985 · N737XD · Substantial damage > After landing to the left of the centerline of rwy 10, the acft veered left off the rwy and collided with a drainage ditch located approximately 10 yards from the rwy. Following contract with the ditch, at approximately 15 mph, the acft flipped over, coming… - [NTSB NYC85LA182](https://openairdocs.org/ntsb/NYC85LA182.md): Piper PA-16 · Livingston, NY · Accident · No injuries · Limited investigation · Final report · Jul 18, 1985 · N5739H · Substantial damage > The acft departed the right side of the rwy where it collided with a corn crop during a landing roll. The acft owner, a pvt plt, stated a mechanic on board was flying at the time of the accident. The mechanic stated that the owner was at the controls when the… - [NTSB NYC85LA180](https://openairdocs.org/ntsb/NYC85LA180.md): Piper PA-28-140 · Bedminster, NJ · Accident · No injuries · Limited investigation · Final report · Jul 18, 1985 · N6139J · 2 aircraft · Substantial damage > N4319F heard NG138J announce its position in the traffic pattern throughout the approach and landing. N4319F landed on runway 30 and was taxiing back to the ramp on the parallel taxiway. The occupant of N4319F observed N6139J land about midway down the runway… - [NTSB MKC85LA161](https://openairdocs.org/ntsb/MKC85LA161.md): Cessna 180G · Harrison, AR · Accident · No injuries · Limited investigation · Final report · Jul 18, 1985 · N4734U · Substantial damage > The plt stated that during a wheel landing, the acft bounced, but not hard. He reported that he applied sufficient power to recover & made a smooth, 3-point touchdown, then the acft began a gradual skidding turn to the right. The plt corrected with left… - [NTSB SEA85LA169](https://openairdocs.org/ntsb/SEA85LA169.md): Cessna 185F · Boise, ID · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N4309R · Substantial damage > The acft ground looped and the left main gear collapsed during a landing roll. The plt reported that the left wing came up during the landing roll which resulted in the acft veering to the right. When the wing settled, the left main gear collapsed allowing… - [NTSB NYC85LA175](https://openairdocs.org/ntsb/NYC85LA175.md): Grumman AA-1C · Farmingdale, NY · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N333FY · Substantial damage > The plt was performing a series of touch and go landings at republic arpt when the accident occurred. During the final landing, a hard touch down was made which resulted in a porpoised landing. - [NTSB NYC85FNC05](https://openairdocs.org/ntsb/NYC85FNC05.md): Barnes AX7 · Gorham, ME · Accident · Serious injuries · Final report · Jul 17, 1985 · N15314 · No damage > The pilot took off with three passengers in a hot air balloon. There was an unforecast wind change with an increase in velocity. This change in wind direction and velocity precluded the ability to make a landing and keep the basket upright. When the basket… - [NTSB MKC85LA160](https://openairdocs.org/ntsb/MKC85LA160.md): Cessna 180J · Fort Dodge, IA · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N180DH · Substantial damage > N180DH was landing on a 6,547 x 150 ft, dry, asphalt, runway with a lt quartering headwind at 15, with gust to 20 KTS. The plt said he made a full flap, full stall, 3PT, landing. The acft was aligned with the rwy centerline but after a short roll the acft… - [NTSB DEN85LA192](https://openairdocs.org/ntsb/DEN85LA192.md): Cessna 170B · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N8252A · Substantial damage > The pilot stated that he did not use proper technique and did not maintain directional control while landing in a brisk and direct crosswind. The airplane was substantially damaged in the hard landing that was followed by a ground loop. - [NTSB ATL85LA218](https://openairdocs.org/ntsb/ATL85LA218.md): Cessna 177 · Stanton, KY · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N3150T · Substantial damage > The pilot reported that during takeoff, he believed that the flight controls were not responding to control inputs. Moments after lift-off, he aborted the takeoff. The airplane continued off the departure end of the runway, where the nose gear and engine… - [NTSB SEA85LA172](https://openairdocs.org/ntsb/SEA85LA172.md): Bellanca 7GCBC · Moses Lake, WA · Accident · No injuries · Limited investigation · Final report · Jul 16, 1985 · N36137 · Substantial damage > A ground loop occurred during landing roll on rwy 36. The wind at touchdown was from 210 degs at 5 KTS. The twr did give the plt the current wind when the controller cleared him to land. The plt was aware that he would be landing with a left quartering tail… - [NTSB NYC85LA176](https://openairdocs.org/ntsb/NYC85LA176.md): Piper PA-22-108 · Hookstown, PA · Accident · No injuries · Limited investigation · Final report · Jul 16, 1985 · N5322Z · Substantial damage > The instructor and student were practicing normal takeoffs and landings. According to the pilot, on the sixth landing, at the correct airspeed, the aircraft touched down on the main gear and then the noise wheel collapsed. The aircraft then nosed over.… - [NTSB MIA85IA211](https://openairdocs.org/ntsb/MIA85IA211.md): Cessna R182 · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Jul 15, 1985 · N6289T · Minor damage > The plt stated that he made a normal touchdown & on his landing rollout the nose gear collapsed. The landing gear was cycled several times after this occurrence & no abnormality was observed. No determination could be made of the malfunction of the landing… - [NTSB NYC85LA170](https://openairdocs.org/ntsb/NYC85LA170.md): Piper PA-32R-301T · Provincetown, MA · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N8210H · Substantial damage > During arrival, the acft was vectored for an ILS rwy 7 apch which was made with a tail wind. On his 1st attempt, the plt made a missed apch & was vectored for another ILS. After making a 2nd apch, he landed. The plt stated that while he was landing, he… - [NTSB NYC85FA166](https://openairdocs.org/ntsb/NYC85FA166.md): Piper PA-24-250 · Tioga, PA · Accident · 2 fatal · Field investigation · Final report · Jul 14, 1985 · N7934P · Destroyed > The plt initiated a downwind landing on a grass rwy that sloped mostly uphill, but began sloping downhill at its departure end. A witness near the apch end of the 2150 ft rwy watched the acft touch down beyond its midpoint, then disappear over its crested… - [NTSB LAX85LA317](https://openairdocs.org/ntsb/LAX85LA317.md): Robinson R-22A · Piru, CA · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N85594 · Substantial damage > The flight instructor instructed the 25-hour student plt to perform an autorotation with a pwr recovery at 20 ft AGL. The instructor became aware too late that the student was 'dead locked' on the controls and he was unable to recover prior to touchdown. A… - [NTSB CHI85LA286](https://openairdocs.org/ntsb/CHI85LA286.md): Piper PA-32R-300 · Appleton, WI · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N4137F · Substantial damage > As the plt applied brakes during a full stop landing, the right brake failed. The plt then maneuvered the acft off the paved landing surface in an attempt to get it to roll to a stop. The right landing gear strut collapsed. The acft then slid into a fence and… - [NTSB ATL85LA212](https://openairdocs.org/ntsb/ATL85LA212.md): Cessna 182C · Lugoff, SC · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N8472T · Substantial damage > The plt transported a load of skydivers to alt & was returning to the airstrip. During arrival, he decided to practice a simulated eng out landing. While on an apch with full flaps, the plt elected to slip the acft. As he was transitioning from a side slip to… - [NTSB ATL85LA211](https://openairdocs.org/ntsb/ATL85LA211.md): Cessna 172 M · Statesville, NC · Accident · No injuries · Limited investigation · Final report · Jul 14, 1985 · N12334 · Substantial damage > While en route, the plt encountered reduced visibility & had difficulty finding the airstrip. His 1st apch to land was high & he made a go-around. The plt landed on his 2nd attempt, but was unable to stop on the wet grass rwy. He delayed attempting a… - [NTSB NYC85LA167](https://openairdocs.org/ntsb/NYC85LA167.md): Piper PA28-151 · Chatham, MA · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1985 · N5405F · Substantial damage > During the final approach to runway 24, the aircraft was too high and fast. The pilot decided to land on the runway instead of going around. According to the pilot, the aircraft landed too FAR down the runway and went over the end. - [NTSB CHI85LA287](https://openairdocs.org/ntsb/CHI85LA287.md): Piper PA-28-181 · Stoughton, WI · Accident · No injuries · Limited investigation · Final report · Jul 13, 1985 · N47677 · Substantial damage > Upon landing following a normal 70 knot final approach the aircraft initially touched down one-third of the way down the 2500 ft grass runway. A bounce carried the aircraft to a point halfway down the runway where the aircraft landed in a full stall. The… - [NTSB ATL85LA215](https://openairdocs.org/ntsb/ATL85LA215.md): Beech 95-B55 · Owensboro, KY · Accident · No injuries · Limited investigation · Final report · Jul 13, 1985 · N3001S · Substantial damage > The plt had a single eng land rating & was preparing for a multi-eng check ride. While practicing a touch-&-go landing, the acft bounced. The plt applied power, made a go-around & landed without further incident. However, during a post-flt exam, substantial… - [NTSB ANC85LA131](https://openairdocs.org/ntsb/ANC85LA131.md): Cessna 180 · Barrow, AK · Accident · No injuries · Limited investigation · Final report · Jul 13, 1985 · N9164T · Substantial damage > The plt reported that when he returned to the arpt, he made a 3-point landing in gusty x-wind conditions. Reportedly, the acft then ground looped & was damaged. At 1534 adt, the wind at Barrow was from 050 deg at 13 gusting 18 KTS. - [NTSB FTW85FA283](https://openairdocs.org/ntsb/FTW85FA283.md): Gates Learjet 35A · Fort Worth, TX · Accident · No injuries · Field investigation · Final report · Jul 12, 1985 · N613RR · Substantial damage > This acft ran off the departure end of the 4001' runway following a normal approach, touchdown and initial braking. After about 1000' of norm braking, the acft began a drift to the right which was partially overcome by full left rudder and asymmetrical… - [NTSB SEA85LA161](https://openairdocs.org/ntsb/SEA85LA161.md): Mooney M20-F · Salem, OR · Accident · No injuries · Limited investigation · Final report · Jul 11, 1985 · N6879V · Substantial damage > The acft was substantially damaged during an inadvertant gear-up landing. Inspection of the acft revealed the landing gear circuit breaker was popped. When functionally tested, the landing gear operated normally. The gear warning horn was found to be… - [NTSB NYC85LA165](https://openairdocs.org/ntsb/NYC85LA165.md): Beech C23 · Penn Yan, NY · Accident · No injuries · Limited investigation · Final report · Jul 11, 1985 · N6704L · Substantial damage > The plt was familiar with the arpt, during the landing the plt observed the wind sock indicating calm winds and the acft was landed into the sun. During the landing roll, pwr was added for takeoff. When the acft was aprx 2/3 the way down the rwy, the plt… - [NTSB NYC85LA164](https://openairdocs.org/ntsb/NYC85LA164.md): Cessna 182M · Block Island, RI · Accident · No injuries · Limited investigation · Final report · Jul 11, 1985 · N71359 · Substantial damage > The plt was checked out in the C-182 on July 9, 1985 and had flown this acft for 1 hr in the previous year. During a normal power off landing with ten degrees of flaps extended, the plt added power and noticed no change in performance. The acft touched down… - [NTSB NYC85FA163](https://openairdocs.org/ntsb/NYC85FA163.md): Mitsubishi MU-2B-26 · Southbridge, MA · Accident · No injuries · Field investigation · Final report · Jul 11, 1985 · N727MA · Destroyed > During lndg the acft impacted hard and skidded down the rwy before it went off the left side of the rwy. The left main wheel separted and the nose gear collapsed. Both plts stated the lndg apch was normal until the acft was aprx 15 ftabove the rwy at which… - [NTSB MKC85LA153](https://openairdocs.org/ntsb/MKC85LA153.md): Cessna 172M · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jul 11, 1985 · N13064 · Substantial damage > Plt stated that she used left aileron and right rudder for x-wind correction and did not release the rudder pressure on touchdown. The acft went off side of rwy, crossed a taxiway, went down an embankment and through a fence into a plowed field where it nosed… - [NTSB FTW85LA284](https://openairdocs.org/ntsb/FTW85LA284.md): Grumman AA5B · Sonora, TX · Accident · No injuries · Limited investigation · Final report · Jul 11, 1985 · N4520B · Substantial damage > While landing at an unfamiliar strip, the plt observed a rough surface at the apch end, and landed one halfway down the down-sloping 2300 ft rwy. He tried to go around, but could not accelerate enough, and the acft rolled thru 2 fences, trees, then stopped… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=425 ## 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=424 --- 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.