# 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 184 of 377 · 18,850 cases ## Cases, newest first - [NTSB ANC88LA053](https://openairdocs.org/ntsb/ANC88LA053.md): Cessna 150L · Kotzebue, AK · Accident · 1 fatal · Limited investigation · Final report · May 4, 1988 · N6592G · Destroyed > The aircraft crashed five miles south of the city along the beach line. FAA inspectors, the Alaska state troopers accident report and several witnesses revealed that the pilot stated prior to the flight that he intended to commit suicide. The plt had a fight… - [NTSB ANC88FA052](https://openairdocs.org/ntsb/ANC88FA052.md): Piper PA-18-150 · Larson Bay, AK · Accident · 1 fatal · Field investigation · Final report · May 3, 1988 · N54768 · 2 aircraft · Destroyed > A float equipped Piper PA-18-150 and float equipped Cessna 185F, were involved in a midair collision at an altitude of approximately 800 feet MSL over Larson Bay, AK. At the time of the midair collision both aircraft were being used as fish spotters for… - [NTSB LAX88DVG03](https://openairdocs.org/ntsb/LAX88DVG03.md): Schweizer G-164B · Gridley, CA · Accident · No injuries · Final report · May 2, 1988 · N3627Q · Substantial damage > During an agricultural operation, the engine quit at approximately 50 feet AGL. The airplane was landed on a dirt field and nosed over. Inspection of the engine revealed that the left magneto drive gear teeth were missing and the right magneto drive gear was… - [NTSB SEA88LA087](https://openairdocs.org/ntsb/SEA88LA087.md): Stearman A-75-N1 · Medford, OR · Accident · Minor injuries · Limited investigation · Final report · May 1, 1988 · N53125 · Substantial damage > Plt performed a negative 'g' maneuver, estimated at 2 to 2.5 negative 'g' force, following which the engine lost power. A forced landing was accomplished in scrub trees. The engine is equipped with a float carburetor. There were indications that the cause of… - [NTSB CHI88FA102](https://openairdocs.org/ntsb/CHI88FA102.md): Bellanca 7ECA · Merrimac, WI · Accident · 1 fatal · Field investigation · Final report · May 1, 1988 · N31288 · Destroyed > The pilot had just taken off from a private strip and immediately entered a high angle of bank turn to the left at low altitude. A witness, who was an experienced aerobatic pilot, estimated the angle of bank to approach 90 degrees. The nose was seen to pitch… - [NTSB FTW88DRA11](https://openairdocs.org/ntsb/FTW88DRA11.md): Cessna L-19E · Conroe, TX · Accident · 1 fatal · Final report · Apr 30, 1988 · N3946L · Destroyed > The airplane was observed by witnesses making a chandelle-like maneuver from takeoff. At the top, the nose and right wing dropped for approximately 180 degrees of turn. The wings were almost level when the airplane hit the runway. The airplane burned after… - [NTSB CHI88FA101](https://openairdocs.org/ntsb/CHI88FA101.md): Cessna 152 · Lonsdale, MN · Accident · 1 fatal · Field investigation · Final report · Apr 28, 1988 · N67338 · Destroyed > The student pilot was on his first solo flight outside the airport traffic area and was practicing maneuvers prescribed by his flight instructor including slow flight and stall type maneuvers. The aircraft experienced a loss of control, followed by an… - [NTSB ANC88FA051](https://openairdocs.org/ntsb/ANC88FA051.md): Beech C55 · Tyonek, AK · Accident · 2 fatal · Field investigation · Final report · Apr 27, 1988 · N2730T · Substantial damage > The two pilots were operating the aircraft under the authority of a ferry permit which allowed flt only during day VFR conditions and with a single pilot. They requested and received just the weather at the destination airport, which was VMC. En route the flt… - [NTSB BFO88DIG02](https://openairdocs.org/ntsb/BFO88DIG02.md): Lamb Shoestring S-102 · Gaithersburg, MD · Accident · 1 fatal · Final report · Apr 24, 1988 · N47CL · Destroyed > The pilot inproperly performing aerobatics without sufficient altitude to complete a recovery. - [NTSB LAX88DUA01](https://openairdocs.org/ntsb/LAX88DUA01.md): Hernandez Thorp T-18 · Palos Verdes, CA · Accident · 2 fatal · Final report · Apr 23, 1988 · N1394A · Destroyed > The pilot was demonstrating the acft for the passenger for a possible sale. They were part of a flight of two over the pacific ocean. The owner of the aircraft being demonstrated was in the second aircraft. The pilot of the demo acft radioed to the second… - [NTSB ATL88LA149](https://openairdocs.org/ntsb/ATL88LA149.md): Rolladen-Schneider LS-4 · Chester, SC · Accident · No injuries · Limited investigation · Final report · Apr 22, 1988 · N45BD · 2 aircraft · Destroyed > While thermaling during the sailplane competition, N45BD was slightly higher and to the left of N295SZ. N45BD made a right turn and struck the right inboard wing section of N294SZ with the outboard wing tip of N45BD. The outboard wing tip of N45BD separated… - [NTSB SEA88LA081](https://openairdocs.org/ntsb/SEA88LA081.md): Rockwell A-9B · Grace, ID · Accident · 1 fatal · Limited investigation · Final report · Apr 19, 1988 · N7657V · Destroyed > Plt/owner not certificated for aerial application. No record found of prior experience in aerial application. Replaced certificated plt for undet reason. Witnesses observed acft enter stall/spin during first aerial application turnaround maneuver in strong… - [NTSB LAX88FA163](https://openairdocs.org/ntsb/LAX88FA163.md): Aerospatiale AS355F · Cajon, CA · Accident · 2 fatal · Field investigation · Final report · Apr 17, 1988 · N5777P · Destroyed > Pilot's failure to maintain altitude. - [NTSB MIA88LA152](https://openairdocs.org/ntsb/MIA88LA152.md): Denney Kitfox · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Apr 16, 1988 · N84DD · Substantial damage > The plt stated that he was flying in the homebuilt acft area at the 'sun and fun fly in' when the engine quit. An attempt was made to land in a field, which he couldn't make, and came to rest in some scrub trees. The plt also stated that he had been having… - [NTSB MIA88LA146](https://openairdocs.org/ntsb/MIA88LA146.md): Fischer STAR-LITE · Lakeland, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 1988 · N20RF · Destroyed > The owner/manufacturer of the homebuilt acft repaired the horizontal stabilizers, then asked the designer to test fly the aircraft. After takeoff, at an alt of aprx 7,000 feet MSL, in a nose low attitude, at 158 mph ( 28 mph greater than vne) both horizontal… - [NTSB SEA88LA076](https://openairdocs.org/ntsb/SEA88LA076.md): Cessna 172M · Lake Mead, NV · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1988 · N91555 · Destroyed > The pilot was flying very close to the water for the purpose of dropping beer to friends. The pilot allowed the aircraft to inadvertently descend and strike the water. - [NTSB MIA88DL001](https://openairdocs.org/ntsb/MIA88DL001.md): Falcon Special S/R · Lakeland, FL · Accident · Serious injuries · Final report · Apr 10, 1988 · N82RC · Substantial damage > The pilot experienced an in flight fire in the exhaust system while performing acrobatic maneuvers at an airshow. The aircraft is equipped with a pump that injects oil into the exhaust system to produce a visible smoke trail when vaporized by the exhaust… - [NTSB FTW88DPJ04](https://openairdocs.org/ntsb/FTW88DPJ04.md): Aerotek Pitts S-2A · Elk City, OK · Accident · 1 fatal · Final report · Apr 10, 1988 · N8076 · Destroyed > The aircraft was observed doing aerobatics. A stall/spin was initiated from a climbing vertical attitude. Corrective action was not accomplished by the pilot and the aircraft was observed to spin to ground impact. No aircraft malfunctions were found. - [NTSB CHI88DEM04](https://openairdocs.org/ntsb/CHI88DEM04.md): Anderson Pitts S-1S · Mt. Pleasant, MI · Accident · No injuries · Final report · Apr 10, 1988 · N528MS · Substantial damage > The pilot was performing some inverted maneuvers when the engine quit. The pilot stated he attempted to restart the engine but was unable to. He then executed an emergency landing in a farm field. During the landing roll the pilot was unable to maintain… - [NTSB ANC88DAG03](https://openairdocs.org/ntsb/ANC88DAG03.md): Piper PA-14 · Glennallen, AK · Accident · No injuries · Final report · Apr 5, 1988 · N5188H · Substantial damage > The pilot stated that he was flying up a fairly wide valley containing a ridge that he had to fly over. The ground was completely white with snow. The pilot noticed a hill directly in front of the aircraft; he started a turn and the aircraft struck the snow… - [NTSB FTW88DRA05](https://openairdocs.org/ntsb/FTW88DRA05.md): Hiller UH-12E · La Salle, TX · Accident · No injuries · Final report · Apr 4, 1988 · N4029D · Substantial damage > Acft was substantially damaged during an emergency autorotation following an engine failure while the acft was completing an aerial application maneuver. Acft touched down tail low and the main rotor blades flexed down and cut off the tail boom. Investigation… - [NTSB CHI88FA092](https://openairdocs.org/ntsb/CHI88FA092.md): Cessna 207 · Hardwick, MN · Accident · 1 fatal · Field investigation · Final report · Apr 4, 1988 · N207CA · Destroyed > Witnesses observed the aircraft for aprx 8 minutes in erratic diving, climbing, and steep-turning maneuvers which culminated in a 12 degree descent to the ground. The sound of the eng was heard throughout the sequence and other evidence indicated engine power… - [NTSB CHI88DEM03](https://openairdocs.org/ntsb/CHI88DEM03.md): Grumman G-164A · Allegan, MI · Accident · No injuries · Final report · Apr 4, 1988 · N84PG · Substantial damage > The pilot had just completed two swath runs and was turning to start the third when the aircraft began to buffet and approached a stall. The pilot then lowered the nose of the aircraft and added full throttle. After applying full throttle the pilot stated he… - [NTSB LAX88FA150](https://openairdocs.org/ntsb/LAX88FA150.md): Piper PA-28-180 · Ukiah, CA · Accident · 1 fatal · Field investigation · Final report · Apr 3, 1988 · N15847 · Destroyed > The pilot failed to maintain control of his aircraft. Contributing factors were the pilot's lack of recent IFR experience, spatial disorientation and his failure to perform remedial action. - [NTSB LAX88DVA03](https://openairdocs.org/ntsb/LAX88DVA03.md): Cessna 188B · Gustine, CA · Accident · No injuries · Final report · Apr 2, 1988 · N21762 · Substantial damage > During an aerial application maneuver, at 70 ft. a.g.l., the engine lost all power. The pilot leveled the wings and dumped the remaining load. The engine regained full power, backfired, then lost power again. The aircraft collided with almond trees. An… - [NTSB DEN88FA089](https://openairdocs.org/ntsb/DEN88FA089.md): Burkhart Grob G103A · Boulder, CO · Accident · 2 fatal · Field investigation · Final report · Apr 2, 1988 · N788G · Destroyed - [NTSB ATL88LA127](https://openairdocs.org/ntsb/ATL88LA127.md): Cessna 150J · Guntersville, AL · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1988 · N50715 · Substantial damage > The seaplane collided with the water shortly after takeoff. The plt rptd that a large spider dropped in front of him and distracted him. The airplane was in a gradual right turn about 100 ft above the water at the time. He attempted to swat the spider with… - [NTSB MIA88LA131](https://openairdocs.org/ntsb/MIA88LA131.md): Cessna 172N · Key West, FL · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N739DQ · Substantial damage > According to the plt he was on a fish spotting flight. The acft lost power. The plt ditched in the ocean. He was picked up by a passing boat & taken to Key West, FL. He stated that due to the past history of this acft, his opinion was that the cause of the… - [NTSB LAX88LA141](https://openairdocs.org/ntsb/LAX88LA141.md): Cessna 172RG · Malibu, CA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N9609B · Destroyed > The pilot stated that the purpose of the flight was to allow the passenger to photograph some yachts sailing off the Malibu coast. The pilot said that he initiated a turn at 300 feet AGL around one of the yachts and the aircraft 'suddenly stalled' and he was… - [NTSB ATL88FA123](https://openairdocs.org/ntsb/ATL88FA123.md): Beech C23 · Sevierville, TN · Accident · 4 fatal · Field investigation · Final report · Mar 22, 1988 · N9272S · Substantial damage > The aircraft was not certified for acrobatic flight. According to several witnesses the pilot was practicing acrobatics with three passengers on board. The pilot lost control of the aircraft and did not recover. - [NTSB DEN88GA088](https://openairdocs.org/ntsb/DEN88GA088.md): Bell 47G-3B1 · Gobernador, NM · Accident · No injuries · Final report · Mar 21, 1988 · N7863S · Substantial damage > The commerical plt was hovering out of ground effect at 40 feet AGL. During a maneuver he reported hearing a loud bang and the rotor RPM began to decay. The plt made a hovering autorotation resulting in a hard landing. The main rotor struck the tail boom and… - [NTSB MKC88LA064](https://openairdocs.org/ntsb/MKC88LA064.md): Cessna 188B · Manter, KS · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 1988 · N21653 · Destroyed > While conducting a team aerial application operation, the trailing aircraft struck the terrain with the right wing tip, rotated in a flat attitude about 2 turns, and was destroyed by fire. The pilot said, while in a downwind procedure turnaround, into the… - [NTSB ATL88LA120](https://openairdocs.org/ntsb/ATL88LA120.md): Slingsby Dart T-51 · Whitwell, TN · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 1988 · N209K · Destroyed > The glider was observed to make a normal release. While still in a turn it encountered a wind shear and rolled into a vertical bank. It sideslipped for a few seconds then the nose dropped into a vertical dive. The pilot stated that when he attempted to pull… - [NTSB FTW88LA081](https://openairdocs.org/ntsb/FTW88LA081.md): Cessna 150L · Weatherford, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1988 · N10842 · Destroyed > A forced landing was attempted following a complete eng failure. The plt overshot the intended touchdown pt and pulled the acft off the grnd in an attempt to clear a busy hwy. however, the acft struck wires located next to the road. Evidence indicated that… - [NTSB SEA88LA058](https://openairdocs.org/ntsb/SEA88LA058.md): Cessna 152 · Gold Bar, WA · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 1988 · N4932H · Substantial damage > The instructor pilot and his dual student flew into a canyon area. The aircraft was allowed to fly too close to rising terrain which the aircraft was unable to outclimb. During a turn to reverse direction the aircraft collided with terrain. The CFI stated… - [NTSB ATL88FA118](https://openairdocs.org/ntsb/ATL88FA118.md): Champion 7BCM · Bishopville, SC · Accident · 2 fatal · Field investigation · Final report · Mar 17, 1988 · N82782 · Destroyed > The student pilot, carrying a passenger, attempted a low level maneuver, and stalled the aircraft. He was unable to recover in the altitude available and the aircraft struck the ground. Toxicological tests on the blood/urine were done on the PIC. The blood… - [NTSB LAX88DVD03](https://openairdocs.org/ntsb/LAX88DVD03.md): Paxton RV-3A · Antioch, CA · Accident · Serious injuries · Final report · Mar 15, 1988 · N87JP · Destroyed > While performing aerobatic maneuvers, the aircraft was seen to have entered a spin. At approximately 300 feet the aircraft recovered, however, the left wing was seen to be bent upward and the fiberglass tip was dangling from the wing. The aircraft impacted… - [NTSB ATL88LA115](https://openairdocs.org/ntsb/ATL88LA115.md): Cessna 172K · Butler, AL · Accident · No injuries · Limited investigation · Final report · Mar 15, 1988 · N78840 · Substantial damage > The plt rptd that he observed the engine oil pressure indication drop to zero during a low-level pipeline patrol flight. He attempted to increase engine pwr and initiate a climb, but the engine began to run rough. He subsequently landed on the pipeline… - [NTSB ATL88LA111](https://openairdocs.org/ntsb/ATL88LA111.md): Taylorcraft BC-65 · Maiden, NC · Accident · Minor injuries · Limited investigation · Final report · Mar 13, 1988 · N23899 · Substantial damage > The aircraft had been flying a series of low level maneuvers over the city. The pilot was attempting to recover from an intentional spin close to the ground when the aircraft struck utility lines and impacted the ground. - [NTSB MIA88LA125](https://openairdocs.org/ntsb/MIA88LA125.md): Cessna 150M · Jacksonville, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 11, 1988 · N22CE · Substantial damage > The pilot stated that he did not visually check the fuel quantity prior to departure on an aerial photography flight. About.9 hours after takeoff the engine failed due to fuel exhaustion. The pilot executed a forced landing and the aircraft crashed. Both the… - [NTSB LAX88LA126](https://openairdocs.org/ntsb/LAX88LA126.md): Bell 47G-2A-1 · Oceanside, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 11, 1988 · N73969 · Destroyed > The non-U.S. Certificated pilot lost control of the helicopter while hovering 3-FT AGL during a maintenance test flight. The acft descended, touched down hard and rolled over. The non-english speaking pilot immediately departed the scene & reportedly headed… - [NTSB ANC88LA039](https://openairdocs.org/ntsb/ANC88LA039.md): Cessna 207 · Ruby, AK · Accident · No injuries · Limited investigation · Final report · Mar 11, 1988 · N70364 · Substantial damage > The aircraft was over the airport at 2,000 feet MSL when the engine quit. The aircraft crashed one mile north of the airport. Examination of the aircraft engine revealed a broken throttle control which would cause the engine to go to idle. - [NTSB ATL88IA108](https://openairdocs.org/ntsb/ATL88IA108.md): Boeing 737 · Greensboro, NC · Incident · No injuries · Incident investigation · Final report · Mar 10, 1988 · N13331 · 2 aircraft · No damage > Continental flt 458 (Boeing 737, N13331) was flying NE at FL370 as Continental flt 703 (Boeing 737, N432PE) was flying fm the opposite drctn at FL350. Both flts were on the same freq, being ctld by atlanta ARTCC (sector 47) ctlr, who had just come on duty. In… - [NTSB MIA88LA121](https://openairdocs.org/ntsb/MIA88LA121.md): Schleicher K-8B · Miami, FL · Accident · No injuries · Limited investigation · Final report · Mar 7, 1988 · N4663S · Substantial damage > The plt stated that he had placed the glider into a mild dive & was indicating 90 to 95 mph, well below redline speed when the whole section of the trailing edge of the wing from the aft spar & wing root out to a dist of about 6 ft, separated from the acft.… - [NTSB MIA88LA203](https://openairdocs.org/ntsb/MIA88LA203.md): Hunter Velocity · Merritt Island, FL · Accident · Serious injuries · Limited investigation · Final report · Mar 4, 1988 · N128JM · Substantial damage > While checking the stall characteristics of a homebuilt acft, the acft descended in a stalled condition until crashing into a river. The plt was unable to lower the nose. Investigation revealed that he improperly positioned baffles in the fuel tanks resulting… - [NTSB DEN88DTM01](https://openairdocs.org/ntsb/DEN88DTM01.md): Cessna 188 · Riverton, UT · Accident · Serious injuries · Final report · Mar 2, 1988 · N8073V · Destroyed > This ag operator was fertilizing a field. He was making repetative trips which took about 10 min each. The plt was aware that the fuel gauges were inaccurate, reading less fuel than was actually onboard. While making a swath run the eng lost pwr and the acft… - [NTSB MIA88LA118](https://openairdocs.org/ntsb/MIA88LA118.md): Cessna 152 · Columbus, MS · Accident · Minor injuries · Limited investigation · Final report · Feb 29, 1988 · N65532 · Substantial damage > The plt stated that he was simulating a loss of power & then attempting to turn back to the arpt & land on the runway that they departed from. As he was turning back from an approximate altitude of 600 feet, the acft stalled & crashed. - [NTSB BFO88FID01](https://openairdocs.org/ntsb/BFO88FID01.md): Perkins Christen Eagle II · Williamsburg, VA · Accident · 2 fatal · Final report · Feb 28, 1988 · N115MC · Destroyed > Witnesses saw the acft performing aerobatics which included loops and rolls. The acft was climbing in a loop when it suddenly pitched down and descended to the ground. Some witnesses said the acft was spinning as it descended. - [NTSB NYC88LA094](https://openairdocs.org/ntsb/NYC88LA094.md): Cessna 172 · North Hanover, NJ · Accident · No injuries · Limited investigation · Final report · Feb 26, 1988 · N738MX · Substantial damage > The eng lost power while the acft was circling at aprx 1500 ft AGL & the occupants were engaged in aerial photography. Subsequently, the acft was damaged during an emergency landing in a swampy area. An exam of the acft revealed the left tank was empty. The… - [NTSB CHI88DER02](https://openairdocs.org/ntsb/CHI88DER02.md): Bellanca 7GCBC · Warroad, MN · Accident · 2 fatal · Final report · Feb 26, 1988 · N53808 · Destroyed > The aircraft experienced a loss of control and rapid descent onto the ice in what witnesses described as a spin type maneuver from a low altitude. The purpose of the flight was a low level photo mission. The aircraft was destroyed. The pilot and passenger… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=185 ## 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=184 --- 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.