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

## Cases, newest first

- [NTSB OAK65F0008](https://openairdocs.org/ntsb/OAK65F0008.md): Cessna 140 · San Jose, CA · Accident · No injuries · Closed · Feb 5, 1965 · N2095N · 2 aircraft · Substantial damage
- [NTSB NYC65F0036](https://openairdocs.org/ntsb/NYC65F0036.md): Cessna 172 · Andover, MA · Accident · No injuries · Closed · Feb 4, 1965 · N7859U · Substantial damage
- [NTSB NYC65F0006](https://openairdocs.org/ntsb/NYC65F0006.md): Piper PA22 · Tewksbury, MA · Accident · No injuries · Closed · Feb 3, 1965 · N5647Z · Substantial damage
- [NTSB NYC65A0102](https://openairdocs.org/ntsb/NYC65A0102.md): Grumman G-159 · Calverton, NY · Accident · No injuries · Closed · Feb 3, 1965 · N770AC · Substantial damage
- [NTSB MIA65S0003](https://openairdocs.org/ntsb/MIA65S0003.md): Beechcraft AT-11 · Freeport, Burkina Faso · Accident · 1 fatal · Closed · Feb 2, 1965 · N52933 · Destroyed
- [NTSB UNK65X1378](https://openairdocs.org/ntsb/UNK65X1378.md): Cessna 172A · Lake Charles, LA · Accident · No injuries · Closed · Feb 1, 1965 · N21965 · Substantial damage
- [NTSB LAX65F0018](https://openairdocs.org/ntsb/LAX65F0018.md): Piper PA-24 · Van Nuys, CA · Accident · Minor injuries · Closed · Jan 31, 1965 · N7553P · Destroyed
- [NTSB NYC65F0002](https://openairdocs.org/ntsb/NYC65F0002.md): Piper PA22 · Montgomery, NY · Accident · No injuries · Closed · Jan 30, 1965 · N5686Z · Substantial damage
- [NTSB UNK65X1368](https://openairdocs.org/ntsb/UNK65X1368.md): Beechraft 35-33 · Dallas, TX · Accident · Serious injuries · Closed · Jan 28, 1965 · N624V · Destroyed
- [NTSB UNK65X1363](https://openairdocs.org/ntsb/UNK65X1363.md): Cessna 120 · Half Moon Bay, CA · Accident · Minor injuries · Closed · Jan 28, 1965 · N1868N · Destroyed
- [NTSB MKC65F0002](https://openairdocs.org/ntsb/MKC65F0002.md): Piper PA-24 · Lake Elmo, MN · Accident · No injuries · Closed · Jan 28, 1965 · N5981P · Substantial damage
- [NTSB UNK65X1356](https://openairdocs.org/ntsb/UNK65X1356.md): Beechraft D18S · Cleveland, TN · Accident · No injuries · Closed · Jan 27, 1965 · N2636 · Substantial damage
- [NTSB UNK65X1343](https://openairdocs.org/ntsb/UNK65X1343.md): Piper PA-18 · Tustin, WI · Accident · Serious injuries · Closed · Jan 24, 1965 · N1021A · Destroyed
- [NTSB LAX65A0060](https://openairdocs.org/ntsb/LAX65A0060.md): Fairchild M62C · Jacumba, CA · Accident · 2 fatal · Closed · Jan 23, 1965 · N56681 · Substantial damage
- [NTSB MKC65A0048](https://openairdocs.org/ntsb/MKC65A0048.md): Beechcraft K35 · Syracuse, KS · Accident · 4 fatal · Closed · Jan 22, 1965 · N5390E · Destroyed
- [NTSB UNK65X1326](https://openairdocs.org/ntsb/UNK65X1326.md): Piper PA22 · Chagrin Falls, OH · Accident · No injuries · Closed · Jan 21, 1965 · N4786Z · Substantial damage
- [NTSB UNK65X1324](https://openairdocs.org/ntsb/UNK65X1324.md): Aeronca 7AC · Teller, AK · Accident · No injuries · Closed · Jan 21, 1965 · N82490 · Substantial damage
- [NTSB NYC65 0096](https://openairdocs.org/ntsb/NYC65%200096.md): Martin M-404 · Weyers Cave, VA · Accident · No injuries · Closed · Jan 21, 1965 · N40448 · Substantial damage
- [NTSB ANC65I0040](https://openairdocs.org/ntsb/ANC65I0040.md): Convair CV-880 · Fairbanks, AK · Incident · No injuries · Closed · Jan 21, 1965 · N8877H · Minor damage
- [NTSB UNK65X1318](https://openairdocs.org/ntsb/UNK65X1318.md): Cessna 172 · Wellsburg, WV · Accident · Serious injuries · Closed · Jan 19, 1965 · N7775U · Substantial damage
- [NTSB UNK65X1313](https://openairdocs.org/ntsb/UNK65X1313.md): Piper PA-22 · Viola, KS · Accident · Serious injuries · Closed · Jan 18, 1965 · N6834B · Substantial damage
- [NTSB UNK65X1308](https://openairdocs.org/ntsb/UNK65X1308.md): Cessna 150 · Fabens, TX · Accident · No injuries · Closed · Jan 18, 1965 · N5576E · Substantial damage
- [NTSB UNK65X1305](https://openairdocs.org/ntsb/UNK65X1305.md): Piper PA-22 · Nashua, NH · Accident · Minor injuries · Closed · Jan 17, 1965 · N5939Z · 2 aircraft · Substantial damage
- [NTSB UNK65X1299](https://openairdocs.org/ntsb/UNK65X1299.md): Cessna 210 · Stockholm, SW · Accident · 3 fatal · Closed · Jan 17, 1965 · N2313F · Destroyed
- [NTSB LAX65F0007](https://openairdocs.org/ntsb/LAX65F0007.md): Cessna 140 · San Fernando, CA · Accident · No injuries · Closed · Jan 17, 1965 · N89952 · Destroyed
- [NTSB UNK65X1290](https://openairdocs.org/ntsb/UNK65X1290.md): Piper PA-22 · Prospectville, PA · Accident · Minor injuries · Closed · Jan 15, 1965 · N4765Z · Substantial damage
- [NTSB UNK65X1289](https://openairdocs.org/ntsb/UNK65X1289.md): Champion 7EC · Cambridge, MN · Accident · No injuries · Closed · Jan 14, 1965 · N4837E · Substantial damage
- [NTSB CHI65A0068](https://openairdocs.org/ntsb/CHI65A0068.md): Lockheed L18 · Ypsilanti, MI · Accident · 2 fatal · Closed · Jan 14, 1965 · N512V · Destroyed
- [NTSB UNK65X1265](https://openairdocs.org/ntsb/UNK65X1265.md): Cessna 172 · Oses Lake, WA · Accident · No injuries · Closed · Jan 10, 1965 · N4264F · Substantial damage
- [NTSB LAX65F0090](https://openairdocs.org/ntsb/LAX65F0090.md): Luscombe 8A · Riverside, CA · Accident · No injuries · Closed · Jan 10, 1965 · N71704 · Substantial damage
- [NTSB CHI65F0083](https://openairdocs.org/ntsb/CHI65F0083.md): Cessna 182 · Peoria, IL · Accident · 1 fatal · Closed · Jan 10, 1965 · N8476T · Destroyed
- [NTSB UNK65X1261](https://openairdocs.org/ntsb/UNK65X1261.md): Fairchild 24W41A · Norwood, MA · Accident · No injuries · Closed · Jan 9, 1965 · N25183 · Substantial damage
- [NTSB OAK65A0049](https://openairdocs.org/ntsb/OAK65A0049.md): Piper PA20 · San Carlos, CA · Accident · 3 fatal · Closed · Jan 9, 1965 · N7459K · Destroyed
- [NTSB CHI65F0022](https://openairdocs.org/ntsb/CHI65F0022.md): Beechraft AT11 · Wheeling, IL · Accident · No injuries · Closed · Jan 9, 1965 · N107RS · Substantial damage
- [NTSB UNK65X1249](https://openairdocs.org/ntsb/UNK65X1249.md): Beechraft A35 · Berryville, AR · Accident · Minor injuries · Closed · Jan 7, 1965 · N692B · Destroyed
- [NTSB UNK65X1248](https://openairdocs.org/ntsb/UNK65X1248.md): Cessna 170B · Farmingdale, NY · Accident · No injuries · Closed · Jan 7, 1965 · N3262A · Substantial damage
- [NTSB LAX65F0044](https://openairdocs.org/ntsb/LAX65F0044.md): Beech D35 · Long Beach, CA · Accident · Serious injuries · Closed · Jan 7, 1965 · N459B · Substantial damage
- [NTSB UNK65X1235](https://openairdocs.org/ntsb/UNK65X1235.md): Cessna 210 · Blythe, CA · Accident · Minor injuries · Closed · Jan 6, 1965 · N7377E · Destroyed
- [NTSB UNK65X1230](https://openairdocs.org/ntsb/UNK65X1230.md): Cessna 182 · Lathrup Wells, NV · Accident · No injuries · Closed · Jan 4, 1965 · N9054T · Substantial damage
- [NTSB CHI65F0020](https://openairdocs.org/ntsb/CHI65F0020.md): Champion 7FC · Mishawaka, IN · Accident · No injuries · Closed · Jan 4, 1965 · N9816Y · Substantial damage
- [NTSB MKC65F0020](https://openairdocs.org/ntsb/MKC65F0020.md): Piper PA-22 · Seneca, KS · Accident · Minor injuries · Closed · Jan 2, 1965 · N2947Z · Destroyed
- [NTSB UNK65X1206](https://openairdocs.org/ntsb/UNK65X1206.md): Schweizer SGS126 · Riverside, CA · Accident · Minor injuries · Closed · Jan 1, 1965 · N10359 · Substantial damage
- [NTSB UNK65X1202](https://openairdocs.org/ntsb/UNK65X1202.md): Mooney MK-20D · Vandalia, OH · Accident · Serious injuries · Closed · Dec 31, 1964 · N1923Y · Substantial damage
- [NTSB UNK65X1161](https://openairdocs.org/ntsb/UNK65X1161.md): Cessna 172 · Swan Valley, ID · Accident · Serious injuries · Closed · Dec 27, 1964 · N7026A · Destroyed
- [NTSB UNK65X1152](https://openairdocs.org/ntsb/UNK65X1152.md): Beech 23 · Rogers, AR · Accident · No injuries · Closed · Dec 27, 1964 · N2364Q · Substantial damage
- [NTSB UNK65X1144](https://openairdocs.org/ntsb/UNK65X1144.md): Piper PA-22 · Lucerne Vally, CA · Accident · Minor injuries · Closed · Dec 26, 1964 · N5298Z · Destroyed
- [NTSB UNK65X1126](https://openairdocs.org/ntsb/UNK65X1126.md): Cessna 182 · Smyer, TX · Accident · No injuries · Closed · Dec 25, 1964 · N8686T · Substantial damage
- [NTSB UNK65X1118](https://openairdocs.org/ntsb/UNK65X1118.md): Piper PA-24 · Bartonville, IL · Accident · 1 fatal · Closed · Dec 24, 1964 · N6406P · Destroyed
- [NTSB UNK65X1106](https://openairdocs.org/ntsb/UNK65X1106.md): Maule M4 · Rosholt, SD · Accident · No injuries · Closed · Dec 23, 1964 · N4734T · Substantial damage
- [NTSB UNK65X1091](https://openairdocs.org/ntsb/UNK65X1091.md): Piper PA-22 · Palm Springs, CA · Accident · No injuries · Closed · Dec 22, 1964 · N2678A · Destroyed

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

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

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