NTSB investigations: Lycoming IO-320 series, MI
29 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
| 1967 | 3 |
|---|---|
| 1969 | 4 |
| 1970 | 3 |
| 1971 | 2 |
| 1973 | 2 |
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 2002 | 1 |
| 2009 | 1 |
| 2020 | 1 |
| 2025 | 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\" = 'MI' 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" = 'MI' 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 CEN25LA361Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-30 · Caro, MIThe pilot’s failure to remove the tow bar before flight.NTSB CEN20LA399Accident · 2 fatalClass 3 · LimitedFinal reportVans RV9 · Zeeland, MIThe pilot’s failure to maintain airspeed during a visual approach in dark night conditions, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the pilot’s lack of recent flight experience at night.NTSB CEN09LA512Accident · 1 fatalLimited investigationFinal reportHooper James A Bushby MUS · Gladwin, MIThe pilot's failure to maintain aircraft control for undetermined reasons.NTSB CHI03LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Jackson, MIThe pilot's failure to follow the checklist and extend the landing gear resulting in a gear up landing.NTSB CHI91LA165Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Big Rapids, MIExcessive application of the flight controls by the student pilot. A factor related to the accident is delayed remedial action by the flight instructor.NTSB CHI90FAMS2Accident · 2 fatalMissing aircraftFinal reportPiper PA-30B · Charlevoix, MIThe probable cause of this accident is undetermined.NTSB CHI88DEM08Accident · No injuriesFinal reportChampion 7KCAB · Grand Haven, MIThe pilot's inattentive fuel system monitoring, and the resultant total failure of the aircraft's powerplant due to fuel exhaustion. A forced landing was executed on a stretch of beach with sand dunes, and the aircraft was substantially damaged during the…NTSB CHI87LA175Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Bad Axe, MIDuring a demonstration of an aborted takeoff, the 'power was cut' after the aircraft accelerated to about 75 mph. At about that time, the aircraft encountered a gust of wind and became airborne. A power recovery was initiated, but the aircraft touched down in…NTSB CHI86MA216Incident · No injuriesMajor investigationFinal reportBoeing 737-222 · Lansing, MIPiedmont flt PI255 (a Boeing 737, N749N) was dscndg in visual conds on an IFR clnc when it & a twin commanche (Piper PA-30, N7399Y) converged & passed within a rprtd 50 to 100 ft of each other. The near collision occurred as the PA-30 was cruising westbound…NTSB CHI81FEC21Accident · Minor injuriesClosedPiper PA-30 · Ann Arbor, MINTSB CHI80FEM12Accident · No injuriesClosedPiper PA-30 · Lansing, MINTSB CHI79FEM31Accident · No injuriesClosedPiper PA-30 · Kalamazoo, MINTSB CHI78FEC15Accident · No injuriesClosedPiper PA-30 · Pontiac, MINTSB CHI76FEC45Accident · No injuriesClosedPiper PA-30 · S Lyon, MINTSB CHI74FEM67Accident · No injuriesClosedPiper PA-30 · Freeland, MINTSB CHI74FEC06Accident · No injuriesClosedPiper PA-30 · Dansville, MINTSB CHI74 EM04Accident · No injuriesClosedPiper PA-30 · West Branch, MINTSB CHI72FEM04Accident · No injuriesClosedPiper PA-30 · Freeland, MINTSB CHI71FBJ71Accident · No injuriesClosedPiper PA-30 · Lansing, MINTSB CHI71FBJ18Accident · No injuriesClosedPiper PA-30 · Pellston, MINTSB CHI70AC085Accident · No injuriesClosedCessna 182 · Edenville, MINTSB CHI70FBJ28Accident · No injuriesClosedPiper PA-30 · Charlotte, MINTSB CHI70F0391Accident · No injuriesClosedPiper PA-30 · Grand Rapids, MINTSB CHI70F0359Accident · No injuriesClosedPiper PA-30 · Harrison, MINTSB CHI70F0051Accident · No injuriesClosedMong Sport · Schoolcraft, MINTSB CHI69F0551Accident · No injuriesClosedPiper PA-30 · Birmingham, MINTSB CHI68F0461Accident · No injuriesClosedPiper PA-30 · Traverse Cty, MINTSB CHI68F0329Accident · No injuriesClosedPiper PA-30 · Freeland, MINTSB CHI67F0556Accident · No injuriesClosedPiper PA-30 · Birmingham, MI