# NTSB investigations: Lockheed SP-2H

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 WPR14TA248](https://openairdocs.org/ntsb/WPR14TA248.md): Lockheed SP 2H · Fresno, CA · Accident · No injuries · Final report · Jun 16, 2014 · N4692A · Substantial damage
  > The collapse of the nosewheel landing gear due to the disengagement of the nosewheel landing gear pin. Contributing to the accident was the failure of the main hydraulic system due to overpressurization for reasons that could not be determined during…
- [NTSB SEA08GA194](https://openairdocs.org/ntsb/SEA08GA194.md): Lockheed P2V-7 · Reno, NV · Accident · 3 fatal · Final report · Sep 2, 2008 · N4235T · Destroyed
  > The failure of the flight crew to maintain airspeed above in-flight minimum control speed (Vmca) after losing power in the left jet engine during initial climb after takeoff. Contributing to the accident was the crew's inadequate cockpit resource management…
- [NTSB FTW98GA286](https://openairdocs.org/ntsb/FTW98GA286.md): Lockheed SP-2H · Reserve, NM · Accident · 2 fatal · Final report · Jun 28, 1998 · N14835 · Destroyed
  > Failure of the copilot to maintain both lateral and vertical clearance from the trees, and failure of the captain to provide adequate supervision of the flight.
- [NTSB SEA92LA044](https://openairdocs.org/ntsb/SEA92LA044.md): Lockheed P2V-7 · Dixon, WY · Accident · 2 fatal · Limited investigation · Final report · Feb 8, 1992 · N70600 · Destroyed
  > The pilot-in-command's continued VFR flight into instrument meteorological conditions which resulted in a loss of control due to the lack of aircraft attitude indicators and resultant pilot spatial disorientation. A factor which contributed to the accident…

## 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 ('5269601'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=5269601

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