NTSB investigations: Beech 35

8 cases on aircraft the registry lists as Beech 35, where the first occurrence was “Loss of engine power”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

NTSB investigations: Beech 35 per year, 1982–2026: 8 cases
1982	1
1983	1
1989	2
1991	1
1999	1
2000	1
2001	1

Where

Open the map

Latest cases

Query with SQL

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 ('1151502') 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" = 350)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('1151502')
      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\" = 350))
  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 ('1151502')
    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" = 350))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 FTW01LA140Accident · Serious injuriesLimited investigationFinal reportBeech BE-35 · Springdale, ARthe loss of engine power due to an undetermined reason.Jun 9, 2001 · N2963V · Substantial damage NTSB LAX00LA108Accident · No injuriesLimited investigationFinal reportBeech 35 · Desert Center, CAThe pilot's inadequate fuel management, his inaccurate fuel consumption calculations, and his improper use of the fuel selector.Feb 24, 2000 · N5127C · Substantial damage NTSB CHI00LA048Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Hanover, MIfuel starvation and the pilot's improper fuel tank selector position. A factor was the swampy terrain.Dec 17, 1999 · N5BB · Substantial damage NTSB ATL91FA039Accident · 1 fatalField investigationFinal reportBeech 35 · Arden, NCFor undetermined reasons, the engine lost power.Jan 18, 1991 · N4589V · Destroyed NTSB MKC90LA002Accident · No injuriesLimited investigationFinal reportBeech 35 · Mountain View, MOLoss of engine power for undetermined reasons. Premature retraction of the landing gear by the pilot was a contributing factor.Oct 1, 1989 · N3106V · Substantial damage NTSB MIA89LA140Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Daytona Beach, FLA loss of engine power for undetermined reasons.Apr 29, 1989 · N447B · Substantial damage NTSB MIA83LA163Accident · No injuriesLimited investigationFinal reportBeech BE-35 · Miami Beach, FLThe pilot stated that while cruising with another aircraft at an unknown altitude the oil pressure began to decrease. Shortly after this, the engine failed. The oil temp, cylinder temp, and exhaust gas temp remained in the normal range the engine stopped…Jun 18, 1983 · N3364V · Destroyed NTSB FTW82DA252Accident · No injuriesFinal reportBeech 35 · Graham, TXWhile descending through about 2800 ft AGL to land, the engine lost power. The pilot was unable to restart the engine and elected to land in an OAT field with oats about 2 to 3 ft high. The pilot reported that during the landing roll, the nose gear collapsed…Jun 28, 1982 · N2880V · Substantial damage