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

## Cases, newest first

- [NTSB LAX03FA008](https://openairdocs.org/ntsb/LAX03FA008.md): Cessna 150F · Julian, CA · Accident · 1 fatal · Field investigation · Final report · Oct 14, 2002 · N8735G · Destroyed
  > an in-flight loss of control for undetermined reasons.
- [NTSB DEN03LA006](https://openairdocs.org/ntsb/DEN03LA006.md): Mooney M20B · Loa, UT · Accident · No injuries · Limited investigation · Final report · Oct 14, 2002 · N74530 · Substantial damage
  > the pilot's inadvertent placement of the fuel selector position in the off position. A contributing factor was the pilot's lack of familiarity with the aircraft.
- [NTSB IAD03LA006](https://openairdocs.org/ntsb/IAD03LA006.md): Cessna 177RG · South Vienna, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 13, 2002 · N7510V · Substantial damage
  > The improper installation of the single drive, dual magneto, which resulted in its separation from the engine and a subsequent total loss of engine power. Factors included the crops in the forced landing field, and the night lighting conditions.
- [NTSB SEA03LA002](https://openairdocs.org/ntsb/SEA03LA002.md): Gentry Vari-Eze · Shine, WA · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 2002 · N24BG · Substantial damage
  > Loss of engine power for undetermined reasons during cruise. Trees and objects near the roadway were factors.
- [NTSB LAX03FA005](https://openairdocs.org/ntsb/LAX03FA005.md): Grumman AA-5A · Phoenix, AZ · Accident · 1 fatal · Field investigation · Final report · Oct 12, 2002 · N9566U · Destroyed
  > failure of the lubricating system resulting in a total loss of engine power and an off airport forced landing.
- [NTSB IAD03FA004](https://openairdocs.org/ntsb/IAD03FA004.md): Cessna 182S · Brownville Jct, ME · Accident · 1 fatal · Field investigation · Final report · Oct 12, 2002 · N100TY · Destroyed
  > The pilot's failure to maintain sufficient altitude while flying in mountainous terrain at night. A factor was the night lighting conditions.
- [NTSB FTW03LA011](https://openairdocs.org/ntsb/FTW03LA011.md): Brantly Helicopter B-2B · Vinson, OK · Accident · No injuries · Limited investigation · Final report · Oct 12, 2002 · N9008H · Substantial damage
  > The pilot's inadvertent flight into adverse weather conditions during cruise resulting in his failure to maintain control of the helicopter, and his failure to maintain rotor rpm. Contributing factors relating to the accident included the frontal activity…
- [NTSB ANC03IA001](https://openairdocs.org/ntsb/ANC03IA001.md): Boeing 747-400 · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Oct 10, 2002 · N661US · No damage
  > The fatigue fracture of the lower rudder power control module manifold, which resulted in a lower rudder hardover.
- [NTSB ATL03FA002](https://openairdocs.org/ntsb/ATL03FA002.md): Beech K35 · Jellico, TN · Accident · 1 fatal · Field investigation · Final report · Oct 9, 2002 · N5350E · Destroyed
  > The pilot's incapacitation in flight due to a heart attack resulting in an in-flight loss of control, and collision with terrain. A factor was the pilot acting as a pilot-in-command with a known medical grounding condition.
- [NTSB CHI03LA006](https://openairdocs.org/ntsb/CHI03LA006.md): Wolf Rotorway Exec-162F · Gregory, MI · Accident · No injuries · Limited investigation · Final report · Oct 7, 2002 · N1955Z · Substantial damage
  > Failure of the secondary drive shaft, which resulted in a complete loss of power to the main rotor, and a high forward airspeed on touchdown, causing the helicopter to flip forward.
- [NTSB FTW03LA005](https://openairdocs.org/ntsb/FTW03LA005.md): Cirrus Design SR-22 · Lewisville, TX · Accident · No injuries · Limited investigation · Final report · Oct 3, 2002 · N1223S · Substantial damage
  > The improper reinstallation of the left aileron by maintenance personnel. A contributing factor was the non-suitable terrain for the forced landing.
- [NTSB CHI03FA003](https://openairdocs.org/ntsb/CHI03FA003.md): Piper PA-18A · Garden City, KS · Accident · 1 fatal · Field investigation · Final report · Oct 2, 2002 · N3279Z · Destroyed
  > The inadequate preflight planning/preparation and visual flight rules flight into instrument meteorological conditions by the pilot. The clouds, mist, and night conditions were contributing factors.
- [NTSB SEA02LA187](https://openairdocs.org/ntsb/SEA02LA187.md): Mooney M20J · Oakley, ID · Accident · No injuries · Limited investigation · Final report · Sep 30, 2002 · N4232H · Substantial damage
  > Failure (fracture) of the two number four piston compression rings, leading to the erosion of a section of the piston sidewall, resulting in the exhaustion of the engine's oil supply during cruise flight, followed by a forced landing on a country road.…
- [NTSB SEA02FA185](https://openairdocs.org/ntsb/SEA02FA185.md): Cessna 172S · Medford, OR · Accident · 2 fatal · Field investigation · Final report · Sep 30, 2002 · N514SP · Substantial damage
  > Terrain clearance was not maintained during cruise flight. Dark night and mountainous terrain were factors.
- [NTSB ANC02LA127](https://openairdocs.org/ntsb/ANC02LA127.md): Piper PA-18 · Ekwok, AK · Accident · No injuries · Limited investigation · Final report · Sep 30, 2002 · N723C · Substantial damage
  > A partial separation of one propeller blade during cruise flight.
- [NTSB SEA02LA184](https://openairdocs.org/ntsb/SEA02LA184.md): Cessna 182 · Estacada, OR · Accident · No injuries · Limited investigation · Final report · Sep 29, 2002 · N5337B · Destroyed
  > The entanglement of an inadvertently opened skydiver's parachute in the aircraft’s elevator and rudder just after a group of four skydivers positioned themselves on the aircraft's external jump platform prior to a jump.
- [NTSB LAX02LA298](https://openairdocs.org/ntsb/LAX02LA298.md): Cessna 182 · Lucerne Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 2002 · N6412A · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel consumption calculations.
- [NTSB CHI02LA297](https://openairdocs.org/ntsb/CHI02LA297.md): Jonas Nieuport · Creve Coeur, MO · Accident · No injuries · Limited investigation · Final report · Sep 28, 2002 · N678DJ · Substantial damage
  > The installation of improper carburetor jets resulting in an improper fuel mixture and loss of engine power.
- [NTSB LAX02LA296](https://openairdocs.org/ntsb/LAX02LA296.md): Whetzel Thorpe T-18 · Valley Center, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 2002 · N60LW · Substantial damage
  > the pilot's inadequate preflight planning/preparation by not verifying the fuel supply, and his inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power. A factor in the accident was the pilot's decision to initiate…
- [NTSB LAX02LA295](https://openairdocs.org/ntsb/LAX02LA295.md): Bell 206L-1 · North Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Sep 25, 2002 · N601GM · Substantial damage
  > the pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.
- [NTSB NYC02LA195](https://openairdocs.org/ntsb/NYC02LA195.md): Paiement Rans S-12 · Mercer, ME · Accident · 1 fatal · Limited investigation · Final report · Sep 24, 2002 · N7011Y · Substantial damage
  > The pilot's improper in-flight decision, and failure to maintain adequate clearance, which resulted in a collision with a wire during a low altitude flight.
- [NTSB MIA02FA173](https://openairdocs.org/ntsb/MIA02FA173.md): Piper PA-32R-301T · Yeehaw Junction, FL · Accident · 2 fatal · Field investigation · Final report · Sep 24, 2002 · N106JG · Destroyed
  > the pilot's continued flight into known severe weather, resulting in an in-flight separation of the right wing, vertical stabilizer and the stabilator. Factors in this accident were heavy thunderstorm, and failure of the FAA controllers to provide the pilot…
- [NTSB FTW02FA262](https://openairdocs.org/ntsb/FTW02FA262.md): Piper PA-28R-200 · Chromo, CO · Accident · 2 fatal · Field investigation · Final report · Sep 24, 2002 · N6227J · Destroyed
  > The flight instructor's failure to maintain clearance with the mountainous terrain during the cross-country flight. A contributing factor was the dark night light conditions.
- [NTSB ATL02LA176](https://openairdocs.org/ntsb/ATL02LA176.md): Cessna 152 · Spring City, TN · Accident · No injuries · Limited investigation · Final report · Sep 24, 2002 · N46656 · Substantial damage
  > The flight instructor's failure to follow standard training procedures that resulted in the loss of engine power during a simulated loss of engine power.
- [NTSB LAX02LA292](https://openairdocs.org/ntsb/LAX02LA292.md): Cessna 172RG · Del Mar, CA · Accident · No injuries · Limited investigation · Final report · Sep 21, 2002 · N6303V · Substantial damage
  > The loss of engine power due to failure of the number three connecting rod cap. Also causal was the failure of the pilot of a previous flight to report an engine overspeed event precluding the performance of the appropriate maintenance inspection.
- [NTSB LAX02LA291](https://openairdocs.org/ntsb/LAX02LA291.md): PZL-Bielsko SZD-42-2 Jantar · Hemet, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 21, 2002 · N131AS · Substantial damage
  > the pilot's failure to maintain an adequate terrain clearance altitude.
- [NTSB LAX02LA290](https://openairdocs.org/ntsb/LAX02LA290.md): Cessna 172G · Vail, AZ · Accident · No injuries · Limited investigation · Final report · Sep 18, 2002 · N2982U · Substantial damage
  > The pilot's inadequate fuel consumption calculations, which resulted in fuel exhaustion.
- [NTSB IAD02LA095](https://openairdocs.org/ntsb/IAD02LA095.md): Cessna 172M · Edinburg, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 18, 2002 · N5033H · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB ATL02LA170](https://openairdocs.org/ntsb/ATL02LA170.md): Mikoyan Gurevich Mig-15 · Whiteville, NC · Accident · 1 fatal · Limited investigation · Final report · Sep 18, 2002 · N151MG · Destroyed
  > The pilot continued visual flight into instrument meteorological conditions and experienced spatial disorientation which resulted in a loss of control and the subsequent collision with the ground.
- [NTSB CHI02LA285](https://openairdocs.org/ntsb/CHI02LA285.md): Hughes 369D · O'Neill, NE · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 2002 · N500EK · Substantial damage
  > A loss of engine power due to turbine blade separation as a result of hot corrosion damage to the turbine blades. Contributing to the accident was the pilot misjudging the flare at the completion of the autorotation resulting in a hard landing. The dark night…
- [NTSB CHI02LA286](https://openairdocs.org/ntsb/CHI02LA286.md): Bailey DSA-1 · Washington, IA · Accident · Serious injuries · Limited investigation · Final report · Sep 16, 2002 · N304MB · Substantial damage
  > The selection of unsuitable terrain and the failure of the oil pressure gage line. Factors were, the pilot/owners failure to obtain an annual condition inspection, and the corn crop.
- [NTSB CHI02FA284](https://openairdocs.org/ntsb/CHI02FA284.md): Pilatus PC-12/45 · Westphalia, MO · Accident · 2 fatal · Field investigation · Final report · Sep 14, 2002 · N451ES · Destroyed
  > The pilot's spatial disorientation while turning in a cruise climb in instrument meteorological conditions, which resulted in the pilot's loss of aircraft control, and his failure to recover from a resultant tight descending spiral.
- [NTSB NYC02LA193](https://openairdocs.org/ntsb/NYC02LA193.md): I.C.A. Brasov IS-28-B2 · Blairstown, NJ · Accident · Serious injuries · Limited investigation · Final report · Sep 12, 2002 · N8216Q · Substantial damage
  > The second pilot's improper in-flight decision to perform a release from the towplane, which did not allow for successful completion of the flight. A factor was the downdrafts.
- [NTSB LAX02FA281](https://openairdocs.org/ntsb/LAX02FA281.md): Aerospatiale AS350BA · Peach Springs, AZ · Accident · Minor injuries · Field investigation · Final report · Sep 12, 2002 · N357NT · Substantial damage
  > the pilot's failure to maintain an adequate airspeed and main rotor rpm during the landing approach as prescribed in the hydraulic pump failure emergency procedures found in the rotorcraft flight manual, thus resulting in a loss of control of the aircraft and…
- [NTSB ATL02LA169](https://openairdocs.org/ntsb/ATL02LA169.md): Piper PA24-250 · Morton, MS · Accident · No injuries · Limited investigation · Final report · Sep 11, 2002 · N5724P · Substantial damage
  > Contamination in the exhaust valve guide area which caused the binding of the exhaust valve in the open position.
- [NTSB CHI02FA288](https://openairdocs.org/ntsb/CHI02FA288.md): Bell 206L-1 · Doland, SD · Accident · 4 fatal · Field investigation · Final report · Sep 10, 2002 · N400SL · Destroyed
  > Pilot spatial disorientation while flying in dark night conditions, resulting in a loss of aircraft control; and the company's inadequate remedial actions after identifying the pilot's night flying deficiency over areas without lighted references. A factor to…
- [NTSB LAX02FA278](https://openairdocs.org/ntsb/LAX02FA278.md): Beech A36 · Grand Canyon, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 8, 2002 · N8261J · Destroyed
  > the pilot's inadequate in-flight planning/decision and his failure to maintain adequate airspeed which resulted in an encounter with adverse weather conditions and the loss of control due to a stall. Contributing factors were thunderstorm related turbulence,…
- [NTSB IAD02FA091](https://openairdocs.org/ntsb/IAD02FA091.md): Piper PA 32R-301T · Byram Township, NJ · Accident · 2 fatal · Field investigation · Final report · Sep 8, 2002 · C-GKLY · Destroyed
  > the improper manufacturing of the crankshaft gear bolt, which resulted in the failure of the bolt due to hydrogen embrittlement, and the subsequent loss of engine power. Also causal was the engine manufacturer's failure to remove the affected bolts from fixed…
- [NTSB NYC02LA185](https://openairdocs.org/ntsb/NYC02LA185.md): Reiley Seawind 3000 · Bloomingburg, OH · Accident · Serious injuries · Limited investigation · Final report · Sep 7, 2002 · N278ER · Substantial damage
  > The pilot's inadvertent use of the fuel shutoff valve which resulted in a subsequent total loss of engine power due to fuel starvation.
- [NTSB NYC02LA184](https://openairdocs.org/ntsb/NYC02LA184.md): Graham Mini-500 · Renfrew, PA · Accident · 1 fatal · Limited investigation · Final report · Sep 7, 2002 · N373TG · Substantial damage
  > Failure of the main transmission.
- [NTSB NYC02LA182](https://openairdocs.org/ntsb/NYC02LA182.md): Duffy Vans RV-9A · Oxford, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 2002 · N945D · Substantial damage
  > The pilot's improper fuel calculations, which resulted in fuel exhaustion and a subsequent total loss of engine power. Factors included an inaccurate fuel gauge indication for undetermined reasons, the pilot's reliance on that indication, the night lighting…
- [NTSB LAX02LA275](https://openairdocs.org/ntsb/LAX02LA275.md): Huene Velocity XL-RG · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Sep 6, 2002 · N394BL · Destroyed
  > An in-flight exhaust stack separation during descent for landing resulting in loss of engine power and a forced landing to an open field.
- [NTSB FTW02LA250](https://openairdocs.org/ntsb/FTW02LA250.md): Gray Rotorway Exec 90 · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Sep 5, 2002 · N716JB · Substantial damage
  > The pilot's failure to refuel the helicopter, which resulted in fuel exhaustion.
- [NTSB MIA02LA166](https://openairdocs.org/ntsb/MIA02LA166.md): Beech C24R · Olar, SC · Accident · No injuries · Limited investigation · Final report · Sep 4, 2002 · N6698D · Substantial damage
  > The pilot's failure to execute the proper remedial action for hydraulic leak fumes in the cockpit, and his decision to perform an immediate precautionary landing to a vacant field, resulting in collision with a tree. A factor in the accident was the…
- [NTSB CHI02IA275](https://openairdocs.org/ntsb/CHI02IA275.md): Saab-Scania 340A · Detroit, MI · Incident · No injuries · Incident investigation · Final report · Sep 4, 2002 · N110XJ · No damage
  > A malfunctioning yaw damper.
- [NTSB NYC02LA181](https://openairdocs.org/ntsb/NYC02LA181.md): Piper PA-18 · Belmar, NJ · Accident · No injuries · Limited investigation · Final report · Sep 3, 2002 · N5428H · Substantial damage
  > The improper use of an fuel additive which resulted in a power loss. A factor was the lack of suitable terrain.
- [NTSB FTW02LA247](https://openairdocs.org/ntsb/FTW02LA247.md): Eurocopter AS350B3 · Eagle Pass, TX · Accident · No injuries · Limited investigation · Final report · Sep 2, 2002 · N747R · Substantial damage
  > The insufficient length of the stepper motor rack inside the HMU, which caused the red "GOV" light to illuminate and the fuel metering valve to freeze causing the engine to automatically engage the manual mode.
- [NTSB ANC02LA110](https://openairdocs.org/ntsb/ANC02LA110.md): Cessna 185 · Port Alsworth, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 2002 · N185CF · Substantial damage
  > The pilot's inadequate evaluation of the area weather conditions, and his subsequent inability to maintain terrain clearance upon encountering a downdraft, which resulted in an in-flight collision with tree-covered mountainous terrain. A factor in the…
- [NTSB SEA02LA168](https://openairdocs.org/ntsb/SEA02LA168.md): Nolley BD-5 · Corvallis, OR · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 2002 · N50TX · Substantial damage
  > Fuel starvation resulting in a loss of engine power during the aircraft's initial climb. A disconnected fuel line was a factor.
- [NTSB LAX02LA270](https://openairdocs.org/ntsb/LAX02LA270.md): Ercoupe 415-C · Fresno, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 2002 · N87204 · Substantial damage
  > a loss of engine power for undetermined reasons.

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

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

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