# NTSB investigations: Approach

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 175 of 420 · 20,992 cases

## Cases, newest first

- [NTSB BFO88LA006](https://openairdocs.org/ntsb/BFO88LA006.md): Cessna U-206 · Front Royal, VA · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1987 · N756KP · 2 aircraft · Minor damage
  > The aircraft was involved in a midair collision with N756KP, a Cessna U206 aircraft, while both aircraft were on the final approach to runway 27 at the uncontrolled Front Royal, VA airport. Excellent VFR weather prevailed with 15 miles visibility reported.…
- [NTSB NYC88LA014](https://openairdocs.org/ntsb/NYC88LA014.md): Schweizer SGS-2-33A · Mansfield, MA · Accident · No injuries · Limited investigation · Final report · Oct 24, 1987 · N5775S · Substantial damage
  > The Schweizer SGS-2-33A was in the traffic pattern with a student pilot and flight instructor. In the right turn from base to final, the nose dropped and control was lost. The flight instructor took control of the aircraft, and regained control, however,…
- [NTSB MIA88LA019](https://openairdocs.org/ntsb/MIA88LA019.md): Cessna 172 · Titusville, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 1987 · N4207F · Substantial damage
  > After a go-around, at aprx 300 ft, the eng lost power. The plt attempted to return to the arpt, but was unable. The acft descended, collided with trees, bounced off the roof of a house & came to rest against a vehicle in the driveway. Inspection of the…
- [NTSB BFO88LA018](https://openairdocs.org/ntsb/BFO88LA018.md): Piper PA-32-300 · Churchton, MD · Accident · No injuries · Limited investigation · Final report · Oct 23, 1987 · N2816M · Substantial damage
  > The plt rprtd that after searching unsuccessfully for a wind sock & getting no reply on UNICOM freq, he made an apch to rwy 16. Later, he saw the wind sock about half way down the rwy near a building. Drg the apch, he noticed he was high & put the acft in a…
- [NTSB LAX88LA021](https://openairdocs.org/ntsb/LAX88LA021.md): Beech 35-A33 · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 22, 1987 · N423T · Substantial damage
  > The pilot and passenger both stated that the engine lost all power during the final approach for landing. The passenger switched the fuel tank selector from the left to the right tank. There was not time to attempt a restart. He then raised the landing gear…
- [NTSB NYC88LA013](https://openairdocs.org/ntsb/NYC88LA013.md): Piper PA-31-310 · Beverly, MA · Accident · No injuries · Limited investigation · Final report · Oct 21, 1987 · N9249Y · Substantial damage
  > The plt rprtd that drg an NDB apch, the acft 'broke out slightly above minimums' & that he maneuvered to land from a close-in, base leg. He stated that drg a left turn to final apch, the left eng began losing power. Rprtdly, there was a lack of response to…
- [NTSB MIA88FA012](https://openairdocs.org/ntsb/MIA88FA012.md): Cessna 210M · Jacksonville, FL · Accident · Serious injuries · Field investigation · Final report · Oct 21, 1987 · N8193M · Destroyed
  > During a part 135 on-demand air taxi cargo flt, the plt reported an eng malfunction when the acft was aprx 15 miles sw of the arpt while on apch to land. The flt continued & the plt then reported that the eng quit & the flt was 5 miles sw of the arpt. A…
- [NTSB NYC88LA011](https://openairdocs.org/ntsb/NYC88LA011.md): Cessna 402B · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Oct 18, 1987 · N6344X · Substantial damage
  > The plt rprtd that drg an apch to rwy 6 at dusk, a sudden sink rate developed. He applied power & brought the acft to a climb attitude; however, he felt a 'thud beneath the aircraft' & noted that the right main gear light no longer indicated down & locked.…
- [NTSB NYC88LA012](https://openairdocs.org/ntsb/NYC88LA012.md): Cessna 172P · Bedford, MA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N97313 · 2 aircraft · Substantial damage
  > A Cessna 172, N97313, and a Beech C23, N6718Z, collided in flt as the plts of both acft were arriving to land on rwy 11 at hanscom field. The Cessna plt had planned to land at beverly, MA, but diverted to hansom field due to wx. The Cessna was in a left turn…
- [NTSB MKC88LA008](https://openairdocs.org/ntsb/MKC88LA008.md): Cessna 172F · Lamoni, IA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N8508U · Substantial damage
  > The pilot said he was too high on final and went around. He stated that, when he was on short final during the next approach, he thought he was still too high and put down full flaps. The airplane stalled and touched down short of the runway. The nosegear was…
- [NTSB ATL88LA016](https://openairdocs.org/ntsb/ATL88LA016.md): Cessna 172N · Brookville, OH · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 1987 · N737WU · Substantial damage
  > While on final approach the acft began to fall below the flight path the plt desired. Remedial actions were insufficient to correct the deviation. The acft impacted short of the rwy and collapsed the landing gear. Investigation revealed the use of 40 degrees…
- [NTSB MKC88FA007](https://openairdocs.org/ntsb/MKC88FA007.md): Champion Aeronca 7GC · Columbia, MO · Accident · 2 fatal · Field investigation · Final report · Oct 14, 1987 · N4889E · Destroyed
  > Witnesses reported the pilot had planned to practice 'taildragger' takeoffs and landings. They reported the aircraft operated routinely from engine start through the final approach segment of a VFR traffic pattern. While stabilized at about 400 ft AGL on…
- [NTSB FTW88FA005](https://openairdocs.org/ntsb/FTW88FA005.md): Cessna 175 · Crystal City, TX · Accident · Serious injuries · Field investigation · Final report · Oct 13, 1987 · N6512E · Destroyed
  > The plt was attempting a night visual apch to his unlighted pvt strip when the acft struck trees, flew under a pwr line,struck additional trees & subsequently impacted the gnd. The acdnt occurred aprx 2.5 miles short of the threshold. Samples of the plt's…
- [NTSB NYC88LA004](https://openairdocs.org/ntsb/NYC88LA004.md): Piper PA-28-161 · Weston, MA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1987 · N8391A · Destroyed
  > Drg a night arrival, when the acft was apchg the boston tca, the plt dscndd to 1000 ft. as he was leveling off, he noted a power loss & was unable to reach the destn arpt. He identified a field & initiated an emerg landing. Drg the apch, the acft struck power…
- [NTSB ATL88LA008](https://openairdocs.org/ntsb/ATL88LA008.md): Piper PA-28R-200 · Sebring, OH · Accident · No injuries · Limited investigation · Final report · Oct 9, 1987 · N2802R · Destroyed
  > While on final appch to land, a fire broke out in the airplane engine compartment. The commercial plt and his instructor evacuated the airplane after ldg and the airplane was destroyed by the fire. The acft was subsequently examined by an IA mechanic who…
- [NTSB SEA88LA002](https://openairdocs.org/ntsb/SEA88LA002.md): Klien Avid Flyer · Edwall, WA · Accident · No injuries · Limited investigation · Final report · Oct 7, 1987 · N819MK · Destroyed
  > While on a VFR final apch for lndg, the plt was watching for pwr lines which had to be cleared & diverted his attention from his airspeed. After clearing the pwr lines, the acft stalled & crashed on a roadway. The acft was not equipped with a stall warning…
- [NTSB MIA88FA003](https://openairdocs.org/ntsb/MIA88FA003.md): Cessna 310K · Inverness, FL · Accident · 4 fatal · Field investigation · Final report · Oct 5, 1987 · N3815X · Destroyed
  > Witnesses stated that the plt initiated a go around at the runway 19 threshold, broke off to the right & went behind a tree line in a 60 degree right bank. On the other side of the tree line the acft was observed to strike the trees with the left wing and…
- [NTSB CHI88FA001](https://openairdocs.org/ntsb/CHI88FA001.md): Beech A35 · Grand Ledge, MI · Accident · No injuries · Field investigation · Final report · Oct 4, 1987 · N8705A · Substantial damage
  > After rtrng fm a x-country flt, the plt was about to turn downwind to land when the eng began to lose power. He moved the fuel selector from the left main to the rgt main psn & pumped the wobble pump svrl times, but the eng did not restart. He then moved the…
- [NTSB BFO88IA001](https://openairdocs.org/ntsb/BFO88IA001.md): Fokker F-28-MK-1000 · Baltimore, MD · Incident · No injuries · Incident investigation · Final report · Oct 3, 1987 · N288N · Minor damage
  > The acft had a main gear only landing after the nose gear failed to lock down. This was the first flight since a newly overhauled nose gear was installed. It was determined that when the nose gear was installed and before it was corrected, a wrong washer was…
- [NTSB LAX87FA350](https://openairdocs.org/ntsb/LAX87FA350.md): Cessna 340A · San Diego, CA · Accident · 6 fatal · Field investigation · Final report · Sep 30, 1987 · XAKOA · Destroyed
  > At aprx 0600, the acft depd guerrero negro, Mexico on an air taxi flt to tijuana, Mexico. At 0715, the tijuana wx was rprtd as partially obscured, vis 1 mi with fog, haze & smoke, wind calm. Drg arrival, the plt was clrd for an ILS rwy 9 apch & rprtd over the…
- [NTSB ANC87LA170](https://openairdocs.org/ntsb/ANC87LA170.md): Piper PA-32-260 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1987 · N3560W · Substantial damage
  > The pilot stated that she departed the airport with only one quarter tank of fuel; on final approach to the runway the engine quit. The owner stated there was less than ten (10) gallons on board the aircraft prior to take off.
- [NTSB DEN87LA243](https://openairdocs.org/ntsb/DEN87LA243.md): Robinson R-22M · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Sep 27, 1987 · N47RW · Substantial damage
  > A CFI and a private plt were ferrying a newly purchased helicopter to their home airport. During a fuel stop, while on a visual approach, the helicopter encountered windshear. The density altitude was 8000 feet, and the helicopter was at or near max gross wt.…
- [NTSB NYC87FA262](https://openairdocs.org/ntsb/NYC87FA262.md): Piper PA-32-300 · Montoursville, PA · Accident · 1 fatal · Field investigation · Final report · Sep 25, 1987 · N38364 · Destroyed
  > The plt initiated the ILS approach and acknowledged a frequency change. The acft was found on a steep hill one mile south of the airport. No evidence of an engine or control system malfunction was found. It appeared that the pilot made a missed approach and…
- [NTSB FTW87LA224](https://openairdocs.org/ntsb/FTW87LA224.md): Cessna 150M · Addison, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 25, 1987 · N63156 · Substantial damage
  > The aircraft became too slow while on final approach, started mushing, and drifted left. Full engine power was applied accompanied by nose up elevator trim. The aircraft bounced then climbed about 30 feet while attaining a steep nose up attitude and stalled.…
- [NTSB NYC87LA261](https://openairdocs.org/ntsb/NYC87LA261.md): Cessna 172P · Fitchburg, MA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 1987 · N99151 · Destroyed
  > Drg arrival, the plt was clrd for an ndb-a apch to Fitchburg muni arpt. The NDB was located on the arpt & the arpt elev was 350'. The min dscnt alt (mda) was 1140' MSL. The apch procedure was to go outbnd fm the NDB on a 137 deg bearing, make a procedure…
- [NTSB DEN87LA242](https://openairdocs.org/ntsb/DEN87LA242.md): Mooney M20K · Aspen, CO · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N6874U · Destroyed
  > While on a cross country pleasure flt the acft engine failed apx four miles short of the dest aprt. A forced landing was made in a field.
- [NTSB CHI87LA216](https://openairdocs.org/ntsb/CHI87LA216.md): Cessna 170B · Washington, IN · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1987 · N473CJ · Substantial damage
  > The pilot was landing the aircraft, after returning from a personal cross-country flight, when he encountered a crosswind gust and 'veered strongly to the right.' The pilot then decided to abort the landing and proceeded to add full power for a go-around.…
- [NTSB CHI87LA215](https://openairdocs.org/ntsb/CHI87LA215.md): Piper PA-22-150 · Belleville, IN · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N7108B · Substantial damage
  > The aircraft was returning to an unlighted private airstrip after a local pleasure flight. The sun had set but, according to the pilot, the sky was still illuminated. The pilot stated he was able to set up an approach, but when established on final he 'lost…
- [NTSB BFO87LA066](https://openairdocs.org/ntsb/BFO87LA066.md): Piper PA-32-260 · Roanoke, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 20, 1987 · N3636W · Substantial damage
  > Roanoke tower cleared the aircraft for landing and the pilot pulled the power to idle. The pilot did not realize the engine had quit until he applied power on short final and the engine did not respond. The aircraft struck short of runway 33. The pilot stated…
- [NTSB MKC87LA173](https://openairdocs.org/ntsb/MKC87LA173.md): Cessna 172M · Festus, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1987 · N13568 · Substantial damage
  > The CFI was giving inst to a pvt plt who was undergoing a biennial flt review. The pvt plt cmpltd the maneuvers and ret to the arpt. The lndg was aborted and a go-around was made. The CFI took control and executed another appch. The pvt plt was to monitor an…
- [NTSB MIA87FA250](https://openairdocs.org/ntsb/MIA87FA250.md): Commonwealth 185 · St. Petersburg, FL · Accident · 3 fatal · Field investigation · Final report · Sep 19, 1987 · N92919 · 2 aircraft · Destroyed
  > The pilot of the Commonwealth erroneously reported his positon to the tower for landing instructions. He then failed to follow the instructions and collided with a Beech 23 acft that was on downwind to land at albert whitted airport. Both aircraft involved in…
- [NTSB LAX87LA338](https://openairdocs.org/ntsb/LAX87LA338.md): Cessna 152 · Napa, CA · Accident · No injuries · Limited investigation · Final report · Sep 17, 1987 · N6576B · Substantial damage
  > The student plt was on her 2nd solo flt. She rprtd that on her 1st landing, the acft bounced on the main gear, then drifted to the left & went off the rwy. She applied full power & raised the flaps in an attempt to go around. Witnesses rprtd the acft attained…
- [NTSB ANC87FA153](https://openairdocs.org/ntsb/ANC87FA153.md): Piper PA-12 · Shaw Creek, AK · Accident · 3 fatal · Field investigation · Final report · Sep 16, 1987 · N3140M · Destroyed
  > The private pilot was transporting passengers incidental to the operation of his lodge. According to witnesses, it was common for pilots to use that portion of the highway for takeoffs and landings. According to the husband of one of the fatally injured…
- [NTSB LAX87FA335](https://openairdocs.org/ntsb/LAX87FA335.md): Mooney M20J · Dublin, CA · Accident · 1 fatal · Field investigation · Final report · Sep 14, 1987 · N3551H · Destroyed
  > The pilot had flown 5.6 hours during the day, starting the first flight about 0600. ATC controllers stated that the pilot did not follow the clearance issued to him. The controllers then issued radar vectors. The instructor the pilot flew with earlier in the…
- [NTSB NYC87FA251](https://openairdocs.org/ntsb/NYC87FA251.md): Cessna 152 · Boxborough, MA · Accident · 2 fatal · Field investigation · Final report · Sep 12, 1987 · N25223 · Destroyed
  > The IFR flight from auburn-lewiston, Maine to the manchester, new hampshire VORTAC facility was without incident. Boston center cleared the flight for the vor/dme instrument approach procedure to runway 21 at the uncontrolled stow/minute man airport, stow,…
- [NTSB MIA87LA244](https://openairdocs.org/ntsb/MIA87LA244.md): Air Tractor AT301 · Belle Glade, FL · Accident · No injuries · Limited investigation · Final report · Sep 11, 1987 · N23600 · Substantial damage
  > The plt stated that he was spraying water to clean out his hopper tank. During approach to land the eng quit. Unable to reach the airstrip the plt landed on a road. On landing rollout on the road he struck a hidden 55 gallon drum with the right wing tip, spun…
- [NTSB MIA87LA243](https://openairdocs.org/ntsb/MIA87LA243.md): Beech V-35B · Apalachicola, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 1987 · N9008Q · Destroyed
  > The plt stated that while on final apch to st. georges arpt he lost power. On an attempt to go around collided with trees, flipped over & came to rest inverted.
- [NTSB FTW87FA213](https://openairdocs.org/ntsb/FTW87FA213.md): Partenavia P68C · New Orleans, LA · Accident · Serious injuries · Field investigation · Final report · Sep 11, 1987 · N1352W · Destroyed
  > The plt began an ILS rwy 18R apch at ngt to the lakefront arpt. He rprtd that after the acft broke out of the clouds at 1700', he transitioned to a visual apch. He stated that as he contd, the apch seemed normal, except the VASI lights seemed too FAR down the…
- [NTSB SEA87FA185](https://openairdocs.org/ntsb/SEA87FA185.md): Cessna TR182 · Tillamook, OR · Accident · 2 fatal · Field investigation · Final report · Sep 10, 1987 · N9484R · Destroyed
  > Drg arrival, the plt was cleared for an ndb-a apch & received approval to change to the local adzy freq. After that, there was no further radio comm with the acft. Radar data showed the acft crossed over the initial apch fix (iaf) & began a rgt outbound turn…
- [NTSB LAX87LA330](https://openairdocs.org/ntsb/LAX87LA330.md): Beech H35 · Avenal, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1987 · N7962D · Substantial damage
  > During a pleasure flight, the pilot noted that the oil pressure was reading low. The pilot decided to make a 180 degree turn to land at a nearby airport. En route the oil pressure continued to drop. During the first landing attempt the pilot stated the…
- [NTSB LAX87FA331](https://openairdocs.org/ntsb/LAX87FA331.md): Beech 95 · Monterey, CA · Accident · 3 fatal · Field investigation · Final report · Sep 9, 1987 · N845B · Destroyed
  > The coml plt was rcvg mult-eng dual instrn in a Beech 95. After tkof, the aircrew began practicing inst apchs. After making an ILS rwy 10 apch to enter left traffic for rwy 28, the flt was clrd onto a south downwind to be sequenced to follow a psa BAE-146.…
- [NTSB SEA87LA182](https://openairdocs.org/ntsb/SEA87LA182.md): Cessna 180H · Salmon, ID · Accident · No injuries · Limited investigation · Final report · Sep 5, 1987 · N2467F · Substantial damage
  > While on approach for landing a total loss of power occurred for undetermined reasons.
- [NTSB CHI87FA212](https://openairdocs.org/ntsb/CHI87FA212.md): Cessna 177 · Genoa, IL · Accident · No injuries · Field investigation · Final report · Sep 3, 1987 · N2295Y · Substantial damage
  > The plt made a straight-in apch to land at dusk on an unlighted sod rwy. He stated he lowered 10 deg of flaps aprx 2 mi fm the rwy. While on final apch, with the power set at aprx 1800 RPM, the acft began to settle. The plt said he applied full power, but it…
- [NTSB ATL87DLT04](https://openairdocs.org/ntsb/ATL87DLT04.md): Nord SV4C · Lebanon, TN · Accident · No injuries · Final report · Sep 3, 1987 · N125V · Substantial damage
  > The pilot stated while on final approach he allowed the aircraft to get too low and slow. He realized it was too late to recover and the aircraft collided with a tree.
- [NTSB MIA87LA238](https://openairdocs.org/ntsb/MIA87LA238.md): Aero Commander 680FL · St Thomas · Accident · No injuries · Limited investigation · Final report · Sep 2, 1987 · N111UA · Substantial damage
  > After a loss of hyd pressure, the rgt main gear would not fully extd when the plt tried to lower the gear for lndg. All atmts to lock it into place were unsuccessful. When the acft touched down drg the lndg, the rgt main gear collapsed. The acft slid to a…
- [NTSB LAX87LA321](https://openairdocs.org/ntsb/LAX87LA321.md): Cessna 152C · Upland, CA · Accident · No injuries · Limited investigation · Final report · Sep 2, 1987 · N757HK · Substantial damage
  > The dual instruction flight completed 2 full stop landings on runway 06 at the cable airport. On the next takeoff the flight encountered a downdraft after turning on the crosswind leg. The instructor pilot took the controls and turned to the downwind leg but…
- [NTSB MIA87FA236](https://openairdocs.org/ntsb/MIA87FA236.md): Cessna 152 · Opa Locka, FL · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1987 · N48864 · 2 aircraft · Substantial damage
  > A student plt & instructor (CFI) in Cessna 152, N48864, took off & entered rgt traffic to practice lndgs on rwy 9R. Soonthereafter, a helicopter plt (h/p) in a bell 47G-2, N6728D, took off & entered rgt traffic to practice lndgs in a desig-nated helicopter…
- [NTSB CHI87FA197](https://openairdocs.org/ntsb/CHI87FA197.md): Aeronca 7AC · Kenosha, WI · Accident · 2 fatal · Field investigation · Final report · Aug 30, 1987 · N3406E · Destroyed
  > The aircraft was on final approach for landing during a dual instructional flight. The aircraft was observed to pitch up, then enter a nose down, right wing low attitude which it maintained until it impacted the ground. Witnesses, including another CFI who…
- [NTSB MKC87DPG03](https://openairdocs.org/ntsb/MKC87DPG03.md): Air Tractor AT-301 · Tillar, AR · Accident · Serious injuries · Final report · Aug 27, 1987 · N3159X · Substantial damage
  > The pilot stated that the prop RPM became erratic. On approach, the prop ran completely out of control, causing the aircraft to nose down into a plowed field just short of the landing area. The a/c hit on the main landing gear, broke them off, then it nosed…
- [NTSB MIA87FA234](https://openairdocs.org/ntsb/MIA87FA234.md): Piper PA-38-112 · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · Aug 26, 1987 · N2316D · Destroyed
  > The student plt was on an aprx 380 mi solo x-country flt fm Vero Beach (vrb) to naples (apf), brooksville (bkv) & back to vrb. He thought he had plenty of fuel for the flt & elected to dep w/o taking a credit card (for fuel). When he lndd at apf & bkv, he did…

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=176

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

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

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