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

## Cases, newest first

- [NTSB OAK68D0236](https://openairdocs.org/ntsb/OAK68D0236.md): Alon A-2 · Chico, CA · Accident · No injuries · Closed · Nov 3, 1967 · N5673F · Substantial damage
- [NTSB OAK68A0039](https://openairdocs.org/ntsb/OAK68A0039.md): Cessna 150G · Beckwourth, CA · Accident · 2 fatal · Closed · Nov 3, 1967 · N3704J · Destroyed
- [NTSB MIA68F0267](https://openairdocs.org/ntsb/MIA68F0267.md): Piper PA-24 · Birmingham, AL · Accident · Serious injuries · Closed · Nov 3, 1967 · N7034P · Substantial damage
- [NTSB FTW68F0326](https://openairdocs.org/ntsb/FTW68F0326.md): Beech B50 · Mcallen, TX · Accident · No injuries · Closed · Nov 3, 1967 · N3674B · Substantial damage
- [NTSB CHI68F0457](https://openairdocs.org/ntsb/CHI68F0457.md): Cessna 421 · Findlay, OH · Accident · Minor injuries · Closed · Nov 3, 1967 · N4019L · Destroyed
- [NTSB SEA68A0039](https://openairdocs.org/ntsb/SEA68A0039.md): Convair 340T · Great Falls, MT · Accident · Minor injuries · Closed · Nov 1, 1967 · N73120 · Substantial damage
- [NTSB LAX68A0045](https://openairdocs.org/ntsb/LAX68A0045.md): Cessna 182 · Grand Canyon, AZ · Accident · 5 fatal · Closed · Nov 1, 1967 · N3555Y · Destroyed
- [NTSB MIA68F0283](https://openairdocs.org/ntsb/MIA68F0283.md): Lear Jet 23 · Huntsville, AL · Accident · No injuries · Closed · Oct 31, 1967 · N825LJ · Substantial damage
- [NTSB MIA68D0249](https://openairdocs.org/ntsb/MIA68D0249.md): Cessna 182 · Dayton, TN · Accident · No injuries · Closed · Oct 31, 1967 · N3586F · Substantial damage
- [NTSB DIA68F0128](https://openairdocs.org/ntsb/DIA68F0128.md): Piper PA-28 · Greensboro, NC · Accident · No injuries · Closed · Oct 30, 1967 · N7950W · Substantial damage
- [NTSB MIA68F0263](https://openairdocs.org/ntsb/MIA68F0263.md): Cessna 120 · Venice, FL · Accident · Serious injuries · Closed · Oct 29, 1967 · N1788V · Substantial damage
- [NTSB MIA68D0316](https://openairdocs.org/ntsb/MIA68D0316.md): Cessna 150F · Opa Locka, FL · Accident · No injuries · Closed · Oct 29, 1967 · N8793G · Substantial damage
- [NTSB LAX68F0183](https://openairdocs.org/ntsb/LAX68F0183.md): Cessna 150 · Otay, CA · Accident · No injuries · Closed · Oct 29, 1967 · N6661F · 2 aircraft · Minor damage
- [NTSB OAK68D0181](https://openairdocs.org/ntsb/OAK68D0181.md): Cessna 150G · Concord, CA · Accident · Minor injuries · Closed · Oct 28, 1967 · N4027J · Substantial damage
- [NTSB MKC68D0315](https://openairdocs.org/ntsb/MKC68D0315.md): Piper J-3 · Gothenburg, NE · Accident · Minor injuries · Closed · Oct 28, 1967 · N42663 · Substantial damage
- [NTSB MIA68F0343](https://openairdocs.org/ntsb/MIA68F0343.md): Cessna 172 · Lithonia, GA · Accident · Serious injuries · Closed · Oct 28, 1967 · N8511G · Destroyed
- [NTSB MIA68A0041](https://openairdocs.org/ntsb/MIA68A0041.md): Cessna 150 · Lacy Springs, AL · Accident · 1 fatal · Closed · Oct 28, 1967 · N7797F · Destroyed
- [NTSB MIA68F0262](https://openairdocs.org/ntsb/MIA68F0262.md): Cessna 120 · Newton, MS · Accident · Minor injuries · Closed · Oct 26, 1967 · N1850N · Substantial damage
- [NTSB DIA68F0098](https://openairdocs.org/ntsb/DIA68F0098-112971.md): Cessna 182J · Clinton, MD · Accident · No injuries · Closed · Oct 26, 1967 · N3512F · Substantial damage
- [NTSB CHI68A0039](https://openairdocs.org/ntsb/CHI68A0039.md): Lear Jet 23 · Muskegon, MI · Accident · Minor injuries · Closed · Oct 25, 1967 · N432EJ · Destroyed
- [NTSB NYC68F0264](https://openairdocs.org/ntsb/NYC68F0264.md): Piper PA-28 · Agawam, MA · Accident · Minor injuries · Closed · Oct 24, 1967 · N5602W · Substantial damage
- [NTSB DIA68D0115](https://openairdocs.org/ntsb/DIA68D0115.md): Cessna 150G · Basye, VA · Accident · No injuries · Closed · Oct 24, 1967 · N3711J · Substantial damage
- [NTSB NYC68D0246](https://openairdocs.org/ntsb/NYC68D0246.md): Cessna 182 · Windsor Lock, CT · Accident · No injuries · Closed · Oct 23, 1967 · N2704Q · Substantial damage
- [NTSB MIA68F0260](https://openairdocs.org/ntsb/MIA68F0260.md): Cessna 150 · Dinsmore, FL · Accident · No injuries · Closed · Oct 23, 1967 · N5800E · Substantial damage
- [NTSB NYC68F0300](https://openairdocs.org/ntsb/NYC68F0300.md): Taylorcraft BC12-D · Midway, PA · Accident · Serious injuries · Closed · Oct 22, 1967 · N5049M · Substantial damage
- [NTSB MIA68D0356](https://openairdocs.org/ntsb/MIA68D0356.md): Cessna 150 · Dahlonega, GA · Accident · No injuries · Closed · Oct 22, 1967 · N8225F · Destroyed
- [NTSB CHI68A0037](https://openairdocs.org/ntsb/CHI68A0037.md): Bensen B8M · Lockport, IL · Accident · 1 fatal · Closed · Oct 22, 1967 · N24082 · Destroyed
- [NTSB MIA68D0247](https://openairdocs.org/ntsb/MIA68D0247.md): Globe GC-1B · Kennesaw, GA · Accident · No injuries · Closed · Oct 20, 1967 · N90310 · Substantial damage
- [NTSB NYC68A0062](https://openairdocs.org/ntsb/NYC68A0062.md): Cessna 172 · So.Hackensack, NJ · Accident · 2 fatal · Closed · Oct 19, 1967 · N2473L · Destroyed
- [NTSB LAX68A0041](https://openairdocs.org/ntsb/LAX68A0041.md): Piper PA-28 · W.Los Angeles, CA · Accident · 4 fatal · Closed · Oct 18, 1967 · N5109W · 2 aircraft · Destroyed
- [NTSB FTW68F0285](https://openairdocs.org/ntsb/FTW68F0285.md): Cessna 180 · Morgan City, LA · Accident · No injuries · Closed · Oct 17, 1967 · N2700X · Substantial damage
- [NTSB DIA68F0103](https://openairdocs.org/ntsb/DIA68F0103.md): Piper PA-28 · Laurel, NJ · Accident · Minor injuries · Closed · Oct 17, 1967 · N8372W · Destroyed
- [NTSB DEN68D0125](https://openairdocs.org/ntsb/DEN68D0125.md): Champion 7GCB · Evanston, WY · Accident · No injuries · Closed · Oct 16, 1967 · N9953Y · Substantial damage
- [NTSB LAX68D0211](https://openairdocs.org/ntsb/LAX68D0211.md): Cessna 172 · Lk Havsu Cty, AZ · Accident · No injuries · Closed · Oct 15, 1967 · N7456X · Substantial damage
- [NTSB LAX68D0189](https://openairdocs.org/ntsb/LAX68D0189.md): Schweizer SGS126 · Pearblossom, CA · Accident · No injuries · Closed · Oct 15, 1967 · N3839A · Substantial damage
- [NTSB NYC68D0247](https://openairdocs.org/ntsb/NYC68D0247.md): Schweizer SGU-2 · Barre, MA · Accident · No injuries · Closed · Oct 14, 1967 · N10357 · Substantial damage
- [NTSB LAX68F0225](https://openairdocs.org/ntsb/LAX68F0225.md): Piper PA-24 · Huntington B., CA · Accident · Serious injuries · Closed · Oct 14, 1967 · N6296P · Destroyed
- [NTSB CHI68F0394](https://openairdocs.org/ntsb/CHI68F0394.md): Cessna 310 · South Bend, IN · Accident · No injuries · Closed · Oct 14, 1967 · N6777T · Substantial damage
- [NTSB FTW68F0282](https://openairdocs.org/ntsb/FTW68F0282.md): Cessna 150 · Ferris, TX · Accident · Minor injuries · Closed · Oct 13, 1967 · N8469J · Destroyed
- [NTSB FTW68F0270](https://openairdocs.org/ntsb/FTW68F0270.md): Cessna 150F · Alvin, TX · Accident · No injuries · Closed · Oct 13, 1967 · N8696S · Substantial damage
- [NTSB CHI68A0034](https://openairdocs.org/ntsb/CHI68A0034.md): Beech B95 · Detroit, MI · Accident · 1 fatal · Closed · Oct 13, 1967 · N2045C · Destroyed
- [NTSB NYC68F0233](https://openairdocs.org/ntsb/NYC68F0233.md): Cessna 150 · Totowa, NJ · Accident · No injuries · Closed · Oct 11, 1967 · N6884F · Destroyed
- [NTSB SEA68D0145](https://openairdocs.org/ntsb/SEA68D0145.md): Cessna 150 · Rexburg, ID · Accident · No injuries · Closed · Oct 10, 1967 · N8292F · Substantial damage
- [NTSB DEN68F0119](https://openairdocs.org/ntsb/DEN68F0119.md): Cessna 150G · Aurora, CO · Accident · Minor injuries · Closed · Oct 10, 1967 · N4077J · Substantial damage
- [NTSB OAK68A0034](https://openairdocs.org/ntsb/OAK68A0034.md): Cessna 150G · Las Vegas, NV · Accident · 2 fatal · Closed · Oct 8, 1967 · N3229J · 2 aircraft · Destroyed
- [NTSB MIA68F0286](https://openairdocs.org/ntsb/MIA68F0286.md): Piper PA-28 · Macon, GA · Accident · Serious injuries · Closed · Oct 8, 1967 · N4171J · Substantial damage
- [NTSB OAK68D0268](https://openairdocs.org/ntsb/OAK68D0268.md): Cessna 172G · Susanville, CA · Accident · Minor injuries · Closed · Oct 7, 1967 · N5915R · Destroyed
- [NTSB DEN68F0123](https://openairdocs.org/ntsb/DEN68F0123.md): Cessna 182 · Roosevelt, UT · Accident · Serious injuries · Closed · Oct 7, 1967 · N3978D · Substantial damage
- [NTSB NYC68F0227](https://openairdocs.org/ntsb/NYC68F0227.md): Piper PA-24 · Spring Valley, NY · Accident · No injuries · Closed · Oct 6, 1967 · N8734P · Substantial damage
- [NTSB FTW68F0268](https://openairdocs.org/ntsb/FTW68F0268.md): Schlemeyer 1 · Tomball, TX · Accident · No injuries · Closed · Oct 6, 1967 · N317H · Substantial damage

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

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

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