# NTSB investigations: Enroute

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 432 of 718 · 35,889 cases

## Cases, newest first

- [NTSB FTW79DQG58](https://openairdocs.org/ntsb/FTW79DQG58.md): Piper PA-24 · Wall, TX · Accident · No injuries · Closed · Aug 28, 1979 · N6598P · Substantial damage
- [NTSB SEA79FA052](https://openairdocs.org/ntsb/SEA79FA052.md): Piper PA-32 · Maple Falls, WA · Accident · 5 fatal · Closed · Aug 27, 1979 · CG-IMB · Destroyed
- [NTSB MIA79FA118](https://openairdocs.org/ntsb/MIA79FA118.md): Piper PA-24 · Melbourne, FL · Accident · 2 fatal · Closed · Aug 27, 1979 · N5762P · Destroyed
- [NTSB LAX79DUG54](https://openairdocs.org/ntsb/LAX79DUG54.md): Piper PA-38 · 29 Palms, CA · Accident · No injuries · Closed · Aug 27, 1979 · N2444K · Substantial damage
- [NTSB CHI79DEG24](https://openairdocs.org/ntsb/CHI79DEG24.md): Cessna 152 · Camden, OH · Accident · No injuries · Closed · Aug 27, 1979 · N46758 · Substantial damage
- [NTSB LAX79FA070](https://openairdocs.org/ntsb/LAX79FA070.md): Cessna 152 · San Marcos, CA · Accident · 2 fatal · Closed · Aug 26, 1979 · N48740 · Destroyed
- [NTSB LAX79DVG73](https://openairdocs.org/ntsb/LAX79DVG73.md): Piper PA-28R · Redding, CA · Accident · Minor injuries · Closed · Aug 26, 1979 · N9492C · Destroyed
- [NTSB FTW79FPA27](https://openairdocs.org/ntsb/FTW79FPA27.md): Cessna 150F · Rowlett, TX · Accident · No injuries · Closed · Aug 26, 1979 · N8881S · Substantial damage
- [NTSB SEA79FYK24](https://openairdocs.org/ntsb/SEA79FYK24.md): Cessna A185F · Eugene, OR · Accident · No injuries · Closed · Aug 25, 1979 · N93086 · Substantial damage
- [NTSB IAD79FIJ13](https://openairdocs.org/ntsb/IAD79FIJ13.md): Cessna 175 · Parkersburg, WV · Accident · Minor injuries · Closed · Aug 25, 1979 · N6975E · Substantial damage
- [NTSB FTW79FQG57](https://openairdocs.org/ntsb/FTW79FQG57.md): Davis DA-5A · Midland, TX · Accident · Minor injuries · Closed · Aug 25, 1979 · N7022T · Destroyed
- [NTSB SEA79FA050](https://openairdocs.org/ntsb/SEA79FA050.md): Beech B23 · Neihart, MT · Accident · 4 fatal · Closed · Aug 24, 1979 · N7635R · Destroyed
- [NTSB NYC79FFJ26](https://openairdocs.org/ntsb/NYC79FFJ26.md): Piper PA-24 · Wellsville, NY · Accident · No injuries · Closed · Aug 24, 1979 · N9232P · Substantial damage
- [NTSB LAX79DUK18](https://openairdocs.org/ntsb/LAX79DUK18.md): Cessna 150 · Page, AZ · Accident · Minor injuries · Closed · Aug 24, 1979 · N6142G · Substantial damage
- [NTSB FTW79FRG52](https://openairdocs.org/ntsb/FTW79FRG52.md): Bell 47G-4A · Alice, TX · Accident · No injuries · Closed · Aug 24, 1979 · N8573F · Substantial damage
- [NTSB FTW79FQG56](https://openairdocs.org/ntsb/FTW79FQG56.md): Grumman G-164A · Hale Center, TX · Accident · Minor injuries · Closed · Aug 24, 1979 · N4940 · Substantial damage
- [NTSB FTW78DQG55](https://openairdocs.org/ntsb/FTW78DQG55.md): Cessna 188 · Adrian, TX · Accident · Minor injuries · Closed · Aug 24, 1979 · N2538J · Destroyed
- [NTSB NYC79FA082](https://openairdocs.org/ntsb/NYC79FA082.md): Aero Comdr 680FL · Rexville, NY · Accident · 3 fatal · Closed · Aug 23, 1979 · N5003E · Destroyed
- [NTSB LAX79DUK17](https://openairdocs.org/ntsb/LAX79DUK17.md): Piper PA-28 · Shonto, AZ · Accident · No injuries · Closed · Aug 23, 1979 · N7231W · Substantial damage
- [NTSB ANC79FA085](https://openairdocs.org/ntsb/ANC79FA085.md): Piper PA-11 · Dillingham, AK · Accident · 2 fatal · Closed · Aug 23, 1979 · N4520M · Destroyed
- [NTSB ANC79FA083](https://openairdocs.org/ntsb/ANC79FA083.md): Piper PA-14 · Anchorage, AK · Accident · 2 fatal · Closed · Aug 23, 1979 · N4252H · Destroyed
- [NTSB ANC79DAA31](https://openairdocs.org/ntsb/ANC79DAA31.md): Piper PA-12 · Ft.Yukon, AK · Accident · No injuries · Closed · Aug 23, 1979 · N4121N · Substantial damage
- [NTSB NYC79FFS25](https://openairdocs.org/ntsb/NYC79FFS25.md): Bushby 22 · Geneseo, NY · Accident · Serious injuries · Closed · Aug 22, 1979 · N3QB · Substantial damage
- [NTSB MIA79FKA12](https://openairdocs.org/ntsb/MIA79FKA12.md): Piper PA-38 · Camuy, PR · Accident · Minor injuries · Closed · Aug 22, 1979 · N2415G · Destroyed
- [NTSB DEN99FA057](https://openairdocs.org/ntsb/DEN99FA057.md): Piper PA-28 · Fairview, UT · Accident · 4 fatal · Closed · Aug 22, 1979 · N6445J · Substantial damage
- [NTSB MIA79FKJ62](https://openairdocs.org/ntsb/MIA79FKJ62.md): Piper PA-25 · Autaugaville, AL · Accident · Minor injuries · Closed · Aug 21, 1979 · N82367 · Substantial damage
- [NTSB LAX79FUM25](https://openairdocs.org/ntsb/LAX79FUM25.md): N.American P-51D · Nsalton City, CA · Accident · 1 fatal · Closed · Aug 21, 1979 · N332 · Destroyed
- [NTSB FTW79DPJ36](https://openairdocs.org/ntsb/FTW79DPJ36.md): Piper PA-22 · Pauls Valley, OK · Accident · No injuries · Closed · Aug 21, 1979 · N652A · Destroyed
- [NTSB NYC79FHA22](https://openairdocs.org/ntsb/NYC79FHA22.md): Cessna 310I · Reddington, NJ · Accident · No injuries · Closed · Aug 20, 1979 · N8127M · Destroyed
- [NTSB IAD79FA069](https://openairdocs.org/ntsb/IAD79FA069.md): Cessna 310K · Cresaptown, MD · Accident · 2 fatal · Closed · Aug 20, 1979 · N7060L · Destroyed
- [NTSB NYC79FA081](https://openairdocs.org/ntsb/NYC79FA081.md): Cessna 152 · Kunkletown, PA · Accident · 1 fatal · Closed · Aug 19, 1979 · N49080 · Destroyed
- [NTSB MKC79FCD33](https://openairdocs.org/ntsb/MKC79FCD33.md): Cessna 210 · Fostoria, IA · Accident · Serious injuries · Closed · Aug 19, 1979 · N732WZ · Destroyed
- [NTSB MKC79FA050](https://openairdocs.org/ntsb/MKC79FA050.md): Cessna 150 · St Anthony, ND · Accident · 1 fatal · Closed · Aug 19, 1979 · N714HX · Destroyed
- [NTSB LAX79DDD36](https://openairdocs.org/ntsb/LAX79DDD36.md): Aeronca L-3 · Walnut Creek, CA · Accident · No injuries · Closed · Aug 19, 1979 · N49110 · Substantial damage
- [NTSB IAD79FLJ14](https://openairdocs.org/ntsb/IAD79FLJ14.md): Cessna A188 · Merritt, NC · Accident · No injuries · Closed · Aug 19, 1979 · N3532Q · Substantial damage
- [NTSB IAD79FA067](https://openairdocs.org/ntsb/IAD79FA067.md): Benson R8M · Fayetteville, TN · Accident · 1 fatal · Closed · Aug 19, 1979 · N86531 · Destroyed
- [NTSB SEA79FYM58](https://openairdocs.org/ntsb/SEA79FYM58.md): Piper PA-18 · Heppner, OR · Accident · No injuries · Closed · Aug 18, 1979 · N3765Z · Substantial damage
- [NTSB NYC79FGM44](https://openairdocs.org/ntsb/NYC79FGM44.md): Enstrom F28C · Erie, PA · Accident · Serious injuries · Closed · Aug 18, 1979 · N573H · Destroyed
- [NTSB NYC79FA079](https://openairdocs.org/ntsb/NYC79FA079-201200.md): Cessna 172M · Mount Union, PA · Accident · 1 fatal · Closed · Aug 18, 1979 · N6630H · Destroyed
- [NTSB CHI79FEP75](https://openairdocs.org/ntsb/CHI79FEP75.md): Piper PA-28 · Kenosha, WI · Accident · 2 fatal · Closed · Aug 18, 1979 · N3016H · Destroyed
- [NTSB DEN79FA055](https://openairdocs.org/ntsb/DEN79FA055.md): Bell 47G3B1 · Rico, CO · Accident · 2 fatal · Closed · Aug 17, 1979 · N73963 · Destroyed
- [NTSB SEA79FYM57](https://openairdocs.org/ntsb/SEA79FYM57.md): Aero Comdr S-2R · Hermiston, OR · Accident · Serious injuries · Closed · Aug 16, 1979 · N4945X · Substantial damage
- [NTSB SEA79FYE43](https://openairdocs.org/ntsb/SEA79FYE43.md): Zipper HH-1 · Everett, WA · Accident · 1 fatal · Closed · Aug 15, 1979 · N2200Z · Destroyed
- [NTSB NYC79DA077](https://openairdocs.org/ntsb/NYC79DA077.md): Piper PA-18 · Chatam, MA · Accident · No injuries · Closed · Aug 15, 1979 · N8478Y · Destroyed
- [NTSB LAX79FA067](https://openairdocs.org/ntsb/LAX79FA067.md): Maule M-5 · Mammoth Lakes, CA · Accident · 2 fatal · Closed · Aug 15, 1979 · N9067E · Destroyed
- [NTSB IAD79DID25](https://openairdocs.org/ntsb/IAD79DID25.md): Piper PA-28 · Roanoke, VA · Accident · Minor injuries · Closed · Aug 15, 1979 · N41856 · Destroyed
- [NTSB FTW79FPD35](https://openairdocs.org/ntsb/FTW79FPD35.md): Piper PA-22 · Abilene, TX · Accident · No injuries · Closed · Aug 15, 1979 · N5968D · Substantial damage
- [NTSB NYC79FA076](https://openairdocs.org/ntsb/NYC79FA076.md): Richard KR-2 · Asbury Park, NJ · Accident · No injuries · Closed · Aug 14, 1979 · N2262N · Substantial damage
- [NTSB NYC79IA075](https://openairdocs.org/ntsb/NYC79IA075.md): Lear Jet 35 · Newark, NJ · Incident · No injuries · Closed · Aug 13, 1979 · N35NB · Minor damage
- [NTSB DEN79FQD15](https://openairdocs.org/ntsb/DEN79FQD15.md): Cessna 172 · Cloudcroft, NM · Accident · Minor injuries · Closed · Aug 13, 1979 · N739WT · Destroyed

Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=433

## 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 = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=432

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