NTSB investigations: Beech B35, 1976
9 cases on aircraft the registry lists as Beech B35. 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 | 15 |
|---|---|
| 1965 | 17 |
| 1966 | 18 |
| 1967 | 14 |
| 1968 | 12 |
| 1969 | 6 |
| 1970 | 10 |
| 1971 | 9 |
| 1972 | 7 |
| 1973 | 9 |
| 1974 | 6 |
| 1975 | 3 |
| 1976 | 9 |
| 1977 | 2 |
| 1978 | 2 |
| 1979 | 3 |
| 1980 | 4 |
| 1981 | 3 |
| 1982 | 5 |
| 1983 | 4 |
| 1985 | 2 |
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 5 |
| 1990 | 2 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 1 |
| 1996 | 3 |
| 1998 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2007 | 2 |
| 2008 | 1 |
| 2009 | 2 |
| 2010 | 1 |
| 2015 | 1 |
| 2019 | 2 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2025 | 1 |
| 2026 | 1 |
Where
Latest 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\") = 1976
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151506'))
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") = 1976
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151506'))
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 OAK77FA002Accident · 2 fatalClosedBeech B35 · Lower Lake, CANTSB SEA76DYE55Accident · No injuriesClosedBeech B35 · Olympia, WANTSB MKC76AK075Accident · 3 fatalClosedBeech B35 · Columbus, NENTSB LAX76AL085Accident · 5 fatalClosedBeech B35 · Rubidoux, CANTSB NYC76AM1O2Accident · 2 fatalClosedBeech B35 · Hyannis, MANTSB CHI76FEC44Accident · Serious injuriesClosedBeech B35 · Troy, MINTSB LAX76FUQ31Accident · No injuriesClosedBeech B35 · Sepulveda, CANTSB LAX76FUG37Accident · No injuriesClosedPiper PA-28 · Rice, CANTSB MIA76FKG39Accident · Minor injuriesClosedBeech B35 · Atlanta, GA