Skip to content

Curtiss Wright C-46A

NTSB investigations · 22

Matched to the registry by N-number and event date, newest first.

Query with SQL

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('2622602') ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('2622602')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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.Dec 20, 2000 · N1419Z · Destroyed 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…Jul 10, 1983 · N92853 · Substantial damage 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…Mar 28, 1982 · N9852F · Substantial damage NTSB MIA79RA121Accident · No injuriesClosedCurtis-Wrt C-46D · South Caicos, TokelauSep 12, 1979 · N7768B · Substantial damage NTSB MIA78FA106Accident · Minor injuriesClosedCurtiss C-46 · Opa Locka, FLJul 22, 1978 · N157K · Substantial damage NTSB ANC75AA071Accident · No injuriesClosedCurtiss-Wrt C-46 · Deadhorse, AKMar 27, 1975 · N4860V · Substantial damage NTSB MIA74AM037Accident · No injuriesClosedCurtis-Wrt C-46A · Lakeland, FLOct 23, 1973 · N611Z · Substantial damage NTSB FTW71AF075Accident · No injuriesClosedCurtiss-Wrt C-46F · Houston, TXMay 10, 1971 · N446M · Substantial damage NTSB UNK69X0109Accident · No injuriesClosedCurtiss WRT C-46F · Manaus, BrazilFeb 3, 1969 · N5133B · Destroyed NTSB MIA68A0051Accident · No injuriesClosedCurtiss C-46A · Key West, FLNov 28, 1967 · N75396 · Substantial damage NTSB ANC68A0025Accident · No injuriesClosedCurtiss-Wrt C-46A · Fairbanks, AKOct 13, 1967 · N92853 · Substantial damage NTSB CHI66A0099Accident · 3 fatalClosedCurtis C-46 · Columbia City, INJun 16, 1966 · N10415 · 2 aircraft · Destroyed NTSB UNK66X0106Accident · No injuriesClosedCurtis C-46 · Pouso Aleg, BrazilOct 29, 1965 · N75296 · Destroyed NTSB NYC66A0034Accident · No injuriesClosedCurtis C-46 · Dover, DESep 13, 1965 · N5132B · Substantial damage NTSB UNK65X1189Accident · 4 fatalClosedCurtis-Writ C-46A · Detroit, MIDec 30, 1964 · N608Z · Destroyed NTSB UNK65X0918Accident · No injuriesClosedCurtiss C46 · Oliktok Pt, AKDec 4, 1964 · N4860V · Substantial damage NTSB UNK65X0828Accident · No injuriesClosedCurtiss C-46 · Covington, KYNov 25, 1964 · N611Z · Substantial damage NTSB UNK64X0628Accident · No injuriesClosedCurtis C-46A · Denver, COFeb 21, 1964 · N611Z · Substantial damage NTSB UNK64X0100Accident · No injuriesClosedCurtiss WRT C-46A · Hill Afb, UTJan 1, 1964 · N10415 · Substantial damage NTSB DEN64A0039Accident · 3 fatalClosedCurtiss-Wrt C-46A · Nederland, CODec 7, 1963 · N609Z · Destroyed NTSB MIA62A0090Accident · No injuriesClosedCurtiss-Wrt C-46A · Macon, GADec 4, 1962 · N5131B · Substantial damage NTSB MIA62A0034Accident · No injuriesClosedCurtiss WRT C-46A · Tyndall Afb, FLMay 24, 1962 · N75388 · Substantial damage

Back to Curtiss Wright C-46A