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

## Cases, newest first

- [NTSB DEN00FA086](https://openairdocs.org/ntsb/DEN00FA086.md): Smith, Ted Aerostar Aerostar 601 · Estes Park, CO · Accident · 2 fatal · Field investigation · Final report · Apr 30, 2000 · N7421S · Destroyed
  > A descent below the surrounding terrain, by the pilot, in IMC conditions. Factors were high mountainous terrain, clouds, inaccurate weather evaluation by the pilot, and the pilot's flight into IMC conditions.
- [NTSB CHI00LA127](https://openairdocs.org/ntsb/CHI00LA127.md): Fairchild PT-26B · Winn, MI · Accident · Minor injuries · Limited investigation · Final report · Apr 30, 2000 · N53366 · Substantial damage
  > the pilot's inadequate fuel management. Factors to the accident were fuel starvation, the low altitude at the time of the loss of engine power, remedial action not possible by the pilot, and the unsuitable terrain for landing encountered by the pilot.
- [NTSB MIA00FA141](https://openairdocs.org/ntsb/MIA00FA141.md): North American SNJ-5 · Elk Park, NC · Accident · 2 fatal · Field investigation · Final report · Apr 28, 2000 · N3187G · Destroyed
  > The inflight loss of control for undetermined reasons resulting in the airplane colliding with mountainous terrain during the uncontrolled descent.
- [NTSB DEN00FA078](https://openairdocs.org/ntsb/DEN00FA078.md): Douglas DC-8-62F · Denver, CO · Accident · No injuries · Field investigation · Final report · Apr 28, 2000 · N990CF · Substantial damage
  > The failure of the clamp that secured the high-pressure bleed air duct to the high-pressure relief valve. Factors were the resulting excessive pressurization of the engine nacelle, and the subsequent separation of the engine cowling.
- [NTSB NYC00LA121](https://openairdocs.org/ntsb/NYC00LA121.md): Cessna 150D · Waynesville, OH · Accident · No injuries · Limited investigation · Final report · Apr 26, 2000 · N4182U · Substantial damage
  > The pilot's inadequate preflight, and the water that remained in the fuel system after the preflight.
- [NTSB FTW00LA132](https://openairdocs.org/ntsb/FTW00LA132.md): Cessna 140 · Hunter, OK · Accident · No injuries · Limited investigation · Final report · Apr 26, 2000 · N76176 · Substantial damage
  > The pilot's inadequate preflight resulting in the loss of the oil cap and subsequent loss of engine oil. A factor was the lack of suitable terrain for the landing.
- [NTSB FTW00LA131](https://openairdocs.org/ntsb/FTW00LA131.md): Beech BE-35 · Lancaster, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 25, 2000 · N5269C · Substantial damage
  > the loss of engine power for undetermined reasons.
- [NTSB ATL00FA048](https://openairdocs.org/ntsb/ATL00FA048.md): Eurocopter BK117-A3 · St. Petersburg, FL · Accident · 3 fatal · Field investigation · Final report · Apr 25, 2000 · N428MB · Destroyed
  > The pilot's failure to maintain clearance that resulted in the in-flight collision with a tower.
- [NTSB SEA00LA075](https://openairdocs.org/ntsb/SEA00LA075.md): Piper PA-28-181 · Ashland, OR · Accident · Serious injuries · Limited investigation · Final report · Apr 24, 2000 · N55PJ · Substantial damage
  > The pilot's failure to refuel the airplane, which resulted in a loss of engine power due to fuel exhaustion. Unsuitable terrain for a landing was a contributing factor.
- [NTSB NYC00FA119](https://openairdocs.org/ntsb/NYC00FA119.md): Beech N35 · Conicville, VA · Accident · 2 fatal · Field investigation · Final report · Apr 22, 2000 · N1253Z · Destroyed
  > The pilot's in-flight decision to continue flight into IMC conditions, and his failure to maintain control of the airplane. Factors related to the accident were the failure of the vacuum pump and the pilot's lack of recent instrument time.
- [NTSB LAX00FA170](https://openairdocs.org/ntsb/LAX00FA170.md): Emigh Trojan A2 · Brentwood, CA · Accident · 2 fatal · Field investigation · Final report · Apr 22, 2000 · N8324H · Destroyed
  > the pilot's failure to maintain control of the airplane.
- [NTSB LAX00FA168](https://openairdocs.org/ntsb/LAX00FA168.md): Beech D35 · Agua Dulce, CA · Accident · 1 fatal · Field investigation · Final report · Apr 22, 2000 · N2086D · Destroyed
  > The pilot's failure to maintain terrain clearance while cruising up a mountain pass, on a dark night, in IMC conditions, and his improper in-flight decision to perform a VFR flight in the inclement weather.
- [NTSB NYC00FA118](https://openairdocs.org/ntsb/NYC00FA118.md): Mooney M20J · Norton, VA · Accident · 5 fatal · Field investigation · Final report · Apr 21, 2000 · N5632H · Destroyed
  > The pilot's improper weather evaluation, which resulted in a loss of aircraft control. Factors in this accident were icing conditions, and aircraft loading which exceed the airplane's weight and balance limitations.
- [NTSB LAX00LA167](https://openairdocs.org/ntsb/LAX00LA167.md): Eurocopter AS-350 BA · Kahului, HI · Accident · No injuries · Limited investigation · Final report · Apr 21, 2000 · N6094H · Substantial damage
  > Failure of the manufacturer to ensure proper quality control of the ignition solenoid housing chamfer area, which allowed for insufficient clamping forces between the ignition solenoid housing and T-fitting, and the eventual separation of the T-fitting, loss…
- [NTSB LAX00LA165](https://openairdocs.org/ntsb/LAX00LA165.md): Cessna 152 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Apr 21, 2000 · N152SC · Substantial damage
  > Fuel exhaustion during cruise flight due to the student pilot becoming disoriented and lost.
- [NTSB LAX00LA162](https://openairdocs.org/ntsb/LAX00LA162.md): Schweizer G-164B · Lodi, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 2000 · N3629F · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB FTW00LA127](https://openairdocs.org/ntsb/FTW00LA127.md): Mooney M20F · Tomball, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 2000 · N7038V · Substantial damage
  > Engine seizure due to the rupture of an oil cooler line.
- [NTSB DEN00FA074](https://openairdocs.org/ntsb/DEN00FA074.md): Bell 206L-3 · Lakewood, CO · Accident · No injuries · Field investigation · Final report · Apr 18, 2000 · N937S · Substantial damage
  > The complete loss of the tail rotor blades due to a fatigue failure of one blade. Factors were sloping and rough uneven terrain for the ensuing forced landing.
- [NTSB LAX00LA157](https://openairdocs.org/ntsb/LAX00LA157.md): Cessna 207 · Yreka, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 2000 · N1682U · Substantial damage
  > the total loss of engine power while in cruise flight due to the fatigue failure of the engine's anti-ice bleed air line, which resulted in the pilot's inability to utilize the engine anti-ice system. Contributing factors were the icing conditions and the…
- [NTSB LAX00LA156](https://openairdocs.org/ntsb/LAX00LA156.md): Bell 407 · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Apr 16, 2000 · N175PA · Substantial damage
  > The failure and subsequent disintegration of the oil cooler fan forward hanger bearing.
- [NTSB NYC00LA114](https://openairdocs.org/ntsb/NYC00LA114.md): Loomis Sidewinder · Cincinnati, OH · Accident · No injuries · Limited investigation · Final report · Apr 15, 2000 · N13545 · Substantial damage
  > A partial power loss for undetermined reasons.
- [NTSB LAX00LA155](https://openairdocs.org/ntsb/LAX00LA155.md): Smith RV-4 · Willows, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2000 · N63SM · Substantial damage
  > Disconnection of the elevator push rod due to the owner/builder's improper installation of the rear jam nut on the elevator pushrod.
- [NTSB CHI00LA112](https://openairdocs.org/ntsb/CHI00LA112.md): North American T-28B · Kankakee, IL · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2000 · N82AW · Destroyed
  > the misjudged glidepath by the pilot. Factors were the failure of the impeller seal resulting in a total loss of engine oil and subsequent engine failure, the plowed farm field, and the lack of suitable terrain for the forced landing.
- [NTSB NYC00FA112](https://openairdocs.org/ntsb/NYC00FA112.md): Cessna 172H · Grottoes, VA · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2000 · N1404F · Destroyed
  > The pilot's loss of control of the airplane in instrument meteorological conditions, which resulted in an inadvertent stall/spin. Factors included the pilot's lack of instrument time under actual conditions, and his lack of recent instrument flight experience.
- [NTSB CHI00FA111](https://openairdocs.org/ntsb/CHI00FA111.md): Bell 222U · St. Paul, MN · Accident · No injuries · Field investigation · Final report · Apr 14, 2000 · N225LL · Substantial damage
  > The loss of clamp-up force between the transmission case and the pylon mounted actuator support assembly which resulted in fatigue failure of the threaded studs and dowel pins, the failure of the flight control system, helicopter control not being possible…
- [NTSB MIA00LA132](https://openairdocs.org/ntsb/MIA00LA132.md): Hartline Glastar · Woodstock, AL · Accident · Serious injuries · Limited investigation · Final report · Apr 13, 2000 · N897G · Substantial damage
  > a total engine failure for undetermined reason, resulting in a forced landing and subsequent impact with a tree.
- [NTSB SEA00LA070](https://openairdocs.org/ntsb/SEA00LA070.md): Cessna 150M · Auburn, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 2000 · N9301U · Substantial damage
  > The pilot's failure to follow aircraft operating procedures by not raising the flaps during the go-around maneuver. Contributing factors were the pilot's failure to adhere to the balked landing checklist (FLAPS to 20) resulting in degraded climb performance,…
- [NTSB MIA00LA130](https://openairdocs.org/ntsb/MIA00LA130.md): Scott Vans RV-4 · Natchez, MS · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 2000 · N123SC · Substantial damage
  > an inadvertent stall at too low altitude to allow recovery. Factors in this accident were fog and low ceilings.
- [NTSB IAD00TA040](https://openairdocs.org/ntsb/IAD00TA040.md): Cessna 182RG · Cleveland, OH · Accident · No injuries · Final report · Apr 12, 2000 · N6183T · Substantial damage
  > the pilot's intentional flight into known icing conditions which resulted in an inadvertent stall/mush and hard landing. A factor in the accident was the icing conditions.
- [NTSB ANC00LA041](https://openairdocs.org/ntsb/ANC00LA041.md): Piper PA-28 · Aleknagik, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 2000 · N6119W · Substantial damage
  > The first pilot's (pilot-in-command) inadequate evaluation of the weather, and failure to maintain an adequate altitude above the ground. Factors in the accident were low ceilings, and snow-covered terrain.
- [NTSB SEA00LA068](https://openairdocs.org/ntsb/SEA00LA068.md): PZL-Bielsko SZD-45A Ogar · Libby, MT · Accident · No injuries · Limited investigation · Final report · Apr 8, 2000 · N54AS · Substantial damage
  > A crack in the propeller blade that developed into a complete separation of the blade.
- [NTSB SEA00LA066](https://openairdocs.org/ntsb/SEA00LA066.md): Beech A200 · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Apr 8, 2000 · N258AG · Substantial damage
  > The pilot's failure to properly follow pre-takeoff checklists (resulting in the engine starters remaining engaged after engine start, generators not being activated, discharge of the aircraft battery and consequent total electrical failure during flight with…
- [NTSB FTW00LA119](https://openairdocs.org/ntsb/FTW00LA119.md): Cessna 172E · Lubbock, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 7, 2000 · N5682T · Substantial damage
  > The pilot's incorrect positioning of the fuel selector which resulted in fuel starvation. Factors were the pilot's lack of familiarity with the fuel system due to an inadequate checkout by a flight instructor, and the lack of suitable terrain for the forced…
- [NTSB NYC00IA116](https://openairdocs.org/ntsb/NYC00IA116.md): Israel Aircraft Industries 1125 · Pine Knot, KY · Incident · No injuries · Incident investigation · Final report · Apr 3, 2000 · N511WA · No damage
  > The partial failure of an inverter and the inadequate design of the electrical circuit breaker system.
- [NTSB LAX00LA146](https://openairdocs.org/ntsb/LAX00LA146.md): Boeing 757-2G7 · Dallas, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 3, 2000 · N910AW · No damage
  > The en route cruise encounter with forecast moderate turbulence.
- [NTSB FTW00FAMS1](https://openairdocs.org/ntsb/FTW00FAMS1.md): Beech M35 · Gulf Of Mexico · Accident · 1 fatal · Missing aircraft · Final report · Apr 3, 2000 · N9778R · Destroyed
  > the pilot's continued flight of the airplane into known adverse weather conditions resulting in the pilot's loss of control of the aircraft. Contributing factors were the severe turbulence and windshear.
- [NTSB SEA00FA061](https://openairdocs.org/ntsb/SEA00FA061.md): Bell 47G-3B-1 · Stanwood, WA · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2000 · N3377H · Destroyed
  > The disengagement of the oil jet fitting from its threaded receptacle at the forward end of the engine crankshaft. This resulted in excessive oil within the clutch assembly, the subsequent slipping of the clutch, and ultimately the disengagement of the rotor…
- [NTSB LAX00LA153](https://openairdocs.org/ntsb/LAX00LA153.md): Quicksilver Sprint 2 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Apr 2, 2000 · UNREG · Substantial damage
  > The overheating and seizure of the number 2 piston for undetermined reasons. Also causal was the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing, which led to an inadvertent stall/mush.
- [NTSB FTW00FA113](https://openairdocs.org/ntsb/FTW00FA113.md): Vans RV-6T · Pettigrew, AR · Accident · 2 fatal · Field investigation · Final report · Apr 2, 2000 · N96VA · Destroyed
  > the pilot's continued flight into known adverse weather and his failure to maintain obstacle clearance. Contributing factors were adverse weather conditions, and the pilot's disregard for the forecasted adverse weather.
- [NTSB CHI00LA103](https://openairdocs.org/ntsb/CHI00LA103.md): Piper PA-28-140 · Pine City, MN · Accident · Minor injuries · Limited investigation · Final report · Apr 2, 2000 · N54454 · Substantial damage
  > A loss of engine power due to the failure of the number four cylinder's exhaust valve spring and exhaust valve. Contributing to the accident were, the barbwire fence and the clump of high vegetation encountered by the airplane.
- [NTSB NYC00LA115](https://openairdocs.org/ntsb/NYC00LA115.md): Mooney M-20F · Parker, PA · Accident · No injuries · Limited investigation · Final report · Apr 1, 2000 · N737HB · Substantial damage
  > The pilot's failure to maintain an adequate visual lookout, due to his distraction with a flock of birds. A factor was the pilot's improper in flight decision to continue the simulated engine failure to too low of an altitude.
- [NTSB IAD00IA032](https://openairdocs.org/ntsb/IAD00IA032.md): Boeing 767-332 · New York City, NY · Incident · No injuries · Incident investigation · Final report · Mar 31, 2000 · N182DN · No damage
  > The first officer's failure to maintain control of the airplane during climb out over water at night, which was a result of spatial disorientation. Factors in the incident were the cloud layer and dark night.
- [NTSB ANC00TA039](https://openairdocs.org/ntsb/ANC00TA039.md): Bell 206B · Manokotak, AK · Accident · No injuries · Final report · Mar 30, 2000 · N5006R · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings and snow, and snow-covered terrain.
- [NTSB MIA00LA123](https://openairdocs.org/ntsb/MIA00LA123.md): Ayres S2R-G10 · Leesburg, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 29, 2000 · N4089Q · Substantial damage
  > The failure of the pilot to maintain clearance during a spray pass resulting in the in-flight collision with the raised rows of the field.
- [NTSB NYC00LA103](https://openairdocs.org/ntsb/NYC00LA103.md): Cessna 177RG · Renick, WV · Accident · Serious injuries · Limited investigation · Final report · Mar 28, 2000 · N1830Q · Substantial damage
  > The pilot's improper weather evaluation, and subsequent improper decision to fly into forecast and known icing conditions that exceeded the capability of the airplane to maintain flight. A factor was the icing conditions.
- [NTSB LAX00LA135](https://openairdocs.org/ntsb/LAX00LA135.md): Cessna 172 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Mar 25, 2000 · N7354A · Substantial damage
  > The pilot's inadequate weather evaluation, and his improper remedial actions that led to a precautionary landing and subsequent attempted takeoff from unsuitable terrain.
- [NTSB FTW00LA106](https://openairdocs.org/ntsb/FTW00LA106.md): Ward Acro · Beasley, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 2000 · N79RW · Substantial damage
  > The loss of engine power for an undetermined reason.
- [NTSB CHI00LA098](https://openairdocs.org/ntsb/CHI00LA098.md): Cessna 152 · Butler, MO · Accident · No injuries · Limited investigation · Final report · Mar 25, 2000 · N6375H · Substantial damage
  > the certified flight instructor's improper use of the mixture control while demonstrating a simulated loss of engine power which resulted in fuel starvation. A factor associated with the accident was the rough terrain on which the forced landing was made.
- [NTSB LAX00LA139](https://openairdocs.org/ntsb/LAX00LA139.md): Scovil KR-2 · Tonopah, AZ · Accident · No injuries · Limited investigation · Final report · Mar 24, 2000 · N73BP · Substantial damage
  > The fuel control metering unit becoming disengaged and the inadvertent use of the fuel supply during flight.
- [NTSB MIA00LA114](https://openairdocs.org/ntsb/MIA00LA114.md): Mckinnis Steen Skybolt · Tuscaloosa, AL · Accident · No injuries · Limited investigation · Final report · Mar 20, 2000 · N75CM · Substantial damage
  > a loss of engine power during climb due to fuel starvation which was caused by a fuel leak in the gascolator as a result of improper maintenance by the operator that resulted in the pilot making a forced landing during which the airplane sustained substantial…

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

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

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