# NTSB investigations: Cessna 150, IN

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 CEN18FA132](https://openairdocs.org/ntsb/CEN18FA132.md): Cessna 150 · Marion, IN · Accident · 2 fatal · Field investigation · Final report · Apr 2, 2018 · N5614E · 2 aircraft · Destroyed
  > The failure of both pilots to see and avoid the other airplane as they converged on intersecting runways. Contributing to the accident was the jet pilot's not monitoring the airport's traffic advisory frequency, known reduced visibility of the intersecting…
- [NTSB CHI07CA139](https://openairdocs.org/ntsb/CHI07CA139.md): Cessna 150 · English, IN · Accident · No injuries · Data collection · Final report · May 15, 2007 · N7772E · Substantial damage
  > The pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.
- [NTSB MIA76FET19](https://openairdocs.org/ntsb/MIA76FET19.md): Cessna 150 · Lake Village, IN · Accident · No injuries · Closed · Oct 30, 1975 · N45DB · Substantial damage
- [NTSB CHI74FET11](https://openairdocs.org/ntsb/CHI74FET11.md): Cessna 150 · Michigan City, IN · Accident · Serious injuries · Closed · Nov 2, 1973 · N6987G · Substantial damage
- [NTSB CHI73FET04](https://openairdocs.org/ntsb/CHI73FET04.md): Cessna 150 · Valparaiso, IN · Accident · No injuries · Closed · Jun 10, 1972 · N6608T · Substantial damage
- [NTSB CHI67A0094](https://openairdocs.org/ntsb/CHI67A0094.md): Cessna 150 · Kokomo, IN · Accident · 2 fatal · Closed · Feb 8, 1967 · N5535E · Destroyed
- [NTSB CHI67F0378](https://openairdocs.org/ntsb/CHI67F0378.md): Cessna 150 · Angola, IN · Accident · No injuries · Closed · Nov 26, 1966 · N6497T · Destroyed
- [NTSB CHI67D0063](https://openairdocs.org/ntsb/CHI67D0063.md): Cessna 150 · Carmel, IN · Accident · No injuries · Closed · Jun 25, 1966 · N5535E · Substantial damage
- [NTSB UNK64X2561](https://openairdocs.org/ntsb/UNK64X2561.md): Cessna 150 · New Richmond, IN · Accident · 2 fatal · Closed · Jun 29, 1964 · N7806E · Destroyed
- [NTSB UNK64X1598](https://openairdocs.org/ntsb/UNK64X1598.md): Cessna 150 · Clayton, IN · Accident · No injuries · Closed · May 3, 1964 · N5517E · Substantial damage

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

This list as a web page: https://openairdocs.org/ntsb?model=2071802&state=IN

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