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

## Cases, newest first

- [NTSB DEN81FTE36](https://openairdocs.org/ntsb/DEN81FTE36.md): Piper PA-28 · Alamosa, CO · Accident · Minor injuries · Closed · May 12, 1981 · N9511C · Substantial damage
- [NTSB LAX82FA086](https://openairdocs.org/ntsb/LAX82FA086.md): Cessna 152 · Ruth, CA · Accident · 1 fatal · Closed · May 11, 1981 · N67379 · Destroyed
- [NTSB CHI81FCA07](https://openairdocs.org/ntsb/CHI81FCA07.md): Piper PA-28 · Highland, IL · Accident · No injuries · Closed · May 11, 1981 · N49887 · Substantial damage
- [NTSB SEA81FYM24](https://openairdocs.org/ntsb/SEA81FYM24.md): Maule M4220C · North Plains, OR · Accident · No injuries · Closed · May 10, 1981 · N2071U · Substantial damage
- [NTSB LAX81FUJ62](https://openairdocs.org/ntsb/LAX81FUJ62.md): Hughes 269C · Cottonwood, AZ · Accident · Serious injuries · Closed · May 10, 1981 · N58210 · Destroyed
- [NTSB CHI81FA055](https://openairdocs.org/ntsb/CHI81FA055.md): Mooney M20K · Campbell Hill, IL · Accident · 1 fatal · Closed · May 10, 1981 · N231DZ · Destroyed
- [NTSB NYC81FA046](https://openairdocs.org/ntsb/NYC81FA046.md): Erco 415-D · Terryville, CT · Accident · No injuries · Closed · May 9, 1981 · C-FNWZ · Destroyed
- [NTSB DEN81FTC15](https://openairdocs.org/ntsb/DEN81FTC15.md): Cessna 152 · Gillette, WY · Accident · No injuries · Closed · May 8, 1981 · N6560H · Substantial damage
- [NTSB ANC81DA051](https://openairdocs.org/ntsb/ANC81DA051.md): Dehavilland DHC-2 · Klawock, AK · Accident · No injuries · Closed · May 8, 1981 · N64384 · Substantial damage
- [NTSB LAX81FUD01](https://openairdocs.org/ntsb/LAX81FUD01.md): Bellanca 17-31 · Santa Monica, CA · Accident · No injuries · Closed · May 6, 1981 · N1281R · Destroyed
- [NTSB FTW81FRG34](https://openairdocs.org/ntsb/FTW81FRG34.md): Beech C50 · Los Fresnos, TX · Accident · No injuries · Closed · May 6, 1981 · N3712B · Substantial damage
- [NTSB FTW81FA088](https://openairdocs.org/ntsb/FTW81FA088.md): Beech 35 · Muse, OK · Accident · 2 fatal · Closed · May 6, 1981 · N3952C · Destroyed
- [NTSB FTW81FA085](https://openairdocs.org/ntsb/FTW81FA085.md): Aerospatial AS350D · Gulf Of Mexico (Gulf of Mexico) · Accident · No injuries · Closed · May 4, 1981 · N143BH · Substantial damage
- [NTSB DEN81FA030](https://openairdocs.org/ntsb/DEN81FA030.md): Piper PA-32 · Gillette, WY · Accident · 1 fatal · Closed · May 4, 1981 · N8999N · Substantial damage
- [NTSB CHI81FEV18](https://openairdocs.org/ntsb/CHI81FEV18.md): Cessna 177B · Winchester, IL · Accident · No injuries · Closed · May 4, 1981 · N13676 · Substantial damage
- [NTSB ATL81FIA06](https://openairdocs.org/ntsb/ATL81FIA06.md): Hughes 269C · Washington, DC · Accident · No injuries · Closed · May 4, 1981 · N7447F · Substantial damage
- [NTSB SEA81FA033](https://openairdocs.org/ntsb/SEA81FA033.md): Stinson 108-2 · Ellensburg, WA · Accident · Serious injuries · Closed · May 3, 1981 · N9279K · Destroyed
- [NTSB ATL81FLT08](https://openairdocs.org/ntsb/ATL81FLT08.md): Hughes 269C · Ridgely, TN · Accident · No injuries · Closed · May 3, 1981 · N7487F · Substantial damage
- [NTSB ATL81FA070](https://openairdocs.org/ntsb/ATL81FA070.md): Mooney M20K · Churchville, MD · Accident · Serious injuries · Closed · May 3, 1981 · N231CJ · Substantial damage
- [NTSB ATL81DLQ15](https://openairdocs.org/ntsb/ATL81DLQ15.md): Hughes 269A-1 · Canonsburg, KY · Accident · No injuries · Closed · May 3, 1981 · N8875F · Substantial damage
- [NTSB NYC81FHA10](https://openairdocs.org/ntsb/NYC81FHA10.md): Cessna 150G · Stroudsburg, PA · Accident · Minor injuries · Closed · May 2, 1981 · N4073J · Substantial damage
- [NTSB LAX81FUQ20](https://openairdocs.org/ntsb/LAX81FUQ20.md): Cherokee II · Valyermo, CA · Accident · 1 fatal · Closed · May 2, 1981 · N3311 · Destroyed
- [NTSB LAX81FUG27](https://openairdocs.org/ntsb/LAX81FUG27.md): Cessna 172 · Hesperia, CA · Accident · Minor injuries · Closed · May 2, 1981 · N7490G · Substantial damage
- [NTSB LAX81FA081](https://openairdocs.org/ntsb/LAX81FA081.md): Cessna 172 · Claremont, CA · Accident · 1 fatal · Closed · May 2, 1981 · N6317E · Destroyed
- [NTSB FTW81FRG35](https://openairdocs.org/ntsb/FTW81FRG35.md): Cessna 441 · Hebbronville, TX · Accident · No injuries · Closed · May 2, 1981 · N4180G · Substantial damage
- [NTSB MIA81DLD35](https://openairdocs.org/ntsb/MIA81DLD35.md): Dehavilland DH-104 · Sebring, FL · Accident · Minor injuries · Closed · May 1, 1981 · N630H · Destroyed
- [NTSB DEN81FA029](https://openairdocs.org/ntsb/DEN81FA029.md): Bell UH-1B · Williston, ND · Accident · 8 fatal · Closed · May 1, 1981 · N46942 · Destroyed
- [NTSB DEN81FTC14](https://openairdocs.org/ntsb/DEN81FTC14.md): Dehavilland DHC-1 · Rawlins, WY · Accident · No injuries · Closed · Apr 30, 1981 · N48262 · Substantial damage
- [NTSB LAX81FUJ54](https://openairdocs.org/ntsb/LAX81FUJ54.md): Cougar 1 · Willcox, AZ · Accident · Minor injuries · Closed · Apr 29, 1981 · N777BP · Substantial damage
- [NTSB FTW81FA082](https://openairdocs.org/ntsb/FTW81FA082.md): Bell 206L-1 · Angleton, TX · Accident · No injuries · Closed · Apr 29, 1981 · N2774V · Substantial damage
- [NTSB LAX81FVA37](https://openairdocs.org/ntsb/LAX81FVA37.md): Aero Comdr S2R · Firebaugh, CA · Accident · No injuries · Closed · Apr 28, 1981 · N8913Q · Substantial damage
- [NTSB ATL81FKG17](https://openairdocs.org/ntsb/ATL81FKG17.md): Piper PA-39 · Macon, GA · Accident · No injuries · Closed · Apr 28, 1981 · N8959Y · Substantial damage
- [NTSB LAX81FUG42](https://openairdocs.org/ntsb/LAX81FUG42.md): Raven RX-7 · San Dimas, CA · Accident · Serious injuries · Closed · Apr 26, 1981 · N55672 · Substantial damage
- [NTSB LAX81FA079](https://openairdocs.org/ntsb/LAX81FA079.md): Piper PA-32 · Tehachapi, CA · Accident · 1 fatal · Closed · Apr 26, 1981 · N8921N · Destroyed
- [NTSB FTW81DRG32](https://openairdocs.org/ntsb/FTW81DRG32.md): Taylor Titc MK-1 · Menard, TX · Accident · Minor injuries · Closed · Apr 26, 1981 · N1032L · Destroyed
- [NTSB FTW81DPG19](https://openairdocs.org/ntsb/FTW81DPG19.md): Cessna 172 · Bay, AR · Accident · No injuries · Closed · Apr 26, 1981 · N79078 · Substantial damage
- [NTSB DEN81FTM20](https://openairdocs.org/ntsb/DEN81FTM20.md): Hughes 369D · Morgan, SD · Accident · Minor injuries · Closed · Apr 26, 1981 · N58283 · Substantial damage
- [NTSB FTW81FPD19](https://openairdocs.org/ntsb/FTW81FPD19.md): Champion 402 · Roanoke, TX · Accident · Minor injuries · Closed · Apr 25, 1981 · N9956Y · Substantial damage
- [NTSB FTW81FA079](https://openairdocs.org/ntsb/FTW81FA079.md): Cessna TU206B · Beaumont, TX · Accident · 1 fatal · Closed · Apr 25, 1981 · N3414L · Destroyed
- [NTSB DEN81DTG08](https://openairdocs.org/ntsb/DEN81DTG08.md): Cessna A185F · Williston, ND · Accident · No injuries · Closed · Apr 25, 1981 · N93275 · Substantial damage
- [NTSB CHI81FEK15](https://openairdocs.org/ntsb/CHI81FEK15.md): Richards Variez · Wapakoneta, OH · Accident · Serious injuries · Closed · Apr 24, 1981 · N48EZ · Substantial damage
- [NTSB MKC81FCD17](https://openairdocs.org/ntsb/MKC81FCD17.md): Mooney M20J · Norwalk, IA · Accident · No injuries · Closed · Apr 23, 1981 · N4452H · Substantial damage
- [NTSB DEN82DTE29](https://openairdocs.org/ntsb/DEN82DTE29.md): Cessna 172N · Wray, CO · Accident · No injuries · Closed · Apr 23, 1981 · N4767E · Substantial damage
- [NTSB ATL81FKG16](https://openairdocs.org/ntsb/ATL81FKG16.md): Cessna 172P · Carnesville, GA · Accident · No injuries · Closed · Apr 23, 1981 · N53045 · Substantial damage
- [NTSB SEA81FA031](https://openairdocs.org/ntsb/SEA81FA031.md): Piper PA-28 · Washougal, WA · Accident · 2 fatal · Closed · Apr 22, 1981 · C-GNVX · Destroyed
- [NTSB LAX81FJA08](https://openairdocs.org/ntsb/LAX81FJA08.md): Cessna 206G · 400mi Ne Hnl, HI · Accident · Minor injuries · Closed · Apr 22, 1981 · N6318U · Destroyed
- [NTSB FTW81IA076](https://openairdocs.org/ntsb/FTW81IA076.md): Bell 206B · Gulf Of Mexico (Gulf of Mexico) · Incident · No injuries · Closed · Apr 22, 1981 · N2757C · Minor damage
- [NTSB SEA81AA030](https://openairdocs.org/ntsb/SEA81AA030.md): Cessna 172N · Gorst, WA · Accident · 1 fatal · Closed · Apr 21, 1981 · N2411E · Destroyed
- [NTSB LAX81FUA07](https://openairdocs.org/ntsb/LAX81FUA07.md): Bellanca 8KCAB · San Pedro, CA · Accident · Minor injuries · Closed · Apr 21, 1981 · N2576Z · Substantial damage
- [NTSB MKC81IA031](https://openairdocs.org/ntsb/MKC81IA031.md): Piper PA-32 · St.Ansgar, IA · Incident · No injuries · Closed · Apr 20, 1981 · N3370W · Minor damage

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

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

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