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

## Cases, newest first

- [NTSB FTW79FPJ12](https://openairdocs.org/ntsb/FTW79FPJ12.md): Piper PA-28 · Purcell, OK · Accident · 1 fatal · Closed · Apr 26, 1979 · N8530W · Destroyed
- [NTSB NYC79FGM36](https://openairdocs.org/ntsb/NYC79FGM36.md): Cessna 150 · Northeast, PA · Accident · No injuries · Closed · Apr 25, 1979 · N6474G · Substantial damage
- [NTSB OAK79FA026](https://openairdocs.org/ntsb/OAK79FA026.md): Mooney M20E · Mercury, NV · Accident · Serious injuries · Closed · Apr 24, 1979 · N3394X · Destroyed
- [NTSB LAX79DUJ70](https://openairdocs.org/ntsb/LAX79DUJ70.md): Beech C-23 · Phoenix, AZ · Accident · No injuries · Closed · Apr 24, 1979 · N24629 · Substantial damage
- [NTSB CHI79FEP44](https://openairdocs.org/ntsb/CHI79FEP44.md): Cessna T210N · St. Francis, WI · Accident · Serious injuries · Closed · Apr 24, 1979 · N6485N · Substantial damage
- [NTSB OAK79DVM17](https://openairdocs.org/ntsb/OAK79DVM17.md): Cessna 150L · Palo Alto, CA · Accident · No injuries · Closed · Apr 22, 1979 · N19304 · Substantial damage
- [NTSB NYC79DHA11](https://openairdocs.org/ntsb/NYC79DHA11.md): Aeronca 11AC · Poyntelle, PA · Accident · No injuries · Closed · Apr 22, 1979 · N3295E · Substantial damage
- [NTSB MKC79DCD17](https://openairdocs.org/ntsb/MKC79DCD17.md): Cessna 150 · Omaha, NE · Accident · No injuries · Closed · Apr 22, 1979 · N17033 · Substantial damage
- [NTSB FTW79FPM07](https://openairdocs.org/ntsb/FTW79FPM07-136529.md): Cessna 182 · El Paso, TX · Accident · Serious injuries · Closed · Apr 21, 1979 · N9361X · Substantial damage
- [NTSB FTW79DA074](https://openairdocs.org/ntsb/FTW79DA074.md): Lear Jet 35A · Rogers, AR · Accident · No injuries · Closed · Apr 21, 1979 · N7735A · Substantial damage
- [NTSB CHI79FEX22](https://openairdocs.org/ntsb/CHI79FEX22.md): Cessna 340 · Columbus, IN · Accident · No injuries · Closed · Apr 21, 1979 · N69546 · Substantial damage
- [NTSB NYC79FA040](https://openairdocs.org/ntsb/NYC79FA040.md): Lake LA-4 · Jonesboro, ME · Accident · 1 fatal · Closed · Apr 20, 1979 · N7639L · Destroyed
- [NTSB MIA79FKG34](https://openairdocs.org/ntsb/MIA79FKG34.md): Aeronca 11BC · Warner Robins, GA · Accident · Serious injuries · Closed · Apr 19, 1979 · N86054 · Substantial damage
- [NTSB MKC79DCQ18](https://openairdocs.org/ntsb/MKC79DCQ18.md): Cessna 172 · Belleville, KS · Accident · Minor injuries · Closed · Apr 18, 1979 · N1455U · Substantial damage
- [NTSB LAX79DUJ72](https://openairdocs.org/ntsb/LAX79DUJ72.md): Schweizer 2-33A · Tucson, AZ · Accident · Minor injuries · Closed · Apr 18, 1979 · N17963 · Substantial damage
- [NTSB DEN79FTE31](https://openairdocs.org/ntsb/DEN79FTE31.md): Beech C45H · Firestone, CO · Accident · No injuries · Closed · Apr 18, 1979 · N6495D · Substantial damage
- [NTSB NYC79FNC23](https://openairdocs.org/ntsb/NYC79FNC23.md): Piper PA-32R · New London, NH · Accident · No injuries · Closed · Apr 17, 1979 · N1982H · Substantial damage
- [NTSB NYC79FA038](https://openairdocs.org/ntsb/NYC79FA038.md): Piper PA-24 · Smithville, NJ · Accident · Serious injuries · Closed · Apr 17, 1979 · N7318P · Destroyed
- [NTSB IAF79FLT04](https://openairdocs.org/ntsb/IAF79FLT04.md): Cessna 150 · Memphis, TN · Accident · No injuries · Closed · Apr 17, 1979 · N6099G · Substantial damage
- [NTSB IAD79DKM12](https://openairdocs.org/ntsb/IAD79DKM12.md): Cessna 172 · Spruce Pine, NC · Accident · Minor injuries · Closed · Apr 17, 1979 · N8222L · Substantial damage
- [NTSB CHI79FEX21](https://openairdocs.org/ntsb/CHI79FEX21.md): Beech C-23 · Fishers, IN · Accident · Serious injuries · Closed · Apr 17, 1979 · N2064L · Substantial damage
- [NTSB CHI79DEX20](https://openairdocs.org/ntsb/CHI79DEX20.md): Piper PA-28 · Lafayette, IN · Accident · No injuries · Closed · Apr 17, 1979 · N3661R · Substantial damage
- [NTSB OAK79FVG32](https://openairdocs.org/ntsb/OAK79FVG32.md): Great Lakes 2T-1A · Richvale, CA · Accident · Serious injuries · Closed · Apr 15, 1979 · N3811F · Destroyed
- [NTSB MIA79DLD58](https://openairdocs.org/ntsb/MIA79DLD58.md): Piper PA-44 · Useppa Island, FL · Accident · No injuries · Closed · Apr 14, 1979 · N2089K · Substantial damage
- [NTSB LAX79FA040](https://openairdocs.org/ntsb/LAX79FA040.md): Grumman G-21A · Catalina Is, CA · Accident · 1 fatal · Closed · Apr 14, 1979 · N11CS · Destroyed
- [NTSB CHI79FEK10](https://openairdocs.org/ntsb/CHI79FEK10.md): Cessna 150 · Marion, OH · Accident · No injuries · Closed · Apr 14, 1979 · N63032 · Substantial damage
- [NTSB MIA79FA070](https://openairdocs.org/ntsb/MIA79FA070.md): Beech 56TC · Howey In Hills, FL · Accident · 2 fatal · Closed · Apr 12, 1979 · N72571 · Destroyed
- [NTSB FTW79FA071](https://openairdocs.org/ntsb/FTW79FA071.md): Bell 206B · Cameron, LA · Accident · Minor injuries · Closed · Apr 12, 1979 · N59627 · Substantial damage
- [NTSB NYC79DNA15](https://openairdocs.org/ntsb/NYC79DNA15.md): Cessna 172 · Marlboro, MA · Accident · No injuries · Closed · Apr 11, 1979 · N5451H · Substantial damage
- [NTSB MIA79FKT53](https://openairdocs.org/ntsb/MIA79FKT53-137080.md): Cessna 150 · Ft.Lauderdale, FL · Accident · Minor injuries · Closed · Apr 11, 1979 · N3231X · Destroyed
- [NTSB DEN79FQA26](https://openairdocs.org/ntsb/DEN79FQA26.md): Piper PA-38 · Albuquerque, NM · Accident · No injuries · Closed · Apr 11, 1979 · N4470E · Substantial damage
- [NTSB OAK79DVD21](https://openairdocs.org/ntsb/OAK79DVD21.md): Cessna 182RG · Stockton, CA · Accident · No injuries · Closed · Apr 9, 1979 · N2263T · Substantial damage
- [NTSB CHI79FEK09](https://openairdocs.org/ntsb/CHI79FEK09.md): Cessna 210E · Westerville, OH · Accident · No injuries · Closed · Apr 8, 1979 · N4940U · Substantial damage
- [NTSB NYC79FGM22](https://openairdocs.org/ntsb/NYC79FGM22.md): Piper PA-22 · Monroeville, PA · Accident · 2 fatal · Closed · Apr 7, 1979 · N5720D · Destroyed
- [NTSB NYC79FGM20](https://openairdocs.org/ntsb/NYC79FGM20.md): Piper PA-32 · Connellsville, PA · Accident · No injuries · Closed · Apr 6, 1979 · N36473 · Substantial damage
- [NTSB FTW79DRJ12](https://openairdocs.org/ntsb/FTW79DRJ12.md): Cessna 152 · Alto, LA · Accident · No injuries · Closed · Apr 6, 1979 · N24506 · Substantial damage
- [NTSB CHI79IA043](https://openairdocs.org/ntsb/CHI79IA043.md): Learjet 25B · Swanton, OH · Incident · No injuries · Closed · Apr 6, 1979 · N2427F · No damage
- [NTSB NYC79FA035](https://openairdocs.org/ntsb/NYC79FA035.md): Beech E-18 · Newburg, NY · Accident · Serious injuries · Closed · Apr 4, 1979 · N149PA · Destroyed
- [NTSB NYC79FA034](https://openairdocs.org/ntsb/NYC79FA034.md): Piper PA-34 · Philadelphia, PA · Accident · 2 fatal · Closed · Apr 3, 1979 · N6211J · Destroyed
- [NTSB LAX79FUJ62](https://openairdocs.org/ntsb/LAX79FUJ62.md): Cessna 172 · Flagstaff, AZ · Accident · Serious injuries · Closed · Apr 3, 1979 · N9337E · Destroyed
- [NTSB CHI79FEI17](https://openairdocs.org/ntsb/CHI79FEI17.md): Cessna 150 · Warren, OH · Accident · No injuries · Closed · Apr 3, 1979 · N714PD · Substantial damage
- [NTSB CHI79DEG10](https://openairdocs.org/ntsb/CHI79DEG10.md): Douglas AD-4N · Harrison, OH · Accident · No injuries · Closed · Apr 3, 1979 · N91945 · Substantial damage
- [NTSB IAD79FA042](https://openairdocs.org/ntsb/IAD79FA042.md): Cessna 175 · Livingston, TN · Accident · 2 fatal · Closed · Apr 1, 1979 · N6734E · Destroyed
- [NTSB MIA79FLD54](https://openairdocs.org/ntsb/MIA79FLD54.md): Blanik L-13 · Clearwater, FL · Accident · No injuries · Closed · Mar 30, 1979 · N83AS · Substantial damage
- [NTSB LAX79FUJ59](https://openairdocs.org/ntsb/LAX79FUJ59.md): Beech 55 · Wickenburg, AZ · Accident · No injuries · Closed · Mar 30, 1979 · N255M · Substantial damage
- [NTSB FTW79FPJ09](https://openairdocs.org/ntsb/FTW79FPJ09.md): Cessna 182 · Guthrie, OK · Accident · No injuries · Closed · Mar 30, 1979 · N2509G · Substantial damage
- [NTSB FTW79DPJ10](https://openairdocs.org/ntsb/FTW79DPJ10.md): Cessna 210C · Seiling, OK · Accident · No injuries · Closed · Mar 30, 1979 · N3678Y · Substantial damage
- [NTSB UNK79X0109](https://openairdocs.org/ntsb/UNK79X0109.md): Piper PA-32 · San Diego, CA · Accident · No injuries · Closed · Mar 29, 1979 · N312AG · Substantial damage
- [NTSB MIA79DA063](https://openairdocs.org/ntsb/MIA79DA063.md): Cessna 172 · Daytona Beach, FL · Accident · No injuries · Closed · Mar 28, 1979 · N84ER · 2 aircraft · Substantial damage
- [NTSB CHI79FA037](https://openairdocs.org/ntsb/CHI79FA037.md): Piper PA-30 · Ludington, MI · Accident · 1 fatal · Closed · Mar 28, 1979 · N77334 · Destroyed

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

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

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