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

## Cases, newest first

- [NTSB DEN80DTE18](https://openairdocs.org/ntsb/DEN80DTE18.md): Piper PA-18 · Las Animas, CO · Accident · No injuries · Closed · Jan 4, 1980 · N73371 · Substantial damage
- [NTSB LAX80FVM12](https://openairdocs.org/ntsb/LAX80FVM12.md): Cessna T210N · Palo Alto, CA · Accident · Serious injuries · Closed · Jan 3, 1980 · N4747C · Substantial damage
- [NTSB LAX80FA032](https://openairdocs.org/ntsb/LAX80FA032.md): Cessna 172 · Coalinga, CA · Accident · 2 fatal · Closed · Jan 3, 1980 · N4290L · Destroyed
- [NTSB FTW80FA030](https://openairdocs.org/ntsb/FTW80FA030.md): Bell 206B · Montegut, LA · Accident · 1 fatal · Closed · Jan 3, 1980 · N30TA · 2 aircraft · Destroyed
- [NTSB LAX80FUA07](https://openairdocs.org/ntsb/LAX80FUA07.md): Cessna 172 · Torrance, CA · Accident · Minor injuries · Closed · Jan 2, 1980 · N738GA · Substantial damage
- [NTSB MIA80FKJ15](https://openairdocs.org/ntsb/MIA80FKJ15.md): Cessna 172I · Foley, AL · Accident · No injuries · Closed · Dec 31, 1979 · N46053 · Substantial damage
- [NTSB NYC80FHJ06](https://openairdocs.org/ntsb/NYC80FHJ06.md): Cougar AJ1 · Bayport, NY · Accident · Minor injuries · Closed · Dec 30, 1979 · N11112 · Substantial damage
- [NTSB CHI80FEX03](https://openairdocs.org/ntsb/CHI80FEX03.md): Beech B35 · Fairmount, IN · Accident · Minor injuries · Closed · Dec 30, 1979 · N8811A · Substantial damage
- [NTSB NYC80FHM06](https://openairdocs.org/ntsb/NYC80FHM06.md): Cessna 150 · Teaneck, NJ · Accident · Serious injuries · Closed · Dec 29, 1979 · N50741 · Substantial damage
- [NTSB CHI80DEP12](https://openairdocs.org/ntsb/CHI80DEP12.md): M.B.B. BO-209 · Johnson Creek, WI · Accident · No injuries · Closed · Dec 29, 1979 · N209SF · Substantial damage
- [NTSB CHI80FA019](https://openairdocs.org/ntsb/CHI80FA019.md): Piper PA-28R · Kankakee, IL · Accident · 2 fatal · Closed · Dec 28, 1979 · N7644J · Destroyed
- [NTSB CHI80FEM09](https://openairdocs.org/ntsb/CHI80FEM09.md): Cessna 150H · Hesperia, MI · Accident · No injuries · Closed · Dec 26, 1979 · N6746S · Substantial damage
- [NTSB FTW80FRG16](https://openairdocs.org/ntsb/FTW80FRG16.md): Cessna 152 · San Antonio, TX · Accident · No injuries · Closed · Dec 24, 1979 · N68816 · Substantial damage
- [NTSB LAX80FVD07](https://openairdocs.org/ntsb/LAX80FVD07.md): Beech B24R · Cloverdale, CA · Accident · Minor injuries · Closed · Dec 23, 1979 · N6991R · Destroyed
- [NTSB MIA80FA022](https://openairdocs.org/ntsb/MIA80FA022.md): Beech E18S · Orlando, FL · Accident · 4 fatal · Closed · Dec 22, 1979 · N198B · Destroyed
- [NTSB FTW80FPD07](https://openairdocs.org/ntsb/FTW80FPD07.md): Cessna 120 · Lawn, TX · Accident · No injuries · Closed · Dec 22, 1979 · N44BM · Substantial damage
- [NTSB DEN80FA013](https://openairdocs.org/ntsb/DEN80FA013.md): Rockwell 500B · Santa Fe, NM · Accident · 1 fatal · Closed · Dec 22, 1979 · N6194X · Destroyed
- [NTSB SEA80FTA06](https://openairdocs.org/ntsb/SEA80FTA06.md): Cessna 210M · Glendive, MT · Accident · No injuries · Closed · Dec 21, 1979 · N8197M · Substantial damage
- [NTSB SEA80DYA05](https://openairdocs.org/ntsb/SEA80DYA05.md): Mooney M20E · Burley, ID · Accident · No injuries · Closed · Dec 21, 1979 · N1306W · Substantial damage
- [NTSB MKC80FA015](https://openairdocs.org/ntsb/MKC80FA015.md): Cessna 152 · Olathe, KS · Accident · 1 fatal · Closed · Dec 21, 1979 · N25494 · Destroyed
- [NTSB MIA80DKJ14](https://openairdocs.org/ntsb/MIA80DKJ14.md): Cessna 152 · Huntsville, AL · Accident · No injuries · Closed · Dec 21, 1979 · N67340 · Substantial damage
- [NTSB LAX80FA027](https://openairdocs.org/ntsb/LAX80FA027.md): Cessna 172M · Lebec, CA · Accident · 5 fatal · Closed · Dec 21, 1979 · N6714H · Destroyed
- [NTSB IAD80DLQ06](https://openairdocs.org/ntsb/IAD80DLQ06.md): Cessna 172F · Corbin, KY · Accident · No injuries · Closed · Dec 21, 1979 · N8820U · Substantial damage
- [NTSB FTW80FA026](https://openairdocs.org/ntsb/FTW80FA026.md): Cessna 182E · Comfort, TX · Accident · 2 fatal · Closed · Dec 21, 1979 · N2853Y · Destroyed
- [NTSB FTW80FA025](https://openairdocs.org/ntsb/FTW80FA025.md): Cessna 182 · Story, AR · Accident · 1 fatal · Closed · Dec 21, 1979 · N5393B · Destroyed
- [NTSB DEN80FQA12](https://openairdocs.org/ntsb/DEN80FQA12.md): Cessna 177B · Vaughn, NM · Accident · Serious injuries · Closed · Dec 21, 1979 · N16239 · Destroyed
- [NTSB CHI80IEP10](https://openairdocs.org/ntsb/CHI80IEP10.md): Mooney M20J · Waterloo, WI · Accident · No injuries · Closed · Dec 21, 1979 · N201UW · Substantial damage
- [NTSB ANC80IA021](https://openairdocs.org/ntsb/ANC80IA021.md): Cessna 207A · Bethel, AK · Incident · No injuries · Closed · Dec 21, 1979 · N7605U · No damage
- [NTSB LAX80FA114](https://openairdocs.org/ntsb/LAX80FA114.md): Piper PA-32R · Safford, AZ · Accident · 2 fatal · Closed · Dec 20, 1979 · N9877K · Destroyed
- [NTSB LAX80DXQ12](https://openairdocs.org/ntsb/LAX80DXQ12.md): Cessna T2101 · Yerington, NV · Accident · Minor injuries · Closed · Dec 20, 1979 · N2227S · Substantial damage
- [NTSB FTW80DRA14](https://openairdocs.org/ntsb/FTW80DRA14.md): Meyers 200 · La Porte, TX · Accident · No injuries · Closed · Dec 20, 1979 · N495C · Substantial damage
- [NTSB FTW80DQG06](https://openairdocs.org/ntsb/FTW80DQG06.md): Cessna 152 · Sweetwater, TX · Accident · No injuries · Closed · Dec 20, 1979 · N4727B · Substantial damage
- [NTSB FTW80FRD14](https://openairdocs.org/ntsb/FTW80FRD14.md): Hughes 369D · Westwego, LA · Accident · No injuries · Closed · Dec 19, 1979 · N58270 · Substantial damage
- [NTSB CHI80FEM08](https://openairdocs.org/ntsb/CHI80FEM08.md): Ryan ST-3KR · Holland, MI · Accident · Minor injuries · Closed · Dec 19, 1979 · N47433 · Substantial damage
- [NTSB NYC80FNA06](https://openairdocs.org/ntsb/NYC80FNA06.md): Cessna 177RG · Mashpee, MA · Accident · Minor injuries · Closed · Dec 18, 1979 · N35106 · Substantial damage
- [NTSB NYC80FA015](https://openairdocs.org/ntsb/NYC80FA015.md): Cessna 172 · Washingtnville, NY · Accident · 1 fatal · Closed · Dec 16, 1979 · N6647A · Destroyed
- [NTSB LAX80FUJ20](https://openairdocs.org/ntsb/LAX80FUJ20.md): Cessna 180J · Chandler, AZ · Accident · No injuries · Closed · Dec 16, 1979 · N91K · Substantial damage
- [NTSB IAD80FA017](https://openairdocs.org/ntsb/IAD80FA017.md): Beech A65 · Lexington, KY · Accident · 7 fatal · Closed · Dec 16, 1979 · N154F · Destroyed
- [NTSB MIA80FA018](https://openairdocs.org/ntsb/MIA80FA018.md): Raven S-55A · Davie, FL · Accident · 4 fatal · Closed · Dec 15, 1979 · N64RR · Destroyed
- [NTSB CHI80FA014](https://openairdocs.org/ntsb/CHI80FA014.md): Hughes 269C · West Milton, OH · Accident · 1 fatal · Closed · Dec 15, 1979 · N7483F · Destroyed
- [NTSB DEN80FTE14](https://openairdocs.org/ntsb/DEN80FTE14.md): Cessna R172K · Montrose, CO · Accident · Minor injuries · Closed · Dec 14, 1979 · N736LR · Substantial damage
- [NTSB IAD80DID05](https://openairdocs.org/ntsb/IAD80DID05.md): Piper PA-28 · Lexington, VA · Accident · Minor injuries · Closed · Dec 12, 1979 · N5059S · Substantial damage
- [NTSB MKC80FA014](https://openairdocs.org/ntsb/MKC80FA014.md): Cessna 182S · Womack, MO · Accident · 1 fatal · Closed · Dec 11, 1979 · N3594U · Destroyed
- [NTSB MKC80FA013](https://openairdocs.org/ntsb/MKC80FA013.md): Piper PA-31 · Lee'S Summit, MO · Accident · No injuries · Closed · Dec 11, 1979 · N7511L · Substantial damage
- [NTSB SEA80FYM09](https://openairdocs.org/ntsb/SEA80FYM09.md): Cessna 150G · Aloha, OR · Accident · Serious injuries · Closed · Dec 10, 1979 · N4825X · Substantial damage
- [NTSB MIA79FLA10](https://openairdocs.org/ntsb/MIA79FLA10.md): Bell 206B · Sea Island, GA · Accident · No injuries · Closed · Dec 10, 1979 · N59530 · Substantial damage
- [NTSB LAX80DVG09](https://openairdocs.org/ntsb/LAX80DVG09.md): Cessna 172 · Sacramento, CA · Accident · No injuries · Closed · Dec 10, 1979 · N8173L · Substantial damage
- [NTSB SEA80FA014](https://openairdocs.org/ntsb/SEA80FA014.md): Cessna 182 · Idaho Falls, ID · Accident · 2 fatal · Closed · Dec 9, 1979 · N470PP · Destroyed
- [NTSB MKC80FCQ05](https://openairdocs.org/ntsb/MKC80FCQ05.md): Cessna 150G · Onaga, KS · Accident · Minor injuries · Closed · Dec 9, 1979 · N3165X · Substantial damage
- [NTSB MKC80FCQ04](https://openairdocs.org/ntsb/MKC80FCQ04.md): Piper PA-28 · Dodge City, KS · Accident · Minor injuries · Closed · Dec 9, 1979 · N5298S · Substantial damage

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

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

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