Final NTSB investigations: Consolidated Vultee/Hops L-13A

8 cases on aircraft the registry lists as Consolidated Vultee/Hops L-13A. 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: Consolidated Vultee/Hops L-13A per year, 1965–2026: 8 cases
1965	1
1966	1
1971	1
1973	1
1975	1
1979	1
1984	1
1990	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.aircraft_model_code IN ('2420704')) 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.aircraft_model_code IN ('2420704'))
  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.aircraft_model_code IN ('2420704'))
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 LAX90DVD01Accident · Serious injuriesFinal reportConvair L-13A · Hayward, CAAbsence of a oil system fitting cap.Aug 9, 1990 · N13NH · Destroyed NTSB NYC84LA156Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Vultee L-13A · Dummerston, VTDuring arrival, the plt landed to the south on a turf rwy. He stated that after a normal apch & touchdown, the acft encountered a gust of wind, presumably from the northwest & the acft nosed over. Also, in an accident report, he reported the wind was from the…May 2, 1984 · N90426 · Substantial damage NTSB ANC80DAG10Accident · Minor injuriesClosedConvair L-13 · Girdwood, AKOct 14, 1979 · N2544B · Substantial damage NTSB ANC75DAG95Accident · No injuriesClosedConvair L-13 · Talkeetna, AKJun 11, 1975 · N2544B · Substantial damage NTSB ANC74FAA24Accident · No injuriesClosedConvair L-13 · Fairbanks, AKDec 20, 1973 · N4704V · Substantial damage NTSB OAK72DVM07Accident · No injuriesClosedConvair L-13 · Watsonville, CAOct 10, 1971 · N2544B · Substantial damage NTSB DEN67D0054Accident · No injuriesClosedStinson L-13 · Sheridan, WYAug 5, 1966 · N6500C · Substantial damage NTSB MIA66F0162Accident · No injuriesClosedConvair L-13A · Ayden, NCAug 17, 1965 · N2531B · Substantial damage