NTSB investigations: Beech 58, 2022
5 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\") = 2022
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") = 2022
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 WPR22FA332Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Galt, CAThe certified flight instructor's failure to maintain control of the airplane and inadequate supervision of the flight, which resulted in an aerodynamic stall/spin from which he could not recover.NTSB CEN22LA250Incident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Evansville, INThe failure of the propeller blade due to high-cycle fatigue that originated from damage that occurred at an unknown time. Contributing to the accident was the failure to identify the damage before the accident flight.NTSB ERA22LA246Accident · No injuriesClass 3 · LimitedFinal reportBeech 58 · Perry, GAThe pilot’s failure to properly configure the landing gear before landing.NTSB ERA22FA126Accident · 1 fatalClass 3 · FieldFinal reportBeech 58 · Lexington, NCInadequate maintenance, which led to a partial loss of both right and left engine power during takeoff, and the pilot’s subsequent failure to maintain airspeed while maneuvering with one engine at low altitude. Contributing to the accident was the pilot’s…NTSB CEN22FA096Accident · 2 fatalClass 3 · FieldFinal reportBeech 58 · Defiance, MOThe pilot’s loss of airplane control while flying in night instrument conditions due to spatial disorientation and the flight crew’s inability to recover from an unusual airplane attitude.