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

## Cases, newest first

- [NTSB CHI69F0509](https://openairdocs.org/ntsb/CHI69F0509.md): Cessna 170 · Mt.Morris, MI · Accident · No injuries · Closed · Mar 9, 1969 · N4294V · Substantial damage
- [NTSB OAK69D0243](https://openairdocs.org/ntsb/OAK69D0243.md): Mooney M20C · So.Lake Tahoe, CA · Accident · Minor injuries · Closed · Mar 8, 1969 · N5778Q · Substantial damage
- [NTSB MKC69F0354](https://openairdocs.org/ntsb/MKC69F0354-191393.md): Cessna 182 · St.Paul, MN · Accident · Minor injuries · Closed · Mar 7, 1969 · N5424B · Substantial damage
- [NTSB MKC69D0361](https://openairdocs.org/ntsb/MKC69D0361-190850.md): Piper PA-28 · Fort Dodge, IA · Accident · No injuries · Closed · Mar 7, 1969 · N7591R · Substantial damage
- [NTSB NYC69D0358](https://openairdocs.org/ntsb/NYC69D0358.md): Piper PA-28 · Easton, PA · Accident · No injuries · Closed · Mar 6, 1969 · N5779F · Substantial damage
- [NTSB MKC69A0052](https://openairdocs.org/ntsb/MKC69A0052.md): Piper PA-23 · Windom, MN · Accident · Minor injuries · Closed · Mar 6, 1969 · N6470Y · Substantial damage
- [NTSB CHI69F0507](https://openairdocs.org/ntsb/CHI69F0507.md): Cessna 150 · West Chicago, IL · Accident · No injuries · Closed · Mar 4, 1969 · N8982S · Substantial damage
- [NTSB SEA69F0208](https://openairdocs.org/ntsb/SEA69F0208.md): Laister LK-10A · Dallesport, WA · Accident · Serious injuries · Closed · Mar 2, 1969 · N49911 · Destroyed
- [NTSB MIA69D0468](https://openairdocs.org/ntsb/MIA69D0468.md): Schweizer SGU-2- · Sylvania, GA · Accident · Minor injuries · Closed · Mar 2, 1969 · N5832V · Substantial damage
- [NTSB CHI69F0517](https://openairdocs.org/ntsb/CHI69F0517.md): Piper PA-28 · South Bend, IN · Accident · Minor injuries · Closed · Mar 1, 1969 · N3555K · Destroyed
- [NTSB ANC69D0112](https://openairdocs.org/ntsb/ANC69D0112.md): Piper PA-12 · Anchorage, AK · Accident · No injuries · Closed · Mar 1, 1969 · N3861M · Substantial damage
- [NTSB NYC69F0356](https://openairdocs.org/ntsb/NYC69F0356.md): Bell 206A · Lenox Hill, NY · Accident · No injuries · Closed · Feb 28, 1969 · N1426W · Substantial damage
- [NTSB NYC69D0355](https://openairdocs.org/ntsb/NYC69D0355.md): Cessna 150 · Ravena, NY · Accident · No injuries · Closed · Feb 28, 1969 · N2572J · Substantial damage
- [NTSB FTW69D0475](https://openairdocs.org/ntsb/FTW69D0475.md): Piper PA-23 · Burnet, TX · Accident · No injuries · Closed · Feb 28, 1969 · N3273P · Destroyed
- [NTSB CHI69F0534](https://openairdocs.org/ntsb/CHI69F0534.md): Piper PA-28 · Wabash, IN · Accident · No injuries · Closed · Feb 28, 1969 · N5335L · Substantial damage
- [NTSB MIA69F0374](https://openairdocs.org/ntsb/MIA69F0374.md): Piper PA-30 · Key West, FL · Accident · Minor injuries · Closed · Feb 27, 1969 · N7872Y · Destroyed
- [NTSB MKC69F0358](https://openairdocs.org/ntsb/MKC69F0358-191324.md): Piper PA-12 · Cuba, MO · Accident · No injuries · Closed · Feb 26, 1969 · N3140M · Substantial damage
- [NTSB CHI69D0499](https://openairdocs.org/ntsb/CHI69D0499.md): Stinson 108 · Laurel, IN · Accident · Minor injuries · Closed · Feb 26, 1969 · N4147C · Substantial damage
- [NTSB LAX69F0286](https://openairdocs.org/ntsb/LAX69F0286.md): Piper PA-23 · Plaster City, CA · Accident · No injuries · Closed · Feb 25, 1969 · N6323Y · Substantial damage
- [NTSB OAK69F0285](https://openairdocs.org/ntsb/OAK69F0285.md): Cessna 310I · Bishop, CA · Accident · Minor injuries · Closed · Feb 23, 1969 · N8103M · Substantial damage
- [NTSB OAK69O0015](https://openairdocs.org/ntsb/OAK69O0015.md): Cessna 182 · Mulege, Mexico · Accident · Minor injuries · Closed · Feb 22, 1969 · N2383G · Substantial damage
- [NTSB NYC69F0348](https://openairdocs.org/ntsb/NYC69F0348.md): Aero Comdr 100A · Groton, CT · Accident · No injuries · Closed · Feb 22, 1969 · N5555M · Substantial damage
- [NTSB MIA69F0416](https://openairdocs.org/ntsb/MIA69F0416.md): Stinson 108-2 · Russellville, AL · Accident · 1 fatal · Closed · Feb 21, 1969 · N97478 · Destroyed
- [NTSB FTW69F0391](https://openairdocs.org/ntsb/FTW69F0391.md): Beech J35 · Little Rock, AR · Accident · Serious injuries · Closed · Feb 21, 1969 · N7209B · Destroyed
- [NTSB OAK69F0241](https://openairdocs.org/ntsb/OAK69F0241.md): Dehavilland DHC-6 · Chico, CA · Accident · No injuries · Closed · Feb 20, 1969 · N951SM · Substantial damage
- [NTSB MKC69D0363](https://openairdocs.org/ntsb/MKC69D0363-190986.md): Cessna 150 · Sioux Falls, SD · Accident · No injuries · Closed · Feb 19, 1969 · N6402F · Substantial damage
- [NTSB CHI69F0465](https://openairdocs.org/ntsb/CHI69F0465.md): Cessna 150H · Detroit, MI · Accident · No injuries · Closed · Feb 18, 1969 · N6423S · Substantial damage
- [NTSB NYC69D0362](https://openairdocs.org/ntsb/NYC69D0362.md): Beech D35 · Lakewood, NJ · Accident · No injuries · Closed · Feb 17, 1969 · N135Y · Substantial damage
- [NTSB SEA69D0186](https://openairdocs.org/ntsb/SEA69D0186.md): Piper PA-28 · Chester, MT · Accident · No injuries · Closed · Feb 16, 1969 · N5342W · Substantial damage
- [NTSB NYC69F0349](https://openairdocs.org/ntsb/NYC69F0349.md): Stinson 108 · Aliquippa, PA · Accident · Minor injuries · Closed · Feb 16, 1969 · N8539K · Substantial damage
- [NTSB DIA69D0156](https://openairdocs.org/ntsb/DIA69D0156.md): Cessna 150 · Clinton, MD · Accident · No injuries · Closed · Feb 15, 1969 · N51099 · Substantial damage
- [NTSB DIA69D0145](https://openairdocs.org/ntsb/DIA69D0145.md): Piper PA-28 · Roanoke, VA · Accident · No injuries · Closed · Feb 15, 1969 · N4547R · Substantial damage
- [NTSB MIA69D0361](https://openairdocs.org/ntsb/MIA69D0361.md): Cessna 150 · Ft.Lauderdale, FL · Accident · No injuries · Closed · Feb 14, 1969 · N3081X · Substantial damage
- [NTSB FTW69A0056](https://openairdocs.org/ntsb/FTW69A0056.md): Piper PA-30 · El Dorado, AR · Accident · 1 fatal · Closed · Feb 14, 1969 · N7783Y · Destroyed
- [NTSB SEA69F0199](https://openairdocs.org/ntsb/SEA69F0199.md): Cessna 150F · Goshen, OR · Accident · Minor injuries · Closed · Feb 13, 1969 · N8920S · Destroyed
- [NTSB SEA69F0198](https://openairdocs.org/ntsb/SEA69F0198.md): Cessna 150 · Chehalis, WA · Accident · No injuries · Closed · Feb 13, 1969 · N3198J · Substantial damage
- [NTSB FTW69F0380](https://openairdocs.org/ntsb/FTW69F0380.md): Bellanca 17-30 · Plainview, TX · Accident · No injuries · Closed · Feb 12, 1969 · N7329V · Substantial damage
- [NTSB MIA69F0370](https://openairdocs.org/ntsb/MIA69F0370.md): Piper PA-18 · Ft Lauderdale, FL · Accident · Minor injuries · Closed · Feb 11, 1969 · N2898P · Destroyed
- [NTSB DEN70F0002](https://openairdocs.org/ntsb/DEN70F0002.md): Piper PA-23 · Denver, CO · Accident · No injuries · Closed · Feb 10, 1969 · N5293Y · Substantial damage
- [NTSB LAX69D0297](https://openairdocs.org/ntsb/LAX69D0297.md): Bolkow Phoeb · Phoenix, AZ · Accident · No injuries · Closed · Feb 9, 1969 · N1211T · Substantial damage
- [NTSB FTW69F0378](https://openairdocs.org/ntsb/FTW69F0378-201687.md): Beech A23 · Dallas, TX · Accident · Serious injuries · Closed · Feb 8, 1969 · N8792M · Substantial damage
- [NTSB FTW69D0403](https://openairdocs.org/ntsb/FTW69D0403.md): Bean 1 · Taft, TX · Accident · Serious injuries · Closed · Feb 7, 1969 · N7467 · Substantial damage
- [NTSB FTW69D0387](https://openairdocs.org/ntsb/FTW69D0387.md): Cessna 188 · W.Memphis, AR · Accident · No injuries · Closed · Feb 7, 1969 · N3531Q · Substantial damage
- [NTSB OAK69F0219](https://openairdocs.org/ntsb/OAK69F0219.md): Mooney M20F · Lathrop Wells, NV · Accident · Serious injuries · Closed · Feb 6, 1969 · N6470Q · Substantial damage
- [NTSB MKC69F0366](https://openairdocs.org/ntsb/MKC69F0366.md): Cessna 401 · Minneapolis, MN · Accident · No injuries · Closed · Feb 6, 1969 · N4073Q · Substantial damage
- [NTSB FTW69A0053](https://openairdocs.org/ntsb/FTW69A0053.md): Douglas DC-9 · Harlingen, TX · Accident · Serious injuries · Closed · Feb 6, 1969 · N1304T · 2 aircraft · Minor damage
- [NTSB DEN69D0222](https://openairdocs.org/ntsb/DEN69D0222.md): Piper PA-28 · Rangely, CO · Accident · No injuries · Closed · Feb 5, 1969 · N5521F · Substantial damage
- [NTSB CHI69F0580](https://openairdocs.org/ntsb/CHI69F0580.md): Beech G35 · Peoria, IL · Accident · Serious injuries · Closed · Feb 5, 1969 · N4447D · Destroyed
- [NTSB NYC69F0319](https://openairdocs.org/ntsb/NYC69F0319.md): Piper PA-30 · Sussex, NJ · Accident · No injuries · Closed · Feb 4, 1969 · N7617Y · Substantial damage
- [NTSB MKC69D0345](https://openairdocs.org/ntsb/MKC69D0345-201678.md): Cessna 150 · Eden Praire, MN · Accident · No injuries · Closed · Feb 4, 1969 · N22182 · Substantial damage

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

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

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