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.
Cases per year
| 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 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.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."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" 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 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.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.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…NTSB ANC77FA024Accident · 1 fatalClosedChase YC122C · Anchorage, AKNTSB FTW77FQG06Accident · No injuriesClosedN. American TB-25N · Vega, TXNTSB MIA75FKG77Accident · 2 fatalClosedN.American B-25H · Dawsonville, GANTSB OAK72DVG21Accident · No injuriesClosedConvair PBY-6A · Paskenta, CANTSB ANC69D0048Accident · No injuriesClosedChase YC-122 · Golovin, AKNTSB ANC67A0069Accident · 2 fatalClosedN.American B-25N · Rampart, AKNTSB NYC67A0172Accident · 1 fatalClosedGrumman TBM-3E · Tuckerton, NJNTSB OAK67A0081Accident · No injuriesClosedGrumman TBM-3E · Jiggs, NVNTSB OAK67A0076Accident · No injuriesClosedN American B-25N · Red Bluff, CANTSB OAK67A0030Accident · Minor injuriesClosedGrumman TBM · Elko, NVNTSB OAK65F0069Accident · No injuriesClosedNo.American B25 · Honolulu, HI