NTSB investigations: Lockheed 188C
13 cases on aircraft the registry lists as Lockheed 188C. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1964 | 1 |
|---|---|
| 1966 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 2 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1986 | 1 |
| 1990 | 1 |
| 1999 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB DCA99WA042Accident · No injuriesForeign investigationLockheed L-188 · Shannon, IrelandNTSB BFO91T#001Incident · No injuriesFinal reportLockheed 188C · Wallops Island, VANTSB NYC87LA010Accident · Serious injuriesLimited investigationFinal reportLockheed L188A · Boston, MADuring 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 DCA83AA029Accident · No injuriesFinal reportLockheed 188C · Cold Bay, AKDuring 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 NYC80FA018Accident · Minor injuriesClosedLockheed L-188 · Syracuse, NYNTSB DCA80AA007Accident · 3 fatalClosedLockheed 188C · Salt Lake City, UTNTSB MIA78FA052Accident · No injuriesClosedLockheed L188C · Fort Myers, FLNTSB ANC73AA023Accident · No injuriesClosedLockheed L188A · Amchitka Is, AKNTSB DEN72AD042Accident · No injuriesClosedLockheed 188 · Hill Afb, UTNTSB DEN71AD007Accident · Minor injuriesClosedLockheed 188 · Hill Af Base, UTNTSB DIA68A0035Accident · No injuriesClosedLockheed 188C · Wash.Natl.Apt, DCNTSB DCA66A0006Accident · 83 fatalClosedLockheed L-188C · Ardmore, OKNTSB UNK64X1438Accident · Minor injuriesClosedLockheed L-188 · Cleveland, OH