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

## Cases, newest first

- [NTSB ANC81FA039](https://openairdocs.org/ntsb/ANC81FA039.md): Cessna 185F · Delta Junction, AK · Accident · Minor injuries · Closed · Apr 2, 1981 · N456AP · Substantial damage
- [NTSB LAX81FA069](https://openairdocs.org/ntsb/LAX81FA069.md): Cessna 172 · Cholame, CA · Accident · 2 fatal · Closed · Apr 1, 1981 · N80352 · Destroyed
- [NTSB FTW81FA062](https://openairdocs.org/ntsb/FTW81FA062.md): Bell 206L1 · Huntsville, TX · Accident · No injuries · Closed · Apr 1, 1981 · N2623 · Substantial damage
- [NTSB FTW81DRG29](https://openairdocs.org/ntsb/FTW81DRG29.md): Grumman G-164A · San Saba, TX · Accident · No injuries · Closed · Apr 1, 1981 · N8508H · Substantial damage
- [NTSB FTW81DA063](https://openairdocs.org/ntsb/FTW81DA063.md): Douglas DC-3 · Laredo, TX · Accident · No injuries · Closed · Apr 1, 1981 · N3433P · Substantial damage
- [NTSB CHI81FEE26](https://openairdocs.org/ntsb/CHI81FEE26.md): Cessna 152 · Hoffman Est, IL · Accident · Serious injuries · Closed · Mar 31, 1981 · N757PB · Destroyed
- [NTSB CHI81FA040](https://openairdocs.org/ntsb/CHI81FA040.md): Piper PA-32 · Corunna, MI · Accident · 1 fatal · Closed · Mar 31, 1981 · N2158D · Destroyed
- [NTSB ATL81FA058](https://openairdocs.org/ntsb/ATL81FA058.md): Beech A23-24 · Sawyer, KY · Accident · Minor injuries · Closed · Mar 31, 1981 · N5690S · Substantial damage
- [NTSB LAX81FA068](https://openairdocs.org/ntsb/LAX81FA068.md): Cessna 172N · Temecula, CA · Accident · 2 fatal · Closed · Mar 29, 1981 · N738WP · Substantial damage
- [NTSB SEA81FA026](https://openairdocs.org/ntsb/SEA81FA026.md): Muir RV-3 · Renton, WA · Accident · 1 fatal · Closed · Mar 28, 1981 · N84763 · Destroyed
- [NTSB NYC81FNE13](https://openairdocs.org/ntsb/NYC81FNE13.md): Cessna 150 · Mansfield, CT · Accident · No injuries · Closed · Mar 28, 1981 · N60118 · Substantial damage
- [NTSB MIA81FA057](https://openairdocs.org/ntsb/MIA81FA057.md): Douglas C-54B · St.Croix (Atlantic Ocean) · Accident · 1 fatal · Closed · Mar 28, 1981 · N98AS · Destroyed
- [NTSB MIA81IA058](https://openairdocs.org/ntsb/MIA81IA058.md): Dehavilland DH-114 · St Thomas, VI · Incident · Minor injuries · Closed · Mar 27, 1981 · N583PR · Minor damage
- [NTSB FTW81FA059](https://openairdocs.org/ntsb/FTW81FA059.md): Cessna 172P · Lake Charles, LA · Accident · 1 fatal · Closed · Mar 27, 1981 · N52710 · Destroyed
- [NTSB MKC81FCQ18](https://openairdocs.org/ntsb/MKC81FCQ18.md): Cessna 150K · Haysville, KS · Accident · Minor injuries · Closed · Mar 26, 1981 · N6418G · Substantial damage
- [NTSB CHI81FA039](https://openairdocs.org/ntsb/CHI81FA039.md): Cessna A185F · Patzau, WI · Accident · 2 fatal · Closed · Mar 26, 1981 · N4862C · Destroyed
- [NTSB FTW81IA058](https://openairdocs.org/ntsb/FTW81IA058.md): Embraer 110P1 · Lafayette, LA · Incident · No injuries · Closed · Mar 25, 1981 · N691RA · Minor damage
- [NTSB FTW81FA056](https://openairdocs.org/ntsb/FTW81FA056.md): Bell 206L-1 · Gulf Of Mexico (Gulf of Mexico) · Accident · Minor injuries · Closed · Mar 25, 1981 · N1077N · Substantial damage
- [NTSB MIA81FA055](https://openairdocs.org/ntsb/MIA81FA055.md): N.American P51D · Tallahassee, FL · Accident · No injuries · Closed · Mar 24, 1981 · N3451D · 2 aircraft · Minor damage
- [NTSB ANC81DA036](https://openairdocs.org/ntsb/ANC81DA036.md): Champion 7EC · Chignik Lagoon, AK · Accident · No injuries · Closed · Mar 24, 1981 · N4396C · Destroyed
- [NTSB MKC81FCG28](https://openairdocs.org/ntsb/MKC81FCG28.md): Cessna 182C · Springfield, MO · Accident · No injuries · Closed · Mar 23, 1981 · N8656T · Substantial damage
- [NTSB LAX81FA064](https://openairdocs.org/ntsb/LAX81FA064.md): Cessna 172N · Frazier Park, CA · Accident · 2 fatal · Closed · Mar 22, 1981 · N5534D · Destroyed
- [NTSB FTW81FA051](https://openairdocs.org/ntsb/FTW81FA051.md): Cessna 210B · Graham, TX · Accident · Minor injuries · Closed · Mar 22, 1981 · N9629X · Destroyed
- [NTSB SEA81FA025](https://openairdocs.org/ntsb/SEA81FA025.md): Schweizer SGS126 · Arlington, WA · Accident · 1 fatal · Closed · Mar 21, 1981 · N9866E · Destroyed
- [NTSB NYC81FGM14](https://openairdocs.org/ntsb/NYC81FGM14.md): Piper PA-38 · Beaver Falls, PA · Accident · No injuries · Closed · Mar 21, 1981 · N2552D · Substantial damage
- [NTSB MIA81FA054](https://openairdocs.org/ntsb/MIA81FA054.md): Mooney M20F · San Juan, PR · Accident · 3 fatal · Closed · Mar 21, 1981 · N712CS · Destroyed
- [NTSB FTW81FRA22](https://openairdocs.org/ntsb/FTW81FRA22.md): Grumman G-164B · Lissie, TX · Accident · Serious injuries · Closed · Mar 21, 1981 · N48609 · 2 aircraft · Destroyed
- [NTSB SEA81FYP11](https://openairdocs.org/ntsb/SEA81FYP11.md): Piper PA-28 · Wenatchee, WA · Accident · Minor injuries · Closed · Mar 20, 1981 · N7226F · Substantial damage
- [NTSB MIA81FA053](https://openairdocs.org/ntsb/MIA81FA053.md): Hiller UH-12D · Miami Beach, FL · Accident · Minor injuries · Closed · Mar 20, 1981 · N62376 · Destroyed
- [NTSB MKC81FCQ17](https://openairdocs.org/ntsb/MKC81FCQ17.md): Beech A36 · Hill City, KS · Accident · Minor injuries · Closed · Mar 19, 1981 · N2022A · Substantial damage
- [NTSB LAX81FA118](https://openairdocs.org/ntsb/LAX81FA118.md): Cessna T210N · Bishop, CA · Accident · 2 fatal · Closed · Mar 19, 1981 · N4943C · Destroyed
- [NTSB SEA81FYK07](https://openairdocs.org/ntsb/SEA81FYK07.md): Hiller Acft UH-12E · Umpqua, OR · Accident · Serious injuries · Closed · Mar 18, 1981 · N90467 · Substantial damage
- [NTSB LAX81FUJ43](https://openairdocs.org/ntsb/LAX81FUJ43.md): Cessna 210D · Phoenix, AZ · Accident · No injuries · Closed · Mar 18, 1981 · N393Q · Substantial damage
- [NTSB LAX81FA061](https://openairdocs.org/ntsb/LAX81FA061.md): Piper PA-28 · Tucson, AZ · Accident · 2 fatal · Closed · Mar 18, 1981 · N8274B · 2 aircraft · Destroyed
- [NTSB NYC81FNC10](https://openairdocs.org/ntsb/NYC81FNC10.md): Piper PA-23 · Brookfield, VT · Accident · Serious injuries · Closed · Mar 17, 1981 · N747F · Substantial damage
- [NTSB LAX81FA060](https://openairdocs.org/ntsb/LAX81FA060.md): Cessna 150 · Reno, NV · Accident · 2 fatal · Closed · Mar 17, 1981 · N704SQ · Destroyed
- [NTSB FTW81DRD14](https://openairdocs.org/ntsb/FTW81DRD14.md): Cessna 402B · Houma, LA · Accident · No injuries · Closed · Mar 17, 1981 · N3767C · Substantial damage
- [NTSB DEN81FA022](https://openairdocs.org/ntsb/DEN81FA022.md): Bell 206A · Evanston, WY · Accident · No injuries · Closed · Mar 16, 1981 · N7881S · Substantial damage
- [NTSB NYC81FNC09](https://openairdocs.org/ntsb/NYC81FNC09.md): Cessna 140 · Enfield, NH · Accident · No injuries · Closed · Mar 15, 1981 · N72UL · Substantial damage
- [NTSB NYC81FHD16](https://openairdocs.org/ntsb/NYC81FHD16.md): Piper PA-28 · Smithville, NJ · Accident · Minor injuries · Closed · Mar 15, 1981 · N44610 · Destroyed
- [NTSB ATL81DKJ14](https://openairdocs.org/ntsb/ATL81DKJ14.md): Piper PA-38 · Auburn, AL · Accident · No injuries · Closed · Mar 15, 1981 · N2523T · Substantial damage
- [NTSB ANC81FA033](https://openairdocs.org/ntsb/ANC81FA033.md): Piper PA-18A · Fairbanks, AK · Accident · 2 fatal · Closed · Mar 15, 1981 · N8570D · Destroyed
- [NTSB LAX81FA059](https://openairdocs.org/ntsb/LAX81FA059.md): Piper PA-28 · Molokai, HI · Accident · 4 fatal · Closed · Mar 14, 1981 · N5956W · Destroyed
- [NTSB ANC81FA029](https://openairdocs.org/ntsb/ANC81FA029.md): Cessna 180 · Shishmaref, AK · Accident · No injuries · Closed · Mar 14, 1981 · N7685A · Substantial damage
- [NTSB ANC81FA028](https://openairdocs.org/ntsb/ANC81FA028.md): Dehavnd Can DHC-2 · Kenai, AK · Accident · 1 fatal · Closed · Mar 14, 1981 · N6473 · Substantial damage
- [NTSB LAX81FUJ41](https://openairdocs.org/ntsb/LAX81FUJ41.md): Cessna 182Q · Apache Jct, AZ · Accident · No injuries · Closed · Mar 13, 1981 · N4932N · Substantial damage
- [NTSB FTW81FRG26](https://openairdocs.org/ntsb/FTW81FRG26.md): Great Lakes 2T-1A2 · Alamo, TX · Accident · No injuries · Closed · Mar 13, 1981 · N6053L · Substantial damage
- [NTSB NYC81FA032](https://openairdocs.org/ntsb/NYC81FA032.md): Beech F33A · Ilion, NY · Accident · 2 fatal · Closed · Mar 12, 1981 · N17590 · Destroyed
- [NTSB SEA81FYP10](https://openairdocs.org/ntsb/SEA81FYP10.md): Piper PA-25 · Oaksdale, WA · Accident · Minor injuries · Closed · Mar 11, 1981 · N7553Z · Substantial damage
- [NTSB LAX81FUG16](https://openairdocs.org/ntsb/LAX81FUG16.md): Harmon-Weig Jungst · Corona, CA · Accident · No injuries · Closed · Mar 9, 1981 · N615HW · Substantial damage

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

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

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