Skip to content

NTSB investigations: Lycoming R680, CA

26 cases on aircraft whose registry engine model is Lycoming R680. 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

Where

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 ('41540')) 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 ('41540'))
  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 ('41540'))
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 WPR25LA258Accident · No injuriesClass 4 · LimitedFinal reportBoeing B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during the landing roll with a quartering tailwind.Aug 19, 2025 · N14GC · Substantial damage NTSB WPR20CA073Accident · Minor injuriesData collectionFinal reportStearman B75N1 · Vacaville, CAThe pilot's failure to maintain directional control during landing, which resulted in a runway excursion and nose-over when the right wheel encountered mud.Jan 22, 2020 · N14GC · Substantial damage NTSB GAA17CA077Accident · No injuriesData collectionFinal reportCurtiss Wright Travel AIR 4000 · San Diego, CAThe other pilot’s failure to see and avoid the airplane stopped ahead of him during taxi.Nov 22, 2016 · N3242 · 2 aircraft · Substantial damage NTSB WPR10CA382Accident · No injuriesData collectionFinal reportBoeing PT-13B · Santa Rosa, CAThe failure of the pilot of another airplane to maintain clearance while taxiing.Jul 31, 2010 · N46590 · 2 aircraft · Minor damage NTSB WPR09LA025Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Rialto, CAA total loss of engine power during initial climb due to an interruption in fuel flow through an improperly assembled carburetor.Oct 26, 2008 · N44848 · Substantial damage NTSB LAX88FA180Accident · 3 fatalField investigationFinal reportCurtiss-Wright Travel AIR 2000 · Fairfield, CAPilot's failure to maintain an airspeed at which the aircraft is controllable and entering a stall.May 14, 1988 · N6130 · Destroyed NTSB LAX87LA122Accident · Serious injuriesLimited investigationFinal reportBoeing PT-13D · Vacaville, CAThe aircraft were in the holding area short of runway 19 at the uncontrolled nut tree airport. The Cessna pilot taxied into position behind landing traffic and allowed his aircraft to roll slowly forward while waiting for the landing aircraft to clear the…Feb 22, 1987 · N620BD · 2 aircraft · Substantial damage NTSB LAX82FVG23Accident · 1 fatalFinal reportBoeing A75N1 · Pleasant Grove, CAThe pilot reported that he landed toward the north with the wind from the northeast at 8 to 10 knots. When the tailwheel touched down, the aircraft veered right. The pilot reported that he could not stop the turn. He opened the throttle while attempting to…May 8, 1982 · N68820 · Substantial damage NTSB OAK79DVA39Accident · No injuriesClosedBoeing A75 · Hanford, CAJun 5, 1979 · N69652 · Substantial damage NTSB LAX78FUA16Accident · No injuriesClosedBoeing PT-13 · Irvine, CAMay 19, 1978 · N9722Z · Substantial damage NTSB OAK78FVM11Accident · No injuriesClosedBoeing A75 · Sn Jun Batsta, CAMar 16, 1978 · N63378 · Substantial damage NTSB OAK77DVA45Accident · No injuriesClosedBoeing A75N1 · Modesto, CAJul 30, 1977 · N5053V · Destroyed NTSB OAK77DVA09Accident · No injuriesClosedBoeing A75 · Hanford, CANov 4, 1976 · N67454 · Substantial damage NTSB OAK76DVA38Accident · Minor injuriesClosedGrumman G-164 · Los Banos, CAFeb 16, 1976 · N10295 · Substantial damage NTSB LAX76DVA20Accident · No injuriesClosedBoeing B75 · Kettleman City, CAOct 12, 1975 · N68488 · Substantial damage NTSB OAK76AP001|OAK7LAP001Accident · 2 fatalClosedWeatherly 201B · Tracy, CAJul 10, 1975 · N1253W · 2 aircraft · Destroyed NTSB OAK75FVA72Accident · No injuriesClosedBoeing A75 · Hanford, CAJun 19, 1975 · N67454 · Substantial damage NTSB OAK74FVA03Accident · Serious injuriesClosedBoeing E75N1 · Hickman, CAJul 11, 1973 · N5053V · Substantial damage NTSB OAK73DVG59Accident · No injuriesClosedBoeing A75N1 · Biggs, CAApr 25, 1973 · N68837 · Substantial damage NTSB OAK71DVG40Accident · Minor injuriesClosedBoeing A75N1 · Sacramento, CANov 20, 1970 · N68820 · Substantial damage NTSB OAK70FVF03Accident · Minor injuriesClosedBoeing A75N1 · Arbuckle, CAFeb 5, 1970 · N68837 · Substantial damage NTSB OAK69D0084Accident · Minor injuriesClosedBoeing E75 · Hanford, CAAug 3, 1968 · N69652 · Destroyed NTSB OAK69F0069Accident · 1 fatalClosedBoeing A75L-3 · Knights Lndg, CAJul 19, 1968 · N56226 · Destroyed NTSB OAK68D0365Accident · Minor injuriesClosedBoeing A75 · Colusa, CAMay 2, 1968 · N51281 · Substantial damage NTSB LAX66F0111Accident · No injuriesClosedCurtiss WRT TR-400 · Ripley, CAAug 7, 1965 · N9958 · Substantial damage NTSB UNK64X4119Accident · No injuriesClosedBoeing PT17 · Pacoima, CASep 23, 1964 · N1390N · Substantial damage