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

## Cases, newest first

- [NTSB FTW72FRG48](https://openairdocs.org/ntsb/FTW72FRG48.md): Cessna 150F · Ingleside, TX · Accident · Minor injuries · Closed · Feb 5, 1972 · N7000F · Substantial damage
- [NTSB CHI72FEC27](https://openairdocs.org/ntsb/CHI72FEC27.md): Piper PA-28 · Ann Arbor, MI · Accident · No injuries · Closed · Feb 5, 1972 · N9790W · Substantial damage
- [NTSB MKC72FER37](https://openairdocs.org/ntsb/MKC72FER37.md): Cessna 210K · Duluth, MN · Accident · Serious injuries · Closed · Feb 4, 1972 · N9468M · Substantial damage
- [NTSB DEN72AD035](https://openairdocs.org/ntsb/DEN72AD035.md): Mooney M20C · Dugway, UT · Accident · 2 fatal · Closed · Feb 4, 1972 · N9412V · Destroyed
- [NTSB MKC72FCG36](https://openairdocs.org/ntsb/MKC72FCG36.md): Piper PA-28 · Columbia, MO · Accident · Minor injuries · Closed · Feb 3, 1972 · N9178W · Destroyed
- [NTSB NYC72DNC24](https://openairdocs.org/ntsb/NYC72DNC24.md): Piper PA-28 · Londonderry, NH · Accident · Minor injuries · Closed · Feb 2, 1972 · N9337W · Substantial damage
- [NTSB MIA72AM077](https://openairdocs.org/ntsb/MIA72AM077.md): Piper PA-23 · Memphis, TN · Accident · 3 fatal · Closed · Feb 2, 1972 · N5638Y · Destroyed
- [NTSB OAK72DVA42](https://openairdocs.org/ntsb/OAK72DVA42.md): Beech D55 · Porterville, CA · Accident · No injuries · Closed · Jan 30, 1972 · N711RX · Substantial damage
- [NTSB FTW72DPJ30](https://openairdocs.org/ntsb/FTW72DPJ30.md): Piper PA-28 · Duncan, OK · Accident · No injuries · Closed · Jan 29, 1972 · N5074W · Substantial damage
- [NTSB OAK72DVG33](https://openairdocs.org/ntsb/OAK72DVG33.md): Cessna 401 · Grass Vally, CA · Accident · No injuries · Closed · Jan 28, 1972 · N8433F · Substantial damage
- [NTSB UNK72X0104](https://openairdocs.org/ntsb/UNK72X0104.md): Cessna 182 · Kibati, Tanzania · Accident · 1 fatal · Closed · Jan 26, 1972 · N6251A · Substantial damage
- [NTSB CHI72DEI29](https://openairdocs.org/ntsb/CHI72DEI29.md): Piper PA-28 · Swanton, OH · Accident · No injuries · Closed · Jan 26, 1972 · N423FL · Substantial damage
- [NTSB NYC72FHD26](https://openairdocs.org/ntsb/NYC72FHD26.md): Cessna 177 · New London, PA · Accident · No injuries · Closed · Jan 23, 1972 · N29617 · Substantial damage
- [NTSB NYC72FGM29](https://openairdocs.org/ntsb/NYC72FGM29.md): Beech A35 · Weirton, WV · Accident · No injuries · Closed · Jan 23, 1972 · N8542A · Substantial damage
- [NTSB SEA72DYG27](https://openairdocs.org/ntsb/SEA72DYG27.md): Piper PA-28 · Brewster, WA · Accident · No injuries · Closed · Jan 22, 1972 · N5279W · Substantial damage
- [NTSB CHI72DEI31](https://openairdocs.org/ntsb/CHI72DEI31.md): Piper PA-28R · Painesville, OH · Accident · No injuries · Closed · Jan 22, 1972 · N2607R · Substantial damage
- [NTSB NYC72FHM25](https://openairdocs.org/ntsb/NYC72FHM25.md): Piper PA-28 · Clarkstown, NY · Accident · Serious injuries · Closed · Jan 21, 1972 · N4285J · Destroyed
- [NTSB NYC72AN090](https://openairdocs.org/ntsb/NYC72AN090.md): Piper PA-24 · Morgantown, WV · Accident · 2 fatal · Closed · Jan 21, 1972 · N5986P · Destroyed
- [NTSB CHI72AC061](https://openairdocs.org/ntsb/CHI72AC061.md): Piper PA-23 · St.Charles, IL · Accident · 1 fatal · Closed · Jan 21, 1972 · N4029P · Destroyed
- [NTSB NYC72FFA32](https://openairdocs.org/ntsb/NYC72FFA32.md): Cessna 172K · Rexford, NY · Accident · Minor injuries · Closed · Jan 20, 1972 · N7067G · Substantial damage
- [NTSB MIA72AM071](https://openairdocs.org/ntsb/MIA72AM071.md): Cessna 310D · Mableton, GA · Accident · 1 fatal · Closed · Jan 20, 1972 · N162G · Destroyed
- [NTSB SEA72FTI11](https://openairdocs.org/ntsb/SEA72FTI11.md): Cessna 172 · Kalispell, MT · Accident · No injuries · Closed · Jan 19, 1972 · N6185E · Substantial damage
- [NTSB FTW72FPA13](https://openairdocs.org/ntsb/FTW72FPA13.md): Beech A35 · Dallas, TX · Accident · Serious injuries · Closed · Jan 19, 1972 · N785B · Destroyed
- [NTSB MIA72DLD38](https://openairdocs.org/ntsb/MIA72DLD38.md): Starduster TWO · Clearwater, FL · Accident · No injuries · Closed · Jan 18, 1972 · N800RE · Substantial damage
- [NTSB FTW72AF044](https://openairdocs.org/ntsb/FTW72AF044.md): Gates Lear 25 · Victoria, TX · Accident · 9 fatal · Closed · Jan 18, 1972 · N658TC · Destroyed
- [NTSB NYC72FNA28](https://openairdocs.org/ntsb/NYC72FNA28.md): Cessna 150J · Lincoln, RI · Accident · No injuries · Closed · Jan 17, 1972 · N50714 · Substantial damage
- [NTSB OAK72DVG31](https://openairdocs.org/ntsb/OAK72DVG31.md): Cessna 210 · Sacramento, CA · Accident · No injuries · Closed · Jan 16, 1972 · N6901R · Substantial damage
- [NTSB LAX72FUJ66](https://openairdocs.org/ntsb/LAX72FUJ66.md): Meyers OTW145 · Wenden, AZ · Accident · No injuries · Closed · Jan 15, 1972 · N34321 · Substantial damage
- [NTSB FTW72DRJ19](https://openairdocs.org/ntsb/FTW72DRJ19.md): Cessna 210H · Cottonport, LA · Accident · No injuries · Closed · Jan 14, 1972 · N5958F · Substantial damage
- [NTSB OAK72FVD30](https://openairdocs.org/ntsb/OAK72FVD30.md): Cessna 150L · Stockton, CA · Accident · Serious injuries · Closed · Jan 13, 1972 · N6511G · Destroyed
- [NTSB MIA72FLG22](https://openairdocs.org/ntsb/MIA72FLG22.md): Cessna 172K · Greer, SC · Accident · Serious injuries · Closed · Jan 12, 1972 · N7142G · Substantial damage
- [NTSB FTW72FRA30](https://openairdocs.org/ntsb/FTW72FRA30.md): Cessna 172 · Katy, TX · Accident · No injuries · Closed · Jan 10, 1972 · N2501U · Substantial damage
- [NTSB CHI72DEI27](https://openairdocs.org/ntsb/CHI72DEI27.md): Cessna 150 · Chardon, OH · Accident · No injuries · Closed · Jan 10, 1972 · N8374M · Substantial damage
- [NTSB OAK72AP023](https://openairdocs.org/ntsb/OAK72AP023.md): Piper PA-28 · Mt.Herman, CA · Accident · 1 fatal · Closed · Jan 9, 1972 · N4181J · Destroyed
- [NTSB CHI72AC058](https://openairdocs.org/ntsb/CHI72AC058.md): Cessna 182H · Brazil, IN · Accident · 2 fatal · Closed · Jan 9, 1972 · N8351S · Destroyed
- [NTSB CHI72AC057](https://openairdocs.org/ntsb/CHI72AC057.md): Piper PA-28 · Salem, MI · Accident · 4 fatal · Closed · Jan 9, 1972 · N7039W · Destroyed
- [NTSB NYC72FHA30](https://openairdocs.org/ntsb/NYC72FHA30.md): Piper PA-28 · Wyoming, PA · Accident · Minor injuries · Closed · Jan 8, 1972 · N5991U · Substantial damage
- [NTSB CHI72FLQ29](https://openairdocs.org/ntsb/CHI72FLQ29.md): Mooney M20C · Ferguson, KY · Accident · No injuries · Closed · Jan 8, 1972 · N1348W · Substantial damage
- [NTSB CHI72DEA27](https://openairdocs.org/ntsb/CHI72DEA27.md): Cessna 150 · Lebanon, IN · Accident · No injuries · Closed · Jan 8, 1972 · N8098F · Substantial damage
- [NTSB ANC72DAG86](https://openairdocs.org/ntsb/ANC72DAG86.md): Smith Mini DSA-1 · Anchorage, AK · Accident · Minor injuries · Closed · Jan 7, 1972 · N791J · Substantial damage
- [NTSB LAX72FUQ59](https://openairdocs.org/ntsb/LAX72FUQ59.md): Cessna 172K · Palmdale, CA · Accident · Minor injuries · Closed · Jan 5, 1972 · N7098G · Substantial damage
- [NTSB NYC72AN087](https://openairdocs.org/ntsb/NYC72AN087.md): Piper PA-30 · Hanover, MD · Accident · 1 fatal · Closed · Jan 4, 1972 · N8821Y · Destroyed
- [NTSB MIA72FKJ39](https://openairdocs.org/ntsb/MIA72FKJ39.md): Piper PA-28 · Mobile, AL · Accident · Minor injuries · Closed · Jan 2, 1972 · N1856T · Substantial damage
- [NTSB FTW72FPG60](https://openairdocs.org/ntsb/FTW72FPG60.md): Beech S35 · De Queen, AR · Accident · Serious injuries · Closed · Jan 2, 1972 · N5601K · Substantial damage
- [NTSB FTW72FPG59](https://openairdocs.org/ntsb/FTW72FPG59.md): Cessna 172 · Parkin, AR · Accident · No injuries · Closed · Jan 2, 1972 · N3642S · Substantial damage
- [NTSB OAK72FVA40](https://openairdocs.org/ntsb/OAK72FVA40.md): Beech V35A · Piedra, CA · Accident · No injuries · Closed · Jan 1, 1972 · N328S · Destroyed
- [NTSB LAX72FUQ52](https://openairdocs.org/ntsb/LAX72FUQ52.md): Cessna 170 · S.Fernando, CA · Accident · No injuries · Closed · Jan 1, 1972 · N2631V · Destroyed
- [NTSB LAX72FUM17](https://openairdocs.org/ntsb/LAX72FUM17.md): Bell 47G-2 · Chula Vista, CA · Accident · No injuries · Closed · Jan 1, 1972 · N919SF · Substantial damage
- [NTSB CHI72DEV20](https://openairdocs.org/ntsb/CHI72DEV20.md): Taylorcraft BC12-D · Jacksonville, IL · Accident · No injuries · Closed · Dec 31, 1971 · N95057 · Substantial damage
- [NTSB CHI72AC056](https://openairdocs.org/ntsb/CHI72AC056.md): Piper PA-24 · Rockford, IL · Accident · 2 fatal · Closed · Dec 30, 1971 · N5518P · Destroyed

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

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

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