NTSB investigations: Douglas DC-7C
15 cases on aircraft the registry lists as Douglas DC-7C. 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 | 2 |
| 1965 | 1 |
| 1966 | 4 |
| 1968 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1979 | 1 |
| 1983 | 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 ('3021806'))
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 ('3021806'))
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 ANC83IA111Incident · No injuriesIncident investigationFinal reportDouglas DC-7C · King Salmon, AKAcft overran the end of the rwy when takeoff was aborted after failure to rotate. No mechanical difficulties were noted. The rwy was dry and adequate. The CG was at or near the forward limit.NTSB LAX79FUT01Accident · 1 fatalClosedDouglas DC-7C · Daggett, CANTSB LAX77IA056Incident · No injuriesClosedDouglas DC-7C · Long Beach, CANTSB DCA74A0009Accident · 3 fatalClosedDouglas DC-7C · Miami, FLNTSB NYC73AN094Accident · 5 fatalClosedDouglas DC-7CF · San Juan, PRNTSB MIA69A0017Accident · No injuriesClosedDouglas DC-7C · Miami, FLNTSB DIA69A0016Accident · Serious injuriesClosedDouglas DC-7C · Cherry Point, NCNTSB DCA67R0002Accident · Minor injuriesClosedDouglas DC-7C · Saigon, VMNTSB DCA67A0002Accident · Serious injuriesClosedDouglas DC-7C · Tokyo, JANTSB MIA67I0030Incident · No injuriesClosedDouglas DC-7C · Miami, FLNTSB MIA67S0001Incident · No injuriesClosedDouglas DC-7 · Antigua Bwi, Ascension IslandNTSB MIA66I0053Incident · No injuriesClosedDouglas DC-7 · Atlanta, GANTSB FTW64A0016Accident · No injuriesClosedDouglas DC-7C · Panama Cty, St. Pierre & MiquelonNTSB DCA63A0008Accident · 101 fatalClosedDouglas DC-7C · Annette Isld, AKNTSB ANC62A0048Accident · No injuriesClosedDouglas DC-7C · Sitka Sound, AK