# NTSB investigations: Other

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 4 of 5 · 212 cases

## Cases, newest first

- [NTSB FTW91LA119](https://openairdocs.org/ntsb/FTW91LA119.md): Rolladen-Schneider LS-6 · Boerne, TX · Accident · No injuries · Limited investigation · Final report · Jun 22, 1991 · N6MN · Substantial damage
  > The pilot's failure to release at a higher altitude prior to looking for thermal activity and the pilot's poor in-flight planning. Factors were the downdraft and the tall grass encountered during landing.
- [NTSB CHI91LA183](https://openairdocs.org/ntsb/CHI91LA183.md): Balloon Works FIREFLY-7B · Greenwood, MO · Accident · 1 fatal · Limited investigation · Final report · Jun 9, 1991 · N3605G · Minor damage
  > The inadequate briefing to the ground crew by the pilot, because the ground crewman did not understand the intent and objectives of the maneuver.
- [NTSB FTW91LA048](https://openairdocs.org/ntsb/FTW91LA048.md): Bell 206B II · High Island, TX · Accident · 1 fatal · Limited investigation · Final report · Mar 8, 1991 · N59491 · Substantial damage
  > For occurrence #1 - inadequate supervision by the operator in launching a hazardous mission without an adequate sling/harness, the pilot's poor judgement in accepting and continuing the mission into low light conditions, and the crewmember's inadvertent…
- [NTSB CHI91DEM03](https://openairdocs.org/ntsb/CHI91DEM03.md): Huddleston/Becktold Glasair · Lansing, MI · Accident · No injuries · Final report · Feb 11, 1991 · N270KT · Substantial damage
  > Failure of the instructor pilot (CFI) to maintain sufficient airspeed on final approach to flare the aircraft for landing. Factors related to the accident were: the landing gear malfunction, and the cfi's improperly planned approach.
- [NTSB SEA91LA033](https://openairdocs.org/ntsb/SEA91LA033.md): Erco 415-C · Ola, ID · Accident · 1 fatal · Limited investigation · Final report · Dec 8, 1990 · N3522H · Destroyed
  > The pilot's failure to maintain sufficient altitude for terrain clearance. Also causal was the pilot's impairment due to alcohol. Contributing factors were the night light condition and the hilly terrain.
- [NTSB LAX90FA336](https://openairdocs.org/ntsb/LAX90FA336.md): Lockheed PV-2 · Lakeport, CA · Accident · 8 fatal · Field investigation · Final report · Sep 29, 1990 · N7250C · Destroyed
  > The pilot-in-command's failure to maintain airspeed during a pull-up from a low pass. Factors which contributed to the accident were: the pilot's poor judgement in buzzing the seaplanes which resulted in insufficient altitude to recover from the stall, and…
- [NTSB ANC90LA170](https://openairdocs.org/ntsb/ANC90LA170.md): Bell 206B · Kokhanok, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 9, 1990 · N385EH · Substantial damage
  > The failure of the compressor end of the air compressor scroll to tee tube assembly causing the engine to spool down. The forced landing in eneven, unprepared, and lightly forested terrain were factors.
- [NTSB CHI90DEP09](https://openairdocs.org/ntsb/CHI90DEP09.md): Cessna 182 · Columbus, WI · Accident · Serious injuries · Final report · Aug 18, 1990 · N20824 · Substantial damage
  > The skydiver's panic and failure to depart the aircraft as instructed. Contributing was the skydiver's lack of total experience in this type of operation.
- [NTSB ANC90LA074](https://openairdocs.org/ntsb/ANC90LA074.md): Cessna 150 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · May 23, 1990 · N66425 · Substantial damage
  > The flight instructor's failure to use carburetor heat during a simulated engine failure. The rough terrain and weather conditions conducive to carburetor icing were contributing factors.
- [NTSB CHI90FA117](https://openairdocs.org/ntsb/CHI90FA117.md): Bellanca 8KCAB · West Bend, WI · Accident · 2 fatal · Field investigation · Final report · Apr 24, 1990 · N2976R · Destroyed
  > Inflight failure of the right wing strut-to-spar attachment fitting due to fatigue initiated by improper welding techniques involving inadequate post-weld cooling control.
- [NTSB LAX90DUG04](https://openairdocs.org/ntsb/LAX90DUG04.md): Weber Christen Eagle II · Bermuda Dunes, CA · Accident · 2 fatal · Final report · Mar 18, 1990 · N234RW · Destroyed
  > The pilot-in-command's improper use of the flight controls while performing acrobatic maneuvers.
- [NTSB SEA90LA032](https://openairdocs.org/ntsb/SEA90LA032.md): Balloon Works Firefly 7 · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1989 · N4070W · 2 aircraft · Substantial damage
  > The pilot of the raven RX7, N5710Y, failed to maintain adequate control to avoid a collision with the firefly 7, N4070W, and both pilots did not maintain adequate clearance from each other during the practice maneuver.
- [NTSB BFO90FA002](https://openairdocs.org/ntsb/BFO90FA002.md): Beech 58P · Nokesville, VA · Accident · 1 fatal · Field investigation · Final report · Oct 26, 1989 · N86MC · Destroyed
  > Improper installation of the elevator trim actuators, and subsequent jamming of the elevator trim in a nose down trim position.
- [NTSB DEN89FA184](https://openairdocs.org/ntsb/DEN89FA184.md): Cessna 172M · Albuquerque, NM · Accident · 1 fatal · Field investigation · Final report · Aug 6, 1989 · N64263 · Destroyed
  > The pilot deliberately flew his aircraft into the face of a mountain. A contributing factor was: the psychological condition of the pilot.
- [NTSB LAX89LA335](https://openairdocs.org/ntsb/LAX89LA335.md): Luscombe 8A · Napa, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 10, 1989 · N77969 · Destroyed
  > Suicide.
- [NTSB FTW89DPJ07](https://openairdocs.org/ntsb/FTW89DPJ07.md): Beech T-34 · Haskell, OK · Accident · 2 fatal · Final report · Jun 24, 1989 · N34CJ · Destroyed
  > Failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall. Factors related to the accident were: a leak in the pitot system, failure of the pilot to obtain adequate maintenance/inspection of the pitot system, and his lack of…
- [NTSB FTW88DQG03](https://openairdocs.org/ntsb/FTW88DQG03.md): Beech G35 · Friona, TX · Accident · No injuries · Final report · Jan 26, 1988 · N313B · Substantial damage
  > After touchdown on the landing strip, the left landing gear collapsed, and the airplane went off the left side of the strip. The airplane went into a water pit, and struck a pump station and associated equipment. Later the pilot stated to his son that he had…
- [NTSB LAX88LA043](https://openairdocs.org/ntsb/LAX88LA043.md): Hughes 369D · Honolulu, HI · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N1113L · Substantial damage
  > The plt rprtd that during an external load operation, the helicopter ran out of fuel. Subsequently, it was damaged when it touched down hard during a forced landing.
- [NTSB NYC88LA006](https://openairdocs.org/ntsb/NYC88LA006.md): Cessna 150 · Croghan, NY · Accident · No injuries · Limited investigation · Final report · Oct 13, 1987 · N3497J · Substantial damage
  > The pvt plt & one passenger became disoriented while they were on a x-country pleasure flt. The plt was unable to contact any communication center, so she landed in a field & obtained info to get her bearings. She took off again using short/soft field…
- [NTSB SEA87LA188](https://openairdocs.org/ntsb/SEA87LA188.md): Mercer OWL Racer 65-2 · Reno, NV · Accident · 1 fatal · Limited investigation · Final report · Sep 15, 1987 · N5JG · Destroyed
  > Drg a practice flt in a formula one racer bfr the Reno air races, the eng lost pwr after 4 laps when the acft was at an alt of about 40' AGL. The plt maneuvered to lnd on a rwy in winds that were variable & gusty. A witness rprtd the plt made an abrupt left…
- [NTSB FTW87DRG06](https://openairdocs.org/ntsb/FTW87DRG06.md): William M. Burge Tern · Refugio, TX · Accident · Minor injuries · Final report · Aug 8, 1987 · N38826 · Substantial damage
  > On August 8, 1987, a burge tern, N38826 impacted a transmission wire and subsequently, the terrain while attempting a forced landing to a field approximately 7 miles west of Refugio, Texas. The homebuilt glider had flown approximately 18 miles northwest of…
- [NTSB LAX87LA013](https://openairdocs.org/ntsb/LAX87LA013.md): Piper PA-30 · Oceanside, CA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1986 · N7982Y · Destroyed
  > During a x-country flt, the plt stated, that just south of los angeles international arpt, the acft's right engine was running rough. At the same time pwr in the left engine began decreasing, then the prop automatically feathered. The plt attempted a re-start…
- [NTSB LAX86LA357](https://openairdocs.org/ntsb/LAX86LA357.md): Cessna 210N · Douglas, AZ · Accident · No injuries · Limited investigation · Final report · Sep 26, 1986 · N5340U · Substantial damage
  > The acft was found abandoned 25 miles west of Douglas, Arizona. A landing was made on a dirt road where the acft contacted a ditch and nosed over. The acft was reported stolen and the plt was not located. According to the local sheriff's office, traces of…
- [NTSB CHI86LA228](https://openairdocs.org/ntsb/CHI86LA228.md): Piper PA-31-310 · St. Paul, MN · Accident · No injuries · Limited investigation · Final report · Sep 18, 1986 · N707HB · Substantial damage
  > At the end of an uneventful flight the pilot lowered the landing gear and noted three gear down indicator lights. Upon landing rollout the nose gear collapsed. An inspection following the accident revealed that a hydraulic leak was present near the hydraulic…
- [NTSB ATL86LA254](https://openairdocs.org/ntsb/ATL86LA254.md): Piper PA-25 · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Aug 27, 1986 · N9101D · Destroyed
  > The acft was about 1/2 hrs into a planned 2.0 hr banner tow flt. On the last pass along the Beach, at about 500 ft AGL, the eng popped and lost pwr. The plt turned the acft out to sea and landed in the ocean. The plt swam to shore and the acft sank.
- [NTSB ANC86LA062](https://openairdocs.org/ntsb/ANC86LA062.md): Lake LA-4-200 · Lake Clark, AK · Accident · 3 fatal · Limited investigation · Final report · May 24, 1986 · N6190V · Destroyed
  > The aircraft crashed in Lake Clark, Alaska, and sank into 170 feet of water. There were no witnesses to the accident; the aircraft was not recovered.
- [NTSB LAX86FA183](https://openairdocs.org/ntsb/LAX86FA183.md): Cessna 150B · Bermuda Dunes, CA · Accident · 1 fatal · Field investigation · Final report · Apr 21, 1986 · N1118Y · Destroyed
  > The purpose of the research & development flight was to document through the use of videotape the deployment & trajectory of a speciality parachute which was connected to a ballast bag. The plt, who was the designer of the device, utilized his experimental…
- [NTSB ATL86FA066](https://openairdocs.org/ntsb/ATL86FA066.md): Cessna 152 · Lexington, NC · Accident · 2 fatal · Field investigation · Final report · Jan 30, 1986 · N25277 · Substantial damage
  > The plt/mechanic had completed a top overhaul on the acft eng and was believed to have been conducting a night maintenance flight when the accident occurred. The acft impacted the ground in a near vertical attitude in a wooded areaaprx one mile from the…
- [NTSB DEN86LA068](https://openairdocs.org/ntsb/DEN86LA068.md): Cameron 0-77 · Rio Rancho, NM · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1986 · N3SB · Substantial damage
  > The plt stated that during the inflation of his balloon, the safety line holding the basket to his support vehicle broke during windy conditions. According to the plt, he tried to inflate the envelope in order to climb above buildings nearby. The plt…
- [NTSB SEA86FA034](https://openairdocs.org/ntsb/SEA86FA034.md): Stinson 108 · Hoquiam, WA · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1985 · N40199 · Destroyed
  > The acft contacted terrain 680 ft north of rwy 06 at bowerman airfield. The acft departed elma arpt, ocean shores, WA, sometime around 2330 PST, on 12-29-85. Prior to the departure the passenger stated to persons they were waiting for the fog to clear for…
- [NTSB BFO86LA007](https://openairdocs.org/ntsb/BFO86LA007.md): Robinson R-22 · Manassas, VA · Accident · No injuries · Limited investigation · Final report · Nov 29, 1985 · N8499B · Substantial damage
  > A simulated straight in autorotation to runway 34L was entered from final approach by lowering the collective, and a pwrrecovery was planned at the bottom of the autorotation. At about 150 feet AGL, the throttle was rolled in to match the engine and rotor…
- [NTSB ANC85LA177](https://openairdocs.org/ntsb/ANC85LA177.md): Cessna A185F · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N80124 · Substantial damage
  > The plt stated that prior to landing, the acft's right brake had no pressure. He reported that after he landed, the tail wheel began to shimmy & the acft pulled to the left. He applied full right rudder, but was unable to prevent the acft from ground looping…
- [NTSB LAX85LA353](https://openairdocs.org/ntsb/LAX85LA353.md): Mike Stone Moni · Byron, CA · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N97MS · Destroyed
  > While on the initial test flt, the amatuer-built r. m. stone moni acft crashed near Byron, CA. The plt reported that during the flight the acft began to 'flutter', followed by separation of the canopy. Shortly thereafter the acft entered into an…
- [NTSB LAX84IA448](https://openairdocs.org/ntsb/LAX84IA448.md): Cessna 172 · Redding, CA · Incident · No injuries · Incident investigation · Final report · Aug 21, 1984 · N7360A · Minor damage
  > Plt briefed pax on use of brakes so he could hand prop acft. Plt stated, the acft 'got away from the passenger' when the engine started. Acft contacted a parked acft and a hangar before stopping.
- [NTSB ATL84LA258](https://openairdocs.org/ntsb/ATL84LA258.md): Bellanca 7KCAB · Virginia Beach, VA · Accident · No injuries · Limited investigation · Final report · Aug 16, 1984 · N1717C · Substantial damage
  > After a banner tow pick-up, rudder jammed full right. Plt applied both feet to left rudder pedal in attempt to control direction of flt. Left rudder cable then failed in overload as banner engaged power line and broke free. Directional control requirements on…
- [NTSB MIA84FA225](https://openairdocs.org/ntsb/MIA84FA225.md): Bellanca 8GCBC · Navarre, FL · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1984 · N50402 · Destroyed
  > Plt was engaged in banner tow pick up. Prior to engaging pick up line, acft struck ground nose down. Ground scars related to impact damage show wings rotated 180 degrees from path of flight prior to impact.
- [NTSB SEA84LA156](https://openairdocs.org/ntsb/SEA84LA156.md): Monett-Keating Moni · Bremerton, WA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1984 · N193RK · Substantial damage
  > The pilot stated he had shut down the engine several times to glide. On the last restart the engine ran for aprx 15 secsand then began to run rough and died. Attempted restarts were not successful. The aircraft failed to clear trees while attempting to land…
- [NTSB MIA84LA144](https://openairdocs.org/ntsb/MIA84LA144.md): Cessna TR182 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 21, 1984 · N738JA · Substantial damage
  > The plt was unable to lower the landing gear and made a wheels-up landing. An exam revealed that a rod end, pn S02321-3, on the nose gear door had failed. The failure was in tension bending with no signs of preexisting fatigue or corrosion.
- [NTSB FTW84LA203](https://openairdocs.org/ntsb/FTW84LA203.md): Cessna 185F · Belle Chasse, LA · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 1984 · N69GV · Minor damage
  > When the plt attempted to start the eng, it 'hung up in the middle of the compression stroke.' He stated that after confirming that the magnetos were off, he attempted to 'free the propeller by hand.' The eng started as soon as the propeller was moved. The…
- [NTSB MIA84LA121](https://openairdocs.org/ntsb/MIA84LA121.md): Piper PA-28-180 · Borinquen, PR · Accident · Minor injuries · Limited investigation · Final report · Mar 23, 1984 · N617R · Substantial damage
  > The plt reported that when he initially attempted to start the eng, the battery was weak. He decided to manually remove excess oil/lubricant from the eng by hand propping the acft. The plt stated that he set the parking brake & turned off the master sw & fuel…
- [NTSB FTW84LA155](https://openairdocs.org/ntsb/FTW84LA155.md): Cessna 152 · Durant, OK · Accident · No injuries · Limited investigation · Final report · Mar 2, 1984 · N4861B · 2 aircraft · Substantial damage
  > Before takeoff, a student & a commercial plt agreed to rendezvous & fly formation while the student took pictures of the commercial plt's acft. The student was to fly a Cessna 152, N4861B, while the commercial plt flew a Cessna 150, N704V6. They planned for…
- [NTSB DEN84LA074](https://openairdocs.org/ntsb/DEN84LA074.md): Cessna 210D · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Jan 25, 1984 · N45AM · Substantial damage
  > The acft was landed with the main gear retracted after attempts to extend them failed. After landing the acft departed the right side of the rwy. Post accident examination revealed that the secondary relief valve had failed in the hydraulic power pack. This…
- [NTSB DEN84IA070](https://openairdocs.org/ntsb/DEN84IA070.md): Swearingen SA227-AC · Durango, CO · Incident · No injuries · Incident investigation · Final report · Jan 15, 1984 · N31088 · Minor damage
  > According to the captain, the coplt was making the landing & crossed the threshold at 50 to 60 ft AGL at 110 to 115 KTS. He said a slightly higher airspeed was used to compensate for a small abount of ice that remained on the leading edge of the wings. In the…
- [NTSB ATL84LA077](https://openairdocs.org/ntsb/ATL84LA077.md): Cessna 150L · Ozark, AL · Accident · No injuries · Limited investigation · Final report · Dec 26, 1983 · N6816G · Substantial damage
  > The plt reported that the acft had about 17 gal of fuel on board before he took off. About 2 hrs & 40 mins later, while in slow flt at aprx 700 ft AGL, the eng lost power. The plt landed in a small field that was surrounded by trees. During the landing roll…
- [NTSB FTW84LA044](https://openairdocs.org/ntsb/FTW84LA044.md): Beech 95-B55 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Nov 6, 1983 · N677K · Substantial damage
  > During a missed approach from a practice ILS apch, a loud noise was heard during gear retraction. Subsequent attempts toextend the gear, both normally & manually, resulted in the right gear remaining up & locked with the inboard gear door slightly open. The…
- [NTSB LAX84LA019](https://openairdocs.org/ntsb/LAX84LA019.md): Bell 206B · Santa Ana, CA · Accident · No injuries · Limited investigation · Final report · Oct 15, 1983 · N49670 · Substantial damage
  > After returning from a flt, the helicopter was shutdown & refueled, then it was moved to a dolly. During the moving operation, the left 'shoe' slipped off the platform & the helicopter rocked back & damaged the tail rotor area.
- [NTSB MIA83IA217](https://openairdocs.org/ntsb/MIA83IA217.md): Semco SEM 182 · Palm Beach, FL · Incident · Minor injuries · Incident investigation · Final report · Aug 27, 1983 · N2052J · Minor damage
  > While being ground handled after landing a balloon contacted high tension high voltage wires.
- [NTSB DCA83AA036](https://openairdocs.org/ntsb/DCA83AA036.md): Lockheed Learstar, L-18-56 · Silvana, WA · Accident · 11 fatal · Final report · Aug 22, 1983 · N116CA · Destroyed
  > The acft was on a sport parachute flt to carry 24 parachutists to 12,500' over a drop zone (dz) for a mass jump. It was in a cargo configuration with no passenger seats, but it had 1 jump seat. There were 24 seat belts on the floor of the cargo area. Also,…
- [NTSB CHI83LA272](https://openairdocs.org/ntsb/CHI83LA272.md): Douglas DC-9-30 · Milwaukee, WI · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1983 · N980Z · Minor damage
  > A jetway collapsed as passenger loading commenced. The drive gear failed & oil was found to be contiminated with water. Heat had transferred to the worm gear which was misaligned & was not manufactured for acft use specifications.
- [NTSB NYC83LA163](https://openairdocs.org/ntsb/NYC83LA163.md): Piper J3C-65 · Argyle, NY · Accident · No injuries · Limited investigation · Final report · Jun 12, 1983 · N19AN · Substantial damage
  > The plt attempted to start the eng by hand propping for aprx 20 min. The eng finally started & continued to rev up. During this time, the passenger was in the rear seat. As the plt was returning to the cockpit, the acft began to roll forward. The plt was…

Next page: https://openairdocs.org/ntsb-phases/800/cases.md?page=5

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

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

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