Final NTSB investigations: Boeing 707-323C

12 cases on aircraft the registry lists as Boeing 707-323C. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19672026

Final NTSB investigations: Boeing 707-323C per year, 1967–2026: 12 cases
1967	1
1969	1
1971	2
1972	1
1973	2
1977	1
1980	1
1987	1
1991	1
1996	1

Where

Open the map

Latest cases

Query with 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."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 ('138367D')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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

Run 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 MIA96IA084Incident · No injuriesIncident investigationFinal reportBoeing 707-323C · Miami, FLfailure of the flight engineer to follow the appropriate emergency procedure to manually extend the nose landing gear. Factors relating to the incident were: fatigue failure of the utility hydraulic system relief valve, which resulted in an inoperative normal…Feb 22, 1996 · N751MA · Minor damage NTSB DEN91FA098Accident · No injuriesField investigationFinal reportBoeing 707-323C · Denver, COImproper overhaul of the nose gear assembly by other maintenance personnel.Jul 9, 1991 · N8404 · Substantial damage NTSB FTW87LA113Accident · Minor injuriesLimited investigationFinal reportBoeing 707-323C · Oklahoma City, OKAfter engine start ground personnel experienced difficulty disconnecting the airstart unit hose. The ground signalman left the view of the crew to assist the other men in an effort to disconnect the unit from the aircraft. The pilot assuming that all was…May 1, 1987 · N8404 · Substantial damage NTSB MIA810A005Accident · Serious injuriesClosedBoeing 707 · Kingston (Atlantic Ocean)Oct 17, 1980 · N8406 · No damage NTSB NYC77FA029Accident · No injuriesClosedBoeing 727 · Jamaica, NYJan 25, 1977 · N4620 · 2 aircraft · Substantial damage NTSB FTW74IF013Incident · No injuriesClosedBoeing 707 · Memphis, TNSep 5, 1973 · N7595A · Minor damage NTSB NYC73IN138Incident · No injuriesClosedBoeing 707 · No.Atlantic Ocean (Atlantic Ocean)May 1, 1973 · N8406 · No damage NTSB FTW73IF028Incident · Minor injuriesClosedBoeing 707 · Little Rock, ARDec 14, 1972 · N7569A · No damage NTSB FTW72IF006Incident · No injuriesClosedBoeing 707 · Dallas, TXJul 21, 1971 · N8405 · Minor damage NTSB NYC71AN078Accident · 2 fatalClosedCessna 150 · Edison, NJJan 9, 1971 · N60942 · 2 aircraft · Destroyed NTSB FTW70A0008Accident · 1 fatalClosedBoeing 707 · Fort Worth, TXAug 3, 1969 · N7567A · 2 aircraft · Substantial damage NTSB LAX68I0031Incident · No injuriesClosedBoeing 707 · Phoenix, AZSep 14, 1967 · N7598A · Minor damage