NTSB investigations: Lycoming IGSO-540-B1A, 1980

9 cases on aircraft whose registry engine model is Lycoming IGSO-540-B1A. 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: Lycoming IGSO-540-B1A, 1980 per year, 1964–2026: 97 cases
1964	2
1965	1
1966	1
1967	5
1968	3
1969	4
1970	2
1971	2
1972	3
1973	2
1974	4
1975	2
1976	2
1977	6
1978	6
1979	5
1980	9
1981	3
1982	1
1983	3
1984	2
1985	2
1987	4
1988	1
1989	3
1991	1
1992	1
1993	1
1994	1
1995	2
1998	3
1999	1
2001	1
2007	1
2008	1
2009	1
2010	1
2016	1
2018	1
2019	1
2020	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 ('41535')) 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 ('41535'))
  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 ('41535'))
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 LAX81FA031Accident · No injuriesClosedBeech 65-88 · Goleta, CADec 10, 1980 · N884S · Substantial damage NTSB ATL81FLG02Accident · Serious injuriesClosedAero Comdr 680FLP · Columbia, SCOct 17, 1980 · N1167Z · Destroyed NTSB MIA80FLD96Accident · No injuriesClosedBeech 65-B80 · Lake Marion, FLSep 7, 1980 · N242Q · Destroyed NTSB MIA80DA094Accident · 1 fatalClosedBeech 65-80 · Pt.Maria (Gulf of Mexico)Aug 25, 1980 · N218K · Destroyed NTSB LAX80FVD32Accident · No injuriesClosedAero Comdr 680FLP · Emeryville, CAAug 2, 1980 · N27VF · Substantial damage NTSB FTW80FA096Accident · 2 fatalClosedAero Comdr 680FLP · Iola, TXJul 25, 1980 · N6515V · Destroyed NTSB MIA80FLD52Accident · Serious injuriesClosedBeech 65-80 · Sebring, FLApr 6, 1980 · N717Q · Destroyed NTSB MIA80FLA17Accident · No injuriesClosedAero Comdr 680F · N Smyrna Beach, FLMar 15, 1980 · N2302P · Substantial damage NTSB MIA80FA032Accident · 2 fatalClosedAero Comdr 680FL · Sebring, FLFeb 14, 1980 · N662B · Destroyed