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

## Cases, newest first

- [NTSB LAX91LA389](https://openairdocs.org/ntsb/LAX91LA389.md): Cessna 172P · Hesperia, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 1991 · N97564 · Substantial damage
  > A stuck exhaust valve due to the operator's non compliance with a manufacturers recommended service bulletin on the engine. Contributing to the accident was the lack of suitable terrain for a safe landing.
- [NTSB DCA91MA052](https://openairdocs.org/ntsb/DCA91MA052.md): Embraer 120 · Eagle Lake, TX · Accident · 14 fatal · Class 1 · Major · Final report · Sep 11, 1991 · N33701 · Destroyed
  > The failure of Continental express maintenance and inspection personnel to adhere to proper maintenance and quality assurance procedures for the airplane's horizontal stabilizer deice boots that led to the sudden in-flight loss of the partially secured left…
- [NTSB CHI91FA291](https://openairdocs.org/ntsb/CHI91FA291.md): Beech 95 · Killdeer, ND · Accident · 2 fatal · Field investigation · Final report · Sep 11, 1991 · N393B · Destroyed
  > The pilot's disregarding the weather forecast; his improper in-flight decision to continue a VFR flight into instrument meteorological conditions; and his failure to maintain adequate clearance from terrain. The mountainous hilly terrain and low ceiling were…
- [NTSB ANC91LA146](https://openairdocs.org/ntsb/ANC91LA146.md): Hughes 369D · Iliamna, AK · Accident · No injuries · Limited investigation · Final report · Sep 11, 1991 · N29JV · Substantial damage
  > Was fuel exhaustion due to the pilot-in-command's improper preflight planning. Contributing to the accident was the rough and uneven tundra landing site.
- [NTSB LAX91FA386](https://openairdocs.org/ntsb/LAX91FA386.md): Cessna 172K · Bullhead City, AZ · Accident · Serious injuries · Field investigation · Final report · Sep 8, 1991 · N7031G · Destroyed
  > 1) A short circuit, 2) electrical overload which ignited the cabin interior, 3) inadequate electrical circuit protection, and 4) insufficient electrical system design standards.
- [NTSB BFO91LA080](https://openairdocs.org/ntsb/BFO91LA080.md): Cessna 152 · Croom, MD · Accident · No injuries · Limited investigation · Final report · Sep 8, 1991 · N48430 · Substantial damage
  > The pilot's failure to assure an adequate fuel supply was on board to complete the flight which resulted in fuel exhaustion.
- [NTSB LAX91LA385](https://openairdocs.org/ntsb/LAX91LA385.md): Cessna C-310B · San Pedro, CA · Accident · 1 fatal · Limited investigation · Final report · Sep 7, 1991 · N5442A · Destroyed
  > An inflight loss of control for undetermined reasons.
- [NTSB CHI91LA290](https://openairdocs.org/ntsb/CHI91LA290.md): Cessna 152 · Minneapolis, KS · Accident · No injuries · Limited investigation · Final report · Sep 7, 1991 · N67781 · Substantial damage
  > The pilot's failure to assure an adequate fuel supply was on board the airplane which resulted in fuel exhaustion. A factor related to the accident was inaccurate preflight planning.
- [NTSB SEA91FA235](https://openairdocs.org/ntsb/SEA91FA235.md): Piper PA32RT-300T · Mayfield, UT · Accident · 1 fatal · Field investigation · Final report · Sep 6, 1991 · N3006J · Destroyed
  > Poor in flight planning/decision. Factors to the accident were: flight into known adverse weather, inadvertent VFR flight into IMC and inadequate clearance.
- [NTSB NYC91LA229](https://openairdocs.org/ntsb/NYC91LA229.md): Piper PA-28-140 · Somerville, NJ · Accident · No injuries · Limited investigation · Final report · Sep 5, 1991 · N6183J · Substantial damage
  > An off airport landing in unsuitable terrain following a power loss due to oil exhaustion. A factor related to the accident was the operators decision not to follow the recommendations of the Piper cherokee service manual.
- [NTSB BFO91LA079](https://openairdocs.org/ntsb/BFO91LA079.md): Cessna 150 · Fallston, MD · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1991 · N5794G · Substantial damage
  > The pilot's failure to accurately determine the fuel quantity before his flight and monitor the quantity during the flight, which resulted in fuel exhaustion due to an inadequate fuel supply.
- [NTSB LAX91LA382](https://openairdocs.org/ntsb/LAX91LA382.md): Piper PA-28R-200 · Redwood City, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 4, 1991 · N2080T · Substantial damage
  > The fatigue failure of the number two connecting rod and rod cap due to an engine overspeed condition which the rods and rod caps were exposed at some undetermined historical point.
- [NTSB LAX91LA381](https://openairdocs.org/ntsb/LAX91LA381.md): Cessna C-210 · Calexico, CA · Accident · No injuries · Limited investigation · Final report · Sep 2, 1991 · N2580S · Substantial damage
  > A non-mechanical loss of engine power due to fuel starvation from the pilot's improper use of the fuel supply.
- [NTSB CHI91LA282](https://openairdocs.org/ntsb/CHI91LA282.md): Piper PA-22-150 · Emporia, KS · Accident · 1 fatal · Limited investigation · Final report · Sep 2, 1991 · N6136D · Destroyed
  > The pilot's VFR flight into instrument meteorological conditions (IMC), and his delay in taking remedial action. The weather (fog) was a related factor.
- [NTSB BFO91FA078](https://openairdocs.org/ntsb/BFO91FA078.md): Piper PA-23-250 · Sod, WV · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1991 · N5435Y · Destroyed
  > The improper level off which resulted in a hard landing. Contributing was fuel starvation resulting in partial loss of engine power.
- [NTSB MIA91GA211](https://openairdocs.org/ntsb/MIA91GA211.md): Robinson R-22 Beta · Lake City, FL · Accident · 1 fatal · Final report · Aug 30, 1991 · N4022D · Destroyed
  > The pilot's failure to maintain a visual lookout due to his diverted attention to observe and enter the location of an illegal marijuana patch into the on board loran unit.
- [NTSB BFO91LA077](https://openairdocs.org/ntsb/BFO91LA077.md): Cessna 150 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Aug 29, 1991 · N3303V · Destroyed
  > The pilot became lost over the Atlantic Ocean and flew until the fuel supply was exhausted.
- [NTSB MIA91IA207](https://openairdocs.org/ntsb/MIA91IA207.md): Airbus Industrie A-300-600R · Atlantic Ocean (Atlantic Ocean) · Incident · Minor injuries · Incident investigation · Final report · Aug 28, 1991 · N18066 · No damage
  > The in flight encounter with turbulence, and the failure of the passengers to comply with instructions to return to their seats and utilize their seatbelts.
- [NTSB CHI91LA275](https://openairdocs.org/ntsb/CHI91LA275.md): Beech B23 · Jenison, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 1991 · N2389L · Substantial damage
  > Failure of the pilot to perform remedial action during fuel system carburetor icing.
- [NTSB MIA91LA206](https://openairdocs.org/ntsb/MIA91LA206.md): Friling Amtr · Land O' Lakes, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 27, 1991 · N12JF · Destroyed
  > The poor in flight decision of the pilot to fly near thunderstorms and their associated turbulence resulting in an uncontrolled descent and in flight collision with terrain.
- [NTSB CHI91LA274](https://openairdocs.org/ntsb/CHI91LA274.md): Cessna 150 · Camden, MI · Accident · No injuries · Limited investigation · Final report · Aug 27, 1991 · N4400U · Substantial damage
  > Partial power loss due to improper use of the carburetor heat control by the pilot. Factors related to the accident were inadequate visual lookout by the pilot and presence of static power lines.
- [NTSB BFO91LA076](https://openairdocs.org/ntsb/BFO91LA076.md): Cessna A188B · New Market, MD · Accident · No injuries · Limited investigation · Final report · Aug 26, 1991 · N8284G · Substantial damage
  > Inadequate preflight by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. A factor related to the accident was: the inoperative fuel quantity gages.
- [NTSB LAX91LA371](https://openairdocs.org/ntsb/LAX91LA371.md): Cessna 152 · Avalon, CA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1991 · N320SV · Destroyed
  > A loss of engine power for undetermined reasons and subsequent ditching while flying over the ocean.
- [NTSB LAX91LA369](https://openairdocs.org/ntsb/LAX91LA369.md): Hiller UH12D · Sparks, NV · Accident · No injuries · Limited investigation · Final report · Aug 25, 1991 · N100HH · Substantial damage
  > The encounter with rough, unsuitable terrain during a precautionary landing. Contributing to the accident was the pilot's decision to make an autorotation after encountering an airframe vibration.
- [NTSB FTW91FA158](https://openairdocs.org/ntsb/FTW91FA158.md): Beech K35 · Tulsa, OK · Accident · Serious injuries · Field investigation · Final report · Aug 25, 1991 · N817R · Substantial damage
  > Total power loss due to failure of the crankshaft bearings and connecting rod cap bolts resulting from the maintenance facilities' failure to overhaul the engine. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA91LA221](https://openairdocs.org/ntsb/SEA91LA221.md): Cessna C-210L · Cheyenne, WY · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1991 · N2190S · Substantial damage
  > Maintenance personnel did not perform a proper top overhaul. This resulted in engine failure due to the failure of a connecting rod bearing. Factors include the hard landing resulting from the premature landing flare by the pilot.
- [NTSB NYC91LA219](https://openairdocs.org/ntsb/NYC91LA219.md): Mooney M20F · Meadville, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 24, 1991 · N3827N · Substantial damage
  > Engine failure resulting from the fatigue failure of the number 2 cylinder exhaust valve and the subsequent forced landing at night. A factor related to the accident was the restricted visibility.
- [NTSB CHI91LA270](https://openairdocs.org/ntsb/CHI91LA270.md): Cessna 150L · Watertown, SD · Accident · Minor injuries · Limited investigation · Final report · Aug 24, 1991 · N16098 · 2 aircraft · Substantial damage
  > Attempted formation flying with N4535E by the pilot of N16098. Factors associated with the collision were: nonperformance of preflight planning, and failure to follow procedures and directives by the pilot of N16098.
- [NTSB SEA91FA220](https://openairdocs.org/ntsb/SEA91FA220.md): Bellanca 17-30A · Arlington, WY · Accident · 3 fatal · Field investigation · Final report · Aug 23, 1991 · N14698 · Destroyed
  > The loss of engine power for an undetermined reason. Factors contriubting to the accident were trees and the pilot's failure to maintain adequate clearance above the trees.
- [NTSB LAX91LA367](https://openairdocs.org/ntsb/LAX91LA367.md): Cessna R182 · Fredonia, AZ · Accident · No injuries · Limited investigation · Final report · Aug 23, 1991 · N9067C · Substantial damage
  > Failure of the carburetor mixture control, resulting in loss of engine power. A factor related to the accident was: lack of compliance with marvel-schebler service bulletin (sb) #A1-78.
- [NTSB FTW91LA153](https://openairdocs.org/ntsb/FTW91LA153.md): Cessna 150M · Haskell, OK · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1991 · N704CP · Substantial damage
  > Improper installation of avionics equipment resulting in interference with flight control.
- [NTSB SEA91IA219](https://openairdocs.org/ntsb/SEA91IA219.md): Boeing 747-151 · Seattle, WA · Incident · Minor injuries · Incident investigation · Final report · Aug 22, 1991 · N604US · Minor damage
  > A fire in the number 4 engine, resulting from a fuel leak at the main fuel control unit, due to improper maintenance by unknown/undetermined person. The L5 emergency exit failed to operatee due to a broken plastic pulley guard in the slide release mechanism.
- [NTSB SEA91LA217](https://openairdocs.org/ntsb/SEA91LA217.md): Beech B24R · Shady Cove, OR · Accident · Serious injuries · Limited investigation · Final report · Aug 21, 1991 · N2528W · Substantial damage
  > Improper re-installation of an oil line by maintenance personnel, which resulted in an oil leak from a loose line and subsequent seizure of the engine. Uneven terrain in the emergency landing area was a related factor.
- [NTSB FTW91LA151](https://openairdocs.org/ntsb/FTW91LA151.md): Beech A23-24 · Tomball, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1991 · N3673Q · Substantial damage
  > The total loss of engine power for undetermined reasons. A factor in the accident was the unsuitable terrain at the pilot's disposal.
- [NTSB SEA91FA216](https://openairdocs.org/ntsb/SEA91FA216.md): Pilatus Britten-Norman BN-2A-26 Islander · Ketchikan, AK · Accident · 4 fatal · Field investigation · Final report · Aug 20, 1991 · N68HA · Destroyed
  > The pilot's attempting to operate VFR in instrument meteorological conditions. Factors contributing to the accident were upsloping terrain in the aircraft's flight path as well as weather conditions resulting in an obscuration of the terrain.
- [NTSB SEA91LA212](https://openairdocs.org/ntsb/SEA91LA212.md): Cessna U206F · Nimrod, OR · Accident · No injuries · Limited investigation · Final report · Aug 19, 1991 · N35831 · Substantial damage
  > The fractured crankshaft resulting in engine seizure followed by a forced landing on rough and uneven terrain resulting in separation of the nose gear.
- [NTSB LAX91LA361](https://openairdocs.org/ntsb/LAX91LA361.md): Cessna 172G · Hilo, HI · Accident · No injuries · Limited investigation · Final report · Aug 18, 1991 · N5921R · Substantial damage
  > Fuel exhaustion due to the installation of a non standard propeller for which no performance charts were available.
- [NTSB SEA91LA210](https://openairdocs.org/ntsb/SEA91LA210.md): Weyerts Rans S-10 · Stanwood, WA · Accident · 1 fatal · Limited investigation · Final report · Aug 17, 1991 · N35PR · Destroyed
  > An undetermined loss of engine power and the pilot's allowing the airspeed to decelerate below the stall speed during the subsequent forced landing.
- [NTSB MIA91IA199](https://openairdocs.org/ntsb/MIA91IA199.md): British Aerospace BA-3100 · Fort Myers, FL · Incident · Minor injuries · Incident investigation · Final report · Aug 17, 1991 · N3155 · No damage
  > The physiological incapacitation of the captain and his loss of consciousness due to a syncopal pleural event.
- [NTSB DEN91FA116](https://openairdocs.org/ntsb/DEN91FA116.md): Cessna 182N · Climax, CO · Accident · 1 fatal · Field investigation · Final report · Aug 17, 1991 · N76AM · Substantial damage
  > Improper in-flight planning/decision by the non-rated pilot and his failure to maintain adequate airspeed, which resulted in a stall. A factor related to the accident was: the pilot's lack of qualification.
- [NTSB NYC91LA211](https://openairdocs.org/ntsb/NYC91LA211.md): Cessna 150 · Sharon, OH · Accident · No injuries · Limited investigation · Final report · Aug 16, 1991 · N19171 · Substantial damage
  > The improper use of carburetor heat by the pilot, which resulted in a loss of engine power and subsequent forced landing on rough terrain. A factor related to the accident was the lack of total flight experience of the student pilot.
- [NTSB ATL91FA161](https://openairdocs.org/ntsb/ATL91FA161.md): Cessna 402B · Kathleen, GA · Accident · 3 fatal · Field investigation · Final report · Aug 16, 1991 · N5855M · Destroyed
  > The pilot's failure to maintain aircraft control while descending at night. Factors related to the accident were: darkness, fog, the pilot's lack of qualification in multi-engine aircraft, his lack of experience in this type of aircraft, his overconfidence in…
- [NTSB SEA91FA207](https://openairdocs.org/ntsb/SEA91FA207.md): Piper PA-32 · Gustavus, AK · Accident · 6 fatal · Field investigation · Final report · Aug 15, 1991 · N4075W · Destroyed
  > VFR flight by the pilot into instrument meteorological conditions (IMC), and the pilot's failure to maintain sufficient altitude and/or clearance from mountainous terrain. Factors related to the accident were: the adverse weather and terrain conditions.
- [NTSB LAX91LA358](https://openairdocs.org/ntsb/LAX91LA358.md): Beech J35 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Aug 14, 1991 · N3028C · Substantial damage
  > The failure of the crankshaft counterweight retaining clip due to improper maintenance installation of the part.
- [NTSB ATL91LA158](https://openairdocs.org/ntsb/ATL91LA158.md): Piper PA-24-250 · Waxhaw, NC · Accident · No injuries · Limited investigation · Final report · Aug 14, 1991 · N6262P · Substantial damage
  > The spatial disorientation experienced by the pilot in IMC, his failure to maintain aircraft control, and the exceeding of the design stress limits of the aircraft. Factor(s) in this accident were: the pilot's inadequate preflight planning, the VFR flight…
- [NTSB FTW91FA147](https://openairdocs.org/ntsb/FTW91FA147.md): Beech 35-C33 · Dalhart, TX · Accident · 3 fatal · Field investigation · Final report · Aug 13, 1991 · N887R · Destroyed
  > The pilot's flight into known adverse weather. Factors were the pilot's lack of instrument experience and existing weather conditions.
- [NTSB CHI91LA230](https://openairdocs.org/ntsb/CHI91LA230.md): Cessna 172 · Metropolis, IL · Accident · No injuries · Limited investigation · Final report · Aug 13, 1991 · N2339U · Substantial damage
  > Miscellaneous equipment not removed (foam rubber) and inadequate preflight by the pilot.
- [NTSB NYC91LA207](https://openairdocs.org/ntsb/NYC91LA207.md): Cessna 152 · Bear Mountain, NY · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 1991 · N67393 · Destroyed
  > The pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing in water.
- [NTSB CHI91MA260](https://openairdocs.org/ntsb/CHI91MA260.md): British Aerospace 3201 · St Louis, MO · Accident · No injuries · Major investigation · Final report · Aug 12, 1991 · N339TE · Substantial damage
  > Failure of the pilot(s) to follow the correct emergency procedure. Factors related to this accident were: inadequate system design by the manufacturer, which allowed hydraulic line vibration, fatigue failure of the line, and loss of fluid from the normal…
- [NTSB LAX91LA353](https://openairdocs.org/ntsb/LAX91LA353.md): Cessna 172B · King City, CA · Accident · No injuries · Limited investigation · Final report · Aug 11, 1991 · N7910X · Substantial damage
  > The total loss of engine power in cruise flight due to the failure of the number 3 cylinder exhaust valve, resulting in a forced landing, and subsequent nose over on landing roll out.

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

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

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