# NTSB investigations: Unknown

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 26 of 40 · 1,978 cases

## Cases, newest first

- [NTSB FTW84FA374](https://openairdocs.org/ntsb/FTW84FA374.md): Miller Air Sports GEM 260 · Martindale, TX · Accident · 1 fatal · Field investigation · Final report · Sep 1, 1984 · N177M · Destroyed
  > Notes left by plt indicate he had been testing the flight envelope of this experimental racing acft, including operation of the engine beyond prop limit of 4000 RPM. Witnesses heard engine sound suddenly speed up to high RPM then cease altogether. Some…
- [NTSB FTW84LA366](https://openairdocs.org/ntsb/FTW84LA366.md): Grumman G-164 · Oak Grove, LA · Accident · No injuries · Limited investigation · Final report · Aug 24, 1984 · N528Y · Substantial damage
  > Aircraft landed with a flat left main tire, veered left and nosed over inverted.
- [NTSB FTW84LA356](https://openairdocs.org/ntsb/FTW84LA356.md): Gulfstream 520 · Goliad, TX · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1984 · N4183B · Destroyed
  > Acft was found abandoned. Wreckage scene indicates collision with trees prior to collision with terrain. Acft suspected of being used for illegal cargo operations.
- [NTSB LAX84FA421](https://openairdocs.org/ntsb/LAX84FA421.md): Fairchild Hiller FH-1100 · Meadview, AZ · Accident · 3 fatal · Field investigation · Final report · Jul 29, 1984 · N711KH · Destroyed
  > Purpose of the flt was s sightseeing tour of lake mead, hoover dam and the western rim of the grand canyon. Before reaching the canyon the flt was to travel over a 5500 ft MSL ridge. The helicopter contacted a juniper tree at the bottom of a 3-sided canyon at…
- [NTSB FTW84LA330](https://openairdocs.org/ntsb/FTW84LA330.md): Bellanca 7ECA · San Marcos, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 1984 · N8685V · Destroyed
  > While the plt was on a x-country flt, the acft crashed & came to rest on the shoreline of a large pond. Initial impact was believed to have occurred with the water. No preimpact part failure or malfunction was found during the investigation. There was…
- [NTSB ANC84LAMS1](https://openairdocs.org/ntsb/ANC84LAMS1.md): Cessna 401 · Anchorage, AK · Accident · 5 fatal · Final report · Jul 25, 1984 · N7984Q · No damage
  > At 0630 AKDT the plt obtained a wx briefing for the flt which forecast VFR with occasional marginal conditions along the route of flt. At 0704, the plt obtained an updated briefing at which time the destination of cantwell was reported IFR. At 0731 AKDT, the…
- [NTSB BFO84FA001](https://openairdocs.org/ntsb/BFO84FA001.md): Piper PA-28-235 · Selbyville, DE · Accident · 2 fatal · Field investigation · Final report · Jul 21, 1984 · N9014W · Destroyed
  > The student pilot and one passenger departed on the flight without a wx briefing despite the existence of low ceilings and rain. Witnesses related hearing the engine accelerate and seeing the acft start a climb before it broke up and impacted the ground.…
- [NTSB NYC84FAMS1](https://openairdocs.org/ntsb/NYC84FAMS1.md): Cessna 172N · Nantucket, MA · Accident · 2 fatal · Missing aircraft · Final report · Jul 19, 1984 · N4950G · Destroyed
  > The acft disappeared after departing on the return leg of a x-country. The plt had called the operator at the home base and reported that IMC weather existed for the return. The plt was informed that the acft was not needed and he did not need to hurry back.…
- [NTSB FTW84FA291](https://openairdocs.org/ntsb/FTW84FA291.md): Cessna 152 · Minco, OK · Accident · 2 fatal · Field investigation · Final report · Jun 29, 1984 · N6473P · Destroyed
  > The student plt had rented the acft. Records showed that he had flown this acft on previous occasions. The plt acting as instructor did not possess a current instructor certificate. There were no witnesses to the crash, but the acft was observed maneuvering…
- [NTSB MIA84FU006](https://openairdocs.org/ntsb/MIA84FU006.md): Storey SKY PUP · Indiantown, FL · Accident · 1 fatal · Final report · Jun 23, 1984 · UNREG · Destroyed
  > The ultralight experienced an in-flight separation of the left wing. The wing separated at the wing attachment fitting. The plt & ultralight had a parachute attached but it did not deploy.
- [NTSB MIA84LA186](https://openairdocs.org/ntsb/MIA84LA186.md): Cessna A188B · Marianna, FL · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N5630G · Substantial damage
  > During a crop dusting operation, there was an apparent loss of power & oil sprayed on the windshield of the acft. The plt stated that when he applied power, there was no response. He made a forced landing on a road, but the right wing of the acft hit a tree.…
- [NTSB MIA84FA188](https://openairdocs.org/ntsb/MIA84FA188.md): Cessna C-188 · Elkton, FL · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1984 · N8233G · Destroyed
  > The aircraft departed the farm grass strip for a spray mission estimated to take about 20 minutes. When the aircraft failed to return the pilots business partner started looking for the aircraft and pilot. The aircraft was found about one and one half mile…
- [NTSB LAX84LA354](https://openairdocs.org/ntsb/LAX84LA354.md): Cessna T210N · Camp Verde, AZ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1984 · N6406Y · Substantial damage
  > The plt reported that during the landing, the acft rolled about 200 to 250 ft after touchdown, then began veering to the left. He attempted to maintain directional control by applying right rudder & brake, but was unusccessful. The left main gear hit a berm,…
- [NTSB LAX84FA328](https://openairdocs.org/ntsb/LAX84FA328.md): Piper PA-31-350 · Baker, CA · Accident · 2 fatal · Field investigation · Final report · Jun 2, 1984 · N6GW · Destroyed
  > The acft was found where it had crashed & burned on a rough lava bed. The crash site was about 1 mi northeast of a road where drug smuggling acft had been known to land in the past. There was evidence that cocaine had been removed from the accident site. The…
- [NTSB LAX84LAMS3](https://openairdocs.org/ntsb/LAX84LAMS3.md): Bellanca 17-31A · CA · Accident · 1 fatal · Final report · Jun 1, 1984 · N6602V · Destroyed
  > Between may 31 & June 1, 1984, the private plt is believed to have driven to the airport, parked his car, & boarded his aircraft for a presumed personal flt. The plt's wife became concerned about her husband's failure to appear at work, & she notified local…
- [NTSB FTW84FA258](https://openairdocs.org/ntsb/FTW84FA258.md): Cessna 152 · Fairview, OK · Accident · 1 fatal · Field investigation · Final report · May 31, 1984 · N49640 · Destroyed
  > The acft had inflt structural failure and separation of some components and crashed in an inverted flat spin parts of the wing and aileron were never found. Some parts were found about 1/2 mile from the primary impact point. An autopsy onthe plt revealed the…
- [NTSB FTW84LA249](https://openairdocs.org/ntsb/FTW84LA249.md): Beech 65 · Zapata, TX · Accident · No injuries · Limited investigation · Final report · May 25, 1984 · N404C · Destroyed
  > According to law enforcement officers, the acft experienced double eng failure and made a forced landing in unimproved terrain. During the landing rollout the acft struck several trees. An intense post crash fire erupted destroying all but one wing tip of the…
- [NTSB SEA84FA113](https://openairdocs.org/ntsb/SEA84FA113.md): Cessna 150F · Gleneden Beach, OR · Accident · 1 fatal · Field investigation · Final report · May 19, 1984 · N6511F · Destroyed
  > Two witnesses observed the student plt in the acft at about 1500 PDT. They reported that they were waiting for the wx to clear & that they tried to get the student to spend the night instead of leaving, but they were unsuccessful. Subsequently, the acft…
- [NTSB FTW84LAMS4](https://openairdocs.org/ntsb/FTW84LAMS4.md): Piper PA-32-260 · Lafayette, LA · Accident · 1 fatal · Final report · May 10, 1984 · N3545W · Destroyed
  > The acft has been missing since 5/10/84. The owner called for his acft preflighted and departed on a southerly heading. An off shore oil rig spotted a twin engine acft heading south. Search efforts by cap were unsuccessful. The plt gave no indication of his…
- [NTSB ATL84FA168](https://openairdocs.org/ntsb/ATL84FA168.md): Cessna 172RG · Dallas, GA · Accident · 2 fatal · Field investigation · Final report · May 6, 1984 · N6293V · Destroyed
  > Approximately one-half hour after takeoff, the aircraft collided with rising terrain and was destroyed. The flight was unauthorized and no witnesses observed the crash. Weather at the time of the crash is unknown. The private pilot on board probably had not…
- [NTSB LAX84FA258](https://openairdocs.org/ntsb/LAX84FA258.md): Bellanca 7AC · Skull Valley, AZ · Accident · 2 fatal · Field investigation · Final report · Apr 16, 1984 · N85034 · Destroyed
  > The acft had been flown on several local flts, earlier that day. The last known flt originated at the ernest j love arpt, prescott, AZ, at 1600 MST. Subsequently, it crashed near the departure end of rwy 02 at the quarter circle 'j' arpt, which was in the…
- [NTSB MIA84LA137](https://openairdocs.org/ntsb/MIA84LA137.md): Grumman American AA-5A · Clearwater, FL · Accident · 1 fatal · Limited investigation · Final report · Apr 14, 1984 · N206JA · Destroyed
  > Shortly after takeoff, the acft crashed into the ocean. VMC existed at the arpt but dense low ocean fog was reported at the crash site. Some acft debris was recovered.
- [NTSB FTW84FA193](https://openairdocs.org/ntsb/FTW84FA193.md): Bellanca 8GCBC · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Apr 9, 1984 · N4167Y · Destroyed
  > Witnesses heard the sound of an acft with the eng at high RPM. Shortly after that, they saw the acft in a left spin with the eng remaining at full power. The acft continued spinning until it crashed & burned. The witnesses noticed that when the plane was…
- [NTSB MKC84FA119](https://openairdocs.org/ntsb/MKC84FA119.md): Piper PA-28R-201T · Memphis, MO · Accident · 2 fatal · Field investigation · Final report · Apr 7, 1984 · N6902C · Destroyed
  > The acft broke apart during a x-country flt. Some thunderstorm activity & turbulence existed along parts of the planned route of flt. However, there was no known adverse wx in the vicinity of the crash site. About 25 mi southwest at kirksville, MD, the 0745…
- [NTSB FTW84FA190](https://openairdocs.org/ntsb/FTW84FA190.md): Beech 65 · Jennings, LA · Accident · 1 fatal · Field investigation · Final report · Apr 5, 1984 · N6RG · Destroyed
  > A popping or backfiring sound was heard by several people who later observed the acft flying at low altitude on what appeared to be a final approach to rwy 13 at Jennings arpt (located about 75 mi sw of the departure point.) No radios were onboard the acft so…
- [NTSB MIA84LA128](https://openairdocs.org/ntsb/MIA84LA128.md): Cessna 172 · Marathon, FL · Accident · 4 fatal · Limited investigation · Final report · Apr 2, 1984 · N64110 · Destroyed
  > The acft was missing after departing on a flt from maraton, FL to everglades city, FL. Sar personnel found the bodies of the plt & 3 pax, but the acft was not found. It was presumed to have been destroyed during a crash in the gulf of Mexico.
- [NTSB MIA84FA126](https://openairdocs.org/ntsb/MIA84FA126.md): Cessna 402B · Missing Acft, MS · Accident · 6 fatal · Field investigation · Final report · Mar 31, 1984 · N44NC · Destroyed
  > This Acft disappeared on a flt from ft lauderdale, FL to bimini, Bahamas. After departure, the Acft flt plan was activated by radio. This was the last communication with the Acft. An itap radar readout revealed an Acft flt that departed at the appropriate…
- [NTSB MIA84LA114](https://openairdocs.org/ntsb/MIA84LA114.md): Piper PA-28-235 · Sanibel Island, FL · Accident · 4 fatal · Limited investigation · Final report · Mar 12, 1984 · N39677 · Destroyed
  > The acft failed to arrive at its destination. A satellite photo of the area showed wx & cloud cover between the departure & destination arpts. Radar data showed that an acft had left key west, FL, at about 1700, went northbound at 4500 until it encounter bad…
- [NTSB ANC84FA042](https://openairdocs.org/ntsb/ANC84FA042.md): Piper PA-18-150 · Galena, AK · Accident · 2 fatal · Field investigation · Final report · Mar 12, 1984 · N5976D · Destroyed
  > The plt took off on a reported low level hunting trip. During the flt, the acft crashed on snow covered terrain near a group of trees. It came to rest in a near vertical, nose down attitude with crushing damage on the nose & leading edges of the wings. There…
- [NTSB NYC84FA107](https://openairdocs.org/ntsb/NYC84FA107.md): American AA-1 · Scriba, NY · Accident · 1 fatal · Field investigation · Final report · Mar 8, 1984 · N5649L · Destroyed
  > Acft was located, after a 4 day search, in a gravel pit 8 miles from point of departure. Wreckage examination revealed acft collided with terrain in vertical descent with nil forward speed. Investigation of power plant revealed no evidence of torque or power…
- [NTSB MIA84FA091](https://openairdocs.org/ntsb/MIA84FA091.md): Cessna 185F · Key West, FL · Accident · Serious injuries · Field investigation · Final report · Feb 22, 1984 · N4460R · Destroyed
  > The acft landed after a previous flt & was refueled & preflight for another mission. According to maintenance personnel, the acft floats were drained once every morning before the 1st flt of the day in accordance with the manufacturer's recommendations. The…
- [NTSB MIA84LA089](https://openairdocs.org/ntsb/MIA84LA089.md): Cessna P-210N · Key West, FL · Accident · 2 fatal · Limited investigation · Final report · Feb 21, 1984 · N731NJ · Destroyed
  > During his wx briefing the plt was given the flight precautions & enroute forecast along his proposed route of flt. Enroute at 14,000 ft the plt advised ARTCC that the flt had encountered rime ice. The controller cleared the flt to descend to 12,000 ft & the…
- [NTSB FTW84IA135](https://openairdocs.org/ntsb/FTW84IA135.md): Nihon YS-11 · Tulsa, OK · Incident · No injuries · Incident investigation · Final report · Feb 15, 1984 · N903TC · No damage
  > The acft experienced a nose wheel steering malfunction & ran off the rwy during landing. The nose wheel system was removed from the acft & submitted for inspection & overhaul. Examination revealed that the lever shaft 'ears' had separated from fatigue.
- [NTSB DEN84FA086](https://openairdocs.org/ntsb/DEN84FA086.md): Cessna T210M · Sidney, MT · Accident · 1 fatal · Field investigation · Final report · Feb 7, 1984 · N7399M · Destroyed
  > Richland flt #101, a bank check courier flt, departed VFR with 180 lbs of cargo. Six minutes prior to the crash, the last radio transmission from the acft was heard concerning a routine landing wx advisory. The acft crashed aprx 45 degs nose low, gear & flaps…
- [NTSB FTW84FA122](https://openairdocs.org/ntsb/FTW84FA122.md): Beech 77 · Fritch, TX · Accident · 2 fatal · Field investigation · Final report · Jan 27, 1984 · N3829D · Destroyed
  > The acft departed on 1/27/84 and failed to return from a 2 hour local flt. Time of departure was 1330 CST. On 1/28/84, afisherman on lake meredith found an acft wheel floating in the water. This wheel was later found to have the same part numbers and paint as…
- [NTSB LAX84FA151](https://openairdocs.org/ntsb/LAX84FA151.md): Wells/Rand KR-2 · Santa Paula, CA · Accident · 2 fatal · Field investigation · Final report · Jan 21, 1984 · N42CW · Destroyed
  > While flying in an easterly direction, the acft collided with a 1/2 inch power line/ground cable, aprx 300 ft above the terrain. The impact occurred at mid-span. After colliding with the cable, the acft crashed & came to rest in an orchard. The sun was at an…
- [NTSB CHI84LA090](https://openairdocs.org/ntsb/CHI84LA090.md): Cessna 210D · Rockford, IL · Accident · No injuries · Limited investigation · Final report · Jan 19, 1984 · N502RF · Substantial damage
  > The plt was on a maintenance test flt to check the landing gear hydraulic power pac. He was unable to lower the main landing gear and landed with the nosewheel down. Examination of the hydraulic pac after the accident revealed that the hydraulic system had…
- [NTSB FTW84FA114](https://openairdocs.org/ntsb/FTW84FA114.md): Bellanca 7ECA · Throckmorton, TX · Accident · 2 fatal · Field investigation · Final report · Jan 11, 1984 · N8646 · Destroyed
  > The acft crashed in a steep left wing down, nose down attitude. The flt had been for the purpose of checking out the front seat plt on pipe line patrol. The front seat plt had only 22 hrs in this make & model. The weather was VMC and no mechanical…
- [NTSB LAX84LA217](https://openairdocs.org/ntsb/LAX84LA217.md): Cessna 182Q · Hana, HI · Accident · 3 fatal · Limited investigation · Final report · Jan 1, 1984 · N95811 · Destroyed
  > The acft disappeared from radar about 8 mi north of Hana, HI, while on an over-water flt. When it did not return from the flt, a search was intiated, but the acft was not found. Only the nose wheel strut (which washed ashore) and a life vest (found by…
- [NTSB LAX84FU024](https://openairdocs.org/ntsb/LAX84FU024.md): Eipper MX · Ramona, CA · Accident · 1 fatal · Final report · Dec 28, 1983 · UNREG · Destroyed
  > The plt was flying the ultralight vehicle to check it out before allowing his student to solo. Aprx 15 min after the plt took off, he was flying over the arpt at about 400 ft AGL when witnesses heard a 'loud non-metallic' sound from the vehicle. At about that…
- [NTSB FTW84FA086](https://openairdocs.org/ntsb/FTW84FA086.md): Beech D18S · Brownsville, TX · Accident · 1 fatal · Field investigation · Final report · Dec 6, 1983 · N44609 · Destroyed
  > The plt had just taken off at night on a flt to Mexico when he declared an intent to return & land with some unspecified emergency. While he was using his radio, the sound of both engs, running at hi power, was audible. When asked if he required assistance,…
- [NTSB CHI84FAMS1](https://openairdocs.org/ntsb/CHI84FAMS1.md): Mooney M20C · Near Green Bay, WI · Accident · 1 fatal · Missing aircraft · Final report · Nov 22, 1983 · N9232M · Destroyed
  > After a taking off at 2029 CST, the plt climbed to 7000 ft & flew on a southerly heading toward the oshkosh VOR. At 2030, the plt indicated that he had a radio problem, but he remained in radio contact with ATC until a freq change at 2039, then no further…
- [NTSB MIA84LA035](https://openairdocs.org/ntsb/MIA84LA035.md): Cessna 340A · Nr. Orangeville, FL · Accident · 1 fatal · Limited investigation · Final report · Nov 20, 1983 · N85JK · Destroyed
  > The acft disappeared fm radar coverage while in cruise flt at 10,000 feet MSL near Orangeville, FL. The ATC transcript revealed that the plt had been inquiring abt the weather ahead of him and was cleared to descend to 6000 in order to get below strong…
- [NTSB FTW84FA057](https://openairdocs.org/ntsb/FTW84FA057.md): Cessna 210N · Childress, TX · Accident · 1 fatal · Field investigation · Final report · Nov 16, 1983 · N6616N · Substantial damage
  > The plt contacte fss requesting info as to fuel service. He was advised that the rwy lights at Childress arpt was out of service. About 34 min later the plt stated his eng had quit & he would try to make the arpt. The acft subsequently struck power lines…
- [NTSB DEN84FA231](https://openairdocs.org/ntsb/DEN84FA231.md): Cessna 182P · Climax, CO · Accident · 4 fatal · Field investigation · Final report · Nov 14, 1983 · N7292S · Destroyed
  > The wreckage of N7292S was located by the Colorado civil air patrol on July 22, 1984. An on-scene examination of the wreckage revealed that the acft had impacted tall pine trees in a near vertical right hand spiral maneuver. Impact forces destroyed the acft…
- [NTSB CHI84FA042](https://openairdocs.org/ntsb/CHI84FA042.md): Piper PA-22-150 · Easton Township, MI · Accident · 3 fatal · Field investigation · Final report · Nov 12, 1983 · N6903D · Destroyed
  > The acft crashed aprx 3 mi from the departure arpt. According to witnesses, it was flying at aprx 200 ft AGL when the right wing dipped & then the acft went nearly straight into the ground. An inspection of the airframe & flt control sys revealed no evidence…
- [NTSB CHI84LA038](https://openairdocs.org/ntsb/CHI84LA038.md): Beech A36 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Nov 5, 1983 · N6739U · Substantial damage
  > On the return flt to Columbus, OH, the alternator warning light was on. After recycling the switch, the plt shut down all electrical equipment. During arrival at the destination, the plt put the gear handle down, but noted a dim unsafe gear light & a…
- [NTSB ATL84LA035](https://openairdocs.org/ntsb/ATL84LA035.md): Piper PA-23-250 · Greer, SC · Accident · No injuries · Limited investigation · Final report · Nov 1, 1983 · N40249 · Substantial damage
  > During the flt, hydraulic failure of the landing sys occurred & the aircrew were unable to get the gear locked in the down position. After orbiting for over an hour, a landing was made. During touchdown, the gear collapsed. An exam revealed that an aileron…
- [NTSB ANC84FA013](https://openairdocs.org/ntsb/ANC84FA013.md): Cessna 206 · Kenai, AK · Accident · 4 fatal · Field investigation · Final report · Oct 31, 1983 · N9975 · Destroyed
  > The acft departed nondalton, AK at aprx 1135 yst on a flt to Kenai, AK. At aprx 1215 yst, the plt report that he was over west forelands & requested the Kenai wx. About 4 min later, he requested a df steer to the Kenai arpt. A short time later, radio contact…
- [NTSB NYC84LA008](https://openairdocs.org/ntsb/NYC84LA008.md): Cessna 172L · Wilkes-Barre, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1983 · N7759G · Substantial damage
  > During flt, the eng lost power from fuel exhaustion & the plt tried to land on a highway. According to witnesses, when he tried to maneuver into the northbound land, while traveling south, the right main gear hit the side of a bank. The wing fuel tanks were…

Next page: https://openairdocs.org/ntsb-phases/990/cases.md?page=27

## 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 = 990)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/990/cases?page=26

---
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.