NTSB investigations: Beech S35, 1987
3 cases on aircraft the registry lists as Beech S35. 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 | 3 |
|---|---|
| 1965 | 11 |
| 1966 | 18 |
| 1967 | 14 |
| 1968 | 16 |
| 1969 | 9 |
| 1970 | 7 |
| 1971 | 9 |
| 1972 | 8 |
| 1973 | 6 |
| 1974 | 7 |
| 1975 | 5 |
| 1976 | 6 |
| 1977 | 3 |
| 1978 | 5 |
| 1979 | 3 |
| 1980 | 4 |
| 1981 | 3 |
| 1982 | 2 |
| 1983 | 3 |
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 3 |
| 1988 | 2 |
| 1989 | 4 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 4 |
| 1993 | 4 |
| 1994 | 1 |
| 1995 | 3 |
| 1996 | 2 |
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2002 | 5 |
| 2003 | 6 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 1 |
| 2009 | 3 |
| 2011 | 2 |
| 2012 | 3 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 3 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 2 |
| 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\") = 1987
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151532'))
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") = 1987
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151532'))
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 CHI87DEC04Accident · 2 fatalFinal reportBeech S35 · Pontiac, MIAcft was making a low pass about 200 ft AGL over rwy 27L to allow ATCT personnel to inspect landing gear position after reporting landing gear difficulties. After twr personnel informed the plt that the gear appeared to be down, the plt requested to land on…NTSB LAX87LA164Accident · No injuriesLimited investigationFinal reportBeech S35 · Tucson, AZThe aircraft door came open during the initial climb after takeoff because it was not properly closed and locked. The pilot raised the landing gear. Thereafter, because of slow acceleration, he elected to land on the remaining runway. He moved the landing…NTSB MKC87LA052Accident · No injuriesLimited investigationFinal reportBeech B-35 · Butler, MOThe PIC flew a traffic pattern that placed him landing long to the rwy at Butler, MO. The PIC perceived an eng failure prior to attempting a go-around and activated the fuel boost pump and advanced the throttle. The PIC rptd the eng faultered and quit. The…