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

## Cases, newest first

- [NTSB CEN13IA387](https://openairdocs.org/ntsb/CEN13IA387.md): Martin Charles A Zenith Stol CH 750 · Paragould, AR · Incident · No injuries · Incident investigation · Final report · Jun 28, 2013 · N699TX · Minor damage
  > The improper installation of the propeller flange, which resulted in an in-flight separation of the propeller assembly.
- [NTSB ANC13RA061](https://openairdocs.org/ntsb/ANC13RA061.md): De Havilland DHC-2 MK 1 · Half Moon Bay, Canada · Accident · No injuries · Foreign investigation · Jun 24, 2013 · C-FPCG · Substantial damage
  > On June 24, 2013, at 1544 coordinated universal time, a DeHavilland DHC-2MK 1, Canadian registered C-FPCG, owned and operated by Seair Seaplanes, was substantially damaged near Half Moon Bay, Canada. Visual meteorological conditions prevailed at the time of…
- [NTSB WPR13FA284](https://openairdocs.org/ntsb/WPR13FA284.md): Beech A45 · Boulder City, NV · Accident · 2 fatal · Field investigation · Final report · Jun 23, 2013 · N434M · Substantial damage
  > The pilot/mechanic's loss of control during an emergency descent following a loss of engine power while in cruise flight. Contributing to the accident was the pilot/mechanic's incorrect assembly of the No. 6 cylinder at the last cylinder change, which…
- [NTSB CEN13LA367](https://openairdocs.org/ntsb/CEN13LA367.md): Piper PA-28-140 · De Smet, SD · Accident · No injuries · Limited investigation · Final report · Jun 21, 2013 · N589FL · Substantial damage
  > A loss of engine power for reasons that could not be determined because postaccident examinations of the airplane and engine revealed no mechanical malfunctions or failures that would have precluded normal operation.
- [NTSB ANC13CA056](https://openairdocs.org/ntsb/ANC13CA056.md): Cub Crafters CC11-100 · Dillingham, AK · Accident · No injuries · Data collection · Final report · Jun 19, 2013 · N620Y · Substantial damage
  > A loss of engine power due to carburetor icing.
- [NTSB ERA13WA293](https://openairdocs.org/ntsb/ERA13WA293.md): Piper PA-28-161 · Barcis, Italy · Accident · 2 fatal · Foreign investigation · Jun 18, 2013 · F-GHLY · Substantial damage
  > On June 18, 2013 at 1655 Universal Coordinated Time (UTC), a Piper PA-28, French registration F-GHLY, privately operated, was substantially damaged when it impacted with the slope of a mountain near Barcis, Italy during a cross-country flight from Locarno…
- [NTSB WPR13LA275](https://openairdocs.org/ntsb/WPR13LA275.md): Piper PA-28-181 · Waihee-Waiehu, HI · Accident · No injuries · Limited investigation · Final report · Jun 17, 2013 · N9160Q · Substantial damage
  > The loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies due to saltwater immersion.
- [NTSB WPR13LA272](https://openairdocs.org/ntsb/WPR13LA272.md): Cessna 175 · Needles, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 2013 · N9370B · Substantial damage
  > A loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning. Contributing to the severity of the front passenger’s injuries was the pilot’s decision to depart with more passengers than available seats, which resulted in…
- [NTSB ERA13WA290](https://openairdocs.org/ntsb/ERA13WA290.md): Beech 58 · Albenga, Italy · Accident · 1 fatal · Foreign investigation · Jun 16, 2013 · G-CIZZ · Destroyed
- [NTSB ERA13WA289](https://openairdocs.org/ntsb/ERA13WA289.md): Bell 212 · Tefe, Brazil · Accident · 2 fatal · Foreign investigation · Jun 14, 2013 · PR-HRZ · Destroyed
  > On June 14, 2013, about 0810 universal coordinated time, a Bell 212 helicopter, Brazilian registration PR-HRZ, operated by an oil and gas exploration and production company, was destroyed when it impacted terrain shortly after takeoff from a support base…
- [NTSB CEN13LA339](https://openairdocs.org/ntsb/CEN13LA339.md): Youngs William D T211 · Festus, MO · Accident · Serious injuries · Limited investigation · Final report · Jun 11, 2013 · N211BY · Substantial damage
  > Fuel exhaustion due to the pilot’s inadequate preflight fuel planning, which resulted in a total loss of engine power.
- [NTSB CEN13FA338](https://openairdocs.org/ntsb/CEN13FA338.md): Pipistrel Alpha Trainer · Pampa, TX · Accident · 1 fatal · Field investigation · Final report · Jun 11, 2013 · N477PA · Substantial damage
  > The loss of engine power due to fuel exhaustion as a result of the manufacturer providing the incorrect Pilot’s Operating Handbook to the owner, which prevented the pilot from accurately calculating the fuel requirements before the flight. Contributing to the…
- [NTSB ERA13FA275](https://openairdocs.org/ntsb/ERA13FA275.md): Cessna 340A · Boynton Beach, FL · Accident · 1 fatal · Field investigation · Final report · Jun 8, 2013 · N217JP · Destroyed
  > The pilot’s loss of situational awareness, which resulted in an inadvertent aerodynamic stall/spin after he climbed the airplane back into instrument meteorological conditions (IMC). Contributing to the accident was the pilot’s improper decision to continue…
- [NTSB CEN13FA327](https://openairdocs.org/ntsb/CEN13FA327.md): Piper PA-28-140 · Mosca, CO · Accident · 2 fatal · Field investigation · Final report · Jun 8, 2013 · N7147R · Substantial damage
  > The pilot's failure to maintain airplane control while attempting to clear a mountain pass in turbulent conditions at a high density altitude, which resulted in the airplane exceeding its critical angle-of-attack and experiencing an aerodynamic stall.
- [NTSB CEN13FA326](https://openairdocs.org/ntsb/CEN13FA326.md): Hawker Beechcraft B200GT · Baker, LA · Accident · 1 fatal · Field investigation · Final report · Jun 7, 2013 · N510LD · Destroyed
  > The pilot’s failure to maintain adequate airspeed during departure, which resulted in an aerodynamic stall and subsequent impact with terrain. Contributing to the accident was the pilot’s lack of specific knowledge of the airplane’s avionics.
- [NTSB WPR13FA264](https://openairdocs.org/ntsb/WPR13FA264.md): Robinson Helicopter R44 II · Los Angeles, CA · Accident · Minor injuries · Field investigation · Final report · Jun 6, 2013 · N915BW · Substantial damage
  > The pilot’s loss of helicopter control following a precautionary landing, which resulted in a dynamic rollover.
- [NTSB ANC13FA054](https://openairdocs.org/ntsb/ANC13FA054.md): Dehavilland Beaver DHC-2 MK.1 · Petersburg, AK · Accident · 1 fatal · Field investigation · Final report · Jun 4, 2013 · N616W · Substantial damage
  > The pilot’s failure to maintain adequate altitude above the trees, and his subsequent failure to maintain adequate airspeed while maneuvering to avoid the trees, which resulted in an inadvertent aerodynamic stall/spin and an uncontrolled descent.
- [NTSB ERA13LA268](https://openairdocs.org/ntsb/ERA13LA268.md): Maule M-4-220C · Fredericksburg, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 1, 2013 · N40337 · Substantial damage
  > A total loss of engine power due to the fatigue failure of the No. 4 cylinder piston pin.
- [NTSB CEN13LA330](https://openairdocs.org/ntsb/CEN13LA330.md): Cessna TP206B · Sturgeon Bay, WI · Accident · No injuries · Limited investigation · Final report · Jun 1, 2013 · N3350J · Substantial damage
  > The pilot’s improper reselection of the left fuel tank, which had an obstructed vent system and resulted in a total loss of engine power during the approach for landing.
- [NTSB WPR13CA252](https://openairdocs.org/ntsb/WPR13CA252.md): Cessna 172A · Eatonville, WA · Accident · Minor injuries · Data collection · Final report · May 31, 2013 · N7701T · Substantial damage
  > A partial loss of engine power due to carburetor icing and the pilot's failure to maintain adequate airspeed during a go-around, which resulted in a stall.
- [NTSB ERA13TA261](https://openairdocs.org/ntsb/ERA13TA261.md): Bell 407 · Columbia, MD · Accident · No injuries · Final report · May 31, 2013 · N407HC · Substantial damage
  > The short circuit failure of a tantalum capacitor, internal to the engine’s electronic control unit, resulting in an uncommanded shutdown of the engine in flight.
- [NTSB ERA13LA258](https://openairdocs.org/ntsb/ERA13LA258.md): Cessna 177B · Herndon, VA · Accident · Minor injuries · Limited investigation · Final report · May 31, 2013 · N177FG · Substantial damage
  > The pilot’s inadequate preflight planning, which resulted in fuel exhaustion and a subsequent total loss of engine power.
- [NTSB ERA13LA262](https://openairdocs.org/ntsb/ERA13LA262.md): Cessna 182P · Brevard, NC · Accident · Minor injuries · Limited investigation · Final report · May 30, 2013 · N6525M · Substantial damage
  > The cylinder manufacturer's misalignment of the exhaust valve guides in the No. 2 cylinder during manufacture, which resulted in the exhaust valve sticking and the pushrod breaking and the subsequent total loss of engine power.
- [NTSB ERA13CA260](https://openairdocs.org/ntsb/ERA13CA260.md): Piper PA-28-140 · Ellenville, NY · Accident · Minor injuries · Data collection · Final report · May 30, 2013 · N5715F · Substantial damage
  > The student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain.
- [NTSB CEN13WA405](https://openairdocs.org/ntsb/CEN13WA405.md): Piper PA-32R-301T · Lagunillas, Mexico · Accident · 1 fatal · Foreign investigation · May 30, 2013 · N371HP · Substantial damage
- [NTSB CEN13WA307](https://openairdocs.org/ntsb/CEN13WA307.md): Piper PA-28RT-201T · Tallard, France · Accident · 1 fatal · Foreign investigation · May 29, 2013 · N68XM · Destroyed
- [NTSB WPR13CA245](https://openairdocs.org/ntsb/WPR13CA245.md): Piper PA-31-350 · Page, AZ · Accident · No injuries · Data collection · Final report · May 28, 2013 · N969BD · Substantial damage
  > A loss of engine power during cruise flight due to fuel exhaustion. Contributing to the accident was the pilot's improper fuel planning.
- [NTSB WPR13FA243](https://openairdocs.org/ntsb/WPR13FA243.md): Hiller UH-12E · Wenatchee, WA · Accident · Minor injuries · Field investigation · Final report · May 26, 2013 · N99090 · Substantial damage
  > Fatigue failure of the six bolts that secured the bevel gear to the first stage planetary carrier, which caused the transmission to seize while the helicopter and main rotor were still operating.
- [NTSB ERA13FA253](https://openairdocs.org/ntsb/ERA13FA253.md): Piper PA-34-200T · Johnstown, NY · Accident · 3 fatal · Field investigation · Final report · May 24, 2013 · N31743 · Destroyed
  > The pilot's loss of control due to spatial disorientation in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup.
- [NTSB CEN13LA305](https://openairdocs.org/ntsb/CEN13LA305.md): Stinson 108-3 · Beaumont, TX · Accident · Minor injuries · Limited investigation · Final report · May 23, 2013 · N121CM · Substantial damage
  > The lack of a forward clamp on the carburetor heat box rubber boot, which allowed the boot to be ingested into the inlet of the carburetor heat box, restricting the airflow and leading to a subsequent partial loss of engine power.
- [NTSB CEN13LA298](https://openairdocs.org/ntsb/CEN13LA298.md): Allen Jan A Challenger II · Greeley, CO · Accident · No injuries · Limited investigation · Final report · May 22, 2013 · N269MM · Substantial damage
  > The loss of engine power due to the engine seizure, which resulted from damage caused by the ingestion of carburetor ice into the engine intake ports.
- [NTSB CEN13LA287](https://openairdocs.org/ntsb/CEN13LA287.md): Piper PA-28-161 · Oskaloosa, IA · Accident · Minor injuries · Limited investigation · Final report · May 18, 2013 · N47539 · Substantial damage
  > The loss of engine power for reasons that could not be determined because the engine examination did not reveal any malfunctions or failures that would have precluded normal operation.
- [NTSB ERA13CA247](https://openairdocs.org/ntsb/ERA13CA247.md): Cessna 182D · East Moriches, NY · Accident · No injuries · Data collection · Final report · May 17, 2013 · N8775X · Substantial damage
  > The inadvertent deployment of the skydiving instructor's drogue chute when he exited the airplane, resulting in it contacting and damaging the horizontal stabilizer.
- [NTSB WPR13FA234](https://openairdocs.org/ntsb/WPR13FA234.md): Cessna 421C · Floriston, CA · Accident · 1 fatal · Field investigation · Final report · May 16, 2013 · N421W · Destroyed
  > The pilot's failure to maintain airplane control during descent while operating in instrument meteorological conditions.
- [NTSB WPR13CA231](https://openairdocs.org/ntsb/WPR13CA231.md): Cessna 182P · Carson City, NV · Accident · No injuries · Data collection · Final report · May 15, 2013 · N911HE · Substantial damage
  > The pilot's failure to maintain aircraft control after an encounter with downdrafts while flying over mountainous terrain.
- [NTSB CEN13LA280](https://openairdocs.org/ntsb/CEN13LA280.md): Piper PA-36-285 · Galena, KS · Accident · Minor injuries · Limited investigation · Final report · May 14, 2013 · N57719 · Substantial damage
  > The loss of engine power due to improper maintenance by an unknown individual that led to the degradation and deterioration of the No. 2 piston, which was undetected because of overdue maintenance.
- [NTSB ERA13LA241](https://openairdocs.org/ntsb/ERA13LA241.md): Cessna 182E · Southwick, MA · Accident · No injuries · Limited investigation · Final report · May 13, 2013 · N817JT · Substantial damage
  > The partial loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any malfunctions or failures that would have precluded normal operation.
- [NTSB ERA13CA272](https://openairdocs.org/ntsb/ERA13CA272.md): Pdps Pzl-Bielsko SZD-55-1 · Henderson, NC · Accident · No injuries · Data collection · Final report · May 12, 2013 · N81799 · Substantial damage
  > A loss of aerodynamic lift that resulted in a forced landing to unsuitable terrain.
- [NTSB ERA13CA240](https://openairdocs.org/ntsb/ERA13CA240.md): Piper PA-44-180T · Loxahatchee, FL · Accident · No injuries · Data collection · Final report · May 11, 2013 · N8390K · Substantial damage
  > An in-flight collision with a bird.
- [NTSB ERA13LA239](https://openairdocs.org/ntsb/ERA13LA239.md): Cessna 182G · Clewiston, FL · Accident · No injuries · Limited investigation · Final report · May 9, 2013 · N2440R · Substantial damage
  > The private pilot’s inadequate preflight planning and fuel management and the flight instructor’s inadequate supervision, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB CEN13LA283](https://openairdocs.org/ntsb/CEN13LA283.md): Air Tractor AT-302 · Winnie, TX · Accident · No injuries · Limited investigation · Final report · May 9, 2013 · N3650B · Substantial damage
  > The improper decision by the pilot to attempt a flight with a known fuel system-related maintenance discrepancy, which resulted in a fuel imbalance and subsequent fuel starvation during an approach to an alternate airport with a rough field. Contributing to…
- [NTSB ANC13CA044](https://openairdocs.org/ntsb/ANC13CA044.md): Piper PA-18-150 · Palmer, AK · Accident · No injuries · Data collection · Final report · May 7, 2013 · N8899Y · Substantial damage
  > The pilot's failure to use continuous carburetor heat while operating in conditions conducive to carburetor icing, which resulted in the development of carburetor ice and a subsequent partial loss of engine power.
- [NTSB WPR13LA216](https://openairdocs.org/ntsb/WPR13LA216.md): Rans S-17 · Fontana, CA · Accident · Minor injuries · Limited investigation · Final report · May 4, 2013 · N6171R · Substantial damage
  > A loss of engine power due to improper construction and inadequate maintenance of the fuel system and engine. Contributing to the accident was the airplane’s inadvertent contact with an unseen guy wire during the landing flare.
- [NTSB CEN13LA258](https://openairdocs.org/ntsb/CEN13LA258.md): Cessna 182T · Delta, CO · Accident · No injuries · Limited investigation · Final report · May 2, 2013 · N2012Y · Substantial damage
  > The loss of propeller control for reasons that could not be determined because postaccident examinations revealed no anomalies that would have precluded normal operation and the airplane’s subsequent collision with power lines during the forced landing.
- [NTSB CEN13CA250](https://openairdocs.org/ntsb/CEN13CA250.md): Beech A36 · Ingalls, IN · Accident · No injuries · Data collection · Final report · May 1, 2013 · N1568Y · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation.
- [NTSB WPR13LA224](https://openairdocs.org/ntsb/WPR13LA224.md): Cessna 172M · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Apr 29, 2013 · N20800 · Substantial damage
  > Loss of engine power during climb due to a failure of the No. 2 piston assembly; the reason for the failure could not be determined because of the extent of damage to the piston assembly.
- [NTSB WPR13FA211](https://openairdocs.org/ntsb/WPR13FA211.md): Cessna 172RG · Calabasas, CA · Accident · 2 fatal · Class 3 · Field · Final report · Apr 29, 2013 · N4677V · 2 aircraft · Substantial damage
  > The failure of the pilots in both aircraft to maintain an adequate visual lookout, which resulted in a midair collision.
- [NTSB ERA13LA221](https://openairdocs.org/ntsb/ERA13LA221.md): Aeronca 11AC · Hoosick Falls, NY · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 2013 · N3503E · Substantial damage
  > The failure of the left wing attachment bracket weld due to inadequate welding by unknown maintenance personnel.
- [NTSB ERA13FA217](https://openairdocs.org/ntsb/ERA13FA217.md): Cessna 172N · Dade City, FL · Accident · Minor injuries · Field investigation · Final report · Apr 27, 2013 · N5944J · Substantial damage
  > The in-flight loosening of the No. 3 cylinder exhaust valve rocker arm stud, which resulted in a complete loss of engine power.
- [NTSB CEN13LA245](https://openairdocs.org/ntsb/CEN13LA245.md): Raytheon G36 · Hoxie, KS · Accident · No injuries · Limited investigation · Final report · Apr 26, 2013 · N222GL · Substantial damage
  > The loss of engine power due to fuel starvation 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.

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

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

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