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

## Cases, newest first

- [NTSB UNK65X0213](https://openairdocs.org/ntsb/UNK65X0213.md): Cessna 195 · Southport, NC · Accident · Serious injuries · Closed · Oct 9, 1964 · N1523D · Destroyed
- [NTSB UNK65X0205](https://openairdocs.org/ntsb/UNK65X0205.md): Piper PA25 · Arvin, CA · Accident · No injuries · Closed · Oct 9, 1964 · N7109Z · Substantial damage
- [NTSB UNK65X0194](https://openairdocs.org/ntsb/UNK65X0194.md): Globe GC1B · Powell, TN · Accident · No injuries · Closed · Oct 8, 1964 · N3767K · Substantial damage
- [NTSB UNK65X0183](https://openairdocs.org/ntsb/UNK65X0183.md): Bellanca 1419 · Pikeville, KY · Accident · No injuries · Closed · Oct 7, 1964 · N6853D · Substantial damage
- [NTSB UNK65X0172](https://openairdocs.org/ntsb/UNK65X0172.md): Aeronca 65C · Dalton, PA · Accident · No injuries · Closed · Oct 7, 1964 · N22392 · Substantial damage
- [NTSB UNK65X0168](https://openairdocs.org/ntsb/UNK65X0168.md): Piper J5A · Stanton, MN · Accident · No injuries · Closed · Oct 6, 1964 · N30849 · Substantial damage
- [NTSB UNK65X0166](https://openairdocs.org/ntsb/UNK65X0166.md): Mooney M20D · Yuba City, CA · Accident · Minor injuries · Closed · Oct 6, 1964 · N6661U · Destroyed
- [NTSB UNK65X0150](https://openairdocs.org/ntsb/UNK65X0150.md): Aero CDR 680 · Charlotte, NC · Accident · 1 fatal · Closed · Oct 4, 1964 · N6271D · Destroyed
- [NTSB UNK65X0138](https://openairdocs.org/ntsb/UNK65X0138.md): Schweizer TG2 · Berlin, VT · Accident · Minor injuries · Closed · Oct 4, 1964 · N49530 · Substantial damage
- [NTSB UNK65X0133](https://openairdocs.org/ntsb/UNK65X0133.md): Hughes 269A · Scottsdale, AZ · Accident · No injuries · Closed · Oct 3, 1964 · N8744F · Substantial damage
- [NTSB UNK65X0128](https://openairdocs.org/ntsb/UNK65X0128.md): Cessna 150 · Alliance, OH · Accident · No injuries · Closed · Oct 3, 1964 · N7098X · Substantial damage
- [NTSB UNK65X0121](https://openairdocs.org/ntsb/UNK65X0121.md): Aeronca L16A · Jefferson, OH · Accident · Minor injuries · Closed · Oct 3, 1964 · N9653H · Substantial damage
- [NTSB UNK64X4199](https://openairdocs.org/ntsb/UNK64X4199.md): Taylorcraft BC12D · Bly, OR · Accident · Serious injuries · Closed · Sep 28, 1964 · N34239 · Destroyed
- [NTSB UNK64X4198](https://openairdocs.org/ntsb/UNK64X4198.md): Piper PA28 · Winfred, MT · Accident · No injuries · Closed · Sep 28, 1964 · N8534W · Destroyed
- [NTSB UNK64X4196](https://openairdocs.org/ntsb/UNK64X4196.md): Schweitzer S65126 · San Jose, CA · Accident · Minor injuries · Closed · Sep 28, 1964 · N3815A · Substantial damage
- [NTSB UNK64X4192](https://openairdocs.org/ntsb/UNK64X4192.md): Beechcraft 95 · Scappoose, OR · Accident · No injuries · Closed · Sep 28, 1964 · N2736Y · Substantial damage
- [NTSB UNK64X4172](https://openairdocs.org/ntsb/UNK64X4172.md): Bell 47G2 · Pomona, CA · Accident · No injuries · Closed · Sep 26, 1964 · N5193B · Substantial damage
- [NTSB UNK64X4167](https://openairdocs.org/ntsb/UNK64X4167.md): Cessna 182 · Hite, UT · Accident · No injuries · Closed · Sep 26, 1964 · N3170U · Substantial damage
- [NTSB UNK64X4165](https://openairdocs.org/ntsb/UNK64X4165.md): Beechcraft M23 · Laytonsville, MD · Accident · No injuries · Closed · Sep 26, 1964 · N23372 · Substantial damage
- [NTSB UNK64X4156](https://openairdocs.org/ntsb/UNK64X4156.md): Cessna 195 · Santa Monica, CA · Accident · No injuries · Closed · Sep 26, 1964 · N3464V · Substantial damage
- [NTSB UNK64X4151](https://openairdocs.org/ntsb/UNK64X4151.md): Beechcraft 55 · Ontario, CA · Accident · Minor injuries · Closed · Sep 26, 1964 · N315M · Destroyed
- [NTSB UNK64X4149](https://openairdocs.org/ntsb/UNK64X4149.md): Cessna 175 · Culver, IN · Accident · Serious injuries · Closed · Sep 25, 1964 · N7196M · Destroyed
- [NTSB UNK64X4125](https://openairdocs.org/ntsb/UNK64X4125.md): Piper PA24 · Robersonville, NC · Accident · No injuries · Closed · Sep 24, 1964 · N8124P · Substantial damage
- [NTSB UNK64X4119](https://openairdocs.org/ntsb/UNK64X4119.md): Boeing PT17 · Pacoima, CA · Accident · No injuries · Closed · Sep 23, 1964 · N1390N · Substantial damage
- [NTSB UNK64X4088](https://openairdocs.org/ntsb/UNK64X4088.md): Luscombe 8E · Sapulpa, OK · Accident · Serious injuries · Closed · Sep 21, 1964 · N2045K · Substantial damage
- [NTSB UNK64X4084](https://openairdocs.org/ntsb/UNK64X4084.md): Cessna 182C · Camp Wood, TX · Accident · No injuries · Closed · Sep 21, 1964 · N8700T · Substantial damage
- [NTSB UNK64X4081](https://openairdocs.org/ntsb/UNK64X4081.md): Champion 7FC · Columbia, IL · Accident · Serious injuries · Closed · Sep 20, 1964 · N9043B · Destroyed
- [NTSB UNK64X4065](https://openairdocs.org/ntsb/UNK64X4065.md): Piper J5 · Oak Harbor, WA · Accident · No injuries · Closed · Sep 20, 1964 · N35021 · Substantial damage
- [NTSB UNK64X4048](https://openairdocs.org/ntsb/UNK64X4048.md): Mooney M20E · Norfolk, VA · Accident · Minor injuries · Closed · Sep 19, 1964 · N69650 · Substantial damage
- [NTSB UNK64X4042](https://openairdocs.org/ntsb/UNK64X4042.md): Fairchild 22C7G · Reno, NV · Accident · No injuries · Closed · Sep 18, 1964 · N14788 · Substantial damage
- [NTSB UNK64X4032](https://openairdocs.org/ntsb/UNK64X4032.md): Boeing B75N1 · Belizoni, MS · Accident · No injuries · Closed · Sep 18, 1964 · N10571 · Substantial damage
- [NTSB UNK64X4030](https://openairdocs.org/ntsb/UNK64X4030.md): Piper PA24 · Block Is, RI · Accident · Minor injuries · Closed · Sep 18, 1964 · N5260P · Substantial damage
- [NTSB UNK64X3996](https://openairdocs.org/ntsb/UNK64X3996.md): Piper J3 · Euless, TX · Accident · No injuries · Closed · Sep 15, 1964 · N3921B · Substantial damage
- [NTSB UNK64X3993](https://openairdocs.org/ntsb/UNK64X3993.md): Piper PA22 · Gaylord, MN · Accident · No injuries · Closed · Sep 15, 1964 · N3265Z · Substantial damage
- [NTSB UNK64X3986](https://openairdocs.org/ntsb/UNK64X3986.md): Cessna 172 · Wheeling, IL · Accident · Minor injuries · Closed · Sep 14, 1964 · N7695T · Substantial damage
- [NTSB UNK64X3972](https://openairdocs.org/ntsb/UNK64X3972.md): Piper PA28 · Roselle, IL · Accident · No injuries · Closed · Sep 13, 1964 · N5085W · Substantial damage
- [NTSB UNK64X3970](https://openairdocs.org/ntsb/UNK64X3970.md): Cessna 140 · Amarillo, TX · Accident · No injuries · Closed · Sep 13, 1964 · N72807 · Destroyed
- [NTSB UNK64X3963](https://openairdocs.org/ntsb/UNK64X3963.md): Luscombe 8A · Wis Rapids, WI · Accident · No injuries · Closed · Sep 13, 1964 · N2704K · Substantial damage
- [NTSB UNK64X3958](https://openairdocs.org/ntsb/UNK64X3958.md): Aeronca 7AC · Springville, NY · Accident · No injuries · Closed · Sep 13, 1964 · N2992E · Substantial damage
- [NTSB UNK64X3957](https://openairdocs.org/ntsb/UNK64X3957.md): Mooney M20 · Waterford, MI · Accident · 3 fatal · Closed · Sep 13, 1964 · N6521B · Destroyed
- [NTSB UNK64X3945](https://openairdocs.org/ntsb/UNK64X3945.md): Piper PA15 · Forestville, NY · Accident · No injuries · Closed · Sep 12, 1964 · N4440H · Substantial damage
- [NTSB UNK64X3915](https://openairdocs.org/ntsb/UNK64X3915.md): Piper PA28 · Martinsburg, PA · Accident · Minor injuries · Closed · Sep 11, 1964 · N5166W · Substantial damage
- [NTSB UNK64X3897](https://openairdocs.org/ntsb/UNK64X3897.md): Cessna 172 · Snohomish, WA · Accident · Minor injuries · Closed · Sep 10, 1964 · N8945B · Substantial damage
- [NTSB UNK64X3883](https://openairdocs.org/ntsb/UNK64X3883.md): Ercoupe 415C · Easton, PA · Accident · Minor injuries · Closed · Sep 9, 1964 · N94396 · Substantial damage
- [NTSB UNK64X3878](https://openairdocs.org/ntsb/UNK64X3878.md): Beechcraft D-18S · Deer River, MN · Accident · 1 fatal · Closed · Sep 8, 1964 · N800UA · Destroyed
- [NTSB UNK64X3866](https://openairdocs.org/ntsb/UNK64X3866.md): Schweizer SGS126 · Coopers Plains, NY · Accident · Serious injuries · Closed · Sep 7, 1964 · N3812A · Substantial damage
- [NTSB UNK64X3859](https://openairdocs.org/ntsb/UNK64X3859.md): Piper PA18 · Highlake, AK · Accident · Minor injuries · Closed · Sep 7, 1964 · N7360D · Substantial damage
- [NTSB UNK64X3858](https://openairdocs.org/ntsb/UNK64X3858.md): Globe Swift GC1B · New Carlisle, OH · Accident · No injuries · Closed · Sep 7, 1964 · N80922 · Substantial damage
- [NTSB UNK64X3838](https://openairdocs.org/ntsb/UNK64X3838.md): Cessna 180 · Houma, LA · Accident · No injuries · Closed · Sep 7, 1964 · N2677Y · Destroyed
- [NTSB UNK64X3836](https://openairdocs.org/ntsb/UNK64X3836.md): Scheibe SF26A · Phillipsburg, KS · Accident · Serious injuries · Closed · Sep 6, 1964 · N1151Q · Substantial damage

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

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

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