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

## Cases, newest first

- [NTSB SEA04LA063](https://openairdocs.org/ntsb/SEA04LA063.md): Glasflugel STD Libelle 201B · Oso, WA · Accident · 1 fatal · Limited investigation · Final report · Apr 2, 2004 · N161D · 2 aircraft · Substantial damage
  > The pilot of the Glaser-Dirks (lead glider) failure to maintain clearance from the Glasflugel (trailing glider) resulting in a mid-air collision while maneuvering.
- [NTSB SEA04FA060](https://openairdocs.org/ntsb/SEA04FA060.md): Cessna 182Q · Santiam Junc., OR · Accident · 3 fatal · Field investigation · Final report · Mar 29, 2004 · N96719 · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in a stall while attempting a low-level crossing of a ridge from the leeward to the windward side. Factors include low-level maneuvering, strong gusty winds, and downdrafts.
- [NTSB ATL04CA083](https://openairdocs.org/ntsb/ATL04CA083.md): Dantzer Lawrence L Rans S-12 · Lowndesboro, AL · Accident · Minor injuries · Data collection · Final report · Mar 28, 2004 · N910MB · Substantial damage
  > The pilot's failure to maintain airspeed while manuevering which resulted in an inadvertent stall/spin. A factor was trees.
- [NTSB NYC04CA096](https://openairdocs.org/ntsb/NYC04CA096.md): Hughes 269B · Farmingdale, NY · Accident · No injuries · Data collection · Final report · Mar 27, 2004 · N9520F · Substantial damage
  > The pilot's failure to maintain aircraft control while hover-taxiing. A factor in this accident was the high wind condition.
- [NTSB LAX04LA170](https://openairdocs.org/ntsb/LAX04LA170.md): Cessna 188B · Planada, CA · Accident · No injuries · Limited investigation · Final report · Mar 25, 2004 · N478Q · Destroyed
  > the partial loss of engine power due to the separation of the number 5 cylinder fuel injector supply line. The fuel line separation was due to company maintenance personnel's failure to secure the b-nut fitting following maintenance. Factors in the accident…
- [NTSB LAX04FA167](https://openairdocs.org/ntsb/LAX04FA167.md): Piper PA-38-112 · Jean, NV · Accident · 1 fatal · Field investigation · Final report · Mar 19, 2004 · N2421D · Destroyed
  > The student pilot's failure to regain control of the aircraft following an upset due to the disconnected primary right aileron control cable. The failure of the company maintenance personnel to detect and correct the improperly secured turnbuckle fitting at…
- [NTSB FTW04LA096](https://openairdocs.org/ntsb/FTW04LA096.md): Cessna 140 · Portland, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2004 · N2435V · Substantial damage
  > The pilots failure to maintain airspeed resulting in an inadvertant stall while executing a forced landing. A factor was the loss of engine power for undetermined reasons.
- [NTSB MIA04LA061](https://openairdocs.org/ntsb/MIA04LA061.md): Robinson R44 · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Mar 17, 2004 · N7194S · Substantial damage
  > The failure of the pilot to maintain control of the helicopter following a reported loss of engine power after picking up to a hover from a dolly.
- [NTSB LAX04LA163](https://openairdocs.org/ntsb/LAX04LA163.md): Wallace Skybolt · Reno, NV · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 2004 · N41BB · Destroyed
  > Failure of the left wing spar during an aerobatic maneuver.
- [NTSB MIA04CA059](https://openairdocs.org/ntsb/MIA04CA059.md): Robinson R22 · Keystone, FL · Accident · No injuries · Data collection · Final report · Mar 12, 2004 · N4370D · Substantial damage
  > The inadequate supervision by the flight instructor by allowing the student to lose excessive altitude resulting in a skid impacting the ground and subsequent roll over of the helicopter.
- [NTSB LAX04FA150](https://openairdocs.org/ntsb/LAX04FA150.md): Ercoupe 415-C · Oakdale, CA · Accident · 2 fatal · Field investigation · Final report · Mar 9, 2004 · N93707 · Destroyed
  > the in-flight separation of the main spar due to corrosion in the wing center section not detectable by inspection methods described in manufacturer's service bulletins and FAA Airworthiness Directives.
- [NTSB MIA04LA068](https://openairdocs.org/ntsb/MIA04LA068.md): Quad City Challenger II · Labelle, FL · Accident · 2 fatal · Limited investigation · Final report · Mar 6, 2004 · UNREG · Destroyed
  > The pilot in command's abrupt pull up, which resulted in an overload of the right wing, right wing separation, an uncontrolled descent, and impact with terrain.
- [NTSB SEA04LA050](https://openairdocs.org/ntsb/SEA04LA050.md): Cessna 170 · Herron, WA · Accident · 2 fatal · Limited investigation · Final report · Mar 1, 2004 · N2534V · Destroyed
  > The failure of the left muffler while maneuvering, resulting in a carbon monoxide leak into the cabin rendering the pilot incapacitated, and the subsequent uncontrolled descent and impact with water.
- [NTSB SEA04LA043](https://openairdocs.org/ntsb/SEA04LA043.md): Garlick UH-1H · Liberty, WA · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 2004 · N6257P · Substantial damage
  > The failure of the tail rotor slider lugs due to fatigue while the helicopter was maneuvering.
- [NTSB FTW04LA080](https://openairdocs.org/ntsb/FTW04LA080.md): Grumman G-164C · Hazen, AR · Accident · 1 fatal · Limited investigation · Final report · Feb 23, 2004 · N6721K · Destroyed
  > The pilot's loss of control while maneuvering during an aerial application flight for undetermined reasons.
- [NTSB ATL04LA076](https://openairdocs.org/ntsb/ATL04LA076.md): Bell 206 · Locust Grove, GA · Accident · No injuries · Limited investigation · Final report · Feb 21, 2004 · N35Q · Substantial damage
  > The pilot's failure to maintain directional control of the helicopter while lifting off a dolly to a hover. This resulted in the tail rotor blades and main rotor blades colliding with the ground and subsequent roll over.
- [NTSB SEA04LA042](https://openairdocs.org/ntsb/SEA04LA042.md): Cessna 150J · Longview, WA · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 2004 · N5559G · Substantial damage
  > Fuel exhaustion while maneuvering, as a result of the pilot's inadequate in-flight decision/planning, leading to his failure to refuel the airplane prior to running out of fuel. A ditch was a factor.
- [NTSB LAX04IA135](https://openairdocs.org/ntsb/LAX04IA135.md): Bell 407 · Madera, CA · Incident · No injuries · Incident investigation · Final report · Feb 19, 2004 · N601MT · Minor damage
  > the failure of the number 6 hangar bearing due to overheating. A factor in the accident was the operator's likely inadequate compliance with service bulletins and airworthiness directives on this issue, along with an inadequate maintenance inspection program…
- [NTSB FTW04TA075](https://openairdocs.org/ntsb/FTW04TA075.md): Bell 206B · Decatur, TX · Accident · Minor injuries · Final report · Feb 18, 2004 · N16MV · Destroyed
  > The pilot's failure to maintain control of the helicopter during liftoff after encountering dynamic rollover. A contributing factor was the rough and uneven terrain.
- [NTSB LAX04LA125](https://openairdocs.org/ntsb/LAX04LA125.md): Knapple/Wray Lancair IV-P · Apache Junction, AZ · Accident · 2 fatal · Limited investigation · Final report · Feb 17, 2004 · N330KT · Destroyed
  > the pilot/builder's failure to maintain an adequate airspeed while maneuvering that resulted in an inadvertent stall/spin.
- [NTSB LAX04FA137](https://openairdocs.org/ntsb/LAX04FA137.md): Piper PA-28-161 · Jean, NV · Accident · 2 fatal · Field investigation · Final report · Feb 16, 2004 · N9199Z · Destroyed
  > !!This case was modified January 31, 2006!! the pilot's failure to maintain adequate clearance with the rising terrain, while maneuvering at low altitude in a mountainous area.
- [NTSB ANC04LA022](https://openairdocs.org/ntsb/ANC04LA022.md): Bertrand/Warner Thorp T-18 · Crescent City, FL · Accident · 1 fatal · Limited investigation · Final report · Feb 14, 2004 · N98WB · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, and his failure to maintain terrain clearance. Factors associated with the accident were fog and low ceilings.
- [NTSB DEN04LA044](https://openairdocs.org/ntsb/DEN04LA044.md): Cessna 152 · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · Feb 12, 2004 · N66952 · Substantial damage
  > the failure of the exhaust valve for the engine's number one cylinder, resulting in the exhaust valve/piston contact and the subsequent total loss of engine power. Contributing factors include the lack of suitable terrain for a forced landing and the snow…
- [NTSB CHI04LA065](https://openairdocs.org/ntsb/CHI04LA065.md): Cessna 402B · Sturgis, MI · Accident · Serious injuries · Limited investigation · Final report · Feb 9, 2004 · N6387X · Substantial damage
  > The failure to maintain obstacle clearance during an intentional low altitude maneuver and the ostentatious display by the pilot-in-command. A factor to the accident was the tree.
- [NTSB ATL04FA071](https://openairdocs.org/ntsb/ATL04FA071.md): Cessna 150G · High Falls, GA · Accident · 1 fatal · Field investigation · Final report · Jan 27, 2004 · N2981J · Substantial damage
  > The pilot's impairment due to alcohol which resulted in his failure to maintain adequate airspeed, inadvertent stall, and subsequent in-flight collision with trees.
- [NTSB SEA04LA036](https://openairdocs.org/ntsb/SEA04LA036.md): Bell 206B · Turner, OR · Accident · No injuries · Limited investigation · Final report · Jan 26, 2004 · N92CA · Substantial damage
  > The pilot's inadequate preflight inspection which failed to detect contaminated fuel. A collapsed fuel screen was a contributing factor.
- [NTSB MIA04CA048](https://openairdocs.org/ntsb/MIA04CA048.md): Robinson R44 · Vero Beach, FL · Accident · No injuries · Data collection · Final report · Jan 23, 2004 · N77KK · Substantial damage
  > The failure of the pilot to maintain clearance with bushed resulting in in-flight contact and susequent dynamic roll-over.
- [NTSB FTW04FA062](https://openairdocs.org/ntsb/FTW04FA062.md): Beech B36TC · Willow Park, TX · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2004 · N7252X · Destroyed
  > The pilot's failure to maintain aircraft control while maneuvering. Contributing factors were the dark night and rain.
- [NTSB SEA04LA033](https://openairdocs.org/ntsb/SEA04LA033.md): Cessna 172RG · Enumclaw, WA · Accident · No injuries · Limited investigation · Final report · Jan 13, 2004 · N64ML · Substantial damage
  > A loss of engine power while maneuvering due to the failure of the heads of six of the eight cam followers. Factors include the pilot's decision to keep the gear retracted during the forced landing, and the rough/uneven terrain.
- [NTSB FTW04LA060](https://openairdocs.org/ntsb/FTW04LA060.md): Robinson R-22 Beta · Encino, TX · Accident · No injuries · Limited investigation · Final report · Jan 12, 2004 · N7061V · Substantial damage
  > The pilot's failure to maintain clearance from a tree while hovering.
- [NTSB DEN04FA038](https://openairdocs.org/ntsb/DEN04FA038.md): Beech B95 · Cedar City, UT · Accident · 2 fatal · Field investigation · Final report · Jan 12, 2004 · N9679R · Destroyed
  > the pilot in command's (examinee) failure to maintain airspeed which resulted in a stall. Contributing to the accident was the inadequate supervision by the designated examiner.
- [NTSB DEN04TA036](https://openairdocs.org/ntsb/DEN04TA036.md): Ayres S2T-T65 · Magdalena, NM · Accident · Minor injuries · Final report · Jan 8, 2004 · N3100E · Destroyed
  > loss of engine power for reasons undetermined. A contributing factor was the lack of suitable terrain for a forced landing.
- [NTSB DEN04FA035](https://openairdocs.org/ntsb/DEN04FA035.md): Rockwell 690A · Cortez, CO · Accident · 1 fatal · Field investigation · Final report · Jan 3, 2004 · N700SR · Destroyed
  > the pilot's inadequate planned approach and his failure to maintain airspeed which resulted in a stall. Contributing factors were low altitude flight maneuvering in an attempt to lose excessive altitude and realign the airplane for landing, and his failure to…
- [NTSB SEA04FA032](https://openairdocs.org/ntsb/SEA04FA032.md): Cessna 182G · Glasgow, MT · Accident · 4 fatal · Field investigation · Final report · Jan 2, 2004 · N3171S · Destroyed
  > Loss of aircraft control resulting in an in-flight collision with terrain. Factors include marginal weather and dark night conditions.
- [NTSB ANC04LA018](https://openairdocs.org/ntsb/ANC04LA018.md): Piper PA-31-350 · Koyukuk, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 2, 2004 · N45008 · Substantial damage
  > The pilot's continued flight into adverse weather conditions, and his failure to maintain clearance from terrain, which resulted in an in-flight collision with terrain. Factors associated with the accident were fog and whiteout weather conditions.
- [NTSB NYC04LA052](https://openairdocs.org/ntsb/NYC04LA052.md): Morgan S-17 · Woodstock, CT · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 2003 · NONE · Substantial damage
  > The uncertificated pilot's decision to perform a low altitude maneuver at an inadequate altitude, which resulted in an in-flight collision with trees.
- [NTSB ATL04LA060](https://openairdocs.org/ntsb/ATL04LA060.md): Cirrus Design SR22 · King, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 27, 2003 · N742CD · Substantial damage
  > A loss of engine power for undetermined reasons and the pilot's failure to maintain a visual lookout and obstacle clearance while performing a simulated engine out resulting in an in-flight-collision with a power line and the ground.
- [NTSB SEA04LA029](https://openairdocs.org/ntsb/SEA04LA029.md): Beech 58P · Missoula, MT · Accident · Minor injuries · Limited investigation · Final report · Dec 23, 2003 · N181AM · Destroyed
  > The second pilot's failure to maintain terrain clearance while maneuvering after takeoff. Proper climb rate not verified by the flight crew, fog, freezing fog, dark night conditions and inadequate supervision by the pilot-in-command were factors.
- [NTSB IAD04LA005](https://openairdocs.org/ntsb/IAD04LA005.md): Piper PA-44 · Prospect, PA · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 2003 · N432PA · Substantial damage
  > The flight instructor's improper in-flight decision, which included an inappropriate altitude selection for intentional single engine operation. Factors were the inability of the flight instructor to restart the right engine for undetermined reasons, and the…
- [NTSB CHI04FA045](https://openairdocs.org/ntsb/CHI04FA045.md): Mooney 20E · Webster, WI · Accident · 2 fatal · Field investigation · Final report · Dec 20, 2003 · N1275X · Destroyed
  > The pilot's inadequate decision to conduct a low altitude flight maneuver without sufficient altitude to maintain clearance from the terrain. Low altitude flight and ostentatious display are contributing factors.
- [NTSB ATL04LA057](https://openairdocs.org/ntsb/ATL04LA057.md): Interplane Skyboy-2 · Covington, TN · Accident · 1 fatal · Limited investigation · Final report · Dec 20, 2003 · UNREG · Substantial damage
  > The pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall/spin and collision with the ground. A factor was the unqualified person (pilot).
- [NTSB ATL04LA055](https://openairdocs.org/ntsb/ATL04LA055.md): MBB BK117A3 · Okeechobee, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 2003 · N911WJ · Substantial damage
  > The pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation, loss of aircraft control, and in-flight collision with trees and terrain. Factors in the accident were the pilot's failure to follow company…
- [NTSB ANC04FA015](https://openairdocs.org/ntsb/ANC04FA015.md): Cessna P210N · Tonopah, NV · Accident · 2 fatal · Field investigation · Final report · Dec 14, 2003 · N4674A · Destroyed
  > The pilot's failure to follow approved instrument flight procedures, and his failure to maintain clearance from obstacles/terrain, which resulted in an in-flight collision with terrain. Factors associated with the accident are snow and low clouds.
- [NTSB SEA04LA026](https://openairdocs.org/ntsb/SEA04LA026.md): Upright RV-7A · McMinnville, OR · Accident · 1 fatal · Limited investigation · Final report · Dec 11, 2003 · N29CV · Destroyed
  > The pilot's failure to maintain aircraft control. Cloudy weather, continued flight into adverse weather, inadequate preflight planning and mountainous terrain were factors.
- [NTSB ATL04FA051](https://openairdocs.org/ntsb/ATL04FA051.md): Cessna 414 · Greeneville, TN · Accident · 4 fatal · Field investigation · Final report · Dec 11, 2003 · N1592T · Destroyed
  > The pilot's failure to maintain airspeed while maneuvering in icing conditions on a circling approach for landing resulting in an inadvertent stall and collision with trees and terrain. A factor in the accident was a partial loss of engine power due to the…
- [NTSB SEA04LA025](https://openairdocs.org/ntsb/SEA04LA025.md): Hughes 369D · Moclips, WA · Accident · Serious injuries · Limited investigation · Final report · Dec 8, 2003 · N8343F · Substantial damage
  > A sudden loss of engine power during hover for undetermined reasons.
- [NTSB LAX04FA057](https://openairdocs.org/ntsb/LAX04FA057.md): Wing D-1 · Rosamond, CA · Accident · 2 fatal · Field investigation · Final report · Dec 4, 2003 · N8602J · Destroyed
  > The flying pilot's failure to obtain/maintain control of the airplane during practice stalls, which resulted in the inadvertent entry into a spin.
- [NTSB SEA04LA024](https://openairdocs.org/ntsb/SEA04LA024.md): Shear Titan Tornado · Brooks, OR · Accident · 1 fatal · Limited investigation · Final report · Dec 2, 2003 · N183T · Substantial damage
  > The failure of the pilot to maintain aircraft control while maneuvering due to a hypoglycemic condition.
- [NTSB LAX04LA054](https://openairdocs.org/ntsb/LAX04LA054.md): Cessna 172S · Wikieup, AZ · Accident · No injuries · Limited investigation · Final report · Nov 29, 2003 · N518ER · Substantial damage
  > The pilot's selection of an en route altitude that did not provide adequate terrain clearance, and resulted in the in-flight collision with terrain. The rising terrain and the blind/box canyon were contributing factors.
- [NTSB FTW04LA069](https://openairdocs.org/ntsb/FTW04LA069.md): MBB BK 117 B-2 · Conroe, TX · Accident · No injuries · Limited investigation · Final report · Nov 29, 2003 · N440HH · Substantial damage
  > The pilot's failure to maintain clearance from trees while repositioning in a confined landing zone. Contributing factors were the dark night light conditions and the confined area available to the pilot.

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

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

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