# NTSB investigations: Continental TSIO-360 series, ID

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 WPR12CA240](https://openairdocs.org/ntsb/WPR12CA240.md): Cessna P337H · Jerome, ID · Accident · No injuries · Data collection · Final report · May 30, 2012 · N5KX · Substantial damage
  > The pilot’s failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use the checklist before landing.
- [NTSB LAX07CA243](https://openairdocs.org/ntsb/LAX07CA243.md): Piper PA-34-200T · Big Creek, ID · Accident · No injuries · Data collection · Final report · Aug 4, 2007 · N9356K · Substantial damage
  > The pilot's misjudgment of distance and speed, which led to a long landing, and his delayed application of brakes that resulted in long landing and a runway overrun.
- [NTSB SEA04CA041](https://openairdocs.org/ntsb/SEA04CA041.md): Piper PA-28R-201T · Rexburg, ID · Accident · No injuries · Data collection · Final report · Feb 13, 2004 · N2216M · Substantial damage
  > The pilot's failure to maintain runway alignment, and clearance from the snow bank. A snow bank adjacent to the runway was a factor.
- [NTSB SEA03FA042](https://openairdocs.org/ntsb/SEA03FA042.md): Piper PA-34-220T · Rexburg, ID · Accident · 4 fatal · Field investigation · Final report · Mar 5, 2003 · N9257X · Destroyed
  > The pilot's failure to maintain aircraft control while on final approach. High and gusting winds were a factor.
- [NTSB SEA03LA003](https://openairdocs.org/ntsb/SEA03LA003.md): Mooney M20K · Rexburg, ID · Accident · No injuries · Limited investigation · Final report · Oct 12, 2002 · N231EH · Substantial damage
  > The pilot's failure to perform a go-around once it became evident that his remedial action was not adequate to overcome the porpoise/pilot-induced oscillation that occurred during the landing flare. Factors include the pilot's inadvertent repeated…
- [NTSB SEA91LA176](https://openairdocs.org/ntsb/SEA91LA176.md): Mooney M-20K · Mccall, ID · Accident · No injuries · Limited investigation · Final report · Jul 18, 1991 · N231AS · Substantial damage
  > An on ground collision with an animal during the landing roll. A factor to the accident was: a dark night condition.
- [NTSB SEA91FA020](https://openairdocs.org/ntsb/SEA91FA020.md): Piper PA-34-200T · Albion, ID · Accident · 1 fatal · Field investigation · Final report · Nov 20, 1990 · N4325X · Destroyed
  > The pilot-in-command's failure to maintain control of the airplane in instrument meteorological conditions. Factors which contributed to the accident were the pilot's apprehension of flying in the forecasted weather, and the adverse weather conditions…
- [NTSB SEA82FA005](https://openairdocs.org/ntsb/SEA82FA005.md): Cessna 421C · Shoshone, ID · Accident · 3 fatal · Closed · Nov 21, 1981 · N8369G · Destroyed
- [NTSB SEA81FA047](https://openairdocs.org/ntsb/SEA81FA047.md): Piper PA-34 · Boise, ID · Incident · No injuries · Closed · Jul 17, 1981 · N40036 · Minor damage
- [NTSB SEA78FYA11](https://openairdocs.org/ntsb/SEA78FYA11.md): Piper PA-28R · Hailey, ID · Accident · No injuries · Closed · Jun 6, 1978 · N47663 · 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" = 'ID' 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=ID

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