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

## Cases, newest first

- [NTSB OAK67D0232](https://openairdocs.org/ntsb/OAK67D0232.md): Navion D · Santa Cruz, CA · Accident · No injuries · Closed · Jun 4, 1966 · N5419V · Substantial damage
- [NTSB NYC67D0012](https://openairdocs.org/ntsb/NYC67D0012.md): Cessna 150 · New City, NY · Accident · Minor injuries · Closed · Jun 4, 1966 · N6592F · Substantial damage
- [NTSB FTW67D0032](https://openairdocs.org/ntsb/FTW67D0032.md): Ercoupe 415-C · Altus, OK · Accident · No injuries · Closed · Jun 4, 1966 · N2131H · Substantial damage
- [NTSB FTW66D0700](https://openairdocs.org/ntsb/FTW66D0700.md): Piper PA-22 · Freemason Isle, LA · Accident · Minor injuries · Closed · Jun 4, 1966 · N6713P · Substantial damage
- [NTSB CHI66F0758](https://openairdocs.org/ntsb/CHI66F0758.md): Aeronca 7FC · Palmyra, WI · Accident · No injuries · Closed · Jun 4, 1966 · N7683E · Substantial damage
- [NTSB NYC67F0002](https://openairdocs.org/ntsb/NYC67F0002.md): Cessna 172 · Northfield, CT · Accident · Minor injuries · Closed · Jun 3, 1966 · N8790B · Substantial damage
- [NTSB NYC66D0683](https://openairdocs.org/ntsb/NYC66D0683.md): Cessna 182 · White Plains, MD · Accident · Minor injuries · Closed · Jun 3, 1966 · N3312Y · Substantial damage
- [NTSB DEN66D0350](https://openairdocs.org/ntsb/DEN66D0350.md): Ercoupe 415C · Gallup, NM · Accident · No injuries · Closed · Jun 3, 1966 · N87095 · Substantial damage
- [NTSB CHI67F0022](https://openairdocs.org/ntsb/CHI67F0022.md): Piper PA-22 · Middleton, WI · Accident · Minor injuries · Closed · Jun 2, 1966 · N9964D · Substantial damage
- [NTSB MKC67F0073](https://openairdocs.org/ntsb/MKC67F0073.md): Piper PA-28 · Kansas City, KS · Accident · Minor injuries · Closed · May 30, 1966 · N6686W · Substantial damage
- [NTSB OAK67D0009](https://openairdocs.org/ntsb/OAK67D0009.md): Ercoupe 415-C · S.Luis Obispo, CA · Accident · No injuries · Closed · May 29, 1966 · N3618H · Substantial damage
- [NTSB NYC67F0051](https://openairdocs.org/ntsb/NYC67F0051.md): Piper J3C-65 · Pennington, NJ · Accident · Serious injuries · Closed · May 29, 1966 · N38541 · Substantial damage
- [NTSB MKC67F0132](https://openairdocs.org/ntsb/MKC67F0132.md): Piper J-3 · Waldron, MO · Accident · No injuries · Closed · May 29, 1966 · N42446 · Substantial damage
- [NTSB FTW67D0030](https://openairdocs.org/ntsb/FTW67D0030.md): Cessna 182 · Crowley, LA · Accident · No injuries · Closed · May 29, 1966 · N8583S · Substantial damage
- [NTSB ANC67D0008](https://openairdocs.org/ntsb/ANC67D0008.md): Cessna 180 · Elmendorf Af, AK · Accident · No injuries · Closed · May 29, 1966 · N1566C · Substantial damage
- [NTSB MKC67F0009](https://openairdocs.org/ntsb/MKC67F0009.md): Cessna 182 · Rapid City, SD · Accident · Minor injuries · Closed · May 28, 1966 · N6381B · Substantial damage
- [NTSB MKC66D0580](https://openairdocs.org/ntsb/MKC66D0580.md): Luscombe 8A · Aurora, MO · Accident · No injuries · Closed · May 28, 1966 · N1231K · Substantial damage
- [NTSB FTW66A0109](https://openairdocs.org/ntsb/FTW66A0109.md): Cessna 172 · Boyce, LA · Accident · 1 fatal · Closed · May 28, 1966 · N5886A · Destroyed
- [NTSB CHI67F0115](https://openairdocs.org/ntsb/CHI67F0115.md): Boeing A75N1 · Lima, OH · Accident · No injuries · Closed · May 28, 1966 · N4739V · Substantial damage
- [NTSB CHI66D0759](https://openairdocs.org/ntsb/CHI66D0759.md): Cessna P206 · Augres, MI · Accident · Minor injuries · Closed · May 28, 1966 · N4623F · Substantial damage
- [NTSB ANC66F0108](https://openairdocs.org/ntsb/ANC66F0108.md): Piper PA-22 · Palmer, AK · Accident · Serious injuries · Closed · May 28, 1966 · N5838D · Destroyed
- [NTSB SEA66D0300](https://openairdocs.org/ntsb/SEA66D0300.md): Cessna 180 · Grace, ID · Accident · No injuries · Closed · May 27, 1966 · N2269C · Substantial damage
- [NTSB NYC67D0007](https://openairdocs.org/ntsb/NYC67D0007.md): Stinson 10A · Penn Yan, NY · Accident · No injuries · Closed · May 27, 1966 · N32203 · Substantial damage
- [NTSB OAK66D0281](https://openairdocs.org/ntsb/OAK66D0281.md): Cessna 175B · Grass Valley, CA · Accident · No injuries · Closed · May 26, 1966 · N8191T · Substantial damage
- [NTSB MIA66D0583](https://openairdocs.org/ntsb/MIA66D0583.md): Piper PA24 · Laurel, MS · Accident · No injuries · Closed · May 26, 1966 · N7323P · Substantial damage
- [NTSB NYC66F0688](https://openairdocs.org/ntsb/NYC66F0688.md): Piper PA-23 · Lincoln, RI · Accident · Serious injuries · Closed · May 25, 1966 · N2184P · Destroyed
- [NTSB SEA66A0060](https://openairdocs.org/ntsb/SEA66A0060.md): Cessna 172 · Metaline Fls, WA · Accident · 3 fatal · Closed · May 24, 1966 · N7230A · Substantial damage
- [NTSB CHI66F0745](https://openairdocs.org/ntsb/CHI66F0745.md): Beech A23A · Cable, WI · Accident · No injuries · Closed · May 24, 1966 · N2360W · Substantial damage
- [NTSB NYC66A0134](https://openairdocs.org/ntsb/NYC66A0134.md): Brantly B2B · Rostraver, PA · Accident · Minor injuries · Closed · May 23, 1966 · N2188U · Destroyed
- [NTSB CHI67D0019](https://openairdocs.org/ntsb/CHI67D0019.md): Piper PA-22 · Lake Village, IN · Accident · No injuries · Closed · May 23, 1966 · N9605D · Substantial damage
- [NTSB SEA66D0280](https://openairdocs.org/ntsb/SEA66D0280.md): N American T-6G · Hogeland, MT · Accident · No injuries · Closed · May 21, 1966 · N3172G · Substantial damage
- [NTSB OAK66D0300](https://openairdocs.org/ntsb/OAK66D0300.md): Oberlerchnr MG23 · Sheridan, CA · Accident · No injuries · Closed · May 21, 1966 · N6729C · Substantial damage
- [NTSB NYC66F0694](https://openairdocs.org/ntsb/NYC66F0694.md): Beech A23 · Colts Neck, NJ · Accident · No injuries · Closed · May 21, 1966 · N3534R · Substantial damage
- [NTSB MKC66D0570](https://openairdocs.org/ntsb/MKC66D0570.md): Cessna 150 · Gordon, NE · Accident · No injuries · Closed · May 21, 1966 · N6124T · Substantial damage
- [NTSB LAX67F0001](https://openairdocs.org/ntsb/LAX67F0001.md): Luscombe 8A · Ojai, CA · Accident · Minor injuries · Closed · May 21, 1966 · N28627 · Substantial damage
- [NTSB DEN66D0318](https://openairdocs.org/ntsb/DEN66D0318.md): Cessna 175 · Anthony, NM · Accident · No injuries · Closed · May 21, 1966 · N7577M · Substantial damage
- [NTSB ANC66D0109](https://openairdocs.org/ntsb/ANC66D0109.md): Piper PA-22 · Stampede, AK · Accident · No injuries · Closed · May 21, 1966 · N9033D · Substantial damage
- [NTSB NYC66A0714](https://openairdocs.org/ntsb/NYC66A0714.md): Cessna 172 · Clinton, MD · Accident · Serious injuries · Closed · May 20, 1966 · N6117E · Destroyed
- [NTSB LAX66A0089](https://openairdocs.org/ntsb/LAX66A0089.md): Piper PA-28 · Santa Ynez, CA · Accident · No injuries · Closed · May 18, 1966 · N5914W · 2 aircraft · Minor damage
- [NTSB CHI66F0744](https://openairdocs.org/ntsb/CHI66F0744.md): Cessna 170 · Franklin, WI · Accident · Serious injuries · Closed · May 17, 1966 · N4209V · Substantial damage
- [NTSB MKC66F0567](https://openairdocs.org/ntsb/MKC66F0567.md): Cessna 182 · Maryville, MO · Accident · No injuries · Closed · May 16, 1966 · N6392B · Substantial damage
- [NTSB MIA66A0134](https://openairdocs.org/ntsb/MIA66A0134.md): Cessna 172F · Dothan, AL · Accident · 1 fatal · Closed · May 16, 1966 · N5701R · Destroyed
- [NTSB NYC66A0130](https://openairdocs.org/ntsb/NYC66A0130.md): Cessna 172 · E.Syracuse, NY · Accident · 4 fatal · Closed · May 15, 1966 · N1388Y · Destroyed
- [NTSB MKC66F0535](https://openairdocs.org/ntsb/MKC66F0535.md): Piper PA-18A · Decatur, NE · Accident · No injuries · Closed · May 15, 1966 · N9887D · Substantial damage
- [NTSB MIA66F0584](https://openairdocs.org/ntsb/MIA66F0584.md): Piper PA-28 · St Simons Isld, GA · Accident · Serious injuries · Closed · May 15, 1966 · N6432W · Destroyed
- [NTSB DEN66F0325](https://openairdocs.org/ntsb/DEN66F0325.md): Boeing B75N-1 · Albuquerque, NM · Accident · No injuries · Closed · May 15, 1966 · N62426 · Substantial damage
- [NTSB NYC66F0700](https://openairdocs.org/ntsb/NYC66F0700.md): Piper PA-28 · Williamsport, PA · Accident · No injuries · Closed · May 13, 1966 · N9018W · Substantial damage
- [NTSB FTW67F0227](https://openairdocs.org/ntsb/FTW67F0227.md): Beech 35 · Fort Worth, TX · Accident · No injuries · Closed · May 13, 1966 · N3388V · Substantial damage
- [NTSB SEA66D0272](https://openairdocs.org/ntsb/SEA66D0272.md): Cessna 172 · Heppner, OR · Accident · No injuries · Closed · May 12, 1966 · N8141X · Substantial damage
- [NTSB MIA66F0560](https://openairdocs.org/ntsb/MIA66F0560.md): Cessna 140 · Auburndale, FL · Accident · No injuries · Closed · May 12, 1966 · N76430 · Substantial damage

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

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

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