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

## Cases, newest first

- [NTSB LAX96LA277](https://openairdocs.org/ntsb/LAX96LA277.md): Robinson R22B · Morgan Hill, CA · Accident · No injuries · Limited investigation · Final report · Jul 19, 1996 · N730SH · Substantial damage
  > The student's improper reaction to an engine/main rotor overspeed condition, and his failure to achieve the proper zero airspeed nose high attitude during a touchdown from an autorotation.
- [NTSB ANC96FA101](https://openairdocs.org/ntsb/ANC96FA101.md): de Havilland DHC-2 · Elfin Cove, AK · Accident · 1 fatal · Field investigation · Final report · Jul 19, 1996 · N54LA · Destroyed
  > The pilot's decision to continue VFR flight into instrument meteorological conditions, and his failure to maintain adequate clearance from rising terrain. Factors associated with the accident were the rising terrain and clouds.
- [NTSB LAX96LA276](https://openairdocs.org/ntsb/LAX96LA276.md): Cessna A188B · Merced, CA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1996 · N731YT · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate preflight inspection and his failure to ensure that adequate fuel was onboard to complete the flight.
- [NTSB DCA96MA070](https://openairdocs.org/ntsb/DCA96MA070.md): Boeing 747-131 · East Moriches, NY · Accident · 230 fatal · Class 1 · Major · Final report · Jul 18, 1996 · N93119 · Destroyed
  > An explosion of the center wing fuel tank (CWT), resulting from ignition of the flammable fuel/air mixture in the tank. The source of ignition energy for the explosion could not be determined with certainty, but, of the sources evaluated by the investigation,…
- [NTSB MIA96LA187](https://openairdocs.org/ntsb/MIA96LA187.md): Piper PA-23-250 · St Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Jul 17, 1996 · N6819Y · Substantial damage
  > a loss of engine power due to fuel contamination, which resulted in a forced landing (ditching) in water. Factors relating to the accident were: an inadquate annual inspection by maintenance personnel, and an inadequate preflight inspection by the pilot.
- [NTSB LAX96FA275](https://openairdocs.org/ntsb/LAX96FA275.md): Piper PA-24-260 · Tennant, CA · Accident · 2 fatal · Field investigation · Final report · Jul 17, 1996 · N9324P · Destroyed
  > the pilot's continued flight into known adverse weather conditions.
- [NTSB ATL96LA108](https://openairdocs.org/ntsb/ATL96LA108.md): Piper PA-18 · Gatesville, NC · Accident · No injuries · Limited investigation · Final report · Jul 17, 1996 · N7168K · Substantial damage
  > The pilot's inadequate preflight inspection which resulted in engine stoppage due to water contamination in the fuel system. A factor was the lack of suitable terrain for a forced landing.
- [NTSB LAX96LA274](https://openairdocs.org/ntsb/LAX96LA274.md): Cessna 172N · Daggett, CA · Accident · No injuries · Limited investigation · Final report · Jul 16, 1996 · N738NZ · Substantial damage
  > The fracture and separation of an exhaust valve head for undetermined reasons.
- [NTSB FTW96LA305](https://openairdocs.org/ntsb/FTW96LA305.md): Stol UC-1 · Princeton, TX · Accident · No injuries · Limited investigation · Final report · Jul 16, 1996 · N9507U · Substantial damage
  > improper adjustment of the left propeller governor which resulted in uncommanded feathering of the left propeller. Factors were: the airplane's inadequate engine out performance and the lack of suitable terrain for the forced landing.
- [NTSB FTW96LA304](https://openairdocs.org/ntsb/FTW96LA304.md): Beech 76 · Falcon, CO · Accident · No injuries · Limited investigation · Final report · Jul 15, 1996 · N6708A · Substantial damage
  > A loss of engine power due to the pilot's inaccurate fuel consumption calculation, and his failure to properly identify the area of intended landing as an airport. A factor was the misrouting of the fuel line by unknown persons.
- [NTSB NYC96LA148](https://openairdocs.org/ntsb/NYC96LA148.md): McDonnell Douglas MD-11 · Westerly, RI · Accident · Serious injuries · Limited investigation · Final report · Jul 14, 1996 · N1768D · No damage
  > insufficient information from the manufacturer in the airplane flight manual and flightcrew operating manual regarding the hazards of applying force to the control wheel or column while the autopilot is engaged and adjusting the pitch thumbwheel during a…
- [NTSB LAX96LA347](https://openairdocs.org/ntsb/LAX96LA347.md): Piper PA-28-180 · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1996 · N5388L · Substantial damage
  > the failure of a propeller blade as a result of undetected in-service mechanical damage that caused a stress point that progressed to a point of failure.
- [NTSB LAX96LA270](https://openairdocs.org/ntsb/LAX96LA270.md): Cessna 177RG · Folsom, CA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1996 · N52185 · Substantial damage
  > An oil starvation failure of the engine due to a mechanic's failure to put the proper gasket stack on when the propeller governor was replaced. The mechanic's omission was due to the airframe manufacturer's failure to ensure that the service and parts manuals…
- [NTSB CHI96LA240](https://openairdocs.org/ntsb/CHI96LA240.md): Sauder Avid Flyer HH · Stoneville, SD · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1996 · N399S · Substantial damage
  > loss of engine power for undetermined reason(s). A factor relating to the accident was: rough/uneven terrain in the emergency landing area.
- [NTSB ATL96LA105](https://openairdocs.org/ntsb/ATL96LA105.md): Cessna 172H · Hickory, NC · Accident · No injuries · Limited investigation · Final report · Jul 13, 1996 · N1637F · Substantial damage
  > Engine stoppage for undetermined reasons. A factor was the terrain furrows.
- [NTSB NYC96LA147](https://openairdocs.org/ntsb/NYC96LA147.md): Cessna 177RG · Rockaway, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1996 · N8059G · Substantial damage
  > The pilot's impairment of judgment and performance due to alcohol which led to his inadequate preflight of the aircraft and his inadequate inflight decision which resulted in fuel exhaustion and loss of engine power.
- [NTSB MIA96LA180](https://openairdocs.org/ntsb/MIA96LA180.md): Bell 206B · Pigeon Forge, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 11, 1996 · N999TV · Substantial damage
  > fatigue failure of the engine PC line, induced by damage from improper installation, which resulted in a loss of engine power and an autorotative landing to unsuitable terrain.
- [NTSB FTW96LA299](https://openairdocs.org/ntsb/FTW96LA299.md): Bell 206B · Matagorda, TX · Accident · No injuries · Limited investigation · Final report · Jul 11, 1996 · N1082N · Substantial damage
  > The loss of engine power due to fuel system contamination. A factor relating to the accident was: the lack of suitable terrain for an emergency landing.
- [NTSB ATL96LA104](https://openairdocs.org/ntsb/ATL96LA104.md): Hiller UH-12E · Cottondale, FL · Accident · No injuries · Limited investigation · Final report · Jul 11, 1996 · N102HT · Substantial damage
  > failure of the main rotor drive torsional coupling and inner gimbal ring, which resulted in jamming of the flight controls during an attempted autorotation.
- [NTSB IAD96LA111](https://openairdocs.org/ntsb/IAD96LA111.md): Cessna 150 · Vincent, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 1996 · N16095 · Destroyed
  > the instructor's inadequate supervision by allowing the student and himself to become lost, his inadequate inflight planning/decision by failing to ensure the airplane was safely landed before fuel was exhausted, and his selection of unsuitable terrain for a…
- [NTSB SEA96LA148](https://openairdocs.org/ntsb/SEA96LA148.md): Mooney M18LA · Beaver Marsh, OR · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 1996 · N4077 · Substantial damage
  > the loss of engine power for undetermined reason(s). A factor relating to the accident was: the presence of trees near the forced landing area.
- [NTSB LAX96LA264](https://openairdocs.org/ntsb/LAX96LA264.md): Piper PA-28-181 · Lanai, HI · Accident · No injuries · Limited investigation · Final report · Jul 7, 1996 · N4319J · Destroyed
  > Fuel exhaustion due to the pilot's inadequate fuel planning and failure to refuel the aircraft prior to initiating a 280-mile over water nonstop leg of the flight.
- [NTSB FTW96LA293](https://openairdocs.org/ntsb/FTW96LA293.md): Beech A23-19 · Garfield, CO · Accident · No injuries · Limited investigation · Final report · Jul 7, 1996 · N5675S · Substantial damage
  > a reported power loss for reasons undetermined.
- [NTSB ATL96TA102](https://openairdocs.org/ntsb/ATL96TA102.md): Hughes 269B · Tampa, FL · Accident · Serious injuries · Final report · Jul 7, 1996 · N10TP · Substantial damage
  > The failure of maintenance personnel to secure the engine oil screen housing during the 50-hour inspection.
- [NTSB NYC96LA141](https://openairdocs.org/ntsb/NYC96LA141.md): Cessna 210 · Boston, MA · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1996 · N131AC · Substantial damage
  > a fracture failure of the crankcase, which resulted in separation of the number five cylinder, loss of engine power, and a ditched landing.
- [NTSB FTW96LA292](https://openairdocs.org/ntsb/FTW96LA292.md): Raven S55A · Gunnison, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1996 · N4273Y · No damage
  > The pilot's improper planning/decision. The weather condition (sudden high wind) was a related factor.
- [NTSB CHI96LA228](https://openairdocs.org/ntsb/CHI96LA228.md): Piper PA-25-235 · Kenmare, ND · Accident · No injuries · Limited investigation · Final report · Jul 5, 1996 · N7730Z · Substantial damage
  > the pilot's improper refueling procedure, inadequate preflight and the inadvertent stall. A factor related to the accident was the low altitude at which the loss of power occurred.
- [NTSB ATL96LA100](https://openairdocs.org/ntsb/ATL96LA100.md): Cessna 172N · Hillsborough, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1996 · N75814 · Substantial damage
  > The failure of the magneto impulse coupling spring. A factor was the power line at the approach end of the forced landing site.
- [NTSB MIA96LA177](https://openairdocs.org/ntsb/MIA96LA177.md): Aerostar RX-8 · Canton, MS · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1996 · N7155N · Substantial damage
  > failure of the pilot to maintain sufficient altitude and/or clearance from the tower.
- [NTSB ANC96TA095](https://openairdocs.org/ntsb/ANC96TA095.md): Cessna 185 · Fairbanks, AK · Accident · Minor injuries · Final report · Jul 4, 1996 · N185CA · Destroyed
  > fatigue failure of the engine crankshaft. A factor related to the accident was: the lack of suitable terrain for a forced landing.
- [NTSB FTW96LA291](https://openairdocs.org/ntsb/FTW96LA291.md): Enstrom 280C · Castle Rock, CO · Accident · No injuries · Limited investigation · Final report · Jul 3, 1996 · N51763 · Substantial damage
  > Total failure of the magneto. A factor was the pilot operating the helicopter with a known deficiency.
- [NTSB IAD96LA106](https://openairdocs.org/ntsb/IAD96LA106.md): Cessna 170B · Beckley, WV · Accident · Minor injuries · Limited investigation · Final report · Jul 2, 1996 · N8099A · Substantial damage
  > The pilots decision to continue flying from VFR to IMC conditions which subsequently forced him to make a precautionary landing onto unsuitable terrain.
- [NTSB FTW96LA285](https://openairdocs.org/ntsb/FTW96LA285.md): Hiller UH12 · Franklin, LA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1996 · N14637 · Substantial damage
  > loss of engine power for undetermined reasons, and the pilot's failure to maintain rotor RPM. A factor was the unsuitable terrain available for the precautionary landing.
- [NTSB FTW96LA281](https://openairdocs.org/ntsb/FTW96LA281.md): Cessna 172H · Pierce, CO · Accident · No injuries · Limited investigation · Final report · Jun 30, 1996 · N1686F · Substantial damage
  > a loss of engine power for undetermined reasons. A factor was the unsuitable terrain.
- [NTSB FTW96LA280](https://openairdocs.org/ntsb/FTW96LA280.md): Cessna 182N · Truth Or Conseq, NM · Accident · No injuries · Limited investigation · Final report · Jun 30, 1996 · N9001G · Substantial damage
  > The loss of engine power due to the fatigue failure of the number one piston. A factor was the lack of suitable terrain for the forced landing.
- [NTSB MIA96LA171](https://openairdocs.org/ntsb/MIA96LA171.md): Beech B35 · Kissimmee, FL · Accident · No injuries · Limited investigation · Final report · Jun 29, 1996 · N5136C · Substantial damage
  > the pilot was operating the airplane at an indicated airspeed that exceeded the design speed for maximum gust intensity (VB), when clear air turbulence was encountered.
- [NTSB FTW96FA279](https://openairdocs.org/ntsb/FTW96FA279.md): Prevatt RV-6 · Boulder, CO · Accident · 2 fatal · Field investigation · Final report · Jun 29, 1996 · N194JP · 2 aircraft · Destroyed
  > Poor judgment by the pilot of the RV-6, N194JP, in that he traversed an uncontrolled airport at traffic pattern altitude, failure of the pilots of both airplanes to see and avoid each other, and an inadvertent airplane stall encountered by the pilot of the…
- [NTSB MIA96FA168](https://openairdocs.org/ntsb/MIA96FA168.md): Hiller FH-1100 · Webster, FL · Accident · 2 fatal · Field investigation · Final report · Jun 28, 1996 · N598F · Substantial damage
  > inadequate compliance with AD 77-07-08 (and SB FH1100-55-2A) by other maintenance personnel, and subsequent fatigue failure of plates in the tail rotor torsion tension bar. Factors related to the accident were: manufacturing discontinuities…
- [NTSB FTW96LA284](https://openairdocs.org/ntsb/FTW96LA284.md): Beech B35 · Portales, NM · Accident · No injuries · Limited investigation · Final report · Jun 28, 1996 · N8860A · Substantial damage
  > failure by maintenance personnel to perform proper maintenance on the aircraft during an annual inspection, and failure to comply with an airworthiness directive.
- [NTSB CHI96LA224](https://openairdocs.org/ntsb/CHI96LA224.md): Piper PA-36-375 · Windfall, IN · Accident · 1 fatal · Limited investigation · Final report · Jun 28, 1996 · N2459X · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering to avoid an obstruction (transmission line), which resulted in a stall and collision with the terrain. His lack of familiarity with the geographic area was a related factor.
- [NTSB ATL96FA096](https://openairdocs.org/ntsb/ATL96FA096.md): Cessna 152 · Talladega, AL · Accident · 2 fatal · Field investigation · Final report · Jun 27, 1996 · N95396 · Destroyed
  > failure of the pilot to see-and-avoid an antenna that was mounted on a Forest Service watch tower. The pilot's excessively low altitude flight was a related factor.
- [NTSB MIA96LA163](https://openairdocs.org/ntsb/MIA96LA163.md): Aeronca 7AC · Callahan, FL · Accident · No injuries · Limited investigation · Final report · Jun 25, 1996 · N84538 · Substantial damage
  > the pilot's premature decision to reduce power, following application of carburetor heat, when engine operation became rougher after experiencing roughness due to carburetor icing. The weather (carburetor icing) conditions and carburetor ice were related…
- [NTSB CHI96LA220](https://openairdocs.org/ntsb/CHI96LA220.md): Grumman AA5B · Fryburg, ND · Accident · 1 fatal · Limited investigation · Final report · Jun 25, 1996 · N6249L · Substantial damage
  > the pilot's VFR flight into instrument meteorological conditions. Factors were the fog, low ceiling, and rising terrain.
- [NTSB CHI96FA216](https://openairdocs.org/ntsb/CHI96FA216.md): Fairchild SA227AC · Grand Forks, ND · Accident · No injuries · Field investigation · Final report · Jun 25, 1996 · N2692P · Substantial damage
  > insufficient clearance between the second stage compressor impeller and the shroud. A factor was the subsequent fatigue failure of the impeller.
- [NTSB CHI96LA235](https://openairdocs.org/ntsb/CHI96LA235.md): Beech B35 · Chesterfield, MO · Accident · No injuries · Limited investigation · Final report · Jun 24, 1996 · N5001C · Substantial damage
  > improperly balanced ruddervators and improperly installed ruddervator (elevator) trim tabs, due to improper maintenance, which resulted in ruddervator flutter and substantial damage in the area of the aft fuselage. Factors relating to the accident were:…
- [NTSB ATL96FA095](https://openairdocs.org/ntsb/ATL96FA095.md): Piper PA-23-250 · Clanton, AL · Accident · 5 fatal · Field investigation · Final report · Jun 24, 1996 · N6937Y · Destroyed
  > corrosion pitting of the number six cylinder on the left engine, and subsequent fatigue fracture and separation of the cylinder, which led to an engine compartment fire, wing fire, and an in-flight separation of the left wing.
- [NTSB MIA96FA162](https://openairdocs.org/ntsb/MIA96FA162.md): Embraer 120 · Orlando, FL · Accident · No injuries · Field investigation · Final report · Jun 23, 1996 · N168CA · Substantial damage
  > the aircraft manufacture's inadequate written procedures in the airplane flight manual/quick reference handbook, which resulted in a failure of the landing gear to extend and a wheels up emergency landing, due to hydraulic blockage in the landing gear…
- [NTSB CHI96LA213](https://openairdocs.org/ntsb/CHI96LA213.md): Cessna 172 · Conway, MI · Accident · No injuries · Limited investigation · Final report · Jun 23, 1996 · N3823S · Substantial damage
  > A crack in the intake manifold which led to oil exhaustion and subsequent piston failure. A factor was the soft field.
- [NTSB MIA96LA161](https://openairdocs.org/ntsb/MIA96LA161.md): Cessna 170A · Southside, AL · Accident · No injuries · Limited investigation · Final report · Jun 22, 1996 · N9230A · Substantial damage
  > failure of an oil line between the engine and the oil cooler, which resulted in loss of oil, oil starvation, and subsequent seizure of the engine. Factors relating to the accident were: the effects of a tailwind during the forced landing, and failure of the…
- [NTSB FTW96LA272](https://openairdocs.org/ntsb/FTW96LA272.md): Grumman-Schweizer G-164A · Holyoke, CO · Accident · No injuries · Limited investigation · Final report · Jun 22, 1996 · N4698 · Substantial damage
  > the total failure of the engine main bearing. A factor was the soft terrain condition on which the forced landing was made.

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

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

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