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

## Cases, newest first

- [NTSB IAD98LA009](https://openairdocs.org/ntsb/IAD98LA009.md): Cessna P210N · Smoketown, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 30, 1997 · N600WL · Substantial damage
  > The pilot in command's (CFI) improper management of the fuel supply, which resulted in fuel exhaustion of the selected tank and the subsequent loss of engine power.
- [NTSB CHI98FA028](https://openairdocs.org/ntsb/CHI98FA028.md): Beech BE 58 · New Berlin, IL · Accident · 6 fatal · Field investigation · Final report · Oct 30, 1997 · N472TL · Destroyed
  > A loss of engine power due to separation of the left engine's number 2 connecting rod as a result of fatigue failure. Also causal was the pilot's failure to maintain adequate airspeed which resulted in a stall/spin. Contributing to the accident was the…
- [NTSB LAX98LA026](https://openairdocs.org/ntsb/LAX98LA026.md): Striplin Lone Ranger Slvr CLD · Agua Dulce, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 1997 · N4478Y · Destroyed
  > Failure of the propeller system/drive assembly, and the pilot's failure to maintain flying speed, which resulted in a stall and subsequent impact with the ground. Inadequate maintenance/inspection of the propeller system was a contributing factor.
- [NTSB CHI98LA027](https://openairdocs.org/ntsb/CHI98LA027.md): Champion 7ECA · Augusta, KS · Accident · No injuries · Limited investigation · Final report · Oct 29, 1997 · N7505F · Substantial damage
  > failure of the aircraft owner to reinstall the quick release hinge pins/safety pins, and failure of the pilot to notice the missing pins during the aircraft preflight, which resulted in separation of the main entry door during flight.
- [NTSB LAX98FA031](https://openairdocs.org/ntsb/LAX98FA031.md): Cessna U206B · Markleeville, CA · Accident · 4 fatal · Field investigation · Final report · Oct 27, 1997 · N4982F · Destroyed
  > the pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude or clearance from mountainous terrain. Factors relating to the accident were: the excessive gross weight of the airplane, the high density altitude, and the…
- [NTSB SEA98LA008](https://openairdocs.org/ntsb/SEA98LA008.md): Beckham RV-4 · Scio, OR · Accident · 1 fatal · Limited investigation · Final report · Oct 26, 1997 · N160HB · Destroyed
  > The pilot-in-command's loss of control of the aircraft for undetermined reasons.
- [NTSB NYC98FA020](https://openairdocs.org/ntsb/NYC98FA020.md): Cessna 172E · Elkton, VA · Accident · 1 fatal · Field investigation · Final report · Oct 26, 1997 · N3097U · Destroyed
  > The pilot's intention VFR flight into instrument meteorological conditions. Contributing factors were clouds and mountainous/hilly terrain..
- [NTSB FTW98FA031](https://openairdocs.org/ntsb/FTW98FA031.md): Piper PA-28RT-201 · Hazen, AR · Accident · 2 fatal · Field investigation · Final report · Oct 25, 1997 · N8146R · Destroyed
  > The pilot's failure to maintain aircraft control. Factors were the pilot's lack of total experience in the make and model of aircraft, the pilot's lack of total night flight experience, and the dark night conditions,
- [NTSB NYC98FA018](https://openairdocs.org/ntsb/NYC98FA018.md): Enstrom F-28C · Fairview, PA · Accident · No injuries · Field investigation · Final report · Oct 24, 1997 · N1944J · Substantial damage
  > inadequate maintenance, which led to detonation and a melted piston, and subsequent power loss.
- [NTSB MIA98FA015](https://openairdocs.org/ntsb/MIA98FA015.md): Cessna 172M · Rabun Gap, GA · Accident · 2 fatal · Field investigation · Final report · Oct 24, 1997 · N1499U · Destroyed
  > The pilot's continued flight under visual flight rules into known instrument meteorological conditions and his failure to maintain a safe altitude for terrain clearance resulting in the aircraft colliding with trees and the ground on the side of a mountain.
- [NTSB SEA98LA007](https://openairdocs.org/ntsb/SEA98LA007.md): Cessna 185A · Damascus, OR · Accident · 2 fatal · Limited investigation · Final report · Oct 23, 1997 · N714 · Destroyed
  > failure of the pilot to maintain sufficient altitude/clearance from terrain. Factors relating to the accident included: darkness, and hilly/mountainous terrain.
- [NTSB ANC98FA006](https://openairdocs.org/ntsb/ANC98FA006.md): Piper PA-32-300 · Juneau, AK · Accident · 2 fatal · Field investigation · Final report · Oct 23, 1997 · N30505 · Destroyed
  > The pilot's intentional flight into adverse weather. Related factors were the low ceilings, mountainous terrain, and self induced pressure by the pilot to complete the flight and return for the evening.
- [NTSB ANC98LA005](https://openairdocs.org/ntsb/ANC98LA005.md): Piper PA-20 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · Oct 21, 1997 · N7049K · Substantial damage
  > The loss of engine power due to the pilot's failure to refuel the airplane prior to fuel exhaustion. A factor associated with the accident was the lack of suitable terrain for a forced landing.
- [NTSB NYC98LA015](https://openairdocs.org/ntsb/NYC98LA015.md): Piper PA-32RT-300 · Scottsville, VA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1997 · N2200J · Substantial damage
  > improper engine operation by undetermined person(s) that initiated gauling on the connecting rod, and led to its subsequent failure.
- [NTSB NYC98FA016](https://openairdocs.org/ntsb/NYC98FA016.md): Cessna 182P · Morgantown, WV · Accident · 1 fatal · Field investigation · Final report · Oct 20, 1997 · N9388G · Destroyed
  > The loss of engine power due to carburetor ice and the pilot's failure to follow ATC instructions during the emergency descent.
- [NTSB FTW98FA024](https://openairdocs.org/ntsb/FTW98FA024.md): Cessna 150M · Deming, NM · Accident · 1 fatal · Field investigation · Final report · Oct 20, 1997 · N6206K · Destroyed
  > The loss of engine power due to fuel contamination. Contributing was unsuitable terrain consisting of high vegetation and sand.
- [NTSB CHI98LA020](https://openairdocs.org/ntsb/CHI98LA020.md): Mooney M20C · St Charles, MO · Accident · No injuries · Limited investigation · Final report · Oct 20, 1997 · N9449V · Substantial damage
  > failure of the alternator's front bearing, depletion of battery power, and failure of the emergency landing gear extension handcrank to engage during the pilot's attempt to perform the emergency procedure.
- [NTSB SEA98LA006](https://openairdocs.org/ntsb/SEA98LA006.md): Bell 47-G3B · Winston, MT · Accident · No injuries · Limited investigation · Final report · Oct 19, 1997 · N47AH · Substantial damage
  > Fuel starvation due to fuel flow restriction from a failed carburetor automatic mixture control device. Factors include night light conditions for the forced landing.
- [NTSB FTW98LA022](https://openairdocs.org/ntsb/FTW98LA022.md): Cessna 150G · Tyler, TX · Accident · No injuries · Limited investigation · Final report · Oct 19, 1997 · N3916J · 2 aircraft · Minor damage
  > The failure of the of pilot of the departing Cessna to follow standard departure procedures and his disorientation while navigating to locate a highway. A factor was the failure of both pilots to maintain visual lookout.
- [NTSB ATL98LA003](https://openairdocs.org/ntsb/ATL98LA003.md): Cessna 150M · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 19, 1997 · N7814U · Substantial damage
  > excessive wear to the number one valve stem and valve stem keepers that resulted in the separation of the valve assembly.
- [NTSB MIA98LA013](https://openairdocs.org/ntsb/MIA98LA013.md): Cessna 172G · Panacea, FL · Accident · No injuries · Limited investigation · Final report · Oct 17, 1997 · N4690L · Substantial damage
  > The pilot's improper use of carburetor heat resulting in loss of engine power due to carburetor icing and an in flight collision with trees during a forced landing.
- [NTSB CHI98LA079](https://openairdocs.org/ntsb/CHI98LA079.md): Cessna 152 · Quincy, IL · Accident · No injuries · Limited investigation · Final report · Oct 17, 1997 · N68299 · Destroyed
  > improper in-flight planning/decision by the flight instructor (CFI), by switching 'OFF' the fuel selector valve of the single-engine airplane (starving the engine of fuel) to 'simulate' an emergency. Factors relating to the accident were: the soft and uneven…
- [NTSB FTW98IA019](https://openairdocs.org/ntsb/FTW98IA019.md): Boeing 757-222 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Oct 16, 1997 · N581UA · Minor damage
  > Maintenance personnel's failure to properly secure the left off-wing slide door after routine slide replacement, allowing an inflight separation of the slide. Factors were inadequate training of maintenance personnel and inadequate written instructions by the…
- [NTSB FTW98TA051](https://openairdocs.org/ntsb/FTW98TA051.md): Cessna P210N · Bryce Canyon, UT · Incident · No injuries · Final report · Oct 15, 1997 · N731NX · Minor damage
  > The failure of the resistor (inverter) in the door seal pressurization air pump due to continuous operation. Factors were a failure in the door seal pressurization system, its inadequate design by the manufacturer, its inadequate written instructions for…
- [NTSB NYC98LA012](https://openairdocs.org/ntsb/NYC98LA012.md): Cessna 172P · Pittsfield, MA · Accident · No injuries · Limited investigation · Final report · Oct 14, 1997 · N62264 · Substantial damage
  > The pilot's poor in-flight decision to continue VFR flight in IFR conditions. Factor's in this accident were the pilot's inadequate pre-flight planning, and fog.
- [NTSB LAX98FA008](https://openairdocs.org/ntsb/LAX98FA008.md): Adrian Davis LONG-EZ · Pacific Grove, CA · Accident · 1 fatal · Field investigation · Final report · Oct 13, 1997 · N555JD · Destroyed
  > the pilot's diversion of attention from the operation of the airplane and his inadvertent application of right rudder that resulted in the loss of airplane control while attempting to manipulate the fuel selector handle. Also, the Board determined that the…
- [NTSB SEA98FA001](https://openairdocs.org/ntsb/SEA98FA001.md): Piper PA-28-181 · Leadore, ID · Accident · 2 fatal · Field investigation · Final report · Oct 11, 1997 · N2938B · Destroyed
  > the pilot's inadvertent entry into instrument meteorological conditions, and his failure to maintain clearance from wooded terrain in the area where he was maneuvering. Factors relating to the accident include: darkness, low ceiling, and high/mountainous…
- [NTSB LAX98LA025](https://openairdocs.org/ntsb/LAX98LA025.md): Ciernia GLASAIR-III · Desert Center, CA · Accident · No injuries · Limited investigation · Final report · Oct 11, 1997 · N153JC · Substantial damage
  > A loss of engine power due to the eventual loss of electrical power which resulted from the pilot's failure to ensure the alternator switch was on as specified in the before starting checklist. The inoperative alternator out warning light was a factor in this…
- [NTSB LAX98FA006](https://openairdocs.org/ntsb/LAX98FA006.md): Cessna 152 · Julian, CA · Accident · 1 fatal · Field investigation · Final report · Oct 11, 1997 · N67293 · Destroyed
  > The pilot's inadequate in-flight planning which resulted in VFR flight into instrument meteorological conditions and the loss of aircraft control. Contributing was the pilot's overconfidence in his ability, clouds, and rain.
- [NTSB CHI98LA016](https://openairdocs.org/ntsb/CHI98LA016.md): Piper PA-18-150 · Williston, ND · Accident · No injuries · Limited investigation · Final report · Oct 11, 1997 · N9691P · Substantial damage
  > the pilot's inadequate preflight planning/preparation, and his selection of an unsuitable area for landing. The adverse weather condition (low ceiling) and submerged object were related factors.
- [NTSB MIA98LA008](https://openairdocs.org/ntsb/MIA98LA008.md): Piper PA-18A-150 · Gulf Of Mexico · Accident · No injuries · Limited investigation · Final report · Oct 9, 1997 · N7198D · Substantial damage
  > loss of engine power for undetermined reason(s), which resulted in a forced landing (ditching) at sea.
- [NTSB CHI98LA012](https://openairdocs.org/ntsb/CHI98LA012.md): Hiller UH-12E · Liberty, NE · Accident · No injuries · Limited investigation · Final report · Oct 9, 1997 · N4027L · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CHI98LA011](https://openairdocs.org/ntsb/CHI98LA011.md): Piper PA-23-250 · Charlotte, MI · Accident · Minor injuries · Limited investigation · Final report · Oct 9, 1997 · N54738 · Substantial damage
  > improper positioning of the fuel selector by the second pilot, which resulted in fuel starvation; inadequate supervision by the pilot-in-command; and failure of the flight crew to follow the published emergency procedures for loss of engine power.
- [NTSB DCA98MA002](https://openairdocs.org/ntsb/DCA98MA002.md): Cessna 208B · Montrose, CO · Accident · 9 fatal · Major investigation · Final report · Oct 8, 1997 · N12022 · Destroyed
  > the pilot's failure to maintain sufficient airspeed for undetermined reasons while maneuvering the airplane near the maximum gross weight and aft cg in or near instrument meteorological conditions, resulting in the loss of control and entry into a stall/spin.…
- [NTSB MIA98FA007](https://openairdocs.org/ntsb/MIA98FA007.md): Beech 35-C33A · Robbins, NC · Accident · 3 fatal · Field investigation · Final report · Oct 7, 1997 · N2050W · 2 aircraft · Destroyed
  > failure of the pilots in both aircraft to see-and-avoid each other's airplane (inadequate visual lookout), and failure of the Beech pilot to operate his airplane at a correct Visual Flight Rules (VFR) cruising altitude for his route of flight.
- [NTSB FTW98LA007](https://openairdocs.org/ntsb/FTW98LA007.md): Beech G18S · Crosbyton, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1997 · N9312Y · Substantial damage
  > Inadequate maintenance which resulted in diminished carburetor heat effectiveness due to missing alternate air doors. Contributing were conducive carburetor icing weather conditions, low ceilings during the emergency descent, and the lack of suitable terrain…
- [NTSB CHI98FA017](https://openairdocs.org/ntsb/CHI98FA017.md): Beech G35 · Poplar Grove, IL · Accident · No injuries · Field investigation · Final report · Oct 6, 1997 · N129B · Substantial damage
  > flutter for an undetermined reason, which resulted in structural damage to the aft fuselage.
- [NTSB FTW98LA005](https://openairdocs.org/ntsb/FTW98LA005.md): Cessna 175A · Bentonville, AR · Accident · No injuries · Limited investigation · Final report · Oct 5, 1997 · N7091E · Destroyed
  > The partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.
- [NTSB NYC98LA005](https://openairdocs.org/ntsb/NYC98LA005.md): Cessna 120 · Mineral Wells, WV · Accident · No injuries · Limited investigation · Final report · Oct 4, 1997 · N76898 · Substantial damage
  > A loss of engine power to a blockage in the carburetor resulting in fuel starvation.
- [NTSB LAX98LA001](https://openairdocs.org/ntsb/LAX98LA001.md): Bell 47G-2 · Burbank, CA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1997 · N2483B · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB IAD98LA002](https://openairdocs.org/ntsb/IAD98LA002.md): Hughes 269A · Campbellsville, KY · Accident · No injuries · Limited investigation · Final report · Oct 3, 1997 · N269SS · Substantial damage
  > The pilot refueled the helicopter with jet fuel instead of avgas, which resulted in a loss of engine power. A related factor was the unsuitable terrain.
- [NTSB MIA98LA002](https://openairdocs.org/ntsb/MIA98LA002.md): McDonnell Douglas DC-9-82 · Cross City, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 2, 1997 · N33502 · No damage
  > The in-flight encounter with turbulence associated with a nearby level 6 thunderstorm with moderate rain while deviating.
- [NTSB CHI98LA004](https://openairdocs.org/ntsb/CHI98LA004.md): Piper PA-28R-200 · Nebraska City, NE · Accident · No injuries · Limited investigation · Final report · Oct 2, 1997 · N1092X · Substantial damage
  > the pilot's improper positioning of the fuel slector to a tank which contained only unusable fuel.
- [NTSB NYC98LA001](https://openairdocs.org/ntsb/NYC98LA001.md): Cessna T210L · Gt. Barrington, MA · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 1997 · N29134 · Substantial damage
  > slippage of the number 2 main bearing for undetermined reason(s) which resulted in a broken crankshaft.
- [NTSB FTW97LA371](https://openairdocs.org/ntsb/FTW97LA371.md): Siai-Marchetti F.260 · Santa Rosa, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1997 · N260MT · Substantial damage
  > improper planning/decision by the pilot, which led to fuel exhaustion, loss of engine power, and a forced landing. A related factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI97LA302](https://openairdocs.org/ntsb/CHI97LA302.md): Rans S-11 Pursuit · Hays, KS · Accident · Serious injuries · Limited investigation · Final report · Sep 29, 1997 · N4299Y · Substantial damage
  > failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall and collision with the terrain. The pilot's lack of experience in the make and model of airplane was a related factor.
- [NTSB FTW97LA367](https://openairdocs.org/ntsb/FTW97LA367.md): Beech 58 · Mora, NM · Accident · Serious injuries · Limited investigation · Final report · Sep 28, 1997 · N365C · Destroyed
  > loss of power in the right engine for undetermined reason(s). Related factors were: that the power loss occurred above the airplane's single engine service ceiling (at high density altitude), and the lack of suitable terrain for a forced landing.
- [NTSB ATL97LA143](https://openairdocs.org/ntsb/ATL97LA143.md): Piper PA-28-181 · Fulton, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 1997 · N35652 · Substantial damage
  > The excessively rich mixture produced by the carburetor, which led to the fuel exhaustion.
- [NTSB IAD97FA123](https://openairdocs.org/ntsb/IAD97FA123.md): Fairchild Hiller FH-1100 · Pittsfield, MA · Accident · 1 fatal · Field investigation · Final report · Sep 27, 1997 · N5045F · Destroyed
  > The first pilot's improper procedures for an autorotation, and improper flare which resulted in a hard landing. Also causal was the second pilot's inadequate remedial action.
- [NTSB ATL97LA142](https://openairdocs.org/ntsb/ATL97LA142.md): Beech 33 · Winston-Salem, NC · Accident · No injuries · Limited investigation · Final report · Sep 27, 1997 · N331DP · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing.

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

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

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