NTSB investigations: Beech G35, 1965
17 cases on aircraft the registry lists as Beech G35. 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 | 16 |
|---|---|
| 1965 | 17 |
| 1966 | 24 |
| 1967 | 10 |
| 1968 | 8 |
| 1969 | 4 |
| 1970 | 9 |
| 1971 | 4 |
| 1972 | 5 |
| 1973 | 4 |
| 1974 | 5 |
| 1975 | 10 |
| 1976 | 1 |
| 1977 | 3 |
| 1978 | 4 |
| 1979 | 2 |
| 1980 | 3 |
| 1981 | 3 |
| 1982 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 2 |
| 1992 | 2 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 5 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 3 |
| 2003 | 2 |
| 2005 | 2 |
| 2006 | 1 |
| 2007 | 1 |
| 2008 | 4 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2023 | 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 ('1151516'))
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 ('1151516'))
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 NYC66D0416Accident · No injuriesClosedBeechcraft G35 · Mendon, MANTSB FTW66A0060Accident · 3 fatalClosedBeech G35 · Redericksburg, TXNTSB LAX66F0207Accident · No injuriesClosedBeechcraft 35 · Oxnard, CANTSB MIA66F0311Accident · No injuriesClosedBeechcraft G-35 · Orlando, FLNTSB NYC66D0357Accident · No injuriesClosedBeechcraft G35 · Olean, NYNTSB OAK66D0144Accident · No injuriesClosedBeech G35 · Santa Rosa, CANTSB NYC66A0061Accident · 1 fatalClosedBeechcraft G-35 · Binghamton, NYNTSB LAX66F0091Accident · No injuriesClosedBeechcraft G-35 · National City, CANTSB FTW66D0225Accident · No injuriesClosedBeechcraft G35 · Amarillo, TXNTSB FTW66A0009Accident · 3 fatalClosedBeechcraft G35 · Morrow, ARNTSB MIA66F0100Accident · No injuriesClosedBeechcraft G-35 · Sarasota, FLNTSB DEN66F0052Accident · No injuriesClosedBeechcraft G35 · Salt Lake City, UTNTSB NYC66F0066Accident · No injuriesClosedBeechcraft G35 · Church Hill, MDNTSB DEN66D0082Accident · No injuriesClosedBeechcraft G-35 · Phoenix, AZNTSB OAK65F0027Accident · No injuriesClosedBeechcraft G-35 · Snelling, CANTSB UNK65X1391Accident · Minor injuriesClosedBeechraft G35 · Grants, NMNTSB DEN65A0049Accident · 2 fatalClosedBeech 35 · Cameron, AZ