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

## Cases, newest first

- [NTSB LAX96LA112](https://openairdocs.org/ntsb/LAX96LA112.md): Steeves KR2 · San Diego, CA · Accident · 1 fatal · Limited investigation · Final report · Feb 17, 1996 · N395DS · Destroyed
  > failure of the pilot to maintain an adequate airspeed margin above stall, while at low altitude in the traffic pattern. His decision to explore the slow speed envelope of the aircraft at low altitude was a related factor.
- [NTSB FTW96LA122](https://openairdocs.org/ntsb/FTW96LA122.md): Cessna 182P · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Feb 17, 1996 · N9901M · Substantial damage
  > The pilot not following procedures and directives in that he did not periodically clear the engine during an extended glide. The factors were carburetor icing weather conditions and lack of suitable terrain for landing.
- [NTSB ATL96FA049](https://openairdocs.org/ntsb/ATL96FA049.md): Piper PA-28-181 · Johns Island, SC · Accident · 2 fatal · Field investigation · Final report · Feb 17, 1996 · N3052T · Substantial damage
  > the pilot's inadequate evaluation of the weather conditions and the continued flight into icing conditions which resulted in the loss of engine power. A factor was conditions favorable for the formation of carburetor icing.
- [NTSB CHI96LA087](https://openairdocs.org/ntsb/CHI96LA087.md): Piper PA-28-161 · Warren, MN · Accident · No injuries · Limited investigation · Final report · Feb 13, 1996 · N145ND · Substantial damage
  > the dual student's failure to maintain a proper glidepath and inadequate supervision by the instructor.
- [NTSB SEA96LA052](https://openairdocs.org/ntsb/SEA96LA052.md): Stinson 108-3 · Hubbard, OR · Accident · No injuries · Limited investigation · Final report · Feb 12, 1996 · N417DW · Substantial damage
  > the pilot's misjudgment of altitude and distance on short final. A factor was the wet and soft terrain short of the runway threshold.
- [NTSB NYC96LA062](https://openairdocs.org/ntsb/NYC96LA062.md): Piper PA-46-350P · Butler, PA · Accident · Serious injuries · Limited investigation · Final report · Feb 12, 1996 · N89HS · Destroyed
  > the pilot's inadequate compensation for wind conditions during the final approach, which resulted in the uncontrolled descent and subsequent collision with the ground. A contributing factor is windshear conditions.
- [NTSB ATL96LA046](https://openairdocs.org/ntsb/ATL96LA046.md): North American P-51D · Palm City, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 1996 · N551MR · Destroyed
  > An improperly adjusted carburetor which resulted in fuel starvation.
- [NTSB FTW96FA113](https://openairdocs.org/ntsb/FTW96FA113.md): Cessna 150 · Galveston, TX · Accident · 1 fatal · Field investigation · Final report · Feb 10, 1996 · N7973F · Destroyed
  > the pilot's inadvertent flight into instrument meteorological conditions (IMC), and his failure to sufficient altitude. Factors relating to the accident were: darkness, foggy weather conditions, the pilot's lack of instrument experience, his lack of recent…
- [NTSB MIA96LA077](https://openairdocs.org/ntsb/MIA96LA077.md): Piper J-3C-65 · Winter Haven, FL · Accident · No injuries · Limited investigation · Final report · Feb 9, 1996 · N6666H · Substantial damage
  > Failure of the pilot to maintain control of the aircraft after initiating a go-around, which resulted in the right wing contacting the ground. The unfavorable wind condition was a related factor.
- [NTSB SEA96LA049](https://openairdocs.org/ntsb/SEA96LA049.md): Piper PA-32-300 · Heber City, UT · Accident · Minor injuries · Limited investigation · Final report · Feb 6, 1996 · N9242C · Substantial damage
  > the pilot's attempted VFR flight into IMC, and his failure to maintain adequate altitude and clearance from terrain during the landing flare. Factors contributing to the accident were the snowbank, fog, and the pilot's complacent attitude.
- [NTSB LAX96FA105](https://openairdocs.org/ntsb/LAX96FA105.md): Beech E90 · Flagstaff, AZ · Accident · 3 fatal · Field investigation · Final report · Jan 31, 1996 · N300SP · Destroyed
  > failure of the pilot to follow prescribed IFR procedures and his failure to maintain control of the aircraft. Factors relating to the accident were: the adverse weather conditions with icing and turbulence.
- [NTSB ATL96LA040](https://openairdocs.org/ntsb/ATL96LA040.md): Cessna 150H · Knoxville, TN · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 1996 · N50215 · Substantial damage
  > Failure of the pilot to maintain sufficient airspeed during a go-around, which resulted in a stall.
- [NTSB MIA96LA073](https://openairdocs.org/ntsb/MIA96LA073.md): Gilpatrick Baby Lakes · Deland, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 27, 1996 · N26BG · Substantial damage
  > The pilot's misjudgment of distance and altitude, while on final approach to land, and his failure to attain the proper touchdown point for landing. The unfavorable wind condition (crosswind) was a related factor.
- [NTSB MIA96LA071](https://openairdocs.org/ntsb/MIA96LA071.md): Cessna 310R · Fort Pierce, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 24, 1996 · N5079J · Substantial damage
  > failure of the pilot to follow emergency procedure(s) and/or feather the respective propeller after loss of power in the left engine for an undetermined reason. The undetermined loss of power (left engine) was a related factor.
- [NTSB ATL96LA039](https://openairdocs.org/ntsb/ATL96LA039.md): Cessna 152 · Greenville, SC · Accident · Minor injuries · Limited investigation · Final report · Jan 23, 1996 · N65465 · Substantial damage
  > the failure of the student pilot to maintain airspeed while raising the flaps during the go-around.
- [NTSB NYC96LA053](https://openairdocs.org/ntsb/NYC96LA053.md): Mitsubishi MU-2B-6 · Allentown, PA · Accident · Minor injuries · Limited investigation · Final report · Jan 19, 1996 · N888TP · Substantial damage
  > the pilot's failure to comply with IFR procedures in that he attempted an instrument approach with visibility below the required minimums, and his delayed execution of a missed approach. A factor was the reduced visibility due to clouds.
- [NTSB FTW96LA098](https://openairdocs.org/ntsb/FTW96LA098.md): Cessna T210M · Las Vegas, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1996 · N761KK · Substantial damage
  > failure of the throttle cable. A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB ATL96FA036](https://openairdocs.org/ntsb/ATL96FA036.md): Piper PA-46-350P · Peachtree City, GA · Accident · 2 fatal · Field investigation · Final report · Jan 16, 1996 · N9210F · Destroyed
  > The pilot's failure to follow the published instrument approach procedure. The fog was a factor.
- [NTSB NYC96LA050](https://openairdocs.org/ntsb/NYC96LA050.md): Cessna 172M · Nashua, NH · Accident · No injuries · Limited investigation · Final report · Jan 14, 1996 · N61765 · Substantial damage
  > the pilot's inadequate crosswind compensation during the go-around.
- [NTSB FTW96LA093](https://openairdocs.org/ntsb/FTW96LA093.md): Beech 35-A33 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jan 14, 1996 · N1111Z · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX96FA094](https://openairdocs.org/ntsb/LAX96FA094.md): Cessna 150 · Suisun, CA · Accident · 2 fatal · Field investigation · Final report · Jan 12, 1996 · N18106 · Destroyed
  > the pilot's continued flight into known adverse weather conditions which eventually led to a loss of control due to spatial disorientation. Factors in the accident were: the pilot's inadequate preflight planning, his impairment due to medication, the foggy…
- [NTSB BFO96LA036](https://openairdocs.org/ntsb/BFO96LA036.md): Cessna T210N · Louisville, KY · Accident · Serious injuries · Limited investigation · Final report · Jan 12, 1996 · N5218A · Destroyed
  > the pilot's misjudgment of the fuel supply, which resulted in a loss of engine power due to fuel exhaustion during final approach to the destination airport. Factors relating to the accident were: terrain conditions and vehicles in the emergency landing area.
- [NTSB CHI96LA068](https://openairdocs.org/ntsb/CHI96LA068.md): Piper PA-34-200T · Des Moines, IA · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 1996 · N3679M · Substantial damage
  > the pilot not using the airplane's deice system which resulted in an accumulation of empennage ice and a tailplane stall. Factors relating to this accident were the pilot's intentional flight into known icing conditions, and the icing conditions.
- [NTSB SEA96FA040](https://openairdocs.org/ntsb/SEA96FA040.md): Cessna 401A · Spokane, WA · Accident · 3 fatal · Field investigation · Final report · Jan 9, 1996 · N117AC · Destroyed
  > failure of the pilot to follow proper IFR procedures, by failing to maintain proper alignment with the localizer course during the ILS approach and/or by failing to follow the proper missed approach procedure. Factors relating to the accident were: darkness;…
- [NTSB BFO96LA037](https://openairdocs.org/ntsb/BFO96LA037.md): Piper PA-28-181 · Coshocton, OH · Accident · No injuries · Limited investigation · Final report · Jan 9, 1996 · N9248K · Substantial damage
  > loss of engine power for an undetermined reason(s). A factor relating to the accident was: the proximity of high obstructions (trees) to the emergency landing area.
- [NTSB ATL96LA030](https://openairdocs.org/ntsb/ATL96LA030.md): Piper PA-34-200T · Gulfport, MS · Accident · Minor injuries · Limited investigation · Final report · Jan 7, 1996 · N424WA · Substantial damage
  > inadequate preflight planning/preparation by the pilot, and inadequate supply of fuel in the airplane, which resulted in fuel exhaustion and subsequent ditching at sea.
- [NTSB ATL96FA029](https://openairdocs.org/ntsb/ATL96FA029.md): Cessna 210H · Columbia, TN · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1996 · N44DJ · Substantial damage
  > failure of the pilot to follow procedures/directives by flying in instrument meteorological conditions (IMC) without proper training/certification; and his failure (or inability) to follow proper IFR procedures and maintain proper altitude during an…
- [NTSB SEA96FA039](https://openairdocs.org/ntsb/SEA96FA039.md): Convair 340 · Spokane, WA · Accident · Minor injuries · Field investigation · Final report · Jan 5, 1996 · N358SA · Destroyed
  > the pilot's improper management of the fuel/system, which resulted in loss of power in both engines, due to fuel starvation. Factors relating to the accident were: false indications of the cockpit fuel gauges, darkness, and the presence of a berm in the…
- [NTSB MIA96FA051](https://openairdocs.org/ntsb/MIA96FA051.md): Cessna 550 · East Naples, FL · Accident · 2 fatal · Field investigation · Final report · Dec 31, 1995 · N91MJ · Destroyed
  > The pilot's disregard for the MDA for a specific segment of the VOR/DME approach which resulted in the inflight collision with a guy wire of an antenna and separation of 8.5 feet of the left wing.
- [NTSB LAX96FA086](https://openairdocs.org/ntsb/LAX96FA086.md): Beech V35B · Delano, CA · Accident · 4 fatal · Field investigation · Final report · Dec 30, 1995 · N7337R · Destroyed
  > Failure of the pilot to maintain control of the aircraft during an IFR circling approach. A factor relating to the accident was: the pilot's lack of instrument flight experience in high performance aircraft.
- [NTSB CHI96FA067](https://openairdocs.org/ntsb/CHI96FA067.md): Cessna 560 · Eagle River, WI · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1995 · N991PC · Destroyed
  > the failure of the pilot to maintain airspeed while executing the circling approach. Factors were the descent below minimum descent altitude, the fog, the low ceiling and the icing conditions.
- [NTSB BFO96FA034](https://openairdocs.org/ntsb/BFO96FA034.md): Piper PA-28R-180 · Louisville, KY · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1995 · N7676J · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall, loss of altitude, and subsequent collision with obstructions (utility pole and supporting cable).
- [NTSB LAX96LA088](https://openairdocs.org/ntsb/LAX96LA088.md): Cessna 150L · Quartzite, AZ · Accident · No injuries · Limited investigation · Final report · Dec 29, 1995 · N1246Q · Substantial damage
  > the pilot's misjudgement of his distance and altitude relationship to the runway, which resulted in an undershoot and failure to achieve the proper touchdown point for landing.
- [NTSB CHI96LA064](https://openairdocs.org/ntsb/CHI96LA064.md): Bellanca 7GCBC · Munich, ND · Accident · No injuries · Limited investigation · Final report · Dec 28, 1995 · N88384 · Substantial damage
  > the pilot allowed his airspeed to get too low and encountered a stall/mush condition. Factors associated with the accident were the pilot not being able to maintain directional control due to misuse of the controls for wind drift correction and improper use…
- [NTSB CHI96IA066](https://openairdocs.org/ntsb/CHI96IA066.md): Fairchild SA227-AC · Bemidji, MN · Incident · No injuries · Incident investigation · Final report · Dec 28, 1995 · N159MC · No damage
  > inadequate maintenance installation and inspection of the elevator flight control system which led to restricted flight control elevator movement due to a loose bolt.
- [NTSB FTW96FA075](https://openairdocs.org/ntsb/FTW96FA075.md): Aero Commander 112 · Carlsbad, NM · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1995 · N1152J · Destroyed
  > The pilot's failure to maintain aircraft control due to spatial disorientation. Factors were the pilot's lack of total actual instrument weather time and the clouds.
- [NTSB LAX96FA078](https://openairdocs.org/ntsb/LAX96FA078.md): Piper PA-31-350 · San Jose, CA · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1995 · N27954 · Destroyed
  > The failure of the air traffic controller to comply with instructions contained in the Air Traffic Control Handbook, FAA Order 7110.65, which resulted in the flight being vectored at an altitude below the minimum vectoring altitude (MVA) and failure to issue…
- [NTSB FTW96LA083](https://openairdocs.org/ntsb/FTW96LA083.md): Piper PA-22-160 · Waller, TX · Accident · No injuries · Limited investigation · Final report · Dec 22, 1995 · N9591D · Substantial damage
  > the pilot's failure to maintain obstacle clearance.
- [NTSB CHI96LA057](https://openairdocs.org/ntsb/CHI96LA057.md): Beech 58 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Dec 22, 1995 · N222RB · Substantial damage
  > the pilot-in-command's abrupt maneuvering during the circling approach. The factors involved were the airframe ice and fog.
- [NTSB MIA96FA048](https://openairdocs.org/ntsb/MIA96FA048.md): Piper PA-32-301 · Memphis, TN · Accident · 2 fatal · Field investigation · Final report · Dec 19, 1995 · N8349Z · Destroyed
  > the pilot's continued flight into known forecast icing conditions which resulted in the aircraft developing an ice buildup, and the pilot's failure to maintain control of the aircraft. The icing conditions was a factor.
- [NTSB ATL96LA024](https://openairdocs.org/ntsb/ATL96LA024.md): Piper PA-32-300 · Monroe, NC · Accident · No injuries · Limited investigation · Final report · Dec 19, 1995 · N4219T · Substantial damage
  > The pilot's inadequate planning and failure to follow operating procedures resulted in his descent below the decision height while on final approach.
- [NTSB SEA96LA030](https://openairdocs.org/ntsb/SEA96LA030.md): Cessna 170B · John Day, OR · Accident · No injuries · Limited investigation · Final report · Dec 16, 1995 · N3171B · Substantial damage
  > The pilot's failure to maintain a proper glidepath.
- [NTSB MIA96LA040](https://openairdocs.org/ntsb/MIA96LA040.md): Cessna 152 · Macon, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 1995 · N48959 · Substantial damage
  > The pilot-in-command's failure to assure an adequate amount of fuel was available for the flight.
- [NTSB FTW96LA069](https://openairdocs.org/ntsb/FTW96LA069.md): Ayres S2R-T34 · West Helena, AR · Accident · No injuries · Limited investigation · Final report · Dec 13, 1995 · N3090C · Substantial damage
  > Binding of the power lever linkage, due to corrosion, which resulted in a situation that led to an inadvertent shut-down of the engine at a critical point on the approach to land. A factor relating to the accident was: inadequate maintenance.
- [NTSB MIA96IA039](https://openairdocs.org/ntsb/MIA96IA039.md): Boeing 747-212B · Amsterdam, Netherlands · Incident · No injuries · Incident investigation · Final report · Dec 10, 1995 · N616FF · Minor damage
  > The failure of the captain to maintain a level wings attitude during a go-around resulting in the right wing dragging on the ground.
- [NTSB ANC96LA018](https://openairdocs.org/ntsb/ANC96LA018.md): Piper PA-32-300 · Nanwalek, AK · Accident · Serious injuries · Limited investigation · Final report · Dec 10, 1995 · N15175 · Substantial damage
  > The pilot's inadequate compensation for wind conditions. A factor in the accident was the variable wind.
- [NTSB LAX96LA069](https://openairdocs.org/ntsb/LAX96LA069.md): Cessna 172 · Ocotillo Wells, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 1995 · N4203L · Substantial damage
  > the failure of the pilot to maintain a proper glide path on final approach.
- [NTSB LAX96LA068](https://openairdocs.org/ntsb/LAX96LA068.md): Cessna T210N · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Dec 8, 1995 · N214BD · Destroyed
  > the pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, due to an inadequate supply of fuel, followed by a forced landing in an area of trees. Darkness was a related factor.
- [NTSB LAX96FA067](https://openairdocs.org/ntsb/LAX96FA067.md): Cessna 340A · San Dimas, CA · Accident · 1 fatal · Field investigation · Final report · Dec 7, 1995 · N37324 · Destroyed
  > the pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, his failure to follow proper IFR procedures, and his failure to maintain proper altitude during a missed approach. Factors relating to the accident…
- [NTSB MIA96LA036](https://openairdocs.org/ntsb/MIA96LA036.md): Cessna 150J · Orange Springs, FL · Accident · No injuries · Limited investigation · Final report · Dec 6, 1995 · N60758 · Substantial damage
  > The pilot's improper use of carburetor heat resulting in engine failure due to carburetor ice.

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

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

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