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

## Cases, newest first

- [NTSB OAK72AP033](https://openairdocs.org/ntsb/OAK72AP033.md): Piper PA-28 · Columbia, CA · Accident · 4 fatal · Closed · Mar 19, 1972 · N3427R · Destroyed
- [NTSB DEN72DTM13](https://openairdocs.org/ntsb/DEN72DTM13.md): Cessna 170B · Monticello, UT · Accident · No injuries · Closed · Mar 18, 1972 · N8065A · Substantial damage
- [NTSB NYC72AN113](https://openairdocs.org/ntsb/NYC72AN113.md): Cessna 172 · Crewe, VA · Accident · 1 fatal · Closed · Mar 17, 1972 · N2586Y · Destroyed
- [NTSB OAK72DVG43](https://openairdocs.org/ntsb/OAK72DVG43.md): Cessna 172 · Napa, CA · Accident · No injuries · Closed · Mar 16, 1972 · N3901R · Substantial damage
- [NTSB FTW72FPG65](https://openairdocs.org/ntsb/FTW72FPG65.md): Beech V35 · Midway, AR · Accident · 1 fatal · Closed · Mar 16, 1972 · N721W · Substantial damage
- [NTSB CHI72FEE66](https://openairdocs.org/ntsb/CHI72FEE66.md): Beech C50 · Waukegan, IL · Accident · Serious injuries · Closed · Mar 16, 1972 · N3752B · Substantial damage
- [NTSB CHI72AC073](https://openairdocs.org/ntsb/CHI72AC073.md): Cessna 421A · Jefferson, OH · Accident · 2 fatal · Closed · Mar 15, 1972 · N3390Q · Destroyed
- [NTSB CHI72AC072](https://openairdocs.org/ntsb/CHI72AC072.md): Beech 3NM · Brook Park, OH · Accident · 1 fatal · Closed · Mar 15, 1972 · N6133 · Destroyed
- [NTSB NYC72AN111](https://openairdocs.org/ntsb/NYC72AN111.md): Mooney M20C · Poughkeepsie, NY · Accident · 3 fatal · Closed · Mar 12, 1972 · N6299U · Destroyed
- [NTSB MIA72FKG80](https://openairdocs.org/ntsb/MIA72FKG80.md): Cessna 150J · Chamblee, GA · Accident · Minor injuries · Closed · Mar 12, 1972 · N60556 · Substantial damage
- [NTSB FTW72FPM25](https://openairdocs.org/ntsb/FTW72FPM25.md): Piper PA-28 · Atoka, OK · Accident · Minor injuries · Closed · Mar 12, 1972 · N4335J · Substantial damage
- [NTSB CHI72DEM55](https://openairdocs.org/ntsb/CHI72DEM55.md): Piper PA-30 · Caspian, MI · Accident · No injuries · Closed · Mar 12, 1972 · N7878Y · Substantial damage
- [NTSB CHI72FEC31](https://openairdocs.org/ntsb/CHI72FEC31.md): N.American T-28 · Utica, MI · Accident · No injuries · Closed · Mar 11, 1972 · N3659G · Substantial damage
- [NTSB SEA72FYA26](https://openairdocs.org/ntsb/SEA72FYA26.md): Piper PA-28 · Caldwell, ID · Accident · No injuries · Closed · Mar 9, 1972 · N9340J · Substantial damage
- [NTSB NYC72FHD34](https://openairdocs.org/ntsb/NYC72FHD34.md): Cessna 310C · Medford, NJ · Accident · No injuries · Closed · Mar 9, 1972 · N6688B · Substantial damage
- [NTSB NYC72DNC33](https://openairdocs.org/ntsb/NYC72DNC33.md): Cessna 310H · West Dover, VT · Accident · No injuries · Closed · Mar 9, 1972 · N12TT · Substantial damage
- [NTSB MKC72FCG39](https://openairdocs.org/ntsb/MKC72FCG39.md): Taylorcraft BC12-D · Higginsville, MO · Accident · Serious injuries · Closed · Mar 9, 1972 · N43501 · Substantial damage
- [NTSB MKC72DCG41](https://openairdocs.org/ntsb/MKC72DCG41.md): Piper PA-28 · Milan, MO · Accident · No injuries · Closed · Mar 9, 1972 · N5673U · Substantial damage
- [NTSB CHI72AC070](https://openairdocs.org/ntsb/CHI72AC070.md): Gates Lear 25 · Sturgis, MI · Accident · No injuries · Closed · Mar 9, 1972 · N100J · Substantial damage
- [NTSB MKC72AK054](https://openairdocs.org/ntsb/MKC72AK054.md): Cessna 172F · Sioux Falls, SD · Accident · 2 fatal · Closed · Mar 8, 1972 · N8150U · Destroyed
- [NTSB NYC72FGM37](https://openairdocs.org/ntsb/NYC72FGM37.md): Piper PA-23 · Bradford, PA · Accident · Minor injuries · Closed · Mar 6, 1972 · N4375P · Substantial damage
- [NTSB DEN72FTE60](https://openairdocs.org/ntsb/DEN72FTE60.md): Schweizer SGU222 · Boulder, CO · Accident · No injuries · Closed · Mar 5, 1972 · N8678R · Substantial damage
- [NTSB DCA72AZ009](https://openairdocs.org/ntsb/DCA72AZ009.md): Fairchild FH227B · Albany, NY · Accident · 16 fatal · Closed · Mar 3, 1972 · N7818M · Destroyed
- [NTSB CHI72FEA34](https://openairdocs.org/ntsb/CHI72FEA34.md): Cessna 150H · Terre Haute, IN · Accident · No injuries · Closed · Mar 3, 1972 · N23238 · Substantial damage
- [NTSB MKC72AK053](https://openairdocs.org/ntsb/MKC72AK053.md): Beech D18S · Bismarck, ND · Accident · Serious injuries · Closed · Mar 2, 1972 · N375C · Destroyed
- [NTSB MIA72AM088](https://openairdocs.org/ntsb/MIA72AM088.md): Cessna 310J · Cartersville, GA · Accident · Serious injuries · Closed · Mar 1, 1972 · N15CM · 2 aircraft · Substantial damage
- [NTSB MIA72FKG76](https://openairdocs.org/ntsb/MIA72FKG76.md): Cessna 172 · Morven, GA · Accident · No injuries · Closed · Feb 29, 1972 · N6212E · Substantial damage
- [NTSB FTW72FPA16](https://openairdocs.org/ntsb/FTW72FPA16.md): Piper PA-22 · Hillsboro, TX · Accident · Minor injuries · Closed · Feb 27, 1972 · N3465Z · Destroyed
- [NTSB CHI72FEE65](https://openairdocs.org/ntsb/CHI72FEE65.md): Beech 35 · Ringwood, IL · Accident · Minor injuries · Closed · Feb 27, 1972 · N5050E · Substantial damage
- [NTSB SEA72FYA24](https://openairdocs.org/ntsb/SEA72FYA24.md): Beech V35 · Ketchum, ID · Accident · Serious injuries · Closed · Feb 26, 1972 · N843BW · Substantial damage
- [NTSB MIA72OKT70](https://openairdocs.org/ntsb/MIA72OKT70.md): Mooney M20C · Porvenir Islnd, RP · Accident · Minor injuries · Closed · Feb 26, 1972 · N5844Q · Substantial damage
- [NTSB MIA72DKT58](https://openairdocs.org/ntsb/MIA72DKT58.md): Amer Avco AA-1A · Boca Raton, FL · Accident · No injuries · Closed · Feb 26, 1972 · N9474L · Substantial damage
- [NTSB FTW72AF057](https://openairdocs.org/ntsb/FTW72AF057.md): Cessna 150 · Post, TX · Accident · 2 fatal · Closed · Feb 26, 1972 · N6706F · Destroyed
- [NTSB ANC72DAG94](https://openairdocs.org/ntsb/ANC72DAG94.md): Cessna 172K · Anchorage, AK · Accident · No injuries · Closed · Feb 26, 1972 · N84532 · Substantial damage
- [NTSB SEA72DYE23](https://openairdocs.org/ntsb/SEA72DYE23.md): Piper PA-28 · Spanaway, WA · Accident · No injuries · Closed · Feb 25, 1972 · N2336R · Substantial damage
- [NTSB OAK72AP029](https://openairdocs.org/ntsb/OAK72AP029.md): Cessna P206A · S.Francisco, CA · Accident · Serious injuries · Closed · Feb 23, 1972 · N4664F · Destroyed
- [NTSB CHI72FET16](https://openairdocs.org/ntsb/CHI72FET16.md): Beech 65-90 · Elkhart, IN · Accident · No injuries · Closed · Feb 23, 1972 · N11ER · Substantial damage
- [NTSB CHI72FET14](https://openairdocs.org/ntsb/CHI72FET14.md): Cessna 150H · South Bend, IN · Accident · Minor injuries · Closed · Feb 22, 1972 · N7240S · Destroyed
- [NTSB CHI72DEI34](https://openairdocs.org/ntsb/CHI72DEI34.md): Piper PA-28 · Chagrin Fall, OH · Accident · No injuries · Closed · Feb 19, 1972 · N7937N · Substantial damage
- [NTSB SEA72AS032](https://openairdocs.org/ntsb/SEA72AS032.md): Beech 99 · Spokane, WA · Accident · Minor injuries · Closed · Feb 18, 1972 · N21FW · Substantial damage
- [NTSB FTW72AF054](https://openairdocs.org/ntsb/FTW72AF054.md): Convair 600 · Beaumont, TX · Accident · No injuries · Closed · Feb 16, 1972 · N94226 · Substantial damage
- [NTSB MKC72DCJ47](https://openairdocs.org/ntsb/MKC72DCJ47.md): Cessna 150 · Weeping Watr, NE · Accident · No injuries · Closed · Feb 13, 1972 · N7982E · Substantial damage
- [NTSB MKC72DCD61](https://openairdocs.org/ntsb/MKC72DCD61.md): Cessna 172 · Gilman, IA · Accident · No injuries · Closed · Feb 13, 1972 · N4375Q · Substantial damage
- [NTSB OAK72FXQ23](https://openairdocs.org/ntsb/OAK72FXQ23.md): Beech K35 · Reno, NV · Accident · Serious injuries · Closed · Feb 12, 1972 · N3073C · Destroyed
- [NTSB LAX72DUJ73](https://openairdocs.org/ntsb/LAX72DUJ73.md): Bellanca 17-30 · Tucson, AZ · Accident · Serious injuries · Closed · Feb 12, 1972 · N4861V · Destroyed
- [NTSB IAD72FIA16](https://openairdocs.org/ntsb/IAD72FIA16.md): Cessna 170A · Winchester, VA · Accident · No injuries · Closed · Feb 12, 1972 · N1307D · Substantial damage
- [NTSB CHI72AC064](https://openairdocs.org/ntsb/CHI72AC064.md): Cessna 150G · Springfield, OH · Accident · 2 fatal · Closed · Feb 12, 1972 · N3629J · 2 aircraft · Destroyed
- [NTSB SEA72DTI13](https://openairdocs.org/ntsb/SEA72DTI13.md): Mooney M20E · Great Falls, MT · Accident · No injuries · Closed · Feb 6, 1972 · N9228V · Substantial damage
- [NTSB OAK72DJY08](https://openairdocs.org/ntsb/OAK72DJY08-201429.md): Dehavilland DHC-6 · Bouam Long, Laos · Accident · No injuries · Closed · Feb 6, 1972 · N774M · Substantial damage
- [NTSB MKC72DCD59](https://openairdocs.org/ntsb/MKC72DCD59.md): Champion 7ECA · Mediapolis, IA · Accident · No injuries · Closed · Feb 5, 1972 · N11055 · Substantial damage

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

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

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