# 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 300 of 718 · 35,885 cases ## Cases, newest first - [NTSB LAX88LA189](https://openairdocs.org/ntsb/LAX88LA189.md): Hiller UH-12E · Anderson, CA · Accident · No injuries · Limited investigation · Final report · May 19, 1988 · N573HA · Substantial damage > After receiving information of existing unfavorable wind conditions and that fuel was not available at the planned refueling point the pilot elected to continue the flight without refueling. As he descended on approaching his destination the engine failed due… - [NTSB LAX88FA187](https://openairdocs.org/ntsb/LAX88FA187.md): Cessna 182A · Grand Canyon, AZ · Accident · 2 fatal · Field investigation · Final report · May 18, 1988 · N4845D · Destroyed > Pilots selection of an inappropriate cruise altitude which did not ensure adequte terrain clearance on the leg of the flight from page to Grand Canyon, Arizona. A factor in the accident was the pilot's flight schedule on the day of the accident which may have… - [NTSB ANC88FA059](https://openairdocs.org/ntsb/ANC88FA059.md): Piper PA-32-260 · Skwentna, AK · Accident · 3 fatal · Field investigation · Final report · May 18, 1988 · N897P · Destroyed > The on-demand air taxi flight with the pilot and two passengers struck the rock face of a mountain at the 8600 foot level. According to witnesses at the time of the accident the weather conditions were poor and visibility was less than one-half mile. The… - [NTSB MKC88LA091](https://openairdocs.org/ntsb/MKC88LA091.md): Cessna 170B · Bayard, NE · Accident · No injuries · Limited investigation · Final report · May 17, 1988 · N4510C · Substantial damage > The pilot stated that he started the trip, from new Mexico to north dakota, the evening prior to the accident. Because of poor weather, the pilot re-routed the flight through several alternate fuel and oil stops. The flight was en route to a planned fuel stop… - [NTSB ANC88LA058](https://openairdocs.org/ntsb/ANC88LA058.md): Cessna 185E · Tuntutuliak, AK · Accident · No injuries · Limited investigation · Final report · May 17, 1988 · N1592F · Substantial damage > The private pilot-in-command of the Cessna 185 was performing business flying for the federal aviation administration. When he ran out of fuel during a cross country flight, he attempted an off-airport forced landing which resulted in a noseover accident. The… - [NTSB NYC88IA141](https://openairdocs.org/ntsb/NYC88IA141.md): Cessna S550 · Allentown, PA · Incident · No injuries · Incident investigation · Final report · May 16, 1988 · N81SH · Minor damage > While cruising at FL350 in light turbulence, the trailing half of the left hand outboard trailing edge flap separated from the acft. The pilot declared and emergency and landed at poughkeepsie, new york, without further incident. The portion of the damaged… - [NTSB ATL88DKG07](https://openairdocs.org/ntsb/ATL88DKG07.md): Grumman G164A · Clanton, AL · Accident · No injuries · Final report · May 16, 1988 · N48438 · Substantial damage - [NTSB FTW88LA102](https://openairdocs.org/ntsb/FTW88LA102.md): Piper PA-24-250 · Floresville, TX · Accident · No injuries · Limited investigation · Final report · May 15, 1988 · N2RD · Substantial damage > The engine stopped producing full power and the pilot had to make a forced landing in a pasture. During the landing roll, the airplane impacted a fence. The pilot said he found fuel in both tanks but the right tank had collapsed due to the tank vent being… - [NTSB LAX88LA181](https://openairdocs.org/ntsb/LAX88LA181.md): Fairchild M-62A-3 · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · May 14, 1988 · N46836 · Substantial damage > During a sightseeing flight, the engine suddenly quit and an emergency off-field landing was made. During the landing roll, the aircraft collided with a fence. The pilot had been operating the aircraft off of the left fuel tank. The left fuel tank was found… - [NTSB DEN88FA107](https://openairdocs.org/ntsb/DEN88FA107.md): Stinson 108-2 · Mosca, CO · Accident · 2 fatal · Field investigation · Final report · May 13, 1988 · N354C · Destroyed > After purchasing acft, plt and plt-rated friend (both airline plts) were joined by plt's wife and departed falcon field, mesa, AZ, en route to MN. The trio stopped in alamosa, CO, for night. They departed alamosa (elevation 7608 ft MSL) the next morning and… - [NTSB ATL88IA171](https://openairdocs.org/ntsb/ATL88IA171.md): Aerospatiale AS-355-F · Reidsville, NC · Incident · No injuries · Incident investigation · Final report · May 13, 1988 · N101UC · Minor damage - [NTSB BFO88FA046](https://openairdocs.org/ntsb/BFO88FA046.md): Piper PA-28-180 · Arlington, VA · Accident · Minor injuries · Field investigation · Final report · May 12, 1988 · CGGNH · Substantial damage > The acft had a total loss of eng power about 7 miles short of the destination necessitating a forced landing in a schoolyard. The acft had been flown about 4.4 hrs since it was last refueled. Examination of the acft revealed less than a gallon of fuel aboard.… - [NTSB LAX88FA331](https://openairdocs.org/ntsb/LAX88FA331.md): Beech B-35 · Ocotillo, CA · Accident · 4 fatal · Field investigation · Final report · May 11, 1988 · N8875A · Destroyed > Inflight collision with terrain for undetermined reasons. - [NTSB CHI88IA111](https://openairdocs.org/ntsb/CHI88IA111.md): Boeing 737-222 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · May 11, 1988 · N9014U · No damage - [NTSB BFO88LA045](https://openairdocs.org/ntsb/BFO88LA045.md): Mooney M-20J · Yorktown, VA · Accident · No injuries · Limited investigation · Final report · May 11, 1988 · N567MM · Destroyed > The plt was returning to the arpt after a 20 minute local flight. About 5 miles from the arpt he noticed the oil pres/temp gages indicated zero even after he checked the circuit breakers-shortly afterward the engine began to lose power and vibrate severely.… - [NTSB FTW88LA098](https://openairdocs.org/ntsb/FTW88LA098.md): Cessna 170 · Sour Lake, TX · Accident · Serious injuries · Limited investigation · Final report · May 9, 1988 · N3853V · Destroyed > The acft struck trees and the grnd during a night cross country in marginal weather. The non-instrument rated pvt plt stated that he was flying in cruise flt at 1250' MSL when he hit trees. The closest wx station recorded 1200 overcast with 5 miles… - [NTSB FTW88IA097](https://openairdocs.org/ntsb/FTW88IA097.md): Boeing 727-223 · Detroit, MI · Incident · No injuries · Incident investigation · Final report · May 9, 1988 · N800AA · Minor damage > The PIC made an unscheduled landing following decompression at 30,000 feet. The aircraft had been written up by flightcrews numerous times between may 7 and may 9 for pressurization problems. Pressure bulkhead at station 940 in the right wheel well cracked 15… - [NTSB LAX88FA192](https://openairdocs.org/ntsb/LAX88FA192.md): Beech 35 · Santa Paula, CA · Accident · 2 fatal · Field investigation · Final report · May 7, 1988 · N3322V · Destroyed > Pilot's failure to maintain an airspeed at which the aircraft is controllable and above the stall speed. - [NTSB DEN88FA106](https://openairdocs.org/ntsb/DEN88FA106.md): Bell 47G-3B1 · Cortez, CO · Accident · 1 fatal · Field investigation · Final report · May 7, 1988 · N8455E · Destroyed > The plt said that he had just taken off and reached an alt of about 300 ft when his collective control went 'limp'. The helicopter entered a descent, partially controlled by the plt using throttle and cyclic control inputs. The helicopter touched down in soft… - [NTSB MIA88LA164](https://openairdocs.org/ntsb/MIA88LA164.md): Piper PA-28-140 · Everglades City, FL · Accident · No injuries · Limited investigation · Final report · May 6, 1988 · N285DP · Substantial damage > The plt stated when the flt departed, there was 33 gals of fuel aboard for the x-c daylight flight. Fuel burn for the acft was approx 8 gph. The flt to the dest required about 1.5 hrs. The plt stated that he intended to refuel at his destination, but the FBO… - [NTSB MKC88FA085](https://openairdocs.org/ntsb/MKC88FA085.md): Cessna 182K · Neligh, NE · Accident · Serious injuries · Field investigation · Final report · May 5, 1988 · N2872R · Substantial damage > None submitted - [NTSB MIA88LA166](https://openairdocs.org/ntsb/MIA88LA166.md): Piper PA-28-161 · Freeport, Bahamas · Accident · No injuries · Limited investigation · Final report · May 4, 1988 · N8068J · Substantial damage > The pilot's inadvertent encounter with adverse weather. - [NTSB MIA88LA163](https://openairdocs.org/ntsb/MIA88LA163.md): Beech 58 · Centerville, MS · Accident · No injuries · Limited investigation · Final report · May 2, 1988 · N7353R · Substantial damage > The pilot stated that he thought the aircraft had been refueled the previous evening. During preflight he did not observe any fuel in the aircraft fuel tanks. He further stated that the aircraft fuel quantity guages had been unreliable. In cruise flight both… - [NTSB DCA88IA056](https://openairdocs.org/ntsb/DCA88IA056.md): Boeing 747-123 · Nr Tokyo, Japan · Incident · No injuries · Incident investigation · Final report · May 2, 1988 · N157UA · Minor damage > United flt 97 experienced indications of uneven fuel flow from main tanks 2 and 3 at FL360 beginning about 4- hours after departure on an 11-hour transpacific flight. The fuel system had been set up for all engine feed from the nos 2 and 3 tanks. Although it… - [NTSB MKC88FA082](https://openairdocs.org/ntsb/MKC88FA082.md): Cessna 180 · Rolla, MO · Accident · Serious injuries · Field investigation · Final report · May 1, 1988 · N9161C · Substantial damage > As the pilot approached the Rolla, Missouri airport he stated that he switched the fuel tank selector from the right tank to both tanks in preparation for landing. The pilot stated that he did not know which direction he moved the fuel selector valve. Engine… - [NTSB BFO88LA042](https://openairdocs.org/ntsb/BFO88LA042.md): Cessna 170 · Mechanicsville, MD · Accident · Minor injuries · Limited investigation · Final report · May 1, 1988 · N4022V · Substantial damage > The acft was flown with the engine cowling plugs installed. The engine overheated and it lost power. The plt said he forgot to remove the plugs during the preflight. During the forced landing roll the acft collided with a berm and the rt main lndg gear was… - [NTSB NYC88LA132](https://openairdocs.org/ntsb/NYC88LA132.md): Piper PA-28-181 · Jamestown, NY · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 1988 · N5688V · Substantial damage > The Piper PA-28-181 departed with two pilots onboard. About one hour after takeoff, the PIC got very sick and could not continue flying. She experienced a severe headache and vomitting. The non-instrument rated pilot continued the flight. The aircraft made… - [NTSB LAX88LA172](https://openairdocs.org/ntsb/LAX88LA172.md): Cessna 150F · Westlake, CA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1988 · N8008S · Substantial damage > During a banner towing operation, the plt had just transferred fuel from the aux tank to the mains. Two minutes later the engine quit. A forced landing was made in a field where the acft collided with the terrain. The engine was inspected and ran for several… - [NTSB MKC88LA081](https://openairdocs.org/ntsb/MKC88LA081.md): Cessna 152 · Dexter, MO · Accident · No injuries · Limited investigation · Final report · Apr 29, 1988 · N25038 · Substantial damage > Shortly after takeoff, during an instructional night cross country training flt, the CFI said he began to lose engine RPM. He made a 180 degree turn to return to the departure apt, when he had a complete power failure. An emergency ldg was made on a freshly… - [NTSB CHI88LA104](https://openairdocs.org/ntsb/CHI88LA104.md): Beech K35 · Milaca, MN · Accident · No injuries · Limited investigation · Final report · Apr 29, 1988 · N6042E · Substantial damage - [NTSB ATL88LA159](https://openairdocs.org/ntsb/ATL88LA159.md): Cessna 150J · Sandy Ridge, NC · Accident · No injuries · Limited investigation · Final report · Apr 29, 1988 · N60276 · Substantial damage > The aircraft engine began to vibrate excessively and lost power. The pilot landed the aircraft in a field. The aircraft nosed over in the soft ground. Examination of the engine revealed that the number one cylinder valve spring seat lock had failed allowing… - [NTSB DCA88MA054](https://openairdocs.org/ntsb/DCA88MA054.md): Boeing 737-297 · Maui, HI · Accident · 1 fatal · Major investigation · Final report · Apr 28, 1988 · N73711 · Substantial damage > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-89/03. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm Flt… - [NTSB BFO88LA035](https://openairdocs.org/ntsb/BFO88LA035.md): Cessna 172 · Elkton, MD · Accident · No injuries · Limited investigation · Final report · Apr 28, 1988 · N4255F · Substantial damage > During cruise flt at an alt of 1500 ft, the engine suddenly stopped producing power. The acft was landed on railroad tracks in order to avoid trees. The acft nosed over during the landing. Plt stated that the right fuel tank gauge indicated 1/4 tank and the… - [NTSB ATL88LA156](https://openairdocs.org/ntsb/ATL88LA156.md): Cessna 152 · Danville, OH · Accident · No injuries · Limited investigation · Final report · Apr 26, 1988 · N4835B · Substantial damage > The plt reported that the engine began to run rough about 2 hrs & 45 minutes into the low-level aerial photo flt. The engine subsequently lost power altogether and the plt made a forced ldg in a marsh. The airplane nosed over during the ldg. Post-crash exam… - [NTSB SEA88FA084](https://openairdocs.org/ntsb/SEA88FA084.md): Maule M5-210C · Bend, OR · Accident · 1 fatal · Field investigation · Final report · Apr 25, 1988 · N312X · Destroyed > Plt filed VFR after advised VFR not recommended. Witness observed acft on course for dest at low alt over hiway. Witness EST ceiling at 100 feet, visibility poor in mod snow. Acft observed to execute sharp left turn amd impact rising terrain. Corrective… - [NTSB MKC88LA079](https://openairdocs.org/ntsb/MKC88LA079.md): Cessna 310P · Berryville, AR · Accident · No injuries · Limited investigation · Final report · Apr 25, 1988 · N5873M · Substantial damage > While trying out his friend's newly purchased twin, the pilot stated an emergency landing was made due to power loss because of fuel starvation. The PIC said he was negligent because he did not possess a multiengine rating and also did not study the fuel… - [NTSB ANC88LA049](https://openairdocs.org/ntsb/ANC88LA049.md): Cessna 337D · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Apr 23, 1988 · N86128 · Substantial damage > The private pilot was practicing simulated instrument flight with his flight instructor in their mutually-owned airplane, when both engines quit within minutes of each other due to fuel exhaustion. The airplane struck trees in the ensuing emergency descent… - [NTSB ATL88LA153](https://openairdocs.org/ntsb/ATL88LA153.md): Grumman American AA-1B · Memphis, TN · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1988 · N9603L · Substantial damage > The pilot reported that the engine lost pwr in-flt due to fuel exhaustion. A forced ldg was made in a plowed field. The airplane nosed over during the ldg. The plt noted after the accident that he should have topped off the fuel tanks prior to departure. The… - [NTSB ATL88IA146](https://openairdocs.org/ntsb/ATL88IA146.md): de Havilland DHC-8-101/102 · Dothan, AL · Incident · No injuries · Incident investigation · Final report · Apr 22, 1988 · N804MX · Minor damage > During cruise flight at 12,000 ft, the flight crew of the DHC-8 observed a low oil pressure warning light. About five seconds later, the right engine fire warning light illuminated. Fire was confirmed and the extinguisher discharged. The fire was extinguished… - [NTSB MIA88LA156](https://openairdocs.org/ntsb/MIA88LA156.md): Mooney M-20J · Perry, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 21, 1988 · N58110 · Destroyed > Jacksonville center reported a loss of radar contact with the acft at approx 2133 EDT after it descended from its last assigned altitude of 6000 feet. The sole occupant and debris from the acft were found shortly thereafter. The results of an autopsy on the… - [NTSB DEN88FA100](https://openairdocs.org/ntsb/DEN88FA100.md): Cessna 182J · Rapid City, SD · Accident · 2 fatal · Field investigation · Final report · Apr 21, 1988 · N2720F · Destroyed > The plt received a wx briefing prior to departure from miles city, MT. The briefing indicated wx conditions less than VFR with icing conditions. The plt departed and landed approximately 1 hour later to remove ice from his acft. The plt departed a second time… - [NTSB CHI88LA099](https://openairdocs.org/ntsb/CHI88LA099.md): Cessna 150M · Zeigler, IL · Accident · No injuries · Limited investigation · Final report · Apr 21, 1988 · N9410U · Substantial damage > Upon completion of a practice emergency landing procedure during an instructional flight, the engine started to run rough and then quit. The instructor was able to regain partial power, and made forced landing in freshly plowed field. The aircraft nosed over… - [NTSB DEN88FA099](https://openairdocs.org/ntsb/DEN88FA099.md): Beech A23-19 · Gunnison, CO · Accident · 2 fatal · Field investigation · Final report · Apr 20, 1988 · N7979L · Destroyed > On a cross country flt, the plt attempted to climb through a pass which was above the effective service ceiling of the acft. At approximately the effective service ceiling of the acft the acft collided with terrain. The acft was destroyed by impact and post… - [NTSB FTW88LA091](https://openairdocs.org/ntsb/FTW88LA091.md): Cessna 150M · Azle, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 19, 1988 · N704MF · Destroyed > The operator stated the night instrument training flight departed with 8.5 gallons of fuel. One hour and thirty minutes later, the airplane hit a tree during flare for a forced landing due to engine failure. The student stated the fuel gage indicated one… - [NTSB FTW88IA092](https://openairdocs.org/ntsb/FTW88IA092.md): Piper PA-31-350 · Henderson, TX · Incident · No injuries · Incident investigation · Final report · Apr 19, 1988 · N59981 · No damage > The pilot experienced total loss of power from the left engine and a partial loss of power from the right engine due to fuel starvation. The main fuel tanks on which the engines were operating were found empty but there was an adequate fuel supply in the… - [NTSB MIA88LA155](https://openairdocs.org/ntsb/MIA88LA155.md): Piper PA-38-112 · Mcdavid, FL · Accident · No injuries · Limited investigation · Final report · Apr 18, 1988 · N2322F · Substantial damage > The plt stated that the flt was 15 miles from the destination & had been diverted due to haze. While flying at an alt of aprox 2,000 ft, the eng quit due to non-mechanical reasons. He was unable to restart it. The plt landed the a/c on a road, during which… - [NTSB MIA88LA204](https://openairdocs.org/ntsb/MIA88LA204.md): Piper PA-32-300 · Fort Myers, FL · Accident · No injuries · Limited investigation · Final report · Apr 17, 1988 · N2032M · Substantial damage > While en route, on a personal cross country flt, the alternator belt broke resulting in the loss of electrical power which the plt did not recognize before the battery had been drained. During the precautionary landing the acft landed hard resulting in… - [NTSB LAX88LA164](https://openairdocs.org/ntsb/LAX88LA164.md): Bellanca 8GCBC · Florence, AZ · Accident · No injuries · Limited investigation · Final report · Apr 17, 1988 · N5504S · Substantial damage > During a cross country flight, the engine suddenly quit, restarted, then quit completely. A forced landing was made in a dry wash where the aircraft nosed over during the landing roll. Approximately 4 gallons of fuel was drained from the fuel system. There… - [NTSB LAX88FA168](https://openairdocs.org/ntsb/LAX88FA168.md): Piper PA-28-140 · Essex, CA · Accident · 2 fatal · Field investigation · Final report · Apr 17, 1988 · N1681J · Destroyed > Failure of the pilot to maintain sufficient altitude to ensure terrain clearance while mountain flying. - [NTSB BFO88FIG01](https://openairdocs.org/ntsb/BFO88FIG01.md): Cessna 152 · Annapolis, MD · Accident · Minor injuries · Final report · Apr 17, 1988 · N5269H · Substantial damage > The stu & instr were returning to mitchellville after doing several touch & go landings at stevensville. The acft was level at 1700 ft when a power loss occurred. Attempts to restart the engine were unsuccessful. The instr took control of the acft and landed… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=301 ## 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=300 --- 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.