# Fatal NTSB investigations, 2008: Abrupt maneuver

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 WPR09FA061](https://openairdocs.org/ntsb/WPR09FA061.md): Beech V35 · Warner Springs, CA · Accident · 2 fatal · Field investigation · Final report · Dec 20, 2008 · N1587L · Substantial damage
  > The failure of the pilot to maintain clearance from terrain during a low altitude maneuver.
- [NTSB LAX08LA272](https://openairdocs.org/ntsb/LAX08LA272.md): Socata Rallye 235E · San Martin, CA · Accident · 1 fatal · Limited investigation · Final report · Aug 21, 2008 · N711BZ · Destroyed
  > The pilot's incapacitation due to severe unrecognized coronary artery disease that resulted in a loss of aircraft control.
- [NTSB DFW08LA157](https://openairdocs.org/ntsb/DFW08LA157.md): Lucas D E/ Lucas K A AcroSport II · St Charles, MO · Accident · 1 fatal · Limited investigation · Final report · Jun 1, 2008 · N114KT · Substantial damage
  > The pilot's failure to maintain control during an attempted low pass maneuver.
- [NTSB NYC08FA189](https://openairdocs.org/ntsb/NYC08FA189.md): Grumman American AA-1C · Philadelphia, PA · Accident · 2 fatal · Field investigation · Final report · May 22, 2008 · N9555U · Destroyed
  > The flight instructor's failure to maintain airspeed which resulted in an inadvertent stall.
- [NTSB MIA08FA038](https://openairdocs.org/ntsb/MIA08FA038.md): Cessna 172L · Clearwater, FL · Accident · 3 fatal · Field investigation · Final report · Jan 12, 2008 · N7100Q · Substantial damage
  > The pilot's failure to maintain airspeed while maneuvering for approach to land. Contributing to the accident was the pilot's operation of the airplane above the design gross weight.

## 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") = 2008
  AND c."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '270' 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/270/sequence?fatal=1&year=2008

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