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

## Cases, newest first

- [NTSB LAX97LA116](https://openairdocs.org/ntsb/LAX97LA116.md): Beech J35 · Morristown, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 3, 1997 · N39W · Destroyed
  > failure of the crankshaft due to improper inspection/overhaul procedures.
- [NTSB CHI97LA078](https://openairdocs.org/ntsb/CHI97LA078.md): Boeing 757-2Q8 · Chicago, IL · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 1997 · N755AT · No damage
  > Clear air turbulence.
- [NTSB CHI97LA076](https://openairdocs.org/ntsb/CHI97LA076.md): Piper PA-28-235 · West Chicago, IL · Accident · Minor injuries · Limited investigation · Final report · Mar 2, 1997 · N9420W · Substantial damage
  > fuel starvation due to the pilot's improper fuel tank selection.
- [NTSB FTW97LA110](https://openairdocs.org/ntsb/FTW97LA110.md): Cessna 152 · Plaquemine, LA · Accident · 2 fatal · Limited investigation · Final report · Feb 28, 1997 · N49205 · Destroyed
  > The pilot's failure to maintain proper altitude and clearance from transmission wires. Factors were, the dark night, low cloud ceiling, and fog.
- [NTSB FTW97FA109](https://openairdocs.org/ntsb/FTW97FA109.md): Keating Quickie II · Houston, TX · Accident · 1 fatal · Field investigation · Final report · Feb 28, 1997 · N89WL · Destroyed
  > The loss of engine power due to fuel starvation as result of the pilot's improper fuel management. Factors were the pilot's lack of familiarity with the airplane, the dark night, the lack of cockpit lights, and the lack of suitable terrain for the pilot to…
- [NTSB MIA97LA087](https://openairdocs.org/ntsb/MIA97LA087.md): Cessna 310R · Calhoun, GA · Accident · Serious injuries · Limited investigation · Final report · Feb 27, 1997 · N72GL · Destroyed
  > The pilot-in-command's improper fuel management and improper positioning of the fuel selector valve to the empty fuel tank. Factors in the accident were: the PIC's improper in-flight planning and decision, his failure to list an alternate airport, and his…
- [NTSB LAX97LA112](https://openairdocs.org/ntsb/LAX97LA112.md): Boeing 767-300 · San Francisco, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 25, 1997 · N661UA · No damage
  > an encounter with unforecasted moderate clear air turbulence, while descending over mountainous terrain.
- [NTSB ANC97LA029](https://openairdocs.org/ntsb/ANC97LA029.md): Cessna 337C · Golovin, AK · Accident · No injuries · Limited investigation · Final report · Feb 25, 1997 · N2615S · Substantial damage
  > the pilot's continued flight into adverse weather conditions, and failure to maintain sufficient distance/altitude from terrain. Low ceiling, flat light condition, and the ice pressure ridge were related factors.
- [NTSB IAD97LA051](https://openairdocs.org/ntsb/IAD97LA051.md): Hughes 369HS · Marion, OH · Accident · No injuries · Limited investigation · Final report · Feb 24, 1997 · N340EM · Substantial damage
  > Uncovering of the fuel tanks outlet, which resulted in fuel starvation and subsequent loss of engine power. A related factor was the unsuitable terrain.
- [NTSB CHI97IA074](https://openairdocs.org/ntsb/CHI97IA074.md): de Havilland DHC-8-311 · Rapid City, SD · Incident · No injuries · Incident investigation · Final report · Feb 24, 1997 · N430AW · No damage
  > a missing 'C' clip, which resulted in the master link coming apart, allowing the electric elevator trim chain and cable to become entangled in the elevator trim cables.
- [NTSB ATL97LA044](https://openairdocs.org/ntsb/ATL97LA044.md): Cessna 150 · Raleigh, NC · Accident · No injuries · Limited investigation · Final report · Feb 23, 1997 · N714JY · Substantial damage
  > a loose fuel capd and siphoning of fuel, resulting in fuel exhaustion and a loss of engine power. A factor was the rough terrain in the forced landing field that resulted in the nose over during the landing roll.
- [NTSB SEA97LA061](https://openairdocs.org/ntsb/SEA97LA061.md): Luscombe 8A · Morgan, UT · Accident · No injuries · Limited investigation · Final report · Feb 22, 1997 · N77947 · Substantial damage
  > Disconnection of the mixture control wire wound cable sheath. A factor was the abrupt, elevated edge of the highway pavement.
- [NTSB SEA97LA063](https://openairdocs.org/ntsb/SEA97LA063.md): Maule M-5-180 · Jordan Valley, OR · Accident · No injuries · Limited investigation · Final report · Feb 21, 1997 · N5652W · Substantial damage
  > failure of the pilot to maintain directional control of the aircraft, while landing. Factors relating to the accident included: the pilot's improper inflight decision to attempt a descent through what appeared to be a hole in the clouds, his inadvertent…
- [NTSB LAX97FA107](https://openairdocs.org/ntsb/LAX97FA107.md): Hughes 369D · Milolii, HI · Accident · Serious injuries · Field investigation · Final report · Feb 21, 1997 · N505RM · Substantial damage
  > failure of the tail rotor for undetermined reason(s), resulting in tail rotor imbalance, separation of the tail rotor, and an autorotative landing on rough terrain with high vegetation. The lack of suitable terrain for a forced landing was a related factor.
- [NTSB CHI97IA073](https://openairdocs.org/ntsb/CHI97IA073.md): de Havilland DHC-8-102 · Romulus, MI · Incident · No injuries · Incident investigation · Final report · Feb 20, 1997 · N828MA · No damage
  > a fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…
- [NTSB CHI97IA072](https://openairdocs.org/ntsb/CHI97IA072.md): McDonnell Douglas DC-9-15 · Des Moines, IA · Incident · No injuries · Incident investigation · Final report · Feb 20, 1997 · N93S · Minor damage
  > the cross tie relay shorted resulting in a fire in the left main electrical equipment rack.
- [NTSB CHI97FAMS1](https://openairdocs.org/ntsb/CHI97FAMS1.md): Cessna T210N · Chicago, IL · Accident · 2 fatal · Missing aircraft · Final report · Feb 20, 1997 · N7134J · Destroyed
  > Undetermined.
- [NTSB FTW97LA106](https://openairdocs.org/ntsb/FTW97LA106.md): Cessna 172 · Rogers, AR · Accident · Serious injuries · Limited investigation · Final report · Feb 15, 1997 · N1419Y · Substantial damage
  > the pilot's improper fuel consumption calculations, which resulted in the loss of engine power, due to fuel exhaustion. A factor relating to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB LAX97LA103](https://openairdocs.org/ntsb/LAX97LA103.md): Cessna 172F · San Pablo Bay, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 1997 · N3757F · Substantial damage
  > total loss of engine power due to carburetor icing and the pilot's failure to use carburetor heat.
- [NTSB LAX97LA102](https://openairdocs.org/ntsb/LAX97LA102.md): Green Cozy III · San Martin, CA · Accident · No injuries · Limited investigation · Final report · Feb 11, 1997 · N34PC · Substantial damage
  > A loss of engine power due to fuel contamination. A factor in the accident is the aircraft design, which routes hydraulic lines through the fuel tank.
- [NTSB MIA97LA083](https://openairdocs.org/ntsb/MIA97LA083.md): Cessna 210L · Weston, FL · Accident · No injuries · Limited investigation · Final report · Feb 10, 1997 · N115WL · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was thew lack of suitable terrain for the forced landing.
- [NTSB NYC97LA051](https://openairdocs.org/ntsb/NYC97LA051.md): Piper PA-44-180T · Caldwell, NJ · Accident · 1 fatal · Limited investigation · Final report · Feb 9, 1997 · N8457H · No damage
  > The pilot's incapacitation due to a heart attack.
- [NTSB MIA97FA082](https://openairdocs.org/ntsb/MIA97FA082.md): Cessna 402C · St. Thomas · Accident · 2 fatal · Field investigation · Final report · Feb 8, 1997 · N318AB · Destroyed
  > The failure of the pilot to maintain altitude while making a visual approach at night over water in black hole conditions resulting in the aircraft descending and crashing into the sea. Contributing to the accident was the failure of the pilot and operator to…
- [NTSB ATL97LA039](https://openairdocs.org/ntsb/ATL97LA039.md): Cessna 152 · Gulfport, MS · Accident · No injuries · Limited investigation · Final report · Feb 7, 1997 · N93873 · Substantial damage
  > the pilot's inadequate preflight planning/preparation, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of fuel.
- [NTSB ATL97LA037](https://openairdocs.org/ntsb/ATL97LA037.md): Cessna 152 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Feb 6, 1997 · N67544 · Substantial damage
  > A loss of engine power for undetermined reasons, and the abrupt maneuver that resulted in an aerodynamic stall. A factor was the pilot's failure to maintain clearance from the power lines.
- [NTSB ANC97LA025](https://openairdocs.org/ntsb/ANC97LA025.md): Piper PA-22 · Skwentna, AK · Accident · 3 fatal · Limited investigation · Final report · Feb 1, 1997 · N7235D · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, and subsequent failure to maintain control of the airplane. Factors associated with the accident are the pilot's inadequate weather evaluation, his becoming lost/disoriented, and…
- [NTSB ATL97IA035](https://openairdocs.org/ntsb/ATL97IA035.md): Boeing 757-232 · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Jan 31, 1997 · N611DL · Minor damage
  > failure of the Stage 1 High Pressure Turbine due to a fatigue fracture in a disk blade retention lug.
- [NTSB FTW97LA095](https://openairdocs.org/ntsb/FTW97LA095.md): Piper PA-38-112 · Boswell, OK · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 1997 · N2493A · Substantial damage
  > The student pilot's improper inflight planning and decision, after becoming lost/disoriented, which resulted in fuel exhaustion, before landing in a suitable landing area. Factors relating to the accident were: the pilot of another aircraft did not accurately…
- [NTSB ANC97FA024](https://openairdocs.org/ntsb/ANC97FA024.md): de Havilland DHC-4A · Sparrevohn, AK · Accident · 1 fatal · Field investigation · Final report · Jan 30, 1997 · N702SC · Destroyed
  > loss of the right engine propeller control oil, which led to an overspeed of the right engine and propeller, and necessitated a shut-down of the right engine; and failure of the pilot to maintain adequate altitude/distance from terrain during visual approach…
- [NTSB FTW97FA092](https://openairdocs.org/ntsb/FTW97FA092.md): Beech 95-B55 · Mayhill, NM · Accident · 3 fatal · Field investigation · Final report · Jan 28, 1997 · N47SM · Destroyed
  > The pilot's failure to maintain clearance with trees and terrain. Factors were the mountainous terrain, the snow obscuring the visibility, the dark night illumination, and the pilot's fatigue.
- [NTSB CHI97LA060](https://openairdocs.org/ntsb/CHI97LA060.md): McDonnell Douglas DC-9-51 · Cape Girardeau, MO · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 1997 · N414EA · No damage
  > clear air turbulence encountered by the flight.
- [NTSB NYC97FA048](https://openairdocs.org/ntsb/NYC97FA048.md): Cessna 172F · Conrad, PA · Accident · 1 fatal · Field investigation · Final report · Jan 25, 1997 · N8835U · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and spatial disorientation of the pilot, which led to loss of aircraft control, an uncontrolled descent, and subsequent collision with wooded terrain. Factors relating to the accident…
- [NTSB MIA97LA075](https://openairdocs.org/ntsb/MIA97LA075.md): Aerospatiale SA315B · Whiteville, NC · Accident · No injuries · Limited investigation · Final report · Jan 25, 1997 · N707EX · Substantial damage
  > The pilot's intentional operation of the helicopter with known deficiencies in equipment and a false indication of the fuel gauge, resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was inadequate maintenance of…
- [NTSB FTW97LA088](https://openairdocs.org/ntsb/FTW97LA088.md): Beech B90 · Longmont, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1997 · N76GM · Destroyed
  > Failure of the pilot to refuel the airplane, resulting in fuel exhaustion. Factors were the pilot's reference to similar but different aircraft performance charts, and the operator's failure to provide the pilot with the proper performance charts.
- [NTSB MIA97FA070](https://openairdocs.org/ntsb/MIA97FA070.md): Bell 206-B3 · Fort Lauderdale, FL · Accident · 4 fatal · Field investigation · Final report · Jan 23, 1997 · N2047R · Destroyed
  > The pilot's incapacitation by carbon monoxide from undetermined sources which led to his diminished ability to see and avoid a radio tower.
- [NTSB LAX97FA093](https://openairdocs.org/ntsb/LAX97FA093.md): Cessna R172K · Bagdad, AZ · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1997 · N736WZ · Destroyed
  > continued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from terrain. Factors relating to the accident were: the high/mountainous terrain and adverse weather conditions.
- [NTSB FTW97IA084](https://openairdocs.org/ntsb/FTW97IA084.md): Boeing 727-100 · Oklahoma City, OK · Incident · No injuries · Incident investigation · Final report · Jan 22, 1997 · N198FE · No damage
  > existence of fumes from the cargo compartment and activation of the cargo smoke detector for undetermined reasons.
- [NTSB CHI97FA056](https://openairdocs.org/ntsb/CHI97FA056.md): Cessna 210N · Highland, MI · Accident · 2 fatal · Field investigation · Final report · Jan 21, 1997 · N29WW · Destroyed
  > in-flight breakup of the airplane for undetermined reason(s).
- [NTSB MIA97LA068](https://openairdocs.org/ntsb/MIA97LA068.md): Stinson 108 · Winter Haven, FL · Accident · No injuries · Limited investigation · Final report · Jan 20, 1997 · N97108 · Substantial damage
  > Failure of the pilot to use carburetor heat for descent resulting in engine failure due to carburetor induction icing.
- [NTSB MIA97LA066](https://openairdocs.org/ntsb/MIA97LA066.md): Cessna 172P · Fort Lauderdale, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 19, 1997 · N136FR · Substantial damage
  > Failure of other maintenance personnel to properly torque a connecting rod bolt and nut for the No. 3 cylinder during engine overhaul.
- [NTSB NYC97LA046](https://openairdocs.org/ntsb/NYC97LA046.md): Piper PA-28R-200 · Thorndale, PA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1997 · N57010 · Substantial damage
  > Inadequate overhaul of the crankshaft that failed to detect fatigue cracks, which resulted in a total loss of engine power when the crankshaft separated in two.
- [NTSB MIA97LA065](https://openairdocs.org/ntsb/MIA97LA065.md): Piper PA-32-300 · Boca Raton, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 17, 1997 · N2816M · Substantial damage
  > Improper overhaul of the left magneto which resulted in a defect in the left magneto rotating magnet to go undetected which caused the magneto to stop rotating and break several teeth from engine crankshaft gears and disconnect the crankshaft drive gear.
- [NTSB IAD97FA043](https://openairdocs.org/ntsb/IAD97FA043.md): Piper PA-28-236 · Alton, NH · Accident · 2 fatal · Field investigation · Final report · Jan 17, 1997 · N8263Y · Destroyed
  > An exhaust gas leak, due to inadequate maintenance, which resulted in carbon monoxide poisoning, and incapacitation of the pilot.
- [NTSB FTW97LA085](https://openairdocs.org/ntsb/FTW97LA085.md): Cessna 172N · Steamboat Spgs, CO · Accident · No injuries · Limited investigation · Final report · Jan 17, 1997 · N739QE · Destroyed
  > Failure of the flight instructor and the dual student to maintain an adequate visual lookout. Factors were the flight instructor's inadequate supervision of the flight, inadequate altitude in which to clear obstacles, and the dual student's lack of…
- [NTSB ANC97LA022](https://openairdocs.org/ntsb/ANC97LA022.md): Cessna 207A · Tununak, AK · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 1997 · N9603M · Substantial damage
  > the pilot's decision to continue VFR flight into instrument meteorological conditions (IMC), and his failure to maintain clearance from rising terrain. Factors associated with the accident were: low ceiling, fog, rising terrain, and the pilot's inadequate…
- [NTSB MIA97LA062](https://openairdocs.org/ntsb/MIA97LA062.md): Waco UPF-7 · Sanibel, FL · Accident · No injuries · Limited investigation · Final report · Jan 14, 1997 · N29986 · Substantial damage
  > A partial loss of engine power (rough running engine) for undetermined reason.
- [NTSB LAX97FA089](https://openairdocs.org/ntsb/LAX97FA089.md): Beech F33A · Mt San Jacinto, CA · Accident · 2 fatal · Field investigation · Final report · Jan 13, 1997 · N31706 · Destroyed
  > continued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude or clearance from mountainous terrain. Factors relating to the accident were: the high/mountainous terrain, and the adverse weather…
- [NTSB CHI97LA052](https://openairdocs.org/ntsb/CHI97LA052.md): Piper PA-24-250 · Franklin, MN · Accident · No injuries · Limited investigation · Final report · Jan 13, 1997 · N6495P · Substantial damage
  > The pilot's inadequate inflight planning and his fuel mismanagement, which resulted in fuel exhaustion and the loss of engine power. A contributing factor with this accident was a frost blocked cockpit windshield.
- [NTSB SEA97LA048](https://openairdocs.org/ntsb/SEA97LA048.md): Piper PA-28-161 · Sun River, OR · Accident · Minor injuries · Limited investigation · Final report · Jan 12, 1997 · N8414B · Substantial damage
  > inadvertent VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain altitude/clearance above moutainous/wooded terrain. Factors relating to the accident were: darkness, adverse weather conditions, and the proximity…
- [NTSB LAX97FA086](https://openairdocs.org/ntsb/LAX97FA086.md): Enstrom F28A · Saipan Island, Sark · Accident · 2 fatal · Field investigation · Final report · Jan 12, 1997 · N9087 · Destroyed
  > loss of engine power due to fuel exhaustion, resulting from improper planning/decision; and the pilot's abrupt handling of the flight controls, while maneuvering to avoid swimmers, which resulted in main rotor blade contact with the tail boom. A related…

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

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

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