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

## Cases, newest first

- [NTSB DEN92LA022](https://openairdocs.org/ntsb/DEN92LA022.md): Cessna 150E · Glenwood, NM · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1991 · N306BJ · Destroyed
  > Partial failure of the spark plugs. Factors were inadequate annual inspection and unsuitable mountainous terrain.
- [NTSB ATL92FA033](https://openairdocs.org/ntsb/ATL92FA033.md): Beech C23 · Lineville, AL · Accident · 2 fatal · Field investigation · Final report · Dec 29, 1991 · N9304S · Destroyed
  > The pilot continued VFR into IMC conditions where he collided with trees and terrain. Factors in this accident were: low clouds, obscured terrain, and the pilot's inadequate prelflight planning.
- [NTSB CHI92LA063](https://openairdocs.org/ntsb/CHI92LA063.md): Cessna 152 · Alpha, IL · Accident · Minor injuries · Limited investigation · Final report · Dec 26, 1991 · N106CF · Substantial damage
  > Inadequate preflight planning and refueling not performed by the pilot.
- [NTSB ATL92FA031](https://openairdocs.org/ntsb/ATL92FA031.md): Beech 58TC · Bluffton, SC · Accident · 5 fatal · Field investigation · Final report · Dec 26, 1991 · N6588S · Destroyed
  > The pilot's failure to maintain minimum controllable airspeed after a reported engine power loss, resulting in a loss of aircraft control. A factor was the loss of power on the left engine. The reason for the left engine power loss could not be determined.
- [NTSB MIA92FA051](https://openairdocs.org/ntsb/MIA92FA051.md): Piper PA-34-200T · Rainbow Lake, FL · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1991 · N47506 · Destroyed
  > The pilot in command's improper inflight decision to divert her attention to other activities not related to the conduct of the flight. Contributing to the accident was the exceeding of the design limits of the airplane leading to a wing failure.
- [NTSB ANC92FA022](https://openairdocs.org/ntsb/ANC92FA022.md): Cessna 207 · Mcgrath, AK · Accident · 1 fatal · Field investigation · Final report · Dec 22, 1991 · N6390H · Destroyed
  > The pilot in command's improper inflight planning/decision and his attempt to fly VFR through IMC conditions. Factors contributing to the accident were the snow, whiteout conditions, and darkness.
- [NTSB DEN92FA016](https://openairdocs.org/ntsb/DEN92FA016.md): Cessna 210M · Albuquerque, NM · Accident · 1 fatal · Field investigation · Final report · Dec 18, 1991 · N1231M · Destroyed
  > Insufficient terrain clearance altitude selected by the pilot in command.
- [NTSB CHI92FA059](https://openairdocs.org/ntsb/CHI92FA059.md): Cessna 172N · Cumberland, WI · Accident · 4 fatal · Field investigation · Final report · Dec 17, 1991 · N73920 · Destroyed
  > Failure to maintain aircraft control by the pilot in commnd. Factors in the accident are the pilot's continued flight into known adverse weather, a blocked pitot static system, lack of total expereince in type of operation, and lack of total expereince in…
- [NTSB NYC92DEG01](https://openairdocs.org/ntsb/NYC92DEG01.md): Devenport EAA Biplane · Wilksville, OH · Accident · Minor injuries · Final report · Dec 16, 1991 · N9601 · Substantial damage
  > The restricted visibility of the pilot due to oil on the windshield and his goggles, which resulted in a tree strike and uncontrolled touchdown, during the execution of a precautionary landing. Factors related to the accident were a clogged crankcase breather…
- [NTSB FTW92LA046](https://openairdocs.org/ntsb/FTW92LA046.md): Piper PA-28-180 · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Dec 15, 1991 · N6392J · Substantial damage
  > The pilot's selection of unsuitable terrain. Factors were the fuel starvation and the tough terrain.
- [NTSB SEA92LA028](https://openairdocs.org/ntsb/SEA92LA028.md): Cessna C-172G · Jackson, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 1991 · N4244L · Destroyed
  > Loss of control due to the pilot's failure to maintain proper airspeed. Factors relating to the accident were the improper flap setting, the high density altitude, mountainous terrain, lack of experience by the pilot, and downdrafft winds.
- [NTSB FTW92FA045](https://openairdocs.org/ntsb/FTW92FA045.md): Beech C23 · Dewitt, AR · Accident · 4 fatal · Field investigation · Final report · Dec 14, 1991 · N6012C · Destroyed
  > The pilot's attempt to land in IMC conditions and her subsequent loss of control during climb out due to spatial disorientation. A factor was the pilot's disregard of the pre-flight weather briefing.
- [NTSB MIA92LA044](https://openairdocs.org/ntsb/MIA92LA044.md): Cessna 150H · Valdosta, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 13, 1991 · N6680S · Substantial damage
  > The pilot-in-command's improper in-flight decision to continue flight into deteriorating weather conditions. Contributing to the accident was the pilot's overconfidence in his personal ability to fly in instrument conditions.
- [NTSB CHI92LA058](https://openairdocs.org/ntsb/CHI92LA058.md): Cessna 150 · Charlestown, IN · Accident · No injuries · Limited investigation · Final report · Dec 13, 1991 · N60040 · Substantial damage
  > Fuel exhaustion. Factors related to the accident were inadequate maintenance of the airplane and the pilot's decision to fly an airplane with known mechanical deficiencies.
- [NTSB ANC92FA083](https://openairdocs.org/ntsb/ANC92FA083.md): Piper PA-31T3, T1040 · Ninilchik, AK · Accident · 1 fatal · Field investigation · Final report · Dec 13, 1991 · N307SC · Destroyed
  > Undetermined.
- [NTSB NYC92LA045](https://openairdocs.org/ntsb/NYC92LA045.md): Cessna 152 · Orford, NH · Accident · No injuries · Limited investigation · Final report · Dec 11, 1991 · N48156 · Substantial damage
  > The student pilot became lost and disoriented.
- [NTSB LAX92LA063](https://openairdocs.org/ntsb/LAX92LA063.md): Piper PA34-200T · San Andreas, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 11, 1991 · N6522F · Destroyed
  > The failure of the nonmultiengine/instrument rated pilot in command to accomplish the proper emergency procedure during a loss of engine power. Contributing to the accident was the pilot's improper training, lack of instrument experience, heavy fog reported…
- [NTSB DCA92MA011](https://openairdocs.org/ntsb/DCA92MA011.md): Beech 400 · Rome, GA · Accident · 9 fatal · Major investigation · Final report · Dec 11, 1991 · N25BR · Destroyed
  > The captain's decision to initiate visual flight into an area of known mountainous terrain and low ceilings and the failure of the flightcrew to maintain awareness of their proximity to the terrain.
- [NTSB CHI92LA051](https://openairdocs.org/ntsb/CHI92LA051.md): Luscombe 8-F · Chapin, IA · Accident · No injuries · Limited investigation · Final report · Dec 11, 1991 · N1871B · Substantial damage
  > Failed connecting rod which resulted in a catastrophic engine failure. A factor related to the accident was unsuitable terrain.
- [NTSB CHI92FA053](https://openairdocs.org/ntsb/CHI92FA053.md): Piper PA-24-250 · Berrien Springs, MI · Accident · 1 fatal · Field investigation · Final report · Dec 11, 1991 · N6919P · Destroyed
  > The pilot-in-command's (cfi's) poor in-flight planning/decision-making and misjudged fuel supply/consumption. A related factor is overconfidence in personal ability.
- [NTSB NYC92FA044](https://openairdocs.org/ntsb/NYC92FA044.md): MBB BO-105CBS · De Ruyter, NY · Accident · 3 fatal · Field investigation · Final report · Dec 10, 1991 · N750H · Destroyed
  > An inflight collision with terrain after the pilot experienced spatial disorientation. Factors related to the accident were the night conditions, and the lack of visual cues.
- [NTSB NYC92LA043](https://openairdocs.org/ntsb/NYC92LA043.md): Cessna 177B · Dalmatia, PA · Accident · No injuries · Limited investigation · Final report · Dec 8, 1991 · N30832 · Destroyed
  > The pilot's failure to maintain proper altitude and object clearance which resulted in a collision with power lines.
- [NTSB MIA92LA040](https://openairdocs.org/ntsb/MIA92LA040.md): Piper PA-32RT-300T · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Dec 8, 1991 · N22213 · Substantial damage
  > Total loss of engine power for undetermined reasons.
- [NTSB LAX92LA057](https://openairdocs.org/ntsb/LAX92LA057.md): Piper PA-34-200T · Pine Valley, CA · Accident · 1 fatal · Limited investigation · Final report · Dec 8, 1991 · N36506 · Destroyed
  > The pilot's failure to monitor the proper altitude over obserable rising terrain. A contributing factor was the pilot's encounter with a strong downdraft.
- [NTSB FTW92LA039](https://openairdocs.org/ntsb/FTW92LA039.md): Cessna 152 · Las Cruces, NM · Accident · Minor injuries · Limited investigation · Final report · Dec 8, 1991 · N4628Q · Substantial damage
  > The pilot's misjudgment of the airplane's performance which led to a situation where it could not climb above the rising terrain. A factor was the high density altitude which existed in the mountains at the time of the accident.
- [NTSB SEA92LA027](https://openairdocs.org/ntsb/SEA92LA027.md): Beech 35 · Klamath Falls, OR · Accident · Serious injuries · Limited investigation · Final report · Dec 7, 1991 · N3323V · Substantial damage
  > Pilot factor in that he failed to follow IFR procedures. Factors to the accident were generator failure, operation with known deficiencies with equipment, and poor inflight planning.
- [NTSB SEA92FA026](https://openairdocs.org/ntsb/SEA92FA026.md): Cessna 172P · Snohomish, WA · Accident · 7 fatal · Field investigation · Final report · Dec 7, 1991 · N65831 · 2 aircraft · Destroyed
  > A visual lookout was not maintained.
- [NTSB NYC92IA042](https://openairdocs.org/ntsb/NYC92IA042.md): Airbus Industrie A-310-324 · Covington, KY · Incident · No injuries · Incident investigation · Final report · Dec 7, 1991 · N819PA · No damage
  > The installation of an improper restrictor in the bleed air line by the manufacturer, which caused the rvdt to fail due to heat, and brought about the uncommanded power loss.
- [NTSB ATL92FA029](https://openairdocs.org/ntsb/ATL92FA029.md): Aerospatiale AS350D Astar · Fuquay-Varina, NC · Accident · 3 fatal · Field investigation · Final report · Dec 7, 1991 · N26FH · Destroyed
  > The pilot's improper decision in continuing the flight with a known engine problem, and the subsequent seizure of the number two engine bearing, resulting in engine stoppage. Darkness was a related factor.
- [NTSB MIA92LA039](https://openairdocs.org/ntsb/MIA92LA039.md): Piper PA-28-140 · Lawrenceville, GA · Accident · No injuries · Limited investigation · Final report · Dec 6, 1991 · N7411J · Destroyed
  > The separation of numbers 1,2, and 3 connecting rods for undetermined reasons resulting in loss of engine power.
- [NTSB DEN92LA011](https://openairdocs.org/ntsb/DEN92LA011.md): Piper PA-22-135 · Siebert, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1991 · N3745A · Substantial damage
  > Total loss of engine power due to a plugged vent in the tank filler cap, resulting in fuel starvation. Factors related to the accident were: darkness and the lack of suitable terrain for a forced landing.
- [NTSB FTW92LA031](https://openairdocs.org/ntsb/FTW92LA031.md): Cessna 210 · Groves, TX · Accident · No injuries · Limited investigation · Final report · Dec 1, 1991 · N9503T · Substantial damage
  > Fuel exhaustion which precipitated the forced landing due to the pilot's inadequate fuel consumption calculations. A factor in the accident was the pilot's failure to divert to an alternate destination when he recognized that fuel exhaustion was a possibility.
- [NTSB DEN92IA013](https://openairdocs.org/ntsb/DEN92IA013.md): Cessna T210M · La Veta, CO · Incident · No injuries · Incident investigation · Final report · Dec 1, 1991 · N6179N · Minor damage
  > Failure of the no 1 connecting rod due to lack of lubrication from blocked oil ports.
- [NTSB CHI92LA039](https://openairdocs.org/ntsb/CHI92LA039.md): Piper PA-28-140 · Carthage, MO · Accident · No injuries · Limited investigation · Final report · Dec 1, 1991 · N9533W · Substantial damage
  > Continued flight by the pilot into known icing conditions, and his improper planning/decision, which resulted in an overrun of the runway after he diverted to an alternate airport. The adverse weather condition, icy runway, and chain link fence near the end…
- [NTSB SEA92FA024](https://openairdocs.org/ntsb/SEA92FA024.md): Piper PA-24-250 · Everett, WA · Accident · Serious injuries · Field investigation · Final report · Nov 30, 1991 · CFKTQ · Substantial damage
  > Fuel starvation due to improper procedures by the pilot-in-command. Factors include lack of familiarity with the aircraft, non-functioning flight compartment lights, and non-suitable terrain.
- [NTSB MIA92LA036](https://openairdocs.org/ntsb/MIA92LA036.md): Cessna 210M · Zephyrhills, FL · Accident · No injuries · Limited investigation · Final report · Nov 30, 1991 · N9064M · Substantial damage
  > Improper placement of the fuel selector by the pilot-in-command resulting in the total loss of engine power due to fuel starvation. Contributing to the accident was an incorrect fuel quantity gage, the dark night condition, and unsuitable terrain encountered.
- [NTSB FTW92LA030](https://openairdocs.org/ntsb/FTW92LA030.md): Cessna 182F · Morse, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 29, 1991 · N37749 · Substantial damage
  > The pilot's attempted VFR flight into IMC conditions. Factors were, the pilot's lack of instrument qualification, his failure to obtain a weather briefing prior to the flight, and dark night conditions.
- [NTSB FTW92FA029](https://openairdocs.org/ntsb/FTW92FA029.md): Cessna 402B · Roanoke, TX · Accident · Serious injuries · Field investigation · Final report · Nov 29, 1991 · N69CR · Destroyed
  > The operation of the airplane with known deficiencies, a missing air cooling baffle, and inadequate maintenance. Factors were the frozen propeller, inability of the pilot to feather the propeller, inoperative landing gear, the inability of the pilot to…
- [NTSB NYC92LA038](https://openairdocs.org/ntsb/NYC92LA038.md): Cessna 152 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Nov 28, 1991 · N25262 · Substantial damage
  > The student pilot's improper preflight and planning which resulted in fuel system exhaustion and a forced landing on unsuitable terrain. A factor related to the accident was the pilot's lack of total experience.
- [NTSB NYC92LA037](https://openairdocs.org/ntsb/NYC92LA037.md): Convair CV-240 · Akron, OH · Accident · Minor injuries · Limited investigation · Final report · Nov 28, 1991 · N450GA · Destroyed
  > The use of an improper grade of fuel, which was approved by the captain and resulted in a loss of engine power duirng climbout and an in flight collision with terrain.
- [NTSB LAX92FA054](https://openairdocs.org/ntsb/LAX92FA054.md): Aerospatiale SA 316B · Bridgeport, CA · Accident · 4 fatal · Field investigation · Final report · Nov 28, 1991 · N146RM · Destroyed
  > Failure of the helicopter's tail rotor drive shaft and drive shaft bearing due to undetermined reason(s).
- [NTSB CHI92FA035](https://openairdocs.org/ntsb/CHI92FA035.md): Cessna 172RG · Litchfield, MN · Accident · 4 fatal · Field investigation · Final report · Nov 27, 1991 · N9589B · Destroyed
  > Pilot factor in that he had spatial disorientation. Factors related to the accident are; VFR flight into IMC, disregarding hazardous weather advisories, performing flight into known adverse weather conditions, and overconfidence in personal ability by the…
- [NTSB LAX92LA051](https://openairdocs.org/ntsb/LAX92LA051.md): Cessna 172M · Saipan, Sark · Accident · No injuries · Limited investigation · Final report · Nov 26, 1991 · N733PB · Destroyed
  > A loss of engine power due to carburetor icing and the failure of the pilot to correctly use carburetor heat.
- [NTSB ATL92FA026](https://openairdocs.org/ntsb/ATL92FA026.md): Cessna 210H · Carrollton, GA · Accident · Minor injuries · Field investigation · Final report · Nov 25, 1991 · N65SD · Substantial damage
  > The contamination of the aircraft fuel system with ice and water, which was undetectable by the pilot.
- [NTSB NYC92LA036](https://openairdocs.org/ntsb/NYC92LA036.md): Piper PA-31-T1040 · Portland, ME · Accident · No injuries · Limited investigation · Final report · Nov 24, 1991 · N24894 · Substantial damage
  > The excessive fuel pressure during inflight fuel transferring, which resulted in the rupture of the wing tank and subsequent damage to the wing. Also causal to the accident was the inadequate fuel tank vent system and the inaccurate fuel quantity system.
- [NTSB SEA92LA023](https://openairdocs.org/ntsb/SEA92LA023.md): Kitfox Ten Model 2 · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · Nov 23, 1991 · N66257 · Substantial damage
  > The loss of engine power when it overheated due to low coolant level, which resulted from the inadequate preflight inspection by the pilot. A factor relating to the accident was the obstruction in the landing area.
- [NTSB MIA92LA038](https://openairdocs.org/ntsb/MIA92LA038.md): Piper PA-20 · Hilliard, FL · Accident · No injuries · Limited investigation · Final report · Nov 23, 1991 · N7304K · Substantial damage
  > Partial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the forced landing. Contributing to the accident was the low ceiling encountered and reduced in-flight planning decision time by the pilot-in-command.
- [NTSB CHI92LA033](https://openairdocs.org/ntsb/CHI92LA033.md): Cessna 172P · Marquette, MI · Accident · Serious injuries · Limited investigation · Final report · Nov 23, 1991 · N96147 · Destroyed
  > Flight into known adverse weather conditions by the pilot, which resulted in airframe (wing) icing and the inability to maintain altitude. The adverse weather conditions and darkness were related factors.
- [NTSB MIA92LA033](https://openairdocs.org/ntsb/MIA92LA033.md): Grumman AA-1C · Lantana, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1991 · N9783U · Substantial damage
  > The improper maintenance assembly and inspection of the throttle linkage which resulted in the throttle linkage becoming disconnected in flight and subsequent loss of engine power.
- [NTSB LAX92LA050](https://openairdocs.org/ntsb/LAX92LA050.md): Speyer Avid Amphibian · San Ysidro, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 22, 1991 · N118A · Destroyed
  > Failure of the pilot/builder to follow the manufacturer's recommended airframe modification procedure to prevent the inflight loss of a flaperon due to flutter. Contributing to the accident was in inflight separation of the wing when the design limits of the…

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

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

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