# NTSB investigations: Cessna A150K, TX

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 DFW08FA036](https://openairdocs.org/ntsb/DFW08FA036.md): Cessna A150K · Mesquite, TX · Accident · 1 fatal · Field investigation · Final report · Nov 23, 2007 · N8301M · Destroyed
  > The flight instructor's failure to maintain sufficient airspeed to avoid a stall during takeoff-initial climb. Factors contributing to the accident are the instructor's decision to takeoff with excessive flaps, the improper maintenance replacement of the flap…
- [NTSB FTW89FA015](https://openairdocs.org/ntsb/FTW89FA015.md): Cessna A150K · Flint, TX · Accident · 2 fatal · Field investigation · Final report · Nov 6, 1988 · N5913J · Destroyed
  > The airplane was observed flying on an easterly heading at low altitude, with the propeller stopped. One of the witnesses said the airplane was gliding toward him and when close he started running away. He said the airplane abruptly turned left and went…

## 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" = 'TX' 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 ('2071824'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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