NTSB investigations: Beech B23
4 cases on aircraft the registry lists as Beech B23, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1995 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151240')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151240')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 CHI95LA184Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Neligh, NEthe pilot's selection of the wrong runway for takeoff, and his failure to compensate for the tailwind. A factor was the tailwind.NTSB LAX95LA203Accident · No injuriesLimited investigationFinal reportBeech B23 · Mariposa, CAthe pilot's premature liftoff and his failure to attain and maintain sufficient airspeed during the intial climb which resulted in an inadvertent stall/mush back onto the runway. The pilot's failure to maintain directional control as the aircraft touched down…NTSB DEN84FA144Accident · 1 fatalField investigationFinal reportBeech B23 · Ruidoso, NMThe pilot stated that upon landing a gust of wind blew the aircraft off the runway center and he initiated a go-around. Witnesses stated the aircraft climbed to approximately 200 to 300 ft and started a left turn. Engine power appeared to be minimal. As the…NTSB FTW82FA152Accident · 2 fatalField investigationFinal reportBeech B23 · Roanoke, TXWitnesses reported that the aircraft appeared to takeoff and climb normally until it reached an altitude of about 100 ft AGL. It then pitched up abruptly to about a 70 deg nose high attitude. After the pitch-up, the aircraft climbed to about 175 to 200 ft…