# NTSB investigations, 2022: Simulated/training event

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 ERA23LA074](https://openairdocs.org/ntsb/ERA23LA074.md): Textron 172 · Newnan, GA · Accident · No injuries · Class 4 · Limited · Final report · Nov 22, 2022 · N407MD · Substantial damage
  > The flight instructor’s inadequate remedial action during a simulated engine failure and low approach, which resulted in a collision with a runway light.
- [NTSB WPR23LA043](https://openairdocs.org/ntsb/WPR23LA043.md): Robinson Helicopter R22 · Kapolei, HI · Accident · No injuries · Class 4 · Limited · Final report · Nov 11, 2022 · N948WB · Substantial damage
  > The pilot receiving instruction’s rapid reduction in throttle during hover autorotation training which resulted in a loss of control and collision with the ground.
- [NTSB CEN22LA297](https://openairdocs.org/ntsb/CEN22LA297.md): Cub Crafters CC18-180 · Air Force Academy, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Jul 1, 2022 · N469AK · Substantial damage
  > The pilot’s failure to maintain airplane control during the go-around, which resulted in impact with terrain. Contributing to the accident was the pilot’s impairment from the effects of alcohol consumption.
- [NTSB WPR22FA227](https://openairdocs.org/ntsb/WPR22FA227.md): Cessna 152 · Mendon, UT · Accident · 2 fatal · Class 3 · Field · Final report · Jun 24, 2022 · N934JH · Substantial damage
  > The flight instructor’s failure to recover from a developed spin, which resulted in impact with terrain. Contributing to the accident was the flight instructor’s decision to enter the maneuver below the operator’s altitude limitation.
- [NTSB ERA22LA237](https://openairdocs.org/ntsb/ERA22LA237.md): Diamond DA42 · Lehighton, PA · Accident · Minor injuries · Class 3 · Limited · Final report · May 9, 2022 · N988JA · Substantial damage
  > The flight instructor’s inadequate supervision of the flight and his failure to secure the right engine following an unsuccessful engine restart attempt, which resulted in the airplane’s inability to maintain altitude and a subsequent off-airport landing.

## 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '600' 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/600/sequence?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.