# NTSB investigations, OH: Altitude deviation,uncontrolled

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 CHI86LA081](https://openairdocs.org/ntsb/CHI86LA081.md): Cessna 150M · Marengo, OH · Accident · Serious injuries · Limited investigation · Final report · Feb 2, 1986 · N2942V · Destroyed
  > The plt was relying on his loran c for navigation when he decided to alter his destination to Delaware municipal arpt due to adverse winds and turbulence. He had been checking his charts for obstructions when the acft collided with trees in a wooded area…
- [NTSB CHI84LA337](https://openairdocs.org/ntsb/CHI84LA337.md): Piper PA-28-161 · Manchester, OH · Accident · No injuries · Limited investigation · Final report · Aug 12, 1984 · N3573C · Substantial damage
  > The accident occurred when the pilot was flying low on a fly-by for photographs. Adjusting her seat, the passenger hit the control yoke, the aircraft pitched down and collided with a tree. The pilot recovered control and completed a safe landing at an airport…
- [NTSB CHI84LA120](https://openairdocs.org/ntsb/CHI84LA120.md): Piper PA-32RT-300 · Lima, OH · Accident · Minor injuries · Limited investigation · Final report · Feb 25, 1984 · N30026 · Substantial damage
  > Heavy wet snow was falling on the day of the accident. The plt reported that he cleared snow off the wings of the acft, but not off the horizontal surface of the t-tail. Also he reported, a considerable amount of slush remained on the rwy which was thrown up…
- [NTSB CHI82IA282](https://openairdocs.org/ntsb/CHI82IA282.md): Cessna 172N · Columbus, OH · Incident · No injuries · Incident investigation · Final report · Jul 29, 1982 · N6292D · Minor damage
  > During stall recovery practice, the right control yoke jammed in the full forward position. Recovery was accomplished byplacing both feet on the instrument panel for leverage then pulling the yoke rearward. Investigation revealed that the RH nylon bearing on…

## 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."eventStateOrRegion" = 'OH' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 110)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=110&state=OH

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