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

## Cases, newest first

- [NTSB NYC06FA104](https://openairdocs.org/ntsb/NYC06FA104.md): Cessna 172L · Montgomery Twp, PA · Accident · 1 fatal · Field investigation · Final report · Apr 25, 2006 · N7604G · Destroyed
  > An impact with mountainous terrain for an undetermined reason.
- [NTSB CHI06LA119](https://openairdocs.org/ntsb/CHI06LA119.md): Woods Skyboy Quick Kit · Huntington, IN · Accident · 1 fatal · Limited investigation · Final report · Apr 24, 2006 · N758RW · Substantial damage
  > The flight's impact with terrain while maneuvering due to undetermined reasons.
- [NTSB LAX06LA147](https://openairdocs.org/ntsb/LAX06LA147.md): Christen Industries A-1 · Creston, CA · Accident · No injuries · Limited investigation · Final report · Apr 23, 2006 · N96088 · Substantial damage
  > The pilot's failure to maintain an adequate clearance from obstacles while intentionally flying at a low altitude.
- [NTSB NYC06FA100](https://openairdocs.org/ntsb/NYC06FA100.md): Bell 47G-3B-1 · East Hanover Tw, PA · Accident · 2 fatal · Field investigation · Final report · Apr 20, 2006 · N22MP · Destroyed
  > The pilot's improper decision to hover out-of-ground-effect in a tailwind, and his failure to maintain aircraft control. A factor in the accident was the tailwind.
- [NTSB DFW06LA093](https://openairdocs.org/ntsb/DFW06LA093.md): Sikorsky S-76A · Houston, TX · Accident · No injuries · Limited investigation · Final report · Apr 19, 2006 · N8063R · Substantial damage
  > The failure by maintenance personnel to secure the tail rotor driveshaft cowling after performing maintenance which resulted in a loss of tail rotor control. A contributing factor was the pilot's improper preflight inspection of the tail rotor driveshaft area.
- [NTSB DFW06CA109](https://openairdocs.org/ntsb/DFW06CA109.md): Cessna 150M · Roanake, TX · Accident · No injuries · Data collection · Final report · Apr 19, 2006 · N3419V · Substantial damage
  > The pilot's failure to maintain clearance from an unmarked transmission wire. A contributing factor was the low altitude flight.
- [NTSB CHI06CA116](https://openairdocs.org/ntsb/CHI06CA116.md): Palulis John Exec 162F · Kalkaska, MI · Accident · No injuries · Data collection · Final report · Apr 16, 2006 · N42996 · Substantial damage
  > The compensation for wind conditions not performed by the pilot during hover. An additional cause was the tailwind.
- [NTSB DFW06LA103](https://openairdocs.org/ntsb/DFW06LA103.md): Air Tractor AT-602 · Meridian, MS · Accident · 1 fatal · Limited investigation · Final report · Apr 15, 2006 · N5003E · Destroyed
  > The pilot's failure to maintain clearance from trees. Contributing factors were the drug impairment and low maneuvering altitude.
- [NTSB CHI06FA109](https://openairdocs.org/ntsb/CHI06FA109.md): Robinson R22 Beta · Chelsea, MI · Accident · 2 fatal · Field investigation · Final report · Apr 13, 2006 · N887BC · Substantial damage
  > The pilot's inadequate preflight inspection of the helicopter that failed to discover water in the fuel, resulting in a loss of engine power while maneuvering, and an in-flight collision with trees and terrain. Factors associated with the accident were…
- [NTSB DEN06LA061](https://openairdocs.org/ntsb/DEN06LA061.md): Piper PA-25-235 · Smith Center, KS · Accident · No injuries · Limited investigation · Final report · Apr 12, 2006 · N9886P · Substantial damage
  > the pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/mush, and subsequent impact with the field and fence. A factor contributing to the accident was the pilot's inadequate flight planning and preparation.
- [NTSB DEN06CA060](https://openairdocs.org/ntsb/DEN06CA060.md): Air Tractor AT-602 · Ulysses, KS · Accident · Minor injuries · Data collection · Final report · Apr 11, 2006 · N50669 · Substantial damage
  > the loss of engine power due to fuel starvation. A contributing factor was the impact with a ditch during the forced landing.
- [NTSB SEA06TA071](https://openairdocs.org/ntsb/SEA06TA071.md): Bell 206B · Sprague, WA · Accident · No injuries · Final report · Apr 7, 2006 · N96NW · Substantial damage
  > The pilot's failure to maintain clearance from mountainous terrain while maneuvering. Mountainous terrain was a factor.
- [NTSB CHI06LA105](https://openairdocs.org/ntsb/CHI06LA105.md): Cessna 177 · Blackburn, MO · Accident · 1 fatal · Limited investigation · Final report · Apr 7, 2006 · N34200 · Destroyed
  > The pilot's failure to maintain obstacle clearance from the power line during low altitude maneuvering. A factor was the power line.
- [NTSB DFW06FA095](https://openairdocs.org/ntsb/DFW06FA095.md): Piper/Stevens PA18A-150 · Hollandale, MS · Accident · 2 fatal · Field investigation · Final report · Apr 5, 2006 · N3887P · Destroyed
  > The pilots failure to maintain control of the airplane. A contributing factor was the pilots impairment.
- [NTSB DFW06LA094](https://openairdocs.org/ntsb/DFW06LA094.md): Aviation Specialties Unlimited Challenger II · Coushatta, LA · Accident · No injuries · Limited investigation · Final report · Apr 4, 2006 · N260HP · Destroyed
  > The loss of control due to premature failure of the elevator's push-pull tube rod-end bearing.
- [NTSB ATL06LA059](https://openairdocs.org/ntsb/ATL06LA059.md): Brantly Helicopter B2B · Cullman, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 2, 2006 · N2183U · Destroyed
  > The pilot's failure to maintain a visual look out while maneuvering resulting in an in-flight collision with wires and the ground. A factor in the accident was the pilot's lack of recent experience in rotorcraft operations.
- [NTSB LAX06LA134](https://openairdocs.org/ntsb/LAX06LA134.md): Bell UH-1H · Yuba City, CA · Accident · No injuries · Limited investigation · Final report · Apr 1, 2006 · N710WD · Substantial damage
  > The pilot's in-flight loss of control of the helicopter for undetermined reasons. A factor was the trees.
- [NTSB ATL06LA058](https://openairdocs.org/ntsb/ATL06LA058.md): Cessna 182T · Double Springs, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 2006 · N2157V · Substantial damage
  > The pilot's failure to maintain airspeed resulting in a stall. A factor in the accident was the pilot's physical impairment due to dementia and his failure to report the medical condition to the aviation medical examiner..
- [NTSB ANC06LA029](https://openairdocs.org/ntsb/ANC06LA029.md): Cooper Harmon Rocket ll · McKittrick, CA · Accident · 1 fatal · Limited investigation · Final report · Mar 25, 2006 · N96CR · Destroyed
  > The pilot's failure to maintain altitude/clearance while performing intentional low altitude aerobatic flight maneuvers. Factors associated with the accident are the low altitude aerobatic flight maneuvers.
- [NTSB ANC06LA028](https://openairdocs.org/ntsb/ANC06LA028.md): Robinson R-22B · Kailua-Kona, HI · Accident · No injuries · Limited investigation · Final report · Mar 23, 2006 · N203DH · Substantial damage
  > The flight instructor's delayed remedial action while conducting hover practice with a student pilot, which resulted in the helicopter contacting the ground and rolling over. A factor contributing to the accident was an inadvertent dynamic roll over.
- [NTSB SEA06CA069](https://openairdocs.org/ntsb/SEA06CA069.md): Kearsley Exec 162F · Morgan, UT · Accident · No injuries · Data collection · Final report · Mar 22, 2006 · N520DK · Substantial damage
  > The pilot's inadequate in-flight decision to attempt to hover out of ground effect above the kit manufacturers published recommendations. A factor was mountainous terrain.
- [NTSB ANC06LA038](https://openairdocs.org/ntsb/ANC06LA038.md): MD Helicopters MD 900 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Mar 22, 2006 · N912LH · Substantial damage
  > The manufacturer's inadequate design clearance of the main rotor blade grip pitch cases, which resulted in damage to the pitch cases when they contacted main rotor perimeter bolts during maneuvering flight.
- [NTSB DFW06LA088](https://openairdocs.org/ntsb/DFW06LA088.md): Beech C23 · Mena, AR · Accident · 1 fatal · Limited investigation · Final report · Mar 21, 2006 · N2160W · Substantial damage
  > The pilot's continued flight into instrument meteorological conditions. Contributing factors were the mountainous terrain and the low ceilings.
- [NTSB ANC06LA027](https://openairdocs.org/ntsb/ANC06LA027.md): Piper PA-18 · Dillingham, AK · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 2006 · N6770B · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering for landing, which resulted in a loss of control and collision with snow-covered terrain. A factor contributing to the accident was an inadvertent stall.
- [NTSB CHI06FA094](https://openairdocs.org/ntsb/CHI06FA094.md): Piper PA34-200T · Branson, MO · Accident · 4 fatal · Field investigation · Final report · Mar 20, 2006 · N21RR · Destroyed
  > The pilot's failure to maintain sufficient airspeed, which resulted in an inadvertent stall/spin while maneuvering to return to the departure airport for landing after declaring an emergency for unspecified reasons. Additional factors were the low cloud…
- [NTSB SEA06FA067](https://openairdocs.org/ntsb/SEA06FA067.md): Kaman K-1200 · Dayville, OR · Accident · 1 fatal · Field investigation · Final report · Mar 17, 2006 · N263KA · Substantial damage
  > The improper overhaul of the reduction gear box assembly and improper installation of the N1 seal and nut assembly lockcup by maintenance personnel, which resulted in failure of the reduction gear box and a total loss of engine power. A contributing factor…
- [NTSB CHI06CA093](https://openairdocs.org/ntsb/CHI06CA093.md): Cessna 182G · Lebanon, IN · Accident · No injuries · Data collection · Final report · Mar 17, 2006 · N3675U · Substantial damage
  > Failure by the flightcrew (dual student and flight instructor) to accurately determine the fuel quantity prior to flight, which resulted in fuel exhaustion. An additional cause was the flight instructor's inadequate supervision of the flight due to his…
- [NTSB DEN06CA048](https://openairdocs.org/ntsb/DEN06CA048.md): Enstrom 280F · Peetz, CO · Accident · No injuries · Data collection · Final report · Mar 15, 2006 · N811Z · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering resulting in an impact with terrain. Contributing factors were the gusty winds, downdrafts, and box canyon.
- [NTSB SEA06LA065](https://openairdocs.org/ntsb/SEA06LA065.md): Kaman K-1200 · Dexter, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 2006 · N133KA · Substantial damage
  > The pilot's failure to identify the overspeed of the helicopter's main rotors due to a turbine governor malfunction, and his failure to take the appropriate actions described in the Flight Manual's emergency procedures section. Factors include the malfunction…
- [NTSB ANC06LA025](https://openairdocs.org/ntsb/ANC06LA025.md): Robinson R44 · Ilimana, AK · Accident · No injuries · Limited investigation · Final report · Mar 12, 2006 · N7528Z · Substantial damage
  > The pilot's continued flight into adverse weather conditions, and his spatial disorientation and loss of control during a subsequent landing attempt. Factors associated with the accident are flat light and whiteout conditions, fog, and snow-covered terrain.
- [NTSB LAX06FA124](https://openairdocs.org/ntsb/LAX06FA124.md): Aero Vodochody L39 · California City, CA · Accident · 2 fatal · Field investigation · Final report · Feb 26, 2006 · N39DF · Destroyed
  > The flight crew's failure to maintain terrain clearance during an intentionally performed course reversal turn at low altitude.
- [NTSB NYC06LA073](https://openairdocs.org/ntsb/NYC06LA073.md): Cessna 182D · Weyers Cave, VA · Accident · 1 fatal · Limited investigation · Final report · Feb 24, 2006 · N9178X · Destroyed
  > The pilot's improper decision to maneuver at a low altitude at night, and his failure to maintain adequate altitude/clearance, which resulted in a collision with power lines. A factor in this accident was the night light conditions.
- [NTSB SEA06CA056](https://openairdocs.org/ntsb/SEA06CA056.md): Cessna 150L · Hillsboro, OR · Accident · No injuries · Data collection · Final report · Feb 23, 2006 · N11568 · Substantial damage
  > The student pilot's delayed use of carburetor heat in carburetor icing conditions while maneuvering. Soft terrain was a factor.
- [NTSB DEN06FA043](https://openairdocs.org/ntsb/DEN06FA043.md): Cessna 182E · Austin, CO · Accident · 3 fatal · Field investigation · Final report · Feb 23, 2006 · N9298X · Destroyed
  > the pilot's failure to maintain clearance from the transmission wire resulting in the airplane's outboard wing portion to be severed, and the subsequent loss of control and ground impact. Factors contributing to the accident were the pilot's impairment from…
- [NTSB NYC06FA071](https://openairdocs.org/ntsb/NYC06FA071.md): Cessna 172R · Mitchellville, MD · Accident · 2 fatal · Field investigation · Final report · Feb 22, 2006 · N3536C · Destroyed
  > The pilot's improper inflight planning/decision to attempt a landing in weather conditions below landing minimums, and his failure to maintain airspeed while maneuvering. Factors in the accident were the fog and snow.
- [NTSB NYC06LA062](https://openairdocs.org/ntsb/NYC06LA062.md): Bell 206B · Big Creek, KY · Accident · Serious injuries · Limited investigation · Final report · Feb 17, 2006 · N36HF · Substantial damage
  > The pilot's inadvertent settling with power during a descent. Contributing to the accident was mechanical turbulence in the lee of an obstruction in windy conditions.
- [NTSB LAX06CA116](https://openairdocs.org/ntsb/LAX06CA116.md): Robinson R22 · El Monte, CA · Accident · Minor injuries · Data collection · Final report · Feb 15, 2006 · N23617 · Substantial damage
  > the pilot's inadequate compensation for the wind conditions, which resulted in the helicopter dynamically rolling over.
- [NTSB LAX06LA110](https://openairdocs.org/ntsb/LAX06LA110.md): Carpenter BJ/Carpenter Glasair II-S FT · Roseville, CA · Accident · 3 fatal · Limited investigation · Final report · Feb 12, 2006 · N540FT · Destroyed
  > The pilot's failure to maintain an adequate airspeed while performing low level aerobatics that led to a stall/spin.
- [NTSB LAX06LA103](https://openairdocs.org/ntsb/LAX06LA103.md): Harwood Kenneth Lancair 360A · Thermal, CA · Accident · No injuries · Limited investigation · Final report · Feb 6, 2006 · N15KH · Substantial damage
  > A loss of engine power caused by the separation of the number three cylinder due to the improper torque on the hold down nuts.
- [NTSB CHI06FA077](https://openairdocs.org/ntsb/CHI06FA077.md): Short Brothers SD-360-300 · Watertown, WI · Accident · 3 fatal · Field investigation · Final report · Feb 5, 2006 · N3735W · 2 aircraft · Destroyed
  > The other airplane's flight crew failure to maintain clearance while maneuvering during formation flight. Contributing to the accident was the decision of both flight crews to fly in formation.
- [NTSB MIA06FA050](https://openairdocs.org/ntsb/MIA06FA050.md): Cirrus Design SR-22 · Stuart, FL · Accident · 3 fatal · Field investigation · Final report · Feb 4, 2006 · N667WP · Destroyed
  > The pilot's failure to maintain aircraft control, which resulted in an uncontrolled descent and impact with the water. Contributing to the accident were a reported instrument failure, pilot disorientation, and instrument meteorological conditions. A factor in…
- [NTSB CHI06LA074](https://openairdocs.org/ntsb/CHI06LA074.md): Bell 206L-1 · Chesterfield, IN · Accident · Serious injuries · Limited investigation · Final report · Feb 2, 2006 · N593AE · Destroyed
  > The pilot's failure to maintain aircraft control after becoming spatially disorientated shortly after departure. Contributing to the accident was the pilot's inadequate preflight weather evaluation, his inadvertent flight into night instrument meteorological…
- [NTSB DFW06CA063](https://openairdocs.org/ntsb/DFW06CA063.md): Piper PA-18-150 · Gail, TX · Accident · No injuries · Data collection · Final report · Jan 30, 2006 · N744 · Substantial damage
  > The pilot's failure to maintain airspeed resulting in an inadvertent stall/mush.
- [NTSB CHI06LA073](https://openairdocs.org/ntsb/CHI06LA073.md): Bellanca 7ECA · Pontiac, MI · Accident · 2 fatal · Limited investigation · Final report · Jan 27, 2006 · N55CW · Destroyed
  > The excessive bank angle executed by the flight crew and their failure to maintain airspeed during the turn, which led to the inadvertent stall and subsequent impact with the ground. A factor was the low altitude.
- [NTSB SEA06FA147](https://openairdocs.org/ntsb/SEA06FA147.md): Cessna 421C · Carson, WA · Accident · 1 fatal · Field investigation · Final report · Jan 25, 2006 · N69KM · Destroyed
  > The pilot's failure to maintain aircraft control while maneuvering. Icing conditions, clouds and the pilot's continued flight into known adverse weather were factors.
- [NTSB SEA06CA043](https://openairdocs.org/ntsb/SEA06CA043.md): Aviat A1-A · Pine, ID · Accident · No injuries · Data collection · Final report · Jan 14, 2006 · N456AM · Substantial damage
  > The pilot's failure to maintain clearance from terrain while maneuvering. Snow covered terrain and flat light conditions are contributing factors.
- [NTSB DFW06CA055](https://openairdocs.org/ntsb/DFW06CA055.md): Bell 47-B3 · Dennison, TX · Accident · No injuries · Data collection · Final report · Jan 13, 2006 · N1575 · Substantial damage
  > The in-flight separation of the stabilizer bar tube.
- [NTSB DFW06TA054](https://openairdocs.org/ntsb/DFW06TA054.md): Aerospatiale AS350-B2 · Eagle Pass, TX · Accident · Serious injuries · Final report · Jan 12, 2006 · N840BP · Substantial damage
  > The pilot's failure to maintain clearance from the unmarked transmission lines. A factor was the pilot's diverted attention while monitoring ground activity.
- [NTSB LAX06FA087](https://openairdocs.org/ntsb/LAX06FA087.md): Cirrus Design SR20 · Lancaster, CA · Accident · 2 fatal · Field investigation · Final report · Jan 9, 2006 · N526CD · Destroyed
  > The student pilot's failure to maintain an adequate airspeed while maneuvering, and, the flight instructor's inadequate supervision of the flight. A factor in the accident was the strong tailwind encountered as the airplane turned from an upwind to a downwind…
- [NTSB LAX06FA069](https://openairdocs.org/ntsb/LAX06FA069.md): McDonnell Douglas 369FF · Lihue, HI · Accident · 1 fatal · Field investigation · Final report · Dec 26, 2005 · N530MD · Substantial damage
  > The pilot's failure to maintain aircraft control while hovering out of ground effect during an external load operation. A contributing factor was the pilot's lack of experience in external load operations.

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

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

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