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

## Cases, newest first

- [NTSB NYC69D0049](https://openairdocs.org/ntsb/NYC69D0049.md): Schweizer SGS233 · Dansville, NY · Accident · Minor injuries · Closed · Jun 22, 1968 · N2436W · Destroyed
- [NTSB DEN69D0047](https://openairdocs.org/ntsb/DEN69D0047.md): Beech A23-19 · Boulder, CO · Accident · No injuries · Closed · Jun 22, 1968 · N4729J · Substantial damage
- [NTSB MKC69F0040](https://openairdocs.org/ntsb/MKC69F0040-201083.md): Beech V35 · Intl Falls, MN · Accident · No injuries · Closed · Jun 18, 1968 · N9576Q · Substantial damage
- [NTSB MKC68F0602](https://openairdocs.org/ntsb/MKC68F0602.md): Cessna 177 · Ulysses, KS · Accident · No injuries · Closed · Jun 18, 1968 · N2865X · Substantial damage
- [NTSB DEN69F0004](https://openairdocs.org/ntsb/DEN69F0004.md): Piper PA-28 · Salt Lake City, UT · Accident · Serious injuries · Closed · Jun 17, 1968 · N9513W · Substantial damage
- [NTSB CHI69D0039](https://openairdocs.org/ntsb/CHI69D0039.md): Cessna 172F · Romeo, MI · Accident · No injuries · Closed · Jun 17, 1968 · N7935U · Substantial damage
- [NTSB MKC69D0036](https://openairdocs.org/ntsb/MKC69D0036.md): Piper PA-22 · Lemmon, SD · Accident · Minor injuries · Closed · Jun 16, 1968 · N1489C · Substantial damage
- [NTSB DEN69D0027](https://openairdocs.org/ntsb/DEN69D0027.md): Schweizer 2-33 · Heber City, UT · Accident · No injuries · Closed · Jun 16, 1968 · N2459W · Substantial damage
- [NTSB DEN69D0017](https://openairdocs.org/ntsb/DEN69D0017.md): Beech J35 · Spanish Fork, UT · Accident · Minor injuries · Closed · Jun 16, 1968 · N735B · Substantial damage
- [NTSB LAX69F0031](https://openairdocs.org/ntsb/LAX69F0031.md): Hutchinson VHS-1 · Adelanto, CA · Accident · Serious injuries · Closed · Jun 15, 1968 · N4624V · Destroyed
- [NTSB DEN68A0058](https://openairdocs.org/ntsb/DEN68A0058.md): Mooney M20F · Toponas, CO · Accident · 1 fatal · Closed · Jun 15, 1968 · N9509M · Destroyed
- [NTSB OAK69F0121](https://openairdocs.org/ntsb/OAK69F0121.md): Cessna 182A · Las Vegas, NV · Accident · No injuries · Closed · Jun 14, 1968 · N2226G · Substantial damage
- [NTSB OAK68A0072](https://openairdocs.org/ntsb/OAK68A0072.md): Cessna 177 · Bass Lake, CA · Accident · 4 fatal · Closed · Jun 14, 1968 · N2914X · Destroyed
- [NTSB NYC69D0080](https://openairdocs.org/ntsb/NYC69D0080.md): Aeronca 11AC · Memphis, NY · Accident · No injuries · Closed · Jun 14, 1968 · N9010E · Substantial damage
- [NTSB FTW69D0029](https://openairdocs.org/ntsb/FTW69D0029.md): Lake LA-4 · Clayton, LA · Accident · No injuries · Closed · Jun 14, 1968 · N7603L · Substantial damage
- [NTSB CHI69F0043](https://openairdocs.org/ntsb/CHI69F0043.md): Cessna 320E · Wheeling, IL · Accident · No injuries · Closed · Jun 12, 1968 · N600SM · Substantial damage
- [NTSB FTW69F0025](https://openairdocs.org/ntsb/FTW69F0025.md): Beech 65 · Garland, TX · Accident · Minor injuries · Closed · Jun 10, 1968 · N342N · Substantial damage
- [NTSB SEA68D0328](https://openairdocs.org/ntsb/SEA68D0328.md): Schweizer 222E · Horseshoe Bend, ID · Accident · No injuries · Closed · Jun 9, 1968 · N9943J · Substantial damage
- [NTSB MKC69D0030](https://openairdocs.org/ntsb/MKC69D0030.md): Piper PA-32 · State Center, IA · Accident · No injuries · Closed · Jun 9, 1968 · N3649W · Substantial damage
- [NTSB LAX69D0028](https://openairdocs.org/ntsb/LAX69D0028.md): Cessna 150 · Scottsdale, AZ · Accident · No injuries · Closed · Jun 9, 1968 · N7892F · Substantial damage
- [NTSB LAX69D0024](https://openairdocs.org/ntsb/LAX69D0024.md): Cessna 150 · Hemet, CA · Accident · No injuries · Closed · Jun 9, 1968 · N1908Z · Substantial damage
- [NTSB ANC69D0016](https://openairdocs.org/ntsb/ANC69D0016.md): Taylorcraft BC-65 · Iliamna, AK · Accident · No injuries · Closed · Jun 9, 1968 · N29560 · Substantial damage
- [NTSB SEA69D0016](https://openairdocs.org/ntsb/SEA69D0016.md): Beech A23 · Vashon Is., WA · Accident · No injuries · Closed · Jun 8, 1968 · N3507R · Substantial damage
- [NTSB NYC69D0037](https://openairdocs.org/ntsb/NYC69D0037.md): Schweizer SGS126 · Toughkenamon, PA · Accident · No injuries · Closed · Jun 8, 1968 · N8683R · Substantial damage
- [NTSB MIA69D0262](https://openairdocs.org/ntsb/MIA69D0262.md): Cessna 150F · Albany, GA · Accident · No injuries · Closed · Jun 8, 1968 · N8267S · Substantial damage
- [NTSB CHI69F0086](https://openairdocs.org/ntsb/CHI69F0086.md): Navion B · Cadillac, MI · Accident · Minor injuries · Closed · Jun 8, 1968 · N80U · Substantial damage
- [NTSB MKC68A0070](https://openairdocs.org/ntsb/MKC68A0070.md): Bellanca 14-193 · Kansas City, KS · Accident · Minor injuries · Closed · Jun 7, 1968 · N8513R · Substantial damage
- [NTSB MIA68F0525](https://openairdocs.org/ntsb/MIA68F0525.md): Cessna 150 · Donelson, TN · Accident · No injuries · Closed · Jun 7, 1968 · N2996J · Substantial damage
- [NTSB DIA69F0007](https://openairdocs.org/ntsb/DIA69F0007.md): Piper PA-22 · Chestertown, MD · Accident · Minor injuries · Closed · Jun 7, 1968 · N3637Z · Substantial damage
- [NTSB DEN69F0028](https://openairdocs.org/ntsb/DEN69F0028.md): Boeing E75 · Cody, WY · Accident · 1 fatal · Closed · Jun 7, 1968 · N66305 · Destroyed
- [NTSB NYC68A0129](https://openairdocs.org/ntsb/NYC68A0129.md): Mystere 20 · Reading, PA · Accident · No injuries · Closed · Jun 6, 1968 · N808F · Substantial damage
- [NTSB MKC68F0592](https://openairdocs.org/ntsb/MKC68F0592.md): Piper PA-28 · Grimes, IA · Accident · No injuries · Closed · Jun 6, 1968 · N3989K · Substantial damage
- [NTSB NYC68F0507](https://openairdocs.org/ntsb/NYC68F0507.md): Piper PA-28 · Bridgeville, PA · Accident · No injuries · Closed · Jun 5, 1968 · N9772W · Substantial damage
- [NTSB NYC68F0487](https://openairdocs.org/ntsb/NYC68F0487.md): Piper PA-28 · Slatington, PA · Accident · Minor injuries · Closed · Jun 3, 1968 · N9688W · Substantial damage
- [NTSB NYC68A0126](https://openairdocs.org/ntsb/NYC68A0126.md): Boeing 727 · Flushing, NY · Accident · Serious injuries · Closed · Jun 3, 1968 · N831TW · Substantial damage
- [NTSB CHI69D0076](https://openairdocs.org/ntsb/CHI69D0076.md): Globe GC-1B · Benton, IL · Accident · No injuries · Closed · Jun 3, 1968 · N78181 · Substantial damage
- [NTSB LAX69F0011](https://openairdocs.org/ntsb/LAX69F0011.md): Piper PA-12 · Compton, CA · Accident · Serious injuries · Closed · Jun 2, 1968 · N3876M · Destroyed
- [NTSB CHI68D0783](https://openairdocs.org/ntsb/CHI68D0783.md): Beech S35 · Chicago, IL · Accident · No injuries · Closed · Jun 2, 1968 · N5825K · Substantial damage
- [NTSB FTW69F0007](https://openairdocs.org/ntsb/FTW69F0007.md): Cessna 150 · Carlisle, AR · Accident · No injuries · Closed · May 31, 1968 · N4347U · Substantial damage
- [NTSB MKC68F0605](https://openairdocs.org/ntsb/MKC68F0605.md): Cessna 150 · Lincoln, NE · Accident · No injuries · Closed · May 30, 1968 · N3118J · Substantial damage
- [NTSB DIA69D0027](https://openairdocs.org/ntsb/DIA69D0027.md): Piper PA-32 · Ravenswood, WV · Accident · No injuries · Closed · May 30, 1968 · N3854W · Substantial damage
- [NTSB DIA68D0236](https://openairdocs.org/ntsb/DIA68D0236.md): Cessna 172 · Sykesville, MD · Accident · Minor injuries · Closed · May 30, 1968 · N7064A · Destroyed
- [NTSB NYC68A0128](https://openairdocs.org/ntsb/NYC68A0128.md): Cessna 210 · Middletown, RI · Accident · No injuries · Closed · May 28, 1968 · N6599X · Substantial damage
- [NTSB MKC69D0142](https://openairdocs.org/ntsb/MKC69D0142.md): Piper PA-28 · Osage City, KS · Accident · No injuries · Closed · May 28, 1968 · N4505R · Substantial damage
- [NTSB FTW68F0614](https://openairdocs.org/ntsb/FTW68F0614.md): Cessna 150 · Turrell, AR · Accident · Minor injuries · Closed · May 28, 1968 · N6533S · Substantial damage
- [NTSB MKC68D0601](https://openairdocs.org/ntsb/MKC68D0601.md): Piper PA-24 · Wichita, KS · Accident · No injuries · Closed · May 27, 1968 · N9158P · Substantial damage
- [NTSB FTW68D0596](https://openairdocs.org/ntsb/FTW68D0596.md): Piper J3 · Andrews, LA · Accident · Minor injuries · Closed · May 27, 1968 · N70421 · Substantial damage
- [NTSB CHI68F0777](https://openairdocs.org/ntsb/CHI68F0777.md): Piper PA-30 · Elkhart, IN · Accident · No injuries · Closed · May 27, 1968 · N525PG · Substantial damage
- [NTSB LAX69D0012](https://openairdocs.org/ntsb/LAX69D0012.md): Cessna 170B · Blythe, CA · Accident · No injuries · Closed · May 26, 1968 · N2672D · Substantial damage
- [NTSB NYC68D0486](https://openairdocs.org/ntsb/NYC68D0486.md): Cessna 150 · Prospectville, PA · Accident · Minor injuries · Closed · May 25, 1968 · N8311G · Substantial damage

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

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

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