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

7 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, PA per year, 1964–2026: 377 cases
19649
196514
196612
196717
19689
196914
197013
197114
19727
19739
197411
197512
197614
197711
197815
19798
19808
19816
19829
19838
19847
19854
19865
198710
19886
19895
19903
19918
19925
19935
19945
19956
19961
19975
19985
19992
20002
20013
20024
20047
20053
20063
20076
20084
20097
20102
20112
20124
20133
20141
20154
20164
20174
20182
20192
20202
20224
20241
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\" = 'PA' 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 ERA10CA016Accident · Minor injuriesData collectionFinal reportPiper PA28 · Meadville, PAA loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.Oct 13, 2009 · N8886E · Substantial damageNTSB ERA09CA539Accident · Minor injuriesData collectionFinal reportCessna 172 · Factoryville, PAThe flight instructor's delayed decision to take control of the airplane and execute a missed approach. Contributing to the accident was the lack of communication between the certificated flight instructor and the pilot receiving instruction.Sep 27, 2009 · N5123E · Substantial damageNTSB ERA09CA493Accident · No injuriesData collectionFinal reportBeech B19 · Thomasville, PAA partial loss of engine power due to a partial blockage of the carburetor fuel inlet filter.Aug 30, 2009 · N6982R · Substantial damageNTSB ERA09CA425Accident · Minor injuriesData collectionFinal reportCessna 177 · Towanda, PAThe failure of the pilot to maintain control of the airplane during a go around following a bounced landing.Jul 27, 2009 · N2980X · Substantial damageNTSB ERA09CA301Accident · No injuriesData collectionFinal reportCessna 172N · Tunkhannock, PAThe pilot's failure to attain the proper touchdown point while landing with a tailwind.May 21, 2009 · N9492E · Substantial damageNTSB ERA09CA287Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Danville, PAThe student pilot's failure to maintain control during a landing.May 11, 2009 · N8403R · Minor damageNTSB ERA09LA124Accident · 1 fatalLimited investigationFinal reportPiper PA-28-160 · Indiana, PAThe pilot's decision to attempt VFR flight in IMC conditions, resulting in a collision with trees during a go-around.Jan 4, 2009 · N5212W · Substantial damage