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

## Cases, newest first

- [NTSB NYC67F0605](https://openairdocs.org/ntsb/NYC67F0605.md): Mooney M20B · Morristown, NJ · Accident · No injuries · Closed · Mar 31, 1967 · N74710 · Substantial damage
- [NTSB MIA67A0103](https://openairdocs.org/ntsb/MIA67A0103.md): Beech A23 · Hattiesburg, MS · Accident · 3 fatal · Closed · Mar 31, 1967 · N2345W · Destroyed
- [NTSB NYC67D0667](https://openairdocs.org/ntsb/NYC67D0667.md): Piper PA-28 · Beverly, MA · Accident · No injuries · Closed · Mar 30, 1967 · N352J · Substantial damage
- [NTSB DCA67A0007](https://openairdocs.org/ntsb/DCA67A0007.md): Douglas DC-8 · Kenner, LA · Accident · 6 fatal · Closed · Mar 30, 1967 · N802E · Destroyed
- [NTSB CHI67F0562](https://openairdocs.org/ntsb/CHI67F0562.md): Cessna 310H · Streator, IL · Accident · No injuries · Closed · Mar 30, 1967 · N1096Q · Substantial damage
- [NTSB MIA67A0101](https://openairdocs.org/ntsb/MIA67A0101.md): Cessna 150F · Lawrenceville, GA · Accident · 1 fatal · Closed · Mar 29, 1967 · N8821S · Destroyed
- [NTSB MKC67D0477](https://openairdocs.org/ntsb/MKC67D0477.md): Piper PA-22 · Denison, IA · Accident · No injuries · Closed · Mar 28, 1967 · N3415A · Substantial damage
- [NTSB MIA67A0098](https://openairdocs.org/ntsb/MIA67A0098.md): Beech 95-55 · Greenwood, MS · Accident · 2 fatal · Closed · Mar 27, 1967 · N1333Z · Destroyed
- [NTSB SEA67D0328](https://openairdocs.org/ntsb/SEA67D0328.md): Cessna 150 · Grass Valley, OR · Accident · No injuries · Closed · Mar 25, 1967 · N3099J · Substantial damage
- [NTSB OAK67D0308](https://openairdocs.org/ntsb/OAK67D0308.md): Schweitzer 1-26A · Carson City, NV · Accident · No injuries · Closed · Mar 25, 1967 · N8688R · Substantial damage
- [NTSB FTW67F0523](https://openairdocs.org/ntsb/FTW67F0523.md): Piper PA-28 · Tillar, AR · Accident · No injuries · Closed · Mar 23, 1967 · N7331W · Substantial damage
- [NTSB CHI67F0559](https://openairdocs.org/ntsb/CHI67F0559.md): Boeing A75N1 · Bluford, IL · Accident · No injuries · Closed · Mar 22, 1967 · N57013 · Substantial damage
- [NTSB NYC67D0625](https://openairdocs.org/ntsb/NYC67D0625.md): Cessna 150 · Plymouth, MA · Accident · No injuries · Closed · Mar 21, 1967 · N2454J · Substantial damage
- [NTSB FTW67F0506](https://openairdocs.org/ntsb/FTW67F0506.md): Cessna 150E · Jacksboro, TX · Accident · Minor injuries · Closed · Mar 21, 1967 · N4058U · Destroyed
- [NTSB MIA67A0095](https://openairdocs.org/ntsb/MIA67A0095.md): Bell 47J-2A · Miami Beach, FL · Accident · Minor injuries · Closed · Mar 20, 1967 · N73990 · Substantial damage
- [NTSB OAK67D0257](https://openairdocs.org/ntsb/OAK67D0257.md): Piper PA-28 · Herlong, CA · Accident · Minor injuries · Closed · Mar 17, 1967 · N7516R · Substantial damage
- [NTSB NYC67D0546](https://openairdocs.org/ntsb/NYC67D0546.md): Piper PA-28 · Hartford, CT · Accident · No injuries · Closed · Mar 16, 1967 · N9124W · Substantial damage
- [NTSB CHI68D0479](https://openairdocs.org/ntsb/CHI68D0479.md): Piper PA-28 · Urbana, IL · Accident · Minor injuries · Closed · Mar 16, 1967 · N6498R · Destroyed
- [NTSB NYC67I0038](https://openairdocs.org/ntsb/NYC67I0038.md): Boeing B-727 · Newark, NJ · Incident · No injuries · Closed · Mar 14, 1967 · N8148N · Minor damage
- [NTSB OAK67A0068](https://openairdocs.org/ntsb/OAK67A0068.md): Piper PA-22 · Sutcliffe, NV · Accident · 1 fatal · Closed · Mar 12, 1967 · N1743P · Destroyed
- [NTSB MIA67F0434](https://openairdocs.org/ntsb/MIA67F0434.md): Schweitzer TG-3A · Eagleville, TN · Accident · Serious injuries · Closed · Mar 12, 1967 · N1438M · Destroyed
- [NTSB OAK67D0311](https://openairdocs.org/ntsb/OAK67D0311.md): Cessna 172 · Antioch, CA · Accident · No injuries · Closed · Mar 11, 1967 · N4344L · Substantial damage
- [NTSB NYC67D0522](https://openairdocs.org/ntsb/NYC67D0522.md): Beech A23 · Oneonta, NY · Accident · No injuries · Closed · Mar 11, 1967 · N5962S · Substantial damage
- [NTSB LAX67D0378](https://openairdocs.org/ntsb/LAX67D0378.md): Schweitzer 2-22 · Flagstaff, AZ · Accident · Serious injuries · Closed · Mar 11, 1967 · N10367 · Minor damage
- [NTSB FTW67F0486](https://openairdocs.org/ntsb/FTW67F0486.md): Piper PA-24 · Fort Worth, TX · Accident · No injuries · Closed · Mar 11, 1967 · N7672P · Substantial damage
- [NTSB MIA67A0093](https://openairdocs.org/ntsb/MIA67A0093.md): Piper J3C-65 · Fosters, AL · Accident · 1 fatal · Closed · Mar 10, 1967 · N92295 · Destroyed
- [NTSB LAX67F0312](https://openairdocs.org/ntsb/LAX67F0312.md): Cessna 150 · Long Beach, CA · Accident · No injuries · Closed · Mar 10, 1967 · N8651G · Substantial damage
- [NTSB FTW67D0516](https://openairdocs.org/ntsb/FTW67D0516.md): Cessna 182 · Ferriday, LA · Accident · No injuries · Closed · Mar 10, 1967 · N3030Y · Substantial damage
- [NTSB MKC67F0529](https://openairdocs.org/ntsb/MKC67F0529.md): Piper PA-22 · St.Paul, MN · Accident · No injuries · Closed · Mar 9, 1967 · N4599Z · Destroyed
- [NTSB MKC67F0604](https://openairdocs.org/ntsb/MKC67F0604.md): Navion B · Columbia, MO · Accident · No injuries · Closed · Mar 8, 1967 · N5274K · Destroyed
- [NTSB CHI67F0570](https://openairdocs.org/ntsb/CHI67F0570.md): Beech D50A · Solsberry, IN · Accident · Serious injuries · Closed · Mar 8, 1967 · N5636D · Substantial damage
- [NTSB OAK67A0066](https://openairdocs.org/ntsb/OAK67A0066.md): Navion NAV-A · S.Francisco, CA · Accident · 2 fatal · Closed · Mar 6, 1967 · N8760H · Destroyed
- [NTSB NYC67A0125](https://openairdocs.org/ntsb/NYC67A0125.md): Cessna 310K · Dexter, NY · Accident · Serious injuries · Closed · Mar 6, 1967 · N6944L · Destroyed
- [NTSB MKC67D0478](https://openairdocs.org/ntsb/MKC67D0478.md): Cessna 172 · Eldora, IA · Accident · No injuries · Closed · Mar 6, 1967 · N4186L · Substantial damage
- [NTSB ANC68F0023](https://openairdocs.org/ntsb/ANC68F0023.md): Piper PA-18 · Mcgrath, AK · Accident · Serious injuries · Closed · Mar 6, 1967 · N5408Y · Substantial damage
- [NTSB OAK67D0273](https://openairdocs.org/ntsb/OAK67D0273.md): Beech 35 · Novato, CA · Accident · No injuries · Closed · Mar 5, 1967 · N8259D · Substantial damage
- [NTSB OAK67D0242](https://openairdocs.org/ntsb/OAK67D0242.md): Taylorcraft DCO-65 · Soledad, CA · Accident · Minor injuries · Closed · Mar 4, 1967 · N48603 · Substantial damage
- [NTSB CHI67F0526](https://openairdocs.org/ntsb/CHI67F0526.md): Piper PA-22 · Grand Ledge, MI · Accident · No injuries · Closed · Mar 4, 1967 · N5903D · Substantial damage
- [NTSB OAK67A0064](https://openairdocs.org/ntsb/OAK67A0064.md): Cessna 182G · Oroville, CA · Accident · 1 fatal · Closed · Mar 2, 1967 · N2344R · Destroyed
- [NTSB LAX67A0081](https://openairdocs.org/ntsb/LAX67A0081.md): Bensen B-8 · Fontana, CA · Accident · No injuries · Closed · Mar 2, 1967 · N1697 · Substantial damage
- [NTSB MKC67D0481](https://openairdocs.org/ntsb/MKC67D0481.md): Champion 7FC · Anoka, MN · Accident · No injuries · Closed · Feb 27, 1967 · N9989Y · Substantial damage
- [NTSB MKC67F0473](https://openairdocs.org/ntsb/MKC67F0473.md): Beech 35 · Chesterfield, MO · Accident · No injuries · Closed · Feb 26, 1967 · N3073V · Substantial damage
- [NTSB MKC67D0462](https://openairdocs.org/ntsb/MKC67D0462.md): Piper PA-22 · Sac City, IA · Accident · No injuries · Closed · Feb 26, 1967 · N3533Z · Substantial damage
- [NTSB LAX67D0314](https://openairdocs.org/ntsb/LAX67D0314.md): Luscombe 8A · Joshua Tree, CA · Accident · No injuries · Closed · Feb 26, 1967 · N1571K · Substantial damage
- [NTSB LAX67F0320](https://openairdocs.org/ntsb/LAX67F0320.md): Piper PA-24 · Buckeye, AZ · Accident · No injuries · Closed · Feb 25, 1967 · N7210P · Substantial damage
- [NTSB CHI67F0557](https://openairdocs.org/ntsb/CHI67F0557.md): Mooney M20E · Freeland, MI · Accident · No injuries · Closed · Feb 24, 1967 · N5747Q · Substantial damage
- [NTSB MIA67F0394](https://openairdocs.org/ntsb/MIA67F0394.md): Cessna 150D · Madison, MS · Accident · No injuries · Closed · Feb 23, 1967 · N6031T · Destroyed
- [NTSB MIA67D0544](https://openairdocs.org/ntsb/MIA67D0544.md): Beech A23 · Batesburg, SC · Accident · No injuries · Closed · Feb 23, 1967 · N8863M · Destroyed
- [NTSB MIA67D0455](https://openairdocs.org/ntsb/MIA67D0455.md): Cessna 150 · Lithonia, GA · Accident · No injuries · Closed · Feb 23, 1967 · N8217S · Substantial damage
- [NTSB LAX67F0321](https://openairdocs.org/ntsb/LAX67F0321.md): Piper PA-28 · Long Beach, CA · Accident · Minor injuries · Closed · Feb 23, 1967 · N8367R · Substantial damage

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

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

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