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

## Cases, newest first

- [NTSB MIA72FKG93](https://openairdocs.org/ntsb/MIA72FKG93.md): Cessna 150 · Lithonia, GA · Accident · No injuries · Closed · Apr 25, 1972 · N5720G · Substantial damage
- [NTSB FTW72FRG74](https://openairdocs.org/ntsb/FTW72FRG74.md): Beech K35 · Port Aransas, TX · Accident · No injuries · Closed · Apr 25, 1972 · N5130X · Substantial damage
- [NTSB ANC72FAH07](https://openairdocs.org/ntsb/ANC72FAH07.md): Champion 7GCBC · Ekwok, AK · Accident · Serious injuries · Closed · Apr 24, 1972 · N1651G · Substantial damage
- [NTSB NYC72FGM44](https://openairdocs.org/ntsb/NYC72FGM44.md): Luscombe 8E · Titusville, PA · Accident · No injuries · Closed · Apr 23, 1972 · N1423B · Substantial damage
- [NTSB MIA72AM113](https://openairdocs.org/ntsb/MIA72AM113.md): Aero Comdr 500-B · College Park, GA · Accident · 5 fatal · Closed · Apr 22, 1972 · N6319U · Destroyed
- [NTSB MIA72FKW24](https://openairdocs.org/ntsb/MIA72FKW24.md): Cessna 150L · Hixson, TN · Accident · Minor injuries · Closed · Apr 21, 1972 · N1785Q · Destroyed
- [NTSB UNK72X0108](https://openairdocs.org/ntsb/UNK72X0108.md): Cessna 172 · Ptd.Bight, Jamaica · Accident · No injuries · Closed · Apr 20, 1972 · N8065B · Destroyed
- [NTSB CHI72FEE72](https://openairdocs.org/ntsb/CHI72FEE72.md): Cassutt 11M · Naperville, IL · Accident · 1 fatal · Closed · Apr 18, 1972 · N55MS · Destroyed
- [NTSB MIA72FKT69](https://openairdocs.org/ntsb/MIA72FKT69.md): Piper PA-28 · W.Hollywood, FL · Accident · Serious injuries · Closed · Apr 17, 1972 · N2098R · Substantial damage
- [NTSB FTW72AF069](https://openairdocs.org/ntsb/FTW72AF069.md): Piper PA-28 · Dallas, TX · Accident · Minor injuries · Closed · Apr 17, 1972 · N1512J · 2 aircraft · Substantial damage
- [NTSB CHI72DEI36](https://openairdocs.org/ntsb/CHI72DEI36.md): Cessna 172 · Toledo, OH · Accident · No injuries · Closed · Apr 17, 1972 · N4292L · Substantial damage
- [NTSB NYC72FKM32](https://openairdocs.org/ntsb/NYC72FKM32.md): Piper PA-12 · Rockingham, NC · Accident · No injuries · Closed · Apr 15, 1972 · N92792 · Substantial damage
- [NTSB LAX72DUQ78](https://openairdocs.org/ntsb/LAX72DUQ78.md): Cessna 172 · Inyokern, CA · Accident · Minor injuries · Closed · Apr 14, 1972 · N1484Y · Substantial damage
- [NTSB FTW72DRJ23](https://openairdocs.org/ntsb/FTW72DRJ23.md): Cessna 150J · Longview, TX · Accident · Minor injuries · Closed · Apr 14, 1972 · N61285 · Substantial damage
- [NTSB CHI72AC083](https://openairdocs.org/ntsb/CHI72AC083.md): Short Bros SC-7-3 · Lacrosse, WI · Accident · 1 fatal · Closed · Apr 14, 1972 · N725R · Destroyed
- [NTSB SEA72AS045](https://openairdocs.org/ntsb/SEA72AS045.md): Cessna 182A · Walla Walla, WA · Accident · 3 fatal · Closed · Apr 11, 1972 · N4068D · Destroyed
- [NTSB MIA72FLA39](https://openairdocs.org/ntsb/MIA72FLA39.md): Cessna 140 · Milton, FL · Accident · Serious injuries · Closed · Apr 10, 1972 · N72699 · Substantial damage
- [NTSB OAK72DVG49](https://openairdocs.org/ntsb/OAK72DVG49.md): Piper PA-28 · Dunsmuir, CA · Accident · Minor injuries · Closed · Apr 9, 1972 · N9374J · Substantial damage
- [NTSB MIA72AM107](https://openairdocs.org/ntsb/MIA72AM107.md): Piper PA-32 · Fort Payne, AL · Accident · 7 fatal · Closed · Apr 9, 1972 · N3953W · Destroyed
- [NTSB CHI72FEM60](https://openairdocs.org/ntsb/CHI72FEM60.md): Piper PA-23 · Escanaba, MI · Accident · No injuries · Closed · Apr 9, 1972 · N1351P · Substantial damage
- [NTSB NYC72DFT09](https://openairdocs.org/ntsb/NYC72DFT09.md): Schleicher AS-K14 · Fayetteville, PA · Accident · No injuries · Closed · Apr 8, 1972 · N2316 · Substantial damage
- [NTSB FTW72FRA46](https://openairdocs.org/ntsb/FTW72FRA46.md): Cessna 177 · Pearland, TX · Accident · No injuries · Closed · Apr 8, 1972 · N30443 · Substantial damage
- [NTSB CHI72FEM57](https://openairdocs.org/ntsb/CHI72FEM57.md): Cessna 337 · Sault S.Mari, MI · Accident · Serious injuries · Closed · Apr 8, 1972 · CF-SLZ · Substantial damage
- [NTSB CHI72AC079](https://openairdocs.org/ntsb/CHI72AC079.md): Cessna 172 · Lowell, MI · Accident · 1 fatal · Closed · Apr 8, 1972 · N5936A · Destroyed
- [NTSB FTW72DRG76](https://openairdocs.org/ntsb/FTW72DRG76.md): Cessna 210T · Mexicali, Mexico · Accident · Serious injuries · Closed · Apr 6, 1972 · N882MM · Substantial damage
- [NTSB CHI72FEM58](https://openairdocs.org/ntsb/CHI72FEM58.md): Piper PA-24 · Battle Creek, MI · Accident · No injuries · Closed · Apr 6, 1972 · N8562P · Substantial damage
- [NTSB FTW72DPM26](https://openairdocs.org/ntsb/FTW72DPM26.md): Bell 47G · Wynona, OK · Accident · No injuries · Closed · Apr 5, 1972 · N993B · Substantial damage
- [NTSB CHI72FEC37](https://openairdocs.org/ntsb/CHI72FEC37.md): Navion A · Taylor, MI · Accident · No injuries · Closed · Apr 4, 1972 · N8565H · Substantial damage
- [NTSB LAX72FUQ74](https://openairdocs.org/ntsb/LAX72FUQ74.md): Cessna 150 · Goleta, CA · Accident · No injuries · Closed · Apr 1, 1972 · N6542G · Substantial damage
- [NTSB MIA72FKQ33](https://openairdocs.org/ntsb/MIA72FKQ33.md): Gillam Star SA300 · Picayune, MS · Accident · No injuries · Closed · Mar 31, 1972 · N2462 · Substantial damage
- [NTSB MIA72AM104](https://openairdocs.org/ntsb/MIA72AM104.md): Cessna 320E · Charleston, SC · Accident · 5 fatal · Closed · Mar 31, 1972 · N3421Q · Destroyed
- [NTSB CHI72FEC33](https://openairdocs.org/ntsb/CHI72FEC33.md): Beech D35 · Pontiac, MI · Accident · No injuries · Closed · Mar 30, 1972 · N2097D · Substantial damage
- [NTSB CHI72AC077](https://openairdocs.org/ntsb/CHI72AC077.md): Piper PA-30 · Vandalia, IL · Accident · 2 fatal · Closed · Mar 29, 1972 · N8543Y · Destroyed
- [NTSB MIA72AM101](https://openairdocs.org/ntsb/MIA72AM101.md): Swearingen SA26AT · Nashville, TN · Accident · 4 fatal · Closed · Mar 28, 1972 · N4111X · Destroyed
- [NTSB MIA72FLA35](https://openairdocs.org/ntsb/MIA72FLA35.md): Piper PA-22 · Blountstown, FL · Accident · Minor injuries · Closed · Mar 27, 1972 · N2836Z · Substantial damage
- [NTSB FTW72DPD33](https://openairdocs.org/ntsb/FTW72DPD33.md): Beech 23 · Evant, TX · Accident · Minor injuries · Closed · Mar 27, 1972 · N2374L · Substantial damage
- [NTSB OAK72FVW26](https://openairdocs.org/ntsb/OAK72FVW26.md): Mooney M20F · Boulder City, NV · Accident · Minor injuries · Closed · Mar 26, 1972 · N9486V · Substantial damage
- [NTSB OAK72FVG46](https://openairdocs.org/ntsb/OAK72FVG46.md): Navion A · Jackson, CA · Accident · Serious injuries · Closed · Mar 26, 1972 · N4551K · Substantial damage
- [NTSB OAK72DVG47](https://openairdocs.org/ntsb/OAK72DVG47.md): Piper PA-28 · Lower Lake, CA · Accident · No injuries · Closed · Mar 26, 1972 · N7667W · Substantial damage
- [NTSB NYC72DFJ32](https://openairdocs.org/ntsb/NYC72DFJ32.md): Piper PA-22 · East Amherst, NY · Accident · No injuries · Closed · Mar 26, 1972 · N7341D · Substantial damage
- [NTSB NYC72AN117](https://openairdocs.org/ntsb/NYC72AN117.md): Beech D95A · Portsmouth, VA · Accident · Serious injuries · Closed · Mar 25, 1972 · N8954M · Destroyed
- [NTSB MIA72DLG32](https://openairdocs.org/ntsb/MIA72DLG32.md): Cessna 140 · Laurens, SC · Accident · Minor injuries · Closed · Mar 25, 1972 · N81081 · Substantial damage
- [NTSB LAX72FUG62](https://openairdocs.org/ntsb/LAX72FUG62.md): Cessna 150 · Riverside, CA · Accident · Serious injuries · Closed · Mar 25, 1972 · N2962S · Substantial damage
- [NTSB DEN72DTC22](https://openairdocs.org/ntsb/DEN72DTC22.md): Piper PA-28R · Gillette, WY · Accident · Minor injuries · Closed · Mar 25, 1972 · N2120T · Substantial damage
- [NTSB CHI72FLQ32](https://openairdocs.org/ntsb/CHI72FLQ32.md): Mong Sport MS-2 · Elizabethtown, KY · Accident · Serious injuries · Closed · Mar 25, 1972 · N2376 · Substantial damage
- [NTSB LAX72FUJ88](https://openairdocs.org/ntsb/LAX72FUJ88.md): Bell 47G3B1 · Gila Bend, AZ · Accident · No injuries · Closed · Mar 24, 1972 · N1333X · Substantial damage
- [NTSB CHI72FEA36](https://openairdocs.org/ntsb/CHI72FEA36.md): Cessna 150 · Greencastle, IN · Accident · Serious injuries · Closed · Mar 24, 1972 · N4140U · Destroyed
- [NTSB OAK72DVG45](https://openairdocs.org/ntsb/OAK72DVG45.md): Cessna 150 · Paradise, CA · Accident · Serious injuries · Closed · Mar 23, 1972 · N4053J · Destroyed
- [NTSB OAK72DJY18](https://openairdocs.org/ntsb/OAK72DJY18.md): Pilatus PC6-H2 · Song Lai, Laos · Accident · No injuries · Closed · Mar 21, 1972 · N391R · Substantial damage
- [NTSB MKC72AK056](https://openairdocs.org/ntsb/MKC72AK056.md): Beech V35 · Worthington, MN · Accident · 1 fatal · Closed · Mar 21, 1972 · N9407S · Destroyed

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

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

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