NTSB investigations: Consolidated Vultee 28-5ACF

8 cases on aircraft the registry lists as Consolidated Vultee 28-5ACF. 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

19642026

NTSB investigations: Consolidated Vultee 28-5ACF per year, 1964–2026: 8 cases
1964	3
1966	1
1970	1
1994	1
1997	1
2025	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2422202', '2421230')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2422202', '2421230'))
  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 ('2422202', '2421230'))
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 ERA26LA028Accident · No injuriesClass 4 · LimitedFinal reportConsolidated Vultee 28-5ACF · Dayton, TNThe collapse of the left main landing gear due to the fatigue fracture of the lower landing gear actuator bolt.Oct 31, 2025 · N222FT · Substantial damage NTSB LAX97LA270Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee PBY-5A(28-5ACF) · Moreno, CAthe implosion of the unlocked left nose gear door which resulted in the hydraulic disintegration of the forward fuselage. The cause of the locking pin actuator malfunction was not determined.Aug 1, 1997 · N322FA · Destroyed NTSB SEA94LA181Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics PBY-5A · Lincoln City, ORThe pilot's failure to maintain clearance from a boat dock during the aborted takeoff. Factors include the pilot's poor inflight decision to land on a narrow lake under unfavorable wind conditions, and strong crosswinds during the attempted takeoff.Jul 8, 1994 · N2172N · Substantial damage NTSB MIA71AM042Accident · No injuriesClosedConvair 28-5AC · Christiansted, VINov 14, 1970 · N5584V · Substantial damage NTSB CHI67A0028Accident · Minor injuriesClosedConvair PBY5A · Highland Pk, ILAug 27, 1966 · N331RS · Destroyed NTSB UNK65X1032Accident · No injuriesClosedConvair PBY6A · Phoenix, AZDec 16, 1964 · N7057C · Substantial damage NTSB UNK65X0118Accident · 1 fatalClosedConvair 285ACF · Chichagof I, AKOct 2, 1964 · N4936V · Destroyed NTSB UNK64X3910Incident · No injuriesClosedConsolidatd PBY285 · Decatur, ALSep 11, 1964 · N19Q · Minor damage