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

## Cases, newest first

- [NTSB SEA77DYM60](https://openairdocs.org/ntsb/SEA77DYM60.md): Beech B35 · Dallas, OR · Accident · No injuries · Closed · Jul 31, 1977 · N5066C · Substantial damage
- [NTSB CHI77FEP47](https://openairdocs.org/ntsb/CHI77FEP47.md): Cessna 172 · Lake Geneva, WI · Accident · Serious injuries · Closed · Jul 31, 1977 · N7409A · Substantial damage
- [NTSB ANC77FA065](https://openairdocs.org/ntsb/ANC77FA065.md): Beech E90 · Sitka, AK · Accident · 5 fatal · Closed · Jul 31, 1977 · N4207S · Destroyed
- [NTSB NYC77FNA25](https://openairdocs.org/ntsb/NYC77FNA25.md): Piper PA-28 · Edgartown, MA · Accident · Serious injuries · Closed · Jul 30, 1977 · N57363 · Substantial damage
- [NTSB FTW77FQG45](https://openairdocs.org/ntsb/FTW77FQG45.md): Beech B23 · Gruver, TX · Accident · No injuries · Closed · Jul 30, 1977 · N2190W · Substantial damage
- [NTSB FTW77DPD33](https://openairdocs.org/ntsb/FTW77DPD33.md): Erco 415-D · Fort Worth, TX · Accident · Minor injuries · Closed · Jul 30, 1977 · N99016 · Substantial damage
- [NTSB CHI77FA061](https://openairdocs.org/ntsb/CHI77FA061.md): Cessna 172F · Grand Rapids, MI · Accident · 1 fatal · Closed · Jul 30, 1977 · N5606R · Destroyed
- [NTSB CHI77DEP52](https://openairdocs.org/ntsb/CHI77DEP52.md): Beech B-19 · Milwaukee, WI · Accident · No injuries · Closed · Jul 30, 1977 · N1990L · Substantial damage
- [NTSB IAD77FA054](https://openairdocs.org/ntsb/IAD77FA054.md): Beech 95 · Fletcher, NC · Accident · 3 fatal · Closed · Jul 29, 1977 · N771B · Destroyed
- [NTSB DEN78FTE77](https://openairdocs.org/ntsb/DEN78FTE77-201260.md): Beech D-18S · Trinidad, CO · Accident · No injuries · Closed · Jul 28, 1977 · N244V · Substantial damage
- [NTSB CHI77DET29](https://openairdocs.org/ntsb/CHI77DET29.md): Beech BE-19 · Elkhart, IN · Accident · No injuries · Closed · Jul 28, 1977 · N1914L · Substantial damage
- [NTSB MIA77FKJ60](https://openairdocs.org/ntsb/MIA77FKJ60.md): Cessna 177RG · Weaver, AL · Accident · No injuries · Closed · Jul 26, 1977 · N33273 · Substantial damage
- [NTSB SEA77FA043](https://openairdocs.org/ntsb/SEA77FA043.md): Piper PA-32R · Bernard Creek, ID · Accident · 5 fatal · Closed · Jul 25, 1977 · N9228K · Destroyed
- [NTSB MKC77FER66](https://openairdocs.org/ntsb/MKC77FER66.md): Piper PA-22 · Thief River, MN · Accident · No injuries · Closed · Jul 25, 1977 · N9222D · Substantial damage
- [NTSB ANC77DAA39](https://openairdocs.org/ntsb/ANC77DAA39.md): Bellanca 7GCBC · Nenana, AK · Accident · No injuries · Closed · Jul 25, 1977 · N1800G · Substantial damage
- [NTSB IAD77FIG28](https://openairdocs.org/ntsb/IAD77FIG28.md): Beech 23 · Gaithersburg, MD · Accident · No injuries · Closed · Jul 23, 1977 · N6VT · Substantial damage
- [NTSB CHI77FEE37](https://openairdocs.org/ntsb/CHI77FEE37.md): Schweizer 1-26 · Huntley, IL · Accident · Serious injuries · Closed · Jul 23, 1977 · N8615R · Substantial damage
- [NTSB ANC77DAA40](https://openairdocs.org/ntsb/ANC77DAA40.md): Cessna 170 · Delta Junction, AK · Accident · No injuries · Closed · Jul 23, 1977 · N4074V · Substantial damage
- [NTSB OAK77FVA47](https://openairdocs.org/ntsb/OAK77FVA47.md): Cessna 150M · Madera, CA · Accident · Serious injuries · Closed · Jul 20, 1977 · N9450U · Destroyed
- [NTSB NYC77FA072](https://openairdocs.org/ntsb/NYC77FA072.md): Piper PA-31 · Cheektowaga, NY · Accident · 1 fatal · Closed · Jul 20, 1977 · N406CA · Destroyed
- [NTSB FTW77FRJ14](https://openairdocs.org/ntsb/FTW77FRJ14.md): Grumman G-164A · Lk Providence, LA · Accident · No injuries · Closed · Jul 20, 1977 · N8950H · Destroyed
- [NTSB SEA77FYE29](https://openairdocs.org/ntsb/SEA77FYE29.md): Taylor B8M · Shelton, WA · Accident · 1 fatal · Closed · Jul 19, 1977 · N65360 · Destroyed
- [NTSB OAK77DVA43](https://openairdocs.org/ntsb/OAK77DVA43.md): Cessna 150 · Madera, CA · Accident · No injuries · Closed · Jul 19, 1977 · N3018X · Substantial damage
- [NTSB MKC77DER64](https://openairdocs.org/ntsb/MKC77DER64.md): Cessna 150 · Staples, MN · Accident · No injuries · Closed · Jul 19, 1977 · N10859 · Substantial damage
- [NTSB DEN77FQG05](https://openairdocs.org/ntsb/DEN77FQG05.md): Molino PIK-20 · Hobbs, NM · Accident · Serious injuries · Closed · Jul 19, 1977 · N37N · Substantial damage
- [NTSB CHI77FEP45](https://openairdocs.org/ntsb/CHI77FEP45.md): Bellanca 17-30A · Milwaukee, WI · Accident · No injuries · Closed · Jul 18, 1977 · N39867 · Substantial damage
- [NTSB NYC77DHA29](https://openairdocs.org/ntsb/NYC77DHA29.md): Cessna 172 · Bedminster, NJ · Accident · No injuries · Closed · Jul 17, 1977 · N12501 · Substantial damage
- [NTSB CHI77FEV35](https://openairdocs.org/ntsb/CHI77FEV35.md): Woolums KR-2 · Jacksonville, IL · Accident · No injuries · Closed · Jul 17, 1977 · N14527 · Substantial damage
- [NTSB OAK77FXQ27](https://openairdocs.org/ntsb/OAK77FXQ27.md): Beech A23A · Lake Tahoe, CA · Accident · Serious injuries · Closed · Jul 16, 1977 · N2362W · Substantial damage
- [NTSB NYC77DHJ30](https://openairdocs.org/ntsb/NYC77DHJ30.md): Cessna 172 · Montauk, NY · Accident · No injuries · Closed · Jul 16, 1977 · N6654H · Substantial damage
- [NTSB MKC77DCQ47](https://openairdocs.org/ntsb/MKC77DCQ47.md): Piper PA-28 · Hoxie, KS · Accident · Minor injuries · Closed · Jul 14, 1977 · N7221F · Substantial damage
- [NTSB IAD77DA053](https://openairdocs.org/ntsb/IAD77DA053.md): Grum Amer AA-1 · Vine Grove, KY · Accident · 1 fatal · Closed · Jul 14, 1977 · N5652L · Substantial damage
- [NTSB CHI77FA059](https://openairdocs.org/ntsb/CHI77FA059.md): Cessna 150M · Peoria, IL · Accident · 1 fatal · Closed · Jul 14, 1977 · N8993U · Destroyed
- [NTSB SEA77DYM45](https://openairdocs.org/ntsb/SEA77DYM45.md): Cessna 172 · Madras, OR · Accident · No injuries · Closed · Jul 12, 1977 · N6414E · Substantial damage
- [NTSB LAX77DUG52](https://openairdocs.org/ntsb/LAX77DUG52.md): Piper PA-28 · Soggy Dry Lake, CA · Accident · No injuries · Closed · Jul 12, 1977 · N44675 · Substantial damage
- [NTSB SEA77DYM51](https://openairdocs.org/ntsb/SEA77DYM51.md): Cessna 150 · Dallas, OR · Accident · No injuries · Closed · Jul 11, 1977 · N22499 · Substantial damage
- [NTSB OAK77FVD44](https://openairdocs.org/ntsb/OAK77FVD44.md): Cessna 150H · Oakland, CA · Accident · No injuries · Closed · Jul 10, 1977 · N6657S · Substantial damage
- [NTSB NYC77DFJ38](https://openairdocs.org/ntsb/NYC77DFJ38.md): Lake 4-200 · Lakeville, NY · Accident · No injuries · Closed · Jul 10, 1977 · N6024V · Substantial damage
- [NTSB MKC77FCQ46](https://openairdocs.org/ntsb/MKC77FCQ46.md): Cessna U206G · Wichita, KS · Accident · Minor injuries · Closed · Jul 10, 1977 · N7711N · Substantial damage
- [NTSB NYC77FHD19](https://openairdocs.org/ntsb/NYC77FHD19.md): Cessna 150 · Atlantic Cy, NJ · Accident · Serious injuries · Closed · Jul 9, 1977 · N66746 · Destroyed
- [NTSB NYC77FFJ33](https://openairdocs.org/ntsb/NYC77FFJ33.md): Piper PA-18 · Elmira, NY · Accident · Serious injuries · Closed · Jul 9, 1977 · N83350 · Destroyed
- [NTSB MIA77FK648](https://openairdocs.org/ntsb/MIA77FK648.md): Champion 7HC · Savannah, GA · Accident · No injuries · Closed · Jul 9, 1977 · N8576E · Substantial damage
- [NTSB FTW77FPJ29](https://openairdocs.org/ntsb/FTW77FPJ29.md): Volksplane VP-1 · Oklahoma City, OK · Accident · Minor injuries · Closed · Jul 9, 1977 · N64619 · Substantial damage
- [NTSB NYC77FA070](https://openairdocs.org/ntsb/NYC77FA070.md): Piper PA-28R · Hingham, MA · Accident · 3 fatal · Closed · Jul 8, 1977 · N5275S · Destroyed
- [NTSB CHI77FET22](https://openairdocs.org/ntsb/CHI77FET22.md): Piper PA-28 · Huntington, IN · Accident · 1 fatal · Closed · Jul 8, 1977 · N8091N · Destroyed
- [NTSB ANC77DAG80](https://openairdocs.org/ntsb/ANC77DAG80.md): Piper PA-18 · Homer, AK · Accident · Minor injuries · Closed · Jul 8, 1977 · N9449D · Substantial damage
- [NTSB MKC77FER58](https://openairdocs.org/ntsb/MKC77FER58.md): Baby GRT LK S-2 · Grand Rapids, MN · Accident · No injuries · Closed · Jul 7, 1977 · N52DS · Substantial damage
- [NTSB MIA77DKG85](https://openairdocs.org/ntsb/MIA77DKG85.md): Luscombe 8E · Lavonia, GA · Accident · Minor injuries · Closed · Jul 7, 1977 · N2673K · Substantial damage
- [NTSB FTW77DPG57](https://openairdocs.org/ntsb/FTW77DPG57.md): Aero Comdr S-2R · Beedeville, AR · Accident · No injuries · Closed · Jul 6, 1977 · N5649X · Substantial damage
- [NTSB LAX77FUG51](https://openairdocs.org/ntsb/LAX77FUG51.md): Piper PA-22 · Redlands, CA · Accident · No injuries · Closed · Jul 5, 1977 · N6055D · Destroyed

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

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

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