# 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 69 of 718 · 35,889 cases

## Cases, newest first

- [NTSB ERA16LA123](https://openairdocs.org/ntsb/ERA16LA123.md): Taylorcraft BL · St. Petersburg, FL · Accident · No injuries · Class 3 · Limited · Final report · Mar 5, 2016 · N22661 · Substantial damage
  > A partial loss of engine power due to the fatigue fracture of the No. 3 cylinder head stud.
- [NTSB ENG16RA026](https://openairdocs.org/ntsb/ENG16RA026.md): Cessna 208 · Georgetown, Guyana · Incident · No injuries · Foreign investigation · Mar 3, 2016 · 8R-GHT · No damage
  > The Guyana Civil Aviation Authority (GCAA) has notified the NTSB of an incident involving a Cessna 208B, which occurred on March 3, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA investigation under the provisions of ICAO…
- [NTSB GAA16CA143](https://openairdocs.org/ntsb/GAA16CA143.md): Bell 47 · Agua Dulce, CA · Accident · Minor injuries · Data collection · Final report · Mar 2, 2016 · N568TB · Substantial damage
  > The pilot's failure to set the appropriate collective friction prior to releasing the collective in flight, which resulted in decreased main rotor pitch, settling with power, and an impact with terrain.
- [NTSB CEN16LA118](https://openairdocs.org/ntsb/CEN16LA118.md): Cessna 150G · Simmesport, LA · Accident · No injuries · Limited investigation · Final report · Mar 2, 2016 · N3339J · Substantial damage
  > The installation of an improper bearing and thrust washer during engine overhaul, which resulted in failure of the connecting rods and a subsequent total loss of engine power.
- [NTSB CEN16FA116](https://openairdocs.org/ntsb/CEN16FA116.md): Curtiss Wright Travel AIR 4000 · Palmer Lake, CO · Accident · 2 fatal · Field investigation · Final report · Mar 2, 2016 · N6464 · Destroyed
  > The pilot's failure to maintain sufficient airspeed while maneuvering at low altitude in strong gusting winds, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall/spin. Contributing to the accident was the pilot's…
- [NTSB CEN16LA112](https://openairdocs.org/ntsb/CEN16LA112.md): Cirrus Design SR22 · Laguna Pueblo, NM · Accident · Minor injuries · Limited investigation · Final report · Feb 29, 2016 · N2711M · Substantial damage
  > A total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot's inadequate oversight of the airplane's refueling and her subsequent failure to verify and monitor the fuel quantity before and during the flight.
- [NTSB CEN16WA120](https://openairdocs.org/ntsb/CEN16WA120.md): Cessna 152 · Agostyan, Hungary · Accident · No injuries · Foreign investigation · Feb 28, 2016 · HA-VOK · Destroyed
  > On February 28, 2016, at 1003 UTC, a Cessna FA152 (S/N 0346), HA-VOK, impacted wooded terrain near Agostyán, Tata, Hungary. The aircraft was destroyed and the two occupants on board were fatally injured. The aircraft was enroute to Godollo Airport (LHGD),…
- [NTSB CEN16LA115](https://openairdocs.org/ntsb/CEN16LA115.md): Beech V35 · Seymour, IN · Accident · No injuries · Limited investigation · Final report · Feb 27, 2016 · N2714T · Substantial damage
  > The pilot's improper placement of the fuel selector handle between two tank positions, which resulted in a restricted fuel flow to the engine and the initial loss of engine power, and his improper decision to use the high-boost auxiliary fuel pump for an…
- [NTSB ENG16WA018](https://openairdocs.org/ntsb/ENG16WA018.md): Viking Air DHC-6 · Soli Ghoptevir, Nepal · Accident · 25 fatal · Foreign investigation · Feb 24, 2016 · 9N-AHH · Destroyed
- [NTSB ERA16LA110](https://openairdocs.org/ntsb/ERA16LA110.md): Cirrus Design SR22 · Palatka, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 23, 2016 · N256CD · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because engine examination, an engine test run, and review of engine monitor data did not reveal any evidence of preimpact anomalies that would have precluded normal operation.
- [NTSB ERA16LA109](https://openairdocs.org/ntsb/ERA16LA109.md): Piper PA28 · Port Jefferson, NY · Accident · 1 fatal · Limited investigation · Final report · Feb 21, 2016 · N29099 · Substantial damage
  > The flight instructor's inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA16FA108](https://openairdocs.org/ntsb/ERA16FA108.md): Beech A36 · Marshville, NC · Accident · 1 fatal · Field investigation · Final report · Feb 19, 2016 · N61WB · Substantial damage
  > The pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the severity of the pilot's injuries was his failure to have a properly secured shoulder harness at the time of the accident.
- [NTSB WPR16FA072](https://openairdocs.org/ntsb/WPR16FA072.md): Bell 206B · Honolulu, HI · Accident · 1 fatal · Field investigation · Final report · Feb 18, 2016 · N80918 · Substantial damage
  > The in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.
- [NTSB CEN16LA107](https://openairdocs.org/ntsb/CEN16LA107.md): Cessna P210N · Bryan, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 16, 2016 · N732FU · Substantial damage
  > A failure of the crankshaft due to improper torque of the crankcase through bolts.
- [NTSB DCA16CA089](https://openairdocs.org/ntsb/DCA16CA089.md): Airbus Industrie A319 132 · Minneapolis, MN · Accident · Serious injuries · Data collection · Final report · Feb 14, 2016 · N827AW · No damage
  > an encounter with turbulence that resulted in a serious injury to a passenger who was standing when the fasten seatbelt sign was illuminated.
- [NTSB DCA16LA096](https://openairdocs.org/ntsb/DCA16LA096.md): Lockheed 382G · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Feb 12, 2016 · N401LC · Substantial damage
  > The fatigue failure of the forward pressure bulkhead canted web that originated from stress corrosion cracking areas. Contributing to the failure were inspection procedures and intervals inadequate to identify the crack.
- [NTSB CEN16WA104](https://openairdocs.org/ntsb/CEN16WA104.md): Cessna 172 · Jaen, Spain · Accident · 1 fatal · Foreign investigation · Feb 10, 2016 · EC-LSY · Destroyed
- [NTSB WPR16LA066](https://openairdocs.org/ntsb/WPR16LA066.md): Beech B36TC · Santa Barbara, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 9, 2016 · N113TM · Substantial damage
  > A total loss of engine power during initial climbout for reasons that could not be determined because postaccident examination and testing of the engine did not reveal any mechanical anomalies that would have precluded normal operation.
- [NTSB ERA16CA105](https://openairdocs.org/ntsb/ERA16CA105.md): Piper PA34 · Williamsport, PA · Accident · No injuries · Data collection · Final report · Feb 9, 2016 · N234NC · Substantial damage
  > The pilot's failure to maintain altitude in cruise flight due to his diverted attention, which resulted in controlled flight into terrain.
- [NTSB DCA16WA099](https://openairdocs.org/ntsb/DCA16WA099.md): Bombardier DHC8 · Calgary, Alberta, Canada · Incident · No injuries · Foreign investigation · Feb 9, 2016 · C-GWEP · Minor damage
  > The Transportation Safety Board (TSB) of Canada has notified the NTSB of an incident involving a Bombardier DHC8-402 that occurred on February 9, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the TSB investigation under the…
- [NTSB ERA16WA107](https://openairdocs.org/ntsb/ERA16WA107.md): Bell 206 · Bejucal, Venezuela · Accident · 1 fatal · Foreign investigation · Feb 6, 2016 · YV250T · Destroyed
  > On February 6, 2016, about 1710 universal coordinated time, a Bell 206 L-3 helicopter, Venezuelan registration YV250T, was destroyed when it collided with terrain after a loss of control in flight. The flight originated at the Aerópuerto De San Juan De Los…
- [NTSB WPR16LA081](https://openairdocs.org/ntsb/WPR16LA081.md): Mcdonnell Douglas Helicopter 600N · Ashland, OR · Accident · No injuries · Limited investigation · Final report · Feb 5, 2016 · N745BW · Substantial damage
  > Fatigue cracking of a main rotor blade for reasons that could not be determined based on the available information.
- [NTSB DCA16WA085](https://openairdocs.org/ntsb/DCA16WA085.md): Sikorsky S76 · Lagos, Nigeria · Incident · No injuries · Foreign investigation · Feb 3, 2016 · 5N-BQJ · Substantial damage
  > The Nigeria Accident Investigation Bureau (NAIB) has notified the NTSB of an accident involving a Sikorsky S76C helicopter that occurred on February 03, 2016. The NTSB has appointed a U.S. Accredited Representative to assist NAIB's investigation under the…
- [NTSB ERA16LA103](https://openairdocs.org/ntsb/ERA16LA103.md): Piper PA 28-161 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Feb 2, 2016 · N8466G · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examination of the airplane revealed no mechanical anomalies that would have contributed to the power loss.
- [NTSB WPR16LA060](https://openairdocs.org/ntsb/WPR16LA060.md): Piper PA46 · Burns, OR · Accident · No injuries · Limited investigation · Final report · Jan 31, 2016 · N777PG · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination revealed no evidence of an anomaly that would have precluded normal operation. Contributing to the accident was a preexisting landing gear anomaly that…
- [NTSB WPR16WA062](https://openairdocs.org/ntsb/WPR16WA062.md): Piper PA28 · Barwon Heads, Australia, Australia · Accident · 4 fatal · Foreign investigation · Jan 29, 2016 · VH-PXD · Destroyed
  > On January 29, 2016, at 1155 local time, a Piper PA 28-235, VH-PXD, was ditched in the waters near Barwon Heads, Australia. The airplane was operated by a private individual under the pertinent regulations of the Government of Australia. The airplane was…
- [NTSB ERA16LA098](https://openairdocs.org/ntsb/ERA16LA098.md): Eurocopter France EC 130 B4 · Shoals, WV · Accident · No injuries · Limited investigation · Final report · Jan 29, 2016 · N133HN · Substantial damage
  > The improper locking of the rear passenger door by the specialty nurse, which resulted in the door separating from the helicopter in flight.
- [NTSB DCA16CA077](https://openairdocs.org/ntsb/DCA16CA077.md): Boeing 737 7H4 · Titusville, FL · Accident · Serious injuries · Data collection · Final report · Jan 28, 2016 · N718SW · No damage
  > an inadvertent encounter with clear air turbulence.
- [NTSB ERA16LA094](https://openairdocs.org/ntsb/ERA16LA094.md): Robinson Helicopter R22 · Lindenhurst, NY · Accident · No injuries · Class 3 · Limited · Final report · Jan 27, 2016 · N404LE · Substantial damage
  > A rough running engine as a result of an intermittent failure of the left magneto for reasons that could not be determined, which resulted in a subsequent autorotation, impact with a sign, and rollover.
- [NTSB ENG16RA024](https://openairdocs.org/ntsb/ENG16RA024.md): Airbus A320 · Suvarnabhumi Airport, Thailand · Incident · No injuries · Foreign investigation · Jan 25, 2016 · HS-TXN · No damage
  > The Aircraft Accident Investigation Committee of Thailand has notified the NTSB of an incident involving an A320-232 that occurred January 25, 2016. The NTSB has appointed a U.S. Accredited Representative to assist in the investigation under the provisions of…
- [NTSB WPR16WA191](https://openairdocs.org/ntsb/WPR16WA191.md): Vans RV8 · Chiang Mai, Thailand · Accident · No injuries · Foreign investigation · Jan 24, 2016 · HS-GMC · Substantial damage
  > On January 24, 2016, about 1030 local time, a Van RV-8, HS-GMC, initiated a forced landing near Chiang Mai, Thailand after experiencing a total loss of engine power during cruise flight. The owner/pilot, and one passenger, were not injured; the airplane…
- [NTSB GAA16CA107](https://openairdocs.org/ntsb/GAA16CA107.md): Piper PA 46 · Ottawa, KS · Accident · Minor injuries · Data collection · Final report · Jan 19, 2016 · N113WB · Substantial damage
  > The flight crews encounter with un-forecasted freezing rain resulting in an uncontrolled descent, forced landing, and substantial damage to the airplane's firewall, and forward pressure bulkhead.
- [NTSB WPR16FA055](https://openairdocs.org/ntsb/WPR16FA055.md): Airbus EC130 · Hanalei, HI · Accident · Serious injuries · Field investigation · Final report · Jan 18, 2016 · N11VQ · Substantial damage
  > The fatigue failure of the engine fuel pipe as a result of vibration caused by a worn starter-generator front bearing support, which excited the fuel pipe and caused it to oscillate at a resonant frequency, and a subsequent loss of engine power due to fuel…
- [NTSB WPR16FA054](https://openairdocs.org/ntsb/WPR16FA054.md): Cessna 525 · Cedar Fort, UT · Accident · 2 fatal · Field investigation · Final report · Jan 18, 2016 · N711BX · Destroyed
  > The pilot's loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup. Contributing to the accident…
- [NTSB ERA16LA091](https://openairdocs.org/ntsb/ERA16LA091.md): Cessna 152 · Madison, GA · Accident · Serious injuries · Limited investigation · Final report · Jan 18, 2016 · N6135M · Substantial damage
  > The pilot’s improper fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN16LA090](https://openairdocs.org/ntsb/CEN16LA090.md): Bellanca 17-30A · Overbrook, OK · Accident · No injuries · Limited investigation · Final report · Jan 17, 2016 · N194DW · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion, and his subsequent decision to circle to the north end of the airport due to a light tailwind condition instead of making a downwind landing.
- [NTSB CEN16WA088](https://openairdocs.org/ntsb/CEN16WA088.md): Socata TB20 · Cuenca, Spain, Spain · Accident · 4 fatal · Foreign investigation · Jan 16, 2016 · EC-ESK · Destroyed
  > On January 16, 2016, about 1532 coordinated universal time, a Socata TB-20 single engine airplane, serial number 747, registry EC-ESK, was destroyed after impacting terrain near Cuenca, Spain, during cruise flight. The pilot and three passengers were fatally…
- [NTSB ERA16FA089](https://openairdocs.org/ntsb/ERA16FA089.md): Caughran Terry Flightstar II · Wake, VA · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2016 · N82652 · Substantial damage
  > Failure of the left wing in flight due to compression loading from wing loads combined with preexisting damage.
- [NTSB CEN16FA087](https://openairdocs.org/ntsb/CEN16FA087.md): Piper PA 22-108 · Garden City, TX · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2016 · N4751Z · Destroyed
  > The pilot's failure to maintain clearance with terrain during a low altitude flight.
- [NTSB CEN16FA086](https://openairdocs.org/ntsb/CEN16FA086.md): Beech C35 · Meeker, CO · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2016 · N2025D · Destroyed
  > The non-instrument-rated pilot's decision to fly the airplane in instrument meteorological conditions at high altitude for greater than 30 minutes without the use of supplemental oxygen which resulted in hypoxia, and a subsequent loss of control. Contributing…
- [NTSB ENG16WA008](https://openairdocs.org/ntsb/ENG16WA008.md): Boeing 767 · Lima, Peru · Incident · No injuries · Foreign investigation · Jan 11, 2016 · CC-CXK · No damage
  > On January 11, 2016, a Boeing 767-316ER, powered by two General Electric CF6-80C2B6F turbofan engines experienced an inflight uncommnaded shutdown of the right engine. The engine was successfully restarted and the flight continued to its intended destination.…
- [NTSB DCA16RA045](https://openairdocs.org/ntsb/DCA16RA045.md): Bombardier CL600 2B19 · Kiruna, Sweden · Accident · 2 fatal · Foreign investigation · Jan 8, 2016 · SE-DUX · Destroyed
  > import
- [NTSB CEN16WA074](https://openairdocs.org/ntsb/CEN16WA074.md): Cirrus SR20 · Egmond, Netherlands · Accident · 1 fatal · Foreign investigation · Jan 4, 2016 · G-ZOGT · Destroyed
  > On January 4, 2016, about 1356 UTC, a Cirrus Design, Incorporated SR-20, United Kingdom registration G-ZOGT, owned by a private individual, was destroyed when it impacted into the North Sea near Egmond aan Zee, The Netherlands, under unknown circumstances.…
- [NTSB CEN16FA073](https://openairdocs.org/ntsb/CEN16FA073.md): Cessna 172N · Wayne, NE · Accident · 1 fatal · Field investigation · Final report · Jan 4, 2016 · N5104D · Substantial damage
  > The noninstrument-rated pilot's improper decision to continue visual flight into instrument meteorological conditions, which resulted in a collision with terrain.
- [NTSB DCA16CA041](https://openairdocs.org/ntsb/DCA16CA041.md): Embraer ERJ 170 100 SE · Raleigh, NC · Accident · Serious injuries · Data collection · Final report · Jan 3, 2016 · N643RW · No damage
  > an encounter with turbulence resulting in a serious injury to a flight attendant.
- [NTSB WPR16LA047](https://openairdocs.org/ntsb/WPR16LA047.md): Kevin Metzler Velocity STD RG · Rosamond, CA · Accident · No injuries · Limited investigation · Final report · Jan 2, 2016 · N133SV · Substantial damage
  > A partial loss of engine power due to failure of the No. 1 connecting rod as a result of multiple fatigue cracks for reasons that could not be determined during on postaccident examination.
- [NTSB ANC16LA012](https://openairdocs.org/ntsb/ANC16LA012.md): Cessna 208B · Anaktuvuk Pass, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 2, 2016 · N540ME · Substantial damage
  > The pilot’s continued flight into deteriorating, flat light weather conditions, which resulted in impact with mountainous, snow-covered terrain.
- [NTSB ERA16WA081](https://openairdocs.org/ntsb/ERA16WA081.md): Bell 429 · Rostov-na-Dony, Russia · Accident · Serious injuries · Foreign investigation · Jan 1, 2016 · RA-01617 · Destroyed
  > Subject: ERA16WA081 Bell 429, RA-01617, Rostov-na-Dony, Russia On January 1, 2016, about 0621 universal coordinated time, a Bell 429, Russian registration RA-01617, was substantially damaged by collision with terrain during an uncontrolled descent following a…
- [NTSB DCA16WA040](https://openairdocs.org/ntsb/DCA16WA040.md): Boeing 777-333ER · Calgary, Canada · Incident · No injuries · Foreign investigation · Dec 31, 2015 · C-FRAM · No damage
  > The NTSB was notified of an incident involving a Boeing B777-333 aircraft, registration C-FRAM, that occurred enroute from Shanghai, China to Toronto, Canada, which resulted in the flight being diverted to Calgary, Canada. The incident is being investigated…
- [NTSB CEN16LA079](https://openairdocs.org/ntsb/CEN16LA079.md): Piper 28-140 · Republic, MO · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 2015 · N4643R · Destroyed
  > The pilot's inadequate fuel management, which resulted in fuel starvation and a total loss of engine power during cruise flight.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.