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

## Cases, newest first

- [NTSB MIA69F0271](https://openairdocs.org/ntsb/MIA69F0271.md): Beech A23-19 · West Columbia, SC · Accident · No injuries · Closed · Oct 25, 1968 · N5081T · Substantial damage
- [NTSB FTW69D0286](https://openairdocs.org/ntsb/FTW69D0286.md): Cessna 120 · Garland, TX · Accident · No injuries · Closed · Oct 25, 1968 · N76690 · Substantial damage
- [NTSB FTW69D0272](https://openairdocs.org/ntsb/FTW69D0272.md): Cessna 182 · Labadieville, LA · Accident · No injuries · Closed · Oct 25, 1968 · N3261S · Substantial damage
- [NTSB FTW69A0029](https://openairdocs.org/ntsb/FTW69A0029-201691.md): Beech D55 · Monahans, TX · Accident · 2 fatal · Closed · Oct 25, 1968 · N87T · Destroyed
- [NTSB MIA69F0354](https://openairdocs.org/ntsb/MIA69F0354.md): Convair BT-13A · Stone Mtn, GA · Accident · No injuries · Closed · Oct 24, 1968 · N66703 · Substantial damage
- [NTSB DIA69F0094](https://openairdocs.org/ntsb/DIA69F0094.md): Cessna 401 · Hopewell, VA · Accident · Serious injuries · Closed · Oct 24, 1968 · N348E · Destroyed
- [NTSB DIA69D0089](https://openairdocs.org/ntsb/DIA69D0089.md): Beech A23 · Piney Point, MD · Accident · No injuries · Closed · Oct 23, 1968 · N2379Z · Substantial damage
- [NTSB MKC69F0237](https://openairdocs.org/ntsb/MKC69F0237.md): Bensen B8-M · Anoka, MN · Accident · No injuries · Closed · Oct 21, 1968 · N1802 · Substantial damage
- [NTSB NYC69D0211](https://openairdocs.org/ntsb/NYC69D0211.md): Piper PA-28 · Middletown, NY · Accident · No injuries · Closed · Oct 20, 1968 · N6335W · Substantial damage
- [NTSB MIA69F0197](https://openairdocs.org/ntsb/MIA69F0197.md): Piper J3C-65 · Headland, AL · Accident · Serious injuries · Closed · Oct 20, 1968 · N92043 · Substantial damage
- [NTSB MIA69D0219](https://openairdocs.org/ntsb/MIA69D0219.md): Schleicher AS-K13 · Homestead, FL · Accident · Minor injuries · Closed · Oct 19, 1968 · N1618 · Substantial damage
- [NTSB SEA69A0024](https://openairdocs.org/ntsb/SEA69A0024.md): Cessna 310C · Burley, ID · Accident · 1 fatal · Closed · Oct 17, 1968 · N1761H · Substantial damage
- [NTSB OAK69A0022](https://openairdocs.org/ntsb/OAK69A0022.md): Mooney M20F · Cotage Grove, OR · Accident · 3 fatal · Closed · Oct 17, 1968 · N78889 · Destroyed
- [NTSB CHI69D0284](https://openairdocs.org/ntsb/CHI69D0284.md): Beech A23-19 · Roselle, IL · Accident · No injuries · Closed · Oct 17, 1968 · N4787J · Substantial damage
- [NTSB DEN69F0132](https://openairdocs.org/ntsb/DEN69F0132.md): Cessna 182A · Cedar City, UT · Accident · No injuries · Closed · Oct 16, 1968 · N4968D · Substantial damage
- [NTSB MKC69F0221](https://openairdocs.org/ntsb/MKC69F0221.md): Cessna 172 · Wakeeney, KS · Accident · Serious injuries · Closed · Oct 15, 1968 · N6064A · Substantial damage
- [NTSB LAX69F0159](https://openairdocs.org/ntsb/LAX69F0159.md): Nardi FN333 · Pomona, CA · Accident · Serious injuries · Closed · Oct 15, 1968 · N913NS · Substantial damage
- [NTSB CHI69F0345](https://openairdocs.org/ntsb/CHI69F0345.md): Bellanca 17-30 · Watervliet, MI · Accident · Minor injuries · Closed · Oct 15, 1968 · N4893V · Substantial damage
- [NTSB CHI69D0313](https://openairdocs.org/ntsb/CHI69D0313.md): Cessna 170B · Eureka, MI · Accident · No injuries · Closed · Oct 15, 1968 · N2788D · Substantial damage
- [NTSB FTW69F0254](https://openairdocs.org/ntsb/FTW69F0254.md): Piper PA-28 · Shallowater, TX · Accident · No injuries · Closed · Oct 13, 1968 · N6826W · Substantial damage
- [NTSB DIA69F0090](https://openairdocs.org/ntsb/DIA69F0090.md): Piper PA-28 · Linthicum, MD · Accident · No injuries · Closed · Oct 13, 1968 · N6274W · Destroyed
- [NTSB CHI69F0317](https://openairdocs.org/ntsb/CHI69F0317.md): Cessna 172D · Shawano, WI · Accident · Minor injuries · Closed · Oct 13, 1968 · N2522Y · Destroyed
- [NTSB ANC69D0071](https://openairdocs.org/ntsb/ANC69D0071.md): Piper PA-14 · Anchorage, AK · Accident · Minor injuries · Closed · Oct 13, 1968 · N5142H · Substantial damage
- [NTSB LAX69D0165](https://openairdocs.org/ntsb/LAX69D0165.md): Cessna 150 · Hesperia, CA · Accident · No injuries · Closed · Oct 12, 1968 · N4270U · Substantial damage
- [NTSB CHI69F0306](https://openairdocs.org/ntsb/CHI69F0306.md): Piper PA-28 · Lombard, IL · Accident · No injuries · Closed · Oct 12, 1968 · N5491W · Destroyed
- [NTSB NYC69D0218](https://openairdocs.org/ntsb/NYC69D0218.md): Helicom SAH100 · Finleyville, PA · Accident · No injuries · Closed · Oct 11, 1968 · N828Z · Substantial damage
- [NTSB NYC69A0045](https://openairdocs.org/ntsb/NYC69A0045.md): Piper PA-23 · Derry, PA · Accident · 2 fatal · Closed · Oct 10, 1968 · N5140Y · Destroyed
- [NTSB FTW69F0250](https://openairdocs.org/ntsb/FTW69F0250.md): Piper PA-24 · Oklahoma Cty, OK · Accident · No injuries · Closed · Oct 10, 1968 · N5809P · Substantial damage
- [NTSB MKC69A0021](https://openairdocs.org/ntsb/MKC69A0021.md): Cessna 195B · Loup City, NE · Accident · 1 fatal · Closed · Oct 9, 1968 · N502E · Destroyed
- [NTSB CHI69F0338](https://openairdocs.org/ntsb/CHI69F0338.md): Piper PA-23 · Painesville, OH · Accident · No injuries · Closed · Oct 9, 1968 · N3297P · Substantial damage
- [NTSB FTW69A0022](https://openairdocs.org/ntsb/FTW69A0022.md): Cessna 172 · Hot Springs, AR · Accident · 4 fatal · Closed · Oct 7, 1968 · N8225U · Destroyed
- [NTSB CHI69A0038](https://openairdocs.org/ntsb/CHI69A0038.md): Piper PA-22 · Hobart, IN · Accident · 1 fatal · Closed · Oct 7, 1968 · N6113D · Destroyed
- [NTSB DIA69A0017](https://openairdocs.org/ntsb/DIA69A0017.md): Lear Jet 23 · Dulles Itl Apt, VA · Accident · No injuries · Closed · Oct 6, 1968 · N430EJ · Substantial damage
- [NTSB NYC69D0233](https://openairdocs.org/ntsb/NYC69D0233.md): Piper PA-24 · Montauk, NY · Accident · No injuries · Closed · Oct 5, 1968 · N5759P · Substantial damage
- [NTSB NYC69D0190](https://openairdocs.org/ntsb/NYC69D0190.md): Champion 7ECA · Bayport, NY · Accident · No injuries · Closed · Oct 5, 1968 · N1876G · Substantial damage
- [NTSB FTW69F0247](https://openairdocs.org/ntsb/FTW69F0247.md): Piper PA-32 · Littlefield, TX · Accident · No injuries · Closed · Oct 5, 1968 · N996PK · Substantial damage
- [NTSB DEN69F0125](https://openairdocs.org/ntsb/DEN69F0125.md): Cessna 150F · Las Cruces, NM · Accident · Serious injuries · Closed · Oct 5, 1968 · N7716F · Substantial damage
- [NTSB ANC69F0085](https://openairdocs.org/ntsb/ANC69F0085.md): Cessna 140 · Willow, AK · Accident · Minor injuries · Closed · Oct 5, 1968 · N2215V · Substantial damage
- [NTSB OAK69D0149](https://openairdocs.org/ntsb/OAK69D0149.md): Cessna 172H · Turlock, CA · Accident · No injuries · Closed · Oct 4, 1968 · N3742R · Substantial damage
- [NTSB FTW69F0245](https://openairdocs.org/ntsb/FTW69F0245.md): Cessna U206 · Blytheville, AR · Accident · No injuries · Closed · Oct 2, 1968 · N3949G · Substantial damage
- [NTSB OAK69D0145](https://openairdocs.org/ntsb/OAK69D0145.md): Cessna 150 · Palo Alto, CA · Accident · No injuries · Closed · Oct 1, 1968 · N4254U · Substantial damage
- [NTSB MIA69D0182](https://openairdocs.org/ntsb/MIA69D0182.md): Mooney M20E · Tarpum Hd, Burkina Faso · Accident · No injuries · Closed · Oct 1, 1968 · N3243F · Substantial damage
- [NTSB NYC69A0043](https://openairdocs.org/ntsb/NYC69A0043.md): Piper PA-24 · Northampton, MA · Accident · No injuries · Closed · Sep 29, 1968 · N8127P · Substantial damage
- [NTSB SEA69D0117](https://openairdocs.org/ntsb/SEA69D0117.md): Beech S35 · Malott, WA · Accident · No injuries · Closed · Sep 28, 1968 · N8802M · Substantial damage
- [NTSB SEA69D0116](https://openairdocs.org/ntsb/SEA69D0116.md): Cessna 150 · Orofino, ID · Accident · No injuries · Closed · Sep 28, 1968 · N8567G · Substantial damage
- [NTSB OAK69A0019](https://openairdocs.org/ntsb/OAK69A0019.md): Lockheed 1649A · Stockton, CA · Accident · No injuries · Closed · Sep 28, 1968 · N8081H · Substantial damage
- [NTSB DIA69A0016](https://openairdocs.org/ntsb/DIA69A0016.md): Douglas DC-7C · Cherry Point, NC · Accident · Serious injuries · Closed · Sep 27, 1968 · N7466 · Destroyed
- [NTSB FTW69D0220](https://openairdocs.org/ntsb/FTW69D0220.md): Cessna 180A · Stroud, OK · Accident · No injuries · Closed · Sep 26, 1968 · N7881A · Substantial damage
- [NTSB FTW69F0241](https://openairdocs.org/ntsb/FTW69F0241.md): Cessna 150 · Stanton, TX · Accident · Serious injuries · Closed · Sep 25, 1968 · N3104J · Destroyed
- [NTSB DIA69A0014](https://openairdocs.org/ntsb/DIA69A0014.md): Dehavilland DH104 · Charlotte, NC · Accident · 2 fatal · Closed · Sep 25, 1968 · N357G · Destroyed

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

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

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