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

## Cases, newest first

- [NTSB DEN68F0251](https://openairdocs.org/ntsb/DEN68F0251.md): Luscombe 8A · Navajo, NM · Accident · Serious injuries · Closed · Apr 18, 1968 · N45933 · Destroyed
- [NTSB FTW68D0554](https://openairdocs.org/ntsb/FTW68D0554.md): Luscombe 8E · San Antonio, TX · Accident · No injuries · Closed · Apr 17, 1968 · N2401K · Substantial damage
- [NTSB DIA68A0043](https://openairdocs.org/ntsb/DIA68A0043.md): Cessna 150 · Trinity, NC · Accident · 1 fatal · Closed · Apr 16, 1968 · N8300J · Destroyed
- [NTSB CHI68F0702](https://openairdocs.org/ntsb/CHI68F0702.md): Piper PA-28 · Lincoln, IL · Accident · No injuries · Closed · Apr 16, 1968 · N6670W · Substantial damage
- [NTSB MKC68D0530](https://openairdocs.org/ntsb/MKC68D0530.md): Cessna 150F · Clinton, MO · Accident · No injuries · Closed · Apr 15, 1968 · N8013S · Substantial damage
- [NTSB ANC69F0006](https://openairdocs.org/ntsb/ANC69F0006.md): Maule M-4 · Wasilla, AK · Accident · No injuries · Closed · Apr 15, 1968 · N9863M · Substantial damage
- [NTSB FTW68F0551](https://openairdocs.org/ntsb/FTW68F0551.md): Cessna 150 · New Orleans, LA · Accident · No injuries · Closed · Apr 14, 1968 · N6650F · Substantial damage
- [NTSB DIA68D0194](https://openairdocs.org/ntsb/DIA68D0194.md): Cessna 172D · New Market, VA · Accident · Minor injuries · Closed · Apr 14, 1968 · N2570Y · Substantial damage
- [NTSB CHI68F0706](https://openairdocs.org/ntsb/CHI68F0706.md): Piper PA-22 · Kankakee, IL · Accident · Minor injuries · Closed · Apr 14, 1968 · N2294A · Substantial damage
- [NTSB NYC68F0440](https://openairdocs.org/ntsb/NYC68F0440.md): Piper J3C · Topsham, ME · Accident · Serious injuries · Closed · Apr 13, 1968 · N42821 · Substantial damage
- [NTSB NYC68D0441](https://openairdocs.org/ntsb/NYC68D0441.md): Piper PA-18 · Tuftonboro, NH · Accident · Minor injuries · Closed · Apr 12, 1968 · N285HC · Substantial damage
- [NTSB CHI68F0738](https://openairdocs.org/ntsb/CHI68F0738.md): Luscombe 8B · Wadsworth, OH · Accident · Serious injuries · Closed · Apr 12, 1968 · N37003 · Destroyed
- [NTSB LAX68F0400](https://openairdocs.org/ntsb/LAX68F0400.md): N American T-28A · Holbrook, AZ · Accident · 1 fatal · Closed · Apr 10, 1968 · N7708C · Substantial damage
- [NTSB DEN68D0246](https://openairdocs.org/ntsb/DEN68D0246.md): Cessna 150 · Fort Collins, CO · Accident · No injuries · Closed · Apr 10, 1968 · N3782J · Destroyed
- [NTSB CHI68F0690](https://openairdocs.org/ntsb/CHI68F0690.md): Cessna 172F · Denver, IL · Accident · Serious injuries · Closed · Apr 10, 1968 · N8269U · Substantial damage
- [NTSB CHI68A0087](https://openairdocs.org/ntsb/CHI68A0087.md): Piper PA-28 · Columbus, OH · Accident · 2 fatal · Closed · Apr 10, 1968 · N4239J · 2 aircraft · Destroyed
- [NTSB MIA68F0496](https://openairdocs.org/ntsb/MIA68F0496.md): Cessna 150 · Ocoee, FL · Accident · Serious injuries · Closed · Apr 9, 1968 · N8457G · Destroyed
- [NTSB NYC68D0432](https://openairdocs.org/ntsb/NYC68D0432.md): Piper PA-28 · Waterford, CT · Accident · No injuries · Closed · Apr 8, 1968 · N9245J · Substantial damage
- [NTSB LAX69F0291](https://openairdocs.org/ntsb/LAX69F0291.md): Cessna 172G · Inyokern, CA · Accident · Serious injuries · Closed · Apr 7, 1968 · N4363L · Destroyed
- [NTSB SEA68D0291](https://openairdocs.org/ntsb/SEA68D0291.md): Piper PA-18 · Great Falls, MT · Accident · Minor injuries · Closed · Apr 6, 1968 · N7699Y · Substantial damage
- [NTSB LAX68D0369](https://openairdocs.org/ntsb/LAX68D0369.md): Cessna 150 · El Monte, CA · Accident · No injuries · Closed · Apr 6, 1968 · N6685T · Substantial damage
- [NTSB MKC68F0511](https://openairdocs.org/ntsb/MKC68F0511.md): Piper PA-28 · Weepng Water, NE · Accident · Serious injuries · Closed · Apr 5, 1968 · N8450R · Substantial damage
- [NTSB LAX68D0378](https://openairdocs.org/ntsb/LAX68D0378.md): Piper PA-12 · Bakersfield, CA · Accident · No injuries · Closed · Apr 5, 1968 · N7735H · Substantial damage
- [NTSB CHI68F0680](https://openairdocs.org/ntsb/CHI68F0680.md): Cessna 172 · Iron Mountan, MI · Accident · No injuries · Closed · Apr 5, 1968 · N8257U · Substantial damage
- [NTSB FTW68F0547](https://openairdocs.org/ntsb/FTW68F0547.md): Bellanca 14-13 · Austin, TX · Accident · Minor injuries · Closed · Apr 4, 1968 · N61X · Substantial damage
- [NTSB ANC68F0108](https://openairdocs.org/ntsb/ANC68F0108.md): Piper PA-28 · Anchorage, AK · Accident · No injuries · Closed · Apr 4, 1968 · N9091J · Substantial damage
- [NTSB NYC68F0459](https://openairdocs.org/ntsb/NYC68F0459.md): Cessna 172 · Bradford, PA · Accident · Serious injuries · Closed · Apr 3, 1968 · N888H · Substantial damage
- [NTSB FTW68F0504](https://openairdocs.org/ntsb/FTW68F0504.md): Beech A23 · Tulsa, OK · Accident · No injuries · Closed · Apr 2, 1968 · N6931Q · Substantial damage
- [NTSB SEA68D0273](https://openairdocs.org/ntsb/SEA68D0273.md): Piper PA-12 · Cascade, ID · Accident · No injuries · Closed · Mar 31, 1968 · N3729M · Substantial damage
- [NTSB NYC68F0421](https://openairdocs.org/ntsb/NYC68F0421.md): Piper PA-28 · Kingston, NY · Accident · Minor injuries · Closed · Mar 31, 1968 · N9868W · Substantial damage
- [NTSB NYC68F0414](https://openairdocs.org/ntsb/NYC68F0414.md): Stinson 108-3 · Warren, PA · Accident · Minor injuries · Closed · Mar 31, 1968 · N6686M · Destroyed
- [NTSB NYC68D0417](https://openairdocs.org/ntsb/NYC68D0417.md): Piper PA-28 · Prospectville, PA · Accident · No injuries · Closed · Mar 31, 1968 · N6508W · Substantial damage
- [NTSB MIA68F0463](https://openairdocs.org/ntsb/MIA68F0463.md): Cessna 172 · Knoxville, TN · Accident · No injuries · Closed · Mar 31, 1968 · N1457F · Substantial damage
- [NTSB MKC68D0541](https://openairdocs.org/ntsb/MKC68D0541.md): Schweizer SGU222 · Marysville, KS · Accident · No injuries · Closed · Mar 30, 1968 · N3893A · Substantial damage
- [NTSB MIA68F0441](https://openairdocs.org/ntsb/MIA68F0441.md): Cessna 150 · Murfreesboro, TN · Accident · No injuries · Closed · Mar 30, 1968 · N7019S · Substantial damage
- [NTSB FTW68D0544](https://openairdocs.org/ntsb/FTW68D0544.md): Piper PA-28 · Dallas, TX · Accident · No injuries · Closed · Mar 30, 1968 · N6439R · Substantial damage
- [NTSB CHI68F0671](https://openairdocs.org/ntsb/CHI68F0671.md): Cessna 172G · Fraser, MI · Accident · No injuries · Closed · Mar 30, 1968 · N5995R · Substantial damage
- [NTSB CHI68A0085](https://openairdocs.org/ntsb/CHI68A0085.md): Piper PA-22 · Cincinnati, OH · Accident · 1 fatal · Closed · Mar 30, 1968 · N4658Z · Destroyed
- [NTSB FTW68F0525](https://openairdocs.org/ntsb/FTW68F0525.md): Piper PA-28 · Snyder, TX · Accident · Minor injuries · Closed · Mar 29, 1968 · N8127W · Substantial damage
- [NTSB FTW68D0541](https://openairdocs.org/ntsb/FTW68D0541.md): Piper PA-24 · Hardesty, OK · Accident · Minor injuries · Closed · Mar 29, 1968 · N5631P · Substantial damage
- [NTSB CHI68F0693](https://openairdocs.org/ntsb/CHI68F0693.md): Piper PA-28 · Campbellsville, KY · Accident · No injuries · Closed · Mar 28, 1968 · N5846W · Substantial damage
- [NTSB DCA68A0004](https://openairdocs.org/ntsb/DCA68A0004.md): Douglas DC-9 · St Louis, MO · Accident · 2 fatal · Closed · Mar 27, 1968 · N970Z · 2 aircraft · Substantial damage
- [NTSB FTW68F0489](https://openairdocs.org/ntsb/FTW68F0489.md): Mooney M20A · Garland, TX · Accident · Minor injuries · Closed · Mar 26, 1968 · N1069C · Substantial damage
- [NTSB DEN68F0241](https://openairdocs.org/ntsb/DEN68F0241.md): Beech A23 · Albuquerque, NM · Accident · Minor injuries · Closed · Mar 26, 1968 · N6912Q · Substantial damage
- [NTSB ANC68D0105](https://openairdocs.org/ntsb/ANC68D0105.md): Cessna 172 · Fort Yukon, AK · Accident · No injuries · Closed · Mar 26, 1968 · N3562S · Substantial damage
- [NTSB NYC68A0112](https://openairdocs.org/ntsb/NYC68A0112.md): Beech 95-B55 · Windsor Lock, CT · Accident · 1 fatal · Closed · Mar 25, 1968 · N3030Q · Destroyed
- [NTSB SEA68A0060](https://openairdocs.org/ntsb/SEA68A0060.md): Cessna 172 · Puyallup, WA · Accident · 4 fatal · Closed · Mar 24, 1968 · N6069A · 2 aircraft · Destroyed
- [NTSB FTW68F0522](https://openairdocs.org/ntsb/FTW68F0522.md): Piper PA-30 · San Marcos, TX · Accident · No injuries · Closed · Mar 24, 1968 · N7673Y · Substantial damage
- [NTSB MKC68D0518](https://openairdocs.org/ntsb/MKC68D0518.md): Cessna 172 · Chariton, IA · Accident · No injuries · Closed · Mar 23, 1968 · N1647Y · Substantial damage
- [NTSB LAX68D0362](https://openairdocs.org/ntsb/LAX68D0362.md): Champion 7ECA · Wittman, AZ · Accident · Minor injuries · Closed · Mar 23, 1968 · N9545S · Substantial damage

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

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

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