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

## Cases, newest first

- [NTSB LAX81FA078](https://openairdocs.org/ntsb/LAX81FA078.md): Cessna 170A · Morgan Hill, CA · Accident · 3 fatal · Closed · Mar 20, 1979 · N9117A · Destroyed
- [NTSB DEN79FA032](https://openairdocs.org/ntsb/DEN79FA032.md): Mooney M20F · Crestone, CO · Accident · 3 fatal · Closed · Mar 19, 1979 · N3881N · Destroyed
- [NTSB CHI79FA036](https://openairdocs.org/ntsb/CHI79FA036.md): Piper PA-32 · Dekalb, IL · Accident · 6 fatal · Closed · Mar 19, 1979 · N4047R · Destroyed
- [NTSB OAK79DVW12](https://openairdocs.org/ntsb/OAK79DVW12.md): Beech P35 · Mormon Mesa, NV · Accident · No injuries · Closed · Mar 18, 1979 · N8665M · Substantial damage
- [NTSB MIA79FLD53](https://openairdocs.org/ntsb/MIA79FLD53.md): Piper PA-28 · Fellsmere, FL · Accident · Minor injuries · Closed · Mar 18, 1979 · N1131X · Destroyed
- [NTSB MIA79FKG25](https://openairdocs.org/ntsb/MIA79FKG25.md): Piper PA-24 · Hawkinsville, GA · Accident · No injuries · Closed · Mar 18, 1979 · N7622P · Substantial damage
- [NTSB DEN79FA030](https://openairdocs.org/ntsb/DEN79FA030.md): Aerostar 601P · Aspen, CO · Accident · 4 fatal · Closed · Mar 18, 1979 · N35FC · Destroyed
- [NTSB NYC79FFA15](https://openairdocs.org/ntsb/NYC79FFA15.md): Enstrom F-28C · Schroon Lake, NY · Accident · Serious injuries · Closed · Mar 17, 1979 · N604H · Substantial damage
- [NTSB CHI79FA035](https://openairdocs.org/ntsb/CHI79FA035.md): Piper PA-28 · Park Forrest, IL · Accident · 2 fatal · Closed · Mar 17, 1979 · N9458W · Destroyed
- [NTSB SEA79FA026](https://openairdocs.org/ntsb/SEA79FA026.md): Piper PA-22 · Spencer, ID · Accident · 3 fatal · Closed · Mar 16, 1979 · N4740A · Destroyed
- [NTSB CHI79DA034](https://openairdocs.org/ntsb/CHI79DA034.md): Cessna 150M · Spring Valley, OH · Accident · 1 fatal · Closed · Mar 16, 1979 · N704ZG · Destroyed
- [NTSB SEA79FYM19](https://openairdocs.org/ntsb/SEA79FYM19.md): Cessna T210N · John Day, OR · Accident · No injuries · Closed · Mar 15, 1979 · N7426N · Substantial damage
- [NTSB MKC79FCD15](https://openairdocs.org/ntsb/MKC79FCD15.md): Cessna 182Q · Tipton, IA · Accident · No injuries · Closed · Mar 15, 1979 · N759GU · Destroyed
- [NTSB MIA79FLD51](https://openairdocs.org/ntsb/MIA79FLD51.md): Cessna 172 · Cedar Key, FL · Accident · No injuries · Closed · Mar 15, 1979 · CF-SZZ · Substantial damage
- [NTSB CHI79DA033](https://openairdocs.org/ntsb/CHI79DA033.md): Cessna 150M · Adrian, MI · Accident · 1 fatal · Closed · Mar 15, 1979 · N9280U · Destroyed
- [NTSB LAX79IA033](https://openairdocs.org/ntsb/LAX79IA033.md): Cessna T210L · Lancaster, CA · Incident · 1 fatal · Closed · Mar 14, 1979 · N123DH · No damage
- [NTSB LAX79FUJ57](https://openairdocs.org/ntsb/LAX79FUJ57.md): Cessna 152 · Phoenix, AZ · Accident · No injuries · Closed · Mar 14, 1979 · N67700 · Substantial damage
- [NTSB IAD79FKM11](https://openairdocs.org/ntsb/IAD79FKM11.md): Cessna 172 · Lexington, NC · Accident · No injuries · Closed · Mar 14, 1979 · N738TD · Substantial damage
- [NTSB FTW79IA063](https://openairdocs.org/ntsb/FTW79IA063.md): Boeing 747 · Dallas, TX · Incident · 1 fatal · Closed · Mar 14, 1979 · N601BN · No damage
- [NTSB IAD79FLQ09](https://openairdocs.org/ntsb/IAD79FLQ09.md): Bell 47G4 · Russellville, KY · Accident · Minor injuries · Closed · Mar 12, 1979 · N1218W · Substantial damage
- [NTSB FTW79FQD08](https://openairdocs.org/ntsb/FTW79FQD08.md): Cessna 320D · El Paso, TX · Accident · No injuries · Closed · Mar 11, 1979 · N3322Q · Substantial damage
- [NTSB FTW79FPJ07](https://openairdocs.org/ntsb/FTW79FPJ07.md): Rockwell 114 · Billings, OK · Accident · No injuries · Closed · Mar 11, 1979 · N4740W · Substantial damage
- [NTSB MKC79FCD13](https://openairdocs.org/ntsb/MKC79FCD13.md): Mooney M-20G · Wellsburg, IA · Accident · No injuries · Closed · Mar 10, 1979 · N3613N · Substantial damage
- [NTSB MIA79FLT04](https://openairdocs.org/ntsb/MIA79FLT04.md): Piper PA-23 · Southaven, MS · Accident · No injuries · Closed · Mar 10, 1979 · N1125P · Substantial damage
- [NTSB ANC79FAG36](https://openairdocs.org/ntsb/ANC79FAG36.md): Cessna 172K · Wasilla, AK · Accident · Serious injuries · Closed · Mar 10, 1979 · N79435 · Substantial damage
- [NTSB ANC79DAG35](https://openairdocs.org/ntsb/ANC79DAG35.md): Cessna 180 · Palmer, AK · Accident · No injuries · Closed · Mar 10, 1979 · N63336 · Substantial damage
- [NTSB SEA79FA024](https://openairdocs.org/ntsb/SEA79FA024.md): Cessna 195 · Vancouver, WA · Accident · 1 fatal · Closed · Mar 9, 1979 · N195BC · Destroyed
- [NTSB MIA79FLD48](https://openairdocs.org/ntsb/MIA79FLD48.md): Piper PA-32 · Vero Beach, FL · Accident · 1 fatal · Closed · Mar 9, 1979 · N2114C · Destroyed
- [NTSB IAD79IA039](https://openairdocs.org/ntsb/IAD79IA039.md): Lear 24B · Greensboro, NC · Incident · No injuries · Closed · Mar 9, 1979 · N14BC · No damage
- [NTSB FTW79FA059](https://openairdocs.org/ntsb/FTW79FA059.md): Hughes 369D · Angleton, TX · Accident · 2 fatal · Closed · Mar 9, 1979 · N58333 · Destroyed
- [NTSB DEN79FTE26](https://openairdocs.org/ntsb/DEN79FTE26.md): Cessna 177 · Englewood, CO · Accident · No injuries · Closed · Mar 9, 1979 · N13757 · Substantial damage
- [NTSB LAX79FUG22](https://openairdocs.org/ntsb/LAX79FUG22.md): Cessna 172G · Apple Valley, CA · Accident · No injuries · Closed · Mar 8, 1979 · N3868L · Substantial damage
- [NTSB DEN79FA029](https://openairdocs.org/ntsb/DEN79FA029.md): Piper PA-24 · Corinne, UT · Accident · 2 fatal · Closed · Mar 8, 1979 · N6914P · Destroyed
- [NTSB SEA79FA023](https://openairdocs.org/ntsb/SEA79FA023.md): Lake 4-200 · Battle Ground, WA · Accident · 3 fatal · Closed · Mar 7, 1979 · N1229L · Destroyed
- [NTSB MIA79FKG22](https://openairdocs.org/ntsb/MIA79FKG22.md): Piper PA-28 · Jesup, GA · Accident · Minor injuries · Closed · Mar 7, 1979 · N4825T · Substantial damage
- [NTSB LAX80FA051](https://openairdocs.org/ntsb/LAX80FA051.md): Cessna 172 · Eureka, CA · Accident · 3 fatal · Closed · Mar 7, 1979 · N6788A · Destroyed
- [NTSB ANC79DAG37](https://openairdocs.org/ntsb/ANC79DAG37.md): Cessna 180 · Nelson Lagoon, AK · Accident · No injuries · Closed · Mar 7, 1979 · N65992 · Substantial damage
- [NTSB MIA79FLA16](https://openairdocs.org/ntsb/MIA79FLA16.md): Aeronca 7AC · Blakely, GA · Accident · No injuries · Closed · Mar 6, 1979 · N83796 · Substantial damage
- [NTSB IAD79FKW07](https://openairdocs.org/ntsb/IAD79FKW07.md): Piper PA-25 · Sparta, TN · Accident · No injuries · Closed · Mar 6, 1979 · N4390Y · Destroyed
- [NTSB CHI79FEV13](https://openairdocs.org/ntsb/CHI79FEV13.md): Sonerai I · Paris, IL · Accident · No injuries · Closed · Mar 6, 1979 · N36NA · Substantial damage
- [NTSB OAK79FVG19](https://openairdocs.org/ntsb/OAK79FVG19.md): Piper PA-28 · Galt, CA · Accident · No injuries · Closed · Mar 5, 1979 · N56649 · Substantial damage
- [NTSB MIA79DLD19](https://openairdocs.org/ntsb/MIA79DLD19.md): Piper PA-28 · Grant, FL · Accident · No injuries · Closed · Mar 5, 1979 · N38730 · Substantial damage
- [NTSB FTW79FPG21](https://openairdocs.org/ntsb/FTW79FPG21.md): Beech 58 · Fort Smith, AR · Accident · No injuries · Closed · Mar 5, 1979 · N4199S · Substantial damage
- [NTSB NYC79FA028](https://openairdocs.org/ntsb/NYC79FA028.md): Piper PA-28R · Palmerton, PA · Accident · 4 fatal · Closed · Mar 4, 1979 · N5964V · Destroyed
- [NTSB FTW79DRD16](https://openairdocs.org/ntsb/FTW79DRD16.md): Aero Comm 520 · New Orleans, LA · Accident · Minor injuries · Closed · Mar 4, 1979 · N4178B · Destroyed
- [NTSB OAK79AA020](https://openairdocs.org/ntsb/OAK79AA020.md): Beech 95 · Elko, NV · Accident · 4 fatal · Closed · Mar 3, 1979 · N644SE · Destroyed
- [NTSB NYC79FHM11](https://openairdocs.org/ntsb/NYC79FHM11.md): Stits Play · Montville, NJ · Accident · Minor injuries · Closed · Mar 3, 1979 · N2451 · Substantial damage
- [NTSB NYC79FA026](https://openairdocs.org/ntsb/NYC79FA026.md): Cessna 172 · Poland, ME · Accident · 2 fatal · Closed · Mar 3, 1979 · N738HR · Substantial damage
- [NTSB IAD79FIA07](https://openairdocs.org/ntsb/IAD79FIA07.md): Cessna 172 · Front Royal, VA · Accident · No injuries · Closed · Mar 3, 1979 · N5639T · Destroyed
- [NTSB NYC79FHD10](https://openairdocs.org/ntsb/NYC79FHD10.md): Bell 47G-4A · Seaside Park, NJ · Accident · No injuries · Closed · Mar 2, 1979 · N1385X · Substantial damage

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

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

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