# NTSB investigations: Cessna 150F, MA

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 NYC81FNE11](https://openairdocs.org/ntsb/NYC81FNE11.md): Cessna 150 · Princeton, MA · Accident · Minor injuries · Closed · Feb 22, 1981 · N6975F · Substantial damage
- [NTSB NYC78FA073](https://openairdocs.org/ntsb/NYC78FA073.md): Cessna 150 · Southbridge, MA · Accident · 1 fatal · Closed · Jul 27, 1978 · N8196F · Substantial damage
- [NTSB NYC77DNA14](https://openairdocs.org/ntsb/NYC77DNA14.md): Cessna 150 · Hanson, MA · Accident · No injuries · Closed · Mar 27, 1977 · N8717S · Substantial damage
- [NTSB NYC76FNE24](https://openairdocs.org/ntsb/NYC76FNE24.md): Cessna 150G · Westboro, MA · Accident · Minor injuries · Closed · Jun 7, 1976 · N8347G · Substantial damage
- [NTSB NYC74FNE23](https://openairdocs.org/ntsb/NYC74FNE23.md): Cessna 150F · Monterey, MA · Accident · Serious injuries · Closed · May 12, 1974 · N8234F · Destroyed
- [NTSB NYC74FNE02](https://openairdocs.org/ntsb/NYC74FNE02.md): Cessna 150F · Wendell, MA · Accident · No injuries · Closed · Aug 13, 1973 · N8860G · Substantial damage
- [NTSB NYC69D0448](https://openairdocs.org/ntsb/NYC69D0448.md): Cessna 150 · Newburyport, MA · Accident · No injuries · Closed · May 18, 1969 · N6730F · Substantial damage
- [NTSB NYC68F0454](https://openairdocs.org/ntsb/NYC68F0454.md): Cessna 150 · Winchendon, MA · Accident · No injuries · Closed · Apr 22, 1968 · N8058S · Substantial damage
- [NTSB NYC68D0307](https://openairdocs.org/ntsb/NYC68D0307.md): Cessna 150F · Bedford, MA · Accident · No injuries · Closed · Dec 1, 1967 · N3590L · Substantial damage
- [NTSB NYC68F0277](https://openairdocs.org/ntsb/NYC68F0277.md): Cessna 150 · Bedford, MA · Accident · No injuries · Closed · Oct 25, 1967 · N6588F · Substantial damage
- [NTSB NYC68D0199](https://openairdocs.org/ntsb/NYC68D0199.md): Cessna 150 · Monterey, MA · Accident · No injuries · Closed · Sep 21, 1967 · N8035S · Substantial damage
- [NTSB NYC68D0106](https://openairdocs.org/ntsb/NYC68D0106.md): Cessna 150 · Sterling Jct, MA · Accident · No injuries · Closed · Aug 12, 1967 · N3063X · Substantial damage
- [NTSB NYC68D0060](https://openairdocs.org/ntsb/NYC68D0060.md): Cessna 150 · Shirley, MA · Accident · No injuries · Closed · Jul 11, 1967 · N3099X · Destroyed
- [NTSB NYC67F0657](https://openairdocs.org/ntsb/NYC67F0657.md): Cessna 150F · Shirley, MA · Accident · Minor injuries · Closed · Apr 30, 1967 · N8948S · Destroyed
- [NTSB NYC67F0588](https://openairdocs.org/ntsb/NYC67F0588.md): Cessna 150 · Ludlow, MA · Accident · Minor injuries · Closed · Apr 1, 1967 · N8214S · Destroyed
- [NTSB NYC67D0455](https://openairdocs.org/ntsb/NYC67D0455.md): Cessna 150 · Sheffield, MA · Accident · No injuries · Closed · Dec 30, 1966 · N8663G · Substantial damage
- [NTSB NYC67D0425](https://openairdocs.org/ntsb/NYC67D0425.md): Cessna 150 · Norwood, MA · Accident · No injuries · Closed · Dec 18, 1966 · N3078X · Substantial damage
- [NTSB NYC67F0318](https://openairdocs.org/ntsb/NYC67F0318.md): Cessna 150F · Greenfield, MA · Accident · No injuries · Closed · Oct 9, 1966 · N6834F · Substantial damage
- [NTSB NYC67A0048](https://openairdocs.org/ntsb/NYC67A0048.md): Cessna 150 · Westford, MA · Accident · 1 fatal · Closed · Sep 17, 1966 · N8427G · Destroyed
- [NTSB NYC67D0097](https://openairdocs.org/ntsb/NYC67D0097.md): Cessna 150 · Danvers, MA · Accident · No injuries · Closed · Jul 9, 1966 · N6562F · Substantial damage
- [NTSB NYC67D0018](https://openairdocs.org/ntsb/NYC67D0018.md): Cessna 150 · N. Andover, MA · Accident · No injuries · Closed · Jun 12, 1966 · N3590L · Substantial damage
- [NTSB NYC66F0636](https://openairdocs.org/ntsb/NYC66F0636.md): Cessna 150 · Bedford, MA · Accident · No injuries · Closed · Apr 17, 1966 · N8171S · Substantial damage
- [NTSB NYC66F0644](https://openairdocs.org/ntsb/NYC66F0644.md): Cessna 150 · Bedford, MA · Accident · No injuries · Closed · Feb 22, 1966 · N8366G · Substantial damage
- [NTSB NYC66F0449](https://openairdocs.org/ntsb/NYC66F0449.md): Cessna 150F · Mansfield, MA · Accident · Minor injuries · Closed · Jan 5, 1966 · N8948S · 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" = 'MA' 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=MA

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