# NTSB investigations: Maneuvering

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 178 of 378 · 18,851 cases

## Cases, newest first

- [NTSB MIA89FA101](https://openairdocs.org/ntsb/MIA89FA101.md): North American T-28C · Titusville, FL · Accident · 1 fatal · Field investigation · Final report · Mar 10, 1989 · N775CH · Destroyed
  > The pilot's improper execution of an aerobatic maneuver resulting in inadequate airspeed and loss of control.
- [NTSB DEN89LA084](https://openairdocs.org/ntsb/DEN89LA084.md): Hiller UH-12E · Golden, CO · Accident · No injuries · Limited investigation · Final report · Mar 9, 1989 · N7411N · Substantial damage
  > Improper in-flight planning/decision by the CFI which resulted in loss of tail rotor effectiveness and loss of directional control. Contributing factors were high density altitude, tailwind, and rough/uneven terrain.
- [NTSB MIA89FA098](https://openairdocs.org/ntsb/MIA89FA098.md): Cessna 152 · Fort Lauderdale, FL · Accident · 2 fatal · Field investigation · Final report · Mar 6, 1989 · N47115 · Destroyed
  > Instructor pilots failure to maintain control of the aircraft resulting in a collision with terrain.
- [NTSB SEA89LA052](https://openairdocs.org/ntsb/SEA89LA052.md): Schweizer 269C · Forrest Grove, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1989 · N7505Y · Substantial damage
  > The pilot's misjudgment of his altitude and clearance while attempting to sling-load a trailer.
- [NTSB FTW89LA063](https://openairdocs.org/ntsb/FTW89LA063.md): Cessna 172 · Bastrop, TX · Accident · No injuries · Limited investigation · Final report · Mar 3, 1989 · N7407T · Substantial damage
  > Inadequate preflight planning and preparation by the pilot which resulted in fuel exhaustion. Contributing to the accident were the low ceilings and fog.
- [NTSB LAX89DVA06](https://openairdocs.org/ntsb/LAX89DVA06.md): Grumman G-164A · Riverdale, CA · Accident · Serious injuries · Final report · Mar 1, 1989 · N8547H · Destroyed
  > Inadequate visual lookout by the pilot, when he diverted his attention. The power line was a related factor.
- [NTSB FTW89DQA01](https://openairdocs.org/ntsb/FTW89DQA01.md): Intermountain Mfg. Callair A-9B · El Paso, TX · Accident · Minor injuries · Final report · Feb 26, 1989 · N375MC · Substantial damage
  > Engine failure due to the pilot's failure to select the fullest tanks and, failure to maintain adequate flying speed.
- [NTSB ANC89LA046](https://openairdocs.org/ntsb/ANC89LA046.md): Piper PA-18 · Sulatna River, AK · Accident · No injuries · Limited investigation · Final report · Feb 22, 1989 · N1243A · Substantial damage
  > The pilot's failure to maintain control of the airplane which resulted in a stall.
- [NTSB MIA89LA087](https://openairdocs.org/ntsb/MIA89LA087.md): Harmon Velocity · Fort Lauderdale, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1989 · N330RH · Substantial damage
  > The inability of the pilot to recover from the intentional stall with an unknown c.g.
- [NTSB ATL89FA088](https://openairdocs.org/ntsb/ATL89FA088.md): Bellanca 7GCBC · Jackson, GA · Accident · 1 fatal · Field investigation · Final report · Feb 16, 1989 · N4126Y · Destroyed
  > The pilot's improper handling of the airplane which resulted in an inadvertent stall/spin and subsequent collision with terrain. Factors contributing to the accident were the pilot's decision to perform aerobatic maneuvers at low altitude, and complacency…
- [NTSB LAX89LA110](https://openairdocs.org/ntsb/LAX89LA110.md): Cessna 152 · Green Valley, AZ · Accident · No injuries · Limited investigation · Final report · Feb 12, 1989 · N5496B · Substantial damage
  > The student pilot displayed poor judgement in not maintaining proper altitude. A factor contributing to the accident was the pilot's overall lack of experience.
- [NTSB ATL89FA086](https://openairdocs.org/ntsb/ATL89FA086.md): Piper PA-28-140 · Jasper, TN · Accident · 2 fatal · Field investigation · Final report · Feb 12, 1989 · N588FL · Destroyed
  > The pilot's improper handling of the airplane flight controls at low altitude which resulted in an excessive rate of descent and collision with a tree.
- [NTSB NYC89FA080](https://openairdocs.org/ntsb/NYC89FA080.md): Bellanca 7GCBC · Lyon Mountain, NY · Accident · 1 fatal · Field investigation · Final report · Feb 11, 1989 · CGBHN · Destroyed
  > The pilot decided to fly in weather conditions that were beyond his and the aircraft's capabilities.
- [NTSB ATL89DKG01](https://openairdocs.org/ntsb/ATL89DKG01.md): Grumman G-164A · Dawson, GA · Accident · No injuries · Final report · Feb 10, 1989 · N9755 · Substantial damage
  > Total loss of engine power due to leaking carburetor float. Contributing to the accident was the soft terrain used for a forced landing.
- [NTSB SEA89LA048](https://openairdocs.org/ntsb/SEA89LA048.md): Aero Commander S2R · Cottonwood, ID · Accident · No injuries · Limited investigation · Final report · Feb 8, 1989 · N5620X · Substantial damage
  > The pilot misjudging his altitude due to the white out conditions. Contributing to the accident was the pilots lack of experience in this aircraft and this type of operation.
- [NTSB MIA89LA081](https://openairdocs.org/ntsb/MIA89LA081.md): Bell TH-1L · Greenville, FL · Accident · No injuries · Limited investigation · Final report · Feb 8, 1989 · N204AP · Substantial damage
  > Installation of the improper sprag clutch assembly by the owners maintenance personnel resulting in failure of the sprag clutch and the loss of transmission drive.
- [NTSB ANC89LA040](https://openairdocs.org/ntsb/ANC89LA040.md): Piper PA-18 · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Feb 6, 1989 · N7049 · Substantial damage
  > The pilot's failure to compensate for the gusty wind conditions and to maintain control of the airplane. Contributing to the accident was the gusty winds.
- [NTSB MIA89LA079](https://openairdocs.org/ntsb/MIA89LA079.md): Stolp-Adams SA100 · Indian Rocks, FL · Accident · No injuries · Limited investigation · Final report · Feb 4, 1989 · N511U · Substantial damage
  > The pilot's attempt to perform aerobatic maneuvers in an aircraft that was not equipped with fuel and oil systems that would continue to operate in inverted positions. This action resulted in a loss of power and the pilot having to ditch the aircraft.
- [NTSB MIA89LA076](https://openairdocs.org/ntsb/MIA89LA076.md): Waco YMF · Key West, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 1989 · N99Y · Substantial damage
  > The inability of the plt to maintain control after encountering his own wake turbulence at a low altitude during a steep turning maneuver.
- [NTSB LAX89DVA03](https://openairdocs.org/ntsb/LAX89DVA03.md): Bell 47G-3B2 · Strathmore, CA · Accident · Serious injuries · Final report · Feb 1, 1989 · N2918W · Destroyed
  > Improper compensation for wind conditions by the pilot, and his failure to maintain clearance from the service truck. Factors relating to the accident were: the unfavorable (variable) and gusty wind conditions and close proximity of the service vehicle.
- [NTSB LAX89FA093](https://openairdocs.org/ntsb/LAX89FA093.md): Grumman AA5A · Lake View, CA · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1989 · N26313 · Destroyed
  > The pilot's inadvertent flight into a box canyon.
- [NTSB LAX89FA092](https://openairdocs.org/ntsb/LAX89FA092.md): Robinson R22A · Santa Barbara, CA · Accident · 2 fatal · Field investigation · Final report · Jan 22, 1989 · N8529C · Destroyed
  > Failure of the pilot to maintain adequate altitude, proper airspeed for the reduced visibility, and an adequate visual outlook to avoid a collision with power transmission cable. Contributing to the accident was reduced visibility due to fog.
- [NTSB MKC89FA055](https://openairdocs.org/ntsb/MKC89FA055.md): Champion 7EC · Luxemburg, MN · Accident · 1 fatal · Field investigation · Final report · Jan 21, 1989 · N7596E · Destroyed
  > The pilot failed to maintain adequate airspeed which resulted in a stall and loss of aircraft control. The pilot's failure to observe weight and balance limitations of the aircraft was a contributing factor.
- [NTSB LAX89LA087](https://openairdocs.org/ntsb/LAX89LA087.md): Cessna T207A · Page, AZ · Accident · No injuries · Limited investigation · Final report · Jan 17, 1989 · N6347H · Substantial damage
  > Improper in-flight planning/decision by the pilot and his inadequate visual lookout (failure to see-and-avoid the obstruction). Factors related to the accident were: the birds, the pilot's excessive maneuver, and the transmission line.
- [NTSB ANC89LA035](https://openairdocs.org/ntsb/ANC89LA035.md): Cessna 150 · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Jan 16, 1989 · N6414K · Substantial damage
  > The student pilot's failure to follow procedures during the simulated forced landing. Contributing to the accident were the extreme temperatures.
- [NTSB LAX89DUJ03](https://openairdocs.org/ntsb/LAX89DUJ03.md): Murphey Vancraft 532 · Tucson, AZ · Accident · 1 fatal · Final report · Jan 15, 1989 · N61LM · Destroyed
  > Inadequate lookout by the pilot during unwarranted low flight.
- [NTSB BFO89LA015](https://openairdocs.org/ntsb/BFO89LA015.md): Cessna 150 · Winchester, VA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1989 · N714CR · Substantial damage
  > Partial loss of engine power for an unknown reason. Soft terrain was a contributing factor.
- [NTSB ANC89LA033](https://openairdocs.org/ntsb/ANC89LA033.md): Hughes 500-D · Bell Mountain, AK · Accident · No injuries · Limited investigation · Final report · Jan 12, 1989 · N5074R · Substantial damage
  > The pilot's misjudgment of his clearance above the terrain due to distorted visual perception. Contributing to the accident was the whiteout condition.
- [NTSB ATL89LA067](https://openairdocs.org/ntsb/ATL89LA067.md): Cessna 152 · Theodore, AL · Accident · No injuries · Limited investigation · Final report · Jan 4, 1989 · N69015 · Substantial damage
  > Pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall, and subsequent collision with the ground.
- [NTSB FTW89LA036](https://openairdocs.org/ntsb/FTW89LA036.md): Bell 206B-III · S.Timbalier 151 · Accident · Minor injuries · Limited investigation · Final report · Jan 3, 1989 · N22704 · Destroyed
  > A collision between the aircraft and the platform during the emergency autorotation which caused the left skid and float to separate and destabilized the autorotation. The collision was probably unadoidable due to the maneuver that was being conducted at the…
- [NTSB SEA89LA029](https://openairdocs.org/ntsb/SEA89LA029.md): Bell 47G3-B1 · Newberg, OR · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1988 · N8587F · Substantial damage
  > As plt slowed helicopter to about 10 KTS forward speed, tail rotor effectiveness decreased. Acft yawed right into descent to ground contact.
- [NTSB ATL89FA059](https://openairdocs.org/ntsb/ATL89FA059.md): Cessna 172 · Wadsworth, OH · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1988 · N8193B · Destroyed
  > PIC & future son-in-law came to arpt to fly acft. Wx was low ceilings & viz due to fog. PIC did not have instrument rating. The son-in-law, an army captain, was sked to leave for overseas assignment shortly. Closest arpt which rpted wx, 15 miles southeast,…
- [NTSB MIA89LA056](https://openairdocs.org/ntsb/MIA89LA056.md): Hughes 269A · Crystal River, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1988 · N1025J · Substantial damage
  > The plt stated that he was giving a friend a ride in the acft when he inadvertantly struck powerlines and crashed in shallow water.
- [NTSB NYC89FA053](https://openairdocs.org/ntsb/NYC89FA053.md): Cessna 414 · Franklin Twp, PA · Accident · 2 fatal · Field investigation · Final report · Dec 22, 1988 · N244RM · Destroyed
  > Before takeoff, the crew indcd the flt would be for 'check rides' & that they planned to 'shoot approaches' & proceed to the practice area to do some airwork. ATC advised the plts that the cloud bases were at 3500 feet MSL. Elevation of the terrain (where the…
- [NTSB FTW89DPJ02](https://openairdocs.org/ntsb/FTW89DPJ02.md): Ercoupe 415C · Oklahoma City, OK · Accident · 2 fatal · Final report · Dec 21, 1988 · N99636 · Destroyed
  > During flight, the airplane appeared to go into a steep banked spiral from which it did not recover. It struck a two-car detached garage and then the ground. Inspection revealed that the fabric of both wings had been installed improperly, and part of the…
- [NTSB DEN89FA045](https://openairdocs.org/ntsb/DEN89FA045.md): Piper PA-24-250 · Elephant Butte, NM · Accident · 1 fatal · Field investigation · Final report · Dec 21, 1988 · N751SP · Destroyed
  > During a return flight from having maintenance performed on the acft the plt executed a low pass by his home which was located on a point of land overlooking Elephant Butte reservoir, NM. During the maneuver while in a steep turn the left wing struck the…
- [NTSB DEN89LA042](https://openairdocs.org/ntsb/DEN89LA042.md): Cessna 152 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Dec 16, 1988 · N49209 · Substantial damage
  > The plt was flying a cross-country flight. She said that 3 miles from her destination, the engine quit when the plane ran out of fuel. A landing on an ice covered asphalt road was performed. During roll out, the left main gear went off the road and the left…
- [NTSB NYC89LA049](https://openairdocs.org/ntsb/NYC89LA049.md): Cessna 150L · Greenwich, CT · Accident · No injuries · Limited investigation · Final report · Dec 12, 1988 · N6538G · Substantial damage
  > Trees during an off airport landing after the aircraft expererienced a power loss fue to fuel starvation.
- [NTSB LAX89LA063](https://openairdocs.org/ntsb/LAX89LA063.md): Hughes 369E · Hanalei, HI · Accident · No injuries · Limited investigation · Final report · Dec 12, 1988 · N7733H · Substantial damage
  > During a local sightseeing flight, the pilot reported that he heard a muffled bang and simultaneously the engine out warning lights and audio alarm activated. The pilot initiated a forced landing on the beach which resulted in the helicopter nosing over. An…
- [NTSB FTW89DRA01](https://openairdocs.org/ntsb/FTW89DRA01.md): Hughes 369D · Kountze, TX · Accident · Minor injuries · Final report · Dec 12, 1988 · N58261 · Substantial damage
  > False indications of the fuel quantity system, which led the pilot to believe ha had more fuel than he did.
- [NTSB CHI89LA029](https://openairdocs.org/ntsb/CHI89LA029.md): Mcdonnell Douglas 269C · Frankfort, IL · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 1988 · N1098P · Substantial damage
  > The helicopter experienced a tree strike with the main rotor blades and then rolled over when it struck the ground during a precautionary landing attempt. The helicopter had been conducting contract power line patrol when the PIC noted an apparent partial…
- [NTSB ATL89FA045](https://openairdocs.org/ntsb/ATL89FA045.md): Piper PA-28-140 · Concord, NC · Accident · 2 fatal · Field investigation · Final report · Nov 26, 1988 · N98369 · Destroyed
  > PIC & wife flew to local residential area to photograph a house. The acft was flown in the vicinity of the accident for about 30 minutes. Radar data displayed the acft in a level left turn at 2300 feet (1700 AGL) for about 50 seconds when contact was abruptly…
- [NTSB CHI89FA027](https://openairdocs.org/ntsb/CHI89FA027.md): Gulfstream AA1A · North Vernon, IN · Accident · 2 fatal · Field investigation · Final report · Nov 24, 1988 · N9396L · Destroyed
  > The aircraft was observed to make a high speed low level pass adjacent to the runway and a climbing left turn away from the airport, heading north. A witness in a field north of the airport reported seeing the aircraft descending from a low altitude, level…
- [NTSB LAX89LA053](https://openairdocs.org/ntsb/LAX89LA053.md): Cessna 150F · Santa Maria, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 19, 1988 · N6883F · Substantial damage
  > During a pleasure flight, the airplane was being flown along a ridgeline while the pilot and passenger were looking for an old airplane wreck. The pilot was distracted and did not notice the airplane was entering a canyon and rising terrain. When the pilots…
- [NTSB CHI89DEX01](https://openairdocs.org/ntsb/CHI89DEX01.md): Pitts S-15 · Delphi, IN · Accident · 1 fatal · Final report · Nov 17, 1988 · N3RJ · Destroyed
  > Failure to recover from an aerobatic maneuver due to lack of total experience, and lack of recent experience in the type of flight regime.
- [NTSB ATL89LA038](https://openairdocs.org/ntsb/ATL89LA038.md): Cessna 152F · Harkers Island, NC · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1988 · N8225F · Destroyed
  > The plt rprtd he was orbiting over a school of fish at aprx 800' when he encountered wake turbulence from his own acft. He believed that a wider orbit would have prevented him from flying back into the wake & additional altitude would have provided more time…
- [NTSB FTW89DQG02](https://openairdocs.org/ntsb/FTW89DQG02.md): Piper PA-25 · Amarillo, TX · Accident · 1 fatal · Final report · Nov 14, 1988 · N8547L · Destroyed
  > Failure on the part of the pilot to maintain the proper airspeed for the maneuver being performed, followed by a stall at an altitude insufficient to recover.
- [NTSB CHI89DEV02](https://openairdocs.org/ntsb/CHI89DEV02.md): Air Command 503 · Sullivan, IL · Accident · 1 fatal · Final report · Nov 13, 1988 · UNREG · Destroyed
  > The pilot failed to maintain control of the aircraft.
- [NTSB ATL89FA036](https://openairdocs.org/ntsb/ATL89FA036.md): Cessna 152 · Arcadia, FL · Accident · 2 fatal · Field investigation · Final report · Nov 13, 1988 · N69175 · Destroyed
  > Aircraft departed on a cross country instructional flight. The aircraft landed for fuel at orlando int'l and departed VFR. There were no witnesses. The accident site was located by ELT signal in a treeline that bordered the west end of a large open pasture.…
- [NTSB LAX89LA046](https://openairdocs.org/ntsb/LAX89LA046.md): Univair Taylorcraft BC12-D · Kawaihae, HI · Accident · No injuries · Limited investigation · Final report · Nov 12, 1988 · N5496V · Substantial damage
  > During a pleasure flight, the pilot intentionally shut down the engine and was flying the airplane similar to a sailplane. To restart the engine, he would dive the airplane to attain enough speed to windmill the prop. Just before the accident, he allowed the…

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=179

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

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

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