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

## Cases, newest first

- [NTSB UNK64X2992](https://openairdocs.org/ntsb/UNK64X2992.md): Piper PA18A · La Verne, CA · Accident · No injuries · Closed · Jul 23, 1964 · N7097D · Substantial damage
- [NTSB UNK64X2931](https://openairdocs.org/ntsb/UNK64X2931.md): Piper PA22 · Medina, OH · Accident · Minor injuries · Closed · Jul 19, 1964 · N5341Z · Destroyed
- [NTSB UNK64X2929](https://openairdocs.org/ntsb/UNK64X2929.md): Cessna 172D · Washington, IN · Accident · No injuries · Closed · Jul 19, 1964 · N2723U · Substantial damage
- [NTSB UNK64X2926](https://openairdocs.org/ntsb/UNK64X2926.md): Ercoure 415C · Hanover, NJ · Accident · No injuries · Closed · Jul 19, 1964 · N99288 · Substantial damage
- [NTSB UNK64X2924](https://openairdocs.org/ntsb/UNK64X2924.md): Luscombe 8A · Lainsburg, MI · Accident · Minor injuries · Closed · Jul 19, 1964 · N2586K · Substantial damage
- [NTSB UNK64X2920](https://openairdocs.org/ntsb/UNK64X2920.md): Cessna 140 · Selma, CA · Accident · No injuries · Closed · Jul 19, 1964 · N77265 · Substantial damage
- [NTSB UNK64X2919](https://openairdocs.org/ntsb/UNK64X2919.md): Cessna 195 · Tinley Park, IL · Accident · No injuries · Closed · Jul 19, 1964 · N3433V · Destroyed
- [NTSB UNK64X2918](https://openairdocs.org/ntsb/UNK64X2918.md): Aeronca 11AC · Lebanon, IN · Accident · No injuries · Closed · Jul 19, 1964 · N9736E · Substantial damage
- [NTSB UNK64X2896](https://openairdocs.org/ntsb/UNK64X2896.md): Cessna 172 · Fresno, CA · Accident · No injuries · Closed · Jul 18, 1964 · N6268E · Substantial damage
- [NTSB UNK64X2891](https://openairdocs.org/ntsb/UNK64X2891.md): Douglas DC-7 · Richmond, VA · Accident · Minor injuries · Closed · Jul 17, 1964 · N809D · Substantial damage
- [NTSB UNK64X2888](https://openairdocs.org/ntsb/UNK64X2888.md): Beechcraft 35A33 · Int L Falls, MN · Accident · Serious injuries · Closed · Jul 17, 1964 · N494T · Substantial damage
- [NTSB UNK64X2884](https://openairdocs.org/ntsb/UNK64X2884.md): Piper PA-28 · Vale, OR · Accident · 2 fatal · Closed · Jul 17, 1964 · N5139W · Destroyed
- [NTSB UNK64X2880](https://openairdocs.org/ntsb/UNK64X2880.md): Globe Swift · Shenandoah, VA · Accident · Minor injuries · Closed · Jul 17, 1964 · N3330K · Substantial damage
- [NTSB UNK64X2873](https://openairdocs.org/ntsb/UNK64X2873.md): Boeing A75 · Webb, MS · Accident · No injuries · Closed · Jul 17, 1964 · N51420 · Substantial damage
- [NTSB UNK64X2805](https://openairdocs.org/ntsb/UNK64X2805.md): Beechcraft 23 · Springer, NM · Accident · Minor injuries · Closed · Jul 13, 1964 · N2395Z · Destroyed
- [NTSB UNK64X2789](https://openairdocs.org/ntsb/UNK64X2789.md): Piper PA28 · Golden Pond, KY · Accident · Minor injuries · Closed · Jul 12, 1964 · N5256W · Destroyed
- [NTSB UNK64X2781](https://openairdocs.org/ntsb/UNK64X2781.md): Piper PA-24 · W Yellowstone, MT · Accident · 1 fatal · Closed · Jul 12, 1964 · N6002P · Destroyed
- [NTSB UNK64X2779](https://openairdocs.org/ntsb/UNK64X2779.md): Piper PA22 · Springfield, MO · Accident · 1 fatal · Closed · Jul 12, 1964 · N2948Z · Destroyed
- [NTSB UNK64X2778](https://openairdocs.org/ntsb/UNK64X2778.md): Bellanca 14132 · Belle Fourche, SD · Accident · 1 fatal · Closed · Jul 12, 1964 · N74350 · Substantial damage
- [NTSB UNK64X2777](https://openairdocs.org/ntsb/UNK64X2777.md): Cessna 172E · Milpitas, CA · Accident · 1 fatal · Closed · Jul 12, 1964 · N5554T · Destroyed
- [NTSB UNK64X2766](https://openairdocs.org/ntsb/UNK64X2766.md): Beechcraft G17S · Danville, KY · Accident · No injuries · Closed · Jul 11, 1964 · N333 · Destroyed
- [NTSB UNK64X2765](https://openairdocs.org/ntsb/UNK64X2765.md): Champion 7FC · Concord, CA · Accident · No injuries · Closed · Jul 11, 1964 · N7548E · Substantial damage
- [NTSB UNK64X2764](https://openairdocs.org/ntsb/UNK64X2764.md): Piper PA22 · Mukwonago, WI · Accident · Minor injuries · Closed · Jul 11, 1964 · N2713D · Substantial damage
- [NTSB UNK64X2750](https://openairdocs.org/ntsb/UNK64X2750.md): Cessna 150 · Ambler, PA · Accident · Minor injuries · Closed · Jul 10, 1964 · N7969E · Destroyed
- [NTSB UNK64X2747](https://openairdocs.org/ntsb/UNK64X2747.md): Aeronca 7ACS · Kenmore, WA · Accident · No injuries · Closed · Jul 10, 1964 · N82554 · Substantial damage
- [NTSB UNK64X2732](https://openairdocs.org/ntsb/UNK64X2732.md): Piper PA24 · Lake Village, AR · Accident · No injuries · Closed · Jul 9, 1964 · N8312P · Substantial damage
- [NTSB UNK64X2725](https://openairdocs.org/ntsb/UNK64X2725.md): Cessna 120 · Laytonsville, MD · Accident · Minor injuries · Closed · Jul 9, 1964 · N2714N · Destroyed
- [NTSB UNK64X2724](https://openairdocs.org/ntsb/UNK64X2724.md): Cessna 150 · Minerva, OH · Accident · No injuries · Closed · Jul 9, 1964 · N7990E · Substantial damage
- [NTSB UNK64X2711](https://openairdocs.org/ntsb/UNK64X2711.md): Cessna 182 · Kremmling, CO · Accident · No injuries · Closed · Jul 8, 1964 · N7107E · Substantial damage
- [NTSB UNK64X2709](https://openairdocs.org/ntsb/UNK64X2709.md): Piper PA23 · Burbank, CA · Accident · No injuries · Closed · Jul 8, 1964 · N5151Y · Substantial damage
- [NTSB UNK64X2699](https://openairdocs.org/ntsb/UNK64X2699.md): Cessna 150 · El Monte, CA · Accident · No injuries · Closed · Jul 7, 1964 · N7091X · Substantial damage
- [NTSB UNK64X2694](https://openairdocs.org/ntsb/UNK64X2694.md): Aeronca 7AC · Ramsey, IN · Accident · No injuries · Closed · Jul 7, 1964 · N81611 · Substantial damage
- [NTSB UNK64X2688](https://openairdocs.org/ntsb/UNK64X2688.md): Beechcraft K35 · Creede, CO · Accident · Minor injuries · Closed · Jul 6, 1964 · N5895 · Destroyed
- [NTSB UNK64X2686](https://openairdocs.org/ntsb/UNK64X2686.md): Mooney MK20 · Rock Springs, WY · Accident · No injuries · Closed · Jul 6, 1964 · N851B · Substantial damage
- [NTSB UNK64X2683](https://openairdocs.org/ntsb/UNK64X2683.md): Piper PA18 · Fredericksburg, VA · Accident · Minor injuries · Closed · Jul 6, 1964 · N999D · Substantial damage
- [NTSB UNK64X2671](https://openairdocs.org/ntsb/UNK64X2671.md): Cessna 205 · Riverside, CA · Accident · 2 fatal · Closed · Jul 5, 1964 · N8281Z · Destroyed
- [NTSB UNK64X2670](https://openairdocs.org/ntsb/UNK64X2670.md): Cessna 180 · Crystal, MN · Accident · Minor injuries · Closed · Jul 5, 1964 · N9171T · Destroyed
- [NTSB UNK64X2655](https://openairdocs.org/ntsb/UNK64X2655.md): Piper J3C · Yolo, CA · Accident · No injuries · Closed · Jul 5, 1964 · N6515H · Substantial damage
- [NTSB UNK64X2647](https://openairdocs.org/ntsb/UNK64X2647.md): Brantly B2B · Lakewood, CO · Accident · No injuries · Closed · Jul 4, 1964 · N2194U · Destroyed
- [NTSB UNK64X2620](https://openairdocs.org/ntsb/UNK64X2620.md): Aeronca 7AC · Burnet, TX · Accident · No injuries · Closed · Jul 3, 1964 · N85142 · Substantial damage
- [NTSB UNK64X2585](https://openairdocs.org/ntsb/UNK64X2585.md): Beech A35 · Nantucket, MA · Accident · 4 fatal · Closed · Jun 30, 1964 · N782B · Destroyed
- [NTSB UNK64X2571](https://openairdocs.org/ntsb/UNK64X2571.md): Cessna 182 · Tucson, AZ · Accident · No injuries · Closed · Jun 29, 1964 · N3616U · Substantial damage
- [NTSB UNK64X2534](https://openairdocs.org/ntsb/UNK64X2534.md): Patt Read PRG1 · Lamesa, TX · Accident · No injuries · Closed · Jun 28, 1964 · N14Y · Substantial damage
- [NTSB UNK64X2524](https://openairdocs.org/ntsb/UNK64X2524.md): Cessna 180A · South Naknek, AK · Accident · No injuries · Closed · Jun 27, 1964 · N9587B · Destroyed
- [NTSB UNK64X2498](https://openairdocs.org/ntsb/UNK64X2498.md): Taylorcraft L2 · Redlands, CA · Accident · Minor injuries · Closed · Jun 26, 1964 · N63389 · Destroyed
- [NTSB UNK64X2492](https://openairdocs.org/ntsb/UNK64X2492.md): Cessna 172P · Anapra, NM · Accident · Minor injuries · Closed · Jun 26, 1964 · N8538X · Substantial damage
- [NTSB UNK64X2487](https://openairdocs.org/ntsb/UNK64X2487.md): Douglas DC-8 · Cleveland, OH · Incident · No injuries · Closed · Jun 26, 1964 · N8015U · Minor damage
- [NTSB UNK64X2484](https://openairdocs.org/ntsb/UNK64X2484.md): Bell 47G · Ord, NE · Accident · Minor injuries · Closed · Jun 25, 1964 · N935B · Destroyed
- [NTSB UNK64X2479](https://openairdocs.org/ntsb/UNK64X2479.md): Piper PA28 · Fabens, TX · Accident · No injuries · Closed · Jun 25, 1964 · N6036W · Substantial damage
- [NTSB UNK64X2475](https://openairdocs.org/ntsb/UNK64X2475.md): Cessna 182 · Van Nuys, CA · Accident · No injuries · Closed · Jun 25, 1964 · N8704X · Substantial damage

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

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

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