NTSB investigations: Lycoming O-360-A3A
10 cases on aircraft whose registry engine model is Lycoming O-360-A3A. 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
| 1965 | 1 |
|---|---|
| 1968 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2018 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42267'))
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 ('42267'))
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 GAA18CA219Accident · No injuriesData collectionFinal reportStone James R Daytona Cubs Replica · Orlando, FLThe pilot’s failure to maintain lateral control during landing in crosswind conditions.NTSB CEN18LA073Accident · No injuriesLimited investigationFinal reportS.O.C.A.T.A. MS893E · Wadsworth, OHThe pilot’s failure to apply carburetor heat during the approach, which resulted in a loss of engine power due to carburetor icing.NTSB FTW02LA135Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Santa Teresa, NMthe pilot's inadequate compensation for the gusty crosswind conditions resulting in a loss of control of the airplane during the landing. A contributing factor was the gusty crosswind.NTSB MIA01LA005Accident · Serious injuriesLimited investigationFinal reportArthur P. Matthews Acro Sport II · Huntersville, NCthe pilot's misjudgment of the distance/speed and failure to attain the proper touchdown point or affect a timely go-around which resulted in the aircraft overrunning the runway and incurring substantial damage when it ran into a streambed.NTSB SEA98LA014Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Battle Ground, WAThe owner/pilot's failure to properly install the fuel selector valve after removal, subsequently leading to a false indication on the valve selector handle. This led to the pilot unintentionally closing the valve and starving the engine of fuel during the…NTSB CHI77DEP15Accident · No injuriesClosedPiper PA-28 · Pewaukee, WINTSB MKC76DCA34Accident · No injuriesClosedCessna 177 · Fenton, MONTSB MIA69F0133Accident · No injuriesClosedCessna 177 · Crestview, FLNTSB DEN68D0210Accident · No injuriesClosedPiper PA-18 · Buffalo, WYNTSB OAK65D0063Accident · No injuriesClosedPiper PA-28 · Hayward, CA