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

## Cases, newest first

- [NTSB CHI68F0529](https://openairdocs.org/ntsb/CHI68F0529.md): Piper PA-24 · Manistee, MI · Accident · Serious injuries · Closed · Dec 31, 1967 · N7636P · Substantial damage
- [NTSB FTW68D0410](https://openairdocs.org/ntsb/FTW68D0410.md): Cessna 310D · Midland, TX · Accident · Minor injuries · Closed · Dec 29, 1967 · N6989T · Substantial damage
- [NTSB FTW68D0403](https://openairdocs.org/ntsb/FTW68D0403.md): Piper PA-28 · Jonesboro, AR · Accident · No injuries · Closed · Dec 29, 1967 · N6417W · Substantial damage
- [NTSB DEN68F0179](https://openairdocs.org/ntsb/DEN68F0179.md): Cessna 210 · Denver, CO · Accident · Minor injuries · Closed · Dec 29, 1967 · N6641X · Destroyed
- [NTSB CHI68F0519](https://openairdocs.org/ntsb/CHI68F0519.md): Cessna 182 · Greencastle, IN · Accident · Minor injuries · Closed · Dec 27, 1967 · N5081D · Destroyed
- [NTSB LAX68F0260](https://openairdocs.org/ntsb/LAX68F0260.md): Cessna 140 · Redlands, CA · Accident · Serious injuries · Closed · Dec 25, 1967 · N72100 · Destroyed
- [NTSB CHI68D0525](https://openairdocs.org/ntsb/CHI68D0525.md): Cessna 182 · Roscoe, IL · Accident · Minor injuries · Closed · Dec 25, 1967 · N2482G · Substantial damage
- [NTSB OAK68D0340](https://openairdocs.org/ntsb/OAK68D0340-201100.md): Cessna 182 · Fair Oaks, CA · Accident · Minor injuries · Closed · Dec 24, 1967 · N4924D · Substantial damage
- [NTSB FTW68D0409](https://openairdocs.org/ntsb/FTW68D0409.md): Beech A23 · Lamesa, TX · Accident · No injuries · Closed · Dec 24, 1967 · N5769V · Substantial damage
- [NTSB MKC68A0041](https://openairdocs.org/ntsb/MKC68A0041.md): Brantly B-2A · Gordon, NE · Accident · No injuries · Closed · Dec 23, 1967 · N5918X · Destroyed
- [NTSB LAX68D0253](https://openairdocs.org/ntsb/LAX68D0253.md): Dehaviland DHC-2 · Llano, CA · Incident · No injuries · Closed · Dec 23, 1967 · CF-ROM · Substantial damage
- [NTSB NYC68D0317](https://openairdocs.org/ntsb/NYC68D0317.md): Cessna 337 · Belle Vernon, PA · Accident · No injuries · Closed · Dec 22, 1967 · N2464S · Substantial damage
- [NTSB FTW68F0408](https://openairdocs.org/ntsb/FTW68F0408.md): Cessna 150 · Angleton, TX · Accident · Minor injuries · Closed · Dec 22, 1967 · N8898S · Destroyed
- [NTSB CHI68F0512](https://openairdocs.org/ntsb/CHI68F0512.md): Beech D18S · Beloit, IL · Accident · Serious injuries · Closed · Dec 22, 1967 · N120R · Substantial damage
- [NTSB OAK68D0314](https://openairdocs.org/ntsb/OAK68D0314.md): Piper PA-22 · Travis Afb, CA · Accident · No injuries · Closed · Dec 21, 1967 · N4901Z · Substantial damage
- [NTSB FTW68A0063](https://openairdocs.org/ntsb/FTW68A0063.md): Piper PA-24 · Manvel, TX · Accident · 1 fatal · Closed · Dec 19, 1967 · N6885P · Destroyed
- [NTSB MIA68F0371](https://openairdocs.org/ntsb/MIA68F0371.md): Piper PA-28 · Hialeah, FL · Accident · No injuries · Closed · Dec 17, 1967 · N6801W · Substantial damage
- [NTSB NYC68A0079](https://openairdocs.org/ntsb/NYC68A0079.md): Piper PA-28 · Bridgeport, CT · Accident · 4 fatal · Closed · Dec 16, 1967 · N9736J · Destroyed
- [NTSB MKC68F0391](https://openairdocs.org/ntsb/MKC68F0391.md): Cessna 150 · Rosemount, MN · Accident · Minor injuries · Closed · Dec 16, 1967 · N2484J · Substantial damage
- [NTSB CHI68F0501](https://openairdocs.org/ntsb/CHI68F0501.md): Beech K35 · Wheeling, IL · Accident · Minor injuries · Closed · Dec 16, 1967 · N801R · Substantial damage
- [NTSB ANC68F0074](https://openairdocs.org/ntsb/ANC68F0074.md): Piper PA-18 · Sitka, AK · Accident · No injuries · Closed · Dec 16, 1967 · N4581A · Substantial damage
- [NTSB NYC68F0330](https://openairdocs.org/ntsb/NYC68F0330.md): Beech T-34 · Butler, PA · Accident · 1 fatal · Closed · Dec 15, 1967 · N9182R · Destroyed
- [NTSB OAK68A0050](https://openairdocs.org/ntsb/OAK68A0050.md): Bell 47J-2A · Hanalei, HI · Accident · 2 fatal · Closed · Dec 13, 1967 · N8501F · Destroyed
- [NTSB NYC68F0321](https://openairdocs.org/ntsb/NYC68F0321.md): Beech D18S · New Cumberland, PA · Accident · Minor injuries · Closed · Dec 12, 1967 · N5869C · Destroyed
- [NTSB MIA68A0054](https://openairdocs.org/ntsb/MIA68A0054.md): Aero Comdr 560E · Kingshill, VI · Accident · 2 fatal · Closed · Dec 12, 1967 · N8448C · Destroyed
- [NTSB OAK68D0248](https://openairdocs.org/ntsb/OAK68D0248.md): Beech H35 · Monterey, CA · Accident · No injuries · Closed · Dec 11, 1967 · N4634D · Substantial damage
- [NTSB SEA68A0043](https://openairdocs.org/ntsb/SEA68A0043.md): Piper PA-24 · Seattle, WA · Accident · No injuries · Closed · Dec 10, 1967 · N6091P · Substantial damage
- [NTSB CHI68A0053](https://openairdocs.org/ntsb/CHI68A0053.md): Beech H18 · Madison, WI · Accident · 7 fatal · Closed · Dec 10, 1967 · N390R · Destroyed
- [NTSB NYC68F0328](https://openairdocs.org/ntsb/NYC68F0328-201099.md): Piper PA-28 · Ronkonkoma, NY · Accident · Minor injuries · Closed · Dec 9, 1967 · N4101J · Substantial damage
- [NTSB LAX68D0235](https://openairdocs.org/ntsb/LAX68D0235.md): Cassna 182 · Escondido, CA · Accident · No injuries · Closed · Dec 9, 1967 · N5966B · Substantial damage
- [NTSB CHI68F0496](https://openairdocs.org/ntsb/CHI68F0496.md): Cessna 150 · Columbus, OH · Accident · No injuries · Closed · Dec 9, 1967 · N374LA · Substantial damage
- [NTSB CHI68A0052](https://openairdocs.org/ntsb/CHI68A0052.md): Hughes 269B · Evansville, IN · Accident · 2 fatal · Closed · Dec 9, 1967 · N9454F · Destroyed
- [NTSB OAK68D0237](https://openairdocs.org/ntsb/OAK68D0237.md): Cessna 182 · Oroville, CA · Accident · No injuries · Closed · Dec 8, 1967 · N3433U · Substantial damage
- [NTSB CHI68F0598](https://openairdocs.org/ntsb/CHI68F0598.md): Piper PA-32 · Wauwatosa, WI · Accident · Serious injuries · Closed · Dec 8, 1967 · N3437W · Substantial damage
- [NTSB MIA68F0350](https://openairdocs.org/ntsb/MIA68F0350.md): Beech C-45H · Miami, FL · Accident · No injuries · Closed · Dec 7, 1967 · N9169Z · Substantial damage
- [NTSB MKC68D0378](https://openairdocs.org/ntsb/MKC68D0378.md): Cessna 150 · Creve Coeur, MO · Accident · No injuries · Closed · Dec 6, 1967 · N3457J · Substantial damage
- [NTSB LAX68D0223](https://openairdocs.org/ntsb/LAX68D0223.md): Piper J-3 · Filmore, CA · Accident · No injuries · Closed · Dec 6, 1967 · N21506 · Substantial damage
- [NTSB CHI68F0499](https://openairdocs.org/ntsb/CHI68F0499.md): Piper PA-30 · Lowell, MI · Accident · 1 fatal · Closed · Dec 6, 1967 · N8071Y · Destroyed
- [NTSB DIA68A0025](https://openairdocs.org/ntsb/DIA68A0025.md): Cessna 310F · Norfolk, VA · Accident · 2 fatal · Closed · Dec 5, 1967 · N6704X · Destroyed
- [NTSB DEN68D0163](https://openairdocs.org/ntsb/DEN68D0163.md): Cessna 150 · Gillette, WY · Accident · No injuries · Closed · Dec 5, 1967 · N8183F · Substantial damage
- [NTSB CHI68F0452](https://openairdocs.org/ntsb/CHI68F0452.md): Piper PA-28 · Ann Arbor, MI · Accident · No injuries · Closed · Dec 5, 1967 · N6459R · Substantial damage
- [NTSB OAK68A0048](https://openairdocs.org/ntsb/OAK68A0048.md): Piper PA-23 · Reno, NV · Accident · 1 fatal · Closed · Dec 4, 1967 · N5853Y · Destroyed
- [NTSB OAK68D0252](https://openairdocs.org/ntsb/OAK68D0252.md): N.American SNJ-B5 · Honolulu, HI · Accident · No injuries · Closed · Dec 2, 1967 · N3163G · Substantial damage
- [NTSB OAK68D0246](https://openairdocs.org/ntsb/OAK68D0246.md): Snow S2C · Tranquillty, CA · Accident · No injuries · Closed · Dec 2, 1967 · N1661S · Substantial damage
- [NTSB DEN68D0149](https://openairdocs.org/ntsb/DEN68D0149.md): Cessna 310 · Grand Junct, CO · Accident · No injuries · Closed · Dec 1, 1967 · N5266A · Substantial damage
- [NTSB DEN68D0162](https://openairdocs.org/ntsb/DEN68D0162.md): Cessna 182 · Hobbs, NM · Accident · No injuries · Closed · Nov 30, 1967 · N5626B · Substantial damage
- [NTSB OAK68D0224](https://openairdocs.org/ntsb/OAK68D0224.md): Cessna 421 · Salinas, CA · Accident · Minor injuries · Closed · Nov 29, 1967 · N4005L · Substantial damage
- [NTSB MIA68D0311](https://openairdocs.org/ntsb/MIA68D0311.md): Cessna 170A · Tampa, FL · Accident · No injuries · Closed · Nov 29, 1967 · N1111F · Substantial damage
- [NTSB MIA68A0053](https://openairdocs.org/ntsb/MIA68A0053.md): Lear Jet 23 · Orlando, FL · Accident · 3 fatal · Closed · Nov 29, 1967 · N690L · Destroyed
- [NTSB DIA68D0171](https://openairdocs.org/ntsb/DIA68D0171.md): Mooney M20C · Fairmont, WV · Accident · No injuries · Closed · Nov 29, 1967 · N2940L · Substantial damage

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

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

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