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

## Cases, newest first

- [NTSB UNK64X3449](https://openairdocs.org/ntsb/UNK64X3449.md): Aeronca 7AC · Plainfield, CT · Accident · Serious injuries · Closed · Aug 18, 1964 · N33P · Destroyed
- [NTSB UNK64X3448](https://openairdocs.org/ntsb/UNK64X3448.md): Aeronca 7AC · Mcdougal, AR · Accident · Serious injuries · Closed · Aug 18, 1964 · N83306 · Destroyed
- [NTSB UNK64X3433](https://openairdocs.org/ntsb/UNK64X3433.md): Beech 35-33 · South Plainfld, NJ · Accident · 2 fatal · Closed · Aug 16, 1964 · N290AA · Destroyed
- [NTSB UNK64X3422](https://openairdocs.org/ntsb/UNK64X3422.md): Cessna 170 · East Bethel, MN · Accident · No injuries · Closed · Aug 16, 1964 · N1242D · Destroyed
- [NTSB UNK64X3410](https://openairdocs.org/ntsb/UNK64X3410.md): Cessna 170B · Port Jefferson, NY · Accident · No injuries · Closed · Aug 16, 1964 · N2220D · Substantial damage
- [NTSB UNK64X3366](https://openairdocs.org/ntsb/UNK64X3366.md): Piper PA24 · Isle Of Palms, SC · Accident · Minor injuries · Closed · Aug 13, 1964 · N5854P · Destroyed
- [NTSB UNK64X3360](https://openairdocs.org/ntsb/UNK64X3360.md): Piper PA28 · Plymouth, NH · Accident · Minor injuries · Closed · Aug 13, 1964 · N7029W · Destroyed
- [NTSB UNK64X3337](https://openairdocs.org/ntsb/UNK64X3337.md): Cessna 150 · St Charles, MO · Accident · Minor injuries · Closed · Aug 12, 1964 · N4310U · Destroyed
- [NTSB UNK64X3333](https://openairdocs.org/ntsb/UNK64X3333.md): Piper PA11 · Moscow, ID · Accident · Minor injuries · Closed · Aug 11, 1964 · N4546M · Destroyed
- [NTSB UNK64X3324](https://openairdocs.org/ntsb/UNK64X3324.md): Hughes 269B · Las Vegas, NV · Accident · No injuries · Closed · Aug 10, 1964 · N9308F · Substantial damage
- [NTSB UNK64X3320](https://openairdocs.org/ntsb/UNK64X3320.md): Piper PA22 · Drewsey, OR · Accident · Minor injuries · Closed · Aug 10, 1964 · N4871Z · Substantial damage
- [NTSB UNK64X3303](https://openairdocs.org/ntsb/UNK64X3303.md): Schweizer 222 · Fairfield, NJ · Accident · No injuries · Closed · Aug 9, 1964 · N91842 · Destroyed
- [NTSB UNK64X3297](https://openairdocs.org/ntsb/UNK64X3297.md): Beechcraft 23 · Lander, WY · Accident · No injuries · Closed · Aug 9, 1964 · N2334J · Substantial damage
- [NTSB UNK64X3294](https://openairdocs.org/ntsb/UNK64X3294.md): Stinson 108-2 · Martin, SD · Accident · No injuries · Closed · Aug 9, 1964 · N150C · Substantial damage
- [NTSB UNK64X3277](https://openairdocs.org/ntsb/UNK64X3277.md): Piper PA22 · East Tawas, MI · Accident · No injuries · Closed · Aug 8, 1964 · N2969Z · Destroyed
- [NTSB UNK64X3268](https://openairdocs.org/ntsb/UNK64X3268.md): Beechcraft M23 · Carpenteria, CA · Accident · No injuries · Closed · Aug 8, 1964 · N23811 · Substantial damage
- [NTSB UNK64X3262](https://openairdocs.org/ntsb/UNK64X3262.md): Piper PA16 · Arvin, CA · Accident · Serious injuries · Closed · Aug 7, 1964 · N5792H · Destroyed
- [NTSB UNK64X3257](https://openairdocs.org/ntsb/UNK64X3257.md): Beechcraft E35 · Pauma Valley, CA · Accident · No injuries · Closed · Aug 7, 1964 · N3218C · Substantial damage
- [NTSB UNK64X3247](https://openairdocs.org/ntsb/UNK64X3247.md): Cessna 170 · San Jose, CA · Accident · No injuries · Closed · Aug 6, 1964 · N4273V · 2 aircraft · Minor damage
- [NTSB UNK64X3244](https://openairdocs.org/ntsb/UNK64X3244.md): Brantly B2B · Borden, IN · Accident · Minor injuries · Closed · Aug 6, 1964 · N2190U · Substantial damage
- [NTSB UNK64X3238](https://openairdocs.org/ntsb/UNK64X3238.md): Aeronca 11AC · Eagle River, AK · Accident · No injuries · Closed · Aug 6, 1964 · N3178E · Substantial damage
- [NTSB UNK64X3228](https://openairdocs.org/ntsb/UNK64X3228.md): Cessna 182 · Stow, OH · Accident · No injuries · Closed · Aug 5, 1964 · N5464B · Substantial damage
- [NTSB UNK64X3227](https://openairdocs.org/ntsb/UNK64X3227.md): Cessna 172 · Ft Pierce, FL · Accident · No injuries · Closed · Aug 5, 1964 · N6146E · Substantial damage
- [NTSB UNK64X3208](https://openairdocs.org/ntsb/UNK64X3208.md): Piper J3 · Wheeling, IL · Accident · Minor injuries · Closed · Aug 4, 1964 · N70154 · Destroyed
- [NTSB UNK64X3202](https://openairdocs.org/ntsb/UNK64X3202.md): Fairchild C82 · Granite Mt, AK · Accident · No injuries · Closed · Aug 3, 1964 · N4829V · Destroyed
- [NTSB UNK64X3199](https://openairdocs.org/ntsb/UNK64X3199.md): Schweizer 222E · Jefferson, IN · Accident · No injuries · Closed · Aug 3, 1964 · N8679R · Substantial damage
- [NTSB UNK64X3188](https://openairdocs.org/ntsb/UNK64X3188.md): Piper PA-18 · Willow, AK · Accident · 3 fatal · Closed · Aug 2, 1964 · N6015Z · Destroyed
- [NTSB UNK64X3185](https://openairdocs.org/ntsb/UNK64X3185.md): Hughes 269A · Oconomowoc Lk, WI · Accident · No injuries · Closed · Aug 2, 1964 · N8924F · Substantial damage
- [NTSB UNK64X3183](https://openairdocs.org/ntsb/UNK64X3183.md): Piper PA22 · Wheeling, IL · Accident · No injuries · Closed · Aug 2, 1964 · N5602Z · Substantial damage
- [NTSB UNK64X3180](https://openairdocs.org/ntsb/UNK64X3180.md): Piper J3 · Berea, KY · Accident · Minor injuries · Closed · Aug 2, 1964 · N40909 · Destroyed
- [NTSB UNK64X3174](https://openairdocs.org/ntsb/UNK64X3174.md): Stinson 108 · Ashfork, AZ · Accident · No injuries · Closed · Aug 2, 1964 · N97623 · Substantial damage
- [NTSB UNK64X3163](https://openairdocs.org/ntsb/UNK64X3163.md): Aeronca 7AC · Bartlett, IL · Accident · Minor injuries · Closed · Aug 2, 1964 · N4431E · Destroyed
- [NTSB UNK64X3134](https://openairdocs.org/ntsb/UNK64X3134.md): Cessna 172 · Thousand Is, NY · Accident · Minor injuries · Closed · Jul 31, 1964 · N6803X · Substantial damage
- [NTSB UNK64X3133](https://openairdocs.org/ntsb/UNK64X3133.md): Beechcraft M35 · Arcadia, FL · Accident · No injuries · Closed · Jul 31, 1964 · N9597R · Substantial damage
- [NTSB UNK64X3103](https://openairdocs.org/ntsb/UNK64X3103.md): Cessna 120 · Laporte City, IA · Accident · No injuries · Closed · Jul 29, 1964 · N2081V · Substantial damage
- [NTSB UNK64X3092](https://openairdocs.org/ntsb/UNK64X3092.md): Home Built BJ1 · Lakeport, CA · Accident · Serious injuries · Closed · Jul 28, 1964 · N88985 · Substantial damage
- [NTSB UNK64X3089](https://openairdocs.org/ntsb/UNK64X3089.md): Piper PA24 · Chicago, IL · Accident · No injuries · Closed · Jul 28, 1964 · N5826P · Substantial damage
- [NTSB UNK64X3088](https://openairdocs.org/ntsb/UNK64X3088.md): Cessna 320 · Peoria, IL · Accident · No injuries · Closed · Jul 28, 1964 · N5716X · Substantial damage
- [NTSB UNK64X3087](https://openairdocs.org/ntsb/UNK64X3087.md): Beechcraft 35 · Ulysses, KS · Accident · No injuries · Closed · Jul 28, 1964 · N3211V · Substantial damage
- [NTSB UNK64X3069](https://openairdocs.org/ntsb/UNK64X3069.md): Beech K35 · Bismark, ND · Accident · No injuries · Closed · Jul 27, 1964 · N6099E · Substantial damage
- [NTSB UNK64X3066](https://openairdocs.org/ntsb/UNK64X3066.md): Piper PA22 · Liberty, NC · Accident · No injuries · Closed · Jul 27, 1964 · N3962P · Destroyed
- [NTSB UNK64X3055](https://openairdocs.org/ntsb/UNK64X3055.md): Swift GC1B · Meridian Colo, MS · Accident · Serious injuries · Closed · Jul 26, 1964 · N2346B · Destroyed
- [NTSB UNK64X3044](https://openairdocs.org/ntsb/UNK64X3044.md): Stinson 108-2 · Woonsocket, RI · Accident · No injuries · Closed · Jul 26, 1964 · N875D · Substantial damage
- [NTSB UNK64X3043](https://openairdocs.org/ntsb/UNK64X3043.md): Piper PA23 · Albuquerque, NM · Accident · Minor injuries · Closed · Jul 25, 1964 · N5268Y · Substantial damage
- [NTSB UNK64X3039](https://openairdocs.org/ntsb/UNK64X3039.md): Champion 7FC · Dayton, OH · Accident · No injuries · Closed · Jul 25, 1964 · N8951R · Substantial damage
- [NTSB UNK64X3029](https://openairdocs.org/ntsb/UNK64X3029.md): Cessna 140 · Schoolcraft, MI · Accident · Minor injuries · Closed · Jul 25, 1964 · N3626V · Destroyed
- [NTSB UNK64X3027](https://openairdocs.org/ntsb/UNK64X3027.md): Hughes 269A · Bowman, SC · Accident · No injuries · Closed · Jul 25, 1964 · N8828F · Substantial damage
- [NTSB UNK64X3019](https://openairdocs.org/ntsb/UNK64X3019.md): Champion 7EC · Guymon, OK · Accident · No injuries · Closed · Jul 25, 1964 · N8954B · Substantial damage
- [NTSB UNK64X3007](https://openairdocs.org/ntsb/UNK64X3007.md): Cessna 172 · Fairbury, IL · Accident · Minor injuries · Closed · Jul 24, 1964 · N2816S · Destroyed
- [NTSB UNK64X3001](https://openairdocs.org/ntsb/UNK64X3001.md): Bensen B8M · Three Rivers, MI · Accident · Minor injuries · Closed · Jul 24, 1964 · N4655T · Substantial damage

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

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

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