# NTSB investigations: Enroute

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 302 of 718 · 35,885 cases

## Cases, newest first

- [NTSB NYC88IA112](https://openairdocs.org/ntsb/NYC88IA112.md): Boeing 757 · Providence, RI · Incident · No injuries · Incident investigation · Final report · Mar 22, 1988 · N628DL · No damage
  > The Boeing 757 was climbing through 20000 ft with the first officer on the flight controls when the 55 year old captain became incapacitated. The first officer delcared an emergency and made a normal landing. When clear of the runway, the aircraft was stopped…
- [NTSB SEA88IA065](https://openairdocs.org/ntsb/SEA88IA065.md): Boeing 727-232 · Portland, OR · Incident · No injuries · Incident investigation · Final report · Mar 21, 1988 · N515DA · Minor damage
  > Crew was unable to lower the left main lndg gear. Crew then executed an emergency landing on the right main and nose gear with minor damage to the acft. The investigation revealed that the left main gear door attach fitting had a fatigue fracture.
- [NTSB BFO88FA026](https://openairdocs.org/ntsb/BFO88FA026.md): Cessna 210N · Quantico, VA · Accident · 3 fatal · Field investigation · Final report · Mar 20, 1988 · N6401N · Destroyed
  > The acft was abt 25 mi south & inbound to dca when the plt rprtd an enctr with snowshwrs which were part of a cold front. He asked & was clrd to dscnd to 2500 ft so he could maint VMC. Radar data showed, the acft dscndd past 2500 ft to 1300 ft. abt 16 mi…
- [NTSB SEA88LA062](https://openairdocs.org/ntsb/SEA88LA062.md): Aeronca 7AC · Umpqua, OR · Accident · Serious injuries · Limited investigation · Final report · Mar 19, 1988 · N81788 · Destroyed
  > While flying low over a river the aircraft struck unmarked telephone wires. An off-airport landing was made onto a cow pasture. During the landing the aircraft struck the ground nose first. Post acc inspection revealed telephone wire insulation wedged near…
- [NTSB NYC88IA109](https://openairdocs.org/ntsb/NYC88IA109.md): Boeing 737 · Morristown, NJ · Incident · No injuries · Incident investigation · Final report · Mar 19, 1988 · N69348 · 2 aircraft · No damage
  > Boeing 737 (N69348) was depg newark intl arpt as a lear jet 24 (N500NH) was depg fm teterboro. Both were being ctld by new york TRACON (newark sector). The strip for the 737 was mismarked as a north departure rather than an east departure. The instructor/full…
- [NTSB SEA88LA059](https://openairdocs.org/ntsb/SEA88LA059.md): Beech A24R · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Mar 18, 1988 · N8307R · Substantial damage
  > During climb to cruise the aircraft's door opened. The pilot then diverted to a nearby airport for a precautionary landing. During landing the pilot had difficulty maintaining directional control. The aircraft struck a runway edge light during landing roll…
- [NTSB CHI88DEE03](https://openairdocs.org/ntsb/CHI88DEE03.md): Piper PA-22-150 · West Chicago, IL · Accident · No injuries · Final report · Mar 18, 1988 · N2758P · Substantial damage
  > The plt rprtd that just after leveling off, the eng started to sputter. He initiated emergency procedures, but was unable to restore power. During an emergency landing at dusk, the acft hit a ditch & nosed over. An investigation revealed the #3 exhaust valve…
- [NTSB LAX88FA129](https://openairdocs.org/ntsb/LAX88FA129.md): Beech V35B · Oildale, CA · Accident · 1 fatal · Field investigation · Final report · Mar 17, 1988 · N4103A · Destroyed
  > Improper maintenance given by the fixed based operator.
- [NTSB DEN88IA083](https://openairdocs.org/ntsb/DEN88IA083.md): Cessna 210 · Billings, MT · Incident · No injuries · Incident investigation · Final report · Mar 17, 1988 · N2180S · Minor damage
- [NTSB MKC88LA062](https://openairdocs.org/ntsb/MKC88LA062.md): Grumman G-164B · West Point, AR · Accident · No injuries · Limited investigation · Final report · Mar 15, 1988 · N6750Q · Substantial damage
  > The pilot said, shortly after takeoff, enroute to an aerial application operation, the engine began to lose pwr and began backfiring. He dumped a portion of his load, and made an emergency ldg in a soft, unplanted bean field. After rolling about 200 feet, the…
- [NTSB LAX88LA128](https://openairdocs.org/ntsb/LAX88LA128.md): Cessna 150M · Lodi, CA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1988 · N714FJ · Substantial damage
  > On the day of the accident, the pilot departed lancaster, California, flew to fresno to pick up a passenger and then continued on to Lodi, the ultimate destination. While being vectored toward the airport at Lodi, the engine quit and the aircraft collided…
- [NTSB MIA88LA126](https://openairdocs.org/ntsb/MIA88LA126.md): Piper PA-22-108 · Dorado, PR · Accident · No injuries · Limited investigation · Final report · Mar 14, 1988 · N5611Z · Substantial damage
  > While on a personal flt in normal cruise at an alt of 1000 ft aprx 2 miles southeast of the arpt, the eng began to misfire and the cabin filled with smoke. The plt elected to land in a clearing. The plt also stated that the eng was losing pwr and tht a/c…
- [NTSB LAX88DVA02](https://openairdocs.org/ntsb/LAX88DVA02.md): Bell UH-1B · Arvin, CA · Accident · Minor injuries · Final report · Mar 14, 1988 · N59368 · Destroyed
- [NTSB LAX88LA125](https://openairdocs.org/ntsb/LAX88LA125.md): Piper PA28R-201T · Bullhead City, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 13, 1988 · N694ME · Substantial damage
  > Shortly after takeoff, the engine failed. During the forced landing the aircraft ran into a rock quarry. Inspection of the engine revealed that the fuel injector lines were loose and that one line had separated.
- [NTSB DEN88DQA03](https://openairdocs.org/ntsb/DEN88DQA03.md): Surline Sidewinder · Moriarty, NM · Accident · 2 fatal · Final report · Mar 12, 1988 · N185SA · Destroyed
  > Witnesses heard the acft eng sound increase dramatically as the acft passed over a gen aviation airport. The acft was seen by another witness at low atl, estimated to be about 200 ft, as the nose pitched up. The acft then entered a spin and impacted the…
- [NTSB ATL88FA110](https://openairdocs.org/ntsb/ATL88FA110.md): Piper PA-32R-300 · Rock Hill, SC · Accident · Serious injuries · Field investigation · Final report · Mar 12, 1988 · N8727E · Destroyed
  > The plt and a certificated pilot/pax departed the Rock Hill apt for a local maint test flt following an engine overhaul and installation. About 10 minutes into the flt, the engine oil pressure dropped to zero and a complete loss of power followed. The plt…
- [NTSB ATL88FA109](https://openairdocs.org/ntsb/ATL88FA109.md): Cessna 150 · Sylva, NC · Accident · 2 fatal · Field investigation · Final report · Mar 11, 1988 · N1258Q · Destroyed
  > The pilot was conducting a local pleasure flight when the airplane was seen in the boxed canyon maneuvering. The witness said that the pilot was getting lower on each pass, until the airplane was about 300 feet above the ground when the airplane went into a…
- [NTSB LAX88LA123](https://openairdocs.org/ntsb/LAX88LA123.md): Helio HT-295 · Oracle, AZ · Accident · No injuries · Limited investigation · Final report · Mar 10, 1988 · N68871 · Destroyed
  > Engine failure for undetermined reasons.
- [NTSB ANC88FA037](https://openairdocs.org/ntsb/ANC88FA037.md): Beech B35 · Nome, AK · Accident · 1 fatal · Field investigation · Final report · Mar 10, 1988 · N5115C · Destroyed
  > The aircraft sustained an in-flight breakup during the enroute phase of the flight. The left fitting that secures the front spars of the stabilizers to the fuselage revealed the presence of pre-existing fatigue cracking. The initial separation of the left…
- [NTSB DEN88LA082](https://openairdocs.org/ntsb/DEN88LA082.md): Cessna 152 · Fort Collins, CO · Accident · No injuries · Limited investigation · Final report · Mar 9, 1988 · N47567 · Substantial damage
  > The private plt was performing a night solo training flight in the local area. After several stop and go landings, the plt was returning to her home airport. At 6300FT MSL, in cruise flight, the plt reported that the engine quit. Attempts to restart were not…
- [NTSB NYC88DGT01](https://openairdocs.org/ntsb/NYC88DGT01.md): North American F-51D · State College, PA · Accident · 1 fatal · Final report · Mar 7, 1988 · N51WE · Destroyed
  > N51WE, a North American F-51D took off as the second ship of a two ship flight with N6341T, another F-51D. They were observed climbing in formation into the clouds. N6341T assumed communications and said they were a flight of 2 and ok, after ATC was unable to…
- [NTSB ATL88LA114](https://openairdocs.org/ntsb/ATL88LA114.md): Piper PA-18-150 · Orangeburg, SC · Accident · No injuries · Limited investigation · Final report · Mar 7, 1988 · N8994Y · Substantial damage
  > The engine lost pwr as the airplane was returning from a fire-patrol flt. The plt made a forced ldg in a field where the airplane ran into soft dirt and nosed over. Post-crash exam of the acft revealed no evidence of any fuel ramaining in the fuel system. The…
- [NTSB MKC88LA060](https://openairdocs.org/ntsb/MKC88LA060.md): Piper PA-32-260 · Mound City, MO · Accident · No injuries · Limited investigation · Final report · Mar 6, 1988 · N7703J · Substantial damage
  > The PIC, after an earlier lndg at tarkio, Missouri and an unsuccessful attempt to reach his fishing partner, flew his acft to and landed at st. joseph rosecrans arpt. After contacting his friend, and catching a few hours of sleep, the PIC made an early…
- [NTSB FTW88FA077](https://openairdocs.org/ntsb/FTW88FA077.md): Fairchild M-62C · Arlington, TX · Accident · Minor injuries · Field investigation · Final report · Mar 6, 1988 · N63739 · Substantial damage
  > Failure of the number six cylinder and piston.
- [NTSB ATL88FA104](https://openairdocs.org/ntsb/ATL88FA104.md): Beech A36 · Bow, KY · Accident · 2 fatal · Field investigation · Final report · Mar 5, 1988 · N2929R · Destroyed
  > The pilot had received two weather briefings. In both, he was advised of forecast and known icing conditions. The pilot reported ice build-up to ATC. Afterward he requested no further assistance from ATC to locate a suitable landing area. Wreckage examination…
- [NTSB MKC88FA059](https://openairdocs.org/ntsb/MKC88FA059.md): Beech E18S · Vienna, MO · Accident · 2 fatal · Field investigation · Final report · Mar 4, 1988 · N45A · Destroyed
  > The plt rcvd a wx briefing bfr starting a ngt cargo opn in known icing conds. Bfr the flt, a line serviceman noticed ice on the acft's wings & suggested its removal, but the plt declined. Aprx 45 min after tkof, the plt rprtd to ARTCC that a de-ice boot had…
- [NTSB LAX88LA120](https://openairdocs.org/ntsb/LAX88LA120.md): Piper PA-28-236 · Hesperia, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1988 · N2184U · Substantial damage
- [NTSB ATL88LA100](https://openairdocs.org/ntsb/ATL88LA100.md): Cessna 182P · Norwalk, OH · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 1988 · N84118 · Substantial damage
  > The plt rptd that he was cruising at 9,000 ft when he observed the EGT gauge indication dropping. The engine began to run rough and he noticed a fuel odor in the cabin. The carb air temp gauge was indicating 'well out of' the icing range. He selected carb…
- [NTSB FTW88LA076](https://openairdocs.org/ntsb/FTW88LA076.md): Piper PA-24-400 · Midland, TX · Accident · No injuries · Limited investigation · Final report · Mar 3, 1988 · N8496P · Substantial damage
  > Encounter with severe turbulence within tops of convective clouds. Leading to this was the pilot's failure to properly evaluate the potential danger of the convective activity, which he chose to penetrate.
- [NTSB ATL88IA102](https://openairdocs.org/ntsb/ATL88IA102.md): Government Aircraft Fact Nomad N22B · Birmingham, AL · Incident · No injuries · Incident investigation · Final report · Mar 3, 1988 · N422NE · Minor damage
- [NTSB ANC88LA034](https://openairdocs.org/ntsb/ANC88LA034.md): Cessna A185E · Mcgrath, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1988 · N1954U · Substantial damage
  > The pilot had begun his descent for his destination airport 20 miles away when the engine lost all power. He was unable to restart the engine, and made a forced landing in deep snow. The pilot reported that he had been airborne for approximately two hours…
- [NTSB SEA88FA054](https://openairdocs.org/ntsb/SEA88FA054.md): Cessna T210N · Burns, OR · Accident · Minor injuries · Field investigation · Final report · Mar 2, 1988 · N5427A · Destroyed
  > The aircraft engine quit during cruise flt on a bright moonlit night cross country flt at 8000 ft AGL, 28 NM west of Burns, OR. The pilot reversed course in an emergency descent and followed a straight 50 ft wide hwy toward Burns. At approx 500 ft. AGL the…
- [NTSB NYC88LA100](https://openairdocs.org/ntsb/NYC88LA100.md): Piper PA-28-180 · Maybrook, NY · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 1988 · N16255 · Substantial damage
  > The Piper PA-28 took off for a local pleasure flight. After takeoff the pilot noticed that the engine was running rough and he had lost his oil pressure. The engine seized and an off-airport landing was made in a snow covered field. Post-crash examination of…
- [NTSB ATL88DMG03](https://openairdocs.org/ntsb/ATL88DMG03.md): Thorp T-18 · Advance, NC · Accident · Minor injuries · Final report · Mar 1, 1988 · N1369 · Substantial damage
- [NTSB FTW88IA078](https://openairdocs.org/ntsb/FTW88IA078.md): Cessna T210M · Grosebeck, TX · Incident · No injuries · Incident investigation · Final report · Feb 28, 1988 · N761RP · Minor damage
  > The pilot made a forced landing following engine failure. Teardown examination showed the no. 4 exhaust valve head had separated from the stem. Metal debris was found in the oil sump. The no. 1 connecting rod was separated from the crankshaft. There was…
- [NTSB FTW88FA072](https://openairdocs.org/ntsb/FTW88FA072.md): Cessna P206D · Eagle Lake, TX · Accident · Minor injuries · Field investigation · Final report · Feb 28, 1988 · N8721Z · Destroyed
  > An inflight fire erupted following the separation of the number 4 cylinder. A metallurgist determined that studs failed in fatigue. The aircraft continued to burn after the emergency landing and was completely destroyed. The acft had an annual inspection…
- [NTSB LAX88FA118](https://openairdocs.org/ntsb/LAX88FA118.md): Grumman AA-5B · Frazier Park, CA · Accident · 2 fatal · Field investigation · Final report · Feb 27, 1988 · N74236 · Destroyed
  > Improper maintenance performed previous to the accident flight which failed to identify a fault which rendered the airplane nonairworthy. Contributing to this accident was the pilot's exercise of poor judgement in disregarding weather forecasts indicating…
- [NTSB LAX88DVA01](https://openairdocs.org/ntsb/LAX88DVA01.md): Eagle DW-1 · Modesto, CA · Accident · Minor injuries · Final report · Feb 27, 1988 · N8801Y · Destroyed
  > While enroute for the purpose of spraying a field, the engine seemed to overspeed then lose power. The aircraft was landed on a soft field where during the landing roll, the aircraft nosed over. The propeller dome was found to have separated from the aircraft…
- [NTSB FTW88DRG07](https://openairdocs.org/ntsb/FTW88DRG07.md): Grumman G-164A · Alamo, TX · Accident · No injuries · Final report · Feb 26, 1988 · N4647 · Destroyed
  > The pilot experienced a total loss of engine power during climb when he made his initial power reduction. The power loss was accompanied by a loud bang. A severe postaccident ground fire melted a large portion of the engine. A partial engine teardown was…
- [NTSB MKC88LA055](https://openairdocs.org/ntsb/MKC88LA055.md): Carter Quickee 2 · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Feb 25, 1988 · N587TC · Substantial damage
  > While flying a homebuilt aircraft, under experimental category, the pilot experienced an engine failure. An emergency ldg was made on a highway, and during the ldg roll the acft struck some marker barrels, suffering substantial damage. The pilot said the…
- [NTSB LAX88LA116](https://openairdocs.org/ntsb/LAX88LA116.md): Beech F35 · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Feb 25, 1988 · N5041B · Substantial damage
  > The plt rprtd that he had initially psnd the fuel selector (sel) to the left main tank. He said that after abt 1 hr of flt (near palmdale, CA), he psnd the sel to the rgt main tank for a short time, then (near Pacoima), he moved it back to the left main tank.…
- [NTSB CHI88DEM01](https://openairdocs.org/ntsb/CHI88DEM01.md): North American T-28A · Schoolcraft, MI · Accident · Minor injuries · Final report · Feb 24, 1988 · N14142 · Substantial damage
  > While the pilot was climbing through 7800 MSL he noticed a vapor trail coming from the right exhaust area. The pilot notified approach control that he was returning to the departure airport and they supplied radar vectors. The pilot started a descent and…
- [NTSB FTW88LA070](https://openairdocs.org/ntsb/FTW88LA070.md): Piper PA-22-108 · Fabens, TX · Accident · No injuries · Limited investigation · Final report · Feb 23, 1988 · N5542Z · Substantial damage
  > The plt reported that the eng ran rough on a previous flt and he removed, cleaned, and replaced the spark plugs. He then took off and at a point seven miles from the departure arpt, the eng again began to run rough and intermittently. An emergency landing…
- [NTSB DEN88LA075](https://openairdocs.org/ntsb/DEN88LA075.md): Cessna 206G · Loveland, CO · Accident · No injuries · Limited investigation · Final report · Feb 22, 1988 · N756EY · Substantial damage
  > A commercial plt was flying a group of parachutists for a skydiving club. The aircraft encountered turbulence during a climb to 4,500 feet AGL. As the second jumper was exiting, the aircraft dropped and the parachutist struck the horizontal stabilizer. The…
- [NTSB FTW88LA068](https://openairdocs.org/ntsb/FTW88LA068.md): Piper PA-22-150 · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Feb 21, 1988 · N3524P · Substantial damage
  > The flt was cruising at 2,000 ft MSL when the eng lost pwr. The student plt changed fuel tanks and the engine regained pwr for about 20 sec then again lost pwr. During the forced landing the acft collided with a fence and nosed over. Examination of the eng by…
- [NTSB BFO88FA024](https://openairdocs.org/ntsb/BFO88FA024.md): Cessna 177RG · Ellamore, WV · Accident · 2 fatal · Field investigation · Final report · Feb 21, 1988 · N2109Q · Destroyed
  > Aprx 3 hrs and 26 minutes after takeoff from republic airport, the plt reported having engine problems. Unable to make it to an airport, the plt radioed that he was going to attempt to land on a road. The airplane struck trees and crashed in a wooded area…
- [NTSB DEN88LA080](https://openairdocs.org/ntsb/DEN88LA080.md): Cessna TU-206 · Durango, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 20, 1988 · N9848M · Substantial damage
  > While on a cross country flight the plt ran short of fuel and altered course to another airport. The pilot said the acft engine failed short of the new destination due to fuel exhaustion. The plt performed an emergency landing in an open field and the acft…
- [NTSB ATL88LA095](https://openairdocs.org/ntsb/ATL88LA095.md): Cessna 182RG · Jacksonville, AL · Accident · Serious injuries · Limited investigation · Final report · Feb 20, 1988 · N1703R · Substantial damage
  > The pilot had just purchased the aircraft and it had less than one hour on the overhauled engine. The pilot was at 1500 feet when the engine quit. On final approach to the emergency landing area, the aircraft collided with trees. The engine examination…
- [NTSB SEA88IA051](https://openairdocs.org/ntsb/SEA88IA051.md): Piper PA-31T · Las Vegas, NV · Incident · Minor injuries · Incident investigation · Final report · Feb 19, 1988 · N2645Z · Minor damage
  > While cruising at FL270, right side cockpit window failed, resulting in decompression. Acft diverted to normal landing. Examination revealed lower bolts overtorqued and plexiglas compromised by excess primer, initiating cracking. Evidence indicated window not…
- [NTSB MIA88LA109](https://openairdocs.org/ntsb/MIA88LA109.md): Piper PA-28-161 · Stuart, FL · Accident · 3 fatal · Limited investigation · Final report · Feb 19, 1988 · N43253 · Destroyed
  > Bfr depg at ngt with no flt plan, non-inst rated plt was adzd of psbl clds forming at a low lvl. En route, he got radar flt flwg. Apchg his destn, he got vctrs & alt chgs to avoid wx & otr acft. At 2001:04, radar svc was trmtd with palm bchapch ctl to cont…

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=303

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

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

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