NTSB investigations: Beech A36TC, TX
6 cases on aircraft the registry lists as Beech A36TC. 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
| 1983 | 1 |
|---|---|
| 1997 | 1 |
| 2001 | 1 |
| 2010 | 2 |
| 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 ('1151603', '1151613'))
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 ('1151603', '1151613'))
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 CEN22LA039Accident · Minor injuriesClass 3 · LimitedFinal reportBeech A36TC · Rockport, TXThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB CEN10LA559Accident · No injuriesLimited investigationFinal reportBeech A36TC · Snook, TXThe pilot's failure to recognize the change in wind velocity and his decision to make a downwind takeoff from the grass airstrip, which led to the airplane's degraded climb capability.NTSB CEN10LA235Accident · Minor injuriesLimited investigationFinal reportBeech A36TC · El Paso, TXA loss of engine power for undetermined reasons.NTSB FTW01LA185Accident · Minor injuriesLimited investigationFinal reportBeech A-36TC · Fort Worth, TXthe partial loss of engine power for an undetermined reason and the pilot's decision to initiate the takeoff downwind.NTSB FTW98LA025Accident · No injuriesLimited investigationFinal reportBeech A36TC · Stratford, TXThe pilot's failure to maintain the proper glidepath with the airplane resulting in the airplane not touching down at the proper touchdown point on the runway. A factor was the unfavorable winds.NTSB FTW83FA108Accident · 1 fatalField investigationFinal reportBeech A36TC · Addison, TXThe non-instrument rated, student plt used another person's name while filing an instrument flt plan. When he contacted ground control for departure, he was advised that the arpt had just become IFR. After some confusion concerning canceling & filing flt…