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

## Cases, newest first

- [NTSB MKC77FTK06](https://openairdocs.org/ntsb/MKC77FTK06.md): Cessna 177 · Kadoka, SD · Accident · Serious injuries · Closed · Feb 5, 1977 · N2273Y · Substantial damage
- [NTSB DEN77FTE21](https://openairdocs.org/ntsb/DEN77FTE21.md): Piper PA-28 · Brighton, CO · Accident · Minor injuries · Closed · Feb 5, 1977 · N5154L · Substantial damage
- [NTSB CHI77FEV11](https://openairdocs.org/ntsb/CHI77FEV11.md): Piper PA-24 · Tolono, IL · Accident · No injuries · Closed · Feb 5, 1977 · N7440P · Substantial damage
- [NTSB NYC77FA030](https://openairdocs.org/ntsb/NYC77FA030.md): Cessna 150L · Smithfield, RI · Accident · 1 fatal · Closed · Feb 4, 1977 · N6756G · Destroyed
- [NTSB MIA77DLD27](https://openairdocs.org/ntsb/MIA77DLD27.md): Maule M5 · Venice, FL · Accident · No injuries · Closed · Feb 3, 1977 · N362X · Substantial damage
- [NTSB FTW77FA033](https://openairdocs.org/ntsb/FTW77FA033.md): Swearingen SA266T · Beckmam, TX · Accident · 2 fatal · Closed · Feb 3, 1977 · N34SM · Destroyed
- [NTSB IAD77FLQ06](https://openairdocs.org/ntsb/IAD77FLQ06.md): Piper PA-23 · Louisville, KY · Accident · No injuries · Closed · Feb 1, 1977 · N4651P · Substantial damage
- [NTSB ANC77FAD03](https://openairdocs.org/ntsb/ANC77FAD03.md): Cessna 180G · Annette Island, AK · Accident · Minor injuries · Closed · Feb 1, 1977 · N981SC · Substantial damage
- [NTSB LAX77FUG27](https://openairdocs.org/ntsb/LAX77FUG27.md): Piper PA-28 · Riverside, CA · Accident · No injuries · Closed · Jan 30, 1977 · N101YT · Substantial damage
- [NTSB CHI77DEP15](https://openairdocs.org/ntsb/CHI77DEP15.md): Piper PA-28 · Pewaukee, WI · Accident · No injuries · Closed · Jan 30, 1977 · N7504W · Substantial damage
- [NTSB IAD77FA018](https://openairdocs.org/ntsb/IAD77FA018.md): Cessna 177RG · Chattanooga, TN · Accident · 2 fatal · Closed · Jan 29, 1977 · N7506V · Destroyed
- [NTSB FTW77FPA13](https://openairdocs.org/ntsb/FTW77FPA13.md): Cessna 182H · Corsicana, TX · Accident · Minor injuries · Closed · Jan 28, 1977 · N2374X · Substantial damage
- [NTSB SEA77FA015](https://openairdocs.org/ntsb/SEA77FA015.md): Piper PA-32R · Olympia, WA · Accident · 1 fatal · Closed · Jan 27, 1977 · N6638F · Destroyed
- [NTSB OAK77DVM06](https://openairdocs.org/ntsb/OAK77DVM06.md): Rockwell 112A · San Jose, CA · Accident · No injuries · Closed · Jan 27, 1977 · N1361J · Substantial damage
- [NTSB MKC77DER16](https://openairdocs.org/ntsb/MKC77DER16.md): Beechcraft 95-C55 · Marshall, MN · Accident · No injuries · Closed · Jan 27, 1977 · N966W · Substantial damage
- [NTSB MIA77FA027](https://openairdocs.org/ntsb/MIA77FA027.md): Cessna 172 · Lantana, FL · Accident · No injuries · Closed · Jan 27, 1977 · N733KF · 2 aircraft · Substantial damage
- [NTSB LAX77FUG26](https://openairdocs.org/ntsb/LAX77FUG26.md): Luscombe 8E · Daggett, CA · Accident · Minor injuries · Closed · Jan 27, 1977 · N72033 · Destroyed
- [NTSB FTW77FPD10](https://openairdocs.org/ntsb/FTW77FPD10.md): Cessna 172 · Denton, TX · Accident · Minor injuries · Closed · Jan 27, 1977 · N8066L · Destroyed
- [NTSB MIA77FLG09](https://openairdocs.org/ntsb/MIA77FLG09.md): Cessna 210T · Charleston, SC · Accident · No injuries · Closed · Jan 26, 1977 · N732HZ · Substantial damage
- [NTSB MIA77FA026](https://openairdocs.org/ntsb/MIA77FA026.md): Cessna 411 · Ft Myers, FL · Accident · 2 fatal · Closed · Jan 25, 1977 · N99JM · Destroyed
- [NTSB FTW77FPD09](https://openairdocs.org/ntsb/FTW77FPD09.md): Piper PA-28R · Denton, TX · Accident · Minor injuries · Closed · Jan 24, 1977 · N1986T · Substantial damage
- [NTSB DEN77FTE18](https://openairdocs.org/ntsb/DEN77FTE18.md): Bell 47G3B1 · Cimmaron, CO · Accident · Minor injuries · Closed · Jan 24, 1977 · N1362X · Destroyed
- [NTSB CHI77FA025](https://openairdocs.org/ntsb/CHI77FA025.md): Piper PA-22 · Romeoville, IL · Accident · 2 fatal · Closed · Jan 23, 1977 · N4904Z · Destroyed
- [NTSB ANC77DAG30](https://openairdocs.org/ntsb/ANC77DAG30.md): Cessna 206 · False Pass, AK · Accident · No injuries · Closed · Jan 23, 1977 · N1981U · Substantial damage
- [NTSB SEA77DYM17](https://openairdocs.org/ntsb/SEA77DYM17.md): Beech 60 · Independence, OR · Accident · No injuries · Closed · Jan 22, 1977 · N7320D · Substantial damage
- [NTSB OAK77DVG18](https://openairdocs.org/ntsb/OAK77DVG18.md): Cessna 172 · Dunsmuir, CA · Accident · Serious injuries · Closed · Jan 22, 1977 · N19FD · Destroyed
- [NTSB MIA77FLT01](https://openairdocs.org/ntsb/MIA77FLT01.md): Dehavilland OHC-1 · Walls, MS · Accident · Serious injuries · Closed · Jan 22, 1977 · N8DW · Substantial damage
- [NTSB MIA77FKQ06](https://openairdocs.org/ntsb/MIA77FKQ06.md): Aeronca 7AC · Madison, MS · Accident · Minor injuries · Closed · Jan 22, 1977 · N1956E · Substantial damage
- [NTSB OAK77FVD10](https://openairdocs.org/ntsb/OAK77FVD10.md): Schweizer 2-33 · Fremont, CA · Accident · Minor injuries · Closed · Jan 21, 1977 · N1239S · Substantial damage
- [NTSB MKC77DCQ14](https://openairdocs.org/ntsb/MKC77DCQ14.md): Aeronca 11AC · Tetmore, KS · Accident · No injuries · Closed · Jan 21, 1977 · N9539E · Substantial damage
- [NTSB CHI77FEP14](https://openairdocs.org/ntsb/CHI77FEP14.md): Piper PA-23 · Lone Rock, WI · Accident · Minor injuries · Closed · Jan 21, 1977 · N1275P · Destroyed
- [NTSB SEA77FYP17](https://openairdocs.org/ntsb/SEA77FYP17.md): Aeronca 11AC · Harrah, WA · Accident · Minor injuries · Closed · Jan 20, 1977 · N9791E · Substantial damage
- [NTSB DEN77FTE16](https://openairdocs.org/ntsb/DEN77FTE16.md): Cessna 150M · Fort Collins, CO · Accident · Serious injuries · Closed · Jan 19, 1977 · N66100 · Destroyed
- [NTSB OAK77FA013](https://openairdocs.org/ntsb/OAK77FA013.md): Beech C45H · Sonoma, CA · Accident · 2 fatal · Closed · Jan 16, 1977 · N94972 · Destroyed
- [NTSB MIA77FLD25](https://openairdocs.org/ntsb/MIA77FLD25.md): Piper PA-28 · Vero Beach, FL · Accident · Minor injuries · Closed · Jan 14, 1977 · N5406F · Substantial damage
- [NTSB MIA77FKG15](https://openairdocs.org/ntsb/MIA77FKG15.md): Aero Comdr 100 · Newman, GA · Accident · Minor injuries · Closed · Jan 14, 1977 · N4117X · Substantial damage
- [NTSB NYC77FNC17](https://openairdocs.org/ntsb/NYC77FNC17.md): Cessna 172 · Caribu, ME · Accident · Serious injuries · Closed · Jan 13, 1977 · N7138Q · Substantial damage
- [NTSB IAD77FKW12](https://openairdocs.org/ntsb/IAD77FKW12.md): Piper PA28 · Crossville, TN · Accident · No injuries · Closed · Jan 13, 1977 · N5884W · Substantial damage
- [NTSB LAX77FA023](https://openairdocs.org/ntsb/LAX77FA023.md): Cessna 140 · Riverside, CA · Accident · 1 fatal · Closed · Jan 12, 1977 · N2155V · 2 aircraft · Destroyed
- [NTSB FTW77FA029](https://openairdocs.org/ntsb/FTW77FA029.md): Beech 95-B55 · Pampa, TX · Accident · 4 fatal · Closed · Jan 12, 1977 · N179W · Destroyed
- [NTSB FTW77FQG08](https://openairdocs.org/ntsb/FTW77FQG08.md): Cessna 150H · Sonora, TX · Accident · Serious injuries · Closed · Jan 10, 1977 · N22464 · 2 aircraft · Substantial damage
- [NTSB FTW77DRG23](https://openairdocs.org/ntsb/FTW77DRG23.md): Cessna 150 · Rio Grand City, TX · Accident · No injuries · Closed · Jan 10, 1977 · N7153X · Substantial damage
- [NTSB SEA77DYM14](https://openairdocs.org/ntsb/SEA77DYM14.md): Cessna 182 · Waldport, OR · Accident · No injuries · Closed · Jan 9, 1977 · N8720X · Substantial damage
- [NTSB OAK77FA010](https://openairdocs.org/ntsb/OAK77FA010.md): Piper PA-28R · Lemoore, CA · Accident · 2 fatal · Closed · Jan 9, 1977 · N441S · Destroyed
- [NTSB NYC77FHA11](https://openairdocs.org/ntsb/NYC77FHA11.md): Piper PA-24 · Allentown, PA · Accident · Minor injuries · Closed · Jan 9, 1977 · N8014P · Substantial damage
- [NTSB CHI77FA023](https://openairdocs.org/ntsb/CHI77FA023.md): Beech K35 · Delaware Twp, IN · Accident · 1 fatal · Closed · Jan 9, 1977 · N6098E · Destroyed
- [NTSB MIA77FLG06](https://openairdocs.org/ntsb/MIA77FLG06.md): Cessna 150M · Isle Of Palms, SC · Accident · No injuries · Closed · Jan 8, 1977 · N8805U · Substantial damage
- [NTSB MIA77DLA14](https://openairdocs.org/ntsb/MIA77DLA14.md): Boeing B75N1 · Trenton, FL · Accident · No injuries · Closed · Jan 8, 1977 · N5819V · Substantial damage
- [NTSB IAD77FKM10](https://openairdocs.org/ntsb/IAD77FKM10.md): Piper PA-28R · Julian, NC · Accident · No injuries · Closed · Jan 8, 1977 · N472HH · Substantial damage
- [NTSB NYC77DNA08](https://openairdocs.org/ntsb/NYC77DNA08.md): Piper PA-28 · Beverly, MA · Accident · No injuries · Closed · Jan 6, 1977 · N15963 · Substantial damage

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

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

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