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

## Cases, newest first

- [NTSB CHI79DEM24](https://openairdocs.org/ntsb/CHI79DEM24.md): Cessna 150M · St. Charles, MI · Accident · No injuries · Closed · Jun 28, 1979 · N66688 · Substantial damage
- [NTSB NYC79FGM30](https://openairdocs.org/ntsb/NYC79FGM30.md): Cessna 150 · Kittanning, PA · Accident · No injuries · Closed · Jun 27, 1979 · N18077 · Substantial damage
- [NTSB MKC79FTG08](https://openairdocs.org/ntsb/MKC79FTG08.md): Cessna 150M · Mercer, ND · Accident · No injuries · Closed · Jun 27, 1979 · N45232 · Substantial damage
- [NTSB MKC79FER50](https://openairdocs.org/ntsb/MKC79FER50.md): Piper PA-25 · Hutchinson, MN · Accident · No injuries · Closed · Jun 27, 1979 · N7634 · Substantial damage
- [NTSB MKC79DCQ36](https://openairdocs.org/ntsb/MKC79DCQ36.md): Cessna 152 · Arkansas City, KS · Accident · Serious injuries · Closed · Jun 27, 1979 · N89142 · Destroyed
- [NTSB ANC79FA063](https://openairdocs.org/ntsb/ANC79FA063.md): Beech B19 · Anchorage, AK · Accident · 2 fatal · Closed · Jun 27, 1979 · N24042 · Destroyed
- [NTSB SEA79FYP30](https://openairdocs.org/ntsb/SEA79FYP30.md): Cessna 152 · Malaga, WA · Accident · Minor injuries · Closed · Jun 26, 1979 · N757JM · Substantial damage
- [NTSB MKC79FCG51](https://openairdocs.org/ntsb/MKC79FCG51.md): Mooney M20A · Hillsdale, KS · Accident · No injuries · Closed · Jun 26, 1979 · N6072X · Substantial damage
- [NTSB LAX79DUJ87](https://openairdocs.org/ntsb/LAX79DUJ87.md): Cessna T210 · Kingman, AZ · Accident · No injuries · Closed · Jun 26, 1979 · N2431K · Substantial damage
- [NTSB DEN79FA047](https://openairdocs.org/ntsb/DEN79FA047.md): Lockheed PV-2 · Humble City, NM · Accident · No injuries · Closed · Jun 26, 1979 · N7253C · Substantial damage
- [NTSB CHI79FEE66](https://openairdocs.org/ntsb/CHI79FEE66.md): Bowers DSA1 · Princeton, IL · Accident · Serious injuries · Closed · Jun 26, 1979 · N9228A · Substantial damage
- [NTSB SEA79FTI19](https://openairdocs.org/ntsb/SEA79FTI19.md): Bell 47G3B1 · Emigrant, MT · Accident · No injuries · Closed · Jun 25, 1979 · N3078G · Substantial damage
- [NTSB NYC79FNE18](https://openairdocs.org/ntsb/NYC79FNE18.md): Bell 47D-1 · Ridgefield, CT · Accident · No injuries · Closed · Jun 24, 1979 · N4250A · Substantial damage
- [NTSB MKC79FCQ33](https://openairdocs.org/ntsb/MKC79FCQ33.md): Rockwell S2R · Hoxie, KS · Accident · No injuries · Closed · Jun 24, 1979 · N5008X · Substantial damage
- [NTSB MIA79FKQ13](https://openairdocs.org/ntsb/MIA79FKQ13.md): Cessna 170A · Raymond, MS · Accident · Serious injuries · Closed · Jun 24, 1979 · N5420C · Substantial damage
- [NTSB MIA79FKG51](https://openairdocs.org/ntsb/MIA79FKG51.md): Piper PA-23 · Griffin, GA · Accident · No injuries · Closed · Jun 24, 1979 · N4406P · Substantial damage
- [NTSB DEN79FTE52](https://openairdocs.org/ntsb/DEN79FTE52.md): Cessna 172 · Lindon, CO · Accident · Minor injuries · Closed · Jun 24, 1979 · N3920Q · Destroyed
- [NTSB DEN79FA046](https://openairdocs.org/ntsb/DEN79FA046.md): Bell 206B · Gobernador, NM · Accident · No injuries · Closed · Jun 24, 1979 · N16810 · Substantial damage
- [NTSB CHI79FEI30](https://openairdocs.org/ntsb/CHI79FEI30.md): Cessna 210J · Bucyrus, OH · Accident · Minor injuries · Closed · Jun 24, 1979 · N777AM · Substantial damage
- [NTSB MKC79FCA19](https://openairdocs.org/ntsb/MKC79FCA19.md): Davis DA2B · Bowling Green, MO · Accident · 2 fatal · Closed · Jun 23, 1979 · N74FJ · Destroyed
- [NTSB FTW79FA089](https://openairdocs.org/ntsb/FTW79FA089.md): Beech V35B · Pampa, TX · Accident · 2 fatal · Closed · Jun 23, 1979 · N2028P · Destroyed
- [NTSB MKC79FA037](https://openairdocs.org/ntsb/MKC79FA037.md): Cessna 182Q · Dawson, ND · Accident · 1 fatal · Closed · Jun 22, 1979 · N456LH · Destroyed
- [NTSB IAD79DIJ08](https://openairdocs.org/ntsb/IAD79DIJ08.md): Piper PA-28R · Clinchport, VA · Accident · No injuries · Closed · Jun 22, 1979 · N41855 · Substantial damage
- [NTSB LAX791A068](https://openairdocs.org/ntsb/LAX791A068.md): Lockheed L-1011 · Hutchinson, KS · Incident · No injuries · Closed · Jun 21, 1979 · N11001 · Minor damage
- [NTSB NYC79FNE17](https://openairdocs.org/ntsb/NYC79FNE17.md): Cessna 152 · Bristol, CT · Accident · Minor injuries · Closed · Jun 20, 1979 · N49009 · Substantial damage
- [NTSB MIA79FLA32](https://openairdocs.org/ntsb/MIA79FLA32.md): Bellanca 7GCBC · Daytona Beach, FL · Accident · Serious injuries · Closed · Jun 19, 1979 · N57498 · Destroyed
- [NTSB FTW79DPG55](https://openairdocs.org/ntsb/FTW79DPG55.md): Bell 47G-2 · Earle, AR · Accident · No injuries · Closed · Jun 19, 1979 · N3550 · Substantial damage
- [NTSB SEA79FYM41](https://openairdocs.org/ntsb/SEA79FYM41.md): Cessna 182 · Wilsonville, OR · Accident · No injuries · Closed · Jun 18, 1979 · N4952D · Substantial damage
- [NTSB LAX79FA043](https://openairdocs.org/ntsb/LAX79FA043.md): Beech A-36 · Needles, CA · Accident · Serious injuries · Closed · Jun 18, 1979 · N821V · Substantial damage
- [NTSB DEN79FTE47](https://openairdocs.org/ntsb/DEN79FTE47.md): Cessna T188C · Center, CO · Accident · Serious injuries · Closed · Jun 18, 1979 · N2167J · Substantial damage
- [NTSB FTW79FPG54](https://openairdocs.org/ntsb/FTW79FPG54.md): Aeronca 11AC · Mountain Home, AR · Accident · Serious injuries · Closed · Jun 17, 1979 · N31959 · Destroyed
- [NTSB DEN79FA044](https://openairdocs.org/ntsb/DEN79FA044.md): Cessna U206 · Milford, UT · Accident · No injuries · Closed · Jun 17, 1979 · N4424Q · Destroyed
- [NTSB LAX79FUG47](https://openairdocs.org/ntsb/LAX79FUG47.md): Piper PA-28 · Big Bear, CA · Accident · No injuries · Closed · Jun 16, 1979 · N1115X · Destroyed
- [NTSB FTW79DPD24](https://openairdocs.org/ntsb/FTW79DPD24.md): Cessna 337D · Graham, TX · Accident · No injuries · Closed · Jun 16, 1979 · N86395 · Substantial damage
- [NTSB NYC79FHM21](https://openairdocs.org/ntsb/NYC79FHM21.md): Cessna 172M · Marlboro, NJ · Accident · Serious injuries · Closed · Jun 15, 1979 · N20325 · Substantial damage
- [NTSB IAD79FID20](https://openairdocs.org/ntsb/IAD79FID20.md): Beech 58 · Keysville, VA · Accident · No injuries · Closed · Jun 15, 1979 · N2018T · Substantial damage
- [NTSB CHI79FEI28](https://openairdocs.org/ntsb/CHI79FEI28.md): Cessna 182P · Brookpark, OH · Accident · No injuries · Closed · Jun 15, 1979 · N1977M · Substantial damage
- [NTSB MKC79FCQ29](https://openairdocs.org/ntsb/MKC79FCQ29.md): Piper PA-25 · Atwood, KS · Accident · Serious injuries · Closed · Jun 14, 1979 · N6045Z · Substantial damage
- [NTSB MKC79FCJ23](https://openairdocs.org/ntsb/MKC79FCJ23.md): Beech H35 · Wilcox, NE · Accident · Serious injuries · Closed · Jun 14, 1979 · N5426D · Destroyed
- [NTSB FTW79DQD11](https://openairdocs.org/ntsb/FTW79DQD11.md): Piper PA-32 · Kent, TX · Accident · No injuries · Closed · Jun 14, 1979 · N36367 · Substantial damage
- [NTSB MIA79FAQ96](https://openairdocs.org/ntsb/MIA79FAQ96.md): Beech 65 · Preston, GA · Accident · 1 fatal · Closed · Jun 13, 1979 · N111WP · Destroyed
- [NTSB LAX79DUG46](https://openairdocs.org/ntsb/LAX79DUG46.md): Cessna 177RG · Needles, CA · Accident · Minor injuries · Closed · Jun 13, 1979 · N33260 · Substantial damage
- [NTSB IAD79DKM16](https://openairdocs.org/ntsb/IAD79DKM16.md): Cessna 150 · Shelby, NC · Accident · Minor injuries · Closed · Jun 12, 1979 · N66031 · Substantial damage
- [NTSB DEN79FTE44](https://openairdocs.org/ntsb/DEN79FTE44.md): Hughes 269C · Eckley, CO · Accident · Minor injuries · Closed · Jun 12, 1979 · N7472F · Substantial damage
- [NTSB DEN79DTE43](https://openairdocs.org/ntsb/DEN79DTE43.md): Piper PA-25 · Eads, CO · Accident · No injuries · Closed · Jun 12, 1979 · N6496Z · Substantial damage
- [NTSB SEA79FYA16](https://openairdocs.org/ntsb/SEA79FYA16.md): Cessna T210L · Hailey, ID · Accident · Serious injuries · Closed · Jun 11, 1979 · N5102Q · Substantial damage
- [NTSB FTW79FQG43](https://openairdocs.org/ntsb/FTW79FQG43.md): Beech 65-88 · Seminole, TX · Accident · No injuries · Closed · Jun 11, 1979 · N707ED · Destroyed
- [NTSB ANC79FA060](https://openairdocs.org/ntsb/ANC79FA060.md): Cessna 207 · Platinum, AK · Accident · No injuries · Closed · Jun 11, 1979 · N6255H · Substantial damage
- [NTSB SEA79DYA14](https://openairdocs.org/ntsb/SEA79DYA14.md): Cessna 150 · Salmon, ID · Accident · Minor injuries · Closed · Jun 10, 1979 · N2269J · Destroyed
- [NTSB MIA79DLA30](https://openairdocs.org/ntsb/MIA79DLA30.md): Cessna 150 · Mayday, GA · Accident · Minor injuries · Closed · Jun 10, 1979 · N6577F · Substantial damage

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

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

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