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

## Cases, newest first

- [NTSB CHI99LA020](https://openairdocs.org/ntsb/CHI99LA020.md): Becker Wag Aero Super Sport · Hamilton, ND · Accident · 1 fatal · Limited investigation · Final report · Nov 3, 1998 · N285BB · Destroyed
  > the fatigue failure of the lower wing strut attachment bracket.
- [NTSB ANC99LA011](https://openairdocs.org/ntsb/ANC99LA011.md): Piper PA-12 · Willow, AK · Accident · No injuries · Limited investigation · Final report · Nov 3, 1998 · N5129Y · Substantial damage
  > A loss of engine power due to an undetermined reason. A factor associated with the accident was unsuitable terrain for a forced landing.
- [NTSB MIA99FA027](https://openairdocs.org/ntsb/MIA99FA027.md): Cessna C-182Q · Piedmont, AL · Accident · 2 fatal · Field investigation · Final report · Nov 2, 1998 · N735JZ · Destroyed
  > The pilot's decision to continue the flight under visual flight rules into deteriorating visibility, and his failure to maintain altitude clearance with the terrain.
- [NTSB FTW99FA018](https://openairdocs.org/ntsb/FTW99FA018.md): Morrisey Rutan Long EZE · Alvin, TX · Accident · 1 fatal · Field investigation · Final report · Nov 2, 1998 · N21EE · Destroyed
  > Loss of engine power for undetermined reasons.
- [NTSB DCA99MA007](https://openairdocs.org/ntsb/DCA99MA007.md): Boeing 737-200 · Atlanta, GA · Accident · Minor injuries · Major investigation · Final report · Nov 1, 1998 · EICJW · Substantial damage
  > (1) the capping of the incorrect hydraulic line by mechanics, which led to the failure of hydraulic system A; (2) the mechanics' lack of experience working with the Boeing 737 hydraulic system; and (3) the maintenance controller's failure to ascertain more…
- [NTSB LAX99FA020](https://openairdocs.org/ntsb/LAX99FA020.md): Cessna 182Q · Nixon, NV · Accident · 3 fatal · Field investigation · Final report · Oct 29, 1998 · N95726 · Destroyed
  > The noninstrument rated pilot's failure to maintain control of the airplane during an attempted flight into adverse weather which resulted in inadvertent VFR flight into instrument meteorological conditions. Factors in the accident were the pilot's failure to…
- [NTSB DEN99LA018](https://openairdocs.org/ntsb/DEN99LA018.md): Piper PA28-181 · Tooele, UT · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 1998 · N3034B · Destroyed
  > The pilot's VFR flight into IMC and his failure to maintain adequate terrain clearance. Contributng factors were fog, low ceilings, high terrain, the pilot's lack of familiarity with the geographic environment and his misinterpretation of terrain features on…
- [NTSB ATL99FA011](https://openairdocs.org/ntsb/ATL99FA011.md): Piper PA-32R-300 · Roswell, GA · Accident · 1 fatal · Field investigation · Final report · Oct 28, 1998 · N8554C · Destroyed
  > A loss of engine power due to the failure of the number five connecting rod assembly as a result of fatigue cracks that were initiated in areas of galling. A factor was the lack of suitable terrain for a forced landing.
- [NTSB MIA99LA017](https://openairdocs.org/ntsb/MIA99LA017.md): Reinhold Revolution Mini 500 · Hickory, NC · Accident · No injuries · Limited investigation · Final report · Oct 26, 1998 · N500GQ · Substantial damage
  > The seizure of the rear piston in the cylinder barrel resulting in total loss of engine power and an autorotation which resulted in main rotor contact with the tail boom while touching down on unsuitable terrain.
- [NTSB ANC99LA008](https://openairdocs.org/ntsb/ANC99LA008.md): Cessna 207A · Noorvik, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 26, 1998 · N9400M · Substantial damage
  > The pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were a dark night and low ceilings.
- [NTSB LAX99LA015](https://openairdocs.org/ntsb/LAX99LA015.md): Beech 36 · Palmdale, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1998 · N36EL · Substantial damage
  > The pilot's improper management of his fuel supply which resulted in fuel starvation. Factors in the accident were the inadequate annual inspection which resulted in fuel siphoning, and a high reading fuel gage.
- [NTSB LAX99LA014](https://openairdocs.org/ntsb/LAX99LA014.md): Piper PA-28-180 · Reno, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 1998 · N2164T · Destroyed
  > The pilot's disregard for five weather briefings and his attempted flight into known adverse weather conditions.
- [NTSB CHI99LA012](https://openairdocs.org/ntsb/CHI99LA012.md): Hiller UH-12C · Clinton, IA · Accident · No injuries · Limited investigation · Final report · Oct 24, 1998 · N9739C · Substantial damage
  > the failure of the 90 degree gearbox for reasons undetermined. Factors were the failure of the gearbox, and it not being possible for the pilot to maintain control of the aircraft.
- [NTSB SEA99LA006](https://openairdocs.org/ntsb/SEA99LA006.md): Cessna 172G · Vancouver, WA · Accident · No injuries · Limited investigation · Final report · Oct 23, 1998 · N3765L · Substantial damage
  > Refueling was not preformed which subsequently led to fuel exhaustion. Factors include the student pilot's inadequate preflight planing/preparation.
- [NTSB SEA99GA007](https://openairdocs.org/ntsb/SEA99GA007.md): Cessna 182P · Deming, WA · Accident · 1 fatal · Final report · Oct 23, 1998 · N1324M · Destroyed
  > Terrain clearance was not maintained for undetermined reasons. Mountainous terrain was a factor.
- [NTSB CHI99LA010](https://openairdocs.org/ntsb/CHI99LA010.md): Taylorcraft BC12-D · Duluth, MN · Accident · No injuries · Limited investigation · Final report · Oct 22, 1998 · N95196 · Substantial damage
  > The inadequate airspeed by the pilot-in-command. Contributing factors were the gusts and the trees.
- [NTSB LAX99IA013](https://openairdocs.org/ntsb/LAX99IA013.md): Boeing MD-11 · Honolulu, HI · Incident · No injuries · Incident investigation · Final report · Oct 21, 1998 · N581FE · No damage
  > A jammed spoiler control pulley system caused by a shop rag left in an area of recent maintenance. Neither the maintenance organization nor the mechanic responsible could be determined.
- [NTSB DEN99LA015](https://openairdocs.org/ntsb/DEN99LA015.md): Mooney M20C · Englewood, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 1998 · N6405U · Substantial damage
  > The undertorquing of the camshaft gear retaining bolts during engine overhaul by maintenance personnel. A factor was the unsuitable terrain for a forced landing.
- [NTSB DEN99LA014](https://openairdocs.org/ntsb/DEN99LA014.md): Beech B200 · Rio Rancho, NM · Accident · No injuries · Limited investigation · Final report · Oct 20, 1998 · N50PM · Destroyed
  > The pilot's inadequate preflight of the aircraft, resulting in fuel supply exhaustion.
- [NTSB FTW99LA014](https://openairdocs.org/ntsb/FTW99LA014.md): Cessna 182Q · Farmerville, LA · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 1998 · N4796N · Substantial damage
  > The loss of engine power due to fuel exhaustion as result of the pilot's inadequate preflight. Factors were the pilot's failure to verify the refueling of the airplane and the lack of suitable terrain for the forced landing.
- [NTSB DEN99FA012](https://openairdocs.org/ntsb/DEN99FA012.md): Piper PA-28-235 · Buffalo, WY · Accident · 2 fatal · Field investigation · Final report · Oct 19, 1998 · N8537N · Destroyed
  > The non-instrument rated pilot's initiated flight into adverse weather conditions and inadvertently flew into IMC weather conditions. Factors were the low ceiling weather conditions, the dark night light conditions, and a non operating VOR navigational aid.
- [NTSB MIA99LA007](https://openairdocs.org/ntsb/MIA99LA007.md): Ayres S2R · Frisco City, AL · Accident · No injuries · Limited investigation · Final report · Oct 14, 1998 · N3093B · Destroyed
  > The pilot's failure to maintain airspeed on climb out resulting in an inadvertent stall, and subsequent in-flight collision with terrain.
- [NTSB IAD99LA010](https://openairdocs.org/ntsb/IAD99LA010.md): Piper PA-32-300 · Dunkirk, NY · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 1998 · N8619N · Substantial damage
  > The pilot's inadequate fuel management that resulted in fuel starvation. Factors in the accident were the improperly timed magneto and an engine driven fuel pump leak.
- [NTSB IAD99FA005](https://openairdocs.org/ntsb/IAD99FA005.md): Cessna R172K · Bowie, MD · Accident · 1 fatal · Field investigation · Final report · Oct 13, 1998 · N736KL · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Also causal was the pilot's poor in-flight planning/decision, and his continued VFR flight into instrument meteorological conditions. A related factor was the fog.
- [NTSB DEN99LA008](https://openairdocs.org/ntsb/DEN99LA008.md): Stinson 108-3 · Jackson Hole, WY · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1998 · N569C · Destroyed
  > The pilot's inability to maintain adequate airspeed which resulted in an inadvertent stall/mush. Factors contributing to the accident were the unfavorable weather condition, mountain wave and the high density altitude.
- [NTSB LAX99LA007](https://openairdocs.org/ntsb/LAX99LA007.md): Cessna 190 · Lost Hills, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1998 · N1087D · Substantial damage
  > A loss of engine power due to fatigue failure of the number 4 cylinder articulating rod.
- [NTSB FTW99FA001](https://openairdocs.org/ntsb/FTW99FA001.md): Bell 407 · Vermilion 331 · Accident · 1 fatal · Field investigation · Final report · Oct 5, 1998 · N403PH · 2 aircraft · Destroyed
  > the failure of both pilots to see and avoid each other's aircraft during cruise flight. Factors were the failure of both pilots to use a known safety advisory recommendation and the failure of both operators to implement the recommendation as a company…
- [NTSB DEN99LA003](https://openairdocs.org/ntsb/DEN99LA003.md): Cameron N-120 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 1998 · N1607G · No damage
  > The balloon's encounter with unforecasted wind shear and the subsequent inadvertent collision with terrain. A factor was the pilot's inability to control the balloon's descent.
- [NTSB IAD99LA002](https://openairdocs.org/ntsb/IAD99LA002.md): Navion A · Jaffrey, NH · Accident · No injuries · Limited investigation · Final report · Oct 3, 1998 · N4285K · Substantial damage
  > The pilot's inadequate aircraft preflight and subsequent failure to refuel the aircraft resulting in fuel exhaustion. A factor was the lack of suitable terrain to execute a forced landing.
- [NTSB FTW99LA002](https://openairdocs.org/ntsb/FTW99LA002.md): Piper PA-28-180 · Horizon City, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 3, 1998 · N8194W · Substantial damage
  > The fuel exhaustion due to the pilot's failure to refuel the airplane. Factors were the unfavorable wind condition and the lack of suitable terrain for the forced landing.
- [NTSB LAX99LA002](https://openairdocs.org/ntsb/LAX99LA002.md): Cessna 152 · San Jose, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 1998 · N957AF · Destroyed
  > Continued VFR flight by the pilot into instrument meteorological conditions (IMC) at night over mountainous terrain. The pilot's use of unclear language when stating his intentions to air traffic control was a factor.
- [NTSB FTW99LA003](https://openairdocs.org/ntsb/FTW99LA003.md): Beech M35 · Carter, OK · Accident · No injuries · Limited investigation · Final report · Oct 2, 1998 · N9838R · Substantial damage
  > Fuel starvation. Factors were; the pilot's self induced pressure to fly the aircraft when maintenance had not been completed, poor judgement by the pilot to commence and continue flight with known deficiencies in the aircraft, and the lack of suitable terrain…
- [NTSB LAX99FA001](https://openairdocs.org/ntsb/LAX99FA001.md): Aero Commander 680 FPL · Palm Springs, CA · Accident · 1 fatal · Field investigation · Final report · Oct 1, 1998 · N5YZ · Destroyed
  > The pilot's failure to properly use the manual turbocharger wastegates and to monitor the manifold pressure during takeoff.
- [NTSB LAX98FA312](https://openairdocs.org/ntsb/LAX98FA312.md): Cessna 152 · Avalon, CA · Accident · 1 fatal · Field investigation · Final report · Oct 1, 1998 · N49770 · Destroyed
  > The pilot's failure to maintain adequate altitude/clearance. Contributing to the accident were the hilly and mountainous terrain and glare from the setting sun.
- [NTSB SEA98LA192](https://openairdocs.org/ntsb/SEA98LA192.md): Mayala Dragonfly · Avon, MT · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1998 · N4478V · Destroyed
  > Failure of the engine crankshaft aft oil seal resulting in the loss of engine oil, and rough terrain during the forced landing.
- [NTSB MIA98LA254](https://openairdocs.org/ntsb/MIA98LA254.md): Bell 47-D1 · Oxford, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1998 · N755E · Substantial damage
  > The pilot's failure to maintain directional control due to vibration from the main rotor blade for undetermined reasons. A related finding was the improper repair of a crack in the laminant of the blue main rotor blade by other maintenance personnel.
- [NTSB CHI98LA366](https://openairdocs.org/ntsb/CHI98LA366.md): Beech BE-35 · Point Lookout, MO · Accident · No injuries · Limited investigation · Final report · Sep 29, 1998 · N8946M · Substantial damage
  > The pilot's continued flight with a known deficiency in equipment. Contributing to the accident was the maintenance adjustment that was not completed by the mechanic.
- [NTSB FTW98LA412](https://openairdocs.org/ntsb/FTW98LA412.md): Cessna 152 · Durango, CO · Accident · No injuries · Limited investigation · Final report · Sep 27, 1998 · N4568F · Substantial damage
  > Improper maintenance by an unknown person and the subsequent throttle cable disconnect due to a castellated nut separation. Factors were the none suitable soft terrain for the forced landing, and the failure of the nose wheel landing gear during the landing…
- [NTSB LAX98LA309](https://openairdocs.org/ntsb/LAX98LA309.md): Texas Helicopter OH-13H · Gilroy, CA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1998 · N1001G · Destroyed
  > The pilot's loss of control for undetermined reasons.
- [NTSB LAX98FA306](https://openairdocs.org/ntsb/LAX98FA306.md): Beech 95-B55 · Hawthorne, NV · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1998 · N554MB · Destroyed
  > The pilot's disregard of the weather briefing information and his decision to attempt flight into forecast adverse weather conditions, which led to an encounter with icing conditions beyond the performance capability of the aircraft. The pilot's disregard for…
- [NTSB CHI98LA367](https://openairdocs.org/ntsb/CHI98LA367.md): Piper PA-34-220T · Schofield, WI · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1998 · N900JH · Substantial damage
  > The inadvertent deactivation of the fuel selector and the emergency procedure not followed by the pilot-in-command. The tree was a contributing factor.
- [NTSB FTW98LA410](https://openairdocs.org/ntsb/FTW98LA410.md): Grumman G-164A · Mart, TX · Accident · No injuries · Limited investigation · Final report · Sep 25, 1998 · N983X · Substantial damage
  > The loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX98FA297](https://openairdocs.org/ntsb/LAX98FA297.md): Beech 35-B33 · San Jose, CA · Accident · 2 fatal · Field investigation · Final report · Sep 19, 1998 · N486W · Destroyed
  > the pilot's loss of aircraft control and entry into a spiral dive for undetermined reasons. The dark night lighting conditions and the pilot's probable low recent flight experience were factors in this accident.
- [NTSB FTW98FA392](https://openairdocs.org/ntsb/FTW98FA392.md): Piper PA-20-180 · Thornton, CO · Accident · Serious injuries · Field investigation · Final report · Sep 19, 1998 · N6028D · Destroyed
  > The separation of a propeller blade due to corrosion initiated fatigue, followed by the separation of several of the engine's mounts, and the subsequent inability of the pilot to control the aircraft. A contributing factor was the trees.
- [NTSB CHI98FA353](https://openairdocs.org/ntsb/CHI98FA353.md): Barklage Revolution Mini 500 · Cahokia, IL · Accident · 1 fatal · Field investigation · Final report · Sep 19, 1998 · N611AB · Destroyed
  > A loss of engine power due to cold seizure of the power-takeoff cylinder. A factor contributing to the accident was the power lines.
- [NTSB FTW98LA404](https://openairdocs.org/ntsb/FTW98LA404.md): Piper PA-28RT-201T · Duck Creek, UT · Accident · No injuries · Limited investigation · Final report · Sep 18, 1998 · N8252S · Substantial damage
  > Loose intake valve rocker arm studs that allowed a loss of compression and a loss of oil. A factor was unsuitable terrain on which to make a forced landing and poles next to a cattle guard.
- [NTSB ATL98GA127](https://openairdocs.org/ntsb/ATL98GA127.md): Government Aircraft Fact N22S · Caribbean Sea · Accident · 1 fatal · Final report · Sep 18, 1998 · N6305U · 2 aircraft · Destroyed
  > The failure of the pilot-in-command of the other aircraft (N6305U) to maintain physical clearance from N6302W. Contributing factors were the inadequate visual lookout of all four pilots involved.
- [NTSB SEA98LA181](https://openairdocs.org/ntsb/SEA98LA181.md): Kelly Kolb Mark III · Cashmere, WA · Accident · Serious injuries · Limited investigation · Final report · Sep 17, 1998 · N62691 · Substantial damage
  > Fuel starvation caused by the partial blockage of the fuel pump chambers as a result of the misalignment of the fuel pump front cover by the pilot/builder. Factors include trees in the area in which the pilot attempted the forced landing.
- [NTSB CHI98FA349](https://openairdocs.org/ntsb/CHI98FA349.md): Beech 58 · Oakdale, WI · Accident · 3 fatal · Field investigation · Final report · Sep 16, 1998 · N4574Q · Destroyed
  > The installation of the door seal inflation system by company personnel. An additional cause was the emergency procedures not followed by the pilot-in-command. A contributing factor was the trees.
- [NTSB SEA98LA177](https://openairdocs.org/ntsb/SEA98LA177.md): Stinson 108-1 · Spray, OR · Accident · No injuries · Limited investigation · Final report · Sep 14, 1998 · N8666K · Substantial damage
  > A partial loss of engine power, and the pilot's subsequent misjudgment of clearance with a transmission wire during a precautionary landing approach. The reason for the power loss was not determined; however, the pilot reported that it was not of a mechanical…

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

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

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