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

## Cases, newest first

- [NTSB SEA70F0122](https://openairdocs.org/ntsb/SEA70F0122.md): Alon A-2 · Vancouver, WA · Accident · No injuries · Closed · Aug 31, 1969 · N5632F · Substantial damage
- [NTSB MKC70F0205](https://openairdocs.org/ntsb/MKC70F0205.md): Callair A-9B · Ithaca, NE · Accident · Serious injuries · Closed · Aug 31, 1969 · N7264V · Substantial damage
- [NTSB MKC70D0173](https://openairdocs.org/ntsb/MKC70D0173.md): Cessna 150 · Council Blfs, IA · Accident · Minor injuries · Closed · Aug 31, 1969 · N8547G · Substantial damage
- [NTSB CHI70F0247](https://openairdocs.org/ntsb/CHI70F0247.md): Piper PA-22 · Decatur, IL · Accident · Serious injuries · Closed · Aug 31, 1969 · N1745P · Substantial damage
- [NTSB CHI70D0287](https://openairdocs.org/ntsb/CHI70D0287.md): Mooney M20E · Northbrook, IL · Accident · No injuries · Closed · Aug 31, 1969 · N79840 · Substantial damage
- [NTSB NYC70F0143](https://openairdocs.org/ntsb/NYC70F0143.md): Beech V35A · Rochester, NY · Accident · Minor injuries · Closed · Aug 30, 1969 · N7932R · Substantial damage
- [NTSB MKC70D0165](https://openairdocs.org/ntsb/MKC70D0165.md): Piper PA-32 · Garden City, KS · Accident · Minor injuries · Closed · Aug 30, 1969 · N4202R · Substantial damage
- [NTSB MIA70D0249](https://openairdocs.org/ntsb/MIA70D0249.md): Cessna 140 · Cleveland, GA · Accident · Serious injuries · Closed · Aug 30, 1969 · N77142 · Substantial damage
- [NTSB CHI70F0224](https://openairdocs.org/ntsb/CHI70F0224.md): Cessna 172 · Dundee, MI · Accident · No injuries · Closed · Aug 30, 1969 · N8966B · Substantial damage
- [NTSB CHI70F0203](https://openairdocs.org/ntsb/CHI70F0203.md): Cessna 182 · Ada, OH · Accident · No injuries · Closed · Aug 30, 1969 · N5770B · Substantial damage
- [NTSB NYC70F0147](https://openairdocs.org/ntsb/NYC70F0147.md): Beech 95-B55 · Forest City, PA · Accident · No injuries · Closed · Aug 29, 1969 · N97Q · Substantial damage
- [NTSB OAK70D0111](https://openairdocs.org/ntsb/OAK70D0111.md): Cessna 150 · S Lke Tahoe, CA · Accident · Minor injuries · Closed · Aug 28, 1969 · N6465S · Substantial damage
- [NTSB FTW70D0202](https://openairdocs.org/ntsb/FTW70D0202.md): Mooney M20C · Waurika, OK · Accident · No injuries · Closed · Aug 28, 1969 · N5999Q · Substantial damage
- [NTSB MIA70F0181](https://openairdocs.org/ntsb/MIA70F0181.md): Cessna 177 · Orlando, FL · Accident · No injuries · Closed · Aug 27, 1969 · N3258T · Substantial damage
- [NTSB NYC70F0128](https://openairdocs.org/ntsb/NYC70F0128.md): Cessna TU206U · Norwood, MA · Accident · No injuries · Closed · Aug 26, 1969 · N734AP · Substantial damage
- [NTSB MIA70A0016](https://openairdocs.org/ntsb/MIA70A0016.md): Beech 65 · Mobile, AL · Accident · 3 fatal · Closed · Aug 26, 1969 · N3333M · Destroyed
- [NTSB IAD70A0017](https://openairdocs.org/ntsb/IAD70A0017.md): Cessna 150G · Gastonia, NC · Accident · 1 fatal · Closed · Aug 26, 1969 · N3187J · 2 aircraft · Minor damage
- [NTSB CHI70A0014](https://openairdocs.org/ntsb/CHI70A0014.md): Globe GC-1B · Boardman, OH · Accident · 2 fatal · Closed · Aug 26, 1969 · N90344 · Destroyed
- [NTSB MKC70A0006](https://openairdocs.org/ntsb/MKC70A0006.md): Piper PA-32 · Topeka, KS · Accident · No injuries · Closed · Aug 25, 1969 · N4105W · Substantial damage
- [NTSB MIA70F0121](https://openairdocs.org/ntsb/MIA70F0121.md): Beech 23 · Camden, SC · Accident · No injuries · Closed · Aug 25, 1969 · N2371Z · Substantial damage
- [NTSB CHI70F0230](https://openairdocs.org/ntsb/CHI70F0230.md): Piper PA-28 · Lombard, IL · Accident · No injuries · Closed · Aug 25, 1969 · N6843W · Substantial damage
- [NTSB SEA70A0011](https://openairdocs.org/ntsb/SEA70A0011.md): Cessna 180 · Harrison, ID · Accident · 3 fatal · Closed · Aug 24, 1969 · N3633C · Destroyed
- [NTSB LAX70F0118](https://openairdocs.org/ntsb/LAX70F0118.md): Cessna 150H · Van Nuys, CA · Accident · No injuries · Closed · Aug 24, 1969 · N50254 · Substantial damage
- [NTSB DIA70D0052](https://openairdocs.org/ntsb/DIA70D0052.md): Schweizer SGS232 · Banner Elk, NC · Accident · No injuries · Closed · Aug 24, 1969 · N7746S · Substantial damage
- [NTSB DEN70D0085](https://openairdocs.org/ntsb/DEN70D0085.md): Luscombe 8E · Fountain, CO · Accident · No injuries · Closed · Aug 24, 1969 · N2304K · Substantial damage
- [NTSB CHI70D0298](https://openairdocs.org/ntsb/CHI70D0298.md): Cessna 140 · Chilton, WI · Accident · No injuries · Closed · Aug 24, 1969 · N1999V · Substantial damage
- [NTSB MIA70A0014](https://openairdocs.org/ntsb/MIA70A0014.md): Beech C-45G · Brentwood, TN · Accident · 1 fatal · Closed · Aug 22, 1969 · N311U · Destroyed
- [NTSB ANC70F0022](https://openairdocs.org/ntsb/ANC70F0022.md): Taylorcraft BL-12 · Yakutat, AK · Accident · No injuries · Closed · Aug 22, 1969 · N96204 · Substantial damage
- [NTSB SEA70F0090](https://openairdocs.org/ntsb/SEA70F0090.md): Piper PA-22 · Halsey, OR · Accident · Serious injuries · Closed · Aug 21, 1969 · N4782Z · Substantial damage
- [NTSB OAK70A0012](https://openairdocs.org/ntsb/OAK70A0012.md): Navion B · Ash Meadows, NV · Accident · 2 fatal · Closed · Aug 21, 1969 · N5255K · Destroyed
- [NTSB NYC70FIK04](https://openairdocs.org/ntsb/NYC70FIK04.md): Cessna 310N · Coraopolis, PA · Accident · Serious injuries · Closed · Aug 20, 1969 · N4195Q · Substantial damage
- [NTSB MIA70D0116](https://openairdocs.org/ntsb/MIA70D0116.md): Stinson 108-2 · Cameron, SC · Accident · No injuries · Closed · Aug 17, 1969 · N290C · Substantial damage
- [NTSB CHI70F0266](https://openairdocs.org/ntsb/CHI70F0266.md): Aeronca 7AC · Farmington, IL · Accident · Minor injuries · Closed · Aug 17, 1969 · N102P · Substantial damage
- [NTSB OAK70D0087](https://openairdocs.org/ntsb/OAK70D0087.md): Piper PA-18 · Cutler, CA · Accident · No injuries · Closed · Aug 16, 1969 · N7600B · Substantial damage
- [NTSB NYC70D0133](https://openairdocs.org/ntsb/NYC70D0133.md): Cessna 150 · Ambler, PA · Accident · No injuries · Closed · Aug 16, 1969 · N60743 · Substantial damage
- [NTSB DEN70D0076](https://openairdocs.org/ntsb/DEN70D0076.md): Beech T-34A · Fort Bridger, WY · Accident · Minor injuries · Closed · Aug 16, 1969 · N7745C · Substantial damage
- [NTSB LAX70F0128](https://openairdocs.org/ntsb/LAX70F0128.md): Cessna 172 · Fullerton, CA · Accident · No injuries · Closed · Aug 15, 1969 · N46288 · Destroyed
- [NTSB IAD70F0056](https://openairdocs.org/ntsb/IAD70F0056.md): Piper PA-22 · Hot Springs, VA · Accident · Serious injuries · Closed · Aug 15, 1969 · N3832P · Destroyed
- [NTSB SEA70D0067](https://openairdocs.org/ntsb/SEA70D0067.md): Cessna 172 · Electric Cty, WA · Accident · No injuries · Closed · Aug 14, 1969 · N5741A · Substantial damage
- [NTSB LAX70D0095](https://openairdocs.org/ntsb/LAX70D0095.md): Cessna 182 · Rubidoux, CA · Accident · No injuries · Closed · Aug 14, 1969 · N2569G · Substantial damage
- [NTSB MIA70D0132](https://openairdocs.org/ntsb/MIA70D0132.md): Cessna 182 · Rock Hill, SC · Accident · No injuries · Closed · Aug 13, 1969 · N6352A · Substantial damage
- [NTSB FTW70D0131](https://openairdocs.org/ntsb/FTW70D0131.md): Beech A23-19 · Amarillo, TX · Accident · No injuries · Closed · Aug 13, 1969 · N2385W · Substantial damage
- [NTSB CHI70F0164](https://openairdocs.org/ntsb/CHI70F0164.md): Beech 95-55 · Waverly, OH · Accident · Serious injuries · Closed · Aug 13, 1969 · N525S · Destroyed
- [NTSB FTW70D0175](https://openairdocs.org/ntsb/FTW70D0175-201472.md): Beech D45 · Blue Earth, MN · Accident · Serious injuries · Closed · Aug 12, 1969 · N4824Z · Substantial damage
- [NTSB FTW70D0146](https://openairdocs.org/ntsb/FTW70D0146.md): Cessna 180 · Helena, AR · Accident · Minor injuries · Closed · Aug 12, 1969 · N76F · Substantial damage
- [NTSB MKC70D0142](https://openairdocs.org/ntsb/MKC70D0142.md): Beech 35-B33 · Grinnell, IA · Accident · No injuries · Closed · Aug 11, 1969 · N9703Y · Substantial damage
- [NTSB IAD70A0012](https://openairdocs.org/ntsb/IAD70A0012.md): Beech N35 · Suffolk, VA · Accident · 1 fatal · Closed · Aug 10, 1969 · N9463Y · Destroyed
- [NTSB DIA70D0050](https://openairdocs.org/ntsb/DIA70D0050.md): Cessna 180 · Stafford, VA · Accident · No injuries · Closed · Aug 10, 1969 · N3143D · Substantial damage
- [NTSB SEA70D0063](https://openairdocs.org/ntsb/SEA70D0063.md): Piper PA-28 · Brookings, OR · Accident · No injuries · Closed · Aug 9, 1969 · N9446J · Substantial damage
- [NTSB NYC70D0102](https://openairdocs.org/ntsb/NYC70D0102.md): Beech T-34B · Orleans, MA · Accident · No injuries · Closed · Aug 9, 1969 · N11SG · Substantial damage

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

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

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