NTSB investigations: Lycoming 0-320 series, 2009, VA

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, 2009, VA per year, 1964–2026: 249 cases
19645
19657
19667
19676
196810
19699
19705
19715
19726
197310
19744
19753
19768
19778
19784
19794
19806
19812
19824
19834
19846
19852
19865
19873
19882
19894
19901
19913
19922
19933
19943
19954
19962
19972
19981
19991
20004
20015
20028
20034
20041
20053
20078
20081
20096
20103
20111
20123
20133
20142
20154
20162
20175
20183
20194
20201
20213
20225
20233
20242
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\") = 2009
    AND c.\"eventStateOrRegion\" = 'VA' 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 ERA10LA055Accident · No injuriesLimited investigationFinal reportCessna 172 · Luray, VAThe pilot's premature rotation and liftoff and her subsequent failure to recognize and correct for the influence of ground effect on the airplane's takeoff performance.Nov 8, 2009 · N738CD · Substantial damageNTSB ERA10CA017Accident · Serious injuriesData collectionFinal reportPiper PA28 · Lebanon, VAThe pilot’s decision to continue flight under visual flight rules into known deteriorating weather conditions, which resulted in controlled flight into terrain.Oct 10, 2009 · N43620 · Substantial damageNTSB ERA09LA517Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Hillsville, VAThe total loss of engine power for an undetermined reason.Sep 13, 2009 · N734TV · Substantial damageNTSB ERA09LA456Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Winchester, VAThe pilot's inadequate preflight inspection and failure to ensure an adequate quantity of fuel was available for the flight.Aug 7, 2009 · N20977 · Substantial damageNTSB ERA09CA430Accident · No injuriesData collectionFinal reportCessna 172N · Manassas, VAThe student pilot’s failure to maintain directional control during takeoff.Jul 30, 2009 · N733BS · Substantial damageNTSB ERA09CA205Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Richmond, VAA loss of engine power due to the pilot inadvertently shutting down the engine.Mar 22, 2009 · N2360M · Substantial damage