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

## Cases, newest first

- [NTSB SEA07FA031](https://openairdocs.org/ntsb/SEA07FA031.md): Piper PA-28-140 · Bandon, OR · Accident · 1 fatal · Field investigation · Final report · Dec 12, 2006 · N5618U · Substantial damage
  > The loss of aircraft control in the traffic pattern for undetermined reasons.
- [NTSB DFW07FA036](https://openairdocs.org/ntsb/DFW07FA036.md): Cessna 310Q · Waco, TX · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2006 · N69677 · Destroyed
  > The pilot's failure to maintain sufficient airspeed to avoid a stall during the instrument landing approach, which resulted in an inadvertent stall and collision with terrain. Also causal was the pilot's impairment due to prohibited drugs. Factors associated…
- [NTSB NYC07FA043](https://openairdocs.org/ntsb/NYC07FA043.md): Piper PA-32R-300 · Charlottesville, VA · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2006 · N8349C · Destroyed
  > A loss of engine power for undetermined reasons.
- [NTSB NYC07FA042](https://openairdocs.org/ntsb/NYC07FA042.md): Cessna 210K · Edgewater, MD · Accident · 2 fatal · Field investigation · Final report · Dec 9, 2006 · N9449M · Substantial damage
  > The pilot's failure to maintain the proper altitude/clearance will on approach, which resulted in an in-flight collision with trees. Contributing to the accident was the night-light conditions, an obstruction light that was not illuminated, and trees that had…
- [NTSB DEN07CA035](https://openairdocs.org/ntsb/DEN07CA035.md): Piper PA-28-180 · Falcon, CO · Accident · Minor injuries · Data collection · Final report · Dec 8, 2006 · N6487J · Substantial damage
  > loss of power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing, unsuitable terrain available on which to make a forced landing and the tree.
- [NTSB NYC07FA038](https://openairdocs.org/ntsb/NYC07FA038.md): Smith, Ted Aerostar 601P · West Dover, VT · Accident · 1 fatal · Field investigation · Final report · Dec 2, 2006 · N9797Q · Destroyed
  > A loss of control during approach for undetermined reasons, which resulted in a collision with trees.
- [NTSB DFW07LA032](https://openairdocs.org/ntsb/DFW07LA032.md): Noble Vans RV-7A · Norman, OK · Accident · 2 fatal · Limited investigation · Final report · Dec 2, 2006 · N216RV · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall. A contributing factor was the pilot's attempt at formation flying.
- [NTSB NYC07FA037](https://openairdocs.org/ntsb/NYC07FA037.md): Cirrus SR22 · Huntersville, NC · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2006 · N665CD · Destroyed
  > The pilot's failure to maintain aircraft control. Contributing to the accident was the night instrument meteorological conditions.
- [NTSB LAX07FA049](https://openairdocs.org/ntsb/LAX07FA049.md): Beech B36TC · Buena Park, CA · Accident · Serious injuries · Field investigation · Final report · Nov 27, 2006 · N3144D · Substantial damage
  > a fuel starvation induced loss of engine power due to pilot's inadequate fuel system management.
- [NTSB LAX07LA048](https://openairdocs.org/ntsb/LAX07LA048.md): Cessna 414A · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 2006 · N414AY · Substantial damage
  > A loss of power in the right engine due to fuel starvation. The fuel starvation was the result of the pilot's improper fuel selector position setting.
- [NTSB NYC07LA036](https://openairdocs.org/ntsb/NYC07LA036.md): Cessna T210N · Caldwell, NJ · Accident · No injuries · Limited investigation · Final report · Nov 21, 2006 · N210MP · Substantial damage
  > The private pilot's failure to maintain adequate altitude/clearance, and the flight instructor's failure to take remedial action. Contributing to the accident was the night light conditions.
- [NTSB NYC07CA034](https://openairdocs.org/ntsb/NYC07CA034.md): Taylorcraft BC12-D · Benton, KY · Accident · Serious injuries · Data collection · Final report · Nov 21, 2006 · N148HW · Substantial damage
  > The pilot's improper decision to fly between the trees during his approach to the runway.
- [NTSB MIA07CA020](https://openairdocs.org/ntsb/MIA07CA020.md): Liberty Aerospace XL-2 · Melbourne, FL · Accident · No injuries · Data collection · Final report · Nov 21, 2006 · N508XL · Substantial damage
  > The pilot's (Dual Student) failure to relinquish control of the airplane when instructed by the certified flight instructor resulting in airspeed not being maintained and an inadvertent stall.
- [NTSB ATL07CA023](https://openairdocs.org/ntsb/ATL07CA023.md): Hudspeth Shawn D Challenger II · Bessemer, AL · Accident · No injuries · Data collection · Final report · Nov 21, 2006 · N44594 · Substantial damage
  > The pilot's failure to maintain control of the airplane during an approach for landing. A factor in the accident was gusting winds.
- [NTSB MIA07CA018](https://openairdocs.org/ntsb/MIA07CA018.md): Sargent Jonathan Varieze · Punta Gorda, FL · Accident · Serious injuries · Data collection · Final report · Nov 18, 2006 · N75EZ · Substantial damage
  > The pilot's failure to maintain control of the airplane. A factor in the accident was the pilot's inadequate preflight, which did not ensure the security of the canopy before flight.
- [NTSB LAX07LA037](https://openairdocs.org/ntsb/LAX07LA037.md): Beechcraft J35 · Flagstaff, AZ · Accident · 1 fatal · Limited investigation · Final report · Nov 18, 2006 · N8246D · Substantial damage
  > The pilot's inadequate in-flight planning while on approach which lead to a loss of engine power due to fuel starvation.
- [NTSB SEA07IA019](https://openairdocs.org/ntsb/SEA07IA019.md): Cessna 172 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Nov 16, 2006 · N9522S · No damage
  > The instructor pilot's improper in-flight decision not to take evasive action as a heavy aircraft passed by while on an upwind parallel approach path to an adjacent runway, leading to a wake vortices encounter. Factors include a nearly direct crosswind…
- [NTSB SEA07LA017](https://openairdocs.org/ntsb/SEA07LA017.md): Piper PA-28-140 · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Nov 14, 2006 · N2390T · Substantial damage
  > The pilot's inadequate in-flight planning by failing to refuel while en route which resulted in fuel exhaustion and loss of engine power while on approach to the airport. Rough/uneven terrain was a factor.
- [NTSB CHI07CA023](https://openairdocs.org/ntsb/CHI07CA023.md): Mooney M20J · Akron, OH · Accident · Minor injuries · Data collection · Final report · Nov 14, 2006 · N202WB · Substantial damage
  > The pilot's failure to maintain sufficient airspeed during final approach resulting in an inadvertent stall. Contributing factors were the airplane's low altitude at the time of the stall and the asymmetric flap configuration.
- [NTSB MIA07CA015](https://openairdocs.org/ntsb/MIA07CA015.md): Bellanca BL-17-30 · Lantana, FL · Accident · Minor injuries · Data collection · Final report · Nov 13, 2006 · N6663V · Substantial damage
  > The pilot's improper preflight planning/decision which resulted in total loss of engine power due to fuel exhaustion.
- [NTSB MIA07LA014](https://openairdocs.org/ntsb/MIA07LA014.md): Cessna 150J · DeFuniak Springs, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 2006 · N50977 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB DFW07FA023](https://openairdocs.org/ntsb/DFW07FA023.md): McCutchan Glasair · Mineral Wells, TX · Accident · 2 fatal · Field investigation · Final report · Nov 11, 2006 · N606MC · Destroyed
  > The pilot's failure to maintain airspeed during a forced landing, resulting in an inadvertent stall. A factor was the loss of engine power due to fuel exhaustion.
- [NTSB ATL07CA017](https://openairdocs.org/ntsb/ATL07CA017.md): Diamond Aircraft Industries DA 20-C1 · Raleigh, NC · Accident · No injuries · Data collection · Final report · Nov 10, 2006 · N190WA · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around, which resulted in a inadvertent stall.
- [NTSB SEA07FA016](https://openairdocs.org/ntsb/SEA07FA016.md): Beech D35 · Shelton, WA · Accident · 1 fatal · Field investigation · Final report · Nov 9, 2006 · N2843V · Substantial damage
  > The pilot's failure to refuel the airplane, which resulted in fuel exhaustion, and his failure to maintain sufficient airspeed to avoid a stall during the subsequent forced landing. A factor associated with the accident is the inadvertent stall.
- [NTSB DFW07LA022](https://openairdocs.org/ntsb/DFW07LA022.md): Cessna 152 · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Nov 7, 2006 · N94684 · 2 aircraft · Substantial damage
  > The failure of the second pilot to maintain separation from the preceding traffic established on final approach. A contributing factor was the failure by ATC personnel to visually identify and separate airplanes in the traffic pattern.
- [NTSB MIA07FA011](https://openairdocs.org/ntsb/MIA07FA011.md): Beech BE-76 · Port Orange, FL · Accident · 2 fatal · Field investigation · Final report · Nov 1, 2006 · N6017U · Destroyed
  > The flight instructor's inadequate preflight planning which resulted in fuel exhaustion.
- [NTSB NYC07CA016](https://openairdocs.org/ntsb/NYC07CA016.md): Jahns RV-7 · Farmingdale, NJ · Accident · No injuries · Data collection · Final report · Oct 31, 2006 · N916R · Substantial damage
  > A loss of engine power due to a disconnected throttle/power lever linkage. A contributingfactor was the owner/builder's improper installation of the throttle linkage.
- [NTSB NYC07CA014](https://openairdocs.org/ntsb/NYC07CA014.md): Cessna 172N · Morgantown, WV · Accident · No injuries · Data collection · Final report · Oct 29, 2006 · N952AC · Substantial damage
  > The student pilot's failure to maintain directional control and the flight instructor's improper planning and supervision of the student's solo cross country flight. A contributing factor was the wind gusts.
- [NTSB CHI07FA009](https://openairdocs.org/ntsb/CHI07FA009.md): Beech 95-B55 · Lawrenceville, IL · Accident · 1 fatal · Field investigation · Final report · Oct 27, 2006 · N1832N · Substantial damage
  > The improper judgment by the pilot to conduct a flight to, and execute an approach to, an airport with weather conditions that were below the required minimums. Also causal was the pilot's continued descent below the approach minimum descent altitude.…
- [NTSB SEA07CA010](https://openairdocs.org/ntsb/SEA07CA010.md): Alexander Lancair 320 · Scappoose, OR · Accident · No injuries · Data collection · Final report · Oct 22, 2006 · N1382Y · Substantial damage
  > The pilot's failure to maintain aircraft control during a go-around.
- [NTSB NYC07LA011](https://openairdocs.org/ntsb/NYC07LA011.md): Bishop Bakeng Duce · South Boston, VA · Accident · 1 fatal · Limited investigation · Final report · Oct 22, 2006 · N91BK · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall. Contributing was the deteriorating weather and diminishing light conditions, the pilot's decision to take off despite the weather advisory, and the pilot's…
- [NTSB CHI07LA011](https://openairdocs.org/ntsb/CHI07LA011.md): Cessna R182 · Ames, IA · Accident · No injuries · Limited investigation · Final report · Oct 22, 2006 · N5274S · Substantial damage
  > The fatigue failure of the landing gear actuator pin and the exterior visual maintenance inspection for cracks not possible by company maintenance personnel.
- [NTSB MIA07CA007](https://openairdocs.org/ntsb/MIA07CA007.md): Cessna 150L · Umatilla, FL · Accident · Minor injuries · Data collection · Final report · Oct 20, 2006 · N10772 · Substantial damage
  > The flight instructor's delayed remedial action during a go-around, which resulted in a failure to maintain sufficient airspeed to avoid a stall/mush, and an in-flight collision with terrain.
- [NTSB NYC07FA009](https://openairdocs.org/ntsb/NYC07FA009.md): Piper PA-46-310P · Odenton, MD · Accident · 2 fatal · Field investigation · Final report · Oct 19, 2006 · N9130N · Destroyed
  > The pilot's failure to maintain adequate clearance from terrain during the approach. Contributing was the pilot's self-induced pressure to land the airplane after being informed by air traffic control that he was not operating in compliance with the ADIZ…
- [NTSB NYC07CA010](https://openairdocs.org/ntsb/NYC07CA010.md): Cirrus SR-22 · Lumberton, NJ · Accident · No injuries · Data collection · Final report · Oct 19, 2006 · N246MT · Substantial damage
  > The pilot's failure to maintain aircraft control during a go-around, which resulted in an in-flight collision with a tree.
- [NTSB ANC07LA003](https://openairdocs.org/ntsb/ANC07LA003.md): Cessna 207 · Tuntutuliak, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 2006 · N7336U · Substantial damage
  > The pilot's misjudgment of distance/altitude during the landing approach, which resulted in an undershoot and in-flight collision with a river embankment. Factors contributing to the accident were reduced visibility due to rain and mist.
- [NTSB DEN07FA008](https://openairdocs.org/ntsb/DEN07FA008.md): McDonnell Douglas MD-90-30 · Denver, CO · Accident · No injuries · Field investigation · Final report · Oct 12, 2006 · N906DA · Substantial damage
  > A fractured nose gear assembly spray deflector that blocked the nose gear from extending during landing, and resulted in an intentional nose gear up landing.
- [NTSB MIA07CA003](https://openairdocs.org/ntsb/MIA07CA003.md): Olree Robert Spezio Sport DAL-1 · Sarasota, FL · Accident · No injuries · Data collection · Final report · Oct 11, 2006 · N777WH · Substantial damage
  > The pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall / mush and impact with objects (a tree and a fence) before ground impact.
- [NTSB CHI07CA007](https://openairdocs.org/ntsb/CHI07CA007.md): Steinbaum Kitfox IV · Proctorville, OH · Accident · No injuries · Data collection · Final report · Oct 10, 2006 · N5103R · Substantial damage
  > The blocked fuel filter which resulted in the loss of engine power. The residential area where the power loss occurred, the trees, the sloped landing site, and the unsuitable terrain encountered during the forced landing were contributing factors.
- [NTSB SEA07FA006](https://openairdocs.org/ntsb/SEA07FA006.md): Robinson R44 · Sumner, WA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2006 · N769RT · Substantial damage
  > The complete loss of engine power, for undetermined reasons, while on final approach, and the pilot's loss of control of the helicopter after the power loss. Factors include a lake below the final approach to the private landing pad.
- [NTSB DEN07FA002](https://openairdocs.org/ntsb/DEN07FA002.md): Beech 36 · Centennial, CO · Accident · Minor injuries · Field investigation · Final report · Oct 4, 2006 · N7855R · Substantial damage
  > the loss of engine power for undetermined reasons. Contributing factors were the light pole and parked vehicles impacted during the forced landing.
- [NTSB NYC07LA001](https://openairdocs.org/ntsb/NYC07LA001.md): Piper PA-24-250 · Hammonton, NJ · Accident · No injuries · Limited investigation · Final report · Oct 3, 2006 · N5097P · Substantial damage
  > Displacement of the idler gear assembly, which resulted in a loss of camshaft timing, and a subsequent engine failure. Contributing to the accident was the swampy terrain condition.
- [NTSB SEA07LA002](https://openairdocs.org/ntsb/SEA07LA002.md): Cessna 340A · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Oct 2, 2006 · N1920E · Substantial damage
  > The fracture of the adjusting bellcrank in overstress due to binding in a linkage forward of the bell crank.
- [NTSB CHI07LA002](https://openairdocs.org/ntsb/CHI07LA002.md): Piper PA-23-250 · Marshall, MN · Accident · No injuries · Limited investigation · Final report · Oct 2, 2006 · N71TA · Substantial damage
  > The failure of the nose gear to properly extend for undetermined reasons, which resulted in damage to the forward fuselage during landing.
- [NTSB CHI06CA277](https://openairdocs.org/ntsb/CHI06CA277.md): Rockwell 112TC · Bolivar, MO · Accident · No injuries · Data collection · Final report · Sep 30, 2006 · N1154J · Substantial damage
  > The pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the go-around attempt. Contributing factors were the crosswind and the gusts.
- [NTSB LAX06CA299](https://openairdocs.org/ntsb/LAX06CA299.md): Beech 95-55 · Safford, AZ · Accident · Minor injuries · Data collection · Final report · Sep 28, 2006 · N9412Y · Substantial damage
  > The pilot's inadequate in-flight planning/decision and inaccurate fuel consumption calculations, which led to fuel exhaustion and total loss of power to both engines.
- [NTSB SEA06CA190](https://openairdocs.org/ntsb/SEA06CA190.md): Coltrin RV-6 · Burley, ID · Accident · No injuries · Data collection · Final report · Sep 27, 2006 · N566JH · Substantial damage
  > A loss of engine power due to the malfunctioning of the carburetor. A factor was the airplane nosing over due to the rough/uneven terrain.
- [NTSB ANC06CA135](https://openairdocs.org/ntsb/ANC06CA135.md): Cessna 150 · Anchorage, AK · Accident · No injuries · Data collection · Final report · Sep 20, 2006 · N7745E · Destroyed
  > The pilot's misjudged distance/altitude during final approach, which resulted in an undershoot and subsequent in-flight collision with terrain. A factor associated with the accident was a landing gear collapse.
- [NTSB LAX06LA290](https://openairdocs.org/ntsb/LAX06LA290.md): Schweizer 269C-1 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Sep 10, 2006 · N323CP · Substantial damage
  > Inadequate maintenance adjustment and missing mixture spring, which resulted in a loss of engine power during approach.
- [NTSB DEN06CA125](https://openairdocs.org/ntsb/DEN06CA125.md): Thomas Velocity · Conway, SC · Accident · Minor injuries · Data collection · Final report · Sep 9, 2006 · N31756 · Destroyed
  > the loss of engine power due to fuel starvation. The cause of the fuel starvation was not determined. Contributing to the accident was the lack of suitable terrain for a forced landing.

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

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

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