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

## Cases, newest first

- [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.
- [NTSB WPR18FA074](https://openairdocs.org/ntsb/WPR18FA074.md): Hughes 369D · Pomeroy, WA · Accident · 1 fatal · Field investigation · Final report · Jan 27, 2018 · N369TH · Substantial damage
  > A loss of control following the gunner's failure to ensure that the net maintained clearance from the tail rotor.
- [NTSB CEN18FA088](https://openairdocs.org/ntsb/CEN18FA088.md): Cessna 172F · Williamsport, IN · Accident · 1 fatal · Field investigation · Final report · Jan 27, 2018 · N8559U · Destroyed
  > The pilot's mismanagement of fuel, which resulted in fuel exhaustion and descent and collision with trees.
- [NTSB ERA18WA066](https://openairdocs.org/ntsb/ERA18WA066.md): Robinson R44 · Recife, Brazil · Accident · 2 fatal · Foreign investigation · Jan 23, 2018 · PP-HLI · Substantial damage
  > The government of Brazil has notified the NTSB of an accident involving a ROBINSON R44 helicopter that occurred on January 23, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the…
- [NTSB GAA18CA110](https://openairdocs.org/ntsb/GAA18CA110.md): Helicopteres Guimbal Cabri G2 · Cahokia, IL · Accident · Minor injuries · Data collection · Final report · Jan 22, 2018 · N989HH · Substantial damage
  > The student pilot's failure to maintain yaw control while landing in gusting crosswind conditions and the flight instructor's delayed remedial action.
- [NTSB ERA18FA064](https://openairdocs.org/ntsb/ERA18FA064.md): Vans RV-12 · Bonita Springs, FL · Accident · 1 fatal · Field investigation · Final report · Jan 22, 2018 · N262WS · Destroyed
  > The pilot's unsafe maneuvering and exceedance of the airplane's operating limitations, which resulted in an in-flight failure of the left wing. Contributing to the accident was the pilot's underlying physiologic or psychiatric disease.
- [NTSB CEN18LA082](https://openairdocs.org/ntsb/CEN18LA082.md): Matheny Larry E Christavia MK 1 · Grand Detour, IL · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 2018 · N746LM · Substantial damage
  > The pilot's failure to see and avoid the power line. Contributing to the accident was the pilot’s intentional flight at low altitude.
- [NTSB WPR18LA076](https://openairdocs.org/ntsb/WPR18LA076.md): Buckeye Industries Dream Machine 582 · Chester, MT · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 19, 2018 · N92048 · Substantial damage
  > The pilot's failure to maintain adequate clearance from powerlines.
- [NTSB CEN18FA074](https://openairdocs.org/ntsb/CEN18FA074.md): MD Helicopters 369HM · Perrysburg, OH · Accident · 2 fatal · Field investigation · Final report · Jan 15, 2018 · N4QX · Substantial damage
  > A loss of engine power due to snow or ice ingestion at an altitude that was insufficient to allow for engine re-ignition. Contributing to the accident were conditions, including altitude and flat light conditions, that precluded a successful autorotation to…
- [NTSB GAA18CA102](https://openairdocs.org/ntsb/GAA18CA102.md): Piper PA 28 · Corona, CA · Accident · No injuries · Data collection · Final report · Jan 13, 2018 · N7085R · Substantial damage
  > The student pilot and flight instructor’s failure to see and avoid powerlines during a simulated emergency landing, which resulted in a wire strike during a go-around.
- [NTSB CEN18LA079](https://openairdocs.org/ntsb/CEN18LA079.md): Dayton A Dabbs Magni M-16 · Point Venture, TX · Accident · No injuries · Limited investigation · Final report · Jan 13, 2018 · N317KD · Substantial damage
  > The loss of engine power for reasons that could not be determined because a postaccident engine test run showed no anomalies that would have precluded normal operation, and the pilot's decision to conduct the flight at a low altitude.
- [NTSB ERA18LA091](https://openairdocs.org/ntsb/ERA18LA091.md): Hughes 369 · San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · Jan 11, 2018 · N571HH · No damage
  > The helicopter pilot's improper decision to use an open-end grapple, instead of an A-frame attachment, to lift and move a ladder with a lineman on it and the lineman's improper decision to be lifted on a ladder via an open-end grapple, which were contrary to…
- [NTSB CEN18LA069](https://openairdocs.org/ntsb/CEN18LA069.md): Robinson Helicopter R44 II · Albany, TX · Accident · No injuries · Limited investigation · Final report · Jan 8, 2018 · N797JR · Substantial damage
  > A loss of helicopter control for reasons that could not be determined because postaccident examination did not reveal any evidence of mechanical malfunctions or failures of the main rotor and tail rotor systems that would have precluded normal operation.
- [NTSB CEN18FA063](https://openairdocs.org/ntsb/CEN18FA063.md): Cessna 208 · Punta Islita, Costa Rica · Accident · 12 fatal · Field investigation · Final report · Dec 31, 2017 · TI-BEI · Destroyed
  > The flight crew's failure to maintain airspeed while maneuvering to exit an area of rising terrain, which resulted in an exceedance of the airplane's critical angle of attack and an aerodynamic stall. Contributing to the accident was the flight crew's…
- [NTSB WPR18FA063](https://openairdocs.org/ntsb/WPR18FA063.md): Cessna 172M · Ogden, UT · Accident · 2 fatal · Field investigation · Final report · Dec 29, 2017 · N4395R · Substantial damage
  > The pilot's failure to maintain clearance from the water while flying over a lake with glassy surface conditions. Contributing to the accident was the pilot's use of three impairing medications.
- [NTSB CEN18LA064](https://openairdocs.org/ntsb/CEN18LA064.md): Pipistrel Doo Ajdovscina Virus SW · Paulding, OH · Accident · No injuries · Limited investigation · Final report · Dec 28, 2017 · N4JW · Substantial damage
  > The loss of engine power while the motor-powered glider was maneuvering due to the fuel unporting in its fuel tank, which resulted in fuel starvation and a subsequent forced landing on unsuitable terrain.
- [NTSB ERA18WA069](https://openairdocs.org/ntsb/ERA18WA069.md): Cessna A188 · Montecristi, Dominican Republic · Incident · No injuries · Foreign investigation · Dec 23, 2017 · HI 907 · Minor damage
  > The government of Dominican Republic has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on December 23, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Dominican Republic's…
- [NTSB CEN18FA060](https://openairdocs.org/ntsb/CEN18FA060.md): X-Air XA85 · Oskaloosa, IA · Accident · 1 fatal · Field investigation · Final report · Dec 23, 2017 · N20XA · Substantial damage
  > The pilot's low altitude flight into a power line due to his impairment from an acute physiologic event during the flight. Contributing to the pilot's impairment was his use of two sedating medications.
- [NTSB WPR18LA050](https://openairdocs.org/ntsb/WPR18LA050.md): Gray Jim Robert Exec · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Dec 17, 2017 · N716JB · Substantial damage
  > Failure of the oil pressure gauge line, which resulted in oil exhaustion and a total loss of engine power.
- [NTSB GAA18CA073](https://openairdocs.org/ntsb/GAA18CA073.md): Brock Steiner Sport Copter Vortex · Spanish Fork, UT · Accident · No injuries · Data collection · Final report · Dec 8, 2017 · N395SC · Substantial damage
  > The pilot’s failure to maintain situational and geographic awareness during the flight, which resulted in him becoming lost and exhausting the gyroplane’s fuel.
- [NTSB ERA18FA030](https://openairdocs.org/ntsb/ERA18FA030.md): Mooney M20C · Starke, FL · Accident · 1 fatal · Field investigation · Final report · Nov 23, 2017 · N6894N · Destroyed
  > The pilot's loss of control due to spatial disorientation while maneuvering in instrument meteorological conditions. Contributing was the pilot's lack of instrument currency and his self-induced pressure to complete the flight.
- [NTSB CEN18WA046](https://openairdocs.org/ntsb/CEN18WA046.md): MD Helicopter 369HS · La Morita, Mexico · Accident · 2 fatal · Foreign investigation · Nov 22, 2017 · XC-TIJ · Destroyed
  > On November 22, 2017, about 1437 pacific standard time, a MD Helicopters 369HS single-engine helicopter, serial number 920414S, Mexican registration XC-TIJ, crashed while providing aerial support for police activity near La Morita, Mexico. The pilot and his…
- [NTSB WPR18FA035](https://openairdocs.org/ntsb/WPR18FA035.md): Cessna 152 · Tehachapi, CA · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2017 · N24987 · Destroyed
  > The pilot's loss of situational awareness shortly after takeoff over a sparsely lit area in dark night conditions, which resulted in a rapid descent to ground impact.
- [NTSB CEN18LA034](https://openairdocs.org/ntsb/CEN18LA034.md): Ercoupe 415 CD · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Nov 20, 2017 · N3067H · Substantial damage
  > The failure of the engine-driven fuel pump and the pilot's failure to identify the pump's failure, which resulted in a loss of engine power due to fuel starvation and a forced landing on a road, during which the airplane hit obstacles.
- [NTSB CEN18FA035](https://openairdocs.org/ntsb/CEN18FA035.md): Robinson Helicopter R22 Beta · Electra, TX · Accident · 1 fatal · Field investigation · Final report · Nov 20, 2017 · N4179M · Substantial damage
  > The pilot's failure to maintain clearance from powerlines while maneuvering at low altitude.
- [NTSB GAA18CA054](https://openairdocs.org/ntsb/GAA18CA054.md): Quicksilver MXL Sport · Point Mugu, CA · Accident · Minor injuries · Data collection · Final report · Nov 19, 2017 · N7712 · Substantial damage
  > The pilot’s failure to see and avoid power wires.
- [NTSB ERA18WA160](https://openairdocs.org/ntsb/ERA18WA160.md): Piper PA-25-235 · Itapolis, Brazil · Accident · 1 fatal · Foreign investigation · Nov 14, 2017 · PR-AAV · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a PIPER AIRCRAFT PA-25-235 airplane that occurred on November 14, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under…
- [NTSB ERA18LA021](https://openairdocs.org/ntsb/ERA18LA021.md): Socata TB200 · Annapolis, MD · Accident · No injuries · Class 2 · Limited · Final report · Nov 10, 2017 · N207GT · Substantial damage
  > A loss of engine power for undetermined reasons after the disconnection of the propeller governor control due to inadequate securenment during maintenance.
- [NTSB CEN18FA030](https://openairdocs.org/ntsb/CEN18FA030.md): Temco GC 1B · Pineville, LA · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2017 · N2363B · Substantial damage
  > The loss of engine power due to fuel starvation, which resulted from the unporting of the fuel during a right turn due to the auxiliary fuel tanks' improper configuration.
- [NTSB WPR18LA029](https://openairdocs.org/ntsb/WPR18LA029.md): Bell 206 · Rolling Fork, MS · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 7, 2017 · N93PH · Substantial damage
  > An uncommanded yaw and subsequent loss of main rotor rpm for reasons that could not be determined.
- [NTSB GAA18CA044](https://openairdocs.org/ntsb/GAA18CA044.md): Cessna 172 · Bonners Ferry, ID · Accident · No injuries · Data collection · Final report · Nov 7, 2017 · N55234 · Substantial damage
  > The pilot’s failure to see and avoid power lines while maneuvering at a low altitude.
- [NTSB CEN18LA026](https://openairdocs.org/ntsb/CEN18LA026.md): Hughes 369D · Sulphur, LA · Accident · 2 fatal · Limited investigation · Final report · Nov 7, 2017 · N138WH · No damage
  > The pilot's failure to maintain adequate separation between a long line being used to hoist linemen from a shield wire during an external load flight, which resulted in the long line being severed.
- [NTSB ANC18FA007](https://openairdocs.org/ntsb/ANC18FA007.md): Icon A5 · Clearwater, FL · Accident · 1 fatal · Field investigation · Final report · Nov 7, 2017 · N922BA · Substantial damage
  > The pilot's improper decision to perform aggressive, low-altitude maneuvers due to his impairment from the use of multiple psychoactive substances, which resulted in a loss of control.
- [NTSB CEN18LA025](https://openairdocs.org/ntsb/CEN18LA025.md): Robinson Helicopter R44 · Larchwood, IA · Accident · Serious injuries · Limited investigation · Final report · Nov 6, 2017 · N7085M · Substantial damage
  > The pilot's loss of situational awareness, which resulted in his failure to maintain adequate clearance from powerlines.
- [NTSB GAA18CA034](https://openairdocs.org/ntsb/GAA18CA034.md): Airbus Helicopters EC 130 · La Paloma, TX · Accident · No injuries · Data collection · Final report · Oct 26, 2017 · N22TZ · Substantial damage
  > The separation of a weight from the gunner’s net, which struck the helicopter’s main rotor blade during flight.
- [NTSB GAA18CA029](https://openairdocs.org/ntsb/GAA18CA029.md): Six Chuter West Legend XL · Mabton, WA · Accident · Serious injuries · Data collection · Final report · Oct 26, 2017 · N781SC · Substantial damage
  > The pilot’s failure to see and avoid transmission wires.
- [NTSB WPR18FA016](https://openairdocs.org/ntsb/WPR18FA016.md): Robinson R22 · Arlington, WA · Accident · 1 fatal · Field investigation · Final report · Oct 24, 2017 · N8537J · Substantial damage
  > The pilot's failure to maintain adequate clearance from the water while maneuvering at low altitude.
- [NTSB ERA18WA029](https://openairdocs.org/ntsb/ERA18WA029.md): Cessna A188 · Sao Felix do Xingu, Brazil · Accident · 1 fatal · Foreign investigation · Oct 24, 2017 · PR-RBA · Destroyed
  > The government of Brazil has notified the NTSB of an accident involving a CESSNA A188 airplane that occurred on October 24, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions…
- [NTSB CEN18LA019](https://openairdocs.org/ntsb/CEN18LA019.md): Air Tractor AT 502B · Olton, TX · Accident · Serious injuries · Class 3 · Limited · Final report · Oct 24, 2017 · N502G · Destroyed
  > The pilot's exceedance of the airplane’s critical angle of attack while maneuvering during the aerial application flight, which resulted in an aerodynamic stall and loss of control at an altitude too low to recover.
- [NTSB ERA18WA017](https://openairdocs.org/ntsb/ERA18WA017.md): Cessna 210 · Itaituba, Brazil · Accident · 5 fatal · Foreign investigation · Oct 22, 2017 · PT-ORU · Destroyed
  > On October 22, 2017, about 2105 universal coordinated time, a Cessna 210N, Brazilian registration PT-ORU, operated by a private individual, was destroyed when it collided with terrain following a low altitude maneuver near Itaituba, Brazil. The two foreign…
- [NTSB WPR18FA013](https://openairdocs.org/ntsb/WPR18FA013.md): Flugzeugproduktions-und Vertri EA 300/L · Four Corners, CA · Accident · 2 fatal · Field investigation · Final report · Oct 21, 2017 · N414MT · Destroyed
  > Collision with terrain after the pilot was unable to regain airplane control during an aerobatic maneuver. Contributing to the accident was the operator's failure to provide effective internal oversight to identify and prohibit exceedance of the airplanes'…
- [NTSB GAA18CA012](https://openairdocs.org/ntsb/GAA18CA012.md): Eurocopter Deutschland MBB BK 117 · Canton, IL · Accident · No injuries · Data collection · Final report · Oct 13, 2017 · N140SF · Substantial damage
  > The flight instructor's incorrect cyclic control during a hover, which resulted in a hard landing.
- [NTSB CEN18FA011](https://openairdocs.org/ntsb/CEN18FA011.md): Cessna 172M · Ramsey, MN · Accident · 2 fatal · Field investigation · Final report · Oct 13, 2017 · N7CF · Destroyed
  > The pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…
- [NTSB CEN18FA009](https://openairdocs.org/ntsb/CEN18FA009.md): Cessna 182H · Las Cruces, NM · Accident · 2 fatal · Field investigation · Final report · Oct 13, 2017 · N8338S · Substantial damage
  > Controlled flight into terrain in dark night conditions.
- [NTSB CEN18FA004](https://openairdocs.org/ntsb/CEN18FA004.md): Aero Vodochody L39C · Vernon, TX · Accident · 1 fatal · Field investigation · Final report · Oct 8, 2017 · N580LL · Destroyed
  > An in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.
- [NTSB ERA18WA009](https://openairdocs.org/ntsb/ERA18WA009.md): Zlin Z50 · Gauteng Province, South Africa · Accident · 1 fatal · Foreign investigation · Oct 6, 2017 · ZS-VAR · Destroyed
  > On October 6, 2017, about 1530 coordinated universal time, a Zlin Z-50L, South African registration ZS-VAR, was destroyed when it impacted terrain shortly after takeoff from Kitty Hawk Airport (FAKT), Gauteng Province, South Africa. The pilot was fatally…
- [NTSB CEN18WA005](https://openairdocs.org/ntsb/CEN18WA005.md): Piper PA25 · Cerro de Ortega, Mexico · Accident · 1 fatal · Foreign investigation · Oct 5, 2017 · XB-DLL · Substantial damage
- [NTSB ERA18FA004](https://openairdocs.org/ntsb/ERA18FA004.md): Cessna 401 · Salters, SC · Accident · 2 fatal · Field investigation · Final report · Oct 4, 2017 · N401HH · Destroyed
  > The pilot's decision to attempt a low-altitude aerobatic maneuver in a non-aerobatic airplane, and his subsequent failure to maintain control of the airplane during the maneuver. Contributing to the accident was the pilot's impairment by the effects of…
- [NTSB CEN18FA001](https://openairdocs.org/ntsb/CEN18FA001.md): Brantly B 2B · Midland, MI · Accident · 1 fatal · Field investigation · Final report · Oct 1, 2017 · N2284U · Substantial damage
  > The pilot's failure to maintain control of the helicopter, which resulted in a loss of tail rotor effectiveness, and his failure to promptly initiate the proper recovery technique, which resulted in a descent that could not be arrested before impacting the…

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

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

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