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

## Cases, newest first

- [NTSB MKC69D0194](https://openairdocs.org/ntsb/MKC69D0194.md): Boeing B75N1 · Mountain Grove, MO · Accident · No injuries · Closed · Jul 19, 1968 · N69246 · Substantial damage
- [NTSB SEA69D0077](https://openairdocs.org/ntsb/SEA69D0077.md): Cessna 172H · Union Creek, OR · Accident · Minor injuries · Closed · Jul 18, 1968 · N8829Z · Destroyed
- [NTSB NYC69D0062](https://openairdocs.org/ntsb/NYC69D0062.md): Piper PA-28 · Edgartown, MA · Accident · Minor injuries · Closed · Jul 17, 1968 · N7304W · Substantial damage
- [NTSB NYC69D0045](https://openairdocs.org/ntsb/NYC69D0045.md): Piper PA-28 · Heuvelton, NY · Accident · Minor injuries · Closed · Jul 17, 1968 · N1529J · Substantial damage
- [NTSB MKC69D0201](https://openairdocs.org/ntsb/MKC69D0201.md): Cessna 172 · Springfield, MO · Accident · No injuries · Closed · Jul 16, 1968 · N2145Y · Substantial damage
- [NTSB SEA69A0004](https://openairdocs.org/ntsb/SEA69A0004.md): Cessna 170A · Hermiston, OR · Accident · 1 fatal · Closed · Jul 15, 1968 · N9747A · Destroyed
- [NTSB SEA68D0046](https://openairdocs.org/ntsb/SEA68D0046-108552.md): Cherokee II · Oroville, WA · Accident · Minor injuries · Closed · Jul 15, 1968 · N7839C · Substantial damage
- [NTSB MKC69F0063](https://openairdocs.org/ntsb/MKC69F0063.md): Piper PA-28 · Breckenridge, MN · Accident · No injuries · Closed · Jul 15, 1968 · N4928J · Substantial damage
- [NTSB DIA69F0028](https://openairdocs.org/ntsb/DIA69F0028.md): Cessna 150 · Oxon Hill, MD · Accident · Serious injuries · Closed · Jul 15, 1968 · N4172U · Destroyed
- [NTSB MKC69D0062](https://openairdocs.org/ntsb/MKC69D0062-109173.md): Piper PA-28 · Summerfield, KS · Accident · Minor injuries · Closed · Jul 14, 1968 · N7519R · Substantial damage
- [NTSB LAX69F0059](https://openairdocs.org/ntsb/LAX69F0059.md): Clover MA4-A · Rubidoux, CA · Accident · Serious injuries · Closed · Jul 14, 1968 · N3350G · Substantial damage
- [NTSB LAX69D0060](https://openairdocs.org/ntsb/LAX69D0060.md): Globe GC-1B · Rubidoux, CA · Accident · No injuries · Closed · Jul 14, 1968 · N3762K · Substantial damage
- [NTSB CHI69D0189](https://openairdocs.org/ntsb/CHI69D0189.md): Piper PA-28 · Wonewoc, WI · Accident · Minor injuries · Closed · Jul 14, 1968 · N6343R · Substantial damage
- [NTSB LAX69D0053](https://openairdocs.org/ntsb/LAX69D0053.md): Beech 35 · Gorman, CA · Accident · No injuries · Closed · Jul 13, 1968 · N5089C · Substantial damage
- [NTSB CHI69F0103](https://openairdocs.org/ntsb/CHI69F0103.md): Beech A23 · Peoria, IL · Accident · Minor injuries · Closed · Jul 13, 1968 · N2381J · Substantial damage
- [NTSB NYC69F0050](https://openairdocs.org/ntsb/NYC69F0050.md): Cessna 150F · Ringwood, NJ · Accident · Serious injuries · Closed · Jul 12, 1968 · N7951F · Substantial damage
- [NTSB CHI69D0113](https://openairdocs.org/ntsb/CHI69D0113.md): Luscombe 8A · Green Bay, WI · Accident · No injuries · Closed · Jul 12, 1968 · N21996 · Substantial damage
- [NTSB SEA69F0055](https://openairdocs.org/ntsb/SEA69F0055.md): Piper PA-22 · Vancouver, WA · Accident · Minor injuries · Closed · Jul 9, 1968 · N9165D · Destroyed
- [NTSB NYC69A0007](https://openairdocs.org/ntsb/NYC69A0007.md): Piper PA-30 · Lock Haven, PA · Accident · 1 fatal · Closed · Jul 9, 1968 · N8572Y · Destroyed
- [NTSB CHI69F0249](https://openairdocs.org/ntsb/CHI69F0249.md): Erco 415-C · Fremont, OH · Accident · No injuries · Closed · Jul 9, 1968 · N99427 · Substantial damage
- [NTSB LAX69A0005](https://openairdocs.org/ntsb/LAX69A0005.md): Beech A35 · Phoenix, AZ · Accident · 2 fatal · Closed · Jul 8, 1968 · N8450A · Destroyed
- [NTSB CHI69F0087](https://openairdocs.org/ntsb/CHI69F0087.md): Mooney M20E · Gary, IN · Accident · Serious injuries · Closed · Jul 8, 1968 · N5506Q · Destroyed
- [NTSB LAX69D0071](https://openairdocs.org/ntsb/LAX69D0071.md): Beech P35 · Lancaster, CA · Accident · No injuries · Closed · Jul 7, 1968 · N1528Z · Substantial damage
- [NTSB CHI69F0046](https://openairdocs.org/ntsb/CHI69F0046.md): Cessna 195 · Brookeville, OH · Accident · Minor injuries · Closed · Jul 7, 1968 · N4431C · Substantial damage
- [NTSB CHI69D0129](https://openairdocs.org/ntsb/CHI69D0129.md): Piper PA-22 · Neenah, WI · Accident · No injuries · Closed · Jul 7, 1968 · N2244A · Substantial damage
- [NTSB NYC69F0039](https://openairdocs.org/ntsb/NYC69F0039.md): Piper PA-28 · Butler, PA · Accident · No injuries · Closed · Jul 6, 1968 · N5167L · Substantial damage
- [NTSB MKC69D0048](https://openairdocs.org/ntsb/MKC69D0048-201084.md): Beech A23 · Le Mars, IA · Accident · Minor injuries · Closed · Jul 6, 1968 · N5673S · Substantial damage
- [NTSB MIA69D0046](https://openairdocs.org/ntsb/MIA69D0046.md): Mooney M-18C · Homestead, FL · Accident · No injuries · Closed · Jul 6, 1968 · N4133 · Destroyed
- [NTSB FTW69D0156](https://openairdocs.org/ntsb/FTW69D0156.md): Beech G17S · Lewisville, TX · Accident · No injuries · Closed · Jul 6, 1968 · N700N · Substantial damage
- [NTSB DEN69D0042](https://openairdocs.org/ntsb/DEN69D0042.md): Piper PA-28 · Jackson, WY · Accident · Minor injuries · Closed · Jul 5, 1968 · N5668W · Substantial damage
- [NTSB OAK69D0051](https://openairdocs.org/ntsb/OAK69D0051.md): Aeronca 7EC · Fremont, CA · Accident · No injuries · Closed · Jul 4, 1968 · N4337C · Substantial damage
- [NTSB FTW69F0123](https://openairdocs.org/ntsb/FTW69F0123.md): Beech T-34 · San Antonio, TX · Accident · Serious injuries · Closed · Jul 4, 1968 · N74011 · Substantial damage
- [NTSB MKC69D0204](https://openairdocs.org/ntsb/MKC69D0204.md): Erco 415-C · Stilwell, KS · Accident · No injuries · Closed · Jul 1, 1968 · N93624 · Substantial damage
- [NTSB ANC69A0001](https://openairdocs.org/ntsb/ANC69A0001.md): Piper PA-32 · Kenai, AK · Accident · Serious injuries · Closed · Jul 1, 1968 · N3731W · Substantial damage
- [NTSB NYC69F0055](https://openairdocs.org/ntsb/NYC69F0055.md): Nelson PG185B · Finleyville, PA · Accident · Serious injuries · Closed · Jun 30, 1968 · N68580 · Substantial damage
- [NTSB MIA69F0043](https://openairdocs.org/ntsb/MIA69F0043.md): Cessna 172 · Palatka, FL · Accident · Serious injuries · Closed · Jun 30, 1968 · N2758L · Destroyed
- [NTSB LAX69D0039](https://openairdocs.org/ntsb/LAX69D0039.md): Cessna 170 · Hesperia, CA · Accident · No injuries · Closed · Jun 30, 1968 · N9716A · Substantial damage
- [NTSB CHI69D0055](https://openairdocs.org/ntsb/CHI69D0055.md): Piper PA-28 · Earl Park, IN · Accident · No injuries · Closed · Jun 30, 1968 · N6670W · Substantial damage
- [NTSB NYC69F0034](https://openairdocs.org/ntsb/NYC69F0034.md): Cessna 310H · Totowa, NJ · Accident · Minor injuries · Closed · Jun 29, 1968 · N1101Q · Destroyed
- [NTSB NYC69D0025](https://openairdocs.org/ntsb/NYC69D0025.md): Cessna 150 · Prattsville, NY · Accident · No injuries · Closed · Jun 29, 1968 · N6944S · Destroyed
- [NTSB SEA69D0042](https://openairdocs.org/ntsb/SEA69D0042.md): Cessna 150 · Halfway, OR · Accident · Minor injuries · Closed · Jun 28, 1968 · N22499 · Substantial damage
- [NTSB DEN69D0040](https://openairdocs.org/ntsb/DEN69D0040.md): Bell 47G3B1 · Fort Collins, CO · Accident · Minor injuries · Closed · Jun 28, 1968 · N73287 · Destroyed
- [NTSB DIA69D0018](https://openairdocs.org/ntsb/DIA69D0018.md): Piper PA-24 · Dulles, VA · Accident · No injuries · Closed · Jun 26, 1968 · N6843P · Substantial damage
- [NTSB MKC68A0073](https://openairdocs.org/ntsb/MKC68A0073.md): Convair 580 · Sioux Falls, SD · Accident · No injuries · Closed · Jun 24, 1968 · N4824C · Substantial damage
- [NTSB DEN69D0078](https://openairdocs.org/ntsb/DEN69D0078.md): Piper PA-22 · Greeley, CO · Accident · No injuries · Closed · Jun 24, 1968 · N3921P · Substantial damage
- [NTSB CHI69F0024](https://openairdocs.org/ntsb/CHI69F0024.md): Stinson 108-3 · Petersburg, MI · Accident · No injuries · Closed · Jun 24, 1968 · N6428M · Substantial damage
- [NTSB SEA69F0040](https://openairdocs.org/ntsb/SEA69F0040.md): Piper PA-28 · Friday Harbr, WA · Accident · Serious injuries · Closed · Jun 23, 1968 · N6308R · Destroyed
- [NTSB SEA69F0032](https://openairdocs.org/ntsb/SEA69F0032.md): Schweizer 2-22 · Issaquah, WA · Accident · No injuries · Closed · Jun 23, 1968 · N2769R · Substantial damage
- [NTSB MIA69D0085](https://openairdocs.org/ntsb/MIA69D0085.md): Cessna 150 · Pinehurst, GA · Accident · No injuries · Closed · Jun 23, 1968 · N8121F · Substantial damage
- [NTSB CHI69F0083](https://openairdocs.org/ntsb/CHI69F0083.md): Cessna 180 · Crestline, OH · Accident · Minor injuries · Closed · Jun 23, 1968 · N7602A · Destroyed

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

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

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