NTSB investigations: Beech C23, AK

7 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19762026

NTSB investigations: Beech C23, AK per year, 1976–2026: 7 cases
1976	2
1977	1
1978	2
1982	1
1983	1

Where

Open the map

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" = 'AK' 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

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\" = 'AK' 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" = 'AK' 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

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 ANC83FA171Accident · No injuriesField investigationFinal reportBeech C-23 · Northway, AKThe acft nose gear collapsed during a forced landing after the engine quit at 300 ft AGL during takeoff. The plt stated the engine quit suddenly with and warning at 300 ft AGL. Witnesses on the arpt said they heard the engine misfiring and backfiring so badly…Sep 15, 1983 · N9365S · Substantial damage NTSB ANC82DA030Accident · No injuriesFinal reportBeech C23 · Kenai, AKDuring the landing roll the aircraft swerved left, right, then left again before leaving the left edge of the runway about 1700 feet beyond the landing threshold. It passed over a snow berm before coming to rest perpendicular to the runway.Apr 4, 1982 · N6714E · Substantial damage NTSB ANC78DAG98Accident · Minor injuriesClosedBeech C23 · Big Lake, AKJun 10, 1978 · N1964L · Destroyed NTSB ANC78DAG69Accident · Minor injuriesClosedBeech C23 · Homer, AKApr 23, 1978 · N9168S · Substantial damage NTSB ANC77FA043Accident · 1 fatalClosedBeech C-23 · Dan Creek, AKMay 13, 1977 · N1931L · Destroyed NTSB ANC76DAH50Accident · Minor injuriesClosedBeech C23 · Cantwell, AKJul 20, 1976 · N9168S · Substantial damage NTSB ANC76DAH14Accident · No injuriesClosedBeech C23 · Glenallen, AKMay 12, 1976 · N9365S · Substantial damage