NTSB investigations: Lycoming I0360 series, 2019, TX

6 cases on aircraft whose registry engine model is Lycoming I0360 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 I0360 series, 2019, TX per year, 1964–2026: 215 cases
19646
19654
19663
19679
19686
19694
19705
19712
19723
19736
19746
19754
19767
19777
19787
19792
19803
198110
19822
19835
19841
19856
19862
19874
19891
19904
19921
19941
19952
19962
19982
19992
20001
20012
20022
20036
20044
20053
20062
20075
20083
20091
20102
20116
20126
20134
20145
20151
20166
20183
20196
20204
20212
20223
20233
20244
20252

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\") = 2019
    AND c.\"eventStateOrRegion\" = 'TX' 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 ('41515'))
  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 CEN20LA051Accident · No injuriesClass 3 · LimitedFinal reportEnstrom F28 · Danbury, TXThe failure of the engine's No.3 intake valve resulting is a loss of engine power and a rollover following the autorotation to soft ground.Dec 31, 2019 · N57SJ · Substantial damageNTSB CEN20TA025Accident · No injuriesClass 3Final reportPiper PA34 · Mount Pleasant, TXThe pilot's hard, bounced landing and the flight instructor's delayed remedial action, which resulted in a fracture of the nose landing gear mounting structure.Nov 25, 2019 · N15412 · Substantial damageNTSB CEN20LA016Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Springtown, TXA total loss of engine power for undetermined reasons.Oct 13, 2019 · N75139 · Substantial damageNTSB CEN19LA302Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · La Grange, TXThe pilot's improper flare, which resulted in a hard landing.Sep 2, 2019 · N212BS · Substantial damageNTSB GAA19CA400Accident · Minor injuriesData collectionFinal reportBeech 95 · Navasota, TXThe airplane’s impact with a bird.Jun 29, 2019 · N998DM · Substantial damageNTSB CEN19LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Prairie, TXThe failure of the pilots of both airplanes to see and avoid the other airplane while entering the airport traffic pattern in visual meteorological conditions. Contributing to the accident was the tower controller's failure to recognize the proximity of the…Jan 29, 2019 · N565SP · 2 aircraft · Substantial damage