NTSB investigations: Lycoming 0-360-A1D, TX
15 cases on aircraft whose registry engine model is Lycoming 0-360-A1D. 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
| 1973 | 1 |
|---|---|
| 1980 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 1999 | 1 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2011 | 1 |
| 2024 | 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 ('41504'))
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 ('41504'))
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 CEN24LA141Accident · No injuriesClass 3 · LimitedFinal reportCozy Mark IV · Gonzales, TXMaintenance personnel’s failure to properly torque the crankshaft idler gear hardware according to the engine manufacturer’s service instructions, which resulted in separation of the crankshaft idler gear’s fasteners and disengagement of the camshaft,…NTSB CEN12LA087Accident · No injuriesLimited investigationFinal reportAviat A-1B · Gainesville, TXThe right main gear tire contacting the brake caliper, which resulted in an uncommanded brake effect on the wheel.NTSB DFW07LA124Accident · 1 fatalLimited investigationFinal reportAdams RV-6A · Boerne, TXThe pilot's failure to maintain the best angle of climb speed resulting in an inadvertent stall. A contributing factor was the high density altitude.NTSB DFW05CA127Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Rock Springs, TXThe pilot's failure to maintain clearance with a static line. A contributing factor was the low altitude.NTSB DFW05LA022Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Eagle Pass, TXThe pilot's failure to maintain control of the helicopter. A contributing factor was the unsuitable terrain for landing.NTSB FTW03LA172Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Houston, TXThe pilot's failure to maintain rotor RPM and the improper landing flare resulting in a hard landing. A contributing factor was the prevailing high winds.NTSB FTW02FA071Accident · 1 fatalField investigationFinal reportBeech C23 · Sinton, TXThe pilot's failure to maintain clearance with trees while executing a missed approach procedure. Contributing factors were the prevailing fog and the dark night conditions.NTSB FTW02LA050Accident · Serious injuriesLimited investigationFinal reportHeard RV-6A · Comfort, TXthe pilot's inadequate recovery from a bounced landing, which resulted in a hard landing and collapse of the nose landing gear.NTSB FTW01LA164Accident · Minor injuriesLimited investigationFinal reportYoung RV-6 · Spring, TXthe loss of engine power for undetermined reasons during the landing approach. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW01LA159Accident · No injuriesLimited investigationFinal reportGlover RV-8 · Mineral Wells, TXthe jammed elevator control stick on takeoff roll. A contributory factor was the crosswind.NTSB FTW99LA083Accident · No injuriesLimited investigationFinal reportRobinson R22-B2 · Freer, TXThe passenger's inadvertent interference with the cyclic control which consequently restricted the control's movement.NTSB FTW90LA084Accident · No injuriesLimited investigationFinal reportCessna 172G · Rio Hondo, TXOil starvation induced power loss due to improper maintenance procedures. Contributing to the accident were inadequate maintenance inspection and the soft terrain in which the forced landing was performed.NTSB FTW85LA278Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Austin, TXThe eng failed at about 2000 ft MSL while the acft was climbing to cruise flt. The plt attempted to turn back to the arpt but realized it was too FAR away. The plt then made a forced landing in a grass area adjacent to a large hwy at about a 45 deg angle to…NTSB FTW80DQG12Accident · No injuriesClosedPitts S-1S · Midland, TXNTSB FTW73FQG29Accident · Minor injuriesClosedPiper PA-28R · Odessa, TX