NTSB investigations: Douglas DC-6B, AK
7 cases on aircraft the registry lists as Douglas DC-6B. 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
| 1975 | 1 |
|---|---|
| 1992 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2001 | 2 |
| 2011 | 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.\"eventStateOrRegion\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3021712'))
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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3021712'))
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 ANC11CA044Accident · No injuriesData collectionFinal reportDouglas DC-6B · Cold Bay, AKThe flight crew's failure to extend the landing gear, which resulted in an inadvertent wheels up landing. Contributing to the accident was the flight crew's diverted attention.NTSB ANC01LA146Accident · Minor injuriesLimited investigationFinal reportDouglas DC-6B · Nuiqsut, AKThe flightcrew's continued use of an unstabilized GPS approach. Factors associated with the accident were low ceilings, and the inadequate coordination between the crew.NTSB ANC01LA034Accident · No injuriesLimited investigationFinal reportDouglas DC-6B · Crooked Creek, AKThe flight crew's misjudged flare while landing. Factors associated with the accident were flat light conditions, snow-covered terrain, and an uphill runway grade.NTSB ANC98LA014Accident · No injuriesLimited investigationFinal reportDouglas DC-6B · Mcgrath, AKThe ingestion of snow into the windshield anti-ice system, and the resulting obscured windshield which made runway alignment not possible. Factors associated with this accident were the cold windshield, the reduced performance of the windshield anti-ice…NTSB ANC96LA042Accident · No injuriesLimited investigationFinal reportDouglas DC-6-B · Beluga, AKThe Pilot-in-Command's selection of an unsuitable terrain area for taxi/parking and his misjudgment of the clearance required.NTSB ANC92LA043Accident · Minor injuriesLimited investigationFinal reportDouglas DC-6B · Selawik, AKThe pilot's inadequate pre flight planning and disregarding the aircraft performance data. Contributing factors were the extreme outside air temperatures, the icy runway, and the tailwind.NTSB ANC75AA054Accident · 2 fatalClosedDouglas DC-6B · Fairbanks, AK