# Final NTSB investigations: Off-field or emergency landing

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 ERA22LA326](https://openairdocs.org/ntsb/ERA22LA326.md): Schweizer SGS 2-33A · Waynesville, OH · Accident · No injuries · Class 4 · Limited · Final report · Jul 10, 2022 · N3616Q · Substantial damage
  > The pilot’s loss of situational awareness (geographic position), which resulted in his inability to locate the intended landing runway and his decision to perform an off-airport landing.
- [NTSB CEN22LA314](https://openairdocs.org/ntsb/CEN22LA314.md): Piper PA-18-150 · Rogers, AR · Accident · No injuries · Class 4 · Limited · Final report · Jul 9, 2022 · N83552 · Substantial damage
  > The pilot’s failure to establish a stabilize approach criteria during low-level maneuvering to the runway, which resulted in a hard landing and contact with a hay bale.
- [NTSB CEN21LA102](https://openairdocs.org/ntsb/CEN21LA102.md): Hughes 369D · Tuckers Crossing, MS · Accident · 1 fatal · Class 3 · Limited · Final report · Dec 29, 2020 · N103SU · Destroyed
  > The pilot’s loss of helicopter control when the external saw contacted trees during an attempted emergency landing due to a main rotor transmission oil pressure warning. The reason that the pilot did not release the external saw from the helicopter during the…
- [NTSB CEN20CA236](https://openairdocs.org/ntsb/CEN20CA236.md): Bellanca 1730A · Martinton, IL · Accident · No injuries · Class 4 · Data collection · Final report · Jun 19, 2020 · N244HW · Substantial damage
  > The pilot's improper decision to conduct an off-field precautionary landing.
- [NTSB WPR20LA121](https://openairdocs.org/ntsb/WPR20LA121.md): Piper PA-32RT-300T · Angostura, NM · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 10, 2020 · N2112A · Substantial damage
  > The pilots precautionary off airport landing due to an undetermined engine issue.
- [NTSB WPR18LA133](https://openairdocs.org/ntsb/WPR18LA133.md): Robinson Helicopter R44 II · Borrego Springs, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 30, 2018 · N423ML · Substantial damage
  > The loss of the helicopter’s drive system for reasons that could not be determined from the available evidence, which led to an autorotation that resulted in a hard landing and rollover on uneven sandy terrain.

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

This list as a web page: https://openairdocs.org/ntsb-events/440/cases?status=final

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