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

## Cases, newest first

- [NTSB FTW78DRA36](https://openairdocs.org/ntsb/FTW78DRA36.md): Piper PA-18 · Conroe, TX · Accident · No injuries · Closed · Aug 20, 1978 · N57551 · Substantial damage
- [NTSB CHI78FEC48](https://openairdocs.org/ntsb/CHI78FEC48.md): Aeronca 7AC · Imlay City, MI · Accident · Minor injuries · Closed · Aug 20, 1978 · N85108 · Destroyed
- [NTSB CHI78DEP62](https://openairdocs.org/ntsb/CHI78DEP62.md): Cessna 150 · Milwaukee, WI · Accident · No injuries · Closed · Aug 20, 1978 · N3035V · Substantial damage
- [NTSB OAK78DVA75](https://openairdocs.org/ntsb/OAK78DVA75.md): Mooney M20J · Atwater, CA · Accident · Minor injuries · Closed · Aug 19, 1978 · N201UE · Substantial damage
- [NTSB FTW78FPA35](https://openairdocs.org/ntsb/FTW78FPA35.md): Piper PA-28 · Mc Kinney, TX · Accident · No injuries · Closed · Aug 19, 1978 · N8825J · Substantial damage
- [NTSB FTW78DRG68](https://openairdocs.org/ntsb/FTW78DRG68.md): Cessna T210 · Burnet, TX · Accident · No injuries · Closed · Aug 18, 1978 · N29007 · Substantial damage
- [NTSB CHI78DEP60](https://openairdocs.org/ntsb/CHI78DEP60.md): Cessna 150K · Kenosha, WI · Accident · No injuries · Closed · Aug 18, 1978 · N6490G · Substantial damage
- [NTSB MIA78DKJ76](https://openairdocs.org/ntsb/MIA78DKJ76.md): Piper PA-28 · Panama City, FL · Accident · No injuries · Closed · Aug 17, 1978 · N1265T · Substantial damage
- [NTSB NYC78FGM44](https://openairdocs.org/ntsb/NYC78FGM44.md): Cessna 337 · Cutty, PA · Accident · Serious injuries · Closed · Aug 16, 1978 · N1146M · Substantial damage
- [NTSB FTW78FPD28](https://openairdocs.org/ntsb/FTW78FPD28.md): Piper PA-22 · Ft Worth, TX · Accident · No injuries · Closed · Aug 15, 1978 · N7530D · Substantial damage
- [NTSB SEA79FYM48](https://openairdocs.org/ntsb/SEA79FYM48-202537.md): Hughes 369D · Cascadia, OR · Accident · Serious injuries · Closed · Aug 14, 1978 · N8600F · Destroyed
- [NTSB UNK78X0131](https://openairdocs.org/ntsb/UNK78X0131.md): Piper PA-32 · Congotown, Burkina Faso · Accident · Minor injuries · Closed · Aug 13, 1978 · N3875W · Substantial damage
- [NTSB SEA78DYE35](https://openairdocs.org/ntsb/SEA78DYE35.md): Let-Np-K L-13 · Issaquah, WA · Accident · No injuries · Closed · Aug 13, 1978 · N9244Z · Substantial damage
- [NTSB FTW78FPA33](https://openairdocs.org/ntsb/FTW78FPA33.md): Piper PA-18 · Caddo Mills, TX · Accident · Minor injuries · Closed · Aug 13, 1978 · N9720P · Substantial damage
- [NTSB FTW78FA068](https://openairdocs.org/ntsb/FTW78FA068.md): Swearingen SA226 · Austin, TX · Accident · Serious injuries · Closed · Aug 13, 1978 · N300TL · Destroyed
- [NTSB FTW78DRG70](https://openairdocs.org/ntsb/FTW78DRG70.md): Schweizer SGS-2 · Georgetown, TX · Accident · No injuries · Closed · Aug 13, 1978 · N14501 · Substantial damage
- [NTSB CHI78FA059](https://openairdocs.org/ntsb/CHI78FA059.md): Mooney M20C · Valparaiso, IN · Accident · 2 fatal · Closed · Aug 13, 1978 · N44JH · Destroyed
- [NTSB NYC78DFJ35](https://openairdocs.org/ntsb/NYC78DFJ35.md): Mcdonald II · Mayville, NY · Accident · Minor injuries · Closed · Aug 12, 1978 · N12825 · Substantial damage
- [NTSB DEN78FTE86](https://openairdocs.org/ntsb/DEN78FTE86.md): Beech B60 · Alamosa, CO · Accident · No injuries · Closed · Aug 12, 1978 · N4315W · Substantial damage
- [NTSB DEN78FQA49](https://openairdocs.org/ntsb/DEN78FQA49.md): Cessna 206 · Roswell, NM · Accident · No injuries · Closed · Aug 12, 1978 · N9468G · Substantial damage
- [NTSB OAK78DA042](https://openairdocs.org/ntsb/OAK78DA042.md): Piper PA-31 · Kneeland, CA · Accident · No injuries · Closed · Aug 11, 1978 · N61402 · Substantial damage
- [NTSB LAX78FVM39](https://openairdocs.org/ntsb/LAX78FVM39.md): M Larson 1 · Sn Luis Obspo, CA · Accident · Serious injuries · Closed · Aug 11, 1978 · N5500K · Destroyed
- [NTSB MIA78FKT68](https://openairdocs.org/ntsb/MIA78FKT68.md): Cessna 150 · Pahokee, FL · Accident · Serious injuries · Closed · Aug 10, 1978 · N3932V · Destroyed
- [NTSB MIA78DA112](https://openairdocs.org/ntsb/MIA78DA112.md): Schemp Nimbus · Mt Groghan, SC · Accident · 1 fatal · Closed · Aug 9, 1978 · N2WH · Destroyed
- [NTSB CHI78FEC46](https://openairdocs.org/ntsb/CHI78FEC46.md): Cessna 150M · Westland, MI · Accident · Minor injuries · Closed · Aug 9, 1978 · N704HH · Substantial damage
- [NTSB SEA78FA052](https://openairdocs.org/ntsb/SEA78FA052.md): Bell 47G3B1 · Snoqualmie Fls, WA · Accident · No injuries · Closed · Aug 7, 1978 · N1182W · Destroyed
- [NTSB NYC78FA076](https://openairdocs.org/ntsb/NYC78FA076.md): Piper PA-31 · East Hampton, NY · Accident · Minor injuries · Closed · Aug 7, 1978 · N9093Y · Substantial damage
- [NTSB MKC78FCQ36](https://openairdocs.org/ntsb/MKC78FCQ36.md): Vari-Eze · Liberal, KS · Accident · 1 fatal · Closed · Aug 7, 1978 · N36EZ · Destroyed
- [NTSB MIA78FKG70](https://openairdocs.org/ntsb/MIA78FKG70.md): Cessna 150 · Savannah, GA · Accident · No injuries · Closed · Aug 7, 1978 · N5699E · Substantial damage
- [NTSB LAX78FA064](https://openairdocs.org/ntsb/LAX78FA064.md): Hughes 269C · Phoenix, AZ · Accident · 2 fatal · Closed · Aug 7, 1978 · N7477F · Destroyed
- [NTSB LAX78FUQ41](https://openairdocs.org/ntsb/LAX78FUQ41.md): Cessna 150A · Pacoima, CA · Accident · Serious injuries · Closed · Aug 6, 1978 · N7102X · Destroyed
- [NTSB DEN78FTE82](https://openairdocs.org/ntsb/DEN78FTE82.md): Cessna 172 · Aurora, CO · Accident · No injuries · Closed · Aug 6, 1978 · N577DB · Substantial damage
- [NTSB CHI78FEV48](https://openairdocs.org/ntsb/CHI78FEV48.md): Cessna U206F · Yates City, IL · Accident · Minor injuries · Closed · Aug 6, 1978 · N50625 · Substantial damage
- [NTSB CHI78FA052](https://openairdocs.org/ntsb/CHI78FA052.md): Piper PA-22 · East Moline, IL · Accident · 2 fatal · Closed · Aug 6, 1978 · N3217B · 2 aircraft · Destroyed
- [NTSB SEA78FYM47](https://openairdocs.org/ntsb/SEA78FYM47.md): Cessna 180H · Enterprise, OR · Accident · Serious injuries · Closed · Aug 5, 1978 · N3475Y · Substantial damage
- [NTSB MKC78DCG58](https://openairdocs.org/ntsb/MKC78DCG58.md): Schweizer 1-34 · Grain Valley, MO · Accident · Minor injuries · Closed · Aug 5, 1978 · N7646 · Substantial damage
- [NTSB MKC78DER83](https://openairdocs.org/ntsb/MKC78DER83.md): Cessna 180B · Eveleth, MN · Accident · No injuries · Closed · Aug 4, 1978 · N5273E · Substantial damage
- [NTSB FTW78FPJ35](https://openairdocs.org/ntsb/FTW78FPJ35.md): Cessna 150 · Lawton, OK · Accident · Serious injuries · Closed · Aug 3, 1978 · N3955U · Destroyed
- [NTSB DEN78FTE83](https://openairdocs.org/ntsb/DEN78FTE83.md): Cessna 401A · Aspen, CO · Accident · Serious injuries · Closed · Aug 3, 1978 · N555SH · Destroyed
- [NTSB MKC78FA058](https://openairdocs.org/ntsb/MKC78FA058.md): Cessna 120 · Kimball, NE · Accident · 1 fatal · Closed · Aug 2, 1978 · N16DF · Destroyed
- [NTSB IAD78FA088](https://openairdocs.org/ntsb/IAD78FA088.md): Piper PA-34 · Chesterfield, VA · Accident · 3 fatal · Closed · Aug 2, 1978 · N56122 · Destroyed
- [NTSB NYC79FA075](https://openairdocs.org/ntsb/NYC79FA075.md): Cessna 310P · Sussex, NJ · Accident · 1 fatal · Closed · Jul 31, 1978 · N5808M · Destroyed
- [NTSB MKC78FCA47](https://openairdocs.org/ntsb/MKC78FCA47-202549.md): Cessna 172N · Pevely, MO · Accident · Minor injuries · Closed · Jul 31, 1978 · N734MH · Substantial damage
- [NTSB LAX78IA065](https://openairdocs.org/ntsb/LAX78IA065.md): Mooney M20J · Tucson, AZ · Incident · No injuries · Closed · Jul 31, 1978 · N201KY · 2 aircraft · No damage
- [NTSB OAK78FVD50](https://openairdocs.org/ntsb/OAK78FVD50.md): Cessna 140A · Concord, CA · Accident · No injuries · Closed · Jul 30, 1978 · N9428A · Substantial damage
- [NTSB NYC78DHA31](https://openairdocs.org/ntsb/NYC78DHA31.md): Schweizer 233 · Hilltown, PA · Accident · Minor injuries · Closed · Jul 30, 1978 · N2467W · Substantial damage
- [NTSB LAX78FUQ39](https://openairdocs.org/ntsb/LAX78FUQ39.md): Pitts S-1S · Santa Paula, CA · Accident · No injuries · Closed · Jul 30, 1978 · N100Q · 2 aircraft · Substantial damage
- [NTSB CHI78FEX28](https://openairdocs.org/ntsb/CHI78FEX28.md): Piper PA-28 · Mitchell, IN · Accident · 2 fatal · Closed · Jul 30, 1978 · N7638W · Destroyed
- [NTSB CHI78FEP52](https://openairdocs.org/ntsb/CHI78FEP52.md): Thorp T-18 · Oshkosh, WI · Accident · 2 fatal · Closed · Jul 30, 1978 · N18FK · Destroyed
- [NTSB NYC78FNC42](https://openairdocs.org/ntsb/NYC78FNC42.md): Cessna 182D · Hollis, NH · Accident · Minor injuries · Closed · Jul 29, 1978 · N8810X · Substantial damage

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

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

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