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

## Cases, newest first

- [NTSB MIA67A0126](https://openairdocs.org/ntsb/MIA67A0126.md): Brantly 305 · Chamblee, GA · Accident · 2 fatal · Closed · May 29, 1967 · N2219U · Destroyed
- [NTSB LAX67F0442](https://openairdocs.org/ntsb/LAX67F0442.md): Piper PA-22 · Tucson, AZ · Accident · Minor injuries · Closed · May 29, 1967 · N3543Z · Substantial damage
- [NTSB DIA67D0114](https://openairdocs.org/ntsb/DIA67D0114.md): Piper PA-28 · South Port, NC · Accident · No injuries · Closed · May 29, 1967 · N7560R · Destroyed
- [NTSB DIA67D0111](https://openairdocs.org/ntsb/DIA67D0111.md): Beech 35C · Cecilton, MD · Accident · No injuries · Closed · May 29, 1967 · N822M · Substantial damage
- [NTSB CHI67F0650](https://openairdocs.org/ntsb/CHI67F0650.md): Piper PA-22 · Nashport, OH · Accident · No injuries · Closed · May 29, 1967 · N5507Z · Substantial damage
- [NTSB DIA67D0102](https://openairdocs.org/ntsb/DIA67D0102.md): N American AT-6 · Charlotte, NC · Accident · No injuries · Closed · May 28, 1967 · N3748G · Substantial damage
- [NTSB SEA67D0318](https://openairdocs.org/ntsb/SEA67D0318.md): Cessna 195A · Carey, ID · Accident · No injuries · Closed · May 27, 1967 · N1512D · Substantial damage
- [NTSB DEN68F0001](https://openairdocs.org/ntsb/DEN68F0001.md): Beech C-45 · Saratoga, WY · Accident · No injuries · Closed · May 26, 1967 · N9846Z · Substantial damage
- [NTSB CHI68F0006](https://openairdocs.org/ntsb/CHI68F0006.md): Piper PA-22 · Greenville, MI · Accident · 1 fatal · Closed · May 26, 1967 · N5516Z · Destroyed
- [NTSB FTW67D0662](https://openairdocs.org/ntsb/FTW67D0662.md): Piper PA-18 · Pocahontas, AR · Accident · No injuries · Closed · May 25, 1967 · N8182D · Substantial damage
- [NTSB SEA68F0012](https://openairdocs.org/ntsb/SEA68F0012.md): Ercoupe 415-C · Cottage Grve, OR · Accident · Serious injuries · Closed · May 24, 1967 · N99793 · Destroyed
- [NTSB DIA67F0110](https://openairdocs.org/ntsb/DIA67F0110.md): Cessna 150G · Sandston, VA · Accident · No injuries · Closed · May 23, 1967 · N4629X · Substantial damage
- [NTSB SEA68D0039](https://openairdocs.org/ntsb/SEA68D0039.md): Piper PA-18 · Burns, OR · Accident · No injuries · Closed · May 21, 1967 · N1086A · Substantial damage
- [NTSB NYC67D0661](https://openairdocs.org/ntsb/NYC67D0661.md): Cessna 150 · Colts Neck, NJ · Accident · No injuries · Closed · May 21, 1967 · N6215T · Substantial damage
- [NTSB NYC67A0165](https://openairdocs.org/ntsb/NYC67A0165.md): Bensen B8M · Silver Creek, NY · Accident · Minor injuries · Closed · May 21, 1967 · N4773G · Substantial damage
- [NTSB MKC68D0020](https://openairdocs.org/ntsb/MKC68D0020.md): Mooney M20C · Norborne, MO · Accident · Serious injuries · Closed · May 21, 1967 · N6571U · Substantial damage
- [NTSB LAX67A0107](https://openairdocs.org/ntsb/LAX67A0107.md): Cessna 182C · Hawthorne, CA · Accident · 2 fatal · Closed · May 21, 1967 · N34271 · 2 aircraft · Substantial damage
- [NTSB NYC67F0700](https://openairdocs.org/ntsb/NYC67F0700.md): Piper PA-28 · Ocean City, NJ · Accident · Serious injuries · Closed · May 20, 1967 · N9572W · Substantial damage
- [NTSB MKC67F0611](https://openairdocs.org/ntsb/MKC67F0611-116481.md): Fairchild PT-26 · Omaha, NE · Accident · No injuries · Closed · May 20, 1967 · N73613 · Substantial damage
- [NTSB FTW67F0621](https://openairdocs.org/ntsb/FTW67F0621.md): Lake LA-4 · Hot Springs, AR · Accident · Minor injuries · Closed · May 20, 1967 · N1143L · Substantial damage
- [NTSB FTW67A0111](https://openairdocs.org/ntsb/FTW67A0111.md): Lockheed 1329 · Dallas, TX · Accident · No injuries · Closed · May 20, 1967 · N1967G · Substantial damage
- [NTSB CHI67F0680](https://openairdocs.org/ntsb/CHI67F0680.md): Cessna 182 · Indianapolis, IN · Accident · Minor injuries · Closed · May 20, 1967 · N5735B · Substantial damage
- [NTSB FTW67D0674](https://openairdocs.org/ntsb/FTW67D0674.md): Beech 35 · Marfa, TX · Accident · No injuries · Closed · May 19, 1967 · N7943D · Substantial damage
- [NTSB NYC67F0688](https://openairdocs.org/ntsb/NYC67F0688.md): Piper PA-28 · Mendon, MA · Accident · Serious injuries · Closed · May 18, 1967 · N8042W · Destroyed
- [NTSB FTW67F0639](https://openairdocs.org/ntsb/FTW67F0639.md): Cessna 175 · Mangum, OK · Accident · Serious injuries · Closed · May 16, 1967 · N7399M · Destroyed
- [NTSB CHI67A0126](https://openairdocs.org/ntsb/CHI67A0126.md): Cessna 320 · Aurora, IN · Accident · 6 fatal · Closed · May 16, 1967 · N3324Q · Destroyed
- [NTSB NYC67F0693](https://openairdocs.org/ntsb/NYC67F0693.md): Mooney M20C · Mckees Rocks, PA · Accident · No injuries · Closed · May 15, 1967 · N7168U · Substantial damage
- [NTSB OAK68D0002](https://openairdocs.org/ntsb/OAK68D0002.md): Cessna 182 · Lodi, CA · Accident · No injuries · Closed · May 14, 1967 · N1903X · Substantial damage
- [NTSB NYC67A0159](https://openairdocs.org/ntsb/NYC67A0159.md): Cessna 150G · Nashua, NH · Accident · 2 fatal · Closed · May 14, 1967 · N3755J · Destroyed
- [NTSB FTW67F0638](https://openairdocs.org/ntsb/FTW67F0638.md): Cessna 206B · Blue Mountain, AR · Accident · Minor injuries · Closed · May 14, 1967 · N3416L · Destroyed
- [NTSB DEN67F0262](https://openairdocs.org/ntsb/DEN67F0262.md): Mooney M20E · Albuquerque, NM · Accident · No injuries · Closed · May 14, 1967 · N2688W · Substantial damage
- [NTSB CHI67D0661](https://openairdocs.org/ntsb/CHI67D0661.md): Piper PA-28 · Pewaukee, WI · Accident · No injuries · Closed · May 12, 1967 · N6313W · Substantial damage
- [NTSB DIA67F0103](https://openairdocs.org/ntsb/DIA67F0103.md): Piper J3C · Cumberland, MD · Accident · Minor injuries · Closed · May 10, 1967 · N22831 · Substantial damage
- [NTSB CHI67A0122](https://openairdocs.org/ntsb/CHI67A0122.md): Beech 35-A33 · Lansing, MI · Accident · 3 fatal · Closed · May 10, 1967 · N7111N · Destroyed
- [NTSB OAK67A0077](https://openairdocs.org/ntsb/OAK67A0077.md): Mooney M20E · Del Ray Oak, CA · Accident · 4 fatal · Closed · May 9, 1967 · N1323W · Destroyed
- [NTSB DIA67A0018](https://openairdocs.org/ntsb/DIA67A0018.md): Beech C35 · Keyser, WV · Accident · 1 fatal · Closed · May 9, 1967 · N5853C · Destroyed
- [NTSB NYC68D0057](https://openairdocs.org/ntsb/NYC68D0057.md): Piper PA-22 · Amherst, NY · Accident · No injuries · Closed · May 7, 1967 · N5888Z · Substantial damage
- [NTSB LAX67D0390](https://openairdocs.org/ntsb/LAX67D0390.md): Cessna 172 · Murrieta, CA · Accident · No injuries · Closed · May 7, 1967 · N5504T · Substantial damage
- [NTSB FTW67D0613](https://openairdocs.org/ntsb/FTW67D0613.md): Cessna 150 · Oakwood, OK · Accident · No injuries · Closed · May 7, 1967 · N3563T · Substantial damage
- [NTSB OAK67D0336](https://openairdocs.org/ntsb/OAK67D0336.md): Boeing A75N1 · Colusa, CA · Accident · No injuries · Closed · May 6, 1967 · N56206 · Substantial damage
- [NTSB MKC67F0581](https://openairdocs.org/ntsb/MKC67F0581.md): Schweizer SGU-2 · Red Wing, MN · Accident · No injuries · Closed · May 6, 1967 · N5823V · Substantial damage
- [NTSB LAX67D0428](https://openairdocs.org/ntsb/LAX67D0428.md): Schweitzer SGS126 · Adelanto, CA · Accident · No injuries · Closed · May 6, 1967 · N10387 · Substantial damage
- [NTSB NYC67F0677](https://openairdocs.org/ntsb/NYC67F0677.md): Piper PA-22 · Liberty, NY · Accident · No injuries · Closed · May 5, 1967 · N5802Z · Substantial damage
- [NTSB FTW67D0609](https://openairdocs.org/ntsb/FTW67D0609.md): Grumman G-164 · Dewitt, AR · Accident · No injuries · Closed · May 4, 1967 · N10226 · Substantial damage
- [NTSB FTW67F0591](https://openairdocs.org/ntsb/FTW67F0591.md): Cessna 172 · Haynesville, LA · Accident · Serious injuries · Closed · May 3, 1967 · N7895U · Destroyed
- [NTSB CHI67D0649](https://openairdocs.org/ntsb/CHI67D0649.md): Piper PA-22 · Hartford City, IN · Accident · No injuries · Closed · May 3, 1967 · N2355A · Substantial damage
- [NTSB NYC67F0646](https://openairdocs.org/ntsb/NYC67F0646.md): Cessna 182H · West Mifflin, PA · Accident · No injuries · Closed · May 2, 1967 · N2034X · Substantial damage
- [NTSB LAX67F0421](https://openairdocs.org/ntsb/LAX67F0421.md): Piper PA-30 · Tucson, AZ · Accident · Serious injuries · Closed · May 2, 1967 · N7347Y · Destroyed
- [NTSB FTW67D0589](https://openairdocs.org/ntsb/FTW67D0589.md): Cessna 170 · Blackwell, OK · Accident · No injuries · Closed · May 2, 1967 · N4042V · Substantial damage
- [NTSB DIA67F0082](https://openairdocs.org/ntsb/DIA67F0082.md): Piper PA-24 · Alexandria, VA · Accident · Minor injuries · Closed · May 1, 1967 · N7566P · Substantial damage

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

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

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