# 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 287 of 718 · 35,885 cases ## Cases, newest first - [NTSB ATL89LA146](https://openairdocs.org/ntsb/ATL89LA146.md): Ercoupe 415-C · Troy, NC · Accident · 1 fatal · Limited investigation · Final report · May 13, 1989 · N99766 · Destroyed > An undetermined powerplant problem, which resulted in a loss of engine power, and the pilot/mechanic's failure to assure the aircraft was properly inspected before flight. Factors related to the accident were: the pilot's delay in making a precautionary… - [NTSB LAX89LA191](https://openairdocs.org/ntsb/LAX89LA191.md): Airbus Industrie A-300-B4-203 · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · May 11, 1989 · N972C · No damage > An unexpected encounter with clear air turbulence which seriously injured a passenger in the aft lavatory. - [NTSB LAX89LA190](https://openairdocs.org/ntsb/LAX89LA190.md): Cessna 150D · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · May 11, 1989 · N4276U · Substantial damage > The pilots failure to accurately calculate fuel consumption during preflight planning and preparation and during the flight which resulted in fuel exhaustion. - [NTSB CHI89LA086](https://openairdocs.org/ntsb/CHI89LA086.md): Porterfield CP-55 · Tecumseh, MI · Accident · No injuries · Limited investigation · Final report · May 11, 1989 · N32340 · Substantial damage > Pilot's inadequate preflight operatins, which failed to detect the presence of water contamination in the fuel system, and resulted in the substantial loss of power and subsequent forced landing. The aircraft encountered soft, loose soil during the forced… - [NTSB LAX89FA192](https://openairdocs.org/ntsb/LAX89FA192.md): Beech 200 · Azusa, CA · Accident · 1 fatal · Field investigation · Final report · May 10, 1989 · N39YV · Destroyed > Improper in-flight planning/decision by the pilot, which resulted in has inadvertent flight into instrument meteorological conditions (IMC) and subsequent collision with mountainous terrain. The weather and terrain conditions were considered to be related… - [NTSB LAX89LA146](https://openairdocs.org/ntsb/LAX89LA146.md): Beech A36 · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · May 9, 1989 · N7238A · Substantial damage > Failure of the number four piston assembly. A factor related to the accident was: the soft/uneven terrain in the emergency landing area. - [NTSB LAX89FA189](https://openairdocs.org/ntsb/LAX89FA189.md): Piper PA-28-181 · Dublin, CA · Accident · 2 fatal · Field investigation · Final report · May 9, 1989 · N8078V · Destroyed > The pilot decided to continue VFR flight after encountering instrument meteorological conditions in an area of rising mountainous terrain. Factors in this accident were the pilots lack of experience and his failure to obtain a preflight weather briefing. - [NTSB LAX89IA184](https://openairdocs.org/ntsb/LAX89IA184.md): Boeing 747 · Los Angeles, CA · Incident · Minor injuries · Incident investigation · Final report · May 8, 1989 · ZKNZX · No damage > Inadequate visual look-out by the pilot of the other (small twin engine) aircraft. A factor related to the incident was: a delay of the 747 crew to see-and-avoid the other aircraft. - [NTSB MKC89LA106](https://openairdocs.org/ntsb/MKC89LA106.md): Cessna 150 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · May 7, 1989 · N6411K · Substantial damage > The pilots failure to properly calculate fuel consumption which resulted in an inadequate fuel reserve and fuel exhaustion prior to reaching his destination. During the ensuing forced landing the pilot failed to maintain airspeed which resulted in an… - [NTSB FTW89FA093](https://openairdocs.org/ntsb/FTW89FA093.md): MBB BO-105S · W Cameron Blk · Accident · 1 fatal · Field investigation · Final report · May 7, 1989 · N2785B · Destroyed > The partial electrical failure of the micro-switch for the outboard lateral guide assembly, and the incorrect guard installed on the hydraulic test switch, resulting in a total hydraulic failure. Factors were: the incorrect installation of the guard by an… - [NTSB LAX89FA182](https://openairdocs.org/ntsb/LAX89FA182.md): Cessna 172 · Industry, CA · Accident · 3 fatal · Field investigation · Final report · May 6, 1989 · N6129E · Destroyed > The failure of the pilot to maintain an adequate altitude to ensure obstruction clearance. Factors related to the accident were: darkness, low ceiling, fog, and the pilot's continued flight into adverse weather conditions. - [NTSB FTW89DRG05](https://openairdocs.org/ntsb/FTW89DRG05.md): Grumman-Schweizer G-164 · Edcouch, TX · Accident · No injuries · Final report · May 6, 1989 · N4591 · Substantial damage > Loss of engine power for an undetermined reason. The corn crop was a contributing factor. - [NTSB CHI89LA085](https://openairdocs.org/ntsb/CHI89LA085.md): Cessna 152 · Flint, MI · Accident · No injuries · Limited investigation · Final report · May 6, 1989 · N25054 · Substantial damage > The pilot-in-command's failure to follow proper procedures and directives and his premature decision to initiate an emergency procedure. Contributing factors were the pilot's lack of total experience and his selection of unsuitable terrain for the emergency… - [NTSB ANC89FA069](https://openairdocs.org/ntsb/ANC89FA069.md): Bell 412 · Girdwood, AK · Accident · Minor injuries · Field investigation · Final report · May 6, 1989 · N524EH · Destroyed > A main rotor flight control bolt (part number 20-057-6-38D) came out of its rod end bearing while in flight due to the bolt being improperly torqued during maintenance. - [NTSB MKC89LA100](https://openairdocs.org/ntsb/MKC89LA100.md): Cessna 172 · Wentzville, MO · Accident · Minor injuries · Limited investigation · Final report · May 4, 1989 · N5092D · Substantial damage > The pilot's delay in aborting the landing, and his failure to maintain clearance from the power lines. Factors related to the accident were: the pilot's selection of the wrong runway, the adverse weather conditions, the pilot's failure to attain the proper… - [NTSB MKC89FA102](https://openairdocs.org/ntsb/MKC89FA102.md): Cessna 150H · Carnegie, OK · Accident · 2 fatal · Field investigation · Final report · May 4, 1989 · N22875 · Destroyed > Continued VFR flight by the pilot into instrument meteorological conditions, which resulted in subsequent collision with rising/hilly terrain. Related factors were: inadequate preflight planning/preparation by the pilot, dark night, adverse weather… - [NTSB LAX89FA178](https://openairdocs.org/ntsb/LAX89FA178.md): Piper PA-28-201T · Stockton, CA · Accident · 1 fatal · Field investigation · Final report · May 4, 1989 · N8133A · Destroyed > The pilot's improper decision to perform aerobatics which resulted in the design stress limits of the airplane being exceeded due to excessive airspeed. Contributing factors to the accident were the pilot's overconfidence in his and the airplane's ability,… - [NTSB FTW89FA090](https://openairdocs.org/ntsb/FTW89FA090.md): Cessna 172P · Burnet, TX · Accident · 2 fatal · Field investigation · Final report · May 3, 1989 · N5253K · Destroyed > Continued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: the adverse weather conditions and the pilot's lack of… - [NTSB DEN89LA115](https://openairdocs.org/ntsb/DEN89LA115.md): Cessna 182G · St. Xavier, MT · Accident · No injuries · Limited investigation · Final report · May 3, 1989 · N3410S · Substantial damage > The pilot's failure to maintain airspeed while maneuvering for a forced landing following a failure of the number two piston. Contributing to the accident was smoke in the cockpit. - [NTSB CHI89IA083](https://openairdocs.org/ntsb/CHI89IA083.md): Mcdonnell Douglas DC-9-82 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · May 2, 1989 · N434AA · Minor damage > Failure of the hydraulic power transfer unit shut-off (ptu s/o) valve due to failed (fatigued) valve body attach screws. - [NTSB MIA89LA140](https://openairdocs.org/ntsb/MIA89LA140.md): Beech 35 · Daytona Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 1989 · N447B · Substantial damage > A loss of engine power for undetermined reasons. - [NTSB NYC89FA129](https://openairdocs.org/ntsb/NYC89FA129.md): Brantly Helicopter B-2 · Herkimer, NY · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1989 · N2113U · Destroyed > A forced landing in unsuitable terrain due to an internal engine failure. The engine failure sequence was initiated by a failed oil pressure relief spring which had failed in fatigue due to improper plating of the spring. The spring failure caused oil… - [NTSB NYC89LA126](https://openairdocs.org/ntsb/NYC89LA126.md): Bell 206A · Bedminster, NJ · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1989 · N273E · Substantial damage > Off airport landing in unsuitable terrain due to an undetermined power loss. - [NTSB MKC89FA099](https://openairdocs.org/ntsb/MKC89FA099.md): Maule M-5 · Ainsworth, NE · Accident · 3 fatal · Field investigation · Final report · Apr 27, 1989 · N20BS · Destroyed > The pilot continued flight into IFR conditions and the loss of aicraft control due to spatial disorientation. Contributing to the accident were the cloud conditions and fog. - [NTSB FTW89LA088](https://openairdocs.org/ntsb/FTW89LA088.md): Cessna 182 · Owasso, OK · Accident · No injuries · Limited investigation · Final report · Apr 27, 1989 · N5160D · Substantial damage > Inadequate preflight by the pilot, which resulted in fuel exhaustion from lack of fuel. The presence of trees was was a contributing factor. - [NTSB FTW89LA085](https://openairdocs.org/ntsb/FTW89LA085.md): Mooney M20J · Jasper, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 27, 1989 · N201TP · Destroyed > The pilot's misjudgement of his altitude. Factors related to the accident were: light conditions at dawn and ground fog in the area, which resulted in the pilot's lack of visual perception. - [NTSB LAX89LA173](https://openairdocs.org/ntsb/LAX89LA173.md): North American P-51D · Travis Afb, CA · Accident · No injuries · Limited investigation · Final report · Apr 26, 1989 · N151D · Substantial damage > The left main landing gear failing to fully extend for undetermined reasons resulting in its collapsing during landing. - [NTSB FTW89LA087](https://openairdocs.org/ntsb/FTW89LA087.md): Piper PA-32-300 · Eufaula, OK · Accident · No injuries · Limited investigation · Final report · Apr 26, 1989 · N8654N · Substantial damage > The pilot's improper positioning of the fuel selector, which resulted in a loss of power due to fuel starvation, and his failure to followed the emergency procedure. A factor related to the accident was: rough terrain in the emergency landing area. - [NTSB MIA89FA137](https://openairdocs.org/ntsb/MIA89FA137.md): Cessna 150M · Miramar, FL · Accident · Serious injuries · Field investigation · Final report · Apr 25, 1989 · N3004V · Destroyed > The pilot's failure to continue flying the airplane when he noted a vibration of unknown origin. Contributing to the accident was the improper selection of unsuitable terrain to execute a precautionary landing when an airport and a highway median were… - [NTSB NYC89IA222](https://openairdocs.org/ntsb/NYC89IA222.md): Cessna 421C · New York, NY · Incident · No injuries · Incident investigation · Final report · Apr 23, 1989 · N247CB · 2 aircraft · No damage > Failure of the liberty sector controller to advise pan am flight 542 of the presence of the Cessna 421 and/or restrict the climb of flight 542 until it had passed the Cessna, and failure of the pan am aircrew to see the Cessna in adequate time to avoid a near… - [NTSB MIA89LA136](https://openairdocs.org/ntsb/MIA89LA136.md): Cessna 152 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Apr 23, 1989 · N704XE · Substantial damage > Failure of a rocker shaft boss on the number three cylinder. A related factor was the rough terrain in the emergency landing area. - [NTSB ATL89LA133](https://openairdocs.org/ntsb/ATL89LA133.md): Beech A36 · Macon, GA · Accident · No injuries · Limited investigation · Final report · Apr 22, 1989 · N6613A · Substantial damage > The pilot delayed remedial action when the imminent loss of electrical power was observed. Additionally, the pilot's failure to execute the appropriate emergency procedure and manually lower the landing gear, resulted in its collapse upon landing.… - [NTSB MIA89LA135](https://openairdocs.org/ntsb/MIA89LA135.md): Cessna 150M · Olive Branch, MS · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 1989 · N51344 · Substantial damage > Fuel exhaustion caused by the pilot exceeding the fuel endurance of the airplane. - [NTSB SEA89LA073](https://openairdocs.org/ntsb/SEA89LA073.md): Donner/Parton Avid Flyer · Stanwood, WA · Accident · No injuries · Limited investigation · Final report · Apr 20, 1989 · N4409D · Substantial damage > An ignition lead became disconnected from one cylinder, which resulted in a partial power loss. A factor related to the accident was: soft terrain in the touchdown area. - [NTSB SEA89FA074](https://openairdocs.org/ntsb/SEA89FA074.md): de Havilland DHC-2 · Pelican, AK · Accident · 2 fatal · Field investigation · Final report · Apr 19, 1989 · N62873 · Destroyed > Improper in-flight decision by the pilot, and his inadvertent flight into instrument meteorological conditions (IMC). The terrain and weather conditions were considered to be factors. - [NTSB NYC89LA122](https://openairdocs.org/ntsb/NYC89LA122.md): Piper PA-22-160 · Gettysburg, PA · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 1989 · N8745D · Destroyed > The pilot's poor preflight and in-flight planning in electing to continue the flight beyond the planned destination which resulted in fuel exhaustion. - [NTSB FTW89LA083](https://openairdocs.org/ntsb/FTW89LA083.md): Cessna 150J · Athens, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1989 · N50703 · Substantial damage > Fuel exhaustion due to inadequate preflight by the pilot. - [NTSB FTW89FA151](https://openairdocs.org/ntsb/FTW89FA151.md): Bellanca 17-30A · Junction, TX · Accident · 1 fatal · Field investigation · Final report · Apr 17, 1989 · N8785V · Destroyed > Continued VFR flight into instrument meteorological conditions (IMC) by the pilot, which resulted in his failure to maintain control of the aircraft due to spatial disorientation. The weather conditions and his self-induced pressure were factors. - [NTSB ATL89FA130](https://openairdocs.org/ntsb/ATL89FA130.md): Bell UH-1E · Aiken, SC · Accident · Serious injuries · Field investigation · Final report · Apr 17, 1989 · N118HS · Substantial damage > Improper installation of a tail rotor pitch change crosshead retention bolt by the company mechanic, which resulted in loosening of the bolt and eventual failure of the tail rotor assembly/blade and subsequent loss of control. Trees at the crash site… - [NTSB ANC89LA060](https://openairdocs.org/ntsb/ANC89LA060.md): Cessna 152 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Apr 17, 1989 · N6479L · Substantial damage > Improper preflight planning and preparation by the pilot which resulted in fuel exhaustion. - [NTSB LAX89LA161](https://openairdocs.org/ntsb/LAX89LA161.md): Cessna 175 · Victorville, CA · Accident · No injuries · Limited investigation · Final report · Apr 15, 1989 · N8174T · Substantial damage > The pilot's failure to conduct an adequate preflight and assure the proper quantity of fuel on board for the proposed flight. - [NTSB ATL89FA131](https://openairdocs.org/ntsb/ATL89FA131.md): Mooney M20F · Lynch, KY · Accident · 2 fatal · Field investigation · Final report · Apr 15, 1989 · N9252V · Destroyed > Continued VFR flight by the pilot into instrument meteorological conditions (IMC). Factors related to the accident were: the adverse weather conditions, terrain, and the pilot's lack of instrument experience. - [NTSB LAX89LA180](https://openairdocs.org/ntsb/LAX89LA180.md): Mooney M20C · Hesperia, CA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1989 · N5909Q · Substantial damage > The pilot, the operator of the airplane, improperly maintained the airplane, and during the ensuing forced landing the pilot's inflight planning was poor and that he misjudeged the airplane's altitude. - [NTSB ATL89LA126](https://openairdocs.org/ntsb/ATL89LA126.md): Grumman AA-5B · Siler City, NC · Accident · No injuries · Limited investigation · Final report · Apr 13, 1989 · N28990 · Substantial damage > Improper engine overhaul procedures which resulted in the catastrophic failure of the engine crankshaft. Contributing to the accident was the lack of a suitable forced landing area. - [NTSB MIA89LA129](https://openairdocs.org/ntsb/MIA89LA129.md): Luscombe 8A · St Augustine, FL · Accident · No injuries · Limited investigation · Final report · Apr 12, 1989 · N311P · Substantial damage > Fuel contamination. A related factor was the tree. - [NTSB LAX89FA157](https://openairdocs.org/ntsb/LAX89FA157.md): Cessna 152 · Chino, CA · Accident · Serious injuries · Field investigation · Final report · Apr 11, 1989 · N24807 · Substantial damage > The pilot's failure to obtain an appropriate weather briefing in preparation for the cross country flight and his failure to maintain an altitude sufficient to clear the terrain along the indended route after entering reduced visibility conditions. - [NTSB DEN89LA105](https://openairdocs.org/ntsb/DEN89LA105.md): Cessna 172F · Morgan, UT · Accident · No injuries · Limited investigation · Final report · Apr 10, 1989 · N7847U · Substantial damage > Inadequate servicing of the aircraft by the pilot, partial blockage of the fuel line and fuel filter, and fuel starvation. Contributing factors were: the downward sloping runway and a fence. - [NTSB ATL89MA123](https://openairdocs.org/ntsb/ATL89MA123.md): Beech 200 · Pensacola, FL · Accident · 3 fatal · Major investigation · Final report · Apr 10, 1989 · N30PC · Destroyed > An in flight cabin fire of undetermined origin, and smoke (toxic condition) in the crew compartment, which resulted in physical impairment of the flight crew. - [NTSB LAX89LA154](https://openairdocs.org/ntsb/LAX89LA154.md): Cessna 152 · Taft, CA · Accident · No injuries · Limited investigation · Final report · Apr 9, 1989 · N4602L · Substantial damage > The pilots improper use of carburetor heat in weather conditions which were conducive to the formation of carburetor ice. - [NTSB MKC89LA088](https://openairdocs.org/ntsb/MKC89LA088.md): Mooney M20E · Lake Elmo, MN · Accident · No injuries · Limited investigation · Final report · Apr 8, 1989 · N9424V · Substantial damage > Fuel tank selector improperly positioned, emergency procedure improperly performed by the pilot, and fuel starvation. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=288 ## 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=287 --- 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.