NTSB investigations: Beech V35A, 1984
2 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\") = 1984
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") = 1984
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 FTW85FA078Accident · 1 fatalField investigationFinal reportBeech V35A · Midlothian, TXN7460N, operating as mid-america flt 401, crashed while on an IFR flt plan enroute to corpus christi, TX. After having been vectored around a heavy thunderstorm & cleared direct to waco, TX. The plt contacted fort worth center & stated that he had 'lost my…NTSB DEN84LA178Accident · No injuriesLimited investigationFinal reportBeech V35A · Dove Creek, COWhile en route, the plt encountered hazy wx after crossing the Continental divide. Near montrose, CO, he deviated about 50 mi north to avoid adverse wx. He was unable to get thru, so he proceeded back to montrose to skirt the southern edge of the wx. He…