# 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 85 of 420 · 20,992 cases

## Cases, newest first

- [NTSB MIA04LA074](https://openairdocs.org/ntsb/MIA04LA074.md): Terry E. Morris Glasair III · Lakeland, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 2004 · N333ZZ · Substantial damage
  > The pilot's failure to maintain airspeed and establish a climb during an attempted go-around which resulted in a stall/mush and collision with terrain. His failure to follow air traffic control instructions is a contributing factor.
- [NTSB NYC04CA108](https://openairdocs.org/ntsb/NYC04CA108.md): Andrews Zenith Tri-Z · Kennedy, NY · Accident · Serious injuries · Data collection · Final report · Apr 16, 2004 · N569Z · Substantial damage
  > The pilot's improper fuel tank selector position which resulted in a loss of engine power due to fuel starvation.
- [NTSB MIA04LA071](https://openairdocs.org/ntsb/MIA04LA071.md): Beech Be-300 · Daytona Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 2004 · N301KS · Destroyed
  > The pilot's inadequate management of the airplane's fuel system, which resulted in fuel starvation, a loss of engine power, a forced landing, and damage to the airplane during the landing.
- [NTSB FTW04LA109](https://openairdocs.org/ntsb/FTW04LA109.md): Spannagel RV-8A · Borger, TX · Accident · No injuries · Limited investigation · Final report · Apr 15, 2004 · N82LS · Substantial damage
  > A partial loss of engine power as a result of inadequate clearance between the journals and bearings.
- [NTSB ATL04FA093](https://openairdocs.org/ntsb/ATL04FA093.md): Cessna 182S · North Augusta, SC · Accident · 3 fatal · Field investigation · Final report · Apr 12, 2004 · N364ME · Substantial damage
  > The pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an uncontrolled descent and subsequent in-flight collision with trees and the ground.
- [NTSB DEN04IA060](https://openairdocs.org/ntsb/DEN04IA060.md): Canadair CL-600-2C10 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Apr 11, 2004 · N609QX · No damage
  > The total failure of the airplane's number 1 system hydraulic pump.
- [NTSB FTW04LA103](https://openairdocs.org/ntsb/FTW04LA103.md): Pdps PZL-Bielsko SZD-50-3 · Cherry Valley, AR · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 2004 · N18SZ · Substantial damage
  > The pilot's failure to maintain airspeed during the landing which resulted in an inadvertent stall.
- [NTSB CHI04LA099](https://openairdocs.org/ntsb/CHI04LA099.md): Beech C35 · Big Rapids, MI · Accident · Serious injuries · Limited investigation · Final report · Apr 4, 2004 · N1922D · Substantial damage
  > The total loss of engine power due to the pilot's improper fuel management which led to fuel starvation.
- [NTSB NYC04LA101](https://openairdocs.org/ntsb/NYC04LA101.md): Piper PA-28R-180 · Elyria, OH · Accident · No injuries · Limited investigation · Final report · Apr 3, 2004 · N19AG · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB NYC04FA100](https://openairdocs.org/ntsb/NYC04FA100.md): Piper PA-28R-180 · Harrietstown, NY · Accident · 2 fatal · Field investigation · Final report · Apr 3, 2004 · N4686J · Substantial damage
  > The pilot's failure to follow instrument flight rules procedures resulting in a collision with a tree. Factors related to the accident were the dark night conditions, low visibility, and low cloud ceiling.
- [NTSB FTW04LA101](https://openairdocs.org/ntsb/FTW04LA101.md): Piper PA-32R-300 · Georgetown, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 2004 · N47976 · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB CHI04LA098](https://openairdocs.org/ntsb/CHI04LA098.md): Navion B · Joplin, MO · Accident · No injuries · Limited investigation · Final report · Apr 3, 2004 · N5223K · Substantial damage
  > The loss of engine power for undetermined reasons. The posts, unsuitable terrain and signs were factors to the accident.
- [NTSB ATL04CA089](https://openairdocs.org/ntsb/ATL04CA089.md): Cessna 172N · Statesboro, GA · Accident · No injuries · Data collection · Final report · Apr 3, 2004 · N4874G · Substantial damage
  > The pilot's failure to establish a positive climb and his failure to maintain clearance during a go-around, which resulted in an in-flight collision with trees. A factor was the gusting winds.
- [NTSB ATL04LA088](https://openairdocs.org/ntsb/ATL04LA088.md): Cessna 172N · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Apr 2, 2004 · N271EP · Substantial damage
  > The pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion. The pilot's preflight planning and uneven terrain were contributing factors.
- [NTSB LAX04CA173](https://openairdocs.org/ntsb/LAX04CA173.md): Piper PA34-200 · La Verne, CA · Accident · No injuries · Data collection · Final report · Mar 31, 2004 · N74SA · Substantial damage
  > the CFI 's failure to correctly reconfigure the right engine fuel selector, resulting in a total loss of power to that engine. Also causal was the CFI's failure to maintain direction control of the airplane and an adequate airspeed, which led to the airplane…
- [NTSB SEA04LA066](https://openairdocs.org/ntsb/SEA04LA066.md): PZL Warzawa-Okecie PZL-104 Wilga 35A · Burlington, WA · Accident · No injuries · Limited investigation · Final report · Mar 29, 2004 · N65ZA · Substantial damage
  > The passenger's interference with flight controls during a go-around maneuver. Contributing to the accident were the passenger's anxiety/apprehension, the pilot's inadequate brief to the passenger about potential control interference, and the gusty wind…
- [NTSB ATL04LA087](https://openairdocs.org/ntsb/ATL04LA087.md): Aircraft Mfg & Development Alarus CH2T · Bay Minette, AL · Accident · Serious injuries · Limited investigation · Final report · Mar 28, 2004 · N605AM · Substantial damage
  > The pilot's inadequate inflight decision which resulted in continued VFR flight into IMC conditions, and his failure to maintain clearance which resulted in a collision with trees. A factor was the fog.
- [NTSB SEA04LA058](https://openairdocs.org/ntsb/SEA04LA058.md): Luscombe T8F · Chiloquin, OR · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 2004 · C-FHUH · Substantial damage
  > The pilot's failure to maintain airspeed during a downwind turn resulting in a stall-mush and collision with the ground. Wind gusts were a factor.
- [NTSB NYC04LA088](https://openairdocs.org/ntsb/NYC04LA088.md): Gates Learjet 35A · Utica, NY · Accident · No injuries · Limited investigation · Final report · Mar 19, 2004 · N800AW · Substantial damage
  > The copilot's failure to maintain airspeed, and the captain's delayed remedial action, which resulted in an inadvertent stall and the subsequent hard landing.
- [NTSB LAX04FA162](https://openairdocs.org/ntsb/LAX04FA162.md): Mooney M20K · Los Angeles, CA · Accident · 2 fatal · Field investigation · Final report · Mar 17, 2004 · N1148V · Destroyed
  > The pilot's loss of airplane control while maneuvering due to spatial disorientation. Contributing factors were the low ceiling, reduced visibility (fog), and the pilot's lack of instrument flying currency. An additional factor was the failure of air traffic…
- [NTSB FTW04LA094](https://openairdocs.org/ntsb/FTW04LA094.md): Piper PA-28-151 · Goldwaite, TX · Accident · No injuries · Limited investigation · Final report · Mar 17, 2004 · N43656 · Substantial damage
  > The loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.
- [NTSB LAX04TA161](https://openairdocs.org/ntsb/LAX04TA161.md): WSK PZL Mielec M-18A · Safford, AZ · Accident · 1 fatal · Final report · Mar 16, 2004 · N6259N · Destroyed
  > A loss of engine power due to fuel starvation and at least one ensuing engine power surge, which caused the airplane to pitch up abruptly into a stall at an altitude too low for recovery. Contributing to the accident were the pilot's mismanagement of the fuel…
- [NTSB LAX04CA157](https://openairdocs.org/ntsb/LAX04CA157.md): Cessna 172C · Thermal, CA · Accident · Minor injuries · Data collection · Final report · Mar 14, 2004 · N8287X · Substantial damage
  > the pilot's failure to retract the flaps during the go-around and his failure to obtain and maintain sufficient airspeed, which led to a stall mush condition. High density altitude was a contributing factor.
- [NTSB MIA04LA062](https://openairdocs.org/ntsb/MIA04LA062.md): Beech BE90 · Fort Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Mar 13, 2004 · N11FL · Substantial damage
  > The inadequate inspection of the landing gear system by company maintenance personnel resulting in a crack in the left main landing actuator mount going undetected and collapse of the left landing gear during landing roll when the actuator attachment failed.
- [NTSB DEN04LA065](https://openairdocs.org/ntsb/DEN04LA065.md): Mooney M20C · Clovis, NM · Accident · No injuries · Limited investigation · Final report · Mar 13, 2004 · N6958V · Substantial damage
  > the pilot's improper in-flight planning and decision making during an instrument approach resulting in the pilot's intentional descent below approach minimums, and the pilot's failure to maintain obstacle clearance resulting in the in-flight collision with an…
- [NTSB LAX04FA165](https://openairdocs.org/ntsb/LAX04FA165.md): Mitsubishi MU-2B-40 · Napa, CA · Accident · 2 fatal · Field investigation · Final report · Mar 12, 2004 · N966MA · Destroyed
  > The pilot's failure to maintain control of the airplane following a shutdown of the left engine during a night visual approach. A factor contributing to the accident was the dark night.
- [NTSB ATL04LA082](https://openairdocs.org/ntsb/ATL04LA082.md): Cessna 172N · Knoxville, TN · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 2004 · N6257F · Substantial damage
  > The CFI's inadequate in-flight planning/decision and his inadequate supervision which resulted in fuel exhaustion. A factor was the inadequate preflight planning/preparation to ensure an adequate fuel supply, and the berm.
- [NTSB CHI04LA085](https://openairdocs.org/ntsb/CHI04LA085.md): Cessna 172R · Dubuque, IA · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 2004 · N105FS · Substantial damage
  > The flight instructor's inadequate in-flight planning/decision which resulted in ice accretion on the airframe, and his failure to maintain adequate airspeed resulting in a stall. Contributing factors were the ice contamination, the aircraft's low altitude…
- [NTSB NYC04LA081](https://openairdocs.org/ntsb/NYC04LA081.md): Cessna 150F · Harrisonburg, VA · Accident · Serious injuries · Limited investigation · Final report · Mar 5, 2004 · N3038X · Substantial damage
  > The pilot's improper decision to attempt a landing with an excessive tailwind, which resulted in an inadvertent stall while attempting to climb during a go-around. A factor related to the accident was the tailwind conditions and the rising terrain beyond the…
- [NTSB SEA04LA048](https://openairdocs.org/ntsb/SEA04LA048.md): Cessna 172N · Gig Harbor, WA · Accident · No injuries · Limited investigation · Final report · Mar 3, 2004 · N75844 · Substantial damage
  > The pilot's failure to follow the published IFR procedure resulting in failure to maintain clearance from objects during an instrument approach. Trees and an inoperative glide slope receiver were factors.
- [NTSB LAX04LA143](https://openairdocs.org/ntsb/LAX04LA143.md): Piper PA-28-180 · Mariposa, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 29, 2004 · N5205L · Substantial damage
  > The total loss of engine power for undetermined reasons.
- [NTSB SEA04LA046](https://openairdocs.org/ntsb/SEA04LA046.md): Jerome Q-2 · Hillsboro, OR · Accident · Minor injuries · Limited investigation · Final report · Feb 28, 2004 · N143GJ · Substantial damage
  > The pilot's inadequate evaluation of deteriorating weather conditions (increasing rain) and his failure to maintain the proper rate of descent on landing (long/hard touchdown). Contributing factors were carburetor icing conditions and rain.
- [NTSB FTW04FA083](https://openairdocs.org/ntsb/FTW04FA083.md): Taylorcraft BC12-D · Wrightsville, AR · Accident · 1 fatal · Field investigation · Final report · Feb 27, 2004 · N43005 · Destroyed
  > The pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin on the downwind leg of the traffic pattern.
- [NTSB SEA04IA045](https://openairdocs.org/ntsb/SEA04IA045.md): Boeing 737-300 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Feb 24, 2004 · N368SW · No damage
  > The First Officer's misidentification of the parallel taxiway as the active runway, resulting in the need for a sidestep maneuver while on short final for a full-stop landing. Factors include sun-glare from wet paved surfaces, a visual illusion created by the…
- [NTSB NYC04CA072](https://openairdocs.org/ntsb/NYC04CA072.md): Cessna 172 · West Dover, VT · Accident · No injuries · Data collection · Final report · Feb 14, 2004 · N8880V · Substantial damage
  > The pilot's failure to maintain aircraft control, and his failure to perform a go-around. Factors were wind gusts and the pilot's lack of flight experience.
- [NTSB CHI04LA076](https://openairdocs.org/ntsb/CHI04LA076.md): Cessna 177 · Sturgis, MI · Accident · No injuries · Limited investigation · Final report · Feb 14, 2004 · N3468T · Substantial damage
  > The pilot's inadvertent raising of flaps resulting in a loss of lift and his failure to maintain aircraft control resulting in a dragging of the wing.
- [NTSB ATL04FA075](https://openairdocs.org/ntsb/ATL04FA075.md): Piper PA-28-180 · Alma, GA · Accident · 3 fatal · Field investigation · Final report · Feb 12, 2004 · N6473J · Substantial damage
  > The pilot's inadequate in-flight decision, and his failure to maintain aircraft control which resulted in continued VFR flight into IMC and the subsequent collision with trees during approach.
- [NTSB ANC04FA021](https://openairdocs.org/ntsb/ANC04FA021.md): Beech J35 · Pensacola, FL · Accident · 1 fatal · Field investigation · Final report · Feb 12, 2004 · N8389D · Destroyed
  > The pilot's improper decision to conduct flight that exceeded his demonstrated skills/ability. Also causal was his failure to properly execute the instrument approach. Contributing factors were low ceiling, fog, and the pilot's lack of the appropriate…
- [NTSB LAX04CA121](https://openairdocs.org/ntsb/LAX04CA121.md): Bell 47-G3B2 · Salome, AZ · Accident · No injuries · Data collection · Final report · Feb 11, 2004 · N8AG · Substantial damage
  > the pilot's failure to maintain an adequate clearance from trees while approaching the landing zone.
- [NTSB NYC04LA071](https://openairdocs.org/ntsb/NYC04LA071.md): Piper PA-32-260 · Collegeville, PA · Accident · No injuries · Limited investigation · Final report · Feb 9, 2004 · N1563X · Substantial damage
  > The pilot's failure to maintain clearance from trees during approach to the runway. Factors in the accident were the dark night and snowbank.
- [NTSB CHI04LA064](https://openairdocs.org/ntsb/CHI04LA064.md): Piper PA-28R-200 · Lone Rock, WI · Accident · Minor injuries · Limited investigation · Final report · Feb 7, 2004 · N5039S · Substantial damage
  > The pilot's continued flight into icing conditions resulting in ice accretion on the wing and his failure to maintain airspeed resulting in a stall.
- [NTSB LAX04LA111](https://openairdocs.org/ntsb/LAX04LA111.md): Cessna T210L · Goodyear, AZ · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 2004 · N2234S · Substantial damage
  > The pilot's inadequate fuel consumption calculations and in-flight planning/decision, which resulted in fuel exhaustion.
- [NTSB LAX04CA115](https://openairdocs.org/ntsb/LAX04CA115.md): Piper PA-28-161 · Placerville, CA · Accident · No injuries · Data collection · Final report · Jan 30, 2004 · N28385 · Substantial damage
  > the pilot's failure to attain a proper glide path during the final approach and delayed go-around, resulting in an undershoot of the runway. The inadequate supervision of the flight and flight instructor's delayed remedial action was also causal.
- [NTSB SEA04LA038](https://openairdocs.org/ntsb/SEA04LA038.md): Cessna 172N · Rigby, ID · Accident · Serious injuries · Limited investigation · Final report · Jan 28, 2004 · N734CB · Substantial damage
  > The flight instructor's failure to follow procedures, i.e., operating the non-icing certified aircraft in known icing conditions contrary to the pilot operators handbook which resulted in ice accretion and ultimately a stall and loss of control in flight.…
- [NTSB CHI04LA061](https://openairdocs.org/ntsb/CHI04LA061.md): Aeronca 7AC · Prairieville, MI · Accident · Serious injuries · Limited investigation · Final report · Jan 24, 2004 · N1087E · Substantial damage
  > The pilot's failure to maintain altitude/clearance from the transmission wires during final approach. Factors to the accident were the unmarked transmission wires and their support poles.
- [NTSB DEN04LA040](https://openairdocs.org/ntsb/DEN04LA040.md): Beech A36 · Farmington, NM · Accident · Serious injuries · Limited investigation · Final report · Jan 23, 2004 · N8240U · Substantial damage
  > the pilot's improper in-flight planning/decision making and his failure to maintain adequate airspeed which resulted in fuel starvation/exhaustion and a stall spin.
- [NTSB LAX04FA096](https://openairdocs.org/ntsb/LAX04FA096.md): Cessna 172K · Grass Valley, CA · Accident · 2 fatal · Field investigation · Final report · Jan 20, 2004 · N99LR · Destroyed
  > the pilot's continued visual flight into instrument meteorological conditions and failure to maintain an adequate terrain/object clearance altitude. Also causal was the pilot's improper in-flight decision to return to the origin airport in the face of…
- [NTSB MIA04FA045](https://openairdocs.org/ntsb/MIA04FA045.md): Piper PA-28-181 · Fort Pierce, FL · Accident · 2 fatal · Field investigation · Final report · Jan 19, 2004 · N298PA · Destroyed
  > The flight instructor's failure to comply with the instrument approach procedure in that he descended prematurely below decision height resulting in an in-flight collision with trees, power lines and the ground. Contributing factors were the dark night light…
- [NTSB MIA04FA043](https://openairdocs.org/ntsb/MIA04FA043.md): Piper PA-30 · Clearwater, FL · Accident · 1 fatal · Field investigation · Final report · Jan 17, 2004 · N8735Y · 2 aircraft · Substantial damage
  > The failure of both pilots to maintain adequate visual lookout while entering the traffic pattern (downwind leg) at an uncontrolled airport resulting in a midair collision. inadvertent stall, and in-flight collision with terrain.
- [NTSB NYC04LA067](https://openairdocs.org/ntsb/NYC04LA067.md): Cessna 421 · Ravenna, OH · Accident · No injuries · Limited investigation · Final report · Jan 14, 2004 · N300FB · Substantial damage
  > The pilot's failure to maintain airspeed, which resulted in an inadvertent stall and subsequent hard landing. A factor in the accident was degraded aircraft performance due to the airframe ice accumulation.

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

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

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