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

## Cases, newest first

- [NTSB NYC80FHM07](https://openairdocs.org/ntsb/NYC80FHM07.md): Cessna 182 · Spring Valley, NY · Accident · Minor injuries · Closed · Jan 17, 1980 · N4789N · Destroyed
- [NTSB MIA80FLD38](https://openairdocs.org/ntsb/MIA80FLD38.md): Cessna 150 · Melbourne, FL · Accident · No injuries · Closed · Jan 17, 1980 · N9379U · Substantial damage
- [NTSB CHI80FA021](https://openairdocs.org/ntsb/CHI80FA021.md): Cessna 310Q · Winthrop Hbr, IL · Accident · 2 fatal · Closed · Jan 16, 1980 · N40AK · Destroyed
- [NTSB ANC80FA023](https://openairdocs.org/ntsb/ANC80FA023.md): Cessna 185 · Shungnak, AK · Accident · 7 fatal · Closed · Jan 14, 1980 · N1690Z · Destroyed
- [NTSB MIA80FA026](https://openairdocs.org/ntsb/MIA80FA026.md): Beech M35 · Leesburg, FL · Accident · 1 fatal · Closed · Jan 13, 1980 · N9320Y · Destroyed
- [NTSB CHI80FEG07](https://openairdocs.org/ntsb/CHI80FEG07.md): Cessna 210 · Hillsboro, OH · Accident · No injuries · Closed · Jan 13, 1980 · N4930U · Substantial damage
- [NTSB MIA80FA025](https://openairdocs.org/ntsb/MIA80FA025.md): Cessna 152 · Tampa, FL · Accident · 1 fatal · Closed · Jan 12, 1980 · N48956 · Destroyed
- [NTSB IAD80FLQ10](https://openairdocs.org/ntsb/IAD80FLQ10.md): Hughes 500D · Dione, KY · Accident · Serious injuries · Closed · Jan 11, 1980 · N9163F · Destroyed
- [NTSB DEN80FQA13](https://openairdocs.org/ntsb/DEN80FQA13.md): Cessna 210B · Albuquerque, NM · Accident · Serious injuries · Closed · Jan 11, 1980 · N5976X · Substantial damage
- [NTSB MIA80FKA03](https://openairdocs.org/ntsb/MIA80FKA03.md): Cessna 336 · Mona Island, PR · Accident · No injuries · Closed · Jan 10, 1980 · N1788Z · Substantial damage
- [NTSB LAX80FUM08](https://openairdocs.org/ntsb/LAX80FUM08.md): Bellanca 17-30A · El Cajon, CA · Accident · No injuries · Closed · Jan 10, 1980 · N28204 · Substantial damage
- [NTSB FTW80FA032](https://openairdocs.org/ntsb/FTW80FA032.md): Beech 95-B55 · Duncan, OK · Accident · 4 fatal · Closed · Jan 10, 1980 · N4643A · Destroyed
- [NTSB NYC80FNE08](https://openairdocs.org/ntsb/NYC80FNE08.md): Mooney M20E · Williamantic, CT · Accident · No injuries · Closed · Jan 5, 1980 · N9265V · Substantial damage
- [NTSB CHI80FEE14](https://openairdocs.org/ntsb/CHI80FEE14.md): Piper PA-34 · Elgin, IL · Accident · No injuries · Closed · Jan 3, 1980 · N30100 · Substantial damage
- [NTSB NYC80FA017](https://openairdocs.org/ntsb/NYC80FA017.md): Cessna 172N · Lindenhurst, NY · Accident · 2 fatal · Closed · Dec 30, 1979 · N738WX · Destroyed
- [NTSB NYC80DFJ02](https://openairdocs.org/ntsb/NYC80DFJ02.md): Schweizer SGS126 · Elmira, NY · Accident · No injuries · Closed · Dec 30, 1979 · N2508H · Substantial damage
- [NTSB IAD80DID07](https://openairdocs.org/ntsb/IAD80DID07.md): Luscombe 8E · Indian Valley, VA · Accident · No injuries · Closed · Dec 30, 1979 · N45765 · Substantial damage
- [NTSB CHI80FA020](https://openairdocs.org/ntsb/CHI80FA020.md): Piper PA-28 · Royal Oak, MI · Accident · 3 fatal · Closed · Dec 30, 1979 · N4512P · Destroyed
- [NTSB IAD80DLJ06](https://openairdocs.org/ntsb/IAD80DLJ06.md): Baby GRT LK 1 · Durham, NC · Accident · No injuries · Closed · Dec 29, 1979 · N1BL · Substantial damage
- [NTSB CHI80DEP11](https://openairdocs.org/ntsb/CHI80DEP11.md): Piper PA-28 · Rio Creek, WI · Accident · No injuries · Closed · Dec 29, 1979 · N15651 · Substantial damage
- [NTSB NYC80FA016](https://openairdocs.org/ntsb/NYC80FA016.md): Piper PA-28 · Broad Brook, CT · Accident · 2 fatal · Closed · Dec 28, 1979 · N16436 · Destroyed
- [NTSB DEN80FA016](https://openairdocs.org/ntsb/DEN80FA016.md): Beech B60 · Hayden, CO · Accident · 1 fatal · Closed · Dec 28, 1979 · N6030S · Destroyed
- [NTSB MKC80DER16](https://openairdocs.org/ntsb/MKC80DER16.md): Bellanca 7ECA · Paynesville, MN · Accident · Minor injuries · Closed · Dec 27, 1979 · N3086H · Destroyed
- [NTSB DEN79FA015](https://openairdocs.org/ntsb/DEN79FA015.md): Cessna 421B · Eagle.Co, CO · Accident · 5 fatal · Closed · Dec 26, 1979 · N100RV · Destroyed
- [NTSB MKC80FTG02](https://openairdocs.org/ntsb/MKC80FTG02.md): Beech C35 · Grand Forks, ND · Accident · Serious injuries · Closed · Dec 23, 1979 · N692D · Substantial damage
- [NTSB LAX80DA028](https://openairdocs.org/ntsb/LAX80DA028.md): Cessna 172N · Elko, NV · Accident · No injuries · Closed · Dec 23, 1979 · N738JL · 2 aircraft · Substantial damage
- [NTSB MKC80FCD09](https://openairdocs.org/ntsb/MKC80FCD09.md): Cessna 177RG · Greenfield, IA · Accident · No injuries · Closed · Dec 22, 1979 · N52195 · Substantial damage
- [NTSB NYC80FNC05](https://openairdocs.org/ntsb/NYC80FNC05.md): Cessna 180 · Turner, ME · Accident · Serious injuries · Closed · Dec 21, 1979 · N6417X · Substantial damage
- [NTSB FTW80FA024](https://openairdocs.org/ntsb/FTW80FA024.md): Cessna 421B · Locust Grove, AR · Accident · 4 fatal · Closed · Dec 21, 1979 · N5428J · Destroyed
- [NTSB DEN80FA012](https://openairdocs.org/ntsb/DEN80FA012.md): Mitsubishi MU-2B · Provo, UT · Accident · 2 fatal · Closed · Dec 21, 1979 · N200BR · Destroyed
- [NTSB CHI80FEC07](https://openairdocs.org/ntsb/CHI80FEC07.md): Piper PA-28 · Owosso, MI · Accident · No injuries · Closed · Dec 21, 1979 · N36700 · Substantial damage
- [NTSB CHI80FA016](https://openairdocs.org/ntsb/CHI80FA016.md): Cessna 172K · Edwardsville, IL · Accident · 2 fatal · Closed · Dec 21, 1979 · N736UL · Destroyed
- [NTSB CHI80DA017](https://openairdocs.org/ntsb/CHI80DA017.md): Cessna 310R · Green Bay, WI · Accident · 2 fatal · Closed · Dec 21, 1979 · N78ST · Destroyed
- [NTSB MKC80DCQ08](https://openairdocs.org/ntsb/MKC80DCQ08.md): Cessna 170B · Kingman, KS · Accident · No injuries · Closed · Dec 20, 1979 · N3050A · Substantial damage
- [NTSB FTW80DRA13](https://openairdocs.org/ntsb/FTW80DRA13.md): Beech 95-A55 · Angleton, TX · Accident · No injuries · Closed · Dec 17, 1979 · N910TL · Substantial damage
- [NTSB CHI80FET05](https://openairdocs.org/ntsb/CHI80FET05.md): Erco 415-CD · Lake Village, IN · Accident · Serious injuries · Closed · Dec 16, 1979 · N3857H · Substantial damage
- [NTSB CHI80FA015](https://openairdocs.org/ntsb/CHI80FA015.md): Piper PA-28 · Mansfield, OH · Accident · 1 fatal · Closed · Dec 16, 1979 · N5515F · Destroyed
- [NTSB LAX80FVM09](https://openairdocs.org/ntsb/LAX80FVM09.md): Piper J-3C · New Cuyana, CA · Accident · No injuries · Closed · Dec 15, 1979 · N71066 · Substantial damage
- [NTSB FTW80FRG13](https://openairdocs.org/ntsb/FTW80FRG13.md): Erco 415-C · Troy, TX · Accident · 1 fatal · Closed · Dec 15, 1979 · N93477 · Destroyed
- [NTSB DEN80FTE13](https://openairdocs.org/ntsb/DEN80FTE13.md): Cessna 182 · Gunnison, CO · Accident · Minor injuries · Closed · Dec 15, 1979 · N2191G · Destroyed
- [NTSB LAX80DUJ24](https://openairdocs.org/ntsb/LAX80DUJ24.md): Cessna 172M · Window Rock, AZ · Accident · No injuries · Closed · Dec 14, 1979 · N841JW · Substantial damage
- [NTSB MIA80DLA11](https://openairdocs.org/ntsb/MIA80DLA11.md): Cessna 152 · Tallahassee, FL · Accident · Minor injuries · Closed · Dec 13, 1979 · N24243 · Substantial damage
- [NTSB DEN80FTE07](https://openairdocs.org/ntsb/DEN80FTE07.md): Cessna 310K · Longmont, CO · Accident · No injuries · Closed · Dec 12, 1979 · N7058L · Substantial damage
- [NTSB SEA80FYP06](https://openairdocs.org/ntsb/SEA80FYP06.md): Cessna 305A · Sandpoint, ID · Accident · Serious injuries · Closed · Dec 9, 1979 · N5264G · Substantial damage
- [NTSB FTW80FRD11](https://openairdocs.org/ntsb/FTW80FRD11.md): Cessna 421B · Lafayette, LA · Accident · Serious injuries · Closed · Dec 9, 1979 · N5970M · Substantial damage
- [NTSB DEN80DQG03](https://openairdocs.org/ntsb/DEN80DQG03.md): Cessna 206 · Hobbs, NM · Accident · No injuries · Closed · Dec 9, 1979 · N735VE · Substantial damage
- [NTSB SEA80FA013](https://openairdocs.org/ntsb/SEA80FA013.md): Cessna T210M · Pasco, WA · Accident · 1 fatal · Closed · Dec 8, 1979 · N732QJ · Destroyed
- [NTSB SEA80FA012](https://openairdocs.org/ntsb/SEA80FA012.md): Aeronca 65-CA · Mountain Home, ID · Accident · 2 fatal · Closed · Dec 8, 1979 · N31929 · Substantial damage
- [NTSB FTW80FPJ05](https://openairdocs.org/ntsb/FTW80FPJ05.md): Piper PA-38 · Guymon, OK · Accident · No injuries · Closed · Dec 8, 1979 · N4387E · Substantial damage
- [NTSB IAD80DID04](https://openairdocs.org/ntsb/IAD80DID04.md): Piper PA-28 · Lynchburg, VA · Accident · No injuries · Closed · Dec 7, 1979 · N6410J · Substantial damage

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

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

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