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

## Cases, newest first

- [NTSB MIA67F0356](https://openairdocs.org/ntsb/MIA67F0356.md): Piper PA-30 · Jonesboro, GA · Accident · No injuries · Closed · Jan 24, 1967 · N7030Y · Substantial damage
- [NTSB DIA67D0031](https://openairdocs.org/ntsb/DIA67D0031.md): Cessna 150F · Gaithersburg, MD · Accident · No injuries · Closed · Jan 24, 1967 · N8716S · Substantial damage
- [NTSB CHI67F0447](https://openairdocs.org/ntsb/CHI67F0447.md): Cessna 310J · Romulus, MI · Accident · Minor injuries · Closed · Jan 24, 1967 · N3173L · Destroyed
- [NTSB MIA67F0361](https://openairdocs.org/ntsb/MIA67F0361.md): Piper PA-28 · San Juan, PR · Accident · No injuries · Closed · Jan 23, 1967 · N6351R · Substantial damage
- [NTSB MIA67A0080](https://openairdocs.org/ntsb/MIA67A0080.md): Convair 640 · San Juan, PR · Accident · Minor injuries · Closed · Jan 23, 1967 · N3408 · Substantial damage
- [NTSB NYC67D0486](https://openairdocs.org/ntsb/NYC67D0486.md): Piper PA-28 · Basin Harbor, VT · Accident · No injuries · Closed · Jan 22, 1967 · N6556W · Substantial damage
- [NTSB NYC67D0450](https://openairdocs.org/ntsb/NYC67D0450.md): Piper PA-12 · Pittstown, NJ · Accident · No injuries · Closed · Jan 22, 1967 · N3988M · Substantial damage
- [NTSB MIA67D0405](https://openairdocs.org/ntsb/MIA67D0405.md): Luscombe 8A · Pahokee, FL · Accident · Minor injuries · Closed · Jan 22, 1967 · N2084K · Substantial damage
- [NTSB MIA67D0001](https://openairdocs.org/ntsb/MIA67D0001-118919.md): Cessna 172D · Ridgeland, SC · Accident · Minor injuries · Closed · Jan 22, 1967 · N2732U · Substantial damage
- [NTSB NYC67D0491](https://openairdocs.org/ntsb/NYC67D0491.md): Stits SA-6B · Taunton, MA · Accident · No injuries · Closed · Jan 21, 1967 · N6493C · Substantial damage
- [NTSB MKC67F0392](https://openairdocs.org/ntsb/MKC67F0392.md): Navion G · Hopkins, MN · Accident · No injuries · Closed · Jan 21, 1967 · N2351T · Substantial damage
- [NTSB CHI67D0477](https://openairdocs.org/ntsb/CHI67D0477.md): Champion 7ECA · Ramsey, IN · Accident · No injuries · Closed · Jan 20, 1967 · N11097 · Substantial damage
- [NTSB MKC67F0398](https://openairdocs.org/ntsb/MKC67F0398.md): Cessna 337 · El Dorado, KS · Accident · No injuries · Closed · Jan 18, 1967 · N6319F · Substantial damage
- [NTSB LAX67D0267](https://openairdocs.org/ntsb/LAX67D0267.md): Bellanca 14-13 · Santee, CA · Accident · No injuries · Closed · Jan 18, 1967 · N86927 · Substantial damage
- [NTSB OAK67F0227](https://openairdocs.org/ntsb/OAK67F0227.md): Cessna 172F · Monterey, CA · Accident · Serious injuries · Closed · Jan 16, 1967 · N5650R · Destroyed
- [NTSB CHI67A0087](https://openairdocs.org/ntsb/CHI67A0087.md): Hiller UH-12B · Fairhaven, MI · Accident · No injuries · Closed · Jan 15, 1967 · N5304V · Destroyed
- [NTSB FTW67F0385](https://openairdocs.org/ntsb/FTW67F0385.md): Cessna 150D · Alvin, TX · Accident · No injuries · Closed · Jan 14, 1967 · N4440U · Substantial damage
- [NTSB DEN67D0190](https://openairdocs.org/ntsb/DEN67D0190.md): Beech J35 · Wagon Mound, NM · Accident · No injuries · Closed · Jan 14, 1967 · N8396D · Substantial damage
- [NTSB OAK67D0217](https://openairdocs.org/ntsb/OAK67D0217.md): Cessna 140 · Newman, CA · Accident · No injuries · Closed · Jan 13, 1967 · N72777 · Substantial damage
- [NTSB MKC67D0379](https://openairdocs.org/ntsb/MKC67D0379.md): Cessna 150 · Hopkins, MN · Accident · No injuries · Closed · Jan 12, 1967 · N6960F · Substantial damage
- [NTSB MKC67F0399](https://openairdocs.org/ntsb/MKC67F0399.md): Piper PA-28 · Springfield, MO · Accident · No injuries · Closed · Jan 11, 1967 · N6688W · Substantial damage
- [NTSB FTW67D0432](https://openairdocs.org/ntsb/FTW67D0432.md): Cessna 120 · George West, TX · Accident · Minor injuries · Closed · Jan 11, 1967 · N81060 · Substantial damage
- [NTSB CHI67D0581](https://openairdocs.org/ntsb/CHI67D0581.md): Cessna 320E · Wheeling, IL · Accident · No injuries · Closed · Jan 11, 1967 · N600SM · Substantial damage
- [NTSB DIA67F0007](https://openairdocs.org/ntsb/DIA67F0007.md): Piper PA-28 · Monroe, NC · Accident · No injuries · Closed · Jan 10, 1967 · N8945W · Substantial damage
- [NTSB NYC67F0410](https://openairdocs.org/ntsb/NYC67F0410.md): Piper PA-23 · Easton, PA · Accident · No injuries · Closed · Jan 9, 1967 · N6053Y · Substantial damage
- [NTSB OAK67D0225](https://openairdocs.org/ntsb/OAK67D0225.md): Beech K35 · Las Vegas, NV · Accident · No injuries · Closed · Jan 7, 1967 · N635Q · Substantial damage
- [NTSB OAK67D0199](https://openairdocs.org/ntsb/OAK67D0199.md): Piper PA-30 · Oakdale, CA · Accident · No injuries · Closed · Jan 7, 1967 · N7930Y · Substantial damage
- [NTSB MIA67D0359](https://openairdocs.org/ntsb/MIA67D0359.md): Cessna 172 · Sanford, FL · Accident · Minor injuries · Closed · Jan 7, 1967 · N2611U · Substantial damage
- [NTSB LAX67F0262](https://openairdocs.org/ntsb/LAX67F0262.md): Luscombe 8A · Huntington, CA · Accident · No injuries · Closed · Jan 7, 1967 · N71148 · Substantial damage
- [NTSB CHI67A0084](https://openairdocs.org/ntsb/CHI67A0084.md): Martin 404 · Cleveland, OH · Accident · No injuries · Closed · Jan 7, 1967 · N478A · Substantial damage
- [NTSB NYC67F0469](https://openairdocs.org/ntsb/NYC67F0469.md): Piper PA-23 · Wappingers Fls, NY · Accident · No injuries · Closed · Jan 6, 1967 · N4086P · Substantial damage
- [NTSB LAX67A0065](https://openairdocs.org/ntsb/LAX67A0065.md): Hughes 269B · Bloomington, CA · Accident · Serious injuries · Closed · Jan 5, 1967 · N9301F · Substantial damage
- [NTSB LAX67F0292](https://openairdocs.org/ntsb/LAX67F0292.md): Beech 95-B55 · S.Barbara, CA · Accident · No injuries · Closed · Jan 4, 1967 · N7964K · Substantial damage
- [NTSB NYC67F0448](https://openairdocs.org/ntsb/NYC67F0448.md): Cessna 150 · Berlin, NJ · Accident · No injuries · Closed · Jan 2, 1967 · N7951F · Substantial damage
- [NTSB NYC67D0465](https://openairdocs.org/ntsb/NYC67D0465.md): Cessna 172 · Middletown, NY · Accident · No injuries · Closed · Jan 2, 1967 · N5506T · Substantial damage
- [NTSB LAX67D0247](https://openairdocs.org/ntsb/LAX67D0247.md): Ercoupe 415-C · Glendale, AZ · Accident · No injuries · Closed · Jan 2, 1967 · N3660H · Substantial damage
- [NTSB FTW67A0068](https://openairdocs.org/ntsb/FTW67A0068.md): Mooney M20E · Ardmore, OK · Accident · 4 fatal · Closed · Jan 2, 1967 · N7130U · Destroyed
- [NTSB CHI67F0404](https://openairdocs.org/ntsb/CHI67F0404.md): Piper PA-32 · Pontiac, MI · Accident · No injuries · Closed · Jan 2, 1967 · N3829W · Substantial damage
- [NTSB MKC67A0041](https://openairdocs.org/ntsb/MKC67A0041.md): Cessna 172 · Spring Grove, MN · Accident · 1 fatal · Closed · Jan 1, 1967 · N7378A · Destroyed
- [NTSB CHI67F0400](https://openairdocs.org/ntsb/CHI67F0400.md): Piper PA-22 · Rockwood, MI · Accident · No injuries · Closed · Jan 1, 1967 · N1236C · Substantial damage
- [NTSB NYC67D042.](https://openairdocs.org/ntsb/NYC67D042..md): Piper PA-22 · Jaffrey, NH · Accident · No injuries · Closed · Dec 31, 1966 · N5805Z · Substantial damage
- [NTSB MKC67F0383](https://openairdocs.org/ntsb/MKC67F0383.md): Aeronca 7CCM · Phelphs, MN · Accident · Minor injuries · Closed · Dec 31, 1966 · N4642E · Substantial damage
- [NTSB MKC67D0375](https://openairdocs.org/ntsb/MKC67D0375.md): Piper PA-22 · Grundy Cntr, IA · Accident · No injuries · Closed · Dec 31, 1966 · N2486P · Substantial damage
- [NTSB NYC67F0443](https://openairdocs.org/ntsb/NYC67F0443.md): Cessna 320D · Morristown, NJ · Accident · No injuries · Closed · Dec 30, 1966 · N4118T · Substantial damage
- [NTSB NYC67I0096](https://openairdocs.org/ntsb/NYC67I0096.md): Fairchild F-27 · Bridgeport, CT · Incident · No injuries · Closed · Dec 29, 1966 · N2705J · No damage
- [NTSB NYC67F0471](https://openairdocs.org/ntsb/NYC67F0471.md): Bellanca 14-13 · Tridelphia, WV · Accident · Minor injuries · Closed · Dec 28, 1966 · N74264 · Substantial damage
- [NTSB MKC67D0384](https://openairdocs.org/ntsb/MKC67D0384.md): Cessna 120 · Buyek, MN · Accident · No injuries · Closed · Dec 26, 1966 · N72775 · Substantial damage
- [NTSB MIA67F0349](https://openairdocs.org/ntsb/MIA67F0349.md): Cessna P206A · Dyersburg, TN · Accident · 1 fatal · Closed · Dec 26, 1966 · N4663F · Substantial damage
- [NTSB FTW67D0377](https://openairdocs.org/ntsb/FTW67D0377.md): Piper PA-28 · Boise City, OK · Accident · Serious injuries · Closed · Dec 26, 1966 · N9314J · Destroyed
- [NTSB CHI67D0508](https://openairdocs.org/ntsb/CHI67D0508.md): Cessna 150 · Lombard, IL · Accident · No injuries · Closed · Dec 26, 1966 · N8002F · Substantial damage

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

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

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