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

## Cases, newest first

- [NTSB MKC79DER57](https://openairdocs.org/ntsb/MKC79DER57-134213.md): Cessna 188T · Belview, MN · Accident · Minor injuries · Closed · Jul 24, 1979 · N2070J · Substantial damage
- [NTSB LAX79FUQ40](https://openairdocs.org/ntsb/LAX79FUQ40.md): Baby Great Lakes · Santa Paula, CA · Accident · Serious injuries · Closed · Jul 23, 1979 · N3448 · Substantial damage
- [NTSB DEN79FTE62](https://openairdocs.org/ntsb/DEN79FTE62.md): Great Lakes 2T · Castle Rock, CO · Accident · No injuries · Closed · Jul 23, 1979 · N77IVY · Substantial damage
- [NTSB ANC79FAD03](https://openairdocs.org/ntsb/ANC79FAD03.md): Piper PA-28 · Pt.Sherman, AK · Accident · No injuries · Closed · Jul 23, 1979 · N6396C · Substantial damage
- [NTSB MKC79FCA21](https://openairdocs.org/ntsb/MKC79FCA21.md): Cessna 177RG · Thayer, MO · Accident · Serious injuries · Closed · Jul 22, 1979 · N53097 · Substantial damage
- [NTSB LAX79FUA15](https://openairdocs.org/ntsb/LAX79FUA15.md): Cessna T210L · Newport Beach, CA · Accident · 1 fatal · Closed · Jul 22, 1979 · N732AR · Destroyed
- [NTSB FTW79FA028](https://openairdocs.org/ntsb/FTW79FA028-134248.md): Cessna T210N · Kingfisher, OK · Accident · 2 fatal · Closed · Jul 22, 1979 · N5364A · Destroyed
- [NTSB CHI79FEV27](https://openairdocs.org/ntsb/CHI79FEV27.md): Smith BGL · Macomb, IL · Accident · 1 fatal · Closed · Jul 22, 1979 · N69119 · Substantial damage
- [NTSB SEA79FYM52](https://openairdocs.org/ntsb/SEA79FYM52.md): Cessna 150 · Sisters, OR · Accident · Serious injuries · Closed · Jul 21, 1979 · N51321 · Substantial damage
- [NTSB OAK79DXQ25](https://openairdocs.org/ntsb/OAK79DXQ25.md): Cessna 182 · Susanville, CA · Accident · No injuries · Closed · Jul 21, 1979 · N6864M · Substantial damage
- [NTSB NYC79FNA24](https://openairdocs.org/ntsb/NYC79FNA24.md): Cessna 305A · Quincy, MA · Accident · No injuries · Closed · Jul 21, 1979 · N5284G · Substantial damage
- [NTSB NYC79FFJ24](https://openairdocs.org/ntsb/NYC79FFJ24.md): Palermo ACE · Geneseo, NY · Accident · Minor injuries · Closed · Jul 21, 1979 · N666Q · Substantial damage
- [NTSB NYC79FA064](https://openairdocs.org/ntsb/NYC79FA064.md): Bell 206B · Alpine, NJ · Accident · No injuries · Closed · Jul 21, 1979 · N711GT · Substantial damage
- [NTSB MKC79DCG62](https://openairdocs.org/ntsb/MKC79DCG62.md): Boeing A75 · Effingham, KS · Accident · No injuries · Closed · Jul 21, 1979 · N75360 · Substantial damage
- [NTSB DEN79FTE61](https://openairdocs.org/ntsb/DEN79FTE61.md): Cessna 150 · Berthoud, CO · Accident · Serious injuries · Closed · Jul 21, 1979 · N18660 · Substantial damage
- [NTSB DEN79FA051](https://openairdocs.org/ntsb/DEN79FA051.md): Cessna 177RG · Fairplay, CO · Accident · 3 fatal · Closed · Jul 21, 1979 · N8019G · Destroyed
- [NTSB ANC79DAG85](https://openairdocs.org/ntsb/ANC79DAG85.md): Piper PA-32 · Soldotna, AK · Accident · Minor injuries · Closed · Jul 21, 1979 · N5499T · Substantial damage
- [NTSB OAK79DAMS7](https://openairdocs.org/ntsb/OAK79DAMS7.md): Douglas DC-3 · Honolulu (Pacific Ocean) · Accident · 2 fatal · Closed · Jul 20, 1979 · N63250 · Destroyed
- [NTSB MIA79DKT88](https://openairdocs.org/ntsb/MIA79DKT88.md): Cessna 152 · Opa Locka, FL · Accident · No injuries · Closed · Jul 20, 1979 · N757DW · Substantial damage
- [NTSB LAX79FA062](https://openairdocs.org/ntsb/LAX79FA062.md): Cessna 172 · Mesa, AZ · Accident · 1 fatal · Closed · Jul 20, 1979 · N6250D · Substantial damage
- [NTSB CHI79FEX33](https://openairdocs.org/ntsb/CHI79FEX33.md): Texas Heli OH-13 · Solitude, IN · Accident · 1 fatal · Closed · Jul 20, 1979 · N51847 · Destroyed
- [NTSB OAK79IA034](https://openairdocs.org/ntsb/OAK79IA034.md): Boeing 737 · Fresno, CA · Incident · Minor injuries · Closed · Jul 19, 1979 · N73717 · Minor damage
- [NTSB NYC79DA069](https://openairdocs.org/ntsb/NYC79DA069.md): Piper PA-24 · Pittsburgh, PA · Incident · No injuries · Closed · Jul 19, 1979 · N8250P · No damage
- [NTSB NYC79DA062](https://openairdocs.org/ntsb/NYC79DA062.md): Piper PA-18 · Martha'S Vnyrd (Atlantic Ocean) · Accident · No injuries · Closed · Jul 19, 1979 · N811H · Destroyed
- [NTSB MIA79DKJ55](https://openairdocs.org/ntsb/MIA79DKJ55.md): Cessna 172 · Marianna, FL · Accident · Serious injuries · Closed · Jul 19, 1979 · N20456 · Destroyed
- [NTSB IAD79DKW18](https://openairdocs.org/ntsb/IAD79DKW18.md): Beech A35 · Greeneville, TN · Accident · Minor injuries · Closed · Jul 19, 1979 · N534B · Substantial damage
- [NTSB DEN79FA050](https://openairdocs.org/ntsb/DEN79FA050.md): Aero Comdr 680FL · Northglenn, CO · Accident · No injuries · Closed · Jul 19, 1979 · N291NC · Substantial damage
- [NTSB SEA79FYM51](https://openairdocs.org/ntsb/SEA79FYM51.md): Bell 47G · Embler, OR · Accident · Minor injuries · Closed · Jul 18, 1979 · N6356X · Substantial damage
- [NTSB LAX79DA066](https://openairdocs.org/ntsb/LAX79DA066.md): Cessna 206 · Chinle, AZ · Accident · No injuries · Closed · Jul 18, 1979 · N29152 · Substantial damage
- [NTSB IAD79IA064](https://openairdocs.org/ntsb/IAD79IA064.md): Namc YS-11A · Charlottesvlle, VA · Incident · No injuries · Closed · Jul 18, 1979 · N259P · Minor damage
- [NTSB CHI79FEG20](https://openairdocs.org/ntsb/CHI79FEG20.md): Warmick BAT W3 · Miamitown, OH · Accident · 1 fatal · Closed · Jul 18, 1979 · N1313Q · Substantial damage
- [NTSB IAD79FLQ20](https://openairdocs.org/ntsb/IAD79FLQ20.md): Cessna 172 · Louisville, KY · Accident · No injuries · Closed · Jul 17, 1979 · N18171 · Substantial damage
- [NTSB IAD79FI610](https://openairdocs.org/ntsb/IAD79FI610.md): Bellanca 7GCBC · Ocean City, MD · Accident · No injuries · Closed · Jul 17, 1979 · N11718 · Substantial damage
- [NTSB CHI79FEE67](https://openairdocs.org/ntsb/CHI79FEE67.md): Friling Variez · Plainfield, IL · Accident · No injuries · Closed · Jul 17, 1979 · N28JF · Substantial damage
- [NTSB ANC79DAG62](https://openairdocs.org/ntsb/ANC79DAG62.md): Cessna 185F · Port Allsworth, AK · Accident · No injuries · Closed · Jul 17, 1979 · N1770R · Substantial damage
- [NTSB FTW79DRG46](https://openairdocs.org/ntsb/FTW79DRG46.md): Sportaire · San Antonio, TX · Accident · No injuries · Closed · Jul 16, 1979 · N77BT · Substantial damage
- [NTSB ANC79DAA23](https://openairdocs.org/ntsb/ANC79DAA23.md): Cessna 150H · Fairbanks, AK · Accident · No injuries · Closed · Jul 16, 1979 · N50296 · Substantial damage
- [NTSB NYC79FA058](https://openairdocs.org/ntsb/NYC79FA058.md): Piper PA-28 · Blng Springs, PA · Accident · 4 fatal · Closed · Jul 15, 1979 · N2216G · Destroyed
- [NTSB MKC79DCG59](https://openairdocs.org/ntsb/MKC79DCG59.md): Bensen Gyro · Mountain Grove, MO · Accident · No injuries · Closed · Jul 15, 1979 · N47814 · Substantial damage
- [NTSB CHI79FEP67](https://openairdocs.org/ntsb/CHI79FEP67.md): Piper PA-17 · South Byron, WI · Accident · Minor injuries · Closed · Jul 15, 1979 · N4839H · Substantial damage
- [NTSB SEA79FA046](https://openairdocs.org/ntsb/SEA79FA046.md): Piper PA-38 · Bellevue, ID · Accident · 1 fatal · Closed · Jul 14, 1979 · N9320T · Destroyed
- [NTSB OAK79FXQ24](https://openairdocs.org/ntsb/OAK79FXQ24.md): Cessna 172D · Reno, NV · Accident · Minor injuries · Closed · Jul 14, 1979 · N2651U · Substantial damage
- [NTSB NYC79FA057](https://openairdocs.org/ntsb/NYC79FA057.md): Piper PA-18S · Shenley, PA · Accident · 2 fatal · Closed · Jul 14, 1979 · N4399A · Destroyed
- [NTSB FTW79FPD28](https://openairdocs.org/ntsb/FTW79FPD28.md): Cessna 150L · Weatherford, TX · Accident · No injuries · Closed · Jul 14, 1979 · N7930G · Substantial damage
- [NTSB ANC79IA071](https://openairdocs.org/ntsb/ANC79IA071.md): Cessna 207 · Saltery Cove, AK · Incident · No injuries · Closed · Jul 14, 1979 · N29CF · No damage
- [NTSB SEA79FYE31](https://openairdocs.org/ntsb/SEA79FYE31.md): Globe GC-1B · Puyallup, WA · Accident · Minor injuries · Closed · Jul 13, 1979 · N80918 · Substantial damage
- [NTSB MIA79FA103](https://openairdocs.org/ntsb/MIA79FA103.md): Douglas DC-3 · Belle Glade, FL · Accident · No injuries · Closed · Jul 13, 1979 · N21782 · Substantial damage
- [NTSB ANC79IA069](https://openairdocs.org/ntsb/ANC79IA069.md): Beech C-18S · Drake Island, AK · Incident · Minor injuries · Closed · Jul 13, 1979 · N1047B · Minor damage
- [NTSB LAX79FVA49](https://openairdocs.org/ntsb/LAX79FVA49.md): Focke Wolf 190 · Gustine, CA · Accident · Serious injuries · Closed · Jul 12, 1979 · N19TF · Substantial damage
- [NTSB LAX79DUJ98](https://openairdocs.org/ntsb/LAX79DUJ98.md): Cessna 182 · Suprise, AZ · Accident · No injuries · Closed · Jul 12, 1979 · N6863M · Substantial damage

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

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

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