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

## Cases, newest first

- [NTSB FTW70D0093](https://openairdocs.org/ntsb/FTW70D0093.md): Cessna 150J · Stratford, TX · Accident · No injuries · Closed · Jul 13, 1969 · N50886 · Substantial damage
- [NTSB ANC70D0015](https://openairdocs.org/ntsb/ANC70D0015.md): Cessna 180 · Kenai, AK · Accident · Minor injuries · Closed · Jul 13, 1969 · N5379D · Destroyed
- [NTSB CHI70F0102](https://openairdocs.org/ntsb/CHI70F0102.md): Chatters F-10 · Milan, MI · Accident · Minor injuries · Closed · Jul 12, 1969 · N4951 · Destroyed
- [NTSB CHI70F0093](https://openairdocs.org/ntsb/CHI70F0093.md): Cessna 150 · Houghton Lk, MI · Accident · Minor injuries · Closed · Jul 12, 1969 · N23154 · Destroyed
- [NTSB CHI70F0158](https://openairdocs.org/ntsb/CHI70F0158.md): Cessna 120 · Pecatonica, IL · Accident · Serious injuries · Closed · Jul 11, 1969 · N76722 · Substantial damage
- [NTSB MIA70A0001](https://openairdocs.org/ntsb/MIA70A0001.md): Cessna 310C · Athens, GA · Accident · 1 fatal · Closed · Jul 10, 1969 · N6719T · Destroyed
- [NTSB FTW70F0092](https://openairdocs.org/ntsb/FTW70F0092.md): Snow S2C · Coy, AR · Accident · 1 fatal · Closed · Jul 10, 1969 · N1852S · Destroyed
- [NTSB CHI70F0210](https://openairdocs.org/ntsb/CHI70F0210.md): Cessna 172I · Northbrook, IL · Accident · Serious injuries · Closed · Jul 10, 1969 · N35541 · Destroyed
- [NTSB NYC70F0054](https://openairdocs.org/ntsb/NYC70F0054.md): Piper PA-17 · Madison, CT · Accident · No injuries · Closed · Jul 9, 1969 · N4811H · Substantial damage
- [NTSB NYC70A0007](https://openairdocs.org/ntsb/NYC70A0007.md): Piper PA-22 · Bridgeport, NJ · Accident · 2 fatal · Closed · Jul 8, 1969 · N4847Z · Destroyed
- [NTSB NYC70D0093](https://openairdocs.org/ntsb/NYC70D0093.md): Schweizer SGS-1 · Dansville, NY · Accident · No injuries · Closed · Jul 6, 1969 · N3870A · Substantial damage
- [NTSB LAX70I0002](https://openairdocs.org/ntsb/LAX70I0002.md): Cessna 172 · San Fernando, CA · Incident · No injuries · Closed · Jul 6, 1969 · N4613L · Minor damage
- [NTSB OAK70D0070](https://openairdocs.org/ntsb/OAK70D0070.md): Cessna 150 · San Carlos, CA · Accident · No injuries · Closed · Jul 5, 1969 · N7277S · Substantial damage
- [NTSB NYC70F0059](https://openairdocs.org/ntsb/NYC70F0059.md): Cessna 172C · White Plains, NY · Accident · Minor injuries · Closed · Jul 5, 1969 · N1859Y · Substantial damage
- [NTSB CHI70D0129](https://openairdocs.org/ntsb/CHI70D0129.md): Cessna 180 · Balsam Lake, WI · Accident · Minor injuries · Closed · Jul 5, 1969 · N3606C · Substantial damage
- [NTSB UNK69X0130](https://openairdocs.org/ntsb/UNK69X0130.md): Mooney M20C · Mulege, Mexico · Accident · Serious injuries · Closed · Jul 4, 1969 · N9112V · Destroyed
- [NTSB CHI70A0003](https://openairdocs.org/ntsb/CHI70A0003.md): Piper PA-32 · Madison, IN · Accident · No injuries · Closed · Jul 4, 1969 · N7704J · Substantial damage
- [NTSB FTW70F0077](https://openairdocs.org/ntsb/FTW70F0077.md): Piper PA-12 · Cottonport, LA · Accident · No injuries · Closed · Jul 3, 1969 · N7903H · Destroyed
- [NTSB NYC70D0025](https://openairdocs.org/ntsb/NYC70D0025.md): Piper PA-22 · Warrington, PA · Accident · No injuries · Closed · Jul 2, 1969 · N4738Z · Substantial damage
- [NTSB SEA70D0023](https://openairdocs.org/ntsb/SEA70D0023.md): Thorp T-18 · Puyallup, WA · Accident · Minor injuries · Closed · Jul 1, 1969 · N3715 · Substantial damage
- [NTSB LAX70F0032](https://openairdocs.org/ntsb/LAX70F0032.md): Piper PA-32 · Carlsbad, CA · Accident · Minor injuries · Closed · Jul 1, 1969 · N3335W · Substantial damage
- [NTSB FTW70F0079](https://openairdocs.org/ntsb/FTW70F0079.md): Beech C-45H · Plainview, TX · Accident · No injuries · Closed · Jul 1, 1969 · N850C · Substantial damage
- [NTSB CAN70AF538](https://openairdocs.org/ntsb/CAN70AF538.md): Bell 47G · Badger, Canada · Accident · Minor injuries · Closed · Jul 1, 1969 · N2814B · Substantial damage
- [NTSB OAK70D0036](https://openairdocs.org/ntsb/OAK70D0036.md): Piper PA-28 · Palo Alto, CA · Accident · No injuries · Closed · Jun 30, 1969 · N6792J · Substantial damage
- [NTSB NYC69A0114](https://openairdocs.org/ntsb/NYC69A0114.md): Piper PA-30 · Rancocas, NJ · Accident · 2 fatal · Closed · Jun 30, 1969 · N8609Y · Destroyed
- [NTSB LAX70D0045](https://openairdocs.org/ntsb/LAX70D0045.md): Aeronca 7AC · Yuma, AZ · Accident · Minor injuries · Closed · Jun 30, 1969 · N84168 · Destroyed
- [NTSB FTW70F0078](https://openairdocs.org/ntsb/FTW70F0078.md): Beech A23 · Beaumont, TX · Accident · No injuries · Closed · Jun 30, 1969 · N5590S · Substantial damage
- [NTSB NYC70F0065](https://openairdocs.org/ntsb/NYC70F0065.md): Fairchild 24R · Hammondsport, NY · Accident · Serious injuries · Closed · Jun 29, 1969 · N81223 · Destroyed
- [NTSB MIA69A0095](https://openairdocs.org/ntsb/MIA69A0095.md): Piper PA-18A · Madison, MS · Accident · 1 fatal · Closed · Jun 29, 1969 · N2876Z · Destroyed
- [NTSB DIA69A0070](https://openairdocs.org/ntsb/DIA69A0070.md): Cessna 172 · Charleston, WV · Accident · 4 fatal · Closed · Jun 29, 1969 · N5936R · Destroyed
- [NTSB FTW70F0104](https://openairdocs.org/ntsb/FTW70F0104.md): Cessna 172F · Brinkley, AR · Accident · 1 fatal · Closed · Jun 28, 1969 · N5534R · Destroyed
- [NTSB FTW70D0088](https://openairdocs.org/ntsb/FTW70D0088.md): Piper PA-28 · Kingfisher, OK · Accident · Minor injuries · Closed · Jun 28, 1969 · N6398W · Substantial damage
- [NTSB CHI70D0123](https://openairdocs.org/ntsb/CHI70D0123.md): Callair A-9 · Hobart, IN · Accident · No injuries · Closed · Jun 28, 1969 · N3603G · Substantial damage
- [NTSB CHI70D0060](https://openairdocs.org/ntsb/CHI70D0060.md): Bensen B-8M · W Lafayette, OH · Accident · Minor injuries · Closed · Jun 28, 1969 · N8059R · Substantial damage
- [NTSB MKC70F0029](https://openairdocs.org/ntsb/MKC70F0029.md): Cessna 310P · Wichita, KS · Accident · Minor injuries · Closed · Jun 27, 1969 · N5879M · Destroyed
- [NTSB MIA70D0043](https://openairdocs.org/ntsb/MIA70D0043.md): Aeronca 65-CA · Enterprise, AL · Accident · No injuries · Closed · Jun 27, 1969 · N31899 · Substantial damage
- [NTSB MIA69A0093](https://openairdocs.org/ntsb/MIA69A0093.md): Piper PA-18 · Flora, MS · Accident · No injuries · Closed · Jun 27, 1969 · N4032Z · 2 aircraft · Destroyed
- [NTSB LAX69A0077](https://openairdocs.org/ntsb/LAX69A0077.md): Cessna 182E · Phoenix, AZ · Accident · 3 fatal · Closed · Jun 27, 1969 · N3150Y · Destroyed
- [NTSB MIA70D0106](https://openairdocs.org/ntsb/MIA70D0106.md): Cessna 140 · Walterboro, SC · Accident · Minor injuries · Closed · Jun 26, 1969 · N76115 · Substantial damage
- [NTSB CHI70D0138](https://openairdocs.org/ntsb/CHI70D0138.md): Piper PA-28 · Brunswick, OH · Accident · No injuries · Closed · Jun 26, 1969 · N95116 · Substantial damage
- [NTSB OAK69A0073](https://openairdocs.org/ntsb/OAK69A0073.md): Cessna 170B · Lathrop Wells, NV · Accident · 1 fatal · Closed · Jun 25, 1969 · N2513C · Destroyed
- [NTSB DIA70F0010](https://openairdocs.org/ntsb/DIA70F0010.md): Cessna 170 · Harrells, NC · Accident · No injuries · Closed · Jun 24, 1969 · N4198V · Substantial damage
- [NTSB UNK69X0126](https://openairdocs.org/ntsb/UNK69X0126.md): Sikorsky S-62A · Dakar, Nicaragua · Accident · No injuries · Closed · Jun 23, 1969 · N665Y · Substantial damage
- [NTSB SEA70F0008](https://openairdocs.org/ntsb/SEA70F0008.md): Piper PA-25 · Homedale, ID · Accident · Serious injuries · Closed · Jun 22, 1969 · N6855Z · Destroyed
- [NTSB MIA70F0015](https://openairdocs.org/ntsb/MIA70F0015.md): Cessna 172 · Russellville, AL · Accident · Minor injuries · Closed · Jun 22, 1969 · N3256U · Substantial damage
- [NTSB FTW70F0037](https://openairdocs.org/ntsb/FTW70F0037.md): Piper PA-28 · Baton Rouge, LA · Accident · No injuries · Closed · Jun 22, 1969 · N8222N · Substantial damage
- [NTSB FTW70D0091](https://openairdocs.org/ntsb/FTW70D0091.md): Piper PA-28 · Marksville, LA · Accident · No injuries · Closed · Jun 22, 1969 · N6940W · Substantial damage
- [NTSB DIA70F0027](https://openairdocs.org/ntsb/DIA70F0027.md): Piper J3C-65 · Cambridge, MD · Accident · Serious injuries · Closed · Jun 22, 1969 · N1533N · Destroyed
- [NTSB CHI70F0237](https://openairdocs.org/ntsb/CHI70F0237.md): Cessna 150H · Lorain, OH · Accident · Minor injuries · Closed · Jun 22, 1969 · N22878 · Substantial damage
- [NTSB FTW70D0036](https://openairdocs.org/ntsb/FTW70D0036.md): Piper PA-22 · Evant, TX · Accident · No injuries · Closed · Jun 21, 1969 · N2721P · Substantial damage

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

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

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