# NTSB investigations, IL: Emergency 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 CEN16FA214](https://openairdocs.org/ntsb/CEN16FA214.md): Cirrus Design SR22 · Marion, IL · Accident · 1 fatal · Field investigation · Final report · Jun 10, 2016 · N508AJ · Destroyed
  > The pilots' failure to maintain adequate airspeed while executing a simulated engine failure and landing maneuver, which resulted in the wing's critical angle of attack being exceeded and a subsequent aerodynamic stall and loss of control.
- [NTSB CEN14LA517](https://openairdocs.org/ntsb/CEN14LA517.md): Robinson Helicopter R22 Beta · Cahokia, IL · Accident · No injuries · Limited investigation · Final report · Sep 19, 2014 · N115DD · Substantial damage
  > The pilot’s poor decision to take off with the clutch warning light illuminated, which resulted in the total failure of the fan assembly due to a lack of lubrication. Contributing to the accident was the mechanic’s failure to lubricate the lower actuator…
- [NTSB CEN13CA312](https://openairdocs.org/ntsb/CEN13CA312.md): Robinson Helicopter R22 Beta · Lansing, IL · Accident · No injuries · Data collection · Final report · Jun 3, 2013 · N2318X · Substantial damage
  > Improper control inputs by the pilot-receiving-instruction and the inability of the flight instructor to correct the control inputs in sufficient time to avoid the hard landing.
- [NTSB CEN13LA164](https://openairdocs.org/ntsb/CEN13LA164.md): Bellanca 17-30A · Morris, IL · Accident · No injuries · Limited investigation · Final report · Feb 16, 2013 · N93747 · Substantial damage
  > The pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CHI03LA306](https://openairdocs.org/ntsb/CHI03LA306.md): Bellanca 14-13-2 · Moline, IL · Accident · No injuries · Limited investigation · Final report · Sep 6, 2003 · N74467 · Substantial damage
  > The partial failure of the engine driven fuel pump and fuel starvation. An additional cause was the pilot misjudging the proper glidepath and his improper in-flight decision during the precautionary landing to pull back the power and lower the flaps prior to…
- [NTSB CHI99IA096](https://openairdocs.org/ntsb/CHI99IA096.md): Cessna T210R · Tinley Park, IL · Incident · No injuries · Incident investigation · Final report · Feb 20, 1999 · N7687U · Minor damage
  > the improper installation of the pressure oil line 'B' nut by maintenance personnel. Contributing to the incident were the loose pressure oil line 'B' nut and separation of the propeller from the aircraft.
- [NTSB CHI92LA252](https://openairdocs.org/ntsb/CHI92LA252.md): Cameron N-90 · Centralia, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 16, 1992 · N75250 · No damage
  > Abrupt touchdown.
- [NTSB CHI90LA220](https://openairdocs.org/ntsb/CHI90LA220.md): Schleicher ASK-21 · Plainfield, IL · Accident · No injuries · Limited investigation · Final report · Jul 31, 1990 · N342KS · Substantial damage
  > The glider pilot's improper aircraft handling at low atitude.
- [NTSB CHI85LA294](https://openairdocs.org/ntsb/CHI85LA294.md): Piper PA-28-161 · Schaumburg, IL · Accident · No injuries · Limited investigation · Final report · Jul 17, 1985 · N4349K · Substantial damage
  > The acft contacted a ditch during a forced landing following a loss of pwr shortly after takeoff. The plt reported that at an alt of aprx 200 ft AGL, during the takeoff climb, a total loss of pwr occurred. A left turn was made in an attemptto avoid buildings…
- [NTSB CHI82FCA01](https://openairdocs.org/ntsb/CHI82FCA01.md): Hughes 369HS · Cahokia, IL · Accident · No injuries · Closed · Nov 14, 1981 · N9083F · Substantial damage
- [NTSB UNK64X1983](https://openairdocs.org/ntsb/UNK64X1983.md): Bell 47G · Pana, IL · Accident · No injuries · Closed · May 27, 1964 · N4734S · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb-phases/600/cases?state=IL

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