# 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 132 of 718 · 35,889 cases

## Cases, newest first

- [NTSB ANC05FA121](https://openairdocs.org/ntsb/ANC05FA121.md): Beech V35B · Denali Park, AK · Accident · 2 fatal · Field investigation · Final report · Aug 5, 2005 · N912DB · Destroyed
  > The pilot's failure to maintain altitude/clearance from mountainous terrain while climbing, and his improper in-flight decision making by electing to fly at a low altitude toward rising terrain. A factor associated with the accident was mountainous terrain.
- [NTSB SEA05LA163](https://openairdocs.org/ntsb/SEA05LA163.md): Steele Safari · Leavenworth, WA · Accident · No injuries · Limited investigation · Final report · Aug 4, 2005 · N13MA · Substantial damage
  > The failure of the tail rotor drive shaft during cruise flight. Factors include soft, grassy terrain at the location where the pilot executed the autorotational landing.
- [NTSB IAD05LA114](https://openairdocs.org/ntsb/IAD05LA114.md): Convair BT-13A · Lyme, NH · Accident · 2 fatal · Limited investigation · Final report · Aug 3, 2005 · N49646 · Destroyed
  > The pilot's improper fuel management which resulted in an incorrect fuel selector position, fuel starvation, and subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain adequate airspeed and inadvertent stall.
- [NTSB LAX05LA253](https://openairdocs.org/ntsb/LAX05LA253.md): Malechek Q-200 · Delano, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 2, 2005 · N870BM · Destroyed
  > the in-flight delamination and separation of a propeller blade for undetermined reasons.
- [NTSB LAX05FA255](https://openairdocs.org/ntsb/LAX05FA255.md): Piper PA-28-151 · San Luis Obispo, CA · Accident · 1 fatal · Field investigation · Final report · Aug 2, 2005 · N4401X · Destroyed
  > The pilot's continued flight into instrument meteorological conditions, and his failure to maintain clearance from the rising hilly terrain. Contributing factors were the pilot's inexperience regarding flying during the dark, nighttime condition, and the low…
- [NTSB DFW05CA199](https://openairdocs.org/ntsb/DFW05CA199.md): Mrazek Rans S-14 · Forth Worth, TX · Accident · No injuries · Data collection · Final report · Aug 2, 2005 · N5802 · Substantial damage
  > The loss of engine power for undetermined reasons. A factor contributing to the accident was the lack of suitable terrain for the forced landing.
- [NTSB CHI05CA209](https://openairdocs.org/ntsb/CHI05CA209.md): National Ballooning 751-12 · Indianola, IA · Accident · No injuries · Data collection · Final report · Aug 2, 2005 · N3219T · Substantial damage
  > The in-flight fire due to the loose fuel line connection as a result of the pilot's inadequate preflight. A factor was the power lines.
- [NTSB NYC05CA127](https://openairdocs.org/ntsb/NYC05CA127.md): Yakovlev 55M · New Marlboro, MA · Accident · No injuries · Data collection · Final report · Jul 31, 2005 · N1003G · Substantial damage
  > The pilot's improper weather evaluation which resulted in a precautionary off airport landing; and his improper flare which resulted in a hard landing. A factor in this accident was weather associated with thunderstorm activity.
- [NTSB LAX05CA257](https://openairdocs.org/ntsb/LAX05CA257.md): Cessna A150M · Trinity Center, CA · Accident · Minor injuries · Data collection · Final report · Jul 31, 2005 · N8166V · Destroyed
  > the pilot's failure to select an adequate altitude, which would assure clearance from the mountainous terrain while flying into a box canyon in high density altitude conditions.
- [NTSB IAD05LA112](https://openairdocs.org/ntsb/IAD05LA112.md): Schweizer 269C · Mount Holly, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 31, 2005 · N399HF · Substantial damage
  > The flight instructor's delayed remedial action. A factor was the flight instructor's failure to ensure that both pilots knew who was performing the maneuver.
- [NTSB DEN05LA117](https://openairdocs.org/ntsb/DEN05LA117.md): Bellanca 14-19-3 · Grand Junction, CO · Accident · 1 fatal · Limited investigation · Final report · Jul 30, 2005 · N8870R · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the improper fuel selector position. Factors contributing to the accident were the inadvertent stall, the ravine, and the steep drop off embankment.
- [NTSB ANC05FA116](https://openairdocs.org/ntsb/ANC05FA116.md): Cessna 180 · Fairbanks, AK · Accident · 2 fatal · Field investigation · Final report · Jul 30, 2005 · N3188C · Destroyed
  > The pilot's failure to maintain sufficient altitude/clearance from objects and terrain during cruise flight, which resulted in an in-flight collision with tree-covered terrain.
- [NTSB DFW05CA194](https://openairdocs.org/ntsb/DFW05CA194.md): Cessna 175A · Graham, OK · Accident · No injuries · Data collection · Final report · Jul 28, 2005 · N6776E · Substantial damage
  > The impending loss of engine power as result of the failure of the generator mounting gasket resulting in engine oil starvation. A contributing factor was the lack of suitable terrain for the precautionary landing.
- [NTSB CHI05CA205](https://openairdocs.org/ntsb/CHI05CA205.md): Piper PA-28-151 · Holland, MI · Accident · No injuries · Data collection · Final report · Jul 28, 2005 · N602EA · Destroyed
  > The pilot's failure to maintain adequate airspeed which resulted in a stall, and subsequent collision with trees. Contributing to the accident were the trees.
- [NTSB ANC05LA110](https://openairdocs.org/ntsb/ANC05LA110.md): de Havilland DHC-3 · Ketchikan, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 28, 2005 · N6868B · Minor damage
  > An electrical arc on the exterior of a fuel pressure line that initiated a fuel leak and fire during cruise flight, which resulted in serious injuries to the pilot as he performed an emergency landing on the water. A factor contributing to the accident was an…
- [NTSB DFW05CA198](https://openairdocs.org/ntsb/DFW05CA198.md): Amateur Built Varieze · Alco, AR · Accident · Minor injuries · Data collection · Final report · Jul 27, 2005 · N115JT · Substantial damage
  > The pilot's pilots failure to refuel the airplane. Contributing factors were the low ceilings and the lack of suitable terrain for the precautionary landing.
- [NTSB MIA05LA136](https://openairdocs.org/ntsb/MIA05LA136.md): Brantly Helicopter B2B · Ft. Pierce, FL · Accident · No injuries · Limited investigation · Final report · Jul 24, 2005 · N9023M · Substantial damage
  > The pilot's inadequate preflight planning/preparation, and failure to refuel the helicopter prior to takeoff which resulted in fuel exhaustion and a loss of engine power during the landing.
- [NTSB LAX05LA242](https://openairdocs.org/ntsb/LAX05LA242.md): Quicksilver Mxlii 101 Sport · Galt, CA · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 2005 · UNREG · Destroyed
  > loss of engine power for undetermined reasons, and the pilot's failure to maintain an adequate airspeed while maneuvering for a forced landing that resulted in a stall and uncontrolled descent into terrain.
- [NTSB IAD05LA105](https://openairdocs.org/ntsb/IAD05LA105.md): Piper PA-28-180 · Copake, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 20, 2005 · N7767N · Substantial damage
  > The pilot's inadequate preflight planning which resulted in fuel exhaustion and subsequent loss of engine power.
- [NTSB IAD05LA103](https://openairdocs.org/ntsb/IAD05LA103.md): Piper PA-28-180 · Denton, MD · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 2005 · N4797L · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB DFW05LA183](https://openairdocs.org/ntsb/DFW05LA183.md): Piper PA-28R-200 · Pollock, LA · Accident · No injuries · Limited investigation · Final report · Jul 16, 2005 · N33720 · Substantial damage
  > The loss of engine power due to a loose engine lubrication system component in the crankcase. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI05LA190](https://openairdocs.org/ntsb/CHI05LA190.md): Mooney M20M · White Cloud, MI · Accident · No injuries · Limited investigation · Final report · Jul 15, 2005 · N355RZ · Substantial damage
  > A loss of engine power during cruise flight due to the mechanic's improper maintenance, the disconnected oil line, the oil leak from the disconnected line, and the unsuitable terrain the pilot encountered during the forced landing. Factors were the outside…
- [NTSB CHI05CA185](https://openairdocs.org/ntsb/CHI05CA185.md): Aero Commander S2R · Walnut, IL · Accident · Minor injuries · Data collection · Final report · Jul 14, 2005 · N8962Q · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate in-flight planning/decision. A contributing factor was the corn field.
- [NTSB ATL05CA130](https://openairdocs.org/ntsb/ATL05CA130.md): Jabiru SK0007 · Aiken, SC · Accident · Minor injuries · Data collection · Final report · Jul 13, 2005 · N30SP · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB LAX05FA229](https://openairdocs.org/ntsb/LAX05FA229.md): Eurocopter AS350BA · Kapaau, HI · Accident · No injuries · Field investigation · Final report · Jul 12, 2005 · N4064F · Substantial damage
  > the in-flight separation of the tail rotor system as a result of a loss of clamp force and fatigue fracturing of the attachment nut plates. The cause of the loss of clamp force was likely due to an inadvertent tail rotor blade strike during the previous…
- [NTSB IAD05LA101](https://openairdocs.org/ntsb/IAD05LA101.md): Aeronca 65CA · Cadiz, OH · Accident · No injuries · Limited investigation · Final report · Jul 11, 2005 · N36806 · Substantial damage
  > Carburetor icing, which resulted in a partial loss of engine power. A factor was an unanticipated hill in the forced landing rollout area.
- [NTSB DCA05MA083](https://openairdocs.org/ntsb/DCA05MA083.md): Boeing 767-232 · Raleigh-Durham, NC · Accident · Serious injuries · Major investigation · Final report · Jul 11, 2005 · N113DA · No damage
  > An inadvertent in-flight encounter with clear air turbulence.
- [NTSB ATL05FA128](https://openairdocs.org/ntsb/ATL05FA128.md): Cessna 172N · Penrose, NC · Accident · 1 fatal · Field investigation · Final report · Jul 10, 2005 · N73747 · Destroyed
  > A loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to use the full length of the runway for takeoff, and the inadvertent stall.
- [NTSB CHI05LA178](https://openairdocs.org/ntsb/CHI05LA178.md): Cessna 210E · La Gygne, KS · Accident · No injuries · Limited investigation · Final report · Jul 9, 2005 · N4933U · Substantial damage
  > The failure of the throttle control cable which resulted from wear followed by fatigue cracking. A factor associated with the accident was the corn crop which the airplane contacted during the forced landing.
- [NTSB LAX05TA226](https://openairdocs.org/ntsb/LAX05TA226.md): Ayres S2R-G10 · Wickenburg, AZ · Accident · Minor injuries · Final report · Jul 7, 2005 · N440AT · Substantial damage
  > the partial loss of engine power for undetermined reasons.
- [NTSB IAD05LA096](https://openairdocs.org/ntsb/IAD05LA096.md): Piper PA-25 · Cape May, NJ · Accident · No injuries · Limited investigation · Final report · Jul 5, 2005 · N6289Z · Substantial damage
  > A partial loss of engine power for undetermined reasons. A factor was the lack of suitable terrain to perform a forced landing.
- [NTSB IAD05LA095](https://openairdocs.org/ntsb/IAD05LA095.md): Grumman American AA-5 · Branchville, NJ · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 2005 · N6061L · Substantial damage
  > An electrical fire of unknown origin. A factor in the accident was the pilot's failure to perform the In-Flight Electrical Fires checklist.
- [NTSB IAD05CA092](https://openairdocs.org/ntsb/IAD05CA092.md): Callahan Rotorway Exec 90 · Weston, WV · Accident · No injuries · Data collection · Final report · Jul 4, 2005 · N4359N · Destroyed
  > A loss of engine power for undetermined reasons during an attempted power recovery. A factor in the accident was the pilot's failure to maintain rotor rpm, which resulted in a hard landing and subsequent post crash fire.
- [NTSB ATL05CA122](https://openairdocs.org/ntsb/ATL05CA122.md): Aeronca C3 · Summerville, SC · Accident · Serious injuries · Data collection · Final report · Jul 4, 2005 · N14532 · Substantial damage
  > The maintenance personnel failure to secure the intake valve adjustment jam nut which resulted in excessive valve clearance, and the subsequent loss of engine power.
- [NTSB MIA05FA130](https://openairdocs.org/ntsb/MIA05FA130.md): Beech V35 · De Funiak Sprgs, FL · Accident · 1 fatal · Field investigation · Final report · Jul 3, 2005 · N2056W · Substantial damage
  > The loss of engine power during cruise flight for an undetermined reason, which resulted in an emergency descent and an in-flight collision with tress and terrain.
- [NTSB ANC05CA095](https://openairdocs.org/ntsb/ANC05CA095.md): Cessna 207 · Bethel, AK · Accident · No injuries · Data collection · Final report · Jul 3, 2005 · N48CF · Substantial damage
  > An in-flight collision with a bird during cruise flight, which resulted in structural damage to the airplane's wing.
- [NTSB SEA05FA136](https://openairdocs.org/ntsb/SEA05FA136.md): Beech E-55 · Lopez, WA · Accident · 2 fatal · Field investigation · Final report · Jul 2, 2005 · N686T · Destroyed
  > The pilot's failure to refuel the airplane which resulted in a dual loss of engine power during normal descent due to fuel exhaustion. A contributing factor was the incorrect installation of the left and right wing fuel sight gage/float assemblies by unknown…
- [NTSB IAD05LA089](https://openairdocs.org/ntsb/IAD05LA089.md): Longtin Kitfox Model III · New London, NH · Accident · 1 fatal · Limited investigation · Final report · Jul 2, 2005 · N795JL · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor in the accident was the tail wind condition.
- [NTSB LAX05LA221](https://openairdocs.org/ntsb/LAX05LA221.md): Piper PA-23-160 · Honolulu, HI · Accident · No injuries · Limited investigation · Final report · Jul 1, 2005 · N3369P · Substantial damage
  > the flight crew's failure to ensure that the landing gear lever was in the full down position prior to utilizing the hand pump, and the certified flight instructor's failure to utilize the blow down emergency landing gear system. The instructor's inadequate…
- [NTSB CHI05LA173](https://openairdocs.org/ntsb/CHI05LA173.md): Robinson R22 Beta · Crete, IL · Accident · No injuries · Limited investigation · Final report · Jul 1, 2005 · N997SA · Substantial damage
  > The separation of the drive belt, during cruise, leading to the puncturing of the oil cooler and subsequent fire. An additional cause was the pilot's restricted lookout during the emergency landing resulting in the hard landing.
- [NTSB ANC05FA090](https://openairdocs.org/ntsb/ANC05FA090.md): Cessna T207 · Nanwalek, AK · Accident · 3 fatal · Field investigation · Final report · Jul 1, 2005 · N1621U · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, which resulted in an in-flight collision with an island cliff during cruise flight. A factor contributing to the accident was fog in the area of the accident.
- [NTSB NYC05LA110](https://openairdocs.org/ntsb/NYC05LA110.md): Cirrus Design SR-22 · Haverstraw, NY · Accident · Serious injuries · Limited investigation · Final report · Jun 30, 2005 · N3452L · Substantial damage
  > The pilot's physiological condition, which resulted in his incapacitation during the flight, and subsequent loss of aircraft control.
- [NTSB MIA05CA125](https://openairdocs.org/ntsb/MIA05CA125.md): Cessna 152 · Williston, FL · Accident · No injuries · Data collection · Final report · Jun 30, 2005 · N5372L · Substantial damage
  > The inadequate weather evaluation by the pilot-in-command which resulted in the in-flight encounter with rain and thunder that resulted in a precautionary landing and subsequent on-ground collision with a ditch.
- [NTSB ATL05LA117](https://openairdocs.org/ntsb/ATL05LA117.md): Piper J3C-65 · Mocksville, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2005 · N38341 · Substantial damage
  > The loss of engine power due to fuel system contamination. A factor was trees.
- [NTSB ATL05LA115](https://openairdocs.org/ntsb/ATL05LA115.md): Cessna 177A · Rome, GA · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2005 · N70847 · Substantial damage
  > The pilot's delay in the use of carburetor heat, which resulted in the formation of carburetor / induction ice and the loss of engine power.
- [NTSB IAD05LA085](https://openairdocs.org/ntsb/IAD05LA085.md): Martel Air Command 532Elite · Highgate, VT · Accident · 1 fatal · Limited investigation · Final report · Jun 26, 2005 · UNREG · Substantial damage
  > The pilot's improper cyclic input, which resulted in a retreating rotor blade stall, and its subsequent impact with the propeller. Also causal, was the pilot's failure to acquire proper training. A factor was the pilot's decision not to have a stability…
- [NTSB CHI05CA181](https://openairdocs.org/ntsb/CHI05CA181.md): Piper PA-31-310 · Lake Huron, MI · Accident · Minor injuries · Data collection · Final report · Jun 26, 2005 · N601RE · Substantial damage
  > The fuel exhaustion during cruise flight, the inadequate in-flight planning/decision by the pilot, and the unsuitable terrain encountered by the pilot during the forced landing.
- [NTSB CHI05CA166](https://openairdocs.org/ntsb/CHI05CA166.md): Cessna 182F · Lapeer, MI · Accident · Minor injuries · Data collection · Final report · Jun 26, 2005 · N3184U · Substantial damage
  > The pilot's inadequate preflight inspection due to his failure to physically verify the security of the fuel tank caps, the unsecured fuel tank cap and fuel exhaustion.
- [NTSB SEA05LA127](https://openairdocs.org/ntsb/SEA05LA127.md): Cessna 182A · Star, ID · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 2005 · N2153G · Substantial damage
  > A loss of engine power for undetermined reasons. A factor contributing to the accident were the transmission wires.
- [NTSB DEN05CA105](https://openairdocs.org/ntsb/DEN05CA105.md): Navion Navion G · Parowan, UT · Accident · No injuries · Data collection · Final report · Jun 25, 2005 · N2484T · Substantial damage
  > The jammed left main landing gear and the wheels up landing. Factors contributing to the accident were the misaligned left landing light and that landing gear extension was not possible.

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.