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

## Cases, newest first

- [NTSB NYC07FA173](https://openairdocs.org/ntsb/NYC07FA173.md): Cessna 150L · Hammondsport, NY · Accident · 1 fatal · Field investigation · Final report · Jul 24, 2007 · N10958 · Substantial damage
  > The pilot's inadequate in flight decision and failure to maintain aircraft control during cruise flight. Contributing to the accident were inadequate preflight planning, dark night and poor weather conditions.
- [NTSB LAX07LA238](https://openairdocs.org/ntsb/LAX07LA238.md): de Havilland Beaver DHC-2 MK.1 · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Jul 24, 2007 · N6784L · Substantial damage
  > A loss of engine power due to the failure of the supercharger impeller bushing, which allowed raw oil to enter the induction system.
- [NTSB ANC07FA068](https://openairdocs.org/ntsb/ANC07FA068.md): de Havilland DHC-2 · Ketchikan, AK · Accident · 5 fatal · Field investigation · Final report · Jul 24, 2007 · N995WA · Destroyed
  > The pilot's decision to continue under visual flight rules into an area of instrument metrological conditions. Contributing to the accident was the pilot's inadequate weather evaluation, and the FAA's inadequate surveillance of the commercial air tour…
- [NTSB CHI07CA227](https://openairdocs.org/ntsb/CHI07CA227.md): Air Tractor AT-602 · Prophetstown, IL · Accident · No injuries · Data collection · Final report · Jul 23, 2007 · N628JP · Substantial damage
  > The pilot's failure to accurately monitor fuel consumption during flight, which resulted in a loss of engine power due to fuel starvation/exhaustion. A contributing factor was the cornfield encountered during the forced landing.
- [NTSB CHI07LA221](https://openairdocs.org/ntsb/CHI07LA221.md): Grumman G-164A · Moline, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 22, 2007 · N9828 · Destroyed
  > Fatigue failure of the engine cylinder during cruise flight resulting in a loss of engine power. Additional causes were the pilot's failure to maintain sufficient airspeed and the resulting inadvertent stall during the forced landing. A contributing factor…
- [NTSB ATL07LA106](https://openairdocs.org/ntsb/ATL07LA106.md): Cessna 172P · Sussex, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 2007 · N63483 · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB NYC07LA170](https://openairdocs.org/ntsb/NYC07LA170.md): Learjet 25 · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Jul 21, 2007 · N70SK · Substantial damage
  > A loss of power on both engines for an undetermined reason.
- [NTSB CHI07LA224](https://openairdocs.org/ntsb/CHI07LA224.md): Beech V35B · Rockford, IL · Accident · No injuries · Limited investigation · Final report · Jul 21, 2007 · N313W · Substantial damage
  > A loss of engine power for undetermined reasons, which resulted in a forced landing. A contributing factor was the unsuitable terrain (corn field) encountered during the landing.
- [NTSB NYC07LA171](https://openairdocs.org/ntsb/NYC07LA171.md): Midget Mustang M-1 · Covode, PA · Accident · 1 fatal · Limited investigation · Final report · Jul 20, 2007 · N1085 · Destroyed
  > A loss of engine power for undermined reasons.
- [NTSB MIA07LA123](https://openairdocs.org/ntsb/MIA07LA123.md): Larry J. Cook Lancair 320 · Destin, FL · Accident · No injuries · Limited investigation · Final report · Jul 20, 2007 · N52LC · Substantial damage
  > The separation of a portion of a propeller blade due to fatigue cracking which initiated in an area of corrosion that was not detected during propeller overhaul 10 flight hours before the accident.
- [NTSB DFW07LA167](https://openairdocs.org/ntsb/DFW07LA167.md): Rotorway 162F · Stratford, OK · Accident · No injuries · Limited investigation · Final report · Jul 20, 2007 · N888TD · Substantial damage
  > The loss of engine power due to a seized supercharger. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI07LA213](https://openairdocs.org/ntsb/CHI07LA213.md): Air Tractor AT-402A · Laurel, IA · Accident · 1 fatal · Limited investigation · Final report · Jul 16, 2007 · N203DM · Substantial damage
  > The pilot failed to maintain clearance with the upsloping terrain for undetermined reasons.
- [NTSB CHI07CA215](https://openairdocs.org/ntsb/CHI07CA215.md): Rotorway 162F · Heart, ND · Accident · No injuries · Data collection · Final report · Jul 16, 2007 · CFYAR · Substantial damage
  > The pilot inadvertently shut off the fuel pump switch which resulted in fuel starvation and the subsequent loss of engine power. An additional cause was the pilot's poorly executed autorotation/flare which resulted in a hard landing.
- [NTSB SEA07IA201](https://openairdocs.org/ntsb/SEA07IA201.md): Cirrus Design SR22 · Reno, NV · Incident · No injuries · Incident investigation · Final report · Jul 15, 2007 · N254SR · No damage
  > The failure of the left turbocharger as a result of a production defect in the unit's compressor due to a machining process change by the manufacturer that was made without formal documentation or substantiation.
- [NTSB SEA07FA199](https://openairdocs.org/ntsb/SEA07FA199.md): Cessna 182S · New River, AZ · Accident · 2 fatal · Field investigation · Final report · Jul 15, 2007 · N2454M · Substantial damage
  > The pilot's inadvertent VFR flight into IMC and his ensuing failure to maintain aircraft control while in cruise flight. Contributing factors were the cloudy weather and the dark night conditions.
- [NTSB SEA07TA203](https://openairdocs.org/ntsb/SEA07TA203.md): Cessna TU206G · New Meadows, ID · Accident · No injuries · Final report · Jul 14, 2007 · N9374Z · Substantial damage
  > The loss of engine power due to the loss of engine oil pressure following the oil pump's drive shaft failure for an undetermined reason. Contributing factors were the lack of suitable terrain for a forced landing and the rough/uneven terrain.
- [NTSB SEA07FA195](https://openairdocs.org/ntsb/SEA07FA195.md): Yakovlev YAK-55M · Everett, WA · Accident · 1 fatal · Field investigation · Final report · Jul 14, 2007 · N55NH · Destroyed
  > The pilot's inadequate preflight planning and inspection that led to oil exhaustion and a catastrophic engine failure. Also causal was the pilot's attempted operation of an aircraft with known deficiencies, and the lack of a current airworthiness inspection.…
- [NTSB MIA07LA120](https://openairdocs.org/ntsb/MIA07LA120.md): John D. Williams XT-912 · Newport News, VA · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 2007 · N133W · Substantial damage
  > The pilot's failure to comply with FAA and engine manufacturer directives resulting in deterioration of fuel system components by fuel containing ethanol and blockage of the fuel filter by contaminants.
- [NTSB LAX07LA215](https://openairdocs.org/ntsb/LAX07LA215.md): Cessna 172RG · Roche Harbor, WA · Accident · No injuries · Limited investigation · Final report · Jul 12, 2007 · N9551B · Substantial damage
  > The pilot's failure to perform the emergency landing gear extension procedure prior to landing. A contributing factor in the accident was the failure of the electrical system.
- [NTSB NYC07IA164](https://openairdocs.org/ntsb/NYC07IA164.md): Piper PA-31-350 · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Jul 11, 2007 · N105GC · Minor damage
  > The mechanic's failure to secure the right engine cowling fasteners. Contributing to the incident was the pilot's inadequate preflight inspection.
- [NTSB NYC07MA162](https://openairdocs.org/ntsb/NYC07MA162.md): Cessna 310R · Sanford, FL · Accident · 5 fatal · Class 1 · Major · Final report · Jul 10, 2007 · N501N · Destroyed
  > Actions and decisions by National Association for Stock Car Auto Racing's corporate aviation division's management and maintenance personnel to allow the accident airplane to be released for flight with a known and unresolved discrepancy, and the accident…
- [NTSB MIA07FA117](https://openairdocs.org/ntsb/MIA07FA117.md): Piper PA-30 · Nichols, FL · Accident · 2 fatal · Field investigation · Final report · Jul 9, 2007 · N387RP · Substantial damage
  > Failure of the flight crew to maintain minimal controllable airspeed following a total loss of power in the right engine.
- [NTSB LAX07LA212](https://openairdocs.org/ntsb/LAX07LA212.md): Cessna 182G · Orland, CA · Accident · No injuries · Limited investigation · Final report · Jul 9, 2007 · N4521M · Substantial damage
  > Fuel exhaustion due to the pilot's improper preflight inspection and preparation, and his failure to ensure adequate fuel was onboard for the anticipated flight.
- [NTSB LAX07CA213](https://openairdocs.org/ntsb/LAX07CA213.md): Diamond DA40-G1000 · Strawberry Rese, UT · Accident · Minor injuries · Data collection · Final report · Jul 9, 2007 · N747PZ · Substantial damage
  > The pilot failed to maintain adequate terrain clearance. Contributing to the accident was the pilot's decision to turn into upsloping terrain at a low altitude.
- [NTSB DEN07CA115](https://openairdocs.org/ntsb/DEN07CA115.md): Robinson R22 Beta · Albuquerque, NM · Accident · No injuries · Data collection · Final report · Jul 9, 2007 · N74536 · Substantial damage
  > The pilot's failure to maintain aircraft control during an encounter with the loss of tail rotor effectiveness. Contributing factors were the high density altitude and the power lines.
- [NTSB CHI07LA204](https://openairdocs.org/ntsb/CHI07LA204.md): Cessna 182K · Edgerton, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 2007 · N2579R · Substantial damage
  > The reported non-mechanical loss of engine power for undetermined reasons during cruise and the excessive airspeed the pilot maintained during the approach for the forced landing. Factors were the loss of electrical power during cruise and the high vegetation…
- [NTSB ATL07FA102](https://openairdocs.org/ntsb/ATL07FA102.md): Piper PA-32-260 · Tyringham, MA · Accident · 2 fatal · Field investigation · Final report · Jul 9, 2007 · N5595J · Substantial damage
  > The pilot's inadvertent encounter with thunderstorms during cruise flight. Contributing to the accident was the failure of air traffic control to appropriately issue weather information and initiate an in-flight deviation around known and clearly observed…
- [NTSB MIA07CA122](https://openairdocs.org/ntsb/MIA07CA122.md): Beech B90 · Louisburg, NC · Accident · Serious injuries · Data collection · Final report · Jul 8, 2007 · N1999G · Minor damage
  > The failure of the jumper to follow procedures.
- [NTSB LAX07LA209](https://openairdocs.org/ntsb/LAX07LA209.md): Cessna 152 · Tracy, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 8, 2007 · N95038 · Substantial damage
  > The pilot's improper recovery from a bounced landing and his failure to maintain directional control during the landing roll. Contributing to the accident were the operator's inadequate engine maintenance, which precipitated the loss of engine power, the…
- [NTSB DFW07LA164](https://openairdocs.org/ntsb/DFW07LA164.md): Boeing B737-800 · McAlester, OK · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 2007 · N929AN · No damage
  > An in-flight encounter with clear air turbulence, which resulted in a serious injury to a flight attendant.
- [NTSB NYC07LA160](https://openairdocs.org/ntsb/NYC07LA160.md): Cessna Ector 305A · Berkeley Townsh, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 2007 · N12633 · Substantial damage
  > A loss of engine power during cruise flight for undetermined reasons.
- [NTSB DFW07FA149](https://openairdocs.org/ntsb/DFW07FA149.md): Socata TB-20 · Groesbeck, TX · Accident · 1 fatal · Field investigation · Final report · Jul 6, 2007 · N2801W · Destroyed
  > The pilot's loss of control due to spatial disorientation. Contributing factors were the pilot's perceived need to fly to home station and his lack of flight experience in actual instrument meteorological conditions.
- [NTSB LAX07CA205](https://openairdocs.org/ntsb/LAX07CA205.md): Saunders Stiletto · Quartzsite, AZ · Accident · Minor injuries · Data collection · Final report · Jul 5, 2007 · N337DS · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate preflight inspection during which he failed to insure security of the fuel tank's cap.
- [NTSB CHI07LA195](https://openairdocs.org/ntsb/CHI07LA195.md): Grumman American AA-1C · Carrollton, OH · Accident · 2 fatal · Limited investigation · Final report · Jul 5, 2007 · N200JA · Substantial damage
  > The pilot failed to maintain clearance from trees during cruise. Factors were the inadequate preflight planning, the thunderstorm in the area at the time of the accident, and the trees.
- [NTSB NYC07LA157](https://openairdocs.org/ntsb/NYC07LA157.md): Mooney M20E · Winnsboro, SC · Accident · No injuries · Limited investigation · Final report · Jul 3, 2007 · N7837V · Substantial damage
  > A loss of engine power due to contamination within the fuel injector servo, which was not detected during a recent inadequate annual inspection.
- [NTSB CHI07CA202](https://openairdocs.org/ntsb/CHI07CA202.md): Cessna 172N · Yorkville, IL · Accident · No injuries · Data collection · Final report · Jun 30, 2007 · N738SV · Substantial damage
  > The inadequate fuel consumption calculations by the pilot, the fuel exhaustion during cruise flight, and the unsuitable landing area encountered by the pilot. Contributing factors were the night light conditions and trees.
- [NTSB NYC07CA154](https://openairdocs.org/ntsb/NYC07CA154.md): Cessna 150 · Lancaster, PA · Accident · No injuries · Data collection · Final report · Jun 28, 2007 · N7842E · Substantial damage
  > The pilot's decision to conduct the flight while impaired by alcohol, which resulted in fuel exhaustion and substantial damage to the airplane during the subsequent forced landing.
- [NTSB CHI07LA185](https://openairdocs.org/ntsb/CHI07LA185.md): Cessna 172 · Oak Grove, MN · Accident · No injuries · Limited investigation · Final report · Jun 28, 2007 · N6267E · Substantial damage
  > A loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain.
- [NTSB CHI07FA183](https://openairdocs.org/ntsb/CHI07FA183.md): Piper PA-46-500TP · Wellsville, MO · Accident · 3 fatal · Field investigation · Final report · Jun 28, 2007 · N477MD · Destroyed
  > The pilot's failure to activate the pitot heat as per the checklist, resulting in erroneous airspeed information due to pitot tube icing, and his subsequent failure to maintain aircraft control. Contributing to the accident was the pilot's continued flight in…
- [NTSB CHI07CA190](https://openairdocs.org/ntsb/CHI07CA190.md): Cessna 150L · Salem, IL · Accident · No injuries · Data collection · Final report · Jun 28, 2007 · N11419 · Substantial damage
  > The loss of engine power due to fuel exhaustion which resulted in a forced landing. Additional causes were the certified flight instructor's inadequate preflight supervision. Factors contributing to the accident were the disorientation encountered by the…
- [NTSB LAX07LA204](https://openairdocs.org/ntsb/LAX07LA204.md): Boeing 747-422 · Oceanic · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 2007 · N120UA · No damage
  > An in-flight encounter with turbulence that resulted in serious injury to a flight attendant.
- [NTSB ANC07LA056](https://openairdocs.org/ntsb/ANC07LA056.md): Piper PA-12 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 27, 2007 · N78456 · Substantial damage
  > The malfunction of an engine magneto during cruise flight, which resulted in a partial loss of engine power, and an on-ground encounter with terrain. A factor associated with the accident was the high vegetation at the off-airport landing site.
- [NTSB CHI07FA182](https://openairdocs.org/ntsb/CHI07FA182.md): North American Navion · Colona, IL · Accident · 2 fatal · Field investigation · Final report · Jun 25, 2007 · N8804H · Destroyed
  > The non-instrument rated pilot's continued flight into instrument meteorological conditions.
- [NTSB DEN07CA107](https://openairdocs.org/ntsb/DEN07CA107.md): Truitt Peter Zenair CH 701SP · Mountain View, WY · Accident · Minor injuries · Data collection · Final report · Jun 24, 2007 · N281Z · Destroyed
  > The pilot's failure to maintain aircraft control during cruise flight resulting in an impact with terrain. Contributing factors were the wind gust and high density altitude.
- [NTSB SEA07LA178](https://openairdocs.org/ntsb/SEA07LA178.md): Piper PA 24-250 · Flagstaff, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 2007 · N7584P · Substantial damage
  > The loss of engine power during cruise flight due to fuel exhaustion, as a result of the pilot's failure to refuel and inadequate preflight planning.
- [NTSB MIA07LA111](https://openairdocs.org/ntsb/MIA07LA111.md): Beech A36 · Cullman, AL · Accident · Serious injuries · Limited investigation · Final report · Jun 22, 2007 · N18491 · Substantial damage
  > The pilot’s mismanagement of an in-flight emergency, which resulted in a gear-up landing and runway overrun. Contributing to the accident was a breach to the engine crankcase above and in line with the No. 1 cylinder.
- [NTSB DEN07CA105](https://openairdocs.org/ntsb/DEN07CA105.md): Piper PA-32-301T · Santa Fe, NM · Accident · Minor injuries · Data collection · Final report · Jun 22, 2007 · N8207Z · Substantial damage
  > The pilot's inadequate preflight planning and preparation, and improper in-flight decisions resulting in fuel exhaustion. A factor was the unsuitable terrain for landing.
- [NTSB CHI07FA176](https://openairdocs.org/ntsb/CHI07FA176.md): Beech A36TC · Cannon Falls, MN · Accident · 1 fatal · Field investigation · Final report · Jun 22, 2007 · N3671S · Destroyed
  > The pilot's continued flight into instrument meteorological conditions, which resulted in spatial disorientaton and loss of control.
- [NTSB NYC07FA145](https://openairdocs.org/ntsb/NYC07FA145.md): Cessna 182C · Hiddenite, NC · Accident · 2 fatal · Field investigation · Final report · Jun 21, 2007 · N8691T · Destroyed
  > Carburetor icing, which resulted in a loss of engine power. Also causal, was the pilots' failure to maintain airspeed during the forced landing, which resulted in an inadvertent stall.
- [NTSB DFW07CA142](https://openairdocs.org/ntsb/DFW07CA142.md): Cessna 206 · Baton Rouge, LA · Accident · No injuries · Data collection · Final report · Jun 20, 2007 · N4803U · Substantial damage
  > Fuel starvation as result of the pilot's failure to properly position the fuel selector. A contributing factor was the lack of suitable terrain for the forced landing.

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

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

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