# 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 163 of 420 · 20,996 cases

## Cases, newest first

- [NTSB DEN89FA217](https://openairdocs.org/ntsb/DEN89FA217.md): Piper PA-31T2 · Louisville, CO · Accident · 3 fatal · Field investigation · Final report · Sep 15, 1989 · N63XL · Destroyed
  > Failure of the pilot to maintain adequate airspeed, while maneuvering for spacing in the traffic pattern, which resulted in an inadvertent stall at low altitude.
- [NTSB LAX89LA312](https://openairdocs.org/ntsb/LAX89LA312.md): Cessna 152 · Santa Paula, CA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1989 · N49697 · Substantial damage
  > Improper in-flight planning/decision by the student pilot. Contributing factors were the parked aircraft, hangar, and the student pilot's lack of total experience.
- [NTSB DEN89LA216](https://openairdocs.org/ntsb/DEN89LA216.md): Cessna 172N · Provo, UT · Accident · No injuries · Limited investigation · Final report · Sep 14, 1989 · N75815 · Substantial damage
  > The pilot failed to maintain the proper glidepath during a practice instrument approach resulting in a collision with terrain. Contributing factor(s) was: the dark night light condition.
- [NTSB MIA89IA247](https://openairdocs.org/ntsb/MIA89IA247.md): Beech G18S · Jackson, MS · Incident · No injuries · Incident investigation · Final report · Sep 13, 1989 · N9604R · Minor damage
  > Failure of the pilot to correctly perform the emergency gear extension procedures. Contributing to the accident was the failure of the normal gear extension system.
- [NTSB MKC89FA196](https://openairdocs.org/ntsb/MKC89FA196.md): Piper PA-32-300 · Bentonville, AR · Accident · 2 fatal · Field investigation · Final report · Sep 11, 1989 · N8995N · Destroyed
  > A loose oil line that became disconnected, when maintenance/inspection of the aircraft had not been completed, which resulted in loss of engine oil and subsequent failure of the connecting rod from lack of lubrication. A factor related to the accident was:…
- [NTSB MIA89LA244](https://openairdocs.org/ntsb/MIA89LA244.md): Piper PA-24-180 · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Sep 10, 1989 · N7946P · Substantial damage
  > Failure of the private pilot (dual student) to assure the fuel selector was positioned to the proper tank, which resulted in fuel starvation; and inadequate supervision by the instructor pilot (CFI). The trees were a related factor.
- [NTSB DCA89IA071](https://openairdocs.org/ntsb/DCA89IA071.md): Boeing 737-200A · Kansas City, MO · Incident · No injuries · Class 1 · Incident · Final report · Sep 9, 1989 · N283AU · Minor damage
  > The flightcrew's failure to adequately prepare for and execute a nonprecision approach and their subsequent premature descent below minimum descent altitude. Contributing to the cause of the incident was the inadequate and deficient services provided to the…
- [NTSB SEA89LA166](https://openairdocs.org/ntsb/SEA89LA166.md): Consolidated Aeronautics LAKE-LA-4-200 · Klawock, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 1989 · N2582P · Destroyed
  > The pilot misjudged the aircraft height above water while attempting to land on a lake. A contributing factor was the smooth, glassy water surface conditions on the lake.
- [NTSB DEN89LA224](https://openairdocs.org/ntsb/DEN89LA224.md): Piper PA-31-350 · Monument Valley, UT · Accident · No injuries · Limited investigation · Final report · Sep 8, 1989 · N3554P · Substantial damage
  > The pilot's failure to adequately compensate for windshear.
- [NTSB FTW89LA160](https://openairdocs.org/ntsb/FTW89LA160.md): Cessna 210P · Bethany, OK · Accident · No injuries · Limited investigation · Final report · Sep 7, 1989 · N732XW · Substantial damage
  > A loose fuel line connection, due to inadequate maintenance, which resulted in fuel starvation. Factors related to the accident were: darkness and the obstructions (hay bale & approach light pole) in the emergency landing area.
- [NTSB SEA89LA162](https://openairdocs.org/ntsb/SEA89LA162.md): Cessna TU206G · Moore, ID · Accident · No injuries · Limited investigation · Final report · Sep 4, 1989 · N666HS · Substantial damage
  > Fuel exhaustion due to the pilot's inaccurate fuel consumption calculations. Contributing to the accident was a fence.
- [NTSB NYC89LA208](https://openairdocs.org/ntsb/NYC89LA208.md): Piper PA-32RT-300T · Wolfeboro, NH · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1989 · N21353 · Destroyed
  > Inadequate compensation for wind conditions by the owner/pilot-in-command (PIC), his failue to maintain proper altitude on the approach, and failure of the other pilot (owner's instructor pilot) to take remedial action. Factors related to the accident were:…
- [NTSB LAX89FA294](https://openairdocs.org/ntsb/LAX89FA294.md): Beech V35TC · Fort Jones, CA · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1989 · N6225V · Destroyed
  > The failure of the pilot to maintain sufficient altitude.
- [NTSB CHI89LA178](https://openairdocs.org/ntsb/CHI89LA178.md): Cessna 120 · Brooklyn, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1989 · N2101V · Destroyed
  > Failure of the pilot to see-and-avoid power lines in his flight path during a go-around. The power lines and his lack of familiarity with the airport were contributing factors.
- [NTSB BFO89FA075](https://openairdocs.org/ntsb/BFO89FA075.md): Piper PA-31-350 · Lynchburg, VA · Accident · 5 fatal · Field investigation · Final report · Aug 28, 1989 · N234J · Destroyed
  > Pilot's failure to maintain clearance from obstructions because of improper IFR operation. Contributing to the accident was descent below decision height, delay in initiating the missed approach, and fog conditions.
- [NTSB MIA89LA236](https://openairdocs.org/ntsb/MIA89LA236.md): Cessna 188A · Milton, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1989 · N5699J · Substantial damage
  > Flight in known adverse weather by the pilot. Turbulence from the nearby thunderstorm was a related factor.
- [NTSB FTW89LA154](https://openairdocs.org/ntsb/FTW89LA154.md): Cessna 150M · Hearne, TX · Accident · 1 fatal · Limited investigation · Final report · Aug 27, 1989 · N16090 · Destroyed
  > The failure of the pilot to maintain control of the airplane and his lack of experience/training. A factor was the pilot's poor physical condition.
- [NTSB LAX89LA288](https://openairdocs.org/ntsb/LAX89LA288.md): Ryan ST3KR · Hawthorne, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 26, 1989 · N59466 · Substantial damage
  > Oil starvation of the engine due to the pilot's failure to turn the oil tank supply valve on prior to flight.
- [NTSB ATL89LA202](https://openairdocs.org/ntsb/ATL89LA202.md): Piper PA-38-112 · Gainesville, GA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1989 · N2487N · Substantial damage
  > The pilot's misjudgement of the airplane fuel supply during preflight inspection, and his subsequent failure to monitor in-flight fuel consumption, which led to an engine power loss due to fuel exhaustion. Contributing to the accident were the pilot's…
- [NTSB DEN89LA199](https://openairdocs.org/ntsb/DEN89LA199.md): Cessna T210F · Englewood, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1989 · N6121R · Substantial damage
  > A failure in the hyrdraulic power unit, which prevented operation of either the normal or emergency gear extension systems. The raised runway lip contributed to aircraft damage and pilot injury.
- [NTSB CHI89LA177](https://openairdocs.org/ntsb/CHI89LA177.md): Cessna 177B · Auburn, IN · Accident · No injuries · Limited investigation · Final report · Aug 24, 1989 · N30806 · Substantial damage
  > Failure of the pilot to maintain directional control during the landing, which resulted in a ground swerve. Contributing factors were: the pilot's misjudgement of distance, speed, and altitude on final approach and high vegetation (tall grass & brush) beside…
- [NTSB MKC89LA186](https://openairdocs.org/ntsb/MKC89LA186.md): Cessna 172 · Clear Lake, MN · Accident · No injuries · Limited investigation · Final report · Aug 23, 1989 · N80357 · Substantial damage
  > The pilot's improper decision in attempting to land with inadequate visual cues which precluded identification of a correct runway alignment. A suitable alternative airport was readily available.
- [NTSB MIA89LA229](https://openairdocs.org/ntsb/MIA89LA229.md): Bell 47G · Ponce, PR · Accident · No injuries · Limited investigation · Final report · Aug 23, 1989 · N955B · Substantial damage
  > Failure of the aft tail rotor drive shaft.
- [NTSB LAX89FA275](https://openairdocs.org/ntsb/LAX89FA275.md): Mooney M20F · Livermore, CA · Accident · 4 fatal · Field investigation · Final report · Aug 23, 1989 · CFSAB · Destroyed
  > The pilot's decision to conduct low level night flight under low ceilings. Contributing factors were: the dark night, low ceiling, and high obstructions.
- [NTSB LAX89LA284](https://openairdocs.org/ntsb/LAX89LA284.md): Bellanca 8KCAB · Santa Paula, CA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1989 · N1119E · Substantial damage
  > Failure of the instructor pilot to adequately supervise the conduct of the flight and to take timely and effective corrective action to the student's improper control inputs.
- [NTSB SEA89FA154](https://openairdocs.org/ntsb/SEA89FA154.md): Beech C90 · Gold Beach, OR · Accident · 3 fatal · Field investigation · Final report · Aug 21, 1989 · N25ST · Destroyed
  > The pilot's failure to initiate a go-around after emerging from a fog bank on a short final which resulted in inadequate airspeed and a stall. Contributing to the accident was the pilot's poor judgement in attempting the VFR approach in IMC conditions.
- [NTSB NYC89LA196](https://openairdocs.org/ntsb/NYC89LA196.md): Ryan ST-3KR · Factoryville, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 1989 · N239 · Substantial damage
  > Inadequate preflight by the pilot and his misjudgement of the fuel supply, which resulted in fuel exhaustion. The ditch was a related factor.
- [NTSB NYC89LA197](https://openairdocs.org/ntsb/NYC89LA197.md): Schweizer SGS-2-32 · Plymouth, CT · Accident · No injuries · Limited investigation · Final report · Aug 19, 1989 · N414LF · Substantial damage
  > Improper compensation for wind conditions by the pilot. A factor related to the accidetn was: the downdraft.
- [NTSB MIA89LA223](https://openairdocs.org/ntsb/MIA89LA223.md): Cessna 150 · Fort Pierce, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 1989 · N60847 · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. The terrain (rough/uneven) in the emergency landing area was a related factor.
- [NTSB LAX89DUQ04](https://openairdocs.org/ntsb/LAX89DUQ04.md): Air Tractor AT-300 · New Cuyama, CA · Accident · No injuries · Final report · Aug 15, 1989 · N4324S · Destroyed
  > The pilot's mismanagement of the fuel supply which led to an engine power loss due to fuel exhaustion and subsequent collision with the ground by allowing the aircraft to stall.
- [NTSB NYC89FA190](https://openairdocs.org/ntsb/NYC89FA190.md): Cessna 182Q · Edison Twshp, NJ · Accident · 1 fatal · Field investigation · Final report · Aug 14, 1989 · N759MN · Destroyed
  > Failure of the pilot to follow the IFR procedure and maintain the minimum descent altitude (mda) for that segment of the approach. Factors related to the accident were: minimum safe altitude warning (msaw) radar not enabled, and failure of the approach…
- [NTSB LAX89FA277](https://openairdocs.org/ntsb/LAX89FA277.md): Piper PA-23-250 · Lake Tahoe, CA · Accident · 2 fatal · Field investigation · Final report · Aug 14, 1989 · N4838P · Destroyed
  > Disablement of the stabilator flight control system. A contributing factor was: inadequate maintenance.
- [NTSB LAX89DVM05](https://openairdocs.org/ntsb/LAX89DVM05.md): Skelton Emeraude · Watsonville, CA · Accident · No injuries · Final report · Aug 14, 1989 · N82D · Destroyed
  > An inadequate fuel line, due to improper installation by the owner/builder, fuel line failure, fuel line leak, and a subsequent fire.
- [NTSB NYC89LA194](https://openairdocs.org/ntsb/NYC89LA194.md): MBB ME 209 · Chatham, MA · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 1989 · N209AA · Substantial damage
  > The pilot stalled the aircraft while landing. Contributing factors to the accident were haze and the pilot applied power too late to arrest the airplane's sink rate.
- [NTSB MKC89LA177](https://openairdocs.org/ntsb/MKC89LA177.md): Cessna 180 · Topeka, KS · Accident · No injuries · Limited investigation · Final report · Aug 12, 1989 · N24TW · Substantial damage
  > The pilot's poorly planned approach and failure to maintain a proper glidepath. A contributing factor was the failure of the engine to supply power.
- [NTSB ATL89FA196](https://openairdocs.org/ntsb/ATL89FA196.md): Beech A-36 · Chapel Hill, NC · Accident · 1 fatal · Field investigation · Final report · Aug 12, 1989 · N25805 · Destroyed
  > The pilot's failure to maintain control of the airplane while maneuvering for a landing. Contributing factors were: the pilot's failure to follow the emergency procedures for an autopilot malfunction, and pilot fatigue.
- [NTSB ATL89DMG06](https://openairdocs.org/ntsb/ATL89DMG06.md): Dammann N3-2 · Hendersonville, NC · Accident · 1 fatal · Final report · Aug 11, 1989 · N70406 · Destroyed
  > Engine failure due to carburetor ice.
- [NTSB NYC89LA187](https://openairdocs.org/ntsb/NYC89LA187.md): Grumman AA-5 · Mount Joy, PA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1989 · N1611R · Substantial damage
  > The pilot's delay in initiating a go-around, and his failure to maintain proper runway alignment. Factors related to the accident were: failure of the pilot to attain the proper touchdown point and the crop.
- [NTSB NYC89IA185](https://openairdocs.org/ntsb/NYC89IA185.md): Boeing 727-254 · Boston, MA · Incident · Minor injuries · Incident investigation · Final report · Aug 10, 1989 · N915TS · Minor damage
  > The failure of the landing gear drag brace to unlock during landing. Contributing was the failure of pacific southwest airlines to catch the incorrect assembly. An additional factor was the use of faulty information by eastern airlines and their decision to…
- [NTSB CHI89LA162](https://openairdocs.org/ntsb/CHI89LA162.md): Taylorcraft BC12-D · Garrettsville, OH · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 1989 · N5131M · Destroyed
  > The pilot did not maintain adequate airspeed and allowed the aircraft to inadvertently enter a stall/spin. Turbulence was considered to be a contributing factor.
- [NTSB MIA89LA213](https://openairdocs.org/ntsb/MIA89LA213.md): Bell 47G-2 · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Aug 5, 1989 · N3550 · Substantial damage
  > The student pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: the student pilot's lack of total experience & tree(s) in the emergency landing area.
- [NTSB MKC89LA176](https://openairdocs.org/ntsb/MKC89LA176.md): Bell 206-B2 · Sebeka, MN · Accident · No injuries · Limited investigation · Final report · Aug 4, 1989 · N96117 · Substantial damage
  > Power plant failure due to a fracture of the first stage turbine wheel, resulting in an uncontrolled autorotation.
- [NTSB CHI89FA155](https://openairdocs.org/ntsb/CHI89FA155.md): Lancair 235 · Fond Du Lac, WI · Accident · 2 fatal · Field investigation · Final report · Aug 1, 1989 · N385L · Destroyed
  > Failure of the pilot-in-command to assure that adequate airspeed was maintained during the turn to final approach, which resulted in an inadvertent stall/spin.
- [NTSB LAX89LA254](https://openairdocs.org/ntsb/LAX89LA254.md): Piper PA-28-161 · Oceanside, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 1989 · N2933D · Substantial damage
  > The failure of the pilot-in-command to attain proper airspeed during the go-around. The lack of airspeed did not permit the airplane to climb and the pilot intentionally stalled the airplane into the trees. Contributing to the accident was the pilot delaying…
- [NTSB SEA89LA142](https://openairdocs.org/ntsb/SEA89LA142.md): Cessna 172E · Yerington, NV · Accident · No injuries · Limited investigation · Final report · Jul 30, 1989 · N14454 · Substantial damage
  > The pilot's failure to maintain adequate airspeed during a landing go-around in high density altitude conditions.
- [NTSB NYC89FA177](https://openairdocs.org/ntsb/NYC89FA177.md): Beech A36 · Salisbury Twp, PA · Accident · 7 fatal · Field investigation · Final report · Jul 30, 1989 · N2063V · 2 aircraft · Destroyed
  > The failure of both pilots to see and avoid each other. A contributing factor to the accident was that neither pilot was heard over the radio announcing their position and intentions.
- [NTSB BFO89DIG02](https://openairdocs.org/ntsb/BFO89DIG02.md): Piper PA-28 · Cumberland, MD · Accident · Minor injuries · Final report · Jul 30, 1989 · N38370 · Substantial damage
  > The pilot's improper decision to takeoff in deteriorating weather conditions. Related factors were: the pilot's failure to obtain a weather briefing prior to departure, and his lack of an instrument rating.
- [NTSB LAX89LA249](https://openairdocs.org/ntsb/LAX89LA249.md): Beech C24R · Lower Lake, CA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1989 · N18789 · Substantial damage
  > Pilot-in-command's failure to identify the sink rate soon enough to take corrective action.
- [NTSB LAX89LA250](https://openairdocs.org/ntsb/LAX89LA250.md): Cessna 210 · Thermal, CA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1989 · N76RR · Substantial damage
  > A twisted nose gear uplock due to an elongated bolt hole which prevented the nose gear from extending.
- [NTSB CHI89LA149](https://openairdocs.org/ntsb/CHI89LA149.md): Cessna 172M · Wixom, MI · Accident · No injuries · Limited investigation · Final report · Jul 27, 1989 · N12662 · Substantial damage
  > Carburetor ice due to the pilot's improper use of carburetor heat. Factors related to the accident were: weather conditions conducive to carburetor ice, dark night, and tree(s) in the emergency landing area.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.