NTSB investigations: Beech A24R, CA
9 cases on aircraft the registry lists as Beech A24R. 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
| 1974 | 2 |
|---|---|
| 1981 | 1 |
| 1982 | 2 |
| 1983 | 1 |
| 1988 | 2 |
| 1996 | 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 ('1151252'))
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 ('1151252'))
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 LAX96LA221Accident · No injuriesLimited investigationFinal reportBeech 23-A24R · Modesto, CAfuel exhaustion due to the pilot's inadequate preflight inspection of the aircraft.NTSB LAX89LA072Accident · No injuriesLimited investigationFinal reportBeech A24R · Grass Valley, CAAt the end of a cross country flight, during the landing roll, the airplane began to slide to the left. The pilot was unable to regain control due to the patchy snow and ice on the runway. The airplane exited the runway and collided with a snow bank. There…NTSB LAX89FA006Accident · 2 fatalField investigationFinal reportBeech A24R · Mt. Baldy, CAPilot's improper in-flight decision and altitude.NTSB LAX83LA161Accident · Minor injuriesLimited investigationFinal reportBeech A24R · Upland, CAWhile on final apch to land, the plt saw 2 other acft taxi onto the rwy & began taking off. After the 2nd acft had pulled onto the rwy, the plt decided to go around. However as the acft on the rwy accelerated, there appeared to be sufficient room to land, so…NTSB LAX82FA183Accident · 4 fatalField investigationFinal reportBeech A24R · Near Mt. Shasta, CAThe flight originated at reno, NV, but the pilot landed at red bluff, CA after receiving an in-flight weather briefing. After landing, he obtained another weather briefing and was advised that VFR flight was not recommended. He then filed a VFR flight plan…NTSB LAX82FA156Accident · Minor injuriesField investigationFinal reportBeech A24R · Camarillo, CAThe pilot took off from the Camarillo airport on a local flight to practice touch and go landings. He had made two touch and go patterns and was on his third and final landing when the collision occurred. He had transmitted his position on downwind and base…NTSB LAX82FA124Accident · 2 fatalClosedBeech A24R · Yucca Valley, CANTSB LAX75FUQ04Accident · No injuriesClosedBeech A24R · Lancaster, CANTSB OAK74AP064Accident · Serious injuriesClosedBeech A24R · Lincoln, CA