# NTSB investigations: Controlled flight into terr/obj (CFIT)

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.

Page 18 of 18 · 856 cases

## Cases, newest first

- [NTSB SEA08LA095](https://openairdocs.org/ntsb/SEA08LA095.md): Piper PA-28-181 · Bridger, MT · Accident · Minor injuries · Limited investigation · Final report · Mar 26, 2008 · N432RM · Substantial damage
  > The pilot failed to maintain situational awareness during the flight. Contributing to the accident were the dark night, the pilot's failure to follow approved navigational procedures for the flight, and the pilot's over reliance on the avionics in the…
- [NTSB NYC08FA138](https://openairdocs.org/ntsb/NYC08FA138.md): Cirrus Design SR22 · Front Royal, VA · Accident · 2 fatal · Field investigation · Final report · Mar 15, 2008 · N141SR · Destroyed
  > The pilot's failure to maintain clearance from rising mountainous terrain, and his failure to turn toward his assigned course during initial climb. Contributing to the accident were the low ceiling, reduced visibility, dark night conditions, and rising…
- [NTSB NYC08FA109](https://openairdocs.org/ntsb/NYC08FA109.md): Beech A36 · Cumberland, MD · Accident · 2 fatal · Field investigation · Final report · Feb 22, 2008 · N3815T · Substantial damage
  > The pilot's failure to maintain the proper approach course for undetermined reasons.
- [NTSB SEA08FA078](https://openairdocs.org/ntsb/SEA08FA078.md): Lancair LC41 · Portland, OR · Accident · 1 fatal · Field investigation · Final report · Feb 16, 2008 · N621ER · Destroyed
  > The pilot's failure to follow the missed approach procedure. Contributing to the accident were the fog and below landing minimums visibility conditions.
- [NTSB LAX08FA052](https://openairdocs.org/ntsb/LAX08FA052.md): Robinson Helicopter R22 Beta · Los Angeles, CA · Accident · 1 fatal · Field investigation · Final report · Jan 26, 2008 · N705JJ · Destroyed
  > The pilot's failure to maintain an adequate obstacle clearance altitude from transmission wires during cruise flight. Contributing to the accident was the dark night conditions.
- [NTSB SEA08FA062](https://openairdocs.org/ntsb/SEA08FA062.md): Hawker Beechcraft 1900C · Lihue, HI · Accident · 1 fatal · Field investigation · Final report · Jan 14, 2008 · N410UB · Destroyed
  > The pilot's spatial disorientation and loss of situational awareness. Contributing to the accident were the dark night and the task requirements of simultaneously monitoring the cockpit instruments and the other airplane.

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

This list as a web page: https://openairdocs.org/ntsb-events/120/cases?page=18

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