NTSB investigations: Bellanca 7KCAB, TX

10 cases on aircraft the registry lists as Bellanca 7KCAB. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19772026

NTSB investigations: Bellanca 7KCAB, TX per year, 1977–2026: 10 cases
1977	2
1979	2
1980	2
1981	1
1989	1
2003	1
2024	1

Where

Open the map

Latest cases

Query with SQL

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 ('1220701')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('1220701'))
  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 ('1220701'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN24LA147Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7KCAB · Bluff Dale, TXAn engine compartment fire for reasons that could not be determined due to extensive thermal damage.Apr 4, 2024 · N8946 · Destroyed NTSB FTW03LA206Accident · No injuriesLimited investigationFinal reportBellanca 7KCAB · McKinney, TXThe pilot's failure to maintain airspeed resulting in an inadvertent stall during landing. A contributing factor was flaring too high.Aug 23, 2003 · N8730V · Substantial damage NTSB FTW90LA016Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Friona, TXThe pilot's decision to perform an aerobatic maneuver during initial climb out with inadequate altitude for recovery.Oct 22, 1989 · N7632S · Substantial damage NTSB FTW81FPA15Accident · Minor injuriesClosedBellanca 7KCAB · Bonham, TXAug 16, 1981 · N86702 · Destroyed NTSB FTW81FA008Accident · 2 fatalClosedBellanca 7KCAB · Nursery, TXNov 18, 1980 · N245JB · Destroyed NTSB FTW80FA086Accident · 3 fatalClosedBoeing PT-17 · San Antonio, TXJun 16, 1980 · N1012M · 2 aircraft · Destroyed NTSB FTW80FQG01Accident · Serious injuriesClosedBellanca 7KCAB · Big Spring, TXOct 6, 1979 · N8647 · Substantial damage NTSB FTW79DQG39Accident · No injuriesClosedBellanca 7KCAB · Canadian, TXMay 24, 1979 · N9195L · Substantial damage NTSB FTW77FRA26Accident · Serious injuriesClosedBellanca 7KCAB · Pearland, TXJun 5, 1977 · N7895S · Substantial damage NTSB FTW77FQD19Accident · 1 fatalClosedBellanca 7KCAB · El Paso, TXMay 28, 1977 · N4103Y · Destroyed