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

## Cases, newest first

- [NTSB NYC67A0055](https://openairdocs.org/ntsb/NYC67A0055.md): Piper PA-28 · Orient Point, NY · Accident · No injuries · Closed · Sep 17, 1966 · N9245J · Substantial damage
- [NTSB LAX67D0122](https://openairdocs.org/ntsb/LAX67D0122.md): Piper PA-28 · Acton, CA · Accident · No injuries · Closed · Sep 17, 1966 · N6852W · Substantial damage
- [NTSB CHI67F0283](https://openairdocs.org/ntsb/CHI67F0283.md): Taylorcraft BC12-D · Elyria, OH · Accident · Minor injuries · Closed · Sep 17, 1966 · N96533 · Substantial damage
- [NTSB OAK67F0111](https://openairdocs.org/ntsb/OAK67F0111.md): Piper PA-28 · Dobbins, CA · Accident · No injuries · Closed · Sep 16, 1966 · N6165W · Substantial damage
- [NTSB NYC67F0274](https://openairdocs.org/ntsb/NYC67F0274.md): Stearman B75 · Seabrook, NJ · Accident · Serious injuries · Closed · Sep 16, 1966 · N9040H · Destroyed
- [NTSB MIA67F0186](https://openairdocs.org/ntsb/MIA67F0186.md): Piper PA-12 · Fayetteville, TN · Accident · No injuries · Closed · Sep 16, 1966 · N92765 · Substantial damage
- [NTSB CHI67D0259](https://openairdocs.org/ntsb/CHI67D0259.md): Ercoupe 415-C · Grayslake, IL · Accident · No injuries · Closed · Sep 16, 1966 · N93776 · Substantial damage
- [NTSB CHI67D0245](https://openairdocs.org/ntsb/CHI67D0245.md): Cessna 172C · Xenia, OH · Accident · No injuries · Closed · Sep 16, 1966 · N1641Y · Substantial damage
- [NTSB MIA67D0221](https://openairdocs.org/ntsb/MIA67D0221.md): Cessna 320B · Kingston, Jamaica · Accident · No injuries · Closed · Sep 14, 1966 · N3402Q · 2 aircraft · Substantial damage
- [NTSB NYC67D0284](https://openairdocs.org/ntsb/NYC67D0284.md): Cessna 310K · Teterboro, NJ · Accident · No injuries · Closed · Sep 13, 1966 · N735AD · Substantial damage
- [NTSB MIA67F0185](https://openairdocs.org/ntsb/MIA67F0185.md): Beech 35 · T.Lauderdale, FL · Accident · Minor injuries · Closed · Sep 13, 1966 · N1154 · Substantial damage
- [NTSB OAK67F0133](https://openairdocs.org/ntsb/OAK67F0133.md): Taylorcraft BC12-D · Paso Robles, CA · Accident · Serious injuries · Closed · Sep 12, 1966 · N43419 · Destroyed
- [NTSB MIA67A0035](https://openairdocs.org/ntsb/MIA67A0035.md): Curtis CW-22B · Tallahassee, FL · Accident · 1 fatal · Closed · Sep 11, 1966 · N19446 · Destroyed
- [NTSB OAK67D0158](https://openairdocs.org/ntsb/OAK67D0158.md): Schweizer SGS126 · Truckee, CA · Accident · No injuries · Closed · Sep 10, 1966 · N2724Z · Substantial damage
- [NTSB MKC67F0157](https://openairdocs.org/ntsb/MKC67F0157.md): Cessna 120 · Tekamah, NE · Accident · Minor injuries · Closed · Sep 10, 1966 · N4015N · Substantial damage
- [NTSB MKC67D0220](https://openairdocs.org/ntsb/MKC67D0220.md): Cessna 150 · Brewster, KS · Accident · Minor injuries · Closed · Sep 10, 1966 · N4628X · Substantial damage
- [NTSB CHI67D0273](https://openairdocs.org/ntsb/CHI67D0273.md): Cessna 150 · Middle Bass, OH · Accident · No injuries · Closed · Sep 10, 1966 · N4734X · Destroyed
- [NTSB SEA67D0120](https://openairdocs.org/ntsb/SEA67D0120-120442.md): Beech 35 · Libby, MT · Accident · No injuries · Closed · Sep 9, 1966 · N3172V · Substantial damage
- [NTSB SEA67F0184](https://openairdocs.org/ntsb/SEA67F0184.md): Cessna 150 · Springfield, OR · Accident · Minor injuries · Closed · Sep 5, 1966 · N3690J · Substantial damage
- [NTSB MKC67F0204](https://openairdocs.org/ntsb/MKC67F0204.md): Stinson 105 · Camdenton, MO · Accident · Minor injuries · Closed · Sep 5, 1966 · N21197 · Substantial damage
- [NTSB MKC67F0199](https://openairdocs.org/ntsb/MKC67F0199.md): Aeronca 058B · Essex, IA · Accident · Minor injuries · Closed · Sep 5, 1966 · N48243 · Substantial damage
- [NTSB MKC67D0223](https://openairdocs.org/ntsb/MKC67D0223.md): Cessna 150 · Sedalia, MO · Accident · No injuries · Closed · Sep 5, 1966 · N7927F · Substantial damage
- [NTSB SEA67F0109](https://openairdocs.org/ntsb/SEA67F0109.md): Cessna 140 · Walla Walla, WA · Accident · Minor injuries · Closed · Sep 4, 1966 · N2222N · Substantial damage
- [NTSB MIA67F0179](https://openairdocs.org/ntsb/MIA67F0179.md): Cessna 150 · Milan, GA · Accident · Minor injuries · Closed · Sep 3, 1966 · N8966S · Substantial damage
- [NTSB SEA67F0116](https://openairdocs.org/ntsb/SEA67F0116.md): Piper PA-22 · Redmond, OR · Accident · Serious injuries · Closed · Sep 1, 1966 · N6956B · Substantial damage
- [NTSB SEA67F0187](https://openairdocs.org/ntsb/SEA67F0187.md): Cessna 150 · Eugene, OR · Accident · No injuries · Closed · Aug 31, 1966 · N1236Y · Substantial damage
- [NTSB NYC67F0230](https://openairdocs.org/ntsb/NYC67F0230.md): Piper PA-22 · Milroy, PA · Accident · Minor injuries · Closed · Aug 31, 1966 · N9552D · Substantial damage
- [NTSB ANC67D0063](https://openairdocs.org/ntsb/ANC67D0063.md): Grumman G-21 · Alegnagik, AK · Accident · No injuries · Closed · Aug 31, 1966 · N640 · Substantial damage
- [NTSB LAX67F0087](https://openairdocs.org/ntsb/LAX67F0087.md): Funk B85C · Sunset Beach, CA · Accident · No injuries · Closed · Aug 30, 1966 · N24154 · Substantial damage
- [NTSB DEN67F0092](https://openairdocs.org/ntsb/DEN67F0092.md): Cessna 172 · Littleton, CO · Accident · No injuries · Closed · Aug 30, 1966 · N4624L · Substantial damage
- [NTSB CHI67A0031](https://openairdocs.org/ntsb/CHI67A0031.md): Taylorcraft BC12D1 · Rochester, IL · Accident · 1 fatal · Closed · Aug 30, 1966 · N5481M · Destroyed
- [NTSB CHI67F0303](https://openairdocs.org/ntsb/CHI67F0303.md): Fairchild F-24 · Warrenville, IL · Accident · No injuries · Closed · Aug 29, 1966 · N20628 · Substantial damage
- [NTSB UNK66X0168](https://openairdocs.org/ntsb/UNK66X0168.md): Piper PA-18 · Jacobshavn, Greenland · Accident · No injuries · Closed · Aug 28, 1966 · N4176Z · Substantial damage
- [NTSB MKC67A0018](https://openairdocs.org/ntsb/MKC67A0018.md): Cessna 172E · Knox City, MO · Accident · 1 fatal · Closed · Aug 28, 1966 · N3915S · Destroyed
- [NTSB DEN67F0094](https://openairdocs.org/ntsb/DEN67F0094.md): Schweizer TG-3A · Casper, WY · Accident · Serious injuries · Closed · Aug 28, 1966 · N9305H · Substantial damage
- [NTSB SEA67A0018](https://openairdocs.org/ntsb/SEA67A0018.md): Bensen B8M · Richland, WA · Accident · No injuries · Closed · Aug 27, 1966 · N68682 · Substantial damage
- [NTSB NYC67F0221](https://openairdocs.org/ntsb/NYC67F0221.md): Globe GC-1A · East Taunton, MA · Accident · Serious injuries · Closed · Aug 27, 1966 · N90366 · Substantial damage
- [NTSB LAX67D0128](https://openairdocs.org/ntsb/LAX67D0128.md): Piper PA-32 · Oildale, CA · Accident · No injuries · Closed · Aug 27, 1966 · N3630W · Substantial damage
- [NTSB CHI67F0150](https://openairdocs.org/ntsb/CHI67F0150.md): Beech D35 · Hazard, KY · Accident · No injuries · Closed · Aug 27, 1966 · N3442B · Substantial damage
- [NTSB OAK67D0087](https://openairdocs.org/ntsb/OAK67D0087.md): Piper PA-24 · Redding, CA · Accident · No injuries · Closed · Aug 26, 1966 · N193P · Substantial damage
- [NTSB LAX67F0090](https://openairdocs.org/ntsb/LAX67F0090.md): Globe GC-1B · Hawthorne, CA · Accident · No injuries · Closed · Aug 26, 1966 · N3215K · Substantial damage
- [NTSB CHI67A0027](https://openairdocs.org/ntsb/CHI67A0027.md): Navion NAV-4 · Terre Haute, IN · Accident · 3 fatal · Closed · Aug 26, 1966 · N91F · Destroyed
- [NTSB MIA67F0167](https://openairdocs.org/ntsb/MIA67F0167.md): Piper PA-28 · Auburn, AL · Accident · Minor injuries · Closed · Aug 25, 1966 · N8118W · Substantial damage
- [NTSB LAX67A0022](https://openairdocs.org/ntsb/LAX67A0022.md): Aeronca 7BCM · Pierce Ferry, AZ · Accident · 1 fatal · Closed · Aug 24, 1966 · N85052 · Substantial damage
- [NTSB DEN67A0017](https://openairdocs.org/ntsb/DEN67A0017.md): Aeronca 11AC · Sandy, UT · Accident · 2 fatal · Closed · Aug 24, 1966 · N9775E · Destroyed
- [NTSB FTW67D0183](https://openairdocs.org/ntsb/FTW67D0183.md): Piper PA-22 · Borger, TX · Accident · Serious injuries · Closed · Aug 23, 1966 · N3752P · Destroyed
- [NTSB MIA67A0028](https://openairdocs.org/ntsb/MIA67A0028.md): Boeing D75N1 · Reidville, SC · Accident · 1 fatal · Closed · Aug 22, 1966 · N65W · Destroyed
- [NTSB NYC67D0181](https://openairdocs.org/ntsb/NYC67D0181.md): Cessna 150 · Ambler, PA · Accident · No injuries · Closed · Aug 20, 1966 · N3187X · Substantial damage
- [NTSB CHI67D0158](https://openairdocs.org/ntsb/CHI67D0158.md): Piper PA-22 · Mooresville, IN · Accident · No injuries · Closed · Aug 20, 1966 · N879A · Substantial damage
- [NTSB SEA67F0112](https://openairdocs.org/ntsb/SEA67F0112.md): Cessna 182-A · Crescent Lke, OR · Accident · No injuries · Closed · Aug 19, 1966 · N5878B · Substantial damage

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

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

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