Skip to content

NTSB investigations: Beech C-45H, CA

23 cases on aircraft the registry lists as Beech C-45H. 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 ('1151018', '1151019')) 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 ('1151018', '1151019'))
  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 ('1151018', '1151019'))
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 LAX93LA140Accident · Serious injuriesLimited investigationFinal reportBeech C-45H · Oakland, CAA premature lift off and inadvertent stall by the pilot-in-command. Contributing to the accident was insufficient available aircraft performance data after a ferry tank installation and both pilots lack of total experience in the airplane.Mar 7, 1993 · N494 · Destroyed NTSB LAX91LA228Accident · No injuriesLimited investigationFinal reportBeech C-45H · Lake Elsinore, CAFuel starvation due to an improper modification of the fuel system and the pilot's failure to ensure that the aircraft was airworthy prior to flight.May 29, 1991 · N9903Z · Substantial damage NTSB LAX87LA302Accident · No injuriesLimited investigationFinal reportBeech C-45H · Auburn, CAThe aircraft collided with a ditch after a loss of control during landing rollout. The pilot indicated that during the landing roll the aircraft veered left. Attempted braking action was ineffective. The aircraft had a history of brake problems. The acft had…Aug 11, 1987 · N105DK · Substantial damage NTSB LAX84IA219Incident · No injuriesIncident investigationFinal reportBeech C-45G · Ontario, CAA Beech E18S, N3657G, operating as federal express flt 954L, was cleared for takeoff on rwy 8L after a Boeing 747, N8172G, operating as interflight 429, was cleared to cross the same rwy. The Boeing 747'S cargo included race horses. The Boeing crew were…Mar 15, 1984 · N3657G · No damage NTSB LAX83FA012Accident · 14 fatalField investigationFinal reportBeech C-45H · Taft, CAThe aircraft was on a local flight involving a parachute jumping activity. In addition to the pilot, there were 12 parachutists and an observer on board. The pilot initiated his takeoff on runway 18. A witness stated that shortly after takeoff, the engine…Oct 17, 1982 · N403SE · Destroyed NTSB LAX78FA047Accident · 1 fatalClosedVolpar C-45H · Lake Elsinore, CAMay 11, 1978 · N63H · Destroyed NTSB OAK77FVD14Accident · Minor injuriesClosedBeech C45H · Antioch, CAFeb 6, 1977 · N634Z · Substantial damage NTSB LAX74DVA55Accident · No injuriesClosedCessna 150 · Bakersfield, CAApr 13, 1974 · N10513 · 2 aircraft · Destroyed NTSB LAX74AL016Accident · No injuriesClosedBeech C-45H · Los Angeles, CAAug 17, 1973 · N281H · Substantial damage NTSB LAX73AL013Accident · No injuriesClosedBeech D18S · Santa Maria, CASep 13, 1972 · N281H · Substantial damage NTSB OAK72DVG39Accident · No injuriesClosedBeech D18S · Sacramento, CAMar 10, 1972 · N628B · Substantial damage NTSB LAX71FUM29Accident · Serious injuriesClosedBeech C-45H · Lakeside, CAFeb 14, 1971 · N4709C · Destroyed NTSB OAK71DVM36Accident · No injuriesClosedTradewinds C-45 · San Jose, CAJan 14, 1971 · N6640R · Substantial damage NTSB OAK71AP022Accident · Minor injuriesClosedBeech C-45H · San Bruno, CANov 2, 1970 · N6654R · Destroyed NTSB LAX68F0318Accident · No injuriesClosedBeech C-45H · Palm Sprgs, CAJan 14, 1968 · N9818Z · Substantial damage NTSB OAK68A0047Accident · 3 fatalClosedBeech C-45H · Sanger, CANov 25, 1967 · N9450Z · Destroyed NTSB LAX68A0006Accident · 2 fatalClosedPiper PA-28 · Sepulveda, CAJul 15, 1967 · N5966W · 2 aircraft · Destroyed NTSB LAX67D0064Accident · No injuriesClosedBeech D18 · Van Nuys, CAJul 4, 1966 · N9826Z · Substantial damage NTSB OAK67D0025Accident · No injuriesClosedBeech D18S · San Jose, CAJun 23, 1966 · N8188H · Substantial damage NTSB OAK66D0174Accident · No injuriesClosedBeechcraft C45H · San Francisco, CAJan 17, 1966 · N420RJ · Substantial damage NTSB OAK66F0090Accident · No injuriesClosedBeechcraft D-18S · Concord, CAAug 5, 1965 · N8185H · Substantial damage NTSB UNK64X4050Accident · No injuriesClosedBeechcraft C45H · Fresno, CASep 19, 1964 · N9329Z · Substantial damage NTSB UNK64X2466Accident · No injuriesClosedBeechcraft C45H · Long Beach, CAJun 24, 1964 · N9545Z · Substantial damage