# NTSB investigations: Approach

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 25 of 420 · 20,992 cases

## Cases, newest first

- [NTSB GAA20CA010](https://openairdocs.org/ntsb/GAA20CA010.md): Cessna 150 · Fallon, NV · Accident · No injuries · Data collection · Final report · Oct 8, 2019 · N50618 · Substantial damage
  > The pilot's improper preflight fuel planning and quantity inspection, which resulted in fuel exhaustion, a total loss of engine power, a forced landing on unsuitable terrain, and a subsequent nose-over.
- [NTSB WPR20WA002](https://openairdocs.org/ntsb/WPR20WA002.md): Cessna 172 · Maharashtra, India · Accident · 1 fatal · Foreign investigation · Oct 5, 2019 · VT-HRP · Substantial damage
  > On October 5, 2019, at 0628 coordinated universal time, a Cessna 172R airplane, VT-HRP, collided with a fence during approach at the Shirpur Airport, Maharashtra, India. The student pilot was fatally injured and the airplane was substantially damaged. The…
- [NTSB ERA20LA011](https://openairdocs.org/ntsb/ERA20LA011.md): Piper PA46 · Harrisburg, PA · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 4, 2019 · N4385K · Substantial damage
  > A total loss of engine power for reasons that could not be determined following a successful engine run.
- [NTSB CEN20FA001](https://openairdocs.org/ntsb/CEN20FA001.md): Socata TBM 700 · Lansing, MI · Accident · 5 fatal · Class 3 · Field · Final report · Oct 3, 2019 · N700AQ · Substantial damage
  > The pilot’s failure to maintain airspeed during final approach, which resulted in a loss of control and an aerodynamic stall at a low altitude, and his decision to operate the airplane outside of the approved weight and balance envelope.
- [NTSB ERA20LA052](https://openairdocs.org/ntsb/ERA20LA052.md): Beech 55 · Grove City, PA · Accident · No injuries · Class 3 · Limited · Final report · Oct 1, 2019 · N9404Q · Substantial damage
  > The pilot’s mismanagement of the airplane’s available fuel, which resulted in a partial loss of engine power to the left engine, and his subsequent failure to maintain directional control of the airplane while on final approach to the runway.
- [NTSB GAA19CA570](https://openairdocs.org/ntsb/GAA19CA570.md): Cirrus SR22 · Lexington, NE · Accident · Serious injuries · Data collection · Final report · Sep 25, 2019 · N1216N · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during a go around, which resulted in an aerodynamic stall and a hard landing.
- [NTSB CEN19TA333](https://openairdocs.org/ntsb/CEN19TA333.md): Lancair Lancair 320 · Bolivar, MO · Accident · No injuries · Class 3 · Final report · Sep 25, 2019 · N52WL · Substantial damage
  > Inadequate maintenance of the airplane, which resulted in a lack of adequate hydraulic fluid, malfunction of the landing gear extension system, and the landing gear collapse on landing.
- [NTSB ERA19LA280](https://openairdocs.org/ntsb/ERA19LA280.md): Cessna 172 · Manville, NJ · Accident · No injuries · Class 3 · Limited · Final report · Sep 24, 2019 · N78192 · Substantial damage
  > A total loss of engine power due to the ingestion of sealant material that had loosened inside the carburetor airbox.
- [NTSB CEN19LA326](https://openairdocs.org/ntsb/CEN19LA326.md): Vans Vans RV-10 · Lancaster, TX · Accident · No injuries · Class 3 · Limited · Final report · Sep 21, 2019 · N569JC · Substantial damage
  > A partial loss of engine power due to a faulty magneto/ignition system, which resulting in a forced landing.
- [NTSB GAA19CA569](https://openairdocs.org/ntsb/GAA19CA569.md): Diamond DA20 · Fort Wayne, IN · Accident · No injuries · Data collection · Final report · Sep 20, 2019 · N212DX · Substantial damage
  > The pilot's improper preflight fuel planning, which resulted in fuel exhaustion, a total loss of engine power, and impact with a tree during an off-airport landing.
- [NTSB ERA19TA278](https://openairdocs.org/ntsb/ERA19TA278.md): Cessna 208 · Pepperell, MA · Accident · No injuries · Class 3 · Final report · Sep 20, 2019 · N895SF · Substantial damage
  > The pilot's loss of control when the airplane encountered a downdraft during landing approach, which resulted in a subsequent hard landing and gear collapse.
- [NTSB ERA19LA274](https://openairdocs.org/ntsb/ERA19LA274.md): Socata TB9 · Fort Meade, MD · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 17, 2019 · N2824R · Substantial damage
  > The failure of the carburetor intake scat tubing, which resulted in a partial loss of engine power.
- [NTSB CEN19MA312](https://openairdocs.org/ntsb/CEN19MA312.md): Convair 440 · Monclova, OH · Accident · 2 fatal · Class 3 · Major · Final report · Sep 11, 2019 · N24DR · Destroyed
  > The flight crew’s failure to maintain the proper airspeed on final approach, which resulted in an inadvertent aerodynamic stall and impact with trees, and terrain. Contributing to the accident was the flight crew’s fatigue due to the overnight flight schedule.
- [NTSB ERA19TA276](https://openairdocs.org/ntsb/ERA19TA276.md): Beech 23 · Panama City, FL · Accident · No injuries · Class 3 · Final report · Sep 10, 2019 · N3555R · Substantial damage
  > A total loss of engine power due to an obstructed fuel vent, and the flight instructor's failure to ensure that the student did an adequate preflight inspection, which resulted in a forced landing.
- [NTSB ERA19FA265](https://openairdocs.org/ntsb/ERA19FA265.md): Vans RV-12 · Lady Lake, FL · Accident · 1 fatal · Class 3 · Field · Final report · Sep 6, 2019 · N767FS · Destroyed
  > The pilot's loss of pitch control due to the in-flight opening of the canopy for reasons that could not be determined.
- [NTSB GAA19CA536](https://openairdocs.org/ntsb/GAA19CA536.md): Cessna 310 · Tahlequah, OK · Accident · Minor injuries · Data collection · Final report · Sep 5, 2019 · N7673Q · Substantial damage
  > The total loss of right engine power due to fuel starvation and the pilot's improper fuel management.
- [NTSB WPR19WA272](https://openairdocs.org/ntsb/WPR19WA272.md): Beech B300 · Calamba, Philippines · Accident · 9 fatal · Foreign investigation · Sep 1, 2019 · RP-C2296 · Destroyed
  > On September 1, 2019 about 0541 universal coordinated time, a Beech B-300, RP-C2296, collided with terrain near Brgy. Pansol, Calamba, Laguna, Philippines. The two flight crew and seven passengers were fatally injured. Two persons on the ground received minor…
- [NTSB CEN19LA299](https://openairdocs.org/ntsb/CEN19LA299.md): Piper PA28 · Conroe, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 31, 2019 · N55633 · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB DCA19CA208](https://openairdocs.org/ntsb/DCA19CA208.md): Mcdonnell Douglas MD88 · Chicago, IL · Accident · Serious injuries · Data collection · Final report · Aug 27, 2019 · N911DL · No damage
  > an encounter with convective turbulence during descent.
- [NTSB WPR19LA243](https://openairdocs.org/ntsb/WPR19LA243.md): Mooney M20C · Reno, NV · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 26, 2019 · N78988 · Substantial damage
  > The pilot's improper inflight fuel management, which resulted in fuel starvation and a total loss of engine power.
- [NTSB ERA19LA260](https://openairdocs.org/ntsb/ERA19LA260.md): DG Flugzeugbau DG-500MB · Robertsdale, AL · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 24, 2019 · N165MB · Substantial damage
  > Impact with trees during the landing approach for reasons that could not be determined based on the available information.
- [NTSB GAA19CA557](https://openairdocs.org/ntsb/GAA19CA557.md): Beech 35 · Fort Myers, FL · Accident · No injuries · Data collection · Final report · Aug 23, 2019 · N9422S · Substantial damage
  > The airplane’s impact with a bird during approach.
- [NTSB ERA19LA255](https://openairdocs.org/ntsb/ERA19LA255.md): Cessna 310 · Tampa, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 21, 2019 · N2299F · Substantial damage
  > The failure of the right main landing gear to fully extend and lock for reasons that could not be determined.
- [NTSB CEN19LA281](https://openairdocs.org/ntsb/CEN19LA281.md): Stinson 108 · Grand Rapids, MN · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 21, 2019 · N647C · Substantial damage
  > A loss of engine power after takeoff for undetermined reasons.
- [NTSB CEN19FA270](https://openairdocs.org/ntsb/CEN19FA270.md): Pitts S2 · New Orleans, LA · Accident · 2 fatal · Class 3 · Field · Final report · Aug 16, 2019 · N600DF · Destroyed
  > A loss of control for undetermined reasons.
- [NTSB WPR19FA219](https://openairdocs.org/ntsb/WPR19FA219.md): Capes Murphy Moose · Marysville, WA · Accident · 1 fatal · Class 3 · Field · Final report · Aug 15, 2019 · N525SG · Destroyed
  > The pilot’s failure to maintain terrain clearance while turning to final approach to avoid a collision with another airplane flying a straight in approach to the same runway. Contributing to the accident was the pilots of both airplanes failure to adequately…
- [NTSB CEN19LA267](https://openairdocs.org/ntsb/CEN19LA267.md): De Havilland DHC6 · San Marcos, TX · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 15, 2019 · N322AV · Substantial damage
  > The pilot's delayed go-around attempt and the flight instructor's delayed remedial action that resulted in a nose-down impact with terrain during an attempted go-around.
- [NTSB ERA19LA247](https://openairdocs.org/ntsb/ERA19LA247.md): Fantasy Air Allegro · Boone, NC · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 14, 2019 · N5020X · Destroyed
  > The reported total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB CEN19WA272](https://openairdocs.org/ntsb/CEN19WA272.md): Reims Aviation Cessna F172N · Lesnovo, Bulgaria · Incident · No injuries · Foreign investigation · Aug 14, 2019 · LZ-SPB · No damage
  > On August 14, 2018, about 0750 coordinated universal time, a Reims Aviation Cessna F172N airplane, Bulgarian registration number LZ-SPB, had a forced landing at the Lesnovo Airport (LBLS), Lesnovo, Bulgaria, following an inflight loss of engine power. The…
- [NTSB WPR19FA215](https://openairdocs.org/ntsb/WPR19FA215.md): North American T28A · Ontario, OR · Accident · 1 fatal · Class 3 · Field · Final report · Aug 9, 2019 · N9862C · Substantial damage
  > A total loss of engine power due to the improperly adjusted carburetor idle valve.
- [NTSB WPR19FA212](https://openairdocs.org/ntsb/WPR19FA212.md): Wheeler Express Series 2000 · Camarillo, CA · Accident · 2 fatal · Class 3 · Field · Final report · Aug 7, 2019 · N43FD · Substantial damage
  > The pilot’s failure to maintain adequate airspeed on final approach, which resulted in exceedance of the airplane’s critical angle of attack and an aerodynamic stall at an altitude that precluded recovery.
- [NTSB GAA19CA490](https://openairdocs.org/ntsb/GAA19CA490.md): Diamond DA20 · Pueblo, CO · Accident · No injuries · Data collection · Final report · Aug 7, 2019 · N979DA · Substantial damage
  > The student pilot's failure to maintain the runway heading during an attempted aborted landing, which resulted in a runway excursion onto rough terrain.
- [NTSB WPR19FA209](https://openairdocs.org/ntsb/WPR19FA209.md): Cessna 182 · Wolf Point, MT · Accident · 2 fatal · Class 3 · Field · Final report · Aug 5, 2019 · N3469R · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an accelerated aerodynamic stall and subsequent loss of control.
- [NTSB ERA19WA241](https://openairdocs.org/ntsb/ERA19WA241.md): Cessna 510 · Los Angeles, Chile · Accident · 1 fatal · Foreign investigation · Aug 2, 2019 · CC-ANR · Destroyed
  > The government of Chile has notified the NTSB of an accident involving a Cessna 510 airplane that occurred on August 2, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Chile's investigation under the provisions of…
- [NTSB WPR19LA205](https://openairdocs.org/ntsb/WPR19LA205.md): Md Helicopter 369 · Eugene, OR · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 28, 2019 · N438RC · Substantial damage
  > The left seat pilot’s failure to account for environmental conditions conducive to a loss of tail rotor effectiveness, which resulted in a loss of tail rotor effectiveness and subsequent loss of control.
- [NTSB CEN19LA246](https://openairdocs.org/ntsb/CEN19LA246.md): Swearingen SA227 · El Paso, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 27, 2019 · N681TR · Substantial damage
  > Failure of the left main landing gear to fully extend due to a lack of hydraulic fluid and during emergency extension procedures, which resulted in the collapse of the landing gear during landing and the subsequent runway excursion and collision with a sign.
- [NTSB GAA19WA458](https://openairdocs.org/ntsb/GAA19WA458.md): Sikorsky S92 · Sable Island, Canada · Incident · No injuries · Foreign investigation · Jul 24, 2019 · C-GICB · No damage
  > The government of Canada has notified the NTSB of an accident involving a SIKORSKY S92 helicopter that occurred on July 24, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions…
- [NTSB CEN19FA236](https://openairdocs.org/ntsb/CEN19FA236.md): Beech 95B55 · Chadron, NE · Accident · 3 fatal · Class 2 · Field · Final report · Jul 24, 2019 · N8910U · Substantial damage
  > The pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR19LA198](https://openairdocs.org/ntsb/WPR19LA198.md): Cessna 172 · Madras, OR · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 22, 2019 · N3761L · Substantial damage
  > A partial loss of power during final approach for undetermined reasons as postaccident examinations did not reveal any preimpact anomalies with the airplane or engine.
- [NTSB OPS19WA018](https://openairdocs.org/ntsb/OPS19WA018.md): Airbus A321 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jul 22, 2019 · YL-LCQ · No damage
  > The Air Accidents Investigation Branch (AAIB) of the United Kingdom has notified the NTSB of an incident involving an Airbus A-321-231, which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…
- [NTSB ENG19WA036](https://openairdocs.org/ntsb/ENG19WA036.md): Airbus A330 · Islamabad, Pakistan · Incident · No injuries · Foreign investigation · Jul 22, 2019 · A7-ACG · No damage
  > The Aircraft Accident Investigation Board (AAIB) of Pakistan has notified the NTSB of an incident involving an Airbus A330-200 airplane which occurred on July 22, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation…
- [NTSB WPR19LA202](https://openairdocs.org/ntsb/WPR19LA202.md): Cessna 172 · Port Townsend, WA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 21, 2019 · N3863L · Substantial damage
  > The loss of engine power for reasons that could not be determined based on available information.
- [NTSB GAA19CA451](https://openairdocs.org/ntsb/GAA19CA451.md): Cessna 402 · St. Louis, MO · Accident · No injuries · Data collection · Final report · Jul 21, 2019 · N300SN · Substantial damage
  > The airplane’s collision with a bird during short final.
- [NTSB ANC19TA037](https://openairdocs.org/ntsb/ANC19TA037.md): Piper PA19 · Skwentna, AK · Accident · Serious injuries · Class 4 · Final report · Jul 21, 2019 · N6PF · Substantial damage
  > The pilot’s loss of directional control during a go-around and his failure to assess the wind conditions appropriately before a landing attempt.
- [NTSB GAA19WA455](https://openairdocs.org/ntsb/GAA19WA455.md): Cirrus SR22 · Kolding, Denmark · Incident · No injuries · Foreign investigation · Jul 17, 2019 · N830CD · No damage
  > The government of Denmark has notified the NTSB of an accident involving a CIRRUS SR22 airplane that occurred on July 17, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the provisions of…
- [NTSB ERA19LA229](https://openairdocs.org/ntsb/ERA19LA229.md): Progressive Aerodyne Searey · Crescent, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 16, 2019 · N632FG · Substantial damage
  > The pilot’s misjudgment of his altitude during landing and subsequent decrease in pitch attitude, which resulted in a collision with the water.
- [NTSB CEN19LA226](https://openairdocs.org/ntsb/CEN19LA226.md): Cashen Super Acro Sport · Detroit Lakes, MN · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 16, 2019 · N61SC · Substantial damage
  > An open circuit in the engine's electrical switch box, which resulted in a partial loss of engine power and subsequent forced landing.
- [NTSB GAA19CA421](https://openairdocs.org/ntsb/GAA19CA421.md): Willie Bennett Glastar · Lompoc, CA · Accident · Minor injuries · Data collection · Final report · Jul 15, 2019 · N345BP · Substantial damage
  > The pilot's failure to maintain a proper glidepath during a night landing, which resulted in impact with a tree.
- [NTSB GAA19CA409](https://openairdocs.org/ntsb/GAA19CA409.md): Diamond DA 40 · Denver, CO · Accident · No injuries · Data collection · Final report · Jul 13, 2019 · N388JP · Substantial damage
  > The pilot receiving instruction's failure to maintain the runway heading and bank control during landing in crosswind conditions, which resulted in a go-around and subsequent collision with a runway light.
- [NTSB GAA19CA467](https://openairdocs.org/ntsb/GAA19CA467.md): Cessna 525 · Orlando, FL · Accident · No injuries · Data collection · Final report · Jul 12, 2019 · N262BK · Substantial damage
  > The airplane’s impact with a bird during approach.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=26

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

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=25

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