NTSB investigations: Beech V35, 1989
6 cases on aircraft the registry lists as Beech V35. 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
| 1966 | 6 |
|---|---|
| 1967 | 14 |
| 1968 | 9 |
| 1969 | 8 |
| 1970 | 3 |
| 1971 | 5 |
| 1972 | 8 |
| 1973 | 7 |
| 1974 | 8 |
| 1975 | 4 |
| 1976 | 7 |
| 1977 | 1 |
| 1978 | 7 |
| 1979 | 2 |
| 1980 | 4 |
| 1981 | 3 |
| 1982 | 3 |
| 1983 | 2 |
| 1985 | 1 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 6 |
| 1990 | 1 |
| 1991 | 4 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 7 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 2 |
| 2002 | 2 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 2 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 2 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 4 |
| 2019 | 5 |
| 2020 | 2 |
| 2021 | 2 |
| 2023 | 3 |
| 2024 | 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 ('1151538'))
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 ('1151538'))
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 CHI90LA042Accident · No injuriesLimited investigationFinal reportBeech V35 · Cable, WIThe pilot's failure to adequately compensate for crosswind conditions. Contributing to the accident was the gusty, crosswind conditions which existed.NTSB FTW90LA035Accident · Minor injuriesLimited investigationFinal reportBeech V35 · Crosbyton, TXImproper overhaul of the aircraft engine by maintenance personnel that led to the complete loss of engine oil due to an undertorqued oil cooler assembly. Factors in the accident were the failure of maintenance personnel to detect the condition during the…NTSB LAX90FA010Accident · 1 fatalField investigationFinal reportBeech V35 · Goleta, CAThe pilot's attempt to conduct visual flight into adverse weather conditions at an altitude that would not provide terrain clearance. The weather condition was a related factor.NTSB LAX89FA294Accident · 1 fatalField investigationFinal reportBeech V35TC · Fort Jones, CAThe failure of the pilot to maintain sufficient altitude.NTSB BFO89FA060Accident · 1 fatalField investigationFinal reportBeech V35TC · Charlottesville, VAImproper installation of the throttle and variable absolute controller assemblies by maintenance personnel which resulted in a total loss of engine power.NTSB BFO89FA019Accident · 1 fatalField investigationFinal reportBeech V35TC · Roanoke, VAThe pilot failed to maintain control of the aircraft due to spatial disorientation.