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

## Cases, newest first

- [NTSB CHI66F0065](https://openairdocs.org/ntsb/CHI66F0065.md): Cessna 180 · Marysville, MI · Accident · Minor injuries · Closed · Jun 28, 1965 · N513J · Destroyed
- [NTSB CHI66F0047](https://openairdocs.org/ntsb/CHI66F0047.md): No American SNJ-5 · Hales Corner, WI · Accident · Minor injuries · Closed · Jun 28, 1965 · N3262G · Substantial damage
- [NTSB NYC66D0059](https://openairdocs.org/ntsb/NYC66D0059.md): Cessna 140 · Odenton, MD · Accident · Minor injuries · Closed · Jun 27, 1965 · N72455 · Destroyed
- [NTSB NYC65A0156](https://openairdocs.org/ntsb/NYC65A0156.md): Cessna 170 · Neffsville, PA · Accident · 1 fatal · Closed · Jun 27, 1965 · N4080V · 2 aircraft · Minor damage
- [NTSB MKC66F0124](https://openairdocs.org/ntsb/MKC66F0124.md): Cessna 150 · Hatton, ND · Accident · No injuries · Closed · Jun 27, 1965 · N2074Z · Substantial damage
- [NTSB MIA66F0072](https://openairdocs.org/ntsb/MIA66F0072.md): Cessna 310 · W Palm Beach, FL · Accident · 2 fatal · Closed · Jun 26, 1965 · N5215A · Destroyed
- [NTSB FTW66F0163](https://openairdocs.org/ntsb/FTW66F0163.md): Piper PA-25 · Perryton, TX · Accident · No injuries · Closed · Jun 26, 1965 · N6675Z · Substantial damage
- [NTSB FTW66F0162](https://openairdocs.org/ntsb/FTW66F0162.md): Piper PA-28 · Tulsa, OK · Accident · No injuries · Closed · Jun 26, 1965 · N5786W · Substantial damage
- [NTSB DEN66D0057](https://openairdocs.org/ntsb/DEN66D0057.md): Bellanca 14-19 · Ft Grant, AZ · Accident · No injuries · Closed · Jun 26, 1965 · N6575N · Substantial damage
- [NTSB CHI66F0141](https://openairdocs.org/ntsb/CHI66F0141.md): Comonwealth 7000 · Sparta, WI · Accident · Serious injuries · Closed · Jun 26, 1965 · N20734 · Substantial damage
- [NTSB CHI66D0020](https://openairdocs.org/ntsb/CHI66D0020.md): Cessna 172 · Cleveland, OH · Accident · No injuries · Closed · Jun 26, 1965 · N16QB · Substantial damage
- [NTSB MKC66F0088](https://openairdocs.org/ntsb/MKC66F0088.md): Piper PA-28 · Newton, IA · Accident · No injuries · Closed · Jun 25, 1965 · N6588W · Substantial damage
- [NTSB DEN65A0084](https://openairdocs.org/ntsb/DEN65A0084.md): Bell B-47G3 · 10sw Payson, AZ · Accident · No injuries · Closed · Jun 25, 1965 · N6788D · Substantial damage
- [NTSB MKC66F0040](https://openairdocs.org/ntsb/MKC66F0040.md): Scheibe L-SPAT · Frankfort, MI · Accident · No injuries · Closed · Jun 24, 1965 · N5581A · Substantial damage
- [NTSB CHI66D0134](https://openairdocs.org/ntsb/CHI66D0134.md): Schleicher K7 · Jefferson, OH · Accident · Minor injuries · Closed · Jun 24, 1965 · N4700G · Substantial damage
- [NTSB UNK65X1505](https://openairdocs.org/ntsb/UNK65X1505.md): Piper PA-22 · Hamilton, NY · Accident · No injuries · Closed · Jun 23, 1965 · N5621Z · Substantial damage
- [NTSB OAK65A0074](https://openairdocs.org/ntsb/OAK65A0074.md): Hiller UH-12E · Mammoth Lakes, CA · Accident · No injuries · Closed · Jun 22, 1965 · N44B · Substantial damage
- [NTSB UNK65X1504](https://openairdocs.org/ntsb/UNK65X1504.md): Champion 7FC · Lake Wales, FL · Accident · No injuries · Closed · Jun 20, 1965 · N7582E · Substantial damage
- [NTSB SEA66D0017](https://openairdocs.org/ntsb/SEA66D0017.md): Cessna 180 · Cascade, ID · Accident · No injuries · Closed · Jun 20, 1965 · N1693C · Destroyed
- [NTSB MIA65A0124](https://openairdocs.org/ntsb/MIA65A0124.md): Cessna 172 · Toccoa, GA · Accident · 3 fatal · Closed · Jun 19, 1965 · N4253F · Destroyed
- [NTSB DEN65A0083](https://openairdocs.org/ntsb/DEN65A0083.md): Beechcraft T-34 · Albuquerque, NM · Accident · 2 fatal · Closed · Jun 19, 1965 · N12269 · Destroyed
- [NTSB CHI66F0121](https://openairdocs.org/ntsb/CHI66F0121.md): Piper PA-24 · Helmsburg, IN · Accident · Minor injuries · Closed · Jun 19, 1965 · N6306P · Substantial damage
- [NTSB SEA66F0057](https://openairdocs.org/ntsb/SEA66F0057.md): Fairchild M62C · Homedale, ID · Accident · No injuries · Closed · Jun 18, 1965 · N56110 · Substantial damage
- [NTSB NYC66F0040](https://openairdocs.org/ntsb/NYC66F0040.md): Piper PA-24 · Fishers Island, NY · Accident · No injuries · Closed · Jun 17, 1965 · N7656P · Substantial damage
- [NTSB UNK65X1503](https://openairdocs.org/ntsb/UNK65X1503.md): Bell 47G · Nassau, Burkina Faso · Accident · No injuries · Closed · Jun 16, 1965 · N940B · Substantial damage
- [NTSB CHI66D0069](https://openairdocs.org/ntsb/CHI66D0069.md): Cessna 140 · Clay City, IN · Accident · No injuries · Closed · Jun 16, 1965 · N2446N · Substantial damage
- [NTSB LAX66F0040](https://openairdocs.org/ntsb/LAX66F0040.md): Cessna 140 · Torrance, CA · Accident · Minor injuries · Closed · Jun 14, 1965 · N89413 · Substantial damage
- [NTSB NYC65I0149](https://openairdocs.org/ntsb/NYC65I0149.md): Douglas DC-6 · Buffalo, NY · Incident · No injuries · Closed · Jun 13, 1965 · N90731 · Minor damage
- [NTSB CHI66F0018](https://openairdocs.org/ntsb/CHI66F0018.md): Swift GC1B · Versailles, OH · Accident · Minor injuries · Closed · Jun 13, 1965 · N2355B · Substantial damage
- [NTSB NYC66D0016](https://openairdocs.org/ntsb/NYC66D0016.md): Piper PA-28 · Herrings, NY · Accident · Minor injuries · Closed · Jun 12, 1965 · N8681W · Destroyed
- [NTSB OAK65A0072](https://openairdocs.org/ntsb/OAK65A0072.md): Beechcraft B-95 · Hayward, CA · Accident · 1 fatal · Closed · Jun 11, 1965 · N956T · Destroyed
- [NTSB UNK65X1498](https://openairdocs.org/ntsb/UNK65X1498.md): Cessna 150 · Cincinnati, OH · Accident · No injuries · Closed · Jun 9, 1965 · N3014J · Substantial damage
- [NTSB CHI66F0206](https://openairdocs.org/ntsb/CHI66F0206.md): Cessna 140 · Joliet, IL · Accident · No injuries · Closed · Jun 9, 1965 · N2353V · Substantial damage
- [NTSB CHI66F0023](https://openairdocs.org/ntsb/CHI66F0023.md): Piper PA-18 · Columbus, OH · Accident · Minor injuries · Closed · Jun 9, 1965 · N4076A · Substantial damage
- [NTSB DEN65D0007](https://openairdocs.org/ntsb/DEN65D0007-177980.md): Piper PA-28 · Tucson, AZ · Accident · No injuries · Closed · Jun 7, 1965 · N6032W · Destroyed
- [NTSB MIA66F0075](https://openairdocs.org/ntsb/MIA66F0075.md): Cessna 182 · Stockbridge, GA · Accident · Minor injuries · Closed · Jun 6, 1965 · N4913D · Substantial damage
- [NTSB LAX66F0002](https://openairdocs.org/ntsb/LAX66F0002.md): Piper PA-18A · Minden, NV · Accident · Minor injuries · Closed · Jun 5, 1965 · N1630A · Substantial damage
- [NTSB ANC65D0016](https://openairdocs.org/ntsb/ANC65D0016.md): Cessna 150 · Nenana, AK · Accident · No injuries · Closed · Jun 5, 1965 · N7116X · Substantial damage
- [NTSB SEA65F0073](https://openairdocs.org/ntsb/SEA65F0073.md): Stinson 108-2 · Oregon City, OR · Accident · Minor injuries · Closed · Jun 4, 1965 · N893D · Destroyed
- [NTSB OAK65D0070](https://openairdocs.org/ntsb/OAK65D0070.md): Cessna 180 · Badger, CA · Accident · No injuries · Closed · Jun 4, 1965 · N2829D · Substantial damage
- [NTSB MIA65F0114](https://openairdocs.org/ntsb/MIA65F0114.md): Cessna 140 · Bessemer, AL · Accident · No injuries · Closed · Jun 4, 1965 · N3563V · Substantial damage
- [NTSB FTW65A0123](https://openairdocs.org/ntsb/FTW65A0123.md): Hughes 269B · La Feria, TX · Accident · No injuries · Closed · Jun 4, 1965 · N9370F · Substantial damage
- [NTSB SEA66F0016](https://openairdocs.org/ntsb/SEA66F0016.md): Piper PA30 · Mckenzie Brij, OR · Accident · Serious injuries · Closed · May 31, 1965 · N7466Y · Destroyed
- [NTSB SEA66F0007](https://openairdocs.org/ntsb/SEA66F0007.md): Ryan ST-A · Olympia, WA · Accident · Serious injuries · Closed · May 31, 1965 · N18923 · Substantial damage
- [NTSB NYC66F0050](https://openairdocs.org/ntsb/NYC66F0050.md): Navion A · Bridgeport, NJ · Accident · Serious injuries · Closed · May 31, 1965 · N4611K · Substantial damage
- [NTSB CHI65A0098](https://openairdocs.org/ntsb/CHI65A0098.md): Cessna 182 · Indianapolis, IN · Accident · 2 fatal · Closed · May 31, 1965 · N3126U · Destroyed
- [NTSB NYC66D0062](https://openairdocs.org/ntsb/NYC66D0062.md): Piper PA-12 · Neptune, NJ · Accident · No injuries · Closed · May 30, 1965 · N3413M · Substantial damage
- [NTSB FTW66F0086](https://openairdocs.org/ntsb/FTW66F0086.md): Mooney M18C · Piedmont, OK · Accident · No injuries · Closed · May 30, 1965 · N492M · Substantial damage
- [NTSB CHI66F0025](https://openairdocs.org/ntsb/CHI66F0025.md): Cessna 172C · Ft Wayne, IN · Accident · No injuries · Closed · May 30, 1965 · N8442X · Substantial damage
- [NTSB SEA66F0004](https://openairdocs.org/ntsb/SEA66F0004.md): Schweizer SGSI26 · Richland, WA · Accident · No injuries · Closed · May 29, 1965 · N8650R · Substantial damage

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

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

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