Final NTSB investigations: Lycoming TI0-540 series, 1974

62 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
Final NTSB investigations: Lycoming TI0-540 series, 1974 per year, 1964–2026: 2,178 cases
19649
196527
196632
196749
196848
196947
197048
197163
197245
197351
197462
197546
197652
197758
197868
197965
198057
198155
198247
198340
198446
198543
198643
198735
198830
198932
199013
199129
199227
199324
199422
199527
199628
199723
199819
199925
200035
200141
200245
200336
200441
200541
200648
200731
200830
200928
201031
201123
201230
201326
201425
201529
201621
201721
201819
201920
202028
202115
202222
202327
202414
202511
20265

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\") = 1974
    AND c.\"completionStatus\" = 'Completed'
    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 CHI75DEA13Accident · No injuriesClosedPiper PA-24 · Kokomo, INDec 6, 1974 · N9166P · Substantial damageNTSB NYC75AN062Accident · No injuriesClosedPiper PA-23 · Philadelphia, PANov 15, 1974 · N40254 · Substantial damageNTSB MIA75OKT29Accident · Serious injuriesClosedPiper PA-32 · Cay Verde, Burkina FasoNov 15, 1974 · N56481 · Substantial damageNTSB FTW75FQG28Accident · No injuriesClosedPiper PA-24 · Lubbock, TXNov 1, 1974 · N9366P · Substantial damageNTSB NYC75FHA20Accident · No injuriesClosedPiper PA-24 · Reading, PAOct 29, 1974 · N9056P · Substantial damageNTSB MIA75DKT24Accident · No injuriesClosedPiper PA-32 · Lantana, FLOct 28, 1974 · N4360T · Substantial damageNTSB DEN75DQA18Accident · No injuriesClosedPiper PA-24 · Arrey, NMOct 27, 1974 · N9236P · Substantial damageNTSB MKC75DCG18Accident · No injuriesClosedPiper PA-32 · Boonville, MOOct 24, 1974 · N56994 · Substantial damageNTSB FTW75DPA13Accident · Minor injuriesClosedPiper PA-32 · Bruceville, TXOct 22, 1974 · N94JC · Substantial damageNTSB LAX75AL019Accident · 4 fatalClosedPiper PA-23 · Long Beach, CAOct 18, 1974 · N501EE · DestroyedNTSB NYC75AN043Accident · Minor injuriesClosedPiper PA-31 · Shartlesville, PAOct 7, 1974 · N61454 · Substantial damageNTSB MKC75FER24Accident · No injuriesClosedPiper PA-23 · Hibbing, MNSep 24, 1974 · N14223 · Substantial damageNTSB MKC75DER23Accident · No injuriesClosedPiper PA-24 · Fairmont, MNSep 19, 1974 · N11CG · Substantial damageNTSB ANC75DAG44Accident · No injuriesClosedCessna 185 · Birchwood, AKSep 19, 1974 · N70394 · Substantial damageNTSB MIA75DKG23Accident · Minor injuriesClosedAero Comdr A-9B · Whigham, GAAug 23, 1974 · N7728V · Substantial damageNTSB MIA75FKJ13Accident · No injuriesClosedPiper PA-23 · Birmingham, ALAug 17, 1974 · N6380Y · Substantial damageNTSB MKC75FCD08Accident · No injuriesClosedCallair A-9B · Harcourt, IAAug 15, 1974 · N7765V · DestroyedNTSB LAX75OL002Accident · No injuriesClosedPiper PA-23 · Tsuniah Lake, CanadaAug 13, 1974 · N54099 · Substantial damageNTSB CHI75FEV02Accident · No injuriesClosedPiper PA-24 · Quincy, ILAug 9, 1974 · N9291P · Substantial damageNTSB FTW75DRD04Accident · Minor injuriesClosedPiper PA-24 · Donaldsonville, LAAug 4, 1974 · N8573P · Substantial damageNTSB CHI75FEI06Accident · No injuriesClosedPiper PA-32 · Toledo, OHAug 4, 1974 · N15267 · Substantial damageNTSB NYC75FHA05Accident · No injuriesClosedPiper PA-32 · Honesdale, PAJul 31, 1974 · N8967N · Substantial damageNTSB FTW75FQG12Accident · No injuriesClosedPiper PA-23 · Dalhart, TXJul 28, 1974 · N411PC · Substantial damageNTSB NYC75FGM02Accident · No injuriesClosedPiper PA-32 · Sheffield, PAJul 27, 1974 · N8958N · Substantial damageNTSB NYC74AN015Accident · No injuriesClosedPiper PA-32 · Emporium, PAJul 27, 1974 · N4206R · Substantial damageNTSB IAD75FID01Accident · No injuriesClosedCallair A-9B · Temperancevl, VAJul 18, 1974 · N7791V · Substantial damageNTSB MKC75DCJ04Accident · No injuriesClosedPiper PA-24 · Sidney, NEJul 8, 1974 · N9222P · Substantial damageNTSB MIA75FLD05Accident · Serious injuriesClosedPiper PA-24 · Orlando, FLJul 5, 1974 · N9397P · Substantial damageNTSB MKC75FER01Accident · No injuriesClosedPiper PA-24 · Rockford, MNJul 4, 1974 · N9137P · Substantial damageNTSB LAX75OL010Accident · No injuriesClosedPiper PA-32 · San Quinton, MexicoJul 4, 1974 · N4254R · Substantial damageNTSB CHI75FEC02Accident · No injuriesClosedPiper PA-31 · Marine City, MIJul 1, 1974 · N2WM · Substantial damageNTSB FTW74DPG80Accident · No injuriesClosedAero Comdr A-9B · Grady, ARJun 28, 1974 · N7774V · Substantial damageNTSB NYC74FHD43Accident · No injuriesClosedPiper PA-24 · Cape May, NJJun 21, 1974 · N9339P · Substantial damageNTSB LAX74DUJ71Accident · No injuriesClosedPiper PA-32 · Page, AZJun 15, 1974 · N4296R · Substantial damageNTSB NYC74IN107Incident · No injuriesClosedPiper PA-23 · Batavia, NYJun 11, 1974 · N5708Y · Minor damageNTSB NYC74FNA42Accident · No injuriesClosedPiper PA-24 · Newburyport, MAJun 8, 1974 · N892RC · Substantial damageNTSB MKC74DER54Accident · No injuriesClosedBellanca 17-31 · New Germany, MNJun 6, 1974 · N170EE · Substantial damageNTSB MIA74DLG29Accident · No injuriesClosedCallair A-9B · Allendale, SCMay 30, 1974 · N7655V · Substantial damageNTSB MKC74DER49Accident · No injuriesClosedPiper PA-24 · Fairmont, MNMay 17, 1974 · N11CG · Substantial damageNTSB IAD74FLQ32Accident · No injuriesClosedPiper PA-24 · Hopkinsville, KYMay 14, 1974 · N8814P · Substantial damageNTSB LAX74DUM31Accident · No injuriesClosedPiper PA-24 · Calexico, CAMay 13, 1974 · N9436P · Substantial damageNTSB OAK74AP058Accident · No injuriesClosedPiper PA-24 · Jackson, CAMay 8, 1974 · N9435P · Substantial damageNTSB MIA74DKJ54Accident · No injuriesClosedBellanca 17-31A · Huntsville, ALMay 7, 1974 · N6585V · Substantial damageNTSB MKC74FCD31Accident · No injuriesClosedBellanca 17-30A · Red Oak, IAMay 5, 1974 · N8262R · 2 aircraft · Substantial damageNTSB NYC74FGT19Accident · No injuriesClosedPiper PA-32 · Lock Haven, PAApr 28, 1974 · N1428S · Substantial damageNTSB MIA74FKG69Accident · No injuriesClosedPiper PA-24 · Macon, GAApr 6, 1974 · N8973P · Substantial damageNTSB FTW74FPA20Accident · No injuriesClosedPiper PA-31 · Dallas, TXMar 30, 1974 · N6754L · Minor damageNTSB NYC74AN079Accident · No injuriesClosedDehavilland DH114 · Philadelphia, PAMar 26, 1974 · N782R · Substantial damageNTSB FTW74FPA18Accident · Minor injuriesClosedPiper PA-23 · Farmersville, TXMar 20, 1974 · N50CC · Substantial damageNTSB NYC74AN081Accident · No injuriesClosedPiper PA-31 · Providence, RIMar 15, 1974 · N9057Y · Substantial damage