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

## Cases, newest first

- [NTSB FTW81FQD06](https://openairdocs.org/ntsb/FTW81FQD06.md): Piper PA-32 · Carlsbad, NM · Accident · No injuries · Closed · Nov 1, 1980 · N40908 · Substantial damage
- [NTSB FTW81FQA08](https://openairdocs.org/ntsb/FTW81FQA08.md): Mitsubishi MW-2B · Roswell, NM · Accident · No injuries · Closed · Nov 1, 1980 · N10FR · Substantial damage
- [NTSB FTW81FQA07](https://openairdocs.org/ntsb/FTW81FQA07.md): Piper PA-28R · Taos Pueblo, NM · Accident · No injuries · Closed · Nov 1, 1980 · N4975S · Substantial damage
- [NTSB ATL81FLG04](https://openairdocs.org/ntsb/ATL81FLG04.md): Cessna 402B · Salley, SC · Accident · Serious injuries · Closed · Nov 1, 1980 · N8159Q · Destroyed
- [NTSB ANC81DAG10](https://openairdocs.org/ntsb/ANC81DAG10.md): Hughes 269A · Goose Bay, AK · Accident · No injuries · Closed · Nov 1, 1980 · N8775F · Substantial damage
- [NTSB LAX80FUG03](https://openairdocs.org/ntsb/LAX80FUG03-129003.md): Cessna 150 · Big Bear Lake, CA · Accident · No injuries · Closed · Oct 31, 1980 · N1732Q · Destroyed
- [NTSB LAX80DVG05](https://openairdocs.org/ntsb/LAX80DVG05-128546.md): Erco 415-C · Cottonwood, CA · Accident · No injuries · Closed · Oct 31, 1980 · N93420 · Substantial damage
- [NTSB CHI81FEI05](https://openairdocs.org/ntsb/CHI81FEI05.md): Cessna 152 · Port Clinton, OH · Accident · No injuries · Closed · Oct 31, 1980 · N47316 · Substantial damage
- [NTSB ATL81FA011](https://openairdocs.org/ntsb/ATL81FA011.md): Cessna T210M · Pearson, GA · Accident · 1 fatal · Closed · Oct 31, 1980 · N761HK · Destroyed
- [NTSB NYC81FHD06](https://openairdocs.org/ntsb/NYC81FHD06.md): Cessna 150K · Coatsville, PA · Accident · Serious injuries · Closed · Oct 30, 1980 · N6040G · Destroyed
- [NTSB LAX81FVD05](https://openairdocs.org/ntsb/LAX81FVD05.md): Cessna 152 · Napa, CA · Accident · Serious injuries · Closed · Oct 29, 1980 · N5455B · Destroyed
- [NTSB ATL81IA009](https://openairdocs.org/ntsb/ATL81IA009.md): Beech A60 · Leaksville, MS · Incident · No injuries · Closed · Oct 29, 1980 · N7578D · Minor damage
- [NTSB SEA81FA003](https://openairdocs.org/ntsb/SEA81FA003.md): Cessna 172 · Craigmont, ID · Accident · 1 fatal · Closed · Oct 26, 1980 · N9109B · Destroyed
- [NTSB FTW81FPJ04](https://openairdocs.org/ntsb/FTW81FPJ04.md): Aero Comdr 100 · Hobart, OK · Accident · Serious injuries · Closed · Oct 26, 1980 · N3701X · Destroyed
- [NTSB CHI81FER04](https://openairdocs.org/ntsb/CHI81FER04.md): Aeronca 11AC · Clyndon, MN · Accident · Minor injuries · Closed · Oct 26, 1980 · N85906 · Substantial damage
- [NTSB CHI81FCA04](https://openairdocs.org/ntsb/CHI81FCA04.md): Piper PA-32 · St Jacob, IL · Accident · Serious injuries · Closed · Oct 26, 1980 · N10DR · Destroyed
- [NTSB DEN81FTC04](https://openairdocs.org/ntsb/DEN81FTC04.md): Cessna 150M · Casper, WY · Accident · Minor injuries · Closed · Oct 25, 1980 · N345JF · Destroyed
- [NTSB FTW81FPD04](https://openairdocs.org/ntsb/FTW81FPD04.md): Cessna 182 · Ft Worth, TX · Accident · No injuries · Closed · Oct 24, 1980 · N6050B · Substantial damage
- [NTSB LAX81FVG01](https://openairdocs.org/ntsb/LAX81FVG01.md): Porterfield 35W · Citrus Heights, CA · Accident · 2 fatal · Closed · Oct 18, 1980 · N18520 · Destroyed
- [NTSB FTW81FRA03](https://openairdocs.org/ntsb/FTW81FRA03.md): Piper PA-23 · Houston, TX · Accident · Minor injuries · Closed · Oct 18, 1980 · N4859P · Substantial damage
- [NTSB NYC81DHM01](https://openairdocs.org/ntsb/NYC81DHM01.md): Cessna 177 · Pleasant Vly, NY · Accident · No injuries · Closed · Oct 17, 1980 · N333T · Substantial damage
- [NTSB MIA810A005](https://openairdocs.org/ntsb/MIA810A005.md): Boeing 707 · Kingston (Atlantic Ocean) · Accident · Serious injuries · Closed · Oct 17, 1980 · N8406 · No damage
- [NTSB DEN81FA007](https://openairdocs.org/ntsb/DEN81FA007.md): Beech 65 · Sula, MT · Accident · 3 fatal · Closed · Oct 17, 1980 · N35CS · Destroyed
- [NTSB DEN80FAMS1](https://openairdocs.org/ntsb/DEN80FAMS1.md): Mooney M20F · Buffalo, WY · Accident · 2 fatal · Closed · Oct 17, 1980 · N9182V · Destroyed
- [NTSB LAX81FUJ04](https://openairdocs.org/ntsb/LAX81FUJ04.md): Mooney M20C · Willcox, AZ · Accident · No injuries · Closed · Oct 16, 1980 · N9350V · Substantial damage
- [NTSB LAX81FJA02](https://openairdocs.org/ntsb/LAX81FJA02.md): Piper J3-65D · Waialua, HI · Accident · Serious injuries · Closed · Oct 16, 1980 · N62222 · Substantial damage
- [NTSB LAX81FA004](https://openairdocs.org/ntsb/LAX81FA004.md): Cessna T210 · Sacramento, CA · Accident · 1 fatal · Closed · Oct 16, 1980 · N6137B · Destroyed
- [NTSB ATL80FLG01](https://openairdocs.org/ntsb/ATL80FLG01.md): Grumman G-164B · Kingstree, SC · Accident · No injuries · Closed · Oct 16, 1980 · N6605K · Substantial damage
- [NTSB SEA81FA002](https://openairdocs.org/ntsb/SEA81FA002.md): Cessna 182Q · Ashland, OR · Accident · 1 fatal · Closed · Oct 15, 1980 · N735PZ · Destroyed
- [NTSB NYC81FHA02](https://openairdocs.org/ntsb/NYC81FHA02.md): Dornier D0-28 · Scranton, PA · Accident · No injuries · Closed · Oct 15, 1980 · 4X-CFA · Substantial damage
- [NTSB FTW81FA004](https://openairdocs.org/ntsb/FTW81FA004.md): Beech V35A · Cedar Hill, TX · Accident · 2 fatal · Closed · Oct 15, 1980 · N1780A · Destroyed
- [NTSB LAX81FA002](https://openairdocs.org/ntsb/LAX81FA002.md): Piper PA-28 · Crestline, CA · Accident · 4 fatal · Closed · Oct 14, 1980 · N2212D · Destroyed
- [NTSB CHI81FA001](https://openairdocs.org/ntsb/CHI81FA001.md): Cessna 337H · Waterford, MI · Accident · 3 fatal · Closed · Oct 14, 1980 · N1333L · 2 aircraft · Destroyed
- [NTSB MKC81FCA12](https://openairdocs.org/ntsb/MKC81FCA12.md): Cessna 182N · Salem, MO · Accident · Minor injuries · Closed · Oct 13, 1980 · N92200 · Destroyed
- [NTSB MIA81DLD04](https://openairdocs.org/ntsb/MIA81DLD04.md): Bell 47J · Yeehaw Jnction, FL · Accident · No injuries · Closed · Oct 13, 1980 · N16082 · Substantial damage
- [NTSB ATL81DLQ03](https://openairdocs.org/ntsb/ATL81DLQ03.md): Cessna 172M · Waddy, KY · Accident · Serious injuries · Closed · Oct 13, 1980 · N64517 · Substantial damage
- [NTSB FTW81DRA01](https://openairdocs.org/ntsb/FTW81DRA01.md): Navion B · Beaumont, TX · Accident · No injuries · Closed · Oct 12, 1980 · N2WD · Substantial damage
- [NTSB LAX81FVD03](https://openairdocs.org/ntsb/LAX81FVD03.md): Piper PA-28 · Castro Valley, CA · Accident · Serious injuries · Closed · Oct 11, 1980 · N9754W · Substantial damage
- [NTSB FTW81FPJ01](https://openairdocs.org/ntsb/FTW81FPJ01.md): Piper PA-38 · Stillwater, OK · Accident · Minor injuries · Closed · Oct 11, 1980 · N2592B · Destroyed
- [NTSB FTW81DQD02](https://openairdocs.org/ntsb/FTW81DQD02.md): Prue Super · Alamogordo, NM · Accident · Serious injuries · Closed · Oct 11, 1980 · N86676 · Substantial damage
- [NTSB ATL81FA006](https://openairdocs.org/ntsb/ATL81FA006.md): Cessna 172 · Roanoke, VA · Accident · 4 fatal · Closed · Oct 10, 1980 · N7644T · Destroyed
- [NTSB ATL81FA005](https://openairdocs.org/ntsb/ATL81FA005.md): Beech 35 · Dargan, MD · Accident · 3 fatal · Closed · Oct 10, 1980 · N418F · Destroyed
- [NTSB ANC81DAA04](https://openairdocs.org/ntsb/ANC81DAA04.md): Stinson 108-3 · Nenana, AK · Accident · Serious injuries · Closed · Oct 9, 1980 · N985C · Substantial damage
- [NTSB SEA81DYM06](https://openairdocs.org/ntsb/SEA81DYM06.md): Bell 206L-1 · Cougar, WA · Accident · No injuries · Closed · Oct 8, 1980 · N2756N · Substantial damage
- [NTSB NYC81FHD02](https://openairdocs.org/ntsb/NYC81FHD02.md): Blimp EA-1 · Lakehurst, NJ · Accident · No injuries · Closed · Oct 8, 1980 · N5499A · Substantial damage
- [NTSB FTW81FQA03](https://openairdocs.org/ntsb/FTW81FQA03.md): Barnes AX7 · Albuquerque, NM · Accident · No injuries · Closed · Oct 8, 1980 · N115JB · Substantial damage
- [NTSB FTW81FQA02](https://openairdocs.org/ntsb/FTW81FQA02.md): Raven S-50A · Albuquerque, NM · Accident · Minor injuries · Closed · Oct 7, 1980 · N51520 · Substantial damage
- [NTSB SEA81FYP01](https://openairdocs.org/ntsb/SEA81FYP01.md): Piper PA-22 · Waterville, WA · Accident · Serious injuries · Closed · Oct 6, 1980 · N7710D · Substantial damage
- [NTSB MIA81DLD02](https://openairdocs.org/ntsb/MIA81DLD02.md): Cessna 152 · St Petersburg, FL · Accident · No injuries · Closed · Oct 5, 1980 · N48995 · Destroyed
- [NTSB FTW81FQA01](https://openairdocs.org/ntsb/FTW81FQA01.md): Cessna 195B · Chama, NM · Accident · No injuries · Closed · Oct 5, 1980 · N3053B · Substantial damage

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

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

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