Final NTSB investigations: Convair BT-13A
10 cases on aircraft the registry lists as Convair BT-13A. 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 | 1 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1973 | 2 |
| 1980 | 1 |
| 1989 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2005 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2420204'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2420204'))
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 IAD05LA114Accident · 2 fatalLimited investigationFinal reportConvair BT-13A · Lyme, NHThe pilot's improper fuel management which resulted in an incorrect fuel selector position, fuel starvation, and subsequent loss of engine power. A factor in the accident was the pilot's failure to maintain adequate airspeed and inadvertent stall.NTSB FTW01FA117Accident · 2 fatalField investigationFinal reportConvair BT-13A · Odessa, TXthe pilot's failure to maintain the minimum required airspeed for flight, which resulted in a loss of control while performing a go-around. A contributing factor to the accident was the gusty tailwind condition.NTSB LAX00FA159Accident · Serious injuriesField investigationFinal reportConvair BT-13A · Pearl Harbor, HIthe pilot's failure to anticipate turbulence from the formation lead airplane. Contributing to the accident was the pilot's failure to maintain control of the airplane.NTSB ATL90FA007Accident · 2 fatalField investigationFinal reportVultee BT-13 · Axis, ALThe aircraft inadvertently entered a stall, when the pilot/passenger had a heart attack. A factor related to the accident was: lack of altitude for the pilot-in-command to recover from the stall.NTSB FTW80DPA17Accident · No injuriesClosedCnsd Vultee BT-13 · Waco, TXNTSB OAK74FVA20Accident · 1 fatalClosedVultee BT-13A · Madera, CANTSB FTW74FRA11Accident · Serious injuriesClosedConvair BT-13A · Galveston, TXNTSB LAX68F0217Accident · No injuriesClosedVultee BT-13 · Lancaster, CANTSB DEN66D0268Accident · No injuriesClosedConvair BT-13 · Tucson, AZNTSB UNK64X3362Accident · No injuriesClosedConvair BT13 · Casa Grande, AZ