NTSB investigations: Beech P35, 1966
8 cases on aircraft the registry lists as Beech P35. 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 | 13 |
| 1966 | 8 |
| 1967 | 9 |
| 1968 | 9 |
| 1969 | 2 |
| 1970 | 9 |
| 1971 | 5 |
| 1972 | 7 |
| 1973 | 2 |
| 1974 | 6 |
| 1975 | 4 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1979 | 4 |
| 1980 | 3 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 3 |
| 1996 | 3 |
| 1997 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 2 |
| 2007 | 1 |
| 2010 | 2 |
| 2012 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2021 | 2 |
| 2023 | 3 |
| 2025 | 2 |
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\") = 1966
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151530'))
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") = 1966
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151530'))
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 MKC67D0412Accident · No injuriesClosedBeech P35 · Glenwood, MNNTSB LAX67F0214Accident · No injuriesClosedBeech P35 · Corona, CANTSB MIA67A0284Accident · No injuriesClosedBeech P35 · Eagle Springs, NCNTSB MKC66F0554Accident · No injuriesClosedBeech P35 · Brookings, SDNTSB FTW66F0576Accident · No injuriesClosedBeechcraft P35 · Lake Charles, LANTSB MIA66F0439Accident · Minor injuriesClosedBeechcraft P35 · Gainsville, GANTSB MKC66D0406Accident · No injuriesClosedBeech P35 · Bentley, KSNTSB CHI66F0556Accident · No injuriesClosedBeechcraft P35 · Joliet, IL