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

## Cases, newest first

- [NTSB IAD79FID14](https://openairdocs.org/ntsb/IAD79FID14.md): Bellanca 17-30 · Quinton, VA · Accident · No injuries · Closed · Apr 30, 1979 · N4862V · Substantial damage
- [NTSB SEA79DYE21](https://openairdocs.org/ntsb/SEA79DYE21.md): Cessna 150 · Curtiss, WA · Accident · No injuries · Closed · Apr 29, 1979 · N19041 · Destroyed
- [NTSB MIA79FLD60](https://openairdocs.org/ntsb/MIA79FLD60.md): Piper J-3C · Arcadia, FL · Accident · Minor injuries · Closed · Apr 29, 1979 · N2156M · Substantial damage
- [NTSB LAX79DUJ67](https://openairdocs.org/ntsb/LAX79DUJ67.md): Aeronca 7AC · Tucson, AZ · Accident · No injuries · Closed · Apr 29, 1979 · N1338E · Substantial damage
- [NTSB SEA79FYM30](https://openairdocs.org/ntsb/SEA79FYM30.md): Piper PA-28 · Sandy, OR · Accident · Serious injuries · Closed · Apr 28, 1979 · N7142W · Destroyed
- [NTSB MIA79FLG22](https://openairdocs.org/ntsb/MIA79FLG22.md): Piper PA-28 · Ridgeland, SC · Accident · Minor injuries · Closed · Apr 28, 1979 · N15197 · Destroyed
- [NTSB MIA79FKT62](https://openairdocs.org/ntsb/MIA79FKT62.md): Bellanca 7GCBC · Miami, FL · Accident · Serious injuries · Closed · Apr 28, 1979 · N2670Z · Destroyed
- [NTSB FTW7DDA077](https://openairdocs.org/ntsb/FTW7DDA077.md): Bell 206L · Cameron, LA · Accident · Minor injuries · Closed · Apr 28, 1979 · N16779 · Substantial damage
- [NTSB MIA79DA079](https://openairdocs.org/ntsb/MIA79DA079.md): Lockheed PV-1 · Guamtanamo (Atlantic Ocean) · Accident · 2 fatal · Closed · Apr 27, 1979 · N544B · Destroyed
- [NTSB FTW79FPJ13](https://openairdocs.org/ntsb/FTW79FPJ13.md): Cessna 172 · Minco, OK · Accident · No injuries · Closed · Apr 27, 1979 · N5233F · Substantial damage
- [NTSB CHI79FEE51](https://openairdocs.org/ntsb/CHI79FEE51.md): Beech 65-A90 · Chicago, IL · Accident · Minor injuries · Closed · Apr 27, 1979 · N5JR · Substantial damage
- [NTSB LAX79FA047](https://openairdocs.org/ntsb/LAX79FA047.md): Cessna 172M · Gorman, CA · Accident · 2 fatal · Closed · Apr 26, 1979 · N61882 · Substantial damage
- [NTSB IAD79FA047](https://openairdocs.org/ntsb/IAD79FA047.md): Cessna 182J · Hillsboro, VA · Accident · 2 fatal · Closed · Apr 26, 1979 · N2738F · Destroyed
- [NTSB FTW79FA070](https://openairdocs.org/ntsb/FTW79FA070.md): Aerospatile SA365C · Sabine Pass, TX · Accident · Serious injuries · Closed · Apr 26, 1979 · N90049 · Substantial damage
- [NTSB FTW79DQG36](https://openairdocs.org/ntsb/FTW79DQG36.md): Cessna 188 · Higgins, TX · Accident · No injuries · Closed · Apr 26, 1979 · XB-AVA · Substantial damage
- [NTSB OAK79FA027](https://openairdocs.org/ntsb/OAK79FA027.md): Piper PA-22 · King City, CA · Accident · Minor injuries · Closed · Apr 25, 1979 · N7318D · Substantial damage
- [NTSB FTW79FRD24](https://openairdocs.org/ntsb/FTW79FRD24.md): Cessna 180J · Harvey, LA · Accident · Minor injuries · Closed · Apr 25, 1979 · N42322 · Substantial damage
- [NTSB CHI79FEI20](https://openairdocs.org/ntsb/CHI79FEI20.md): Cessna 170A · Newton Falls, OH · Accident · No injuries · Closed · Apr 25, 1979 · N4051V · Substantial damage
- [NTSB CHI79FEE53](https://openairdocs.org/ntsb/CHI79FEE53.md): Piper PA-28 · Cherry, IL · Accident · No injuries · Closed · Apr 25, 1979 · N5KS · Substantial damage
- [NTSB LAX79DUM13](https://openairdocs.org/ntsb/LAX79DUM13.md): Bell 47G-2A · Fallbrook, CA · Accident · No injuries · Closed · Apr 24, 1979 · N73872 · Substantial damage
- [NTSB MIA79DLG21](https://openairdocs.org/ntsb/MIA79DLG21.md): Cessna 152 · Williamton, SC · Accident · No injuries · Closed · Apr 23, 1979 · N25833 · Substantial damage
- [NTSB FTW79DRG30](https://openairdocs.org/ntsb/FTW79DRG30.md): Piper PA-32R · Sarita, TX · Accident · No injuries · Closed · Apr 23, 1979 · N32670 · Substantial damage
- [NTSB LAX79FUJ64](https://openairdocs.org/ntsb/LAX79FUJ64.md): Cessna 150 · Willcox, AZ · Accident · No injuries · Closed · Apr 22, 1979 · N8204F · Substantial damage
- [NTSB NYC79DA043](https://openairdocs.org/ntsb/NYC79DA043.md): Boeing 707 · Panama City, St. Pierre & Miquelon · Accident · Serious injuries · Closed · Apr 21, 1979 · N453PA · No damage
- [NTSB SEA79DTI13](https://openairdocs.org/ntsb/SEA79DTI13.md): Piper PA-24 · Sula, MT · Accident · Serious injuries · Closed · Apr 20, 1979 · N8372P · Destroyed
- [NTSB MKC79FCD16](https://openairdocs.org/ntsb/MKC79FCD16.md): Mooney M20E · Cresco, IA · Accident · Minor injuries · Closed · Apr 20, 1979 · N7115U · Substantial damage
- [NTSB LAX79DVA29](https://openairdocs.org/ntsb/LAX79DVA29.md): Piper PA-28 · Avenal, CA · Accident · Minor injuries · Closed · Apr 20, 1979 · N9434W · Destroyed
- [NTSB FTW79FA073](https://openairdocs.org/ntsb/FTW79FA073.md): Lockheed 18 · Brownsville, TX · Accident · No injuries · Closed · Apr 20, 1979 · N711BR · Substantial damage
- [NTSB DEN79DTC11](https://openairdocs.org/ntsb/DEN79DTC11.md): Piper PA-18A · Casper, WY · Accident · No injuries · Closed · Apr 20, 1979 · N8081C · Substantial damage
- [NTSB SEA79FA031](https://openairdocs.org/ntsb/SEA79FA031.md): Bell 214B-1 · Darby, MT · Accident · 2 fatal · Closed · Apr 19, 1979 · N226RM · Destroyed
- [NTSB ANC79DA046](https://openairdocs.org/ntsb/ANC79DA046.md): Cessna 180F · Sheep Bay, AK · Incident · No injuries · Closed · Apr 19, 1979 · N2690Y · 2 aircraft · Minor damage
- [NTSB NYC79FFA17](https://openairdocs.org/ntsb/NYC79FFA17.md): Grum Amer AA-1C · Oriskany, NY · Accident · No injuries · Closed · Apr 18, 1979 · N39006 · Substantial damage
- [NTSB NYC79FA039](https://openairdocs.org/ntsb/NYC79FA039.md): Cessna 152 · Stormville, NY · Accident · 2 fatal · Closed · Apr 18, 1979 · N67451 · Substantial damage
- [NTSB MIA79FA073](https://openairdocs.org/ntsb/MIA79FA073.md): Piper PA-30 · Rich, MS · Accident · 1 fatal · Closed · Apr 18, 1979 · N8758Y · Destroyed
- [NTSB DCA79FA014](https://openairdocs.org/ntsb/DCA79FA014.md): Sikorsky S61-L · Newark, NJ · Accident · 3 fatal · Closed · Apr 18, 1979 · N618PA · Substantial damage
- [NTSB CHI79FA045](https://openairdocs.org/ntsb/CHI79FA045.md): Piper PA-28 · Veedersburg, IN · Accident · 2 fatal · Closed · Apr 17, 1979 · N1895T · 2 aircraft · Destroyed
- [NTSB MIA79FKT61](https://openairdocs.org/ntsb/MIA79FKT61.md): Convair 340 · Key West, FL · Accident · No injuries · Closed · Apr 16, 1979 · N94480 · Substantial damage
- [NTSB FTW79DPA14](https://openairdocs.org/ntsb/FTW79DPA14.md): Cessna 177 · Blue Ridge, TX · Accident · No injuries · Closed · Apr 16, 1979 · N3496T · Substantial damage
- [NTSB MIA79FA071](https://openairdocs.org/ntsb/MIA79FA071.md): Beech 58 · Boca Ration, FL · Accident · 2 fatal · Closed · Apr 15, 1979 · N20SB · Destroyed
- [NTSB LAX79FA044](https://openairdocs.org/ntsb/LAX79FA044.md): Cessna 170B · Big Bear City, CA · Accident · 3 fatal · Closed · Apr 15, 1979 · N1409C · Destroyed
- [NTSB IAD79DLJ09](https://openairdocs.org/ntsb/IAD79DLJ09.md): Cessna 150 · Roseboro, NC · Accident · Minor injuries · Closed · Apr 15, 1979 · N45096 · Destroyed
- [NTSB OAK79DVA26](https://openairdocs.org/ntsb/OAK79DVA26.md): Ryan ST3KR · Fresno, CA · Accident · No injuries · Closed · Apr 14, 1979 · N56209 · Substantial damage
- [NTSB LAX79DVA25](https://openairdocs.org/ntsb/LAX79DVA25.md): Beech H35 · Porterville, CA · Accident · No injuries · Closed · Apr 14, 1979 · N202BC · Substantial damage
- [NTSB LAX79DUG30](https://openairdocs.org/ntsb/LAX79DUG30.md): Barnett J-4 · Adelanto, CA · Accident · 1 fatal · Closed · Apr 14, 1979 · N68093 · Destroyed
- [NTSB FTW79FQG30](https://openairdocs.org/ntsb/FTW79FQG30.md): Navion A · Sweetwater, TX · Accident · No injuries · Closed · Apr 13, 1979 · N8534H · Substantial damage
- [NTSB CHI79FEP43](https://openairdocs.org/ntsb/CHI79FEP43.md): Piper PA-32R · Iola, WI · Accident · No injuries · Closed · Apr 13, 1979 · N9585C · Substantial damage
- [NTSB CHI79FA044](https://openairdocs.org/ntsb/CHI79FA044.md): Cessna 150J · Waverly, OH · Accident · 3 fatal · Closed · Apr 13, 1979 · N60759 · Destroyed
- [NTSB DEN79FA036](https://openairdocs.org/ntsb/DEN79FA036.md): Piper PA-32 · Carrizozo, NM · Accident · 3 fatal · Closed · Apr 12, 1979 · N6309C · Destroyed
- [NTSB IAD79IA044](https://openairdocs.org/ntsb/IAD79IA044.md): Fairchild PC-6C · Raeford, NC · Incident · No injuries · Closed · Apr 11, 1979 · N361F · Minor damage
- [NTSB IAD79FIG05](https://openairdocs.org/ntsb/IAD79FIG05.md): Lake LA4200 · Dayton, MD · Accident · No injuries · Closed · Apr 11, 1979 · N6158Y · Substantial damage

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

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

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