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

## Cases, newest first

- [NTSB ATL97LA144](https://openairdocs.org/ntsb/ATL97LA144.md): Piper PA-22-160 · Belleview, FL · Accident · No injuries · Limited investigation · Final report · Sep 28, 1997 · N3402Z · Substantial damage
  > the pilot's improper in-flight planning/decision, and his delay in initiating a go-around, which resulted in a hard touchdown, loss of directional control, and collision with objects (fence and trees).
- [NTSB NYC97LA188](https://openairdocs.org/ntsb/NYC97LA188.md): Jackman Pitts S-1S · Hammondsport, NY · Accident · No injuries · Limited investigation · Final report · Sep 27, 1997 · N4241Z · Substantial damage
  > the pilot's improper flare.
- [NTSB CHI97LA304](https://openairdocs.org/ntsb/CHI97LA304.md): Luscombe 8A · Brooklyn, MI · Accident · 1 fatal · Limited investigation · Final report · Sep 27, 1997 · N1269K · Destroyed
  > failure of the pilot to see-and-avoid the transmission wires (inadequate visual lookout, and failing to maintain sufficient altitude and clearance from the obstruction).
- [NTSB ATL97LA141](https://openairdocs.org/ntsb/ATL97LA141.md): Tomlinson Pober Super ACE · Lebanon, TN · Accident · No injuries · Limited investigation · Final report · Sep 27, 1997 · N54JT · Substantial damage
  > The pilot's failure to follow normal checklist procedures that resulted in fuel starvation.
- [NTSB SEA97IA217](https://openairdocs.org/ntsb/SEA97IA217.md): Piper PA-23-250 · Soda Springs, ID · Incident · No injuries · Incident investigation · Final report · Sep 25, 1997 · CGBUA · Minor damage
  > The pilot's failure to see-and-avoid the truck. Related factors included: a truck, insufficient runway obstruction information provided in the Airport/Facility Directory by the FAA, and VASI glide path angle setting (by local airport personnel) which provided…
- [NTSB SEA97FA215](https://openairdocs.org/ntsb/SEA97FA215.md): Cessna 172M · Bremerton, WA · Accident · 3 fatal · Field investigation · Final report · Sep 24, 1997 · N6756H · Substantial damage
  > The pilot's misjudgment of distance and altitude from the runway, and his subsequent failure to maintain clearance from the terrain. Factors contributing to the accident were dark night conditions, the pilot's improper decision to conduct the flight at night,…
- [NTSB NYC97LA192](https://openairdocs.org/ntsb/NYC97LA192.md): Cessna 150G · Forest, VA · Accident · No injuries · Limited investigation · Final report · Sep 24, 1997 · N4748X · Substantial damage
  > the pilot's movement of the mixture control to the idle cut-off position, during an approach to land, which resulted in a loss of engine power and a forced landing before reaching the runway.
- [NTSB CHI97LA299](https://openairdocs.org/ntsb/CHI97LA299.md): Beech C23 · Champaign, IL · Accident · No injuries · Limited investigation · Final report · Sep 24, 1997 · N1851Z · Substantial damage
  > an undetermined engine and/or oil system failure that resulted in an oil leak and subsequent loss of engine power. A related factor was: high vegetation (corn crop) in the emergency landing area.
- [NTSB FTW97LA355](https://openairdocs.org/ntsb/FTW97LA355.md): American General AG5B · Texarkana, AR · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 1997 · N1194L · Substantial damage
  > the pilot's improper planning/decision, by failing to ensure timely refueling of the airplane, which resulted in fuel exhaustion, loss of engine power, and a forced landing.
- [NTSB CHI97LA307](https://openairdocs.org/ntsb/CHI97LA307.md): Cessna 182 · Dassel, MN · Accident · No injuries · Limited investigation · Final report · Sep 22, 1997 · N7331Q · Substantial damage
  > the pilot's failure to attain the proper touchdown point on the airstrip. Factors associated with the accident were the high vegetation which skewed the pilot's visual perception of threshold, and the embankment which the airplane contacted.
- [NTSB ATL97FA135](https://openairdocs.org/ntsb/ATL97FA135.md): Cessna 182G · Lexington, TN · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1997 · N3725U · Substantial damage
  > Improper planning/decision by the pilot, which led to the fuel exhaustion, loss of engine power, and a forced landing. Trees in the emergency landing area were a related factor.
- [NTSB IAD97LA121](https://openairdocs.org/ntsb/IAD97LA121.md): Pohlman/Pohlman Rotorway Exec 90 · Westminster, MD · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1997 · N94CJ · Substantial damage
  > The loss of power due to carburetor icing. A factor to this accident was the carburetor heat was not accessible from within the cockpit.
- [NTSB NYC97LA183](https://openairdocs.org/ntsb/NYC97LA183.md): Cessna 402C · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1997 · N6879Y · Substantial damage
  > the pilot's delayed decision to perform a go-around (missed approach). Related factors were: darkness, low ceiling, fog, and disorientation of the flight crew, while making the approach in conditions of limited visibility.
- [NTSB CHI97LA295](https://openairdocs.org/ntsb/CHI97LA295.md): Piper PA-38-112 · Greenwood, IN · Accident · No injuries · Limited investigation · Final report · Sep 17, 1997 · N43DR · Substantial damage
  > the student pilot's failure to maintain adequate airspeed during the go-around, which resulted in an inadvertant stall. A factor related to the accident was the raising of flaps.
- [NTSB ANC97LA160](https://openairdocs.org/ntsb/ANC97LA160.md): Piper PA-11 · Gulkana, AK · Accident · No injuries · Limited investigation · Final report · Sep 14, 1997 · N4116D · Substantial damage
  > The pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control after touchdown. A factor associated with the accident was the gusty wind conditions.
- [NTSB FTW97LA346](https://openairdocs.org/ntsb/FTW97LA346.md): Reilly Thorp T-18 · Wagoner, OK · Accident · 1 fatal · Limited investigation · Final report · Sep 13, 1997 · N16LE · Destroyed
  > the pilot's failure to maintain airspeed.
- [NTSB LAX97LA324](https://openairdocs.org/ntsb/LAX97LA324.md): Piper PA28R-180 · Reno, NV · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 1997 · N69645 · Substantial damage
  > The pilot's failure to maintain an adequate airspeed during a go-around, which resulted in an inadvertent stall/mush. Factors in the accident were: the pilot's lack of qualification in the aircraft; the FAA pilot certification system's failure to transfer the…
- [NTSB LAX97LA322](https://openairdocs.org/ntsb/LAX97LA322.md): Cessna 150L · Hilo, HI · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 1997 · N18503 · Substantial damage
  > failure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.
- [NTSB SEA97LA211](https://openairdocs.org/ntsb/SEA97LA211.md): Piper PA-18-150 · Mackay, ID · Accident · No injuries · Limited investigation · Final report · Sep 9, 1997 · N91019 · Substantial damage
  > The pilot misjudged the distance/altitude while on final approach.
- [NTSB LAX97LA320](https://openairdocs.org/ntsb/LAX97LA320.md): Bell 206B · Minden, NV · Accident · Minor injuries · Limited investigation · Final report · Sep 9, 1997 · N90115 · Substantial damage
  > A hard landing due to the failure of the pilot to adequately compensate for the wind direction and velocity on initiating his approach to the landing area, resulting in a loss of tail rotor authority.
- [NTSB LAX97LA318](https://openairdocs.org/ntsb/LAX97LA318.md): Beech A23A · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Sep 8, 1997 · N2339W · Destroyed
  > the student pilot's improper recovery from a bounced landing, and failure to maintain adequate airspeed during an attempted go-around, which resulted in a stall and impact with the terrain (runway).
- [NTSB MIA97LA241](https://openairdocs.org/ntsb/MIA97LA241.md): Cessna 182B · Paris, TN · Accident · No injuries · Limited investigation · Final report · Sep 7, 1997 · N2794G · Substantial damage
  > Temporary loss of engine power for undetermined reasons res ulting in a forced landing on unsuitable terrain.
- [NTSB MIA97LA240](https://openairdocs.org/ntsb/MIA97LA240.md): Diamond Aircraft Industries DA 20-A1 · Concord, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1997 · N560SS · Substantial damage
  > The failure of the pilot to latch the canopy closed prior to takeoff. This resulted in the canopying opening while on approach to land and the pilot was unable to maintain altitude due to the excessive drag.
- [NTSB FTW97LA359](https://openairdocs.org/ntsb/FTW97LA359.md): Shutt Marquart MA-5 · Pecos, TX · Accident · No injuries · Limited investigation · Final report · Sep 7, 1997 · N82ND · Substantial damage
  > The pilot's inadequate compensation for the crosswind during a forced landing following a loss of engine power due to fuel exhaustion for an undetermined reason. Factors were the gusty winds and rough/uneven terrain.
- [NTSB NYC97LA179](https://openairdocs.org/ntsb/NYC97LA179.md): Piper PA-28R-200 · West Chester, PA · Accident · No injuries · Limited investigation · Final report · Sep 6, 1997 · N4982S · Substantial damage
  > the pilot's misjudgment of altitude and distance to the runway, which resulted in an undershoot and failure to reach the proper touchdown point. Rising terrain at the approach end of the runway was a related factor.
- [NTSB ATL97LA133](https://openairdocs.org/ntsb/ATL97LA133.md): Cessna 150F · Kenly, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1997 · N6898F · Substantial damage
  > The pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.
- [NTSB LAX97LA310](https://openairdocs.org/ntsb/LAX97LA310.md): Bingelis Falco F.8L · Watsonville, CA · Accident · No injuries · Limited investigation · Final report · Sep 4, 1997 · N84TX · Substantial damage
  > the pilot's misjudgment of distance and speed on final approach, leading to a landing undershoot.
- [NTSB LAX97LA308](https://openairdocs.org/ntsb/LAX97LA308.md): Taylorcraft BC-12D · Gerlach, NV · Accident · No injuries · Limited investigation · Final report · Aug 31, 1997 · N4459P · Substantial damage
  > The pilot's failure to maintain an adequate airspeed while attempting a right slip, which resulted in an inadvertent stall.
- [NTSB IAD97LA116](https://openairdocs.org/ntsb/IAD97LA116.md): Beech Musketeer 23 · Wauseon, OH · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1997 · N2372L · Substantial damage
  > The pilot's fuel mismanagement by his failure to switch fuel tank positions, which resulted in the fuel starvation and the loss of engine power.
- [NTSB CHI97LA277](https://openairdocs.org/ntsb/CHI97LA277.md): Hughes 269A · Council Bluffs, IA · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1997 · N7058T · Destroyed
  > inadequate supervision by the designated examiner by failing to ensure a timely autorotation recovery was initiated. A related factor was: the student pilot allowed the rotor rpm to diminish after the examiner simulated a loss of engine power.
- [NTSB CHI97LA276](https://openairdocs.org/ntsb/CHI97LA276.md): Cessna 150J · Romeo, MI · Accident · No injuries · Limited investigation · Final report · Aug 31, 1997 · N60200 · Substantial damage
  > the pilot's improper use of carburetor heat, which resulted in carburetor ice and loss of engine power. Factors relating to the accident were: carburetor icing conditions, and the crop (corn) in the emergency landing area.
- [NTSB ATL97LA128](https://openairdocs.org/ntsb/ATL97LA128.md): Cessna 172M · Lawrenceville, GA · Accident · No injuries · Limited investigation · Final report · Aug 31, 1997 · N9625V · Substantial damage
  > The student pilot's improper go-around technique that resulted in an inadvertent stall. A factor was a premature flare for landing.
- [NTSB NYC97FA173](https://openairdocs.org/ntsb/NYC97FA173.md): Piper PA-34-200T · Hancock, MA · Accident · 1 fatal · Field investigation · Final report · Aug 29, 1997 · N40AB · Destroyed
  > The pilot's failure to maintain adequate terrain clearance and the proper altitude. Contributing was mountainous terrain.
- [NTSB LAX97LA298](https://openairdocs.org/ntsb/LAX97LA298.md): Beech H35 · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Aug 22, 1997 · N4689D · Substantial damage
  > The pilot's mismanagement of the fuel supply which resulted in fuel starvation. A contributing factor was inoperative fuel gauges.
- [NTSB CHI97LA271](https://openairdocs.org/ntsb/CHI97LA271.md): Schweizer SGS 1-26E · Zionsville, IN · Accident · Serious injuries · Limited investigation · Final report · Aug 22, 1997 · N600JP · Destroyed
  > failure of the pilot to maintain adequate airspeed, which resulted in a stall and subsequent spin. A factor associated with the accident was the pilot's lack of experience in this make and model of glider.
- [NTSB CHI97LA266](https://openairdocs.org/ntsb/CHI97LA266.md): Swearingen SA226TC · Des Moines, IA · Accident · Minor injuries · Limited investigation · Final report · Aug 20, 1997 · N224AM · Substantial damage
  > the pilot's improper in-flight planning/decision and failure to perform the emergency procedure for shut-down of the right engine. Factors relating to the accident were: the power lever cable became disconnected from the fuel control unit, due to improper…
- [NTSB CHI97LA264](https://openairdocs.org/ntsb/CHI97LA264.md): Piper PA-38-112 · Glenwood, MN · Accident · No injuries · Limited investigation · Final report · Aug 17, 1997 · N23236 · Substantial damage
  > failure of the student pilot to maintain the correct airspeed for a go-around maneuver, which resulted in a stall/mush and collision with terrain.
- [NTSB NYC97LA165](https://openairdocs.org/ntsb/NYC97LA165.md): Dassault DA-20 · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Aug 14, 1997 · N227R · Substantial damage
  > The pilot misjudged distance and altitude to the runway after transition from an instrument approach to a visual approach. Factors related to the accident were the rain, and uphill runway conditions at a dark night.
- [NTSB MIA97FA232](https://openairdocs.org/ntsb/MIA97FA232.md): Beech 200 · Dalton, GA · Accident · 1 fatal · Field investigation · Final report · Aug 14, 1997 · N74EJ · Substantial damage
  > the pilot's improper IFR procedure, by failing to maintain the minimum descent altitude (MDA) during the ILS localizer approach, until the runway environment was in sight, which resulted in a collision with terrain short of the runway. Factors relating to the…
- [NTSB LAX97LA283](https://openairdocs.org/ntsb/LAX97LA283.md): Cessna 195 · Santa Ana, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 11, 1997 · N9328A · Substantial damage
  > Water contamination in the fuel system due to the failure of the mechanic who performed the last annual inspection to adequately comply with the AD which required inspection of the fuel tank filler area for proper sealing, and the pilot's inadequate preflight…
- [NTSB ATL97LA122](https://openairdocs.org/ntsb/ATL97LA122.md): Zenair 701 · Spruce Creek, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 11, 1997 · N105RC · Substantial damage
  > The failure of the engine for undetermined reasons, while maneuvering close to the ground. Factors included the soft terrain and the conditions favorable for carburetor icing.
- [NTSB SEA97LA184](https://openairdocs.org/ntsb/SEA97LA184.md): Mooney M20C · Bountiful, UT · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 1997 · N9666M · Substantial damage
  > The pilot's inadequate fuel management which resulted in fuel starvation.
- [NTSB NYC97LA162](https://openairdocs.org/ntsb/NYC97LA162.md): Simpson Avid Flyer · Westerly, RI · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1997 · N7156X · Substantial damage
  > The pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.
- [NTSB FTW97LA303](https://openairdocs.org/ntsb/FTW97LA303.md): Cessna 150H · Los Alamos, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 10, 1997 · N22286 · Substantial damage
  > The fuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL97LA119](https://openairdocs.org/ntsb/ATL97LA119.md): Cessna 152 · Macon, GA · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1997 · N757WL · Substantial damage
  > The loss of control of the airplane due to the pilot's improperly planned approach and failure to maintain adequate airspeed.
- [NTSB ATL97LA117](https://openairdocs.org/ntsb/ATL97LA117.md): Cessna 172P · Rockhill, SC · Accident · Minor injuries · Limited investigation · Final report · Aug 8, 1997 · N66098 · Substantial damage
  > The pilot's failure to plan and have adequate fuel for the flight.
- [NTSB ATL97FA113](https://openairdocs.org/ntsb/ATL97FA113.md): Pilatus BN-2 Islander · Fajardo, PR · Accident · Serious injuries · Field investigation · Final report · Aug 7, 1997 · N26JA · 2 aircraft · Substantial damage
  > The pilot's failure to maintain adequate visual lookout.
- [NTSB DCA97MA058](https://openairdocs.org/ntsb/DCA97MA058.md): Boeing 747-300 · Nimitz Hill · Accident · 228 fatal · Class 1 · Major · Final report · Aug 6, 1997 · H7468 · Destroyed
  > the captain's failure to adequately brief and execute the nonprecision approach and the first officer's and flight engineer's failure to effectively monitor and cross-check the captain's execution of the approach. Contributing to these failures were the…
- [NTSB MIA97LA227](https://openairdocs.org/ntsb/MIA97LA227.md): Beech V35B · Tullahoma, TN · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 1997 · N9236Q · Substantial damage
  > the pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation, a forced landing, and impact with a tree.
- [NTSB LAX97FA272](https://openairdocs.org/ntsb/LAX97FA272.md): Piper PA-28RT-201 · Hesperia, CA · Accident · 3 fatal · Field investigation · Final report · Aug 5, 1997 · N8227Q · Destroyed
  > failure of the pilot to see-and-avoid high voltage power lines, while coping with a lack of engine power during a go-around in a high density altitude condition. Factors relating to the accident were: high density altitude that resulted in a normal reduction…

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

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

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