# NTSB investigations, 1995: 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 7 · 301 cases

## Latest cases

- [NTSB MIA96FA051](https://openairdocs.org/ntsb/MIA96FA051.md): Cessna 550 · East Naples, FL · Accident · 2 fatal · Field investigation · Final report · Dec 31, 1995 · N91MJ · Destroyed
  > The pilot's disregard for the MDA for a specific segment of the VOR/DME approach which resulted in the inflight collision with a guy wire of an antenna and separation of 8.5 feet of the left wing.
- [NTSB LAX96FA086](https://openairdocs.org/ntsb/LAX96FA086.md): Beech V35B · Delano, CA · Accident · 4 fatal · Field investigation · Final report · Dec 30, 1995 · N7337R · Destroyed
  > Failure of the pilot to maintain control of the aircraft during an IFR circling approach. A factor relating to the accident was: the pilot's lack of instrument flight experience in high performance aircraft.
- [NTSB CHI96FA067](https://openairdocs.org/ntsb/CHI96FA067.md): Cessna 560 · Eagle River, WI · Accident · 2 fatal · Field investigation · Final report · Dec 30, 1995 · N991PC · Destroyed
  > the failure of the pilot to maintain airspeed while executing the circling approach. Factors were the descent below minimum descent altitude, the fog, the low ceiling and the icing conditions.
- [NTSB BFO96FA034](https://openairdocs.org/ntsb/BFO96FA034.md): Piper PA-28R-180 · Louisville, KY · Accident · 1 fatal · Field investigation · Final report · Dec 30, 1995 · N7676J · Destroyed
  > failure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall, loss of altitude, and subsequent collision with obstructions (utility pole and supporting cable).
- [NTSB LAX96LA088](https://openairdocs.org/ntsb/LAX96LA088.md): Cessna 150L · Quartzite, AZ · Accident · No injuries · Limited investigation · Final report · Dec 29, 1995 · N1246Q · Substantial damage
  > the pilot's misjudgement of his distance and altitude relationship to the runway, which resulted in an undershoot and failure to achieve the proper touchdown point for landing.
- [NTSB CHI96LA064](https://openairdocs.org/ntsb/CHI96LA064.md): Bellanca 7GCBC · Munich, ND · Accident · No injuries · Limited investigation · Final report · Dec 28, 1995 · N88384 · Substantial damage
  > the pilot allowed his airspeed to get too low and encountered a stall/mush condition. Factors associated with the accident were the pilot not being able to maintain directional control due to misuse of the controls for wind drift correction and improper use…
- [NTSB CHI96IA066](https://openairdocs.org/ntsb/CHI96IA066.md): Fairchild SA227-AC · Bemidji, MN · Incident · No injuries · Incident investigation · Final report · Dec 28, 1995 · N159MC · No damage
  > inadequate maintenance installation and inspection of the elevator flight control system which led to restricted flight control elevator movement due to a loose bolt.
- [NTSB FTW96FA075](https://openairdocs.org/ntsb/FTW96FA075.md): Aero Commander 112 · Carlsbad, NM · Accident · 2 fatal · Field investigation · Final report · Dec 24, 1995 · N1152J · Destroyed
  > The pilot's failure to maintain aircraft control due to spatial disorientation. Factors were the pilot's lack of total actual instrument weather time and the clouds.
- [NTSB LAX96FA078](https://openairdocs.org/ntsb/LAX96FA078.md): Piper PA-31-350 · San Jose, CA · Accident · 2 fatal · Field investigation · Final report · Dec 23, 1995 · N27954 · Destroyed
  > The failure of the air traffic controller to comply with instructions contained in the Air Traffic Control Handbook, FAA Order 7110.65, which resulted in the flight being vectored at an altitude below the minimum vectoring altitude (MVA) and failure to issue…
- [NTSB FTW96LA083](https://openairdocs.org/ntsb/FTW96LA083.md): Piper PA-22-160 · Waller, TX · Accident · No injuries · Limited investigation · Final report · Dec 22, 1995 · N9591D · Substantial damage
  > the pilot's failure to maintain obstacle clearance.
- [NTSB CHI96LA057](https://openairdocs.org/ntsb/CHI96LA057.md): Beech 58 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Dec 22, 1995 · N222RB · Substantial damage
  > the pilot-in-command's abrupt maneuvering during the circling approach. The factors involved were the airframe ice and fog.
- [NTSB MIA96FA048](https://openairdocs.org/ntsb/MIA96FA048.md): Piper PA-32-301 · Memphis, TN · Accident · 2 fatal · Field investigation · Final report · Dec 19, 1995 · N8349Z · Destroyed
  > the pilot's continued flight into known forecast icing conditions which resulted in the aircraft developing an ice buildup, and the pilot's failure to maintain control of the aircraft. The icing conditions was a factor.
- [NTSB ATL96LA024](https://openairdocs.org/ntsb/ATL96LA024.md): Piper PA-32-300 · Monroe, NC · Accident · No injuries · Limited investigation · Final report · Dec 19, 1995 · N4219T · Substantial damage
  > The pilot's inadequate planning and failure to follow operating procedures resulted in his descent below the decision height while on final approach.
- [NTSB SEA96LA030](https://openairdocs.org/ntsb/SEA96LA030.md): Cessna 170B · John Day, OR · Accident · No injuries · Limited investigation · Final report · Dec 16, 1995 · N3171B · Substantial damage
  > The pilot's failure to maintain a proper glidepath.
- [NTSB MIA96LA040](https://openairdocs.org/ntsb/MIA96LA040.md): Cessna 152 · Macon, GA · Accident · Serious injuries · Limited investigation · Final report · Dec 14, 1995 · N48959 · Substantial damage
  > The pilot-in-command's failure to assure an adequate amount of fuel was available for the flight.
- [NTSB FTW96LA069](https://openairdocs.org/ntsb/FTW96LA069.md): Ayres S2R-T34 · West Helena, AR · Accident · No injuries · Limited investigation · Final report · Dec 13, 1995 · N3090C · Substantial damage
  > Binding of the power lever linkage, due to corrosion, which resulted in a situation that led to an inadvertent shut-down of the engine at a critical point on the approach to land. A factor relating to the accident was: inadequate maintenance.
- [NTSB MIA96IA039](https://openairdocs.org/ntsb/MIA96IA039.md): Boeing 747-212B · Amsterdam, Netherlands · Incident · No injuries · Incident investigation · Final report · Dec 10, 1995 · N616FF · Minor damage
  > The failure of the captain to maintain a level wings attitude during a go-around resulting in the right wing dragging on the ground.
- [NTSB ANC96LA018](https://openairdocs.org/ntsb/ANC96LA018.md): Piper PA-32-300 · Nanwalek, AK · Accident · Serious injuries · Limited investigation · Final report · Dec 10, 1995 · N15175 · Substantial damage
  > The pilot's inadequate compensation for wind conditions. A factor in the accident was the variable wind.
- [NTSB LAX96LA069](https://openairdocs.org/ntsb/LAX96LA069.md): Cessna 172 · Ocotillo Wells, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 1995 · N4203L · Substantial damage
  > the failure of the pilot to maintain a proper glide path on final approach.
- [NTSB LAX96LA068](https://openairdocs.org/ntsb/LAX96LA068.md): Cessna T210N · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Dec 8, 1995 · N214BD · Destroyed
  > the pilot's inadequate preflight planning and preparation, which resulted in fuel exhaustion, due to an inadequate supply of fuel, followed by a forced landing in an area of trees. Darkness was a related factor.
- [NTSB LAX96FA067](https://openairdocs.org/ntsb/LAX96FA067.md): Cessna 340A · San Dimas, CA · Accident · 1 fatal · Field investigation · Final report · Dec 7, 1995 · N37324 · Destroyed
  > the pilot's impairment of judgment and performance due to drugs, his resultant improper planning/decision, his failure to follow proper IFR procedures, and his failure to maintain proper altitude during a missed approach. Factors relating to the accident…
- [NTSB MIA96LA036](https://openairdocs.org/ntsb/MIA96LA036.md): Cessna 150J · Orange Springs, FL · Accident · No injuries · Limited investigation · Final report · Dec 6, 1995 · N60758 · Substantial damage
  > The pilot's improper use of carburetor heat resulting in engine failure due to carburetor ice.
- [NTSB MIA96FA035](https://openairdocs.org/ntsb/MIA96FA035.md): Aerospatiale TB-20 · Meridian, MS · Accident · 3 fatal · Field investigation · Final report · Dec 6, 1995 · N33AS · Destroyed
  > the pilot's failure to maintain airspeed (VSO) while maneuvering during an ILS approach in instrument flight conditions. Factors related to the accident were: the pilot's failure to follow the published approach procedure, his failure to maintain a proper…
- [NTSB MIA96LA034](https://openairdocs.org/ntsb/MIA96LA034.md): Cessna 172M · Madison, MS · Accident · No injuries · Limited investigation · Final report · Dec 4, 1995 · N12245 · Substantial damage
  > The pilot's premature raising of flaps during a go-around.
- [NTSB CHI96FA045](https://openairdocs.org/ntsb/CHI96FA045.md): Piper PA-28 · Friedens, PA · Accident · 1 fatal · Field investigation · Final report · Dec 3, 1995 · N8775W · Destroyed
  > the pilot's failure to follow instrument approach procedures, by not maintaining proper altitude and by descending below the minimum descent altitude. Factors relating to the accident were: the air traffic controller's failure to issue a proper clearance, the…
- [NTSB FTW96LA068](https://openairdocs.org/ntsb/FTW96LA068.md): Aviat A-1 · Collinsville, OK · Accident · Minor injuries · Limited investigation · Final report · Dec 2, 1995 · N236CD · Substantial damage
  > The pilot's improper planning/decision, his failure to periodically clear the engine during the glide, and failure to see-and-avoid the transmission line during the approach for an emergency landing.
- [NTSB LAX96LA060](https://openairdocs.org/ntsb/LAX96LA060.md): Laister LP-15 · Adelanto, CA · Accident · Serious injuries · Limited investigation · Final report · Dec 1, 1995 · N6LS · Destroyed
  > the pilot's selection of the wrong runway for the prevailing wind conditions, and his failure to maintain an adequate airspeed during the base-to-final turn.
- [NTSB CHI96LA047](https://openairdocs.org/ntsb/CHI96LA047.md): Cessna 310R · Michigan City, IN · Accident · No injuries · Limited investigation · Final report · Nov 28, 1995 · N5CX · Substantial damage
  > the pilot-in-command's selecting and maintaining an improper approach speed.
- [NTSB ANC96TA016](https://openairdocs.org/ntsb/ANC96TA016.md): Cessna 182H · Koyuk, AK · Accident · No injuries · Final report · Nov 28, 1995 · N1997X · Destroyed
  > The pilot's delayed application of carburetor heat. Factors in the accident were carburetor icing conditions and lack of suitable terrain for a forced landing.
- [NTSB LAX96LA056](https://openairdocs.org/ntsb/LAX96LA056.md): Monocoupe 90A · Salinas, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 26, 1995 · N11768 · Substantial damage
  > the pilot's failure to properly recover from a slipping maneuver.
- [NTSB SEA96FA024](https://openairdocs.org/ntsb/SEA96FA024.md): Beech C24R · Bozeman, MT · Accident · 2 fatal · Field investigation · Final report · Nov 25, 1995 · N3729T · Substantial damage
  > failure of the pilot to follow the specified approach track (proper IFR procedure), and his associated failure to maintain altitude or clearance from mountainous terrain. Factors relating to the accident were: the pilot's failure to abide by the aircraft…
- [NTSB FTW96LA051](https://openairdocs.org/ntsb/FTW96LA051.md): Cessna 310J · Englewood, CO · Accident · Minor injuries · Limited investigation · Final report · Nov 24, 1995 · N1147M · Substantial damage
  > failure of the pilot to feather the propeller on the inoperative engine in accordance with the emergency procedure. Factors relating to the accident were: loss of power in the left engine for undetermined reason(s), and rough/uneven terrain in the emergency…
- [NTSB MIA96LA026](https://openairdocs.org/ntsb/MIA96LA026.md): Piper PA-32-300 · Fort Lauderdale, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 23, 1995 · N44CQ · Substantial damage
  > The pilots failure to follow the visual approach slope indicator and maintain a proper glidepath during approach. Contributing to the accident was pilot fatigue.
- [NTSB FTW96FA048](https://openairdocs.org/ntsb/FTW96FA048.md): Beech A35 · Hudson, CO · Accident · 1 fatal · Field investigation · Final report · Nov 21, 1995 · N8759A · Destroyed
  > The pilot's failure to maintain clearance. A factor was improper in-flight planning.
- [NTSB LAX96FA050](https://openairdocs.org/ntsb/LAX96FA050.md): Piper PA-32-300 · Fullerton, CA · Accident · 3 fatal · Field investigation · Final report · Nov 20, 1995 · N888JK · Destroyed
  > the pilot-in-command's failure to follow IFR procedures in that he descended below the minimum descent altitude and failed to execute a missed approach. Contributing to the accident was the pilot-in-command's self-induced pressure to get to work.
- [NTSB LAX96FA049](https://openairdocs.org/ntsb/LAX96FA049.md): Beech S35 · Oxnard, CA · Accident · 1 fatal · Field investigation · Final report · Nov 19, 1995 · N5795K · Destroyed
  > failure of the pilot to maintain adequate airspeed during a missed approach, after encountering an undetermined propeller malfunction, which resulted in a stall and collision with the terrain. Factors relating to the accident were: darkness, fog, and the…
- [NTSB BFO96LA023](https://openairdocs.org/ntsb/BFO96LA023.md): Beech A23-24 · New Carlisle, OH · Accident · No injuries · Limited investigation · Final report · Nov 19, 1995 · N4758J · Substantial damage
  > the pilot-in-command's failure to reach the proper touchdown point. Related factors were the pilot's failure to obtain/maintain the proper glidepath during the approach, and the rough/uneven terrain encountered after the airplane touched down short of the…
- [NTSB LAX96LA048](https://openairdocs.org/ntsb/LAX96LA048.md): Cessna 150H · Imperial, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 18, 1995 · N23102 · Destroyed
  > the student pilot's misreading of the altimeter while in the traffic pattern, which put the aircraft in dangerous proximity to the ground and obstructions. A factor in the accident was the pilot's inability to see the power pole due to sun glare as the…
- [NTSB CHI96FA034](https://openairdocs.org/ntsb/CHI96FA034.md): Ercoupe 415-C · Stafford, KS · Accident · 2 fatal · Field investigation · Final report · Nov 18, 1995 · N93726 · Destroyed
  > the pilot misjudged his distance and altitude and flew into transmission wires. A factor was the pilot's lack of recent night flying experience.
- [NTSB MIA96LA028](https://openairdocs.org/ntsb/MIA96LA028.md): Bell 47-D1 · Jasper, FL · Accident · No injuries · Limited investigation · Final report · Nov 15, 1995 · N4702S · Substantial damage
  > Improper maintenance and inspection of the carburetor system by maintenance personnel during the last annual inspection which resulted in a partial loss of engine power due to carburetor ice. Contributing to the accident were: the pilot's failure to perform…
- [NTSB NYC96LA025](https://openairdocs.org/ntsb/NYC96LA025.md): Cessna 150J · Norwood, MA · Accident · No injuries · Limited investigation · Final report · Nov 13, 1995 · N51197 · Substantial damage
  > the student's inadvertent use of the mixture control and the flight instructor's inadequate supervision during the final approach resulting in the loss of engine power due to fuel starvation and the subsequent nose over during the forced landing.
- [NTSB FTW96LA041](https://openairdocs.org/ntsb/FTW96LA041.md): Piper PA-28-201T · Keller, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 12, 1995 · N2141Z · Substantial damage
  > the inadequate visual lookout by the driver of the vehicle resulting in his obstructing the runway.
- [NTSB DCA96MA008](https://openairdocs.org/ntsb/DCA96MA008.md): McDonnell Douglas MD-83 · East Granby, CT · Accident · Minor injuries · Class 1 · Major · Final report · Nov 12, 1995 · N566AA · Substantial damage
  > the flightcrew's failure to maintain the required minimum descent altitude until the required visual references identifiable with the runway were in sight. Contributing factors were the failure of the BDL approach controller to furnish the flightcrew with a…
- [NTSB NYC96FA024](https://openairdocs.org/ntsb/NYC96FA024.md): Piper PA-23-250 · Ashville, NY · Accident · 1 fatal · Field investigation · Final report · Nov 11, 1995 · N62620 · Destroyed
  > the pilot's misjudgment of altitude and distance to the runway during an approach to land. Factors relating to the accident were: the night and adverse weather conditions.
- [NTSB CHI96LA031](https://openairdocs.org/ntsb/CHI96LA031.md): Beech 35 · Belleville, KS · Accident · No injuries · Limited investigation · Final report · Nov 10, 1995 · N9894R · Substantial damage
  > the pilot misjudging his approach to the runway. Factors relating to the accident were: the weather conditions, a sick passenger that diverted the pilot's attention, the snow covered terrain, and the pilot's decision not to execute the missed approach…
- [NTSB BFO96LA026](https://openairdocs.org/ntsb/BFO96LA026.md): Cessna 210E · Newport News, VA · Accident · No injuries · Limited investigation · Final report · Nov 10, 1995 · N2314F · Substantial damage
  > the failure of the engine-driven hydraulic pump drive shaft, the pilot's failure to properly engage the emergency landing gear handle.
- [NTSB LAX96FA042](https://openairdocs.org/ntsb/LAX96FA042.md): Beech S35 · Kneeland, CA · Accident · 4 fatal · Field investigation · Final report · Nov 9, 1995 · N8920M · Destroyed
  > failure of the pilot to correct a descending spiral and perform a missed approach, after becoming spatially disoriented and deviating from the planned ILS approach procedure. Factors relating to the accident were: darkness, and the pilot's excessive…
- [NTSB BFO96LA018](https://openairdocs.org/ntsb/BFO96LA018.md): Beech 35 · Phillipsburg, OH · Accident · No injuries · Limited investigation · Final report · Nov 5, 1995 · N5376E · Substantial damage
  > The flight instructor's (CFI's) inadequate supervision of the flying pilot, and the flying pilot's abrupt handling of the airplane during an attempted go-around. Factors relating to the accident were: the flying pilot's lack of familiarity with light piston…
- [NTSB LAX96LA039](https://openairdocs.org/ntsb/LAX96LA039.md): Cessna 402B · Redwood City, CA · Accident · Minor injuries · Limited investigation · Final report · Nov 4, 1995 · N316HG · Substantial damage
  > the simultaneous total loss of engine power for undetermined reasons.
- [NTSB DCA96IA005](https://openairdocs.org/ntsb/DCA96IA005.md): Boeing B-737-500 · San Francisco, CA · Incident · No injuries · Incident investigation · Final report · Oct 29, 1995 · N904UA · No damage
  > The inadvertant stall for undertermined reasons.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?year=1995&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") = 1995
  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=1995

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