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

18 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, 1977, 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\") = 1977
    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 MIA78FKT18Accident · Serious injuriesClosedCessna 172 · Lantana, FLDec 4, 1977 · N3966Q · DestroyedNTSB MIA78FA017Accident · 1 fatalClosedPiper PA-28 · Lakeport, FLNov 29, 1977 · N5374W · DestroyedNTSB MIA78FLD09Accident · No injuriesClosedCessna 172 · Lake Wales, FLOct 30, 1977 · N4476R · Substantial damageNTSB MIA77DLD05Accident · No injuriesClosedCessna 172 · Brooksville, FLOct 22, 1977 · N734ZP · Substantial damageNTSB MIA78DLD02Accident · No injuriesClosedCessna 177M · Daytona Beach, FLOct 6, 1977 · N6864H · 2 aircraft · Substantial damageNTSB MIA77FA084Accident · 1 fatalClosedCessna 172 · Key West, FLSep 7, 1977 · N733QS · No damageNTSB MIA77FLD81Accident · No injuriesClosedPiper PA-28 · Crystal River, FLSep 5, 1977 · N9505W · Substantial damageNTSB MIA77DLD80Accident · No injuriesClosedPiper PA-18 · Zellwood, FLAug 31, 1977 · N9714P · Substantial damageNTSB MIA77DKT70Accident · No injuriesClosedCessna 172 · Key Largo, FLAug 21, 1977 · N12743 · Substantial damageNTSB MIA77FLD74Accident · No injuriesClosedCessna 172 · New Prt Richey, FLJul 2, 1977 · N733NF · Substantial damageNTSB MIA77DLD70Accident · No injuriesClosedPiper PA-28 · Daytona Beach, FLJun 23, 1977 · N32684 · Substantial damageNTSB MIA77FLA35Accident · No injuriesClosedBeech B19 · Molino, FLJun 5, 1977 · N6603R · Substantial damageNTSB MIA77FLD57Accident · No injuriesClosedPiper PA-18 · Lakeland, FLMay 15, 1977 · N7180B · Substantial damageNTSB MIA77FLA32Accident · No injuriesClosedCessna 177 · Panama City, FLMay 13, 1977 · N3453T · Substantial damageNTSB MIA77DLD46Accident · No injuriesClosedPiper PA-28 · Sarosota, FLApr 5, 1977 · N42230 · Substantial damageNTSB MIA77DKT57Accident · No injuriesClosedPiper PA18 · Pompano Beach, FLMar 31, 1977 · N6094D · DestroyedNTSB MIA77FLD36Accident · No injuriesClosedPiper PA-23 · Winter Park, FLMar 18, 1977 · N3112P · Substantial damageNTSB MIA77FLA17Accident · Serious injuriesClosedPiper PA-23 · Lake City, FLFeb 23, 1977 · N1370P · Substantial damage