NTSB investigations: Beech 58, 1979
13 cases on aircraft the registry lists as Beech 58. 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1967 | 1 |
| 1971 | 1 |
| 1972 | 6 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 7 |
| 1976 | 5 |
| 1977 | 9 |
| 1978 | 8 |
| 1979 | 13 |
| 1980 | 6 |
| 1981 | 8 |
| 1982 | 11 |
| 1983 | 9 |
| 1984 | 7 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 10 |
| 1988 | 3 |
| 1989 | 6 |
| 1990 | 6 |
| 1991 | 7 |
| 1992 | 9 |
| 1993 | 8 |
| 1994 | 5 |
| 1995 | 7 |
| 1996 | 6 |
| 1997 | 3 |
| 1998 | 8 |
| 1999 | 6 |
| 2000 | 10 |
| 2001 | 6 |
| 2002 | 7 |
| 2003 | 4 |
| 2004 | 3 |
| 2005 | 4 |
| 2006 | 1 |
| 2007 | 7 |
| 2008 | 1 |
| 2009 | 3 |
| 2010 | 6 |
| 2011 | 5 |
| 2012 | 8 |
| 2013 | 3 |
| 2015 | 4 |
| 2016 | 2 |
| 2017 | 3 |
| 2018 | 4 |
| 2019 | 1 |
| 2022 | 5 |
| 2023 | 1 |
| 2024 | 7 |
| 2025 | 1 |
| 2026 | 4 |
Where
Open the mapLatest cases
Query with SQL
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 ('1152740'))
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 ('1152740'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI80DA018Accident · 2 fatalClosedBeech B58 · Taylorville, ILNTSB MKC80FCG02Accident · No injuriesClosedBeech 58 · Kansas City, MONTSB NYC80FA085Accident · 1 fatalClosedBeech 58 · Middletown, PANTSB IAD79FID20Accident · No injuriesClosedBeech 58 · Keysville, VANTSB MIA79FA071Accident · 2 fatalClosedBeech 58 · Boca Ration, FLNTSB CHI79FEE46Accident · No injuriesClosedBeech 58 · Lansing, ILNTSB FTW79FPG21Accident · No injuriesClosedBeech 58 · Fort Smith, ARNTSB MKC79FCA11Accident · Serious injuriesClosedBeech 58 · Chesterfield, MONTSB MIA79FA054Accident · 3 fatalClosedBeech 58 · Greenville, MSNTSB NYC79FA025Accident · Serious injuriesClosedBeech 58 · Oneonta, NYNTSB MIA79DKG19Accident · No injuriesClosedBeech B58 · Augusta, GANTSB NYC79FGM14Accident · No injuriesClosedBeech 58 · Beaver Falls, PANTSB NYC79FGM09Accident · No injuriesClosedBeech BE-58 · Beaver Falls, PA