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

## Cases, newest first

- [NTSB IAD80FIA01](https://openairdocs.org/ntsb/IAD80FIA01.md): Boeing E75 · Bealton, VA · Accident · No injuries · Closed · Oct 28, 1979 · N47964 · Substantial damage
- [NTSB FTW80FRG05](https://openairdocs.org/ntsb/FTW80FRG05.md): Luscombe 8A · Fredericksburg, TX · Accident · Serious injuries · Closed · Oct 28, 1979 · N1209K · Destroyed
- [NTSB CHI80FET02](https://openairdocs.org/ntsb/CHI80FET02.md): Cessna 172N · Munster, IN · Accident · Minor injuries · Closed · Oct 28, 1979 · N738FU · Substantial damage
- [NTSB ANC80DAG09](https://openairdocs.org/ntsb/ANC80DAG09.md): Cessna 185 · Anchorage, AK · Accident · Minor injuries · Closed · Oct 28, 1979 · N94178 · Destroyed
- [NTSB MIA80DKT09](https://openairdocs.org/ntsb/MIA80DKT09.md): Cessna 152 · Highland Beach, FL · Accident · Minor injuries · Closed · Oct 27, 1979 · N89705 · Substantial damage
- [NTSB LAX80FUG05](https://openairdocs.org/ntsb/LAX80FUG05.md): Bellanca 14-19 · Corona, CA · Accident · Minor injuries · Closed · Oct 27, 1979 · N8807R · Substantial damage
- [NTSB MIA80DLA06](https://openairdocs.org/ntsb/MIA80DLA06.md): Bellanca 7GCAA · Archer, FL · Accident · Minor injuries · Closed · Oct 26, 1979 · N2515Z · Destroyed
- [NTSB NYC80FA006](https://openairdocs.org/ntsb/NYC80FA006.md): Piper PA-28 · Gilead, ME · Accident · 1 fatal · Closed · Oct 25, 1979 · N407FL · Substantial damage
- [NTSB IAD80FKW01](https://openairdocs.org/ntsb/IAD80FKW01.md): Cessna 150 · Collegedale, TN · Accident · No injuries · Closed · Oct 25, 1979 · N714BM · Substantial damage
- [NTSB ANC80FA007](https://openairdocs.org/ntsb/ANC80FA007.md): Cessna 207 · Venetie, AK · Accident · 1 fatal · Closed · Oct 25, 1979 · N1684U · Substantial damage
- [NTSB NYC80FHM01](https://openairdocs.org/ntsb/NYC80FHM01.md): Cessna 152 · East Hanover, NJ · Accident · No injuries · Closed · Oct 23, 1979 · N65601 · Substantial damage
- [NTSB NYC80FHD04](https://openairdocs.org/ntsb/NYC80FHD04.md): Aerospatle SA341G · Philadelphia, PA · Accident · Minor injuries · Closed · Oct 23, 1979 · N119SF · Destroyed
- [NTSB MKC80DER06](https://openairdocs.org/ntsb/MKC80DER06.md): Piper PA-23 · Cold Springs, MN · Accident · No injuries · Closed · Oct 23, 1979 · N62818 · Substantial damage
- [NTSB LAX80DUJ06](https://openairdocs.org/ntsb/LAX80DUJ06.md): Hughes 369D · Phoenix, AZ · Accident · Minor injuries · Closed · Oct 23, 1979 · N8673F · Substantial damage
- [NTSB FTW80FA007](https://openairdocs.org/ntsb/FTW80FA007.md): Cessna 182 · Sonora, TX · Accident · 4 fatal · Closed · Oct 23, 1979 · N9018X · Destroyed
- [NTSB DEN80FA005](https://openairdocs.org/ntsb/DEN80FA005-201189.md): Soloy 47G · Ruidoso, NM · Accident · 1 fatal · Closed · Oct 23, 1979 · N7828S · Destroyed
- [NTSB CHI80FA007](https://openairdocs.org/ntsb/CHI80FA007.md): Cessna 310 · Bloomington, IN · Accident · 2 fatal · Closed · Oct 22, 1979 · N1320G · Destroyed
- [NTSB MIA80FLA04](https://openairdocs.org/ntsb/MIA80FLA04.md): Erco 415-C · Camila, GA · Accident · No injuries · Closed · Oct 21, 1979 · N99982 · Substantial damage
- [NTSB IAD80FIG01](https://openairdocs.org/ntsb/IAD80FIG01.md): Bushby Mini Mustng · Stevensville, MD · Accident · Serious injuries · Closed · Oct 21, 1979 · N3794 · Substantial damage
- [NTSB FTW80FRJ05](https://openairdocs.org/ntsb/FTW80FRJ05.md): Rearwin 9000KR · Jacksonville, TX · Accident · Minor injuries · Closed · Oct 21, 1979 · N21977 · Substantial damage
- [NTSB CHI80FEI03](https://openairdocs.org/ntsb/CHI80FEI03.md): Piper PA-28 · Mantua, OH · Accident · Minor injuries · Closed · Oct 21, 1979 · N5351W · Substantial damage
- [NTSB LAX80FA006](https://openairdocs.org/ntsb/LAX80FA006.md): Beech V35B · Lucerne Valley, CA · Accident · 2 fatal · Closed · Oct 20, 1979 · N6641S · Destroyed
- [NTSB LAX80DVW01](https://openairdocs.org/ntsb/LAX80DVW01.md): Piper PA-28R · Lone Pine, CA · Accident · No injuries · Closed · Oct 20, 1979 · N32470 · Substantial damage
- [NTSB IAD80DKM02](https://openairdocs.org/ntsb/IAD80DKM02.md): Piper PA-28 · Rockingham, NC · Accident · No injuries · Closed · Oct 20, 1979 · N40925 · Substantial damage
- [NTSB DEN80DTM04](https://openairdocs.org/ntsb/DEN80DTM04.md): Beech 19 · Cedar City, UT · Accident · No injuries · Closed · Oct 20, 1979 · N2166W · Substantial damage
- [NTSB NYC80FNA02](https://openairdocs.org/ntsb/NYC80FNA02.md): Cessna 150H · Norton, MA · Accident · No injuries · Closed · Oct 19, 1979 · N7001S · Substantial damage
- [NTSB NYC80FHM02](https://openairdocs.org/ntsb/NYC80FHM02.md): Cessna 172 · E.Fishkill, NY · Accident · Serious injuries · Closed · Oct 19, 1979 · N7WP · Substantial damage
- [NTSB LAX80FUM03](https://openairdocs.org/ntsb/LAX80FUM03.md): Cessna T210F · El Cajon, CA · Accident · Serious injuries · Closed · Oct 19, 1979 · N6124R · Destroyed
- [NTSB LAX79FJA17](https://openairdocs.org/ntsb/LAX79FJA17.md): Bell 47D1 · Pearl City, HI · Accident · No injuries · Closed · Oct 19, 1979 · N234B · Substantial damage
- [NTSB IAD80FLQ04](https://openairdocs.org/ntsb/IAD80FLQ04.md): Beech H18S · Covington, KY · Accident · No injuries · Closed · Oct 19, 1979 · N24K · Substantial damage
- [NTSB DEN80FA004](https://openairdocs.org/ntsb/DEN80FA004.md): Rockwell 114 · Hanksville, UT · Accident · 2 fatal · Closed · Oct 19, 1979 · N4873W · Substantial damage
- [NTSB SEA80FA004](https://openairdocs.org/ntsb/SEA80FA004.md): Cessna 177RG · Ephrata, WA · Accident · 2 fatal · Closed · Oct 18, 1979 · N34948 · Destroyed
- [NTSB FTW80DA005](https://openairdocs.org/ntsb/FTW80DA005.md): Cessna 182 · Tyler, TX · Accident · No injuries · Closed · Oct 18, 1979 · N4697K · Substantial damage
- [NTSB CHI80FEM06](https://openairdocs.org/ntsb/CHI80FEM06.md): Cessna 402A · Lansing, MI · Accident · No injuries · Closed · Oct 17, 1979 · N7809Q · Substantial damage
- [NTSB NYC80DNC03](https://openairdocs.org/ntsb/NYC80DNC03.md): Piper PA-28 · Newport, VT · Accident · No injuries · Closed · Oct 15, 1979 · CGQXR · Substantial damage
- [NTSB CHI80FEP02](https://openairdocs.org/ntsb/CHI80FEP02.md): Beech 56TC · Middleton, WI · Accident · Minor injuries · Closed · Oct 15, 1979 · N7115N · Substantial damage
- [NTSB CHI80DA004](https://openairdocs.org/ntsb/CHI80DA004.md): Cessna A150L · Spring Valley, IL · Accident · 1 fatal · Closed · Oct 15, 1979 · N5936J · Destroyed
- [NTSB NYC80FFA02](https://openairdocs.org/ntsb/NYC80FFA02.md): Cessna 185 · Booneville, NY · Accident · No injuries · Closed · Oct 14, 1979 · N1678R · Substantial damage
- [NTSB LAX80FA004](https://openairdocs.org/ntsb/LAX80FA004.md): Piper PA-32 · Ontario, CA · Accident · 4 fatal · Closed · Oct 14, 1979 · N331JB · Destroyed
- [NTSB LAX80DVG01](https://openairdocs.org/ntsb/LAX80DVG01.md): Cessna 182 · San Andreas, CA · Accident · No injuries · Closed · Oct 14, 1979 · N6415F · Substantial damage
- [NTSB NYC80FHM03](https://openairdocs.org/ntsb/NYC80FHM03.md): Piper PA-28 · Morganville, NJ · Accident · Serious injuries · Closed · Oct 13, 1979 · N6692J · Substantial damage
- [NTSB MIA80FKG04](https://openairdocs.org/ntsb/MIA80FKG04.md): Cessna 152 · Athens, GA · Accident · No injuries · Closed · Oct 13, 1979 · N25889 · Substantial damage
- [NTSB LAX80FA007](https://openairdocs.org/ntsb/LAX80FA007.md): Cessna 152 · Ojai, CA · Accident · 2 fatal · Closed · Oct 13, 1979 · N49216 · Destroyed
- [NTSB IAD80FLT01](https://openairdocs.org/ntsb/IAD80FLT01.md): Bayles Spec 1 · Jackson, TN · Accident · 2 fatal · Closed · Oct 13, 1979 · N8237E · Destroyed
- [NTSB IAD80FLQ01](https://openairdocs.org/ntsb/IAD80FLQ01.md): Beech A-35 · Grayson, KY · Accident · Minor injuries · Closed · Oct 13, 1979 · N786B · Substantial damage
- [NTSB IAD80DLQ03](https://openairdocs.org/ntsb/IAD80DLQ03.md): Cessna 152 · Bowling Green, KY · Accident · No injuries · Closed · Oct 13, 1979 · N47109 · Substantial damage
- [NTSB SEA80DYK01](https://openairdocs.org/ntsb/SEA80DYK01.md): Cessna TU206 · Klamath Falls, OR · Accident · No injuries · Closed · Oct 12, 1979 · N1204Q · Substantial damage
- [NTSB IAD80DHD01](https://openairdocs.org/ntsb/IAD80DHD01.md): Cessna 150 · Middletown, DE · Accident · No injuries · Closed · Oct 12, 1979 · N11820 · Substantial damage
- [NTSB FTW80FRG03](https://openairdocs.org/ntsb/FTW80FRG03.md): Piper PA-28 · San Marcos, TX · Accident · No injuries · Closed · Oct 12, 1979 · N5993W · Substantial damage
- [NTSB FTW80FRA02](https://openairdocs.org/ntsb/FTW80FRA02.md): Grum-Amer AA-5A · Cold Spring, TX · Accident · No injuries · Closed · Oct 12, 1979 · N9983U · Substantial damage

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

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

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