# NTSB investigations: Cessna 150F, CT

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 IAD02LA068](https://openairdocs.org/ntsb/IAD02LA068.md): Cessna 150 · Griswold, CT · Accident · No injuries · Limited investigation · Final report · Jul 5, 2002 · N8894G · Substantial damage
  > the pilot's improper pre-flight planning and decision to depart a field with insufficient runway. Factors were the rough/uneven terrain, high obstructions and the tailwind.
- [NTSB NYC88LA240](https://openairdocs.org/ntsb/NYC88LA240.md): Cessna 150 · Burlington, CT · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 1988 · N3099X · Substantial damage
  > The plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of…
- [NTSB NYC79FNE09](https://openairdocs.org/ntsb/NYC79FNE09.md): Cessna 150 · Simsbury, CT · Accident · No injuries · Closed · Feb 28, 1979 · N6530F · Substantial damage
- [NTSB NYC69D0467](https://openairdocs.org/ntsb/NYC69D0467.md): Cessna 150 · Hartford, CT · Accident · No injuries · Closed · May 12, 1969 · N8035S · Substantial damage
- [NTSB NYC69D0430](https://openairdocs.org/ntsb/NYC69D0430.md): Cessna 150 · Southbury, CT · Accident · No injuries · Closed · Apr 28, 1969 · N6703F · Substantial damage
- [NTSB NYC69A0012](https://openairdocs.org/ntsb/NYC69A0012.md): Cessna 150 · East Hampton, CT · Accident · 1 fatal · Closed · Jul 31, 1968 · N8121S · Destroyed
- [NTSB NYC68F0506](https://openairdocs.org/ntsb/NYC68F0506.md): Cessna 150 · Mansfield, CT · Accident · Serious injuries · Closed · Jun 5, 1968 · N8112S · Substantial damage
- [NTSB NYC68F0282](https://openairdocs.org/ntsb/NYC68F0282.md): Cessna 150F · Plainville, CT · Accident · No injuries · Closed · Nov 5, 1967 · N8218F · Substantial damage
- [NTSB NYC68F0280](https://openairdocs.org/ntsb/NYC68F0280.md): Cessna 150F · Plainville, CT · Accident · Serious injuries · Closed · Nov 5, 1967 · N6694F · Substantial damage
- [NTSB NYC67D0575](https://openairdocs.org/ntsb/NYC67D0575.md): Cessna 150 · Williamantic, CT · Accident · No injuries · Closed · Mar 28, 1967 · N8896G · 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" = 'CT' 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 ('2071814'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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