# Final NTSB investigations, IN: 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 CHI96LA008](https://openairdocs.org/ntsb/CHI96LA008.md): Piper PA-22 · Crawfordsville, IN · Accident · Minor injuries · Limited investigation · Final report · Oct 15, 1995 · N834A · Destroyed
  > The pilot's premature raising of the flaps and the low airspeed.
- [NTSB CHI85FA301](https://openairdocs.org/ntsb/CHI85FA301.md): Bell 47G2A1 · Brook, IN · Accident · 1 fatal · Field investigation · Final report · Jul 20, 1985 · N1345A · Destroyed
  > The helicopter contacted the terrain in a flat attitude and rolled over during an autorotative landing. A witness stated an autorotation was entered at 800 ft AGL during which the plt made a 360 deg descending turn. An application of pwr was heard at an alt…
- [NTSB CHI82FA007](https://openairdocs.org/ntsb/CHI82FA007.md): Cessna 172 · Kokomo, IN · Accident · 4 fatal · Closed · Oct 22, 1981 · N21766 · Destroyed
- [NTSB CHI80DA061](https://openairdocs.org/ntsb/CHI80DA061.md): Aeronca C-3 · Luray, IN · Accident · 1 fatal · Closed · Aug 1, 1980 · N16291 · Substantial damage
- [NTSB CHI80FA013](https://openairdocs.org/ntsb/CHI80FA013.md): Cessna 177 · Gary, IN · Accident · 1 fatal · Closed · Dec 1, 1979 · N10412 · Destroyed
- [NTSB CHI79FA079](https://openairdocs.org/ntsb/CHI79FA079-196164.md): Cessna 310 · Blue Ridge, IN · Accident · 2 fatal · Closed · Aug 29, 1979 · N69618 · Destroyed
- [NTSB CHI79FA023](https://openairdocs.org/ntsb/CHI79FA023.md): Piper PA-28R · Memphis, IN · Accident · 2 fatal · Closed · Jan 19, 1979 · N1885F · Destroyed
- [NTSB CHI78FA066](https://openairdocs.org/ntsb/CHI78FA066.md): Brantley B-2B · Brook, IN · Accident · 1 fatal · Closed · Sep 11, 1978 · N2284U · Destroyed
- [NTSB CHI78FEX23](https://openairdocs.org/ntsb/CHI78FEX23.md): Hunter Mong GH-1 · Roll, IN · Accident · 1 fatal · Closed · Jul 9, 1978 · N132H · Destroyed
- [NTSB CHI788A011](https://openairdocs.org/ntsb/CHI788A011.md): Beech P35 · New Salem, IN · Accident · 5 fatal · Closed · Nov 17, 1977 · N9958Y · Destroyed
- [NTSB CHI77FEX49](https://openairdocs.org/ntsb/CHI77FEX49.md): Midget Mustng · Clinton, IN · Accident · Minor injuries · Closed · Sep 3, 1977 · N6141U · Substantial damage
- [NTSB CHI77FA018](https://openairdocs.org/ntsb/CHI77FA018.md): Piper PA-28 · Columbia City, IN · Accident · 3 fatal · Closed · Dec 25, 1976 · N1510J · Destroyed
- [NTSB CHI77FA011](https://openairdocs.org/ntsb/CHI77FA011.md): Cessna 195 · Roanoke, IN · Accident · 1 fatal · Closed · Dec 10, 1976 · N169CB · Destroyed
- [NTSB CHI76AC064](https://openairdocs.org/ntsb/CHI76AC064.md): Piper PA-28 · W.Terre Haute, IN · Accident · 2 fatal · Closed · May 28, 1976 · N6331R · Destroyed
- [NTSB CHI76AC063](https://openairdocs.org/ntsb/CHI76AC063.md): Cessna 310H · Richland City, IN · Accident · 1 fatal · Closed · May 27, 1976 · N1075Q · Destroyed
- [NTSB CHI76AC040](https://openairdocs.org/ntsb/CHI76AC040.md): Piper PA-30 · Monrovia, IN · Accident · 2 fatal · Closed · Dec 20, 1975 · N7785Y · Destroyed
- [NTSB CHI75AC092](https://openairdocs.org/ntsb/CHI75AC092-201282.md): Piper PA-22 · Port Isabel, IN · Accident · 1 fatal · Closed · Jun 3, 1975 · N3578V · Destroyed
- [NTSB CHI75AC072](https://openairdocs.org/ntsb/CHI75AC072.md): Piper PA-24 · Cincinnati, IN · Accident · 1 fatal · Closed · Mar 23, 1975 · N7514P · Destroyed
- [NTSB NYC74AN072](https://openairdocs.org/ntsb/NYC74AN072.md): Cessna U206 · Monon, IN · Accident · 1 fatal · Closed · Feb 22, 1974 · N71992 · Destroyed
- [NTSB CHI74AC010](https://openairdocs.org/ntsb/CHI74AC010.md): Piper PA-28R · Fountaintown, IN · Accident · 1 fatal · Closed · Aug 1, 1973 · N2102T · Destroyed
- [NTSB CHI73AC087](https://openairdocs.org/ntsb/CHI73AC087.md): Piper PA-22 · Indianapolis, IN · Accident · 2 fatal · Closed · May 8, 1973 · N3378B · Destroyed
- [NTSB CHI73AC060](https://openairdocs.org/ntsb/CHI73AC060.md): Piper PA-28 · Paragon, IN · Accident · 2 fatal · Closed · Dec 25, 1972 · N8885N · Destroyed
- [NTSB CHI73AC025](https://openairdocs.org/ntsb/CHI73AC025.md): Cessna 172 · Martinsville, IN · Accident · 1 fatal · Closed · Aug 24, 1972 · N5745A · Destroyed
- [NTSB CHI73AC018](https://openairdocs.org/ntsb/CHI73AC018.md): Cessna 182M · Brownsburg, IN · Accident · 5 fatal · Closed · Aug 15, 1972 · N92004 · Destroyed
- [NTSB CHI73FEE09](https://openairdocs.org/ntsb/CHI73FEE09.md): Bellanca 17-30 · Gary, IN · Accident · No injuries · Closed · Jul 24, 1972 · N7394V · Substantial damage
- [NTSB CHI73AC004](https://openairdocs.org/ntsb/CHI73AC004.md): Piper PA-24 · Kewanna, IN · Accident · 4 fatal · Closed · Jul 15, 1972 · N5491P · Destroyed
- [NTSB CHI72AC087](https://openairdocs.org/ntsb/CHI72AC087.md): Cessna 175A · Boonville, IN · Accident · 2 fatal · Closed · May 7, 1972 · N6857E · Destroyed
- [NTSB CHI72FET18](https://openairdocs.org/ntsb/CHI72FET18.md): Cessna 172 · Elkhart, IN · Accident · Serious injuries · Closed · Mar 12, 1972 · N5632A · Destroyed
- [NTSB CHI71AC091](https://openairdocs.org/ntsb/CHI71AC091.md): Piper PA-30 · Fort Wayne, IN · Accident · 2 fatal · Closed · Jun 19, 1971 · XB-RIG · Destroyed
- [NTSB CHI71AC078](https://openairdocs.org/ntsb/CHI71AC078.md): Mooney M20C · Muncie, IN · Accident · 2 fatal · Closed · Apr 18, 1971 · N3427X · Destroyed
- [NTSB CHI71AC032](https://openairdocs.org/ntsb/CHI71AC032.md): Piper PA-28 · Pierceton, IN · Accident · 2 fatal · Closed · Nov 10, 1970 · N7795W · Destroyed
- [NTSB CHI70FBA10](https://openairdocs.org/ntsb/CHI70FBA10.md): Fulton EAA · Perrysville, IN · Accident · Minor injuries · Closed · Mar 1, 1970 · N9941 · Destroyed
- [NTSB CHI69A0075](https://openairdocs.org/ntsb/CHI69A0075.md): Mooney M20E · Jeffersonvlle, IN · Accident · 1 fatal · Closed · Feb 28, 1969 · N1274X · Destroyed
- [NTSB CHI69D0275](https://openairdocs.org/ntsb/CHI69D0275.md): Piper PA-28 · Andersonville, IN · Accident · No injuries · Closed · Sep 10, 1968 · N9488J · Destroyed
- [NTSB CHI69A0017](https://openairdocs.org/ntsb/CHI69A0017.md): Mooney A2-A · Anderson, IN · Accident · 3 fatal · Closed · Aug 10, 1968 · N5487F · Destroyed
- [NTSB CHI69F0067](https://openairdocs.org/ntsb/CHI69F0067.md): Cessna 172 · Fairbanks, IN · Accident · Serious injuries · Closed · Jun 18, 1968 · N6084A · Destroyed
- [NTSB CHI68A0091](https://openairdocs.org/ntsb/CHI68A0091-110933.md): Beech 35 · Gary, IN · Accident · 1 fatal · Closed · Apr 19, 1968 · N3057V · Destroyed
- [NTSB CHI68A0064](https://openairdocs.org/ntsb/CHI68A0064.md): Cessna 172 · Liberty, IN · Accident · 2 fatal · Closed · Jan 21, 1968 · N4142F · Destroyed
- [NTSB CHI67A0110](https://openairdocs.org/ntsb/CHI67A0110.md): Cessna 182 · Gary, IN · Accident · 4 fatal · Closed · Mar 27, 1967 · N3687U · Destroyed
- [NTSB CHI67A0104](https://openairdocs.org/ntsb/CHI67A0104.md): Cessna 210 · Bainbridge, IN · Accident · 3 fatal · Closed · Mar 17, 1967 · N9462T · Destroyed
- [NTSB CHI67A0102](https://openairdocs.org/ntsb/CHI67A0102.md): Cessna 210A · Plymouth, IN · Accident · 1 fatal · Closed · Mar 15, 1967 · N6683X · Destroyed
- [NTSB CHI67A0094](https://openairdocs.org/ntsb/CHI67A0094.md): Cessna 150 · Kokomo, IN · Accident · 2 fatal · Closed · Feb 8, 1967 · N5535E · Destroyed
- [NTSB CHI67A0069](https://openairdocs.org/ntsb/CHI67A0069.md): Beech A23 · Forest, IN · Accident · 1 fatal · Closed · Nov 26, 1966 · N1439L · Destroyed
- [NTSB CHI66A0089](https://openairdocs.org/ntsb/CHI66A0089.md): Piper PA-22 · Morocco, IN · Accident · 1 fatal · Closed · May 12, 1966 · N3208Z · Destroyed
- [NTSB CHI65A0080](https://openairdocs.org/ntsb/CHI65A0080.md): Piper PA-22 · Madison, IN · Accident · 1 fatal · Closed · Mar 8, 1965 · N3317Z · Destroyed
- [NTSB UNK64X1084](https://openairdocs.org/ntsb/UNK64X1084.md): Piper PA-28 · Auburn, IN · Accident · 4 fatal · Closed · Mar 28, 1964 · N7551W · Destroyed
- [NTSB UNK64X0336](https://openairdocs.org/ntsb/UNK64X0336.md): Cessna 172 · Lochiel, IN · Accident · 1 fatal · Closed · Jan 23, 1964 · N2753U · 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" = 'IN' 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=IN&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.
