# 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 125 of 377 · 18,850 cases

## Cases, newest first

- [NTSB IAD97LA106](https://openairdocs.org/ntsb/IAD97LA106.md): Robinson R22 Beta · Willimantic, CT · Accident · No injuries · Limited investigation · Final report · Aug 6, 1997 · N717GT · Substantial damage
  > The student pilot misunderstood the flight instructor's instructions and reduced the engine power to idle, and the Certificated Flight Instructor's delayed remedial action.
- [NTSB ANC97LA117](https://openairdocs.org/ntsb/ANC97LA117.md): Piper PA-18 · Farewell, AK · Accident · No injuries · Limited investigation · Final report · Aug 5, 1997 · N1606A · Substantial damage
  > the pilot's failure to maintain adequate control of the airplane resulting in an inadvertent stall/mush at low altitude. Factors to the accident were the pilot's low altitude flight maneuver and the gusty winds.
- [NTSB CHI97LA235](https://openairdocs.org/ntsb/CHI97LA235.md): Cessna A188A · Norfolk, NE · Accident · No injuries · Limited investigation · Final report · Aug 3, 1997 · N9902G · Substantial damage
  > the pilot's improper in-flight planning/decision, and failure or inability to control the airplane after encountering wake turbulence at low altitude during an aerial application maneuver. A related factor was the low altitude of the airplane when the wake…
- [NTSB FTW97LA300](https://openairdocs.org/ntsb/FTW97LA300.md): Poor Boys Toys Exec 90 · Patricia, TX · Accident · No injuries · Limited investigation · Final report · Aug 1, 1997 · N596PB · Substantial damage
  > The failure of the pilot to maintain terrain clearance with the crops during a surveying flight. A factor was the pilots diverted attention.
- [NTSB FTW97LA291](https://openairdocs.org/ntsb/FTW97LA291.md): Piper PA-28-180 · Abernathy, TX · Accident · No injuries · Limited investigation · Final report · Jul 31, 1997 · N32185 · Substantial damage
  > The pilot's failure to use carburetor heat during serious carburetor icing conditions, and the flight instructor's inadequate supervision. Factors were the icing conditions and the lack of suitable terrain for the forced landing.
- [NTSB SEA97FA178](https://openairdocs.org/ntsb/SEA97FA178.md): Cessna 172M · Clackamas, OR · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1997 · N80222 · Substantial damage
  > The pilot's failure to maintain adequate airspeed in a steep turn and his concurrent failure to maintain adequate altitude, resulting in an accelerated stall at an altitude insufficient for recovery. Factors include the pilot's intentional low altitude flight…
- [NTSB MIA97LA221](https://openairdocs.org/ntsb/MIA97LA221.md): Cessna 188 · Benson, NC · Accident · No injuries · Limited investigation · Final report · Jul 28, 1997 · N53240 · Destroyed
  > The pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with a cable, subsequent loss of engine power, forced landing, and an in-flight collision with terrain. Contributing to the accident was a total loss of…
- [NTSB LAX97FA259](https://openairdocs.org/ntsb/LAX97FA259.md): Piper J3C-85 · Bullhead City, AZ · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1997 · N3339N · Destroyed
  > improper judgement of the pilot by intentionally performing low level maneuvers, and his misjudgment of a level-off over water.
- [NTSB CHI97LA228](https://openairdocs.org/ntsb/CHI97LA228.md): Cessna 188B · Halstead, KS · Accident · No injuries · Limited investigation · Final report · Jul 28, 1997 · N4864Q · Substantial damage
  > the pilot failed to maintain adequate clearance from the transmission wires. Factors included the malfunctioning of the wire cutter and pilot fatigue.
- [NTSB CHI97LA225](https://openairdocs.org/ntsb/CHI97LA225.md): Sorrell SNS-7 · Tomahawk, WI · Accident · No injuries · Limited investigation · Final report · Jul 27, 1997 · N774HB · Destroyed
  > The pilot encountered a tailplane stall. The factors involved were the pilot conducted a low altitude flight maneuver and encountered engine torque effect.
- [NTSB SEA97LA177](https://openairdocs.org/ntsb/SEA97LA177.md): Cessna 182G · Big Creek, ID · Accident · 2 fatal · Limited investigation · Final report · Jul 25, 1997 · N3134S · Destroyed
  > The flightcrew's failure to maintain clearance from trees. A factor was trees north of the departure end of the airstrip.
- [NTSB LAX97LA248](https://openairdocs.org/ntsb/LAX97LA248.md): Bell 47G-2 · Buttonwillow, CA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1997 · N919SF · Destroyed
  > failure of the pilot to maintain adequate clearance from a utility pole (obstruction) during aerial application. The obstruction was a related factor.
- [NTSB IAD97LA102](https://openairdocs.org/ntsb/IAD97LA102.md): Lardas Renegade Spirit · Boonsboro, MD · Accident · 1 fatal · Limited investigation · Final report · Jul 21, 1997 · N416RS · Destroyed
  > The pilot's failure to maintain control of his homebuilt airplane during a low level maneuver after a loss of engine power due to undetermined reasons. A factor in the accident was the pilot's alcohol impairment.
- [NTSB FTW97LA276](https://openairdocs.org/ntsb/FTW97LA276.md): Gulfstream-Schweizer G-164B · Palestine, AR · Accident · No injuries · Limited investigation · Final report · Jul 21, 1997 · N8031K · Destroyed
  > The pilot's failure to maintain clearance with the wire transmission line due to his diverted attention.
- [NTSB SEA97LA172](https://openairdocs.org/ntsb/SEA97LA172.md): Grumman G-164A · Pingree, ID · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 1997 · N6550 · Destroyed
  > The pilot-in-command's failure to maintain adequate clearance with the power lines. A contributing factor was the unmarked power lines.
- [NTSB SEA97LA171](https://openairdocs.org/ntsb/SEA97LA171.md): Hughes 269C · Yamhill, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1997 · N1105B · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB FTW97FA274](https://openairdocs.org/ntsb/FTW97FA274.md): Hillam Rans S-9 · Mckinney, TX · Accident · 1 fatal · Field investigation · Final report · Jul 20, 1997 · N1678N · Destroyed
  > loss of engine power for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering for a forced landing, which resulted in a stall and collision with the terrain.
- [NTSB ATL97LA107](https://openairdocs.org/ntsb/ATL97LA107.md): Piper J3C-65 · Leesburg, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 1997 · N98879 · Substantial damage
  > the pilot's inadvertent entry into a secondary stall and spin, as engine power faltered during application of power, while recovering from an intentional stall. The hesitation (faltering) of power and the pilot's diverted attention were related factors.
- [NTSB ATL97LA106](https://openairdocs.org/ntsb/ATL97LA106.md): Bellanca 8GCBC · Bunnell, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1997 · N4138Y · Substantial damage
  > the pilot's failure to ensure the airplane had adequate airspeed for banner pickup/towing operations, which resulted in a stall/mush and subsequent contact with the terrain.
- [NTSB NYC97GA148](https://openairdocs.org/ntsb/NYC97GA148.md): Schweizer 269C · Baltimore, MD · Accident · Serious injuries · Final report · Jul 18, 1997 · N6129Q · Destroyed
  > A total loss of engine power which was a result of incomplete and improper engine overhaul by company maintenance personnel. A factor in the accident was the unsuitable forced landing area terrain.
- [NTSB LAX97LA257](https://openairdocs.org/ntsb/LAX97LA257.md): Fronsman Rotorway Exec · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1997 · N6323F · Destroyed
  > an undetermined failure of the oil system (lines or filter), while hovering, which resulted in an engine compartment fire that erupted and subsequently destroyed the helicopter after it was landed.
- [NTSB LAX97LA247](https://openairdocs.org/ntsb/LAX97LA247.md): Sikorsky S-58T · Page, AZ · Accident · No injuries · Limited investigation · Final report · Jul 18, 1997 · N47B · Substantial damage
  > an engine failure resulting from the fracture of two power turbine blades, which had been previously subjected to a hot or hung start.
- [NTSB NYC97FA144](https://openairdocs.org/ntsb/NYC97FA144.md): Cessna TR182 · Seaside Heights, NJ · Accident · 2 fatal · Field investigation · Final report · Jul 13, 1997 · N737PK · Destroyed
  > failure of the pilot to maintain sufficient altitude/clearance above water, while maneuvering over the ocean during a dark moonless night. Related factors were: darkness, the pilot's probable illusion of altitude, spatial disorientation, and lack of…
- [NTSB MIA97LA211](https://openairdocs.org/ntsb/MIA97LA211.md): Schweizer SGS-1-26B · Eustis, FL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1997 · N9927J · Destroyed
  > an in-flight separation of the right wing, and subsequent impact with trees. Factors in this accident were thermal lift and turbulence in clouds.
- [NTSB FTW97LA263](https://openairdocs.org/ntsb/FTW97LA263.md): Bronner Steen Skybolt · Brazoria, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1997 · N773HD · Substantial damage
  > a fuel leak at a wobble pump fuel hose clamp, which resulted in loss of fuel and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.
- [NTSB CHI97LA211](https://openairdocs.org/ntsb/CHI97LA211.md): Waco UPF-7 · Springfield, IL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1997 · N30136 · Substantial damage
  > failure of the pilot to maintain safe altitude/clearance from the terrain. Factors relating to this accident were: the hazy weather condition, the resultant difficulty in keeping the other airplane in sight, and the pilot's diverted attention, while looking…
- [NTSB FTW97FA262](https://openairdocs.org/ntsb/FTW97FA262.md): Ryan Navion B · Garfield, CO · Accident · 4 fatal · Field investigation · Final report · Jul 11, 1997 · N5401K · Destroyed
  > failure of the pilot to maintain adequate airspeed, during a turn to reverse direction, which resulted in a stall and collision with a pole and a building. High density altiitude was a related factor.
- [NTSB SEA97LA164](https://openairdocs.org/ntsb/SEA97LA164.md): Piper PA-18-135 · Biddle, MT · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1997 · N3253B · Destroyed
  > The pilot-in-command's failure to maintain adequate airspeed which resulted in a stall/mush. A factor contributing to the accident was the tailwind condition on takeoff.
- [NTSB LAX97GA235](https://openairdocs.org/ntsb/LAX97GA235.md): Bell BHT-206L-1 · Highland, CA · Accident · 1 fatal · Final report · Jul 7, 1997 · N27591 · Destroyed
  > Loss of engine power due to fuel contamination. Also causal was the ingestion of entrapped air that occurred during an abrupt maneuver and fuel-borne contamination that caused the fuel system check valves to leak, resulted in a lower than expected fuel level…
- [NTSB CHI97LA204](https://openairdocs.org/ntsb/CHI97LA204.md): Grumman-Schweizer G-164B · Donnelly, MN · Accident · No injuries · Limited investigation · Final report · Jul 7, 1997 · N6633K · Substantial damage
  > undetermined event resulting in the broken connecting rod and cylinder.
- [NTSB SEA97LA163](https://openairdocs.org/ntsb/SEA97LA163.md): Piper PA-18-150 · Big Creek, ID · Accident · No injuries · Limited investigation · Final report · Jul 5, 1997 · N4249Z · Substantial damage
  > The pilot-in-command's inadequate terrain clearance and failure to maintain directional control. Also, the overload of the aircraft's left main landing gear strut assembly. Factors contributing to the accident were high density altitude conditions, downdrafts…
- [NTSB CHI97LA194](https://openairdocs.org/ntsb/CHI97LA194.md): Cessna 170B · Karlin, MI · Accident · 2 fatal · Limited investigation · Final report · Jul 5, 1997 · N2416D · Destroyed
  > the pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his inadequate visual lookout while buzzing, which resulted in failure to see-and-avoid the top (ground/static) wires of an electrical power line.
- [NTSB FTW97LA251](https://openairdocs.org/ntsb/FTW97LA251.md): Cessna 172G · Powderly, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1997 · N3888L · Substantial damage
  > The inadvertent stall due to the pilot's diverted attention to an open service door. A factor was the inadequate preflight inspection by the pilot.
- [NTSB FTW97LA252](https://openairdocs.org/ntsb/FTW97LA252.md): Bell 206B · New Iberia, LA · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 1997 · N49661 · Substantial damage
  > the pilot's improper in-flight planning/decision. A related factor was his failure to follow the company procedure of maintaining visual contact with the external long-line cable, while hovering with it attached.
- [NTSB CHI97LA199](https://openairdocs.org/ntsb/CHI97LA199.md): Snow S2C · Viola, IL · Accident · No injuries · Limited investigation · Final report · Jul 3, 1997 · N1684S · Substantial damage
  > the pilot's inadequate preflight planning/preparation by failing to ensure there was an inadequate supply of fuel for the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Uneven terrain in the emergency landing area was a…
- [NTSB CHI97LA193](https://openairdocs.org/ntsb/CHI97LA193.md): Grumman G-164 · Satanta, KS · Accident · No injuries · Limited investigation · Final report · Jul 2, 1997 · N10397 · Substantial damage
  > The pilot did not maintain aircraft control and the reason for the loss of engine power was undetermined.
- [NTSB SEA97LA156](https://openairdocs.org/ntsb/SEA97LA156.md): Stiritz Eipper MX II · Newport, WA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1997 · N15TJ · Substantial damage
  > The failure of the owner/builder to adequately inspect his homebuilt aircraft, which subsequently led to the failure of the right wing lift cable attach bolt and resulted in the collapse of the right wing during flight.
- [NTSB FTW97LA242](https://openairdocs.org/ntsb/FTW97LA242.md): Air Tractor AT-301 · Edna, TX · Accident · No injuries · Limited investigation · Final report · Jun 30, 1997 · N4396S · Substantial damage
  > failure of the pilot to maintain clearance from a guy wire, during a swath run.
- [NTSB ANC97FA092](https://openairdocs.org/ntsb/ANC97FA092.md): Cessna 207A · Nome, AK · Accident · 2 fatal · Field investigation · Final report · Jun 28, 1997 · N207SP · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from an obstruction (antenna tower). Factors in the accident were low ceilings and visibility, and the pilot's lack of familiarity with…
- [NTSB FTW97LA238](https://openairdocs.org/ntsb/FTW97LA238.md): Cessna 305A · Watkins, CO · Accident · No injuries · Limited investigation · Final report · Jun 27, 1997 · N5225G · Destroyed
  > The pilot inadvertently stalling the airplane at an altitude insufficient for a safe recovery. A factor was the tailwind.
- [NTSB CHI97FA187](https://openairdocs.org/ntsb/CHI97FA187.md): Piper PA-22-108 · Lenox Township, MI · Accident · Serious injuries · Field investigation · Final report · Jun 25, 1997 · N4882Z · Substantial damage
  > The pilot's failure to follow the procedures and directives as listed on the placard in the aircraft resulting in fuel starvation and subsequent engine failure.
- [NTSB FTW97LA232](https://openairdocs.org/ntsb/FTW97LA232.md): Aero Commander Callair A-9B · El Indio, TX · Accident · No injuries · Limited investigation · Final report · Jun 23, 1997 · N7684V · Substantial damage
  > the pilot's inadequate preflight, subsequent fuel starvation, and failure of the pilot to reposition the fuel selector to another tank (perform emergency procedure) after the loss of engine power, which resulted in a forced landing and subseqent nose-over.…
- [NTSB NYC97LA125](https://openairdocs.org/ntsb/NYC97LA125.md): Shafer SONERAI-I · W.Hampton Beach, NY · Accident · 1 fatal · Limited investigation · Final report · Jun 22, 1997 · N20CS · 2 aircraft · Destroyed
  > failure of the number two pilot (N77TY) to follow race procedures, and failure of the number three pilot (N20CS) to turn and avoid the number two airplane, when it decelerated into the number three pilot's blind spot.
- [NTSB CHI97LA181](https://openairdocs.org/ntsb/CHI97LA181.md): Cessna 172M · Grosse Ile, MI · Accident · No injuries · Limited investigation · Final report · Jun 22, 1997 · N4491R · Substantial damage
  > the instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.
- [NTSB MIA97LA192](https://openairdocs.org/ntsb/MIA97LA192.md): Unknown Kolb Firestar II · Orlando, FL · Accident · 1 fatal · Limited investigation · Final report · Jun 21, 1997 · UNREG · Substantial damage
  > Inadvertent stall by the pilot while turning from the upwind to the crosswind leg. Contributing to the accident was the pilots lack of total experience in the make and model airplane.
- [NTSB CHI97LA174](https://openairdocs.org/ntsb/CHI97LA174.md): Piper PA-25-235 · Faulkton, SD · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1997 · N7378Z · Destroyed
  > the pilot's inability to see the power lines and the power lines. Factors contributing to this accident were the trees and the sunglare.
- [NTSB SEA97LA147](https://openairdocs.org/ntsb/SEA97LA147.md): Wolf Smith M/P DSA-1 · Bend, OR · Accident · 1 fatal · Limited investigation · Final report · Jun 20, 1997 · N168RW · Destroyed
  > An inflight propeller blade separation, and a subsequent evasive turn to avoid traffic by the pilot at an inadequate airspeed resulting in an accelerated stall. Factors were excessive power output of the installed engine, an aircraft taking off in the…
- [NTSB MIA97LA190](https://openairdocs.org/ntsb/MIA97LA190.md): Schweizer G-164B · Edwards, MS · Accident · No injuries · Limited investigation · Final report · Jun 20, 1997 · N6816Q · Substantial damage
  > failure of the distributor drive gear in the right magneto, resulting in loss of engine power and a forced landing. The lack of suitable terrain for a forced landing was a related factor.
- [NTSB ATL97LA087](https://openairdocs.org/ntsb/ATL97LA087.md): Air Tractor AT-301A · Labelle, FL · Accident · No injuries · Limited investigation · Final report · Jun 20, 1997 · N23728 · Substantial damage
  > failure of the pilot to maintain adequate airspeed during a turn-around maneuver, which resulted in an aerodynamic stall/mush and collision with the terrain.
- [NTSB FTW97FA229](https://openairdocs.org/ntsb/FTW97FA229.md): Air Tractor AT-301 · Las Animas, CO · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1997 · N7308E · Destroyed
  > in-flight collision with terrain, while maneuvering, for undetermined reason(s).

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

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

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