# NTSB investigations: Maneuvering 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 179 of 377 · 18,850 cases ## Cases, newest first - [NTSB MIA89FA027](https://openairdocs.org/ntsb/MIA89FA027.md): Grumman AA5A · Tampa, FL · Accident · 2 fatal · Field investigation · Final report · Nov 11, 1988 · N9975U · Destroyed > Witnesses stated the acft was flying at low alt in the area of lake thonotosassa just before it struck the top static wire of a group of power lines. Impact occurred while the acft was on a southerly heading. The acft then crashed into an orange grove. An… - [NTSB MIA89LA024](https://openairdocs.org/ntsb/MIA89LA024.md): Bell 206L · St. Thomas · Accident · Minor injuries · Limited investigation · Final report · Nov 10, 1988 · N16619 · Substantial damage > The plt autorotated the helicopter into the water after a loss of power while transitioning from fwd flight to a hover. While landing with the emergency floats armed, he attempted to deploy the floats but was unable. The plt & pax evacuated. The helicopter… - [NTSB LAX89DUM03](https://openairdocs.org/ntsb/LAX89DUM03.md): Grumman G-164 · Blythe, CA · Accident · No injuries · Final report · Nov 10, 1988 · N10219 · Substantial damage > The pilot stated that the engine lost power on a 'spray pass.' He then executed a forced landing straight ahead and nosed over after touchdown in a cotton field. Investigation revealed an elbow fitting connecting the main fuel supply line and the carburetor… - [NTSB ATL89LA030](https://openairdocs.org/ntsb/ATL89LA030.md): Piper PA-28-140 · Deane, KY · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 1988 · N98185 · Destroyed > While en route to wise, Virginia from richmond, Kentucky on a pleasure flight, the airplane collided with trees on rockhouse mountain. The airplane was substantially damaged and the pilot and passenger were seriously injured. The fuel selector was found… - [NTSB CHI89DEV01](https://openairdocs.org/ntsb/CHI89DEV01.md): Cessna 152 · Vandalia, IL · Accident · No injuries · Final report · Nov 8, 1988 · N93085 · Substantial damage > The eng began running rough aprx 5 min after the plt took off from an en route arpt drg a night, x-country training flt. He reversed course back toward the departure arpt with the eng providing partial power. While maneuvering to land on rwy 18, the eng… - [NTSB CHI89LA022](https://openairdocs.org/ntsb/CHI89LA022.md): Cessna 150J · Carson City, MI · Accident · No injuries · Limited investigation · Final report · Nov 7, 1988 · N50649 · Substantial damage - [NTSB NYC89FA021](https://openairdocs.org/ntsb/NYC89FA021.md): Cessna 152 · Smithfield, RI · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1988 · N5462B · Destroyed > Failure of the pilot to maintain airspeed after beginning an ascent from a low pass, which resulted in a stall & loss of aircraft control. Inadequate altitude to recover from a stall was considered to be a contributing factor. - [NTSB FTW89FA015](https://openairdocs.org/ntsb/FTW89FA015.md): Cessna A150K · Flint, TX · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1988 · N5913J · Destroyed > The airplane was observed flying on an easterly heading at low altitude, with the propeller stopped. One of the witnesses said the airplane was gliding toward him and when close he started running away. He said the airplane abruptly turned left and went… - [NTSB FTW89DRD01](https://openairdocs.org/ntsb/FTW89DRD01.md): Sandridge KR-2 · Monroe, LA · Accident · Minor injuries · Final report · Nov 5, 1988 · N4474U · Destroyed > As the plt was taxiing to takeoff, the tower adzd him that wind shear advisories were in effect. At aprx 1359, he was clrd for takeoff on rwy 31. At that time, the wind was from 280 deg at 18 KTS. Drg takeoff, the acft was climbing thru about 300 to 500 ft,… - [NTSB SEA89LA016](https://openairdocs.org/ntsb/SEA89LA016.md): Bell 214B-1 · Ketchikan, AK · Accident · No injuries · Limited investigation · Final report · Nov 4, 1988 · N514RM · Substantial damage > Outbd 5 feet of top skin from one main rotor blade separated in flt. Plt effected lndg with no further damage. Investigation revealed erosion of leading edge protective strip allowed airloads to intrude under skin to cause delamination and separation. Soot… - [NTSB LAX89LA035](https://openairdocs.org/ntsb/LAX89LA035.md): Cessna 152 · Chandler, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 1988 · N4657L · Destroyed > The pilot lost control and collided with the runway while maneuvering for landing. The pilot and passenger were testing atmospheric conditions with meteorological equipment in conjunction with noise testing of a Boeing 707 'hush' kit. The Cessna tookoff… - [NTSB FTW89DQG01](https://openairdocs.org/ntsb/FTW89DQG01.md): Piper PA-25-235 · Lamesa, TX · Accident · 1 fatal · Final report · Nov 4, 1988 · N75217 · Destroyed > The pilot was spraying a field of cotton, and was in a turnaround when the airplane descended to the ground. The autopsy indicated the pilot died of acute coronary thrombosis. Although tox results indicate the presence of alcohol in the pilot's blood, the… - [NTSB MKC89LA018](https://openairdocs.org/ntsb/MKC89LA018.md): Rockwell S2R · Sublette, KS · Accident · Serious injuries · Limited investigation · Final report · Nov 1, 1988 · N5517X · Substantial damage > While conducting an aerial application operation, the aircraft struck some cross-country power lines. The acft nosed down and struck the terrain, causing substantial damage to the acft and serious injuries to the pilot. The pilot was unable to recall the… - [NTSB DEN89LA025](https://openairdocs.org/ntsb/DEN89LA025.md): Piper PA-18-150 · Tucumcari, NM · Accident · No injuries · Limited investigation · Final report · Oct 30, 1988 · N4026Z · Substantial damage > The private plt was flying a friend over his ranch searching for cows. The plt reported making a 40 deg left banked turn at 300 ft AGL at full power and 70 knots. He said that the plane would not respond to aileron control inputs initially. The plt said the… - [NTSB DEN89DTE02](https://openairdocs.org/ntsb/DEN89DTE02.md): Jones Christen Eagle II · Parker, CO · Accident · 1 fatal · Final report · Oct 30, 1988 · N25DJ · Destroyed > The plt was performing aerobatics in a homebuilt christen eagle near his girlfriend's house where a birthday party was in progress. Witnesses said the acft executed a roll at low altitude and 'went straight in.' Weather was not a factor and examination of the… - [NTSB MIA89LA020](https://openairdocs.org/ntsb/MIA89LA020.md): Parsons B-8M · Lake City, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 1988 · N10WP · Substantial damage > During an airshow, the plt took off to perform a planned 8-spin autorotative landing from an alt of aprx 800 ft. an FAA inspector who observed the accident stated the flt ascended to aprx 650 ft MSL. After closing the throttle, the plt began the maneuver.… - [NTSB LAX89LA027](https://openairdocs.org/ntsb/LAX89LA027.md): Let L-13 · Marana, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 29, 1988 · N90848 · Substantial damage > The pilot reported that shortly after liftoff from runway 26 the control stick became difficult to move. He decided to continue the air tow and release at 200 feet AGL after release, the pilot turned the glider to return to the runway to land. He was still… - [NTSB LAX89DUJ02](https://openairdocs.org/ntsb/LAX89DUJ02.md): Piper PA-25-235 · Glendale, AZ · Accident · Serious injuries · Final report · Oct 23, 1988 · N7229Z · Substantial damage > During an aerial application flight the pilot reported that the right wing suddenly went up then down. The airplane rolled to the right and collided with the terrain. Inspection of the airplane revealed that the lift strut was broken. Evidence of corrosion… - [NTSB LAX89DUJ01](https://openairdocs.org/ntsb/LAX89DUJ01.md): Cessna A188A · Casa Grande, AZ · Accident · Serious injuries · Final report · Oct 23, 1988 · N5640J · Destroyed > During aerial application flight, the aircraft collided with a high-tension static wire and subsequently with the ground. Post-impact fire ensued. The pilot stated he misjudged his approach to the field and did not see the wire. - [NTSB ANC89LA012](https://openairdocs.org/ntsb/ANC89LA012.md): Piper PA-18 · Huslia, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 23, 1988 · N7688L · Substantial damage > The private pilot and his adult male passenger were both severely burned when the pilot's Piper PA-18 crashed and burned following a low altitude stall and impact with trees. The pilot's wife stated that her husband told her that he was showing his passenger… - [NTSB LAX89FA023](https://openairdocs.org/ntsb/LAX89FA023.md): Piper PA-28-140 · Big Pine, CA · Accident · 2 fatal · Field investigation · Final report · Oct 22, 1988 · N140RM · Destroyed > Pilot's failure to maintain proper altitude. - [NTSB LAX89FA018](https://openairdocs.org/ntsb/LAX89FA018.md): Cessna 172P · Union City, CA · Accident · 2 fatal · Field investigation · Final report · Oct 19, 1988 · N52222 · Destroyed > Loss of control of the aircraft by the pilot when he inadvertently entered instrument meteorological conditions. Factors contributing to the accident were, dark night light conditions and foggy weather conditions, inadvertent flight into IMC under visual… - [NTSB SEA89LA013](https://openairdocs.org/ntsb/SEA89LA013.md): Cessna 210E · Wenatchee, WA · Accident · 4 fatal · Limited investigation · Final report · Oct 18, 1988 · N4961U · Destroyed > The acft crashed while the plt was on a x-country flt at dawn. Impact occurred on rising, rocky terrain in a box canyon area at an elev of about 6000 ft. no ground scars were evident, but the acft impacted on a rocky slide area. It came to rest in one area… - [NTSB LAX89DUM02](https://openairdocs.org/ntsb/LAX89DUM02.md): Piper PA-36-285 · Brawley, CA · Accident · Serious injuries · Final report · Oct 18, 1988 · N57591 · Destroyed > At the completion of aerial application, the plt attempted flight beneath power lines. The aircraft contacted and severed four power lines and then collided with terrain. A post-impact fire ensued. - [NTSB LAX89DVM01](https://openairdocs.org/ntsb/LAX89DVM01.md): Continental Copters OH13H · Castroville, CA · Accident · No injuries · Final report · Oct 16, 1988 · N9092T · Substantial damage > During aerial application by helicopter, engine power was lost. Plt maneuvered to avoid power lines during autorotation, resulting in hard lndg. Investigation revealed failure of accessory drive to magnetos. - [NTSB LAX89DUM01](https://openairdocs.org/ntsb/LAX89DUM01.md): Arlington Sisu 1A · Borrego Springs, CA · Accident · 1 fatal · Final report · Oct 15, 1988 · N252JB · Substantial damage > While thermal soaring, the acft entered a steep spinning descent, three turns to the right followed by two turns to the left and ground impact in a near vertical attitude. No evidence was found of aircraft structural failure or control malfunction. The… - [NTSB ATL89FA013](https://openairdocs.org/ntsb/ATL89FA013.md): Cessna 182E · Brooklet, GA · Accident · 1 fatal · Field investigation · Final report · Oct 14, 1988 · N2834Y · Destroyed > Witnesses reported the plt began a low altitude, high speed pass over the rwy as he had done on several previous occasions. However, as he initiated the pass, the descent to the rwy was not arrested & the airplane 'pancaked' near the threshold. The airplane… - [NTSB MKC89DPG01](https://openairdocs.org/ntsb/MKC89DPG01.md): Culver LFA · Dumas, AR · Accident · 1 fatal · Final report · Oct 13, 1988 · N34872 · Destroyed > A witness stated that the airplane backfired while in a turn at low altitude. He heard it backfire twice more and noticed engine running at idle just before it crashed. When runup, the engine would attain 1900 RPM, then backfire and the RPM would drop to 600… - [NTSB ANC89FA009](https://openairdocs.org/ntsb/ANC89FA009.md): Piper PA-12 · Little Heart Lk, AK · Accident · 2 fatal · Field investigation · Final report · Oct 13, 1988 · N3153M · Substantial damage > The pilot-in-command called a local pilot in the talkeetna area for weather and the conditions of the lake to determine if the lake's surface had frozen. He then departed for the lake at 1800 adt and was not heard from again. The airplane wreckage was located… - [NTSB LAX89DVA01](https://openairdocs.org/ntsb/LAX89DVA01.md): Ayres S2R · Traver, CA · Accident · Serious injuries · Final report · Oct 12, 1988 · N3087D · Substantial damage > While spraying a cotton field the engine lost power. The pilot executed a forced landing in an open area but rollout continued into crops. The acft nosed over. Investigation revealed only unuseable fuel on board. - [NTSB SEA89LA011](https://openairdocs.org/ntsb/SEA89LA011.md): Roman LONG-EZ · Salmon, ID · Accident · 1 fatal · Limited investigation · Final report · Oct 10, 1988 · N38AJ · Destroyed > The purpose of the flight was to spot wild game during feeding time (at dusk). The surviving passenger estimated the flight visibility was about one to two mi with smoke. While flying in close proximity to rugged, mountainous terrain, the acft struck a tree… - [NTSB FTW89DRG02](https://openairdocs.org/ntsb/FTW89DRG02.md): Douglas A-20G · San Benito, TX · Accident · 1 fatal · Final report · Oct 8, 1988 · N67921 · Destroyed > Incapacitation of the pilot while flying an aircraft due to loss of consciousness from a cardiac rhythm disturbance. - [NTSB NYC89FA006](https://openairdocs.org/ntsb/NYC89FA006.md): Piper PA-28-180 · Renovo, PA · Accident · 1 fatal · Field investigation · Final report · Oct 7, 1988 · N7293W · Destroyed > Improper VFR procedures the pilot's visual lookout was improper and he collided with a static wire. - [NTSB ANC89LA006](https://openairdocs.org/ntsb/ANC89LA006.md): Cessna 206 · Eagle, AK · Accident · No injuries · Limited investigation · Final report · Oct 6, 1988 · N734GW · Substantial damage > The pilot-in-command was attempting to air drop groceries to a mining site and a box of bread hit the horizontal stabilizer. The aircraft returned and landed uneventfully at Eagle airport. - [NTSB MIA89LA003](https://openairdocs.org/ntsb/MIA89LA003.md): Piper PA-38-112 · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Oct 5, 1988 · N91323 · Substantial damage > While practicing maneuvers near a grass airstrip, the left side of the engine cowling opened. The plt elected to perform a low pass to observe wind direction, then a precautionary landing at the airstrip. After touchdown, the acft became airborne and drifted… - [NTSB MIA89FA004](https://openairdocs.org/ntsb/MIA89FA004.md): Hughes 269C · Vero Beach, FL · Accident · No injuries · Field investigation · Final report · Oct 5, 1988 · N8602F · Destroyed > The plt stated that while doing a stuck left pedal maneuver, the helicopter was flown with a 5 degree yaw to the left. As the airspeed zeroed, the collective was brought in to bring the nose around and light contact was made with the ground. He then stated… - [NTSB LAX89LA009](https://openairdocs.org/ntsb/LAX89LA009.md): Bellanca 8KCAB · Alpine, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1988 · N5508H · Destroyed > During a telephone interview, the pilot stated that he had just recovered from a one turn spin and was in level flight when he felt the airplane pitch up. He added a small amount of nose down trim and the airplane pitched down. He stated that at this point… - [NTSB SEA89FA006](https://openairdocs.org/ntsb/SEA89FA006.md): Beech B-99A · East Sound, WA · Accident · No injuries · Field investigation · Final report · Oct 4, 1988 · N803BA · Substantial damage > The crew elected to depart the airport under a special VFR clearance. Wx at the departure airport was 700 ft ovc with visibility 1 and 1/4 miles. The destination airport was within 25 nautical miles of the departure airport and was reporting a bkn ceiling of… - [NTSB NYC89FA003](https://openairdocs.org/ntsb/NYC89FA003.md): Aeronca 11AC · Barnstead, NH · Accident · Serious injuries · Field investigation · Final report · Oct 3, 1988 · N9569E · Destroyed > The Aeronca 11AC was maneuvering downwind for landing. The pilot made a left turn towards the runway to tighten the pattern. While in close proximity to a house and the runway, at a low altitude the pilot elected to make a steep left 270 degree turn, opposite… - [NTSB LAX89FA006](https://openairdocs.org/ntsb/LAX89FA006.md): Beech A24R · Mt. Baldy, CA · Accident · 2 fatal · Field investigation · Final report · Oct 3, 1988 · N8065R · Destroyed > Pilot's improper in-flight decision and altitude. - [NTSB ANC89LA003](https://openairdocs.org/ntsb/ANC89LA003.md): Cessna 206 · Kodiak, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1988 · N122SC · Substantial damage > While flying through a mountain pass the pilot encountered a high wind condition. The pilot lost control of the airplane, and the airplane crashed at the 900 foot level. - [NTSB SEA89LA003](https://openairdocs.org/ntsb/SEA89LA003.md): Let L-13 · Enumclaw, WA · Accident · No injuries · Limited investigation · Final report · Oct 2, 1988 · N9241Z · Substantial damage > The pilot allowed the aircraft to become too close to terrain while soaring. A steep turn to reverse direction resulted in entry into an accelerated stall at low altitude. The pilot lowered the nose of the aircraft to recover, however, while lowering the nose… - [NTSB MKC89LA002](https://openairdocs.org/ntsb/MKC89LA002.md): Cessna 140 · Quinter, KS · Accident · No injuries · Limited investigation · Final report · Oct 2, 1988 · N73051 · Substantial damage > The pilot was flying at reduced power without the use of carburetor heat. The aircraft engine began to run rough. The pilot added carburetor heat and full throttle which resulted in the engine backfiring. The pilot elected to execute a precautionary landing.… - [NTSB ANC89LA002](https://openairdocs.org/ntsb/ANC89LA002.md): Piper PA-11 · Levelock, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 1988 · N4724M · Substantial damage > The airplane was at approximately 250 to 300 feet above sea level, and was executing a 360 degree turn to the left when the airplane stalled and crashed in the river. The pilot reported that he has never held a FAA pilot or medical certificate. - [NTSB MIA89LA001](https://openairdocs.org/ntsb/MIA89LA001.md): Robinson R22 · Orlando, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 1, 1988 · N2628B · Substantial damage > While practicing hovering the helicopter began to drift. The instructor plt corrected this & returned control to the student plt. The helicopter then began to descend & the instructor plt attempted to correct this with collective, but the student plt applied… - [NTSB DEN89FA001](https://openairdocs.org/ntsb/DEN89FA001.md): Cessna 152 · Eden, UT · Accident · 2 fatal · Field investigation · Final report · Oct 1, 1988 · N48926 · Destroyed > Before takeoff, the plt told ramp psnl that he & his wife were planning to take some pictures of the beautiful fall colors. A witness near the crash site observed an acft (matching the description of N48926) flying at low altitude. Subsequently, the acft… - [NTSB NYC88LA250](https://openairdocs.org/ntsb/NYC88LA250.md): Bellanca 14-13-2 · Sodus Bay, NY · Accident · No injuries · Limited investigation · Final report · Sep 30, 1988 · N74425 · Substantial damage > While on a low level pleasure flt over water the plt failed to maintain adequate terrain clearance and the left wing contacted the water. The acft crashed into the water and remained upright. The plt and pax exited the acft and were picked up by a passing… - [NTSB NYC88LA247](https://openairdocs.org/ntsb/NYC88LA247.md): Cessna 172P · New York, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1988 · N98305 · Destroyed > While on a night personal pleasure flt along the hudson river between New York and new jersey, at 300 feet AGL, the plt turned the acft toward an unlighted shore area and lost visual cues. The plt inadvertently flew the acft into the water. The acft sunk and… - [NTSB LAX88DVG10](https://openairdocs.org/ntsb/LAX88DVG10.md): Cessna A188B · Dixon, CA · Accident · 1 fatal · Final report · Sep 30, 1988 · N21871 · Destroyed > Plt had completed aerial application of a field several miles south. Witnesses heard sounds of acft. One witness observed acft briefly inverted and 'out of control.' Acft impacted open field upright, wings level and nose down. Fire ensued. No evidence found… - [NTSB NYC88DFJ04](https://openairdocs.org/ntsb/NYC88DFJ04.md): Callair A-9 · Churchville, NY · Accident · Serious injuries · Final report · Sep 29, 1988 · N8402V · Substantial damage > The pilot was engaged in aerial application activities. When he started a turn at low altitude to align himself for another spray run the aircraft stalled and struck the terrain. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=180 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=179 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.