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

## Cases, newest first

- [NTSB ERA13LA072](https://openairdocs.org/ntsb/ERA13LA072.md): Hansen David Daniel RV-4 · Carthage, NC · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 2012 · N416DH · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because postaccident examinations of the engine and fuel system revealed no anomalies that would have precluded normal operation. Contributing to the severity of the accident was the…
- [NTSB ERA13FA071](https://openairdocs.org/ntsb/ERA13FA071.md): Green Gary E Thorp T-18 · Pahokee, FL · Accident · 1 fatal · Field investigation · Final report · Dec 1, 2012 · N118GG · Substantial damage
  > The descent and overstress of the airplane during the descent, which resulted in the in-flight breakup of the airplane.
- [NTSB ERA13FA070](https://openairdocs.org/ntsb/ERA13FA070.md): Robinson Helicopter R22 Beta II · Apollo Beach, FL · Accident · 1 fatal · Field investigation · Final report · Nov 30, 2012 · N2626N · Substantial damage
  > Mast bumping for reasons that could not be determined because one main rotor blade was not recovered.
- [NTSB CEN13FA073](https://openairdocs.org/ntsb/CEN13FA073.md): Cessna 421C · Wells, TX · Accident · 1 fatal · Field investigation · Final report · Nov 27, 2012 · N67SR · Substantial damage
  > The pilot’s decision to continue the flight into an area of extreme weather, which led to the in-flight encounter with a thunderstorm and structural failure of the wings and tail.
- [NTSB WPR13LA052](https://openairdocs.org/ntsb/WPR13LA052.md): Cessna U206 · Van Nuys, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 25, 2012 · N5229U · Substantial damage
  > A partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.
- [NTSB WPR13FA061](https://openairdocs.org/ntsb/WPR13FA061.md): Piper PA28 · Aurora, UT · Accident · 3 fatal · Field investigation · Final report · Nov 25, 2012 · N8314E · Substantial damage
  > The pilot's failure to maintain clearance with terrain while maneuvering in a remote mountainous region. Contributing to the accident was the pilot's improper decision to traverse the remote mountainous area in high-density altitude conditions with the…
- [NTSB CEN13LA072](https://openairdocs.org/ntsb/CEN13LA072.md): Beech S35 · DeRidder, LA · Accident · Serious injuries · Limited investigation · Final report · Nov 25, 2012 · N322D · Substantial damage
  > A total loss of engine power due to oil starvation after the oil filler cap separated from the oil filler tube during flight due to corrosion. Contributing to the accident was the pilot's failure to maintain airspeed during low altitude operations, which…
- [NTSB DCA13WA031](https://openairdocs.org/ntsb/DCA13WA031.md): Boeing 737 · Bogota, Colombia · Incident · No injuries · Foreign investigation · Nov 24, 2012 · HP1371CM · No damage
  > On 24 November, 2012, at approxiumately 1636 UTC time, a Boeing B737-7V3, registration HP1371CM, operated by Copa Airlines Columbia between Bogota and Cartegna, Coulmbia, experienced a depressurization while climbing through FL240 and the oxygen masks…
- [NTSB ERA13WA078](https://openairdocs.org/ntsb/ERA13WA078.md): Cessna R172K · Cuchilla La Laja, Colombia · Accident · 1 fatal · Foreign investigation · Nov 19, 2012 · HK4890G · Substantial damage
  > On November 19, 2012, about 1030 hours local, a Cessna R172K, Colombian registration HK4890G, collided with mountainous terrain near Cuchilla La Laja – Municipio de San Francisco, Departmento de Cundinamarca, Colombia. Instrument meteorological conditions…
- [NTSB WPR13FA053](https://openairdocs.org/ntsb/WPR13FA053.md): Cessna 182D · Bondurant, WY · Accident · 1 fatal · Field investigation · Final report · Nov 17, 2012 · N61LN · Destroyed
  > The noninstrument-rated pilot’s failure to maintain clearance from terrain while maneuvering around weather.
- [NTSB WPR13LA043](https://openairdocs.org/ntsb/WPR13LA043.md): Cirrus SR22 · Show Low, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 2012 · N800RW · Substantial damage
  > The fatigue failure of an improperly installed nipple in the oil system of a supplemental type certificate-installed supercharger, which resulted in a complete loss of engine oil during cruise climb.
- [NTSB WPR13IA059](https://openairdocs.org/ntsb/WPR13IA059.md): Bell 407 · Riverton, WY · Incident · No injuries · Incident investigation · Final report · Nov 15, 2012 · N7160V · Minor damage
  > The pilot’s failure to maintain sufficient altitude to clear power lines while maneuvering at low altitude. Contributing to the accident was the pilot’s failure to follow company operating specifications for minimum altitude.
- [NTSB ERA13LA056](https://openairdocs.org/ntsb/ERA13LA056.md): Piper PA-18-150 · Canton, GA · Accident · No injuries · Limited investigation · Final report · Nov 13, 2012 · N9764P · Substantial damage
  > A partial loss of engine power due to carburetor icing, which the pilot could not correct by applying carburetor heat because the movement of the carburetor heat control arm was restricted.
- [NTSB WPR13FA037](https://openairdocs.org/ntsb/WPR13FA037.md): Cessna 421C · Shaver Lake, CA · Accident · 2 fatal · Field investigation · Final report · Nov 11, 2012 · N700EM · Substantial damage
  > The pilot's failure to regain airplane control following a sudden rapid descent during cruise, which resulted in an in-flight breakup. Contributing to the accident was the pilot's decision to make the flight with a failed vacuum pump, particularly at high…
- [NTSB ANC13LA009](https://openairdocs.org/ntsb/ANC13LA009.md): Piper PA-18-150 · Akiachak, AK · Accident · Minor injuries · Limited investigation · Final report · Nov 11, 2012 · N8466Y · Substantial damage
  > The pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and the pilot’s failure to maintain adequate airspeed during the subsequent forced landing, which resulted in an inadvertent stall.
- [NTSB ERA13LA052](https://openairdocs.org/ntsb/ERA13LA052.md): Waller Charles R Rans S12-XL · Gordon, AL · Accident · No injuries · Limited investigation · Final report · Nov 10, 2012 · N933CW · Substantial damage
  > A fatigue failure of the elevator pitch trim cable, which resulted in aerodynamic flutter of the elevator in flight and the airplane’s subsequent nose-over during the resultant precautionary landing.
- [NTSB CEN13LA054](https://openairdocs.org/ntsb/CEN13LA054.md): Cessna P210N · Conway, AR · Accident · 1 fatal · Limited investigation · Final report · Nov 7, 2012 · N887JA · Substantial damage
  > The pilot's inadequate preflight inspection, which failed to detect the lack of fuel and resulted in fuel exhaustion during climb, and the pilot's subsequent failure to maintain airplane control, which resulted in an aerodynamic stall at low altitude from…
- [NTSB CEN13FA049](https://openairdocs.org/ntsb/CEN13FA049.md): Cessna 208B · Wichita, KS · Accident · 1 fatal · Field investigation · Final report · Nov 6, 2012 · N793FE · Substantial damage
  > The total loss of engine power as a result of a fractured compressor turbine blade due to high-cycle fatigue.
- [NTSB ERA13WA068](https://openairdocs.org/ntsb/ERA13WA068.md): Embraer 810D · Chapada dos Guimaraes, Brazil · Accident · 4 fatal · Foreign investigation · Nov 1, 2012 · PT-VRV · Substantial damage
  > On November 1, 2012, at 1950 Universal Coordinated Time (UTC), an Embraer Aircraft model EMB-810D (Piper Design PA-34-220T), Brazilian registration PT-VRV, operated by a private owner, was substantially damaged following an encounter with weather and a…
- [NTSB ERA13WA050](https://openairdocs.org/ntsb/ERA13WA050.md): Cessna 206 · Kiim, Ecuador · Accident · Serious injuries · Foreign investigation · Oct 31, 2012 · HC-CBG · Substantial damage
  > On October 31, 2012, about 1545 coordinated universal time (1045 local time), a Cessna 206, Ecuadorian registration HC-CBG, was substantially damaged during a forced landing in Kiim, Ecuador. The Ecuadorian commercial pilot was seriously injured. The airplane…
- [NTSB WPR13CA027](https://openairdocs.org/ntsb/WPR13CA027.md): Robinson Helicopter R22 Beta · Hanapepe, HI · Accident · No injuries · Data collection · Final report · Oct 29, 2012 · N216AB · Substantial damage
  > The pilot's selection of an unsuitable landing area. Contributing to the pilot’s decision to land in an unsuitable landing area was his lack of helicopter experience, which led him to misidentify the precursor event.
- [NTSB ERA13LA042](https://openairdocs.org/ntsb/ERA13LA042.md): Piper PA-32R-300 · Sevierville, TN · Accident · Minor injuries · Limited investigation · Final report · Oct 28, 2012 · N4478F · Substantial damage
  > The air traffic controller’s failure to comply with the required vectoring and safety alert procedures, which resulted in the airplane’s flight into rising terrain. Contributing to the accident was the Federal Aviation Administration’s continued practice of…
- [NTSB ERA13FA039](https://openairdocs.org/ntsb/ERA13FA039.md): Beech A36 · Hooksett, NH · Accident · 2 fatal · Field investigation · Final report · Oct 25, 2012 · N4325W · Substantial damage
  > The pilot's total incapacitation in flight due to an acute heart attack.
- [NTSB DCA13WA015](https://openairdocs.org/ntsb/DCA13WA015.md): Boeing 737 · Brasilia, Brazil · Incident · No injuries · Foreign investigation · Oct 24, 2012 · PR-WJD · No damage
  > The Aeronautical Accident Prevention and Investigation Center of Brazil (CENIPA), has notified the NTSB of an incident involving a Boeing 737 that occurred on October 24, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the CENIPA…
- [NTSB WPR13LA015](https://openairdocs.org/ntsb/WPR13LA015.md): Beech N35 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Oct 18, 2012 · N671VC · Substantial damage
  > A loss of engine power due to oil starvation due to loose oil cooler attachment bolts. Contributing to the accident was inadequate maintenance during the annual inspection.
- [NTSB WPR13CA016](https://openairdocs.org/ntsb/WPR13CA016.md): Boeing 737-3H4 · Las Vegas, NV · Accident · Serious injuries · Data collection · Final report · Oct 17, 2012 · N625SW · No damage
  > The flight attendant's encounter with an unseen obstruction in the aisle, which resulted in a fall.
- [NTSB ERA13WA031](https://openairdocs.org/ntsb/ERA13WA031.md): Robinson R-44 · Moscow, Russia · Accident · 1 fatal · Foreign investigation · Oct 16, 2012 · RA-04206 · Substantial damage
  > None
- [NTSB CEN13LA015](https://openairdocs.org/ntsb/CEN13LA015.md): Young Robert Herman Woody Pusher · Cloverdale, IN · Accident · Serious injuries · Limited investigation · Final report · Oct 16, 2012 · N10RY · Minor damage
  > The total loss of engine power due to carburetor icing.
- [NTSB WPR13LA011](https://openairdocs.org/ntsb/WPR13LA011.md): Cirrus Design SR20 · Parker, AZ · Accident · No injuries · Limited investigation · Final report · Oct 15, 2012 · N499SF · Substantial damage
  > The pilot's failure to perform an adequate preflight inspection, which resulted in inadequate fuel for the flight and the subsequent fuel exhaustion and a total loss of engine power. Contributing to the accident was the pilot's failure to land the airplane at…
- [NTSB WPR13FA010](https://openairdocs.org/ntsb/WPR13FA010.md): Piper PA-28-151 · Marana, AZ · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2012 · N151SV · Substantial damage
  > The pilot’s flight in dark night conditions with no visual reference and his subsequent spatial disorientation.
- [NTSB CEN13FA012](https://openairdocs.org/ntsb/CEN13FA012.md): Cessna 172R · Simpson, LA · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2012 · N2126R · Substantial damage
  > The pilot’s loss of airplane control while maneuvering between areas of precipitation during a night cross-country flight.
- [NTSB ANC13FA004](https://openairdocs.org/ntsb/ANC13FA004.md): Grumman Aircraft ENG C-1A · Willow, AK · Accident · 1 fatal · Field investigation · Final report · Oct 15, 2012 · N27PH · Destroyed
  > The pilot’s loss of control of the airplane for reasons that could not be determined because the wreckage was not recovered from the accident site.
- [NTSB ERA13LA019](https://openairdocs.org/ntsb/ERA13LA019.md): Piper PA-23-250 · Charlotte Amalie · Accident · 3 fatal · Limited investigation · Final report · Oct 13, 2012 · N5553Y · Substantial damage
  > The pilot's attempted visual flight rules (VFR) flight into marginal VFR conditions on a dark night over water and his failure to maintain sufficient altitude, which resulted in the airplane’s controlled flight into water. Contributing to the accident was the…
- [NTSB CEN13FA010](https://openairdocs.org/ntsb/CEN13FA010.md): Robinson Helicopter R44 II · Blanco, TX · Accident · 3 fatal · Field investigation · Final report · Oct 12, 2012 · N474FA · Substantial damage
  > The pilot's loss of helicopter control as a result of spatial disorientation due to dark night conditions and marginal visual flight rules weather conditions.
- [NTSB ERA13FA014](https://openairdocs.org/ntsb/ERA13FA014.md): Bell 407 · Coolbaugh Township, PA · Accident · 2 fatal · Field investigation · Final report · Oct 10, 2012 · N108MF · Substantial damage
  > The pilot’s decision to continue visual flight rules flight into instrument meteorological conditions due to self-imposed pressure to complete the trip, which resulted in impact with trees and terrain.
- [NTSB CEN13FA009](https://openairdocs.org/ntsb/CEN13FA009.md): Bell 206B · Crowley, LA · Accident · 1 fatal · Field investigation · Final report · Oct 10, 2012 · N333DR · Substantial damage
  > The pilot’s failure to maintain clearance from the broadcast tower guy-wires.
- [NTSB WPR13FA008](https://openairdocs.org/ntsb/WPR13FA008.md): Piper PA-32R-301T · Laramie Peak, WY · Accident · 4 fatal · Field investigation · Final report · Oct 9, 2012 · N110UM · Destroyed
  > The noninstrument-rated pilot’s continued visual flight into instrument meteorological conditions, which resulted in his failure to maintain sufficient clearance from rising terrain.
- [NTSB WPR13FA006](https://openairdocs.org/ntsb/WPR13FA006.md): Garlick Helicopters UH-1H · Shady Cove, OR · Accident · Minor injuries · Field investigation · Final report · Oct 7, 2012 · N1577 · Substantial damage
  > The separation of the tail rotor gearbox and tail rotor assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs.
- [NTSB ERA13CA011](https://openairdocs.org/ntsb/ERA13CA011.md): Piper PA-28-140 · Beltzville, PA · Accident · No injuries · Data collection · Final report · Oct 6, 2012 · N44595 · Substantial damage
  > The flight instructor’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB ERA13CA010](https://openairdocs.org/ntsb/ERA13CA010.md): Moulton Howard Wells ULTRA-PUP · Lyman, ME · Accident · Minor injuries · Data collection · Final report · Oct 6, 2012 · N3073X · Substantial damage
  > The accumulation of ice in the automotive engine’s carburetor, which resulted in a loss of engine power.
- [NTSB DCA13WA174](https://openairdocs.org/ntsb/DCA13WA174.md): Cessna 210 - N · Outjo, Namibia · Incident · No injuries · Foreign investigation · Oct 6, 2012 · V5-YUL · No damage
  > On October 6, 2012 about 1400 UTC, V5-YUL, Cessna 210N, had a partial loss of engine power followed by a precautionary landing near Outjo, Namibia. Visual meteorological conditions existed at the time. None of the 4 occupans were injured. The airplane was not…
- [NTSB ENG15WA014](https://openairdocs.org/ntsb/ENG15WA014.md): Boeing 737 - 73V · Incheon, South Korea · Incident · No injuries · Foreign investigation · Oct 5, 2012 · HL8207 · No damage
  > On October 5, 2012, an Easter Jet Boeing 737-700 powered by two CFM 56-7B20 turbofan engines experienced a No. 2 engine failure while climbing through 22,500 feet after takeoff from Gimpo International Airport, Seoul, South Korean. The flight crew shutdown…
- [NTSB CEN13CA005](https://openairdocs.org/ntsb/CEN13CA005.md): Piper PA-24-250 · Colorado Springs, CO · Accident · No injuries · Data collection · Final report · Oct 5, 2012 · N6661P · Substantial damage
  > The pilot’s failure to maintain airspeed during the landing with known structural icing, which resulted in the airplane’s stall. Contributing to the accident was the pilot’s failure to divert to an area where conditions were not conducive to icing.
- [NTSB ERA12LA584](https://openairdocs.org/ntsb/ERA12LA584.md): Keuthan Buccaneer II · Granite Quarry, NC · Accident · 1 fatal · Limited investigation · Final report · Sep 30, 2012 · N710WP · Substantial damage
  > The pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB CEN12LA667](https://openairdocs.org/ntsb/CEN12LA667.md): Mcdonnell Douglas Heli 369FF · Decorah, IA · Accident · No injuries · Limited investigation · Final report · Sep 30, 2012 · N530KD · Substantial damage
  > The pilot's failure to properly manage the helicopter's available fuel supply, which led to a total loss of engine power due to fuel exhaustion. Contributing to the accident was the improper calibration of the fuel gauge and the fuel-low warning light.
- [NTSB WPR12LA439](https://openairdocs.org/ntsb/WPR12LA439.md): Cessna 152 · Eugene, OR · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 2012 · N95840 · Substantial damage
  > A total loss of engine power due to fuel exhaustion during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have resulted in the loss of engine power.
- [NTSB ERA12LA589](https://openairdocs.org/ntsb/ERA12LA589.md): Cessna 421B · Selma, AL · Accident · No injuries · Limited investigation · Final report · Sep 29, 2012 · N1537T · Substantial damage
  > The pilot’s improper fuel management, which resulted in a total loss of engine power on the right engine and a partial loss of engine power on the left engine due to fuel starvation.
- [NTSB ANC12CA112](https://openairdocs.org/ntsb/ANC12CA112.md): Piper PA-12 · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Sep 23, 2012 · N4483M · Substantial damage
  > The pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB ERA12FA572](https://openairdocs.org/ntsb/ERA12FA572.md): Cessna 172S · Land O'Lakes, FL · Accident · 1 fatal · Field investigation · Final report · Sep 22, 2012 · N21750 · Substantial damage
  > The pilot’s decision to continue the cross-country flight while fatigued, which resulted in him falling asleep during the initial descent for landing.
- [NTSB CEN12LA659](https://openairdocs.org/ntsb/CEN12LA659.md): Lindstrand Balloons 210S · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 22, 2012 · N608RR · Minor damage
  > The failure of the balloon envelope parachute vent to properly seat, which resulted in the uncontrolled descent of the balloon. The reason the vent did not properly seat during the accident flight could not be determined because the vent operated properly…

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

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

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