NTSB investigations: Beech A35, 1965
20 cases on aircraft the registry lists as Beech A35. 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 | 12 |
|---|---|
| 1965 | 20 |
| 1966 | 18 |
| 1967 | 9 |
| 1968 | 14 |
| 1969 | 5 |
| 1970 | 12 |
| 1971 | 8 |
| 1972 | 9 |
| 1973 | 11 |
| 1974 | 8 |
| 1975 | 6 |
| 1976 | 8 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 2 |
| 1980 | 7 |
| 1981 | 5 |
| 1982 | 2 |
| 1983 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 4 |
| 1988 | 3 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 2 |
| 2005 | 3 |
| 2008 | 1 |
| 2010 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 2 |
| 2024 | 2 |
| 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\") = 1965
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151504'))
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") = 1965
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151504'))
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 FTW66A0061Accident · 4 fatalClosedBeech A35 · Llano, TXNTSB MIA66F0357Accident · No injuriesClosedBeechcraft A35 · Miami, FLNTSB MIA66F0366Accident · Minor injuriesClosedBeech A35 · Lake Worth, FLNTSB OAK66D0151Accident · Minor injuriesClosedBeechcraft A35 · Lodi, CANTSB NYC66F0142Accident · No injuriesClosedBeechcraft A35 · Elkton, MDNTSB MIA66A0019Accident · 1 fatalClosedBeechcraft A-35 · Statesville, NCNTSB MIA66A0018Accident · 4 fatalClosedBeechcraft A35 · Mathiston, MSNTSB CHI66A0013Accident · 4 fatalClosedBeechcraft A35 · Woodville, OHNTSB CHI66F0189Accident · No injuriesClosedBeechcraft A-35 · Green Bay, WINTSB SEA66A0005Accident · 1 fatalClosedBeech 35 · 4w Malta, IDNTSB OAK66D0080Accident · No injuriesClosedBeechcraft A-35 · Kneeland, CANTSB LAX66F0062Accident · No injuriesClosedBeechcraft A-35 · Hawthorne, CANTSB MKC66F0027Accident · No injuriesClosedBeechcraft A-35 · Warrensburg, MONTSB FTW66F0021Accident · No injuriesClosedBeechcraft A-35 · Ardmore, OKNTSB FTW65F0025Accident · No injuriesClosedBeechcraft A-35 · Midland, TXNTSB LAX65A0070Accident · 2 fatalClosedBeechcraft 35A · Imperial, CANTSB UNK65X1426Accident · No injuriesClosedBeechraft A-35 · Tulsa, OKNTSB NYC65F0040Accident · No injuriesClosedBeechraft 35 · Syracuse, NYNTSB MKC65F0051Accident · No injuriesClosedBeechcraft A35 · Wichita, KSNTSB UNK65X1273Accident · Serious injuriesClosedBeechraft A-35 · Hearne, TX