NTSB investigations: Beech 23, TX
20 cases on aircraft the registry lists as Beech 23. 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 | 7 |
|---|---|
| 1965 | 1 |
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 2 |
| 1977 | 1 |
| 1996 | 1 |
| 2006 | 1 |
| 2021 | 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 ('1151202'))
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 ('1151202'))
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 CEN22LA040Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 23 · Abilene, TXThe flight instructor’s inadequate fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident was the missing placard showing the usable fuel quantity.NTSB DFW06CA192Accident · No injuriesData collectionFinal reportBeech BE23 · Bowie, TXThe student pilot's failure to maintain clearance from trees. Contributing factors were the prevailing crosswind and improper supervision of the flight by the flight instructor.NTSB FTW96FA339Accident · 1 fatalField investigationFinal reportBeech 23 · Wimberley, TXThe pilot's failure to maintain airspeed. Factors were the high density altitude, the tail wind, and the pilot's failure to adhere to the limitations prescribed by his flight instructor.NTSB FTW77FRJ08Accident · No injuriesClosedBeech 23 · Edom, TXNTSB FTW73FPA06Accident · No injuriesClosedBeech B23 · Waxahachie, TXNTSB FTW72DPD33Accident · Minor injuriesClosedBeech 23 · Evant, TXNTSB FTW71FRA04Accident · No injuriesClosedBeech 23 · Eagle Lake, TXNTSB FTW70D0191Accident · No injuriesClosedBeech A23 · Dimmitt, TXNTSB FTW68D0467Accident · No injuriesClosedBeech A23 · Plainview, TXNTSB FTW68D0128Accident · Minor injuriesClosedBeech 23 · Canton, TXNTSB FTW68D0163Accident · No injuriesClosedBeech 23 · Laredo, TXNTSB FTW67F0142Accident · No injuriesClosedBeech 23 · Kingdom Lake, TXNTSB FTW66D0017Accident · No injuriesClosedBeechcraft 23 · Rankin, TXNTSB UNK65X0941Accident · No injuriesClosedBeechcraft 23 · Muleshoe, TXNTSB UNK65X0620Accident · No injuriesClosedBeechcraft PA-23 · Dallas, TXNTSB UNK64X2949Accident · No injuriesClosedBeechcraft 23 · Pearland, TXNTSB UNK64X2637Accident · No injuriesClosedBeechcraft M23 · Abilene, TXNTSB UNK64X2481Accident · No injuriesClosedBeechcraft 23 · Seminole, TXNTSB UNK64X2282Accident · No injuriesClosedBeechcraft 23 · Dallas, TXNTSB UNK64X1979Accident · No injuriesClosedBeechcraft 23 · El Paso, TX