# NTSB investigations: Continental 0-300 series, OR: In flight collision with object

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 LAX07CA242](https://openairdocs.org/ntsb/LAX07CA242.md): Cessna 172B · Sisters, OR · Accident · No injuries · Data collection · Final report · Aug 7, 2007 · N7604X · Substantial damage
  > The pilot's failure to maintain adequate clearance from trees.
- [NTSB SEA06LA012](https://openairdocs.org/ntsb/SEA06LA012.md): Cessna 172 · Gleneden Beach, OR · Accident · No injuries · Limited investigation · Final report · Oct 21, 2005 · N6000A · Substantial damage
  > The pilot's failure to maintain clearance from objects while maneuvering over the airport environment. Dark night conditions, trees, and ground fog were factors.
- [NTSB SEA05CA055](https://openairdocs.org/ntsb/SEA05CA055.md): Cessna 172H · Waldport, OR · Accident · Minor injuries · Data collection · Final report · Mar 6, 2005 · N8100L · Substantial damage
  > The pilot's failure to attain sufficient altitude/clearance during the takeoff initial climb, which resulted in an inflight collision with trees. A factor was the tall grass on the turf runway, which slowed the airplane's acceleration during the takeoff roll.
- [NTSB SEA92FA002](https://openairdocs.org/ntsb/SEA92FA002.md): Cessna 172G · Miltonfreewater, OR · Accident · 4 fatal · Field investigation · Final report · Oct 6, 1991 · N1372F · Destroyed
  > Inadequate in-flight planning. Factors to the accident were: mountainous terrain, clearance not maintained, lack of total flight experience, and lack of familiarity with geographical area.
- [NTSB SEA85LA143](https://openairdocs.org/ntsb/SEA85LA143.md): Cessna 172B · Imbler, OR · Accident · No injuries · Limited investigation · Final report · Jun 22, 1985 · N6987X · Substantial damage
  > During takeoff from a field (off arpt), the acft failed to clear a fence. The pilot then attempted to abort the takeoff, but the acft hit a bale of hay & nosed over. The plt's last medical certificate was dated 9/2/82.
- [NTSB SEA82FYK07](https://openairdocs.org/ntsb/SEA82FYK07.md): Cessna 172 · Lapine, OR · Accident · 1 fatal · Final report · Jan 24, 1982 · N8172B · Destroyed
  > When the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to…

## 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" = 'OR' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17022')
    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" = 220))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17022&occurrence=220&state=OR

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