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

## Cases, newest first

- [NTSB CEN12LA296](https://openairdocs.org/ntsb/CEN12LA296.md): Maule M-7-420AC · Hanover Township, MI · Accident · Minor injuries · Limited investigation · Final report · May 13, 2012 · N420RP · Substantial damage
  > A total loss of engine power for reasons that could not be determined during an exhaustive postaccident examination of the engine and its components.
- [NTSB CEN12CA294](https://openairdocs.org/ntsb/CEN12CA294.md): Beckert Bruce A RV-6 · Au Gres, MI · Accident · Serious injuries · Data collection · Final report · May 13, 2012 · N212LB · Substantial damage
  > The pilot’s low altitude maneuvering, which resulted in an inadvertent stall and subsequent impact with the water.
- [NTSB WPR12LA200](https://openairdocs.org/ntsb/WPR12LA200.md): Champion 7GC · Rexburg, ID · Accident · No injuries · Limited investigation · Final report · May 12, 2012 · N4861E · Substantial damage
  > A decrease in indicated oil pressure while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Also causal was the pilot’s failure to…
- [NTSB WPR12LA205](https://openairdocs.org/ntsb/WPR12LA205.md): Infinity 2000 · Hurricane, UT · Accident · Serious injuries · Limited investigation · Final report · May 11, 2012 · N541KP · Substantial damage
  > The pilot's decision to fly at a low altitude in a canyon, which resulted in insufficient altitude to recover from an encounter with terrain-induced turbulence.
- [NTSB CEN12FA291](https://openairdocs.org/ntsb/CEN12FA291.md): Beech V35B · Las Vegas, NM · Accident · 1 fatal · Field investigation · Final report · May 11, 2012 · N645EP · Substantial damage
  > The pilot’s loss of airplane control for reasons that could not be determined because postaccident examination revealed no evidence of preimpact anomalies that would have precluded normal operation.
- [NTSB CEN12LA289](https://openairdocs.org/ntsb/CEN12LA289.md): Robinson Helicopter R44 II · Grants, NM · Accident · No injuries · Limited investigation · Final report · May 10, 2012 · N7523S · Substantial damage
  > The loss of engine power due to an excessively rich fuel mixture that occurred during operations at idle power settings at a high density altitude. Contributing to the accident was the flight instructor’s poor decision-making in choosing to practice an…
- [NTSB CEN12LA282](https://openairdocs.org/ntsb/CEN12LA282.md): Bell 206B-III · Flora, IN · Accident · No injuries · Limited investigation · Final report · May 9, 2012 · N1069Z · Substantial damage
  > The pilot allowed the helicopter to settle with power.
- [NTSB WPR12LA198](https://openairdocs.org/ntsb/WPR12LA198.md): Cessna 177A · Hanksville, UT · Accident · Minor injuries · Limited investigation · Final report · May 8, 2012 · N28WF · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude in high density altitude conditions, which resulted in the airplane’s inability to climb or maintain clearance from terrain.
- [NTSB CEN12LA267](https://openairdocs.org/ntsb/CEN12LA267.md): Bell 206B · Valley Falls, KS · Accident · Minor injuries · Limited investigation · Final report · May 2, 2012 · N85RB · Substantial damage
  > The pilot’s inadequate compensation for the wind conditions during a hover maneuver, which resulted in a loss of tail rotor effectiveness.
- [NTSB WPR12LA190](https://openairdocs.org/ntsb/WPR12LA190.md): Cessna T210 · Elberta, UT · Accident · Serious injuries · Limited investigation · Final report · May 1, 2012 · N210LH · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12WA197](https://openairdocs.org/ntsb/WPR12WA197.md): Cessna 150 · Bourke, Australia, Australia · Accident · 1 fatal · Foreign investigation · Apr 29, 2012 · VH-UWR · Substantial damage
  > On April 29, 2012, at 0800 universal coordinated time, a Cessna 150M, VH-UWR, collided with the terrain during a mustering operation near Bourke, Australia. The airplane was operated by a private individual under the pertinent civil regulations of Australia.…
- [NTSB ERA12LA318](https://openairdocs.org/ntsb/ERA12LA318.md): Temco GC-1B · Dayton, TN · Accident · Minor injuries · Limited investigation · Final report · Apr 29, 2012 · N106S · Substantial damage
  > A partial loss of engine power during low-altitude maneuvers for reasons that could not be determined because the engine examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation; however the carburetor was…
- [NTSB CEN12CA269](https://openairdocs.org/ntsb/CEN12CA269.md): Eurocopter AS 350 B2 · Hugo, OK · Accident · No injuries · Data collection · Final report · Apr 29, 2012 · N406EM · Substantial damage
  > The pilot’s inadequate collective control inputs while performing a hovering autorotation, which resulted in a hard landing. Contributing to the accident was the check airman's delayed remedial action.
- [NTSB ERA12LA307](https://openairdocs.org/ntsb/ERA12LA307.md): Rice Leo B Kitfox Series 5 · Port Canaveral, FL · Accident · No injuries · Limited investigation · Final report · Apr 28, 2012 · N77LR · Substantial damage
  > Impingement of the elevator control by foreign objects (clamp, glove) left in the flight control path by the pilot/owner or maintenance personnel.
- [NTSB ERA12CA304](https://openairdocs.org/ntsb/ERA12CA304.md): Bell 206B · Hershey, PA · Accident · Serious injuries · Data collection · Final report · Apr 27, 2012 · N16EP · Substantial damage
  > The pilot's diverted attention while performing aerial application at low altitude, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s failure to adjust the control friction to the position he was accustomed.
- [NTSB WPR12FA184](https://openairdocs.org/ntsb/WPR12FA184.md): Cessna A185F · Blanding, UT · Accident · 3 fatal · Field investigation · Final report · Apr 25, 2012 · N243W · Substantial damage
  > The pilot's failure to maintain airplane control during low-level maneuvering flight. Contributing to the pilot’s death was the lack of a timely emergency rescue response due to the lack of effective emergency signal transmissions from both the airplane’s…
- [NTSB WPR12CA183](https://openairdocs.org/ntsb/WPR12CA183.md): Bell 206B · Arvin, CA · Accident · No injuries · Data collection · Final report · Apr 25, 2012 · N969W · Substantial damage
  > The pilot did not maintain clearance from power lines during low altitude maneuvering.
- [NTSB ENG12WA037](https://openairdocs.org/ntsb/ENG12WA037.md): Pilatus PC6 - B2H4 · Muaritan, Indonesia · Accident · 2 fatal · Foreign investigation · Apr 25, 2012 · PK-VVQ · Substantial damage
  > On April 25, 2012, at 09:29 UTC time, a Pilatus PC-6/B2-H4, PK-VVQ, operated by Susi Air, impacted terrain near Muaritan after the pilot reported a fuel system problem.The accident is being investigated by the Indonesian National Transportation Safety…
- [NTSB CEN12LA260](https://openairdocs.org/ntsb/CEN12LA260.md): Thrush S2R-H80 · Bryan, TX · Accident · No injuries · Limited investigation · Final report · Apr 25, 2012 · N510KW · Substantial damage
  > The pilot's diverted attention, which resulted in a loss of control while maneuvering the airplane at a low altitude.
- [NTSB WPR12FA180](https://openairdocs.org/ntsb/WPR12FA180.md): League Lancair IV-TP · Sisters, OR · Accident · 2 fatal · Field investigation · Final report · Apr 23, 2012 · N66HL · Substantial damage
  > The pilots’ inability to maintain control of the airplane and arrest a steep spiral dive while maneuvering for reasons that could not be determined because postaccident examination could not identify any anomalies that would have precluded normal operation…
- [NTSB CEN12LA259](https://openairdocs.org/ntsb/CEN12LA259.md): Moody-Siple A · Stuttgart, AR · Accident · No injuries · Limited investigation · Final report · Apr 21, 2012 · N78RB · Substantial damage
  > The pilot’s inadequate fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA12WA301](https://openairdocs.org/ntsb/ERA12WA301.md): Cessna T206H · Macapá, Brazil · Accident · 2 fatal · Foreign investigation · Apr 20, 2012 · PR-CRR · Destroyed
  > On April 20, 2012, about 0855 universal coordinated time, a Cessna T206H, Brazilian registration PR-CRR, was substantially damaged when it collided with terrain approximately five minutes after takeoff from Macapa International Airport (SBMQ), Macapa, Brazil.…
- [NTSB WPR12CA172](https://openairdocs.org/ntsb/WPR12CA172.md): Rockwell International S-2R · Palouse, WA · Accident · No injuries · Data collection · Final report · Apr 17, 2012 · N4971X · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s distraction and subsequent failure to have the airplane refueled.
- [NTSB ERA12LA293](https://openairdocs.org/ntsb/ERA12LA293.md): Prendergast John/Vans RV-7A · Gerrardstown, WV · Accident · No injuries · Limited investigation · Final report · Apr 16, 2012 · N5025G · Substantial damage
  > The pilot/builder's misjudgment of the required spacer width needed after engine housing lap grinding, which resulted in bearing oil hole misalignment and insufficient internal engine lubrication.
- [NTSB WPR12FA164](https://openairdocs.org/ntsb/WPR12FA164.md): Cessna 320D · Green River, WY · Accident · 1 fatal · Field investigation · Final report · Apr 12, 2012 · N32EG · Destroyed
  > The pilot's failure to maintain airplane control while maneuvering in marginal weather conditions, which resulted in an exceedence of the design stress limits of the airplane and a subsequent in-flight structural failure.
- [NTSB WPR12WA199](https://openairdocs.org/ntsb/WPR12WA199.md): Ayres S2R · Moree, Australia, Australia · Accident · 1 fatal · Foreign investigation · Apr 10, 2012 · VH-WDD · Substantial damage
  > On April 10, 2012, at 2300 universal coordinated time, an Ayres Turbo Thrush S-2R, VH-WDD, collided with the terrain near Moree, Australia, while conducting agricultural operations. The airplane was operated by Alexander Aviation PTY LTD under the pertinent…
- [NTSB ERA12CA275](https://openairdocs.org/ntsb/ERA12CA275.md): Air Tractor AT-602 · Ruleville, MS · Accident · No injuries · Data collection · Final report · Apr 9, 2012 · N51037 · Substantial damage
  > The pilot's inadequate preflight planning and in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN12LA236](https://openairdocs.org/ntsb/CEN12LA236.md): Ayres S2R-T15 · Lakin, KS · Accident · Serious injuries · Limited investigation · Final report · Apr 9, 2012 · N64DX · Substantial damage
  > The pilot did not maintain sufficient airspeed while maneuvering, which resulted in an aerodynamic stall at a low altitude.
- [NTSB WPR12FA155](https://openairdocs.org/ntsb/WPR12FA155.md): Extra Flugzeugbau EA-300 · Salinas, CA · Accident · 2 fatal · Field investigation · Final report · Apr 8, 2012 · N45R · Substantial damage
  > A loose portable XM-GPS antenna that migrated to the tail section of the airplane and jammed the elevator bell crank. Contributing to the accident was the pilot’s failure to account for the cockpit portable GPS antenna during preflight or postflight…
- [NTSB WPR12FA154](https://openairdocs.org/ntsb/WPR12FA154.md): Cessna T182 · Ludlow, CA · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2012 · N5201F · Substantial damage
  > The in-flight loss of control due to the pilot’s impairment as a result of hypoxia. Contributing to the accident was the pilot’s operation of the airplane above 12,500 feet without the aid of supplemental oxygen.
- [NTSB CEN12WA679](https://openairdocs.org/ntsb/CEN12WA679.md): Robinson R22 · Huy, Belgium · Accident · 2 fatal · Foreign investigation · Apr 6, 2012 · OO-DTZ · Destroyed
  > This accident is under the jurisdiction and control of the Belgium government.
- [NTSB ERA12CA272](https://openairdocs.org/ntsb/ERA12CA272.md): Wielt Great Lakes 2T-1A · Warwarsing, NY · Accident · Minor injuries · Data collection · Final report · Apr 5, 2012 · N211RW · Substantial damage
  > The pilot’s failure to maintain airplane control during low level maneuvering flight.
- [NTSB CEN12LA230](https://openairdocs.org/ntsb/CEN12LA230.md): Robinson Helicopter R22 Beta · Isabel, SD · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 2012 · N104MH · Substantial damage
  > The partial loss of engine power due to carburetor ice.
- [NTSB CEN12LA227](https://openairdocs.org/ntsb/CEN12LA227.md): Grumman F8F-1 · Breckenridge, TX · Accident · 1 fatal · Limited investigation · Final report · Apr 4, 2012 · N14HP · Substantial damage
  > The pilot's loss of airplane control during a low-altitude aerobatic maneuver.
- [NTSB ANC12CA029](https://openairdocs.org/ntsb/ANC12CA029.md): Cessna 180 · Palmer, AK · Accident · No injuries · Data collection · Final report · Mar 30, 2012 · N266V · Substantial damage
  > The pilot’s failure to maintain adequate clearance from terrain during low-level maneuvering.
- [NTSB WPR12FA136](https://openairdocs.org/ntsb/WPR12FA136.md): Cessna 150L · Goble, OR · Accident · 2 fatal · Field investigation · Final report · Mar 15, 2012 · N18677 · Substantial damage
  > The flight instructor's decision to continue flight into the area of reduced visibility and the pilots’ subsequent failure to maintain clearance from the hilly terrain while operating in an area of low ceilings, rain, and fog.
- [NTSB ANC12LA026](https://openairdocs.org/ntsb/ANC12LA026.md): Dehavilland Beaver DHC-2 · Ketchikan, AK · Accident · Serious injuries · Limited investigation · Final report · Mar 13, 2012 · N82SF · Substantial damage
  > The pilot's decision to depart in marginal visual meteorological conditions, and his continued visual flight into instrument meteorological conditions.
- [NTSB ERA12CA222](https://openairdocs.org/ntsb/ERA12CA222.md): Cessna 172N · Orleans, VT · Accident · Minor injuries · Data collection · Final report · Mar 10, 2012 · N738QF · Substantial damage
  > The pilot’s failure to maintain clearance from a power line while conducting low-altitude flight.
- [NTSB WPR12FA123](https://openairdocs.org/ntsb/WPR12FA123.md): Bellanca 7GCBC · Brockton, MT · Accident · 1 fatal · Field investigation · Final report · Mar 5, 2012 · N5542K · Substantial damage
  > The pilot’s failure to maintain adequate airspeed and airplane control while maneuvering at a low altitude, which resulted in a stall and subsequent impact with terrain.
- [NTSB WPR12LA125](https://openairdocs.org/ntsb/WPR12LA125.md): Aerospatiale AS 355F1 · Makakilo City, HI · Accident · No injuries · Limited investigation · Final report · Mar 3, 2012 · N101MZ · Substantial damage
  > A partial loss of engine power while maneuvering over rough/uneven terrain that was precipitated by the failure of a 3rd stage turbine blade as a result of high-cycle fatigue.
- [NTSB ERA12WA223](https://openairdocs.org/ntsb/ERA12WA223.md): Cessna 188 · Querencia do Norte, Brazil · Accident · 1 fatal · Class 5 · Foreign · Mar 2, 2012 · PR-STO · Substantial damage
  > On March 02, 2012, about 1350 universal coordinated time, a Cessna 188B, Brazilian registration PR-STO, was substantially damaged when it collided with power lines during a crop dusting flight, near Querencia do Norte, Brazil. The foreign certificated pilot…
- [NTSB WPR12LA107](https://openairdocs.org/ntsb/WPR12LA107.md): Bell AH-1F · Coolidge, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2012 · N197LE · Substantial damage
  > A flight control malfunction while maneuvering for reasons that could not be determined because postaccident examination revealed no evidence of a mechanical malfunction or failure that would have precluded normal operation.
- [NTSB CEN12FA174](https://openairdocs.org/ntsb/CEN12FA174.md): Hemp Timothy Legacy 2000 · Belen, NM · Accident · 2 fatal · Field investigation · Final report · Mar 1, 2012 · N273TE · Destroyed
  > The pilot’s failure to maintain clearance from power lines while maneuvering after takeoff. Contributing to the accident was the pilot’s decision to operate the airplane during the hours of darkness when he had a restriction for daytime flight only due to…
- [NTSB ERA12FA194](https://openairdocs.org/ntsb/ERA12FA194.md): Strout Frank Aventura II · Laceys Spring, AL · Accident · 2 fatal · Field investigation · Final report · Feb 26, 2012 · N1193S · Substantial damage
  > The pilot's failure to maintain control of the airplane during a low-altitude maneuver. Contributing to the accident was the pilot's lack of the required rating to operate the airplane.
- [NTSB WPR12LA115](https://openairdocs.org/ntsb/WPR12LA115.md): Texas Helicopter OH-13E/M74 · Farmington, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 2012 · N43921 · Substantial damage
  > The in-flight separation of the wood portion of one main rotor blade while maneuvering at low level, the reason for which could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN12LA167](https://openairdocs.org/ntsb/CEN12LA167.md): Crain Jac A BD-4 · Clarinda, IA · Accident · 1 fatal · Limited investigation · Final report · Feb 19, 2012 · N215BD · Destroyed
  > A loss of airplane control for reasons that could not be determined because postaccident examination of the airplane and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12GA106](https://openairdocs.org/ntsb/WPR12GA106.md): Bell 407 · Moran Junction, WY · Accident · 1 fatal · Final report · Feb 15, 2012 · N407HL · Substantial damage
  > The pilot’s failure to maintain yaw control while hovering at high density altitude, which resulted in a loss of tail rotor effectiveness.
- [NTSB CEN12FA158](https://openairdocs.org/ntsb/CEN12FA158.md): Piper PA-28-180 · Osborn, MO · Accident · 2 fatal · Field investigation · Final report · Feb 14, 2012 · N4824L · Substantial damage
  > The pilot’s decision to conduct low-level passes above a residence and his failure to maintain sufficient altitude.
- [NTSB WPR12CA102](https://openairdocs.org/ntsb/WPR12CA102.md): Piper PA-18-135 · Concrete, WA · Accident · Minor injuries · Data collection · Final report · Feb 12, 2012 · N1155C · Substantial damage
  > The pilot did not attain and maintain sufficient altitude to clear terrain while maneuvering.
- [NTSB WPR12CA100](https://openairdocs.org/ntsb/WPR12CA100.md): Schweizer 269C · Las Vegas, NV · Accident · Minor injuries · Data collection · Final report · Feb 11, 2012 · N20536 · Substantial damage
  > The pilot's inadequate compensation for the known wind conditions during a hovering maneuver, which resulted in a loss of tail rotor effectiveness and directional control.

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

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

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