# NTSB investigations: Maneuvering

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 182 of 378 · 18,851 cases

## Cases, newest first

- [NTSB DEN88LA161](https://openairdocs.org/ntsb/DEN88LA161.md): Piper PA-36-285 · Buchanan, ND · Accident · No injuries · Limited investigation · Final report · Jul 18, 1988 · N9990P · Substantial damage
  > The plt said he made several swath runs passing under a transmission line and over a power line that crossed the end of the fld being sprayed. He said as he passed under the transmission line during a run the vert stab collided with the line and was damaged.…
- [NTSB CHI88DEV02](https://openairdocs.org/ntsb/CHI88DEV02.md): Grumman G-164A · Cape Girardeau, IL · Accident · No injuries · Final report · Jul 18, 1988 · N677U · Substantial damage
  > The plt was applying chemicals to a field with 3 radio transmission towers along one side. He rprtd that as he was finishing the field, he circled one of the towers, them made a final swath run across the end of the field. He stated that as he pulled up from…
- [NTSB LAX88LA260](https://openairdocs.org/ntsb/LAX88LA260.md): Piper PA-28-140 · Agua Dulce, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1988 · N33043 · Substantial damage
  > The pilot attempted a takeoff from a 2,900 ft MSL elevation airport when the observed unofficial outside air temperature was a reported 105 degrees fahrenheit. Although no exact pressure altitude was available an approximate density altitude of 6,300 was…
- [NTSB FTW88DRD14](https://openairdocs.org/ntsb/FTW88DRD14.md): Grumman G-164A · Crowley, LA · Accident · Serious injuries · Final report · Jul 16, 1988 · N8580H · Destroyed
  > The agricultural pilot was working in a field which had telephone lines at one end and power lines at the other. On his last run, as he started his pull up, the airplane struck the power lines at one end of the field. The airplane went through the power…
- [NTSB MKC88LA126](https://openairdocs.org/ntsb/MKC88LA126.md): Rockwell S2R · England, AR · Accident · No injuries · Limited investigation · Final report · Jul 15, 1988 · N4186X · Substantial damage
  > The plt said he had been flying under power lines during an aerial application operation, and while performing his downwind pass, an updraft caused him to collide with the bottom wires. He lost control of the aircraft and collided with the terrain.
- [NTSB FTW88LA134](https://openairdocs.org/ntsb/FTW88LA134.md): Bell 47G2 · Port O'Connor, TX · Accident · No injuries · Limited investigation · Final report · Jul 15, 1988 · N47WJ · Substantial damage
  > The pilot stated that he turned downwind during hover practice, allowed the main rotor RPM to decrease, and settled with power to a hard landing. The front portion of the skids impacted first and the main rotor blades struck the tail boom. The pilot was not…
- [NTSB ATL88DKG10](https://openairdocs.org/ntsb/ATL88DKG10.md): Cessna 188 · Douglas, GA · Accident · No injuries · Final report · Jul 15, 1988 · N91217 · Substantial damage
- [NTSB FTW88DRD13](https://openairdocs.org/ntsb/FTW88DRD13.md): Grumman G-164A · Kinder, LA · Accident · Serious injuries · Final report · Jul 14, 1988 · N8512H · Minor damage
  > The pilot was spraying a fungicide on the field and the owner of the field was flagging for him, on the top of a dike, on the west end of the field. During normal operation, the flagman stayed in position until the airplane was 300 feet away, at which time he…
- [NTSB SEA88LA129](https://openairdocs.org/ntsb/SEA88LA129.md): Aerospatiale SA315B · Oakridge, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1988 · N3128G · Destroyed
  > While slinging a log the pilot allowed the log/sling line to contact a tree. The momentum of the log and helicopter bowed the tree over when the line contacted it. The pilot chose to release the log from the sling line rather than disengage the entire line…
- [NTSB LAX88FA254](https://openairdocs.org/ntsb/LAX88FA254.md): Sikorsky S-58BT · Marina Del Rey, CA · Accident · Serious injuries · Field investigation · Final report · Jul 13, 1988 · N94AH · Substantial damage
  > Mismanagement of the fuel system by the pilot which resulted in fuel starvation and a duel engine flameout. Contributing to the accident was the pilot's lack of total experience in the Sikorsky S58T.
- [NTSB DEN88FA212](https://openairdocs.org/ntsb/DEN88FA212.md): Piper PA-22-150 · Kanosh, UT · Accident · 2 fatal · Field investigation · Final report · Jul 13, 1988 · N3541Z · Destroyed
  > Plt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…
- [NTSB SEA88LA128](https://openairdocs.org/ntsb/SEA88LA128.md): Schempp-Hirth Discus B · Minden, NV · Accident · No injuries · Limited investigation · Final report · Jul 12, 1988 · N554T · 2 aircraft · Destroyed
  > Acft were ascending in the same thermal during national soaring competition and collided in flight. N554T sustained loss of the horizontal tail in collision, followed by loss of control in flight. The pilot parachuted safely. N130JB sustained minor damage and…
- [NTSB ATL88FA213](https://openairdocs.org/ntsb/ATL88FA213.md): Bell TH-1L · Walterboro, SC · Accident · Serious injuries · Field investigation · Final report · Jul 12, 1988 · N465JR · Substantial damage
  > The military surplus helicopter experienced a 42 degree gear box failure while lifting a load of logs. The helicopter subsequently landed hard as the plt was attempting to autorotate to a ldg. Metallurgical examination of the gearbox revealed that a gear…
- [NTSB FTW88DRD12](https://openairdocs.org/ntsb/FTW88DRD12.md): Texas Helicopter M74C · Rayville, LA · Accident · No injuries · Final report · Jul 11, 1988 · N47345 · Destroyed
  > The commercial pilot was spraying his cotton field with his own helicopter. The acft hit a tree during a right turning pull-up. The tail rotor blades were severed first then, during an uncontrolled right turn, the tailboom hit another tree. The main rotor…
- [NTSB CHI88DEX08](https://openairdocs.org/ntsb/CHI88DEX08.md): Continental Copters Tomcat MK-6 · Straughn, IN · Accident · No injuries · Final report · Jul 11, 1988 · N9093T · Substantial damage
  > Aerial application helicopter struck power lines in field on first swath run. This was the first time the pilot had sprayed this field. Prior to spraying the field he questioned the farmer regarding power lines or other obstructions. The farmer replied that…
- [NTSB CHI88DEC05](https://openairdocs.org/ntsb/CHI88DEC05.md): Bell 47D1 (OH-13E) · Stockbridge, MI · Accident · No injuries · Final report · Jul 11, 1988 · N12087 · Substantial damage
  > The plt was spraying an onion field when he noted a vibration, followed by a loud noise & severe shaking of the helicopter. He attempted a forced landing, but the helicopter was unresponsive to cyclic & collective inputs. Subsequently, the right skid dug into…
- [NTSB FTW88FA132](https://openairdocs.org/ntsb/FTW88FA132.md): Piper PA-38-112 · Electra, TX · Accident · 2 fatal · Field investigation · Final report · Jul 10, 1988 · N2459K · Destroyed
  > The private pilot's logbook indicated he had a checkout on steep turns and spins two months prior to the accident. He also logged four landings during the same one-half hour flight. A witness saw the airplane complete a three turn spin and saw it start to…
- [NTSB DEN88FA151](https://openairdocs.org/ntsb/DEN88FA151.md): Aerospatiale SA-315B · Dubois, WY · Accident · Serious injuries · Field investigation · Final report · Jul 10, 1988 · N47274 · Substantial damage
- [NTSB ATL88DKG09](https://openairdocs.org/ntsb/ATL88DKG09.md): Cessna 188 · Garfield, GA · Accident · 1 fatal · Final report · Jul 10, 1988 · N3525Q · Destroyed
  > Following minor engine maintenance, the plt/mechanic made the test flight. The engine cowling was not installed prior to the flt. Witnesses reported that the acft wheels touched the water of a nearby pond followed by a sharp pull-up into the plt's customary…
- [NTSB LAX88DUM04](https://openairdocs.org/ntsb/LAX88DUM04.md): Hiller UH-12D · Winterhaven, CA · Accident · Minor injuries · Final report · Jul 9, 1988 · N646JS · Destroyed
- [NTSB MKC88LA129](https://openairdocs.org/ntsb/MKC88LA129.md): Grumman G-164 · Baker, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1988 · N6848K · Substantial damage
  > Witnesses said that shortly after takeoff, the fully loaded acft appeared to be unable to climb out of ground effect. About 1.5 mile from the airstrip, the pilot began a turn back to the north. Unable to climb, he initiated action to dump his chemical load,…
- [NTSB CHI88LA155](https://openairdocs.org/ntsb/CHI88LA155.md): Aeronca 7AC · Hillsboro, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1988 · N2200E · Substantial damage
  > After making a low pass down a private strip, the aircraft experienced a wire strike followed by an uncontrolled descent into the ground. The pilot stated that his attention was diverted by the owner of the strip.
- [NTSB SEA88LA123](https://openairdocs.org/ntsb/SEA88LA123.md): Kaman HH43 · Joseph, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1988 · N55714 · Destroyed
  > The pilot was making the initial long line external load hookup of the day for the purpose of conducting logging operations. The pilot stated that as he maneuvered the aircraft into position the helicopter's main rotor system contacted a tall tree.
- [NTSB MIA88LA212](https://openairdocs.org/ntsb/MIA88LA212.md): Bell 47D1 · Ruleville, MS · Accident · No injuries · Limited investigation · Final report · Jul 4, 1988 · N903B · Substantial damage
  > During an aerial application flt while spraying chemicals the plt reported that the engine quit. The pilot attempted an autorotation but was too low and slow to complete it. The aircraft landed hard in the field of crops and nosed over. Examination of the…
- [NTSB MIA88FA213](https://openairdocs.org/ntsb/MIA88FA213.md): Franklin Drifter XP-503 · Lake Wales, FL · Accident · 2 fatal · Field investigation · Final report · Jul 4, 1988 · N65DF · Destroyed
  > The owner rprtd the plt flew the acft at a company picnic without authorization. Company psnl saw the experimental, amateur built acft takeoff from the company strip, then maneuver for a low pass over the area at about 150 to 200 ft AGL. Some estimated the…
- [NTSB CHI88FA147](https://openairdocs.org/ntsb/CHI88FA147.md): Cessna 150G · Plymouth, OH · Accident · 1 fatal · Field investigation · Final report · Jul 4, 1988 · N2865S · Destroyed
- [NTSB ANC88FA083](https://openairdocs.org/ntsb/ANC88FA083.md): Cessna 185 · Whittier, AK · Accident · 4 fatal · Field investigation · Final report · Jul 4, 1988 · N185BT · Substantial damage
  > The flight departed six mile lake on elmendorf air force base and was destined for coghill lake. The airplane was found at the 2500 foot level of a mountain on the north side of burns glacier. The airplane heading was 324 degrees. The heading to go through…
- [NTSB ANC88DAG05](https://openairdocs.org/ntsb/ANC88DAG05.md): Piper PA-18A · Mcgrath, AK · Accident · 2 fatal · Final report · Jul 4, 1988 · N1556P · Substantial damage
  > The airplane crashed approximately 94 miles east of the city of Mcgrath, Alaska. The pilot and passenger were fatally injured and the Piper PA-18 airplane was substantially damaged. The airplane impacted ground in a near vertical attitude near the end of a…
- [NTSB NYC88DHM01](https://openairdocs.org/ntsb/NYC88DHM01.md): Rutgers Agriplane · Freehold, NJ · Accident · Serious injuries · Final report · Jul 3, 1988 · N54472 · Substantial damage
  > The plt was working for a firm that was developing the experimental, light weight, crop duster in a joint venture with another firm. An acdnt occurred as he was operating the acft at the location of one of the firms. The plt stated that after takeoff, 'I was…
- [NTSB ANC88LA081](https://openairdocs.org/ntsb/ANC88LA081.md): Cessna 206 · Naknek, AK · Accident · 1 fatal · Limited investigation · Final report · Jul 3, 1988 · N5045U · Destroyed
  > The pilot was hauling fish from remote beach sites in Alaska to a nearby gravel airstrip. Witnesses reported seeing the airplane make two approaches to the field in weather estimated as visibility 1/2 mile in fog, and a ceiling of 100-200 feet. After the two…
- [NTSB NYC88LA177](https://openairdocs.org/ntsb/NYC88LA177.md): Bellanca 7GCBC · Laconia, NH · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1988 · N5041J · Substantial damage
  > The plt stated that after pickup on a banner tow operation, the tow became twisted and he elected to return and release. On downwind, the acft began a rapid descent which the plt could not compensate for, even after releasing the banner and adding power.…
- [NTSB MKC88FA120](https://openairdocs.org/ntsb/MKC88FA120.md): Piper PA-28-160 · Beedeville, AR · Accident · 1 fatal · Field investigation · Final report · Jul 2, 1988 · N5517W · Substantial damage
  > Intentional buzzing performed, visual outlook not maintained and over confidence in personal ability by the pilot in command.
- [NTSB LAX88LA247](https://openairdocs.org/ntsb/LAX88LA247.md): Schweizer SGS-1-26A · Montague, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 1988 · N2726Z · Destroyed
  > During a pleasure flight, the last transmission by the pilot stated he was going to see what the glider could do besides straight and level flight. Witnesses in the area reported that they heard a loud pop and observed the glider, minus the left wing, in a…
- [NTSB LAX88FA240](https://openairdocs.org/ntsb/LAX88FA240.md): Cessna 172P · Descanso, CA · Accident · 1 fatal · Field investigation · Final report · Jun 30, 1988 · N51234 · Destroyed
  > Pilot's poor judgment and intentional decision to low fly the aircraft below the minimum safe altitude.
- [NTSB SEA88FA120](https://openairdocs.org/ntsb/SEA88FA120.md): Cessna 150F · Skykomish, WA · Accident · 2 fatal · Field investigation · Final report · Jun 29, 1988 · N2RE · Destroyed
  > The noninstrument rated pilot was attempting to follow us highway 2 westbound across the cascades mountains. According to several witnesses upon cresting the stevens pass area at an altitude of 4300 feet MSL (approximately 250 feet AGL) he encountered low…
- [NTSB LAX88DXQ02](https://openairdocs.org/ntsb/LAX88DXQ02.md): Baron Minicoupe · Truckee, CA · Accident · 1 fatal · Final report · Jun 29, 1988 · N8534A · Destroyed
  > It was reported that the purpose of the flight was to buzz friends of the pilot who were windsurfing on sailboards. The airplane was seen maneuvering erratically at a very low altitude over the boca reservoir. Witnesses said the airplane did several steep…
- [NTSB ANC88LA073](https://openairdocs.org/ntsb/ANC88LA073.md): Cessna 172 · Kenai, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1988 · N65928 · Substantial damage
  > The pilot stated that he was in a 180 degree turn when he encountered IMC conditions. The flight path had placed the pilot in a valley with cloud shrouded hills to the sides. The aircraft struck the side of a hill at 1780 MSL.
- [NTSB NYC88DFJ02](https://openairdocs.org/ntsb/NYC88DFJ02.md): Hiller UH-12E · Cherry Creek, NY · Accident · Minor injuries · Final report · Jun 27, 1988 · N157HA · Substantial damage
  > The pilot reported that during an aerial application operation, he heard a noise that was followed by a decay in rotor RPM. Subsequently, he was forced to land in an area of tall trees & the helicopter was damaged. An investigationrevealed that a connecting…
- [NTSB DEN88LA139](https://openairdocs.org/ntsb/DEN88LA139.md): Piper PA-25-235 · Conrad, MT · Accident · No injuries · Limited investigation · Final report · Jun 27, 1988 · N9856P · Substantial damage
  > The plt reported that he was making a lt turnaround to begin a swath run. He said the acft slowed while in a steep lt bank at the highest part of the turn and he was unable to raise the lt wing as the acft approached the ground. The lt wing and main landing…
- [NTSB MIA88FA206](https://openairdocs.org/ntsb/MIA88FA206.md): Piper PA-28-180 · Madeira Beach, FL · Accident · 2 fatal · Field investigation · Final report · Jun 25, 1988 · N15986 · Destroyed
  > Witnesses stated that the acft was flying about 20 feet above the bay when the left wing dipped into the water. The airplane cartwheeled and sank. Witnesses said the aircraft had been buzzing homes and boats all along the coast, from clearwater south to the…
- [NTSB BFO88LA059](https://openairdocs.org/ntsb/BFO88LA059.md): Champion 7ECA · Talcott, WV · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 1988 · N9504S · Destroyed
  > According to a witness, the acft was maneuvering at a low altitude when it contacted trees. The acft then descended, impacting the terrain 45 ft from the trees and slid aprx 110 ft before coming to rest. The plt stated that due to injuries he is unable to…
- [NTSB DEN88LA134](https://openairdocs.org/ntsb/DEN88LA134.md): Cessna T188C · Big Timber, MT · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 1988 · N4970J · Substantial damage
  > The plt said he was spraying 2,4,d on two barley flds. He had completed one fld and was turning around when the acft began to settle. He said when he attempted to avoid ground contact the acft stalled and collided with the ground. During a telephone…
- [NTSB ATL88FA199](https://openairdocs.org/ntsb/ATL88FA199.md): Luscombe 8A · Horse Shoe, NC · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1988 · N1144B · Destroyed
  > A witness reported that he was irrigating a newly cultivated corn field with a spray irrigation machine. He heard and then observed the accident airplane fly through or just over a gap in the trees at the northeast end of the field. The airplane proceeded to…
- [NTSB LAX88DVA07](https://openairdocs.org/ntsb/LAX88DVA07.md): Ayres S2R · Firebaugh, CA · Accident · 1 fatal · Final report · Jun 21, 1988 · N5512X · Destroyed
  > During an agricultural spraying run, the airplane was required to fly under power lines to complete the job. The airplane was seen flying in the direction of the wires. The airplane initially contacted a levee with the wing and then collided with a power…
- [NTSB SEA88LA115](https://openairdocs.org/ntsb/SEA88LA115.md): Peterson J-4 · Ephrata, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1988 · CGHGZ · Substantial damage
  > The glider plt was maneuvering for a thermal when he encountered a downdraft. The plt said insufficient altitude remained for an airport landing. An off-airport landing on rough terrain resulted in damage to the glider.
- [NTSB NYC88LA168](https://openairdocs.org/ntsb/NYC88LA168.md): Cessna 305A · Colts Neck, NJ · Accident · No injuries · Limited investigation · Final report · Jun 18, 1988 · N14418 · Substantial damage
  > During a banner pick up attempt, the tow rope became affixed to the main landing gear. The pilot was unable to release the banner and landed with it still attached. Upon landing roll out, the aircraft's tail rose abruptly and the propeller dug into the turf.…
- [NTSB NYC88FA167](https://openairdocs.org/ntsb/NYC88FA167.md): Bellanca 7GCBC · Livermore Falls, ME · Accident · 2 fatal · Field investigation · Final report · Jun 18, 1988 · N4129Y · Destroyed
  > The citabria 7GCBC was observed to make a loop. The left wing bent upward at the strut attach point as the aircraft was at the bottom of the loop and recovering to level flight. The aircraft was then observed to descend in a right spiral and not recover prior…
- [NTSB MIA88FA197](https://openairdocs.org/ntsb/MIA88FA197.md): Kennedy Skycycle 2 · Orlando, FL · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1988 · N33KA · Destroyed
  > The gyroplane was on a local demonstration flt. The passenger (pax) stated the plt took off, climbed to aprx 500 ft AGL,descended to aprx 20 ft AGL & maneuvered near observers. He said the plt then added power & initiated a 30 deg climb attitude. The pax…
- [NTSB DEN88LA131](https://openairdocs.org/ntsb/DEN88LA131.md): Grumman G-164 · Ayr, ND · Accident · No injuries · Limited investigation · Final report · Jun 18, 1988 · N455Y · Substantial damage
- [NTSB FTW88LA122](https://openairdocs.org/ntsb/FTW88LA122.md): Cessna 182R · Garden City, TX · Accident · No injuries · Limited investigation · Final report · Jun 17, 1988 · N9836H · Substantial damage
  > The pilot was inspecting some areas to be sprayed and also a road to be used as an airstrip for his aerial spraying. After a low pass over the road at reduced power, he advanced the throttle but the engine would not respond. During the forced landing in rough…

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=183

## 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 = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=182

---
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.