# 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 163 of 718 · 35,889 cases

## Cases, newest first

- [NTSB FTW01LA200](https://openairdocs.org/ntsb/FTW01LA200.md): Cessna 182A · Salado, TX · Accident · No injuries · Limited investigation · Final report · Aug 18, 2001 · N4795D · Substantial damage
  > A loss of engine power for undetermined reasons. A factor was the pilot's failure to maintain airspeed during the forced landing resulting in a stall. This report was modified on December 2, 2005.
- [NTSB DEN01LA149](https://openairdocs.org/ntsb/DEN01LA149.md): Piper PA-32RT-300 · Rock Springs, WY · Accident · No injuries · Limited investigation · Final report · Aug 18, 2001 · N3015L · Substantial damage
  > the mechanic's failure to perform an airworthiness directive, which resulted in the loss of engine oil through a partially failed oil filter converter plate gasket, and subsequent failure of a connecting rod during cruise flight. A contributing factor was the…
- [NTSB CHI01LA285](https://openairdocs.org/ntsb/CHI01LA285.md): Waters Avid Bandit · Northville, MI · Accident · Serious injuries · Limited investigation · Final report · Aug 18, 2001 · N62PT · Substantial damage
  > fuel starvation due to the pilot's improper fuel calculations. A factor was the concrete building.
- [NTSB CHI01LA284](https://openairdocs.org/ntsb/CHI01LA284.md): Cameron Balloons Shuttle 90 · Centralia, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 2001 · N8094S · Destroyed
  > The balloon envelope fire. A contributing factor was the flammability of the envelope.
- [NTSB FTW01LA184](https://openairdocs.org/ntsb/FTW01LA184.md): Rockwell S-2R · Fabens, TX · Accident · No injuries · Limited investigation · Final report · Aug 17, 2001 · N4890X · Substantial damage
  > the pilot's inadequate preflight resulting in loss of engine power due to fuel exhaustion. A contributing factor was the power line.
- [NTSB MIA01LA217](https://openairdocs.org/ntsb/MIA01LA217.md): Cessna 152 · Summerfield, FL · Accident · No injuries · Limited investigation · Final report · Aug 16, 2001 · N69120 · Substantial damage
  > The poor in-flight planning decision by the student pilot for his failure to turn around to avoid low ceilings resulting in a precautionary landing in a field. A contributing factor in the accident was the pilot's lack of total experience. A finding in the…
- [NTSB DEN01LA146](https://openairdocs.org/ntsb/DEN01LA146.md): Commander 114-B · Snowmass Villag, CO · Accident · Serious injuries · Limited investigation · Final report · Aug 15, 2001 · N994JT · Substantial damage
  > The pilot's failure to maintain altitude/clearance from the rising terrain for undetermined reasons. Contributing factors include high density altitude conditions, and trees.
- [NTSB NYC01IA211](https://openairdocs.org/ntsb/NYC01IA211.md): Cessna 210L · Bluefield, WV · Incident · No injuries · Incident investigation · Final report · Aug 13, 2001 · N732JT · Minor damage
  > Improper maintenance which resulted in the installation of an unserviceable piston assembly, and the subsequent catastrophic engine failure. Factors in this accident were the improper inspection by the piston supplier and the softening of the piston.
- [NTSB LAX01TA278](https://openairdocs.org/ntsb/LAX01TA278.md): Douglas DC-3C · Alturas, CA · Accident · Serious injuries · Final report · Aug 13, 2001 · N376AS · No damage
  > The inadvertent encounter with terrain induced turbulence. A factor was the high terrain.
- [NTSB ANC01FA106](https://openairdocs.org/ntsb/ANC01FA106.md): Maule M-6-235 · Kotzebue, AK · Accident · 1 fatal · Field investigation · Final report · Aug 13, 2001 · N56467 · Destroyed
  > The pilot's failure to maintain adequate clearance from an obstruction (antenna tower), and his continued flight into instrument meteorological conditions. Factors associated with the accident were low ceilings, and low visibility.
- [NTSB SEA01LA154](https://openairdocs.org/ntsb/SEA01LA154.md): Republic RC-3 · Chimacum, WA · Accident · No injuries · Limited investigation · Final report · Aug 12, 2001 · N6755K · Substantial damage
  > An internal ground in the right magneto followed by an internal ground evidenced by arcing in the left ignition coil unit, which led to failure of both the right magneto and the left coil ignition system respectively during cruise. Contributing factors were a…
- [NTSB DEN01LA145](https://openairdocs.org/ntsb/DEN01LA145.md): Eurocopter AS350 B-2 · Cody, WY · Accident · No injuries · Limited investigation · Final report · Aug 12, 2001 · C-FBTW · Substantial damage
  > the pilot's inadequate in-flight planning for an off site landing, which resulted in failure of the tail rotor drive shaft due to entanglement of his long-line in the drive shaft.
- [NTSB CHI01LA274](https://openairdocs.org/ntsb/CHI01LA274.md): Piper PA-28-180 · Union, IL · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 2001 · N8424W · Substantial damage
  > The total failure of the crankshaft as a result of fatigue and the unsuitable terrain encountered during the forced landing. Factors associated with the accident were the soft terrain on which the forced landing was made and the subsequent gear collapse.
- [NTSB IAD01FA096](https://openairdocs.org/ntsb/IAD01FA096.md): Piper PA-28RT-201 · Rohrersville, MD · Accident · 3 fatal · Field investigation · Final report · Aug 11, 2001 · N2869F · Destroyed
  > The pilot's continued VFR flight into obscured, mountanous terrain. Factors included the rising terrain and weather obscuration.
- [NTSB ANC01FA102](https://openairdocs.org/ntsb/ANC01FA102.md): Cessna 185 · Tyonek, AK · Accident · 1 fatal · Field investigation · Final report · Aug 10, 2001 · N4849C · Substantial damage
  > A loss of engine power during cruise flight due to fuel system contamination with water, and the pilot's inadequate preflight procedures. A factor in the accident was unsuitable terrain for a forced landing.
- [NTSB MIA01LA213](https://openairdocs.org/ntsb/MIA01LA213.md): Avid Mk-4 · Salisbury, NC · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2001 · N567SM · Substantial damage
  > , An aileron control system failure during climb due to an improper welded installation by the aircraft homebuilder, resulting in an inflight loss of lateral control, and an inflight collision with the terrain during an uncontrolled descent and landing.
- [NTSB MIA01LA212](https://openairdocs.org/ntsb/MIA01LA212.md): Piper PA-32-260 · Key West, FL · Accident · 2 fatal · Limited investigation · Final report · Aug 9, 2001 · N5569J · Substantial damage
  > The inadvertent disabling of the throttle in the idle position during a cockpit disturbance created when an armed hijacker forcibly attempted to cause the aircraft to fly to Cuba, resulting in a loss of controllability of power for sustainable flight and an…
- [NTSB LAX01LA275](https://openairdocs.org/ntsb/LAX01LA275.md): Boeing 737-500 · Klamath Falls, OR · Accident · Serious injuries · Limited investigation · Final report · Aug 9, 2001 · N512SW · No damage
  > An encounter with turbulence from a developing thunderstorm during cruise flight.
- [NTSB NYC01LA205](https://openairdocs.org/ntsb/NYC01LA205.md): Rans S-7 · Sydnorsville, VA · Accident · Serious injuries · Limited investigation · Final report · Aug 8, 2001 · N56RP · Substantial damage
  > A loss of engine power due to an engine over-temperature condition, which resulted in a forced landing and subsequent collision with trees.
- [NTSB IAD01LA095](https://openairdocs.org/ntsb/IAD01LA095.md): Hughes 269C · Lewiston, NY · Accident · No injuries · Limited investigation · Final report · Aug 7, 2001 · N3626B · Substantial damage
  > The pilot's failure to maintain rotor rpm during the simulated forced landing. Also causal in the accident was the failure of both pilots to recognize the total loss of engine power and the CFI's inadequate remedial actions. A factor in the accident was the…
- [NTSB LAX01FA271](https://openairdocs.org/ntsb/LAX01FA271.md): Cessna 336 · Palmdale, CA · Accident · Serious injuries · Field investigation · Final report · Aug 6, 2001 · N3838U · Substantial damage
  > The pilot's inadequate preflight inspection of the primer controls, resulting in excessive fuel flow, spark plug fouling, and loss of engine power in the aft engine.
- [NTSB CHI01LA267](https://openairdocs.org/ntsb/CHI01LA267.md): Piper PA-32-300 · Racine, WI · Accident · No injuries · Limited investigation · Final report · Aug 6, 2001 · N5481T · Substantial damage
  > The total loss of engine power during cruise flight due to the number 3 cylinder thru-studs fatigue fractures, and the thru-stud's low hardness as a result improper heat treatment of the thru-studs, and the unsuitable terrain encountered during the forced…
- [NTSB ANC01FA100](https://openairdocs.org/ntsb/ANC01FA100.md): Cessna 172S · Cooper Landing, AK · Accident · Serious injuries · Field investigation · Final report · Aug 6, 2001 · N813SP · Substantial damage
  > The pilot's inadequate remedial action to disconnect the autopilot during an uncommanded altitude deviation while in cruise flight. Factors in the accident were activation of the autopilot; the pilot's lack of familiarity with the airplane's autopilot system;…
- [NTSB CHI01LA265](https://openairdocs.org/ntsb/CHI01LA265.md): Cessna 172M · Milton, WI · Accident · No injuries · Limited investigation · Final report · Aug 5, 2001 · N13715 · Substantial damage
  > The unsuitable terrain for landing encountered by the pilot. Factors were the high vegetation and the loss of engine power for undetermined reasons.
- [NTSB CHI01LA259](https://openairdocs.org/ntsb/CHI01LA259.md): Bell 47G-2 · Blooming Prairi, MN · Accident · No injuries · Limited investigation · Final report · Aug 5, 2001 · N440TG · Substantial damage
  > The reported loss of engine power for undetermined reasons during a the cruise portion of a CFR part 137 observation, and the pilot not following the height/velocity charts data.
- [NTSB IAD01LA091](https://openairdocs.org/ntsb/IAD01LA091.md): Delbridge Rotorway Exec 162F · Carrollton, VA · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 2001 · N113RD · Substantial damage
  > pilot's inadequate fuel consumption calculations, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CHI01LA276](https://openairdocs.org/ntsb/CHI01LA276.md): Efaw Casutt Sport Racer · Shell Lake, WI · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 2001 · N333GE · Substantial damage
  > The pilot's inadequate preflight planning/preparation and the misjudged flare that resulted in a hard landing. A factor to the accident was the loss of engine power due to fuel exhaustion.
- [NTSB ANC01LA099](https://openairdocs.org/ntsb/ANC01LA099.md): Cessna 207 · Healy, AK · Accident · No injuries · Limited investigation · Final report · Aug 3, 2001 · N9794M · Substantial damage
  > The pilot's continued flight into adverse weather conditions after becoming lost/disoriented. Factors in the accident were rising terrain, a blind/box canyon, low clouds, and rain.
- [NTSB CHI01LA255](https://openairdocs.org/ntsb/CHI01LA255.md): Beech A36 · Sugar Grove, IL · Accident · No injuries · Limited investigation · Final report · Aug 1, 2001 · N136GR · Substantial damage
  > the inadequate maintenance inspection and the unsuitable terrain encountered by the pilot mechanic. The fuel system leak was a contributing factor.
- [NTSB ANC01FA095](https://openairdocs.org/ntsb/ANC01FA095.md): Cessna 172 · Eagle River, AK · Accident · Serious injuries · Field investigation · Final report · Aug 1, 2001 · N5312T · Substantial damage
  > The fatigue induced fracture of a connecting rod wrist pin, resulting in a complete loss of engine power.
- [NTSB NYC01LA194](https://openairdocs.org/ntsb/NYC01LA194.md): Piper PA-28-180 · New Milford, CT · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2001 · N55205 · Substantial damage
  > Separation of the number two connecting rod for reasons undetermined.
- [NTSB MIA01LA202](https://openairdocs.org/ntsb/MIA01LA202.md): Lancair 360 · St. Marys, GA · Accident · 2 fatal · Limited investigation · Final report · Jul 31, 2001 · N41EH · Destroyed
  > The flight instructor/pilot in command's continued flight into known adverse weather, which resulted in a loss of control, and uncontrolled descent, and the airplane crashing into the Atlantic Ocean.
- [NTSB DEN01FA133](https://openairdocs.org/ntsb/DEN01FA133.md): Wilson Glastar · Henefer, UT · Accident · 1 fatal · Field investigation · Final report · Jul 30, 2001 · N533WW · Destroyed
  > the pilot's failure to maintain aircraft control for an undetermined reason.
- [NTSB ANC01FA093](https://openairdocs.org/ntsb/ANC01FA093.md): Piper PA-32-300 · Haines, AK · Accident · 6 fatal · Field investigation · Final report · Jul 30, 2001 · N39586 · Destroyed
  > The pilot's continued flight into known adverse weather conditions, and his poor in-flight decision making. Factors associated with the accident were clouds and mountainous terrain. A finding is the pilot's use of FAA prohibited drugs.
- [NTSB MIA01LA197](https://openairdocs.org/ntsb/MIA01LA197.md): Cessna 182B · Headland, AL · Accident · No injuries · Limited investigation · Final report · Jul 28, 2001 · N7202E · Substantial damage
  > The pilot's improper decision to perform a go-around while on short final to an available runway following loss of engine power for undetermined reasons when engine power was regained momentarily, which resulted in an impact with terrain while maneuvering at…
- [NTSB IAD01FA086](https://openairdocs.org/ntsb/IAD01FA086.md): Aeronca S-65-CA · Esperance, NY · Accident · 2 fatal · Field investigation · Final report · Jul 28, 2001 · N1049Y · Destroyed
  > The pilot's inadequate decision and his failure to maintain obstacle clearance. Contributing factors are a transmission wire and the pilot's intentional low pass.
- [NTSB FTW01FA171](https://openairdocs.org/ntsb/FTW01FA171.md): Cessna 205 · De Queen, AR · Accident · 4 fatal · Field investigation · Final report · Jul 28, 2001 · N8324Z · Destroyed
  > the pilot's VFR flight into IMC, which resulted in spatial disorientation and a loss of aircraft control. A contributing factor to the accident was the pilot's lack of total instrument flight time.
- [NTSB DEN01LA130](https://openairdocs.org/ntsb/DEN01LA130.md): Cessna 172RG · Gunnison, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 2001 · N401TA · Destroyed
  > the pilot's failure to attain the proper climb rate, and his improper inflight planning/decision to attempt to cross mountainous terrain at an inadequate altitude. Contributing factors were the downdraft and the pilot's total lack of experience in mountain…
- [NTSB NYC01LA192](https://openairdocs.org/ntsb/NYC01LA192.md): Montgomery Teenie Two · Cambridge, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 27, 2001 · N6790 · Substantial damage
  > the pilot's improper maintenance which resulted in the engine retarding to idle, and subsequent forced landing. A factor was the tall grass in the field where the forced landing was performed.
- [NTSB NYC01LA187](https://openairdocs.org/ntsb/NYC01LA187.md): Piper PA-32R-301T · Sandy Hook, NJ · Accident · No injuries · Limited investigation · Final report · Jul 25, 2001 · N4159V · Substantial damage
  > A total loss of engine power for undetermined reasons.
- [NTSB MIA01TA194](https://openairdocs.org/ntsb/MIA01TA194.md): Bell 206B-III · Jacksonville, FL · Accident · Minor injuries · Final report · Jul 25, 2001 · N313JP · Destroyed
  > the pilot's failure to recognize and correct for unanticipated right yaw/loss of tail rotor effectiveness (LTE) during an approach to hover at a low altitude, which resulted in a loss of control and the helicopter descending and colliding with a house and the…
- [NTSB CHI01LA245](https://openairdocs.org/ntsb/CHI01LA245.md): McDonnell Douglas DC-9-51 · Detroit, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 25, 2001 · N780NC · No damage
  > The passenger (an off duty flight attendant) disregarded the flight crews warning regarding turbulence along with the seat belt sign which had been turned on.
- [NTSB SEA01TA143](https://openairdocs.org/ntsb/SEA01TA143.md): Boeing Helicopters Div. H500D · Union Gap, WA · Accident · No injuries · Final report · Jul 24, 2001 · N8964T · Substantial damage
  > The complete loss of engine power at cruise for undetermined reasons. Factors include a landing area that was restricted/confined due to adjacent trees, and an intentional abrupt flare resulting in a hard landing.
- [NTSB CHI01LA237](https://openairdocs.org/ntsb/CHI01LA237.md): Veith Kolb Sling Shot · Goodview, MN · Accident · 1 fatal · Limited investigation · Final report · Jul 24, 2001 · N56CV · Substantial damage
  > The loss of engine power due to fuel starvation caused by a blocked, unsecured, fuel vent line. Contributing to the accident was the pilot's failure to maintain adequate airspeed during the forced landing which resulted in an inadvertent stall at a low…
- [NTSB ATL01LA092](https://openairdocs.org/ntsb/ATL01LA092.md): Kolb Twin Star Mark III · Edgewater, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 2001 · N703BL · Destroyed
  > The loss of flight control in-flight for undetermined reasons, that resulted in the uncontrolled collision with the ground.
- [NTSB ATL01LA091](https://openairdocs.org/ntsb/ATL01LA091.md): Mitchell T-10 · Ashland City, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 24, 2001 · N3221X · Substantial damage
  > The restricted movement of the rudder cable, resulting in a loss of control and collision with trees.
- [NTSB NYC01LA184](https://openairdocs.org/ntsb/NYC01LA184.md): Pohl Lancair IV-P · Fryeburg, ME · Accident · No injuries · Limited investigation · Final report · Jul 23, 2001 · N488SD · Substantial damage
  > A partial blockage of the air intake system, due to the pilot's failure to ensure the engine compartment was clear of paper towels after a maintenance inspection.
- [NTSB CHI01FA231](https://openairdocs.org/ntsb/CHI01FA231.md): World Helicopters 47D1 · Ballard, MO · Accident · 2 fatal · Field investigation · Final report · Jul 22, 2001 · N17301 · Destroyed
  > The pilot's improper preflight planning which resulted in fuel exhaustion, and the pilot's subsequent improper autorotation.
- [NTSB SEA01LA138](https://openairdocs.org/ntsb/SEA01LA138.md): Cessna 120 · Troutdale, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 21, 2001 · N90077 · Destroyed
  > the pilot's inadvertent visual flight rules ( VFR) flight into instrument meteorological conditions (IMC) during cruise flight. Factors include his attention being diverted to the indications presented by his Global Positioning System (GPS), and low ceiling…
- [NTSB MIA01FA193](https://openairdocs.org/ntsb/MIA01FA193.md): Piper PA-46-350P · Black Mountain, NC · Accident · 1 fatal · Field investigation · Final report · Jul 21, 2001 · N396PM · Destroyed
  > The pilot's continued VFR flight into IMC conditions resulting in the airplane colliding with mountainous terrain.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.