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

## Cases, newest first

- [NTSB ANC06CA127](https://openairdocs.org/ntsb/ANC06CA127.md): Cessna 172 · Healy, AK · Accident · No injuries · Data collection · Final report · Aug 30, 2006 · N5375R · Substantial damage
  > The pilot's failure to maintain adequate altitude/clearance while maneuvering, which resulted in an in-flight collision with terrain. Factors associated with the accident were rising terrain, and the pilot's low altitude flight.
- [NTSB NYC06CA213](https://openairdocs.org/ntsb/NYC06CA213.md): Robinson R22 Beta · Frederick, MD · Accident · No injuries · Data collection · Final report · Aug 28, 2006 · N2649D · Substantial damage
  > The flight instructor's delayed remedial action during a hovering autorotation, which resulted in a hard landing and inadvertent dynamic rollover.
- [NTSB LAX06LA275](https://openairdocs.org/ntsb/LAX06LA275.md): Terry Tevis RV-6A · Novato, CA · Accident · 2 fatal · Limited investigation · Final report · Aug 28, 2006 · N312RV · Substantial damage
  > The pilot's failure to maintain terrain clearance while maneuvering. Rising terrain, fog and dark night conditions were factors.
- [NTSB CHI06CA247](https://openairdocs.org/ntsb/CHI06CA247.md): Piper J-3C-65 · Bayfield, WI · Accident · Minor injuries · Data collection · Final report · Aug 27, 2006 · N76JS · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering which resulted in a stall. A factor associated with the accident was the low altitude at which the airplane stalled.
- [NTSB LAX06LA271](https://openairdocs.org/ntsb/LAX06LA271.md): Boeing E75 · Morgan Hill, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 2006 · N58980 · Substantial damage
  > Excessive fuel flow through the carburetor which resulted in leaking fuel, and subsequent in-flight fire while maneuvering.
- [NTSB DEN06LA116](https://openairdocs.org/ntsb/DEN06LA116.md): Baker RV-3AB · Laramie, WY · Accident · 1 fatal · Limited investigation · Final report · Aug 24, 2006 · N43EM · Destroyed
  > The in-flight failure of the right wing spar during aerobatic flight. Contributing to the accident was the owner/operator's failure to comply with the service bulletin issued by the kit manufacturer.
- [NTSB CHI06CA242](https://openairdocs.org/ntsb/CHI06CA242.md): Bell 47G-5 · Sanborn, ND · Accident · No injuries · Data collection · Final report · Aug 23, 2006 · N2251W · Substantial damage
  > The pilot's failure to maintain clearance from the power lines during the aerial application flight. The power lines were a factor.
- [NTSB LAX06CA285](https://openairdocs.org/ntsb/LAX06CA285.md): Beech 99 · Lodi, CA · Accident · Serious injuries · Data collection · Final report · Aug 22, 2006 · N205TC · Substantial damage
  > the failure of the skydiver to correctly follow procedures and directives on exiting the airplane properly, which resulted in his collision with the horizontal stabilizer.
- [NTSB DEN06FA115](https://openairdocs.org/ntsb/DEN06FA115.md): Stallings VariEze · Loveland, CO · Accident · 2 fatal · Field investigation · Final report · Aug 20, 2006 · N23HS · Destroyed
  > the pilot's intentional aerobatics performed at low altitude, and his failure to maintain clearance from terrain. A contributing factor was the pilot's poor judgment.
- [NTSB SEA06LA164](https://openairdocs.org/ntsb/SEA06LA164.md): Bellanca 8GCBC · Townsend, MT · Accident · Serious injuries · Limited investigation · Final report · Aug 19, 2006 · N4109Y · Substantial damage
  > The pilot's failure to maintain terrain clearance while intentionally maneuvering low to the ground.
- [NTSB SEA06LA162](https://openairdocs.org/ntsb/SEA06LA162.md): Kaman HH-43F · Metaline Falls, WA · Accident · 1 fatal · Limited investigation · Final report · Aug 18, 2006 · N559D · Destroyed
  > The failure of the left-hand cross-shaft input internal spline while the helicopter was in a hover, which resulted in the loss of gear box timing, in-flight blade contact and separation, and the subsequent loss of control and impact with a log deck.
- [NTSB CHI06LA240](https://openairdocs.org/ntsb/CHI06LA240.md): Cessna A188B · Rolla, ND · Accident · No injuries · Limited investigation · Final report · Aug 18, 2006 · N9224R · Substantial damage
  > The pilot's failure to maintain clearance from terrain during the aerial-application flight, and the loss of engine power due to the overstress failure of the engine crankshaft sustained during ground impact. Contributing to the accident was the low-altitude…
- [NTSB NYC06FA205](https://openairdocs.org/ntsb/NYC06FA205.md): Scheibe SF-28A · Canandaigua, NY · Accident · 1 fatal · Field investigation · Final report · Aug 17, 2006 · N14KG · Substantial damage
  > The private pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and impact with trees. Factors were the FAA inspector's delayed remedial action, and his lack of experience in the make and model motorglider.
- [NTSB LAX06LA262](https://openairdocs.org/ntsb/LAX06LA262.md): Extra Flugzeugbau EA-300 · Mojave, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 2006 · N12DW · Substantial damage
  > the pilot's failure to maintain an adequate airspeed while performing low-level aerobatics that resulted in an inadvertent accelerated stall and in-flight collision with terrain.
- [NTSB CHI06CA233](https://openairdocs.org/ntsb/CHI06CA233.md): Hoyt Kolb Mark III Clsc · Lakeville, MN · Accident · No injuries · Data collection · Final report · Aug 15, 2006 · N232S · Substantial damage
  > The pilot's failure to maintain clearance from the crops which resulted in the subsequent impact with the ground.
- [NTSB SEA06GA158](https://openairdocs.org/ntsb/SEA06GA158.md): Eurocopter AS-350-B3 · Yellow Pine, ID · Accident · 4 fatal · Final report · Aug 13, 2006 · N355EV · Destroyed
  > The pilot's intentional low altitude flight and his failure to maintain an adequate altitude to clear the trees.
- [NTSB SEA06FA159](https://openairdocs.org/ntsb/SEA06FA159.md): Robinson R44 II · Warrenton, OR · Accident · 3 fatal · Field investigation · Final report · Aug 13, 2006 · N168PT · Destroyed
  > The pilot's intentional flight into instrument meteorological conditions while maneuvering which resulted in an in flight collision with terrain/water.
- [NTSB MIA06LA127](https://openairdocs.org/ntsb/MIA06LA127.md): American Champion 7EC · Palmetto, FL · Accident · No injuries · Limited investigation · Final report · Aug 12, 2006 · N9898B · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering which resulted in a stall.
- [NTSB ANC06CA114](https://openairdocs.org/ntsb/ANC06CA114.md): Cessna 172 · Palatka, FL · Accident · No injuries · Data collection · Final report · Aug 12, 2006 · N2469U · Substantial damage
  > The student's failure to maintain adequate airspeed to preclude a stall while maneuvering over the runway, and the instructor's inadequate supervision of the student pilot, which resulted in a collision with the runway. A factor in the accident was an…
- [NTSB SEA06CA161](https://openairdocs.org/ntsb/SEA06CA161.md): Bell 206L-3 · Salt Lake City, UT · Accident · No injuries · Data collection · Final report · Aug 11, 2006 · N206UH · Substantial damage
  > The failure of the pilot to maintain clearance by allowing the helicopter to drift backwards, resulting in its tail rotor striking a hangar.
- [NTSB DFW06LA198](https://openairdocs.org/ntsb/DFW06LA198.md): Ayres S2R-T34 · Parkdale, AR · Accident · No injuries · Limited investigation · Final report · Aug 11, 2006 · N444HF · Substantial damage
  > The failure of a compressor turbine blade for undetermined reasons, which resulted in a total loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX06LA257](https://openairdocs.org/ntsb/LAX06LA257.md): Robinson R22 Beta · Tucson, AZ · Accident · 1 fatal · Limited investigation · Final report · Aug 10, 2006 · N7059S · Substantial damage
  > The pilot's failure to maintain adequate rotor rpm and adequate terrain clearance while maneuvering to reverse direction. Contributing factors were the high density altitude, that exceeded the helicopter's performance capability, and the rising mountainous…
- [NTSB CHI06CA235](https://openairdocs.org/ntsb/CHI06CA235.md): Grumman-Schweizer G-164A · Gering, NE · Accident · No injuries · Data collection · Final report · Aug 10, 2006 · N48461 · Substantial damage
  > The pilot's failure to maintain clearance from the power lines during the aerial application flight. Factors were the low altitude and power lines.
- [NTSB CHI06CA225](https://openairdocs.org/ntsb/CHI06CA225.md): Weatherly 620B · Sioux Center, IA · Accident · No injuries · Data collection · Final report · Aug 8, 2006 · N9012P · Substantial damage
  > The pilot's mismanagement of the fuel system which resulted in the loss of engine power due to fuel starvation and his failure to maintain aircraft control during the subsequent forced landing. A factor to the accident was the soybean crop.
- [NTSB DEN06FA111](https://openairdocs.org/ntsb/DEN06FA111.md): Piper PA-28R-201 · Salida, CO · Accident · 1 fatal · Field investigation · Final report · Aug 7, 2006 · N6506C · Substantial damage
  > the pilot's inadequate preflight planning/preparation. Contributing factors in this accident were the pilot's lack of familiarity with the geographical area, his becoming lost/disoriented, his improper decision, the high density altitude, and the reduction in…
- [NTSB LAX06LA255](https://openairdocs.org/ntsb/LAX06LA255.md): Air Tractor AT-502 · Chowchilla, CA · Accident · 1 fatal · Limited investigation · Final report · Aug 5, 2006 · N502WQ · Substantial damage
  > The pilot's loss of control while maneuvering resulting from an incapacitating physiological event.
- [NTSB LAX06GA254](https://openairdocs.org/ntsb/LAX06GA254.md): Aviation International Rotors CH-54A · Happy Camp, CA · Accident · 2 fatal · Final report · Aug 5, 2006 · N6156U · Substantial damage
  > The fatigue failure of tail rotor blade spindle, which resulted in the separation of the blade and tail rotor gearbox.
- [NTSB CHI06CA219](https://openairdocs.org/ntsb/CHI06CA219.md): Shempp-Hirth Discuss B · Tipton, IN · Accident · Serious injuries · Data collection · Final report · Aug 5, 2006 · N888TK · Minor damage
  > The glider pilot's improper in-flight decision to continue searching for thermal lift, instead of landing when the glider was in range of a suitable landing area. Contributing factors to the accident was the lack of thermal lift which resulted in a hard…
- [NTSB NYC06LA193](https://openairdocs.org/ntsb/NYC06LA193.md): Piper PA-25 · Egg Harbor Twp, NJ · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 2006 · N6471Z · Substantial damage
  > The pilot's failure to utilize carburetor heat during the descent, which resulted in the formation of carburetor ice and subsequent engine failure. A factor in the accident was the carburetor icing conditions.
- [NTSB DFW06LA195](https://openairdocs.org/ntsb/DFW06LA195.md): Cessna A188B · Sumrall, MS · Accident · 1 fatal · Limited investigation · Final report · Aug 4, 2006 · N86188 · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the partial loss of engine power and the low altitude.
- [NTSB CHI06LA223](https://openairdocs.org/ntsb/CHI06LA223.md): Piper PA-25-235 · Underwood, ND · Accident · 1 fatal · Limited investigation · Final report · Aug 3, 2006 · N4693Y · Substantial damage
  > The pilot's failure to maintain clearance with the power line during the aerial application flight.
- [NTSB LAX06CA276](https://openairdocs.org/ntsb/LAX06CA276.md): Interstate S-1A · Buckeye, AZ · Accident · No injuries · Data collection · Final report · Aug 1, 2006 · N28332 · Substantial damage
  > the in-flight separation of the control stick. A contributing factor was the rough terrain for the forced landing, which resulted in a collapsed landing gear.
- [NTSB ANC06LA105](https://openairdocs.org/ntsb/ANC06LA105.md): American Champion 8GCBC · Anchorage, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2006 · N35RF · Substantial damage
  > The flight instructor's failure to maintain sufficient airspeed to avoid a stall during a turn to reverse direction, which resulted in an inadvertent stall and a loss of control. Factors associated with the accident are the inadvertent stall, and the flight…
- [NTSB DEN06FA107](https://openairdocs.org/ntsb/DEN06FA107.md): American Champion 7KCAB · Winter Park, CO · Accident · 2 fatal · Field investigation · Final report · Jul 30, 2006 · N5232X · Destroyed
  > The pilot's failure to maintain adequate airspeed to avoid a stall while maneuvering at a low altitude in mountainous terrain. Factors associated with the accident are the pilot's performance of a low altitude flight maneuver, an inadvertent stall/spin, and…
- [NTSB CHI06CA222](https://openairdocs.org/ntsb/CHI06CA222.md): Rockwell S2R · Park Rapids, MN · Accident · Minor injuries · Data collection · Final report · Jul 30, 2006 · N7982V · Substantial damage
  > A loss of engine power for undetermined reasons and the inadequate airspeed during the forced landing which resulted in a stall/mush. A factor was the low altitude at which the airplane was being operated.
- [NTSB LAX06CA250](https://openairdocs.org/ntsb/LAX06CA250.md): Robinson R-22B · Chino, CA · Accident · Minor injuries · Data collection · Final report · Jul 29, 2006 · N475SH · Substantial damage
  > the certified flight instructor's inadequate supervision and incorrect remedial action. A factor was the student pilot's loss of control in a hovering turn.
- [NTSB ANC06LA100](https://openairdocs.org/ntsb/ANC06LA100.md): Eurocopter AS 350B2 · Skagway, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 2006 · N301TH · Substantial damage
  > The pilot's failure to maintain adequate clearance from trees while hovering, which resulted in a main rotor strike with trees, an uncontrolled descent, and a collision with terrain.
- [NTSB LAX06CA245](https://openairdocs.org/ntsb/LAX06CA245.md): Cessna 150J · Napa, CA · Accident · Minor injuries · Data collection · Final report · Jul 26, 2006 · N60816 · Substantial damage
  > a loss of engine power due to fuel starvation. The fuel starvation was the result of the pilot's inadequate preflight preparation (failure to refuel the airplane before taking off) and his inadequate in-flight decision (to make right turns while holding) that…
- [NTSB ATL06LA110](https://openairdocs.org/ntsb/ATL06LA110.md): Arter RV6 · Hartselle, AL · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 2006 · N112WA · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering resulting in an inadvertent stall and collision with trees and the ground. Factor in the accident were the pilot's ostentatious display and impairment due to alcohol.
- [NTSB SEA06CA145](https://openairdocs.org/ntsb/SEA06CA145.md): Grumman-Schweizer G-164B · Lamont, WA · Accident · Minor injuries · Data collection · Final report · Jul 23, 2006 · N8376K · Substantial damage
  > The pilot's failure to maintain terrain clearance while maneuvering.
- [NTSB DFW06CA189](https://openairdocs.org/ntsb/DFW06CA189.md): Piper PA19/L-18C · Katy, TX · Accident · Serious injuries · Data collection · Final report · Jul 22, 2006 · N3134F · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering resulting in an inadvertent stall/spin.
- [NTSB ATL06CA106](https://openairdocs.org/ntsb/ATL06CA106.md): Cessna 172F · Rome, GA · Accident · Serious injuries · Data collection · Final report · Jul 21, 2006 · N5324R · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall, and subsequent impact with the ground.
- [NTSB CHI06CA195](https://openairdocs.org/ntsb/CHI06CA195.md): Grumman G-164A · Lakeview, MI · Accident · No injuries · Data collection · Final report · Jul 20, 2006 · N5068 · Substantial damage
  > A loss of engine power for undetermined reasons. A factor associated with the accident was the low altitude at which the airplane was being operated when the loss of engine power occurred.
- [NTSB LAX06LA236](https://openairdocs.org/ntsb/LAX06LA236.md): Hammack Air Command Elite · Hilo, HI · Accident · Serious injuries · Limited investigation · Final report · Jul 19, 2006 · N6111A · Destroyed
  > an in-flight separation of a control rod joint assembly, which resulted in the pilot's loss of control. The underlying reason for the separation could not be determined.
- [NTSB ANC06LA101](https://openairdocs.org/ntsb/ANC06LA101.md): Cessna 172E · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Jul 13, 2006 · N5560T · Substantial damage
  > The pilot's failure to maintain altitude/clearance from a transmission line while performing a low altitude maneuver, which resulted in an in-flight collision with the transmission line.
- [NTSB ANC06CA090](https://openairdocs.org/ntsb/ANC06CA090.md): Schweizer 300C · Titusville, FL · Accident · Minor injuries · Data collection · Final report · Jul 12, 2006 · N1831A · Substantial damage
  > The failure of the certificated flight instructor (CFI) to maintain control of the helicopter, which resulted in an in-flight collision with terrain. A factor associated with the accident was the dual student's improper use of the cyclic trim.
- [NTSB CHI06LA187](https://openairdocs.org/ntsb/CHI06LA187.md): Piper PA-18-135 · Steubenville, OH · Accident · 1 fatal · Limited investigation · Final report · Jul 11, 2006 · N9841Q · Substantial damage
  > The pilot's failure to maintain clearance from the unmarked power line which resulted in the subsequent impact with the roadway. Factors were the unmarked power line, and the low altitude at which the flight was conducted.
- [NTSB LAX06CA227](https://openairdocs.org/ntsb/LAX06CA227.md): Hughes 369D · Kihei, HI · Accident · No injuries · Data collection · Final report · Jul 7, 2006 · N611WA · Substantial damage
  > the pilot's failure to maintain an adequate clearance from obstructions, which led to a main rotor blade strike.
- [NTSB NYC06LA171](https://openairdocs.org/ntsb/NYC06LA171.md): Buckeye Dream Machine · Monticello, KY · Accident · 1 fatal · Limited investigation · Final report · Jul 4, 2006 · UNREG · Substantial damage
  > The misplaced parachute suspension line, which resulted in an in-flight loss of control. A factor was the pilot's inadequate preflight inspection.
- [NTSB SEA06LA134](https://openairdocs.org/ntsb/SEA06LA134.md): Taylor Royal T · Davenport, WA · Accident · 3 fatal · Limited investigation · Final report · Jul 1, 2006 · N2554 · Destroyed
  > The pilot's failure to maintain aircraft control while maneuvering, resulting in a collision with terrain.

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

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

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