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

## Cases, newest first

- [NTSB LAX92LA105](https://openairdocs.org/ntsb/LAX92LA105.md): Cessna 170B · Austin, NV · Accident · 1 fatal · Limited investigation · Final report · Jan 28, 1992 · N39HP · Substantial damage
  > The pilot's delay in reversing direction, his continued flight into instrument meteorological conditions, his failure to maintain adequate airspeed and inadvertent stall while maneuvering to reverse direction. Contributing to the accident was weather…
- [NTSB MIA92LA069](https://openairdocs.org/ntsb/MIA92LA069.md): Bell 47D1 · Cross City, FL · Accident · No injuries · Limited investigation · Final report · Jan 27, 1992 · N93067 · Substantial damage
  > Partial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the autorotative landing.
- [NTSB MIA92FA059](https://openairdocs.org/ntsb/MIA92FA059.md): Cessna 150L · Lake Alfred, FL · Accident · 2 fatal · Field investigation · Final report · Jan 11, 1992 · N6032J · Destroyed
  > The pilot-in-command's inadvertent accelerated stall while buzzing at an altitude that precluded recovery.
- [NTSB LAX92LA087](https://openairdocs.org/ntsb/LAX92LA087.md): Robinson R22B · Lake Hughes, CA · Accident · No injuries · Limited investigation · Final report · Jan 11, 1992 · N2634N · Substantial damage
  > The failure of the pilot to maintain rotor RPM while maneuvering and his misjudgement of the landing flare. A factor in the accident was the pilot's lack of total experience.
- [NTSB SEA92LA036](https://openairdocs.org/ntsb/SEA92LA036.md): Schweizer SGS-1-35C · Hood River, OR · Accident · No injuries · Limited investigation · Final report · Jan 5, 1992 · N2818H · Destroyed
  > Poor preflight planning and preparation along with the pilot's restricted visibility. Factors to the accident were: clouds and VFR flight into IMC.
- [NTSB CHI92DCJ01](https://openairdocs.org/ntsb/CHI92DCJ01.md): Piper PA-18-125 · Ashby, NE · Accident · 2 fatal · Final report · Jan 5, 1992 · N1217A · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering.
- [NTSB MIA92LA054](https://openairdocs.org/ntsb/MIA92LA054.md): Smith/Davis DA-2A · Holly Springs, MS · Accident · 1 fatal · Limited investigation · Final report · Jan 4, 1992 · N3093 · Destroyed
  > The pilot-in-command's improper management of fuel. This resulted in the airplane experiencing fuel exhaustion, forced landing, and in flight collision with terrain.
- [NTSB FTW92LA054](https://openairdocs.org/ntsb/FTW92LA054.md): Alvin D. Campbell KR-2 · San Marcos, TX · Accident · 2 fatal · Limited investigation · Final report · Jan 4, 1992 · N651AC · Destroyed
  > The modification of the canopy hinge system which resulted in the loss of aircraft control due to an inflight canopy separation.
- [NTSB CHI92FA066](https://openairdocs.org/ntsb/CHI92FA066.md): Piper PA-31P · Mosinee, WI · Accident · 1 fatal · Field investigation · Final report · Jan 2, 1992 · N500BH · Destroyed
  > An inflight fire with the cabin heater as the origin, and unsuitable terrain in which to make a forced landing. A factor related to the accident was the soft terrain.
- [NTSB ANC92LA024](https://openairdocs.org/ntsb/ANC92LA024.md): Piper PA-18 · Nome, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 2, 1992 · N1930A · Substantial damage
  > The pilot inadvertently stalled the airplane. Contributing to the accident was inadequate altitude.
- [NTSB NYC92FA052](https://openairdocs.org/ntsb/NYC92FA052.md): Aeronca 7AC · Salisbury, CT · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1991 · N3103E · Destroyed
  > The pilot's failure to maintain airspeed while performing low altitude aerobatic maneuvers, resulting in a stall with insufficient altitude to recover. Factors related to the accident were the pilot's overconfidence in his ability to perform these maneuvers,…
- [NTSB CHI92FA062](https://openairdocs.org/ntsb/CHI92FA062.md): Cessna 172M · Sanford, MI · Accident · 2 fatal · Field investigation · Final report · Dec 27, 1991 · N6623H · Destroyed
  > The pilot-in-command's failure to maintain a visual lookout to avoid a wire strike. Factors were the pilot-in-command's intentional low level flight, his failure to maintain proper altitude, and the transmission wires.
- [NTSB NYC92FA050](https://openairdocs.org/ntsb/NYC92FA050.md): Beech A36 · Wilmington, OH · Accident · 3 fatal · Field investigation · Final report · Dec 26, 1991 · N236JS · Destroyed
  > The failure of the pilots to maintain adequate terrain clearance. Factors which contributed to the accident were: the night conditions, reduced visibility due to fog, and the likelihood that the pilots diverted their attention to the operation of the loran…
- [NTSB LAX92LA070](https://openairdocs.org/ntsb/LAX92LA070.md): Bellanca 7KCAB · Happy Camp, CA · Accident · 2 fatal · Limited investigation · Final report · Dec 25, 1991 · N1679G · Destroyed
  > The excessive nature of the maneuvers attempted by the pilot at a low altitude during the takeoff initial climb, the failure of the pilot to maintain proper pitch attitude and airspeed to avoid an aerodynamic stall, and inadequate altitude to perfrom…
- [NTSB LAX92FA067](https://openairdocs.org/ntsb/LAX92FA067.md): Cessna 152 · Ventura, CA · Accident · 2 fatal · Field investigation · Final report · Dec 22, 1991 · N69028 · Destroyed
  > The failure of the pilot to maintain adequate altitude above the ground to recover from an inadvertent stall. Contributing to the accident was the pilot's handling of the aircraft specifically an excessive angle of attack which resulted in reduced airspeed…
- [NTSB SEA92LA030](https://openairdocs.org/ntsb/SEA92LA030.md): Artic S-1B2 · Lysite, WY · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 1991 · N71AT · Substantial damage
  > The pilot's failure to maintain clearance with terrain. Factors contributing to the accident were rising terrain, downdrafts, and the pilot's inadequate compensation for wind conditions.
- [NTSB NYC92LA048](https://openairdocs.org/ntsb/NYC92LA048.md): Piper PA-28-140 · Goshen, NY · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1991 · N55685 · Substantial damage
  > The loss of engine power resulting from the ingestion of a foreign object into the carburetor and the subsequent forced landing in trees. A factor related to the accident was the maintenance performed on the airplane by unauthorized personnel.
- [NTSB MIA92LA048](https://openairdocs.org/ntsb/MIA92LA048.md): Piper J-4E · Timmonsville, SC · Accident · Serious injuries · Limited investigation · Final report · Dec 15, 1991 · N38153 · Substantial damage
  > Total loss of engine power (nonmechanical) due to inadequate fuel consumption calculation by the pilot-in-command, resulting in an engine failure due to fuel exhaustion, a forced landing, and in-flight collision with terrain.
- [NTSB FTW92LA047](https://openairdocs.org/ntsb/FTW92LA047.md): Cessna 182D · Carlisle, AR · Accident · No injuries · Limited investigation · Final report · Dec 15, 1991 · N8883X · Substantial damage
  > The parachute jumper's reserve parachute inadvertently opening, for undetermined reasons, resulting in the jumper impacting the right horizontal stabilizer.
- [NTSB MIA92LA042](https://openairdocs.org/ntsb/MIA92LA042.md): Bell 206L-3 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Dec 12, 1991 · N206CM · Substantial damage
  > The pilot in commands failure to maintain tailrotor ground clearance while hovering resulting in the tail striking the ground and the subsequent separation of the tailrotor and gearbox.
- [NTSB CHI92DEV01](https://openairdocs.org/ntsb/CHI92DEV01.md): Quickie Quickie 1 · Carmi, IL · Accident · Serious injuries · Final report · Dec 11, 1991 · N1V · Substantial damage
  > An engine bearing seizure and a premature forced landing flare.
- [NTSB LAX92FA058](https://openairdocs.org/ntsb/LAX92FA058.md): Piper PA31-350 · Temple Bar, AZ · Accident · 5 fatal · Field investigation · Final report · Dec 10, 1991 · N350MR · Destroyed
  > The pilot-in-command's poor inflight decision by not electing to proceed to an alternate airport and to continue to the flight under visual flight rules into instrument meteorological conditions. The low ceilings and visibilities across the flight route and…
- [NTSB FTW92LA038](https://openairdocs.org/ntsb/FTW92LA038.md): Cessna 172B · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Dec 5, 1991 · N6947X · Substantial damage
  > Clearance was not maintained and the airplane struck a wire. A factor was the aircraft had been stolen by two unknown individuals.
- [NTSB LAX92LA046](https://openairdocs.org/ntsb/LAX92LA046.md): Bellanca 7ECA · Fremont, CA · Accident · 2 fatal · Limited investigation · Final report · Nov 19, 1991 · N36243 · Destroyed
  > The pilot-in-command's failure to maintain an airspeed above the stall speed. His over confidence in his personal ability, lack of familiarity with the aircraft, and his inadequate training in acrobatic flight were factors in the accident.
- [NTSB MIA92LA031](https://openairdocs.org/ntsb/MIA92LA031.md): Robinson R22 Mariner · Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 17, 1991 · N4072U · Substantial damage
  > The pilot-in-command's improper use of collective control and throttle during recovery from an autorotation which resulted in loss of rotor RPM and a subsequent hard landing.
- [NTSB FTW92FA022](https://openairdocs.org/ntsb/FTW92FA022.md): Cessna 310C · Waller, TX · Accident · 2 fatal · Field investigation · Final report · Nov 16, 1991 · N6704T · Destroyed
  > The loss of directional control as result of the velocity minimum control airspeed not being maintained. A factor was that the maneuver was initiated at an inadequate altitude too low for the pilot to recover.
- [NTSB MIA92LA029](https://openairdocs.org/ntsb/MIA92LA029.md): WSK PZL Mielec PZL-M-18 · Florida City, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 1991 · N4506K · Substantial damage
  > Partial loss of engine power due to a loose intake manifold. Also, improper maintenance by an unknown person.
- [NTSB MIA92LA028](https://openairdocs.org/ntsb/MIA92LA028.md): Schweizer SGS 2-33A · Groveland, FL · Accident · No injuries · Limited investigation · Final report · Nov 14, 1991 · N2890H · Substantial damage
  > Poor in-flight planning/decision by the pilot-in-command resulting in the off airport landing. Contributing to the accident was his lack of total experience.
- [NTSB CHI92FA027](https://openairdocs.org/ntsb/CHI92FA027.md): Piper PA-24-180 · Coffeyville, KS · Accident · 2 fatal · Field investigation · Final report · Nov 14, 1991 · N5935P · Destroyed
  > The pilot's failure to maintain sufficient airspeed (above stall speed) during the emergency procedure. Related factors are the pilot's poor planning/decision, inattentiveness, and the weather (low ceiling, gusty tailwinds).
- [NTSB LAX92LA041](https://openairdocs.org/ntsb/LAX92LA041.md): Bell 206B · Hilo, HI · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 1991 · N16712 · Substantial damage
  > The inadvertent encounter with a loss of tail rotor effectiveness phenomena and the resultant pilot inflight loss of control.
- [NTSB MIA92GA024](https://openairdocs.org/ntsb/MIA92GA024.md): Cessna 172N · Okeechobee, FL · Accident · 1 fatal · Final report · Nov 8, 1991 · N739WS · Destroyed
  > The pilot-in-command's failure to maintain altitude during a low pass at night. Contributing factors were the pilot's likely spatial disorientation due to the lack of surface visual clues, the dark night conditions, and the patchy fog conditions.
- [NTSB ANC92LA014](https://openairdocs.org/ntsb/ANC92LA014.md): Cessna 170 · Whiskey Gulch, AK · Accident · No injuries · Limited investigation · Final report · Nov 7, 1991 · N2584V · Substantial damage
  > The pilot's failure to maintain an airspeed above stalling during maneuvering flight. A factor relating to the accident was operating at an altitude inadequate in which to effect recovery.
- [NTSB LAX92LA039](https://openairdocs.org/ntsb/LAX92LA039.md): Cessna 172P · Williams, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1991 · N5337K · Destroyed
  > The pilot's failure to maintain visual lookout.
- [NTSB NYC92FA026](https://openairdocs.org/ntsb/NYC92FA026.md): Piper L-3 · Plymouth, MA · Accident · 2 fatal · Field investigation · Final report · Nov 3, 1991 · N6AN · Destroyed
  > The improper decision by the non-instrument-rated pilot to attempt VFR flight in instrument meteorological conditions, at a low altitude, which resulted in a collision with the water. Factors related to the accident were: the overconfidence of the pilot in…
- [NTSB NYC92LA024](https://openairdocs.org/ntsb/NYC92LA024.md): Maule M5-235C · Jim Thorpe, PA · Accident · No injuries · Limited investigation · Final report · Nov 2, 1991 · N5634K · Substantial damage
  > The pilot's improper use of carburetor heat, resulting in carburetor ice and a loss of engine power and subsequent forced landing in trees. A factor related to the accident was the pilot's lack of experience in this make and model airplane.
- [NTSB CHI92FA022](https://openairdocs.org/ntsb/CHI92FA022.md): Rockwell AC 690B · Milton, KS · Accident · 2 fatal · Field investigation · Final report · Nov 2, 1991 · N799V · Destroyed
  > Incapacitation of the pilot in command, followed by the loss of control and an inflight breakup with a unqualified person on the controls.
- [NTSB BFO92FA005](https://openairdocs.org/ntsb/BFO92FA005.md): Piper PA-28-180 · West Wardsboro, VT · Accident · 1 fatal · Field investigation · Final report · Oct 31, 1991 · N8855J · Destroyed
  > The pilot's flight into known adverse weather. Contributing to the accident was the pilot's inadequate flight and weather planning.
- [NTSB FTW92FA014](https://openairdocs.org/ntsb/FTW92FA014.md): Beech A36 · Marble Falls, TX · Accident · 2 fatal · Field investigation · Final report · Oct 27, 1991 · N7246H · Destroyed
  > The pilot's performance of acrobatic maneuvers at an altitude too low to allow for recovery.
- [NTSB MIA92FA017](https://openairdocs.org/ntsb/MIA92FA017.md): Cessna 152 · Valkaria, FL · Accident · Serious injuries · Field investigation · Final report · Oct 26, 1991 · N24431 · Destroyed
  > The pilot-in-command's failure to maintain altitude while maneuvering. This resulted in the pilot becoming spatially disoriented and an in-flight collision with terrain. Contributing to the accident was the pilot's decision to operate the airplane with known…
- [NTSB LAX92FA025](https://openairdocs.org/ntsb/LAX92FA025.md): Aerospatiale AS350B · Scottsdale, AZ · Accident · Minor injuries · Field investigation · Final report · Oct 26, 1991 · N9001S · Substantial damage
  > An undetermined malfunction of the hydraulic system in which the system was locked, preventing the movement of the flight controls, and loss of directional control.
- [NTSB NYC92DHA01](https://openairdocs.org/ntsb/NYC92DHA01.md): Jesse Knight Long EZ · Milford, PA · Accident · 1 fatal · Final report · Oct 23, 1991 · N172JK · Substantial damage
  > The pilot's inadequate visual lookout.
- [NTSB ATL92LA015](https://openairdocs.org/ntsb/ATL92LA015.md): Bellanca 8JCAB · Morristown, TN · Accident · No injuries · Limited investigation · Final report · Oct 20, 1991 · N3770 · Substantial damage
  > The pilot's failure to maintain a proper altitude during a low pass. A factor in this accident was the pilot's overconfidence in his personal ability.
- [NTSB ATL92LA012](https://openairdocs.org/ntsb/ATL92LA012.md): Don Jackman Pitts S-1S · Franklinville, NC · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1991 · N4241Z · Substantial damage
  > The failure of the pilot to maintain proper clearance from the power line.
- [NTSB SEA92FA013](https://openairdocs.org/ntsb/SEA92FA013.md): Cessna 172N · Columbus, MT · Accident · 3 fatal · Field investigation · Final report · Oct 18, 1991 · N733QL · Destroyed
  > The pilot in command's operation at too low an altitude over the river and his failure to maintain adequate clearance from the power lines. Factors contributing to the accident were the wires crossing the river and the pilot in command's poor judgement in…
- [NTSB SEA92FA222](https://openairdocs.org/ntsb/SEA92FA222.md): Maule M-5-235C · Moran, WY · Accident · 3 fatal · Field investigation · Final report · Oct 16, 1991 · N19AR · Destroyed
  > The pilot's failure to maintain clearance and altitude from terrain while maneuvering, and his failure to adequately compensate for the wind conditions. Factors contributing to the accident are terrain-induced turbulence, unfavorable winds, gusty high winds,…
- [NTSB LAX92LA014](https://openairdocs.org/ntsb/LAX92LA014.md): Aerospatiale AS-350D · Hilo, HI · Accident · No injuries · Limited investigation · Final report · Oct 14, 1991 · N35961 · Substantial damage
  > 1) A loss of engine power due to the ingestion of gasses from the active volcano vent, and 2) the pilots inflight decision to hover downwind in close proximity to the vent.
- [NTSB DEN92LA003](https://openairdocs.org/ntsb/DEN92LA003.md): Piper PA-18-150 · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Oct 13, 1991 · N4488Z · Substantial damage
  > The pilot flying the aircraft at a height above ground level which was inadequate for recovery from an encounter with down drafts. A factor was: down draft encounter.
- [NTSB SEA92LA005](https://openairdocs.org/ntsb/SEA92LA005.md): Hughes 269B · Hillsboro, OR · Accident · No injuries · Limited investigation · Final report · Oct 12, 1991 · N9474F · Substantial damage
  > The failure to maintain rotor RPM. Factors include inadequate preflight planning, overconfidence in aircraft's ability, and non-suitable terrain.
- [NTSB FTW92DPJ02](https://openairdocs.org/ntsb/FTW92DPJ02.md): Piper PA-25 · Warner, OK · Accident · 1 fatal · Final report · Oct 10, 1991 · N8516L · Destroyed
  > The complete loss of engine power for undetermined reason.
- [NTSB MIA92FA008](https://openairdocs.org/ntsb/MIA92FA008.md): Bellanca 7GCBC · Key West, FL · Accident · 2 fatal · Field investigation · Final report · Oct 8, 1991 · N4155Y · Substantial damage
  > Failure of the pilot to maintain airspeed, which resulted in an inadvertent stall/spin at an altitude that was too low for recovery. A factor related to the accident was: the pilot's failure to jettison the banner when the stall was encountered.

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

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

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