Skip to content

NTSB investigations: Lycoming I0360 series, AR

33 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

Latest cases

Query with SQL

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 c."eventStateOrRegion" = 'AR' 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

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 c.\"eventStateOrRegion\" = 'AR' 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.

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 c."eventStateOrRegion" = 'AR' 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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB CEN16LA200Accident · No injuriesLimited investigationFinal reportMooney M20 · Little Rock, ARA loss of engine power due to water contamination of the fuel.May 13, 2016 · N6371Q · Substantial damage NTSB CEN15LA270Accident · No injuriesLimited investigationFinal reportPiper PA28-200 · Jonesboro, ARMaintenance personnel's improper engine oil drain valve installation, which led to engine oil exhaustion and the subsequent loss of engine power after takeoff at an altitude too low for the pilot to execute a forced landing in a suitable area.Jun 10, 2015 · N872CS · Substantial damage NTSB CEN13LA095Accident · No injuriesLimited investigationFinal reportMooney M20E · Gurdon, ARThe total loss of engine power for reasons that could not be determined because no mechanical engine malfunctions were identified and because the actual fuel load and distribution at the time of the accident could not be determined.Dec 5, 2012 · N9493V · Substantial damage NTSB CEN12FA463Accident · Minor injuriesField investigationFinal reportMooney M20E · Marked Tree, ARThe loss of engine power during cruise flight due to a malfunction of the fuel injection servo due to a damaged O-ring.Jul 21, 2012 · N1310W · Substantial damage NTSB DEN08FA122Accident · 2 fatalField investigationFinal reportHughes 269B · Salesville, ARThe pilot's failure to maintain clearance from the crossing transmission line.Jul 15, 2008 · N469E · Destroyed NTSB FTW04LA071Accident · No injuriesLimited investigationFinal reportBeech BE-23 · Mena, ARThe loss of engine power for undetermined reasons and the pilot's misjudgment of altitude and distance during the forced landing which resulted in a collision with trees and transmission wires.Feb 8, 2004 · N234DD · Substantial damage NTSB FTW02LA253Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Rector, ARThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.Sep 7, 2002 · N6369Q · Substantial damage NTSB FTW99LA234Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Russellville, ARThe improper touchdown by the flight instructor.Aug 23, 1999 · N44KH · Substantial damage NTSB FTW99LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Heber Springs, ARThe pilot's excessive approach airspeed resulting in the airplane overrunning the runway, and his failure to maintain aircraft control during the landing roll.Jul 26, 1999 · N7605J · Substantial damage NTSB MKC88LA022Accident · No injuriesLimited investigationFinal reportMooney M20J · Springdale, ARDrg a wx briefing bfr tkof, the plt was adzd that VFR flt was not rcmdd due to low ceiling & icing conds. He was adzd the freezing lvl was forecast to be at 4000' over little rock & to slope down to the surface in se Missouri. Also, he was briefed on pireps…Nov 28, 1987 · N201CQ · Substantial damage NTSB MKC87LA102Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Fayetteville, ARThe PIC was demonstrating the helo to a prospective customer. The PIC was hovering in a remote area with rough and uneven terrain. The PIC rptd outside air temps of abt 90 degrees during the demo flt. The PIC stated that he was moving around over the grnd in…May 7, 1987 · N13CM · Substantial damage NTSB MKC86LA015Accident · Minor injuriesLimited investigationFinal reportMooney MK21 · Warren, ARAt cruise level flt the plt rptd a malfunctioning engine. The plt was cleared to descend to an airport in the vicinity. The precautionary landing was initiated due to an oil pressure decline. Approaching for the landing the plt rptd the engine completely quit…Oct 25, 1985 · N3399X · Substantial damage NTSB FTW81DPG08Accident · No injuriesClosedPiper PA-28R · Mountain Home, ARNov 28, 1980 · N43496 · Substantial damage NTSB FTW80DA119Accident · No injuriesClosedPiper PA-28R · Mountain View, ARSep 20, 1980 · N32820 · Substantial damage NTSB FTW79DPG39Accident · No injuriesClosedPiper PA-28R · Stuttgart, ARMay 13, 1979 · N4932J · Substantial damage NTSB FTW77FPG01Accident · No injuriesClosedPiper PA-34 · Little Rock, AROct 4, 1977 · N41192 · Substantial damage NTSB FTW77DPG45Accident · No injuriesClosedPiper PA-28R · Manila, ARJun 10, 1977 · N5057S · Substantial damage NTSB FTW77DPG32Accident · No injuriesClosedGreat Lakes 2T-1A · Searcy, ARMay 8, 1977 · N6094L · Substantial damage NTSB FTW77DPG10Accident · No injuriesClosedPiper PA-28R · Dermott, ARNov 30, 1976 · N55830 · Substantial damage NTSB FTW77DPG04Accident · No injuriesClosedGreat Lakes 2T-1A · Van Buren, AROct 26, 1976 · N101GL · Substantial damage NTSB FTW76DPG83Accident · No injuriesClosedPiper PA-28 · Ft.Smith, ARJul 17, 1976 · N7463J · Substantial damage NTSB FTW75DPG39Accident · No injuriesClosedMooney M20E · West Memphis, ARMar 22, 1975 · N1246X · Substantial damage NTSB FTW75DPG15Accident · No injuriesClosedLake LA-4 · Redfield, ARAug 22, 1974 · N5020L · Substantial damage NTSB FTW73FPG39Accident · Serious injuriesClosedPiper PA-28R · Black Fork, ARMar 1, 1973 · N4974T · Destroyed NTSB FTW73FPG37Accident · No injuriesClosedMooney M20C · N.Little Rock, ARJan 27, 1973 · N2795W · Substantial damage NTSB FTW71FPG35Accident · No injuriesClosedMooney M20E · Little Rock, ARJan 31, 1971 · N9302M · Substantial damage NTSB FTW71FPG31Accident · No injuriesClosedBeech A23-24 · Arkadelphia, ARDec 24, 1970 · N6922Q · Substantial damage NTSB FTW68A0060Accident · Serious injuriesClosedHughes 300 · Fayetteville, ARDec 9, 1967 · N9335F · Destroyed NTSB FTW68D0266Accident · No injuriesClosedBeech A23 · Pine Bluff, AROct 1, 1967 · N4740J · Substantial damage NTSB FTW67D0509Accident · Minor injuriesClosedMooney M20E · West Memphis, ARMar 25, 1967 · N79853 · Substantial damage NTSB FTW67D0405Accident · No injuriesClosedMooney M20F · Mena, ARJan 10, 1967 · N9507M · Substantial damage NTSB FTW67A0001Accident · No injuriesClosedHughes 269B · Little Rock, ARJul 1, 1966 · N9303F · Substantial damage NTSB FTW66F0372Accident · No injuriesClosedMooney M20E · Newport, AROct 31, 1965 · N1242X · Substantial damage