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

## Cases, newest first

- [NTSB LAX01LA117](https://openairdocs.org/ntsb/LAX01LA117.md): Piper PA-23-160 · Anza, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 2001 · N333PE · Substantial damage
  > The pilot's failure to maintain control of the airplane following the opening of the cockpit/cabin door. The door came open because of improperly installed upholstery, which resulted in the inability to lock the door.
- [NTSB IAD01LA037](https://openairdocs.org/ntsb/IAD01LA037.md): Cessna 150 · Huntington, WV · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 2001 · N6584F · Substantial damage
  > The pilot's inadequate preflight inspection, which resulted in residual fuel contamination and a subsequent engine failure. Factors included corroded fuel filler necks and rain the previous evening.
- [NTSB DEN01FA070](https://openairdocs.org/ntsb/DEN01FA070.md): Beech A36 · Jackson Hole, WY · Accident · 4 fatal · Field investigation · Final report · Mar 12, 2001 · N1080A · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions which resulted in an inflight collision with terrain during cruise flight. Factors were the pilot's inadequate preflight planning in that he failed to familiarize himself with the…
- [NTSB MIA01LA097](https://openairdocs.org/ntsb/MIA01LA097.md): Enstrom F-28C · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Mar 11, 2001 · N5687H · Destroyed
  > a fire due to a broken and separated turbocharger exhaust which allowed hot exhaust to ignite the engine shroud.
- [NTSB DEN01LA067](https://openairdocs.org/ntsb/DEN01LA067.md): Robinson R22 Beta · Buffalo, WY · Accident · No injuries · Limited investigation · Final report · Mar 11, 2001 · N144MB · Substantial damage
  > failure of the rotor drive system clutch assembly which rendered the aircraft uncontrollable.
- [NTSB DEN01FA066](https://openairdocs.org/ntsb/DEN01FA066.md): Cessna T210L · Howard, CO · Accident · 1 fatal · Field investigation · Final report · Mar 10, 2001 · N222ED · Destroyed
  > the pilot's continuation of a VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance. Contributing factors were his failure to obtain a preflight weather briefing, and his failure to obtain any in-flight…
- [NTSB CHI01LA101](https://openairdocs.org/ntsb/CHI01LA101.md): Cessna P206 · Derby, KS · Accident · No injuries · Limited investigation · Final report · Mar 10, 2001 · N2507X · Substantial damage
  > The misjudged in-flight planning the pilot had for the forced landing. Factors were the induction air ducting separation, the pilot not coordinating his emergency procedure with airfield traffic, and the trees.
- [NTSB CHI01FA100](https://openairdocs.org/ntsb/CHI01FA100.md): Piper PA-28-180 · Erhard, MN · Accident · 1 fatal · Field investigation · Final report · Mar 10, 2001 · N55893 · Destroyed
  > The pilot's failure to maintain aircraft control. Factors relating to the accident were the pilot's encounter with known adverse weather conditions, the low ceiling, the pilot disregarding the weather observation information obtained prior to the flight, and…
- [NTSB LAX01FA113](https://openairdocs.org/ntsb/LAX01FA113.md): Piper PA-32R-300 · Essex, CA · Accident · 2 fatal · Field investigation · Final report · Mar 9, 2001 · N1965H · Destroyed
  > Rupture of the fuel injection flow divider diaphragm due to improper manufacture of the raw material stock from which the diaphragm was fabricated. The diaphragm tear resulted in complete engine power loss, which required the pilot to descend into an…
- [NTSB LAX01FA112](https://openairdocs.org/ntsb/LAX01FA112.md): North American Navion · Santa Ysabel, CA · Accident · 1 fatal · Field investigation · Final report · Mar 9, 2001 · N91445 · Destroyed
  > the pilot's continued VFR flight into IFR conditions, which resulted in a loss of control due to spatial disorientation.
- [NTSB DEN01LA065](https://openairdocs.org/ntsb/DEN01LA065.md): Erco 415-C · Ivins, UT · Accident · No injuries · Limited investigation · Final report · Mar 9, 2001 · N1121J · Substantial damage
  > The unsuitable terrain on which to make a forced landing. A contributing factors was the carburetor icing conditions.
- [NTSB SEA01LA063](https://openairdocs.org/ntsb/SEA01LA063.md): Piper PA-24 · Saint Helens, OR · Accident · No injuries · Limited investigation · Final report · Mar 8, 2001 · N6337P · Substantial damage
  > the pilot's improper use of the carburetor heat while attempting to determine if there was ice accumulating in the carburetor throat. Factors include flight in conditions conducive to carburetor icing, and a fence running across the field in which the forced…
- [NTSB SEA01FA060](https://openairdocs.org/ntsb/SEA01FA060.md): Cessna U206G · Mica, WA · Accident · 1 fatal · Field investigation · Final report · Mar 8, 2001 · CGISV · Substantial damage
  > The pilot's continued flight into instrument meteorological conditions. Contributing factors were fog, low ceilings, drizzle/mist, rising terrain, and the non-availability of a functioning transponder.
- [NTSB LAX01LA110](https://openairdocs.org/ntsb/LAX01LA110.md): Jones RV-6A · Inyokern, CA · Accident · 2 fatal · Limited investigation · Final report · Mar 7, 2001 · N46KA · Substantial damage
  > the in-flight collision with mountainous terrain during a forced landing following a loss of engine power resulting from the pilot's inadequate weather evaluation, continued flight into icing weather conditions, his delay in carburetor heat use, and his delay…
- [NTSB CHI01LA099](https://openairdocs.org/ntsb/CHI01LA099.md): Grumman American AA-1C · Dekalb, IL · Accident · Minor injuries · Limited investigation · Final report · Mar 7, 2001 · N9886U · Substantial damage
  > Fuel starvation, the pilot not switching the fuel selector to the other fuel tank, and the pilot not maintaining control of the airplane through the forced landing attempt. Factors relating to this accident were the pilot's inadequate fuel management, the…
- [NTSB SEA01LA057](https://openairdocs.org/ntsb/SEA01LA057.md): Cassutt II · Moses Lake, WA · Accident · No injuries · Limited investigation · Final report · Mar 4, 2001 · N1431 · Substantial damage
  > Failure of a wrist pin plug in the engine, resulting in partial blockage of the engine lubrication system and partial failure of the engine connecting rod bearings; and the pilot's subsequent failure to maintain adequate airspeed during a forced landing…
- [NTSB LAX01LA108](https://openairdocs.org/ntsb/LAX01LA108.md): Harlow Lancair ES · Marana, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 4, 2001 · N350N · Substantial damage
  > Failure of the propeller reduction drive unit which resulted in drive belt and pulley failure and a subsequent loss of thrust requiring an emergency landing on soft terrain. The reason for the bearing and/or belt failure was not determined. A factor was the…
- [NTSB LAX01LA107](https://openairdocs.org/ntsb/LAX01LA107.md): Christian Rans S-12 · Ramona, CA · Accident · No injuries · Limited investigation · Final report · Mar 3, 2001 · N12FC · Substantial damage
  > The in-flight failure of the engine crankshaft for undetermined reasons.
- [NTSB ANC01LA039](https://openairdocs.org/ntsb/ANC01LA039.md): Helio H-295 · Clear, AK · Accident · No injuries · Limited investigation · Final report · Mar 3, 2001 · N42DC · Substantial damage
  > The shifting of engine connecting rod bearings, and the fracture of an engine connecting rod.
- [NTSB FTW01LA074](https://openairdocs.org/ntsb/FTW01LA074.md): Cessna 182P · Tuttle, OK · Accident · No injuries · Limited investigation · Final report · Mar 2, 2001 · N4721K · Substantial damage
  > fuel exhaustion due to a loose fuel cap as a result of the pilot's inadequate preflight. A contributory factor was the lack of suitable terrain for the forced landing.
- [NTSB IAD01LA035](https://openairdocs.org/ntsb/IAD01LA035.md): Cessna 210 · Newark, OH · Accident · No injuries · Limited investigation · Final report · Mar 1, 2001 · N3738Y · Substantial damage
  > Improper maintenance, which resulted in the failure of the instrument panel shock mounts.
- [NTSB DEN01LA059](https://openairdocs.org/ntsb/DEN01LA059.md): Meshko Zenair CH-701 · Hudson, CO · Accident · Serious injuries · Limited investigation · Final report · Mar 1, 2001 · N4386W · Substantial damage
  > the loss of engine power as a result of detonation. A contributing factor was the unsuitable terrain on which to make a forced landing.
- [NTSB DEN01FA058](https://openairdocs.org/ntsb/DEN01FA058.md): Bell 412SP · Grand Junction, CO · Accident · 1 fatal · Field investigation · Final report · Feb 28, 2001 · N412SM · Destroyed
  > the pilot's failure to maintain rotor speed during an intentional autorotation, which resulted in a loss of control.
- [NTSB LAX01LA105](https://openairdocs.org/ntsb/LAX01LA105.md): Embraer EMB-120 · Monterey, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 26, 2001 · N288SW · No damage
  > moisture contamination of the elevator trim actuators, which allowed the units to freeze at altitude resulting in an abrupt pitch change when the units thawed at lower altitudes.
- [NTSB DEN01LA055](https://openairdocs.org/ntsb/DEN01LA055.md): Cessna 172F · Larkspur, CO · Accident · No injuries · Limited investigation · Final report · Feb 26, 2001 · N8389U · Substantial damage
  > the flight instructor inadvertently stalling the airplane during a forced landing. Contributing factors were fuel exhaustion due to inadvertent opening of the fuel drain, lack of familiarity with the airplane, inadequate supervision of the flight, and the…
- [NTSB DEN01FA056](https://openairdocs.org/ntsb/DEN01FA056.md): Beech V35B · Green River, UT · Accident · 1 fatal · Field investigation · Final report · Feb 26, 2001 · N4637M · Destroyed
  > the pilot's failure to maintain aircraft control as a result of incapacitation (from hypoxia) due to the in-flight decision to fly at altitudes where oxygen is required, without oxygen available.
- [NTSB NYC01LA080](https://openairdocs.org/ntsb/NYC01LA080.md): Cessna 172I · Suffolk, VA · Accident · No injuries · Limited investigation · Final report · Feb 25, 2001 · N46115 · Substantial damage
  > The pilot's improper in-flight planning/decision and his failure to refuel, which resulted in fuel exhaustion.
- [NTSB MIA01LA085](https://openairdocs.org/ntsb/MIA01LA085.md): Hiller UH-12B · Whitesburg, GA · Accident · No injuries · Limited investigation · Final report · Feb 24, 2001 · N5307V · Substantial damage
  > The improper emergency procedure performed by the pilot due to his electing to perform a run-on landing resulting in excessive airspeed at touchdown and subsequent roll-over following ground contact with grass. A contributing factor was the inadequate…
- [NTSB MIA01LA082](https://openairdocs.org/ntsb/MIA01LA082.md): Beech 36 · Tybee Island, GA · Accident · 4 fatal · Limited investigation · Final report · Feb 19, 2001 · N7703R · Destroyed
  > The flights entry into a descending right turn for undetermined reasons resulting in the flight crashing into the ocean.
- [NTSB CHI01FA113](https://openairdocs.org/ntsb/CHI01FA113.md): Beech 95-B55 · Norris, SD · Accident · 3 fatal · Field investigation · Final report · Feb 19, 2001 · N9927S · Destroyed
  > The pilot encountering instrument meteorological conditions and his subsequent loss of control of the airplane.
- [NTSB CHI01LA095](https://openairdocs.org/ntsb/CHI01LA095.md): Piper PA-22-108 · Overton, NE · Accident · No injuries · Limited investigation · Final report · Feb 18, 2001 · N5886Z · Substantial damage
  > The open exhaust valve. Factors relating to the accident were the sticking exhaust valve guide and the snow drift the airplane encountered during the precautionary landing.
- [NTSB MIA01LA081](https://openairdocs.org/ntsb/MIA01LA081.md): Cessna 182H · Weaver, AL · Accident · No injuries · Limited investigation · Final report · Feb 17, 2001 · N8556S · Substantial damage
  > Damage to the No. 4 cylinder intake valve push rod tube at an undetermined time which resulted in the push rod rubbing on the push rod tube and failing due to wear, resulting in loss of engine power and damage to the airplane during a forced landing in a…
- [NTSB FTW01LA068](https://openairdocs.org/ntsb/FTW01LA068.md): Piper PA32-R-301T · Haslet, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 17, 2001 · N8355L · Substantial damage
  > the improper installation of the oil filter bypass valve by an unknown person, which resulted in the loss of engine oil and subsequent loss of total power during a normal descent. A contributing factor to the accident was the lack of suitable terrain for the…
- [NTSB FTW01FA069](https://openairdocs.org/ntsb/FTW01FA069.md): Robinson R-22 Beta · Borger, TX · Accident · 2 fatal · Field investigation · Final report · Feb 16, 2001 · N4002M · Destroyed
  > the pilot's inadvertent flight into instrument meteorological conditions and failure to maintain obstacle clearance. Contributing factors were the pilot's failure to obtain an updated preflight weather briefing and the dark night conditions.
- [NTSB FTW01LA066](https://openairdocs.org/ntsb/FTW01LA066.md): Piper PA-28-140 · Owasso, OK · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 2001 · N2457Q · Substantial damage
  > the pilot's delay in switching the fuel selector, which resulted in fuel starvation in cruise flight.
- [NTSB CHI01LA088](https://openairdocs.org/ntsb/CHI01LA088.md): Mooney M20K · New Hudson, MI · Accident · No injuries · Limited investigation · Final report · Feb 10, 2001 · N1157P · Substantial damage
  > Inadequate preflight planning/preparation which resulted in an adequate fuel supply for the flight and subsequently in fuel starvation. A factor associated with the accident was the steep bank which the airplane contacted during the forced landing.
- [NTSB FTW01LA060](https://openairdocs.org/ntsb/FTW01LA060.md): Cessna 150K · Bishop, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 2001 · N5695G · Substantial damage
  > the pilot's failure to maintain altitude and clearance from terrain. Contributing factors were the pilot's diverted attention and the low ceiling.
- [NTSB CHI01LA086](https://openairdocs.org/ntsb/CHI01LA086.md): Cessna 310Q · Mitchell, SD · Accident · No injuries · Limited investigation · Final report · Feb 7, 2001 · N10ET · Substantial damage
  > The pilot disregarded the aircraft limitation placard, and attempted flight into known adverse weather after receiving a hazardous weather advisory. Factors to the accident were the ice-covered cockpit windshield, the ice-covered runway, and the snowbank.
- [NTSB MIA01LA073](https://openairdocs.org/ntsb/MIA01LA073.md): Cessna A150K · Cabo Rojo, PR · Accident · No injuries · Limited investigation · Final report · Feb 6, 2001 · N5915J · Substantial damage
  > The failure of the pilot to use carburetor heat during descent resulting in loss of engine power due to carburetor icing and the airplane colliding with a fence and nosing over during a forced landing.
- [NTSB ATL01LA031](https://openairdocs.org/ntsb/ATL01LA031.md): Sorrell SNS-2 Guppy · Raymond, MS · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 2001 · N6334F · Destroyed
  > The failure of the rudder horn bracket, that resulted in the inflight loss of control.
- [NTSB ANC01LA036](https://openairdocs.org/ntsb/ANC01LA036.md): Piper PA-12 · Anvik, AK · Accident · Serious injuries · Limited investigation · Final report · Feb 6, 2001 · N3334M · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions, and subsequent in-flight collision with terrain during descent. Factors in the accident were the presence of fog, and snow-covered terrain.
- [NTSB LAX01LA088](https://openairdocs.org/ntsb/LAX01LA088.md): Fish RV6 · Georgetown, CA · Accident · No injuries · Limited investigation · Final report · Feb 5, 2001 · N1198N · Substantial damage
  > The total loss of engine power due to fracture and separation of the engine crankshaft.
- [NTSB MIA01FA071](https://openairdocs.org/ntsb/MIA01FA071.md): Mooney M20R · Bluffton, SC · Accident · 2 fatal · Field investigation · Final report · Feb 4, 2001 · N88FJ · Destroyed
  > The pilot's failure to maintain control due to spatial disorientation.
- [NTSB SEA01LA045](https://openairdocs.org/ntsb/SEA01LA045.md): Alexander MA-5 Charger · Spanaway, WA · Accident · No injuries · Limited investigation · Final report · Feb 3, 2001 · N58LA · Substantial damage
  > the pilot's failure to apply carburetor heat prior to takeoff while operating in serious carburetor icing conditions. Factors include operating in serious carburetor icing conditions, and rough/uneven terrain in the area of the forced landing.
- [NTSB LAX01LA085](https://openairdocs.org/ntsb/LAX01LA085.md): Cessna T210M · Kelseyville, CA · Accident · No injuries · Limited investigation · Final report · Feb 3, 2001 · N761SE · Substantial damage
  > The failure of the pilot to comply with emergency procedures contained in the Pilot's Operating Handbook, which resulted in an excessively rich mixture and loss of engine power.
- [NTSB FTW01LA067](https://openairdocs.org/ntsb/FTW01LA067.md): British Aerospace HS.125-700A · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Feb 3, 2001 · N190WC · Substantial damage
  > the pilot-in-command's inadequate preflight inspection, which resulted in a flight with a blocked fuel tank vent. A contributing factor was maintenance personnel's failure to remove the tape covering the fuel tank vent following a pressure test.
- [NTSB ATL01LA029](https://openairdocs.org/ntsb/ATL01LA029.md): Robert D. Wood Velocity Xlfg · Sebastian, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 3, 2001 · N658SE · Substantial damage
  > The manufacturer's inadequate design of the winglet/rudder assembly, and inadequate bonding techniques for metal to fiber structures, which resulted in control surface flutter.
- [NTSB LAX01LA089](https://openairdocs.org/ntsb/LAX01LA089.md): Arthur Dragonfly · Marana, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 2, 2001 · N29KK · Substantial damage
  > A total loss of engine power for undetermined reasons. Contributing to the accident was the rough/uneven terrain.
- [NTSB NYC01LA074](https://openairdocs.org/ntsb/NYC01LA074.md): Beech B-19 · Louisa, VA · Accident · No injuries · Limited investigation · Final report · Feb 1, 2001 · N9746L · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in a hard landing. Factor's in this accident were the loss of electrical power due to an alternator failure and the night light conditions.
- [NTSB FTW01LA057](https://openairdocs.org/ntsb/FTW01LA057.md): Beech BE-58 · Brinkley, AR · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 2001 · N448DH · Substantial damage
  > the pilot's poor inflight planning and decision making which resulted in his executing a precautionary landing in a soft field. A contributing factor was the lack of suitable terrain for the precautionary landing.

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

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

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