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

## Cases, newest first

- [NTSB CHI07FA084](https://openairdocs.org/ntsb/CHI07FA084.md): Beech 58 · Munster, IN · Accident · 2 fatal · Field investigation · Final report · Mar 10, 2007 · N332HA · Substantial damage
  > The fuel starvation for an undetermined reason which led to the loss of power on the left engine. Additional causes were the pilot's failure to maintain airspeed which led to his loss of control of the airplane. Factors in the accident were the flight…
- [NTSB ANC07CA023](https://openairdocs.org/ntsb/ANC07CA023.md): Cessna 172 · Chugiak, AK · Accident · No injuries · Data collection · Final report · Mar 10, 2007 · N73813 · Substantial damage
  > The instructor pilot's inadequate supervision of the student while landing, which resulted in an undershoot, and subsequent in-flight collision with snow-covered terrain.
- [NTSB DFW07LA082](https://openairdocs.org/ntsb/DFW07LA082.md): Cessna T210R · Boerne, TX · Accident · No injuries · Limited investigation · Final report · Mar 8, 2007 · N766DP · 2 aircraft · Minor damage
  > The pilot of the other airplane's failure to maintain proper spacing during approach to landing and subsequent go-around, which resulted in a midair collision.
- [NTSB ATL07CA048](https://openairdocs.org/ntsb/ATL07CA048.md): Mooney M20J · Toccoa, GA · Accident · No injuries · Data collection · Final report · Mar 7, 2007 · N4WY · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around resulting in an inadvertenent stall and collision with the ground.
- [NTSB LAX07LA102](https://openairdocs.org/ntsb/LAX07LA102.md): Cessna 182Q · Banning, CA · Accident · No injuries · Limited investigation · Final report · Mar 3, 2007 · N735SD · Substantial damage
  > Loss of engine power while on final approach for undetermined reasons. Contributing to the accident was the unfavorable wind condition.
- [NTSB DFW07LA080](https://openairdocs.org/ntsb/DFW07LA080.md): Beech P35 · Ponca City, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2007 · N1554Z · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA07CA067](https://openairdocs.org/ntsb/SEA07CA067.md): Cessna 182H · Jean, NV · Accident · Minor injuries · Data collection · Final report · Feb 26, 2007 · N1864X · Substantial damage
  > The pilot's failure to adequately compensate for the wind conditions during final approach, which resulted in a loss of control and an in-flight collision with terrain. A contributing factor was the windshear condition encountered.
- [NTSB MIA07LA053](https://openairdocs.org/ntsb/MIA07LA053.md): Piper PA-28-181 · Venice, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 25, 2007 · N2213Z · Substantial damage
  > The failure of the student pilot to maintain airspeed during a go-around.
- [NTSB SEA07LA063](https://openairdocs.org/ntsb/SEA07LA063.md): Cessna 180 · Bellingham, WA · Accident · No injuries · Limited investigation · Final report · Feb 24, 2007 · N9115C · Substantial damage
  > The loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for a forced landing, and the trees.
- [NTSB DFW07CA079](https://openairdocs.org/ntsb/DFW07CA079.md): Buckeye Breeze XL · Buffalo City, AR · Accident · Serious injuries · Data collection · Final report · Feb 21, 2007 · N582W · Destroyed
  > The pilot's failure to maintain control of the aircraft during approach. A contributing factor was the reported encounter with severe turbulence.
- [NTSB MIA07CA051](https://openairdocs.org/ntsb/MIA07CA051.md): Van's RV7A · Green Cove, FL · Accident · Minor injuries · Data collection · Final report · Feb 20, 2007 · N938JF · Substantial damage
  > The pilot's failure to maintain sufficient airspeed to avoid a stall during the final approach to land, resulting in an in-flight loss of control, a hard landing, and a nose over. Factors associated with the accident are an inadvertent stall, and the pilot's…
- [NTSB DFW07FA071](https://openairdocs.org/ntsb/DFW07FA071.md): Stevens KB-2 · Oklahoma City, OK · Accident · 1 fatal · Field investigation · Final report · Feb 18, 2007 · N6KT · Substantial damage
  > The pilot's failure to maintain control of the gyroplane while in the traffic pattern. Contributing to the accident was the high wind with terrain induced turbulence and the absence of the gyroplane's horizontal stabilizer.
- [NTSB NYC07CA067](https://openairdocs.org/ntsb/NYC07CA067.md): Piper PA-28-181 · Millbrook, NY · Accident · No injuries · Data collection · Final report · Feb 17, 2007 · N47480 · Substantial damage
  > The pilot's failure to maintain a proper glidepath to the runway.
- [NTSB CHI07FA073](https://openairdocs.org/ntsb/CHI07FA073.md): Cessna 340A · Council Bluffs, IA · Accident · 4 fatal · Field investigation · Final report · Feb 17, 2007 · N111SC · Destroyed
  > The pilot's continued flight into adverse weather, and his failure to maintain altitude during the instrument approach. Contributing factors were the presence of severe icing, moderate turbulence, and low-level wind shear.
- [NTSB DFW07CA070](https://openairdocs.org/ntsb/DFW07CA070.md): Cessna 172B · Stephenville, TX · Accident · Minor injuries · Data collection · Final report · Feb 15, 2007 · N2629U · Substantial damage
  > The loss of engine power during the landing approach due to the pilot's failure to follow the appropriate procedures to preclude carburetor ice in known carburetor icing conditions.
- [NTSB CHI07FA069](https://openairdocs.org/ntsb/CHI07FA069.md): Eurocopter France EC120B · Gulf of Mexico · Accident · 2 fatal · Field investigation · Final report · Feb 12, 2007 · N690WR · Substantial damage
  > The pilot's inadequate compensation for the gusty wind conditions which resulted in his failure to maintain clearance with the structure extending from the offshore oil platform. Contributing to the accident was the gusty wind condition.
- [NTSB DFW07CA068](https://openairdocs.org/ntsb/DFW07CA068.md): Fortuna Sonex · Atlanta, TX · Accident · No injuries · Data collection · Final report · Feb 10, 2007 · N229P · Substantial damage
  > The pilot's failure to maintain an adequate airspeed that resulted in a stall/mush. A contributing factor was the group of trees located near the departure end of the runway.
- [NTSB DFW07FA067](https://openairdocs.org/ntsb/DFW07FA067.md): Cessna 414 · Rocksprings, TX · Accident · 2 fatal · Field investigation · Final report · Feb 9, 2007 · N69845 · Destroyed
  > The pilot's failure to maintain clearance with terrain. Contributing factors were the below approach/landing minimums weather and the drizzle/mist weather conditions.
- [NTSB DEN07FA059](https://openairdocs.org/ntsb/DEN07FA059.md): Beech H-18 · Great Bend, KS · Accident · 1 fatal · Field investigation · Final report · Feb 9, 2007 · N45GM · Destroyed
  > The pilot's failure to maintain aircraft control during the missed approach which resulted in an inadvertent stall and impact with terrain. A contributing factor was the icing conditions.
- [NTSB CHI07FA068](https://openairdocs.org/ntsb/CHI07FA068.md): Cessna 208B · Alliance, NE · Accident · Serious injuries · Field investigation · Final report · Feb 8, 2007 · N1116Y · Substantial damage
  > The pilot's descent below minimum descent altitude while on a nonprecision approach. A contributing factor was a low ceiling.
- [NTSB DFW07CA064](https://openairdocs.org/ntsb/DFW07CA064.md): Beech F35 · McKinney, TX · Accident · No injuries · Data collection · Final report · Feb 4, 2007 · N6XH · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC07FA065](https://openairdocs.org/ntsb/NYC07FA065.md): Socata TBM 700 · Dartmouth, MA · Accident · 3 fatal · Field investigation · Final report · Feb 3, 2007 · N944CA · Destroyed
  > Both pilots' failure to maintain aircraft control during a missed approach.
- [NTSB MIA07CA046](https://openairdocs.org/ntsb/MIA07CA046.md): C.W Crane T2 · Bunnell, FL · Accident · Minor injuries · Data collection · Final report · Feb 2, 2007 · N69TT · Destroyed
  > The pilot's inadvertent encounter with adverse weather that resulted in a descent and an impact with terrain.
- [NTSB CHI07LA064](https://openairdocs.org/ntsb/CHI07LA064.md): Cessna 414A · Dickinson, ND · Accident · No injuries · Limited investigation · Final report · Feb 1, 2007 · N6631C · Substantial damage
  > The undetermined failure of the emergency landing gear system and the retraction of the right main landing gear during landing.
- [NTSB SEA07LA056](https://openairdocs.org/ntsb/SEA07LA056.md): Martin/Harris Harmon Rocket · Troutdale, OR · Accident · Minor injuries · Limited investigation · Final report · Jan 31, 2007 · N141RH · Substantial damage
  > A total loss of power for undetermined reasons just as the aircraft was maneuvering to enter the downwind for landing. The absence of a suitable landing location was a factor in the accident.
- [NTSB NYC07LA061](https://openairdocs.org/ntsb/NYC07LA061.md): Cessna 310Q · Atlantic City, NJ · Accident · No injuries · Limited investigation · Final report · Jan 31, 2007 · N20SS · Substantial damage
  > The inoperative safe gear indicator light switch. Contributing to the accident was the pilot hand-cranking the landing gear past the physical stop.
- [NTSB DFW07CA060](https://openairdocs.org/ntsb/DFW07CA060.md): Tanker DR-107 One Design · Rockwall, TX · Accident · No injuries · Data collection · Final report · Jan 26, 2007 · N385DT · Substantial damage
  > A loss of engine power for an undetermined reason during a go-around, which resulted in a forced landing. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX07CA074](https://openairdocs.org/ntsb/LAX07CA074.md): Quad City Ultralight Challenger Special · Orland, CA · Accident · No injuries · Data collection · Final report · Jan 20, 2007 · UNREG · Substantial damage
  > The pilots improper in-flight decision to continue the flight rather than refuel resulting in fuel exhustion and the loss of engine power.
- [NTSB NYC07FA056](https://openairdocs.org/ntsb/NYC07FA056.md): Beech A36 · Wayne, NJ · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2007 · N711SK · Destroyed
  > The pilot's failure to comply with the published instrument approach procedure, which resulted in controlled flight into terrain.
- [NTSB SEA07LA048](https://openairdocs.org/ntsb/SEA07LA048.md): Navion G Model · El Centro, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 15, 2007 · N3BP · Substantial damage
  > The loss of engine power for undetermined reasons. Contributing factors were the lack of suitable terrain for the forced landing and the glare from the sun.
- [NTSB ENG07IA009](https://openairdocs.org/ntsb/ENG07IA009.md): Mitsubishi MU-2B-36 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jan 12, 2007 · N950MA · Minor damage
  > Complete loss of No. 2 engine power due to a partial rim failure of the 2nd stage turbine wheel, resulting in No. 2 engine shutdown and turbine debris exiting the side of the engine. The wheel failure mechanism could not be determined due to missing turbine…
- [NTSB DEN07LA049](https://openairdocs.org/ntsb/DEN07LA049.md): Beech A36 · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Jan 12, 2007 · N8183E · Substantial damage
  > The pilot-rated dual student's failure to maintain sufficient airspeed during the landing approach to avoid a stall. Also causal was the flight instructor's failure to provide adequate supervision. Factors associated with the accident are an inadvertent…
- [NTSB CHI07CA057](https://openairdocs.org/ntsb/CHI07CA057.md): Barron Thorp T18 · Edinburg, OH · Accident · Serious injuries · Data collection · Final report · Jan 9, 2007 · N54DT · Destroyed
  > The pilot's improper in-flight decision not to refuel prior to fuel exhaustion. A factor to the accident was the tree line that the airplane impacted during the forced landing.
- [NTSB ATL07FA031](https://openairdocs.org/ntsb/ATL07FA031.md): Cessna 182P · Columbia, SC · Accident · 3 fatal · Field investigation · Final report · Jan 5, 2007 · N55YS · Destroyed
  > The pilot's failure to follow approach procedures by descending below the prescribed descision height altitude resulting in an in-flight collision with trees and the ground. This report was modified on January 25, 2008.
- [NTSB DFW07FA051](https://openairdocs.org/ntsb/DFW07FA051.md): Cessna 182R · Batesville, AR · Accident · 2 fatal · Field investigation · Final report · Jan 4, 2007 · N2658 · Destroyed
  > The pilot's failure to maintain clearance from trees. A contributing factor to the accident was the prevailing low ceilings.
- [NTSB NYC07FA052](https://openairdocs.org/ntsb/NYC07FA052.md): Cessna TR182 · Charlotte, NC · Accident · 4 fatal · Field investigation · Final report · Dec 31, 2006 · N7090S · Destroyed
  > The pilot's spatial disorientation, which resulted in a loss of aircraft control and subsequent in-flight breakup. Contributing to the accident was instrument meteorological conditions.
- [NTSB CHI07LA051](https://openairdocs.org/ntsb/CHI07LA051.md): Piper PA-32-300 · Romeo, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 31, 2006 · N888PR · Substantial damage
  > The pilot's failure to maintain aircraft control and proper rate of descent during the VOR approach. Factors associated with the accident were the low cloud conditions and moderate to heavy rain.
- [NTSB CHI07LA050](https://openairdocs.org/ntsb/CHI07LA050.md): Beech B-99 · Rapid City, SD · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 2006 · N99TH · Substantial damage
  > The pilot's failure to follow the published instrument approach procedure which contributed to his failure to maintain altitude and clearance from terrain during the instrument approach. A factor was the night light condition.
- [NTSB LAX07CA066](https://openairdocs.org/ntsb/LAX07CA066.md): Burkhart Grob G-103A · Minden, NV · Accident · Minor injuries · Data collection · Final report · Dec 27, 2006 · N794G · Substantial damage
  > The flight's encounter with a low ceiling while on approach that necessatiated an off-airport precautionary landing on unsuitable terrain. Obstructions were a factor.
- [NTSB ATL07FA030](https://openairdocs.org/ntsb/ATL07FA030.md): Cessna 414A · Lawrenceville, GA · Accident · 3 fatal · Field investigation · Final report · Dec 26, 2006 · N62950 · Substantial damage
  > The pilot's failure to follow the instrument approach procedure. Contributing to the accident was the pilot's descent below the prescribed decision height altitude.
- [NTSB ANC07LA009](https://openairdocs.org/ntsb/ANC07LA009.md): Gates Learjet 35A · Nashville, TN · Accident · No injuries · Limited investigation · Final report · Dec 26, 2006 · N136WE · Substantial damage
  > The pilot's inadequate compensation for gusty crosswind conditions during landing, which resulted in a loss of control and collision with the runway. Factors contributing to the accident were the failure of the aileron augmentation (spoiler) flight control…
- [NTSB CHI07FA045](https://openairdocs.org/ntsb/CHI07FA045.md): Beech A36 · Chattanooga, TN · Accident · 4 fatal · Field investigation · Final report · Dec 23, 2006 · N3704B · Destroyed
  > The pilot's reported spatial disorientation which lead to not maintaining altitude/clearance from terrain and not obtaining/maintaining a proper climb rate during the missed approach. Factors were the night, the clouds encountered on approach, and trees.
- [NTSB ATL07FA029](https://openairdocs.org/ntsb/ATL07FA029.md): Cessna 340A · Charleston, SC · Accident · 4 fatal · Field investigation · Final report · Dec 22, 2006 · N808RA · Substantial damage
  > The pilot's failure to maintain airspeed during a turn from base to final, resulting in an inadvertent stall/spin. Contributing to the accident was the impairment of the pilot due to the combination of drugs found in his toxicological report.
- [NTSB LAX07FA059](https://openairdocs.org/ntsb/LAX07FA059.md): Piper PA-46-350P · Concord, CA · Accident · 4 fatal · Field investigation · Final report · Dec 21, 2006 · N1AM · Destroyed
  > Failure of the pilot to follow the prescribed instrument approach procedures and to maintain an adequate airspeed while maneuvering in the airport environment that led to a stall.
- [NTSB DFW07FA042](https://openairdocs.org/ntsb/DFW07FA042.md): Cessna T210N · Austin, TX · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2006 · N5434C · Destroyed
  > The pilot's failure to maintain control of the airplane while executing an instrument approach for undetermined reasons.
- [NTSB DFW07FA041](https://openairdocs.org/ntsb/DFW07FA041.md): Beech A36 · Fayetteville, AR · Accident · 1 fatal · Field investigation · Final report · Dec 19, 2006 · N1100J · Destroyed
  > The pilot's failure to maintain clearance from obstacles. Contributing factors were the below approach/landing weather minimums, and the prevailing dark night conditions.
- [NTSB CHI07LA043](https://openairdocs.org/ntsb/CHI07LA043.md): Cessna 560 · North Canton, OH · Accident · No injuries · Limited investigation · Final report · Dec 18, 2006 · N49NS · Substantial damage
  > The rupture of the hydraulic pressure hose assembly, which was caused by internal wear between the hose's fire sleeve and stainless steel braid, and the failure of the emergency landing gear assembly to deploy the right main landing gear during approach.…
- [NTSB DFW07CA038](https://openairdocs.org/ntsb/DFW07CA038.md): Cessna 421 · Brackettville, TX · Accident · No injuries · Data collection · Final report · Dec 16, 2006 · N642CB · Destroyed
  > The pilot's failure to maintain proper runway alignment on final approach and his delayed decision to execute a go-around. Factors were the dark night conditions and the inoperative runway edge lights.
- [NTSB NYC07CA049](https://openairdocs.org/ntsb/NYC07CA049.md): Cessna 172C · Middletown, NY · Accident · Minor injuries · Data collection · Final report · Dec 14, 2006 · N8260X · Substantial damage
  > The pilot misjudging distance/altitude during the turn from base to final, which resulted in an undershoot and subsequent collision with trees. A factor was the haze.
- [NTSB CHI07CA040](https://openairdocs.org/ntsb/CHI07CA040.md): Schleicher AS-K13 · Gregory, MI · Accident · No injuries · Data collection · Final report · Dec 14, 2006 · N545TT · Substantial damage
  > The pilot's unexpected encounter with wind shear and his inability to remain clear of the trees while on final approach to land.

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

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

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