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

## Cases, newest first

- [NTSB ERA13CA163](https://openairdocs.org/ntsb/ERA13CA163.md): Air Tractor AT-301 · Greenbrier, AL · Accident · No injuries · Data collection · Final report · Feb 24, 2013 · N7310N · Substantial damage
  > The pilot’s failure to maintain adequate clearance from trees.
- [NTSB ERA13CA142](https://openairdocs.org/ntsb/ERA13CA142.md): Dombroski Frank Vans RV-10 · Lake Placid, NY · Accident · Minor injuries · Data collection · Final report · Feb 21, 2013 · N10FD · Substantial damage
  > The pilot's improper in-flight planning and decision making, which resulted in attempted visual flight in night instrument meteorological conditions and subsequent impact with terrain.
- [NTSB WPR13GA128](https://openairdocs.org/ntsb/WPR13GA128.md): Bell 206B · Eureka, NV · Accident · 1 fatal · Final report · Feb 18, 2013 · N20620 · Substantial damage
  > The pilot’s failure to maintain clearance from a wire while maneuvering during low-altitude operations. Contributing to the accident was task- and/or work-related fatigue.
- [NTSB ERA13LA136](https://openairdocs.org/ntsb/ERA13LA136.md): Quicksilver MX2 · Poplarville, MS · Accident · 1 fatal · Limited investigation · Final report · Feb 17, 2013 · UNREG · Substantial damage
  > The noncertificated pilot’s decision to make the flight and his failure to maintain clearance from trees while maneuvering at a low altitude.
- [NTSB CEN13LA163](https://openairdocs.org/ntsb/CEN13LA163.md): PZL Mielec M-18A · Jennings, LA · Accident · 1 fatal · Limited investigation · Final report · Feb 15, 2013 · N4305D · Substantial damage
  > The pilot’s inadequate visual lookout, which resulted in a collision with guy wires during an aerial application flight.
- [NTSB ERA13WA165](https://openairdocs.org/ntsb/ERA13WA165.md): Piper PA-36-300 · Quevedo, Ecuador · Accident · 1 fatal · Foreign investigation · Feb 14, 2013 · HC-BJM · Substantial damage
  > On February 14, 2013, about 1310 coordinated universal time (UTC), a Piper PA-36-300, Ecuadorian registration HC-BJM, operated by CIA FAP S.A., was substantially damaged when it impacted the ground during an aerial application flight. The Ecuadorian pilot was…
- [NTSB CEN13TA165](https://openairdocs.org/ntsb/CEN13TA165.md): Bell OH-58A · Pine Springs, TX · Accident · Minor injuries · Final report · Feb 14, 2013 · N337PW · Substantial damage
  > The pilot's failure to maintain directional control while operating in conditions conducive to a loss of tail rotor effectiveness.
- [NTSB ERA13WA157](https://openairdocs.org/ntsb/ERA13WA157.md): Cessna 172S · Mersin, Türkiye · Accident · 1 fatal · Foreign investigation · Feb 12, 2013 · TC-CDA · Substantial damage
  > On February 12, 2013, at about 1414 Universal Time Coordinated, a Cessna 172S, Turkish registration TC-CDA, operated by the Turkish Aeronautical Association, impacted terrain during an instructional flight, near Mersin, Turkey. The flight instructor was…
- [NTSB WPR13FA119](https://openairdocs.org/ntsb/WPR13FA119.md): Bell 206B · Acton, CA · Accident · 3 fatal · Field investigation · Final report · Feb 10, 2013 · N59518 · Substantial damage
  > The pilot's decision to conduct a flight in dark night conditions with an illuminated cockpit light that degraded his visibility and his ability to identify and arrest the helicopter's descent while maneuvering, which resulted in controlled flight into…
- [NTSB WPR13CA120](https://openairdocs.org/ntsb/WPR13CA120.md): Bell 206B · Shandon, CA · Accident · No injuries · Data collection · Final report · Feb 10, 2013 · N802KA · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB WPR13CA121](https://openairdocs.org/ntsb/WPR13CA121.md): Piper PA-28-140 · Sunnyside, WA · Accident · Minor injuries · Data collection · Final report · Feb 9, 2013 · N6726J · Substantial damage
  > The pilot’s inadequate vigilance while maneuvering at low altitude and his subsequent failure to maintain clearance from power lines.
- [NTSB ERA13CA130](https://openairdocs.org/ntsb/ERA13CA130.md): Dratbe Shmiel Amir Classic Edge X · Miami, FL · Accident · Minor injuries · Data collection · Final report · Feb 9, 2013 · N662DA · Substantial damage
  > The student pilot's decision to fly at low altitude surrounded by tree, wire, and water hazards, and his failure to maintain clearance from those obstacles.
- [NTSB ERA13WA135](https://openairdocs.org/ntsb/ERA13WA135.md): Cessna 172 · La Matanza, Argentina · Accident · 4 fatal · Foreign investigation · Feb 8, 2013 · LV-GEU · Substantial damage
  > On February 8, 2013, at 2250 Coordinated Universal Time (UTC), a Cessna 172, Argentine registration LV-GEU, impacted terrain while maneuvering at an altitude of approximately 500 feet in the vicinity of Matanza Airport (SADZ), La Matanza, Argentina. The local…
- [NTSB CEN13LA168](https://openairdocs.org/ntsb/CEN13LA168.md): Air Tractor AT-502 · Forrest City, AR · Accident · Minor injuries · Limited investigation · Final report · Feb 7, 2013 · N198LA · Substantial damage
  > The in-flight separation of the left aileron's push-pull rod and hardware. Contributing to the accident was the failure of maintenance personnel to apply proper torque to the self-locking nuts.
- [NTSB CEN13LA148](https://openairdocs.org/ntsb/CEN13LA148.md): Robinson R22 Beta II · Gillett, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 2013 · N3059Q · Substantial damage
  > A loss of tail rotor effectiveness while manuevering at low altitude.
- [NTSB CEN13LA152](https://openairdocs.org/ntsb/CEN13LA152.md): Air Tractor AT-401 · Victoria, TX · Accident · No injuries · Limited investigation · Final report · Jan 31, 2013 · N9190B · Substantial damage
  > The mechanical failure of the engine power section, which resulted in a loss of engine power.
- [NTSB ERA13CA122](https://openairdocs.org/ntsb/ERA13CA122.md): Amirkhanian Shahram Charl Commander · Westminster, MD · Accident · Minor injuries · Data collection · Final report · Jan 29, 2013 · N393GX · Substantial damage
  > Impact with power lines due to the pilot’s obscured vision due to the low angle of the sun, which prevented the pilot from seeing the lines.
- [NTSB ERA13LA118](https://openairdocs.org/ntsb/ERA13LA118.md): Hiller-Tri-Plex Ind.Inc. UH-12B · Okeechobee, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 2013 · N9041U · Substantial damage
  > The pilot's failure to monitor carburetor temperature and use carburetor heat in conditions conducive to serious carburetor icing, which resulted in partial loss of engine power.
- [NTSB WPR13FA095](https://openairdocs.org/ntsb/WPR13FA095.md): Cessna 140 · Boulder, UT · Accident · 2 fatal · Field investigation · Final report · Jan 19, 2013 · N2341N · Substantial damage
  > The pilot’s improper decision to maneuver at a low altitude and failure to adequately monitor the environment to maintain clearance from power lines.
- [NTSB WPR13LA087](https://openairdocs.org/ntsb/WPR13LA087.md): Bell OH-58C · Riverdale, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 8, 2013 · N911PT · Substantial damage
  > A flight control malfunction while maneuvering for reasons that could not be determined because it was not possible to establish whether observed damage to the flight control assembly was the result of wreckage recovery efforts or a preexisting condition.
- [NTSB CEN13WA126](https://openairdocs.org/ntsb/CEN13WA126.md): Piper PA34 · Saint Pierre de Bressieux, France · Accident · 5 fatal · Foreign investigation · Jan 5, 2013 · CN-DAY · Substantial damage
  > On January 5, 2013, at 1235 coordinated universal time, a Piper PA-34-200T airplane, Morocco registration, CN-DAY, crashed in mountainous terrain near Saint Pierre de Bressieux, France. The pilot and four passengers were fatally injured. The accident…
- [NTSB WPR13FA083](https://openairdocs.org/ntsb/WPR13FA083.md): Luscombe 8A · Oceano, CA · Accident · 1 fatal · Field investigation · Final report · Jan 3, 2013 · N45923 · Substantial damage
  > The pilot’s failure to maintain airplane control and his improper decision to begin a low-level maneuver at an altitude that was not sufficient for recovery before ground impact. Contributing to the accident was the pilot’s impairment from marijuana use.
- [NTSB WPR13CA084](https://openairdocs.org/ntsb/WPR13CA084.md): Bell 47G · Five Points, CA · Accident · Minor injuries · Data collection · Final report · Jan 3, 2013 · N14841 · Substantial damage
  > The pilot’s failure to maintain clearance with a telephone pole during a low-level maneuver.
- [NTSB WPR13FA080](https://openairdocs.org/ntsb/WPR13FA080.md): Bell 206 · Delano, CA · Accident · 1 fatal · Field investigation · Final report · Jan 2, 2013 · N828AC · Destroyed
  > The pilot's failure to maintain helicopter control due to spatial disorientation while maneuvering in low visibility, dark night conditions.
- [NTSB WPR13FA073](https://openairdocs.org/ntsb/WPR13FA073.md): Beech B100 · Libby, MT · Accident · 2 fatal · Field investigation · Final report · Dec 19, 2012 · N499SW · Destroyed
  > The noncertificated pilot’s failure to maintain clearance from terrain while maneuvering to land in dark night conditions likely due to his geographic disorientation (lost). Contributing to the accident was the pilot’s improper decision to fly at night with a…
- [NTSB WPR13LA069](https://openairdocs.org/ntsb/WPR13LA069.md): Powerchute Airwolf 912ULS · Dell, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 2012 · N480QP · Substantial damage
  > The pilot's failure to maintain aircraft control and clearance from mountainous terrain while maneuvering at a low altitude in downdraft conditions.
- [NTSB ERA13LA087](https://openairdocs.org/ntsb/ERA13LA087.md): Rotorway DB-1 · Mayland, TN · Accident · Minor injuries · Limited investigation · Final report · Dec 13, 2012 · N828X · Substantial damage
  > The pilot’s failure to maintain helicopter control following a high-side governor failure for reasons that could not be determined during postaccident examination.
- [NTSB CEN13FA100](https://openairdocs.org/ntsb/CEN13FA100.md): Aerovodochody L-29 Delfin · Combine, TX · Accident · 2 fatal · Field investigation · Final report · Dec 13, 2012 · N29NR · Substantial damage
  > The airplane's impact with terrain for reasons that could not be determined during examination of the available evidence because of extensive impact damage and postimpact fire.
- [NTSB CEN13FA089](https://openairdocs.org/ntsb/CEN13FA089.md): Beech 58 · Manhattan, IL · Accident · 1 fatal · Field investigation · Final report · Dec 4, 2012 · N4016A · Substantial damage
  > An in-flight loss of control and impact with terrain for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR13LA062](https://openairdocs.org/ntsb/WPR13LA062.md): Cessna 172S · Kahului, HI · Accident · 1 fatal · Limited investigation · Final report · Dec 2, 2012 · N3554Y · Substantial damage
  > The noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.
- [NTSB CEN13FA085](https://openairdocs.org/ntsb/CEN13FA085.md): Piper PA 46-350P · Greensburg, IN · Accident · 4 fatal · Field investigation · Final report · Dec 2, 2012 · N92315 · Destroyed
  > The pilot's failure to maintain airplane control while maneuvering in night instrument meteorological conditions due to spatial disorientation.
- [NTSB CEN13FA082](https://openairdocs.org/ntsb/CEN13FA082.md): Beech P35 · Correctionville, IA · Accident · 2 fatal · Field investigation · Final report · Dec 2, 2012 · N1566Z · Substantial damage
  > The pilot’s failure to perform a go-around after encountering thick fog at night.
- [NTSB CEN13LA086](https://openairdocs.org/ntsb/CEN13LA086.md): Bell 47G-2 · Walkerville, MI · Accident · 1 fatal · Limited investigation · Final report · Dec 1, 2012 · N3755Z · Substantial damage
  > The pilot's failure to maintain altitude while maneuvering, which resulted in a collision with trees. Contributing to the accident was the pilot's decision to fly at a low altitude, which did not provide enough margin to recover from the descent.
- [NTSB CEN13CA079](https://openairdocs.org/ntsb/CEN13CA079.md): Schweizer SGS 2-32 · Boulder, CO · Accident · Minor injuries · Data collection · Final report · Nov 29, 2012 · N9929J · Substantial damage
  > The glider pilot's inability to locate an area of thermal lift.
- [NTSB WPR13CA057](https://openairdocs.org/ntsb/WPR13CA057.md): Hughes 369D · Sheridan, OR · Accident · Minor injuries · Data collection · Final report · Nov 27, 2012 · N163PJ · Substantial damage
  > The pilot’s failure to prevent the helicopter from entering a vortex ring state (settling with power) condition during an external load operation, which resulted in the helicopter’s main rotor blades impacting the truck.
- [NTSB WPR13FA056](https://openairdocs.org/ntsb/WPR13FA056.md): Mcdaniel RV-6-CH · Scio, OR · Accident · 2 fatal · Field investigation · Final report · Nov 26, 2012 · N424D · Substantial damage
  > The pilot's decision to perform aerobatics in an airplane that was prohibited from aerobatics as stated in its operating limitations document, which resulted in the failure of the right wing spar.
- [NTSB WPR13LA050](https://openairdocs.org/ntsb/WPR13LA050.md): Sater Coot A-Amphib · San Andreas, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 23, 2012 · N8VS · Substantial damage
  > The pilot's excessive flight control inputs, which led to flight that exceeded the structural limits of the airplane and resulted in structural failure of both wings.
- [NTSB ERA13WA066](https://openairdocs.org/ntsb/ERA13WA066.md): Aerospatiale AS-355F1 · Great Guana Cay, Bahamas · Accident · 1 fatal · Foreign investigation · Nov 22, 2012 · C6-APV · Substantial damage
  > On November 22, 2012, about 1310 eastern standard time, an Aerospatiale AS 355F1, Bahamian registration C6-APV, registered to Pioneer Caribbean Logistics Ltd., impacted terrain while attempting to land at Baker's Bay Resort, Great Guana Cay, Bahamas. The…
- [NTSB CEN13FA060](https://openairdocs.org/ntsb/CEN13FA060.md): Grumman American Avn. AA-1B · Burlington, WI · Accident · 2 fatal · Field investigation · Final report · Nov 18, 2012 · N6273L · Substantial damage
  > The pilot’s failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in an inadvertent stall and spin.
- [NTSB WPR13GA044](https://openairdocs.org/ntsb/WPR13GA044.md): Bell OH-58 · Altadena, CA · Accident · Minor injuries · Final report · Nov 17, 2012 · N911FA · 2 aircraft · Substantial damage
  > The landing pilot's failure to maintain clearance with from obstacles a parked prior to landinghelicopter and the other pilot's failure to park the helicopter inside of a marked parking pad. Contributing to the accident was the landing pilot's obscured…
- [NTSB ERA13WA431](https://openairdocs.org/ntsb/ERA13WA431.md): Beech 95B55 - B · Concepcion, Paraguay · Accident · 3 fatal · Foreign investigation · Nov 16, 2012 · ZP-BLV · Destroyed
  > On November 16, 2012, about 0813 local time (1113 coordinated universal time), a Beech BE-55, Paraguayan registration ZP-BLV, was destroyed when it impacted terrain about 500 meters short of the runway at a ranch in Departamento Presidente Hayes, about 50…
- [NTSB ERA13LA057](https://openairdocs.org/ntsb/ERA13LA057.md): Hughes 369D · Corning, NY · Accident · 2 fatal · Limited investigation · Final report · Nov 15, 2012 · N369AW · Substantial damage
  > The pilot’s failure to maintain adequate altitude while conducting a power line aerial observation flight, which resulted in an in-flight collision with wires. Contributing to the accident was the pilot’s lack of total experience in the type of operation.
- [NTSB WPR13FA036](https://openairdocs.org/ntsb/WPR13FA036.md): North Wing Scout X-C · Waterville, WA · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2012 · N467XW · Substantial damage
  > The pilot's failure to maintain control of the airplane while maneuvering at a low altitude, which resulted in a stall and subsequent spin from which he was unable to recover.
- [NTSB WPR13LA035](https://openairdocs.org/ntsb/WPR13LA035.md): Cessna 172M · Modesto, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 6, 2012 · N21391 · Substantial damage
  > Failure of the throttle control cable during maneuvering flight, which resulted in a partial loss of engine power.
- [NTSB CEN13FA051](https://openairdocs.org/ntsb/CEN13FA051.md): Piper PA-28-140 · Anadarko, OK · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2012 · N7337J · Substantial damage
  > The pilot’s use of excessive bank angle while maneuvering in the airport traffic pattern, which resulted in an accelerated stall.
- [NTSB ERA13GA046](https://openairdocs.org/ntsb/ERA13GA046.md): Hughes OH-6A · Atlanta, GA · Accident · 2 fatal · Final report · Nov 4, 2012 · N368PD · Substantial damage
  > The pilot's failure to maintain sufficient altitude during maneuvering flight, which resulted in his failure to see and avoid a power pole and wires.
- [NTSB CEN13LA034](https://openairdocs.org/ntsb/CEN13LA034.md): US Light Hornet · Mont Belvieu, TX · Accident · 2 fatal · Limited investigation · Final report · Oct 28, 2012 · N2482J · Substantial damage
  > The pilot’s inadequate airspeed management while maneuvering in gusty wind conditions, which resulted in an aerodynamic stall. Contributing to the accident was the airplane’s low altitude, which did not allow for a stall recovery.
- [NTSB WPR13LA025](https://openairdocs.org/ntsb/WPR13LA025.md): Robinson Helicopter R22 Mariner · Lake Havasu, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 2012 · N2627M · Substantial damage
  > The pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.
- [NTSB WPR13LA023](https://openairdocs.org/ntsb/WPR13LA023.md): Robinson Helicopter R-44 II · Toutle, WA · Accident · No injuries · Limited investigation · Final report · Oct 26, 2012 · N7530F · Substantial damage
  > The pilot’s failure to maintain precise altitude control, which resulted in the helicopter entering a settling with power condition while hovering out of ground effect.
- [NTSB WPR13FA022](https://openairdocs.org/ntsb/WPR13FA022.md): Behne Glasair III · Byron, CA · Accident · 2 fatal · Field investigation · Final report · Oct 23, 2012 · N655DB · Destroyed
  > The pilot's failure to maintain control of the airplane while maneuvering, which resulted in a stall and subsequent spin.

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

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

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