NTSB investigations: Bellanca 17-31

9 cases on aircraft the registry lists as Bellanca 17-31. 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

19702026

NTSB investigations: Bellanca 17-31 per year, 1970–2026: 9 cases
1970	2
1972	2
1974	1
1975	1
1976	1
1980	1
1982	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220434', '1250030')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220434', '1250030'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220434', '1250030'))
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 MIA82DA154Accident · No injuriesFinal reportBellanca 17-31 · Lake Wales, FLThe aircraft was on a maintenance flight to check a recently installed engine oil temperature gauge. After determining that the gauge was operating satisfactorily, the pilot began a descent toward the airport. While descending through 3000 ft, the pilot…Jul 14, 1982 · N7373V · Destroyed NTSB ATL80FKG29Accident · No injuriesClosedBellanca 17-31 · Hampton, GASep 21, 1980 · N7374V · Substantial damage NTSB SEA76FYE63Accident · Serious injuriesClosedBellanca 17-31 · Bremerton, WASep 21, 1976 · N7387V · Substantial damage NTSB MKC75AK064Accident · 4 fatalClosedBellanca 17-31 · Lutesville, MOJun 23, 1975 · N7360V · Destroyed NTSB OAK74DVG29Accident · No injuriesClosedBellanca 17-31 · Lk.Berryesa, CAFeb 9, 1974 · N7387V · Substantial damage NTSB LAX73OL008Accident · No injuriesClosedBellanca 17-31 · 1, MexicoDec 27, 1972 · N7357V · Substantial damage NTSB MIA73FKJ21Accident · Serious injuriesClosedBellanca 17-31A · Alexander Cty, ALSep 15, 1972 · N8205R · Substantial damage NTSB CHI71FGD31Accident · No injuriesClosedBellanca 17-31 · Richmond Hts, OHDec 21, 1970 · N6595V · Substantial damage NTSB MIA71FKQ16Accident · No injuriesClosedBellanca 17-31 · Brandon, MSOct 12, 1970 · N7351V · Substantial damage