NTSB investigations: Lycoming 0-320 series, 2012
9 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Collision during takeoff/land. 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
| 2008 | 7 |
|---|---|
| 2009 | 6 |
| 2010 | 8 |
| 2011 | 9 |
| 2012 | 9 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 4 |
| 2019 | 9 |
| 2020 | 10 |
| 2021 | 6 |
| 2022 | 5 |
| 2023 | 5 |
| 2024 | 4 |
| 2025 | 4 |
| 2026 | 6 |
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 year(c.\"eventDate\") = 2012
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '490'))
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 year(c."eventDate") = 2012
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '490'))
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 ERA12CA585Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Maryville, TNThe pilot’s failure to plan and execute a takeoff that assured obstacle clearance at the departure end of the runway, which resulted in a collision with trees.NTSB CEN12LA629Accident · No injuriesLimited investigationFinal reportVarga 2150A · Clinton, IAThe pilot of the other airplane failing to adequately monitor for other aircraft while landing.NTSB CEN12LA569Accident · No injuriesLimited investigationFinal reportPiper PA28 · Leesburg, OHThe pilot's improper preflight planning and decision to attempt a takeoff from a runway that was too short for conditions, which resulted in the airplane settling into terrain.NTSB CEN12LA488Accident · 1 fatalLimited investigationFinal reportJoseph C. Andrews, Jr. Vans · Valentine, NEThe RV-6 pilot's failure to monitor the location of the RV-4, resulting in the on-ground collision. Contributing to the accident was the RV-6 pilot not ensuring proper separation from the RV-4 and his expectation that the pilot of RV-4 would roll out to the…NTSB ANC12CA076Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Whittier, AKThe pilot's failure to maintain clearance from brush during landing, which resulted in a loss of control.NTSB ANC12CA065Accident · No injuriesData collectionFinal reportPiper PA-22-160 · McGrath, AKThe pilot’s decision to load the airplane in excess of its takeoff capability given the runway conditions, which resulting in a collision with terrain during the initial climb.NTSB CEN12CA270Accident · No injuriesData collectionFinal reportCessna 172M · Three Rivers, MICollision with a deer during the takeoff roll.NTSB WPR12CA117Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Randle, WAThe pilot exceeded the helicopter's performance, resulting in low rotor rpm and settling.NTSB CEN12TA122Accident · No injuriesFinal reportCessna 172P · Conroe, TXFailure of the rear crankshaft gear dowel pin due to improper installation, which resulted in a total loss of engine power.