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

## Cases, newest first

- [NTSB CEN14CA515](https://openairdocs.org/ntsb/CEN14CA515.md): Cessna 150J · Brookfield, WI · Accident · Minor injuries · Data collection · Final report · Sep 22, 2014 · N50889 · Substantial damage
  > The pilot's inadequate maintenance and preflight of the airplane which resulted in a total loss of engine power due to oil starvation.
- [NTSB ANC14LA085](https://openairdocs.org/ntsb/ANC14LA085.md): Cessna TU206 · Deadhorse, AK · Accident · No injuries · Limited investigation · Final report · Sep 22, 2014 · N206J · Substantial damage
  > The application of insufficient torque to the engine cylinder through bolts during the replacement of the No. 1 cylinder, which resulted in the displacement of the No. 2 bearing, oil starvation, and a catastrophic engine failure.
- [NTSB ERA14LA451](https://openairdocs.org/ntsb/ERA14LA451.md): Grumman American Avn. AA-5A · Homosassa, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 2014 · N26676 · Substantial damage
  > A partial loss of engine power for reasons that could not be determined because engine examination did not reveal any anomalies that would have precluded normal operation.
- [NTSB DCA14WA163](https://openairdocs.org/ntsb/DCA14WA163.md): Boeing Boeing 737-8AS · Stanstead, United Kingdom · Incident · No injuries · Foreign investigation · Sep 18, 2014 · EI-EFB · No damage
  > The Air Accidents Investigation Branch of the United Kingdom has notified the NTSB of an accident involving a Boeing 737-8AS airplane that occurred on September 18, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's…
- [NTSB CEN14LA504](https://openairdocs.org/ntsb/CEN14LA504.md): Saccio Thomas A Seawind 3000 · Bloomington, IN · Accident · 2 fatal · Limited investigation · Final report · Sep 18, 2014 · N516SW · Destroyed
  > An in-flight fire for reasons that could not be determined because the examination of the airplane did not reveal the source of the fire.
- [NTSB WPR14LA377](https://openairdocs.org/ntsb/WPR14LA377.md): Piper PA 28 · Lone Pine, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 15, 2014 · N5948W · Substantial damage
  > The fatigue failure of a propeller blade due to a propeller strike by/of an unidentified object at an unknown time.
- [NTSB WPR14LA374](https://openairdocs.org/ntsb/WPR14LA374.md): Bell 206 · Tombstone, AZ · Accident · No injuries · Limited investigation · Final report · Sep 12, 2014 · N64AW · Substantial damage
  > A partial loss of engine power during cruise flight due to loose “B” nut fittings and a bent tube as a result of maintenance personnel’s inadequate inspection of the nuts during the most recent inspection.
- [NTSB ERA14CA426](https://openairdocs.org/ntsb/ERA14CA426.md): Schleicher ASW 19B · Avoca, NY · Accident · Serious injuries · Data collection · Final report · Sep 7, 2014 · N31GF · Substantial damage
  > The pilot's decision to attempt a return to his departure airport which resulted in the glider's encounter with atmospheric conditions where the lift was not sufficient to maintain flight and an off-airport landing.
- [NTSB CEN14LA486](https://openairdocs.org/ntsb/CEN14LA486.md): Cirrus Design SR22 · Langola Township, MN · Accident · No injuries · Limited investigation · Final report · Sep 7, 2014 · N22WX · Substantial damage
  > Maintenance personnel’s failure to apply sufficient torque on the throttle control lever nut, which resulted in a loss of throttle control and subsequent loss of engine power.
- [NTSB WPR14LA367](https://openairdocs.org/ntsb/WPR14LA367.md): Piper PA 25-235 · Warner Springs, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2014 · N7117Z · Substantial damage
  > The glider pilot's failure to maintain directional control during the initial climb while being towed, which led to the tow plane's unstable flight and its subsequent aerodynamic stall. Contributing to the accident was the tow pilot's delayed release of the…
- [NTSB ERA14LA425](https://openairdocs.org/ntsb/ERA14LA425.md): Navion Navion · Rock Hill, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 2014 · N4900K · Substantial damage
  > The pilot’s improper fuel management, which resulted in the exhaustion of the fuel supply in the selected fuel tank and a subsequent total loss of engine power.
- [NTSB ERA14LA424](https://openairdocs.org/ntsb/ERA14LA424.md): Socata TBM 700 · Caribbean Sea, A1 · Accident · 2 fatal · Limited investigation · Final report · Sep 5, 2014 · N900KN · Destroyed
  > The design of the cabin pressurization system, which made it prone to unnecessary shutdown, combined with a checklist design that prioritized troubleshooting over ensuring that the pilot was sufficiently protected from hypoxia. This resulted in a loss of…
- [NTSB DCA14WA160](https://openairdocs.org/ntsb/DCA14WA160.md): Embraer EMB 145LR · London, Canada · Incident · No injuries · Foreign investigation · Sep 5, 2014 · N16954 · Minor damage
  > The TSB of Canada has notified the NTSB of an accident involving a Embraer EMB145LR airplane that occurred on September 05, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the TSB-Canada's investigation under the provisions of ICAO…
- [NTSB ERA14FA421](https://openairdocs.org/ntsb/ERA14FA421.md): Klaas Development Lancair IV P · Ooltewah, TN · Accident · 1 fatal · Field investigation · Final report · Sep 3, 2014 · N541EM · Substantial damage
  > The inadequate torque of the propeller mounting bolts and inspection of the propeller, which resulted in the fatigue fracture of the bolts and a subsequent in-flight separation of the propeller assembly.
- [NTSB WPR14CA363](https://openairdocs.org/ntsb/WPR14CA363.md): Hughes 369D · Willows, CA · Accident · Serious injuries · Data collection · Final report · Sep 2, 2014 · N516PJ · Substantial damage
  > The pilot's failure to adequately secure cargo (a jacket), which resulted in the jacket exiting the cabin compartment and colliding with the tail rotor during cruise flight.
- [NTSB DCA14WA181](https://openairdocs.org/ntsb/DCA14WA181.md): Agusta AW109 · La Mojonera, Mexico · Accident · 2 fatal · Foreign investigation · Sep 2, 2014 · XC-ALM · Destroyed
  > The government of Mexico has notified the NTSB of an accident involving a AgustaWestland AW109 helicopter that occurred on September 02, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the…
- [NTSB CEN14WA478](https://openairdocs.org/ntsb/CEN14WA478.md): Cessna A185F · Baie-Comeau, Canada · Accident · 1 fatal · Foreign investigation · Sep 2, 2014 · N4446C · Substantial damage
- [NTSB DCA14WA159](https://openairdocs.org/ntsb/DCA14WA159.md): Fokker F27 - 50 · Mugumu, Tanzania · Accident · No injuries · Foreign investigation · Sep 1, 2014 · 5Y-SXP · Destroyed
- [NTSB ERA14LA415](https://openairdocs.org/ntsb/ERA14LA415.md): Cirrus SR22 · Wallops Island, VA · Accident · 1 fatal · Limited investigation · Final report · Aug 30, 2014 · N930RH · Substantial damage
  > The pilot’s impairment and subsequent incapacitation for reasons that could not be determined because the pilot and airplane were not recovered.
- [NTSB ERA14LA411](https://openairdocs.org/ntsb/ERA14LA411.md): Cessna 150L · Creedmoor, NC · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 2014 · N1741Q · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s impairment due to alcohol ingestion.
- [NTSB DCA14CA155](https://openairdocs.org/ntsb/DCA14CA155.md): Embraer-Empresa Brasileira De ERJ 170 200 LR · Columbus, OH · Accident · Serious injuries · Data collection · Final report · Aug 27, 2014 · N204JQ · No damage
  > the capabilities of the beverage cart were exceeded which resulted in the cart toppling over and fracturing the flight attendant's foot.
- [NTSB ERA14LA405](https://openairdocs.org/ntsb/ERA14LA405.md): Hiller UH 12E · Cape May Court House, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 2014 · N4035A · Substantial damage
  > The mechanic’s failure to detect excessive wear on the engine’s lateral snubber vibration mount during the latest annual inspection, which resulted in an in-flight engine failure and a subsequent forced landing.
- [NTSB ERA14FA403](https://openairdocs.org/ntsb/ERA14FA403.md): Beech S35 · Laurel Hill, FL · Accident · 1 fatal · Field investigation · Final report · Aug 23, 2014 · N334DF · Destroyed
  > A total loss of engine power due to detonation/preignition damage of the No. 6 cylinder. Contributing to the accident was the pilot’s decision to continue flight after receiving an indication of an impending engine failure.
- [NTSB ERA14CA419](https://openairdocs.org/ntsb/ERA14CA419.md): Dehavilland DHC 6 Twin Otter · Pepperell, MA · Accident · No injuries · Data collection · Final report · Aug 23, 2014 · N202EH · Substantial damage
  > An inadvertent collision with a bird, which resulted in substantial damage to the left wing.
- [NTSB CEN14CA455](https://openairdocs.org/ntsb/CEN14CA455.md): Embraer S A ERJ170-200LR · Hemphill, TX · Accident · Serious injuries · Data collection · Final report · Aug 22, 2014 · N421YX · No damage
  > The airplane's inadvertent encounter with wake turbulence during cruise flight, which resulted in a serious injury to a flight attendant.
- [NTSB ERA14LA402](https://openairdocs.org/ntsb/ERA14LA402.md): Thibault Michael L RV4 · Polk Township, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 2014 · N62632 · Substantial damage
  > A total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.
- [NTSB DCA15WA014](https://openairdocs.org/ntsb/DCA15WA014.md): Boeing 737 · Hat Yai, Thailand · Incident · No injuries · Foreign investigation · Aug 20, 2014 · HS-LTL · No damage
  > The Department of Civil Aviation of Thailand has notified the NTSB of an accident involving a Boeing 737 that occurred on August 05, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the DCA's investigation under the provisions of ICAO…
- [NTSB CEN14CA479](https://openairdocs.org/ntsb/CEN14CA479.md): Quicksilver 2S · Frontenac, MN · Accident · No injuries · Data collection · Final report · Aug 20, 2014 · UNREG · Substantial damage
  > The loss of engine power during cruise due to fuel exhaustion resulting in a forced landing on a cornfield.
- [NTSB WPR14FA349](https://openairdocs.org/ntsb/WPR14FA349.md): Beech V35B · Novato, CA · Accident · 1 fatal · Field investigation · Final report · Aug 19, 2014 · N1160T · Substantial damage
  > The instrument-rated pilot's decision to conduct a visual approach to the airport in night, instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the accident was the pilot's loss of situational awareness, the…
- [NTSB DCA14CA157](https://openairdocs.org/ntsb/DCA14CA157.md): Boeing 767 322 · Reykjavik, Iceland · Accident · Serious injuries · Data collection · Final report · Aug 18, 2014 · N666UA · No damage
  > The capabilities of the beverage cart were exceeded which resulted in the cart toppling over and fracturing the flight attendant's foot.
- [NTSB ERA14LA390](https://openairdocs.org/ntsb/ERA14LA390.md): Cessna R182 · Farmingdale, NY · Accident · No injuries · Limited investigation · Final report · Aug 17, 2014 · N292LC · Substantial damage
  > The failure of the aluminum nipple fuel supply line fitting, which resulted in an engine compartment fire.
- [NTSB OPS14IA011](https://openairdocs.org/ntsb/OPS14IA011.md): Boeing 777 - 236 · Shemya, AK · Incident · No injuries · Incident investigation · Final report · Aug 16, 2014 · N773AN · No damage
  > The air traffic controller’s failure to identify a conflict between two aircraft and to issue an adequate clearance, which resulted in a loss of required separation. Contributing to the incident was the Federal Aviation Administration’s failure to provide…
- [NTSB ERA14LA389](https://openairdocs.org/ntsb/ERA14LA389.md): Cessna T206H · Wiggins, MS · Accident · Minor injuries · Limited investigation · Final report · Aug 14, 2014 · N1229M · Substantial damage
  > A loosening of the engine throttle cable from its support clamp during flight, which resulted in a loss of throttle control.
- [NTSB WPR14LA345](https://openairdocs.org/ntsb/WPR14LA345.md): Piper PA 28-236 · Salmon, ID · Accident · Minor injuries · Limited investigation · Final report · Aug 13, 2014 · N2190H · Substantial damage
  > Maintenance personnel’s improper surface preparation of the accessory mount pad for the installation of the engine’s dry vacuum pump, which resulted in the loss of engine oil, oil pressure, and engine power during flight. Contributing to the accident was the…
- [NTSB CEN14WA538](https://openairdocs.org/ntsb/CEN14WA538.md): Piper PA12 · Reykjavik, Iceland · Incident · No injuries · Foreign investigation · Aug 12, 2014 · TF-ROD · Minor damage
- [NTSB WPR14LA340](https://openairdocs.org/ntsb/WPR14LA340.md): Hughes 269C · Darrington, WA · Accident · No injuries · Limited investigation · Final report · Aug 11, 2014 · N7432F · Substantial damage
  > Maintenance personnel’s failure to secure the throttle mount bracket during a recent engine installation, which resulted in the loss of throttle movement and an inability to control engine power.
- [NTSB CEN14LA419](https://openairdocs.org/ntsb/CEN14LA419.md): Evolution Trikes Revo · South Haven, MI · Accident · 1 fatal · Limited investigation · Final report · Aug 11, 2014 · N214EV · Substantial damage
  > The noninstrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in his loss of aircraft control and the resultant overstress and in-flight breakup of the weight-shift-control aircraft.
- [NTSB ERA14LA382](https://openairdocs.org/ntsb/ERA14LA382.md): Jackson Jeremiah D Vans RV6A · West Palm Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 2014 · N214MJ · Substantial damage
  > The pilot’s excessive landing speed, which resulted in a runway excursion and noseover. Contributing to the accident was a partial loss of engine power during an attempted go-around for reasons that could not be determined because no anomalies were identified…
- [NTSB ERA14LA378](https://openairdocs.org/ntsb/ERA14LA378.md): Birchler Boyd Eagle 540 · Standish, ME · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 2014 · N34BJ · Substantial damage
  > The total loss of engine power due to fuel starvation for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.
- [NTSB CEN14CA482](https://openairdocs.org/ntsb/CEN14CA482.md): Beech 95 B55 (T42A) · Bremond, TX · Accident · No injuries · Data collection · Final report · Aug 10, 2014 · N5812K · Substantial damage
  > Mismanagement of fuel, which resulted in a total loss of power due to fuel starvation.
- [NTSB CEN14LA424](https://openairdocs.org/ntsb/CEN14LA424.md): Barger Steve M RV-7A · Russell, IA · Accident · 2 fatal · Limited investigation · Final report · Aug 9, 2014 · N92BF · Destroyed
  > The noninstrument-rated pilot’s inadvertent entry into instrument meteorological conditions, which resulted in his spatial disorientation and the subsequent loss of airplane control.
- [NTSB CEN14FA414](https://openairdocs.org/ntsb/CEN14FA414.md): Piper PA 28R-201 · Steamboat Springs, CO · Accident · 2 fatal · Field investigation · Final report · Aug 9, 2014 · N3509M · Substantial damage
  > The pilot’s inability to maintain a climb while attempting to cross over a mountain pass in high-density altitude conditions that degraded the airplane’s climb performance. Contributing to the accident was the pilot’s decision to attempt the flight in…
- [NTSB CEN14WA416](https://openairdocs.org/ntsb/CEN14WA416.md): Cessna 182P · Lake of the Woods, Canada · Accident · 3 fatal · Foreign investigation · Aug 8, 2014 · N1292S · Destroyed
- [NTSB CEN14TA421](https://openairdocs.org/ntsb/CEN14TA421.md): Piper PA 28-180 · Sulphur, LA · Accident · Minor injuries · Final report · Aug 8, 2014 · N4286T · Substantial damage
  > The pilot’s failure to properly manage the airplane’s fuel supply, which led to fuel starvation and a total loss of engine power.
- [NTSB CEN14WA407](https://openairdocs.org/ntsb/CEN14WA407.md): Socata TBM 700 · Saint Jean les Deux Jumeaux, France · Accident · 2 fatal · Foreign investigation · Aug 6, 2014 · N129AG · Destroyed
- [NTSB WPR14LA329](https://openairdocs.org/ntsb/WPR14LA329.md): Christen Industries Pitts S 2B · Oceanside, CA · Accident · No injuries · Limited investigation · Final report · Aug 5, 2014 · N88EW · Substantial damage
  > The total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s inadequate fuel planning.
- [NTSB WPR14LA327](https://openairdocs.org/ntsb/WPR14LA327.md): David L Thompson Challenger II · Winterhaven, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 2014 · N518DT · Substantial damage
  > A total loss of engine power during cruise for reasons that could not be determined based on the available information. Contributing to the accident was the pilot’s loss of control during the forced landing.
- [NTSB CEN14FA400](https://openairdocs.org/ntsb/CEN14FA400.md): Larry Ketterling FEW P-51 Mustang · Lisbon, ND · Accident · 1 fatal · Field investigation · Final report · Aug 1, 2014 · N116LK · Destroyed
  > The partial loss of engine power for a reason that could not be determined because of extensive impact and postcrash fire damage, and the pilot's failure to maintain adequate airspeed, which resulted in the airplane's wing exceeding its critical…
- [NTSB ERA14LA369](https://openairdocs.org/ntsb/ERA14LA369.md): Piper PA-32-300 · Helena, AL · Accident · Serious injuries · Limited investigation · Final report · Jul 31, 2014 · N9103K · Destroyed
  > A total loss of engine power for reasons that could not be determined due to postcrash fire damage.
- [NTSB CEN14CA429](https://openairdocs.org/ntsb/CEN14CA429.md): Air Tractor AT 502B · Minden, NE · Accident · No injuries · Data collection · Final report · Jul 29, 2014 · N502NR · Substantial damage
  > The pilot's inadequate survey of the aerial application field which resulted in a collision with a windmill.

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

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

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