NTSB investigations: Beech V35A, 1988
3 cases on aircraft the registry lists as Beech V35A. 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
| 1965 | 1 |
|---|---|
| 1968 | 3 |
| 1969 | 5 |
| 1970 | 8 |
| 1971 | 8 |
| 1972 | 6 |
| 1973 | 5 |
| 1974 | 4 |
| 1975 | 6 |
| 1976 | 1 |
| 1977 | 6 |
| 1978 | 2 |
| 1979 | 4 |
| 1980 | 4 |
| 1981 | 5 |
| 1982 | 1 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 3 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 1 |
| 2009 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2014 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 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\") = 1988
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151544', '1151542'))
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") = 1988
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151544', '1151542'))
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 NYC89LA002Accident · Serious injuriesLimited investigationFinal reportBeech V35A · Derry, NHThe acft collided with trees after takeoff from a private airstrip with a rwy which has 1,200 feet useable length. The field elev is 425 ft and the plt EST the temp to be 60 deg f. the plt said the takeoff was made to the NE. The wind was reported to be out…NTSB MIA89LA002Accident · Minor injuriesLimited investigationFinal reportBeech V35A · Fort Lauderdale, FLThe plt stated that aprx 15 minutes after takeoff from Fort Lauderdale, the eng quit completely & he was unable to make it back to the arpt. While attempting a forced landing in a field, he landed nose down, the nose gear collapsed, and the acft slid to a…NTSB CHI88DEX05Accident · No injuriesFinal reportBeech V35A · Seymour, INAircraft was in cruise flight at 6500 feet when engine began to run rough. Pilot navigated to nearest airport and made intentional gear-up landing with cruise power. Postcrash investigation revealed number 2 exhaust valve had failed and become wedged between…