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

## Cases, newest first

- [NTSB MKC66A0007](https://openairdocs.org/ntsb/MKC66A0007.md): Piper J3C-65 · Indianola, IA · Accident · 1 fatal · Closed · Jul 27, 1965 · N38561 · Destroyed
- [NTSB ANC66D0033](https://openairdocs.org/ntsb/ANC66D0033.md): Cessna 170 · Talkeetna, AK · Accident · No injuries · Closed · Jul 27, 1965 · N2648D · Substantial damage
- [NTSB MKC66F0180](https://openairdocs.org/ntsb/MKC66F0180.md): Cessna 172 · So St Paul, MN · Accident · No injuries · Closed · Jul 26, 1965 · N7737U · Substantial damage
- [NTSB FTW66D0187](https://openairdocs.org/ntsb/FTW66D0187.md): Champion 7AC · Ada, OK · Accident · No injuries · Closed · Jul 26, 1965 · N7563E · Substantial damage
- [NTSB CHI66F0116](https://openairdocs.org/ntsb/CHI66F0116.md): Piper PA-24 · Ft Wayne, IN · Accident · No injuries · Closed · Jul 26, 1965 · N6019P · Substantial damage
- [NTSB NYC66F0076](https://openairdocs.org/ntsb/NYC66F0076.md): Cessna 172 · Kutztown, PA · Accident · No injuries · Closed · Jul 25, 1965 · N3589S · Substantial damage
- [NTSB NYC66D0132](https://openairdocs.org/ntsb/NYC66D0132.md): Cessna 150 · Deer Park, NY · Accident · No injuries · Closed · Jul 25, 1965 · N7910Z · Substantial damage
- [NTSB CHI66F0094](https://openairdocs.org/ntsb/CHI66F0094.md): Piper PA-22 · Lebanon, OH · Accident · No injuries · Closed · Jul 25, 1965 · N4915Z · Substantial damage
- [NTSB UNK65X1517](https://openairdocs.org/ntsb/UNK65X1517.md): Piper J-3 · Weibrsbrn, Georgia · Accident · 1 fatal · Closed · Jul 23, 1965 · N3416K · Destroyed
- [NTSB FTW66D0159](https://openairdocs.org/ntsb/FTW66D0159.md): Piper PA-25 · Gruver, TX · Accident · No injuries · Closed · Jul 23, 1965 · N7413Z · Substantial damage
- [NTSB DEN66A0012](https://openairdocs.org/ntsb/DEN66A0012.md): Bell 47G3B · Show Low, AZ · Accident · No injuries · Closed · Jul 23, 1965 · N73236 · Substantial damage
- [NTSB LAX66D0118](https://openairdocs.org/ntsb/LAX66D0118.md): Piper PA-23 · Thousand Oaks, CA · Accident · No injuries · Closed · Jul 21, 1965 · N4120P · Substantial damage
- [NTSB DEN66D0060](https://openairdocs.org/ntsb/DEN66D0060.md): Piper PA-28 · Saratoga, WY · Accident · No injuries · Closed · Jul 21, 1965 · N7187W · Substantial damage
- [NTSB CHI66F0118](https://openairdocs.org/ntsb/CHI66F0118.md): Aeronca 058B · Champaign, IL · Accident · No injuries · Closed · Jul 21, 1965 · N46924 · Substantial damage
- [NTSB NYC66F0113](https://openairdocs.org/ntsb/NYC66F0113.md): Piper J-3 · New Market, NJ · Accident · No injuries · Closed · Jul 20, 1965 · N42346 · Substantial damage
- [NTSB CHI66F0138](https://openairdocs.org/ntsb/CHI66F0138.md): Schweizer 2-22E · Oak Brook, IL · Accident · No injuries · Closed · Jul 20, 1965 · N684U · Substantial damage
- [NTSB MIA66A0012](https://openairdocs.org/ntsb/MIA66A0012.md): Stinson 108-3 · Oliver Sprgs, TN · Accident · 1 fatal · Closed · Jul 19, 1965 · N6773M · Destroyed
- [NTSB MKC66D0253](https://openairdocs.org/ntsb/MKC66D0253.md): Mooney M20E · West Plains, MO · Accident · Minor injuries · Closed · Jul 18, 1965 · N57430 · Destroyed
- [NTSB MIA66F0110](https://openairdocs.org/ntsb/MIA66F0110.md): Taylorcraft BC12D1 · Savannah, GA · Accident · Serious injuries · Closed · Jul 18, 1965 · N44214 · Destroyed
- [NTSB OAK66D0067](https://openairdocs.org/ntsb/OAK66D0067.md): Cessna 210 · Tracy, CA · Accident · No injuries · Closed · Jul 17, 1965 · N9572T · Substantial damage
- [NTSB MIA66F0052](https://openairdocs.org/ntsb/MIA66F0052.md): Piper PA-28 · Winston Salem, NC · Accident · No injuries · Closed · Jul 17, 1965 · N8618W · Substantial damage
- [NTSB NYC66F0128](https://openairdocs.org/ntsb/NYC66F0128.md): Beechcraft M-35 · Kenova, WV · Accident · No injuries · Closed · Jul 16, 1965 · N9303Y · Substantial damage
- [NTSB FTW66A0004](https://openairdocs.org/ntsb/FTW66A0004.md): Hughes 269A · Alamo, TX · Accident · No injuries · Closed · Jul 14, 1965 · N8725F · Substantial damage
- [NTSB DEN66A0010](https://openairdocs.org/ntsb/DEN66A0010.md): Hughes 269B · Cody, WY · Accident · No injuries · Closed · Jul 14, 1965 · N9397F · Substantial damage
- [NTSB FTW66D0292](https://openairdocs.org/ntsb/FTW66D0292.md): Cessna 180 · Villa Delcarm, Mexico · Accident · No injuries · Closed · Jul 12, 1965 · N9267C · Substantial damage
- [NTSB NYC66A0005](https://openairdocs.org/ntsb/NYC66A0005.md): Cessna 310D · 5s Mercersburg, PA · Accident · 4 fatal · Closed · Jul 11, 1965 · N6735T · Destroyed
- [NTSB NYC66A0004](https://openairdocs.org/ntsb/NYC66A0004.md): Mid Mustang M-M-1 · Elizabethville, PA · Accident · 1 fatal · Closed · Jul 11, 1965 · N8718E · Destroyed
- [NTSB MKC66F0095](https://openairdocs.org/ntsb/MKC66F0095.md): Piper PA-30 · Maple Lake, MN · Accident · No injuries · Closed · Jul 11, 1965 · N7235Y · Substantial damage
- [NTSB LAX66A0005](https://openairdocs.org/ntsb/LAX66A0005.md): Cessna 120 · Cayucos, CA · Accident · 1 fatal · Closed · Jul 11, 1965 · N1772N · Destroyed
- [NTSB CHI66D0087](https://openairdocs.org/ntsb/CHI66D0087.md): Cessna 170B · Greenfield, IN · Accident · No injuries · Closed · Jul 11, 1965 · N2738D · Substantial damage
- [NTSB CHI66A0007](https://openairdocs.org/ntsb/CHI66A0007.md): Enstrom F-28 · Marquette, MI · Accident · No injuries · Closed · Jul 11, 1965 · N40043 · Substantial damage
- [NTSB MIA66F0161](https://openairdocs.org/ntsb/MIA66F0161.md): Beechcraft E-35 · Pressman Home, TN · Accident · No injuries · Closed · Jul 10, 1965 · N3356C · Substantial damage
- [NTSB CHI66F0129](https://openairdocs.org/ntsb/CHI66F0129.md): Fairchild PT-26 · Dyer, IN · Accident · Minor injuries · Closed · Jul 10, 1965 · N79177 · Substantial damage
- [NTSB DEN66F0033](https://openairdocs.org/ntsb/DEN66F0033.md): Cessna 175 · Goldhill, UT · Accident · No injuries · Closed · Jul 9, 1965 · N8180T · Destroyed
- [NTSB ANC66D0040](https://openairdocs.org/ntsb/ANC66D0040.md): Mooney M20A · Talkeetna, AK · Accident · No injuries · Closed · Jul 9, 1965 · N1096B · Substantial damage
- [NTSB FTW66F0210](https://openairdocs.org/ntsb/FTW66F0210.md): Schweizer SGS126 · Guthrie, OK · Accident · Serious injuries · Closed · Jul 8, 1965 · N2776Z · Substantial damage
- [NTSB SEA66D0026](https://openairdocs.org/ntsb/SEA66D0026.md): Piper PA-28 · Bellvue, WA · Accident · No injuries · Closed · Jul 7, 1965 · N7394W · Substantial damage
- [NTSB FTW66A0002](https://openairdocs.org/ntsb/FTW66A0002.md): Piper J-3 · No.Little Rck, AR · Accident · 1 fatal · Closed · Jul 7, 1965 · N88371 · Substantial damage
- [NTSB DEN66D0054](https://openairdocs.org/ntsb/DEN66D0054.md): Piper PA-18A · Upton, WY · Accident · No injuries · Closed · Jul 5, 1965 · N8238P · Substantial damage
- [NTSB CHI66F0103](https://openairdocs.org/ntsb/CHI66F0103.md): Cessna 182 · Griffith, IN · Accident · No injuries · Closed · Jul 4, 1965 · N2140G · Substantial damage
- [NTSB CHI66F0079](https://openairdocs.org/ntsb/CHI66F0079.md): Piper PA-22 · Columbia, KY · Accident · No injuries · Closed · Jul 4, 1965 · N4550A · Substantial damage
- [NTSB NYC66F0056](https://openairdocs.org/ntsb/NYC66F0056.md): Miniplane DSA-1 · New Haven, CT · Accident · Minor injuries · Closed · Jul 3, 1965 · N9155R · Substantial damage
- [NTSB CHI66D0183](https://openairdocs.org/ntsb/CHI66D0183.md): Stinson 108 · Put In Bay, OH · Accident · Minor injuries · Closed · Jul 3, 1965 · N8173K · Destroyed
- [NTSB SEA66F0056](https://openairdocs.org/ntsb/SEA66F0056.md): Cessna 172 · Vancouver, WA · Accident · No injuries · Closed · Jul 2, 1965 · N8230U · Substantial damage
- [NTSB DEN66D0021](https://openairdocs.org/ntsb/DEN66D0021.md): Mooney M20D · La Jara, CO · Accident · No injuries · Closed · Jul 2, 1965 · N1222X · Substantial damage
- [NTSB FTW66F0259](https://openairdocs.org/ntsb/FTW66F0259.md): Piper PA-25 · Harlingen, TX · Accident · No injuries · Closed · Jul 1, 1965 · N6771Z · Substantial damage
- [NTSB NYC66F0092](https://openairdocs.org/ntsb/NYC66F0092.md): Piper PA23 · New Haven, CT · Accident · Serious injuries · Closed · Jun 29, 1965 · N5253Y · Destroyed
- [NTSB DEN66D0028](https://openairdocs.org/ntsb/DEN66D0028.md): Beechcraft 35 · Cuba, NM · Accident · No injuries · Closed · Jun 29, 1965 · N3008V · Destroyed
- [NTSB CHI66D0046](https://openairdocs.org/ntsb/CHI66D0046.md): Schleicher KA6CR · Lima, OH · Accident · No injuries · Closed · Jun 29, 1965 · N9437H · Substantial damage
- [NTSB NYC65A0157](https://openairdocs.org/ntsb/NYC65A0157.md): Air & Space 18A · Pocasset, MA · Accident · No injuries · Closed · Jun 28, 1965 · N6103S · Substantial damage

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

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

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