# NTSB investigations: Cessna 150G, MS

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 ERA12LA574](https://openairdocs.org/ntsb/ERA12LA574.md): Cessna 150G · Corinth, MS · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 2012 · N8465J · Substantial damage
  > The improper torque application on the crankshaft gear bolt by maintenance personnel during an engine overhaul, which resulted in the fatigue failure of the locking tab washer and gear alignment dowel and subsequent engine stoppage. Contributing to the…
- [NTSB ERA09CA243](https://openairdocs.org/ntsb/ERA09CA243.md): Cessna 150 · Madison, MS · Accident · Minor injuries · Data collection · Final report · Apr 15, 2009 · N3334J · Substantial damage
  > The pilot's improper flare and subsequent loss of directional control.
- [NTSB ATL00FA061](https://openairdocs.org/ntsb/ATL00FA061.md): Cessna 150G · Oxford, MS · Accident · 2 fatal · Field investigation · Final report · Jun 8, 2000 · N3711J · Substantial damage
  > The certified flight instructor's failure to maintain airspeed during climbout.
- [NTSB MIA91LA094](https://openairdocs.org/ntsb/MIA91LA094.md): Cessna 150G · Greenwood, MS · Accident · Minor injuries · Limited investigation · Final report · Mar 9, 1991 · N2949J · Substantial damage
  > Failure of the student pilot to abort the flight when one of the two fuel quantity indicators became inoperative during the first leg of the flight. Also, inaccurate fuel consumption calculations, poor preflight planning, and poor supervision by the CFI who…
- [NTSB MIA7LFKQ05](https://openairdocs.org/ntsb/MIA7LFKQ05.md): Cessna 150G · Okolona, MS · Accident · Serious injuries · Closed · Jul 28, 1975 · N4050J · Substantial damage
- [NTSB MIA74DKQ19](https://openairdocs.org/ntsb/MIA74DKQ19.md): Cessna 150G · Bolton, MS · Accident · No injuries · Closed · May 1, 1974 · N3623J · Substantial damage
- [NTSB MIA73FKQ25](https://openairdocs.org/ntsb/MIA73FKQ25.md): Cessna 150 · Avon, MS · Accident · Serious injuries · Closed · Mar 8, 1973 · N2611J · Substantial damage
- [NTSB MIA70F0077](https://openairdocs.org/ntsb/MIA70F0077.md): Cessna 150G · Gulfport, MS · Accident · No injuries · Closed · Jul 29, 1969 · N4092J · Substantial damage
- [NTSB MIA68D0181](https://openairdocs.org/ntsb/MIA68D0181.md): Cessna 150 · Batesville, MS · Accident · No injuries · Closed · Sep 16, 1967 · N2744S · 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" = 'MS' 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 ('2071816'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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