# Final NTSB investigations, PA: Uncontrolled descent

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 BFO93LA180](https://openairdocs.org/ntsb/BFO93LA180.md): Robinson R22 · Scottdale, PA · Accident · No injuries · Limited investigation · Final report · Sep 19, 1993 · N88RD · Substantial damage
  > The pilot's selection of unsuitable terrain for landing and his delay in performing remedial action.
- [NTSB NYC82FGT04](https://openairdocs.org/ntsb/NYC82FGT04.md): Carver HP-14B · Altoona, PA · Accident · 1 fatal · Closed · Nov 7, 1981 · N3320X · Destroyed
- [NTSB NYC81FA070](https://openairdocs.org/ntsb/NYC81FA070.md): Piper PA-32 · Easton, PA · Accident · 6 fatal · Closed · Jul 1, 1981 · N54383 · Destroyed
- [NTSB NYC81FA010](https://openairdocs.org/ntsb/NYC81FA010.md): Beech H18 · Troxelville, PA · Accident · 1 fatal · Closed · Nov 18, 1980 · N701CC · Destroyed
- [NTSB NYC80FGT21](https://openairdocs.org/ntsb/NYC80FGT21.md): Bensen B-8M · Columbia, PA · Accident · 1 fatal · Closed · Sep 8, 1980 · N3776N · Destroyed
- [NTSB NYC80FA022](https://openairdocs.org/ntsb/NYC80FA022-201184.md): Cessna 152 · Indian Head, PA · Accident · 1 fatal · Closed · Jan 29, 1980 · N68326 · Substantial damage
- [NTSB NYC79FA090](https://openairdocs.org/ntsb/NYC79FA090.md): Piper PA-28 · No.Whitehall, PA · Accident · 3 fatal · Closed · Sep 5, 1979 · N6275W · Destroyed
- [NTSB NYC78FA009](https://openairdocs.org/ntsb/NYC78FA009.md): Piper PA-28R · North Wales, PA · Accident · 1 fatal · Closed · Nov 23, 1977 · N1018L · Destroyed
- [NTSB NYC77FA037](https://openairdocs.org/ntsb/NYC77FA037.md): Cessna U206F · Doylestown, PA · Accident · 2 fatal · Closed · Mar 13, 1977 · N35634 · Substantial damage
- [NTSB NYC77FA014](https://openairdocs.org/ntsb/NYC77FA014.md): Cessna 172M · Conneautville, PA · Accident · 1 fatal · Closed · Nov 20, 1976 · N80778 · Destroyed
- [NTSB NYC77FA012](https://openairdocs.org/ntsb/NYC77FA012.md): Piper PA-22 · Warren Center, PA · Accident · 1 fatal · Closed · Nov 12, 1976 · N973A · Destroyed
- [NTSB NYC77FA005](https://openairdocs.org/ntsb/NYC77FA005.md): Piper PA-28 · Frenchville, PA · Accident · 1 fatal · Closed · Oct 17, 1976 · N4189J · Destroyed
- [NTSB NYC76AN007](https://openairdocs.org/ntsb/NYC76AN007.md): Piper PA-28 · Benton, PA · Accident · 1 fatal · Closed · Jul 16, 1975 · N4843L · Destroyed
- [NTSB NYC76AN005](https://openairdocs.org/ntsb/NYC76AN005.md): Mooney M20C · Newtown, PA · Accident · 1 fatal · Closed · Jul 14, 1975 · N4030N · Destroyed
- [NTSB NYC75AN069](https://openairdocs.org/ntsb/NYC75AN069.md): Cessna 182 · Erie, PA · Accident · 4 fatal · Closed · Nov 28, 1974 · N2433X · Destroyed
- [NTSB NYC75AN046](https://openairdocs.org/ntsb/NYC75AN046.md): N.American F-51D · Chatham, PA · Accident · 1 fatal · Closed · Oct 13, 1974 · N5412V · Destroyed
- [NTSB NYC75AN039](https://openairdocs.org/ntsb/NYC75AN039.md): Cessna 172H · Bluebell, PA · Accident · 2 fatal · Closed · Sep 20, 1974 · N3258L · Destroyed
- [NTSB NYC75AN022](https://openairdocs.org/ntsb/NYC75AN022.md): Cessna 172 · Catasauqua, PA · Accident · 2 fatal · Closed · Aug 23, 1974 · N8191L · Destroyed
- [NTSB NYC75AN001](https://openairdocs.org/ntsb/NYC75AN001.md): Piper PA-23 · Acme, PA · Accident · 5 fatal · Closed · Jul 4, 1974 · N5084Y · Destroyed
- [NTSB NYC74AN014](https://openairdocs.org/ntsb/NYC74AN014-201627.md): Cessna 172K · Huntingdon Vly, PA · Accident · 1 fatal · Closed · Aug 13, 1973 · N7060G · Destroyed
- [NTSB NYC72AN157](https://openairdocs.org/ntsb/NYC72AN157.md): Beech 23 · Spring Run, PA · Accident · 3 fatal · Closed · Jun 18, 1972 · N2378Q · Destroyed
- [NTSB NYC72AN085](https://openairdocs.org/ntsb/NYC72AN085.md): Piper PA-28 · Malvern, PA · Accident · 1 fatal · Closed · Dec 30, 1971 · N6047W · Destroyed
- [NTSB NYC72AN083](https://openairdocs.org/ntsb/NYC72AN083.md): Cessna 150B · Allentown, PA · Accident · 1 fatal · Closed · Dec 24, 1971 · N1180Y · Destroyed
- [NTSB NYC72AN061](https://openairdocs.org/ntsb/NYC72AN061.md): Piper PA-28 · Boalsburg, PA · Accident · 4 fatal · Closed · Oct 31, 1971 · N9287J · Destroyed
- [NTSB NYC72AN051](https://openairdocs.org/ntsb/NYC72AN051.md): Piper PA-28R · Washingtnville, PA · Accident · 1 fatal · Closed · Oct 10, 1971 · N2941R · Destroyed
- [NTSB NYC72FGM03](https://openairdocs.org/ntsb/NYC72FGM03.md): Brantly B2B · Williamsburg, PA · Accident · No injuries · Closed · Jul 10, 1971 · N2180U · Substantial damage
- [NTSB IAD71AI054](https://openairdocs.org/ntsb/IAD71AI054.md): Cessna 310C · Dunlo, PA · Accident · 4 fatal · Closed · May 27, 1971 · N1765H · Destroyed
- [NTSB NYC71AN087](https://openairdocs.org/ntsb/NYC71AN087.md): Piper PA-28 · Hallstead, PA · Accident · 3 fatal · Closed · Feb 17, 1971 · N9711J · Destroyed
- [NTSB NYC71AN063](https://openairdocs.org/ntsb/NYC71AN063.md): Cessna 310P · Grove City, PA · Accident · 3 fatal · Closed · Nov 20, 1970 · N5789M · Destroyed
- [NTSB NYC70AN135](https://openairdocs.org/ntsb/NYC70AN135.md): Piper PA-32 · Wilkes-Barre, PA · Accident · 1 fatal · Closed · Jun 27, 1970 · N4707S · Destroyed
- [NTSB NYC69A0109](https://openairdocs.org/ntsb/NYC69A0109.md): Piper J-3 · Reading, PA · Accident · 1 fatal · Closed · Jun 4, 1969 · N42637 · Destroyed
- [NTSB NYC69A0053](https://openairdocs.org/ntsb/NYC69A0053.md): Piper PA-23 · Churchville, PA · Accident · 4 fatal · Closed · Nov 7, 1968 · N4946P · Destroyed
- [NTSB NYC69A0026](https://openairdocs.org/ntsb/NYC69A0026.md): Piper PA-24 · Dallas, PA · Accident · 3 fatal · Closed · Sep 2, 1968 · N5578P · Destroyed
- [NTSB NYC68A0134](https://openairdocs.org/ntsb/NYC68A0134.md): Piper PA-28R · Gardners, PA · Accident · 4 fatal · Closed · Jun 16, 1968 · N3783T · Destroyed
- [NTSB NYC68A0132](https://openairdocs.org/ntsb/NYC68A0132.md): Piper PA-28 · Cairnbrook, PA · Accident · 1 fatal · Closed · Jun 13, 1968 · N9857W · Destroyed
- [NTSB NYC68A0120](https://openairdocs.org/ntsb/NYC68A0120.md): Piper PA-22 · Johnstown, PA · Accident · 1 fatal · Closed · May 18, 1968 · N3710P · Destroyed
- [NTSB NYC68A0116](https://openairdocs.org/ntsb/NYC68A0116.md): Beech C-33A · Granville, PA · Accident · 2 fatal · Closed · Apr 25, 1968 · N779AA · Destroyed
- [NTSB NYC68A0049](https://openairdocs.org/ntsb/NYC68A0049.md): Cessna 182 · Rothsville, PA · Accident · 2 fatal · Closed · Sep 21, 1967 · N6362A · Destroyed
- [NTSB NYC67F0584](https://openairdocs.org/ntsb/NYC67F0584.md): Cessna 172 · Harrow, PA · Accident · Minor injuries · Closed · Apr 6, 1967 · N1196F · Destroyed
- [NTSB NYC67F0497](https://openairdocs.org/ntsb/NYC67F0497.md): Cessna 150 · Tyrone, PA · Accident · No injuries · Closed · Feb 4, 1967 · N3446J · Destroyed
- [NTSB NYC67A0102](https://openairdocs.org/ntsb/NYC67A0102.md): Cessna 150 · Fombell, PA · Accident · 2 fatal · Closed · Jan 18, 1967 · N7754F · Destroyed
- [NTSB NYC67A0077](https://openairdocs.org/ntsb/NYC67A0077.md): Beech S35 · Columbia X-Rds, PA · Accident · 3 fatal · Closed · Nov 7, 1966 · N6030F · Destroyed
- [NTSB NYC66A0102](https://openairdocs.org/ntsb/NYC66A0102.md): Piper PA-28 · Falls Creek, PA · Accident · 2 fatal · Closed · Mar 18, 1966 · N8181W · Destroyed
- [NTSB NYC66A0032](https://openairdocs.org/ntsb/NYC66A0032.md): Stinson 108-3 · Milroy, PA · Accident · 1 fatal · Closed · Sep 5, 1965 · N6353M · Destroyed
- [NTSB NYC65A0126](https://openairdocs.org/ntsb/NYC65A0126.md): Beechcraft D50 · Hollidaysburg, PA · Accident · 3 fatal · Closed · Apr 18, 1965 · N4341D · Destroyed
- [NTSB NYC65A0124](https://openairdocs.org/ntsb/NYC65A0124.md): Piper PA-25 · Philipsburg, PA · Accident · 1 fatal · Closed · Apr 7, 1965 · N7335Z · Destroyed

## 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."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 650)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/650/cases?state=PA&status=final

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