Skip to content

NTSB investigations: Boeing E75, CA

29 cases on aircraft the registry lists as Boeing E75. 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 ('1380120')) 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 ('1380120'))
  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 ('1380120'))
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 WPR14FA182Accident · 1 fatalField investigationFinal reportBoeing E75 · Fairfield, CAThe pilot's failure to maintain clearance from the runway during a low-level aerobatic maneuver due to his impairment by an over-the-counter antihistamine. Contributing to the severity of the pilot's injuries were the pilot's lack of fire protective clothing,…May 4, 2014 · N68828 · Destroyed NTSB LAX06LA271Accident · Minor injuriesLimited investigationFinal reportBoeing E75 · Morgan Hill, CAExcessive fuel flow through the carburetor which resulted in leaking fuel, and subsequent in-flight fire while maneuvering.Aug 25, 2006 · N58980 · Substantial damage NTSB LAX99LA008Accident · Minor injuriesLimited investigationFinal reportStearman E75 · Oakland, CAA loss of engine power due to the pilot's inadvertent entry into a negative 'g' condition, which induced a temporary interruption of the fuel supply.Oct 11, 1998 · N770WM · Substantial damage NTSB LAX92LA195Accident · No injuriesLimited investigationFinal reportBoeing PT-17 · Chino, CAThe pilot's failure to maintain directional control during the landing roll out.May 3, 1992 · N1731B · Substantial damage NTSB LAX91LA283Accident · No injuriesLimited investigationFinal reportBoeing E75 · San Luis Obispo, CAThat the pilot failed to properly compensate of the existing quartering tailwind, improperly using the flight controls and brakes.Jun 30, 1991 · N68809 · Substantial damage NTSB LAX90LA309Accident · No injuriesLimited investigationFinal reportBoeing E75 · Petaluma, CAThe pilot failed to maintain directional control by improperly using the rudder.Aug 31, 1990 · N5358N · Substantial damage NTSB LAX89LA008Accident · No injuriesLimited investigationFinal reportCessna 182A · Visalia, CAA Cessna 182A & a Boeing A75 collided on the rwy. The pilot of the Boeing stated that he was doing touch & go ldgs & had the ldg Cessna in sight. The Boeing plt then lost site of the Cessna after it touched down on rwy 30. The Boeing plt assumed the Cessna…Oct 4, 1988 · N5888B · 2 aircraft · Substantial damage NTSB LAX78FUA16Accident · No injuriesClosedBoeing PT-13 · Irvine, CAMay 19, 1978 · N9722Z · Substantial damage NTSB OAK75DVG48Accident · No injuriesClosedStearman A75N1 · Orland, CAMar 14, 1975 · N4763V · Substantial damage NTSB OAK75FVA20Accident · No injuriesClosedBoeing A75 · Kerman, CASep 22, 1974 · N1064N · Substantial damage NTSB OAK74DVA38Accident · No injuriesClosedBoeing A75N1 · Hanford, CADec 17, 1973 · N4768V · Substantial damage NTSB LAX73DUG20Accident · No injuriesClosedBoeing E75 · Ripley, CASep 25, 1972 · N67912 · Substantial damage NTSB OAK73DVA06Accident · No injuriesClosedBoeing E75 · Huron, CAJul 13, 1972 · N5018V · Destroyed NTSB OAK72DVM27Accident · No injuriesClosedBoeing E75N1 · Watsonville, CAMar 27, 1972 · N3961B · Substantial damage NTSB OAK72FVM21Accident · 1 fatalClosedStearman E75 · Castroville, CAJan 18, 1972 · N68983 · Destroyed NTSB OAK71DVA93Accident · No injuriesClosedBoeing E75 · Five Points, CAJun 30, 1971 · N5024V · Substantial damage NTSB OAK71DVM16Accident · No injuriesClosedBoeing B75 · Soledad, CASep 18, 1970 · N68984 · Substantial damage NTSB OAK71DVM13Accident · No injuriesClosedStearman B75 · Gonzales, CAAug 31, 1970 · N68984 · Substantial damage NTSB OAK70DVG07Accident · No injuriesClosedBoeing E-75 · Willows, CAApr 8, 1970 · N4763V · Substantial damage NTSB LAX70DUM06Accident · No injuriesClosedStearman A-75 · Winterhaven, CAMar 4, 1970 · N4758V · Substantial damage NTSB OAK70D0106Accident · No injuriesClosedBoeing A75 · Caruthers, CASep 6, 1969 · N562 · Destroyed NTSB OAK70D0128Accident · No injuriesClosedBoeing A75 · Castroville, CAAug 30, 1969 · N4767V · Substantial damage NTSB OAK70D0026Accident · No injuriesClosedBoeing E75 · Newell, CAJun 6, 1969 · N53399 · Substantial damage NTSB LAX69D0100Accident · Minor injuriesClosedBoeing E75 · Ripley, CAAug 31, 1968 · N67912 · Substantial damage NTSB OAK69D0094Accident · No injuriesClosedBoeing E75 · Traver, CAAug 3, 1968 · N68805 · Destroyed NTSB OAK68D0065Accident · No injuriesClosedBoeing A75 · Williams, CAJul 13, 1967 · N1318N · Substantial damage NTSB UNK64X4119Accident · No injuriesClosedBoeing PT17 · Pacoima, CASep 23, 1964 · N1390N · Substantial damage NTSB UNK64X3663Accident · No injuriesClosedBoeing E75 · Hanford, CAAug 29, 1964 · N4768V · Substantial damage NTSB UNK64X3532Accident · Minor injuriesClosedBoeing E75 · Tipton, CAAug 22, 1964 · N58986 · Substantial damage