# NTSB investigations, 1995, SC: 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.

## Latest cases

- [NTSB MIA96LA052](https://openairdocs.org/ntsb/MIA96LA052.md): Mooney M20 · Eastover, SC · Accident · Minor injuries · Limited investigation · Final report · Dec 30, 1995 · N3750H · Substantial damage
  > inadequate overhaul procedures by maintenance personnel resulting in an oil pump failure and subsequent loss of engine power.
- [NTSB ATL96FA022](https://openairdocs.org/ntsb/ATL96FA022.md): Piper PA-46-310P · Greenwood, SC · Accident · 1 fatal · Field investigation · Final report · Dec 14, 1995 · N9102V · Substantial damage
  > the loss of engine power for undetermined reason.
- [NTSB ATL96LA031](https://openairdocs.org/ntsb/ATL96LA031.md): Cessna 150M · Beaufort, SC · Accident · No injuries · Limited investigation · Final report · Dec 1, 1995 · N8779U · Substantial damage
  > An inadequate preflight which resulted in water contamination in the fuel system and the subsequent loss of engine power. The tree stump was a factor.
- [NTSB ATL95LA172](https://openairdocs.org/ntsb/ATL95LA172.md): Grumman G-164A · Lynchburg, SC · Accident · No injuries · Limited investigation · Final report · Sep 22, 1995 · N9700 · Substantial damage
  > The failure of the magneto mount pad, which resulted in a malfunction of the magneto timing and partial loss of engine power. A factor relating to the accident was: high vegetation in the emergency landing area.
- [NTSB ATL95LA134](https://openairdocs.org/ntsb/ATL95LA134.md): Stafford Aerosport Scamp · Abbeville, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1995 · N99TJ · Substantial damage
  > The improper engine overhaul which resulted in metal contamination of the engine assembly.
- [NTSB ATL95LA132](https://openairdocs.org/ntsb/ATL95LA132.md): Cessna 310 · Ridgeland, SC · Accident · No injuries · Limited investigation · Final report · Jul 12, 1995 · N3083D · Substantial damage
  > The pilot's failure to assure that the airplane's alternators were on which led to a complete loss of electrical power, and his failure to attempt to lower the landing gear by emergency procedures.
- [NTSB ATL95LA131](https://openairdocs.org/ntsb/ATL95LA131.md): PZL Koliber -150A · Pickens, SC · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 1995 · N150AE · Destroyed
  > the inadequate design and operation of the induction airbox. A factor in the accident was the carburetor icing weather conditions.
- [NTSB ATL95LA103](https://openairdocs.org/ntsb/ATL95LA103.md): Mooney M20E · Moncks Corner, SC · Accident · Serious injuries · Limited investigation · Final report · Jun 3, 1995 · N6923U · Substantial damage
  > The pilot's failure to properly calculate the fuel required and his fuel consumption for the flight.
- [NTSB ATL95LA056](https://openairdocs.org/ntsb/ATL95LA056.md): Piper PA-28-140 · Charleston, SC · Accident · Minor injuries · Limited investigation · Final report · Mar 3, 1995 · N7498R · Substantial damage
  > The failure of the position washer in the fuel selector valve, which resulted in the fuel starvation of the engine.
- [NTSB MIA95FA060](https://openairdocs.org/ntsb/MIA95FA060.md): Piper PA-28-236 · York, SC · Accident · 2 fatal · Field investigation · Final report · Jan 19, 1995 · N8423B · Destroyed
  > The noninstrument-rated pilot's failure to maintain control of the airplane due to spatial disorientation while conducting flight in instrument meteorological conditions (IMC). A factor relating to the accident was: failure of the pilot to follow…

## 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 year(c."eventDate") = 1995
  AND c."eventStateOrRegion" = 'SC' AND c."eventCountry" = 'USA'
  AND 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?state=SC&year=1995

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