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

## Cases, newest first

- [NTSB MIA69F0346](https://openairdocs.org/ntsb/MIA69F0346.md): Beech G17S · Southhaven, MS · Accident · Minor injuries · Closed · Feb 3, 1969 · N4710V · Substantial damage
- [NTSB MIA69D0368](https://openairdocs.org/ntsb/MIA69D0368.md): Piper PA-28 · Lacosta Is, FL · Accident · No injuries · Closed · Feb 2, 1969 · N9402J · Substantial damage
- [NTSB MIA69D0365](https://openairdocs.org/ntsb/MIA69D0365.md): Cessna 177 · Vero Beach, FL · Accident · No injuries · Closed · Feb 1, 1969 · N261TS · Substantial damage
- [NTSB MIA69F0348](https://openairdocs.org/ntsb/MIA69F0348.md): Cessna 150H · Kendall, FL · Accident · No injuries · Closed · Jan 31, 1969 · N7246S · Substantial damage
- [NTSB MIA69F0330](https://openairdocs.org/ntsb/MIA69F0330.md): Twin Navion D-16A · Cookeville, TN · Accident · No injuries · Closed · Jan 31, 1969 · N717F · Substantial damage
- [NTSB FTW69F0396](https://openairdocs.org/ntsb/FTW69F0396.md): Beech E35 · Tomball, TX · Accident · Serious injuries · Closed · Jan 31, 1969 · N7373B · Substantial damage
- [NTSB MIA69A0043](https://openairdocs.org/ntsb/MIA69A0043.md): Beech 99 · Orlando, FL · Accident · No injuries · Closed · Jan 30, 1969 · N851SA · Substantial damage
- [NTSB DEN69D0218](https://openairdocs.org/ntsb/DEN69D0218.md): Cessna 172 · Yuma, CO · Accident · Minor injuries · Closed · Jan 30, 1969 · N46052 · Substantial damage
- [NTSB DEN69D0202](https://openairdocs.org/ntsb/DEN69D0202.md): Cessna 172 · Ft.Carson, CO · Accident · No injuries · Closed · Jan 30, 1969 · N46482 · Substantial damage
- [NTSB NYC69D0329](https://openairdocs.org/ntsb/NYC69D0329.md): Beech G35 · Millville, NJ · Accident · No injuries · Closed · Jan 27, 1969 · N46190 · Substantial damage
- [NTSB MKC69D0355](https://openairdocs.org/ntsb/MKC69D0355-201666.md): Aero Comdr 680-FL · Kansas City, MO · Accident · No injuries · Closed · Jan 27, 1969 · N290MP · Substantial damage
- [NTSB CHI69F0446](https://openairdocs.org/ntsb/CHI69F0446.md): Piper PA-23 · London, OH · Accident · No injuries · Closed · Jan 27, 1969 · N2005P · Substantial damage
- [NTSB MIA69A0042](https://openairdocs.org/ntsb/MIA69A0042.md): Cessna 150G · Pahokee, FL · Accident · 1 fatal · Closed · Jan 25, 1969 · N2983S · Destroyed
- [NTSB NYC69A0076](https://openairdocs.org/ntsb/NYC69A0076.md): Piper PA-24 · New Holland, PA · Accident · 2 fatal · Closed · Jan 24, 1969 · N110KS · Destroyed
- [NTSB MKC69D0351](https://openairdocs.org/ntsb/MKC69D0351.md): Cessna 150 · Rantoul, KS · Accident · Minor injuries · Closed · Jan 24, 1969 · N2877S · Substantial damage
- [NTSB FTW69F0383](https://openairdocs.org/ntsb/FTW69F0383.md): Ercoupe 415-C · Jenks, OK · Accident · Serious injuries · Closed · Jan 23, 1969 · N2208H · Substantial damage
- [NTSB FTW69D0371](https://openairdocs.org/ntsb/FTW69D0371.md): Cessna 182A · Denison, TX · Accident · No injuries · Closed · Jan 22, 1969 · N3953D · Substantial damage
- [NTSB DCA69I0001](https://openairdocs.org/ntsb/DCA69I0001.md): Fairchild FH-227 · Springfield, IL · Incident · No injuries · Closed · Jan 22, 1969 · N4224 · Minor damage
- [NTSB MKC69F0342](https://openairdocs.org/ntsb/MKC69F0342.md): Cessna 310P · Lincoln, NE · Accident · Serious injuries · Closed · Jan 20, 1969 · N5748M · Destroyed
- [NTSB DEN69D0160](https://openairdocs.org/ntsb/DEN69D0160.md): Piper PA-28 · Provo, UT · Accident · No injuries · Closed · Jan 20, 1969 · N5794F · Substantial damage
- [NTSB CHI69F0444](https://openairdocs.org/ntsb/CHI69F0444.md): Cessna 150E · Pewaukee, WI · Accident · No injuries · Closed · Jan 20, 1969 · N6221T · Substantial damage
- [NTSB NYC69F0306](https://openairdocs.org/ntsb/NYC69F0306.md): Piper PA-28 · Mendon, MA · Accident · No injuries · Closed · Jan 19, 1969 · N8124W · Substantial damage
- [NTSB FTW69F0374](https://openairdocs.org/ntsb/FTW69F0374.md): Beech 95-C55 · Lubbock, TX · Accident · Minor injuries · Closed · Jan 19, 1969 · N521U · Substantial damage
- [NTSB DIA69F0131](https://openairdocs.org/ntsb/DIA69F0131.md): Piper PA-23 · Carrboro, NC · Accident · No injuries · Closed · Jan 19, 1969 · N1432P · Substantial damage
- [NTSB OAK69A0045](https://openairdocs.org/ntsb/OAK69A0045.md): Piper PA-23 · Sparks, NV · Accident · 1 fatal · Closed · Jan 18, 1969 · N6055Y · Destroyed
- [NTSB NYC69F0296](https://openairdocs.org/ntsb/NYC69F0296.md): Piper PA-23 · Clarence, NY · Accident · No injuries · Closed · Jan 18, 1969 · N3306P · Substantial damage
- [NTSB FTW69D0367](https://openairdocs.org/ntsb/FTW69D0367.md): Piper PA-22 · Abilene, TX · Accident · No injuries · Closed · Jan 18, 1969 · N7728D · Substantial damage
- [NTSB MKC69D0325](https://openairdocs.org/ntsb/MKC69D0325.md): Aeronca 7AC · Clitherall, MN · Accident · No injuries · Closed · Jan 17, 1969 · N3340E · Substantial damage
- [NTSB DIA69D0140](https://openairdocs.org/ntsb/DIA69D0140.md): Cessna 150 · Norfolk, VA · Accident · No injuries · Closed · Jan 16, 1969 · N2604J · Substantial damage
- [NTSB DEN69F0170](https://openairdocs.org/ntsb/DEN69F0170.md): Cessna 172 · Ogden, UT · Accident · Minor injuries · Closed · Jan 16, 1969 · N7978B · Substantial damage
- [NTSB MKC69F0340](https://openairdocs.org/ntsb/MKC69F0340.md): Piper PA-24 · Great Bend, KS · Accident · No injuries · Closed · Jan 15, 1969 · N9184P · Substantial damage
- [NTSB LAX69F0241](https://openairdocs.org/ntsb/LAX69F0241.md): Piper PA-23 · Hawthorne, CA · Accident · Serious injuries · Closed · Jan 15, 1969 · N3313P · Destroyed
- [NTSB FTW69A0047](https://openairdocs.org/ntsb/FTW69A0047.md): Beech C-45H · Midland, TX · Accident · No injuries · Closed · Jan 14, 1969 · N9570Z · Substantial damage
- [NTSB DEN69F0169](https://openairdocs.org/ntsb/DEN69F0169.md): Piper J3C-65 · Silver City, NM · Accident · Serious injuries · Closed · Jan 13, 1969 · N98882 · Substantial damage
- [NTSB DCA69A0012](https://openairdocs.org/ntsb/DCA69A0012.md): Douglas DC-8 · Los Angeles (Pacific Ocean) · Accident · 15 fatal · Closed · Jan 13, 1969 · LN-M00 · Destroyed
- [NTSB OAK69F0233](https://openairdocs.org/ntsb/OAK69F0233.md): Cessna 320 · Nut Tree, CA · Accident · No injuries · Closed · Jan 12, 1969 · N9821L · Substantial damage
- [NTSB OAK69D0222](https://openairdocs.org/ntsb/OAK69D0222.md): Piper PA-28 · Tracy, CA · Accident · No injuries · Closed · Jan 12, 1969 · N7228J · Substantial damage
- [NTSB MKC69D0328](https://openairdocs.org/ntsb/MKC69D0328.md): Piper PA-18A · Callaway, NE · Accident · No injuries · Closed · Jan 12, 1969 · N1993A · Substantial damage
- [NTSB FTW69D0395](https://openairdocs.org/ntsb/FTW69D0395.md): Cessna 172 · Dougherty, TX · Accident · No injuries · Closed · Jan 12, 1969 · N1454F · Substantial damage
- [NTSB CHI69F0428](https://openairdocs.org/ntsb/CHI69F0428.md): Cessna 310L · Ann Arbor, MI · Accident · No injuries · Closed · Jan 12, 1969 · N2215F · Substantial damage
- [NTSB DIA69D0130](https://openairdocs.org/ntsb/DIA69D0130.md): Piper PA-28R · Wilmington, DE · Accident · No injuries · Closed · Jan 11, 1969 · N3879T · Substantial damage
- [NTSB CHI70D0019](https://openairdocs.org/ntsb/CHI70D0019.md): Piper PA-28 · Pinckneyville, IL · Accident · No injuries · Closed · Jan 11, 1969 · N7703W · Substantial damage
- [NTSB DEN69D0234](https://openairdocs.org/ntsb/DEN69D0234.md): Piper PA-23 · Greeley, CO · Accident · No injuries · Closed · Jan 10, 1969 · N1034P · Substantial damage
- [NTSB MKC69D0313](https://openairdocs.org/ntsb/MKC69D0313.md): Piper PA-28 · Lakeville, MN · Accident · No injuries · Closed · Jan 6, 1969 · N7450W · Substantial damage
- [NTSB DCA69A0011](https://openairdocs.org/ntsb/DCA69A0011.md): Convair 440 · Bradford, PA · Accident · 11 fatal · Closed · Jan 6, 1969 · N5825 · Destroyed
- [NTSB CHI69F0412](https://openairdocs.org/ntsb/CHI69F0412.md): Beech N35 · Columbus, OH · Accident · Minor injuries · Closed · Jan 6, 1969 · N1297Z · Destroyed
- [NTSB NYC69D0288](https://openairdocs.org/ntsb/NYC69D0288.md): Beech 23-19 · Hudson, NY · Accident · No injuries · Closed · Jan 5, 1969 · N2375W · Substantial damage
- [NTSB MKC69D0301](https://openairdocs.org/ntsb/MKC69D0301.md): Piper PA-28 · Ellsworth, KS · Accident · No injuries · Closed · Jan 5, 1969 · N8169W · Substantial damage
- [NTSB LAX69D0238](https://openairdocs.org/ntsb/LAX69D0238.md): Stinson 108-3 · Mortmar, CA · Accident · Minor injuries · Closed · Jan 4, 1969 · N6902M · Substantial damage
- [NTSB DIA69F0121](https://openairdocs.org/ntsb/DIA69F0121.md): Mooney M20A · Walnut Cove, NC · Accident · No injuries · Closed · Jan 4, 1969 · N8158E · Substantial damage

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

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

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