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

## Cases, newest first

- [NTSB MKC66I0058](https://openairdocs.org/ntsb/MKC66I0058.md): Douglas DC-3 · Norfolk, NE · Incident · No injuries · Closed · May 11, 1966 · N15748 · Minor damage
- [NTSB DEN66A0081](https://openairdocs.org/ntsb/DEN66A0081.md): Bell 47G3B1 · Aspen, CO · Accident · Serious injuries · Closed · May 11, 1966 · N1180W · Substantial damage
- [NTSB SEA66D0269](https://openairdocs.org/ntsb/SEA66D0269.md): Cessna 120 · Boise, ID · Accident · No injuries · Closed · May 10, 1966 · N76892 · Substantial damage
- [NTSB FTW66F0667](https://openairdocs.org/ntsb/FTW66F0667.md): Piper PA-24 · Garland, TX · Accident · No injuries · Closed · May 10, 1966 · N7611P · Substantial damage
- [NTSB FTW67F0249](https://openairdocs.org/ntsb/FTW67F0249.md): Cessna 210 · Ubbock, TX · Accident · No injuries · Closed · May 9, 1966 · N9649T · Substantial damage
- [NTSB DEN66D0329](https://openairdocs.org/ntsb/DEN66D0329.md): Piper PA-24 · Buckeye, AZ · Accident · No injuries · Closed · May 8, 1966 · N6589P · Substantial damage
- [NTSB OAK66D0289](https://openairdocs.org/ntsb/OAK66D0289.md): Cessna 172 · Tracy, CA · Accident · No injuries · Closed · May 7, 1966 · N5023A · Substantial damage
- [NTSB LAX66F0335](https://openairdocs.org/ntsb/LAX66F0335.md): Luscombe 8A · Ojai, CA · Accident · Serious injuries · Closed · May 7, 1966 · N45684 · Substantial damage
- [NTSB LAX66A0083](https://openairdocs.org/ntsb/LAX66A0083.md): Bell 47G · Santa Susana, CA · Accident · Minor injuries · Closed · May 6, 1966 · N2473B · Substantial damage
- [NTSB CHI66F0718](https://openairdocs.org/ntsb/CHI66F0718.md): Piper PA28 · Hilliard, OH · Accident · No injuries · Closed · May 6, 1966 · N180SU · Substantial damage
- [NTSB SEA67F0018](https://openairdocs.org/ntsb/SEA67F0018.md): Piper PA-22 · Florence, OR · Accident · Serious injuries · Closed · May 4, 1966 · N6133D · Destroyed
- [NTSB FTW66F0648](https://openairdocs.org/ntsb/FTW66F0648.md): Cessna 170A · Spearman, TX · Accident · Minor injuries · Closed · May 1, 1966 · N1789D · Destroyed
- [NTSB SEA67D0008](https://openairdocs.org/ntsb/SEA67D0008.md): Piper PA-28 · Sherwood, OR · Accident · No injuries · Closed · Apr 30, 1966 · N8644W · Substantial damage
- [NTSB OAK66D0259](https://openairdocs.org/ntsb/OAK66D0259.md): Globe GC-1B · Sacramento, CA · Accident · No injuries · Closed · Apr 30, 1966 · N3224K · Substantial damage
- [NTSB MKC66F0510](https://openairdocs.org/ntsb/MKC66F0510.md): Piper PA-24 · Lincoln, NE · Accident · No injuries · Closed · Apr 30, 1966 · N5776P · Substantial damage
- [NTSB LAX66D0360](https://openairdocs.org/ntsb/LAX66D0360.md): Beech B35 · Colton, CA · Accident · No injuries · Closed · Apr 30, 1966 · N8461A · Substantial damage
- [NTSB MIA66D0581](https://openairdocs.org/ntsb/MIA66D0581.md): Piper PA14 · Lane, SC · Accident · Minor injuries · Closed · Apr 29, 1966 · N4245H · Substantial damage
- [NTSB LAX66F0319](https://openairdocs.org/ntsb/LAX66F0319.md): Cessna 150 · Van Nuys, CA · Accident · No injuries · Closed · Apr 29, 1966 · N6534T · Substantial damage
- [NTSB MKC66D0564](https://openairdocs.org/ntsb/MKC66D0564.md): Cessna 150 · Houston, MO · Accident · No injuries · Closed · Apr 27, 1966 · N1922Z · Destroyed
- [NTSB MKC66F0555](https://openairdocs.org/ntsb/MKC66F0555.md): Piper PA-28 · Warrensburg, MO · Accident · Serious injuries · Closed · Apr 26, 1966 · N4602R · Substantial damage
- [NTSB MIA66A0125](https://openairdocs.org/ntsb/MIA66A0125.md): Bell 47G-2 · Homestead, FL · Accident · Minor injuries · Closed · Apr 26, 1966 · N6774D · Substantial damage
- [NTSB MIA66A0124](https://openairdocs.org/ntsb/MIA66A0124.md): Piper PA-28 · Daytona Beach, FL · Accident · 3 fatal · Closed · Apr 25, 1966 · N4570R · Destroyed
- [NTSB NYC66I0123](https://openairdocs.org/ntsb/NYC66I0123.md): Boeing 707 · Philadelphia, PA · Incident · No injuries · Closed · Apr 24, 1966 · N7516A · Minor damage
- [NTSB MKC66D0518](https://openairdocs.org/ntsb/MKC66D0518.md): Champion 7FC · White Bear Lk, MN · Accident · Minor injuries · Closed · Apr 24, 1966 · N9970Y · Substantial damage
- [NTSB MIA66D0538](https://openairdocs.org/ntsb/MIA66D0538.md): Piper PA-23 · Foley, AL · Accident · No injuries · Closed · Apr 24, 1966 · N5208Y · Substantial damage
- [NTSB OAK66F0241](https://openairdocs.org/ntsb/OAK66F0241.md): Boeing A-75N1 · Robbins, CA · Accident · Minor injuries · Closed · Apr 23, 1966 · N7713C · Substantial damage
- [NTSB NYC66F0632](https://openairdocs.org/ntsb/NYC66F0632.md): Piper PA-28 · Sadsburyville, PA · Accident · No injuries · Closed · Apr 23, 1966 · N5721W · Substantial damage
- [NTSB NYC66F0618](https://openairdocs.org/ntsb/NYC66F0618.md): Piper PA-28 · Amityville, NY · Accident · Minor injuries · Closed · Apr 23, 1966 · N7462W · Destroyed
- [NTSB LAX66F0304](https://openairdocs.org/ntsb/LAX66F0304.md): LC Short A · Lancaster, CA · Accident · Serious injuries · Closed · Apr 23, 1966 · N238Y · Substantial damage
- [NTSB DEN67F0016](https://openairdocs.org/ntsb/DEN67F0016.md): Cessna 175 · Alpine, WY · Accident · Serious injuries · Closed · Apr 23, 1966 · N6584E · Substantial damage
- [NTSB DEN66F0310](https://openairdocs.org/ntsb/DEN66F0310.md): Cessna 170C · Watkins, CO · Accident · Minor injuries · Closed · Apr 23, 1966 · N1336Y · Substantial damage
- [NTSB SEA66D0294](https://openairdocs.org/ntsb/SEA66D0294-171782.md): Beech A23 · Vancouver, WA · Accident · No injuries · Closed · Apr 22, 1966 · N2374W · Substantial damage
- [NTSB DCA66A0006](https://openairdocs.org/ntsb/DCA66A0006.md): Lockheed L-188C · Ardmore, OK · Accident · 83 fatal · Closed · Apr 22, 1966 · N183H · Destroyed
- [NTSB OAK66F0231](https://openairdocs.org/ntsb/OAK66F0231.md): Cessna 150 · Richvale, CA · Accident · Minor injuries · Closed · Apr 18, 1966 · N8340G · Substantial damage
- [NTSB MKC66D0541](https://openairdocs.org/ntsb/MKC66D0541.md): Cessna 150 · Atlantic, IA · Accident · No injuries · Closed · Apr 18, 1966 · N8807S · Substantial damage
- [NTSB FTW66F0638](https://openairdocs.org/ntsb/FTW66F0638.md): Piper PA-28 · Tomball, TX · Accident · No injuries · Closed · Apr 18, 1966 · N6558W · Substantial damage
- [NTSB CHI66F0769](https://openairdocs.org/ntsb/CHI66F0769.md): Piper PA-28 · Richmond, IN · Accident · Serious injuries · Closed · Apr 18, 1966 · N6507W · Substantial damage
- [NTSB OAK66D0284](https://openairdocs.org/ntsb/OAK66D0284.md): Aero-Pegaso M-100S · Livermore, CA · Accident · Minor injuries · Closed · Apr 17, 1966 · N88981 · Substantial damage
- [NTSB MKC66D0514](https://openairdocs.org/ntsb/MKC66D0514.md): Cessna 172 · Mexico, MO · Accident · No injuries · Closed · Apr 17, 1966 · N4113L · Substantial damage
- [NTSB CHI66D0694](https://openairdocs.org/ntsb/CHI66D0694.md): Piper PA-24 · Swanton, OH · Accident · No injuries · Closed · Apr 17, 1966 · N8450P · Substantial damage
- [NTSB OAK66D0271](https://openairdocs.org/ntsb/OAK66D0271.md): Cessna 150D · Yona, GU · Accident · Minor injuries · Closed · Apr 16, 1966 · N4126U · Substantial damage
- [NTSB NYC66F0619](https://openairdocs.org/ntsb/NYC66F0619.md): Cessna 210 · Flemington, NJ · Accident · No injuries · Closed · Apr 16, 1966 · N6688X · Substantial damage
- [NTSB NYC66A0120](https://openairdocs.org/ntsb/NYC66A0120.md): Hughes 269B · Speculator, NY · Accident · No injuries · Closed · Apr 15, 1966 · N9435F · Substantial damage
- [NTSB DEN66F0267](https://openairdocs.org/ntsb/DEN66F0267.md): Piper PA-24 · Greely, CO · Accident · No injuries · Closed · Apr 15, 1966 · N7122P · Substantial damage
- [NTSB FTW66F0615](https://openairdocs.org/ntsb/FTW66F0615.md): Piper PA-28 · Stilwell, OK · Accident · No injuries · Closed · Apr 14, 1966 · N8965W · Substantial damage
- [NTSB SEA66F0240](https://openairdocs.org/ntsb/SEA66F0240.md): Cessna 172 · Pullman, WA · Accident · Minor injuries · Closed · Apr 13, 1966 · N7721T · Substantial damage
- [NTSB NYC66F0621](https://openairdocs.org/ntsb/NYC66F0621.md): Piper PA-23 · Syracuse, NY · Accident · No injuries · Closed · Apr 13, 1966 · N2183P · Substantial damage
- [NTSB LAX66F0318](https://openairdocs.org/ntsb/LAX66F0318.md): Boeing A75 · Banning, CA · Accident · Minor injuries · Closed · Apr 13, 1966 · N60167 · Destroyed
- [NTSB MIA66F0516](https://openairdocs.org/ntsb/MIA66F0516.md): Beech D95A · Raleigh, NC · Accident · No injuries · Closed · Apr 12, 1966 · N8920U · Substantial damage
- [NTSB SEA66F0281](https://openairdocs.org/ntsb/SEA66F0281.md): Piper PA-22 · Mitchell, OR · Accident · Minor injuries · Closed · Apr 11, 1966 · N2729P · Destroyed

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

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

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