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

## Cases, newest first

- [NTSB LAX97FA334](https://openairdocs.org/ntsb/LAX97FA334.md): Navion G · Gabbs, NV · Accident · 2 fatal · Field investigation · Final report · Jul 23, 1997 · N2429T · Destroyed
  > The pilot's attempted visual flight into instrument meteorological conditions which resulted in his spatial disorientation and a loss of airplane control. A contributing factor was his overconfidence in his personal ability.
- [NTSB SEA97LA173](https://openairdocs.org/ntsb/SEA97LA173.md): Cessna 170 · Graham, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1997 · N4292V · Substantial damage
  > Inadequate aircraft preflight by the pilot-in-command, and water contamination in the fuel resulting in a loss of engine power. A factor was a power transmission line in the forced landing area.
- [NTSB CHI97LA222](https://openairdocs.org/ntsb/CHI97LA222.md): Morgan MINI-500 · Ava, MO · Accident · No injuries · Limited investigation · Final report · Jul 19, 1997 · N500XM · Substantial damage
  > Loss of engine power due to loss of engine cooling fluid. Related factors were maintenance service bulletin not complied with by the owner/pilot mechanic resulting in low output of the carburetor, and unsuitable terrain.
- [NTSB CHI97FA218](https://openairdocs.org/ntsb/CHI97FA218.md): Cessna 172P · Chicago, IL · Accident · 7 fatal · Field investigation · Final report · Jul 19, 1997 · N5323K · 2 aircraft · Destroyed
  > the pilots not maintaining visual separation between their airplanes. A factor in this accident was the pilot of the southbound airplane not reporting her position abeam the airport as directed by the ATC controller.
- [NTSB LAX97LA245](https://openairdocs.org/ntsb/LAX97LA245.md): Classic Waco YMF-5 · Pahoa, HI · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1997 · N553T · Substantial damage
  > Loss of the propeller retaining nut and associated hardware for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.
- [NTSB LAX97LA242](https://openairdocs.org/ntsb/LAX97LA242.md): Cessna 180K · Lake Mead, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1997 · N2914K · Substantial damage
  > Failure of the number 4 piston for undetermined reasons.
- [NTSB FTW97FA269](https://openairdocs.org/ntsb/FTW97FA269.md): Mooney M20C · Sarepta, LA · Accident · 1 fatal · Field investigation · Final report · Jul 15, 1997 · N777TU · Substantial damage
  > The pilot's impairment (drugs) resulting in his becoming disoriented and the ensuing loss of engine power due to fuel exhaustion. Factors were the lack of suitable terrain for the forced landing and the inaccurate navigation chart.
- [NTSB NYC97LA138](https://openairdocs.org/ntsb/NYC97LA138.md): Hughes 269B · Paducah, KY · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1997 · N9398F · Substantial damage
  > The failure of maintenance personnel to identify and correct the worn holes on the lower fuselage fairing and the failure of the flight instructor to maintain main rotor RPM during the autorotative landing. A contributing factor was the flight instructor's…
- [NTSB FTW97LA268](https://openairdocs.org/ntsb/FTW97LA268.md): Cessna 152 · Lufkin, TX · Accident · No injuries · Limited investigation · Final report · Jul 14, 1997 · N5238H · Substantial damage
  > The loss of engine power due to fuel exhaustion, which resulted from the student pilot becoming disoriented. A factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC97LA142](https://openairdocs.org/ntsb/NYC97LA142.md): Piper PA-28-181 · Jersey City, NJ · Accident · No injuries · Limited investigation · Final report · Jul 13, 1997 · N84611 · Substantial damage
  > The pilot's mismangement of the fuel supply, by which he failed to switched fuel tanks, which resulted in fuel starvation and the loss of engine power.
- [NTSB FTW97LA264](https://openairdocs.org/ntsb/FTW97LA264.md): Bell 47G-3B-1 · Crossett, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1997 · N83701 · Substantial damage
  > failure of maintenance personnel to perform an adequate inspection of the fuselage center frame and detect a fatigue fracture of a longeron tube on the upper left side of the center frame, which resulted in a disconnect of the tail rotor drive shaft from the…
- [NTSB LAX97LA240](https://openairdocs.org/ntsb/LAX97LA240.md): Cessna 152 · Gila Bend, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1997 · N4594B · Substantial damage
  > the pilot's failure to verify the fuel quantity prior to departure, and his failure to perform sufficient en route fuel consumption calculations during the cross-country flight.
- [NTSB CHI97FA208](https://openairdocs.org/ntsb/CHI97FA208.md): Cessna 150F · Gary, IN · Accident · 1 fatal · Field investigation · Final report · Jul 12, 1997 · N8197S · Destroyed
  > the pilot's not obtaining/maintaining airspeed which resulted in a stall.
- [NTSB ANC97LA102](https://openairdocs.org/ntsb/ANC97LA102.md): Piper PA-18 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Jul 12, 1997 · N1961P · Substantial damage
  > water contamination of the fuel supply. Soft, unsuitable terrain for the precautionary landing were factors.
- [NTSB SEA97LA166](https://openairdocs.org/ntsb/SEA97LA166.md): Cessna 172I · Naches, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 1997 · N35436 · Substantial damage
  > inadequate preflight by the pilot, and subsequent fuel exhaustion, which led to a forced landing and subsequent nose over of the aircraft. Related factors were: the FBO did not refuel the aircraft as requested, and soft terrain was encountered during the…
- [NTSB MIA97LA209](https://openairdocs.org/ntsb/MIA97LA209.md): Grumman American AA-1B · New Albany, MS · Accident · No injuries · Limited investigation · Final report · Jul 10, 1997 · N1493R · Substantial damage
  > a forced landing due to an undetermined complete loss of engine power, and subsequent impact with tress.
- [NTSB FTW97IA261](https://openairdocs.org/ntsb/FTW97IA261.md): Boeing 757-223 · Dickinson, ND · Incident · Minor injuries · Incident investigation · Final report · Jul 10, 1997 · N660AM · Minor damage
  > an encounter with unforecast convection induced turbulence (CIT). Related factors were: the flight crew's improper evaluation of the weather, and an inaccurate preflight weather briefing by company weather personnel.
- [NTSB CHI97LA209](https://openairdocs.org/ntsb/CHI97LA209.md): Piper PA-25-235A · O'Neil, NE · Accident · No injuries · Limited investigation · Final report · Jul 10, 1997 · N7050Z · Substantial damage
  > fuel exhaustion, due to the pilot's improper planning/decision and inadequate fuel consumption calculations. Factors relating to the accident were: the lack of an operable fuel indication system, and the high winds.
- [NTSB NYC97FA139](https://openairdocs.org/ntsb/NYC97FA139.md): Grumman American AA-5B · Jones Beach, NY · Accident · 3 fatal · Field investigation · Final report · Jul 8, 1997 · N28535 · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and his loss of aircraft control due to spatial disorientation, which resulted in an uncontrolled descent and collision with terrain (water). Related factors were: the adverse weather…
- [NTSB FTW97LA258](https://openairdocs.org/ntsb/FTW97LA258.md): Aero Commander 500-B · Dallas, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 1997 · N802TC · Substantial damage
  > The pilot-in-command's failure to follow emergency procedures to reduce drag and maintain best climb airspeed. Factors were the partial loss of engine power due to the cracks in the #1 and #4 cylinders as the result of an unapproved modification of their…
- [NTSB ANC97LA100](https://openairdocs.org/ntsb/ANC97LA100.md): Piper PA-18-160 · Cantwell, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 1997 · N3952Z · Substantial damage
  > The pilot's failure to maintain sufficient altitude to clear terrain. Factors were exceeding the airplane's maximum allowable gross weight, and downdrafts and turbulence associated with wind flowing across a mountain ridge.
- [NTSB CHI97LA197](https://openairdocs.org/ntsb/CHI97LA197.md): Piper PA-18 · Middleville, MI · Accident · 2 fatal · Limited investigation · Final report · Jul 6, 1997 · N183DP · Destroyed
  > fuel contamination, due to improper servicing of the aircraft; and failure of the pilot to maintain adequate airspeed, while maneuvering to land, which resulted in a inadvertent stall and collision with the terrain. The pilot's failure to ensure a proper…
- [NTSB CHI97FA196](https://openairdocs.org/ntsb/CHI97FA196.md): Mooney M20A · White Bear, MN · Accident · 2 fatal · Field investigation · Final report · Jul 6, 1997 · N8394E · Destroyed
  > pilot incapacitation due to a stroke.
- [NTSB ATL97LA097](https://openairdocs.org/ntsb/ATL97LA097.md): Ryan Navion · Cross City, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 6, 1997 · N91519 · Substantial damage
  > The pilot's inadequate preflight planning that resulted in loss of power in flight due to fuel exhaustion.
- [NTSB CHI97IA195](https://openairdocs.org/ntsb/CHI97IA195.md): McDonnell Douglas DC-9-30 · Flint, MI · Incident · No injuries · Incident investigation · Final report · Jul 5, 1997 · N963N · Minor damage
  > An electrical short in the wiring of the left wingtip oscillating position light auto transformer and a failure of the system circuit breaker.
- [NTSB ATL97LA096](https://openairdocs.org/ntsb/ATL97LA096.md): Piper PA-28-140 · Spruce Pine, NC · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1997 · N5807U · Substantial damage
  > The pilot's failure to maintain terrain clearance after turning the wrong way in a traffic pattern.
- [NTSB ANC97FA099](https://openairdocs.org/ntsb/ANC97FA099.md): de Havilland DHC-2 · Skwentna, AK · Accident · 4 fatal · Field investigation · Final report · Jul 5, 1997 · N5164G · Substantial damage
  > a loss of engine power due to the fatigue failure of the no.1 exhaust push rod. Factors contributing to the accident were: insufficient information on pushrod inspection and overhaul from the manufacturer, unsuitable terrain available for landing, and the…
- [NTSB LAX97LA232](https://openairdocs.org/ntsb/LAX97LA232.md): Cessna 182A · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1997 · N2011G · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate preflight planning/inspection and his failure to ensure that adequate fuel was onboard prior to departure.
- [NTSB IAD97LA097](https://openairdocs.org/ntsb/IAD97LA097.md): Grumman American AA-1B · Culpeper, VA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1997 · N9883L · Substantial damage
  > The pilot's inadequate preflight planning which fail to provide an adequate fuel supply
- [NTSB FTW97LA250](https://openairdocs.org/ntsb/FTW97LA250.md): Piper PA-28-140 · Ashdown, AR · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1997 · N1798J · Destroyed
  > The inadvertent stall/mush. A factor was the high density altitude.
- [NTSB IAD97FA095](https://openairdocs.org/ntsb/IAD97FA095.md): Piper PA-28R-180 · Penobscot, ME · Accident · 4 fatal · Field investigation · Final report · Jul 3, 1997 · N3896T · Destroyed
  > The pilot's flight into adverse weather conditions, which resulted in the loss of control. Factors relating to the accident were the fog and the pilot's lack of an instrument rating.
- [NTSB FTW97LA246](https://openairdocs.org/ntsb/FTW97LA246.md): Cessna T210M · Kerrville, TX · Accident · No injuries · Limited investigation · Final report · Jul 2, 1997 · N761FM · Substantial damage
  > The disintegration of the #1 cylinder piston resulting from a detonation/pre-ignition condition due to an unknown reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW97LA244](https://openairdocs.org/ntsb/FTW97LA244.md): Cessna 152 · Fort Worth, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1997 · N69073 · Substantial damage
  > fuel exhaustion, due to the pilot's failure to refuel before taking off on the remainder of the flight after making a precautionary landing. Factors related to the accident were: the pilot becoming lost and disoriented, and the lack of suitable terrain for a…
- [NTSB NYC97LA132](https://openairdocs.org/ntsb/NYC97LA132.md): Globe GC-1B · Yates, NY · Accident · No injuries · Limited investigation · Final report · Jun 30, 1997 · CFNXL · Substantial damage
  > The failure of the cylinder bolts, and the lack of suitable terrain for a forced landing.
- [NTSB NYC97LA131](https://openairdocs.org/ntsb/NYC97LA131.md): Cessna 172P · Tioga, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1997 · N97613 · Substantial damage
  > The pilot's improper inflight decision to land downwind with an inoperative airspeed indicator, and his improper landing flare.
- [NTSB FTW97LA243](https://openairdocs.org/ntsb/FTW97LA243.md): Cessna 152 · Gorman, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1997 · N6099L · Substantial damage
  > the student pilot's improper inflight planning/decision, and selection of unsuitable terrain for a precautionary landing. Factors relating to the accident were: a fluctuation in the electrical system, due to an undetermined reason, the student pilot's lack of…
- [NTSB CHI97LA190](https://openairdocs.org/ntsb/CHI97LA190.md): Dietrich Nieuport 12 · Byron, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 1997 · N169RD · Destroyed
  > The owner/pilot mechanic's inadequate inspection of the aircraft which led to contamination (other than water) of the fuel filter.
- [NTSB ANC97LA093](https://openairdocs.org/ntsb/ANC97LA093.md): Douglas DC-4 · Venetie, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1997 · N103 · Destroyed
  > A fire associated with the number 2 engine for undetermined reasons.
- [NTSB LAX97FA225](https://openairdocs.org/ntsb/LAX97FA225.md): Cessna R172K · Moreno Valley, CA · Accident · 2 fatal · Field investigation · Final report · Jun 28, 1997 · N7373K · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, and his attempt to climb through a low stratus cloud layer while in mountainous/hilly terrain. The pilot's failure to obtain a weather briefing, the weather, and the terrain were…
- [NTSB FTW97LA309](https://openairdocs.org/ntsb/FTW97LA309.md): Beech F33A · Monroe, LA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1997 · N234PM · Substantial damage
  > an electrical short, which burned a hole in a fuel line, and subsequent fire from the burning fuel.
- [NTSB FTW97LA236](https://openairdocs.org/ntsb/FTW97LA236.md): Piper PA-28-140 · Leadville, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1997 · N6306R · Substantial damage
  > an attempt by the pilot to fly the aircraft over mountainous terrain in a regime that was beyond its climb performance limit. High density altitude was a related factor.
- [NTSB SEA97LA152](https://openairdocs.org/ntsb/SEA97LA152.md): Cessna 172A · Ogden, UT · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1997 · N6844X · Substantial damage
  > The fracture of the no. 4 exhaust valve and subsequent loss of engine power. Factors contributing to the accident include a congested landing area, and rough terrain.
- [NTSB MIA97LA196](https://openairdocs.org/ntsb/MIA97LA196.md): Piper PA-28-140 · Sanford, FL · Accident · No injuries · Limited investigation · Final report · Jun 26, 1997 · N859KW · Substantial damage
  > Failure of the oil cooler radiator hose which resulted in oil exhaustion and subsequent engine failure. Contributing to the accident was the failure of the FAA to require a recurrent detailed examination and or require those hoses be life limited to prevent…
- [NTSB LAX97LA224](https://openairdocs.org/ntsb/LAX97LA224.md): Enstrom F-28-F · Riverside, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1997 · N99YC · Substantial damage
  > failure by unknown maintenance personnel to retorque the nuts on the retainer cover.
- [NTSB NYC97LA128](https://openairdocs.org/ntsb/NYC97LA128.md): Mooney M20C · Bellwood, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1997 · N6756N · Substantial damage
  > the total loss of engine power due to failed connecting rods.
- [NTSB MIA97LA194](https://openairdocs.org/ntsb/MIA97LA194.md): Piper PA-28-181 · Walls, MS · Accident · No injuries · Limited investigation · Final report · Jun 24, 1997 · N3692M · Substantial damage
  > The poor in-flight planning by the pilot for her failure to divert to an alternate airport after recognizing that a low fuel quantity state existed when preflight and in-flight planning revealed sufficient fuel for the flight. Contributing to the accident was…
- [NTSB NYC97LA127](https://openairdocs.org/ntsb/NYC97LA127.md): Eiriavion PIK-20E · Rochester, VT · Accident · No injuries · Limited investigation · Final report · Jun 23, 1997 · N1043G · Substantial damage
  > The pilot's inadequate evaluation of the weather that consisted of downdrafts and his inadequate start procedures that resulted in a forced landing and collision with trees.
- [NTSB LAX97LA222](https://openairdocs.org/ntsb/LAX97LA222.md): Piper PA-28R-201 · San Diego, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 1997 · N6471C · Substantial damage
  > the pilot-in-command's failure to maintain an adequate airspeed which resulted in a stall/mush.
- [NTSB LAX97FA286](https://openairdocs.org/ntsb/LAX97FA286.md): Cessna 172N · Cuyama, CA · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1997 · N6141D · Destroyed
  > undetermined.
- [NTSB ANC97LA088](https://openairdocs.org/ntsb/ANC97LA088.md): Cessna 206 · Prudhoe Bay, AK · Accident · No injuries · Limited investigation · Final report · Jun 21, 1997 · N756DJ · Substantial damage
  > The pilot's improper preflight inspection of the airplane and failure to properly secure the baggage door.

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

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

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