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

## Cases, newest first

- [NTSB UNK64X2472](https://openairdocs.org/ntsb/UNK64X2472.md): Briegleb BG12A · Aspen, CO · Accident · Serious injuries · Closed · Jun 24, 1964 · N9165R · Substantial damage
- [NTSB UNK64X2468](https://openairdocs.org/ntsb/UNK64X2468.md): Piper PA22 · Climax Springs, MO · Accident · No injuries · Closed · Jun 24, 1964 · N2759P · Substantial damage
- [NTSB UNK64X2463](https://openairdocs.org/ntsb/UNK64X2463.md): Beechcraft B35 · Wagoner, OK · Accident · No injuries · Closed · Jun 24, 1964 · N5009C · Substantial damage
- [NTSB UNK64X2457](https://openairdocs.org/ntsb/UNK64X2457.md): Cessna 180C · Togiak, AK · Accident · Serious injuries · Closed · Jun 23, 1964 · N9282T · Substantial damage
- [NTSB UNK64X2454](https://openairdocs.org/ntsb/UNK64X2454.md): Cessna 180B · Fairmont, IL · Accident · Serious injuries · Closed · Jun 23, 1964 · N9101T · Destroyed
- [NTSB UNK64X2449](https://openairdocs.org/ntsb/UNK64X2449.md): Cessna 310 · Nashville, IN · Accident · No injuries · Closed · Jun 23, 1964 · N5226A · Substantial damage
- [NTSB UNK64X2441](https://openairdocs.org/ntsb/UNK64X2441.md): Piper PA22 · San German, PR · Accident · No injuries · Closed · Jun 23, 1964 · N5915Z · Substantial damage
- [NTSB UNK64X2431](https://openairdocs.org/ntsb/UNK64X2431.md): Piper PA24 · Hoopa, CA · Accident · No injuries · Closed · Jun 22, 1964 · N7989P · Substantial damage
- [NTSB UNK64X2430](https://openairdocs.org/ntsb/UNK64X2430.md): Piper J3C · Whitsett, NC · Accident · Serious injuries · Closed · Jun 21, 1964 · N40974 · Substantial damage
- [NTSB UNK64X2424](https://openairdocs.org/ntsb/UNK64X2424.md): Cessna 195 · Palm Beach, FL · Accident · No injuries · Closed · Jun 21, 1964 · N1533D · Substantial damage
- [NTSB UNK64X2417](https://openairdocs.org/ntsb/UNK64X2417.md): Piper J3 · Hazard, KY · Accident · Minor injuries · Closed · Jun 21, 1964 · N15758 · Substantial damage
- [NTSB UNK64X2406](https://openairdocs.org/ntsb/UNK64X2406.md): Cessna 172 · Hampton, NH · Accident · 1 fatal · Closed · Jun 20, 1964 · N4213F · Destroyed
- [NTSB UNK64X2405](https://openairdocs.org/ntsb/UNK64X2405.md): Taylorcraft BC12D · Oneida, TN · Accident · Serious injuries · Closed · Jun 20, 1964 · N43475 · Destroyed
- [NTSB UNK64X2404](https://openairdocs.org/ntsb/UNK64X2404.md): Cessna 182A · Woodland Pk, CO · Accident · 1 fatal · Closed · Jun 20, 1964 · N5989B · Destroyed
- [NTSB UNK64X2402](https://openairdocs.org/ntsb/UNK64X2402.md): Taylorcraft BC12D · Clute, TX · Accident · 1 fatal · Closed · Jun 20, 1964 · N96593 · Destroyed
- [NTSB UNK64X2400](https://openairdocs.org/ntsb/UNK64X2400.md): Cessna 150 · Denver, CO · Accident · No injuries · Closed · Jun 20, 1964 · N7064X · Substantial damage
- [NTSB UNK64X2396](https://openairdocs.org/ntsb/UNK64X2396.md): Beechcraft M23 · Tishomingo, OK · Accident · No injuries · Closed · Jun 20, 1964 · N2329Z · Substantial damage
- [NTSB UNK64X2391](https://openairdocs.org/ntsb/UNK64X2391.md): Piper PA28 · Manley Spgs, AK · Accident · Minor injuries · Closed · Jun 20, 1964 · N5564W · Destroyed
- [NTSB UNK64X2383](https://openairdocs.org/ntsb/UNK64X2383.md): Aero Cmdr 680 · Southhampton, MA · Accident · 2 fatal · Closed · Jun 19, 1964 · N344S · Destroyed
- [NTSB UNK64X2381](https://openairdocs.org/ntsb/UNK64X2381.md): Cessna 172B · Quinter, KS · Accident · 1 fatal · Closed · Jun 19, 1964 · N8130X · Destroyed
- [NTSB UNK64X2376](https://openairdocs.org/ntsb/UNK64X2376.md): Homebuilt · Crawford, NY · Accident · Minor injuries · Closed · Jun 19, 1964 · N177P · Substantial damage
- [NTSB UNK64X2375](https://openairdocs.org/ntsb/UNK64X2375.md): Stinson 1081 · Peoria, IL · Accident · No injuries · Closed · Jun 19, 1964 · N8543K · Substantial damage
- [NTSB UNK64X2372](https://openairdocs.org/ntsb/UNK64X2372.md): Aeronca 15AC · Minneapolis, MN · Accident · Minor injuries · Closed · Jun 19, 1964 · N1203H · Substantial damage
- [NTSB UNK64X2368](https://openairdocs.org/ntsb/UNK64X2368.md): Cessna 182C · El Paso, TX · Accident · No injuries · Closed · Jun 19, 1964 · N9049T · Substantial damage
- [NTSB UNK64X2358](https://openairdocs.org/ntsb/UNK64X2358.md): Cessna 172 · Chicago, IL · Accident · Minor injuries · Closed · Jun 18, 1964 · N7863T · Substantial damage
- [NTSB UNK64X2352](https://openairdocs.org/ntsb/UNK64X2352.md): Piper PA24 · Caliente, NV · Accident · No injuries · Closed · Jun 18, 1964 · N6203P · Substantial damage
- [NTSB UNK64X2348](https://openairdocs.org/ntsb/UNK64X2348.md): Beechcraft N35 · Marion, OH · Accident · No injuries · Closed · Jun 18, 1964 · N9373Y · Substantial damage
- [NTSB UNK64X2280](https://openairdocs.org/ntsb/UNK64X2280.md): Beechcraft D35 · West Bend, WI · Accident · Minor injuries · Closed · Jun 14, 1964 · N2953B · Substantial damage
- [NTSB UNK64X2273](https://openairdocs.org/ntsb/UNK64X2273.md): Cherokee BAM-1 · Amarillo, TX · Accident · Serious injuries · Closed · Jun 13, 1964 · N6113U · Substantial damage
- [NTSB UNK64X2264](https://openairdocs.org/ntsb/UNK64X2264.md): Taylorcraft BC-12D · Ft Richardsn, AK · Accident · No injuries · Closed · Jun 13, 1964 · N29694 · Substantial damage
- [NTSB UNK64X2256](https://openairdocs.org/ntsb/UNK64X2256.md): Piper PA14 · Anchorage, AK · Accident · No injuries · Closed · Jun 13, 1964 · N5129H · Substantial damage
- [NTSB UNK64X2241](https://openairdocs.org/ntsb/UNK64X2241.md): Cessna 210 · Sioux Falls, SD · Accident · Minor injuries · Closed · Jun 12, 1964 · N9428T · Substantial damage
- [NTSB UNK64X2234](https://openairdocs.org/ntsb/UNK64X2234.md): Luscombe 8A · Mcalester, OK · Accident · No injuries · Closed · Jun 11, 1964 · N23047 · Substantial damage
- [NTSB UNK64X2223](https://openairdocs.org/ntsb/UNK64X2223.md): Cessna 172 · Foremost, Canada · Accident · No injuries · Closed · Jun 11, 1964 · N7304A · Substantial damage
- [NTSB UNK64X2188](https://openairdocs.org/ntsb/UNK64X2188.md): Piper PA28 · Medford, NJ · Accident · No injuries · Closed · Jun 8, 1964 · N6075W · Destroyed
- [NTSB UNK64X2177](https://openairdocs.org/ntsb/UNK64X2177.md): Beechcraft 35 · Ludlow, CA · Accident · 3 fatal · Closed · Jun 7, 1964 · N3730N · Destroyed
- [NTSB UNK64X2169](https://openairdocs.org/ntsb/UNK64X2169.md): Cessna 120 · Arlington, TX · Accident · No injuries · Closed · Jun 7, 1964 · N76404 · Substantial damage
- [NTSB UNK64X2167](https://openairdocs.org/ntsb/UNK64X2167.md): Cessna 170A · Roseau, MN · Accident · Minor injuries · Closed · Jun 7, 1964 · N9570A · Substantial damage
- [NTSB UNK64X2155](https://openairdocs.org/ntsb/UNK64X2155.md): Cessna 170B · Newton, KS · Accident · No injuries · Closed · Jun 6, 1964 · N4542C · Substantial damage
- [NTSB UNK64X2154](https://openairdocs.org/ntsb/UNK64X2154.md): Home Built · Yuca Valley, CA · Accident · Minor injuries · Closed · Jun 6, 1964 · N9728Z · Substantial damage
- [NTSB UNK64X2149](https://openairdocs.org/ntsb/UNK64X2149.md): Piper PA11 · Churchs Ferry, ND · Accident · No injuries · Closed · Jun 6, 1964 · N4842M · Substantial damage
- [NTSB UNK64X2145](https://openairdocs.org/ntsb/UNK64X2145.md): Stinson 1082 · Oroville, CA · Accident · No injuries · Closed · Jun 6, 1964 · N9640K · Substantial damage
- [NTSB UNK64X2138](https://openairdocs.org/ntsb/UNK64X2138.md): Fairchild F24 · Egegik, AK · Accident · Serious injuries · Closed · Jun 5, 1964 · N28501 · Substantial damage
- [NTSB UNK64X2125](https://openairdocs.org/ntsb/UNK64X2125.md): Beech 35 · Marine City, MI · Accident · Minor injuries · Closed · Jun 5, 1964 · N2741U · Substantial damage
- [NTSB UNK64X2111](https://openairdocs.org/ntsb/UNK64X2111.md): Piper PA22 · Covington, TN · Accident · Minor injuries · Closed · Jun 4, 1964 · N5125Z · Destroyed
- [NTSB UNK64X2103](https://openairdocs.org/ntsb/UNK64X2103.md): Cessna 140 · Hillsboro, VA · Accident · No injuries · Closed · Jun 4, 1964 · N2298V · Substantial damage
- [NTSB UNK64X2098](https://openairdocs.org/ntsb/UNK64X2098.md): Beechcraft E-18S · Wooster, OH · Accident · 1 fatal · Closed · Jun 3, 1964 · N9921 · Destroyed
- [NTSB UNK64X2094](https://openairdocs.org/ntsb/UNK64X2094.md): Piper PA12 · Egegik, AK · Accident · Minor injuries · Closed · Jun 3, 1964 · N3507M · Substantial damage
- [NTSB UNK64X2059](https://openairdocs.org/ntsb/UNK64X2059.md): Cessna 120 · Rankin, TX · Accident · Minor injuries · Closed · May 31, 1964 · N2560N · Substantial damage
- [NTSB UNK64X2055](https://openairdocs.org/ntsb/UNK64X2055.md): Piper PA28 · Lobos Island, PR · Accident · No injuries · Closed · May 31, 1964 · N7038W · Substantial damage

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

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

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