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

## Cases, newest first

- [NTSB CEN18LA314](https://openairdocs.org/ntsb/CEN18LA314.md): Airbus EC 130 T2 · Mullen, NE · Accident · Serious injuries · Limited investigation · Final report · Aug 3, 2018 · N130TG · Substantial damage
  > The pilot’s inadequate and incorrect antitorque pedal application during a tight, decelerating turn downwind, which resulted in a loss of yaw control.
- [NTSB CEN18LA313](https://openairdocs.org/ntsb/CEN18LA313.md): Brantly B-2 · Midland, MI · Accident · No injuries · Limited investigation · Final report · Aug 3, 2018 · N5901X · Substantial damage
  > The in-flight separation of the tail rotor blade due to fatigue, which resulted in the subsequent emergency landing and dynamic rollover.
- [NTSB CEN18LA311](https://openairdocs.org/ntsb/CEN18LA311.md): Cessna 188 · Watkins, MN · Accident · No injuries · Limited investigation · Final report · Aug 2, 2018 · N5523S · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because a postaccident examination revealed no evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB CEN18WA343](https://openairdocs.org/ntsb/CEN18WA343.md): Piper PA25 · Namiquipa, Mexico · Accident · 1 fatal · Foreign investigation · Aug 1, 2018 · XB-FMA · Destroyed
  > On August 1, 2018, about 0956 hours mountain daylight time, a Piper PA-25-235 single-engine airplane, serial number 25-4177, Mexican registration XB-FMA, crashed in an agricultural field near Namiquipa, Mexico. The pilot was fatally injured. The local aerial…
- [NTSB CEN18LA303](https://openairdocs.org/ntsb/CEN18LA303.md): Buchanan Kitfox IV · Loma, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2018 · N125TY · Substantial damage
  > The pilot's improper decision to conduct a low-altitude flight over a river and his inadequate monitoring of the environment, which resulted in a collision with a cableway.
- [NTSB ERA18FA206](https://openairdocs.org/ntsb/ERA18FA206.md): Piper PA60 · Greenville, ME · Accident · 3 fatal · Field investigation · Final report · Jul 30, 2018 · C-GRRS · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering to land, which resulted in an aerodynamic stall.
- [NTSB ERA18LA204](https://openairdocs.org/ntsb/ERA18LA204.md): Progressive Aerodyne Searey · Haverhill, NH · Accident · Serious injuries · Limited investigation · Final report · Jul 29, 2018 · N221EZ · Substantial damage
  > The pilot's failure to maintain clearance from trees while maneuvering the airplane at a very low altitude in a confined area while attempting to land on a river.
- [NTSB CEN18FA297](https://openairdocs.org/ntsb/CEN18FA297.md): Aeronca 7AC · Alexandria, MN · Accident · 1 fatal · Field investigation · Final report · Jul 29, 2018 · N85506 · Substantial damage
  > The pilot's intentional low-altitude flight, which resulted in an impact with power lines.
- [NTSB GAA18CA453](https://openairdocs.org/ntsb/GAA18CA453.md): Robinson R44 · Elma, IA · Accident · Minor injuries · Data collection · Final report · Jul 27, 2018 · N466EL · Substantial damage
  > The pilot's failure maintain clearance from power lines during an agricultural application flight.
- [NTSB ERA18LA202](https://openairdocs.org/ntsb/ERA18LA202.md): Cessna 150 · Matthews, NC · Accident · No injuries · Limited investigation · Final report · Jul 26, 2018 · N1193Y · Substantial damage
  > The student pilot's improper decision to conduct a solo flight without an endorsement to do so and to perform an off-airport landing based on a perceived performance issue with the airplane. Contributing to the accident was the pilot's lack of training and…
- [NTSB CEN18WA308](https://openairdocs.org/ntsb/CEN18WA308.md): Air Tractor AT301 · Ascension, Chihuahua, Mexico · Accident · 1 fatal · Foreign investigation · Jul 25, 2018 · XB-OVB · Substantial damage
  > On July 25, 2018, about 1600 coordinated universal time, a Mexican registered Air Tractor AT 301 airplane, XB-OVB, impacted terrain near Ascension, Chihuahua, Mexico. The pilot was fatally injured and the airplane sustained substantial damage. The local…
- [NTSB CEN18LA292](https://openairdocs.org/ntsb/CEN18LA292.md): Grumman AA5 · Brazoria, TX · Accident · No injuries · Class 3 · Limited · Final report · Jul 23, 2018 · N74420 · Substantial damage
  > The propeller blade separation due to a fatigue fracture.
- [NTSB CEN18WA305](https://openairdocs.org/ntsb/CEN18WA305.md): Lavia Argentina PA-25-260 · Namiquipa, Chihuahua, Mexico · Accident · 1 fatal · Foreign investigation · Jul 22, 2018 · XB-EGL · 2 aircraft · Substantial damage
  > On July 22, 2018, about 1500 coordinated universal time, a Lavia Argentina S.A. PA-25-260 airplane, XB-EGL and Lavia Argentina S.A. PA-25-235 airplane, XB-DVX, collided during aerial application maneuvers near Namiquipa, Chihuahua, Mexico. The pilot of XB-EGL…
- [NTSB CEN18LA281](https://openairdocs.org/ntsb/CEN18LA281.md): Piper PA28 · Shreveport, LA · Accident · No injuries · Limited investigation · Final report · Jul 19, 2018 · N7080F · Substantial damage
  > The partial loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA18LA195](https://openairdocs.org/ntsb/ERA18LA195.md): Eagle DW1 · Ider, AL · Accident · No injuries · Limited investigation · Final report · Jul 18, 2018 · N8805X · Substantial damage
  > Fatigue failure of the No. 2 cylinder studs/through bolts and the fracture of the crankcase, which resulted in a total loss of engine power.
- [NTSB CEN18FA277](https://openairdocs.org/ntsb/CEN18FA277.md): Cessna 152 · Fort Rice, ND · Accident · 1 fatal · Class 2 · Field · Final report · Jul 17, 2018 · N24515 · Substantial damage
  > The pilot's failure to use carburetor heat in conditions that were conducive to serious carburetor icing, which resulted in a loss of engine power, an exceedance of the airplane's critical angle of attack, and an aerodynamic stall. Contributing to the…
- [NTSB CEN18LA269](https://openairdocs.org/ntsb/CEN18LA269.md): Bell 47J · Franklin, IN · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 2018 · N8568F · Destroyed
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB WPR18FA195](https://openairdocs.org/ntsb/WPR18FA195.md): Cessna 172 · Deer Park, WA · Accident · 3 fatal · Class 3 · Field · Final report · Jul 13, 2018 · N24442 · Substantial damage
  > An in-flight breakup as a result of the airplane exceeding the structural strength of the airplane during a rapid descent that the flight instructor was unable to recover from following a collision with a large bird.
- [NTSB CEN18LA270](https://openairdocs.org/ntsb/CEN18LA270.md): Air Tractor AT 602 · Bismarck, IL · Accident · Serious injuries · Class 3 · Limited · Final report · Jul 13, 2018 · N629LA · Substantial damage
  > A loss of control for reasons that could not be determined based on the available information.
- [NTSB CEN18IA273](https://openairdocs.org/ntsb/CEN18IA273.md): Cessna A188B · Rockford, OH · Incident · No injuries · Incident investigation · Final report · Jul 12, 2018 · N2483J · Minor damage
  > The total loss of engine power, which resulted from the separation of the No. 2 connecting rod due to oil starvation as a result of insufficient clamping force of the engine's through-bolts.
- [NTSB CEN18FA263](https://openairdocs.org/ntsb/CEN18FA263.md): Air Tractor AT-602 · Wheatley, AR · Accident · 1 fatal · Field investigation · Final report · Jul 11, 2018 · N8508P · Destroyed
  > The pilot's failure to maintain clearance from terrain for reasons that could not be determined based on the available evidence.
- [NTSB CEN18FA262](https://openairdocs.org/ntsb/CEN18FA262.md): Schempp-Hirth Flugzeugbau Ventus 3F · Moriarty, NM · Accident · 1 fatal · Field investigation · Final report · Jul 10, 2018 · N753R · Substantial damage
  > The pilot's exceedance of the glider's critical angle of attack during a low-altitude turn, which resulted in an aerodynamic stall and subsequent impact with terrain.
- [NTSB WPR18LA189](https://openairdocs.org/ntsb/WPR18LA189.md): Grumman G164B · Colusa, CA · Accident · No injuries · Class 3 · Limited · Final report · Jul 9, 2018 · N6696K · Substantial damage
  > Total loss of engine power for reasons that could not be determined based on the available information.
- [NTSB CEN18LA260](https://openairdocs.org/ntsb/CEN18LA260.md): Bell 206 · Bentley, IL · Accident · No injuries · Limited investigation · Final report · Jul 6, 2018 · N224KM · Substantial damage
  > The pilot's failure to ensure that adequate fuel was on board for the maneuvering flight, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN18FA258](https://openairdocs.org/ntsb/CEN18FA258.md): Bell 47G · Arlington, IN · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2018 · N96195 · Substantial damage
  > The inflight separation of the upper transmission due to the thread failure of transmission housing attachment bolts, which were installed on the helicopter with thread damage from a prior installation.
- [NTSB CEN18FA242](https://openairdocs.org/ntsb/CEN18FA242.md): Champion 7GCAA · Arthur, NE · Accident · 1 fatal · Field investigation · Final report · Jun 29, 2018 · N9026L · Substantial damage
  > The pilot's failure to recover from a spin for reasons that could not be determined based on the available information.
- [NTSB WPR18WA185](https://openairdocs.org/ntsb/WPR18WA185.md): Beech C90 · Mumbai, India · Accident · 5 fatal · Foreign investigation · Jun 28, 2018 · VT-UPZ · Destroyed
  > On June 28, 2018, at 0740 Universal Coordinated Time, a King Air C90 airplane, VT-UPZ, was destroyed when it impacted the ground near Mumbai, India. The airplane was operated under the pertinent regulations of the Government of India. The two pilots, two…
- [NTSB WPR18FA186](https://openairdocs.org/ntsb/WPR18FA186.md): Cessna 320 · Eagle Mountain, UT · Accident · 1 fatal · Class 3 · Field · Final report · Jun 28, 2018 · N320MF · Destroyed
  > The pilot's exceedance of the airplane's critical angle of attack and the airplane experiencing an aerodynamic stall at too low an altitude to recover.
- [NTSB GAA18CA383](https://openairdocs.org/ntsb/GAA18CA383.md): Grumman Acft ENG Cor-Schweizer G 164 · Malin, OR · Accident · No injuries · Data collection · Final report · Jun 27, 2018 · N151QC · Substantial damage
  > The pilot’s misjudgment of the approach and his subsequent exceedance of the airplane’s critical angle of attack during an agricultural application flight, which resulted in an aerodynamic stall and collision with power lines.
- [NTSB ANC18WA060](https://openairdocs.org/ntsb/ANC18WA060.md): Bell 205 · Hudson Bay, Canada · Accident · No injuries · Foreign investigation · Jun 27, 2018 · C-FYHD · Substantial damage
  > On June 27, 2018, at 1713 central standard time, a Canadian registered Bell 205A helicopter, C-FYHD, operated by Transwest Air Ltd Partnership, was substantially damaged during a precautionary landing due to severe airframe vibration at Buckmayer Lake,…
- [NTSB WPR18LA181](https://openairdocs.org/ntsb/WPR18LA181.md): Cessna 172S · Phoenix, AZ · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 26, 2018 · N154ME · Substantial damage
  > A total loss of engine power due to crankshaft failure as the result of a subsurface fatigue crack.
- [NTSB CEN18CA240](https://openairdocs.org/ntsb/CEN18CA240.md): Robinson Helicopter R22 Beta · Encino, TX · Accident · Minor injuries · Data collection · Final report · Jun 26, 2018 · N122CH · Substantial damage
  > The gunner's failure to ensure that the net would not ensnare the helicopter's skids once deployed, which resulted in the pilot being unable to maintain helicopter control as the bull pulled on the net and subsequent impact with terrain.
- [NTSB WPR18WA202](https://openairdocs.org/ntsb/WPR18WA202.md): Zlin Z242L · Hong Kong, China · Accident · Serious injuries · Foreign investigation · Jun 24, 2018 · B-LUK · Substantial damage
  > On June 24, 2018, at 1638 local time, a Zlin Z 242 L airplane, B-LUK, was substantially damaged when it collided with the ground near Ma Shi Chau, Hong Kong, China. The private pilot was seriously injured. The airplane was operated in accordance with the…
- [NTSB CEN18FA235](https://openairdocs.org/ntsb/CEN18FA235.md): Ercoupe 415 D · Monmouth, IL · Accident · 2 fatal · Field investigation · Final report · Jun 24, 2018 · N94070 · Destroyed
  > A loss of engine power for reasons that could not be determined based on the available information.
- [NTSB WPR18FA178](https://openairdocs.org/ntsb/WPR18FA178.md): Schempp-Hirth Standard Cirrus · Aguila, AZ · Accident · 1 fatal · Class 2 · Field · Final report · Jun 23, 2018 · N7880 · Substantial damage
  > The pilot's exceedance of the glider's critical angle of attack while attempting a thermal climb at low altitude, which resulted in an aerodynamic stall/spin at an altitude that precluded recovery.
- [NTSB WPR18LA177](https://openairdocs.org/ntsb/WPR18LA177.md): Schempp Hirth Flugzeugbau Arcus M · Richfield, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 21, 2018 · N16DN · Destroyed
  > An inflight loss of control and subsequent inflight breakup for reasons that could not be determined based on the available information.
- [NTSB WPR18LA176](https://openairdocs.org/ntsb/WPR18LA176.md): Piper PA 18-150 · Yellow Pine, ID · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 21, 2018 · N1979P · Substantial damage
  > The pilot’s failure to maintain adequate airspeed while conducting a go-around and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall/spin at too low of an altitude to recover. Contributing to the accident were…
- [NTSB GAA18CA371](https://openairdocs.org/ntsb/GAA18CA371.md): Air Tractor AT 301 · Hutchinson, MN · Accident · No injuries · Data collection · Final report · Jun 20, 2018 · N3169D · Substantial damage
  > The pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.
- [NTSB CEN18FA232](https://openairdocs.org/ntsb/CEN18FA232.md): Air Tractor AT 502B · Enid, OK · Accident · 1 fatal · Class 2 · Field · Final report · Jun 19, 2018 · N2063B · Destroyed
  > The pilot's failure to see and avoid a known obstacle (communications tower) during agricultural spraying operations.
- [NTSB WPR18WA180](https://openairdocs.org/ntsb/WPR18WA180.md): Piper PA31 · Antananarivo, Madagascar · Accident · 5 fatal · Foreign investigation · Jun 18, 2018 · 5R-MKF · Substantial damage
  > On June 18, 2018, about 0615 local time, a Piper PA-31 airplane, 5R-MKF, impacted terrain about 5 nautical miles from the Ivato International Airport, Antananarivo, Madagascar. The pilot in command, two pilot observers, pilot monitor, and one passenger were…
- [NTSB GAA18CA352](https://openairdocs.org/ntsb/GAA18CA352.md): Bell 206 · Orondo, WA · Accident · No injuries · Data collection · Final report · Jun 17, 2018 · N2762P · Substantial damage
  > The pilot's failure to maintain clearance from power lines while maneuvering at low altitude.
- [NTSB GAA18CA378](https://openairdocs.org/ntsb/GAA18CA378.md): Mcdonnell Douglas Heli 369 · Yabucoa, PR · Accident · No injuries · Data collection · Final report · Jun 16, 2018 · N900FF · Substantial damage
  > The pilot's failure to maintain main rotor clearance from a fiber line while picking up a lineman.
- [NTSB CEN18LA226](https://openairdocs.org/ntsb/CEN18LA226.md): Grumman Acft ENG Cor-Schweizer G 164B · Arrey, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 15, 2018 · N6672Q · Substantial damage
  > The pilot's failure to maintain clearance from a hillside during an agricultural application flight while facing the sun.
- [NTSB CEN18FA227](https://openairdocs.org/ntsb/CEN18FA227.md): Cessna 172N · Rotan, TX · Accident · 2 fatal · Field investigation · Final report · Jun 15, 2018 · N734BS · Destroyed
  > The pilot's reckless decision to conduct low-level flight over a canyon, resulting in the airplane's impact with power lines and terrain.
- [NTSB ERA18LA168](https://openairdocs.org/ntsb/ERA18LA168.md): Stinson L 5 · Thomson, GA · Accident · No injuries · Class 3 · Limited · Final report · Jun 14, 2018 · N45TX · Substantial damage
  > Failure of maintenance personnel to inspect the crankshaft after two previous propeller strikes, which resulted in failure of the crankshaft and a total loss of engine power. Contributing to the crankshaft failure was insufficient torque applied to the thrust…
- [NTSB CEN18WA231](https://openairdocs.org/ntsb/CEN18WA231.md): Air Tractor AT802 · Mallorca, Spain · Accident · 1 fatal · Foreign investigation · Jun 12, 2018 · EC-GVN · Substantial damage
  > On June 12, 2018, about 1600 hours universal coordinated time, an Air Tractor AT-802 airplane, Spanish registration EC-GVN, was substantially damaged during an agricultural application flight near Mallorca, Spain. The pilot sustained fatal injuries. The local…
- [NTSB CEN18FA217](https://openairdocs.org/ntsb/CEN18FA217.md): Let L 23 Super Blanik · Moose, WY · Accident · 2 fatal · Field investigation · Final report · Jun 9, 2018 · N317BA · Destroyed
  > The pilot's encounter with atmospheric conditions that resulted in a loss of lift and a subsequent loss of control near terrain that precluded recovery. Contributing to the accident was the pilot's failure to follow the operator's published tour flight…
- [NTSB CEN18FA215](https://openairdocs.org/ntsb/CEN18FA215.md): Robinson Helicopter R44 · Oshkosh, WI · Accident · 1 fatal · Field investigation · Final report · Jun 9, 2018 · N529DW · Substantial damage
  > The pilot's decision to fly over the river at a low altitude and his failure to maintain clearance with wires during low-level flight.
- [NTSB ANC18FA044](https://openairdocs.org/ntsb/ANC18FA044.md): Piper PA18 · Sitka, AK · Accident · 2 fatal · Class 2 · Field · Final report · Jun 9, 2018 · N1203A · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack for unknown reason, which resulted in an aerodynamic stall and a loss of control.
- [NTSB CEN18WA234](https://openairdocs.org/ntsb/CEN18WA234.md): Piper PA-25 · Cajeme, Sonora, Mexico · Accident · 1 fatal · Foreign investigation · Jun 7, 2018 · XB-YEI · Substantial damage
  > On June 7, 2018, a Mexican registered Piper PA-25, XB-YEI, impacted electrical cables and terrain near Cajeme, Sonora, Mexico. The pilot received fatal injuries. The airplane sustained substantial damage. The flight departed Cajeme, Mexico, on a local aerial…

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

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

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