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

## Cases, newest first

- [NTSB WPR13FA017](https://openairdocs.org/ntsb/WPR13FA017.md): Cessna 182P · Yucca, AZ · Accident · 1 fatal · Field investigation · Final report · Oct 18, 2012 · N20939 · Substantial damage
  > The pilot’s failure to take corrective action to avoid terrain during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN13CA019](https://openairdocs.org/ntsb/CEN13CA019.md): Air Tractor AT-502B · Portales, NM · Accident · No injuries · Data collection · Final report · Oct 17, 2012 · N598LA · Substantial damage
  > The pilot’s failure to maintain clearance from power lines during an aerial application flight.
- [NTSB ERA13TA021](https://openairdocs.org/ntsb/ERA13TA021.md): Bell OH-58A · Jackson, TN · Accident · Minor injuries · Final report · Oct 13, 2012 · N40TN · Substantial damage
  > A loss of engine power for undetermined reasons because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB ERA13LA022](https://openairdocs.org/ntsb/ERA13LA022.md): Hughes/Helicopter Assocs 369A · West Chester, PA · Accident · No injuries · Limited investigation · Final report · Oct 13, 2012 · N546 · 2 aircraft · Substantial damage
  > The pilot’s failure to see and avoid the preceding helicopter while maneuvering for landing. Contributing to the accident were the flight lead pilot’s inadequate preflight briefing and in-flight instruction to the formation pilots, which resulted in the loss…
- [NTSB ANC13FA001](https://openairdocs.org/ntsb/ANC13FA001.md): Grumman G-44 · Aleknagik, AK · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2012 · N139F · Substantial damage
  > The pilot's decision to make multiple low passes over the glassy surface water, which resulted in an impact with the surface of the lake.
- [NTSB WPR13LA007](https://openairdocs.org/ntsb/WPR13LA007.md): Schleicher ASH25M · Kamuela, HI · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 2012 · N513WK · Substantial damage
  > The pilot’s failure to maintain control of the glider after it encountered atmospheric conditions while maneuvering where the lift was not sufficient to maintain flight, which resulted in a stall and impact with terrain during the subsequent approach to land.
- [NTSB ERA13WA156](https://openairdocs.org/ntsb/ERA13WA156.md): Cessna 172S · Izmir, Türkiye · Accident · 1 fatal · Foreign investigation · Oct 6, 2012 · TC-CBI · Substantial damage
  > On October 6, 2012, at 0915 Coordinated Universal Time (UTC), a Cessna 172S, Turkish registration TC-CBI, operated by the Turkish Aeronautical Association, impacted mountainous terrain during an instructional flight, near Izmir, Turkey. The flight instructor…
- [NTSB CEN13FA006](https://openairdocs.org/ntsb/CEN13FA006.md): Beech A36 · Mabank, TX · Accident · 4 fatal · Field investigation · Final report · Oct 6, 2012 · N32GP · Destroyed
  > The pilot's loss of airplane control while maneuvering in instrument meteorological conditions.
- [NTSB WPR13LA004](https://openairdocs.org/ntsb/WPR13LA004.md): Piper PA-28-161 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Oct 5, 2012 · N8115Q · 2 aircraft · Substantial damage
  > The failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.
- [NTSB WPR13WA014](https://openairdocs.org/ntsb/WPR13WA014.md): Robinson R22 · Halls Creek, Australia, Australia · Accident · 1 fatal · Foreign investigation · Oct 3, 2012 · VH-LLF · Substantial damage
  > On October 3, 2012, at about 1100 universal coordinated time, a Robinson Helicopter Company, R-22 Beta, VH-LLF, sustained substantial damage when it collided with the side of a canyon near the Halls Creek Aerodrome, Australia. The pilot was fatally injured.…
- [NTSB WPR13LA003](https://openairdocs.org/ntsb/WPR13LA003.md): Robinson Helicopter R22 Beta · Rockport, WA · Accident · No injuries · Limited investigation · Final report · Oct 3, 2012 · N80140 · Substantial damage
  > The pilot's failure to maintain sufficient rotor rpm during a precautionary landing, which resulted in a hard landing.
- [NTSB ERA13WA030](https://openairdocs.org/ntsb/ERA13WA030.md): Piper PA25 · Juquiá Municipality, Brazil · Accident · 1 fatal · Foreign investigation · Oct 3, 2012 · PT-DOX · Destroyed
  > On October 03, 2012, at 1100 universal coordinated time, a Piper PA-25-260, Brazilian registration PT-DOX, was destroyed when it impacted the ground and was consumed by fire after colliding with high-tension electric wires. The pilot was fatally injured. The…
- [NTSB ERA13WA085](https://openairdocs.org/ntsb/ERA13WA085.md): Thrush S2R-T34 · Naranjal, Ecuador · Accident · No injuries · Foreign investigation · Oct 2, 2012 · HC-CFU · Substantial damage
  > On October 2, 2012, a Thrush S2R-T34, Ecuadorian registration HC-CFU, operated by a private owner, was substantially damaged following an engine failure and collision with terrain near Naranjal Province, Guayas, Ecuador. The flight's last departure point and…
- [NTSB WPR12LA442](https://openairdocs.org/ntsb/WPR12LA442.md): Air Creation Tanarg · Safford, AZ · Accident · 1 fatal · Limited investigation · Final report · Sep 30, 2012 · N2751N · Substantial damage
  > The pilot’s failure to maintain airplane control while maneuvering in high wind conditions and his failure to adjust the trim appropriately. Contributing to the accident was the airplane’s nonstandard modified wing configuration.
- [NTSB CEN12LA669](https://openairdocs.org/ntsb/CEN12LA669.md): Robinson Helicopter R44 · Nocona, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 2012 · N8341W · Substantial damage
  > The noncertificated pilot’s operation of the helicopter, which resulted in impact with the water.
- [NTSB CEN12FA670](https://openairdocs.org/ntsb/CEN12FA670.md): Agusta A109E · Eastland, TX · Accident · Serious injuries · Field investigation · Final report · Sep 30, 2012 · N144CF · Substantial damage
  > The loss of helicopter control after an in-flight upset, which occurred when the pilot selected the autopilot’s altitude hold mode; the reason for the reported in-flight control anomaly could not be determined during postaccident helicopter examinations.…
- [NTSB ERA12LA578](https://openairdocs.org/ntsb/ERA12LA578.md): Cessna 172B · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · Sep 23, 2012 · N8059X · Substantial damage
  > The pilot’s suicidal act.
- [NTSB WPR12LA426](https://openairdocs.org/ntsb/WPR12LA426.md): Bell 206 - B · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · Sep 19, 2012 · N222GR · Destroyed
  > The pilot’s inability to maintain sufficient main rotor rpm while maneuvering in high density altitude conditions, which resulted in a precautionary landing and subsequent rollover.
- [NTSB CEN12LA650](https://openairdocs.org/ntsb/CEN12LA650.md): Hiller UH-12B · Rio Vista, TX · Accident · No injuries · Limited investigation · Final report · Sep 19, 2012 · N94735 · Substantial damage
  > The catastrophic failure and disintegration of the No. 6 engine piston, which resulted in a total loss of engine power.
- [NTSB ANC12LA107](https://openairdocs.org/ntsb/ANC12LA107.md): Piper PA-22-160 · Talkeetna, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 2012 · N8433D · Substantial damage
  > The flight instructor's failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an inadvertent stall.
- [NTSB WPR12LA428](https://openairdocs.org/ntsb/WPR12LA428.md): Rockwell International 690A · Ellensburg, WA · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 2012 · N57112 · Substantial damage
  > The pilot’s failure to avoid a turbulent smoke column, which resulted in an overstress failure of the left aileron control rod.
- [NTSB ERA12FA565](https://openairdocs.org/ntsb/ERA12FA565.md): Yakovlev YAK 52 · Brownsboro, AL · Accident · 2 fatal · Field investigation · Final report · Sep 16, 2012 · N2207X · Substantial damage
  > The pilot's loss of control while performing a low-level aerobatic maneuver, which resulted in collision with terrain.
- [NTSB WPR12FA421](https://openairdocs.org/ntsb/WPR12FA421.md): Frederick F 1 · Reno, NV · Accident · No injuries · Field investigation · Final report · Sep 14, 2012 · N158CF · Substantial damage
  > The pilot’s operation of the airplane above the established never-exceed speed and the incorrect installation of the trim tab control horn, which resulted in the flutter of the left elevator trim tab.
- [NTSB ERA12FA561](https://openairdocs.org/ntsb/ERA12FA561.md): Hall Don H RV-7 · Cumming, GA · Accident · 2 fatal · Field investigation · Final report · Sep 13, 2012 · N517DG · Substantial damage
  > The pilot’s failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and collision with terrain.
- [NTSB CEN12FA628](https://openairdocs.org/ntsb/CEN12FA628.md): Piper PA-23-250 · Bullard, TX · Accident · 1 fatal · Field investigation · Final report · Sep 12, 2012 · N4842P · Substantial damage
  > The pilot's maneuver, which exceeded the airplane's structural limit and resulted in an in-flight breakup.
- [NTSB WPR12LA410](https://openairdocs.org/ntsb/WPR12LA410.md): Schoepflin DA-4-550 · Viola, ID · Accident · 1 fatal · Limited investigation · Final report · Sep 9, 2012 · N550YS · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering, resulting in an aerodynamic stall/spin with insufficient altitude to recover.
- [NTSB CEN12LA623](https://openairdocs.org/ntsb/CEN12LA623.md): Piper PA-28RT-201 · Gilmer, TX · Accident · No injuries · Limited investigation · Final report · Sep 9, 2012 · N2878V · Substantial damage
  > The partial loss of engine power due to the loss of cylinder compression. The loss of cylinder compression was the result of the No. 3 piston ring failure due to excessive heat because of the lean fuel mixture from a partially clogged fuel nozzle.
- [NTSB WPR12LA409](https://openairdocs.org/ntsb/WPR12LA409.md): Great Lakes 2T-1A-2 · Monroe, WA · Accident · No injuries · Limited investigation · Final report · Sep 8, 2012 · N3702F · Substantial damage
  > A loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12LA407](https://openairdocs.org/ntsb/WPR12LA407.md): Moore Edward R MXS · Borrego Springs, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 8, 2012 · N21MX · Substantial damage
  > The pilot’s inability to maintain control of the airplane following the loss of aileron and elevator control due to the forward flight control torque tube assembly’s detachment from the forward bearing. Contributing to the accident was the inadequate…
- [NTSB WPR12CA405](https://openairdocs.org/ntsb/WPR12CA405.md): Robinson Helicopter R22 Beta · Lake Newman, WA · Accident · No injuries · Data collection · Final report · Sep 7, 2012 · N212SH · Substantial damage
  > The flight instructor's failure to maintain clearance from terrain while correcting for the student pilot's failure to maintain directional control of the helicopter.
- [NTSB CEN12LA615](https://openairdocs.org/ntsb/CEN12LA615.md): Goodyear F2G · Valley City, ND · Accident · 1 fatal · Limited investigation · Final report · Sep 7, 2012 · N5577N · Substantial damage
  > The pilot’s decision to initiate the aerobatic maneuver at an altitude that did not allow for full recovery of the airplane before ground impact.
- [NTSB CEN12LA622](https://openairdocs.org/ntsb/CEN12LA622.md): Piper PA-25-235 · Jasper, MO · Accident · No injuries · Limited investigation · Final report · Sep 6, 2012 · N7655Z · Substantial damage
  > The total loss of engine power due to separation of a carburetor air box support bracket and subsequent airflow obstruction to the carburetor.
- [NTSB WPR12FA395](https://openairdocs.org/ntsb/WPR12FA395.md): Skykits USA Savannah ADV · Murtaugh, ID · Accident · 1 fatal · Field investigation · Final report · Sep 3, 2012 · N9764J · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at or above the airplane's maximum ceiling, which resulted in a stall and a subsequent loss of airplane control. Contributing to the accident was the pilot's decision to operate the airplane…
- [NTSB ANC12LA097](https://openairdocs.org/ntsb/ANC12LA097.md): Piper PA-18-150 · Coldfoot, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 2012 · N82016 · Substantial damage
  > The pilot's failure to maintain clearance from terrain while maneuvering to reverse course.
- [NTSB WPR12CA387](https://openairdocs.org/ntsb/WPR12CA387.md): Croman SH-3H · Covelo, CA · Accident · No injuries · Data collection · Final report · Sep 1, 2012 · N611CK · Substantial damage
  > The pilot’s failure to maintain clearance from a tree during an aerial firefighting flight.
- [NTSB ERA12LA541](https://openairdocs.org/ntsb/ERA12LA541.md): Johnston Douglas S Safari · McVeytown, PA · Accident · 1 fatal · Limited investigation · Final report · Sep 1, 2012 · N70415 · Substantial damage
  > The pilot's lack of proficiency and certification, which resulted in his failure to enter an autorotation when the engine lost power. Contributing to the accident was the pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a subsequent…
- [NTSB CEN12LA655](https://openairdocs.org/ntsb/CEN12LA655.md): TL Ultralight Sro Stingsport · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Sep 1, 2012 · N898N · Substantial damage
  > The failure of the wood propeller blades in flight. Contributing to the accident was the owner/operator’s failure to complete required inspections on the propeller within the specified interval, which reduced the likelihood of detecting the cracks and may…
- [NTSB CEN12LA602](https://openairdocs.org/ntsb/CEN12LA602.md): Aero Vodochody L39C · Davenport, IA · Accident · 1 fatal · Limited investigation · Final report · Sep 1, 2012 · N139GS · Destroyed
  > The loss of airplane control for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded operation.
- [NTSB CEN12FA594](https://openairdocs.org/ntsb/CEN12FA594.md): Piper PA-12 · Rye, CO · Accident · 2 fatal · Field investigation · Final report · Aug 31, 2012 · N3031M · Substantial damage
  > The pilot’s selection of a flightpath toward rising terrain that exceeded the climb capability of the airplane.
- [NTSB CEN12CA603](https://openairdocs.org/ntsb/CEN12CA603.md): Flight Design Ctls · Pittsford, MI · Accident · Minor injuries · Data collection · Final report · Aug 31, 2012 · N995LS · Substantial damage
  > The student pilot’s failure to maintain directional control of the airplane while maneuvering at a low altitude.
- [NTSB ERA12CA546](https://openairdocs.org/ntsb/ERA12CA546.md): Cessna 172M · Bardstown, KY · Accident · No injuries · Data collection · Final report · Aug 30, 2012 · N21214 · Substantial damage
  > The flight instructor's decision to turn the fuel selector to the off position and his delayed remedial actions to restart the engine, which resulted in fuel starvation and a subsequent forced landing.
- [NTSB CEN12LA589](https://openairdocs.org/ntsb/CEN12LA589.md): Air Tractor AT-301 · Ralls, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 2012 · N23960 · Substantial damage
  > The total loss of engine power due to a fatigue failure of the rocker arm journal casting of the rocker arm cap.
- [NTSB CEN12CA631](https://openairdocs.org/ntsb/CEN12CA631.md): Powrachute Pegasus · Luling, TX · Accident · No injuries · Data collection · Final report · Aug 28, 2012 · N554E · Substantial damage
  > Collision with a powerline resulting from the pilot's not maintaining adequate clearance while on a day VFR approach to land.
- [NTSB WPR12LA371](https://openairdocs.org/ntsb/WPR12LA371.md): Arrow Falcon Exporters OH58 · Escalon, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 27, 2012 · N503DR · Substantial damage
  > The pilot’s failure to maintain clearance from trees during a low-altitude agricultural application, which resulted in a loss of control and impact with the ground.
- [NTSB CEN12CA588](https://openairdocs.org/ntsb/CEN12CA588.md): Trick Trikes Stss · Wanamingo, MN · Accident · Minor injuries · Data collection · Final report · Aug 26, 2012 · N5152E · Substantial damage
  > The pilot's failure to maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.
- [NTSB ERA12LA528](https://openairdocs.org/ntsb/ERA12LA528.md): Schleicher ASW-19 · Dansville, NY · Accident · 1 fatal · Limited investigation · Final report · Aug 25, 2012 · N438AS · Substantial damage
  > The pilot’s failure to maintain glider control while maneuvering. Contributing to the accident was the pilot’s impairment due to an over-the-counter sedating antihistamine.
- [NTSB ERA12FA527](https://openairdocs.org/ntsb/ERA12FA527.md): Bell 407 · Abingdon, VA · Accident · 1 fatal · Field investigation · Final report · Aug 25, 2012 · N407N · Substantial damage
  > The pilot's improper decision to make a low-level departure over water in dark night conditions without lights, which resulted in controlled flight into the water. Contributing to the accident was the pilot's likely spatial disorientation due to a vestibular…
- [NTSB ERA12WA534](https://openairdocs.org/ntsb/ERA12WA534.md): Gulfstream G-164B · Calabozo, Venezuela · Accident · 1 fatal · Foreign investigation · Aug 24, 2012 · YV264A · Substantial damage
  > On August 24, 2012, about 2000 universal coordinated time, a Gulfstream G-164B, Venezuelan registration YV264A, registered to Fumiwan C.A, was substantially damaged when it impacted terrain during an aerial application. The pilot was fatally injured. The…
- [NTSB CEN12LA578](https://openairdocs.org/ntsb/CEN12LA578.md): Destiny XLT · Hart, MI · Accident · 2 fatal · Limited investigation · Final report · Aug 24, 2012 · N1674A · Substantial damage
  > The partial deflation of the powered parachute canopy when the pilot flew the aircraft into an area with gusty wind conditions. Contributing to the accident were the modifications that changed the flying characteristics of the parachute.
- [NTSB WPR12TA364](https://openairdocs.org/ntsb/WPR12TA364.md): American Eurocopter AS350B3 · Sunburst, MT · Accident · No injuries · Final report · Aug 18, 2012 · N3939A · Substantial damage
  > The improper installation of the engine-to-main gearbox flex coupling, which resulted in the failure of the flex coupling and a loss of power to the rotor system during takeoff.

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

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

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