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

## Cases, newest first

- [NTSB MKC80DCG06](https://openairdocs.org/ntsb/MKC80DCG06.md): Cessna 172M · Greenfield, MO · Accident · No injuries · Closed · Oct 14, 1980 · N9658V · Substantial damage
- [NTSB NYC81FHD03](https://openairdocs.org/ntsb/NYC81FHD03.md): Piper PA-34 · Burlington, NJ · Accident · No injuries · Closed · Oct 13, 1980 · N1482X · Substantial damage
- [NTSB LAX81FVD04](https://openairdocs.org/ntsb/LAX81FVD04.md): B/Gt Lakes BS-1 · Livermore, CA · Accident · 1 fatal · Closed · Oct 13, 1980 · N13BS · Destroyed
- [NTSB CHI81FEE03](https://openairdocs.org/ntsb/CHI81FEE03.md): Cessna 182P · Romeoville, IL · Accident · Serious injuries · Closed · Oct 12, 1980 · N21510 · Destroyed
- [NTSB FTW81FRG01](https://openairdocs.org/ntsb/FTW81FRG01.md): Bellanca 17-30 · San Antonio, TX · Accident · Minor injuries · Closed · Oct 11, 1980 · N4815V · Substantial damage
- [NTSB CHI81FEP05](https://openairdocs.org/ntsb/CHI81FEP05.md): Cessna 150L · Rhinelander, WI · Accident · No injuries · Closed · Oct 11, 1980 · N7730G · Substantial damage
- [NTSB ATL81FA007](https://openairdocs.org/ntsb/ATL81FA007.md): Cessna T188C · Theodore, AL · Accident · 4 fatal · Closed · Oct 11, 1980 · N2181J · 2 aircraft · Destroyed
- [NTSB NYC81IA002](https://openairdocs.org/ntsb/NYC81IA002.md): Lockheed L1011 · Newark, NJ · Incident · No injuries · Closed · Oct 10, 1980 · N31015 · 2 aircraft · No damage
- [NTSB NYC81FA003](https://openairdocs.org/ntsb/NYC81FA003.md): Cessna 500 · Plymouth, MA · Accident · No injuries · Closed · Oct 10, 1980 · N8JG · Substantial damage
- [NTSB MIA81FA001](https://openairdocs.org/ntsb/MIA81FA001.md): Piper PA-28 · Aguadilla, PR · Accident · 4 fatal · Closed · Oct 10, 1980 · N707XQ · Destroyed
- [NTSB MKC81FCA01](https://openairdocs.org/ntsb/MKC81FCA01-201171.md): Bellanca 17-30A · Fenton, MO · Accident · Serious injuries · Closed · Oct 9, 1980 · N8856V · Substantial damage
- [NTSB LAX81DXQ02](https://openairdocs.org/ntsb/LAX81DXQ02.md): Piper PA-28 · Elko, NV · Accident · Serious injuries · Closed · Oct 8, 1980 · N6883C · Destroyed
- [NTSB CHI81DEP04](https://openairdocs.org/ntsb/CHI81DEP04.md): Piper PA-28 · Cottage Grove, WI · Accident · No injuries · Closed · Oct 7, 1980 · N4817L · Substantial damage
- [NTSB NYC81DHD01](https://openairdocs.org/ntsb/NYC81DHD01.md): Cessna 172 · Woodbine, NJ · Accident · No injuries · Closed · Oct 6, 1980 · N9883J · Substantial damage
- [NTSB MKC81FA003](https://openairdocs.org/ntsb/MKC81FA003.md): Cessna 182H · Newcastle, WY · Accident · 2 fatal · Closed · Oct 6, 1980 · N3460S · Destroyed
- [NTSB LAX81FVM01](https://openairdocs.org/ntsb/LAX81FVM01.md): Cessna 210 · San Jose, CA · Accident · No injuries · Closed · Oct 6, 1980 · N7434E · Substantial damage
- [NTSB ATL81DKJ01](https://openairdocs.org/ntsb/ATL81DKJ01.md): Beech C18S · Theodore, AL · Accident · No injuries · Closed · Oct 5, 1980 · N6806C · Substantial damage
- [NTSB SEA81DYM02](https://openairdocs.org/ntsb/SEA81DYM02.md): Piper PA-28 · Molalla, OR · Accident · No injuries · Closed · Oct 3, 1980 · N33638 · Substantial damage
- [NTSB SEA81DYA01](https://openairdocs.org/ntsb/SEA81DYA01.md): Cessna 182 · Picabo, ID · Accident · No injuries · Closed · Oct 3, 1980 · N6797M · Substantial damage
- [NTSB FTW81FA002](https://openairdocs.org/ntsb/FTW81FA002.md): Cessna U206F · Lonoke, AR · Accident · Serious injuries · Closed · Oct 3, 1980 · N59179 · 2 aircraft · Substantial damage
- [NTSB ATL81FID01](https://openairdocs.org/ntsb/ATL81FID01.md): Mccullock J2 · Chesapeake, VA · Accident · Serious injuries · Closed · Oct 3, 1980 · N4372G · Destroyed
- [NTSB LAX80FVA03](https://openairdocs.org/ntsb/LAX80FVA03-128660.md): Piper PA-32 · Merced, CA · Accident · 2 fatal · Closed · Oct 2, 1980 · N21307 · Destroyed
- [NTSB FTW81FRJ02](https://openairdocs.org/ntsb/FTW81FRJ02.md): Piper PA-22 · Texarkana, TX · Accident · No injuries · Closed · Oct 2, 1980 · N2546A · Substantial damage
- [NTSB CHI80FEE53](https://openairdocs.org/ntsb/CHI80FEE53.md): Cessna 310Q · West Chicago, IL · Accident · No injuries · Closed · Sep 30, 1980 · N310CT · Substantial damage
- [NTSB LAX80FVD39](https://openairdocs.org/ntsb/LAX80FVD39.md): Dehavilland DH-82 · San Rafael, CA · Accident · Minor injuries · Closed · Sep 28, 1980 · CFFDZ · Substantial damage
- [NTSB LAX80FA143](https://openairdocs.org/ntsb/LAX80FA143.md): Cessna 150M · San Fernando, CA · Accident · 2 fatal · Closed · Sep 27, 1980 · N63093 · 2 aircraft · Destroyed
- [NTSB LAX80DVG75](https://openairdocs.org/ntsb/LAX80DVG75.md): Cessna 172C · Mount Shasta, CA · Accident · Minor injuries · Closed · Sep 26, 1980 · N1843Y · Destroyed
- [NTSB FTW80FA123](https://openairdocs.org/ntsb/FTW80FA123.md): Cessna U206 · Austin, TX · Accident · No injuries · Closed · Sep 26, 1980 · N6120X · Substantial damage
- [NTSB ATL88DKJ34](https://openairdocs.org/ntsb/ATL88DKJ34.md): Piper PA-25 · Bay Minette, AL · Accident · No injuries · Closed · Sep 26, 1980 · N7726Z · Destroyed
- [NTSB NYC80FNA26](https://openairdocs.org/ntsb/NYC80FNA26.md): Piper PA-28 · Hanson, MA · Accident · Serious injuries · Closed · Sep 24, 1980 · N5910F · Destroyed
- [NTSB MIA80FKA10](https://openairdocs.org/ntsb/MIA80FKA10.md): Cessna 172 · Guanica, PR · Accident · No injuries · Closed · Sep 24, 1980 · N3608S · Destroyed
- [NTSB LAX80FA142](https://openairdocs.org/ntsb/LAX80FA142.md): Aero Comdr 500-B · Santa Maria, CA · Accident · 2 fatal · Closed · Sep 24, 1980 · N6206X · Destroyed
- [NTSB CHI81FEK27](https://openairdocs.org/ntsb/CHI81FEK27-202519.md): Schleicher K7 · Montpelier, OH · Accident · No injuries · Closed · Sep 24, 1980 · N1002Z · Substantial damage
- [NTSB ATL80FKW23](https://openairdocs.org/ntsb/ATL80FKW23.md): Cessna 152 · Murfreesboro, TN · Accident · No injuries · Closed · Sep 23, 1980 · N5396M · Substantial damage
- [NTSB LAX80FUK04](https://openairdocs.org/ntsb/LAX80FUK04.md): Piper PA-28 · Show Low, AZ · Accident · Serious injuries · Closed · Sep 22, 1980 · N9819W · Substantial damage
- [NTSB ATL80FIA16](https://openairdocs.org/ntsb/ATL80FIA16.md): Cessna 172 · Manassas, VA · Accident · No injuries · Closed · Sep 22, 1980 · N6284D · Substantial damage
- [NTSB DEN80DTG17](https://openairdocs.org/ntsb/DEN80DTG17.md): Cessna 150 · Oakes, ND · Accident · No injuries · Closed · Sep 21, 1980 · N4814X · Substantial damage
- [NTSB FTW80DPG68](https://openairdocs.org/ntsb/FTW80DPG68.md): Cessna 172I · Marianna, AR · Accident · No injuries · Closed · Sep 20, 1980 · N46047 · Substantial damage
- [NTSB SEA80DYM62](https://openairdocs.org/ntsb/SEA80DYM62.md): Cessna 182P · Goldendale, WA · Accident · No injuries · Closed · Sep 18, 1980 · N1498M · Substantial damage
- [NTSB FTW80FQA44](https://openairdocs.org/ntsb/FTW80FQA44.md): Raven RX-7 · Albuquerque, NM · Accident · Minor injuries · Closed · Sep 18, 1980 · N55536 · Destroyed
- [NTSB MKC80FA057](https://openairdocs.org/ntsb/MKC80FA057.md): Gulf-Amer AA-5B · Chesterfield, MO · Accident · 3 fatal · Closed · Sep 17, 1980 · N4516L · Destroyed
- [NTSB FTW80DRG72](https://openairdocs.org/ntsb/FTW80DRG72.md): Cessna TU206F · Mcallen, TX · Accident · No injuries · Closed · Sep 16, 1980 · N8495Q · Substantial damage
- [NTSB ATL80FKG27](https://openairdocs.org/ntsb/ATL80FKG27.md): Aerostar 601P · Peachtree City, GA · Accident · Minor injuries · Closed · Sep 15, 1980 · N333BM · Substantial damage
- [NTSB ATL80DKW21](https://openairdocs.org/ntsb/ATL80DKW21.md): Champion 7ECA · Lawrenceburg, TN · Accident · No injuries · Closed · Sep 14, 1980 · N1633G · Substantial damage
- [NTSB ANC80DAH05](https://openairdocs.org/ntsb/ANC80DAH05.md): Cessna U206G · Dillingham, AK · Accident · No injuries · Closed · Sep 14, 1980 · N144BM · Substantial damage
- [NTSB CHI80DEE55](https://openairdocs.org/ntsb/CHI80DEE55.md): Piper PA-28 · New Lenox, IL · Accident · No injuries · Closed · Sep 13, 1980 · N55526 · Substantial damage
- [NTSB MIA80FA099](https://openairdocs.org/ntsb/MIA80FA099.md): Beech 65 · Clearwater, FL · Accident · 6 fatal · Closed · Sep 12, 1980 · N625GP · Destroyed
- [NTSB FTW80FA114](https://openairdocs.org/ntsb/FTW80FA114.md): Cessna 401 · Houma, LA · Accident · 1 fatal · Closed · Sep 12, 1980 · N444CS · 2 aircraft · Destroyed
- [NTSB DEN80FTE78](https://openairdocs.org/ntsb/DEN80FTE78.md): Cessna 210A · Brighton, CO · Accident · No injuries · Closed · Sep 11, 1980 · N9459X · Substantial damage
- [NTSB ANC80DAH06](https://openairdocs.org/ntsb/ANC80DAH06.md): Lake 4-200 · Anchorage, AK · Accident · No injuries · Closed · Sep 9, 1980 · N1112L · Substantial damage

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

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

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