# 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 216 of 378 · 18,851 cases ## Cases, newest first - [NTSB MIA84FA116](https://openairdocs.org/ntsb/MIA84FA116.md): Alleva Starduster SA300 · Lakeland, FL · Accident · 2 fatal · Field investigation · Final report · Mar 18, 1984 · N688 · Destroyed > The owner/builder of the acft & his wife were flying at aprx 800 ft AGL when the plane rolled to a near inverted attitude & entered a dive. Before entering the maneuver, the plt was observed waving to friends & acquaintances who resided in the area. Before… - [NTSB FTW84FA171](https://openairdocs.org/ntsb/FTW84FA171.md): Bellanca 8KCAB · Kiefer, OK · Accident · 2 fatal · Field investigation · Final report · Mar 17, 1984 · N5502V · Destroyed > The acft was destroyed as it spun into the ground after having been observed doing aerobatics between 800 and 1500 AGL. The maneuvers included barrel rolls and hammerhead stalls. The last maneuver ended in a spin that was said to last ABOUT5 turns before… - [NTSB MIA84FA112](https://openairdocs.org/ntsb/MIA84FA112.md): Swanson/Bensen B-8M · Dunnellon, FL · Accident · 1 fatal · Field investigation · Final report · Mar 16, 1984 · N8067W · Substantial damage > The student plt was told by the owner of the acft to only taxi the acft & not to fly it. During the 6th taxi maneuver it became airborne. It climbed to about 200 ft AGL where the plt made a 180 deg turn, followed by a 90 deg turn, followed by another 180 deg… - [NTSB LAX84FA220](https://openairdocs.org/ntsb/LAX84FA220.md): North American T-28B · Rialto, CA · Accident · 2 fatal · Field investigation · Final report · Mar 16, 1984 · N14110 · Destroyed > Plt was authorized by acft owner to test fly the acft around the traffic pattern with a local FBO owner on board. Plt made 3 flts, last of which culminated in the accident. On the first and third flts, unauthorized passengers were on board. FBO owner stated… - [NTSB MIA84FA106](https://openairdocs.org/ntsb/MIA84FA106.md): Southern Comfort · Lakeland, FL · Accident · Serious injuries · Field investigation · Final report · Mar 15, 1984 · N19FH · Destroyed > While performing aerobatics at an airshow, the fabric on top of the upper wing started separating from the wing. The plt continued flying the acft & tried to return to the arpt. However, when flt could not be maintained with full power, due to loss of… - [NTSB SEA84LA066](https://openairdocs.org/ntsb/SEA84LA066.md): Hiller UH-12E · Forest Grove, OR · Accident · No injuries · Limited investigation · Final report · Mar 12, 1984 · N62377 · Substantial damage > The plt reported that while hovering, during an external load operation, the eng lost power & blue smoke & flames exited the back of the helicopter. The helicopter then struck trees before coming to rest. During an investigation, the eng started normally &… - [NTSB LAX84FA215](https://openairdocs.org/ntsb/LAX84FA215.md): Cessna 150M · Clovis, CA · Accident · 2 fatal · Field investigation · Final report · Mar 12, 1984 · N66436 · Destroyed > The plt had called his girlfriend to say he was going to fly over her house an that he wanted her to wave at him as he flew past. In flying low over her house the plt waved and yelled loud enough to be heard on the ground. A friend said that during a… - [NTSB LAX84LA216](https://openairdocs.org/ntsb/LAX84LA216.md): Burkhart Grob G102 Astir CS · Marana, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1984 · N128SS · Substantial damage > The plt initially lined up for a straight-in approach to land, but on final approach, he decided to make a 360 deg turn to land in front of spectators who were along the beginning of the airstrip. As he was completing the turn to land, the left wing contacted… - [NTSB ATL84FMG01](https://openairdocs.org/ntsb/ATL84FMG01.md): Schleicher KA6CR · Marion, NC · Accident · Serious injuries · Final report · Mar 10, 1984 · N4221G · Substantial damage > The plt attempted a 360 deg turn prior to landing, while at a low altitude and crashed after aprx 150 to 180 degs of the turn. - [NTSB NYC84LA105](https://openairdocs.org/ntsb/NYC84LA105.md): Cessna 150K · Livermore, ME · Accident · No injuries · Limited investigation · Final report · Mar 8, 1984 · N5685G · Substantial damage > The student plt, practicing level flt and turns during a power off descent, advanced the throttle without engine response. There was no suitable landing area so the plt elected to stall the acft into the trees. - [NTSB ANC84LA041](https://openairdocs.org/ntsb/ANC84LA041.md): Maule M-5-235C · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Mar 8, 1984 · N56304 · Substantial damage > The pilot told flight service personnel that the aircraft struck the ground while circling. His passenger was attemptingto photograph something on the ground. - [NTSB LAX84FU025](https://openairdocs.org/ntsb/LAX84FU025.md): Wizard J-3BR503 · Lake Elsinore, CA · Accident · 1 fatal · Final report · Mar 7, 1984 · UNREG · Destroyed > The acft collided with the ground in a past vertical inverted position. The wings failed in negative load after the plt lost control in pitch with the airspeed decreasing and stalled into a dive. The plt was on his first solo flt and his instructor was… - [NTSB DEN84LA105](https://openairdocs.org/ntsb/DEN84LA105.md): Callair A · Tremonton, UT · Accident · No injuries · Limited investigation · Final report · Mar 6, 1984 · N8260H · Substantial damage > The acft collided with a snow covered field while the plt was applying carbon black and fertilizer to induce snow melt. The overcast sky'gave a white-out effect on depth perception'. The collision with a rise in the field tore off the landing gear and the… - [NTSB MIA84LA096](https://openairdocs.org/ntsb/MIA84LA096.md): Heinemann Rotorway Executive · Ft. Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N44818 · Destroyed > The commercial/atp plt was not rated for helicopters. He stated that 'while in flt position' to check the cyclic pressures, a strong gust of wind lifted the helicopter off the ground & rolled it over on its side. He believed that this would not have happened… - [NTSB FTW84LA154](https://openairdocs.org/ntsb/FTW84LA154.md): Bell 206L-1 · Intracstl City, LA · Accident · Serious injuries · Limited investigation · Final report · Mar 3, 1984 · N27798 · Substantial damage > The helicopter collided with marsh terrain while spotting dead alligators. The plt does not remember events of the accident. The helicopter operator stated the helicopter appeared to have impacted at a low airspeed at a normal RPM. The emergemcy floats were… - [NTSB DEN84FTM01](https://openairdocs.org/ntsb/DEN84FTM01.md): Keith A Smith KR-2 · Salt Lake City, UT · Accident · 1 fatal · Final report · Feb 26, 1984 · N54KS · Destroyed > The acft collided with a mountain ridge in a flat'pancake'attitude,no evidence of foward motion was apparent and all thewreckage was confined to the immediate area. The wooden prop was intact with the exception of 2 inches missing from the end of one blade,… - [NTSB CHI84FA119](https://openairdocs.org/ntsb/CHI84FA119.md): Cessna 152-II · Manhattan, IL · Accident · 1 fatal · Field investigation · Final report · Feb 26, 1984 · N4972H · Destroyed > The acft was observed entering a spin from a nose high attitude from which it failed to recover. The student pilot was seen waving to his family as the acft circled in the vicinity of his parent's home. There was no evidence of preimpact failure or… - [NTSB ATL84FLT03](https://openairdocs.org/ntsb/ATL84FLT03.md): Cessna A-188B · Crawford, MS · Accident · Serious injuries · Final report · Feb 25, 1984 · N731RJ · Destroyed > The acft stalled during an aerial application turn-around. Before recovery from the stall, the acft collided with trees, a power line and the ground. No evidence of a preimpact malfunction was found or reported. - [NTSB SEA84FA060](https://openairdocs.org/ntsb/SEA84FA060.md): Cessna 172N · Kent, WA · Accident · 3 fatal · Field investigation · Final report · Feb 24, 1984 · N4603F · 2 aircraft · Destroyed > At about 1345 PST, the plt of a Cessna 172N, N4603F, departed crest airpark, Kent, WA, on a local pleasure flt. Aprx 5 min later, the plt & 1 passenger of a float equipped Cessna 180, N4908A, took off from lake meridian, Kent, WA, & were also on a local… - [NTSB LAX84LA194](https://openairdocs.org/ntsb/LAX84LA194.md): Bell 47-G4A · Dixon, CA · Accident · No injuries · Limited investigation · Final report · Feb 24, 1984 · N9017N · Destroyed > The acft crashed during a forced landing after the engine quit. The plt stated that, 'three minutes into the crop dusting mission the engine quit and he suspected fuel mismanagement.' - [NTSB MKC84FU001](https://openairdocs.org/ntsb/MKC84FU001.md): Pioneer Flightstar · Blytheville, AR · Accident · Serious injuries · Final report · Feb 23, 1984 · UNREG · Substantial damage > The acft spun into the ground from about 500 ft AGL. The vehicle had been observed by witnesses to be in slow flt makingturns to the right. After 180 degrees of turn, the nose pitched down to about 60 degrees and the left wing went down to about 75 degrees of… - [NTSB FTW84LU004](https://openairdocs.org/ntsb/FTW84LU004.md): Vampire Satalar · Pearland, TX · Accident · Serious injuries · Final report · Feb 22, 1984 · UNREG · Destroyed > The acft departed the Pearland arpt, climbed to about 150 feet AGL, entered a left turn, stalled and crashed through themetal roof of a hangar. The plt stated he was eager to get airborne and fly the traffic pattern before sundown. He stated that he climbed… - [NTSB FTW84LA145](https://openairdocs.org/ntsb/FTW84LA145.md): Grumman G-164A · Abbeville, LA · Accident · 1 fatal · Limited investigation · Final report · Feb 22, 1984 · N9728 · Destroyed > The plt was employed as a professional corporate & charter plt; however, he had not flown agricultural acft in several years. He had receently purchased half interest in the air sevice & was on his 1st refresher flt since then. While the plt was practicing a… - [NTSB FTW84LA144](https://openairdocs.org/ntsb/FTW84LA144.md): Bell 47G4A · Refugio, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 21, 1984 · N7956J · Destroyed > The helicopter was being used to herd cattle in a heavily wooded/brushy area. The plt reported he was in a hover maneuver at 50-60 ft AGL when he heard a loud sound from the rear of the helicopter. It immediately pitched nose down & started to rotate to the… - [NTSB DEN84FA095](https://openairdocs.org/ntsb/DEN84FA095.md): Cessna 152 · Franktown, CO · Accident · 2 fatal · Field investigation · Final report · Feb 20, 1984 · N89182 · Destroyed > The acft was observed circling for about 10 minutes. Afterwards, pwr decreased and the acft descended. During descent an occasional burst of pwr was heard. When the acft neared the ground it nosed up & down along with an increase in eng pwr. Witnesses stated… - [NTSB FTW84LA140](https://openairdocs.org/ntsb/FTW84LA140.md): Cessna 152 · Ada, OK · Accident · Serious injuries · Limited investigation · Final report · Feb 19, 1984 · N6558M · Destroyed > The acft collided with powerlines during a low level flt along the canadian river and fell into the shallow water. The plt who is a fireman said he had descended to observe a grass fire burning along side the river. - [NTSB MIA84FA082](https://openairdocs.org/ntsb/MIA84FA082.md): Cessna 152 · Cooper City, FL · Accident · 2 fatal · Field investigation · Final report · Feb 17, 1984 · N5408M · Destroyed > Witnesses saw the acft in a spin prior to impact. They stated that the plt was seen doing practice airwork in the area. - [NTSB FTW84LA138](https://openairdocs.org/ntsb/FTW84LA138.md): Piper PA-31 · Brownsville, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1984 · N7415L · Substantial damage > The plt was maneuvering for an ILS approach when he collided with the ground. He said he was distracted by the swinging CDI and was below the glide slope. He said he started to add power for a missed approach and the acft impacted the ground. A passenger said… - [NTSB ATL84FA100](https://openairdocs.org/ntsb/ATL84FA100.md): Bell 47GL · Cullman, AL · Accident · 1 fatal · Field investigation · Final report · Feb 17, 1984 · N12KH · Destroyed > The plt had just completed an eng overhaul & was test flying the helicopter. While maneuvering at aprx 100 ft AGL, the eng lost power & the plt initiated an autorotation. During the landing, the helicopter impacted hard on rising terrain, rolled onto its side… - [NTSB MIA84FA081](https://openairdocs.org/ntsb/MIA84FA081.md): Bell 47-G · Cedar Key, FL · Accident · Serious injuries · Field investigation · Final report · Feb 16, 1984 · N6357 · Substantial damage > The helicopter turned and descended from an out of ground effect hover. The rpms dropped and the acft hit the ground hard. - [NTSB FTW84LA137](https://openairdocs.org/ntsb/FTW84LA137.md): Piper PA-25-150 · Altus, OK · Accident · 1 fatal · Limited investigation · Final report · Feb 16, 1984 · N6090Z · Destroyed > The acft crashed in a wheat field that was being spray, then was destoyed by a post crash fire. According to the operator, the plt was at the end of a swath run when he glanced into the cockpit to visually check how much chemical was remaining in the hopper.… - [NTSB MIA84LA080](https://openairdocs.org/ntsb/MIA84LA080.md): Cessna T-188 · Arcadia, FL · Accident · No injuries · Limited investigation · Final report · Feb 15, 1984 · N9932J · Substantial damage > The plt was maneuvering at low alt and low airspeed during aerial application. During a steep (80 bank) the acft stalledand crashed. - [NTSB MIA84FA078](https://openairdocs.org/ntsb/MIA84FA078.md): Hiller UH-12E · Waldo, FL · Accident · Serious injuries · Field investigation · Final report · Feb 15, 1984 · N19MP · Destroyed > The acft was being used to dispense aerial incendiary devices (aids) to control forest burning. The aids were 1.25 inch diameter polystyrene balls containing potassium permanganate. They were injected with ethylene glycol prior to being dropped out of the… - [NTSB LAX84FA180](https://openairdocs.org/ntsb/LAX84FA180.md): Maupin WOODSTOCK-I · California City, CA · Accident · 1 fatal · Field investigation · Final report · Feb 13, 1984 · N71W · Destroyed > During flt, the glider sustained an in-flt failure of both wings, then entered an uncontrolled descent & crashed. An exam of the wreckage revealed no preexisting structural problems. The glider was equipped with a recording barograph. A barograph trace showed… - [NTSB FTW84LA136](https://openairdocs.org/ntsb/FTW84LA136.md): Sikorsky S-58E · Morgan City, LA · Accident · Serious injuries · Limited investigation · Final report · Feb 13, 1984 · N70709 · Substantial damage > The helicopter was hovering above trees at about 100 ft AGL when the tail rotor chip detector lgt flickered svrl times, then illuminated steadily. This was followed by a loud grinding noise from the tail area & the acft yawed to the right. The acft entered an… - [NTSB ATL84FA099](https://openairdocs.org/ntsb/ATL84FA099.md): Piper PA-30-160 · Massies Mill, VA · Accident · 1 fatal · Field investigation · Final report · Feb 13, 1984 · N8742Y · Destroyed > While en route, the plt was progressing northbound when he contacted the Washington fss at 2134 EST for updated wx info. At that time, he described his position as north of lynchburg, VA. The fss briefer noted that his voice was normal, his manner was calm &… - [NTSB LAX84LA168](https://openairdocs.org/ntsb/LAX84LA168.md): Moseley/Scorpion 133 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 1984 · N4661U · Substantial damage > The plt stated that he intended only to grt the helicopter 'in a light position to check for balance and cyclic position. He further stated that a gust of wind caused a total lift off and he over-controlled the acft which rolled andcrashed sideways in a… - [NTSB FTW84LA130](https://openairdocs.org/ntsb/FTW84LA130.md): Bell 47G-2A · Benavides, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 1984 · N8478E · Substantial damage > The plt was herding cattle when an eng failure occurred over a small group of trees. The plt auto-rotated and the acft landed hard. - [NTSB FTW84FA127](https://openairdocs.org/ntsb/FTW84FA127.md): American AA-1A · Lampasas, TX · Accident · 2 fatal · Field investigation · Final report · Feb 6, 1984 · N9480L · Destroyed > The acft descended into the ground along the east bank of the Colorado river at about a 45 deg angle to the horizon in a wings level attitude. There were no witnesses to the accident. Investigation revealed that the plt was planning a springtime canoe trip… - [NTSB DEN84LA083](https://openairdocs.org/ntsb/DEN84LA083.md): Maule M-4S · Three Forks, MT · Accident · Minor injuries · Limited investigation · Final report · Feb 5, 1984 · N9832M · Substantial damage > The plt was flying low toward rising terrain. The airspeed slowed to the point that the point that the acft mushed into the ground and cartwheeled. The plt said he had not removed all the frost on the wings prior to flt and he thought the stall speed was… - [NTSB MIA84LA071](https://openairdocs.org/ntsb/MIA84LA071.md): Piper PA-28-140 · Naranjito, PR · Accident · Serious injuries · Limited investigation · Final report · Feb 3, 1984 · N15MM · Substantial damage > The acft collided with hilly terrain during a low pass. The plt was preparing to land at a nearby private airstrip. - [NTSB DEN84FA081](https://openairdocs.org/ntsb/DEN84FA081.md): Enstrom F-28C · Chester, MT · Accident · 1 fatal · Field investigation · Final report · Feb 1, 1984 · N776FS · Destroyed > According to a company employee, the plt made a radio call from a remote mountain site where the plt was doing some workon a transmitter tower & stated that he was taking off, & if the employee did not hear from him in an hour to come look for him. The… - [NTSB LAX84LA160](https://openairdocs.org/ntsb/LAX84LA160.md): Cessna A188B · Santa Nella, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 30, 1984 · N731WR · Substantial damage > During a low level ag turn, the acft's left wing impacted an 8-FT high stand pipe. The acft then cartwheeled & crashed. A few weeks before the accident, the plt had personally inspected the field. However, just days before the accident, the standpipe had been… - [NTSB NYC84FA085](https://openairdocs.org/ntsb/NYC84FA085.md): Piper PA-28R-200 · Templeton, MA · Accident · 4 fatal · Field investigation · Final report · Jan 29, 1984 · N55495 · Destroyed > The acft collided with trees on unlgtd terrain at ngt after making a low pass at aprx 60 ft AGL with the gear extended. Witnesses reported that the acft's clearance lights were not operating until the rwy lights were turned on, then they observed the acft's… - [NTSB DEN84FA073](https://openairdocs.org/ntsb/DEN84FA073.md): Bell 206L-1 · Huntington, UT · Accident · Serious injuries · Field investigation · Final report · Jan 22, 1984 · N500CN · Substantial damage > While in a stabilized, out-of-ground-effect hover, at about 300 feet AGL, the helicopter started an uncontrollable right turn. The plt stated that using full left peddle had no effect on stopping the spin. At the onset of the spin, the occupants of the acft… - [NTSB SEA84LA040](https://openairdocs.org/ntsb/SEA84LA040.md): Beech A35 · Renton, WA · Accident · No injuries · Limited investigation · Final report · Jan 21, 1984 · N560B · Substantial damage > The acft was damaged during a forced landing after the engine quit after takeoff. The plt said he noticed the oil pressure drop to zero a few minutes after takeoff and was turning back to the arpt when the engine quit. He did not lower the landing gear since… - [NTSB LAX84LA150](https://openairdocs.org/ntsb/LAX84LA150.md): Piper PA-38-112 · Mendota, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 1984 · N2492P · Destroyed > The acft collided with a tractor while the plt was making a low pass over some workers in a tomato field. The plt said he was returning the rented acft when he decided to make a final check on the field workers before departing for the day. No evidence of any… - [NTSB MIA84LA060](https://openairdocs.org/ntsb/MIA84LA060.md): Grumman AG-CAT · Homestead, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 1984 · N6736Q · Destroyed > The acft crashed during a forced landing after the engine lost power. Investigation revealed that that # 8 cylinder failed. The original cracking was determined to be from fatigue. - [NTSB MIA84FA058](https://openairdocs.org/ntsb/MIA84FA058.md): Hiller UH-12C · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jan 12, 1984 · N5317V · No damage > A performer fell from a trapeze rigged below the helicopter while it was hovering at about 150 ft AGL. The FAA had not authorized the modification to the acft. The plt was not certified for external load operations. The performer reportedly had not done this… - [NTSB CHI84LA083](https://openairdocs.org/ntsb/CHI84LA083.md): Cessna 150M · Pittsboro, IN · Accident · No injuries · Limited investigation · Final report · Jan 8, 1984 · N6340B · Substantial damage > The acft made a forced landing on a rough, snow covered field after the engine failed. Post accident investigation showed thet the exhaust valve on #1 cylinder punctured the cylinder. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=217 ## 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=216 --- 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.