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

## Cases, newest first

- [NTSB DEN68F0171](https://openairdocs.org/ntsb/DEN68F0171.md): Beech M35 · Roswell, NM · Accident · No injuries · Closed · Nov 28, 1967 · N329Z · Substantial damage
- [NTSB LAX68D0237](https://openairdocs.org/ntsb/LAX68D0237.md): Beech A23 · Bakersfield, CA · Accident · Minor injuries · Closed · Nov 27, 1967 · N2319Z · Substantial damage
- [NTSB FTW68A0055](https://openairdocs.org/ntsb/FTW68A0055.md): Cessna 310H · Alpine, TX · Accident · 1 fatal · Closed · Nov 27, 1967 · N1118Q · Destroyed
- [NTSB OAK68F0257](https://openairdocs.org/ntsb/OAK68F0257.md): Stinson 108-1 · San Jose, CA · Accident · Serious injuries · Closed · Nov 26, 1967 · N97074 · Substantial damage
- [NTSB NYC68D0287](https://openairdocs.org/ntsb/NYC68D0287.md): Piper PA-28 · Chesterfield, MA · Accident · No injuries · Closed · Nov 26, 1967 · N3946K · Substantial damage
- [NTSB MKC68F0393](https://openairdocs.org/ntsb/MKC68F0393.md): Beech A23 · Askov, MN · Accident · Serious injuries · Closed · Nov 26, 1967 · N4726J · Substantial damage
- [NTSB MIA68D0293](https://openairdocs.org/ntsb/MIA68D0293.md): Piper J3C-65 · Benoit, MS · Accident · No injuries · Closed · Nov 26, 1967 · N6681H · Substantial damage
- [NTSB OAK68A0047](https://openairdocs.org/ntsb/OAK68A0047.md): Beech C-45H · Sanger, CA · Accident · 3 fatal · Closed · Nov 25, 1967 · N9450Z · Destroyed
- [NTSB DEN68A0023](https://openairdocs.org/ntsb/DEN68A0023.md): Mooney M20E · Glenwood Spg, CO · Accident · 1 fatal · Closed · Nov 25, 1967 · N3392X · Destroyed
- [NTSB CHI68D0531](https://openairdocs.org/ntsb/CHI68D0531.md): Cessna 172 · Painesville, OH · Accident · No injuries · Closed · Nov 25, 1967 · N3906L · Substantial damage
- [NTSB LAX68F0310](https://openairdocs.org/ntsb/LAX68F0310.md): Cessna 320 · Santa Ana, CA · Accident · No injuries · Closed · Nov 24, 1967 · N3409Q · Substantial damage
- [NTSB DIA68A0022](https://openairdocs.org/ntsb/DIA68A0022.md): Piper PA-23 · Sandston, VA · Accident · Serious injuries · Closed · Nov 24, 1967 · N6106Y · Destroyed
- [NTSB CHI68F0438](https://openairdocs.org/ntsb/CHI68F0438.md): Piper PA-22 · Indianapolis, IN · Accident · No injuries · Closed · Nov 23, 1967 · N9600D · Substantial damage
- [NTSB FTW68D0355](https://openairdocs.org/ntsb/FTW68D0355.md): Beech 65-A80 · Concan, TX · Accident · No injuries · Closed · Nov 22, 1967 · N899Q · Destroyed
- [NTSB CHI68A0047](https://openairdocs.org/ntsb/CHI68A0047.md): Piper PA-24 · Davisburg, MI · Accident · 3 fatal · Closed · Nov 21, 1967 · N7165P · Destroyed
- [NTSB FTW68D0354](https://openairdocs.org/ntsb/FTW68D0354.md): Cessna 150 · Sand Springs, OK · Accident · No injuries · Closed · Nov 20, 1967 · N3288J · Substantial damage
- [NTSB DCA68A0002](https://openairdocs.org/ntsb/DCA68A0002.md): Convair 880 · Constance, KY · Accident · 69 fatal · Closed · Nov 20, 1967 · N821TW · Destroyed
- [NTSB FTW68F0416](https://openairdocs.org/ntsb/FTW68F0416.md): Boeing E75 · Lancaster, TX · Accident · Serious injuries · Closed · Nov 19, 1967 · N16716 · Substantial damage
- [NTSB CHI68F0462](https://openairdocs.org/ntsb/CHI68F0462.md): Mooney 20C · Columbus, OH · Accident · Minor injuries · Closed · Nov 19, 1967 · N78912 · Substantial damage
- [NTSB CHI68A0046](https://openairdocs.org/ntsb/CHI68A0046.md): Cessna 172E · Jamestown, KY · Accident · 3 fatal · Closed · Nov 19, 1967 · N5460T · Destroyed
- [NTSB NYC68D0289](https://openairdocs.org/ntsb/NYC68D0289.md): Ryan ST-3KR · Berlin, NJ · Accident · No injuries · Closed · Nov 18, 1967 · N48928 · Substantial damage
- [NTSB FTW68F0363](https://openairdocs.org/ntsb/FTW68F0363.md): Piper PA-22 · Claude, TX · Accident · Serious injuries · Closed · Nov 18, 1967 · N3235Z · Substantial damage
- [NTSB FTW68A0050](https://openairdocs.org/ntsb/FTW68A0050.md): N American P-51 · Brownwood, TX · Accident · 1 fatal · Closed · Nov 18, 1967 · N12065 · Destroyed
- [NTSB DIA68D0126](https://openairdocs.org/ntsb/DIA68D0126.md): Cessna 170 · Laurel, MD · Accident · No injuries · Closed · Nov 18, 1967 · N2541V · Substantial damage
- [NTSB NYC68A0073](https://openairdocs.org/ntsb/NYC68A0073.md): Piper PA-28 · Lakewood, NJ · Accident · 2 fatal · Closed · Nov 17, 1967 · N4492J · Destroyed
- [NTSB CHI68F0542](https://openairdocs.org/ntsb/CHI68F0542.md): Piper PA-30 · Chagrin Flls, OH · Accident · Serious injuries · Closed · Nov 17, 1967 · N7704Y · Destroyed
- [NTSB CHI68D0488](https://openairdocs.org/ntsb/CHI68D0488.md): Beech A23A · Toledo, OH · Accident · No injuries · Closed · Nov 17, 1967 · CF-VMA · Substantial damage
- [NTSB MIA68A0046](https://openairdocs.org/ntsb/MIA68A0046.md): Beech C35 · Birmingham, AL · Accident · 3 fatal · Closed · Nov 16, 1967 · N8985A · Destroyed
- [NTSB MIA68F0339](https://openairdocs.org/ntsb/MIA68F0339.md): Piper PA-24 · Muscle Shoals, AL · Accident · Minor injuries · Closed · Nov 14, 1967 · N5203P · Substantial damage
- [NTSB LAX68F0213](https://openairdocs.org/ntsb/LAX68F0213.md): Cessna 172 · San Fernand, CA · Accident · Minor injuries · Closed · Nov 13, 1967 · N368SR · Destroyed
- [NTSB CHI68D0439](https://openairdocs.org/ntsb/CHI68D0439.md): Champion 7FC · Monticello, IL · Accident · Minor injuries · Closed · Nov 13, 1967 · N7696E · Substantial damage
- [NTSB NYC68F0294](https://openairdocs.org/ntsb/NYC68F0294.md): Mooney M20 · Scandia, PA · Accident · Serious injuries · Closed · Nov 12, 1967 · N1958Y · Substantial damage
- [NTSB MKC68D0341](https://openairdocs.org/ntsb/MKC68D0341.md): Beech 35 · Smith Center, KS · Accident · No injuries · Closed · Nov 12, 1967 · N4540V · Substantial damage
- [NTSB MIA68F0279](https://openairdocs.org/ntsb/MIA68F0279.md): Piper PA-32 · Humacao, PR · Accident · No injuries · Closed · Nov 12, 1967 · N4041W · Destroyed
- [NTSB CHI68F0476](https://openairdocs.org/ntsb/CHI68F0476.md): Beech V35 · Springfield, IL · Accident · Minor injuries · Closed · Nov 12, 1967 · N9486S · Substantial damage
- [NTSB MKC68D0346](https://openairdocs.org/ntsb/MKC68D0346.md): Cessna 172 · Blair, NE · Accident · No injuries · Closed · Nov 11, 1967 · N6976A · Substantial damage
- [NTSB MKC68D0343](https://openairdocs.org/ntsb/MKC68D0343.md): Erco 415-D · Oelwein, IA · Accident · No injuries · Closed · Nov 11, 1967 · N94642 · Substantial damage
- [NTSB ANC68A0028](https://openairdocs.org/ntsb/ANC68A0028.md): Piper PA-12 · Skwentna, AK · Accident · No injuries · Closed · Nov 11, 1967 · N3595M · Substantial damage
- [NTSB DEN68D0138](https://openairdocs.org/ntsb/DEN68D0138.md): Globe GC-1B · Aurora, CO · Accident · No injuries · Closed · Nov 10, 1967 · N3246K · Substantial damage
- [NTSB LAX68D0248](https://openairdocs.org/ntsb/LAX68D0248.md): Cessna 150H · Etiwanda, CA · Accident · No injuries · Closed · Nov 9, 1967 · N6738S · Substantial damage
- [NTSB OAK68A0042](https://openairdocs.org/ntsb/OAK68A0042.md): Cessna 310C · Salinas, CA · Accident · 1 fatal · Closed · Nov 8, 1967 · N6684B · Destroyed
- [NTSB CHI68F0435](https://openairdocs.org/ntsb/CHI68F0435.md): Cessna 195 · Sandwich, IL · Accident · Minor injuries · Closed · Nov 8, 1967 · N3452V · Destroyed
- [NTSB NYC68F0282](https://openairdocs.org/ntsb/NYC68F0282.md): Cessna 150F · Plainville, CT · Accident · No injuries · Closed · Nov 5, 1967 · N8218F · Substantial damage
- [NTSB NYC68F0274](https://openairdocs.org/ntsb/NYC68F0274.md): Cessna 150E · Morganville, NJ · Accident · Serious injuries · Closed · Nov 5, 1967 · N3927U · Destroyed
- [NTSB NYC68F0267](https://openairdocs.org/ntsb/NYC68F0267.md): Taylorcraft BC12D1 · Waterville, ME · Accident · No injuries · Closed · Nov 5, 1967 · N44444 · Substantial damage
- [NTSB LAX68A0046](https://openairdocs.org/ntsb/LAX68A0046.md): Bensen B8M · Chula Vista, CA · Accident · 1 fatal · Closed · Nov 5, 1967 · N7107 · Destroyed
- [NTSB DEN68A0022](https://openairdocs.org/ntsb/DEN68A0022.md): Cessna 172 · Greeley, CO · Accident · 4 fatal · Closed · Nov 5, 1967 · N1754F · 2 aircraft · Destroyed
- [NTSB CHI68F0420](https://openairdocs.org/ntsb/CHI68F0420.md): Beech 95-55 · Prt St.James, MI · Accident · Minor injuries · Closed · Nov 5, 1967 · N8637Q · Destroyed
- [NTSB SEA68F0212](https://openairdocs.org/ntsb/SEA68F0212.md): Piper PA-24 · Ocean Shores, WA · Accident · No injuries · Closed · Nov 4, 1967 · N6116P · 2 aircraft · Substantial damage
- [NTSB SEA68F0201](https://openairdocs.org/ntsb/SEA68F0201.md): Stinson 10A · Kettle Falls, WA · Accident · No injuries · Closed · Nov 4, 1967 · N32298 · Substantial damage

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

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

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