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

## Cases, newest first

- [NTSB LAX99FA125](https://openairdocs.org/ntsb/LAX99FA125.md): Piper PA-28-161 · Lytle Creek, CA · Accident · 2 fatal · Field investigation · Final report · Mar 20, 1999 · N2529W · Destroyed
  > the pilot's inadvertent visual flight into instrument meteorological conditions resulting in impact with high terrain.
- [NTSB ATL99LA056](https://openairdocs.org/ntsb/ATL99LA056.md): Cessna 152 · Bunn Level, NC · Accident · Minor injuries · Limited investigation · Final report · Mar 20, 1999 · N46542 · Substantial damage
  > The loss of engine power for undetermined reasons. Factors were an electrical system malfunction for undetermined reasons and the dark night conditions.
- [NTSB DEN99LA057](https://openairdocs.org/ntsb/DEN99LA057.md): Cessna 172G · Agate, CO · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1999 · N1321F · Substantial damage
  > The development of carburetor ice resulting in a partial loss of engine power. Factors were the weather conditions favorable for carburetor icing, the dark night conditions, and the lack of suitable terrain for landing.
- [NTSB NYC99FA074](https://openairdocs.org/ntsb/NYC99FA074.md): Cessna 340A · Chesapeake, VA · Accident · 2 fatal · Field investigation · Final report · Mar 16, 1999 · N13DT · Destroyed
  > The pilot's failure to maintain control of the airplane during a single engine emergency landing, after experiencing a failure of the left engine. A factor in this accident was the failure of the left engine's camshaft due to a fatigue crack.
- [NTSB DEN99LA054](https://openairdocs.org/ntsb/DEN99LA054.md): Cessna 320D · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Mar 16, 1999 · N4127T · Substantial damage
  > A partial loss of power on the left engine for undetermined reasons. A factor was the pilot's failure to maintain directional control of the aircraft during landing flare/touchdown.
- [NTSB ANC99LA034](https://openairdocs.org/ntsb/ANC99LA034.md): Cessna 150 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Mar 16, 1999 · N8620S · Substantial damage
  > The loss of engine power for an undetermined reason.
- [NTSB CHI99LA109](https://openairdocs.org/ntsb/CHI99LA109.md): Piper J5A · Wausau, WI · Accident · No injuries · Limited investigation · Final report · Mar 15, 1999 · N40888 · Substantial damage
  > the loss of engine power for undetermined reasons and the lack of suitable terrain for landing. A factor to the accident was the aircraft owner not performing necessary maintenance to the aircraft.
- [NTSB DEN99IA053](https://openairdocs.org/ntsb/DEN99IA053.md): Gulfstream G-IV · Durango, CO · Incident · No injuries · Incident investigation · Final report · Mar 13, 1999 · N411WW · Minor damage
  > The failure of the number four fuel line. Factors were the chaffing of the alternator's electrical wires on the number four fuel line, and the subsequent fire in the number one engine nacelle.
- [NTSB NYC99FA071](https://openairdocs.org/ntsb/NYC99FA071.md): Mooney M20K · Counts, VA · Accident · 1 fatal · Field investigation · Final report · Mar 12, 1999 · N231HU · Destroyed
  > The pilot's failure to maintain control of the airplane.
- [NTSB MIA99LA103](https://openairdocs.org/ntsb/MIA99LA103.md): Piper PA-32-300 · Mt. Vernon, GA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1999 · N3218W · Substantial damage
  > The pilot's improper flare that resulted in a hard landing in an open field. A factor was the high output flow of the fuel injector servo that resulted in a loss of engine power and the forced landing.
- [NTSB CHI99FA105](https://openairdocs.org/ntsb/CHI99FA105.md): Beech C-45G · Romulus, MI · Accident · 1 fatal · Field investigation · Final report · Mar 11, 1999 · N234L · Destroyed
  > the aircraft control not maintained and the inadvertent stall by the pilot while maneuvering to the landing area. The open door was a contributing factor.
- [NTSB NYC99LA073](https://openairdocs.org/ntsb/NYC99LA073.md): Piper PA-32R-300 · Richmond, VA · Accident · No injuries · Limited investigation · Final report · Mar 9, 1999 · N5454F · Substantial damage
  > The pilot's inadequate preflight planning/preparation which resulted in flight into icing weather conditions. A factor related to the accident was restricted visibility through the icy windshield during landing.
- [NTSB MIA99LA100](https://openairdocs.org/ntsb/MIA99LA100.md): Mooney 20G · Naples, FL · Accident · No injuries · Limited investigation · Final report · Mar 6, 1999 · N3588X · Substantial damage
  > the pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a off airport forced landing. Contributing factors in this accident were the pilot's inadequate pre-flight and in-flight…
- [NTSB NYC99LA069](https://openairdocs.org/ntsb/NYC99LA069.md): Saab-Scania 340A · Atlantic City, NJ · Accident · Serious injuries · Limited investigation · Final report · Mar 3, 1999 · N343BE · No damage
  > Unanticipated in-flight turbulence.
- [NTSB MIA99LA099](https://openairdocs.org/ntsb/MIA99LA099.md): Piper PA-32-260 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Mar 3, 1999 · N4802S · Destroyed
  > a loss of engine power for an undetermined reason, resulting in a forced landing in water, and subsequent sinking of the airplane.
- [NTSB CHI99IA100](https://openairdocs.org/ntsb/CHI99IA100.md): McDonnell Douglas DC-10 · Salina, KS · Incident · No injuries · Incident investigation · Final report · Mar 2, 1999 · N40061 · 2 aircraft · No damage
  > The ARTCC personnel failed to maintain radio communications with both airplanes and failed to maintain IFR separation standards. Factors relating to the incident were the FAA does not require cargo airplanes to be equipped with TCAS and neither airplane was…
- [NTSB MIA99LA093](https://openairdocs.org/ntsb/MIA99LA093.md): Scott A. George Jr. Fisher Celebrity · Simpsonville, SC · Accident · No injuries · Limited investigation · Final report · Mar 1, 1999 · N1122V · Substantial damage
  > The unsuitable terrain encountered during the forced landing. Contributing to the accident was the total loss of engine power due to the failure of a plastic 90-degree fitting at the inlet fitting of the carburetor.
- [NTSB NYC99LA068](https://openairdocs.org/ntsb/NYC99LA068.md): Piper PA-28-140 · Wolfeboro, NH · Accident · Serious injuries · Limited investigation · Final report · Feb 28, 1999 · N8790N · Substantial damage
  > The pilot's failure to attain a proper touchdown point. A factor in the accident was the pilot's failure to use a preflight briefing service, resulting in an in flight encounter with snow, and subsequent precautionary landing.
- [NTSB LAX99LA113](https://openairdocs.org/ntsb/LAX99LA113.md): Cessna P210N · Pacific Ocean (Pacific Ocean) · Accident · 1 fatal · Limited investigation · Final report · Feb 28, 1999 · HSKCC · Destroyed
  > A loss of engine oil pressure and ensuing loss of engine power for undetermined reasons.
- [NTSB DEN99LA046](https://openairdocs.org/ntsb/DEN99LA046.md): Piper PA-23C-250 · Lamar, CO · Accident · No injuries · Limited investigation · Final report · Feb 27, 1999 · N6574Y · Substantial damage
  > The pilot's improper use of the airplane's fuel tank selector switches. Factors were the fuel starvation to both engines, the pilot's lack of sleep, and the soft terrain.
- [NTSB LAX99LA111](https://openairdocs.org/ntsb/LAX99LA111.md): Cooper Vans RV-6 · Vacaville, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 26, 1999 · N36VR · Substantial damage
  > The failure of the engine assembler to apply the proper torque on the connecting rods bolts, which led to fatigue cracking and ultimately fracture of the rod bolts.
- [NTSB FTW99LA085](https://openairdocs.org/ntsb/FTW99LA085.md): Eurocopter Colibri EC120B · Springtown, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 26, 1999 · N122TH · Substantial damage
  > The improper touchdown executed by the pilot. Factors were the tail wind condition, and the manufacturer's inadequate design of the P3 pipe supports, which resulted in a fatigue fracture of the P3 pipe.
- [NTSB MIA99LA091](https://openairdocs.org/ntsb/MIA99LA091.md): Mooney M20J · St. Cloud, FL · Accident · No injuries · Limited investigation · Final report · Feb 25, 1999 · N4671H · Substantial damage
  > The improper installation of the propeller by maintenance personnel resulting in fretting of the face of the propeller hub and fatigue failure of the No. 1 propeller blade. Also, the unsuitable terrain encountered during the descent for the forced landing.
- [NTSB DEN99LA042](https://openairdocs.org/ntsb/DEN99LA042.md): Beech V35 · Telluride, CO · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 1999 · N345MD · Destroyed
  > A loss of engine power due to the ingestion of air in the fuel line, the pilot's failure to purge the fuel line of unwanted air prior to flight as outlined in the Airplane Flight Manual, and inadequate altitude in which to glide to the airport.
- [NTSB NYC99LA065](https://openairdocs.org/ntsb/NYC99LA065.md): Stinson 108-3 · Bristol, CT · Accident · No injuries · Limited investigation · Final report · Feb 21, 1999 · N6191M · Substantial damage
  > The partial loss of power due to the failure of a fatigued connecting rod bolt.
- [NTSB LAX99FA106](https://openairdocs.org/ntsb/LAX99FA106.md): Cessna 172N · El Monte, CA · Accident · Minor injuries · Field investigation · Final report · Feb 20, 1999 · N5174D · Destroyed
  > An in-flight fuel fire in the left forward doorpost due to an electrical arc from an adjacent map light switch puncturing a main fuel feed line. The manufacturer's inadequate design in routing the fuel line in close proximity to electrical arc sources in the…
- [NTSB LAX99LA103](https://openairdocs.org/ntsb/LAX99LA103.md): Zivko Aeronautics Edge 540 · Livermore, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1999 · N9ND · Substantial damage
  > The manufacturer's inadequate quality control procedures, which allowed an improperly manufactured crankshaft to be shipped, resulting in the separation of one counterweight from the crankshaft lug and the subsequent catastrophic internal failure of the…
- [NTSB LAX99FA104](https://openairdocs.org/ntsb/LAX99FA104.md): Beech 95-B55 · Coalinga, CA · Accident · 2 fatal · Field investigation · Final report · Feb 19, 1999 · N125TW · Destroyed
  > the pilot's inadvertant visual flight into instrument meteorological conditions.
- [NTSB LAX99LA094](https://openairdocs.org/ntsb/LAX99LA094.md): Beech F33 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Feb 18, 1999 · N8253C · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB ATL99FA048](https://openairdocs.org/ntsb/ATL99FA048.md): Piper PA-32RT-300 · Cartersville, GA · Accident · 1 fatal · Field investigation · Final report · Feb 16, 1999 · N21724 · Destroyed
  > In flight collision with terrain for undetermined reasons.
- [NTSB NYC99LA059](https://openairdocs.org/ntsb/NYC99LA059.md): Aerospatiale 355 · Toledo, OH · Accident · Serious injuries · Limited investigation · Final report · Feb 12, 1999 · N355MF · Destroyed
  > The pilot's decision to continue the flight which resulted in inadvertent flight into IMC, and the subsequent spatial disorientation and loss of control. A factor in the accident was the inaccuracy of the weather forecast.
- [NTSB NYC99LA058](https://openairdocs.org/ntsb/NYC99LA058.md): Cessna 152 · Duanesburg, NY · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 1999 · N89097 · Substantial damage
  > The instructor pilot's improper use of carburetor heat which resulted in carburetor ice, and a loss of engine power. A factor in the accident was the instructor pilot's failure to initiate the simulated engine failure from a point where a successful forced…
- [NTSB MIA99LA081](https://openairdocs.org/ntsb/MIA99LA081.md): Cessna 210G · Lake Placid, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 1999 · N5874F · Substantial damage
  > a total loss of engine power due to an in-flight separation of the crankshaft, caused by a fatigue crack that originated from the aft fillet radius of the No. 2 main journal, resulting in a forced landing in a field and impact with a tree.
- [NTSB DEN99IA038](https://openairdocs.org/ntsb/DEN99IA038.md): British Aerospace BAE 146-200A · Aspen, CO · Incident · No injuries · Incident investigation · Final report · Feb 12, 1999 · N608AW · Minor damage
  > The inadequate maintenance overhaul of the number four turbine disc by the manufacturer. A factor was the turbine blade's failure due to high cycle fatigue fracture.
- [NTSB MIA99LA079](https://openairdocs.org/ntsb/MIA99LA079.md): Wolf Seawind 3000 · Bradenton, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 11, 1999 · N76SW · Substantial damage
  > Total loss of engine power due to a burned piston for undetermined reasons resulting in a forced landing to unsuitable terrain and the subsequent crash landing onto a golf course.
- [NTSB LAX99LA093](https://openairdocs.org/ntsb/LAX99LA093.md): Aerostar RX-9 · Peoria, AZ · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1999 · N91067 · Substantial damage
  > The pilot's attempted flight in an area of forecasted high winds and his inadequate compensation for those wind conditions once encountered.
- [NTSB FTW99LA079](https://openairdocs.org/ntsb/FTW99LA079.md): Miller/Bell TR-1 · Hiwasse, AR · Accident · No injuries · Limited investigation · Final report · Feb 8, 1999 · N9194X · Substantial damage
  > The pilot's inadequate compensation for prevailing wind conditions. Factors were the crosswind, the lack of suitable terrain, and the separation of the adell clamp for the oil cooler inlet line.
- [NTSB ATL99LA049](https://openairdocs.org/ntsb/ATL99LA049.md): McDonnell Douglas MD-80 · Raleigh, NC · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 1999 · N433AA · No damage
  > The flight encountered clear air turbulence while descending through 17,000 feet mean sea level (MSL).
- [NTSB DEN99LA037](https://openairdocs.org/ntsb/DEN99LA037.md): Boeing 757-222 · Climax, CO · Accident · Serious injuries · Limited investigation · Final report · Feb 7, 1999 · N586UA · No damage
  > The flight's encounter with turbulence.
- [NTSB CHI99FA089](https://openairdocs.org/ntsb/CHI99FA089.md): Piper PA-18-150 · Belle Fourche, SD · Accident · 2 fatal · Field investigation · Final report · Feb 6, 1999 · N8075D · Destroyed
  > inadequate preflight planning/preparation, refueling not performed, and aircraft control not maintained by the pilot. The inadvertent stall by the pilot was an additional cause. Fuel exhaustion was a contributing factor.
- [NTSB NYC99IA056](https://openairdocs.org/ntsb/NYC99IA056.md): Piper PA42-1000 · Lexington, KY · Incident · No injuries · Incident investigation · Final report · Feb 5, 1999 · N37KW · Minor damage
  > Improper assembly of the engine gearcase by the manufacturer, which resulted in an uncontained failure of the 1st bull gear.
- [NTSB LAX99FA102](https://openairdocs.org/ntsb/LAX99FA102.md): North American T-28B · Joshua Tree, CA · Accident · 1 fatal · Field investigation · Final report · Feb 4, 1999 · N628B · Destroyed
  > The pilot's decision to attempt flight into an area of known adverse weather and the subsequent inadvertent VFR flight into IFR conditions resulting in an in-flight collision with mountainous terrain.
- [NTSB LAX99FA090](https://openairdocs.org/ntsb/LAX99FA090.md): North American T-28C · Joshua Tree, CA · Accident · 1 fatal · Field investigation · Final report · Feb 4, 1999 · N128BJ · Destroyed
  > The pilot's decision to attempt flight into an area of known adverse weather and the subsequent inadvertent VFR flight into IFR conditions resulting in an in-flight collision with mountainous terrain.
- [NTSB MIA99LA073](https://openairdocs.org/ntsb/MIA99LA073.md): Piper PA-32-260 · Orlando, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 3, 1999 · N5528J · Destroyed
  > A loss of engine power due to an engine assembly overload for undetermined reasons. A related factor was the pilot exceeded the airplane's maximum allowable weight.
- [NTSB CHI99LA081](https://openairdocs.org/ntsb/CHI99LA081.md): Cessna 150M · Paxton, IL · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1999 · N704BF · Substantial damage
  > the inadequate preflight planning by the pilot in command and the exhaustion of usable fuel. Factors were the tailwind landing condition and the rough terrain at the landing site.
- [NTSB FTW99LA078](https://openairdocs.org/ntsb/FTW99LA078.md): Taylorcraft BC12-D1 · Daingerfield, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 2, 1999 · N44174 · Substantial damage
  > An undetermined airframe malfunction which rendered the aircraft uncontrollable.
- [NTSB LAX99LA087](https://openairdocs.org/ntsb/LAX99LA087.md): Airbus Industrie A-320-232 · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 1999 · N640AW · No damage
  > The injured passenger's failure to follow the instructions of the cabin attendants.
- [NTSB LAX99IA085](https://openairdocs.org/ntsb/LAX99IA085.md): Aerospatiale AS350B · Grand Canyon Pk, AZ · Incident · No injuries · Incident investigation · Final report · Feb 1, 1999 · N32GA · Minor damage
  > The in-flight separation of a side window for undetermined reasons.
- [NTSB CHI99FA079](https://openairdocs.org/ntsb/CHI99FA079.md): Cessna U-206G · Salem, MO · Accident · 1 fatal · Field investigation · Final report · Jan 31, 1999 · N7586N · Destroyed
  > the spatial disorientation and loss of control by the pilot after a reported vacuum failure. Factors were instrument flight conditions and icing conditions.
- [NTSB FTW99LA072](https://openairdocs.org/ntsb/FTW99LA072.md): Piper PA-34-200T · Wharton, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 1999 · N8729E · Substantial damage
  > The pilot's failure to comply with the manufacturer's single engine landing checklist which resulted in the aircraft landing short of the runway.

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

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

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