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

## Cases, newest first

- [NTSB IAD70I0024](https://openairdocs.org/ntsb/IAD70I0024.md): Howard Aero 500 · Wheeling, WV · Incident · No injuries · Closed · Oct 3, 1969 · N8020 · Minor damage
- [NTSB MIA70F0195](https://openairdocs.org/ntsb/MIA70F0195.md): Boeing E-75 · Milan, TN · Accident · Serious injuries · Closed · Oct 2, 1969 · N5058V · Destroyed
- [NTSB FTW70F0265](https://openairdocs.org/ntsb/FTW70F0265.md): Cessna 177 · Georgetown, LA · Accident · Minor injuries · Closed · Oct 2, 1969 · N2928X · Destroyed
- [NTSB FTW70F0224](https://openairdocs.org/ntsb/FTW70F0224.md): Cessna 205 · Lake Village, AR · Accident · Minor injuries · Closed · Oct 2, 1969 · N8296Z · Substantial damage
- [NTSB ANC70D0050](https://openairdocs.org/ntsb/ANC70D0050.md): Cessna 170B · Palmer, AK · Accident · Minor injuries · Closed · Sep 30, 1969 · N3433D · Substantial damage
- [NTSB NYC70D0196](https://openairdocs.org/ntsb/NYC70D0196.md): Piper PA-28 · Beverly, MA · Accident · No injuries · Closed · Sep 29, 1969 · N9901W · Substantial damage
- [NTSB DEN70F0108](https://openairdocs.org/ntsb/DEN70F0108.md): Hughes 269B · Cheyenne, WY · Accident · Minor injuries · Closed · Sep 29, 1969 · N9484F · Substantial damage
- [NTSB UNK69X0149](https://openairdocs.org/ntsb/UNK69X0149.md): Boeing C-97 · Nigeria, Nicaragua · Accident · 5 fatal · Closed · Sep 26, 1969 · N52676 · Destroyed
- [NTSB MIA70F0174](https://openairdocs.org/ntsb/MIA70F0174.md): Mooney M20C · Brandon, MS · Accident · No injuries · Closed · Sep 26, 1969 · N7847V · Substantial damage
- [NTSB FTW70F0223](https://openairdocs.org/ntsb/FTW70F0223.md): Piper PA-28 · Magnolia, AR · Accident · Minor injuries · Closed · Sep 25, 1969 · N6408R · Substantial damage
- [NTSB UNK69X0148](https://openairdocs.org/ntsb/UNK69X0148.md): Cessna 150 · Andros Is, Burkina Faso · Accident · No injuries · Closed · Sep 24, 1969 · N3217X · Substantial damage
- [NTSB CHI70F0317](https://openairdocs.org/ntsb/CHI70F0317.md): Beech A23-19 · Minooka, IL · Accident · No injuries · Closed · Sep 24, 1969 · N6911Q · Substantial damage
- [NTSB MKC70A0012](https://openairdocs.org/ntsb/MKC70A0012.md): Cessna 182M · Kansas City, MO · Accident · 3 fatal · Closed · Sep 23, 1969 · N91785 · Destroyed
- [NTSB MIA70F0215](https://openairdocs.org/ntsb/MIA70F0215.md): Hughes 269A · Rembert, SC · Accident · No injuries · Closed · Sep 23, 1969 · N8848F · Destroyed
- [NTSB IAD70A0021](https://openairdocs.org/ntsb/IAD70A0021.md): Piper PA-28 · Edgewater, MD · Accident · 2 fatal · Closed · Sep 23, 1969 · N4204J · 2 aircraft · Minor damage
- [NTSB CHI70F0342](https://openairdocs.org/ntsb/CHI70F0342.md): Piper J3C-65 · Niagara, WI · Accident · Serious injuries · Closed · Sep 23, 1969 · N42046 · Destroyed
- [NTSB SEA70A0013](https://openairdocs.org/ntsb/SEA70A0013.md): Piper PA-30 · Tacoma, WA · Accident · 1 fatal · Closed · Sep 22, 1969 · N8504Y · Destroyed
- [NTSB FTW70F0369](https://openairdocs.org/ntsb/FTW70F0369.md): Piper PA-28 · Van Buren, AR · Accident · No injuries · Closed · Sep 22, 1969 · N4298J · Substantial damage
- [NTSB FTW70A0020](https://openairdocs.org/ntsb/FTW70A0020.md): Cessna 172G · Pearland, TX · Accident · No injuries · Closed · Sep 21, 1969 · N5868B · 2 aircraft · Substantial damage
- [NTSB SEA70D0108](https://openairdocs.org/ntsb/SEA70D0108.md): Cessna 170 · Alderwod Mnr, WA · Accident · No injuries · Closed · Sep 19, 1969 · N2534V · Substantial damage
- [NTSB OAK70D0120](https://openairdocs.org/ntsb/OAK70D0120.md): Erco 415G · Lone Pine, CA · Accident · No injuries · Closed · Sep 19, 1969 · N94408 · Substantial damage
- [NTSB LAX70A0017](https://openairdocs.org/ntsb/LAX70A0017.md): Beech K35 · Van Nuys, CA · Accident · Minor injuries · Closed · Sep 19, 1969 · N6093E · Destroyed
- [NTSB FTW70A0019](https://openairdocs.org/ntsb/FTW70A0019.md): Cessna 172G · Morgan City, LA · Accident · 1 fatal · Closed · Sep 19, 1969 · N4620L · Destroyed
- [NTSB OAK70F0126](https://openairdocs.org/ntsb/OAK70F0126.md): Cessna 210 · Reno, NV · Accident · Minor injuries · Closed · Sep 18, 1969 · N6866R · Substantial damage
- [NTSB OAK70D0136](https://openairdocs.org/ntsb/OAK70D0136.md): Cessna 172 · Lodi, CA · Accident · Minor injuries · Closed · Sep 18, 1969 · N1486Y · Substantial damage
- [NTSB FTW70F0220](https://openairdocs.org/ntsb/FTW70F0220.md): Piper PA-25 · Hollis, OK · Accident · 1 fatal · Closed · Sep 17, 1969 · N6103Z · Destroyed
- [NTSB CHI70F0274](https://openairdocs.org/ntsb/CHI70F0274.md): Piper PA-24 · Middleton, WI · Accident · No injuries · Closed · Sep 17, 1969 · N8149P · Substantial damage
- [NTSB LAX70F0136](https://openairdocs.org/ntsb/LAX70F0136.md): Cessna 210D · Chino, CA · Accident · No injuries · Closed · Sep 16, 1969 · N3857Y · Substantial damage
- [NTSB FTW70F0218](https://openairdocs.org/ntsb/FTW70F0218.md): Cessna 120 · Greenville, TX · Accident · Minor injuries · Closed · Sep 15, 1969 · N76642 · Destroyed
- [NTSB DEN70A0021](https://openairdocs.org/ntsb/DEN70A0021.md): Cessna 150F · Aurora, CO · Accident · 2 fatal · Closed · Sep 15, 1969 · N8803S · Substantial damage
- [NTSB NYC70D0162](https://openairdocs.org/ntsb/NYC70D0162.md): Trager T-3 · Millville, NJ · Accident · Minor injuries · Closed · Sep 14, 1969 · N9098 · Substantial damage
- [NTSB FTW70D0225](https://openairdocs.org/ntsb/FTW70D0225.md): Cessna 310L · Newkirk, OK · Accident · No injuries · Closed · Sep 14, 1969 · N3346X · Substantial damage
- [NTSB CHI70F0248](https://openairdocs.org/ntsb/CHI70F0248.md): Cessna 140 · Columbus, OH · Accident · No injuries · Closed · Sep 14, 1969 · N4255N · Substantial damage
- [NTSB ANC70D0065](https://openairdocs.org/ntsb/ANC70D0065.md): Piper PA-28 · Gulkana, AK · Accident · No injuries · Closed · Sep 14, 1969 · N6374J · Substantial damage
- [NTSB UNK69X0147](https://openairdocs.org/ntsb/UNK69X0147.md): Grumman G-44 · Halfx Arpt, Canada · Accident · Minor injuries · Closed · Sep 13, 1969 · N128A · Substantial damage
- [NTSB NYC70F0163](https://openairdocs.org/ntsb/NYC70F0163.md): Stinson V-77 · Waynesburg, PA · Accident · Minor injuries · Closed · Sep 12, 1969 · N9393H · Substantial damage
- [NTSB NYC70F0161](https://openairdocs.org/ntsb/NYC70F0161.md): Cessna 337C · Toms River, NJ · Accident · 1 fatal · Closed · Sep 12, 1969 · N2651S · Destroyed
- [NTSB MKC70D0189](https://openairdocs.org/ntsb/MKC70D0189.md): Cessna 150G · Cannon Falls, MN · Accident · No injuries · Closed · Sep 10, 1969 · N4610X · Substantial damage
- [NTSB OAK70D0137](https://openairdocs.org/ntsb/OAK70D0137.md): Cessna 172 · Grover City, CA · Accident · No injuries · Closed · Sep 9, 1969 · N78126 · Substantial damage
- [NTSB FTW70F0217](https://openairdocs.org/ntsb/FTW70F0217.md): Piper PA-25 · Elaine, AR · Accident · Serious injuries · Closed · Sep 9, 1969 · N7441Z · Destroyed
- [NTSB FTW70F0234](https://openairdocs.org/ntsb/FTW70F0234.md): Beech H35 · College Sta, TX · Accident · Serious injuries · Closed · Sep 8, 1969 · N7980D · Substantial damage
- [NTSB IAD70D0063](https://openairdocs.org/ntsb/IAD70D0063.md): Cessna 150G · Advance, NC · Accident · No injuries · Closed · Sep 7, 1969 · N2678J · Substantial damage
- [NTSB FTW70A0013](https://openairdocs.org/ntsb/FTW70A0013.md): Cessna 320 · Burleson, TX · Accident · 2 fatal · Closed · Sep 7, 1969 · N5773X · Destroyed
- [NTSB NYC70F0142](https://openairdocs.org/ntsb/NYC70F0142.md): Cessna 180 · Walkill, NY · Accident · Minor injuries · Closed · Sep 6, 1969 · N2963A · Destroyed
- [NTSB CHI70D0291](https://openairdocs.org/ntsb/CHI70D0291.md): Schweizer SGS233 · Highland, IL · Accident · No injuries · Closed · Sep 6, 1969 · N7759S · Substantial damage
- [NTSB IAD70D0069](https://openairdocs.org/ntsb/IAD70D0069.md): Cessna 150 · Smyrna, DE · Accident · Serious injuries · Closed · Sep 5, 1969 · N8238F · Substantial damage
- [NTSB CHI70D0216](https://openairdocs.org/ntsb/CHI70D0216.md): Piper PA-28 · Georgetown, KY · Accident · No injuries · Closed · Sep 5, 1969 · N8477W · Substantial damage
- [NTSB NYC70F0150](https://openairdocs.org/ntsb/NYC70F0150.md): Cessna 310B · Stony Point, NY · Accident · Serious injuries · Closed · Sep 4, 1969 · N6609B · Destroyed
- [NTSB LAX70A0016](https://openairdocs.org/ntsb/LAX70A0016.md): Piper PA-24 · Blythe, CA · Accident · 6 fatal · Closed · Sep 3, 1969 · N9304P · Destroyed
- [NTSB NYC70A0030](https://openairdocs.org/ntsb/NYC70A0030.md): Stinson 108-1 · Colton, NY · Accident · 2 fatal · Closed · Sep 1, 1969 · N97789 · Destroyed

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

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

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