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

## Cases, newest first

- [NTSB FTW66D0008](https://openairdocs.org/ntsb/FTW66D0008.md): Beechcraft M-35 · Rankin, TX · Accident · No injuries · Closed · Mar 14, 1965 · N9823R · Substantial damage
- [NTSB FTW65A0090](https://openairdocs.org/ntsb/FTW65A0090.md): Piper PA-23 · Tomball, TX · Accident · 4 fatal · Closed · Mar 13, 1965 · N615F · Destroyed
- [NTSB MKC65F0068](https://openairdocs.org/ntsb/MKC65F0068.md): Beechcraft 23 · Wichita, KS · Accident · Minor injuries · Closed · Mar 12, 1965 · N2321Z · Destroyed
- [NTSB NYC65F0083](https://openairdocs.org/ntsb/NYC65F0083.md): Cessna 150 · Stratford, NH · Accident · No injuries · Closed · Mar 9, 1965 · N6567T · Substantial damage
- [NTSB OAK65A0058](https://openairdocs.org/ntsb/OAK65A0058.md): Hughes 269B · Pt Reyes S, CA · Accident · No injuries · Closed · Mar 7, 1965 · N9378F · Substantial damage
- [NTSB LAX65F0039](https://openairdocs.org/ntsb/LAX65F0039.md): Lake LA-4 · Catalina Is, CA · Accident · Serious injuries · Closed · Mar 7, 1965 · N1027L · Destroyed
- [NTSB SEA65F0046](https://openairdocs.org/ntsb/SEA65F0046.md): Swift GC-1B · Camas, WA · Accident · Minor injuries · Closed · Mar 6, 1965 · N80656 · Destroyed
- [NTSB MIA65F0098](https://openairdocs.org/ntsb/MIA65F0098.md): Piper PA-28 · Jacksonville, FL · Accident · Minor injuries · Closed · Mar 6, 1965 · N8907W · Substantial damage
- [NTSB CHI66F0028](https://openairdocs.org/ntsb/CHI66F0028.md): Piper PA-20 · Cable, WI · Accident · No injuries · Closed · Mar 6, 1965 · N1145C · 2 aircraft · Substantial damage
- [NTSB ANC65D0002](https://openairdocs.org/ntsb/ANC65D0002.md): Piper PA-24 · Nenana, AK · Accident · No injuries · Closed · Mar 6, 1965 · N6280P · Substantial damage
- [NTSB NYC65A0113](https://openairdocs.org/ntsb/NYC65A0113.md): Lockheed L-18 · Philipsburg, PA · Accident · 2 fatal · Closed · Mar 5, 1965 · N600N · Destroyed
- [NTSB CHI65D0043](https://openairdocs.org/ntsb/CHI65D0043.md): Cessna 172 · Elyria, OH · Accident · No injuries · Closed · Mar 4, 1965 · N3023U · Substantial damage
- [NTSB SEA65F0028](https://openairdocs.org/ntsb/SEA65F0028.md): Piper PA-28 · Bellevue, WA · Accident · Minor injuries · Closed · Mar 3, 1965 · N5545W · Substantial damage
- [NTSB MKC65F0095](https://openairdocs.org/ntsb/MKC65F0095.md): Beechcraft K-35 · Cape Girardeau, MO · Accident · No injuries · Closed · Mar 3, 1965 · N138AG · Substantial damage
- [NTSB FTW66F0132](https://openairdocs.org/ntsb/FTW66F0132.md): Beechcraft C-50 · Tulsa, OK · Accident · No injuries · Closed · Mar 1, 1965 · N3714B · Substantial damage
- [NTSB UNK65X1464](https://openairdocs.org/ntsb/UNK65X1464.md): Cessna 172 · Dallas, TX · Accident · No injuries · Closed · Feb 28, 1965 · N6165E · Substantial damage
- [NTSB OAK65D0029](https://openairdocs.org/ntsb/OAK65D0029.md): Beechcraft B-55 · Lodi, CA · Accident · No injuries · Closed · Feb 28, 1965 · N5612K · Substantial damage
- [NTSB NYC65F0155](https://openairdocs.org/ntsb/NYC65F0155.md): Fairchild M-62A · Albion, NJ · Accident · No injuries · Closed · Feb 28, 1965 · N49966 · Destroyed
- [NTSB NYC65F0069](https://openairdocs.org/ntsb/NYC65F0069.md): Cessna 172 · Haverhill, MA · Accident · No injuries · Closed · Feb 28, 1965 · N7111A · Substantial damage
- [NTSB MKC65F0090](https://openairdocs.org/ntsb/MKC65F0090.md): Cessna 140 · Aitkin, MN · Accident · No injuries · Closed · Feb 28, 1965 · N89164 · Destroyed
- [NTSB MIA65D0003](https://openairdocs.org/ntsb/MIA65D0003.md): Aero Cmdr 520 · Fayetteville, GA · Accident · No injuries · Closed · Feb 28, 1965 · N9093R · Substantial damage
- [NTSB LAX65F0033](https://openairdocs.org/ntsb/LAX65F0033.md): Laister K 10-A · San Diego, CA · Accident · Minor injuries · Closed · Feb 28, 1965 · N58353 · Substantial damage
- [NTSB FTW66D0056](https://openairdocs.org/ntsb/FTW66D0056-201560.md): Piper PA-28 · El Dorado, AR · Accident · No injuries · Closed · Feb 28, 1965 · N8011W · Substantial damage
- [NTSB NYC65F0058](https://openairdocs.org/ntsb/NYC65F0058.md): Piper J3C-65 · New Kent, VA · Accident · Serious injuries · Closed · Feb 27, 1965 · N25982 · Destroyed
- [NTSB MIA65F0016](https://openairdocs.org/ntsb/MIA65F0016-201571.md): Piper J3C · New Ellenton, SC · Accident · No injuries · Closed · Feb 27, 1965 · N87841 · Substantial damage
- [NTSB MIA65A0085](https://openairdocs.org/ntsb/MIA65A0085.md): Cessna 182 · Raleigh, NC · Accident · 5 fatal · Closed · Feb 25, 1965 · N1939X · Substantial damage
- [NTSB LAX65D0043](https://openairdocs.org/ntsb/LAX65D0043.md): Beechcraft B50 · Coso Junction, CA · Accident · Minor injuries · Closed · Feb 24, 1965 · N3568B · Substantial damage
- [NTSB DEN65F0028](https://openairdocs.org/ntsb/DEN65F0028.md): Forney F-1A · Spanish Fork, UT · Accident · No injuries · Closed · Feb 24, 1965 · N3051G · Destroyed
- [NTSB UNK65X1446](https://openairdocs.org/ntsb/UNK65X1446.md): Piper PA23 · Cedar Keys, FL · Accident · No injuries · Closed · Feb 21, 1965 · N4347P · Substantial damage
- [NTSB OAK65F0049](https://openairdocs.org/ntsb/OAK65F0049.md): Piper PA-28 · Redding, CA · Accident · Minor injuries · Closed · Feb 21, 1965 · N7692W · Destroyed
- [NTSB NYC65F0063](https://openairdocs.org/ntsb/NYC65F0063.md): Piper PA-22 · Fredericksburg, PA · Accident · Minor injuries · Closed · Feb 21, 1965 · N4500Z · 2 aircraft · Substantial damage
- [NTSB UNK65X1440](https://openairdocs.org/ntsb/UNK65X1440.md): Cessna 182 · Varnville, SC · Accident · No injuries · Closed · Feb 20, 1965 · N2435R · Substantial damage
- [NTSB CHI65D0068](https://openairdocs.org/ntsb/CHI65D0068.md): Taylorcraft BC-12D · Iron River, MI · Accident · Minor injuries · Closed · Feb 20, 1965 · N20V · Substantial damage
- [NTSB UNK65X1438](https://openairdocs.org/ntsb/UNK65X1438.md): Piper PA-12 · Dawson, GA · Accident · Serious injuries · Closed · Feb 19, 1965 · N7712H · Substantial damage
- [NTSB OAK65F0064](https://openairdocs.org/ntsb/OAK65F0064.md): Dornier DO28B1 · Sam Thong, Laos · Accident · Serious injuries · Closed · Feb 18, 1965 · N1153Q · Substantial damage
- [NTSB UNK65X1433](https://openairdocs.org/ntsb/UNK65X1433.md): Cessna 210 · Addison, TX · Accident · No injuries · Closed · Feb 17, 1965 · N215MD · Substantial damage
- [NTSB CHI65F0095](https://openairdocs.org/ntsb/CHI65F0095.md): Boeing A75N1 · Plainville, IN · Accident · Serious injuries · Closed · Feb 15, 1965 · N9955H · Substantial damage
- [NTSB UNK65X1419](https://openairdocs.org/ntsb/UNK65X1419.md): Grunau Baby · Elsinore, CA · Accident · No injuries · Closed · Feb 14, 1965 · N3371G · Destroyed
- [NTSB LAX65F0029](https://openairdocs.org/ntsb/LAX65F0029.md): Cessna 182 · Sepulveda, CA · Accident · Minor injuries · Closed · Feb 9, 1965 · N5063D · Destroyed
- [NTSB UNK65X1412](https://openairdocs.org/ntsb/UNK65X1412.md): Mooney M20D · Laurinburg, NC · Accident · No injuries · Closed · Feb 8, 1965 · N1925Y · Substantial damage
- [NTSB UNK65X1410](https://openairdocs.org/ntsb/UNK65X1410.md): Beechraft 35-33 · Wauchula, FL · Accident · No injuries · Closed · Feb 8, 1965 · N9934R · Destroyed
- [NTSB NYC65F0028](https://openairdocs.org/ntsb/NYC65F0028.md): Cessna 150 · New Holland, PA · Accident · No injuries · Closed · Feb 8, 1965 · N5929T · Substantial damage
- [NTSB UNK65X1406](https://openairdocs.org/ntsb/UNK65X1406.md): Cessna 150 · Pearland, TX · Accident · Serious injuries · Closed · Feb 7, 1965 · N7779E · Destroyed
- [NTSB UNK65X1404](https://openairdocs.org/ntsb/UNK65X1404.md): Piper PA22 · Woodstock, CT · Accident · No injuries · Closed · Feb 7, 1965 · N5989D · Substantial damage
- [NTSB UNK65X1402](https://openairdocs.org/ntsb/UNK65X1402.md): Cessna 150 · Jonesboro, AR · Accident · Minor injuries · Closed · Feb 7, 1965 · N4540U · Destroyed
- [NTSB SEA65F0002](https://openairdocs.org/ntsb/SEA65F0002.md): Shinn 2150A · Othello, WA · Accident · No injuries · Closed · Feb 6, 1965 · N5122V · Substantial damage
- [NTSB NYC65D0139](https://openairdocs.org/ntsb/NYC65D0139.md): Champion 7FC · Warren, PA · Accident · No injuries · Closed · Feb 6, 1965 · N7513E · Substantial damage
- [NTSB LAX65D0006](https://openairdocs.org/ntsb/LAX65D0006.md): Cessna 175 · Brawley, CA · Accident · Minor injuries · Closed · Feb 6, 1965 · N6897E · Substantial damage
- [NTSB FTW65A0079](https://openairdocs.org/ntsb/FTW65A0079.md): Cessna 172 · Burleson, TX · Accident · 4 fatal · Closed · Feb 6, 1965 · N3709S · Destroyed
- [NTSB CHI65F0034](https://openairdocs.org/ntsb/CHI65F0034.md): Mooney MARK20 · Woodburn, IN · Accident · No injuries · Closed · Feb 6, 1965 · N5284B · Substantial damage

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

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

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