NTSB investigations: Bellanca 17-30, 1977

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

19672026

NTSB investigations: Bellanca 17-30, 1977 per year, 1967–2026: 162 cases
1967	5
1968	7
1969	11
1970	14
1971	5
1972	10
1973	7
1974	8
1975	7
1976	10
1977	8
1978	7
1979	5
1980	4
1981	3
1982	2
1983	1
1984	4
1985	3
1986	4
1987	2
1988	3
1989	1
1990	1
1991	1
1992	1
1993	2
1995	2
1996	4
1997	3
1998	1
1999	2
2000	2
2001	1
2002	1
2004	2
2006	1
2008	1
2012	2
2016	1
2017	1
2020	2

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 year(c."eventDate") = 1977 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220432', '1250020')) 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 year(c.\"eventDate\") = 1977
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220432', '1250020'))
  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 year(c."eventDate") = 1977
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1220432', '1250020'))
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 LAX78FA005Accident · 2 fatalClosedBellanca 17-30 · Fullerton, CANov 13, 1977 · N6572V · Destroyed NTSB NYC77FHM25Accident · No injuriesClosedBellanca 17-30 · Newburg, NYSep 2, 1977 · N6574V · Substantial damage NTSB LAX77FA068Accident · 2 fatalClosedBellanca 17-30 · San Dimas, CAAug 30, 1977 · N4889V · Destroyed NTSB MIA77DKJ75Accident · Minor injuriesClosedBellanca 1730 · Dauphin Is, ALAug 17, 1977 · N7324V · Substantial damage NTSB IAD77FID12Accident · No injuriesClosedBellanca 17-30 · Newport News, VAFeb 8, 1977 · N7316V · Substantial damage NTSB DEN77FQA16Accident · Serious injuriesClosedBellanca 17-30 · Albuquerque, NMFeb 6, 1977 · N7325V · Substantial damage NTSB IAD77FIJ04Accident · Serious injuriesClosedBellanca 17-30 · Point Pleasant, WVJan 29, 1977 · N4862V · Substantial damage NTSB DEN77FA021Accident · 1 fatalClosedBellanca 17-30 · Acomita, NMJan 21, 1977 · N7352V · Destroyed