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

## Cases, newest first

- [NTSB CHI67F0542](https://openairdocs.org/ntsb/CHI67F0542.md): Cessna 140 · Pine Top, KY · Accident · Serious injuries · Closed · Feb 22, 1967 · N89499 · Destroyed
- [NTSB OAK67A0063](https://openairdocs.org/ntsb/OAK67A0063.md): Aero Comdr 560-E · Tahoe Valley, CA · Accident · 4 fatal · Closed · Feb 21, 1967 · N616R · Destroyed
- [NTSB LAX67D0269](https://openairdocs.org/ntsb/LAX67D0269.md): Luscombe 8A · Sierra Vista, AZ · Accident · No injuries · Closed · Feb 21, 1967 · N45675 · Substantial damage
- [NTSB DEN67A0048](https://openairdocs.org/ntsb/DEN67A0048.md): Bell 47G3B1 · Riverton, WY · Accident · No injuries · Closed · Feb 21, 1967 · N8537F · Substantial damage
- [NTSB UNK67X0112](https://openairdocs.org/ntsb/UNK67X0112.md): Beech 95-A55 · Nha Trang, VM · Accident · 2 fatal · Closed · Feb 20, 1967 · N9781Y · Destroyed
- [NTSB CHI67I0099](https://openairdocs.org/ntsb/CHI67I0099.md): Boeing 727 · Akron, OH · Incident · No injuries · Closed · Feb 20, 1967 · N7408U · Substantial damage
- [NTSB MKC67F0608](https://openairdocs.org/ntsb/MKC67F0608.md): Piper J-3C · Virginia, MN · Accident · Serious injuries · Closed · Feb 19, 1967 · N70955 · Destroyed
- [NTSB MIA67F0430](https://openairdocs.org/ntsb/MIA67F0430.md): Piper PA-28 · Clearwater, FL · Accident · No injuries · Closed · Feb 19, 1967 · N8429W · Substantial damage
- [NTSB LAX67A0080](https://openairdocs.org/ntsb/LAX67A0080.md): Cessna 150E · Santa Susana, CA · Accident · No injuries · Closed · Feb 19, 1967 · N4096U · Minor damage
- [NTSB FTW67D0449](https://openairdocs.org/ntsb/FTW67D0449.md): Cessna 150 · Denton, TX · Accident · No injuries · Closed · Feb 19, 1967 · N2256J · Substantial damage
- [NTSB ANC67F0080](https://openairdocs.org/ntsb/ANC67F0080.md): Piper PA-22 · Fairbanks, AK · Accident · No injuries · Closed · Feb 19, 1967 · N5110Z · Substantial damage
- [NTSB MIA67D0397](https://openairdocs.org/ntsb/MIA67D0397.md): Cessna 172 · Cabo Rojo, PR · Accident · No injuries · Closed · Feb 18, 1967 · N7824X · Substantial damage
- [NTSB OAK67A0062](https://openairdocs.org/ntsb/OAK67A0062.md): Piper PA-23 · Oakland, CA · Accident · 2 fatal · Closed · Feb 17, 1967 · N2043P · 2 aircraft · Destroyed
- [NTSB MIA67D0472](https://openairdocs.org/ntsb/MIA67D0472.md): Beech E18S · Fairhope, AL · Accident · No injuries · Closed · Feb 17, 1967 · N46M · Substantial damage
- [NTSB FTW67F0451](https://openairdocs.org/ntsb/FTW67F0451.md): Cessna 150F · Cleburne, TX · Accident · Serious injuries · Closed · Feb 16, 1967 · N8663S · Destroyed
- [NTSB FTW67D0450](https://openairdocs.org/ntsb/FTW67D0450.md): Piper PA-22 · Searcy, AR · Accident · Minor injuries · Closed · Feb 16, 1967 · N3220B · Substantial damage
- [NTSB CHI67F0473](https://openairdocs.org/ntsb/CHI67F0473.md): Piper PA-28 · Evergreen Pk, IL · Accident · No injuries · Closed · Feb 16, 1967 · N7731W · Substantial damage
- [NTSB MKC67A0048](https://openairdocs.org/ntsb/MKC67A0048.md): Cessna 182F · Sikeston, MO · Accident · 1 fatal · Closed · Feb 15, 1967 · N3235U · Destroyed
- [NTSB DEN67D0223](https://openairdocs.org/ntsb/DEN67D0223.md): Cessna 182 · Ft Collins, CO · Accident · Minor injuries · Closed · Feb 15, 1967 · N3383F · Substantial damage
- [NTSB MKC67D0455](https://openairdocs.org/ntsb/MKC67D0455.md): Cessna 172 · Dodge Cntr, MN · Accident · No injuries · Closed · Feb 14, 1967 · N159AE · Substantial damage
- [NTSB MKC67A0047](https://openairdocs.org/ntsb/MKC67A0047.md): Cessna 172G · Warrensburg, MO · Accident · 2 fatal · Closed · Feb 13, 1967 · N4403L · Destroyed
- [NTSB FTW67F0454](https://openairdocs.org/ntsb/FTW67F0454.md): Morris KM-2 · Fort Worth, TX · Accident · No injuries · Closed · Feb 12, 1967 · N73867 · Substantial damage
- [NTSB CHI67F0496](https://openairdocs.org/ntsb/CHI67F0496.md): Aeronca 7AC · Bainbridge, OH · Accident · No injuries · Closed · Feb 12, 1967 · N82272 · Substantial damage
- [NTSB LAX67D0300](https://openairdocs.org/ntsb/LAX67D0300.md): Piper PA-23 · Fallbrook, CA · Accident · No injuries · Closed · Feb 11, 1967 · N3217P · Substantial damage
- [NTSB FTW67A0083](https://openairdocs.org/ntsb/FTW67A0083.md): Hawker-Sdly DH125 · New Orleans, LA · Accident · No injuries · Closed · Feb 11, 1967 · N142B · Substantial damage
- [NTSB CHI67F0507](https://openairdocs.org/ntsb/CHI67F0507.md): Cessna 172H · West Chicago, IL · Accident · No injuries · Closed · Feb 9, 1967 · N3735R · Substantial damage
- [NTSB LAX67F0324](https://openairdocs.org/ntsb/LAX67F0324.md): Cessna 182J · Bakersfield, CA · Accident · No injuries · Closed · Feb 7, 1967 · N3467F · Substantial damage
- [NTSB OAK67D0279](https://openairdocs.org/ntsb/OAK67D0279.md): Cessna 180 · Quincy, CA · Accident · No injuries · Closed · Feb 6, 1967 · N5232D · Substantial damage
- [NTSB LAX67F0306](https://openairdocs.org/ntsb/LAX67F0306.md): Stinson 108-3 · Kernville, CA · Accident · Serious injuries · Closed · Feb 5, 1967 · N6584M · Substantial damage
- [NTSB CHI67F0457](https://openairdocs.org/ntsb/CHI67F0457.md): Piper PA-28 · Findlay, OH · Accident · Minor injuries · Closed · Feb 5, 1967 · N9648J · Substantial damage
- [NTSB NYC67F0510](https://openairdocs.org/ntsb/NYC67F0510.md): Beech G35 · Morrisville, VT · Accident · No injuries · Closed · Feb 4, 1967 · N4517D · Substantial damage
- [NTSB NYC67F0508](https://openairdocs.org/ntsb/NYC67F0508.md): Piper PA-22 · Tompkins Cove, NY · Accident · Serious injuries · Closed · Feb 4, 1967 · N634A · Destroyed
- [NTSB CHI67F0494](https://openairdocs.org/ntsb/CHI67F0494.md): Piper PA-28 · Charlotte, MI · Accident · No injuries · Closed · Feb 4, 1967 · N7470R · Substantial damage
- [NTSB CHI67F0483](https://openairdocs.org/ntsb/CHI67F0483.md): Cessna 150F · Northbrook, IL · Accident · Minor injuries · Closed · Feb 4, 1967 · N8022S · Substantial damage
- [NTSB CHI67F0465](https://openairdocs.org/ntsb/CHI67F0465.md): Cessna 172 · Roselle, IL · Accident · No injuries · Closed · Feb 3, 1967 · N6000A · Substantial damage
- [NTSB DIA67D0025](https://openairdocs.org/ntsb/DIA67D0025.md): Cessna Wren · Laurel, MD · Accident · No injuries · Closed · Feb 2, 1967 · M2427X · Substantial damage
- [NTSB LAX67F0268](https://openairdocs.org/ntsb/LAX67F0268.md): Cessna 150F · Huntington B, CA · Accident · Serious injuries · Closed · Feb 1, 1967 · N8910S · 2 aircraft · Substantial damage
- [NTSB LAX67D0385](https://openairdocs.org/ntsb/LAX67D0385.md): Cessna 150 · 29 Palms, CA · Accident · No injuries · Closed · Feb 1, 1967 · N3203X · Substantial damage
- [NTSB FTW67A0078](https://openairdocs.org/ntsb/FTW67A0078.md): Douglas DC-6A · San Antonio, TX · Accident · 3 fatal · Closed · Jan 31, 1967 · N640NA · Destroyed
- [NTSB DEN67D0196](https://openairdocs.org/ntsb/DEN67D0196.md): Cessna 150F · Longmont, CO · Accident · Minor injuries · Closed · Jan 31, 1967 · N8701S · Substantial damage
- [NTSB DEN67D0219](https://openairdocs.org/ntsb/DEN67D0219.md): Cessna 150 · Steamboat Sp, CO · Accident · No injuries · Closed · Jan 29, 1967 · N7031F · Substantial damage
- [NTSB MIA67D0537](https://openairdocs.org/ntsb/MIA67D0537.md): Cessna 150G · Winnsboro, SC · Accident · Minor injuries · Closed · Jan 28, 1967 · N4095J · Substantial damage
- [NTSB DEN67D0197](https://openairdocs.org/ntsb/DEN67D0197.md): Piper PA-32 · Denver, CO · Accident · No injuries · Closed · Jan 28, 1967 · N3730W · Minor damage
- [NTSB NYC67F0490](https://openairdocs.org/ntsb/NYC67F0490.md): Piper PA-28 · Minersville, PA · Accident · Minor injuries · Closed · Jan 27, 1967 · N4564R · Destroyed
- [NTSB MKC67D0407](https://openairdocs.org/ntsb/MKC67D0407.md): Piper J3C-65 · Gordon, NE · Accident · No injuries · Closed · Jan 27, 1967 · N3423N · Substantial damage
- [NTSB FTW67F0434](https://openairdocs.org/ntsb/FTW67F0434.md): Piper PA-24 · Angleton, TX · Accident · No injuries · Closed · Jan 26, 1967 · N7797P · Substantial damage
- [NTSB NYC67A0107](https://openairdocs.org/ntsb/NYC67A0107.md): Beech 65 · Armonk, NY · Accident · 3 fatal · Closed · Jan 25, 1967 · N345F · Destroyed
- [NTSB MIA67D0384](https://openairdocs.org/ntsb/MIA67D0384.md): Cessna 150 · Orlando, FL · Accident · No injuries · Closed · Jan 25, 1967 · N4627X · Substantial damage
- [NTSB DIA67D0022](https://openairdocs.org/ntsb/DIA67D0022.md): Cessna 150 · Sapphire, NC · Accident · No injuries · Closed · Jan 25, 1967 · N6072T · Substantial damage
- [NTSB CHI67F0561](https://openairdocs.org/ntsb/CHI67F0561.md): Beech B95 · Bloomington, IN · Accident · 2 fatal · Closed · Jan 25, 1967 · N399Z · Destroyed

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

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

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