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

## Cases, newest first

- [NTSB UNK64X3830](https://openairdocs.org/ntsb/UNK64X3830.md): Cessna 170 · Princeton, ME · Accident · Serious injuries · Closed · Sep 6, 1964 · N2510V · Substantial damage
- [NTSB UNK64X3813](https://openairdocs.org/ntsb/UNK64X3813.md): Beechcraft A35 · Aurora, MO · Accident · No injuries · Closed · Sep 6, 1964 · N776B · Substantial damage
- [NTSB UNK64X3807](https://openairdocs.org/ntsb/UNK64X3807.md): Cessna 175A · Idleyld Park, OR · Accident · 1 fatal · Closed · Sep 5, 1964 · N8074T · Destroyed
- [NTSB UNK64X3802](https://openairdocs.org/ntsb/UNK64X3802.md): Mooney M20 · Huron, SD · Accident · Serious injuries · Closed · Sep 5, 1964 · N6534B · Destroyed
- [NTSB UNK64X3793](https://openairdocs.org/ntsb/UNK64X3793.md): Aeronca 7AC · Sacramento, CA · Accident · Minor injuries · Closed · Sep 5, 1964 · N83308 · Substantial damage
- [NTSB UNK64X3769](https://openairdocs.org/ntsb/UNK64X3769.md): Ercoupe 415C · Indian Head, MD · Accident · No injuries · Closed · Sep 4, 1964 · N2166H · Substantial damage
- [NTSB UNK64X3760](https://openairdocs.org/ntsb/UNK64X3760.md): Beech K35 · Orlando, FL · Accident · Serious injuries · Closed · Sep 3, 1964 · N5366E · Destroyed
- [NTSB UNK64X3751](https://openairdocs.org/ntsb/UNK64X3751.md): Cessna 180 · Circle Pines, MN · Accident · No injuries · Closed · Sep 3, 1964 · N5318D · Substantial damage
- [NTSB UNK64X3737](https://openairdocs.org/ntsb/UNK64X3737.md): Beechcraft 35-33 · Vinton, LA · Accident · 3 fatal · Closed · Sep 2, 1964 · N612V · Destroyed
- [NTSB UNK64X3736](https://openairdocs.org/ntsb/UNK64X3736.md): Cessna 210 · Salt Lake City, UT · Accident · No injuries · Closed · Sep 2, 1964 · N7347E · Substantial damage
- [NTSB UNK64X3735](https://openairdocs.org/ntsb/UNK64X3735.md): Piper PA28 · Cape May, NJ · Accident · No injuries · Closed · Sep 2, 1964 · N5707W · Substantial damage
- [NTSB UNK64X3731](https://openairdocs.org/ntsb/UNK64X3731.md): Piper PA24 · Houston, MO · Accident · No injuries · Closed · Sep 2, 1964 · N7673P · Substantial damage
- [NTSB UNK64X3721](https://openairdocs.org/ntsb/UNK64X3721.md): Callair A9 · Dewitt, AR · Accident · No injuries · Closed · Sep 1, 1964 · N9672Z · Substantial damage
- [NTSB UNK64X3714](https://openairdocs.org/ntsb/UNK64X3714.md): Piper PA22 · Kissimmee, FL · Accident · No injuries · Closed · Aug 31, 1964 · N5388Z · Substantial damage
- [NTSB UNK64X3707](https://openairdocs.org/ntsb/UNK64X3707.md): Aero Comm 520 · Taylor City, NC · Accident · No injuries · Closed · Aug 31, 1964 · N4180B · Substantial damage
- [NTSB UNK64X3682](https://openairdocs.org/ntsb/UNK64X3682.md): Cessna 180 · Childress, TX · Accident · No injuries · Closed · Aug 30, 1964 · N4530B · Substantial damage
- [NTSB UNK64X3681](https://openairdocs.org/ntsb/UNK64X3681.md): Luscombe 8A · Laveen, AZ · Accident · Minor injuries · Closed · Aug 30, 1964 · N25211 · Substantial damage
- [NTSB UNK64X3672](https://openairdocs.org/ntsb/UNK64X3672.md): Taylorcraft BC12D · Cross Keys, NJ · Accident · No injuries · Closed · Aug 29, 1964 · N5175M · Destroyed
- [NTSB UNK64X3669](https://openairdocs.org/ntsb/UNK64X3669.md): Piper J3C · Tewksbury, MA · Accident · No injuries · Closed · Aug 29, 1964 · N70399 · Substantial damage
- [NTSB UNK64X3642](https://openairdocs.org/ntsb/UNK64X3642.md): Piper PA28 · Madison, CT · Accident · No injuries · Closed · Aug 28, 1964 · N5391W · Substantial damage
- [NTSB UNK64X3638](https://openairdocs.org/ntsb/UNK64X3638.md): Piper PA22 · Gt Barrington, MA · Accident · Minor injuries · Closed · Aug 28, 1964 · N4721Z · Substantial damage
- [NTSB UNK64X3635](https://openairdocs.org/ntsb/UNK64X3635.md): Cessna P206 · Wichita, KS · Accident · 2 fatal · Closed · Aug 27, 1964 · N8464Z · Substantial damage
- [NTSB UNK64X3615](https://openairdocs.org/ntsb/UNK64X3615.md): Hughes 269B · Wilson, TX · Accident · No injuries · Closed · Aug 26, 1964 · N9306F · Substantial damage
- [NTSB UNK64X3612](https://openairdocs.org/ntsb/UNK64X3612.md): Boeing 707 331C · Kansas City, MO · Accident · No injuries · Closed · Aug 26, 1964 · N787TW · Substantial damage
- [NTSB UNK64X3611](https://openairdocs.org/ntsb/UNK64X3611.md): Piper PA-30 · Choteau, MT · Accident · 4 fatal · Closed · Aug 26, 1964 · CF-PHN · Destroyed
- [NTSB UNK64X3598](https://openairdocs.org/ntsb/UNK64X3598.md): Piper PA-28 · Chico, CA · Accident · No injuries · Closed · Aug 26, 1964 · N8646W · Destroyed
- [NTSB UNK64X3593](https://openairdocs.org/ntsb/UNK64X3593.md): Piper PA12 · Timbalier Is, LA · Accident · Serious injuries · Closed · Aug 25, 1964 · N7669H · Destroyed
- [NTSB UNK64X3586](https://openairdocs.org/ntsb/UNK64X3586.md): Piper PA23 · St Petersburg, FL · Accident · No injuries · Closed · Aug 25, 1964 · N1201P · Substantial damage
- [NTSB UNK64X3583](https://openairdocs.org/ntsb/UNK64X3583.md): Aeronca 7AC · Chiloquin, OR · Accident · Minor injuries · Closed · Aug 25, 1964 · N2266E · Destroyed
- [NTSB UNK64X3574](https://openairdocs.org/ntsb/UNK64X3574.md): Cessna 170 · Hays, KS · Accident · Minor injuries · Closed · Aug 24, 1964 · N4612C · Destroyed
- [NTSB UNK64X3570](https://openairdocs.org/ntsb/UNK64X3570.md): Cessna 170A · Paoli, IN · Accident · Serious injuries · Closed · Aug 23, 1964 · N1374D · Destroyed
- [NTSB UNK64X3565](https://openairdocs.org/ntsb/UNK64X3565.md): Cessna 182 · Bullfrog Basin, UT · Accident · No injuries · Closed · Aug 23, 1964 · N5389B · Destroyed
- [NTSB UNK64X3559](https://openairdocs.org/ntsb/UNK64X3559.md): Luscombe 8E · Orlando, FL · Accident · Minor injuries · Closed · Aug 23, 1964 · N2480K · Substantial damage
- [NTSB UNK64X3557](https://openairdocs.org/ntsb/UNK64X3557.md): Beechcraft T34 · Jesup, GA · Accident · No injuries · Closed · Aug 23, 1964 · N4946C · Substantial damage
- [NTSB UNK64X3548](https://openairdocs.org/ntsb/UNK64X3548.md): Mooney MK-20 · Seigler Spgs, CA · Accident · 1 fatal · Closed · Aug 22, 1964 · N5241B · Destroyed
- [NTSB UNK64X3545](https://openairdocs.org/ntsb/UNK64X3545.md): Beechcraft C45H · Gilbertsville, PA · Accident · Minor injuries · Closed · Aug 22, 1964 · N74838 · Substantial damage
- [NTSB UNK64X3543](https://openairdocs.org/ntsb/UNK64X3543.md): Beechcraft A55 · Baltimore, MD · Accident · No injuries · Closed · Aug 22, 1964 · N7501S · Substantial damage
- [NTSB UNK64X3538](https://openairdocs.org/ntsb/UNK64X3538.md): Stinson 108 · Marion, IA · Accident · No injuries · Closed · Aug 22, 1964 · N97656 · Substantial damage
- [NTSB UNK64X3525](https://openairdocs.org/ntsb/UNK64X3525.md): Schweizer 1-26 · Moretown, VT · Accident · 1 fatal · Closed · Aug 21, 1964 · N3832A · Substantial damage
- [NTSB UNK64X3514](https://openairdocs.org/ntsb/UNK64X3514.md): Cessna 182 · Auburn, CA · Accident · Minor injuries · Closed · Aug 21, 1964 · N2459G · Substantial damage
- [NTSB UNK64X3513](https://openairdocs.org/ntsb/UNK64X3513.md): Piper PA22 · Sheffield, TX · Accident · No injuries · Closed · Aug 21, 1964 · N8019D · Substantial damage
- [NTSB UNK64X3498](https://openairdocs.org/ntsb/UNK64X3498.md): Brantly B2B · Luling, TX · Accident · Minor injuries · Closed · Aug 20, 1964 · N2256U · Destroyed
- [NTSB UNK64X3496](https://openairdocs.org/ntsb/UNK64X3496.md): Cessna 150 · Waynesboro, VA · Accident · No injuries · Closed · Aug 20, 1964 · N7318X · Destroyed
- [NTSB UNK64X3491](https://openairdocs.org/ntsb/UNK64X3491.md): Piper PA22 · Nugent, TX · Accident · No injuries · Closed · Aug 20, 1964 · N6946D · Substantial damage
- [NTSB UNK64X3482](https://openairdocs.org/ntsb/UNK64X3482.md): Helio H-395 · Agrinion, Greece · Accident · No injuries · Closed · Aug 20, 1964 · N4199D · Substantial damage
- [NTSB UNK64X3474](https://openairdocs.org/ntsb/UNK64X3474.md): Cessna 180 · Salem, OR · Accident · No injuries · Closed · Aug 19, 1964 · N9024C · Substantial damage
- [NTSB UNK64X3471](https://openairdocs.org/ntsb/UNK64X3471.md): Ercoupe 415C · Westminister, MD · Accident · No injuries · Closed · Aug 19, 1964 · N93406 · Substantial damage
- [NTSB UNK64X3462](https://openairdocs.org/ntsb/UNK64X3462.md): Piper PA12 · Sparrevohn, AK · Accident · No injuries · Closed · Aug 18, 1964 · N2581M · Substantial damage
- [NTSB UNK64X3458](https://openairdocs.org/ntsb/UNK64X3458.md): Piper PA24 · Anna Maria, FL · Accident · No injuries · Closed · Aug 18, 1964 · N7708P · Substantial damage
- [NTSB UNK64X3450](https://openairdocs.org/ntsb/UNK64X3450.md): Piper PA-28 · Danville, VA · Accident · 1 fatal · Closed · Aug 18, 1964 · N8740W · Destroyed

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

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

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