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

## Cases, newest first

- [NTSB MIA68D0085](https://openairdocs.org/ntsb/MIA68D0085.md): Piper PA-28 · Jacksonville, FL · Accident · No injuries · Closed · Jul 21, 1967 · N6414W · Substantial damage
- [NTSB MIA68D006U](https://openairdocs.org/ntsb/MIA68D006U.md): Cessna 150 · Lawrenceburg, TN · Accident · No injuries · Closed · Jul 21, 1967 · N8969S · Substantial damage
- [NTSB LAX68D0102](https://openairdocs.org/ntsb/LAX68D0102.md): Cessna 182 · Marana, AZ · Accident · Minor injuries · Closed · Jul 21, 1967 · N9286X · Substantial damage
- [NTSB ANC68F0039](https://openairdocs.org/ntsb/ANC68F0039.md): Aeronca 11AC · Dillingham, AK · Accident · Serious injuries · Closed · Jul 21, 1967 · N9097E · Destroyed
- [NTSB DEN68F0032](https://openairdocs.org/ntsb/DEN68F0032.md): Navion A · Albuquerque, NM · Accident · No injuries · Closed · Jul 20, 1967 · N2791A · Substantial damage
- [NTSB UNK67X0140](https://openairdocs.org/ntsb/UNK67X0140.md): Beech S35 · Barbuda, Ascension Island · Accident · No injuries · Closed · Jul 19, 1967 · N5776K · Substantial damage
- [NTSB LAX68D0090](https://openairdocs.org/ntsb/LAX68D0090.md): Piper PA-28 · Carefree, AZ · Accident · No injuries · Closed · Jul 18, 1967 · N9569W · Substantial damage
- [NTSB NYC68F0082](https://openairdocs.org/ntsb/NYC68F0082.md): Cougar I · Minersville, PA · Accident · No injuries · Closed · Jul 16, 1967 · N1112Y · Substantial damage
- [NTSB MKC68D0086](https://openairdocs.org/ntsb/MKC68D0086.md): Piper PA-28 · Chadron, NE · Accident · No injuries · Closed · Jul 15, 1967 · N8208W · Substantial damage
- [NTSB MIA68D0134](https://openairdocs.org/ntsb/MIA68D0134.md): Luscombe 8F · Savannah, GA · Accident · No injuries · Closed · Jul 15, 1967 · N1430B · Substantial damage
- [NTSB LAX68F0066](https://openairdocs.org/ntsb/LAX68F0066.md): Tonzer T-18 · Lancaster, CA · Accident · Minor injuries · Closed · Jul 15, 1967 · N6651 · Substantial damage
- [NTSB LAX68A0006](https://openairdocs.org/ntsb/LAX68A0006.md): Piper PA-28 · Sepulveda, CA · Accident · 2 fatal · Closed · Jul 15, 1967 · N5966W · 2 aircraft · Destroyed
- [NTSB NYC68F0155](https://openairdocs.org/ntsb/NYC68F0155.md): Maule M-4 · Ballston, NY · Accident · Serious injuries · Closed · Jul 14, 1967 · N9856M · Destroyed
- [NTSB LAX68D0044](https://openairdocs.org/ntsb/LAX68D0044.md): Piper PA-18 · Escondido, CA · Accident · No injuries · Closed · Jul 14, 1967 · N8256C · Substantial damage
- [NTSB CHI68F0076](https://openairdocs.org/ntsb/CHI68F0076.md): Cessna 150 · Hillsdale, MI · Accident · Minor injuries · Closed · Jul 13, 1967 · N7920F · Destroyed
- [NTSB NYC68A0006](https://openairdocs.org/ntsb/NYC68A0006.md): Champion 7ECA · Holley, NY · Accident · 1 fatal · Closed · Jul 12, 1967 · N9521S · Destroyed
- [NTSB NYC68D0060](https://openairdocs.org/ntsb/NYC68D0060.md): Cessna 150 · Shirley, MA · Accident · No injuries · Closed · Jul 11, 1967 · N3099X · Destroyed
- [NTSB DEN68D0024](https://openairdocs.org/ntsb/DEN68D0024.md): Piper PA-18 · Walden, CO · Accident · No injuries · Closed · Jul 11, 1967 · N3675P · Substantial damage
- [NTSB ANC68A0002](https://openairdocs.org/ntsb/ANC68A0002.md): Bell 47G-2 · Beaver, AK · Accident · Serious injuries · Closed · Jul 11, 1967 · N499EA · Destroyed
- [NTSB CHI68F0086](https://openairdocs.org/ntsb/CHI68F0086.md): Erco 415-C · Newport, MI · Accident · Minor injuries · Closed · Jul 9, 1967 · N87383 · Substantial damage
- [NTSB LAX68D0062](https://openairdocs.org/ntsb/LAX68D0062.md): Schweizer SGS126 · Halloran Spgs, CA · Accident · No injuries · Closed · Jul 8, 1967 · N8608R · Substantial damage
- [NTSB LAX68D0055](https://openairdocs.org/ntsb/LAX68D0055.md): Schweizer SGS2-8 · Elsinore, CA · Accident · Minor injuries · Closed · Jul 7, 1967 · N53285 · Substantial damage
- [NTSB DIA68F0022](https://openairdocs.org/ntsb/DIA68F0022.md): Alon A-2 · Whitsett, NC · Accident · Minor injuries · Closed · Jul 7, 1967 · N6566Q · Substantial damage
- [NTSB FTW68F0067](https://openairdocs.org/ntsb/FTW68F0067.md): Beech 35 · Mountainview, OK · Accident · Serious injuries · Closed · Jul 5, 1967 · N434B · Destroyed
- [NTSB DEN68F0012](https://openairdocs.org/ntsb/DEN68F0012.md): Cessna 150 · Watkins, CO · Accident · Serious injuries · Closed · Jul 5, 1967 · N7140F · Substantial damage
- [NTSB NYC68D0045](https://openairdocs.org/ntsb/NYC68D0045.md): Cessna 150D · East Hampton, CT · Accident · Minor injuries · Closed · Jul 4, 1967 · N5929T · Substantial damage
- [NTSB CHI68F0149](https://openairdocs.org/ntsb/CHI68F0149.md): Piper J3C65 · Kingsford, MI · Accident · Serious injuries · Closed · Jul 4, 1967 · N7483H · Substantial damage
- [NTSB SEA68D0117](https://openairdocs.org/ntsb/SEA68D0117.md): Piper PA-24 · Rockland, ID · Accident · No injuries · Closed · Jul 3, 1967 · N7535P · Substantial damage
- [NTSB NYC68D0034](https://openairdocs.org/ntsb/NYC68D0034.md): Cessna 150 · Nashua, NH · Accident · No injuries · Closed · Jul 3, 1967 · N4156V · Substantial damage
- [NTSB MKC68F0067](https://openairdocs.org/ntsb/MKC68F0067.md): Piper PA-28 · So.St.Paul, MN · Accident · Serious injuries · Closed · Jul 3, 1967 · N508UM · Substantial damage
- [NTSB LAX68D0026](https://openairdocs.org/ntsb/LAX68D0026.md): Wolf Hirth LO-150 · Apple Vally, CA · Accident · Serious injuries · Closed · Jul 3, 1967 · N9009Z · Substantial damage
- [NTSB LAX68F0124](https://openairdocs.org/ntsb/LAX68F0124.md): Cessna 182 · Long Beach, CA · Accident · Serious injuries · Closed · Jul 2, 1967 · N5525B · Destroyed
- [NTSB LAX68F0054](https://openairdocs.org/ntsb/LAX68F0054.md): Cessna 172 · Arcadia, CA · Accident · No injuries · Closed · Jul 2, 1967 · N3879S · Substantial damage
- [NTSB OAK68A0001](https://openairdocs.org/ntsb/OAK68A0001.md): Beech 35 · Carson City, NV · Accident · 4 fatal · Closed · Jul 1, 1967 · N3199V · Destroyed
- [NTSB MKC68A0001](https://openairdocs.org/ntsb/MKC68A0001.md): Bellanca 14-13 · Viburnum, MO · Accident · 3 fatal · Closed · Jul 1, 1967 · N74333 · Destroyed
- [NTSB FTW68D0063](https://openairdocs.org/ntsb/FTW68D0063.md): Taylorcraft BC12 · Moro, AR · Accident · No injuries · Closed · Jul 1, 1967 · N29806 · Substantial damage
- [NTSB OAK68D0045](https://openairdocs.org/ntsb/OAK68D0045.md): Piper PA-28 · Fresno, CA · Accident · No injuries · Closed · Jun 30, 1967 · N7730W · Substantial damage
- [NTSB FTW68D0060](https://openairdocs.org/ntsb/FTW68D0060.md): Cessna 150 · Bowie, TX · Accident · No injuries · Closed · Jun 30, 1967 · N3131X · Substantial damage
- [NTSB NYC68F0024](https://openairdocs.org/ntsb/NYC68F0024.md): Cessna 172 · Kutztown, PA · Accident · Serious injuries · Closed · Jun 29, 1967 · N9885T · Destroyed
- [NTSB CHI68F0179](https://openairdocs.org/ntsb/CHI68F0179.md): Piper PA-15 · Terre Haute, IN · Accident · Serious injuries · Closed · Jun 29, 1967 · N4303H · Substantial damage
- [NTSB NYC68D0142](https://openairdocs.org/ntsb/NYC68D0142.md): Aeronca S7AC · Niagra Falls, NY · Accident · No injuries · Closed · Jun 28, 1967 · N82423 · Destroyed
- [NTSB NYC67A0190](https://openairdocs.org/ntsb/NYC67A0190.md): Ercoupe 415C · Berlin, NJ · Accident · 2 fatal · Closed · Jun 28, 1967 · N99035 · Destroyed
- [NTSB MKC67A0092](https://openairdocs.org/ntsb/MKC67A0092.md): Beech D35 · So.St-Paul, MN · Accident · 1 fatal · Closed · Jun 28, 1967 · N2930B · 2 aircraft · Substantial damage
- [NTSB MKC67A0090](https://openairdocs.org/ntsb/MKC67A0090.md): Champion 7CCM · Johnson, KS · Accident · 1 fatal · Closed · Jun 28, 1967 · N4587E · Destroyed
- [NTSB LAX68F0059](https://openairdocs.org/ntsb/LAX68F0059.md): Cessna 170 · Cottonwood, AZ · Accident · Serious injuries · Closed · Jun 28, 1967 · N4247V · Substantial damage
- [NTSB CAN F0444](https://openairdocs.org/ntsb/CAN%20%20F0444.md): Aeronca S7AC · Niagra Falls, Canada · Accident · No injuries · Closed · Jun 28, 1967 · N82423 · Destroyed
- [NTSB FTW68F0028](https://openairdocs.org/ntsb/FTW68F0028.md): Piper PA-28 · Ponca City, OK · Accident · Minor injuries · Closed · Jun 27, 1967 · N5400U · Destroyed
- [NTSB OAK68D0039](https://openairdocs.org/ntsb/OAK68D0039.md): Piper PA-28 · Hollister, CA · Accident · No injuries · Closed · Jun 26, 1967 · N6451R · Substantial damage
- [NTSB MKC68F0120](https://openairdocs.org/ntsb/MKC68F0120.md): Piper PA-11 · N.Rockford, ND · Accident · Minor injuries · Closed · Jun 26, 1967 · N4758H · Substantial damage
- [NTSB CHI67A0141](https://openairdocs.org/ntsb/CHI67A0141.md): Bell 47G-2 · Wisc.Dells, WI · Accident · No injuries · Closed · Jun 26, 1967 · N2866B · Substantial damage

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

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

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