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

## Cases, newest first

- [NTSB OAK68F0089](https://openairdocs.org/ntsb/OAK68F0089.md): Beech G35 · Napa, CA · Accident · No injuries · Closed · Aug 12, 1967 · N4203D · Substantial damage
- [NTSB DIA68F0051](https://openairdocs.org/ntsb/DIA68F0051.md): Piper PA-30 · Morganton, NC · Accident · No injuries · Closed · Aug 12, 1967 · N8174Y · Substantial damage
- [NTSB CHI68F0226](https://openairdocs.org/ntsb/CHI68F0226.md): Cessna 180 · West Chicago, IL · Accident · Serious injuries · Closed · Aug 12, 1967 · N9182C · Substantial damage
- [NTSB MIA68F0165](https://openairdocs.org/ntsb/MIA68F0165.md): Aeronca 11AC · Carnegie, GA · Accident · Serious injuries · Closed · Aug 11, 1967 · N85840 · Substantial damage
- [NTSB MIA68F0126](https://openairdocs.org/ntsb/MIA68F0126.md): Piper PA-28 · Nashville, TN · Accident · Minor injuries · Closed · Aug 11, 1967 · N9662W · Substantial damage
- [NTSB CHI68F0200](https://openairdocs.org/ntsb/CHI68F0200.md): Mooney M20F · Yale, MI · Accident · No injuries · Closed · Aug 11, 1967 · N6319Q · Substantial damage
- [NTSB SEA68A0014](https://openairdocs.org/ntsb/SEA68A0014.md): Piper PA-11 · Dayton, WA · Accident · 2 fatal · Closed · Aug 10, 1967 · N78736 · Destroyed
- [NTSB MKC68D0401](https://openairdocs.org/ntsb/MKC68D0401.md): Beech 95-B55 · Chesterfield, MO · Accident · No injuries · Closed · Aug 10, 1967 · N8689Q · Substantial damage
- [NTSB MKC68F0128](https://openairdocs.org/ntsb/MKC68F0128.md): Cessna T-210G · Grand Island, NE · Accident · Minor injuries · Closed · Aug 8, 1967 · N6886R · Substantial damage
- [NTSB MIA68F0133](https://openairdocs.org/ntsb/MIA68F0133.md): Piper PA-30 · W.Palm Beach, FL · Accident · No injuries · Closed · Aug 8, 1967 · N8051Y · Substantial damage
- [NTSB DEN68A0012](https://openairdocs.org/ntsb/DEN68A0012.md): Bell 47G3B1 · Holoman Afb, NM · Accident · No injuries · Closed · Aug 8, 1967 · N1361X · Substantial damage
- [NTSB OAK68D0221](https://openairdocs.org/ntsb/OAK68D0221.md): Beech J35 · Colusa, CA · Accident · No injuries · Closed · Aug 7, 1967 · N8337D · Substantial damage
- [NTSB OAK68A0010](https://openairdocs.org/ntsb/OAK68A0010.md): Bell 47G-3B · Clearlake, CA · Accident · No injuries · Closed · Aug 6, 1967 · N73285 · Substantial damage
- [NTSB NYC68A0024](https://openairdocs.org/ntsb/NYC68A0024.md): Piper PA-28 · Laconia, NH · Accident · 5 fatal · Closed · Aug 6, 1967 · N4226J · 2 aircraft · Destroyed
- [NTSB CHI68F0141](https://openairdocs.org/ntsb/CHI68F0141.md): Erco 415-C · Greencastle.Ind, IN · Accident · Minor injuries · Closed · Aug 6, 1967 · N99406 · Destroyed
- [NTSB NYC68F0092](https://openairdocs.org/ntsb/NYC68F0092.md): Boeing A75 · Bridgeton, NJ · Accident · No injuries · Closed · Aug 5, 1967 · N49645 · Substantial damage
- [NTSB NYC68D0122](https://openairdocs.org/ntsb/NYC68D0122.md): Aeronca 11AC · Morrisdale, PA · Accident · No injuries · Closed · Aug 5, 1967 · N9645E · Substantial damage
- [NTSB MKC68D0157](https://openairdocs.org/ntsb/MKC68D0157.md): Cessna 172 · Mclouth, KS · Accident · No injuries · Closed · Aug 5, 1967 · N5787R · Substantial damage
- [NTSB CHI68F0431](https://openairdocs.org/ntsb/CHI68F0431.md): Luscombe 8A · Long Grove, IL · Accident · Minor injuries · Closed · Aug 4, 1967 · N4948E · Substantial damage
- [NTSB SEA68A0011](https://openairdocs.org/ntsb/SEA68A0011.md): Piper PA-28 · Sisters, OR · Accident · 4 fatal · Closed · Aug 3, 1967 · N9154W · Destroyed
- [NTSB MKC68F0099](https://openairdocs.org/ntsb/MKC68F0099.md): Cessna 180H · Oneill, NE · Accident · No injuries · Closed · Aug 3, 1967 · N9913V · Substantial damage
- [NTSB MKC68D0098](https://openairdocs.org/ntsb/MKC68D0098.md): Piper PA-22 · Des Moines, IA · Accident · No injuries · Closed · Aug 3, 1967 · N4526Z · Substantial damage
- [NTSB CHI68F0185](https://openairdocs.org/ntsb/CHI68F0185.md): Cessna 172G · Greenwood, IL · Accident · Minor injuries · Closed · Aug 3, 1967 · N4492L · Substantial damage
- [NTSB MKC68F0212](https://openairdocs.org/ntsb/MKC68F0212.md): Beech 95-B55 · St.Joseph, MO · Accident · No injuries · Closed · Aug 2, 1967 · N262Q · Substantial damage
- [NTSB DEN68F0053](https://openairdocs.org/ntsb/DEN68F0053.md): Beech H35 · Ogden, UT · Accident · No injuries · Closed · Aug 2, 1967 · N5462D · Substantial damage
- [NTSB MKC68A0008](https://openairdocs.org/ntsb/MKC68A0008.md): Taylorcraft BC12-D · Le Mars, IA · Accident · 1 fatal · Closed · Aug 1, 1967 · N43350 · 2 aircraft · Destroyed
- [NTSB DEN68F0040](https://openairdocs.org/ntsb/DEN68F0040.md): Champion 7GC · Albuquerque, NM · Accident · Serious injuries · Closed · Aug 1, 1967 · N8547E · Substantial damage
- [NTSB CHI68D0273](https://openairdocs.org/ntsb/CHI68D0273.md): Cessna 172 · Lansing, IL · Accident · Minor injuries · Closed · Aug 1, 1967 · N5115A · Substantial damage
- [NTSB CHI68F0214](https://openairdocs.org/ntsb/CHI68F0214.md): Piper PA-18 · Detour Vill, MI · Accident · Serious injuries · Closed · Jul 31, 1967 · N2363A · Destroyed
- [NTSB SEA68F0080](https://openairdocs.org/ntsb/SEA68F0080.md): Taylorcraft BC12-D · Puyallup, WA · Accident · Minor injuries · Closed · Jul 30, 1967 · N96298 · Substantial damage
- [NTSB CHI68D0175](https://openairdocs.org/ntsb/CHI68D0175.md): Schweizer 2-32 · Naperville, IL · Accident · No injuries · Closed · Jul 30, 1967 · N2771Z · Substantial damage
- [NTSB OAK68D0185](https://openairdocs.org/ntsb/OAK68D0185.md): Schweizer SGS2-8 · Auburn, CA · Accident · Minor injuries · Closed · Jul 29, 1967 · N50796 · Destroyed
- [NTSB DIA68F0049](https://openairdocs.org/ntsb/DIA68F0049.md): Navion C · Roanoke, VA · Accident · No injuries · Closed · Jul 29, 1967 · N3972A · Substantial damage
- [NTSB CHI68D0389](https://openairdocs.org/ntsb/CHI68D0389.md): Cessna 180 · Fairmount, IL · Accident · No injuries · Closed · Jul 26, 1967 · N4709B · Substantial damage
- [NTSB CHI68A0012](https://openairdocs.org/ntsb/CHI68A0012.md): Taylorcraft BC12-D · Holcombe, WI · Accident · 2 fatal · Closed · Jul 26, 1967 · N96507 · Destroyed
- [NTSB CHI68D0324](https://openairdocs.org/ntsb/CHI68D0324.md): Curtis Scout · Waukesha, WI · Accident · Minor injuries · Closed · Jul 25, 1967 · N2021 · Substantial damage
- [NTSB ANC68F0094](https://openairdocs.org/ntsb/ANC68F0094.md): Beech A23 · Copper Centr, AK · Accident · No injuries · Closed · Jul 25, 1967 · N7971L · Substantial damage
- [NTSB LAX68F0080](https://openairdocs.org/ntsb/LAX68F0080.md): Cessna 140 · Tucson, AZ · Accident · No injuries · Closed · Jul 24, 1967 · N1634V · Substantial damage
- [NTSB CHI68D0375](https://openairdocs.org/ntsb/CHI68D0375.md): Cessna 172 · Ft.Atkinson, WI · Accident · No injuries · Closed · Jul 24, 1967 · N7248T · Substantial damage
- [NTSB SEA68F0055](https://openairdocs.org/ntsb/SEA68F0055.md): Beech A23 · Metaline Fls, WA · Accident · No injuries · Closed · Jul 23, 1967 · N2350W · Substantial damage
- [NTSB OAK68F0052](https://openairdocs.org/ntsb/OAK68F0052.md): Piper PA-28 · S Lke Tahoe, CA · Accident · Serious injuries · Closed · Jul 23, 1967 · N7841W · Substantial damage
- [NTSB NYC68D0070](https://openairdocs.org/ntsb/NYC68D0070.md): Navion B · Elysburg, PA · Accident · No injuries · Closed · Jul 23, 1967 · N5259K · Substantial damage
- [NTSB MKC68F0081](https://openairdocs.org/ntsb/MKC68F0081.md): Buluey Sport · Hutchinson, KS · Accident · 1 fatal · Closed · Jul 23, 1967 · N6376V · Destroyed
- [NTSB LAX68F0076](https://openairdocs.org/ntsb/LAX68F0076.md): Erco 415-C · Murrieta, CA · Accident · Serious injuries · Closed · Jul 23, 1967 · N99397 · Substantial damage
- [NTSB DEN68F0034](https://openairdocs.org/ntsb/DEN68F0034.md): Cessna 320A · Alamosa, CO · Accident · Serious injuries · Closed · Jul 23, 1967 · N3017R · Destroyed
- [NTSB CHI68D0314](https://openairdocs.org/ntsb/CHI68D0314.md): Cessna 182 · Seneca, IL · Accident · No injuries · Closed · Jul 23, 1967 · N5584B · Substantial damage
- [NTSB MKC68D0131](https://openairdocs.org/ntsb/MKC68D0131.md): Cessna 150 · St.Charles, MO · Accident · No injuries · Closed · Jul 22, 1967 · N8666S · Substantial damage
- [NTSB DIA68D0048](https://openairdocs.org/ntsb/DIA68D0048.md): Piper PA-28 · Baltimore, MD · Accident · No injuries · Closed · Jul 22, 1967 · N9682W · Substantial damage
- [NTSB SEA68F0060](https://openairdocs.org/ntsb/SEA68F0060.md): Taylorcraft DC-65 · Mountain Home, ID · Accident · Minor injuries · Closed · Jul 21, 1967 · N62798 · Substantial damage
- [NTSB MKC68D0180](https://openairdocs.org/ntsb/MKC68D0180.md): Beech P35 · Leawood, KS · Accident · No injuries · Closed · Jul 21, 1967 · N9596Y · Substantial damage

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

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

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