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

## Cases, newest first

- [NTSB FTW97FA014](https://openairdocs.org/ntsb/FTW97FA014.md): Mbb BO-105 CBS-4 · Cameron, LA · Accident · 1 fatal · Field investigation · Final report · Oct 10, 1996 · N299EH · Destroyed
  > the pilot's failure to maintain clearance with terrain for undetermined reasons. Contributing factors were the dark night and pilot fatigue.
- [NTSB FTW97LA013](https://openairdocs.org/ntsb/FTW97LA013.md): Dickson RV-3A · Rosharon, TX · Accident · No injuries · Limited investigation · Final report · Oct 9, 1996 · N3920P · Destroyed
  > The pilot's failure to follow procedures and directives in that he did not use carburetor heat and he did not periodically clear the engine during an extended glide. Factors were the carburetor icing weather conditions and the transmission wire.
- [NTSB CHI97LA006](https://openairdocs.org/ntsb/CHI97LA006.md): Callair B1A · Nebraska City, NE · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1996 · N6203X · Substantial damage
  > a supercharger bearing failure. A factor was the excessive sink rate during the forced landing.
- [NTSB SEA97FA006](https://openairdocs.org/ntsb/SEA97FA006.md): Piper PA-34-200T · Cle Elum, WA · Accident · 1 fatal · Field investigation · Final report · Oct 8, 1996 · N666HL · Substantial damage
  > The pilot's physical impairment of judgment and performance, his decision to fly while impaired, and his subsequent failure to maintain control of the aircraft which led to the aircraft's design stress limits being exceeded and inflight separation of the…
- [NTSB NYC97FA004](https://openairdocs.org/ntsb/NYC97FA004.md): Beech F33A · Doylesburg, PA · Accident · 2 fatal · Field investigation · Final report · Oct 8, 1996 · N2154L · Destroyed
  > continued VFR flight by the pilot into instrument meteorological conditions, and his failure to maintain altitude and/or clearance from high terrain. Factors relating to the accident were: darkness, low ceiling, fog, and high (mountainous) terrain along the…
- [NTSB LAX97LA011](https://openairdocs.org/ntsb/LAX97LA011.md): Richards Lancair IVP · Camarillo, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 1996 · N477RM · Destroyed
  > The loss of engine power for undetermined reasons.
- [NTSB LAX97LA007](https://openairdocs.org/ntsb/LAX97LA007.md): Cessna 172C · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Oct 7, 1996 · N1332Y · Substantial damage
  > the pilot's improper use (positioning) of the fuel selector, which resulted in fuel starvation and loss of engine power.
- [NTSB LAX97LA006](https://openairdocs.org/ntsb/LAX97LA006.md): Bell 47G-5A · King City, CA · Accident · No injuries · Limited investigation · Final report · Oct 7, 1996 · N8135J · Substantial damage
  > the pilot's failure to maintain adequate rotor rpm during the takeoff initial climb.
- [NTSB FTW97LA010](https://openairdocs.org/ntsb/FTW97LA010.md): Cessna 152 · Gulf Of Mexico · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 1996 · N5525L · Substantial damage
  > fuel exhaustion due to the pilot's inadequate in-flight fuel consumption calculations.
- [NTSB FTW97LA006](https://openairdocs.org/ntsb/FTW97LA006.md): Cessna 175B · Mount Pleasant, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 1996 · N8171T · Substantial damage
  > The total loss of engine power due to the #3 connecting rod separation resulting in engine seizure. Factors were the dark night and the lack of suitable terrain for the forced landing.
- [NTSB SEA97LA004](https://openairdocs.org/ntsb/SEA97LA004.md): Crouch Avid Mark IV · Stanwood, WA · Accident · No injuries · Limited investigation · Final report · Oct 6, 1996 · N518DC · Substantial damage
  > failure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of engine power. A factor relating to the accident was: the pilot's failure to attain the proper touchdown point on suitable terrain during the…
- [NTSB IAD97LA002](https://openairdocs.org/ntsb/IAD97LA002.md): Cessna 150H · Sunbury, PA · Accident · No injuries · Limited investigation · Final report · Oct 5, 1996 · N6741S · Substantial damage
  > failure of the cluster gear attaching bolts (of which one failed from fatigue), resulting in a disconnect of the gear and loss of engine power. An obstruction (rock) in the emergency landing area was a related factor.
- [NTSB FTW97LA007](https://openairdocs.org/ntsb/FTW97LA007.md): Hispano Aviacion HA-200 Saeta · Elk City, OK · Accident · No injuries · Limited investigation · Final report · Oct 5, 1996 · N3179K · Substantial damage
  > The loss of aircraft control due to a fuel imbalance as a result of a partial failure of the fuel jettison system. A factor was that fuel could not be transferred from the left wing tip fuel tank to the rear fuselage fuel tank.
- [NTSB SEA97LA002](https://openairdocs.org/ntsb/SEA97LA002.md): Rockwell S2R · Glide, OR · Accident · No injuries · Limited investigation · Final report · Oct 4, 1996 · N8957Q · Substantial damage
  > failure of the pilot to perform an adequate preflight inspection, which led to fuel exhaustion and subsequent loss of power. Factors relating to the accident were: false indications of cockpit fuel gauges and unsuitable terrain for a forced landing.
- [NTSB SEA97FA001](https://openairdocs.org/ntsb/SEA97FA001.md): Boeing Vertol BV-107 II · Canby, OR · Accident · 3 fatal · Field investigation · Final report · Oct 4, 1996 · N196CH · Destroyed
  > failure of maintenance personnel to install a cotter pin in a clevis bolt in the flight control system, which resulted in the aft directional and lateral control output pushrod to become disconnected from a bellcrank in the forward portion of the first stage…
- [NTSB FTW97IA003](https://openairdocs.org/ntsb/FTW97IA003.md): Beech 1900D · Pueblo, CO · Incident · No injuries · Incident investigation · Final report · Oct 4, 1996 · N154ZV · No damage
  > Partial incapacitation of the flightcrew for unknown reasons.
- [NTSB LAX97LA008](https://openairdocs.org/ntsb/LAX97LA008.md): Grumman American AA-1B · Kona, HI · Accident · No injuries · Limited investigation · Final report · Oct 3, 1996 · N1365R · Destroyed
  > loss of engine power for undetermined reason(s).
- [NTSB LAX97LA002](https://openairdocs.org/ntsb/LAX97LA002.md): Piper PA-28-140 · Plymouth, CA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1996 · N5705U · Substantial damage
  > failure of the #3 exhaust valve, which resulted in loss of engine power, a forced landing, and subsequent collision with a fence post.
- [NTSB NYC96LA189](https://openairdocs.org/ntsb/NYC96LA189.md): Cessna 172K · Deal, NJ · Accident · No injuries · Limited investigation · Final report · Sep 28, 1996 · N84593 · Substantial damage
  > the pilot's improper decision/planning, which resulted in fuel exhaustion and a subsequent forced landing.
- [NTSB CHI96FA353](https://openairdocs.org/ntsb/CHI96FA353.md): Cessna 195 · Greenville, MO · Accident · 4 fatal · Field investigation · Final report · Sep 26, 1996 · N195WR · Destroyed
  > the pilot's decision to fly into known adverse weather which resulted in an overload failure and separation of the left wing.
- [NTSB SEA96LA223](https://openairdocs.org/ntsb/SEA96LA223.md): Piper PA-28-235 · Paisley, OR · Accident · Serious injuries · Limited investigation · Final report · Sep 25, 1996 · N8822W · Substantial damage
  > Total loss of engine power secondary to geartrain failure.
- [NTSB IAD96LA154](https://openairdocs.org/ntsb/IAD96LA154.md): Cessna 182 · Kansas, OH · Accident · No injuries · Limited investigation · Final report · Sep 25, 1996 · N6336A · Substantial damage
  > the pilot's improper inflight planning/decision, which resulted in fuel exhaustion during cruise flight and subsequent loss of engine power. A related factor was the lack of suitable terrain for an emergency landing.
- [NTSB IAD96LA153](https://openairdocs.org/ntsb/IAD96LA153.md): Cessna 188 · Pataskala, OH · Accident · No injuries · Limited investigation · Final report · Sep 25, 1996 · N3619J · Substantial damage
  > deterioration and fuel leakage from an engine fuel hose (with a service life that had been exceed, due to inadequate maintenance), which resulted in an engine compartment fire and subsequent damage to the airplane.
- [NTSB SEA96LA219](https://openairdocs.org/ntsb/SEA96LA219.md): Kaman HH-43 B/F · Troy, MT · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 1996 · N4069R · Substantial damage
  > failure of the freewheeling sprag unit bearings for undetermined reasons.
- [NTSB FTW96FA399](https://openairdocs.org/ntsb/FTW96FA399.md): Ayres S2R-T45 · Granger, TX · Accident · 1 fatal · Field investigation · Final report · Sep 23, 1996 · N3107B · Destroyed
  > the pilot's inadvertent flight into adverse weather conditions, and subsequent loss of aircraft control due to spatial disorientation. Factors relating to the accident were darkness, the prevailing fog and low ceilings, the inadequate flight instruments…
- [NTSB FTW96LA396](https://openairdocs.org/ntsb/FTW96LA396.md): Coursey Prostar PT-2 · Rio Rancho, NM · Accident · No injuries · Limited investigation · Final report · Sep 22, 1996 · N822CF · Substantial damage
  > fatigue failure of the engine oil cooler coil, which resulted in an oil leak, oil starvation, loss of engine power, and a subsequent forced landing. Factors relating to the accident were: the proximity of a truck on the highway and soft terrain that was…
- [NTSB CHI96LA350](https://openairdocs.org/ntsb/CHI96LA350.md): Cessna 172D · Germantown Hill, IL · Accident · Minor injuries · Limited investigation · Final report · Sep 22, 1996 · N904SW · Substantial damage
  > the pilot's inadequate fuel supply and his misjudging distance and altitude. The trees were a factor.
- [NTSB CHI96LA346](https://openairdocs.org/ntsb/CHI96LA346.md): Beech B23 · Viroqua, WI · Accident · No injuries · Limited investigation · Final report · Sep 22, 1996 · N66338 · Substantial damage
  > the pilot's inadequate aircraft preflight which led to fuel exhaustion. A factor was the rough uneven terrain.
- [NTSB CHI96FA348](https://openairdocs.org/ntsb/CHI96FA348.md): Cessna 172F · Saint Clair, MN · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1996 · N5373R · Destroyed
  > a loss of power due to the engine's #2 cylinder exhaust valve stuck open, and the pilot's failure to maintain airspeed.
- [NTSB LAX96FA339](https://openairdocs.org/ntsb/LAX96FA339.md): Cessna T207A · Littlefield, AZ · Accident · 1 fatal · Field investigation · Final report · Sep 21, 1996 · N6468H · Destroyed
  > The pilot's failure to maintain clearance with terrain during descent for undetermined reasons. Contributing factors were the dark night and mountainous terrain.
- [NTSB IAD96LA150](https://openairdocs.org/ntsb/IAD96LA150.md): Cessna 150G · Templeton, MA · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1996 · N2607J · Destroyed
  > the student pilot's improper in-flight decision to continued the cross-country flight into night conditions, and his inability to find the destination (or an alternate airport) in a timely manner, which resulted in fuel exhaustion, forced landing, and…
- [NTSB IAD96LA149](https://openairdocs.org/ntsb/IAD96LA149.md): Cessna 172P · Richwood, WV · Accident · No injuries · Limited investigation · Final report · Sep 21, 1996 · N848LF · Substantial damage
  > improper in-flight planning/decision by the flight crew, and inadequate supervision by the check pilot, which resulted in the flight crew's failure to maintain altitude/clearance from trees on rising terrain. A factor relating to the accident was:…
- [NTSB FTW96LA397](https://openairdocs.org/ntsb/FTW96LA397.md): Cessna T210L · Lonestar, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1996 · N369PT · Substantial damage
  > The loss of engine power due to the pilot's improper fuel consumption calculations resulting in the fuel exhaustion. A factor was the unsuitable terrain for the forced landing.
- [NTSB LAX96LA343](https://openairdocs.org/ntsb/LAX96LA343.md): Aero Commander 690 · Truckee, CA · Accident · No injuries · Limited investigation · Final report · Sep 20, 1996 · N840DC · 2 aircraft · Substantial damage
  > The inadequate visual outlook by both pilots while in the vicinity of the airport. A factor was that each aircraft was on a different frequency at the time.
- [NTSB ATL96LA131](https://openairdocs.org/ntsb/ATL96LA131.md): Beech A23 · Tarboro, NC · Accident · No injuries · Limited investigation · Final report · Sep 20, 1996 · N8879M · Substantial damage
  > fatigue failure of the propeller blade. Factors relating to the accident were: corrosion pit(s) on the propeller blade, and inadequate maintenance/inspection of the propeller.
- [NTSB ATL96LA128](https://openairdocs.org/ntsb/ATL96LA128.md): Piper PA-32-300 · Georgetown, SC · Accident · Minor injuries · Limited investigation · Final report · Sep 19, 1996 · N9VM · Substantial damage
  > failure of maintenance personnel to comply with an airworthiness directive, requiring periodic magneto inspections; inadequate annual inspection of the airplane by (other) maintenance personnel; and subsequent failure of the impulse coupling in the left…
- [NTSB LAX96LA338](https://openairdocs.org/ntsb/LAX96LA338.md): Cessna 152 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Sep 18, 1996 · N94381 · Substantial damage
  > A separation of a connecting rod due to a lack of internal lubrication from a blocked oil passage after a bearing had shifted on its journal.
- [NTSB FTW96LA391](https://openairdocs.org/ntsb/FTW96LA391.md): Tubb AIR Commander 532 · Magnolia, AR · Accident · Serious injuries · Limited investigation · Final report · Sep 18, 1996 · N7136C · Substantial damage
  > The loss of engine power due to the loss of coolant, as a result of a leak in the radiator. A factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW96IA389](https://openairdocs.org/ntsb/FTW96IA389.md): Airbus Industrie AE 340-300 · San Antonio, TX · Incident · Minor injuries · Incident investigation · Final report · Sep 18, 1996 · DAIGK · No damage
  > turbulence, and failure of passengers to properly fasten their seat belts and properly hold lap children after the captain announced expected turbulence.
- [NTSB ANC96LA157](https://openairdocs.org/ntsb/ANC96LA157.md): Piper PA-12 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Sep 16, 1996 · N7658H · Substantial damage
  > the pilot's improper planning/decision, which resulted in loss of engine power due to fuel exhaustion. A factor associated with the accident was: the erroneous (false) indication of the fuel sight tubes.
- [NTSB CHI96LA340](https://openairdocs.org/ntsb/CHI96LA340.md): Cessna 150 · Wonder Lake, IL · Accident · No injuries · Limited investigation · Final report · Sep 14, 1996 · N1381Q · Substantial damage
  > a blocked exhaust pipe as a result of an inadequate weld repair to the muffler.
- [NTSB FTW96LA386](https://openairdocs.org/ntsb/FTW96LA386.md): Bell 206L-1/C-30P · Morgan City, LA · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 1996 · N2654 · Substantial damage
  > The loss of tail rotor control as result of a tail rotor blade strike by an undetermined object. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI96LA335](https://openairdocs.org/ntsb/CHI96LA335.md): Piper PA-31 · Janesville, WI · Accident · No injuries · Limited investigation · Final report · Sep 13, 1996 · N27299 · Substantial damage
  > fuel exhaustion as a result of an inadequate preflight by the pilot in command.
- [NTSB ANC96LA154](https://openairdocs.org/ntsb/ANC96LA154.md): Bell 206B · Cantwell, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 13, 1996 · N7982J · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions (IMC). The terrain conditions, low ceiling, fog, and whiteout conditions were related factors.
- [NTSB FTW96LA385](https://openairdocs.org/ntsb/FTW96LA385.md): Hiller UH12E · Hamburg, AR · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 1996 · N156HA · Substantial damage
  > The loss of tail rotor control as result of a tail rotor blade strike by a partially disconnected ballast weight, due to a disconnected pin. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA96LA212](https://openairdocs.org/ntsb/SEA96LA212.md): Grazier Quickie 2 · Superior, MT · Accident · 1 fatal · Limited investigation · Final report · Sep 11, 1996 · N73QQ · Substantial damage
  > loss of engine power after takeoff for undetermined reason(s), and failure of the pilot to maintain adequate airspeed, while maneuvering to return to the departure airport, which resulted in a stall and collision with wooded terrain.
- [NTSB FTW96LA384](https://openairdocs.org/ntsb/FTW96LA384.md): Cessna 177RG · Colorado Sprngs, CO · Accident · No injuries · Limited investigation · Final report · Sep 11, 1996 · N2797V · Substantial damage
  > The improper installation of the propeller governor by company maintenance personnel, resulting in the total loss of oil and engine seizure. Factors were the pilot's misjudgment of altitude and airspeed, causing him to make a forced landing on unsuitable…
- [NTSB NYC96LA183](https://openairdocs.org/ntsb/NYC96LA183.md): Piper PA-28-140 · Closter, NJ · Accident · No injuries · Limited investigation · Final report · Sep 9, 1996 · N1792T · Substantial damage
  > The pilot's improper fuel management, which resulted in a power loss due to fuel exhaustion, followed by the airplane striking a tree during a forced landing.
- [NTSB CHI96LA331](https://openairdocs.org/ntsb/CHI96LA331.md): Cessna 182 · Eden Prairie, MN · Accident · No injuries · Limited investigation · Final report · Sep 8, 1996 · N5401B · Substantial damage
  > the pilot's misjudging the fuel supply and fuel exhaustion. A related factor was the lack of suitable terrain for a forced landing.
- [NTSB ANC96TA148](https://openairdocs.org/ntsb/ANC96TA148.md): Piper PA-18 · Elmendorf, AK · Accident · No injuries · Final report · Sep 8, 1996 · N4372A · Substantial damage
  > loss of engine power due to fuel starvation, which resulted from improper positioning of the fuel tank selector; inadequate supervision by the flight instructor (CFI); and the flight crew's improper emergency procedure.

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

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

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