NTSB investigations: Beech C23, AZ
12 cases on aircraft the registry lists as Beech C23. 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
| 1976 | 1 |
|---|---|
| 1977 | 2 |
| 1979 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2010 | 1 |
| 2016 | 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\" = 'AZ' 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 ('1151242'))
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" = 'AZ' 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 ('1151242'))
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 WPR16LA128Accident · Minor injuriesLimited investigationFinal reportBeech C23 · Prescott, AZThe pilots' improper inflight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB WPR10CA400Accident · Minor injuriesData collectionFinal reportBeech C23 · Wenden, AZThe pilot’s inadequate bounced landing recovery and failure to maintain directional control during landing.NTSB LAX08CA075Accident · No injuriesData collectionFinal reportBeech C23 · Marble Canyon, AZThe pilot's inadequate compensation for the wind conditions and failure to maintain an adequate airspeed during the flare. Contributing to the accident were wind gusts and a crosswind.NTSB LAX07CA226Accident · No injuriesData collectionFinal reportBeech C23 · Taylor, AZthe student pilot's misjudged landing flare and inadequate recovery from a bounced landing that resulted in a hard landing and a loss of directional control.NTSB LAX06CA052Accident · No injuriesData collectionFinal reportBeech C23 · Holbrook, AZThe student pilot's abrupt flare and failure to maintain airspeed, which resulted in a stall. The flight instructor's inadequate supervision of the flight was also causal.NTSB LAX91FA219Accident · Serious injuriesField investigationFinal reportBeech C23 · Cibola, AZThe pilot's failure to maintain adequate clearance between the aircraft and ground vehicle during a low pass resulting in an in flight collision with the vehicle, loss of control, and in flight collision with terrain. Factors related to the accident was the…NTSB LAX84LA388Accident · No injuriesLimited investigationFinal reportBeech C-23 · Chandler, AZThe student plt was on his 1st solo flt. He reported that the acft bounced during a landing, then 'started to head off to the left.' He reported that he 'came in with power & rudder' but the acft went off the rwy & hit a mound of dirt & a fence.NTSB LAX83LA010Accident · No injuriesLimited investigationFinal reportBeech C23 · Sedona, AZThe pilot reported that he entered the traffic pattern to land on runway 03 with the wind down the runway at 20, gusting 25 KTS. He made a go-around on his first approach, during the second approach, he encountered a gust of wind, landed hard and the aircraft…NTSB LAX79DUJ70Accident · No injuriesClosedBeech C-23 · Phoenix, AZNTSB LAX77DUK05Accident · No injuriesClosedBeech C23 · Tucson, AZNTSB LAX77DUJ80Accident · No injuriesClosedBeech C23 · Tucson, AZNTSB LAX76AL069Accident · 4 fatalClosedBeech C23 · Lukackukai, AZ