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

## Cases, newest first

- [NTSB ATL89FA035](https://openairdocs.org/ntsb/ATL89FA035.md): Hughes 269C · Mohawk, TN · Accident · 2 fatal · Field investigation · Final report · Nov 14, 1988 · N9575F · Destroyed
  > The helicopter had landed at a private airstrip and the instructor deplaned. The dual student remained in the helicopter with the engine running. The CFI reboarded and the student made the takeoff. Later, on downwind in traffic pattern, a witness reported a…
- [NTSB NYC89LA027](https://openairdocs.org/ntsb/NYC89LA027.md): Beech A36 · Montauk, NY · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 1988 · N722BH · Substantial damage
  > Loss of control, inflight, while landing, due to low level wind shear.
- [NTSB ATL89LA033](https://openairdocs.org/ntsb/ATL89LA033.md): Cessna 172 · Lumberton, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 13, 1988 · N993NA · Substantial damage
  > The pilot had been flying about 45 minutes when he crashed short of the runway. He believed he departed with 16 gallons of fuel, based on fuel gauge readings. The wreckage examination failed to disclose any system problems. After the accident, only a small…
- [NTSB SEA89LA018](https://openairdocs.org/ntsb/SEA89LA018.md): Robinson R-22 · Port Gamble, WA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1988 · N2460P · Substantial damage
  > Foreign national pilot was obtaining helicopter instruction. On solo flt to practice lndgs in unimproved terrain, touched down on stump with one skid and rolled over. Plt cited temporary pwr loss during approach. Investigation found no engine malfunction.
- [NTSB MIA89LA026](https://openairdocs.org/ntsb/MIA89LA026.md): Piper PA-44-180 · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 1988 · N81609 · Substantial damage
  > As the student plt was making a simulated single eng apch, the instructor's attention was momentarily diverted inside the cockpit. When the instructor looked outside again, the acft was low & slow on a short final apch. The CFI applied power to arrest the…
- [NTSB FTW89LA020](https://openairdocs.org/ntsb/FTW89LA020.md): Stinson 108-1 · Powderly, TX · Accident · No injuries · Limited investigation · Final report · Nov 11, 1988 · N8394K · Substantial damage
  > The pilot was receiving his biennial flight review and was on approach to the airport when he heard a loud snap and lost elevator control. He was able to put the airplane down on the runway, but could not get the tail down. When he applied the brakes, the…
- [NTSB BFO89LA007](https://openairdocs.org/ntsb/BFO89LA007.md): Cessna 152 · Leesburg, VA · Accident · No injuries · Limited investigation · Final report · Nov 8, 1988 · N93031 · Substantial damage
  > The student & instructor (CFI) made a normal apch at 60 KIAS with 30 degs of flaps. When aprx 100 to 200 ft AGL, the acft began to descend below the desired glidepath. The student added power and increased pitch attitude. The acft continued to descend and the…
- [NTSB ATL89LA027](https://openairdocs.org/ntsb/ATL89LA027.md): Cessna 182H · Greensboro, NC · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 1988 · N2358X · Substantial damage
  > PIC was attempting to land at unfamiliar airport with narrow rwy, 25 feet wide, bounded by trees. He did not determine wind other than its general direction. Crosswind was four knots. On short final, after crossing over trees that were approach obstacles,…
- [NTSB LAX89LA038](https://openairdocs.org/ntsb/LAX89LA038.md): Schleicher ASK-21 · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Nov 6, 1988 · N129KS · Substantial damage
  > During final approach, the glider collided with a fence. A witness stated that, 'the pilot simply let the glider get too low and too slow and hit a fence.' There were no mechanical problems reported prior to the accident. The pilot did not file an acdt report.
- [NTSB FTW89IA016](https://openairdocs.org/ntsb/FTW89IA016.md): Boeing 727 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Nov 6, 1988 · N386PA · No damage
  > Poor planning/decision by the unidentified Cessna pilot by maneuvering in busy airspace near the arsa with no ATC coordination or transponder signal; no traffic advisory being issued by the approach controller; and inadequate visual lookout by the flight crew…
- [NTSB FTW89LA014](https://openairdocs.org/ntsb/FTW89LA014.md): Cessna 152 · Winnsboro, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 1988 · N69008 · Substantial damage
  > The student plt checked the wx for his solo x/c and was advised of strong winds and moderate turbulence. The supervising flight instructor was aware of the wx report and allowed the student to depart, although all later x/c flights were cancelled due to the…
- [NTSB ATL89FA025](https://openairdocs.org/ntsb/ATL89FA025.md): Piper PA-38-112 · Mc Donough, GA · Accident · Serious injuries · Field investigation · Final report · Nov 5, 1988 · N2407L · Substantial damage
  > Shortly after takeoff the flight experienced a complete engine failure. The pilot attempted a forced landing to an open field but crashed short. The investigation disclosed that the pilot was not certificated as an airman and he did not have the permission of…
- [NTSB MKC89LA019](https://openairdocs.org/ntsb/MKC89LA019.md): Cessna 172 · Linn, MO · Accident · No injuries · Limited investigation · Final report · Nov 3, 1988 · N6287E · Substantial damage
  > While attempting to land crosswind on a 900 foot long dirt runway, the pilot decided he was too high and had excessive airspeed. He attempted to make a go around. However, he was unable to clear a dirt embankment and struck the nose wheel. Unaware of the…
- [NTSB FTW89FA012](https://openairdocs.org/ntsb/FTW89FA012.md): Piper 601B · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Nov 2, 1988 · N60819 · Destroyed
  > Pilot's decision to fly the approach visually with outside reference to the lights and inadvertently descending below the decision height off the proper glide path.
- [NTSB ATL89MA023](https://openairdocs.org/ntsb/ATL89MA023.md): Cessna 210D · Nashville, TN · Accident · 1 fatal · Major investigation · Final report · Nov 2, 1988 · N3822Y · Destroyed
  > Drg west arr at ngt, plt was vctrd for a VFR, straight-in apch to rwy 2R & adzd of Boeing 727 off his rgt front, passingfm rgt to left. He was cautioned abt wake turbc (w/t) & replied, 'okay I see him.' Ctlr then told plt to turn inbnd & maint 'visual' with…
- [NTSB FTW89IA011](https://openairdocs.org/ntsb/FTW89IA011.md): Bell 206 L-1 · Brownsville, TX · Incident · No injuries · Incident investigation · Final report · Oct 30, 1988 · N2092U · Minor damage
  > Uncontained engine failure due to the thermal fatigue of the first stage trubine wheel.
- [NTSB BFO89FA004](https://openairdocs.org/ntsb/BFO89FA004.md): Piper PA-34-200 · Ocean City, MD · Accident · 3 fatal · Field investigation · Final report · Oct 29, 1988 · N666RW · Destroyed
  > The pilot failed to maintain adequate clearance above the terrain. Contributing factors are inattention to altitude and dark night conditions over illusionary producing featureless water.
- [NTSB ATL89FA019](https://openairdocs.org/ntsb/ATL89FA019.md): Aeronca 7AC · Austell, GA · Accident · Serious injuries · Field investigation · Final report · Oct 29, 1988 · N83045 · Substantial damage
  > PIC was obtaining bfr; stalls & flt at min control airspeed were completed. PIC began descent from 2500 MSL to his pvt strip for simulated engine out landing. In a subsequent interview PIC said carb heat was applied & removed after 30 sec. In his rpt he said…
- [NTSB LAX89FA025](https://openairdocs.org/ntsb/LAX89FA025.md): Piper PA31P-350 · Redlands, CA · Accident · 2 fatal · Field investigation · Final report · Oct 27, 1988 · N79HW · Destroyed
  > The pilot's inadvertent selection of an inappropriate altitude for the attempted night special VFR circle to land maneuver. Contributing to the accident was the dark night, restricted visibilities and lack of ground reference lights. Also contributing to the…
- [NTSB CHI89LA016](https://openairdocs.org/ntsb/CHI89LA016.md): Beech F35 · Milwaukee, WI · Accident · No injuries · Limited investigation · Final report · Oct 23, 1988 · N104TG · Substantial damage
  > While executing a VOR approach and circling to land, the aircraft collided with trees and a fence, then impacted on a roadway short of the runway. The pilot had obtained a full weather briefing prior to his departure. The weather briefing included SIGMET golf…
- [NTSB ATL89LA016](https://openairdocs.org/ntsb/ATL89LA016.md): Schempp-Hirth DISCUS-B · Whitwell, TN · Accident · No injuries · Limited investigation · Final report · Oct 22, 1988 · N321SB · Substantial damage
  > The plt rprtd that thermal lift deteriorated drg the return leg of a x-country flt & he elected to make an off aprt lndg in a hay field. As he was on final apch on a westerly hdg, he saw a previously undetected power line across the field, which reqd a rapid…
- [NTSB NYC89LA016](https://openairdocs.org/ntsb/NYC89LA016.md): Piper PA-32-300 · Easton, PA · Accident · No injuries · Limited investigation · Final report · Oct 21, 1988 · N56813 · Substantial damage
  > Landing short of the runway due to a power loss of unknown reason(s).
- [NTSB MKC89LA010](https://openairdocs.org/ntsb/MKC89LA010.md): Piper PA-32-300 · Andover, KS · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 1988 · N8641N · Substantial damage
  > While turning base to final for landing on a private grass strip, after a personal cross country flight, the aircraft stalled and fell uncontrolled to the terrain. A post accident investigation failed to reveal any malfunction of the control systems or…
- [NTSB MKC89FA007](https://openairdocs.org/ntsb/MKC89FA007.md): Cessna T210F · Rogers, AR · Accident · 2 fatal · Field investigation · Final report · Oct 21, 1988 · N6191R · Destroyed
  > Continued flight by the pilot into instrument meteorological conditions (IMC) and his failure to maintain aircraft control after becoming disoriented. Contributing factors were: dark night, low ceilings, fog, drizzle, obscuration, and failure of the pilot to…
- [NTSB BFO89FA003](https://openairdocs.org/ntsb/BFO89FA003.md): Piper PA-28RT-201 · Frederick, MD · Accident · 1 fatal · Field investigation · Final report · Oct 21, 1988 · N8291Z · Destroyed
  > Nonsubmitted
- [NTSB NYC89FA015](https://openairdocs.org/ntsb/NYC89FA015.md): Beech A24R · Blue Bell, PA · Accident · 4 fatal · Field investigation · Final report · Oct 20, 1988 · N1RJ · Destroyed
  > Improper VFR procedures, the pilot failed to maintian adequate airspeed for the attitude of flight of the airplane causing it to stall and collide with trees and a powerline during recovery.
- [NTSB LAX89FA021](https://openairdocs.org/ntsb/LAX89FA021.md): Cessna TR-182 · Paso Robles, CA · Accident · 1 fatal · Field investigation · Final report · Oct 19, 1988 · N739YS · Destroyed
  > The pilot failed to maintain the proper altitude while executing the published instrument approach procedure.
- [NTSB CHI89LA013](https://openairdocs.org/ntsb/CHI89LA013.md): Piper PA-31-350 · Big Rapids, MI · Accident · No injuries · Limited investigation · Final report · Oct 19, 1988 · N300HF · Substantial damage
  > The pilot stated that he failed to maintain sufficient airspeed and altitude during an IFR circle-to-land maneuver. The pilot reported that when he thought he was going to overshoot final, he tightened up the bank. The aircraft stalled and the left wing…
- [NTSB NYC89LA014](https://openairdocs.org/ntsb/NYC89LA014.md): Let L13 · Warren, VT · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 1988 · CFYSR · Substantial damage
  > Pilot's improper supervision of flight, permitted the student to not maintain the proper airspeed and stall the glider and crash into the ground.
- [NTSB NYC89LA012](https://openairdocs.org/ntsb/NYC89LA012.md): Cessna P210 · Collegeville, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 1988 · N400JL · Destroyed
  > The plt rprtd that as he was arriving to land, he entered left traffic & moved the fuel selector to the fullest tank. Shortly after moving the fuel selector, the eng lost power as though it was fuel starved. He said he operated the fuel boost pump & switched…
- [NTSB LAX89LA019](https://openairdocs.org/ntsb/LAX89LA019.md): Taylorcraft BC12-D · Tehachapi, CA · Accident · No injuries · Limited investigation · Final report · Oct 15, 1988 · N44022 · Substantial damage
  > During the landing touchdown, on runway 11, a gust of wind was encountered and the airplane became airborne. The pilot attempted to go around. During the go around attempt the pilot was not able to gain control of the airplane. Winds at the time of the…
- [NTSB FTW89LA005](https://openairdocs.org/ntsb/FTW89LA005.md): Cessna 150 · Friendswood, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1988 · N7054F · Substantial damage
  > The student pilot descended from 1450 feet to 1000 feet and entered the traffic pattern. Just before turning base, he applied carburetor heat and ten seconds later the engine lost power and quit. Unsuitable terrain made the forced landing a hard landing. An…
- [NTSB LAX89FA013](https://openairdocs.org/ntsb/LAX89FA013.md): Piper PA-32-300 · Santa Maria, CA · Accident · 3 fatal · Field investigation · Final report · Oct 12, 1988 · N6198H · Destroyed
  > The pilot failed to follow the correct I.f.r. procedures whereas he descended below the final approach fix altitude.
- [NTSB NYC89LA009](https://openairdocs.org/ntsb/NYC89LA009.md): Cessna U206G · Rutland, VT · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 1988 · N9431R · Destroyed
  > The accident sequence was observed by two pilots who were awaiting takeoff at the approach end of the rwy in use. One of the pilots reported that the plt of the acdt acft advised him that the acdt acft had encountered ice during the flight. The acdt acft was…
- [NTSB MKC89FA004](https://openairdocs.org/ntsb/MKC89FA004.md): Hughes 500C · Branson, MO · Accident · Serious injuries · Field investigation · Final report · Oct 8, 1988 · N506WW · Substantial damage
  > The flight was conducted for sightseeing with 5 passengers onboard. The pilot turned on final approach with 35 knots of airspeed and encountered a high rate of descent. The pilot reported that he noted a split tach and initiated an autorotation, but was…
- [NTSB CHI89DET01](https://openairdocs.org/ntsb/CHI89DET01.md): Volksplane VP-1 · Coldwater, MI · Accident · 1 fatal · Final report · Oct 8, 1988 · N131JT · Substantial damage
  > A stall with entry into the incipient stage of a spin with insufficient altitude for recovery.
- [NTSB LAX89FA010](https://openairdocs.org/ntsb/LAX89FA010.md): Cessna 182R · Salinas, CA · Accident · 1 fatal · Field investigation · Final report · Oct 7, 1988 · N1787R · Destroyed
  > The pilot failed to follow published missed approach procedures. Factors contributing to the accident were the pilot lack of recent experience in type of operation, instrument go-around procedures, and the cloud covered mountainous terrain.
- [NTSB BFO89LA001](https://openairdocs.org/ntsb/BFO89LA001.md): Cessna 172 · Sandston, VA · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 1988 · N739PE · Substantial damage
  > The plt said he was on final apch about 600 to 800 ft AGL when power loss occurred. He forced landed on an open field about 1/2 mi short of the rwy. The eng exam revealed that two teeth of the idler gear had separated. This resulted in a loss of continuity…
- [NTSB ATL89FA005](https://openairdocs.org/ntsb/ATL89FA005.md): Cessna 120 · Monroe, GA · Accident · Serious injuries · Field investigation · Final report · Oct 5, 1988 · N77458 · Destroyed
  > The pilot was returning to land when he experienced a complete engine failure. The pilot reported completing a before landing check and rechecked the carburetor heat following the initial power loss. The sequence of events were typical of carburetor ice…
- [NTSB SEA89LA007](https://openairdocs.org/ntsb/SEA89LA007.md): Aerospatiale SA341G · Fields, OR · Accident · No injuries · Limited investigation · Final report · Oct 4, 1988 · N401S · Substantial damage
  > The plt rprtd that as he was in a slow descending turn to the left at about 20 KTS (translational lift). The helicopter suddenly rotated to the left without warning. He estimated that this occurred at about 30 ft AGL. He applied right pedal & the rotation…
- [NTSB LAX89FA001](https://openairdocs.org/ntsb/LAX89FA001.md): Beech B23 · Scottsdale, AZ · Accident · 1 fatal · Field investigation · Final report · Oct 3, 1988 · N7621R · Destroyed
  > The pilot's mismanagement of fuel. Contributing to the accident was the inadequate lighting of the fuel selector valve.
- [NTSB LAX89LA004](https://openairdocs.org/ntsb/LAX89LA004.md): Cessna 172M · Auberry, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 1988 · N20680 · Destroyed
  > The pilot was unfamiliar with the area that he was attempting to land in and circled to familiarize himself with the terrain. He then made a low pass over the dirt runway and circled to land. The first attempt was discontinued because the pilot felt that he…
- [NTSB LAX89LA003](https://openairdocs.org/ntsb/LAX89LA003.md): Cessna 150F · Payson, AZ · Accident · No injuries · Limited investigation · Final report · Oct 2, 1988 · N8681S · Destroyed
  > The aircraft collided with an obstacle during a go-around from the red creek private dirt strip. The plt reported that he had never landed at the 2000 ft, dirt strip and had no other short or soft field takeoff/landing practice beyond his instruction at an…
- [NTSB CHI89LA001](https://openairdocs.org/ntsb/CHI89LA001.md): Cessna 310Q · Tell City, IN · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 1988 · N8157Q · Destroyed
  > The pilot flew a VOR approach to the airport, but was too high to land on the approach runway. He executed a circling VFR pattern to land on the reciprocal runway, then flew into the ground fog in the descending base turn. The left wing struck a tree while in…
- [NTSB ANC89LA001](https://openairdocs.org/ntsb/ANC89LA001.md): Cessna 180 · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Oct 2, 1988 · N420SB · Substantial damage
  > Drg arrival to land on a lake at night, the plt began a 180 deg turn from a NE heading at aprx 500' AGL to a final apch on a sw heading. As the acft was in the turn, it began losing altitude rapidly. The plt applied power to stop the descent, but the acft…
- [NTSB NYC89LA001](https://openairdocs.org/ntsb/NYC89LA001.md): Piper PA-22-150 · Mayville, NY · Accident · No injuries · Limited investigation · Final report · Oct 1, 1988 · N3112Z · Substantial damage
  > While on short final for landing, the flt encountered turbulence and began settling over trees located near the end of the runway. In the attempt to go around the plt allowed the acft to decelerate. The acft drifted 30 degrees right of the runway and crashed…
- [NTSB MKC88FA183](https://openairdocs.org/ntsb/MKC88FA183.md): Beech D55 · N. Little Rock, AR · Accident · 3 fatal · Field investigation · Final report · Oct 1, 1988 · N7826R · Destroyed
  > The pilot had been executing a vor/dme rwy 35 instrument approach to north Little Rock muni (1M1). The PIC called 'missed approach' a short time aft having been clrd to execute the instrument apprch. Apprch control attmptd to provide instructions to the PIC…
- [NTSB NYC88LA251](https://openairdocs.org/ntsb/NYC88LA251.md): Cessna 210 · Kirkwood, NY · Accident · No injuries · Limited investigation · Final report · Sep 30, 1988 · N7457E · Substantial damage
  > The plt attempted to land at a private airport at night on an unlit rwy. A go-around was initiated and during the go-around the eng lost pwr. A gear up landing was made beyond the rwy. The investigation revealed water in the fuel system. The eng was run up…
- [NTSB LAX88FA330](https://openairdocs.org/ntsb/LAX88FA330.md): Bell 206L-1 · Santa Barbara, CA · Accident · No injuries · Field investigation · Final report · Sep 29, 1988 · N2246Q · Substantial damage
  > Failure of the #1 turbine wheel. Contributing to this accident was the unreported over temperature cycles of the engine. Also contributing was the unsuitability of the landing surface from the presence of the 1/4 inch steel sheeting.
- [NTSB FTW88LA166](https://openairdocs.org/ntsb/FTW88LA166.md): Piper PA-28-140 · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Sep 29, 1988 · N4683R · Substantial damage
  > The pvt plt (PIC) was flying with an instructor (CFI), who had an expired medical certificate. The CFI stated he was flying as a safety plt only. The PIC extended his downwind leg & subsequently was low & slow on a long final apch. He raised the nose of the…

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

## 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=168

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