Fatal NTSB investigations: Lycoming TI0-540 series, 1980

16 cases on aircraft whose registry engine model is Lycoming TI0-540 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
Fatal NTSB investigations: Lycoming TI0-540 series, 1980 per year, 1964–2026: 467 cases
19641
19663
19685
19693
19701
19714
19726
19731
19741
19754
19765
19776
197814
197912
198016
198113
198215
198313
19849
19857
19869
198710
19886
19898
19902
19918
19926
19938
19948
19953
19967
19972
19986
19996
20006
200114
200217
200312
200416
200512
200613
20077
200811
200910
20109
20118
201214
20137
201412
201510
20165
20174
20187
20196
20207
20216
20227
20239
20241
20253
20266

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\") = 1980
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41533'))
  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 FTW81FA017Accident · 2 fatalClosedPiper PA-32R · Hagarville, ARDec 14, 1980 · N12ML · DestroyedNTSB MIA81FA024Accident · 2 fatalClosedPiper PA-23 · Fort Myers, FLDec 11, 1980 · N20MX · DestroyedNTSB MIA81FA019Accident · 2 fatalClosedPiper PA-23 · Jacksonville, FLNov 26, 1980 · N6575Y · DestroyedNTSB NYC81FAMS1Accident · 4 fatalClosedPiper PA-31 · Bridgeport, CTNov 10, 1980 · N62987 · DestroyedNTSB DEN81FA008Accident · 4 fatalClosedAero Cmdr 500B · Buffalo, WYOct 17, 1980 · N6395U · Substantial damageNTSB LAX80FVA03Accident · 2 fatalClosedPiper PA-32 · Merced, CAOct 2, 1980 · N21307 · DestroyedNTSB MIA80FA113Accident · 2 fatalClosedPiper PA-23 · Delray Beach, FLSep 28, 1980 · N14403 · DestroyedNTSB CHI80FA065Accident · 4 fatalClosedPiper PA-23 · East Tawas, MIAug 27, 1980 · N44EM · DestroyedNTSB MIA80FA090Accident · 2 fatalClosedPiper PA-31 · Dania, FLAug 10, 1980 · N27906 · DestroyedNTSB ATL80FA065Accident · 5 fatalClosedPiper PA-23 · Rockford, TNJul 3, 1980 · N6087Y · DestroyedNTSB SEA80FA036Accident · 4 fatalClosedPiper PA32RT · Granite, ORJun 26, 1980 · N39691 · DestroyedNTSB FTW80AA057Accident · 7 fatalClosedPiper PA-31 · Houston, TXMar 21, 1980 · N59932 · DestroyedNTSB NYC80FA028Accident · 2 fatalClosedPiper PA-24 · East Freedom, PAMar 17, 1980 · N9226P · DestroyedNTSB MIA80FA042Accident · 5 fatalClosedPiper PA-32R · Ocala, FLMar 6, 1980 · N2543Q · DestroyedNTSB LAX80FA058Accident · 2 fatalClosedBellanca 17-31A · Long Beach, CAFeb 25, 1980 · N8853V · DestroyedNTSB CHI80FA026Accident · 4 fatalClosedPiper PA-32 · Ft Wayne, INFeb 22, 1980 · N200BF · Destroyed