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

## Cases, newest first

- [NTSB DCA69A0002](https://openairdocs.org/ntsb/DCA69A0002.md): Fairchild FH-227 · Charleston, WV · Accident · 35 fatal · Closed · Aug 10, 1968 · N712U · Destroyed
- [NTSB CHI69D0160](https://openairdocs.org/ntsb/CHI69D0160.md): Piper PA-24 · Marlette, MI · Accident · No injuries · Closed · Aug 10, 1968 · N5938P · Substantial damage
- [NTSB MKC69D0220](https://openairdocs.org/ntsb/MKC69D0220.md): Mooney M20C · Gainesville, MO · Accident · Minor injuries · Closed · Aug 9, 1968 · N5739Q · Substantial damage
- [NTSB MKC69A0010](https://openairdocs.org/ntsb/MKC69A0010.md): Cessna 150H · Republic, MO · Accident · 2 fatal · Closed · Aug 9, 1968 · N7115S · Destroyed
- [NTSB MIA69F0184](https://openairdocs.org/ntsb/MIA69F0184.md): Cessna 320 · Pine Mountain, GA · Accident · Serious injuries · Closed · Aug 9, 1968 · N6182Q · Destroyed
- [NTSB LAX69F0068](https://openairdocs.org/ntsb/LAX69F0068.md): Piper PA-28 · Upland, CA · Accident · No injuries · Closed · Aug 9, 1968 · N7264J · Substantial damage
- [NTSB DEN69D0088](https://openairdocs.org/ntsb/DEN69D0088.md): Stinson 108-2 · Aurora, CO · Accident · Minor injuries · Closed · Aug 9, 1968 · N8124K · Substantial damage
- [NTSB CHI69D0294](https://openairdocs.org/ntsb/CHI69D0294.md): Piper PA-22 · Platteville, WI · Accident · Minor injuries · Closed · Aug 9, 1968 · N4990Z · Substantial damage
- [NTSB NYC69D0146](https://openairdocs.org/ntsb/NYC69D0146.md): Schweizer SGS126 · Crawford, NY · Accident · No injuries · Closed · Aug 8, 1968 · N3800A · Substantial damage
- [NTSB ANC69F0007](https://openairdocs.org/ntsb/ANC69F0007.md): Piper PA-20 · Cordova, AK · Accident · No injuries · Closed · Aug 8, 1968 · N7473K · Substantial damage
- [NTSB NYC69A0017](https://openairdocs.org/ntsb/NYC69A0017.md): Boeing 727 · Boston, MA · Accident · Minor injuries · Closed · Aug 7, 1968 · N7419U · Substantial damage
- [NTSB FTW69D0139](https://openairdocs.org/ntsb/FTW69D0139.md): Piper PA-22 · Lamont, OK · Accident · No injuries · Closed · Aug 6, 1968 · N1703P · Substantial damage
- [NTSB SEA69D0078](https://openairdocs.org/ntsb/SEA69D0078.md): Story Mark 7 · Salem, OR · Accident · Minor injuries · Closed · Aug 5, 1968 · N1269 · Substantial damage
- [NTSB MIA69F0144](https://openairdocs.org/ntsb/MIA69F0144.md): Cessna 182G · Callahan, FL · Accident · No injuries · Closed · Aug 5, 1968 · N3725U · Substantial damage
- [NTSB NYC69F0067](https://openairdocs.org/ntsb/NYC69F0067.md): Piper PA-28 · Honesdale, PA · Accident · Minor injuries · Closed · Aug 4, 1968 · N5235L · Destroyed
- [NTSB LAX69D0109](https://openairdocs.org/ntsb/LAX69D0109.md): Schweizer SGS233 · Pearblossom, CA · Accident · No injuries · Closed · Aug 4, 1968 · N5706S · Substantial damage
- [NTSB FTW69D0151](https://openairdocs.org/ntsb/FTW69D0151.md): Cessna 182A · Lexington, OK · Accident · No injuries · Closed · Aug 4, 1968 · N6123B · Substantial damage
- [NTSB DEN69D0071](https://openairdocs.org/ntsb/DEN69D0071.md): Bell 47G3B1 · Dubois, WY · Accident · No injuries · Closed · Aug 4, 1968 · N8471E · Substantial damage
- [NTSB CHI69D0259](https://openairdocs.org/ntsb/CHI69D0259.md): N American SNJ-5 · Sandwich, IL · Accident · Minor injuries · Closed · Aug 4, 1968 · N7806B · Substantial damage
- [NTSB ANC69D0056](https://openairdocs.org/ntsb/ANC69D0056.md): Piper PA-11 · Palmer, AK · Accident · No injuries · Closed · Aug 4, 1968 · N4807M · Substantial damage
- [NTSB MKC69A0007](https://openairdocs.org/ntsb/MKC69A0007.md): Aeronca 7AC · Lexington, NE · Accident · Serious injuries · Closed · Aug 3, 1968 · N2966E · 2 aircraft · Destroyed
- [NTSB FTW69D0138](https://openairdocs.org/ntsb/FTW69D0138.md): Piper PA-28 · Dixie, LA · Accident · No injuries · Closed · Aug 3, 1968 · N1857J · Substantial damage
- [NTSB CHI69D0180](https://openairdocs.org/ntsb/CHI69D0180.md): Mooney M20C · Mears, MI · Accident · Minor injuries · Closed · Aug 3, 1968 · N3441X · Substantial damage
- [NTSB LAX69D0123](https://openairdocs.org/ntsb/LAX69D0123.md): Boeing A75N1 · Parker, AZ · Accident · No injuries · Closed · Aug 2, 1968 · N59250 · Substantial damage
- [NTSB FTW69D0195](https://openairdocs.org/ntsb/FTW69D0195.md): Cessna 180 · Dripping Spgs, TX · Accident · No injuries · Closed · Aug 2, 1968 · N4596B · Substantial damage
- [NTSB DIA69F0037](https://openairdocs.org/ntsb/DIA69F0037.md): Piper PA-22 · Earlysville, VA · Accident · No injuries · Closed · Aug 2, 1968 · N7009B · Substantial damage
- [NTSB CHI69F0202](https://openairdocs.org/ntsb/CHI69F0202.md): Piper PA-22 · Byron Center, MI · Accident · No injuries · Closed · Aug 2, 1968 · N5257Z · Substantial damage
- [NTSB CHI69D0167](https://openairdocs.org/ntsb/CHI69D0167.md): Cessna 150 · Franklin, WI · Accident · Minor injuries · Closed · Jul 31, 1968 · N3906J · Destroyed
- [NTSB MKC69D0100](https://openairdocs.org/ntsb/MKC69D0100.md): Piper PA-28 · Clearwater, NE · Accident · No injuries · Closed · Jul 30, 1968 · N9150W · Substantial damage
- [NTSB LAX69D0079](https://openairdocs.org/ntsb/LAX69D0079.md): Bell 47G3B1 · Peach Spgs, AZ · Accident · No injuries · Closed · Jul 30, 1968 · N6245N · Substantial damage
- [NTSB ANC69D0062](https://openairdocs.org/ntsb/ANC69D0062.md): Piper J3C · Eureka, AK · Accident · No injuries · Closed · Jul 30, 1968 · N24846 · Substantial damage
- [NTSB OAK69D0071](https://openairdocs.org/ntsb/OAK69D0071.md): Stinson 108-1 · Livermore, CA · Accident · Minor injuries · Closed · Jul 29, 1968 · N97882 · Substantial damage
- [NTSB NYC69D0072](https://openairdocs.org/ntsb/NYC69D0072.md): Cessna 150 · Warwick, NY · Accident · No injuries · Closed · Jul 29, 1968 · N8667G · Destroyed
- [NTSB NYC69F0143](https://openairdocs.org/ntsb/NYC69F0143.md): Colonial C-1 · Gardenville, NY · Accident · No injuries · Closed · Jul 28, 1968 · N257B · Destroyed
- [NTSB NYC69A0011](https://openairdocs.org/ntsb/NYC69A0011.md): Piper PA-23 · Wyandanch, NY · Accident · 8 fatal · Closed · Jul 28, 1968 · N5980Y · 2 aircraft · Destroyed
- [NTSB DEN69D0054](https://openairdocs.org/ntsb/DEN69D0054.md): Cessna 172 · Crownpoint, NM · Accident · Minor injuries · Closed · Jul 28, 1968 · N7914X · Substantial damage
- [NTSB CHI69D0135](https://openairdocs.org/ntsb/CHI69D0135.md): Cessna 150 · Lawton, MI · Accident · No injuries · Closed · Jul 28, 1968 · N6946F · Substantial damage
- [NTSB NYC69D0107](https://openairdocs.org/ntsb/NYC69D0107.md): Cessna 140 · Vinalhaven, ME · Accident · No injuries · Closed · Jul 27, 1968 · N72786 · Substantial damage
- [NTSB MKC69D0059](https://openairdocs.org/ntsb/MKC69D0059-109299.md): Cessna 177 · Eden Prairie, MN · Accident · No injuries · Closed · Jul 27, 1968 · N3419T · Substantial damage
- [NTSB SEA68D0082](https://openairdocs.org/ntsb/SEA68D0082-108594.md): Cessna 182 · Kalispell, MT · Accident · No injuries · Closed · Jul 26, 1968 · N3530U · Substantial damage
- [NTSB MKC69D0054](https://openairdocs.org/ntsb/MKC69D0054.md): Hughes 269A · Onawa, IA · Accident · No injuries · Closed · Jul 25, 1968 · N8841F · Substantial damage
- [NTSB MIA69D0080](https://openairdocs.org/ntsb/MIA69D0080.md): Piper PA-22 · Moore Haven, FL · Accident · No injuries · Closed · Jul 24, 1968 · N7749D · Substantial damage
- [NTSB SEA69F0076](https://openairdocs.org/ntsb/SEA69F0076.md): Piper J5A · Beaverton, OR · Accident · No injuries · Closed · Jul 23, 1968 · N35692 · Substantial damage
- [NTSB LAX69F0062](https://openairdocs.org/ntsb/LAX69F0062.md): Lear Jet 24A · Little Rock, CA · Accident · No injuries · Closed · Jul 23, 1968 · N388R · Substantial damage
- [NTSB CHI69F0077](https://openairdocs.org/ntsb/CHI69F0077.md): Cessna 150 · Armada, MI · Accident · Minor injuries · Closed · Jul 22, 1968 · N7035X · Substantial damage
- [NTSB NYC69D0125](https://openairdocs.org/ntsb/NYC69D0125.md): Piper PA-22 · Monroeville, PA · Accident · Minor injuries · Closed · Jul 21, 1968 · N5433Z · Substantial damage
- [NTSB FTW69F0111](https://openairdocs.org/ntsb/FTW69F0111.md): Jukich AV-36 · Alpine, TX · Accident · Serious injuries · Closed · Jul 21, 1968 · N41R · Destroyed
- [NTSB DIA69F0030](https://openairdocs.org/ntsb/DIA69F0030.md): Piper PA-12 · White Lake, NC · Accident · Serious injuries · Closed · Jul 21, 1968 · N4435M · Substantial damage
- [NTSB CHI69F0106](https://openairdocs.org/ntsb/CHI69F0106.md): Luscombe 8A · Bainbridge, OH · Accident · Minor injuries · Closed · Jul 21, 1968 · N71749 · Substantial damage
- [NTSB SEA69D0038](https://openairdocs.org/ntsb/SEA69D0038.md): Ercoupe 415-C · Nampa, ID · Accident · No injuries · Closed · Jul 20, 1968 · N87283 · Substantial damage

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

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

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