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

## Cases, newest first

- [NTSB NYC67D0324](https://openairdocs.org/ntsb/NYC67D0324.md): Piper PA-12 · Bluefield, WV · Accident · No injuries · Closed · Aug 18, 1966 · N4346M · Substantial damage
- [NTSB LAX67F0118](https://openairdocs.org/ntsb/LAX67F0118.md): Cessna 310B · Ontario, CA · Accident · Minor injuries · Closed · Aug 18, 1966 · N5380A · Substantial damage
- [NTSB FTW67F0388](https://openairdocs.org/ntsb/FTW67F0388.md): Cessna 140 · Lipan, TX · Accident · No injuries · Closed · Aug 18, 1966 · N1722V · Substantial damage
- [NTSB NYC67F0228](https://openairdocs.org/ntsb/NYC67F0228.md): Luscombe 8A · Neptune, NJ · Accident · No injuries · Closed · Aug 17, 1966 · N77840 · Substantial damage
- [NTSB MIA67F0194](https://openairdocs.org/ntsb/MIA67F0194.md): Piper PA-25 · Shellman, GA · Accident · No injuries · Closed · Aug 17, 1966 · N6406Z · Substantial damage
- [NTSB FTW67D0138](https://openairdocs.org/ntsb/FTW67D0138.md): Cessna 150 · Freemason Isle, LA · Accident · No injuries · Closed · Aug 16, 1966 · N8459G · Substantial damage
- [NTSB DEN67D0077](https://openairdocs.org/ntsb/DEN67D0077.md): Cessna 182 · Green River, UT · Accident · No injuries · Closed · Aug 16, 1966 · N4918D · Substantial damage
- [NTSB ANC67D0032](https://openairdocs.org/ntsb/ANC67D0032.md): Cessna 170B · Eagle, AK · Accident · Minor injuries · Closed · Aug 16, 1966 · N8168A · Substantial damage
- [NTSB CHI67A0023](https://openairdocs.org/ntsb/CHI67A0023.md): Hawker-Sdly DH-125 · Paducah, KY · Accident · No injuries · Closed · Aug 15, 1966 · N926G · Substantial damage
- [NTSB SEA67F0107](https://openairdocs.org/ntsb/SEA67F0107.md): Piper PA-18 · Zortman, MT · Accident · No injuries · Closed · Aug 14, 1966 · N1197C · Substantial damage
- [NTSB OAK67A0024](https://openairdocs.org/ntsb/OAK67A0024.md): Cessna 172A · Davis, CA · Accident · 2 fatal · Closed · Aug 14, 1966 · N9742T · Destroyed
- [NTSB LAX67F0096](https://openairdocs.org/ntsb/LAX67F0096.md): Taylorcraft BC12-D · Santa Susana, CA · Accident · No injuries · Closed · Aug 14, 1966 · N43698 · Substantial damage
- [NTSB DEN67F0066](https://openairdocs.org/ntsb/DEN67F0066.md): Cessna T-210F · Albuquerque, NM · Accident · Minor injuries · Closed · Aug 14, 1966 · N6193R · Substantial damage
- [NTSB CHI67F0236](https://openairdocs.org/ntsb/CHI67F0236.md): Piper PA-28 · Hobart, IN · Accident · No injuries · Closed · Aug 14, 1966 · N6347W · Substantial damage
- [NTSB MKC67D0149](https://openairdocs.org/ntsb/MKC67D0149.md): Beech A23A · Council Blfs, IA · Accident · No injuries · Closed · Aug 13, 1966 · N2307W · Substantial damage
- [NTSB SEA67D0124](https://openairdocs.org/ntsb/SEA67D0124.md): Cessna 182 · Tacoma, WA · Accident · No injuries · Closed · Aug 12, 1966 · N2371R · Substantial damage
- [NTSB SEA67F0105](https://openairdocs.org/ntsb/SEA67F0105.md): Cessna 170B · Troutdale, OR · Accident · No injuries · Closed · Aug 9, 1966 · N2575D · Substantial damage
- [NTSB NYC67F0146](https://openairdocs.org/ntsb/NYC67F0146.md): Beech M23 · Latham, NY · Accident · No injuries · Closed · Aug 8, 1966 · N8875M · Substantial damage
- [NTSB SEA67A0011](https://openairdocs.org/ntsb/SEA67A0011.md): Bell 47J-2A · Darrington, WA · Accident · Minor injuries · Closed · Aug 7, 1966 · N251PH · Destroyed
- [NTSB NYC67F0210](https://openairdocs.org/ntsb/NYC67F0210.md): Piper PA-22 · Roscoe, NY · Accident · No injuries · Closed · Aug 7, 1966 · N7457D · Substantial damage
- [NTSB NYC67D0151](https://openairdocs.org/ntsb/NYC67D0151.md): Cessna 120 · Montauk, NY · Accident · No injuries · Closed · Aug 7, 1966 · N76361 · Substantial damage
- [NTSB FTW67D0171](https://openairdocs.org/ntsb/FTW67D0171.md): Schweizer SGS126 · Mccamey, TX · Accident · Serious injuries · Closed · Aug 6, 1966 · N3886A · Minor damage
- [NTSB OAK67D0074](https://openairdocs.org/ntsb/OAK67D0074.md): Mooney M-18L · All Rvr Mills, CA · Accident · No injuries · Closed · Aug 5, 1966 · N392A · Substantial damage
- [NTSB OAK67A0017](https://openairdocs.org/ntsb/OAK67A0017.md): Beech C-18S · San Jose, CA · Accident · No injuries · Closed · Aug 4, 1966 · N7385C · Destroyed
- [NTSB MKC67F0148](https://openairdocs.org/ntsb/MKC67F0148.md): Piper PA-25 · Blairstown, IA · Accident · Serious injuries · Closed · Aug 4, 1966 · N7114Z · Substantial damage
- [NTSB MIA67D0121](https://openairdocs.org/ntsb/MIA67D0121.md): Stinson 108-3 · Wauchula, FL · Accident · No injuries · Closed · Aug 3, 1966 · N6944M · Substantial damage
- [NTSB MKC67F0146](https://openairdocs.org/ntsb/MKC67F0146.md): Cessna 182A · Mason City, IA · Accident · Minor injuries · Closed · Aug 2, 1966 · N5183D · Substantial damage
- [NTSB MKC67F0141](https://openairdocs.org/ntsb/MKC67F0141.md): Cessna 150F · Columbus, NE · Accident · No injuries · Closed · Aug 2, 1966 · N6813F · Substantial damage
- [NTSB SEA67D0154](https://openairdocs.org/ntsb/SEA67D0154.md): Stinson 108 · Orcas Island, WA · Accident · No injuries · Closed · Jul 31, 1966 · N8200K · Substantial damage
- [NTSB OAK67D0047](https://openairdocs.org/ntsb/OAK67D0047.md): Luscombe 8E · Vacaville, CA · Accident · Minor injuries · Closed · Jul 31, 1966 · N2293K · Substantial damage
- [NTSB NYC67F0155](https://openairdocs.org/ntsb/NYC67F0155.md): Cessna 182 · Red Hook, NY · Accident · No injuries · Closed · Jul 31, 1966 · N2680F · Substantial damage
- [NTSB FTW6MF0117](https://openairdocs.org/ntsb/FTW6MF0117.md): Mooney M20E · Odessa, TX · Accident · No injuries · Closed · Jul 31, 1966 · N5758Q · Substantial damage
- [NTSB FTW67D0116](https://openairdocs.org/ntsb/FTW67D0116.md): Mooney M20C · Abilene, TX · Accident · No injuries · Closed · Jul 31, 1966 · N6693U · Substantial damage
- [NTSB CHI67F0133](https://openairdocs.org/ntsb/CHI67F0133.md): Scheibe L-55 · Whitestown, IN · Accident · Serious injuries · Closed · Jul 31, 1966 · N1172 · Substantial damage
- [NTSB CHI67D0146](https://openairdocs.org/ntsb/CHI67D0146-201158.md): Cessna 172 · Reed City, MI · Accident · No injuries · Closed · Jul 31, 1966 · N5407T · Substantial damage
- [NTSB ANC67F0039](https://openairdocs.org/ntsb/ANC67F0039.md): Cessna 150F · Anchorage, AK · Accident · No injuries · Closed · Jul 31, 1966 · N8805S · Substantial damage
- [NTSB OAK67F0042](https://openairdocs.org/ntsb/OAK67F0042.md): Piper PA-28 · Honolulu, HI · Accident · No injuries · Closed · Jul 30, 1966 · N6007W · Substantial damage
- [NTSB NYC67F0148](https://openairdocs.org/ntsb/NYC67F0148.md): Piper PA-28 · Biddeford, ME · Accident · No injuries · Closed · Jul 30, 1966 · N8514W · Substantial damage
- [NTSB MKC67F0195](https://openairdocs.org/ntsb/MKC67F0195.md): Piper PA-24 · Des Moines, IA · Accident · No injuries · Closed · Jul 30, 1966 · N5715P · Substantial damage
- [NTSB CHI67A0018](https://openairdocs.org/ntsb/CHI67A0018.md): Piper PA-22 · Strongsville, OH · Accident · 1 fatal · Closed · Jul 30, 1966 · N5722Z · 2 aircraft · Minor damage
- [NTSB OAK67F0070](https://openairdocs.org/ntsb/OAK67F0070.md): Cessna 150 · Minden, NV · Accident · No injuries · Closed · Jul 29, 1966 · N3054X · 2 aircraft · Substantial damage
- [NTSB SEA67F0134](https://openairdocs.org/ntsb/SEA67F0134.md): Maule M-4 · Oledo, OR · Accident · No injuries · Closed · Jul 28, 1966 · N12016 · Substantial damage
- [NTSB DEN67I0013](https://openairdocs.org/ntsb/DEN67I0013.md): Boeing B-727 · Pueblo, CO · Incident · No injuries · Closed · Jul 28, 1966 · N7011U · Minor damage
- [NTSB DEN67D0071](https://openairdocs.org/ntsb/DEN67D0071.md): Piper PA-28 · Alamosa, CO · Accident · No injuries · Closed · Jul 28, 1966 · N7149W · Substantial damage
- [NTSB CHI67A0016](https://openairdocs.org/ntsb/CHI67A0016.md): Cessna 150 · Racine, WI · Accident · 1 fatal · Closed · Jul 27, 1966 · N3005J · Destroyed
- [NTSB FTW6MF0154](https://openairdocs.org/ntsb/FTW6MF0154.md): Piper PA-22 · Dallas, TX · Accident · No injuries · Closed · Jul 26, 1966 · N4541Z · Substantial damage
- [NTSB FTW67D0123](https://openairdocs.org/ntsb/FTW67D0123.md): Beech S35 · Lubbock, TX · Accident · No injuries · Closed · Jul 26, 1966 · N864T · Substantial damage
- [NTSB SEA67A0007](https://openairdocs.org/ntsb/SEA67A0007.md): Piper PA-20 · Glide, OR · Accident · 3 fatal · Closed · Jul 25, 1966 · N6930K · Destroyed
- [NTSB MIA67A0015](https://openairdocs.org/ntsb/MIA67A0015.md): Mooney M20C · Jacksonville, NC · Accident · 2 fatal · Closed · Jul 25, 1966 · N5730Q · Destroyed
- [NTSB CHI67A0013](https://openairdocs.org/ntsb/CHI67A0013.md): Taylorcraft BC12 · Bancroft, MI · Accident · 1 fatal · Closed · Jul 25, 1966 · N36444 · Destroyed

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

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

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