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

## Cases, newest first

- [NTSB FTW68D0450](https://openairdocs.org/ntsb/FTW68D0450.md): Cessna 150F · Floydada, TX · Accident · No injuries · Closed · Feb 10, 1968 · N8448G · Substantial damage
- [NTSB MIA68F0398](https://openairdocs.org/ntsb/MIA68F0398.md): Piper PA-24 · Millington, TN · Accident · No injuries · Closed · Feb 9, 1968 · N6284P · Substantial damage
- [NTSB CHI68F0660](https://openairdocs.org/ntsb/CHI68F0660.md): Cessna 182C · River, KY · Accident · No injuries · Closed · Feb 9, 1968 · N2657G · Substantial damage
- [NTSB FTW68F0440](https://openairdocs.org/ntsb/FTW68F0440.md): Bellanca 17-30 · Fort Worth, TX · Accident · No injuries · Closed · Feb 8, 1968 · N6659V · Substantial damage
- [NTSB DIA68F0163](https://openairdocs.org/ntsb/DIA68F0163.md): Piper PA-24 · Crisfield, MD · Accident · No injuries · Closed · Feb 6, 1968 · N7009P · Substantial damage
- [NTSB CHI68F0572](https://openairdocs.org/ntsb/CHI68F0572.md): Cessna 150F · Junction City, KY · Accident · Minor injuries · Closed · Feb 6, 1968 · N3581L · Destroyed
- [NTSB CHI68D0584](https://openairdocs.org/ntsb/CHI68D0584.md): Beech A23 · Milwaukee, WI · Accident · Minor injuries · Closed · Feb 5, 1968 · N4733J · Destroyed
- [NTSB UNK68X0121](https://openairdocs.org/ntsb/UNK68X0121.md): Piper PA-28 · Reynosa, Mexico · Accident · No injuries · Closed · Feb 4, 1968 · N6984W · Substantial damage
- [NTSB SEA68F0251](https://openairdocs.org/ntsb/SEA68F0251.md): Cessna 150 · Anacortes, WA · Accident · No injuries · Closed · Feb 4, 1968 · N6035T · Substantial damage
- [NTSB NYC68F0362](https://openairdocs.org/ntsb/NYC68F0362.md): Erco 415-C · Holland, NY · Accident · Serious injuries · Closed · Feb 4, 1968 · N2680H · Substantial damage
- [NTSB NYC68D0381](https://openairdocs.org/ntsb/NYC68D0381.md): Piper PA-23 · Agawam, MA · Accident · No injuries · Closed · Feb 4, 1968 · N3263P · Substantial damage
- [NTSB FTW68D0479](https://openairdocs.org/ntsb/FTW68D0479.md): Cessna 172 · New Braunfels, TX · Accident · No injuries · Closed · Feb 4, 1968 · N6278E · Substantial damage
- [NTSB CHI68A0069](https://openairdocs.org/ntsb/CHI68A0069.md): Cessna 150 · Salem, OH · Accident · 1 fatal · Closed · Feb 4, 1968 · N8277S · Destroyed
- [NTSB LAX68D0301](https://openairdocs.org/ntsb/LAX68D0301.md): Cessna 150 · Santee, CA · Accident · No injuries · Closed · Feb 3, 1968 · N8150S · Substantial damage
- [NTSB MKC68F0449](https://openairdocs.org/ntsb/MKC68F0449.md): Cessna 150 · Kansas City, KS · Accident · Minor injuries · Closed · Feb 2, 1968 · N6738F · Substantial damage
- [NTSB CHI68I0066](https://openairdocs.org/ntsb/CHI68I0066.md): Convair 880 · Chicago, IL · Incident · No injuries · Closed · Jan 31, 1968 · N810TW · Minor damage
- [NTSB MKC68D0439](https://openairdocs.org/ntsb/MKC68D0439.md): Cessna 150G · Dubuque, IA · Accident · Minor injuries · Closed · Jan 30, 1968 · N3954J · Substantial damage
- [NTSB LAX68D0333](https://openairdocs.org/ntsb/LAX68D0333.md): Champion 7ECA · Phoenix, AZ · Accident · Minor injuries · Closed · Jan 30, 1968 · N5199T · Substantial damage
- [NTSB LAX68F0323](https://openairdocs.org/ntsb/LAX68F0323.md): Cessna 172 · Yuma, AZ · Accident · No injuries · Closed · Jan 28, 1968 · N3900L · Substantial damage
- [NTSB DEN68D0206](https://openairdocs.org/ntsb/DEN68D0206.md): Piper PA-28 · Portales, NM · Accident · No injuries · Closed · Jan 28, 1968 · N8545W · Substantial damage
- [NTSB CHI68A0065](https://openairdocs.org/ntsb/CHI68A0065.md): Convair 440 · Benton Harbr, MI · Accident · Minor injuries · Closed · Jan 28, 1968 · N2041 · Substantial damage
- [NTSB FTW68F0436](https://openairdocs.org/ntsb/FTW68F0436.md): Luscombe 8A · Waco, TX · Accident · No injuries · Closed · Jan 27, 1968 · N45670 · Substantial damage
- [NTSB LAX68D0324](https://openairdocs.org/ntsb/LAX68D0324.md): Cessna 210 · Bowie, AZ · Accident · No injuries · Closed · Jan 25, 1968 · N4964U · Substantial damage
- [NTSB SEA68A0050](https://openairdocs.org/ntsb/SEA68A0050.md): Bell 47G-3B · Superior, MT · Accident · No injuries · Closed · Jan 24, 1968 · N73269 · Substantial damage
- [NTSB MKC68D0413](https://openairdocs.org/ntsb/MKC68D0413.md): Cessna 150 · Smith Center, KS · Accident · No injuries · Closed · Jan 24, 1968 · N6658F · Substantial damage
- [NTSB LAX68D0307](https://openairdocs.org/ntsb/LAX68D0307.md): Cessna 172 · Blythe, CA · Accident · Minor injuries · Closed · Jan 24, 1968 · N7174A · Substantial damage
- [NTSB NYC68F0348](https://openairdocs.org/ntsb/NYC68F0348.md): Cessna 310 · Erie, PA · Accident · No injuries · Closed · Jan 23, 1968 · N3095D · Substantial damage
- [NTSB MKC68O0005](https://openairdocs.org/ntsb/MKC68O0005.md): Champion 7ECA · Rudge Lk.Ont, Canada · Accident · No injuries · Closed · Jan 21, 1968 · N9674S · Destroyed
- [NTSB LAX68F0283](https://openairdocs.org/ntsb/LAX68F0283.md): Schweizer SGS232 · Boulevard, CA · Accident · Minor injuries · Closed · Jan 21, 1968 · N9902J · Substantial damage
- [NTSB NYC68D0377](https://openairdocs.org/ntsb/NYC68D0377.md): Cessna 140 · Middletown, NY · Accident · No injuries · Closed · Jan 20, 1968 · N89123 · Substantial damage
- [NTSB CHI68F0577](https://openairdocs.org/ntsb/CHI68F0577.md): Piper PA-22 · Columbus, OH · Accident · No injuries · Closed · Jan 20, 1968 · N4677Z · Substantial damage
- [NTSB CHI68D0617](https://openairdocs.org/ntsb/CHI68D0617.md): Cessna 150 · No.Lima, OH · Accident · No injuries · Closed · Jan 20, 1968 · N4541U · Substantial damage
- [NTSB MIA68D0400](https://openairdocs.org/ntsb/MIA68D0400.md): Cessna 150 · Miami, FL · Accident · No injuries · Closed · Jan 19, 1968 · N3940J · 2 aircraft · Substantial damage
- [NTSB CHI68F0537](https://openairdocs.org/ntsb/CHI68F0537.md): Ryan ST-3KR · Bardstown, KY · Accident · Serious injuries · Closed · Jan 18, 1968 · N25510 · Destroyed
- [NTSB LAX68F0304](https://openairdocs.org/ntsb/LAX68F0304.md): Cessna 150 · El Cajon, CA · Accident · Serious injuries · Closed · Jan 17, 1968 · N8626S · Destroyed
- [NTSB FTW68F0413](https://openairdocs.org/ntsb/FTW68F0413.md): Piper PA-28 · Slidell, LA · Accident · Serious injuries · Closed · Jan 17, 1968 · N6312R · Destroyed
- [NTSB CHI68F0545](https://openairdocs.org/ntsb/CHI68F0545-112197.md): Piper PA-22 · Lexington, KY · Accident · No injuries · Closed · Jan 16, 1968 · N5927Z · Substantial damage
- [NTSB LAX68D0285](https://openairdocs.org/ntsb/LAX68D0285.md): Cessna 172 · El Centro, CA · Accident · No injuries · Closed · Jan 14, 1968 · N8256L · Substantial damage
- [NTSB DIA68D0148](https://openairdocs.org/ntsb/DIA68D0148.md): Luscombe 8A · Newport News, VA · Accident · No injuries · Closed · Jan 14, 1968 · N1112K · Substantial damage
- [NTSB NYC68F0340](https://openairdocs.org/ntsb/NYC68F0340.md): Cessna 172H · Deer Park, NY · Accident · No injuries · Closed · Jan 13, 1968 · N3281L · Substantial damage
- [NTSB LAX68D0287](https://openairdocs.org/ntsb/LAX68D0287.md): Cessna 172 · Rubidoux, CA · Accident · Minor injuries · Closed · Jan 13, 1968 · N9124B · Destroyed
- [NTSB NYC68F0335](https://openairdocs.org/ntsb/NYC68F0335.md): Beech H18 · Norwich, NY · Accident · No injuries · Closed · Jan 12, 1968 · N909T · Destroyed
- [NTSB CHI68F0528](https://openairdocs.org/ntsb/CHI68F0528.md): Piper PA-28 · Westphalia, MI · Accident · Minor injuries · Closed · Jan 11, 1968 · N6402R · Substantial damage
- [NTSB CHI68F0546](https://openairdocs.org/ntsb/CHI68F0546.md): Cessna 411A · Elkhart, IN · Accident · Minor injuries · Closed · Jan 10, 1968 · N3254R · Substantial damage
- [NTSB OAK68D0250](https://openairdocs.org/ntsb/OAK68D0250.md): Piper PA-28 · Concord, CA · Accident · No injuries · Closed · Jan 5, 1968 · N9453J · Substantial damage
- [NTSB MIA68D0373](https://openairdocs.org/ntsb/MIA68D0373.md): Bellanca 17-30 · Lake Wales, FL · Accident · No injuries · Closed · Jan 5, 1968 · N4757V · Substantial damage
- [NTSB OAK68D0251](https://openairdocs.org/ntsb/OAK68D0251.md): Cessna 150 · Garberville, CA · Accident · No injuries · Closed · Jan 3, 1968 · N4725X · Substantial damage
- [NTSB MIA68F0352](https://openairdocs.org/ntsb/MIA68F0352.md): Piper PA-28 · Mayaguez, PR · Accident · Minor injuries · Closed · Jan 3, 1968 · N9447J · Substantial damage
- [NTSB FTW68A0068](https://openairdocs.org/ntsb/FTW68A0068.md): Douglas DC-6B · New Orleans, LA · Accident · No injuries · Closed · Jan 3, 1968 · HR-SAO · Substantial damage
- [NTSB MIA68A0060](https://openairdocs.org/ntsb/MIA68A0060.md): Martin 404 · Oxford Miss, MS · Accident · No injuries · Closed · Jan 1, 1968 · N251S · Destroyed

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

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

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