NTSB investigations: Beech 95-A55, 1989
4 cases on aircraft the registry lists as Beech 95-A55. 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 | 7 |
|---|---|
| 1965 | 6 |
| 1966 | 9 |
| 1967 | 8 |
| 1968 | 3 |
| 1969 | 6 |
| 1970 | 8 |
| 1972 | 4 |
| 1973 | 2 |
| 1974 | 3 |
| 1975 | 4 |
| 1976 | 2 |
| 1977 | 3 |
| 1978 | 2 |
| 1979 | 3 |
| 1980 | 1 |
| 1982 | 3 |
| 1983 | 1 |
| 1984 | 3 |
| 1985 | 2 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 4 |
| 1990 | 1 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2004 | 2 |
| 2006 | 1 |
| 2009 | 3 |
| 2010 | 1 |
| 2012 | 2 |
| 2019 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2025 | 1 |
| 2026 | 1 |
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\") = 1989
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152704'))
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") = 1989
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1152704'))
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 FTW90LA028Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Mineral Wells, TXThe landing gear was either not fully extended during the landing or it retracted during the landing roll for an undetermined reason.NTSB LAX89FA287Accident · 2 fatalField investigationFinal reportCessna 180J · Tracy, CAInadequate visual lookout by both pilots, which resulted in their failure to see-and-avoid each other's aircraft. A factor related to the accident was: the lack of a conflict alert system for the stockton arts ii radar.NTSB SEA89LA072Accident · No injuriesLimited investigationFinal reportBeech A55 · Arlington, WAA premature/improper retraction of the landing gear by the second pilot (aircraft owner), who was occupying the right front seat.NTSB NYC89FA097Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Lake Placid, NYThe pilot's departure into known adverse weather conditions and his continued VFR flight into instrument meteorological conditions. Contributing factor(s) was: the adverse weather conditions.