# NTSB investigations: Lockheed 188C

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 DCA99WA042](https://openairdocs.org/ntsb/DCA99WA042.md): Lockheed L-188 · Shannon, Ireland · Accident · No injuries · Foreign investigation · Mar 1, 1999 · N285F · Substantial damage
- [NTSB BFO91T#001](https://openairdocs.org/ntsb/BFO91T%23001.md): Lockheed 188C · Wallops Island, VA · Incident · No injuries · Final report · Nov 1, 1990 · N429NA · Minor damage
- [NTSB NYC87LA010](https://openairdocs.org/ntsb/NYC87LA010.md): Lockheed L188A · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 1986 · N342HA · No damage
  > During engine start number 4 engine was started. The signal was given to the ground crewman to disconnect the air start unit. The engineer thought he heard 'start number 3'. Engine number 4 was shifted up, it stabilized, and engine number 3 was started. After…
- [NTSB DCA83AA029](https://openairdocs.org/ntsb/DCA83AA029.md): Lockheed 188C · Cold Bay, AK · Accident · No injuries · Final report · Jun 8, 1983 · N1968R · Substantial damage
  > During a cruise climb, the aircrew noted an unusual vibration; however, attempts to isolate the vibration were unsuccessful. While climbing from FL190 to FL250, the flt engineer went aft to observe the engs & props, but noted nothing unusual. A flt attendant…
- [NTSB NYC80FA018](https://openairdocs.org/ntsb/NYC80FA018.md): Lockheed L-188 · Syracuse, NY · Accident · Minor injuries · Closed · Jan 18, 1980 · N290F · Substantial damage
- [NTSB DCA80AA007](https://openairdocs.org/ntsb/DCA80AA007.md): Lockheed 188C · Salt Lake City, UT · Accident · 3 fatal · Closed · Nov 18, 1979 · N859U · Destroyed
- [NTSB MIA78FA052](https://openairdocs.org/ntsb/MIA78FA052.md): Lockheed L188C · Fort Myers, FL · Accident · No injuries · Closed · Mar 11, 1978 · N859U · Substantial damage
- [NTSB ANC73AA023](https://openairdocs.org/ntsb/ANC73AA023.md): Lockheed L188A · Amchitka Is, AK · Accident · No injuries · Closed · Sep 26, 1972 · N1968R · Substantial damage
- [NTSB DEN72AD042](https://openairdocs.org/ntsb/DEN72AD042.md): Lockheed 188 · Hill Afb, UT · Accident · No injuries · Closed · Mar 19, 1972 · N851U · Substantial damage
- [NTSB DEN71AD007](https://openairdocs.org/ntsb/DEN71AD007.md): Lockheed 188 · Hill Af Base, UT · Accident · Minor injuries · Closed · Aug 24, 1970 · N855U · Destroyed
- [NTSB DIA68A0035](https://openairdocs.org/ntsb/DIA68A0035.md): Lockheed 188C · Wash.Natl.Apt, DC · Accident · No injuries · Closed · Mar 3, 1968 · N135US · No damage
- [NTSB DCA66A0006](https://openairdocs.org/ntsb/DCA66A0006.md): Lockheed L-188C · Ardmore, OK · Accident · 83 fatal · Closed · Apr 22, 1966 · N183H · Destroyed
- [NTSB UNK64X1438](https://openairdocs.org/ntsb/UNK64X1438.md): Lockheed L-188 · Cleveland, OH · Accident · Minor injuries · Closed · Apr 24, 1964 · N125US · Substantial damage

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

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

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