NTSB investigations: Beech A35, IL
12 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 | 1 |
|---|---|
| 1966 | 4 |
| 1967 | 1 |
| 1973 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1995 | 2 |
| 2022 | 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 c.\"eventStateOrRegion\" = 'IL' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'IL' AND c."eventCountry" = 'USA'
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 DCA22FA157Accident · 1 fatalClass 3 · FieldFinal reportBeech A35 · Centralia, ILThe pilot’s unsuccessful attempt to switch fuel tanks, which resulted in fuel starvation. Contributing to the accident was the uninstalled fuel selector handle warning device.NTSB CHI95LA186Accident · No injuriesLimited investigationFinal reportBeech A35 · Jacksonville, ILimproper maintenance and inspection of the airplane's ruddervators.NTSB CHI95FA161Accident · Serious injuriesField investigationFinal reportBeech A35 · Downers Grove, ILfuel contamination (water), and the pilot's inadequate aircraft preflight. A factor was trees.NTSB CHI78FEV19Accident · Minor injuriesClosedBeech A35 · Quincy, ILNTSB CHI77FEV25Accident · No injuriesClosedBeech A35 · Peoria, ILNTSB CHI74FEV18Accident · No injuriesClosedBeech A35 · Macomb, ILNTSB CHI68F0419Accident · No injuriesClosedBeech 35 · New Lenox, ILNTSB CHI67F0226Accident · No injuriesClosedBeech A35 · Midlothian, ILNTSB CHI67D0261Accident · No injuriesClosedBeech A35 · Chicago, ILNTSB CHI67F0360Accident · No injuriesClosedBeech A35 · Wheeling, ILNTSB CHI66D0676Accident · No injuriesClosedBeech A35 · Crystal Lake, ILNTSB UNK64X1775Accident · 4 fatalClosedBeechcraft A35 · Lombard, IL