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

## Cases, newest first

- [NTSB LAX89FA081](https://openairdocs.org/ntsb/LAX89FA081.md): Cessna 414 · Pleasanton, CA · Accident · 1 fatal · Field investigation · Final report · Jan 9, 1989 · N1672T · Destroyed
  > Failure of the pilot to properly follow the IFR (instrument flight rules) procedures by not maintaining the minimum descent altitude for that seqment of the approach. The weather conditions and mountainous terrain were considered to be related factors.
- [NTSB MIA89LA064](https://openairdocs.org/ntsb/MIA89LA064.md): Piper PA-28-161 · Bunnell, FL · Accident · No injuries · Limited investigation · Final report · Jan 7, 1989 · N81444 · Substantial damage
  > Misjudgement of altitude and distance to the runway by the student pilot, and inadequate supervision by the instructor pilot (CFI). The exposed (raised) runway lip was a factor.
- [NTSB MIA89LA061](https://openairdocs.org/ntsb/MIA89LA061.md): Cessna R172K · Margate, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 5, 1989 · N736BX · Substantial damage
  > Failure of the engine driven oil pump due to foreign object(s), which resulted in oil starvation and subsequent engine failure. Factors related to the accident were: dark night and trees in the emergency landing area.
- [NTSB DEN89FA056](https://openairdocs.org/ntsb/DEN89FA056.md): Cessna 208B · Aspen, CO · Accident · Serious injuries · Field investigation · Final report · Jan 5, 1989 · N945FE · Destroyed
  > Pilot's improper IFR procedure. Contributing factors included moderate turbulence, low ceilings, obscuration and snow.
- [NTSB NYC89FA062](https://openairdocs.org/ntsb/NYC89FA062.md): Piper PA-22-150 · Limington, ME · Accident · 2 fatal · Field investigation · Final report · Jan 4, 1989 · N5704D · Destroyed
  > Failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: the adverse wind conditions, lack of pilot experience in the type of aircraft, and the lack of shoulder harness/upper body…
- [NTSB ANC89LA031](https://openairdocs.org/ntsb/ANC89LA031.md): Cessna 207A · Russian Mission, AK · Accident · No injuries · Limited investigation · Final report · Jan 3, 1989 · N7329U · Substantial damage
  > The partial engine power loss due to undetermined reasons. Contributing to the accident was the pilot's improper inflight planning by flying at a traffic pattern altitude insufficient to insure a safe emergency landing either on or off the airport and his…
- [NTSB ATL89FA065](https://openairdocs.org/ntsb/ATL89FA065.md): Mitsubishi MU-2B · Mansfield, OH · Accident · 4 fatal · Field investigation · Final report · Jan 2, 1989 · N500V · Destroyed
  > Failure of the pilot to maintain control of the aircraft, due to spatial disorientation, at about the time he was changing radio frequencies during an IFR approach.
- [NTSB FTW89LA035](https://openairdocs.org/ntsb/FTW89LA035.md): Cessna 150 · Austin, TX · Accident · No injuries · Limited investigation · Final report · Jan 1, 1989 · N66385 · Substantial damage
  > The pilot did not have an adequate fuel supply to complete the flight. The plts flt planning was inadequate and the ignored opportunities to obtain fuel enroute led to fuel exhaustion, prior to reaching destination.
- [NTSB CHI89FA038](https://openairdocs.org/ntsb/CHI89FA038.md): Cessna T210N · Springfield, IL · Accident · 2 fatal · Field investigation · Final report · Jan 1, 1989 · N2305U · Destroyed
  > The pilot's improper IFR procedure during an ILS approach in below minimum conditions, and the pilot's failure to proceed to an alternate destination. Contributing factors were the adverse weather conditions.
- [NTSB NYC89LA058](https://openairdocs.org/ntsb/NYC89LA058.md): Piper PA-60 · Somerville, NJ · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 1988 · N90393 · Destroyed
  > Improper inflight decisions while approaching the airport on final approach with defective magnetos. The right fuel selector was placed in the closed position, the pilot attempted a go around, raised the landing gear and flaps, failed to maintain VMC, and…
- [NTSB MIA89LA060](https://openairdocs.org/ntsb/MIA89LA060.md): Air Command 532E · Clearwater, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 1988 · N70319 · Substantial damage
  > The student pilot said he did not remember anything about the accident. Witnesses stated that at about 50 ft AGL on final approach the gyrocopter rapidly descended. It remained level and hit hard, rolling over on impact. Witnesses stated that the engine was…
- [NTSB CHI89LA041](https://openairdocs.org/ntsb/CHI89LA041.md): Cessna 152II · Grand Rapids, MI · Accident · No injuries · Limited investigation · Final report · Dec 31, 1988 · N714XV · Destroyed
  > Pilot's total lack of experience in this type of operation.
- [NTSB NYC89FA059](https://openairdocs.org/ntsb/NYC89FA059.md): Beech A36 · Bridgeport, CT · Accident · 1 fatal · Field investigation · Final report · Dec 24, 1988 · N262C · Destroyed
  > Twice prior to being established on final the pilot was asked if he was getting proper indications for the approach to land. Contact was subsequently lost while the pilot was attempting to make an ILS approach to runway 06 at Bridgeport. The aircraft was…
- [NTSB MIA89LA058](https://openairdocs.org/ntsb/MIA89LA058.md): Cessna 175 · Starke, FL · Accident · No injuries · Limited investigation · Final report · Dec 24, 1988 · N9373B · Substantial damage
  > Flt was 3 miles east of arpt returning to land at alt of aprx 2,000 ft, when the eng quit. Plt was unable to restart & elected to land in small trees as a nearby highway was congested. Acft collided with trees & fell to the ground. Examination of the eng…
- [NTSB DEN89LA048](https://openairdocs.org/ntsb/DEN89LA048.md): Cessna TR182 · Lamar, CO · Accident · No injuries · Limited investigation · Final report · Dec 24, 1988 · N757MU · Destroyed
  > The pilot was making a VFR approach for landing. The landing gear was lowered and full flaps were deployed. The pilot said he allowed the airspeed to get too low and the aircraft stalled. The nose and left wing dropped and the pilot added full power. The nose…
- [NTSB CHI89FA035](https://openairdocs.org/ntsb/CHI89FA035.md): Cessna 310R · Madison, IN · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1988 · N5121J · Destroyed
  > Pilot-in-command's disregard of IFR procedures in descending below the minimum decision height for the approach to a point where collision with towers and/or wires became possible. His abrupt maneuver to avoid such collision resulted in a stall/spin, from…
- [NTSB ATL89FA061](https://openairdocs.org/ntsb/ATL89FA061.md): Cessna 210B · Mt Airy, NC · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1988 · N210RW · Destroyed
  > The pilot attempted to locate the destination airport in instrument meteorological conditions, and his failure to maintain a sufficient altitude to avoid the terrain in the area. Factors contributing to the accident were the pilot' overconfidence in his…
- [NTSB ATL89LA060](https://openairdocs.org/ntsb/ATL89LA060.md): Beech C23 · Gilbertsville, KY · Accident · Minor injuries · Limited investigation · Final report · Dec 23, 1988 · N6046V · Substantial damage
  > During preflt inspection fuel was noted to be up to the slots in the tab for the reduced fuel indicators, or 20 gal each tank. A 3 hour, dark night, cross country was flown to destination. PIC said acft arrived with about 5 gal fuel remaining in each tank. On…
- [NTSB MKC89FA043](https://openairdocs.org/ntsb/MKC89FA043.md): Bell 206L-1 · Cape Girardeau, MO · Accident · 3 fatal · Field investigation · Final report · Dec 22, 1988 · N119CG · Destroyed
  > The helicopter was dispatched at night on an emerg med svc (EMS) flt fm a hospital at Cape Girardeau, MO. Purpose of theflt was to transport a patient fm a hospital at marion, IL, to Cape Girardeau. Wx at Cape Girardeau deteriorated after the acft departed.…
- [NTSB MIA89LA055](https://openairdocs.org/ntsb/MIA89LA055.md): Cessna 172N · Clearwater, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 1988 · N5160F · Substantial damage
  > The plt stated that he had been given a short approach for runway 4, when the tower told him to go around. He added power, retracted the flaps, and made a sharp right turn. The acft stalled and crashed into an office building aprx 1 mile from the airport.
- [NTSB LAX89LA066](https://openairdocs.org/ntsb/LAX89LA066.md): Cessna 150L · Hesperia, CA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1988 · N1542Q · Substantial damage
  > At the end of a pleasure flight, while on final approach, the airplane was low on the approach. Just prior to reaching the airport boundary, the airplane collided with the top of a vehicle travelling on a road perpendicular to the runway. The airplane…
- [NTSB FTW89LA032](https://openairdocs.org/ntsb/FTW89LA032.md): Mooney M20C · Houma, LA · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 1988 · N6444U · Substantial damage
  > The airplane was on an IFR flight plan but was in VFR conditions when the communications radios failed. Pilot used hand held transceiver, but communications were not satisfactory. Pilot elected to continue to destination but did not declare an emergency nor…
- [NTSB CHI89IA034](https://openairdocs.org/ntsb/CHI89IA034.md): Aerospatiale ATR-42 · Mosinee, WI · Incident · No injuries · Incident investigation · Final report · Dec 22, 1988 · N427MQ · No damage
  > Stall induced by the accretion of moderate to severe clear icing.
- [NTSB CHI89LA033](https://openairdocs.org/ntsb/CHI89LA033.md): Cessna 414 · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Dec 20, 1988 · N414CM · Substantial damage
- [NTSB ANC89LA024](https://openairdocs.org/ntsb/ANC89LA024.md): Cessna 170B · North Pole, AK · Accident · No injuries · Limited investigation · Final report · Dec 18, 1988 · N3138B · Substantial damage
  > The plt rprtd that drg an apch to land, a x-wind caused the acft to drift to the left. Subsequently, the left wing struck trees along the edge of the rwy & the acft crashed. The plt rprtd the wind was from 120 deg at 6 gusting 10 KTS.
- [NTSB SEA89LA028](https://openairdocs.org/ntsb/SEA89LA028.md): Cessna 210D · Twin Falls, ID · Accident · No injuries · Limited investigation · Final report · Dec 17, 1988 · N3815Y · Substantial damage
  > Prior to landing, the pilot was unable to lower the nose gear by using either the normal or emergency systems. Subsequently, he landed the acft with the main gear extended & the nose gear in the retracted position. After landing, the nose gear uplock actuator…
- [NTSB LAX89FA064](https://openairdocs.org/ntsb/LAX89FA064.md): Cessna T210L · Buena Park, CA · Accident · 2 fatal · Field investigation · Final report · Dec 17, 1988 · N4675Q · Destroyed
  > The pilot used poor judgement in beginning the flight with inadequate fuel; his failure to follow normal v.f.r. procedures; and his poor preflight inspection.
- [NTSB LAX89DVM03](https://openairdocs.org/ntsb/LAX89DVM03.md): Beard Varieze · Palo Alto, CA · Accident · 1 fatal · Final report · Dec 13, 1988 · N226RB · Substantial damage
  > The acft crashed 200 ft short of the rwy in a pond and nosed over. Witnesses heard the sounds of low power. Evidence of low/no power was shown by the prop. Investigation revealed that unapproved engine mods were made by pilot/owner. An untested carb heat…
- [NTSB ATL89FA054](https://openairdocs.org/ntsb/ATL89FA054.md): Aero Commander 720 · Alcoa, TN · Accident · 2 fatal · Field investigation · Final report · Dec 9, 1988 · N120G · Destroyed
  > After encountering icing conditions in flight and experiencing problems maintaining altitudes and headings, the pilot elected to divert from his planned destination of dayton, oh to knoxville, TN. While on final approach after descending 1300 ft below minimum…
- [NTSB SEA89FA021](https://openairdocs.org/ntsb/SEA89FA021.md): Cessna 335 · Arlington, WA · Accident · 2 fatal · Field investigation · Final report · Dec 3, 1988 · N2706F · Destroyed
  > Drg a ngt arr, the plt was vectored for a LOC rwy 34 apch. After rchg the final apch fix/outer marker (om), he was clrd for the apch. Abt 5 or 6 min later, the ATC ctlr noticed the acft was aprx 7 mi nw of the arpt, climbing abv 3000' MSL. Missed apch…
- [NTSB NYC89LA037](https://openairdocs.org/ntsb/NYC89LA037.md): Cessna 172 · Block Island, RI · Accident · No injuries · Limited investigation · Final report · Dec 3, 1988 · N19863 · Substantial damage
  > The pilot of the Cessna 182 was on downwind when he stated that he pulled the carburetor heat on and then pulled the power back to 1500 RPM. Within a few seconds the engine quit and the pilot informed the tower. The aircraft landed about 500 feet short of the…
- [NTSB MKC89LA034](https://openairdocs.org/ntsb/MKC89LA034.md): Cessna 182 · Garnett, KS · Accident · No injuries · Limited investigation · Final report · Dec 3, 1988 · N5851B · Substantial damage
  > Having just made a parachutist's drop, during a sky diving operation, the private pilot spiraled down from altitude to land, but had to extend his pattern to allow a departing acft to leave. During a long final approach, the engine failed and an emergency…
- [NTSB FTW89FA028](https://openairdocs.org/ntsb/FTW89FA028.md): Piper PA-38-112 · Tomball, TX · Accident · 1 fatal · Field investigation · Final report · Dec 3, 1988 · N2379V · Destroyed
  > The airplane was being used for touch and go landings by an instructor and a low time student. It was on a base leg to land to the south when the instructor told the tower she had lost the engine and was going down. There were no witnesses to the accident.…
- [NTSB ATL89LA049](https://openairdocs.org/ntsb/ATL89LA049.md): Cessna 172M · Griffin, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 1988 · N92388 · Substantial damage
  > After a preflight and runup the pilot made a takeoff and remained in closed traffic for landing practice. On downwind, opposite the desired point of touchdown, he retarded power, applied carb heat and slowed the airplane. Turning base, the acft lost power.…
- [NTSB LAX89LA041](https://openairdocs.org/ntsb/LAX89LA041.md): Piper PA-28 · Modesto, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 1, 1988 · N5852V · Substantial damage
  > During an ILS approach in night instrument meteorological conditions, the pilot allowed the airspeed to diminish resulting in the airplane stalling. Before the pilot could regain control, the airplane collided with the terrain short of the runway. There were…
- [NTSB LAX89FA057](https://openairdocs.org/ntsb/LAX89FA057.md): Beech N35 · Hanford, CA · Accident · 1 fatal · Field investigation · Final report · Nov 28, 1988 · N9469Y · Destroyed
  > The pilot failed to maintain sufficient altitude and descended below the minimum descent altitude while executing the missed approach. Contributing to this accident was the deteriorating weather conditions and the pilot's wish to return the airplane to its…
- [NTSB FTW89FA025](https://openairdocs.org/ntsb/FTW89FA025.md): Luscombe 8E · Port Lavaca, TX · Accident · 1 fatal · Field investigation · Final report · Nov 27, 1988 · N2301K · Destroyed
  > There were no records to indicate the non-instrument rated pilot received a pre-flight weather briefing from any weather reporting service. Witnesses in the area of the accident stated the night was dark and the ground was covered with fog. The airplane…
- [NTSB NYC89LA040](https://openairdocs.org/ntsb/NYC89LA040.md): Bellanca 7ECA · Erwinna, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 1988 · N8572V · Substantial damage
  > Off airport landing in unsuitable terrain due to a power loss caused by carburetor icing.
- [NTSB ANC89LA020](https://openairdocs.org/ntsb/ANC89LA020.md): Piper PA-12 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Nov 25, 1988 · N2930M · Substantial damage
  > The pilot misjudged the approach and failed to maintain a proper descent rate. A related factor was trees.
- [NTSB CHI89LA028](https://openairdocs.org/ntsb/CHI89LA028.md): Piper PA-32-260 · Marquette, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 24, 1988 · N3662W · Substantial damage
  > After encountering unforecast adverse wx at his intended destn, the plt circled the area a couple of times, then diverted to Marquette, MI. However, before reaching the alternate arpt, the eng lost power due to fuel exhaustion. Subsequently, the acft collided…
- [NTSB ATL89LA044](https://openairdocs.org/ntsb/ATL89LA044.md): Piper PA-24-250 · Ft Mill, SC · Accident · No injuries · Limited investigation · Final report · Nov 23, 1988 · N6711P · Substantial damage
  > Two days before the acdnt, the plt had fueled the acft to capacity & flown it a short distance to his house at a pvt airstrip. After the flt, he noticed fuel on the tops of both wings, aft of the fuel filler caps. He was aware that fuel had leaked from the…
- [NTSB ATL89LA043](https://openairdocs.org/ntsb/ATL89LA043.md): Cessna 182 · Thomaston, GA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1988 · N5473B · Substantial damage
  > The pilot and three passengers were on a night flight in an aircraft that was equipped to carry skydivers. During the approach to land, the landing light failed. While attempting to get the light to operate, the pilot allowed an undershoot to develop.…
- [NTSB NYC89LA034](https://openairdocs.org/ntsb/NYC89LA034.md): Cessna 340 · Oxford, CT · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 1988 · N468CM · Destroyed
  > Collision with trees and terrain due to the pilot exceeding approach minimum altitude during an ILS approach.
- [NTSB MKC89FA027](https://openairdocs.org/ntsb/MKC89FA027.md): Beech E-90 · Locust Grove, AR · Accident · 6 fatal · Field investigation · Final report · Nov 19, 1988 · N308PS · Destroyed
  > The pilot's failure to maintain obstacle clearance altitude and exceeding the minimum descent altitude published in the approach procedure.
- [NTSB LAX89LA052](https://openairdocs.org/ntsb/LAX89LA052.md): Piper PA-28R-201T · Van Nuys, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1988 · N4306M · Substantial damage
  > The pilot lost control of the aircraft while descending for landing and collided with a pole. The pilot stated that he was cleared to land behind a king air, on runway 16R. The pilot stated that about the time he descended to 50 feet AGL, near the threshold,…
- [NTSB MIA89LA037](https://openairdocs.org/ntsb/MIA89LA037.md): Cessna 150J · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Nov 18, 1988 · N61317 · Substantial damage
  > The acft departed, entered left downwind leg for touch-and-go landings. When at midfield downwind, the instructor plt stated the eng quit & he was unable to restart it. The acft continued downwind momentarily then the instructor plt turned the acft to land at…
- [NTSB ATL89LA039](https://openairdocs.org/ntsb/ATL89LA039.md): Cessna 172 · Pikeville, KY · Accident · No injuries · Limited investigation · Final report · Nov 18, 1988 · N2840Q · Substantial damage
  > The pilot had flown about 3.7 hours and was about 2 miles from his destination airport when the engine stopped and he was forced to land in a swamp. The pilot had topped off the acft so that it contained 42 gallons of fuel (38 gallons of usable fuel). The…
- [NTSB FTW89LA021](https://openairdocs.org/ntsb/FTW89LA021.md): Bell 206L-1 · Gulf-Of-Mexico (Gulf of Mexico) · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1988 · N2780W · Substantial damage
  > Engine failure for undetermined reasons and the pilot misjudging his altitude during the flare resulting in a hard landing.
- [NTSB MIA89FA033](https://openairdocs.org/ntsb/MIA89FA033.md): Piper PA-28-181 · Jacksonville, FL · Accident · 4 fatal · Field investigation · Final report · Nov 14, 1988 · N8342L · Destroyed
  > Drg a ngt arrival, the plt requested a special VFR clnc to the arpt & was adzd that the wx was partially obscured, vis was 1 mi with fog & the wind was calm. As he contd the apch, all flts were adzd the vis had dropped to 1/2 mi. The plt requested clnc for an…
- [NTSB DEN89LA033](https://openairdocs.org/ntsb/DEN89LA033.md): Cessna 310H · Carlsbad, NM · Accident · Serious injuries · Limited investigation · Final report · Nov 14, 1988 · N1044Q · Substantial damage
  > On an IFR business/training flt, the ATP plt made an unscheduled fuel stop. On a practice ILS apch to rwy 3, circling to land rwy 21, the acft yawed hard rt and the plt lost directional control. The plt said it sounded and felt like the rt engine had lost…

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

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

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