Final NTSB investigations: Wright C14AB AC BA

14 cases on aircraft whose registry engine model is Wright C14AB AC BA. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Final NTSB investigations: Wright C14AB AC BA per year, 1965–2026: 14 cases
1965	1
1966	1
1967	4
1968	1
1971	1
1975	1
1976	1
1977	1
1985	1
1997	1
2002	1

Where

Open the map

Latest cases

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_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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67030')) 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_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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67030'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('67030'))
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 DEN02GA074Accident · 2 fatalFinal reportConsolidated-Vultee P4Y-2 · Estes Park, COthe inflight failure of the left wing due to fatigue cracking in the left wing's forward spar and wing skin. A factor contributing to the accident was inadequate maintenance procedures to detect fatigue cracking.Jul 19, 2002 · N7620C · Destroyed NTSB NYC97LA088Accident · No injuriesLimited investigationFinal reportNorth American B-25J · Midland, VAThe pilot's misjudgment of distance and altitude during the final approach. A factor in the accident was the exposed runway lip/edge.May 10, 1997 · N9456Z · Substantial damage NTSB SEA85FA182Accident · 2 fatalField investigationFinal reportConsolidated-Vultee PBY-6A · Northport, WAWater bomber acft landed on lake with dump doors partially open during landing phase of water pickup run. Mechanically operated dump door locks were applied before dump doors were closed. Plt controlled dump doors from pilots control wheel, co-pilot operated…Jul 29, 1985 · N2886D · Destroyed NTSB ANC77FA024Accident · 1 fatalClosedChase YC122C · Anchorage, AKJan 31, 1977 · N5904V · Destroyed NTSB FTW77FQG06Accident · No injuriesClosedN. American TB-25N · Vega, TXDec 21, 1976 · N3680G · Substantial damage NTSB MIA75FKG77Accident · 2 fatalClosedN.American B-25H · Dawsonville, GAJun 3, 1975 · N96GC · Destroyed NTSB OAK72DVG21Accident · No injuriesClosedConvair PBY-6A · Paskenta, CAAug 27, 1971 · N2886D · Substantial damage NTSB ANC69D0048Accident · No injuriesClosedChase YC-122 · Golovin, AKSep 7, 1968 · N122R · Substantial damage NTSB ANC67A0069Accident · 2 fatalClosedN.American B-25N · Rampart, AKJun 27, 1967 · N9937Z · Destroyed NTSB NYC67A0172Accident · 1 fatalClosedGrumman TBM-3E · Tuckerton, NJJun 2, 1967 · N9595C · Destroyed NTSB OAK67A0081Accident · No injuriesClosedGrumman TBM-3E · Jiggs, NVMay 24, 1967 · N9651C · Substantial damage NTSB OAK67A0076Accident · No injuriesClosedN American B-25N · Red Bluff, CAMay 6, 1967 · N3521G · Destroyed NTSB OAK67A0030Accident · Minor injuriesClosedGrumman TBM · Elko, NVSep 6, 1966 · N6894C · Destroyed NTSB OAK65F0069Accident · No injuriesClosedNo.American B25 · Honolulu, HIMay 7, 1965 · N9754Z · Substantial damage