NTSB investigations: Beech 19A, CA
12 cases on aircraft the registry lists as Beech 19A. 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.
Cases per year
| 1969 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 2 |
| 1978 | 1 |
| 2003 | 1 |
| 2010 | 1 |
| 2022 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('1151214'))
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 ('1151214'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR22FA196Accident · 2 fatalClass 3 · FieldFinal reportBeech 19A · Oroville, CAThe pilot’s failure to maintain proper airspeed during a turn and his exceedance of the airplane’s critical angle of attack, which resulted in an accelerated stall. Contributing to the accident was the improper placement of the fuel selector, which resulted…NTSB WPR11FA054Accident · 3 fatalField investigationFinal reportBeech 19A · Newport Beach, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB LAX03LA120Accident · No injuriesLimited investigationFinal reportBeech 19A · Coalinga, CAThe pilot's failure to obtain/maintain an adequate airspeed, which resulted in a stall/mush.NTSB OAK78FVG46Accident · No injuriesClosedBeech 19A · Butte City, CANTSB LAX75FUQ17Accident · No injuriesClosedBeech B19A · Simi, CANTSB LAX74FUM32Accident · Serious injuriesClosedBeech A23-19 · San Diego, CANTSB OAK74FVD10Accident · Serious injuriesClosedBeech 19A · Stockton, CANTSB OAK73FVD05Accident · No injuriesClosedBeech A23-19 · Vineburg, CANTSB OAK71DVG82Accident · Minor injuriesClosedBeech 19A · Pope Valley, CANTSB OAK71DVA70Accident · No injuriesClosedBeech A23-19 · Fresno, CANTSB LAX70DUG06Accident · No injuriesClosedBeech A23-19 · Hemet, CANTSB LAX69F0258Accident · No injuriesClosedBeech A23-19 · Van Nuys, CA