NTSB investigations: Lycoming 0-320 series, MI
21 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of control - in flight”. 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
| 1982 | 1 |
|---|---|
| 1983 | 3 |
| 1984 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 2 |
| 2001 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2007 | 1 |
Where
Latest 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 ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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 ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 CHI08FA033Accident · 1 fatalField investigationFinal reportCessna 172I · Gladwin, MIThe pilot's failure to maintain aircraft control while maneuvering at a low altitude. Contributing to the accident was the pilot's diverted attention while attempting to photograph ground objects.NTSB CHI06LA023Accident · Serious injuriesLimited investigationFinal reportMcClintock Glasair SH-2 · Port Huron, MIThe pilot not maintaining airplane control during landing.NTSB CHI04CA258Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Detroit, MIThe student pilot's failure to maintain directional control of the airplane during the landing flare and subsequent go-around. A factor was the T-hangar.NTSB CHI04FA197Accident · 1 fatalField investigationFinal reportRobinson R22 Alpha · Mount Clemens, MIA loss of control in flight for undetermined reasons.NTSB CHI01LA181Accident · 2 fatalLimited investigationFinal reportMasko Mustang MII · Ann Arbor, MIThe pilot's failure to maintain control of the airplane resulting in the inadvertent stall/spin. A factor was the pilot's unfamiliarity with the airplane.NTSB CHI00LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grant, MIthe pilot's failure to maintain control of the airplane which resulted in a stall/mush condition. Factors associated with the accident were the trees and gusty wind conditions which resulted in turbulence on takeoff.NTSB CHI00LA172Accident · No injuriesLimited investigationFinal reportCessna 172N · Canton, MIthe CFI delayed initiating a go-around during the landing. Factors associated with the accident were the student pilot's inadequate handling of the airplane, the crosswind condition, and the soft terrain on which the airplane touched down.NTSB CHI99LA349Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Detroit, MIthe pilot's failure to maintain control of the airplane which resulted in the inadvertent spin. A factor was the pilot snagged the banner pole.NTSB CHI97LA181Accident · No injuriesLimited investigationFinal reportCessna 172M · Grosse Ile, MIthe instructor pilot's inadequate planning/decision, resulting in an inadvertent stall situation.NTSB CHI96LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Grand Haven, MIfailure of the dual student to maintain directional control of the airplane during the landing, and inadequate supervision by the flight instructor.NTSB CHI95LA088Accident · No injuriesLimited investigationFinal reportCessna 172 · Holland, MIdelayed remedial action by the flight instructor. Factors in the accident were the student pilot not maintaining directional control once airborne.NTSB CHI94LA185Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lake City, MIThe pilot-in-command's inadequate compensation for wind conditions. Factors were the pilot-in-command's not using all available runway, premature lift off, and a crosswind.NTSB CHI93FA171Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Hubbardston, MIThe pilot's failure to maintain airspeed due to alcohol impairment while maneuvering at low altitude.NTSB CHI93LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Saline, MIThe pilot's failure to maintain aircraft control and airspeed.NTSB CHI88LA047Accident · No injuriesLimited investigationFinal reportCessna 172P · Jenison, MIThe low total time pilot took off in crosswind conditions for a proficiency flight and during a go around lost directional control and struck a snow bank along the downwind side of the runay.NTSB CHI86FA198Accident · 2 fatalField investigationFinal reportBellanca 7GCBC · Perrinton, MIThe pvt PIC and his pax, also a pvt plt, departed the pic's pvt airstrip for a local pleasure flt. An acft, similar in size and color to the plt's was seen doing low level flt at tree top level with abrupt pull-ups near where the plt normally flew. The plt…NTSB CHI84LA330Accident · No injuriesLimited investigationFinal reportDahlman BD4 · Grand Haven, MIThe pilot indicated that he observed the wind tee indicating a westerly wind but during landing flare/roll, a gusty wind from the south caused the acft to veer to the right. The acft veered off the runway and the left main gear separated.NTSB CHI84FA042Accident · 3 fatalField investigationFinal reportPiper PA-22-150 · Easton Township, MIThe acft crashed aprx 3 mi from the departure arpt. According to witnesses, it was flying at aprx 200 ft AGL when the right wing dipped & then the acft went nearly straight into the ground. An inspection of the airframe & flt control sys revealed no evidence…NTSB CHI83LA443Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Eaton Rapids, MIThe acft nose gear collapsed during a hard landing. The landing was on a 2600 ft turf strip. The pilot stated that afterthe acft bounced several times during landing the nose gear collapsed. The acft then slid into a post near the edge of the rwy.NTSB CHI83LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28-140E · Lake, MIThe pilot stated the wind shifted at about 50 ft AGL and the acft stopped climbing and mushed down and collided with a fence.NTSB DEN82FTA11Accident · 2 fatalFinal reportPiper PA-18 · Hardin, MIThe wreckage was found 3/4 mi west of the nw end of a farm rwy in the approximate position of where a right turn would occur from the downwind leg to the base leg of a right pattern to the se rwy. The wreckage showed evidence of a right rotational moment at…