# Final NTSB investigations, 2022: Altitude deviation

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 DCA23LA172](https://openairdocs.org/ntsb/DCA23LA172.md): Boeing 777 · Kahului, HI · Incident · No injuries · Class 4 · Limited · Final report · Dec 19, 2022 · N212UA · No damage
  > The flight crew’s failure to manage the airplane’s vertical flightpath, airspeed, and pitch attitude following a miscommunication about the captain’s desired flap setting during the initial climb.
- [NTSB WPR23LA029](https://openairdocs.org/ntsb/WPR23LA029.md): Cessna 152 · San Jose, CA · Accident · No injuries · Class 4 · Limited · Final report · Nov 13, 2022 · N5171B · Substantial damage
  > The student pilots unstabilized approach and improper landing flare, which resulted in a hard bounced landing.
- [NTSB ERA22LA404](https://openairdocs.org/ntsb/ERA22LA404.md): Cirrus Design SF50 · Saint Cloud, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 9, 2022 · N77VJ · Substantial damage
  > The pilot’s continuation of the instrument approach into known extreme precipitation and turbulence associated with a thunderstorm, resulting in excessive altitude deviations that required him to activate the Cirrus Airframe Parachute System.
- [NTSB WPR22FA215](https://openairdocs.org/ntsb/WPR22FA215.md): Beech E35 · Buckeye, AZ · Accident · 2 fatal · Class 3 · Field · Final report · Jun 18, 2022 · N13AR · Destroyed
  > The pilots’ failure to climb and complete a normal traffic pattern after making a low approach and their failure to extend the flaps for reasons that could not be determined, and the flight instructor’s failure to ensure adequate airspeed and bank control…
- [NTSB WPR22FA197](https://openairdocs.org/ntsb/WPR22FA197.md): Cessna 208B · Oceanside, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 3, 2022 · N7581F · Substantial damage
  > The right-seated pilot’s failure to correct the left-seated pilot’s mismanagement of the engine thrust, which resulted in undesired speed and thrust oscillations during the final approach and a subsequent descent into terrain.
- [NTSB ERA22LA140](https://openairdocs.org/ntsb/ERA22LA140.md): Robinson Helicopter R22 · Fallston, MD · Accident · Minor injuries · Class 4 · Limited · Final report · Mar 1, 2022 · N786SH · Substantial damage
  > The student pilot's unstabilized hover, which resulted in ground contact and a dynamic rollover. Contributing to the accident was the flight instructor's inadequate supervision of the student and his delayed remedial action.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2022
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '282' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/282/sequence?status=final&year=2022

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