NTSB investigations: Fairchild C-82A
8 cases on aircraft the registry lists as Fairchild C-82A. 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 |
|---|---|
| 1965 | 2 |
| 1980 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 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 ('3372004'))
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 ('3372004'))
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 ANC84IA103Incident · No injuriesIncident investigationFinal reportFairchild C-82A · Anchorage, AKDuring arrival at the destination arpt, the aircrew was unable to extend the landing gear by using either the normal or emergency systems. They elected to return to Anchorage where emergency equipment was available. Fuel was reduced & subsequently a wheels up…NTSB ANC83IA118Incident · No injuriesIncident investigationFinal reportFairchild C-82A · Anchorage, AKThe main landing gear collapsed after landing. The nose gearwas down & locked with a green light in the cockpit. There was no down & locked light illuminated for the main gear. Examination revealed signatures consistent with extreme overload as in attempting…NTSB ANC83FA012Accident · Serious injuriesField investigationFinal reportFairchild C-82 · Nelson Lagoon, AKThe acft landed short damaging the right boom & horizontal stabilizer. The rwy threshold is marked by light green reflective threshold markers & two red & white striped touchdown panels.NTSB ANC82DA101Accident · No injuriesFinal reportFairchild C-82A · Karluk, AKThe pilot reported that during arrival, the approach to landing seemed normal until just before touchdown. The aircraft touched down short of the runway threshold marks on relatively steep terrain in the safety zone. The pilot estimated that the touchdown…NTSB ANC80FA097Accident · No injuriesClosedFairchild C-82A · Goodnews Bay, AKNTSB FTW66A0011Accident · No injuriesClosedFairchild C-82 · Campeche, MexicoNTSB ANC65A0039Accident · No injuriesClosedFairchild C82 · Beaver, AKNTSB UNK64X3202Accident · No injuriesClosedFairchild C82 · Granite Mt, AK