NTSB investigations: Beech B24R, 1978

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

19742026

NTSB investigations: Beech B24R, 1978 per year, 1974–2026: 88 cases
1974	3
1975	5
1976	7
1977	3
1978	9
1979	8
1980	1
1981	5
1982	2
1983	1
1984	2
1986	1
1987	3
1988	3
1989	3
1990	1
1991	2
1992	4
1993	2
1994	2
1995	3
1996	1
1999	1
2000	3
2001	1
2003	1
2005	1
2007	2
2009	1
2011	1
2012	1
2016	1
2019	1
2021	1
2024	1
2025	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 year(c."eventDate") = 1978 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151253')) 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 year(c.\"eventDate\") = 1978
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151253'))
  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 year(c."eventDate") = 1978
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151253'))
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 MIA79DLG10Accident · No injuriesClosedBeech B24 · Rock Hill, SCDec 16, 1978 · N6543R · Substantial damage NTSB FTW78DQG44Accident · No injuriesClosedBeech B24R · Follett, TXJul 25, 1978 · N7117E · Substantial damage NTSB SEA78FA044Accident · 1 fatalClosedBeech B24R · Vashon, WAJul 11, 1978 · N6591R · Destroyed NTSB OAK78FVA51Accident · No injuriesClosedBeech 24R · Groveland, CAJun 25, 1978 · N9359S · Substantial damage NTSB DEN78FTE63Accident · Minor injuriesClosedBeech B24R · Co.Springs, COJun 15, 1978 · N6563R · Substantial damage NTSB NYC78FNA24Accident · Serious injuriesClosedBeech 24R · Beverly, MAMay 25, 1978 · N9349S · Substantial damage NTSB CHI78FET17Accident · Serious injuriesClosedBeech B24R · Berrien Sprngs, MIApr 16, 1978 · N2525W · Substantial damage NTSB FTW78DPJ13Accident · No injuriesClosedBeech B24R · Hennessey, OKMar 29, 1978 · N2506W · Substantial damage NTSB NYC78FNE15Accident · Serious injuriesClosedBeech 24R · Madson, CTMar 24, 1978 · N2186W · Substantial damage