# 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 171 of 420 · 20,996 cases

## Cases, newest first

- [NTSB MIA88FA195](https://openairdocs.org/ntsb/MIA88FA195.md): Piper PA-31-P · Miami Lakes, FL · Accident · 1 fatal · Field investigation · Final report · Jun 17, 1988 · N560JB · Destroyed
  > The instructor (CFI), who survived, was flying the acft fm the rgt fnt seat while the owner/plt was in the left seat. The flt had progressed normally until the plts rtrnd to the arpt to lnd. Clnc was received to lnd on rwy 9L. According to the CFI, he lowered…
- [NTSB LAX88LA226](https://openairdocs.org/ntsb/LAX88LA226.md): de Havilland DHC-6-100 · Tau, Antarctica · Accident · Serious injuries · Limited investigation · Final report · Jun 17, 1988 · N202RH · Destroyed
  > The captain, who was flying the twin otter from the right seat, entered a right hand traffic pattern for landing. A left quartering, 15 knot headwind, was gusting across the airport. Upon turning to the final approach the captain reduced the aircraft's engine…
- [NTSB ATL88LA194](https://openairdocs.org/ntsb/ATL88LA194.md): Cessna 150F · Newnan, GA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1988 · N7776F · Destroyed
  > After making a local flt, the student plt returned to the arpt, but drg the landing, the acft touched down abt 60' short of the rwy. Shortly after touching down, the nose gear sheared off. The acft then traveled abt 370 ft further before coming to rest beside…
- [NTSB BFO88FA054](https://openairdocs.org/ntsb/BFO88FA054.md): Cessna 177RG · Clinton, MD · Accident · Serious injuries · Field investigation · Final report · Jun 11, 1988 · N2070Q · Substantial damage
  > Eng pwr loss occurred when the instrument student advanced the throttle to do a go-around when the acft was too high to lnd on rwy 5 following a simulated instrmt apch. The instr took control of the acft and about half-way down the rwy, at about 300 ft AGL,…
- [NTSB DEN88FA126](https://openairdocs.org/ntsb/DEN88FA126.md): Cessna 404 · Denver, CO · Accident · Serious injuries · Field investigation · Final report · Jun 10, 1988 · N8827K · Substantial damage
  > The plt was on a flt from greeley to Denver, Colorado to obtain minor maint on a cargo door. As the acft was being vectored on final apch, the plt rprtd that he believed the acft had fuel starvation. Subsequently, the acft was observedto make a complete roll…
- [NTSB CHI88DEM06](https://openairdocs.org/ntsb/CHI88DEM06.md): Koopsen Miller Sport II · Lake City, MI · Accident · No injuries · Final report · Jun 10, 1988 · N5574A · Substantial damage
  > Just prior to turning on final approach to land, the pilot experienced a complete loss of power. He continued the approach but decelerated more rapidly than he anticipated and was unable to clear a stand of trees on the approach path. Examination revealed a…
- [NTSB MIA88LA188](https://openairdocs.org/ntsb/MIA88LA188.md): Cessna T210R · Tampa, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1988 · N6390U · Substantial damage
  > The plt stated that on final apch to Tampa international airport, he reduced power, put the gear down and, as he tried to add power, none was available. During an attempted forced landing, he hit the top of an office trailer and a guy wire before coming to…
- [NTSB LAX88LA218](https://openairdocs.org/ntsb/LAX88LA218.md): Rockwell 690C · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Jun 8, 1988 · N47TT · Substantial damage
  > At the end of a cross country flight, while on final approach to the runway, the right engine quit. Shortly thereafter, the left engine quit. The pilot made a forced landing in a field short of the runway where during the landing roll the airplane collided…
- [NTSB LAX88LA217](https://openairdocs.org/ntsb/LAX88LA217.md): Cessna 150F · Quartzsite, AZ · Accident · 1 fatal · Limited investigation · Final report · Jun 8, 1988 · N7892F · Substantial damage
- [NTSB ATL88LA190](https://openairdocs.org/ntsb/ATL88LA190.md): Sikorsky S-55C · Coaling, AL · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1988 · N883 · Substantial damage
  > The helo was approaching a helipad for landing after the last aerial application flight of the day when there was a pop and tail rotor control was lost. After several rotations about the vertical axis, the PIC landed the helo hard, collapsing the landing…
- [NTSB SEA88LA104](https://openairdocs.org/ntsb/SEA88LA104.md): Cessna 210 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N70SA · Substantial damage
  > During an instructional flight and an ILS approach, a total loss of engine power occurred at about 1200 feet AGL. A forced landing was made onto rough terrain. During landing roll the nose gear separated from the aircraft. The private pilot receiving…
- [NTSB MKC88LA106](https://openairdocs.org/ntsb/MKC88LA106.md): Cessna 172 · Lakeview, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1988 · N75540 · Substantial damage
  > While attempting to land crosswind on a 'one way' runway, the plt said a gust of wind blew him towards some bordering trees, so he made a decision to 'go around'. The plt said he applied full throttle and raised the flaps from the full flap setting, and…
- [NTSB SEA88LA103](https://openairdocs.org/ntsb/SEA88LA103.md): Piper PA-22-150 · Hawthorne, NV · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1988 · N3741P · Substantial damage
  > During a go-around due to the pilot having difficulty landing with a gusting crosswind, the aircraft struck a barbed wire fence with the main landing gear and a fence post with the left horizontal stabilizer. The aircraft then crossed a road and came to rest…
- [NTSB LAX88LA209](https://openairdocs.org/ntsb/LAX88LA209.md): Schweizer SGS 2-33A · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Jun 3, 1988 · N7768S · Substantial damage
  > At the end of a pleasure flt, the plt extended the downwind leg for landing, thinking that the touchdown altitude was 12 ft instead of, in actuality, 220 ft. the plt normally flew out of another airport with an alt of 12 ft. from the extended downwind, the…
- [NTSB CHI88IA129](https://openairdocs.org/ntsb/CHI88IA129.md): Short Brothers SD3-60 · Madison, WI · Incident · No injuries · Incident investigation · Final report · Jun 3, 1988 · N383MQ · No damage
  > Failure of the right outboard flap position signalling cable due to chaffing initiated by improper installation/rigging by a manufacturer's vendor.
- [NTSB NYC88LA153](https://openairdocs.org/ntsb/NYC88LA153.md): Piper PA-60 · Latrobe, PA · Accident · No injuries · Limited investigation · Final report · Jun 2, 1988 · N90DR · Substantial damage
  > Accident was pilot loss of directional control during landing.
- [NTSB DEN88LA117](https://openairdocs.org/ntsb/DEN88LA117.md): Cessna T210N · Ft. Collins, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 1988 · N6638N · Substantial damage
- [NTSB DCA88IA060](https://openairdocs.org/ntsb/DCA88IA060.md): Boeing 747-200 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Jun 1, 1988 · SXOAB · Minor damage
  > None submitted
- [NTSB CHI88LA124](https://openairdocs.org/ntsb/CHI88LA124.md): Beech B-19A · Lacon, IL · Accident · No injuries · Limited investigation · Final report · May 31, 1988 · N4306S · Substantial damage
  > A hard landing made by the student pilot after attempting to recover from a bounced landing.
- [NTSB LAX88LA206](https://openairdocs.org/ntsb/LAX88LA206.md): Cessna T210M · Long Beach, CA · Accident · Minor injuries · Limited investigation · Final report · May 30, 1988 · N6178N · Substantial damage
  > While on final approach to the runway, the engine quit. During the forced landing the empennage caught on the airport boundary fence. The airplane collided with the terrain and nosed over. Inspection of the fuel tanks revealed that one tank was empty and the…
- [NTSB NYC88LA151](https://openairdocs.org/ntsb/NYC88LA151.md): Beech 23 · Meriden, CT · Accident · 1 fatal · Limited investigation · Final report · May 29, 1988 · N6042X · Substantial damage
  > The Beech 23 lost power during a go-around. During an off-airport landing, the acft struck a house. The private pilot died the following day of injuries and the flight instructor was seriously injured. There was no evidence of a large fuel spill and only…
- [NTSB FTW88LA112](https://openairdocs.org/ntsb/FTW88LA112.md): Piper PA-28-140 · Denton, TX · Accident · Serious injuries · Limited investigation · Final report · May 29, 1988 · N98088 · Destroyed
  > The instructor was simulating an engine-out emergency for the dual student. The student was making an approach to an emergency field with a line of trees on the approach end. When the instructor became aware that they might not reach the field, he directed…
- [NTSB MKC88LA101](https://openairdocs.org/ntsb/MKC88LA101.md): Cessna 152 · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · May 28, 1988 · N89443 · Substantial damage
  > Following a landing apch at the end of a student solo cross country flight, a full flap go around was attempted. Witnesses said the acft was higher than normal, and after passing over more than one half of the usable runway, the pilot initiated a go around.…
- [NTSB MIA88LA180](https://openairdocs.org/ntsb/MIA88LA180.md): Cessna 182A · Williston, FL · Accident · Minor injuries · Limited investigation · Final report · May 28, 1988 · N4057D · Substantial damage
  > The plt dropped off parachutists at 8,500 ft and began to descend back to arpt. The a/c was descending at 145 mph, 19 inches mp, and 2300 RPM in a long circular pattern. The flt was on final between 500 and 1000 ft MSL when the plt tried to apply pwr. The eng…
- [NTSB DEN88FA114](https://openairdocs.org/ntsb/DEN88FA114.md): Beech D-17S · Wheatland, WY · Accident · 2 fatal · Field investigation · Final report · May 28, 1988 · N1038M · Destroyed
  > The witnesses said they saw the acft fly a pattern indicative of a base to final approach to rwy 35. The airstrip has a second runway oriented east and west. The wind was blowing from the east at 20 knots. The acft wreckage was found approximately 3/4 miles…
- [NTSB LAX88LA199](https://openairdocs.org/ntsb/LAX88LA199.md): Piper PA-32-300 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · May 27, 1988 · N30289 · Substantial damage
  > While on final approach, the acft began to drift to the left. The plt applied rudder control, however, the acft continued to drift off centerline. The plt initiated a go-around; however, during the climb, the landing gear caught on the arpt boundary fence.…
- [NTSB LAX88LA195](https://openairdocs.org/ntsb/LAX88LA195.md): Cessna 182N · Prescott, AZ · Accident · Serious injuries · Limited investigation · Final report · May 26, 1988 · N8918G · Substantial damage
  > At the end of a cross country flight, while on final approach, the pilot reported that a sudden wind gust brought the nose up and the aircraft drifted right. Before the pilot could correct the situation, the aircraft stalled. The aircraft dropped to the…
- [NTSB MIA88FA179](https://openairdocs.org/ntsb/MIA88FA179.md): Cessna 172K · Lake City, FL · Accident · 1 fatal · Field investigation · Final report · May 25, 1988 · N736VS · Destroyed
  > The acft, while on a local flight, struck a telephone transmission line on the approach end of runway 1. Witnesses stated that they saw the acft takeoff to the west and make a right turn and go out of sight. Aprx three to five minutes later, they heard the…
- [NTSB MKC88LA096](https://openairdocs.org/ntsb/MKC88LA096.md): Mccurry Taylor Monoplane · Marshalltown, IA · Accident · No injuries · Limited investigation · Final report · May 24, 1988 · N4256B · Substantial damage
  > The pilot stated that he had intentionally shut down the engine-- so as to attempt a power off 'deadstick' landing. As he was descending, the pilot changed his plans and decided to restart the engine--but the engine would not start. While attempting the…
- [NTSB FTW88FA110](https://openairdocs.org/ntsb/FTW88FA110.md): Cessna 320-F · San Angelo, TX · Accident · Serious injuries · Field investigation · Final report · May 24, 1988 · N73AT · Substantial damage
  > Drg fam flt, CFI noted fuel quantity low with selectors on aux fuel tanks. Drg arc to ILS apch, CFI allowed the rt eng to fail due to fuel starvation. CFI selected main tks and obtained restart. Apch was cont to a touch and go lndg performed by the ATP plt…
- [NTSB NYC88LA145](https://openairdocs.org/ntsb/NYC88LA145.md): Taylorcraft BC-12D · Brookhaven, NY · Accident · No injuries · Limited investigation · Final report · May 21, 1988 · N96193 · Substantial damage
  > Loss of power due to carburetor ice during an attempted go around. Pilot landed in scrub pines and airplane nosed over.
- [NTSB MIA88LA174](https://openairdocs.org/ntsb/MIA88LA174.md): Luscombe 8A · Geneva, FL · Accident · Minor injuries · Limited investigation · Final report · May 21, 1988 · N45980 · Substantial damage
  > The pilot state that he encountered turbulence over a tree line while on short final approach. The aircraft began to sink and before the sink rate could be arrested the aircraft struck a tree. The aircraft touched down short of the runway.
- [NTSB LAX88LA191](https://openairdocs.org/ntsb/LAX88LA191.md): Beech G-35 · Bullhead City, AZ · Accident · Serious injuries · Limited investigation · Final report · May 19, 1988 · N4472D · Substantial damage
- [NTSB ANC88LA060](https://openairdocs.org/ntsb/ANC88LA060.md): Cessna 175B · Asigiyukpak, AK · Accident · Minor injuries · Limited investigation · Final report · May 18, 1988 · N32CP · Substantial damage
  > During the approach to the beach area the pilot stalled the aircraft. The aircraft nosed over on its back during the landing.
- [NTSB MKC88LA090](https://openairdocs.org/ntsb/MKC88LA090.md): Great Lakes 2T1A2 · Horton, KS · Accident · No injuries · Limited investigation · Final report · May 17, 1988 · N3502L · Substantial damage
  > The PIC was executing touch and go lndgs when he reportedly experienced a shift in wind conditions. The acft impacted the ground short of the rwy. He said that the wings suddenly lost lift resulting in a high descent rate. The PIC reported no mechanical flt…
- [NTSB MKC88FA089](https://openairdocs.org/ntsb/MKC88FA089.md): Aero Commander 690A · Little Rock, AR · Accident · 1 fatal · Field investigation · Final report · May 17, 1988 · N660RB · Destroyed
  > The plt had just rtrnd fm vacation in the Bahamas bfr starting a flt fm Little Rock to atlanta with an intermediate stopat memphis. This itinerary was flwd by a rtrn flt to Little Rock via a reverse routing. Witnesses rprtd the plt said he had only 2 hrs of…
- [NTSB DEN88FA109](https://openairdocs.org/ntsb/DEN88FA109.md): Cessna T210N · Albuquerque, NM · Accident · 5 fatal · Field investigation · Final report · May 17, 1988 · N5402Y · Destroyed
- [NTSB ANC88FA057](https://openairdocs.org/ntsb/ANC88FA057.md): Piper PA-18 · Wasilla, AK · Accident · Serious injuries · Field investigation · Final report · May 17, 1988 · N7224K · Substantial damage
  > The private pilot and passenger were making an approach to the Wasilla airport, Wasilla, AK, when the engine lost power. The pilot made a sharp 180 degree turn to try and reach a paved street about 3/4 of a mile short of the runway. The airplane stalled and…
- [NTSB LAX88LA184](https://openairdocs.org/ntsb/LAX88LA184.md): Grumman American AA-1B · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · May 15, 1988 · N9601L · Substantial damage
  > During a post maintenance test flight prior to sign off of an annual inspection, the engine quit and the pilot performed a forced landing in a mud field colliding with a dike. Examination of the engine revealed that a fuel pressure line had disconnected from…
- [NTSB SEA88FA095](https://openairdocs.org/ntsb/SEA88FA095.md): Cessna 172L · Ocean Shores, WA · Accident · 1 fatal · Field investigation · Final report · May 14, 1988 · N7935G · Destroyed
  > The student pilot departed on his fifth solo flight from the airport where he had been accustomed to originating his instructional flights. After several touch and go landings he proceeded to a nearby airport and conducted at least one more touch and go.…
- [NTSB SEA88LA093](https://openairdocs.org/ntsb/SEA88LA093.md): Hughes 269C · Prineville, OR · Accident · Minor injuries · Limited investigation · Final report · May 12, 1988 · N751AM · Substantial damage
  > The pilot reduced power for landing and a high sink rate developed. The pilot attempted to increase power to correct the sink rate but got no response. Rotor rpm's were diminishing, so the plt lowered the collective to regain rpm's. the pilot elected make an…
- [NTSB MKC88LA088](https://openairdocs.org/ntsb/MKC88LA088.md): Cessna 172 · Concordia, KS · Accident · Minor injuries · Limited investigation · Final report · May 12, 1988 · N8240B · Substantial damage
  > While attempting a crosswind landing, PIC decided to make a go-around. During the go-around the acft stalled, struck the terrain and cartwheeled.
- [NTSB CHI88LA113](https://openairdocs.org/ntsb/CHI88LA113.md): Cessna 152 · Nauvoo, IL · Accident · Serious injuries · Limited investigation · Final report · May 12, 1988 · N757ZY · Destroyed
  > The pilot was making a 'fast low approach' to a private airstrip near his home when he realized he was coming too close to a row of trees. The pilot stated he became so preoccupied with trying not to hit the trees that he did not notice how close the aircraft…
- [NTSB MIA88IA168](https://openairdocs.org/ntsb/MIA88IA168.md): Piper PA-42-720 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · May 11, 1988 · N900MP · 2 aircraft · No damage
  > Condor flt 610 (Mcdonnell Douglas DC-10, german registration: dadso) was aprx 2 hrs late as the flt crew members were preparing to takeoff. Subsequently, flt 610 was clrd for takeoff with instructions to cross the 5 DME (on the standard instrument…
- [NTSB MIA88IA167](https://openairdocs.org/ntsb/MIA88IA167.md): Beech 200 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · May 10, 1988 · N981LL · 2 aircraft · No damage
  > Midway flt 172 (Mcdonnell Douglas DC-9, N1065T) was on an IFR departure from Chicago midway arpt at the same time that Beech 200, N981LL, was on an IFR arrival for a visual apch to merrill c meigs arpt, although both were in VMC. Previously, o'hare TRACON had…
- [NTSB CHI88FA110](https://openairdocs.org/ntsb/CHI88FA110.md): Boeing 747-136 · Chicago, IL · Accident · No injuries · Field investigation · Final report · May 9, 1988 · GAWND · Substantial damage
  > Failure of the number three flap track due to stress corrosion cracking. Factors contributing to this failure are insufficient design of the member and inadequate inspection and maintenance procedures to detect cracks before they propagate to a critical…
- [NTSB NYC88LA136](https://openairdocs.org/ntsb/NYC88LA136.md): Beech A23-24 · Lyons, NY · Accident · Serious injuries · Limited investigation · Final report · May 8, 1988 · N7982L · Destroyed
  > Pilot failed to maintain airspeed during his go around.
- [NTSB NYC88LA137](https://openairdocs.org/ntsb/NYC88LA137.md): Piper PA-24-250 · Blairstown, NJ · Accident · No injuries · Limited investigation · Final report · May 7, 1988 · N6762P · Substantial damage
  > The flight was on final for runway 7 following another airplane, when the pilot's attention was drawn to a glider maneuvering in the area. He yielded left to maintain a comfortable distance from the glider and failed to observe an antenna tower in his path.…
- [NTSB SEA88LA088](https://openairdocs.org/ntsb/SEA88LA088.md): Cessna 172M · Hood River, OR · Accident · No injuries · Limited investigation · Final report · May 6, 1988 · N12659 · Substantial damage
  > Plt had diverted back along course to land because of observed wx ahead. On late final, a strong wind gust tipped the acft to near wings-vertical attitude. Plt managed to correct to wings level but could not control altitude loss before ground contact. Plt…
- [NTSB MKC88LA087](https://openairdocs.org/ntsb/MKC88LA087.md): Grumman G-164B · Waldenburg, AR · Accident · No injuries · Limited investigation · Final report · May 6, 1988 · N6782K · Substantial damage
  > The acft was being positioned for an aerial application operation. While landing, the acft struck a 1.5 ft levee at the end of the private grass strip. Subsequently, the main gear sheared off, the wings were buckled & the prop was damaged.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
