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

## Cases, newest first

- [NTSB ATL02LA173](https://openairdocs.org/ntsb/ATL02LA173.md): Piper PA-32RT-300 · St. Simons Island, GA · Accident · Serious injuries · Limited investigation · Final report · Sep 21, 2002 · N607JW · Substantial damage
  > The pilot's failure to maintain airspeed during a simulated emergency landing, and his delayed remedial action that resulted in a stall, and an uncontrolled collision with trees. A factor was the check pilot's inadaquate supervision of the check ride.
- [NTSB ATL02FA171](https://openairdocs.org/ntsb/ATL02FA171.md): Mooney M20R · Burnsville, NC · Accident · 2 fatal · Field investigation · Final report · Sep 20, 2002 · N574DJ · Destroyed
  > The pilot's failure to maintain airspeed during final approach, which resulted in an inadvertent stall and uncontrolled descent into trees and terrain. Factors were wind gusts and terrain-induced turbulence.
- [NTSB LAX02FA288](https://openairdocs.org/ntsb/LAX02FA288.md): Mooney M-20E · Carlsbad, CA · Accident · 3 fatal · Field investigation · Final report · Sep 17, 2002 · N7199U · 2 aircraft · Destroyed
  > failure of the pilots of both airplanes to maintain an adequate visual lookout and to see and avoid each other. A contributing factor was the failure of the controller to detect and resolve the conflict between the airplanes.
- [NTSB FTW02LA257](https://openairdocs.org/ntsb/FTW02LA257.md): Smith Aerostar 601P · Piedmont, OK · Accident · No injuries · Limited investigation · Final report · Sep 16, 2002 · N90652 · Substantial damage
  > A fuel leak at the left boost pump to bladder tank flange, which resulted in fuel exhaustion and the subsequent loss of power to both engines.
- [NTSB SEA02FA175](https://openairdocs.org/ntsb/SEA02FA175.md): Cessna TR182 · Twin Falls, ID · Accident · 3 fatal · Field investigation · Final report · Sep 15, 2002 · N738GX · Destroyed
  > The pilot's failure to maintain runway alignment and his failure to execute a timely go-around maneuver resutling in the aircraft's impacting a parked fuel truck well clear of the runway safety area. Contributing factors were the strong crosswind/gusty wind…
- [NTSB IAD02LA093](https://openairdocs.org/ntsb/IAD02LA093.md): Cessna 177 · Dayton, OH · Accident · No injuries · Limited investigation · Final report · Sep 13, 2002 · N2916X · Substantial damage
  > The pilot's failure to maintain adequate airspeed, resulting in a stall.
- [NTSB FTW02LA253](https://openairdocs.org/ntsb/FTW02LA253.md): Mooney M20F · Rector, AR · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 2002 · N6369Q · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.
- [NTSB CHI02LA271](https://openairdocs.org/ntsb/CHI02LA271.md): Cessna 152 · Brooklyn Park, MN · Accident · No injuries · Limited investigation · Final report · Sep 5, 2002 · N48969 · Substantial damage
  > The pilot's inadequate preflight preparation/planning, which resulted in fuel exhaustion and the loss of engine power. A factor to the accident was the power transmission line and the trees.
- [NTSB LAX02LA273](https://openairdocs.org/ntsb/LAX02LA273.md): Petrik Questair Venture · Crescent City, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 4, 2002 · N6UN · Substantial damage
  > The pilot's loss of control for undetermined reasons. A contributing factor was low ceiling.
- [NTSB FTW02FA243](https://openairdocs.org/ntsb/FTW02FA243.md): Schweizer SGS 1-34 · Decatur, TX · Accident · 1 fatal · Field investigation · Final report · Sep 2, 2002 · N2691H · Substantial damage
  > The pilot's failure to maintain airspeed resulting in an inadvertent stall. A contributing factor was lack of total experience in the make and model of the accident aircraft.
- [NTSB MIA02LA165](https://openairdocs.org/ntsb/MIA02LA165.md): Cessna T337D · Fort Pierce, FL · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2002 · N33N · Substantial damage
  > The pilot's misjudgment of the fuel supply, and subsequent fuel exhaustion.
- [NTSB MIA02LA164](https://openairdocs.org/ntsb/MIA02LA164.md): Clarence F. Callahan Challenger II · Plymouth, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2002 · N521CF · Substantial damage
  > The pilot's failure to maintain the proper alignment which resulted in the airplane impacting trees on the south side of the approach end of the landing runway.
- [NTSB ATL02FA162](https://openairdocs.org/ntsb/ATL02FA162.md): American General AA-5B · Zephyrhills, FL · Accident · 2 fatal · Field investigation · Final report · Sep 1, 2002 · N81189 · Destroyed
  > The pilots continued visual flight into instrument conditions (fog), and subsequent collision with a tree and a residence.
- [NTSB ANC02FA107](https://openairdocs.org/ntsb/ANC02FA107.md): Cessna A185F · Kodiak, AK · Accident · 2 fatal · Field investigation · Final report · Aug 28, 2002 · N7300R · Substantial damage
  > The pilot's failure to maintain adequate airspeed and his operation of the airplane in an over gross condition. A contributing factor was noncompliance with written company weight and balance procedures.
- [NTSB IAD02LA090](https://openairdocs.org/ntsb/IAD02LA090.md): Cessna T210N · Glastonbury, CT · Accident · No injuries · Limited investigation · Final report · Aug 26, 2002 · N4908C · Substantial damage
  > A partial loss of engine power for undetermined reasons. A factor in the airplane's damage was the standing corn.
- [NTSB DEN02TA100](https://openairdocs.org/ntsb/DEN02TA100.md): Bell 206L-3 · Saguache, CO · Accident · Serious injuries · Final report · Aug 26, 2002 · N801HM · Substantial damage
  > the pilot's inadequate in-flight planning and decision making, and the loss of tail rotor effectiveness. A contributing factor was the right quartering tailwind.
- [NTSB LAX02LA263](https://openairdocs.org/ntsb/LAX02LA263.md): Pravecek Lawrence Varieze · Rio Linda, CA · Accident · No injuries · Limited investigation · Final report · Aug 25, 2002 · N42231 · Substantial damage
  > the loss of engine power caused by fuel exhaustion due to a fuel tank leak. Also causal was the inadequate maintenance performed on the repair of the fuel tank by unknown maintenance personnel.
- [NTSB IAD02LA089](https://openairdocs.org/ntsb/IAD02LA089.md): Puhl Genesis · Petersburg, WV · Accident · 1 fatal · Limited investigation · Final report · Aug 25, 2002 · N51XT · Destroyed
  > The pilot's failure to maintain airspeed after a loss of engine power, which resulted in an inadvertent stall/spin. Factors included the pilot's inadequate preflight planning which resulted in fuel exhaustion, and the transmission wires in the pilot's glide…
- [NTSB CHI02LA263](https://openairdocs.org/ntsb/CHI02LA263.md): Robinson R22 Beta · Seneca, IL · Accident · No injuries · Limited investigation · Final report · Aug 24, 2002 · N102MH · Substantial damage
  > The loss of engine power for undetermined reasons. Factors were the low altitude, the trees, and the unsuitable terrain encountered for the forced landing.
- [NTSB NYC02FA173](https://openairdocs.org/ntsb/NYC02FA173.md): Piper PA-22-108 · Mayville, NY · Accident · 1 fatal · Field investigation · Final report · Aug 21, 2002 · N5221Z · Substantial damage
  > The student pilot's failure to maintain adequate altitude during the landing approach and the private pilot's inadequate supervision, which resulted in a collision with a marked utility pole. A factor in this accident was the student pilot's lack of…
- [NTSB NYC02LA167](https://openairdocs.org/ntsb/NYC02LA167.md): Piper PA32-300 · Chatham, MA · Accident · No injuries · Limited investigation · Final report · Aug 16, 2002 · N20787 · Substantial damage
  > The pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…
- [NTSB CHI02LA252](https://openairdocs.org/ntsb/CHI02LA252.md): Lancair 320 · Iola, KS · Accident · Minor injuries · Limited investigation · Final report · Aug 15, 2002 · N83WS · Substantial damage
  > the engine failure for undetermined reasons and the lack of a suitable landing area to execute a forced landing.
- [NTSB NYC02LA165](https://openairdocs.org/ntsb/NYC02LA165.md): Cessna 172G · Sangerville, ME · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2002 · N56BC · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around, which resulted in an inadvertent stall.
- [NTSB ANC02FA097](https://openairdocs.org/ntsb/ANC02FA097.md): Piper PA-18 · Skwentna, AK · Accident · 2 fatal · Field investigation · Final report · Aug 14, 2002 · N4065Z · Destroyed
  > The pilot's failure to maintain adequate airspeed while on approach to land, which resulted in an inadvertent stall, and subsequent collision with trees.
- [NTSB SEA02LA154](https://openairdocs.org/ntsb/SEA02LA154.md): Cessna 182 · Bellingham, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 2002 · N6420A · Substantial damage
  > The pilot's improper decision to continue en route in cruise flight when his fuel supply became low, eventually leading to fuel exhaustion while on final approach to the destination airport. Factors include the fact that the final approach course took the…
- [NTSB LAX02FA251](https://openairdocs.org/ntsb/LAX02FA251.md): Aero Commander 690A · Bishop, CA · Accident · 4 fatal · Field investigation · Final report · Aug 11, 2002 · N690TB · Destroyed
  > The pilot's failure to maintain an appropriate terrain clearance altitude while maneuvering in the traffic pattern due to the sensory and visual illusions created by a lack of ground reference lights and/or terrain conspicuity, and the dark nighttime…
- [NTSB FTW02LA236](https://openairdocs.org/ntsb/FTW02LA236.md): Aero Commander Callair A-9B · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Aug 10, 2002 · N7718V · Substantial damage
  > The pilot's inadequate recovery from a bounced landing, and his failure to maintain directional control. Contributing factors were the cross wind, and the pilot's lack of experience in the make and model of the accident airplane.
- [NTSB ATL02IA155](https://openairdocs.org/ntsb/ATL02IA155.md): McDonnell Douglas DC-10-10 · Tampa, FL · Incident · No injuries · Incident investigation · Final report · Aug 10, 2002 · N388FE · Minor damage
  > The failure of the left main landing gear retract cylinder support frame due to fatigue.
- [NTSB MIA02LA146](https://openairdocs.org/ntsb/MIA02LA146.md): Beech 58 · Fort Lauderdale, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2002 · N8180R · Destroyed
  > the pilot's abrupt pull up and his failure to maintain airspeed during a go-around, which resulted in an inadvertent stall/spin and impact with the terrain during the resultant uncontrolled descent.
- [NTSB LAX02LA248](https://openairdocs.org/ntsb/LAX02LA248.md): Mooney M20M · Gualala, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 2002 · N1038K · Destroyed
  > The pilot's delayed decision in executing a go-around. Contributing factors were the pilot's limited experience landing on short fields and the rising terrain.
- [NTSB CHI02FA237](https://openairdocs.org/ntsb/CHI02FA237.md): Beech 95-A55 · Festus, MO · Accident · 1 fatal · Field investigation · Final report · Aug 7, 2002 · N13MS · Destroyed
  > The pilot's lack of recent experience and his failure to maintain adequate airspeed which resulted in a stall and collision with the ground. The pilot's failure to execute a go-around was a factor.
- [NTSB NYC02LA155](https://openairdocs.org/ntsb/NYC02LA155.md): Piper PA-28-235 · Coatesville, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 6, 2002 · N31SW · Substantial damage
  > The pilot's inaccurate in-flight planning and fuel consumption calculations, and his improper decision to not land and refuel which led to fuel exhaustion and subsequent loss of engine power.
- [NTSB CHI02LA240](https://openairdocs.org/ntsb/CHI02LA240.md): Cessna 150H · Dyersville, IA · Accident · No injuries · Limited investigation · Final report · Aug 6, 2002 · N6995S · Substantial damage
  > The pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion and subsequent loss of engine power. A related factor was the bean field.
- [NTSB NYC02LA153](https://openairdocs.org/ntsb/NYC02LA153.md): Piper PA-32-300 · Bluffton, OH · Accident · No injuries · Limited investigation · Final report · Aug 4, 2002 · N110CF · Substantial damage
  > The pilot's fuel mismanagement with his failure to position the fuel selector to the proper tank which resulted in engine fuel starvation.
- [NTSB MIA02FA144](https://openairdocs.org/ntsb/MIA02FA144.md): Piper PA-28-180 · Cheraw, SC · Accident · 1 fatal · Field investigation · Final report · Aug 3, 2002 · N3450R · Substantial damage
  > The misrouting of the fuel lines to the fuel selector, which resulted in the use of a fuel tank with inadequate fuel supply, fuel starvation, and the loss of engine power. Contributing was the pilot's inadequate remedial action for conducting an emergency…
- [NTSB IAD02LA080](https://openairdocs.org/ntsb/IAD02LA080.md): Cessna 172K · Patuxent River, MD · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2002 · N1177M · Substantial damage
  > The pilot's inadequate fuel calculations, which resulted in fuel exhaustion and a subsequent loss of engine power.
- [NTSB SEA02LA141](https://openairdocs.org/ntsb/SEA02LA141.md): Cessna 210L · Cascade, ID · Accident · No injuries · Limited investigation · Final report · Jul 30, 2002 · N732EK · Substantial damage
  > The pilot's failure to maintain the proper rate of descent on short final resulting in a touchdown short of the runway threshold. Contributing factors were the variable winds and swampy terrain at the touchdown site.
- [NTSB SEA02LA138](https://openairdocs.org/ntsb/SEA02LA138.md): Cessna T188C · Choteau, MT · Accident · No injuries · Limited investigation · Final report · Jul 29, 2002 · N2802J · Substantial damage
  > Fuel exhaustion as a result of the pilot's inattention to fuel consumption (flight duration) which resulted in a total loss of power and subsequent hard landing.
- [NTSB NYC02LA151](https://openairdocs.org/ntsb/NYC02LA151.md): Piper PA-28-235 · Kelleys Island, OH · Accident · No injuries · Limited investigation · Final report · Jul 28, 2002 · N15442 · Substantial damage
  > The pilot-in-command's failure to obtain a proper touchdown point. A factor was the downdraft.
- [NTSB DCA02MA054](https://openairdocs.org/ntsb/DCA02MA054.md): Boeing 727-232 · Tallahassee, FL · Accident · Serious injuries · Class 1 · Major · Final report · Jul 26, 2002 · N497FE · Destroyed
  > The captain's and first officer's failure to establish and maintain a proper glidepath during the night visual approach to landing. Contributing to the accident was a combination of the captain's and first officer's fatigue, the captain's and first officer's…
- [NTSB CHI02LA209](https://openairdocs.org/ntsb/CHI02LA209.md): Beech S35 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Jul 24, 2002 · N6162G · Substantial damage
  > The proper glide path not obtained/maintained by the pilot. The approach lights were a contributing factor.
- [NTSB CHI02CA201](https://openairdocs.org/ntsb/CHI02CA201.md): Schweizer 1-26B · New Douglas, IL · Accident · Minor injuries · Data collection · Final report · Jul 20, 2002 · N111HK · Substantial damage
  > The probable cause of this accident was a failure to maintain the proper glide path and sufficient obstacle clearance while on final approach.
- [NTSB LAX02LA230](https://openairdocs.org/ntsb/LAX02LA230.md): Violet Dragonfly · Tucson, AZ · Accident · Serious injuries · Limited investigation · Final report · Jul 18, 2002 · N48RV · Destroyed
  > The pilot's loss of control resulting from his improperly planned approach and an inadvertent encounter with wake turbulence.
- [NTSB CHI02FA197](https://openairdocs.org/ntsb/CHI02FA197.md): Piper PA-60 · Columbus, IN · Accident · 1 fatal · Field investigation · Final report · Jul 18, 2002 · N158GA · Destroyed
  > The pilot's failure to maintain control of the airplane during a missed approach. Additional factors included the operator's inadequate oversight, the pilot's improper in-flight decision, conditions conducive to pilot fatigue, fog, and night.
- [NTSB FTW02LA208](https://openairdocs.org/ntsb/FTW02LA208.md): Cessna 210A · Sherman, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 2002 · N9466X · Substantial damage
  > fuel starvation. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB IAD02LA077](https://openairdocs.org/ntsb/IAD02LA077.md): Cessna 172 · Barre, VT · Accident · No injuries · Limited investigation · Final report · Jul 15, 2002 · N43860 · Substantial damage
  > The pilot's failure to maintain airspeed during a go-around attempt, which resulted in an inadvertent stall and a subsequent impact with trees. A factor was the pilot's delayed initiation of the go-around.
- [NTSB FTW02LA204](https://openairdocs.org/ntsb/FTW02LA204.md): Cessna 150H · Omaha, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 2002 · N22715 · Substantial damage
  > the pilot's failure to maintain adequate airspeed during the go-around resulting in an inadvertent stall. A contributing factor was haze.
- [NTSB FTW02CA206](https://openairdocs.org/ntsb/FTW02CA206.md): Aero Commander Callair A-9B · El Paso, TX · Accident · Serious injuries · Data collection · Final report · Jul 13, 2002 · N7791V · Substantial damage
  > the loss of control due to the encounter with the dust devil.
- [NTSB CHI02LA185](https://openairdocs.org/ntsb/CHI02LA185.md): Eskildsen P · Olathe, KS · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2002 · N2882 · Substantial damage
  > The pilot's improper planning and decision making during the emergency descent and landing. The total loss of engine power due to fuel exhaustion and the pilot's inadvertent stall were contributing factors.
- [NTSB SEA02FA124](https://openairdocs.org/ntsb/SEA02FA124.md): Unrein Productmatch 80 P51D · Battle Ground, WA · Accident · No injuries · Field investigation · Final report · Jul 6, 2002 · N51PL · Substantial damage
  > The pilot's failure to maintain the proper airspeed (80 mph) on final approach resulting in a bounced landing and a loss of control during an attempted go-around and ultimately the on ground collision with a residence. Contributing factors were the pilot's…

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

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

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