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

## Cases, newest first

- [NTSB UNK65X1089](https://openairdocs.org/ntsb/UNK65X1089.md): Beechraft D95 · Groveland, IL · Accident · No injuries · Closed · Dec 22, 1964 · N8613M · Substantial damage
- [NTSB UNK65X1027](https://openairdocs.org/ntsb/UNK65X1027.md): Cessna 120 · Avon, OH · Accident · No injuries · Closed · Dec 16, 1964 · N81068 · Substantial damage
- [NTSB UNK65X1009](https://openairdocs.org/ntsb/UNK65X1009.md): Piper PA28 · Lumberton, NJ · Accident · No injuries · Closed · Dec 14, 1964 · N8743W · Substantial damage
- [NTSB UNK65X0993](https://openairdocs.org/ntsb/UNK65X0993.md): Cessna 182 · Olathe, KS · Accident · No injuries · Closed · Dec 12, 1964 · N2316G · 2 aircraft · Minor damage
- [NTSB UNK65X0987](https://openairdocs.org/ntsb/UNK65X0987.md): Mooney M20B · Emporia, KS · Accident · No injuries · Closed · Dec 12, 1964 · N74587 · Substantial damage
- [NTSB UNK65X0971](https://openairdocs.org/ntsb/UNK65X0971.md): Cessna 172 · Torrance, CA · Accident · 4 fatal · Closed · Dec 10, 1964 · N8022B · Destroyed
- [NTSB UNK65X0962](https://openairdocs.org/ntsb/UNK65X0962.md): Cessna 210 · Sayre, OK · Accident · Serious injuries · Closed · Dec 9, 1964 · N9554T · Substantial damage
- [NTSB UNK65X0956](https://openairdocs.org/ntsb/UNK65X0956.md): Piper PA28 · Waterville, OH · Accident · 1 fatal · Closed · Dec 8, 1964 · N5527W · Destroyed
- [NTSB UNK65X0955](https://openairdocs.org/ntsb/UNK65X0955.md): Cessna 310B · Hopkins, MN · Accident · No injuries · Closed · Dec 8, 1964 · N547M · Substantial damage
- [NTSB UNK65X0940](https://openairdocs.org/ntsb/UNK65X0940.md): Boeing 727 · New York, NY · Incident · No injuries · Closed · Dec 6, 1964 · N1971 · Minor damage
- [NTSB UNK65X0913](https://openairdocs.org/ntsb/UNK65X0913.md): Cessna 206 · Fayetteville, AR · Accident · 4 fatal · Closed · Dec 4, 1964 · N5089U · Destroyed
- [NTSB UNK65X0912](https://openairdocs.org/ntsb/UNK65X0912.md): Cessna 172 · Westherford, TX · Accident · No injuries · Closed · Dec 4, 1964 · N2360U · Substantial damage
- [NTSB UNK65X0906](https://openairdocs.org/ntsb/UNK65X0906.md): Stinson L-5 · Ogana, JA · Accident · Serious injuries · Closed · Dec 2, 1964 · N9879F · Destroyed
- [NTSB UNK65X0890](https://openairdocs.org/ntsb/UNK65X0890.md): Piper PA22 · St Marys, PA · Accident · Serious injuries · Closed · Nov 30, 1964 · N8616C · Destroyed
- [NTSB UNK65X0889](https://openairdocs.org/ntsb/UNK65X0889.md): Cessna 182 · Hilo, HI · Accident · Minor injuries · Closed · Nov 30, 1964 · N3241S · Destroyed
- [NTSB UNK65X0885](https://openairdocs.org/ntsb/UNK65X0885.md): Luscombe 8A · Colony, OK · Accident · No injuries · Closed · Nov 29, 1964 · N71389 · Substantial damage
- [NTSB UNK65X0881](https://openairdocs.org/ntsb/UNK65X0881.md): Beechcraft S35 · Tacoma, WA · Accident · 4 fatal · Closed · Nov 29, 1964 · N5723K · Destroyed
- [NTSB UNK65X0880](https://openairdocs.org/ntsb/UNK65X0880.md): Boeing B-720 · Okla City, OK · Accident · No injuries · Closed · Nov 29, 1964 · N113 · Substantial damage
- [NTSB UNK65X0846](https://openairdocs.org/ntsb/UNK65X0846.md): Piper PA22 · Warren, PA · Accident · Minor injuries · Closed · Nov 26, 1964 · N7302D · Substantial damage
- [NTSB UNK65X0842](https://openairdocs.org/ntsb/UNK65X0842.md): Piper PA-24 · El Dorado, AR · Accident · 1 fatal · Closed · Nov 26, 1964 · N8171P · Destroyed
- [NTSB UNK65X0835](https://openairdocs.org/ntsb/UNK65X0835.md): Cessna 140 · Longmont, CO · Accident · No injuries · Closed · Nov 25, 1964 · N2895N · Substantial damage
- [NTSB UNK65X0834](https://openairdocs.org/ntsb/UNK65X0834.md): Piper PA18 · Marfa, TX · Accident · No injuries · Closed · Nov 25, 1964 · N3994Z · Substantial damage
- [NTSB UNK65X0833](https://openairdocs.org/ntsb/UNK65X0833.md): Beechcraft D18 · Alief, TX · Accident · No injuries · Closed · Nov 25, 1964 · N62R · Substantial damage
- [NTSB UNK65X0830](https://openairdocs.org/ntsb/UNK65X0830.md): Cessna 150C · Santa Monica, CA · Accident · Minor injuries · Closed · Nov 25, 1964 · N1992Z · 2 aircraft · Minor damage
- [NTSB UNK65X0829](https://openairdocs.org/ntsb/UNK65X0829.md): Piper PA-24 · Mars, PA · Accident · Serious injuries · Closed · Nov 25, 1964 · N7334P · Substantial damage
- [NTSB UNK65X0825](https://openairdocs.org/ntsb/UNK65X0825.md): Taylorcraft BC12D · Fishers Ldg, AZ · Accident · Minor injuries · Closed · Nov 25, 1964 · N43726 · Substantial damage
- [NTSB UNK65X0824](https://openairdocs.org/ntsb/UNK65X0824.md): Piper PA24 · Lowake, TX · Accident · No injuries · Closed · Nov 25, 1964 · N7794P · Substantial damage
- [NTSB UNK65X0807](https://openairdocs.org/ntsb/UNK65X0807.md): Luscombe 8A · Gainesville, FL · Accident · 1 fatal · Closed · Nov 23, 1964 · N71619 · Substantial damage
- [NTSB UNK65X0801](https://openairdocs.org/ntsb/UNK65X0801.md): Beechcraft 35-A33 · Lowake, TX · Accident · No injuries · Closed · Nov 22, 1964 · N630V · Substantial damage
- [NTSB UNK65X0800](https://openairdocs.org/ntsb/UNK65X0800.md): Bellanca 260A · Westwego, LA · Accident · No injuries · Closed · Nov 22, 1964 · N8871R · Destroyed
- [NTSB UNK65X0790](https://openairdocs.org/ntsb/UNK65X0790.md): Piper PA24 · Placerville, CA · Accident · Minor injuries · Closed · Nov 22, 1964 · N6986P · Destroyed
- [NTSB UNK65X0774](https://openairdocs.org/ntsb/UNK65X0774.md): Cessna 172 · Lorenzo, TX · Accident · Minor injuries · Closed · Nov 21, 1964 · N8111X · Substantial damage
- [NTSB UNK65X0764](https://openairdocs.org/ntsb/UNK65X0764.md): Piper PA17 · Defiance, OH · Accident · Minor injuries · Closed · Nov 20, 1964 · N4837H · Substantial damage
- [NTSB UNK65X0757](https://openairdocs.org/ntsb/UNK65X0757.md): Argosy AW-650 · Gwinn, MI · Accident · No injuries · Closed · Nov 19, 1964 · N660Z · Substantial damage
- [NTSB UNK65X0742](https://openairdocs.org/ntsb/UNK65X0742.md): Cessna 172E · Kelleys Isld, OH · Accident · 4 fatal · Closed · Nov 16, 1964 · N7758U · Destroyed
- [NTSB UNK65X0732](https://openairdocs.org/ntsb/UNK65X0732.md): Lockheed L-749A · Wichita Kans, KS · Accident · Serious injuries · Closed · Nov 15, 1964 · N6013C · Minor damage
- [NTSB UNK65X0731](https://openairdocs.org/ntsb/UNK65X0731.md): Cessna 172F · Shrewsbury, NJ · Accident · 1 fatal · Closed · Nov 15, 1964 · N8274U · Destroyed
- [NTSB UNK65X0729](https://openairdocs.org/ntsb/UNK65X0729.md): Fairchild F-27 · Las Vegas, NV · Accident · 29 fatal · Closed · Nov 15, 1964 · N745L · Destroyed
- [NTSB UNK65X0728](https://openairdocs.org/ntsb/UNK65X0728.md): Beech C18S · Fairfield, NJ · Accident · 4 fatal · Closed · Nov 15, 1964 · N39Q · Destroyed
- [NTSB UNK65X0714](https://openairdocs.org/ntsb/UNK65X0714.md): Aeronca 11AC · Ontanagon, MI · Accident · No injuries · Closed · Nov 15, 1964 · N3264E · Substantial damage
- [NTSB UNK65X0696](https://openairdocs.org/ntsb/UNK65X0696.md): Champion 7EC · Villa Rica, GA · Accident · Minor injuries · Closed · Nov 14, 1964 · N7598E · Substantial damage
- [NTSB UNK65X0692](https://openairdocs.org/ntsb/UNK65X0692.md): Piper PA-28 · Burlington, CT · Accident · Serious injuries · Closed · Nov 13, 1964 · N7665W · Destroyed
- [NTSB UNK65X0674](https://openairdocs.org/ntsb/UNK65X0674.md): Stinson 108-1 · Greenville, MI · Accident · Minor injuries · Closed · Nov 12, 1964 · N8945K · Substantial damage
- [NTSB UNK65X0650](https://openairdocs.org/ntsb/UNK65X0650.md): Piper PA22 · Winter Haven, FL · Accident · 2 fatal · Closed · Nov 10, 1964 · N5992D · Destroyed
- [NTSB UNK65X0645](https://openairdocs.org/ntsb/UNK65X0645.md): Aeronca 7AC · San Jose, CA · Accident · Minor injuries · Closed · Nov 10, 1964 · N1575E · Destroyed
- [NTSB UNK65X0632](https://openairdocs.org/ntsb/UNK65X0632.md): Cessna 180 · Acburg, VT · Accident · No injuries · Closed · Nov 9, 1964 · N7784A · Substantial damage
- [NTSB UNK65X0621](https://openairdocs.org/ntsb/UNK65X0621.md): Schweizer 126A · Cedar Falls, ID · Accident · Minor injuries · Closed · Nov 8, 1964 · N2714Z · Substantial damage
- [NTSB UNK65X0620](https://openairdocs.org/ntsb/UNK65X0620.md): Beechcraft PA-23 · Dallas, TX · Accident · No injuries · Closed · Nov 8, 1964 · N2314L · Substantial damage
- [NTSB UNK65X0613](https://openairdocs.org/ntsb/UNK65X0613.md): Mooney M20A · Washington, IL · Accident · Serious injuries · Closed · Nov 8, 1964 · N8303E · Substantial damage
- [NTSB UNK65X0612](https://openairdocs.org/ntsb/UNK65X0612.md): Callair A5 · Wellton, AZ · Accident · No injuries · Closed · Nov 8, 1964 · N2961G · Substantial damage

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

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

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