NTSB investigations: Lycoming R680E3B

7 cases on aircraft whose registry engine model is Lycoming R680E3B. 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 R680E3B per year, 1967–2026: 7 cases
1967	1
1974	1
1976	2
1980	1
2006	1
2024	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42025')) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42025'))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42025'))
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 WPR24LA164Accident · No injuriesClass 4 · LimitedFinal reportBoeing-Stearman PT-17 · Heber City, UTThe pilot’s failure to maintain directional control during the landing roll.May 27, 2024 · N7995 · Substantial damage NTSB ANC06LA058Accident · No injuriesLimited investigationFinal reportBoeing A75-L3 · Lake Wales, FLThe pilot's failure to maintain proper runway alignment during the takeoff roll, which resulted in a collision with trees during a precautionary landing when the airplane touched down to the right of the runway edge. A factor contributing to the accident was…May 21, 2006 · N60562 · Substantial damage NTSB FTW80FRG54Accident · Minor injuriesClosedBoeing B75N1 · Raymondville, TXJul 5, 1980 · N64890 · Substantial damage NTSB LAX76DVA80Accident · No injuriesClosedBoeing IB75A · Shafter, CAJul 27, 1976 · N53406 · Substantial damage NTSB FTW76DRG67Accident · No injuriesClosedBoeing B75N1 · Raymondville, TXJul 12, 1976 · N64890 · Substantial damage NTSB LAX75DVA32Accident · No injuriesClosedBoeing IB75A · Shafter, CAOct 18, 1974 · N53406 · Substantial damage NTSB FTW68D0148Accident · No injuriesClosedBoeing E75 · Osceola, ARAug 5, 1967 · N1544M · Substantial damage