NTSB investigations: Beech F35
5 cases on aircraft the registry lists as Beech F35, 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
| 1988 | 1 |
|---|---|
| 1992 | 1 |
| 1993 | 2 |
| 2003 | 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 ('1151514')
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 ('1151514')
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 SEA03LA078Accident · No injuriesLimited investigationFinal reportBeech F-35 · Anacortes, WAThe pilot's inadvertent selection of the incorrect fuel tank selector position (OFF) while in cruise flight over open water, and his failure to activate the fuel wobble-pump. A contributing factor was the unsuitable terrain.NTSB NYC93FA169Accident · 2 fatalField investigationFinal reportBeech F35 · Medford, NJThe pilot's failure to select a fuel tank that contained fuel, and perform the emergency procedure to restart the engine, which resulted in fuel starvation and the loss of engine power. Factors are the pilot's lack of total experience and his inadequate…NTSB LAX93LA191Accident · No injuriesLimited investigationFinal reportBeech F35 · Sandy Valley, NVThe pilot's failure to perform a preflight inspection of the airplane, and to assure that an adequate supply of fuel was on board the aircraft. This subsequently led to an inadequate fuel supply in the left tank, and fuel starvation. A factor related to the…NTSB NYC93LA050Accident · Serious injuriesLimited investigationFinal reportBeech F-35 · Collegeville, PAThe pilot's failure to follow the before landing check list in the pilot operators handbook in not selecting the fullest fuel tank for landing, which resulted in fuel starvation and subsequent engine failure.NTSB LAX88LA116Accident · No injuriesLimited investigationFinal reportBeech F35 · Pacoima, CAThe plt rprtd that he had initially psnd the fuel selector (sel) to the left main tank. He said that after abt 1 hr of flt (near palmdale, CA), he psnd the sel to the rgt main tank for a short time, then (near Pacoima), he moved it back to the left main tank.…