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

## Cases, newest first

- [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).
- [NTSB SEA97LA143](https://openairdocs.org/ntsb/SEA97LA143.md): Cessna A188 · Richland, WA · Accident · No injuries · Limited investigation · Final report · Jun 17, 1997 · N9766V · Substantial damage
  > the pilot's failure to maintain airspeed. Inadequate in-flight planning and high obstructions that restricted evasive maneuvers were factors.
- [NTSB LAX97TA213](https://openairdocs.org/ntsb/LAX97TA213.md): Bell 47G-3B-1 · Fallon, NV · Accident · No injuries · Final report · Jun 16, 1997 · N1335X · Substantial damage
  > exhaustion of the aircraft's fuel supply, due to improper planning and/or decision. A factor related to the accident was the high density altitude which made a successful autorotative landing unlikely.
- [NTSB FTW97FA221](https://openairdocs.org/ntsb/FTW97FA221.md): Cessna 172N · Greenbrier, AR · Accident · 2 fatal · Field investigation · Final report · Jun 15, 1997 · N738YG · Destroyed
  > The pilot's failure to maintain aircraft control during a low altitude maneuver. Factors were the pilot's lack of total experience in the type of operation and inadequate training by the company management.
- [NTSB SEA97LA142](https://openairdocs.org/ntsb/SEA97LA142.md): Glaser-Dirks DG-400 · Weston, OR · Accident · No injuries · Limited investigation · Final report · Jun 14, 1997 · N321V · Substantial damage
  > The pilot's failure to attain a proper descent rate during the forced landing. Factors include: the pilot's failure to use an 'engine start' checklist, failure to turn the ignition switch to the 'on' position, failure to use the landing checklist, failure to…
- [NTSB FTW97FA220](https://openairdocs.org/ntsb/FTW97FA220.md): Ayres S2R-T34 · Corning, AR · Accident · 1 fatal · Field investigation · Final report · Jun 14, 1997 · N3103D · Destroyed
  > The in-flight separation of the left wing as result of fatigue crack of the lower spar cap due to inadequate materials by the manufacturer. A factor was the operator's failure to comply with a published service bulletin on the airframe.
- [NTSB FTW97LA223](https://openairdocs.org/ntsb/FTW97LA223.md): Air Tractor AT-400A · Black Oak, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1997 · N3161J · Destroyed
  > The loss of engine power due to compressor turbine blade failure. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL97LA086](https://openairdocs.org/ntsb/ATL97LA086.md): McDonnell Douglas MDHC-369E · Okahumpka, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 1997 · N765KV · No damage
  > The failure of the crewmember to use the necessary safety equipment, and his subsequent fall from an elevated platform. A factor was the crewmember's distraction with an animal.
- [NTSB FTW97LA217](https://openairdocs.org/ntsb/FTW97LA217.md): Bell 206L-3 · Weston, CO · Accident · No injuries · Limited investigation · Final report · Jun 12, 1997 · N207DS · Substantial damage
  > the pilot's improper in-flight planning/decision and failure to maintain adequate altitude and/or clearance from rising mountainous/hilly terrain. The unfavorable wind condition and low airspeed were related factors.
- [NTSB SEA97LA136](https://openairdocs.org/ntsb/SEA97LA136.md): Staudacher S-260-2 · Wallace, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 1997 · N540S · Substantial damage
  > the pilot's improper planning/decision, which resulted in his failure to maintain adequate altitude/distance from wooded terrain during a low-altitude course reversal. Related factors include mountainous/hilly terrain, blind canyon, low ceiling, and trees in…
- [NTSB LAX97LA206](https://openairdocs.org/ntsb/LAX97LA206.md): Bell UH-1B · Heron, CA · Accident · No injuries · Limited investigation · Final report · Jun 11, 1997 · N888SJ · Destroyed
  > partial loss of engine power for undetermined reasons. A factor relating to the accident was that the engine lost power when the helicopter was outside (below) the limits of the height/velocity curve.
- [NTSB IAD97LA086](https://openairdocs.org/ntsb/IAD97LA086.md): Luscombe LL-8-A · Annapolis, MD · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 1997 · N37095 · Destroyed
  > the pilot's failure to use carburetor heat, which resulted in accumulation of carburetor ice and subsequent loss of engine power. Related factors were: carburetor icing conditions, and trees in the emergency landing area.
- [NTSB LAX97GA205](https://openairdocs.org/ntsb/LAX97GA205.md): Rockwell OV-10A · Hollister, CA · Accident · 1 fatal · Final report · Jun 10, 1997 · N94LM · Destroyed
  > the pilot's failure to maintain adequate ground clearance altitude while performing a low-level aerobatic maneuver. A factor in the accident was the pilot's lack of experience in the aircraft.
- [NTSB NYC97LA121](https://openairdocs.org/ntsb/NYC97LA121.md): Robbins Kolb Firestar · Gilbertsville, PA · Accident · 1 fatal · Limited investigation · Final report · Jun 9, 1997 · UNREG · Substantial damage
  > The noncertificated operator's improper decision to fly low over a congested area, which resulted in an abrupt maneuver to avoid a collision with a tethered blimp, and the subsequent uncontrolled descent and collision with terrain.
- [NTSB NYC97LA108](https://openairdocs.org/ntsb/NYC97LA108.md): Schweizer SGS 135 · Pepperell, MA · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 1997 · N17976 · Substantial damage
  > The pilot's failure to maintain airspeed during a turn, which resulted in an inadvertent stall and subsequent uncontrolled descent into water.
- [NTSB LAX97FA202](https://openairdocs.org/ntsb/LAX97FA202.md): Cessna 206 · Saugus, CA · Accident · 1 fatal · Field investigation · Final report · Jun 8, 1997 · N756PU · Destroyed
  > the pilot's failure to maintain an adequate terrain clearance altitude while attempting VFR flight into instrument meteorological conditions.
- [NTSB LAX97LA204](https://openairdocs.org/ntsb/LAX97LA204.md): Bell 204-B · Kaneohe, HI · Accident · No injuries · Limited investigation · Final report · Jun 6, 1997 · N64F · Substantial damage
  > failure of the pilot to verify that the load was properly rigged before attempting to pick it up. The uneven (sloping) terrain was a related factor.
- [NTSB SEA97LA126](https://openairdocs.org/ntsb/SEA97LA126.md): Garlick UH-1H · Addy, WA · Accident · No injuries · Limited investigation · Final report · Jun 3, 1997 · N85NW · Substantial damage
  > The inflight failure of the K-FLEX engine-to-gear box drive shaft and no suitable site in which to make a forced/emergency landing. A factor was the mountainous/hilly terrain.
- [NTSB MIA97FA176](https://openairdocs.org/ntsb/MIA97FA176.md): Cessna 172N · Comerio, PR · Accident · 3 fatal · Field investigation · Final report · Jun 2, 1997 · N4752D · Destroyed
  > the pilot's improper in-flight planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from obstructions on rising terrain.
- [NTSB FTW97FA207](https://openairdocs.org/ntsb/FTW97FA207.md): Canadair F-86E MK.6 · Broomfield, CO · Accident · 1 fatal · Field investigation · Final report · Jun 1, 1997 · N86EX · Destroyed
  > Inadequate planning and decision making by the pilot in starting the aerobatic maneuver at an insufficient altitude to successfully complete the maneuver.
- [NTSB LAX97LA221](https://openairdocs.org/ntsb/LAX97LA221.md): Staudaucher S300D · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · May 31, 1997 · N540DH · Substantial damage
  > The owner/pilot's decision to use automotive hardware, which had not been heat treated, and the practice of adding aluminum plates to the trailing edge of the aileron without rebalancing the flight controls, which resulted in the separation of the aileron at…
- [NTSB FTW97LA212](https://openairdocs.org/ntsb/FTW97LA212.md): Grumman G-164A · Woodsboro, TX · Accident · No injuries · Limited investigation · Final report · May 31, 1997 · N842KG · Substantial damage
  > The loss of engine power as result of fuel exhaustion due to the pilot's failure to refuel the airplane. A factor was the unsuitable terrain available for the pilot to execute the forced landing.
- [NTSB CHI97LA150](https://openairdocs.org/ntsb/CHI97LA150.md): Grumman G164 · Illinois City, IL · Accident · Serious injuries · Limited investigation · Final report · May 29, 1997 · N474Y · Substantial damage
  > failure of the pilot to see and maintain clearance from a static wire. The proximity of the wire was a related factor.
- [NTSB SEA97LA123](https://openairdocs.org/ntsb/SEA97LA123.md): Piper PA-38 · Fruitland, UT · Accident · Minor injuries · Limited investigation · Final report · May 27, 1997 · N2362K · Substantial damage
  > The pilot's failure to maintain clearance from mountainous terrain. Factors include his improper inflight decision to attempt to fly through a mountain pass under high density altitude conditions in an aircraft that was operating near the limits of its…
- [NTSB FTW97LA202](https://openairdocs.org/ntsb/FTW97LA202.md): Piper PA-25-235 · Lamar, CO · Accident · No injuries · Limited investigation · Final report · May 27, 1997 · N4829Y · Substantial damage
  > Failure of the left magneto and crank shaft idler drive gears. Factors were failure to perform a 100 hour inspection and unsuitable terrain for a forced landing.
- [NTSB CHI97FA149](https://openairdocs.org/ntsb/CHI97FA149.md): Bell 206L3 · Boise, ID · Accident · No injuries · Field investigation · Final report · May 27, 1997 · N35CH · Substantial damage
  > the improper torque meter installation by maintenance personnel, attempting flight with known discrepancies by the pilot-in-command and the check airman, and an improper autorotation by the pilot-in-command with improper oversight of the autorotation maneuver…
- [NTSB MIA97FA173](https://openairdocs.org/ntsb/MIA97FA173.md): Cessna 205 · Homestead, FL · Accident · 6 fatal · Field investigation · Final report · May 25, 1997 · N8214Z · Destroyed
  > The pilot-in-command's failure to maintain airspeed as he slowed for a parachutist to jump from the aircraft, and his failure to apply spin recovery emergency procedures prior to ground impact. Contributing to the accident was the pilot-in-command's lack of…
- [NTSB FTW97LA200](https://openairdocs.org/ntsb/FTW97LA200.md): Beech BE-56TC · Spring, TX · Accident · No injuries · Limited investigation · Final report · May 23, 1997 · N7890R · Substantial damage
  > The pilot's failure to perform an adequate preflight (did not remove pitot tube protective covering prior to flight) which resulted in an inaccurate cockpit airspeed indication during takeoff roll and subsequent emergency landing. Factors were, the pilot's…
- [NTSB SEA97LA119](https://openairdocs.org/ntsb/SEA97LA119.md): Garlick UH-1H · Lolo, MT · Accident · No injuries · Limited investigation · Final report · May 22, 1997 · N95NW · Substantial damage
  > Fuel exhaustion due to the pilot's failure to refuel.
- [NTSB MIA97FA172](https://openairdocs.org/ntsb/MIA97FA172.md): Bell 206B · Winter Park, FL · Accident · Serious injuries · Field investigation · Final report · May 22, 1997 · N61PP · Destroyed
  > The pilots improper in-flight planning/decision to conduct an out of ground effect hover with a tailwind resulting in an in-flight loss of directional control due to loss of tailrotor effectiveness/unanticipated right yaw, and subsequent in-flight collision…
- [NTSB SEA97LA117](https://openairdocs.org/ntsb/SEA97LA117.md): Hiller UH-12E · Miltonfreewater, OR · Accident · 1 fatal · Limited investigation · Final report · May 21, 1997 · N3005J · Substantial damage
  > The main rotor blade separated due to fatigue. Factors were: an Airworthiness Directive was not properly performed, and inadequate inspection of the main rotor blades.
- [NTSB ATL97LA073](https://openairdocs.org/ntsb/ATL97LA073.md): Capstaff Challenger II · Southern Pines, NC · Accident · 1 fatal · Limited investigation · Final report · May 21, 1997 · UNREG · Substantial damage
  > The pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain clearance from obstacles.
- [NTSB ANC97LA077](https://openairdocs.org/ntsb/ANC97LA077.md): Cessna 180 · Shaktoolik, AK · Accident · No injuries · Limited investigation · Final report · May 21, 1997 · N24EJ · Substantial damage
  > loss of engine power for undetermined reason(s).
- [NTSB CHI97LA137](https://openairdocs.org/ntsb/CHI97LA137.md): Cessna 152 · Paragon, IN · Accident · Serious injuries · Limited investigation · Final report · May 18, 1997 · N4757B · Destroyed
  > the pilot did not maintain aircraft control. The factors involved were aerobatics were performed and improper use of aircraft.
- [NTSB SEA97LA115](https://openairdocs.org/ntsb/SEA97LA115.md): Robinson R22B · Boise, ID · Accident · No injuries · Limited investigation · Final report · May 16, 1997 · N2328W · Substantial damage
  > improper handling of the helicopter by the student pilot/applicant, during a hover autorotation, which resulted in loss of tail rotor effectiveness. The check pilot's inadequate remedial action was a related factor.
- [NTSB SEA97LA111](https://openairdocs.org/ntsb/SEA97LA111.md): Cessna 150M · Freeland, WA · Accident · Minor injuries · Limited investigation · Final report · May 13, 1997 · N7557A · Substantial damage
  > Fuel exhaustion due to the flight instructor's failure to insure there was proper fuel in the aircraft and the flight instructor's misjudgment of his altitude and airspeed while executing a power-off forced landing in a large open field. Factors include: a…
- [NTSB LAX97LA178](https://openairdocs.org/ntsb/LAX97LA178.md): Robinson R-22 · Santa Margarita, CA · Accident · Minor injuries · Limited investigation · Final report · May 12, 1997 · N83795 · Substantial damage
  > The failure of the pilot to maintain adequate rotor rpm during a low pass maneuvering flight resulting in loss of control. High density altitude was a factor in the accident.
- [NTSB LAX97FA177](https://openairdocs.org/ntsb/LAX97FA177.md): Beech A36TC · Truckee, CA · Accident · 5 fatal · Field investigation · Final report · May 12, 1997 · N6174N · Destroyed
  > failure of the pilot to maintain altitude and clearance above the terrain, while turning (for an unknown reason) back toward the airport after takeoff. Factors relating to the accident were: the environmental conditions (light conditions at dusk and high…
- [NTSB SEA97LA104](https://openairdocs.org/ntsb/SEA97LA104.md): Cessna T188C · Mitchell, OR · Accident · 1 fatal · Limited investigation · Final report · May 10, 1997 · N3152J · Destroyed
  > The pilot's failure to maintain adequate airspeed while maneuvering, which led to a stall. A factor contributing to the accident was the lack of adequate altitude to effect a successful stall recovery.
- [NTSB ATL97LA071](https://openairdocs.org/ntsb/ATL97LA071.md): Piper PA-23-250 · Jacksonville, FL · Accident · Minor injuries · Limited investigation · Final report · May 8, 1997 · N520SM · Substantial damage
  > The pilot's failure to maintain terrain clearance while on a low pass, leading to propeller damage. A factor was birds in the area.
- [NTSB CHI97LA124](https://openairdocs.org/ntsb/CHI97LA124.md): Air Tractor AT-301 · Huron, SD · Accident · No injuries · Limited investigation · Final report · May 7, 1997 · N23640 · Substantial damage
  > The pilot's failure to maintain clearance from known transmission lines.
- [NTSB MIA97FA152](https://openairdocs.org/ntsb/MIA97FA152.md): Bellanca 8KCAB · New Smyrna Bch, FL · Accident · 1 fatal · Field investigation · Final report · May 2, 1997 · N5057F · Substantial damage
  > an in flight loss of control for undetermined reasons.
- [NTSB ATL97LA067](https://openairdocs.org/ntsb/ATL97LA067.md): Hughes 269A · Lake Wales, FL · Accident · No injuries · Limited investigation · Final report · May 1, 1997 · N37754 · Substantial damage
  > loss of engine power for undetermined reason(s); and the flight instructor's improper flare and improper use of the flight controls, while flaring for an autorotative landing.
- [NTSB NYC97LA083](https://openairdocs.org/ntsb/NYC97LA083.md): Porter Stolp SA-750 · E. Huntingdon, PA · Accident · 1 fatal · Limited investigation · Final report · Apr 30, 1997 · N513EP · Destroyed
  > was the pilot's entry into an uncontrolled stall/spin and his inadequate recovery from the maneuver which resulted in collision with terrain. Factors in the accident were the low entry altitude for the maneuver and the pilot's lack of recent flight experience.
- [NTSB LAX97LA173](https://openairdocs.org/ntsb/LAX97LA173.md): Shoaf Christen Eagle II · Half Moon Bay, CA · Accident · 2 fatal · Limited investigation · Final report · Apr 29, 1997 · N61GS · Destroyed
  > undetermined.
- [NTSB IAD97LA069](https://openairdocs.org/ntsb/IAD97LA069.md): Jaquish Challenger Spec II · Mansfield, PA · Accident · Serious injuries · Limited investigation · Final report · Apr 29, 1997 · N9213A · Substantial damage
  > inadequate visual lookout by the pilot, which led to an in-flight collision with an electrical wire. Related factors were: low altitude flight by the pilot, and the proximity of the transmission line.
- [NTSB FTW97LA167](https://openairdocs.org/ntsb/FTW97LA167.md): Grumman-Schweizer G-164A · Hatch, NM · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1997 · N7696 · Substantial damage
  > The pilot's failure to maintain clearance from the wires. A factor was the sunglare.
- [NTSB SEA97FA094](https://openairdocs.org/ntsb/SEA97FA094.md): Smith, Ted Aerostar Aerostar 601P · Klammath Falls, OR · Accident · 1 fatal · Field investigation · Final report · Apr 27, 1997 · N30LL · Substantial damage
  > The pilot's failure to set the throttle of his second failed engine to 'Cracked-1/2-Open' as called for in the Engine Failure/Restart checklist, followed by a high-power engine surge. Factors include the pilot's delay in landing for refueling, the pilot…
- [NTSB CHI97LA114](https://openairdocs.org/ntsb/CHI97LA114.md): Olsen Acro Sport II · Monon, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1997 · N52260 · Substantial damage
  > The loss of engine power for undetermined reasons. Low altitude flight is a contributing factor.
- [NTSB FTW97TA165](https://openairdocs.org/ntsb/FTW97TA165.md): Bell 206-L1 · Trinidad, CO · Accident · Minor injuries · Final report · Apr 23, 1997 · N618DE · Substantial damage
  > The pilot's failure to maintain control of the helicopter due to a loss of tail rotor effectiveness. A factor was the tailwind condition and the pilot's failure to maintain proper airspeed.

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

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

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