NTSB investigations: Beech B24R, 1979

8 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, 1979 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") = 1979 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\") = 1979
    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") = 1979
  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 LAX80FVD07Accident · Minor injuriesClosedBeech B24R · Cloverdale, CADec 23, 1979 · N6991R · Destroyed NTSB NYC79FGM42Accident · No injuriesClosedBeech B-24R · Youngsville, PAAug 12, 1979 · N9250S · Substantial damage NTSB SEA79DYE39Accident · Minor injuriesClosedBeech B24R · Burton, WAAug 11, 1979 · N4348W · Substantial damage NTSB MIA79FKA11Accident · Serious injuriesClosedBeech B24R · Arecibo, PRAug 9, 1979 · N24678 · Destroyed NTSB CHI79FA051Accident · 1 fatalClosedBeech 24R · Traverse City, MIJun 4, 1979 · N6561R · Destroyed NTSB MIA79FLD67Accident · No injuriesClosedBeech B24R · Crystal River, FLMay 20, 1979 · N16JT · Substantial damage NTSB MKC79FCJ17Accident · No injuriesClosedBeech B24R · Bertrand, NEMay 6, 1979 · N9345S · Substantial damage NTSB NYC79FHD12Accident · No injuriesClosedBeech B24R · Robbinsville, NJMar 22, 1979 · N9162S · Substantial damage