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

## Cases, newest first

- [NTSB ERA13LA276](https://openairdocs.org/ntsb/ERA13LA276.md): Cessna 170 · Plainville, CT · Accident · No injuries · Limited investigation · Final report · Jun 9, 2013 · N2585V · Substantial damage
  > The pilot’s overflight of the landing runway during a forced landing after a loss of engine power. Contributing to the accident was the pilot’s inadequate preflight which resulted in his failure to detect water contamination of the fuel system.
- [NTSB ERA13CA284](https://openairdocs.org/ntsb/ERA13CA284.md): Piper PA-28-140 · Ozark, AL · Accident · No injuries · Data collection · Final report · Jun 8, 2013 · N6881W · Substantial damage
  > The student pilot’s failure to maintain control of the airplane during the aborted landing.
- [NTSB ERA13FA273](https://openairdocs.org/ntsb/ERA13FA273.md): Bell Helicopter Textron 206L-1 · Manchester, KY · Accident · 3 fatal · Field investigation · Final report · Jun 7, 2013 · N114AE · Destroyed
  > The pilot’s loss of helicopter control due to spatial disorientation when he inadvertently encountered night, instrument meteorological conditions, which resulted in the in-flight separation of the main rotor and tailboom.
- [NTSB CEN13WA404](https://openairdocs.org/ntsb/CEN13WA404.md): Cirrus Design SR22 GTS G3 · Gloucestershire, United Kingdom · Accident · Minor injuries · Foreign investigation · Jun 6, 2013 · N936CT · Substantial damage
- [NTSB CEN13CA316](https://openairdocs.org/ntsb/CEN13CA316.md): Sheldrick John H RV-6 · Brookfield, WI · Accident · No injuries · Data collection · Final report · Jun 4, 2013 · N77GT · Substantial damage
  > The pilot's failure to maintain runway alignment and his failure to recognize that the airplane had drifted away from the runway prior to landing.
- [NTSB CEN13CA315](https://openairdocs.org/ntsb/CEN13CA315.md): Cub Crafters CCK · Cookson, OK · Accident · No injuries · Data collection · Final report · Jun 3, 2013 · N319MA · Substantial damage
  > A total loss of engine power due to water contamination in the fuel. Contributing to the accident was the pilot's failure to check the fuel during the preflight, and failure to check the fuel storage tank’s fuel filter/water separator.
- [NTSB WPR13CA257](https://openairdocs.org/ntsb/WPR13CA257.md): Cessna 182P · Bridgeport, CA · Accident · Serious injuries · Data collection · Final report · Jun 2, 2013 · N21231 · Substantial damage
  > The pilot's distracted attention while on final approach which resulted in his failure to maintain adequate airspeed and subsequent loss of aircraft control.
- [NTSB WPR13CA261](https://openairdocs.org/ntsb/WPR13CA261.md): Beech A23-24 · La Grande, OR · Accident · No injuries · Data collection · Final report · Jun 1, 2013 · N650VX · Substantial damage
  > The pilot’s failure to maintain airplane control and the flight instructors failure to monitor the pilot during a simulated emergency landing.
- [NTSB DCA13WA103](https://openairdocs.org/ntsb/DCA13WA103.md): Boeing 737-800 · Eindhoven, Netherlands · Incident · No injuries · Foreign investigation · May 31, 2013 · EI-ENL · No damage
  > The Dutch Safety Board (DSB), has notified the NTSB of an incident involving a Boeing 737-800 that occurred on May 31, 2013. The NTSB has appointed a U.S. Accredited Representative to assist the DSB investigation under the provisions of ICAO Annex 13 as the…
- [NTSB ERA13CA255](https://openairdocs.org/ntsb/ERA13CA255.md): Flightstar Sportplanes Flightstar II · York, SC · Accident · Minor injuries · Data collection · Final report · May 25, 2013 · N677NC · Substantial damage
  > The pilot’s failure to maintain aircraft control while landing in gusty wind conditions.
- [NTSB CEN13LA293](https://openairdocs.org/ntsb/CEN13LA293.md): Air Tractor AT-602 · Longview, TX · Accident · No injuries · Limited investigation · Final report · May 23, 2013 · N583LA · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate preflight planning, which precluded him from locating his intended destination and led to fuel…
- [NTSB CEN13LA291](https://openairdocs.org/ntsb/CEN13LA291.md): Diamond Aircraft Ind DA 20-C1 · Englewood, CO · Accident · Minor injuries · Limited investigation · Final report · May 22, 2013 · N571MA · Substantial damage
  > The in-flight separation of the engine throttle lever and throttle cable due to maintenance personnel not applying sufficient torque to the self-locking nut or improperly reusing a degraded self-locking nut.
- [NTSB WPR13FA236](https://openairdocs.org/ntsb/WPR13FA236.md): Cessna 170B · Auburn, CA · Accident · 2 fatal · Field investigation · Final report · May 19, 2013 · N2865C · Substantial damage
  > The pilot's failure to maintain airplane control during approach to landing, which resulted in an inadvertent stall and subsequent spin.
- [NTSB ENG13IA027](https://openairdocs.org/ntsb/ENG13IA027.md): Boeing 747 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · May 19, 2013 · B18701 · Minor damage
  > Failure of the right inboard foreflap outboard fitting due to fatigue and bearing anomalies on the sequence carriages which resulted in the partial separation of the right inboard foreflap. Contributing to the incident was the failure of maintenance personnel…
- [NTSB WPR13LA247](https://openairdocs.org/ntsb/WPR13LA247.md): Cessna 210-5A · Wenatchee, WA · Accident · No injuries · Limited investigation · Final report · May 18, 2013 · N4848U · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper landing flare, which resulted in the airplane’s tail striking the runway.
- [NTSB CEN13LA286](https://openairdocs.org/ntsb/CEN13LA286.md): Cessna 182C · Fremont, MI · Accident · No injuries · Limited investigation · Final report · May 18, 2013 · N9075T · Substantial damage
  > The pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion while in the traffic pattern.
- [NTSB WPR13CA235](https://openairdocs.org/ntsb/WPR13CA235.md): Swanson Tiger Moth 80 · Lynden, WA · Accident · Minor injuries · Data collection · Final report · May 17, 2013 · N928VS · Substantial damage
  > The pilot's failure to maintain clearance from trees during final approach and his obscured vision due to the sun glare.
- [NTSB WPR13CA246](https://openairdocs.org/ntsb/WPR13CA246.md): Cessna U206G · Friday Harbor, WA · Accident · No injuries · Data collection · Final report · May 14, 2013 · N707WJ · Substantial damage
  > A collision with a bird while on the downwind leg of the traffic pattern.
- [NTSB ERA13CA245](https://openairdocs.org/ntsb/ERA13CA245.md): Schweizer SGS 1-23H-15 · Yadkinville, NC · Accident · Minor injuries · Data collection · Final report · May 14, 2013 · N9860E · Substantial damage
  > The pilot's improper altitude management while maneuvering for an off-airport landing, which resulted in a collision with trees.
- [NTSB ERA13CA235](https://openairdocs.org/ntsb/ERA13CA235.md): Piper PA-28-140 · Jacksonville, NC · Accident · No injuries · Data collection · Final report · May 9, 2013 · N4518F · Substantial damage
  > The student pilot's failure to maintain adequate airspeed during the go-around attempt, which resulted in an aerodynamic stall and collision with the ground.
- [NTSB ERA13CA234](https://openairdocs.org/ntsb/ERA13CA234.md): Piper J3C-65 · Selma, NC · Accident · Minor injuries · Data collection · Final report · May 9, 2013 · N21609 · Substantial damage
  > The instructor pilot’s inadequate visual lookout, which resulted in a collision with power lines and then the ground.
- [NTSB CEN13FA269](https://openairdocs.org/ntsb/CEN13FA269.md): Cessna 182T · Fredericksburg, TX · Accident · 2 fatal · Field investigation · Final report · May 9, 2013 · N6197H · Destroyed
  > The pilot’s failure to maintain airspeed while transitioning from instrument to visual flight while still in instrument conditions, which resulted in an inadvertent stall.
- [NTSB CEN13CA272](https://openairdocs.org/ntsb/CEN13CA272.md): Cessna 172M · Thief River Falls, MN · Accident · No injuries · Data collection · Final report · May 9, 2013 · N1820V · Substantial damage
  > The pilot’s failure to maintain clearance from the power line while on approach to landing.
- [NTSB WPR13CA219](https://openairdocs.org/ntsb/WPR13CA219.md): Piper PA-28 · Cottonwood, AZ · Accident · Serious injuries · Data collection · Final report · May 7, 2013 · N47717 · Substantial damage
  > The student pilot's decision to attempt a night landing on an unlit runway, which resulted in a misaligned approach and subsequent collision with a fence. Contributing to the accident was the student pilot's improper set-up of the airplane radios, which…
- [NTSB ERA13FA227](https://openairdocs.org/ntsb/ERA13FA227.md): Newgent, Barry S6S · Suffolk, VA · Accident · 2 fatal · Field investigation · Final report · May 4, 2013 · N388KB · Destroyed
  > The pilot's failure to maintain airspeed while turning from the downwind to the base leg of the traffic pattern, which resulted in a subsequent aerodynamic stall, spin, and impact with terrain. Contributing to the accident were the pilot's lack of currency…
- [NTSB ANC13CA042](https://openairdocs.org/ntsb/ANC13CA042.md): Cessna 207A · Newtok, AK · Accident · Minor injuries · Data collection · Final report · May 4, 2013 · N9400M · Substantial damage
  > The pilot's continued flight into adverse weather and his failure to maintain clearance from terrain while on approach in flat light conditions. Contributing to the accident was the pilot's delayed decision to initiate a go-around.
- [NTSB CEN13CA268](https://openairdocs.org/ntsb/CEN13CA268.md): Hook Zodiac CH-650 · Gainesville, MO · Accident · Minor injuries · Data collection · Final report · May 2, 2013 · N914AR · Substantial damage
  > The pilot misjudged the landing approach, which resulted in the airplane hitting a tree.
- [NTSB ERA13FA219](https://openairdocs.org/ntsb/ERA13FA219.md): Daniels Dominator · Valkaria, FL · Accident · 1 fatal · Field investigation · Final report · Apr 29, 2013 · N85KY · Substantial damage
  > The pilot’s failure to maintain adequate power and airspeed, which resulted in a loss of control, abrupt descent, and impact with terrain. Contributing to the accident was the pilot’s failure to obtain adequate experience in the gyroplane before making the…
- [NTSB ERA13FA215](https://openairdocs.org/ntsb/ERA13FA215.md): Schweizer SGS 2-32 · Shirley, NY · Accident · 1 fatal · Field investigation · Final report · Apr 27, 2013 · N9857E · Substantial damage
  > The pilot’s failure to maintain airspeed during final approach, which resulted in a stall. Contributing to the accident was the pilot’s likely impairment due to an over-the-counter sedating antihistamine.
- [NTSB CEN13LA244](https://openairdocs.org/ntsb/CEN13LA244.md): Dean Leslie N Highlander · Bryan, OH · Accident · 1 fatal · Limited investigation · Final report · Apr 27, 2013 · N58LD · Substantial damage
  > The pilot's failure to maintain sufficient airspeed during a go-around, which resulted in an aerodynamic stall and subsequent impact with terrain.
- [NTSB ERA13WA226](https://openairdocs.org/ntsb/ERA13WA226.md): Cessna 210L · Belem, Brazil · Accident · 2 fatal · Foreign investigation · Apr 26, 2013 · PR-LJI · Substantial damage
  > On April 26, 2013, about 1215 universal coordinated time, a Cessna 210L, Brazilian registration PR-LJI, operated by Brabo Taxi Aereo Ltda., was substantially damaged during a forced landing while on approach to the Brigadeiro Protasio de Oliveira Airport…
- [NTSB CEN13CA262](https://openairdocs.org/ntsb/CEN13CA262.md): Engineering & Research 415-C · Little Falls, MN · Accident · Minor injuries · Data collection · Final report · Apr 26, 2013 · N94305 · Substantial damage
  > The failure of the airplane's throttle cable.
- [NTSB ERA13FA209](https://openairdocs.org/ntsb/ERA13FA209.md): Cessna 210E · Williamsburg, VA · Accident · 2 fatal · Field investigation · Final report · Apr 19, 2013 · N111BK · Substantial damage
  > The pilot’s failure to maintain airplane control during a base-to-final turn with a gusting wind and potential turbulence/wind shear, which resulted in an aerodynamic stall and collision with terrain.
- [NTSB ERA13CA208](https://openairdocs.org/ntsb/ERA13CA208.md): Cessna 140 · Lancaster, SC · Accident · No injuries · Data collection · Final report · Apr 18, 2013 · N76688 · Substantial damage
  > The pilot’s decision to land with a tailwind and his failure to turn off the carburetor heat during a go-around, which resulted in degraded engine performance and the airplane’s subsequent collision with trees at the end of the runway.
- [NTSB ERA13FA201](https://openairdocs.org/ntsb/ERA13FA201.md): Schoonover John D KIT FOX IV 1200 · St. Lucie, FL · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2013 · N117S · Substantial damage
  > The pilot’s failure to maintain adequate airspeed during the turn to final, which resulted in an exceedance of the wing’s critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot’s combined use of two sedating…
- [NTSB WPR13LA190](https://openairdocs.org/ntsb/WPR13LA190.md): Beech 35-B33 · San Manuel, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2013 · N6841Q · Substantial damage
  > A loss of engine power due to fuel starvation during the landing approach. Contributing to the accident was the pilot’s failure to follow the emergency checklist and switch tanks. Contributing to the severity of the pilot's injuries was the lack of a shoulder…
- [NTSB ERA13CA310](https://openairdocs.org/ntsb/ERA13CA310.md): Schleicher Alexander ASH 26 E · Tullahoma, TN · Accident · No injuries · Data collection · Final report · Apr 12, 2013 · N26EL · Substantial damage
  > The pilot's improper use of wing spoilers during approach resulting in an altitude loss and collision with a tree.
- [NTSB WPR13LA184](https://openairdocs.org/ntsb/WPR13LA184.md): Beech A36TC · Big Bear City, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 2013 · N36SG · Substantial damage
  > The improper overhaul of the propeller, which resulted in the installation of an incorrect propeller actuating pin and deformation of the ferrule hole and led to the pin’s fatigue failure. Contributing to the accident was the failure of multiple owners and…
- [NTSB CEN13CA215](https://openairdocs.org/ntsb/CEN13CA215.md): Cessna 310Q · Willoughby, OH · Accident · No injuries · Data collection · Final report · Mar 30, 2013 · N1267G · Substantial damage
  > A bird strike during a practice instrument approach in visual conditions.
- [NTSB CEN13LA212](https://openairdocs.org/ntsb/CEN13LA212.md): Cirrus SR22T · Alexandria, MN · Accident · Minor injuries · Limited investigation · Final report · Mar 29, 2013 · N1967N · Substantial damage
  > The failure of maintenance personnel to install a safety wire during reinstallation of the right flap, which led to the separation of the right flap rod from the right flap actuation fitting during flap extension. Contributing to the accident were inadequate…
- [NTSB WPR13CA170](https://openairdocs.org/ntsb/WPR13CA170.md): Diamond DA 20-C1 · Provo, UT · Accident · No injuries · Data collection · Final report · Mar 28, 2013 · N986CT · Substantial damage
  > The student pilot’s failure to maintain airspeed and airplane control during an attempted go-around.
- [NTSB WPR13WA197](https://openairdocs.org/ntsb/WPR13WA197.md): Cirrus SR22 · Zhuhai Sanzao Airport, China · Accident · No injuries · Foreign investigation · Mar 27, 2013 · B-9592 · Substantial damage
  > On March 27, 2013 about 1445 Beijing time, a Cirrus SR-22, Chinese registration B-9592, experienced a loss of engine power and subsequently ditched near Zhuhai Sanzao Airport, Guangdong Province, China. The airplane was operated as an instructional flight by…
- [NTSB WPR13LA167](https://openairdocs.org/ntsb/WPR13LA167.md): Enstrom F-28F · Twin Falls, ID · Accident · No injuries · Limited investigation · Final report · Mar 27, 2013 · N918DK · Substantial damage
  > A total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13CA207](https://openairdocs.org/ntsb/CEN13CA207.md): Beech A36 · Fort Stockton, TX · Accident · No injuries · Data collection · Final report · Mar 27, 2013 · N888TT · Substantial damage
  > The student pilot inadvertently switching the fuel selector to the OFF position and the flight instructor's failure to monitor the student pilot's actions.
- [NTSB WPR13CA163](https://openairdocs.org/ntsb/WPR13CA163.md): Cessna 172G · Temecula, CA · Accident · Minor injuries · Data collection · Final report · Mar 22, 2013 · N5931R · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR13CA152](https://openairdocs.org/ntsb/WPR13CA152.md): Cessna 172N · Gila Bend, AZ · Accident · Minor injuries · Data collection · Final report · Mar 17, 2013 · N5802J · Substantial damage
  > The student pilot's failure to maintain airplane control during an attempted go-around.
- [NTSB ERA13LA173](https://openairdocs.org/ntsb/ERA13LA173.md): New Piper PA32-301FT · Stafford, VA · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 2013 · N32EV · Substantial damage
  > The pilot's improper placement of the fuel tank selector handle during approach, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA13CA177](https://openairdocs.org/ntsb/ERA13CA177.md): Trick Trikes Eagle · Eustis, FL · Accident · Minor injuries · Data collection · Final report · Mar 17, 2013 · N44565 · Substantial damage
  > The pilot’s failure to maintain control of the weight-shift aircraft during the final approach to land.
- [NTSB ERA13LA171](https://openairdocs.org/ntsb/ERA13LA171.md): Mcnulty John S Aerolite 103 · Immokalee, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 16, 2013 · N2549W · Substantial damage
  > The loss of engine power due to the seizure of the magneto piston.
- [NTSB ERA13LA169](https://openairdocs.org/ntsb/ERA13LA169.md): Cameron Balloons US Z-105 · Homestead, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 16, 2013 · N4019A · Minor damage
  > The pilot’s failure to maintain sufficient altitude to avoid obstructions during the approach to land, which resulted in a collision with power lines.

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

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

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