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

## Cases, newest first

- [NTSB LAX70D0099](https://openairdocs.org/ntsb/LAX70D0099.md): Schweizer SGS123 · Elsinore, CA · Accident · No injuries · Closed · Aug 9, 1969 · N3843A · Substantial damage
- [NTSB FTW70D0174](https://openairdocs.org/ntsb/FTW70D0174.md): Piper PA-28 · Augusta, AR · Accident · No injuries · Closed · Aug 8, 1969 · N9061W · Substantial damage
- [NTSB LAX70F0084](https://openairdocs.org/ntsb/LAX70F0084.md): Stinson L-5 · Daggett, CA · Accident · Minor injuries · Closed · Aug 7, 1969 · N51130 · Substantial damage
- [NTSB DEN70F0083](https://openairdocs.org/ntsb/DEN70F0083.md): Beech S35 · Denver, CO · Accident · No injuries · Closed · Aug 7, 1969 · N8551Q · Substantial damage
- [NTSB DEN70D0055](https://openairdocs.org/ntsb/DEN70D0055.md): Beech 19A · Salt Lake City, UT · Accident · No injuries · Closed · Aug 7, 1969 · N6067N · Substantial damage
- [NTSB CHI70D0178](https://openairdocs.org/ntsb/CHI70D0178.md): Cessna 150 · Owensboro, KY · Accident · No injuries · Closed · Aug 7, 1969 · N6367S · Substantial damage
- [NTSB MKC70D0105](https://openairdocs.org/ntsb/MKC70D0105.md): Cessna 150 · Davenport, IA · Accident · No injuries · Closed · Aug 6, 1969 · N8613S · Substantial damage
- [NTSB OAK70F0075](https://openairdocs.org/ntsb/OAK70F0075.md): Piper PA-24 · Fair Oaks, CA · Accident · No injuries · Closed · Aug 5, 1969 · N6713P · Substantial damage
- [NTSB NYC70A0019](https://openairdocs.org/ntsb/NYC70A0019.md): Cessna 180B · Greenville, ME · Accident · 1 fatal · Closed · Aug 5, 1969 · N5084E · Substantial damage
- [NTSB MKC70D0202](https://openairdocs.org/ntsb/MKC70D0202.md): Cessna 150 · Ozark, MO · Accident · No injuries · Closed · Aug 5, 1969 · N3168X · Substantial damage
- [NTSB FTW70A0009](https://openairdocs.org/ntsb/FTW70A0009.md): Beech 95-B55 · Grand Prairie, TX · Accident · 1 fatal · Closed · Aug 4, 1969 · N197J · Destroyed
- [NTSB DIA70D0043](https://openairdocs.org/ntsb/DIA70D0043.md): Piper PA-22 · Mitchellville, MD · Accident · No injuries · Closed · Aug 3, 1969 · N3630Z · Substantial damage
- [NTSB DEN70A0008](https://openairdocs.org/ntsb/DEN70A0008.md): Cessna 172H · Albuquerque, NM · Accident · 1 fatal · Closed · Aug 3, 1969 · N1662F · Destroyed
- [NTSB CHI70D0226](https://openairdocs.org/ntsb/CHI70D0226.md): Piper PA-28 · Columbia Sta, OH · Accident · Minor injuries · Closed · Aug 3, 1969 · N1842J · Substantial damage
- [NTSB DEN70F0051](https://openairdocs.org/ntsb/DEN70F0051.md): Piper PA-25 · Estancia, NM · Accident · No injuries · Closed · Aug 2, 1969 · N8675L · Destroyed
- [NTSB CHI70D0144](https://openairdocs.org/ntsb/CHI70D0144.md): Cessna 177 · Spooner, MN · Accident · Serious injuries · Closed · Aug 2, 1969 · N2311Y · Substantial damage
- [NTSB CHI70D0108](https://openairdocs.org/ntsb/CHI70D0108.md): Piper PA-23 · Brownsburg, IN · Accident · No injuries · Closed · Aug 2, 1969 · N2219P · Destroyed
- [NTSB FTW70D0117](https://openairdocs.org/ntsb/FTW70D0117.md): Piper PA-18 · Cameron, LA · Accident · Minor injuries · Closed · Aug 1, 1969 · N4119Z · Substantial damage
- [NTSB NYC70F0092](https://openairdocs.org/ntsb/NYC70F0092.md): Hughes 269A · West Seneca, NY · Accident · No injuries · Closed · Jul 30, 1969 · N8725F · Substantial damage
- [NTSB LAX70F0055](https://openairdocs.org/ntsb/LAX70F0055.md): Champion 7GCBC · Santa Susana, CA · Accident · Serious injuries · Closed · Jul 29, 1969 · N1689G · Substantial damage
- [NTSB SEA70A0005](https://openairdocs.org/ntsb/SEA70A0005.md): Piper PA-28 · Astoria, OR · Accident · 1 fatal · Closed · Jul 27, 1969 · N9751W · Destroyed
- [NTSB FTW70F0148](https://openairdocs.org/ntsb/FTW70F0148.md): Cougar 1 · Yukon, OK · Accident · 1 fatal · Closed · Jul 27, 1969 · N7121 · Destroyed
- [NTSB DEN70F0075](https://openairdocs.org/ntsb/DEN70F0075.md): Bell 47G3B1 · Cheyenne, WY · Accident · No injuries · Closed · Jul 27, 1969 · N8575F · Substantial damage
- [NTSB DEN70A0006](https://openairdocs.org/ntsb/DEN70A0006.md): Beech C35 · Las Vegas, NM · Accident · 5 fatal · Closed · Jul 27, 1969 · N64F · Destroyed
- [NTSB CHI70F0135](https://openairdocs.org/ntsb/CHI70F0135.md): Piper PA-28 · Middleton, WI · Accident · No injuries · Closed · Jul 27, 1969 · N6743J · Substantial damage
- [NTSB OAK70D0065](https://openairdocs.org/ntsb/OAK70D0065.md): Cessna 172 · Weaverville, CA · Accident · No injuries · Closed · Jul 26, 1969 · N8848B · Destroyed
- [NTSB MIA70A0004](https://openairdocs.org/ntsb/MIA70A0004.md): Douglas DC-3A · Chamblee, GA · Accident · No injuries · Closed · Jul 26, 1969 · N686RP · Substantial damage
- [NTSB FTW70F0167](https://openairdocs.org/ntsb/FTW70F0167.md): Stinson 108-1 · Saginaw, TX · Accident · Minor injuries · Closed · Jul 26, 1969 · N8775K · Substantial damage
- [NTSB FTW70D0094](https://openairdocs.org/ntsb/FTW70D0094.md): Cessna 188 · Palmer, TX · Accident · No injuries · Closed · Jul 26, 1969 · N8004V · Substantial damage
- [NTSB DCA70A0002](https://openairdocs.org/ntsb/DCA70A0002-79451.md): Boeing 707 · Pomona, NJ · Accident · 5 fatal · Closed · Jul 26, 1969 · N787TW · Destroyed
- [NTSB ANC70D0043](https://openairdocs.org/ntsb/ANC70D0043.md): Piper PA-11 · Dillingham, AK · Accident · No injuries · Closed · Jul 26, 1969 · N78610 · Substantial damage
- [NTSB MKC70D0186](https://openairdocs.org/ntsb/MKC70D0186.md): Piper PA-25 · Kansas City, KS · Accident · No injuries · Closed · Jul 25, 1969 · N7641Z · Substantial damage
- [NTSB MKC70D0121](https://openairdocs.org/ntsb/MKC70D0121.md): Piper PA-25 · Hugoton, KS · Accident · No injuries · Closed · Jul 25, 1969 · N6555L · Substantial damage
- [NTSB ANC70D0026](https://openairdocs.org/ntsb/ANC70D0026.md): Champion 7GC · Palmer, AK · Accident · No injuries · Closed · Jul 23, 1969 · N7676E · Substantial damage
- [NTSB IAD70D0044](https://openairdocs.org/ntsb/IAD70D0044.md): Piper PA-22 · Park Hall, MD · Accident · No injuries · Closed · Jul 22, 1969 · N5730Z · Substantial damage
- [NTSB FTW70F0112](https://openairdocs.org/ntsb/FTW70F0112.md): Cessna 170B · Smithfield, TX · Accident · Minor injuries · Closed · Jul 21, 1969 · N4534C · Substantial damage
- [NTSB FTW70F0156](https://openairdocs.org/ntsb/FTW70F0156.md): Piper PA-23 · Clear Springs, TX · Accident · No injuries · Closed · Jul 20, 1969 · N3471P · Substantial damage
- [NTSB MKC70F0085](https://openairdocs.org/ntsb/MKC70F0085.md): Beech A23-24 · Tecumseh, NE · Accident · Serious injuries · Closed · Jul 19, 1969 · N6129N · Substantial damage
- [NTSB MIA70D0083](https://openairdocs.org/ntsb/MIA70D0083.md): Cessna 150F · Ozark, AL · Accident · No injuries · Closed · Jul 19, 1969 · N8207S · Substantial damage
- [NTSB LAX70D0051](https://openairdocs.org/ntsb/LAX70D0051.md): Piper PA-23 · Bakersfield, CA · Accident · No injuries · Closed · Jul 19, 1969 · N5551Y · Substantial damage
- [NTSB FTW70F0108](https://openairdocs.org/ntsb/FTW70F0108.md): Many Miles 1 · Jacksboro, TX · Accident · 2 fatal · Closed · Jul 19, 1969 · N74071 · Destroyed
- [NTSB SEA70D0061](https://openairdocs.org/ntsb/SEA70D0061.md): Cessna 180 · Donald, OR · Accident · No injuries · Closed · Jul 18, 1969 · N2992A · Substantial damage
- [NTSB NYC70D0109](https://openairdocs.org/ntsb/NYC70D0109.md): Beech 23 · Perry, NY · Accident · No injuries · Closed · Jul 18, 1969 · N8760M · Substantial damage
- [NTSB FTW70F0097](https://openairdocs.org/ntsb/FTW70F0097.md): Piper PA-32 · Arlington, TX · Accident · No injuries · Closed · Jul 18, 1969 · N4152W · Substantial damage
- [NTSB DEN70D0097](https://openairdocs.org/ntsb/DEN70D0097.md): Bell 47G3B2 · Breckenridge, CO · Accident · Minor injuries · Closed · Jul 17, 1969 · N4074G · Substantial damage
- [NTSB ANC70A0007](https://openairdocs.org/ntsb/ANC70A0007.md): Piper PA-18 · Talkeetna, AK · Accident · No injuries · Closed · Jul 16, 1969 · N2988Z · Substantial damage
- [NTSB FTW70D0211](https://openairdocs.org/ntsb/FTW70D0211.md): Erco 415-E · Fort Worth, TX · Accident · No injuries · Closed · Jul 15, 1969 · N94770 · Substantial damage
- [NTSB CHI70A0005](https://openairdocs.org/ntsb/CHI70A0005.md): Cessna 150H · Plymouth, MI · Accident · Serious injuries · Closed · Jul 15, 1969 · N50005 · 2 aircraft · Destroyed
- [NTSB NYC70D0136](https://openairdocs.org/ntsb/NYC70D0136.md): Piper J4 · Medina, NY · Accident · Minor injuries · Closed · Jul 13, 1969 · N30986 · Substantial damage
- [NTSB FTW70F0100](https://openairdocs.org/ntsb/FTW70F0100.md): Cessna 150 · Pine Bluff, AR · Accident · Serious injuries · Closed · Jul 13, 1969 · N8398G · Substantial damage

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

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

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