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

## Cases, newest first

- [NTSB MIA79FKG43](https://openairdocs.org/ntsb/MIA79FKG43.md): Piper PA-28 · Thomaston, GA · Accident · No injuries · Closed · May 24, 1979 · N6396R · Substantial damage
- [NTSB IAD79FKW10](https://openairdocs.org/ntsb/IAD79FKW10.md): Taylorcraft F-19 · Elk Valley, TN · Accident · Minor injuries · Closed · May 24, 1979 · N3679T · Substantial damage
- [NTSB FTW79FQG40](https://openairdocs.org/ntsb/FTW79FQG40.md): Cessna 150M · Dalhart, TX · Accident · No injuries · Closed · May 24, 1979 · N6213K · Destroyed
- [NTSB SEA79FA036](https://openairdocs.org/ntsb/SEA79FA036.md): Cessna 172K · St Maries, ID · Accident · Serious injuries · Closed · May 23, 1979 · N7503G · Destroyed
- [NTSB OAK79FJA12](https://openairdocs.org/ntsb/OAK79FJA12.md): Hiller Acft UH-12E · Lihue, HI · Accident · No injuries · Closed · May 23, 1979 · N155HA · Substantial damage
- [NTSB MKC79FA030](https://openairdocs.org/ntsb/MKC79FA030.md): Cessna 172M · Grand Marais, MN · Accident · 2 fatal · Closed · May 22, 1979 · N1390U · Destroyed
- [NTSB ANC79FAA13](https://openairdocs.org/ntsb/ANC79FAA13.md): Piper PA-22 · Nenana, AK · Accident · No injuries · Closed · May 22, 1979 · N162 · Substantial damage
- [NTSB ANC79DA052](https://openairdocs.org/ntsb/ANC79DA052.md): Piper PA-22 · Cape Seniavin, AK · Accident · 2 fatal · Closed · May 22, 1979 · N90649 · Substantial damage
- [NTSB DEN79FTC14](https://openairdocs.org/ntsb/DEN79FTC14.md): Cessna 172E · Rawlins, WY · Accident · Minor injuries · Closed · May 21, 1979 · N9240Z · Substantial damage
- [NTSB LAX79FUQ30](https://openairdocs.org/ntsb/LAX79FUQ30.md): Cessna 172 · Santa Barbara, CA · Accident · No injuries · Closed · May 20, 1979 · N3711R · Substantial damage
- [NTSB NYC79FA046](https://openairdocs.org/ntsb/NYC79FA046.md): Cessna 182 · Massapequa, NY · Accident · 4 fatal · Closed · May 19, 1979 · N3309U · Substantial damage
- [NTSB MKC79FA029](https://openairdocs.org/ntsb/MKC79FA029.md): Piper PA-18 · Oelrichs, SD · Accident · 1 fatal · Closed · May 19, 1979 · N240T · Destroyed
- [NTSB ANC79DAG55](https://openairdocs.org/ntsb/ANC79DAG55.md): Cessna 206 · Kustatan, AK · Accident · No injuries · Closed · May 19, 1979 · N29029 · Substantial damage
- [NTSB LAX79FVW14](https://openairdocs.org/ntsb/LAX79FVW14.md): Stinson 108-2 · Glendale, NV · Accident · Minor injuries · Closed · May 18, 1979 · N6312M · Substantial damage
- [NTSB DEN79FTM14](https://openairdocs.org/ntsb/DEN79FTM14.md): Piper PA-22 · Panguitch, UT · Accident · Minor injuries · Closed · May 18, 1979 · N8702C · Substantial damage
- [NTSB FTW79DA080](https://openairdocs.org/ntsb/FTW79DA080.md): Bell 206B · Sorrento, LA · Accident · No injuries · Closed · May 17, 1979 · N203AL · Substantial damage
- [NTSB CHI79FEX25](https://openairdocs.org/ntsb/CHI79FEX25.md): Bell 47J2 · Westfield, IN · Accident · No injuries · Closed · May 17, 1979 · N51711 · Substantial damage
- [NTSB IAD79FLQ11](https://openairdocs.org/ntsb/IAD79FLQ11.md): Enstrom F-28-C · Shelbyville, KY · Accident · No injuries · Closed · May 16, 1979 · N559H · Substantial damage
- [NTSB NYC79FGM23](https://openairdocs.org/ntsb/NYC79FGM23-135801.md): Piper PA-32 · Bradford, PA · Accident · Serious injuries · Closed · May 14, 1979 · N4126R · Substantial damage
- [NTSB OAK79FVD27](https://openairdocs.org/ntsb/OAK79FVD27.md): N.American SNJ-6 · Antioch, CA · Accident · No injuries · Closed · May 13, 1979 · N2857G · Destroyed
- [NTSB DEN79FTM17](https://openairdocs.org/ntsb/DEN79FTM17.md): Mooney M20E · Hanksville, UT · Accident · Serious injuries · Closed · May 13, 1979 · N79869 · Substantial damage
- [NTSB DEN79FQD08](https://openairdocs.org/ntsb/DEN79FQD08.md): Cessna 182 · Deming, NM · Accident · Minor injuries · Closed · May 13, 1979 · N8890T · Substantial damage
- [NTSB DEN79FA039](https://openairdocs.org/ntsb/DEN79FA039-201204.md): Piper PA-31 · Albuquerque, NM · Accident · 2 fatal · Closed · May 13, 1979 · N54286 · Destroyed
- [NTSB SEA79FYP21](https://openairdocs.org/ntsb/SEA79FYP21.md): Thorp T-18 · Zillah, WA · Accident · Serious injuries · Closed · May 11, 1979 · N1947 · Destroyed
- [NTSB OAK79FA030](https://openairdocs.org/ntsb/OAK79FA030.md): Piper PA-32 · Groveland, CA · Accident · 1 fatal · Closed · May 11, 1979 · N44698 · Destroyed
- [NTSB MIA79FKG37](https://openairdocs.org/ntsb/MIA79FKG37.md): Piper PA-30B · Ball Ground, GA · Accident · Serious injuries · Closed · May 11, 1979 · N8152Y · Destroyed
- [NTSB FTW79FRG29](https://openairdocs.org/ntsb/FTW79FRG29.md): Cessna 150M · Ft.Hood, TX · Accident · Minor injuries · Closed · May 9, 1979 · N7651U · Substantial damage
- [NTSB CHI79FEC25](https://openairdocs.org/ntsb/CHI79FEC25.md): Rower Aero Bipe · Sandusky, MI · Accident · No injuries · Closed · May 9, 1979 · N3987A · Substantial damage
- [NTSB SEA79FYM31](https://openairdocs.org/ntsb/SEA79FYM31.md): Baird/Beers AMFS14 · Mcminnville, OR · Accident · Serious injuries · Closed · May 8, 1979 · N75LB · Destroyed
- [NTSB DEN79FA039](https://openairdocs.org/ntsb/DEN79FA039-135533.md): Mooney M20F · El Morro, NM · Accident · 2 fatal · Closed · May 8, 1979 · N842JW · Destroyed
- [NTSB LAX79FA051](https://openairdocs.org/ntsb/LAX79FA051.md): Grum-Amer AA-5 · Jerome, AZ · Accident · 2 fatal · Closed · May 7, 1979 · N26306 · Destroyed
- [NTSB ANC79DAA14](https://openairdocs.org/ntsb/ANC79DAA14.md): Piper PA-18 · Unalakleet, AK · Accident · No injuries · Closed · May 7, 1979 · N5885D · Substantial damage
- [NTSB SEA79FYK10](https://openairdocs.org/ntsb/SEA79FYK10.md): Piper PA-24 · Klamath Falls, OR · Accident · Minor injuries · Closed · May 6, 1979 · N5846P · Substantial damage
- [NTSB NYC79FHM17](https://openairdocs.org/ntsb/NYC79FHM17.md): Piper PA-28R · Monsey, NY · Accident · Minor injuries · Closed · May 6, 1979 · N453LT · Substantial damage
- [NTSB NYC79FGT15](https://openairdocs.org/ntsb/NYC79FGT15.md): Grumman AA1 · Mountville, PA · Accident · 1 fatal · Closed · May 6, 1979 · N6404L · Substantial damage
- [NTSB NYC79DHA13](https://openairdocs.org/ntsb/NYC79DHA13.md): Bell 47G · Weatherly, PA · Accident · Serious injuries · Closed · May 6, 1979 · N73979 · Substantial damage
- [NTSB MKC79FCJ17](https://openairdocs.org/ntsb/MKC79FCJ17.md): Beech B24R · Bertrand, NE · Accident · No injuries · Closed · May 6, 1979 · N9345S · Substantial damage
- [NTSB MIA79FLD62](https://openairdocs.org/ntsb/MIA79FLD62.md): Bensen Gyro B-8M · Mulberry, FL · Accident · 1 fatal · Closed · May 6, 1979 · N6820A · Substantial damage
- [NTSB IAD79FIA12](https://openairdocs.org/ntsb/IAD79FIA12.md): Piper PA-28 · Pomonkey, MD · Accident · Minor injuries · Closed · May 6, 1979 · N6583W · Destroyed
- [NTSB CHI79FEV19](https://openairdocs.org/ntsb/CHI79FEV19.md): Cessna 152 · Gillespie, IL · Accident · No injuries · Closed · May 6, 1979 · N68341 · Substantial damage
- [NTSB CHI79FEM20](https://openairdocs.org/ntsb/CHI79FEM20.md): Cessna 310 · Traverse City, MI · Accident · No injuries · Closed · May 6, 1979 · N639R · Substantial damage
- [NTSB SEA79FTA14](https://openairdocs.org/ntsb/SEA79FTA14.md): Cessna 150 · Billings, MT · Accident · No injuries · Closed · May 5, 1979 · N704JL · Substantial damage
- [NTSB MIA79FKJ38](https://openairdocs.org/ntsb/MIA79FKJ38.md): Cessna 182 · Ebro, FL · Accident · Minor injuries · Closed · May 5, 1979 · N8958X · Destroyed
- [NTSB LAX79FA049](https://openairdocs.org/ntsb/LAX79FA049.md): Beech D-50 · Julian, CA · Accident · 5 fatal · Closed · May 5, 1979 · N16MM · Destroyed
- [NTSB FTW79DPJ15](https://openairdocs.org/ntsb/FTW79DPJ15.md): Hughes 269A · Alva, OK · Accident · Minor injuries · Closed · May 5, 1979 · N8892F · Substantial damage
- [NTSB ANC79FA047](https://openairdocs.org/ntsb/ANC79FA047.md): Cessna 185F · Anchorage, AK · Accident · No injuries · Closed · May 4, 1979 · N93294 · Substantial damage
- [NTSB MKC79FA028](https://openairdocs.org/ntsb/MKC79FA028.md): Maule M-4 · Bowman, ND · Accident · 1 fatal · Closed · May 3, 1979 · N2078U · Destroyed
- [NTSB SEA79FA032](https://openairdocs.org/ntsb/SEA79FA032.md): Cessna 150 · John Day, OR · Accident · 1 fatal · Closed · May 1, 1979 · N7753F · Destroyed
- [NTSB MKC79IA025](https://openairdocs.org/ntsb/MKC79IA025-134984.md): Cessna 210 · Bunker, MO · Incident · No injuries · Closed · May 1, 1979 · N6153N · Minor damage
- [NTSB SEA79FA033](https://openairdocs.org/ntsb/SEA79FA033.md): Cessna 182Q · Quilcene, WA · Accident · 1 fatal · Closed · Apr 30, 1979 · N759EZ · Destroyed

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

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

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