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

14 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, FL per year, 1964–2026: 824 cases
19647
19658
196617
196716
196816
196911
197015
197118
197213
19739
197415
197516
197611
197718
197816
197919
198021
198120
198217
198310
198415
198515
198615
198711
198811
198911
199010
199111
199216
199310
199413
199510
199611
199714
199812
199913
200018
200115
200212
200315
200419
200514
200613
20076
200816
200914
20106
201113
20129
201310
201411
201511
201613
20179
201819
201916
202010
202113
202211
20239
202410
202510
202611

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\" = 'FL' 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 ERA10LA101Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St. Petersburg, FLA loss of engine power for undetermined reasons.Dec 24, 2009 · N8634V · Substantial damageNTSB ERA10LA086Accident · 2 fatalLimited investigationFinal reportCox Busby Mustang · Plant City, FLThe pilot’s failure to maintain adequate airspeed following a loss of engine power for undetermined reasons.Nov 29, 2009 · N72PC · Substantial damageNTSB ERA10CA078Accident · No injuriesData collectionFinal reportCessna 172 · Panancea, FLThe pilot's failure to maintain directional control during the landing rollout.Nov 22, 2009 · N35638 · Substantial damageNTSB ERA10LA070Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Port Charlotte, FLA partial loss of engine power due to the separation of the spark plug hole helicoil from the bottom position of the No. 3 cylinder for undetermined reasons.Nov 20, 2009 · N41765 · Substantial damageNTSB ERA10FA052Accident · 1 fatalField investigationFinal reportAero Commander 100 · Weston, FLThe flight's descent for undetermined reasons, resulting in the in-flight collision with terrain.Nov 8, 2009 · N4139X · Substantial damageNTSB ERA09CA541Accident · No injuriesData collectionFinal reportCessna 172P · Pensacola, FLThe pilot's inability to maintain control during landing due to the separation of the nose landing gear upper scissor from the nose gear assembly. Contributing to the accident was the inadequate visual examination performed during the annual inspection.Sep 27, 2009 · N55437 · Substantial damageNTSB ERA09LA549Accident · No injuriesLimited investigationFinal reportCessna 172P · Pensacola, FLThe student pilot's improper flare, which resulted in a hard landing.Aug 20, 2009 · N64344 · Substantial damageNTSB ERA09LA360Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Del Ray Beach, FLAn in-flight failure of the main drive vee belts.Jun 21, 2009 · N2306T · Substantial damageNTSB ERA09LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Sarasota, FLA loss of engine power for undetermined reasons.May 30, 2009 · N12151 · Substantial damageNTSB ERA09LA229Accident · 1 fatalLimited investigationFinal reportGaynor Donald J RV6A · Englewood, FLThe pilot's operation of the airplane while impaired (alcohol) and his decision to attempt aerobatic maneuvers at a low altitude resulting in the loss of aircraft control and subsequent collision with trees.Apr 4, 2009 · N88WG · Substantial damageNTSB ERA09CA219Accident · Minor injuriesData collectionFinal reportParks Jerry R Lancair · Milton, FLThe pilot's failure to maintain aircraft control during landing.Mar 28, 2009 · N320J · Substantial damageNTSB ERA09LA201Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Sanford, FLAn engine air induction explosion for an undetermined reason during repeated engine start attempts.Mar 17, 2009 · N613FT · Substantial damageNTSB ERA11LA067Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe student pilot's inadequate crosswind landing technique and the certified flight instructor's delayed remedial action, which resulted in a hard landing.Feb 26, 2009 · N616FT · Substantial damageNTSB ERA09LA152Accident · 2 fatalLimited investigationFinal reportPiper PA-18 -150 · Tallahassee, FLThe pilot's decision to initiate takeoff in close proximity to other vehicles which were operating on the runway resulting in collision with a vehicle during takeoff.Feb 1, 2009 · N2424A · Substantial damage