# 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 292 of 420 · 20,992 cases

## Cases, newest first

- [NTSB IAD75DIG22](https://openairdocs.org/ntsb/IAD75DIG22.md): Piper PA-22 · Swanton, MD · Accident · Minor injuries · Closed · Jun 22, 1975 · N3460Z · Substantial damage
- [NTSB NYC75DNC38](https://openairdocs.org/ntsb/NYC75DNC38.md): Cessna A150 · Shelbourne, VT · Accident · No injuries · Closed · Jun 21, 1975 · N6154F · Destroyed
- [NTSB CHI75FEE70](https://openairdocs.org/ntsb/CHI75FEE70.md): Beech B95 · Crystal Lake, IL · Accident · No injuries · Closed · Jun 21, 1975 · N171W · Substantial damage
- [NTSB ANC75FAA35](https://openairdocs.org/ntsb/ANC75FAA35.md): Cessna 172L · Circle City, AK · Accident · Minor injuries · Closed · Jun 21, 1975 · N19670 · Substantial damage
- [NTSB NYC75FHA46](https://openairdocs.org/ntsb/NYC75FHA46.md): Beech 95-C55 · Basking Ridge, NJ · Accident · Serious injuries · Closed · Jun 20, 1975 · N245UC · Destroyed
- [NTSB NYC75FFA43](https://openairdocs.org/ntsb/NYC75FFA43.md): Cessna 206 · Manorkill, NY · Accident · No injuries · Closed · Jun 20, 1975 · N29054 · Substantial damage
- [NTSB MKC75FCG51](https://openairdocs.org/ntsb/MKC75FCG51.md): Cessna 172 · Leawood, KS · Accident · Minor injuries · Closed · Jun 20, 1975 · N5586R · Substantial damage
- [NTSB FTW75AF074](https://openairdocs.org/ntsb/FTW75AF074.md): Cessna 182 · Fayetteville, AR · Accident · No injuries · Closed · Jun 20, 1975 · N6463A · Substantial damage
- [NTSB SEA75DYE48](https://openairdocs.org/ntsb/SEA75DYE48.md): Cessna 150 · Blaine, WA · Accident · Minor injuries · Closed · Jun 18, 1975 · N8364J · Substantial damage
- [NTSB OAK75FVM35](https://openairdocs.org/ntsb/OAK75FVM35.md): Piper PA-28 · San Jose, CA · Accident · Minor injuries · Closed · Jun 17, 1975 · N33020 · Substantial damage
- [NTSB NYC75AN118](https://openairdocs.org/ntsb/NYC75AN118.md): Piper PA-28 · Export, PA · Accident · Serious injuries · Closed · Jun 17, 1975 · N922RD · Substantial damage
- [NTSB CHI75FEC58](https://openairdocs.org/ntsb/CHI75FEC58.md): Cessna 150L · Ypsilanti, MI · Accident · No injuries · Closed · Jun 16, 1975 · N1217Q · Substantial damage
- [NTSB NYC75FFJ24](https://openairdocs.org/ntsb/NYC75FFJ24.md): Piper J-3 · Gasport, NY · Accident · Serious injuries · Closed · Jun 15, 1975 · N6880H · Destroyed
- [NTSB DEN75DTC27](https://openairdocs.org/ntsb/DEN75DTC27.md): Cessna 177 · Laramie, WY · Accident · No injuries · Closed · Jun 15, 1975 · N3159T · Substantial damage
- [NTSB OAK75FVG76](https://openairdocs.org/ntsb/OAK75FVG76.md): Cessna 150 · Antioch, CA · Accident · No injuries · Closed · Jun 14, 1975 · N61175 · Substantial damage
- [NTSB CHI75DEK34](https://openairdocs.org/ntsb/CHI75DEK34.md): Piper PA-20 · Chesterville, OH · Accident · No injuries · Closed · Jun 14, 1975 · N3SJ · Substantial damage
- [NTSB NYC75AN120](https://openairdocs.org/ntsb/NYC75AN120.md): Ted Smith 600 · Philadelphia, PA · Accident · No injuries · Closed · Jun 13, 1975 · N7408S · Substantial damage
- [NTSB CHI75FEP68](https://openairdocs.org/ntsb/CHI75FEP68.md): Grum Amer AA1 · Delavan, WI · Accident · Serious injuries · Closed · Jun 12, 1975 · N6543L · Substantial damage
- [NTSB FTW75FQG58](https://openairdocs.org/ntsb/FTW75FQG58.md): Cessna 182 · Crane, TX · Accident · No injuries · Closed · Jun 11, 1975 · N4771D · Substantial damage
- [NTSB MIA75DLG36](https://openairdocs.org/ntsb/MIA75DLG36.md): Schweizer 2-33 · Chester, SC · Accident · No injuries · Closed · Jun 8, 1975 · N5767S · Substantial damage
- [NTSB MIA75FKT89](https://openairdocs.org/ntsb/MIA75FKT89.md): Cessna 150 · Lantana, FL · Accident · Serious injuries · Closed · Jun 7, 1975 · N10861 · Destroyed
- [NTSB FTW75DPJ24](https://openairdocs.org/ntsb/FTW75DPJ24.md): Piper PA-18 · Hough, OK · Accident · Serious injuries · Closed · Jun 7, 1975 · N7301L · Destroyed
- [NTSB /AK75FVA67](https://openairdocs.org/ntsb/%2FAK75FVA67.md): Cessna 172H · Merced, CA · Accident · No injuries · Closed · Jun 7, 1975 · N8103L · Substantial damage
- [NTSB OAK75FVW22](https://openairdocs.org/ntsb/OAK75FVW22.md): Cessna 320F · Las Vegas, NV · Accident · No injuries · Closed · Jun 5, 1975 · N6177Q · Substantial damage
- [NTSB NYC75FHD51](https://openairdocs.org/ntsb/NYC75FHD51.md): Aeronca 7BCM · Pennington, NJ · Accident · No injuries · Closed · Jun 3, 1975 · N9324H · Substantial damage
- [NTSB IAD75DIA23](https://openairdocs.org/ntsb/IAD75DIA23.md): Cessna 150J · Clinton, MD · Accident · Minor injuries · Closed · Jun 3, 1975 · N51099 · Substantial damage
- [NTSB FTW75FRG85](https://openairdocs.org/ntsb/FTW75FRG85.md): Beech S35 · Sinton, TX · Accident · Minor injuries · Closed · Jun 3, 1975 · N375T · Substantial damage
- [NTSB FTW75AF070](https://openairdocs.org/ntsb/FTW75AF070.md): Piper PA-28 · Bryan, TX · Accident · 1 fatal · Closed · Jun 3, 1975 · N7401J · Destroyed
- [NTSB CHI75DEC52](https://openairdocs.org/ntsb/CHI75DEC52.md): Piper PA-22 · Linden, MI · Accident · No injuries · Closed · Jun 2, 1975 · N5587Z · Substantial damage
- [NTSB IAD7KFHD49](https://openairdocs.org/ntsb/IAD7KFHD49.md): Mooney M20 · Garrison Lake, DE · Accident · Serious injuries · Closed · Jun 1, 1975 · N5254B · Substantial damage
- [NTSB FTW75FPG75](https://openairdocs.org/ntsb/FTW75FPG75.md): Piper PA-25 · Tamo, AR · Accident · No injuries · Closed · Jun 1, 1975 · N6848Z · Destroyed
- [NTSB CHI75FEI56](https://openairdocs.org/ntsb/CHI75FEI56.md): Beech J35 · New Phila, OH · Accident · Minor injuries · Closed · Jun 1, 1975 · N8256D · Destroyed
- [NTSB SEA7KAS043](https://openairdocs.org/ntsb/SEA7KAS043.md): Pine Air Superv · Omak, WA · Accident · 1 fatal · Closed · May 30, 1975 · N772MD · Destroyed
- [NTSB SEA75DTI31](https://openairdocs.org/ntsb/SEA75DTI31.md): Piper PA-34 · Missoula, MT · Accident · No injuries · Closed · May 30, 1975 · N55258 · Substantial damage
- [NTSB OAK75DVD50](https://openairdocs.org/ntsb/OAK75DVD50.md): Cessna 172 · Concord, CA · Accident · Minor injuries · Closed · May 30, 1975 · N84793 · Substantial damage
- [NTSB CHI75FEV32](https://openairdocs.org/ntsb/CHI75FEV32.md): Beech A23 · Shelbyville, IL · Accident · Serious injuries · Closed · May 30, 1975 · N3511R · Destroyed
- [NTSB CHI75FEC51](https://openairdocs.org/ntsb/CHI75FEC51.md): Cessna 414 · Lapeer, MI · Accident · No injuries · Closed · May 30, 1975 · N414GW · Substantial damage
- [NTSB MKC75AK057](https://openairdocs.org/ntsb/MKC75AK057.md): Cessna 414 · Omaha, NE · Accident · Minor injuries · Closed · May 29, 1975 · N82470 · Substantial damage
- [NTSB SEA75FYC39](https://openairdocs.org/ntsb/SEA75FYC39.md): Piper J3L-65 · Cornelius, OR · Accident · No injuries · Closed · May 28, 1975 · N26841 · Substantial damage
- [NTSB OAK75FVM32](https://openairdocs.org/ntsb/OAK75FVM32.md): Piper PA-28 · Santa Cruz, CA · Accident · No injuries · Closed · May 28, 1975 · N2813T · Substantial damage
- [NTSB FTW75DPD42](https://openairdocs.org/ntsb/FTW75DPD42.md): Piper PA-28 · Grand Prairie, TX · Accident · No injuries · Closed · May 26, 1975 · N1833J · Substantial damage
- [NTSB CHI75FEI54](https://openairdocs.org/ntsb/CHI75FEI54.md): Kanran KR-1 · Wadsworth, OH · Accident · Minor injuries · Closed · May 26, 1975 · N90837 · Destroyed
- [NTSB MIA75FLD76](https://openairdocs.org/ntsb/MIA75FLD76.md): Grum Amer AA1-B · Tampa, FL · Accident · Minor injuries · Closed · May 25, 1975 · N6547L · Substantial damage
- [NTSB LAX75DUJ83](https://openairdocs.org/ntsb/LAX75DUJ83.md): Mooney M20E · Coolidge, AZ · Accident · Serious injuries · Closed · May 25, 1975 · N3239F · Destroyed
- [NTSB CHI75FEK28](https://openairdocs.org/ntsb/CHI75FEK28.md): Piper PA-28 · Mt Gilead, OH · Accident · Serious injuries · Closed · May 25, 1975 · N56817 · Substantial damage
- [NTSB CHI75FEC49](https://openairdocs.org/ntsb/CHI75FEC49.md): Cessna 140 · Tecumseh, MI · Accident · Serious injuries · Closed · May 25, 1975 · N2459V · Destroyed
- [NTSB MKC75FCG47](https://openairdocs.org/ntsb/MKC75FCG47.md): Cessna 150 · Kansas City, KS · Accident · Minor injuries · Closed · May 24, 1975 · N18600 · Destroyed
- [NTSB FTW75AF067](https://openairdocs.org/ntsb/FTW75AF067.md): Cessna 177RG · Tomball, TX · Accident · 4 fatal · Closed · May 24, 1975 · N1951Q · 2 aircraft · Destroyed
- [NTSB MIA75FLD77](https://openairdocs.org/ntsb/MIA75FLD77.md): Cessna 177 · Lakeland, FL · Accident · No injuries · Closed · May 23, 1975 · N2860X · Substantial damage
- [NTSB CHI75DEM43](https://openairdocs.org/ntsb/CHI75DEM43.md): Luscombe 8A · Oshtemo, MI · Accident · No injuries · Closed · May 23, 1975 · N71101 · Substantial damage

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

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

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