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

## Cases, newest first

- [NTSB FTW96LA381](https://openairdocs.org/ntsb/FTW96LA381.md): Mooney M20J · Biscoe, AR · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1996 · N311SM · Destroyed
  > Binding of the flight control system for an undetermined reason.
- [NTSB MIA96LA227](https://openairdocs.org/ntsb/MIA96LA227.md): Agusta A109A II · Flamingo, FL · Accident · No injuries · Limited investigation · Final report · Sep 6, 1996 · N169BH · Substantial damage
  > The pilot being unable to stop the helicopter after encounter wet grass after making a precautionary landing in an unlit parking lot following loss of power in one engine and illumination of a transmission chip detector light.
- [NTSB IAD96LA144](https://openairdocs.org/ntsb/IAD96LA144.md): Cessna 150L · Hope, ME · Accident · No injuries · Limited investigation · Final report · Sep 6, 1996 · N6632G · Substantial damage
  > inadequate preflight, by not refueling the airplane during an en route stop, which led to fuel exhaustion, loss of engine power, and a subsequent forced landing.
- [NTSB SEA96FA209](https://openairdocs.org/ntsb/SEA96FA209.md): Cessna 340A · Wise River, MT · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1996 · N128RP · Destroyed
  > The pilot's attempt to fly in adverse meteorological conditions which led a loss of aircraft control. Factors contributing to the accident include: the pilot's failure to obtain the most current information of the meteorological conditions prior to departure,…
- [NTSB FTW96FA373](https://openairdocs.org/ntsb/FTW96FA373.md): Beech D55 · Corsicana, TX · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1996 · N873LB · Destroyed
  > The pilot's failure to maintain minimum control airspeed which resulted in the loss of control. Factors were the bent collar of the left main fuel tank refueling neck which resulted in fuel siphoning from the tank in flight, the pilot's failure to follow…
- [NTSB DCA96MA079](https://openairdocs.org/ntsb/DCA96MA079.md): McDonnell Douglas DC-10-10CF · Newburgh, NY · Accident · Minor injuries · Class 1 · Major · Final report · Sep 5, 1996 · N68055 · Destroyed
  > an in-flight cargo fire of undetermined origin. (NTSB Report AAR-98/03)
- [NTSB MIA96LA225](https://openairdocs.org/ntsb/MIA96LA225.md): Cessna A188B · Winona, MS · Accident · No injuries · Limited investigation · Final report · Sep 3, 1996 · N53109 · Substantial damage
  > improper maintenance of the airplane by the unqualified pilot/owner, by providing inadequate clearance between a flexible oil hose and a heat shield, which resulted in chafing of the hose, an oil leak, and subsequent oil starvation. A factor relating to the…
- [NTSB LAX96LA325](https://openairdocs.org/ntsb/LAX96LA325.md): Cessna 210L · Glendale, AZ · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1996 · N99NV · Substantial damage
  > The loss of engine power due to the pilot's mismanagement of the fuel system, which resulted in fuel starvation. The passenger's action, which restricted the pilot's ability to control the aircraft, was a factor in this accident.
- [NTSB ANC96LA144](https://openairdocs.org/ntsb/ANC96LA144.md): Cessna 207 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Sep 3, 1996 · N7396U · Substantial damage
  > an in-flight encouter with bird(s)/geese, which resulted in a bird strike.
- [NTSB FTW96LA369](https://openairdocs.org/ntsb/FTW96LA369.md): Piper PA-32R-300 · Salida, CO · Accident · No injuries · Limited investigation · Final report · Sep 2, 1996 · N7640F · Substantial damage
  > total failure of the induction air control linkage (bolt), which allowed the alternate air door to close and starve the engine of air.
- [NTSB FTW96LA367](https://openairdocs.org/ntsb/FTW96LA367.md): Jackson Sonerai I · Santa Fe, NM · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1996 · N103HJ · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. The lack of suitable terrain for the forced landing was a related factor.
- [NTSB FTW96FA368](https://openairdocs.org/ntsb/FTW96FA368.md): Cessna 150F · Jones, LA · Accident · 2 fatal · Field investigation · Final report · Sep 2, 1996 · N8380G · Destroyed
  > VFR flight into instrument meteorological conditions (VMC), and failure of the pilot (PIC) to maintain control of the airplane after becoming spatially disorientation. Factors relating to the accident were: darkness, the adverse weather condition (fog and…
- [NTSB ANC96LA135](https://openairdocs.org/ntsb/ANC96LA135.md): Cessna 206 · Port Alsworth, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1996 · N733KD · Substantial damage
  > the pilot's improper in-flight planning/decision, which resulted in intering a box canyon with insufficient altitude to either execute a turn to safety or outclimb rising terrain. A factor associated with the accident was: the pilot allowed the passenger to…
- [NTSB ANC96FA137](https://openairdocs.org/ntsb/ANC96FA137.md): Piper PA-32 · Haines, AK · Accident · Serious injuries · Field investigation · Final report · Sep 2, 1996 · N2181Z · Substantial damage
  > the pilot's inadvertent flight into instrument meteorological conditions (IMC) failure to maintain adequate altitude/clearance from terrain, while maneuvering to reverse the direction of flight. Factors associated with the accident were: the pilot's…
- [NTSB ANC96LA140](https://openairdocs.org/ntsb/ANC96LA140.md): Piper PA-28-161 · Skwentna, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1996 · N4366Y · Substantial damage
  > corrosion and subsequent fatigue failure of the crankshaft, which resulted in engine failure and a forced landing. Factors related to the accident were: the lack of suitable terrain for a forced landing, and the operator's non-compliance with a service…
- [NTSB LAX96LA322](https://openairdocs.org/ntsb/LAX96LA322.md): Cessna 305A · San Diego, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1996 · N5277G · Substantial damage
  > Fuel exhaustion due to the pilot's improper preflight planning, and an inadequate fuel supply.
- [NTSB FTW96LA366](https://openairdocs.org/ntsb/FTW96LA366.md): Cessna 421B · Conchas, NM · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1996 · N55HU · Destroyed
  > The pilot's inadvertent flight into hail which shattered the pilot's windshield and resulted in his incapacitation due to hypoxia.
- [NTSB CHI96LA333](https://openairdocs.org/ntsb/CHI96LA333.md): Piper PA-32 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Aug 31, 1996 · N2087A · Substantial damage
  > the pilot's improper fuel management, which resulted in fuel starvation and loss of engine power. A factor relating to the accident was: the pilot's improper flare during the forced landing.
- [NTSB CHI96FA322](https://openairdocs.org/ntsb/CHI96FA322.md): Mankovich Sonerai · Jeffersonville, IN · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1996 · N7037J · Destroyed
  > inadequate maintenance and inspection of the airplane by the pilot/owner and other airframe and powerplant mechanics, which failed to assure adequate sealing of the engine firewall, and led to the pilot's incapacitation due to carbon monoxide.
- [NTSB ANC96LA134](https://openairdocs.org/ntsb/ANC96LA134.md): Cessna 180 · Port Alsworth, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 30, 1996 · N8241V · Substantial damage
  > The fuel starvation caused by the unporting of the right fuel tank, and the pilot's inadequate preflight by not dipping the fuel tank to ensure sufficient fuel quantity to prevent the unporting.
- [NTSB MIA96LA220](https://openairdocs.org/ntsb/MIA96LA220.md): Boeing 737-300 · Chattanooga, TN · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1996 · N392US · Minor damage
  > clear air turbulence, which was encountered during cruise flight and resulted in injuries to passengers.
- [NTSB CHI96LA321](https://openairdocs.org/ntsb/CHI96LA321.md): Piper PA-28-180 · Grant City, MO · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1996 · N8456W · Substantial damage
  > low oil level which resulted in the partial loss of engine power, the pilot's intentional operation of the airplane with a known mechanical deficiency, and the hay bale. Factors relating to this accident were the owner/pilot mechanic's failure to comply with…
- [NTSB CHI96IA320](https://openairdocs.org/ntsb/CHI96IA320.md): Cessna 525 · Milwaukee, WI · Incident · No injuries · Incident investigation · Final report · Aug 29, 1996 · N123JN · Minor damage
  > an uncontained failure of a high pressure turbine disk blade retention post due to fatigue. A factor relating to the incident was: inadequate design of the high pressure turbine disk. Fretting on the leading side of the lobe near the fracture origin may have…
- [NTSB NYC96LA176](https://openairdocs.org/ntsb/NYC96LA176.md): Temco D-16A · Hainesport, NJ · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 1996 · N128N · Substantial damage
  > the pilot's improper inflight planning/decision and inadequate management of fuel, which resulted in fuel exhaustion and the loss of engine power.
- [NTSB LAX96LA318](https://openairdocs.org/ntsb/LAX96LA318.md): Cessna 150H · Minden, NV · Accident · Serious injuries · Limited investigation · Final report · Aug 28, 1996 · N788JG · Destroyed
  > the pilot's delayed remedial action when encountering downdrafts while approaching high terrain in high density altitude conditions. The pilot's inadequate supervision of the second pilot was a factor in the accident.
- [NTSB MIA96FA218](https://openairdocs.org/ntsb/MIA96FA218.md): Piper PA-32RT-300 · Lagrange, GA · Accident · 1 fatal · Field investigation · Final report · Aug 27, 1996 · N741RB · Destroyed
  > the pilot's improper procedure by not placing the fuel selector on the tank with the most fuel, which resulted in fuel starvation and a forced landing in a pasture. Contributing factors in this accident were the pilot's inadequate pre-flight and in-flight…
- [NTSB LAX96LA315](https://openairdocs.org/ntsb/LAX96LA315.md): Bell 47-G4A · Guam · Accident · 1 fatal · Limited investigation · Final report · Aug 26, 1996 · N474GA · Destroyed
  > loss of tail rotor control due to improper maintenance.
- [NTSB CHI96LA317](https://openairdocs.org/ntsb/CHI96LA317.md): Piper PA-32R-301 · Stewartville, MN · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 1996 · N801SP · Substantial damage
  > the pilot's improper in-flight planning/decision, which resulted in a failure to reach the proper touchdown point for the landing. The fractured nose gear shimmy damper attaching collar and the jammed nose gear were related factors.
- [NTSB CHI96FA314](https://openairdocs.org/ntsb/CHI96FA314.md): Piper PA-32R-300 · Medford, MN · Accident · 1 fatal · Field investigation · Final report · Aug 26, 1996 · N7133C · Destroyed
  > failure of the pilot to maintain control of the airplane, due to spatial disorientation. Factors relating to the accident were: failure of the (primary) vacuum system and a restriction in the (standby) vacuum system.
- [NTSB SEA96LA203](https://openairdocs.org/ntsb/SEA96LA203.md): Forney F-1 · Bozeman, MT · Accident · No injuries · Limited investigation · Final report · Aug 25, 1996 · N7551C · Substantial damage
  > the pilot's failure to adequately service the engine with oil before flight, which resulted in a loss of oil pressure and a subsequent forced landing. The high vegetation and embankment at the forced landing site were related factors.
- [NTSB NYC96LA173](https://openairdocs.org/ntsb/NYC96LA173.md): Lake LA-250 · Hamilton Twp, NJ · Accident · No injuries · Limited investigation · Final report · Aug 25, 1996 · N8405F · Substantial damage
  > A complete loss of engine power due to inadequate maintenance that contributed to a loose fuel line fitting, a fuel leak and subsequent fuel starvation. The uneven terrain was a factor.
- [NTSB FTW96LA360](https://openairdocs.org/ntsb/FTW96LA360.md): Cresap Early Bird Jenny · Kersey, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1996 · N12JN · Destroyed
  > Failure of the throttle linkage. A related factor was the lack of suitable terrain for the forced landing.
- [NTSB FTW96LA357](https://openairdocs.org/ntsb/FTW96LA357.md): Mooney M20J · Lubbock, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 25, 1996 · N4538H · Substantial damage
  > inadequate maintenance by maintenance personnel, which resulted in a total loss of engine power when the magneto disengaged from the engine. A related factor was the lack of suitable terrain for a forced landing.
- [NTSB LAX96FA317](https://openairdocs.org/ntsb/LAX96FA317.md): Cessna 441 · Phoenix, AZ · Accident · No injuries · Field investigation · Final report · Aug 24, 1996 · N832AD · Substantial damage
  > blockage of the fuel vent system due to mud from wasp nest(s). Inadequate maintenance was a related factor.
- [NTSB ANC96FA131](https://openairdocs.org/ntsb/ANC96FA131.md): Maule M-7 · Barrow, AK · Accident · 2 fatal · Field investigation · Final report · Aug 24, 1996 · N5656A · Destroyed
  > the pilot's inadequate weather evaluation and resultant flight into adverse weather conditions. Factors associated with the accident were: high winds and terrain induced turbulence.
- [NTSB NYC96LA171](https://openairdocs.org/ntsb/NYC96LA171.md): Piper PA-32-260 · Coatsville, PA · Accident · Minor injuries · Limited investigation · Final report · Aug 23, 1996 · N3868W · Destroyed
  > loss of engine power for undetermined reason(s). Factors relating to the accident were: darkness, and the lack of suitable landing areas.
- [NTSB SEA96LA198](https://openairdocs.org/ntsb/SEA96LA198.md): Bell 206B · Glenns Ferry, ID · Accident · Serious injuries · Limited investigation · Final report · Aug 22, 1996 · N3896V · Substantial damage
  > fuel contamination, due to improper servicing of the helicopter, which resulted in an intermittent loss of engine power. A factor relating to the accident was: the pilot's inadequate control of the helicopter, during autorotation with intermittent engine…
- [NTSB MIA96LA215](https://openairdocs.org/ntsb/MIA96LA215.md): Cessna 210M · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Aug 21, 1996 · N732ST · Substantial damage
  > the pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation, a forced landing, and subsequent in flight collision with terrain. The lack of suitable terrain for a forced landing was a related factor.
- [NTSB FTW96FA352](https://openairdocs.org/ntsb/FTW96FA352.md): Grumman American AA-1B · Boulder, CO · Accident · 2 fatal · Field investigation · Final report · Aug 20, 1996 · N6505L · Destroyed
  > The pilot's poor judgment in attempting low altitude flight in mountainous terrain without adequate mountain flying training which led to low altitude maneuvering exceeding the climb capability of the airplane. Factors in the accident were: the pilot's…
- [NTSB CHI96FA316](https://openairdocs.org/ntsb/CHI96FA316.md): Piper PA-28-180 · Hartford, MI · Accident · 1 fatal · Field investigation · Final report · Aug 20, 1996 · N9209J · Substantial damage
  > inaccurate fuel consumption calculations by the pilot before takeoff, and his improper decision not to land before his airplane ran out of fuel.
- [NTSB ATL96LA122](https://openairdocs.org/ntsb/ATL96LA122.md): American AA5 · Crestview, FL · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 1996 · N1198D · Substantial damage
  > the pilot's improper operation of the powerplant controls.
- [NTSB SEA96TA192](https://openairdocs.org/ntsb/SEA96TA192.md): Bell UH-1H · Pendleton, OR · Accident · No injuries · Final report · Aug 19, 1996 · N4734F · Substantial damage
  > undetermined malfunction/failure of a flight control or hydraulic system. Rough terrain in the emergency landing area was a related factor.
- [NTSB CHI96TA306](https://openairdocs.org/ntsb/CHI96TA306.md): Hughes 269A · Cedar Rapids, IA · Accident · Minor injuries · Final report · Aug 19, 1996 · N7052A · Substantial damage
  > partial blocking of the fuel injection control, and a fracture of the induction air ducting for reasons undetermined. A factor was trees.
- [NTSB CHI96FA309](https://openairdocs.org/ntsb/CHI96FA309.md): Piper PA-32-300 · Crystal Lake, IL · Accident · Serious injuries · Field investigation · Final report · Aug 19, 1996 · N823PJ · Destroyed
  > the pilot's inadequate fuel management and which resulted in fuel system exhaustion. The factors involved were the pilot's failure to refuel, inadequate preflight planning/preparation and the dark night conditions encountered.
- [NTSB FTW96LA350](https://openairdocs.org/ntsb/FTW96LA350.md): Hardy Quickie Q-200 · Hudson, CO · Accident · Minor injuries · Limited investigation · Final report · Aug 18, 1996 · N6NH · Substantial damage
  > delamination of a propeller blade. A factor relating to the accident was: the terrain condition in the emergency landing area (soft/sandy berm and ditch).
- [NTSB LAX96LA311](https://openairdocs.org/ntsb/LAX96LA311.md): Atkinson Varieze · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Aug 17, 1996 · N3LV · Substantial damage
  > The fracture and separation of the mixture control cable housing from the carburetor mounting bracket, which resulted in fuel starvation due to an overlean condition, and the pilot's failure to maintain an adequate airspeed while stretching the glide to the…
- [NTSB LAX96FA308](https://openairdocs.org/ntsb/LAX96FA308.md): Cessna 210E · Big Bear City, CA · Accident · 1 fatal · Field investigation · Final report · Aug 17, 1996 · N4931U · Destroyed
  > an inadequate annual inspection conducted by other maintenance personnel.
- [NTSB ATL96FA119](https://openairdocs.org/ntsb/ATL96FA119.md): Cessna 172H · St. Petersburg, FL · Accident · 1 fatal · Field investigation · Final report · Aug 17, 1996 · N8016L · Substantial damage
  > An engine malfunction for undetermined reasons. A factor was the pilot's selection of an unsuitable landing site.
- [NTSB FTW96LA348](https://openairdocs.org/ntsb/FTW96LA348.md): Vans RV-4 · Van Horn, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 16, 1996 · XBINF · Substantial damage
  > loss of engine power due to a cracked oil cooler, which led to the loss of all lubricating oil and an engine seizure. The lack of suitable terrain for a forced landing was a related factor.
- [NTSB NYC96IA168](https://openairdocs.org/ntsb/NYC96IA168.md): Boeing 727-232 · Flushing, NY · Incident · No injuries · Incident investigation · Final report · Aug 14, 1996 · N533DA · No damage
  > a failure of the low pressure turbine assembly for undetermined reason(s).

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

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

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