NTSB investigations: Lycoming IGSO-540-B1A, CA

10 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

19652026

NTSB investigations: Lycoming IGSO-540-B1A, CA per year, 1965–2026: 10 cases
1965	1
1968	1
1970	1
1977	1
1978	1
1979	1
1980	2
2010	1
2019	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" = 'CA' AND c."eventCountry" = 'USA' 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 c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    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 c."eventStateOrRegion" = 'CA' AND c."eventCountry" = 'USA'
  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 WPR19FA175Accident · 1 fatalClass 3 · FieldFinal reportRobinson R44 · Two Harbors, CAThe pilot's continued visual flight into instrument meteorological conditions, which resulted in controlled flight into terrain.Jun 18, 2019 · N7187D · Destroyed NTSB WPR11FA078Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Perris, CAThe pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in an in-flight collision with mountainous terrain.Dec 20, 2010 · N316KW · Substantial damage NTSB LAX81FA031Accident · No injuriesClosedBeech 65-88 · Goleta, CADec 10, 1980 · N884S · Substantial damage NTSB LAX80FVD32Accident · No injuriesClosedAero Comdr 680FLP · Emeryville, CAAug 2, 1980 · N27VF · Substantial damage NTSB OAK79IA023Incident · No injuriesClosedBeech 65-A80 · San Francisco, CAApr 17, 1979 · N978Q · Minor damage NTSB OAK78DA053Accident · No injuriesClosedBeech 65A-80 · Columbia, CASep 15, 1978 · N978Q · Substantial damage NTSB OAK78FVD06Accident · No injuriesClosedBeech 65-80 · Concord, CAOct 26, 1977 · N711DE · Substantial damage NTSB OAK71FVG10Accident · No injuriesClosedAero Comdr 680-FL · Fort Jones, CAAug 15, 1970 · N256X · Substantial damage NTSB OAK69D0203Accident · No injuriesClosedBeech 65-80 · Fresno, CADec 19, 1968 · N6800Q · Substantial damage NTSB LAX66F0096Accident · No injuriesClosedAero Cmdr 680-FL · Camarillo, CASep 9, 1965 · N541M · Substantial damage