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

## Cases, newest first

- [NTSB SEA69F0109](https://openairdocs.org/ntsb/SEA69F0109.md): Piper PA-14 · Silverdale, WA · Accident · No injuries · Closed · Aug 30, 1968 · N4296H · Substantial damage
- [NTSB SEA69D0099](https://openairdocs.org/ntsb/SEA69D0099.md): Cessna 150 · Friday Harbr, WA · Accident · No injuries · Closed · Aug 30, 1968 · N6720F · Substantial damage
- [NTSB NYC69D0145](https://openairdocs.org/ntsb/NYC69D0145.md): Cessna 172 · Manchester, PA · Accident · No injuries · Closed · Aug 30, 1968 · N7500T · Substantial damage
- [NTSB NYC69F0182](https://openairdocs.org/ntsb/NYC69F0182.md): Piper PA-28 · Croton Lake, NY · Accident · No injuries · Closed · Aug 29, 1968 · N6833W · Substantial damage
- [NTSB NYC69A0025](https://openairdocs.org/ntsb/NYC69A0025.md): Cessna 180D · Ashland, NH · Accident · 3 fatal · Closed · Aug 29, 1968 · N3170D · Destroyed
- [NTSB FTW69F0177](https://openairdocs.org/ntsb/FTW69F0177.md): Erco 415-C · Keller, TX · Accident · No injuries · Closed · Aug 29, 1968 · N99601 · Substantial damage
- [NTSB DIA69D0060](https://openairdocs.org/ntsb/DIA69D0060.md): Schweizer SGS126 · Leesburg, VA · Accident · No injuries · Closed · Aug 27, 1968 · N5705S · Substantial damage
- [NTSB SEA69D0083](https://openairdocs.org/ntsb/SEA69D0083.md): Cessna 177 · Montpelier, ID · Accident · No injuries · Closed · Aug 25, 1968 · N2866X · Substantial damage
- [NTSB MKC69F0136](https://openairdocs.org/ntsb/MKC69F0136.md): Ryan ST-3KR · Troy Mills, IA · Accident · Serious injuries · Closed · Aug 25, 1968 · N48605 · Destroyed
- [NTSB MKC69D0206](https://openairdocs.org/ntsb/MKC69D0206.md): Luscombe 8A · Bonner Sprgs, KS · Accident · Minor injuries · Closed · Aug 25, 1968 · N71574 · Substantial damage
- [NTSB MIA69F0106](https://openairdocs.org/ntsb/MIA69F0106.md): Alon A-2 · Tampa, FL · Accident · No injuries · Closed · Aug 25, 1968 · N5691F · Substantial damage
- [NTSB LAX69D0120](https://openairdocs.org/ntsb/LAX69D0120.md): Cessna 150F · Kernville, CA · Accident · No injuries · Closed · Aug 25, 1968 · N7980F · Substantial damage
- [NTSB CHI69D0282](https://openairdocs.org/ntsb/CHI69D0282.md): Cessna 150 · Lynnville, KY · Accident · No injuries · Closed · Aug 25, 1968 · N4422U · Destroyed
- [NTSB NYC69A0023](https://openairdocs.org/ntsb/NYC69A0023.md): Cessna 120 · Braintree, MA · Accident · 1 fatal · Closed · Aug 24, 1968 · N76424 · Destroyed
- [NTSB LAX69F0103](https://openairdocs.org/ntsb/LAX69F0103.md): Schweizer SGS233 · Tehachapi, CA · Accident · Serious injuries · Closed · Aug 24, 1968 · N5733J · Substantial damage
- [NTSB FTW69A0012](https://openairdocs.org/ntsb/FTW69A0012.md): Piper PA-18A · Sinton, TX · Accident · 1 fatal · Closed · Aug 24, 1968 · N7798B · Destroyed
- [NTSB CHI69F0195](https://openairdocs.org/ntsb/CHI69F0195.md): Piper PA-28 · Freeport, IL · Accident · No injuries · Closed · Aug 23, 1968 · N5219L · Substantial damage
- [NTSB ANC69D0052](https://openairdocs.org/ntsb/ANC69D0052.md): Piper PA-28 · Kenai, AK · Accident · No injuries · Closed · Aug 23, 1968 · N5233W · Substantial damage
- [NTSB OAK69A0013](https://openairdocs.org/ntsb/OAK69A0013.md): Piper PA-32 · Reno, NV · Accident · No injuries · Closed · Aug 21, 1968 · N4115W · Substantial damage
- [NTSB MKC69F0132](https://openairdocs.org/ntsb/MKC69F0132.md): Piper PA-12 · St.Charles, MO · Accident · No injuries · Closed · Aug 21, 1968 · N92579 · Substantial damage
- [NTSB MKC69F0119](https://openairdocs.org/ntsb/MKC69F0119.md): Beech A23-19 · Rock Rapids, IA · Accident · Minor injuries · Closed · Aug 21, 1968 · N4788J · Substantial damage
- [NTSB MIA69F0141](https://openairdocs.org/ntsb/MIA69F0141.md): Cessna 140 · Opa Locka, FL · Accident · No injuries · Closed · Aug 21, 1968 · N76853 · Substantial damage
- [NTSB CHI69F0240](https://openairdocs.org/ntsb/CHI69F0240.md): Cessna 150H · East St.Louis, IL · Accident · Minor injuries · Closed · Aug 20, 1968 · N23486 · Substantial damage
- [NTSB MIA69F0268](https://openairdocs.org/ntsb/MIA69F0268.md): Aero Comdr 680-FL · Crescent Beach, SC · Accident · Minor injuries · Closed · Aug 19, 1968 · N6379U · Substantial damage
- [NTSB MIA69D0128](https://openairdocs.org/ntsb/MIA69D0128.md): Piper PA-18 · Cottonwood, AL · Accident · No injuries · Closed · Aug 19, 1968 · N9490D · Substantial damage
- [NTSB OAK69D0139](https://openairdocs.org/ntsb/OAK69D0139.md): Piper PA-24 · Bridgeport, CA · Accident · Minor injuries · Closed · Aug 18, 1968 · N6512P · Substantial damage
- [NTSB OAK69D0093](https://openairdocs.org/ntsb/OAK69D0093.md): Cessna 170 · Vacaville, CA · Accident · No injuries · Closed · Aug 18, 1968 · N3944V · Substantial damage
- [NTSB OAK69D0087](https://openairdocs.org/ntsb/OAK69D0087.md): Schweizer SGS126 · Fremont, CA · Accident · No injuries · Closed · Aug 18, 1968 · N2769Z · Substantial damage
- [NTSB NYC69A0020](https://openairdocs.org/ntsb/NYC69A0020.md): Taylorcraft BC12-D · Barre Plains, MA · Accident · Minor injuries · Closed · Aug 18, 1968 · N43118 · 2 aircraft · Substantial damage
- [NTSB MKC69D0214](https://openairdocs.org/ntsb/MKC69D0214.md): Beech S35 · Bethany, MO · Accident · No injuries · Closed · Aug 18, 1968 · N8636Q · Substantial damage
- [NTSB CHI69F0221](https://openairdocs.org/ntsb/CHI69F0221.md): Piper PA-23 · Wheeling, IL · Accident · No injuries · Closed · Aug 18, 1968 · N4285P · Substantial damage
- [NTSB CHI69D0241](https://openairdocs.org/ntsb/CHI69D0241.md): Globe GC-1B · Galion, OH · Accident · Minor injuries · Closed · Aug 18, 1968 · N3744K · Substantial damage
- [NTSB OAK69A0012](https://openairdocs.org/ntsb/OAK69A0012.md): Cessna 210 · Monterey, CA · Accident · 3 fatal · Closed · Aug 17, 1968 · N9676T · Destroyed
- [NTSB CHI69A0020](https://openairdocs.org/ntsb/CHI69A0020.md): Cessna 172H · Aurora, KY · Accident · Serious injuries · Closed · Aug 16, 1968 · N1453F · Destroyed
- [NTSB NYC69F0127](https://openairdocs.org/ntsb/NYC69F0127.md): Cessna 150 · Flemington, NJ · Accident · No injuries · Closed · Aug 15, 1968 · N84623 · Substantial damage
- [NTSB OAK69A0010](https://openairdocs.org/ntsb/OAK69A0010.md): Cessna 150 · Hayward, CA · Accident · No injuries · Closed · Aug 14, 1968 · N7819E · 2 aircraft · Substantial damage
- [NTSB MKC69D0113](https://openairdocs.org/ntsb/MKC69D0113.md): Piper PA-16 · Rush City, MN · Accident · No injuries · Closed · Aug 14, 1968 · N5705H · Substantial damage
- [NTSB FTW69D0153](https://openairdocs.org/ntsb/FTW69D0153.md): Piper PA-24 · Guymon, OK · Accident · No injuries · Closed · Aug 14, 1968 · N6498P · Substantial damage
- [NTSB DEN69D0073](https://openairdocs.org/ntsb/DEN69D0073.md): Cessna 140 · Grass Creek, WY · Accident · No injuries · Closed · Aug 14, 1968 · N5686C · Substantial damage
- [NTSB CHI69F0333](https://openairdocs.org/ntsb/CHI69F0333.md): Cessna 150 · Carmi, IL · Accident · Serious injuries · Closed · Aug 14, 1968 · N6370S · Substantial damage
- [NTSB CHI69F0199](https://openairdocs.org/ntsb/CHI69F0199.md): Cessna 177 · E.St.Louis, IL · Accident · Serious injuries · Closed · Aug 14, 1968 · N3389T · Destroyed
- [NTSB MKC69F0069](https://openairdocs.org/ntsb/MKC69F0069.md): Cessna 180H · St Paul, MO · Accident · No injuries · Closed · Aug 13, 1968 · N7903V · Substantial damage
- [NTSB LAX69D0116](https://openairdocs.org/ntsb/LAX69D0116.md): Callair A-9 · Coolidge, AZ · Accident · Minor injuries · Closed · Aug 13, 1968 · N7604V · Substantial damage
- [NTSB FTW69F0149](https://openairdocs.org/ntsb/FTW69F0149.md): Taylorcraft DCO-65 · Slaton, TX · Accident · Minor injuries · Closed · Aug 13, 1968 · N50593 · Substantial damage
- [NTSB NYC69D0137](https://openairdocs.org/ntsb/NYC69D0137.md): Piper PA-28 · Southbridge, MA · Accident · Minor injuries · Closed · Aug 11, 1968 · N5282W · Substantial damage
- [NTSB FTW69F0190](https://openairdocs.org/ntsb/FTW69F0190.md): Aeronca 7AC · Grapevine, TX · Accident · Minor injuries · Closed · Aug 11, 1968 · N84889 · Substantial damage
- [NTSB CHI69D0131](https://openairdocs.org/ntsb/CHI69D0131.md): Cessna 180 · Sabina, OH · Accident · No injuries · Closed · Aug 11, 1968 · N1537C · Substantial damage
- [NTSB NYC69F0151](https://openairdocs.org/ntsb/NYC69F0151.md): Luscombe 8A · Patchogue, NY · Accident · Minor injuries · Closed · Aug 10, 1968 · N1939B · Substantial damage
- [NTSB FTW69F0143](https://openairdocs.org/ntsb/FTW69F0143.md): Piper PA-24 · Eudora, AR · Accident · No injuries · Closed · Aug 10, 1968 · N8757P · Substantial damage
- [NTSB FTW69D0189](https://openairdocs.org/ntsb/FTW69D0189.md): Beech N35 · Wichita Falls, TX · Accident · No injuries · Closed · Aug 10, 1968 · N9387Y · Substantial damage

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

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

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