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

## Cases, newest first

- [NTSB UNK68X0127](https://openairdocs.org/ntsb/UNK68X0127.md): Beech S35 · R Buena Vista, Mexico · Accident · No injuries · Closed · Mar 22, 1968 · N233BT · Substantial damage
- [NTSB FTW68F0511](https://openairdocs.org/ntsb/FTW68F0511.md): Aero Comdr 560 · Hilltop, TX · Accident · Serious injuries · Closed · Mar 22, 1968 · N855LB · Destroyed
- [NTSB DIA68D0186](https://openairdocs.org/ntsb/DIA68D0186.md): Cessna 172 · Rose Hill, NC · Accident · No injuries · Closed · Mar 22, 1968 · N6342E · Substantial damage
- [NTSB NYC68A0109](https://openairdocs.org/ntsb/NYC68A0109.md): Cessna 177 · Ronkonkoma, NY · Accident · 1 fatal · Closed · Mar 19, 1968 · N248K · Destroyed
- [NTSB MIA68F0462](https://openairdocs.org/ntsb/MIA68F0462.md): Cessna 150H · Ft.Lauderdale, FL · Accident · No injuries · Closed · Mar 19, 1968 · N6666S · Substantial damage
- [NTSB UNK68X0126](https://openairdocs.org/ntsb/UNK68X0126.md): Bellanca 14-13 · Mazatlan, Mexico · Accident · 1 fatal · Closed · Mar 17, 1968 · N86749 · Destroyed
- [NTSB MKC68F0529](https://openairdocs.org/ntsb/MKC68F0529.md): Piper PA-28 · Kearney, MO · Accident · Minor injuries · Closed · Mar 17, 1968 · N6906W · Destroyed
- [NTSB MKC68A0056](https://openairdocs.org/ntsb/MKC68A0056.md): Beech E18S · Rapid City, SD · Accident · 9 fatal · Closed · Mar 17, 1968 · N3400 · Destroyed
- [NTSB CHI68A0082](https://openairdocs.org/ntsb/CHI68A0082.md): Piper PA-30 · Alton, IL · Accident · 2 fatal · Closed · Mar 16, 1968 · N7643Y · Destroyed
- [NTSB DIA68F0183](https://openairdocs.org/ntsb/DIA68F0183.md): Erco 415-C · Gaithersburg, MD · Accident · No injuries · Closed · Mar 15, 1968 · N2541H · Substantial damage
- [NTSB OAK68D0328](https://openairdocs.org/ntsb/OAK68D0328.md): Cessna 150 · Fair Oaks, CA · Accident · Minor injuries · Closed · Mar 14, 1968 · N3171X · Destroyed
- [NTSB DIA68A0037](https://openairdocs.org/ntsb/DIA68A0037.md): M.Dessault Falcon · Parkersburg, WV · Accident · 6 fatal · Closed · Mar 13, 1968 · N1846 · Destroyed
- [NTSB SEA68F0278](https://openairdocs.org/ntsb/SEA68F0278.md): Cessna 150 · Dillard, OR · Accident · Minor injuries · Closed · Mar 11, 1968 · N3099S · Substantial damage
- [NTSB MIA68A0076](https://openairdocs.org/ntsb/MIA68A0076.md): Cessna 150G · Columbus, GA · Accident · 2 fatal · Closed · Mar 9, 1968 · N3037S · Destroyed
- [NTSB MIA68A0075](https://openairdocs.org/ntsb/MIA68A0075.md): Beech 35 · Troy, AL · Accident · 1 fatal · Closed · Mar 9, 1968 · N5148C · Destroyed
- [NTSB CHI68F0615](https://openairdocs.org/ntsb/CHI68F0615.md): Piper PA-28 · Orleans, IN · Accident · Minor injuries · Closed · Mar 7, 1968 · N3237W · Destroyed
- [NTSB MIA68D0443](https://openairdocs.org/ntsb/MIA68D0443.md): Aeronca 7AC · Mckinnon, TN · Accident · Minor injuries · Closed · Mar 6, 1968 · N82506 · Substantial damage
- [NTSB FTW68D0485](https://openairdocs.org/ntsb/FTW68D0485.md): Piper PA-18 · Mer Rouge, LA · Accident · Minor injuries · Closed · Mar 6, 1968 · N3883Z · Destroyed
- [NTSB OAK68D0313](https://openairdocs.org/ntsb/OAK68D0313.md): Cessna 182 · Santa Cruz, CA · Accident · Minor injuries · Closed · Mar 3, 1968 · N5097D · Substantial damage
- [NTSB NYC68D0395](https://openairdocs.org/ntsb/NYC68D0395.md): Beech A23 · Dunkirk, NY · Accident · Minor injuries · Closed · Mar 3, 1968 · N3586R · Substantial damage
- [NTSB MKC68F0485](https://openairdocs.org/ntsb/MKC68F0485.md): Cessna 120 · Papillion, NE · Accident · No injuries · Closed · Mar 3, 1968 · N81044 · Substantial damage
- [NTSB MKC68A0055](https://openairdocs.org/ntsb/MKC68A0055.md): Cessna 177 · Beaumdnt, KS · Accident · 2 fatal · Closed · Mar 3, 1968 · N2327Y · Destroyed
- [NTSB LAX68D0357](https://openairdocs.org/ntsb/LAX68D0357.md): Beech P35 · Thermal, CA · Accident · No injuries · Closed · Mar 3, 1968 · N713WB · Substantial damage
- [NTSB LAX68A0083](https://openairdocs.org/ntsb/LAX68A0083.md): Beech 35-B33 · Fullerton, CA · Accident · 3 fatal · Closed · Mar 3, 1968 · N8966M · Destroyed
- [NTSB LAX68F0325](https://openairdocs.org/ntsb/LAX68F0325.md): Cessna 150 · San Diego, CA · Accident · No injuries · Closed · Feb 29, 1968 · N5836E · Substantial damage
- [NTSB FTW68D0471](https://openairdocs.org/ntsb/FTW68D0471.md): Piper PA-28 · Lubbock, TX · Accident · No injuries · Closed · Feb 27, 1968 · N8236W · Substantial damage
- [NTSB CHI68A0077](https://openairdocs.org/ntsb/CHI68A0077.md): Hughes 269B · Sinking Spgs, OH · Accident · Serious injuries · Closed · Feb 27, 1968 · N9406F · Destroyed
- [NTSB DEN68F0221](https://openairdocs.org/ntsb/DEN68F0221.md): Piper PA-32 · Douglas, WY · Accident · 1 fatal · Closed · Feb 26, 1968 · N4090W · Destroyed
- [NTSB OAK68F0326](https://openairdocs.org/ntsb/OAK68F0326.md): Taylorcraft BC12-D · San Jose, CA · Accident · No injuries · Closed · Feb 25, 1968 · N43420 · 2 aircraft · Substantial damage
- [NTSB MKC68D0475](https://openairdocs.org/ntsb/MKC68D0475.md): Piper J3 · Kingman, KS · Accident · Minor injuries · Closed · Feb 25, 1968 · N92067 · Substantial damage
- [NTSB MIA68A0070](https://openairdocs.org/ntsb/MIA68A0070.md): Beech 35 · Charleston, SC · Accident · 1 fatal · Closed · Feb 25, 1968 · N3206V · Destroyed
- [NTSB LAX68F0321](https://openairdocs.org/ntsb/LAX68F0321.md): Callair A-3 · Elsinore, CA · Accident · 1 fatal · Closed · Feb 25, 1968 · N2900V · Destroyed
- [NTSB LAX68D0345](https://openairdocs.org/ntsb/LAX68D0345.md): Cessna 170 · Lakeside, CA · Accident · No injuries · Closed · Feb 25, 1968 · N9268A · Substantial damage
- [NTSB SEA68A0055](https://openairdocs.org/ntsb/SEA68A0055.md): Beech D18S · Ferndale, WA · Accident · 2 fatal · Closed · Feb 24, 1968 · N4545 · 2 aircraft · Substantial damage
- [NTSB MKC68D0521](https://openairdocs.org/ntsb/MKC68D0521.md): Beech 35 · Grain Valley, MO · Accident · No injuries · Closed · Feb 24, 1968 · N3877N · Substantial damage
- [NTSB LAX68D0364](https://openairdocs.org/ntsb/LAX68D0364.md): Cessna 150G · Torrance, CA · Accident · No injuries · Closed · Feb 24, 1968 · N3770J · Substantial damage
- [NTSB CHI68D0360](https://openairdocs.org/ntsb/CHI68D0360.md): Piper PA-22 · Platteville, WI · Accident · No injuries · Closed · Feb 24, 1968 · N3820P · Substantial damage
- [NTSB NYC68D0387](https://openairdocs.org/ntsb/NYC68D0387.md): Piper PA-24 · Stratford, CT · Accident · No injuries · Closed · Feb 23, 1968 · N870W · Substantial damage
- [NTSB CHI68F0608](https://openairdocs.org/ntsb/CHI68F0608.md): Beech C-45H · Chicago, IL · Accident · No injuries · Closed · Feb 23, 1968 · N9943Z · Destroyed
- [NTSB FTW68D0463](https://openairdocs.org/ntsb/FTW68D0463.md): Piper PA-11 · El Paso, TX · Accident · No injuries · Closed · Feb 21, 1968 · N4512M · Substantial damage
- [NTSB CHI68A0075](https://openairdocs.org/ntsb/CHI68A0075.md): Beech E35 · Springfield, IL · Accident · 3 fatal · Closed · Feb 20, 1968 · N7380B · Destroyed
- [NTSB CHI68A0074](https://openairdocs.org/ntsb/CHI68A0074.md): Piper PA-28 · Ranklin, IN · Accident · 2 fatal · Closed · Feb 18, 1968 · N9516W · 2 aircraft · Destroyed
- [NTSB CHI68A0073](https://openairdocs.org/ntsb/CHI68A0073.md): Beech 35 · Crestwood, IL · Accident · 2 fatal · Closed · Feb 18, 1968 · N4532V · Destroyed
- [NTSB NYC68F0392](https://openairdocs.org/ntsb/NYC68F0392.md): Piper PA-28 · Shrewsbury, NJ · Accident · No injuries · Closed · Feb 16, 1968 · N9136W · Substantial damage
- [NTSB MIA68F0431](https://openairdocs.org/ntsb/MIA68F0431.md): Cessna 150 · Balboa, St. Pierre & Miquelon · Accident · 1 fatal · Closed · Feb 16, 1968 · N8469G · Destroyed
- [NTSB OAK68D0285](https://openairdocs.org/ntsb/OAK68D0285.md): Cessna 150 · San Jose, CA · Accident · Minor injuries · Closed · Feb 15, 1968 · N6472F · Substantial damage
- [NTSB CHI68D0597](https://openairdocs.org/ntsb/CHI68D0597.md): Aeronca 7AC · Princeton, KY · Accident · No injuries · Closed · Feb 13, 1968 · N85783 · Substantial damage
- [NTSB DEN68D0238](https://openairdocs.org/ntsb/DEN68D0238.md): Piper PA-22 · Clovis, NM · Accident · Minor injuries · Closed · Feb 12, 1968 · N3720Z · Substantial damage
- [NTSB FTW68D0442](https://openairdocs.org/ntsb/FTW68D0442.md): Schweizer SGS126 · Rockwall, TX · Accident · No injuries · Closed · Feb 11, 1968 · N8682R · Substantial damage
- [NTSB DEN68F0211](https://openairdocs.org/ntsb/DEN68F0211.md): Cessna 177 · Las Cruces, NM · Accident · Serious injuries · Closed · Feb 11, 1968 · N2287Y · Substantial damage

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

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

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