NTSB investigations: Lycoming O-360-A1P, TX
5 cases on aircraft whose registry engine model is Lycoming O-360-A1P. 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
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2016 | 3 |
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 ('42259'))
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 ('42259'))
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 CEN17FA028Accident · 1 fatalField investigationFinal reportAviat A-1C-180 · Clarksville, TXThe pilot's failure to maintain sufficient airspeed during the landing approach, which resulted in exceedance of the airplane's critical angle of attack and an aerodynamic stall.NTSB GAA16CA225Accident · No injuriesData collectionFinal reportAviat A-1C-180 · Harlingen, TXThe pilot's failure to maintain directional control during the landing roll in crosswind conditions, which resulted in a ground loop and substantial damage to the right wing.NTSB GAA16CA103Accident · No injuriesData collectionFinal reportAviat A-1C · Breckenridge, TXThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.NTSB CEN12LA125Accident · Serious injuriesLimited investigationFinal reportAviat A-1C-180 · McKinney, TXThe passenger's inadvertent contact with a rotating propeller after exiting the parked airplane. Contributing to the accident were the dark night conditions and the deplaning of the passenger while the propeller was turning.NTSB CEN10CA120Accident · No injuriesData collectionFinal reportAviat A1 · Austin, TXThe pilot's failure to maintain directional control during landing and his failure to properly execute a go-around.