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

## Cases, newest first

- [NTSB MKC67F0296](https://openairdocs.org/ntsb/MKC67F0296.md): Piper PA-28 · St.Charles, MO · Accident · No injuries · Closed · Oct 23, 1966 · N7040R · Substantial damage
- [NTSB MKC67A0031](https://openairdocs.org/ntsb/MKC67A0031.md): Bensen B-8M · Lincoln, NE · Accident · Minor injuries · Closed · Oct 23, 1966 · N25039 · Substantial damage
- [NTSB FTW67D0279](https://openairdocs.org/ntsb/FTW67D0279.md): Alon A-2 · Corning, AR · Accident · No injuries · Closed · Oct 22, 1966 · N5655F · Substantial damage
- [NTSB FTW67A0046](https://openairdocs.org/ntsb/FTW67A0046.md): Douglas DC-8 · New Orleans, LA · Accident · Minor injuries · Closed · Oct 22, 1966 · N808E · Substantial damage
- [NTSB OAK67F0134](https://openairdocs.org/ntsb/OAK67F0134.md): Beech C-45H · Honolulu, HI · Accident · Serious injuries · Closed · Oct 21, 1966 · N139V · Substantial damage
- [NTSB CHI67D0308](https://openairdocs.org/ntsb/CHI67D0308.md): Piper PA-24 · Danville, KY · Accident · No injuries · Closed · Oct 21, 1966 · N6176P · Substantial damage
- [NTSB NYC67A0062](https://openairdocs.org/ntsb/NYC67A0062.md): Grumman G-159 · Pittsfield, MA · Accident · No injuries · Closed · Oct 20, 1966 · N363G · Substantial damage
- [NTSB SEA67D0204](https://openairdocs.org/ntsb/SEA67D0204.md): Beech A23 · Klamath Fall, OR · Accident · No injuries · Closed · Oct 19, 1966 · N3590R · Destroyed
- [NTSB MIA67D0282](https://openairdocs.org/ntsb/MIA67D0282.md): Cessna 172 · Jasper, AL · Accident · No injuries · Closed · Oct 19, 1966 · N5372R · Substantial damage
- [NTSB CHI67F0377](https://openairdocs.org/ntsb/CHI67F0377.md): Piper PA-28 · Elgin, IL · Accident · No injuries · Closed · Oct 19, 1966 · N9056J · Substantial damage
- [NTSB NYC67F0337](https://openairdocs.org/ntsb/NYC67F0337.md): Piper PA-28 · So.Hackensack, NJ · Accident · Minor injuries · Closed · Oct 18, 1966 · N6769W · Destroyed
- [NTSB MIA67A0047](https://openairdocs.org/ntsb/MIA67A0047.md): Cessna 210 · Fairburn, GA · Accident · 3 fatal · Closed · Oct 18, 1966 · N6534X · Destroyed
- [NTSB MKC67D0273](https://openairdocs.org/ntsb/MKC67D0273.md): Cessna 182 · Omaha, NE · Accident · No injuries · Closed · Oct 17, 1966 · N5548B · Substantial damage
- [NTSB OAK67D0269](https://openairdocs.org/ntsb/OAK67D0269.md): Piper PA-28 · Novato, CA · Accident · No injuries · Closed · Oct 16, 1966 · N9530J · Substantial damage
- [NTSB MIA67A0046](https://openairdocs.org/ntsb/MIA67A0046.md): Cessna 180 · Englewood, FL · Accident · 2 fatal · Closed · Oct 16, 1966 · N2862A · Destroyed
- [NTSB FTW67F0276](https://openairdocs.org/ntsb/FTW67F0276.md): Cessna 150 · Portland, TX · Accident · No injuries · Closed · Oct 16, 1966 · N8724G · Substantial damage
- [NTSB LAX67F0176](https://openairdocs.org/ntsb/LAX67F0176.md): Cessna 150 · Phoenix, AZ · Accident · Minor injuries · Closed · Oct 15, 1966 · N7802Z · Substantial damage
- [NTSB MIA67D0256](https://openairdocs.org/ntsb/MIA67D0256.md): Mooney M20C · W.Palm Beach, FL · Accident · Minor injuries · Closed · Oct 14, 1966 · N1215X · Substantial damage
- [NTSB SEA67D0211](https://openairdocs.org/ntsb/SEA67D0211.md): Cessna 310J · Everett, WA · Accident · No injuries · Closed · Oct 13, 1966 · N3116L · Destroyed
- [NTSB NYC67D0319](https://openairdocs.org/ntsb/NYC67D0319.md): Schweizer 2-22C · Elmira, NY · Accident · Minor injuries · Closed · Oct 12, 1966 · N8648R · Substantial damage
- [NTSB FTW67F0246](https://openairdocs.org/ntsb/FTW67F0246.md): Piper PA-22 · Muenster, TX · Accident · Serious injuries · Closed · Oct 11, 1966 · N1401A · Substantial damage
- [NTSB NYC67F0348](https://openairdocs.org/ntsb/NYC67F0348.md): Luscombe 8A · Richmond, VA · Accident · Serious injuries · Closed · Oct 10, 1966 · N45807 · Destroyed
- [NTSB MKC67F0487](https://openairdocs.org/ntsb/MKC67F0487.md): Piper PA-22 · Bowling Green, MO · Accident · Minor injuries · Closed · Oct 9, 1966 · N8263C · Substantial damage
- [NTSB FTW67D0258](https://openairdocs.org/ntsb/FTW67D0258.md): Cessna 182 · Blackwell, OK · Accident · No injuries · Closed · Oct 9, 1966 · N2026X · Substantial damage
- [NTSB NYC67F0297](https://openairdocs.org/ntsb/NYC67F0297.md): Piper PA-28 · Ocean City, NJ · Accident · No injuries · Closed · Oct 8, 1966 · N5339W · Substantial damage
- [NTSB NYC67D0311](https://openairdocs.org/ntsb/NYC67D0311.md): Schleicher KA-6 · Gorham, NH · Accident · Minor injuries · Closed · Oct 8, 1966 · N6574D · Destroyed
- [NTSB FTW67F0326](https://openairdocs.org/ntsb/FTW67F0326.md): Great Lakes 2T-1A · Smithville, TX · Accident · Minor injuries · Closed · Oct 8, 1966 · N909N · Substantial damage
- [NTSB CHI67D0270](https://openairdocs.org/ntsb/CHI67D0270.md): Piper PA-24 · Northbrook, IL · Accident · No injuries · Closed · Oct 8, 1966 · N7083P · Substantial damage
- [NTSB ANC67A0038](https://openairdocs.org/ntsb/ANC67A0038-120958.md): Bell 47G-4A · Kenai, AK · Accident · No injuries · Closed · Oct 8, 1966 · N8576F · Substantial damage
- [NTSB OAK67D0090](https://openairdocs.org/ntsb/OAK67D0090.md): Cessna 170B · Elk Grove, CA · Accident · No injuries · Closed · Oct 5, 1966 · N8000A · Substantial damage
- [NTSB CHI67F0204](https://openairdocs.org/ntsb/CHI67F0204.md): Piper PA-28 · Columbus, OH · Accident · Minor injuries · Closed · Oct 4, 1966 · N6314R · Substantial damage
- [NTSB NYC67F0404](https://openairdocs.org/ntsb/NYC67F0404.md): Beech A23-24 · Marlboro, MA · Accident · No injuries · Closed · Oct 2, 1966 · N5784V · Substantial damage
- [NTSB NYC67F0296](https://openairdocs.org/ntsb/NYC67F0296.md): Piper PA-22 · Williamson, NY · Accident · Serious injuries · Closed · Oct 2, 1966 · N2225A · Substantial damage
- [NTSB MIA67F0291](https://openairdocs.org/ntsb/MIA67F0291.md): N.American P-51D · Chamblee, GA · Accident · Minor injuries · Closed · Oct 2, 1966 · N13410 · Substantial damage
- [NTSB LAX67D0206](https://openairdocs.org/ntsb/LAX67D0206.md): Cessna 140 · Blythe, CA · Accident · No injuries · Closed · Oct 2, 1966 · N89923 · Substantial damage
- [NTSB LAX67D0150](https://openairdocs.org/ntsb/LAX67D0150.md): Beech D35 · Big Bear, CA · Accident · No injuries · Closed · Oct 2, 1966 · N2988B · Substantial damage
- [NTSB NYC67D0294](https://openairdocs.org/ntsb/NYC67D0294.md): Piper J3L-65 · Grottoes, VA · Accident · Minor injuries · Closed · Sep 30, 1966 · N38686 · Substantial damage
- [NTSB NYC67A0056](https://openairdocs.org/ntsb/NYC67A0056.md): Piper PA-30 · Ceredo, WV · Accident · 1 fatal · Closed · Sep 30, 1966 · N7472Y · Destroyed
- [NTSB CHI67F0208](https://openairdocs.org/ntsb/CHI67F0208.md): Cessna 182B · Plainwell, MI · Accident · No injuries · Closed · Sep 28, 1966 · N7174E · Substantial damage
- [NTSB MKC67F0272](https://openairdocs.org/ntsb/MKC67F0272.md): Cessna 150 · Rosemount, MN · Accident · No injuries · Closed · Sep 27, 1966 · N6684T · 2 aircraft · Substantial damage
- [NTSB DEN67F0106](https://openairdocs.org/ntsb/DEN67F0106.md): Piper PA-30 · Fountain, CO · Accident · No injuries · Closed · Sep 27, 1966 · N7903Y · Substantial damage
- [NTSB NYC67A0052](https://openairdocs.org/ntsb/NYC67A0052.md): Bensen B8M · Benton, PA · Accident · 1 fatal · Closed · Sep 25, 1966 · N1138 · Destroyed
- [NTSB LAX67F0165](https://openairdocs.org/ntsb/LAX67F0165.md): Cessna 172 · Apple Valley, CA · Accident · Serious injuries · Closed · Sep 25, 1966 · N7034A · Destroyed
- [NTSB UNK66X0177](https://openairdocs.org/ntsb/UNK66X0177.md): Cessna U206 · Ndareda, Tanzania · Accident · No injuries · Closed · Sep 24, 1966 · N2169F · Substantial damage
- [NTSB OAK67F0142](https://openairdocs.org/ntsb/OAK67F0142.md): Navion A · Morgan Hill, CA · Accident · Minor injuries · Closed · Sep 24, 1966 · N91537 · Substantial damage
- [NTSB NYC67F0262](https://openairdocs.org/ntsb/NYC67F0262.md): Cessna 172D · Leesburg, VA · Accident · No injuries · Closed · Sep 24, 1966 · N2486Y · Substantial damage
- [NTSB MIA67D0182](https://openairdocs.org/ntsb/MIA67D0182.md): Cessna 150 · Lambert, MS · Accident · No injuries · Closed · Sep 22, 1966 · N7018F · Destroyed
- [NTSB MKC67F0259](https://openairdocs.org/ntsb/MKC67F0259.md): Piper PA-28 · Parkville, MO · Accident · Minor injuries · Closed · Sep 20, 1966 · N6906W · Substantial damage
- [NTSB DEN67A0023](https://openairdocs.org/ntsb/DEN67A0023.md): Cessna 182B · Green River, UT · Accident · No injuries · Closed · Sep 20, 1966 · N2365G · Substantial damage
- [NTSB OAK67D0125](https://openairdocs.org/ntsb/OAK67D0125.md): Cessna 172 · Alvarado, CA · Accident · Serious injuries · Closed · Sep 17, 1966 · N5388R · Destroyed

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

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

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