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

## Cases, newest first

- [NTSB ANC03FA066](https://openairdocs.org/ntsb/ANC03FA066.md): Cessna 421C · Sitka, AK · Accident · 5 fatal · Field investigation · Final report · Jul 4, 2003 · N777DX · Destroyed
  > The pilot's failure to follow IFR procedures by not following the published approach procedures, which resulted in an in-flight collision with terrain. Factors contributing to the accident were a low ceiling, and the pressure induced by conditions/events (the…
- [NTSB SEA03LA202](https://openairdocs.org/ntsb/SEA03LA202.md): North American P-51D · Jerome, ID · Accident · No injuries · Limited investigation · Final report · Jul 3, 2003 · N2869D · Substantial damage
  > The malfunction of the cooling system pressure relief valve and the pilot's failure to follow procedures. An engine over temperature, a coolant leak as a result of a relief valve failure, an obstructed windshield which was covered with coolant fluid, and an…
- [NTSB ATL03LA117](https://openairdocs.org/ntsb/ATL03LA117.md): Stinson 108-3 · Hendersonville, TN · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 2003 · N6088M · Substantial damage
  > The total loss of engine power due to loss of oil pressure for undetermined reasons, resulting in a forced landing and nose over on none suitable terrain.
- [NTSB CHI03LA187](https://openairdocs.org/ntsb/CHI03LA187.md): Piper PA-24 · Winamac, IN · Accident · No injuries · Limited investigation · Final report · Jul 2, 2003 · N6315P · Substantial damage
  > A loss of engine power due to the improper installation of the crankshaft gear due to the omission of the retaining bolt and subsequent shear failure of the anti-rotation pin. The unsuitable terrain encountered, and the rough field were factors.
- [NTSB MIA03LA139](https://openairdocs.org/ntsb/MIA03LA139.md): Samual G. DaSilva Velocity · Sebastian, FL · Accident · Serious injuries · Limited investigation · Final report · Jul 1, 2003 · N51576 · Substantial damage
  > The improper repair of the crankshaft by a FAA Certified Repair Station resulting in fatigue failure and subsequent total loss of engine power. A factor in the accident was the rough/uneven terrain encountered by the pilot during the landing roll in a field.
- [NTSB SEA03FA121](https://openairdocs.org/ntsb/SEA03FA121.md): Lamb RV-4 · Vail, WA · Accident · 1 fatal · Field investigation · Final report · Jun 29, 2003 · N6596X · Substantial damage
  > A loss of engine power due to the pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion. Contributing factors were the non-operating (vandalized) runway lights, the pilot's delayed departure to his…
- [NTSB NYC03LA139](https://openairdocs.org/ntsb/NYC03LA139.md): Cessna 172K · White Marsh, MD · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 2003 · N5138G · Substantial damage
  > The pilot's in-flight decision to not land and refuel, which resulted in fuel exhaustion. A factor in the accident was the pilot's inadequate communications.
- [NTSB LAX03LA216](https://openairdocs.org/ntsb/LAX03LA216.md): Cessna 210D · Carefree, AZ · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2003 · N3826Y · Substantial damage
  > fuel exhaustion due to a crack on the elbow fitting to the gascolator resulted in a fuel leak.
- [NTSB CHI03LA211](https://openairdocs.org/ntsb/CHI03LA211.md): Quicksilver MXL II · Marceline, MO · Accident · Serious injuries · Limited investigation · Final report · Jun 29, 2003 · UNREG · Substantial damage
  > The pilot's failure to assure an adequate fuel supply which resulted in fuel exhaustion. A factor associated with the accident was the pilot's lack of experience in this make/model of aircraft.
- [NTSB IAD03CA060](https://openairdocs.org/ntsb/IAD03CA060.md): Bellanca 7GCBC · Atlantic City, NJ · Accident · Minor injuries · Data collection · Final report · Jun 28, 2003 · N4133Y · Substantial damage
  > The pilot's failure to properly secure an aerial advertising banner to the outside of the airplane.
- [NTSB CHI03LA184](https://openairdocs.org/ntsb/CHI03LA184.md): Bell 47G-5A · Sandusky, MI · Accident · No injuries · Limited investigation · Final report · Jun 28, 2003 · N8413D · Substantial damage
  > The failure of the ignition switch leading to an engine power loss in cruise flight and the subsequent high flare during autorotation. Factors contributing to the accident were the pilot's misjudgment of the landing flare and the unsuitable terrain…
- [NTSB NYC03FA136](https://openairdocs.org/ntsb/NYC03FA136.md): Beech 35-B33 · Harned, KY · Accident · 2 fatal · Field investigation · Final report · Jun 27, 2003 · N8953M · Destroyed
  > The airplane's in-flight collision with terrain for undetermined reasons.
- [NTSB LAX03LA211](https://openairdocs.org/ntsb/LAX03LA211.md): Pieterse Kitfox 2 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Jun 26, 2003 · N164JR · Substantial damage
  > The improper design and installation of the airplane's fuel system by the builder of the experimental airplane, which resulted in fuel starvation and a loss of engine power.
- [NTSB CHI03FA179](https://openairdocs.org/ntsb/CHI03FA179.md): Eurocopter EC120B · Boonville, MO · Accident · 1 fatal · Field investigation · Final report · Jun 26, 2003 · N298HS · Destroyed
  > The pilot's inadequate weather evaluation which resulted in his inadvertent flight into instrument meteorological conditions. An additional cause was the pilot's failure to maintain clearance from the terrain. The dark night, thunderstorms, rain and lack of…
- [NTSB SEA03TA116](https://openairdocs.org/ntsb/SEA03TA116.md): McDonnell Douglas 369E · Big Timber, MT · Accident · Minor injuries · Final report · Jun 25, 2003 · N1502 · Substantial damage
  > Fretting on the outside diameter of the compressor coupling adapter which resulted in fatigue and subsequent fracture of the adapter, and ultimately the disconnection of the compressor from the turbine assembly. Contributing factors were low rotor RPM, uneven…
- [NTSB MIA03LA134](https://openairdocs.org/ntsb/MIA03LA134.md): John L. Klein Marquart ChargerMA-5 · Pierson, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 2003 · N707JK · Substantial damage
  > Separation of the elevator push/pull tube from the rear cockpit's control stick for undetermined reasons, which resulted in a loss of elevator control, an uncontrolled descent, and an impact with trees.
- [NTSB CHI03FA181](https://openairdocs.org/ntsb/CHI03FA181.md): Robinson R44 II · Coleta, IL · Accident · 3 fatal · Field investigation · Final report · Jun 25, 2003 · N7512P · Destroyed
  > The pilot not maintaining main rotor RPM during cruise flight. The factor in the two passenger's fatal injuries was the pilot not following directives concerning the prohibition of carrying passengers while a student pilot. Other factors were the pilot's use…
- [NTSB ANC03FA061](https://openairdocs.org/ntsb/ANC03FA061.md): Cessna 172 · Skagway, AK · Accident · 2 fatal · Field investigation · Final report · Jun 25, 2003 · N736QK · Substantial damage
  > The pilot's continued visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain. Factors associated with the accident were low ceilings, rain, and fog.
- [NTSB DEN03LA110](https://openairdocs.org/ntsb/DEN03LA110.md): Alexander Schleicher · Paragonah, UT · Accident · No injuries · Limited investigation · Final report · Jun 24, 2003 · D-KIMK · Substantial damage
  > The pilot's encounter with unsuitable terrain during a precautionary landing. Contributing factors were the strong winds and the approaching vehicle.
- [NTSB SEA03LA117](https://openairdocs.org/ntsb/SEA03LA117.md): Cessna T337D · Driggs, ID · Accident · No injuries · Limited investigation · Final report · Jun 22, 2003 · N86182 · Substantial damage
  > The pilot's inadequate inflight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of power. A factor contributing to the accident was the unsuitable terrain for the forced landing.
- [NTSB SEA03LA115](https://openairdocs.org/ntsb/SEA03LA115.md): Cessna 182C · Bandon, OR · Accident · No injuries · Limited investigation · Final report · Jun 22, 2003 · N8762T · Substantial damage
  > Loss of engine power during descent for undetermined reasons.
- [NTSB IAD03CA062](https://openairdocs.org/ntsb/IAD03CA062.md): William Stevens RAF2000 · Stoutsville, OH · Accident · No injuries · Data collection · Final report · Jun 22, 2003 · N186S · Substantial damage
  > Separation of the engine computer wire and connector, which resulted in a partial loss of engine power.
- [NTSB ATL03LA112](https://openairdocs.org/ntsb/ATL03LA112.md): Schleicher ASW28 · Batesburg, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 2003 · N128ED · Substantial damage
  > The loss of thermal lifting action that resulted in the in-flight collision with trees during an attempted forced landing.
- [NTSB CHI03LA170](https://openairdocs.org/ntsb/CHI03LA170.md): Air Tractor AT-301 · Covert, MI · Accident · No injuries · Limited investigation · Final report · Jun 20, 2003 · N3659T · Substantial damage
  > Failure of the pilot to verify fuel quantity prior to the accident flight, and fuel exhaustion resulting in a loss of engine power. Contributing factors were the soft, rough, unsuitable terrain for a forced landing.
- [NTSB ATL03FA114](https://openairdocs.org/ntsb/ATL03FA114.md): Piper PA-32R-301T · Scottsboro, AL · Accident · 2 fatal · Field investigation · Final report · Jun 19, 2003 · N270LM · Substantial damage
  > The pilot's improper fuel management which resulted in a loss of engine power due to fuel starvation and subsequent impact with trees.
- [NTSB MIA03LA127](https://openairdocs.org/ntsb/MIA03LA127.md): Embraer EMB-145LR · Taylor, FL · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 2003 · N294SK · No damage
  > The in-flight encounter with turbulence during normal descent resulting in a serious injury to a passenger. A finding in the investigation was the seatbelt sign had been on for approximately 2 minutes at the time of the turbulence encounter.
- [NTSB MIA03FA124](https://openairdocs.org/ntsb/MIA03FA124.md): Cessna 172N · Deerfield Beach, FL · Accident · 5 fatal · Field investigation · Final report · Jun 17, 2003 · N4903F · 2 aircraft · Destroyed
  > **This case was revised 6/10/2005 and 2/24/2016. Refer to the public docket for this accident for details.** The failure of the pilot of N4903F, the Cessna 172, and the pilot of N759XA, the Cessna 182, to see and avoid each other while operating in Class E…
- [NTSB MIA03CA129](https://openairdocs.org/ntsb/MIA03CA129.md): Robinson R22 Beta · Kissimmee, FL · Accident · No injuries · Data collection · Final report · Jun 16, 2003 · N7185K · Substantial damage
  > The inadequate supervision by flight instructor for his failure to prevent incorrect anti-torque pedal input by the student resulting in the helicopter yawing at touchdown. A factor in the accident was the incorrect anti-torque pedal input by the student…
- [NTSB ATL03LA106](https://openairdocs.org/ntsb/ATL03LA106.md): Polstra Zodiac CH 601 HDS · Thomson, GA · Accident · No injuries · Limited investigation · Final report · Jun 16, 2003 · N721PT · Substantial damage
  > The total loss of engine power due to the fatigue fracture of the No. 3 cylinder intake valve, which resulted in a forced landing to rough terrain and subsequent collision with small trees and a tree stump.
- [NTSB LAX03FA200](https://openairdocs.org/ntsb/LAX03FA200.md): McDonnell Douglas 369D · Volcano, HI · Accident · 4 fatal · Field investigation · Final report · Jun 15, 2003 · N4493M · Destroyed
  > a loss of engine power due to the fatigue fracture and separation of the compressor coupling adapter. The fatigue fracture was initiated by fretting on the pilot diameter due to both the inadequate design of the coupling and the coaxial misalignment of the…
- [NTSB LAX03CA201](https://openairdocs.org/ntsb/LAX03CA201.md): Schleicher ASW-20 · Idyllwild, CA · Accident · Minor injuries · Data collection · Final report · Jun 15, 2003 · N34LB · Substantial damage
  > The combined effects of a loss of thermal lift and a gust induced loss of airspeed at a low above ground altitude, which resulted in a descent to impact with trees. The pilot's failure to maintain an adequate terrain clearance margin while cruising in…
- [NTSB DEN03LA105](https://openairdocs.org/ntsb/DEN03LA105.md): Adams Balloon A55 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Jun 15, 2003 · N4031Z · Destroyed
  > the pilot's improper planned approach for a landing and obstacle clearance not maintained. A contributing factor was the power lines.
- [NTSB MIA03LA123](https://openairdocs.org/ntsb/MIA03LA123.md): Zenith 601HDS · Immokalee, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 2003 · N601G · Substantial damage
  > Excessive rotor distributor shaft clearance that resulted in damage to the distributor rotor, a loss of ignition, the engine ceasing to operate. This resulted in a forced landing to unsuitable terrain and the airplane nosing over.
- [NTSB LAX03IA199](https://openairdocs.org/ntsb/LAX03IA199.md): Bombardier CL-600-2B19 · Phoenix, AZ · Incident · No injuries · Incident investigation · Final report · Jun 14, 2003 · N97325 · No damage
  > the simultaneous failure of both horizontal stabilizer trim channels on two separate occasions for undetermined reasons.
- [NTSB DEN03LA107](https://openairdocs.org/ntsb/DEN03LA107.md): Beech S35 · Colorado Spring, CO · Accident · No injuries · Limited investigation · Final report · Jun 14, 2003 · N5751K · Substantial damage
  > the pilot's inadequate in-flight planning/decision in which he mismanaged his fuel supply by failing to switch tanks resulting in fuel starvation and the loss of engine power. A contributing factor was the pilot's diverted attention.
- [NTSB CHI03LA165](https://openairdocs.org/ntsb/CHI03LA165.md): Engineering & Research 415-C · Independence, KS · Accident · No injuries · Limited investigation · Final report · Jun 14, 2003 · N87198 · Substantial damage
  > A loss of engine power due to fuel starvation. A factor to the accident was the pilot's improper installation of the fuel cap.
- [NTSB ATL03FA125](https://openairdocs.org/ntsb/ATL03FA125.md): Bellanca 7KCAB · Dover, TN · Accident · 2 fatal · Field investigation · Final report · Jun 14, 2003 · N68551 · Substantial damage
  > The pilot continued VFR flight into adverse weather conditions including instrument meteorological conditions and turbulence in thunderstorms, which resulted in a loss of control in flight and subsequent collision with terrain.
- [NTSB DEN03LA153](https://openairdocs.org/ntsb/DEN03LA153.md): Sharp Corben Baby Ace D · Wamsutter, WY · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 2003 · N794CH · Substantial damage
  > A loss of engine power due to carburetor icing. Contributing factors were weather conditions conducive to carburetor icing and unsuitable terrain available on which to make a forced landing.
- [NTSB DEN03LA152](https://openairdocs.org/ntsb/DEN03LA152.md): Piper PA-46-500TP · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Jun 13, 2003 · N211EZ · Substantial damage
  > the inadvertent encounter with turbulence associated with thunderstorms. A contributing factor was the icing conditions.
- [NTSB CHI03LA159](https://openairdocs.org/ntsb/CHI03LA159.md): Cessna T210N · Tribune, KS · Accident · No injuries · Limited investigation · Final report · Jun 13, 2003 · N210MP · Substantial damage
  > The in-flight separation of the turbocharger exhaust band clamp resulting in an in-flight fire and uncommanded landing gear extension. Also causal was the improper maintenance by unknown personnel.
- [NTSB MIA03LA121](https://openairdocs.org/ntsb/MIA03LA121.md): Piper PA-25-235 · Gulf Hammock, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 2003 · N6981Z · Substantial damage
  > The insufficient information provided to the pilot by the mechanic that installed the auxiliary fuel tank for his failure to install a placard to indicate that both fuel on/off valves should not be on at the same time resulting in a total loss of engine power…
- [NTSB MIA03FA122](https://openairdocs.org/ntsb/MIA03FA122.md): Piper PA-32R-301 · Carthage, MS · Accident · 2 fatal · Field investigation · Final report · Jun 12, 2003 · N232HC · Destroyed
  > The failure of the non-instrument rated pilot to following the in-flight weather avoidance assistance instructions offered by the controller and his continued flight into known adverse weather condition (thunderstorm), resulting in overload failure of the…
- [NTSB LAX03LA193](https://openairdocs.org/ntsb/LAX03LA193.md): Boeing MD-82 · Fort Worth, TX · Accident · Serious injuries · Limited investigation · Final report · Jun 12, 2003 · N451AA · No damage
  > The encounter with severe turbulence during descent, prior to the cabin crew taking their seats, which resulted in serious injury to two flight attendants.
- [NTSB ATL03LA152](https://openairdocs.org/ntsb/ATL03LA152.md): Chinook Plus 2 A13-SWB · Elsanor, AL · Accident · 2 fatal · Limited investigation · Final report · Jun 12, 2003 · UNREG · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB NYC03LA127](https://openairdocs.org/ntsb/NYC03LA127.md): Cessna 172H · East Vincent, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 11, 2003 · N3027U · Substantial damage
  > The pilot's inadequate in-flight planning/preparation which resulted in fuel exhaustion during cruise flight. The pilot's inadequate preflight preparation in which he failed to refuel the airplane is a contributing factor.
- [NTSB LAX03LA190](https://openairdocs.org/ntsb/LAX03LA190.md): Piper PA-24-250 · Fallon, NV · Accident · No injuries · Limited investigation · Final report · Jun 10, 2003 · N5058P · Substantial damage
  > The pilot's inadequate preflight and his mismanagement of the fuel supply by his failure to switch fuel tanks.
- [NTSB DEN03IA101](https://openairdocs.org/ntsb/DEN03IA101.md): Boeing 757-200 · Dodge City, KS · Incident · Minor injuries · Incident investigation · Final report · Jun 10, 2003 · N704X · No damage
  > the inadvertent activation of the flight deck door's upper pressure relief latch during closure of the door, resulting in the deployment of the upper decompression panel which subsequently struck the captain. Contributing factors included the operator's…
- [NTSB LAX03FA187](https://openairdocs.org/ntsb/LAX03FA187.md): Rockwell International Aero-Commander 112TC · Santa Nella, CA · Accident · 1 fatal · Field investigation · Final report · Jun 9, 2003 · N4696W · Destroyed
  > The pilot's inadequate in-flight planning/decision by conducting VFR flight into IMC, and his failure to maintain terrain clearance. Contributing factors were low clouds, fog, and mountainous terrain.
- [NTSB CHI03LA155](https://openairdocs.org/ntsb/CHI03LA155.md): Sesin EXEC90 · Searcy, AR · Accident · No injuries · Limited investigation · Final report · Jun 8, 2003 · N8246J · Substantial damage
  > The unqualified maintenance performed by the pilot and the inadequate autorotation by the pilot. A factor contributing to this accident was the overtemperature of the engine cooling system.
- [NTSB SEA03LA107](https://openairdocs.org/ntsb/SEA03LA107.md): Pippert Zenith Air CH 701 · Rochester, WA · Accident · No injuries · Limited investigation · Final report · Jun 7, 2003 · N2748 · Substantial damage
  > Loose jet in the carburetor while on climb out resulting in a loss of engine power.

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

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

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