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

## Cases, newest first

- [NTSB ERA12LA206](https://openairdocs.org/ntsb/ERA12LA206.md): Mooney M20M · Amisville, VA · Accident · Serious injuries · Limited investigation · Final report · Mar 3, 2012 · N486KC · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined because of the damage due to the postcrash fire.
- [NTSB DCA12CA059](https://openairdocs.org/ntsb/DCA12CA059.md): Bombardier CL-600-2B19 · Harrisburg, PA · Accident · Serious injuries · Data collection · Final report · Mar 3, 2012 · N453AW · No damage
  > an inadvertent encounter with clear air turbulence during descent.
- [NTSB ERA12FA205](https://openairdocs.org/ntsb/ERA12FA205.md): Cessna LC42-550FG · Salisburry, NC · Accident · 2 fatal · Field investigation · Final report · Mar 2, 2012 · N167ZP · Destroyed
  > The non-instrument-rated pilot's decision to continue flight into instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.
- [NTSB DCA12CA045](https://openairdocs.org/ntsb/DCA12CA045.md): Boeing 767 · Angers, France · Accident · Serious injuries · Data collection · Final report · Feb 26, 2012 · N829MH · No damage
  > the flight attendant inadvertently tripping over a passenger's luggage strap that was protruding into the isle.
- [NTSB ERA12WA221](https://openairdocs.org/ntsb/ERA12WA221.md): Piper PA-34 · Belém, Brazil · Accident · 3 fatal · Foreign investigation · Feb 25, 2012 · PR-LAB · Substantial damage
  > On February 25, 2012, about 1150 coordinated universal time, a Piper PA-34-220T, Brazilian registration PR-LAB, was substantially damaged when it impacted terrain shortly after departure from Belém-Brigadeiro Protásio de Oliveira Airport (SBJC), Belém,…
- [NTSB CEN12LA175](https://openairdocs.org/ntsb/CEN12LA175.md): Piper PA-28-161 · Rapid City, SD · Accident · No injuries · Limited investigation · Final report · Feb 24, 2012 · N20GG · Substantial damage
  > The loss of engine power during climb due to carburetor icing. Contributing to the accident was the limited travel of the carburetor heat valve which prevented application of maximum carburetor heat.
- [NTSB WPR12LA119](https://openairdocs.org/ntsb/WPR12LA119.md): Boeing 737-7H4 · Pawnee, NE · Accident · Serious injuries · Limited investigation · Final report · Feb 23, 2012 · N915WN · No damage
  > The airplane's encounter with moderate turbulence during cruise flight, which resulted in a serious injury to a flight attendant.
- [NTSB WPR12LA113](https://openairdocs.org/ntsb/WPR12LA113.md): Haycraft Sport Hornet · Mariposa, CA · Accident · No injuries · Limited investigation · Final report · Feb 21, 2012 · N72PD · Substantial damage
  > Improper clearance and inadequate heat shielding between engine components and the exhaust system, which resulted in an in-flight fire.
- [NTSB CEN12FA164](https://openairdocs.org/ntsb/CEN12FA164.md): Piper PA-24-250 · Albany, TX · Accident · 2 fatal · Field investigation · Final report · Feb 21, 2012 · N7147P · Substantial damage
  > The loss of flight instrumentation due to a failed vacuum pump while flying a night without a discernable horizon, which resulted in the pilot's spatial disorientation and an in-flight loss of control and impact with terrain. Contributing was the continued…
- [NTSB WPR12LA109](https://openairdocs.org/ntsb/WPR12LA109.md): Robinson Helicopter R22 Beta · Antioch, CA · Accident · No injuries · Limited investigation · Final report · Feb 20, 2012 · N7508Y · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision. Contributing to the accident was the failure of air traffic control personnel to issue the helicopter pilot a prompt and appropriate alternate…
- [NTSB ERA12LA191](https://openairdocs.org/ntsb/ERA12LA191.md): Cessna 172N · Flat Rock, VA · Accident · No injuries · Limited investigation · Final report · Feb 17, 2012 · N4737D · Substantial damage
  > The partial loss of engine power due to the failure of the exhaust valve spring seat for reasons that could not be determined.
- [NTSB DCA12CA042](https://openairdocs.org/ntsb/DCA12CA042.md): Embraer EMB120 · Iliamna, AK · Accident · No injuries · Data collection · Final report · Feb 16, 2012 · N1110J · Substantial damage
  > the maintenance personnel's failure to install the cotter pins that secured castellated nuts on the left elevator vertical hinge bolts, which resulted in the left elevator partially detaching in flight. Contributing to the accident was the failure of…
- [NTSB WPR12FA105](https://openairdocs.org/ntsb/WPR12FA105.md): Cessna 172S · North Bend, WA · Accident · 3 fatal · Field investigation · Final report · Feb 15, 2012 · N665SP · Substantial damage
  > The pilot's physical impairment due to alcohol, which adversely affected his ability to operate the airplane and to maintain clearance from mountainous terrain while operating in dark night conditions.
- [NTSB ERA12LA180](https://openairdocs.org/ntsb/ERA12LA180.md): Piper PA-32-260 · Amory, MS · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 2012 · N3688W · Substantial damage
  > The pilot's inadequate preflight and in-flight planning and decision-making, including his inadequate weather evaluation and his delayed diversion to a closer airport, which resulted in a total loss of engine power due to fuel exhaustion.
- [NTSB ERA12WA200](https://openairdocs.org/ntsb/ERA12WA200.md): Bombardier 60 · Europe, A1 · Incident · No injuries · Foreign investigation · Feb 12, 2012 · ES-PVP · Minor damage
  > On February 12, 2012, at an unknown time and location, the cargo compartment door of a Bombardier Aerospace Learjet 60, Estonia registration ES-PVP, separated from the airframe in flight. The airplane incurred minor damage, while the two crewmembers and four…
- [NTSB DCA12WA039](https://openairdocs.org/ntsb/DCA12WA039.md): Boeing 737 · London, United Kingdom · Incident · No injuries · Foreign investigation · Feb 11, 2012 · G-THOO · No damage
  > The United Kingdom's Air Accidents Investigation Branch (AAIB) has notified the NTSB of an accident involving a Boeing 737 that occurred on February, 11, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the…
- [NTSB WPR12LA099](https://openairdocs.org/ntsb/WPR12LA099.md): Cessna 172M · Cusick, WA · Accident · No injuries · Limited investigation · Final report · Feb 9, 2012 · N5100R · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB WPR12FA098](https://openairdocs.org/ntsb/WPR12FA098.md): Cessna 210 · Morgan, UT · Accident · 2 fatal · Field investigation · Final report · Feb 9, 2012 · N9619T · Substantial damage
  > The non-instrument-rated pilot’s poor planning and continued visual flight rules flight into instrument meteorological conditions and failure to maintain clearance from mountainous terrain.
- [NTSB CEN12FA152](https://openairdocs.org/ntsb/CEN12FA152.md): Varga 2150A · Frankston, TX · Accident · 1 fatal · Field investigation · Final report · Feb 8, 2012 · N8293J · Substantial damage
  > The loss of engine power due to carburetor ice, which resulted in the pilot ditching the airplane into the lake. Contributing to the accident was the pilot’s decision not to apply carburetor heat.
- [NTSB DCA12CA033](https://openairdocs.org/ntsb/DCA12CA033.md): Antonov AN124 · Anchorage, AK · Accident · Serious injuries · Data collection · Final report · Feb 2, 2012 · RA82046 · No damage
  > an inadvertent encounter with Clear Air Turbulence that resulted in serious injuries to two crewmembers.
- [NTSB WPR12CA084](https://openairdocs.org/ntsb/WPR12CA084.md): Schweizer SGS 2-33A · Peoria, AZ · Accident · Minor injuries · Data collection · Final report · Jan 28, 2012 · N17873 · Substantial damage
  > The glider pilot released from the tow airplane at a lower altitude than the planned altitude, which resulted in an off-airport landing.
- [NTSB ERA12LA165](https://openairdocs.org/ntsb/ERA12LA165.md): Piper PA-31-310 · Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Jan 28, 2012 · N30DC · Substantial damage
  > The pilot’s in-flight misjudgment of fuel remaining resulting in fuel exhaustion and a total loss of engine power. Contributing to the accident was an inadequate fuel quantity for the flight for reasons that could not be determined during postaccident…
- [NTSB ERA12IA169](https://openairdocs.org/ntsb/ERA12IA169.md): Cessna 172S · Jackson, MS · Incident · No injuries · Incident investigation · Final report · Jan 28, 2012 · N427CP · No damage
  > The separation of the propeller blade tip due to fatigue cracking that initiated at the blade’s leading edge.
- [NTSB OPS12IA303](https://openairdocs.org/ntsb/OPS12IA303.md): Embraer EMB-145LR · Farmersville, TX · Incident · No injuries · Incident investigation · Final report · Jan 25, 2012 · N639AE · No damage
  > The flight's continued operation through an area containing substantial convective weather activity. Contributing to the accident was the air traffic control/traffic management unit's lack of awareness and recognition of the effect of weather movement on the…
- [NTSB WPR12LA081](https://openairdocs.org/ntsb/WPR12LA081.md): Mas Events Nemesis · Camarillo, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 2012 · F-WNXT · Substantial damage
  > A partial loss of engine power during cruise flight due to incorrectly installed airframe components, which came into contact with a high pressure fuel line and resulted in its failure. Contributing to the accident was an undetermined failure of the primary…
- [NTSB CEN13WA102](https://openairdocs.org/ntsb/CEN13WA102.md): Robinson Helicopter R44 · Oosterschelde, Netherlands · Incident · No injuries · Foreign investigation · Jan 21, 2012 · PH-WMW · No damage
  > On January 21, 2012, at 1430 universal coordinated time, a Robinson Helicopter Company model R44, Dutch registration PH-WMW, made an uneventful forced landing after experiencing a partial loss of engine power near Oosterschelde, The Netherlands. The pilot and…
- [NTSB ERA12WA155](https://openairdocs.org/ntsb/ERA12WA155.md): Bell 206 · Montana Auyantepui, Venezuela · Accident · 5 fatal · Foreign investigation · Jan 18, 2012 · YV1985 · Destroyed
  > On January 18, 2012, about 1715 universal coordinated time, a Bell 206 L-4 helicopter, Venezuelan registration YV1985, was destroyed when it collided with a mountain during a sightseeing flight near Montaña Auyantepui, Parque Nacional Canaima, in the State of…
- [NTSB CEN12WA138](https://openairdocs.org/ntsb/CEN12WA138.md): Piper PA-31-235 · Powys, Wales, United Kingdom, United Kingdom · Accident · No injuries · Foreign investigation · Jan 18, 2012 · G-BWHF · Substantial damage
  > On January 18, 2012, about 1145 universal time (UTC), a United Kingdom registered Piper PA-31-235, G-BWHF, sustained substantial damage when it impacted terrain near Leighton Welshpool, Powys, Wales, United Kingdom. The pilot and the passenger were fatally…
- [NTSB DCA12WA029](https://openairdocs.org/ntsb/DCA12WA029.md): Boeing 747 · London, United Kingdom · Incident · No injuries · Foreign investigation · Jan 17, 2012 · HL7601 · No damage
  > The UK Air Accidents Investigation Branch (AAIB) has notified the NTSB of an incident involving a Boeing 747 that occurred on January 17, 2012. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB investigation under the provisions of…
- [NTSB DCA12FA024](https://openairdocs.org/ntsb/DCA12FA024.md): Bell 214 · Camp Bastion, Afghanistan · Accident · 3 fatal · Field investigation · Final report · Jan 16, 2012 · N5748M · Destroyed
  > the overtravel of the collective sleeve, which led to a severe and sudden reduction in main rotor blade collective pitch, resulting in a loss of control of the helicopter. The reason for the collective sleeve overtravel could not be determined since much of…
- [NTSB ERA12LA145](https://openairdocs.org/ntsb/ERA12LA145.md): Piper PA-24-180 · Brewster, MA · Accident · 2 fatal · Limited investigation · Final report · Jan 15, 2012 · N7648P · Substantial damage
  > The flight crew’s loss of airplane control.
- [NTSB ERA12WA159](https://openairdocs.org/ntsb/ERA12WA159.md): Beech A36 · Mato Grosso, Brazil · Accident · 3 fatal · Foreign investigation · Jan 14, 2012 · PR-RGF · Destroyed
  > On January 14, 2012, about 1000 universal coordinated time, a Beech A36, Brazilian registration PR-RGF, was destroyed when it impacted terrain, following a loss of control during cruise flight into deteriorating weather near Mato Grosso, Brazil. The…
- [NTSB CEN12LA134](https://openairdocs.org/ntsb/CEN12LA134.md): Aero Commander 500-B · Bartlesville, OK · Accident · Minor injuries · Limited investigation · Final report · Jan 14, 2012 · N524HW · Substantial damage
  > The total loss of engine power due to fuel exhaustion and the pilot’s inadequate preflight inspection, which did not correctly identify the airplane’s fuel quantity before departure.
- [NTSB ERA12WA142](https://openairdocs.org/ntsb/ERA12WA142.md): Cirrus Design SR22 · Andros Island, Bahamas · Accident · No injuries · Foreign investigation · Jan 7, 2012 · N723EA · Substantial damage
  > On January 7, 2012, about 1324 eastern standard time, a Cirrus Design Corp. SR22, N723EA, registered to and operated by M&W Aviation LLC, descended into water near Andros Island, Bahamas, following deployment of the Cirrus Airframe Parachute System (CAPS).…
- [NTSB CEN12WA144](https://openairdocs.org/ntsb/CEN12WA144.md): Robinson R22 · Lincolnshire, United Kingdom · Accident · No injuries · Foreign investigation · Jan 6, 2012 · G-CHZN · Substantial damage
  > On January 6, 2012, about 1127 universal time (UTC), a United Kingdom registered Robinson R22 Beta, G-CHZN, sustained substantial damage when it impacted terrain near Witchford, Cambridgeshire, United Kingdom. The pilot was fatally injured. The investigation…
- [NTSB CEN12LA128](https://openairdocs.org/ntsb/CEN12LA128.md): Sanderson Pitts Special SPS-1 · Revere, MN · Accident · No injuries · Limited investigation · Final report · Jan 5, 2012 · N330BL · Substantial damage
  > The total loss of engine power during cruise flight due to fuel contamination and the inadequate design of the fuel system.
- [NTSB CEN12LA118](https://openairdocs.org/ntsb/CEN12LA118.md): Piper PA-32-260 · Elk Rapids, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 2011 · N997TB · Substantial damage
  > The loss of engine power due to the failure of the exhaust valve.
- [NTSB ERA12WA133](https://openairdocs.org/ntsb/ERA12WA133.md): Piper PA28 · Andres Bello,Tachira, Venezuela · Accident · 2 fatal · Foreign investigation · Dec 29, 2011 · HK3934 · Substantial damage
  > On December 29, 2011, about 1415 universal coordinated time, a Piper PA28-161, Columbian registration HK3934, was substantially damaged when it impacted terrain while in cruise flight near Andres Bello, Tachira, Venezuela. The two pilots were fatally injured.…
- [NTSB WPR12CA072](https://openairdocs.org/ntsb/WPR12CA072.md): Schweizer SGS 1-26B · Murrieta, CA · Accident · No injuries · Data collection · Final report · Dec 28, 2011 · N8641R · Substantial damage
  > The glider's encounter with insufficient atmospheric lift to maintain soaring flight.
- [NTSB ERA12CA119](https://openairdocs.org/ntsb/ERA12CA119.md): Hughes 369D · Fall Branch, TN · Accident · No injuries · Data collection · Final report · Dec 21, 2011 · N500TN · Substantial damage
  > The pilot's improper decision to continue a visual flight into instrument meteorological conditions, which resulted in a wire strike.
- [NTSB ERA12FA115](https://openairdocs.org/ntsb/ERA12FA115.md): Socata TBM 700 · Morristown, NJ · Accident · 5 fatal · Field investigation · Final report · Dec 20, 2011 · N731CA · Destroyed
  > The airplane’s encounter with unforecasted severe icing conditions that were characterized by high ice accretion rates and the pilot's failure to use his command authority to depart the icing conditions in an expeditious manner, which resulted in a loss of…
- [NTSB WPR12LA064](https://openairdocs.org/ntsb/WPR12LA064.md): Piper PA-22 · Friday Harbor, WA · Accident · No injuries · Limited investigation · Final report · Dec 13, 2011 · N1810P · Substantial damage
  > A total loss of engine power during initial climb 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 WPR12FA059](https://openairdocs.org/ntsb/WPR12FA059.md): Vans RV7 - A · Surprise, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 10, 2011 · N724WD · Substantial damage
  > An electrical or engine electronic problem, which resulted in a loss of engine power, followed by a low-altitude stall.
- [NTSB ERA12WA113](https://openairdocs.org/ntsb/ERA12WA113.md): Robinson R44 · Sao Bento do Sul, Brazil · Accident · 1 fatal · Foreign investigation · Dec 9, 2011 · PR-KLA · Substantial damage
  > On December 9, 2011 at 1630 universal coordinated time, a Robinson R44, Brazilian registration PR-KLA, operated by SASH Locacao de Veiculos LTDA, as a personal flight, impacted terrain in the vicinity of Fazenda Coqueiros, Sao Bento do Sul, Santa Catarina,…
- [NTSB WPR12FA058](https://openairdocs.org/ntsb/WPR12FA058.md): Piper PA-28R-200 · Coupeville, WA · Accident · 1 fatal · Field investigation · Final report · Dec 8, 2011 · N2611R · Substantial damage
  > The total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB DCA12MA020](https://openairdocs.org/ntsb/DCA12MA020.md): Eurocopter France AS350B2 · Las Vegas, NV · Accident · 5 fatal · Class 1 · Major · Final report · Dec 8, 2011 · N37SH · Destroyed
  > Sundance Helicopters’ inadequate maintenance of the helicopter, including (1) the improper reuse of a degraded self-locking nut, (2) the improper or lack of installation of a split pin, and (3) inadequate postmaintenance inspections, which resulted in the…
- [NTSB CEN12LA111](https://openairdocs.org/ntsb/CEN12LA111.md): Curtiss Wright P40M · Batavia, OH · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 2011 · N5813 · Substantial damage
  > A loss of engine power due to failure of the engine oil cooler and subsequent oil starvation to the engine.
- [NTSB ERA12WA104](https://openairdocs.org/ntsb/ERA12WA104.md): Piper PA28 · Bogota, Colombia · Accident · No injuries · Foreign investigation · Dec 6, 2011 · HK2308 · Substantial damage
  > On December 6, 2011, about 1815 Universal Coordinated Time (UTC), a Piper PA-28-236, Columbian registration HK2308, operated by Aeroclub de Colombia, incurred substantial damage to the left wing and separated the left main gear when it collided with a tree…
- [NTSB CEN12FA098](https://openairdocs.org/ntsb/CEN12FA098.md): Socata TB21 · Silverton, CO · Accident · 4 fatal · Field investigation · Final report · Dec 3, 2011 · N25153 · Substantial damage
  > The non-instrument-rated pilot’s decision to embark on a flight through forecasted instrument meteorological conditions (IMC), and his subsequent flight into IMC, which resulted in the pilot’s spatial disorientation and subsequent maneuvering of the airplane…
- [NTSB WPR12LA053](https://openairdocs.org/ntsb/WPR12LA053.md): Boeing 737-7H4 · Oakland, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 2011 · N261WN · No damage
  > The flight crew’s flight into known severe turbulence associated with mountain wave activity.

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

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

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