# 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 47 of 377 · 18,849 cases

## Cases, newest first

- [NTSB ERA14CA126](https://openairdocs.org/ntsb/ERA14CA126.md): Schempp-Hirth Ventus 2B · Burnsville, NC · Accident · Serious injuries · Data collection · Final report · Feb 18, 2014 · N411SD · Substantial damage
  > The pilot's improper use of the spoilers, which resulted in an uncontrolled descent and subsequent impact with trees.
- [NTSB CEN14FA140](https://openairdocs.org/ntsb/CEN14FA140.md): Hillam Scott L Rans S 10 · Shepherd, TX · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2014 · N3000V · Destroyed
  > The noncertificated pilot’s improper decision to attempt aerobatic maneuvers that exceeded the airplane’s design limitations, which resulted in the subsequent in-flight breakup of the airplane. Contributing to the accident was the pilot’s lack of aerobatic…
- [NTSB CEN14CA142](https://openairdocs.org/ntsb/CEN14CA142.md): Robinson Helicopter R44 II · Bonham, TX · Accident · No injuries · Data collection · Final report · Feb 14, 2014 · N494SH · Substantial damage
  > The pilot's inadequate recovery from a loss of tail rotor effectiveness during a low altitude downwind hover in a gusty wind condition resulting in the helicopter contacting the ground and rolling over.
- [NTSB CEN14FA122](https://openairdocs.org/ntsb/CEN14FA122.md): Bell 206L 3 · Silt, CO · Accident · 3 fatal · Field investigation · Final report · Jan 27, 2014 · N207DS · Destroyed
  > The pilot’s inadequate preflight planning for a low-level aerial surveillance flight of power transmission lines, which led to his being unaware of the crossing power line while flying toward the sun and his subsequent failure to maintain sufficient clearance…
- [NTSB CEN14GA109](https://openairdocs.org/ntsb/CEN14GA109.md): American Eurocopter AS350B3 · Encino, TX · Accident · Serious injuries · Final report · Jan 10, 2014 · N3948A · Substantial damage
  > The pilot’s failure to maintain directional control while maneuvering, which resulted in a loss of tail rotor effectiveness. Contributing to the accident were the pilot’s limited experience in the operating environment and lack of formal mission training.
- [NTSB CEN14LA103](https://openairdocs.org/ntsb/CEN14LA103.md): Bell 430 · West Delta 109 · Accident · No injuries · Limited investigation · Final report · Jan 5, 2014 · N430CT · Substantial damage
  > The pilot’s failure to maintain tail rotor clearance from a handrail on a crane davit on an oil platform during landing.
- [NTSB WPR14LA080](https://openairdocs.org/ntsb/WPR14LA080.md): Cessna 172N · Pacoima, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 2013 · N4936D · Substantial damage
  > The flight instructor’s inadequate compensation for the gusting crosswind conditions during landing, which resulted in a loss of airplane control.
- [NTSB WPR14FA078](https://openairdocs.org/ntsb/WPR14FA078.md): Cessna 172K · Fresno, CA · Accident · 2 fatal · Field investigation · Final report · Dec 27, 2013 · N251JM · Destroyed
  > The pilot’s failure to maintain adequate clearance from trees while on approach, which subsequently led to a loss of airplane control. Also causal was the pilot’s continued operation of the airplane at night with a diagnosed medical condition that degraded…
- [NTSB WPR14WA072](https://openairdocs.org/ntsb/WPR14WA072.md): Hughes 369E · Lake Ross, New Zealand, New Zealand · Accident · 1 fatal · Foreign investigation · Dec 15, 2013 · ZK-HNA · Destroyed
  > On December 15, 2013, at 0400 universal coordinated time, a Hughes 369E, ZK-HNA, collided with terrain under unknown circumstances near Lake Ross, South Island, New Zealand. The flight was operated by Milford Helicopters under the pertinent civil regulations…
- [NTSB CEN14FA084](https://openairdocs.org/ntsb/CEN14FA084.md): Piper PA 24-250 · Collbran, CO · Accident · 3 fatal · Field investigation · Final report · Dec 12, 2013 · N8037P · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.
- [NTSB WPR14LA062](https://openairdocs.org/ntsb/WPR14LA062.md): Hiller UH 12E · Chowchilla, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 2013 · N36MV · Substantial damage
  > The failure of the torsional drive coupling, which resulted in a loss of drive to the main rotor system during low-altitude flight.
- [NTSB ERA14LA057](https://openairdocs.org/ntsb/ERA14LA057.md): Piper PA-28-161 · Elkmont, AL · Accident · 1 fatal · Limited investigation · Final report · Nov 30, 2013 · N8878E · Destroyed
  > A stuck exhaust valve, which resulted in a total loss of engine power at low altitude. Contributing to the accident were the pilot’s decision to fly at a low altitude, which reduced his forced landing options when the loss of engine power occurred; and poor…
- [NTSB CEN14FA072](https://openairdocs.org/ntsb/CEN14FA072.md): Biesemeier David I Smyth Sidewinder · Boulder, CO · Accident · 1 fatal · Field investigation · Final report · Nov 27, 2013 · N3786A · Destroyed
  > The pilot’s abrupt maneuver, which exceeded the structural limits of the left wing and resulted in its in-flight separation.
- [NTSB CEN14LA056](https://openairdocs.org/ntsb/CEN14LA056.md): Pearson Jon M Dragonfly · Anahuac, TX · Accident · 1 fatal · Limited investigation · Final report · Nov 16, 2013 · N975DF · Destroyed
  > The incorrect installation by the pilot, who was not a certificated mechanic or repairman, of the main rotor head bearing block, which resulted in the in-flight separation of the rotor head.
- [NTSB CEN14LA066](https://openairdocs.org/ntsb/CEN14LA066.md): Quad City Challenger I · Winsted, MN · Accident · No injuries · Limited investigation · Final report · Nov 12, 2013 · UNREG · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering for a precautionary landing after the light sport airplane started vibrating, which led to an inadvertent aerodynamic stall.
- [NTSB WPR14CA048](https://openairdocs.org/ntsb/WPR14CA048.md): Maule MX 7-235 · San Ynez, CA · Accident · No injuries · Data collection · Final report · Nov 11, 2013 · N88CR · Substantial damage
  > The pilot's failure to maintain terrain clearance while maneuvering at low altitude in hilly terrain.
- [NTSB CEN14FA046](https://openairdocs.org/ntsb/CEN14FA046.md): Mitsubishi MU 2B-25 · Owasso, OK · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2013 · N856JT · Destroyed
  > The pilot's loss of airplane control during a known one-engine-inoperative condition. The reasons for the loss of control and engine shutdown could not be determined because the airplane was not equipped with a crash-resistant recorder and postaccident…
- [NTSB CEN14LA048](https://openairdocs.org/ntsb/CEN14LA048.md): Eurocopter Deutschland EC135P1 · Shreveport, LA · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 2013 · N911KB · Substantial damage
  > The mechanic's improper installation of the antitorque pedals, which resulted in an in-flight loss of helicopter control.
- [NTSB WPR14FA044](https://openairdocs.org/ntsb/WPR14FA044.md): Cessna U206F · Donnelly, ID · Accident · 3 fatal · Field investigation · Final report · Nov 6, 2013 · N206KL · Destroyed
  > The pilot's failure to maintain clearance from terrain while maneuvering in likely low-ceiling and low-visibility conditions in mountainous terrain.
- [NTSB WPR14CA041](https://openairdocs.org/ntsb/WPR14CA041.md): Bell 206B · Superior, MT · Accident · No injuries · Data collection · Final report · Nov 2, 2013 · N888DR · Substantial damage
  > The pilot's failure to maintain aircraft control while maneuvering during a long-line operation.
- [NTSB CEN14FA034](https://openairdocs.org/ntsb/CEN14FA034.md): Piper PA 23-250 · Caledonia, MN · Accident · 3 fatal · Field investigation · Final report · Nov 1, 2013 · N6068Y · Substantial damage
  > The pilot's loss of control for reasons that could not be determined because the postaccident airplane examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR14FA037](https://openairdocs.org/ntsb/WPR14FA037.md): Musick Lancair 235 · McMinnville, OR · Accident · 1 fatal · Field investigation · Final report · Oct 28, 2013 · N25DM · Substantial damage
  > The pilot's failure to maintain airplane control while intentionally performing maneuvers in an effort to troubleshoot a landing gear malfunction.
- [NTSB CEN14FA024](https://openairdocs.org/ntsb/CEN14FA024.md): Bellanca 14-19-3A · Boerne, TX · Accident · 1 fatal · Field investigation · Final report · Oct 27, 2013 · N11RC · Destroyed
  > A defective exhaust system that allowed carbon monoxide to enter the cabin and impair the pilot, rendering him unable to control the airplane.
- [NTSB ERA14CA032](https://openairdocs.org/ntsb/ERA14CA032.md): Beech V35B · Palm Coast, FL · Accident · No injuries · Data collection · Final report · Oct 26, 2013 · N328HR · Substantial damage
  > An inadvertent collision with a black vulture.
- [NTSB CEN14WA060](https://openairdocs.org/ntsb/CEN14WA060.md): Robinson R22 - Alpha · Torreilles, France · Accident · No injuries · Class 5 · Foreign · Oct 26, 2013 · F-GPKA · Substantial damage
  > On October 26, 2013, at 1226 UTC, a Robinson R22 helicopter, French registration, F-GPKA, collided with the terrain during an autorotation following a loss of power in Torreilles, France. The pilot and passenger were not injured. The helicopter was…
- [NTSB WPR14WA034](https://openairdocs.org/ntsb/WPR14WA034.md): Lancair Legacy · Shepparton, Australia · Accident · 2 fatal · Foreign investigation · Oct 25, 2013 · VH-ICZ · Substantial damage
  > On October 25, 2013 about 1410 local time, an amateur built Lancair Legacy airplane, Australian registration VH-ICZ, collided with terrain near Shepparton, Australia. The airplane sustained substantial damage and the pilot and passenger were fatally injured.…
- [NTSB WPR14WA029](https://openairdocs.org/ntsb/WPR14WA029.md): PZL Okecie M18 · Ulladulla, Australia · Accident · 1 fatal · Foreign investigation · Oct 24, 2013 · VH-TZJ · Substantial damage
  > On October 24, 2013 about 1000 local time, a PZL M18A Dromader aircraft, Australian registration VH-TZJ, collided with terrain near Ulladulla, Australia. The airplane was substantially damaged and the pilot was fatally injured. The airplane was operated as an…
- [NTSB WPR14WA032](https://openairdocs.org/ntsb/WPR14WA032.md): Cessna 182 - Q · Mount Hotham, Australia · Accident · 1 fatal · Foreign investigation · Oct 23, 2013 · VH - KKM · Substantial damage
  > On October 23, 2013 about 1130 local time, a Cessna 182Q airplane, Australian registration VH-KKM, collided with terrain near Mount Hotham, Australia. The airplane sustained substantial damage and the pilot was fatally injured. The airplane was operated as a…
- [NTSB ERA14FA010](https://openairdocs.org/ntsb/ERA14FA010.md): Eurocopter AS 350 B3 · Somerville, TN · Accident · 3 fatal · Field investigation · Final report · Oct 22, 2013 · N353HW · Destroyed
  > The pilot’s inadvertent encounter with night, instrument meteorological conditions while responding to an obstacle alert, resulting in an in-flight loss of helicopter control.
- [NTSB ERA14WA036](https://openairdocs.org/ntsb/ERA14WA036.md): Piper PA-34-200 · Marica, Brazil · Accident · 2 fatal · Foreign investigation · Oct 21, 2013 · PT-KGK · Destroyed
  > On October 21, 2013, about 1840 universal coordinated time (UTC), a Piper PA-34-200, Brazilian registration PT-KGK, while on a local training flight, impacted in a lagoon, after a loss of control, in Marica Municipality – State of Rio de Janeiro, Brazil. The…
- [NTSB CEN14FA019](https://openairdocs.org/ntsb/CEN14FA019.md): Piper PA 28-140 · Talihina, OK · Accident · 1 fatal · Field investigation · Final report · Oct 21, 2013 · N113WS · Destroyed
  > The pilot’s lack of weather planning and his continued flight into an area of known rain with reduced visibility and his subsequent failure to maintain clearance with trees.
- [NTSB CEN14FA014](https://openairdocs.org/ntsb/CEN14FA014.md): Piper PA 32R-301 · Huntsville, AR · Accident · 2 fatal · Field investigation · Final report · Oct 21, 2013 · N888TP · Destroyed
  > The noninstrument-rated pilot’s continued flight into an area of known rain with reduced visibility and his failure to maintain airplane control while maneuvering the airplane after entering these conditions.
- [NTSB CEN14CA039](https://openairdocs.org/ntsb/CEN14CA039.md): Wohaska John Parsons Stiles Gyro · Festus, MO · Accident · Minor injuries · Data collection · Final report · Oct 20, 2013 · N7064U · Substantial damage
  > The pilot's improper propeller adjustment, which resulted in decreased performance and a loss of aircraft control.
- [NTSB WPR14WA030](https://openairdocs.org/ntsb/WPR14WA030.md): Ayres S2R · Wave Rock, Australia · Accident · 1 fatal · Foreign investigation · Oct 18, 2013 · VH-JAY · Destroyed
  > On October 18, 2013 about 1500 local time, an Ayres S2R airplane, Australian registration VH-JAY, collided with terrain near Wave Rock, Australia. The airplane was destroyed and the pilot was fatally injured. The airplane was operated as an agricultural…
- [NTSB WPR14CA016](https://openairdocs.org/ntsb/WPR14CA016.md): Champion 7ECA · Willows, CA · Accident · No injuries · Data collection · Final report · Oct 12, 2013 · N9599S · Substantial damage
  > The pilot's failure to maintain sufficient altitude while flying low over a field which resulted in a loss of aircraft control and collision with terrain.
- [NTSB WPR14LA014](https://openairdocs.org/ntsb/WPR14LA014.md): Bell Helicopter Textron 206L 1 · Seeley, CA · Accident · No injuries · Limited investigation · Final report · Oct 11, 2013 · N206KK · Destroyed
  > The total loss of engine power due to the failure of the No. 4 bearing.
- [NTSB WPR14FA012](https://openairdocs.org/ntsb/WPR14FA012.md): Mooney M20E · Julian, CA · Accident · 2 fatal · Field investigation · Final report · Oct 9, 2013 · N7145U · Destroyed
  > The pilot’s failure to maintain clearance from terrain while maneuvering to avoid clouds in mountainous terrain.
- [NTSB CEN14LA003](https://openairdocs.org/ntsb/CEN14LA003.md): Kenneth M Franz Ultra PUP · Belleville, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 2013 · N106KF · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and his exceedance of the airplane's critical angle-of-attack while turning back to the airport instead of landing straight ahead following a partial loss of engine power, which resulted in an aerodynamic…
- [NTSB WPR14LA008](https://openairdocs.org/ntsb/WPR14LA008.md): Mcdonnell Douglas Heli 369 · Paducah, TX · Accident · 1 fatal · Limited investigation · Final report · Oct 6, 2013 · N530KF · Substantial damage
  > The pilot’s failure to maintain clearance from a power transmission line tower while maneuvering to pick up a rope in gusting wind conditions.
- [NTSB WPR14LA007](https://openairdocs.org/ntsb/WPR14LA007.md): Piper PA32 - 300 · Tinian Island · Accident · 3 fatal · Limited investigation · Final report · Oct 6, 2013 · N4089W · Destroyed
  > The pilot’s failure to maintain terrain clearance while maneuvering at low altitude in dark night conditions.
- [NTSB ERA14LA008](https://openairdocs.org/ntsb/ERA14LA008.md): Cessna 172 - F · Gainesville, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 2013 · N8715U · Substantial damage
  > A total loss of engine power for reasons that could not be determined because a postaccident engine examination and test run revealed no anomalies.
- [NTSB WPR14LA005](https://openairdocs.org/ntsb/WPR14LA005.md): Cessna 340A · Paulden, AZ · Accident · 4 fatal · Limited investigation · Final report · Oct 4, 2013 · N312GC · Substantial damage
  > The pilot’s failure to maintain sufficient altitude to clear a radio tower while maneuvering at low altitude and his decision to make a high-speed, low pass over the gun club.
- [NTSB WPR14CA003](https://openairdocs.org/ntsb/WPR14CA003.md): Air Tractor AT 402B · Wellton, AZ · Accident · No injuries · Data collection · Final report · Oct 2, 2013 · N402TR · Substantial damage
  > The pilot’s distracted attention and failure to maintain sufficient altitude to clear terrain while maneuvering in dark night conditions.
- [NTSB CEN14CA017](https://openairdocs.org/ntsb/CEN14CA017.md): Robinson R22 - Beta · Chicago, IL · Accident · No injuries · Data collection · Final report · Oct 2, 2013 · N554SA · Substantial damage
  > The flight instructor's failure to take remedial action in a timely manner.
- [NTSB WPR13LA429](https://openairdocs.org/ntsb/WPR13LA429.md): Texas Helicopter OH-13E/M74 · Santa Maria, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 2013 · N38113 · Substantial damage
  > The pilot's inadequate monitoring of the environment and failure to maintain clearance from transmission wires during a low-altitude maneuver.
- [NTSB ERA13LA434](https://openairdocs.org/ntsb/ERA13LA434.md): Timothy J Cowper Pitts Special S-1E · Edinburg, NY · Accident · 1 fatal · Limited investigation · Final report · Sep 29, 2013 · N85AT · Destroyed
  > The pilot’s failure to maintain adequate airspeed during low-altitude maneuvering, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB WPR13LA420](https://openairdocs.org/ntsb/WPR13LA420.md): Miller RV6 · Williams, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 24, 2013 · N67GM · Destroyed
  > The pilot's improper decision to fly at a low altitude, which resulted in his failure to maintain clearance from power lines.
- [NTSB ERA13FA424](https://openairdocs.org/ntsb/ERA13FA424.md): Brown Robert K RV7A · Hamilton Township, NJ · Accident · 1 fatal · Field investigation · Final report · Sep 20, 2013 · N174BK · Destroyed
  > The pilot's improper aerobatic maneuver that resulted in a loss of control, exceedance of the airplane's design limitations, and a subsequent in-flight breakup of the airplane.
- [NTSB WPR13WA415](https://openairdocs.org/ntsb/WPR13WA415.md): Lancair 360 - NO Series · Shenyang, China · Accident · 2 fatal · Foreign investigation · Sep 17, 2013 · C-FXCK · Substantial damage
  > On September 17, 2013 about 0523 Universal Time, an experimental amateur-built Lancair, Canadian registration C-FXCK, collided with terrain while maneuvering near Shenyang, Liaoning Province, China. The airplane was participating in an aerobatic exhibition…
- [NTSB WPR13FA411](https://openairdocs.org/ntsb/WPR13FA411.md): Bell UH 1B · Detroit, OR · Accident · 1 fatal · Field investigation · Final report · Sep 16, 2013 · N204UH · Substantial damage
  > The fatigue failure of the upper two tailboom attachment points, which resulted in the tailboom separating from the fuselage during logging operations. Contributing to the accident was poor maintenance throughout the helicopter’s operational life.

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

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

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