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

## Cases, newest first

- [NTSB CHI66F0027](https://openairdocs.org/ntsb/CHI66F0027.md): Cessna 140 · Ramsey, IN · Accident · No injuries · Closed · May 29, 1965 · N76735 · Substantial damage
- [NTSB SEA66F0011](https://openairdocs.org/ntsb/SEA66F0011.md): Schweizer 2-22E · Eugene, OR · Accident · Minor injuries · Closed · May 28, 1965 · N8691R · Substantial damage
- [NTSB FTW66D0229](https://openairdocs.org/ntsb/FTW66D0229.md): Piper PA-22 · Oklahoma Cty, OK · Accident · No injuries · Closed · May 27, 1965 · N4842A · Substantial damage
- [NTSB MKC65F0143](https://openairdocs.org/ntsb/MKC65F0143.md): Piper PA-20 · Emporia, KS · Accident · Minor injuries · Closed · May 26, 1965 · N1560A · Destroyed
- [NTSB MIA66F0011](https://openairdocs.org/ntsb/MIA66F0011.md): Piper PA-24 · St Petersburg, FL · Accident · No injuries · Closed · May 26, 1965 · N7488P · Substantial damage
- [NTSB MIA65F0122](https://openairdocs.org/ntsb/MIA65F0122.md): Cessna 172 · Tampa, FL · Accident · Minor injuries · Closed · May 26, 1965 · N7392A · Substantial damage
- [NTSB NYC66D0018](https://openairdocs.org/ntsb/NYC66D0018.md): Cessna 172 · Hillsboro, WV · Accident · No injuries · Closed · May 24, 1965 · N8774B · Substantial damage
- [NTSB MKC66F0021](https://openairdocs.org/ntsb/MKC66F0021.md): Cessna 182 · Kansas City, MO · Accident · Serious injuries · Closed · May 24, 1965 · N4748D · Destroyed
- [NTSB MIA66F0003](https://openairdocs.org/ntsb/MIA66F0003.md): Beechcraft 35 · Northport, AL · Accident · Serious injuries · Closed · May 23, 1965 · N4505V · Destroyed
- [NTSB MIA65F0121](https://openairdocs.org/ntsb/MIA65F0121.md): Schweitzer SGS126 · Titusville, FL · Accident · Serious injuries · Closed · May 23, 1965 · N12W · Substantial damage
- [NTSB MKC66D0018](https://openairdocs.org/ntsb/MKC66D0018.md): Luscombe 8A · Mosby, MO · Accident · Minor injuries · Closed · May 22, 1965 · N1119K · Substantial damage
- [NTSB FTW66F0078](https://openairdocs.org/ntsb/FTW66F0078.md): Cessna 180 · Sabinal, TX · Accident · Minor injuries · Closed · May 22, 1965 · N2271C · Destroyed
- [NTSB FTW66F0027](https://openairdocs.org/ntsb/FTW66F0027.md): Piper PA-23 · Little Rock, AR · Accident · No injuries · Closed · May 21, 1965 · N4020P · Substantial damage
- [NTSB CAN65C0034](https://openairdocs.org/ntsb/CAN65C0034.md): Aero Comdr 500 · Round Pond Nf, Canada · Accident · Minor injuries · Closed · May 20, 1965 · N8426C · Substantial damage
- [NTSB NYC65F0191](https://openairdocs.org/ntsb/NYC65F0191.md): Aero Cmdr 680E · Warminster, PA · Accident · No injuries · Closed · May 18, 1965 · N262X · Substantial damage
- [NTSB DCA65A0006](https://openairdocs.org/ntsb/DCA65A0006.md): Douglas DC-6A · Knob Noster, MO · Accident · No injuries · Closed · May 18, 1965 · N6579C · Destroyed
- [NTSB OAK65F0068](https://openairdocs.org/ntsb/OAK65F0068.md): Cessna 172A · Antioch, CA · Accident · No injuries · Closed · May 16, 1965 · N9750T · Substantial damage
- [NTSB MKC65F0154](https://openairdocs.org/ntsb/MKC65F0154.md): Schweizer SGS126 · Papillion, NE · Accident · 1 fatal · Closed · May 16, 1965 · N2768R · Destroyed
- [NTSB NYC65F0220](https://openairdocs.org/ntsb/NYC65F0220.md): Mooney 20C · Monroeville, PA · Accident · No injuries · Closed · May 15, 1965 · N6535U · Substantial damage
- [NTSB MKC66F0072](https://openairdocs.org/ntsb/MKC66F0072.md): Cessna 150 · Leawood, KS · Accident · Minor injuries · Closed · May 15, 1965 · N4334U · Destroyed
- [NTSB MKC65F0137](https://openairdocs.org/ntsb/MKC65F0137.md): Piper PA-22 · Ames, IA · Accident · No injuries · Closed · May 13, 1965 · N2627P · Substantial damage
- [NTSB CHI66F0058](https://openairdocs.org/ntsb/CHI66F0058.md): Piper PA-22 · Jeffersonville, IN · Accident · Minor injuries · Closed · May 13, 1965 · N5797Z · Substantial damage
- [NTSB MKC66D0001](https://openairdocs.org/ntsb/MKC66D0001.md): Piper J3-C · Nebraska City, NE · Accident · Minor injuries · Closed · May 12, 1965 · N3482K · Destroyed
- [NTSB NYC65F0196](https://openairdocs.org/ntsb/NYC65F0196.md): Taylorcraft DC-65 · Winchester, VA · Accident · Minor injuries · Closed · May 9, 1965 · N46140 · Substantial damage
- [NTSB MKC65F0136](https://openairdocs.org/ntsb/MKC65F0136.md): Cessna 172 · Sioux Falls, SD · Accident · Minor injuries · Closed · May 9, 1965 · N2758U · Substantial damage
- [NTSB DEN65D0084](https://openairdocs.org/ntsb/DEN65D0084.md): Cessna 172D · Tucson, AZ · Accident · No injuries · Closed · May 9, 1965 · N2533U · Substantial damage
- [NTSB DEN65D0093](https://openairdocs.org/ntsb/DEN65D0093.md): Cessna 170B · Wickenburg, AZ · Accident · Minor injuries · Closed · May 8, 1965 · N1932C · Substantial damage
- [NTSB NYC65F0203](https://openairdocs.org/ntsb/NYC65F0203.md): Taylorcraft BC12D · Parkville, MD · Accident · Serious injuries · Closed · May 6, 1965 · N96828 · Substantial damage
- [NTSB MIA65F0094](https://openairdocs.org/ntsb/MIA65F0094.md): Cessna 170A · Columbus, MS · Accident · No injuries · Closed · May 6, 1965 · N1373D · Destroyed
- [NTSB LAX65F0061](https://openairdocs.org/ntsb/LAX65F0061.md): Ercoupe 415C · Carlsbad, CA · Accident · No injuries · Closed · May 6, 1965 · N87192 · Substantial damage
- [NTSB MIA66F0103](https://openairdocs.org/ntsb/MIA66F0103.md): Cessna 175 · Guntersville, AL · Accident · No injuries · Closed · May 5, 1965 · N9260B · Substantial damage
- [NTSB NYC65A0136](https://openairdocs.org/ntsb/NYC65A0136.md): Luscombe 8A · Fire Isld Pine, NY · Accident · 2 fatal · Closed · May 4, 1965 · N45955 · Destroyed
- [NTSB NYC65F0198](https://openairdocs.org/ntsb/NYC65F0198.md): Piper PA-24 · Millbrook, NY · Accident · No injuries · Closed · May 3, 1965 · N6989P · Substantial damage
- [NTSB CHI65A0094](https://openairdocs.org/ntsb/CHI65A0094.md): Luscombe 8A · Hiram, OH · Accident · 1 fatal · Closed · May 2, 1965 · N2590K · Destroyed
- [NTSB NYC65F0179](https://openairdocs.org/ntsb/NYC65F0179.md): Maule M-4 · Mt Pleasant, PA · Accident · No injuries · Closed · May 1, 1965 · N4740T · Substantial damage
- [NTSB MIA65F0102](https://openairdocs.org/ntsb/MIA65F0102.md): Beech D18S · Opa-Locka, FL · Accident · Serious injuries · Closed · May 1, 1965 · N8902A · Destroyed
- [NTSB MIA65F0064](https://openairdocs.org/ntsb/MIA65F0064.md): Piper PA-12 · Chamblee, GA · Accident · Minor injuries · Closed · May 1, 1965 · N98955 · Destroyed
- [NTSB FTW65A0108](https://openairdocs.org/ntsb/FTW65A0108.md): Mooney M20 · Jonesboro, AR · Accident · 1 fatal · Closed · May 1, 1965 · N1976Y · Destroyed
- [NTSB MKC65D0139](https://openairdocs.org/ntsb/MKC65D0139.md): Aeronca 0-58B · Carroll, IA · Accident · No injuries · Closed · Apr 30, 1965 · N48080 · Destroyed
- [NTSB MIA65F0127](https://openairdocs.org/ntsb/MIA65F0127.md): Aeronca 7AC · Rock Hill, SC · Accident · No injuries · Closed · Apr 29, 1965 · N82989 · Substantial damage
- [NTSB CHI65F0191](https://openairdocs.org/ntsb/CHI65F0191.md): Beechcraft 95A · Bloomington, IN · Accident · Serious injuries · Closed · Apr 29, 1965 · N6141V · Substantial damage
- [NTSB CHI65A0093](https://openairdocs.org/ntsb/CHI65A0093.md): Aero Comm 500B · Rockford, IL · Accident · 2 fatal · Closed · Apr 29, 1965 · N78333 · Destroyed
- [NTSB SEA65D0054](https://openairdocs.org/ntsb/SEA65D0054.md): Cessna 170B · Nyssa, OR · Accident · No injuries · Closed · Apr 26, 1965 · N2513D · Substantial damage
- [NTSB NYC65F0115](https://openairdocs.org/ntsb/NYC65F0115.md): Piper PA-24 · Prospectville, PA · Accident · No injuries · Closed · Apr 25, 1965 · N6327P · Substantial damage
- [NTSB MKC65A0063](https://openairdocs.org/ntsb/MKC65A0063.md): Bell B-47G3 · Dodge City, KS · Accident · No injuries · Closed · Apr 25, 1965 · N8505F · Substantial damage
- [NTSB NYC65F0149](https://openairdocs.org/ntsb/NYC65F0149.md): Cessna 182B · Reading, PA · Accident · Minor injuries · Closed · Apr 24, 1965 · N2789G · Substantial damage
- [NTSB MIA65A0105](https://openairdocs.org/ntsb/MIA65A0105.md): Cessna 172 · Evergreen, AL · Accident · 2 fatal · Closed · Apr 24, 1965 · N8004B · Destroyed
- [NTSB DEN65D0065](https://openairdocs.org/ntsb/DEN65D0065.md): Champion 7CCM · Alva, WY · Accident · Minor injuries · Closed · Apr 23, 1965 · N4451E · Substantial damage
- [NTSB SEA65F0041](https://openairdocs.org/ntsb/SEA65F0041.md): No American SNJ-5 · Caldwell, ID · Accident · No injuries · Closed · Apr 22, 1965 · N9822C · Destroyed
- [NTSB MIA65D0059](https://openairdocs.org/ntsb/MIA65D0059.md): Cessna 150 · Miami, FL · Accident · No injuries · Closed · Apr 22, 1965 · N5518E · Substantial damage

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

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

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