# NTSB investigations, 1996: Maneuvering

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 1 of 6 · 279 cases

## Latest cases

- [NTSB MIA97LA052](https://openairdocs.org/ntsb/MIA97LA052.md): Sirocco Flying Club MJ 5 · Sanford, FL · Accident · 1 fatal · Limited investigation · Final report · Dec 31, 1996 · N949EA · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering in the traffic pattern (crosswind) after takeoff, which resulted in an inadvertent stall, uncontrolled descent, and collision with terrain.
- [NTSB LAX97LA079](https://openairdocs.org/ntsb/LAX97LA079.md): Grumman American AA-5A · Banning, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1996 · N9944U · Substantial damage
  > The pilot's intentional low flight in an area of foothills and canyons at an altitude insufficient to maintain clearance from obstacles.
- [NTSB NYC97LA037](https://openairdocs.org/ntsb/NYC97LA037.md): Richardson Kitfox 4 · Trenton, ME · Accident · 1 fatal · Limited investigation · Final report · Dec 24, 1996 · N922VR · Destroyed
  > failure of the pilot to maintain adequate airspeed while maneuvering after takeoff, which resulted in a stall/spin and an uncontrolled descent into terrain. The airplane's excessive gross weight was a related factor.
- [NTSB MIA97LA048](https://openairdocs.org/ntsb/MIA97LA048.md): Kelly Rans S-12 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Dec 24, 1996 · N6156K · Substantial damage
  > failure of the pilot to maintain adequate airspeed, while maneuvering after takeoff, which resulted in a stall/mush and collision with trees.
- [NTSB FTW97LA071](https://openairdocs.org/ntsb/FTW97LA071.md): Cessna 210A · Peyton, CO · Accident · No injuries · Limited investigation · Final report · Dec 23, 1996 · N6680X · Substantial damage
  > the pilot's improper fuel management by failing to avoid a prolong uncoordinated turn or slip, which resulted in fuel starvation. Factors relating to the accident were: darkness, and the lack of (activated) runway lights.
- [NTSB IAD97LA037](https://openairdocs.org/ntsb/IAD97LA037.md): Robinson R22 HP · Islip, NY · Accident · No injuries · Limited investigation · Final report · Dec 22, 1996 · N8414H · Substantial damage
  > The students pilot's failure to maintain control of the helicopter and the instructor's inadequate supervision of the flight.
- [NTSB SEA97LA038](https://openairdocs.org/ntsb/SEA97LA038.md): Beech BE-77 · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Dec 18, 1996 · N6043M · 2 aircraft · Substantial damage
  > The failure of the pilots of both airplanes to see and avoid each other. A factor contributing to the accident was the Cessna's pilot diverted attention.
- [NTSB LAX97LA068](https://openairdocs.org/ntsb/LAX97LA068.md): Robinson R22 Beta · Lakeport, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 1996 · N8311A · Substantial damage
  > inadequate supervision by the flight instructor (CFI), and his delayed corrective action to the student pilot's abrupt control inputs, thereby allowing the main rotor blades to strike the ground. Factors relating to the accident were: the CFI's lack of…
- [NTSB SEA97FA037](https://openairdocs.org/ntsb/SEA97FA037.md): Bellanca 8KCAB · Eagle Point, OR · Accident · 1 fatal · Field investigation · Final report · Dec 14, 1996 · N278ML · Destroyed
  > The failure of the first pilot (flight instructor) to initiate proper aircraft control, and his failure to perform the adequate remedial action to recover from an intentional inverted spin.
- [NTSB SEA97LA035](https://openairdocs.org/ntsb/SEA97LA035.md): Bell 47G · Pendleton, OR · Accident · 2 fatal · Limited investigation · Final report · Dec 10, 1996 · N4758R · Destroyed
  > The pilot-in-command's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with hilly terrain. A contributing factor in the accident was the presence of fog.
- [NTSB FTW97LA058](https://openairdocs.org/ntsb/FTW97LA058.md): Aerospatiale AS350B · East Cameron 71 · Accident · No injuries · Limited investigation · Final report · Dec 9, 1996 · N390MA · Substantial damage
  > failure of the pilot to maintain clearance from an object (crane/bucket). The gusty wind condition and proximity of the crane/bucket were related factors.
- [NTSB NYC97LA026](https://openairdocs.org/ntsb/NYC97LA026.md): Parker Mustang · Port Norris, NJ · Accident · 1 fatal · Limited investigation · Final report · Dec 8, 1996 · N7009S · Destroyed
  > The student pilot's failure to maintain adequate airspeed.
- [NTSB ATL97FA092](https://openairdocs.org/ntsb/ATL97FA092.md): Cessna 182 · Charleston, SC · Accident · 2 fatal · Field investigation · Final report · Dec 7, 1996 · N8683T · Substantial damage
  > The noninstrument-rated pilot's failure to remain clear of instrument meteorological conditions which led to spatial disorientation and loss of aircraft control. A factor was the pilot's failure to obtain a weather briefing.
- [NTSB MIA97LA035](https://openairdocs.org/ntsb/MIA97LA035.md): Hoster/Volmer VJ22 (Sportsman) · Seminole, FL · Accident · No injuries · Limited investigation · Final report · Dec 6, 1996 · N2921 · Substantial damage
  > inadequate maintenance/inspection of the airplane by the pilot/owner, and fuel contamination that resulted in fuel starvation.
- [NTSB SEA97LA036](https://openairdocs.org/ntsb/SEA97LA036.md): Piper PA18-135 · Cohagen, MT · Accident · 2 fatal · Limited investigation · Final report · Dec 5, 1996 · N62100 · Substantial damage
  > The pilot's failure to maintain airspeed. Factors were the intentional flight at a low altitude and the over gross condition of the airplane.
- [NTSB LAX97FA065](https://openairdocs.org/ntsb/LAX97FA065.md): Opperman Lancair IV-P · Suisun City, CA · Accident · 2 fatal · Field investigation · Final report · Dec 5, 1996 · N444LP · Destroyed
  > In-flight loss of control for an undetermined reason.
- [NTSB ATL97FA021](https://openairdocs.org/ntsb/ATL97FA021.md): Bellanca 17-31ATC · Fitzgerald, GA · Accident · 3 fatal · Field investigation · Final report · Dec 1, 1996 · N123SS · Substantial damage
  > A loss of engine power due to the blockage of the intake manifold of the induction air system, by the broken alternate air door, and the loss of aircraft control for undetermined reasons.
- [NTSB ANC97FA009](https://openairdocs.org/ntsb/ANC97FA009.md): Cessna 185 · Marshall, AK · Accident · 2 fatal · Field investigation · Final report · Nov 30, 1996 · N93829 · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall and collision with the terrain.
- [NTSB LAX97LA057](https://openairdocs.org/ntsb/LAX97LA057.md): Bell 206B · Mcgregor Point, HI · Accident · Serious injuries · Limited investigation · Final report · Nov 29, 1996 · N6262N · Substantial damage
  > the pilot's failure to maintain control of the aircraft and distance from the pole.
- [NTSB MIA97LA028](https://openairdocs.org/ntsb/MIA97LA028.md): North American T28B · Somerville, TN · Accident · 1 fatal · Limited investigation · Final report · Nov 23, 1996 · N3178U · Destroyed
  > the pilot misjudged his altitude/clearance above trees on terrain that was higher than the surrounding terrain, while performing an aerobatic maneuver.
- [NTSB FTW97TA046](https://openairdocs.org/ntsb/FTW97TA046.md): Aerospatiale AS-355-F1 · Taos, NM · Accident · No injuries · Final report · Nov 23, 1996 · N606SP · Substantial damage
  > The pilot's failure to maintain directional control. A factor was terrain induced turbulence.
- [NTSB CHI97LA035](https://openairdocs.org/ntsb/CHI97LA035.md): Cessna 150 · Chesterfield, MO · Accident · No injuries · Limited investigation · Final report · Nov 22, 1996 · N704DR · Substantial damage
  > the pilot's failure to maintain an adequate visual lookout.
- [NTSB MIA97LA027](https://openairdocs.org/ntsb/MIA97LA027.md): Cessna A188B · Ocilla, GA · Accident · No injuries · Limited investigation · Final report · Nov 20, 1996 · N53319 · Substantial damage
  > the pilot's inadequate fuel consumption calculations and failure to ensure the aircraft contained an adequate amount of fuel to complete the flight, which resulted in loss of engine power because of fuel exhaustion. Uneven terrain in the emergency landing…
- [NTSB SEA97LA029](https://openairdocs.org/ntsb/SEA97LA029.md): Bell 206B3 · Ballston, OR · Accident · Serious injuries · Limited investigation · Final report · Nov 19, 1996 · N921RB · Substantial damage
  > a loss of control for undetermined reasons.
- [NTSB SEA97LA032](https://openairdocs.org/ntsb/SEA97LA032.md): Hughes 369D · Forks, WA · Accident · Serious injuries · Limited investigation · Final report · Nov 16, 1996 · N5225C · Substantial damage
  > fuel contamination, which resulted in loss of engine power. Factors relating to the accident included: improper servicing of the helicopter, and a lack of suitable terrain for an emergency landing due to the proximity of trees.
- [NTSB SEA97FA027](https://openairdocs.org/ntsb/SEA97FA027.md): Cessna P210N · Boring, OR · Accident · 1 fatal · Field investigation · Final report · Nov 15, 1996 · N7823K · Destroyed
  > The pilot's attempt to conduct visual flight into instrument meteorological conditions. A factor contributing to the accident was the presence of thick fog.
- [NTSB CHI97FA025](https://openairdocs.org/ntsb/CHI97FA025.md): Enstrom F28F · Gutherie, IL · Accident · 3 fatal · Field investigation · Final report · Nov 11, 1996 · N86214 · Destroyed
  > the pilot's inadequate preflight preparation and not maintaining control of the helicopter during its rearward flight. A factor was the pilot's over-confidence in his personal ability.
- [NTSB MIA97FA020](https://openairdocs.org/ntsb/MIA97FA020.md): Piper PA-60-600 · New Bern, NC · Accident · 3 fatal · Field investigation · Final report · Nov 9, 1996 · N8239J · Destroyed
  > the pilot's failure to maintain airspeed (VMC). Contributing to the accident was his lack of total experience in kind of aircraft.
- [NTSB MIA97FA021](https://openairdocs.org/ntsb/MIA97FA021.md): Cessna TU206B · Jasper, GA · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1996 · N4970F · Destroyed
  > continued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from rising/mountainous terrain. The adverse weather and terrain conditions were related factors.
- [NTSB SEA97LA025](https://openairdocs.org/ntsb/SEA97LA025.md): Garlick TH-1L · Leavenworth, WA · Accident · 1 fatal · Limited investigation · Final report · Nov 5, 1996 · N465JR · Destroyed
  > Fatigue failure of the vertical stabilizer spar cap and subsequent loss of the rotorcraft's vertical stabilizer. Factors include inadequate inspection or trouble-shooting of the aircraft tail cone and vertical stabilizer at and after the time sheet-metal…
- [NTSB IAD97LA015](https://openairdocs.org/ntsb/IAD97LA015.md): Ayres Scorpion Executive · Union Vale, NY · Accident · No injuries · Limited investigation · Final report · Nov 4, 1996 · N3903C · Substantial damage
  > the pilot's failure to maintain control of the helicopter, which resulted in a subsequent emergency landing and collision with a fence and a cherry picker (vehicle). A factor relating to the accident was: the student pilot's lack of experience in the type…
- [NTSB FTW97LA034](https://openairdocs.org/ntsb/FTW97LA034.md): Bell 206L-3 · Mancos, CO · Accident · No injuries · Limited investigation · Final report · Nov 2, 1996 · N937R · Substantial damage
  > failure of the pilot to maintain clearance from the windsock, during a hover/pedal-turn after lift-off.
- [NTSB LAX97LA030](https://openairdocs.org/ntsb/LAX97LA030.md): Bell 206B · Supai, AZ · Accident · Minor injuries · Limited investigation · Final report · Nov 1, 1996 · N90144 · Destroyed
  > improper routing of the external cargo hoist cable (over helicopter skid), which resulted in lateral imbalance and roll-over of the helicopter, as weight on the cable became effective.
- [NTSB FTW97FA032](https://openairdocs.org/ntsb/FTW97FA032.md): Mooney M20J · San Leon, TX · Accident · 1 fatal · Field investigation · Final report · Nov 1, 1996 · N25LS · Substantial damage
  > The pilot's inadvertent stall and spin of the airplane. Factors were the pilot's lack of total experience in the make and model of airplane and the weather conditions.
- [NTSB ATL97LA016](https://openairdocs.org/ntsb/ATL97LA016.md): Cessna 188B · Ocilla, GA · Accident · No injuries · Limited investigation · Final report · Oct 31, 1996 · N731BQ · Substantial damage
  > The pilot's failure to adequately preflight and plan the fuel required for the flight.
- [NTSB ATL97LA011](https://openairdocs.org/ntsb/ATL97LA011.md): Grumman G-164B · Abbeyville, AL · Accident · No injuries · Limited investigation · Final report · Oct 31, 1996 · N6756K · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB SEA97LA022](https://openairdocs.org/ntsb/SEA97LA022.md): Collier Q200 · Estacada, OR · Accident · 1 fatal · Limited investigation · Final report · Oct 29, 1996 · N200CQ · Substantial damage
  > inadequate maintenance adjustment by the owner/pilot/mechanic, by not using safety wire to secure the throttle arm clamping screw, which resulted in a loose clamping screw and rotation of the throttle arm with respect to the butterfly valve shaft. The lack of…
- [NTSB CHI97LA016](https://openairdocs.org/ntsb/CHI97LA016.md): Hughes 369 · Vestaburg, MI · Accident · 1 fatal · Limited investigation · Final report · Oct 28, 1996 · N9251F · Substantial damage
  > failure of the pilot to maintain clearance with the wires.
- [NTSB NYC97FA011](https://openairdocs.org/ntsb/NYC97FA011.md): Yakovlev YAK-18T · Berlin, NJ · Accident · 2 fatal · Field investigation · Final report · Oct 27, 1996 · N9418 · Destroyed
  > an inadequate preflight by unknown person(s), sometime before the flight, by failing to avoid a hydraulic lock (from oil seepage) in the #5 cylinder, which resulted in a bent connecting rod, subsequent failure of the #5 piston, and loss of engine power. Also…
- [NTSB MIA97LA012](https://openairdocs.org/ntsb/MIA97LA012.md): Air Tractor 400 · Sylvester, GA · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 1996 · N73080 · Substantial damage
  > Was the pilots intentional disregard for operating the engine contrary to the flight manuals for intentionally exceeding the maximum engine temperature, resulting in creep failure of one of the compressor turbine blades.
- [NTSB FTW97LA019](https://openairdocs.org/ntsb/FTW97LA019.md): Air Tractor AT-502 · Throckmorton, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1996 · N4549Z · Destroyed
  > failure of the pilot to maintain clearance of a transmission wire during pullup from a swath run. The proximity of the transmission wire was a related factor. The installation of wire cutter equipment on the landing gear might have prevented or reduced the…
- [NTSB LAX97LA014](https://openairdocs.org/ntsb/LAX97LA014.md): Cunningham Rotorway Exec · Mather, CA · Accident · 1 fatal · Limited investigation · Final report · Oct 13, 1996 · N18WC · Destroyed
  > excessive maneuvering by the pilot, which allowed the main rotor blades to contact and sever the tail rotor system and allowed mast bumping to occur.
- [NTSB IAD97LA006](https://openairdocs.org/ntsb/IAD97LA006.md): Piper J3C-65 · Springfield, OH · Accident · 1 fatal · Limited investigation · Final report · Oct 13, 1996 · N42719 · Substantial damage
  > failure of the pilot to maintain obstacle clearance, while maneuvering at low altitudes. A related factor was the quartering tail wind.
- [NTSB ATL97LA002](https://openairdocs.org/ntsb/ATL97LA002.md): Bell UH-IB · Bennettsville, SC · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1996 · N846MC · Destroyed
  > the pilot's improper planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate supply of usable fuel. A factor relating to the accident was: an inoperative left boost pump, which increased the amount of unusable fuel…
- [NTSB SEA97LA011](https://openairdocs.org/ntsb/SEA97LA011.md): Aero Vodochody Aero. Works L-29 · Tillamook, OR · Accident · 2 fatal · Limited investigation · Final report · Oct 11, 1996 · N7150A · Destroyed
  > failure of the pilot to maintain control of the aircraft, while maneuvering behind an F4F aircraft. The lack of altitude for a recovery was a related factor.
- [NTSB SEA97GA008](https://openairdocs.org/ntsb/SEA97GA008.md): Piper PA-18-150 · Holden, UT · Accident · 2 fatal · Final report · Oct 10, 1996 · N91017 · Destroyed
  > The first pilot's failure to maintain adequate airspeed while maneuvering the airplane in close proximity to the ground. This subsequently led to an aerodynamic stall and uncontrolled descent into the ground. Factors contributing to the accident include the…
- [NTSB CHI97LA004](https://openairdocs.org/ntsb/CHI97LA004.md): Bell 47G-5 · Nunda, SD · Accident · No injuries · Limited investigation · Final report · Oct 6, 1996 · N7925J · Substantial damage
  > failure of maintenance personnel to properly torque the six accessory drive bolts, which resulted in fatigue failure of the undertorqued bolts.
- [NTSB CHI97LA003](https://openairdocs.org/ntsb/CHI97LA003.md): Piper PA-16 · Silver Lake, IN · Accident · Serious injuries · Limited investigation · Final report · Oct 5, 1996 · N5749H · Destroyed
  > fuel starvation due to an inadequate preflight and the pilot performed a low altitude maneuver which prevented him from selecting suitable terrain for landing. Additional factors included the loose fuel cap, fuel siphoning, and unreliable fuel gauges.
- [NTSB NYC97LA001](https://openairdocs.org/ntsb/NYC97LA001.md): Cessna 172 · Coudersport, PA · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 1996 · N5154E · Destroyed
  > the pilot's improper in-flight planning/decision, and his failure to ensure that adequate airspeed would be maintained, while maneuvering at low altitude to photograph a residence. The rising terrain and lack of altitude were related factors.
- [NTSB FTW97LA009](https://openairdocs.org/ntsb/FTW97LA009.md): Young Cozy MK IV · Pueblo, CO · Accident · Serious injuries · Limited investigation · Final report · Oct 4, 1996 · N96PJ · Substantial damage
  > the pilot/builder's improper design change which resulted in a loss of control following an intentional stall. A factor was an erroneous weight-and-balance calculation.

Next page: https://openairdocs.org/ntsb-phases/450/cases.md?year=1996&page=2

## 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 year(c."eventDate") = 1996
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 450)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?year=1996

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