# 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 48 of 718 · 35,883 cases

## Cases, newest first

- [NTSB GAA19CA400](https://openairdocs.org/ntsb/GAA19CA400.md): Beech 95 · Navasota, TX · Accident · Minor injuries · Data collection · Final report · Jun 29, 2019 · N998DM · Substantial damage
  > The airplane’s impact with a bird.
- [NTSB ERA19WA207](https://openairdocs.org/ntsb/ERA19WA207.md): Piper PA 28-180 · Cabo Rojo, Dominican Republic · Accident · 4 fatal · Foreign investigation · Jun 29, 2019 · N55784 · Destroyed
- [NTSB CEN19LA199](https://openairdocs.org/ntsb/CEN19LA199.md): Zenair CH750 Stol · Paducah, KY · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 29, 2019 · N170MV · Substantial damage
  > A stuck exhaust valve that resulted in a loss of engine power and a forced landing to rough terrain.
- [NTSB CEN19LA188](https://openairdocs.org/ntsb/CEN19LA188.md): Cessna 560 · Janesville, WI · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 27, 2019 · N318RW · Minor damage
  > The passenger’s decision to unbuckle her restraints during an in-flight turbulence event, resulting in serious injury.
- [NTSB CEN19LA204](https://openairdocs.org/ntsb/CEN19LA204.md): Waco YMF-5C · Bar Harbor, ME · Accident · No injuries · Class 3 · Limited · Final report · Jun 22, 2019 · N63WC · Substantial damage
  > A total loss of engine power due to a cylinder failure for undetermined reasons.
- [NTSB DCA19CA170](https://openairdocs.org/ntsb/DCA19CA170.md): Boeing CV2 · Beeville, TX · Accident · No injuries · Data collection · Final report · Jun 21, 2019 · N243XT · Substantial damage
  > A higher than expected and accounted for crosswind which initiated a lateral deviation, and resulted in the aircraft reaching the limits of the geo-fence area triggering a contingency forced landing.
- [NTSB CEN19FA177](https://openairdocs.org/ntsb/CEN19FA177.md): Beech A36 · Elida, OH · Accident · 2 fatal · Field investigation · Final report · Jun 20, 2019 · N6150X · Destroyed
  > The noninstrument-rated pilot's decision to continue visual flight rules flight into an area of instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot not obtaining a weather…
- [NTSB ENG19RA027](https://openairdocs.org/ntsb/ENG19RA027.md): Aerospatiale AS355 · Dryden, Ontario, Canada · Accident · No injuries · Foreign investigation · Jun 19, 2019 · C-GCZS · Destroyed
  > The Transportation Safety Board of Canada (TSB) has notified the NTSB of an accident involving an Aerospatiale AS355 F2 rotorcraft that occurred on June 19, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the TSB under the provisions…
- [NTSB WPR19FA175](https://openairdocs.org/ntsb/WPR19FA175.md): Robinson R44 · Two Harbors, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 18, 2019 · N7187D · Destroyed
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB CEN19LA175](https://openairdocs.org/ntsb/CEN19LA175.md): Flightstar FC-II · Knoxville, TN · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 18, 2019 · N354AR · Destroyed
  > A total loss of engine power for reasons that could not be determined based on available evidence.
- [NTSB WPR19FA172](https://openairdocs.org/ntsb/WPR19FA172.md): Nanchang CJ6 · Porter Ranch, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 15, 2019 · N269AG · Substantial damage
  > The pilot’s continued flight into marginal visual meteorological conditions, which resulted in controlled flight into terrain.
- [NTSB CEN19FA170](https://openairdocs.org/ntsb/CEN19FA170.md): Piper PA28 · Huntsville, TX · Accident · 1 fatal · Class 2 · Field · Final report · Jun 14, 2019 · N9754J · Destroyed
  > A total loss of engine power as a result of the pilot's inadvertent placement of the fuel selector to the "off" position.
- [NTSB WPR19LA170](https://openairdocs.org/ntsb/WPR19LA170.md): James Experimental Cub · Stanley, ID · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 13, 2019 · N9WU · Substantial damage
  > Overstress failure of the right-wing spar due to an encounter with turbulence.
- [NTSB ANC19WA025](https://openairdocs.org/ntsb/ANC19WA025.md): Cirrus SR20 · Yeosu, South Korea · Accident · No injuries · Foreign investigation · Jun 13, 2019 · HL1258
  > The government of Korea has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on June 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea's investigation under the provisions of…
- [NTSB CEN19WA273](https://openairdocs.org/ntsb/CEN19WA273.md): AgustaWestland AW139 · Albarracín, Spain · Accident · No injuries · Foreign investigation · Jun 12, 2019 · EC-NEH · Substantial damage
  > On June 12, 2019, about 1330 local time, an AgustaWestland AW139 helicopter, EC-NEH, executed an emergency landing to an open field near Albarracín, Spain, for unknown reasons. The pilot and sole occupant sustained no injury, and the helicopter sustained…
- [NTSB ANC19LA027](https://openairdocs.org/ntsb/ANC19LA027.md): Helio H391 · Hope, AK · Accident · No injuries · Class 3 · Limited · Final report · Jun 12, 2019 · N10CJ · Substantial damage
  > The pilot’s failure to maintain directional control during a precautionary landing, which resulted in a ground loop. Contributing to the accident was a partial loss of engine power for reasons that could not be determined.
- [NTSB CEN19LA163](https://openairdocs.org/ntsb/CEN19LA163.md): Griff Challenger · Switz City, IN · Accident · Serious injuries · Class 3 · Limited · Final report · Jun 11, 2019 · N582L · Substantial damage
  > A total loss of engine power due to failure of a connecting rod bearing. Contributing to the engine failure was the lack of an engine overhaul within the prescribed interval.
- [NTSB WPR19LA166](https://openairdocs.org/ntsb/WPR19LA166.md): Cessna 210 · Romona, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 10, 2019 · N3997Y · Substantial damage
  > A total loss of engine power due to oil starvation as a result of the failure of an oil filter adapter fiber gasket.
- [NTSB GAA19CA338](https://openairdocs.org/ntsb/GAA19CA338.md): Pzl-Swidnik PW-5 · Independence, WI · Accident · No injuries · Data collection · Final report · Jun 10, 2019 · N962JH · Substantial damage
  > The separation of the canopy from the glider during an off-airport landing for reasons that could not be determined.
- [NTSB CEN19FA161](https://openairdocs.org/ntsb/CEN19FA161.md): Cessna 425 · Butler, MO · Accident · 1 fatal · Class 3 · Field · Final report · Jun 10, 2019 · N622MM · Destroyed
  > The pilot’s loss of airplane control during a descent to a diversion airport with only the left engine operating. Contributing to the accident was a malfunction of the right engine throttle, the cause of which could not be determined.
- [NTSB ERA19FA189](https://openairdocs.org/ntsb/ERA19FA189.md): Beech A36 · Southold, NY · Accident · 2 fatal · Class 3 · Field · Final report · Jun 8, 2019 · N8014T · Destroyed
  > A total loss of engine power due to a main bearing shift and the pilot’s subsequent failure to maintain a proper glide path to the selected forced landing site. Contributing to the accident was the pilot’s decision to operate the airplane with known…
- [NTSB WPR19LA160](https://openairdocs.org/ntsb/WPR19LA160.md): Cessna 150 · Davis City, CA · Accident · No injuries · Class 3 · Limited · Final report · Jun 7, 2019 · N6617F · Substantial damage
  > A total loss of engine power due to water contamination in the fuel, which resulted in a forced landing and collision with terrain. Contributing to the accident was the pilot's improper decision to proceed with the flight after discovering the contaminated…
- [NTSB ERA19FA188](https://openairdocs.org/ntsb/ERA19FA188.md): Piper PA46 · Castalia, NC · Accident · 4 fatal · Class 3 · Field · Final report · Jun 7, 2019 · N709CH · Destroyed
  > The pilot’s failure to navigate around hazardous weather, resulting in the penetration of a thunderstorm, a loss of airplane control, and an inflight breakup. The air traffic controller’s failure to provide the pilot with adequate and timely weather…
- [NTSB GAA19WA414](https://openairdocs.org/ntsb/GAA19WA414.md): Cessna 207 · Birtingarholt, Iceland · Incident · No injuries · Foreign investigation · Jun 6, 2019 · TF-MAJ · No damage
- [NTSB ANC19WA022](https://openairdocs.org/ntsb/ANC19WA022.md): Grumman AA-5B · Medicine Hat, Canada · Accident · 3 fatal · Foreign investigation · Jun 2, 2019 · C-GQIJ · Substantial damage
  > On June 2, 2019, at 0440 (UTC) time, a Canadian registered Grumman American Aviation, AA-5B airplane, C-GQIJ, operated by a private individual, was found after it had collided with terrain under unknown circumstances while conducting a VFR flight. A search…
- [NTSB DCA19WA156](https://openairdocs.org/ntsb/DCA19WA156.md): Boeing 787 · Japan · Incident · No injuries · Foreign investigation · Jun 1, 2019 · JA828A · No damage
  > The Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 787 airplane that occurred on June 01, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under…
- [NTSB ENG19WA026](https://openairdocs.org/ntsb/ENG19WA026.md): Airbus A330 · Chek Lap Kok, Hong Kong SAR China · Incident · No injuries · Foreign investigation · May 30, 2019 · B-18352
  > The Taiwan Aviation Safety Council (ASC) has notified the NTSB of an incident involving an Airbus A330-302 airplane which occurred on May 30, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ASC investigation under the provisions of…
- [NTSB CEN19LA159](https://openairdocs.org/ntsb/CEN19LA159.md): Lancair LC41 · Cleburne, TX · Accident · No injuries · Class 3 · Limited · Final report · May 30, 2019 · N2514F · Substantial damage
  > A total loss of engine power due to oil starvation as the result of the oil pressure switch failure due to a manufacturing defect.
- [NTSB GAA19WA334](https://openairdocs.org/ntsb/GAA19WA334.md): Piper PA12 · Gillam (Manitoba)-Canada, Canada · Accident · 2 fatal · Foreign investigation · May 29, 2019 · C-FYDN · Destroyed
  > The government of Canada has notified the NTSB of an accident involving a PIPER PA12 airplane that occurred on May 29, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of…
- [NTSB CEN19LA158](https://openairdocs.org/ntsb/CEN19LA158.md): Boeing B75N1 · Fredericksburg, TX · Accident · Serious injuries · Class 3 · Limited · Final report · May 29, 2019 · N60955 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB ERA19FA181](https://openairdocs.org/ntsb/ERA19FA181.md): Piper PA28R · Auburn Township, OH · Accident · 1 fatal · Class 3 · Field · Final report · May 28, 2019 · N3933T · Destroyed
  > The pilot's loss of control due to spatial disorientation in dark night conditions. Contributing to the accident was his inadequate weather planning, lack of experience flying at night and the deteriorating weather conditions.
- [NTSB DCA19CA153](https://openairdocs.org/ntsb/DCA19CA153.md): Airbus A320 · Fort Lauderdale, FL · Accident · Serious injuries · Class 4 · Data collection · Final report · May 28, 2019 · N507JT · No damage
  > A buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the pot locking lever was raised.
- [NTSB CEN19FA155](https://openairdocs.org/ntsb/CEN19FA155.md): Cessna R172 · Mertzon, TX · Accident · 1 fatal · Class 3 · Field · Final report · May 28, 2019 · N2583V · Destroyed
  > The pilot's loss of control due to spatial disorientation.
- [NTSB GAA19WA308](https://openairdocs.org/ntsb/GAA19WA308.md): Piper PA28 · Estancia County, Brazil · Accident · 3 fatal · Foreign investigation · May 27, 2019 · PT-KLO · Destroyed
- [NTSB CEN19LA152](https://openairdocs.org/ntsb/CEN19LA152.md): Rand Robinson KR2 · Poplar Grove, IL · Accident · Minor injuries · Class 3 · Limited · Final report · May 26, 2019 · N886MJ · Substantial damage
  > The loss of engine power due to vapor lock of the throttle body injection system.
- [NTSB DCA19CA151](https://openairdocs.org/ntsb/DCA19CA151.md): Boeing 737-8H4 · Waycross, GA · Accident · Serious injuries · Class 4 · Data collection · Final report · May 25, 2019 · N8697C · No damage
  > an encounter with convectively induced turbulence while penetrating cumulus clouds during descent.
- [NTSB CEN19LA153](https://openairdocs.org/ntsb/CEN19LA153.md): Champion 8KCAB · Fredericksburg, TX · Accident · Minor injuries · Class 3 · Limited · Final report · May 25, 2019 · N68557 · Substantial damage
  > A total loss of engine power due to fuel exhaustion.
- [NTSB WPR19FA154](https://openairdocs.org/ntsb/WPR19FA154.md): Cirrus SR22 · Grover, UT · Accident · 2 fatal · Class 2 · Field · Final report · May 24, 2019 · N809SR · Destroyed
  > The pilot's encounter with moderate to severe icing conditions during cruise flight, which resulted in structural icing and a subsequent loss of control. Contributing to the accident was the pilot’s decision to continue a flight route through known moderate…
- [NTSB ERA19LA180](https://openairdocs.org/ntsb/ERA19LA180.md): Cessna 560 · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Limited investigation · Final report · May 24, 2019 · N832R · Destroyed
  > Impact with water for reasons that could not be determined based on the available information.
- [NTSB GAA19WA273](https://openairdocs.org/ntsb/GAA19WA273.md): Cirrus SR20 · Wilhelmshaven, Germany, Germany · Accident · No injuries · Foreign investigation · May 19, 2019 · D-EXOS · Destroyed
  > The government of Germany has notified the NTSB of an accident involving a CIRRUS SR20 airplane that occurred on May 19, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Germany's investigation under the provisions of…
- [NTSB CEN19FA144](https://openairdocs.org/ntsb/CEN19FA144.md): Vans RV6 · Chillicothe, OH · Accident · 1 fatal · Class 2 · Field · Final report · May 18, 2019 · N596JB · Destroyed
  > The pilot's failure to maintain control of the airplane following an intermittent loss of engine power during cruise flight that resulted in him impacting trees. The reason for the loss of engine power could not be determined based on the available…
- [NTSB WPR19FA148](https://openairdocs.org/ntsb/WPR19FA148.md): Robinson R44 · Alpine, UT · Accident · 2 fatal · Class 3 · Field · Final report · May 17, 2019 · N744TW · Substantial damage
  > The noninstrument-rated pilot’s continued visual flight rules flight into instrument meteorological conditions, which resulted in spatial disorientation and subsequent loss of control. Contributing to the accident was hypoxia due to the high altitude at which…
- [NTSB CEN19LA147](https://openairdocs.org/ntsb/CEN19LA147.md): Cessna P210 · Yankeetown, FL · Accident · Minor injuries · Class 3 · Limited · Final report · May 17, 2019 · N4861P · Substantial damage
  > A loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB GAA19CA272](https://openairdocs.org/ntsb/GAA19CA272.md): Piper PA28 · Maitland, FL · Accident · No injuries · Data collection · Final report · May 16, 2019 · N6753W · Substantial damage
  > The pilot's improper fuel planning, which resulted in fuel exhaustion, the total loss of engine power, and subsequent impact with a car during an emergency landing on a road.
- [NTSB ERA19LA177](https://openairdocs.org/ntsb/ERA19LA177.md): Zenith CH750 · Savannah, TN · Accident · No injuries · Class 3 · Limited · Final report · May 16, 2019 · N750GZ · Substantial damage
  > The total loss of engine power due to a loss of all electrical power. Contributing to the accident was the inaccessible placement of the alternator circuit breaker and the construction of the airplane without a backup electrical source.
- [NTSB WPR19FA146](https://openairdocs.org/ntsb/WPR19FA146.md): Aviat A1 · Santa Ynez, CA · Accident · 1 fatal · Class 3 · Field · Final report · May 15, 2019 · N236AM · Destroyed
  > The pilot’s failure to maintain clearance from mountainous terrain during cruise flight in low visibility and mountainous obscuration conditions.
- [NTSB WPR19FA145](https://openairdocs.org/ntsb/WPR19FA145.md): Grumman G164 · Pleasant Grove, CA · Accident · 2 fatal · Class 3 · Field · Final report · May 15, 2019 · N6787K · 2 aircraft · Substantial damage
  > The failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.
- [NTSB CEN19LA146](https://openairdocs.org/ntsb/CEN19LA146.md): Sikorsky S76 · Morrilton, AR · Accident · No injuries · Class 3 · Limited · Final report · May 15, 2019 · N761AF · Substantial damage
  > The improper securing of the exhaust duct bolts, which resulted in the duct becoming unseated and substantial heat damage to the tail rotor drive shaft.
- [NTSB DCA19WA172](https://openairdocs.org/ntsb/DCA19WA172.md): Boeing 737 · Seoul, South Korea · Accident · Serious injuries · Foreign investigation · May 13, 2019 · HL7726 · No damage
  > The ARAIB of Korea has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on May 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the ARAIB's investigation under the provisions of ICAO Annex 13 as State…
- [NTSB DCA19WA150](https://openairdocs.org/ntsb/DCA19WA150.md): Airbus A330 · Derby, Australia · Incident · No injuries · Foreign investigation · May 13, 2019 · unknown · No damage
  > The Australian Transport Safety Bureau (ATSB) has notified the NTSB of a serious incident involving a AIRBUS A330 airplane that occurred on May 13, 2019. The NTSB has appointed a U.S. Accredited Representative to assist the government of Australia's…

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

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

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