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

## Cases, newest first

- [NTSB NYC06LA091](https://openairdocs.org/ntsb/NYC06LA091.md): Cessna 150M · Passadumkeag, ME · Accident · Minor injuries · Limited investigation · Final report · Apr 10, 2006 · N714EJ · Substantial damage
  > The partially blocked fuel line, which resulted in fuel starvation and a subsequent loss of engine power. Factors in the accident included inadequate maintenance, and the unsuitable terrain.
- [NTSB CHI06CA107](https://openairdocs.org/ntsb/CHI06CA107.md): Cessna 150 · Sandstone, MN · Accident · No injuries · Data collection · Final report · Apr 10, 2006 · N50970 · Substantial damage
  > The total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight. A contributing factor was the unsuitable terrain encountered during the forced landing.
- [NTSB NYC06LA090](https://openairdocs.org/ntsb/NYC06LA090.md): Piper PA-30 · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Apr 7, 2006 · N7812Y · Substantial damage
  > The pilot's failure to maintain aircraft control during a single-engine go-around. A factor was the partial loss of engine power.
- [NTSB DFW06LA101](https://openairdocs.org/ntsb/DFW06LA101.md): Cirrus Design SR20 · Kerrville, TX · Accident · No injuries · Limited investigation · Final report · Apr 7, 2006 · N142SF · Substantial damage
  > The loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL06LA061](https://openairdocs.org/ntsb/ATL06LA061.md): Ayres S2R-T34 · Folkston, GA · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 2006 · N3096H · Substantial damage
  > The total loss of engine power due to the failure of the compressor turbine blades due to high temperature exposure.
- [NTSB DCA06FA033](https://openairdocs.org/ntsb/DCA06FA033.md): Mcdonnell Douglas DC10 · Memphis, TN · Accident · No injuries · Field investigation · Final report · Apr 4, 2006 · N386FE · Substantial damage
  > The rupture of a fatigue crack in the forward air seal tooth serration of the No. 3 engine low pressure turbine stage 1 disk that initiated due to an improper weld repair performed during original manufacture. The improper weld repair changed the material…
- [NTSB ANC06LA043](https://openairdocs.org/ntsb/ANC06LA043.md): Taylorcraft BC12-65 · Iliamna, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 2006 · N36291 · Substantial damage
  > The pilot's delayed use of carburetor heat, which resulted in a loss of engine power during cruise, and an in-flight collision with snow-covered terrain. Factors associated with the accident were an unfavorable wind, and the pilot's inadvertent stall of the…
- [NTSB MIA06LA077](https://openairdocs.org/ntsb/MIA06LA077.md): Marvin T Eiland SparrowHawk · Ona, FL · Accident · 2 fatal · Limited investigation · Final report · Mar 31, 2006 · N41964 · Substantial damage
  > The in-flight loss of control for undetermined reasons during a normal descent, resulting in an uncontrolled descent, and in-flight collision with terrain.
- [NTSB DEN06CA054](https://openairdocs.org/ntsb/DEN06CA054.md): Cessna 170B · Benton, KS · Accident · No injuries · Data collection · Final report · Mar 31, 2006 · N2359J · Substantial damage
  > the pilot's failure to maintain directional control of the airplane resulting in a ground loop. Contributing factors include the inadequate preflight inspection, the pilot's failure to properly latch the cowling, and the pilot's diverted attention to the open…
- [NTSB NYC06LA086](https://openairdocs.org/ntsb/NYC06LA086.md): Diamond Aircraft Industries DA 20-C1 · Clay Township, PA · Accident · Serious injuries · Limited investigation · Final report · Mar 30, 2006 · N346DC · Substantial damage
  > A loss of engine power during cruise flight for undetermined reasons, which resulted in a forced landing and subsequent impact with trees.
- [NTSB LAX06FA133](https://openairdocs.org/ntsb/LAX06FA133.md): Rockwell 112 TCA · La Canada, CA · Accident · 1 fatal · Field investigation · Final report · Mar 30, 2006 · N4641W · Destroyed
  > The pilot's failure to maintain aircraft control and an adequate airspeed during climb to cruise that led to a stall/spin. Contributing to the accident were the clouds and the pilot's physiological state.
- [NTSB LAX06CA140](https://openairdocs.org/ntsb/LAX06CA140.md): Piper PA-31-310 · Victorville, CA · Accident · No injuries · Data collection · Final report · Mar 30, 2006 · N7086Z · Substantial damage
  > an in-flight collision with a bird.
- [NTSB LAX06FA131](https://openairdocs.org/ntsb/LAX06FA131.md): Cessna 208B · Oak Glen, CA · Accident · 2 fatal · Field investigation · Final report · Mar 29, 2006 · N208WE · Destroyed
  > The pilot's continued flight into instrument meteorological weather conditions and his subsequent failure to maintain an adequate airspeed while maneuvering, that led to a stall/spin.
- [NTSB MIA06LA071](https://openairdocs.org/ntsb/MIA06LA071.md): Cessna 402C · Dorado, PR · Accident · Serious injuries · Limited investigation · Final report · Mar 27, 2006 · N223PB · No damage
  > The failure of the pilot to use on-board weather radar equipment for weather avoidance and the pilot's continued operation into known adverse weather conditions, resulting in injury to passengers.
- [NTSB DFW06CA092](https://openairdocs.org/ntsb/DFW06CA092.md): Waterwings SeaRey · Vicksburg, MS · Accident · No injuries · Data collection · Final report · Mar 26, 2006 · N42685 · Destroyed
  > The pilot's inadvertent reduction of power resuting in a collision with water. Contributing factors were the low altiude selected and the pilot's inattention.
- [NTSB ANC06LA030](https://openairdocs.org/ntsb/ANC06LA030.md): Mooney M-10 · Salinas, CA · Accident · 1 fatal · Limited investigation · Final report · Mar 25, 2006 · N9533V · Substantial damage
  > The pilot's continued flight into known adverse weather, and his failure to maintain sufficient airspeed, which resulted in a loss of control and an inadvertent stall/spin during cruise flight. Factors associated with the accident are a low ceiling with…
- [NTSB CHI06LA095](https://openairdocs.org/ntsb/CHI06LA095.md): Cessna 172G · Collins, MO · Accident · No injuries · Limited investigation · Final report · Mar 22, 2006 · N4444L · Substantial damage
  > The pilot's inaccurate fuel consumption calculations that resulted in fuel exhaustion, and the loss of engine power during cruise flight. An additional cause was the pilot's improper in-flight decision to continue when he believed his fuel gauges were erratic…
- [NTSB DFW06LA087](https://openairdocs.org/ntsb/DFW06LA087.md): Weatherly 201B · Hondo, TX · Accident · 1 fatal · Limited investigation · Final report · Mar 21, 2006 · N1257W · Substantial damage
  > A loss of aircraft control for undetermined reasons.
- [NTSB LAX06FA130](https://openairdocs.org/ntsb/LAX06FA130.md): Beech F33A · Kingman, AZ · Accident · 2 fatal · Field investigation · Final report · Mar 20, 2006 · N41PT · Destroyed
  > The noninstrument rated pilot's cruise flight into instrument meteorological conditions, and his failure to maintain control of the airplane, which resulted in an uncontrolled descent, and an in-flight collision with terrain. Factors associated with the…
- [NTSB DEN06LA050](https://openairdocs.org/ntsb/DEN06LA050.md): Piper PA-23-250 · Emporia, KS · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 2006 · N331FC · Substantial damage
  > the pilot's attempted flight into adverse weather conditions and improper in-flight planning which resulted in loss of control and subsequent impact with trees. Contributing factors were the pilot's delayed remedial action, the icing and dark night conditions.
- [NTSB ATL06IA054](https://openairdocs.org/ntsb/ATL06IA054.md): Bombardier CL-600-2B19 · Asheville, NC · Incident · No injuries · Incident investigation · Final report · Mar 19, 2006 · N8783E · Minor damage
  > The improper installation of the pilot's windshield by company maintenance personnel, which resulted in flame and smoke in the cockpit, and subsequent emergency landing.
- [NTSB NYC06FA079](https://openairdocs.org/ntsb/NYC06FA079.md): Beech 56TC · Winfield, WV · Accident · 1 fatal · Field investigation · Final report · Mar 18, 2006 · N18LL · Substantial damage
  > The pilot's inadequate preflight preparation to ensure an adequate supply of supplemental oxygen, and his inadequate in-flight planning and decision making, which resulted in exhaustion of his oxygen supply, and incapacitation from hypoxia during cruise…
- [NTSB ATL06LA053](https://openairdocs.org/ntsb/ATL06LA053.md): Piper PA28-180F · Easley, SC · Accident · Minor injuries · Limited investigation · Final report · Mar 18, 2006 · N2133T · Substantial damage
  > Loss of engine power for undetermined reasons which resulted in a forced landing and subsequent in-flight collision with non-suitable terrain.
- [NTSB CHI06LA099](https://openairdocs.org/ntsb/CHI06LA099.md): Boeing 757-222 · Omaha, NE · Accident · Serious injuries · Limited investigation · Final report · Mar 15, 2006 · N518UA · No damage
  > An inadvertent encounter with unforecast mountain wave turbulence during cruise flight. A contributing factor was the mountain wave (terrain induced) turbulence.
- [NTSB DFW06FA083](https://openairdocs.org/ntsb/DFW06FA083.md): Bell 206L-1 · Patterson, LA · Accident · 2 fatal · Field investigation · Final report · Mar 14, 2006 · N370RL · Destroyed
  > The improper installation of an engine fuel line fitting by other maintenance personnel, which resulted in a loose fitting and a loss of engine power during cruise flight. Factors associated with the accident are a tailwind, and the lack of a suitable site…
- [NTSB MIA06LA063](https://openairdocs.org/ntsb/MIA06LA063.md): Piper PA-32RT-300T · Baker, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 2006 · N321GS · Substantial damage
  > A loss of engine power due to an oil line leak and oil exhaustion. A contributing factor was the unsuitable terrain on which to make a forced landing.
- [NTSB ATL06LA051](https://openairdocs.org/ntsb/ATL06LA051.md): Eakle R Grandin Jr Talon XP · Auburn, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 2006 · N97GE · Substantial damage
  > The pilot's failure to maintain airspeed which resulted in an inadvertent stall. A factor was the improper maintenance inspection of the engine fuel lines resulting in loss of engine power due to a loose fuel line and subsequent fuel starvation.
- [NTSB ATL06LA050](https://openairdocs.org/ntsb/ATL06LA050.md): Cessna 210 · Jesup, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 2006 · N6540X · Substantial damage
  > The loss of engine power due to the fatigue failure of the crankshaft, which resulted in a forced landing, and an in-flight collision with trees. A factor associated with the accident was the failure of other maintenance personnel to comply with the engine…
- [NTSB ATL06LA049](https://openairdocs.org/ntsb/ATL06LA049.md): Ercoupe E · Wetumpka, AL · Accident · No injuries · Limited investigation · Final report · Mar 8, 2006 · N94840 · Substantial damage
  > The failure of the No. 2 exhaust, and intake valves for undetermined reasons, which resulted in a loss of engine power during cruise flight and damage to the airplane during the subsequent forced landing.
- [NTSB CHI06CA098](https://openairdocs.org/ntsb/CHI06CA098.md): Piper PA-28-180 · Holly, MI · Accident · No injuries · Data collection · Final report · Mar 7, 2006 · N7810N · Substantial damage
  > A loss of engine power due to undetermined reasons. Factors associated with the accident were the guard rail and the ditch which the airplane contacted during the forced landing.
- [NTSB DEN06LA046](https://openairdocs.org/ntsb/DEN06LA046.md): Aviat Pitts S-2B · Severance, CO · Accident · No injuries · Limited investigation · Final report · Mar 5, 2006 · N221RS · Substantial damage
  > fuel exhaustion and the pilot's failure to refuel the airplane. Contributing factors were the inaccurate fuel flow reading and the pilot's incorrect fuel consumption calculations.
- [NTSB ATL06LA048](https://openairdocs.org/ntsb/ATL06LA048.md): Joel H Johnson Rans S-6ES Coyote II · Cartersville, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 5, 2006 · N5196W · Substantial damage
  > The loss of engine power during cruise flight for undetermined reasons, which resulted in an forced landing, on ground collision with a ditch, and nose over.
- [NTSB MIA06LA061](https://openairdocs.org/ntsb/MIA06LA061.md): Bell 206B · Naples, FL · Accident · No injuries · Limited investigation · Final report · Mar 4, 2006 · N6BR · Substantial damage
  > The pilot's selection of an unsuitable area to make a precautionary landing which resulted in the helicopter rolling into a ditch.
- [NTSB DFW06CA081](https://openairdocs.org/ntsb/DFW06CA081.md): Grumman-Schweizer G-164B · Texarkana, AR · Accident · Minor injuries · Data collection · Final report · Mar 4, 2006 · N6641Q · Substantial damage
  > The loss of engine power due to a cracked cylinder. Contributing factors were the pilot's failure to maintain adequate airspeed.
- [NTSB DFW06CA077](https://openairdocs.org/ntsb/DFW06CA077.md): Cessna 182C · Gilliam, LA · Accident · No injuries · Data collection · Final report · Mar 4, 2006 · N8519T · Substantial damage
  > The loss of engine power due to carburetor ice. Contributing factors were the pilot's failure to use carburetor heat and the lack of suitable terrain for the forced landing.
- [NTSB MIA06LA058](https://openairdocs.org/ntsb/MIA06LA058.md): Mooney M20J · Fort Pierce, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 1, 2006 · N511G · Substantial damage
  > Improper magneto installation by maintenance personnel, which resulted in the magneto detaching from the engine and subsequent loss of engine power.
- [NTSB CHI06LA088](https://openairdocs.org/ntsb/CHI06LA088.md): Irwin Sonex 2180 · Rockford, IL · Accident · No injuries · Limited investigation · Final report · Feb 27, 2006 · N514KP · Substantial damage
  > The loss of engine power due to the restricted movement of the throttle cable during cruise flight. A factor in the accident was the trees contacted during the forced landing.
- [NTSB DEN06LA044](https://openairdocs.org/ntsb/DEN06LA044.md): Piper PA-28RT-201T · Parker, CO · Accident · No injuries · Limited investigation · Final report · Feb 25, 2006 · N2939V · Substantial damage
  > the improper maintenance procedures resulting in the unseating of the number two main bearing. Contributing factors include the mechanic's improper troubleshooting procedures, and the pilot's improper decision to continue operating the airplane with known…
- [NTSB CHI06LA087](https://openairdocs.org/ntsb/CHI06LA087.md): Cessna 150G · Rockford, OH · Accident · Serious injuries · Limited investigation · Final report · Feb 24, 2006 · N6366S · Substantial damage
  > The fuel exhaustion due to the inadequate preflight planning/preparation by the pilot-in-command. Additional causes were the inadequately planned approach and improper emergency procedure by the pilot-in-command.
- [NTSB SEA06FA055](https://openairdocs.org/ntsb/SEA06FA055.md): Cessna 182P · Goldendale, WA · Accident · 2 fatal · Field investigation · Final report · Feb 23, 2006 · N888SR · Destroyed
  > The pilot's failure to maintain terrain clearance during descent. Factors contributing to the accident were the high mountains, mountain obscuration, the dark night condition, and the pilot's improper in-flight planning/decision making.
- [NTSB SEA06FA054](https://openairdocs.org/ntsb/SEA06FA054.md): Beech 58P · Bow, WA · Accident · 1 fatal · Field investigation · Final report · Feb 23, 2006 · N469MD · Destroyed
  > The pilot's failure to maintain aircraft control during the climb to cruise. Contributing factors included a loss of engine power to the right engine folowing a turbocharger failure, instrument meteorological and dark night conditions.
- [NTSB ANC06FA020](https://openairdocs.org/ntsb/ANC06FA020.md): Robinson R22 · Scottsdale, AZ · Accident · 2 fatal · Field investigation · Final report · Feb 22, 2006 · N7512G · Destroyed
  > A loss of engine power during cruise flight for an undetermined reason, and the pilot's failure to maintain rotor rpm, which resulted in an uncontrolled descent and collision with terrain.
- [NTSB DEN06LA040](https://openairdocs.org/ntsb/DEN06LA040.md): Piper PA-28-235 · Torreon, NM · Accident · No injuries · Limited investigation · Final report · Feb 20, 2006 · N9149W · Substantial damage
  > The jammed magneto drive gear and the fractured camshaft gear, which resulted in the total engine failure. A factor contributing to the accident was the unsuitable dirt road on which the pilot had to force land the airplane.
- [NTSB MIA06LA056](https://openairdocs.org/ntsb/MIA06LA056.md): Cessna 150L · Fruitland Park, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 18, 2006 · N5262Q · Substantial damage
  > The fatigue failure of the No. 4 cylinder resulting in a loss of engine power and subsequent forced landing.
- [NTSB LAX06CA120](https://openairdocs.org/ntsb/LAX06CA120.md): Cessna 177 · Carefree, AZ · Accident · No injuries · Data collection · Final report · Feb 18, 2006 · N29377 · Substantial damage
  > fuel exhaustion due to the pilot's inaccurate fuel consumption calculations and his failure to refuel the airplane prior to the accident flight.
- [NTSB MIA06LA054](https://openairdocs.org/ntsb/MIA06LA054.md): Piper PA-28-140 · Lehigh Acres, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 16, 2006 · N14MA · Substantial damage
  > The loss of engine power for undetermined reasons, resulting in a nose-over during the forced landing.
- [NTSB LAX06FA113](https://openairdocs.org/ntsb/LAX06FA113.md): Cessna 210M · Long Beach, CA · Accident · Serious injuries · Field investigation · Final report · Feb 13, 2006 · N6895B · Destroyed
  > an erroneous low fuel quantity indication that led the pilot to attempt a precautionary landing in a congested and less than ideal location. The erroneous fuel level indication was due to multiple anomalies with the alternator installation that precipitated a…
- [NTSB LAX06FA106](https://openairdocs.org/ntsb/LAX06FA106.md): Cessna 172RG · El Cajon, CA · Accident · 3 fatal · Field investigation · Final report · Feb 9, 2006 · N9531B · 2 aircraft · Destroyed
  > The pilots of both airplanes failure to maintain an adequate visual lookout due to their relative flight paths, which limited the available visual cues. Factors were the failure of the air traffic controller(s) to issue a conflict alert to the Cessna 172RG…
- [NTSB DCA06MA022](https://openairdocs.org/ntsb/DCA06MA022.md): Douglas DC-8 · Philadelphia, PA · Accident · Minor injuries · Class 1 · Major · Final report · Feb 8, 2006 · N748UP · Destroyed
  > an in-flight cargo fire that initiated from an unknown source, which was most likely located within cargo container 12, 13, or 14. Contributing to the loss of the aircraft were the inadequate certification test requirements for smoke and fire detection…
- [NTSB ATL06FA045](https://openairdocs.org/ntsb/ATL06FA045.md): Swearingen SA-226-TC · Paris, TN · Accident · 1 fatal · Field investigation · Final report · Feb 8, 2006 · N629EK · Destroyed
  > The pilot's inflight loss of control following a reported fuel asymmetry condition for undetermined reasons.

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

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

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