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

## Cases, newest first

- [NTSB NYC01LA025](https://openairdocs.org/ntsb/NYC01LA025.md): Cessna 172M · Camp Springs, MD · Accident · No injuries · Limited investigation · Final report · Oct 19, 2000 · N950ME · Substantial damage
  > The pilot's improper in-flight decision to operate close behind a large airplane at the same altitude, which resulted in a wake turbulence encounter.
- [NTSB MIA01FA006](https://openairdocs.org/ntsb/MIA01FA006.md): Aerospatiale AS-355-F2 · Burlington, NC · Accident · 1 fatal · Field investigation · Final report · Oct 17, 2000 · N355DU · Destroyed
  > The mechanics failure to comply with manufacturers instructions for correction of a illuminated main rotor gearbox oil pressure warning light resulting in the helicopter being dispatched on a ferry flight with a failed main rotor gearbox oil pump, failure of…
- [NTSB CHI01MA011](https://openairdocs.org/ntsb/CHI01MA011.md): Cessna 335 · Hillsboro, MO · Accident · 3 fatal · Class 1 · Major · Final report · Oct 17, 2000 · N8354N · Destroyed
  > The pilot's failure to control the airplane while maneuvering because of spatial disorientation. Contributing to the accident were the failure of the airplane's primary attitude indicator and the adverse weather conditions, including turbulence.
- [NTSB NYC01LA013](https://openairdocs.org/ntsb/NYC01LA013.md): Piper PA-28-181 · Southborough, MA · Accident · No injuries · Limited investigation · Final report · Oct 15, 2000 · N4381S · Substantial damage
  > A failed connecting rod assembly, with the initiating event undetermined.
- [NTSB ATL01LA009](https://openairdocs.org/ntsb/ATL01LA009.md): Cessna 150L · Homer, GA · Accident · No injuries · Limited investigation · Final report · Oct 14, 2000 · N18130 · Substantial damage
  > The loss of engine power for undetermined reasons. Factors were conditions favorable for the formation of carburetor ice.
- [NTSB FTW01LA009](https://openairdocs.org/ntsb/FTW01LA009.md): Bellanca BL17-30 · Waller, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 2000 · N4882V · Substantial damage
  > the loss of engine power during climb to cruise due to the failure of the crankshaft counterweight. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI01LA009](https://openairdocs.org/ntsb/CHI01LA009.md): Piper PA-28-140 · Lansing, MI · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 2000 · N732FL · Substantial damage
  > the pilot's inaccurate preflight planning. Factors were the fuel exhaustion, the trees, and the bright night condition.
- [NTSB DEN01FA003](https://openairdocs.org/ntsb/DEN01FA003.md): Cessna R-182 · Grants, NM · Accident · 1 fatal · Field investigation · Final report · Oct 11, 2000 · N182BG · Destroyed
  > the pilot's continued VFR flight into IMC during cruise. Contributing factors were the dark night light conditions, and the cloudy weather conditions.
- [NTSB MIA01LA002](https://openairdocs.org/ntsb/MIA01LA002.md): Harwell/Gardner WAG-AERO Cubby · Stockbridge, GA · Accident · No injuries · Limited investigation · Final report · Oct 10, 2000 · N909GH · Substantial damage
  > The pilot's failure to maintain a visual lookout during a forced landing resulting in an on-ground collision with a berm on landing roll out. Contributing to the accident was a reported loss of engine power for undetermined reasons.
- [NTSB FTW01FA007](https://openairdocs.org/ntsb/FTW01FA007.md): Piper PA-23-160 · Cotulla, TX · Accident · 1 fatal · Field investigation · Final report · Oct 10, 2000 · N3390P · Substantial damage
  > The pilot's failure to refuel the airplane which resulted in fuel exhaustion and subsequent loss of engine power. Also contributing to the accident was the pilot's failure to feather the engine.
- [NTSB LAX01FA006](https://openairdocs.org/ntsb/LAX01FA006.md): McDonnell Douglas 369E · Kernville, CA · Accident · Minor injuries · Field investigation · Final report · Oct 8, 2000 · N819CE · Substantial damage
  > The pilot's improper storage of personal items and his inadequate preflight inspection, which resulted in the unlatching of the left rear cabin door during flight and allowing a plastic garment bag to blow out and strike the tail rotor.
- [NTSB CHI01LA003](https://openairdocs.org/ntsb/CHI01LA003.md): Cessna 182 · Noblesville, IN · Accident · No injuries · Limited investigation · Final report · Oct 8, 2000 · N8907X · Substantial damage
  > Carburetor icing and the pilot's inadequate in-flight planning by his delayed use of carburetor heat. A factor associated with the accident was the unsuitable terrain.
- [NTSB CHI01LA004](https://openairdocs.org/ntsb/CHI01LA004.md): Cessna 172M · Sparta, WI · Accident · Minor injuries · Limited investigation · Final report · Oct 7, 2000 · N13214 · Destroyed
  > the pilot's inaccurate fuel consumption calculations, improper fuel management, inadequate in-flight planning/decision, flight to destination alternate not performed, and the discontinued planned approach to the initially selected runway. Contributing factors…
- [NTSB ANC01LA003](https://openairdocs.org/ntsb/ANC01LA003.md): Helio H-295 · Port Alsworth, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 6, 2000 · N295BA · Substantial damage
  > The pilot's inadequate preflight inspection, which failed to remove all water from the fuel system. A factor associated with the accident was unsuitable terrain for a forced landing.
- [NTSB NYC01LA003](https://openairdocs.org/ntsb/NYC01LA003.md): Cessna 150M · Haverford Twp., PA · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 2000 · N704ST · Substantial damage
  > A loss of engine power due to fuel exhaustion. Also causal was the pilot's inability to locate the airport. A factor in this accident was the dark night conditions.
- [NTSB LAX01FA003](https://openairdocs.org/ntsb/LAX01FA003.md): Cessna 182S · Santa Rosa, CA · Accident · 1 fatal · Field investigation · Final report · Oct 4, 2000 · N2373D · Destroyed
  > the pilot's loss of airplane control due to spatial disorientation. A related factor was the low ceiling.
- [NTSB FTW01LA005](https://openairdocs.org/ntsb/FTW01LA005.md): Holt Thorpe T-18C · Imperial, TX · Accident · 2 fatal · Limited investigation · Final report · Oct 4, 2000 · N85LH · Destroyed
  > the failure of the propeller blade due to fatigue, which originated from a corrosion crack. A contributory factor was the pilot/owner's failure to ensure that the propeller was overhauled at the manufacturer's recommended interval.
- [NTSB CHI01LA002](https://openairdocs.org/ntsb/CHI01LA002.md): Moseler RAF 2000 GTX SE · Muskegon, MI · Accident · 1 fatal · Limited investigation · Final report · Oct 4, 2000 · N1187Z · Destroyed
  > The main rotor contacting with the vertical stabilizer, the loss of the vertical stabilizer, and the aircraft control not possible by the pilot.
- [NTSB ATL01LA004](https://openairdocs.org/ntsb/ATL01LA004.md): Joseph A. Grimaud Seawind 3000 · Chapin, SC · Accident · No injuries · Limited investigation · Final report · Oct 3, 2000 · N98GG · Substantial damage
  > A total loss of engine power for undetermined reasons. A factor was the trees.
- [NTSB NYC01LA002](https://openairdocs.org/ntsb/NYC01LA002.md): Maule M-5 · Leicester, MA · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 2000 · N5638D · Substantial damage
  > The pilot's failure to properly manage the fuel onboard the airplane, which resulted in fuel starvation, and a total loss of engine power. A factor in the accident was the pilot's failure to maintain airspeed while maneuvering for a field.
- [NTSB LAX01FA001](https://openairdocs.org/ntsb/LAX01FA001.md): Beech A36TC · San Juan Batist, CA · Accident · 4 fatal · Field investigation · Final report · Oct 2, 2000 · N36TV · Destroyed
  > the pilot's in-flight decision to continue flight into instrument weather conditions at an altitude that did not maintain an adequate terrain clearance, which resulted in a collision with terrain. Factors were a dark night, clouds, fog, mountainous terrain,…
- [NTSB FTW01LA004](https://openairdocs.org/ntsb/FTW01LA004.md): Bell 206-L1 · Jasper, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 2000 · N321CA · Substantial damage
  > The pilot's inadvertent VFR flight into instrument meteorological conditions, which resulted in his failure to maintain control of the helicopter. Factors were the fog and the pilot's lack of instrument flight experience.
- [NTSB LAX00FA354](https://openairdocs.org/ntsb/LAX00FA354.md): Piper PA-38 · San Luis Obispo, CA · Accident · 1 fatal · Field investigation · Final report · Oct 1, 2000 · N2493G · Destroyed
  > The pilot's failure to maintain clearance from terrain while turning to reverse course following inadvertent nighttime flight into instrument meteorological conditions. A factor in the accident was the pilot's lack of experience in nighttime operations.
- [NTSB ATL01IA001](https://openairdocs.org/ntsb/ATL01IA001.md): McDonnell Douglas MD-80 · Birmingham, AL · Incident · Minor injuries · Incident investigation · Final report · Oct 1, 2000 · N69826 · Minor damage
  > The failure of maintenace personnel to follow fleet campaign directive on how to install a certificate holder.
- [NTSB FTW00LA272](https://openairdocs.org/ntsb/FTW00LA272.md): Porterfield LP65 · Corsicana, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 2000 · N25563 · Substantial damage
  > The failure of the pilot to refuel the airplane, which resulted in fuel exhaustion. A factor was the pilot's inadequate preflight planning and the lack of suitable terrain for the forced landing.
- [NTSB CHI00LA311](https://openairdocs.org/ntsb/CHI00LA311.md): Cessna 150H · Michigan City, IN · Accident · No injuries · Limited investigation · Final report · Sep 30, 2000 · N50318 · Substantial damage
  > fuel contamination (water) and the pilot exceeding his landing field distance. Factors relating to this accident were the pilot inadequate preflight planning/preparation, his having to select an unsuitable landing area, the short landing area, and the marsh.
- [NTSB ATL00LA094](https://openairdocs.org/ntsb/ATL00LA094.md): Luscombe 8A · Homosassa, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 2000 · N2234K · Substantial damage
  > The pilot's inadvertent flight into instrument meteorological conditions and subsequently exhausting his fuel supply. Factors were his failure to obtain a weather briefing, the weather conditions which included clouds and obscuration, the residence and the…
- [NTSB SEA00LA194](https://openairdocs.org/ntsb/SEA00LA194.md): Cessna 172K · Burns, OR · Accident · No injuries · Limited investigation · Final report · Sep 28, 2000 · N84034 · Substantial damage
  > The separation of a portion of one propeller blade as a result of a fatigue crack that initiated at the site of foreign object damage to the blade.
- [NTSB IAD00LA085](https://openairdocs.org/ntsb/IAD00LA085.md): Cessna 182Q · Owingsville, KY · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 2000 · N94326 · Substantial damage
  > A loss of engine power due to water contamination of the fuel. Also causal in the accident was the pilot/owner's failure to repair the inoperative fuel cap.
- [NTSB MIA00LA271](https://openairdocs.org/ntsb/MIA00LA271.md): Boeing 777-223 · Miami, FL · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 2000 · N789AN · No damage
  > an in-flight encounter with turbulence.
- [NTSB SEA00LA185](https://openairdocs.org/ntsb/SEA00LA185.md): Rowe Pietenpol · Raymond, WA · Accident · Serious injuries · Limited investigation · Final report · Sep 23, 2000 · N5079R · Substantial damage
  > The pilot's failure to maintain an airspeed above power-off stall speed (Vso) while attempting a forced landing after a total loss of engine power, and his failure to move the fuel selector switch to the 'ON' position prior to takeoff. Factors include the…
- [NTSB MIA00LA269](https://openairdocs.org/ntsb/MIA00LA269.md): Piper PA-22-135 · Enochville, NC · Accident · Serious injuries · Limited investigation · Final report · Sep 23, 2000 · N3483A · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB DEN00LA176](https://openairdocs.org/ntsb/DEN00LA176.md): Bell 206B · Rawlins, WY · Accident · No injuries · Limited investigation · Final report · Sep 22, 2000 · N32FR · Substantial damage
  > The company dispatching, and the pilot initiating, flight into known adverse weather with an aircraft which did not have the required anti-ice equipment installed. A factor was snow conditions.
- [NTSB SEA00TA182](https://openairdocs.org/ntsb/SEA00TA182.md): Bell 206-L4 · Atlanta, ID · Accident · No injuries · Final report · Sep 21, 2000 · N3310 · Substantial damage
  > The pilot's failure to maintain clearance from an object. Trees and inadequate ground communications were a factor.
- [NTSB MIA00LA267](https://openairdocs.org/ntsb/MIA00LA267.md): Boeing 767-332ER · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Sep 20, 2000 · N172DZ · No damage
  > an in-flight encounter with turbulence in clouds during a normal descent, resulting in serious injuries.
- [NTSB ANC00FA128](https://openairdocs.org/ntsb/ANC00FA128.md): Cessna 207 · Aniak, AK · Accident · 1 fatal · Field investigation · Final report · Sep 20, 2000 · N42472 · Destroyed
  > The pilot's decision to initiate visual flight into dark night instrument meteorological conditions. Factors associated with the accident are a low ceiling, a dark night, the pilot's failure to follow regulatory procedures and directives, and his self-induced…
- [NTSB LAX00FA342](https://openairdocs.org/ntsb/LAX00FA342.md): Sikorsky/Orlando S-55 · Hoover Dam, AZ · Accident · Minor injuries · Field investigation · Final report · Sep 18, 2000 · N17754 · Substantial damage
  > **This report was modified on 2/23/2016. Please refer to the public docket for this accident for more information.** The failure of Papillon maintenance personnel to recognize the significance of the increasing metal in the oil analysis test results and the…
- [NTSB FTW00LA260](https://openairdocs.org/ntsb/FTW00LA260.md): Cessna 152 · Blanchard, LA · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 2000 · N6107Q · Substantial damage
  > The student pilot's failure to refuel, which resulted in fuel exhaustion. Factors were the dark night light conditions and lack of suitable terrain for the forced landing.
- [NTSB LAX00LA341](https://openairdocs.org/ntsb/LAX00LA341.md): Piper PA-28-161 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Sep 17, 2000 · N6303C · Substantial damage
  > An improper engine installation by other maintenance personnel that resulted in a fuel leak at the main fuel line fitting to the carburetor and subsequent fuel exhaustion during cruise flight.
- [NTSB ATL00LA092](https://openairdocs.org/ntsb/ATL00LA092.md): Bombardier CRJ · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 2000 · N853AS · No damage
  > The inadvertent flight into turbulent weather conditions.
- [NTSB DEN00LA170](https://openairdocs.org/ntsb/DEN00LA170.md): Piper PA-28-181 · Sheridan, WY · Accident · Serious injuries · Limited investigation · Final report · Sep 15, 2000 · N6130H · Substantial damage
  > The pilot's improper inflight decision to enter a canyon at an altitude insufficient to clear rising terrain. A factor was the aircraft's climb performance being exceeded due to the rising terrain.
- [NTSB DEN00LA167](https://openairdocs.org/ntsb/DEN00LA167.md): Cessna R172K · Aurora, CO · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 2000 · N1036V · Substantial damage
  > The unsuitable terrain for a forced landing. Contributing factors were the total loss of engine power due to the failure of the engine oil pump and the dark night light conditions.
- [NTSB ATL00LA088](https://openairdocs.org/ntsb/ATL00LA088.md): Cessna 188 · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Sep 10, 2000 · N9977G · Substantial damage
  > The failure of the number six-piston connecting rod that resulted in the total loss of engine power.
- [NTSB LAX00LA329](https://openairdocs.org/ntsb/LAX00LA329.md): Beech A36TC · Minden, NV · Accident · No injuries · Limited investigation · Final report · Sep 7, 2000 · N7110M · Substantial damage
  > the failure of the pilot to follow the pilot operating handbook procedures and to refuel the airplane.
- [NTSB LAX00LA328](https://openairdocs.org/ntsb/LAX00LA328.md): Hughes 269C · Rancho Murieta, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 7, 2000 · N50638 · Destroyed
  > The pilot's inadequate visual lookout during cruise, which subsequently led to a wire strike.
- [NTSB DEN00LA165](https://openairdocs.org/ntsb/DEN00LA165.md): Gulfstream G-IV · Sheridan, WY · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2000 · N1625 · No damage
  > the pilot's inadvertent flight into unforecasted turbulent weather conditions. A contributing factor was the turbulence.
- [NTSB NYC00FA248](https://openairdocs.org/ntsb/NYC00FA248.md): Piper PA-32R-301 · South Kingstown, RI · Accident · 3 fatal · Field investigation · Final report · Sep 3, 2000 · N8230G · Destroyed
  > The pilot's loss of control, and his subsequent overstress of the airplane after a vacuum system failure during flight in instrument meteorological conditions. Factors included the instrument meteorological conditions, a sheared coupling on the vacuum pump,…
- [NTSB LAX00LA356](https://openairdocs.org/ntsb/LAX00LA356.md): Cessna 177B · Hinkley, CA · Accident · No injuries · Limited investigation · Final report · Sep 2, 2000 · N30955 · Substantial damage
  > Loss of engine power due to fuel exhaustion when the pilot became lost and disoriented.
- [NTSB CHI00LA285](https://openairdocs.org/ntsb/CHI00LA285.md): Boeing Stearman B75N1 · Cape Girardeau, MO · Accident · No injuries · Limited investigation · Final report · Sep 2, 2000 · N66607 · Substantial damage
  > the pilot's improper decision to continue the flight when the fuel sight gauge indicated empty and the exhausted fuel supply. A factor was the corn crop.
- [NTSB NYC00LA246](https://openairdocs.org/ntsb/NYC00LA246.md): Cessna 310G · Seven Springs, PA · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 2000 · N8978Z · Substantial damage
  > The pilot's failure to maintain the manufacture's recommended safe single-engine airspeed, which resulted in a velocity-minimum-control roll to the right. A factor in the accident was the pilot's failure to maintain a proper glide path to his intended…

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

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

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