NTSB investigations: Lycoming 0-320 series, MI
13 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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
| 1983 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 3 |
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 ('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\" = 353))
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" = 353))
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 CHI96LA030Accident · No injuriesLimited investigationFinal reportCessna 172N · Niles, MIfuel exhaustion as a result of the pilot's improper fuel consumption calculations. Factors related to the accident were: the pilot's lack of familiarity with the aircraft and operating with a known malfunctioning fuel gauge.NTSB CHI95LA303Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Saint James, MIthe pilot's operation of the airplane with an inoperative fuel gage and the leaking fuel line fitting, which resulted in fuel exhaustion, loss of engine power, and a forced landing. The inoperative fuel gage was a related factor.NTSB CHI95LA297Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Clarkston, MIthe pilot's failure to refuel.NTSB CHI94LA205Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Lambertville, MIThe inadequate maintenance of the airplane resulting in a foreign object in the induction system.NTSB CHI94LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Allendale, MIImproper in-flight planning/decision by the pilot, after encountering unfavorable winds and a low fuel level, which resulted in fuel exhaustion. The unfavorable wind was a related factor.NTSB CHI91DEM05Accident · Serious injuriesFinal reportGildersleeve RV-4 · Ionia, MIRemedial action not performed by the pilot and the pilot's failure to assure the fuel selector was on the proper tank.NTSB CHI91LA146Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Ann Arbor, MILoss of engine power due to carburetor ice, and the pilot's failure to use carburetor heat. Factors related to the accident were: carburetor icing conditions, and a false indication from the carburetor air temperature gage.NTSB CHI90LA126Accident · No injuriesLimited investigationFinal reportPiper PA28-140 · Bad Axe, MITotal failure of the powerplant during the final approach for undetermined reasons.NTSB CHI89LA149Accident · No injuriesLimited investigationFinal reportCessna 172M · Wixom, MICarburetor ice due to the pilot's improper use of carburetor heat. Factors related to the accident were: weather conditions conducive to carburetor ice, dark night, and tree(s) in the emergency landing area.NTSB CHI86LA178Accident · No injuriesLimited investigationFinal reportCessna 172N · West Branch, MIThe student pilot's CFI had advised him to refuel at an en route arpt on the x-county solo flt because there was no fuel avail at departure arpt. The student did not dip thetanks but stated 'based on my calculations of fuel burn there should have been enough…NTSB CHI85LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Troy, MIThe acft collided with a sign during a forced lndg after a loss of power that occurd during initial climb at an alt of 400 ft AGL. The plt stated that the eng began to run rough and with the application of carb heat the eng quit. A post accident eng run-up…NTSB CHI84LA295Accident · No injuriesLimited investigationFinal reportCessna 172M · Southgate, MIAfter takeoff, the plt climbed to 8500 ft MSL to practice maneuvers. He then made a descent to 4500 ft & began heading back to the arpt, then continued descending to 1800 ft & entered the tca. The eng lost power aprx 7 miles from the airport. Later, during an…NTSB CHI83LA104Accident · Minor injuriesLimited investigationFinal reportPiper PA22-150 · Napoleon, MIThe aircraft lost power during climb after takeoff. The pilot made a forced landing in an open field. He stated that contamentation was the cause of the power loss.