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

## Cases, newest first

- [NTSB MKC65F0134](https://openairdocs.org/ntsb/MKC65F0134.md): Beechcraft 23 · Lincoln, NE · Accident · No injuries · Closed · Apr 21, 1965 · N23070 · Substantial damage
- [NTSB FTW65F0052](https://openairdocs.org/ntsb/FTW65F0052.md): Cessna 172 · Smithfield, TX · Accident · Minor injuries · Closed · Apr 21, 1965 · N5382T · Substantial damage
- [NTSB MKC65A0061](https://openairdocs.org/ntsb/MKC65A0061.md): Piper PA-18 · Selfridge, ND · Accident · 1 fatal · Closed · Apr 20, 1965 · N8178D · Destroyed
- [NTSB FTW65F0029](https://openairdocs.org/ntsb/FTW65F0029.md): Piper PA-18 · Laredo, TX · Accident · No injuries · Closed · Apr 20, 1965 · N4089Z · Substantial damage
- [NTSB ANC65A0045](https://openairdocs.org/ntsb/ANC65A0045.md): Cessna 180 · English Bay, AK · Accident · Serious injuries · Closed · Apr 19, 1965 · N3310D · Substantial damage
- [NTSB FTW65D0027](https://openairdocs.org/ntsb/FTW65D0027.md): Cessna 150 · Kaplan, LA · Accident · No injuries · Closed · Apr 18, 1965 · N6040T · Destroyed
- [NTSB CHI65D0103](https://openairdocs.org/ntsb/CHI65D0103.md): Cessna 182C · Pikeville, KY · Accident · No injuries · Closed · Apr 17, 1965 · N8785T · Substantial damage
- [NTSB DEN65F0047](https://openairdocs.org/ntsb/DEN65F0047.md): Cessna 182 · St George, UT · Accident · Minor injuries · Closed · Apr 16, 1965 · N5490B · Substantial damage
- [NTSB LAX65F0046](https://openairdocs.org/ntsb/LAX65F0046.md): Cessna 210 · San Diego, CA · Accident · Minor injuries · Closed · Apr 14, 1965 · N3799Y · Substantial damage
- [NTSB SEA65F0037](https://openairdocs.org/ntsb/SEA65F0037.md): Piper PA-28 · Othello, WA · Accident · No injuries · Closed · Apr 13, 1965 · N5279W · Substantial damage
- [NTSB MIA65F0044](https://openairdocs.org/ntsb/MIA65F0044.md): Cessna 310D · Franklin, NC · Accident · No injuries · Closed · Apr 13, 1965 · N6868T · Substantial damage
- [NTSB OAK65D0036](https://openairdocs.org/ntsb/OAK65D0036.md): Piper PA-28 · Los Banos, CA · Accident · Minor injuries · Closed · Apr 11, 1965 · N8843W · Destroyed
- [NTSB NYC65F0147](https://openairdocs.org/ntsb/NYC65F0147.md): Schweizer SGU · Mars, PA · Accident · Serious injuries · Closed · Apr 11, 1965 · N2749Z · Substantial damage
- [NTSB MKC65D0135](https://openairdocs.org/ntsb/MKC65D0135.md): Cessna 182 · Columbia, MO · Accident · No injuries · Closed · Apr 11, 1965 · N3363U · Substantial damage
- [NTSB MIA65F0070](https://openairdocs.org/ntsb/MIA65F0070.md): Cessna 182F · Okeechobee, FL · Accident · No injuries · Closed · Apr 11, 1965 · N3592U · Destroyed
- [NTSB DEN65A0065](https://openairdocs.org/ntsb/DEN65A0065.md): Bell 47G3B1 · Payson, AZ · Accident · Minor injuries · Closed · Apr 11, 1965 · N1198W · Substantial damage
- [NTSB CHI65F0181](https://openairdocs.org/ntsb/CHI65F0181.md): Aeronca 11-AC · Warsaw, IN · Accident · No injuries · Closed · Apr 11, 1965 · N86023 · Substantial damage
- [NTSB MKC65A0060](https://openairdocs.org/ntsb/MKC65A0060.md): Piper PA-12 · Van Buren, MO · Accident · 1 fatal · Closed · Apr 10, 1965 · N3508M · Substantial damage
- [NTSB MKC65A0059](https://openairdocs.org/ntsb/MKC65A0059.md): Cessna 175 · Lampe, MO · Accident · 3 fatal · Closed · Apr 9, 1965 · N7548M · Destroyed
- [NTSB SEA65A0050](https://openairdocs.org/ntsb/SEA65A0050.md): Hughes 269A · L.Quinault, WA · Accident · Minor injuries · Closed · Apr 8, 1965 · N8886F · Destroyed
- [NTSB MKC65A0058](https://openairdocs.org/ntsb/MKC65A0058.md): Piper PA-23 · Grand Forks, ND · Accident · 2 fatal · Closed · Apr 8, 1965 · N4021P · Destroyed
- [NTSB CHI65A0088](https://openairdocs.org/ntsb/CHI65A0088.md): Piper PA-24 · Flint, MI · Accident · 2 fatal · Closed · Apr 6, 1965 · N6356P · Destroyed
- [NTSB OAK65F0053](https://openairdocs.org/ntsb/OAK65F0053.md): Cessna 172 · San Jose, CA · Accident · No injuries · Closed · Apr 4, 1965 · N7337A · Substantial damage
- [NTSB OAK65D0030](https://openairdocs.org/ntsb/OAK65D0030.md): Beechcraft T-34A · Merced, CA · Accident · No injuries · Closed · Apr 4, 1965 · N7782C · Destroyed
- [NTSB FTW66F0018](https://openairdocs.org/ntsb/FTW66F0018.md): Luscombe 8A · Baytown, TX · Accident · No injuries · Closed · Apr 3, 1965 · N2915K · Substantial damage
- [NTSB CHI65F0063](https://openairdocs.org/ntsb/CHI65F0063.md): Cessna 172 · Lebanon, OH · Accident · No injuries · Closed · Apr 3, 1965 · N5628T · Substantial damage
- [NTSB SEA65F0023](https://openairdocs.org/ntsb/SEA65F0023.md): Beech K35 · Boise, ID · Accident · No injuries · Closed · Apr 2, 1965 · N6034E · Substantial damage
- [NTSB NYC65F0223](https://openairdocs.org/ntsb/NYC65F0223.md): Beechcraft D-18S · New Castle, DE · Accident · Minor injuries · Closed · Apr 2, 1965 · N9910 · Substantial damage
- [NTSB MKC65F0094](https://openairdocs.org/ntsb/MKC65F0094.md): Cessna 150D · Kenosha, WI · Accident · No injuries · Closed · Apr 2, 1965 · N6020T · Substantial damage
- [NTSB OAK65F0075](https://openairdocs.org/ntsb/OAK65F0075.md): Cessna 182 · West Yuba Cty, CA · Accident · No injuries · Closed · Apr 1, 1965 · N8763K · Substantial damage
- [NTSB CHI65F0107](https://openairdocs.org/ntsb/CHI65F0107.md): Beechcraft D-18S · Crawfordsville, IN · Accident · No injuries · Closed · Apr 1, 1965 · N57G · Substantial damage
- [NTSB MIA65F0024](https://openairdocs.org/ntsb/MIA65F0024.md): Piper PA-24 · Memphis, TN · Accident · Serious injuries · Closed · Mar 31, 1965 · N8180P · Substantial damage
- [NTSB CHI65A0085](https://openairdocs.org/ntsb/CHI65A0085.md): Cessna 337 · Willoughby, OH · Accident · Serious injuries · Closed · Mar 29, 1965 · N2121X · Destroyed
- [NTSB NYC65F0117](https://openairdocs.org/ntsb/NYC65F0117.md): Cessna 150 · Denton, MD · Accident · Serious injuries · Closed · Mar 28, 1965 · N578U · Destroyed
- [NTSB MKC65F0102](https://openairdocs.org/ntsb/MKC65F0102.md): Navion G-1 · Sioux City, IA · Accident · No injuries · Closed · Mar 28, 1965 · N2467T · Substantial damage
- [NTSB NYC65F0136](https://openairdocs.org/ntsb/NYC65F0136.md): Cessna 182 · Rochester, NY · Accident · No injuries · Closed · Mar 27, 1965 · N5003D · Substantial damage
- [NTSB MKC65F0092](https://openairdocs.org/ntsb/MKC65F0092.md): Mooney M20A · Eveleth, MN · Accident · No injuries · Closed · Mar 26, 1965 · N1075B · Substantial damage
- [NTSB MIA65F0016](https://openairdocs.org/ntsb/MIA65F0016-179482.md): Ercoupe 415C · Roscoe, GA · Accident · No injuries · Closed · Mar 26, 1965 · N99692 · Substantial damage
- [NTSB CHI65F0134](https://openairdocs.org/ntsb/CHI65F0134.md): Piper PA-22 · Crystal Lake, IL · Accident · No injuries · Closed · Mar 26, 1965 · N5092Z · Destroyed
- [NTSB CHI65F0109](https://openairdocs.org/ntsb/CHI65F0109.md): Cessna 172D · Battle Creek, MI · Accident · Serious injuries · Closed · Mar 25, 1965 · N2349U · Substantial damage
- [NTSB UNK65X1478](https://openairdocs.org/ntsb/UNK65X1478.md): Nelson PG185B · Acme, PA · Accident · Serious injuries · Closed · Mar 21, 1965 · N68585 · Substantial damage
- [NTSB NYC65F0099](https://openairdocs.org/ntsb/NYC65F0099.md): Piper PA-11 · Ithaca, NY · Accident · No injuries · Closed · Mar 21, 1965 · N4699M · Substantial damage
- [NTSB SEA65D0034](https://openairdocs.org/ntsb/SEA65D0034.md): Mooney M18C · Idaho Falls, ID · Accident · No injuries · Closed · Mar 20, 1965 · N4073 · Destroyed
- [NTSB MKC65A0054](https://openairdocs.org/ntsb/MKC65A0054.md): Piper PA-20 · Johnson, KS · Accident · 3 fatal · Closed · Mar 20, 1965 · N3584A · Destroyed
- [NTSB UNK65X1477](https://openairdocs.org/ntsb/UNK65X1477.md): Camair 480 · Obregon, Mexico · Accident · No injuries · Closed · Mar 19, 1965 · N231 · Substantial damage
- [NTSB NYC65F0100](https://openairdocs.org/ntsb/NYC65F0100.md): Piper PA-11 · Rehoboth, DE · Accident · Serious injuries · Closed · Mar 19, 1965 · N4932H · Substantial damage
- [NTSB CHI65F0091](https://openairdocs.org/ntsb/CHI65F0091.md): Piper PA-22 · Roselle, IL · Accident · No injuries · Closed · Mar 19, 1965 · N4953Z · Substantial damage
- [NTSB DEN65D0068](https://openairdocs.org/ntsb/DEN65D0068.md): Piper PA-28 · Paradox, CO · Accident · No injuries · Closed · Mar 15, 1965 · N8756W · Substantial damage
- [NTSB MIA65A0092](https://openairdocs.org/ntsb/MIA65A0092.md): Cessna 150G · Auburn, AL · Accident · 1 fatal · Closed · Mar 14, 1965 · N7966Z · Substantial damage
- [NTSB LAX65D0021](https://openairdocs.org/ntsb/LAX65D0021.md): Cessna 175 · Famosa, CA · Accident · No injuries · Closed · Mar 14, 1965 · N7076M · Substantial damage

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

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

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