# NTSB investigations: 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 166 of 420 · 20,992 cases

## Cases, newest first

- [NTSB ATL89LA111](https://openairdocs.org/ntsb/ATL89LA111.md): Morrisey 2150A · Lenoir, NC · Accident · 1 fatal · Limited investigation · Final report · Mar 18, 1989 · N41HB · Destroyed
  > Pilot disregarded the apparent severity of the approaching thunderstorms and attempted a circuit of the airport under visual flight rules when it was not possible. The pilot's lack of recent flight experience was a contributing factor.
- [NTSB FTW89LA068](https://openairdocs.org/ntsb/FTW89LA068.md): Cessna 172M · Galveston, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 1989 · N5280R · Destroyed
  > Failure of the pilot to maintain sufficient airspeed, which resulted in a stall and loss of control. Contributing factors were: the weather conditions, which were below minimums, and failure of the pilot to perform a missed approach.
- [NTSB BFO89DID01](https://openairdocs.org/ntsb/BFO89DID01.md): Halstead Sandpiper · Chesapeake, VA · Accident · No injuries · Final report · Mar 17, 1989 · N339RH · Destroyed
  > The pilot/builders improper installation of the ruddervador and the pilot's improper recovery from a bounced landing. A contributing factor was the failure of the FAA to detect the flaw during the certification of the aircraft.
- [NTSB CHI89MA057](https://openairdocs.org/ntsb/CHI89MA057.md): Nihon YS-11A-600 · West Lafayette, IN · Accident · 2 fatal · Major investigation · Final report · Mar 15, 1989 · N128MP · Destroyed
  > A loss of control due to the improper inflight decisions by the crew and the undetected accumulation of ice on the leading edge of the horizontal stabilizer, during flight in a forward center of gravity condition and exacerbated by the extension of full…
- [NTSB ATL89IA104](https://openairdocs.org/ntsb/ATL89IA104.md): Cessna 177RG · Savannah, GA · Incident · No injuries · Incident investigation · Final report · Mar 14, 1989 · N52800 · Minor damage
  > Fatigue-induced fracture of the main landing gear actuator rod end.
- [NTSB DEN89LA085](https://openairdocs.org/ntsb/DEN89LA085.md): Cessna T210L · Roy, UT · Accident · Minor injuries · Limited investigation · Final report · Mar 13, 1989 · N26RS · Substantial damage
  > The pilot allowed himself to become distracted by a landing gear problem, which resulted in fuel exhaustion, when he had insufficient fuel to delay his landing. Factors related to the accident were: the landing gear problem and trees in the emergency landing…
- [NTSB LAX89LA123](https://openairdocs.org/ntsb/LAX89LA123.md): Cessna 182L · Watsonville, CA · Accident · Serious injuries · Limited investigation · Final report · Mar 12, 1989 · N42005 · Substantial damage
  > The pilot's improperly planned approach, and his failure to maintain clearance from the wind sock pole. The proximity of the wind sock (arpt facility) was considered to be a related factor.
- [NTSB MKC89LA076](https://openairdocs.org/ntsb/MKC89LA076.md): Cessna 150 · Monroe City, MO · Accident · No injuries · Limited investigation · Final report · Mar 11, 1989 · N8079S · Substantial damage
  > Fuel contamination and the pilot's failure to comply with a maintenance AD. Contributing to the accident was the pilot's operation of the airplane with a known deficiency.
- [NTSB ATL89LA103](https://openairdocs.org/ntsb/ATL89LA103.md): Cessna 172M · Sanford, NC · Accident · No injuries · Limited investigation · Final report · Mar 11, 1989 · N13188 · Substantial damage
  > Carburetor ice due to the failure of the pilot to properly use the carburetor heat control during descent and flight in the traffic patterns at reduced power. Underlying this is inadequate training in the proper understanding of carburetor icing and the…
- [NTSB MIA89FA100](https://openairdocs.org/ntsb/MIA89FA100.md): Beech S35 · Daytona Beach, FL · Accident · 2 fatal · Field investigation · Final report · Mar 9, 1989 · N6852Q · Destroyed
  > The pilot's improper IFR procedure and his failure to maintain proper altitude. Contributing factors were: his improper use of the navigation receiver, his delay in making a missed apch, his lack of experience in the type of aircraft, his lack of recent…
- [NTSB LAX89LA121](https://openairdocs.org/ntsb/LAX89LA121.md): Piper PA-38-112 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Mar 5, 1989 · N25620 · Substantial damage
  > The failure of the instructor pilot to properly evaluate the weather conditions resulting in an encounter with an unanticipated downdraft condition and failure of the student pilot to maintain a proper descent rate.
- [NTSB MIA89LA097](https://openairdocs.org/ntsb/MIA89LA097.md): Piper PA-22-135 · Jacksonville, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1989 · N3243B · Destroyed
  > An unstabilized instrument approach wherein the pilot descended below the mda. Contributing factors included an inadequately equipped acft and the pilot's lack of recent instrument experience.
- [NTSB FTW89LA061](https://openairdocs.org/ntsb/FTW89LA061.md): Cessna 182 · Robstown, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 3, 1989 · N735EZ · Destroyed
  > The pilot delayed flight to an alternate destination, continued flight into instrument meteorological conditions (IMC), experienced spatial disorientation, and lost control of the aircraft. Contributing factors were: the pilot's inadequate preflight…
- [NTSB NYC89FA097](https://openairdocs.org/ntsb/NYC89FA097.md): Beech 95-A55 · Lake Placid, NY · Accident · 1 fatal · Field investigation · Final report · Mar 1, 1989 · N1729Q · Destroyed
  > The pilot's departure into known adverse weather conditions and his continued VFR flight into instrument meteorological conditions. Contributing factor(s) was: the adverse weather conditions.
- [NTSB MIA89FA096](https://openairdocs.org/ntsb/MIA89FA096.md): Douglas DC-3 · Isla Verde, PR · Accident · Minor injuries · Field investigation · Final report · Mar 1, 1989 · N28PR · Substantial damage
  > The failure of the flight crew to feather the left propeller and trim the aircraft after the left engine stopped producing power for undetermined reasons.
- [NTSB FTW89IA064](https://openairdocs.org/ntsb/FTW89IA064.md): Mcdonnell Douglas DC-9-82 · Houston, TX · Incident · No injuries · Incident investigation · Final report · Mar 1, 1989 · N820NY · 2 aircraft · No damage
  > Failure of the TRACON final approach controller to assure radar separation between the aircraft. Factors related to the accident were: inadequate supervision by the ATC supervisor, excessive workload for the controller, unclear instructions by the controller,…
- [NTSB DEN89LA081](https://openairdocs.org/ntsb/DEN89LA081.md): Cessna 150 · Evanston, WY · Accident · No injuries · Limited investigation · Final report · Mar 1, 1989 · N11009 · Substantial damage
  > The failure of the pilot to maintain the proper descent rate on final approach which resulted in a landing short of the runway.
- [NTSB LAX89LA116](https://openairdocs.org/ntsb/LAX89LA116.md): Cessna 177 · Yuba City, CA · Accident · No injuries · Limited investigation · Final report · Feb 26, 1989 · N2377Y · Substantial damage
  > Inadequate supervision by the instructor (CFI) which resulted in a delayed go-around, inadequate airspeed, and a stall/mush into the ground. A poor approach by the student pilot was a contributing factor.
- [NTSB FTW89DQA02](https://openairdocs.org/ntsb/FTW89DQA02.md): I.C.A. Brasov IS-28B2 · El Paso, TX · Accident · Serious injuries · Final report · Feb 26, 1989 · N91363 · Substantial damage
  > The failure of the pilot to maintain adequate airspeed, while maneuvering to land in turbulent weather, which resulted in a stall/spin and subsequent collision with a tree and the ground. Turbulence was a factor.
- [NTSB NYC89LA090](https://openairdocs.org/ntsb/NYC89LA090.md): Taylorcraft L-2M · Olcott, NY · Accident · Minor injuries · Limited investigation · Final report · Feb 25, 1989 · N60201 · Destroyed
  > The inattentiveness of the pilot to maintain airspeed while turning base leg for landing which resulted in a stall and subsequent collision with a hangar.
- [NTSB FTW89LA054](https://openairdocs.org/ntsb/FTW89LA054.md): Cessna 182A · Brownsville, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 1989 · N3826D · Substantial damage
  > The pilot failed to compensate for the existing wind conditions and maintain proper alignment with the runway. The wind conditions and the sunglare are considered to be contributing factors to the accident.
- [NTSB LAX89FA113](https://openairdocs.org/ntsb/LAX89FA113.md): Cessna 172F · Safford, AZ · Accident · 1 fatal · Field investigation · Final report · Feb 18, 1989 · N8492U · Destroyed
  > Failure of the pilot to maintain proper airspeed while on final approach resulting in an aerodynamic stall. Contributing to the accident was the pilot's delayed use of wing flaps.
- [NTSB FTW89LA052](https://openairdocs.org/ntsb/FTW89LA052.md): Cessna 206 · Austin, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1989 · N5175U · Substantial damage
  > The pilot's inaccurate fuel consumption calculations and improper positioning of the fuel tank selector valve.
- [NTSB MIA89FA088](https://openairdocs.org/ntsb/MIA89FA088.md): Cessna 320E · Melrose, FL · Accident · 2 fatal · Field investigation · Final report · Feb 17, 1989 · N3488Q · Destroyed
  > The failure of the pilot to comply promptly with ATC instructions and his loss of control due to spatial disorientation.
- [NTSB ATL89LA087](https://openairdocs.org/ntsb/ATL89LA087.md): Piper PA-23-250 · Huntersville, NC · Accident · No injuries · Limited investigation · Final report · Feb 12, 1989 · N5112Y · Destroyed
  > Fire resulting from an oil leak of undetermined origin in the area of the left engine.
- [NTSB NYC89LA083](https://openairdocs.org/ntsb/NYC89LA083.md): Piper PA-28-161 · Yarmouth, MA · Accident · 1 fatal · Limited investigation · Final report · Feb 11, 1989 · N38529 · Destroyed
  > A loss of engine power and subsequent forced landing which resulted from binding of the carbuerator throttle shaft. The binding resulted from an improper overhaul of the carbuertor approximately 10 flight hours prior to the accident.
- [NTSB LAX89FA103](https://openairdocs.org/ntsb/LAX89FA103.md): Cessna 150K · Honolulu, HI · Accident · Minor injuries · Field investigation · Final report · Feb 9, 1989 · N6149G · 2 aircraft · Substantial damage
  > Inadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…
- [NTSB MIA89GA082](https://openairdocs.org/ntsb/MIA89GA082.md): Cessna T210L · Melbourne, FL · Accident · Minor injuries · Final report · Feb 8, 1989 · N81859 · Substantial damage
  > Failure of the pilot to accurately determine fuel quantity prior to departure followed by his failure to operate the engine on the fullest fuel tank resulting in a fuel tank being run dry resulting in engine failure while on short final approach at his…
- [NTSB MIA89FA078](https://openairdocs.org/ntsb/MIA89FA078.md): Beech A23-24 · Clearwater, FL · Accident · Serious injuries · Field investigation · Final report · Feb 4, 1989 · N3697Q · Destroyed
  > Fuel starvation due to the CFI depleting the fuel supply from one of two tanks and failing to select the fullest tank for landing. Contributing to the accident was the cfi's improper decision to turn back to the airport when insufficient altitude was…
- [NTSB LAX89DVD02](https://openairdocs.org/ntsb/LAX89DVD02.md): War Replicas P-51 · Tracy, CA · Accident · 1 fatal · Final report · Feb 4, 1989 · N51K · Destroyed
  > The improper installation of the aileron controls of this homebuilt acft by the pilot/manufacturer which led to the inflight loss of control of the airplane. Contributing to the accident was the pilot's inexperience in the airplane.
- [NTSB FTW89LA045](https://openairdocs.org/ntsb/FTW89LA045.md): Piper J-3C-65 · Richards, TX · Accident · Minor injuries · Limited investigation · Final report · Feb 2, 1989 · N6675H · Substantial damage
  > The pilot's inadequate preflight planning/preparation in disregarding wind information. Contributing to the accident were the gusting crosswind conditions and the pilot's overconfidence in personal ability.
- [NTSB MKC89LA056](https://openairdocs.org/ntsb/MKC89LA056.md): Cessna 172 · Ainsworth, NE · Accident · No injuries · Limited investigation · Final report · Jan 29, 1989 · N4843G · Substantial damage
  > The loss of power from undetermined reasons during an attempted go-around. Contributing to the accident was the pilot's failure to maintain directional control of the airplane and the crosswind conditions.
- [NTSB LAX89LA097](https://openairdocs.org/ntsb/LAX89LA097.md): Beech E33 · Parlier, CA · Accident · No injuries · Limited investigation · Final report · Jan 28, 1989 · N8403N · Destroyed
  > The pilot's improper in-flight planning/decision to continue to the destination airport after encountering a restrictionof fuel flow from the right tank and subsequent fuel starvation when the left tank emptied. Contributing factors were the blocked fuel vent…
- [NTSB LAX89LA100](https://openairdocs.org/ntsb/LAX89LA100.md): Piper PA-32-300 · Gualala, CA · Accident · No injuries · Limited investigation · Final report · Jan 27, 1989 · N4235R · Substantial damage
  > Pilot misjudged the altitude and distance to the runway and subsequently did not attain the proper touchdown point.
- [NTSB DEN89LA068](https://openairdocs.org/ntsb/DEN89LA068.md): Piper PA-34-200T · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Jan 24, 1989 · N3070M · Substantial damage
  > The loss of right engine power for undetermined reason(s), and the failure of the instructor pilot to feather the right engine. Factors related to the accident were: failure of the left main gear locking mechanism to engage and the unprepared (rough/uneven)…
- [NTSB ATL89DMG02](https://openairdocs.org/ntsb/ATL89DMG02.md): Cessna 172P · Mooresville, NC · Accident · Minor injuries · Final report · Jan 24, 1989 · N98990 · Substantial damage
  > Failure of the pilot to maintain airspeed on final approach to land, which resulted in an inadvertent stall. Factors related to the accident were: carburetor icing conditions, night conditions, and the pilot's decision to land at an unlighted runway.
- [NTSB FTW89DRA02](https://openairdocs.org/ntsb/FTW89DRA02.md): Pitts S1A · Santa Fe, TX · Accident · Serious injuries · Final report · Jan 22, 1989 · N9961 · Substantial damage
  > Pilot in command failed to maintain adequate altitude and clearance on final approach.
- [NTSB DEN89IA067](https://openairdocs.org/ntsb/DEN89IA067.md): Boeing 707-323B · Salt Lake City, UT · Incident · No injuries · Incident investigation · Final report · Jan 22, 1989 · N712PC · Minor damage
  > The pilot-in-command's attempt to align the airplane with the runway at an altitude insufficient for safe maneuvering, resulting in the no. 1 engine striking the runway. Contributing factors include obscured visibility due to fog, the captain's loss of depth…
- [NTSB ATL89LA082](https://openairdocs.org/ntsb/ATL89LA082.md): Cessna 150 · Cambridge, OH · Accident · No injuries · Limited investigation · Final report · Jan 22, 1989 · N1497Q · Substantial damage
  > The pilot's failure to maintain directional control in crosswind conditions while on short final and the improperly adjusted carburetor idle flow.
- [NTSB CHI89GA048](https://openairdocs.org/ntsb/CHI89GA048.md): Piper PA-28-180 · Chicago, IL · Accident · 2 fatal · Final report · Jan 21, 1989 · N16375 · Destroyed
  > Inadequate preflight of the aircraft by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel. Factors related to the accident were: high obstructions and retaining wall in the emergency landing area.
- [NTSB DEN89LA062](https://openairdocs.org/ntsb/DEN89LA062.md): Beech V35B · Broomfield, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 18, 1989 · N1721W · Substantial damage
  > Fuel starvation due to improper fuel tank selectior operation by the pilot. A factor related to the accident was: unprepared (rough/uneven) terrain short of the runway.
- [NTSB MKC89LA054](https://openairdocs.org/ntsb/MKC89LA054.md): Beech C-23 · Greenfield, IA · Accident · No injuries · Limited investigation · Final report · Jan 17, 1989 · N24658 · Substantial damage
  > The pilot's failure to assure an an adequate supply of fuel was on board in order to complete the flight.
- [NTSB SEA89LA035](https://openairdocs.org/ntsb/SEA89LA035.md): Cessna 206 · Sekiu, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 1989 · N732FN · Substantial damage
  > Pilot attempted a landing in adverse weather conditions, rather than postpone the business trip and return to origin or other safe area. Contributing to the accident were turbulence and gusty winds along with the self induced pressure to make the business flt.
- [NTSB LAX89LA084](https://openairdocs.org/ntsb/LAX89LA084.md): Grumman American AA-1B · Westlake, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 15, 1989 · N7174L · Destroyed
  > Improper planning and decision by the pilot which resulted in fuel exhaustion. Contributing factors were: faulty fuel indication, utility pole & uneven terrain.
- [NTSB SEA89LA034](https://openairdocs.org/ntsb/SEA89LA034.md): Cessna 210 · Carson City, NV · Accident · No injuries · Limited investigation · Final report · Jan 14, 1989 · N7342E · Substantial damage
  > Separation of the throttle cable due to wear as power was applied for a landing go-around. Contributing to the accident was rough terrain at the touchdown point of the forced landing.
- [NTSB NYC89LA066](https://openairdocs.org/ntsb/NYC89LA066.md): Cessna T210 · Newport, RI · Accident · Minor injuries · Limited investigation · Final report · Jan 14, 1989 · N6556A · Destroyed
  > Loss of control during an attempted go-around due to raising the flaps at low airspeed, in a nose high attitude.
- [NTSB CHI89LA045](https://openairdocs.org/ntsb/CHI89LA045.md): Piper PA-28-180 · Valparaiso, IN · Accident · No injuries · Limited investigation · Final report · Jan 14, 1989 · N3331R · Substantial damage
  > Inadequate preflight preparation by the pilot, which resulted in inadvertent flight in icing conditions and rapid accumulation of airframe ice, and the pilot's failure to maintain sufficient airspeed to flare during the landing. Factors related to the…
- [NTSB MIA89LA067](https://openairdocs.org/ntsb/MIA89LA067.md): Piper PA-28R-200 · Rose Hill, MS · Accident · Serious injuries · Limited investigation · Final report · Jan 11, 1989 · N9378N · Substantial damage
  > Loss of electrical power for an undetermined reason and fuel starvation from improper use of the fuel selector. Factors related to the accident were: night and adverse weather conditions.
- [NTSB ATL89FA071](https://openairdocs.org/ntsb/ATL89FA071.md): Cessna 208B · Madison, NC · Accident · Serious injuries · Field investigation · Final report · Jan 11, 1989 · N9330B · Destroyed
  > Improper IFR procedure by the pilot and his failure to maintain the minimum descent altitude (mda). Contributing factors were: low ceiling, fog, delayed missed approach by the pilot, and trees.
- [NTSB LAX89FA083](https://openairdocs.org/ntsb/LAX89FA083.md): Pitts S2B · Ramona, CA · Accident · Serious injuries · Field investigation · Final report · Jan 10, 1989 · N5332G · 2 aircraft · Destroyed
  > The Pitts pilot's inadequate visual lookout. Contributing factor(s) was: inadequate radio communications by the Pitts pilot.

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=167

## 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 = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=166

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