NTSB investigations: Beech D35, 2002
5 cases on aircraft the registry lists as Beech D35. 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 | 9 |
|---|---|
| 1965 | 14 |
| 1966 | 11 |
| 1967 | 11 |
| 1968 | 8 |
| 1969 | 5 |
| 1970 | 4 |
| 1971 | 3 |
| 1972 | 5 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 2 |
| 1977 | 3 |
| 1978 | 1 |
| 1979 | 2 |
| 1983 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 2 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 2 |
| 2001 | 1 |
| 2002 | 5 |
| 2005 | 2 |
| 2006 | 2 |
| 2009 | 1 |
| 2010 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2018 | 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\") = 2002
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151510'))
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") = 2002
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151510'))
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 CHI03LA021Accident · Serious injuriesLimited investigationFinal reportBeech D35 · Dodge Center, MNThe loss of engine power due to a fractured engine driven pump shaft pin. The low altitude and unsuitable terrain encountered were contributing factors.NTSB ATL02LA106Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hernando, MSThe pilot's failure to maintain wing tip clearance during an attempted takeoff that resulted in the collision with the ground.NTSB ATL02FA091Accident · 2 fatalField investigationFinal reportBeech BE-35 · Warsaw, NCThe pilot's physical impairment due to the use of marijuana. The pilot's diminished judgment to continue flight into known instrument flight conditions that resulted in an in-flight loss of control, failure of the right wing due to overstress separation, and…NTSB FTW02FA106Accident · 1 fatalField investigationFinal reportBeech D35 · Nacogdoches, TXThe failure of the engine driven fuel pump drive pin resulted in a total loss of engine power. Contributing factors were inadequate maintenance, the pilot's inadequate use of the manual auxillary fuel pump (wobble pump), and the night conditions.NTSB CHI02LA089Accident · No injuriesLimited investigationFinal reportBeech D35 · Ankeny, IAthe excessive flare by the pilot. The icing conditions were a contributing factor.