NTSB investigations: Douglas C54G-DC
5 cases on aircraft the registry lists as Douglas C54G-DC. 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
| 1981 | 1 |
|---|---|
| 1983 | 1 |
| 1995 | 2 |
| 2007 | 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 ('3021534'))
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 ('3021534'))
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 ANC07LA016Accident · No injuriesLimited investigationFinal reportDouglas C54G-DC · Nenana, AKThe failure of an engine cylinder during cruise flight, which resulted in an in-flight fire, and subsequent emergency gear-up landing on snow-covered tundra. A factor in the accident was the failure of the fire suppression equipment to extinguish the fire.NTSB LAX95TA304Accident · No injuriesFinal reportDouglas C-54G · Aubeery, CAfailure of the pilot to see and avoid known obstacles along his route of flight. Contributing was the insufficient information given by the pilot in the lead aircraft.NTSB ANC95LA046Accident · No injuriesLimited investigationFinal reportDouglas C54GDC · Kivalina, AKThe pilot's failure to identify a hazardous landing area. Factors in the accident are the presence of snow banks/berms on the runway, and the inadequate snow removal by airport personnel.NTSB LAX83FA310Accident · No injuriesField investigationFinal reportDouglas DC-4-C55B · Kahului, HIDuring arrival, a descent was begun from 8000 to 7000 ft MSL at 0151 HST. At 0155 HST, the aircrew was cleared for a visual apch from 7000 ft MSL & a rapid descent was started with 20 deg of flaps & aprx 25 inches map (manifold pressure). The acft was…NTSB ANC81FA079Accident · 3 fatalClosedDouglas DC-4 · Kenai, AK