# NTSB investigations: Enroute

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 201 of 718 · 35,885 cases

## Cases, newest first

- [NTSB SEA97LA146](https://openairdocs.org/ntsb/SEA97LA146.md): Cessna 150H · Sweet Home, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1997 · N6599S · Substantial damage
  > The pilot's inadequate preflight preparation and his inadequate inflight planning which resulted in fuel exhaustion. A factor was lack of suitable terrain for a forced landing.
- [NTSB FTW97LA230](https://openairdocs.org/ntsb/FTW97LA230.md): Piper PA-32-300T · Del Norte, CO · Accident · No injuries · Limited investigation · Final report · Jun 18, 1997 · N8056Y · Substantial damage
  > The pilot's failure to attain proper runway alignment. Factors were his attention being diverted by a rough running engine because the fuel injectors were partially blocked.
- [NTSB NYC97LA114](https://openairdocs.org/ntsb/NYC97LA114.md): Luscombe 8F · New Town, PA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1997 · N1894B · Substantial damage
  > The pilot's improper fuel management, which resulted in an intermittent fuel supply, and a loss of engine power.
- [NTSB IAD97LA090](https://openairdocs.org/ntsb/IAD97LA090.md): Cessna 150 · Punxsutawney, PA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1997 · N8080S · Substantial damage
  > Pilot in command became disoriented and continued flight until fuel exhaustion. A factor to this accident is the pilot's inadequate in-flight planning/decision by over flying several airports during his disorientation.
- [NTSB FTW97IA222](https://openairdocs.org/ntsb/FTW97IA222.md): Aerospatiale ATR-72-12 · Dallas, TX · Incident · No injuries · Incident investigation · Final report · Jun 14, 1997 · N438AT · Minor damage
  > the engine fire during descent resulting from a loose, leaking fuel transfer tube due to improper installation and alignment of the transfer tube's retaining clip. Contributing factors were the inadequate design of the clamp, the failure of the operator to…
- [NTSB MIA97LA182](https://openairdocs.org/ntsb/MIA97LA182.md): Cessna 210F · Waycross, GA · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1997 · N1817F · Substantial damage
  > the private pilot's failure to maintain airspeed, while maneuvering in an attempt to reverse direction, which resulted in an inadvertent stall, and subsequent in-flight collision with terrain.
- [NTSB LAX97FA210](https://openairdocs.org/ntsb/LAX97FA210.md): Cessna 210K · Topanga, CA · Accident · 1 fatal · Field investigation · Final report · Jun 12, 1997 · N8276M · Destroyed
  > The pilot's failure to maintain proper VFR altitude over mountainous terrain obscured by clouds, and his intentional descent into instrument meteorological weather conditions.
- [NTSB FTW97LA218](https://openairdocs.org/ntsb/FTW97LA218.md): Cessna 152 · Bridgeport, TX · Accident · No injuries · Limited investigation · Final report · Jun 12, 1997 · N6182U · Substantial damage
  > The loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW97LA215](https://openairdocs.org/ntsb/FTW97LA215.md): Boeing 737-291A · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 1997 · N980UA · No damage
  > the sudden encounter with clear air turbulence.
- [NTSB SEA97FA133](https://openairdocs.org/ntsb/SEA97FA133.md): Cessna U206E · Red Lodge, MT · Accident · 3 fatal · Field investigation · Final report · Jun 9, 1997 · N206EC · Destroyed
  > The pilot-in-command's flight into known adverse weather and the subsequent overload and separation of the right wing-strut fuselage-to-strut attach point. Factors contributing were clouds and obscuration.
- [NTSB ATL97LA083](https://openairdocs.org/ntsb/ATL97LA083.md): Cessna 170A · Orangeburg, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 1997 · N2551V · Substantial damage
  > The pilot experienced a partial loss of engine power for undetermined reason. The pilot failed to maintain flying airspeed which resulted in a stall and then subsequent collision with the ground. A factor was, conditions were favorable for the formation of…
- [NTSB NYC97LA111](https://openairdocs.org/ntsb/NYC97LA111.md): Cessna 150K · Jay, ME · Accident · No injuries · Limited investigation · Final report · Jun 8, 1997 · N6218G · Substantial damage
  > the pilot's inaccurate fuel consumption calculations which resulted in fuel exhaustion.
- [NTSB CHI97LA162](https://openairdocs.org/ntsb/CHI97LA162.md): Boeing 737-300 · Valparaiso, IN · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 1997 · N321UA · No damage
  > a delay by the pilot of the other aircraft in turning on his mode C transponder.
- [NTSB NYC97LA109](https://openairdocs.org/ntsb/NYC97LA109.md): Piper PA-15 · Easton, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1997 · N4173H · Substantial damage
  > A failed aileron pulley which resulted in loss of tension and subsequent loss of aileron control. A factor was the failure of the mechanic to detect the failed aileron pulley during the annual inspection.
- [NTSB CHI97LA159](https://openairdocs.org/ntsb/CHI97LA159.md): Piper PA-25 · Sullivan, MO · Accident · 1 fatal · Limited investigation · Final report · Jun 7, 1997 · N6339Z · Substantial damage
  > the pilot's continued VFR flight into instrument meteorological conditions in an airplane not equipped for flight into IMC. Factors were: the pilot's inadequate preflight preparation, his inadequate evaluation of the weather, and fog.
- [NTSB ATL97LA084](https://openairdocs.org/ntsb/ATL97LA084.md): Piper PA-28-180 · Columbus, MS · Accident · No injuries · Limited investigation · Final report · Jun 5, 1997 · N7581W · Substantial damage
  > inadequate maintenance/inspection and subsequent corrosion of the air filter, which resulted in pieces of the air filter to block the intake to the carburetor and result in loss of engine power. A factor relating to the accident was: failure of maintenance…
- [NTSB ATL97LA081](https://openairdocs.org/ntsb/ATL97LA081.md): Cessna 172I · N. Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Jun 5, 1997 · N5124G · Substantial damage
  > The pilot's inadequate pre-flight inspection which resulted in fuel exhaustion and total loss of engine power. A factor was the soft terrain at the emergency landing site.
- [NTSB ANC97LA084](https://openairdocs.org/ntsb/ANC97LA084.md): Anderson Kitfox IV-1200 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Jun 5, 1997 · N85TA · Substantial damage
  > a seized crankshaft connecting rod bearing. A factor relating to the acciden was: the lack of suitable terrain for an emergency landing.
- [NTSB SEA97LA128](https://openairdocs.org/ntsb/SEA97LA128.md): Cessna 177B · Lake Powell, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1997 · N34680 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB MIA97FA179](https://openairdocs.org/ntsb/MIA97FA179.md): Piper J3C-65 · Asheboro, NC · Accident · 2 fatal · Field investigation · Final report · Jun 4, 1997 · N804DA · 2 aircraft · Substantial damage
  > failure of the pilots in both airplanes to see and/or avoid a collision with each other.
- [NTSB IAD97GA081](https://openairdocs.org/ntsb/IAD97GA081.md): Piper PA-18-150 · Harrisonburg, VA · Accident · Minor injuries · Final report · Jun 4, 1997 · N4310Z · Substantial damage
  > The pilot's preoccupation which led to fuel starvation of the selected tank and the subsequent forced landing.
- [NTSB FTW97LA210](https://openairdocs.org/ntsb/FTW97LA210.md): Beech 60 · Pueblo, CO · Accident · No injuries · Limited investigation · Final report · Jun 4, 1997 · N7396D · Substantial damage
  > loss of power in the right engine and failure of the right propeller to feather for undetermined reasons. A factor relating to the accident was: the pilot's failure or inability to align the airplane with the runway during the forced landing.
- [NTSB LAX97GA198](https://openairdocs.org/ntsb/LAX97GA198.md): Beech 95-B55 · San Carlos, AZ · Accident · 2 fatal · Final report · Jun 3, 1997 · N8KB · Destroyed
  > The pilot's failure to maintain an adequate airspeed while maneuvering, which led to an inadvertent stall/spin.
- [NTSB FTW97FA208](https://openairdocs.org/ntsb/FTW97FA208.md): Bell 206B · Intracoastl Cty, LA · Accident · 1 fatal · Field investigation · Final report · Jun 1, 1997 · N115AL · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid each other's aircraft. Factors were the failure of the pilot of N2773A to use the available traffic advisory service and the failure of the operator of N2773A to make the use of traffic advisory services a company…
- [NTSB LAX97LA197](https://openairdocs.org/ntsb/LAX97LA197.md): Rotorway 162F · Phoenix, AZ · Accident · 1 fatal · Limited investigation · Final report · May 31, 1997 · N176BT · Destroyed
  > the owner/builder incorrectly installed the tail rotor drive pulley mounting scissors, overtorqued the pivot belts, did not perform the required maintenance lubrication of the pivot belts, and failed to perform adequate visual maintenance checks of these…
- [NTSB NYC97LA149](https://openairdocs.org/ntsb/NYC97LA149.md): Piper PA-25-235 · Preston, MD · Accident · No injuries · Limited investigation · Final report · May 29, 1997 · N4497Y · Substantial damage
  > The pilot's improper flare during a precautionary landing, which resulted in a hard landing. A factor in the accident was the failure of the left magneto, which resulted in a partial loss of engine power.
- [NTSB NYC97LA101](https://openairdocs.org/ntsb/NYC97LA101.md): Hiller UH-12E · Granby, NY · Accident · Serious injuries · Limited investigation · Final report · May 29, 1997 · N4029S · Substantial damage
  > failure of the pilot/owner to replace the torsional clutch as specified by the manufacturer, and subsequent failure of the helicopter's clutch, which resulted in a forced landing (autorotation). A related factor was: the encounter with trees in the emergency…
- [NTSB ANC97LA079](https://openairdocs.org/ntsb/ANC97LA079.md): Piper J-5 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · May 29, 1997 · N31164 · Substantial damage
  > The loss of engine power for an undetermined reason, and the noncertificated pilot's decision to perform a go-around after a suitable landing site had been attained. A factor associated with the accident was the rough and uneven terrain.
- [NTSB FTW97LA206](https://openairdocs.org/ntsb/FTW97LA206.md): Piper PA-31-350 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · May 28, 1997 · N491SC · Substantial damage
  > unlatching of the left outboard engine cowling latches for undetermined reason(s), which allowed the left engine cowling to separate inflight and strike the vertical stabilizer.
- [NTSB FTW97LA198](https://openairdocs.org/ntsb/FTW97LA198.md): Piper PA-24-250 · Ward, AR · Accident · Serious injuries · Limited investigation · Final report · May 26, 1997 · N7967P · Substantial damage
  > The loss of engine power resulting from fuel starvation due to the pilot's mismanagement of available fuel. A factor was the lack of suitable terrain for a forced landing.
- [NTSB CHI97FA146](https://openairdocs.org/ntsb/CHI97FA146.md): Henry Barracuda · Antonia, MO · Accident · 2 fatal · Field investigation · Final report · May 26, 1997 · N5926 · Destroyed
  > inadvertent flight by the pilot into instrument meteorological conditions (IMC), spatial disorientation of the pilot, which led to his loss of aircraft control, and the pilot exceeding the design stress limits of the airplane, which led to an in-flight…
- [NTSB ATL97LA075](https://openairdocs.org/ntsb/ATL97LA075.md): Lockheed L-1011-385-3 · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · May 26, 1997 · N768DL · No damage
  > The failure of the flight attendants to maintain control of loose cabin service equipment, a salt shaker, that resulted in an uncorrected tripping hazard.
- [NTSB LAX97LA193](https://openairdocs.org/ntsb/LAX97LA193.md): Cessna 177 · Rota, Sark · Accident · Minor injuries · Limited investigation · Final report · May 25, 1997 · N53079 · Destroyed
  > the unauthorized use of automobile gasoline which led to the loss of engine power due to fuel vapor generation.
- [NTSB FTW97LA201](https://openairdocs.org/ntsb/FTW97LA201.md): Centrair 101C · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · May 25, 1997 · N991JB · Substantial damage
  > the pilot's improper planning/decison. Factors relating to the accident were: lack of thermal lift, which resulted in an off-airport landing, and the lack of suitable terrain for the landing.
- [NTSB SEA97FA120](https://openairdocs.org/ntsb/SEA97FA120.md): Piper PA-32-301T · Bend, OR · Accident · 2 fatal · Field investigation · Final report · May 24, 1997 · N83211 · Destroyed
  > Overload of the airframe structure. Thunderstorms and turbulence were factors.
- [NTSB CHI97LA145](https://openairdocs.org/ntsb/CHI97LA145.md): Ercoupe 415-G · Colusa, IL · Accident · Minor injuries · Limited investigation · Final report · May 24, 1997 · N94415 · Substantial damage
  > improper installation of the rocker arm assembly by maintenance personnel which led to the failure of the rocker arm. A factor was the soft terrain.
- [NTSB FTW97FA199](https://openairdocs.org/ntsb/FTW97FA199.md): Beech V35 · Shawnee, OK · Accident · 3 fatal · Field investigation · Final report · May 23, 1997 · N5459U · Destroyed
  > The pilot's inadvertent entry into a spin. A factor was the pilot's initiated flight into adverse weather.
- [NTSB MIA97LA174](https://openairdocs.org/ntsb/MIA97LA174.md): Convair CV-240 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · May 22, 1997 · N355T · Destroyed
  > failure of the aft master rod in the right engine, and failure of the front master rod bearing in the left engine, which resulted in a forced landing on a beach and a subsequent encounter with ocean water.
- [NTSB LAX97LA190](https://openairdocs.org/ntsb/LAX97LA190.md): Cessna 182 · Lamont, CA · Accident · Minor injuries · Limited investigation · Final report · May 22, 1997 · N6495A · Substantial damage
  > the pilot's failure to maintain adequate fuel for the flight.
- [NTSB ATL97LA074](https://openairdocs.org/ntsb/ATL97LA074.md): Piper PA-28-151 · Sophia, NC · Accident · No injuries · Limited investigation · Final report · May 22, 1997 · N8392C · Substantial damage
  > improper maintenance performed by an unknown person, which resulted in the reduction of airflow through the engine induction system and subsequent loss of engine power. A factor related to the accident was: failure of the pilot to attain a proper touchdown…
- [NTSB SEA97LA116](https://openairdocs.org/ntsb/SEA97LA116.md): Piper PA-28-140 · Hysham, MT · Accident · Minor injuries · Limited investigation · Final report · May 20, 1997 · N32142 · Substantial damage
  > A failure of an engine exhaust valve and the pilot's misjudgement of altitude/distance during an emergency landing at an airstrip.
- [NTSB CHI97LA142](https://openairdocs.org/ntsb/CHI97LA142.md): Mooney M20F · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · May 20, 1997 · N6950V · Substantial damage
  > binding of the number four exhaust valve, which resulted in a partial power loss. A factor was the ravine.
- [NTSB CHI97LA138](https://openairdocs.org/ntsb/CHI97LA138.md): Cessna 172 · Flushing, MI · Accident · Minor injuries · Limited investigation · Final report · May 20, 1997 · N8811Z · Substantial damage
  > was the pilot not maintaining sufficient altitude to clear obstructions. A factor associated with the accident was the pilot was inattentive to the airplane's altitude.
- [NTSB ATL97LA078](https://openairdocs.org/ntsb/ATL97LA078.md): Piper PA-31-350 · Sparta, TN · Accident · No injuries · Limited investigation · Final report · May 20, 1997 · N4105Q · Substantial damage
  > A fire in the left engine started by a leak in the fuel pump.
- [NTSB LAX97LA184](https://openairdocs.org/ntsb/LAX97LA184.md): Cessna 182G · Corona, CA · Accident · No injuries · Limited investigation · Final report · May 19, 1997 · N3165S · Substantial damage
  > fuel exhaustion due to the pilot's failure to perform either preflight or en route fuel consumption calculations. The pilot's decision to fly the aircraft without the required pilot's operating handbook (POH) on board was a factor in this accident.
- [NTSB LAX97LA185](https://openairdocs.org/ntsb/LAX97LA185.md): Bell 206B · Hilo, HI · Accident · 1 fatal · Limited investigation · Final report · May 18, 1997 · N98AW · Destroyed
  > the noninstrument-rated pilot flew into instrument conditions and failed to maintain adequate terrain clearance, while attempting to descend through an overcast. The adverse weather conditions and mountainous terrain were related factors.
- [NTSB LAX97LA183](https://openairdocs.org/ntsb/LAX97LA183.md): North American Navion NA-1 · Morristown, AZ · Accident · No injuries · Limited investigation · Final report · May 18, 1997 · N8551H · Substantial damage
  > failure to replace an old and abraded oil feedline hose which led to its rupture and the in-flight loss of engine oil pressure. A related factor was the pilot's misjudgment of distance-to-go versus altitude remaining during the subsequent forced landing.
- [NTSB MIA97LA168](https://openairdocs.org/ntsb/MIA97LA168.md): Bell 206L-1 · Orlando, FL · Accident · Serious injuries · Limited investigation · Final report · May 17, 1997 · N30SG · Substantial damage
  > The pilot misjudging the distance of the intended touchdown point resulting in his intentional decrease in the main rotor rpm to clear obstacles below. Contributing to the accident was the total loss of engine power due to undetermined reasons.
- [NTSB NYC97FA092](https://openairdocs.org/ntsb/NYC97FA092.md): Cessna T337G · North Dansville, NY · Accident · 1 fatal · Field investigation · Final report · May 16, 1997 · N1ZP · Destroyed
  > the pilot's improper decision to continue VFR flight into instrument meteorological conditions, and his failure to maintain clearance from rising/wooded terrain. The adverse weather conditions and rising wooded terrain were related factors.
- [NTSB FTW97LA192](https://openairdocs.org/ntsb/FTW97LA192.md): Piper PA-28R-210T · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · May 15, 1997 · N43761 · Substantial damage
  > the pilot's failure to know and follow the emergency procedure for extending the landing gear after loss of electrical power. Factors relating to the accident were: an inoperative alternator, inadequate maintenance by the operator, a depleted battery, and…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=202

## 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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=201

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