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

## Cases, newest first

- [NTSB MIA03IA157](https://openairdocs.org/ntsb/MIA03IA157.md): Cessna 402C · Arecibo, PR · Incident · No injuries · Incident investigation · Final report · Aug 5, 2003 · N371R · No damage
  > The pilot’s inadequate in-flight decision, and his failure to refuel, which led to fuel exhaustion and subsequent loss of engine power.
- [NTSB DEN03FA138](https://openairdocs.org/ntsb/DEN03FA138.md): Wright Hughes 1-B · Yellowstone Nat, WY · Accident · 1 fatal · Field investigation · Final report · Aug 5, 2003 · N258Y · Destroyed
  > The in-flight loss of a propeller counterweight, followed by the pilot's loss of aircraft control during a forced landing attempt and subsequent inadvertent stall/spin to the ground.
- [NTSB CHI03FA246](https://openairdocs.org/ntsb/CHI03FA246.md): Piper PA-28-180 · Clarkfield, MN · Accident · 1 fatal · Field investigation · Final report · Aug 5, 2003 · N4577T · Destroyed
  > The pilot not maintaining altitude/clearance from terrain and his continued VFR flight into IMC during cruise flight. A factor was the low ceilings.
- [NTSB MIA03LA155](https://openairdocs.org/ntsb/MIA03LA155.md): McDonnell Douglas MD-82 · Charlotte, NC · Accident · Serious injuries · Limited investigation · Final report · Aug 4, 2003 · N7527A · No damage
  > The pilot-in-command's failure to sufficiently deviate to avoid known weather, and his failure to activate the seatbelt sign to ensure flight attendants and passengers were seated, which resulted in a passenger receiving serious injuries when the flight…
- [NTSB CHI03LA255](https://openairdocs.org/ntsb/CHI03LA255.md): Taylorcraft F19 · Lakewood, WI · Accident · No injuries · Limited investigation · Final report · Aug 4, 2003 · N3575T · Substantial damage
  > A loss of engine power due to fuel starvation as a result of the pilot's improper use of the fuel system. A related factor was the tree.
- [NTSB MIA03LA154](https://openairdocs.org/ntsb/MIA03LA154.md): Piper PA-31-310 · Jupiter, FL · Accident · Minor injuries · Limited investigation · Final report · Aug 2, 2003 · N876RD · Substantial damage
  > The pilot's failure to adequately plan for the flight which resulted in fuel exhaustion, a forced landing, and damage to the airplane during the landing.
- [NTSB FTW03LA198](https://openairdocs.org/ntsb/FTW03LA198.md): Piper PA-28R-201T · Alpine, TX · Accident · No injuries · Limited investigation · Final report · Aug 2, 2003 · N251BC · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain available to the pilot for the forced landing.
- [NTSB CHI03LA245](https://openairdocs.org/ntsb/CHI03LA245.md): Cessna 150L · Pine Bluff, AR · Accident · No injuries · Limited investigation · Final report · Aug 2, 2003 · N6791G · Substantial damage
  > Inadequate preflight planning which resulted in fuel exhaustion during the cross country flight. A factor associated with the accident was the rough terrain encountered during the forced landing.
- [NTSB CHI03LA242](https://openairdocs.org/ntsb/CHI03LA242.md): Teratorn · Elbow Lake, MN · Accident · 1 fatal · Limited investigation · Final report · Aug 2, 2003 · UNREG · Destroyed
  > The pilot's intentional flight into known fog and failure to maintain aircraft control during cruise flight. A factor was the fog, and the low altitude flight.
- [NTSB ANC03LA085](https://openairdocs.org/ntsb/ANC03LA085.md): Cessna 207 · Anchorage, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 1, 2003 · N29CF · Substantial damage
  > The pilot's incorrect positioning of the fuel tank selector valve to a nearly empty tank, which resulted in a loss of engine power due to fuel starvation, and subsequent emergency landing at an off-airport site. Factors associated with the accident were the…
- [NTSB NYC03LA171](https://openairdocs.org/ntsb/NYC03LA171.md): Stewart Hummel Bird · North Baltimore, OH · Accident · 1 fatal · Limited investigation · Final report · Jul 31, 2003 · N7075Y · Substantial damage
  > The loss of engine power for undetermined reasons, and the pilot's failure to maintain airspeed, which resulted in an inadvertent stall during an emergency landing.
- [NTSB LAX03IA252](https://openairdocs.org/ntsb/LAX03IA252.md): Bell 222 · Salinas, CA · Incident · No injuries · Incident investigation · Final report · Jul 30, 2003 · N29KH · No damage
  > The fatigue failure (fracture) of the right forward transmission lift link during cruise flight, which resulted in a severe vibration and an emergency landing.
- [NTSB SEA03LA157](https://openairdocs.org/ntsb/SEA03LA157.md): Schleicher ASW-24E · Hood River, OR · Accident · 1 fatal · Limited investigation · Final report · Jul 28, 2003 · N24YB · Substantial damage
  > The pilot's failure to refuel prior to the flight, resulting in fuel exhaustion during the initial climb, followed by the pilot's failure to maintain airspeed. An inadvertent stall was a factor.
- [NTSB CHI03LA226](https://openairdocs.org/ntsb/CHI03LA226.md): Cessna 177 · Murdock, NE · Accident · No injuries · Limited investigation · Final report · Jul 27, 2003 · N2336Y · Substantial damage
  > The pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power. Contributing to the accident were the trees and unsuitable terrain.
- [NTSB SEA03GA153](https://openairdocs.org/ntsb/SEA03GA153.md): Kaman K-1200 · Keller, WA · Accident · 1 fatal · Final report · Jul 26, 2003 · N314KA · Destroyed
  > Corrosion fatigue within the blade retention bolt bushing(s) of the main rotor blade grip resulting in fatigue, cracking and ultimate separation of the upper grip plate. The separation of the upper blade grip plate led to a dynamic imbalance within the rotor…
- [NTSB NYC03LA168](https://openairdocs.org/ntsb/NYC03LA168.md): Air Tractor AT-301 · Rhinebeck, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 2003 · N23820 · Substantial damage
  > A loss of engine power due to a failure of the number eight cylinder.
- [NTSB ATL03LA120](https://openairdocs.org/ntsb/ATL03LA120.md): Gulfstream American AA-5A · Canon, GA · Accident · Minor injuries · Limited investigation · Final report · Jul 26, 2003 · N727FT · Substantial damage
  > The loss of engine power due to water and corrosion in the fuel system. A factor was the collision with a ditch.
- [NTSB MIA03LA149](https://openairdocs.org/ntsb/MIA03LA149.md): Piper PA-25-235 · Plantation, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 2003 · N72AB · Substantial damage
  > The pilot's improper preflight planning and failure to refuel before the flight, which resulted in fuel exhaustion, a forced landing and damage to the airplane during the landing.
- [NTSB LAX03LA243](https://openairdocs.org/ntsb/LAX03LA243.md): Beech V35B · Livermore, CA · Accident · No injuries · Limited investigation · Final report · Jul 24, 2003 · N386TC · Substantial damage
  > The pilot's inadequate fuel management, which resulted in fuel starvation and a loss of engine power during cruise flight.
- [NTSB LAX03LA242](https://openairdocs.org/ntsb/LAX03LA242.md): Smith Miniplane · Winnemucca, NV · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 2003 · N721SC · Substantial damage
  > The pilot's failure to refuel the airplane prior to fuel exhaustion, which resulted in a loss of engine power during cruise flight, and subsequent in-flight collision with terrain. A factor associated with the accident is the night light conditions.
- [NTSB SEA03FA147](https://openairdocs.org/ntsb/SEA03FA147.md): Cessna Citation 525 · Coupeville, WA · Accident · No injuries · Field investigation · Final report · Jul 22, 2003 · N996JR · Substantial damage
  > The loss of airplane pitch control (trim runway and mistrim condition) resulting from a failure in the airplane's electric pitch trim system. Factors that contributed to the accident were the manufacturer's inadequate design of the pitch trim circuitry that…
- [NTSB NYC03CA169](https://openairdocs.org/ntsb/NYC03CA169.md): Boeing 757-251 · Wadsworth, OH · Accident · Serious injuries · Data collection · Final report · Jul 22, 2003 · N504US · No damage
  > An in-flight encounter with turbulence.
- [NTSB SEA03LA146](https://openairdocs.org/ntsb/SEA03LA146.md): Cessna 182S · Henry's Lake, ID · Accident · No injuries · Limited investigation · Final report · Jul 21, 2003 · N146NE · Substantial damage
  > A set of inadequately torqued vacuum pump retaining nuts, leading to the failure of the vacuum pump gasket, resulting in oil exhaustion, which resulted in a loss of engine power during cruise. A ditch and rough uneven terrain were factors.
- [NTSB IAD03LA066](https://openairdocs.org/ntsb/IAD03LA066.md): Cessna T210N · Hampton Bays, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 2003 · N155RR · Destroyed
  > A loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI03FA219](https://openairdocs.org/ntsb/CHI03FA219.md): Piper PA-28-235 · Jackson, MN · Accident · 1 fatal · Field investigation · Final report · Jul 21, 2003 · N33774 · Destroyed
  > The pilot's intentional flight into terrain as an act of suicide.
- [NTSB MIA03LA143](https://openairdocs.org/ntsb/MIA03LA143.md): Cessna 172P · Plymouth, FL · Accident · No injuries · Limited investigation · Final report · Jul 20, 2003 · N52186 · Substantial damage
  > The pilot's continue operation with known deficiencies (engine vibration) resulting in a partial loss of engine power during climb after takeoff and overrun of the runway during the aborted takeoff.
- [NTSB CHI03LA217](https://openairdocs.org/ntsb/CHI03LA217.md): Enstrom F-28C · Waverly, IA · Accident · No injuries · Limited investigation · Final report · Jul 20, 2003 · N51699 · Substantial damage
  > The main rotor blade push-pull rods being corroded, sustaining fatigue, and separating in cruise and the main rotor blade contacting the tail boom during the emergency landing. Factors were the diminished aircraft control and the vibrations encountered during…
- [NTSB LAX03LA217](https://openairdocs.org/ntsb/LAX03LA217.md): Rans S-10 Sakota/A · Paulden, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 2003 · N222EJ · Substantial damage
  > a loss of engine power due to fuel starvation for undetermined reasons.
- [NTSB DEN03FA133](https://openairdocs.org/ntsb/DEN03FA133.md): Grumman American AA-5B · Steamboat Sprng, CO · Accident · 3 fatal · Field investigation · Final report · Jul 19, 2003 · N742BM · Destroyed
  > The pilot's failure to maintain terrain clearance. Contributing factors include the pilot's inadequate preflight planning/preparation, high density altitude, and mountainous conditions.
- [NTSB ATL03LA118](https://openairdocs.org/ntsb/ATL03LA118.md): Boeing PT-17 · Hendersonville, NC · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 2003 · N411BT · Substantial damage
  > The pilot's inadequate preflight planning/preparation of fuel required for the flight, resulting in a total loss of engine power due to fuel exhaustion. A factor in the accident was pilot impairment due to alcohol consumption.
- [NTSB SEA03LA164](https://openairdocs.org/ntsb/SEA03LA164.md): Beech A35 · Freeland, WA · Accident · No injuries · Limited investigation · Final report · Jul 18, 2003 · N8598A · Substantial damage
  > A partially blocked fuel injector which led to an over temperature condition in the cylinders resulting in a loss of engine power during cruise flight. Sandy terrain conditions for the landing was a factor.
- [NTSB FTW03LA188](https://openairdocs.org/ntsb/FTW03LA188.md): Mooney M20F · Kerrville, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 18, 2003 · N353JT · Substantial damage
  > The loss of engine power due to the failure of the number three cylinder as the result of undertorqued cylinder bolts. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX03LA235](https://openairdocs.org/ntsb/LAX03LA235.md): Robinson R44 · Happy Jack, AZ · Accident · No injuries · Limited investigation · Final report · Jul 17, 2003 · N8329B · Substantial damage
  > the partial loss of engine power due to an excessively lean mixture for undetermined reasons during cruise flight.
- [NTSB CHI03LA237](https://openairdocs.org/ntsb/CHI03LA237.md): Boeing B777-222 · Chicago, IL · Accident · Serious injuries · Limited investigation · Final report · Jul 17, 2003 · N779UA · No damage
  > The turbulence encountered during the descent which seriously injured a passenger returning to her seat after the seat belt sign was activated. A factor was that it was not possible for the returning passenger to comply with the lit seat belt sign.
- [NTSB DEN03LA130](https://openairdocs.org/ntsb/DEN03LA130.md): Aerostar RX-8 · Snowmass Villag, CO · Accident · No injuries · Limited investigation · Final report · Jul 16, 2003 · N35965 · 2 aircraft · Substantial damage
  > the failure of the pilot of balloon #2 to maintain clearance from balloon #1 while overtaking him.
- [NTSB CHI03LA213](https://openairdocs.org/ntsb/CHI03LA213.md): Allenberg Swick BC 12-D · Winsted, MN · Accident · 1 fatal · Limited investigation · Final report · Jul 16, 2003 · N7895A · Destroyed
  > The inadequate aircraft preflight by both pilots of the closed main fuel valve which led to fuel starvation of the engine. Additional causes were the lack of recent experience in the accident airplane and the inadvertent stall by both pilots after a loss of…
- [NTSB ANC03LA076](https://openairdocs.org/ntsb/ANC03LA076.md): Cessna 401 · Gustavus, AK · Accident · 4 fatal · Limited investigation · Final report · Jul 14, 2003 · N6296Q · Destroyed
  > The pilot's inadequate in-flight decision making process, and failure to refuel the airplane prior to fuel exhaustion, which resulted in a total loss of engine power. A factor associated with the accident was the lack of a suitable forced landing site.
- [NTSB NYC03CA156](https://openairdocs.org/ntsb/NYC03CA156.md): Mooney M20C · Utica, OH · Accident · Minor injuries · Data collection · Final report · Jul 13, 2003 · N33WL · Substantial damage
  > The pilot's improper fuel consumption calculations, which resulted in fuel exhaustion. A factor was the unsuitable terrain.
- [NTSB MIA03FA141](https://openairdocs.org/ntsb/MIA03FA141.md): Cessna 402C · Treasure Cay, Bahamas · Accident · 2 fatal · Class 1 · Field · Final report · Jul 13, 2003 · N314AB · Substantial damage
  > the in-flight failure of the right engine and the pilot’s failure to adequately manage the airplane’s performance after the engine failed. The right engine failure resulted from inadequate maintenance that was performed by Air Sunshine’s maintenance personnel…
- [NTSB IAD03LA064](https://openairdocs.org/ntsb/IAD03LA064.md): Piper PA-34-220T · Burnet, TX · Accident · No injuries · Limited investigation · Final report · Jul 12, 2003 · N2463M · Substantial damage
  > The pilot's failure to properly manage the airplane's fuel supply which led to the total loss of engine power, due to fuel starvation. A factor contributing to the accident was the presence of trees in the landing area used by the pilot to perform the…
- [NTSB SEA03LA132](https://openairdocs.org/ntsb/SEA03LA132.md): Hanks Avid Flyer · Toledo, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 2003 · N3086G · Substantial damage
  > The pilot's failure to maintain aircraft control during a simulated emergency descent. Inadequate remedial action was a factor.
- [NTSB ANC03LA073](https://openairdocs.org/ntsb/ANC03LA073.md): Bell 206B · Aniak, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 10, 2003 · N111MT · Substantial damage
  > The compressor discharge pressure line (Pc line) B-nut coming loose at the fuel control unit, which resulted in a total loss of engine power, and subsequent in-flight collision with trees during an autorotation. A factor associated with the accident was the…
- [NTSB NYC03LA155](https://openairdocs.org/ntsb/NYC03LA155.md): Beech BE-56TC · Bethany, WV · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 2003 · N156DK · Substantial damage
  > A total loss of power in the right engine for undetermined reasons. A factor was a partial loss of power in the left engine due to a loose oil line.
- [NTSB ANC03LA071](https://openairdocs.org/ntsb/ANC03LA071.md): Cessna 208B · Kotzebue, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 2003 · N410GV · No damage
  > The airplane encountered unforecast turbulence, which resulted in serious injury to the pilot.
- [NTSB SEA03LA129](https://openairdocs.org/ntsb/SEA03LA129.md): Cessna 182J · Athol, ID · Accident · No injuries · Limited investigation · Final report · Jul 5, 2003 · N3367F · Substantial damage
  > The failure of one of the number five connecting rod cap bolts during cruise flight due to the associated number five rod cap bolt nut being insufficiently torqued at the last major overhaul. Factors include a culvert alongside the road where the pilot found…
- [NTSB NYC03FA148](https://openairdocs.org/ntsb/NYC03FA148.md): Beech F-35 · Middlesboro, KY · Accident · 2 fatal · Field investigation · Final report · Jul 5, 2003 · N205 · Destroyed
  > The pilot's improper decision to descend into clouds, and his exceeding the maximum speed and design stress limits of the airplane, which resulted in an in-flight breakup and subsequent collision with terrain.
- [NTSB LAX03LA225](https://openairdocs.org/ntsb/LAX03LA225.md): American Eurocopter AS350BA · Temple Bar, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 2003 · N2273A · Substantial damage
  > the pilot's failure to follow the published electrical system emergency procedures for a hot battery, and his misjudged landing flare during the terminal phase of the autorotation maneuver at low level.
- [NTSB DEN03LA120](https://openairdocs.org/ntsb/DEN03LA120.md): Conn Vans RV-4 · Durango, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 2003 · N78DR · Substantial damage
  > partial propeller blade separation for reasons undetermined, and the pilot's misjudgment of distance and altitude during the forced landing approach that resulted in his overshooting the road on intended landing and colliding with trees. A contributing factor…
- [NTSB CHI03LA201](https://openairdocs.org/ntsb/CHI03LA201.md): McIlraith Sea Rey · Tomah, WI · Accident · 2 fatal · Limited investigation · Final report · Jul 5, 2003 · N216ST · Destroyed
  > The loss of engine power for an undetermined reason, and the pilot's failure to maintain airspeed resulting in a stall/spin during the forced landing.
- [NTSB SEA03FA124](https://openairdocs.org/ntsb/SEA03FA124.md): Beech A36TC · East Wenatchee, WA · Accident · 1 fatal · Field investigation · Final report · Jul 4, 2003 · N279WP · Substantial damage
  > Loss of engine power due to fuel starvation that resulted from the right wing tank reaching an unusable fuel level. Also causal was an unapproved alteration of the aircraft’s fuel system. Contributing to the accident were the incorrect installation of an…

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

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

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