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

## Cases, newest first

- [NTSB ERA14FA328](https://openairdocs.org/ntsb/ERA14FA328.md): Cessna 150J · Topping, VA · Accident · 2 fatal · Field investigation · Final report · Jul 6, 2014 · N50824 · Substantial damage
  > The pilot's failure to maintain airplane control, which resulted in an aerodynamic stall/spin.
- [NTSB WPR14LA284](https://openairdocs.org/ntsb/WPR14LA284.md): Globe GC 1B · Puyallup, WA · Accident · No injuries · Limited investigation · Final report · Jul 5, 2014 · N3773K · Substantial damage
  > The failure of the exhaust assembly in the No. 3 cylinder for reasons that could not be determined due to the damage incurred to the fractured parts. Also causal to the accident was maintenance personnel’s improper installation of the cylinder.
- [NTSB WPR14CA279](https://openairdocs.org/ntsb/WPR14CA279.md): Wiley Kitfox IV · Sprague, WA · Accident · Serious injuries · Data collection · Final report · Jul 3, 2014 · N5KW · Substantial damage
  > The pilot's failure to maintain adequate clearance from powerlines during the landing approach resulting in a collision.
- [NTSB ERA14LA325](https://openairdocs.org/ntsb/ERA14LA325.md): Piper PA 24-250 · Monroeville, AL · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 2014 · N5923P · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.
- [NTSB CEN14LA345](https://openairdocs.org/ntsb/CEN14LA345.md): Cessna 210L · Las Vegas, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 2014 · N1175Q · Substantial damage
  > The pilot's loss of airplane control during an aborted landing. Contributing to the accident was the pilot's inadequate preflight planning, which resulted in his attempt to land on a runway closed by a notice to airmen and the loss of engine power due to fuel…
- [NTSB CEN14CA365](https://openairdocs.org/ntsb/CEN14CA365.md): Cessna 182A · Geneseo, IL · Accident · Minor injuries · Data collection · Final report · Jul 2, 2014 · N2209G · Substantial damage
  > The pilot's mismanagement of the available fuel supply, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR14CA275](https://openairdocs.org/ntsb/WPR14CA275.md): Hoffman David K Hoffman BMW Airtrike · Payette, ID · Accident · Minor injuries · Data collection · Final report · Jul 1, 2014 · N190DH · Substantial damage
  > The pilot's failure to maintain adequate airspeed during the go-around which resulted in a stall.
- [NTSB CEN14LA354](https://openairdocs.org/ntsb/CEN14LA354.md): Beech A36 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Jul 1, 2014 · N136EL · Substantial damage
  > The failure of the landing gear retract rod.
- [NTSB WPR14LA271](https://openairdocs.org/ntsb/WPR14LA271.md): Cessna 182Q · Big Creek, ID · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2014 · N132K · Substantial damage
  > The pilot’s execution of a traffic pattern that did not put the airplane in position for a normal final approach and the pilot’s decision to continue the landing attempt instead of initiating a go-around, which resulted in the airplane exceeding its critical…
- [NTSB CEN14LA327](https://openairdocs.org/ntsb/CEN14LA327.md): Cessna T207 · Indianapolis, IN · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 2014 · N207AB · Substantial damage
  > A loss of engine power due to fuel starvation, which resulted from the pilot's failure to monitor the fuel level and switch tanks in a timely fashion.
- [NTSB CEN14LA326](https://openairdocs.org/ntsb/CEN14LA326.md): Aerospatiale AS350B · Mayhill, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2014 · N69PJ · Substantial damage
  > The pilot's failure to maintain helicopter control while performing a go-around in strong, gusting wind conditions. Contributing to the accident was the pilot's decision to initiate the flight in strong, gusting wind conditions.
- [NTSB CEN14LA324](https://openairdocs.org/ntsb/CEN14LA324.md): Cessna 414 · Maryland Heights, MO · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 2014 · N1552T · Destroyed
  > The loss of left engine power for reasons that could not be determined due to impact and fire damage.
- [NTSB CEN14CA322](https://openairdocs.org/ntsb/CEN14CA322.md): Cessna 172S · Knox, IN · Accident · No injuries · Data collection · Final report · Jun 25, 2014 · N1307C · Substantial damage
  > The student pilot's use of excessive back pressure on the flight controls during an attempted go around that induced a stall and loss of control.
- [NTSB WPR14LA263](https://openairdocs.org/ntsb/WPR14LA263.md): Knell ASC Spirit · Lehi, UT · Accident · 1 fatal · Limited investigation · Final report · Jun 22, 2014 · N127JK · Substantial damage
  > The pilot’s exceedance of the glider’s critical angle of attack while maneuvering in a steep turn at low altitude, which resulted in an aerodynamic stall.
- [NTSB CEN14CA323](https://openairdocs.org/ntsb/CEN14CA323.md): Cessna E162 · Wichita, KS · Accident · No injuries · Data collection · Final report · Jun 20, 2014 · N511ML · Substantial damage
  > The student pilot's failure to maintain adequate airspeed during the landing approach which resulted in an inadvertent stall and impact with the runway.
- [NTSB CEN14CA303](https://openairdocs.org/ntsb/CEN14CA303.md): Piper PA 28-180 · Port Isabel, TX · Accident · Minor injuries · Data collection · Final report · Jun 18, 2014 · N66AS · Substantial damage
  > A loss of engine power due to the pilot's improper inflight planning and reliance of fuel gauge readings, which resulted in fuel exhaustion.
- [NTSB CEN14CA295](https://openairdocs.org/ntsb/CEN14CA295.md): Cessna 414 · Pleasanton, TX · Accident · Minor injuries · Data collection · Final report · Jun 16, 2014 · N1671T · Substantial damage
  > The pilot's failure to maintain aircraft control during an aborted landing due to an encounter with a tailwind.
- [NTSB WPR14FA243](https://openairdocs.org/ntsb/WPR14FA243.md): Dittenber Thomas J Auriga · Echo Bay, NV · Accident · 2 fatal · Field investigation · Final report · Jun 13, 2014 · N55GM · Destroyed
  > The pilot's failure to maintain airplane control while maneuvering for landing to an unlit runway in dark night conditions.
- [NTSB ERA14IA301](https://openairdocs.org/ntsb/ERA14IA301.md): Cirrus Design SR22 · Burlington, MA · Incident · No injuries · Incident investigation · Final report · Jun 11, 2014 · N813JE · Minor damage
  > A loss of clamping load of the No. 5 cylinder crankcase through bolts due to maintenance personnel’s failure to properly torque the through bolts during recent maintenance, which resulted in displacement of the No. 2 bearing and the subsequent catastrophic…
- [NTSB CEN14FA286](https://openairdocs.org/ntsb/CEN14FA286.md): Bell 206 L4 · South Timbalier Platform · Accident · 2 fatal · Field investigation · Final report · Jun 11, 2014 · N207MY · Destroyed
  > The pilot's loss of helicopter control for reasons that could not be determined based on the available information.
- [NTSB ERA14WA296](https://openairdocs.org/ntsb/ERA14WA296.md): Beech 300 · Pucallpa, Peru · Incident · No injuries · Foreign investigation · Jun 10, 2014 · OB-1181P · Minor damage
  > On June 10, 2014, at 1212 universal coordinated time, a Beech 300, Peruvian registration OB-1881P, operated by Aero Transporte S.A., sustained minor damage when its No. 1 engine experienced vibrations and was subsequently shutdown, while on approach to the…
- [NTSB WPR14LA235](https://openairdocs.org/ntsb/WPR14LA235.md): Cessna 172N · Page, AZ · Accident · No injuries · Limited investigation · Final report · Jun 8, 2014 · N5589E · Substantial damage
  > The pilot’s improper landing flare in gusting wind conditions, his inadequate recovery from the subsequent bounced landing, and his decision to perform a go-around with insufficient airspeed to climb.
- [NTSB WPR14LA222](https://openairdocs.org/ntsb/WPR14LA222.md): Phillips BD 4 · Dayton, NV · Accident · 1 fatal · Limited investigation · Final report · Jun 3, 2014 · N11DV · Destroyed
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack during the turn onto the final base leg in gusting wind conditions, which resulted in a stall/spin at too low an altitude to allow recovery.
- [NTSB CEN14LA273](https://openairdocs.org/ntsb/CEN14LA273.md): Beech H35 · Monroe, LA · Accident · Serious injuries · Limited investigation · Final report · Jun 3, 2014 · N653T · Substantial damage
  > The 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 CEN14LA277](https://openairdocs.org/ntsb/CEN14LA277.md): Cirrus Design SR22 · Durango, CO · Accident · No injuries · Limited investigation · Final report · Jun 1, 2014 · N583KM · Substantial damage
  > The student pilot’s decision to fly solo into an unfamiliar, mountain airport during high-wind conditions. Contributing to the accident was a partial loss of engine power during the attempted go-around, which was caused by an over-rich mixture setting.
- [NTSB ERA14LA269](https://openairdocs.org/ntsb/ERA14LA269.md): Garlick Helicopters OH 58A+ · Whitefield, ME · Accident · Minor injuries · Limited investigation · Final report · May 30, 2014 · N650MH · Substantial damage
  > A total loss of engine power due to fuel starvation. Contributing to the accident was the pilot’s failure to land as soon as possible when the master caution warning light first illuminated as prescribed and his failure to ensure the proper setting of the…
- [NTSB CEN14LA262](https://openairdocs.org/ntsb/CEN14LA262.md): Embraer EMB 135KL · Traverse City, MI · Accident · No injuries · Limited investigation · Final report · May 28, 2014 · N299SK · Substantial damage
  > An in-flight collision with a bird during the descent to land, which resulted in substantial damage to the airplane.
- [NTSB ERA14LA254](https://openairdocs.org/ntsb/ERA14LA254.md): John V Rawson JR Sprint II · Princeton, NJ · Accident · Serious injuries · Limited investigation · Final report · May 21, 2014 · N505CR · Substantial damage
  > The pilot’s failure to maintain airplane control during the approach to land. Contributing to the accident was the pilot’s unfamiliarity with and lack of training in the accident airplane make and model.
- [NTSB ERA14LA242](https://openairdocs.org/ntsb/ERA14LA242.md): Mooney M20K · Georgetown, DE · Accident · Serious injuries · Limited investigation · Final report · May 18, 2014 · N200DP · Substantial damage
  > The pilot’s improper preflight planning and in-flight fuel management, which resulted in fuel starvation and a total loss of engine power. Also causal to the accident was the pilot’s failure to see and avoid the wires on the airport boundary.
- [NTSB WPR14CA190](https://openairdocs.org/ntsb/WPR14CA190.md): Aviat A 1B · Hayden, ID · Accident · No injuries · Data collection · Final report · May 15, 2014 · N176WW · Substantial damage
  > A partial loss of engine power due to encounter with weather conditions conducive to carburetor icing. Contributing the accident was the pilot's inadequate weather planning.
- [NTSB ANC14RA051](https://openairdocs.org/ntsb/ANC14RA051.md): Extra 300 - L · Fukushima City, Japan · Accident · Minor injuries · Foreign investigation · May 12, 2014 · JA111L · Substantial damage
  > On May 12, 2014, at 0115 coordinated universal time, a Japanese registered Extra 300L airplane, JA111L, operated by a private individual, experienced a loss of engine power followed by a forced landing near Fukushima City, Japan. The pilot and one passenger…
- [NTSB ERA14FA232](https://openairdocs.org/ntsb/ERA14FA232.md): Navion G · Hamilton Township, NJ · Accident · 1 fatal · Field investigation · Final report · May 10, 2014 · N2473T · Substantial damage
  > The pilot's mismanagement of the onboard fuel supply, which resulted in fuel starvation to the engine and a subsequent loss of engine power. Contributing to the death of the right front passenger was the inadequate occupant restraint.
- [NTSB CEN14LA234](https://openairdocs.org/ntsb/CEN14LA234.md): Mooney M20TN · San Antonio, TX · Accident · Serious injuries · Limited investigation · Final report · May 10, 2014 · N563JK · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination and testing of the engine revealed no anomalies.
- [NTSB ERA14FA231](https://openairdocs.org/ntsb/ERA14FA231.md): Eagle C-7 · Ruther Glen, VA · Accident · 3 fatal · Field investigation · Final report · May 9, 2014 · N3016Z · Destroyed
  > The pilot’s inadequate approach and his failure to maintain clearance from power lines, which resulted in a subsequent fire.
- [NTSB CEN14LA233](https://openairdocs.org/ntsb/CEN14LA233.md): Piper PA 32-300 · Lancaster, OH · Accident · No injuries · Limited investigation · Final report · May 7, 2014 · N5222S · Substantial damage
  > Fuel starvation due to the deterioration of the fuel selector valve, which allowed fuel to be fed from only the right tip tank. Contributing to the accident was the inadequate annual inspection, which failed to detect the deteriorated valve.
- [NTSB ERA14LA218](https://openairdocs.org/ntsb/ERA14LA218.md): Beech V35B · Middlesboro, KY · Accident · Serious injuries · Limited investigation · Final report · May 2, 2014 · N702JS · Substantial damage
  > The pilot's failure to maintain airplane control during the landing approach due to his diverted attention to the partially opened main cabin door and the unsecured dog. Contributing to the accident was the pilot's failure to securely latch the main cabin…
- [NTSB ERA14CA210](https://openairdocs.org/ntsb/ERA14CA210.md): Jerome A Baak CH 601XL · Sumter, SC · Accident · Minor injuries · Data collection · Final report · Apr 27, 2014 · N121JN · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the fuel exhaustion was the pilot's failure during the building process to properly determine the unusable quantity of fuel.
- [NTSB CEN14FA219](https://openairdocs.org/ntsb/CEN14FA219.md): Bellanca 17 30A · Sweetwater, TX · Accident · 1 fatal · Field investigation · Final report · Apr 27, 2014 · N9759E · Substantial damage
  > The pilot’s inadequate inflight fuel management, which led to a loss of engine power due to fuel exhaustion or starvation.
- [NTSB ERA14CA206](https://openairdocs.org/ntsb/ERA14CA206.md): Cessna 172I · Huntsville, AL · Accident · No injuries · Data collection · Final report · Apr 22, 2014 · N35553 · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB WPR14LA169](https://openairdocs.org/ntsb/WPR14LA169.md): Piper PA30 - NO Series · Bullhead City, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 2014 · N7880Y · Substantial damage
  > The pilot's mismanagement of the throttle and propeller controls during the attempted go-around after encountering turbulence, which resulted in his failure to maintain adequate airspeed and climb rate and a subsequent forced landing and impact with terrain.…
- [NTSB ERA14CA205](https://openairdocs.org/ntsb/ERA14CA205.md): Cirrus Design SR20 · Sanford, FL · Accident · Minor injuries · Data collection · Final report · Apr 21, 2014 · N497DA · Substantial damage
  > The student pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was his failure to compensate for torque, P-factor, and the reported crosswind conditions.
- [NTSB CEN14CA209](https://openairdocs.org/ntsb/CEN14CA209.md): Piper PA 28-181 · Put in Bay, OH · Accident · No injuries · Data collection · Final report · Apr 21, 2014 · N405S · Substantial damage
  > An inflight collision with a goose while on an approach.
- [NTSB CEN14RA212](https://openairdocs.org/ntsb/CEN14RA212.md): British Aerospace HS 125 700A · Saltillo, Mexico · Accident · 8 fatal · Foreign investigation · Apr 20, 2014 · XA-UKR · Destroyed
  > On April 19, 2014, about 1945 hours central daylight time, a British Aerospace HS 125 700A, XA-UKR, impacted an industrial complex and terrain while on final approach to Plan de Guadalupe International Airport (SLW), near Saltillo, Mexico. A postimpact ground…
- [NTSB CEN14CA203](https://openairdocs.org/ntsb/CEN14CA203.md): Piper PA-28 · Kalamazoo, MI · Accident · Minor injuries · Data collection · Final report · Apr 19, 2014 · N38240 · Substantial damage
  > An inadvertent stall during gusting crosswind conditions.
- [NTSB CEN14LA200](https://openairdocs.org/ntsb/CEN14LA200.md): Cessna O 1E · Fredericksburg, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 16, 2014 · N50WP · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.
- [NTSB WPR14FA167](https://openairdocs.org/ntsb/WPR14FA167.md): Sands Helicycle · Reno, NV · Accident · 1 fatal · Field investigation · Final report · Apr 13, 2014 · N78CS · Substantial damage
  > The pilot’s failure to maintain control of the helicopter while in the traffic pattern.
- [NTSB ERA14LA199](https://openairdocs.org/ntsb/ERA14LA199.md): Aircraft Industries A.S. L33 Solo · Bunn, NC · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2014 · N318BA · Substantial damage
  > The pilot’s failure to maintain airspeed while approaching the airport, which resulted in a stall/mush.
- [NTSB CEN14FA185](https://openairdocs.org/ntsb/CEN14FA185.md): Bellanca 17-30A · Albany, OH · Accident · 1 fatal · Field investigation · Final report · Apr 5, 2014 · N8259R · Substantial damage
  > The pilot’s loss of airplane control during the approach to landing.
- [NTSB CEN14CA189](https://openairdocs.org/ntsb/CEN14CA189.md): Belisle Thomas J RV7A · New Iberia, LA · Accident · Minor injuries · Data collection · Final report · Apr 5, 2014 · N119TB · Substantial damage
  > The pilot's loss of control due to a temporary incapacitation.
- [NTSB CEN14WA247](https://openairdocs.org/ntsb/CEN14WA247.md): Piper PA28 - 181 · Norrtälje/Mellingeholm, Sweden · Incident · No injuries · Foreign investigation · Apr 3, 2014 · SE-KSG · Minor damage

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

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

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