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

## Cases, newest first

- [NTSB CHI88DER02](https://openairdocs.org/ntsb/CHI88DER02.md): Bellanca 7GCBC · Warroad, MN · Accident · 2 fatal · Final report · Feb 26, 1988 · N53808 · Destroyed
  > The aircraft experienced a loss of control and rapid descent onto the ice in what witnesses described as a spin type maneuver from a low altitude. The purpose of the flight was a low level photo mission. The aircraft was destroyed. The pilot and passenger…
- [NTSB LAX88DUM03](https://openairdocs.org/ntsb/LAX88DUM03.md): Beech A36 · Ramona, CA · Accident · Minor injuries · Final report · Feb 25, 1988 · N23536 · Destroyed
  > During a test flight for certification of wing tip tanks, while performing spins, the aircraft entered a flat spin. The pilot was unable to regain control and exited the aircraft and parachuted to safety. The aircraft collided with the terrain shortly…
- [NTSB LAX88FA113](https://openairdocs.org/ntsb/LAX88FA113.md): Piper PA-28-161 · Rosamond, CA · Accident · 2 fatal · Field investigation · Final report · Feb 21, 1988 · N8321K · Destroyed
  > Decision of the pilot to attempt multiple low level passes over a residence in an area of rising terrain. Contributing to the accident was the significant levels of methamphetamine and amphetamine found in both the pilot's blood and urine specimens. A factor…
- [NTSB DEN88LA077](https://openairdocs.org/ntsb/DEN88LA077.md): Aeronca 7AC · Gila, NM · Accident · Serious injuries · Limited investigation · Final report · Feb 21, 1988 · N2359E · Substantial damage
  > The plt said that he and his friend were on a pleasure flt following a river bed when he spotted some electrical power lines ahead. He said that he felt that he had adequate clearance over the lines but that he did not see the static line above the wires. The…
- [NTSB LAX88FA114](https://openairdocs.org/ntsb/LAX88FA114.md): Beech A23 · Big Bear City, CA · Accident · 2 fatal · Field investigation · Final report · Feb 20, 1988 · N1461L · Destroyed
  > The passenger told friends that the pilot was going to perform some aerobatic maneuvers near the lodge where they were staying. The other residents in the lodge reported that the airplane flew very low over the house and proceeded towards the east. After…
- [NTSB SEA88FA050](https://openairdocs.org/ntsb/SEA88FA050.md): Bell 206A · Roseburg, OR · Accident · Serious injuries · Field investigation · Final report · Feb 18, 1988 · N7981J · Substantial damage
  > While hovering at 200' AGL, the eng lost power & the plt entered an autorotation. He maneuvered to avoid trees & landed amid tree stumps in a logging clear cut area. An investigation revealed the 1st stage turbine wheel had failed. The wheel exited the eng &…
- [NTSB CHI88DEE02](https://openairdocs.org/ntsb/CHI88DEE02.md): Hill Bushby Mustang II · Yorkville, IL · Accident · 1 fatal · Final report · Feb 18, 1988 · N84HM · Destroyed
  > Performance of aerobatic maneuvers with insufficient altitude for recovery.
- [NTSB LAX88LA110](https://openairdocs.org/ntsb/LAX88LA110.md): Cessna 152 · Seneca, AZ · Accident · 2 fatal · Limited investigation · Final report · Feb 13, 1988 · N757NM · Destroyed
- [NTSB LAX88FA108](https://openairdocs.org/ntsb/LAX88FA108.md): Robinson R-22B · Westlake Vlg, CA · Accident · No injuries · Field investigation · Final report · Feb 12, 1988 · N2445Q · Substantial damage
  > Pilot's remedial actoin after encountering a pitch up wass too abrupt and the improper use of the cyclic control.
- [NTSB NYC88DHA02](https://openairdocs.org/ntsb/NYC88DHA02.md): Gribosh LONG-EZ · Perkasie, PA · Accident · 1 fatal · Final report · Feb 9, 1988 · N814EZ · Substantial damage
  > The homebuilt airplane was being operated on its second test flight after manufacture. Witnesses stated that they heard the engine 'making power changes' and 'surging' while the airplane was maneuvering at 30 to 50 feet above the ground. Also, they reported…
- [NTSB SEA88LA045](https://openairdocs.org/ntsb/SEA88LA045.md): Cessna 152 · Palamino Valley, NV · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 1988 · N48890 · Substantial damage
  > The student pilot was practicing 's' turns over a roadway when engine power loss occurred. Forced landing attempt on the road resulted in a high flare and hard landing, shearing the nose gear. The acft flipped inverted. Engine inspection and test run revealed…
- [NTSB FTW88LA059](https://openairdocs.org/ntsb/FTW88LA059.md): Cessna 182P · Weatherford, TX · Accident · No injuries · Limited investigation · Final report · Feb 6, 1988 · N52536 · Substantial damage
  > A used eng had just been installed in the acft and the owner and mech were performing a functional test flt. Shortly after takeoff at about 300 ft AGL, the eng lost power. The plt pumped the throttle and the eng restarted but immediately quit again and would…
- [NTSB DEN88FA062](https://openairdocs.org/ntsb/DEN88FA062.md): Piper PA-18-125 · Brighton, CO · Accident · 1 fatal · Field investigation · Final report · Feb 4, 1988 · N1153A · Destroyed
  > The student pilot was observed by witnesses to 'buzz' the city of Brighton, Colorado. Witnesses stated that N1153A flew over houses and buildings at a very low altitude. The acft was then observed to climb to a high altitude, do a 'wing over' or 'hammerhead'…
- [NTSB NYC88FA072](https://openairdocs.org/ntsb/NYC88FA072.md): Cessna 337E · Friedens, PA · Accident · 1 fatal · Field investigation · Final report · Feb 2, 1988 · N1201M · Destroyed
  > The 24 year old unlicensed pilot made an unauthorized flight in his father's aircraft. The Cessna 337 was observed to manuever in the vicinity of the airport at a low altitude in and out of the clouds. The aircraft was then observed to come out of the clouds…
- [NTSB LAX88FA103](https://openairdocs.org/ntsb/LAX88FA103.md): Cessna 150J · Douglas, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 2, 1988 · N61305 · Destroyed
  > Inadvertent entry into a stall/spin by the pilot-in-command.
- [NTSB CHI88FA056](https://openairdocs.org/ntsb/CHI88FA056.md): Cessna 150M · Norwalk, WI · Accident · 1 fatal · Field investigation · Final report · Jan 31, 1988 · N9458U · Destroyed
  > The pilot made several calls to the fss and obtained weather briefings for reported and forecast IFR conditions along his proposed route of flight. After departure from sparta, Wisconsin in weather described by witnesses to be below VMC, the aircraft impacted…
- [NTSB MIA88LA095](https://openairdocs.org/ntsb/MIA88LA095.md): Sikorsky S-58E · Sanford, FL · Accident · No injuries · Limited investigation · Final report · Jan 30, 1988 · N2769P · Substantial damage
  > Plt was attempting to give himself a checkout in the helicopter for he believed the fee for a check plt was too expensive. During a second attempt at hover flt he positioned himself with a 90 degree, 12 knot right crosswind. As the acft became light on the…
- [NTSB ATL88DKG03](https://openairdocs.org/ntsb/ATL88DKG03.md): Davis RV-3 · Loxley, AL · Accident · 1 fatal · Final report · Jan 29, 1988 · N1387K · Destroyed
  > The pilot was making touch and go landings at a private airstrip. On the third takeoff witnesses said the aircraft climbed steeply and appeared to enter a hammerhead stall. The aircraft impacted the ground near the departure end of the runway. The…
- [NTSB MKC88FA043](https://openairdocs.org/ntsb/MKC88FA043.md): Aerospatiale AS-350B · Omaha, NE · Accident · Minor injuries · Field investigation · Final report · Jan 20, 1988 · N26TM · Destroyed
  > The pilot picked the aircraft up to a hover and made a hovering turn in preparation for departure. The nose of the aircraft began to rise. The pilot stated later that he could not control the aircraft. The aircraft began to descend and the tail rotor struck a…
- [NTSB ATL88LA101](https://openairdocs.org/ntsb/ATL88LA101.md): Rockwell 112A · Juliette, GA · Accident · No injuries · Limited investigation · Final report · Jan 20, 1988 · N1432J · Substantial damage
  > The airplane struck a transmission cable over a river at about 100 ft AGL. The plt rptd that he inadvertently stalled the airplane while turning to reverse direction during an aerial photo flt, and that he felt a 'bump' during recovery. After returning to the…
- [NTSB MKC88FA040](https://openairdocs.org/ntsb/MKC88FA040.md): Piper PA-28-140 · Creve Coeur, MO · Accident · 1 fatal · Field investigation · Final report · Jan 17, 1988 · N1727J · Destroyed
  > Witnesses stated that the aircraft suddenly started a vertical climb from a straight and level flight attitude. The airplane lost momentum while in the climb, then it nosed down and dove towards the ground. It exploded upon impact and was destroyed in the…
- [NTSB ANC88LA026](https://openairdocs.org/ntsb/ANC88LA026.md): Cessna 172 · Iliamna, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 1988 · N9974V · Substantial damage
  > The pilot was maneuvering at low altitude in low visibility when he encountered a complete white-out condition. The pilot lost control in flight and crashed on a frozen lake.
- [NTSB CHI88LA050](https://openairdocs.org/ntsb/CHI88LA050.md): Cessna 172 · Red Lake Falls, MN · Accident · Serious injuries · Limited investigation · Final report · Jan 15, 1988 · N8122U · Destroyed
- [NTSB ATL88FA078](https://openairdocs.org/ntsb/ATL88FA078.md): Cessna 150H · Cedartown, GA · Accident · 1 fatal · Field investigation · Final report · Jan 14, 1988 · N12NF · Substantial damage
- [NTSB LAX88FA085](https://openairdocs.org/ntsb/LAX88FA085.md): Bell 47G-2A1 · San Diego, CA · Accident · 1 fatal · Field investigation · Final report · Jan 13, 1988 · XBDGH · Destroyed
  > Pilots complacency in performing the preflight inspection. His failure to disconnect the two tie downs straps attached to the right side of the helicopter resulted the roll.
- [NTSB SEA88LA080](https://openairdocs.org/ntsb/SEA88LA080.md): Cessna 180 · Hailey, ID · Accident · 2 fatal · Limited investigation · Final report · Jan 12, 1988 · N180W · Destroyed
  > This Cessna 180 was on a VFR flight from gooding, Idaho to Hailey, Idaho when it disappeared. The wreckage was later found in a steep canyon about 15 miles from the destination. No mechanical failures were found. Good VFR weather conditions existed at the…
- [NTSB ATL88FA072](https://openairdocs.org/ntsb/ATL88FA072.md): North American T-28C · Woodstock, GA · Accident · 2 fatal · Field investigation · Final report · Jan 2, 1988 · N9719G · Destroyed
  > A plt/witness rptd that the airplane first flew over the arpt to the North at about 500 ft AGL, and subsequently performed a wingover at the North end of the arpt. The airplane then made a high-speed pass over the rwy to the south, at about 50 ft AGL. Upon…
- [NTSB ATL88FA070](https://openairdocs.org/ntsb/ATL88FA070.md): Cessna 152 · Ravenna, OH · Accident · 2 fatal · Field investigation · Final report · Jan 2, 1988 · N5364M · Substantial damage
- [NTSB MKC88DCQ01](https://openairdocs.org/ntsb/MKC88DCQ01.md): Flagg Star Lite · Ft. Scott, KS · Accident · 1 fatal · Final report · Jan 1, 1988 · N87LF · Destroyed
  > The failure of the main spars at the attachment points inside the fuselage.
- [NTSB LAX88DUQ03](https://openairdocs.org/ntsb/LAX88DUQ03.md): Rolladen-Schneider LS-3 · Santa Ynez, CA · Accident · Serious injuries · Final report · Dec 27, 1987 · N75FE · Destroyed
  > During a pleasure flight, the left wing of the glider struck a tree and collided with the terrain during a left turn in sinking air. The plt stated that he was looking over his right shoulder at nearby traffic then turned to look forward into the hazy setting…
- [NTSB MIA88FA071](https://openairdocs.org/ntsb/MIA88FA071.md): Cessna 150H · Destin, FL · Accident · 1 fatal · Field investigation · Final report · Dec 24, 1987 · N7005S · Destroyed
  > Witnesses stated that they observed the acft flying in the fog in a southeasterly direction and turn hard right just before it struck the 19th floor of a condominium. The fog according to residents of the bldg was so thick that the ground could not be seen…
- [NTSB NYC88LA059](https://openairdocs.org/ntsb/NYC88LA059.md): Cessna 170A · Sandwich, MA · Accident · 1 fatal · Limited investigation · Final report · Dec 22, 1987 · N5571C · Destroyed
  > The Cessna 170A was on an aerial photography flt. Witnesses rprtd the acft was flying slow at about 200 ft AGL when it began to settle. The witnesses then heard an increase in eng power & saw the acft pitch up. Subsequently, it 'fell off on a wing,' crashed…
- [NTSB ATL88FA066](https://openairdocs.org/ntsb/ATL88FA066.md): Fairchild M-62A-3 · Monroe, NC · Accident · 2 fatal · Field investigation · Final report · Dec 17, 1987 · N9132H · Destroyed
  > Reptdly, the flt purpose was to administer a bfr to the plt/owner of the acft. The first takeoff was aborted. The acft deptd again without an apparent problem. After about 30 minutes, the apt mgr heard and saw the acft in a vertical descent and rotating about…
- [NTSB MIA88FA063](https://openairdocs.org/ntsb/MIA88FA063.md): Piper PA-22-135 · Geneva, AL · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1987 · N3512A · Destroyed
  > Prior to the acdnt, a witness saw the acft flying across an open field at a very low alt. Subsequently, it collided with the tops of several pine trees at about 90 to 95 ft AGL, then it crashed to the ground. No preimpact part failure or malfunction was…
- [NTSB LAX88DVD01](https://openairdocs.org/ntsb/LAX88DVD01.md): Texas Helicopter Wasp/M74L · Petaluma, CA · Accident · No injuries · Final report · Dec 11, 1987 · N51843 · Substantial damage
  > During an aerial application flight, while on the last pass, the aircraft struck a power line that became entangled in the rotor blades. The pilot was unable to maintain control of the aircraft and collided with the terrain. There were no reported mechanical…
- [NTSB ATL88LA054](https://openairdocs.org/ntsb/ATL88LA054.md): Beech B24R · Sewanee, TN · Accident · Serious injuries · Limited investigation · Final report · Dec 9, 1987 · N1999L · Substantial damage
  > The plt rprtd that he obtained a wx briefing before takeoff & that the wx at his intended destination was rprtd as marginal. While en route, he encountered wx and climbed above it. Aprx 4 hrs after departure, he became concerned about the remaining fuel…
- [NTSB DEN88LA035](https://openairdocs.org/ntsb/DEN88LA035.md): Bellanca 7GCBC · Newell, SD · Accident · No injuries · Limited investigation · Final report · Dec 6, 1987 · N2562Z · Substantial damage
  > The plt reported that he was surveying a field of winter wheat at approximately 100 feet AGL in slow flight. The wind was strong and gusty and the acft began to settle toward the ground. The plt added full power, however, the left main landing gear struck the…
- [NTSB BFO88IA012](https://openairdocs.org/ntsb/BFO88IA012.md): Mcdonnell Douglas DC-9-32 · Baltimore, MD · Incident · No injuries · Incident investigation · Final report · Dec 5, 1987 · N924L · 2 aircraft · No damage
  > Twa flt 388 (DC-9, N924L) was in clouds climbing to 7000' when Baltimore (bwi) TRACON adzd that an acft (Piper PA-28R) was straight ahead at 3 mi dscndg fm 6700'. Flt 388 had passed 6000' & the capt requested a traffic avoidance vector. The TRACON ctlr…
- [NTSB ATL88LA049](https://openairdocs.org/ntsb/ATL88LA049.md): Cessna 172H · Paducah, KY · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1987 · N2522L · Substantial damage
  > Abt 20 mi from Paducah (pah), the plt contacted the fss & said the acft was low on fuel & that he intended to land at pah. He was informed that the FBO at pah was closed for the night & fuel was available only if a $25 call-out fee was paid. Also, he was told…
- [NTSB BFO88FA009](https://openairdocs.org/ntsb/BFO88FA009.md): Cessna 182D · South Hill, VA · Accident · 1 fatal · Field investigation · Final report · Nov 30, 1987 · N8886X · Destroyed
  > The plt was on the third leg of a trip between tampa, FL and sussex, NJ. The previous two stops were made because of adverse wx conditions. Before this flight he was advised by fss that VFR flight was not recommended. He filed a VFR flight plan but did not…
- [NTSB LAX88FA061](https://openairdocs.org/ntsb/LAX88FA061.md): Piper PA-11 · San Marcos, CA · Accident · 2 fatal · Field investigation · Final report · Nov 28, 1987 · N4767H · Destroyed
  > The 2 plts took off on an instructional flt which was to be a biennial flt review for the acft owner. During the flt, the plts flew to a dirt strip on a saddleback between 2 mtn peaks near San Marcos. Subsequently, the acft struck a boulder & crashed near the…
- [NTSB FTW88FA033](https://openairdocs.org/ntsb/FTW88FA033.md): Beech 95-B55 · Commerce, TX · Accident · 2 fatal · Field investigation · Final report · Nov 28, 1987 · N5934S · Destroyed
  > The purpose of the flight was to satisfy an insurance requirement that the owner receive 10 hours of dual instruction in this aircraft. The dual controls had been removed and the single control was on the left side. The aircraft was observed in a clockwise…
- [NTSB MIA88FA044](https://openairdocs.org/ntsb/MIA88FA044.md): Cessna 172N · Palm Coast, FL · Accident · 1 fatal · Field investigation · Final report · Nov 24, 1987 · N246ER · Destroyed
  > The student plt was flying the acft on a solo instructional flt in the north practice area & was assigned to practice landings, takeoffs, stalls & slow flt. Witnesses stated they observed the acft flying at a very low altitude just before it collided with a…
- [NTSB LAX88FA052](https://openairdocs.org/ntsb/LAX88FA052.md): Cessna T210L · Camp Verde, AZ · Accident · 4 fatal · Field investigation · Final report · Nov 22, 1987 · N42CR · Destroyed
- [NTSB ATL88LA041](https://openairdocs.org/ntsb/ATL88LA041.md): Grumman AA-5A · Thomson, GA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1987 · N7109L · Substantial damage
  > The airplane struck high-tension power lines while maneuvering at about 100 ft AGL. The collision occurred about 2/10 of a mile from the residence of the plt's girlfriend. One of the wires fell to the ground, damaging an auto and setting a field on fire. The…
- [NTSB MIA88FA042](https://openairdocs.org/ntsb/MIA88FA042.md): Cessna 152 · Okeelanta, FL · Accident · 2 fatal · Field investigation · Final report · Nov 19, 1987 · N89741 · Destroyed
  > The acft crashed into a wildlife management area in a steep nose down attitude with about 20 degs flaps extended. The stated purpose of the flt was to spot deer & a suitable area in which to hunt. Torsional damage to the airframe suggested that the acft was…
- [NTSB DEN88LA026](https://openairdocs.org/ntsb/DEN88LA026.md): Bell 206B III · Albuquerque, NM · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1987 · N1073N · Destroyed
  > While attempting to retrieve a parachute retarded rocket that came to rest in a tree by hooking the right front skid shoe under the chute, the parachute got hung up in the tree. The helicopter lifted the rocket approx 6 ft into the air before it swung into…
- [NTSB LAX88LA049](https://openairdocs.org/ntsb/LAX88LA049.md): Cessna 150M · Honolulu, HI · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1987 · N2973V · Destroyed
  > The pilot stated that the engine lost power while he was flying low over the ocean on a fish spotting flight. Subsequently, he ditched the aircraft in the ocean & it was not retrieved.
- [NTSB LAX88FA047](https://openairdocs.org/ntsb/LAX88FA047.md): Cessna 152 · Bakersfield, CA · Accident · 2 fatal · Field investigation · Final report · Nov 16, 1987 · N5478L · Destroyed
  > The recently rated private pilot and his passenger were flying low and waving to people on the ground. As the aircraft neared electrical service lines across its flight path ground witnesses observed it to enter an abrupt climb, roll left and dive into the…
- [NTSB LAX88FA045](https://openairdocs.org/ntsb/LAX88FA045.md): Cessna 441 · Mexicali, Mexico · Accident · 2 fatal · Field investigation · Final report · Nov 16, 1987 · N2484B · Destroyed
  > A Cessna 441 operated by the uscs collided with terrain while on a authorized night tactical flight. The copilot did not meet the currency standards as required by uscs and was not qualified in the acft. The flight originated during the daylight hours and…

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

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

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