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

## Cases, newest first

- [NTSB SEA98LA133](https://openairdocs.org/ntsb/SEA98LA133.md): Beech 23 · Oakville, WA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1998 · N8719M · Substantial damage
  > Loss of power due to the failure of an exhaust valve, and overloading of the landing gear. Factors include the failure of maintenance personnel to verify proper compliance with an Airworthiness Directive related to the exhaust valve, and soft terrain.
- [NTSB IAD98LA077](https://openairdocs.org/ntsb/IAD98LA077.md): Bennett Piel Emeraude · Hillsville, VA · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1998 · N86WB · Substantial damage
  > A blocked fuel strainer due to an inadequate maintenance inspection by the previous owner, which resulted in fuel starvation.
- [NTSB CHI98LA247](https://openairdocs.org/ntsb/CHI98LA247.md): Piper PA-22 · Nehawka, NE · Accident · No injuries · Limited investigation · Final report · Jul 13, 1998 · N3770A · Substantial damage
  > the pilot's improper fuel management and his improper use of the fuel tank selector. Factors were fuel starvation and crops.
- [NTSB LAX98FA219](https://openairdocs.org/ntsb/LAX98FA219.md): Cessna 150 · Apple Valley, CA · Accident · Minor injuries · Field investigation · Final report · Jul 12, 1998 · N1706Q · Substantial damage
  > The improper installation of unvented fuel caps that resulted in fuel starvation and loss of engine power. A factor was the lack of suitable terrain for a forced landing.
- [NTSB CHI98LA251](https://openairdocs.org/ntsb/CHI98LA251.md): Grumman G-164B · New Haven, IL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1998 · N6731K · Substantial damage
  > Water contamination of the fuel system. A related factor was the swampy terrain.
- [NTSB CHI98LA248](https://openairdocs.org/ntsb/CHI98LA248.md): Forney 415-C · Laurie, MO · Accident · Serious injuries · Limited investigation · Final report · Jul 12, 1998 · N99294 · Destroyed
  > the jammed aileron and elevator controls for undetermined reasons.
- [NTSB CHI98LA271](https://openairdocs.org/ntsb/CHI98LA271.md): Vollmers Sonerai II L · Lincoln, ND · Accident · Minor injuries · Limited investigation · Final report · Jul 11, 1998 · N317WM · Substantial damage
  > Loss of engine power due to a corroded ignition wire. Related factors were the tailwind, and ditch.
- [NTSB FTW98FA306](https://openairdocs.org/ntsb/FTW98FA306.md): Bell 47G · Jones, OK · Accident · 2 fatal · Field investigation · Final report · Jul 10, 1998 · N12085 · Destroyed
  > The pilot's failure to maintain adequate clearance from the trees during a low altitude flight/maneuver.
- [NTSB MIA98IA195](https://openairdocs.org/ntsb/MIA98IA195.md): Airbus Industrie A-300B4-605R · San Juan, PR · Incident · Minor injuries · Incident investigation · Final report · Jul 9, 1998 · N80057 · Minor damage
  > An in-flight engine fire resulting from (1) the failure of the engine overhaul facility to install, and the failure of American Airlines to ensure installation of, the proper adapter bolt inserts to preclude fuel leakage and the failure of the engine overhaul…
- [NTSB IAD98LA078](https://openairdocs.org/ntsb/IAD98LA078.md): Mastopietro Rans S12 · Phillips, ME · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 1998 · N6191V · Substantial damage
  > Loss of engine power due to a separated oil line. A related factor was the unsuitable field.
- [NTSB FTW98LA305](https://openairdocs.org/ntsb/FTW98LA305.md): Piper PA-22-135 · San Angelo, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1998 · N1279C · Substantial damage
  > The loss of engine power as a result of fuel starvation due to the pilot's improper positioning of the fuel selector. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA98IA193](https://openairdocs.org/ntsb/MIA98IA193.md): Boeing 737-7H4 · Birmingham, AL · Incident · No injuries · Incident investigation · Final report · Jul 7, 1998 · N701GS · Minor damage
  > The improper electronic control unit software logic that permitted the electronic control unit to lock on a failed hydromechanical resolver, which failed due to damage to a wire that was incurred during the manufacturing process, resulting in an uncommanded…
- [NTSB CHI98LA241](https://openairdocs.org/ntsb/CHI98LA241.md): Rockwell S-2R · Fort Ransom, ND · Accident · No injuries · Limited investigation · Final report · Jul 7, 1998 · N4232X · Substantial damage
  > A loss of engine power due to fuel exhaustion. Factors contributing to this accident were the pilot's failure to ensure the airplane had enough fuel to complete the flight, and the fence.
- [NTSB MIA98LA188](https://openairdocs.org/ntsb/MIA98LA188.md): Air Tractor AT-502 · Okeechobee, FL · Accident · No injuries · Limited investigation · Final report · Jul 6, 1998 · N10349 · Substantial damage
  > the pilot's improper planning/decision, by failing to ensure the aircraft contained adequate fuel to complete the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Obstructions (trees and guardrail) in the emergency landing…
- [NTSB FTW98FA299](https://openairdocs.org/ntsb/FTW98FA299.md): Grumman American AA-1A · Larkspur, CO · Accident · 1 fatal · Field investigation · Final report · Jul 5, 1998 · N9453L · Destroyed
  > The pilot inadvertently stalling the airplane and entering an unrecoverable spin. A factor was clear air turbulence.
- [NTSB SEA98LA120](https://openairdocs.org/ntsb/SEA98LA120.md): Beech D35 · Driggs, ID · Accident · No injuries · Limited investigation · Final report · Jul 4, 1998 · N3469B · Substantial damage
  > Excessive pressure in the fuel control unit. A foreign material/substance found on the fuel system screens was a factor.
- [NTSB SEA98LA119](https://openairdocs.org/ntsb/SEA98LA119.md): Cessna 170A · Renton, WA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1998 · N1296D · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Failure to jettison the external load and downdrafts were factors.
- [NTSB FTW98LA302](https://openairdocs.org/ntsb/FTW98LA302.md): Keith Team Mini MAX 1600R · Santa Fe, TX · Accident · No injuries · Limited investigation · Final report · Jul 4, 1998 · N106BK · Substantial damage
  > The loss of engine power as result of the failure of the cooling fan belt. A factor was the lack of suitable terrain for the pilot to execute the forced landing.
- [NTSB CHI98LA242](https://openairdocs.org/ntsb/CHI98LA242.md): Brunnemer HMB-2 · Greenwood, IN · Accident · No injuries · Limited investigation · Final report · Jul 4, 1998 · N9129F · Substantial damage
  > A loss of engine power due to a fractured ignition coil. A factor to the accident was the soft terrain.
- [NTSB ATL98LA092](https://openairdocs.org/ntsb/ATL98LA092.md): Cessna 182 · Green Sea, SC · Accident · 1 fatal · Limited investigation · Final report · Jul 4, 1998 · N7247E · Substantial damage
  > The inadvertent activation of the skydivers pilot chute, pulling him into the horizontal stabilizer/elevator, resulting in substantial damage to the airplane.
- [NTSB NYC98LA140](https://openairdocs.org/ntsb/NYC98LA140.md): Fithian Falcon XP · Mahopac, NY · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 1998 · UNREG · Substantial damage
  > The failure of the engine crankshaft, which resulted in a loss of engine power, and the pilot's improper decision to conduct flight over terrain unsuitable for the completion of a forced landing.
- [NTSB CHI98FAMS1](https://openairdocs.org/ntsb/CHI98FAMS1.md): Aero Vodochody Aero. Works L-39C · Traverse City, MI · Accident · 2 fatal · Missing aircraft · Final report · Jul 3, 1998 · N7868M · Destroyed
  > Undetermined.
- [NTSB CHI98LA239](https://openairdocs.org/ntsb/CHI98LA239.md): Robinson R-44 · Cassville, MO · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1998 · N8329B · Substantial damage
  > The pilot in command's inadequate preflight planning/preparation and weather evaluation that resulted in flight into adverse weather conditions. Factors to the accident were a preflight briefing service not being used and the transmission wire.
- [NTSB IAD98LA074](https://openairdocs.org/ntsb/IAD98LA074.md): American Blimp ABC-A-60 · Lock Haven, PA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1998 · N760AB · Substantial damage
  > the pilot's encounter with unforecasted downdrafts.
- [NTSB CHI98LA235](https://openairdocs.org/ntsb/CHI98LA235.md): Piper PA-22-108 · Spearfish, SD · Accident · 1 fatal · Limited investigation · Final report · Jul 1, 1998 · N5181Z · Substantial damage
  > the pilots improper preflight planning, which failed to detect the fuel selector positioned on the left fuel tank, which had insufficient fuel, resulting in fuel starvation, and the loss of engine power.
- [NTSB MIA98LA191](https://openairdocs.org/ntsb/MIA98LA191.md): Cessna 152 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Jun 29, 1998 · N6363B · Substantial damage
  > The pilot's delay in initiating a go-around, which resulted in an inflight collision with power lines.
- [NTSB LAX98IA218](https://openairdocs.org/ntsb/LAX98IA218.md): Aero Commander 681B · Reno, NV · Incident · No injuries · Incident investigation · Final report · Jun 29, 1998 · N520CS · Minor damage
  > The failure and separation of the first and third stage turbine disks for undetermined reasons.
- [NTSB IAD98LA075](https://openairdocs.org/ntsb/IAD98LA075.md): Hoffmann Fisher FP 404 · Louisa, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1998 · N6188X · Substantial damage
  > Loss of engine power for undetermined reasons.
- [NTSB IAD98LA073](https://openairdocs.org/ntsb/IAD98LA073.md): Saab-Scania F-35 Draken · Oceana, VA · Accident · No injuries · Limited investigation · Final report · Jun 26, 1998 · N156XD · Substantial damage
  > The pilot-in-command's inadequate fuel management which led to fuel exhaustion and subsequent loss of engine power. A related factor was the pilot's unfamiliarity with the fuel system.
- [NTSB FTW98LA288](https://openairdocs.org/ntsb/FTW98LA288.md): Piper PA-23-160 · Casper, WY · Accident · No injuries · Limited investigation · Final report · Jun 26, 1998 · N4132P · Substantial damage
  > The pilot's improper in-flight planning and decision making by selecting an inadequate landing area for an emergency landing when a suitable landing area was available. Factors were fuel exhaustion, inaccurate preflight planning, and lack of recent experience.
- [NTSB LAX98FA211](https://openairdocs.org/ntsb/LAX98FA211.md): Eurocopter AS-350-BA · Mt. Waialeale, HI · Accident · 6 fatal · Field investigation · Final report · Jun 25, 1998 · N594BK · Destroyed
  > The pilot's decision to continue VFR flight into deteriorating weather conditions consisting of lowering ceilings and visibility in mountainous terrain, which resulted in the inadvertent entry into instrument meteorological conditions and a collision with a…
- [NTSB NYC98LA132](https://openairdocs.org/ntsb/NYC98LA132.md): Extra Flugzeugbau Flugzeugbau EA260 · Georgia, VT · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1998 · N148GC · Destroyed
  > The pilot's inadequate inflight decision and the loss of engine power due to a blocked vent line. A contributing factor was an unreliable fuel gauge.
- [NTSB MIA98FA187](https://openairdocs.org/ntsb/MIA98FA187.md): Mooney M-20E · Pickens, SC · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1998 · N2709W · Destroyed
  > A loss of engine power for undetermined reasons and the pilot not maintaining adequate clearance with objects (trees) during the emergency landing. Contributing factors were the pilot's impairment associated with the use of an antihistamine and the trees.
- [NTSB IAD98FA072](https://openairdocs.org/ntsb/IAD98FA072.md): Cessna 172M · Hebron, CT · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1998 · N12912 · Destroyed
  > The pilot's failure to obtain a weather briefing which resulted in inadvertent flight into instrument meteorological conditions, and his failure to maintain control of the airplane due to spatial disorientation. Factors in this accident were low ceilings and…
- [NTSB IAD98LA071](https://openairdocs.org/ntsb/IAD98LA071.md): Cessna 152 · Edgemere, MD · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1998 · N95415 · Substantial damage
  > The pilot's inadequate in-flight planning/decision which led to fuel exhaustion.
- [NTSB FTW98LA281](https://openairdocs.org/ntsb/FTW98LA281.md): Rockwell Commander 112 · Las Vegas, NM · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1998 · N1188J · Substantial damage
  > The pilot's improper preflight planning/preparation for a cross country flight resulting in fuel exhaustion and subsequent loss of engine power. Factors were, unsuitable terrain, lack of total aviation experience, and lack of total experience in make/model of…
- [NTSB FTW98FA276](https://openairdocs.org/ntsb/FTW98FA276.md): Beech A36 · Nephi, UT · Accident · 2 fatal · Field investigation · Final report · Jun 20, 1998 · N3861K · Destroyed
  > The improper installation of the turbocharger exhaust stack by unknown maintenance personnel and the subsequent fire in the engine compartment due to the exhaust gas leak from the turbocharger. Factors were the total loss of engine power due to fuel line…
- [NTSB ANC98LA078](https://openairdocs.org/ntsb/ANC98LA078.md): Cessna 207 · Holy Cross, AK · Accident · No injuries · Limited investigation · Final report · Jun 20, 1998 · N1673U · Substantial damage
  > The improper installation/undertorquing of the engine crankcase bolts by company maintenance personnel, and a subsequent fracture of the engine crankshaft. A factor in the accident was unsuitable terrain for a forced landing.
- [NTSB SEA98FA105](https://openairdocs.org/ntsb/SEA98FA105.md): Cessna 340 · Lincoln, MT · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1998 · N88JH · Destroyed
  > The pilot's improper or inadequate use of the aircraft's weather avoidance equipment, resulting in penetration of a Level 4 thunderstorm and subsequent loss of aircraft control from which the pilot did not recover. Factors included a thunderstorm and the…
- [NTSB MIA98LA186](https://openairdocs.org/ntsb/MIA98LA186.md): Piper PA-28-180 · Holly Springs, MS · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 1998 · N8284W · Substantial damage
  > The pilot's inadequate in-flight decision with the miscalculation of the fuel consumption. Operating with an unreliable fuel gage was a contributing factor.
- [NTSB ANC98FA079](https://openairdocs.org/ntsb/ANC98FA079.md): Cessna 185 · Big Lake, AK · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1998 · N9982X · Destroyed
  > The pilot's performance of a low level maneuver. Factors were the pilot's overconfidence in his personal ability, his lack of experience in the type of airplane, and his failure to maintain adequate clearance from terrain.
- [NTSB SEA98LA103](https://openairdocs.org/ntsb/SEA98LA103.md): Casa BU-131 · Harrisburg, OR · Accident · No injuries · Limited investigation · Final report · Jun 17, 1998 · N1XW · Substantial damage
  > A failed bracket attaching the throttle linkage, which resulted in the inability to control power, and unsuitable terrain for a successful forced landing. Factors include soft terrain with high vegetation.
- [NTSB SEA98LA099](https://openairdocs.org/ntsb/SEA98LA099.md): Cessna T210M · La Pine, OR · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1998 · N22CT · Substantial damage
  > Fuel starvation for undetermined reasons.
- [NTSB LAX98FA199](https://openairdocs.org/ntsb/LAX98FA199.md): Mooney M20R · Van Nuys, CA · Accident · 2 fatal · Field investigation · Final report · Jun 16, 1998 · N130RB · Destroyed
  > the non-instrument rated pilot's intentional VFR flight into instrument meteorological conditions. Factors were the low ceiling, drizzle, and fog.
- [NTSB LAX98LA204](https://openairdocs.org/ntsb/LAX98LA204.md): Fife Lancair 320 · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1998 · N96GF · Substantial damage
  > A failure of the electrical system for undetermined reasons. The pilot's decision to continue flight with a suspected electrical system anomaly is a factor in the accident.
- [NTSB FTW98LA269](https://openairdocs.org/ntsb/FTW98LA269.md): Cessna 152 · Boyd, TX · Accident · No injuries · Limited investigation · Final report · Jun 15, 1998 · N6217Q · Substantial damage
  > The loss of engine power due to the total loss of engine oil for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL98LA084](https://openairdocs.org/ntsb/ATL98LA084.md): Bellanca 17-31A · Millry, AL · Accident · No injuries · Limited investigation · Final report · Jun 15, 1998 · N39853 · Substantial damage
  > The fracture of the #2 cylinder connecting rod which resulted in partial loss of engine power and subsequent forced landing. A factor in the accident was the rough terrain.
- [NTSB LAX98LA194](https://openairdocs.org/ntsb/LAX98LA194.md): Scott Dragonfly · Mecca, CA · Accident · No injuries · Limited investigation · Final report · Jun 13, 1998 · N824JC · Substantial damage
  > The pilot's inadequate preflight inspection and his failure to ensure sufficient fuel was in the airplane, which subsequently led to fuel exhaustion. A related factor was the soft terrain.
- [NTSB FTW98LA268](https://openairdocs.org/ntsb/FTW98LA268.md): Cessna 150L · Taft, TX · Accident · No injuries · Limited investigation · Final report · Jun 13, 1998 · N10519 · Substantial damage
  > The pilot's failure to ensure that there was adequate fuel for the planned flight on board the airplane during the preflight inspection which resulted in a loss of engine power due to fuel exhaustion. A factor was the pilot's misjudgment of the glide distance…
- [NTSB CHI98LA200](https://openairdocs.org/ntsb/CHI98LA200.md): Piper PA-23-250 · Albion, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 1998 · N4617P · Substantial damage
  > the pilot's improper preflight planning/preparation and his not refueling the airplane to avoid fuel exhaustion. Factors were the pilot's lack of certification, his not feathering the engine, and the trees.

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

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

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