NTSB investigations: Beech 58P, 1985
3 cases on aircraft the registry lists as Beech 58P. 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
| 1977 | 2 |
|---|---|
| 1978 | 3 |
| 1979 | 4 |
| 1981 | 4 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 3 |
| 1985 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1989 | 2 |
| 1991 | 4 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 5 |
| 1995 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 2 |
| 2006 | 2 |
| 2007 | 1 |
| 2008 | 2 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 3 |
| 2014 | 1 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 2 |
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\") = 1985
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152744'))
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") = 1985
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152744'))
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 DEN85LA199Accident · No injuriesLimited investigationFinal reportBeech 58P · Buena Vista, COThe left engine failed during takeoff at an altitude of about 40 ft AGL. During the forced landing, the plt used incorrect emergency procedures and failed to maintain lateral and directional control of the acft. Inspection of the acft revealed a disintegrated…NTSB FTW85LA227Accident · No injuriesLimited investigationFinal reportBeech 58P · Abilene, TXThe plt stated he made a normal landing and the gear folded during the rollout. Another plt who was waiting at the end of the rwy for takeoff observed the landing and stated the landing gear was extended too late and was still in transit (not fully down) when…NTSB CHI85LA089Accident · No injuriesLimited investigationFinal reportBeech 58P · Grand Rapids, MIAt 1215 EST, a ground vehicle operator (S-1) rprtd that the braking action was poor on the rwys & taxiways (twys). In the next 9 min, 5 snow plows were cleared onto twys a & e. a short time later, the plt of N58PC was cleared to taxi fm the general aviation…