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

## Cases, newest first

- [NTSB MIA90FA017](https://openairdocs.org/ntsb/MIA90FA017.md): Cessna 150L · Columbia, MS · Accident · 1 fatal · Field investigation · Final report · Oct 25, 1989 · N19007 · Destroyed
  > Suicide. The pilot's emotional state of distress was a related factor.
- [NTSB LAX90LA011](https://openairdocs.org/ntsb/LAX90LA011.md): Cessna 150L · Marana, AZ · Accident · No injuries · Limited investigation · Final report · Oct 25, 1989 · N642EZ · Substantial damage
  > Failure of the pilot to properly judge his fuel supply, which resulted in fuel exhaustion.
- [NTSB ATL90LA013](https://openairdocs.org/ntsb/ATL90LA013.md): Cessna 152 · Kinston, NC · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1989 · N67318 · Substantial damage
  > The pilot's decision to depart for his destination airport with less than required fuel, and his improper use of the communications radio which resulted in his circling the airport and exhausting all fuel.
- [NTSB LAX90FA016](https://openairdocs.org/ntsb/LAX90FA016.md): Cessna 177 · So Lake Tahoe, CA · Accident · 3 fatal · Field investigation · Final report · Oct 24, 1989 · N30228 · Destroyed
  > The pilot's decision to continue VFR flight after encountering instrument meteorological conditions.
- [NTSB MKC90LA015](https://openairdocs.org/ntsb/MKC90LA015.md): Cessna 150 · Cherokee Vill, AR · Accident · No injuries · Limited investigation · Final report · Oct 23, 1989 · N704SZ · Substantial damage
  > The pilots failure to use carburetor heat properly. Contributing to the accident were the carburetor icing conditions.
- [NTSB FTW90LA012](https://openairdocs.org/ntsb/FTW90LA012.md): Cessna 170B · New Boston, TX · Accident · No injuries · Limited investigation · Final report · Oct 23, 1989 · N8188A · Substantial damage
  > A loss of engine power for undetermined reasons. The dirt bank contacted during the landing is considered to be contributing factor.
- [NTSB LAX90FA010](https://openairdocs.org/ntsb/LAX90FA010.md): Beech V35 · Goleta, CA · Accident · 1 fatal · Field investigation · Final report · Oct 22, 1989 · N288BH · Destroyed
  > The pilot's attempt to conduct visual flight into adverse weather conditions at an altitude that would not provide terrain clearance. The weather condition was a related factor.
- [NTSB FTW90LA014](https://openairdocs.org/ntsb/FTW90LA014.md): Cessna T-337G-P · Laredo, TX · Accident · No injuries · Limited investigation · Final report · Oct 22, 1989 · N21GC · Substantial damage
  > Double engine failure due to fuel exhaustion. The fuel exhaustion was caused by incorrect inflight fuel consumption calculations and one inaccurate fuel quanity gauge. Contributing to the accident was the dark night restriction to visibility.
- [NTSB CHI90LA017](https://openairdocs.org/ntsb/CHI90LA017.md): De Havilland DH82A · Mascoutah, IL · Accident · No injuries · Limited investigation · Final report · Oct 22, 1989 · N100MH · Substantial damage
  > An undetermined powerplant problem, which resulted in a severe vibration. The soft/uneven terrain was considered to be a contributing factor.
- [NTSB MKC90LA011](https://openairdocs.org/ntsb/MKC90LA011.md): Cessna 172Q · Hiwasse, AR · Accident · No injuries · Limited investigation · Final report · Oct 20, 1989 · N96299 · Substantial damage
  > The pilot's failure to properly plan the flight and insure that there was sufficient fuel to complete the flight. The pilot also failed to monitor the fuel level during the flight.
- [NTSB ATL90LA019](https://openairdocs.org/ntsb/ATL90LA019.md): Cessna 177RG · Albertville, AL · Accident · No injuries · Limited investigation · Final report · Oct 20, 1989 · N34080 · Substantial damage
  > The failure of maintenance personnel to properly inspect the magneto during a recent annual inspection.
- [NTSB SEA90LA008](https://openairdocs.org/ntsb/SEA90LA008.md): Boeing A75N1 · Salmon, ID · Accident · No injuries · Limited investigation · Final report · Oct 19, 1989 · N75863 · Destroyed
  > Failure of pilot to properly evaluate weather conditions through mountainous terrain and fly at an altitude high enough to maintain terrain clearance.
- [NTSB NYC90LA015](https://openairdocs.org/ntsb/NYC90LA015.md): Robinson R22 · Bethpage, NY · Accident · No injuries · Limited investigation · Final report · Oct 19, 1989 · N8024W · Substantial damage
  > The pilot's improper handling of the helicopter during a power off autorotation resulting in a hard landing and a main rotor blade severing the tailboom. Contributing to the accident were a gusty wind and the pilot's improper operation of powerplant and…
- [NTSB MIA90FA014](https://openairdocs.org/ntsb/MIA90FA014.md): Piper PA-28R-200 · Athens, TN · Accident · 2 fatal · Field investigation · Final report · Oct 18, 1989 · N5005S · Destroyed
  > Loss of control of the airplane in instrument flight conditions due to spatial disorientation, which resulted in an inadvertent descending spiral. Lack of total experience in the type of operation (actual instrument conditions) was considered to be a…
- [NTSB DEN90IA012](https://openairdocs.org/ntsb/DEN90IA012.md): Mcdonnell Douglas DC-9 · Monte Vista, CO · Incident · Minor injuries · Incident investigation · Final report · Oct 18, 1989 · N922RW · Minor damage
  > The poor inflight planning and decisions made by the flight crew following the failure of the number two generator constant speed drive unit. Contributing factors to the accident were the failure of the no. 2 generator constant speed drive unit and the crew's…
- [NTSB MIA90LA012](https://openairdocs.org/ntsb/MIA90LA012.md): Cessna 152 · Immokalee, FL · Accident · No injuries · Limited investigation · Final report · Oct 17, 1989 · N911SA · Substantial damage
  > Improper planning/decision by the pilot, which resulted in fuel exhaustion. Factors related to the accident were: the pilot becoming lost or disoriented, and the tree(s) in the emergency landing area.
- [NTSB LAX90DVA01](https://openairdocs.org/ntsb/LAX90DVA01.md): Hiller 12E · Huron, CA · Accident · Serious injuries · Final report · Oct 16, 1989 · N4026G · Substantial damage
  > The pilot failed to properly preflight the airplane before departing on the accident flight and misjudged the flare during the ensuing autorotation. Factors relating to this accident were oil starvation and total failure of the connecting rod.
- [NTSB ATL90FA008](https://openairdocs.org/ntsb/ATL90FA008.md): Cessna 172N · Eddyville, KY · Accident · 2 fatal · Field investigation · Final report · Oct 16, 1989 · N733WK · Destroyed
  > The pilot continuing VFR flight into adverse weather conditions. Contributing factor(s) was: low ceiling and rain.
- [NTSB MKC90LA008](https://openairdocs.org/ntsb/MKC90LA008.md): Cessna P210 · Waterloo, IA · Accident · No injuries · Limited investigation · Final report · Oct 15, 1989 · N47DB · Substantial damage
  > Fuel exhaustion, due to poor planning/decision, and fuel consumption calculations misjudged by the pilot in command. The fact that the runway lights were not operating & the accident occurred at night were contributing factors.
- [NTSB ANC90LA006](https://openairdocs.org/ntsb/ANC90LA006.md): Cessna 185 · Tuluksak, AK · Accident · No injuries · Limited investigation · Final report · Oct 15, 1989 · N70022 · Substantial damage
  > Mounting shaft (airbox through-shaft) for the throttle and mixture controls had become loose and backed out, which resulted in loss of engine power. Factors related to the accident were: darkness and rough terrain.
- [NTSB ANC90LA005](https://openairdocs.org/ntsb/ANC90LA005.md): Piper PA-18 · Near Cold Bay, AK · Accident · No injuries · Limited investigation · Final report · Oct 14, 1989 · N4065E · Substantial damage
  > Improper use of carburetor heat by the pilot, which resulted in loss of engine power due to carburetor ice. Carburetor icing conditions and high vegetation in the forced landing area were contributing factors.
- [NTSB MIA90LA010](https://openairdocs.org/ntsb/MIA90LA010.md): Brickman Eipper Mxii · Miami, FL · Accident · No injuries · Limited investigation · Final report · Oct 12, 1989 · N181BB · Substantial damage
  > A cracked impulse line to the fuel pump, which resulted in an inoperative fuel pump and fuel starvation. Factors related to the accident were: the vehicles and high obstructions in the emergency landing area, which necessitated a maneuver to avoid their…
- [NTSB FTW90LA010](https://openairdocs.org/ntsb/FTW90LA010.md): Piper PA-28-140 · Henderson, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 1989 · N6636W · Substantial damage
  > The loss of engine power as a result of a failure of the number 3 exhaust valve due to undetermined reasons. Factors involved in the accident were the previous owner's delay in overhauling the engine and his failure to adhere to the manufacturer's recommended…
- [NTSB DEN90LA007](https://openairdocs.org/ntsb/DEN90LA007.md): Cessna 210 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Oct 11, 1989 · N7409E · Substantial damage
  > An engine stoppage for undetermined reasons.
- [NTSB NYC90MA009](https://openairdocs.org/ntsb/NYC90MA009.md): Agusta A109A Mkii · Lacey Township, NJ · Accident · 5 fatal · Major investigation · Final report · Oct 10, 1989 · N21FL · Destroyed
  > In-flight separation of a main rotor blade due to fatigue failure of the main rotor blade spar, which originated at a manufacturing induced scratch (tool mark) that was the result of inadequate quality control.
- [NTSB LAX90FA007](https://openairdocs.org/ntsb/LAX90FA007.md): Cessna T207A · Grand Canyon, AZ · Accident · Serious injuries · Field investigation · Final report · Oct 10, 1989 · N7602U · Destroyed
  > The inflight failure of the airplane's powerplant as a result metal fatigue which allowed the crankshaft to fracture. Contributing to the accident was mountainous terrain of the Grand Canyon which did not allow a suitable forced landing area.
- [NTSB SEA90LA004](https://openairdocs.org/ntsb/SEA90LA004.md): Cessna 310C · Redmond, OR · Accident · No injuries · Limited investigation · Final report · Oct 9, 1989 · N1845H · Substantial damage
  > Poor inflight planning, and the pilot did not maintain a proper glide path on final approach, nor perform proper corrective action. Factors related to the accident were: the pilot's attention was diverted due to an open cabin door and the partial loss of…
- [NTSB NYC90LA008](https://openairdocs.org/ntsb/NYC90LA008.md): Cessna 150 · Madison, CT · Accident · No injuries · Limited investigation · Final report · Oct 9, 1989 · N50165 · Substantial damage
  > A loss of engine power, due to a stuck exhaust valve in the number 4 cylinder. Factors related to the accident were: the pilot's excessive airspeed on final approach, and his failure to attain the proper touchdown point during the landing.
- [NTSB CHI90IA006](https://openairdocs.org/ntsb/CHI90IA006.md): Boeing 757-251 · San Francisco, CA · Incident · No injuries · Incident investigation · Final report · Oct 9, 1989 · N512US · Minor damage
  > The extreme wear and eventual failure of a torque tube in the inboard trailing edge flap system. Inspection and lubrication intervals were a factor, as was the physical location of the torque tube with reference to external factors.
- [NTSB ATL90LA005](https://openairdocs.org/ntsb/ATL90LA005.md): Cessna 120 · Maysville, KY · Accident · Minor injuries · Limited investigation · Final report · Oct 8, 1989 · N1829N · Substantial damage
  > The improper inspection of the airplanes engine by the pilot/owner resulting in five rocker box cover screws being missing and subsequent loss of engine oil due to the cover vibrating and causing a hole to be worn in it. Subsequent loss of engine power due to…
- [NTSB MKC90LA007](https://openairdocs.org/ntsb/MKC90LA007.md): Cessna 182 · Hasty, AR · Accident · No injuries · Limited investigation · Final report · Oct 7, 1989 · N11PG · Substantial damage
  > The engine failure due to fuel starvation resulting from the collapse at the fuel cell. The fact that the forced landing was made in dark night conditions was a factor.
- [NTSB NYC90LA004](https://openairdocs.org/ntsb/NYC90LA004.md): Champion 7ECA · Beaver Falls, PA · Accident · No injuries · Limited investigation · Final report · Oct 4, 1989 · N123DA · Substantial damage
  > The right fuel vent became clogged allowing the left fuel tank to become exhausted. In addition, the pilot failed to adequately monitor the fuel supply in each tank.
- [NTSB DEN90FA002](https://openairdocs.org/ntsb/DEN90FA002.md): Cessna 182A · Nixon, NV · Accident · 1 fatal · Field investigation · Final report · Oct 2, 1989 · N2155G · Destroyed
  > Continued flight by the non-instrument rated pilot into instrument meteorological conditions (IMC), and his failure to maintain control of the aircraft, due to spatial disorientation. Inadequate preflight preflight planning/preparation by the pilot, and the…
- [NTSB SEA90FA002](https://openairdocs.org/ntsb/SEA90FA002.md): Bellanca 17-30A · Cougar, WA · Accident · 2 fatal · Field investigation · Final report · Oct 1, 1989 · CGUVU · Destroyed
  > Continued VFR flight by the pilot into instrument meteorological conditions (IMC), and his failure to maintain proper altitude/clearance above mountainous terrain. The adverse weather and terrain were related factors.
- [NTSB NYC90LA002](https://openairdocs.org/ntsb/NYC90LA002.md): Enstrom 280FX · Berlin, NY · Accident · No injuries · Limited investigation · Final report · Oct 1, 1989 · N413DB · Substantial damage
  > Loss of engine power for an undetermined reason.
- [NTSB ATL90LA002](https://openairdocs.org/ntsb/ATL90LA002.md): Beech V35B · Colquitt, GA · Accident · No injuries · Limited investigation · Final report · Oct 1, 1989 · N4277A · Destroyed
  > The pilot's failure to obtain current enroute weather information for his destination resulting in his flying VMC into IMC conditions which resulted in his collision with powerlines while making a precautionary landing on a road.
- [NTSB ATL90FA001](https://openairdocs.org/ntsb/ATL90FA001.md): Beech C90 · Chamblee, GA · Accident · 2 fatal · Field investigation · Final report · Oct 1, 1989 · N43GT · Destroyed
  > Malfunction of one or more flight instruments for an undetermined reason, failue of the pilot to maintain control of the aircraft with partial panel instruments after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft.…
- [NTSB LAX89FA334](https://openairdocs.org/ntsb/LAX89FA334.md): Cessna 152 · Lancaster, CA · Accident · 2 fatal · Field investigation · Final report · Sep 30, 1989 · N6422M · Destroyed
  > The pilot's decision to enter into IMC while flying under VFR. Factors contributing to accident were: low ceilings, poor planning and decisions, failure to obtain a preflight briefing and not performing a weather evaluation.
- [NTSB SEA89FA180](https://openairdocs.org/ntsb/SEA89FA180.md): Cessna 177RG · Nyssa, OR · Accident · 2 fatal · Field investigation · Final report · Sep 29, 1989 · N8055G · Destroyed
  > Failure of the pilot to attain sufficient altitude before flying over mountainous/hilly terrain. Factors related to the accident were: dark night, rising/mountainous terrain, and probable impairment from a prescription drug.
- [NTSB ATL89LA221](https://openairdocs.org/ntsb/ATL89LA221.md): Beech B23 · Hatteras, NC · Accident · Minor injuries · Limited investigation · Final report · Sep 29, 1989 · N2333L · Substantial damage
  > Loss of engine power for an unknown reason.
- [NTSB ATL89DKG06](https://openairdocs.org/ntsb/ATL89DKG06.md): Bell UH-1B · Plains, GA · Accident · 2 fatal · Final report · Sep 29, 1989 · N840MC · Destroyed
  > Improper modification of the helicopter by the company/operator, and failure of the spray boom, which resulted in mast bumping, and subsequent failure of the main rotor assembly.
- [NTSB MKC89LA200](https://openairdocs.org/ntsb/MKC89LA200.md): Hughes 269C · Bloomington, MN · Accident · No injuries · Limited investigation · Final report · Sep 28, 1989 · N95KS · Substantial damage
  > Failure of the engine crankshaft. The light conditions at dawn and the vehicles were considered to be contributing factors.
- [NTSB MIA89LA258](https://openairdocs.org/ntsb/MIA89LA258.md): Piper PA-32R-301T · Kissimmee, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 28, 1989 · N8107T · Substantial damage
  > Inadequate preflight by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel. Factors related to the accident were: false fuel gage indications and trees in the emergency landing area.
- [NTSB CHI89DEM09](https://openairdocs.org/ntsb/CHI89DEM09.md): Hiller UH-12E · Hudsonville, MI · Accident · Minor injuries · Final report · Sep 28, 1989 · N4028T · Substantial damage
  > The fatigue failure of one of the tension-torsion pins.
- [NTSB LAX89LA327](https://openairdocs.org/ntsb/LAX89LA327.md): Cessna 210B · Newport Beach, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 27, 1989 · N9615X · Substantial damage
  > The fatigue failure of the engine's crankshaft, resulting in a total loss of power over unsuitable terrain. The pilot ditched the airplane because he was unable to glide to shore.
- [NTSB FTW89FA172](https://openairdocs.org/ntsb/FTW89FA172.md): Cessna 210D · Covington, LA · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1989 · N3962Y · Destroyed
  > The pilot in command's disregard of the weather information provided during two briefings and his decision to continue VFR flight into IMC condtions. Factors contributing to the accident were the pilot's lack of night and instrument experience.
- [NTSB MKC89LA199](https://openairdocs.org/ntsb/MKC89LA199.md): Cessna 150 · California, MO · Accident · No injuries · Limited investigation · Final report · Sep 24, 1989 · N63091 · Substantial damage
  > Improper use of the carburetor heat by the pilot resulting in the formation of carburetor ice and subsequent loss of power.
- [NTSB DEN89LA223](https://openairdocs.org/ntsb/DEN89LA223.md): Cessna 150L · Carlsbad, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 23, 1989 · N6633G · Substantial damage
  > The pilot failed to refuel the airplane in a timely manner which resulted in fuel exhaustion.
- [NTSB MKC89LA198](https://openairdocs.org/ntsb/MKC89LA198.md): Beech 80 · Littlefork, MN · Accident · No injuries · Limited investigation · Final report · Sep 21, 1989 · N132BA · Substantial damage
  > Total failure of the electrical system during IFR operations & the aircraft's collision with a rock fence during the subsequent gear-up precautionary landing.
- [NTSB MKC89FA197](https://openairdocs.org/ntsb/MKC89FA197.md): Cessna 172N · Hyannis, NE · Accident · Serious injuries · Field investigation · Final report · Sep 21, 1989 · N733FY · Substantial damage
  > Failure of the pilot to maintain sufficient altitude. Darkness and adverse weather conditions were related factors.

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

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

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