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

## Cases, newest first

- [NTSB CEN19WA012](https://openairdocs.org/ntsb/CEN19WA012.md): Cessna 150M · La Paz, Mexico · Accident · 2 fatal · Foreign investigation · Oct 16, 2018 · XB-ODX
  > The government of Mexico has notified the NTSB of an accident involving a CESSNA 150M airplane that occurred on October 16, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions…
- [NTSB ERA19FA010](https://openairdocs.org/ntsb/ERA19FA010.md): Vans RV8 · Culpeper, VA · Accident · 1 fatal · Class 2 · Field · Final report · Oct 12, 2018 · N804RL · Destroyed
  > The pilot's loss of attitude orientation while maneuvering at low altitude in dark night visual meteorological conditions, which resulted in impact with terrain.
- [NTSB WPR19WA036](https://openairdocs.org/ntsb/WPR19WA036.md): Air Tractor 401B · Rukubi, Nigeria · Accident · Minor injuries · Foreign investigation · Oct 4, 2018 · 5N-BTV · Substantial damage
  > On October 4, 2018, about 0815 coordinated universal time, an Air Tractor AT-401B airplane, 5N-BTV, executed a forced landing following a loss of engine power near Rukubi, Nigeria. The pilot sustained minor injuries and the airplane was substantially damaged.…
- [NTSB ERA19LA006](https://openairdocs.org/ntsb/ERA19LA006.md): Cessna 205 · Wagoner, OK · Accident · Minor injuries · Class 3 · Limited · Final report · Oct 4, 2018 · N8495Z · Substantial damage
  > Maintenance personnel’s improper maintenance of the magnetos, which resulted in a loss of engine power.
- [NTSB WPR18FA276](https://openairdocs.org/ntsb/WPR18FA276.md): Cessna T210 · Silver City, ID · Accident · 3 fatal · Class 2 · Field · Final report · Sep 30, 2018 · N732MV · Destroyed
  > The pilot's failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack while making a turn in gusting wind conditions while flying through hilly terrain, which resulted in an aerodynamic stall.
- [NTSB ANC18LA080](https://openairdocs.org/ntsb/ANC18LA080.md): Piper PA18 · Delta Junction, AK · Accident · No injuries · Limited investigation · Final report · Sep 30, 2018 · N5907Y · Substantial damage
  > The total loss of engine power due to carburetor icing, which resulted from the pilot's failure to use carburetor heat while operating at low power settings in conditions conducive to the formation of carburetor ice.
- [NTSB CEN18FA389](https://openairdocs.org/ntsb/CEN18FA389.md): Vans RV 4 · Austin, AR · Accident · 1 fatal · Class 2 · Field · Final report · Sep 26, 2018 · N534MM · Substantial damage
  > The pilot's failure to maintain airplane control while maneuvering which resulted in the airplane exceeding its critical angle of attack and an accelerated stall.
- [NTSB ERA18LA258](https://openairdocs.org/ntsb/ERA18LA258.md): Beech 35 · Georgetown, SC · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 22, 2018 · N435RB · Substantial damage
  > A loss of directional control during landing due to overstress failure of the left seat’s left rudder pedal arm clevis, which occurred as a result of manufacturing defects.
- [NTSB GAA18CA563](https://openairdocs.org/ntsb/GAA18CA563.md): Air Tractor AT802 · Napoleon, ND · Accident · Serious injuries · Data collection · Final report · Sep 21, 2018 · N968JB · Substantial damage
  > The pilot’s failure to maintain clearance from a power line pole during an agricultural application flight.
- [NTSB GAA18CA573](https://openairdocs.org/ntsb/GAA18CA573.md): Hiller UH 12E · Frankfort, KS · Accident · No injuries · Data collection · Final report · Sep 20, 2018 · N1349A · Substantial damage
  > The ground crewmember's improper grabbing of the hovering helicopter's skid during an external load hook-up, which resulted in the helicopter descending and the main rotors striking ground equipment.
- [NTSB CEN18LA381](https://openairdocs.org/ntsb/CEN18LA381.md): Piper PA28 · Pagosa Springs, CO · Accident · No injuries · Limited investigation · Final report · Sep 19, 2018 · N8003W · Substantial damage
  > The student pilot's mismanagement of the fuel selector valve during the simulated forced landing demonstration and the flight instructor's inadequate supervision to ensure the fuel selector was properly set, which resulted in a loss of engine power and…
- [NTSB WPR18LA267](https://openairdocs.org/ntsb/WPR18LA267.md): Aero Vodochody L39 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 14, 2018 · N139UK · 2 aircraft · Minor damage
  > The pilot of the race 13 airplane's failure to maintain clearance from the race 37 airplane during the closed course air race.
- [NTSB WPR18FA261](https://openairdocs.org/ntsb/WPR18FA261.md): Gruber Beelzabub · Rochester, WA · Accident · 2 fatal · Class 3 · Field · Final report · Sep 14, 2018 · N382T · Substantial damage
  > The pilot’s failure to maintain clearance from a tree while maneuvering at a low altitude.
- [NTSB WPR18FA260](https://openairdocs.org/ntsb/WPR18FA260.md): Robert L Coons RotorWay RW 1 · Billings, MT · Accident · 1 fatal · Field investigation · Final report · Sep 12, 2018 · N166LC · Substantial damage
  > The pilot's failure to maintain clearance with a hangar while maneuvering to his hangar. Contributing to the accident was the pilot's limited experience in helicopters.
- [NTSB ERA18LA249](https://openairdocs.org/ntsb/ERA18LA249.md): Edward R. Sugg Sonex · Marion, SC · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 2018 · N75SX · Destroyed
  > Impact with terrain for reasons that could not be determined based on the available information.
- [NTSB ERA18WA248](https://openairdocs.org/ntsb/ERA18WA248.md): Bell 206 · Bartica, Guyana · Accident · No injuries · Foreign investigation · Sep 10, 2018 · 8R-GTR · Substantial damage
  > The government of Guyana has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on September 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Guyana's investigation under the provisions…
- [NTSB GAA18CA543](https://openairdocs.org/ntsb/GAA18CA543.md): Bosko Wr/Bosko Ce Safari · Highgate, VT · Accident · No injuries · Data collection · Final report · Sep 8, 2018 · N699WC · Substantial damage
  > The student pilot’s failure to maintain lateral control during a hover.
- [NTSB GAA18CA533](https://openairdocs.org/ntsb/GAA18CA533.md): Taylorcraft BC12 · Cut Bank, MT · Accident · Minor injuries · Data collection · Final report · Sep 5, 2018 · N95514 · Substantial damage
  > The pilot’s failure to see and avoid power wires while maneuvering at low altitude. Contributing to the accident was the pilot’s inability to determine the airplane’s altitude due to sun glare.
- [NTSB CEN18WA376](https://openairdocs.org/ntsb/CEN18WA376.md): Robinson R44 · Domažlická 1059, Plzen - Skvrnany, Czechia · Accident · 4 fatal · Foreign investigation · Sep 5, 2018 · I-CCNI · Substantial damage
  > On September 5, 2018, at 1533 Coordinated Universal Time, a Robinson R44, I-CCNI, impacted terrain while maneuvering at low altitude, Plzen-Skvmany, Czech Republic. The pilot and three passengers sustained fatal injuries.The investigation is under the…
- [NTSB WPR18FA247](https://openairdocs.org/ntsb/WPR18FA247.md): Schempp-Hirth Duo Discus T · New Washoe City, NV · Accident · 2 fatal · Class 3 · Field · Final report · Sep 2, 2018 · N22XC · Destroyed
  > The pilot’s delayed recovery from an inadvertent spin and/or spiral dive and an exceedance of the glider’s design limit load during recovery, which resulted in an overload failure of both wings.
- [NTSB ERA18FA240](https://openairdocs.org/ntsb/ERA18FA240.md): Lance M Hooley Jetez · Covington, TN · Accident · 1 fatal · Field investigation · Final report · Sep 1, 2018 · N815EY · Destroyed
  > The improper manufacture of the left wing, which resulted in a left wing flutter event and failure at low altitude and high speed.
- [NTSB ERA18FA238](https://openairdocs.org/ntsb/ERA18FA238.md): Schweizer SGS 2 32 · Morrisville, VT · Accident · 3 fatal · Field investigation · Final report · Aug 29, 2018 · N17970 · Substantial damage
  > The pilot's exceedance of the glider's critical angle of attack while maneuvering, which resulted in an aerodynamic stall/spin and impact with terrain. Contributing to the accident was the pilot's decision to operate the glider outside of its published weight…
- [NTSB CEN18LA357](https://openairdocs.org/ntsb/CEN18LA357.md): Grumman G164 · Opelousas, LA · Accident · No injuries · Limited investigation · Final report · Aug 29, 2018 · N956X · Substantial damage
  > The loss of two securing bolts that allowed the left magneto to move around, which disrupted the spark timing and resulted in the engine losing total power.
- [NTSB ERA18FA235](https://openairdocs.org/ntsb/ERA18FA235.md): Airtime Cygnet · Pensacola, FL · Accident · 1 fatal · Field investigation · Final report · Aug 27, 2018 · N186AT · Substantial damage
  > The student pilot's loss of aircraft control for undetermined reasons.
- [NTSB GAA18CA506](https://openairdocs.org/ntsb/GAA18CA506.md): Hughes 369 · Ridgeway, PA · Accident · No injuries · Data collection · Final report · Aug 22, 2018 · N89ZC · Substantial damage
  > The pilot's failure to maintain clearance from power lines during an aerial observation flight.
- [NTSB WPR18LA234](https://openairdocs.org/ntsb/WPR18LA234.md): Air Tractor AT 400 · Grand Forks, ND · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 21, 2018 · N7300M · Substantial damage
  > The loss of engine power while maneuvering due to the failure of the power turbine blade assembly for reasons that could not be determined based on available evidence.
- [NTSB WPR18FA232](https://openairdocs.org/ntsb/WPR18FA232.md): Hughes 369 · Granger, TX · Accident · 2 fatal · Field investigation · Final report · Aug 21, 2018 · N530FU · Destroyed
  > The failure of both pilots to see and avoid a power line while maneuvering at low altitude. Contributing to the accident was the flight instructor's decision to not follow the training syllabus and allow the low-level high-speed flight.
- [NTSB WPR18TA238](https://openairdocs.org/ntsb/WPR18TA238.md): Rans S14 · Brownsville, OR · Accident · Serious injuries · Class 3 · Final report · Aug 20, 2018 · N140JL · Substantial damage
  > The pilot's exceedance of the airplane's critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall, loss of control, and impact with terrain.
- [NTSB WPR18LA233](https://openairdocs.org/ntsb/WPR18LA233.md): Blue Oak CCK-1865 · Deadwood, CA · Accident · No injuries · Limited investigation · Final report · Aug 20, 2018 · N14CK · Substantial damage
  > A loss of engine power due to fuel exhaustion and the pilot's failure to ensure that the left-wing fuel cap was secure before flight. Contributing to the accident was the pilot's failure to monitor fuel levels while in flight.
- [NTSB ERA18WA223](https://openairdocs.org/ntsb/ERA18WA223.md): Stemme S12 · Santo Domingo Norte, Dominican Republic · Accident · 2 fatal · Foreign investigation · Aug 19, 2018 · N612ST · Substantial damage
  > The government of Dominican Republic has notified the NTSB of an accident involving a STEMME S12 glider that occurred on August 19, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's investigation…
- [NTSB GAA18CA512](https://openairdocs.org/ntsb/GAA18CA512.md): Bell 206 · Battle Mountain, NV · Accident · No injuries · Class 4 · Data collection · Final report · Aug 18, 2018 · N8052G · Destroyed
  > The pilot's failure to maintain the proper altitude and airspeed while flying in a canyon in gusting wind conditions.
- [NTSB CEN18FA339](https://openairdocs.org/ntsb/CEN18FA339.md): Air Tractor AT502 · Bronson, MI · Accident · 1 fatal · Field investigation · Final report · Aug 18, 2018 · N502RL · Destroyed
  > The pilot's failure to maintain airspeed while maneuvering, which resulted in exceedance of the airplane's critical angle of attack, an aerodynamic stall, and loss of control at an altitude too low for recovery.
- [NTSB WPR18WA230](https://openairdocs.org/ntsb/WPR18WA230.md): Kawasaki Heavy Industries BK117 B-2 · Ulladulla, Australia · Accident · 1 fatal · Foreign investigation · Aug 17, 2018 · VH-JWB · Destroyed
  > On August 17, 2018, about 1400 local time, a Kawasaki Heavy Industries Ltd. BK117 B-2 helicopter, VH-JWB, was destroyed when it impacted terrain during aerial firefighting operations near Ulladulla, New South Wales, Australia. The helicopter was operated by…
- [NTSB CEN18LA342](https://openairdocs.org/ntsb/CEN18LA342.md): Cessna A188 · Whitewater, KS · Accident · No injuries · Limited investigation · Final report · Aug 17, 2018 · N9076R · Substantial damage
  > The partial loss of engine power due to low cylinder compression, which led to the forced landing following a pull-up maneuver. Contributing to the accident was the airplane’s high gross weight.
- [NTSB WPR18WA225](https://openairdocs.org/ntsb/WPR18WA225.md): Robinson R22 · Queenstown, South Africa · Accident · 1 fatal · Foreign investigation · Aug 15, 2018 · ZS-HBP · Substantial damage
  > On August 15, 2018, at 0830 Universal Coordinated Time, a Robinson R22 Beta helicopter, ZS-HBP, impacted power lines while conducting a game capturing flight near Queenstown, South Africa. The pilot sustained serious injuries and the passenger was fatally…
- [NTSB WPR18LA222](https://openairdocs.org/ntsb/WPR18LA222.md): Air Tractor AT802 · Northport, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 14, 2018 · N397AS · Substantial damage
  > A total loss of engine power during a climb due to an accumulation of molten environmental particles, the source of which could not be determined based on the available evidence, which resulted in a forced landing.
- [NTSB CEN18LA329](https://openairdocs.org/ntsb/CEN18LA329.md): Cessna 150 · Madison, SD · Accident · No injuries · Limited investigation · Final report · Aug 14, 2018 · N6341K · Substantial damage
  > A stuck No. 3 cylinder exhaust valve, which resulted in failure of the associated rocker arm, a partial loss of engine power, and the subsequent forced landing into tall vegetation.
- [NTSB WPR18LA241](https://openairdocs.org/ntsb/WPR18LA241.md): Cessna 172 · Afton, WY · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 13, 2018 · N5660J · Substantial damage
  > The pilot’s failure to maintain terrain clearance after an encounter with a downdraft while maneuvering in a valley with a high-density altitude, which resulted in impact with trees and terrain.
- [NTSB GAA18CA483](https://openairdocs.org/ntsb/GAA18CA483.md): Robinson R22 · Ocean City, NJ · Accident · No injuries · Data collection · Final report · Aug 10, 2018 · N92TR · Substantial damage
  > The flight instructor's decision to conduct hover practice at a lower altitude than recommended and his delayed remedial action during recovery from an unstable hover, which resulted in a dynamic rollover.
- [NTSB ANC18WA065](https://openairdocs.org/ntsb/ANC18WA065.md): Bell 412EP · Nakanojo, Japan · Accident · 9 fatal · Foreign investigation · Aug 10, 2018 · JA200G · Destroyed
  > The government of Japan has notified the NTSB of an accident involving a BELL 412EP helicopter that occurred on August 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of…
- [NTSB WPR18WA235](https://openairdocs.org/ntsb/WPR18WA235.md): Ayres S2R · Diatar, Mauritania · Accident · 1 fatal · Foreign investigation · Aug 8, 2018 · F-GOKZ · Destroyed
  > On August 8, 2018, at an unknown time, an Ayres S2R T34 airplane, F-GOKZ, impacted terrain during an agricultural operation near Diatar, Mauritania. The pilot was fatally injured. The airplane was being operated under the pertinent civil regulations of the…
- [NTSB WPR18LA214](https://openairdocs.org/ntsb/WPR18LA214.md): Bell 206 · Basin City, WA · Accident · Minor injuries · Limited investigation · Final report · Aug 7, 2018 · N607RA · Destroyed
  > The pilot's improper execution of a slowing and turning maneuver, which resulted in a loss of control at an altitude that was too low for recovery.
- [NTSB CEN18LA321](https://openairdocs.org/ntsb/CEN18LA321.md): Cessna A188 · Sedalia, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 6, 2018 · N4996R · Destroyed
  > A total loss of engine power during low-altitude maneuvering for reasons that could not be determined due to postimpact fire damage.
- [NTSB WPR18FA211](https://openairdocs.org/ntsb/WPR18FA211.md): Cessna 414 · Santa Ana, CA · Accident · 5 fatal · Class 2 · Field · Final report · Aug 5, 2018 · N727RP · Destroyed
  > The pilot’s failure to maintain adequate airspeed while maneuvering in the traffic pattern which resulted in an aerodynamic stall and subsequent spin at a low altitude, which the pilot was unable to recover from.
- [NTSB GAA18CA502](https://openairdocs.org/ntsb/GAA18CA502.md): WSK PZL Mielec M-18A · Dansville, NY · Accident · No injuries · Data collection · Final report · Aug 4, 2018 · N851EJ · Substantial damage
  > The pilot’s failure to maintain clearance from crops during an agricultural application flight.
- [NTSB ERA18LA210](https://openairdocs.org/ntsb/ERA18LA210.md): Champion 7GCAA · Lakewood, NJ · Accident · Minor injuries · Class 3 · Limited · Final report · Aug 4, 2018 · N87000 · Substantial damage
  > The pilot's failure to use carburetor heat in weather conditions conducive to carburetor icing, which resulted in a partial loss of engine power due to the formation of carburetor ice, a forced landing and impact with terrain.
- [NTSB CEN18WA312](https://openairdocs.org/ntsb/CEN18WA312.md): Steen Skybolt · Fratauti, Romania · Accident · 1 fatal · Foreign investigation · Aug 4, 2018 · D-EHHH · 2 aircraft · Destroyed
- [NTSB CEN18FA310](https://openairdocs.org/ntsb/CEN18FA310.md): Extra EA 400 · Ponca City, OK · Accident · 5 fatal · Class 3 · Field · Final report · Aug 4, 2018 · N13EP · Destroyed
  > The pilot's loss of control for reasons that could not be determined with the available evidence.
- [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.

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

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

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