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

## Cases, newest first

- [NTSB ANC79FA068](https://openairdocs.org/ntsb/ANC79FA068.md): Cessna 402B · Anchorage, AK · Accident · 7 fatal · Closed · Jul 12, 1979 · N402TH · Destroyed
- [NTSB SEA79FYM48](https://openairdocs.org/ntsb/SEA79FYM48-134274.md): Grumman G-164A · Hermiston, OR · Accident · No injuries · Closed · Jul 11, 1979 · N5340 · Substantial damage
- [NTSB CHI79FEG18](https://openairdocs.org/ntsb/CHI79FEG18.md): Beech E-18S · Dayton, OH · Accident · Serious injuries · Closed · Jul 11, 1979 · N136C · Destroyed
- [NTSB SEA79FA044](https://openairdocs.org/ntsb/SEA79FA044.md): Cessna 182G · Challis, ID · Accident · Serious injuries · Closed · Jul 10, 1979 · N3158Y · Destroyed
- [NTSB NYC79FNC36](https://openairdocs.org/ntsb/NYC79FNC36.md): Waco UPF-7 · North Conway, NH · Accident · No injuries · Closed · Jul 10, 1979 · N32127 · Substantial damage
- [NTSB CHI79FEX32](https://openairdocs.org/ntsb/CHI79FEX32.md): Cessna 172 · Terra Haute, IN · Accident · Minor injuries · Closed · Jul 10, 1979 · N738YH · Substantial damage
- [NTSB NYC79FNC35](https://openairdocs.org/ntsb/NYC79FNC35.md): Erco 415-C · Turner, ME · Accident · No injuries · Closed · Jul 9, 1979 · N99249 · Substantial damage
- [NTSB MIA79FKG53](https://openairdocs.org/ntsb/MIA79FKG53.md): Piper PA-23 · Sapelo Island, GA · Accident · No injuries · Closed · Jul 9, 1979 · N4026P · Substantial damage
- [NTSB FTW79FPG63](https://openairdocs.org/ntsb/FTW79FPG63.md): Aero Cmdr 600S-2 · Crawfordsville, AR · Accident · Serious injuries · Closed · Jul 9, 1979 · N8416V · Substantial damage
- [NTSB SEA79FYP34](https://openairdocs.org/ntsb/SEA79FYP34.md): Piper PA-28 · Othello, WA · Accident · No injuries · Closed · Jul 8, 1979 · N43097 · Substantial damage
- [NTSB NYC79FGM32](https://openairdocs.org/ntsb/NYC79FGM32.md): Luscombe 8A · Albion, PA · Accident · Minor injuries · Closed · Jul 8, 1979 · N45922 · Substantial damage
- [NTSB LAX79FA059](https://openairdocs.org/ntsb/LAX79FA059-134227.md): Fairchild C119L · Casa Grande, AZ · Accident · 4 fatal · Closed · Jul 8, 1979 · N1040E · Destroyed
- [NTSB IAD80FA009](https://openairdocs.org/ntsb/IAD80FA009.md): Cessna T210 · Highlands, NC · Accident · 2 fatal · Closed · Jul 8, 1979 · N6916R · Destroyed
- [NTSB IAD79FIA14](https://openairdocs.org/ntsb/IAD79FIA14.md): Grum Amer AA-5 · Warrenton, VA · Accident · No injuries · Closed · Jul 8, 1979 · N9629U · Substantial damage
- [NTSB FTW79FQG47](https://openairdocs.org/ntsb/FTW79FQG47.md): Piper PA-25 · Spur, TX · Accident · No injuries · Closed · Jul 8, 1979 · N6341Z · Substantial damage
- [NTSB FTW79DPG61](https://openairdocs.org/ntsb/FTW79DPG61.md): Cessna 172 · El Dorado, AR · Accident · No injuries · Closed · Jul 8, 1979 · N75625 · Substantial damage
- [NTSB CHI79FEM27](https://openairdocs.org/ntsb/CHI79FEM27.md): Aeronca 7AC · Spring Lake, MI · Accident · Serious injuries · Closed · Jul 8, 1979 · N85092 · Substantial damage
- [NTSB MIA79FKQ14](https://openairdocs.org/ntsb/MIA79FKQ14.md): Cessna A188B · Lyman, MS · Accident · 1 fatal · Closed · Jul 7, 1979 · N4910R · Destroyed
- [NTSB MIA79DA114](https://openairdocs.org/ntsb/MIA79DA114.md): Lockheed PV-1 · Aruba (Atlantic Ocean) · Accident · No injuries · Closed · Jul 7, 1979 · N721N · Destroyed
- [NTSB LAX79DUG49](https://openairdocs.org/ntsb/LAX79DUG49.md): Beech K-35 · Barstow, CA · Accident · No injuries · Closed · Jul 7, 1979 · N677T · Substantial damage
- [NTSB CHI79FEM25](https://openairdocs.org/ntsb/CHI79FEM25.md): Bellanca 7GCAA · West Branch, MI · Accident · Minor injuries · Closed · Jul 7, 1979 · N31252 · Substantial damage
- [NTSB ANC79FA067](https://openairdocs.org/ntsb/ANC79FA067.md): Rallye 235GT · Kodiak, AK · Accident · 3 fatal · Closed · Jul 7, 1979 · N302RA · Destroyed
- [NTSB SEA79FA043](https://openairdocs.org/ntsb/SEA79FA043.md): Aero Comdr 114 · Leavenworth, WA · Accident · 2 fatal · Closed · Jul 6, 1979 · N5873N · Destroyed
- [NTSB OAK79FVM29](https://openairdocs.org/ntsb/OAK79FVM29.md): Cessna 152 · San Jose, CA · Accident · No injuries · Closed · Jul 6, 1979 · N24455 · Substantial damage
- [NTSB MIA79FKJ53](https://openairdocs.org/ntsb/MIA79FKJ53.md): Cessna 421B · Montgomery, AL · Accident · No injuries · Closed · Jul 6, 1979 · N8079Q · Substantial damage
- [NTSB LAX79FUM20](https://openairdocs.org/ntsb/LAX79FUM20.md): Bell 47G-5 · Escondido, CA · Accident · Serious injuries · Closed · Jul 6, 1979 · N7914S · Substantial damage
- [NTSB IAD79DIJ09](https://openairdocs.org/ntsb/IAD79DIJ09.md): Bell 206 · Gary, WV · Accident · No injuries · Closed · Jul 6, 1979 · N90315 · Substantial damage
- [NTSB DEN79FQA37](https://openairdocs.org/ntsb/DEN79FQA37.md): Bell 47G · Socorro, NM · Accident · No injuries · Closed · Jul 6, 1979 · N73998 · Substantial damage
- [NTSB CHI79FEP53](https://openairdocs.org/ntsb/CHI79FEP53.md): Cessna 150 · Milwaukee, WI · Accident · No injuries · Closed · Jul 6, 1979 · N7774F · Substantial damage
- [NTSB NYC79FNA19](https://openairdocs.org/ntsb/NYC79FNA19.md): Ciciora T-18 · West Tisbury, MA · Accident · No injuries · Closed · Jul 4, 1979 · N64628 · Substantial damage
- [NTSB FTW79FPG60](https://openairdocs.org/ntsb/FTW79FPG60.md): Cessna 172M · Newport, AR · Accident · Minor injuries · Closed · Jul 4, 1979 · N12588 · Substantial damage
- [NTSB SEA79DYP32](https://openairdocs.org/ntsb/SEA79DYP32.md): Grumman G-164A · Lewiston, ID · Accident · Serious injuries · Closed · Jul 3, 1979 · N25SK · Substantial damage
- [NTSB FTW79FA092](https://openairdocs.org/ntsb/FTW79FA092.md): Cessna 340 · Ashdown, AR · Accident · 7 fatal · Closed · Jul 3, 1979 · N345B · 2 aircraft · Destroyed
- [NTSB CHI79FEP51](https://openairdocs.org/ntsb/CHI79FEP51.md): Cessna 182P · Neillsville, WI · Accident · Serious injuries · Closed · Jul 3, 1979 · N22FW · Substantial damage
- [NTSB CHI79FA056](https://openairdocs.org/ntsb/CHI79FA056.md): Piper PA-28 · Taylor, WI · Accident · 1 fatal · Closed · Jul 3, 1979 · N8341C · Destroyed
- [NTSB ANC79FA065](https://openairdocs.org/ntsb/ANC79FA065.md): Enstrom F-28C · Portage, AK · Accident · No injuries · Closed · Jul 2, 1979 · N532H · Substantial damage
- [NTSB OAK79DVA47](https://openairdocs.org/ntsb/OAK79DVA47.md): Beech C23 · Chinese Camp, CA · Accident · No injuries · Closed · Jul 1, 1979 · N5244M · Substantial damage
- [NTSB MIA79DKT73](https://openairdocs.org/ntsb/MIA79DKT73.md): Beech A60 · Belle Glade, FL · Accident · Minor injuries · Closed · Jul 1, 1979 · N461P · Substantial damage
- [NTSB LAX79FUM18](https://openairdocs.org/ntsb/LAX79FUM18.md): Cessna 210J · Carlsbad, CA · Accident · No injuries · Closed · Jul 1, 1979 · N3384S · Substantial damage
- [NTSB DEN79FTC19](https://openairdocs.org/ntsb/DEN79FTC19.md): Hughes 369D · Labarge, WY · Accident · No injuries · Closed · Jul 1, 1979 · N8667F · Substantial damage
- [NTSB OAK79FVD34](https://openairdocs.org/ntsb/OAK79FVD34.md): Cessna 172K · Livermore, CA · Accident · No injuries · Closed · Jun 30, 1979 · N7134G · Substantial damage
- [NTSB ANC79FA064](https://openairdocs.org/ntsb/ANC79FA064.md): Cessna U206F · Kotlik, AK · Accident · Minor injuries · Closed · Jun 30, 1979 · N1991U · Destroyed
- [NTSB SEA79FYP31](https://openairdocs.org/ntsb/SEA79FYP31.md): Hiller Acft UH-12E · Quincy, WA · Accident · No injuries · Closed · Jun 29, 1979 · N65048 · Substantial damage
- [NTSB NYC79DNC41](https://openairdocs.org/ntsb/NYC79DNC41.md): Cessna 140A · Johnson, VT · Accident · No injuries · Closed · Jun 29, 1979 · N5347C · Substantial damage
- [NTSB MKC79FCQ34](https://openairdocs.org/ntsb/MKC79FCQ34.md): Interceptor Super · Johnson, KS · Accident · Minor injuries · Closed · Jun 29, 1979 · N10347 · Substantial damage
- [NTSB MKC79FCG52](https://openairdocs.org/ntsb/MKC79FCG52.md): Grumman AA1B · Garnett, KS · Accident · No injuries · Closed · Jun 29, 1979 · N8861L · Destroyed
- [NTSB FTW79FA090](https://openairdocs.org/ntsb/FTW79FA090.md): Luscombe 8A · Winnsboro, LA · Accident · 2 fatal · Closed · Jun 29, 1979 · N45950 · Destroyed
- [NTSB DEN79DQD13](https://openairdocs.org/ntsb/DEN79DQD13.md): Piper PA-28 · Whites City, NM · Accident · No injuries · Closed · Jun 29, 1979 · N2124J · Substantial damage
- [NTSB ANC79DAG57](https://openairdocs.org/ntsb/ANC79DAG57.md): Bellanca 7GCBC · Anchorage, AK · Accident · No injuries · Closed · Jun 29, 1979 · N2698Z · Substantial damage
- [NTSB MIA79FKA07](https://openairdocs.org/ntsb/MIA79FKA07.md): Cessna 172 · St.Croix, VI · Accident · No injuries · Closed · Jun 28, 1979 · N2949U · Substantial damage

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

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

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