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

## Cases, newest first

- [NTSB LAX03CA266](https://openairdocs.org/ntsb/LAX03CA266.md): Cessna 172M · Riverside, CA · Accident · No injuries · Data collection · Final report · Aug 24, 2003 · N64291 · Substantial damage
  > The student pilot's misjudged distance and altitude, and the instructor's inadequate supervision of the flight. Also causal was the instructor's delayed remedial action.
- [NTSB LAX03LA260](https://openairdocs.org/ntsb/LAX03LA260.md): Ercoupe 415-C · Saint Johns, AZ · Accident · No injuries · Limited investigation · Final report · Aug 22, 2003 · N3182H · Substantial damage
  > The failure of the exhaust valve on the number two engine cylinder, which resulted in a partial loss of engine power during the final approach to land, and an on ground collision with a ditch during the subsequent off-airport landing roll.
- [NTSB MIA03FA167](https://openairdocs.org/ntsb/MIA03FA167.md): Piper PA-31 · Clearwater, FL · Accident · 2 fatal · Field investigation · Final report · Aug 21, 2003 · N93DC · Destroyed
  > The failure of the flightcrew to maintain airspeed (Vs) resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with the ground.
- [NTSB CHI03LA274](https://openairdocs.org/ntsb/CHI03LA274.md): Boeing A-75 · La Crosse, WI · Accident · No injuries · Limited investigation · Final report · Aug 20, 2003 · N806RB · Substantial damage
  > The total loss of engine power due to a fatigue fracture of the engine's crankshaft. A factor was the corn crop.
- [NTSB NYC03CA179](https://openairdocs.org/ntsb/NYC03CA179.md): Cessna 172RG · Glens Falls, NY · Accident · No injuries · Data collection · Final report · Aug 16, 2003 · N9673B · Substantial damage
  > The pilot's failure to maintain control during the flare/touchdown, which resulted in a hard landing. Factors in this accident were wind gusts and the pilot's improper decision to land during thunderstorm activity.
- [NTSB LAX03LA256](https://openairdocs.org/ntsb/LAX03LA256.md): Cessna 150G · Angwin, CA · Accident · No injuries · Limited investigation · Final report · Aug 12, 2003 · N8515J · Substantial damage
  > The pilot's failure to maintain control of the airplane during an attempted go-around, which resulted in a hard landing. Also causal was the pilot's failure to maintain directional control.
- [NTSB IAD03FA070](https://openairdocs.org/ntsb/IAD03FA070.md): Piper PA-32-300 · Factoryville, PA · Accident · 2 fatal · Field investigation · Final report · Aug 8, 2003 · N6373C · Destroyed
  > The pilot's improper in-flight decision to descend below the published minimum descent altitude while executing a non-precision approach in instrument meteorological conditions, which resulted in collision with trees. A factor was the fog.
- [NTSB CHI03LA249](https://openairdocs.org/ntsb/CHI03LA249.md): North American AT-6D · Brookings, SD · Accident · No injuries · Limited investigation · Final report · Aug 7, 2003 · N9272K · Substantial damage
  > The inadequate fuel supply for the flight, and the inadequate preflight by the pilot resulting in exhaustion of the fuel supply and subsequent loss of engine power. The tree was a contributing factor.
- [NTSB NYC03FA176](https://openairdocs.org/ntsb/NYC03FA176.md): Grumman AA-5B · Pleasantville, PA · Accident · 1 fatal · Field investigation · Final report · Aug 6, 2003 · N28788 · Substantial damage
  > The pilot's improper IFR procedure by his failure to maintain published altitudes, which resulted in the in-flight collision with terrain. A factor was his impairment due to prescription medication.
- [NTSB LAX03LA251](https://openairdocs.org/ntsb/LAX03LA251.md): Beech 77 · French Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2003 · N972V · Substantial damage
  > The pilot's attempted low altitude flight maneuver during a go-around, which resulted in his loss of control of the airplane and subsequent in-flight collision with terrain.
- [NTSB ATL03LA121](https://openairdocs.org/ntsb/ATL03LA121.md): Lancair 235 · Fort Payne, AL · Accident · Minor injuries · Limited investigation · Final report · Jul 30, 2003 · N7156W · Substantial damage
  > The pilot's failure to properly reconnect the mixture control cable resulting in a total loss of engine power, and subsequent in-flight collision with the trees.
- [NTSB LAX03GA244](https://openairdocs.org/ntsb/LAX03GA244.md): Bell 206L-3 · Whiteriver, AZ · Accident · 2 fatal · Final report · Jul 26, 2003 · N6184D · Destroyed
  > The pilot's failure to maintain a minimum translational lift airspeed while maneuvering in high density altitude conditions at near maximum required torque and above the in ground effect hover altitude, that resulted in a loss of tail rotor effectiveness and…
- [NTSB NYC03LA165](https://openairdocs.org/ntsb/NYC03LA165.md): Beltram Glasair-TD · London, KY · Accident · No injuries · Limited investigation · Final report · Jul 25, 2003 · N22VB · Substantial damage
  > The pilot's failure to follow published procedures, which resulted in fuel starvation during approach.
- [NTSB SEA03LA151](https://openairdocs.org/ntsb/SEA03LA151.md): Hughes 269C · Snohomish, WA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2003 · N53KF · Substantial damage
  > The dual students failure to maintain clearance from the terrain during the go-around from a simulated autorotational flare, and the instructor pilot's failure to take adequate remedial action to keep the dual student from allowing the aircraft to impact the…
- [NTSB CHI03LA230](https://openairdocs.org/ntsb/CHI03LA230.md): Murch Rotec Rally 3 · Searcy, AR · Accident · No injuries · Limited investigation · Final report · Jul 24, 2003 · N317RE · Substantial damage
  > The frayed rudder cable that failed during the turn to final. A factor was the ditch the airplane encountered during the forced landing.
- [NTSB CHI03LA224](https://openairdocs.org/ntsb/CHI03LA224.md): Aerostar S81A · Highland, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 23, 2003 · N11BQ · No damage
  > Failure of the pilot to maintain a proper descent rate. Contributing factors were the pilot's failure to maintain clearance from the trees, the reported high winds and gusts, the trees, the power lines and the house.
- [NTSB CHI03LA221](https://openairdocs.org/ntsb/CHI03LA221.md): Navion L-17A · Canton, IL · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2003 · N2968C · Substantial damage
  > A complete loss of engine power during landing approach for undetermined reasons, as well as the unsuitable terrain for a forced landing encountered by the pilot. Contributing factors were the berm and the crops.
- [NTSB SEA03LA152](https://openairdocs.org/ntsb/SEA03LA152.md): Rockwell S-2R · Hermiston, OR · Accident · No injuries · Limited investigation · Final report · Jul 21, 2003 · N4250X · Substantial damage
  > The pilot's inadequate in-flight decision by failing to refuel, resulting in fuel exhaustion and the loss of power. Rocky terrain was a factor.
- [NTSB NYC03LA163](https://openairdocs.org/ntsb/NYC03LA163.md): Piper PA-28-181 · Sandusky, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 20, 2003 · N8199D · Substantial damage
  > The pilot's failure to maintain the engine mixture control during the go-around, which resulted in a loss of power, and in-flight collision with trees.
- [NTSB MIA03LA189](https://openairdocs.org/ntsb/MIA03LA189.md): Cessna 182P · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Jul 18, 2003 · N9913E · Substantial damage
  > The pilot's failure to attain the proper touchdown point which resulted in an undershoot.
- [NTSB FTW03LA189](https://openairdocs.org/ntsb/FTW03LA189.md): Beech 35-A33 · Fort Worth, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 18, 2003 · N44CN · Substantial damage
  > The loss of engine power due to the pilot's improper use of the mixture control. Contributing factors were the pilot's failure to select the battery/alternator circuit, resulting in a loss of battery power, the pilot's failure to follow a checklist and the…
- [NTSB SEA03LA141](https://openairdocs.org/ntsb/SEA03LA141.md): Great Lakes 2T-1A-2 · Newman Lake, WA · Accident · No injuries · Limited investigation · Final report · Jul 17, 2003 · N16GL · Substantial damage
  > The pilot's failure to maintain clearance from an object while on final approach for landing. Trees and inadequate visual lookout were factors.
- [NTSB SEA03LA134](https://openairdocs.org/ntsb/SEA03LA134.md): Archer S-18T · Arlington, WA · Accident · No injuries · Limited investigation · Final report · Jul 11, 2003 · N102PM · Substantial damage
  > The pilot's failure to maintain an airspeed above Vs (stalling speed) while making a close-in base-to-final turn.
- [NTSB SEA03LA131](https://openairdocs.org/ntsb/SEA03LA131.md): Piper PA-28-161 · Stuart Island, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2003 · N125ER · Substantial damage
  > The pilot's failure to maintain clearance while maneuvering to land. Contributing factors included the tree and the sunglare condition.
- [NTSB DEN03LA129](https://openairdocs.org/ntsb/DEN03LA129.md): Davis Zenair Stol 701 · Aurora, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2003 · N20584 · Substantial damage
  > the pilot's failure to attain adequate airspeed and establish a climb resulting in a stall/mush and collision with the ground. Contributing factors were his premature turn onto the downwind leg, and the plowed/furrowed terrain.
- [NTSB DEN03FA125](https://openairdocs.org/ntsb/DEN03FA125.md): CASA 2.111 · Cheyenne, WY · Accident · 2 fatal · Field investigation · Final report · Jul 10, 2003 · N72615 · Destroyed
  > A loss of engine power for reasons undetermined, and the pilot's failure to maintain aircraft control. Contributing factors were the unsuitable terrain on which to make a forced landing, low airspeed, the fence, automobile, and the school bus wash barn.
- [NTSB DEN03LA124](https://openairdocs.org/ntsb/DEN03LA124.md): PZL Wilga 104-80 · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Jul 8, 2003 · N214AL · Substantial damage
  > the pilot's failure to maintain airspeed which resulted in a stall.
- [NTSB ANC03LA068](https://openairdocs.org/ntsb/ANC03LA068.md): Cessna 170B · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Jul 6, 2003 · N63DJ · Substantial damage
  > The pilot's misjudged distance and altitude during an approach to land at an off-airport landing site, which resulted in an undershoot, and subsequent in-flight collision with terrain.
- [NTSB NYC03LA150](https://openairdocs.org/ntsb/NYC03LA150.md): Grumman American AA5B · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 2003 · N1966L · Substantial damage
  > The pilot's failure to maintain directional control while landing, after a loss of engine power as reported by the pilot. Factors in this accident were the pilot's improper flare, which resulted in a hard landing, and the crosswind condition.
- [NTSB SEA03LA127](https://openairdocs.org/ntsb/SEA03LA127.md): Lockheed 402-2 · Headquarters, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 2003 · N3380G · Substantial damage
  > The pilot's improper preflight planning and improper fuel consumption calculations. Factors contributing to the accident included the unfavorable wind condition, the downdraft, and the trees.
- [NTSB CHI03LA197](https://openairdocs.org/ntsb/CHI03LA197.md): Cessna 175 · Wessington Spri, SD · Accident · No injuries · Limited investigation · Final report · Jul 4, 2003 · N7256M · Destroyed
  > The pilot not obtaining/maintaining clearance from the barbed wire fence during the go-around. Factors to the accident were the fence, and the brush.
- [NTSB ATL03FA115](https://openairdocs.org/ntsb/ATL03FA115.md): Beech 58P · Memphis, TN · Accident · 2 fatal · Field investigation · Final report · Jul 2, 2003 · N36TL · Substantial damage
  > An encounter with wake turbulence on approach, which resulted in the pilot's inability to maintain control and subsequent in-flight collision with the ground.
- [NTSB LAX03CA220](https://openairdocs.org/ntsb/LAX03CA220.md): Robinson R22 Beta · Chandler, AZ · Accident · No injuries · Data collection · Final report · Jul 1, 2003 · N7508E · Substantial damage
  > The student's failure to maintain adequate main rotor rpm and his failure to relinquish the controls.
- [NTSB LAX03LA218](https://openairdocs.org/ntsb/LAX03LA218.md): Cessna 210 · Henderson, NV · Accident · No injuries · Limited investigation · Final report · Jun 30, 2003 · N9544T · Substantial damage
  > A bolt in the fuel selector that restricted the flow of fuel to the engine, which resulted in fuel starvation and a partial loss of engine power during the final approach to land.
- [NTSB DEN03LA118](https://openairdocs.org/ntsb/DEN03LA118.md): Cessna 210K · Durango, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2003 · N8264M · Substantial damage
  > the pilot's improper in-flight planning/decision and his failure to maintain aircraft control. Factors contributing to the accident were the high altitude on base turn and final approach, the low airspeed, the pilot's improper use of flaps, the inadvertent…
- [NTSB LAX03CA215](https://openairdocs.org/ntsb/LAX03CA215.md): Robinson R22 Beta · Prescott, AZ · Accident · No injuries · Data collection · Final report · Jun 28, 2003 · N332MD · Substantial damage
  > The pilot's failure to maintain adequate main rotor rpm, and, his improper use of the collective, throttle, and anti-torque controls during the attempted recovery. Factors in the accident were the pilot's failure to completely relinquish the controls, and the…
- [NTSB ANC03LA062](https://openairdocs.org/ntsb/ANC03LA062.md): Swearingen SA-226T · Goodnews, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 2003 · N512FS · Substantial damage
  > The flight crew's inadequate evaluation of the weather conditions, which resulted in their inadequate compensation for the wind conditions, and subsequent undershoot. A contributing factor in the accident was a downdraft.
- [NTSB IAD03CA061](https://openairdocs.org/ntsb/IAD03CA061.md): Robinson R22 Beta · Nashua, NH · Accident · No injuries · Data collection · Final report · Jun 27, 2003 · N185MH · Substantial damage
  > The pilot's failure to determine the wind direction, which resulted in a hard, tailwind landing.
- [NTSB SEA03LA118](https://openairdocs.org/ntsb/SEA03LA118.md): Herrin Hornet · Newberg, OR · Accident · 1 fatal · Limited investigation · Final report · Jun 26, 2003 · N1424 · Substantial damage
  > Aircraft control not maintained while maneuvering for landing.
- [NTSB MIA03FA135](https://openairdocs.org/ntsb/MIA03FA135.md): Cessna 414 · N. Fort Myers, FL · Accident · 2 fatal · Field investigation · Final report · Jun 26, 2003 · N749AA · Substantial damage
  > The failure of the pilot to maintain airspeed (Vs) following a total loss of engine power from the right engine due to fuel starvation, resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with trees and terrain. Factors in the…
- [NTSB NYC03LA142](https://openairdocs.org/ntsb/NYC03LA142.md): Beech 24 · Rome, NY · Accident · No injuries · Limited investigation · Final report · Jun 25, 2003 · N1485L · Substantial damage
  > The pilot's failure to maintain directional control during a go-around which resulted in the airplane impacting trees. A factor in the accident was the shifting wind.
- [NTSB DEN03FA111](https://openairdocs.org/ntsb/DEN03FA111.md): Hammond Vans RV-6A · La Junta, CO · Accident · 1 fatal · Field investigation · Final report · Jun 24, 2003 · N199LH · Destroyed
  > the pilot's failure to maintain airspeed resulting in a stall during the turn from base leg to final approach.
- [NTSB CHI03LA180](https://openairdocs.org/ntsb/CHI03LA180.md): Cessna 170B · Widener, AR · Accident · No injuries · Limited investigation · Final report · Jun 24, 2003 · N4478B · Substantial damage
  > The pilot's failure to maintain clearance from the wires and his failure to maintain adequate airspeed, resulting in a stall. A factor contributing to the accident was the unmarked wires.
- [NTSB CHI03LA175](https://openairdocs.org/ntsb/CHI03LA175.md): Cessna 210M · Carlisle, AR · Accident · No injuries · Limited investigation · Final report · Jun 23, 2003 · N9TK · Substantial damage
  > The pilot's improper in-flight decision to descend for landing, at night, without the runway environment insight. Contributing factors were the pilot's disorientation, the embankment and the dark night condition.
- [NTSB LAX03CA208](https://openairdocs.org/ntsb/LAX03CA208.md): Cessna 172K · Overton, NV · Accident · No injuries · Data collection · Final report · Jun 22, 2003 · N7342G · Substantial damage
  > the student pilot's failure to maintain an adequate airspeed and his premature raising of the flaps during a go-around, which led to an inadvertent stall/mush. The flight instructor's inadequate supervision of the flight is also causal.
- [NTSB ATL03FA111](https://openairdocs.org/ntsb/ATL03FA111.md): Maule M-5-235C · Rockvale, TN · Accident · 3 fatal · Field investigation · Final report · Jun 22, 2003 · N555MR · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB SEA03FA110](https://openairdocs.org/ntsb/SEA03FA110.md): Harshbarger W/Reed RV-8 · Grants Pass, OR · Accident · 1 fatal · Field investigation · Final report · Jun 20, 2003 · N863Y · Substantial damage
  > Corrosion and contamination within the fuel servo unit and the pilot's delayed turn back to the runway. Contributing factors were trees and the pilot's impairment due to prescription medication.
- [NTSB ATL03LA108](https://openairdocs.org/ntsb/ATL03LA108.md): Piper PA-32-300 · Fort Mill, SC · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 2003 · N685BW · Substantial damage
  > The pilot's mismanagement of the fuel supply, which resulted in fuel starvation and the subsequent loss of engine power.
- [NTSB SEA03CA102](https://openairdocs.org/ntsb/SEA03CA102.md): Piper PA-18 · Silver City, MT · Accident · No injuries · Data collection · Final report · Jun 14, 2003 · N82946 · Substantial damage
  > Proper descent rate not maintained while on final approach. A wind gust is a factor in the accident.
- [NTSB LAX03LA192](https://openairdocs.org/ntsb/LAX03LA192.md): Argus CA-7 · Angleton, TX · Accident · 1 fatal · Limited investigation · Final report · Jun 11, 2003 · N9043L · Destroyed
  > the pilot's loss of lateral aircraft control. Also causal was the pilot's intentional flight with an asymmetrical fuel loading, and his improper use of the fuel system. A factor in the accident was the insufficient information provided by the kit manufacturer…

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

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

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