NTSB investigations: Lycoming R680, TX
18 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.
Cases per year
| 1964 | 3 |
|---|---|
| 1965 | 3 |
| 1967 | 1 |
| 1969 | 2 |
| 1970 | 4 |
| 1972 | 1 |
| 1974 | 1 |
| 1995 | 1 |
| 2012 | 1 |
| 2021 | 1 |
Where
Open the mapLatest 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.\"eventStateOrRegion\" = 'TX' 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" = 'TX' 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" 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 CEN22LA088Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Rainbow, TXThe pilot’s improper decision to conduct an intentional low altitude flight which resulted in a collision with wires and impact with terrain.NTSB CEN13LA068Accident · Minor injuriesLimited investigationFinal reportBoeing A75L3 · San Antonio, TXA partial loss of engine power during takeoff, likely due to the accumulation of carburetor ice.NTSB FTW95LA360Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Evadale, TXA failure that resulted in separation of the #5 cylinder and loss of engine oil. The lack of suitable terrain for a forced landing was a related factor.NTSB FTW74FRA43Accident · No injuriesClosedBoeing A75N1 · El Campo, TXNTSB FTW72FPD41Accident · No injuriesClosedClark 1000C · Saginaw, TXNTSB FTW71FPD27Accident · Serious injuriesClosedStinson SR-9C · Lake Dallas, TXNTSB FTW71DQG39Accident · No injuriesClosedBoeing A75N1 · Bovina, TXNTSB FTW71DQG19Accident · No injuriesClosedBoeing A75N1 · Bovina, TXNTSB FTW70DPD18Accident · No injuriesClosedStearman PT17 · Seymour, TXNTSB FTW70F0161Accident · No injuriesClosedConvair L-13 · Decatur, TXNTSB FTW69F0534Accident · No injuriesClosedBoeing A75N1 · Edna, TXNTSB FTW67F0603Accident · Serious injuriesClosedBoeing E-75 · Nome, TXNTSB FTW66F0320Accident · No injuriesClosedBoeing PT-13 · Girard, TXNTSB FTW65F0001Accident · Serious injuriesClosedBoeing E-75 · Ganado, TXNTSB UNK65X1277Accident · No injuriesClosedBoeing E75 · Bonham, TXNTSB UNK64X3314Accident · No injuriesClosedBoeing B75N1 · Seminole, TXNTSB UNK64X2536Accident · No injuriesClosedBoeing A75 · Ablinene, TXNTSB UNK64X2199Accident · No injuriesClosedBoeing E75 · Brownfield, TX