NTSB investigations: Beech A35
5 cases on aircraft the registry lists as Beech A35, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 1 |
|---|---|
| 1988 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2002 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151504')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1151504')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
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 LAX02LA117Accident · Serious injuriesLimited investigationFinal reportBeech A35 · Rio Linda, CAthe loss of engine power as a result of fuel starvation due to the pilot's inadequate fuel system management and failure to follow procedures and directives in the Pilot Operating Handbook listed by the manufacturer.NTSB NYC99LA109Accident · Minor injuriesLimited investigationFinal reportBeech A35 · Phillipsburg, OHFuel starvation to the engine due to the pilot's failure to switch fuel tanks.NTSB CHI95FA161Accident · Serious injuriesField investigationFinal reportBeech A35 · Downers Grove, ILfuel contamination (water), and the pilot's inadequate aircraft preflight. A factor was trees.NTSB LAX88FA252Accident · 1 fatalField investigationFinal reportBeech A35 · Lompoc, CAPilot's improper use of the fuel system and his failure to maintain control of his aircraft. Contributing factors were the pilot's intentional operation of an aircraft with known deficiencies in equipment, his improper emergency procedure and his lack of…NTSB LAX83FA205Accident · Serious injuriesField investigationFinal reportBeech A36 · Hawthorne, CAAs the acft was climbing thru about 400 to 500 ft AGL, after takeoff, the eng began losing power. The plt turned on the fuel boost pump & started a turn back toward the arpt. When he realized that he could not reach the rwy, he elected to land on a street.…