NTSB investigations: Bellanca 14-19-3, TX
19 cases on aircraft the registry lists as Bellanca 14-19-3. 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 |
| 1966 | 6 |
| 1967 | 1 |
| 1968 | 1 |
| 1971 | 1 |
| 1975 | 1 |
| 1979 | 1 |
| 1983 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 2008 | 1 |
| 2013 | 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 ('3080106', '1250012'))
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 ('3080106', '1250012'))
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 CEN14FA024Accident · 1 fatalField investigationFinal reportBellanca 14-19-3A · Boerne, TXA defective exhaust system that allowed carbon monoxide to enter the cabin and impair the pilot, rendering him unable to control the airplane.NTSB DFW08CA149Accident · No injuriesData collectionFinal reportBellanca 14-13-3A · San Marcos, TXThe failure of the throttle cable clevis swage. Contributing to the accident was the uneven terrain available for landing.NTSB FTW95LA242Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19 · Fort Stockton, TXThe pilot's improper positioning of the fuel selector to a tank with unusable fuel. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA085Accident · Minor injuriesLimited investigationFinal reportBellanca 14-19-3A · Graham, TXThe loss of engine power due to fuel starvation due to the improper position of the fuel tank selector. Factors were the pilot's failure to follow the checklist and the lack of suitable terrain for the forced landing.NTSB FTW83LA111Accident · Serious injuriesLimited investigationFinal reportBellanca 14-19-3A · Plainview, TXThe flt reported that the battery was too low to start the engine. A 72 yr old ex-pilot offered to hand prop the plane, but after trying, he then offered to hold the brakes. With the ex-pilot at the controls & holding the brakes, the plt began to hand prop…NTSB FTW79DQD13Accident · No injuriesClosedBellanca 1419-3 · Pecos, TXNTSB FTW76DPD14Accident · Minor injuriesClosedBellanca 14-19 · Ft Worth, TXNTSB FTW71DRH29Accident · No injuriesClosedBellanca 14-19 · Seguin, TXNTSB FTW69F0199Accident · No injuriesClosedBell 47G-4A · Portland, TXNTSB FTW67A0087Accident · 1 fatalClosedBellanca 14-19 · Mt.Pleasant, TXNTSB FTW67D0337Accident · No injuriesClosedBellanca 260 · Miami, TXNTSB FTW67F0286Accident · No injuriesClosedBellanca 14-19 · Sweetwater, TXNTSB FTW67F0043Accident · No injuriesClosedBellanca 14-19 · Dallas, TXNTSB FTW66F0651Accident · No injuriesClosedDowner 14-19 · Nederland, TXNTSB FTW66D0608Accident · No injuriesClosedBellanca 14-13 · Guthrie, TXNTSB FTW66D0575Accident · No injuriesClosedBellanca 14-19 · Amarillo, TXNTSB FTW66D0425Accident · No injuriesClosedBellanca 14-19 · Beamont, TXNTSB UNK64X3276Accident · No injuriesClosedBellanca 14193 · Sierra Blanca, TXNTSB UNK64X2925Accident · No injuriesClosedBellanca 14193 · Dublin, TX