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

## Cases, newest first

- [NTSB CEN21LA002](https://openairdocs.org/ntsb/CEN21LA002.md): Cessna 182 · Byers, CO · Accident · No injuries · Class 3 · Limited · Final report · Oct 3, 2020 · N9901E · Substantial damage
  > A partial loss of engine power for undetermined reasons.
- [NTSB WPR21LA002](https://openairdocs.org/ntsb/WPR21LA002.md): Zenith CH601 · Burlington, WA · Accident · No injuries · Class 3 · Limited · Final report · Oct 1, 2020 · N601SA · Substantial damage
  > The total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN20WA426](https://openairdocs.org/ntsb/CEN20WA426.md): Cirrus SR22 · Le Chevillotte, France · Accident · 3 fatal · Class 5 · Foreign · Sep 28, 2020 · N918SE · Destroyed
- [NTSB CEN20LA421](https://openairdocs.org/ntsb/CEN20LA421.md): Beech A36 · Lago Vista, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 28, 2020 · N104RK · Substantial damage
  > The pilot’s mismanagement of the fuel system which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the pilot’s failure to maintain airspeed which resulted in the airplane exceeding its critical angle of attack…
- [NTSB WPR20LA325](https://openairdocs.org/ntsb/WPR20LA325.md): Cessna T210 · Bridgeport, CA · Accident · No injuries · Class 4 · Limited · Final report · Sep 25, 2020 · N300JS · Substantial damage
  > An inadvertent retraction of the flaps during a go-around by the pilot-rated passenger, which caused the airplane to settle onto the runway with the landing gear retracted.
- [NTSB CEN20LA419](https://openairdocs.org/ntsb/CEN20LA419.md): Cessna 172S · San Marcos, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 25, 2020 · N108VK · 2 aircraft · Substantial damage
  > The F1 pilot’s failure to see and avoid the lower altitude Cessna while on final approach for landing. Contributing to the accident were the restrictions to pilot visibility inherent to low- and high-wing airplanes, and both pilots’ failure to recognize the…
- [NTSB ERA20LA336](https://openairdocs.org/ntsb/ERA20LA336.md): Cessna 172 · La Grange, NC · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 23, 2020 · N5439E · Substantial damage
  > The pilot’s failure to maintain directional control during final approach, which resulted in a collision with trees.
- [NTSB ERA20LA332](https://openairdocs.org/ntsb/ERA20LA332.md): Glasair 1RG · Hagerstown, MD · Accident · No injuries · Class 3 · Limited · Final report · Sep 23, 2020 · N324DJ · Substantial damage
  > The pilot's inadequate preflight inspection and fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN20LA401](https://openairdocs.org/ntsb/CEN20LA401.md): Piper PA32 · Kokomo, IN · Accident · 3 fatal · Class 3 · Limited · Final report · Sep 20, 2020 · N8213X · Destroyed
  > The pilot’s inadequate visual lookout, which resulted in a collision with a utility pole and the subsequent collision with terrain.
- [NTSB ERA20LA331](https://openairdocs.org/ntsb/ERA20LA331.md): Piper PA31 · Fort Lauderdale, FL · Accident · No injuries · Class 3 · Limited · Final report · Sep 19, 2020 · N257SH · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s decision to continue to the destination following the loss of engine power to the first engine.
- [NTSB CEN20WA408](https://openairdocs.org/ntsb/CEN20WA408.md): Raven Aircraft Corppration Raven · Moosburg an der Isar, Germany · Accident · 2 fatal · Foreign investigation · Sep 19, 2020 · N651RA · Destroyed
- [NTSB CEN20LA399](https://openairdocs.org/ntsb/CEN20LA399.md): Vans RV9 · Zeeland, MI · Accident · 2 fatal · Class 3 · Limited · Final report · Sep 19, 2020 · N94KJ · Destroyed
  > The pilot’s failure to maintain airspeed during a visual approach in dark night conditions, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the pilot’s lack of recent flight experience at night.
- [NTSB CEN20LA397](https://openairdocs.org/ntsb/CEN20LA397.md): Zenith CH 750 · Montgomery City, MO · Accident · No injuries · Class 3 · Limited · Final report · Sep 16, 2020 · N4744M · Substantial damage
  > The pilot’s inadequate fuel management and flight planning, which led to a total loss of engine power due to fuel exhaustion and a forced landing into rough terrain.
- [NTSB CEN20CA396](https://openairdocs.org/ntsb/CEN20CA396.md): Piper PA46 · Jacksonville, TX · Accident · Minor injuries · Class 4 · Data collection · Final report · Sep 16, 2020 · N972DD · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during the landing approach and the exceedance of the airplane’s critical angle of attack at low altitude resulting in an aerodynamic stall. Contributing was the instructor pilot’s failure to…
- [NTSB WPR20LA304](https://openairdocs.org/ntsb/WPR20LA304.md): Cessna 172 · Seeley Lake, MT · Accident · 2 fatal · Class 3 · Limited · Final report · Sep 13, 2020 · N3720R · Substantial damage
  > The noninstrument-rated pilot’s encounter with instrument meteorological conditions during a night visual approach due to wildfire smoke, which resulted in controlled flight into terrain.
- [NTSB ERA20LA315](https://openairdocs.org/ntsb/ERA20LA315.md): Vans RV9 · Steinhatchee, FL · Accident · 2 fatal · Class 3 · Limited · Final report · Sep 13, 2020 · N4889R · Destroyed
  > The failure of the air traffic controller to provide hazardous weather information to the pilot, resulting in the flight’s encounter with strong updraft conditions, an inflight loss of airplane control, and an in-flight breakup. Contributing was the pilot’s…
- [NTSB WPR20LA308](https://openairdocs.org/ntsb/WPR20LA308.md): Piper PA 30 · Billings, MT · Accident · Serious injuries · Class 3 · Limited · Final report · Sep 12, 2020 · N7602Y · Substantial damage
  > The pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR20LA309](https://openairdocs.org/ntsb/WPR20LA309.md): Bird CK · Enterprise, OR · Accident · No injuries · Class 4 · Limited · Final report · Sep 11, 2020 · N933V · Substantial damage
  > The pilot’s failure to maintain directional control during landing, which resulted in a runway excursion and collision with terrain.
- [NTSB CEN20CA391](https://openairdocs.org/ntsb/CEN20CA391.md): Champion 8GCBC · Ozark, AR · Accident · Minor injuries · Class 4 · Data collection · Final report · Sep 11, 2020 · N81BH · Substantial damage
  > The pilot's failure to maintain clearance from a wire during final approach to landing.
- [NTSB ERA20LA308](https://openairdocs.org/ntsb/ERA20LA308.md): American AA 1 · Newnan, GA · Accident · No injuries · Class 3 · Limited · Final report · Sep 5, 2020 · N6107L · Substantial damage
  > The flight instructor’s inadequate preflight fuel planning, which resulted in an interruption of the fuel supply to the engine and a subsequent a total loss of engine power due.
- [NTSB CEN20LA375](https://openairdocs.org/ntsb/CEN20LA375.md): Titan Mustang T-51 · Brighton, CO · Accident · 1 fatal · Class 3 · Limited · Final report · Sep 2, 2020 · N153JW · Substantial damage
  > The pilot’s loss of airplane control while maneuvering in the traffic pattern.
- [NTSB ANC20LA086](https://openairdocs.org/ntsb/ANC20LA086.md): Piper PA 14 · Wasilla, AK · Accident · Serious injuries · Class 4 · Limited · Final report · Aug 31, 2020 · N4214H · Substantial damage
  > The pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions, which resulted in impact with trees.
- [NTSB CEN20LA367](https://openairdocs.org/ntsb/CEN20LA367.md): Cirrus SR22 · Lawrenceville, IL · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 29, 2020 · N607SR · Destroyed
  > The pilot’s controlled flight into terrain as a result of his failure to properly execute an instrument approach and maintain clearance from trees in night instrument meteorological conditions. Contributing to the accident was the pilot’s unfamiliarity with a…
- [NTSB WPR20LA291](https://openairdocs.org/ntsb/WPR20LA291.md): Cessna TU206 · Tusayan, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 28, 2020 · N3422L · Substantial damage
  > A total loss of engine power due to fuel starvation as a result of contamination in the airplane’s fuel system.
- [NTSB ANC20LA085](https://openairdocs.org/ntsb/ANC20LA085.md): Cessna A185 · Fairbanks, AK · Accident · 2 fatal · Class 3 · Limited · Final report · Aug 27, 2020 · N714KH · 2 aircraft · Destroyed
  > The PA-18 pilot’s failure to see and avoid the Cessna 185 as it was landing. Contributing to the accident was the PA-18 pilot’s failure to hear the traffic advisory provided by the air traffic control tower.
- [NTSB CEN20LA365](https://openairdocs.org/ntsb/CEN20LA365.md): Cessna T210 · Peyton, CO · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 26, 2020 · N64EM · Destroyed
  > The pilot’s failure to maintain adequate airspeed and the exceedance of the airplane’s critical angle of attack during the airplane’s turn to final, resulting in an aerodynamic stall.
- [NTSB WPR20LA283](https://openairdocs.org/ntsb/WPR20LA283.md): Kaman K 1200 · Pine Grove, OR · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 25, 2020 · N314 · Substantial damage
  > An in-flight breakup resulting from contact of the left rotor system with the right rotor system after an in-flight failure of a servo flap from a left rotor blade.
- [NTSB CEN20LA353](https://openairdocs.org/ntsb/CEN20LA353.md): Air Tractor AT602 · Inverness, MS · Accident · No injuries · Class 3 · Limited · Final report · Aug 20, 2020 · N604MG · Substantial damage
  > The pilot’s decision to move the power control lever into beta during flight, which resulted in the power control lever and associated linkage becoming stuck in the beta position.
- [NTSB WPR20CA276](https://openairdocs.org/ntsb/WPR20CA276.md): Mooney M20C · Hillsboro, OR · Accident · No injuries · Class 4 · Data collection · Final report · Aug 19, 2020 · N2933L · Substantial damage
  > The pilot’s failure to maintain altitude on short final due to an encounter with a down draft and the flight instructor's delayed remedial action.
- [NTSB DCA20LA138](https://openairdocs.org/ntsb/DCA20LA138.md): Boeing 767 · Los Angeles, CA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 19, 2020 · N146FE · Substantial damage
  > The left main landing gear’s failure to extend due to the separation of the brake rod retaining hardware from the aft inboard wheel for reasons that could not be determined based on the available evidence.
- [NTSB ERA20LA287](https://openairdocs.org/ntsb/ERA20LA287.md): Piper PA34 · Groton, CT · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 18, 2020 · N41382 · Substantial damage
  > The reported partial loss of right engine power for reasons that could not be determined based on available evidence.
- [NTSB WPR20CA261](https://openairdocs.org/ntsb/WPR20CA261.md): Aviat A1 · Kernville, CA · Accident · Serious injuries · Class 4 · Data collection · Final report · Aug 8, 2020 · N327MN · Substantial damage
  > The pilot's failure to maintain clearance from trees during a go-around, which resulted in an impact with terrain.
- [NTSB ERA20LA278](https://openairdocs.org/ntsb/ERA20LA278.md): Cessna P210 · Allendale, SC · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 7, 2020 · N6300W · Destroyed
  > A total loss of engine power as a result of fuel starvation due to contamination from a thermoplastic polymer used in the fuel system. Contributing to the accident was the pilot’s failure to report debris observed in the fuel system during previous preflight…
- [NTSB ERA20LA273](https://openairdocs.org/ntsb/ERA20LA273.md): Eurocopter EC130 · Knoxville, TN · Accident · 1 fatal · Class 3 · Limited · Final report · Aug 3, 2020 · N55GJ · Substantial damage
  > The pilot's entry into vortex ring state and his inability to arrest the helicopter's descent while maneuvering for landing.
- [NTSB WPR20LA256](https://openairdocs.org/ntsb/WPR20LA256.md): Cessna 172 · San Jose, CA · Accident · No injuries · Class 3 · Limited · Final report · Aug 2, 2020 · N55231 · Substantial damage
  > The airplane’s collision with a bird while maneuvering in the airport traffic pattern.
- [NTSB GAA20WA130](https://openairdocs.org/ntsb/GAA20WA130.md): Cessna 208 · Holbox, Mexico · Accident · No injuries · Foreign investigation · Jul 25, 2020 · XA-FTG · Substantial damage
  > The government of Mexico has notified the NTSB of an accident involving a CESSNA 208 airplane that occurred on July 25, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of…
- [NTSB WPR20WA242](https://openairdocs.org/ntsb/WPR20WA242.md): MD Helicopter 600 · Windhoek, Namibia · Accident · Serious injuries · Class 5 · Foreign · Jul 16, 2020 · V5-HVD · Destroyed
- [NTSB CEN20LA276](https://openairdocs.org/ntsb/CEN20LA276.md): Rockwell S2R R1340 · Keokuk, IA · Accident · No injuries · Class 3 · Limited · Final report · Jul 12, 2020 · N3104S · Substantial damage
  > The improper installation of a fuel vent line during maintenance, which resulted in fuel starvation and a total loss of engine power.
- [NTSB CEN20LA261](https://openairdocs.org/ntsb/CEN20LA261.md): Enstrom 280 · Des Moines, IA · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 4, 2020 · N282SH · Destroyed
  > The partial loss of rotor and engine speed during approach for landing, which resulted in an autorotation and impact with terrain. The reason for the partial loss of rotor and engine speed could not be determined based on the available evidence. Contributing…
- [NTSB GAA20WA119](https://openairdocs.org/ntsb/GAA20WA119.md): Pilatus PC12 · Nice, France · Accident · No injuries · Foreign investigation · Jun 30, 2020 · LX-JFD · Substantial damage
  > The government of France has notified the NTSB of an accident involving a PILATUS PC12 airplane that occurred on June 30, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under the provisions of…
- [NTSB ERA20CA231](https://openairdocs.org/ntsb/ERA20CA231.md): Air Tractor AT502 · South Bay, FL · Accident · No injuries · Class 4 · Data collection · Final report · Jun 29, 2020 · N42190 · Substantial damage
  > The pilot's loss of airplane control during the approach, which resulted in an aerodynamic stall and impact with vegetation and terrain.
- [NTSB CEN20LA248](https://openairdocs.org/ntsb/CEN20LA248.md): Piper PA32R · Zavalla, TX · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 27, 2020 · N315AM · Destroyed
  > The non-certificated pilot’s poor decision-making as he attempted to land at an unlit airstrip in night instrument conditions, which resulted in the airplane’s collision with terrain short of the runway.
- [NTSB WPR20LA196](https://openairdocs.org/ntsb/WPR20LA196.md): Kostrazewa Andre Sonex Light Sport · Centerville, UT · Accident · 2 fatal · Class 3 · Limited · Final report · Jun 25, 2020 · N620AK · Destroyed
  > The pilot flying’s exceedance of the airplane’s critical angle of attack during an attempted forced landing, which resulted in an aerodynamic stall and impact with terrain. The reason for the attempted forced landing could not be determined.
- [NTSB WPR20CA192](https://openairdocs.org/ntsb/WPR20CA192.md): North Wing Uum Scout X-C · Rochester, WA · Accident · Serious injuries · Class 4 · Data collection · Final report · Jun 23, 2020 · N417HW · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while on final approach in turbulent conditions, which resulted in an aerodynamic stall and subsequent hard landing.
- [NTSB WPR20LA189](https://openairdocs.org/ntsb/WPR20LA189.md): Aerospatiale SA342J · Minden, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 21, 2020 · N342J · Destroyed
  > The total loss of engine power due to a surge; the reason for the surge could not be determined based on available information. Contributing to the helicopter damage was the total loss of power while the pilot was transitioning through an altitude and…
- [NTSB CEN20LA239](https://openairdocs.org/ntsb/CEN20LA239.md): Cessna 150 · Millersport, OH · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 20, 2020 · N51033 · Destroyed
  > The loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR20LA177](https://openairdocs.org/ntsb/WPR20LA177.md): Zenair CH601 · Maricopa, AZ · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 10, 2020 · N6402X · Destroyed
  > The pilot’s loss of situational awareness and descent below pattern altitude during the landing approach, which resulted in collision with terrain at night.
- [NTSB WPR20LA176](https://openairdocs.org/ntsb/WPR20LA176.md): Vans RV4 · Safford, AZ · Accident · 1 fatal · Class 3 · Limited · Final report · Jun 9, 2020 · N173CW · Substantial damage
  > A loss of pitch control during the landing approach due to a jammed elevator control system.
- [NTSB DCA20WA117](https://openairdocs.org/ntsb/DCA20WA117.md): Boeing 787 · Dubai, United Arab Emirates · Incident · No injuries · Foreign investigation · Jun 8, 2020 · A6-BMD · No damage
  > The GCAA of United Arab Emirates has notified the NTSB of an incident involving a Boeing 787 airplane that occurred on June 08, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA of United Arab Emirates's investigation under the…
- [NTSB ERA20CA209](https://openairdocs.org/ntsb/ERA20CA209.md): Piper PA38 · Cumberland, MD · Accident · No injuries · Class 4 · Data collection · Final report · Jun 7, 2020 · N2470D · Substantial damage
  > The pilot's failure to maintain directional control during landing and the subsequent go-around in gusting crosswind conditions.

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

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

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