# 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 291 of 718 · 35,885 cases ## Cases, newest first - [NTSB FTW89LA039](https://openairdocs.org/ntsb/FTW89LA039.md): Bell 206L-1 · S. Timbalier 75 (Gulf of Mexico) · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1989 · N27555 · Destroyed > The loss of control of the helicopter due to an undetermined failure of the tail rotor control system. - [NTSB ATL89MA070](https://openairdocs.org/ntsb/ATL89MA070.md): Swearingen SX-300 · Wilmington, OH · Accident · 2 fatal · Major investigation · Final report · Jan 9, 1989 · N6Y · Destroyed > Fatigue and resulting failure of the right wing's lower attachment fitting and inadequate quality control by the Swearingen SX-300 production/design personnel. - [NTSB ATL89LA068](https://openairdocs.org/ntsb/ATL89LA068.md): Beech B-90 · Paducah, KY · Accident · Serious injuries · Limited investigation · Final report · Jan 8, 1989 · N784K · Substantial damage > Pilot failed to maintain proper altitude while maneuvering to land. Probable contributing factors were inoperative weather radar, thunderstorms, lightning, an undetermined electrical problem, dark night, the pilot's improperly planned approach and visual… - [NTSB FTW89FA037](https://openairdocs.org/ntsb/FTW89FA037.md): Beech B33 · New Braunfels, TX · Accident · 2 fatal · Field investigation · Final report · Jan 7, 1989 · N1530Z · Destroyed > The pilot's decision to continue VFR flight into IMC. Contributing factors were the adverse weather conditions and the dark night. - [NTSB LAX89FA091](https://openairdocs.org/ntsb/LAX89FA091.md): Cessna 172M · Oxnard, CA · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1989 · N61587 · Destroyed > Continued VFR flight by the pilot into instrument meteorlogical conditions which resulted in an in-flight collsion with terrain. Related factors were: failure of the pilot to use a preflight briefing service, his decision to initiate flight into known adverse… - [NTSB MKC89DCG02](https://openairdocs.org/ntsb/MKC89DCG02.md): Wells Varieze · Macon, MO · Accident · 1 fatal · Final report · Jan 5, 1989 · N66WR · Destroyed > Continued flight by the pilot into known adverse weather and his failure to maintain sufficient altitude/clearance above obstacles. Contributing factors were: low ceiling, fog, rain, pilot delaying flight to an alternate destination, his lack of recent flight… - [NTSB LAX89FA078](https://openairdocs.org/ntsb/LAX89FA078.md): Piper PA-28-180 · San Bernardino, CA · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1989 · N5157L · Destroyed > The pilot's decision to continue VFR flight after encountering instrument meteorological conditions while attempting to transit through a mountain pass. Contributing factors was: the pilot's self-induced pressure knowing that a co-worker was probably waiting… - [NTSB DEN89LA057](https://openairdocs.org/ntsb/DEN89LA057.md): Bumgartner/Hirt Steen Skybolt · Quemado, NM · Accident · No injuries · Limited investigation · Final report · Jan 5, 1989 · N312BH · Substantial damage > Failure of the pilot to select a suitable landing strip/area. Factors related to the accident were: high terrain and low ceiling along the route of flight, haze, and the soft condition of the selected landing strip. - [NTSB ATL89FA066](https://openairdocs.org/ntsb/ATL89FA066.md): Piper PA-31 · Springfield, OH · Accident · 1 fatal · Field investigation · Final report · Jan 3, 1989 · N9034Y · Destroyed > Fuel exhaustion precipatated by the inadequate fuel consumption calculations performed by the pilot, pressure from the company president to not carry excess fuel and improper in-flight planning/decisions by the pilot by not refueling enroute before fuel was… - [NTSB CHI89FA040](https://openairdocs.org/ntsb/CHI89FA040.md): Piper PA-28-200 · Carmel, IN · Accident · 3 fatal · Field investigation · Final report · Jan 2, 1989 · N2CL · Destroyed > The pilot's poor understanding of the weather forecast, his failure to utilize the pitot heat in icing conditions and the exceeding of the stress limits of the aircraft. - [NTSB CHI89FA039](https://openairdocs.org/ntsb/CHI89FA039.md): Cessna 210D · Alvin, IL · Accident · 2 fatal · Field investigation · Final report · Jan 1, 1989 · N3767Y · Destroyed > Continued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain sufficient altitude. Factors related to the accident were: darkness, adverse weather conditions, the pilot's lack of instrument… - [NTSB LAX89FA076](https://openairdocs.org/ntsb/LAX89FA076.md): Piper PA-28-180 · Wrightwood, CA · Accident · 2 fatal · Field investigation · Final report · Dec 31, 1988 · N5369L · Substantial damage > According to the passenger, during a cross country flight the airplane encountered instrument meteorological conditions. The pilot flew the airplane toward a mountain range and entered a valley with rising terrain. Still in IMC, just prior to the accident,… - [NTSB NYC89IA063](https://openairdocs.org/ntsb/NYC89IA063.md): McDonnell Douglas DC-10 · Atlantic Ocean (Atlantic Ocean) · Incident · No injuries · Incident investigation · Final report · Dec 30, 1988 · N153AA · 2 aircraft · No damage > American flt 1180 (McDonnell-douglas DC-10) was northbound ovr the Atlantic Ocean at flt lvl 350 as a british royal air force vickers VC10 was cruising east at the same alt (non-standard alt for the VC10'S drctn of flt). They were in a non-radar airspace… - [NTSB ATL89LA064](https://openairdocs.org/ntsb/ATL89LA064.md): Mooney M20F · Perdido, AL · Accident · No injuries · Limited investigation · Final report · Dec 30, 1988 · N6969V · Substantial damage > While descending to 6000 feet the pilot experienced a complete loss of engine oil supply. The windscreen was covered with oil and the pilot had to use the side window to gain forward visibility. After completing the emergency landing check the engine seized.… - [NTSB DEN89LA050](https://openairdocs.org/ntsb/DEN89LA050.md): Cessna 152 II · Gilcrest, CO · Accident · No injuries · Limited investigation · Final report · Dec 29, 1988 · N46974 · Substantial damage > The plt, with his wife as a pax, departed greeley, CO, on a cross-country flt to clayton, NM. After landing, the pilot had his aircraft refueled. It took 23.5 gallons of fuel to fill the fuel tanks. The plt then took off, flew 46 miles southeast, then turned… - [NTSB MIA89LA059](https://openairdocs.org/ntsb/MIA89LA059.md): Cessna 177A · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Dec 28, 1988 · N30564 · Substantial damage > The private pilot contacted lakeland tower in flt about 2115 and was told that no fuel was available. He elected to continue flt. The pilot experienced an engine failure due to fuel exhaustion after 4 hours and 12 minutes of flight. He then executed a forced… - [NTSB FTW89LA033](https://openairdocs.org/ntsb/FTW89LA033.md): Cessna TU206D · Alamo, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 1988 · N72249 · Destroyed > Airplane's collision with trees and terrain during an attempted forced landing at night following an engine faiure. The engine failure was caused by fuel starvation as a result of a faulty fuel system which the operator had failed to correct. - [NTSB SEA89LA030](https://openairdocs.org/ntsb/SEA89LA030.md): Cessna 205 · Cottage Grove, OR · Accident · 1 fatal · Limited investigation · Final report · Dec 27, 1988 · N8403Z · Destroyed > The student pilot took off on a solo flight from an uncontrolled airport at Cottage Grove in marginal weather conditions. Shortly after takeoff, he transmitted to eugene tower (which was approximately 15 miles north) that he had encountered 'white-out'… - [NTSB CHI89LA037](https://openairdocs.org/ntsb/CHI89LA037.md): Cessna P210R · Grovertown, IN · Accident · No injuries · Limited investigation · Final report · Dec 27, 1988 · N5457A · Substantial damage - [NTSB DCA89IA016](https://openairdocs.org/ntsb/DCA89IA016.md): Boeing 727-25 · Morgantown, WV · Incident · Minor injuries · Incident investigation · Final report · Dec 26, 1988 · N8148N · Minor damage > Fuselage skin 'flapped' open between body stations 1090 and 1110 and peeled downward from stringer #4 left to stringer #5 left. A scratch or scribe mark was co-located with the longitudinal crack along stringer #4. The area of damage was located on the aft… - [NTSB ATL89DKJ01](https://openairdocs.org/ntsb/ATL89DKJ01.md): Sloan RV-4 · Russellville, AL · Accident · Serious injuries · Final report · Dec 26, 1988 · N77SA · Substantial damage > While cruising at 2500 feet with ram air gate open, engine began to run rough. The plt closed the ram air gate and applied carb heat but the engine continued to run rough and then stopped. The pilot attempted to land in an open field, clearing several large… - [NTSB LAX89FA074](https://openairdocs.org/ntsb/LAX89FA074.md): Piper PA-28-161 · Yucca, AZ · Accident · 2 fatal · Field investigation · Final report · Dec 25, 1988 · N9276M · Destroyed > Pilot's failure to maintain directional control. Contributing factors included the pilot's improper in-flight decision which was related to his overconfidence in his personal ability, spatial disorientation upon encountering inclement weather during the… - [NTSB NYC89LA057](https://openairdocs.org/ntsb/NYC89LA057.md): Piper PA-44-180T · Princeton, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 24, 1988 · N91PA · Destroyed > The acft experienced a loss of power of both engines and crashed into trees near Princeton airport, Princeton, NJ. The pilot flew 4.5 hrs and after a missed approach one engine quit. While attempting to make Princeton airport the other engine quit. According… - [NTSB LAX89FA069](https://openairdocs.org/ntsb/LAX89FA069.md): Cessna T210L · Norco, CA · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1988 · N94210 · Destroyed > Accident was that the pilot became disoriented and was unable to arrest the ensuing descending spiraling turn. - [NTSB DEN89IA047](https://openairdocs.org/ntsb/DEN89IA047.md): Cessna 210L · Roswell, NM · Incident · No injuries · Incident investigation · Final report · Dec 24, 1988 · N59217 · Minor damage > Plt preflighted acft and noted indication of 9 qts of oil in crankcase. Flt departed Roswell (row) in night VMC en route to abq. Plt had just leveled off at 6500 ft MSL when he noticed oil pressure gauge fluctuating. Oil pressure then began dropping and plt… - [NTSB LAX89LA068](https://openairdocs.org/ntsb/LAX89LA068.md): Boeing 747SP-21 · Midway Islands (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1988 · N146UA · No damage > Aircraft's encounter with unforecast severve clear turbulence. - [NTSB LAX89LA067](https://openairdocs.org/ntsb/LAX89LA067.md): Piper PA-28-181 · Victorville, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1988 · N4297X · Substantial damage > During cruise flight, the engine lost power. The pilot initiated a forced landing on an interstate. During the descent, the airplane collided with transmission wires and subsequently came to rest on interstate 15. During an inspection of the wreckage, it was… - [NTSB ATL89FA058](https://openairdocs.org/ntsb/ATL89FA058.md): Cessna 414 · Bloomville, OH · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1988 · N84UM · Destroyed - [NTSB CHI89DET02](https://openairdocs.org/ntsb/CHI89DET02.md): Cessna 150H · Benton Harbor, MI · Accident · No injuries · Final report · Dec 22, 1988 · N50331 · Substantial damage > A misjudged approach during the execution of an emergency landing resulting in an encounter with unsuitable terrain. Contributing factors are inaccurate fuel consumption calculations and fuel starvation due to contamination. - [NTSB MIA89FA054](https://openairdocs.org/ntsb/MIA89FA054.md): Cessna 310L · Cedar Key, FL · Accident · 2 fatal · Field investigation · Final report · Dec 21, 1988 · N2251F · Destroyed > The evidence indicated that personnel failed to tighten a fuel line at the fuel pressure switch on left engine resulting in fuel line leaking into the engine compartment in flight. An inflight fire burned through a fuel crossfeed fuel line which could not be… - [NTSB LAX89LA073](https://openairdocs.org/ntsb/LAX89LA073.md): Bell 206L-1 · Oakland, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 21, 1988 · N1072S · Destroyed > Pilots intentional flight into known adverse weather condititions from which he inadvertently descended into the water at a high rate of speed. Contributing to the accident was the pilot's failure to obtain a weather briefing; lack of recent instrument flying… - [NTSB ATL89LA056](https://openairdocs.org/ntsb/ATL89LA056.md): Beech A36 · Athens, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 20, 1988 · N17696 · Substantial damage > While cruising at 6,000', the plt felt an intense vibration fm the eng. Power was reduced & a descent was begun toward a nearby arpt. Before reaching the arpt, the eng lost power & an emergency wheels-up landing was made in an open field. An exam of the eng… - [NTSB MKC89LA041](https://openairdocs.org/ntsb/MKC89LA041.md): Bell 206L-1 · Linwood, KS · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1988 · N5012J · Substantial damage > Poor in-flight planning and decision, inadequate visual lookout, and clearance not attained by the pilot in command. - [NTSB NYC89LA051](https://openairdocs.org/ntsb/NYC89LA051.md): Cessna 152 · Stacyville, ME · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 1988 · N6558P · Destroyed > The student pilot became lost during a cross country flt. The flight was continued until the acft ran out of fuel. The aircraft collided with trees during an emergency landing and nosed over. The plt told the state police at the acc site that the acft had run… - [NTSB MKC89LA039](https://openairdocs.org/ntsb/MKC89LA039.md): Cessna 150 · Rolla, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 1988 · N704LB · Substantial damage > While returning from a personal cross country flight, the newly certificated private pilot said that the winds picked up and he was blown 30 miles east of his intended course. In addition, he was running one hour over the time allotted for the trip. He landed… - [NTSB CHI89DEE01](https://openairdocs.org/ntsb/CHI89DEE01.md): Cessna 210L · Bannock Burn, IL · Accident · No injuries · Final report · Dec 17, 1988 · N5225K · Substantial damage > Fuel starvation caused by ice blocked fuel lines. - [NTSB SEA89LA026](https://openairdocs.org/ntsb/SEA89LA026.md): Cessna 152 · Medford, OR · Accident · No injuries · Limited investigation · Final report · Dec 16, 1988 · N67638 · Substantial damage > The pilot departed the airport without obtaining fuel. Approximately 15 gallons of fuel was on board which would make the fuel tanks about one-half full. At the time of the accident the aircraft had been airborne for over 2 hours and 10 minutes. Dark visual… - [NTSB NYC89LA050](https://openairdocs.org/ntsb/NYC89LA050.md): Cessna 150 · Lyme, CT · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 1988 · N63136 · Substantial damage > Improper planning; the student pilot became lost and ran out of fuel. During the landing he misjudged distance, altitude and airspeed and overran the field colliding with trees. - [NTSB DEN89FA041](https://openairdocs.org/ntsb/DEN89FA041.md): Piper PA-28R-201T · Arvada, WY · Accident · 1 fatal · Field investigation · Final report · Dec 15, 1988 · N3110Q · Destroyed > The pilot entered clouds and shortly thereafter, crashed near the city of Arvada, WY. The flight consisted of two aircraft, flying together in loose formation, at night, under a layer of clouds. The plt of the lead acft estimated that about 2 min elapsed when… - [NTSB ATL89LA055](https://openairdocs.org/ntsb/ATL89LA055.md): Bellanca 17-30A · Athens, GA · Accident · No injuries · Limited investigation · Final report · Dec 12, 1988 · N14695 · Substantial damage > During descent toward his intended destination, the pilot noted a floating ammeter needle and shortly thereafter he noted his oil pressure was zero. The engine seized and he selected a straight stretch of paved road for his forced landing. In the final stages… - [NTSB NYC89LA047](https://openairdocs.org/ntsb/NYC89LA047.md): Mooney M20J · New Alexandria, PA · Accident · No injuries · Limited investigation · Final report · Dec 11, 1988 · N3820H · Substantial damage > Loss of control experience during landing rollout after an off airport landing was made due to a power loss caused by contaminated fuel. Water had been removed prior to departure. - [NTSB LAX89IA062](https://openairdocs.org/ntsb/LAX89IA062.md): Cessna 152 · Haleiwa, HI · Incident · Minor injuries · Incident investigation · Final report · Dec 11, 1988 · N94825 · Minor damage > The aircraft experienced a partial loss of power and collided with the terrain while completing an emergency landing in a sugar cane field. During this particular maneuver the CFI indicated that he was reasonably sure he cleared the engine at least once a few… - [NTSB CHI89LA031](https://openairdocs.org/ntsb/CHI89LA031.md): Cessna 150 · Varna, IL · Accident · No injuries · Limited investigation · Final report · Dec 11, 1988 · N704KV · Substantial damage > The student pilot was cruising at 2000' MSL on a solo flight, when the engine lost power. Emergency procedures were initiated and a forced landing was made in an open field. During the landing roll, the aircraft struck a dirt bank and was damaged. A… - [NTSB MKC89LA037](https://openairdocs.org/ntsb/MKC89LA037.md): Piper PA-24-250 · Jacksonville, AR · Accident · No injuries · Limited investigation · Final report · Dec 10, 1988 · N8356P · Substantial damage > During a local familarization and acceptance flight for the new acft owner, smoke entered the cockpit and oil pressure was lost. A precautionary emergency ldg was attempted on a soft, muddy, plowed farm field, resulting in substantial damage to the acft.… - [NTSB NYC89LA044](https://openairdocs.org/ntsb/NYC89LA044.md): Piper PA-34-200 · Laconia, NH · Accident · No injuries · Limited investigation · Final report · Dec 7, 1988 · N16502 · Substantial damage > Aircraft striking the road sign after the aircraft experienced a double power loss due to mismanagement of the fuel system by the pilot. - [NTSB MKC89LA031](https://openairdocs.org/ntsb/MKC89LA031.md): Bellanca 17-30 · Martelle, IA · Accident · No injuries · Limited investigation · Final report · Dec 7, 1988 · N198V · Substantial damage > Anticipating a fuel shortage on a personal cross country flight, the plt requested the nearest airport from approach control. The nearest apt was within five miles of his destination apt so continued on course. About 15 miles from his destination, and having… - [NTSB MIA89FA048](https://openairdocs.org/ntsb/MIA89FA048.md): Cessna 150J · Gainesville, FL · Accident · Serious injuries · Field investigation · Final report · Dec 7, 1988 · N60029 · Destroyed > Plt obtained weather briefing prior to departure at which time he was told the possibility of IFR conditions on arrival at destination existed due to fog. Plt failed to obtain en route weather briefing. Near his destination, the plt encountered IFR… - [NTSB LAX89LA061](https://openairdocs.org/ntsb/LAX89LA061.md): Beech K35 · Arbuckle, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 7, 1988 · N9569R · Substantial damage > During cruise flight, the pilot noted oil on the windshield. The pilot diverted to a nearby airport. Enroute the windshield became covered with oil. The pilot opted to make an emergency landing on a road. Due to power lines, he diverted to an open field. Just… - [NTSB FTW89LA031](https://openairdocs.org/ntsb/FTW89LA031.md): MBB BO-105 · South Marsh 113 · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 1988 · N2785B · Substantial damage > Failure and separation of one of the tail rotor blades for undetermined reasons. Thr resulting imbalance and vibration caused the separation of the 90 degree gearbox and a portion of the vertical pylon which necessitated the emergency autorotation to the… - [NTSB ATL89LA053](https://openairdocs.org/ntsb/ATL89LA053.md): Cessna 182P · Vidalia, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 5, 1988 · N9107M · Substantial damage > Aircraft experienced loss of power and returned to airport. Departed second time and experienced rough running engine. Aircraft attempted emergency landing and overturned in field. Examination of the engine revealed piston failure in #4 cylinder. Post acc… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=292 ## 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=291 --- 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.