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

## Cases, newest first

- [NTSB ERA15WA105](https://openairdocs.org/ntsb/ERA15WA105.md): Robinson R66 · Tashanta, Russia · Accident · No injuries · Foreign investigation · Jan 20, 2015 · RA-06205 · Substantial damage
  > On January 20, 2015, at an undetermined time, a Robinson Helicopter R66, Russian registration RA-06205, was substantially damaged during a forced landing near Tashanta, Russia. The pilot and two passengers were not injured. The flight originated in…
- [NTSB CEN15LA106](https://openairdocs.org/ntsb/CEN15LA106.md): Diamond Aircraft Ind DA 20 C1 · Shipshewana, IN · Accident · No injuries · Limited investigation · Final report · Jan 19, 2015 · N979DC · Substantial damage
  > The total loss of engine power due to impact ice obstructing the primary air induction system, which resulted from the student pilot’s failure to operate the alternate air control. Contributing to the accident was the student pilot’s lack of knowledge about…
- [NTSB CEN15WA148](https://openairdocs.org/ntsb/CEN15WA148.md): Piper PA-24-260 · Rechberghausen, Germany · Accident · 2 fatal · Foreign investigation · Jan 18, 2015 · D-EERZ · Substantial damage
  > On January 18, 2015, about 1455 coordinated universal time, a Piper PA-24-260 airplane, German registration D-EERZ, collided with a house near Rechberghausen, Germany. The pilot and passenger were both fatally injured. The airplane was destroyed. The accident…
- [NTSB ERA15FA102](https://openairdocs.org/ntsb/ERA15FA102.md): Schmidt Albert D Aventura II · Sebring, FL · Accident · 2 fatal · Field investigation · Final report · Jan 16, 2015 · N511DS · Substantial damage
  > The pilot's failure to maintain control while maneuvering at low altitude, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB ERA15WA108](https://openairdocs.org/ntsb/ERA15WA108.md): Cessna A188B · Baixa Grande do Ribeiro, Brazil · Accident · 1 fatal · Foreign investigation · Jan 14, 2015 · PT-FFH · Substantial damage
  > On January 14, 2015, about 1050 universal coordinated time, a Cessna A188B, Brazilian registration PT-FFH, was substantially damaged when it collided with a utility pole during an aerial application flight near Baixa Grande do Ribeiro, Brazil. The foreign…
- [NTSB CEN15LA107](https://openairdocs.org/ntsb/CEN15LA107.md): Cessna 210J · Dodge City, KS · Accident · Serious injuries · Limited investigation · Final report · Jan 14, 2015 · N3320S · Substantial damage
  > The loss of engine power on approach due to fuel exhaustion, which resulted from the pilot's improper preflight fuel planning and inspection.
- [NTSB DCA15WA053](https://openairdocs.org/ntsb/DCA15WA053.md): Hal Dhruv · Guayaquil, Ecuador · Accident · Minor injuries · Foreign investigation · Jan 13, 2015 · FAE-603 · Substantial damage
  > The Civil Aviation Authority of Ecuador has notified the NTSB of an accident involving a HAL Dhruvhelicopter, which occurred on January 13, 2015. The NTSB has appointed a U.S Accredited Representative to assist.All investigative information will be released…
- [NTSB CEN15FA101](https://openairdocs.org/ntsb/CEN15FA101.md): Piper PA 28RT-201T · Brighton, CO · Accident · 1 fatal · Field investigation · Final report · Jan 11, 2015 · N82828 · Destroyed
  > The pilot's intentional descent into the terrain.
- [NTSB CEN15LA098](https://openairdocs.org/ntsb/CEN15LA098.md): Raytheon A36 · Parker City, IN · Accident · Serious injuries · Limited investigation · Final report · Jan 4, 2015 · N349EA · Substantial damage
  > The pilot’s loss of airplane control while troubleshooting an engine issue in instrument meteorological conditions, which resulted in impact with trees and terrain.
- [NTSB WPR15WA075](https://openairdocs.org/ntsb/WPR15WA075.md): Cessna 172 - S · Port Arthur, Australia, Australia · Accident · 2 fatal · Foreign investigation · Dec 29, 2014 · VH-PFT · Substantial damage
  > On December 29, 2014, at 1747 local, a Cessna 172S, VH-PFT, collided with water near Port Arthur, Australia during an aerial photography flight. The airplane was operating under the pertinent civil regulations of the government of Australia. The airplane was…
- [NTSB WPR15FA070](https://openairdocs.org/ntsb/WPR15FA070.md): Cessna 172 · Sutter Creek, CA · Accident · 2 fatal · Field investigation · Final report · Dec 24, 2014 · N8518B · Substantial damage
  > The noninstrument-rated pilot's encounter with instrument meteorological conditions (IMC) while maneuvering, which resulted in a loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot's decision to attempt to…
- [NTSB CEN15FA083](https://openairdocs.org/ntsb/CEN15FA083.md): Cessna 172M · Odessa, TX · Accident · 1 fatal · Field investigation · Final report · Dec 22, 2014 · N9922V · Destroyed
  > The pilot’s failure to maintain adequate airspeed while maneuvering at an excessive bank angle at a low altitude, which resulted in an accelerated stall and spin with insufficient altitude for a recovery.
- [NTSB WPR15FA062](https://openairdocs.org/ntsb/WPR15FA062.md): Piper PA 18-150 · Ronan, MT · Accident · 1 fatal · Field investigation · Final report · Dec 16, 2014 · N5989Z · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while performing an intentional, abrupt low-level maneuver.
- [NTSB WPR15CA063](https://openairdocs.org/ntsb/WPR15CA063.md): Eurocopter AS 350 B2 Ecureuil · Bicknell, UT · Accident · No injuries · Data collection · Final report · Dec 16, 2014 · N352SL · Substantial damage
  > The pilot's failure to prevent the helicopter from settling with power while maneuvering at a low altitude, which resulted in a loss of control and subsequent hard landing.
- [NTSB ERA15FA076](https://openairdocs.org/ntsb/ERA15FA076.md): Titan Tornado II · Catlett, VA · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2014 · N50402 · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering at a low altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB CEN15LA077](https://openairdocs.org/ntsb/CEN15LA077.md): New Piper PA 32R-301T · Springfield, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 12, 2014 · N3127R · Substantial damage
  > The pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…
- [NTSB WPR15LA058](https://openairdocs.org/ntsb/WPR15LA058.md): Mcholland Glastar · Sheridan, WY · Accident · No injuries · Limited investigation · Final report · Dec 10, 2014 · N16XP · Substantial damage
  > A loss of engine power while maneuvering at low altitude for reasons that could not be determined during postaccident examination.
- [NTSB CEN15IA076](https://openairdocs.org/ntsb/CEN15IA076.md): Cessna 182S · Springfield, IL · Incident · No injuries · Incident investigation · Final report · Dec 10, 2014 · N661SP · Minor damage
  > The improper installation of a doubler patch, which prevented the right flap from actuating and moving properly and led to the subsequent interference with the aileron.
- [NTSB CEN15CA095](https://openairdocs.org/ntsb/CEN15CA095.md): Cessna 152 · Mount Pleasant, TX · Accident · No injuries · Data collection · Final report · Dec 8, 2014 · N787PB · Destroyed
  > The pilot's decision to maneuver the airplane at low altitude resulting in the airplane impacting power lines.
- [NTSB WPR15FA051](https://openairdocs.org/ntsb/WPR15FA051.md): Robinson Helicopter R44 · Bountiful, UT · Accident · 2 fatal · Field investigation · Final report · Dec 2, 2014 · N3234U · Substantial damage
  > The pilot/mechanic's failure to properly secure the pitch link hardware of one main rotor blade to the rotating swash plate, which resulted in the pitch link separating in flight and a subsequent loss of control.
- [NTSB WPR15LA048](https://openairdocs.org/ntsb/WPR15LA048.md): Air Tractor AT 502B · Somerton, AZ · Accident · 1 fatal · Limited investigation · Final report · Nov 30, 2014 · N946TR · Destroyed
  > A loss of airplane control for reasons that could not be determined based on available evidence.
- [NTSB WPR15FA049](https://openairdocs.org/ntsb/WPR15FA049.md): Cessna 170B · Alzada, MT · Accident · 1 fatal · Field investigation · Final report · Nov 28, 2014 · N3292A · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering, which resulted in a collision with mountainous terrain.
- [NTSB ERA15CA059](https://openairdocs.org/ntsb/ERA15CA059.md): Hiller OH 23B · Leesburg, VA · Accident · No injuries · Data collection · Final report · Nov 24, 2014 · N6057 · Substantial damage
  > A loss of tail rotor effectiveness while hovering in gusting crosswind conditions resulting in the student pilot's loss of control of the helicopter. Contributing was the delayed remedial action of the flight instructor.
- [NTSB ERA15CA055](https://openairdocs.org/ntsb/ERA15CA055.md): Mcdonnell Douglas Helicopter MD500 · Decatur, AL · Accident · No injuries · Data collection · Final report · Nov 18, 2014 · N8371F · Substantial damage
  > An undetermined pilot's failure to maintain clearance from an electrical transmission tower resulting in substantial damage to a main rotor blade. Postaccident investigation could not determine which of two pilots was flying the helicopter at the time the…
- [NTSB ERA15WA061](https://openairdocs.org/ntsb/ERA15WA061.md): Piper PA-25-235 · Cidade Gaúcha, State of Paraná, Brazil · Accident · 1 fatal · Foreign investigation · Nov 17, 2014 · PR-WIZ · Destroyed
  > On November 17, 2014, about 1758 universal coordinated time, a Piper PA-25-235, Brazilian registration PR-WIZ, was destroyed when it impacted the ground in a sugar cane field in Cidade Gaúcha, Paraná, Brazil. The pilot was fatally injured. The flight was…
- [NTSB ERA15LA052](https://openairdocs.org/ntsb/ERA15LA052.md): Dehavilland Tiger Moth DH 82A · Williamson, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 2014 · N28681 · Destroyed
  > The pilot’s failure to maintain airspeed while maneuvering, which led to the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall at an insufficient altitude to fully recover before collision with obstacles and terrain.
- [NTSB WPR15FA039](https://openairdocs.org/ntsb/WPR15FA039.md): Cessna 140A · Gilroy, CA · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2014 · N5612C · Substantial damage
  > The pilot’s failure to maintain clearance from power lines while flying at a low altitude. Contributing to the accident was the obscuration of the pilot’s visibility due to sun glare.
- [NTSB CEN15FA032](https://openairdocs.org/ntsb/CEN15FA032.md): Langston, Frederick L RV 4 · Boerne, TX · Accident · 1 fatal · Field investigation · Final report · Oct 28, 2014 · N70PM · Destroyed
  > A total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.
- [NTSB WPR15TA027](https://openairdocs.org/ntsb/WPR15TA027.md): Eurocopter AS 350 · Bisbee, AZ · Accident · Serious injuries · Final report · Oct 27, 2014 · N5204X · Substantial damage
  > Failure of maintenance personnel to ensure adequate torque of a pneumatic control pipe (P2) fitting, which resulted in a loss of engine power during low altitude flight maneuvers.
- [NTSB WPR15LA023](https://openairdocs.org/ntsb/WPR15LA023.md): Air Tractor AT 301 · Basin City, WA · Accident · No injuries · Limited investigation · Final report · Oct 27, 2014 · N8878S · Substantial damage
  > Maintenance personnel’s and the airplane owner’s failure to inspect the engine for cracks in the cylinders as required by an airworthiness directive, which resulted in the loss of engine power during low-altitude maneuvering flight.
- [NTSB WPR15LA024](https://openairdocs.org/ntsb/WPR15LA024.md): Extra Flugzeugproduktions-Und EA 300/L · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Oct 26, 2014 · N763DT · Substantial damage
  > The failure of the rudder cable due to tension overstress as a result of the cable’s strength being compromised by wear damage, which resulted in the flight instructor’s inability to maintain directional control during the landing roll.
- [NTSB WPR15FA021](https://openairdocs.org/ntsb/WPR15FA021.md): Slingsby T67M 260 · Ridgecrest, CA · Accident · 2 fatal · Field investigation · Final report · Oct 24, 2014 · N456FR · Substantial damage
  > The pilots' failure to recover from a spin for reasons that could not be determined based on available information. Contributing to the student's fatal injury was his delayed egress from the airplane below the specified egression altitude.
- [NTSB CEN15LA026](https://openairdocs.org/ntsb/CEN15LA026.md): Stephenson Stol CH 701 · Mount Vernon, IN · Accident · 1 fatal · Limited investigation · Final report · Oct 24, 2014 · N34WS · Substantial damage
  > The pilot’s impairment due to the ingestion of alcohol and sedating medications, which led to her improper decision to conduct low-level flight, affected her ability to safety operate the airplane, and resulted in her failure to maintain clearance from power…
- [NTSB CEN15CA025](https://openairdocs.org/ntsb/CEN15CA025.md): Robinson Helicopter R44 · Harper, TX · Accident · No injuries · Data collection · Final report · Oct 24, 2014 · N7192K · Substantial damage
  > The pilot's failure to maintain clearance from trees while maneuvering.
- [NTSB WPR15IA035](https://openairdocs.org/ntsb/WPR15IA035.md): North American P51 - D · Mesa, AZ · Incident · No injuries · Incident investigation · Final report · Oct 23, 2014 · N351BD · Minor damage
  > The failure of the left main landing gear to extend, which resulted in a gear-up landing. The reason for the left main landing gear’s failure to operate normally could not be determined because postincident examination of the landing gear system did not…
- [NTSB WPR15FA016](https://openairdocs.org/ntsb/WPR15FA016.md): Sonex Sonex Trigear · Fawnskin, CA · Accident · 1 fatal · Field investigation · Final report · Oct 20, 2014 · N91922 · Substantial damage
  > The pilot's failure to maintain airspeed after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall/spin at low altitude. Contributing to the accident was the airplane's reduced climb…
- [NTSB ERA15CA018](https://openairdocs.org/ntsb/ERA15CA018.md): Bell 206B · Prattville, AL · Accident · No injuries · Data collection · Final report · Oct 16, 2014 · N59541 · Substantial damage
  > The pilot's improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB WPR15GA005](https://openairdocs.org/ntsb/WPR15GA005.md): Marsh S 2F3AT · El Portal, CA · Accident · 1 fatal · Final report · Oct 7, 2014 · N449DF · Destroyed
  > The pilot's failure to maintain clearance from trees while maneuvering at a low altitude.
- [NTSB ERA15WA050](https://openairdocs.org/ntsb/ERA15WA050.md): Cessna A188B · Rozo, Colombia · Accident · No injuries · Foreign investigation · Oct 6, 2014 · HK-1746 · Substantial damage
- [NTSB ERA15CA010](https://openairdocs.org/ntsb/ERA15CA010.md): Toerner Bob SEA REY · Tampa, FL · Accident · No injuries · Data collection · Final report · Oct 6, 2014 · N345BT · Substantial damage
  > The pilot's failure to retract the landing gear after takeoff, which resulted in the landing gear contacting the water while maneuvering at low altitude.
- [NTSB CEN15LA004](https://openairdocs.org/ntsb/CEN15LA004.md): Celier Xenon R · Loma, CO · Accident · 2 fatal · Limited investigation · Final report · Oct 5, 2014 · N719MB · Substantial damage
  > The pilot’s failure to maintain clearance from a static wire and his decision to maneuver the gyroplane at low altitude.
- [NTSB ERA15CA005](https://openairdocs.org/ntsb/ERA15CA005.md): HPH 304CZ · Pikeville, TN · Accident · No injuries · Data collection · Final report · Oct 4, 2014 · N304AK · Substantial damage
  > A loss of aerodynamic lift, which resulted in an off-airport landing and subsequent impact with a pole.
- [NTSB CEN15CA005](https://openairdocs.org/ntsb/CEN15CA005.md): Cessna 152 · Arlington, TX · Accident · No injuries · Data collection · Final report · Oct 4, 2014 · N124RP · Substantial damage
  > The pilot's inadequate flight preparation and navigation during a training flight resulting in collision with low wires.
- [NTSB CEN15LA002](https://openairdocs.org/ntsb/CEN15LA002.md): Bell 206B · Woodsboro, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 2014 · N49746 · Substantial damage
  > The pilot’s failure to recognize and correct for flight conditions conducive to a loss of tail rotor effectiveness, which resulted in a rapid, uncommanded right yaw and subsequent hard landing.
- [NTSB CEN15CA001](https://openairdocs.org/ntsb/CEN15CA001.md): Piper PA 25-235 · Yankton, SD · Accident · No injuries · Data collection · Final report · Oct 1, 2014 · N6659Z · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB ERA14FA461](https://openairdocs.org/ntsb/ERA14FA461.md): Eagle R&D Helicycle · Gallatin, TN · Accident · 1 fatal · Field investigation · Final report · Sep 28, 2014 · N7062U · Substantial damage
  > The pilot's decision to fly the improperly balanced helicopter at high speed and low altitude, which resulted in a loss of control and collision with terrain. Contributing to the accident were the pilot's depression and resulting degradation of executive…
- [NTSB ERA14FA459](https://openairdocs.org/ntsb/ERA14FA459.md): Cessna 172M · Lancaster, NY · Accident · 2 fatal · Field investigation · Final report · Sep 27, 2014 · N9679H · 2 aircraft · Destroyed
  > The other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.
- [NTSB WPR14CA390](https://openairdocs.org/ntsb/WPR14CA390.md): William M Oprendek Pitts S1S · Sedona, AZ · Accident · No injuries · Data collection · Final report · Sep 25, 2014 · N93DB · Substantial damage
  > Failure of the tailwheel steering assembly during maneuvering flight, which resulted in a loss of directional control during the landing roll.
- [NTSB WPR14CA389](https://openairdocs.org/ntsb/WPR14CA389.md): Piper PA25 - 260 · Mokuleia, HI · Accident · No injuries · Data collection · Final report · Sep 24, 2014 · N8555L · Substantial damage
  > The pilot's improper preflight planning and reliance of fuel gauge readings, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN14LA507](https://openairdocs.org/ntsb/CEN14LA507.md): Manweiller Acro Sport II · Middletown, OH · Accident · 2 fatal · Limited investigation · Final report · Sep 20, 2014 · N94SM · Substantial damage
  > The failure of the flying pilot to maintain airplane control after an aerodynamic stall/spin occurred during the aerobatic maneuver following a reported intermittent loss of engine power for reasons that could not be determined during postaccident…

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

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

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