# NTSB investigations, 2022: Airport occurrence

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 ERA23LA094](https://openairdocs.org/ntsb/ERA23LA094.md): Cessna 177 · Franklin, VA · Accident · Minor injuries · Class 4 · Limited · Final report · Dec 26, 2022 · N177D · Substantial damage
  > The pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…
- [NTSB GAA23WA016](https://openairdocs.org/ntsb/GAA23WA016.md): Bell 206 · Kitakyushu, Japan · Incident · No injuries · Class 5 · Foreign · Oct 15, 2022 · JA6113 · No damage
- [NTSB CEN22LA328](https://openairdocs.org/ntsb/CEN22LA328.md): Eurocopter Deutschland EC 135 · Mount Vernon, IL · Accident · No injuries · Class 4 · Limited · Final report · Jul 20, 2022 · N228MT · Substantial damage
  > The inadequate securement of the cloth fire extinguisher cover, which resulted in it being blown off the fire extinguisher and ingested into the helicopter’s fenestron during the 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" = '070' 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/070/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.