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

## Cases, newest first

- [NTSB MIA88LA113](https://openairdocs.org/ntsb/MIA88LA113.md): Piper PA-30 · Jupiter, FL · Accident · No injuries · Limited investigation · Final report · Feb 25, 1988 · N7377Y · Substantial damage
  > The plt stated that he had completed a ldg away from his home base without the gear down & locked lights being illuminated. He stated that he had assumed the lights were 'burned out'. Upon departure, he retracted the gear & flew to his home airport. Upon…
- [NTSB FTW88DPJ03](https://openairdocs.org/ntsb/FTW88DPJ03.md): Cessna 172M · Norman, OK · Accident · Serious injuries · Final report · Feb 24, 1988 · N20129 · Destroyed
  > Pilot retracted flaps during go around and aircraft settled into trees and was destroyed. Front seat occupants were not wearing the available shoulder harnesses. The acft was landing with a quartering tailwind. Due to serious head injuries the plt never…
- [NTSB CHI88LA068](https://openairdocs.org/ntsb/CHI88LA068.md): Cessna T210N · Kankakee, IL · Accident · Minor injuries · Limited investigation · Final report · Feb 24, 1988 · N4917K · Substantial damage
- [NTSB NYC88LA088](https://openairdocs.org/ntsb/NYC88LA088.md): Mooney M20 · Morristown, NJ · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 1988 · N5782E · Substantial damage
  > The Mooney crashed while on a ILS approach at night. The plt had been unable to get into two other airports due to weather and air traffic. The aircraft impacted in swampy area. The pilot had told ATC that he felt uneasy about his engine; however, he did not…
- [NTSB NYC88FA093](https://openairdocs.org/ntsb/NYC88FA093.md): Piper PA-34-200T · Stratford, CT · Accident · 2 fatal · Field investigation · Final report · Feb 20, 1988 · N2469M · Destroyed
  > The pilot and pilot-rated pax received vectors for multiple ILS approaches in deteriorating conditions. On the first attempt the aircraft passed over witnesses but was off course and not in a position to land. The second attempt was aborted before reaching…
- [NTSB NYC88FA087](https://openairdocs.org/ntsb/NYC88FA087.md): Piper PA-31-325 · Hamilton Twp., NJ · Accident · 3 fatal · Field investigation · Final report · Feb 20, 1988 · N27400 · Destroyed
  > The aircraft disappeared from radar at approximately 1 mile final on a night ILS rwy 13 approach. Radar data indicated that the aircraft completed almost 180 degrees of turn prior to disappearing. The aircraft crashed in a heavily wooded area. No evidence of…
- [NTSB MIA88IA112](https://openairdocs.org/ntsb/MIA88IA112.md): Cessna 182 · Stuart, FL · Incident · No injuries · Incident investigation · Final report · Feb 20, 1988 · N6418A · Minor damage
  > While on final apch to land from a banner towing flt, the eng lost power due to fuel exhaustion. The plt made an emergency landing off the airport, but the nose gear collapsed, which resulted in minor damage.
- [NTSB FTW88FA069](https://openairdocs.org/ntsb/FTW88FA069.md): Taylorcraft BC12-D · Big Spring, TX · Accident · 1 fatal · Field investigation · Final report · Feb 20, 1988 · N29779 · Destroyed
  > The pilot was on a local pleasure flight practicing aerobatic maneuvers in the vicinity of the airport. Witnesses thought the pilot was entering the pattern for landing at the completion of the aerobatic practice. They noted a power reduction after which the…
- [NTSB LAX88LA112](https://openairdocs.org/ntsb/LAX88LA112.md): Cessna 172N · Temecula, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1988 · N5135K · Substantial damage
  > At the end of a local pleasure flight, while on final approach, the pilot reported that there was a strong crosswind. Just prior to touchdown the wing lifted and the pilot lost control of the aircraft and collided with a wind tee. There were no mechanical…
- [NTSB FTW88FA063](https://openairdocs.org/ntsb/FTW88FA063.md): Beech S35 · Lake Charles, LA · Accident · 2 fatal · Field investigation · Final report · Feb 19, 1988 · N5701K · Destroyed
  > Acft crashed into a lake shortly after being vectored onto the final approach course for an ILS at 1,500'. Two current IFR plts were on board. Wx at the time was 500' ovc with 10 miles vis and no convective activity or turbulence reported in the area. No…
- [NTSB MIA88FA107](https://openairdocs.org/ntsb/MIA88FA107.md): Beech 58P · Dunedin, FL · Accident · 2 fatal · Field investigation · Final report · Feb 17, 1988 · N444MB · Destroyed
  > Flt was being vectored for practice ILS approach in VFR conditions while the plt-in-command was receiving a biennial flt review. Radar data showed the acft constantly veering to the left off assigned heading and witnesses reported only hearing one engine…
- [NTSB DEN88IA072](https://openairdocs.org/ntsb/DEN88IA072.md): De Havilland DH-7 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Feb 17, 1988 · N9058P · 2 aircraft · No damage
  > As rocky mtn airway flt 2129 (De Havilland DH-7, N9058P) & Cessna 441, N1WB, were arriving, there was moderate to hvy traffic & a rwy change was in progress. N1WB & flt 2129 were provided initial sequencing by feeder ctlrs (AR-1 & AR-4). Both flts were handed…
- [NTSB ATL88LA091](https://openairdocs.org/ntsb/ATL88LA091.md): Piper PA-38-112 · Gainesville, GA · Accident · No injuries · Limited investigation · Final report · Feb 17, 1988 · N9265T · Substantial damage
  > The plt rptd that he inadvertently allowed the airplane to descend below the VASI glidepath while on short-final, and that he failed to react in time to correct the situation. The airplane subsequently impacted an embankment short of the rwy threshold, in a…
- [NTSB ATL88LA090](https://openairdocs.org/ntsb/ATL88LA090.md): Mooney M20F · Birmingham, AL · Accident · Minor injuries · Limited investigation · Final report · Feb 15, 1988 · N7448V · Substantial damage
  > The airplane collided with trees on a hill at night, while on final approach. The plt rptd that he 'evidently got too low' on the approach. The visibility was 10 miles. The hilly terrain in the vicinity of the accident site was undeveloped, and had no…
- [NTSB MIA88LA106](https://openairdocs.org/ntsb/MIA88LA106.md): Waco UPF-7 · St Petersburg, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 1988 · N29368 · Substantial damage
  > The plt stated that while on apch to land, the engine lost power. During an attempt to land on runway 36 the acft stalled & nosed in from an approximate 50 foot altitude. No determination could be made as to the nature of the malfunction of the engine as…
- [NTSB DEN88LA078](https://openairdocs.org/ntsb/DEN88LA078.md): Piper PA-28-161 · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Feb 14, 1988 · N9419C · Substantial damage
- [NTSB MIA88FA105](https://openairdocs.org/ntsb/MIA88FA105.md): Cessna 425 · Sanford, FL · Accident · 1 fatal · Field investigation · Final report · Feb 12, 1988 · N6771Y · Destroyed
  > The flt was cleared for a night ILS apch & advised that twr at dest had closed. Twr had rptd at closing that fog was forming & the flt was advised of the fog. The acft was located on a remote part of the arpt the next morning. The ELT had activated but the…
- [NTSB DEN88LA069](https://openairdocs.org/ntsb/DEN88LA069.md): Cessna 172N · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Feb 12, 1988 · N4914D · Substantial damage
  > The private plt was practicing landings at centennial airport, denver, Colorado. Rnwy 17L, an asphalt rnwy 8,500 feet long and 101 feet wide, was in use. The plt reported that when he attempted to add power on final approach, the throttle cable would not…
- [NTSB FTW88LA058](https://openairdocs.org/ntsb/FTW88LA058.md): Cessna 152 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Feb 10, 1988 · N68806 · Substantial damage
  > The pilot experienced a complete loss of engine power while on the final approach. The damage to the aircraft occurred when he had to land on unsuitable terrain during the forced landing. Examination of the aircraft fuel system showed that a fuel line to the…
- [NTSB LAX88DVM01](https://openairdocs.org/ntsb/LAX88DVM01.md): Beech M35 · San Jose, CA · Accident · No injuries · Final report · Feb 9, 1988 · N2036C · Substantial damage
  > During a pleasure flight, while on final approach to the airport, the engine quit. The pilot made a forced landing in a shopping center parking lot, where the aircraft collided with three parked vehicles. Inspection of the engine did not identify any…
- [NTSB ATL88MA089](https://openairdocs.org/ntsb/ATL88MA089.md): British Aerospace 3101 · Springfield, OH · Accident · 3 fatal · Major investigation · Final report · Feb 9, 1988 · N823JS · Destroyed
  > A company designated instr and two f/o trainees were conducting a FAR 135 trng flt. The third apch was terminated with ago-around initiated over the rwy threshold at about 50 ft. after climbing to about 150 ft, the acft was observed to oscillate in yaw,…
- [NTSB ANC88LA028](https://openairdocs.org/ntsb/ANC88LA028.md): Cessna 172 · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Feb 8, 1988 · N2423U · Substantial damage
  > The certified flight instructor and his student were on a right downwind doing touch-and-go landings when, according to the pilot, the engine suddenly lost all power. Attempts at restarting the engine were unsuccessful, and the airplane landed short of the…
- [NTSB CHI88LA060](https://openairdocs.org/ntsb/CHI88LA060.md): Cessna 152 · Columbia, IL · Accident · No injuries · Limited investigation · Final report · Feb 6, 1988 · N5450Q · Substantial damage
  > Pilot-in-command's misjudged flare and his failure to attain a proper descent rate.
- [NTSB MIA88IA099](https://openairdocs.org/ntsb/MIA88IA099.md): Beech C-99 · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Feb 4, 1988 · N232BH · 2 aircraft · No damage
  > Drg a visual apch to Orlando intl arpt, bar harbor flt 3949 (Beech C-99, N232BH) contacted the tower (local controller) at 1817:07 & rprtd 5 mi north of the VOR for landing. The VOR was located 5.8 mi north of the rwy. About 20 sec later, the local controller…
- [NTSB DEN88FA063](https://openairdocs.org/ntsb/DEN88FA063.md): Cessna 421A · Helena, MT · Accident · 3 fatal · Field investigation · Final report · Feb 4, 1988 · N517S · Destroyed
  > This accident occurred during a night, ILS app to rwy 27 in IMC. The acft collided with a mountain 12 NM ese of the arpt while turning inbound to intercept the LOC course. Investigation revealed that one VOR receiver was set on the destinaton ILS freq, the…
- [NTSB DCA88MZ002](https://openairdocs.org/ntsb/DCA88MZ002.md): Mcdonnell Douglas DC-9-83 · Nashville, TN · Incident · Minor injuries · Final report · Feb 3, 1988 · N569AA · Minor damage
  > American flt 132 was loaded with undeclared & improperly marked haz mtrl (hm) packed in a fiber drum. It contained 5 galof 50% hydrogen peroxide solution (oxidizer) & 25 lbs of textreat s-w (corrosive agent; sodium orthosilicate-based mix),shipped by textile…
- [NTSB SEA88LA043](https://openairdocs.org/ntsb/SEA88LA043.md): Beech 58P · Ketchikan, AK · Accident · 2 fatal · Limited investigation · Final report · Feb 1, 1988 · N3689D · Destroyed
  > Acft collided with trees 1400 ft short of rwy during ILS approach. The acft was left of centerline and about 100 ft below glideslope at that time. Witnesses heard sounds of increased power and impact. When the approach clearance was given the wx was 1000 ft…
- [NTSB MIA88FA097](https://openairdocs.org/ntsb/MIA88FA097.md): Timm N2T-1 · Pompano Beach, FL · Accident · Serious injuries · Field investigation · Final report · Jan 31, 1988 · N60789 · Destroyed
  > Pilot experienced complete loss of engine power while on short final. While making forced landing on a city street the acft collided with a car. Post crash examination of the acft and crash site revealed the acft to contain approx. 3 ounces of fuel with no…
- [NTSB DEN88LA073](https://openairdocs.org/ntsb/DEN88LA073.md): Cessna 182R · Pueblo, CO · Accident · No injuries · Limited investigation · Final report · Jan 31, 1988 · N9393H · Substantial damage
  > The instrument rated pvt plt was completing a personal IFR flight from telluride, Colorado, to Colorado springs, Colorado, with three pax. The destination wx went below IFR minimums prior to the flight's arrival and the aircraft diverted to Pueblo, Colorado,…
- [NTSB LAX88LA100](https://openairdocs.org/ntsb/LAX88LA100.md): Cessna 150F · Lake Havasu Cty, AZ · Accident · No injuries · Limited investigation · Final report · Jan 27, 1988 · N7069F · Substantial damage
  > During a pleasure flt, while on final approach, the engine experienced a pwr loss. An emergency landing was made short of the rwy where the acft collided with a telephone pole, slowing the acft during the landing roll. Inspection of the engine revealed that…
- [NTSB LAX88LA099](https://openairdocs.org/ntsb/LAX88LA099.md): Cessna 152 · El Toro, CA · Accident · No injuries · Limited investigation · Final report · Jan 27, 1988 · N4914H · Destroyed
  > The student plt was practicing touch-&-go landings & was cleared for an apch behind a C-130. He stated that he noted the touchdown point of the C-130 & planned his apch to remain above the C-130'S flt path. However, just before landing, when the acft was at…
- [NTSB LAX88DUK01](https://openairdocs.org/ntsb/LAX88DUK01.md): Colman BD-4 · Half Moon Bay, CA · Accident · Minor injuries · Final report · Jan 27, 1988 · N49RC · Substantial damage
- [NTSB BFO88FA014](https://openairdocs.org/ntsb/BFO88FA014.md): Cessna T210N · Sterling, VA · Accident · No injuries · Field investigation · Final report · Jan 24, 1988 · N5350A · Substantial damage
  > Abt 2.7 hrs after takeoff, the student plt & instructor (CFI) were practicing instrument apchs when the eng lost pwr. The CFI took control of the acft & made a forced lndg, but the acft was damaged on rough terrain. An exam of the acft revealed the right &…
- [NTSB CHI88LA055](https://openairdocs.org/ntsb/CHI88LA055.md): Bellanca 17-30 · Barron, WI · Accident · No injuries · Limited investigation · Final report · Jan 23, 1988 · N7377V · Substantial damage
  > The pilot misjudged altitude and distance and touched down short of the runway and struck a snowbank. Pax stated that the pilot cut pwr about 200 ft from the runway; the aircraft began to sink fast. The pilot applied power too late to prevent the undershoot.…
- [NTSB BFO88LA015](https://openairdocs.org/ntsb/BFO88LA015.md): Cessna 210 · Danville, VA · Accident · Minor injuries · Limited investigation · Final report · Jan 21, 1988 · N210PE · Substantial damage
  > Engine power loss occurred when the acft was in the traffic pattern. The plt made a forced landing in an open field about 2 miles from the airport. The investigation disclosed less than 1 gal of fuel in the selected rt tank.
- [NTSB DCA88MA017](https://openairdocs.org/ntsb/DCA88MA017.md): Fairchild SA-227AC · Bayfield, CO · Accident · 9 fatal · Major investigation · Final report · Jan 20, 1988 · N68TC · Destroyed
  > The aircraft was operating as Continental express flight 2286. During the approach in IFR conditions, the aircraft went below the minimum descent altitude then struck the terrain at 7180 feet MSL. Exam of the aircraft did not disclose any pre-impact failures…
- [NTSB ATL88LA083](https://openairdocs.org/ntsb/ATL88LA083.md): de Havilland DHC-6-200 · Charlotte, NC · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 1988 · N996SA · Substantial damage
  > During the final approach on the instrument landing system, the pilot descended below the glidepath. The aircraft collided with a tree and struck the ground short of the runway threshold.
- [NTSB MKC88FA041](https://openairdocs.org/ntsb/MKC88FA041.md): Piper PA-31T-620 · Hazelwood, MO · Accident · 1 fatal · Field investigation · Final report · Jan 19, 1988 · N200RS · Destroyed
  > Proper glide path not maintained by p.I.c., decision height not identified by the p.I.c., missed approach not performed by the p.I.c. turning on lights in overcast.
- [NTSB ATL88FA082](https://openairdocs.org/ntsb/ATL88FA082.md): Piper PA-23 · Augusta, GA · Accident · Serious injuries · Field investigation · Final report · Jan 19, 1988 · N101JR · Destroyed
- [NTSB MIA88LA089](https://openairdocs.org/ntsb/MIA88LA089.md): Piper PA-32-260 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Jan 18, 1988 · N4818S · Substantial damage
  > The pilot, while on an on-demand air taxi flight, switched to an empty fuel tank in preparation for landing and the engine failed. The pilot then executed a forced landing to the grass short of the runway and the landing gear failed.
- [NTSB FTW88MA048](https://openairdocs.org/ntsb/FTW88MA048.md): Hawker Siddeley 125-600A · Houston, TX · Accident · 1 fatal · Major investigation · Final report · Jan 18, 1988 · XAKUT · Destroyed
  > Bfr tkof, a plt of xa-kut was briefed that the Houston hobby (hou) wx was IFR with '... Indefinite ceiling zero sky obscured visibility's 1/16 of a mile and fog...' He was also adzd IFR conds were forecast until 0900 CST, gradually improving to marginal…
- [NTSB FTW88LA053](https://openairdocs.org/ntsb/FTW88LA053.md): Beech V35B · Temple, TX · Accident · No injuries · Limited investigation · Final report · Jan 18, 1988 · N3804X · Substantial damage
  > The pilot failed to execute a missed approach when he descended through decision height.
- [NTSB CHI88LA044](https://openairdocs.org/ntsb/CHI88LA044.md): Beech A36 · St Paul, MN · Accident · No injuries · Limited investigation · Final report · Jan 18, 1988 · N4479W · Substantial damage
- [NTSB CHI88FA046](https://openairdocs.org/ntsb/CHI88FA046.md): Piper PA-23-250 · Carbondale, IL · Accident · 3 fatal · Field investigation · Final report · Jan 18, 1988 · N40265 · Destroyed
  > Shortly after reporting the outer marker while executing an ILS runway 18 approach in actual instrument meteorological conditions, the aircraft deviated left of the localizer centerline. At a position approximately 1/2 mile outside the middle marker and about…
- [NTSB LAX88LA090](https://openairdocs.org/ntsb/LAX88LA090.md): Aero Commander 200D · Chico, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 1988 · N2977T · Substantial damage
  > At the end of a cross country flt, while in the pattern turning from base to final, the plt stated that the arpt environment was lost. At the same time, the instrument white lights, under the glareshield began to flicker which drowned out the normal…
- [NTSB FTW88LA049](https://openairdocs.org/ntsb/FTW88LA049.md): Piper PA-28-235 · Littlefield, TX · Accident · No injuries · Limited investigation · Final report · Jan 16, 1988 · N8737W · Substantial damage
  > The connecting rod cap attaching bolt failed in flight which caused the engine to stop. The pilot was on final approach at the time but was unable to reach the runway. A forced landing was made in a farm field short of the airport. Upon touchdown the aircraft…
- [NTSB CHI88LA047](https://openairdocs.org/ntsb/CHI88LA047.md): Cessna 172P · Jenison, MI · Accident · No injuries · Limited investigation · Final report · Jan 16, 1988 · N62877 · Substantial damage
  > The low total time pilot took off in crosswind conditions for a proficiency flight and during a go around lost directional control and struck a snow bank along the downwind side of the runay.
- [NTSB ATL88LA079](https://openairdocs.org/ntsb/ATL88LA079.md): Cessna 150J · Fayetteville, NC · Accident · Serious injuries · Limited investigation · Final report · Jan 15, 1988 · N60362 · Destroyed
  > The student plt rptdly became lost on a solo x-c flight, and was unable to locate her destination arpt. She subsequently obtained radar vectors to another arpt. The airplane subsequntly lost power while on final appch to the arpt, and the airplane crashed…
- [NTSB FTW88MA047](https://openairdocs.org/ntsb/FTW88MA047.md): Gates Learjet 36A · Monroe, LA · Accident · 2 fatal · Major investigation · Final report · Jan 8, 1988 · N79SF · Destroyed
  > The crew was executing the ILS approach and had turned back inbound on the procedure turn to the outer marker when the co-pilot stated they were 5.9 DME in a calm voice with no indication of a problem. Impact with the ground occurred at about 5.9 DME,…
- [NTSB CHI88FA039](https://openairdocs.org/ntsb/CHI88FA039.md): Cessna T210N · Bedford Park, IL · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1988 · N4746C · Destroyed
  > Drg an arrival to chicago midway arpt on a cold night, the plt rprtd he was having trouble with a sticky throttle. Subsequently, he made an emergency transmission & said he was 'going in.' Witnesses saw the acft in a descent before it crashed. One witness…

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

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

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