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

## Cases, newest first

- [NTSB MKC68A0027](https://openairdocs.org/ntsb/MKC68A0027.md): Douglas DC-6A · Kansas City, MO · Accident · No injuries · Closed · Oct 5, 1967 · N34956 · Substantial damage
- [NTSB MIA68F0233](https://openairdocs.org/ntsb/MIA68F0233.md): Luscombe 8A · Mcintosh, FL · Accident · Minor injuries · Closed · Oct 5, 1967 · N72075 · Substantial damage
- [NTSB CHI68F0327](https://openairdocs.org/ntsb/CHI68F0327.md): Erco 415-C · New Hudson, MI · Accident · No injuries · Closed · Oct 5, 1967 · N99008 · Substantial damage
- [NTSB MKC68F0292](https://openairdocs.org/ntsb/MKC68F0292.md): Piper PA-22 · New Town, ND · Accident · No injuries · Closed · Oct 3, 1967 · N3560A · Substantial damage
- [NTSB NYC68D0168](https://openairdocs.org/ntsb/NYC68D0168.md): Cessna 150 · Mansfield, MA · Accident · Minor injuries · Closed · Oct 2, 1967 · N5841E · Destroyed
- [NTSB LAX68F0149](https://openairdocs.org/ntsb/LAX68F0149.md): Cessna 310L · Sepulveda, CA · Accident · No injuries · Closed · Oct 2, 1967 · N2252F · Substantial damage
- [NTSB CHI68F0395](https://openairdocs.org/ntsb/CHI68F0395.md): Piper PA-28 · Knox, IN · Accident · No injuries · Closed · Oct 2, 1967 · N7946W · Substantial damage
- [NTSB SEA68A0030](https://openairdocs.org/ntsb/SEA68A0030.md): Cessna 206 · Decatur, WA · Accident · No injuries · Closed · Oct 1, 1967 · N8041Z · Substantial damage
- [NTSB LAX68A0038](https://openairdocs.org/ntsb/LAX68A0038.md): Hughes 269B · Corona, CA · Accident · No injuries · Closed · Oct 1, 1967 · N9329F · Substantial damage
- [NTSB FTW68F0291](https://openairdocs.org/ntsb/FTW68F0291.md): Cessna 150 · Conroe, TX · Accident · No injuries · Closed · Oct 1, 1967 · N6490F · Substantial damage
- [NTSB FTW68F0244](https://openairdocs.org/ntsb/FTW68F0244.md): Piper PA-28 · Tulsa, OK · Accident · Serious injuries · Closed · Oct 1, 1967 · N6721W · Substantial damage
- [NTSB NYC68D0179](https://openairdocs.org/ntsb/NYC68D0179.md): Piper PA-24 · Hackettstown, NJ · Accident · No injuries · Closed · Sep 30, 1967 · N6663P · Substantial damage
- [NTSB FTW68F0308](https://openairdocs.org/ntsb/FTW68F0308.md): Piper PA-32 · Tomball, TX · Accident · No injuries · Closed · Sep 30, 1967 · N3452W · Substantial damage
- [NTSB FTW68D0026](https://openairdocs.org/ntsb/FTW68D0026-113965.md): Cessna 150E · Mill Creek, OK · Accident · No injuries · Closed · Sep 30, 1967 · N6251T · Substantial damage
- [NTSB CHI68F0330](https://openairdocs.org/ntsb/CHI68F0330.md): Navion A · Louisville, KY · Accident · No injuries · Closed · Sep 30, 1967 · N4222K · Destroyed
- [NTSB OAK68F0171](https://openairdocs.org/ntsb/OAK68F0171.md): Beech E35 · Reno, NV · Accident · Minor injuries · Closed · Sep 29, 1967 · N7368B · Substantial damage
- [NTSB NYC68A0053](https://openairdocs.org/ntsb/NYC68A0053.md): Piper PA-28 · Milford, NY · Accident · 4 fatal · Closed · Sep 29, 1967 · N9590J · Destroyed
- [NTSB MKC68F0263](https://openairdocs.org/ntsb/MKC68F0263.md): Cessna 150 · Omaha, NE · Accident · Minor injuries · Closed · Sep 29, 1967 · N7958Z · Substantial damage
- [NTSB FTW68A0036](https://openairdocs.org/ntsb/FTW68A0036.md): Aero Comdr 560E · Dallas, TX · Accident · 7 fatal · Closed · Sep 27, 1967 · N3831C · Destroyed
- [NTSB SEA68D0219](https://openairdocs.org/ntsb/SEA68D0219.md): Taylorcraft BL-12 · Sandy, OR · Accident · Minor injuries · Closed · Sep 26, 1967 · N34036 · Destroyed
- [NTSB CHI68D0410](https://openairdocs.org/ntsb/CHI68D0410.md): Piper PA-28 · Salem, OH · Accident · No injuries · Closed · Sep 25, 1967 · N7477R · Substantial damage
- [NTSB LAX68A0036](https://openairdocs.org/ntsb/LAX68A0036.md): Piper PA-24 · Mesquite, NV · Accident · 2 fatal · Closed · Sep 24, 1967 · N6198P · Destroyed
- [NTSB DIA68D0084](https://openairdocs.org/ntsb/DIA68D0084.md): Waco RNF · Huntington, MD · Accident · No injuries · Closed · Sep 24, 1967 · N11206 · Substantial damage
- [NTSB MIA68F0218](https://openairdocs.org/ntsb/MIA68F0218.md): Piper PA-22 · Humacao, PR · Accident · No injuries · Closed · Sep 23, 1967 · N5278Z · Substantial damage
- [NTSB CHI68F0345](https://openairdocs.org/ntsb/CHI68F0345.md): Scheibe Spatz · Marion, OH · Accident · Serious injuries · Closed · Sep 23, 1967 · N247RH · Substantial damage
- [NTSB DIA68A0013](https://openairdocs.org/ntsb/DIA68A0013.md): Aeronca 7AC · Harkers Is., NC · Accident · 1 fatal · Closed · Sep 22, 1967 · N85297 · Destroyed
- [NTSB OAK68F0130](https://openairdocs.org/ntsb/OAK68F0130.md): Cessna 172 · Fresno, CA · Accident · No injuries · Closed · Sep 21, 1967 · N6079R · Substantial damage
- [NTSB DIA68F0098](https://openairdocs.org/ntsb/DIA68F0098-201113.md): Cessna 150 · Henderson, NC · Accident · Serious injuries · Closed · Sep 21, 1967 · N5685E · Destroyed
- [NTSB NYC68A0048](https://openairdocs.org/ntsb/NYC68A0048.md): Cessna 150 · Vincentown, NJ · Accident · 1 fatal · Closed · Sep 20, 1967 · N8627S · Destroyed
- [NTSB LAX68D0131](https://openairdocs.org/ntsb/LAX68D0131.md): Cessna 170B · Elsinore, CA · Accident · No injuries · Closed · Sep 20, 1967 · N2327D · Substantial damage
- [NTSB SEA68F0164](https://openairdocs.org/ntsb/SEA68F0164.md): Beech C35 · Forks, WA · Accident · Minor injuries · Closed · Sep 19, 1967 · N773D · Substantial damage
- [NTSB NYC68D0192](https://openairdocs.org/ntsb/NYC68D0192.md): Cessna 180 · New City, NY · Accident · No injuries · Closed · Sep 19, 1967 · N3164D · Substantial damage
- [NTSB FTW68A0041](https://openairdocs.org/ntsb/FTW68A0041.md): Cessna 185 · New Orleans, LA · Accident · No injuries · Closed · Sep 19, 1967 · N4718Q · Substantial damage
- [NTSB NYC68F0177](https://openairdocs.org/ntsb/NYC68F0177.md): Cessna 150C · Monroeville, PA · Accident · No injuries · Closed · Sep 18, 1967 · N7895Z · Substantial damage
- [NTSB MKC68F0352](https://openairdocs.org/ntsb/MKC68F0352.md): Piper PA-28 · Chesterfield, MO · Accident · Minor injuries · Closed · Sep 18, 1967 · N9764W · Substantial damage
- [NTSB CHI68F0325](https://openairdocs.org/ntsb/CHI68F0325.md): Cessna 210 · Freeport, IL · Accident · No injuries · Closed · Sep 18, 1967 · N7475E · Substantial damage
- [NTSB SEA68F0227](https://openairdocs.org/ntsb/SEA68F0227.md): Cessna 180 · Orchards, WA · Accident · Serious injuries · Closed · Sep 17, 1967 · N1793C · Destroyed
- [NTSB MIA68D0193](https://openairdocs.org/ntsb/MIA68D0193.md): Taylorcraft BC12 · Millry, AL · Accident · No injuries · Closed · Sep 17, 1967 · N34238 · Substantial damage
- [NTSB SEA68A0027](https://openairdocs.org/ntsb/SEA68A0027.md): Cessna 172 · Portland, OR · Accident · 1 fatal · Closed · Sep 16, 1967 · N5907A · Destroyed
- [NTSB LAX68F0170](https://openairdocs.org/ntsb/LAX68F0170.md): Cessna 150G · Torrance, CA · Accident · No injuries · Closed · Sep 16, 1967 · N8346J · Substantial damage
- [NTSB CHI68F0341](https://openairdocs.org/ntsb/CHI68F0341.md): N.American P-51 · Hastings, MI · Accident · Minor injuries · Closed · Sep 16, 1967 · N251D · Destroyed
- [NTSB SEA68D0216](https://openairdocs.org/ntsb/SEA68D0216.md): Piper PA-24 · Bandon, OR · Accident · No injuries · Closed · Sep 14, 1967 · N8899P · Destroyed
- [NTSB NYC68A0043](https://openairdocs.org/ntsb/NYC68A0043.md): Piper PA-28 · Poestenkill, NY · Accident · 1 fatal · Closed · Sep 13, 1967 · N7406R · Substantial damage
- [NTSB MIA68F0216](https://openairdocs.org/ntsb/MIA68F0216.md): Cessna 150 · Hazel Green, AL · Accident · Serious injuries · Closed · Sep 13, 1967 · N2206J · Substantial damage
- [NTSB MKC68F0230](https://openairdocs.org/ntsb/MKC68F0230.md): Piper PA-16 · Oskaloosa, IA · Accident · Serious injuries · Closed · Sep 12, 1967 · N5310H · Destroyed
- [NTSB LAX68A0030](https://openairdocs.org/ntsb/LAX68A0030.md): Piper PA-24 · Avalon Sci, CA · Accident · 4 fatal · Closed · Sep 12, 1967 · N5638P · Destroyed
- [NTSB NYC68D0166](https://openairdocs.org/ntsb/NYC68D0166.md): Schweizer SGU222 · West Chester, PA · Accident · No injuries · Closed · Sep 11, 1967 · N9918J · Substantial damage
- [NTSB ANC68F0093](https://openairdocs.org/ntsb/ANC68F0093.md): Cessna 175 · Pilot Point, AK · Accident · Serious injuries · Closed · Sep 11, 1967 · N7317M · Substantial damage
- [NTSB SEA68F0123](https://openairdocs.org/ntsb/SEA68F0123.md): Beech C35 · Cle Elum, WA · Accident · Minor injuries · Closed · Sep 10, 1967 · N5927C · Substantial damage
- [NTSB NYC68D0182](https://openairdocs.org/ntsb/NYC68D0182.md): Cessna 170B · Croton, NY · Accident · No injuries · Closed · Sep 10, 1967 · N2793D · Substantial damage

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

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

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