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

## Cases, newest first

- [NTSB LAX68D0236](https://openairdocs.org/ntsb/LAX68D0236.md): Piper PA-22 · Wenden, AZ · Accident · No injuries · Closed · Sep 10, 1967 · N8446D · Substantial damage
- [NTSB FTW68F0290](https://openairdocs.org/ntsb/FTW68F0290.md): Pietenpol Scout · Van Buren, AR · Accident · Serious injuries · Closed · Sep 10, 1967 · N2830J · Destroyed
- [NTSB OAK68D0131](https://openairdocs.org/ntsb/OAK68D0131.md): Beech 35 · Santa Rosa, CA · Accident · No injuries · Closed · Sep 9, 1967 · N3333V · Substantial damage
- [NTSB UNK67X0154](https://openairdocs.org/ntsb/UNK67X0154.md): Custer CCW-5 · Gander, Canada · Accident · Serious injuries · Closed · Sep 8, 1967 · N6257C · Destroyed
- [NTSB NYC68A0042](https://openairdocs.org/ntsb/NYC68A0042.md): Beech 95-A55 · Castle Creek, NY · Accident · 2 fatal · Closed · Sep 8, 1967 · N1450G · Destroyed
- [NTSB DEN68D0083](https://openairdocs.org/ntsb/DEN68D0083.md): Cessna 310 · Aspen, CO · Accident · No injuries · Closed · Sep 8, 1967 · N440X · Substantial damage
- [NTSB CHI68F0319](https://openairdocs.org/ntsb/CHI68F0319.md): Cessna 310C · Waukegan, IL · Accident · No injuries · Closed · Sep 8, 1967 · N460CA · Substantial damage
- [NTSB NYC68D0167](https://openairdocs.org/ntsb/NYC68D0167.md): Schweizer SGU-2 · Elmira, NY · Accident · No injuries · Closed · Sep 7, 1967 · N2415W · Destroyed
- [NTSB MKC68D0219](https://openairdocs.org/ntsb/MKC68D0219.md): Cessna 140A · Pittsville, MO · Accident · No injuries · Closed · Sep 6, 1967 · N5621C · Substantial damage
- [NTSB FTW68O0011](https://openairdocs.org/ntsb/FTW68O0011.md): Beech D35 · Torreon, Mexico · Accident · No injuries · Closed · Sep 6, 1967 · N2128D · Substantial damage
- [NTSB LAX68F0156](https://openairdocs.org/ntsb/LAX68F0156.md): Cessna 210 · Sepulveda, CA · Accident · No injuries · Closed · Sep 5, 1967 · N7442E · Substantial damage
- [NTSB LAX68D0123](https://openairdocs.org/ntsb/LAX68D0123.md): Globe Swift GC-1B · Peoria, AZ · Accident · No injuries · Closed · Sep 4, 1967 · N78293 · Substantial damage
- [NTSB CHI68F0362](https://openairdocs.org/ntsb/CHI68F0362.md): Piper PA-28 · Bellville, OH · Accident · Minor injuries · Closed · Sep 4, 1967 · N5305W · Substantial damage
- [NTSB SEA68D0091](https://openairdocs.org/ntsb/SEA68D0091.md): Piper PA-18 · Imnaha, OR · Accident · Minor injuries · Closed · Sep 2, 1967 · N7533K · Destroyed
- [NTSB NYC68D0149](https://openairdocs.org/ntsb/NYC68D0149.md): Cessna 172E · Ea.Hampton, CT · Accident · Serious injuries · Closed · Sep 2, 1967 · N5308T · Substantial damage
- [NTSB MKC68F0195](https://openairdocs.org/ntsb/MKC68F0195.md): Stits SA6-B · Grinnell, IA · Accident · Serious injuries · Closed · Sep 2, 1967 · N4801E · Substantial damage
- [NTSB MKC68D0196](https://openairdocs.org/ntsb/MKC68D0196.md): Piper PA-22 · Goodland, KS · Accident · Minor injuries · Closed · Sep 2, 1967 · N2705P · Substantial damage
- [NTSB MKC68A0017](https://openairdocs.org/ntsb/MKC68A0017.md): Cessna 182D · Grenola, KS · Accident · 2 fatal · Closed · Sep 2, 1967 · N9096X · Destroyed
- [NTSB UNK67X0153](https://openairdocs.org/ntsb/UNK67X0153.md): Cessna 182 · Kamloops Arpt, Canada · Accident · No injuries · Closed · Sep 1, 1967 · N5671B · Substantial damage
- [NTSB DIA68F0055](https://openairdocs.org/ntsb/DIA68F0055.md): Cessna 310 · Fletcher, NC · Accident · No injuries · Closed · Sep 1, 1967 · N421M · Substantial damage
- [NTSB DIA68D0076](https://openairdocs.org/ntsb/DIA68D0076.md): Piper PA-24 · Mitchelville, MD · Accident · No injuries · Closed · Sep 1, 1967 · N740W · Substantial damage
- [NTSB MKC68A0016](https://openairdocs.org/ntsb/MKC68A0016.md): Cessna 172F · Chesterfield, MO · Accident · 2 fatal · Closed · Aug 30, 1967 · N8621U · Destroyed
- [NTSB MIA68D0237](https://openairdocs.org/ntsb/MIA68D0237.md): Cessna 210 · Camden, SC · Accident · Serious injuries · Closed · Aug 30, 1967 · N6796R · Destroyed
- [NTSB UNK67X0152](https://openairdocs.org/ntsb/UNK67X0152.md): Piper PA-28 · Wms Lake, Canada · Accident · 2 fatal · Closed · Aug 28, 1967 · N4329J · Destroyed
- [NTSB SEA68D0147](https://openairdocs.org/ntsb/SEA68D0147.md): Cessna 172 · Snohomish, WA · Accident · No injuries · Closed · Aug 27, 1967 · N5674A · Substantial damage
- [NTSB OAK68A0022](https://openairdocs.org/ntsb/OAK68A0022.md): Cessna 150 · Boulder City, NV · Accident · 2 fatal · Closed · Aug 27, 1967 · N7805F · Destroyed
- [NTSB NYC68F0151](https://openairdocs.org/ntsb/NYC68F0151.md): Mooney M20C · Neptune, NJ · Accident · No injuries · Closed · Aug 27, 1967 · N1399W · Substantial damage
- [NTSB FTW68F0161](https://openairdocs.org/ntsb/FTW68F0161.md): Piper PA-28 · Blackwell, OK · Accident · Minor injuries · Closed · Aug 27, 1967 · N5090W · Substantial damage
- [NTSB DIA68A0008](https://openairdocs.org/ntsb/DIA68A0008.md): Navion NAV-A · Maugansville, MD · Accident · 1 fatal · Closed · Aug 26, 1967 · N8792H · Destroyed
- [NTSB MKC68D0214](https://openairdocs.org/ntsb/MKC68D0214.md): Cessna 140 · Independence, MO · Accident · Minor injuries · Closed · Aug 24, 1967 · N76939 · Substantial damage
- [NTSB FTW68F0177](https://openairdocs.org/ntsb/FTW68F0177.md): Cessna 170A · Pearland, TX · Accident · No injuries · Closed · Aug 24, 1967 · N9980A · Substantial damage
- [NTSB OAK68D0101](https://openairdocs.org/ntsb/OAK68D0101.md): Boeing A75 · Fresno, CA · Accident · No injuries · Closed · Aug 23, 1967 · N63457 · Substantial damage
- [NTSB CHI68F0300](https://openairdocs.org/ntsb/CHI68F0300.md): Piper PA-28 · Syracuse, IN · Accident · Minor injuries · Closed · Aug 23, 1967 · N8247W · Substantial damage
- [NTSB MIA68F0187](https://openairdocs.org/ntsb/MIA68F0187.md): Erco 415-C · Barnwell, SC · Accident · No injuries · Closed · Aug 22, 1967 · N99047 · Substantial damage
- [NTSB MKC68F0170](https://openairdocs.org/ntsb/MKC68F0170.md): Piper J-3 · Lincoln, NE · Accident · No injuries · Closed · Aug 20, 1967 · N92244 · Substantial damage
- [NTSB DEN68D0070](https://openairdocs.org/ntsb/DEN68D0070.md): Piper PA-18 · Recluse, WY · Accident · Minor injuries · Closed · Aug 18, 1967 · N7573K · Substantial damage
- [NTSB CHI68F0318](https://openairdocs.org/ntsb/CHI68F0318.md): Cessna 172 · Pekin, IL · Accident · No injuries · Closed · Aug 18, 1967 · N8754B · Substantial damage
- [NTSB CHI68F0205](https://openairdocs.org/ntsb/CHI68F0205.md): Piper PA-28 · Bloomington, IL · Accident · No injuries · Closed · Aug 18, 1967 · N6679W · Substantial damage
- [NTSB CHI68F0220](https://openairdocs.org/ntsb/CHI68F0220.md): Beech 35-B33 · Cincinnati, OH · Accident · Minor injuries · Closed · Aug 17, 1967 · N1586S · Substantial damage
- [NTSB SEA68F0170](https://openairdocs.org/ntsb/SEA68F0170.md): Erco 415-C · Crabtree, OR · Accident · No injuries · Closed · Aug 16, 1967 · N99785 · Substantial damage
- [NTSB CHI68D0228](https://openairdocs.org/ntsb/CHI68D0228.md): Cessna 150 · Greenwood, IL · Accident · No injuries · Closed · Aug 16, 1967 · N6933F · Substantial damage
- [NTSB ANC68D0084](https://openairdocs.org/ntsb/ANC68D0084.md): Piper PA-14 · Chitina, AK · Accident · No injuries · Closed · Aug 16, 1967 · N5106H · Substantial damage
- [NTSB ANC68A0011](https://openairdocs.org/ntsb/ANC68A0011.md): Piper PA-18 · Anchorage, AK · Accident · 2 fatal · Closed · Aug 16, 1967 · N8759C · Destroyed
- [NTSB MKC68D0171](https://openairdocs.org/ntsb/MKC68D0171.md): Piper PA-22 · Wahoo, NE · Accident · No injuries · Closed · Aug 15, 1967 · N7002B · Substantial damage
- [NTSB DIA68F0054](https://openairdocs.org/ntsb/DIA68F0054.md): N.American AT-6D · Fayetteville, NC · Accident · No injuries · Closed · Aug 15, 1967 · N9649C · Substantial damage
- [NTSB DEN68F0051](https://openairdocs.org/ntsb/DEN68F0051.md): Mooney M20C · Ruidoso, NM · Accident · Minor injuries · Closed · Aug 15, 1967 · N5981Q · Substantial damage
- [NTSB ANC68F0032](https://openairdocs.org/ntsb/ANC68F0032.md): Cessna 170 · Anchorage, AK · Accident · No injuries · Closed · Aug 14, 1967 · N2541C · Substantial damage
- [NTSB NYC68F0135](https://openairdocs.org/ntsb/NYC68F0135.md): Schweizer SGU222 · Dansville, NY · Accident · No injuries · Closed · Aug 13, 1967 · N2737Z · Substantial damage
- [NTSB MKC68D0142](https://openairdocs.org/ntsb/MKC68D0142.md): Globe GC-1B · Larchwood, IA · Accident · No injuries · Closed · Aug 13, 1967 · N78009 · Substantial damage
- [NTSB CHI68F0233](https://openairdocs.org/ntsb/CHI68F0233.md): Cessna 140 · Bunker Hill, IL · Accident · Minor injuries · Closed · Aug 13, 1967 · N89480 · Substantial damage

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

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

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