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

## Cases, newest first

- [NTSB DFW06LA040](https://openairdocs.org/ntsb/DFW06LA040.md): Bellanca 17-30A · Columbus, TX · Accident · Serious injuries · Limited investigation · Final report · Dec 16, 2005 · N78SV · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX06LA058](https://openairdocs.org/ntsb/LAX06LA058.md): Cessna 177RG · Dixon, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 15, 2005 · N8040G · Substantial damage
  > the pilot's intentional flight at low altitude and failure to maintain obstacle clearance with a high tension static line. The glare from the setting sun was a factor.
- [NTSB DEN06FA023](https://openairdocs.org/ntsb/DEN06FA023.md): Cessna 172S · Pinon, NM · Accident · 1 fatal · Field investigation · Final report · Dec 14, 2005 · N1257Z · Destroyed
  > the pilot's failure to maintain control of the airplane for undetermined reasons.
- [NTSB LAX06FA055](https://openairdocs.org/ntsb/LAX06FA055.md): Beech A23 · Mammoth Lakes, CA · Accident · 2 fatal · Field investigation · Final report · Dec 12, 2005 · N3590R · Destroyed
  > a loss of engine power for undetermined reasons, and, the failure of the pilot to maintain an adequate airspeed while maneuvering following the loss of power, which resulted in a stall/spin.
- [NTSB CHI06FA043](https://openairdocs.org/ntsb/CHI06FA043.md): Cirrus Design SR22 · Arco, MN · Accident · 3 fatal · Field investigation · Final report · Dec 11, 2005 · N621PH · Destroyed
  > The pilot's inadvertent cruise flight into instrument meteorological conditions, and his failure to maintain control of the aircraft after experiencing spatial disorientation. Factors associated with the accident are the pilot's improper planning/decision…
- [NTSB LAX06FA054](https://openairdocs.org/ntsb/LAX06FA054.md): Piper PA-32RT-300 · Kingsburg, CA · Accident · 2 fatal · Field investigation · Final report · Dec 10, 2005 · N3039B · Destroyed
  > The pilot's in-flight decision to continue VFR flight into instrument meteorological conditions during descent, which resulted in an in-flight collision with trees and terrain. Fog, low ceiling, and obscuration were factors.
- [NTSB MIA06LA026](https://openairdocs.org/ntsb/MIA06LA026.md): Cessna 152 · Key Largo, FL · Accident · No injuries · Limited investigation · Final report · Dec 8, 2005 · N49815 · Substantial damage
  > A loss of engine power for undetermined reasons that resulted in the airplane being ditched into the ocean. Contributing to the accident was the pilot's operation of an airplane with known deficiencies due to it having sat in flooded waters.
- [NTSB LAX06CA081](https://openairdocs.org/ntsb/LAX06CA081.md): Burkhart Grob G 103 Twin II · Llano, CA · Accident · No injuries · Data collection · Final report · Dec 3, 2005 · N4601M · Substantial damage
  > The flight's encounter with downdrafts. A contributing factor was the unsuitable vegetation-covered mountainous terrain.
- [NTSB LAX06CA050](https://openairdocs.org/ntsb/LAX06CA050.md): Mooney M20A · China Lake, CA · Accident · Minor injuries · Data collection · Final report · Dec 2, 2005 · N6004X · Substantial damage
  > fuel exhaustion due to the pilot's inadequate in-flight planning and fuel consumption calculations.
- [NTSB DCA06IA007](https://openairdocs.org/ntsb/DCA06IA007.md): Raytheon Corporate Jets Beechjet 400 · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Nov 28, 2005 · N691TA · Minor damage
  > The dual-engine flameout due to high-altitude ice crystals that had accreted onto the JT15D-5 engines' compressor vanes and were ingested into the engine when the pilots retarded the power levers, resulting in compressor surges and rapid reduction in fuel…
- [NTSB CHI06FA037](https://openairdocs.org/ntsb/CHI06FA037.md): Piper PA-28-140 · Atlanta, NE · Accident · 3 fatal · Field investigation · Final report · Nov 27, 2005 · N5596F · Destroyed
  > The non-instrument rated private pilot not maintaining clearance from the marked tower and his continued flight into adverse weather during cruise flight. Factors were the marked tower and the low ceilings present at the accident.
- [NTSB NYC06LA038](https://openairdocs.org/ntsb/NYC06LA038.md): Piper PA-24-180 · Lincoln Park, NJ · Accident · Serious injuries · Limited investigation · Final report · Nov 26, 2005 · N6858P · Substantial damage
  > The improper installation of the helicoil by the non-certificated mechanic, and the inadequate inspection of the installation by the certificated mechanic.
- [NTSB MIA06FA024](https://openairdocs.org/ntsb/MIA06FA024.md): Piper PA-32-300 · Mims, FL · Accident · 2 fatal · Field investigation · Final report · Nov 23, 2005 · N666DE · Substantial damage
  > The loss of engine power due to improper installation of the #2 cylinder by maintenance personnel, which resulted in the separation of the cylinder as a result of fatigue cracking of the cylinder to crankcase fasteners. A contributing factor was the lack of…
- [NTSB DFW06CA033](https://openairdocs.org/ntsb/DFW06CA033.md): Piper PA-23-250 · Bixby, OK · Accident · No injuries · Data collection · Final report · Nov 23, 2005 · N859DA · Substantial damage
  > The loss of engine power due to water contamination and corrosion in both gascolators due to improper maintenance. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI06CA040](https://openairdocs.org/ntsb/CHI06CA040.md): Piper PA-28-180 · Marshall, MO · Accident · Minor injuries · Data collection · Final report · Nov 23, 2005 · N3619R · Substantial damage
  > An in-flight loss of engine power in descent due to fuel exhaustion, and the pilot's inaccurate preflight planning. Contributing to the accident was the unsuitable terrain the pilot encountered and the night conditions.
- [NTSB LAX06LA044](https://openairdocs.org/ntsb/LAX06LA044.md): Piper PA-24-250 · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 21, 2005 · N7466P · Substantial damage
  > the separation of the mixture cable at the carburetor control arm, which resulted in a loss of power, and maintenance personnel's inadequate inspection of the airplane during the last annual inspection.
- [NTSB LAX06FA043](https://openairdocs.org/ntsb/LAX06FA043.md): Cessna T210N · Dana Point, CA · Accident · 4 fatal · Field investigation · Final report · Nov 19, 2005 · N546BC · Destroyed
  > The pilot's inability to maintain aircraft control, which resulted in a loss of airspeed and a stall/spin. The inability of the pilot to maintain control of the airplane was likely due to an incapacitating cardiac event.
- [NTSB CHI06TA033](https://openairdocs.org/ntsb/CHI06TA033.md): Schweizer 269C · Manhattan, KS · Accident · No injuries · Final report · Nov 18, 2005 · N400PD · Substantial damage
  > The binding of the main rotor blade's tachometer cable during cruise flight resulting in an observed split tachometer indication/aural alarm and perceived mechanical emergency and the unsuitable terrain the pilot encountered during the emergency landing. A…
- [NTSB MIA06LA019](https://openairdocs.org/ntsb/MIA06LA019.md): Piper PA-28R-180 · Heathrow, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 2005 · N7453J · Substantial damage
  > A partial loss of engine power due to undetermined reasons resulting in a forced landing in a residential area.
- [NTSB DEN06LA014](https://openairdocs.org/ntsb/DEN06LA014.md): Cessna 172L · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Nov 16, 2005 · N2870Q · Substantial damage
  > the loss of engine power for reasons undetermined. Contributing to the accident was the dark night and lack of suitable terrain for a forced landing.
- [NTSB CHI06LA036](https://openairdocs.org/ntsb/CHI06LA036.md): Cessna T310R · Fergus Falls, MN · Accident · No injuries · Limited investigation · Final report · Nov 15, 2005 · N5094C · Substantial damage
  > The presence of wing ice during landing. Contributing factors were the icing conditions and flight into known adverse weather by the pilot.
- [NTSB ATL06CA015](https://openairdocs.org/ntsb/ATL06CA015.md): Piper PA-32-260 · Bryson City, NC · Accident · Minor injuries · Data collection · Final report · Nov 14, 2005 · N1186X · Substantial damage
  > The loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat.
- [NTSB LAX06CA033](https://openairdocs.org/ntsb/LAX06CA033.md): Rotorway 162F · Chandler, AZ · Accident · No injuries · Data collection · Final report · Nov 13, 2005 · N321JN · Substantial damage
  > a loss of engine power due to fuel contamination (rust, water) as a result of the pilot's inadequate preflight planning preparation.
- [NTSB CHI06LA031](https://openairdocs.org/ntsb/CHI06LA031.md): Piper PA-28-181 · Milwaukee, WI · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 2005 · N2241P · Substantial damage
  > The loss of engine power due to fuel starvation as a result of the pilot's fuel mismanagement. Factors to the accident included the pilot's impairment due to alcohol, the FAA's inadequate oversight when it issued the pilot a second class medical certificate,…
- [NTSB LAX06CA035](https://openairdocs.org/ntsb/LAX06CA035.md): Vans RV-4 · Apple Valley, CA · Accident · No injuries · Data collection · Final report · Nov 12, 2005 · N14GK · Substantial damage
  > a partial loss of engine power for undetermined reasons.
- [NTSB LAX06LA030](https://openairdocs.org/ntsb/LAX06LA030.md): Bell 47D1 · Rancho Murieta, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 10, 2005 · N16356 · Substantial damage
  > a separation of the tail rotor assembly due to the reverse bending fatigue fracture of a tail rotor pitch change link bolt, resulting in a loss of control of the helicopter, and a hard landing during the uncontrolled descent.
- [NTSB LAX06FA031](https://openairdocs.org/ntsb/LAX06FA031.md): Beech F33A · Geyserville, CA · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2005 · N9204Q · Destroyed
  > the pilot's failure to maintain an adequate terrain clearance altitude profile during the descent that resulted in controlled flight into terrain.
- [NTSB CHI06FA030](https://openairdocs.org/ntsb/CHI06FA030.md): Piper PA-23-160 · Bloomington, IL · Accident · 1 fatal · Field investigation · Final report · Nov 10, 2005 · N4319P · Substantial damage
  > The aircraft control not possible by the pilot during a visual approach to the runway due to the physical impairment of the pilot.
- [NTSB NYC06FA027](https://openairdocs.org/ntsb/NYC06FA027.md): Embraer 110P1 · Manchester, NH · Accident · Serious injuries · Field investigation · Final report · Nov 8, 2005 · N7801Q · Destroyed
  > The pilot’s misapplication of flight controls following an engine failure. Contributing to the accident was the failure of the sun gear, which resulted in the loss of engine power. Contributing to the sun gear failure were the engine manufacturer’s…
- [NTSB DEN06FA013](https://openairdocs.org/ntsb/DEN06FA013.md): Beech A36 · Datil, NM · Accident · 1 fatal · Field investigation · Final report · Nov 8, 2005 · N1548Y · Destroyed
  > the pilot's loss of control during flight as a result of incapacitation due to atherosclerotic cardiovascular disease.
- [NTSB CHI06FA026](https://openairdocs.org/ntsb/CHI06FA026.md): Piper PA-31-350 · Ankeny, IA · Accident · 2 fatal · Field investigation · Final report · Nov 8, 2005 · N27177 · Destroyed
  > The pilot's failure to preflight the airplane, the pilot's improper in-flight decision not to land the airplane on the runway when he had the opportunity, and the inadvertent stall when the pilot allowed the airspeed to get too low. Factors that contributed…
- [NTSB LAX06CA026](https://openairdocs.org/ntsb/LAX06CA026.md): Piper PA-28-161 · Payson, AZ · Accident · No injuries · Data collection · Final report · Nov 7, 2005 · N2111P · Substantial damage
  > a loss of engine power due to fuel exhaustion, which was caused by the pilot's inadequate preflight and in-flight planning, his inadequate fuel consumption calculations, and his failure to divert to an alternate airport before the fuel situation became…
- [NTSB MIA06LA015](https://openairdocs.org/ntsb/MIA06LA015.md): Piper PA-28R-180 · Opa-Locka, FL · Accident · No injuries · Limited investigation · Final report · Nov 6, 2005 · N4652J · Substantial damage
  > The failure of the pilot-in-command/CFI to maintain control of the airplane and his inattentiveness to the altitude while troubleshooting the landing gear system resulting in the in-flight collision with terrain.
- [NTSB DFW06CA022](https://openairdocs.org/ntsb/DFW06CA022.md): Piper PA38 · Decatur, TX · Accident · No injuries · Data collection · Final report · Nov 6, 2005 · N2593P · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI06CA028](https://openairdocs.org/ntsb/CHI06CA028.md): Cessna 182 · Butler, MO · Accident · No injuries · Data collection · Final report · Nov 6, 2005 · N5784B · Substantial damage
  > The damage to the horizontal stabilizer was a result of the inadvertent deployment of the skydiver's reserve parachute.
- [NTSB NYC06FA025](https://openairdocs.org/ntsb/NYC06FA025.md): Cessna 172A · Pohatcong, NJ · Accident · 1 fatal · Field investigation · Final report · Nov 5, 2005 · N7467T · 2 aircraft · Substantial damage
  > The inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.
- [NTSB SEA06CA018](https://openairdocs.org/ntsb/SEA06CA018.md): Piper PA-24-250 · Tacoma, WA · Accident · No injuries · Data collection · Final report · Nov 3, 2005 · N1959P · Substantial damage
  > The collapse of the landing gear due to the pilot's failure to use the emergency gear extension system after his aircraft experienced a complete loss of electrical power. Factors include the malfunction of the voltage regulating system, which lead to the…
- [NTSB LAX06LA024](https://openairdocs.org/ntsb/LAX06LA024.md): Schleicher ASH 26 E · Sparks, NV · Accident · Serious injuries · Limited investigation · Final report · Nov 2, 2005 · N26XL · Destroyed
  > The pilot's inadvertent flight into instrument meteorological conditions which resulted in a subsequent loss of control and an in-flight breakup. A contributing factor was the spool up delay for the emergency turn and bank indicator.
- [NTSB CHI06CA025](https://openairdocs.org/ntsb/CHI06CA025.md): Piper PA22-150 · Canton, IL · Accident · Minor injuries · Data collection · Final report · Nov 2, 2005 · N9664D · Destroyed
  > The fire for undetermined reasons.
- [NTSB LAX06LA023](https://openairdocs.org/ntsb/LAX06LA023.md): Piper PA-28-161 · Lodi, CA · Accident · No injuries · Limited investigation · Final report · Oct 31, 2005 · N83785 · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was the trees.
- [NTSB CHI06LA021](https://openairdocs.org/ntsb/CHI06LA021.md): Enstrom F-28A · Portland, IN · Accident · No injuries · Limited investigation · Final report · Oct 30, 2005 · N266Q · Substantial damage
  > The pilot's decision to operate the helicopter with a known engine deficiency, the loss of engine power due to the connecting rod failure, and the pilot's failure to maintain directional control during landing. A factor to the accident was the corn crop and…
- [NTSB NYC06FA015](https://openairdocs.org/ntsb/NYC06FA015.md): Cessna 411 · East Hampton, NY · Accident · 1 fatal · Field investigation · Final report · Oct 23, 2005 · N7345U · Destroyed
  > The pilot's failure to maintain airspeed, while maneuvering with the left engine inoperative. Contributing to the accident were the failure of the left engine, and the pilot's lack of multiengine certification.
- [NTSB DFW06CA013](https://openairdocs.org/ntsb/DFW06CA013.md): Hiller UH-12E · Pasadena, TX · Accident · Serious injuries · Data collection · Final report · Oct 23, 2005 · N909BC · Substantial damage
  > The pilot's inadequate fuel management, which resulted in fuel exhaustion and a loss of engine power. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB DEN06FA010](https://openairdocs.org/ntsb/DEN06FA010.md): Lancair LC-40-550FG · Steamboat Spgns, CO · Accident · 2 fatal · Field investigation · Final report · Oct 23, 2005 · N101HK · Destroyed
  > the pilot's failure to maintain altitude/clearance from terrain. Contributing factors include the pilot's lack of recent experience, the pilot's improper in-flight planning and decision making, the dark night and the mountainous terrain.
- [NTSB NYC06LA016](https://openairdocs.org/ntsb/NYC06LA016.md): Boeing 737-832 · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Limited investigation · Final report · Oct 22, 2005 · N378DA · No damage
  > An encounter with turbulence during cruise flight.
- [NTSB NYC06CA017](https://openairdocs.org/ntsb/NYC06CA017.md): Cessna 150L · Shelburne, VT · Accident · No injuries · Data collection · Final report · Oct 21, 2005 · N1693Q · Substantial damage
  > The pilot's inadequate preflight planning, which resulted in fuel exhaustion and a total loss of engine power.
- [NTSB NYC06CA012](https://openairdocs.org/ntsb/NYC06CA012.md): Weber Glastar · Summersville, WV · Accident · No injuries · Data collection · Final report · Oct 19, 2005 · N722W · Substantial damage
  > a loss of engine power due to a stuck carburetor float needle.
- [NTSB MIA06FA008](https://openairdocs.org/ntsb/MIA06FA008.md): Cessna P337H · Port St. Lucie, FL · Accident · 1 fatal · Field investigation · Final report · Oct 19, 2005 · N5HU · Destroyed
  > The pilot's continued flight into an area of known convective weather, resulting in a loss of aircraft control. Contributing factors were the failure of the FAA center controller to provide information on depicted severe weather to the pilot and the…
- [NTSB LAX06LA015](https://openairdocs.org/ntsb/LAX06LA015.md): Hughes 369D · Avalon, CA · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 2005 · N268ST · Substantial damage
  > the pilot's failure to maintain an adequate visual lookout and obstacle clearance altitude, which resulted in a collision with power lines. Factors in the accident were the position of the sun relative to the helicopter's flight path, which lessoned the…
- [NTSB DFW06LA010](https://openairdocs.org/ntsb/DFW06LA010.md): Cessna 208 · Round Rock, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 2005 · N978FE · Substantial damage
  > The loss of engine power due to the failure of the engine-driven fuel pump. A contributing factor was the inadequate inspection of the engine driven fuel pump.

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

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

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