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

## Cases, newest first

- [NTSB CEN19WA096](https://openairdocs.org/ntsb/CEN19WA096.md): North American T28 · Escuintla, Guatemala · Accident · 2 fatal · Foreign investigation · Mar 10, 2019 · N55500 · Substantial damage
- [NTSB WPR19FA093](https://openairdocs.org/ntsb/WPR19FA093.md): Piper PA23 · Pahokee, FL · Accident · 5 fatal · Class 2 · Field · Final report · Mar 8, 2019 · N5894Y · Destroyed
  > The pilot's failure to maintain control of the airplane while maneuvering for landing with one engine inoperative following a loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR19FA091](https://openairdocs.org/ntsb/WPR19FA091.md): Bell UH1B · Forks, WA · Accident · 1 fatal · Class 2 · Field · Final report · Mar 8, 2019 · N64RA · Destroyed
  > A total loss of engine power due to the failure of the gas generator sealing disk as a result of the operator’s exceedance of the sealing disk life limits at too low an altitude for the pilot to accomplish a successful autorotation which resulted in the…
- [NTSB GAA19CA158](https://openairdocs.org/ntsb/GAA19CA158.md): Piper PA18 · Wyndmere, ND · Accident · No injuries · Data collection · Final report · Mar 7, 2019 · N726 · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack during an uncoordinated turn while maneuvering at low altitude, which resulted in an aerodynamic stall.
- [NTSB ERA19FA118](https://openairdocs.org/ntsb/ERA19FA118.md): Hughes 369 · Talking Rock, GA · Accident · 1 fatal · Class 3 · Field · Final report · Mar 5, 2019 · N89ZC · Substantial damage
  > A fatigue failure of the overrunning clutch subassembly due to abnormal bending loads due to cracks on the center engine mount, which resulted in an inflight loss of power. Contributing to the accident was the helicopter's low altitude and airspeed when the…
- [NTSB WPR19LA092](https://openairdocs.org/ntsb/WPR19LA092.md): Cessna 172 · Melba, ID · Accident · No injuries · Class 3 · Limited · Final report · Mar 1, 2019 · N6486J · Substantial damage
  > The total loss of engine power due to a separated carburetor idle mixture adjustment screw and spring assembly for reasons that could not be determined.
- [NTSB ERA19FA112](https://openairdocs.org/ntsb/ERA19FA112.md): Piper PA25 · Fort Lauderdale, FL · Accident · 1 fatal · Class 3 · Field · Final report · Mar 1, 2019 · N145AB · Destroyed
  > The pilot’s failure to maintain proper altitude and clearance while maneuvering during a banner tow flight, which resulted in an in-flight collision with a 19-story building in a heavily congested area. Contributing to the accident were the easterly wind…
- [NTSB CEN19LA087](https://openairdocs.org/ntsb/CEN19LA087.md): Warner Aerocraft Space Walker II · Devine, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Feb 27, 2019 · N1778 · Substantial damage
  > The pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.
- [NTSB GAA19CA139](https://openairdocs.org/ntsb/GAA19CA139.md): Airbus A350 · Eureka, AK · Accident · No injuries · Data collection · Final report · Feb 18, 2019 · N350ST · Substantial damage
  > The pilot's selection of unsuitable terrain for landing on snow-covered mountainous terrain with steep rocks above, which resulted in loose rocks damaging the main rotor blades and the subsequent loss of helicopter controllability.
- [NTSB CEN19FA082](https://openairdocs.org/ntsb/CEN19FA082.md): Cessna 421 · Canadian, TX · Accident · 2 fatal · Class 2 · Field · Final report · Feb 15, 2019 · N421NS · Destroyed
  > The pilot's failure to maintain control of the airplane while in instrument meteorological conditions with icing conditions present, which resulted in an aerodynamic stall and spin into terrain.
- [NTSB ERA19TA098](https://openairdocs.org/ntsb/ERA19TA098.md): Cessna 172 · Lignum, VA · Accident · Minor injuries · Class 3 · Final report · Feb 10, 2019 · N7414N · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB CEN19WA081](https://openairdocs.org/ntsb/CEN19WA081.md): Cessna 150 · Atizapán de Zaragoza, México, México, Mexico · Accident · 2 fatal · Foreign investigation · Feb 10, 2019 · XB-OWS · Substantial damage
  > The government of Mexico has notified the NTSB of an accident involving a CESSNA 150H airplane that occurred on February 10, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…
- [NTSB ERA19WA101](https://openairdocs.org/ntsb/ERA19WA101.md): Globe GC1A · Dom Pedrito County, Brazil · Accident · 2 fatal · Foreign investigation · Feb 6, 2019 · PT-AIG · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a GLOBE GC1A airplane that occurred on February 06, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB ERA19LA093](https://openairdocs.org/ntsb/ERA19LA093.md): Piper PA32RT · Atlantic Ocean (Atlantic Ocean) · Accident · 2 fatal · Limited investigation · Final report · Feb 1, 2019 · N3016L · Destroyed
  > The pilot's loss of control due to spatial disorientation.
- [NTSB CEN19WA079](https://openairdocs.org/ntsb/CEN19WA079.md): Cessna 150 · Durango, Mexico · Accident · 1 fatal · Foreign investigation · Jan 30, 2019 · XB-KEJ · Substantial damage
- [NTSB WPR19WA147](https://openairdocs.org/ntsb/WPR19WA147.md): Sikorsky S64 · Mount Eliza, Australia · Accident · Minor injuries · Foreign investigation · Jan 28, 2019 · N173AC · Substantial damage
  > On January 28, 2019, at 1956 local time, a Sikorsky S-64E, N173AC, sustained substantial damage after colliding into a pond near Mount Eliza, Australia. The pilot and two crewmembers were not injured. The investigation is under the jurisdiction of the…
- [NTSB WPR19FA077](https://openairdocs.org/ntsb/WPR19FA077.md): Rockwell 112 · Mt Hood, OR · Accident · 1 fatal · Class 2 · Field · Final report · Jan 25, 2019 · N1332J · Destroyed
  > The pilot's decision to fly the airplane in close proximity to mountainous terrain in an area of mountain wave activity that exceeded the performance capabilities of the airplane. Contributing to the accident was the pilot's degraded decision making and…
- [NTSB WPR19LA071](https://openairdocs.org/ntsb/WPR19LA071.md): Bell 206 · Ashland, OR · Accident · 1 fatal · Class 3 · Limited · Final report · Jan 23, 2019 · N8227J · Substantial damage
  > The pilot's decision to continue visual flight into deteriorating weather, which resulted in an encounter with instrument meteorological conditions and spatial disorientation leading to a loss of control.
- [NTSB ERA19WA090](https://openairdocs.org/ntsb/ERA19WA090.md): Piper PA25 · Jaguaré County, Brazil · Accident · 1 fatal · Foreign investigation · Jan 21, 2019 · PR-FBA · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a PIPER PA-25-235 airplane that occurred on January 21, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB CEN19CA062](https://openairdocs.org/ntsb/CEN19CA062.md): Piper PA 18 · Iron Mountain, MI · Accident · Minor injuries · Data collection · Final report · Jan 19, 2019 · N3298Z · Substantial damage
  > The pilot's distraction and subsequent loss of situational awareness and visual horizon in overcast sky conditions, which led to an unrecognized descent during a low-level maneuver and subsequent impact with snow-covered terrain.
- [NTSB CEN19LA053](https://openairdocs.org/ntsb/CEN19LA053.md): Piper PA28 · Salem, SD · Accident · 1 fatal · Limited investigation · Final report · Jan 13, 2019 · N75191 · Substantial damage
  > The incapacitating effects of an acute myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.
- [NTSB WPR19TA061](https://openairdocs.org/ntsb/WPR19TA061.md): Bell 206 · Yuma, AZ · Accident · Serious injuries · Class 3 · Final report · Jan 12, 2019 · N88HC · Substantial damage
  > The pilot's failure to maintain clearance from power transmission wires while flying at low altitude in nighttime conditions.
- [NTSB CEN19LA067](https://openairdocs.org/ntsb/CEN19LA067.md): Bell 47G · Belen, NM · Accident · No injuries · Limited investigation · Final report · Jan 11, 2019 · N3755Z · Substantial damage
  > The pilot's failure to maintain adequate main rotor speed while the helicopter was in an out-of-ground effect hover.
- [NTSB ERA19LA080](https://openairdocs.org/ntsb/ERA19LA080.md): Bellanca 1730 · Soddy-Daisy, TN · Accident · 2 fatal · Limited investigation · Final report · Jan 7, 2019 · N8849V · Destroyed
  > The pilot's improper decision to attempt an aerobatic maneuver at low altitude, which led to an aerodynamic stall and spin from which the pilot could not recover.
- [NTSB GAA19CA110](https://openairdocs.org/ntsb/GAA19CA110.md): Robinson R44 · Grace, ID · Accident · No injuries · Data collection · Final report · Jan 3, 2019 · N4246Z · Substantial damage
  > The pilot's failure to maintain clearance from the power lines.
- [NTSB WPR19LA055](https://openairdocs.org/ntsb/WPR19LA055.md): Cessna 180 · Townsend, MT · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 2, 2019 · N4934A · Substantial damage
  > The pilot’s failure to maintain clearance from power lines while maneuvering at low level, which resulted in a wire strike and subsequent impact with terrain.
- [NTSB GAA19CA124](https://openairdocs.org/ntsb/GAA19CA124.md): Robinson R44 · Santa Maria Island, FL · Accident · Serious injuries · Data collection · Final report · Jan 2, 2019 · N772MG · Substantial damage
  > The pilot's loss of helicopter control while maneuvering at a low altitude after being struck in the head by a bird.
- [NTSB WPR19CA052](https://openairdocs.org/ntsb/WPR19CA052.md): Robinson R22 · Hayward, CA · Accident · No injuries · Data collection · Final report · Dec 28, 2018 · N8319T · Substantial damage
  > An in-flight collision with a bird during low-altitude maneuvering, which resulted in a hard landing.
- [NTSB CEN19LA070](https://openairdocs.org/ntsb/CEN19LA070.md): Cessna 172 · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Dec 21, 2018 · N254RA · Substantial damage
  > The pilot's failure to see and avoid a cell tower wire during a pipeline patrol flight. Contributing to the accident was the pilot's distraction due to writing down observations about the pipeline while flying.
- [NTSB ERA19WA082](https://openairdocs.org/ntsb/ERA19WA082.md): Rockwell S2R · Orihueca, Magdalena, Colombia · Accident · No injuries · Foreign investigation · Dec 19, 2018 · HK5253 · Minor damage
  > The government of Colombia has notified the NTSB of an accident involving a ROCKWELL S2R airplane that occurred on December 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…
- [NTSB ERA19FA068](https://openairdocs.org/ntsb/ERA19FA068.md): Saberwing Saberwing · Adel, GA · Accident · 1 fatal · Class 2 · Field · Final report · Dec 18, 2018 · N203SW · Substantial damage
  > The in-flight failure of the fuselage, as a result of the pilot conducting maneuvers that exceeded the structural capabilities of the airplane.
- [NTSB WPR19WA040](https://openairdocs.org/ntsb/WPR19WA040.md): Pilatus BN2A-20 · Hobart, Australia · Accident · 1 fatal · Foreign investigation · Dec 7, 2018 · VH-OBL · Destroyed
  > On December 7, 2018, at 0929 Universal Time Coordinated, a Pilatus Britten-Norman Ltd, BN2A-20, VH-OBL was destroyed when it collided with terrain near the Hobart Aerodrome, Hobart, Australia. The pilot, who was the sole occupant was fatally injured. The…
- [NTSB GAA19CA078](https://openairdocs.org/ntsb/GAA19CA078.md): Air Tractor AT 502 · Americus, GA · Accident · No injuries · Data collection · Final report · Nov 28, 2018 · N843WA · Substantial damage
  > The pilot's failure to see and avoid a power line during an agricultural application flight.
- [NTSB ERA19WA075](https://openairdocs.org/ntsb/ERA19WA075.md): Cessna 172 · Denizli, Türkiye · Accident · 2 fatal · Foreign investigation · Nov 19, 2018 · TC-JZC · Substantial damage
  > The government of Turkey has notified the NTSB of an accident involving a CESSNA 172 airplane that occurred on November 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions…
- [NTSB GAA19CA063](https://openairdocs.org/ntsb/GAA19CA063.md): Robinson R44 · Knox City, TX · Accident · No injuries · Data collection · Final report · Nov 18, 2018 · N4167Y · Substantial damage
  > The pilot's failure to maintain adequate airspeed with a tailwind, which resulted in the helicopter settling with power, and his subsequent incorrect collective application while attempting to recover, which resulted in a loss of helicopter control due to a…
- [NTSB CEN19FA030](https://openairdocs.org/ntsb/CEN19FA030.md): Cessna 441 · Harmon, ND · Accident · 3 fatal · Class 2 · Field · Final report · Nov 18, 2018 · N441CX · Destroyed
  > The pilot's failure to maintain control of the airplane in dark night conditions that resulted in an in-flight positive overload failure of the wings and the subsequent in-flight breakup of the airplane.
- [NTSB WPR19TA037](https://openairdocs.org/ntsb/WPR19TA037.md): Scottish Series 100 MDL 101 · Lake Pleasant, AZ · Accident · Minor injuries · Class 3 · Final report · Nov 17, 2018 · N82696 · Substantial damage
  > Impact with a lake for undetermined reasons.
- [NTSB ERA19LA050](https://openairdocs.org/ntsb/ERA19LA050.md): Ultralite Sro Stingsport · Clermont, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 17, 2018 · N494N · Substantial damage
  > An inflight failure of the airplane’s horizontal stabilizer.
- [NTSB CEN19FA028](https://openairdocs.org/ntsb/CEN19FA028.md): North American P51 · Fredericksburg, TX · Accident · 2 fatal · Field investigation · Final report · Nov 17, 2018 · N4132A · Destroyed
  > The pilot's decision to perform a low-level maneuver at an altitude where he was unable to recover the airplane before impacting terrain.
- [NTSB ERA19FA047](https://openairdocs.org/ntsb/ERA19FA047.md): Bell OH 58C · Verbena, AL · Accident · 2 fatal · Class 2 · Field · Final report · Nov 16, 2018 · N510CP · Substantial damage
  > The pilot's improper decision to conduct a low-level flight over a river, and his failure to see and avoid power lines, which resulted in the helicopter's impact with power lines and the water.
- [NTSB WPR19RA044](https://openairdocs.org/ntsb/WPR19RA044.md): Aerospatiale AS350 · Dusky Forest, New Zealand · Accident · No injuries · Foreign investigation · Nov 6, 2018 · ZK HZS · Substantial damage
  > The government of New Zealand has notified the NTSB of an accident involving a AEROSPATIALE AS350 helicopter that occurred on November 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of New Zealand's investigation…
- [NTSB WPR19TA018](https://openairdocs.org/ntsb/WPR19TA018.md): Audenried Kitfox S7 SuperSport · Flanigan, NV · Accident · Serious injuries · Final report · Nov 3, 2018 · N13NZ · Substantial damage
  > The pilot's failure to maintain airspeed during a sharp turn at low altitude, which resulted in an aerodynamic stall.
- [NTSB CEN19FA020](https://openairdocs.org/ntsb/CEN19FA020.md): Hughes 369 · McDougal, AR · Accident · 1 fatal · Class 2 · Field · Final report · Nov 2, 2018 · N5187S · Destroyed
  > The pilot's failure to maintain the helicopter's clearance from the powerline structure while hovering in gusty wind conditions, which resulted in an inadvertent collision with the structure and an uncontrolled descent into terrain.
- [NTSB ERA19WA076](https://openairdocs.org/ntsb/ERA19WA076.md): Cessna 150 · Manavgat, Türkiye · Accident · 2 fatal · Foreign investigation · Oct 30, 2018 · TC-KIM · Substantial damage
  > The government of Turkey has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on October 30, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Turkey's investigation under the provisions of…
- [NTSB ERA19FA035](https://openairdocs.org/ntsb/ERA19FA035.md): Aerospatiale AS 355F2 · Beekmantown, NY · Accident · 2 fatal · Field investigation · Final report · Oct 30, 2018 · N372CA · Destroyed
  > The pilot's failure to keep the helicopter clear of a utility pole while hovering with a tailwind, which resulted in a dynamic rollover into active power lines.
- [NTSB ERA19FA034](https://openairdocs.org/ntsb/ERA19FA034.md): Autogyro Cavalon · Sebring, FL · Accident · 2 fatal · Field investigation · Final report · Oct 30, 2018 · N198LT · Destroyed
  > The pilot's improper decision to operate the gyroplane in an unairworthy condition, which resulted in the cyclic pitch control disconnecting in flight. Contributing was the pilot's inability to maintain control of the helicopter utilizing the published…
- [NTSB ERA19LA028](https://openairdocs.org/ntsb/ERA19LA028.md): Beech V35 · Murfreesboro, TN · Accident · Serious injuries · Limited investigation · Final report · Oct 28, 2018 · N5624S · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering at low altitude in gusting wind conditions.
- [NTSB GAA19CA039](https://openairdocs.org/ntsb/GAA19CA039.md): Bell OH 58A · Carson City, NV · Accident · Minor injuries · Data collection · Final report · Oct 27, 2018 · N1032F · Substantial damage
  > The pilot's failure to maintain clearance from power lines while maneuvering at a low altitude in hilly terrain. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.
- [NTSB CEN19LA016](https://openairdocs.org/ntsb/CEN19LA016.md): Rotorway 162 · Passaic, MO · Accident · No injuries · Class 3 · Limited · Final report · Oct 27, 2018 · N162RF · Substantial damage
  > The electrical short in the main rotor rpm indicating unit which provided an inaccurate indication to the student pilot and resulted in substantial damage during the precautionary autorotation.
- [NTSB WPR19WA015](https://openairdocs.org/ntsb/WPR19WA015.md): Bell UH -1H · Vermaaklikheid, South Africa · Accident · 1 fatal · Foreign investigation · Oct 23, 2018 · ZS-HLP · Substantial damage
  > On October 23, 2018, about 0745 Coordinated Universal time, a Bell UH-1H helicopter, ZS-HLP, impacted terrain during a firefighting mission near Vermaaklikheid, South Africa. The pilot sustained fatal injuries and the helicopter was substantially damaged in…

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

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

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