# NTSB investigations: Continental TSIO-360 series, 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 NYC04LA191](https://openairdocs.org/ntsb/NYC04LA191.md): Mooney M20K · Edgartown, MA · Accident · Minor injuries · Limited investigation · Final report · Aug 12, 2004 · N231LK · Substantial damage
  > The pilot's failure to maintain airspeed while performing maneuvers to land, which resulted in an inadvertent stall/mush. A factor was the gusting wind conditions.
- [NTSB IAD99LA064](https://openairdocs.org/ntsb/IAD99LA064.md): Piper PA-34-220T · Nantucket, MA · Accident · No injuries · Limited investigation · Final report · Sep 2, 1999 · N6915Z · Substantial damage
  > the pilot's inadequate recovery from a bounced landing which resulted in a hard landing and the fracture and collapse of the right main landing gear.
- [NTSB NYC99LA195](https://openairdocs.org/ntsb/NYC99LA195.md): Piper PA-34-200T · Chatham, MA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1999 · N31743 · Substantial damage
  > The pilot's improper flare and improper recovery from a bounced landing.
- [NTSB NYC99FAMS3](https://openairdocs.org/ntsb/NYC99FAMS3.md): Piper PA28RT-201T · Plymouth, MA · Accident · 1 fatal · Missing aircraft · Final report · May 6, 1999 · N8235Z · Destroyed
  > undetermined (missing airplane)
- [NTSB NYC86LA058](https://openairdocs.org/ntsb/NYC86LA058.md): Piper PA-28R-200 · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Jan 7, 1986 · N1468X · No damage
  > The pilot was attempting to start the aircraft for a cross country flight. The weather was cold. Initially. The pilot stated the engine started but stopped. The pilot pulled key from ignition, pulled back throttle and closed the mixture before exiting the…
- [NTSB NYC78FNE35](https://openairdocs.org/ntsb/NYC78FNE35.md): Piper PA-28 · Northampton, MA · Accident · No injuries · Closed · Sep 20, 1978 · N56694 · 2 aircraft · 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.engine_model_code IN ('17019', '17023'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17019&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.
