NTSB investigations: Mcculloch 4318A&E/0-100, 1980

7 cases on aircraft whose registry engine model is Mcculloch 4318A&E/0-100. 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

19642026

NTSB investigations: Mcculloch 4318A&E/0-100, 1980 per year, 1964–2026: 91 cases
1964	2
1965	2
1966	4
1967	6
1968	9
1969	2
1970	6
1971	5
1972	6
1973	1
1974	5
1975	4
1976	4
1978	4
1979	2
1980	7
1981	3
1982	4
1983	2
1984	3
1985	1
1988	1
1989	1
1990	1
1992	1
1993	1
1994	1
1995	1
1998	1
2006	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 year(c."eventDate") = 1980 AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('43101')) 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\") = 1980
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('43101'))
  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") = 1980
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('43101'))
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 FTW81FPG07Accident · 1 fatalClosedBensen B8M · Sherrill, ARNov 29, 1980 · N3790K · Destroyed NTSB FTW81FPM01Accident · 1 fatalClosedBenson B8M · Tulsa, OKOct 9, 1980 · N475 · Destroyed NTSB CHI80FEV40Accident · Serious injuriesClosedBensen B8M · St. Joseph, ILSep 28, 1980 · N30087 · Substantial damage NTSB NYC80FGT21Accident · 1 fatalClosedBensen B-8M · Columbia, PASep 8, 1980 · N3776N · Destroyed NTSB MKC80FCA22Accident · 1 fatalClosedBensen B8M · Montgomery Cy, MOJul 19, 1980 · N9981 · Substantial damage NTSB CHI80DEP27Accident · Minor injuriesClosedBensen B-8M · Manitowoc, WIApr 27, 1980 · N2264A · Substantial damage NTSB MIA80FKJ27Accident · 1 fatalClosedBensen BTS8-M · Selma, ALMar 23, 1980 · N554A · Destroyed