# NTSB investigations, 2022: Evacuation

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 CEN23LA025](https://openairdocs.org/ntsb/CEN23LA025.md): Bell 206 · Greenville, IL · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 3, 2022 · N61KH · Substantial damage
  > The mechanic’s failure to inspect and clean the entire fuel nozzle assembly in accordance with the engine maintenance manual, which resulted in fuel starvation and a partial loss of engine power, an autorotation, and a hard landing.
- [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 DCA22FA132](https://openairdocs.org/ntsb/DCA22FA132.md): Mcdonnell Douglas MD80 · Miami, FL · Accident · Minor injuries · Class 2 · Field · Final report · Jun 21, 2022 · HI-1064 · Substantial damage
  > The structural failure of the left main landing gear downlock following ineffective shimmy dampening during the landing roll which caused the collapse of the left main landing gear, resulting in a runway excursion and post-flight fire.
- [NTSB CEN22LA228](https://openairdocs.org/ntsb/CEN22LA228.md): Air Tractor AT-602 · Allport, AR · Accident · Minor injuries · Class 3 · Limited · Final report · Jun 1, 2022 · N5007R · Substantial damage
  > A partial loss of engine power due to fuel contamination from foreign object debris. Contributing to the accident was the operator’s failure to follow the manufacturer’s required airframe fuel filter inspection interval.

## 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" = '460' 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/460/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.