# 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 297 of 718 · 35,885 cases ## Cases, newest first - [NTSB ANC88LA101](https://openairdocs.org/ntsb/ANC88LA101.md): Piper PA-28-140 · Pilot Point, AK · Accident · No injuries · Limited investigation · Final report · Jul 30, 1988 · N2212F · Substantial damage > The non-certificated Pilot reported that he had just purchased the accident airplane the preceding day, and had only flown it for a period of two hours or so. On the accident flight, he had been airborne less than 10 minutes when the engine reportedly began… - [NTSB MKC88LA142](https://openairdocs.org/ntsb/MKC88LA142.md): Shirlan Dickey E-RACER · Dubuque, IA · Accident · No injuries · Limited investigation · Final report · Jul 29, 1988 · N131RD · Substantial damage > At a fuel stop in Dubuque, IA the PIC purchased fuel for the final leg of his flt to oshkosh. After a pre-flt chk and subsequent eng runup, the PIC took the active rwy and commenced a takeoff roll. The lift off and initial climb went without difficulty until… - [NTSB LAX88FA273](https://openairdocs.org/ntsb/LAX88FA273.md): Rearwin 8500 · Glendale, CA · Accident · Minor injuries · Field investigation · Final report · Jul 29, 1988 · N15855 · Substantial damage > Seperation of an engine cylinder that moved into the plane of the wooden propeller blades. The propeller blades were sheared by the dislodged cylinder. The rough landing surface contributed to the accident. - [NTSB ATL88LA221](https://openairdocs.org/ntsb/ATL88LA221.md): Cessna 182A · Elberta, AL · Accident · No injuries · Limited investigation · Final report · Jul 28, 1988 · N4090D · Substantial damage > The plt was on a x-country flt from Elberta, AL, to destin, FL & return. The flt included 4 en route stops to pick up & drop off pax. During an en route stop, the plt checked the fuel by using a home made dip stick & he thought there was sufficient fuel to… - [NTSB MKC88LA137](https://openairdocs.org/ntsb/MKC88LA137.md): Grumman G164B · Knobel, AR · Accident · No injuries · Limited investigation · Final report · Jul 26, 1988 · N2500W · Substantial damage > The plt said he had just completed an aerial application operation and was returning to his base airfield to re-load. While in a low level cruise, the engine quit abruptly, and an emergency ldg was attempted in a soft, muddy soy bean field. During the ldg… - [NTSB MIA88LA237](https://openairdocs.org/ntsb/MIA88LA237.md): Mooney M-20E · Punta Gorda, FL · Accident · No injuries · Limited investigation · Final report · Jul 26, 1988 · N9369M · Substantial damage > The plt stated he kept his acft outdoors & he had not flown it for 7 days. He stated he had not refueled the acft after the last flt & had parked it with 1/2 tanks. Fss personnel stated there had been rain showers in the area during that time. The plt stated… - [NTSB FTW88IA141](https://openairdocs.org/ntsb/FTW88IA141.md): Boeing 737-300 · Kenton, DE · Incident · No injuries · Incident investigation · Final report · Jul 26, 1988 · N14336 · Minor damage > A flameout of the #1 engine occurred due to water ingestion when the aircraft penetrated a vip level 5 thunderstorm and encountered heavy rain while descending with the throttles a flight idle. The engine suffered overtemperature damage to the turbine section… - [NTSB MIA88LA236](https://openairdocs.org/ntsb/MIA88LA236.md): Piper PA-60-700P · Cocoa Beach, FL · Accident · 1 fatal · Limited investigation · Final report · Jul 25, 1988 · N69RB · Destroyed > Flt entered near vertical descent while flying in area of level 1 and 2 thunderstorms just after plt had called requesting permission to deviate around rain showers. A level 5 thunderstorm was present 8 miles west. The acft descended at rates up to 13,800… - [NTSB ATL88FA220](https://openairdocs.org/ntsb/ATL88FA220.md): Piper PA-28-151 · La Grange, GA · Accident · No injuries · Field investigation · Final report · Jul 25, 1988 · N4506F · Substantial damage > The PIC stated he had a hardover in the single axis autopilot which resulted in the acft constantly turning right. Therefore due to the continous bank he elected to make a precautionary landing in a lake versus on land. The acft impacted in a lake left of the… - [NTSB MKC88LA135](https://openairdocs.org/ntsb/MKC88LA135.md): Mooney M20-F · Lawrence, KS · Accident · No injuries · Limited investigation · Final report · Jul 24, 1988 · N6347Q · Substantial damage > The pilot said the engine quit due to fuel exhaustion during a personal cross country flight. He said he tried to glide to his final destination airport, but made an emergency ldg in a farm field about 2 miles short of the airport. - [NTSB MIA88LA233](https://openairdocs.org/ntsb/MIA88LA233.md): Cessna 310 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Jul 24, 1988 · N638E · Substantial damage > While on a personal flt during normal cruise both engs quit due to fuel exhaustion. The plt attempted to land the acft on a road, after which it departed the road surface, and collided with trees. The plt did not file an acc report. - [NTSB MIA88FA234](https://openairdocs.org/ntsb/MIA88FA234.md): Bellanca 17-30A · Daytona Beach, FL · Accident · 1 fatal · Field investigation · Final report · Jul 24, 1988 · N28140 · Destroyed > The acft departed spruce creek arpt and aprx 2 minutes later lost power and crashed into trees just west of the volusia county landfill aprx 4 miles northeast of the Daytona Beach regional arpt. Postcrash examination of the engine revealed the drain line on… - [NTSB BFO88FA068](https://openairdocs.org/ntsb/BFO88FA068.md): Cessna R182RG · Stevensville, MD · Accident · 2 fatal · Field investigation · Final report · Jul 24, 1988 · N9997C · Destroyed > The acft departed bay bridge arpt at aprx 0415 EDT. The passenger, also a plt, was reading back an IFR clearance to ATC when communication ended in the middle of a sentence without any sign of distress. Comparison of ATC and radar tapes indicates that N9997C… - [NTSB SEA88LA137](https://openairdocs.org/ntsb/SEA88LA137.md): Cessna 172 · Coeur D'Alene, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1988 · N8109B · Substantial damage > After low pass over intended landing area, acft would not outclimb rising terrain in canyon. Plt mushed into brushy clearcut area rather than collide with rough terrain. Plt report stated finding of low compression on 3 cyls. Density altitude estimated at… - [NTSB FTW88DPA04](https://openairdocs.org/ntsb/FTW88DPA04.md): Atkins ACRO-SPORT · Fort Worth, TX · Accident · No injuries · Final report · Jul 22, 1988 · N5897 · Substantial damage > During a personal flight, the engine failed and the pilot made a forced landing into an open field. During the landing, the airplane flipped to the inverted position. Investigation revealed no fuel in the tank or fuel system and no fuel spilled on the ground. - [NTSB CHI88LA171](https://openairdocs.org/ntsb/CHI88LA171.md): Cessna 182E · Cedar Springs, MI · Accident · No injuries · Limited investigation · Final report · Jul 22, 1988 · N2859Y · Substantial damage > During cruise flight the pilot reported that a total power loss occurred. The pilot executed a forced landing in an open field. On rollout the aircraft struck a stump and then a small shed. The post accident investigation revealed loosefuel caps and no fuel… - [NTSB CHI88DEP07](https://openairdocs.org/ntsb/CHI88DEP07.md): Cessna 182B · Burlington, WI · Accident · No injuries · Final report · Jul 22, 1988 · N2486G · Substantial damage > Drg a normal dscnt, in preparation to land, the eng lost all power. The plt made an emerg landing, but drg the landing roll-out, the nosewheel enctrd soft, uneven terrain & the acft nosed over. No fuel was found in the fuel tanks or carburetor float bowl, but… - [NTSB LAX88LA267](https://openairdocs.org/ntsb/LAX88LA267.md): Piper PA-24-250 · Chico, CA · Accident · No injuries · Limited investigation · Final report · Jul 21, 1988 · N6441P · Substantial damage > During a cross country flight, the pilot noted a loss of oil pressure. Shortly after, the pilot heard a loud bang and the engine lost power. A forced landing was made short of the airport where the airplane collided with the terrain during the landing roll.… - [NTSB LAX88DUJ05](https://openairdocs.org/ntsb/LAX88DUJ05.md): Grumman G-164B · Parker, AZ · Accident · Minor injuries · Final report · Jul 21, 1988 · N6747Q · Destroyed > During an aerial application flight, the pilot dispensed the load and was returning to the airstrip due to an approaching thunderstorm. Enroute, the visibility was reduced to near zero from blowing dust. The pilot lost control of the airplane and collided… - [NTSB FTW88FA136](https://openairdocs.org/ntsb/FTW88FA136.md): Douglas DC-6A · Golden Meadow, LA · Accident · 3 fatal · Field investigation · Final report · Jul 21, 1988 · N33VX · Destroyed > After abt 4.3 hrs on an overwater flt, the crew rprtd they had 15 min of fuel remaining. Subsequently, 3 of 4 engs lost pwr fm fuel exhaustion. Drg an emerg lndg, the acft hit a levee & was extensively dmgd. Most of the wreckage came to rest in a dainage… - [NTSB LAX88LA265](https://openairdocs.org/ntsb/LAX88LA265.md): Cessna 152 · Dixon, CA · Accident · No injuries · Limited investigation · Final report · Jul 20, 1988 · N6469M · 2 aircraft · Substantial damage > The plts stated that while they were cruising in close formation, the rgt wing of one acft (Cessna 152, N6469M) raised up & collided with the left main lndg gear of the other acft (Cessna 152, N6239H). N6469M received substantial damage to the wing & N6239H… - [NTSB FTW88DPJ08](https://openairdocs.org/ntsb/FTW88DPJ08.md): Cessna 152 · Heavener, OK · Accident · Minor injuries · Final report · Jul 20, 1988 · N68700 · Substantial damage > During a cross country training flight, the non-instrument rated pilot flew into IMC conditions while descending. The pilot attempted to climb into VFR conditions but when that was not successful a descent was begun in an effort to breakout into VFR… - [NTSB CHI88LA170](https://openairdocs.org/ntsb/CHI88LA170.md): Piper PA-32R-301T · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Jul 20, 1988 · N8069S · Substantial damage > During climbout after takeoff, the pilot experienced an engine fire and diverted to Chicago's midway airport for an emergency landing. The pilot executed emergency procedures, shut down the engine, the fuel supply, and all electrical load. When the pilot knew… - [NTSB NYC88LA189](https://openairdocs.org/ntsb/NYC88LA189.md): Balloon Works Firefly 7 · Saltsburg, PA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1988 · N1534W · Substantial damage > The plt launched on a local Balloon sight-seeing flight at 1850 local time with the forecast of thunderstorm activity to commence in the area after midnight. After 40 mins of smooth flt, the temp dropped sharply and shortly thereafter turbulence was… - [NTSB MIA88LA227](https://openairdocs.org/ntsb/MIA88LA227.md): Piper PA-34-200T · St. Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Jul 18, 1988 · N11RJ · Destroyed > The 27 yr old plt purchased the acft about 2 weeks before the accident & had received his multi-eng rating about 3 weeks before. His total multi eng time was about 35 hrs. Nearing his destination, 1 eng quit. A few moments later, the other quit & the plt… - [NTSB LAX88LA266](https://openairdocs.org/ntsb/LAX88LA266.md): Bellanca 17-30A · Springerville, AZ · Accident · No injuries · Limited investigation · Final report · Jul 18, 1988 · N14683 · Substantial damage > Shortly after takeoff, the engine experienced a loss of power. The pilot made a forced landing where during the landing roll, the airplane collided with the terrain. During the engine inspection, it was found that the left magneto fired only one sparkplug.… - [NTSB MKC88LA128](https://openairdocs.org/ntsb/MKC88LA128.md): Eagle DW-1 · Holdrege, NE · Accident · No injuries · Limited investigation · Final report · Jul 17, 1988 · N8806B · Substantial damage > The plt said that after completing a spraying operation and depleting his chemical load, he flew to a near-by farm field to check it over. Enroute, the engine quit, and attempts to restart it were unsuccessful. An emergency ldg was attempted in a plowed farm… - [NTSB LAX88LA262](https://openairdocs.org/ntsb/LAX88LA262.md): Cessna 150K · Dana Point, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1988 · N6226G · Destroyed > During a fish spotting operation over the ocean, the engine began to run rough and vibrate. The engine quit completely shortly thereafter and the airplane was ditched in the ocean. The airplane was not recovered. The plt stated that the eng lost power then… - [NTSB CHI88LA167](https://openairdocs.org/ntsb/CHI88LA167.md): Cessna 177RG · Mankato, MN · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1988 · N2059Q · Substantial damage > As the pilot leveled off at his intended cruise altitude, he noted a loss of oil pressure, then saw oil spread up over the windshield, restricting his visibility. The pilot performed emergency procedures, and began descending to the nearest airport. During… - [NTSB CHI88DEE06](https://openairdocs.org/ntsb/CHI88DEE06.md): Piper PA-25 · Chebanse, IL · Accident · No injuries · Final report · Jul 17, 1988 · N8807L · Substantial damage > The acft had been refueled with pilot's stated quantity of 20 gals of fuel. After completing his spray operation and returning to base he stated 'ran out of gas'. Acft had been airborne 1 + 15 plus taxi and engine runup. - [NTSB NYC88LA188](https://openairdocs.org/ntsb/NYC88LA188.md): Fantasy Sky Promotions AX-7 · Wellsville, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 16, 1988 · CGDGK · Minor damage > About 35 hot air balloons were entered in the great Wellsville balloon rally. At 0625 EDT, the plt (of c-gdgk) attended a wx briefing that was given to the plts by the balloonmeister. The plt said the balloonmeister indicated that there would be suitable… - [NTSB MIA88FA223](https://openairdocs.org/ntsb/MIA88FA223.md): Rockwell 100-180 · Paxton, FL · Accident · Serious injuries · Field investigation · Final report · Jul 16, 1988 · N3603X · Substantial damage > Plt's license was suspended at time of accident and his medical certificate was expired. Plt failed to get weather briefing prior to departure. Plt continued flt into deteriorating weather conditions and while attempting to land at a private airport due to… - [NTSB CHI88DEM07](https://openairdocs.org/ntsb/CHI88DEM07.md): Silliman Hatz CB-1 · Battlecreek, MI · Accident · No injuries · Final report · Jul 16, 1988 · N24DS · Substantial damage > While attempting to execute a forced landing due to an engine failure, the pilot misjudged his emergency procedure and collided with trees then the gnd during the descent to the fairway he had selected for landing. The engine failure was due to fuel… - [NTSB SEA88LA132](https://openairdocs.org/ntsb/SEA88LA132.md): De Havilland DHC-3 · Wrangell, AK · Accident · No injuries · Limited investigation · Final report · Jul 15, 1988 · N55CX · Substantial damage > Plt attempted flight through a mountain pass in the presence of low clouds and fog. Visual ground reference was lost and the acft collided with a snow bank. Plt cited personal and company-induced pressures as factors. Operator completed accident report. - [NTSB MKC88LA127](https://openairdocs.org/ntsb/MKC88LA127.md): Aero Commander 100-180 · Lowell, AR · Accident · No injuries · Limited investigation · Final report · Jul 15, 1988 · N3738X · Substantial damage > About one hour after takeoff, the plt noted that the eng began to run rough. He reduced the power to 2000 RPM & enriched the mixture. He continued flying for about another hour, then the eng lost power. The plt attempted an emergency landing on a frontage… - [NTSB LAX88LA268](https://openairdocs.org/ntsb/LAX88LA268.md): Raven S-60A · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Jul 15, 1988 · N2789Z · Substantial damage > During a sightseeing flight, while on final approach, the balloon collided with power lines. The wires arced starting a fire which damaged the balloon envelope. The plt did not file an acc report. The plts last medical exam was on 7/3/79. - [NTSB LAX88LA257](https://openairdocs.org/ntsb/LAX88LA257.md): Cessna 172K · Palmdale, CA · Accident · No injuries · Limited investigation · Final report · Jul 15, 1988 · N46373 · Substantial damage > While cruising at 9500 feet, the pilot noted that the oil pressure was low. Shortly after, the engine quit. The pilot turned toward an airport, however, the airplane was landed short of the runway and nosed over in soft sand during the landing roll.… - [NTSB NYC88FA181](https://openairdocs.org/ntsb/NYC88FA181.md): Cessna 421 · Taunton, MA · Accident · 1 fatal · Field investigation · Final report · Jul 14, 1988 · N825DW · Destroyed > Bfr rchg his destn, the plt adzd apch ctl that his rgt eng was 'blowing some smoke' & losing oil pressure. Vectors were provided for a visual apch, but there were low clouds in the area & vis was restricted due to haze. After reaching the vcnty of the arpt,… - [NTSB LAX88FA256](https://openairdocs.org/ntsb/LAX88FA256.md): Cessna T210M · Carson, CA · Accident · Serious injuries · Field investigation · Final report · Jul 14, 1988 · N732QZ · Destroyed > The pilot failed to follow the emergency procedures as outlined in the pilot operating handbook by switching the fuel selector to the fullest tank. Contributing to this accident was fuel exhaustion of the right wing tank as a result of fuel siphoning. - [NTSB DEN88LA156](https://openairdocs.org/ntsb/DEN88LA156.md): Cessna 152 · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Jul 14, 1988 · N48055 · Substantial damage > Prior to takeoff from the 6469 ft MSL airport, the pilot leaned the mixture at 2000 RPM. Density altitude was aprx 9100 ft MSL. The 10-DEG flap takeoff and climbout to 300 ft AGL was said to be normal initially; then the aircraft began losing altitude… - [NTSB SEA88LA126](https://openairdocs.org/ntsb/SEA88LA126.md): Beech C23 · The Dalles, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1988 · N18823 · Substantial damage > CFI underestimated fuel consumption on multi-stop cross country and did not visually check fuel remaining prior to last departure. Fuel exhaustion occurred 18 minutes into flight. Acft flipped inverted on forced landing. - [NTSB MKC88FA124](https://openairdocs.org/ntsb/MKC88FA124.md): Cessna 172G · Sarcoxie, MO · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1988 · N4288L · Destroyed > Witnesses at the acdnt site characterized the wx as having a low ceiling with fog. They rprtd they saw the acft 'appear out of clouds' in a steep descent. The acft then began to 'pull up;' however, during recovery from the dive, the acft struck trees &… - [NTSB MIA88LA221](https://openairdocs.org/ntsb/MIA88LA221.md): Hahn RV-4 · Zellwood, FL · Accident · No injuries · Limited investigation · Final report · Jul 13, 1988 · N144TH · Substantial damage > Flt experienced rough running engine and loss of power. As acft was turned toward agricultural strip for an emergency landing the engine failed completely. The plt touched down short of the runway and bogged down in tall grass and muck causing collapse of the… - [NTSB NYC88LA178](https://openairdocs.org/ntsb/NYC88LA178.md): Champion 7GBC · Staten Island, NY · Accident · No injuries · Limited investigation · Final report · Jul 10, 1988 · N7523F · Destroyed > The pilot stated that after flying into a thunderstorm he encountered strong turbulence, heavy downdrafts and rain, which forced him into the water. When he realized that he was going down he dropped the banner he was towing 'but the airplane didn't want to… - [NTSB MKC88LA121](https://openairdocs.org/ntsb/MKC88LA121.md): Beech A-60 · Lexington, MO · Accident · No injuries · Limited investigation · Final report · Jul 9, 1988 · N7578D · Substantial damage > The pilot failed to provide the aircraft with a fuel supply adequate to complete the proposed flight and the pilots failure to maintain directional control of the aircraft during the landing roll on the active runway. - [NTSB LAX88LA250](https://openairdocs.org/ntsb/LAX88LA250.md): Cessna TU206G · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1988 · N6106U · Substantial damage > During a local flight, the pilot noted that the oil pressure was low. En route to the airport, the engine quit. A forced landing was made on a road where during the landing the airplane collided with telephone wires and subsequently the terrain. Inspection of… - [NTSB MKC88FA119](https://openairdocs.org/ntsb/MKC88FA119.md): Cessna 320 · Atwood, KS · Accident · 4 fatal · Field investigation · Final report · Jul 7, 1988 · N320DB · Destroyed > The PIC had deptd the denver metro area carrying pax to vacation in Indiana. No flt plan was filed and there was no record of a preflt wx brief. The flt progrsd without any known difficulty until reaching the colorodo/kansas border. The PIC rqstd and rcvd wx… - [NTSB DEN88LA148](https://openairdocs.org/ntsb/DEN88LA148.md): Beech A36 · Craig, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1988 · N6051M · Substantial damage > While on final after a 4.6 hr x-cnty flight, the pilot reported that the engine quit. The plt said that the engine probably failed due to fuel exhaustion. Personnel at the wreckage site reported no fuel was found in the fuel tanks. After the engine failed,… - [NTSB CHI88IA157](https://openairdocs.org/ntsb/CHI88IA157.md): Beech C99 · Indianapolis, IN · Incident · No injuries · Incident investigation · Final report · Jul 7, 1988 · N3063W · Minor damage > Component failure due to improper lubrication by the operators maintenance personnel. - [NTSB ATL88FA211](https://openairdocs.org/ntsb/ATL88FA211.md): Cessna 175 · Ninety Six, SC · Accident · Serious injuries · Field investigation · Final report · Jul 7, 1988 · N6509E · Destroyed > The pilot was cruising the airplane at 2,000 feet AGL when he noted a loss of oil pressure and increase in oil temperature. He also noted a loss in engine power. He elected to make a landing off airport and set up a pattern for the selected field. The… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=298 ## 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=297 --- 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.