Skip to content

NTSB investigations: Beech B19, CA

22 cases on aircraft the registry lists as Beech B19. 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

19712026

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 ('1151215')) 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 ('1151215'))
  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 ('1151215'))
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 WPR24LA221Accident · No injuriesClass 4 · LimitedFinal reportBeech B19 · Running Springs, CAThe pilot’s decision to maneuver the airplane at a low altitude toward rising terrain, which exceeded the climb capability of the airplane.Jul 1, 2024 · N6553R · Substantial damage NTSB GAA19CA109Accident · No injuriesData collectionFinal reportBeech B19 · Los Angeles, CAThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion and impact with a fence.Jan 26, 2019 · N24682 · Substantial damage NTSB LAX94LA362Accident · No injuriesLimited investigationFinal reportBeech B19 · Big Bear City, CAthe failure and separation of the right main landing gear wheel assembly due to a preexisting and undetected crack.Sep 11, 1994 · N19NH · Substantial damage NTSB LAX90LA107Accident · No injuriesLimited investigationFinal reportBeech B-19 · Chiriaco Summit, CAA engine compartment fire of undetermined origin dduring engine start.Feb 28, 1990 · N24015 · Destroyed NTSB LAX85IA370Incident · No injuriesIncident investigationFinal reportBeech B19 · Van Nuys, CAAfter departure, at about 800 feet, the right airleron became disconnected. The pilot was able to make a left turn, fly a left hand traffic pattern and land successfully. Examination of the aircraft revealed that the right inboard aileron control push rod had…Aug 23, 1985 · N9718L · Minor damage NTSB LAX80DXQ38Accident · No injuriesClosedBeech B19 · S.Lake Tahoe, CAAug 4, 1980 · N24647 · Substantial damage NTSB LAX79DUQ36Accident · No injuriesClosedBeech 19 · Santa Barbara, CAJun 21, 1979 · N4344W · Substantial damage NTSB OAK78FVG78Accident · Serious injuriesClosedBeech B19 · Lower Lake, CASep 4, 1978 · N4349W · Substantial damage NTSB LAX78DVA33Accident · No injuriesClosedBeech B23 · Bakersfield, CAApr 9, 1978 · N9737L · Substantial damage NTSB LAX78FUQ11Accident · No injuriesClosedBeech B19 · Van Nuys, CAJan 20, 1978 · N18966 · 2 aircraft · Substantial damage NTSB OAK77DVM27Accident · No injuriesClosedBeech B19 · San Carlos, CASep 7, 1977 · N6619R · Substantial damage NTSB OAK77FVG30Accident · No injuriesClosedBeech B19 · Placerville, CAApr 26, 1977 · N2187W · Destroyed NTSB OAK76DVD21Accident · Minor injuriesClosedBeech B19 · Rohnerville, CADec 13, 1975 · N2183W · Destroyed NTSB OAK76AP024Accident · 1 fatalClosedBeech B19 · Coalinga, CAOct 26, 1975 · N24594 · Destroyed NTSB OAK75DVA46Accident · No injuriesClosedBeech B19 · Los Banos, CAMar 1, 1975 · N2198W · Substantial damage NTSB OAK75FVD35Accident · No injuriesClosedBeech B19 · Hayward, CAJan 14, 1975 · N2183W · Substantial damage NTSB LAX75FUQ18Accident · No injuriesClosedBeech B19 · Lancaster, CANov 30, 1974 · N1984W · Substantial damage NTSB LAX75AL029Accident · 1 fatalClosedBeech B19 · Tehachapi, CANov 21, 1974 · N9743Q · Destroyed NTSB OAK75DVA19Accident · No injuriesClosedBeech B19 · Columbia, CASep 22, 1974 · N2198W · Substantial damage NTSB OAK74FVG18Accident · No injuriesClosedBeech B19 · Sacremento, CAOct 18, 1973 · N1949W · Substantial damage NTSB LAX73FUM20Accident · No injuriesClosedBeech B19 · San Diego, CAMar 3, 1973 · N9703L · Substantial damage NTSB LAX72FUD04Accident · No injuriesClosedBeech A23-19 · Sta Monica, CAOct 8, 1971 · N6147N · Destroyed