# NTSB investigations, 1996: Approach

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 · 272 cases

## Latest cases

- [NTSB MIA97LA051](https://openairdocs.org/ntsb/MIA97LA051.md): Cessna 172P · Atlanta, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 31, 1996 · N62145 · Substantial damage
  > failure of the pilot to initiate an immediate climb (go-around or missed approach) after encountering fog, while on final approach to land. Darkness and fog at the end of the runway were related factors.
- [NTSB IAD97LA040](https://openairdocs.org/ntsb/IAD97LA040.md): Piper PA-38-112 · Colombia Staton, OH · Accident · No injuries · Limited investigation · Final report · Dec 31, 1996 · N2587G · Substantial damage
  > inadequate supervision by the flight instructor (CFI), and his failure to ensure that sufficient altitude and/or clearance was maintain from obstructions (trees) during the approach. Darkness was a related factor.
- [NTSB ANC97TA016](https://openairdocs.org/ntsb/ANC97TA016.md): Cessna 180 · St Mary'S, AK · Accident · No injuries · Final report · Dec 31, 1996 · N7066 · Substantial damage
  > the pilot's improper use of carburetor heat, and subsequent loss of engine power. Factors associated with the accident were the presence of ice crystals in the atmosphere, and unsuitable terrain for a forced landing.
- [NTSB MIA97FA049](https://openairdocs.org/ntsb/MIA97FA049.md): Piper PA-30 · Goldsboro, NC · Accident · 1 fatal · Field investigation · Final report · Dec 28, 1996 · N8220Y · Destroyed
  > The pilot's failure to follow instrument approach procedures during numerous instrument approaches and missed approaches which resuled in a total loss of engine power on both engines due to fuel exhaustion. Factors contributing to the accident were: the…
- [NTSB CHI97FA047](https://openairdocs.org/ntsb/CHI97FA047.md): Beech C90 · Rhinelander, WI · Accident · Minor injuries · Field investigation · Final report · Dec 28, 1996 · N998VB · Substantial damage
  > the pilot-in-command's inadequate weather evaluation and continued flight into forecast severe icing conditions which exceeded the capabilty of the airplane's anti-ice/deice system. The icing conditions were a factor.
- [NTSB ATL97FA030](https://openairdocs.org/ntsb/ATL97FA030.md): Beech A36 · Pensacola, FL · Accident · 2 fatal · Field investigation · Final report · Dec 28, 1996 · N23652 · Substantial damage
  > The pilot's mismanagement of the fuel supply that resulted in fuel starvation and the subsequent loss of engine power. A factor was low ceilings.
- [NTSB FTW97LA072](https://openairdocs.org/ntsb/FTW97LA072.md): Cessna 150M · Austin, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 1996 · N66773 · Substantial damage
  > The loss of engine power due to fuel exhaustion as result of the pilot's failure to refuel the airplane. Factors were the lack of suitable terrain for the forced landing and the pilot's improper preflight inspection of the fuel system.
- [NTSB NYC97FA194](https://openairdocs.org/ntsb/NYC97FA194.md): Learjet 35A · Dorchester, NH · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1996 · N388LS · Destroyed
  > The captain's failure to maintain situational awareness, which resulted in the airplane being outside the confines of the instrument approach; and the crew's misinterpretation of a step-down fix passage, which resulted in an early descent into rising terrain.…
- [NTSB LAX97FA075](https://openairdocs.org/ntsb/LAX97FA075.md): Piper PA-28-140 · San Diego, CA · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1996 · N943R · 2 aircraft · Destroyed
  > The failure of the pilot-in-command of the Piper PA-28, N943R, to maintain an adequate visual lookout to see and avoid the Cessna 150, N63137. A factor in the accident was the failure of the air traffic controller to issue a traffic advisory to the pilot…
- [NTSB NYC97LA034](https://openairdocs.org/ntsb/NYC97LA034.md): Maule M-5 · Levant, ME · Accident · No injuries · Limited investigation · Final report · Dec 21, 1996 · N56391 · Substantial damage
  > the pilot's inadequate compensation for wind conditions, and his failure to maintain clearance from tree(s) during an attempted go-around. The crosswind and proximity of tree(s) were related factors.
- [NTSB NYC97FA030](https://openairdocs.org/ntsb/NYC97FA030.md): Cessna 425 · Bohemia, NY · Accident · 3 fatal · Field investigation · Final report · Dec 16, 1996 · N425EW · Destroyed
  > the pilot's early descent to decision height and his failure to perform the missed approach procedure. A factor was the failure of air traffic control to issue a safety advisory.
- [NTSB LAX97FA069](https://openairdocs.org/ntsb/LAX97FA069.md): de Havilland DHC-8 · Honolulu, HI · Accident · No injuries · Field investigation · Final report · Dec 16, 1996 · N801WP · Substantial damage
  > A failure of the normal landing gear extension system due to a hydraulic leak, and the failure of the airplane's emergency landing gear extension system due to inadequate servicing by company maintenance personnel. Factors were the emergency landing gear…
- [NTSB MIA97LA038](https://openairdocs.org/ntsb/MIA97LA038.md): Bell 47G · Lantana, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 15, 1996 · N1200Z · Destroyed
  > an undetermined throttle problem, which resulted in a stuck (binding) throttle; and inadequate remedial action by the pilot, which led to a hard landing and subsequent nose over.
- [NTSB NYC97LA029](https://openairdocs.org/ntsb/NYC97LA029.md): Cessna T210M · Charlottesville, VA · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 1996 · N1929M · Substantial damage
  > The pilot's miscalculation of fuel consumption and his inadequate in-flight decision making, which resulted in fuel exhaustion and the loss of engine power.
- [NTSB CHI97LA042](https://openairdocs.org/ntsb/CHI97LA042.md): Piper PA-32R-300 · Garnett, KS · Accident · No injuries · Limited investigation · Final report · Dec 13, 1996 · N31SW · Substantial damage
  > the pilot's improper in-flight planning/decision, including a delay in proceeding to an alternate airport after encountering fog during a night approach, which resulted in loss of engine power due to fuel exhaustion.
- [NTSB IAD97LA031](https://openairdocs.org/ntsb/IAD97LA031.md): Mooney M20F · Wellsville, NY · Accident · 2 fatal · Limited investigation · Final report · Dec 11, 1996 · N3424N · Destroyed
  > Descent below the published minimum descent altitude followed by collision with the surrounding terrain.
- [NTSB ATL97LA025](https://openairdocs.org/ntsb/ATL97LA025.md): Beech BE-24R · Doraville, GA · Accident · No injuries · Limited investigation · Final report · Dec 11, 1996 · N6988R · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB LAX97LA078](https://openairdocs.org/ntsb/LAX97LA078.md): Cessna TU206G · Mammoth Lakes, CA · Accident · No injuries · Limited investigation · Final report · Dec 8, 1996 · N756UP · Substantial damage
  > The loss of power for undetermined reasons, and the pilot's inappropriate use of flaps and his failure to maintain an adequate airspeed during the subsequent landing attempt.
- [NTSB LAX97FA066](https://openairdocs.org/ntsb/LAX97FA066.md): Beech 95-C55 · Riverside, CA · Accident · Serious injuries · Field investigation · Final report · Dec 7, 1996 · N66MB · Substantial damage
  > fuel starvation due to improper fuel management. Contributing to the accident was the pilot's preoccupation of discussing the legality of the approach with the tower controller, and fatigue.
- [NTSB IAD97LA029](https://openairdocs.org/ntsb/IAD97LA029.md): Piper PA-23-250 · Elyria, OH · Accident · Serious injuries · Limited investigation · Final report · Dec 7, 1996 · N4911P · Substantial damage
  > The pilot's fuel mismanagement which led to fuel starvation to one engine, and the pilot's failure to maintain control of the airplane.
- [NTSB LAX97IA056](https://openairdocs.org/ntsb/LAX97IA056.md): Embraer EMB-120ER · Los Angeles, CA · Incident · Minor injuries · Incident investigation · Final report · Nov 30, 1996 · N291SW · No damage
  > a laser light source of unknown origin, directed toward the aircraft, as it was approaching to land.
- [NTSB LAX97FA059](https://openairdocs.org/ntsb/LAX97FA059.md): Morane-Saulnier MS760 II · Irvine, CA · Accident · 3 fatal · Field investigation · Final report · Nov 30, 1996 · N2TE · Destroyed
  > The pilot's failure to maintain an adequate airspeed margin while maneuvering in a steep banked turn to the landing runway, which resulted in an inadvertent stall/spin. Factors in the accident were: the pilot's inadequate preflight inspection of the aircraft…
- [NTSB IAD97FA025](https://openairdocs.org/ntsb/IAD97FA025.md): Aero Commander 681 · Mansfield, OH · Accident · 1 fatal · Field investigation · Final report · Nov 30, 1996 · N9129N · Destroyed
  > the pilot's early descent below the minimum descent altitude (MDA), while preparing to land from an instrument approach, and his failure to maintain adequate altitude and clearance from obstruction(s).
- [NTSB FTW97LA050](https://openairdocs.org/ntsb/FTW97LA050.md): Cessna 172H · Hammond, LA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1996 · N2440L · Substantial damage
  > the pilot's inadequate preflight, resulting in the total loss of engine power due to fuel exhaustion.
- [NTSB FTW97FA049](https://openairdocs.org/ntsb/FTW97FA049.md): Beech A36TC · Tucumcari, NM · Accident · 1 fatal · Field investigation · Final report · Nov 27, 1996 · N48PD · Substantial damage
  > the total loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed.
- [NTSB ATL97LA020](https://openairdocs.org/ntsb/ATL97LA020.md): Lake LA-4-200 · St. Petersburg, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 27, 1996 · N1109L · Substantial damage
  > Fuel exhaustion for undetermined reasons.
- [NTSB LAX97FA049](https://openairdocs.org/ntsb/LAX97FA049.md): Beech 95-C55 · San Diego, CA · Accident · 1 fatal · Field investigation · Final report · Nov 22, 1996 · N3774Q · Destroyed
  > the pilot's lack of situational awareness (becoming lost/disoriented during the approach), his failure to fly the approach as charted, and his failure to maintain aircraft control, while attempting an abrupt turn toward the airport, which led to an…
- [NTSB LAX97FA046](https://openairdocs.org/ntsb/LAX97FA046.md): Beech 95-B55 · Goleta, CA · Accident · 1 fatal · Field investigation · Final report · Nov 20, 1996 · N210WW · Destroyed
  > failure of the pilot to maintain control of the aircraft during an instrument approach, due to spatial disorientation, and/or his failure to maintain proper altitude. Factors relating to the accident were: the pilot's delay (or failure) to initiate a missed…
- [NTSB FTW97FA044](https://openairdocs.org/ntsb/FTW97FA044.md): Piper PA-28R-200 · Fort Worth, TX · Accident · 2 fatal · Field investigation · Final report · Nov 20, 1996 · N1394T · Destroyed
  > the pilots' continued descent of the aircraft below decision height. Factors contributing to the accident were the fog, the dark night illumination, one of the pilot's impairment due to use of marihuana, and both pilots' fatigue.
- [NTSB CHI97IA033](https://openairdocs.org/ntsb/CHI97IA033.md): Boeing 767-300ER-33A · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Nov 20, 1996 · GOITG · No damage
  > the approach controller's failure to issue the frequency change to the flightcrew, and the pilot landing without clearance. A factor relating to this incident is the pilot's decision to land without clearance.
- [NTSB CHI97FA027](https://openairdocs.org/ntsb/CHI97FA027.md): Cessna T210N · Springfield, MO · Accident · 1 fatal · Field investigation · Final report · Nov 15, 1996 · N5083C · Destroyed
  > the pilot's failure to set the altimeter to the current setting given by the controller resulting in the aircraft altimeter reading 260 feet higher than the actual aircraft altitude. Factors involved were pilot fatigue, weather conditions at approach…
- [NTSB LAX97LA040](https://openairdocs.org/ntsb/LAX97LA040.md): Moody RV-6 · Cottonwood, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 14, 1996 · N12033 · Substantial damage
  > loss of engine power for undetermined reason(s).
- [NTSB LAX97FA036](https://openairdocs.org/ntsb/LAX97FA036.md): Cessna 310I · Van Nuys, CA · Accident · 1 fatal · Field investigation · Final report · Nov 14, 1996 · N8046M · Destroyed
  > The pilot's failure to maintain a climb following initiation of a missed approach in fog due to spatial disorientation, and his inadequate training by company personnel. Potential rescue was delayed due to the FAA radar controller's failure to follow…
- [NTSB FTW97LA040](https://openairdocs.org/ntsb/FTW97LA040.md): Piper PA-23-250 · Plainview, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 13, 1996 · N5443 · Substantial damage
  > the pilot's continued descent below the minimum descent altitude (MDA). Factors relating to the accident were: darkness, the adverse weather conditions.
- [NTSB FTW97LA036](https://openairdocs.org/ntsb/FTW97LA036.md): Cessna 150M · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Nov 10, 1996 · N8960U · Substantial damage
  > Fuel exhaustion due the student pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.
- [NTSB SEA97LA026](https://openairdocs.org/ntsb/SEA97LA026.md): Cessna 182G · Hardin, MT · Accident · No injuries · Limited investigation · Final report · Nov 7, 1996 · N3126S · Substantial damage
  > the pilot's inadequate compensation for the wind conditions during the landing, and his failure to maintain directional control of the aircraft after touched down. Factors relating to the accident included the pilot's abrupt movement of the throttle as he…
- [NTSB NYC97LA014](https://openairdocs.org/ntsb/NYC97LA014.md): Cessna 340A · Pawtucket, RI · Accident · Serious injuries · Limited investigation · Final report · Nov 7, 1996 · N36JM · Destroyed
  > failure of the pilot to comply with the published instrument approach procedure, by continuing the ILS approach below the decision height, rather than performing a missed approach; and his failure to attain a proper touchdown point for the continued landing.…
- [NTSB FTW97LA037](https://openairdocs.org/ntsb/FTW97LA037.md): Cessna T210N · Grand Prairie, TX · Accident · No injuries · Limited investigation · Final report · Nov 5, 1996 · N6546N · Substantial damage
  > failure of the pilot to ensure that the fuel selector was positioned to a tank with sufficient fuel, which resulted in fuel starvation and loss of engine power. Factors relating to the accident were: the pilot's inadequate preflight, false indication from the…
- [NTSB FTW97LA035](https://openairdocs.org/ntsb/FTW97LA035.md): Stinson 108-3 · Tyler, TX · Accident · No injuries · Limited investigation · Final report · Nov 3, 1996 · N798C · Substantial damage
  > a loss of engine power due to failure of the crankshaft. A factor was the lack of suitable terrain for the forced landing.
- [NTSB ATL97LA015](https://openairdocs.org/ntsb/ATL97LA015.md): Piper PA-28-161 · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Nov 1, 1996 · N81435 · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB IAD97FA014](https://openairdocs.org/ntsb/IAD97FA014.md): Cessna 172L · Brandy Station, VA · Accident · 2 fatal · Field investigation · Final report · Oct 30, 1996 · N7737G · Destroyed
  > the certificated flight instructor's failure to ensure that proper altitude/clearance was maintained above the terrain and trees, while on final approach. Darkness was a related factor.
- [NTSB ATL97LA013](https://openairdocs.org/ntsb/ATL97LA013.md): Let L-13 · Benton, TN · Accident · Serious injuries · Limited investigation · Final report · Oct 30, 1996 · N15CB · Substantial damage
  > failure of the flight crew to maintain altitude/clearance above runway obstacles, and inadequate supervision by the flight instructor. Factors relating to the accident were sunglare on the canopy, and the proximity of obstacles (trees) to the runway.
- [NTSB LAX97LA026](https://openairdocs.org/ntsb/LAX97LA026.md): Grumman AA1C · San Diego, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1996 · N9519U · Destroyed
  > loss of engine power on final approach for undetermined reason(s).
- [NTSB ANC97LA006](https://openairdocs.org/ntsb/ANC97LA006.md): Piper PA-22/20 · Kasilof, AK · Accident · No injuries · Limited investigation · Final report · Oct 26, 1996 · N7431D · Substantial damage
  > the pilot's misjudgment of distance and altitude on final approach to land, which resulted in an undershoot and collision with a dirt bank before reaching the proper touchdown point. A factor related to the accident was: the proximity of the frozen dirt bank…
- [NTSB SEA97LA021](https://openairdocs.org/ntsb/SEA97LA021.md): Maule M-7-235 · Laramie, WY · Accident · No injuries · Limited investigation · Final report · Oct 25, 1996 · N5664Y · Substantial damage
  > VFR flight by the pilot into instrument meteorological conditions (IMC), his misjudged speed/distance on final approach for landing, and his failure to attain the proper touchdown point during the landing. Factors relating to the accident include snow, low…
- [NTSB IAD97FA011](https://openairdocs.org/ntsb/IAD97FA011.md): Ryan Navion · New Hartford, NY · Accident · 2 fatal · Field investigation · Final report · Oct 22, 1996 · N4564K · Destroyed
  > A loss of control for undetermined reasons.
- [NTSB MIA97LA008](https://openairdocs.org/ntsb/MIA97LA008.md): Cessna 21OK · Tampa, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1996 · N81SC · 2 aircraft · Substantial damage
  > The failure of the pilots of both airplanes to see and avoid each other. Contributing to the accident was the improper planning/decision of the pilot of the Cessna 210 to depart the traffic pattern on the downwind leg rather than on the upwind leg as…
- [NTSB LAX97LA024](https://openairdocs.org/ntsb/LAX97LA024.md): Schweizer 2-33-A · Los Alamitos, CA · Accident · No injuries · Limited investigation · Final report · Oct 20, 1996 · N65844 · Substantial damage
  > The student pilot's failure to properly handle the glider, and the instructor pilot's inadequate supervision.
- [NTSB IAD97LA010](https://openairdocs.org/ntsb/IAD97LA010.md): Bellanca BL28 · Ledbetter, KY · Accident · Minor injuries · Limited investigation · Final report · Oct 20, 1996 · N5029G · Substantial damage
  > the pilot's delay in executing a go-around, and his failure to obtain/maintain adequate airspeed, which resulted in a stall and collision with the ground.
- [NTSB NYC97MA005](https://openairdocs.org/ntsb/NYC97MA005.md): McDonnell Douglas MD-88 · Flushing, NY · Accident · Minor injuries · Class 1 · Major · Final report · Oct 19, 1996 · N914DL · Substantial damage
  > The Safety Board's full report is available at www.ntsb.gov/publictn/publictn.htm. NTSB Report AAR-97/03. the inability of the captain, because of his use of monovision contact lenses, to overcome his misperception of the airplane's position relative to the…

Next page: https://openairdocs.org/ntsb-phases/500/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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/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.