# 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 23 of 377 · 18,849 cases

## Cases, newest first

- [NTSB CEN20WA135](https://openairdocs.org/ntsb/CEN20WA135.md): Piper PA25 · Tepalcatepec, Michoacán, Mexico · Accident · 1 fatal · Foreign investigation · Mar 15, 2020 · XB-VOO · Destroyed
  > The government of Mexico has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on March 15, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB CEN20LA442](https://openairdocs.org/ntsb/CEN20LA442.md): Robinson Helicopter R44 II · Sterling City, TX · Accident · No injuries · Class 4 · Limited · Final report · Mar 12, 2020 · N4386W · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during an aerial application flight.
- [NTSB ERA20CA131](https://openairdocs.org/ntsb/ERA20CA131.md): American Legand AL18 · Social Circle, GA · Accident · No injuries · Data collection · Final report · Mar 10, 2020 · N23TN · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering at low altitude, which resulted in the collision with terrain.
- [NTSB ERA20CA128](https://openairdocs.org/ntsb/ERA20CA128.md): Stolp Starduster Acroduster II SA750 · Senoia, GA · Accident · Minor injuries · Data collection · Final report · Mar 7, 2020 · N529FM · Substantial damage
  > The pilot's failure to see and avoid trees while maneuvering at low altitude, which resulted in a loss of airplane control.
- [NTSB ERA20FA119](https://openairdocs.org/ntsb/ERA20FA119.md): American AA 1 · Boynton Beach, FL · Accident · 1 fatal · Class 3 · Field · Final report · Mar 6, 2020 · N5757L · Substantial damage
  > The pilot's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his exceedance of the airplane’s critical angle of attack following the loss of engine power, which resulted in an aerodynamic stall and…
- [NTSB CEN20FA110](https://openairdocs.org/ntsb/CEN20FA110.md): Cessna 172 · Lincoln, IL · Accident · 3 fatal · Class 3 · Field · Final report · Mar 3, 2020 · N157SF · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack during an aerial survey, which resulted in an aerodynamic stall at an altitude too low to recover.
- [NTSB WPR20CA095](https://openairdocs.org/ntsb/WPR20CA095.md): Cessna 172 · Dubois, ID · Accident · No injuries · Data collection · Final report · Feb 27, 2020 · N7904G · Substantial damage
  > The student pilot's failure to maintain a proper airspeed and descent rate while conducting a low pass over a snow-covered runway after encountering a downdraft and the flight instructor's delayed action, which resulted in the wheels contacting the snow and…
- [NTSB CEN20LA109](https://openairdocs.org/ntsb/CEN20LA109.md): Air Tractor AT 602 · Dumas, AR · Accident · No injuries · Class 3 · Limited · Final report · Feb 25, 2020 · N5197Y · Substantial damage
  > The pilot’s failure to maintain clearance from a power line pole during a low-level aerial application flight, which resulted in impact with the bracket and a subsequent forced landing.
- [NTSB WPR20WA091](https://openairdocs.org/ntsb/WPR20WA091.md): Piper PA44 · Mangalore, Australia · Accident · 4 fatal · Foreign investigation · Feb 19, 2020 · VH-JQF · 2 aircraft · Destroyed
- [NTSB WPR20CA092](https://openairdocs.org/ntsb/WPR20CA092.md): Bell OH 58A · Colexico, CA · Accident · No injuries · Data collection · Final report · Feb 19, 2020 · N288NS · Substantial damage
  > The pilot's failure to arrest the descent rate while maneuvering at low altitude, which resulted in impact with terrain.
- [NTSB ERA20CA104](https://openairdocs.org/ntsb/ERA20CA104.md): Schweizer 269C · Ormond Beach, FL · Accident · No injuries · Data collection · Final report · Feb 17, 2020 · N731TA · Substantial damage
  > The student pilot's improper pedal and cyclic input while maneuvering, which resulted in a loss of helicopter control.
- [NTSB CEN20CA085](https://openairdocs.org/ntsb/CEN20CA085.md): Robinson R44 · Marfa, TX · Accident · No injuries · Data collection · Final report · Feb 14, 2020 · N441KA · Substantial damage
  > The pilot's failure to maintain clearance from a fence during low-altitude maneuvering.
- [NTSB ANC20CA018](https://openairdocs.org/ntsb/ANC20CA018.md): Cessna 172 · Palmer, AK · Accident · No injuries · Data collection · Final report · Feb 6, 2020 · N817PS · Substantial damage
  > The pilot's failure to maintain clearance from snow-covered terrain while maneuvering at low altitude.
- [NTSB CEN20LA073](https://openairdocs.org/ntsb/CEN20LA073.md): Hiller UH 12E · Dinosaur, CO · Accident · No injuries · Class 3 · Limited · Final report · Feb 1, 2020 · N7173S · Substantial damage
  > Failure of a S4 compressor blade due to a fatigue crack that likely initiated at a corrosion pit. Contributing to the accident was maintenance personnel’s failure to detect the corrosion pits during maintenance.
- [NTSB ERA20FA086](https://openairdocs.org/ntsb/ERA20FA086.md): Mustang II · Senoia, GA · Accident · 2 fatal · Class 3 · Field · Final report · Jan 25, 2020 · UNREG · Destroyed
  > The pilot’s exceedance of the airplane’s structural limitations while conducting previous aerobatic maneuvers, which resulted in an in-flight breakup of the airplane.
- [NTSB WPR20FA079](https://openairdocs.org/ntsb/WPR20FA079.md): Piper PA28 · Payson, AZ · Accident · 1 fatal · Class 3 · Field · Final report · Jan 24, 2020 · N3672K · Destroyed
  > The pilot's decision to fly into a canyon with rising terrain, and his subsequent loss of aircraft control while maneuvering away from rising terrain.
- [NTSB GAA20WA110](https://openairdocs.org/ntsb/GAA20WA110.md): Extra E54T · Iztapa, Guatemala · Accident · 1 fatal · Foreign investigation · Jan 24, 2020 · N540ZA · Substantial damage
- [NTSB WPR20WA082](https://openairdocs.org/ntsb/WPR20WA082.md): Cessna S550 · George, South Africa · Accident · 3 fatal · Foreign investigation · Jan 23, 2020 · ZS-CAR · Substantial damage
  > On January 23, 2020, about 0853 coordinated universal time, a Cessna S550, ZS-CAR, impacted mountainous terrain under unknown circumstances while conducting aerial surveying operations near George, South Africa. The two crew members and one passenger were…
- [NTSB WPR20WA076](https://openairdocs.org/ntsb/WPR20WA076.md): Lockheed C130 · Cooma, Australia · Accident · 3 fatal · Class 5 · Foreign · Jan 23, 2020 · N134CG · Destroyed
- [NTSB WPR20FA067](https://openairdocs.org/ntsb/WPR20FA067.md): Cessna 150 · Jacksonville, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jan 20, 2020 · N4763X · Destroyed
  > The pilot’s failure to maintain clearance from guy wires associated with a tower while maneuvering at low altitude.
- [NTSB ERA20LA094](https://openairdocs.org/ntsb/ERA20LA094.md): Airborne America AX9-140 · Homestead, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 19, 2020 · N970TC · Minor damage
  > The pilot's decision to operate the balloon at low altitude near obstructions, structures, and powerlines, which resulted in the balloon contacting powerlines. Contributing to the accident was the Federal Aviation Administration's inadequate oversight of…
- [NTSB GAA20WA109](https://openairdocs.org/ntsb/GAA20WA109.md): Air Tractor AT402 · Guiratinga, MT, Brazil · Accident · 1 fatal · Foreign investigation · Jan 17, 2020 · PR-ASN · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a AIR TRACTOR AT402 airplane that occurred on January 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB ENG20WA014](https://openairdocs.org/ntsb/ENG20WA014.md): Bell 407 · Lautaro, Chile · Accident · No injuries · Foreign investigation · Jan 13, 2020 · CC-AEC · Substantial damage
  > The government of Chile has notified the NTSB of the an accident involving a Bell 407 helicopter at Lautaro, Chile on January 13, 2020. The NTSB has appointed an Accredited Representative for the State of Design and Manufacture of the installed Honeywell…
- [NTSB ENG20WA048](https://openairdocs.org/ntsb/ENG20WA048.md): De Havilland DHC2 · Sadiq Abad - Punjab, Pakistan · Accident · Class 5 · Foreign · Jan 12, 2020 · AP-AMB · Destroyed
- [NTSB WPR20WA078](https://openairdocs.org/ntsb/WPR20WA078.md): Garlick UH1H · Boydtown, Australia · Accident · Minor injuries · Foreign investigation · Jan 9, 2020 · VH-ONZ · Substantial damage
  > On January 9, 2020 about 1620 universal coordinated time, a Garlick Helicopters Inc., UH-1H helicopter, VH-ONZ, lost power and collided with water during an aerial fire control operation at Ben Boyd Reservoir, Boydtown, Merimbula, Australia. The pilot…
- [NTSB ERA20LA071](https://openairdocs.org/ntsb/ERA20LA071.md): Hughes OH 6A · Preston, GA · Accident · Minor injuries · Class 3 · Limited · Final report · Jan 8, 2020 · N6186U · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR20LA062](https://openairdocs.org/ntsb/WPR20LA062.md): Cessna 172H · El Monte, CA · Accident · No injuries · Class 3 · Limited · Final report · Jan 6, 2020 · N1658F · Substantial damage
  > The inflight separation of a section of a propeller blade due to a fatigue crack which resulted in a forced landing.
- [NTSB ERA20CA065](https://openairdocs.org/ntsb/ERA20CA065.md): American AA5 · Rutherfordton, NC · Accident · Serious injuries · Class 4 · Data collection · Final report · Jan 5, 2020 · N9593U · Substantial damage
  > The pilot's failure to maintain control of the airplane during an intentional aerodynamic stall, which resulted in a spin and subsequent collision with terrain.
- [NTSB CEN20LA051](https://openairdocs.org/ntsb/CEN20LA051.md): Enstrom F28 · Danbury, TX · Accident · No injuries · Class 3 · Limited · Final report · Dec 31, 2019 · N57SJ · Substantial damage
  > The failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.
- [NTSB GAA20WA101](https://openairdocs.org/ntsb/GAA20WA101.md): Piper PA25 · Rio Branco, Cerro Largo, Uruguay · Accident · 1 fatal · Foreign investigation · Dec 24, 2019 · CX-BRE-R · Substantial damage
  > The government of Uruguay has notified the NTSB of an accident involving a PIPER PA25 airplane that occurred on December 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Uruguay's investigation under the provisions…
- [NTSB ERA20LA080](https://openairdocs.org/ntsb/ERA20LA080.md): Team Rocket F-1 F-1 · Suffolk, VA · Accident · No injuries · Class 3 · Limited · Final report · Dec 24, 2019 · N230BW · Substantial damage
  > A structural failure of the horizontal stabilizer during aerobatic maneuvers near the airplane’s never-exceed speed. Contributing to the failure was the construction of the horizontal stabilizer that did not meet the kit manufacturer’s specifications.
- [NTSB WPR20WA044](https://openairdocs.org/ntsb/WPR20WA044.md): Angel 44 · Mareeba, Australia · Accident · 2 fatal · Foreign investigation · Dec 14, 2019 · VH-IAZ · Destroyed
  > On December 14, 2019, at 1115 local time, an Angel Aircraft Corporation 44 twin-engine airplane, registration VH-IAZ, collided with terrain near Mareeba Aerodrome, Mareeba Queensland, Australia. Both pilots were fatally injured, and the airplane was…
- [NTSB GAA19WA598](https://openairdocs.org/ntsb/GAA19WA598.md): Aerospatiale AS350 · Kitzbühel, Austria · Accident · Serious injuries · Class 5 · Foreign · Dec 12, 2019 · OE-XHE · No damage
- [NTSB CEN20WA210](https://openairdocs.org/ntsb/CEN20WA210.md): Piper PA30 · Kaunas, Lithuania · Accident · 2 fatal · Foreign investigation · Dec 8, 2019 · LY-ARS · Substantial damage
  > The government of Lithuania has notified the NTSB of an accident involving a PIPER PA30 airplane that occurred on December 08, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Lithuania's investigation under the…
- [NTSB WPR20WA037](https://openairdocs.org/ntsb/WPR20WA037.md): Robinson R44 · Eschowe, South Africa · Accident · 1 fatal · Foreign investigation · Dec 5, 2019 · ZS-RRS · Substantial damage
  > The government of South Africa has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on December 5, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under…
- [NTSB ANC20FA005](https://openairdocs.org/ntsb/ANC20FA005.md): Beech V35 · Blythe, CA · Accident · 1 fatal · Class 3 · Field · Final report · Nov 26, 2019 · N14UC · Destroyed
  > A loss of control in flight due to the pilot’s decision to fly into a mountain range, at night, in conditions conducive to high wind, mountain waves, and turbulence.
- [NTSB WPR20LA026](https://openairdocs.org/ntsb/WPR20LA026.md): Piper PA 18 · Livermore, CA · Accident · No injuries · Class 3 · Limited · Final report · Nov 16, 2019 · N8589D · Substantial damage
  > The improper installation of the flight control stick, which resulted in separation of the flight control stick from the stick stub assembly and an uncontrolled descent and impact with terrain.
- [NTSB GAA20CA063](https://openairdocs.org/ntsb/GAA20CA063.md): Sikorsky S 58JT · Lebanon, IN · Accident · Minor injuries · Data collection · Final report · Nov 10, 2019 · N827MW · Substantial damage
  > The pilot's failure to maintain proper clearance from a tractor trailer during landing.
- [NTSB GAA20CA060](https://openairdocs.org/ntsb/GAA20CA060.md): Robinson R22 · Smoketown, PA · Accident · No injuries · Data collection · Final report · Nov 4, 2019 · N8560A · Substantial damage
  > The student pilot's improper cyclic input while hovering and the flight instructor's delayed remedial action, which resulted in a dynamic rollover.
- [NTSB ERA20FA029](https://openairdocs.org/ntsb/ERA20FA029.md): Pavel Tango2 · Cedartown, GA · Accident · 1 fatal · Class 3 · Field · Final report · Nov 4, 2019 · N875FV · Substantial damage
  > The pilot's loss of control of the gyroplane for reasons that could not be determined based on available evidence.
- [NTSB GAA20CA066](https://openairdocs.org/ntsb/GAA20CA066.md): American AA 5 · Gilbert, SC · Accident · No injuries · Data collection · Final report · Nov 2, 2019 · N24AU · Substantial damage
  > The pilot's improper approach path, which resulted in impact with a tree.
- [NTSB ERA20FA027](https://openairdocs.org/ntsb/ERA20FA027.md): Grumman OV-1 · Stuart, FL · Accident · 1 fatal · Class 3 · Field · Final report · Nov 1, 2019 · N10VD · Destroyed
  > The pilot’s improper recovery from a low-altitude aerobatic maneuver, which resulted in descent into terrain.
- [NTSB WPR20FA018](https://openairdocs.org/ntsb/WPR20FA018.md): Cessna 150 · Brawley, CA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 31, 2019 · N7158X · Substantial damage
  > The pilot’s decision to perform a flight while impaired by the effects of alcohol and cocaine, and his failure to maintain terrain clearance during the flight.
- [NTSB WPR20FA016](https://openairdocs.org/ntsb/WPR20FA016.md): Enstrom 280F · Jordan Valley, OR · Accident · 1 fatal · Class 3 · Field · Final report · Oct 25, 2019 · N280F · Substantial damage
  > A partial loss of engine power due to a worn engine air induction hose, and a subsequent uncontrolled descent into terrain. Contributing to the accident was the failure of maintenance personnel to adequately inspect the hose, and the pilot’s decision to fly…
- [NTSB WPR20FA015](https://openairdocs.org/ntsb/WPR20FA015.md): Mooney M20J · American Falls, ID · Accident · 1 fatal · Class 3 · Field · Final report · Oct 25, 2019 · N201BJ · Substantial damage
  > The pilot’s failure to ensure adequate fuel onboard and his subsequent failure to maintain airspeed while maneuvering which resulted in an aerodynamic stall following a total loss of engine power due to fuel exhaustion. Contributing to the accident was the…
- [NTSB ERA20FA019](https://openairdocs.org/ntsb/ERA20FA019.md): Mooney M20A · Summit Point, WV · Accident · 2 fatal · Class 3 · Field · Final report · Oct 24, 2019 · N8354E · Destroyed
  > The pilot’s decision to conduct a practice stall maneuver at low altitude, which resulted in inadequate altitude remaining in which to recover before impacting terrain.
- [NTSB WPR20FA013](https://openairdocs.org/ntsb/WPR20FA013.md): Robinson R44 · Las Vegas, NV · Accident · 2 fatal · Class 3 · Field · Final report · Oct 23, 2019 · N225JM · Substantial damage
  > An undetermined inflight event that resulted in the pilot performing an autorotation to uneven terrain for reasons that could not be determined due to the extent of impact damage.
- [NTSB CEN20FA012](https://openairdocs.org/ntsb/CEN20FA012.md): Robinson R22 Beta · Hebbronville, TX · Accident · 2 fatal · Class 3 · Field · Final report · Oct 23, 2019 · N7189D · 2 aircraft · Destroyed
  > The failure of the spotter helicopter pilot to maintain clearance from the gunner helicopter while maneuvering. Contributing to the accident were the effects from the pilot’s use of impairing drugs.
- [NTSB CEN20LA013](https://openairdocs.org/ntsb/CEN20LA013.md): Air Tractor AT 502 · Lamesa, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 22, 2019 · N9143F · Minor damage
  > The pilot's improper decision to maneuver at a low altitude and in close proximity to a wind turbine undergoing maintenance, which resulted in a collision with a tagline rope being held by a worker on the ground and serious injury to the worker.
- [NTSB GAA20CA039](https://openairdocs.org/ntsb/GAA20CA039.md): Zenair CH 701 · Safford, AZ · Accident · No injuries · Data collection · Final report · Oct 20, 2019 · N3784A · Substantial damage
  > The in-flight separation of a propeller blade for reasons that could not be determined based on the available evidence, which resulted in an off-airport landing on soft sand and the separation of main landing gear. Contributing to the accident was the pilot’s…

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

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

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