# NTSB investigations: Uncontrolled descent

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 1 of 44 · 2,194 cases

## Latest cases

- [NTSB WPR26FA108](https://openairdocs.org/ntsb/WPR26FA108.md): Vans RV-8 · Hurricane, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Feb 28, 2026 · N80AR · Substantial damage
  > On February 28, 2026, at about 1005 mountain standard time, an experimental amateur-built, Vans Aircraft, RV-8, N80AR, was substantially damaged when it was involved in an accident near Hurricane, Utah. The pilot was fatally injured. The airplane was operated…
- [NTSB WPR25FA147](https://openairdocs.org/ntsb/WPR25FA147.md): Paul Berkovitz Vans RV-10 · Simi Valley, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 3, 2025 · N626PB · Destroyed
  > On May 3, 2025, about 1350 Pacific daylight time, an experimental amateur-built Van’s RV-10, N626PB, was destroyed when it was involved in an accident near Simi Valley, California. The pilot and passenger were fatally injured. The airplane was operated as a…
- [NTSB ERA25FA179](https://openairdocs.org/ntsb/ERA25FA179.md): Cessna 180 · Trilla, IL · Accident · 4 fatal · Class 3 · Field · Preliminary report · Apr 19, 2025 · N4679U · Destroyed
  > On April 19, 2025, at 1016 central daylight time, a Cessna 180G, N4679U, was destroyed when it was involved in an accident near Trilla, Illinois. The private pilot and three passengers were fatally injured. The airplane was operated under Title 14 Code of…
- [NTSB GAA25WA176](https://openairdocs.org/ntsb/GAA25WA176.md): Socata TB 20 · Vaduleni, Moldova · Accident · 1 fatal · Class 5 · Foreign · Oct 27, 2024 · D-EMRT · Destroyed
- [NTSB GAA24WA250](https://openairdocs.org/ntsb/GAA24WA250.md): Beech 95A55 · Birigui, Brazil · Accident · 3 fatal · Class 5 · Foreign · Aug 3, 2024 · PS-RCM · Destroyed
- [NTSB CEN24LA197](https://openairdocs.org/ntsb/CEN24LA197.md): Cessna U206 · Butler, MO · Accident · Serious injuries · Class 4 · Limited · Final report · May 25, 2024 · N29173 · Destroyed
  > The jumper’s unintentional deployment of his emergency parachute and subsequent impact with the airplane’s horizontal stabilizer.
- [NTSB DCA24LA200](https://openairdocs.org/ntsb/DCA24LA200.md): Aergility Atlis 1 · Dunnellon, FL · Accident · No injuries · Class 4 · Limited · Final report · May 24, 2024 · N237KG · Substantial damage
  > An intermittent electrical failure that switched two motor controllers off, resulting in a loss of hover capability and impact with the ground.
- [NTSB ERA22FA262](https://openairdocs.org/ntsb/ERA22FA262.md): Enstrom F28 · Greenville, OH · Accident · 2 fatal · Class 3 · Field · Final report · Jun 7, 2022 · N600TA · Substantial damage
  > An impact with terrain for undetermined reasons.
- [NTSB ERA21LA322](https://openairdocs.org/ntsb/ERA21LA322.md): Diamond DA42 · Hiddenite, NC · Accident · No injuries · Class 3 · Limited · Final report · Aug 9, 2021 · N906ER · Substantial damage
  > The flight instructor’s inability to stop the descent following a practice emergency descent for reasons that could not be determined.
- [NTSB DCA19LA154](https://openairdocs.org/ntsb/DCA19LA154.md): Aurora PAV · Manassas, VA · Accident · No injuries · Limited investigation · Final report · Jun 4, 2019 · N83AU · Substantial damage
  > a loss of hover lift thrust provided by the eight lift motors due to a false on-ground rotor speed reduction command, resulting from excessive vibration.
- [NTSB WPR19LA112](https://openairdocs.org/ntsb/WPR19LA112.md): Air Tractor AT502 · Morganza, LA · Accident · Serious injuries · Class 3 · Limited · Final report · Apr 16, 2019 · N599LA · Substantial damage
  > A loss of aircraft control due to the separation of the elevator pushrod attachment bolt.
- [NTSB WPR19LA027](https://openairdocs.org/ntsb/WPR19LA027.md): Piper PA28 · Presidio, TX · Accident · No injuries · Class 3 · Limited · Final report · Nov 14, 2018 · N1715J · Substantial damage
  > The student pilot’s loss of control at low altitude during a forced landing, which resulted in impact with terrain and substantial damage to the right wing. A contributing factor in the accident was the loss of engine power for undetermined reasons.
- [NTSB ERA16FA194](https://openairdocs.org/ntsb/ERA16FA194.md): Jihlavan Airplanes Sro KP 5 ASA · Rhoadesville, VA · Accident · 2 fatal · Field investigation · Final report · May 24, 2016 · N440JM · Destroyed
  > The pilots' loss of control that necessitated the activation of the parachute system and the airplane manufacturer's inadequate design of the front parachute anchor attachment structure, which resulted in a failure of the parachute after it was deployed in…
- [NTSB ERA16FA001](https://openairdocs.org/ntsb/ERA16FA001.md): Piper PA32R · Westminster, SC · Accident · 4 fatal · Field investigation · Final report · Oct 2, 2015 · N782TM · Destroyed
  > The pilot's loss of airplane control for reasons that could not be determined based on the available information.
- [NTSB ENG15WA040](https://openairdocs.org/ntsb/ENG15WA040.md): Bell 407 · Morobe Province, Papua New Guinea · Incident · No injuries · Foreign investigation · May 2, 2015 · P2-HSL · No damage
  > On May 2, 2015, a Bell Helicopters 407 powered by a Roll-Royce M250-C47B turboshaft experienced an unexpected uncommanded high rate of descent while on approach to the helipad with an external load of two diesel fuel drums. The pilot jettisoned his load and…
- [NTSB GAA15CA053](https://openairdocs.org/ntsb/GAA15CA053.md): Aero SP Z O O AT 4 LSA · Colorado Springs, CO · Accident · Minor injuries · Data collection · Final report · Apr 30, 2015 · N344UA · Substantial damage
  > The pilot's decision to perform aerobatic maneuvers in an airplane not certified for aerobatic flight, which resulted in a loss of control and collision with terrain.
- [NTSB CEN15WA152](https://openairdocs.org/ntsb/CEN15WA152.md): Avions Robin Robin DR 400/140 B · Yverdon LSGY, Switzerland · Accident · 2 fatal · Foreign investigation · Feb 23, 2015 · HB-KDD · Destroyed
- [NTSB CEN15FA141](https://openairdocs.org/ntsb/CEN15FA141.md): Richard Lacourse Wheeler Express · Kersey, CO · Accident · 2 fatal · Field investigation · Final report · Feb 11, 2015 · N564ER · Destroyed
  > The pilot's failure to maintain airplane control during an off-airport forced landing following a total loss of engine power for reasons that could not be determined during postaccident examination of the engine. Contributing to the accident was the pilots'…
- [NTSB WPR13FA116](https://openairdocs.org/ntsb/WPR13FA116.md): Cessna 172S · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Feb 7, 2013 · N328SP · Destroyed
  > The pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.
- [NTSB ERA13FA101](https://openairdocs.org/ntsb/ERA13FA101.md): Piper PA-30 · Jasper, AL · Accident · 3 fatal · Field investigation · Final report · Jan 2, 2013 · N7700Y · Destroyed
  > The student pilot’s poor judgment to take a multiengine airplane for which he did not have experience or permission to operate and depart into night instrument meteorological conditions, which resulted in a loss of airplane control and impact with terrain.
- [NTSB CEN12FA251](https://openairdocs.org/ntsb/CEN12FA251.md): Cirrus Design SR22 · Newcomerstown, OH · Accident · 1 fatal · Field investigation · Final report · Apr 21, 2012 · N110EB · Substantial damage
  > The pilot’s loss of airplane control in instrument meteorological conditions due to his distraction by electrical system anomalies, which resulted in an uncontrolled descent. The reason for the electrical system anomalies could not be determined.
- [NTSB ERA12CA137](https://openairdocs.org/ntsb/ERA12CA137.md): Robinson Helicopter R22 Beta · St Petersburg, FL · Accident · No injuries · Data collection · Final report · Jan 6, 2012 · N8066U · Substantial damage
  > The flight instructor's delayed remedial action during the pilot-receiving-instruction's practice autorotation that developed a high rate of descent. Contributing to the accident was the pilot-receiving-instruction's improper control inputs during the…
- [NTSB CEN12FA108](https://openairdocs.org/ntsb/CEN12FA108.md): Piper PA-32-260 · Bryan, TX · Accident · 5 fatal · Field investigation · Final report · Dec 20, 2011 · N3590T · Substantial damage
  > The pilot’s inadvertent encounter with severe weather, which resulted in the airplane’s left wing failing in positive overload. Contributing to the accident was the pilot’s reliance on outdated weather information that he received on his in-cockpit…
- [NTSB WPR12FA044](https://openairdocs.org/ntsb/WPR12FA044.md): Mooney M20M · Pomona, CA · Accident · 1 fatal · Field investigation · Final report · Nov 18, 2011 · N741SB · Substantial damage
  > The pilot’s failure to maintain sufficient altitude to clear obstructions while maneuvering on the base leg of the traffic pattern for landing.
- [NTSB ANC11CA058](https://openairdocs.org/ntsb/ANC11CA058.md): Aviat A-1B · Palmer, AK · Accident · Serious injuries · Data collection · Final report · Jul 6, 2011 · N949AK · Substantial damage
  > The pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.
- [NTSB WPR11FA155](https://openairdocs.org/ntsb/WPR11FA155.md): Muse KR2 · Newberry Springs, CA · Accident · 1 fatal · Field investigation · Final report · Mar 7, 2011 · N122B · Substantial damage
  > The airplane’s encounter with severe turbulence, which resulted in the in-flight breakup of the airplane. Contributing to the accident was the pilot’s inadequate preflight planning.
- [NTSB CEN11CA003](https://openairdocs.org/ntsb/CEN11CA003.md): Cessna 310J · St. Johns, MI · Accident · Minor injuries · Data collection · Final report · Oct 1, 2010 · N3051L · Substantial damage
  > The failure by the pilot to attain/maintain a climb rate for undetermined reasons during a go-around.
- [NTSB WPR10CA469](https://openairdocs.org/ntsb/WPR10CA469.md): Piper PA-18-150 · White Sulphur Springs, MT · Accident · No injuries · Data collection · Final report · Sep 24, 2010 · N4036E · Substantial damage
  > The pilot's failure to maintain control of the airplane during a go-around in turbulent wind conditions, which resulted in a collision with trees.
- [NTSB ERA10FA464](https://openairdocs.org/ntsb/ERA10FA464.md): Cessna 150H · DeLand, FL · Accident · 2 fatal · Field investigation · Final report · Sep 4, 2010 · N23471 · Substantial damage
  > The pilot's failure to maintain adequate airspeed and airplane control during the initial climb, which resulted in an aerodynamic stall, wire strike, and subsequent impact with the ground.
- [NTSB CEN10LA492](https://openairdocs.org/ntsb/CEN10LA492.md): Infinity Infinity · Little Rock, AR · Accident · Serious injuries · Limited investigation · Final report · Aug 12, 2010 · N208FA · Substantial damage
  > The failure of the control lanyard for undetermined reasons.
- [NTSB ERA10WA116](https://openairdocs.org/ntsb/ERA10WA116.md): Piper PA-32-300 · Bimini, Bahamas, Bahamas · Accident · 3 fatal · Foreign investigation · Jan 17, 2010 · N4219R · Destroyed
  > On January 17, 2010, at approximately 1545 eastern standard time, a Piper PA-32-300, N4219R, crashed approximately 500 yards northwest of the Bimini Bay Resort, North Bimini, Bahamas. The flight departed Lynden Pindling International Airport, Nassau, Bahamas…
- [NTSB ERA09WA166](https://openairdocs.org/ntsb/ERA09WA166.md): Embraer EMB110 · Coari, Brazil · Accident · 24 fatal · Foreign investigation · Feb 7, 2009 · PR-SAE · Destroyed
  > On February 7, 2009, at 1810 universal time coordinates, an Embraer EMB 110P1, Brazilian registry PT-SEA, operated by Manaus Aerotaxi as a commuter flight, experienced an unknown problem after take-off from the Coari, Amazonas Airport (SWKO) in Coari, Brazil,…
- [NTSB WPR09LA032](https://openairdocs.org/ntsb/WPR09LA032.md): Universal Globe · Wallace, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2008 · N80715 · Destroyed
  > The pilot's incapacitation during cruise for unknown reasons that resulted in a loss of aircraft control.
- [NTSB NYC08LA264](https://openairdocs.org/ntsb/NYC08LA264.md): Piper PA-32RT-300T · Palakta, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 3, 2008 · N39758 · Substantial damage
  > The partial loss of engine power for undetermined reasons.
- [NTSB NYC08LA224](https://openairdocs.org/ntsb/NYC08LA224.md): Aero Vodochody Aero. Works L-29 Delfin · Millville, NJ · Accident · 2 fatal · Limited investigation · Final report · Jun 22, 2008 · N29DJ · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of a clogged fuel filter that was not identified due to the pilot's inadequate preflight inspection.
- [NTSB SEA08LA072](https://openairdocs.org/ntsb/SEA08LA072.md): Wooters Lancair ES · Albany, OR · Accident · 3 fatal · Limited investigation · Final report · Feb 8, 2008 · N329BW · Substantial damage
  > The pilot-in-command's failure to maintain aircraft control while in cruise flight. Contributing to the accident were inadequate planning/decision, icing conditions, and continued flight into known icing conditions.
- [NTSB LAX08FA047](https://openairdocs.org/ntsb/LAX08FA047.md): Beechcraft V35B · Selma, CA · Accident · 1 fatal · Field investigation · Final report · Jan 18, 2008 · N4662M · Substantial damage
  > The pilot's failure to maintain control resulting in the in-flight break-up of the airplane due to aerodynamic overload. Contributing factors included the pilot's impairment due to multiple medical conditions and due to recent use of alcohol.
- [NTSB CHI07LA086](https://openairdocs.org/ntsb/CHI07LA086.md): Camair 480 · East Liberty, OH · Accident · 1 fatal · Limited investigation · Final report · Mar 8, 2007 · N209 · Destroyed
  > The uncontrolled descent for undetermined reasons.
- [NTSB CHI07FA046](https://openairdocs.org/ntsb/CHI07FA046.md): Rockwell International 114 · Jasper, TN · Accident · 2 fatal · Field investigation · Final report · Dec 26, 2006 · N55MB · Substantial damage
  > The pilot's inability to maintain altitude due to excessive airframe ice accretion, resulting in an in-flight collision with trees and terrain. Additional causes were the pilot's continued flight in icing conditions once they had been encountered, and his…
- [NTSB SEA07FA035](https://openairdocs.org/ntsb/SEA07FA035.md): Beech D95A · Gilroy, CA · Accident · 3 fatal · Field investigation · Final report · Dec 18, 2006 · N144PG · Destroyed
  > The certified flight instructor's failure to maintain directional control of the airplane and inadequate supervision of the flight, which resulted in a stall/spin.
- [NTSB LAX06TA234](https://openairdocs.org/ntsb/LAX06TA234.md): Let Super Blanik L-23 · Los Alamitos, CA · Accident · No injuries · Final report · Jul 11, 2006 · N381BA · Substantial damage
  > failure of the winch operator to maintain an adequate winch tow speed, resulting in a stall and hard landing.
- [NTSB NYC06CA140](https://openairdocs.org/ntsb/NYC06CA140.md): Cessna A185E · Turner, ME · Accident · No injuries · Data collection · Final report · Jun 6, 2006 · N185RW · Substantial damage
  > The pilot's failure to obtain the proper touchdown point, resulting in a runway undershoot, and substantial damage to the airplane.
- [NTSB DEN06LA016](https://openairdocs.org/ntsb/DEN06LA016.md): Abruzzo Grom-1 · Kendall, KS · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 2005 · N96YD · Minor damage
  > the downdraft forcing the balloon into the power lines. A contrbuting factor was the clear air turbulence and the power lines.
- [NTSB DEN05CA138](https://openairdocs.org/ntsb/DEN05CA138.md): Robinson R44 II · Jackson, WY · Accident · No injuries · Data collection · Final report · Sep 9, 2005 · N944U · Substantial damage
  > the pilot's failure to maintain aircraft control during initial takeoff climb resulting in an uncontrolled descent and impact with terrain. A contributing factor was the pilot's encounter in settling with power.
- [NTSB CHI05CA120](https://openairdocs.org/ntsb/CHI05CA120.md): Brantly Helicopter B-2B · Lakeview, MI · Accident · No injuries · Data collection · Final report · May 20, 2005 · N2274U · Substantial damage
  > The dual student failed to maintain adequate rotor rpm during the practice autorotation and the instructor's delay in attempting remedial action. A factor associated with the accident was the soft terrain that was encountered.
- [NTSB ATL05CA030](https://openairdocs.org/ntsb/ATL05CA030.md): Mooney M20J · Statesville, NC · Accident · No injuries · Data collection · Final report · Nov 27, 2004 · N2201 · Substantial damage
  > the flight instructors improper use of the flight controls on rotation during a short field takeoff resulting in the airplane becoming airborne, stall, and collision with the ground. A factor in the accident was the instructors failure to brief procedures for…
- [NTSB ATL04CA170](https://openairdocs.org/ntsb/ATL04CA170.md): Cessna 172R · Atlanta, GA · Accident · Minor injuries · Data collection · Final report · Aug 28, 2004 · N26486 · Substantial damage
  > The intentional interuption of the flight controls in flight that resulted in a uncontrolled descent and collision with a fence.
- [NTSB SEA04CA122](https://openairdocs.org/ntsb/SEA04CA122.md): Robinson R22 Mariner · Hillsboro, OR · Accident · Minor injuries · Data collection · Final report · Jul 5, 2004 · N856HA · Substantial damage
  > The pilot's failure to maintain aircraft control resulting in an uncontrolled descent and subsequent roll over. Low altitude flight and the pilot's encounter with settling with power were contributing factors.
- [NTSB NYC04CA074](https://openairdocs.org/ntsb/NYC04CA074.md): Danbrook Corbin Jr Ace · Pittsgrove, NJ · Accident · No injuries · Data collection · Final report · Feb 13, 2004 · N823DP · Substantial damage
  > The pilot's improper flare and his failure to maintain adequate airspeed which resulted in a stall and a hard landing.
- [NTSB ATL04LA050](https://openairdocs.org/ntsb/ATL04LA050.md): Baker KR-2 · St. Marys, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 21, 2003 · N93PC · Substantial damage
  > The pilot's failure to maintain airspeed during climb out which resulted in a stall and inflight collision with trees.

Next page: https://openairdocs.org/ntsb-phases/650/cases.md?page=2

## 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 = 650)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/650/cases

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