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

## Cases, newest first

- [NTSB LAX96LA060](https://openairdocs.org/ntsb/LAX96LA060.md): Laister LP-15 · Adelanto, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 1995 · N6LS · Destroyed
  > the pilot's selection of the wrong runway for the prevailing wind conditions, and his failure to maintain an adequate airspeed during the base-to-final turn.
- [NTSB CHI96LA047](https://openairdocs.org/ntsb/CHI96LA047.md): Cessna 310R · Michigan City, IN · Accident · No injuries · Limited investigation · Final report · Nov 28, 1995 · N5CX · Substantial damage
  > the pilot-in-command's selecting and maintaining an improper approach speed.
- [NTSB ANC96TA016](https://openairdocs.org/ntsb/ANC96TA016.md): Cessna 182H · Koyuk, AK · Accident · No injuries · Final report · Nov 28, 1995 · N1997X · Destroyed
  > The pilot's delayed application of carburetor heat. Factors in the accident were carburetor icing conditions and lack of suitable terrain for a forced landing.
- [NTSB LAX96LA056](https://openairdocs.org/ntsb/LAX96LA056.md): Monocoupe 90A · Salinas, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 1995 · N11768 · Substantial damage
  > the pilot's failure to properly recover from a slipping maneuver.
- [NTSB SEA96FA024](https://openairdocs.org/ntsb/SEA96FA024.md): Beech C24R · Bozeman, MT · Accident · 2 fatal · Field investigation · Final report · Nov 25, 1995 · N3729T · Substantial damage
  > failure of the pilot to follow the specified approach track (proper IFR procedure), and his associated failure to maintain altitude or clearance from mountainous terrain. Factors relating to the accident were: the pilot's failure to abide by the aircraft…
- [NTSB FTW96LA051](https://openairdocs.org/ntsb/FTW96LA051.md): Cessna 310J · Englewood, CO · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 1995 · N1147M · Substantial damage
  > failure of the pilot to feather the propeller on the inoperative engine in accordance with the emergency procedure. Factors relating to the accident were: loss of power in the left engine for undetermined reason(s), and rough/uneven terrain in the emergency…
- [NTSB MIA96LA026](https://openairdocs.org/ntsb/MIA96LA026.md): Piper PA-32-300 · Fort Lauderdale, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 1995 · N44CQ · Substantial damage
  > The pilots failure to follow the visual approach slope indicator and maintain a proper glidepath during approach. Contributing to the accident was pilot fatigue.
- [NTSB FTW96FA048](https://openairdocs.org/ntsb/FTW96FA048.md): Beech A35 · Hudson, CO · Accident · 1 fatal · Field investigation · Final report · Nov 21, 1995 · N8759A · Destroyed
  > The pilot's failure to maintain clearance. A factor was improper in-flight planning.
- [NTSB LAX96FA050](https://openairdocs.org/ntsb/LAX96FA050.md): Piper PA-32-300 · Fullerton, CA · Accident · 3 fatal · Field investigation · Final report · Nov 20, 1995 · N888JK · Destroyed
  > the pilot-in-command's failure to follow IFR procedures in that he descended below the minimum descent altitude and failed to execute a missed approach. Contributing to the accident was the pilot-in-command's self-induced pressure to get to work.
- [NTSB LAX96FA049](https://openairdocs.org/ntsb/LAX96FA049.md): Beech S35 · Oxnard, CA · Accident · 1 fatal · Field investigation · Final report · Nov 19, 1995 · N5795K · Destroyed
  > failure of the pilot to maintain adequate airspeed during a missed approach, after encountering an undetermined propeller malfunction, which resulted in a stall and collision with the terrain. Factors relating to the accident were: darkness, fog, and the…
- [NTSB BFO96LA023](https://openairdocs.org/ntsb/BFO96LA023.md): Beech A23-24 · New Carlisle, OH · Accident · No injuries · Limited investigation · Final report · Nov 19, 1995 · N4758J · Substantial damage
  > the pilot-in-command's failure to reach the proper touchdown point. Related factors were the pilot's failure to obtain/maintain the proper glidepath during the approach, and the rough/uneven terrain encountered after the airplane touched down short of the…
- [NTSB LAX96LA048](https://openairdocs.org/ntsb/LAX96LA048.md): Cessna 150H · Imperial, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 18, 1995 · N23102 · Destroyed
  > the student pilot's misreading of the altimeter while in the traffic pattern, which put the aircraft in dangerous proximity to the ground and obstructions. A factor in the accident was the pilot's inability to see the power pole due to sun glare as the…
- [NTSB CHI96FA034](https://openairdocs.org/ntsb/CHI96FA034.md): Ercoupe 415-C · Stafford, KS · Accident · 2 fatal · Field investigation · Final report · Nov 18, 1995 · N93726 · Destroyed
  > the pilot misjudged his distance and altitude and flew into transmission wires. A factor was the pilot's lack of recent night flying experience.
- [NTSB MIA96LA028](https://openairdocs.org/ntsb/MIA96LA028.md): Bell 47-D1 · Jasper, FL · Accident · No injuries · Limited investigation · Final report · Nov 15, 1995 · N4702S · Substantial damage
  > Improper maintenance and inspection of the carburetor system by maintenance personnel during the last annual inspection which resulted in a partial loss of engine power due to carburetor ice. Contributing to the accident were: the pilot's failure to perform…
- [NTSB NYC96LA025](https://openairdocs.org/ntsb/NYC96LA025.md): Cessna 150J · Norwood, MA · Accident · No injuries · Limited investigation · Final report · Nov 13, 1995 · N51197 · Substantial damage
  > the student's inadvertent use of the mixture control and the flight instructor's inadequate supervision during the final approach resulting in the loss of engine power due to fuel starvation and the subsequent nose over during the forced landing.
- [NTSB FTW96LA041](https://openairdocs.org/ntsb/FTW96LA041.md): Piper PA-28-201T · Keller, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1995 · N2141Z · Substantial damage
  > the inadequate visual lookout by the driver of the vehicle resulting in his obstructing the runway.
- [NTSB DCA96MA008](https://openairdocs.org/ntsb/DCA96MA008.md): McDonnell Douglas MD-83 · East Granby, CT · Accident · Minor injuries · Class 1 · Major · Final report · Nov 12, 1995 · N566AA · Substantial damage
  > the flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…
- [NTSB NYC96FA024](https://openairdocs.org/ntsb/NYC96FA024.md): Piper PA-23-250 · Ashville, NY · Accident · 1 fatal · Field investigation · Final report · Nov 11, 1995 · N62620 · Destroyed
  > the pilot's misjudgment of altitude and distance to the runway during an approach to land. Factors relating to the accident were: the night and adverse weather conditions.
- [NTSB CHI96LA031](https://openairdocs.org/ntsb/CHI96LA031.md): Beech 35 · Belleville, KS · Accident · No injuries · Limited investigation · Final report · Nov 10, 1995 · N9894R · Substantial damage
  > the pilot misjudging his approach to the runway. Factors relating to the accident were: the weather conditions, a sick passenger that diverted the pilot's attention, the snow covered terrain, and the pilot's decision not to execute the missed approach…
- [NTSB BFO96LA026](https://openairdocs.org/ntsb/BFO96LA026.md): Cessna 210E · Newport News, VA · Accident · No injuries · Limited investigation · Final report · Nov 10, 1995 · N2314F · Substantial damage
  > the failure of the engine-driven hydraulic pump drive shaft, the pilot's failure to properly engage the emergency landing gear handle.
- [NTSB LAX96FA042](https://openairdocs.org/ntsb/LAX96FA042.md): Beech S35 · Kneeland, CA · Accident · 4 fatal · Field investigation · Final report · Nov 9, 1995 · N8920M · Destroyed
  > failure of the pilot to correct a descending spiral and perform a missed approach, after becoming spatially disoriented and deviating from the planned ILS approach procedure. Factors relating to the accident were: darkness, and the pilot's excessive…
- [NTSB BFO96LA018](https://openairdocs.org/ntsb/BFO96LA018.md): Beech 35 · Phillipsburg, OH · Accident · No injuries · Limited investigation · Final report · Nov 5, 1995 · N5376E · Substantial damage
  > The flight instructor's (CFI's) inadequate supervision of the flying pilot, and the flying pilot's abrupt handling of the airplane during an attempted go-around. Factors relating to the accident were: the flying pilot's lack of familiarity with light piston…
- [NTSB LAX96LA039](https://openairdocs.org/ntsb/LAX96LA039.md): Cessna 402B · Redwood City, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1995 · N316HG · Substantial damage
  > the simultaneous total loss of engine power for undetermined reasons.
- [NTSB DCA96IA005](https://openairdocs.org/ntsb/DCA96IA005.md): Boeing B-737-500 · San Francisco, CA · Incident · No injuries · Incident investigation · Final report · Oct 29, 1995 · N904UA · No damage
  > The inadvertant stall for undertermined reasons.
- [NTSB NYC96LA020](https://openairdocs.org/ntsb/NYC96LA020.md): Cessna 414A · Grt Barrington, MA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1995 · N2UD · Substantial damage
  > the pilot's inadequate compensation for wind conditions, which resulted in an undershoot of the proper touchdown point for landing. Factors relating to the accident were: the unfavorable wind conditions and the exposed runway lip.
- [NTSB NYC96LA019](https://openairdocs.org/ntsb/NYC96LA019.md): Pezold Lancair IV-P · Somerset, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 27, 1995 · N960JP · Destroyed
  > failure of the fuel pump driveshaft, which resulted in fuel starvation and loss of engine power.
- [NTSB LAX96LA024](https://openairdocs.org/ntsb/LAX96LA024.md): Cessna 206 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Oct 27, 1995 · N2167F · Substantial damage
  > the failure of the pilot to maintain control of the aircraft while maneuvering by visual reference to the surface in IFR conditions. An additional factor was the pilot's failure to continue with the missed approach.
- [NTSB LAX96LA022](https://openairdocs.org/ntsb/LAX96LA022.md): Bellanca 7GCBC · Hemet, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 26, 1995 · N8649V · Destroyed
  > the pilot's failure to maintain adequate airspeed and the inadvertent stall while performing a short field landing.
- [NTSB SEA96FA012](https://openairdocs.org/ntsb/SEA96FA012.md): Beech A-36 · Newport, OR · Accident · Serious injuries · Field investigation · Final report · Oct 25, 1995 · N990EC · Substantial damage
  > the pilot's inadvertent shut-off of the fuel mixture control. Factors contributing to the accident were: the pilot's failure to perform adequate remedial action to regain engine power, his lack of familiarity with the accident airplane, and his failure to…
- [NTSB CHI96LA019](https://openairdocs.org/ntsb/CHI96LA019.md): Cessna 150M · Centralia, IL · Accident · No injuries · Limited investigation · Final report · Oct 25, 1995 · N63566 · Substantial damage
  > the pilot's improper use of flaps leading to the inadvertant stall.
- [NTSB CHI96FA017](https://openairdocs.org/ntsb/CHI96FA017.md): Cessna 421C · Battle Creek, MI · Accident · 1 fatal · Field investigation · Final report · Oct 22, 1995 · N421TV · Destroyed
  > the pilot's decision to fly in adverse weather (icing) conditions; the accumulation of airframe ice; and the pilot's failure to maintain adequate airspeed for the situation, which resulted in a loss of aircraft control. The icing condition was a related…
- [NTSB BFO96LA013](https://openairdocs.org/ntsb/BFO96LA013.md): Zenair CH 2000 · Saluda, VA · Accident · Serious injuries · Limited investigation · Final report · Oct 22, 1995 · N9151Z · Destroyed
  > the pilot's failure to maintain control of the airplane during an attempted go around.
- [NTSB MIA96TA014](https://openairdocs.org/ntsb/MIA96TA014.md): Cessna 182R · Redstone Arsena, AL · Accident · No injuries · Final report · Oct 21, 1995 · N3163E · Substantial damage
  > the pilot's poor inflight planning decision for not flying the scheduled time and electing to perform 3 additional takeoffs not planned during fuel consumption calculations. Contributing to the accident was the use of an inaccurate dipstick.
- [NTSB LAX96LA018](https://openairdocs.org/ntsb/LAX96LA018.md): Piper PA-22 · Battle Mountain, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 1995 · N1845A · Substantial damage
  > the pilot's failure to see and avoid utility transmission wires suspended across the final approach flight path.
- [NTSB ATL96LA009](https://openairdocs.org/ntsb/ATL96LA009.md): Cessna 150F · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Oct 21, 1995 · N7157F · Substantial damage
  > The pilot's inadequate preflight/planning which resulted in fuel exhaustion due to an inadequate fuel supply.
- [NTSB LAX96TA016](https://openairdocs.org/ntsb/LAX96TA016.md): Hughes OH-6A · Imperial, CA · Accident · No injuries · Final report · Oct 20, 1995 · N61865 · Substantial damage
  > The pilot's improper planning/decision and failure to ensure there was an adequate supply of fuel, which led to fuel exhaustion and a forced (autorotative) landing.
- [NTSB FTW96LA020](https://openairdocs.org/ntsb/FTW96LA020.md): Cessna 182P · Kingston, OK · Accident · No injuries · Limited investigation · Final report · Oct 20, 1995 · N9812E · Substantial damage
  > the pilot's inadequate compensation for the wind gusts. Factors were the gusts and the dark night conditions.
- [NTSB ATL96LA007](https://openairdocs.org/ntsb/ATL96LA007.md): Beech 23 · Newnan, GA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1995 · N2340J · Substantial damage
  > a loose fuel line fitting, which resulted in a fuel leak and premature emptying of the left fuel tank; failure of the pilot to follow the checklist (select the fullest fuel tank for landing); fuel starvation; and subsequent Loss of engine power, while on…
- [NTSB SEA96LA009](https://openairdocs.org/ntsb/SEA96LA009.md): Cessna 172N · Laurel, MT · Accident · No injuries · Limited investigation · Final report · Oct 19, 1995 · N6477D · Substantial damage
  > the student pilot's improper planning/decision, which resulted in inadequate altitude/clearance from hangar buildings and a subsequent emergency landing, while attempting to evade a flock of geese. The flock of geese was a related factor.
- [NTSB NYC96LA014](https://openairdocs.org/ntsb/NYC96LA014.md): Cessna 210C · Burlington, VT · Accident · No injuries · Limited investigation · Final report · Oct 19, 1995 · N36264 · Substantial damage
  > a fractured hydraulic line and loss of hydraulic fluid, which resulted in an inoperative landing gear extension system for both normal and emergency operation of the gear.
- [NTSB CHI96LA012](https://openairdocs.org/ntsb/CHI96LA012.md): Piper PA-24-260 · Wakeeney, KS · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1995 · N8866P · Substantial damage
  > Failure of the pilot to maintain sufficient altitude and airspeed on final approach to reach the proper touchdown point for landing. A factor relating to the accident was: the pilot's selection of the wrong runway for landing.
- [NTSB FTW96LA017](https://openairdocs.org/ntsb/FTW96LA017.md): Cessna 182A · Norman, OK · Accident · No injuries · Limited investigation · Final report · Oct 17, 1995 · N5060D · Substantial damage
  > the pilot's failure to refuel the airplane resulting in fuel exhaustion. A factor was the lack of suitable terrain for a forced landing.
- [NTSB BFO96LA011](https://openairdocs.org/ntsb/BFO96LA011.md): Cessna 150 · Dayton, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1995 · N5363Q · Substantial damage
  > the student pilot's poor in-flight planning and decision making during the approach to landing/go around. Related factors are his inadequate compensation for crosswind wind conditions.
- [NTSB CHI96LA010](https://openairdocs.org/ntsb/CHI96LA010.md): Crowley/Zenair Zodiac CH-600 · Columbia, MO · Accident · No injuries · Limited investigation · Final report · Oct 15, 1995 · N596WC · Substantial damage
  > A loss of elevator control as a result of the top elevator control cable working its way out of a fitting.
- [NTSB NYC96LA008](https://openairdocs.org/ntsb/NYC96LA008.md): Beech B24R · Bethpage, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1995 · N2544W · Substantial damage
  > the pilot's inadequate preflight and inflight planning/preparation, which resulted in fuel exhaustion and the loss of engine power.
- [NTSB FTW96LA016](https://openairdocs.org/ntsb/FTW96LA016.md): Cessna 182E · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Oct 12, 1995 · N3198Y · Substantial damage
  > a fatigue failure of the right main landing gear. Factors were the pilot's failure to attain the proper touchdown point and his inadequate compensation for the crosswind conditions.
- [NTSB NYC96LA006](https://openairdocs.org/ntsb/NYC96LA006.md): Cessna 172 · Honeoye Falls, NY · Accident · Serious injuries · Limited investigation · Final report · Oct 10, 1995 · N2792L · Substantial damage
  > the pilot's failure to establish a climb in that he failed to raise the flaps and failed to assure full power was applied during the go-around.
- [NTSB BFO96FA010](https://openairdocs.org/ntsb/BFO96FA010.md): Piper PA-28-140 · Bird-In-Hand, PA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1995 · N6360W · Substantial damage
  > the pilot's (PIC's) improper in-flight planning/decision concerning simulated instrument flight during the traffic pattern/descent; and failure of the safety pilot (other crewmember) to provide adequate visual lookout to see-and-avoid the obstruction.
- [NTSB SEA96LA004](https://openairdocs.org/ntsb/SEA96LA004.md): Vans RV-6T · North Plains, OR · Accident · No injuries · Limited investigation · Final report · Oct 7, 1995 · N96VA · Substantial damage
  > Fuel starvation due to the failure of the left tank fuel quantity sending unit which resulted in a false indication of fuel quantity. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI96FA002](https://openairdocs.org/ntsb/CHI96FA002.md): Beech H35 · Ozark, MO · Accident · 2 fatal · Field investigation · Final report · Oct 6, 1995 · N625T · Destroyed
  > the pilot's improper fuel management which resulted in fuel starvation, and his failure to maintain airspeed during the forced landing.

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

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

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