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

## Cases, newest first

- [NTSB ANC18LA042](https://openairdocs.org/ntsb/ANC18LA042.md): Gippsaero PTY GA10 · Mojave, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 2018 · VH-XMH · Destroyed
  > The flight crew's inappropriate decision, without authorization or consultation from the manufacturer's chief design engineer, to introduce flaps in the landing configuration into the entry spin testing, which resulted in an unrecoverable spin and impact with…
- [NTSB WPR18LA163](https://openairdocs.org/ntsb/WPR18LA163.md): North Wing Pulse · Mountain Home, ID · Accident · 1 fatal · Limited investigation · Final report · Jun 2, 2018 · N62073 · Substantial damage
  > The hang glider's encounter with a developing vortex or dust devil while maneuvering during an airshow routine, which resulted in a loss of control at an altitude that precluded recovery. Contributing to the accident was the pilot's preexisting and worsening…
- [NTSB CEN18WA203](https://openairdocs.org/ntsb/CEN18WA203.md): Piper PA25 · Bosschenhoofd, Netherlands · Accident · 1 fatal · Foreign investigation · May 31, 2018 · SE-KHF
  > On May 31, 2018, a Piper PA-25-135 airplane (SE-KHF), crashed while attempting to pick up a banner near Bosschenhoofd, Netherlands. The pilot, who was the sole occupant, was fatally injured. This investigation is under the jurisdiction and control of the…
- [NTSB CEN18FA201](https://openairdocs.org/ntsb/CEN18FA201.md): Ayres S2R · El Reno, OK · Accident · 1 fatal · Field investigation · Final report · May 30, 2018 · N2249B · Destroyed
  > The pilot's failure to maintain clearance from tower guy wires while maneuvering during an aerial application flight.
- [NTSB WPR18LA152](https://openairdocs.org/ntsb/WPR18LA152.md): Mcdonnell Douglas Heli 369FF · Wikieup, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 29, 2018 · N975BW · Substantial damage
  > A vibration of the helicopter for reasons that could not be determined based on the available information, which resulted in a forced landing and the main rotor contacting the tailboom.
- [NTSB GAA18CA306](https://openairdocs.org/ntsb/GAA18CA306.md): Lite Flight Dragonfly · Mint Hill, NC · Accident · No injuries · Data collection · Final report · May 27, 2018 · N582DF · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during a turn, which resulted in an aerodynamic stall/spin.
- [NTSB CEN18WA214](https://openairdocs.org/ntsb/CEN18WA214.md): Bell 47 · Ciudad Valles, Mexico · Accident · 1 fatal · Foreign investigation · May 25, 2018 · XB-OSS · Substantial damage
  > On May 25, 2018, at 0030 hours universal coordinated time, a Scotts Bell 47 helicopter, Mexican registration XB-OSS, impacted terrain following a loss of engine power during an aerial application flight in San Luis Potosi, Mexico. The pilot was fatally…
- [NTSB WPR18LA144](https://openairdocs.org/ntsb/WPR18LA144.md): Ryan Navion · Jasper, AL · Accident · No injuries · Limited investigation · Final report · May 21, 2018 · N4356K · 2 aircraft · Substantial damage
  > The other pilot's failure to maintain clearance from another airplane in the formation flight due to sun glare.
- [NTSB CEN18FA182](https://openairdocs.org/ntsb/CEN18FA182.md): MD Helicopter 369D · Luling, LA · Accident · 1 fatal · Field investigation · Final report · May 20, 2018 · N362JS · Destroyed
  > The pilot's failure to maintain clearance from the powerline structure while hovering, which resulted in an inadvertent collision with the structure and an uncontrolled descent into terrain.
- [NTSB GAA18CA309](https://openairdocs.org/ntsb/GAA18CA309.md): Air Tractor AT 402 · Nicolaus, CA · Accident · No injuries · Data collection · Final report · May 19, 2018 · N5128N · Substantial damage
  > The pilot’s failure to maintain adequate clearance from a power transmission wire.
- [NTSB CEN18LA183](https://openairdocs.org/ntsb/CEN18LA183.md): Hughes 369A · Stoneburg, TX · Accident · Serious injuries · Limited investigation · Final report · May 19, 2018 · N369GK · Destroyed
  > The pilot's unsafe and aggressive operation of the helicopter at low altitude, which resulted in impact with trees.
- [NTSB WPR18TA157](https://openairdocs.org/ntsb/WPR18TA157.md): Cessna 182D · Crescent Mills, CA · Accident · No injuries · Class 3 · Final report · May 18, 2018 · N9163X · Substantial damage
  > A total loss of engine power due to the development of carburetor icing.
- [NTSB CEN18WA188](https://openairdocs.org/ntsb/CEN18WA188.md): Cessna 208 · Tuzantan, Mexico · Accident · 3 fatal · Foreign investigation · May 15, 2018 · UNKNOWN · Destroyed
  > On May 15, 2018, about 1300 coordinated universal time, a Cessna 208 airplane, N149CD, crashed in jungle terrain under unknown circumstances near Tuzantan, Mexico. The three occupants were fatally injured. The flight departure and destination were unknown.…
- [NTSB WPR18LA140](https://openairdocs.org/ntsb/WPR18LA140.md): Bell OH 58C · Yuma, AZ · Accident · No injuries · Class 3 · Limited · Final report · May 12, 2018 · N82857 · Substantial damage
  > A partial loss of engine power during an aerial application flight due to thermal damage to the 1st stage gas producer turbine nozzle and an irregular fuel spray pattern due to carbon buildup of the fuel nozzle. Contributing to the accident was maintenance…
- [NTSB WPR18FA139](https://openairdocs.org/ntsb/WPR18FA139.md): Beech 76 · Julian, CA · Accident · 3 fatal · Field investigation · Final report · May 11, 2018 · N803FC · Destroyed
  > The pilot's failure to maintain sufficient altitude above mountainous terrain while maneuvering during night conditions in an area prone to turbulence, which resulted in a collision with terrain. Contributing to the accident was the flight instructor's…
- [NTSB CEN18LA167](https://openairdocs.org/ntsb/CEN18LA167.md): Enstrom Helicopter 280C · Kerens, TX · Accident · Serious injuries · Limited investigation · Final report · May 10, 2018 · N67RE · Substantial damage
  > The total loss of engine power due to fuel exhaustion and the pilot’s inadequate in-flight fuel management.
- [NTSB GAA18CA265](https://openairdocs.org/ntsb/GAA18CA265.md): Air Tractor AT 802 · Truman, AR · Accident · No injuries · Data collection · Final report · May 4, 2018 · N4170S · Substantial damage
  > The pilot’s failure to see and avoid a pole during an agricultural application flight.
- [NTSB CEN18LA158](https://openairdocs.org/ntsb/CEN18LA158.md): Robinson Helicopter R44 · East Troy, WI · Accident · No injuries · Class 3 · Limited · Final report · May 4, 2018 · N444VH · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information, which resulted in impact with terrain and dynamic rollover during the subsequent attempted landing.
- [NTSB WPR18LA130](https://openairdocs.org/ntsb/WPR18LA130.md): Robinson Helicopter R22 Beta · Portland, OR · Accident · Serious injuries · Class 3 · Limited · Final report · May 2, 2018 · N7526S · Substantial damage
  > A hard landing for reasons that could not be determined based on the available information.
- [NTSB GAA18CA250](https://openairdocs.org/ntsb/GAA18CA250.md): Michael R Alexander Mosquito XE · Iron Station, NC · Accident · Minor injuries · Data collection · Final report · May 2, 2018 · N725JC · Destroyed
  > The noncertificated pilot’s decision to practice hovering the helicopter in a confined space, which resulted in the tail rotor striking a tree.
- [NTSB GAA18CA248](https://openairdocs.org/ntsb/GAA18CA248.md): Cessna 172 · Port Angeles, WA · Accident · Minor injuries · Data collection · Final report · May 2, 2018 · N734QQ · Substantial damage
  > The pilot’s exceedance of the airplane’s critical angle of attack during a turn away from terrain, which resulted in an accelerated stall. Contributing to the accident was the pilot’s decision to delay the turn to avoid terrain.
- [NTSB WPR18LA128](https://openairdocs.org/ntsb/WPR18LA128.md): Grumman Acft ENG Cor-Schweizer G 164C · Maxwell, CA · Accident · No injuries · Class 3 · Limited · Final report · Apr 29, 2018 · N6674K · Substantial damage
  > A total loss of engine power due to an uncommanded closing of the fuel shutoff valve, which terminated fuel to the engine. The reason for the fuel shutoff valve’s closure could not be determined based on the available information.
- [NTSB GAA18CA249](https://openairdocs.org/ntsb/GAA18CA249.md): Hughes 369 · Newark, OH · Accident · No injuries · Data collection · Final report · Apr 29, 2018 · N175JL · Substantial damage
  > The pilot’s failure to maintain adequate clearance from transmission power wires, which resulted in a tail rotor strike.
- [NTSB WPR18LA136](https://openairdocs.org/ntsb/WPR18LA136.md): Cessna 182F · Boulder, UT · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 28, 2018 · N3377U · Substantial damage
  > A partial loss of engine power for reasons that could not be determined due to the available evidence.
- [NTSB WPR18WA126](https://openairdocs.org/ntsb/WPR18WA126.md): Wells Elgin M Starjammer · HeNan Province, China · Accident · 1 fatal · Foreign investigation · Apr 25, 2018 · N49EW · Substantial damage
  > On April 25, 2018, at 1814 local time, an experimental Wells StarJammar airplane, N49EW, crashed during the rehearsal flight for an aerobatic performance at ShangJie general aviation Airport, HeNan Province, P.R. China. The owner/pilot, the sole occupant, was…
- [NTSB CEN18FA147](https://openairdocs.org/ntsb/CEN18FA147.md): North American SNJ 5 · Kingsville, TX · Accident · 2 fatal · Field investigation · Final report · Apr 25, 2018 · N12377 · Destroyed
  > The pilot's failure to maintain airspeed during a steep turn after takeoff, resulting in an exceedance of the airplane's critical angle of attack and a subsequent accelerated stall at an altitude too low for recovery.
- [NTSB ANC18LA032](https://openairdocs.org/ntsb/ANC18LA032.md): Robinson Helicopter R44 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Apr 20, 2018 · N511CC · Substantial damage
  > The pilot's failure to maintain helicopter control while in a hovering turn, which resulted in a collision with obstacles.
- [NTSB GAA18CA247](https://openairdocs.org/ntsb/GAA18CA247.md): Robinson Helicopter R44 · Sonora, TX · Accident · No injuries · Data collection · Final report · Apr 18, 2018 · N4487D · Substantial damage
  > The pilot’s failure to maintain clearance from trees while maneuvering at a low altitude.
- [NTSB ERA18WA133](https://openairdocs.org/ntsb/ERA18WA133.md): Bell 206L-4 · Vereda Plateado, Colombia · Accident · 1 fatal · Foreign investigation · Apr 15, 2018 · HK-4484 · Substantial damage
  > The government of Colombia has notified the NTSB of an accident involving a BELL 206L-4 helicopter that occurred on April 15, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Colombia's investigation under the…
- [NTSB ERA18FA122](https://openairdocs.org/ntsb/ERA18FA122.md): MD Helicopter 600 · Smethport, PA · Accident · 2 fatal · Field investigation · Final report · Apr 8, 2018 · N602BP · Destroyed
  > The helicopter pilot's failure to maintain adequate clearance during power line construction work, which resulted in the helicopter's main rotor striking and becoming entangled with a wire and a subsequent dynamic rollover and collision with terrain.…
- [NTSB WPR18LA113](https://openairdocs.org/ntsb/WPR18LA113.md): Schweizer G 164B · Stockton, CA · Accident · 1 fatal · Limited investigation · Final report · Mar 27, 2018 · N3629E · Substantial damage
  > The pilot's failure to maintain clearance with power lines while maneuvering during an aerial application flight.
- [NTSB GAA18CA229](https://openairdocs.org/ntsb/GAA18CA229.md): Robinson Helicopter R22 · Farmingdale, NY · Accident · No injuries · Data collection · Final report · Mar 23, 2018 · N72QC · Substantial damage
  > The student pilot’s rapid lowering of the collective, which resulted in a hard landing.
- [NTSB WPR18LA107](https://openairdocs.org/ntsb/WPR18LA107.md): Cubcrafters CC11-160 · Browns Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 18, 2018 · N1951B · Substantial damage
  > The pilot’s failure to adequately monitor the environment and maintain a sufficient altitude to avoid power lines.
- [NTSB ERA18LA111](https://openairdocs.org/ntsb/ERA18LA111.md): Cessna 210 · Shelburne, VT · Accident · No injuries · Limited investigation · Final report · Mar 16, 2018 · N761DV · Substantial damage
  > The pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB WPR18FA104](https://openairdocs.org/ntsb/WPR18FA104.md): Piper PA 18-150 · La Center, WA · Accident · 1 fatal · Field investigation · Final report · Mar 11, 2018 · N4511Y · Destroyed
  > The pilot's failure to maintain clearance from trees while maneuvering at a low altitude.
- [NTSB CEN18LA121](https://openairdocs.org/ntsb/CEN18LA121.md): Hughes 369D · Blair, WI · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 2018 · N499SL · No damage
  > The pilot’s failure to recognize and compensate for hazards during the external load operation, which led to a collision between a lineman (external load) and a powerline.
- [NTSB WPR18WA097](https://openairdocs.org/ntsb/WPR18WA097.md): Robinson Helicopter R44 II · Ogies, South Africa · Accident · 2 fatal · Foreign investigation · Feb 28, 2018 · ZS-HKZ · Destroyed
  > On February 28, 2018, at 0945 Universal Coordinated Time (UTC), a South African registered Robinson Helicopter Company R44 Raven II, ZS-HKZ, lost engine power while maneuvering near Truter Boerdery Farm, Ogies, Mpumalana Province, South Africa. The helicopter…
- [NTSB WPR18CA096](https://openairdocs.org/ntsb/WPR18CA096.md): Bell 47G · Pixley, CA · Accident · Serious injuries · Data collection · Final report · Feb 28, 2018 · N7800S · Substantial damage
  > A total loss of engine power due to fuel starvation, which resulted from the pilot’s failure to ensure that adequate fuel was on board for the flight. Contributing to the accident was the pilot’s self-induced pressure to complete the flight due to impending…
- [NTSB GAA18CA145](https://openairdocs.org/ntsb/GAA18CA145.md): Piper PA28R · Milton-Freewater, OR · Accident · No injuries · Data collection · Final report · Feb 28, 2018 · N323MQ · Substantial damage
  > The pilot receiving instruction’s and flight instructor’s improper decision to enter a canyon surrounded by steep rising terrain and their subsequent failure to maintain clearance from terrain while maneuvering at a low altitude.
- [NTSB ERA18FA092](https://openairdocs.org/ntsb/ERA18FA092.md): Quest Kodiac 100 · Georgetown, FL · Accident · 2 fatal · Field investigation · Final report · Feb 28, 2018 · N969TB · Substantial damage
  > The pilots' spatial disorientation while maneuvering for landing in night conditions over unlighted terrain, which resulted in an uncontrolled descent and impact with water.
- [NTSB ERA18FA088](https://openairdocs.org/ntsb/ERA18FA088.md): Air Tractor AT-802 · Greenwood, MS · Accident · 1 fatal · Field investigation · Final report · Feb 26, 2018 · N581LA · Substantial damage
  > The pilot's failure to maintain clearance from a tree for reasons that could not be determined based on the available evidence.
- [NTSB WPR18CA100](https://openairdocs.org/ntsb/WPR18CA100.md): Hughes 369D · Pacific Ocean, Marshall Islands · Accident · Minor injuries · Data collection · Final report · Feb 19, 2018 · N501VS · Substantial damage
  > An in-flight mechanical malfunction with the helicopter, which necessitated a ditching in the ocean. The reason for the malfunction could be determined because the helicopter sank and was not recovered.
- [NTSB GAA18LA131](https://openairdocs.org/ntsb/GAA18LA131.md): Robinson Helicopter R22 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Feb 14, 2018 · N337H · Substantial damage
  > The flight instructor’s abrupt evasive maneuver to avoid a reported unmanned aerial system, which resulted in a loss of forward airspeed and settling with power and a subsequent collision with trees and terrain.
- [NTSB ERA18WA217](https://openairdocs.org/ntsb/ERA18WA217.md): Cessna A188 · La Vega, Dominican Republic · Accident · 1 fatal · Foreign investigation · Feb 14, 2018 · N2451J · Substantial damage
  > The government of the Dominican Republic has notified the NTSB of an accident involving a Cessna A188B airplane that occurred on February 14, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…
- [NTSB CEN18LA106](https://openairdocs.org/ntsb/CEN18LA106.md): Schweizer 269D · Stockbridge, MI · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 13, 2018 · N471RA · Substantial damage
  > The pilot’s failure to maintain adequate clearance from terrain while maneuvering the helicopter at a low altitude after departure. Contributing to the accident were the pilot’s distraction by the smoke in the cabin and the limited visible features in the…
- [NTSB GAA18CA127](https://openairdocs.org/ntsb/GAA18CA127.md): Hughes 369 · Heber City, UT · Accident · No injuries · Data collection · Final report · Feb 12, 2018 · N338HW · Substantial damage
  > The pilot’s failure to maintain clearance from an elk while maneuvering at a low altitude.
- [NTSB ERA18WA108](https://openairdocs.org/ntsb/ERA18WA108.md): Piper PA25 · Ribeirao Cascalheira, Brazil · Accident · 1 fatal · Foreign investigation · Feb 9, 2018 · PT-OQX · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a Piper PA-25-260 airplane that occurred on February 09, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB WPR18FA084](https://openairdocs.org/ntsb/WPR18FA084.md): Cessna 182T · Santee, CA · Accident · 2 fatal · Field investigation · Final report · Feb 6, 2018 · N3525T · Substantial damage
  > The pilot's decision to take off into instrument meteorological conditions that resulted in spatial disorientation, and his exceedance of the airplane's critical angle of attack, which resulted in an aerodynamic stall.
- [NTSB ERA18WA081](https://openairdocs.org/ntsb/ERA18WA081.md): Reims F150L · Abrizzano di Negrar, Italy · Accident · 2 fatal · Foreign investigation · Jan 31, 2018 · I-CENE · Substantial damage
  > The government of Italy has notified the NTSB of an accident involving a Reims Aviation F150L airplane that occurred on January 31, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Italy's investigation under the…
- [NTSB GAA18CA113](https://openairdocs.org/ntsb/GAA18CA113.md): Robinson Helicopter R22 · Homstead, FL · Accident · No injuries · Data collection · Final report · Jan 28, 2018 · N127AG · Substantial damage
  > The pilot’s diverted attention to his phone while maneuvering at a low altitude, which resulted in collision with terrain.

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

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

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