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

## Cases, newest first

- [NTSB FTW79DRA08](https://openairdocs.org/ntsb/FTW79DRA08.md): Piper PA-28 · Orange, TX · Accident · No injuries · Closed · Feb 7, 1979 · N3597A · Substantial damage
- [NTSB MIA79FA048](https://openairdocs.org/ntsb/MIA79FA048.md): Beech E35 · Brunswick, GA · Accident · 1 fatal · Closed · Feb 6, 1979 · N2059C · Substantial damage
- [NTSB FTW79FPG17](https://openairdocs.org/ntsb/FTW79FPG17.md): Rockwell 112TCA · Monticello, AR · Accident · Serious injuries · Closed · Feb 6, 1979 · N4685W · Destroyed
- [NTSB MIA79FA047](https://openairdocs.org/ntsb/MIA79FA047.md): Piper PA-23 · Miami, FL · Accident · 2 fatal · Closed · Feb 5, 1979 · N6608Y · Destroyed
- [NTSB MIA79DLD37](https://openairdocs.org/ntsb/MIA79DLD37.md): Aerostar 601P · Vero Beach, FL · Accident · No injuries · Closed · Feb 5, 1979 · N90336 · Substantial damage
- [NTSB NYC79FNC17](https://openairdocs.org/ntsb/NYC79FNC17.md): Piper PA-28 · Portland, ME · Accident · Serious injuries · Closed · Feb 4, 1979 · N42236 · Substantial damage
- [NTSB FTW79DQD07](https://openairdocs.org/ntsb/FTW79DQD07.md): Aerospatial 350C · Salt Flat, TX · Accident · No injuries · Closed · Feb 3, 1979 · N49556 · Substantial damage
- [NTSB DEN79FA019](https://openairdocs.org/ntsb/DEN79FA019.md): Cessna T210 · Boulder, CO · Accident · 2 fatal · Closed · Feb 3, 1979 · N9490M · Destroyed
- [NTSB CHI79FET15](https://openairdocs.org/ntsb/CHI79FET15.md): Cessna 152 · Valparaiso, IN · Accident · Minor injuries · Closed · Feb 3, 1979 · N757NC · Substantial damage
- [NTSB OAK79DXQ13](https://openairdocs.org/ntsb/OAK79DXQ13.md): Cessna 210 · Battle Mt, NV · Accident · No injuries · Closed · Feb 2, 1979 · N94242 · Substantial damage
- [NTSB SEA79FYE12](https://openairdocs.org/ntsb/SEA79FYE12.md): Cessna 182 · Parkland, WA · Accident · No injuries · Closed · Jan 31, 1979 · N58454 · Substantial damage
- [NTSB LAX79FUG15](https://openairdocs.org/ntsb/LAX79FUG15.md): Rand KR-2 · Victorville, CA · Accident · 1 fatal · Closed · Jan 31, 1979 · N4KR · Destroyed
- [NTSB SEA79DYE13](https://openairdocs.org/ntsb/SEA79DYE13.md): Cessna 140 · Mt.Rainier, WA · Accident · No injuries · Closed · Jan 29, 1979 · N4108N · Substantial damage
- [NTSB FTW79FQG16](https://openairdocs.org/ntsb/FTW79FQG16.md): Beech 58P · Amarillo, TX · Accident · Serious injuries · Closed · Jan 29, 1979 · N23644 · Substantial damage
- [NTSB ANC79DA037](https://openairdocs.org/ntsb/ANC79DA037.md): Cessna 185 · Point Hope, AK · Accident · No injuries · Closed · Jan 28, 1979 · N21369 · Substantial damage
- [NTSB ANC79DA036](https://openairdocs.org/ntsb/ANC79DA036.md): Dehavilland DHC-6 · Anaktuvuk Pass, AK · Accident · No injuries · Closed · Jan 28, 1979 · N851TB · Substantial damage
- [NTSB MIA79FA045](https://openairdocs.org/ntsb/MIA79FA045.md): Hughes 269C · Andytown, FL · Accident · 2 fatal · Closed · Jan 27, 1979 · N7450F · Destroyed
- [NTSB NYC79FA022](https://openairdocs.org/ntsb/NYC79FA022.md): Piper PA-31 · Lima, NY · Accident · No injuries · Closed · Jan 26, 1979 · N9004Y · Substantial damage
- [NTSB MIA79DKA04](https://openairdocs.org/ntsb/MIA79DKA04.md): Piper PA-28 · San Juan, PR · Accident · No injuries · Closed · Jan 26, 1979 · N7309J · Destroyed
- [NTSB IAD79FKM07](https://openairdocs.org/ntsb/IAD79FKM07.md): Beech S35 · Franklin, NC · Accident · Serious injuries · Closed · Jan 26, 1979 · N5792K · Substantial damage
- [NTSB MIA79FLT03](https://openairdocs.org/ntsb/MIA79FLT03.md): Cessna 150 · Booneville, MS · Accident · No injuries · Closed · Jan 25, 1979 · N8357U · Substantial damage
- [NTSB NYC79FFA10](https://openairdocs.org/ntsb/NYC79FFA10.md): Piper PA-23 · Utica, NY · Accident · Serious injuries · Closed · Jan 23, 1979 · N63888 · Substantial damage
- [NTSB ANC79FAD02](https://openairdocs.org/ntsb/ANC79FAD02.md): Dehavilland DHC-2 · Ketchican, AK · Accident · Serious injuries · Closed · Jan 23, 1979 · N68086 · Destroyed
- [NTSB MKC79FA016](https://openairdocs.org/ntsb/MKC79FA016.md): Cessna 180J · Blair, NE · Accident · 2 fatal · Closed · Jan 22, 1979 · N7836K · Destroyed
- [NTSB FTW79FQG17](https://openairdocs.org/ntsb/FTW79FQG17.md): Cessna P206D · Seminole, TX · Accident · No injuries · Closed · Jan 21, 1979 · N8725Z · Substantial damage
- [NTSB ANC79FA034](https://openairdocs.org/ntsb/ANC79FA034.md): Piper PA-18 · Galena, AK · Accident · No injuries · Closed · Jan 21, 1979 · N8324 · Substantial damage
- [NTSB OAK79FVD08](https://openairdocs.org/ntsb/OAK79FVD08.md): Beech C-24R · San Leandro, CA · Accident · Serious injuries · Closed · Jan 20, 1979 · N24040 · Substantial damage
- [NTSB LAX79DVA14](https://openairdocs.org/ntsb/LAX79DVA14.md): Enstrom F28A · Shafter, CA · Accident · No injuries · Closed · Jan 20, 1979 · N520H · Substantial damage
- [NTSB FTW79FRG13](https://openairdocs.org/ntsb/FTW79FRG13.md): Bell 47G-4A · Falfurrias, TX · Accident · Serious injuries · Closed · Jan 20, 1979 · N4002G · Destroyed
- [NTSB DEN79IA015](https://openairdocs.org/ntsb/DEN79IA015.md): Douglas DC-10 · Denver, CO · Incident · No injuries · Closed · Jan 20, 1979 · N1872U · No damage
- [NTSB CHI79FEI09](https://openairdocs.org/ntsb/CHI79FEI09.md): Cessna 310 · Willoughby, OH · Accident · Minor injuries · Closed · Jan 19, 1979 · N5848M · Substantial damage
- [NTSB ANC79FA033](https://openairdocs.org/ntsb/ANC79FA033.md): Cessna U206 · Cape Romanzof, AK · Accident · 1 fatal · Closed · Jan 19, 1979 · N4970C · Destroyed
- [NTSB NYC79FHA08](https://openairdocs.org/ntsb/NYC79FHA08.md): Piper PA-28R · West Milford, NJ · Accident · No injuries · Closed · Jan 18, 1979 · N7814W · Substantial damage
- [NTSB CHI79FA024](https://openairdocs.org/ntsb/CHI79FA024.md): Piper PA-23 · Scottown, OH · Accident · 3 fatal · Closed · Jan 18, 1979 · N4031P · Destroyed
- [NTSB SEA79FA019](https://openairdocs.org/ntsb/SEA79FA019.md): Cessna 182P · Seattle, WA · Accident · 1 fatal · Closed · Jan 17, 1979 · N8483M · Destroyed
- [NTSB MIA79FLO32](https://openairdocs.org/ntsb/MIA79FLO32.md): Piper PA-32 · Vero Beach, FL · Accident · No injuries · Closed · Jan 16, 1979 · N21698 · Substantial damage
- [NTSB MIA79FKG15](https://openairdocs.org/ntsb/MIA79FKG15.md): Pdq-2 E · Stockbridge, GA · Accident · Serious injuries · Closed · Jan 16, 1979 · N2282T · Substantial damage
- [NTSB FTW79FA044](https://openairdocs.org/ntsb/FTW79FA044.md): Cessna 172N · Mount Judea, AR · Accident · 2 fatal · Closed · Jan 16, 1979 · N2564L · Destroyed
- [NTSB MIA79FKT36](https://openairdocs.org/ntsb/MIA79FKT36.md): Aero Comdr 560E · Clewiston, FL · Accident · Serious injuries · Closed · Jan 15, 1979 · N438G · Destroyed
- [NTSB LAX81FA005](https://openairdocs.org/ntsb/LAX81FA005.md): Bellanca 17-31 · Gorman, CA · Accident · 1 fatal · Closed · Jan 15, 1979 · N7367V · Destroyed
- [NTSB IAD79FA028](https://openairdocs.org/ntsb/IAD79FA028.md): Piper PA-32 · Paris, TN · Accident · Serious injuries · Closed · Jan 15, 1979 · N4815S · Destroyed
- [NTSB MKC79DER18](https://openairdocs.org/ntsb/MKC79DER18.md): Cessna 152 · Cottage Grove, MN · Accident · No injuries · Closed · Jan 13, 1979 · N757WE · Substantial damage
- [NTSB MIA79FKT35](https://openairdocs.org/ntsb/MIA79FKT35.md): Dehavilland DH-104 · Labelle, FL · Accident · No injuries · Closed · Jan 12, 1979 · N80013 · Substantial damage
- [NTSB MIA79FA040](https://openairdocs.org/ntsb/MIA79FA040.md): Cessna 150M · Orlando, FL · Accident · 1 fatal · Closed · Jan 12, 1979 · N9278U · Destroyed
- [NTSB FTW79FQG14](https://openairdocs.org/ntsb/FTW79FQG14.md): Piper PA-23 · Acuff, TX · Accident · No injuries · Closed · Jan 12, 1979 · N6792Y · Substantial damage
- [NTSB FTW79FA040](https://openairdocs.org/ntsb/FTW79FA040.md): Beech 95-B55 · Acuff, TX · Accident · 2 fatal · Closed · Jan 12, 1979 · N6032F · Destroyed
- [NTSB NYC79FA017](https://openairdocs.org/ntsb/NYC79FA017.md): Piper PA-31 · Templeton, MA · Accident · 5 fatal · Closed · Jan 11, 1979 · N33TN · 2 aircraft · Destroyed
- [NTSB FTW79FA041](https://openairdocs.org/ntsb/FTW79FA041.md): Aero Comdr 680FP · El Reno, OK · Accident · 3 fatal · Closed · Jan 11, 1979 · N2177M · Destroyed
- [NTSB CHI79FEE31](https://openairdocs.org/ntsb/CHI79FEE31.md): Cessna 152 · Geneva, IL · Accident · Minor injuries · Closed · Jan 11, 1979 · N69258 · Substantial damage
- [NTSB NYC79FFA08](https://openairdocs.org/ntsb/NYC79FFA08.md): Cessna 177RG · Hartford, NY · Accident · No injuries · Closed · Jan 10, 1979 · N50016 · Substantial damage

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

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

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