NTSB investigations: Curtiss Wright C-46A, AK
6 cases on aircraft the registry lists as Curtiss Wright C-46A. 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
| 1964 | 1 |
|---|---|
| 1967 | 1 |
| 1975 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 2000 | 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 ('2622602'))
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 ('2622602'))
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 ANC01FA026Accident · 2 fatalField investigationFinal reportCurtis-Wright C46A · Kenai, AKThe flight crew's decision to continue VFR flight into instrument meteorological conditions. Factors associated with the accident are high winds, turbulence, and low ceilings.NTSB ANC83FA119Accident · Serious injuriesField investigationFinal reportCurtiss C-46A · Bettles, AKJust after touchdown the acft rolled over a frost heave on the rwy surface and began veering to the right. The plt applied left brake and added pwr to the right eng but the acft continued going right until the right wing struck a hill adjacent to the right…NTSB ANC82DA029Accident · No injuriesFinal reportCurtiss-Wright C-46A · Wulik River Str, AKDuring arrival, the pilot noted that there was a cargo plane being unloaded at the end of a 4100 ft, snow covered runway. He elected to land from the opposite end within the first 4000 ft. the wind was calm. During the landing flare, the right main gear…NTSB ANC75AA071Accident · No injuriesClosedCurtiss-Wrt C-46 · Deadhorse, AKNTSB ANC68A0025Accident · No injuriesClosedCurtiss-Wrt C-46A · Fairbanks, AKNTSB UNK65X0918Accident · No injuriesClosedCurtiss C46 · Oliktok Pt, AK