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

## Cases, newest first

- [NTSB LAX00LA082](https://openairdocs.org/ntsb/LAX00LA082.md): Mince Jurka MJ77 · Rio Vista, CA · Accident · No injuries · Limited investigation · Final report · Jan 22, 2000 · N751JR · Substantial damage
  > The loss of engine power during cruise flight for unknown reasons resulting in a forced landing in a plowed field.
- [NTSB NYC00LA069](https://openairdocs.org/ntsb/NYC00LA069.md): Mooney M20M · Montpelier, VT · Accident · No injuries · Limited investigation · Final report · Jan 21, 2000 · N223KT · Substantial damage
  > A blocked crankcase breather line due to ice and improper maintenance which resulted in further restricting the line. A factor in this accident was the below freezing outside air temperature.
- [NTSB FTW00LA071](https://openairdocs.org/ntsb/FTW00LA071.md): Cessna 152 · Slidell, TX · Accident · No injuries · Limited investigation · Final report · Jan 21, 2000 · N6179Q · Substantial damage
  > The pilot's improper approach planning, which resulted in a downwind landing. A factor was the loss of engine power for undetermined reasons.
- [NTSB FTW00LA068](https://openairdocs.org/ntsb/FTW00LA068.md): Mooney M20K · Tyler, TX · Accident · No injuries · Limited investigation · Final report · Jan 19, 2000 · N1157G · Substantial damage
  > The failure of the crankshaft drive gear as a result of fatigue, which resulted in a forced landing. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA00FA069](https://openairdocs.org/ntsb/MIA00FA069.md): Beech P-35 · Rogersville, TN · Accident · 1 fatal · Field investigation · Final report · Jan 16, 2000 · N9740Y · Substantial damage
  > the pilot's improper in-flight planning/decision and continued visual flight into instrument meteorological conditions (IMC) that resulted in an in-flight collision with terrain and subsequent damage to the aircraft.
- [NTSB LAX00LA075](https://openairdocs.org/ntsb/LAX00LA075.md): Piper PA-38-112 · Kernville, CA · Accident · No injuries · Limited investigation · Final report · Jan 15, 2000 · N2572N · Substantial damage
  > Fuel exhaustion due to the pilot's in-flight decision to not refuel the airplane at an en route stop as planned.
- [NTSB LAX00LA072](https://openairdocs.org/ntsb/LAX00LA072.md): Boeing 757-2G7 · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Jan 12, 2000 · N909AW · No damage
  > Encounter with Clear Air Turbulence. Poor communication between the captain and flight attendants as to the urgency for the flight attendants to take their seats was a contributing factor.
- [NTSB LAX00GA073](https://openairdocs.org/ntsb/LAX00GA073.md): Arrow OH-58A · Crows Landing, CA · Accident · 2 fatal · Final report · Jan 12, 2000 · N901SF · Destroyed
  > The failure of the pilot to maintain altitude and clearance from terrain during a turn to reverse direction after encountering instrument meteorological conditions. A factor in the accident was the pilot's failure to obtain a full weather briefing before…
- [NTSB LAX00LA074](https://openairdocs.org/ntsb/LAX00LA074.md): Beech F-33A · Mobile, AZ · Accident · No injuries · Limited investigation · Final report · Jan 11, 2000 · N1565A · Substantial damage
  > the manufacturer representative's improper reinstallation of the crankshaft counterweight snap rings which subsequently separated, allowing the crankshaft counterweight to contact the crankshaft resulting in a total power loss of engine power.
- [NTSB FTW00LA059](https://openairdocs.org/ntsb/FTW00LA059.md): Piper PA-32-300 · Sweeney, TX · Accident · No injuries · Limited investigation · Final report · Jan 10, 2000 · N8954N · Substantial damage
  > The pilot's excessive flare resulting in a hard landing. Factors were the loss of engine power for undetermined reasons, the power lines on final approach and the dark night conditions.
- [NTSB LAX00LA069](https://openairdocs.org/ntsb/LAX00LA069.md): Cessna 177B · Rialto, CA · Accident · No injuries · Limited investigation · Final report · Jan 8, 2000 · N34021 · Substantial damage
  > The failure of the maintenance personnel to follow the manufacturer's procedures and directives regarding the proper torquing of the screws securing the oil pressure screen housing, which resulted in the loss of lubricating oil, and the subsequent seizure of…
- [NTSB DEN00LA038](https://openairdocs.org/ntsb/DEN00LA038.md): Piper PA-23-250 · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Jan 8, 2000 · N128Y · Substantial damage
  > A forced landing on rough, unsuitable terrain. Factors were: Inadequate preflight planning, flight into known adverse weather conditions containing snow, high gusting winds, low temperatures, and a total loss of power for non mechanical reasons due to…
- [NTSB ATL00FA023](https://openairdocs.org/ntsb/ATL00FA023.md): Beech 23 · Macon, GA · Accident · 2 fatal · Field investigation · Final report · Jan 8, 2000 · N2336Z · Destroyed
  > The loss of engine power for undetermined reasons. A factor was conditions favorable for the formation of carburetor ice.
- [NTSB SEA00FA037](https://openairdocs.org/ntsb/SEA00FA037.md): Cessna 150G · Marysville, WA · Accident · 1 fatal · Field investigation · Final report · Jan 7, 2000 · N3721J · Substantial damage
  > Fuel exhaustion due to the non-certificated 'pilot's' failure to determine the fuel quantity prior to takeoff. Factors include a dark night, and a non-iluminated electrical transmission wire strung across the highway upon which the pilot was attempting to…
- [NTSB MIA00FA064](https://openairdocs.org/ntsb/MIA00FA064.md): Cessna 172R · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Field investigation · Final report · Jan 6, 2000 · N156RA · Destroyed
  > The pilot's lack of total experience in instrument flight, simulated instrument flight, and night flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water. Contributing to the accident was the dark night with…
- [NTSB MIA00FA060](https://openairdocs.org/ntsb/MIA00FA060.md): Robinson R44 · Cayey, PR · Accident · No injuries · Field investigation · Final report · Jan 3, 2000 · N233MP · Substantial damage
  > The pilot's failure to use carburetor heat as required by the Pilot's Operating Handbook resulting in a loss of engine and rotor rpm, forced landing to none suitable terrain (residence), and subsequent roll over.
- [NTSB LAX00LA063](https://openairdocs.org/ntsb/LAX00LA063.md): Cessna 172G · Victorville, CA · Accident · No injuries · Limited investigation · Final report · Jan 3, 2000 · N3690L · Substantial damage
  > The failure of the pilot to maintain positional awareness, which resulted in his becoming lost and disoriented. Contributing factors were the pilot's delay requesting assistance from air traffic control and the failure of the airplane's electrical generator.
- [NTSB FTW00LA067](https://openairdocs.org/ntsb/FTW00LA067.md): Piper PA-46-310P · Corning, AR · Accident · No injuries · Limited investigation · Final report · Jan 3, 2000 · N87NF · Substantial damage
  > The loss of engine power for an undetermined reason. A factor was the dark night light condition.
- [NTSB FTW00LA058](https://openairdocs.org/ntsb/FTW00LA058.md): Cessna A185F · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jan 3, 2000 · N999SW · Substantial damage
  > the loss of engine power during climb as a result of fatigue cracking of the #4 cylinder head and its subsequent separation from its barrel.
- [NTSB LAX00LA062](https://openairdocs.org/ntsb/LAX00LA062.md): Cessna 172A · Dos Palos, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 2, 2000 · N7249T · Substantial damage
  > A partial loss of engine power due to the failure of maintenance personnel to properly install and safety the throttle arm to the carburetor throttle shaft.
- [NTSB FTW00LA057](https://openairdocs.org/ntsb/FTW00LA057.md): Piper PA-46-310P · Odessa, TX · Accident · No injuries · Limited investigation · Final report · Jan 2, 2000 · N4389W · Substantial damage
  > The separation of the #1 piston pin due to fatigue, which resulted in a total loss of engine power. A factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN00FA037](https://openairdocs.org/ntsb/DEN00FA037.md): Cessna 421B · Telluride, CO · Accident · 1 fatal · Field investigation · Final report · Jan 2, 2000 · N421CF · Destroyed
  > The non-instrument rated pilot's intentional flight into IMC, and his subsequent spatial disorientation that resulted in an inadvertent stall. A factor was the snow showers weather condition.
- [NTSB MIA00LA063](https://openairdocs.org/ntsb/MIA00LA063.md): Cessna 550 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Jan 1, 2000 · N752CC · Substantial damage
  > An inadvertent in-flight collision with a bird in cruise flight resulting in substantial damage to the airplane.
- [NTSB ATL00FA019](https://openairdocs.org/ntsb/ATL00FA019.md): Bellanca BL-17-30A · Monteagle, TN · Accident · 2 fatal · Field investigation · Final report · Jan 1, 2000 · N8821V · Destroyed
  > The pilot's failure to adequately evaluate weather conditions that resulted in the continuation of visual flight into instrument weather conditions and the subsequent collision with trees.
- [NTSB SEA00LA034](https://openairdocs.org/ntsb/SEA00LA034.md): Cessna 182S · Kennewick, WA · Accident · No injuries · Limited investigation · Final report · Dec 30, 1999 · N374TC · Substantial damage
  > The pilot's decision to continue flight into known icing conditions, and his subsequent failure to maintain adequate airspeed on final approach, resulting in a hard landing. Factors included: icing conditions; the pilot's improper decision to continue to his…
- [NTSB CHI00LA052](https://openairdocs.org/ntsb/CHI00LA052.md): Cessna T210F · Indianola, IA · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 1999 · N6144R · Destroyed
  > loss of engine power for undetermined reason. A factor relating to this accident was the tree.
- [NTSB FTW00FA053](https://openairdocs.org/ntsb/FTW00FA053.md): Mooney M20K · Mcalester, OK · Accident · 1 fatal · Field investigation · Final report · Dec 27, 1999 · N5697N · Destroyed
  > The pilot's failure to maintain aircraft control. Factors were the pilot's impairment (drugs), the deployed right speed brake, and the night conditions.
- [NTSB IAD00LA014](https://openairdocs.org/ntsb/IAD00LA014.md): Prudhomme Velocity RG 173 · Richmond, VA · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1999 · N242JP · Substantial damage
  > the improper installation of the oil supply line to the propeller governor which resulted in a loss of lubrication, overtemperature, and a loss of engine power.
- [NTSB NYC00LA061](https://openairdocs.org/ntsb/NYC00LA061.md): Zielke RV-4 · Florence, NJ · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 1999 · N8ZZ · Substantial damage
  > Failure of one of the propeller blades. A factor was the necessity land across, rather than in alignment with, the furrowed terrain due to the nature of the emergency.
- [NTSB DEN00LA031](https://openairdocs.org/ntsb/DEN00LA031.md): Luscombe 8E · San Luis, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 1999 · N1941B · Substantial damage
  > The pilot's inadequate in-flight decision, and the subsequent inadvertent stall/mush. Factors were the pilot's lack of total experience in mountain flying, the high density altitude, and downdraft weather conditions.
- [NTSB CHI00LA055](https://openairdocs.org/ntsb/CHI00LA055.md): Beech BE-35 · Mokane, MO · Accident · No injuries · Limited investigation · Final report · Dec 24, 1999 · N2012D · Substantial damage
  > fuel starvation due to the pilot's failure to make accurate fuel consumption calculations and the pilot's improper emergency procedures for engine re-start. A factor was the ditch.
- [NTSB ATL00LA018](https://openairdocs.org/ntsb/ATL00LA018.md): Cessna 208B · Adjuntas, PR · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1999 · N1315A · Destroyed
  > The pilot continued flight into adverse weather conditions that included low ceiling and turbulence. Factors to the accident were trees.
- [NTSB MIA00FA056](https://openairdocs.org/ntsb/MIA00FA056.md): Beech E-90 · Beaufort, SC · Accident · 1 fatal · Field investigation · Final report · Dec 20, 1999 · N75CF · Destroyed
  > The pilot-in-commands failure to maintain the appropriate altitude (minimum descent altitude) during an area surveillance radar (ASR) approach, resulting in an in-flight collision with swampy terrain. Contributing to the accident was the co-pilot's failure to…
- [NTSB LAX00LA052](https://openairdocs.org/ntsb/LAX00LA052.md): Rhea KR-2 · Moreno Valley, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 18, 1999 · N77KR · Substantial damage
  > An undetected fuel leak from an improperly manufactured right tank into the internal wing spaces, which resulted in fuel exhaustion.
- [NTSB FTW00FA046](https://openairdocs.org/ntsb/FTW00FA046.md): Globe GC-1B · Edgewood, TX · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1999 · N80951 · Substantial damage
  > the pilot's failure to maintain aircraft control during a forced landing which resulted in a stall/spin. Contributing factors were the failure of the engine driven fuel pump, the engine manufacturer's use of an inadequate fuel pump which was only intended for…
- [NTSB NYC00LA054](https://openairdocs.org/ntsb/NYC00LA054.md): Mooney 20J · New Milford, CT · Accident · No injuries · Limited investigation · Final report · Dec 17, 1999 · N43TP · Substantial damage
  > Failure of 3 of the 4 connecting rods for an undetermined reason.
- [NTSB CHI00LA048](https://openairdocs.org/ntsb/CHI00LA048.md): Beech 35 · Hanover, MI · Accident · Minor injuries · Limited investigation · Final report · Dec 17, 1999 · N5BB · Substantial damage
  > fuel starvation and the pilot's improper fuel tank selector position. A factor was the swampy terrain.
- [NTSB MIA00LA051](https://openairdocs.org/ntsb/MIA00LA051.md): Cessna 152 · Woodville, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 1999 · N460TC · Substantial damage
  > The pilot's improper preflight planning resulting in loss of engine power due to fuel exhaustion and the collision with trees during a forced landing.
- [NTSB FTW00LA044](https://openairdocs.org/ntsb/FTW00LA044.md): Beech F35 · Elk City, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 1999 · N3359C · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN00LA027](https://openairdocs.org/ntsb/DEN00LA027.md): Cessna 182R · Farmington, NM · Accident · No injuries · Limited investigation · Final report · Dec 14, 1999 · N9616H · Substantial damage
  > The pilot's inadequate preflight planning, and his improper inflight decision to not land and refuel, which resulted in fuel exhaustion.
- [NTSB CHI00LA046](https://openairdocs.org/ntsb/CHI00LA046.md): Cessna 150B · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Dec 14, 1999 · N7339X · Substantial damage
  > The pilots failure to use carburetor heat during takeoff in weather conducive for serious carburetor ice. Factors were the weather that was conducive for carburetor icing and the presence of the truck that the aircraft impacted.
- [NTSB SEA00FA031](https://openairdocs.org/ntsb/SEA00FA031.md): Mooney M20-M · Missoula, MT · Accident · 1 fatal · Field investigation · Final report · Dec 12, 1999 · N270BB · Destroyed
  > Engine failure for undetermined reasons. Factors include the lack of suitable terrain for an emergency landing, trees and mountainous terrain.
- [NTSB NYC00MA048](https://openairdocs.org/ntsb/NYC00MA048.md): Israel Aircraft Industries 1124A · Gouldsboro, PA · Accident · 3 fatal · Major investigation · Final report · Dec 12, 1999 · N50PL · Destroyed
  > The improper assembly of the horizontal stabilizer trim actuator unit by maintenance personnel.
- [NTSB FTW00LA042](https://openairdocs.org/ntsb/FTW00LA042.md): King Lancair 235/320 · Sterling City, TX · Accident · No injuries · Limited investigation · Final report · Dec 12, 1999 · N717SK · Substantial damage
  > The fatigue fracture of the propeller attaching bolts, due to improper torque during the installation of the propeller by other maintenance personnel. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA00FA048](https://openairdocs.org/ntsb/MIA00FA048.md): Cessna U-3A · Brooksville, MS · Accident · 1 fatal · Field investigation · Final report · Dec 11, 1999 · N8063X · Destroyed
  > The in-flight loss of control for undetermined reasons resulting in the collision with terrain.
- [NTSB LAX00LA043](https://openairdocs.org/ntsb/LAX00LA043.md): Piper PA-31-350 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Dec 11, 1999 · N27181 · Substantial damage
  > The pilot's failure to follow the manufacturer's published emergency procedures for engine loss of power resulting in a forced landing in an open construction area where the airplane collided with a berm. A related factor was the loss of engine power in the…
- [NTSB ANC00FA018](https://openairdocs.org/ntsb/ANC00FA018.md): Cessna 207 · Bethel, AK · Accident · 6 fatal · Field investigation · Final report · Dec 7, 1999 · N1747U · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, fog, and snow-covered terrain.
- [NTSB FTW00LA040](https://openairdocs.org/ntsb/FTW00LA040.md): Bell 206L-1 · Ship Shoal 225 · Accident · Serious injuries · Limited investigation · Final report · Dec 5, 1999 · N600CK · Substantial damage
  > The loss of power for undetermined reasons. A factor was the rough water condition.
- [NTSB MIA00LA039](https://openairdocs.org/ntsb/MIA00LA039.md): Pitts S1C · Creedmore, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 4, 1999 · N177J · Substantial damage
  > The pilot's failure to select the reserve position of the fuel tank resulting in loss of engine power due to fuel starvation and a nose over during a forced landing.
- [NTSB MIA00LA038](https://openairdocs.org/ntsb/MIA00LA038.md): Maule MX-7-160 · Palm Bch Garden, FL · Accident · No injuries · Limited investigation · Final report · Dec 3, 1999 · N9235N · Substantial damage
  > The sailplane pilot's failure to comply with standard emergency procedures for 'sailplane release failure' upon its occurrence and his maneuvering of the sailplane while still tethered to the tow plane resulting in the inflight loss of control and engine…

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

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

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