NTSB investigations: Lycoming I0360 SER A&C, UT
10 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
| 1989 | 1 |
|---|---|
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2016 | 1 |
| 2022 | 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\" = 'UT' 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" = 'UT' 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 WPR22LA358Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28RT-201 · South Jordan, UTThe pilot’s inability to see and avoid a bird while landing in dark night conditions.NTSB GAA16CA523Accident · No injuriesData collectionFinal reportCessna 172 · Tooele, UTThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB WPR10CA229Accident · No injuriesData collectionFinal reportAviat A-1B · Moab, UTThe pilot's inadequate crosswind compensation resulting in a loss of directional control and impact with bushes.NTSB SEA07LA087Accident · Serious injuriesLimited investigationFinal reportBurdette RV-3 · Bountiful, UTThe pilot's failure to maintain directional control during the landing roll. Factors include an earthen berm near the point where the aircraft departed the side of the runway.NTSB DEN04LA001Accident · No injuriesLimited investigationFinal reportElliott Mustang II · Cedar City, UTThe pilot's inadequate preflight planning/preparation which led to fuel exhaustion and subsequent loss of engine power.NTSB DEN03LA017Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Tooele, UTthe inadvertent retraction of the landing gear during landing roll by the dual student. Contributing factors included the dual student's lack of familiarity with the aircraft, inadequate supervision by the flight instructor, and improper rigging of the…NTSB DEN01LA123Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Bryce Canyon, UTthe pilot's failure to maintain directional control during landing. A contributing factor was the crosswind.NTSB DEN00LA017Accident · No injuriesLimited investigationFinal reportCessna 172R · Logan, UTThe pilot's improper flare and improper recovery from a bounced landing.NTSB SEA97LA122Accident · No injuriesLimited investigationFinal reportNoe SA-300 · Bountiful, UTthe pilot's failure to maintain directional control of the airplane. Related factors include: an area of standing water on a portion of the runway, and soft terrain just off the edge of the runway.NTSB DEN89LA195Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Bountiful, UTInadequate compensation for wind conditions by the pilot and his failure to maintain directional control during the landing. The pilot's inadequate preflight preparation (lack of a weather briefing) and the weather conditions were contributing factors.