Skip to content

NTSB investigations: Boeing A75, CA

25 cases on aircraft the registry lists as Boeing A75. 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

Where

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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1380108')) 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.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1380108'))
  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."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1380108'))
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 LAX00LA119Accident · No injuriesLimited investigationFinal reportStearman A-75 · Imperial, CAThe failure of the pilot-in-command to maintain directional control of the aircraft during landing roll.Mar 7, 2000 · N56760 · Substantial damage NTSB LAX96LA101Accident · No injuriesLimited investigationFinal reportBoeing A75 · Barstow, CAa loss of engine power for an undetermined reason(s).Jan 27, 1996 · N1359N · Substantial damage NTSB LAX89LA090Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Huntington Bch, CAThe pilot's inadequate evaluation of the weather, and the sudden wind shift that was encountered during takeoff. The trees & wall were related factors.Jan 18, 1989 · N58072 · Substantial damage NTSB LAX86LA215Accident · Minor injuriesLimited investigationFinal reportBoeing A75 · Angels Camp, CANumerous ground witnesses observed the aircraft fly low along the river which fed into the new melonies reservoir lake and then collide with unmarked high tension power lines which spanned a narrow portion of the lake. The pilot thought the aircraft was at…May 10, 1986 · N56760 · Destroyed NTSB OAK78FVM11Accident · No injuriesClosedBoeing A75 · Sn Jun Batsta, CAMar 16, 1978 · N63378 · Substantial damage NTSB OAK76FVA92Accident · 1 fatalClosedBoeing A75 · Parlier, CASep 18, 1976 · N68497 · Destroyed NTSB OAK76DVA79Accident · No injuriesClosedBoeing A75 · Tulare, CAJul 24, 1976 · N4792V · Destroyed NTSB LAX75FVA63Accident · Serious injuriesClosedBoeing A75 · Wasco, CAMay 16, 1975 · N5005V · Destroyed NTSB OAK75FVG55Accident · 1 fatalClosedBoeing A75 · Williams, CAApr 19, 1975 · N1351N · Destroyed NTSB OAK74FVA48Accident · Minor injuriesClosedStearman A75 · Visalia, CAMar 17, 1974 · N53089 · Substantial damage NTSB OAK74FVA44Accident · No injuriesClosedBoeing A75 · Kerman, CAFeb 3, 1974 · N75442 · Substantial damage NTSB OAK74FVG27Accident · No injuriesClosedBoeing A75 · Clarksburg, CAJan 28, 1974 · N69096 · Substantial damage NTSB OAK73DVA63Accident · Minor injuriesClosedBoeing A75N1 · Kingsburg, CAJun 5, 1973 · N1359N · Substantial damage NTSB LAX72FVA78Accident · 1 fatalClosedBoeing A75N1 · Bakersfield, CAJun 15, 1972 · N267N · Destroyed NTSB OAK69D0295Accident · Minor injuriesClosedBoeing A75 · Danville, CAApr 28, 1969 · N59253 · Substantial damage NTSB OAK69F0033Accident · 1 fatalClosedBoeing A75 · Orosi, CAJun 25, 1968 · N4762V · Destroyed NTSB OAK69D0007Accident · No injuriesClosedBoeing A-75 · Westley, CAMay 15, 1968 · N59253 · Substantial damage NTSB OAK68D0099Accident · No injuriesClosedBoeing A75 · Visalia, CAAug 23, 1967 · N56419 · Destroyed NTSB OAK68D0038Accident · No injuriesClosedBoeing A75 · San Ramon, CAMay 21, 1967 · N59253 · Substantial damage NTSB OAK67D0336Accident · No injuriesClosedBoeing A75N1 · Colusa, CAMay 6, 1967 · N56206 · Substantial damage NTSB OAK67D0054Accident · No injuriesClosedBoeing A75 · Caruthers, CAAug 12, 1966 · N4792V · Substantial damage NTSB OAK66D0254Accident · No injuriesClosedBoeing A75 · Exeter, CAApr 15, 1966 · N67870 · Destroyed NTSB OAK66F0243Accident · No injuriesClosedBoeing A-75 · Yuba City, CAApr 1, 1966 · N59253 · Substantial damage NTSB UNK64X2889Accident · 1 fatalClosedBoeing A75 · Dos Palos, CAJul 17, 1964 · N53089 · 2 aircraft · Substantial damage NTSB UNK64X0945Accident · No injuriesClosedBoeing A75N1 · Corcoran, CAMar 15, 1964 · N1716B · Substantial damage