# NTSB investigations: Enroute

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 74 of 718 · 35,885 cases

## Cases, newest first

- [NTSB CEN15LA216](https://openairdocs.org/ntsb/CEN15LA216.md): Piper PA 28-235 · Huntington, IN · Accident · Minor injuries · Limited investigation · Final report · May 4, 2015 · N8703W · Substantial damage
  > The pilot’s inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA15FA204](https://openairdocs.org/ntsb/ERA15FA204.md): Cessna 182 · Mulberry, TN · Accident · 1 fatal · Field investigation · Final report · May 3, 2015 · N6579M · Destroyed
  > The pilot's failure to recover from a controlled descent for reasons that could not be determined during the postaccident investigation.
- [NTSB DCA15WA178](https://openairdocs.org/ntsb/DCA15WA178.md): Boeing Boeing 777-228 IGW · Douala, Cameroon · Incident · No injuries · Foreign investigation · May 2, 2015 · F-GSPG · No damage
  > The Bureau d'Enquêtes et d'Analyses pour la sécurité de l'aviation civile (BEA) has notified the NTSB of an incident involving a Boeing 777-200, which occurred on May 2, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BEA…
- [NTSB CEN15LA217](https://openairdocs.org/ntsb/CEN15LA217.md): Cessna 150F · Neillsville, WI · Accident · Minor injuries · Limited investigation · Final report · May 2, 2015 · N8558G · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR15LA155](https://openairdocs.org/ntsb/WPR15LA155.md): Cessna 140 · Crescent Lake, OR · Accident · Minor injuries · Limited investigation · Final report · May 1, 2015 · N2514N · Substantial damage
  > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inability to restart the engine for reasons that could not be determined because postaccident examination…
- [NTSB WPR15LA153](https://openairdocs.org/ntsb/WPR15LA153.md): Cessna 170B · Centralia, WA · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 2015 · N1296D · Substantial damage
  > Maintenance personnel’s incorrect installation of the fuel selector valvehandle, which resulted in fuel starvation, a loss of engine power, and a forced hard landing. Contributing to the accident was the pilot's failure to follow the manufacturer's checklist.
- [NTSB GAA15CA051](https://openairdocs.org/ntsb/GAA15CA051.md): Piper PA 32R-300 · Gatlinburg, TN · Accident · No injuries · Data collection · Final report · Apr 26, 2015 · N2269M · Substantial damage
  > The pilot's encounter with extreme turbulence during descent over mountainous terrain, which resulted in a loss of control, and structural damage in flight.
- [NTSB DCA15WA123](https://openairdocs.org/ntsb/DCA15WA123.md): Boeing 737 - 8B6 · Madrid, Spain · Incident · No injuries · Foreign investigation · Apr 23, 2015 · CN-RNZ · No damage
  > The Director General of Civil Aviation of Morocco has notified the NTSB of an incident involving a Boeing 737-800 airplane, which occurred on April 23, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Director General of Civil…
- [NTSB WPR15FA152](https://openairdocs.org/ntsb/WPR15FA152.md): Piper PA 28-140 · Mt Tom, OR · Accident · 1 fatal · Field investigation · Final report · Apr 22, 2015 · N1729J · Destroyed
  > The noncertificated pilot's continued visual flight into instrument meteorological conditions, which resulted in spatial disorientation leading to the pilot's loss of control of the airplane and subsequent collision with mountainous terrain.
- [NTSB ERA15WA195](https://openairdocs.org/ntsb/ERA15WA195.md): Piper PA-32-300 · Punta Cana, Dominican Republic · Accident · 7 fatal · Foreign investigation · Apr 20, 2015 · HI 957 · Destroyed
- [NTSB ERA15LA189](https://openairdocs.org/ntsb/ERA15LA189.md): Cessna LC41-550FG · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Apr 18, 2015 · N400BZ · Substantial damage
  > An inflight fire and a total loss of engine power due to oil starvation, after separation of the No. 3 cylinder exhaust valve rocker box cover for reasons that could not be determined based on the available information.
- [NTSB CEN15LA202](https://openairdocs.org/ntsb/CEN15LA202.md): Fairchild SA227 AC · Rifle, CO · Accident · No injuries · Limited investigation · Final report · Apr 17, 2015 · N2691W · Substantial damage
  > The uncontained engine failure due to the fatigue failure of the second-stage turbine rotor disk.
- [NTSB ERA15LA201](https://openairdocs.org/ntsb/ERA15LA201.md): Universal Stinson 108-1 · Macon, MS · Accident · No injuries · Limited investigation · Final report · Apr 16, 2015 · N9799G · Substantial damage
  > A partial loss of engine power for reasons that could not be determined based on the available information.
- [NTSB ERA15IA198](https://openairdocs.org/ntsb/ERA15IA198.md): Dassault-Breguet Mystere Falcon 900 · Orlando, FL · Incident · No injuries · Class 2 · Incident · Final report · Apr 16, 2015 · N610RL · Minor damage
  > Unknown maintenance personnel’s inadequate securing of a wiring bundle during a maintenance, repair, or modification event, which led to chafing of the wiring bundle, an electrical short and arcing, and a subsequent in-flight fire.
- [NTSB CEN15LA204](https://openairdocs.org/ntsb/CEN15LA204.md): Grumman G 164A · Maysville, OK · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2015 · N7951 · Substantial damage
  > The loss of engine power for reasons that could not be determined because a postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN15LA198](https://openairdocs.org/ntsb/CEN15LA198.md): Robinson Helicopter R44 II · Dunlap, IL · Accident · No injuries · Limited investigation · Final report · Apr 15, 2015 · N754R · Substantial damage
  > A loss of main rotor rpm for reasons that could not be determined during postaccident examinations.
- [NTSB WPR15FA147](https://openairdocs.org/ntsb/WPR15FA147.md): Robert C. Hanson Pitts S2E · Lebec, CA · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2015 · N75BH · Destroyed
  > The pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.
- [NTSB ANC15FA021](https://openairdocs.org/ntsb/ANC15FA021.md): Cessna 180 · Whittier, AK · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2015 · N9247C · Substantial damage
  > The pilot's decision to continue flight into known icing conditions, contrary to the airplane’s limitations, which resulted in a total loss of engine power due to icing.
- [NTSB ERA15RA199](https://openairdocs.org/ntsb/ERA15RA199.md): Swearingen SA226-TC · North Vancouver, Canada · Accident · 2 fatal · Foreign investigation · Apr 13, 2015 · C-GSKC · Destroyed
  > On April 13, 2015, at 0709 Pacific daylight time, a Swearingen SA226-TC, Canadian registration C-GSKC, operating as Carson Air flight 66, was destroyed in an area of mountainous terrain about 10 nautical miles north of North Vancouver, British Columbia. The…
- [NTSB ERA15WA182](https://openairdocs.org/ntsb/ERA15WA182.md): Cessna 172S · Santander, Colombia · Accident · 3 fatal · Foreign investigation · Apr 12, 2015 · HK5064G · 2 aircraft · Substantial damage
  > On April 12, 2015, about 1915 coordinated universal time, a Cessna 172S, Colombian registration HK5064G, and a Cessna 150M, Colombian registration HK1912G, were substantially damaged after impacting mountainous terrain in the vicinity of the Serrania Los…
- [NTSB DCA15WA156](https://openairdocs.org/ntsb/DCA15WA156.md): Boeing Boeing 737-530 · Zurich, Switzerland · Incident · No injuries · Foreign investigation · Apr 12, 2015 · D-ABJB · No damage
  > The BFU of Switzerland (BFU-CH) has notified the NTSB of an incident involving a Boeing 737-530 airplane that occurred on April 12, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the BFU-CH's investigation under the provisions of ICAO…
- [NTSB ERA15LA183](https://openairdocs.org/ntsb/ERA15LA183.md): Aeronca 7AC · Spring City, TN · Accident · No injuries · Limited investigation · Final report · Apr 11, 2015 · N82658 · Substantial damage
  > The pilot's failure to properly apply carburetor heat in conditions conducive to carburetor icing, which resulted the accumulation of carburetor ice and the subsequent total loss of engine power.
- [NTSB ERA15LA328](https://openairdocs.org/ntsb/ERA15LA328.md): Gulfstream Aerospace G IV · Caribbean Sea, A1 · Accident · No injuries · Limited investigation · Final report · Apr 10, 2015 · N450KK · Substantial damage
  > The in-flight failure of the cabin pressurization relief/safety valve (CPRV) due to an obstruction of the CPRV static port, which allowed the airplane to overpressurize. The reason for the initial overpressurization condition could not be determined.
- [NTSB ENG15IA017](https://openairdocs.org/ntsb/ENG15IA017.md): Boeing 707 338C · Victorville, CA · Incident · No injuries · Incident investigation · Final report · Apr 10, 2015 · N624RH · Minor damage
  > the fracture of one 1st stage turbine blade from a high cycle fatigue crack that originated from a break in the coating on the leading edge of the blade. The cause for the break in the coating could not be determined. Contributing to the uncontained release…
- [NTSB ENG15WA018](https://openairdocs.org/ntsb/ENG15WA018.md): Short Brothers & Harland SC-7 Skyvan S3 · Klatovy, Czech Republic, Czechia · Incident · No injuries · Foreign investigation · Apr 8, 2015 · OE-FDN · Minor damage
  > An Austrian registered Shorts SC7 Skyvan, registration number OE-FDN, being operated by Pink Aviation Services Gmbh, suffered an uncontained failure of No.2 turbine wheel on RH engine during descend, resulting in damage to the right-hand forward sidewall fuel…
- [NTSB ERA15FA178](https://openairdocs.org/ntsb/ERA15FA178.md): Hughes 369D · Cherokee, AL · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2015 · N555JC · Substantial damage
  > The pilot's spatial disorientation during a low-level river crossing in rainy, gray, reduced visibility meteorological conditions, which resulted in the helicopter's subsequent descent and impact with the water. Contributing to the accident was the pilot's…
- [NTSB DCA15WA113](https://openairdocs.org/ntsb/DCA15WA113.md): Eurocopter AS365N3 · Jalan Sungai Lalang, Kampung Pasir baru, Semenyih, Malaysia · Accident · 6 fatal · Foreign investigation · Apr 4, 2015 · 9M-IGB · Destroyed
- [NTSB CEN15FA189](https://openairdocs.org/ntsb/CEN15FA189.md): Cessna 152 · Batesville, AR · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2015 · N65463 · Destroyed
  > The noninstrument-rated pilot's controlled flight into terrain due to an inadvertent encounter with clouds in dark night conditions. Contributing to the accident was the pilot's decision to fly at night in marginal visual meteorological conditions without the…
- [NTSB CEN15WA193](https://openairdocs.org/ntsb/CEN15WA193.md): Rans S6 - ES · Tan Rouge, Réunion · Accident · 2 fatal · Foreign investigation · Mar 30, 2015 · N974GQ · Destroyed
  > On March 30, 2015, about 0630 universal coordinated time (UTC), a Rans S6-ES airplane, French registration 974-GQ, impacted terrain near Tan Rouge, Reunion. The pilot and passenger on board were fatally injured. The airplane was destroyed. The local flight…
- [NTSB GAA15CA029](https://openairdocs.org/ntsb/GAA15CA029.md): Kerr John A Kitfox Classic IV · Logan, UT · Accident · No injuries · Data collection · Final report · Mar 28, 2015 · N195KF · Substantial damage
  > The pilot's inadequate preflight inspection/planning, which resulted in fuel exhaustion, and a loss of engine power en route.
- [NTSB ERA15WA185](https://openairdocs.org/ntsb/ERA15WA185.md): Aerospool Dynamic WT-9 · Cotopaxi Volcano, Ecuador · Accident · 1 fatal · Foreign investigation · Mar 28, 2015 · F-JUKE · Destroyed
  > On March 28, 2015, about 1300 local time, an Aerospool Dynamic WT9, French registration F-JUKE, was destroyed when it impacted terrain on Cotopaxi Volcano, Cotopaxi Province, Ecuador. The Swiss pilot was fatally injured. The flight, which originated at…
- [NTSB WPR15FA135](https://openairdocs.org/ntsb/WPR15FA135.md): Piper PA32R - 301 · Townsend, MT · Accident · 1 fatal · Field investigation · Final report · Mar 26, 2015 · C-GAUS · Substantial damage
  > The pilot's decision to depart on and to continue a visual flight rules flight over mountainous terrain into instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's lack of recent…
- [NTSB ERA15LA179](https://openairdocs.org/ntsb/ERA15LA179.md): Bell 206B · Taylors Island, MD · Accident · No injuries · Limited investigation · Final report · Mar 24, 2015 · N43CM · Substantial damage
  > A partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB DCA15WA093](https://openairdocs.org/ntsb/DCA15WA093.md): Airbus Industrie A320-211 · Barcellonette, France · Accident · 152 fatal · Foreign investigation · Mar 24, 2015 · D-AIPX · Destroyed
- [NTSB CEN15LA180](https://openairdocs.org/ntsb/CEN15LA180.md): Cessna 208B · Verdigris, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 24, 2015 · N106BZ · Substantial damage
  > The fuel pump gear manufacturer’s allowance of set-up gears made from a nonconforming material to be put in the production inventory system, the installation of a nonconforming gear in the accident airplane’s production fuel pump, and the gear’s failure,…
- [NTSB ERA15LA166](https://openairdocs.org/ntsb/ERA15LA166.md): Hawker Beechcraft G36 · Inverness, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 23, 2015 · N936B · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB ERA15FA164](https://openairdocs.org/ntsb/ERA15FA164.md): Robinson Helicopter R44 II · Orlando, FL · Accident · 3 fatal · Field investigation · Final report · Mar 22, 2015 · N30242 · Destroyed
  > An inflight loss of control due to the likely detachment of the forward left servo control tube upper rod end attachment bolt.
- [NTSB ERA15WA167](https://openairdocs.org/ntsb/ERA15WA167.md): Cessna TU206 - G · Mitu, Colombia · Accident · 2 fatal · Foreign investigation · Mar 20, 2015 · HK2327 · Substantial damage
  > On March 20, 2015, about 1805 coordinated universal time, a Cessna TU206G, Colombian registration HK-2327, was substantially damaged while ditching into the Vaupés River near the Fabio Alberto León Bentley Airport (SKMU), Mitú, Columbia. The pilot and a…
- [NTSB GAA15CA022](https://openairdocs.org/ntsb/GAA15CA022.md): Beech A36 · New Market, IN · Accident · No injuries · Data collection · Final report · Mar 17, 2015 · N900TM · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion, and a loss of engine power en-route.
- [NTSB CEN15WA178](https://openairdocs.org/ntsb/CEN15WA178.md): Piper PA32RT - 300T · Sudbury, Canada · Accident · 3 fatal · Foreign investigation · Mar 17, 2015 · C-GDWA · Substantial damage
- [NTSB GAA15CA009](https://openairdocs.org/ntsb/GAA15CA009.md): Beech 76 · Juda, WI · Accident · No injuries · Data collection · Final report · Mar 16, 2015 · N6700D · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion, and a loss of engine power enroute.
- [NTSB ERA15WA159](https://openairdocs.org/ntsb/ERA15WA159.md): Piper PA-34-200T · Macas, Ecuador · Accident · 1 fatal · Foreign investigation · Mar 15, 2015 · HC-CNC · Destroyed
  > On March 15, 2015, at an unknown time, a Piper PA-34, Ecuadorian registration HC-CNC, impacted terrain under unknown circumstances shortly after takeoff from Edmundo Carvajal Airport, Macas, Ecuador. The pilot, the sole occupant, was fatally injured. The…
- [NTSB DCA15WA097](https://openairdocs.org/ntsb/DCA15WA097.md): Boeing 777-306er 300 · Bangkok, Thailand · Incident · No injuries · Foreign investigation · Mar 15, 2015 · PH-BVB · Minor damage
  > The Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving a Boeing 777-306ER that occurred on March 15, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the Aircraft Accident Investigation…
- [NTSB CEN15FA171](https://openairdocs.org/ntsb/CEN15FA171.md): Eurocopter AS 350 B2 · Eufaula, OK · Accident · 1 fatal · Field investigation · Final report · Mar 13, 2015 · N919EM · Destroyed
  > The flight's inadvertent encounter with night instrument meteorological conditions, which resulted in the pilot turning the helicopter and subsequently descending into trees and terrain due to spatial disorientation.
- [NTSB ANC15LA015](https://openairdocs.org/ntsb/ANC15LA015.md): Airbus AS350 B2 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 13, 2015 · N814EH · Substantial damage
  > The failure of the ball bearing within the pitch change spider assembly due to its operation with no grease within the bearing, which resulted in the subsequent fracture of the spider assembly and a loss of tail rotor control authority. Also causal to the…
- [NTSB CEN15LA172](https://openairdocs.org/ntsb/CEN15LA172.md): Beech B19 · Osage Beach, MO · Accident · Serious injuries · Limited investigation · Final report · Mar 11, 2015 · N774TA · Substantial damage
  > The failure of the No. 4 piston wrist pin plug and the subsequent entry of its metal shavings into the oil system, which clogged the oil passages and caused the engine to seize. Contributing to the accident was the installation of engine parts that were not…
- [NTSB CEN15LA170](https://openairdocs.org/ntsb/CEN15LA170.md): Maule M 7-260C · Oregon, MO · Accident · No injuries · Limited investigation · Final report · Mar 10, 2015 · N55000 · Substantial damage
  > Engine vibration for reasons that could not be determined based on the available evidence.
- [NTSB DCA15WA090](https://openairdocs.org/ntsb/DCA15WA090.md): Bell UH1H - NO Series · Cape Town, South Africa · Accident · 1 fatal · Foreign investigation · Mar 8, 2015 · ZS-HBV · Destroyed
  > The government of South Africa has notified the NTSB of an accident involving a Bell UH-1H helicopter that occurred on March 08, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the government of South Africa's investigation under the…
- [NTSB CEN15CA166](https://openairdocs.org/ntsb/CEN15CA166.md): Funk B85C · Leonard, OK · Accident · No injuries · Data collection · Final report · Mar 6, 2015 · N81194 · Substantial damage
  > The improper installation of the UP elevator cable turnbuckle which became disconnected during the flight.
- [NTSB WPR15LA123](https://openairdocs.org/ntsb/WPR15LA123.md): Goudie Fisher Classic · Redlands, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 2015 · N417LG · Substantial damage
  > A loss of engine power due to fuel starvation. Contributing to the accident was the pilot's inadequate planning for the test flight, which resulted in insufficient altitude and no suitable place to land in the event of an emergency.

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=75

## 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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=74

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