NTSB investigations: Beech P35, FL
8 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
| 1967 | 1 |
|---|---|
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1981 | 1 |
| 1996 | 1 |
| 2001 | 1 |
| 2023 | 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\" = 'FL' 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" = 'FL' 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 ERA23LA173Accident · No injuriesClass 3 · LimitedFinal reportBeech P35 · Perry, FLMaintenance personnel’s incorrect torquing of the oil filter adapter jam nut, resulting in the failure of the adapter threads, a complete loss of oil, and subsequent total loss of engine power.NTSB MIA02LA018Accident · Serious injuriesLimited investigationFinal reportBeech P35 · Belle Glade, FLThe loss of engine oil for undetermined reasons that resulted in the engine seizing, a forced landing on a dirt road, and an impact with a vehicle on the dirt road during the landing rollout.NTSB MIA96FA165Accident · 1 fatalField investigationFinal reportBeech P35 · St. Petersburg, FLthe pilot's improper procedure by not placing the fuel selector on the tank with the most fuel.NTSB MIA81DLA23Accident · No injuriesClosedBeech P35 · Deland, FLNTSB MIA72AM136Accident · 1 fatalClosedBeech P35 · Jacksonville, FLNTSB MIA71AM090Accident · 1 fatalClosedBeech P35 · Marathon, FLNTSB MIA70DLD39Accident · No injuriesClosedBeech P-35 · Okeechobee, FLNTSB MIA68D0050Accident · No injuriesClosedBeech P35 · Miami, FL