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

## Cases, newest first

- [NTSB UNK69X0104](https://openairdocs.org/ntsb/UNK69X0104.md): Brittnorman BN-2A · Narssaruaq, Greenland · Accident · No injuries · Closed · Jan 3, 1969 · N587JA · Substantial damage
- [NTSB MIA69A0036](https://openairdocs.org/ntsb/MIA69A0036.md): Hawker-Sdly 125-3A · St.Petersburg, FL · Accident · No injuries · Closed · Jan 3, 1969 · CF-KCI · Substantial damage
- [NTSB MKC69F0306](https://openairdocs.org/ntsb/MKC69F0306.md): Cessna 172E · Wamego, KS · Accident · Serious injuries · Closed · Jan 2, 1969 · N3788S · Substantial damage
- [NTSB FTW69F0349](https://openairdocs.org/ntsb/FTW69F0349.md): Piper PA-32 · Friona, TX · Accident · No injuries · Closed · Dec 30, 1968 · N3453W · Substantial damage
- [NTSB MKC69D0333](https://openairdocs.org/ntsb/MKC69D0333.md): Cessna 150 · Eden Prairie, MN · Accident · No injuries · Closed · Dec 29, 1968 · N6825F · Substantial damage
- [NTSB OAK69F0202](https://openairdocs.org/ntsb/OAK69F0202.md): Cessna 182F · Fresno, CA · Accident · No injuries · Closed · Dec 27, 1968 · N3222U · Substantial damage
- [NTSB DCA69A0010](https://openairdocs.org/ntsb/DCA69A0010.md): Convair 580 · Chicago, IL · Accident · 27 fatal · Closed · Dec 27, 1968 · N2045 · Destroyed
- [NTSB MKC69F0326](https://openairdocs.org/ntsb/MKC69F0326.md): Piper PA-23 · Creston, IA · Accident · No injuries · Closed · Dec 26, 1968 · N3341P · Substantial damage
- [NTSB FTW69I0042](https://openairdocs.org/ntsb/FTW69I0042.md): Douglas DC-9 · Austin, TX · Incident · No injuries · Closed · Dec 26, 1968 · N1304T · Minor damage
- [NTSB DCA69A0007](https://openairdocs.org/ntsb/DCA69A0007.md): Convair 580 · Bradford, PA · Accident · 20 fatal · Closed · Dec 24, 1968 · N5802 · Destroyed
- [NTSB ANC69A0034](https://openairdocs.org/ntsb/ANC69A0034.md): Lockheed L-100 · Brit Put, AK · Accident · 2 fatal · Closed · Dec 24, 1968 · N760AL · Destroyed
- [NTSB NYC69I0066](https://openairdocs.org/ntsb/NYC69I0066.md): Douglas DC-8 · Newark, NJ · Incident · No injuries · Closed · Dec 23, 1968 · N8779 · Minor damage
- [NTSB FTW69D0342](https://openairdocs.org/ntsb/FTW69D0342.md): Beech A23 · Spearsville, LA · Accident · No injuries · Closed · Dec 22, 1968 · N2396L · Substantial damage
- [NTSB MKC69D0348](https://openairdocs.org/ntsb/MKC69D0348.md): Taylorcraft BC-12D · Shevlin, MN · Accident · No injuries · Closed · Dec 21, 1968 · N43612 · Substantial damage
- [NTSB DIA69F0132](https://openairdocs.org/ntsb/DIA69F0132.md): Cessna 177 · Waynesboro, VA · Accident · Serious injuries · Closed · Dec 20, 1968 · N3165T · Substantial damage
- [NTSB NYC69F0308](https://openairdocs.org/ntsb/NYC69F0308.md): Piper PA-28 · Mckean, PA · Accident · Serious injuries · Closed · Dec 19, 1968 · N833F · Substantial damage
- [NTSB MIA69F0316](https://openairdocs.org/ntsb/MIA69F0316.md): Cessna 172 · Heflin, AL · Accident · Serious injuries · Closed · Dec 19, 1968 · N46271 · Substantial damage
- [NTSB SEA69A0037](https://openairdocs.org/ntsb/SEA69A0037.md): Cessna TU206A · Troutdale, OR · Accident · 1 fatal · Closed · Dec 18, 1968 · N29145 · Destroyed
- [NTSB CHI69I0063](https://openairdocs.org/ntsb/CHI69I0063.md): Beech C-45H · Youngstown, OH · Incident · No injuries · Closed · Dec 18, 1968 · N431P · Minor damage
- [NTSB ANC69A0033](https://openairdocs.org/ntsb/ANC69A0033.md): Beech G18S · Kenai, AK · Accident · Serious injuries · Closed · Dec 18, 1968 · N5730U · Destroyed
- [NTSB MIA69F0311](https://openairdocs.org/ntsb/MIA69F0311.md): Piper PA-28 · Mayaguez, PR · Accident · Minor injuries · Closed · Dec 17, 1968 · N3471K · Substantial damage
- [NTSB LAX69D0253](https://openairdocs.org/ntsb/LAX69D0253.md): Bell 47G3B1 · Grand Canyon, AZ · Accident · No injuries · Closed · Dec 16, 1968 · N1321X · Substantial damage
- [NTSB LAX69D0204](https://openairdocs.org/ntsb/LAX69D0204.md): Piper PA-28R · Chula Vista, CA · Accident · Minor injuries · Closed · Dec 16, 1968 · N4614J · Substantial damage
- [NTSB FTW69F0327](https://openairdocs.org/ntsb/FTW69F0327.md): Cessna 182 · Linden, TX · Accident · Minor injuries · Closed · Dec 15, 1968 · N5123D · Substantial damage
- [NTSB MIA69D0334](https://openairdocs.org/ntsb/MIA69D0334.md): Piper PA-28 · Charleston, SC · Accident · Minor injuries · Closed · Dec 13, 1968 · N5186L · Substantial damage
- [NTSB CHI69F0429](https://openairdocs.org/ntsb/CHI69F0429.md): Beech A65 · Chicago, IL · Accident · No injuries · Closed · Dec 13, 1968 · N941V · Substantial damage
- [NTSB ANC69D0097](https://openairdocs.org/ntsb/ANC69D0097.md): Cessna 180 · Arctic Villg, AK · Accident · No injuries · Closed · Dec 13, 1968 · N9191C · Substantial damage
- [NTSB NYC69F0292](https://openairdocs.org/ntsb/NYC69F0292.md): Navion A · Farmingdale, NY · Accident · Serious injuries · Closed · Dec 12, 1968 · N4184K · Destroyed
- [NTSB LAX69D0249](https://openairdocs.org/ntsb/LAX69D0249.md): Piper PA-28 · Phoenix, AZ · Accident · No injuries · Closed · Dec 12, 1968 · N67025 · Substantial damage
- [NTSB DCA69R0002](https://openairdocs.org/ntsb/DCA69R0002.md): Boeing 707 · Caracas, Venezuela · Accident · 51 fatal · Closed · Dec 12, 1968 · N494PA · Destroyed
- [NTSB CHI69F0387](https://openairdocs.org/ntsb/CHI69F0387.md): Cessna U206 · Lint, MI · Accident · No injuries · Closed · Dec 11, 1968 · N3935G · Substantial damage
- [NTSB CHI69A0059](https://openairdocs.org/ntsb/CHI69A0059.md): Beech 23 · Marion, OH · Accident · 1 fatal · Closed · Dec 10, 1968 · N2314Q · Destroyed
- [NTSB MKC69F0289](https://openairdocs.org/ntsb/MKC69F0289.md): Piper PA-28 · Spearfish, SD · Accident · Minor injuries · Closed · Dec 9, 1968 · N7164W · Substantial damage
- [NTSB LAX69A0031](https://openairdocs.org/ntsb/LAX69A0031.md): Cessna 150B · Santa Paula, CA · Accident · 5 fatal · Closed · Dec 8, 1968 · N1192Y · 2 aircraft · Destroyed
- [NTSB CHI69D0525](https://openairdocs.org/ntsb/CHI69D0525.md): Cessna 310D · Vienna, OH · Accident · No injuries · Closed · Dec 8, 1968 · N3056D · Destroyed
- [NTSB SEA69F0173](https://openairdocs.org/ntsb/SEA69F0173.md): Beech D18S · Seattle, WA · Accident · Minor injuries · Closed · Dec 5, 1968 · CF-RQL · Destroyed
- [NTSB MIA69A0030](https://openairdocs.org/ntsb/MIA69A0030.md): Cessna 172 · Stone Mountain, GA · Accident · 1 fatal · Closed · Dec 5, 1968 · N7039T · Destroyed
- [NTSB ANC69D0100](https://openairdocs.org/ntsb/ANC69D0100.md): Dehavilland DHC-2 · Fairbanks, AK · Accident · No injuries · Closed · Dec 5, 1968 · N1805R · Substantial damage
- [NTSB FTW69F0315](https://openairdocs.org/ntsb/FTW69F0315.md): Piper PA-24 · Lubbock, TX · Accident · No injuries · Closed · Dec 4, 1968 · N8092P · Substantial damage
- [NTSB MIA69D0284](https://openairdocs.org/ntsb/MIA69D0284.md): Stinson 108 · Fort Myers, FL · Accident · Minor injuries · Closed · Dec 2, 1968 · N8923K · Substantial damage
- [NTSB MIA69F0338](https://openairdocs.org/ntsb/MIA69F0338.md): Cessna 150 · Cristobal, St. Pierre & Miquelon · Accident · Minor injuries · Closed · Dec 1, 1968 · N8717G · Substantial damage
- [NTSB FTW69D0297](https://openairdocs.org/ntsb/FTW69D0297.md): Cessna 182 · Hope, AR · Accident · No injuries · Closed · Nov 30, 1968 · N2621R · Substantial damage
- [NTSB CHI69D0382](https://openairdocs.org/ntsb/CHI69D0382.md): Cessna 172 · Ramsey, IN · Accident · Minor injuries · Closed · Nov 30, 1968 · N5624R · Substantial damage
- [NTSB NYC69D0275](https://openairdocs.org/ntsb/NYC69D0275.md): Piper PA-28 · Chester, CT · Accident · Minor injuries · Closed · Nov 28, 1968 · N8891W · Substantial damage
- [NTSB MIA69A0028](https://openairdocs.org/ntsb/MIA69A0028.md): Stinson 108-3 · Ft.Lauderdale, FL · Accident · 2 fatal · Closed · Nov 28, 1968 · N4174C · Destroyed
- [NTSB ANC69D0095](https://openairdocs.org/ntsb/ANC69D0095.md): Piper PA-22 · Kodiak, AK · Accident · Minor injuries · Closed · Nov 28, 1968 · N5205Z · Substantial damage
- [NTSB OAK69D0205](https://openairdocs.org/ntsb/OAK69D0205.md): Piper PA-28 · S Lake Tahoe, CA · Accident · No injuries · Closed · Nov 27, 1968 · N4337J · Substantial damage
- [NTSB MIA69F0301](https://openairdocs.org/ntsb/MIA69F0301.md): Taylorcraft BL · Fairburn, GA · Accident · Minor injuries · Closed · Nov 27, 1968 · N22608 · Substantial damage
- [NTSB CHI69F0380](https://openairdocs.org/ntsb/CHI69F0380.md): Aero Comdr 500-A · Paducah, KY · Accident · Minor injuries · Closed · Nov 27, 1968 · N9381R · Destroyed
- [NTSB OAK69D0192](https://openairdocs.org/ntsb/OAK69D0192.md): Beech T-34A · Eureka, CA · Accident · No injuries · Closed · Nov 25, 1968 · N5240V · Substantial damage

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

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

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