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

## Cases, newest first

- [NTSB CHI67D0417](https://openairdocs.org/ntsb/CHI67D0417.md): Cessna 172 · Bloomingdale, IN · Accident · No injuries · Closed · Dec 26, 1966 · N2558U · Substantial damage
- [NTSB NYC67F0438](https://openairdocs.org/ntsb/NYC67F0438.md): Luscombe 8E · Aliquippa, PA · Accident · No injuries · Closed · Dec 25, 1966 · N2527K · Destroyed
- [NTSB MIA67F0539](https://openairdocs.org/ntsb/MIA67F0539.md): Champion 7GCAA · Tallahassee, FL · Accident · No injuries · Closed · Dec 24, 1966 · N8370V · Substantial damage
- [NTSB DCA67R0001](https://openairdocs.org/ntsb/DCA67R0001.md): Canadair CL-44 · Tourane, VM · Accident · 4 fatal · Closed · Dec 24, 1966 · N228SW · Destroyed
- [NTSB OAK67D0184](https://openairdocs.org/ntsb/OAK67D0184.md): Stinson 108 · Columbia, CA · Accident · No injuries · Closed · Dec 23, 1966 · N97358 · Substantial damage
- [NTSB NYC67D0474](https://openairdocs.org/ntsb/NYC67D0474.md): Cessna 150 · Morristown, NJ · Accident · No injuries · Closed · Dec 23, 1966 · N3516J · Substantial damage
- [NTSB CHI67A0083](https://openairdocs.org/ntsb/CHI67A0083.md): Scheutzow B · Brunswick, OH · Accident · No injuries · Closed · Dec 23, 1966 · N592A · Substantial damage
- [NTSB OAK67F0209](https://openairdocs.org/ntsb/OAK67F0209.md): Cessna 172 · Bishop, CA · Accident · No injuries · Closed · Dec 22, 1966 · N3579S · Destroyed
- [NTSB SEA67D0266](https://openairdocs.org/ntsb/SEA67D0266.md): Aeronca 7AC · Circle, MT · Accident · No injuries · Closed · Dec 20, 1966 · N2849E · Substantial damage
- [NTSB FTW67D0348](https://openairdocs.org/ntsb/FTW67D0348.md): Cessna 182 · Muleshoe, TX · Accident · No injuries · Closed · Dec 20, 1966 · N8399S · Substantial damage
- [NTSB MKC67F0394](https://openairdocs.org/ntsb/MKC67F0394.md): Cessna 172E · Farmington, MO · Accident · Serious injuries · Closed · Dec 19, 1966 · N5732T · Destroyed
- [NTSB FTW67F0347](https://openairdocs.org/ntsb/FTW67F0347.md): Cessna 172G · Pearland, TX · Accident · Minor injuries · Closed · Dec 19, 1966 · N3728L · Substantial damage
- [NTSB CHI67F0438](https://openairdocs.org/ntsb/CHI67F0438.md): Aero Comdr 680F · Elkhart, IN · Accident · Serious injuries · Closed · Dec 19, 1966 · N342WS · Destroyed
- [NTSB CHI67F0396](https://openairdocs.org/ntsb/CHI67F0396.md): Beech 35-33 · Saginaw, MI · Accident · No injuries · Closed · Dec 18, 1966 · N109VW · Destroyed
- [NTSB NYC67D0447](https://openairdocs.org/ntsb/NYC67D0447.md): Cessna 150 · West Caldwell, NJ · Accident · No injuries · Closed · Dec 16, 1966 · N8224F · Substantial damage
- [NTSB DEN67D0186](https://openairdocs.org/ntsb/DEN67D0186.md): Aeronca 7AC · Layton, UT · Accident · Minor injuries · Closed · Dec 16, 1966 · N81973 · Substantial damage
- [NTSB CHI67A0077](https://openairdocs.org/ntsb/CHI67A0077.md): Piper PA-30B · Bloomington, IL · Accident · Serious injuries · Closed · Dec 16, 1966 · N8162Y · Substantial damage
- [NTSB CHI67F0397](https://openairdocs.org/ntsb/CHI67F0397.md): Cessna 210E · Minford, OH · Accident · Serious injuries · Closed · Dec 15, 1966 · N377Y · Destroyed
- [NTSB MIA67F0468](https://openairdocs.org/ntsb/MIA67F0468.md): Piper PA-24 · Pensacola, FL · Accident · No injuries · Closed · Dec 14, 1966 · N6992P · Substantial damage
- [NTSB LAX67D0219](https://openairdocs.org/ntsb/LAX67D0219.md): Beech A23 · Santa Susan, CA · Accident · No injuries · Closed · Dec 13, 1966 · N5667S · Substantial damage
- [NTSB OAK67D0193](https://openairdocs.org/ntsb/OAK67D0193.md): Aeronca 7CCM · Fallon, NV · Accident · No injuries · Closed · Dec 11, 1966 · N82265 · Substantial damage
- [NTSB DIA67F0001](https://openairdocs.org/ntsb/DIA67F0001.md): Piper PA-15 · Wakefield, VA · Accident · No injuries · Closed · Dec 11, 1966 · N4477H · Substantial damage
- [NTSB OAK67D0191](https://openairdocs.org/ntsb/OAK67D0191.md): Cessna 182 · Halawa, HI · Accident · No injuries · Closed · Dec 10, 1966 · N5332B · Substantial damage
- [NTSB LAX67D0257](https://openairdocs.org/ntsb/LAX67D0257.md): Globe GC-1B · Riverside, CA · Accident · No injuries · Closed · Dec 10, 1966 · N80664 · Substantial damage
- [NTSB MKC67F0424](https://openairdocs.org/ntsb/MKC67F0424.md): Cessna 150F · Ft.Riley, KS · Accident · Serious injuries · Closed · Dec 8, 1966 · N7862F · Substantial damage
- [NTSB MIA67F0350](https://openairdocs.org/ntsb/MIA67F0350.md): Piper PA-23 · Charleston, SC · Accident · No injuries · Closed · Dec 8, 1966 · N6162Y · Substantial damage
- [NTSB FTW67A0063](https://openairdocs.org/ntsb/FTW67A0063.md): Cessna 150 · New Orleans, LA · Accident · 1 fatal · Closed · Dec 8, 1966 · 7Q-YFC · Destroyed
- [NTSB OAK67D0187](https://openairdocs.org/ntsb/OAK67D0187.md): Cessna 150 · Sunnyvale, CA · Accident · Minor injuries · Closed · Dec 7, 1966 · N5937T · Substantial damage
- [NTSB FTW67F0343](https://openairdocs.org/ntsb/FTW67F0343.md): Temco D-16A · Saginaw, TX · Accident · Minor injuries · Closed · Dec 4, 1966 · N129N · Substantial damage
- [NTSB FTW67A0060](https://openairdocs.org/ntsb/FTW67A0060.md): Cessna 182 · Ponca City, OK · Accident · 1 fatal · Closed · Dec 4, 1966 · N8612T · Destroyed
- [NTSB MIA67D0324](https://openairdocs.org/ntsb/MIA67D0324.md): Cessna 172 · Lakeland, GA · Accident · Minor injuries · Closed · Dec 3, 1966 · N7752X · Substantial damage
- [NTSB FTW67A0058](https://openairdocs.org/ntsb/FTW67A0058.md): Lockheed 12A · Oklahoma Cty, OK · Accident · No injuries · Closed · Dec 1, 1966 · N16085 · Substantial damage
- [NTSB LAX67A0054](https://openairdocs.org/ntsb/LAX67A0054.md): Cessna 150 · Santee, CA · Accident · 1 fatal · Closed · Nov 30, 1966 · N6955F · Destroyed
- [NTSB CHI67F0381](https://openairdocs.org/ntsb/CHI67F0381.md): Piper PA-23 · Springboro, OH · Accident · Minor injuries · Closed · Nov 28, 1966 · N3175P · Substantial damage
- [NTSB NYC67F0462](https://openairdocs.org/ntsb/NYC67F0462.md): Luscombe 8A · Norwood, MA · Accident · Minor injuries · Closed · Nov 27, 1966 · N71280 · Substantial damage
- [NTSB CHI67D0418](https://openairdocs.org/ntsb/CHI67D0418.md): Cessna 172 · Kasbeer, IL · Accident · Minor injuries · Closed · Nov 26, 1966 · N3588S · Substantial damage
- [NTSB MIA67D0327](https://openairdocs.org/ntsb/MIA67D0327.md): Beech 23 · Coakley Tn, Burkina Faso · Accident · No injuries · Closed · Nov 25, 1966 · N5969S · Substantial damage
- [NTSB OAK67F0192](https://openairdocs.org/ntsb/OAK67F0192.md): Cessna 172G · San Jose, CA · Accident · Minor injuries · Closed · Nov 23, 1966 · N4363L · Substantial damage
- [NTSB NYC67A0085](https://openairdocs.org/ntsb/NYC67A0085.md): Piper PA-18 · Northeast, PA · Accident · 1 fatal · Closed · Nov 23, 1966 · N4202Z · Destroyed
- [NTSB MKC67F0353](https://openairdocs.org/ntsb/MKC67F0353.md): Mooney M20E · Council Blfs, IA · Accident · Serious injuries · Closed · Nov 23, 1966 · N79354 · Destroyed
- [NTSB CHI67F0383](https://openairdocs.org/ntsb/CHI67F0383.md): N.American 265-40 · Evansville, IN · Accident · No injuries · Closed · Nov 23, 1966 · N355MJ · Substantial damage
- [NTSB NYC67F0378](https://openairdocs.org/ntsb/NYC67F0378.md): Maule M4 · Mt Pleasant, PA · Accident · No injuries · Closed · Nov 20, 1966 · N4724T · Substantial damage
- [NTSB NYC67D0401](https://openairdocs.org/ntsb/NYC67D0401.md): Piper PA-18 · Richland, NY · Accident · Serious injuries · Closed · Nov 20, 1966 · N3258P · Destroyed
- [NTSB MKC67A0035](https://openairdocs.org/ntsb/MKC67A0035.md): Cessna 150 · Creve Coeur, MO · Accident · 1 fatal · Closed · Nov 20, 1966 · N6791F · Destroyed
- [NTSB OAK67D0176](https://openairdocs.org/ntsb/OAK67D0176.md): Cessna 182D · Bethel Isl., CA · Accident · No injuries · Closed · Nov 19, 1966 · N8948X · Substantial damage
- [NTSB NYC67D0383](https://openairdocs.org/ntsb/NYC67D0383.md): Piper PA28 · Bridgeton, NJ · Accident · No injuries · Closed · Nov 19, 1966 · N5779W · Substantial damage
- [NTSB DEN67F0153](https://openairdocs.org/ntsb/DEN67F0153.md): Cessna 150 · Albuquerque, NM · Accident · No injuries · Closed · Nov 19, 1966 · N7931F · Substantial damage
- [NTSB OAK67D0168](https://openairdocs.org/ntsb/OAK67D0168.md): Piper J4A · Orland, CA · Accident · No injuries · Closed · Nov 18, 1966 · N33194 · Substantial damage
- [NTSB NYC67D0394](https://openairdocs.org/ntsb/NYC67D0394.md): Cessna 150 · Amagansett, NY · Accident · No injuries · Closed · Nov 18, 1966 · N8170F · Substantial damage
- [NTSB MIA67D0332](https://openairdocs.org/ntsb/MIA67D0332.md): Cessna 150G · Melbourne, FL · Accident · No injuries · Closed · Nov 18, 1966 · N3859J · Substantial damage

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

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

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