NTSB investigations: Curtiss Wright C-46F, AK
10 cases on aircraft the registry lists as Curtiss Wright C-46F. 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
| 1967 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 2 |
| 1983 | 1 |
| 2000 | 1 |
| 2013 | 1 |
| 2018 | 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 ('2622608'))
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 ('2622608'))
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 ANC18CA054Accident · Minor injuriesData collectionFinal reportCurtiss Wright C46 · Manley Hot Springs, AKThe pilot's failure to attain the proper touchdown speed and his decision to land with a tailwind without ensuring that there was adequate runway length for the touchdown.NTSB ANC13LA063Accident · No injuriesLimited investigationFinal reportCurtiss Wright C-46F · Fairbanks, AKThe failure of the right main landing gear side brace due to fatigue, which resulted in a collapse of the right main landing gear.NTSB ANC01LA009Accident · No injuriesLimited investigationFinal reportCurtis-Wright C-46F · Port Alsworth, AKThe pilot's failure to maintain clearance during taxi. A factor associated with the accident was trees.NTSB ANC83FA080Accident · No injuriesField investigationFinal reportCurtiss-Wright C-46F · King Salmon, AKThe coplt reported that the acft had been in level cruise flt aprx 1 min when they felt a vibration, followed by a loud bang. The aircrew saw fire & smoke coming from the left eng, so they shut down the eng & feathered the propeller. The plt also activated…NTSB ANC75AA086Accident · No injuriesClosedCurtis-Wrt C-46F · Barrow, AKNTSB ANC75AA052Accident · No injuriesClosedCurtiss-Wrt C-46F · Arctic Village, AKNTSB ANC74AA072Accident · No injuriesClosedCurtis-Wrt C-46 · Fairbanks, AKNTSB ANC74AA002Accident · No injuriesClosedCurtis-Wrt C-46F · Beluga, AKNTSB ANC73IA002Incident · No injuriesClosedCurtiss-Wrt C-46 · Fort Yukon, AKNTSB ANC67A0056Accident · No injuriesClosedCurtiss-Wrt C-46 · Anchorage, AK