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

## Cases, newest first

- [NTSB SEA70D0142](https://openairdocs.org/ntsb/SEA70D0142.md): Ercoupe 415C · Hillsboro, OR · Accident · No injuries · Closed · Nov 7, 1969 · N2243H · Substantial damage
- [NTSB CHI70D0365](https://openairdocs.org/ntsb/CHI70D0365.md): Cessna 150G · Logansport, IN · Accident · No injuries · Closed · Nov 7, 1969 · N3879J · Substantial damage
- [NTSB MKC70D0249](https://openairdocs.org/ntsb/MKC70D0249.md): Cessna 182 · Edgely, ND · Accident · Minor injuries · Closed · Nov 6, 1969 · N1913X · Substantial damage
- [NTSB NYC70F0205](https://openairdocs.org/ntsb/NYC70F0205.md): Mooney M-22 · Albany, NY · Accident · No injuries · Closed · Nov 5, 1969 · N7708M · Substantial damage
- [NTSB FTW70F0284](https://openairdocs.org/ntsb/FTW70F0284.md): Mooney M20C · Addison, TX · Accident · No injuries · Closed · Nov 5, 1969 · N7810V · Substantial damage
- [NTSB DEN70A0032](https://openairdocs.org/ntsb/DEN70A0032.md): Cessna 150D · Denver, CO · Accident · 2 fatal · Closed · Nov 4, 1969 · N6068T · 2 aircraft · Destroyed
- [NTSB LAX70D0191](https://openairdocs.org/ntsb/LAX70D0191.md): Globe GC-1A · Casa Grande, AZ · Accident · No injuries · Closed · Nov 3, 1969 · N80720 · Substantial damage
- [NTSB DEN70F0113](https://openairdocs.org/ntsb/DEN70F0113.md): Cessna 210 · Santa Fe, NM · Accident · Minor injuries · Closed · Nov 2, 1969 · N9690T · Destroyed
- [NTSB CHI70F0321](https://openairdocs.org/ntsb/CHI70F0321.md): Amer Avco AA-1 · Birmingham, MI · Accident · No injuries · Closed · Nov 2, 1969 · N224Y · Substantial damage
- [NTSB MIA70F0297](https://openairdocs.org/ntsb/MIA70F0297.md): Beech V35 · Chamblee, GA · Accident · No injuries · Closed · Oct 31, 1969 · N5622S · Substantial damage
- [NTSB ANC70A0038](https://openairdocs.org/ntsb/ANC70A0038.md): Beech TC-45J · Barrow, AK · Accident · Minor injuries · Closed · Oct 31, 1969 · N437PA · Destroyed
- [NTSB LAX70I0024](https://openairdocs.org/ntsb/LAX70I0024.md): Dehavilland DHC-6 · Santa Ana, CA · Incident · Minor injuries · Closed · Oct 30, 1969 · N953SM · Minor damage
- [NTSB LAX70F0187](https://openairdocs.org/ntsb/LAX70F0187.md): Cessna 310B · Santa Ana, CA · Accident · Serious injuries · Closed · Oct 30, 1969 · N5489A · Destroyed
- [NTSB CHI70D0316](https://openairdocs.org/ntsb/CHI70D0316.md): Piper PA-22 · Rochelle, IL · Accident · No injuries · Closed · Oct 29, 1969 · N3054Z · Substantial damage
- [NTSB ANC70I0037](https://openairdocs.org/ntsb/ANC70I0037.md): Beech 95 · Anchorage, AK · Incident · No injuries · Closed · Oct 28, 1969 · N2728Y · Minor damage
- [NTSB FTW70F0260](https://openairdocs.org/ntsb/FTW70F0260.md): Beech B90 · San Antonio, TX · Accident · No injuries · Closed · Oct 27, 1969 · N861K · Substantial damage
- [NTSB OAK70A0029](https://openairdocs.org/ntsb/OAK70A0029.md): Cessna 150 · Sacramento, CA · Accident · Serious injuries · Closed · Oct 26, 1969 · N60244 · 2 aircraft · Destroyed
- [NTSB MKC70D0242](https://openairdocs.org/ntsb/MKC70D0242.md): Cessna 150J · Waterloo, IA · Accident · No injuries · Closed · Oct 26, 1969 · N50473 · Substantial damage
- [NTSB LAX70D0164](https://openairdocs.org/ntsb/LAX70D0164.md): Cessna 172 · Lucerne, CA · Accident · No injuries · Closed · Oct 26, 1969 · N78095 · Substantial damage
- [NTSB NYC70I0045](https://openairdocs.org/ntsb/NYC70I0045.md): Beech E18S · Philadelphia, PA · Incident · No injuries · Closed · Oct 20, 1969 · N340V · Minor damage
- [NTSB FTW70F0272](https://openairdocs.org/ntsb/FTW70F0272.md): Aero Comdr 680FP · Okmulgee, OK · Accident · No injuries · Closed · Oct 20, 1969 · N4262 · Substantial damage
- [NTSB LAX70D0177](https://openairdocs.org/ntsb/LAX70D0177.md): Cessna A188 · Guadalupe, AZ · Accident · No injuries · Closed · Oct 19, 1969 · N3525Q · Substantial damage
- [NTSB IAD70D0090](https://openairdocs.org/ntsb/IAD70D0090.md): Piper PA-22 · Andrews Afb, MD · Accident · Minor injuries · Closed · Oct 19, 1969 · N7026D · Substantial damage
- [NTSB CHI70F0337](https://openairdocs.org/ntsb/CHI70F0337.md): Piper PA-28 · Nappanee, IN · Accident · No injuries · Closed · Oct 19, 1969 · N7397J · Substantial damage
- [NTSB NYC70D0201](https://openairdocs.org/ntsb/NYC70D0201.md): Schweizer S2-33A · Bayport, NY · Accident · No injuries · Closed · Oct 18, 1969 · N5798S · Substantial damage
- [NTSB DEN70A0026](https://openairdocs.org/ntsb/DEN70A0026.md): Cessna 180 · Center, CO · Accident · 1 fatal · Closed · Oct 17, 1969 · N2808D · Destroyed
- [NTSB OAK70D0144](https://openairdocs.org/ntsb/OAK70D0144.md): Cessna 177 · Honolulu, HI · Accident · No injuries · Closed · Oct 16, 1969 · N30283 · Substantial damage
- [NTSB MIA70D0275](https://openairdocs.org/ntsb/MIA70D0275.md): Cessna 120 · Savannah, GA · Accident · No injuries · Closed · Oct 16, 1969 · N1600V · Substantial damage
- [NTSB FTW70F0258](https://openairdocs.org/ntsb/FTW70F0258.md): Beech S35 · Pine Bluff, AR · Accident · No injuries · Closed · Oct 16, 1969 · N5620K · Substantial damage
- [NTSB FTW70D0273](https://openairdocs.org/ntsb/FTW70D0273.md): Mooney M20E · San Angelo, TX · Accident · No injuries · Closed · Oct 16, 1969 · N7139U · Substantial damage
- [NTSB FTW70D0267](https://openairdocs.org/ntsb/FTW70D0267.md): Cessna 150 · Lubbock, TX · Accident · Minor injuries · Closed · Oct 14, 1969 · N7167S · Substantial damage
- [NTSB NYC70D0198](https://openairdocs.org/ntsb/NYC70D0198.md): Piper PA-22 · Erie, PA · Accident · No injuries · Closed · Oct 13, 1969 · N5841Z · Substantial damage
- [NTSB NYC70A0043](https://openairdocs.org/ntsb/NYC70A0043.md): Piper PA-28 · So.Weymouth, MA · Accident · 1 fatal · Closed · Oct 13, 1969 · N6423W · Destroyed
- [NTSB NYC70F0189](https://openairdocs.org/ntsb/NYC70F0189.md): Piper PA-28 · Teterboro, NJ · Accident · Minor injuries · Closed · Oct 12, 1969 · N95127 · Destroyed
- [NTSB NYC70F0177](https://openairdocs.org/ntsb/NYC70F0177.md): Midget II 1-A · Langhorne, PA · Accident · No injuries · Closed · Oct 12, 1969 · N7191 · Substantial damage
- [NTSB MKC70A0018](https://openairdocs.org/ntsb/MKC70A0018.md): Beech E18S · Ashland, WI · Accident · No injuries · Closed · Oct 12, 1969 · N3785B · Substantial damage
- [NTSB LAX70F0183](https://openairdocs.org/ntsb/LAX70F0183.md): Cessna 310N · Van Nuys, CA · Accident · Minor injuries · Closed · Oct 12, 1969 · N5066Q · Destroyed
- [NTSB LAX70D0182](https://openairdocs.org/ntsb/LAX70D0182.md): Sailplane GT-2 · Elsinore, CA · Accident · Minor injuries · Closed · Oct 12, 1969 · N94282 · Substantial damage
- [NTSB CHI70F0295](https://openairdocs.org/ntsb/CHI70F0295.md): Erco 415C · Germantown, OH · Accident · Serious injuries · Closed · Oct 12, 1969 · N99522 · Substantial damage
- [NTSB MKC70F0251](https://openairdocs.org/ntsb/MKC70F0251.md): Piper PA-28R · Washington, MO · Accident · No injuries · Closed · Oct 11, 1969 · N3174R · Substantial damage
- [NTSB IAD70F0081](https://openairdocs.org/ntsb/IAD70F0081.md): Mooney M20C · Fletcher, NC · Accident · No injuries · Closed · Oct 11, 1969 · N6010Q · Substantial damage
- [NTSB FTW70F0251](https://openairdocs.org/ntsb/FTW70F0251.md): Cessna 172H · Fort Worth, TX · Accident · Serious injuries · Closed · Oct 10, 1969 · N2879L · Substantial damage
- [NTSB DEN70A0025](https://openairdocs.org/ntsb/DEN70A0025.md): Beech V35 · St George, UT · Accident · 4 fatal · Closed · Oct 10, 1969 · N424V · Destroyed
- [NTSB IAD70F0097](https://openairdocs.org/ntsb/IAD70F0097.md): Piper PA-28 · Fredericksburg, VA · Accident · No injuries · Closed · Oct 9, 1969 · N1872J · Substantial damage
- [NTSB MIA70F0177](https://openairdocs.org/ntsb/MIA70F0177.md): Piper J3C-65 · Arcadia, FL · Accident · No injuries · Closed · Oct 7, 1969 · N98083 · Substantial damage
- [NTSB FTW70F0249](https://openairdocs.org/ntsb/FTW70F0249.md): Bell 206A · Morgan City, LA · Accident · No injuries · Closed · Oct 7, 1969 · N292FW · Substantial damage
- [NTSB MIA70D0198](https://openairdocs.org/ntsb/MIA70D0198.md): Piper PA-28 · Birmingham, AL · Accident · No injuries · Closed · Oct 5, 1969 · N5977W · Substantial damage
- [NTSB LAX70A0021](https://openairdocs.org/ntsb/LAX70A0021.md): Piper PA-18A · Tehachapi, CA · Accident · 1 fatal · Closed · Oct 5, 1969 · N2877P · Destroyed
- [NTSB CHI70F0276](https://openairdocs.org/ntsb/CHI70F0276.md): Cessna 150 · River Falls, WI · Accident · No injuries · Closed · Oct 5, 1969 · N7993E · Substantial damage
- [NTSB MIA70D0207](https://openairdocs.org/ntsb/MIA70D0207.md): Cessna 150H · Pensacola, FL · Accident · No injuries · Closed · Oct 4, 1969 · N22139 · Substantial damage

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

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

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