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

## Cases, newest first

- [NTSB MKC70D0299](https://openairdocs.org/ntsb/MKC70D0299.md): Cessna 150F · Minneapolis, MN · Accident · No injuries · Closed · Dec 16, 1969 · N8868G · Substantial damage
- [NTSB SEA70F0129](https://openairdocs.org/ntsb/SEA70F0129.md): Cessna 150H · Spokane, WA · Accident · Serious injuries · Closed · Dec 15, 1969 · N22640 · Destroyed
- [NTSB SEA70I0024](https://openairdocs.org/ntsb/SEA70I0024.md): Boeing 747 · Renton, WA · Incident · No injuries · Closed · Dec 13, 1969 · N732PA · Minor damage
- [NTSB FTW70F0329](https://openairdocs.org/ntsb/FTW70F0329.md): Cessna 182 · Bay City, TX · Accident · No injuries · Closed · Dec 13, 1969 · N92099 · Substantial damage
- [NTSB ANC70D0085](https://openairdocs.org/ntsb/ANC70D0085.md): Cessna 172 · Fairbanks, AK · Accident · No injuries · Closed · Dec 13, 1969 · N8039X · Substantial damage
- [NTSB MIA70F0306](https://openairdocs.org/ntsb/MIA70F0306.md): Aero Comdr 200-D · Ashburn, GA · Accident · Minor injuries · Closed · Dec 12, 1969 · N2900T · Substantial damage
- [NTSB IAD70D0116](https://openairdocs.org/ntsb/IAD70D0116.md): Piper PA-28 · Clinton, MD · Accident · No injuries · Closed · Dec 11, 1969 · N9879W · Substantial damage
- [NTSB NYC70A0061](https://openairdocs.org/ntsb/NYC70A0061.md): Piper PA-23 · Passadumkeag, ME · Accident · 3 fatal · Closed · Dec 10, 1969 · N5090Y · Destroyed
- [NTSB MIA70A0046](https://openairdocs.org/ntsb/MIA70A0046.md): Beech E18S · Montgomery, AL · Accident · No injuries · Closed · Dec 10, 1969 · N679T · Substantial damage
- [NTSB MIA70A0044](https://openairdocs.org/ntsb/MIA70A0044.md): Cessna 210G · Valdosta, GA · Accident · 2 fatal · Closed · Dec 9, 1969 · N5919F · Destroyed
- [NTSB LAX70A0032](https://openairdocs.org/ntsb/LAX70A0032.md): Taylorcraft BC-12D · Santa Paula, CA · Accident · No injuries · Closed · Dec 9, 1969 · N39983 · 2 aircraft · Substantial damage
- [NTSB CHI70F0363](https://openairdocs.org/ntsb/CHI70F0363.md): Piper J3C-65 · Dowagiac, MI · Accident · No injuries · Closed · Dec 6, 1969 · N92348 · Substantial damage
- [NTSB MIA70A0043](https://openairdocs.org/ntsb/MIA70A0043.md): Cessna 170B · Ft.Lauderdale, FL · Accident · 1 fatal · Closed · Dec 5, 1969 · N3001W · Destroyed
- [NTSB MKC70A0031](https://openairdocs.org/ntsb/MKC70A0031.md): Cessna 172K · Ulysses, KS · Accident · 2 fatal · Closed · Dec 3, 1969 · N78585 · Destroyed
- [NTSB LAX70D0220](https://openairdocs.org/ntsb/LAX70D0220.md): Cessna 172 · Goleta, CA · Accident · Minor injuries · Closed · Dec 3, 1969 · N167AE · Substantial damage
- [NTSB FTW70F0325](https://openairdocs.org/ntsb/FTW70F0325.md): Piper PA-28 · Wilderado, TX · Accident · No injuries · Closed · Dec 2, 1969 · N5777F · Substantial damage
- [NTSB MIA70A0042](https://openairdocs.org/ntsb/MIA70A0042.md): Dehavilland DH114 · Charlotte Amal, VI · Accident · Serious injuries · Closed · Dec 1, 1969 · N570PR · Substantial damage
- [NTSB CHI70D0374](https://openairdocs.org/ntsb/CHI70D0374.md): Cessna 182 · Wheeling, IL · Accident · No injuries · Closed · Nov 30, 1969 · N5867B · Substantial damage
- [NTSB CHI70F0354](https://openairdocs.org/ntsb/CHI70F0354.md): Aeronca 7BCM · Harrison, MI · Accident · Serious injuries · Closed · Nov 28, 1969 · N2563E · Substantial damage
- [NTSB UNK70X0104](https://openairdocs.org/ntsb/UNK70X0104.md): Piper PA-23 · Inagua, Burkina Faso · Accident · 4 fatal · Closed · Nov 27, 1969 · N4408P · Destroyed
- [NTSB MKC70A0030](https://openairdocs.org/ntsb/MKC70A0030.md): Mooney M-20F · St Louis, MO · Accident · 4 fatal · Closed · Nov 27, 1969 · N6493Q · Destroyed
- [NTSB CHI70F0361](https://openairdocs.org/ntsb/CHI70F0361.md): Cessna 177 · Ypsilanti, MI · Accident · Serious injuries · Closed · Nov 27, 1969 · N3100T · Destroyed
- [NTSB NYC70F0247](https://openairdocs.org/ntsb/NYC70F0247.md): Cessna 182K · Lake Katrine, NY · Accident · Serious injuries · Closed · Nov 26, 1969 · N3040Q · Substantial damage
- [NTSB NYC70D0217](https://openairdocs.org/ntsb/NYC70D0217.md): Aeronca 11CC · Westminster, VT · Accident · Serious injuries · Closed · Nov 26, 1969 · N4102E · Substantial damage
- [NTSB FTW70A0036](https://openairdocs.org/ntsb/FTW70A0036.md): Beech 65-A90 · Galveston, TX · Accident · 3 fatal · Closed · Nov 26, 1969 · N500X · Destroyed
- [NTSB MKC70F0269](https://openairdocs.org/ntsb/MKC70F0269.md): Taylorcraft BC12-D · Brandon, SD · Accident · Minor injuries · Closed · Nov 25, 1969 · N43314 · Substantial damage
- [NTSB FTW70F0306](https://openairdocs.org/ntsb/FTW70F0306.md): Piper J-3 · Esterwood, LA · Accident · Serious injuries · Closed · Nov 25, 1969 · N1353M · Substantial damage
- [NTSB LAX70D0212](https://openairdocs.org/ntsb/LAX70D0212.md): Beech C35 · Glendale, AZ · Accident · Minor injuries · Closed · Nov 24, 1969 · N756D · Substantial damage
- [NTSB FTW70F0326](https://openairdocs.org/ntsb/FTW70F0326.md): Cessna 150 · Dallas, TX · Accident · Serious injuries · Closed · Nov 23, 1969 · N4465U · Substantial damage
- [NTSB FTW70A0034](https://openairdocs.org/ntsb/FTW70A0034.md): Cessna 150 · Lake Village, AR · Accident · 1 fatal · Closed · Nov 22, 1969 · N6375S · Destroyed
- [NTSB FTW70F0292](https://openairdocs.org/ntsb/FTW70F0292.md): Cessna 180 · New Orleans, LA · Accident · Minor injuries · Closed · Nov 19, 1969 · N3470Y · Substantial damage
- [NTSB OAK70F0202](https://openairdocs.org/ntsb/OAK70F0202.md): Cessna 310H · S.Francisco, CA · Accident · No injuries · Closed · Nov 18, 1969 · N1053Q · Destroyed
- [NTSB NYC70A0052](https://openairdocs.org/ntsb/NYC70A0052.md): Piper PA-28 · Norwood, MA · Accident · No injuries · Closed · Nov 18, 1969 · N5566F · 2 aircraft · Substantial damage
- [NTSB CHI70F0325](https://openairdocs.org/ntsb/CHI70F0325.md): Aeronca 7AC · Circleville, OH · Accident · No injuries · Closed · Nov 17, 1969 · N85099 · Substantial damage
- [NTSB CHI70A0034](https://openairdocs.org/ntsb/CHI70A0034.md): Cessna 150 · Prairie View, IL · Accident · No injuries · Closed · Nov 16, 1969 · N6009T · 2 aircraft · Minor damage
- [NTSB NYC70F0001](https://openairdocs.org/ntsb/NYC70F0001-149937.md): Mooney M20C · Cortland, NY · Accident · No injuries · Closed · Nov 15, 1969 · N6948N · Substantial damage
- [NTSB MKC70F0281](https://openairdocs.org/ntsb/MKC70F0281.md): Cessna 120 · Riverton, IA · Accident · Serious injuries · Closed · Nov 15, 1969 · N1878N · Destroyed
- [NTSB MIA70I0037](https://openairdocs.org/ntsb/MIA70I0037.md): Boeing 727 · Mccoy Afbase, FL · Incident · No injuries · Closed · Nov 14, 1969 · N4619 · Minor damage
- [NTSB MIA70F0291](https://openairdocs.org/ntsb/MIA70F0291.md): Beech C-45H · Albany, GA · Accident · No injuries · Closed · Nov 14, 1969 · N9818Z · Destroyed
- [NTSB NYC70F0194](https://openairdocs.org/ntsb/NYC70F0194.md): Bellanca 17-30 · Princeton, NJ · Accident · Minor injuries · Closed · Nov 13, 1969 · N7349V · Destroyed
- [NTSB LAX70F0205](https://openairdocs.org/ntsb/LAX70F0205.md): Piper PA-24 · Carlsbad, CA · Accident · Serious injuries · Closed · Nov 13, 1969 · N6213P · Destroyed
- [NTSB CHI70A0033](https://openairdocs.org/ntsb/CHI70A0033.md): Piper PA-28 · Blacklick, OH · Accident · 2 fatal · Closed · Nov 13, 1969 · N12JE · Destroyed
- [NTSB IAD70F0108](https://openairdocs.org/ntsb/IAD70F0108.md): Champion 7ECA · Martinsburg, WV · Accident · Minor injuries · Closed · Nov 11, 1969 · N9503S · Substantial damage
- [NTSB DEN70F0125](https://openairdocs.org/ntsb/DEN70F0125.md): Piper PA-28 · Salt Lake City, UT · Accident · No injuries · Closed · Nov 10, 1969 · N9759J · Substantial damage
- [NTSB ANC70A0040](https://openairdocs.org/ntsb/ANC70A0040.md): Dehavilland DHC-2 · Barrow, AK · Accident · No injuries · Closed · Nov 10, 1969 · N4478 · Substantial damage
- [NTSB MKC70F0263](https://openairdocs.org/ntsb/MKC70F0263.md): Piper PA-28 · Beaumont, KS · Accident · Serious injuries · Closed · Nov 9, 1969 · N5257L · Substantial damage
- [NTSB MIA70F0238](https://openairdocs.org/ntsb/MIA70F0238.md): Cessna 150 · Jonesboro, GA · Accident · Serious injuries · Closed · Nov 9, 1969 · N4157U · Destroyed
- [NTSB IAD70D0105](https://openairdocs.org/ntsb/IAD70D0105.md): Cessna 150 · Clinton, MD · Accident · No injuries · Closed · Nov 8, 1969 · N3833J · Substantial damage
- [NTSB FTW70A0030](https://openairdocs.org/ntsb/FTW70A0030.md): Cessna 182K · Little Rock, AR · Accident · 1 fatal · Closed · Nov 8, 1969 · N2430Q · Destroyed
- [NTSB CHI70F0392](https://openairdocs.org/ntsb/CHI70F0392.md): Piper PA-22 · Gwinn, MI · Accident · No injuries · Closed · Nov 8, 1969 · N1804P · Substantial damage

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

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

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