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

## Cases, newest first

- [NTSB FTW66F0493](https://openairdocs.org/ntsb/FTW66F0493.md): Cessna 172 · Amarillo, TX · Accident · No injuries · Closed · Jan 31, 1966 · N6364E · Substantial damage
- [NTSB CHI66F0550](https://openairdocs.org/ntsb/CHI66F0550.md): Cessna 140 · Pelican Lake, WI · Accident · Minor injuries · Closed · Jan 31, 1966 · N76910 · Substantial damage
- [NTSB SEA66F0207](https://openairdocs.org/ntsb/SEA66F0207.md): Cessna 150 · Pullman, WA · Accident · Serious injuries · Closed · Jan 30, 1966 · N4074U · Destroyed
- [NTSB CHI66D0593](https://openairdocs.org/ntsb/CHI66D0593.md): Piper PA-22 · Janesville, WI · Accident · No injuries · Closed · Jan 30, 1966 · N5815Z · Substantial damage
- [NTSB MIA66A0085](https://openairdocs.org/ntsb/MIA66A0085.md): Mooney M-20E · Manor, GA · Accident · 1 fatal · Closed · Jan 29, 1966 · N7196U · Destroyed
- [NTSB FTW66A0067](https://openairdocs.org/ntsb/FTW66A0067.md): Piper PA-32 · Dallas, TX · Accident · Serious injuries · Closed · Jan 29, 1966 · N3246W · Substantial damage
- [NTSB NYC66A0081](https://openairdocs.org/ntsb/NYC66A0081.md): Beech B95A · Erie, PA · Accident · 3 fatal · Closed · Jan 27, 1966 · N598C · Destroyed
- [NTSB FTW66F0511](https://openairdocs.org/ntsb/FTW66F0511.md): Piper PA-28 · San Antonio, TX · Accident · No injuries · Closed · Jan 27, 1966 · N5292W · Substantial damage
- [NTSB NYC66D0475](https://openairdocs.org/ntsb/NYC66D0475.md): Piper PA-28 · Morristown, NJ · Accident · No injuries · Closed · Jan 26, 1966 · N6235W · Substantial damage
- [NTSB CHI66F0555](https://openairdocs.org/ntsb/CHI66F0555.md): Cessna 150 · West Chicago, IL · Accident · No injuries · Closed · Jan 25, 1966 · N3516L · Substantial damage
- [NTSB CHI66F0518](https://openairdocs.org/ntsb/CHI66F0518.md): Taylorcraft BC-65 · Lewis Center, OH · Accident · No injuries · Closed · Jan 24, 1966 · N24453 · Substantial damage
- [NTSB LAX66D0283](https://openairdocs.org/ntsb/LAX66D0283.md): Cessna 172 · Las Vegas, NV · Accident · No injuries · Closed · Jan 23, 1966 · N5380R · Substantial damage
- [NTSB OAK66F0192](https://openairdocs.org/ntsb/OAK66F0192.md): Cessna 150 · Monterey, CA · Accident · Minor injuries · Closed · Jan 22, 1966 · N6488T · Destroyed
- [NTSB NYC66F0442](https://openairdocs.org/ntsb/NYC66F0442.md): Cessna 172 · Houlton, ME · Accident · No injuries · Closed · Jan 22, 1966 · N5400T · Substantial damage
- [NTSB NYC66D0470](https://openairdocs.org/ntsb/NYC66D0470.md): Piper PA-22 · Ballston Spa, NY · Accident · No injuries · Closed · Jan 22, 1966 · N2632P · Substantial damage
- [NTSB NYC66A0078](https://openairdocs.org/ntsb/NYC66A0078.md): Piper PA-28 · Warwick, RI · Accident · 3 fatal · Closed · Jan 22, 1966 · N5562W · 2 aircraft · Destroyed
- [NTSB LAX67F0139](https://openairdocs.org/ntsb/LAX67F0139.md): Alon A-2 · Santa Paula, CA · Accident · 1 fatal · Closed · Jan 22, 1966 · N5472E · Destroyed
- [NTSB MIA66F0412](https://openairdocs.org/ntsb/MIA66F0412.md): Piper PA-28 · Greensboro, NC · Accident · No injuries · Closed · Jan 21, 1966 · N6872W · Substantial damage
- [NTSB SEA66F0253](https://openairdocs.org/ntsb/SEA66F0253.md): Cessna 150 · Seattle, WA · Accident · Serious injuries · Closed · Jan 20, 1966 · N5718E · Substantial damage
- [NTSB CHI66F0613](https://openairdocs.org/ntsb/CHI66F0613.md): Beechcraft 95-55 · Wheeling, IL · Accident · No injuries · Closed · Jan 20, 1966 · N6127V · Substantial damage
- [NTSB NYC66D0472](https://openairdocs.org/ntsb/NYC66D0472.md): Piper PA-28 · Nottingham, PA · Accident · No injuries · Closed · Jan 19, 1966 · N5721W · Substantial damage
- [NTSB LAX66F0320](https://openairdocs.org/ntsb/LAX66F0320.md): Cessna 172 · Las Vegas, NV · Accident · No injuries · Closed · Jan 18, 1966 · N5773A · Substantial damage
- [NTSB LAX66D0224](https://openairdocs.org/ntsb/LAX66D0224.md): Cessna 150 · Piru, CA · Accident · No injuries · Closed · Jan 18, 1966 · N4240U · Substantial damage
- [NTSB NYC66D0467](https://openairdocs.org/ntsb/NYC66D0467.md): Cessna 310 · Jamestown, NY · Accident · Minor injuries · Closed · Jan 17, 1966 · N8157M · Substantial damage
- [NTSB MKC66F0396](https://openairdocs.org/ntsb/MKC66F0396.md): Piper PA-22 · Herington, KS · Accident · Serious injuries · Closed · Jan 17, 1966 · N1165C · Destroyed
- [NTSB MKC66A0039](https://openairdocs.org/ntsb/MKC66A0039.md): Hughes 269A · Rantoul, KS · Accident · No injuries · Closed · Jan 16, 1966 · N8904F · Substantial damage
- [NTSB FTW66F0500](https://openairdocs.org/ntsb/FTW66F0500.md): Cessna 180 · Stowell, TX · Accident · No injuries · Closed · Jan 16, 1966 · N9347C · Substantial damage
- [NTSB FTW66A0065](https://openairdocs.org/ntsb/FTW66A0065.md): Beech K35 · Mustang, OK · Accident · 2 fatal · Closed · Jan 16, 1966 · N5330E · Destroyed
- [NTSB CHI66F0558](https://openairdocs.org/ntsb/CHI66F0558.md): Cessna 150 · Lombard, IL · Accident · No injuries · Closed · Jan 15, 1966 · N3514J · Substantial damage
- [NTSB NYC66A0074](https://openairdocs.org/ntsb/NYC66A0074.md): Piper PA-30 · Lynchburg, VA · Accident · 2 fatal · Closed · Jan 14, 1966 · N7522Y · Destroyed
- [NTSB SEA66D0197](https://openairdocs.org/ntsb/SEA66D0197.md): Mooney M20C · Polson, MT · Accident · No injuries · Closed · Jan 12, 1966 · N5704Q · Substantial damage
- [NTSB LAX66A0055](https://openairdocs.org/ntsb/LAX66A0055.md): Hughes 269A · Carlsbad, CA · Accident · No injuries · Closed · Jan 9, 1966 · N8761F · Substantial damage
- [NTSB DEN66D0210](https://openairdocs.org/ntsb/DEN66D0210.md): Cessna 172 · Bowie, AZ · Accident · Minor injuries · Closed · Jan 9, 1966 · N7513T · Destroyed
- [NTSB NYC66A0070](https://openairdocs.org/ntsb/NYC66A0070.md): Bell Cntntl · Philadelphia, PA · Accident · No injuries · Closed · Jan 7, 1966 · N73872 · Substantial damage
- [NTSB CHI66A0062](https://openairdocs.org/ntsb/CHI66A0062.md): Piper PA-24 · Cascade, MI · Accident · 1 fatal · Closed · Jan 7, 1966 · N8423P · Destroyed
- [NTSB CHI66F0515](https://openairdocs.org/ntsb/CHI66F0515.md): Piper PA-30 · Franklin, IN · Accident · No injuries · Closed · Jan 6, 1966 · N7073Y · Substantial damage
- [NTSB NYC66F0411](https://openairdocs.org/ntsb/NYC66F0411.md): Cessna 140A · Marlboro, MA · Accident · No injuries · Closed · Jan 1, 1966 · N5675C · Substantial damage
- [NTSB MKC66D0337](https://openairdocs.org/ntsb/MKC66D0337.md): Stinson 108-2 · Panoro, IA · Accident · No injuries · Closed · Jan 1, 1966 · N9551K · Substantial damage
- [NTSB LAX66F0212](https://openairdocs.org/ntsb/LAX66F0212.md): Cessna 150 · Long Beach, CA · Accident · No injuries · Closed · Jan 1, 1966 · N2029Z · Substantial damage
- [NTSB CHI66F0494](https://openairdocs.org/ntsb/CHI66F0494.md): Cessna 120 · Greenville, MI · Accident · Minor injuries · Closed · Jan 1, 1966 · N2946N · Substantial damage
- [NTSB OAK66D0178](https://openairdocs.org/ntsb/OAK66D0178.md): Piper PA-22 · Mammoth Lake, CA · Accident · Minor injuries · Closed · Dec 31, 1965 · N3954P · Substantial damage
- [NTSB NYC66D0416](https://openairdocs.org/ntsb/NYC66D0416.md): Beechcraft G35 · Mendon, MA · Accident · No injuries · Closed · Dec 31, 1965 · N4409D · Destroyed
- [NTSB SEA66F0193](https://openairdocs.org/ntsb/SEA66F0193.md): Cessna 150 · Ellensburg, WA · Accident · No injuries · Closed · Dec 30, 1965 · N7718E · Substantial damage
- [NTSB MIA66F0505](https://openairdocs.org/ntsb/MIA66F0505.md): Navion A · Oceanway, FL · Accident · Serious injuries · Closed · Dec 30, 1965 · N527BB · Substantial damage
- [NTSB MIA66A0074](https://openairdocs.org/ntsb/MIA66A0074.md): Brantly B-2 · Tampa, FL · Accident · No injuries · Closed · Dec 30, 1965 · N5906X · Substantial damage
- [NTSB NYC66F0412](https://openairdocs.org/ntsb/NYC66F0412.md): Cessna 150 · Medford, NJ · Accident · Serious injuries · Closed · Dec 29, 1965 · N6157T · Substantial damage
- [NTSB MIA66F0355](https://openairdocs.org/ntsb/MIA66F0355.md): Cessna 172 · Pine Hall, NC · Accident · Minor injuries · Closed · Dec 29, 1965 · N6967A · Substantial damage
- [NTSB MIA66F0376](https://openairdocs.org/ntsb/MIA66F0376.md): Piper PA22 · Lexington, SC · Accident · Serious injuries · Closed · Dec 28, 1965 · N4502Z · Substantial damage
- [NTSB MKC66F0342](https://openairdocs.org/ntsb/MKC66F0342.md): Cessna 140 · Monticello, MN · Accident · No injuries · Closed · Dec 27, 1965 · N3587V · Substantial damage
- [NTSB MKC66D0370](https://openairdocs.org/ntsb/MKC66D0370.md): Forney 415-C · Allerton, IA · Accident · No injuries · Closed · Dec 27, 1965 · N94041 · Substantial damage

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

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

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