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

## Cases, newest first

- [NTSB MIA80FKJ21](https://openairdocs.org/ntsb/MIA80FKJ21.md): Cessna 152 · Montgomery, AL · Accident · No injuries · Closed · Feb 23, 1980 · N24210 · Substantial damage
- [NTSB IAD80DLQ13](https://openairdocs.org/ntsb/IAD80DLQ13.md): Cessna 177 · Albany, KY · Accident · Serious injuries · Closed · Feb 23, 1980 · N3491T · Destroyed
- [NTSB LAX80FA057](https://openairdocs.org/ntsb/LAX80FA057.md): Cessna T337G · Reno, NV · Accident · 1 fatal · Closed · Feb 22, 1980 · N1ZQ · Destroyed
- [NTSB SEA80FYM17](https://openairdocs.org/ntsb/SEA80FYM17.md): Hughes 369HS · Siletz, OR · Accident · No injuries · Closed · Feb 21, 1980 · N9219F · Substantial damage
- [NTSB MKC80FA024](https://openairdocs.org/ntsb/MKC80FA024.md): Grum-Amer AA-5B · Spencer, IA · Accident · 2 fatal · Closed · Feb 21, 1980 · N74028 · Destroyed
- [NTSB LAX80DVA14](https://openairdocs.org/ntsb/LAX80DVA14.md): Grumman G-164B · Ceres, CA · Accident · No injuries · Closed · Feb 21, 1980 · N6659Q · Substantial damage
- [NTSB IAD80FA026](https://openairdocs.org/ntsb/IAD80FA026.md): Beech 95-B55 · Cumming, GA · Accident · 2 fatal · Closed · Feb 19, 1980 · N88LR · Destroyed
- [NTSB FTW80FPG13](https://openairdocs.org/ntsb/FTW80FPG13.md): Cessna 150M · Burlington, AR · Accident · Serious injuries · Closed · Feb 19, 1980 · N714KJ · Destroyed
- [NTSB MIA80FKJ20](https://openairdocs.org/ntsb/MIA80FKJ20.md): Cessna 150 · North Johns, AL · Accident · No injuries · Closed · Feb 18, 1980 · N3956J · Substantial damage
- [NTSB MIA80FKG18](https://openairdocs.org/ntsb/MIA80FKG18.md): Cessna 150 · Columbus, GA · Accident · No injuries · Closed · Feb 18, 1980 · N45384 · Destroyed
- [NTSB MIA80FA035](https://openairdocs.org/ntsb/MIA80FA035.md): Cessna 172RG · Palm Bay, FL · Accident · 1 fatal · Closed · Feb 18, 1980 · N6265R · Destroyed
- [NTSB IAD80FA024](https://openairdocs.org/ntsb/IAD80FA024.md): Piper PA-22 · Clear Spring, MD · Accident · 1 fatal · Closed · Feb 18, 1980 · N7596D · Destroyed
- [NTSB FTW80FRD16](https://openairdocs.org/ntsb/FTW80FRD16.md): Bell 212 · Houma, LA · Accident · No injuries · Closed · Feb 18, 1980 · N71AL · Substantial damage
- [NTSB ANC80DAG34](https://openairdocs.org/ntsb/ANC80DAG34.md): Cessna 172K · Iliamna, AK · Accident · No injuries · Closed · Feb 18, 1980 · N7381K · Substantial damage
- [NTSB MIA80FLD39](https://openairdocs.org/ntsb/MIA80FLD39.md): Cessna 180E · Zephyrhills, FL · Accident · Serious injuries · Closed · Feb 16, 1980 · N8681X · Destroyed
- [NTSB LAX80FA121](https://openairdocs.org/ntsb/LAX80FA121.md): Mooney M20K · Bishop, CA · Accident · 1 fatal · Closed · Feb 16, 1980 · N231EY · Destroyed
- [NTSB LAX80FA053](https://openairdocs.org/ntsb/LAX80FA053.md): Piper PA-28 · Redding, CA · Accident · 3 fatal · Closed · Feb 16, 1980 · N8081H · Destroyed
- [NTSB IAD80FLJ07](https://openairdocs.org/ntsb/IAD80FLJ07.md): Piper PA-28 · Raleigh, NC · Accident · Serious injuries · Closed · Feb 16, 1980 · N56810 · Substantial damage
- [NTSB DEN80FTC07](https://openairdocs.org/ntsb/DEN80FTC07.md): Cessna 152 · Lander, WY · Accident · No injuries · Closed · Feb 16, 1980 · N24272 · Substantial damage
- [NTSB ANC80FAA06](https://openairdocs.org/ntsb/ANC80FAA06.md): Cessna 150M · Eielson Afb, AK · Accident · No injuries · Closed · Feb 16, 1980 · N704YU · Substantial damage
- [NTSB LAX80FVM15](https://openairdocs.org/ntsb/LAX80FVM15.md): Cessna 182 · Salinas, CA · Accident · No injuries · Closed · Feb 15, 1980 · N2633G · Substantial damage
- [NTSB LAX80FJA11](https://openairdocs.org/ntsb/LAX80FJA11.md): Cessna 172E · Lanai City, HI · Accident · 2 fatal · Closed · Feb 15, 1980 · N9982Q · Destroyed
- [NTSB FTW80DRG27](https://openairdocs.org/ntsb/FTW80DRG27.md): Beech 23 · Llano, TX · Accident · No injuries · Closed · Feb 15, 1980 · N60003 · Substantial damage
- [NTSB FTW80FPM07](https://openairdocs.org/ntsb/FTW80FPM07.md): Bensen Gyro · Quapaw, OK · Accident · Serious injuries · Closed · Feb 14, 1980 · NONE · Destroyed
- [NTSB FTW80FA047](https://openairdocs.org/ntsb/FTW80FA047.md): Beech 35 · Barksdale, TX · Accident · 2 fatal · Closed · Feb 14, 1980 · N621T · Destroyed
- [NTSB ANC80DAA07](https://openairdocs.org/ntsb/ANC80DAA07.md): Piper J-3 · Ruby, AK · Accident · No injuries · Closed · Feb 14, 1980 · N78507 · Substantial damage
- [NTSB LAX80FA050](https://openairdocs.org/ntsb/LAX80FA050.md): Piper PA-34 · Reno, NV · Accident · 2 fatal · Closed · Feb 12, 1980 · N2858X · Destroyed
- [NTSB CHI80FEV14](https://openairdocs.org/ntsb/CHI80FEV14.md): Piper PA-28R · Sherman, IL · Accident · No injuries · Closed · Feb 12, 1980 · N4620J · Substantial damage
- [NTSB MIA80FKG17](https://openairdocs.org/ntsb/MIA80FKG17.md): Erco 415-C · Columbus, GA · Accident · No injuries · Closed · Feb 11, 1980 · N2599H · Substantial damage
- [NTSB NYC80FHM09](https://openairdocs.org/ntsb/NYC80FHM09.md): Cessna 152 · Picatny Arsenl, NJ · Accident · Serious injuries · Closed · Feb 10, 1980 · N24761 · Destroyed
- [NTSB SEA80FYK05](https://openairdocs.org/ntsb/SEA80FYK05.md): Piper PA-24 · Allegany, OR · Accident · Serious injuries · Closed · Feb 9, 1980 · N5628P · Substantial damage
- [NTSB FTW80FA040](https://openairdocs.org/ntsb/FTW80FA040.md): Bell 206B · Friendswood, TX · Accident · 1 fatal · Closed · Feb 9, 1980 · N14815 · 2 aircraft · Destroyed
- [NTSB NYC80FNE10](https://openairdocs.org/ntsb/NYC80FNE10.md): Cessna 150 · Waterford, CT · Accident · Minor injuries · Closed · Feb 8, 1980 · N61085 · Substantial damage
- [NTSB NYC80FGT05](https://openairdocs.org/ntsb/NYC80FGT05.md): Cessna 175 · East Berlin, PA · Accident · No injuries · Closed · Feb 8, 1980 · N6585E · Substantial damage
- [NTSB NYC80FFJ03](https://openairdocs.org/ntsb/NYC80FFJ03.md): Beech V35A · Portville, NY · Accident · No injuries · Closed · Feb 8, 1980 · N44CM · Substantial damage
- [NTSB LAX80FA048](https://openairdocs.org/ntsb/LAX80FA048.md): Piper PA-28 · El Segundo, CA · Accident · 3 fatal · Closed · Feb 8, 1980 · N44126 · 2 aircraft · Destroyed
- [NTSB LAX80DA047](https://openairdocs.org/ntsb/LAX80DA047.md): Nord-Avion 262 · Saugus, CA · Accident · Serious injuries · Closed · Feb 8, 1980 · N420SA · No damage
- [NTSB SEA80DYE12](https://openairdocs.org/ntsb/SEA80DYE12.md): Piper PA-28 · Yelm, WA · Accident · Minor injuries · Closed · Feb 7, 1980 · N47576 · Destroyed
- [NTSB LAX80FA052](https://openairdocs.org/ntsb/LAX80FA052.md): Bell 47G3B1 · Alpine, AZ · Accident · 1 fatal · Closed · Feb 7, 1980 · N1327X · Destroyed
- [NTSB LAX80FA046](https://openairdocs.org/ntsb/LAX80FA046.md): Cessna T210M · Grapevine, CA · Accident · 1 fatal · Closed · Feb 7, 1980 · N761UW · Destroyed
- [NTSB IAD80FKM09](https://openairdocs.org/ntsb/IAD80FKM09.md): Cessna 150 · Troutman, NC · Accident · Serious injuries · Closed · Feb 7, 1980 · N5888G · Substantial damage
- [NTSB NYC80FHM08](https://openairdocs.org/ntsb/NYC80FHM08.md): Cessna 152 · Linden, NJ · Accident · Serious injuries · Closed · Feb 6, 1980 · N49568 · Substantial damage
- [NTSB DEN80FA024](https://openairdocs.org/ntsb/DEN80FA024.md): Mooney M20C · Scipio, UT · Accident · 1 fatal · Closed · Feb 6, 1980 · N6489U · Destroyed
- [NTSB DEN80AA023](https://openairdocs.org/ntsb/DEN80AA023.md): Cessna TU206G · Clovis, NM · Accident · 4 fatal · Closed · Feb 6, 1980 · N7393N · 2 aircraft · Destroyed
- [NTSB CHI80FEP17](https://openairdocs.org/ntsb/CHI80FEP17.md): Cessna 172 · Bruce, WI · Accident · Minor injuries · Closed · Feb 6, 1980 · N1167V · Substantial damage
- [NTSB LAX80DVD10](https://openairdocs.org/ntsb/LAX80DVD10.md): Ryan PT-22 · Oakland, CA · Accident · No injuries · Closed · Feb 5, 1980 · N54907 · Substantial damage
- [NTSB LAX80DUM10](https://openairdocs.org/ntsb/LAX80DUM10.md): Stinson 108-2 · Borrego Sprngs, CA · Accident · No injuries · Closed · Feb 5, 1980 · N9698K · Destroyed
- [NTSB LAX80FA045](https://openairdocs.org/ntsb/LAX80FA045.md): Aerostar 601P · San Jose, CA · Accident · 2 fatal · Closed · Feb 4, 1980 · N8078J · Destroyed
- [NTSB CHI80FEP15](https://openairdocs.org/ntsb/CHI80FEP15.md): Bellanca 17-30 · Darlington, WI · Accident · No injuries · Closed · Feb 3, 1980 · N7369V · Substantial damage
- [NTSB IAD80FKW08](https://openairdocs.org/ntsb/IAD80FKW08.md): Cessna 172 · Tn Ridge, TN · Accident · Serious injuries · Closed · Feb 2, 1980 · N6248E · Substantial damage

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

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

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