NTSB investigations: Lycoming 0-540 series, 1983, AZ

4 cases on aircraft whose registry engine model is Lycoming 0-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
NTSB investigations: Lycoming 0-540 series, 1983, AZ per year, 1964–2026: 94 cases
19643
19654
19669
19674
19682
19693
19701
19714
19723
19741
19761
19772
19783
19794
19804
19811
19822
19834
19913
19921
19931
19953
19961
20012
20022
20032
20041
20051
20073
20083
20091
20101
20112
20121
20142
20151
20161
20191
20211
20231
20241
20252
20261

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\") = 1983
    AND c.\"eventStateOrRegion\" = 'AZ' 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 ('41532'))
  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 LAX84LA067Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Glendale, AZOn short final to a 2400 ft rwy the plt's father, who was in the rt ft seat and also a rated plt, asked 'you do realize this is a short rwy?' The son, who was the PIC, answered 'yes.' The acft touched down hard abt 1/3 of the way down the rwy, bounced up and…Nov 16, 1983 · N4772T · Substantial damageNTSB LAX84LA031Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · New River, AZThe tow pilot reported that during a takeoff tow with both acft still on the ground, he started to drift right as a gust of wind caught him. The glider pilot decided to release. The tow acft then went 100 yards off the rwy and collided with a parked glider.…Oct 24, 1983 · N4361Y · Substantial damageNTSB LAX83LA389Accident · Serious injuriesLimited investigationFinal reportPiper PA25-235 · Somerton, AZThe acft collided with the ground during a turn in turbulent air to abort an aerial application mission because of weather. The pilot stated that he had made two passes at the field he was spraying when he noticed the flagman and farmers waving him off due to…Aug 16, 1983 · N7104Z · DestroyedNTSB LAX83LA106Accident · No injuriesLimited investigationFinal reportCessna 182RG · Marble Canyon, AZDuring the landing the pilot lost control of the aircraft in a gusty wind. The aircraft left the runway and nosed over. In soft terrain. He blamed his slow reaction and inexperience for the accident. The wind was from 300 degrees at 11 KTS gusting to 18 KTS.Feb 19, 1983 · N1679R · Substantial damage