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

## Cases, newest first

- [NTSB MIA97LA032](https://openairdocs.org/ntsb/MIA97LA032.md): Piper PA-28-180 · Sugarloaf Key, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 1996 · N9545J · Substantial damage
  > a complete loss of engine power due to a disconnected connecting rod cap.
- [NTSB LAX97LA060](https://openairdocs.org/ntsb/LAX97LA060.md): Piper PA-32R-301T · Tusayan, AZ · Accident · No injuries · Limited investigation · Final report · Dec 1, 1996 · N3566X · Substantial damage
  > Fuel exhaustion due to the pilot's inadequate preflight planning and his miscalculation of the fuel required for the flight.
- [NTSB NYC97LA023](https://openairdocs.org/ntsb/NYC97LA023.md): Piper PA-28-181 · Long Pond, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 1996 · N4839F · Substantial damage
  > The pilot's inadequate preflight planning/preparation and improper inflight planning/decision, which resulted in fuel exhaustion and the loss of engine power, due to an inadequate supply of fuel. Darkness and trees in the emergency landing area were related…
- [NTSB LAX97LA058](https://openairdocs.org/ntsb/LAX97LA058.md): Cessna T210N · Scottsdale, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 30, 1996 · N4788C · Destroyed
  > detonation/pre-ignition for unknown reason(s), which resulted in failure of the number two piston, loss of engine power, and a subsequent forced landing on rough/uneven desert terrain.
- [NTSB FTW97FA051](https://openairdocs.org/ntsb/FTW97FA051.md): Eurocopter AS350B2 · High Island A20 · Accident · 3 fatal · Field investigation · Final report · Nov 28, 1996 · N6100U · Destroyed
  > This case was modified 6/26/2006. The failure of the tail rotor pitch change link due to a fatigue fracture, which resulted in a loss of tail rotor control and separation of the aft tailboom.
- [NTSB CHI97LA037](https://openairdocs.org/ntsb/CHI97LA037.md): Cessna 150 · Bowbells, ND · Accident · No injuries · Limited investigation · Final report · Nov 27, 1996 · CGOCS · Substantial damage
  > the pilot's failure to lean the mixture control after applying carburetor heat as the pilot's operating handbook states should be done. The carburetor icing conditions and the terrain were factors.
- [NTSB ATL97LA027](https://openairdocs.org/ntsb/ATL97LA027.md): Beech 35 · Lafayette, GA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1996 · N4523V · Substantial damage
  > failure of maintenance personnel to balance the ruddervator assemblies after they had been reskinned and painted, which resulted in flutter and subsequent damage to the empennage.
- [NTSB NYC97FA021](https://openairdocs.org/ntsb/NYC97FA021.md): Cessna 414 · Duo, WV · Accident · 2 fatal · Field investigation · Final report · Nov 26, 1996 · N73CP · Destroyed
  > The pilot's inadequate inflight decision which resulted in VFR flight into instrument meteorological conditions and his failure to maintain adequate terrain clearance which resulted in an inflight collision with terrain. The low ceiling was a factor.
- [NTSB NYC97FA019](https://openairdocs.org/ntsb/NYC97FA019.md): Cessna 172N · Andover, MA · Accident · No injuries · Field investigation · Final report · Nov 21, 1996 · N4926G · Substantial damage
  > failure of the dual magneto, which resulted in a total loss of engine power, and subsequent collision with trees during a forced landing at night. Darkness and trees in the emergency landing area were related factors.
- [NTSB LAX97FA047](https://openairdocs.org/ntsb/LAX97FA047.md): Piper PA-28-236 · Lost Hills, CA · Accident · 1 fatal · Field investigation · Final report · Nov 21, 1996 · N8447B · Destroyed
  > The pilot's continued VFR flight into instrument meteorological conditions, which led to spatial disorientation and loss of aircraft control, and the pilot exceeding the aircraft's design stress limits during an attempted recovery. The noninstrument-rated…
- [NTSB LAX97LA051](https://openairdocs.org/ntsb/LAX97LA051.md): Boeing 737-500 · Bishop, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 20, 1996 · N916UA · No damage
  > a clear air turbulence encounter.
- [NTSB SEA97LA030](https://openairdocs.org/ntsb/SEA97LA030.md): Cessna 421B · Olympia, WA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1996 · N8005Q · Substantial damage
  > inoperative deicing equipment, due to multiple wing boot holes and malfunctioning control/shuttle valves; subsequent build-up of airframe (wing) ice; and failure of the pilot to maintain adequate airspeed during the flare for landing. Factors relating to the…
- [NTSB CHI97FA030](https://openairdocs.org/ntsb/CHI97FA030.md): Boeing 737-222 · Grand Rapids, MI · Accident · Serious injuries · Field investigation · Final report · Nov 19, 1996 · N9038U · No damage
  > a passenger sustained a fractured ankle during an emergency evacuation for undetermined reasons.
- [NTSB MIA97LA024](https://openairdocs.org/ntsb/MIA97LA024.md): Cessna 182C · Anderson, SC · Accident · No injuries · Limited investigation · Final report · Nov 17, 1996 · N8605T · Substantial damage
  > the pilot's improper preflight, resulting in the fuel cap(s) not being secured; and subsequent siphoning and loss of fuel, which resulted in loss of engine power, a forced landing, and subsequent collision with a ditch during the emergency landing.
- [NTSB LAX97FA044](https://openairdocs.org/ntsb/LAX97FA044.md): Cessna 152 · Gilroy, CA · Accident · 1 fatal · Field investigation · Final report · Nov 17, 1996 · N48737 · Destroyed
  > flight by the pilot into into adverse weather conditions, and his failure to maintain altitude or clearance from mountainous terrain. The adverse weather and terrain conditions were related factors.
- [NTSB CHI97IA029](https://openairdocs.org/ntsb/CHI97IA029.md): Beech 1900D · Hopkensville, KY · Incident · No injuries · Incident investigation · Final report · Nov 17, 1996 · N841SK · Minor damage
  > the materials used in the new windshield, to meet new EPA requirements, were inadequate for the design.
- [NTSB NYC97LA018](https://openairdocs.org/ntsb/NYC97LA018.md): Dubis Team Minimax · North Adams, MA · Accident · No injuries · Limited investigation · Final report · Nov 16, 1996 · N4335W · Substantial damage
  > fuel contamination, which resulted in a loss of engine power. Factors relating to the accident were: the lack of a drain in the fuel system to properly check the fuel before flight, and the pilot's failure (or inability) to detect the contaminated fuel.
- [NTSB LAX97LA042](https://openairdocs.org/ntsb/LAX97LA042.md): Beech 35-33 · Apple Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1996 · N961T · Substantial damage
  > fuel starvation, due to plugged fuel system vent lines, which resulted in loss of engine power.
- [NTSB IAD97FA022](https://openairdocs.org/ntsb/IAD97FA022.md): Piper PA-34-220T · West Milton, OH · Accident · 2 fatal · Field investigation · Final report · Nov 15, 1996 · N8468H · Destroyed
  > The pilot's inability to maintain aircraft control after an undetermined failure of the automatic flight control. A contributing factor was failure of the maintenance technician to have the airplane test flown prior to release.
- [NTSB LAX97LA303](https://openairdocs.org/ntsb/LAX97LA303.md): Fleming Glassair III · Dunsmuir, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 14, 1996 · N77DF · Destroyed
  > was the pilot's intentional flight into marginal meteorological conditions in mountainous terrain during dark nighttime conditions.
- [NTSB LAX97LA039](https://openairdocs.org/ntsb/LAX97LA039.md): McDonnell Douglas 369D · Hana, HI · Accident · No injuries · Limited investigation · Final report · Nov 13, 1996 · N8625F · Substantial damage
  > subsequent failure of the spur adapter gearshaft (SAG), after 'retaining ring to compressor impeller machining' occurred and allowed the SAG to shift aft. The mechanism which induced the ring to impeller machining was not determined. Mountainous terrain in…
- [NTSB FTW97FA039](https://openairdocs.org/ntsb/FTW97FA039.md): Cessna 182Q · Colorado City, TX · Accident · 1 fatal · Field investigation · Final report · Nov 12, 1996 · N5116N · Destroyed
  > the pilot's encounter with instrument meteorological conditions (IMC), and his subsequent loss of aircraft control, due to spatial disorientation. Factors relating to the accident were: the clouds, low ceilings, and the pilot's lack of recent instrument…
- [NTSB IAD97LA019](https://openairdocs.org/ntsb/IAD97LA019.md): Cessna 150 · Edgerton, OH · Accident · 1 fatal · Limited investigation · Final report · Nov 11, 1996 · N5627E · Destroyed
  > the pilot's Inadvertent VFR flight into instrument meteorological conditions resulting in spatial disorientation and subsequent loss of control of the airplane. Factors to this accident were the night conditions and snow.
- [NTSB MIA97LA023](https://openairdocs.org/ntsb/MIA97LA023.md): Bellanca 17-30A · Brunswick, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 1996 · N86DR · Substantial damage
  > a complete loss of engine power as a result of piston failure, oil starvation, and the subsequent forced landing in unsuitable terrain.
- [NTSB MIA97LA022](https://openairdocs.org/ntsb/MIA97LA022.md): Beech V35B · Columbiana, AL · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 1996 · N6026T · Substantial damage
  > the pilot's improper use of the fuel selector, which resulted in fuel starvation, and his failure to select a tank with fuel for a restart, which resulted in a failure to restart the engine, a forced landing, and subsequent impact with terrain. High…
- [NTSB IAD97IA018](https://openairdocs.org/ntsb/IAD97IA018.md): McDonnell Douglas MD-11 · Dayton, OH · Incident · No injuries · Incident investigation · Final report · Nov 8, 1996 · N814DE · No damage
  > Failure of the output drive unit shear pin due to lack of lubrication to the screw actuator assemblies. Contributing to the cause was the aircraft manufacturer's production and inspection personnel failing to lubricate the screw assemblies after initial…
- [NTSB NYC97FA013](https://openairdocs.org/ntsb/NYC97FA013.md): Piper PA-34-200T · Lehman Township, PA · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1996 · N5671V · Destroyed
  > The failure of the forward fuselage nose assembly for an undetermined reason, which resulted in an in-flight breakup of the airplane.
- [NTSB CHI97LA021](https://openairdocs.org/ntsb/CHI97LA021.md): Cessna 177A · Kirksville, MO · Accident · Minor injuries · Limited investigation · Final report · Nov 3, 1996 · N30614 · Substantial damage
  > an improper maintenance overhaul by company maintenance personnel which led to a bearing failure. The soft terrain was a factor.
- [NTSB LAX97LA033](https://openairdocs.org/ntsb/LAX97LA033.md): Cessna 150M · Lake Havasu, AZ · Accident · No injuries · Limited investigation · Final report · Nov 2, 1996 · N2825V · Destroyed
  > carburetor ice, and failure of the pilot to use carburetor heat, which resulted in loss of engine power. Factors relating to the accident were: carburetor icing conditions, darkness, and the lack of suitable terrain for a forced landing.
- [NTSB LAX97LA031](https://openairdocs.org/ntsb/LAX97LA031.md): Rainey Rans S-12 · Tucson, AZ · Accident · 2 fatal · Limited investigation · Final report · Nov 2, 1996 · N95HS · Destroyed
  > a broken wire in the ignition coil, which resulted in a loss of engine power; and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spin and uncontrolled collision with the terrain.
- [NTSB LAX97FA032](https://openairdocs.org/ntsb/LAX97FA032.md): Piper PA-34-200 · Halawa, HI · Accident · 5 fatal · Field investigation · Final report · Nov 2, 1996 · N1701K · Destroyed
  > the pilot's inadvertent VFR flight into instrument meteorological conditions (IMC), and his failure to maintain sufficient clearance and/or altitude from mountainous terrain. Factors related to the accident were: darkness, adverse weather conditions, and…
- [NTSB FTW97FA033](https://openairdocs.org/ntsb/FTW97FA033.md): Schweizer SGS 1-36 · Boulder, CO · Accident · 1 fatal · Field investigation · Final report · Nov 2, 1996 · N3616Z · Destroyed
  > The pilot exceeding the design stress limits of the aircraft by performing an aerobatic maneuver, resulting in total failure of the wing spar.
- [NTSB CHI97LA018](https://openairdocs.org/ntsb/CHI97LA018.md): Frost RAF 2000 GTX SE · Adrian, MI · Accident · 1 fatal · Limited investigation · Final report · Nov 2, 1996 · N914VT · Substantial damage
  > the pilot's failure to maintain control of the aircraft. A factor was his lack of familiarity with the airplane.
- [NTSB ATL97LA012](https://openairdocs.org/ntsb/ATL97LA012.md): Douglas C-47 · Dorado, PR · Accident · Serious injuries · Limited investigation · Final report · Oct 31, 1996 · N37AP · Substantial damage
  > failure of the #11 cylinder on the right (#2) engine, which resulted in an in-flight fire and loss of power in that engine; and a malfunction/failure of the #2 feathering system, which led to a subsequent forced landing before the flight crew could return to…
- [NTSB ANC97LA005](https://openairdocs.org/ntsb/ANC97LA005.md): Ken Seright Rotorway Exec 162F · Haines, AK · Accident · No injuries · Limited investigation · Final report · Oct 29, 1996 · N711KN · Substantial damage
  > a leaking coolant hose that saturated the induction air filter and one electronic ignition system with coolant. Unsuitable terrain for a forced landing was a related factor in the accident.
- [NTSB LAX97FA027](https://openairdocs.org/ntsb/LAX97FA027.md): Piper PA-44-180 · Indio Hills, CA · Accident · 2 fatal · Field investigation · Final report · Oct 28, 1996 · N2157P · Destroyed
  > the pilot's spatial disorientation which led to a loss of aircraft control, and exceeding the aircraft's structural design limits after the aircraft had entered a descending spiral. The pilot's lack of instrument flight currency and the dark night were…
- [NTSB ATL97LA010](https://openairdocs.org/ntsb/ATL97LA010.md): Lindberg Kitfox IV · Merritt Island, FL · Accident · 2 fatal · Limited investigation · Final report · Oct 27, 1996 · N11LG · Destroyed
  > A loss of engine power for undetermined reasons and the failure of the pilots to maintain airspeed.
- [NTSB ATL97LA009](https://openairdocs.org/ntsb/ATL97LA009.md): Mooney M20K · Amelia Island, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 25, 1996 · N32DG · Substantial damage
  > inadequate maintenance/inspection, which resulted in a failure to detect and correct moisture contamination of the left magneto; and/or improper adjustment of the engine fuel pump output, which resulted in excessive fuel pressure.
- [NTSB FTW97LA028](https://openairdocs.org/ntsb/FTW97LA028.md): Cessna A185E · Giddings, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 24, 1996 · N185XX · Substantial damage
  > The loss of engine power as result of an oil leak due to a pinched 'O' ring in the oil filter. Factors were the improper installation of the oil filter, and the lack of suitable terrain for the forced landing.
- [NTSB CHI97LA012](https://openairdocs.org/ntsb/CHI97LA012.md): Piper PA-32-260 · Mancelona, MI · Accident · No injuries · Limited investigation · Final report · Oct 20, 1996 · N56155 · Substantial damage
  > the worn fuel system pump (actuator arm). A factor was the unsuitable terrain encountered by the pilot.
- [NTSB SEA97LA015](https://openairdocs.org/ntsb/SEA97LA015.md): Bell 206B-3 · Casper, WY · Accident · No injuries · Limited investigation · Final report · Oct 16, 1996 · N2762G · Substantial damage
  > loss of power for undetermined reason(s). A factor relating to the accident was: the pilot was operating outside height/velocity curve parameters, when the loss of power occurred.
- [NTSB LAX97LA019](https://openairdocs.org/ntsb/LAX97LA019.md): Aero Commander 690 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Oct 15, 1996 · N15VZ · Substantial damage
  > failure of the main landing gear to fully engage in the down-and-locked position for undetermined reason(s). Loss of hydraulic pressure to the main gear for undetermined reasons(s) was a related factor.
- [NTSB LAX97LA018](https://openairdocs.org/ntsb/LAX97LA018.md): Cessna 172P · Kingsburg, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1996 · N6187K · Destroyed
  > the student pilot's use of an excessively lean mixture, which led to engine overheating, detonation, subsequent failure of the number 2 piston, and a forced landing.
- [NTSB IAD97LA008](https://openairdocs.org/ntsb/IAD97LA008.md): Cessna 172 · Germantown, KY · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1996 · N8299U · Substantial damage
  > improper maintenance with the installation of an improper oil ring on the number four piston, which led to failure of both the ring and pistion, oil starvation, and subsequent loss of engine power.
- [NTSB ANC97FA001](https://openairdocs.org/ntsb/ANC97FA001.md): de Havilland DHC-2 · Ketchikan, AK · Accident · 3 fatal · Field investigation · Final report · Oct 13, 1996 · N64276 · Destroyed
  > continued flight by the pilot into adverse weather condition, and his failure to maintain adequate altitude/clearance from mountainous terrain. Factors related to the accident were the high/mountainous terrain, and weather conditions that included low…
- [NTSB LAX97LA015](https://openairdocs.org/ntsb/LAX97LA015.md): Cessna 182A · Agua Dulce, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 1996 · N4924D · Substantial damage
  > inadequate compliance with the applicable airworthiness directive by other maintenance personnel, and the pilot's inadequate preflight inspection which resulted in fuel exhaustion from a deteriorated fuel cap seal.
- [NTSB CHI97LA009](https://openairdocs.org/ntsb/CHI97LA009.md): Hayes Lancair 235 · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Oct 12, 1996 · N90WH · Substantial damage
  > a stuck carburetor float valve which resulted in excessive fuel flow and ultimately fuel exhaustion. A factor related to the accident was the rough terrain on which the forced landing was made.
- [NTSB LAX97LA001](https://openairdocs.org/ntsb/LAX97LA001.md): Cessna 210A · Truckee, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 11, 1996 · N9403X · Substantial damage
  > a total loss of engine power for undetermined nonmechanical reasons.
- [NTSB SEA97LA010](https://openairdocs.org/ntsb/SEA97LA010.md): Piper PA-36-300 · Prosser, WA · Accident · 1 fatal · Limited investigation · Final report · Oct 10, 1996 · N2331Y · Substantial damage
  > failure of the pilot to maintain clearance from the terrain, while en route to an apple orchard that he intended to spray. A factor relating to the accident was: the turbulent wind condition over the hills.
- [NTSB IAD97LA005](https://openairdocs.org/ntsb/IAD97LA005.md): Cessna T210M · Mentor, KY · Accident · No injuries · Limited investigation · Final report · Oct 10, 1996 · N6163N · Substantial damage
  > the pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power. Factors relating to the accident were: the inaccurate fuel quantity gage, and the light condition at dusk.

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

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

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