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

## Cases, newest first

- [NTSB CEN25LA297](https://openairdocs.org/ntsb/CEN25LA297.md): Ayres S2R · Akron, IA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jul 28, 2025 · N524SL · Substantial damage
  > On July 28, 2025, about 1537 central daylight time, an Ayres Corporation S2R-T34 airplane, N524SL, sustained substantial damage when it was involved in an accident near Akron, Iowa. The pilot sustained serious injuries. The airplane was operated as a Title 14…
- [NTSB CEN25FA289](https://openairdocs.org/ntsb/CEN25FA289.md): Piper PA-22-150 · New Underwood, SD · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 28, 2025 · N9642D · Substantial damage
  > On July 28, 2025, about 0604 mountain daylight time, a Piper PA-22-150 airplane, N9642D, was substantially damaged when it was involved in an accident near New Underwood, South Dakota. The pilot was seriously injured and the passenger sustained fatal…
- [NTSB CEN25LA292](https://openairdocs.org/ntsb/CEN25LA292.md): Bell 206B · North Bend, NE · Accident · No injuries · Class 4 · Limited · Final report · Jul 27, 2025 · N432TV · Substantial damage
  > The pilot’s failure to maintain clearance from wires while maneuvering at a low altitude, and the ground crew failure to inform the pilot that the support truck had been moved.
- [NTSB ERA25LA287](https://openairdocs.org/ntsb/ERA25LA287.md): Grob-Werke Twin Astir · Franconia, NH · Accident · No injuries · Class 4 · Limited · Final report · Jul 24, 2025 · N103GV · Substantial damage
  > The pilot’s failure to detect the inadvertent deployment of the spoilers, which resulted in a prolonged, excessive descent rate. Contributing to the accident was the pilot’s decision to conduct a downwind approach versus a straight in approach to the…
- [NTSB CEN25LA286](https://openairdocs.org/ntsb/CEN25LA286.md): Weatherly 620B · Rushmore, MN · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 23, 2025 · N2032J · Substantial damage
  > The pilot’s failure to maintain clearance from a tree during low-level maneuvering.
- [NTSB CEN25LA285](https://openairdocs.org/ntsb/CEN25LA285.md): Air Tractor AT-802A · Walcott, IA · Accident · No injuries · Class 4 · Limited · Final report · Jul 23, 2025 · N802BF · Substantial damage
  > The pilot’s failure to maintain clearance from the crops during an aerial application flight.
- [NTSB CEN25LA283](https://openairdocs.org/ntsb/CEN25LA283.md): Air Tractor AT-301 · Hartsburg, IL · Accident · No injuries · Class 4 · Limited · Final report · Jul 23, 2025 · N2371V · Substantial damage
  > The pilot’s failure to maintain control of the airplane during takeoff with a tailwind from a wet turf airstrip.
- [NTSB CEN25FA281](https://openairdocs.org/ntsb/CEN25FA281.md): Bell Helicopter Textron 206L-1 · Thibodaux, LA · Accident · 1 fatal · Class 3 · Field · Final report · Jul 23, 2025 · N2611 · Destroyed
  > The pilot’s failure to maintain clearance to powerlines during an agricultural application pass.
- [NTSB GAA25WA244](https://openairdocs.org/ntsb/GAA25WA244.md): ProMecc Aerosapce Freccia FG · Azzano Mella, Italy · Accident · 2 fatal · Class 3 · Foreign · Jul 22, 2025 · I-E607 · Destroyed
- [NTSB CEN25LA277](https://openairdocs.org/ntsb/CEN25LA277.md): Robinson Helicopter R66 · Maynard, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 22, 2025 · N88911 · Substantial damage
  > On July 22, 2025, about 1400 central daylight time, a Robinson Helicopter Company R66 helicopter, N88911, was substantially damaged when it was involved in an accident near Maynard, Iowa. The pilot was uninjured. The helicopter was operated under Title 14…
- [NTSB CEN25LA276](https://openairdocs.org/ntsb/CEN25LA276.md): Air Tractor AT-402A · Centralia, MO · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 22, 2025 · N1534D · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during low-level maneuvering.
- [NTSB CEN25LA274](https://openairdocs.org/ntsb/CEN25LA274.md): Air Tractor AT502 · Hastings, NE · Accident · No injuries · Class 4 · Limited · Final report · Jul 22, 2025 · N502KB · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.
- [NTSB CEN25FA273](https://openairdocs.org/ntsb/CEN25FA273.md): Cessna T188C · Oregon, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 22, 2025 · N2802J · Substantial damage
  > On July 22, 2025, about 0930 central daylight time, a Cessna T188C, N2802J, was substantially damaged when it was involved in an accident near Oregon, Illinois. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB WPR25LA216](https://openairdocs.org/ntsb/WPR25LA216.md): Cessna 172 · Concrete, WA · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 20, 2025 · N6964A · Substantial damage
  > The pilot’s failure to maintain clearance from powerlines, which resulted in a wire strike.
- [NTSB ENG25WA056](https://openairdocs.org/ntsb/ENG25WA056.md): AgustaWestlands AW119 Mkii · Britânia, state of Goiás, Brazil · Accident · Class 5 · Foreign · Jul 20, 2025 · PR-CBG
- [NTSB CEN25LA266](https://openairdocs.org/ntsb/CEN25LA266.md): Bell B206-B · Bloomington, IL · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 18, 2025 · N975TR · Substantial damage
  > The pilot’s failure to avoid power lines during an aerial application flight.
- [NTSB CEN25FA247](https://openairdocs.org/ntsb/CEN25FA247.md): Zenith CH601 · Pawnee National Grassland, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2025 · N314LB · Destroyed
  > On July 12, 2025, about 1250 mountain daylight time, a Zenith CH601 HDS airplane, N314LB was destroyed when it was involved in an accident in the Pawnee National Grasslands, Colorado. The pilot was fatally injured. The airplane was operated under the…
- [NTSB WPR25LA209](https://openairdocs.org/ntsb/WPR25LA209.md): Pipistrel Alpha Trainer · Colorado City, AZ · Accident · No injuries · Class 4 · Limited · Final report · Jul 11, 2025 · N209ZM · Substantial damage
  > The pilot’s exceedance of the airplane’s never-exceed speed (VNE) during maneuvering, which resulted in the in-flight separation of the left flaperon.
- [NTSB CEN25LA240](https://openairdocs.org/ntsb/CEN25LA240.md): Cub Crafters CCK-1865 · La Garita, CO · Accident · No injuries · Class 4 · Limited · Final report · Jul 7, 2025 · N952SA · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while maneuvering at low altitude in mountainous terrain. Contributing was the pilot’s inadequate preflight planning and aeronautical decision making.
- [NTSB ERA25LA259](https://openairdocs.org/ntsb/ERA25LA259.md): Robbins C/Robbins J Rotorway Exec 162F · Towanda, PA · Accident · No injuries · Class 4 · Limited · Final report · Jul 4, 2025 · N31XR · Destroyed
  > An in-flight fire for reasons that could not be determined due to the extent of fire damage.
- [NTSB CEN25LA237](https://openairdocs.org/ntsb/CEN25LA237.md): Robinson Helicopter R44 II · Pecos, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 4, 2025 · N992TP · Substantial damage
  > The pilot’s failure to maintain aircraft control during gusty wind conditions.
- [NTSB GAA25WA225](https://openairdocs.org/ntsb/GAA25WA225.md): Robinson R22 · Anthony Lagoon, Australia · Accident · Class 5 · Foreign · Jul 1, 2025 · VH-HGE · Substantial damage
- [NTSB CEN25LA231](https://openairdocs.org/ntsb/CEN25LA231.md): Grumman Acft ENG Cor-Schweizer G-164B · Lockport, LA · Accident · No injuries · Class 3 · Limited · Final report · Jul 1, 2025 · N8834H · Substantial damage
  > The pilot’s inadequate planning for the high density altitude conditions which resulted in reduced airplane performance, climb capability, and subsequent forced landing.
- [NTSB GAA25WA226](https://openairdocs.org/ntsb/GAA25WA226.md): Air Tractor AT301 · Cienaga, Colombia · Accident · Minor injuries · Class 5 · Foreign · Jun 30, 2025 · HK4198 · Substantial damage
- [NTSB CEN25FA224](https://openairdocs.org/ntsb/CEN25FA224.md): Vans RV-10 · Capron, IL · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 28, 2025 · N847CS · Substantial damage
  > On June 28, 2025, about 0934 central daylight time, a Vans RV-10 airplane, N847CS, was substantially damaged during an accident near Capron, Illinois. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA25LA240](https://openairdocs.org/ntsb/ERA25LA240.md): Robinson Helicopter R44 II · Hawesville, KY · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 25, 2025 · N144WK · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during low-level agricultural spray operations.
- [NTSB CEN25LA221](https://openairdocs.org/ntsb/CEN25LA221.md): Air Tractor AT-402B · Pierre, SD · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 24, 2025 · N107ML · Substantial damage
  > The pilot’s failure to maintain clearance with the power lines while maneuvering that resulted in an in-flight collision with the power lines and impact with terrain.
- [NTSB ERA25LA237](https://openairdocs.org/ntsb/ERA25LA237.md): Gyro Technic GT-VX2 · Swanzey, NH · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 23, 2025 · N62XF · Substantial damage
  > The pilot’s failure to maintain rotor rpm of the gyroplane during a low approach, while distracted by other aircraft in the airport traffic pattern, which resulted in the pilot’s decision to perform an off-runway landing.
- [NTSB CEN25LA219](https://openairdocs.org/ntsb/CEN25LA219.md): Air Tractor AT-502B · Charleston, MO · Accident · Minor injuries · Class 4 · Limited · Final report · Jun 23, 2025 · N114WL · Substantial damage
  > The pilot’s loss of control during the spray pass, which resulted in impact with vegetation and terrain.
- [NTSB WPR25FA182](https://openairdocs.org/ntsb/WPR25FA182.md): Cessna 172 · Billings, MT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 19, 2025 · N79306 · Substantial damage
  > On June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB ERA25FA230](https://openairdocs.org/ntsb/ERA25FA230.md): Mooney M20F · Beverly, MA · Accident · 2 fatal · Class 3 · Field · Final report · Jun 19, 2025 · N9573M · Substantial damage
  > The pilot’s failure to maintain control of the airplane while maneuvering to return to the airport which resulted in an aerodynamic stall. Contributing to the accident was the improperly installed No. 2 cylinder bottom spark plug by maintenance personnel,…
- [NTSB CEN25LA218](https://openairdocs.org/ntsb/CEN25LA218.md): Piper PA-36-375 · Huron, SD · Accident · No injuries · Class 4 · Limited · Final report · Jun 19, 2025 · N6174A · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during a low-level aerial application, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.
- [NTSB ERA25FA228](https://openairdocs.org/ntsb/ERA25FA228.md): Beech 58 · Tabor City, NC · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 14, 2025 · N82UC · Destroyed
  > On June 14, 2025, at 1245 eastern daylight time, a Beech 58 airplane, N82UC, was destroyed when it was involved in an accident near Tabor City, North Carolina. The private pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code…
- [NTSB ERA25LA229](https://openairdocs.org/ntsb/ERA25LA229.md): Robinson Helicopter R66 · Valparaiso, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 12, 2025 · N633AF · Substantial damage
  > On June 12, 2025, about 1850 eastern daylight time, a Robinson Helicopter R66, N633AF, was substantially damaged when it was involved in an accident near Valparaiso, Florida. The pilot and passenger sustained minor injuries, and a second passenger was not…
- [NTSB CEN25FA198](https://openairdocs.org/ntsb/CEN25FA198.md): Aeronca 7AC · Waterman, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 7, 2025 · N1846E · Substantial damage
  > On June 7, 2025, about 1459 central daylight time, an Aeronca 7AC airplane, N1846E, sustained substantial damage when it was involved in an accident near Waterman, Illinois. The pilot was fatally injured, and the passenger was seriously injured. The airplane…
- [NTSB CEN25LA206](https://openairdocs.org/ntsb/CEN25LA206.md): Xag P100 PRO · Pontiac, IL · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 5, 2025 · N231CU · Substantial damage
  > On June 5, 2025, at 1155 central daylight time, a XAG P100 Pro, N231CU, was substantially damaged when it was involved in an accident near Pontiac, Illinois. The unmanned aerial system (UAS) was operated under Title 14 Code of Federal Regulations as a Part…
- [NTSB ERA25LA217](https://openairdocs.org/ntsb/ERA25LA217.md): Piper PA-23 · Palm Bay, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 4, 2025 · N2109P · Substantial damage
  > A loss of engine power to both of the airplane’s engines due to fuel exhaustion and fuel starvation.
- [NTSB CEN25LA191](https://openairdocs.org/ntsb/CEN25LA191.md): Air Tractor AT-401 · Hamlet, NE · Accident · No injuries · Class 4 · Limited · Final report · Jun 2, 2025 · N60057 · Substantial damage
  > The pilot's failure to maintain clearance from the power lines during low altitude maneuvering.
- [NTSB WPR25LA165](https://openairdocs.org/ntsb/WPR25LA165.md): Weatherly 620B · Lewiston, MT · Accident · No injuries · Class 4 · Limited · Final report · May 30, 2025 · N90393 · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while maneuvering at a low altitude.
- [NTSB CEN25FA184](https://openairdocs.org/ntsb/CEN25FA184.md): Rockwell Commander 114A · Hankamer, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 24, 2025 · N5903N · Destroyed
  > On May 24, 2025, about 1658 central daylight time (CDT), a Rockwell Commander 114A airplane, N5903N, was destroyed when it was involved in an accident near Hankamer, Texas. The private pilot and passenger were fatally injured. The airplane was operated under…
- [NTSB GAA25WA158](https://openairdocs.org/ntsb/GAA25WA158.md): Air Tractor AT602 · St George Aerodrome, Australia · Incident · No injuries · Class 5 · Foreign · Apr 29, 2025 · VH-FAO · Minor damage
- [NTSB GAA25WA155](https://openairdocs.org/ntsb/GAA25WA155.md): Cessna 182 · Allen, Argentina · Accident · 1 fatal · Class 5 · Foreign · Apr 28, 2025 · LV-HTM · Substantial damage
- [NTSB GAA25WA144](https://openairdocs.org/ntsb/GAA25WA144.md): Cessna 188 · Sangkiang Village, Papua New Guinea · Accident · 1 fatal · Class 5 · Foreign · Apr 23, 2025 · VH-SOY · Destroyed
- [NTSB GAA25WA150](https://openairdocs.org/ntsb/GAA25WA150.md): Ayres S2R · SãO José Do Rio Claro, Brazil · Accident · 1 fatal · Class 5 · Foreign · Apr 19, 2025 · PR-PRM · Destroyed
- [NTSB CEN25LA161](https://openairdocs.org/ntsb/CEN25LA161.md): Champion Aeronca 7AC · Estherwood, LA · Accident · No injuries · Class 4 · Limited · Final report · Apr 19, 2025 · N83871 · Substantial damage
  > The non-certificated pilot’s failure to maintain altitude while maneuvering at low altitude that resulted in a descent and impact into terrain.
- [NTSB CEN25LA155](https://openairdocs.org/ntsb/CEN25LA155.md): Quicksilver MX II · Brady, TX · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 11, 2025 · UNREG · Substantial damage
  > The airplane’s encounter with a dust devil, which resulted in a loss of airplane control at a low altitude.
- [NTSB CEN25FA151](https://openairdocs.org/ntsb/CEN25FA151.md): Aeronca 7AC · Cape Fair, MO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 10, 2025 · N83952 · Substantial damage
  > On April 10, 2025, at 0904 central daylight time, an Aeronca 7AC airplane, N83952, was substantially damaged when it was involved in an accident near Cape Fair, Missouri. The pilot received serious injuries, and the passenger was fatally injured. The airplane…
- [NTSB CEN25LA149](https://openairdocs.org/ntsb/CEN25LA149.md): Pphu Ekolot KR-030 Topaz · Platteville, WI · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 8, 2025 · N568RD · Substantial damage
  > The pilot’s failure to maintain clearance from terrain for reasons which could not be determined.
- [NTSB ERA25LA181](https://openairdocs.org/ntsb/ERA25LA181.md): Schleicher ASW-19 · Zephyrhills, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Apr 2, 2025 · N37PL · Substantial damage
  > The pilot’s inadequate inflight planning and an encounter with atmospheric conditions where the lift was not sufficient to maintain flight, resulting in an off-airport landing and collision with a fence.
- [NTSB CEN25LA140](https://openairdocs.org/ntsb/CEN25LA140.md): Air Tractor AT-802A · Cash, AR · Accident · No injuries · Class 4 · Limited · Final report · Mar 28, 2025 · N41687 · Substantial damage
  > The pilot’s failure to maintain clearance from an excavator during low-altitude aerial application operations.

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

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

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