NTSB investigations: Lycoming R680
7 cases on aircraft whose registry engine model is Lycoming R680, where the first occurrence was “Loss of control - on ground/water”. 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2007 | 1 |
Where
Latest cases
Query with SQL
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 ('41540')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 ('41540')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 CHI07CA130Accident · No injuriesData collectionFinal reportBoeing E75N1 · Fostoria, OHThe pilot's inadequate compensation for wind conditions and his subsequent failure to maintain directional control during landing. The crosswind and wind gusts were contributing factors.NTSB SEA01LA140Accident · No injuriesLimited investigationFinal reportBoeing E75N1 · Spokane, WAThe pilot landed with insufficient formation spacing behind the lead aircraft, resulting in an encounter with the lead aircraft's wake turbulence, and subsequently lost directional control during landing roll.NTSB SEA00LA195Accident · No injuriesLimited investigationFinal reportBoeing E75 · Salem, ORThe pilot's failure to maintain aircraft control upon experiencing a loss of normal braking effectiveness. Factors included a partial failure of the brake system, a tailwind, and a parked aircraft.NTSB CHI91LA110Accident · No injuriesLimited investigationFinal reportBoeing A75 · North Platte, NEDirectional control was not maintained by the pilot resulting in a swerve and ground loop. A factor related to the accident was lack of total experience in type of aircraft by the pilot.NTSB MIA89LA191Accident · No injuriesLimited investigationFinal reportGrumman G-44 · Pahokee, FLThe pilot's inadvertent loss of airplane control, while on the water, which resulted in a swerve and subsequent accident.NTSB NYC88LA164Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Marlboro, NJThe pilot was making a landing to the west when he experienced a loss of directional control and groundlooped on the right side of the runway. He said the tailwheel of the acft was already on the ground when the groundloop occurred and he lost control when a…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…