# 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 360 of 420 · 20,996 cases

## Cases, newest first

- [NTSB FTW69F0460](https://openairdocs.org/ntsb/FTW69F0460.md): Cessna 150 · Garland, TX · Accident · No injuries · Closed · Apr 20, 1969 · N4310U · Substantial damage
- [NTSB DIA69D0203](https://openairdocs.org/ntsb/DIA69D0203.md): Cessna 150 · Dover, DE · Accident · No injuries · Closed · Apr 18, 1969 · N8946S · Substantial damage
- [NTSB CHI69F0632](https://openairdocs.org/ntsb/CHI69F0632.md): Cessna 150 · Youngstown, OH · Accident · No injuries · Closed · Apr 16, 1969 · N50550 · Destroyed
- [NTSB DEN69A0041](https://openairdocs.org/ntsb/DEN69A0041.md): Aeronca S0-58B · Questa, NM · Accident · 1 fatal · Closed · Apr 14, 1969 · N50782 · Destroyed
- [NTSB SEA69D0216](https://openairdocs.org/ntsb/SEA69D0216.md): Cessna 210G · Palouse, WA · Accident · No injuries · Closed · Apr 13, 1969 · N5918F · Substantial damage
- [NTSB MIA69A0066](https://openairdocs.org/ntsb/MIA69A0066.md): Piper PA-28 · Greeneville, TN · Accident · 1 fatal · Closed · Apr 13, 1969 · N5793F · Destroyed
- [NTSB MIA69A0065](https://openairdocs.org/ntsb/MIA69A0065.md): Bellanca 17-30 · Daytona Beach, FL · Accident · 2 fatal · Closed · Apr 12, 1969 · N4868V · Destroyed
- [NTSB SEA69F0226](https://openairdocs.org/ntsb/SEA69F0226.md): Cessna 150H · Fall City, WA · Accident · Minor injuries · Closed · Apr 10, 1969 · N6984S · Substantial damage
- [NTSB SEA69F0257](https://openairdocs.org/ntsb/SEA69F0257.md): Beech D17S · Aurora, OR · Accident · Minor injuries · Closed · Apr 7, 1969 · N1192V · Substantial damage
- [NTSB OAK70D0001](https://openairdocs.org/ntsb/OAK70D0001.md): Cessna 150 · Lincoln, CA · Accident · No injuries · Closed · Apr 7, 1969 · N7720F · Substantial damage
- [NTSB MKC69D0400](https://openairdocs.org/ntsb/MKC69D0400.md): Beech V35 · Sac City, IA · Accident · No injuries · Closed · Apr 7, 1969 · N5727V · Substantial damage
- [NTSB MKC69A0054](https://openairdocs.org/ntsb/MKC69A0054.md): Cessna 172E · Tarkio, MO · Accident · 1 fatal · Closed · Apr 7, 1969 · N5716T · Destroyed
- [NTSB CHI69A0085](https://openairdocs.org/ntsb/CHI69A0085.md): Aeronca 11AC · Alto, MI · Accident · 1 fatal · Closed · Apr 7, 1969 · N9674E · Destroyed
- [NTSB DIA69F0176](https://openairdocs.org/ntsb/DIA69F0176.md): Alon A-2 · Jacksonville, NC · Accident · No injuries · Closed · Apr 5, 1969 · N5475E · Substantial damage
- [NTSB OAK69D0278](https://openairdocs.org/ntsb/OAK69D0278.md): Piper PA-25 · Creston, CA · Accident · Minor injuries · Closed · Apr 4, 1969 · N7452Z · Destroyed
- [NTSB FTW69D0445](https://openairdocs.org/ntsb/FTW69D0445.md): Piper PA-32 · Midland, TX · Accident · No injuries · Closed · Apr 4, 1969 · N3975W · Substantial damage
- [NTSB MIA69F0443](https://openairdocs.org/ntsb/MIA69F0443.md): Taylorcraft BC12-D · Summerville, SC · Accident · No injuries · Closed · Apr 3, 1969 · N95233 · Substantial damage
- [NTSB FTW69D0422](https://openairdocs.org/ntsb/FTW69D0422.md): Cessna 140 · Weatherford, OK · Accident · No injuries · Closed · Apr 3, 1969 · N77053 · Substantial damage
- [NTSB CHI69F0550](https://openairdocs.org/ntsb/CHI69F0550.md): Piper PA-28 · Marysville, OH · Accident · No injuries · Closed · Apr 3, 1969 · N150SU · Substantial damage
- [NTSB FTW69F0461](https://openairdocs.org/ntsb/FTW69F0461.md): Aero Comdr 560A · Burleson, TX · Accident · No injuries · Closed · Apr 2, 1969 · N919VC · Substantial damage
- [NTSB MIA69A0060](https://openairdocs.org/ntsb/MIA69A0060.md): Piper PA-23 · Pensacola, FL · Accident · No injuries · Closed · Mar 31, 1969 · N6237Y · Substantial damage
- [NTSB ANC69D0122](https://openairdocs.org/ntsb/ANC69D0122.md): Piper J3C-65 · Anchorage, AK · Accident · Minor injuries · Closed · Mar 31, 1969 · N88472 · Substantial damage
- [NTSB FTW69F0478](https://openairdocs.org/ntsb/FTW69F0478.md): Ercoupe 415-C · Cleveland, TX · Accident · No injuries · Closed · Mar 30, 1969 · N94399 · Substantial damage
- [NTSB ANC70F0019](https://openairdocs.org/ntsb/ANC70F0019.md): Hiller UH-12E · Barrow, AK · Accident · Minor injuries · Closed · Mar 28, 1969 · N9761C · Destroyed
- [NTSB OAK69D0262](https://openairdocs.org/ntsb/OAK69D0262.md): Cessna 170B · Chowchilla, CA · Accident · Minor injuries · Closed · Mar 26, 1969 · N2921D · Substantial damage
- [NTSB LAX69D0307](https://openairdocs.org/ntsb/LAX69D0307.md): Piper PA-25 · Taft, CA · Accident · No injuries · Closed · Mar 26, 1969 · N7623Z · Substantial damage
- [NTSB SEA69D0207](https://openairdocs.org/ntsb/SEA69D0207.md): Beech A23 · Tacoma, WA · Accident · No injuries · Closed · Mar 25, 1969 · N1472L · Substantial damage
- [NTSB MIA69I0057](https://openairdocs.org/ntsb/MIA69I0057.md): Douglas DC-8 · Tampa, FL · Incident · No injuries · Closed · Mar 24, 1969 · N813E · Minor damage
- [NTSB NYC69D0380](https://openairdocs.org/ntsb/NYC69D0380.md): Luscombe 8E · Dexter, ME · Accident · No injuries · Closed · Mar 23, 1969 · N2618K · Substantial damage
- [NTSB CHI69F0554](https://openairdocs.org/ntsb/CHI69F0554.md): Cessna 150H · Dodgeville, WI · Accident · No injuries · Closed · Mar 23, 1969 · N6620S · Substantial damage
- [NTSB CHI69D0608](https://openairdocs.org/ntsb/CHI69D0608.md): Piper PA-22 · Midlothian, IL · Accident · No injuries · Closed · Mar 23, 1969 · N3413Z · Substantial damage
- [NTSB SEA69A0050](https://openairdocs.org/ntsb/SEA69A0050.md): Cessna 172I · Spokane, WA · Accident · 3 fatal · Closed · Mar 22, 1969 · N8497L · Destroyed
- [NTSB FTW69A0063](https://openairdocs.org/ntsb/FTW69A0063.md): Beech 56TC · San Antonio, TX · Accident · 5 fatal · Closed · Mar 22, 1969 · N5488U · Destroyed
- [NTSB DIA69F0161](https://openairdocs.org/ntsb/DIA69F0161.md): Piper J3C-65 · Edgewater, MD · Accident · No injuries · Closed · Mar 22, 1969 · N98224 · Destroyed
- [NTSB FTW69D0425](https://openairdocs.org/ntsb/FTW69D0425.md): Cessna 210D · Patterson, LA · Accident · Minor injuries · Closed · Mar 21, 1969 · N3808Y · Destroyed
- [NTSB CHI69F0538](https://openairdocs.org/ntsb/CHI69F0538.md): Globe GC-1B · Brohman, MI · Accident · Serious injuries · Closed · Mar 20, 1969 · N80581 · Destroyed
- [NTSB MKC69A0053](https://openairdocs.org/ntsb/MKC69A0053.md): Cessna 150H · Kansas City, KS · Accident · 3 fatal · Closed · Mar 19, 1969 · N22790 · 2 aircraft · Destroyed
- [NTSB CHI69F0549](https://openairdocs.org/ntsb/CHI69F0549.md): Piper PA-24 · Joliet, IL · Accident · Serious injuries · Closed · Mar 17, 1969 · N6024P · Destroyed
- [NTSB NYC69A0088](https://openairdocs.org/ntsb/NYC69A0088.md): Beech 35 · Medford, NJ · Accident · 3 fatal · Closed · Mar 16, 1969 · N3104V · Destroyed
- [NTSB LAX69A0054](https://openairdocs.org/ntsb/LAX69A0054.md): Piper PA-23 · Costa Mesa, CA · Accident · 2 fatal · Closed · Mar 16, 1969 · N4308P · Destroyed
- [NTSB CHI69F0536](https://openairdocs.org/ntsb/CHI69F0536.md): Beech C35 · Rockford, IL · Accident · No injuries · Closed · Mar 16, 1969 · N5856C · Substantial damage
- [NTSB DIA69D0157](https://openairdocs.org/ntsb/DIA69D0157.md): Maule M-4 · Lillington, NC · Accident · Minor injuries · Closed · Mar 15, 1969 · N4731T · Substantial damage
- [NTSB DEN69F0206](https://openairdocs.org/ntsb/DEN69F0206.md): Luscombe 8A · Sedalia, CO · Accident · No injuries · Closed · Mar 15, 1969 · N1993B · Substantial damage
- [NTSB CHI69D0596](https://openairdocs.org/ntsb/CHI69D0596.md): Cessna 182 · Indianapolis, IN · Accident · No injuries · Closed · Mar 15, 1969 · N2890R · Substantial damage
- [NTSB CHI69D0544](https://openairdocs.org/ntsb/CHI69D0544.md): Beech A23-19 · Waukegan, IL · Accident · No injuries · Closed · Mar 15, 1969 · N4771J · Substantial damage
- [NTSB MIA69D0415](https://openairdocs.org/ntsb/MIA69D0415.md): Piper PA-22 · Kissimmee, FL · Accident · Minor injuries · Closed · Mar 14, 1969 · N3266B · Destroyed
- [NTSB FTW69F0401](https://openairdocs.org/ntsb/FTW69F0401.md): Beech S35 · New Orleans, LA · Accident · Minor injuries · Closed · Mar 13, 1969 · N5601K · Substantial damage
- [NTSB ANC69A0045](https://openairdocs.org/ntsb/ANC69A0045.md): Dehaviland DHC-6 · Minchumina, AK · Accident · 1 fatal · Closed · Mar 13, 1969 · N4901 · Destroyed
- [NTSB MKC69D0374](https://openairdocs.org/ntsb/MKC69D0374.md): Piper PA-28 · Perry, IA · Accident · No injuries · Closed · Mar 12, 1969 · N4886L · Substantial damage
- [NTSB MKC69F0339](https://openairdocs.org/ntsb/MKC69F0339.md): Piper PA-28 · Iowa City, IA · Accident · No injuries · Closed · Mar 9, 1969 · N6426W · Substantial damage

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

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

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.