NTSB investigations: Lycoming IGSO-540-B1A, MO

5 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

19672026

NTSB investigations: Lycoming IGSO-540-B1A, MO per year, 1967–2026: 5 cases
1967	1
1969	1
1975	1
1987	1
1989	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" = 'MO' 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\" = 'MO' 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" = 'MO' 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 MKC90LA039Accident · No injuriesLimited investigationFinal reportBeech 80 · Cape Girardeau, MOAn inoperative landing gear extension system due to failure of an electric motor and a misplaced emergency crank handle.Dec 13, 1989 · N525GT · Substantial damage NTSB MKC88FA028Accident · No injuriesField investigationFinal reportAero Commander 680FL · Kansas City, MOAt 2108:57 ea flt 275(EA275) a Boeing 727, was cleared to takeoff on runway 19 and at 2110:24 N6509V, an Aero Commander,was cleared to taxi into position and hold. N6509V entered runway 19 near mid-field at taxiway A-3 without advising the tower of his intent…Dec 16, 1987 · N6509V · 2 aircraft · Substantial damage NTSB MKC76FCG17Accident · No injuriesClosedAero Comdr 680FL · Kansas City, MOAug 12, 1975 · N9011N · Substantial damage NTSB MKC69D0355Accident · No injuriesClosedAero Comdr 680-FL · Kansas City, MOJan 27, 1969 · N290MP · Substantial damage NTSB MKC67D0567Accident · No injuriesClosedAero Comdr 680F · Albany, MOMay 21, 1967 · N290MP · Substantial damage