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

## Cases, newest first

- [NTSB FTW82FRG36](https://openairdocs.org/ntsb/FTW82FRG36.md): Piper 25-235 · Hondo, TX · Accident · Serious injuries · Final report · Jun 8, 1982 · N7344Z · Destroyed
  > On the second pass spraying sodium chloride the aircraft struck the top portion of a line of oak trees when pulling out of a field. The aircraft then collided with a tv antenna and another tree before contacting the ground.
- [NTSB FTW82FPD12](https://openairdocs.org/ntsb/FTW82FPD12.md): Cessna 150 · Graham, TX · Accident · 1 fatal · Final report · Jun 8, 1982 · N6742G · Destroyed
  > The aircraft was being used on a pipeline patrol mission. The pilot informed the pipeline ground crew of a pipeline leak and circled the area. The aircraft was observed by the ground crew to making a wide circle at about 100 ft AGL when it abruptly went into…
- [NTSB FTW82DA216](https://openairdocs.org/ntsb/FTW82DA216.md): Cessna A188B · Gould, AR · Accident · No injuries · Final report · Jun 8, 1982 · N731MZ · Substantial damage
  > The pilot stated that there were trees on the east end of the field that he was fertilizing and the wind was from the southwest at 15, gusting 20 KTS. The temperature was about 90 degrees. The pilot reported that when he was turning to go into the field, a…
- [NTSB DEN82DTG05](https://openairdocs.org/ntsb/DEN82DTG05.md): Cessna 188 · Devils Lake, ND · Accident · No injuries · Final report · Jun 8, 1982 · N2087J · Substantial damage
  > The pilot started a swath run at dusk by crossing under a set of wires. As he crossed under the wires, one of his main gear struck the top of a rock pile. The pilot thought that both of the main gear had failed, and he elected to make a belly landing in a…
- [NTSB MKC82DA098](https://openairdocs.org/ntsb/MKC82DA098.md): Weatherly 201A · Bronson, KS · Accident · No injuries · Final report · Jun 7, 1982 · N2934W · Substantial damage
  > The pilot reported that he was spraying over rolling terrain that was covered with trees. While on his last pass, he struck the top of a tree with his left wing. The aircraft became difficult to control, and the pilot elected to make a precautionary landing.…
- [NTSB LAX82DVG26](https://openairdocs.org/ntsb/LAX82DVG26.md): Grumman G-164 · Williams, CA · Accident · No injuries · Final report · Jun 7, 1982 · N641U · Destroyed
  > The pilot was applying a granular herbicide to a rice field with low voltage wires on the west border and high voltage lines located diagonally across the field. During a pass from west to east, he crossed over the low voltage wires and lowered the nose to…
- [NTSB ATL82FLA03](https://openairdocs.org/ntsb/ATL82FLA03.md): Cessna 172M · Thomasville, GA · Accident · 2 fatal · Final report · Jun 7, 1982 · N13687 · Destroyed
  > The aircraft was being operated on a business flight for the purpose of surveying farm crops in the area. At about 1700 EDT, it crashed into a 20 acre farm lake while on a westerly heading. The weather was reported as clear, visibility 6 to 7 miles with haze,…
- [NTSB DEN82DTI14](https://openairdocs.org/ntsb/DEN82DTI14.md): Starke KR-2 · Wolf Creek, MT · Accident · No injuries · Final report · Jun 6, 1982 · N2AL · Substantial damage
  > While flying at a low altitude over the Missouri river the aircraft collided with a powerline damaging the propeller and cowling. The pilot used ground transportation to pickup a new propeller. He repaired the aircraft, surveyed the takeoff area and attempted…
- [NTSB LAX82FA213](https://openairdocs.org/ntsb/LAX82FA213.md): Cessna 172L · Meiners Oaks, CA · Accident · 2 fatal · Field investigation · Final report · Jun 5, 1982 · N19659 · Destroyed
  > Witnesses in a remote canyon reported an aircraft making low passes in that area. They last saw the plane going up the canyon. Later, the aircraft was located on a wall of the same canyon. Tests of the pilot's blood showed an alcohol level of.279 percent.…
- [NTSB FTW82FRD14](https://openairdocs.org/ntsb/FTW82FRD14.md): Grumman G-164A · Kaplan, LA · Accident · No injuries · Final report · Jun 5, 1982 · N5261 · Destroyed
  > The operator reported that the pilot was making a left turn to line up with the flagman when the aircraft stalled and went down into trees. The temperature was reported to be 95 deg. There was no mention of injuries in the operator's accident report…
- [NTSB FTW82FRG35](https://openairdocs.org/ntsb/FTW82FRG35.md): Piper PA-18A · San Marcos, TX · Accident · Minor injuries · Final report · Jun 4, 1982 · N3590P · Destroyed
  > The pilot was on a flight to spray his own farm. While maneuvering during aerial application, the left wing tip struck a telephone guy wire and then the plane crashed. The pilot had been spraying his own farm over the previous 10 yrs with the same telephone…
- [NTSB ATL82FA153](https://openairdocs.org/ntsb/ATL82FA153.md): Cessna 172M · Alabaster, AL · Accident · 1 fatal · Field investigation · Final report · Jun 4, 1982 · N5443H · Destroyed
  > At 0755, the plt contacted birmingham approach control & reported 35 mi south at 2,000 ft. he was advised of the bhm wx & that it was IFR at the arpt. The pilot stated he would like to land at another arpt & was given his approximate position to three arpts.…
- [NTSB DEN82FTM13](https://openairdocs.org/ntsb/DEN82FTM13.md): Aerospatiale 315B · Coalville, UT · Accident · Serious injuries · Final report · Jun 3, 1982 · N8237 · Substantial damage
  > During a seismic exploration flight the eng quit. No eng malfunction was found.
- [NTSB ATL82DKQ14](https://openairdocs.org/ntsb/ATL82DKQ14.md): Cessna A188B · Boyle, MS · Accident · Serious injuries · Final report · Jun 3, 1982 · N731MM · Destroyed
  > The pilot reported that he had begun a swath run with a fresh load of fertilizer when the aircraft struck a wire. He stated that this was the top wire of an extremely high set. The wires ran diagonally across the southeast corner of the rice field that he was…
- [NTSB SEA82DA080](https://openairdocs.org/ntsb/SEA82DA080.md): Eagle DW-1 · Sprague, WA · Accident · No injuries · Final report · Jun 1, 1982 · N88012 · Destroyed
  > The pilot had checked out in this make and model of aircraft on the preceeding day. On the day of the accident, he was spraying fertizer in a crosswind condition. He stated that he was on a downhill swath run in gusty conditions when he deployed the controls…
- [NTSB MKC82DA093](https://openairdocs.org/ntsb/MKC82DA093.md): Grumman G-164A · Red Cloud, NE · Accident · Minor injuries · Final report · Jun 1, 1982 · N5253 · Destroyed
  > The aircraft struck the top wire of an electrical transmission line and crashed. The pilot reported that he misjudged the "wire distance" as he let down over a pond to begin a swath run. The pond was at the edge of the field that he was seeding. The pilot…
- [NTSB MKC82DA092](https://openairdocs.org/ntsb/MKC82DA092.md): Cessna 188B · Thornton, IA · Accident · No injuries · Final report · Jun 1, 1982 · N21722 · Substantial damage
  > While spraying a corn field, the pilot crossed under a powerline at the north end of the field. While passing beneath the lines, his left wing tip struck the bottom wire. The pilot reported that he lost aileron control and landed in a corn field with no…
- [NTSB FTW82DA205](https://openairdocs.org/ntsb/FTW82DA205.md): Grumman G-164A · Angleton, TX · Accident · No injuries · Final report · Jun 1, 1982 · N8974H · Destroyed
  > While concentrating on his flagger, the pilot misjudged his altitude and allowed the aircraft to collide with a levee. The pilot then dumped his load and made an emergency landing, during which time, the aircraft nosed over.
- [NTSB DEN82FTA10](https://openairdocs.org/ntsb/DEN82FTA10.md): Piper PA-25-235 · Glendive, MT · Accident · Serious injuries · Final report · Jun 1, 1982 · N4589Y · Destroyed
  > The pilot reported that he had just loaded the sprayer and had made one pass downhill. At the end of the field, he started a left turn to make an uphill pass. The pilot stated that he got into bad air or down slope air and started to dump the chemical but it…
- [NTSB DEN82DTK05](https://openairdocs.org/ntsb/DEN82DTK05.md): Grumman G-164 · Murdo, SD · Accident · No injuries · Final report · Jun 1, 1982 · N10247 · Substantial damage
  > During a spraying operation the landing gear collided with a dirt bank. The pilot returned to the airport and during landing the right wing contacted the runway because of a missing right landing gear. The aircraft ground looped and nosed over.
- [NTSB SEA82DYE07](https://openairdocs.org/ntsb/SEA82DYE07.md): Starduster TOO SA300 · Sequim Bay, WA · Accident · 1 fatal · Final report · May 31, 1982 · N15DK · Destroyed
  > While flying over a lake at low altitude, the left wing of the aircraft struck wires on a moored sailboat about 50 ft above the water level. Three witnesses report that just prior to the collision, the pilot dipped or wagged his wings and waved at them. After…
- [NTSB DEN82FA099](https://openairdocs.org/ntsb/DEN82FA099.md): Cessna 172N · Orem, UT · Accident · 4 fatal · Field investigation · Final report · May 31, 1982 · N5380D · Substantial damage
  > Prior to the accident, the student pilot was observed performing power-on stalls at low altitude with passengers on board. The stalls were being made toward rapidly rising terrain in a mountainous area. After the last recovery, the aircraft was observed…
- [NTSB CHI82DA195](https://openairdocs.org/ntsb/CHI82DA195.md): Grumman AA1B · Chesterland, OH · Accident · Minor injuries · Final report · May 31, 1982 · N1631R · Destroyed
  > The aircraft collided with trees during low flight maneuvering. The aircraft then collided with terrain and was destroyed. The pilot and passenger received minor injuries.
- [NTSB ATL82FID09](https://openairdocs.org/ntsb/ATL82FID09.md): Mignet HM293 · Radford, VA · Accident · Minor injuries · Final report · May 30, 1982 · N2931 · Substantial damage
  > During flight, the pilot began flying over a river in his homebuilt HM293 "flea." He reported that he had started a right turn and was looking for a bridge when the left wing tip struck wires. The wires were part of a railway signal line that crossed the…
- [NTSB ANC82DAG28](https://openairdocs.org/ntsb/ANC82DAG28.md): Piper PA-18 · Kenai, AK · Accident · 1 fatal · Final report · May 30, 1982 · N9089D · Destroyed
  > Pilot was giving passengers rides along bishop creek. He was reported as flying low and erratic. On the last flight with two passengers, the wing dipped & caught the water. The acft then cartwheeled. The plt's blood alcohol level was 196 mg%.
- [NTSB FTW82DA199](https://openairdocs.org/ntsb/FTW82DA199.md): Air Tractor AT 301 · Eakly, OK · Accident · No injuries · Final report · May 29, 1982 · N3653F · Substantial damage
  > The pilot stated that as he pulled up from a swath run the engine started missing. He then elected to attempt a return to his departure airstrip. While turning toward the field the engine started making a loud noise and lost power. During the forced landing…
- [NTSB CHI82DA196](https://openairdocs.org/ntsb/CHI82DA196.md): Bell 47D1 · Le Sueur, MN · Accident · No injuries · Final report · May 29, 1982 · N4251A · Substantial damage
  > During a spraying operation, the aircraft was being refueled from a 200 gal fuel tank, mounted on the rear of a truck. The truck was parked on a slight slope with the outlet for the servicing hose at the lower end. After the helicopter was serviced with 14…
- [NTSB DEN82FTK04](https://openairdocs.org/ntsb/DEN82FTK04.md): Callair A-9B · Sioux Falls, SD · Accident · No injuries · Final report · May 27, 1982 · N7769V · Substantial damage
  > The eng quit & the plt landed in an adjacent field after first hitting a wooded fence. An inspectin of the bendix fuel servo unit, model PSA-10ED-1, revealed that the fuel diaphragm stem, pn 2539806, had failed.
- [NTSB DEN82FTC04](https://openairdocs.org/ntsb/DEN82FTC04.md): Cessna 172P · Osage, WY · Accident · 1 fatal · Final report · May 27, 1982 · N64093 · Destroyed
  > The aircraft departed gillette, Wyoming on a pipeline patrol mission. This was the pilot's first pipeline patrol over the line that he was patrolling. During the flight, the aircraft struck three powerlines and crashed. The passenger stated that he saw the…
- [NTSB CHI82FA186](https://openairdocs.org/ntsb/CHI82FA186.md): Cessna 172N · Milford, MI · Accident · 2 fatal · Field investigation · Final report · May 27, 1982 · N4967G · Destroyed
  > Earlier in the evening during a return flt from london, ontario to pontiac, MI the plt became disoriented & was radar vectored to detroit city arpt, the only arpt reporting VMC. The plt landed at about 2208. After landing the plt received two wx briefings at…
- [NTSB LAX82DA194](https://openairdocs.org/ntsb/LAX82DA194.md): Grumman G-164A · Woodland, CA · Accident · Minor injuries · Final report · May 26, 1982 · N8388 · Destroyed
  > The aircraft collided with wires and crashed during a crop dusting operation. The aircraft hit wires during a turn at the end of a swath run.
- [NTSB FTW82DA196](https://openairdocs.org/ntsb/FTW82DA196.md): Cessna A188B · Mangham, LA · Accident · No injuries · Final report · May 26, 1982 · N6303G · Destroyed
  > While turning to begin a swath run at about 200 ft AGL, a propeller blade failed and separated. Subsequently, the engine began a severe vibration and also separated. Oil covered the windshield and prevented forward visibility. The pilot reported that he was…
- [NTSB LAX82DA193](https://openairdocs.org/ntsb/LAX82DA193.md): Cessna A188 · Ehrenberg, AZ · Accident · Serious injuries · Final report · May 25, 1982 · N70454 · Destroyed
  > The pilot stated that as he pulled up at the end of a trim run in order to miss some electric wires the aircraft began to shutter. It then rolled left, right, and back to the left going almost inverted before coming to rest in a cotton field.
- [NTSB LAX82DVG25](https://openairdocs.org/ntsb/LAX82DVG25.md): Grumman G-164 · Richvale, CA · Accident · Serious injuries · Final report · May 24, 1982 · N10225 · Destroyed
  > During a procedure turn of the swath run the pilot stated he was low and slow and collided with powerlines. The aircraft crashed and burned.
- [NTSB FTW82FPG12](https://openairdocs.org/ntsb/FTW82FPG12.md): Grumman G-164 · Ethel, AR · Accident · 1 fatal · Final report · May 24, 1982 · N5376 · Destroyed
  > The acft collided with power lines during the start of a swath run.
- [NTSB CHI82FER18](https://openairdocs.org/ntsb/CHI82FER18.md): Aeronca 65-TF · Staples, MN · Accident · 1 fatal · Final report · May 23, 1982 · N31765 · Substantial damage
  > The pilot was making low passes over a river in search of a drowned man. He made a steep right turn and the aircraft stalled, dove into trees and impacted the ground nose first. The pilot stated the aircraft's door had been removed and that the aircraft had…
- [NTSB LAX82FXQ08](https://openairdocs.org/ntsb/LAX82FXQ08.md): Piper 18-150 · Tahoe City, CA · Accident · 2 fatal · Final report · May 22, 1982 · N2881P · Destroyed
  > The float equipped aircraft departed on a local photography mission. The passenger wanted to take aerial photographs of the city area. After flying around the area for about 25 minutes, the aircraft crashed on a street. A witness observed the aircraft flying…
- [NTSB LAX82DXQ10](https://openairdocs.org/ntsb/LAX82DXQ10.md): Broyill-Cowan-Murray BG12B · Yerington, NV · Accident · 1 fatal · Final report · May 22, 1982 · N612BG · Destroyed
  > At about 1315 PDT, the pilot departed on a round robin cross-country flight from minden, Nevada to bridgeport California and return. He was participating in a region ii soaring championship (sport class). On the return leg of the trip, the pilot was oserved…
- [NTSB DEN82DTG04](https://openairdocs.org/ntsb/DEN82DTG04.md): Boeing A75N1 · Northwood, ND · Accident · No injuries · Final report · May 21, 1982 · N65501 · Substantial damage
  > The pilot was on a flight to practice aerial application. This was his first flight in this make and model of aircraft. While making a practice run over an open field with water in the chemical tanks, the left main gear contacted the ground damaging the…
- [NTSB MKC82DA085](https://openairdocs.org/ntsb/MKC82DA085.md): Grumman G-164A · Tekamah, NE · Accident · No injuries · Final report · May 20, 1982 · N7689 · Substantial damage
  > On the third spray run the pilot stated that the aircraft engine had a loss of power. He attempted to fly back to the airport but was forced to make an emergency landing in an open field. During the landing roll the aircraft nosed over in the soft mud. Engine…
- [NTSB FTW82DA189](https://openairdocs.org/ntsb/FTW82DA189.md): Bell 47D-1 · Harrisburg, AR · Accident · No injuries · Final report · May 20, 1982 · N93067 · Substantial damage
  > During an agricultural spraying operation the pilot turned downwind and the tail rotor struck a rice dike. The pilot lost control and the aircraft landed hard. The main rotor severed the tail boom. Investigation revealed the aircraft had been loaded within…
- [NTSB FTW82DA188](https://openairdocs.org/ntsb/FTW82DA188.md): Cessna T188C · Knobel, AR · Accident · No injuries · Final report · May 20, 1982 · N4439J · Substantial damage
  > The pilot stated that during his swath run the engine seemed to hesitate. While checking the engine the pilot collided with a levee and the landing gear separated from the aircraft. The pilot made a forced landing in an adjacent field.
- [NTSB CHI82FA174](https://openairdocs.org/ntsb/CHI82FA174.md): Cessna A188 · Blue Earth, MN · Accident · 1 fatal · Field investigation · Final report · May 19, 1982 · N9819V · Destroyed
  > The flagman stated that during the swath run the acft was following the contour of the field. The flagman thought the plt was getting close to the end of the field & was about to call him on the radio when the acft pulled up to about a 45 deg nose high…
- [NTSB SEA82DA072](https://openairdocs.org/ntsb/SEA82DA072.md): Bell 47G-2 · Grandview, WA · Accident · No injuries · Final report · May 18, 1982 · N11VH · Substantial damage
  > While dispensing herbicide (systox) over an apple orchard the pilot sensed that the engine was binding followed by a power loss. The pilot elected to dump the herbicide and performed a power-off autorotation landing in a grape vineyard. Investigation revealed…
- [NTSB LAX82DVM16](https://openairdocs.org/ntsb/LAX82DVM16.md): Hughes 269C · Salinas, CA · Accident · No injuries · Final report · May 17, 1982 · N1105B · Substantial damage
  > The student pilot reported that the purpose of the flight was to practice hovering. He reported that the wind was from 280 degrees at 9 knots. He stated that while hovering, he turned to a downwind heading when a gust of wind spun the helicopter to the right.…
- [NTSB ATL82FID08](https://openairdocs.org/ntsb/ATL82FID08.md): Cessna 188 · West Point, VA · Accident · No injuries · Final report · May 17, 1982 · N5522S · Destroyed
  > The pilot took off with a 50 gal load of water to calibrate the spray system. He stated that during a swath run, he heard a loud noise or whirring sound and initially thought there was a spray pump propeller failure. Immediately, he pulled up, started a left…
- [NTSB LAX82DA178](https://openairdocs.org/ntsb/LAX82DA178.md): Piper PA-36-285 · E. Of Delano, CA · Accident · No injuries · Final report · May 16, 1982 · N57734 · Substantial damage
  > During the procedure turn phase while spraying orange trees the engine stopped. Six orange trees were destroyed during the emergency landing. Examination of the aircraft's engine revealed no preimpact failure or malfunction.
- [NTSB ATL82FKJ12](https://openairdocs.org/ntsb/ATL82FKJ12.md): Piper J3C-65 · Alabaster, AL · Accident · 1 fatal · Final report · May 16, 1982 · N42799 · Destroyed
  > During an air show, the aircraft was observed flying slowly over the runway on a southerly heading at about 200 to 250 ft AGL. Full left rudder was applied along with full up elevator and the plane entered a spin. After one turn, full opposite rudder was…
- [NTSB MKC82DA082](https://openairdocs.org/ntsb/MKC82DA082.md): Bell 47G2 · Thornton, IA · Accident · Minor injuries · Final report · May 14, 1982 · N8426E · Substantial damage
  > During the downwind turn for the fourth spraying pass the pilot encountered a gust of wind. The pilot stated he applied power, collective and cyclic to level off at spraying altitude but the wind was too strong to prevent the tailboom from striking the ground.
- [NTSB ANC82DAG26](https://openairdocs.org/ntsb/ANC82DAG26.md): Piper 18 · Ramsey Bay, AK · Accident · 1 fatal · Final report · May 13, 1982 · N74979 · Substantial damage
  > The pilot and passenger were on a hunting trip and flew out of the camp to spot fellow hunters climbing a mountain. After locating them the pilot tried to turn in the canyon at low altitude and low airspeed. The aircraft stalled, spun and crashed.

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

## 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=232

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