# NTSB investigations: Lycoming 0-235 series, 2001: In flight collision with terrain/water

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 ATL02LA014](https://openairdocs.org/ntsb/ATL02LA014.md): Cessna 152 · Elberton, GA · Accident · No injuries · Limited investigation · Final report · Oct 31, 2001 · N93550 · Substantial damage
  > The student pilot's in-flight decision to land in a field, which resulted in an on-ground collision with a berm. Factors were the student's inadequate training and inadequate supervision by the flight instructor on the ground.
- [NTSB CHI01LA148](https://openairdocs.org/ntsb/CHI01LA148.md): Cessna 152 · Patriot, IN · Accident · No injuries · Limited investigation · Final report · May 27, 2001 · N6154Q · Substantial damage
  > the inadequate rotation speed and compensation for wind conditions by the pilot. Contributing factors were the crosswind and gust.
- [NTSB SEA01LA102](https://openairdocs.org/ntsb/SEA01LA102.md): Piper PA-18-105 Special · Wilbur, WA · Accident · 1 fatal · Limited investigation · Final report · May 22, 2001 · N7155K · Substantial damage
  > A collision with terrain for undetermined reasons.
- [NTSB CHI01LA122](https://openairdocs.org/ntsb/CHI01LA122.md): Bellanca 7ECA · Kimball, NE · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 2001 · N53950 · Substantial damage
  > The pilot not maintaining clearance from the terrain. A factor was that the pilot misjudged the low altitude flight maneuver.
- [NTSB MIA01LA113](https://openairdocs.org/ntsb/MIA01LA113.md): Larry R. Kinsey Variez O-235 · Pinson, AL · Accident · 1 fatal · Limited investigation · Final report · Mar 31, 2001 · N49LK · Destroyed
  > The pilot's continued visual flight rules flight into instrument meteorological conditions resulting in the airplane colliding with mountainous terrain.
- [NTSB FTW01LA045](https://openairdocs.org/ntsb/FTW01LA045.md): Cessna 152 · Bristow, OK · Accident · No injuries · Limited investigation · Final report · Jan 4, 2001 · N68472 · Substantial damage
  > The pilot's inadequate compensation for the crosswind conditions, which resulted in the airplane striking a snow bank during the landing flare/touchdown. A factor was the crosswind weather condition.

## 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") = 2001
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41505')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41505&occurrence=230&year=2001

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
