NTSB investigations: Boeing 707-131B
17 cases on aircraft the registry lists as Boeing 707-131B. 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
| 1963 | 1 |
|---|---|
| 1964 | 1 |
| 1965 | 3 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 2 |
| 1975 | 2 |
| 1978 | 1 |
| 1981 | 1 |
| 1982 | 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 ('138360P'))
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 ('138360P'))
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 MKC82IA042Incident · 1 fatalIncident investigationFinal reportBoeing 707-131B · Las Vegas, NVThis incident occurred when there was no intent to fly. On 3-8-82, a Boeing 707-131, owned and operated by twa, was receiving routine maintenance in Las Vegas, NV. During the check, the servicing valve on the forward water tank would not open. A twa mechanic…NTSB MKC81FA038Accident · No injuriesClosedBoeing 707 · St Louis, MONTSB CHI78IA056Incident · Serious injuriesClosedBoeing 707 · Chicago, ILNTSB IAD76II016Incident · No injuriesClosedBoeing 707 · Edwardsville, ILNTSB MKC76AK038Accident · Serious injuriesClosedBoeing 707 · Bloomington, INNTSB OAK74AP049Accident · Serious injuriesClosedBoeing 707 · Rosewood, OHNTSB LAX74AL053Accident · Serious injuriesClosedBoeing 707 · Los Angeles, CANTSB MKC73AK031Accident · Serious injuriesClosedBoeing 707 · St.Louis, MONTSB NYC72AN079Accident · Serious injuriesClosedBoeing 707 · Kingston, NYNTSB IAD71II011Incident · No injuriesClosedBoeing 707 · Dulles Intl Apt, DCNTSB DIA69I0056Incident · No injuriesClosedBoeing 707 · Dulles Int Apt, VANTSB DIA69A0040Accident · No injuriesClosedBoeing 707 · Dulles Airport, VANTSB DCA66A0005Accident · 4 fatalClosedLockheed L1049C · Carmel, NYNTSB MKC66A0002Accident · Serious injuriesClosedBoeing 707 131B · Omaha, NENTSB LAX65A0068Accident · No injuriesClosedBoeing 707 131B · Los Angeles, CANTSB UNK65X0951Incident · No injuriesClosedBoeing 707 131B · New York, NYNTSB MKC63A0074Accident · Serious injuriesClosedBoeing 707 · Des Moines, IA