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

## Cases, newest first

- [NTSB CHI67F0628](https://openairdocs.org/ntsb/CHI67F0628.md): Cessna 182 · Mishawaka, IN · Accident · No injuries · Closed · May 1, 1967 · N3368U · Substantial damage
- [NTSB NYC67F0657](https://openairdocs.org/ntsb/NYC67F0657.md): Cessna 150F · Shirley, MA · Accident · Minor injuries · Closed · Apr 30, 1967 · N8948S · Destroyed
- [NTSB NYC67A0151](https://openairdocs.org/ntsb/NYC67A0151.md): Piper PA-23 · Hershey, PA · Accident · 2 fatal · Closed · Apr 30, 1967 · N8888 · Destroyed
- [NTSB MIA67D0518](https://openairdocs.org/ntsb/MIA67D0518.md): Cessna 150G · Cullman, AL · Accident · Minor injuries · Closed · Apr 30, 1967 · N2226J · Destroyed
- [NTSB NYC67D0699](https://openairdocs.org/ntsb/NYC67D0699.md): Cessna 150 · Sewell, NJ · Accident · No injuries · Closed · Apr 29, 1967 · N3976J · Substantial damage
- [NTSB NYC67D0636](https://openairdocs.org/ntsb/NYC67D0636.md): Piper PA-28 · Northampton, MA · Accident · No injuries · Closed · Apr 29, 1967 · N7916W · Substantial damage
- [NTSB MKC67D0579](https://openairdocs.org/ntsb/MKC67D0579.md): Aeronca 7AC · Dodge City, KS · Accident · No injuries · Closed · Apr 29, 1967 · N84506 · Substantial damage
- [NTSB MKC67D0520](https://openairdocs.org/ntsb/MKC67D0520.md): Cessna 172H · Louisville, NE · Accident · No injuries · Closed · Apr 29, 1967 · N2561L · Substantial damage
- [NTSB NYC67A0148](https://openairdocs.org/ntsb/NYC67A0148.md): Cessna 310 · Indiana, PA · Accident · 2 fatal · Closed · Apr 26, 1967 · N5217A · Destroyed
- [NTSB CHI67F0677](https://openairdocs.org/ntsb/CHI67F0677.md): Cessna 172G · Edmonton, KY · Accident · No injuries · Closed · Apr 26, 1967 · N3609L · Substantial damage
- [NTSB SEA68F0049](https://openairdocs.org/ntsb/SEA68F0049.md): Piper PA-23 · Hoquiam, WA · Accident · Serious injuries · Closed · Apr 25, 1967 · N2205P · Substantial damage
- [NTSB MKC68D0061](https://openairdocs.org/ntsb/MKC68D0061.md): Cessna 140 · Harvey, ND · Accident · No injuries · Closed · Apr 25, 1967 · N2063V · Substantial damage
- [NTSB MKC67D0526](https://openairdocs.org/ntsb/MKC67D0526.md): Piper PA-28 · Des Moines, IA · Accident · No injuries · Closed · Apr 25, 1967 · N4266J · Substantial damage
- [NTSB MIA67A0112](https://openairdocs.org/ntsb/MIA67A0112.md): Convair 640D · San Juan, PR · Accident · Minor injuries · Closed · Apr 25, 1967 · N3420 · Substantial damage
- [NTSB SEA67F0343](https://openairdocs.org/ntsb/SEA67F0343.md): Cessna 172F · Beaverton, OR · Accident · Serious injuries · Closed · Apr 23, 1967 · N8196U · Substantial damage
- [NTSB LAX67D0369](https://openairdocs.org/ntsb/LAX67D0369.md): Piper PA-23 · San Diego, CA · Accident · No injuries · Closed · Apr 23, 1967 · N3211P · Substantial damage
- [NTSB FTW67F0542](https://openairdocs.org/ntsb/FTW67F0542.md): Cessna 172 · Dallas, TX · Accident · Minor injuries · Closed · Apr 23, 1967 · N1498F · Destroyed
- [NTSB CHI67F0635](https://openairdocs.org/ntsb/CHI67F0635.md): Navion L-17 · Toronto, OH · Accident · Serious injuries · Closed · Apr 23, 1967 · N114N · Destroyed
- [NTSB LAX67F0383](https://openairdocs.org/ntsb/LAX67F0383.md): Cessna 150 · Van Nuys, CA · Accident · Serious injuries · Closed · Apr 22, 1967 · N5551E · Substantial damage
- [NTSB CHI67F0625](https://openairdocs.org/ntsb/CHI67F0625.md): Cessna 172 · Three Oaks, MI · Accident · No injuries · Closed · Apr 21, 1967 · N8457U · Substantial damage
- [NTSB LAX67F0382](https://openairdocs.org/ntsb/LAX67F0382.md): Mooney M20C · Van Nuys, CA · Accident · Minor injuries · Closed · Apr 20, 1967 · N6580U · Substantial damage
- [NTSB FTW67F0563](https://openairdocs.org/ntsb/FTW67F0563.md): Beech 65-80 · Addison, TX · Accident · Minor injuries · Closed · Apr 20, 1967 · N342NF · Substantial damage
- [NTSB CHI68D0017](https://openairdocs.org/ntsb/CHI68D0017.md): Cessna 172 · Rensselaer, IN · Accident · No injuries · Closed · Apr 17, 1967 · N6051R · Substantial damage
- [NTSB CHI67F0555](https://openairdocs.org/ntsb/CHI67F0555.md): Piper PA-32 · Troy, MI · Accident · No injuries · Closed · Apr 17, 1967 · N3865W · Substantial damage
- [NTSB NYC67F0597](https://openairdocs.org/ntsb/NYC67F0597.md): Piper PA-22 · Basking Ridge, NJ · Accident · Minor injuries · Closed · Apr 16, 1967 · N47532 · Substantial damage
- [NTSB LAX67F0371](https://openairdocs.org/ntsb/LAX67F0371.md): Fairchild PT-19 · Joshua Tree, CA · Accident · Serious injuries · Closed · Apr 16, 1967 · N52303 · Destroyed
- [NTSB SEA67D0303](https://openairdocs.org/ntsb/SEA67D0303.md): Briegleb BG-12B · Issaqua, WA · Accident · No injuries · Closed · Apr 15, 1967 · N12940 · Substantial damage
- [NTSB NYC67D0632](https://openairdocs.org/ntsb/NYC67D0632.md): Piper PA-28 · Burlington, VT · Accident · No injuries · Closed · Apr 15, 1967 · N6556W · Substantial damage
- [NTSB NYC67D0622](https://openairdocs.org/ntsb/NYC67D0622.md): Piper PA-28 · Spring Valley, NY · Accident · No injuries · Closed · Apr 15, 1967 · N6596W · Substantial damage
- [NTSB NYC67A0141](https://openairdocs.org/ntsb/NYC67A0141.md): Beech H35 · Liberty, NY · Accident · 3 fatal · Closed · Apr 15, 1967 · N8203D · Destroyed
- [NTSB CHI67F0657](https://openairdocs.org/ntsb/CHI67F0657-201139.md): Mooney M20A · Chicago, IL · Accident · No injuries · Closed · Apr 15, 1967 · N6030X · Substantial damage
- [NTSB CHI67D0615](https://openairdocs.org/ntsb/CHI67D0615.md): Ercoupe 415-E · Wadsworth, OH · Accident · No injuries · Closed · Apr 14, 1967 · N94777 · Substantial damage
- [NTSB FTW67F0537](https://openairdocs.org/ntsb/FTW67F0537.md): Globe GC-1B · Stillwater, OK · Accident · Minor injuries · Closed · Apr 13, 1967 · N3346K · Substantial damage
- [NTSB DIA67D0078](https://openairdocs.org/ntsb/DIA67D0078.md): Cessna 182 · Clinton, MD · Accident · No injuries · Closed · Apr 12, 1967 · N7172E · Substantial damage
- [NTSB MIA67D0507](https://openairdocs.org/ntsb/MIA67D0507.md): Cessna 150 · Mcdonough, GA · Accident · No injuries · Closed · Apr 11, 1967 · N6454T · Substantial damage
- [NTSB UNK67X0122](https://openairdocs.org/ntsb/UNK67X0122.md): Pilatus PC-6C · Moung Mounge, Laos · Accident · No injuries · Closed · Apr 9, 1967 · N392R · Substantial damage
- [NTSB SEA67F0309](https://openairdocs.org/ntsb/SEA67F0309.md): Schweizer SGU222 · Boise, ID · Accident · No injuries · Closed · Apr 9, 1967 · N9943J · Substantial damage
- [NTSB MIA68F0184](https://openairdocs.org/ntsb/MIA68F0184.md): Piper PA-18 · Crescent Beach, SC · Accident · No injuries · Closed · Apr 9, 1967 · N335T · Destroyed
- [NTSB ANC68D0001](https://openairdocs.org/ntsb/ANC68D0001.md): Cessna 180 · Stony River, AK · Accident · No injuries · Closed · Apr 9, 1967 · N7615A · Substantial damage
- [NTSB CHI67D0610](https://openairdocs.org/ntsb/CHI67D0610.md): Piper PA-28 · West Liberty, KY · Accident · No injuries · Closed · Apr 8, 1967 · N5894W · Substantial damage
- [NTSB DEN67A0060](https://openairdocs.org/ntsb/DEN67A0060.md): Cessna 310D · Albuquerque, NM · Accident · No injuries · Closed · Apr 7, 1967 · N824S · Substantial damage
- [NTSB MIA67F0515](https://openairdocs.org/ntsb/MIA67F0515.md): Navion A · Alexander Cty, AL · Accident · No injuries · Closed · Apr 6, 1967 · N4321K · Substantial damage
- [NTSB SEA68F0027](https://openairdocs.org/ntsb/SEA68F0027.md): Piper PA-28 · Port Orchard, WA · Accident · Serious injuries · Closed · Apr 5, 1967 · N4392J · Substantial damage
- [NTSB NYC67F0591](https://openairdocs.org/ntsb/NYC67F0591.md): Piper PA-28 · Bernville, PA · Accident · Serious injuries · Closed · Apr 5, 1967 · N7451R · Substantial damage
- [NTSB NYC67D0610](https://openairdocs.org/ntsb/NYC67D0610.md): Schweitzer 1-26 · Wurtsboro, NY · Accident · Minor injuries · Closed · Apr 2, 1967 · N679U · Substantial damage
- [NTSB SEA67A0064](https://openairdocs.org/ntsb/SEA67A0064-117738.md): Volmer VJ-22 · Lacey, WA · Accident · 1 fatal · Closed · Apr 1, 1967 · N68648 · Destroyed
- [NTSB NYC67F0588](https://openairdocs.org/ntsb/NYC67F0588.md): Cessna 150 · Ludlow, MA · Accident · Minor injuries · Closed · Apr 1, 1967 · N8214S · Destroyed
- [NTSB NYC67D0567](https://openairdocs.org/ntsb/NYC67D0567.md): Beech A23 · Montgomryville, PA · Accident · No injuries · Closed · Apr 1, 1967 · N8763M · Substantial damage
- [NTSB FTW67F0550](https://openairdocs.org/ntsb/FTW67F0550.md): Champion 7JC · Manila, AR · Accident · Minor injuries · Closed · Apr 1, 1967 · N8967R · Substantial damage
- [NTSB FTW67D0528](https://openairdocs.org/ntsb/FTW67D0528.md): Cessna 150 · Lafayette, LA · Accident · No injuries · Closed · Apr 1, 1967 · N8918S · Substantial damage

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

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

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