# Final NTSB investigations, 2009: Explosion (post-impact)

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 CEN10LA041](https://openairdocs.org/ntsb/CEN10LA041.md): Wicks Air Center Hornet · Bonham, TX · Accident · 2 fatal · Limited investigation · Final report · Nov 7, 2009 · N651WA · Destroyed
  > The pilot's loss of control shortly after takeoff due to spatial disorientation in fog and/or low-level clouds.
- [NTSB CEN10LA034](https://openairdocs.org/ntsb/CEN10LA034.md): Piper PA-18-135 · Sikeston, MO · Accident · 2 fatal · Limited investigation · Final report · Oct 31, 2009 · N1198C · Substantial damage
  > The pilot's failure to maintain directional control during a crosswind takeoff.
- [NTSB CEN10FA029](https://openairdocs.org/ntsb/CEN10FA029.md): Beech A36TC · Kalamazoo, MI · Accident · 1 fatal · Field investigation · Final report · Oct 27, 2009 · C-FFIH · Destroyed
  > The loss of engine power for an undetermined reason.
- [NTSB ERA10FA024](https://openairdocs.org/ntsb/ERA10FA024.md): Piper PA-23-250 · Summerville, SC · Accident · 4 fatal · Field investigation · Final report · Oct 21, 2009 · N62635 · Substantial damage
  > Flight into terrain for undetermined reasons.
- [NTSB ERA09FA526](https://openairdocs.org/ntsb/ERA09FA526.md): Piper PA-32R-301T · Fort Lauderdale, FL · Accident · 4 fatal · Field investigation · Final report · Sep 20, 2009 · N2467Y · Substantial damage
  > Fatigue failure of the No. 5 engine cylinder fuel supply line, which resulted in an engine compartment fire. Also causal was the pilot's failure to immediately secure the engine/perform a forced landing after discovery of the fire, which resulted in the…

## 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 year(c."eventDate") = 2009
  AND c."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '180' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/180/sequence?status=final&year=2009

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
