NTSB investigations: Beech A35, 1989
2 cases on aircraft the registry lists as Beech A35. 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 | 12 |
|---|---|
| 1965 | 20 |
| 1966 | 18 |
| 1967 | 9 |
| 1968 | 14 |
| 1969 | 5 |
| 1970 | 12 |
| 1971 | 8 |
| 1972 | 9 |
| 1973 | 11 |
| 1974 | 8 |
| 1975 | 6 |
| 1976 | 8 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 2 |
| 1980 | 7 |
| 1981 | 5 |
| 1982 | 2 |
| 1983 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 2 |
| 2005 | 3 |
| 2008 | 1 |
| 2010 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 2 |
| 2025 | 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 ('1151504'))
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 ('1151504'))
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 FTW89GA170Accident · 2 fatalFinal reportBeech A35 · Escondido, CASpatial disorientation of the pilot after he initiated flight into IMC conditions, and his exceeding the design stress limits of the airplane during the attempted recovery. Related factors were: the pilot's lack of total and recent instrument flight…NTSB LAX89LA255Accident · No injuriesLimited investigationFinal reportBeech A35 · Hemet, CALoss of engine power for undetermined reasons.