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

## Cases, newest first

- [NTSB LAX80FUG25](https://openairdocs.org/ntsb/LAX80FUG25.md): Cessna 172N · Chino, CA · Accident · Serious injuries · Closed · Mar 16, 1980 · N733CW · Destroyed
- [NTSB MIA80FKJ26](https://openairdocs.org/ntsb/MIA80FKJ26.md): Benson B8MD · Pensacola, FL · Accident · 1 fatal · Closed · Mar 15, 1980 · N1743 · Substantial damage
- [NTSB ANC80IA036](https://openairdocs.org/ntsb/ANC80IA036.md): Cessna 207 · Russian Msn, AK · Incident · No injuries · Closed · Mar 15, 1980 · N1749U · Minor damage
- [NTSB MIA80FKQ03](https://openairdocs.org/ntsb/MIA80FKQ03.md): Grumman G-164A · Flora, MS · Accident · Minor injuries · Closed · Mar 14, 1980 · N48507 · Destroyed
- [NTSB LAX80FA065](https://openairdocs.org/ntsb/LAX80FA065.md): Cessna 414 · Vacaville, CA · Accident · 5 fatal · Closed · Mar 14, 1980 · N4632G · Destroyed
- [NTSB LAX80FA064](https://openairdocs.org/ntsb/LAX80FA064.md): Cessna 421B · Tucson, AZ · Accident · 2 fatal · Closed · Mar 14, 1980 · N59RZ · Destroyed
- [NTSB FTW80FRG30](https://openairdocs.org/ntsb/FTW80FRG30.md): Rand KR-2 · San Antonio, TX · Accident · Serious injuries · Closed · Mar 14, 1980 · N30ET · Destroyed
- [NTSB ANC80FA035](https://openairdocs.org/ntsb/ANC80FA035.md): Cessna A185F · Shaktoolik, AK · Accident · 4 fatal · Closed · Mar 14, 1980 · N93322 · Substantial damage
- [NTSB MKC80DA027](https://openairdocs.org/ntsb/MKC80DA027.md): Piper PA-31 · Utica, NE · Accident · No injuries · Closed · Mar 13, 1980 · N6493L · Substantial damage
- [NTSB LAX80FVA23](https://openairdocs.org/ntsb/LAX80FVA23.md): Piper PA-31T · Kettleman City, CA · Accident · Minor injuries · Closed · Mar 12, 1980 · N26CA · Substantial damage
- [NTSB FTW80FQD04](https://openairdocs.org/ntsb/FTW80FQD04.md): Piper PA-34 · El Paso, TX · Accident · Serious injuries · Closed · Mar 12, 1980 · N123AH · Substantial damage
- [NTSB FTW80FPJ11](https://openairdocs.org/ntsb/FTW80FPJ11.md): Bell 206L · El Reno, OK · Accident · No injuries · Closed · Mar 11, 1980 · N144MB · Substantial damage
- [NTSB FTW80FPG17](https://openairdocs.org/ntsb/FTW80FPG17.md): Aerostar 601B · Scranton, AR · Accident · No injuries · Closed · Mar 11, 1980 · N80GT · Substantial damage
- [NTSB FTW80DRD19](https://openairdocs.org/ntsb/FTW80DRD19.md): Bell 206B · Venice, LA · Accident · Minor injuries · Closed · Mar 11, 1980 · N16966 · Destroyed
- [NTSB NYC80FA027](https://openairdocs.org/ntsb/NYC80FA027.md): Mooney M20C · Ogdensburg, NJ · Accident · 1 fatal · Closed · Mar 10, 1980 · N7171V · Destroyed
- [NTSB ANC80DA034](https://openairdocs.org/ntsb/ANC80DA034.md): Cessna 206 · Dillingham, AK · Accident · Serious injuries · Closed · Mar 9, 1980 · N1297M · Substantial damage
- [NTSB NYC80FA025](https://openairdocs.org/ntsb/NYC80FA025.md): Swearingen SA226 · Glens Falls, NY · Accident · Minor injuries · Closed · Mar 8, 1980 · N720R · Substantial damage
- [NTSB FTW80FPJ10](https://openairdocs.org/ntsb/FTW80FPJ10.md): Piper PA-32 · Loyal, OK · Accident · No injuries · Closed · Mar 7, 1980 · N3223W · Substantial damage
- [NTSB CHI80FEM17](https://openairdocs.org/ntsb/CHI80FEM17.md): Cessna 150M · Traverse City, MI · Accident · No injuries · Closed · Mar 7, 1980 · N45181 · Substantial damage
- [NTSB MIA80FA044](https://openairdocs.org/ntsb/MIA80FA044.md): Mooney M20K · Blairsville, GA · Accident · 3 fatal · Closed · Mar 6, 1980 · N231GQ · Destroyed
- [NTSB MKC80FER27](https://openairdocs.org/ntsb/MKC80FER27.md): Cessna 152 · Euclid, MN · Accident · No injuries · Closed · Mar 4, 1980 · N68811 · Substantial damage
- [NTSB FTW80FA052](https://openairdocs.org/ntsb/FTW80FA052.md): Rockwell 112 · Witt Springs, AR · Accident · 1 fatal · Closed · Mar 4, 1980 · N1098J · Destroyed
- [NTSB CHI80FET11](https://openairdocs.org/ntsb/CHI80FET11.md): Cessna 210A · Gary, IN · Accident · No injuries · Closed · Mar 4, 1980 · N9420X · Substantial damage
- [NTSB ANC80DAG33](https://openairdocs.org/ntsb/ANC80DAG33.md): Cessna 180C · Kenai, AK · Accident · Serious injuries · Closed · Mar 4, 1980 · N9337T · Substantial damage
- [NTSB IAD80FA029](https://openairdocs.org/ntsb/IAD80FA029.md): Cessna 182K · Hartsville, TN · Accident · 1 fatal · Closed · Mar 3, 1980 · N48G · Destroyed
- [NTSB FTW80IA050](https://openairdocs.org/ntsb/FTW80IA050.md): Beech 65A90 · Bridgeport, TX · Incident · No injuries · Closed · Mar 3, 1980 · N30AA · Minor damage
- [NTSB FTW80FA051](https://openairdocs.org/ntsb/FTW80FA051.md): Cessna U206 · Arlington, TX · Accident · Minor injuries · Closed · Mar 3, 1980 · N50955 · Substantial damage
- [NTSB SEA80DYE21](https://openairdocs.org/ntsb/SEA80DYE21.md): Cessna 150 · Toledo, WA · Accident · Minor injuries · Closed · Mar 2, 1980 · N5742G · Destroyed
- [NTSB MIA80FA040](https://openairdocs.org/ntsb/MIA80FA040.md): Cessna 310D · Ft.Lauderdale, FL · Accident · 1 fatal · Closed · Mar 2, 1980 · CFHWT · Destroyed
- [NTSB LAX80FA060](https://openairdocs.org/ntsb/LAX80FA060.md): Douglas B-26C · Georgetown, CA · Accident · 4 fatal · Closed · Mar 2, 1980 · N4204A · Destroyed
- [NTSB LAX80DUG22](https://openairdocs.org/ntsb/LAX80DUG22.md): Ryan Navion · Wrightwood, CA · Accident · Minor injuries · Closed · Mar 2, 1980 · N4235K · Destroyed
- [NTSB DEN80FTE31](https://openairdocs.org/ntsb/DEN80FTE31.md): Beech 35-C33 · Almont, CO · Accident · Minor injuries · Closed · Mar 2, 1980 · N9033S · Substantial damage
- [NTSB MIA80FA039](https://openairdocs.org/ntsb/MIA80FA039.md): Bell 206B · Kissimmee, FL · Accident · 2 fatal · Closed · Feb 29, 1980 · N5015Y · Destroyed
- [NTSB LAX80FUD07](https://openairdocs.org/ntsb/LAX80FUD07.md): Cessna 150J · Alhambra, CA · Accident · Minor injuries · Closed · Feb 29, 1980 · N61265 · Substantial damage
- [NTSB IAD80FID08](https://openairdocs.org/ntsb/IAD80FID08.md): Piper PA-31 · Appomattox, VA · Accident · Minor injuries · Closed · Feb 29, 1980 · N77QC · Destroyed
- [NTSB FTW80FA049](https://openairdocs.org/ntsb/FTW80FA049.md): Bell 212 · Hillsboro, TX · Accident · 3 fatal · Closed · Feb 29, 1980 · TPH-04 · Destroyed
- [NTSB SEA80FYE19](https://openairdocs.org/ntsb/SEA80FYE19.md): Republic RC-3 · Mckenna, WA · Accident · Serious injuries · Closed · Feb 28, 1980 · N87576 · Substantial damage
- [NTSB NYC80FFA09](https://openairdocs.org/ntsb/NYC80FFA09.md): Bellanca 7ECA · Poland, NY · Accident · No injuries · Closed · Feb 28, 1980 · N11081 · Substantial damage
- [NTSB LAX80DUJ34](https://openairdocs.org/ntsb/LAX80DUJ34.md): Cessna R172K · Concho, AZ · Accident · Minor injuries · Closed · Feb 28, 1980 · N758PP · Substantial damage
- [NTSB SEA80FYE18](https://openairdocs.org/ntsb/SEA80FYE18.md): Aerospatle 318C · Aberdeen, WA · Accident · Serious injuries · Closed · Feb 27, 1980 · N5593N · Substantial damage
- [NTSB MIA80FLT01](https://openairdocs.org/ntsb/MIA80FLT01.md): Cessna 188 · Tunica, MS · Accident · 1 fatal · Closed · Feb 27, 1980 · N8148V · Destroyed
- [NTSB LAX80FUQ11](https://openairdocs.org/ntsb/LAX80FUQ11.md): Bell 47G · Pacoima, CA · Accident · No injuries · Closed · Feb 26, 1980 · N182JR · Substantial damage
- [NTSB LAX80FA058](https://openairdocs.org/ntsb/LAX80FA058.md): Bellanca 17-31A · Long Beach, CA · Accident · 2 fatal · Closed · Feb 25, 1980 · N8853V · Destroyed
- [NTSB DEN80FQA19](https://openairdocs.org/ntsb/DEN80FQA19.md): Beech A-45 · Taos, NM · Accident · Serious injuries · Closed · Feb 25, 1980 · N421NM · Substantial damage
- [NTSB SEA80FA020](https://openairdocs.org/ntsb/SEA80FA020.md): Cessna 172N · Dufur, OR · Accident · 3 fatal · Closed · Feb 24, 1980 · N2340E · Destroyed
- [NTSB MIA80FKJ22](https://openairdocs.org/ntsb/MIA80FKJ22.md): Erco 415-C · Laceys Spring, AL · Accident · Serious injuries · Closed · Feb 24, 1980 · N3546H · Substantial damage
- [NTSB MIA80FA037](https://openairdocs.org/ntsb/MIA80FA037.md): Beech V35 · Valdosta, GA · Accident · 3 fatal · Closed · Feb 24, 1980 · N5620S · Destroyed
- [NTSB IAD80FA027](https://openairdocs.org/ntsb/IAD80FA027.md): Cessna 150 · Reidland, KY · Accident · 1 fatal · Closed · Feb 24, 1980 · N1678Q · Destroyed
- [NTSB DEN80DTE29](https://openairdocs.org/ntsb/DEN80DTE29.md): Cessna 182J · Kremmling, CO · Accident · Minor injuries · Closed · Feb 24, 1980 · N2677F · Destroyed
- [NTSB MIA80FLD42](https://openairdocs.org/ntsb/MIA80FLD42.md): Cessna 210 · Sun City, FL · Accident · Serious injuries · Closed · Feb 23, 1980 · N6548N · Destroyed

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

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

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