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

## Cases, newest first

- [NTSB UNK64X0974](https://openairdocs.org/ntsb/UNK64X0974.md): Kitz Kopter D1 · Sedalia, MO · Accident · No injuries · Closed · Mar 18, 1964 · N6357X · Substantial damage
- [NTSB UNK64X0962](https://openairdocs.org/ntsb/UNK64X0962.md): Ercoupe 415C · Red Bay, AL · Accident · Minor injuries · Closed · Mar 17, 1964 · N3535H · Destroyed
- [NTSB UNK64X0950](https://openairdocs.org/ntsb/UNK64X0950.md): Piper PA24 · Mt Holly, NC · Accident · No injuries · Closed · Mar 16, 1964 · N5548P · Substantial damage
- [NTSB UNK64X0949](https://openairdocs.org/ntsb/UNK64X0949.md): Cessna 172 · Moorehead, KY · Accident · No injuries · Closed · Mar 16, 1964 · N8342B · Destroyed
- [NTSB UNK64X0940](https://openairdocs.org/ntsb/UNK64X0940.md): Luscombe 8A · Deland, FL · Accident · No injuries · Closed · Mar 15, 1964 · N1139K · Substantial damage
- [NTSB UNK64X0919](https://openairdocs.org/ntsb/UNK64X0919.md): Cessna 120 · Indian Grove, MO · Accident · 1 fatal · Closed · Mar 15, 1964 · N2860N · Destroyed
- [NTSB UNK64X0897](https://openairdocs.org/ntsb/UNK64X0897.md): Hughes 269A · Bandera, TX · Accident · No injuries · Closed · Mar 13, 1964 · N8791F · Substantial damage
- [NTSB UNK64X0890](https://openairdocs.org/ntsb/UNK64X0890.md): Douglas DC-3C · Miles City, MT · Accident · 5 fatal · Closed · Mar 12, 1964 · N61442 · Destroyed
- [NTSB UNK64X0878](https://openairdocs.org/ntsb/UNK64X0878.md): Douglas DC-8 · Philadelphia, PA · Incident · No injuries · Closed · Mar 11, 1964 · N80610 · No damage
- [NTSB UNK64X0867](https://openairdocs.org/ntsb/UNK64X0867.md): Bell 47G · Grand Isle, LA · Accident · 2 fatal · Closed · Mar 10, 1964 · N994B · Destroyed
- [NTSB UNK64X0866](https://openairdocs.org/ntsb/UNK64X0866.md): Douglas DC-4 · Boston, MA · Accident · 3 fatal · Closed · Mar 10, 1964 · N384 · Destroyed
- [NTSB UNK64X0860](https://openairdocs.org/ntsb/UNK64X0860.md): Cessna 175 · Dallas, TX · Accident · No injuries · Closed · Mar 9, 1964 · N9442B · Substantial damage
- [NTSB UNK64X0841](https://openairdocs.org/ntsb/UNK64X0841.md): Douglas DC-3A · Chicago, IL · Accident · 1 fatal · Closed · Mar 8, 1964 · N410D · Substantial damage
- [NTSB UNK64X0838](https://openairdocs.org/ntsb/UNK64X0838.md): Beech J35 · Trumann, AR · Accident · No injuries · Closed · Mar 7, 1964 · N8379D · Substantial damage
- [NTSB UNK64X0833](https://openairdocs.org/ntsb/UNK64X0833.md): Pratt Reed G1 · Elsinore, CA · Accident · No injuries · Closed · Mar 7, 1964 · N87610 · Substantial damage
- [NTSB UNK64X0830](https://openairdocs.org/ntsb/UNK64X0830.md): Piper PA18 · Brodheadsville, PA · Accident · No injuries · Closed · Mar 7, 1964 · N4065Z · Substantial damage
- [NTSB UNK64X0817](https://openairdocs.org/ntsb/UNK64X0817.md): Bell P63 · Mercedes, TX · Accident · Minor injuries · Closed · Mar 6, 1964 · N9004R · Destroyed
- [NTSB UNK64X0795](https://openairdocs.org/ntsb/UNK64X0795.md): Cessna 310H · Lake Jackson Tex, TX · Accident · 1 fatal · Closed · Mar 3, 1964 · N1128Q · Destroyed
- [NTSB UNK64X0788](https://openairdocs.org/ntsb/UNK64X0788.md): Lockheed L-049 · Zephyr Cove, NV · Accident · 85 fatal · Closed · Mar 1, 1964 · N86504 · Destroyed
- [NTSB UNK64X0786](https://openairdocs.org/ntsb/UNK64X0786.md): Piper PA24 · El Paso, TX · Accident · Serious injuries · Closed · Mar 1, 1964 · N8025P · Substantial damage
- [NTSB UNK64X0780](https://openairdocs.org/ntsb/UNK64X0780.md): Piper PA28 · Skaneateles, NY · Accident · No injuries · Closed · Mar 1, 1964 · N7596W · Substantial damage
- [NTSB UNK64X0771](https://openairdocs.org/ntsb/UNK64X0771.md): Beechcraft 23 · Kahului, HI · Accident · No injuries · Closed · Mar 1, 1964 · N2354Z · Substantial damage
- [NTSB UNK64X0761](https://openairdocs.org/ntsb/UNK64X0761.md): Piper PA22 · Newburg, MD · Accident · No injuries · Closed · Feb 29, 1964 · N5680Z · Substantial damage
- [NTSB UNK64X0758](https://openairdocs.org/ntsb/UNK64X0758.md): Cessna 170 · St Joseph, MO · Accident · No injuries · Closed · Feb 29, 1964 · N3492C · Substantial damage
- [NTSB UNK64X0756](https://openairdocs.org/ntsb/UNK64X0756.md): Aeronca 7AC · San Jose, CA · Accident · No injuries · Closed · Feb 29, 1964 · N82183 · Substantial damage
- [NTSB UNK64X0734](https://openairdocs.org/ntsb/UNK64X0734.md): Piper PA28 · Ogden, UT · Accident · No injuries · Closed · Feb 28, 1964 · N8559W · Substantial damage
- [NTSB UNK64X0726](https://openairdocs.org/ntsb/UNK64X0726.md): Cessna 172B · Harrisonville, MO · Accident · No injuries · Closed · Feb 28, 1964 · N7599X · Substantial damage
- [NTSB UNK64X0709](https://openairdocs.org/ntsb/UNK64X0709.md): Beechcraft A35 · Wadsworth, OH · Accident · No injuries · Closed · Feb 27, 1964 · N8666A · Substantial damage
- [NTSB UNK64X0666](https://openairdocs.org/ntsb/UNK64X0666.md): Piper PA22 · Meriden, CT · Accident · Minor injuries · Closed · Feb 22, 1964 · N5589Z · Substantial damage
- [NTSB UNK64X0663](https://openairdocs.org/ntsb/UNK64X0663.md): Piper J3C · Garland, KS · Accident · Minor injuries · Closed · Feb 22, 1964 · N3557N · Destroyed
- [NTSB UNK64X0653](https://openairdocs.org/ntsb/UNK64X0653.md): Piper PA25 · Latrobe, PA · Accident · No injuries · Closed · Feb 22, 1964 · N6935Z · Substantial damage
- [NTSB UNK64X0646](https://openairdocs.org/ntsb/UNK64X0646.md): Cessna 150 · Albuquerque, NM · Accident · No injuries · Closed · Feb 22, 1964 · N4124U · 2 aircraft · Substantial damage
- [NTSB UNK64X0645](https://openairdocs.org/ntsb/UNK64X0645.md): Cessna 172 · Ambler, PA · Accident · No injuries · Closed · Feb 22, 1964 · N7672X · Substantial damage
- [NTSB UNK64X0608](https://openairdocs.org/ntsb/UNK64X0608.md): Ercoupe 145C · Honolulu, HI · Accident · No injuries · Closed · Feb 19, 1964 · N3645H · Substantial damage
- [NTSB UNK64X0592](https://openairdocs.org/ntsb/UNK64X0592.md): Luscombe 8A · Quartz Hill, CA · Accident · 1 fatal · Closed · Feb 17, 1964 · N28440 · Destroyed
- [NTSB UNK64X0573](https://openairdocs.org/ntsb/UNK64X0573.md): Cessna 180 · Kasigluk, AK · Accident · No injuries · Closed · Feb 15, 1964 · N7741A · Substantial damage
- [NTSB UNK64X0562](https://openairdocs.org/ntsb/UNK64X0562.md): Aeronca 7AC · Dallas, TX · Accident · No injuries · Closed · Feb 14, 1964 · N84192 · Substantial damage
- [NTSB UNK64X0559](https://openairdocs.org/ntsb/UNK64X0559.md): Cessna 140 · Lagrange, NC · Accident · Serious injuries · Closed · Feb 13, 1964 · N72836 · Destroyed
- [NTSB UNK64X0533](https://openairdocs.org/ntsb/UNK64X0533.md): Cessna 172 · Watkins, CO · Accident · No injuries · Closed · Feb 11, 1964 · N8195X · Substantial damage
- [NTSB UNK64X0507](https://openairdocs.org/ntsb/UNK64X0507.md): Piper PA24 · Dallas, TX · Accident · 1 fatal · Closed · Feb 9, 1964 · N5692P · Destroyed
- [NTSB UNK64X0475](https://openairdocs.org/ntsb/UNK64X0475.md): Schweizer TG3A · Fremont, CA · Accident · Serious injuries · Closed · Feb 6, 1964 · N68267 · Destroyed
- [NTSB UNK64X0468](https://openairdocs.org/ntsb/UNK64X0468.md): Cessna 182 · Northbrook, IL · Accident · No injuries · Closed · Feb 5, 1964 · N5547B · Substantial damage
- [NTSB UNK64X0450](https://openairdocs.org/ntsb/UNK64X0450.md): Brantly B2 · Lyons, PA · Accident · 1 fatal · Closed · Feb 3, 1964 · N5960X · Destroyed
- [NTSB UNK64X0433](https://openairdocs.org/ntsb/UNK64X0433.md): Waco UPF7 · San Fernand, CA · Accident · Minor injuries · Closed · Feb 2, 1964 · N20971 · Substantial damage
- [NTSB UNK64X0422](https://openairdocs.org/ntsb/UNK64X0422.md): Cessna 150 · Ringwood, IL · Accident · No injuries · Closed · Feb 1, 1964 · N5511E · Substantial damage
- [NTSB UNK64X0413](https://openairdocs.org/ntsb/UNK64X0413.md): Stinson 108-3 · Silver City, NC · Accident · Minor injuries · Closed · Jan 31, 1964 · N651C · Substantial damage
- [NTSB UNK64X0402](https://openairdocs.org/ntsb/UNK64X0402.md): Beechcraft A55 · Kansas City, MO · Accident · No injuries · Closed · Jan 30, 1964 · N1420G · Substantial damage
- [NTSB UNK64X0385](https://openairdocs.org/ntsb/UNK64X0385.md): Aero Comm 500 · Nashville, TN · Accident · Minor injuries · Closed · Jan 28, 1964 · N3830C · Substantial damage
- [NTSB UNK64X0374](https://openairdocs.org/ntsb/UNK64X0374.md): Cessna 175 · Santa Rosa, CA · Accident · No injuries · Closed · Jan 26, 1964 · N6756E · Substantial damage
- [NTSB UNK64X0364](https://openairdocs.org/ntsb/UNK64X0364.md): Champion 7EC · Slidell, LA · Accident · No injuries · Closed · Jan 26, 1964 · N7506B · Substantial damage

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

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

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