Final NTSB investigations: Lockheed 188A
13 cases on aircraft the registry lists as Lockheed 188A. 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
| 1962 | 1 |
|---|---|
| 1963 | 1 |
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1985 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5262602'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('5262602'))
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 DCA85AA009Accident · 3 fatalFinal reportLockheed 188A · Kansas City, KSDuring arrival to the Kansas City downtown arpt, the flt was vectored for a VOR rwy 3 apch, then was cleared for the apch & to circle & land on rwy 36. On final apch, the acft was hi & was not in a position to land, so the flt was cleared to circle left for…NTSB DCA84AA024Accident · 4 fatalFinal reportLockheed L-188 · Chalkhill, PAAfter departing the baltimore-washington arpt, the acft had climbed to FL 220. According to info on the cockpit voice recorder (vcr), the crew experienced gyro problems during the climb. They selected the #1 vertical gyro to drive both approach horizons…NTSB ANC79FA029Accident · Minor injuriesClosedLockheed 188A · Umiat, AKNTSB DCA77AA022Accident · 3 fatalClosedLockheed L-188C · St.Louis, MONTSB ANC76AA075Accident · No injuriesClosedLockheed 188 · Udrivik Lake, AKNTSB ANC75AA079Accident · No injuriesClosedLockheed 188A · Deadhorse, AKNTSB DIA69I0045Incident · No injuriesClosedLockheed 188-A · Richmond, VANTSB DCA68A0005Accident · 85 fatalClosedLockheed L-188 · Dawson, TXNTSB MIA68I0032Incident · No injuriesClosedLockheed 188 · Pensacola, FLNTSB FTW67A0015Accident · No injuriesClosedLockheed L-188A · Fort Worth, TXNTSB MIA65A0104Accident · Serious injuriesClosedLockheed L-188 · Tallahassee, FLNTSB CHI63A0182Accident · Serious injuriesClosedLockheed 188 · Chicago, ILNTSB MIA62A0056Accident · Minor injuriesClosedLockheed 188 · Knoxville, TN