NTSB investigations: Lycoming IO-320 series, AL
27 cases on aircraft whose registry engine model is Lycoming IO-320 series. 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 |
|---|---|
| 1966 | 1 |
| 1969 | 2 |
| 1970 | 4 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 3 |
| 1978 | 1 |
| 1980 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2011 | 1 |
| 2020 | 2 |
| 2025 | 1 |
| 2026 | 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\" = 'AL' 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 ('41509'))
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" = 'AL' 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 ('41509'))
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 ERA26LA190Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Enterprise, ALThe pilot’s inadequate preflight and inflight fuel planning, which resulted in a total loss of engine power due to fuel starvation and subsequent forced landing into trees.NTSB ERA25LA315Accident · Serious injuriesClass 4 · LimitedFinal reportPatriot CX1900A · Centreville, ALThe pilot’s failure to detect and remove water contamination from the airplane’s fuel system before the flight, which resulted in a total loss of engine power during initial climb.NTSB ERA20LA272Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Alabaster, ALA loss of control and lack of climb performance shortly after takeoff for reasons that could not be determined based on available evidence, resulting in a collision with terrain.NTSB ERA20LA194Accident · No injuriesClass 3 · LimitedFinal reportBellanca 8KCAB · Rainbow City, ALThe partial loss of engine power for reasons that could not be determined based on available evidence.NTSB ERA11FA348Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Guntersville, ALThe pilot's excessive pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to comply with weight and balance limitations.NTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.NTSB ATL05CA125Accident · No injuriesData collectionFinal reportCessna 172P · Monroeville, ALThe student pilot's failure to maintain directional control and the subsequent collision with the ground during landing.NTSB MIA80FKJ28Accident · No injuriesClosedPiper PA-30 · Birmingham, ALNTSB MIA78DKJ91Accident · Minor injuriesClosedBellanca 7KCAB · Jasper, ALNTSB MIA77DKJ72Accident · No injuriesClosedPiper PA-30 · Montgomery, ALNTSB MIA77FKJ26Accident · No injuriesClosedPiper PA-30 · Tuscaloosa, ALNTSB MIA77DKJ16Accident · No injuriesClosedBellanca 7KCAB · Enterprise, ALNTSB MIA76DKJ63Accident · No injuriesClosedPiper PA-30 · Monroeville, ALNTSB MIA76DKJ43Accident · No injuriesClosedBellanca 7KCAB · Davenport, ALNTSB MIA74DKJ44Accident · No injuriesClosedPiper PA-30 · Decatur, ALNTSB MIA74DKJ10Accident · No injuriesClosedPiper PA-28 · Wetumpka, ALNTSB MIA73DKJ62Accident · No injuriesClosedPiper PA-30 · Fairhope, ALNTSB MIA73FKJ20Accident · No injuriesClosedPiper PA-30 · Tallassee, ALNTSB MIA71FKJ37Accident · No injuriesClosedPiper PA-30 · Birmingham, ALNTSB MIA71DKJ31Accident · No injuriesClosedPiper PA-30 · Monroeville, ALNTSB MIA70DKJ51Accident · No injuriesClosedPiper PA-30 · Pine Hill, ALNTSB MIA70DKJ25Accident · No injuriesClosedPiper PA-30 · Montgomery, ALNTSB MIA70FKJ05Accident · No injuriesClosedChampion 7KCAB · Kimberly, ALNTSB MIA70D0236Accident · No injuriesClosedPiper PA-30 · Enterprise, ALNTSB MIA70D0169Accident · No injuriesClosedPiper PA-30 · Alexander Cty, ALNTSB MIA67A0011Accident · 2 fatalClosedPiper PA-30 · Gordo, ALNTSB MIA66F0225Accident · No injuriesClosedPiper PA-30 · Birmingham, AL