# 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 294 of 718 · 35,885 cases ## Cases, newest first - [NTSB CHI89LA002](https://openairdocs.org/ntsb/CHI89LA002.md): Cessna 152II · Ashland, OH · Accident · No injuries · Limited investigation · Final report · Oct 9, 1988 · N49135 · Substantial damage > While enroute on a cross country flight from buffalo, new york to mansfield, Ohio, the aircraft experienced a total loss of engine power. The pilot performed emergency procedures and executed a forced landing in a farmer's open field. The pilot stated that… - [NTSB MIA89LA007](https://openairdocs.org/ntsb/MIA89LA007.md): Cessna T188C · Flora, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1988 · N2896J · Destroyed > After dispensing a chemical load, the plt was rtrng to re-load when the eng began running rough. He said he noted the fuel flow was erratic, so he turned on the boost pump. The eng stabilized momentarily, then smoke entered the cockpit & the eng began… - [NTSB FTW89LA001](https://openairdocs.org/ntsb/FTW89LA001.md): Cessna 150 · Navasota, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1988 · N51112 · Substantial damage > Acft struck a tree during a night forced landing following an eng failure in cruise flt. The eng failure was caused by fuel exhaustion. The flt had been airborne for 4 hours and 44 minutes; however, the plt had calculated that he had sufficient fuel to make… - [NTSB DEN89LA012](https://openairdocs.org/ntsb/DEN89LA012.md): Bellanca 8KCAB · Pueblo, CO · Accident · No injuries · Limited investigation · Final report · Oct 8, 1988 · N102EC · Substantial damage > The commercial plt & his pvt plt wife were flying x-country on vacation. While en route, the eng began running rough & lost power. Drg an emergency dscnt, the plt restarted the eng & initiated a climb to select a better lndg site, but the eng lost power… - [NTSB CHI89FA005](https://openairdocs.org/ntsb/CHI89FA005.md): Piper PA-28 · Schaumburg, IL · Accident · Minor injuries · Field investigation · Final report · Oct 8, 1988 · N4608R · Destroyed > Engine failure due to oil starvation and the pilot's misjudged emergency landing, during which the aircraft collided with trees and a swimming pool, before coming to rest on the ground and a chain link fence. - [NTSB ATL89FA006](https://openairdocs.org/ntsb/ATL89FA006.md): Cessna 210N · Alexander City, AL · Accident · 1 fatal · Field investigation · Final report · Oct 7, 1988 · N6510N · Substantial damage > The airplane crashed about 2 mi short of the destination arpt. Witnesses reported that it impacted nose down after clearing trees; no engine sounds were heard. According to rescue personnel, the plt indicated that there were no engine or other mechanical… - [NTSB MIA89LA006](https://openairdocs.org/ntsb/MIA89LA006.md): Piper PA-23-250 · La Belle, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1988 · N6815Y · Substantial damage > The pilot while on a ferry permit flight experienced a failure of the #4 cyl of the left engine and did not attain the vyse speed and the aircraft started to descend. The pilot ditched the aircraft in a lake and it was not recovered. No records on the engines… - [NTSB FTW89DRG01](https://openairdocs.org/ntsb/FTW89DRG01.md): Shamgaugh Pitts Special · San Benito, TX · Accident · No injuries · Final report · Oct 6, 1988 · N3S · Substantial damage > Improper torquing of the 'b' nut fitting on the main fuel supply line to the powerplant at the firewall and the pilot's inadequate pre-flight inspection. - [NTSB DEN89LA008](https://openairdocs.org/ntsb/DEN89LA008.md): Cessna T210N · Price, UT · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1988 · N7335N · Substantial damage > The pilot was performing a business flight over mountainous terrain. About 1 hr into the flight, he noticed smoke or oil vapor in the cockpit. He saw oil on the lower cowling and wing and communicated his position and problem to the salt lake city ARTCC. The… - [NTSB DEN89FA007](https://openairdocs.org/ntsb/DEN89FA007.md): Mooney M20E · Walsh, CO · Accident · 3 fatal · Field investigation · Final report · Oct 5, 1988 · N5997Q · Destroyed > There is no record plt obtained wx briefing, filed flt plan, or obtained in-flt wx advisories. Plt and two pax departed san marcos, TX, at 1400 CDT in VMC, enroute to springfield, CO. Acft was seen by two witnesses at aprx 1630 MDT, 11 mi w of Walsh, CO,… - [NTSB DEN89LA004](https://openairdocs.org/ntsb/DEN89LA004.md): Raven Rally II · Rio Rancho, NM · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1988 · N4098G · Substantial damage > The commercial balloon plt and one pax were participating in a balloon fiesta. The acft took off from albuquerque, on a local flight in calm winds. At altitude, the balloon encountered south winds that carried the balloon to Rio Rancho, where a landing was… - [NTSB LAX89LA002](https://openairdocs.org/ntsb/LAX89LA002.md): Piper PA-28R-201 · Palmdale, CA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1988 · N31386 · 2 aircraft · Substantial damage > At approximately 6000 ft MSL two airplanes collided in flight. N49382 was climbing to altitude, N31386 was descending in a shallow left turn. The airplane descending colliding with the climbing airplane from behind and to the right. Both airplanes were able… - [NTSB ATL89LA003](https://openairdocs.org/ntsb/ATL89LA003.md): Cessna 150M · Silerton, TN · Accident · No injuries · Limited investigation · Final report · Oct 2, 1988 · N6176K · Substantial damage > The student plt was on a VFR x-country flt. She rprtd that after leveling at 2000', the eng began running rough & the RPM dropped from 2400 to about 2000 RPM. The acft would not maint alt. The student said she applied carb heat when the acft was at about… - [NTSB ATL89FA004](https://openairdocs.org/ntsb/ATL89FA004.md): Piper PA-30 · La Follette, TN · Accident · 1 fatal · Field investigation · Final report · Oct 2, 1988 · N7484Y · Destroyed > The pilot reported an autopilot problem and was not able to maintain control of the airplane. The airframe components were scattered in a circular pattern. All fractures displayed overload failures. The wreckage examination failed to disclose any system or… - [NTSB SEA89LA005](https://openairdocs.org/ntsb/SEA89LA005.md): Piper PA-28-140 · North Fork, ID · Accident · No injuries · Limited investigation · Final report · Oct 1, 1988 · N7548R · Destroyed > The pilot flew the aircraft into a box canyon at dawn. The aircraft was unable to outclimb rising terrain. The aircraft impacted heavily wooded terrain at a slow airspeed at 8,000 feet MSL about 50 yards short of the crest. - [NTSB MKC88LA182](https://openairdocs.org/ntsb/MKC88LA182.md): Cessna 172E · Harrison, AR · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 1988 · N3943S · Substantial damage > While in normal cruise flt, the plt declared an emergency. He stated the eng had failed & that he thought it had 'thrown a rod.' Subsequently, the acft was extensively damaged drg an emerg landing in a wooded area. An investigation revealed the #6 connecting… - [NTSB MIA89LA002](https://openairdocs.org/ntsb/MIA89LA002.md): Beech V35A · Fort Lauderdale, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 1988 · N8076R · Substantial damage > The plt stated that aprx 15 minutes after takeoff from Fort Lauderdale, the eng quit completely & he was unable to make it back to the arpt. While attempting a forced landing in a field, he landed nose down, the nose gear collapsed, and the acft slid to a… - [NTSB ATL89LA002](https://openairdocs.org/ntsb/ATL89LA002.md): Piper PA-24-250 · Monroeville, AL · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 1988 · N100J · Destroyed > According to the plt, he had requested the acft be fully svcd with fuel before takeoff; however, he did not visually check the fuel. He rprtd that after takeoff, he had flown about 50 min when he noted the rgt tank, which he was using, indcd empty. He said he… - [NTSB CHI88FA248](https://openairdocs.org/ntsb/CHI88FA248.md): Cessna 210L · Monroe, WI · Accident · 2 fatal · Field investigation · Final report · Sep 30, 1988 · N5268V · Destroyed - [NTSB SEA88LA189](https://openairdocs.org/ntsb/SEA88LA189.md): Bellanca 7ECA · Toledo, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1988 · N1047Y · Substantial damage > The plt took off from an uncontrolled strip in marginal wx conds, believing he could affect a departure to good VFR conds. Shortly after takeoff, he enctrd solid IMC & momentarily lost control of the acft. After regaining control & having lost altitude, he… - [NTSB ATL88LA255](https://openairdocs.org/ntsb/ATL88LA255.md): Cessna 150 · Bessemer City, NC · Accident · No injuries · Limited investigation · Final report · Sep 25, 1988 · N7831E · Substantial damage > The pilot reported that he had observed a cloud layer forming along his flt route. At about the same time, the acft VOR rcvr failed. The plt elected to continue vfr-on-top to his planned destination based on VFR wx reported by an ATIS broadcast from an arpt… - [NTSB SEA88LA183](https://openairdocs.org/ntsb/SEA88LA183.md): Cessna 150L · Hadlock, WA · Accident · 1 fatal · Limited investigation · Final report · Sep 22, 1988 · N11582 · Destroyed > The recently certificated pilot departed on a two hour round-robin flight to attend a meeting and was advised to expect fog on return. The aircraft was flown for one hour prior to this flight and was not refueled. No record of a wx brief was found. Prior to… - [NTSB NYC88FA238](https://openairdocs.org/ntsb/NYC88FA238.md): de Havilland DH-7-58C · Albany, NY · Accident · Serious injuries · Field investigation · Final report · Sep 22, 1988 · N170RA · Substantial damage > The acft experienced an uncontained disintegration of the no.2 engine. Scorched engine fragments ripped through the fuselage injuring two passengers, one seriously. The uncontained failure was the result of wear or spalling of the 1st stage reduction gear and… - [NTSB MKC88FA176](https://openairdocs.org/ntsb/MKC88FA176.md): Beech C23 · Belle Plaines, IA · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1988 · N6022C · Destroyed > The non-instrument rated pilot received a full weather briefing prior to departure during which he was advised that VFR flight was not recommended. In addition he was advised that, while conditions were forecast to improve, the possibility for scattered… - [NTSB DEN88LA210](https://openairdocs.org/ntsb/DEN88LA210.md): Piper PA-28-140 · Kerrville, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 1988 · N3621K · Destroyed > The commercial plt was 6 miles from his ranch and noted smoke in the cockpit, accompanied by a rough running engine. He turned back to the ranch for a forced landing. He overflew the landing area, decided he was too high for landing and turned for another… - [NTSB ATL88LA253](https://openairdocs.org/ntsb/ATL88LA253.md): Cessna 150G · Luverne, AL · Accident · No injuries · Limited investigation · Final report · Sep 22, 1988 · N3772J · Substantial damage > The plt reported that he was flying at about 7-800 ft AGL while inspecting timber for insect damage when the engine suddenly lost power. He could not recover enough power to sustain flt, so he selected a pasture for his impending forced ldg. He reported that… - [NTSB NYC88IA246](https://openairdocs.org/ntsb/NYC88IA246.md): Boeing 747-100 · Georgetown, Guyana · Incident · Minor injuries · Incident investigation · Final report · Sep 21, 1988 · N9674 · No damage > Incident that led to the death of the passenger in row #6 was apparently not related to turbulence, because the passenger died of choking two hours after the turbulence encounter. - [NTSB MKC88FA175](https://openairdocs.org/ntsb/MKC88FA175.md): Cessna 310R · Latimer, IA · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1988 · N36HD · Destroyed > The pilot had completed his normal flight schedule and was assigned an additional trip from des moines, Iowa to st paul, Minnesota. Calculations show that the pilot had flown an estimated 5 hours in the 8 1/2 hours preceding the accident. The line attendant… - [NTSB CHI88DEP13](https://openairdocs.org/ntsb/CHI88DEP13.md): Heibel AIR Command 532 · Cottage Grove, WI · Accident · 1 fatal · Final report · Sep 21, 1988 · N7015C · Destroyed > While in cruise flight this amateur built gyrocopter experienced a main rotor strike to the rudder and propeller. The student pilot who had a total of eight hours flight time, all in this aircraft, was conducting a solo flight in this dual control gyrocopter.… - [NTSB LAX88LA326](https://openairdocs.org/ntsb/LAX88LA326.md): Cessna 172L · Banning, CA · Accident · No injuries · Limited investigation · Final report · Sep 20, 1988 · N7233Q · Substantial damage > During a crosscountry flt, while enroute from lake havasu city, AZ, to Banning, CA, the engine experienced a loss of power. The airplane collided with the terrain after a forced landing. Inspection of the fuel system revealed there was no fuel on board. - [NTSB DEN88FA213](https://openairdocs.org/ntsb/DEN88FA213.md): Piper PA-22-150 · Curtin, OR · Accident · 2 fatal · Field investigation · Final report · Sep 20, 1988 · N3863P · Destroyed > On 9/20/88, the plt & his wife depd montaque, CA, on a flt to silverdale, WA, with a planned refueling stop at cottage grove, OR. When the acft did not arrive, a search was made, but to no avail. On 1/24/90, a tree planting crew found the acft, where it had… - [NTSB SEA88LA182](https://openairdocs.org/ntsb/SEA88LA182.md): Piper PA-24-260 · Bend, OR · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 1988 · N8765P · Destroyed > At aprx 1239 PDT, while on an IFR x-country flt at 14,000', the acft enctrd icing conds. Drg the next 1.4 hrs, the plt changed altitude in increments, climbing to 17,000', then descending to 11,000' to avoid icing. At aprx 1411 PDT, he indcd the eng had lost… - [NTSB LAX88LA324](https://openairdocs.org/ntsb/LAX88LA324.md): Robinson R22-HP · Yosemite, CA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1988 · N9077N · Substantial damage > The pilot was flying in high terrain at 10,000 ft MSL when he noticed his airspeed had dropped to 0. He stated that he had encountered a strong tailwind and he lost control of the helicopter. The helicopter collided with the terrain in an uncontrolled… - [NTSB FTW88FA164](https://openairdocs.org/ntsb/FTW88FA164.md): Piper PA-28R-201T · Okmulgee, OK · Accident · 1 fatal · Field investigation · Final report · Sep 18, 1988 · N47806 · Destroyed > Non-instrument rated pilot's intentional flight into an area of adverse weather associated with thunderstorms, heavy precipitation, and turbulence. The pilot experienced vertigo and lost control of the aircraft. The aircraft then sustained an infight breakup… - [NTSB CHI88FA237](https://openairdocs.org/ntsb/CHI88FA237.md): Cessna 182RG · Zanesville, OH · Accident · 2 fatal · Field investigation · Final report · Sep 18, 1988 · N9877C · Destroyed > The pilot's poor judgement/decision-making, and his over confidence in his own ability which led to his repeated decisions to operate his aircraft in adverse weather conditions. The fact that the pilot had operated the aircraft in adverse weather conditions… - [NTSB CHI88DEG01](https://openairdocs.org/ntsb/CHI88DEG01.md): Piper PA-22-160 · Jackson, OH · Accident · No injuries · Final report · Sep 18, 1988 · N9053D · Substantial damage > While in cruise flight, the eng began running rough & would not produce enough power to maintain level flt. The plt selected a pasture for an emergency landing. Just before landing, the acft struck & severed a transmission line. It then brushed a treetop &… - [NTSB SEA88LA181](https://openairdocs.org/ntsb/SEA88LA181.md): Piper PA-28-140 · Cottage Grove, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 17, 1988 · N1223T · Substantial damage > When plt realized strong headwinds at cruise alt would preclude reaching intended destination, he attempted to divert to another alternate. Fuel exhaustion occurred before reaching arpt. During a lndg, executed in dark, acft collided with a fence. - [NTSB NYC88FA236](https://openairdocs.org/ntsb/NYC88FA236.md): Cessna 172N · Adams, MA · Accident · 2 fatal · Field investigation · Final report · Sep 17, 1988 · N6586J · Destroyed > Pilot's inadequate preflight planning and improper inflight decisions, he continued VFR into IFR conditions. The air route traffic control center service was improper. - [NTSB DEN88IA207](https://openairdocs.org/ntsb/DEN88IA207.md): Beech 1900 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Sep 17, 1988 · N32017 · Minor damage - [NTSB LAX88LA322](https://openairdocs.org/ntsb/LAX88LA322.md): Hughes 369HS · Columbia, CA · Accident · No injuries · Limited investigation · Final report · Sep 16, 1988 · N9110F · Substantial damage > During an external load operation, there was an indication of high torque and the oil chip light illuminated. The engine lost power and the pilot initiated an autorotation. The helicopter collided with the sloping terrain and rolled over. Inspection of the… - [NTSB ANC88LA138](https://openairdocs.org/ntsb/ANC88LA138.md): de Havilland DHC-2 · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 1988 · N98JH · Substantial damage > While cruising, the pilot-in-command experienced a rough engine and finally an unexplained power reduction to idle. He was unable to glide the float equipped airplane to a body of water and executed a forced landing on the tundra where the airplane sustained… - [NTSB MKC88LA174](https://openairdocs.org/ntsb/MKC88LA174.md): Beech A23 · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Sep 15, 1988 · N6917Q · Substantial damage > The PIC said there was a loud metallic explosion in the engine compartment. When the acft was about 7 miles from the destination apt and beginning a descent. The aircraft began vibrating violently and the windshield became covered with engine oil. Attempts… - [NTSB MIA88LA268](https://openairdocs.org/ntsb/MIA88LA268.md): Cessna 177 · Polk City, FL · Accident · No injuries · Limited investigation · Final report · Sep 15, 1988 · N2357Y · Substantial damage > Plt failed to insure acft had adequate fuel supply for flt. The engine failed due to fuel exhaustion and a forced landing was made in a field. The plt said that he experienced stronger than expected head winds. Post acc invest revealed that the acft fuel… - [NTSB DEN88IA204](https://openairdocs.org/ntsb/DEN88IA204.md): Cessna 206 · Glade Park, CO · Incident · No injuries · Incident investigation · Final report · Sep 15, 1988 · N71001 · No damage > The failure of the #1 connecting rod assembly in the engine, resulting in a forced landing. A factor in the incident was that the pilot did not see & avoid power wires in the forced landing path. - [NTSB ATL88LA252](https://openairdocs.org/ntsb/ATL88LA252.md): Piper PA-12 · Covington, TN · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1988 · N2833M · Substantial damage > The plt reported that the engine suddenly began to run rough and backfire during a pipeline patrol flight at 300 ft AGL. The roughness worsened and the plt made a forced ldg on a dirt road. During rollout, one of the wings caught vegetation bordering the road… - [NTSB LAX88LA317](https://openairdocs.org/ntsb/LAX88LA317.md): Cessna 150L · Salinas, CA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1988 · N6804G · Substantial damage > During a cross-country flt, while descending to the arpt, the engine lost power. The airplane collided with the terrain and nosed over. Inspection of the fuel system revealed there was no fuel on board. - [NTSB CHI88DEP12](https://openairdocs.org/ntsb/CHI88DEP12.md): Piper PA-36-300 · Pulaski, WI · Accident · 1 fatal · Final report · Sep 14, 1988 · N57847 · Destroyed > The aircraft descended at a high rate of speed, 75 degrees nosedown, into the terrain. His widow stated that the pilot had left home at approximately 2100 CST on the accident night, in an inebriated condition. After a discussion about his drinking, he… - [NTSB MKC88FA171](https://openairdocs.org/ntsb/MKC88FA171.md): Piper J3C-65 · Goodman, MO · Accident · Serious injuries · Field investigation · Final report · Sep 13, 1988 · N3533N · Substantial damage > Engine ignition and lubrication problems which resulted in the pilot's election to execute a precautionary landing. A contributing factor was the pilot's inability to see and avoid power lines in his approach path due to bright sunshine. - [NTSB DEN88FA202](https://openairdocs.org/ntsb/DEN88FA202.md): Beech 200 · Jackson, WY · Accident · 1 fatal · Field investigation · Final report · Sep 12, 1988 · N1283 · Destroyed > The plt and his two pax had just arrived at the Jackson hole airport (jax) approximately 30 minutes prior to the accident. The plt dropped off his pax and stepped into operations for a short break. He then returned to the acft by himself for a return flt to… - [NTSB ANC88LA135](https://openairdocs.org/ntsb/ANC88LA135.md): Champion 7GCBC · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Sep 12, 1988 · N3059G · Substantial damage > The private pilot and his son were returning from a hunting trip when the airplane ran out of fuel. The pilot attempted an emergency landing on an unlighted roadway and struck a telephone wire or small powerline during the approach. The airplane landed hard… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=295 ## 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=294 --- 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.