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

## Cases, newest first

- [NTSB CHI68F0766](https://openairdocs.org/ntsb/CHI68F0766.md): Beech 23 · Elkhart, IN · Accident · No injuries · Closed · May 25, 1968 · N2325L · Substantial damage
- [NTSB DEN68A0053](https://openairdocs.org/ntsb/DEN68A0053.md): Mooney M20C · Littleton, CO · Accident · 4 fatal · Closed · May 24, 1968 · N6706U · Destroyed
- [NTSB MIA68F0528](https://openairdocs.org/ntsb/MIA68F0528.md): Piper PA-28 · Marietta, GA · Accident · No injuries · Closed · May 22, 1968 · N8914W · Substantial damage
- [NTSB LAX69F0010](https://openairdocs.org/ntsb/LAX69F0010.md): Bell 47G3B1 · Springervill, AZ · Accident · Minor injuries · Closed · May 22, 1968 · N73965 · Destroyed
- [NTSB MIA68A0097](https://openairdocs.org/ntsb/MIA68A0097.md): Piper PA-28 · Midland, TX · Accident · 1 fatal · Closed · May 21, 1968 · N7067R · Destroyed
- [NTSB OAK69D0057](https://openairdocs.org/ntsb/OAK69D0057.md): Cessna 210 · Alturas, CA · Accident · Serious injuries · Closed · May 20, 1968 · N4962U · Destroyed
- [NTSB UNK68X0139](https://openairdocs.org/ntsb/UNK68X0139.md): Aeronca 7DC · Lk Otukamamon, Canada · Accident · 1 fatal · Closed · May 18, 1968 · N83416 · Substantial damage
- [NTSB NYC69F0005](https://openairdocs.org/ntsb/NYC69F0005.md): Cessna 182 · Piffard, NY · Accident · Serious injuries · Closed · May 18, 1968 · N8707T · Substantial damage
- [NTSB MKC69D0038](https://openairdocs.org/ntsb/MKC69D0038-201086.md): Cessna 150F · Joplin, MO · Accident · No injuries · Closed · May 18, 1968 · N6417F · Substantial damage
- [NTSB FTW69D0129](https://openairdocs.org/ntsb/FTW69D0129.md): Alon A-2 · San Antonio, TX · Accident · No injuries · Closed · May 18, 1968 · N5664F · Substantial damage
- [NTSB DEN68F0274](https://openairdocs.org/ntsb/DEN68F0274.md): Piper PA-18 · Rifle, CO · Accident · Serious injuries · Closed · May 18, 1968 · N1870P · Substantial damage
- [NTSB FTW68F0588](https://openairdocs.org/ntsb/FTW68F0588.md): Cessna 150 · Lubbock, TX · Accident · No injuries · Closed · May 16, 1968 · N7217S · Substantial damage
- [NTSB OAK69F0008](https://openairdocs.org/ntsb/OAK69F0008.md): Aeronca 7AC · Davis, CA · Accident · No injuries · Closed · May 15, 1968 · N83058 · Substantial damage
- [NTSB OAK69D0058](https://openairdocs.org/ntsb/OAK69D0058.md): Cessna 150 · Lincoln, CA · Accident · No injuries · Closed · May 15, 1968 · N7720F · Substantial damage
- [NTSB MKC68D0551](https://openairdocs.org/ntsb/MKC68D0551.md): Cessna 140 · Arkansas Cty, KS · Accident · No injuries · Closed · May 15, 1968 · N3694V · Substantial damage
- [NTSB CHI68A0095](https://openairdocs.org/ntsb/CHI68A0095.md): Piper PA-23 · Pellston, MI · Accident · 4 fatal · Closed · May 14, 1968 · N4307Y · Destroyed
- [NTSB MIA68A0094](https://openairdocs.org/ntsb/MIA68A0094.md): Piper PA-28 · St Thomas, VI · Accident · Minor injuries · Closed · May 13, 1968 · N5307L · Destroyed
- [NTSB OAK68F0375](https://openairdocs.org/ntsb/OAK68F0375.md): Piper PA-24 · Fresno, CA · Accident · No injuries · Closed · May 11, 1968 · N7369P · Substantial damage
- [NTSB SEA69F0022](https://openairdocs.org/ntsb/SEA69F0022.md): Piper PA-18 · Lowell, OR · Accident · Minor injuries · Closed · May 10, 1968 · N9073D · Substantial damage
- [NTSB MKC68A0066](https://openairdocs.org/ntsb/MKC68A0066.md): Beech H50 · Scott City, MO · Accident · 1 fatal · Closed · May 10, 1968 · N113P · Destroyed
- [NTSB DIA68D0232](https://openairdocs.org/ntsb/DIA68D0232.md): Piper PA-23 · Chantilly, VA · Accident · No injuries · Closed · May 9, 1968 · N3339P · Substantial damage
- [NTSB CHI68F0716](https://openairdocs.org/ntsb/CHI68F0716.md): Piper PA-28 · Westland, MI · Accident · Minor injuries · Closed · May 7, 1968 · N7586R · Substantial damage
- [NTSB OAK68D0388](https://openairdocs.org/ntsb/OAK68D0388.md): Aeronca 7AC · Asti, CA · Accident · No injuries · Closed · May 5, 1968 · N81566 · Substantial damage
- [NTSB OAK68D0363](https://openairdocs.org/ntsb/OAK68D0363.md): Cessna 140 · Palo Alto, CA · Accident · No injuries · Closed · May 5, 1968 · N89057 · Substantial damage
- [NTSB SEA68A0065](https://openairdocs.org/ntsb/SEA68A0065.md): Erco 415-D · Lynnwood, WA · Accident · 2 fatal · Closed · May 4, 1968 · N3909H · Destroyed
- [NTSB LAX68A0098](https://openairdocs.org/ntsb/LAX68A0098.md): Fairchild F-27J · Bruni, TX · Accident · 2 fatal · Closed · May 4, 1968 · N27W · Destroyed
- [NTSB NYC68F0466](https://openairdocs.org/ntsb/NYC68F0466.md): Piper PA-28 · Fairless, PA · Accident · No injuries · Closed · May 3, 1968 · N4286J · Destroyed
- [NTSB MIA68A0091](https://openairdocs.org/ntsb/MIA68A0091.md): Cessna 172H · Belmont, MS · Accident · 2 fatal · Closed · May 2, 1968 · N1789F · Destroyed
- [NTSB CHI68D0730](https://openairdocs.org/ntsb/CHI68D0730.md): Mig.Mustang Oscar · Minooka, IL · Accident · Serious injuries · Closed · May 2, 1968 · N7617 · Substantial damage
- [NTSB SEA68F0300](https://openairdocs.org/ntsb/SEA68F0300.md): Alon A-2 · Billings, MT · Accident · Serious injuries · Closed · Apr 29, 1968 · N6504Q · Substantial damage
- [NTSB OAK69D0013](https://openairdocs.org/ntsb/OAK69D0013.md): Cessna 120 · Angwin, CA · Accident · Minor injuries · Closed · Apr 29, 1968 · N77248 · Destroyed
- [NTSB NYC68F0481](https://openairdocs.org/ntsb/NYC68F0481.md): Ercoupe 415-C · Williamstown, NJ · Accident · 1 fatal · Closed · Apr 28, 1968 · N93331 · Destroyed
- [NTSB NYC68A0117](https://openairdocs.org/ntsb/NYC68A0117.md): Douglas DC-8 · Atlantic City, NJ · Accident · Serious injuries · Closed · Apr 28, 1968 · N1820 · Destroyed
- [NTSB FTW68F0567](https://openairdocs.org/ntsb/FTW68F0567.md): Glasfugel H301 · El Paso, TX · Accident · 1 fatal · Closed · Apr 28, 1968 · N301X · Destroyed
- [NTSB FTW68A0090](https://openairdocs.org/ntsb/FTW68A0090.md): Beech 65 · Beaumont, TX · Accident · 7 fatal · Closed · Apr 28, 1968 · N968Q · Destroyed
- [NTSB OAK69D0003](https://openairdocs.org/ntsb/OAK69D0003.md): Naval Fcty N3N-1 · Willows, CA · Accident · No injuries · Closed · Apr 27, 1968 · N45251 · Substantial damage
- [NTSB NYC68F0469](https://openairdocs.org/ntsb/NYC68F0469.md): Alon A2 · Millville, NJ · Accident · No injuries · Closed · Apr 27, 1968 · N6593Q · Substantial damage
- [NTSB DIA68D0220](https://openairdocs.org/ntsb/DIA68D0220.md): Cessna 182 · Fort Bragg, NC · Accident · No injuries · Closed · Apr 27, 1968 · N5167D · Substantial damage
- [NTSB LAX68F0392](https://openairdocs.org/ntsb/LAX68F0392.md): Dehavnd Can DH 82A · Castaic, CA · Accident · Minor injuries · Closed · Apr 26, 1968 · N542R · Substantial damage
- [NTSB CHI68D0748](https://openairdocs.org/ntsb/CHI68D0748.md): Piper PA-28 · Galion, OH · Accident · No injuries · Closed · Apr 25, 1968 · N3802T · Substantial damage
- [NTSB DEN68A0050](https://openairdocs.org/ntsb/DEN68A0050.md): Bell 47G3B1 · Aspen, CO · Accident · Minor injuries · Closed · Apr 24, 1968 · N7942S · Substantial damage
- [NTSB NYC68F0492](https://openairdocs.org/ntsb/NYC68F0492.md): Cessna 170A · Belle Vernon, PA · Accident · Minor injuries · Closed · Apr 23, 1968 · N9295A · Substantial damage
- [NTSB CHI68D0725](https://openairdocs.org/ntsb/CHI68D0725.md): Piper PA-28 · Lorain, OH · Accident · No injuries · Closed · Apr 23, 1968 · N9965W · Substantial damage
- [NTSB OAK69O0004](https://openairdocs.org/ntsb/OAK69O0004.md): Pilatus PC-6C · Hoi An, VM · Accident · Minor injuries · Closed · Apr 21, 1968 · N394R · Substantial damage
- [NTSB DIA68F0195](https://openairdocs.org/ntsb/DIA68F0195.md): Mooney M20C · Mitchellville, MD · Accident · Minor injuries · Closed · Apr 21, 1968 · N4030N · Substantial damage
- [NTSB CHI69D0021](https://openairdocs.org/ntsb/CHI69D0021.md): Piper PA-28 · Juneau, WI · Accident · Minor injuries · Closed · Apr 21, 1968 · N4283J · Substantial damage
- [NTSB CHI68D0697](https://openairdocs.org/ntsb/CHI68D0697.md): Piper PA-28 · Cropper, KY · Accident · No injuries · Closed · Apr 21, 1968 · N1514J · Substantial damage
- [NTSB SEA69F0009](https://openairdocs.org/ntsb/SEA69F0009.md): Piper PA-22 · Springfield, OR · Accident · Serious injuries · Closed · Apr 19, 1968 · N9302D · Substantial damage
- [NTSB UNK68X0133](https://openairdocs.org/ntsb/UNK68X0133.md): Cessna 411 · Korinthos, Greece · Accident · 2 fatal · Closed · Apr 18, 1968 · N4952T · Destroyed
- [NTSB DIA68D0215](https://openairdocs.org/ntsb/DIA68D0215.md): Piper PA-28 · Manassas, VA · Accident · Minor injuries · Closed · Apr 18, 1968 · N5256L · Substantial damage

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

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

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