Fatal NTSB investigations: Lycoming TI0-540 series, 1992

6 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, 1992 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\") = 1992
    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 DEN93FA012Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300T · Kersey, COInadvertent stall and loss of control due to structural icing. Factors were: icing conditions, and flight into known adverse weather.Nov 20, 1992 · N39683 · DestroyedNTSB FTW93FA033Accident · 2 fatalField investigationFinal reportBellanca 17-31ATC · Dublin, TXImproper IFR operation by the pilot by descending under instrument meteorological conditions below the minimum altitude and the pilot's failure to maintain control of the airplane while maneuvering for a landing. Factors which contributed to the accident…Nov 9, 1992 · N39883 · DestroyedNTSB LAX93FA004Accident · 3 fatalField investigationFinal reportBellanca 17-31ATC · Elko, NVThe failure of the pilot to obtain an adequate preflight weather brieifing and the pilot's decision to continue flight into forecast adverse weather conditions. Contributing to the accident was the prevailing icing, clouds, and rain weather conditions.Oct 3, 1992 · N33317 · DestroyedNTSB MIA92LA143Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · St. ThomasIn-flight fire for undetermined reasons, and in-flight collision with the water.Jun 28, 1992 · N59LD · DestroyedNTSB MIA92WA119Accident · 1 fatalForeign investigationPiper PA-32-300 · San Michele, HaitiApr 29, 1992 · N4026W · DestroyedNTSB BFO92FA032Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Sandston, VAThe pilot's improper in-flight planning/decision failure to follow the missed approach procedure.Mar 6, 1992 · N100LC · Destroyed