NTSB investigations: Beech 23, TN

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

19642026

NTSB investigations: Beech 23, TN per year, 1964–2026: 10 cases
1964	3
1965	1
1967	1
1970	1
1974	1
1978	1
2015	1
2021	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" = 'TN' 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 ('1151202')) 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\" = 'TN' 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 ('1151202'))
  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" = 'TN' 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 ('1151202'))
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 ERA21LA149Accident · No injuriesClass 4 · LimitedFinal reportBeech 23 · Rogersville, TNThe pilot's improper landing flare, which resulted in an initial hard landing, separation of the left main landing gear, and a runway excursion during a subsequent landing attempt.Mar 3, 2021 · N2374J · Substantial damage NTSB ERA16LA019Accident · No injuriesLimited investigationFinal reportBeech 23 · Humboldt, TNA partial loss of engine power due to low No. 2 cylinder compression and an inoperative right magneto.Oct 18, 2015 · N2339J · Substantial damage NTSB IAD79FKW02Accident · Serious injuriesClosedBeech A23 · Knoxville, TNDec 3, 1978 · N2308Q · Destroyed NTSB IAD74DKW32Accident · No injuriesClosedBeech 23 · Oneida, TNMar 31, 1974 · N2313Q · Substantial damage NTSB MIA71AM028Accident · 2 fatalClosedBeech 23 · Gates, TNSep 18, 1970 · N2331Q · Destroyed NTSB MIA67D0003Accident · No injuriesClosedBeech 23 · Crossville, TNJun 10, 1967 · N2394L · Substantial damage NTSB MIA66F0386Accident · No injuriesClosedBeechcraft 23 · Knoxville, TNDec 14, 1965 · N2399Z · Substantial damage NTSB UNK65X0603Accident · 2 fatalClosedBeechcraft 23 · Grd Junction, TNNov 7, 1964 · N8713M · Destroyed NTSB UNK64X2186Accident · No injuriesClosedBeechraft B23 · Chuckey, TNJun 8, 1964 · N2399Z · Substantial damage NTSB UNK64X1240Accident · No injuriesClosedBeechcraft 23 · Nashville, TNApr 9, 1964 · N8743M · Substantial damage