# 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 299 of 718 · 35,885 cases ## Cases, newest first - [NTSB MIA88LA198](https://openairdocs.org/ntsb/MIA88LA198.md): Hughes 369D · Horn Lake, MS · Accident · No injuries · Limited investigation · Final report · Jun 19, 1988 · N1109P · Substantial damage > Bfr tkof, the helicopter was svcd with 100LL fuel (an approved altn fuel if the boost pump is used in flt). Drg flt, theeng lost pwr. An autorotation was made in tall vegetation, but drg the lndg, the main rotor blades severed the tail boom. An inspn of the… - [NTSB SEA88FA113](https://openairdocs.org/ntsb/SEA88FA113.md): Beech 58P · Bellevue, WA · Accident · Minor injuries · Field investigation · Final report · Jun 18, 1988 · N17795 · Destroyed > The plt reported that 20 gallons of fuel was added on may 18 and stated this brought the main tanks up to near full (160 gal). Between that fueling and the acc a total of 6.0 hours were recorded and an additional 80 gallons of fuel was added. Records at the… - [NTSB NYC88LA169](https://openairdocs.org/ntsb/NYC88LA169.md): Robinson R22HP · Copake Falls, NY · Accident · No injuries · Limited investigation · Final report · Jun 18, 1988 · N622SC · Substantial damage > During a practice autorotation to an open field, the aircraft struck a wire that had not been observed. An attempt to fly over the wire was unsuccessful and the tail rotor and aft 1/3 of the tail cone was severed from the helicopter. A hovering autorotation… - [NTSB BFO88LA055](https://openairdocs.org/ntsb/BFO88LA055.md): Aeronca 7AC · Capon Bridge, WV · Accident · No injuries · Limited investigation · Final report · Jun 18, 1988 · N1841E · Substantial damage > Loss of power because of carburetor ice which obstructed airflow to the engine. The aircraft nosed over on landing because of soft terrain and high grass. The pilot's failure to use carburetor heat is a contributing factor. - [NTSB NYC88FA166](https://openairdocs.org/ntsb/NYC88FA166.md): Bell 206L-1 · Springtown, PA · Accident · 2 fatal · Field investigation · Final report · Jun 17, 1988 · N114FH · Destroyed > While in cruise flight, ground witnesses observed the helicopter make two violent roll maneuvers followed by an in-flight breakup. Aircraft wreckage was spread over an area of approximately 10 acres. Examination of the wreckage revealed that the collective… - [NTSB CHI88DER03](https://openairdocs.org/ntsb/CHI88DER03.md): Cessna 172K · Mora, MN · Accident · No injuries · Final report · Jun 17, 1988 · N7499G · Substantial damage > Drg flt, one of the plts demonstrated a negative 'g' maneuver by entering a climb, then making a 'push over' to a descent. He throttled back on the back side of the maneuver to maintain airspeed. When the throttle was readvanced, there was no eng response.… - [NTSB SEA88LA110](https://openairdocs.org/ntsb/SEA88LA110.md): Aeronca O58B · Bremerton, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 15, 1988 · N49203 · Substantial damage > During cruise, eng lost power. Plt attempted to restore power with no success; eng power was surging but less than enough to sustain flight. Forced landing was executed into rough terrain. Inspection revealed fuel selector deteriorated by age and use. The… - [NTSB NYC88LA165](https://openairdocs.org/ntsb/NYC88LA165.md): Lake LA-4-200 · Wantagh, NY · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 1988 · N6110V · Substantial damage > The pilot was on a return VFR flight to republic airport after having repairs performed on the aircraft. The pilot stated that he experienced an engine power loss and prepared for an emergency landing with the gears retracted. The aircraft landed between two… - [NTSB DEN88LA129](https://openairdocs.org/ntsb/DEN88LA129.md): Cessna 172 · Rifle, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1988 · N2262E · Substantial damage > The student plt was flying a x-country training flt. The flt was not on the planned route. The plt flew into a box canyon too narrow to complete a turn and could not climb fast enough to clear the terrain at the end of the canyon. The pilot attempted a turn… - [NTSB LAX88LA222](https://openairdocs.org/ntsb/LAX88LA222.md): Piper PA-28-161 · Palm Springs, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 1988 · N43310 · Destroyed > Pilot misjudged the altitude of the mountain peak. - [NTSB LAX88LA221](https://openairdocs.org/ntsb/LAX88LA221.md): Burkhart Grob G-103A · Fremont, CA · Accident · No injuries · Limited investigation · Final report · Jun 12, 1988 · N103BK · Substantial damage > During a local flt, the glider encountered a windshear and lost altitude. The pilot was unable to regain the lost altitude and a forced landing was made where during the landing roll the glider collided with rough terrain. - [NTSB FTW88FA119](https://openairdocs.org/ntsb/FTW88FA119.md): Cessna 205 · Elgin, TX · Accident · 4 fatal · Field investigation · Final report · Jun 10, 1988 · N8181Z · Destroyed > The pilot radioed that he was running out of fuel while being vectored for landing. The ceiling was about 900 feet with 5 miles visibility and the accident occurred in a level grass field. Witnesses heard the engine cutting out and a loss of control occurred… - [NTSB LAX88DVA06](https://openairdocs.org/ntsb/LAX88DVA06.md): Craven Teenie TWO · Fowler, CA · Accident · Minor injuries · Final report · Jun 9, 1988 · N6052 · Destroyed > During cruise flight, the pilot reported a loss of oil pressure. The engine then sputtered and quit. The pilot initiated a forced landing where the airplane collided with several wooden crates short of the intended ldg area. Inspection of the engine revealed… - [NTSB ATL88FA191](https://openairdocs.org/ntsb/ATL88FA191.md): Cessna 421B · Knoxville, TN · Accident · 1 fatal · Field investigation · Final report · Jun 9, 1988 · N700SC · Destroyed - [NTSB SEA88LA107](https://openairdocs.org/ntsb/SEA88LA107.md): Beech A36 · Wenatchee, WA · Accident · No injuries · Limited investigation · Final report · Jun 8, 1988 · N7243X · Substantial damage > Airframe ice was accumulating on the aircraft at 13,000 feet so the pilot requested an altitude of 14,000 feet. At 14,000 feet the pilot lost control of the aircraft and descended down to 6,500 feet before recovering. The pilot had stated that he felt he had… - [NTSB LAX88LA216](https://openairdocs.org/ntsb/LAX88LA216.md): Cessna 150M · Ramona, CA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1988 · N66167 · Substantial damage > During the climb to cruise phase of the flt, the engine experienced a loss of power. The pilot applied carburetor heat and the power began to return. Due to the loss in altitude, the plt opted to make a forced landing in a field where just prior to touchdown,… - [NTSB LAX88LA214](https://openairdocs.org/ntsb/LAX88LA214.md): Robinson R22 · Bakersfield, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1988 · N2634N · Substantial damage > While on an instructional flt, the CFI instructed the student to fly above the power line poles at all times. While in cruise flight the instructor was looking away when the helicopter collided with power lines. The instructor took control of the helicopter… - [NTSB LAX88LA213](https://openairdocs.org/ntsb/LAX88LA213.md): Piper PA-28RT-201T · Grand Canyon, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1988 · N2131N · Substantial damage > Failure of the an tee fitting, thereby allowing the oil to be pumped overboard causing the engine failure. The failure of the tee fitting was caused by the tie wrap used to secure the line. The tie wrap pulled the oil line and stressed one side of the tee… - [NTSB CHI88LA125](https://openairdocs.org/ntsb/CHI88LA125.md): Cessna TU206B · Ellsworth, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1988 · N4757F · Substantial damage > During cruise flight the pilot experienced an engine failure which he believed to be caused by fuel exhaustion, and executed a forced landing in unsuitable terrain. Post accident inspection revealed that the left fuel tank contained 23 gallons of fuel at the… - [NTSB MKC88LA105](https://openairdocs.org/ntsb/MKC88LA105.md): Beech 35C · Manhattan, KS · Accident · No injuries · Limited investigation · Final report · Jun 4, 1988 · N5878C · Substantial damage > Arriving at the original destination apt, the PIC decided on an alternate, nearby airport, due to confusion regarding runway conditions at the original destination apt. Flying to his alternate, he erroneously lined up at a military airport located about 10… - [NTSB LAX88LA212](https://openairdocs.org/ntsb/LAX88LA212.md): Fairchild Hiller FH-1100 · Lihue, HI · Accident · No injuries · Limited investigation · Final report · Jun 4, 1988 · N53EP · Substantial damage > Fatigue failure of the engine to transmission drive shaft engine coupling due to an angular misalignment of the drive shaft. - [NTSB FTW88DRD08](https://openairdocs.org/ntsb/FTW88DRD08.md): Cessna T-210N · Ruston, LA · Accident · Minor injuries · Final report · Jun 4, 1988 · N6449Y · Destroyed > During climbout, the engine lost power and the airplane made a forced landing in a wooded area. After hitting trees and the terrain, the airplane burned. No pre-impact problems were found with the powerplant. Vented fuel caps had been installed but were… - [NTSB DEN88FA121](https://openairdocs.org/ntsb/DEN88FA121.md): Piper PA-28-180 · Rock Springs, WY · Accident · 2 fatal · Field investigation · Final report · Jun 4, 1988 · N9728J · Destroyed > Shortly after departure on the second leg of a cross country flt the plt informed the fss located on the arpt that he was returning. The fss technician on duty observed the acft turn final at an abnormally low altitude. The acft disappeared from view. The… - [NTSB MKC88DCQ03](https://openairdocs.org/ntsb/MKC88DCQ03.md): Aeronca 11AC · Ada, KS · Accident · Serious injuries · Final report · Jun 3, 1988 · N85985 · Substantial damage > The a/c contacted powerlines about 25 feet AGL, contacted a tree, broke another powerline, and then crashed into a pickup truck. No evidence of preimpact mechanical problems were found with either airframe or powerplant. A toxicological test of the pilot… - [NTSB NYC88LA152](https://openairdocs.org/ntsb/NYC88LA152.md): Beech H18 · Utica, NY · Accident · No injuries · Limited investigation · Final report · Jun 1, 1988 · N20PA · Substantial damage > The flight had departed syracuse airport enroute to plattsburg, new york transporting ups packages. At about 0810 hours, a loss of power on the left engine was experienced and altitude could not be maintained. The pilot informed griffiss control that he could… - [NTSB LAX88LA207](https://openairdocs.org/ntsb/LAX88LA207.md): Beech M35 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Jun 1, 1988 · N9896R · Substantial damage > During the climb out the engine experienced a loss of power. A forced landing was made where during the landing roll the airplane collided with the terrain. Inspection of the engine revealed that the number two connecting rod broke. - [NTSB FTW88DRG10](https://openairdocs.org/ntsb/FTW88DRG10.md): Piper PA-28RT-201 · Lampasas, TX · Accident · Minor injuries · Final report · May 31, 1988 · N8209H · Destroyed > The pilot experienced a partial loss of engine power during cruise, while on a night, VFR, cross-country flight. He attempted to spiral down to an airport for an emergency landing but reported that he became disoriented and attempted to land downwind,… - [NTSB CHI88DEM05](https://openairdocs.org/ntsb/CHI88DEM05.md): Bell 47G-2A · Midland, MI · Accident · No injuries · Final report · May 31, 1988 · N440TG · Substantial damage > The plt rprtd that before takeoff, he checked the fuel gage & concluded there was enough fuel to dispense his load. However, after spraying out the load, he started to return to the landing site & then the eng lost power from fuel exhaustion. The helicopter… - [NTSB LAX88FA204](https://openairdocs.org/ntsb/LAX88FA204.md): Taylorcraft BL65 · Eloy, AZ · Accident · 2 fatal · Field investigation · Final report · May 30, 1988 · N27463 · Destroyed > Failure of the pilot to maintain control of the aircraft during takeoff climb resulting in an inadvertent spiral. Contributing to this accident was the pilot's lack of total experience in the aircraft make and model. - [NTSB LAX88FA196](https://openairdocs.org/ntsb/LAX88FA196.md): Beech H-35 · Phoenix, AZ · Accident · 1 fatal · Field investigation · Final report · May 30, 1988 · N904Q · Destroyed > The plt had just completed a flight from farmington, n.m., to Phoenix, AZ (phx) where she deplaned her pax. The plt dept phx enroute to mesa, AZ, (ffz). After t.o. the LCL controller instructed the plt to turn right to 300 deg and to turn on the xpndr; the… - [NTSB NYC88FA147](https://openairdocs.org/ntsb/NYC88FA147.md): Lake LA4-250 · Shaftsbury, VT · Accident · 1 fatal · Field investigation · Final report · May 29, 1988 · N1405F · Destroyed > The Lake amphibian was being flown with two ferry tanks installed in the cabin. The pilot departed with full fuel in the aircraft tanks and 15 gallons in the ferry tanks. The center of gravity at zero fuel weight was 3/4 inch past the aft limit. With addition… - [NTSB MKC88LA099](https://openairdocs.org/ntsb/MKC88LA099.md): Cessna 152 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · May 29, 1988 · N67360 · Substantial damage > During a cross country flight, an emergency landing was made within three miles of destination airport. The aircraft nosed over after landing attempt, and passenger and PIC were not injured. Post flight inspection revealed engine had failed due to fuel… - [NTSB LAX88FA215](https://openairdocs.org/ntsb/LAX88FA215.md): Cessna 421C · Shaver Lake, CA · Accident · 4 fatal · Field investigation · Final report · May 29, 1988 · N98683 · Destroyed > Inflight encounter with forcasted severe icing and turbulence beyond the capability of either the aircraft or the pilot, which led to an inflgiht loss of control. Factors in the accident were the pilots lack of understanding of high altitude flight aspects… - [NTSB LAX88FA197](https://openairdocs.org/ntsb/LAX88FA197.md): Piper PA-28-140 · Pinecrest, CA · Accident · 2 fatal · Field investigation · Final report · May 29, 1988 · N1259T · Destroyed > Pilots decision to continue VFR flight through a mountain area after encountering instrument meteorological conditions. - [NTSB CHI88LA123](https://openairdocs.org/ntsb/CHI88LA123.md): Cessna 152 · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · May 28, 1988 · N4812B · Substantial damage > The student pilot was making the fourth leg of a solo cross country flight totalling 314 nautical miles. Although he departed with full fuel, none was added during the trip. The aircraft experienced a power failure, due to fuel exhaustion, approximately five… - [NTSB NYC88LA157](https://openairdocs.org/ntsb/NYC88LA157.md): Cessna 172M · Lairdsville, PA · Accident · Minor injuries · Limited investigation · Final report · May 27, 1988 · N5164H · Substantial damage > The Cessna 172 took off on a solo x-c flight with a student pilot/owner operator at the controls. After takeoff. The pilot reported a loss of engine power and made an off airport forced landing in a plowed field. The nose wheel dug in after approx 200 ft and… - [NTSB DEN88FA111](https://openairdocs.org/ntsb/DEN88FA111.md): Cessna T210N · Seboyeta, NM · Accident · 1 fatal · Field investigation · Final report · May 27, 1988 · N5536A · Destroyed > The plt departed el paso, TX, and flew to Douglas, AZ, where three pax boarded. The plt then flew to a ranch near Seboyeta, NM, and landed on a dirt road. After conducting business, the plt and his pax took off for pagosa springs, CO. As the acft turned on a… - [NTSB CHI88LA119](https://openairdocs.org/ntsb/CHI88LA119.md): Cessna 150K · Gary, IN · Accident · Minor injuries · Limited investigation · Final report · May 27, 1988 · N5658G · Destroyed > While on the return leg of a local flight, the pilot was flying at 150' above the water along the shoreline. The pilot's attention was diverted from the task of flying the airplane by navigation duties (the frequency, and adjustment, and tuning of the VOR),… - [NTSB ATL88FA185](https://openairdocs.org/ntsb/ATL88FA185.md): Piper PA-28R-200 · Raleigh, NC · Accident · 2 fatal · Field investigation · Final report · May 26, 1988 · N44018 · 2 aircraft · Destroyed > A Piper PA-28R (lead acft, N44018) & a Cessna 172 (#2 acft, N737GU) were departing Raleigh-durham arpt on a formation flt to petersburg, VA. The Cessna plt (wingman) rprtd that drg takeoff & initial climb, the lead acft bgn to accelerate ahead of him. The… - [NTSB MIA88IA177](https://openairdocs.org/ntsb/MIA88IA177.md): British BAC-111-203 · Orlando, FL · Incident · Minor injuries · Incident investigation · Final report · May 24, 1988 · N1544 · Minor damage > The flt was descending thru 13000 ft when turbulence was encountered. Four passengers and two flight attendents were injured. The passengers were injured when their seatbelts' end fittings detached from their seats' tie-down shackles and the passengers struck… - [NTSB FTW88IA109](https://openairdocs.org/ntsb/FTW88IA109.md): Boeing 737-3T0 · New Orleans, LA · Incident · No injuries · Incident investigation · Final report · May 24, 1988 · N75356 · Minor damage > A double engine flameout due to water ingestion which occurred as a result of an inflight encounter with an area of very heavy rain and hail. A contributing cause of the incident was the inadequate design of the engines and the FAA water ingestion… - [NTSB ATL88LA183](https://openairdocs.org/ntsb/ATL88LA183.md): Ercoupe 415-C · Whiteville, NC · Accident · Minor injuries · Limited investigation · Final report · May 24, 1988 · N41886 · Substantial damage > The student plt reported that the engine began to skip and lose pwr about 20 minutes after departure. The engine subsequently lost all pwr and the student made a forced ldg in a plowed field. The airplane nosed over during the ldg. Post-crash exam of the… - [NTSB NYC88LA146](https://openairdocs.org/ntsb/NYC88LA146.md): Cessna 152 · Turner, ME · Accident · No injuries · Limited investigation · Final report · May 23, 1988 · N46413 · Substantial damage > The pilot said he preflighted the aircraft before departure. The pilot stated that he flew in the local area taking photos, then had started back towards the airport when the engine began to sputter. The pilot called bangor air rescue, checked instruments and… - [NTSB MIA88IA176](https://openairdocs.org/ntsb/MIA88IA176.md): Airbus Industrie A-300 · Near San Juan, PR · Incident · No injuries · Incident investigation · Final report · May 23, 1988 · N209PA · 2 aircraft · No damage > Pan am flt 217 (Airbus A300, N209PA) was clrd by new york center oceanic ctl area (oca) to proceed south on airway amber 300 at FL 290 over the atlantic ocean. As it was en route, American flt 902 departed san Juan (sju), PR for a northbound flt on the same… - [NTSB NYC88LA144](https://openairdocs.org/ntsb/NYC88LA144.md): Cessna 150F · West Chester, PA · Accident · No injuries · Limited investigation · Final report · May 22, 1988 · N8154S · Substantial damage > The pilot preflighted the aircraft and performed a runup before takeoff. The flight departed from runway 27. When the aircraft reached about 200 feet, the engine experienced a power loss and altitude could not be maintained. The pilot elected to land in a… - [NTSB MIA88LA175](https://openairdocs.org/ntsb/MIA88LA175.md): Globe GC1-B · Miami, FL · Accident · No injuries · Limited investigation · Final report · May 22, 1988 · N90379 · Substantial damage > Hydraulic motor activated light remained on after landing gear retraction. The pilot believing this to indicate a landing gear malfunction slowed the acft and extended the gear. A gear down indicator illuminated. However, the hydraulic motor activated light… - [NTSB ATL88LA181](https://openairdocs.org/ntsb/ATL88LA181.md): Globe GC-1A · Blue Ridge, GA · Accident · Minor injuries · Limited investigation · Final report · May 22, 1988 · N80582 · Substantial damage > The plt reported that he encountered deteriorating wx conditions during the flt. He made a 180 degree turn and other course changes in an attempt to return to better wx, but was unable to maintain VFR flt. He subsequently elected to make a precautionary ldg… - [NTSB MKC88LA094](https://openairdocs.org/ntsb/MKC88LA094.md): Cessna 170 · Cassville, MO · Accident · Minor injuries · Limited investigation · Final report · May 21, 1988 · N2585V · Substantial damage > The PIC dptd Texas enr to bolivar, MO with a stop for fuel in pinebluff, ark with two revenue pax's aboard. The PIC stated that the pax would try to locate the arpt by visually identifying the lights of the city. The PIC stated they wandered to several… - [NTSB SEA88LA098](https://openairdocs.org/ntsb/SEA88LA098.md): Grumman G-164 · Ritzville, WA · Accident · No injuries · Limited investigation · Final report · May 20, 1988 · N6963K · Destroyed > While on an aerial applications flight, the pilot was climbing to clear power lines when a whirlwind was encountered. The aircraft struck a power pole and descended onto the ground. - [NTSB ATL88LA179](https://openairdocs.org/ntsb/ATL88LA179.md): Cessna 152 · Conway, SC · Accident · Minor injuries · Limited investigation · Final report · May 20, 1988 · N94533 · Substantial damage > The pilot was conducting a maintenance test flight when he experienced a drop in engine RPM. After a series of bangs the engine quit. The pilot made a forced landing into a rough field. The engine examination disclosed that no. 1 piston had failed. The engine… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=300 ## 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=299 --- 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.