NTSB investigations: Beech V35B, 2015
6 cases on aircraft the registry lists as Beech V35B. 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
| 1970 | 1 |
|---|---|
| 1972 | 1 |
| 1973 | 4 |
| 1974 | 4 |
| 1975 | 5 |
| 1976 | 2 |
| 1977 | 4 |
| 1978 | 6 |
| 1979 | 8 |
| 1980 | 4 |
| 1981 | 6 |
| 1982 | 8 |
| 1983 | 6 |
| 1984 | 4 |
| 1985 | 6 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 8 |
| 1990 | 4 |
| 1991 | 6 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 7 |
| 1996 | 6 |
| 1997 | 3 |
| 1999 | 3 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 6 |
| 2004 | 3 |
| 2005 | 6 |
| 2006 | 2 |
| 2007 | 6 |
| 2008 | 5 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 7 |
| 2013 | 2 |
| 2014 | 3 |
| 2015 | 6 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 4 |
| 2024 | 1 |
| 2025 | 1 |
| 2026 | 3 |
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\") = 2015
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151548'))
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") = 2015
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151548'))
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 CEN16LA082Accident · No injuriesLimited investigationFinal reportBeech V35B · Tahlequah, OKA partial loss of engine power shortly after takeoff due to an inadequately tightened fuel line. Also causal was the pilot's failure to extend the landing gear once the airplane was in a position to safely land on the runway.NTSB GAA15CA295Accident · No injuriesData collectionFinal reportBeech V35B · Houston, TXThe pilot's failure to properly secure the cabin door prior to takeoff, resulting in the door opening during takeoff, an aborted takeoff, runway overrun, and collision with terrain.NTSB ERA15LA357Accident · Minor injuriesLimited investigationFinal reportBeech V35B · Wilmington, NCThe pilot's improper loading of the airplane, which resulted in a sudden pitch up during the attempted takeoff, the pilot’s subsequent loss of directional control, and an aerodynamic stall.NTSB CEN15FA316Accident · 2 fatalField investigationFinal reportBeech V35B · Colbert, OKThe pilot's failure to properly position the fuel selector, which resulted in a total loss of engine power due to fuel starvation. Contributing to the severity of the accident was the pilot's failure to select an appropriate location for a forced landing,…NTSB ERA15CA176Accident · Serious injuriesData collectionFinal reportBeech V35B · Wetumpka, ALThe pilot's use of an incorrect radio frequency when attempting to turn on the runway lights, resulting is an attempt to land the airplane while aligned with airport hangar lights.NTSB ERA15LA092Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Long View, NCThe improper installation of the lower rear crankshaft counterweight snap rings by unknown maintenance personnel, which resulted in the separation of the counterweight and a subsequent total loss of engine power during initial climb.