NTSB investigations: Lycoming I0360 SER A&C, NM
8 cases on aircraft whose registry engine model is Lycoming I0360 SER A&C. 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
| 1978 | 1 |
|---|---|
| 1990 | 2 |
| 1998 | 1 |
| 2002 | 1 |
| 2005 | 1 |
| 2007 | 1 |
| 2010 | 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\" = 'NM' 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 ('41511'))
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" = 'NM' 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 ('41511'))
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 CEN11TA064Accident · Minor injuriesFinal reportPartenavia P.68 · Anthony, NMThe pilot's decision to conduct a low-level flight in mountainous terrain in an area where downdrafts were prevalent, resulting in the inadvertent loss of control and the collision with the terrain.NTSB DEN07CA088Accident · No injuriesData collectionFinal reportAcro Sport Acroduster II SA750 · Albuquerque, NMThe pilot's failure to maintain directional control during the landing roll.NTSB LAX05CA137Accident · No injuriesData collectionFinal reportCessna 172S · Gallup, NMthe pilot's premature liftoff and inadequate remedial action, which resulted in the airplane inadvertently recontacting the runway.NTSB FTW02FA162Accident · 1 fatalField investigationFinal reportCirrus Design SR-20 · Angel Fire, NMThe pilot's decision to continue the flight into the rising mountainous terrain, and subsequent failure to maintain clearance with the trees. Contributing factors were the rising mountainous terrain, and the high density altitude,NTSB FTW98LA281Accident · Minor injuriesLimited investigationFinal reportRockwell Commander 112 · Las Vegas, NMThe pilot's improper preflight planning/preparation for a cross country flight resulting in fuel exhaustion and subsequent loss of engine power. Factors were, unsuitable terrain, lack of total aviation experience, and lack of total experience in make/model of…NTSB DEN90LA138Accident · No injuriesLimited investigationFinal reportBuchanan S1-S · Albuquerque, NMThe failure of the pilot in command to adequately compensate for the wind conditions and to maintain directional control during landing roll. A contributing factor was the failure of the tailwheel locking assembly.NTSB DEN90DQA01Accident · 1 fatalFinal reportMichael C. Quigley Velocity · Santa Teresa, NMFailure of the pilot in command to maintain airspeed on final approach resulting in an inadvertent stall and uncontrolled descent into the ground.NTSB DEN78FQA46Accident · Serious injuriesClosedPiper PA-32 · Canjilon, NM