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

## Cases, newest first

- [NTSB FTW70AF049](https://openairdocs.org/ntsb/FTW70AF049.md): Piper PA-23 · Tulsa, OK · Accident · No injuries · Closed · Jan 23, 1970 · N6847Y · 2 aircraft · Substantial damage
- [NTSB DEN70FXT02](https://openairdocs.org/ntsb/DEN70FXT02.md): Aero Comdr 680-F · Ogden, UT · Accident · Minor injuries · Closed · Jan 23, 1970 · N345PS · Substantial damage
- [NTSB CHI70FGA04](https://openairdocs.org/ntsb/CHI70FGA04.md): Piper PA-28 · Piqua, OH · Accident · No injuries · Closed · Jan 23, 1970 · N98208 · Substantial damage
- [NTSB DEN70AD046](https://openairdocs.org/ntsb/DEN70AD046.md): Aero Comdr 680V · Aspen, CO · Accident · 8 fatal · Closed · Jan 22, 1970 · N6359U · Destroyed
- [NTSB CHI70FBJ04](https://openairdocs.org/ntsb/CHI70FBJ04.md): Piper PA-23 · Conway, MI · Accident · Minor injuries · Closed · Jan 22, 1970 · N5245Y · Destroyed
- [NTSB MKC70FDM03](https://openairdocs.org/ntsb/MKC70FDM03.md): Dehavilland DHC-2 · Ely, MN · Accident · No injuries · Closed · Jan 21, 1970 · N11255 · Substantial damage
- [NTSB CHI70FBG04](https://openairdocs.org/ntsb/CHI70FBG04.md): Piper PA-28 · Ann Arbor, MI · Accident · No injuries · Closed · Jan 21, 1970 · N9164J · Substantial damage
- [NTSB MKC70DCD06](https://openairdocs.org/ntsb/MKC70DCD06.md): Piper PA-28 · Fairfield, IA · Accident · No injuries · Closed · Jan 18, 1970 · N8423R · Substantial damage
- [NTSB CHI70DDJ05](https://openairdocs.org/ntsb/CHI70DDJ05.md): Cessna 150 · Waukesha, WI · Accident · No injuries · Closed · Jan 18, 1970 · N7959E · Substantial damage
- [NTSB MIA70FKQ01](https://openairdocs.org/ntsb/MIA70FKQ01.md): Cessna 150J · Southaven, MS · Accident · No injuries · Closed · Jan 17, 1970 · N61192 · Substantial damage
- [NTSB MIA70FKG02](https://openairdocs.org/ntsb/MIA70FKG02.md): Beech 95-A55 · Kennesaw, GA · Accident · Serious injuries · Closed · Jan 15, 1970 · N9586Y · Substantial damage
- [NTSB CHI70FBA02](https://openairdocs.org/ntsb/CHI70FBA02.md): Piper PA-22 · Mooresville, IN · Accident · No injuries · Closed · Jan 15, 1970 · N4977Z · Substantial damage
- [NTSB MKC70DDQ01](https://openairdocs.org/ntsb/MKC70DDQ01.md): Cessna 150 · Miller, SD · Accident · No injuries · Closed · Jan 13, 1970 · N2870S · Substantial damage
- [NTSB CHI70FGD02](https://openairdocs.org/ntsb/CHI70FGD02.md): Cessna 310K · Mentor, OH · Accident · Serious injuries · Closed · Jan 13, 1970 · N6901L · Substantial damage
- [NTSB MIA70AM055](https://openairdocs.org/ntsb/MIA70AM055.md): Piper PA-23 · Bay Minette, AL · Accident · Serious injuries · Closed · Jan 11, 1970 · N6661Y · Destroyed
- [NTSB FTW70AF046](https://openairdocs.org/ntsb/FTW70AF046.md): Douglas DC-9 · Harlingen, TX · Accident · No injuries · Closed · Jan 11, 1970 · N1308T · Substantial damage
- [NTSB MKC70DCD01](https://openairdocs.org/ntsb/MKC70DCD01.md): Cessna 177 · Osage, IA · Accident · No injuries · Closed · Jan 10, 1970 · N3358T · Substantial damage
- [NTSB LAX70AL040](https://openairdocs.org/ntsb/LAX70AL040.md): Grumman G-21A · Avalon, CA · Accident · No injuries · Closed · Jan 10, 1970 · N329 · Minor damage
- [NTSB MKC70DCQ02](https://openairdocs.org/ntsb/MKC70DCQ02.md): Cessna 172K · Salina, KS · Accident · No injuries · Closed · Jan 9, 1970 · N79903 · Substantial damage
- [NTSB DEN70FXT01](https://openairdocs.org/ntsb/DEN70FXT01.md): Cessna 182 · Spanish Fork, UT · Accident · No injuries · Closed · Jan 8, 1970 · N1951X · Substantial damage
- [NTSB MKC70FCQ01](https://openairdocs.org/ntsb/MKC70FCQ01.md): Beech 95-B55 · Hutchinson, KS · Accident · Serious injuries · Closed · Jan 7, 1970 · N5896J · Substantial damage
- [NTSB ANC70AA054](https://openairdocs.org/ntsb/ANC70AA054.md): Cessna 180 · Bethel, AK · Accident · No injuries · Closed · Jan 7, 1970 · N4641U · Substantial damage
- [NTSB NYC70DHD02](https://openairdocs.org/ntsb/NYC70DHD02.md): Cessna 177 · Vineland, NJ · Accident · No injuries · Closed · Jan 4, 1970 · N3310T · Substantial damage
- [NTSB CHI70FGA02](https://openairdocs.org/ntsb/CHI70FGA02.md): Piper PA-24 · Erlanger, KY · Accident · No injuries · Closed · Jan 4, 1970 · N8444P · Substantial damage
- [NTSB CHI70AC043](https://openairdocs.org/ntsb/CHI70AC043.md): Cessna 150H · Collinsville, IL · Accident · 1 fatal · Closed · Jan 4, 1970 · N22419 · 2 aircraft · Destroyed
- [NTSB LAX70FUQ02](https://openairdocs.org/ntsb/LAX70FUQ02.md): Cessna 140 · Pacoima, CA · Accident · Serious injuries · Closed · Jan 3, 1970 · N2369V · Substantial damage
- [NTSB FTW70FPD02](https://openairdocs.org/ntsb/FTW70FPD02.md): Cessna 150H · Fort Worth, TX · Accident · Serious injuries · Closed · Jan 3, 1970 · N7295S · Substantial damage
- [NTSB NYC70DFA02](https://openairdocs.org/ntsb/NYC70DFA02-141377.md): Cessna 150 · Plattsburgh, NY · Accident · No injuries · Closed · Jan 2, 1970 · N6995F · Substantial damage
- [NTSB MIA70AM053](https://openairdocs.org/ntsb/MIA70AM053.md): Cessna 337B · Cedar Key, FL · Accident · 2 fatal · Closed · Jan 2, 1970 · N5497S · Destroyed
- [NTSB LAX70FUD01](https://openairdocs.org/ntsb/LAX70FUD01.md): Mooney M20E · Los Angeles, CA · Accident · Minor injuries · Closed · Jan 2, 1970 · N9253V · Substantial damage
- [NTSB MKC70FDD03](https://openairdocs.org/ntsb/MKC70FDD03.md): Champion 7CCM · Verona, ND · Accident · No injuries · Closed · Jan 1, 1970 · N4449E · Substantial damage
- [NTSB OAK70O0002](https://openairdocs.org/ntsb/OAK70O0002.md): Pilatus PC-6 · Saigon, VM · Accident · Serious injuries · Closed · Dec 31, 1969 · N391R · Substantial damage
- [NTSB MIA70A0051](https://openairdocs.org/ntsb/MIA70A0051.md): Beech V35A · Tampa, FL · Accident · 4 fatal · Closed · Dec 31, 1969 · N8351N · Destroyed
- [NTSB IAD70D0121](https://openairdocs.org/ntsb/IAD70D0121.md): Cessna 172 · Monroe, NC · Accident · No injuries · Closed · Dec 29, 1969 · N5775A · Substantial damage
- [NTSB ANC70D0087](https://openairdocs.org/ntsb/ANC70D0087.md): Piper PA-18 · Glennallen, AK · Accident · No injuries · Closed · Dec 28, 1969 · N2992Z · Substantial damage
- [NTSB MKC70F0316](https://openairdocs.org/ntsb/MKC70F0316.md): Cessna 182H · Kansas City, KS · Accident · Minor injuries · Closed · Dec 27, 1969 · N1803X · Substantial damage
- [NTSB MIA70D0264](https://openairdocs.org/ntsb/MIA70D0264.md): Cessna 150 · St Elmo, AL · Accident · No injuries · Closed · Dec 27, 1969 · N3465J · Destroyed
- [NTSB LAX70F0238](https://openairdocs.org/ntsb/LAX70F0238.md): Piper PA-28 · Rialto, CA · Accident · Minor injuries · Closed · Dec 27, 1969 · N9783W · Substantial damage
- [NTSB FTW70F0339](https://openairdocs.org/ntsb/FTW70F0339.md): Cessna 177 · Berwick, LA · Accident · Minor injuries · Closed · Dec 27, 1969 · N29549 · Substantial damage
- [NTSB CHI70F0377](https://openairdocs.org/ntsb/CHI70F0377.md): Piper J3C-65 · Paw Paw, MI · Accident · No injuries · Closed · Dec 27, 1969 · N5781N · Substantial damage
- [NTSB FTW70F0328](https://openairdocs.org/ntsb/FTW70F0328.md): Cessna 210 · Lufkin, TX · Accident · No injuries · Closed · Dec 25, 1969 · N9464X · Substantial damage
- [NTSB CHI70F0395](https://openairdocs.org/ntsb/CHI70F0395.md): Beech E33 · Milan, IL · Accident · Minor injuries · Closed · Dec 25, 1969 · N8314N · Substantial damage
- [NTSB SEA70D0127](https://openairdocs.org/ntsb/SEA70D0127.md): Piper PA-18 · Jordan Vally, OR · Accident · Minor injuries · Closed · Dec 24, 1969 · N1858P · Substantial damage
- [NTSB MIA70A0049](https://openairdocs.org/ntsb/MIA70A0049.md): Piper PA-30 · Crossville, TN · Accident · 1 fatal · Closed · Dec 23, 1969 · N7884Y · Destroyed
- [NTSB NYC70F0245](https://openairdocs.org/ntsb/NYC70F0245.md): Piper PA-28 · East Hanover, NJ · Accident · Minor injuries · Closed · Dec 21, 1969 · N6707W · Destroyed
- [NTSB MKC70A0035](https://openairdocs.org/ntsb/MKC70A0035.md): Beech 65-80 · Republic, MO · Accident · 1 fatal · Closed · Dec 21, 1969 · N1539S · Destroyed
- [NTSB FTW70F0344](https://openairdocs.org/ntsb/FTW70F0344.md): Beech 95-B55 · Addison, TX · Accident · Minor injuries · Closed · Dec 21, 1969 · N8489N · Substantial damage
- [NTSB MKC70D0293](https://openairdocs.org/ntsb/MKC70D0293.md): Cessna 170B · Baldwin City, KS · Accident · No injuries · Closed · Dec 20, 1969 · N3468C · Substantial damage
- [NTSB IAD70D0125](https://openairdocs.org/ntsb/IAD70D0125.md): Cessna 195 · Mt Jackson, VA · Accident · No injuries · Closed · Dec 20, 1969 · N10PB · Substantial damage
- [NTSB NYC70A0064](https://openairdocs.org/ntsb/NYC70A0064.md): Cessna 150H · Woodbury, CT · Accident · 1 fatal · Closed · Dec 18, 1969 · N6730S · Destroyed

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

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

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