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

## Cases, newest first

- [NTSB MKC66F0427](https://openairdocs.org/ntsb/MKC66F0427.md): Cessna 172F · Brigeton, MO · Accident · Serious injuries · Closed · Dec 26, 1965 · N7914U · Destroyed
- [NTSB FTW66F0483](https://openairdocs.org/ntsb/FTW66F0483.md): Taylorcraft BC12-D · Sand Springs, OK · Accident · Minor injuries · Closed · Dec 26, 1965 · N95034 · Substantial damage
- [NTSB FTW66F0450](https://openairdocs.org/ntsb/FTW66F0450.md): Cessna 170 · Guthrie, OK · Accident · No injuries · Closed · Dec 20, 1965 · N4192V · Substantial damage
- [NTSB DEN66D0212](https://openairdocs.org/ntsb/DEN66D0212.md): Cessna 150 · Littleton, CO · Accident · No injuries · Closed · Dec 20, 1965 · N8435G · Substantial damage
- [NTSB MKC66D0334](https://openairdocs.org/ntsb/MKC66D0334.md): Cessna 172 · Wichita, KS · Accident · Minor injuries · Closed · Dec 19, 1965 · N7648X · Destroyed
- [NTSB UNK66X0116](https://openairdocs.org/ntsb/UNK66X0116.md): No American Navion · San Luis, Mexico · Accident · No injuries · Closed · Dec 18, 1965 · N91585 · Substantial damage
- [NTSB LAX66F0202](https://openairdocs.org/ntsb/LAX66F0202.md): Cessna 150 · Catalina Is, CA · Accident · No injuries · Closed · Dec 18, 1965 · N3980U · Substantial damage
- [NTSB CHI66F0485](https://openairdocs.org/ntsb/CHI66F0485.md): Piper PA28 · Urbana, IL · Accident · Serious injuries · Closed · Dec 18, 1965 · N8208W · Destroyed
- [NTSB MIA66A0069](https://openairdocs.org/ntsb/MIA66A0069.md): Piper J3C-65 · Metter, GA · Accident · 2 fatal · Closed · Dec 17, 1965 · N7060H · Substantial damage
- [NTSB OAK66F0172](https://openairdocs.org/ntsb/OAK66F0172.md): Cessna 182 · Tahoe Valley, CA · Accident · Minor injuries · Closed · Dec 15, 1965 · N9078X · Substantial damage
- [NTSB NYC66D0373](https://openairdocs.org/ntsb/NYC66D0373.md): Stinson L-5E · Mechanicsville, VA · Accident · No injuries · Closed · Dec 15, 1965 · N3707C · Substantial damage
- [NTSB LAX66F0207](https://openairdocs.org/ntsb/LAX66F0207.md): Beechcraft 35 · Oxnard, CA · Accident · No injuries · Closed · Dec 15, 1965 · N306B · Substantial damage
- [NTSB FTW66F0466](https://openairdocs.org/ntsb/FTW66F0466.md): Piper PA-32 · Alexandria, LA · Accident · Serious injuries · Closed · Dec 15, 1965 · N3341W · Destroyed
- [NTSB MIA66F0409](https://openairdocs.org/ntsb/MIA66F0409.md): Piper PA-24 · New Bern, NC · Accident · No injuries · Closed · Dec 14, 1965 · N6830P · Substantial damage
- [NTSB LAX66F0191](https://openairdocs.org/ntsb/LAX66F0191.md): Cessna 182B · Ocotillo, CA · Accident · Minor injuries · Closed · Dec 13, 1965 · N2780G · Substantial damage
- [NTSB NYC66A0065](https://openairdocs.org/ntsb/NYC66A0065.md): Piper PA-30 · White Plains, NY · Accident · 1 fatal · Closed · Dec 12, 1965 · N7056Y · Destroyed
- [NTSB MIA66D0361](https://openairdocs.org/ntsb/MIA66D0361.md): Piper J3C-65 · St George, SC · Accident · No injuries · Closed · Dec 12, 1965 · N98519 · Substantial damage
- [NTSB FTW66F0431](https://openairdocs.org/ntsb/FTW66F0431.md): Taylorcraft DCO-65 · Gurdon, AR · Accident · Minor injuries · Closed · Dec 12, 1965 · N58603 · Substantial damage
- [NTSB FTW66F0430](https://openairdocs.org/ntsb/FTW66F0430.md): Piper PA-22 · Fort Worth, TX · Accident · Minor injuries · Closed · Dec 11, 1965 · N2370P · Substantial damage
- [NTSB ANC66D0079](https://openairdocs.org/ntsb/ANC66D0079.md): Piper PA-22 · Anchorage, AK · Accident · No injuries · Closed · Dec 11, 1965 · N5601Z · Substantial damage
- [NTSB CHI66F0491](https://openairdocs.org/ntsb/CHI66F0491.md): Luscombe 8A · Findlay, OH · Accident · Serious injuries · Closed · Dec 10, 1965 · N1274B · Substantial damage
- [NTSB CHI66D0498](https://openairdocs.org/ntsb/CHI66D0498.md): Piper PA-28 · Mansfield, OH · Accident · No injuries · Closed · Dec 10, 1965 · N7739W · Substantial damage
- [NTSB CHI66A0058](https://openairdocs.org/ntsb/CHI66A0058.md): Cessna 150F · South Bend, IN · Accident · 1 fatal · Closed · Dec 10, 1965 · N8072S · Destroyed
- [NTSB SEA66A0036](https://openairdocs.org/ntsb/SEA66A0036.md): Air & Space 18A · Oakland, OR · Accident · No injuries · Closed · Dec 8, 1965 · N6101S · Substantial damage
- [NTSB CHI66F0458](https://openairdocs.org/ntsb/CHI66F0458.md): Luscombe 8E · Willis, MI · Accident · No injuries · Closed · Dec 8, 1965 · N2668K · Substantial damage
- [NTSB NYC66F0389](https://openairdocs.org/ntsb/NYC66F0389.md): Piper PA-28 · Worcester, MA · Accident · Minor injuries · Closed · Dec 7, 1965 · N6596W · Substantial damage
- [NTSB CHI66F0531](https://openairdocs.org/ntsb/CHI66F0531.md): Beechcraft 23 · Wheeling, IL · Accident · Serious injuries · Closed · Dec 5, 1965 · N2323Q · 2 aircraft · Substantial damage
- [NTSB CHI66D0496](https://openairdocs.org/ntsb/CHI66D0496.md): Cessna 182F · Middle Bass, OH · Accident · No injuries · Closed · Dec 5, 1965 · N3589Y · Substantial damage
- [NTSB ANC66D0074](https://openairdocs.org/ntsb/ANC66D0074.md): Piper PA-20 · Barrow, AK · Accident · Minor injuries · Closed · Dec 5, 1965 · N6899K · Destroyed
- [NTSB NYC66F0388](https://openairdocs.org/ntsb/NYC66F0388.md): Cessna 172 · Stevensville, MD · Accident · Serious injuries · Closed · Dec 4, 1965 · N2560U · Destroyed
- [NTSB MKC66F0372](https://openairdocs.org/ntsb/MKC66F0372.md): Cessna 150 · Springfield, SD · Accident · No injuries · Closed · Dec 4, 1965 · N8225S · Substantial damage
- [NTSB MIA66F0346](https://openairdocs.org/ntsb/MIA66F0346.md): Piper J4A · Greenville, MS · Accident · 1 fatal · Closed · Dec 4, 1965 · N24563 · Destroyed
- [NTSB LAX66A0046](https://openairdocs.org/ntsb/LAX66A0046.md): Hughes 269A · Lompoc, CA · Accident · No injuries · Closed · Dec 4, 1965 · N8900F · Substantial damage
- [NTSB NYC66A0062](https://openairdocs.org/ntsb/NYC66A0062.md): Cessna 337 · Glen Falls, NY · Accident · 1 fatal · Closed · Dec 3, 1965 · N2252X · Destroyed
- [NTSB MIA67F0065](https://openairdocs.org/ntsb/MIA67F0065.md): Piper PA-22 · Tallahassee, FL · Accident · Minor injuries · Closed · Nov 28, 1965 · N3552P · Substantial damage
- [NTSB FTW66D0442](https://openairdocs.org/ntsb/FTW66D0442.md): Ercoupe 415-C · Teague, TX · Accident · No injuries · Closed · Nov 27, 1965 · N93884 · Substantial damage
- [NTSB FTW66D0441](https://openairdocs.org/ntsb/FTW66D0441.md): Piper PA-22 · Amarillo, TX · Accident · No injuries · Closed · Nov 26, 1965 · N3382B · Substantial damage
- [NTSB FTW66D0501](https://openairdocs.org/ntsb/FTW66D0501.md): Cessna 172D · Punta De Mita, Mexico · Accident · No injuries · Closed · Nov 25, 1965 · N2661U · Substantial damage
- [NTSB DEN66A0035](https://openairdocs.org/ntsb/DEN66A0035.md): Piper PA-24 · Santa Fe, NM · Accident · 1 fatal · Closed · Nov 22, 1965 · N5542P · Destroyed
- [NTSB MKC66D0362](https://openairdocs.org/ntsb/MKC66D0362.md): Taylorcraft L-2 · Adair, IA · Accident · No injuries · Closed · Nov 21, 1965 · N48247 · Substantial damage
- [NTSB NYC66F0392](https://openairdocs.org/ntsb/NYC66F0392.md): Cessna 190 · Latrobe, PA · Accident · Serious injuries · Closed · Nov 20, 1965 · N1598D · Destroyed
- [NTSB SEA66F0176](https://openairdocs.org/ntsb/SEA66F0176.md): Aeronca 7AC · Vancouver, WA · Accident · Minor injuries · Closed · Nov 17, 1965 · N81933 · Substantial damage
- [NTSB DEN66F0160](https://openairdocs.org/ntsb/DEN66F0160.md): Aero Cmdr 680-FL · Albuquerque, NM · Accident · No injuries · Closed · Nov 17, 1965 · N770HB · Substantial damage
- [NTSB CHI66D0484](https://openairdocs.org/ntsb/CHI66D0484.md): Piper PA-28 · Auburn, IN · Accident · No injuries · Closed · Nov 17, 1965 · N6764W · Substantial damage
- [NTSB DEN66F0171](https://openairdocs.org/ntsb/DEN66F0171.md): Piper PA-24 · Las Cruces, NM · Accident · No injuries · Closed · Nov 16, 1965 · N6263P · Substantial damage
- [NTSB DEN66F0159](https://openairdocs.org/ntsb/DEN66F0159.md): Alon A2 · Sunland Pk, NM · Accident · No injuries · Closed · Nov 14, 1965 · N6372V · Substantial damage
- [NTSB CHI66A0049](https://openairdocs.org/ntsb/CHI66A0049.md): Piper PA-18 · New Carlisle, OH · Accident · 1 fatal · Closed · Nov 14, 1965 · N1532V · 2 aircraft · Substantial damage
- [NTSB OAK66F0171](https://openairdocs.org/ntsb/OAK66F0171.md): Beechcraft C45H · Maui, HI · Accident · 2 fatal · Closed · Nov 12, 1965 · N9915Z · Destroyed
- [NTSB OAK66D0151](https://openairdocs.org/ntsb/OAK66D0151.md): Beechcraft A35 · Lodi, CA · Accident · Minor injuries · Closed · Nov 12, 1965 · N8493A · Destroyed
- [NTSB DEN66D0191](https://openairdocs.org/ntsb/DEN66D0191.md): Cessna 182 · Frannie, WY · Accident · No injuries · Closed · Nov 12, 1965 · N3494S · Substantial damage

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

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

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