NTSB investigations: Lycoming 0-320 series, 2007, MI

6 cases on aircraft whose registry engine model is Lycoming 0-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

19642026
NTSB investigations: Lycoming 0-320 series, 2007, MI per year, 1964–2026: 393 cases
19648
196511
196611
196715
196815
196914
197010
19719
197213
19738
197412
19757
197615
197710
19788
19799
19808
19818
198210
198316
19846
19855
19868
19875
19887
19892
19904
19919
19927
19937
19946
19957
19963
19975
19983
19995
20005
20018
20022
20035
20045
20053
20066
20076
20081
20105
20111
20124
20134
20142
20154
20162
20173
20185
20192
20204
20211
20223
20231
20241
20253
20261

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 year(c.\"eventDate\") = 2007
    AND 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'))
  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.

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.Nov 3, 2007 · N8353L · Substantial damageNTSB CHI07CA294Accident · No injuriesData collectionFinal reportCessna 172M · Pontiac, MIThe pilot's misjudgment of the landing flare and her improper recovery from the bounced landing.Sep 5, 2007 · N73455 · Substantial damageNTSB CHI07LA266Accident · No injuriesLimited investigationFinal reportCessna 172M · Marine City, MIA loss of engine power for undetermined reasons. Factors contributing to the accident were the insufficient runway remaining and the soft terrain.Aug 11, 2007 · N13586 · Substantial damageNTSB CHI07CA245Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe student pilot's improper flare, which resulted in a hard landing. An additional cause was the pilot's inadequate recovery from a bounced landing. Factors in the accident include the pilot's failure to maintain directional control during the landing roll…Jul 29, 2007 · N222UN · Substantial damageNTSB CHI07CA118Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Williamston, MIThe pilot's improper recovery from a bounced landing which resulted in the collapse of the nose landing gear. The hilly runway was a contributing factor.Apr 21, 2007 · N5528F · Substantial damageNTSB CHI07CA076Accident · No injuriesData collectionFinal reportCessna 172N · Holland, MIThe student pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during the takeoff, which caused the airplane to impact the snow bank and nose over. Contributing factors were the crosswind and the snow…Feb 23, 2007 · N5321D · Substantial damage