NTSB investigations: Beech P35, TX
13 cases on aircraft the registry lists as Beech P35. 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 | 2 |
|---|---|
| 1965 | 1 |
| 1967 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1974 | 1 |
| 1979 | 1 |
| 1986 | 1 |
| 1996 | 2 |
| 2013 | 1 |
| 2014 | 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\" = 'TX' 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 ('1151530'))
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" = 'TX' 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 ('1151530'))
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 CEN14LA165Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Wichita Falls, TXThe loss of engine power due to the misrigging of the fuel mixture control.NTSB CEN13CA389Accident · Minor injuriesData collectionFinal reportBeech P35 · Bridgeport, TXThe failure of both the flight instructor and the pilot to monitor and manage the fuel on board, which resulted in an engine failure due to fuel starvation.NTSB FTW96LA129Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Brownwood, TXthe pilot's failure to follow manufacturer's procedures and premature gear retraction.NTSB FTW96LA117Accident · Minor injuriesLimited investigationFinal reportBeech P35 · Lubbock, TXthe pilot's delay in aborting the takeoff.NTSB FTW87LA012Accident · Minor injuriesLimited investigationFinal reportBeech P-35 · Clarendon, TXThe plt was attempting a takeoff with a 12 kt quartering tailwind when the accident occurred. Immediately following rotation and gear retraction, the acft settled and impacted the terrain.NTSB FTW79DQG35Accident · No injuriesClosedBeechcraft P35 · Big Spring, TXNTSB FTW74AF057Accident · 1 fatalClosedBeech P35 · Luling, TXNTSB FTW72FRA60Accident · Minor injuriesClosedBeech P35 · Brenham, TXNTSB FTW72FRA06Accident · Minor injuriesClosedBeech P35 · Alief, TXNTSB FTW67F0618Accident · No injuriesClosedBeech P35 · El Paso, TXNTSB FTW66D0489Accident · No injuriesClosedBeechcraft P-35 · Hilltop Lakes, TXNTSB UNK64X3493Accident · No injuriesClosedBeechcraft P35 · Midland, TXNTSB UNK64X3402Accident · 4 fatalClosedBeechcraft P35 · Beeville, TX