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

## Cases, newest first

- [NTSB NYC92LA013](https://openairdocs.org/ntsb/NYC92LA013.md): I.C.A. Brasov Lark I-28-B2 · Blairstown, NJ · Accident · No injuries · Limited investigation · Final report · Oct 18, 1991 · N350BB · Substantial damage
  > An improperly planned approach which resulted in an inadvertent stall with insufficient altitude for recovery. A factor related to the accident was improper use of the flight controls by the pilot.
- [NTSB LAX92LA019](https://openairdocs.org/ntsb/LAX92LA019.md): Cessna 120 · Olancha, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 18, 1991 · N120MK · Destroyed
  > Failure of the pilot to maintain adequate airspeed resulting in an inadvertent stall while on final approach. Factors were the high density altitude and the pilot's poor approach planning.
- [NTSB FTW92IA010](https://openairdocs.org/ntsb/FTW92IA010.md): Boeing 747-300 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Oct 17, 1991 · PHBUU · Minor damage
  > The pilot's failure to attain proper runway alignment prior to touchdown and his failure to initiate a go around to remedy the situation. A factor was the low altitude at which he initiated the side step maneuver for which he was cleared.
- [NTSB ATL92LA010](https://openairdocs.org/ntsb/ATL92LA010.md): Beech A36 · Selma, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 17, 1991 · N3735Y · Substantial damage
  > The fatigue failure of the engine crankshaft counterweight blade, which resulted from excessive wear of the counterweight pin bushings, due to corrosion from an unknown source.
- [NTSB ANC92LA008](https://openairdocs.org/ntsb/ANC92LA008.md): Cessna A185E · Dog Salmon Riv, AK · Accident · No injuries · Limited investigation · Final report · Oct 17, 1991 · N2756J · Substantial damage
  > The pilot's failure to maintain airspeed. Contributing to the accident was the downdraft.
- [NTSB CHI92LA012](https://openairdocs.org/ntsb/CHI92LA012.md): Rockwell 112YC · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Oct 16, 1991 · N4603W · Substantial damage
  > The pilot's failure to perform a major repair and continued operation of the airplane with known deficiencies.
- [NTSB SEA92LA012](https://openairdocs.org/ntsb/SEA92LA012.md): Piper PA28-161 · Duchesne, UT · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1991 · N8379V · Substantial damage
  > Fuel exhaustion due to the pilot's inattention and becoming lost. A factor to the accident was the night conditions.
- [NTSB NYC92DNC01](https://openairdocs.org/ntsb/NYC92DNC01.md): Denney Aircraft Behn KIT FOX III · Hartford, VT · Accident · No injuries · Final report · Oct 13, 1991 · N898KG · Substantial damage
  > An inadvertent stall/spin. Factors related to the accident were an improperly planned approach by the pilot, the failure of the pilot to attain and maintain flying speed, rising terrain, and turbulent air conditions.
- [NTSB NYC92DHJ01](https://openairdocs.org/ntsb/NYC92DHJ01.md): Challenger II Bombadier · Moriches, NY · Accident · 1 fatal · Final report · Oct 13, 1991 · N8182K · Destroyed
  > A loss of control in flight due to a flight control malfunction for undetermined reasons.
- [NTSB LAX92LA013](https://openairdocs.org/ntsb/LAX92LA013.md): Stinson 108-8 · Susanville, CA · Accident · No injuries · Limited investigation · Final report · Oct 12, 1991 · N87607 · Substantial damage
  > An inadvertent stall due to the failure of the pilot to maintain a correct airspeed during the approach.
- [NTSB LAX92LA012](https://openairdocs.org/ntsb/LAX92LA012.md): Beech K35 · Grass Valley, CA · Accident · No injuries · Limited investigation · Final report · Oct 11, 1991 · N9559R · Substantial damage
  > The inadvertent encounter with a microburst/downburst phenomena associated with thunderstorm activity. A factor in the accident was the failure of the pilot to adequately assess the weather conditions during the landing attempt.
- [NTSB MIA92LA009](https://openairdocs.org/ntsb/MIA92LA009.md): Lake LA-4 · Panama City, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1991 · N25PA · Substantial damage
  > Loss of power due to undetermined reasons. Contributing to the accident was the cfi's inadequate emergency procedures following the reported loss of power.
- [NTSB CHI92LA005](https://openairdocs.org/ntsb/CHI92LA005.md): Cessna 150E · Cassville, MO · Accident · Serious injuries · Limited investigation · Final report · Oct 10, 1991 · N2563J · Substantial damage
  > The pilot-in-command's improper preflight planning and preparation. Factors contributing to this accident were fuel exhaustion, a hidden obstruction within the terrain the pilot landed on and a collapsed nosegear.
- [NTSB NYC92LA003](https://openairdocs.org/ntsb/NYC92LA003.md): Cessna 172 · Lincoln, ME · Accident · No injuries · Limited investigation · Final report · Oct 9, 1991 · N76101 · Substantial damage
  > The pilot's failure to see and avoid the transmission lines. A factor was the sunglare.
- [NTSB FTW92LA006](https://openairdocs.org/ntsb/FTW92LA006.md): Cessna 152 · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Oct 9, 1991 · N5399B · Substantial damage
  > Fuel exhaustion as a result of the pilot's failure to refuel the airplane prior to the flight. A factor was the fbo's failure to properly maintain the fuel quantity gauges.
- [NTSB ATL92LA003](https://openairdocs.org/ntsb/ATL92LA003.md): Cessna 320 · Gadsden, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1991 · N4726X · Substantial damage
  > Fuel starvation due to incorrect fuel line installations, an inoperative fuel boost pump, and incorrect pilot procedure. A factor in this accident was the pilot's intentional operation with a known fuel system deficiency.
- [NTSB FTW92LA004](https://openairdocs.org/ntsb/FTW92LA004.md): Cessna 210C · Leander, TX · Accident · No injuries · Limited investigation · Final report · Oct 5, 1991 · N3655Y · Substantial damage
  > The pilot's disregard for the hazardous weather advisories received. A factor was the weather.
- [NTSB ATL91LA184](https://openairdocs.org/ntsb/ATL91LA184.md): Fischer Wagabond · Rossville, TN · Accident · 1 fatal · Limited investigation · Final report · Sep 30, 1991 · N42LF · Destroyed
  > The loss of engine power as a result of carburetor icing.
- [NTSB NYC91LA251](https://openairdocs.org/ntsb/NYC91LA251.md): Cessna C-152 II · Blue Bell, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1991 · N48806 · Substantial damage
  > The pilot failed to maintain directional control of the airplane, resulting in the airplane drifting to the left of the runway and impacting with a windsock pole. Contributing factors in the accident were the pilot's inadequate compensation for a crosswind…
- [NTSB BFO91LA086](https://openairdocs.org/ntsb/BFO91LA086.md): Cessna 172 · Grayson, KY · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 1991 · N10PT · Substantial damage
  > The pilot's failure to maintain control of the aircraft during the attempted go-around.
- [NTSB SEA91LA252](https://openairdocs.org/ntsb/SEA91LA252.md): Cessna 152 · Malaga, WA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1991 · N4740H · Substantial damage
  > The instructor pilot's failure to insure adequate terrain clearance during the go-around maneuver. Factors contributing to the accident were 1) rising terrain, 2) high density altitude condition, and 3) the instructor pilot's delay of the go-around.
- [NTSB LAX91LA408](https://openairdocs.org/ntsb/LAX91LA408.md): Burkhart Grob G103 · Fremont, CA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1991 · N4113G · Substantial damage
  > The pilot failed to adequately compensate for the prevailing wind conditions.
- [NTSB CHI91DTK04](https://openairdocs.org/ntsb/CHI91DTK04.md): Boland/Poe Tsunami · Pierre, SD · Accident · 1 fatal · Final report · Sep 25, 1991 · NX39JR · Destroyed
  > A bending overload failure of the wing flap control rods and remedial action by the pilot was not possible. Factors in the accident are the inadequate design of the wing flap system by the pilot/operator manufacturer and his lack of total experience in type…
- [NTSB MIA91LA223](https://openairdocs.org/ntsb/MIA91LA223.md): Centrair 101A · Groveland, FL · Accident · No injuries · Limited investigation · Final report · Sep 21, 1991 · N93KG · Substantial damage
  > The pilot in command's poor in flight decision planning, and inadvertent stall mush while on approach to land. Contributing to the accident was his lack of total experience.
- [NTSB ATL91LA179](https://openairdocs.org/ntsb/ATL91LA179.md): Piper PA-28-140 · Greenville, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1991 · N8728N · Substantial damage
  > The dual student's improper positioning of the fuel tank selector handle, and the cfi's inadequate supervision of her student. A factor in this accident was: the cfi's lack of experience as a flight instructor.
- [NTSB ATL91FA176](https://openairdocs.org/ntsb/ATL91FA176.md): Cessna C-172N · Alabaster, AL · Accident · 2 fatal · Field investigation · Final report · Sep 21, 1991 · N700CH · Substantial damage
  > The pilot's failure to maintain flying speed which resulted in an unintentional stall and collision with the ground. A factor was the pilot's use of unprescribed drugs.
- [NTSB CHI91LA299](https://openairdocs.org/ntsb/CHI91LA299.md): Piper PA-23-250 · Boscobel, WI · Accident · No injuries · Limited investigation · Final report · Sep 20, 1991 · N915PM · Substantial damage
  > Improper remedial action by the pilot-in-command (PIC), and inadequate monitoring by the designated pilot examiner (DPE) during a simulated emergency procedure. Factors related to the accident were: the loss of power in one engine due to an undetermined…
- [NTSB CHI91LA278](https://openairdocs.org/ntsb/CHI91LA278.md): Cessna 310J · Sugar Grove, IL · Accident · No injuries · Limited investigation · Final report · Sep 20, 1991 · N300RA · Substantial damage
  > The buckled nose landing gear retraction/extension gear drive tube. A factor in the accident was the pilot in command not having the landing gear inspected at the interval recommended by the manufacturer.
- [NTSB SEA91LA243](https://openairdocs.org/ntsb/SEA91LA243.md): Donald W. Sorrels Vans RV-6 · Kennewick, WA · Accident · No injuries · Limited investigation · Final report · Sep 18, 1991 · N391DS · Substantial damage
  > The loss of power due to the pilot/builder's improper adjustment of the engine idle speed. A factor relating to the accident was the soft terrain at the accident site.
- [NTSB CHI91LA304](https://openairdocs.org/ntsb/CHI91LA304.md): Piper PA-28R-200 · Atchison, KS · Accident · No injuries · Limited investigation · Final report · Sep 17, 1991 · N4795T · Substantial damage
  > Delayed remedial action by the pilot in command. Factors related to the accident are a misjudged approach by the pilot in command, and complacency on the part of the FAA inspector.
- [NTSB SEA91LA239](https://openairdocs.org/ntsb/SEA91LA239.md): Cessna 150M · Hillsboro, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 1991 · N714RK · Substantial damage
  > Inadequate preflight planning, which resulted in an inadequate fuel supply and fuel exhaustion.
- [NTSB NYC91LA236](https://openairdocs.org/ntsb/NYC91LA236.md): Cessna 172M · Norwood, MA · Accident · No injuries · Limited investigation · Final report · Sep 12, 1991 · N71393 · Substantial damage
  > Premature retraction of the wing flaps during a go-around which resulted in an inadvertent stall with insufficient altitude for recovery. Factors related to the accident were: the pilot's lack of total experience in make and model, and lack of recent…
- [NTSB ATL91LA172](https://openairdocs.org/ntsb/ATL91LA172.md): Cessna 401 · Jackson, TN · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 1991 · N13DT · Destroyed
  > The pilot's failure to select the main fuel tanks prior to the approach, resulting in fuel starvation and engine stoppage.
- [NTSB DEN91FA126](https://openairdocs.org/ntsb/DEN91FA126.md): Piper PA-30 · Ft. Carson, CO · Accident · 1 fatal · Field investigation · Final report · Sep 11, 1991 · N7730Y · Destroyed
  > The loss of power to both engines due first to fuel starvation followed by fuel exhaustion, the pilot's failure to refuel, and the inadvertent stall. A factor was: the pilot's improper use of powerplant controls.
- [NTSB LAX91LA390](https://openairdocs.org/ntsb/LAX91LA390.md): Bell 47G-3B-2 · Chula Vista, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 1991 · N2618D · Substantial damage
  > The pilot's failure to maintain the proper airspeed and misjudging the landing flare altitude. The powerplant failure for an undetermined reason and the unsuitable terrain for the float equipped helicopter were factors in the accident.
- [NTSB DEN91LA125](https://openairdocs.org/ntsb/DEN91LA125.md): Piper PA-24-180 · Broomfield, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 1991 · N16WW · Substantial damage
  > The pilot's failure to refuel and his misjudged fuel consumption calculations which resulted in fuel exhaustion power loss.
- [NTSB MIA91LA216](https://openairdocs.org/ntsb/MIA91LA216.md): Cessna 182 · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Sep 7, 1991 · N5648B · Substantial damage
  > The pilot in command's improper preflight planning and his failure to ensure that the aircraft contained sufficient fuel for the flight.
- [NTSB ANC91LA144](https://openairdocs.org/ntsb/ANC91LA144.md): Piper PA-18 · Noatak, AK · Accident · No injuries · Limited investigation · Final report · Sep 7, 1991 · N2KA · Substantial damage
  > Was the pilot's failure to maintain a proper descent rate. Contributing to the accident was the gust of tailwind.
- [NTSB ATL91LA167](https://openairdocs.org/ntsb/ATL91LA167.md): Taylorcraft DCO-65 · Calhoun, GA · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1991 · N43LT · Substantial damage
  > The pilot's failure to maintain directional control during the go-around attempt. Factor(s) in this accident were: the excessive airspeed at touchdown, and the pilot's lack of experience in this model of airplane.
- [NTSB NYC91LA226](https://openairdocs.org/ntsb/NYC91LA226.md): Mooney M20J · Nantucket, MA · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1991 · N296TH · Destroyed
  > The pilot's descent below the ILS glide path and his delay in initiating a missed approach which resulted in collision with the terrain.
- [NTSB LAX91LA378](https://openairdocs.org/ntsb/LAX91LA378.md): Schempp-Hirth VENTUS-B · Mojave, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1991 · N901DH · Destroyed
  > The glider pilot's inadequate altitude to clear terrain. Factors which related to the pilot being low could not be established because the pilot had no memory of the accident, and no witnesses were identified who observed the glider other than during its…
- [NTSB ATL91LA164](https://openairdocs.org/ntsb/ATL91LA164.md): Piper PA-23-160 · Stockbridge, GA · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1991 · N44PG · Substantial damage
  > The pilot's failure to maintain flying speed after experiencing a partial loss of engine power. Factors in this accident were, loose carburetors, annual inspection not performed, and pilot's lack of recent experience.
- [NTSB ANC91LA140](https://openairdocs.org/ntsb/ANC91LA140.md): Piper PA-18-150 · Gold King, AK · Accident · No injuries · Limited investigation · Final report · Aug 31, 1991 · N2664A · Substantial damage
  > The pilot's failure to maintain a proper descent rate. Contributing to the accident was the rising terrain and the tailwind condition.
- [NTSB CHI91DEV03](https://openairdocs.org/ntsb/CHI91DEV03.md): Hocker Dragonfly · Metropolis, IL · Accident · 1 fatal · Final report · Aug 30, 1991 · N28P · Destroyed
  > Pilot's failure to maintain airspeed above stall.
- [NTSB DEN91LA121](https://openairdocs.org/ntsb/DEN91LA121.md): Cessna R182 · Parker, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1991 · N2628C · Substantial damage
  > Partial failure of the aircraft powerplant for undetermined reasons. A related factor was: the soft terrain.
- [NTSB FTW91FA155](https://openairdocs.org/ntsb/FTW91FA155.md): Bell 412 · Garden Banks · Accident · 1 fatal · Field investigation · Final report · Aug 26, 1991 · N3909F · Substantial damage
  > Overheating and subsequent failure of the number one tail rotor hanger bearing for an undeterined reason, and failure of the tail rotor drive shaft.
- [NTSB CHI91LA269](https://openairdocs.org/ntsb/CHI91LA269.md): Cessna 172E · Harbor Springs, MI · Accident · No injuries · Limited investigation · Final report · Aug 22, 1991 · N3891S · Substantial damage
  > The pilot's failure to adequately compensate for wind conditions. A factor associated with the accident was his delay in initiating the go-around.
- [NTSB MIA91IA201](https://openairdocs.org/ntsb/MIA91IA201.md): Piper PA-28-140 · Clearwater, FL · Incident · No injuries · Incident investigation · Final report · Aug 21, 1991 · N9558W · Minor damage
  > Total loss of engine power due to fuel starvation caused by improper fuel tank selector position by the pilot-in-command. Contributing to the incident was the pilot's total lack of experience.
- [NTSB SEA91LA209](https://openairdocs.org/ntsb/SEA91LA209.md): Cessna 172M · Oak Harbor, WA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1991 · CGFTE · Substantial damage
  > The pilot's allowing the airspeed to decay below the stall speed. Factors contributing to the accident were the pilot's failure to maintain directional control and the pilot's lack of total recent experience.
- [NTSB NYC91LA213](https://openairdocs.org/ntsb/NYC91LA213.md): Cessna 150C · Kemblesville, PA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1991 · N16AC · Substantial damage
  > The instructor pilots' inadequate supervision, the student pilots' overshoot of the simulated landing area, and the power loss for undetermined reasons.

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

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

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