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

## Cases, newest first

- [NTSB MIA69F0263](https://openairdocs.org/ntsb/MIA69F0263.md): Piper PA-24 · Lawrenceburg, TN · Accident · Serious injuries · Closed · Nov 25, 1968 · N5781P · Destroyed
- [NTSB FTW69F0296](https://openairdocs.org/ntsb/FTW69F0296.md): Cessna 150E · El Paso, TX · Accident · No injuries · Closed · Nov 25, 1968 · N6228R · Substantial damage
- [NTSB CHI69F0381](https://openairdocs.org/ntsb/CHI69F0381.md): Cessna 172 · Shelbyville, IN · Accident · No injuries · Closed · Nov 25, 1968 · N7238A · Destroyed
- [NTSB MKC69F0271](https://openairdocs.org/ntsb/MKC69F0271.md): Beech A23A · Wichita, KS · Accident · No injuries · Closed · Nov 24, 1968 · N6942Q · Substantial damage
- [NTSB MKC69F0270](https://openairdocs.org/ntsb/MKC69F0270.md): Aeronca 65-TAL · Houston, MO · Accident · Serious injuries · Closed · Nov 24, 1968 · N31354 · Destroyed
- [NTSB LAX69O0211](https://openairdocs.org/ntsb/LAX69O0211.md): Beech D35 · Navajoa, Mexico · Accident · No injuries · Closed · Nov 24, 1968 · N3700N · Substantial damage
- [NTSB LAX69D0188](https://openairdocs.org/ntsb/LAX69D0188.md): Piper PA-22 · Bermuda Dunes, CA · Accident · Minor injuries · Closed · Nov 24, 1968 · N9616D · Substantial damage
- [NTSB CHI69F0409](https://openairdocs.org/ntsb/CHI69F0409.md): Piper PA-28 · Sturtevant, WI · Accident · Minor injuries · Closed · Nov 24, 1968 · N4217T · Substantial damage
- [NTSB CHI69F0377](https://openairdocs.org/ntsb/CHI69F0377.md): Piper PA-28 · Tecumseh, MI · Accident · No injuries · Closed · Nov 24, 1968 · N7493J · Substantial damage
- [NTSB CHI69F0355](https://openairdocs.org/ntsb/CHI69F0355.md): Cessna 172C · Plain City, OH · Accident · No injuries · Closed · Nov 24, 1968 · N1584Y · Substantial damage
- [NTSB MKC69F0282](https://openairdocs.org/ntsb/MKC69F0282.md): Mooney M20C · Festus, MO · Accident · Minor injuries · Closed · Nov 23, 1968 · N7192U · Destroyed
- [NTSB MIA69F0279](https://openairdocs.org/ntsb/MIA69F0279.md): Cessna 150F · West Hollywod, FL · Accident · No injuries · Closed · Nov 23, 1968 · N3081X · Substantial damage
- [NTSB LAX69A0028](https://openairdocs.org/ntsb/LAX69A0028.md): Dehavilland DHC-6 · Santa Ana, CA · Accident · 9 fatal · Closed · Nov 23, 1968 · N7666 · Destroyed
- [NTSB CHI69D0397](https://openairdocs.org/ntsb/CHI69D0397.md): Beech A23 · Chicago, IL · Accident · No injuries · Closed · Nov 23, 1968 · N1406L · Substantial damage
- [NTSB OAK69F0175](https://openairdocs.org/ntsb/OAK69F0175.md): Champion 7GCB · Reno, NV · Accident · Minor injuries · Closed · Nov 22, 1968 · N9935Y · Substantial damage
- [NTSB MIA69F0261](https://openairdocs.org/ntsb/MIA69F0261.md): Aeronca 65-TAC · Lafayette, TN · Accident · Serious injuries · Closed · Nov 22, 1968 · N46605 · Destroyed
- [NTSB MIA69D0278](https://openairdocs.org/ntsb/MIA69D0278.md): Aero Comdr 560-E · Miami, FL · Accident · Minor injuries · Closed · Nov 22, 1968 · N2788B · Substantial damage
- [NTSB DCA69A0005](https://openairdocs.org/ntsb/DCA69A0005.md): Douglas DC-8 · S.Francisco, CA · Accident · No injuries · Closed · Nov 22, 1968 · JA8032 · Substantial damage
- [NTSB FTW69F0305](https://openairdocs.org/ntsb/FTW69F0305.md): Champion 7FC · Jones, LA · Accident · Serious injuries · Closed · Nov 21, 1968 · N9001B · Destroyed
- [NTSB FTW69A0034](https://openairdocs.org/ntsb/FTW69A0034.md): Piper PA-31 · Nederland, TX · Accident · 5 fatal · Closed · Nov 20, 1968 · N9174Y · Destroyed
- [NTSB CHI69D0402](https://openairdocs.org/ntsb/CHI69D0402.md): Piper PA-28 · Northbrook, IL · Accident · No injuries · Closed · Nov 20, 1968 · N9963W · Substantial damage
- [NTSB NYC69A0056](https://openairdocs.org/ntsb/NYC69A0056.md): Beech 65 · Latham, NY · Accident · 2 fatal · Closed · Nov 18, 1968 · N1401M · Destroyed
- [NTSB DIA69A0025](https://openairdocs.org/ntsb/DIA69A0025.md): Piper PA-23 · Charlottesvlle, VA · Accident · 1 fatal · Closed · Nov 18, 1968 · N5943Y · Destroyed
- [NTSB CHI69A0054](https://openairdocs.org/ntsb/CHI69A0054.md): Cessna 320E · Pontiac, MI · Accident · 1 fatal · Closed · Nov 17, 1968 · N3436Q · Destroyed
- [NTSB LAX69D0195](https://openairdocs.org/ntsb/LAX69D0195.md): Cessna 150 · Long Beach, CA · Accident · No injuries · Closed · Nov 16, 1968 · N8222S · Substantial damage
- [NTSB FTW69D0303](https://openairdocs.org/ntsb/FTW69D0303.md): Piper PA-24 · Friona, TX · Accident · No injuries · Closed · Nov 16, 1968 · N8990P · Substantial damage
- [NTSB MIA69D0306](https://openairdocs.org/ntsb/MIA69D0306.md): Piper PA-28 · Clemson, SC · Accident · Minor injuries · Closed · Nov 15, 1968 · N5110L · Substantial damage
- [NTSB CHI69F0359](https://openairdocs.org/ntsb/CHI69F0359.md): Maule M-4210 · Clarkston, MI · Accident · No injuries · Closed · Nov 15, 1968 · N2014U · Substantial damage
- [NTSB CHI69A0050](https://openairdocs.org/ntsb/CHI69A0050.md): Cessna 150 · Frankfort, IL · Accident · 2 fatal · Closed · Nov 15, 1968 · N22532 · Destroyed
- [NTSB LAX69D0203](https://openairdocs.org/ntsb/LAX69D0203.md): Bell 206A · Long Beach, CA · Accident · No injuries · Closed · Nov 12, 1968 · N696MR · Substantial damage
- [NTSB MIA69F0328](https://openairdocs.org/ntsb/MIA69F0328.md): Piper PA-16 · Bartow, FL · Accident · Serious injuries · Closed · Nov 8, 1968 · N5950H · Destroyed
- [NTSB CHI69F0344](https://openairdocs.org/ntsb/CHI69F0344.md): Piper PA-22 · Darby Dale, OH · Accident · Serious injuries · Closed · Nov 8, 1968 · N8895C · Substantial damage
- [NTSB NYC69A0052](https://openairdocs.org/ntsb/NYC69A0052.md): Cessna 402 · Allentown, PA · Accident · 1 fatal · Closed · Nov 7, 1968 · N8419F · Destroyed
- [NTSB CHI69F0343](https://openairdocs.org/ntsb/CHI69F0343.md): Cessna 150 · Plymouth, MI · Accident · No injuries · Closed · Nov 7, 1968 · N50005 · Substantial damage
- [NTSB CHI69A0047](https://openairdocs.org/ntsb/CHI69A0047.md): Cessna 150H · Mattoon, IL · Accident · 2 fatal · Closed · Nov 7, 1968 · N6519S · Destroyed
- [NTSB LAX69D0192](https://openairdocs.org/ntsb/LAX69D0192.md): Piper PA-18 · Benson, AZ · Accident · No injuries · Closed · Nov 6, 1968 · N4129Z · Substantial damage
- [NTSB DIA69F0106](https://openairdocs.org/ntsb/DIA69F0106.md): Cessna 177 · Louisburg, NC · Accident · No injuries · Closed · Nov 6, 1968 · N2271Y · Substantial damage
- [NTSB NYC69F0268](https://openairdocs.org/ntsb/NYC69F0268.md): Piper PA-22 · Phippsburg, ME · Accident · Serious injuries · Closed · Nov 3, 1968 · N5042Z · Substantial damage
- [NTSB MKC69F0263](https://openairdocs.org/ntsb/MKC69F0263.md): Cessna 150F · Mobridge, SD · Accident · Minor injuries · Closed · Oct 31, 1968 · N8225S · Substantial damage
- [NTSB NYC69F0252](https://openairdocs.org/ntsb/NYC69F0252.md): Piper PA-28 · Glastonbury, CT · Accident · Serious injuries · Closed · Oct 30, 1968 · N3728K · Substantial damage
- [NTSB OAK69D0161](https://openairdocs.org/ntsb/OAK69D0161.md): Cessna 150 · Visalia, CA · Accident · Minor injuries · Closed · Oct 29, 1968 · N7945F · Destroyed
- [NTSB MKC69D0245](https://openairdocs.org/ntsb/MKC69D0245.md): Stinson 108-2 · Sharon Sprgs, KS · Accident · No injuries · Closed · Oct 29, 1968 · N9807K · Substantial damage
- [NTSB OAK69D0166](https://openairdocs.org/ntsb/OAK69D0166.md): Piper PA-22 · Ukiah, CA · Accident · No injuries · Closed · Oct 27, 1968 · N2824Z · Substantial damage
- [NTSB DIA69F0109](https://openairdocs.org/ntsb/DIA69F0109.md): Piper PA-28 · Fredericksburg, VA · Accident · No injuries · Closed · Oct 27, 1968 · N424AS · Substantial damage
- [NTSB OAK69O0010](https://openairdocs.org/ntsb/OAK69O0010.md): Beech A23 · Sangley Pt, RP · Accident · No injuries · Closed · Oct 26, 1968 · N4927 · Substantial damage
- [NTSB MKC69F0324](https://openairdocs.org/ntsb/MKC69F0324.md): Piper PA-24 · Kansas City, MO · Accident · Serious injuries · Closed · Oct 26, 1968 · N8418P · Substantial damage
- [NTSB FTW69F0274](https://openairdocs.org/ntsb/FTW69F0274.md): Cessna 177 · Tulsa, OK · Accident · No injuries · Closed · Oct 26, 1968 · N3318T · Substantial damage
- [NTSB CHI69F0365](https://openairdocs.org/ntsb/CHI69F0365.md): Piper PA-28 · Waukegan, IL · Accident · Serious injuries · Closed · Oct 26, 1968 · N6898W · Destroyed
- [NTSB CHI69D0351](https://openairdocs.org/ntsb/CHI69D0351.md): Cessna 150 · Lockport, IL · Accident · No injuries · Closed · Oct 26, 1968 · N23019 · Substantial damage
- [NTSB CHI69D0323](https://openairdocs.org/ntsb/CHI69D0323.md): Maule M-4 · Midway, KY · Accident · No injuries · Closed · Oct 26, 1968 · N9826M · Substantial damage

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

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

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