# NTSB investigations: Cessna 425: In flight collision with terrain/water

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 DEN05FA126](https://openairdocs.org/ntsb/DEN05FA126.md): Cessna 425 · Lone Tree, CO · Accident · 4 fatal · Field investigation · Final report · Aug 14, 2005 · N425SG · Destroyed
  > The pilot's failure to properly execute the published instrument approach procedure, which resulted in controlled flight into terrain.
- [NTSB NYC97FA030](https://openairdocs.org/ntsb/NYC97FA030.md): Cessna 425 · Bohemia, NY · Accident · 3 fatal · Field investigation · Final report · Dec 16, 1996 · N425EW · Destroyed
  > the pilot's early descent to decision height and his failure to perform the missed approach procedure. A factor was the failure of air traffic control to issue a safety advisory.
- [NTSB MIA88FA105](https://openairdocs.org/ntsb/MIA88FA105.md): Cessna 425 · Sanford, FL · Accident · 1 fatal · Field investigation · Final report · Feb 12, 1988 · N6771Y · Destroyed
  > The flt was cleared for a night ILS apch & advised that twr at dest had closed. Twr had rptd at closing that fog was forming & the flt was advised of the fog. The acft was located on a remote part of the arpt the next morning. The ELT had activated but the…
- [NTSB NYC84FA092](https://openairdocs.org/ntsb/NYC84FA092.md): Cessna 425 · Dryden, NY · Accident · Minor injuries · Field investigation · Final report · Feb 25, 1984 · N6886D · Destroyed
  > The plt stated that he was utilizing the autopilot and flt director to execute the ILS appch to rwy 32. The autopilot was tracking the localizer while the pilot controlled the rate of descent along the glideslope with pitch command wheel on the autopilot,…

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076018', '207601A')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2076018&occurrence=230

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