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

## Cases, newest first

- [NTSB CHI78FEP68](https://openairdocs.org/ntsb/CHI78FEP68.md): Mooney M20F · Racine, WI · Accident · No injuries · Closed · Sep 11, 1978 · N9275V · Substantial damage
- [NTSB NYC78FFA32](https://openairdocs.org/ntsb/NYC78FFA32.md): Cessna 182C · Hudson, NY · Accident · No injuries · Closed · Sep 10, 1978 · N8956T · Substantial damage
- [NTSB NYC78FA090](https://openairdocs.org/ntsb/NYC78FA090.md): Piper PA-32 · Honesdale, PA · Accident · 2 fatal · Closed · Sep 10, 1978 · N789CC · Destroyed
- [NTSB MIA78FLD73](https://openairdocs.org/ntsb/MIA78FLD73.md): Gyrocopter 1 · Dunnellon, FL · Accident · 1 fatal · Closed · Sep 10, 1978 · NONE · Destroyed
- [NTSB FTW78FA080](https://openairdocs.org/ntsb/FTW78FA080.md): Beech V35 · Alexandria, LA · Accident · 1 fatal · Closed · Sep 10, 1978 · N5642S · Destroyed
- [NTSB FTW78DPG88](https://openairdocs.org/ntsb/FTW78DPG88.md): Grumman G-164A · Bald Knob, AR · Accident · Minor injuries · Closed · Sep 10, 1978 · N9652 · Destroyed
- [NTSB CHI78FA065](https://openairdocs.org/ntsb/CHI78FA065.md): Cessna 172K · Mackinaw City, MI · Accident · 3 fatal · Closed · Sep 10, 1978 · N84380 · Destroyed
- [NTSB SEA78FYK21](https://openairdocs.org/ntsb/SEA78FYK21.md): Cessna 182B · Azalea, OR · Accident · No injuries · Closed · Sep 9, 1978 · N2465G · Substantial damage
- [NTSB MKC78DER92](https://openairdocs.org/ntsb/MKC78DER92.md): Cessna P337H · Jacobsen, MN · Accident · No injuries · Closed · Sep 9, 1978 · N4CZ · Substantial damage
- [NTSB MKC78DCG66](https://openairdocs.org/ntsb/MKC78DCG66.md): Cessna 152 · Waverly, KS · Accident · No injuries · Closed · Sep 9, 1978 · N25478 · Substantial damage
- [NTSB FTW78DQG49](https://openairdocs.org/ntsb/FTW78DQG49.md): Cessna 172 · Colorado City, TX · Accident · Serious injuries · Closed · Sep 9, 1978 · N19909 · Substantial damage
- [NTSB DEN78DQD36](https://openairdocs.org/ntsb/DEN78DQD36.md): Cessna 152 · Deming, NM · Accident · No injuries · Closed · Sep 9, 1978 · N757PC · Substantial damage
- [NTSB OAK78FA049](https://openairdocs.org/ntsb/OAK78FA049.md): Beech C-24R · Big Sur, CA · Accident · 4 fatal · Closed · Sep 8, 1978 · N23994 · Destroyed
- [NTSB MIA78FA122](https://openairdocs.org/ntsb/MIA78FA122.md): Piper PA-38 · Florence, SC · Accident · 2 fatal · Closed · Sep 8, 1978 · N4425E · Destroyed
- [NTSB SEA78FA063](https://openairdocs.org/ntsb/SEA78FA063.md): Piper PA-28 · Sisters, OR · Accident · 4 fatal · Closed · Sep 7, 1978 · N39499 · Destroyed
- [NTSB LAX78FA075](https://openairdocs.org/ntsb/LAX78FA075.md): Cessna 402B · Hyder, AZ · Accident · No injuries · Closed · Sep 7, 1978 · N7866Q · Destroyed
- [NTSB ANC78DAH14](https://openairdocs.org/ntsb/ANC78DAH14.md): Piper J5B · Kenai, AK · Accident · No injuries · Closed · Sep 7, 1978 · N49387 · Substantial damage
- [NTSB OAK78FA050](https://openairdocs.org/ntsb/OAK78FA050.md): Piper PA-24 · Mariposa, CA · Accident · 3 fatal · Closed · Sep 6, 1978 · N6576P · Destroyed
- [NTSB MKC78FCJ44](https://openairdocs.org/ntsb/MKC78FCJ44.md): Piper PA-28R · Humboldt, NE · Accident · No injuries · Closed · Sep 6, 1978 · N75358 · Substantial damage
- [NTSB FTW78FA075](https://openairdocs.org/ntsb/FTW78FA075.md): Douglas DC-7C · Farmersville, LA · Accident · 1 fatal · Closed · Sep 6, 1978 · N244B · Destroyed
- [NTSB NYC78FFJ37](https://openairdocs.org/ntsb/NYC78FFJ37.md): Grum Amer AA-5B · Cortland, NY · Accident · Minor injuries · Closed · Sep 5, 1978 · N74355 · Substantial damage
- [NTSB FTW78DPG84](https://openairdocs.org/ntsb/FTW78DPG84.md): Cessna 188 · West Point, AR · Accident · No injuries · Closed · Sep 5, 1978 · N8277G · Substantial damage
- [NTSB OAK78FVA80](https://openairdocs.org/ntsb/OAK78FVA80.md): Cessna 150F · Fowler, CA · Accident · No injuries · Closed · Sep 4, 1978 · N3523L · Substantial damage
- [NTSB OAK78FA047](https://openairdocs.org/ntsb/OAK78FA047.md): Piper PA-28R · Auburn, CA · Accident · 1 fatal · Closed · Sep 4, 1978 · N9530K · Destroyed
- [NTSB NYC78FA088](https://openairdocs.org/ntsb/NYC78FA088.md): Hughes 269C · Derry, PA · Accident · No injuries · Closed · Sep 4, 1978 · N7466F · Substantial damage
- [NTSB IAD78FA106](https://openairdocs.org/ntsb/IAD78FA106.md): Hughes 269B · Damascus, MD · Accident · No injuries · Closed · Sep 4, 1978 · N9568F · Destroyed
- [NTSB FTW78FRD55](https://openairdocs.org/ntsb/FTW78FRD55.md): Piper PA-25 · Leonville, LA · Accident · No injuries · Closed · Sep 4, 1978 · N9807P · Substantial damage
- [NTSB SEA78FTA21](https://openairdocs.org/ntsb/SEA78FTA21.md): Piper PA-18 · Miles City, MT · Accident · No injuries · Closed · Sep 3, 1978 · N9897D · Substantial damage
- [NTSB SEA78FA060](https://openairdocs.org/ntsb/SEA78FA060.md): Piper J3C · Mccall, ID · Accident · 2 fatal · Closed · Sep 3, 1978 · N88185 · Destroyed
- [NTSB NYC78FA087](https://openairdocs.org/ntsb/NYC78FA087.md): Cessna 150 · Dover, NJ · Accident · 1 fatal · Closed · Sep 3, 1978 · N704QG · Substantial damage
- [NTSB MKC78FCQ38](https://openairdocs.org/ntsb/MKC78FCQ38.md): Cessna 177RG · Wellington, KS · Accident · No injuries · Closed · Sep 3, 1978 · N45318 · Substantial damage
- [NTSB CHI78FEP65](https://openairdocs.org/ntsb/CHI78FEP65.md): Cessna 177B · Junction City, WI · Accident · Serious injuries · Closed · Sep 3, 1978 · N35121 · Destroyed
- [NTSB CHI78FEC51](https://openairdocs.org/ntsb/CHI78FEC51.md): Cessna 152 · Clawson, MI · Accident · No injuries · Closed · Sep 3, 1978 · N757RP · Substantial damage
- [NTSB OAK78DXQ45](https://openairdocs.org/ntsb/OAK78DXQ45.md): Cessna 150 · S.Lake Tahoe, CA · Accident · Minor injuries · Closed · Sep 2, 1978 · N8130S · Substantial damage
- [NTSB NYC78FHJ24](https://openairdocs.org/ntsb/NYC78FHJ24.md): Piper PA-24 · North Castle, NY · Accident · Minor injuries · Closed · Sep 2, 1978 · N7388P · Destroyed
- [NTSB MKC78FER91](https://openairdocs.org/ntsb/MKC78FER91.md): Benson RW-B8M · Winona, MN · Accident · Minor injuries · Closed · Sep 2, 1978 · N47199 · Substantial damage
- [NTSB DCA78AA021](https://openairdocs.org/ntsb/DCA78AA021.md): Grumman G-21A · St Thomas, VI · Accident · 4 fatal · Closed · Sep 2, 1978 · N7777V · Destroyed
- [NTSB SEA78FYP50](https://openairdocs.org/ntsb/SEA78FYP50.md): Cessna T210M · Spokane, WA · Accident · Minor injuries · Closed · Sep 1, 1978 · N761CM · Substantial damage
- [NTSB IAD78FA104](https://openairdocs.org/ntsb/IAD78FA104.md): Hughes 269C · Robbinsville, NC · Accident · 2 fatal · Closed · Sep 1, 1978 · N9295F · Destroyed
- [NTSB FTW78FPD31](https://openairdocs.org/ntsb/FTW78FPD31.md): Cessna 172K · Saginaw, TX · Accident · Minor injuries · Closed · Sep 1, 1978 · N84159 · Substantial damage
- [NTSB CHI78FEV52](https://openairdocs.org/ntsb/CHI78FEV52.md): Beech 23 · Minonk, IL · Accident · No injuries · Closed · Sep 1, 1978 · N2301J · Substantial damage
- [NTSB CHI78FEP69](https://openairdocs.org/ntsb/CHI78FEP69.md): Cessna 172F · Sauk Prairie, WI · Accident · No injuries · Closed · Sep 1, 1978 · N8312U · Substantial damage
- [NTSB FTW78FRJ32](https://openairdocs.org/ntsb/FTW78FRJ32.md): Cessna 150J · Mooringsport, LA · Accident · Minor injuries · Closed · Aug 31, 1978 · N50835 · Substantial damage
- [NTSB CHI78IA061](https://openairdocs.org/ntsb/CHI78IA061.md): Lockheed L-1011 · Chicago, IL · Incident · No injuries · Closed · Aug 31, 1978 · N701DA · No damage
- [NTSB ANC78FA071](https://openairdocs.org/ntsb/ANC78FA071.md): Piper PA-18 · Cooper Landing, AK · Accident · 2 fatal · Closed · Aug 31, 1978 · N8838L · Destroyed
- [NTSB ANC78FA070](https://openairdocs.org/ntsb/ANC78FA070.md): Beech A36 · Ketchikan, AK · Accident · 6 fatal · Closed · Aug 31, 1978 · N17593 · Destroyed
- [NTSB LAX78FA072](https://openairdocs.org/ntsb/LAX78FA072.md): Mooney M20 · Los Angeles, CA · Accident · 2 fatal · Closed · Aug 30, 1978 · N864B · Destroyed
- [NTSB IAD78FA100](https://openairdocs.org/ntsb/IAD78FA100.md): Cessna 172C · Creedmoor, NC · Accident · No injuries · Closed · Aug 30, 1978 · N8471X · Substantial damage
- [NTSB FTW78FA073](https://openairdocs.org/ntsb/FTW78FA073.md): Bell 206B · Intracstl City, LA · Accident · 4 fatal · Closed · Aug 30, 1978 · N9908K · Destroyed
- [NTSB MKC78DCD49](https://openairdocs.org/ntsb/MKC78DCD49.md): Bell 47G-5A · Manson, IA · Accident · No injuries · Closed · Aug 29, 1978 · N14841 · Substantial damage

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

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

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