NTSB investigations: Beech A23, PA

11 cases on aircraft the registry lists as Beech A23. 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

19652026

NTSB investigations: Beech A23, PA per year, 1965–2026: 11 cases
1965	1
1967	3
1971	1
1972	1
1976	1
1978	2
1979	1
1999	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" = 'PA' 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 ('1151204')) 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\" = 'PA' 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 ('1151204'))
  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" = 'PA' 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 ('1151204'))
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 NYC99LA223Accident · No injuriesLimited investigationFinal reportBeech A23 · Carlisle, PAThe pilot's improper fuel management, resulting in fuel starvation.Sep 12, 1999 · N3508R · Substantial damage NTSB NYC80FGM03Accident · Minor injuriesClosedBeech A23 · Bradford, PAOct 22, 1979 · N8865M · Substantial damage NTSB NYC78DHA29Accident · Minor injuriesClosedBeech A23 · New Hanover, PAJun 25, 1978 · N1453L · Substantial damage NTSB NYC78FGT09Accident · Minor injuriesClosedBeech A23 · State College, PAJun 15, 1978 · N3521R · Substantial damage NTSB NYC76FGM43Accident · No injuriesClosedBeech A-23 · Somerset, PAAug 10, 1976 · N3557R · Substantial damage NTSB NYC72FHD38Accident · No injuriesClosedBeech B23 · Ambler, PAApr 30, 1972 · N3521R · Substantial damage NTSB NYC71FGM27Accident · No injuriesClosedBeech A23 · Belle Vernon, PAJan 24, 1971 · N8742M · Substantial damage NTSB NYC68F0257Accident · No injuriesClosedBeech A23 · Seneca, PANov 8, 1967 · N1458L · Substantial damage NTSB NYC67D0567Accident · No injuriesClosedBeech A23 · Montgomryville, PAApr 1, 1967 · N8763M · Substantial damage NTSB NYC67D0518Accident · No injuriesClosedBeech A23 · Easton, PAJan 30, 1967 · N3550R · Substantial damage NTSB NYC66D0364Accident · No injuriesClosedBeechcraft A-23 · Doylestown, PANov 28, 1965 · N3552R · Substantial damage