Skip to content

NTSB investigations: Boeing A75N1, CA

31 cases on aircraft the registry lists as Boeing A75N1. 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 ('1380165')) 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 ('1380165'))
  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 ('1380165'))
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 LAX04CA258Accident · No injuriesData collectionFinal reportBoeing A 75N1 · Auburn, CAthe pilot undergoing instruction's overcontrol of the aircraft by his excessive use of the rudder control and failure to maintain directional control of the airplane during landing, which resulted in a ground loop. Contributing factors to the accident were…Jul 11, 2004 · N56416 · Substantial damage NTSB LAX86LA299Accident · No injuriesLimited investigationFinal reportBoeing N25-3 · Van Nuys, CAA Boeing N2S-3 nosed over on landing while on a local VFR flight. The pilot indicated that he had logged a total of 2.4 hours in this make and model aircraft all within the previous ninety days. The pilot stated that on his last approach, the speed was too…Jul 7, 1986 · N5106N · Substantial damage NTSB LAX81DVA15Accident · No injuriesClosedBoeing A75N-1 · Lemoore, CADec 5, 1980 · N62630 · Substantial damage NTSB OAK77FVA12Accident · 1 fatalClosedBoeing A75N1 · Oakdale, CADec 31, 1976 · N53039 · Destroyed NTSB OAK74DVA33Accident · No injuriesClosedBoeing A75 · Hickman, CANov 15, 1973 · N56416 · Substantial damage NTSB OAK73FVG58Accident · No injuriesClosedBoeing A75N1 · E Nicolaus, CAApr 24, 1973 · N57001 · Destroyed NTSB LAX73DUM31Accident · Minor injuriesClosedBoeing A75N1 · Holtville, CAApr 3, 1973 · N67517 · Destroyed NTSB OAK72DVG78Accident · No injuriesClosedBoeing A75N1 · Tulelake, CAJun 25, 1972 · N4825V · Substantial damage NTSB LAX72FUM15Accident · No injuriesClosedBoeing A75 · Holtville, CANov 10, 1971 · N53143 · Substantial damage NTSB OAK72FVD20Accident · 1 fatalClosedBoeing A75N1 · Santa Rosa, CAOct 7, 1971 · N62946 · Destroyed NTSB OAK71DVG39Accident · No injuriesClosedBoeing A75 · Woodland, CANov 19, 1970 · N57001 · Substantial damage NTSB LAX71DVA22Accident · No injuriesClosedBoeing IB75A · Bakersfield, CAAug 22, 1970 · N67119 · Substantial damage NTSB OAK70DVG24Accident · No injuriesClosedBoeing A75N1 · Sacramento, CAJun 2, 1970 · N57007 · Substantial damage NTSB OAK70D0074Accident · Serious injuriesClosedBoeing A75N1 · Sacramento, CAJul 22, 1969 · N57001 · Substantial damage NTSB OAK70D0038Accident · Minor injuriesClosedBoeing 75 · Merced, CAJul 8, 1969 · N62337 · Destroyed NTSB OAK69F0118Accident · Serious injuriesClosedBoeing A75 · Caruthers, CAAug 23, 1968 · N49326 · Substantial damage NTSB LAX69D0098Accident · No injuriesClosedBoeing 75 · Shafter, CAAug 12, 1968 · N66711 · Substantial damage NTSB OAK69F0038Accident · No injuriesClosedBoeing A75N1 · Novato, CAJul 13, 1968 · N61553 · Substantial damage NTSB OAK68D0235Accident · Minor injuriesClosedBoeing A75 · Montpellier, CANov 22, 1967 · N56416 · Substantial damage NTSB OAK67D0293Accident · No injuriesClosedBoeing A75N1 · Modesto, CAApr 8, 1967 · N55137 · Destroyed NTSB OAK67D0107Accident · Minor injuriesClosedBoeing A75N1 · Five Points, CASep 9, 1966 · N62368 · Substantial damage NTSB LAX67D0027Accident · No injuriesClosedBoeing A75 · Buttonwillow, CAJun 18, 1966 · N65352 · Substantial damage NTSB OAK66F0241Accident · Minor injuriesClosedBoeing A-75N1 · Robbins, CAApr 23, 1966 · N7713C · Substantial damage NTSB LAX66A0071Accident · 1 fatalClosedBoeing A75 · Sunnymead, CAMar 19, 1966 · N59792 · Substantial damage NTSB OAK66F0048Accident · No injuriesClosedBoeing A75 · Armona, CAAug 6, 1965 · N62630 · Substantial damage NTSB LAX66F0063Accident · No injuriesClosedBoeing B-75 · Lamont, CAAug 3, 1965 · N66711 · Substantial damage NTSB OAK66F0036Accident · No injuriesClosedBoeing A75-1 · Richvale, CAApr 28, 1965 · N63496 · Destroyed NTSB UNK64X2651Accident · Minor injuriesClosedBoeing A75 · Corcoran, CAJul 4, 1964 · N53229 · 2 aircraft · Substantial damage NTSB UNK64X2509Accident · No injuriesClosedBoeing A75 · Arvin, CAJun 27, 1964 · N62659 · Substantial damage NTSB UNK64X1392Accident · No injuriesClosedBoeing A75N1 · Nelson, CAApr 20, 1964 · N56921 · Substantial damage NTSB UNK64X0410Accident · No injuriesClosedBoeing PT17 · Corcoran, CAJan 31, 1964 · N56505 · Substantial damage