NTSB investigations: Lycoming I0360 series, 1999

5 cases on aircraft whose registry engine model is Lycoming I0360 series, where the first occurrence was “Hard landing”. 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

19822026
NTSB investigations: Lycoming I0360 series, 1999 per year, 1982–2026: 82 cases
19823
19834
19842
19851
19873
19903
19911
19925
19931
19941
19951
19962
19975
19983
19995
20004
20017
20029
20034
20048
20056
20061
20073

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\") = 1999
    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')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
  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 MIA00LA027Accident · No injuriesLimited investigationFinal reportCessna 172R · Daytona Beach, FLWas the pilot's improper flare and improper recovery from a bounced landing resulting in a hard landing and damage to the aircraft.Nov 20, 1999 · N475ER · Substantial damageNTSB FTW99LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Russellville, ARThe improper touchdown by the flight instructor.Aug 23, 1999 · N44KH · Substantial damageNTSB DEN00LA109Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Wheatland, WYThe flight instructor's failure to maintain control of the aircraft. Factors were inadequate supervision of the student by the flight instructor and inaccurate judgment by the flight instructor in not having the aircraft examined following the event.Aug 4, 1999 · N4789J · Substantial damageNTSB FTW99TA190Accident · Minor injuriesFinal reportHughes 269C · Houston, TXThe hard landing as a result of the flight instructor's failure to attain the proper airspeed before simulating an engine failure, which resulted in the development of a high sink rate. Factors were the night illumination and the soft ground.Jul 15, 1999 · N7491F · Substantial damageNTSB CHI99LA103Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIThe pilot's improper flare and failure to maintain directional control. Related factors were the snowbank and lack of total experience.Mar 10, 1999 · N983AV · Substantial damage